all shops costs 1 mesos

[dir3]

run this query:

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:

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 :]

 

[mikethemak]

Re: [smallRELEASE] all shops costs 1 mesos

err...thanx for the contribution.


But, this is kinda comman sense...didnt everyone know this?

 

[Vi3tb0i2ty]

Re: [smallRELEASE] all shops costs 1 mesos

yeah alot of people already have this

 

[dir3]

Re: [smallRELEASE] all shops costs 1 mesos

dont think so
thought about it only today in morning.

 

[joen]

Re: [smallRELEASE] all shops costs 1 mesos

i know.. But still good job :happy:

 

[dir3]

Re: [smallRELEASE] all shops costs 1 mesos

thanks all :]

btw joen good job on wedding too

 

[Vi3tb0i2ty]

Re: [smallRELEASE] all shops costs 1 mesos

yeah good job

 

[dir3]

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..

 

[joen]

Re: [smallRELEASE] all shops costs 1 mesos

thanks all :]

btw joen good job on wedding too

Thanks :busted_co But ye it's still in beta.