Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release/Dev] Target Multi-Shop v.1

Status
Not open for further replies.
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Seems like I'm still going to release something on RageZone...

Anyways, this is a Release/Dev because I have the Shop SQL, but I'm still going to update it. Remember, this script is REALLY long, so I'll attach it to this thread. I'll also include a download link here. Download Link -

I call this Shop SQL the "Target Multi-Shop" because it uses the NPC, Andy, who apparently "works" for Target...

By the request of ihatehaxor, here are some of the items that are in this script:
Accessory Items
Dragon Weapons
Pets
Pet Food
Food Items
Potions
Summoning Bags
Some Common Hats
Some Common Gloves
And more~
Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122007, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122001, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122003, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122004, 25000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122006, 25000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122002, 40000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122005, 40000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1122000, 40000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2041200, 50000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302059, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1312031, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1322052, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332049, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332050, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1372032, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382036, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1402236, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1412026, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1422028, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432038, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1442045, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452044, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462039, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472051, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472052, 20000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302016, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302017, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302025, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302026, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302027, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302028, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302029, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302058, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302059, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302035, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302036, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302057, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302066, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302073, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302074, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1312033, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432043, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432044, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302034, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302062, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302079, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1322059, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332064, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332065, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382053, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1412032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432045, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1442060, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452052, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462046, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472062, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1032040, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1032041, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1032041, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452045, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452046, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452016, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452022, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472056, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472030, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1472055, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462041, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462014, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462019, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462040, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332057, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332025, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332055, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1332056, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1312033, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1312032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1322055, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1322054, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302033, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302067, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302058, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302066, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302020, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302030, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1302064, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1442052, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1442024, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1442051, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432041, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432012, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1432040, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382040, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382009, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382012, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1382039, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1412028, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1412011, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1412027, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1422032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1422014, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1422029, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1402040, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1402039, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1372034, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2000005, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2060004, 50000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2061004, 50000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070016, 50000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452054, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462047, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082048, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082049, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082050, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452046, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452048, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462041, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462043, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452055, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462048, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002749, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082083, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082084, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082085, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1052151, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1072345, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452023, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452053, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452004, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452018, 2000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462046, 2000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452056, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462049, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082125, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082126, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082127, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1072203, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1072204, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1072205, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002547, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082163, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1052071, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1452044, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1462039, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070000, 10000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070001, 250000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070008, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070002, 650000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070009, 650000, 0); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070012, 800000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070013, 1500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070003, 1650000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070010, 1700000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070011, 2000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070004, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070005, 15000000, 0); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070006, 25000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070007, 35000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2070016, 50000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000000, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000001, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000002, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000003, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000004, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000005, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000006, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000007, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000008, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000009, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000010, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000011, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000012, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000013, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000014, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000015, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000017, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000018, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000020, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000021, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000022, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000023, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000024, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000025, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000028, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000029, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000030, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000031, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000033, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000034, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000036, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000037, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000039, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 5000041, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010000, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010004, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010005, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010015, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010011, 2500000, 0); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010001, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010002, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010003, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010006, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010007, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010008, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010010, 2500000, 0); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010009, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010012, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010014, 2500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3011000, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 3010013, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022053, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022308, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022194, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022184, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022035, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022251, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022016, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022117, 2000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022195, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022271, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022032, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022263, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022102, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022143, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022193, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022142, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022282, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022045, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022044, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022048, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022250, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022176, 2000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022306, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022113, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022249, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022069, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022052, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022006, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022198, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022199, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022224, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022225, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022226, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022227, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022228, 999999, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022150, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022272, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022244, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022307, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022273, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022049, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2020017, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022283, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022191, 5000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022103, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022028, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022029, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022030, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022192, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2020020, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2022068, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100017, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101043, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101044, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101045, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101046, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101047, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101048, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101049, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101057, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100000, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100014, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100016, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101050, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101051, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101052, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101053, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101054, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101055, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101056, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101020, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102000, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102001, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102002, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102003, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102004, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102005, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102006, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102007, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102008, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2102009, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101072, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101073, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101021, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101026, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101023, 200000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101025, 200000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101024, 200000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100001, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100035, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100036, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100002, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100003, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100004, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100005, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100006, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100007, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100033, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100034, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101080, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101089, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101090, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101091, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101092, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101093, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101081, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101082, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101083, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101084, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101085, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101086, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101087, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101088, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101039, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100052, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100020, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100021, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100022, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100023, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100024, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100025, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100026, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101027, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101012, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101010, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101015, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101011, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101014, 150000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101009, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100053, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100054, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100055, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100056, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100057, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100058, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100059, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101013, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100043, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100012, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100015, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101001, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100013, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101008, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100044, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100029, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100030, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100011, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100031, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100032, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100041, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100047, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100051, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100045, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100050, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100049, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100048, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101007, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101000, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100009, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100042, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101004, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101005, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101006, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100008, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100028, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101002, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2101003, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100018, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2100019, 10000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030008, 1000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030011, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030010, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030012, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030016, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030000, 1000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030007, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030002, 1000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030004, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030005, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030001, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030003, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030006, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 2030009, 2000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4160011, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4005000, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4005001, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4005002, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4005003, 100000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4005004, 150000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4006000, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4006001, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4003000, 5000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021000, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021001, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021002, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021003, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021004, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021005, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021006, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021007, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021008, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4021009, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011000, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011001, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011002, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011003, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011004, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011005, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011006, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011007, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 4011008, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002716, 150000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002717, 150000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002663, 200000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002492, 250000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002677, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002676, 550000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002471, 700000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002554, 700000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002571, 700000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002483, 800000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002572, 900000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002573, 950000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1002574, 1000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082228, 5000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082223, 500000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1082222, 700000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1050100, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1050127, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1051098, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1051140, 100000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1050018, 150000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1694, 1051017, 150000, 0);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1694, 9201086);
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Mar 13, 2007
Messages
45
Reaction score
0
What's with the "position" being 0? o_O isnt it suppose to be like 1,2,3,4....iuno im choob.
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Apparently, the 0 will stand for the 1, 2, 3, 4...
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Thanks for using it. I'll need more ideas. If you want a certain item(s) on this script, just PM me the list of item codes...

Btw, I lost track of the items on it... So, whoever asks me what items are on the script is a noob.
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Really amazing. If you read the thread, you would know... Sort of...

And, none of the Shop SQLs I made are tested...
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Read the bold sentence pl0x. Nuff said.
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
I FORGOT!

When I remember some, I'll edit the thread...
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Ok... I'll edit the thread to show some of the stuff in it. Happy?
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
There. I edited it.

I'll remember more later. And I'll update later too.
 
*
Loyal Member
Joined
Jul 23, 2008
Messages
691
Reaction score
90
Meh.It'll help people with real high rates server, the ones that are like Kill a snail.lvl 200, rebirth
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Should I delete it or not... XD

Btw, REQUESTS FOR ITEMS HERE?!? Just PM me the the item codes and the item names and I'll put em in the script! (Credits will be given...)
 
Master Summoner
Loyal Member
Joined
Apr 20, 2008
Messages
578
Reaction score
76
You can't use Andy, did you even test this.
 
Status
Not open for further replies.
Back
Top