uNiQue1337 Posted March 8, 2009 Share Posted March 8, 2009 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!" Quote Link to comment Share on other sites More sharing options...
jossoo Posted March 8, 2009 Share Posted March 8, 2009 if i remember its already posted....no problem kee up good work m8 :) Quote Link to comment Share on other sites More sharing options...
uNiQue1337 Posted March 8, 2009 Author Share Posted March 8, 2009 if i remember its already posted....no problem kee up good work m8 :) It is posted in Greek Section. In english it isnt. Quote Link to comment Share on other sites More sharing options...
CriticalError Posted March 8, 2009 Share Posted March 8, 2009 ofc this guide is very good man usefull for ppl start with this congratulations for your good job in community keep up!!! PS= just forget something brother you say when extract pack copy folder data and paste in gameserver you do that overwriten all folder and you lose another folders have this is just a observation :P Quote Link to comment Share on other sites More sharing options...
uNiQue1337 Posted March 8, 2009 Author Share Posted March 8, 2009 ofc this guide is very good man usefull for ppl start with this congratulations for your good job in community keep up!!! PS= just forget something brother you say when extract pack copy folder data and paste in gameserver you do that overwriten all folder and you lose another folders have this is just a observation :P You dont loose something ;D Its just overwritte (data) folder because it is already exist... It does not delete anything ;D Quote Link to comment Share on other sites More sharing options...
Feelmyspells Posted March 8, 2009 Share Posted March 8, 2009 Well pretty good guide for newbies.Keep up. Quote Link to comment Share on other sites More sharing options...
Mwrk Posted March 8, 2009 Share Posted March 8, 2009 Nice guide. Keep it up :) Quote Link to comment Share on other sites More sharing options...
Admiral Posted March 16, 2009 Share Posted March 16, 2009 Thanks for this ^^ Quote Link to comment Share on other sites More sharing options...
hakerboy Posted March 17, 2009 Share Posted March 17, 2009 Nice share. keep up :P. ps. to all of you if there is a message "installed unsuccesfully" then it didnt installed:P since many will ask for it :P Quote Link to comment Share on other sites More sharing options...
uNiQue1337 Posted March 17, 2009 Author Share Posted March 17, 2009 It needs manual fix... I cant make a guide about it for every chronicle and for every pack.. Quote Link to comment Share on other sites More sharing options...
hakerboy Posted March 17, 2009 Share Posted March 17, 2009 It needs manual fix... I cant make a guide about it for every chronicle and for every pack.. Ye it needs manual fix. but do you think that a guy that use guide for npc instalation would realy know how to fix it?:P it was an advise not a question to those that would ask:P no offence :P Quote Link to comment Share on other sites More sharing options...
maskedrey Posted March 26, 2009 Share Posted March 26, 2009 ty Quote Link to comment Share on other sites More sharing options...
maskedrey Posted March 26, 2009 Share Posted March 26, 2009 man this is very cool i like it Quote Link to comment Share on other sites More sharing options...
maskedrey Posted March 26, 2009 Share Posted March 26, 2009 nice guild Quote Link to comment Share on other sites More sharing options...
DAVC Posted March 28, 2009 Share Posted March 28, 2009 any can give link for donwloads file pls no have 100 post Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.