[Relase]Tag Name for PvP Kills

[Cansas59]

and how? im stupid i know, but so im learning

[atragol]

can`t understand .... video plsss

[Truth1010]

Originally Posted by atragol

can`t understand .... video plsss

If you can't / don't understand this, then i fear a video isn't going to help you at all. Do some SQL Tutorials and stop expecting everyone else to go out of their way just to do it all for you.

There are already baby-step guides available if you just put some effort in yourself.

[SnickQ]

Originally Posted by [Dev]Matheus

Procedures->usp_Insert_Action_Log_E

This should help you Cansas59

[jefersongpx88]

explain better that I do not understand if you can make video I will be thanking you already excuse my English

[Velocity.]

Originally Posted by jefersongpx88

explain better that I do not understand if you can make video I will be thanking you already excuse my English

There's nothing complicated about this script.
Insert the following code into PS_Gamelog.dbo.usp_Insert_Action_Log_E

DECLARE     [MENTION=726976]Nome[/MENTION] varchar(30),@K1 int
SET     [MENTION=726976]Nome[/MENTION] = (SELECT CharName FROM PS_GameData.dbo._CreatedChars WHERE CharID =     [MENTION=395373]Chari[/MENTION]D)
SET @K1 = (SELECT K1 FROM PS_GameData.dbo.Chars WHERE CharID =     [MENTION=395373]Chari[/MENTION]D)
IF     [MENTION=292198]Action[/MENTION]Type = 108 -- Action Logout
BEGIN
	IF @K1 >= 50000 --  Number of Kills
	BEGIN
		UPDATE PS_GameData.dbo.Chars SET CharName = '[Killer]' +     [MENTION=726976]Nome[/MENTION] WHERE CharID =     [MENTION=395373]Chari[/MENTION]D
		UPDATE PS_GameData.dbo.Guilds SET MasterName = '[Killer]' +     [MENTION=726976]Nome[/MENTION] WHERE MasterCharID =     [MENTION=395373]Chari[/MENTION]D
		UPDATE PS_GameData.dbo.FriendChars SET FriendName = '[Killer]' +     [MENTION=726976]Nome[/MENTION] WHERE FriendID =     [MENTION=395373]Chari[/MENTION]D
	END
END

Some Explanation:

DECLARE      [MENTION=726976]Nome[/MENTION] = Character Name
DECLARE @K1 int = Character Kills
SET      [MENTION=726976]Nome[/MENTION] = (SELECT CharName FROM PS_GameData.dbo._CreatedChars WHERE CharID =      [MENTION=395373]Chari[/MENTION]D) - Selects Character name from Character
SET @K1 = (SELECT K1 FROM PS_GameData.dbo.Chars WHERE CharID =      [MENTION=395373]Chari[/MENTION]D) - Selects Kills From Character
IF @K1 >= 50000 --  Number of Kills - if kills more than 50,000 then proceeds if not script dies
then it sets the tag for the character name which applied to. (i'm definetly not good at sql)

If you still don't know what to do then i can't really help you. Better start learning some basic sql

[[PH]KEO(DEV)]

Originally Posted by [Dev]Matheus

Not recommend taking the name of the player straight Chars table, because an hour will reach the maximum Limete of character.

@Cansas59

Use this script to add more tag names

DECLARE @Nome varchar(30),@K1 int
SET @Nome = (SELECT CharName FROM PS_GameData.dbo._CreatedChars WHERE CharID = @CharID)
SET @K1 = (SELECT K1 FROM PS_GameData.dbo.Chars WHERE CharID = @CharID)
IF @ActionType = 108 -- Action Logout
BEGIN
	IF @K1 >= 50000 --  Number of Kills
	BEGIN
		UPDATE PS_GameData.dbo.Chars SET CharName = '[Killer]' + @Nome WHERE CharID = @CharID
		UPDATE PS_GameData.dbo.Guilds SET MasterName = '[Killer]' + @Nome WH
ERE MasterCharID = @CharID
		UPDATE PS_GameData.dbo.FriendChars SET FriendName = '[Killer]' + @Nome WHERE FriendID = @CharID
	END
	ELSE IF @K1 >= 100000 --  Number of Kills
	BEGIN
		UPDATE PS_GameData.dbo.Chars SET CharName = '[King]' + @Nome WHERE CharID = @CharID
		UPDATE PS_GameData.dbo.Guilds SET MasterName = '[King]' + @Nome WHERE MasterCharID = @CharID
		UPDATE PS_GameData.dbo.FriendChars SET FriendName = '[King]' + @Nome WHERE FriendID = @CharID
	END
END

Add this code to the kill count you want.

ELSE IF @K1 >= 100000 --  Number of Kills
	BEGIN
		UPDATE PS_GameData.dbo.Chars SET CharName = '[King]' + @Nome WHERE CharID = @CharID
		UPDATE PS_GameData.dbo.Guilds SET MasterName = '[King]' + @Nome WHERE MasterCharID = @CharID
		UPDATE PS_GameData.dbo.FriendChars SET FriendName = '[King]' + @Nome WHERE FriendID = @CharID
	END

so if we use more tags like this.. if player reach 100,000 kill he got tag [King][Killer]Charname ?

what if everytime we reach new kill .. removed old tag then change to new tag like if we reach 50,000 kill got tag [Killer] then if reach 100,000 kill removed [Killer] Tag then add [King] tag..
because if like that the charname is too long if make more kill tags..

[sominus]

Yes, it should remove the old tag (if it exists). May be using PATINDEX and REPLACE.