Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Job exp exchanger?

Initiate Mage
Joined
Dec 11, 2012
Messages
8
Reaction score
3
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?
 
Initiate Mage
Joined
Dec 11, 2012
Messages
8
Reaction score
3
Or is there any stored procedure which handles the Job experience adding/updating/removing?
 
Upvote 0
In the Emperor name
Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
this proc manages it i think _UpdateTriangleJobWeekly
 
Upvote 0
Initiate Mage
Joined
Dec 11, 2012
Messages
8
Reaction score
3
Sadly it's not. Checked it out and as it's said, it updates the general job ranking but not any player specific one.
 
Upvote 0
Initiate Mage
Joined
Jan 24, 2013
Messages
6
Reaction score
0
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
 
Upvote 0
In the Emperor name
Member
Joined
Jun 25, 2011
Messages
1,605
Reaction score
238
ahh, i got you wrong, you want for 1 specific player? i have no idea
 
Upvote 0
Back
Top