Tutorial| Set easy siege time :)

[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.

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'

*** Bless,
lifs2000

[yami1203]

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.

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'

*** Bless,
lifs2000

It seems the binary data can't be replaced

[[DEV]Dekaron]

[lifs2000]

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.