Problem With Academy

[Blizzard]

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

[Dev.Klito]

انت شغال بجراد و فلتر ايه

[Blizzard]

Sa Vi

[Dev.Klito]

طب اتأكد انك مش عامل Disable Academy

[Blizzard]

متأكد و قفلت الحمايه خالص و دخلت من غير حمايا بردو مش رادى يسجل فى Academy

[Mahmoud Rashwan]

جرب ده و اعمل رسترت USE SRO_VT_SHARD /* By ™BaZzZoKa™ */
GO
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

[Blizzard]

Not Work :v9v9net_010::v9v9net_010:

[Mahmoud Rashwan]

جرب ده مع التاني USE SRO_VT_SHARD
exec _TRAINING_CAMP_UPDATEHONORRANK

[Blizzard]

Not Work :111 (13)::111 (13):

[Blizzard]

UP

[Mahmoud Rashwan]

كدا فى فلتر اكيد قافل الاكادمى

[Blizzard]

انا بفتح من غير حمايا خالص وبردو مش شغاله

[Dev.Klito]

ممكن تكون الــ Academy مقفولة فى الداتا اصلا و الحـــل استخدم داتا غيرها

حــــــــــل اخـــــــر فـــــــــــى الاسفـــــــــل !!

[Dev.Klito]

او اعمل دى و شوف ...

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 3/6/2017 7:20:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_TRAINING_CAMP_CREATE]
@CreaterID INT
AS
SET NOCOUNT ON

IF EXISTS (SELECT CharID FROM _TrainingCampMember WHERE CharID = @CreaterID)
BEGIN
RETURN -1001
END

DECLARE @CampID INT
DECLARE @FoundationDate SMALLDATETIME
SET @FoundationDate = GETDATE()

BEGIN TRANSACTION

DECLARE @HonorPoint INT
SET @HonorPoint = 0
SELECT @HonorPoint = HonorPoint FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CreaterID

IF @HonorPoint <> 0
BEGIN
DELETE FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CreaterID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -6
END
END

INSERT INTO _TrainingCamp (CreationDate, Rank, GraduateCount, EvaluationPoint, LatestEvaluationDate, CommentTitle, Comment )
VALUES ( @FoundationDate, 5, 0, 0, @FoundationDate, '', '')

SET @CampID = @@IDENTITY

IF (@@ERROR <> 0 OR @@ROWCOUNT = 0 OR @CampID = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -7
END

DECLARE @Ret INT
EXEC @Ret = _TrainingCamp_FnAddMember @CampID, @CreaterID, @HonorPoint
IF (@@ERROR <> 0 OR @Ret <= 0)
BEGIN
ROLLBACK TRANSACTION
RETURN @Ret
END

COMMIT TRANSACTION

SET NOCOUNT OFF

RETURN @CampID

[!_Ahmed Elabbasy_!]

بوص حضرتك جرب برنامج vSro - Auto Query Tool v1.3

[Dev.Klito]

بوص حضرتك جرب برنامج vSro - Auto Query Tool v1.3

هو مش هيكون محتاج اى برنامج لان البروسيد عندو مقفولة انا بعتله كيورة هتفتحها و ان شاء الله كل حاجة هتشتغل

[MikrotikBody]

بوص حضرتك جرب برنامج vSro - Auto Query Tool v1.3

نعم ؟ :wallbash::wallbash:

[MikrotikBody]

قبل ما تغير الداتا ممكن ترفع البروسيدورات دي
_TRAINING_CAMP_CREATE
_TRAINING_CAMP_ADDMEMBER

[Blizzard]

تمام هو تم الحل بس فى مشكله تانى :D

[Blizzard]

دى صوره من جوه الجيم
http://i.epvpimg.com/nAEmbab.jpg

و دى صور من الVPS

http://i.epvpimg.com/yj8rdab.jpg
http://i.epvpimg.com/A2VVcab.jpg

انا عاوز اخليه يعمل ابديت لى الهونار باف كل 12 ساعه مثلا 12 الضهر و 12 بليل

[MikrotikBody]

أظبطها من الي SMC

[Dev.Klito]

دى صوره من جوه الجيم
http://i.epvpimg.com/nAEmbab.jpg

و دى صور من الVPS

http://i.epvpimg.com/yj8rdab.jpg
http://i.epvpimg.com/A2VVcab.jpg

انا عاوز اخليه يعمل ابديت لى الهونار باف كل 12 ساعه مثلا 12 الضهر و 12 بليل


يعنى هو كدا اشتغل المشكلة الجديدة فى موضوع جديد

لو لسا متحلتش كلمنى عشان افتحو تانى

##