[HELP] PINK STAR RESET KILL

[Wa7dani]

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

/*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

[arjulie]

what you wan't on that script and also can you tell what you wan't?

[Wa7dani]

Originally Posted by arjulie

what you wan't on that script and also can you tell what you wan't?

i dont want tag name i mean this[*]
and sory for my languge

[killer2p]

so remove the *

[{Skrillex}]

Why you ask for easy thinks like this?
You just can learn by doing. Make a copy of original file and then edit the files... when it don´t work or something is from use the old original file and try again. When you don´t able to do this. I help you.

[Wa7dani]

Originally Posted by .:Skrillex:.

Why you ask for easy thinks like this?
You just can learn by doing. Make a copy of original file and then edit the files... when it don´t work or something is from use the old original file and try again. When you don´t able to do this. I help you.

i know how to make this script work but i dont like tag name when someone get the friest reset will get[*] in his name , i do my best to edit but i failed
if you know how to edit this script and make it without tag just tell me , ty
and sorry for my languge

[[MXD]Takeshi]

Originally Posted by Wa7dani

i know how to make this script work but i dont like tag name

I checked script... it so easy....
instead of update charname (it show your name in game) dont change it...

[[DEV]Wandersson]

lmao the script so easy

[Wa7dani]

Originally Posted by [DEV]Wandersson

lmao the script so easy

i write new one , but thank you for help