X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-list_bonus.php;fp=0.2.1%2Finc%2Fmodules%2Fadmin%2Fwhat-list_bonus.php;h=0f597a78e5b7c748df9892c105fd2955b7db814e;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=05a060c8d301e3abefe49c08bde30f82de8721af;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/modules/admin/what-list_bonus.php b/0.2.1/inc/modules/admin/what-list_bonus.php index 05a060c8d3..0f597a78e5 100644 --- a/0.2.1/inc/modules/admin/what-list_bonus.php +++ b/0.2.1/inc/modules/admin/what-list_bonus.php @@ -1,156 +1,156 @@ -"); - } - - if (GET_EXT_VERSION("bonus") >= "0.6.9") - { - // Add more bonus points here - $USE = "(0"; - if ($CONFIG['bonus_click_yn'] == "Y") $USE .= " + turbo_bonus"; - if ($CONFIG['bonus_login_yn'] == "Y") $USE .= " + login_bonus"; - if ($CONFIG['bonus_order_yn'] == "Y") $USE .= " + bonus_order"; - if ($CONFIG['bonus_stats_yn'] == "Y") $USE .= " + bonus_stats"; - if ($CONFIG['bonus_ref_yn'] == "Y") $USE .= " + bonus_ref"; - $USE .= ")"; - } - else - { - // Old version ??? - $USE = "turbo_bonus"; - } - - // 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, ".$USE." AS active_bonus, last_online -FROM "._MYSQL_PREFIX."_user_data -WHERE status='CONFIRMED' AND ".$USE." > 0".$LAST." -ORDER BY active_bonus 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['bonus_ranks']) - { - // Maybe he can win his active bonus? - $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_bonus_rows", true, $content); - $SW = 3 - $SW; $cnt++; $total += $turbo; - } - define('__BONUS_ROWS', $OUT); - define('__TOTAL', TRANSLATE_COMMA($total)); - - // Check if we need to display form or not with manuel withdraw - if ($CONFIG['bonus_month'] == date("m", time())) - { - // Load form - define('__BONUS_WITHDRAW_FORM', LOAD_TEMPLATE("admin_list_bonus_form", true)); - } - else - { - // Display message "no manual withdraw possible" - define('__BONUS_WITHDRAW_FORM', "".ADMIN_BONUS_ALREADY_WITHDRAW.""); - } - - // Prepare constant for timemark - define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $CONFIG['ap_in_since'], "2")); - - // Load final template - LOAD_TEMPLATE("admin_list_bonus"); - } - else - { - // No one has become an "activity bonus"... - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BONUS_NO_ACTIVE_RALLYE); - } -} - else -{ - // Aktive-Rallye not activated - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BONUS_RALLYE_DEACTIVATED); -} - -// -?> +"); + } + + if (GET_EXT_VERSION("bonus") >= "0.6.9") + { + // Add more bonus points here + $USE = "(0"; + if ($CONFIG['bonus_click_yn'] == "Y") $USE .= " + turbo_bonus"; + if ($CONFIG['bonus_login_yn'] == "Y") $USE .= " + login_bonus"; + if ($CONFIG['bonus_order_yn'] == "Y") $USE .= " + bonus_order"; + if ($CONFIG['bonus_stats_yn'] == "Y") $USE .= " + bonus_stats"; + if ($CONFIG['bonus_ref_yn'] == "Y") $USE .= " + bonus_ref"; + $USE .= ")"; + } + else + { + // Old version ??? + $USE = "turbo_bonus"; + } + + // 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, ".$USE." AS active_bonus, last_online +FROM "._MYSQL_PREFIX."_user_data +WHERE status='CONFIRMED' AND ".$USE." > 0".$LAST." +ORDER BY active_bonus 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['bonus_ranks']) + { + // Maybe he can win his active bonus? + $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_bonus_rows", true, $content); + $SW = 3 - $SW; $cnt++; $total += $turbo; + } + define('__BONUS_ROWS', $OUT); + define('__TOTAL', TRANSLATE_COMMA($total)); + + // Check if we need to display form or not with manuel withdraw + if ($CONFIG['bonus_month'] == date("m", time())) + { + // Load form + define('__BONUS_WITHDRAW_FORM', LOAD_TEMPLATE("admin_list_bonus_form", true)); + } + else + { + // Display message "no manual withdraw possible" + define('__BONUS_WITHDRAW_FORM', "".ADMIN_BONUS_ALREADY_WITHDRAW.""); + } + + // Prepare constant for timemark + define('__AUTOPURGE_TIMEOUT', MAKE_DATETIME(time() - $CONFIG['ap_in_since'], "2")); + + // Load final template + LOAD_TEMPLATE("admin_list_bonus"); + } + else + { + // No one has become an "activity bonus"... + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BONUS_NO_ACTIVE_RALLYE); + } +} + else +{ + // Aktive-Rallye not activated + LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_BONUS_RALLYE_DEACTIVATED); +} + +// +?>