[HELP] PINK STAR RESET KILL

Hi everyone
I want to correct the script and delete the tag name

Quote:

/*Sisteme de reset pvp rank*/

DECLARE @Tag1 varchar(30)
DECLARE @TagName varchar(30)
SET @Tag1 = (SELECT SUBSTRING(CharName, 5,30) FROM PS_GameData.dbo.Chars WHERE CharID = @CharID);
DECLARE @Tag2 varchar(30)
SET @Tag2 = (SELECT SUBSTRING(CharName, 6,30) FROM PS_GameData.dbo.Chars WHERE CharID = @CharID);
IF @ActionType = '108'
BEGIN
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 0)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[*]', TagID = 1
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE MasterCharID=@CharID

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE FriendID=@CharID

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 1)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[**]', TagID = 2
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName=@CharName+ '[*]'
WHERE MasterCharID=@CharID

UPDATE PS_GameData.dbo.FriendChars
SET FriendName=@CharName+'[*]'
WHERE FriendID=@CharID

UPDATE PS_GameData.dbo.BanChars
SET BanName=@CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 2)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, TagName = '[***]', TagID = 3
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE MasterCharID=@CharID

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE FriendID=@CharID

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 1000000 AND CharID = @CharID AND TagID = 3)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET CharName = @CharName+ '[*]',K1 = 0, K2 = 0, StatPoint = StatPoint + 100, TagName = '[****]', TagID = 4
WHERE CharID = @CharID

UPDATE PS_GameData.dbo.Guilds
SET MasterName= @CharName+ '[*]'
WHERE MasterCharID=@CharID

UPDATE PS_GameData.dbo.FriendChars
SET FriendName= @CharName+ '[*]'
WHERE FriendID=@CharID

UPDATE PS_GameData.dbo.BanChars
SET BanName= @CharName+ '[*]'
WHERE BanID=@CharID
END
END