Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[RELEASE]NPC That Sells ALL NX Items!![OdinMS]

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jan 17, 2008
Messages
14
Reaction score
0
I originally coded this for FusionMS, but I don't think anyone else has released it yet, so I might as well.

**PLEASE TAKE THE TIME TO REPLY TO THIS TOPIC IF YOU FIND IT USEFUL OR INTERESTING**

This will make , in Henesys, sell all NX items.
If you want to change the NPC, simply change the name of 9000017.js to whichever NPC's ID you want. However, if the NPC gives a quest, it won't work.

Updated (5-22-08 - 4:15 PM EST)
Download:
MIRROR:

Directions:
1) Download and extract, of course.
2) Place 9000017.js into your server's npc folder: OdinMS\scripts\npc
3) Then open up SQLyog, Navicat, MySQL Query Browser, or a similar program, and execute the .sql files provided.
4) Enjoy!

If you get the following error when trying to execute the query's:
Code:
Error Code : 1136
Column count doesn't match value count at row 1
Download and execute the following:


If you have any problems, feel free to post here.

Screenie:
crushing2 - [RELEASE]NPC That Sells ALL NX Items!![OdinMS] - RaGEZONE Forums
 
Last edited:
Newbie Spellweaver
Joined
Jan 17, 2008
Messages
14
Reaction score
0
Re: [RELEASE]Full NX Shop, ALL IN ONE NPC! [OdinMS]

Updated the links, and included a download for those using the newest OdinMS revision(s).
 
Newbie Spellweaver
Joined
Apr 6, 2008
Messages
5
Reaction score
0
sorry, it doesnt really work. When you click the npc it just does nothing. and from that point you cn't click other npc's. Thanks for the hard effort tho. :)
 
Newbie Spellweaver
Joined
Jan 17, 2008
Messages
14
Reaction score
0
sorry, it doesnt really work. When you click the npc it just does nothing. and from that point you cn't click other npc's. Thanks for the hard effort tho. :)

I updated the links, don't forget to execute Shops.sql
 
Initiate Mage
Joined
May 19, 2008
Messages
1
Reaction score
0
yo thanks man its great your one of the first i seen releasing things for odin source keep it up you should make an all in one nx hair, eyes, and skin shop that would be sick thanks tho
 
Newbie Spellweaver
Joined
May 3, 2008
Messages
10
Reaction score
0
Thanks so much! Good thing I didn't use Coco yet, it was going to be next NPC I was going to use as a store. xD
 
Initiate Mage
Joined
Feb 2, 2007
Messages
2
Reaction score
0
um it says duplicate entries and when im ingame it only sells the balloon becasue it became item 0
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Jan 17, 2008
Messages
14
Reaction score
0
um it says duplicate entries and when im ingame it only sells the balloon becasue it became item 0

For some reason your shopitemid column doesn't auto-increment.

Try right clicking on shopitems in the Schemata box on the right and click Edit Table. Make sure there's a check mark under AUTO INC in row shopitemid.

Also, I noticed something's wrong with your query, try executing this instead:
Code:
INSERT INTO shopitems VALUES (shopitemid, 100, 1102093, 5000000, 1);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102005, 5000000, 2);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102075, 5000000, 3);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102037, 5000000, 4);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102010, 5000000, 5);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102070, 5000000, 6);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102045, 5000000, 7);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102038, 5000000, 8);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102049, 5000000, 9);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102008, 5000000, 10);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102110, 5000000, 11);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102065, 5000000, 12);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102077, 5000000, 13);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102092, 5000000, 14);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102006, 5000000, 15);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102066, 5000000, 16);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102074, 5000000, 17);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102111, 5000000, 18);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102063, 5000000, 19);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102058, 5000000, 20);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102050, 5000000, 21);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102068, 5000000, 22);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102073, 5000000, 23);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102019, 5000000, 24);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102062, 5000000, 25);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102059, 5000000, 26);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102076, 5000000, 27);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102052, 5000000, 28);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102060, 5000000, 29);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102069, 5000000, 30);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102044, 5000000, 31);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102025, 5000000, 32);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102036, 5000000, 33);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102009, 5000000, 34);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102091, 5000000, 35);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102067, 5000000, 36);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102039, 5000000, 37);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102020, 5000000, 38);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102051, 5000000, 39);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102007, 5000000, 40);
INSERT INTO shopitems VALUES (shopitemid, 100, 1102072, 5000000, 41);
 
Last edited:
Newbie Spellweaver
Joined
Apr 25, 2008
Messages
19
Reaction score
0
Can be improved by adding <Pets> , <Effects>, <Messenger> like such.
 
Newbie Spellweaver
Joined
Jan 17, 2008
Messages
14
Reaction score
0
Can be improved by adding <Pets> , <Effects>, <Messenger> like such.

I didn't add those things for the following reasons:
Pets don't work.
Effects DC everyone on the map when used.
Messengers are sold by Fredrick in the FM.

If you really want them it shouldn't be too hard to figure out how to add them yourself, just by looking at my code. :)
 
Last edited:
Newbie Spellweaver
Joined
Sep 14, 2007
Messages
23
Reaction score
0
no, it should be
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102093, 5000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102005, 5000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102075, 5000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102037, 5000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102010, 5000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102070, 5000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102045, 5000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102038, 5000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102049, 5000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102008, 5000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102110, 5000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102065, 5000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102077, 5000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102092, 5000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102006, 5000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102066, 5000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102074, 5000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102111, 5000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102063, 5000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102058, 5000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102050, 5000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102068, 5000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102073, 5000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102019, 5000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102062, 5000000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102059, 5000000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102076, 5000000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102052, 5000000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102060, 5000000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102069, 5000000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102044, 5000000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102025, 5000000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102036, 5000000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102009, 5000000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102091, 5000000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102067, 5000000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102039, 5000000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102020, 5000000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102051, 5000000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102007, 5000000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (100, 1102072, 5000000, 41);
 
Skilled Illusionist
Loyal Member
Joined
May 5, 2008
Messages
352
Reaction score
0
this was already released
 
Last edited:
Status
Not open for further replies.
Back
Top