[Help] L2j Gracia Final siege

[JustLikeMe]

I came up to a problem once again. How can i change siege hours? I used this:

 

-- ---------------------------
-- Table structure for castle
-- ---------------------------
CREATE TABLE IF NOT EXISTS castle (
  id INT NOT NULL default 0,
  name varchar(25) NOT NULL,
  taxPercent INT NOT NULL default 15,
  treasury INT NOT NULL default 0,
  siegeDate DECIMAL(20,0) NOT NULL default 0,
  siegeDayOfWeek INT NOT NULL default 7,
  siegeHourOfDay INT NOT NULL default 20,
  PRIMARY KEY  (name),
  KEY id (id)
);

INSERT IGNORE INTO `castle` VALUES (1, 'Gludio', 0, 0, 0, 6, 20),
(2, 'Dion', 0, 0, 0, 7, 20),
(3, 'Giran', 0, 0, 0, 6, 20),
(4, 'Oren', 0, 0, 0, 7, 20),
(5, 'Aden', 0, 0, 0, 6, 20),
(6, 'Innadril', 0, 0, 0, 7, 20),
(7, 'Goddard', 0, 0, 0, 6, 20);

 

So the time is automated and i dont need to change the unix time every week. This si for Saturday and Sunday every second week. I think it doesnt work, any idea?

[Commodus]

Here you are : http://w3w.aplus.pl/l2/siege.php?time/

 

Fill the data,hour,castle and execute the sql file that appears.

[JustLikeMe]

But this is for every weekend isnt it??

[Commodus]

But this is for every weekend isnt it??

 

You have to update it every week.

[JustLikeMe]

hmmm this is the only way? i mean this is a little painfull :D Anyway thanks at least i can edit the hours :P

[Commodus]

hmmm this is the only way? i mean this is a little painfull :D

 

No , it's not.It's the best way to change your siege times.

[JustLikeMe]

yeah, i was just looking for an automated system but this is not bad either.

[Commodus]

yeah, i was just looking for an automated system but this is not bad either.

 

Of course , it's not.Anyway use this method , it's just 1 min to update your sieges ^^

 

Locked.