[●♥ 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