X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=inline;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=81237f37b7cc35ec1dbc2a1e13444c54bb772fa8;hb=5bdeaf8b452206598b6c6cd4f941145b11a0eccc;hp=d1da6a6af201db2f723bd52dc7a4b8fc0b7b03e2;hpb=cca98f57dff720b174d21d071cee8303462485d7;p=mailer.git diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php index d1da6a6af2..81237f37b7 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__); @@ -64,7 +64,7 @@ $OUT = ""; if (SQL_NUMROWS($result) > 0) { // Load our winners... $SW = 2; $cnt = 1; - while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) { + while (list($uid, $turbo, $last) = SQL_FETCHROW($result)) { // Prepare data for the template $content = array( 'sw' => $SW,