[joesuef]

ضيف ده في
SRO_VT_SHARD>>Programmability>>__AddTimedJob

عدل بس علي ارقم Titile نفس عندك في RefSkill

				if(@JobID = '60001')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 24        Where	CharID	=	@CharID
END
if(@JobID = '60002')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 25        Where	CharID	=	@CharID
END
if(@JobID = '60003')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 26        Where	CharID	=	@CharID
END
if(@JobID = '60004')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 27        Where	CharID	=	@CharID
END
if(@JobID = '60005')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 28        Where	CharID	=	@CharID
END
if(@JobID = '60006')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 29        Where	CharID	=	@CharID
END
if(@JobID = '60007')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 30        Where	CharID	=	@CharID
END
if(@JobID = '60008')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 31        Where	CharID	=	@CharID
END
if(@JobID = '60009')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 32        Where	CharID	=	@CharID
END
if(@JobID = '60010')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 33        Where	CharID	=	@CharID
END
if(@JobID = '60011')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 34        Where	CharID	=	@CharID
END
if(@JobID = '60012')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 35        Where	CharID	=	@CharID
END
if(@JobID = '60013')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 36        Where	CharID	=	@CharID
END
if(@JobID = '60014')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 37        Where	CharID	=	@CharID
END
if(@JobID = '60015')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 38        Where	CharID	=	@CharID
END
if(@JobID = '60016')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 39        Where	CharID	=	@CharID
END
if(@JobID = '60017')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 40        Where	CharID	=	@CharID
END
if(@JobID = '60018')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 41        Where	CharID	=	@CharID
END
if(@JobID = '60019')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 42        Where	CharID	=	@CharID
END
if(@JobID = '60020')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 43        Where	CharID	=	@CharID
END
if(@JobID = '60021')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 44        Where	CharID	=	@CharID
END
if(@JobID = '60022')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 45        Where	CharID	=	@CharID
END
if(@JobID = '60023')
BEGIN 
UPDATE dbo._Char   SET HwanLevel = 46        Where	CharID	=	@CharID
END