Tutorial| Set easy siege time :)

11/12/2020 16:58 lifs2000#1

Hello everyone!
I've seen some posts here about siege times and I figured out the best way I been using for years, would love to share it with you if you did not know.

Code:

SELECT CAST(2006281400 AS varbinary); 
-- year month day time  - 2006281400 - - 2020 06 28 14 00 ( just set up the date as you want)
After you get the result of doing the cast you will have the binary information.
0x77956CB8
Then you just update the siege_info table and you can set up siege any time you want!
update character..siege_info set DWSTARTTIME=(0x77956CB8)  where siege_tag='y'

God Bless,
lifs2000

11/13/2020 14:55 yami1203#2

Quote:
Originally Posted by lifs2000
Hello everyone!
I've seen some posts here about siege times and I figured out the best way I been using for years, would love to share it with you if you did not know.
Code:
SELECT CAST(2006281400 AS varbinary); 
-- year month day time  - 2006281400 - - 2020 06 28 14 00 ( just set up the date as you want)
After you get the result of doing the cast you will have the binary information.
0x77956CB8
Then you just update the siege_info table and you can set up siege any time you want!
update character..siege_info set DWSTARTTIME=(0x77956CB8)  where siege_tag='y'
God Bless,
lifs2000

It seems the binary data can't be replaced

11/13/2020 15:22 [DEV]Dekaron#3

11/13/2020 16:38 lifs2000#4

Quote:

Originally Posted by yami1203

It seems the binary data can't be replaced

You have to run the SQL Query.

You can not enter binary information manually like that.