Giúp mình cái Striger với !!!

[Darkku]

Tình hình bữa lục lại cái web bác Mr.Quy thấy ở trong file server có 2 file Uy Thac Online và Trigger mà không biết dụng ???

Pro nào chỉ em cách dùng với được không ạ

File ủy thác online

- Moi lan chay Job se tang diem Uy thac khi nhan vat : Dang Online va Dung trong lang Lorencia hoac Noria cua Sub-1
- Huy stat Uy thac khi nhan vat : Khac Sub-1, Ngoai lang Lorencia, Noria
    + Trong lang Lorencia : MapNumber=0,95<MapPosX<175,90<MapPosY<165
    + Trong lang Noria : MapNumber=3,165<MapPosX<205 - 85<MapPosY<130

1. Run Script

Create PROCEDURE PointUyThac
As
Begin
Declare
@PointUyThac int,
@SubUyThac varchar(50)
SET @PointUyThac=5                -- So PointUyThac tang
SET @SubUyThac='GS01'        --Ten Sub cho phep Uy Thac

Update CHARACTER
SET TinhTrang_UyThac = 0
From Character,MEMB_STAT
WHERE Character.AccountID = MEMB_STAT.memb___id AND (Character.TinhTrang_UyThac=2) AND ((MEMB_STAT.ServerName != @SubUyThac) OR (Character.MapNumber!=0 AND Character.MapNumber!=3) OR (Character.MapNumber=0 AND (Character.MapPosX<95 OR Character.MapPosX>175 OR Character.MapPosY<90 OR Character.MapPosY>165)) OR (Character.MapNumber=3 AND (Character.MapPosX<165 OR Character.MapPosX>205 OR Character.MapPosY<85 OR Character.MapPosY>130)) )

UPDATE CHARACTER
SET Diemuythac = Diemuythac + @PointUyThac
FROM memb_stat, AccountCharacter, Character
Where MEMB_STAT.ConnectStat = 1 and MEMB_STAT.ServerName = @SubUyThac and MEMB_STAT.memb___id = AccountCharacter.Id and AccountCharacter.GameIDC = Character.Name and Character.TinhTrang_UyThac = 2

End

2. Create a JOB run every 5 minute bat dau tu 0h5'
exec PointUyThac 

File Striger

CREATE TRIGGER ServerVIP ON [dbo].[MEMB_STAT] 
FOR update
AS
begin
declare
@acc varchar(10),
@CHECK1 varchar(10),
@CHECK2 varchar(10),
@CHECK3 varchar(10)

SELECT @acc=memb___id FROM inserted where servername='Servervip'
SELECT @CHECK1=time_exp_servervip FROM [dbo].[MEMB_INFO] WHERE memb___id=@acc
SELECT @CHECK2=Time_Now FROM [dbo].[Check_Server_Time]
SELECT @CHECK3=enable_vip FROM [dbo].[VIPNET_CLIENT] WHERE AccountID_client=@acc
IF ((@CHECK1 < @CHECK2) OR (@check3 = '0'))
BEGIN
update [dbo].[MEMB_INFO] set vaonham='1'  where memb___id=@acc
update [dbo].[character] set CtlCode='1'  where accountid=@acc
END
IF ((@check3 > '0') OR (@CHECK1 > @CHECK2))
BEGIN
update [dbo].[MEMB_INFO] set vaonham='0'  where memb___id=@acc
update [dbo].[character] set CtlCode='0'  where accountid=@acc
END

END

==================================================================================

CREATE TRIGGER Limit ON [dbo].[MEMB_STAT]
FOR update
AS
begin
declare
@acc varchar(10),
@acc1 varchar(10),
@ns varchar(15)
select @acc=memb___id FROM inserted

select @ns=servername FROM inserted
if(@ns='Server02')
begin
update [dbo].[character] set CtlCode='1' where accountid=@acc and resets>'100'
end


if(@ns='Server01')
begin
update [dbo].[character] set CtlCode='0' where accountid=@acc and CtlCode<>'32'
end
end 

==================================================================================

CREATE TRIGGER skill ON [dbo].[MEMB_STAT]
FOR update
AS
begin
declare
@acc varchar(10)

select @acc=memb___id FROM inserted

update [dbo].[character] set Magiclist=0xda0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000ff0000 where accountid=@acc and (class=80 or class=81 or class=82)
end