[Release]Summoning Bag FULL Shop~Easy to use

maplepuppet · Nov 30, 2008

Finally done with my second release. I'm glad I'm learning all this, but anyways, this is a summoning bag shop with all kinds of summoning bags (37 in total)
Just run this as a new script tab in mysql query browser and execute.
Hope you enjoy

Where it says NPC ID, delete that and type the npc ID you want the shop to be located at.
Here's the code.

Code:

INSERT INTO `shops` VALUES 
(''90001,Npc ID '');
INSERT INTO `shopitems` 
(`shopitemid`,`shopid`,`itemid`,`price`,`position`) VALUES
(70000,90001,2101050,1000000,1),
(70001,90001,2101051,1000000,2),
(70002,90001,2101052,1000000,3),
(70003,90001,2101053,1000000,4),
(70004,90001,2101054,1000000,5),
(70005,90001,2101055,1000000,6),
(70006,90001,2101056,1000000,7),
(70007,90001,2100017,1000000,8),
(70008,90001,2100000,1000000,9),
(70009,90001,2100014,1000000,10),
(70010,90001,2100016,1000000,11),
(70011,90001,2100001,1000000,12),
(70012,90001,2100002,1000000,13),
(70013,90001,2100003,1000000,14),
(70014,90001,2100004,1000000,15),
(70015,90001,2100005,1000000,16),
(70016,90001,2100006,1000000,17),
(70017,90001,2100007,1000000,18),
(70018,90001,2101001,1000000,19),
(70019,90001,2101008,1000000,20),
(70020,90001,2101007,1000000,21),
(70021,90001,2101000,1000000,22),
(70022,90001,2100009,1000000,23),
(70023,90001,2101004,1000000,24),
(70024,90001,2101005,1000000,25),
(70025,90001,2101006,1000000,26),
(70026,90001,2100008,1000000,27),
(70027,90001,2101002,1000000,28),
(70028,90001,2101003,1000000,29),
(70029,90001,2100018,1000000,30),
(70030,90001,2100019,1000000,31),
(70031,90001,2100010,1000000,32),
(70032,90001,2100011,1000000,33),
(70033,90001,2100012,1000000,34),
(70034,90001,2100013,1000000,35),
(70035,90001,2100031,1000000,36),
(70036,90001,2100032,1000000,37);