X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fdaily%2Fdaily_birthday.php;h=4ff04e06348dc564d53616bf0d392a60a37bcaa1;hb=64eecfb13d8618ddcf0e9d53920a21b0401b3971;hp=42273b6f314564adfb3c0d85e8244a3b8f54181e;hpb=ea6cf3578750b2697b45cab74725396962b56ceb;p=mailer.git diff --git a/inc/daily/daily_birthday.php b/inc/daily/daily_birthday.php index 42273b6f31..4ff04e0634 100644 --- a/inc/daily/daily_birthday.php +++ b/inc/daily/daily_birthday.php @@ -17,7 +17,7 @@ * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -59,13 +59,13 @@ $year = getYear(); $lastOnline = ''; // Shall I include only active members? -if ((getConfig('birthday_active') == 'Y') && (isExtensionActive('autopurge')) && (isBegActiveEnabled()) && ((getApInactiveSince() > 0))) { - $add = ' AND (UNIX_TIMESTAMP() - `last_online`) >= {?ap_inactive_since?}'; +if ((getConfig('birthday_active') == 'Y') && (isExtensionActive('autopurge')) && ((getApInactiveSince() > 0))) { + $add = ' AND (UNIX_TIMESTAMP() - `last_online`) < {?ap_inactive_since?}'; } // END - if // Only confirmed members shall receive birthday mails... $result_birthday = SQL_QUERY_ESC("SELECT - `userid`, `email`, `birth_year` + `userid`,`email`,`birth_year` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE @@ -99,7 +99,7 @@ if (!SQL_HASZERONUMS($result_birthday)) { } // END - for // Insert row into database - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_birthday` (`userid`, `points`, `chk_value`) VALUES (%s,{?birthday_points?},'%s' )", + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_user_birthday` (`userid`,`points`,`chk_value`) VALUES (%s,{?birthday_points?},'%s' )", array( bigintval($content['userid']), $content['check']