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

[michaelhuynh02]

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.









The Sql since alot of u cant download it.

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

[MentaL]

[DaichiKokujo]

Mind telling us whats in the custom shop?

[michaelhuynh02]

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

[Zinic]

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

[Savage]

Post some more pics and more details.

[michaelhuynh02]

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

EDIT:Just added the screenshots

[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

[iSecks]

What server is this for?

[stapled]

What server is this for?

Odin

[michaelhuynh02]

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?

[Iownyoujk]

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

[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

[michaelhuynh02]

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!

[michaelhuynh02]

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

THXS XD

[RMZero213]

THXS XD

Loldoublepost.

[skylite]

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

[SBTGms]

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

[_Maple_]

Thats tight!

[michaelhuynh02]

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

Sure hold on

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)

[zequanong]

zzzzz

[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?

[cheesybacon]

found this in the SQL lol

[megoesrawr]

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

[narvin]

found this in the SQL lol

ahahaha GG

and how did you get yoko yoko there? O_O

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