Shaiya Raid Kill Share

USE [PS_GameData]
GO
/* Publisher By Cyanide DC: Broken#7035 ? */
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 [MENTION=2326962]oldk[/MENTION]1 int, [MENTION=829095]Newk[/MENTION]1 int, [MENTION=2805776]UserU[/MENTION]ID INT, [MENTION=339306]newuser[/MENTION]UID INT, [MENTION=395373]Chari[/MENTION]D INT

set [MENTION=2805776]UserU[/MENTION]ID = (select UserUID from inserted) -- gets useruid from inserted row
SET [MENTION=395373]Chari[/MENTION]D = (select CHARID from inserted) -- gets char id from new inserted row
set [MENTION=339306]newuser[/MENTION]UID = (SELECT USERUID FROM PS_gameData.dbo.chars WHERE charID  [MENTION=395373]Chari[/MENTION]D) -- sets newuserid as the id to look for
set [MENTION=2326962]oldk[/MENTION]1 = (SELECT k1 FROM PS_gameData.dbo.chars WHERE CHARID  [MENTION=395373]Chari[/MENTION]D) -- sets [MENTION=2326962]oldk[/MENTION]1 as the new chars k1
set [MENTION=829095]Newk[/MENTION]1 = (select MAX(k1) FROM dbo.chars where UserUID = [MENTION=339306]newuser[/MENTION]UID) -- gets max kills from a account

update PS_GAMEDATA.dbo.CHARS
set K1 = [MENTION=829095]Newk[/MENTION]1 
from PS_GAMEDATA.dbo.CHARS where [MENTION=395373]Chari[/MENTION]D = CharID
SET NOCOUNT off
END