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!

Mu Lung Pot Shop

Newbie Spellweaver
Joined
May 25, 2008
Messages
98
Reaction score
0
This is my second release in two days. Like I said since I am now have a server I am releasing daily. (Maybe) This probably almost took an hour to get perfect if not more. Everything in the script is in GMS and same price.

Please Give Me Full Credits if you add to repack or such.

PHP:
-- Made by MesoRnager of RaGEZONE --

INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111230, 911, 2000000, 50, 1);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111231, 911, 2000001, 160, 2);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111232, 911, 2000002, 320, 3);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111233, 911, 2000003, 200, 4);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111234, 911, 2000006, 620, 5);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111235, 911, 2002000, 500, 6);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111236, 911, 2002001, 400, 7);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111237, 911, 2002002, 500, 8);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111238, 911, 2002004, 500, 9);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111239, 911, 2002005, 500, 10);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111240, 911, 2022089, 3400, 11);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111241, 911, 2001000, 3200, 12);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111242, 911, 2001001, 2300, 13);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111243, 911, 2001002, 4000, 14);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111244, 911, 2010000, 30, 15);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111245, 911, 2010002, 50, 16);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111246, 911, 2010001, 106, 17);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111247, 911, 2010003, 100, 18);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111248, 911, 2010004, 310, 19);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111249, 911, 2020012, 4500, 20);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111250, 911, 2020013, 5600, 21);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111251, 911, 2020014, 8100, 22);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111252, 911, 2020015, 10200, 23);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111253, 911, 02030000, 400, 24);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111254, 911, 2060000, 1, 25);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111255, 911, 2060001, 10, 26);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111256, 911, 2061000, 1, 27);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111257, 911, 2061001, 10, 28);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111258, 911, 2022015, 12500, 29);
INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES (111259, 911, 2070000, 500, 30);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(911, 2090003);
 
Last edited:
Newbie Spellweaver
Joined
Apr 4, 2008
Messages
70
Reaction score
0
Re: [Release] Mu Lung Pot Shop

so you fixed error XD

btw nice release =)
 
Newbie Spellweaver
Joined
May 25, 2008
Messages
98
Reaction score
0
Re: [Release] Mu Lung Pot Shop

so you fixed error XD

btw nice release =)

Yeah, lol it took a while. I did everything add numbers and everything untill I found out I was missing:




INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES
 
Newbie Spellweaver
Joined
Jul 1, 2008
Messages
55
Reaction score
2
Re: [Release] Mu Lung Pot Shop

I am not gonna use, but i good job job for finding the ids and exact price. :technolog
 
Newbie Spellweaver
Joined
May 25, 2008
Messages
98
Reaction score
0
Re: [Release] Mu Lung Pot Shop

I will be adding a lot more missing NPC's.
 
Newbie Spellweaver
Joined
Jul 1, 2008
Messages
55
Reaction score
2
Re: [Release] Mu Lung Pot Shop

Well, good luck with that, i am switchingto vana lols, and these npcs would be kewl. but i keep getting error for a custom shop.
 
Newbie Spellweaver
Joined
May 25, 2008
Messages
98
Reaction score
0
Re: [Release] Mu Lung Pot Shop

Well, good luck with that, i am switchingto vana lols, and these npcs would be kewl. but i keep getting error for a custom shop.

cool. Have fun.
 
Master Summoner
Loyal Member
Joined
Mar 4, 2007
Messages
564
Reaction score
1
Re: [Release] Mu Lung Pot Shop

Way to keep up on the releases. :3
Good work!
 
Newbie Spellweaver
Joined
Jul 1, 2008
Messages
55
Reaction score
2
Re: [Release] Mu Lung Pot Shop

Lol, just asking, any of u good with vana coding? i went to vana forums, but they ignore me. D=/
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Re: [Release] Mu Lung Pot Shop

Well, is this what the pots shop has in GMS? Or is it custom?

Btw, maybe you could work on shops that Odin doesn't have...
 
Newbie Spellweaver
Joined
May 25, 2008
Messages
98
Reaction score
0
Re: [Release] Mu Lung Pot Shop

Well, is this what the pots shop has in GMS? Or is it custom?

Btw, maybe you could work on shops that Odin doesn't have...

Its GMS based not custom.

Add me on MSN and tell me the incomplete shops.
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Re: [Release] Mu Lung Pot Shop

Uhh... Sure! But, I got some that I think that shops won't work... Mainly in Mu Lung, Leafre, Herb Town, etc.
 
Master Summoner
Joined
May 31, 2008
Messages
524
Reaction score
1
Re: [Release] Mu Lung Pot Shop

Well, I'll try finding out what shops don't work, ok? Cause I think I know some...
 
Skilled Illusionist
Joined
May 12, 2008
Messages
321
Reaction score
0
Re: [Release] Mu Lung Pot Shop

Very nice, though you added "beginner thief throwing stars" instead of real subis :p
 
Master Summoner
Loyal Member
Joined
Apr 27, 2008
Messages
596
Reaction score
0
Re: [Release] Mu Lung Pot Shop

No wonder it didn't work.
 
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
11
Reaction score
0
Re: [Release] Mu Lung Pot Shop

Code:
-- Made by MesoRnager of RaGEZONE // Revised by iSecks--

INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES 
(111230, 911, 2000000, 50, 1),
(111231, 911, 2000001, 160, 2),
(111232, 911, 2000002, 320, 3),
(111233, 911, 2000003, 200, 4),
(111234, 911, 2000006, 620, 5),
(111235, 911, 2002000, 500, 6),
(111236, 911, 2002001, 400, 7),
(111237, 911, 2002002, 500, 8),
(111238, 911, 2002004, 500, 9),
(111239, 911, 2002005, 500, 10),
(111240, 911, 2022089, 3400, 11),
(111241, 911, 2001000, 3200, 12),
(111242, 911, 2001001, 2300, 13),
(111243, 911, 2001002, 4000, 14),
(111244, 911, 2010000, 30, 15),
(111245, 911, 2010002, 50, 16),
(111246, 911, 2010001, 106, 17),
(111247, 911, 2010003, 100, 18),
(111248, 911, 2010004, 310, 19),
(111249, 911, 2020012, 4500, 20),
(111250, 911, 2020013, 5600, 21),
(111251, 911, 2020014, 8100, 22),
(111252, 911, 2020015, 10200, 23),
(111253, 911, 02030000, 400, 24),
(111254, 911, 2060000, 1, 25),
(111255, 911, 2060001, 10, 26),
(111256, 911, 2061000, 1, 27),
(111257, 911, 2061001, 10, 28),
(111258, 911, 2022015, 12500, 29),
(111259, 911, 2070000, 500, 30);

INSERT INTO shops (`shopid`, `npcid`) VALUES
(911, 2090003);

You don't need to put "INSERT INTO shopitems (shopitemid, shopid, itemid, price, position) VALUES" before every line. See my revised version of your mysql script to see a faster way to do the same thing you did.
 
Back
Top