X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-bonus.php;h=15861a7bcf301b29b4a1c5ccb6ee98c653c7a10d;hp=66ae60cb37ccf939fee6f73912e285e226bf802c;hb=f9a9c09e1ae257449bfd98f8854e321efba1dc3c;hpb=e521a48cf5d2a3090bd8d7a9cb21dfbc2dfda257 diff --git a/inc/modules/member/what-bonus.php b/inc/modules/member/what-bonus.php index 66ae60cb37..15861a7bcf 100644 --- a/inc/modules/member/what-bonus.php +++ b/inc/modules/member/what-bonus.php @@ -43,17 +43,17 @@ if (!defined('__SECURITY')) { } // Add description as navigation point -ADD_DESCR("member", basename(__FILE__)); +ADD_DESCR("member", __FILE__); 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"; + if (getConfig('bonus_click_yn') == "Y") $USE .= " + turbo_bonus"; + if (getConfig('bonus_login_yn') == "Y") $USE .= " + login_bonus"; + if (getConfig('bonus_order_yn') == "Y") $USE .= " + bonus_order"; + if (getConfig('bonus_stats_yn') == "Y") $USE .= " + bonus_stats"; + if (getConfig('bonus_ref_yn') == "Y") $USE .= " + bonus_ref"; $USE .= ")"; } else @@ -64,35 +64,32 @@ if (GET_EXT_VERSION("bonus") >= "0.6.9") // Autopurge installed? $LAST = "%s"; $ONLINE = ""; -if (EXT_IS_ACTIVE("autopurge")) -{ +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_inactive_since']); + $LAST = " AND last_online >= (UNIX_TIMESTAMP() - %s)"; + $ONLINE = getConfig('ap_inactive_since'); } // Let's check if there are some points left we can "pay"... -$result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS active_bonus, last_online FROM "._MYSQL_PREFIX."_user_data +$result = SQL_QUERY_ESC("SELECT userid, ".$USE." AS points, last_online FROM "._MYSQL_PREFIX."_user_data WHERE ".$USE." > 0 AND status='CONFIRMED'".$LAST." -ORDER BY active_bonus DESC, last_online DESC, userid LIMIT %s", - array($ONLINE, $_CONFIG['bonus_ranks']), __FILE__, __LINE__); +ORDER BY points DESC, last_online DESC, userid +LIMIT %s", + array($ONLINE, getConfig('bonus_ranks')), __FILE__, __LINE__); // Reset temporary variable and check for users $OUT = ""; -if (SQL_NUMROWS($result) > 0) -{ +if (SQL_NUMROWS($result) > 0) { // Load our winners... $SW = 2; $cnt = 1; - while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) - { + while ($content = SQL_FETCHARRAY($result)) { // Prepare data for the template $content = array( - 'sw' => $SW, - 'cnt' => $cnt, - 'uid' => bigintval($uid), - 'points' => TRANSLATE_COMMA($turbo), - 'last' => MAKE_DATETIME($last, "2"), - ); + $content['sw'] = $SW; + $content['cnt'] = $cnt; + $content['uid'] = bigintval($content['uid']); + $content['points'] = TRANSLATE_COMMA($content['points']); + $content['last'] = MAKE_DATETIME($content['last'], "2"); // Load row template $OUT .= LOAD_TEMPLATE("member_bonus_row", true, $content); @@ -100,9 +97,7 @@ if (SQL_NUMROWS($result) > 0) // Count one up and switch colors $cnt++;$SW = 3 - $SW; } -} - else -{ +} else { // No one is interested in our "active rallye" ! :-( $OUT = LOAD_TEMPLATE("member_bonus_404", true); }