[HELP]PvP Reward + TAG

03/21/2016 03:17 st.jimmy998#1
Hello,

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


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 :) :)
03/21/2016 05:49 SnickQ#2
Create another Columns in Char like Name2
Code:
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 @[Only registered and activated users can see links. Click Here To Register...] varchar(30) =(Select Name2 FROM PS_GameData.dbo.Chars WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
SET @[Only registered and activated users can see links. Click Here To Register...] = (SELECT CharName FROM PS_GameData.dbo.Chars WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D)

IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 AND CharID = @[Only registered and activated users can see links. Click Here To Register...]D AND TagID = 1)
BEGIN

UPDATE PS_GameData.dbo.Chars
SET CharName = @[Only registered and activated users can see links. Click Here To Register...]+ '[**]',K1 = 0, K2 = 0, TagName = '[**]', TagID = 2
WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D and TagID='1'


IF EXISTS (SELECT * FROM PS_GameData.dbo.Chars WHERE K1 >= 200000 AND CharID = @[Only registered and activated users can see links. Click Here To Register...]D AND TagID = 2)
BEGIN

UPDATE PS_GameData.dbo.Chars
SET CharName = @[Only registered and activated users can see links. Click Here To Register...]+ '[***]',K1 = 0, K2 = 0, TagName = '[***]', TagID = 3
WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D and TagID='2'

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