X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmonthly%2Fmonthly_beg.php;h=516e3a7ec6313f468c0ed9a3a4817cbf22511286;hb=d3ea83baa3f2607db46c26f7d8527c84b994f116;hp=dfc0eb786365a794ecd9ff596b8c4abdf9e05c7a;hpb=76740e48546bb3fdb9fca65d8d205765f2bd4d68;p=mailer.git diff --git a/inc/monthly/monthly_beg.php b/inc/monthly/monthly_beg.php index dfc0eb7863..516e3a7ec6 100644 --- a/inc/monthly/monthly_beg.php +++ b/inc/monthly/monthly_beg.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 * @@ -57,7 +57,7 @@ if ((getBegRanks() > 0) && (!isCssOutputMode())) { // Shall we exclude webmaster's own userid? if ((!isBegIncludeOwnEnabled()) && (isValidUserId(getBegUserid()))) { // Exclude it - $whereStatement = " AND `userid` != {?beg_userid?}"; + $whereStatement .= ' AND `userid` != {?beg_userid?}'; } // END - if // Let's check if there are some points left we can pay... @@ -68,11 +68,13 @@ if ((getBegRanks() > 0) && (!isCssOutputMode())) { // SQL string to check for accounts $result_main = SQL_QUERY("SELECT - `userid`, `email`, `gender`, `surname`, `family`, `beg_points` + `userid`, + `beg_points` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - `status`='CONFIRMED'" . $whereStatement . " AND + `status`='CONFIRMED'" . $whereStatement . " + " . runFilterChain('user_exclusion_sql', ' ') . " AND `beg_points` > 0 ORDER BY `beg_points` DESC, @@ -83,7 +85,8 @@ LIMIT {?beg_ranks?}", __FILE__, __LINE__); // Load our winners... while ($content = SQL_FETCHARRAY($result_main)) { // Add points to user's account directly - addPointsThroughReferalSystem('monthly_beg', $content['userid'], $content['beg_points']); + initReferralSystem(); + addPointsThroughReferralSystem('monthly_beg', $content['userid'], $content['beg_points']); // Load email template and email it away $message = loadEmailTemplate('member_beg', $content, bigintval($content['userid']));