Ok i'm not so sure if changing the level cap is the opposite command for the unlocking 50-56 quest and setting maxlevel to 66
What I want is to lock the level to 50 so noone can go over 50 (for now)
can anyone link me to the post for it? i can't see the guide in how to change it in the tutorial index..
Or maybe this will do?
I just edited something i found in one of the links
CREATE TRIGGER [dbo].[MaxLevel_66] ON [dbo].[tbl_general]
FOR UPDATE
AS
DECLARE @Serial int
SELECT @Serial = Serial from inserted
SET NOCOUNT ON;
IF UPDATE (MaxLevel)
BEGIN
update [dbo].[tbl_general]
set [MaxLevel] = 50 where [Serial] = @Serial and [MaxLevel] >= 50 and [MaxLevel] <= 50
END


Reply With Quote


