How to keep the job exp? I traded 1 times then job level up to 7.
Printable View
How to keep the job exp? I traded 1 times then job level up to 7.
If i do this in that procedure:
update _char set remaingold = remaingold*5 + @TotalReward where charid = @CharID
Without edit the quotation table the thief will get x5 rates too ?
Maybe im saying a stupid thing :P
not working with me .. the profit jump to 83 bill ..
there's no other way for the % between towns and the real profit - you shud rather try some more variations out, like keeping the normal price of the goods of 383 Gold.Quote:
Originally Posted by P L A S M A
thanks bro
When I try to run the query To adjust the necessary Exp for the Joblevels , I get this error
Msg 207, Level 16, State 1, Line 5
Invalid column name 'NewEXPQuot'.
Can I simply just modfify the default "JobExp_Trade,Robber,Hunter" to the new Exp I need?
ex: Lv4 needs 38745000, If I divide it by 100 and change it to 387450. Exp rate now is 100% lower than before to get lvl 4?
Sorry gonna censor that part - was just a theoretical idea, my bad ^^
Those columns are "int" data types meaning they cannot pass the max number in which Level 7 is using.Quote:
Originally Posted by elitebi
2,147,483,647 <- Game uses
2,147,483,648 <- Official max "int" value before it's considered bigint.
I've tried changing the procedure for the RefLevel to use bigint but when loading the game it returns an error related to the change in the RefLevel.
Also Altered the column data type and still no go. I can't find a way around this to increase the job level exp. Might need to crack the GS.
Ye it's prolly not only DB-sided - unfortunately, the only thing we cud also try is to decrease the receiving job EXP by editing the procedure
Its funny how no one even bothered to answer you.Quote:
Originally Posted by jschilling
So can someone please tell us what needs to be changed client sided?
EDIT: Nvm i got it.
just edit pricepolicyofitem.txt clientsided.
EDIT: For some reason no matter what i put i always make like 20 bill +
Quote:
SET @NewQuot = 0.2 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 343 -- Goods Price @ the Shop
SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 250 -- Goods Price if you sell them directly again - without trading.
my values.
anyway to edit the thief gold?
Yah increase the Sell Price. Thieves steal your merchendise and sell it without buying them so they have 100% profit over to how much they sell.
hmm i dont understand ..Quote:
Originally Posted by AngelShade
Quote:
Originally Posted by AngelShade
I increased buy price to 1915 and sell price to 1528 and this did not make the theif gain more gold than when I had the buy and sell values at 1915 and 955. My trade profit is set to 10x. What am I missing? :?:
do you mean refpricepolicyofitem.txt? because i can't find pricepolicyofitem.txtQuote:
Originally Posted by ByteGala
if that is, then which value should i change..??
btw, this is my query
i just want to make the profit 3x (3.0). is my query correct?Code:DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //by Caipi
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 3.0 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
Caipi, lovely script, really nice but theres a few bugs with this script that is needed to be taken into consideration:
After I used this script, I raised my rates to 8.5x only, buy price to 1983 gold and sell price 638 gold, max stack to 40 (normal), when i went from Jangan to Downhang = np, but afterwards when i sold the goods, reached level 5 trader and teleported to Jangan = crashed server.. C++ Runtime error
EDIT: sorry capi, didnt want to give you a bad name, I found out there was something else causing it.
normally , it works fine
but with special goods.........
i get the regular profit maybe i've put wrong values ?
my profit is 2.0 i just increased the selling price
Guys I want to make each trade 5 star get 250m , can anyone give me the rates to make each 5* trade get 250m ?
I want rates this
SET @NewQuot = 0.2 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 343 -- Goods Price @ the Shop
SET @NewStack = 40 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 250 -- Goods Price if you sell them directly again - without trading.
to get 250m each 5* trade
How to Raise Rate thief?
if I want to change only the values and not change the maxstack items.
how do?
"UPDATE _Char set RemainGold = RemainGold + (@TotalReward*10) WHERE CharID = @ CharID "does not change anything, is there any way to increase only hunter gold rate ?
if set @NewQuot = 2
rate is 2x?