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

[crushing2]

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 Coco, 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: http://www.mediafire.com/?tcx2xvzrsvg
MIRROR: http://www.sendspace.com/file/r8tu31

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:

Error Code : 1136
Column count doesn't match value count at row 1

Download and execute the following:
http://www.mediafire.com/?mbhibnmxu4g

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

Screenie:

[MentaL]

[crushing2]

Updated the links, and included a download for those using the newest OdinMS revision(s).

[AsianBoy]

Cool nice release thanks =)

[DragonsFaith]

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. :)

[crushing2]

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

[DragonsFaith]

thanks it works :)

[mspwnage15]

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

[wutda]

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

[wutda]

EDIT: NVM, fixed.

[skooboi626]

um it says duplicate entries and when im ingame it only sells the balloon becasue it became item 0

[crushing2]

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:

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);

[ANBUItachi]

Thx..Is working Fine

[crushing2]

Thx..Is working Fine

Great! Thanks for your reply. :)

[deathman91]

Can be improved by adding <Pets> , <Effects>, <Messenger> like such.

[crushing2]

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. :)