lỗi Job khi reset lại máy

[PhamNinh]

bạn nào chưa làm đc cái start UyThacOnline

thì.

1. tạo Job UyThacOnline
2. Tạo Store Procedure (code bên dưới nhé)

Run vô tư. đã success ủy thác online

tks: Nt Anh

Close

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

Update Character
SET UyThac = 0
From Character JOIN MEMB_STAT
ON Character.AccountID = MEMB_STAT.memb___id AND (Character.UyThac=1) AND ((MEMB_STAT.ServerName NOT LIKE @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 PointUyThac = PointUyThac + @PointUyThac
FROM MEMB_STAT JOIN AccountCharacter ON MEMB_STAT.ConnectStat = 1 and MEMB_STAT.ServerName LIKE @SubUyThac and MEMB_STAT.memb___id = AccountCharacter.Id 
JOIN Character ON AccountCharacter.GameIDC = Character.Name and Character.UyThac = 1

End
GO