Dev.Ri3o
24-11-2016, 07:37 PM
http://www4.0zz0.com/2015/11/27/18/243536469.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
Disable HonorRank By Academy
الموضوع ده مفيد جدا لسيرفرات ال PVP System عشان بيخلو ال HonorRank من ال NPC
هتعمل ده وتريح دماغك
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 24.11.2016 04:23:29 ******/
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
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/884808031.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/702514124.gif (https://www.0zz0.com)
Disable HonorRank By Academy
الموضوع ده مفيد جدا لسيرفرات ال PVP System عشان بيخلو ال HonorRank من ال NPC
هتعمل ده وتريح دماغك
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_TRAINING_CAMP_CREATE] Script Date: 24.11.2016 04:23:29 ******/
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
http://www4.0zz0.com/2015/11/27/18/171651594.gif (https://www.0zz0.com)
http://www4.0zz0.com/2015/11/27/18/735351340.gif (https://www.0zz0.com)