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!

Petstuff

Junior Spellweaver
Joined
May 30, 2008
Messages
103
Reaction score
1
It would be wrong to call this a release because its been released a billion times, just... I put it all into one,
this is doofus NPC script selling all pet items thatcurrently work, books food pets nx item for 100 closeness, equips. Yes i realise there is topics with them released but its all scattered, for example 1 person release a name tag npc, then 1 guy with a pet npc, etc.
Then you end up with a messy npc with doubled stuff,
So yes, im not even gonna take ANY credit for this, nor do i expect any like "GOOD RELEASE" but i organized it for myself, and decided to let you guys take it since the other topics are so messy.

save as -anything.sql-
run in sql

Code:
INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5170000,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802100,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,2120000,30,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,2260000,500,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160000,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160001,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160002,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160003,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160004,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160005,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160006,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160007,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160008,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160009,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160010,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160012,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160013,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160014,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160015,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160016,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160017,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160024,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160023,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160026,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160027,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160029,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,4160032,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000028,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000029,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000030,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000031,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000032,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000033,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000004,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000025,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000007,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000015,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000009,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000010,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000013,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000006,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000037,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000024,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000036,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000003,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000020,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000011,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000008,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000023,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000002,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000017,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000014,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000041,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000005,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000012,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000039,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5000044,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802027,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802003,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802006,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802025,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802012,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802018,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802031,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802033,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802015,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802021,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802028,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802036,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802016,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802035,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802014,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802010,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802037,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802023,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802030,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802029,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802004,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802026,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802011,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802002,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802000,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802013,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802007,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802008,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802019,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802005,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802032,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802009,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802034,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802020,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802024,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802017,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802048,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802042,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802047,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802049,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802050,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802051,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802052,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802053,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,1802055,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240012,1000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240000,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240001,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240002,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240003,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240004,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240005,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240006,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240007,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240008,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240009,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240010,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240013,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240015,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240017,5000000,0);

INSERT INTO shopitems
(`shopid`, `itemid`, `price`, `position`)
VALUES
(14447,5240020,5000000,0);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(14447, 1012004);
 
Master Summoner
Loyal Member
Joined
Nov 30, 2007
Messages
511
Reaction score
0
Re: [VERY VERY SMALL RELEASE]Petstuff

Gud rls wil def uze :)))))
 
Skilled Illusionist
Joined
Jun 20, 2008
Messages
355
Reaction score
1
Re: [RELEASE]Petstuff

You forgot the

Code:
INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(14447, 1012004);
 
Junior Spellweaver
Joined
Jul 12, 2008
Messages
105
Reaction score
0
Re: [RELEASE]Petstuff

^^^ i think he just saved your life =O LOL x]
 
Skilled Illusionist
Joined
Jun 20, 2008
Messages
355
Reaction score
1
Re: [RELEASE]Petstuff

Hehe ^-^, Other then that, Good release, I'm using it right nao. :3
 
Junior Spellweaver
Joined
May 30, 2008
Messages
103
Reaction score
1
Re: [RELEASE]Petstuff

a poop, musta not copied, my bad :p
thanks i guess but i just took all the other threads and made 1 npc so that it wouldn't be messy D:
 
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
25
Reaction score
0
Re: [RELEASE]Petstuff

" Organization is the key to an organized community. "

- Guess that's not B-S talk xD


Anyways, g00d r3l3@$e :D I like [=
 
Junior Spellweaver
Joined
May 30, 2008
Messages
103
Reaction score
1
Re: [RELEASE]Petstuff

" organization is the key to an organized community. "

- guess that's not b-s talk xd


anyways, g00d r3l3@$e :d i like [=

zewmuhgadddd ty4srly,iwerklyk 10hrs in dis en i h0p3 et halpz
;d
 
Newbie Spellweaver
Joined
Jul 9, 2008
Messages
17
Reaction score
0
Re: [RELEASE]Petstuff

errm. The posistion is 0 for eahc. Won't work..
 
Legendary Battlemage
Joined
May 23, 2008
Messages
628
Reaction score
4
Re: [RELEASE]Petstuff

If people don't appreciate what you release, then simply don't release and let them do it themselves ;)
 
Junior Spellweaver
Joined
May 30, 2008
Messages
103
Reaction score
1
Re: [RELEASE]Petstuff

errm. The posistion is 0 for eahc. Won't work..

Shows how much you know....
if you dont know VERY SIMPLE shop npc's how do you have a server?
F6

-To everyone else-
TYGUIZIRLYAPPRCATEET, MI GN WRK ON LYK EMMM A INSNE NPC THTGEV U STFF 4 MESZA.
 
Experienced Elementalist
Loyal Member
Joined
Apr 23, 2008
Messages
240
Reaction score
0
Re: [RELEASE]Petstuff

Shows how much you know....
if you dont know VERY SIMPLE shop npc's how do you have a server?
F6

-To everyone else-
TYGUIZIRLYAPPRCATEET, MI GN WRK ON LYK EMMM A INSNE NPC THTGEV U STFF 4 MESZA.


Well, its better having an order o_0
 
Back
Top