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

    • I’ve worked with teams spread across a few regions, and having a group that actually connects tech, security, and digital assets made things smoother for us, especially during cross‑city projects. I liked how straightforward their setup was, and tapping into their digital assets side helped us speed up a couple of integrations. If you’re scaling across different markets, it might be a handy option to look into.
    • Hello guys, I’m Morientes, owner of the servers you might know: L2Lionna / L2Pandora / L2Ramona / L2ERA / L2Zaken / L2Classic / L2Peri / L2Alice / L2EVA / L2Dragon and more. Over the years I’ve been developing Lineage II projects starting from High Five, then Classic, and later Essence. I started with High Five, which I turned into a very well-tested server with over 100 openings. My peak was around 2800 players online, and the server was stable (no crashes). With every opening there was always something to improve, fix, or optimize, and over time it became more and more stable. I still have all SVN commits from all those years, I can show everything via screen share if needed. The reason I’m selling is not because of the quality. The files are solid and ready to run any type of server (any rates). The problem was on our side;  we didn’t have a good long-term strategy for reopening servers as a team. About Classic: I started from 2.0 (Zaken version) and gradually upgraded it up to 4.7 Kamael. Each chronicle upgrade came with a lot of improvements, especially in terms of stability. About Essence: I started from the very first version and developed it up to High Elf (Protocol 464). Starting from Protocol 286 (Secrets of Empire), I worked with PTS files and extracted a lot of deep fixes. I unpacked AI.obj with full functionality, used official sniffers, and whenever something wasn’t clear, I checked directly on official servers and sniffed packets or data. For every chronicle update, I basically sniffed the entire official server, zones, monsters, events, mechanics, everything. From Chronicle 388, Reborn approached us to buy our files. The current L2Reborn Essence is based on my work! I can prove everything. I also have their updates integrated into my pack. I stopped development after High Elf mainly because my main developer was constantly looking for other opportunities. It became difficult to maintain a stable team, especially with everything going on (including the situation in Ukraine at that time). Eventually, I couldn’t find a reliable dev to continue working on Essence, so I decided to step away from this market last year. Now I’ve decided to sell everything. What I’m selling: All necessary tools (sniffing, geodata build, pack upgrade tools, game client parsers, L2Wiki parser, interfaces etc.) Full SVN repositories with all commits (Essence / Classic / High Five) All edited clients I still have All my data I can also include on sell an official character that is active daily, ranked, end up gear, and has access to end-game zones!!! useful for deep sniffing where normal players don’t have access. If someone wants to buy everything, I prefer a full deal and I will transfer full ownership. If needed, I can also sell parts separately, but honestly I’d prefer to sell everything to one team that can continue this project — this has been my work, my hobby, my baby. Important: I don’t offer further updates. The files are sold exactly as they are. I will, of course, explain everything you need to know to continue working on them. Contact: Telegram: @AlexAlexey Discord: .primsl2
  • 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..