Price items wholesale traders reduced

The players on my server have problems trading, namely the selling price is lower than the buying price, the loss-making trip.
For example: They bought all 5,000,000 gold, traded from Jangan to Donwhang, but when they came to Downhang, the revenue was only about 200,000 gold (a lot of loss).
I don't know what the problem is here? Please show me how to fix it?!
Thanks very much.

_ItemQuotation

Quote:

Originally Posted by sonzenbi _ItemQuotation

yes but he will not know what to do explains a little more what he has to modify? how is calculated what each column means

Quote:

Originally Posted by sonzenbi _ItemQuotation

I looked at that table and really didn't understand it!

Well this is _ItemQuotation table, you gotta just double everything by 2 in there, that would make the profit 400,000 instead of 200,000
Just like that:

Update _ItemQuotation set Quot_LB = Quot_LB * 2

And keep multiplying them all till you get a satisfying result.
Note: you need to restart your gameserver after changing any values in order to take effect.

perfect and in case of reducing instead of raising the amount that is made?

Does this somehow alter the Exp that is held when you get the profit?

Quote:

Originally Posted by Mr.Awesome1337 Well this is _ItemQuotation table, you gotta just double everything by 2 in there, that would make the profit 400,000 instead of 200,000 Just like that: Update _ItemQuotation set Quot_LB = Quot_LB * 2 And keep multiplying them all till you get a satisfying result. Note: you need to restart your gameserver after changing any values in order to take effect.

The problem here is that the sale money is not equal to a small part of the purchase money (buy all 5,000,000 gold but when sold only 200,000 gold, a loss of 4.8 million gold).

Refobjcomon
Refpriceitem
:)

The quick way is to take the DB of the other SRO to get _ItemQuotation
*copy and then modify the price as you want :D

Quote:

Originally Posted by [GM]Dejo Refobjcomon Refpriceitem :)

Please show me more specifically!

Quote:

Originally Posted by srothanglong The quick way is to take the DB of the other SRO to get _ItemQuotation *copy and then modify the price as you want :D

The SRO 120 and SRO 140 databases are different!

Donwhang TRADER NPC doesn't sell any items ?

Quote:

Originally Posted by sonzenbi Donwhang TRADER NPC doesn't sell any items ?

No, they do sell!

Quote:

Originally Posted by tanquang No, they do sell!

Quote:

use SRO_VT_SHARD select * from _ItemQuotation where AssocNPC = 2059 and RefItemID between 2147 and 2150

Give me the result

Quote:

Originally Posted by sonzenbi Give me the result

32 1 2059 2147 1.88 1.58 2.18 50000 250 42499
33 1 2059 2148 1.88 1.58 2.18 50000 250 42499
34 1 2059 2149 1.88 1.58 2.18 50000 250 42499
35 1 2059 2150 1.88 1.58 2.18 50000 250 42499