Tia Selling All Gm Scrolls And All BossHunter Equips

[cooljaydm]

This is my third release it took me about 5 minutes to make isnt much but i thought some people might want it. But First Go To MYSQL And go to shops then make a new shop. ShopID:123456 and 9010001. Or You Can Change It To Any NPC.

PS This Makes Tia A Shop

SQL SCRIPT

INSERT INTO shops
(`npcid`)
VALUES
(9010001);
INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1002749, 5000000, 1);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1002750, 5000000, 2);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1052151, 5000000, 3);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1052152, 5000000, 4);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1072345, 5000000, 5);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1072346, 5000000, 6);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1002739, 5000000, 7);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1002740, 5000000, 8);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1052148, 5000000, 9);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1052149, 5000000, 10);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1072342, 5000000, 11);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 1072343, 5000000, 12);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040603, 2000000000, 13);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044503, 2000000000, 14);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2041024, 2000000000, 15);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2041025, 2000000000, 16);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044703, 2000000000, 17);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044603, 2000000000, 18);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043303, 2000000000, 19);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456,
204030, 2000000000, 20);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040807, 2000000000, 21);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040806, 2000000000, 22);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040006, 2000000000, 23);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040007, 2000000000, 24);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043103, 2000000000, 25);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043203, 2000000000, 26);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043003, 2000000000, 27);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040507, 2000000000, 28);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040506, 2000000000, 29);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044403, 2000000000, 30);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040903, 2000000000, 31);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040709, 2000000000, 32);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040710, 2000000000, 33);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040711, 2000000000, 34);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044303, 2000000000, 35);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043803, 2000000000, 36);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2040403, 2000000000, 37);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044103, 2000000000, 38);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044203, 2000000000, 39);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044003, 2000000000, 40);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2043703, 2000000000, 41);

 

[cooljaydm]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

sucks.

 

[metroix]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

sucks.

sucks.

 

[XxOsirisxX]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

sucks.

sucks.

 

[Savage]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

Took you 5 minutes? whoa your a fast typer!

I'm sure it probably took longer but your saying 5 minutes to make yourself seem cooler. Correct me if I'm wrong.

 

[XxOsirisxX]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

Took you 5 minutes? whoa your a fast typer!

I'm sure it probably took longer but your saying 5 minutes to make yourself seem cooler. Correct me if I'm wrong.

5 minutes is the default time xD

If you gotta go, and have to do something before.. you says "give me 5 minutes".. if you do something in 30 minutes you says "i did it in 5 minutes". It's like.. "this is so easy".

 

[Lolhamachi]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

Everyone needs to stop selling everything :\

 

[iFate]

Re: [Release]Tia Selling All Gm Scrolls And All BossHunter Equips

If you had all of the item ID's readily available, you could do this in 2mins, give or take... Simple copy/paste

and all of that is not needed... This would easily work, and save time...

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(123456, 2044203, 2000000000, 39),(123456, 2044203, 2000000000, 39),(123456, 2044203, 2000000000, 39),(123456, 2044203, 2000000000, 39);