USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CS_GetCastleTotalInfo] Script Date: 03/01/2017 03:19:09 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WZ_CS_GetCastleTotalInfo]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WZ_CS_GetCastleTotalInfo]
GO
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CS_GetCastleTotalInfo] Script Date: 03/01/2017 03:19:09 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_CS_GetCastleTotalInfo]
@iMapSvrGroup SMALLINT,
@iCastleEventCycle INT
AS
BEGIN
DECLARE @iCastleSiegeTerm INT
SET @iCastleSiegeTerm = @iCastleEventCycle
DECLARE @iFirstCreate INT
SET @iFirstCreate = 0
BEGIN TRANSACTION
SET NOCOUNT ON
IF NOT EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA WITH (READUNCOMMITTED)
WHERE MAP_SVR_GROUP = @iMapSvrGroup)
BEGIN
DECLARE @dtStartDate datetime
DECLARE @dtEndDate datetime
DECLARE @dtStartDateString varchar(32)
DECLARE @dtEndDateString varchar(32)
SET @dtStartDate = GetDate()
SET @dtEndDate = DATEADD(dd, @iCastleSiegeTerm, GetDate())
SET @dtStartDateString = CAST(DATEPART(YY, @dtStartDate) AS char(4)) + '-' + CAST(DATEPART(MM, @dtStartDate) AS char(2)) + '-' + CAST(DATEPART(DD, @dtStartDate) AS char(2)) + ' 00:00:00'
SET @dtEndDateString = CAST(DATEPART(YY, @dtEndDate) AS char(4)) + '-' + CAST(DATEPART(MM, @dtEndDate) AS char(2)) + '-' + CAST(DATEPART(DD, @dtEndDate) AS char(2)) + ' 00:00:00'
INSERT INTO MuCastle_DATA VALUES (
@iMapSvrGroup,
@dtStartDateString,
@dtEndDateString,
0,
0,
0,
'',
0,
0,
0,
0
)
SET @iFirstCreate = 1
END
SELECT MAP_SVR_GROUP,
DATEPART(YY,SIEGE_START_DATE) As SYEAR,
DATEPART(MM,SIEGE_START_DATE) As SMONTH,
DATEPART(DD,SIEGE_START_DATE) As SDAY,
DATEPART(YY,SIEGE_END_DATE) As EYEAR,
DATEPART(MM,SIEGE_END_DATE) As EMONTH,
DATEPART(DD,SIEGE_END_DATE) As EDAY,
SIEGE_GUILDLIST_SETTED,
SIEGE_ENDED,
CASTLE_OCCUPY,
OWNER_GUILD,
MONEY,
TAX_RATE_CHAOS,
TAX_RATE_STORE,
TAX_HUNT_ZONE,
@iFirstCreate As FIRST_CREATE
FROM MuCastle_DATA WITH (READUNCOMMITTED)
WHERE MAP_SVR_GROUP = @iMapSvrGroup
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
GO