X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=1d34c43a0fe6aa33f67bc7bc6106850a9ba827a0;hp=6fc45776bb044155410f74a9cba442030b36d537;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hpb=157ee010917df5ca07e6d31b42f67417b2516d74 diff --git a/0.2.1/inc/modules/member/what-beg2.php b/0.2.1/inc/modules/member/what-beg2.php index 6fc45776bb..1d34c43a0f 100644 --- a/0.2.1/inc/modules/member/what-beg2.php +++ b/0.2.1/inc/modules/member/what-beg2.php @@ -1,109 +1,109 @@ -
"); - -// Autopurge installed? -$LAST = "%s"; $ONLINE = ""; -if (EXT_IS_ACTIVE("autopurge")) -{ - // Use last online timestamp to keep inactive members away from here - $LAST = " AND last_online >= %s"; - $ONLINE = bigintval(time() - $CONFIG['ap_in_since']); -} - -// 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 -WHERE beg_points > 0 AND status='CONFIRMED'".$LAST." -ORDER BY beg_points DESC, last_online DESC, userid LIMIT %s", - array($ONLINE, $CONFIG['beg_ranks']), __FILE__, __LINE__); - -// Reset temporary variable and check for users -$OUT = ""; -if (SQL_NUMROWS($result) > 0) -{ - // Load our winners... - $SW = 2; $cnt = 1; - while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) - { - // Prepare data for the template - $content = array( - 'sw' => $SW, - 'cnt' => $cnt, - 'uid' => bigintval($uid), - 'points' => TRANSLATE_COMMA($turbo), - 'last' => MAKE_DATETIME($last, "2"), - ); - - // Load row template - $OUT .= LOAD_TEMPLATE("member_list_beg_row", true, $content); - - // Count one up and switch colors - $cnt++;$SW = 3 - $SW; - } -} - else -{ - // No one is interested in our "active rallye" ! :-( - $OUT = LOAD_TEMPLATE("member_beg_404", true); -} - -// Free memory -SQL_FREERESULT($result); - -// Remeber row(s) for the template -define('__BEG_ROWS', $OUT); - -// Load final template -LOAD_TEMPLATE("member_list_beg"); - -// -?> +
"); + +// Autopurge installed? +$LAST = "%s"; $ONLINE = ""; +if (EXT_IS_ACTIVE("autopurge")) +{ + // Use last online timestamp to keep inactive members away from here + $LAST = " AND last_online >= %s"; + $ONLINE = bigintval(time() - $CONFIG['ap_in_since']); +} + +// 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 +WHERE beg_points > 0 AND status='CONFIRMED'".$LAST." +ORDER BY beg_points DESC, last_online DESC, userid LIMIT %s", + array($ONLINE, $CONFIG['beg_ranks']), __FILE__, __LINE__); + +// Reset temporary variable and check for users +$OUT = ""; +if (SQL_NUMROWS($result) > 0) +{ + // Load our winners... + $SW = 2; $cnt = 1; + while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) + { + // Prepare data for the template + $content = array( + 'sw' => $SW, + 'cnt' => $cnt, + 'uid' => bigintval($uid), + 'points' => TRANSLATE_COMMA($turbo), + 'last' => MAKE_DATETIME($last, "2"), + ); + + // Load row template + $OUT .= LOAD_TEMPLATE("member_list_beg_row", true, $content); + + // Count one up and switch colors + $cnt++;$SW = 3 - $SW; + } +} + else +{ + // No one is interested in our "active rallye" ! :-( + $OUT = LOAD_TEMPLATE("member_beg_404", true); +} + +// Free memory +SQL_FREERESULT($result); + +// Remeber row(s) for the template +define('__BEG_ROWS', $OUT); + +// Load final template +LOAD_TEMPLATE("member_list_beg"); + +// +?>