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

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم المواضيع المكررة و المخالفة (https://silkroad4arab.com/vb/forumdisplay.php?f=58)
-   -   Query (https://silkroad4arab.com/vb/showthread.php?t=508276)

Ch3tos 13-06-2013 05:31 AM
Query
 
Query Honor Baff Please

SinGo 13-06-2013 07:45 AM

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

ELjOkeR 13-06-2013 09:23 AM
اتفضل ..
[SPOILER]
كود PHP:
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 
[/SPOILER]

وبعد لما تعملها تعمل Update لل Honor Rank
من الداتا وتعمل Restart Gameserver .

Ch3tos 13-06-2013 08:23 PM
كويري تشغيل الـ Honor Buff لو سمحت

nesrelshark 13-06-2013 08:35 PM
[SPOILER]USE SRO_VT_SHARD_INIT
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[/SPOILER]

وى كلمنى على الياهو علشان عيزك


الساعة الآن 03:20 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.