Jump to content

Recommended Posts

Posted

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)

shop-2.jpg

Ok, now we copy the folder DATA and we paste it in GameServer

shop3.jpg

 

AND in GameServer Folder

shop2.jpg

 

 

[2 SQL]

Go to Navicat -> Open your server db [i use l2emu_db] -> Right click and pres execute batch file

width=603 height=480http://i289.photobucket.com/albums/ll235/TheTonyMontana/sql.jpg[/img]

 

So you got that..

width=563 height=480http://i289.photobucket.com/albums/ll235/TheTonyMontana/sql2.jpg[/img]

 

Then

sql2-2.jpg

 

After you have to browse the folder of npc SQL -When you click the SQL file press [Open]

sql2-3.jpg

And after this pres Start.

So if you get this...

sql2-4.jpg

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!"

 

Posted

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

Posted

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

  • 2 weeks later...
Posted

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

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • Download Lobby u need island for lobby Download Crow Island  
    • Website: https://l2elixir.org/ Discord: https://discord.gg/5ydPHvhbxs    
    • L2-LORENA x100 MID RATE   Interlude Nostalgia Meets Modern Gameplay   OFFICIAL OPENING:  April 4 (Saturday)  19:00 UTC+1 ⸻  MAIN INFORMATION  Adena: x5  Drop: x10  Spoil: x10  Raid Boss: x10  Seal Stones: x2  Quests: x10 ⸻  FEATURES  GM Shop up to B-Grade  Full Buffer  Premium System (x2 bonuses)  AutoFarm – FREE for everyone ⸻  SERVER CONCEPT  Classic Interlude nostalgia  Enhanced with modern interface & mechanics  Balanced PvP & PvE gameplay  Active development & custom features ⸻  WHY JOIN L2-LORENA?  No Pay-to-Win  Smooth gameplay & stable server  Competitive PvP environment  Friendly & active community ⸻  JOIN US NOW L2-LORENA 100X <<< LINK Discord: https://discord.gg/TYZ88Tgx4b  Facebook: https://www.facebook.com/share/18kwbkaYZY/?mibextid=wwXIfr   L2-LORENA Link << Discord: https://discord.gg/TYZ88Tgx4b  Facebook: https://www.facebook.com/share/18kwbkaYZY/?mibextid=wwXIfr
    • https://web.archive.org/web/20260306183214/https://maxcheaters.com/topic/241828-l2j-l2damage/page/3/ https://l2topzone.com/forum/l2-server-support-problems/9/l2damage-stopped/30514 Also we will try to push longer seasons ever ! (1135-100)/9 = 115 online
    • ONE SIDE – AND EVERYTHING BREAKS ▪ Looks like a simple case: Florida DL, back side, barcode – “clean and minimal”. ▪ In reality, these are exactly the tasks that fail most often. – data provided as plain text – request only for the back side – focus on the barcode (PDF417) ▪ And here’s the key point: ▪ A barcode is not just a “picture on the back”. It’s compressed logic of the entire document. ▪ If it doesn’t match the front, format, and data structure – the system flags it instantly. ▪ Many create a “similar-looking” code. But systems don’t read “similar” – they read by specification. ▪ In cases like this, it’s not about design. It’s about correct data assembly and how it behaves inside the format. ▪ Today only – 15% off for verification cases. ▪ Want it to pass, not just look right? Describe your case – we’ll show where even clean files break. › TG: @mustang_service ( https:// t.me/ mustang_service ) › Channel: Mustang Service ( https:// t.me/ +JPpJCETg-xM1NjNl ) #editing #photoshop #documents #verification #case
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..