عاجللللل طلبين وضغيرين والله ارجو الحل

[komnda]

المشاركة الأصلية كتبت بواسطة BomBom

بالنسبة ل 2 : من ال gm علم عليه و اكتب كده

/mobkill 1

3- استخدم دى

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    =    '1234[Number Of Graduates] '   
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

شكرا على الرد تمام طب اول واحده ؟ مفيش رد ليه ؟