- Joined
- Jul 20, 2008
- Messages
- 147
- Reaction score
- 5
I think this has already been posted, but who cares, i created a neater version. If any problems just tell me!
Scroll down to the bottom and find this "(99002, 9030000);". Change 9030000(federick) to whatever NPC you 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
Credits Natkemon (ME!)
Scroll down to the bottom and find this "(99002, 9030000);". Change 9030000(federick) to whatever NPC you 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 (99002, 2100017, 150000000, 0);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101043, 150000000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101044, 150000000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101045, 150000000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101046, 150000000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101047, 150000000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101048, 150000000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101049, 150000000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101057, 150000000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100000, 150000000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100014, 150000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100016, 150000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101050, 150000000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101051, 150000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101052, 150000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101053, 150000000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101054, 150000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101055, 150000000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101056, 150000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101020, 150000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102000, 150000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102001, 150000000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102002, 150000000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102003, 150000000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102004, 150000000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102005, 150000000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102006, 150000000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102007, 150000000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102008, 150000000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2102009, 150000000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101072, 150000000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101073, 150000000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101021, 150000000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101026, 150000000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101023, 150000000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101025, 150000000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101024, 150000000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100001, 150000000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100035, 150000000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100036, 150000000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100002, 150000000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100003, 150000000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100004, 150000000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100005, 150000000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100006, 150000000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100007, 150000000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100033, 150000000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100034, 150000000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101080, 150000000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101089, 150000000, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101090, 150000000, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101091, 150000000, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101092, 150000000, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101093, 150000000, 53);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101081, 150000000, 54);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101082, 150000000, 55);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101083, 150000000, 56);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101084, 150000000, 57);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101085, 150000000, 58);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101086, 150000000, 59);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101087, 150000000, 60);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101088, 150000000, 61);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101039, 150000000, 62);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101052, 150000000, 63);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100020, 150000000, 64);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100021, 150000000, 65);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100022, 150000000, 66);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100023, 150000000, 67);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100024, 150000000, 68);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100025, 150000000, 69);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100026, 150000000, 70);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100027, 150000000, 71);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101012, 150000000, 72);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101010, 150000000, 73);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101015, 150000000, 74);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101011, 150000000, 75);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101014, 150000000, 76);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101009, 150000000, 77);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100053, 150000000, 78);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100054, 150000000, 79);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100055, 150000000, 80);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100056, 150000000, 81);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100057, 150000000, 82);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100058, 150000000, 83);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100059, 150000000, 84);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101013, 150000000, 85);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100010, 150000000, 86);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100043, 150000000, 87);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100012, 150000000, 88);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100015, 150000000, 89);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101001, 150000000, 90);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100013, 150000000, 91);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101008, 150000000, 92);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100044, 150000000, 93);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100029, 150000000, 94);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100030, 150000000, 95);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100011, 150000000, 96);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100031, 150000000, 97);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 21000*** 150000000, 98);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100041, 150000000, 99);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100047, 150000000, 100);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100051, 150000000, 101);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100046, 150000000, 102);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100045, 150000000, 103);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100050, 150000000, 104);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100049, 150000000, 105);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100048, 150000000, 106);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101007, 150000000, 107);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101000, 150000000, 108);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100009, 150000000, 109);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100042, 150000000, 110);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101004, 150000000, 111);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101005, 150000000, 112);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101006, 150000000, 113);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100008, 150000000, 114);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100028, 150000000, 115);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101002, 150000000, 116);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2101003, 150000000, 117);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100018, 150000000, 118);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (99002, 2100019, 150000000, 119);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(99002, 9030000);
Credits Natkemon (ME!)
Last edited: