X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-bonus.php;h=2b133c5ebc15161790cefdd35a96bbb4d1e710d4;hp=13f45b08d5cb6492920077c0fea1bf13f4f69656;hb=cca98f57dff720b174d21d071cee8303462485d7;hpb=f6ccb87413901e0352319385471134dd2d4ba966 diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index 13f45b08d5..2b133c5ebc 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-bonus.php @@ -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",