"); 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']); } // 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 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__); // Reset temporary variable and check for users $OUT = ""; if (SQL_NUMROWS($result) > 0) { // Load our winners... $SW = 2; $cnt = 1; while(list($uid, $turbo, $last) = SQL_FETCHROW($result)) { // Prepare data for the template $content = array( 'sw' => $SW, 'cnt' => $cnt, 'uid' => bigintval($uid), 'points' => TRANSLATE_COMMA($turbo), 'last' => MAKE_DATETIME($last, "2"), ); // Load row template $OUT .= LOAD_TEMPLATE("member_bonus_row", true, $content); // Count one up and switch colors $cnt++;$SW = 3 - $SW; } } else { // No one is interested in our "active rallye" ! :-( $OUT = LOAD_TEMPLATE("member_bonus_404", true); } // Free memory SQL_FREERESULT($result); // Remeber row(s) for the template define('__BONUS_ROWS', $OUT); // Load final template LOAD_TEMPLATE("member_bonus"); // ?>