/*Sistemas reset pvp rank*/
DECLARE @
[Only registered and activated users can see links. Click Here To Register...]Kill int
IF @
[Only registered and activated users can see links. Click Here To Register...]Type = '108'
BEGIN
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 )
BEGIN
UPDATE PS_GameData.dbo.Chars
SET K1 = 0
WHERE CharID = @
[Only registered and activated users can see links. Click Here To Register...]D
UPDATE PS_GameData.dbo.Chars
SET KillLevel = 0
WHERE CharID = @
[Only registered and activated users can see links. Click Here To Register...]D
UPDATE PS_GameData.dbo.Chars
SET ResetKill = ResetKill+1
WHERE CharID = @
[Only registered and activated users can see links. Click Here To Register...]D
UPDATE PS_UserData.dbo.Users_Master
SET Point = point+1000
WHERE UserID = @
[Only registered and activated users can see links. Click Here To Register...]
UPDATE PS_GameData.dbo.Chars
SET StatPoint = statpoint+15
WHERE CharID = @
[Only registered and activated users can see links. Click Here To Register...]D
END
END