مشكلة في Acadmey

[banner]

السلام عليكم انا كنت عامل الموضوع ده واتقفل كنت تعبان مكنتش عارف اقعد ع النت وفي ناس كتير ردت بس للاسف متحلتش بردو وللعلم انا مش مشغل اي فلتر

acadmey عندي غريب اوي بدخل اول اكونت وباخد منو ال بوينت باجي اعمل invite لكونت جديد يقولي request operation has failed. واجرب اعمل رقم اكادمي واخش بالاكونت التاني الاكونتين بيخدو كراش وبفتح ملقهوش دخل الاكديمي بردو :)

https://d.top4top.net/p_99946a041.jpg

[.Gamer.]

انت عامل enable لل academy في الداتا بيز اصلا ؟

شوف الموضوع ده ممكن يساعدك
http://www.silkroad4arab.com/vb/showthread.php?t=619950

[banner]

انت عامل enable لل academy في الداتا بيز اصلا ؟

شوف الموضوع ده ممكن يساعدك
http://www.silkroad4arab.com/vb/showthread.php?t=619950

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

[.Gamer.]

جرب دي ...


TRUNCATE TABLE _TrainingCampHonorRank
GO
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



ورستر السيرفر وجرب !

[banner]

جرب دي ...


TRUNCATE TABLE _TrainingCampHonorRank
GO
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



ورستر السيرفر وجرب !

جربتها والله حضرتك ممكن تبص ع الصوره https://d.top4top.net/p_99946a041.jpg

[BuiLt4KiLl]

تمام ،
ده موضوع حضرتك بنفس المشكلة مشكلة في Acadmey (http://www.silkroad4arab.com/vb/showthread.php?t=626884)
و قولنا لحضرتك انها ممكن تكون من الـFilter
لكن مش عارف إذا كنت جربت الخطوة اللي قولتلك عليها دي ولا لا ،
بس عامةً هتبدل الـProcedures دول باللي عندك
و اقفل ملفات السيرفر كلها و افتحها و جرب كدا

_GetCharTrainingCamp
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_GetCharTrainingCamp] Script Date: 9/28/2018 12:54:32 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_GetCharTrainingCamp]
@CharName VARCHAR(64)
AS
SET NOCOUNT ON

DECLARE @CharID INT
IF NOT EXISTS (SELECT CharID FROM _Char WITH (NOLOCK) WHERE CharName16 = @CharName)
BEGIN
RETURN -1
END

SELECT @CharID = CharID FROM _Char WITH (NOLOCK) WHERE CharName16 = @CharName

DECLARE @CampID INT
SET @CampID = 0

SELECT @CampID = CampID FROM _TrainingCampMember WHERE CharID = @CharID
IF @@ERROR <> 0 OR @@ROWCOUNT = 0
BEGIN
RETURN -2
END

SET NOCOUNT OFF

RETURN @CampID

_TrainingCampRanking
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TrainingCampRanking] Script Date: 9/28/2018 12:57:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_TrainingCampRanking]
AS

SELECT Ranking, Tcm.CharName, Rank
FROM _TrainingCampHonorRank AS Tchr JOIN _TrainingCampMember AS Tcm
ON Tchr.CampID = Tcm.CampID
WHERE Tcm.MemberClass = 0 -- 0أ€آ؛ أˆأ„°أںأ€أژ

أتمنى حضرتك تجرب و تقول لنا وصلت لايه
و غير كدا هتبقا مشكلة Filter لان في الموضوع اللي فات و ده
أنا عطيتك كل الـProcedures المسؤولة عن الـHonor و كلهت سليمة

[BuiLt4KiLl]

يغلق ،
لمرور 48 ساعة دون رد صاحب الموضوع
##