[HELP]PvP Reward + TAG

[st.jimmy998]

Hello,

I'm using this script that Cartola released here sometime ago.

 Spoiler

/*Sistema de reset pvp rank*/
DECLARE @ varchar(30)
DECLARE @me varchar(30)
SET @ = (SELECT SUBSTRING(CharName, 5,30) FROM PS_GameData.dbo.Chars WHERE CharID = @D);
DECLARE @2 varchar(30)
SET @2 = (SELECT SUBSTRING(CharName, 6,30) FROM PS_GameData.dbo.Chars WHERE CharID = @D);
IF @Type = '108'
BEGIN
IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 AND CharID = @D AND TagID = 0)
BEGIN
UPDATE PS_UserData.dbo.Users_Master
SET Point = Point + 10000
WHERE UserUID = @ID

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

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

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

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

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

UPDATE PS_GameData.dbo.Guilds
SET MasterName @+ '[*]'
WHERE MasterCharID @D

UPDATE PS_GameData.dbo.FriendChars
SET FriendName @+'[*]'
WHERE FriendID @D

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

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

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

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

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

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

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

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

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

But I have a problem, this give[*] to a "x" player that reached 200k kills right? Well, when the same player, "x[*]" reach again 200k, it gives, x[*][*]..

For example, now I have a player that have " Reading[*][*][*][^], its like those old Tags[*] aren't removed to put that new rank [^]

I want to give that player, x[**] instead of x[*][*], I would like if anyone can help me with this

[SnickQ]

Create another Columns in Char like Name2

USE [PS_GameData]
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Chars ADD
	Name2 varchar(30) NULL CONSTRAINT DF_Chars_Name2 DEFAULT 0
GO
COMMIT

and add for script

DECLARE @ varchar(30) =(Select Name2 FROM PS_GameData.dbo.Chars WHERE CharID = @D)
SET @ = (SELECT CharName FROM PS_GameData.dbo.Chars WHERE CharID = @D)

IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 AND CharID = @D AND TagID = 1)
BEGIN

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


IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 AND CharID = @D AND TagID = 2)
BEGIN

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

An when you will change CharName for players with tag edit also Columns "name2" but without any tag