Evento Aniversario envia mail box duplicados

Iniciado por Jacop, Oct 23, 2025, 03:28 PM

Tema anterior - Siguiente tema

Jacop

Alguien sabe como evitar el envio masivo de mail box a los personajes durante este evento?

Swarlog

No tienes permiso para ver los enlaces. Para poder verlos Registrate o Conectate.Alguien sabe como evitar el envio masivo de mail box a los personajes durante este evento?

Fix para reparar el bug del evento Birthday Gift. y evitar asi el envio masivo de mail box a los personajes.

CitarCORE:

Editar: src/main/java/com/l2jserver/gameserver/taskmanager/tasks/TaskBirthday.java

  {
 	private static final String NAME = "birthday";
 	/** Get all players that have had a birthday since last check. */
-	private static final String SELECT_PENDING_BIRTHDAY_GIFTS = "SELECT charId, char_name, createDate, (YEAR(NOW()) - YEAR(createDate)) AS age " //
-		+ "FROM characters WHERE (YEAR(NOW()) - YEAR(createDate) > 0) AND (DATE_FORMAT(createDate, '%m-%d') > DATE_FORMAT(FROM_UNIXTIME(?), '%m-%d'))";
+	private static final String SELECT_PENDING_BIRTHDAY_GIFTS = "SELECT charId, char_name, createDate, (YEAR(NOW()) - YEAR(createDate)) AS age FROM characters WHERE (YEAR(NOW()) - YEAR(createDate) > 0) AND ((DATE_ADD(createDate, INTERVAL (YEAR(NOW()) - YEAR(createDate)) YEAR)) BETWEEN FROM_UNIXTIME(?) AND NOW())";
 	
 	@Override
 	public String getName()