Siege time change in database table calculation.

[JMD]

As i understand l2jservers siege times are similar of those on official NA servers. I am wondering why this cant be adjustable on configs since official also has european timezone servers. Wouldnt it be a retail like feature to have a config about choosing wether you want sieges to follow NA timezones or EU timezones?

[gmakhs]

l2jserver as i know use root machine timezone so if your computer is setted to gmt+2 you server wil be gmt +2 too

[JMD]

My computer is on GMT+2 but when i make a test server on my pc the siege time is still at 1:00 am.

[gmakhs]

so thats not a timezone problem you have problem with time . you can adjust timezone from database or gm panel

but if im right in h5 castle owners can choose siege time tooo

[JMD]

you mean change the siege date on db? That doesnt work because if you set it and the server restarts the time reverts to its previous setting.

[Kriogen]

As i understand l2jservers siege times are similar of those on official NA servers. I am wondering why this cant be adjustable on configs since official also has european timezone servers. Wouldnt it be a retail like feature to have a config about choosing wether you want sieges to follow NA timezones or EU timezones?

You can always change the siege time. All you need is a little knowlege about unix time and server down.

1. Shutdown the server, any changes to raid respawn or anything time related in db must be done with server down, otherwise if you change and restart server the settings you made are useless.
2. go here: http://www.onlineconversion.com/unix_time.htm
3. Insert the time you want to change, day, hour, year, minutes...etc and press generate, it will generate for you a unix time.

[JMD]

As i understand l2jservers siege times are similar of those on official NA servers. I am wondering why this cant be adjustable on configs since official also has european timezone servers. Wouldnt it be a retail like feature to have a config about choosing wether you want sieges to follow NA timezones or EU timezones?

You can always change the siege time. All you need is a little knowlege about unix time and server down.

1. Shutdown the server, any changes to raid respawn or anything time related in db must be done with server down, otherwise if you change and restart server the settings you made are useless.
2. go here: http://www.onlineconversion.com/unix_time.htm
3. Insert the time you want to change, day, hour, year, minutes...etc and press generate, it will generate for you a unix time.

Thanks i've been asking about this for a long time and nodody ever gave me an answer like this one. It worked.

[blarke]

Isn't this only one-time modification? My players are complaining about the late-at-night siege dates (for NPC owned castles, respectively). If I change the siege dates to like, 5PM for the castles, 2 weeks later I still will have to change it from midnight to 5PM if the castle was not taken, isn't that right?

Cheers,
blarke

[JMD]

Isn't this only one-time modification? My players are complaining about the late-at-night siege dates (for NPC owned castles, respectively). If I change the siege dates to like, 5PM for the castles, 2 weeks later I still will have to change it from midnight to 5PM if the castle was not taken, isn't that right?

Cheers,
blarke

Shutdown your server and run this on your database:

UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '1';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '2';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '3';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '4';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '5';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '6';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '7';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '8';
UPDATE `castle` SET siegeDate = '1329678000000' WHERE id = '9';

It sets all sieges for tomorrow 21:00 GMT+2.

However if you visit this site: http://w3w.aplus.pl/l2/siege.php?time You can put your own dates and hours.

[shoko]

can make Siege times every 7 day ?

[JMD]

can make Siege times every 7 day ?

For that you'll have to disable 7signs.

[Chuliganas]

Okay, so I want to change first siege time to be 8 hours earlier than default one says. Because for some reason first sieges are set to start at midnight...
So I went to database, and found castle tab, and there I found times -
Siege start - 1336258800000
Siege registration - 1335135600001
So since I know difference between those has to be 24 hours, I calculated that substracting those two gave me value of 13000 per every second. So I made ajustments for 8 hours, restarted server, and... new siege times was set 24 hours and 2 minutes earlier! so that messed up all my calculations....

Anyone can explain how those are done?

Because I've tried change siege and TW dates and times using in-game admin panel, but after restarting server those changes disappear.

[JMD]

Use this: http://w3w.aplus.pl/l2/siege.php?time

Server must be offline when applying these queries otherwise they wont work.