I decided to make this topic, because mutch ppl ask how to add Custom NPCS (Shops,Buffers) in their server.
Okay, lets start...
[1 DATA]
You download the NPC and you got two folders... (SQL,DATA)
Ok, now we copy the folder DATA and we paste it in GameServer
AND in GameServer Folder
[2 SQL]
Go to Navicat -> Open your server db [i use l2emu_db] -> Right click and pres execute batch file
http://i289.photobucket.com/albums/ll235/TheTonyMontana/sql.jpg[/img]
So you got that..
http://i289.photobucket.com/albums/ll235/TheTonyMontana/sql2.jpg[/img]
Then
After you have to browse the folder of npc SQL -When you click the SQL file press [Open]
And after this pres Start.
So if you get this...
The npc successfully installed on your server!
[3 How to find NPC ID]
Open GMShop.SQL
and find
INSERT INTO `custom_npc` VALUES ('99998', '36283', 'Super Shop', '1', 'Shop', '0', 'Monster3.heretic_priest_a', '8.00', '24.00', '80', 'male', 'L2Merchant', '80', '5555', '5555', '55.00', '55.00', '50', '50', '50', '50', '50', '50', '50', '50', '5000', '50000', '50000', '50000', '500', '500', '500', '70002', '70000', '0', '80', '120', null, '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
INSERT INTO `custom_npc` VALUES ('99999', '36283', 'Super Shop', '1', 'L2 Emu', '0', 'Monster3.heretic_priest_a', '8.00', '24.00', '80', 'male', 'L2CraftManager', '80', '5555', '5555', '55.00', '55.00', '50', '50', '50', '50', '50', '50', '50', '50', '5000', '50000', '50000', '50000', '500', '500', '500', '70002', '70000', '0', '80', '120', null, '0', '1', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
INSERT INTO `custom_npc` VALUES ('569899', '36283', 'Super Shop', '1', 'Shop Walker', '1', 'Monster3.heretic_priest_a', '8.00', '24.00', '80', 'male', 'L2NpcWalker', '80', '2444', '2444', '0.00', '0.00', '10', '10', '10', '10', '10', '10', '0', '0', '5000', '5000', '5000', '5000', '999', '0', '333', '16005', '70000', null, '85', '115', '', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'balanced', 'false');
It does not always `custom_npc` Some times is `npc` and sometimes is `custom_npc
The id is after VALUES -> 99998 & 99999 & 569899
Thats it... Have fun ;D
I hope i helped newbies :P
Also i hope some ppl stop saying "Hi mi want install shop mi server help mi pliz!"