ازاى اوقف الاكادمى

[alieleraky]

السلام عليكم
كنت محتاج طريقه توضح ازاى اغلق الاكدمى

[محمد منتصر]

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

اعمل الكويري ده لو عايز تقفل تسجيل الهونر خالص مينفعش حد يسجل وكمان شيلها من الميديا
0 UIIT_STT_TC_OPEN 견ىٹµى†Œ ê°œى„¤ 0 0 0 0 0 Academy Establishment Thiأ•t lأ‹p hأ¤c viأ–n 0 0 0 0 0 0
0 UIIT_MSG_TC_TRAININGCAMP_OPEN <sml2>견ىٹµى†Œê°œى„¤ 비ىڑ©ىœ¼ë،œ 10만 골드가 ي•„ىڑ” ي•©ë‹ˆë‹¤.<br>견ىٹµى†Œë¥¼ ê°œى„¤ي•کى‹œê²*ىٹµë‹ˆê¹Œ?</sml2> 0 0 0 0 0 <sml2>Fee of 100,000 gold is needed to establish an Academy.<br>Would you like to establish an Academy?</sml2> <sml2>Phأ‌ më hأ¤c viأ–n lµ 100.000 gold.<br>B¹n cأ£ muèn thiأ•t lأ‹p hأ¤c viأ–n kh«ng?</sml2> 0 0 0 0 0 0
0 UIIT_STT_TC_HONOR_RANKING ëھ…ىکˆ ىˆœىœ„ 0 0 0 0 0 Honor Rank Thأ¸ h¹ng danh dù 0 0 0 0 0 0
وخلي اللي عندك في textuisystem زي دول بدل 1 خليها 0:Emoji12:

[alieleraky]

يعنى كده لو واحد واخدها هيروحو من عليه

[alieleraky]

لو حد معلق الهونر بف هتروح من عليه

[محمد منتصر]

لا لو حد معاه البف الغيها من refskill