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 jobs weapon and Equipment 50 - 110

Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
Ok i made some scripts for my server, because everyone asked for equipments and stuff, and decided to add weapons with its release

So far i have bowman and sin, rest should be done by tommorow

Note : I made it

Mini Guide

To activate codes, Run MySQL, then open new script tab,
Paste codes in and execute

makes sure your not using the NPC i chose, or it may mess you up ;D

Feel free to Edit it
Bowman:
Code:
/* Bowman Equips and Weapons 50-110 */

/* Defalt NPC is Mad Bunny of Victoria Road:Henysys */

/* Partial Credits to SeanPack5.9 Shop SQL,
   Copying their table style
 */

/* Created by: Rayne; Moderator of AkaiMS at
   akiyowindz.com.

   Contact Email:

   <mailrayjon@gmail.com>

   This script can be modified to fit your needs,
   just try not to steal credits =D
*/


INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050051, 200000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050052, 200000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050058, 250000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050059, 250000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050060, 250000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050061, 300000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050062, 300000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050063, 300000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050064, 300000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050075, 400000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050076, 400000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050077, 400000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050078, 400000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050088, 500000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050089, 500000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050090, 500000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050091, 500000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050106, 1000000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050107, 1000000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1050108, 1000000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051037, 200000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051038, 200000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051039, 200000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051041, 250000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051042, 250000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051043, 250000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051062, 300000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051063, 300000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051064, 300000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051065, 300000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051066, 400000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051067, 400000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051068, 400000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051069, 400000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051082, 500000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051083, 500000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051084, 500000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051085, 500000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051105, 1000000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051106, 1000000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1051107, 1000000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1052071, 10000000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002211, 100000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002212, 100000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002213, 100000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002214, 100000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002267, 150000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002268, 150000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002269, 150000, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002270, 150000, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002286, 200000, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002287, 200000, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002288, 200000, 53);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002289, 200000, 54);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002275, 300000, 55);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002276, 300000, 56);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002277, 300000, 57);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002278, 300000, 58);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002402, 400000, 59);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002403, 400000, 60);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002404, 400000, 61);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002405, 400000, 62);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002406, 800000, 63);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002407, 800000, 64);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002408, 800000, 65);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1002547, 8000000, 66);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082083, 100000, 67);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082084, 100000, 68);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082085, 100000, 69);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082089, 150000, 70);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082090, 150000, 71);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082091, 150000, 72);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082106, 200000, 73);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082107, 200000, 74);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082108, 200000, 75);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082109, 300000, 76);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082110, 300000, 77);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082111, 300000, 78);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082112, 300000, 79);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082125, 400000, 80);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082126, 400000, 90);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082127, 400000, 91);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082158, 800000, 92);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082159, 800000, 93);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082160, 800000, 94);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1082163, 8000000, 95);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072122, 100000, 96);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072123, 100000, 97);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072124, 100000, 98);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072125, 100000, 99);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072144, 150000, 100);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072145, 150000, 101);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072146, 150000, 102);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072164, 200000, 103);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072165, 200000, 104);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072166, 200000, 105);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072167, 200000, 106);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072182, 300000, 107);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072183, 300000, 108);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072184, 300000, 109);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072185, 300000, 110);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072203, 400000, 111);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072204, 400000, 112);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072205, 400000, 113);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072227, 800000, 114);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072228, 800000, 115);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072229, 800000, 116);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1072269, 8000000, 117);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452008, 1000000, 118);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452009, 1500000, 119);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452010, 1500000, 120);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452011, 1500000, 121);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452012, 2000000, 122);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452013, 2000000, 123);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452014, 2000000, 124);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452015, 2000000, 125);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452017, 5000000, 126);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452025, 5000000, 127);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452026, 5000000, 128);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452019, 10000000, 129);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452020, 10000000, 130);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452021, 10000000, 131);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452044, 500000000, 132);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452018, 1250000, 133);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1452052, 2500000, 134);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462007, 500000, 135);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462008, 750000, 136);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462009, 1000000, 137);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462010, 2000000, 138);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462011, 2000000, 139);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462012, 2000000, 140);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462013, 2000000, 141);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462018, 5000000, 142);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462021, 5000000, 143);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462022, 5000000, 144);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462015, 10000000, 145);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462016, 10000000, 146);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462017, 10000000, 147);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2140, 1462039, 500000000, 148);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(2140, 9200001);

Thief:
Code:
/* Theif Equips and Weapons 50-110 */

/* Defalt NPC is JM from the streets of Victoria Road:Kerning City */

/* Partial Credits to SeanPack5.9 Shop SQL,
   Copying their table style
 */

/* Created by: Rayne; Moderator of AkaiMS at
   akiyowindz.com.

   Contact Email:

   <mailrayjon@gmail.com>

   This script can be modified to fit your needs,
   just try not to steal credits =D
*/

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040094, 200000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040095, 200000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040096, 200000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040097, 200000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060083, 200000, 5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060084, 200000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060085, 200000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060086, 200000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040098, 300000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040099, 300000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040100, 300000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060087, 300000, 12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060088, 300000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060089, 300000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040105, 400000, 15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040106, 400000, 16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040107, 400000, 17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060093, 400000, 18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060094, 400000, 19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060095, 400000, 20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040108, 500000, 21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040109, 500000, 22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040110, 500000, 23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060097, 500000, 24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060098, 500000, 25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060099, 500000, 26);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040115, 600000, 27);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040116, 600000, 28);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040117, 600000, 29);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1040118, 600000, 30);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060104, 600000, 31);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060105, 600000, 32);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060106, 600000, 33);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1060107, 600000, 34);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1050096, 1400000, 35);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1050097, 1400000, 36);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1050098, 1400000, 37);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1050099, 1400000, 38);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041077, 200000, 39);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041078, 200000, 40);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041079, 200000, 41);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041080, 200000, 42);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061076, 200000, 43);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061077, 200000, 44);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061078, 200000, 45);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061079, 200000, 46);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041094, 300000, 47);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041095, 300000, 48);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041096, 300000, 49);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061093, 300000, 50);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061094, 300000, 51);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061095, 300000, 52);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041100, 400000, 53);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041101, 400000, 54);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041102, 400000, 55);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041103, 400000, 56);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061099, 400000, 57);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061100, 400000, 58);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061101, 400000, 59);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061102, 400000, 60);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041105, 500000, 61);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041106, 500000, 62);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041107, 500000, 63);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061104, 500000, 64);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061105, 500000, 65);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061106, 500000, 66);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041115, 600000, 67);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041116, 600000, 68);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041117, 600000, 69);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1041118, 600000, 70);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061114, 600000, 71);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061115, 600000, 72);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061116, 600000, 73);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1061117, 600000, 74);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1051090, 1400000, 75);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1051091, 1400000, 76);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1051092, 1400000, 77);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1051093, 1400000, 78);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1052072, 15000000, 79);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002207, 200000, 80);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002208, 200000, 81);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002209, 200000, 82);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002210, 200000, 83);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002247, 300000, 84);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002248, 300000, 85);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002249, 300000, 86);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002656, 300000, 87);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002281, 400000, 88);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002282, 400000, 89);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002283, 400000, 90);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002284, 400000, 91);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002285, 400000, 92);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002327, 500000, 93);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002328, 500000, 94);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002329, 500000, 95);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002330, 500000, 96);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002331, 500000, 97);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002323, 600000, 98);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002324, 600000, 99);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002325, 600000, 100);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002326, 600000, 101);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002380, 700000, 102);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002381, 700000, 103);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002382, 700000, 104);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002383, 700000, 105);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1002550, 1000000, 106);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082065, 200000, 107);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082066, 200000, 108);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082067, 200000, 109);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082092, 300000, 110);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082093, 300000, 111);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082094, 300000, 112);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082095, 400000, 113);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082096, 400000, 114);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082097, 400000, 115);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082118, 500000, 116);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082119, 500000, 117);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082120, 500000, 118);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082142, 600000, 119);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082143, 600000, 120);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082144, 600000, 121);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082135, 700000, 122);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082136, 700000, 123);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082137, 700000, 124);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082138, 700000, 125);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1082167, 1000000, 126);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072128, 200000, 127);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072129, 200000, 128);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072130, 200000, 129);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072131, 200000, 130);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072150, 300000, 131);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072151, 300000, 132);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072152, 300000, 133);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072161, 400000, 134);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072162, 400000, 135);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072163, 400000, 136);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072172, 500000, 137);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072173, 500000, 138);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072174, 500000, 139);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072192, 600000, 140);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072193, 600000, 141);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072194, 600000, 142);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072195, 600000, 143);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072213, 700000, 144);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072214, 700000, 145);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072215, 700000, 146);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072215, 700000, 147);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1072272, 1000000, 148);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472018, 500000, 149);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472019, 500000, 150);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472020, 500000, 151);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472021, 500000, 152);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472022, 800000, 153);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472023, 800000, 154);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472024, 800000, 155);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472025, 800000, 156);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472026, 1000000, 157);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472027, 1000000, 158);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472028, 1000000, 159);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472029, 1000000, 160);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472031, 3000000, 161);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472053, 7000000, 162);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472051, 500000000, 163);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472052, 500000000, 164);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332015, 1000000, 165);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332018, 2000000, 166);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332023, 3000000, 167);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332003, 500000, 168);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332027, 7000000, 169);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332050, 500000000, 170);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332052, 10000000, 171);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1332064, 750000, 172);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 1472062, 750000, 173);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070001, 25000, 174);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070002, 50000, 175);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070003, 100000, 176);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070010, 150000, 177);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070004, 800000, 178);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070005, 5000000, 179);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070006, 20000000, 180);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070007, 25000000, 181);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (2141, 2070016, 100000000, 182);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(2141, 1052002);

Hope they are usefull =D
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
lol wtf is that Kevin from AkaiMS?
 
Legendary Battlemage
Loyal Member
Joined
Apr 8, 2008
Messages
668
Reaction score
12
Lol, yea what an avatar stealer gosh..
 
Legendary Battlemage
Loyal Member
Joined
Apr 8, 2008
Messages
668
Reaction score
12
Lol yea.. sorry :/

Ontopic : Great release :)
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
Thank you <3 I have to get started on the other jobs soon Sigh~
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
I couldnt make the others cause i got a gay virus that changed my desktop and my screensaver and had to do system restore, bla bla bla, should be done tommorow
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Hmm... Not bad! But, maybe you could add more stuff to them. (Suggestion!)

(And did you read my guide on making a Shop SQL? Because the format that you made yours is what I explained on my guide... o.o)
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
Lol I didnt, i just looked off of SeanPacks Shop sqls, and used their format, and for each job, i added like everything, but i forgot the dit shield Dx But yeah, i tried everything i could find for that job =P
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Lulz! I did that too, before I made my guide. XD
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
xD Its pretty simple though , just a pain in the butt to make ( takes TOO long)
 
Experienced Elementalist
Joined
Jul 1, 2008
Messages
270
Reaction score
0
You should make this more organized, I have seen one like this, with more and more organized
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
170
Reaction score
0
Organized as in?
Its organized by armour/ wep type, do u mean sub catagories?
 
Junior Spellweaver
Joined
Nov 28, 2006
Messages
114
Reaction score
3
he/she means i think with ------------------ to split the job sections of , maybe some layouts with the letters.

b.t.w. tyvm for this, was already looking for this
 
Back
Top