Birthday present mail every day..

This is not a Support area! Discuss about the Server here. Non-Server related discussion goes in Off-Topic Discussion.
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Sinnocent
Posts: 37
Joined: Tue Sep 08, 2015 8:42 am

Birthday present mail every day..

Post by Sinnocent »

Since January 1st, all characters are receiving a "Happy Birthday!" present in mail from Alegria every day, any solution to fix this?
Sinnocent
Posts: 37
Joined: Tue Sep 08, 2015 8:42 am

Re: Birthday present mail every day..

Post by Sinnocent »

Help please, how can this be happening? I have made no changes in the core or anything related to birthday, it just started happening on the new year 2016. Everyday players are mail a birthday reward.
zhort
Posts: 106
Joined: Thu Oct 06, 2011 11:08 pm

Re: Birthday present mail every day..

Post by zhort »

Sinnocent wrote:Help please, how can this be happening? I have made no changes in the core or anything related to birthday, it just started happening on the new year 2016. Everyday players are mail a birthday reward.

check it

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());
Post Reply