нпц баффер

CREATE TABLE IF NOT EXISTS `npc_buffer` (
`npc_id` int(6) NOT NULL,
`skill_id` int(6) NOT NULL,
`skill_level` int(6) NOT NULL default '1',
`skill_fee_id` int(6) NOT NULL default '0',
`skill_fee_amount` int(6) NOT NULL default '0',
`buff_group` int(6) NOT NULL default '0',
PRIMARY KEY (`npc_id`,`skill_id`,`buff_group`)
);

INSERT IGNORE INTO `npc_buffer` VALUES
(36402,4356,3,0,0,4356),
(36402,4352,2,0,0,4352),
(36402,4345,3,0,0,4345),
(36402,4359,3,0,0,4359),
(36402,4351,6,0,0,4351),
(36402,4355,3,0,0,4355),
(36402,4357,2,0,0,4357),
(36402,4342,2,0,0,4342),
(36402,4358,3,0,0,4358),
(36402,4360,3,0,0,4360),

-- Custom NPC Buffer (TODO: This should be moved to custom tables)
(1000003,264,1,0,0,264),
(1000003,265,1,0,0,265),
(1000003,266,1,0,0,266),
(1000003,267,1,0,0,267),
(1000003,268,1,0,0,268),
(1000003,269,1,0,0,269),
(1000003,270,1,0,0,270),
(1000003,271,1,0,0,271),
(1000003,272,1,0,0,272),
(1000003,273,1,0,0,273),
(1000003,274,1,0,0,274),
(1000003,275,1,0,0,275),
(1000003,276,1,0,0,276),
(1000003,277,1,0,0,277),
(1000003,304,1,0,0,304),
(1000003,305,1,0,0,305),
(1000003,306,1,0,0,306),
(1000003,307,1,0,0,307),
(1000003,308,1,0,0,308),
(1000003,309,1,0,0,309),
(1000003,310,1,0,0,310),
(1000003,311,1,0,0,311),
(1000003,349,1,0,0,349),
(1000003,363,1,0,0,363),
(1000003,364,1,0,0,364),
(1000003,365,1,0,0,365),
(1000003,366,1,0,0,366),
(1000003,367,1,0,0,367),
(1000003,482,2,0,0,482),
(1000003,529,1,0,0,529),
(1000003,530,1,0,0,530),
(1000003,825,1,0,0,825),
(1000003,826,1,0,0,826),
(1000003,827,1,0,0,827),
(1000003,828,1,0,0,828),
(1000003,829,1,0,0,829),
(1000003,830,1,0,0,830),
(1000003,1002,3,0,0,1002),
(1000003,1003,3,0,0,1003),
(1000003,1004,3,0,0,1004),
(1000003,1005,3,0,0,1005),
(1000003,1006,3,0,0,1006),
(1000003,1007,3,0,0,1007),
(1000003,1008,3,0,0,1008),
(1000003,1009,3,0,0,1009),
(1000003,1010,3,0,0,1010),
(1000003,1032,3,0,0,1032),
(1000003,1033,3,0,0,1033),
(1000003,1035,4,0,0,1035),
(1000003,1036,2,0,0,1036),
(1000003,1040,3,0,0,1040),
(1000003,1043,1,0,0,1043),
(1000003,1044,3,0,0,1044),
(1000003,1045,6,0,0,1045),
(1000003,1048,6,0,0,1048),
(1000003,1059,3,0,0,1059),
(1000003,1062,2,0,0,1062),
(1000003,1068,3,0,0,1068),
(1000003,1073,2,0,0,1073),
(1000003,1077,3,0,0,1077),
(1000003,1078,6,0,0,1078),
(1000003,1085,3,0,0,1085),
(1000003,1086,2,0,0,1086),
(1000003,1087,3,0,0,1087),
(1000003,1182,3,0,0,1182),
(1000003,1189,3,0,0,1189),
(1000003,1191,3,0,0,1191),
(1000003,1204,2,0,0,1204),
(1000003,1240,3,0,0,1240),
(1000003,1242,3,0,0,1242),
(1000003,1243,3,0,0,1243),
(1000003,1249,3,0,0,1249),
(1000003,1250,3,0,0,1250),
(1000003,1251,2,0,0,1251),
(1000003,1252,3,0,0,1252),
(1000003,1253,3,0,0,1253),
(1000003,1257,3,0,0,1257),
(1000003,1259,4,0,0,1259),
(1000003,1260,3,0,0,1260),
(1000003,1261,2,0,0,1261),
(1000003,1268,4,0,0,1268),
(1000003,1282,2,0,0,1282),
(1000003,1284,3,0,0,1284),
(1000003,1303,2,0,0,1303),
(1000003,1304,3,0,0,1304),
(1000003,1307,3,0,0,1307),
(1000003,1308,3,0,0,1308),
(1000003,1309,3,0,0,1309),
(1000003,1310,4,0,0,1310),
(1000003,1323,1,0,0,1323),
(1000003,1352,1,0,0,1352),
(1000003,1353,1,0,0,1353),
(1000003,1354,1,0,0,1354),
(1000003,1355,1,0,0,1355),
(1000003,1356,1,0,0,1356),
(1000003,1357,1,0,0,1357),
(1000003,1362,1,0,0,1362),
(1000003,1363,1,0,0,1363),
(1000003,1364,1,0,0,1364),
(1000003,1365,1,0,0,1365),
(1000003,1388,3,0,0,1388),
(1000003,1389,3,0,0,1389),
(1000003,1390,3,0,0,1390),
(1000003,1391,3,0,0,1391),
(1000003,1392,3,0,0,1392),
(1000003,1393,3,0,0,1393),
(1000003,1397,3,0,0,1397),
(1000003,1413,1,0,0,1413),
(1000003,1414,1,0,0,1414),
(1000003,1415,1,0,0,1415),
(1000003,1416,1,0,0,1416),
(1000003,1460,1,0,0,1460),
(1000003,1461,1,0,0,1461),
(1000003,1476,3,0,0,1476),
(1000003,1477,3,0,0,1477),
(1000003,1478,2,0,0,1478),
(1000003,1479,3,0,0,1479),
(1000003,1499,1,0,0,1499),
(1000003,1500,1,0,0,1500),
(1000003,1501,1,0,0,1501),
(1000003,1502,1,0,0,1502),
(1000003,1503,1,0,0,1503),
(1000003,1504,1,0,0,1504),
(1000003,1519,1,0,0,1519),
(1000003,4552,4,0,0,4552),
(1000003,4553,4,0,0,4553),
(1000003,4554,4,0,0,4554),
(1000003,4699,13,0,0,4699),
(1000003,4700,13,0,0,4700),
(1000003,4702,13,0,0,4702),
(1000003,4703,13,0,0,4703),
(1000003,21046,1,0,0,21046);

bulazzz пишет:Всем привет. В рев. 681 неполучается соспавнить нпц баффера, пишет "цель не найдена". ид ввожу 1000003
вот что в sql файле

CREATE TABLE IF NOT EXISTS `npc_buffer` (
`npc_id` int(6) NOT NULL,
`skill_id` int(6) NOT NULL,
`skill_level` int(6) NOT NULL default '1',
`skill_fee_id` int(6) NOT NULL default '0',
`skill_fee_amount` int(6) NOT NULL default '0',
`buff_group` int(6) NOT NULL default '0',
PRIMARY KEY (`npc_id`,`skill_id`,`buff_group`)
);

INSERT IGNORE INTO `npc_buffer` VALUES
(36402,4356,3,0,0,4356),
(36402,4352,2,0,0,4352),
(36402,4345,3,0,0,4345),
(36402,4359,3,0,0,4359),
(36402,4351,6,0,0,4351),
(36402,4355,3,0,0,4355),
(36402,4357,2,0,0,4357),
(36402,4342,2,0,0,4342),
(36402,4358,3,0,0,4358),
(36402,4360,3,0,0,4360),

-- Custom NPC Buffer (TODO: This should be moved to custom tables)
(1000003,264,1,0,0,264),
(1000003,265,1,0,0,265),
(1000003,266,1,0,0,266),
(1000003,267,1,0,0,267),
(1000003,268,1,0,0,268),
(1000003,269,1,0,0,269),
(1000003,270,1,0,0,270),
(1000003,271,1,0,0,271),
(1000003,272,1,0,0,272),
(1000003,273,1,0,0,273),
(1000003,274,1,0,0,274),
(1000003,275,1,0,0,275),
(1000003,276,1,0,0,276),
(1000003,277,1,0,0,277),
(1000003,304,1,0,0,304),
(1000003,305,1,0,0,305),
(1000003,306,1,0,0,306),
(1000003,307,1,0,0,307),
(1000003,308,1,0,0,308),
(1000003,309,1,0,0,309),
(1000003,310,1,0,0,310),
(1000003,311,1,0,0,311),
(1000003,349,1,0,0,349),
(1000003,363,1,0,0,363),
(1000003,364,1,0,0,364),
(1000003,365,1,0,0,365),
(1000003,366,1,0,0,366),
(1000003,367,1,0,0,367),
(1000003,482,2,0,0,482),
(1000003,529,1,0,0,529),
(1000003,530,1,0,0,530),
(1000003,825,1,0,0,825),
(1000003,826,1,0,0,826),
(1000003,827,1,0,0,827),
(1000003,828,1,0,0,828),
(1000003,829,1,0,0,829),
(1000003,830,1,0,0,830),
(1000003,1002,3,0,0,1002),
(1000003,1003,3,0,0,1003),
(1000003,1004,3,0,0,1004),
(1000003,1005,3,0,0,1005),
(1000003,1006,3,0,0,1006),
(1000003,1007,3,0,0,1007),
(1000003,1008,3,0,0,1008),
(1000003,1009,3,0,0,1009),
(1000003,1010,3,0,0,1010),
(1000003,1032,3,0,0,1032),
(1000003,1033,3,0,0,1033),
(1000003,1035,4,0,0,1035),
(1000003,1036,2,0,0,1036),
(1000003,1040,3,0,0,1040),
(1000003,1043,1,0,0,1043),
(1000003,1044,3,0,0,1044),
(1000003,1045,6,0,0,1045),
(1000003,1048,6,0,0,1048),
(1000003,1059,3,0,0,1059),
(1000003,1062,2,0,0,1062),
(1000003,1068,3,0,0,1068),
(1000003,1073,2,0,0,1073),
(1000003,1077,3,0,0,1077),
(1000003,1078,6,0,0,1078),
(1000003,1085,3,0,0,1085),
(1000003,1086,2,0,0,1086),
(1000003,1087,3,0,0,1087),
(1000003,1182,3,0,0,1182),
(1000003,1189,3,0,0,1189),
(1000003,1191,3,0,0,1191),
(1000003,1204,2,0,0,1204),
(1000003,1240,3,0,0,1240),
(1000003,1242,3,0,0,1242),
(1000003,1243,3,0,0,1243),
(1000003,1249,3,0,0,1249),
(1000003,1250,3,0,0,1250),
(1000003,1251,2,0,0,1251),
(1000003,1252,3,0,0,1252),
(1000003,1253,3,0,0,1253),
(1000003,1257,3,0,0,1257),
(1000003,1259,4,0,0,1259),
(1000003,1260,3,0,0,1260),
(1000003,1261,2,0,0,1261),
(1000003,1268,4,0,0,1268),
(1000003,1282,2,0,0,1282),
(1000003,1284,3,0,0,1284),
(1000003,1303,2,0,0,1303),
(1000003,1304,3,0,0,1304),
(1000003,1307,3,0,0,1307),
(1000003,1308,3,0,0,1308),
(1000003,1309,3,0,0,1309),
(1000003,1310,4,0,0,1310),
(1000003,1323,1,0,0,1323),
(1000003,1352,1,0,0,1352),
(1000003,1353,1,0,0,1353),
(1000003,1354,1,0,0,1354),
(1000003,1355,1,0,0,1355),
(1000003,1356,1,0,0,1356),
(1000003,1357,1,0,0,1357),
(1000003,1362,1,0,0,1362),
(1000003,1363,1,0,0,1363),
(1000003,1364,1,0,0,1364),
(1000003,1365,1,0,0,1365),
(1000003,1388,3,0,0,1388),
(1000003,1389,3,0,0,1389),
(1000003,1390,3,0,0,1390),
(1000003,1391,3,0,0,1391),
(1000003,1392,3,0,0,1392),
(1000003,1393,3,0,0,1393),
(1000003,1397,3,0,0,1397),
(1000003,1413,1,0,0,1413),
(1000003,1414,1,0,0,1414),
(1000003,1415,1,0,0,1415),
(1000003,1416,1,0,0,1416),
(1000003,1460,1,0,0,1460),
(1000003,1461,1,0,0,1461),
(1000003,1476,3,0,0,1476),
(1000003,1477,3,0,0,1477),
(1000003,1478,2,0,0,1478),
(1000003,1479,3,0,0,1479),
(1000003,1499,1,0,0,1499),
(1000003,1500,1,0,0,1500),
(1000003,1501,1,0,0,1501),
(1000003,1502,1,0,0,1502),
(1000003,1503,1,0,0,1503),
(1000003,1504,1,0,0,1504),
(1000003,1519,1,0,0,1519),
(1000003,4552,4,0,0,4552),
(1000003,4553,4,0,0,4553),
(1000003,4554,4,0,0,4554),
(1000003,4699,13,0,0,4699),
(1000003,4700,13,0,0,4700),
(1000003,4702,13,0,0,4702),
(1000003,4703,13,0,0,4703),
(1000003,21046,1,0,0,21046);

Или может посоветуете готового баффера? и гмшоп тоже)

Код:

CREATE TABLE IF NOT EXISTS `custom_npc`(
  `id` decimal(11,0) NOT NULL default '0',
  `idTemplate` int(11) NOT NULL default '0',
  `name` varchar(200) default NULL,
  `serverSideName` int(1) default '0',
  `title` varchar(45) default '',
  `serverSideTitle` int(1) default '0',
  `class` varchar(200) default NULL,
  `collision_radius` decimal(5,2) default NULL,
  `collision_height` decimal(5,2) default NULL,
  `level` decimal(2,0) default NULL,
  `sex` varchar(6) default NULL,
  `type` varchar(20) default NULL,
  `attackrange` int(11) default NULL,
  `hp` decimal(8,0) default NULL,
  `mp` decimal(6,0) default NULL,
  `hpreg` decimal(8,2) default NULL,
  `mpreg` decimal(5,2) default NULL,
  `str` decimal(7,0) default NULL,
  `con` decimal(7,0) default NULL,
  `dex` decimal(7,0) default NULL,
  `int` decimal(7,0) default NULL,
  `wit` decimal(7,0) default NULL,
  `men` decimal(7,0) default NULL,
  `exp` decimal(9,0) default NULL,
  `sp` decimal(8,0) default NULL,
  `patk` decimal(5,0) default NULL,
  `pdef` decimal(5,0) default NULL,
  `matk` decimal(5,0) default NULL,
  `mdef` decimal(5,0) default NULL,
  `atkspd` decimal(3,0) default NULL,
  `aggro` decimal(6,0) default NULL,
  `matkspd` decimal(4,0) default NULL,
  `rhand` decimal(5,0) default NULL,
  `lhand` decimal(5,0) default NULL,
  `armor` decimal(1,0) default NULL,
  `walkspd` decimal(3,0) default NULL,
  `runspd` decimal(3,0) default NULL,
  `faction_id` varchar(40) default NULL,
  `faction_range` decimal(4,0) default NULL,
  `isUndead` int(11) default 0,
  `absorb_level` decimal(2,0) default 0,
  `absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') DEFAULT 'LAST_HIT' NOT NULL,
  `ss` int(4) default 0,
  `bss` int(4) default 0,
  `ss_rate` int(3) default 0,
  `AI` varchar(8) default "fighter",
  `drop_herbs` enum('true','false') DEFAULT 'false' NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `custom_npc` VALUES
('50002',30060,'Trader',1,'Festival Adena',1,'NPC.a_traderA_MHuman','10.00','24.00','70','male','L2Merchant',40,'3862','1493',NULL,NULL,'40','43','30','21','35','10','0','0','1314','470','780','382','278','0','253','0','0','0','80','120',NULL,'0',1,'0','LAST_HIT',0,0,0,'balanced','false'),
('50003',30006,'IsleGate',1,'Isle Teleporter',1,'NPC.a_teleporter_FHuman','8.00','25.00','70','female','L2Teleporter',40,'3862','1493',NULL,NULL,'40','43','30','21','35','10','0','0','1314','470','780','382','278','0','253','0','0','0','80','120',NULL,'0',1,'0','LAST_HIT',0,0,0,'balanced','false'),
('50006',32040,'CTF Gate',1,'CTF Event Manager',1,'NpcEV.heretical_devil_mirror','8.00','26.50','70','male','L2Npc',40,'3862','1493',null,null,'40','43','30','21','35','10','0','0','1314','470','780','382','278','0','999','0','0','0','80','120',NULL,'0',1,'0','LAST_HIT',0,0,0,'balanced','false'),
('50007',32040,'TVT Gate',1,'TvT Event Manager',1,'NpcEV.heretical_devil_mirror','8.00','70.00','70','male','L2TvTEventNpc',40,'3862','1493',NULL,NULL,'40','43','30','21','35','10','0','0','1314','470','780','382','278','0','999','0','0','0','80','120',NULL,'0',1,'0','LAST_HIT',0,0,0,'balanced','false'),
('50013',30175,'Vanessa',1,'Elite Trader',1,'NPC.a_traderA_MHuman','10.00','24.00','70','female','L2Merchant',40,'3862','1493',NULL,NULL,'40','43','30','21','20','10','0','0','1314','470','780','382','278','0','253','0','0','0','80','120',NULL,'0',1,'0','LAST_HIT',0,0,0,'balanced','false'),
('50014',31324,'Andromeda',1,'Wedding Manager',1,'NPC.a_casino_FDarkElf','8.00','23.00','70','female','L2WeddingManager',40,'2444','2444','0.00','0.00','10','10','10','10','10','10','0','0','500','500','500','500','278','0','333','9140','9140',NULL,'28','120','','0',0,'0','LAST_HIT',0,0,0,'balanced','false'),
('50015',31255,'Pumpkin',1,'Class Master',1,'Monster.cat_the_cat','9.00','16.00','70','male','L2ClassMaster',40,'3862','1493','11.85','2.78','40','43','30','21','20','10','0','0','1314','470','780','382','278','0','333','0','0','0','88','132',NULL,'0',0,'0','LAST_HIT',0,0,0,'balanced','false'),
('1000003',32226,'Shiela',1,'NPC Buffer',1,'LineageNPC2.K_F1_grand',11,22.25,70,'male','L2NpcBuffer',40,2444,2444,0,0,10,10,10,10,10,10,0,0,500,500,500,500,278,0,333,0,0,NULL,28,120,NULL,'0',0,'0','LAST_HIT',0,0,0,'balanced','false');