fix How To Fix Item Sell Price in Item_Proto

[Exygo 1050]

Problem:

 

Solution:

 

Step 1:

Open navicat -> player -> item_proto and Press CTRL + Q

Step 2:

Execute these queries:

	UPDATE item_proto SET shop_buy_price = gold;
UPDATE item_proto SET shop_buy_price = (shop_buy_price * 1.40)-gold where gold > '0';
UPDATE item_proto SET shop_buy_price = gold-shop_buy_price where gold > '0';
	

Step 3: 

Update item_proto client side too, so you can see the sell price in client window

Result:

 

 

Let me know if that solved your problem

[alondark 58]

for txt ? 

[Exygo 1050]

No solution for that

[tierrilopes 447]

48 minutes ago, alondark said:

for txt ? 

Import txt into excell and then do a formula that does the same as query provided above.

[Denis 1458]

1 hour ago, alondark said:

for txt ? 

You can edit ProtoReader at db for that

[Exygo 1050]

BUMP

[Garzard 2]

Rly?

[Exygo 1050]

UP