X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=d1da6a6af201db2f723bd52dc7a4b8fc0b7b03e2;hp=116fd821d0722256917bc46af2789922e82c3d28;hb=cca98f57dff720b174d21d071cee8303462485d7;hpb=f6ccb87413901e0352319385471134dd2d4ba966 diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php index 116fd821d0..d1da6a6af2 100644 --- a/inc/modules/member/what-beg2.php +++ b/inc/modules/member/what-beg2.php @@ -54,7 +54,7 @@ if (EXT_IS_ACTIVE("autopurge")) { } // Let's check if there are some points left we can "pay"... -$result = SQL_QUERY_ESC("SELECT userid, beg_points AS beg, last_online FROM "._MYSQL_PREFIX."_user_data +$result = SQL_QUERY_ESC("SELECT userid, beg_points AS beg, last_online FROM `{!MYSQL_PREFIX!}_user_data` WHERE beg_points > 0 AND status='CONFIRMED'".$LAST." ORDER BY beg_points DESC, last_online DESC, userid LIMIT %s", array($ONLINE, getConfig('beg_ranks')), __FILE__, __LINE__);