Honar Buff Erorr

[freer3]

السلام عليكم
يا جماعة انا عاوز اعرف ازاى اشغل الكويرى الموجوده فى اللينك ده بس هتلقوها تحت شوية مع العلم ان ده لل HOnar Buff
http://www.silkroad4arab.com/vb/showthread.php?t=473567
انا لما عملتها و كتبت اسم الشير جبلى تحت فى SQL كده
Msg 245, Level 16, State 1, Line 10
Conversion failed when converting the varchar value '1234[Number Of Graduates] ' to data type int.
وانا مش عارف اعمل ايه ارجو الحل

[freer3]

UPUPUPUPUPUPUPU

[●♥ Marwan1337 ♥●]

أعملــهــا كــده

USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '*[YourCharName]'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '[200] '
SET @HonorPoints= @Graduates * 39

--------------------

UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @Graduates
WHERE [Dbo].[_TrainingCamp].[ID] = @CampID
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @HonorPoints
WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID