Alguien sabe como evitar el envio masivo de mail box a los personajes durante este evento?
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()