= (UNIX_TIMESTAMP() - %s)";
$ONLINE = getConfig('ap_inactive_since');
} // END - if
// Check if at least one is in the active rallye
$result = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, beg_points, last_online
FROM `{!_MYSQL_PREFIX!}_user_data`
WHERE `status`='CONFIRMED' AND beg_points > 0".$lastOnline."
ORDER BY beg_points DESC, last_online DESC, userid",
array($ONLINE), __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// List users
$OUT = "";$SW = 2; $cnt = 1; $total = 0;
while ($content = SQL_FETCHARRAY($result)) {
// Init variables
$WIN1 = ""; $WIN2 = "";
if ($cnt <= getConfig('beg_ranks')) {
// Maybe he can win his active beg?
$WIN1 = "";
$WIN2 = "";
} // END - if
// Prepare content
// @TODO Rewrite templates so s/fname will be replaced by surname/family
// @TODO to shorten this block. Please also do so with uid->userid
$content = array(
'uid' => $content['userid'],
'email' => CREATE_EMAIL_LINK($content['email'], "user_data"),
'gender' => TRANSLATE_GENDER($content['gender']),
'sname' => $content['surname'],
'fname' => $content['family'],
'turbo' => TRANSLATE_COMMA($content['beg_points']),
'last' => MAKE_DATETIME($content['last_online'], "2"),
'sw' => $SW,
'win1' => $WIN1,
'win2' => $WIN2,
'cnt' => $cnt,
);
// Load template and add it
$OUT .= LOAD_TEMPLATE("admin_list_beg_rows", true, $content);
$SW = 3 - $SW; $cnt++; $total += $content['beg_points'];
}
define('__BEG_ROWS', $OUT);
define('__TOTAL', TRANSLATE_COMMA($total));
// Check if we need to display form or not with manuel withdraw
if (getConfig('last_month') == date("m", time())) {
// Load form
define('__BEG_WITHDRAW_FORM', LOAD_TEMPLATE("admin_list_beg_form", true));
} else {
// Display message "no manual withdraw possible"
define('__BEG_WITHDRAW_FORM', "{--ADMIN_BEG_ALREADY_WITHDRAW--}
");
}
// Prepare constant for timemark
if (EXT_IS_ACTIVE("autopurge")) {
define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - getConfig('ap_inactive_since'), "2"));
} else {
define('__AUTOPURGE_TIMEOUT', sprintf(getMessage('EXTENSION_PROBLEM_NOT_INSTALLED'), "autopurge"));
}
// Load final template
LOAD_TEMPLATE("admin_list_beg");
} else {
// No one has joined the begging rallye...
LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_BEG_NO_RALLYE'));
}
} else {
// Rallye deactivated
LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_BEG_RALLYE_DEACTIVATED'));
}
//
?>