اكاديمي

[saqr2003]

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

[Dev.Ri3o]

يعنى بيقولك ايه لما بتجيى تعملخها بيطلعلك Error ؟

[code_x]

جرب دول

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

و اعمل restart

[saqr2003]

يعنى بيقولك ايه لما بتجيى تعملخها بيطلعلك Error ؟

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

[Dev.Ri3o]

مش فاهمك ؟ يعنى اما بتجيى تعمل New Academy من عند ال Storage بيعمل ولا لا
ولا انت قصدك ان هو بيتعمل بس مش بيظهر فى ال Rank ومش بياخد Buffs ؟

[saqr2003]

مش فاهمك ؟ يعنى اما بتجيى تعمل New Academy من عند ال Storage بيعمل ولا لا
ولا انت قصدك ان هو بيتعمل بس مش بيظهر فى ال Rank ومش بياخد Buffs ؟

مش بيتعمل

[Dev.Ri3o]

يعنى الاختيار بتاع ال Create موجود بس اما بتكتب اسم ال Academy مفيش حاجة بيتعملها Create ؟

[saqr2003]

يعنى الاختيار بتاع ال Create موجود بس اما بتكتب اسم ال Academy مفيش حاجة بيتعملها Create ؟

https://s30.postimg.org/u4y1wxsrl/Postimage_org.jpg (https://postimg.org/image/wm9t47cnx/)img (https://postimage.org/)

بعد مبدوس Yes

https://s24.postimg.org/w9fm2adyd/Postimage_org.jpg (https://postimg.org/image/9kqf2pwkh/)adult photo hosting (https://postimage.org/)

مفيش حاجه بتحصل

[MikrotikBody]

استخدم ده حضرتك
واعمل ريسترات للجيم سيرفر والشيرد
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 12/12/2016 11:39:11 PM ******/
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

[saqr2003]

استخدم ده حضرتك
واعمل ريسترات للجيم سيرفر والشيرد
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 12/12/2016 11:39:11 PM ******/
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



الله ينور والله

[Dev.Ri3o]

##