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

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

- - طلبين صغيرين (https://silkroad4arab.com/vb/showthread.php?t=490101)

طلبين صغيرين

1-عاوز Query اقفل بية البلص بس
2-عاوز Query يدى الناس بيف اكدمى ة يكون شغال

و شكرا

ترجمة بعد ازنك :d

اقتباس:

المشاركة الأصلية كتبت بواسطة gm] reflexs] (المشاركة 4612825)

ترجمة بعد ازنك :d

اية الى مش فاهمة

1-مينفعش تقفل الplus

2-استخدم دى الاول

كود:

 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

و بعد كده دى

كود:

USE [SRO_VT_SHARD]

DECLARE @CharName Varchar (MAX)

DECLARE @Graduates INT

DECLARE @HonorPoints INT

DECLARE @CharID INT

DECLARE @CampID INT

SET @CharName = 'Charname'

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

اقتباس:

المشاركة الأصلية كتبت بواسطة bombom (المشاركة 4613688)

1-مينفعش تقفل الplus

2-استخدم دى الاول

كود:

 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

و بعد كده دى

كود:

use [sro_vt_shard]

declare @charname varchar (max)

declare @graduates int

declare @honorpoints int

declare @charid int

declare @campid int

set @charname = 'charname'

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

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

اقفل السيرفر و افتحه تانى

اقتباس:

المشاركة الأصلية كتبت بواسطة bombom (المشاركة 4613835)

اقفل السيرفر و افتحه تانى

بردوا نفس المشكلة مافيش اى طريق تانية