USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 20/11/2019 06:16:03 م ******/ 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
-- Modified by Modgift.
COMMIT TRANSACTION
SET NOCOUNT OFF
RETURN -6
اعمل الكويري ده لو عايز تقفل تسجيل الهونر خالص مينفعش حد يسجل وكمان شيلها من الميديا