Here the Actually Siege script goes until year 2009
You must run in sql Query analizer
First This :
Code:
USE [Character] GO /****** Object: UserDefinedFunction [dbo].[FN_BinDateToDateTime] Script Date: 01/10/2010 19:35:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO /****************************************************************************** ? ? : dbo.FN_BinDateToDateTime ? ? : Binary Date? DateTime ???? ????. ??? : ????: Ver Date Author Description --------- ---------- --------------- ------------------------------------ 1.0 2006-05-05 Han Ji Wook 1. ???? 2.0 2010-01-10 Han Ji Wook ******************************************************************************/ ALTER FUNCTION [dbo].[FN_BinDateToDateTime] ( @i_bin_time binary(4) ) RETURNS datetime AS BEGIN DECLARE @v_datetime datetime DECLARE @v_strAux varchar(20) DECLARE @v_strtime varchar(20) SET @v_strAux = CAST(CAST(@i_bin_time as int) as varchar(20)) IF len(@v_strAux) = 7 SELECT @v_strtime = '20100' + CAST(CAST(@i_bin_time as int) as varchar(20)) ELSE IF len(@v_strAux) = 8 SELECT @v_strtime = '2010' + CAST(CAST(@i_bin_time as int) as varchar(20)) ELSE SELECT @v_strtime = '200' + CAST(CAST(@i_bin_time as int) as varchar(20)) SELECT @v_strtime = SUBSTRING(@v_strtime,1,4) +'-'+SUBSTRING(@v_strtime,5,2) +'-'+SUBSTRING(@v_strtime,7,2) +' '+SUBSTRING(@v_strtime,9,2) +':'+SUBSTRING(@v_strtime,11,2) SELECT @v_datetime = CAST(@v_strtime as datetime) RETURN @v_datetime END
Code:
DECLARE @v_siege_no char(10) DECLARE @guild_code varchar(10) DECLARE @guild_name varchar(30) DECLARE @v_strDate varchar(10) DECLARE @v_regdate varchar(10) DECLARE @v_strChannel varchar(2) DECLARE @i_bychannel tinyint DECLARE @o_dwDungeonRegistTime varbinary(4) DECLARE @o_DeadFrontTimeInfo varbinary(1000) DECLARE @o_sp_rtn int DECLARE @o_dwRegistTimeStart varbinary(4) DECLARE @o_dwRegistTimeEnd varbinary(4) DECLARE @o_dwTaxRegistTime varbinary(4) declare @o_dwStartTime varbinary(4) declare @o_dwRegistTime varbinary(4) DECLARE @v_strDate1 varchar(10) DECLARE @i_GetDate datetime DECLARE @v_siege_start_date varchar(14) DECLARE @v_siege_start_time varbinary(4) set @i_GetDate=getdate() SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000' SELECT @v_siege_start_time = SUBSTRING(@v_siege_start_date,4,1) * 100000000 + SUBSTRING(@v_siege_start_date,5,2) * 1000000 + SUBSTRING(@v_siege_start_date,7,2) * 10000 + SUBSTRING(@v_siege_start_date,9,2) * 100 + SUBSTRING(@v_siege_start_date,11,2) SET @guild_code = '001' SET @guild_name = 'ϵͳĬÈÏ' SET @v_siege_no = SUBSTRING(dbo.FN_DateToShortStrDate(GetDate()), 3, 4) + '0001' INSERT INTO GUILD_INFO(guild_code, guild_name, guild_Level, bystate, bychannel) VALUES (@guild_code, @guild_name, 3, 1, 1) INSERT INTO SIEGE_INFO(SIEGE_NO, CHANNEL_NO, GUILD_CODE, GUILD_NAME, DWSTARTTIME, BYREGISTTIMEFLAG, DEFENDER_INFO, SIEGE_TAG) VALUES (@v_siege_no, 1, @guild_code, @guild_name,@v_siege_start_time, 1, 0X0000, 'Y') EXEC SP_SIEGE_START_TIME_U @guild_code,1,0x01,@v_siege_start_time output,@o_dwRegistTime output,@o_sp_rtn output set @v_strDate1=dbo.FN_BinDateToDateTime(@v_siege_start_time) declare @P1 varchar(13) set @P1=NULL declare @P2 varchar(33) set @P2=NULL declare @P3 varchar(25) set @P3=NULL declare @P4 varbinary(4) set @P4=NULL declare @P5 varbinary(4) set @P5=NULL declare @P6 varbinary(4) set @P6=NULL declare @P7 varbinary(4) set @P7=NULL declare @P8 varbinary(4) set @P8=NULL declare @P9 varbinary(4) set @P9=NULL declare @P10 varbinary(4) set @P10=NULL declare @P11 varbinary(2) set @P11=NULL declare @P12 varbinary(2) set @P12=NULL declare @P13 varbinary(2) set @P13=NULL declare @P14 int set @P14=NULL declare @P15 int set @P15=NULL declare @P16 varbinary(4) set @P16=NULL declare @P17 varbinary(996) set @P17=NULL declare @P18 varbinary(996) set @P18=NULL declare @P19 varbinary(1000) set @P19=NULL declare @P20 int set @P20=NULL exec SP_SIEGE_INFO_R 1, @P1 output, @P2 output, @P3 output, @P4 output, @P5 output, @P6 output, @P7 output, @P8 output, @P9 output, @P10 output, @P11 output, @P12 output, @P13 output, @P14 output, @P15 output, @P16 output, @P17 output, @P18 output, @P19 output, @P20 output select @P1, @P2, @P3, @P4, @P5, @P6,@v_strDate1
- Credits to authors.