X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=2487665b87adeafff19855f71cef87f75c7c49e5;hb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;hp=bde8c4836cbe6b34bc44f6e66a13ee00ff5cbe46;hpb=963e55ca1ea79e255f235e359cde9f7862191dc5;p=mailer.git diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index bde8c4836c..2487665b87 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -1,7 +1,7 @@ = "0.3.5") && ($_CONFIG['bonus_mode'] != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); + if ((getExtensionVersion('bonus') >= '0.3.5') && (getConfig('bonus_mode') != "ADD") && ($points > 0)) handleBonusPoints($points); } + // -function BONUS_MAKE_RANK_ROWS($data, $type, $uid) -{ - global $_CONFIG; - $self = false; $OUT = ""; +function addBonusRanks ($data, $type, $userid) { + // Init variables + $self = false; $OUT = ''; $GLOBALS['ranking_content'] = array(); + + // Clear rankings by default + $GLOBALS['ranking_content']['rankings'] = ''; // How many ranks do we have? - $ranks = sizeof(explode(";", $_CONFIG['bonus_ranks'])) + 1; + $ranks = count(explode(';', getConfig('turbo_rates'))) + 1; // Load current user's data - $result = SQL_QUERY_ESC("SELECT level, points, timemark FROM "._MYSQL_PREFIX."_bonus_turbo WHERE %s=%s AND userid=%s LIMIT 1", - array($type, $data, $uid), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + $result = SQL_QUERY_ESC("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1", + array( + $type, + $data, + $userid + ), __FUNCTION__, __LINE__); + + // Entry found? + if (SQL_NUMROWS($result) == 1) { // Load data - list($rank, $points, $mark) = SQL_FETCHROW($result); + $GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], SQL_FETCHARRAY($result)); // Remember all values for later use - $self = true; $points = TRANSLATE_COMMA($points); + $self = true; // Transfer data to template - define('__YR_LEVEL' , $rank); - define('__YR_POINTS', $points); - define('__YR_TMARK' , MAKE_DATETIME($mark, "1")); + $GLOBALS['ranking_content']['yr_level'] = $GLOBALS['ranking_content']['level']; + $GLOBALS['ranking_content']['yr_points'] = translateComma($GLOBALS['ranking_content']['points']); + $GLOBALS['ranking_content']['yr_tmark'] = generateDateTime($GLOBALS['ranking_content']['timemark'], 1); // Load template - define('__YOUR_RANKING_LINE', LOAD_TEMPLATE("show_bonus_yr", true)); - } + $GLOBALS['ranking_content']['own'] = loadTemplate('show_bonus_yr', true, $GLOBALS['ranking_content']); + } // END - if // Load rankings - $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_bonus_turbo WHERE %s=%s ORDER BY level LIMIT %s", - array($type, $data, $_CONFIG['bonus_lines']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) - { + $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE %s=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}", + array($type, $data), __FUNCTION__, __LINE__); + if (SQL_NUMROWS($result) > 0) { // Start generating the ranking list $max = SQL_NUMROWS($result); + // Init variables $SW = 2; - for ($rank = 1; $rank <= $max; $rank++) - { + + // Output all ranks (levels) + for ($rank = 1; $rank <= $max; $rank++) { // Load data - $result_users = SQL_QUERY_ESC("SELECT userid, points, timemark FROM "._MYSQL_PREFIX."_bonus_turbo WHERE %s=%s AND level='%s' LIMIT 1", - array($type, $data, $rank), __FILE__, __LINE__); - list($userid, $points, $mark) = SQL_FETCHROW($result_users); + $result_users = SQL_QUERY_ESC("SELECT + `userid`, `points` +FROM + `{?_MYSQL_PREFIX?}_bonus_turbo` +WHERE + `%s`=%s AND + `level`=%s +LIMIT 1", + array($type, $data, $rank), __FUNCTION__, __LINE__); + + // Nothing found by default + $rows['userid'] = '---'; + $rows['points'] = '---'; // Are you one of them? - if (empty($userid)) - { - // Nothing found - $userid = "---"; $points = "---"; - } - else - { + if (SQL_NUMROWS($result_users) == 1) { + // Load data + $rows = merge_array($rows, SQL_FETCHARRAY($result_users)); + + // Is ext-nickname active? + if (isExtensionActive('nickname')) { + // Then get the nickname + $nick = getNickname($rows['userid']); + + // Is it not empty? Then use it + if (!empty($nick)) $rows['userid'] = $nick; + } // END - if + // Translate comma - $points = TRANSLATE_COMMA($points); - } + $rows['points'] = translateComma($rows['points']); + } // END - if + + // Free result + SQL_FREERESULT($result_users); + + // Add more + $rows['rank'] = $rank; + $rows['sw'] = $SW; // Output row - $OUT .= "