More improved SQL queries

[mailer.git] / inc / modules / member / what-bonus.php

diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php
index 3b01a6f21027d39a9d6dd016b82c64afddfc7a03..e405e625a30ed40721b2b7dc7d548ff6299a4433 100644 (file)
--- a/inc/modules/member/what-bonus.php
+++ b/inc/modules/member/what-bonus.php
@@ -72,7 +72,7 @@ if (EXT_IS_ACTIVE("autopurge")) {
 
 // Let's check if there are some points left we can "pay"...
 $result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS points, last_online FROM `{!_MYSQL_PREFIX!}_user_data`
 
 // Let's check if there are some points left we can "pay"...
 $result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS points, last_online FROM `{!_MYSQL_PREFIX!}_user_data`

-WHERE ".$USE." > 0 AND status='CONFIRMED'".$LAST."
+WHERE ".$USE." > 0 AND `status`='CONFIRMED'".$LAST."

 ORDER BY points DESC, last_online DESC, userid
 LIMIT %s",
        array($ONLINE, getConfig('bonus_ranks')), __FILE__, __LINE__);
 ORDER BY points DESC, last_online DESC, userid
 LIMIT %s",
        array($ONLINE, getConfig('bonus_ranks')), __FILE__, __LINE__);