Job exp exchanger?

[Astinox]

Hi,

we were about to add a job exp exchanger on our website. But somehow we noticed a serious problem: When we remove the exp from the trijob table (using vSro 1.188) some persons still got their old value after teleporting somewhere. This does not happen with all, only with some.

Any suggestions / fixes for that?

 

[Astinox]

No one got any clue?

 

[Astinox]

Or is there any stored procedure which handles the Job experience adding/updating/removing?

 

[Caosfox]

this proc manages it i think _UpdateTriangleJobWeekly

 

[Astinox]

Sadly it's not. Checked it out and as it's said, it updates the general job ranking but not any player specific one.

 

[murilohts]

i have a query u exchange the exp rate and gold rate to 70x

USE [SRO_VT_SHARD]
GO


UPDATE dbo._RefObjCommon
SET Price = 383*70
WHERE Price = 383


UPDATE dbo._RefObjCommon
SET SellPrice = 191*70
WHERE SellPrice = 191


UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*70
WHERE Cost = 383

 

[Caosfox]

ahh, i got you wrong, you want for 1 specific player? i have no idea