Siege Change date and time.

[[DEV]Dekaron]

Ok lets see what we can do:

With this you no need use any scripts all what you need to do is follow this steps.

Change Siege Ritual day and time
1) go to MSSQL database character -> Programmability
__a) expand Function
__b) expand Scalar-valued Functions

Go to dbo.FN.GetDungeonRegistTime (click right mouse button and select Modify)
Here we can change when we can start Siege Ritual -8 is how many days before we can start Siege Ritual 17:00:00 its hour


After change press Execute or press F5

Change Date and time for Siege Battle
2) -||-
__a) -||-
__b) Press right mouse button on dbo.GetSiegeStartBinTime and select Modify



After change press Execute or press F5

Now run your server login to your account with GM character.
use command /gm siegestart now and then use command /gm siegeend now



For Sunday start:

USE [CHARACTER]
GO
/****** Object: UserDefinedFunction [dbo].[FN_GetSiegeStartBinTime] Script Date: 25.10.2020 01:31:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/************************************************** ****************************
이 름 : dbo.FN_GetSiegeStartBinTime
설 명 : 다음 공성전 시작일자를 반환한다.
예 제 : select dbo.FN_GetSiegeStartTime --//반환값 : 0x23E52D6C
수정내역:
Ver Date Author Description
--------- ---------- --------------- -----------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
1.1 2006-05-11 Han Ji Wook 1. 다음공성전 시작시간 변경 >> 2주후 일요일
1.2 2009-12-22 Park Chanik 1. 공성 2010년 에러 관련 변경
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_GetSiegeStartBinTime]
(
@i_GetDate DATETIME
) RETURNS VARBINARY(4)
AS
BEGIN
DECLARE @v_siege_start_time VARBINARY(4)
DECLARE @v_siege_start_date VARCHAR(14)
--// 다음공성전 시작시간 Default Setting : 일요일 9시
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

-- 2009년 12월 22일 변경
-- CAST(SUBSTRING(@v_siege_start_date,4,1) AS INT)* 100000000 ---> CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT)* 100000000
SELECT @v_siege_start_time = CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT) * 100000000
+ CAST(SUBSTRING(@v_siege_start_date,5,2) AS INT) * 1000000
+ CAST(SUBSTRING(@v_siege_start_date,7,2) AS INT) * 10000
+ CAST(SUBSTRING(@v_siege_start_date,9,2) AS INT) * 100
+ CAST(SUBSTRING(@v_siege_start_date,11,2) AS INT)

IF DATALENGTH(@v_siege_start_time) <> 4
BEGIN
SELECT @v_siege_start_time = 0x00000000
END

RETURN @v_siege_start_time
END


For Saturday:

USE [CHARACTER]
GO
/****** Object: UserDefinedFunction [dbo].[FN_GetSiegeStartBinTime] Script Date: 25.10.2020 01:31:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/************************************************** ****************************
이 름 : dbo.FN_GetSiegeStartBinTime
설 명 : 다음 공성전 시작일자를 반환한다.
예 제 : select dbo.FN_GetSiegeStartTime --//반환값 : 0x23E52D6C
수정내역:
Ver Date Author Description
--------- ---------- --------------- -----------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
1.1 2006-05-11 Han Ji Wook 1. 다음공성전 시작시간 변경 >> 2주후 일요일
1.2 2009-12-22 Park Chanik 1. 공성 2010년 에러 관련 변경
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_GetSiegeStartBinTime]
(
@i_GetDate DATETIME
) RETURNS VARBINARY(4)
AS
BEGIN
DECLARE @v_siege_start_time VARBINARY(4)
DECLARE @v_siege_start_date VARCHAR(14)
--// 다음공성전 시작시간 Default Setting : 일요일 9시
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

-- 2009년 12월 22일 변경
-- CAST(SUBSTRING(@v_siege_start_date,4,1) AS INT)* 100000000 ---> CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT)* 100000000
SELECT @v_siege_start_time = CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT) * 100000000
+ CAST(SUBSTRING(@v_siege_start_date,5,2) AS INT) * 1000000
+ CAST(SUBSTRING(@v_siege_start_date,7,2) AS INT) * 10000
+ CAST(SUBSTRING(@v_siege_start_date,9,2) AS INT) * 100
+ CAST(SUBSTRING(@v_siege_start_date,11,2) AS INT)

IF DATALENGTH(@v_siege_start_time) <> 4
BEGIN
SELECT @v_siege_start_time = 0x00000000
END

RETURN @v_siege_start_time
END


8 - Sunday
7 - Saturday
6 - Friday
5 - Thursday
4 - Wednesday
3 - Tuesday
2 - Monday

[nemesidevmv]

thanks for the post

[[DEV]Dekaron]

Originally Posted by nemesidevmv

thanks for the post

no problem man.

[yami1203]

Originally Posted by [DEV]Dekaron

Ok lets see what we can do:

With this you no need use any scripts all what you need to do is follow this steps.

Change Siege Ritual day and time
1) go to MSSQL database character -> Programmability
__a) expand Function
__b) expand Scalar-valued Functions

Go to dbo.FN.GetDungeonRegistTime (click right mouse button and select Modify)
Here we can change when we can start Siege Ritual -8 is how many days before we can start Siege Ritual 17:00:00 its hour


After change press Execute or press F5

Change Date and time for Siege Battle
2) -||-
__a) -||-
__b) Press right mouse button on dbo.GetSiegeStartBinTime and select Modify



After change press Execute or press F5

Now run your server login to your account with GM character.
use command /gm siegestart now and then use command /gm siegeend now

go to Leonhart and Check Siege Information


For Sunday start:

USE [CHARACTER]
GO
/****** Object: UserDefinedFunction [dbo].[FN_GetSiegeStartBinTime] Script Date: 25.10.2020 01:31:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/************************************************** ****************************
이 름 : dbo.FN_GetSiegeStartBinTime
설 명 : 다음 공성전 시작일자를 반환한다.
예 제 : select dbo.FN_GetSiegeStartTime --//반환값 : 0x23E52D6C
수정내역:
Ver Date Author Description
--------- ---------- --------------- -----------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
1.1 2006-05-11 Han Ji Wook 1. 다음공성전 시작시간 변경 >> 2주후 일요일
1.2 2009-12-22 Park Chanik 1. 공성 2010년 에러 관련 변경
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_GetSiegeStartBinTime]
(
@i_GetDate DATETIME
) RETURNS VARBINARY(4)
AS
BEGIN
DECLARE @v_siege_start_time VARBINARY(4)
DECLARE @v_siege_start_date VARCHAR(14)
--// 다음공성전 시작시간 Default Setting : 일요일 9시
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

-- 2009년 12월 22일 변경
-- CAST(SUBSTRING(@v_siege_start_date,4,1) AS INT)* 100000000 ---> CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT)* 100000000
SELECT @v_siege_start_time = CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT) * 100000000
+ CAST(SUBSTRING(@v_siege_start_date,5,2) AS INT) * 1000000
+ CAST(SUBSTRING(@v_siege_start_date,7,2) AS INT) * 10000
+ CAST(SUBSTRING(@v_siege_start_date,9,2) AS INT) * 100
+ CAST(SUBSTRING(@v_siege_start_date,11,2) AS INT)

IF DATALENGTH(@v_siege_start_time) <> 4
BEGIN
SELECT @v_siege_start_time = 0x00000000
END

RETURN @v_siege_start_time
END


For Saturday:

USE [CHARACTER]
GO
/****** Object: UserDefinedFunction [dbo].[FN_GetSiegeStartBinTime] Script Date: 25.10.2020 01:31:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/************************************************** ****************************
이 름 : dbo.FN_GetSiegeStartBinTime
설 명 : 다음 공성전 시작일자를 반환한다.
예 제 : select dbo.FN_GetSiegeStartTime --//반환값 : 0x23E52D6C
수정내역:
Ver Date Author Description
--------- ---------- --------------- -----------------------------------
1.0 2006-05-05 Han Ji Wook 1. 초기생성
1.1 2006-05-11 Han Ji Wook 1. 다음공성전 시작시간 변경 >> 2주후 일요일
1.2 2009-12-22 Park Chanik 1. 공성 2010년 에러 관련 변경
************************************************** ****************************/
ALTER FUNCTION [dbo].[FN_GetSiegeStartBinTime]
(
@i_GetDate DATETIME
) RETURNS VARBINARY(4)
AS
BEGIN
DECLARE @v_siege_start_time VARBINARY(4)
DECLARE @v_siege_start_date VARCHAR(14)
--// 다음공성전 시작시간 Default Setting : 일요일 9시
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 7-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

-- 2009년 12월 22일 변경
-- CAST(SUBSTRING(@v_siege_start_date,4,1) AS INT)* 100000000 ---> CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT)* 100000000
SELECT @v_siege_start_time = CAST(SUBSTRING(@v_siege_start_date,3,2) AS INT) * 100000000
+ CAST(SUBSTRING(@v_siege_start_date,5,2) AS INT) * 1000000
+ CAST(SUBSTRING(@v_siege_start_date,7,2) AS INT) * 10000
+ CAST(SUBSTRING(@v_siege_start_date,9,2) AS INT) * 100
+ CAST(SUBSTRING(@v_siege_start_date,11,2) AS INT)

IF DATALENGTH(@v_siege_start_time) <> 4
BEGIN
SELECT @v_siege_start_time = 0x00000000
END

RETURN @v_siege_start_time
END


8 - Sunday
7 - Saturday
6 - Friday
5 - Thursday
4 - Wednesday
3 - Tuesday
2 - Monday

I followed all what you did but when i end the siege, dekaronserver will crash

[[DEV]Dekaron]

then probably you ****** up something show us what you did what you change.

like for me all works OK.

[yami1203]

Originally Posted by [DEV]Dekaron

then probably you ****** up something show us what you did what you change.

like for me all works OK.

Is it possible to reset the siege query that was registered in the db? Because I think the query that Farius used on this db is different from yours.

[[DEV]Dekaron]

Because my scripts are original. ppl make to much mess in some script
Yes you can.

[yami1203]

Originally Posted by [DEV]Dekaron

Because my scripts are original. ppl make to much mess in some script
Yes you can.

Just delete the getsiegetime something then requery???

[[DEV]Dekaron]

when you run your server do you get info about siege?

[yami1203]

Originally Posted by [DEV]Dekaron

when you run your server do you get info about siege?

What do you mean? Siege in this db was already set by Farius but only once every two weeks.

[[DEV]Dekaron]

Then all what you need is change 15 to 8

Once per two weeks at sunday
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

Every week at sunday
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

[yami1203]

Originally Posted by [DEV]Dekaron

Then all what you need is change 15 to 8

Once per two weeks at sunday
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 15-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

Every week at sunday
SELECT @v_siege_start_date = CONVERT(VARCHAR(10), DATEADD(d, 8-DATEPART(dw, @i_GetDate), @i_GetDate), 112) + '210000'

yep, already done that. Instead of showing the next siege date, the siege info says the next siege is "2014 9/7" then if i start then end the siege, dekaronserver would crash.

[[DEV]Dekaron]

did you try?

when you start your server do you getting info about siege (at the end of start server)

if you getting info at the end like NOT SIEGE ON CHANNEL that mean you don't have working SIEGE that's why your server crashing after using command siege stop now

[yami1203]

it says "[SIEGE INFO] WARTIME ALARM TIME[0]

[[DEV]Dekaron]

Originally Posted by yami1203

it says "[SIEGE INFO] WARTIME ALARM TIME[0]

all is fine with that. this only mean that siege is load and works



just login to your account, use command siege_start now, and wait 5~10 second and use command siege_end now