Custom gm shop All In One. Using Npc. Including lvl 1 to level highest Item!

Well most people released the customshop thing but theres is all seperated and kinda hard to use? Maybe its just my opinion.

Heres the download
NPC=http://www.mediafire.com/?h4jxyw2lgej
SQl=http://www.mediafire.com/?x4ymjlmimdj

Bugs: I think the cape and the other catagories thats in black dont work due to items i put in not being able to be shown so it wont work? Dont mind if u can fix this!

Credits=
Me(making the sql and npc)
Jeffrey(for giving the codes) Hes NOT a part of this site!
1993yan(for the codes and making it)

Note:Dont spam saying there is already on when there isnt one with all of them in on.Also this NPC is at the gm map (KIMAKIN)

Some ScreenShots.

NOTE: The NPC im am using is YokoYoko yours should be NimaKin the Gm NPC in the same map.

http://i260.photobucket.com/albums/i.../Maple0004.jpg

http://i260.photobucket.com/albums/i.../Maple0006.jpg

http://i260.photobucket.com/albums/i.../Maple0007.jpg

http://i260.photobucket.com/albums/i.../Maple0008.jpg

The Sql since alot of u cant download it.

Code:

---

/*SHOP*/

/*Made By Ichigo of ZeroMs
Odinms v55 ,Costum Shops*/
INSERT INTO shops VALUES (1994, 9201067);
INSERT INTO shops VALUES (2020, 9201067);
INSERT INTO shops VALUES (2021, 9201067);
INSERT INTO shops VALUES (2022, 9201067);
INSERT INTO shops VALUES (2023, 9201067);
INSERT INTO shops VALUES (2024, 9201067);
INSERT INTO shops VALUES (2025, 9201067);
INSERT INTO shops VALUES (1996, 9201067);
INSERT INTO shops VALUES (2026, 9201067);
INSERT INTO shops VALUES (2027, 9201067);
INSERT INTO shops VALUES (2028, 9201067);
INSERT INTO shops VALUES (2029, 9201067);
INSERT INTO shops VALUES (2030, 9201067);
INSERT INTO shops VALUES (2031, 9201067);
INSERT INTO shops VALUES (1993, 9201067);
INSERT INTO shops VALUES (1997, 9201067);
INSERT INTO shops VALUES (1998, 9201067);
INSERT INTO shops VALUES (1999, 9201067);
INSERT INTO shops VALUES (2000, 9201067);
INSERT INTO shops VALUES (2001, 9201067);
INSERT INTO shops VALUES (2002, 9201067);
INSERT INTO shops VALUES (2003, 9201067);
INSERT INTO shops VALUES (2004, 9201067);
INSERT INTO shops VALUES (2005, 9201067);
INSERT INTO shops VALUES (1995, 9201067);
INSERT INTO shops VALUES (2006, 9201067);
INSERT INTO shops VALUES (2007, 9201067);
INSERT INTO shops VALUES (2008, 9201067);
INSERT INTO shops VALUES (2009, 9201067);
INSERT INTO shops VALUES (2010, 9201067);
INSERT INTO shops VALUES (2011, 9201067);
INSERT INTO shops VALUES (2012, 9201067);
INSERT INTO shops VALUES (2013, 9201067);
INSERT INTO shops VALUES (2014, 9201067);
INSERT INTO shops VALUES (2015, 9201067);
INSERT INTO shops VALUES (2016, 9201067);
INSERT INTO shops VALUES (2017, 9201067);
INSERT INTO shops VALUES (2018, 9201067);
INSERT INTO shops VALUES (2019, 9201067);
INSERT INTO shops VALUES (2032, 9201067);
INSERT INTO shops VALUES (2033, 9201067);
INSERT INTO shops VALUES (2034, 9201067);
INSERT INTO shops VALUES (2035, 9201067);

/*BOWMAN*/

/* Arrows */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060000, 1, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2061000, 1, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060001, 100, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2061001, 100, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060002, 250, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060002, 250, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060003, 500, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2061003, 500, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2060004, 500, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2025, 2061004, 500, 10);
/* Bows */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452054, 9999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452016, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452055, 699999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452022, 750000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452008, 900000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452023, 1800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452053, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452004, 2000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452045, 2500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452018, 3500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452009, 4500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452010, 4500000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452011, 4500000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452052, 5500000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452012, 6500000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452013, 6500000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452014, 6500000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452015, 6500000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452056, 9000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452017, 40000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452025, 40000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452026, 40000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452019, 50000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452020, 50000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452021, 50000000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2023, 1452044, 90000000, 26);
/* Crossbow */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462047, 9999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462014, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462048, 1200000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462019, 1500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462007, 2000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462008, 4000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462040, 6500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462009, 7000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462046, 9000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462010, 12000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462011, 12000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462012, 12000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462013, 12000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462049, 16000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462018, 18000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462021, 18000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462022, 18000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462015, 50000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462016, 50000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462017, 50000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2024, 1462039, 100000000, 21);
/* Gloves */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082083, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082084, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082085, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082089, 700000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082090, 700000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082091, 700000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082106, 900000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082107, 900000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082108, 900000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082109, 1200000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082110, 1200000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082111, 1200000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082112, 1200000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082125, 1600000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082126, 1600000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082127, 1600000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082158, 2400000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082159, 2400000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082160, 2400000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2021, 1082163, 15000000, 20);
/* Hats */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002211, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002212, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002213, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002214, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002267, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002268, 600000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002269, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002270, 600000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002286, 700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002287, 700000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002288, 700000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002289, 700000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002275, 850000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002276, 850000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002277, 850000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002278, 850000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002402, 950000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002403, 950000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002404, 950000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002405, 950000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002406, 1500000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002407, 1500000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002408, 1500000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2022, 1002547, 15000000, 24);
/* Overall */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050051, 1000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050052, 1000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051037, 1000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051038, 1000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051039, 1000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050058, 3000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050059, 3000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050060, 3000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051041, 3000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051042, 3000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051043, 3000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050061, 5000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050062, 5000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050063, 5000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050064, 5000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051062, 5000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051063, 5000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051064, 5000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051065, 5000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050075, 8000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050076, 8000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050077, 8000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050078, 8000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051066, 8000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051067, 8000000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051068, 8000000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051069, 8000000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050088, 12000000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050089, 12000000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050090, 12000000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050091, 12000000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051082, 12000000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051083, 12000000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051084, 12000000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051085, 12000000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050106, 18000000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050107, 18000000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1050108, 18000000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051105, 18000000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051106, 18000000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1051107, 18000000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2020, 1052071, 45000000, 42);
/* Shoes */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072122, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072123, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072124, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072125, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072144, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072145, 600000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072146, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072164, 700000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072165, 700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072166, 700000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072167, 700000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072182, 800000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072183, 800000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072184, 800000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072185, 800000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072203, 900000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072204, 900000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072205, 900000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072227, 1200000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072228, 1200000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1994, 1072229, 1200000, 21);

/*MAGE*/

/* Gloves */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082080, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082081, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082082, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082086, 1000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082087, 1000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082088, 1000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082098, 2000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082099, 2000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082100, 2000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082121, 4000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082122, 4000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082123, 4000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082131, 6000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082132, 6000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082133, 6000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082134, 6000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082151, 8000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082152, 8000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082153, 8000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082154, 8000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2027, 1082164, 18000000, 21);
/* Hats */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002215, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002216, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002217, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002218, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002242, 900000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002243, 900000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002244, 900000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002245, 900000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002246, 900000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002252, 1500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002253, 1500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002254, 1500000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002271, 2000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002272, 2000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002273, 2000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002274, 2000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002363, 4000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002364, 4000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002365, 4000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002366, 4000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002398, 8000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002399, 8000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002400, 8000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2028, 1002401, 8000000, 24);
/* Overalls */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050045, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050046, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050047, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050048, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050049, 500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051030, 500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051031, 500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051032, 500000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051033, 500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051034, 500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050053, 1000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050054, 1000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050055, 1000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050056, 1000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051044, 1000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051045, 1000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051046, 1000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051047, 1000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050067, 2000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050068, 2000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050069, 2000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050070, 2000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051052, 2000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051053, 2000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051054, 2000000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051055, 2000000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050072, 4000000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050073, 4000000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050074, 4000000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051056, 4000000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051057, 4000000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051058, 4000000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050092, 8000000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050093, 8000000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050094, 8000000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050095, 8000000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051094, 8000000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051095, 8000000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051096, 8000000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051097, 8000000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050102, 16000000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050103, 16000000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050104, 16000000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1050105, 16000000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051101, 16000000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051102, 16000000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051103, 16000000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1051104, 16000000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2026, 1052076, 50000000, 49);
/* Shields */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2029, 1092021, 2500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2029, 1092029, 7500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2029, 1092045, 10000000, 3);
/* Shoes */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072140, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072141, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072142, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072143, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072136, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072137, 600000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072138, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072139, 600000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072157, 700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072158, 700000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072159, 700000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072160, 700000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072177, 800000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072178, 800000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072179, 800000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072206, 900000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072207, 900000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072208, 900000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072209, 900000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072223, 1800000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072224, 1800000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072225, 1800000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072226, 1800000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1996, 1072268, 15000000, 24);
/* Staffs */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382015, 600000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382009, 900000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382055, 1400000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382012, 1800000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382041, 2500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382011, 4000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382014, 6000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382006, 8000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382039, 9000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382007, 10000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382053, 15000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382010, 18000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382056, 20000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382008, 25000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382016, 28000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382035, 35000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382037, 55000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2031, 1382036, 100000000, 18);
/* Wands */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372017, 600000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372007, 1200000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372011, 1800000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372033, 2500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372014, 4500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372008, 6500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372034, 8000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372016, 10000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372009, 20000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372010, 60000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2030, 1372032, 100000000, 11);

/*THIEF*/

/* Shoes */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072128, 499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072129, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072130, 499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072131, 499999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072150, 599999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072151, 599999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072152, 599999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072161, 699999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072162, 699999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072163, 699999, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072172, 799999, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072173, 799999, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072174, 799999, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072192, 899999, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072193, 899999, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072194, 899999, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072195, 899999, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072213, 999999, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072214, 999999, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072215, 999999, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072216, 999999, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1993, 1072272, 14999999, 22);
/* Bottom */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060083, 499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060084, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060085, 499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060086, 499999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061076, 499999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061077, 499999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061078, 499999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061079, 499999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060087, 599999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060088, 599999, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060089, 599999, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061093, 599999, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061094, 599999, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061095, 599999, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060093, 699999, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060094, 699999, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060095, 699999, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061099, 699999, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061100, 699999, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061101, 699999, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061102, 699999, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060097, 799999, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060098, 799999, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060099, 799999, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061104, 799999, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061105, 799999, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061106, 799999, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060104, 899999, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060105, 899999, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060106, 899999, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1060107, 899999, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061114, 899999, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061115, 899999, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061116, 899999, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1997, 1061117, 899999, 35);
/* Tops */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040094, 499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040095, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040096, 499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040097, 499999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041077, 599999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041078, 599999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041079, 599999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041080, 599999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040098, 699999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040099, 699999, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040100, 699999, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041094, 699999, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041095, 699999, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041096, 699999, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040105, 799999, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040106, 799999, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040107, 799999, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041100, 799999, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041101, 799999, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041102, 799999, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041103, 799999, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040108, 899999, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040109, 899999, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040110, 899999, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041105, 899999, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041106, 899999, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041107, 899999, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040115, 999999, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040116, 999999, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040117, 999999, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1040118, 999999, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041115, 999999, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041116, 999999, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041117, 999999, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1998, 1041118, 999999, 35);
/* overalls */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1050096, 000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1050097, 4000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1050098, 4000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1050099, 4000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1051090, 4000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1051091, 4000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1051092, 4000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1051093, 4000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1999, 1052072, 9499999, 9);
/* Gloves */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082065, 499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082066, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082067, 499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082092, 599999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082093, 599999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082094, 599999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082095, 699999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082096, 699999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082097, 699999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082118, 799999, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082119, 799999, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082120, 799999, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082142, 899999, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082143, 899999, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082144, 899999, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082135, 999999, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082136, 999999, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082137, 999999, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082138, 999999, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2000, 1082167, 1499999, 20);
/* Hats */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002209, 499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002210, 499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002247, 599999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002248, 599999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002249, 599999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002656, 599999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002281, 699999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002282, 699999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002283, 699999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002284, 699999, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002285, 699999, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002327, 799999, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002328, 799999, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002329, 799999, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002330, 799999, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002323, 899999, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002324, 899999, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002325, 899999, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002326, 899999, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002380, 999999, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002381, 999999, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002382, 999999, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002383, 999999, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2001, 1002550, 1499999, 24);
/* Shields */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092018, 2499999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092019, 2499999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092020, 7499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092047, 8000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092050, 10000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2002, 1092049, 2000000, 6);
/* Daggers */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332067, 9999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332070, 9999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332068, 399999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332071, 399999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332025, 499999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332054, 499999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332029, 549999, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332015, 749999, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332017, 749999, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332055, 1500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332056, 1500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332030, 3000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332019, 4000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332018, 5000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332053, 6000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332022, 7000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332023, 8000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332072, 9000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332069, 12000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332026, 13000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332027, 14000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332051, 15000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332052, 16000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332049, 50000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2003, 1332050, 60000000, 25);
/* Claws */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472065, 999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472066, 399999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472018, 499999, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472019, 499999, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472020, 499999, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472021, 499999, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472064, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472054, 750000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472022, 2500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472023, 2500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472024, 2500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472025, 2500000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472055, 5000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472026, 8000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472027, 8000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472028, 8000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472029, 8000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472031, 15000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472067, 20000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472033, 25000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472053, 30000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472051, 50000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2004, 1472052, 60000000, 23);
/* Throwing Stars*/
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070000, 10000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070001, 250000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070008, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070002, 650000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070009, 650000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070012, 800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070013, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070003, 1650000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070010, 1700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070011, 2000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070004, 5000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070005, 15000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070006, 25000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070007, 35000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2005, 2070016, 50000000, 15);

/*WARRIOR*/

/* Bottom */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060076, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060077, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060078, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061086, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061087, 500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061088, 500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060079, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060080, 600000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060081, 600000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060082, 600000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061090, 600000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061091, 600000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061092, 600000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060090, 700000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060091, 700000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060092, 700000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061096, 800000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061097, 800000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061098, 800000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060100, 900000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060101, 900000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060102, 900000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061118, 900000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061119, 900000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061120, 900000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060109, 1500000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060110, 1500000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1060111, 1500000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061121, 1500000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061122, 1500000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2006, 1061123, 1500000, 31);
/* Gloves */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082009, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082010, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082011, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082059, 600000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082060, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082061, 600000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082103, 700000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082104, 700000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082105, 700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082114, 800000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082115, 800000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082116, 800000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082117, 800000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082128, 900000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082129, 900000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082130, 900000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082139, 1000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082140, 1000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082141, 1000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2009, 1082168, 8500000, 20);
/* Hats */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002028, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002085, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002086, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002029, 600000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002084, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002030, 700000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002094, 700000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002095, 700000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002338, 800000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002339, 800000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002340, 800000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002528, 900000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002529, 900000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002530, 900000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002531, 900000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002532, 900000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002377, 1500000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002378, 1500000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002379, 1500000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2010, 1002551, 8000000, 20);
/* One-handed Axe */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312008, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312032, 600000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312009, 700000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312010, 800000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312011, 1000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312015, 2500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312030, 50000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2012, 1312031, 90000000, 9);
/* One-handed BW */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322017, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322018, 600000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322019, 700000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322054, 900000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322028, 1000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322029, 1800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322045, 50000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2014, 1322052, 90000000, 8);
/* One- Handed Sword */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302010, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302011, 600000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302012, 700000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302018, 1000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302023, 1800000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302056, 50000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2016, 1302059, 90000000, 7);
/* Overall */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1050080, 5000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1050081, 5000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1050082, 5000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1050083, 5000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1051077, 5000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1051078, 5000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1051079, 5000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1051080, 5000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2008, 1052075, 10000000, 9);
/* Pole Arms */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442029, 9999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442018, 99999, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442004, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442011, 700000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442024, 900000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442025, 50000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442051, 7000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442008, 9000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442060, 15000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442019, 18000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442020, 27000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442026, 29000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442044, 55000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442045, 100000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2019, 1442002, 760000000, 15);
/* Shields */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092004, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092009, 1000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092010, 1000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092011, 1000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092015, 2000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092016, 2000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092017, 2000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092023, 5000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092024, 5000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092025, 5000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092026, 8000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092027, 8000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092028, 8000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2011, 1092042, 25000000, 14);
/* Shoes */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072132, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072133, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072134, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072135, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072147, 600000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072148, 600000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072149, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072154, 700000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072155, 700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072156, 700000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072210, 800000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072211, 800000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072212, 800000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072196, 900000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072197, 900000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072198, 900000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072220, 1600000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072221, 1600000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072222, 1600000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1995, 1072273, 15000000, 20);
/* Spears */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432015, 9999, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432009, 200000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432013, 400000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432016, 600000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432012, 750000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432017, 1000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432006, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432040, 1900000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432007, 4000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432045, 7000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432010, 9000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432018, 15000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432011, 25000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432030, 50000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2018, 1432038, 100000000, 15);
/* Tops */
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040087, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040088, 500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040089, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041087, 500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041088, 500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041089, 500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040090, 600000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040091, 600000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040092, 600000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040093, 600000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041091, 600000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041092, 600000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041093, 600000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040102, 700000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040103, 700000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040104, 700000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041097, 700000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041098, 700000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041099, 700000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040111, 800000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040112, 800000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040113, 800000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041119, 800000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041120, 800000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041121, 800000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040120, 1000000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040121, 1000000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1040122, 1000000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041122, 1000000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041123, 1000000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2007, 1041124, 1000000, 31);
/* Two-Handed Axe*/
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412003, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412007, 700000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412027, 800000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412008, 900000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412009, 1000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412010, 35000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412021, 50000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2013, 1412026, 90000000, 8);
/* Two-Handed Bw*/
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422005, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422009, 600000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422010, 700000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422012, 1000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422013, 1800000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422027, 50000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2015, 1422028, 90000000, 7);
/* Two-Handed Sword*/
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402044, 500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402029, 700000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402003, 900000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402013, 1500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402045, 5000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402011, 6000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402039, 7500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402012, 8500000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402004, 10000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402015, 10000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402005, 18000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402016, 22000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402035, 50000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402037, 50000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2017, 1402036, 10000000, 15);

/*CAPE*/

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES (2035,
1102000, 1, 1);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102001, 1, 2);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102002, 1,
3);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102003, 1,
4);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102004, 1,
5);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102005, 1,
6);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102007, 1,
8);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102008, 1,
9);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102009, 1,
10);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102010, 1,
11);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102011, 1,
12);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102012, 1,
13);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102013, 1,
14);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102014, 1,
15);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102015, 1,
16);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102016, 1,
17);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102017, 1, 18);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102018, 1, 19);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102019, 1, 20);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102020, 1, 21);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102021, 1, 22);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102022, 1, 23);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102023, 1, 24);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102024, 1, 25);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102025, 1, 26);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102026, 1, 27);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102027, 1, 28);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102028, 1, 29);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102029, 1, 30);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102030, 1, 31);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102031, 1, 32);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102032, 1, 33);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102033, 1, 34);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102034, 1, 35);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102035, 1, 36);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102036, 1, 37);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102037, 1, 38);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102038, 1, 39);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102039, 1, 40);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102040, 1, 41);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102041, 1, 42);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102042, 1, 43);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102043, 1, 44);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102044, 1, 45);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102045, 1, 46);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102046, 1, 47);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102047, 1, 48);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102048, 1, 49);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102049, 1, 50);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102050, 1, 51);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102051, 1, 52);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102052, 1, 53);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102053, 1, 54);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102054, 1, 55);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102055, 1, 56);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102056, 1, 57);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102058, 1, 59);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102059, 1, 60);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102060, 1, 61);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102061, 1, 62);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102062, 1, 63);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102063, 1, 64);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102064, 1, 65);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102065, 1, 66);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102066, 1, 67);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102067, 1, 68);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102068, 1, 69);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102069, 1, 70);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102070, 1, 71);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102071, 1, 72);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102072, 1, 73);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102073, 1, 74);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102074, 1, 75);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102075, 1, 76);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102076, 1, 77);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102077, 1, 78);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102078, 1, 79);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102079, 1, 80);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2035, 1102080, 1, 81);

/*CAPE2*/

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102081, 1, 82);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102082, 1, 83);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102084, 1, 85);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102085, 1, 86);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102086, 1, 87);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102087, 1, 88);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102088, 1, 89);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102089, 1, 90);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102090, 1, 91);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102091, 1, 92);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102092, 1, 93);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102093, 1, 94);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102094, 1, 95);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102095, 1, 96);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102096, 1, 97);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102097, 1, 98);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102098, 1, 99);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102099, 1, 100);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102100, 1, 101);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102101, 1, 102);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102102, 1, 103);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102103, 1, 104);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102104, 1, 105);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102105, 1, 106);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102106, 1, 107);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102107, 1, 108);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102108, 1, 109);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102109, 1, 110);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102110, 1, 111);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102111, 1, 112);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102112, 1, 113);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102113, 1, 114);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102114, 1, 115);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102115, 1, 116);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102116, 1, 117);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102117, 1, 118);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102118, 1, 119);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102119, 1, 120);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102120, 1, 121);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102121, 1, 122);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102122, 1, 123);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102123, 1, 124);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102124, 1, 125);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102125, 1, 126);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102126, 1, 127);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102127, 1, 128);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102128, 1, 129);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102129, 1, 130);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102130, 1, 131);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102131, 1, 132);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102132, 1, 133);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102133, 1, 134);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102134, 1, 135);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102135, 1, 136);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102136, 1, 137);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102137, 1, 138);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102138, 1, 139);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102139, 1, 140);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102140, 1, 141);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102141, 1, 142);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102142, 1, 143);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102143, 1, 144);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102144, 1, 145);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102145, 1, 146);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102146, 1, 147);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102147, 1, 148);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102148, 1, 149);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102149, 1, 150);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102150, 1, 151);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102151, 1, 152);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102152, 1, 153);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102153, 1, 154);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102154, 1, 155);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102155, 1, 156);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102156, 1, 157);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102157, 1, 158);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102158, 1, 159);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102159, 1, 160);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102160, 1, 161);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2032, 1102165, 1, 162);

/*EARINGS*/

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032001, 1, 1);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032002, 1, 2);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032003, 1, 3);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032004, 1, 4);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032005, 1, 5);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032006, 1, 6);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032007, 1, 7);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032008, 1, 8);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032009, 1, 9);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032010, 1, 10);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032011, 1, 11);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032012, 1, 12);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032013, 1, 13);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032014, 1, 14);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032015, 1, 15);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032016, 1, 16);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032017, 1, 17);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032018, 1, 18);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032019, 1, 19);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032020, 1, 20);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032021, 1, 21);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032022, 1, 22);
INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032023, 1, 23);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032024, 1, 24);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032025, 1, 25);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032026, 1, 26);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032027, 1, 27);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032028, 1, 28);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032029, 1, 29);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032030, 1, 30);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032031, 1, 31);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032032, 1, 32);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032033, 1, 33);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032034, 1, 34);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032035, 1, 35);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032036, 1, 36);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032037, 1, 37);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032038, 1, 38);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032039, 1, 39);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032040, 1, 40);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032041, 1, 41);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032042, 1, 42);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032043, 1, 43);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032044, 1, 44);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032045, 1, 45);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032046, 1, 46);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032047, 1, 47);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032048, 1, 48);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032049, 1, 49);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032050, 1, 50);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032051, 1, 51);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032052, 1, 52);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032053, 1, 53);

INSERT INTO shopitems
(shopid, itemid, price, position)
VALUES
(2033, 1032054, 1, 54);
 
/*NECKLACE*/

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122001, 1, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122002, 1, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122003, 1, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122004, 1, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122005, 1, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122006, 1, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2034, 1122007, 1, 8);

---

Mind telling us whats in the custom shop?

it has all item for all jobs like amour and wep! stuff like that.

Anything else? Is it well organized? Could you post a pic please?

Post some more pics and more details.

KK ill post some pics in a while and it is well organized.

EDIT:Just added the screenshots

dude when i click on nimakin it tells me all the weapon and armor and stuff but when i click on one it doesnt do nething, and it closes the window

What server is this for?

Quote:

---

Originally Posted by iSecks

What server is this for?

---

Odin

Quote:

---

Originally Posted by bruce8900012

dude when i click on nimakin it tells me all the weapon and armor and stuff but when i click on one it doesnt do nething, and it closes the window

---

Did you execute the sql in your database?

Thanks for this release dude! Beats having to seach for the code in notepad every time u want one!

U are such a nub and a leecher , U stole my work and tell ppl's u made it i bet u even cant make shop by urself
u can gave some REAL no fake credits at least >.>

Here is the proof: http://forum.ragezone.com/showthread.php?t=428136

Quote:

---

Originally Posted by 1993yan

U are such a nub and a leecher , U stole my work and tell ppl's u made it i bet u even cant make shop by urself
u can gave some REAL no fake credits at least >.>

Here is the proof: http://forum.ragezone.com/showthread.php?t=428136

---

Wtf a-hole i didnt steal your work, if i did it would have look the same and anyone who knows how to make a shop can make this douche! all it does is take time to do it! i used a program to generate the codes for the sql and the npc was easy. its almos the same thing over and over!
Plus mine is put in different! mine is organized by colors yours is not!

Quote:

---

Originally Posted by Iownyoujk

Thanks for this release dude! Beats having to seach for the code in notepad every time u want one!

---

THXS XD

Quote:

---

Originally Posted by michaelhuynh02

THXS XD

---

Loldoublepost.

well how do we get there? is there any map id to let us tele therE?

yeah please show a SS of examples of what is available in those shops.

Thats tight!

Quote:

---

Originally Posted by SBTGms

yeah please show a SS of examples of what is available in those shops.

---

Sure hold on

Quote:

---

Originally Posted by skylite

well how do we get there? is there any map id to let us tele therE?

---

its a gmmap if your gm, type (!goto gmmap) to go there im not sure of the map id,someone plz provide?(to lazy to look up XD)

zzzzz

Firstly, 1993yan your and his are different so don't be a noob

Secondly, the gm map id is 180000000

Thirdly, good release btw i can change the npc id correct?

found this in the SQL lol
Attachment 56859

luls so u copied pasta!
DIDNT EVEN GIVE CREDITS GG!
I hate leechers like you and then don't give credits

Quote:

---

Originally Posted by cheesybacon

found this in the SQL lol
Attachment 56859

---

ahahaha GG

and how did you get yoko yoko there? O_O

u think , u nub do u rly think u was thinking to have the same exactly Shop ID , Price Values? u just copied and pasted all my codes, u just used my sql and changed the npc's and outlay.

Quote:

---

Originally Posted by cheesybacon

found this in the SQL lol
Attachment 56859

---

lol who cant paste his name somewhere even my grandma still can

/* Shops */

/*Made By Grandma Of ZeroMs*/

Hey Can Any1 Please Post Here The Sql Text, Cause I Cant Download It.
Ty.

I would like to know yoko guy's position, x, y, rx0, rx1, fh and code. Thanks

I cant Download The SQL Please Sumone Post It Or Reupload It If U Have It

Quote:

---

Originally Posted by DkWar

Firstly, 1993yan your and his are different so don't be a noob

Secondly, the gm map id is 180000000

Thirdly, good release btw i can change the npc id correct?

---

ths and yeah u can change teh npc id.

Quote:

---

Originally Posted by 1993yan

u think , u nub do u rly think u was thinking to have the same exactly Shop ID , Price Values? u just copied and pasted all my codes, u just used my sql and changed the npc's and outlay.

---

i guess it was your since i got the codes from jeffrey? ill give credit srry thought it was his?

Quote:

---

Originally Posted by narvin

ahahaha GG

and how did you get yoko yoko there? O_O

---

heres a guide
http://forum.ragezone.com/showthread.php?t=425262

Quote:

---

Originally Posted by AsianBoy

I would like to know yoko guy's position, x, y, rx0, rx1, fh and code. Thanks

---

<imgdir name="0">
<string name="type" value="n"/>
<string name="id" value="9120023"/>
<int name="x" value="119"/>
<int name="y" value="-205"/>
<int name="mobTime" value="0"/>
<int name="f" value="0"/>
<int name="fh" value="9"/>
<int name="cy" value="-205"/>
<int name="rx0" value="169"/>
<int name="rx1" value="69"/>
</imgdir>

Quote:

---

Originally Posted by cheesybacon

found this in the SQL lol
Attachment 56859

---

One word owned.

can sumone upload the sql cuz his link dont work

or post the code

Quote:

---

Originally Posted by TeamH

can sumone upload the sql cuz his link dont work

or post the code

---

just did

I might be adding this

Yours is broken. I used your script and I fixed it :)

Well, i cant use casue EVERY SINGLE SHOP ID you used is already taken -.- sigh, and im not modding the sql shops it would take hours XD looks good tho..

you can change the shopIDs all at once with Notepad++ just press Ctrl + F pick the replace tab, type in what you want to replace (the shopID) and what you want to replace it with (your shopID of choice) then pick replace all. takes about 30 seconds tops lol