]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/member/what-bonus.php
All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...
[mailer.git] / inc / modules / member / what-bonus.php
index 13f45b08d5cb6492920077c0fea1bf13f4f69656..2b133c5ebc15161790cefdd35a96bbb4d1e710d4 100644 (file)
@@ -71,7 +71,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
+$result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS points, last_online FROM `{!MYSQL_PREFIX!}_user_data`
 WHERE ".$USE." > 0 AND status='CONFIRMED'".$LAST."
 ORDER BY points DESC, last_online DESC, userid
 LIMIT %s",