|
You last visited: Today at 06:02
Advertisement
Price items wholesale traders reduced
Discussion on Price items wholesale traders reduced within the SRO Private Server forum part of the Silkroad Online category.
01/02/2020, 13:29
|
#1
|
elite*gold: 0 
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
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.
|
|
|
|
01/02/2020, 14:26
|
#2
|
elite*gold: 0
Join Date: Feb 2017
Posts: 188
Received Thanks: 120
|
_ItemQuotation
|
|
|
|
|
01/02/2020, 14:38
|
#3
|
elite*gold: 0
Join Date: Nov 2009
Posts: 302
Received Thanks: 33
|
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
|
|
|
|
|
01/03/2020, 08:03
|
#4
|
elite*gold: 0
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
Quote:
Originally Posted by sonzenbi
_ItemQuotation
|
I looked at that table and really didn't understand it!
|
|
|
|
|
01/03/2020, 13:11
|
#5
|
elite*gold: 53
Join Date: Sep 2014
Posts: 308
Received Thanks: 88
|
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.
|
|
|
|
|
01/03/2020, 13:25
|
#6
|
elite*gold: 0
Join Date: Nov 2009
Posts: 302
Received Thanks: 33
|
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?
|
|
|
|
|
01/03/2020, 15:44
|
#7
|
elite*gold: 0
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
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).
|
|
|
|
|
01/04/2020, 03:18
|
#8
|
elite*gold: 0
Join Date: May 2017
Posts: 1,081
Received Thanks: 224
|
Refobjcomon
Refpriceitem
|
|
|
|
|
01/04/2020, 04:56
|
#9
|
elite*gold: 0
Join Date: Apr 2019
Posts: 298
Received Thanks: 80
|
The quick way is to take the DB of the other SRO to get _ItemQuotation
*copy and then modify the price as you want 
|
|
|
|
|
01/04/2020, 07:05
|
#10
|
elite*gold: 0
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
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 |
The SRO 120 and SRO 140 databases are different!
|
|
|
|
|
01/04/2020, 12:29
|
#11
|
elite*gold: 0
Join Date: Feb 2017
Posts: 188
Received Thanks: 120
|
Donwhang TRADER NPC doesn't sell any items ?
|
|
|
|
|
01/04/2020, 15:17
|
#12
|
elite*gold: 0
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
Quote:
Originally Posted by sonzenbi
Donwhang TRADER NPC doesn't sell any items ?
|
No, they do sell!
|
|
|
|
|
01/04/2020, 20:45
|
#13
|
elite*gold: 0
Join Date: Feb 2017
Posts: 188
Received Thanks: 120
|
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
|
|
|
|
|
01/05/2020, 08:42
|
#14
|
elite*gold: 0
Join Date: Feb 2019
Posts: 31
Received Thanks: 1
|
It's here!
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
|
|
|
|
All times are GMT +1. The time now is 06:03.
|
|
