Page 1 of 1

Siege times & L2J

Posted: Wed Dec 21, 2011 3:38 pm
by 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?

Re: Siege times & L2J

Posted: Wed Dec 21, 2011 4:59 pm
by 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

Re: Siege times & L2J

Posted: Wed Dec 21, 2011 5:09 pm
by 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.

Re: Siege times & L2J

Posted: Wed Dec 21, 2011 6:51 pm
by 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

Re: Siege times & L2J

Posted: Wed Dec 21, 2011 7:27 pm
by 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.

Re: Siege times & L2J

Posted: Wed Dec 28, 2011 10:08 am
by Kriogen
JMD wrote: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.

Re: Siege times & L2J

Posted: Wed Dec 28, 2011 8:44 pm
by JMD
Kriogen wrote:
JMD wrote: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.

Re: Siege times & L2J

Posted: Sat Feb 11, 2012 12:37 pm
by 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

Re: Siege times & L2J

Posted: Sat Feb 18, 2012 4:55 pm
by JMD
blarke wrote: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.

Re: Siege times & L2J

Posted: Wed Apr 04, 2012 9:53 am
by shoko
can make Siege times every 7 day ?

Re: Siege times & L2J

Posted: Fri Apr 06, 2012 4:20 am
by JMD
shoko wrote:can make Siege times every 7 day ?
For that you'll have to disable 7signs.

Siege time change in database table calculation.

Posted: Sun Apr 29, 2012 6:28 pm
by 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.

Re: Siege time change in database table calculation.

Posted: Mon Apr 30, 2012 7:47 am
by JMD
Use this: http://w3w.aplus.pl/l2/siege.php?time

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