SQL Flag and Etc

[Moofhead]

Another boring shop release. XD
This one has flags, pumpkin baskets. You can add more stuff. The NPC is Chief Stan btw.

You may change the price to anything you want.

How to Use

1. MySQL Query Browser or navicat
2. Copy and Paste in command.
3. Execute

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302035, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302036, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302057, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302066, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302073, 500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302074, 500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1312033, 500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1432043, 500000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1432044, 500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302034, 500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (133678, 1302062, 500000, 11);


INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(133678, 1012003);

 

[ANBUItachi]

Re: [Release]SQL Flag and Etc

I think Chief Stan is in Use [I think is a Quest]

 

[Falzer]

Re: [Release]SQL Flag and Etc

In Henesys? Well, if yes, Chief Stan is PART (Keyword - Part) of a quest. I think the quest is Alex and the Runaway Kid...

 

[musicazx]

Re: [Release]SQL Flag and Etc

1302073 << InVaild
1302074 << InVaild
---------
1432043 << InVaild
1432044 << InVaild

1302066 - 1312033 << Douple

 

[Blazer9131]

Re: [Release]SQL Flag and Etc

Yah sucky scripting. Just spent a while editing it... half of these items aren't even in the database.