Can't add a npc with sql file

[ADONES]

Hello Dudes,

i'm running the Epilogue with nighly pack and want to add some custom npcs like i did on Gracia Final.

I tryed it with the same sql file like i did at Gracia Final but it dont work... I tryed add them to "custom_npc" table that works.. i can see them in the Database but can not spawn them everytime ingame brings the error "Target cannot be found". If i try to add them to normal "npc" table it dont works... i checked the id's if some are double but there are no double id's.. so it should work i guess... but it don't.

Example of my try:

Code: Select all

REPLACE INTO `npc` VALUES (40001, 31126, 'Blacksmith of Mammon', 1, 'L2House', 1, 'NPC.e_smith_master_MDwarf', 08.00, 16.50, 70, 'male', 'L2Merchant', 40, 3862, 1494, 0.00, 0.00, 40, 43, 30, 21, 20, 20, 0, 0, 1303, 471, 607, 382, 253, 0, 333, 0, 0, 0, 30, 132, 'NULL', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter', 'false'); 

I also already tryed the ' everywhere.

Can someone help me? Or whrite me an sql how to insert my npcs?

Thank you in advance
sincerely yours
ADONES

[Probe]

paste the sql line error you get, or simply do as follows:
copy the existing SQL entry of Blacksmith of Mammon, and just put in a new id (keep template id as default)

[LasTravel]

Code: Select all

REPLACE INTO `npc` VALUES (40001, 31126, 'Blacksmith of Mammon', 1, 'L2House', 1, 'NPC.e_smith_master_MDwarf', 08.00, 16.50, 70, 'male', 'L2Merchant', 40, 3862, 1494, 0.00, 0.00, 40, 43, 30, 21, 20, 20, 0, 0, 1303, 471, 607, 382, 253, 0, 333, 0, 0, 0, 30, 132, 'NULL', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'fighter', 'false'); 

try:

Code: Select all

REPLACE INTO `npc` VALUES ('40001', '31126', 'Blacksmith of Mammon', '1', 'L2House', '1', 'NPC.e_smith_master_MDwarf', '08.00', '16.50', '70', 'male', 'L2Merchant', '40', '3862', '1494', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '0', '50', '120', 'NULL', '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');

[janiii]

Custom npc table has to be enabled in config.

[ADONES]

Thanks for your help..

i tried with that code u whrote me las... but i still get this error..

Code: Select all

[Err] 1136 - Column count doesn't match value count at row 1[Err] REPLACE INTO `npc` VALUES ('40001', '31126', 'Blacksmith of Mammon', '1', 'L2House', '1', 'NPC.e_smith_master_MDwarf', '08.00', '16.50', '70', 'male', 'L2Merchant', '40', '3862', '1494', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '0', '50', '120', 'NULL', '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');[Msg] Finished - Unsuccessfully

and janiii... i already activated custom npc table in the General config... still dont work.. any other ideas?

ty
sincerely yours
ADONES

[LasTravel]

try:

Code: Select all

INSERT INTO `custom_npc` VALUES ('40001', '31126', 'Blacksmith of Mammon', '1', 'L2House', '1', 'NPC.e_smith_master_MDwarf', '08.00', '16.50', '70', 'male', 'L2Merchant', '40', '3862', '1494', '11.85', '2.78', '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '333', '0', '0', '0', '0', '50', '120', 'NULL', '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');

[/quote]

[ADONES]

I already got this npc in my custom_npc list.. but if i want to spawn him it says "Target cannot be found" thats... why i asked to insert him to normal npc table...

[qwerty13]

Check configs, maybe you forgot to enable this table?

[ADONES]

and janiii... i already activated custom npc table in the General config... still dont work.. any other ideas?