ازاى ادى حد Full Honor Buff

[lordbotereslam]

انا عارف الكويرى و شوفته كذه مره بس الارقام اللى فيها دى اغيرها ازاى ولا اعملها ايه !؟

[che_9299]

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

اكتب رقم رقم وانته فاتح السيرفر كده اشتغل بالكويرى وانته هتعرف كل رقم فيهم بيعمل ايه هوه من 1 ~ 4

[lordbotereslam]

طب معلش بص يا باشا كده انا جربت بـ 1 , 2 , 3 و 4

بيجيب
(0 row(s) affected)

و دى صوره

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

[che_9299]

طب استخدم ده الاول وبعد كد جرب وقولى ايه الكلام

USE SRO_VT_SHARD 
TRUNCATE TABLE _TrainingCampHonorRank 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50) 
exec _TRAINING_CAMP_UPDATEHONORRANK

[che_9299]

ولو متحلتشى بردو استخدم الشرح ده
اولآ لازم يكون الكركتر عامل اكاديمى الى هياخد الhonor buff
افتحSQL
وبعديها دوس SRO_VT_SHARD
و بعديها _TrainingCamp هتلاقى
GraduateCount و Evaluationpoint حط هنا 200 و هنا 200

افتح _TrainingCampMember و اعمل copy لل CampIID بتاع اسم الشخصية الى عايزها
افتح _TrainingCampHonorRank و اكتب فى CampIID الاى دى اكيد و فى Rank اكتب 1 و فى Raning اكتب 1 بردوا ... ]علما بان Rank دى بفات honor buff و 1 يعنى كل البفات و Ranking دى رقم كام فى سجل الhonor buff player الى بتيجها فى الجيم من ستورج honor buff بس كداا
بعد ما تعمل كل دا اقفل كل ملفات السيرفر و افحها تانى و مبروك عليك honor buff
لو عايز تعمل تانى اكتب فى Ranking 2 و لو عايز تعمل كركتر ثالثا اكتب فى Raning 3 و هكذا لكن فى Rank دى 1 يعنى كل البفات king يعنى

[افندينا ™Hamboka™]

@Graduates = '1234[Number Of Graduates] '
SET @HonorPoints= @Graduates * 39

Graduates
ديه معنه ان يخاد كام بق يعنى King acdmy خليها 1 لو هاوز ياخد اول بف خليها 4 و هاكذا


HonorPoints

ديه عداد honnor الى مع cher اكتبه اى حاجه