Lvl 70 Weapon Seller and Maple Item Seller

[Kaspar]

Here are two scripts that I just made, work great on my server

Maple Item Store(Default NPC is Mr.Moneybags)

INSERT INTO shops
   (`shopid`, `npcid`)
VALUES
(333332, 9300010);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1032041, 100000000, 1);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1092045, 100000000, 2);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1092046, 100000000, 3);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1092047, 100000000, 4);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1302064, 100000000, 5);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1312032, 100000000, 6);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1322054, 100000000, 7);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1332055, 100000000, 8);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1332056, 100000000, 9);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1372034, 100000000, 10);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1382039, 100000000, 11);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1402039, 100000000, 12);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1412027, 100000000, 13);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1422029, 100000000, 14);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1432040, 100000000, 15);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1442051, 100000000, 16);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1452045, 100000000, 17);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1462040, 100000000, 18);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1472055, 100000000, 19);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1002511, 100000000, 20);
INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1050018, 100000000, 21);
INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333332, 1051017, 100000000, 22); 

Level 70 Weapons(Mia in Henesys)

INSERT INTO shops
   (`shopid`, `npcid`)
VALUES
(333331, 9010002);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1472026, 150000000, 1);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1472028, 150000000, 2);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1472027, 150000000, 3);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1472029, 150000000, 4);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1332018, 150000000, 5);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1332019, 150000000, 6);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1452010, 150000000, 7);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1452011, 150000000, 8);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1452009, 150000000, 9);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1302012, 150000000, 10);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1322019, 150000000, 11);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1462009, 150000000, 12);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1312010, 150000000, 13);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1402012, 150000000, 14);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1412008, 150000000, 15);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1422010, 150000000, 16);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1432007, 150000000, 17);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1442008, 150000000, 18);

INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1372015, 150000000, 19);
INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1050018, 100000000, 20);
INSERT INTO shopitems
   (`shopid`, `itemid`, `price`, `position`)
VALUES
(333331, 1051017, 100000000, 21); 

[MentaL]

[infernofreez]

i have a question.. what is the "values" for example 333331, can it be any number?

[Kaspar]

Thats the shop id, you can just make it a random number, as long as its not already in the "shop" table.

I doubt you will have that randomly made shop id number in your database.

[infernofreez]

alright Thanks ^^ Do I have to execute these, when the server is off? or can it be on while I execute for it to work

[Immature]

the server can be up when you execute them.

[ch1nkayy]

very nice (: i already made one but good for other people (:

[infernofreez]

Ok, I executed them, but when I try to talk to NPC for example, I set the NPC ID for Mapleweapons to Nana (L) in ludi, she wont talk.. do i have to compile or something Rofl?

[Kaspar]

Ok, I executed them, but when I try to talk to NPC for example, I set the NPC ID for Mapleweapons to Nana (L) in ludi, she wont talk.. do i have to compile or something Rofl?

Did you change this part

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(333332, 9300010);
The part in red?

Did any errors come up?

[infernofreez]

No, but Can I change it into a different NPC? Example NANA in Ludi

[Kaspar]

Lol, if you want to change the NPC, put the NPC number where the red part is.

[aeronux]

These look great, awesome job, very useful.

[infernofreez]

When I put the "NPC" ( Nana in Ludi ) I cant talk to her... she just freezes me..

[Kaspar]

I hope your putting in the NPC id...not the name..

[infernofreez]

Yea I put the ID still wont talk.

[Kaspar]

Hm, anyone else have help for this guy?