CREATE TRIGGER giaiblock ON [dbo].[MEMB_STAT]
FOR update
AS
BEGIN
declare
@rs int,
@name varchar(10),
@acc varchar(10),
@check varchar(10),
@ns varchar(15)
select @acc=memb___id FROM inserted where servername='Ten_Server_1'
select @check=vaonham FROM [dbo].[MEMB_INFO] WHERE memb___id=@acc
IF (@check = '1')
BEGIN
update [dbo].[character] set CtlCode='0' where accountid=@acc
update [dbo].[MEMB_INFO] set vaonham='0' where memb___id=@acc
END
END

CREATE TRIGGER RELIFES ON [dbo].[MEMB_STAT]
FOR update
AS
begin
declare
@rs int,
@name varchar(10),
@acc varchar(10),
@ns varchar(15)
select @acc=memb___id FROM inserted where servername='Ten_Server_Gioi_han_Relife'
update [dbo].[character] set CtlCode='1' where accountid=@acc and Relifes>'0'
update [dbo].[MEMB_INFO] set vaonham='1' where memb___id=@acc
end

CREATE TRIGGER RESETS ON [dbo].[MEMB_STAT]
FOR update
AS
begin
declare
@rs int,
@name varchar(10),
@acc varchar(10),
@ns varchar(15)
select @acc=memb___id FROM inserted where servername='Ten_server_gioi_han_reset'
update [dbo].[MEMB_INFO] set vaonham='1' where memb___id=@acc
update [dbo].[character] set CtlCode='1' where accountid=@acc and Resets>'200'
end

CREATE TRIGGER ServerVIP ON [dbo].[MEMB_STAT]
FOR update
AS
begin
declare
@rs int,
@name varchar(10),
@acc varchar(10),
@CHECK1 varchar(10),
@CHECK2 varchar(10),
@ns varchar(15)

SELECT @acc=memb___id FROM inserted where servername='Ten_server_VIp'
SELECT @CHECK1=time_exp_servervip FROM [dbo].[MEMB_INFO] WHERE memb___id=@acc
SELECT @CHECK2=time_now FROM [dbo].[MEMB_INFO] WHERE memb___id=@acc
IF (@CHECK1 < @CHECK2)
BEGIN
update [dbo].[MEMB_INFO] set vaonham='1' where memb___id=@acc
update [dbo].[character] set CtlCode='1' where accountid=@acc
END
ELSE
BEGIN
update [dbo].[MEMB_INFO] set vaonham='0' where memb___id=@acc
update [dbo].[character] set CtlCode='0' where accountid=@acc
END
END