SiegeDate (3 days.)

[Bleadd]

hello,

 

If i change SQL query, the siege date will be every x days?

 

public void saveSiegeDate()
{
	if (_scheduledStartSiegeTask != null)
	{
		_scheduledStartSiegeTask.cancel(true);
		_scheduledStartSiegeTask = ThreadPoolManager.getInstance().scheduleGeneral(new Siege.ScheduleStartSiegeTask(getCastle()), 1000);
	}
	Connection con = null;
	PreparedStatement statement = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
		statement = con.prepareStatement("UPDATE castle SET siegeDate = ?, regTimeEnd = ?, regTimeOver = ?  WHERE id = ?");
		statement.setLong(1, getSiegeDate().getTimeInMillis());
		statement.setLong(2, getTimeRegistrationOverDate().getTimeInMillis());
		statement.setString(3, String.valueOf(getIsTimeRegistrationOver()));
		statement.setInt(4, getCastle().getCastleId());
		statement.execute();
	}
	catch (Exception e)
	{
		_log.log(Level.WARNING, "Exception: saveSiegeDate(): " + e.getMessage(), e);
	}
	finally
	{
		L2DatabaseFactory.close(con);
	}
}

 

If i replace

statement.setLong(1, getSiegeDate().getTimeInMillis());

 

by

 

statement.setLong(1, 259200000);

259200000 = 3 days.

 

The sieges will be every 3 days?

 

L2j H5.

 

Cordially,

Bleadd

[Tryskell]

Nope, you have to change more than that, cause siege date is corrected at server loading/date save.

 

There's a method which change date of castle to be only for saturday or sunday, correctSiegeDateTime().

 

Added to that your system is wrong. You must add 3 days to previous siege time. Not a static date/hour system/whatever.

[Bleadd]

I have an idea.. It's a crap and sh*t trick but if i substract 14 days and add 3 days, will it work?

 

Edit : After a moment of thinking : it's the same problem..

[Tryskell]

You have to edit correctSiegeDateTime() to fit with your needs.

 

Drop the saturday/Sunday stuff, replace the 14 days by 3 days, and so on.