X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-bonus.php;h=ee31c8b790e0037ba8d25a17b866198ea346b846;hb=96d8f54d3fee1d51c38dd6b79c28215f7f5c83ec;hp=b505ddd0abe13e90cc0b38a1c492ed98577e5bfc;hpb=b75d45801998214670b2750544b3f20b4ddf87b3;p=mailer.git diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index b505ddd0ab..ee31c8b790 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-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 * @@ -37,7 +37,7 @@ // Some security stuff... if (!defined('__SECURITY')) { - die(); + exit(); } elseif (!isMember()) { redirectToIndexMemberOnlyModule(); } @@ -52,9 +52,9 @@ if ((!isExtensionActive('bonus')) && (!isAdmin())) { // Add more bonus points here $add = runFilterChain('add_bonus_points_user_columns', ''); -$USE = '`turbo_bunus`'; +$pointsColumns = '`turbo_bunus`'; if (!empty($add)) { - $USE = '(0' . $add . ')'; + $pointsColumns = '(0' . $add . ')'; } // END - if // Init variables @@ -69,17 +69,20 @@ if ((isExtensionActive('autopurge')) && ((getApInactiveSince() > 0))) { // Let's check if there are some points left we can 'pay'... $result = SQL_QUERY_ESC("SELECT - `userid`, ".$USE." AS `points`,`last_online` + `userid`, + ".$pointsColumns." AS `points`, + `last_online` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE - " . $USE . " > 0 AND + " . $pointsColumns . " > 0 AND `status`='CONFIRMED' + " . runFilterChain('user_exclusion_sql', ' ') . " " . $lastOnline . " ORDER BY `points` DESC, - last_online DESC, - userid ASC + `last_online` DESC, + `userid` ASC LIMIT {?bonus_ranks?}", array( $ONLINE