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

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)

- قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)

- - ازاي اشغل الاكادمي (https://silkroad4arab.com/vb/showthread.php?t=491185)

zeko111

22-03-2013 08:48 PM

ازاي اشغل الاكادمي

ازاي اشغل الاكادمي في السيرفر

ممكن حل الاكادمي مش شغال

GM] Reflexs]

23-03-2013 12:49 AM

استخدم الكويري ده

كود بلغة HTML:

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

و استخدم ده كمان

كود بلغة HTML:

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

اقتباس:

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

و استخدم ده كمان

كود بلغة HTML:

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

اقتباس:

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

اتفضل ال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

كود PHP:

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

تمام الله ينور

يغلق #

الساعة الآن 07:29 PM.