Welcome!

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

Join Today!

[RELEASE]All Potions and Foods and Antidotes

Junior Spellweaver
Joined
Jul 20, 2008
Messages
147
Reaction score
5
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, 2022112, 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, 2022132, 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, 2022032, 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, 2022097, 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, 2022096, 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, 2022105, 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, 2022101, 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, 2022099, 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, 2022032, 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, 2022199, 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, 2022100, 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, 2022109, 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, 2022196, 15000, 271);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99001, 2022197, 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!)
 
Last edited:
Experienced Elementalist
Joined
Apr 6, 2008
Messages
296
Reaction score
3
Just to warn ya, your probably gonna get flammed by many people saying its already been done.

Just ignore it lol.
 
Supreme Arcanarch
Loyal Member
Joined
Jul 21, 2008
Messages
969
Reaction score
1
Holy crap. It's the complete list yes? You're so hardworking.

Thanks for this, Nice release =)
 
Elite Diviner
Loyal Member
Joined
Apr 30, 2008
Messages
414
Reaction score
0
Nice work bro, it can be handy for most people.
 
Banned
Banned
Joined
Aug 16, 2008
Messages
102
Reaction score
0
this is a bit useless... cuz.. the rates are high and each level u get a re fill... But nice...
 
Junior Spellweaver
Joined
Jul 6, 2008
Messages
180
Reaction score
0
lol .. it's nice though for high level fighting boss like horntail
 
Skilled Illusionist
Loyal Member
Joined
Jun 23, 2008
Messages
324
Reaction score
0
Nice work and good release althought its been released be4, This might be better than the previous
 
Junior Spellweaver
Joined
Jul 20, 2008
Messages
147
Reaction score
5
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..
 
Master Summoner
Loyal Member
Joined
Jul 27, 2008
Messages
583
Reaction score
0
you bump and ch1nkayy says "thanks you" on every thread.. what a spammers.
 
Back
Top