[Tut]How to make a Shop w/ mySQL query browser

[.SketchBear]

Okay so, this is how to make a shop using mySQL query browser

Step one:

Choose an NPC and find it's id.
Then, find a shop ID that isn't being used, by going to a resultset and clicking on "Shops"
Choose a shop id.

then, create a new script and insert this in

[COLOR="Purple"]INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(shopid, npcid);[/COLOR]

<-- of course, change shopid and npc id to what you want them to be

Step 2:

Figure out the item id's, and the price of your items

Then, insert this in for each item:

[CODE]INSERT INTO shopitems (shopid, itemid, price, position) VALUES (shopid, itemid, price, position);[/CODE]

Eg. I want to put an onyx apple into my shop for 25000 mesos and my shopid is 6666

insert this code:

[COLOR="Purple"]INSERT INTO shopitems (shopid, itemid, price, position) VALUES (6666, 2022179, 25000, 1);[/COLOR]

Note: Position decides where in the shop it'll be. So position 1 will put it first.

Make sure not to have duplicate positions

Good luck with this.