المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : ازاي اشغل الاكادمي

zeko111
22-03-2013, 08:48 PM
ازاي اشغل الاكادمي في السيرفر

ممكن حل الاكادمي مش شغال
GM] Reflexs]
23-03-2013, 12:49 AM
استخدم الكويري ده

USE [SRO_VT_SHARD]
DECLARE @Char**** Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @Char**** = '_2ReaiS_'
SET @CharID = (Select CharID FROM _Char Where Char****16 = @Char****)
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
GM] Reflexs]
23-03-2013, 12:50 AM
و استخدم ده كمان

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
zeko111
23-03-2013, 06:46 PM
reflexs];4621904']و استخدم ده كمان

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



نفس المشكله في حل تاني؟
Mahmoud Rashwan
24-03-2013, 04:24 AM
بعد متعمل كدة رستر السيرفر
MandoLove
24-03-2013, 11:46 AM
تمام استمر
zeko111
24-03-2013, 05:28 PM
والله يا رجاله انا عملت كل اللي انتو قولتو عليه وبردو الاكادمي مش بيجي


علما بان اليرفر pvp strt lvl 110
Cursed_Devil
25-03-2013, 01:39 AM
اتفضل الQuery ديه جرب و قولى.

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
zeko111
25-03-2013, 01:36 PM
اتفضل الquery ديه جرب و قولى.

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



ده عباره عن ايه يا بوب ممكن توضيح ؟
Mahmoud Rashwan
25-03-2013, 08:29 PM
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
zeko111
25-03-2013, 08:48 PM
thx ya rgalaaaaaaaaaaaaaaaaaa et7lt
الف شكر للناس التماام اللي هنا
GM] Reflexs]
25-03-2013, 11:22 PM
اي خدمة :(101):
Mahmoud Rashwan
26-03-2013, 02:30 AM
يغلق#
BomBom
26-03-2013, 03:31 AM
تمام الله ينور

يغلق #