Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

[NMDanny]

What Are The NPCs And Where

NPCs: Doofus(At Walking Area And Henesys Market)
Cloy(Near The Henesys PQ And Storage)

=========================================================
What The NPCs Sell
Doofus: Shop ID- 1337 , Npc ID- 1012004
Doofus Sell Pet Food(50 Mesos) And Pet NX Foods(2500 Mesos)
And Pet Name Tag(15000 Mesos) And "Special" Pets(10,000 Mesos)
Cloy Pet Master: Shop ID- 31337 , Npc ID- 1012005
Cloy Sell Command Books(150 Mesos)
=========================================================
The ID's Are From MapleTip
Queries:
Doofus Pet Food+Tag+Special Pet Shop:

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5170000,15000,1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240000,2500,2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240001,2500,3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240002,2500,4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240003,2500,5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240004,2500,6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240005,2500,7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240006,2500,8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240007,2500,9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240008,2500,10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240009,2500,11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240010,2500,12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240012,2500,13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240013,2500,14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240015,2500,15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240017,2500,16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5240020,2500,17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,2120000,50,18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000034,10000,19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000015,10000,20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000037,10000,21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000044,10000,22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000039,10000,23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000045,10000,24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000041,10000,25);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1337,5000036,10000,26); 

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1337,1012004);

1337= the shop id | 1012004= the npc id You Can Change It

INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160000,150,1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160001,150,2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160002,150,3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160003,150,4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160004,150,5);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160005,150,6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160006,150,7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160007,150,8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160008,150,9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160009,150,10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160010,150,11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160012,150,12);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160013,150,13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160014,150,14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160015,150,15);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160016,150,16);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160017,150,17);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160020,150,18);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160022,150,19);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160023,150,20);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160024,150,21);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160026,150,22);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160027,150,23);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160029,150,24);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (31337,4160032,150,25);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(31337,1012005);

31337= The Shop ID | 1012005= The Npc ID


DOWNLOAD LINK FOR LAZY PEOPLE:

To view the content, you need to sign in or register

Not Tested, But This Wont Harm Your Database, Make Sure That ID's 1337/31337 Are Not Used And That Doofus And Cloy Not
Used!! GM Shop May Use ID 1337 So Be Careful
INSTRUCTION:
Excute/Run These Queries, Or Download And Excute The SQL
Make Sure That Shop ID's 1337 And 31337 Are Not Used
And Make Sure That The NPC's : Doofus And Cloy Not Used
If You Using PCMaple Then Then The GMShop(If you excuted) Using
Shop ID 1337

On Next Version I Maybe Make An Pet Seller And Pet Visual Equips

 

[Feeling]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

I'm First Post

Nice Release ^^

 

[Roamer]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

Nice ^^ XD

 

[ANBUItachi]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

Give Me Credits Dofus Pet Food And Tag was My Idea
Here is the Topic
http://forum.ragezone.com/showthread.php?t=442339

 

[NMDanny]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

It was my idea... i just putted all items for pets that working. except visual equips and equips..
and your topic had only Pet Food and name tag, that was just 2 items, i did all pet foods+pet nx foods+name tag+special pets+a shop with all pets

 

[Falzer]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

This just seems like you updated ANBUItachi's script, added more stuff, and changed the Shop ID...

 

[mcskills]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

I don't get why people need Shop Querys. They are easy to make yourself. All you do is put the ID of the item, ID of shop and how much the item should sell for o.o

 

[Falzer]

Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

They are for lazy people? o.o