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

Falzer · Sep 7, 2008

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 -

To view the content, you need to sign in or register

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);

Jim007 · Sep 7, 2008

What's with the "position" being 0?

isnt it suppose to be like 1,2,3,4....iuno im choob.

xblackcat · Sep 7, 2008

Jim007 said:
What's with the "position" being 0? isnt it suppose to be like 1,2,3,4....iuno im choob.

No 0 means it will be at the top

Falzer · Sep 7, 2008

Apparently, the 0 will stand for the 1, 2, 3, 4...

Jim007 · Sep 7, 2008

Falzer said:
Apparently, the 0 will stand for the 1, 2, 3, 4...

ooo...i see. Pretty sickk. Will be using once I get my server back up.

Falzer · Sep 7, 2008

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.

ihatehaxor · Sep 7, 2008

hmm.
can u like the some ss
or tell us whats in there

Falzer · Sep 7, 2008

Really amazing. If you read the thread, you would know... Sort of...

And, none of the Shop SQLs I made are tested...

ihatehaxor · Sep 7, 2008

well u said.
something about target?

Falzer · Sep 7, 2008

Read the bold sentence pl0x. Nuff said.

ihatehaxor · Sep 7, 2008

lol.
so u wont tell us what this npc has? at all..

Falzer · Sep 7, 2008

I FORGOT!

When I remember some, I'll edit the thread...

ihatehaxor · Sep 7, 2008

how do u forget?
if u make this dont u have to pick ur items?

Falzer · Sep 7, 2008

Ok... I'll edit the thread to show some of the stuff in it. Happy?

ihatehaxor · Sep 7, 2008

lol
yes i am happy now

Falzer · Sep 7, 2008

There. I edited it.

I'll remember more later. And I'll update later too.

ihatehaxor · Sep 7, 2008

lol.
thanks for putting my name up there xP
I AM FAMOUS

CarterFTWWW · Sep 7, 2008

Meh.It'll help people with real high rates server, the ones that are like Kill a snail.lvl 200, rebirth

Falzer · Sep 7, 2008

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...)

RMZero213 · Sep 7, 2008

You can't use Andy, did you even test this.

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

Master Summoner

Attachments

Newbie Spellweaver

🚫

Master Summoner

Newbie Spellweaver

Master Summoner

Custom Title Activated

Master Summoner

Custom Title Activated

Master Summoner

Custom Title Activated

Master Summoner

Custom Title Activated

Master Summoner

Custom Title Activated

Master Summoner

Custom Title Activated

*

Master Summoner

Master Summoner

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners