Page 1 of 1
Birthday present mail every day..
Posted: Fri Jan 08, 2016 10:30 pm
by Sinnocent
Since January 1st, all characters are receiving a "Happy Birthday!" present in mail from Alegria every day, any solution to fix this?
Re: Birthday present mail every day..
Posted: Sun Jan 10, 2016 8:22 pm
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.
Re: Birthday present mail every day..
Posted: Sun Jan 10, 2016 9:50 pm
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());