X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;fp=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-list_beg.php;h=013330c1d0cfb24d5a55ce4ef1a3527565899950;hp=bda36ba0847a171b4af236b922b6c7dd05235353;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hpb=157ee010917df5ca07e6d31b42f67417b2516d74 diff --git a/0.2.1/inc/modules/admin/what-list_beg.php b/0.2.1/inc/modules/admin/what-list_beg.php index bda36ba084..013330c1d0 100644 --- a/0.2.1/inc/modules/admin/what-list_beg.php +++ b/0.2.1/inc/modules/admin/what-list_beg.php @@ -1,139 +1,139 @@ -"); - } - - // 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']); - } - - // Check if at least one is in the active rallye - $result = SQL_QUERY_ESC("SELECT userid, email, sex, surname, family, beg_points, last_online -FROM "._MYSQL_PREFIX."_user_data -WHERE status='CONFIRMED' AND beg_points > 0".$LAST." -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(list($uid, $email, $sex, $sname, $fname, $turbo, $last) = SQL_FETCHROW($result)) - { - // Generate array fore the dynamic template - $WIN1 = ""; $WIN2 = ""; - if ($cnt <= $CONFIG['beg_ranks']) - { - // Maybe he can win his active beg? - $WIN1 = ""; - $WIN2 = ""; - } - $content = array( - 'uid' => $uid, - 'email' => CREATE_EMAIL_LINK($email, "user_data"), - 'salut' => TRANSLATE_SEX($sex), - 'sname' => $sname, - 'fname' => $fname, - 'turbo' => TRANSLATE_COMMA($turbo), - 'last' => MAKE_DATETIME($last, "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 += $turbo; - } - define('__BEG_ROWS', $OUT); - define('__TOTAL', TRANSLATE_COMMA($total)); - - // Check if we need to display form or not with manuel withdraw - if ($CONFIG['beg_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 - define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $CONFIG['ap_in_since'], "2")); - - // Load final template - LOAD_TEMPLATE("admin_list_beg"); - } - else - { - // No one has joined the begging rallye... - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_NO_RALLYE); - } -} - else -{ - // Rallye deactivated - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_RALLYE_DEACTIVATED); -} - -// -?> +"); + } + + // 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']); + } + + // Check if at least one is in the active rallye + $result = SQL_QUERY_ESC("SELECT userid, email, sex, surname, family, beg_points, last_online +FROM "._MYSQL_PREFIX."_user_data +WHERE status='CONFIRMED' AND beg_points > 0".$LAST." +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(list($uid, $email, $sex, $sname, $fname, $turbo, $last) = SQL_FETCHROW($result)) + { + // Generate array fore the dynamic template + $WIN1 = ""; $WIN2 = ""; + if ($cnt <= $CONFIG['beg_ranks']) + { + // Maybe he can win his active beg? + $WIN1 = ""; + $WIN2 = ""; + } + $content = array( + 'uid' => $uid, + 'email' => CREATE_EMAIL_LINK($email, "user_data"), + 'salut' => TRANSLATE_SEX($sex), + 'sname' => $sname, + 'fname' => $fname, + 'turbo' => TRANSLATE_COMMA($turbo), + 'last' => MAKE_DATETIME($last, "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 += $turbo; + } + define('__BEG_ROWS', $OUT); + define('__TOTAL', TRANSLATE_COMMA($total)); + + // Check if we need to display form or not with manuel withdraw + if ($CONFIG['beg_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 + define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $CONFIG['ap_in_since'], "2")); + + // Load final template + LOAD_TEMPLATE("admin_list_beg"); + } + else + { + // No one has joined the begging rallye... + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_NO_RALLYE); + } +} + else +{ + // Rallye deactivated + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BEG_RALLYE_DEACTIVATED); +} + +// +?>