Quote:
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
Code:
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:
Code:
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