X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_bonus.php;h=68f0434bcf1447b834521d80dac0689ee7951d0f;hb=e937b6540b932d537f72e827de76dd5be4aefe48;hp=f41b0e4e9af7bced6f1c837f9c8a014b55d1cb81;hpb=7ed35044deb45bcf59d2432c696129a1651b60cb;p=mailer.git diff --git a/inc/monthly/monthly_bonus.php b/inc/monthly/monthly_bonus.php index f41b0e4e9a..68f0434bcf 100644 --- a/inc/monthly/monthly_bonus.php +++ b/inc/monthly/monthly_bonus.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2012 by Mailer Developer Team * + * 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 * @@ -51,7 +51,7 @@ if (!defined('__SECURITY')) { if ((getBonusRanks() > 0) && (!isCssOutputMode())) { // Extension 'autopurge' is inactive or purging of inactive accounts is deactivated - $whereStatement = "WHERE `status`='CONFIRMED'"; + $whereStatement = runFilterChain('user_exclusion_sql', "WHERE `status`='CONFIRMED'"); // Shall I keep inactive members away from here? (mostly wanted in an "active-rallye" ...) if ((isExtensionActive('autopurge')) && ((getApInactiveSince() > 0))) { @@ -69,7 +69,8 @@ if ((getBonusRanks() > 0) && (!isCssOutputMode())) { // Run SQL string to check for accounts $result_main = SQL_QUERY('SELECT - `userid`,`email`,`gender`,`surname`,`family`, (0' . $add . ') AS `points` + `userid`, + (0' . $add . ') AS `points` FROM `{?_MYSQL_PREFIX?}_user_data` ' . $whereStatement . ' @@ -85,8 +86,8 @@ LIMIT {?bonus_ranks?}', __FILE__, __LINE__); // Make sure zero points are not mailed if ($content['points'] > 0) { // Add points to user's account directly - initReferalSystem(); - addPointsThroughReferalSystem('monthly_bonus', $content['userid'], $content['points']); + initReferralSystem(); + addPointsThroughReferralSystem('monthly_bonus', $content['userid'], $content['points']); // Load email template and email it away $message = loadEmailTemplate('member_bonus', $content, bigintval($content['userid']));