Page 1 of 1

Problem with custom NPC

Posted: Wed Mar 31, 2010 5:39 pm
by RavenStylez
If you want to receive support we need this info to help you properly.
ยป Find Revision
L2J Revision Number: 3913
L2JDP Revision Number: 7038
Nightlies Build.

Heey L2J Members,

I don't know if this should be posted here or in the Custom MODs...
The problem is I'm having a little problem with my custom Vesper Shop on my Epilogue Server.
I've made the multisell files and the html, but it failed when adding the NPC in the database for some reason :?
It said it was succesfully added and it's listed. I've also added it in the sql/npc.sql file.
All other NPCs I've made worked, but this one is really weird.
I've rechecked the HTML files and the XML (multisell) files, but there are no faults.

If I press //spawn 50000 (< that's the NPC ID I've used) it says it's not existing.
Also if I look at the spawn table, it's not there.

Here's what I added for the MySQL:
INSERT INTO `npc` VALUES (50000,13115,'Phoenix',1,'Vesper Shop',1,'LineageMonster4.Divine_Healer',10.00,25.00,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,NULL,0,60,60,0,0,'LAST_HIT','false');

Please help me on this, since I rather not have to do my whole scripting all over again.

Thanks in advance!
-Raven

Re: Problem with custom NPC

Posted: Thu Apr 01, 2010 12:12 am
by hope
add it to custom npc table that is why you have that table

Re: Problem with custom NPC

Posted: Thu Apr 01, 2010 10:30 am
by RavenStylez
But my other custom NPCs were added in this same table and working just fine O.o
I'll try it anyway and tell if it did work.
---------------------------
Thanks for your help. This didn't solve it, but it is solved.
For some reason NPC ID 50000 didn't work. I'm now using 40003 and it works.
Thanks anyway!

Re: Problem with custom NPC

Posted: Fri Apr 02, 2010 9:41 am
by jurchiks
use custom tables for custom stuff, should be a golden rule for dp modders...
it will make it so much easier for you to backup your custom npcs and stuff, you'll just have to backup those tables instead of the full npc table (much heavier in case you didn't know)

Re: Problem with custom NPC

Posted: Fri Apr 02, 2010 9:50 am
by LasTravel
Hello, use this:

Code: Select all

DELETE FROM `npc` WHERE `id`='50000';INSERT INTO `npc` VALUES ('50000', '13115', 'Phoenix', '1', 'Vesper Shop', '1', 'LineageMonster4.Divine_Healer', '10.00', '25.00', '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', '0', '55', '132', '1', '0', 'LAST_HIT', 'false');
Regards

Re: Problem with custom NPC

Posted: Fri Apr 02, 2010 9:59 am
by jurchiks

Code: Select all

DELETE FROM `npc` WHERE `id`='50000';INSERT INTO `custom_npc` VALUES ('50000', '13115', 'Phoenix', '1', 'Vesper Shop', '1', 'LineageMonster4.Divine_Healer', '10.00', '25.00', '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', '0', '55', '132', '1', '0', 'LAST_HIT', 'false');

Re: Problem with custom NPC

Posted: Fri Apr 02, 2010 1:13 pm
by RavenStylez
It is already fixed and there was not a npc on 5000... I've checked both custom_npc and normal npc in the sql folder and the database.