0))) { // Use last online timestamp to keep inactive members away from here $lastOnline = ' AND (UNIX_TIMESTAMP() - `last_online`) < {?ap_inactive_since?}'; } // END - if // Check if at least one is in the active rallye $result = sqlQuery("SELECT `userid`, `email`, `beg_points`, `last_online` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' AND `beg_points` > 0 " . $lastOnline . " " . runFilterChain('user_exclusion_sql', ' ') . " ORDER BY `beg_points` DESC, `last_online` DESC, `userid` ASC", __FILE__, __LINE__); if (!ifSqlHasZeroNumRows($result)) { // List users $OUT = ''; $count = 1; $total = '0'; while ($content = sqlFetchArray($result)) { // Init variables $WIN1 = ''; $WIN2 = ''; // Maybe he can win his active beg? if ($count <= getBegRanks()) { // Mark him $WIN1 = ''; $WIN2 = ''; } // END - if // Prepare content $row = array( 'userid' => $content['userid'], 'email' => generateEmailLink($content['email'], 'user_data'), 'last_online' => generateDateTime($content['last_online'], '2'), 'win1' => $WIN1, 'win2' => $WIN2, 'count' => $count, ); // Load template and add it $OUT .= loadTemplate('admin_list_beg_rows', TRUE, $row); $count++; $total += $content['beg_points']; } // END - while $content['rows'] = $OUT; $content['total_points'] = $total; // Check if we need to display form or not with manuel withdraw if (getLastMonthly() == getMonth()) { // Load form $content['withdraw_form'] = loadTemplate('admin_list_beg_form', TRUE); } else { // Display message "no manual withdraw possible" $content['withdraw_form'] = returnMessage('{--ADMIN_BEG_ALREADY_WITHDRAW--}'); } // Prepare constant for timemark if (isExtensionActive('autopurge')) { $content['autopurge_timeout'] = generateDateTime(time() - getApInactiveSince(), 2); } else { $content['autopurge_timeout'] = returnMessage('{%pipe,generateExtensionInactiveNotInstalledMessage=autopurge%}'); } // Load final template loadTemplate('admin_list_beg', FALSE, $content); } else { // No one has joined the begging rallye... displayMessage('{--ADMIN_BEG_NO_RALLYE--}'); } } else { // Rallye deactivated displayMessage('{--ADMIN_BEG_RALLYE_DEACTIVATED--}'); } // [EOF] ?>