طلبين صغيرين

[2HiT]

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

و شكرا

[GM] Reflexs]]

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

[2HiT]

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

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

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

[BomBom]

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

[2HiT]

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

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]

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

[2HiT]

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

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

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