[Release]Npc Scroll Shop SQL script

Joined
Mar 13, 2007
Messages
2
Reaction score
0
I thought id stop leeching so much and actually make something and release it o.oThis is sql script i made that adds all 10/60 percent scrolls,20% clean slates, and white scrolls to the determined npc id. default is Mia.

For Newbies like i was just a few days ago :D Simply open this in your Mysql and Press "execute" at the top of the progam.

I know its not the best release ever but hey! im trying to do something for the forum community :D

Download link:

or

Code:
INSERT INTO `shopitems` (`shopitemid`,`shopid`,`itemid`,`price`,`position`) VALUES
(9996656,66668,2040031,1,1),
(9996657,66668,2040029,1,2),
(9996658,66668,2040026,1,3),
(9996659,66668,2040025,1,4),
(9996660,66668,2040317,1,5),
(9996661,66668,2040318,1,6),
(9996662,66668,2040321,1,7),
(9996663,66668,2040323,1,8),
(9996664,66668,2040418,1,9),
(9996665,66668,2040419,1,10),
(9996666,66668,2040425,1,11),
(9996667,66668,2040427,1,12),
(9996668,66668,2040502,1,13),
(9996669,66668,2040501,1,14),
(9996670,66668,2040513,1,15),
(9996671,66668,2040514,1,16),
(9996672,66668,2040516,1,17),
(9996673,66668,2040517,1,18),
(9996674,66668,2040532,1,19),
(9996675,66668,2040534,1,20),
(9996676,66668,2040625,1,21),
(9996677,66668,2040627,1,22),
(9996678,66668,2040718,1,23),
(9996679,66668,2040719,1,24),
(9996680,66668,2040720,1,25),
(9996681,66668,2040721,1,26),
(9996682,66668,2040819,1,27),
(9996683,66668,2040820,1,28),
(9996684,66668,2040821,1,29),
(9996685,66668,2040822,1,30),
(9996686,66668,2040914,1,31),
(9996687,66668,2040915,1,32),
(9996688,66668,2040919,1,33),
(9996689,66668,2040920,1,34),
(9996690,66668,2040924,1,35),
(9996691,66668,2040925,1,36),
(9996692,66668,2040931,1,37),
(9996693,66668,2040933,1,38),
(9996694,66668,2041013,1,39),
(9996695,66668,2041014,1,40),
(9996696,66668,2041016,1,41),
(9996697,66668,2041017,1,42),
(9996698,66668,2041019,1,43),
(99966999,66668,2041020,1,44),
(9996700,66668,2041022,1,45),
(9996701,66668,2041023,1,46),
(9996702,66668,2043001,1,47),
(9996703,66668,2043003,1,48),
(9996704,66668,2043009,1,49),
(9996705,66668,2043010,1,50),
(9996706,66668,2043101,1,51),
(9996707,66668,2043103,1,52),
(9996708,66668,2043201,1,53),
(9996709,66668,2043203,1,54),
(9996710,66668,2043301,1,55),
(9996711,66668,2043303,1,56),
(9996712,66668,2043701,1,57),
(9996713,66668,2043703,1,58),
(9996714,66668,2043801,1,59),
(9996715,66668,2043801,1,60),
(9996716,66668,2044001,1,61),
(9996717,66668,2044003,1,62),
(9996718,66668,2044101,1,63),
(9996719,66668,2044103,1,64),
(9996720,66668,2044201,1,65),
(9996721,66668,2044203,1,66),
(9996722,66668,2044301,1,67),
(9996723,66668,2044303,1,68),
(9996724,66668,2044401,1,69),
(9996725,66668,2044403,1,70),
(9996726,66668,2044501,1,71),
(9996727,66668,2044503,1,72),
(9996728,66668,2044601,1,73),
(9996729,66668,2044603,1,74),
(9996730,66668,2044701,1,75),
(9996731,66668,2044703,1,76),
(9996732,66668,2044801,1,77),
(9996733,66668,2044802,1,78),
(9996734,66668,2044901,1,79),
(9996735,66668,2044902,1,80),
(9996736,66668,2049003,1,81),
(9996737,66668,2340000,1,82);
INSERT INTO `shops` (`shopid`,`npcid`) VALUES
(66668,9010002);
I've noticed an increase in these so called "flame shields" and therefore have come to the conclusion that metals have no advantage over flame, and plastic much less, so feel free to flame me cause i have a

kamikashi - [Release]Npc Scroll Shop SQL script - RaGEZONE Forums


Yeah...thats right .
 
Re: Npc Scroll Shop SQL script

yeah
for some reason they don't accept the prefixes
and nice
1st
release
 
Back