USE [PS_GameData]
GO
/* Built By [ADM]CEPNI */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create trigger [dbo].[NewCharsAdded] on [PS_GameData].[dbo].[_CreatedChars]
after INSERT
as
begin
SET NOCOUNT ON
declare
@oldk1 int,
@newk1 int,
@UserUID INT,
@newUserUID INT,
@CharID INT
set @UserUID = (select UserUID from inserted) -- gets useruid from inserted row
SET @CharID = (select CHARID from inserted) -- gets char id from new inserted row
set @newUserUID = (SELECT USERUID FROM PS_gameData.dbo.chars WHERE charID =@charID) -- sets newuserid as the id to look for
set @OLDK1 = (SELECT k1 FROM PS_gameData.dbo.chars WHERE CHARID =@CharID) -- sets @oldk1 as the new chars k1
set @NEWk1 = (select MAX(k1) FROM dbo.chars where UserUID = @newUserUID) -- gets max kills from a account
update PS_GAMEDATA.dbo.CHARS
set K1 = @newk1
from PS_GAMEDATA.dbo.CHARS where @CHARID = CharID
SET NOCOUNT off
END
