I have made this trigger:
But it seem don't work, but no error message... could someone help me? Pleaaase. I use 5.4 PS_Game, and it's moleboxed with level 70 max, so i made this... Thanks for reading
PHP Code:
USE [PS_GameData]
GO
/****** Object: Trigger [dbo].[LevelMax] Script Date: 26/04/2015 20:11:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER trigger [dbo].[LevelMax]
on [PS_GameData].[dbo].[Chars]
after UPDATE
as
IF (UPDATE (Level) and UPDATE (StatPoint) and UPDATE (SkillPoint))
begin
declare @oldLevel int
declare @newLevel int
declare @oldStatPoint int
declare @newStatPoint int
declare @oldSkillPoint int
declare @newSkillPoint int
set @oldLevel = (select Level from deleted)
set @newLevel = (select Level from inserted)
set @oldStatPoint = (select StatPoint from deleted)
set @newStatPoint = (select StatPoint from inserted)
set @oldSkillPoint = (select SkillPoint from deleted)
set @newSkillPoint = (select SkillPoint from inserted)
if @newLevel>60
begin
SET @newLevel=60
SET @newStatPoint=@oldStatPoint
SET @newSkillPoint=@oldSkillPoint
end
end
