[ReleasE]4-in-1 --Ultimate-- Simple -- Shops (Including GM)

iAmALaker · Aug 22, 2008

Hey Guys, this is a Chair, Scroll, GM, and Star Shop in 1 SQL:

Chair: Mr MoneyBags (Henesys Next to Mia's House)

Scrolls: Spieglmann (Many Scrolls) (He is in Orbis)

GM Shop: Henesys Manekineko (Go to Your GM Map and Use the command: !npc 9100001 )

Star: JM from the Street (Kerning)

------------------------->
GUIDE
<------------------------

Open Up MYSQL, Click on File --> New Script Tab

Copy and Paste the script in, and click execute!~

SIMPLE?

Code:

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010000, 2500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010004, 2500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010005, 2500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010015, 2500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010011, 2500000, 5); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010001, 2500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010002, 2500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010003, 2500000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010006, 2500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010007, 2500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010008, 2500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010010, 2500000, 12); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010009, 2500000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010012, 2500000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010014, 2500000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3011000, 5000000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1339, 3010013, 5000000, 17);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1339, 9300010);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070000, 10000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070001, 250000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070008, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070002, 650000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070009, 650000, 5); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070012, 800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070013, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070003, 1650000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070010, 1700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070011, 2000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070004, 5000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070005, 15000000, 12); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070006, 25000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070007, 35000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070016, 50000000, 15);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1340, 1052002);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1002140, 1, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1042003, 1, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1062007, 1, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1322013, 1, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1072010, 1, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2022179, 1, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2022273, 1, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 5072000, 1, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 5390000, 1, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 5390001, 1, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 5390001, 1, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1452044, 1, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1472052, 1, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1462039, 1, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1332050, 1, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1312031, 1, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1322052, 1, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1302059, 1, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1442045, 1, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1432038, 1, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1382036, 1, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1412026, 1, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1422028, 1, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1402036, 1, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1122000, 1, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2041200, 1, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 4006001, 1, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 4001017, 1, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 4031179, 1, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1912000, 1, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1902000, 1, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1902001, 1, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 1902002, 1, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044503, 1, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044703, 1, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044603, 1, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043303, 1, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043103, 1, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043203, 1, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043003, 1, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044403, 1, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044303, 1, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043803, 1, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044103, 1, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044203, 1, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2044003, 1, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2043703, 1, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040807, 1, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040806, 1, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040007, 1, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040506, 1, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040710, 1, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337, 2040711, 1, 53);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1337, 9100001);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040002, 2500000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040005, 2500000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040016, 2500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040100, 2500000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040105, 2500000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040200, 2500000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040205, 2500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040302, 2500000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040310, 2500000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040402, 2500000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040412, 2500000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040502, 2500000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040505, 2500000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040514, 2500000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040517, 2500000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040602, 2500000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040612, 2500000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040702, 2500000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040705, 2500000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040708, 2500000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040802, 2500000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040805, 2500000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040816, 2500000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040902, 2500000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040915, 2500000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040920, 2500000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041002, 2500000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041005, 2500000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041008, 2500000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041011, 2500000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041014, 2500000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041017, 2500000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041020, 2500000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041023, 2500000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043002, 2500000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043008, 2500000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043102, 2500000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043202, 2500000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043302, 2500000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043702, 2500000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043802, 2500000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044002, 2500000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044102, 2500000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044202, 2500000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044302, 2500000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044402, 2500000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044502, 2500000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044602, 2500000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044702, 2500000, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2048002, 2500000, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2048005, 2500000, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040009, 2500000, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040011, 2500000, 53);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040013, 2500000, 54);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040015, 2500000, 55);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040103, 2500000, 56);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040108, 2500000, 57);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040203, 2500000, 58);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040208, 2500000, 59);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040305, 2500000, 60);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040307, 2500000, 61);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040309, 2500000, 62);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040405, 2500000, 63);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040407, 2500000, 64);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040409, 2500000, 65);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040411, 2500000, 66);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040509, 2500000, 67);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040511, 2500000, 68);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040519, 2500000, 69);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040521, 2500000, 70);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040605, 2500000, 71);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040607, 2500000, 72);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040609, 2500000, 73);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040611, 2500000, 74);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040713, 2500000, 75);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040715, 2500000, 76);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040717, 2500000, 77);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040809, 2500000, 78);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040811, 2500000, 79);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040813, 2500000, 80);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040815, 2500000, 81);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040905, 2500000, 82);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040907, 2500000, 83);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040909, 2500000, 84);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040917, 2500000, 85);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040922, 2500000, 86);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041027, 2500000, 87);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041029, 2500000, 88);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041031, 2500000, 89);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041033, 2500000, 90);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041035, 2500000, 91);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041037, 2500000, 92);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041039, 2500000, 93);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041041, 2500000, 94);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043005, 2500000, 95);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043007, 2500000, 96);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043105, 2500000, 97);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043205, 2500000, 98);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043305, 2500000, 99);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043705, 2500000, 100);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043805, 2500000, 101);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044005, 2500000, 102);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044105, 2500000, 103);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044205, 2500000, 104);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044305, 2500000, 105);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044405, 2500000, 106);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044505, 2500000, 107);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044605, 2500000, 108);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044705, 2500000, 109);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040001, 2500000, 110);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040004, 2500000, 111);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040017, 2500000, 112);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040101, 2500000, 113);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040106, 2500000, 114);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040201, 2500000, 115);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040206, 2500000, 116);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040301, 2500000, 117);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040311, 2500000, 118);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040401, 2500000, 119);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040413, 2500000, 120);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040501, 2500000, 121);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040504, 2500000, 122);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040513, 2500000, 123);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040516, 2500000, 124);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040601, 2500000, 125);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040613, 2500000, 126);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040701, 2500000, 127);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040704, 2500000, 128);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040707, 2500000, 129);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040801, 2500000, 130);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040804, 2500000, 131);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040817, 2500000, 132);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040901, 2500000, 133);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040914, 2500000, 134);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040919, 2500000, 135);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041001, 2500000, 136);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041004, 2500000, 137);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041007, 2500000, 138);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041010, 2500000, 139);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041013, 2500000, 140);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041016, 2500000, 141);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041019, 2500000, 142);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041022, 2500000, 143);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043001, 2500000, 144);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043009, 2500000, 145);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043101, 2500000, 146);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043201, 2500000, 147);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043301, 2500000, 148);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043701, 2500000, 149);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043801, 2500000, 150);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044001, 2500000, 151);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044101, 2500000, 152);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044201, 2500000, 153);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044301, 2500000, 154);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044401, 2500000, 155);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044501, 2500000, 156);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044601, 2500000, 157);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044701, 2500000, 158);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2048001, 2500000, 159);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2048004, 2500000, 160);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040008, 2500000, 161);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040010, 2500000, 162);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040012, 2500000, 163);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040014, 2500000, 164);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040104, 2500000, 165);
alter table characters alter column gm set default 1;
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040109, 2500000, 166);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040204, 2500000, 167);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040209, 2500000, 168);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040304, 2500000, 169);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040306, 2500000, 170);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040308, 2500000, 171);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040404, 2500000, 172);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040406, 2500000, 173);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040408, 2500000, 174);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040410, 2500000, 175);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040508, 2500000, 176);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040510, 2500000, 177);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040518, 2500000, 178);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040520, 2500000, 179);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040604, 2500000, 180);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040606, 2500000, 181);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040608, 2500000, 182);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040610, 2500000, 183);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040712, 2500000, 184);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040714, 2500000, 185);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040716, 2500000, 186);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040808, 2500000, 187);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040810, 2500000, 188);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040812, 2500000, 189);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040814, 2500000, 190);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040904, 2500000, 191);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040906, 2500000, 192);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040908, 2500000, 193);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040916, 2500000, 194);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2040921, 2500000, 195);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041026, 2500000, 196);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041028, 2500000, 197);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041030, 2500000, 198);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041032, 2500000, 199);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041034, 2500000, 200);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041036, 2500000, 201);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041038, 2500000, 202);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2041040, 2500000, 203);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043004, 2500000, 204);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043006, 2500000, 205);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043104, 2500000, 206);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043204, 2500000, 207);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043304, 2500000, 208);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043704, 2500000, 209);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2043804, 2500000, 210);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044004, 2500000, 211);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044104, 2500000, 212);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044204, 2500000, 213);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044304, 2500000, 214);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044404, 2500000, 215);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044504, 2500000, 216);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044604, 2500000, 217);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (65, 2044704, 2500000, 218);
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(65, 2042002);

OmgItsParm · Aug 22, 2008

Re: 4-in-1 --Ultimate-- Simple -- Shops (Including GM)

[Release] tag.

urtime59 · Aug 22, 2008

ooh sweet i was looking for this

ClericKn1ght · Aug 22, 2008

GReat Release, Keep it up XD

Gmanpopinjay · Aug 22, 2008

Nice Release Mate =P I Have something like this on my server already =)

thisisakevin · Aug 22, 2008

Clysse · Aug 22, 2008

Simple, But Effective

Great job on this

urtime59 · Aug 22, 2008

Scroll shop includes the wierd 15, 45, 60%'s?

ANBUItachi · Aug 22, 2008

I think this is in PCMaple SQLs
You Just Put it in 1 SQL
>_>

Mgssidley · Aug 22, 2008

This is a Re-Release T.T EXACT same as PCMaple like Itachi said.

OK for sure the GM Shop is the same because you used shop number 1337 and thats what Sean used.

kingdomtroy · Aug 22, 2008

Good job, but I spotted this in your sql script:

Code:

alter table characters alter column gm set default 1;

The default is zero, by setting it to 1, every new character will be GM!

Try to conceal better it next time!:2gunsfiring_v1::busted_co

Stuffa · Aug 22, 2008

Actually this is from the original SQL's from Seanpack which PcMaple is using

desert123100 · Sep 21, 2008

This is leeched from Seanpack. GG

HydroBenZ · Sep 21, 2008

desert123100 said:
This is leeched from Seanpack. GG

You just revived a month old thread. GG

chuayaowei · Sep 21, 2008

Don't revive dead threads.

urtime59 · Sep 21, 2008

Why Not? Especially if someone still needs it...

SaintsIan · Sep 21, 2008

If someone needs it then just tell him/her to use the search button or Google.com.
There are search engines for a reason.

Frozurad · Sep 21, 2008

if they need it they don't have to post...just leech and be done with it GG

casioa1234 · Mar 3, 2009

there are some **** in the item id ? what to put there

[ReleasE]4-in-1 --Ultimate-- Simple -- Shops (Including GM)

Initiate Mage

Legendary Battlemage

Junior Spellweaver

Skilled Illusionist

Legendary Battlemage

Experienced Elementalist

Senior

Junior Spellweaver

&#953;&#272;&#945;rk?

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Burn the land,

Supreme Arcanarch

Junior Spellweaver

Mother effin' clouds

my milkshake.

Junior Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners

ιĐαrk?