[RELEASE]All Potions and Foods and Antidotes - RaGEZONE

natkemon · 09-10-2008

This is my first post, I hope its useful. If there are anything u want added or is missing, tell me!

I got slacked a bit and made most prices 15k. Sorry about that.

This is all Potions and Food and Antidotes in MIA. You can change the npc by scrolling to the very bottom and look for where it says "(99001, 9010002);". Change 9010002 to whatever npc u want.

INSTRUCTIONS
1.Copy and paste this in notepad
2.Save ______.sql
3.Go to MYSQL and Open script and find the file you saved it under.
4.Execute

Code:

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000005, 15000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002019, 15000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002025, 15000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000010, 15000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000003, 15000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002009, 15000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002000, 15000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000004, 15000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000012, 15000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002015, 15000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002023, 15000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002026, 15000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002022, 15000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002021, 15000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2001001, 15000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002007, 15000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002002, 15000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002020, 15000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000006, 15000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000011, 15000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000008, 15000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000001, 15000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002011, 15000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2001002, 15000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000007, 15000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000000, 15000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002008, 15000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002005, 15000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002024, 15000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002010, 15000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002001, 15000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002016, 15000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002017, 15000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002006, 15000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002004, 15000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2001000, 15000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2000009, 15000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002018, 15000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2002003, 15000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2050004, 15000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2050001, 15000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2050003, 15000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2050002, 15000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022180, 15000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010000, 15000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022089, 15000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022**** 15000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022123, 15000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022079, 15000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022284, 15000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20221*** 15000, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022147, 15000, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022311, 15000, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20220*** 15000, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022156, 15000, 53);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022087, 15000, 54);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022090, 100000000, 55);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022091, 100000000, 56);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022092, 100000000, 57);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022093, 100000000, 58);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022130, 15000, 59);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022088, 15000, 60);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022107, 15000, 61);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022144, 15000, 62);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022098, 15000, 63);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022051, 15000, 64);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020002, 15000, 65);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022033, 15000, 66);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020027, 15000, 67);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022145, 15000, 68);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022275, 15000, 69);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022151, 75000000, 70);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022152, 75000000, 71);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022153, 75000000, 72);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020016, 15000, 73);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022190, 15000, 74);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022056, 15000, 75);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022094, 15000, 76);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020028, 15000, 77);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020024, 60000000, 78);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020019, 15000, 79);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020018, 15000, 80);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022310, 15000, 81);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022276, 15000, 82);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022120, 15000, 83);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022062, 15000, 84);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20220*** 15000, 85);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022002, 15000, 86);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020031, 15000, 87);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022077, 15000, 88);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022076, 15000, 89);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022078, 15000, 90);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022047, 15000, 91);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022031, 15000, 92);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022042, 15000, 93);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020029, 15000, 94);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022063, 15000, 95);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022262, 15000, 96);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022182, 15000, 97);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022014, 15000, 98);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022023, 15000, 99);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022155, 15000, 100);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2012000, 15000, 101);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2012003, 15000, 102);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020007, 15000, 103);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022058, 15000, 104);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022242, 15000, 105);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010002, 15000, 106);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022175, 15000, 107);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2012001, 15000, 108);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020008, 15000, 109);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022185, 15000, 110);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022022, 15000, 111);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022021, 15000, 112);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022183, 15000, 113);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022072, 15000, 114);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020001, 15000, 115);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20220*** 15000, 116);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022041, 15000, 117);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022064, 15000, 118);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022043, 15000, 119);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022121, 15000, 120);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022131, 15000, 121);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020010, 15000, 122);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022264, 15000, 123);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010009, 15000, 124);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022066, 15000, 125);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022248, 15000, 126);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022**** 15000, 127);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022189, 15000, 128);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020004, 15000, 129);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022005, 15000, 130);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022**** 15000, 131);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022153, 15000, 132);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022245, 15000, 133);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010005, 15000, 134);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022108, 75000000, 135);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020005, 15000, 136);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020006, 15000, 137);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20220*** 15000, 138);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022127, 25000000, 139);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022129, 25000000, 140);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022128, 25000000, 141);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022126, 25000000, 142);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022125, 25000000, 143);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022053, 15000, 144);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022308, 15000, 145);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022019, 15000, 146);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022018, 15000, 147);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022020, 15000, 148);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022071, 15000, 149);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022194, 15000, 150);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010004, 15000, 151);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022060, 15000, 152);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022278, 15000, 153);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022124, 50000000, 154);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022239, 50000000, 155);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022240, 50000000, 156);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022177, 15000, 157);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022184, 15000, 158);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022035, 15000, 159);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022251, 15000, 160);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022016, 15000, 161);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022195, 15000, 162);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022271, 15000, 163);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20220*** 15000, 164);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022263, 15000, 165);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022102, 15000, 166);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022143, 15000, 167);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010001, 15000, 168);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020012, 15000, 169);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022193, 15000, 170);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022238, 15000, 171);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022142, 15000, 172);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022075, 15000, 173);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022164, 15000, 174);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022015, 15000, 175);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022282, 15000, 176);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020021, 15000, 177);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022039, 15000, 178);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022045, 15000, 179);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022044, 15000, 180);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022048, 15000, 181);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022179, 15000, 182);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022074, 15000, 183);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010003, 15000, 184);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022250, 15000, 185);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020009, 15000, 186);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022061, 15000, 187);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022116, 15000, 188);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022146, 15000, 189);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022054, 15000, 190);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022055, 15000, 191);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022154, 15000, 192);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022149, 15000, 193);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022148, 15000, 194);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020025, 15000, 195);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022037, 15000, 196);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020003, 15000, 197);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2011000, 15000, 198);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010006, 15000, 199);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022176, 15000, 200);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022306, 15000, 201);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022113, 15000, 202);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022246, 15000, 203);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022000, 15000, 204);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022249, 15000, 205);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022017, 15000, 206);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022001, 15000, 207);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022069, 15000, 208);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022086, 15000, 209);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022247, 15000, 210);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022106, 15000, 211);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020013, 15000, 212);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022038, 15000, 213);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022052, 15000, 214);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022006, 15000, 215);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022050, 15000, 216);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022030, 15000, 217);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2010007, 15000, 218);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022198, 15000, 219);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20221*** 15000, 220);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022224, 15000, 221);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022225, 15000, 222);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022226, 15000, 223);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022227, 15000, 224);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022228, 15000, 225);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020000, 15000, 226);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2012002, 15000, 227);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022150, 15000, 228);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022272, 15000, 229);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022244, 15000, 230);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022265, 15000, 231);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022186, 15000, 232);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022004, 15000, 233);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022**** 15000, 234);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022243, 15000, 235);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022307, 15000, 236);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022273, 15000, 237);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022049, 15000, 238);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020026, 15000, 239);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020017, 15000, 240);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022261, 15000, 241);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022166, 15000, 242);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022283, 15000, 243);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022274, 15000, 244);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022277, 15000, 245);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022014, 15000, 246);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022015, 15000, 247);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022191, 15000, 248);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022013, 15000, 249);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022012, 15000, 250);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022025, 15000, 251);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022024, 15000, 252);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022305, 15000, 253);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022103, 15000, 254);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022**** 15000, 255);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022057, 15000, 256);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022119, 15000, 257);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022023, 15000, 258);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022009, 15000, 259);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022011, 15000, 260);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022007, 15000, 261);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022010, 15000, 262);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022008, 15000, 263);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022003, 15000, 264);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022028, 15000, 265);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022029, 15000, 266);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022030, 15000, 267);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022181, 100000000, 268);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020011, 15000, 269);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022192, 15000, 270);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20221*** 15000, 271);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 20221*** 15000, 272);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022200, 15000, 273);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020020, 15000, 274);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2020022, 15000, 275);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022174, 15000, 276);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022026, 15000, 277);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022027, 15000, 278);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022068, 15000, 279);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022065, 15000, 280);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(99001, 9010002);

Credits to Natkemon (ME!)

KillShadow05 · 09-10-2008

Just to warn ya, your probably gonna get flammed by many people saying its already been done.

Just ignore it lol.

natkemon · 09-10-2008

Yeh i've noticed.

chuayaowei · 09-10-2008

Holy crap. It's the complete list yes? You're so hardworking.

Thanks for this, Nice release =)

shajal · 09-10-2008

lol nice i guess but thats a lot but thnx

Ridiculous · 09-10-2008

Nice work bro, it can be handy for most people.

Pokerman · 09-10-2008

haha thats awesome.

LoOpEd · 09-10-2008

this is a bit useless... cuz.. the rates are high and each level u get a re fill... But nice...

**Ace** · 09-10-2008

well.
the biggest shop or w.e its called has all this.
so its not really useful at all

xblackcat · 09-10-2008

Been released many times before

**Roamer** · 09-10-2008

Give him some props
..
Nice release bud, now go make a fresh never-released sql.

natkemon · 09-15-2008

I Need ideas for new release!!

shadowerr · 09-15-2008

lol .. it's nice though for high level fighting boss like horntail

ClericKn1ght · 09-15-2008

Nice work and good release althought its been released be4, This might be better than the previous

natkemon · 09-16-2008

Code:

Nice work and good release althought its been released be4, This might be better than the previous

Well, this is WAY better then the previoius..

natkemon · 09-25-2008

bump*

**ch1nkayy** · 09-25-2008

cool nice thanks.

XxOsirisxX · 09-25-2008

you bump and ch1nkayy says "thanks you" on every thread.. what a spammers.

chuayaowei · 09-25-2008

Yea i totally agree. stop spamming

natkemon · 09-26-2008

I'm spamming?

DkWar · 09-26-2008

by saying "Im spamming?" is a spam..

anyways a thumbs up for effort =D keep working and become a great sql editor

shocka98 · 10-14-2008

does anything have to be done to the npc's script? or it works as long as its not a quest npc..?

**Ace** · 10-15-2008

no.
u just put that script in ur mysql and execute