مشكلة فى الاكاديمى

[ღ♥ČrimeḾaster♥ღ]

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

http://www7.0zz0.com/2016/04/05/00/743788488.jpg

http://www7.0zz0.com/2016/04/05/00/938509653.jpg
لما عشان اعمل تسجيل فيها مش بيرضى خالص و مش بيجيب اى حاجة

[M.HADAD]

شوف الوقت بتاعها فى SMC مظبوط

[ღ♥ČrimeḾaster♥ღ]

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

[Jayden]

اتأكد ان ال SP ده عندك كده

_TRAINING_CAMP_CREATE

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 4/5/2016 3:50:32 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 = '2030-01-01 00:00:00'
/**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, '', '')**/
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

[ღ♥ČrimeḾaster♥ღ]

الف مليون شكر ي Jayden
يغلق ي رجالة

[Dev.BigBear]

##