25-02-2013, 10:29 PM
|
#2
|
|
|
• الانـتـسـاب » Feb 2011
|
|
• رقـم العـضـويـة » 79792
|
|
• المشـــاركـات » 286
|
|
• الـدولـة » I Can't Remeber
|
|
• الـهـوايـة » Program & Designer
|
|
• اسـم الـسـيـرفـر »
|
|
• الـجـنـس »
|
|
• نقـاط التقييم » 13
|
|
|
 
|
Cap بيتعدل من Sro_Client
و ده كويرى للاكونت بف
|
|
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = 'Char Name'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '1234'
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
|
يا ريت اكون افدتك
|
|
|
|