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!

all shops costs 1 mesos

Status
Not open for further replies.
Newbie Spellweaver
Joined
Apr 21, 2008
Messages
73
Reaction score
0
run this query:

Code:
update shopitems SET price = 1;

note:
u can change 1 to wich price that u want.


if u add a new shop make sure its like that:

example for Star shop sean 5.9:


Code:
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070000, 10000, 1);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070001, 250000, 2);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070008, 500000, 3);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070002, 650000, 4);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070009, 650000, 5); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070012, 800000, 6);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070013, 1500000, 7);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070003, 1650000, 8);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070010, 1700000, 9);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070011, 2000000, 10);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070004, 5000000, 11);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070005, 15000000, 12); 
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070006, 25000000, 13);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070007, 35000000, 14);
INSERT INTO shopitems (shopid, itemid, price, position) VALUES (1340, 2070016, 50000000, 15);

INSERT INTO shops
(`shopid`, `npcid`)
VALUES
(1340, 1052002);

u chane the 50000000 (for last item that is c.ilbis to 1 or what u want)


this is for Servers that want all shops costume :]
 
ツ
Loyal Member
Joined
Apr 12, 2008
Messages
729
Reaction score
28
Re: [smallRELEASE] all shops costs 1 mesos

err...thanx for the contribution.


But, this is kinda comman sense...didnt everyone know this? o_O
 
Visit my hompage
Loyal Member
Joined
May 2, 2008
Messages
1,017
Reaction score
2
Re: [smallRELEASE] all shops costs 1 mesos

yeah alot of people already have this
 
Newbie Spellweaver
Joined
Apr 21, 2008
Messages
73
Reaction score
0
Re: [smallRELEASE] all shops costs 1 mesos

dont think so
thought about it only today in morning.
 
Elite Diviner
Joined
Jun 19, 2008
Messages
463
Reaction score
1
Re: [smallRELEASE] all shops costs 1 mesos

i know.. But still good job :happy:
 
Newbie Spellweaver
Joined
Apr 21, 2008
Messages
73
Reaction score
0
Re: [smallRELEASE] all shops costs 1 mesos

thanks all :]

btw joen good job on wedding too :p
 
Visit my hompage
Loyal Member
Joined
May 2, 2008
Messages
1,017
Reaction score
2
Re: [smallRELEASE] all shops costs 1 mesos

yeah good job
 
Newbie Spellweaver
Joined
Apr 21, 2008
Messages
73
Reaction score
0
Re: [smallRELEASE] all shops costs 1 mesos

another tip:

if ur adding shop dont do the thing i said up.

add the shop and then run the query again..
 
Status
Not open for further replies.
Back
Top