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!

Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

Status
Not open for further replies.
Junior Spellweaver
Joined
Apr 23, 2008
Messages
161
Reaction score
0
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:
Code:
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

Code:
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:
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
 
Newbie Spellweaver
Joined
Jul 18, 2008
Messages
87
Reaction score
0
Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

I'm First Post :)

Nice Release ^^
 
Junior Spellweaver
Joined
Apr 23, 2008
Messages
161
Reaction score
0
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
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
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...
 
Junior Spellweaver
Joined
Apr 4, 2008
Messages
157
Reaction score
11
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
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Re: [RELEASE]Cloy Pet Book Shop & Doofus Pet Food And Tag Shop

They are for lazy people? o.o
 
Status
Not open for further replies.
Back
Top