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]4-in-1 --Ultimate-- Simple -- Shops (Including GM)

Status
Not open for further replies.
Initiate Mage
Joined
Jul 23, 2008
Messages
3
Reaction score
0
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);
 
Legendary Battlemage
Loyal Member
Joined
Apr 8, 2008
Messages
668
Reaction score
12
Re: 4-in-1 --Ultimate-- Simple -- Shops (Including GM)

[Release] tag.
 
Legendary Battlemage
Loyal Member
Joined
Dec 7, 2007
Messages
622
Reaction score
11
Nice Release Mate =P I Have something like this on my server already =)
 
Senior
Loyal Member
Joined
Feb 8, 2008
Messages
1,873
Reaction score
42
Simple, But Effective

Great job on this :)
 
Junior Spellweaver
Joined
Apr 18, 2008
Messages
109
Reaction score
0
Scroll shop includes the wierd 15, 45, 60%'s?
 
&#953;&#272;&#945;rk?
Joined
Jan 30, 2008
Messages
420
Reaction score
5
I think this is in PCMaple SQLs
You Just Put it in 1 SQL
>_>
 
Skilled Illusionist
Joined
Apr 17, 2008
Messages
316
Reaction score
1
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.
 
Newbie Spellweaver
Joined
Jun 15, 2008
Messages
32
Reaction score
0
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
 
Junior Spellweaver
Joined
Apr 18, 2008
Messages
109
Reaction score
0
Why Not? Especially if someone still needs it...
 
Mother effin' clouds
Loyal Member
Joined
Apr 13, 2008
Messages
1,534
Reaction score
448
If someone needs it then just tell him/her to use the search button or Google.com.
There are search engines for a reason.
 
my milkshake.
Joined
Aug 23, 2008
Messages
230
Reaction score
10
if they need it they don't have to post...just leech and be done with it GG
 
Junior Spellweaver
Joined
Dec 4, 2008
Messages
172
Reaction score
0
there are some **** in the item id ? what to put there
 
Status
Not open for further replies.
Back
Top