X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-beg2.php;h=25b5bdce5577eb930160866f9f3bf756ceca9bb0;hp=78573eef5cecaebbd8f61a1aa1828446019d30c2;hb=391c98ab7233ff3e640d8b9fad8df92ce45e9b31;hpb=4001187f22197f55e5a1f211fc8defcc180f7c32 diff --git a/inc/modules/member/what-beg2.php b/inc/modules/member/what-beg2.php index 78573eef5c..25b5bdce55 100644 --- a/inc/modules/member/what-beg2.php +++ b/inc/modules/member/what-beg2.php @@ -1,7 +1,7 @@ = (UNIX_TIMESTAMP() - %s)"; - $ONLINE = getConfig('ap_inactive_since'); -} + $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})"; +} // END - if -// 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'".$lastOnline." -ORDER BY beg_points DESC, last_online DESC, userid LIMIT %s", - array($ONLINE, getConfig('beg_ranks')), __FILE__, __LINE__); +// Let's check if there are some points left we can pay... +$result = SQL_QUERY_ESC("SELECT + `userid`, `beg_points`, `last_online` +FROM + `{?_MYSQL_PREFIX?}_user_data` +WHERE + `beg_points` > 0 AND + `status`='CONFIRMED' + " . $lastOnline . " +ORDER BY + `beg_points` DESC, + `last_online` DESC, + `userid` ASC +LIMIT {?beg_ranks?}", + array( + $ONLINE + ), __FILE__, __LINE__); // Reset temporary variable and check for users -$OUT = ""; -if (SQL_NUMROWS($result) > 0) { +$OUT = ''; +if (!SQL_HASZERONUMS($result)) { // Load our winners... - $SW = 2; $cnt = 1; + $count = 1; while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the template + // @TODO points->beg_points $content = array( - 'sw' => $SW, - 'cnt' => $cnt, - 'uid' => bigintval($content['userid']), - 'points' => TRANSLATE_COMMA($content['beg']), - 'last' => MAKE_DATETIME($content['last_online'], "2"), + 'cnt' => $count, + 'userid' => $content['userid'], + 'points' => $content['beg_points'], + 'last_online' => generateDateTime($content['last_online'], 2), ); // Load row template - $OUT .= LOAD_TEMPLATE("member_list_beg_row", true, $content); + $OUT .= loadTemplate('member_list_beg_row', true, $content); - // Count one up and switch colors - $cnt++; $SW = 3 - $SW; - } + // Count one up + $count++; + } // END - while } else { // No one is interested in our "active rallye" ! :-( - $OUT = LOAD_TEMPLATE("member_beg_404", true); + $OUT = loadTemplate('member_beg_404', true); } +// Prepare content +$content['rows'] = $OUT; + // Free memory SQL_FREERESULT($result); -// Remeber row(s) for the template -define('__BEG_ROWS', $OUT); - // Load final template -LOAD_TEMPLATE("member_list_beg"); +loadTemplate('member_list_beg', false, $content); -// +// [EOF] ?>