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

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

- - ياجماعه ارجوا الرد (https://silkroad4arab.com/vb/showthread.php?t=486144)

ياجماعه ارجوا الرد

انا كنت حاتت موضوع عن الهونور buff للاسف بردك الهونور لحد دلوقتى مشتغلش وعملت ريستارت سيرفر مرتين :( لو سمحتم عايز اعرف اخلى ازاى الاكاديمى يشتغل والناس تخد بفات الاكاديمى عادى

كود PHP:


		
			
USE [SRO_VT_SHARD]

GO

/****** Objeto: Table [dbo].[_TrainingCampHonorRank] Fecha de la secuencia de comandos: 06/07/2012 16:18:24 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[_TrainingCampHonorRank](

[Ranking] [int] NOT NULL,

[CampID] [int] NULL,

[Rank] [tinyint] NULL,

CONSTRAINT [PK__TrainingCampHonorRank] PRIMARY KEY CLUSTERED 

(

[Ranking] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]

) ON [PRIMARY]

شغل الكويري دة

باشا لازم ريستارت سيرفر ؟
ولا اشغل الكويرى ده وكله هيبقى تمام ؟

دى كده صح ولا اشيل العلامتين دول علشان لمما جيت احوته كده جابلى Msg 2714, Level 16, State 6, Line 1
There is already an object named '_TrainingCampHonorRank' in the database.

وحضرتك واحد ادالى الكويرى ده امبارح بردك :( بس بردك مش شغاله
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

اعمل الي انا ادتهولك شغال 100% و زم ترستر السيرفر اكيد

ياصحبى لما بجى اعمل Excute مش بينفع بيديلى
Msg 2714, Level 16, State 6, Line 1
There is already an object named '_TrainingCampHonorRank' in the database.

بس الموجود كويرى ادى لواحد بس امل انا عايز اى حد يعمل اكاديمى ويخرج ناس يخد البفان اوتوماتيك اكيد حضرتك فاهمنى :(

مهو الواحد لما بيعلي الناس لحد ليفل 40 وبياخد البف بعد كام ساعة مثلا في اي جيم كده
ثانيا انت داتا بيز ايه ؟؟

أعمــلـ الكــويـرى ده شغــالـ وعـنـ تجــربـة

كود:

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

يااستاذ DB Editor] Marwan انا دلوقتى عملت الكورى ده و استاذ Ezio والله انا طلعت كذا واحد لفل 40 من امابرح ماختش اى حاجه :(

اقتباس:

المشاركة الأصلية كتبت بواسطة DB Editor] Marwan Abbas] (المشاركة 4580497)

أعمــلـ الكــويـرى ده شغــالـ وعـنـ تجــربـة

كود:

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

exec _TRAINING_CAMP_UPDATEHONORRANK

لســا بـردوا نفــسـ المشكلــة ؟!!