Birthday present mail every day..
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 37
- Joined: Tue Sep 08, 2015 8:42 am
Birthday present mail every day..
Since January 1st, all characters are receiving a "Happy Birthday!" present in mail from Alegria every day, any solution to fix this?
-
- Posts: 37
- Joined: Tue Sep 08, 2015 8:42 am
Re: Birthday present mail every day..
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.
-
- Posts: 106
- Joined: Thu Oct 06, 2011 11:08 pm
Re: Birthday present mail every day..
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());