How to add Honor point

[™The Last Emperor™]

USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '[GM]Mario$'
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

احط الكود ده فين مش عارف لو ممكن الخطوات
انا كنت برا ولسه جى للمشرف اللى قفل الموضوع القديم

[DeMooN_Hell]

يغلق وفيه قسم لعمل السيرفرات الخاصة او استفسارات عنها

#

[BomBom]

روح على _TrainingCampSubMentorHonorPoint

فى ال Sro_vt_shard

و اكتب ال char id الى موجود عندك فى ال char_ و فى ال honor point كام point عاوز

بس كده :)

[™The Last Emperor™]

روح على _TrainingCampSubMentorHonorPoint

فى ال Sro_vt_shard

و اكتب ال char id الى موجود عندك فى ال char_ و فى ال honor point كام point عاوز

بس كده :)

عملتها مزودش حاجه فالجيم ؟ انا عاوزو يبقا اعلا Rank علشان اخد honor buff ازاى؟

[MR ! HЄRO]

اعمل بي الكويري الي انا ادتهولك اكتب مكان '[GM]Mario$' الاكونت بتاعك

[Mahmoud Rashwan]

حوط الكوررى دة
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

[™The Last Emperor™]

اعمل بي الكويري الي انا ادتهولك اكتب مكان '[GM]Mario$' الاكونت بتاعك
انا عملت زى ما انت قولت وعملت زا Lover_max مفيش حاجه الهونر بوينت اتحطتت بس مختش البف

[MR ! HЄRO]

انا عملت زى ما انت قولت وعملت زا Lover_max مفيش حاجه الهونر بوينت اتحطتت بس مختش البف

USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '[GM]Mario$'
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


حط اسم الاكونت بتاعك مكان Mario ة هتاخد 4 بقات لو عايز تاخد 2 او 3 عدل الارقام الي تحت

[™The Last Emperor™]

use [sro_vt_shard]
declare @charname varchar (max)
declare @graduates int
declare @honorpoints int
declare @charid int
declare @campid int
set @charname = '[gm]mario$'
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


حط اسم الاكونت بتاعك مكان mario ة هتاخد 4 بقات لو عايز تاخد 2 او 3 عدل الارقام الي تحت

تمام يا جماعه شكرااااااااااااااااااااااااااااااا :111 (4):

[™The Last Emperor™]

يغلق #

[BomBom]

تمام

يغلق #