X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=57d2dc975e1f4e4fa25b72b06fd3d4b9240101ac;hp=155196386b1743194dacf46a1c0588440a6c615e;hb=e3934352dffa6eb9da59a137ae1a9414e5b4d80b;hpb=8ec82aa8ce39be68e4087a26f9763b86fc124ed4 diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index 155196386b..57d2dc975e 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -14,12 +14,10 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -42,10 +40,12 @@ if (!defined('__SECURITY')) { die(); } // END - if -// This function must be run *BEFORE* a link is removed from table 'mxchange_user_links' ! +// This function must be run *BEFORE* a link is removed from table 'mailer_user_links' ! function addTurboBonus ($mid, $userid, $type) { // Shall we add bonus points? - if (!isBonusRallyeActive()) return false; + if (!isBonusRallyeActive()) { + return false; + } // END - if // Init variables $sql = ''; $bonus = '0'; $mail = '0'; $column = ''; @@ -82,12 +82,12 @@ function addTurboBonus ($mid, $userid, $type) { $points = getConfig('turbo_bonus'); } else { // Anything else so let's explode all entered rank points - $test = explode(';', getConfig('turbo_rates')); + $test = explode(';', getTurboRates()); if (!empty($test[$rank - 2])) { // Level found $points = $test[$rank - 2]; } else { - // Level not found! + // Level not found $points = '0.00000'; } } @@ -95,12 +95,12 @@ function addTurboBonus ($mid, $userid, $type) { // Add points to his account directly SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1", array( - bigintval($userid), - $points + $points, + bigintval($userid) ), __FUNCTION__, __LINE__); // Rember this whole data for displaying ranking list - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`, `mail_id`, `bonus_id`, `level`, `points`, `timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())", + SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_bonus_turbo` (`userid`,`mail_id`,`bonus_id`,`level`,`points`,`timemark`) VALUES (%s, %s, %s, %s, %s, UNIX_TIMESTAMP())", array( bigintval($userid), bigintval($mail), @@ -109,7 +109,9 @@ function addTurboBonus ($mid, $userid, $type) { $points ), __FUNCTION__, __LINE__); - if ((isExtensionInstalledAndNewer('bonus', '0.3.5')) && (getConfig('bonus_mode') != 'ADD') && ($points > 0)) handleBonusPoints($points); + if ((isExtensionInstalledAndNewer('bonus', '0.3.5')) && (getBonusMode() != 'ADD') && ($points > 0)) { + handleBonusPoints($points, $userid); + } // END - if } // @@ -121,10 +123,10 @@ function addBonusRanks ($data, $type, $userid) { $GLOBALS['ranking_content']['rankings'] = ''; // How many ranks do we have? - $ranks = count(explode(';', getConfig('turbo_rates'))) + 1; + $ranks = count(explode(';', getTurboRates())) + 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", + $result = SQL_QUERY_ESC("SELECT `level`,`points`,`timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1", array( $type, $data, @@ -150,14 +152,11 @@ function addBonusRanks ($data, $type, $userid) { $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_HASZERONUMS($result)) { - // Start generating the ranking list - $max = SQL_NUMROWS($result); - // Output all ranks (levels) - for ($rank = 1; $rank <= $max; $rank++) { + for ($rank = 1; $rank <= SQL_NUMROWS($result); $rank++) { // Load data $result_users = SQL_QUERY_ESC("SELECT - `userid`, `points` + `userid`,`points` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE @@ -174,15 +173,6 @@ LIMIT 1", 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 } // END - if // Free result @@ -200,11 +190,11 @@ LIMIT 1", $GLOBALS['ranking_content']['rankings'] = '{--MEMBER_BONUS_RANK_YOU_ARE_404--}'; } // END - if } else { - // No entries found! + // No entries found // @TODO Move this HTML to a template $OUT = ' -
' . getMaskedMessage('MEMBER_BONUS_NO_RANKS', $data) . '
+
{%message,MEMBER_BONUS_NO_RANKS=' . $data . '%}
'; } @@ -213,13 +203,18 @@ LIMIT 1", return $OUT; } -// -function handleBonusPoints ($mode) { +// Hanle any bonus points the given user shall become +function handleBonusPoints ($mode, $userid) { // Shall we add bonus points? - if (!isBonusRallyeActive()) return; + if (!isBonusRallyeActive()) { + return; + } // END - if + + // Default is not working + $return = false; // Switch to jackpot-mode when no UID is supplied but userid-mode is selected - if ((getConfig('bonus_mode') == 'UID') && (getBonusUserId() == '0') && (isExtensionActive('jackpot'))) { + if ((getBonusMode() == 'UID') && ($userid == '0') && (isExtensionActive('jackpot'))) { // Update database & config updateConfiguration('bonus_mode', 'JACKPOT'); } // END - if @@ -233,15 +228,19 @@ function handleBonusPoints ($mode) { } // Check his amount first - $total = getTotalPoints(getBonusUserId()); + $total = getTotalPoints($userid); // Subtract points from... - switch (getConfig('bonus_mode')) { + switch (getBonusMode()) { + case 'ADD': // Only add them (no subtraction) + // Ignored + break; + case 'JACKPOT': // ... jackpot - if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) == -1) && (isValidUserId(getBonusUserId()))) { + if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) === false) && (isValidUserId($userid))) { if ($total >= $points) { // Subtract points from userid's account - subtractPointsFromJackpot('bonus_payout_jackpot', getBonusUserId(), $points); + $return = subtractPointsFromJackpot('bonus_payout_jackpot', $userid, $points); } // END - if } // END - if break; @@ -249,69 +248,33 @@ function handleBonusPoints ($mode) { case 'UID': // ... userid's account if ($total >= $points) { // Subtract points from userid's account - subtractPoints('bonus_payout_userid', getBonusUserId(), $points); + $return = subtractPoints('bonus_payout_userid', $userid, $points); } elseif (isExtensionActive('jackpot')) { // Try to subtract from jackpot - $dummy = subtractPointsFromJackpot($points); + $return = subtractPointsFromJackpot($points); } break; + + default: // This should not happen + debug_report_bug(__FUNCTION__, __LINE__, 'Invalid bonus-mode ' . getBonusMode() . ' detected.'); + break; } // END - switch + + // Return status + return $return; } // Purges expired fast-click bonus entries function purgeExpiredTurboBonus() { // Remove entries - $result = SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `timemark` < (UNIX_TIMESTAMP() - {?bonus_timeout?})', __FUNCTION__, __LINE__); + $result = SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__); - if (SQL_AFFECTEDROWS() > 0) { + if (!SQL_HASZEROAFFECTED()) { // Send out email to admin sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_autopurge_turbo', SQL_AFFECTEDROWS()); } // END - if } -//----------------------------------------------------------------------------- -// Filter Functions -//----------------------------------------------------------------------------- - -// Filter for adding login bonus to the user's account -function FILTER_ADD_LOGIN_BONUS () { - // Is the user data valid? - if (!isMember()) { - // Do only run for logged in members - debug_report_bug(__FUNCTION__, __LINE__, 'Please only run this filter for logged in users.'); - } // END - if - - // Bonus is not given by default ;-) - $bonus = false; - if ((isExtensionInstalledAndNewer('sql_patches', '0.2.8')) && (isBonusRallyeActive()) && (getConfig('bonus_login_yn') == 'Y')) { - // Update last login if far enougth away - // @TODO This query isn't right, it will only update if the user was for a longer time away! - SQL_QUERY_ESC('UPDATE - `{?_MYSQL_PREFIX?}_user_data` -SET - `last_login`=UNIX_TIMESTAMP() -WHERE - `userid`=%s AND - `last_login` < (UNIX_TIMESTAMP() - {?login_timeout?}) -LIMIT 1', - array( - getMemberId() - ), __FUNCTION__, __LINE__ - ); - - // Updated entry? - $bonus = (SQL_AFFECTEDROWS() == 1); - } // END - if - - if (($bonus === true) && (getRequestParameter('mode') == 'bonus')) { - // Output message with added points - $GLOBALS['message'] .= '
{--MEMBER_BONUS_LOGIN_BONUS_ADDED--}
'; - } elseif (isExtensionActive('bonus')) { - // No login bonus added! - $GLOBALS['message'] .= '
{--MEMBER_BONUS_LOGIN_BONUS_NOT_ADDED--}
'; - } -} - //----------------------------------------------------------------------------- // Wrapper Functions //----------------------------------------------------------------------------- @@ -340,5 +303,53 @@ function isBonusNewMemberNotifyEnabled () { return $GLOBALS['bonus_new_member_notify_active']; } +// Getter for bonus_timeout +function getBonusTimeout () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_timeout'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_mode +function getBonusMode () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_mode'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_ranks +function getBonusRanks () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_ranks'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for turbo_rates +function getTurboRates () { + // Do we have cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('turbo_rates'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + // [EOF] ?>