Need help with Kill jointing.

08/01/2014 09:27 AliiB#1

Does anyone know how Shaiya Tactics joints their toons on same account to have the same pvp rank? Let me know if you can help :) Thank you!

08/01/2014 10:29 RealChew#2

Probably something like this :

- When the player log off (so when ActionType = 108)

- Selecting the highest number of kills, per example :

Code:

@K1 = SELECT TOP 1 K1 FROM PS_GameData.dbo.Chars WHERE UserUID = @UserUID ORDER BY K1 DESC

- Updating all chars with this value :

Code:

UPDATE PS_GameData.dbo.Chars SET K1= @K1 WHERE UserUID = @UserUID