Edit shops !

[D-j-d]

If tried to find if there is a post of how to edit shops but i didnt find !
sorrt if its spam to u but i realy need it !
I got a EMU server C3 and i need to edit my shops
if you got soo plz give me :)

[MentaL]

[D-j-d]

Can some1 at least Reaply to the thread ?!?

[iamdeath]

ok use search it been ask before

[D-j-d]

its does but no1 replyed him

[darkprince04]

need edit shop?
- Create a sql file like edit_shop.sql
- Write this code:
REPLACE merchant_buylists VALUES (<itemID>,<itemPrice>,<shopID>,<order>);
- U can rewrite it many time to replace many shop with one execute
<itemID>: the ID of Item u add to shop
<itemPrice>: the Price of it
<ShopID>: the ID of shop sell it
<order>: unique number
example:
REPLACE merchant_buylists VALUES (1458,2000,5200,1);
REPLACE merchant_buylists VALUES (1459,3000,5200,2);
when u exec, it will create new shop ID sell: crystal grace D price 2000adena with unique number is 1, crystal grace C price 3000 with unique number is 2

[D-j-d]

Tnx ! :)