Need help with Kill jointing.

AliiB · 08/01/2014, 09:27

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!

RealChew · 08/01/2014, 10:29

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