From a68c1a2da75572d9603f16c9ce9232ee10ff2f93 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 4 Oct 2008 11:23:55 +0000 Subject: [PATCH] Fix for monthly bonus --- inc/databases.php | 2 +- inc/monthly/monthly_bonus.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/inc/databases.php b/inc/databases.php index 3077e9822b..bb52ea6502 100644 --- a/inc/databases.php +++ b/inc/databases.php @@ -113,7 +113,7 @@ define('USAGE_BASE', "usage"); define('SERVER_URL', "http://www.mxchange.org"); // This current patch level -define('CURR_SVN_REVISION', "438"); +define('CURR_SVN_REVISION', "439"); // Take a prime number which is long (if you know a longer one please try it out!) define('_PRIME', 591623); diff --git a/inc/monthly/monthly_bonus.php b/inc/monthly/monthly_bonus.php index 42cfdeb3e4..f6c8f30c39 100644 --- a/inc/monthly/monthly_bonus.php +++ b/inc/monthly/monthly_bonus.php @@ -79,7 +79,7 @@ if (($curr != $_CONFIG['last_month']) && ($_CONFIG['bonus_ranks'] > 0) && ($CSS // SQL string to check for accounts $result_main = SQL_QUERY_ESC("SELECT userid, email, (turbo_bonus + login_bonus + bonus_order + bonus_stats + bonus_ref) AS active_bonus FROM "._MYSQL_PREFIX."_user_data -".$whereStatement1." %s".$ADD." +".$whereStatement1."".$ADD." ORDER BY active_bonus DESC, userid LIMIT %s", array($whereStatement2), __FILE__, __LINE__); -- 2.30.2