الموقع العربي الاول للعبة Silkroad Online

- قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)

- - ازاى ادى حد Full Honor Buff (https://silkroad4arab.com/vb/showthread.php?t=542609)

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

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

كود:

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

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

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

و دى صوره

http://im38.gulfup.com/U6GIW.jpg

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

كود:

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

ولو متحلتشى بردو استخدم الشرح ده
اولآ لازم يكون الكركتر عامل اكاديمى الى هياخد ال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 يعنى

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

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

HonorPoints

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