مشاهدة النسخة كاملة : Buf Accedmy ?
Z.e.K.o
09-11-2012, 10:01 PM
السلام عليكم ورحمة الله وبركاته
يا جماعه حد يقولى لو عاوز ادى بف اكادمى لـCher el Gm اعمل ايه
شكرا
dodolove2888
10-11-2012, 01:06 AM
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '_2ReaiS_'
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
Z.e.K.o
10-11-2012, 01:58 AM
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '_2ReaiS_'
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
شكرا يا باشا
افتح new qurey وبعدين ادوس paste وخلاص على كده
ولا فى اى تعديل على الكود ده
dodolove2888
10-11-2012, 02:17 AM
فى تعديل بدل _2ReaiS_ اكتب اسم Gm قلى حتديلو ال Buff
ღ♥_iMoRy_♥ღ
10-11-2012, 04:53 AM
تسلم كنت محتاجة والله
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc