$YEAR = date('Y', time());
// Shall I include only active members?
-$ADD = "%s"; $VALUE = "";
+$add = "%s"; $VALUE = "";
if ((getConfig('birthday_active')) && (EXT_IS_ACTIVE("autopurge")) && (getConfig('autopurge_inactive') == "Y") && (getConfig('ap_inactive_since') > 0)) {
- $ADD = " AND last_online >= (UNIX_TIMESTAP() - %s)";
+ $add = " AND last_online >= (UNIX_TIMESTAP() - %s)";
$VALUE = getConfig('ap_inactive_since');
}
// Only confirmed members shall receive birthday mails...
$result_birthday = SQL_QUERY_ESC("SELECT userid, email, birth_year
FROM `{!_MYSQL_PREFIX!}_user_data`
-WHERE `status`='CONFIRMED' AND birth_day=%s AND birth_month=%s AND birthday_sent < (UNIX_TIMESTAMP() - ".(getConfig('one_day') * 364).")".$ADD."
+WHERE `status`='CONFIRMED' AND birth_day=%s AND birth_month=%s AND birthday_sent < (UNIX_TIMESTAMP() - ".(getConfig('one_day') * 364).")".$add."
ORDER BY userid",
array($DAY, $MONTH, $VALUE), __FILE__, __LINE__);