help for create NPC reset Kill

[jefersongpx88]

someone has a script that can share when the player picks pink star resets kill by NPC inside the game with reward


sorry for my English

[Elessatr]

 Spoiler

/*Sistemas reset pvp rank*/

DECLARE @Kill int
IF @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 = @D

UPDATE PS_GameData.dbo.Chars
SET KillLevel = 0
WHERE CharID = @D

UPDATE PS_GameData.dbo.Chars
SET ResetKill = ResetKill+1
WHERE CharID = @D

UPDATE PS_UserData.dbo.Users_Master
SET Point = point+1000
WHERE UserID = @

UPDATE PS_GameData.dbo.Chars
SET StatPoint = statpoint+15
WHERE CharID = @D
END
END