X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Freset%2Freset_birthday.php;h=e2a95fd4710ba79c525a817945410cca9486676c;hb=f2aeaab0cd313b2eeb151642455ed558f6b186dc;hp=9836603297d60c0ad571a153c4b1f9ed5798319c;hpb=b1cf96c4a5a63a1d334119a0681e5fbf68edf527;p=mailer.git diff --git a/inc/reset/reset_birthday.php b/inc/reset/reset_birthday.php index 9836603297..e2a95fd471 100644 --- a/inc/reset/reset_birthday.php +++ b/inc/reset/reset_birthday.php @@ -1,7 +1,7 @@ "); - // Get current day (01 to 31), month (01 to 12) and year (4-digits year) $day = date('d', time()); $month = date('m', time()); $year = date('Y', time()); // Shall I include only active members? -$add = "%s"; $value = ''; +$add = '%s'; $value = ''; if ((getConfig('birthday_active')) && (isExtensionActive('autopurge')) && (getConfig('autopurge_inactive') == 'Y') && (getConfig('ap_inactive_since') > 0)) { - $add = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)"; - $value = getConfig('ap_inactive_since'); + $add = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})"; } // END - if // Only confirmed members shall receive birthday mails... @@ -67,7 +67,7 @@ WHERE `status`='CONFIRMED' AND `birth_day`=%s AND `birth_month`=%s AND - `birthday_sent` < (UNIX_TIMESTAMP() - ".(getConfig('ONE_DAY') * 364).") + `birthday_sent` < (UNIX_TIMESTAMP() - ({?ONE_DAY?} * 364)) ".$add." ORDER BY `userid` ASC", @@ -86,7 +86,6 @@ if (SQL_NUMROWS($result_birthday) > 0) { if (getConfig('birthday_points') > 0) { // Add more entries to the array $content['age'] = $age; - $content['points'] = translateComma(getConfig('birthday_points')); $content['check'] = ''; // @TODO 4 is hard-coded here, should we move it out in config? @@ -117,8 +116,8 @@ if (SQL_NUMROWS($result_birthday) > 0) { } // END - while // Free memory - SQL_FREERESULT($result); -} + SQL_FREERESULT($result_birthday); +} // END - if // [EOF] ?>