X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=b37f45c61cbd173e657aa5d7e231da8dcc1d5b0e;hp=8a17b66694bdba4a1764f002799d54bfff68e31d;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=4001187f22197f55e5a1f211fc8defcc180f7c32 diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index 8a17b66694..b37f45c61c 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -1,7 +1,7 @@ = "0.3.5") && (getConfig('bonus_mode') != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); + sqlQueryEscaped("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), + $mailId, + $bonusId, + $rank, + $points + ), __FUNCTION__, __LINE__); + + // @TODO Rewrite this to a filter + if ((isExtensionInstalledAndNewer('bonus', '0.3.5')) && (getBonusMode() != 'ADD') && ($points > 0)) { + handleBonusPoints($points, $userid); + } // END - if } + // -function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { - $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 = 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", - array($type, $data, $uid), __FUNCTION__, __LINE__); - if (SQL_NUMROWS($result) == 1) { + $result = sqlQueryEscaped("SELECT `level`, `points`, `timemark` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s AND `userid`=%s LIMIT 1", + array( + $type, + $data, + bigintval($userid) + ), __FUNCTION__, __LINE__); + + // Entry found? + if (sqlNumRows($result) == 1) { // Load data - list($rank, $points, $mark) = SQL_FETCHROW($result); + $GLOBALS['ranking_content'] = merge_array($GLOBALS['ranking_content'], sqlFetchArray($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']['timemark'] = 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, getConfig('bonus_lines')), __FUNCTION__, __LINE__); - if (SQL_NUMROWS($result) > 0) { - // Start generating the ranking list - $max = SQL_NUMROWS($result); - - $SW = 2; - for ($rank = 1; $rank <= $max; $rank++) { + $result = sqlQueryEscaped("SELECT `id` FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE `%s`=%s ORDER BY `level` ASC LIMIT {?bonus_lines?}", + array($type, $data), __FUNCTION__, __LINE__); + if (!ifSqlHasZeroNumRows($result)) { + // Output all ranks (levels) + for ($rank = 1; $rank <= sqlNumRows($result); $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", + $result_users = sqlQueryEscaped("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 - $userid = "---"; $points = "---"; + $rows['userid'] = '---'; + $rows['points'] = '---'; // Are you one of them? - if (SQL_NUMROWS($result_users) == 1) { + if (sqlNumRows($result_users) == 1) { // Load data - list($userid, $points, $mark) = SQL_FETCHROW($result_users); - - // Translate comma - $points = TRANSLATE_COMMA($points); + $rows = merge_array($rows, sqlFetchArray($result_users)); } // END - if - // Output row - $OUT .= " -  ".$rank.". - ".$userid." - ".$points." -\n"; - $SW = 3 - $SW; + // Free result + sqlFreeResult($result_users); + + // Add more + $rows['rank'] = $rank; + + // Load row template + $OUT .= loadTemplate('member_bonus_turbo_row', TRUE, $rows); } // END - for - if (!$self) { + if ($self === FALSE) { // If current user was not found set constant - define('__YOUR_RANKING_LINE', BONUS_RANK_YOU_ARE_NOT_FOUND); + $GLOBALS['ranking_content']['rankings'] = '{--MEMBER_BONUS_RANK_YOU_ARE_404--}'; } // END - if } else { - // No entries found! - $OUT = " - -
".BONUS_NO_RANKS_1.$data.BONUS_NO_RANKS_2."
+ // No entries found + // @TODO Move this HTML to a template + $OUT = ' + +
{%message,MEMBER_BONUS_NO_RANKS=' . $data . '%}
-\n"; - define('__YOUR_RANKING_LINE', ""); +'; } + + // Retutn content return $OUT; } -// -function BONUS_POINTS_HANDLER ($MODE) { + +// Hanle any bonus points the given user shall become +function handleBonusPoints ($mode, $userid) { // Shall we add bonus points? - if (getConfig('bonus_active') != "Y") 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") && (getConfig('bonus_uid') == "0")) { + if ((getBonusMode() == 'UID') && (!isValidId($userid)) && (isExtensionActive('jackpot'))) { // Update database & config - UPDATE_CONFIG('bonus_mode', "JACKPOT"); + updateConfiguration('bonus_mode', 'JACKPOT'); } // END - if - if ($MODE == "login_bonus") { + if ($mode == 'login_bonus') { // Login bonus detected - $points = getConfig('login_bonus'); + $points = getLoginBonus(); } else { // Direct points supplied - $points = $MODE; + $points = $mode; } + // Check his amount first + $total = getTotalPoints($userid); + // Subtract points from... - switch (getConfig('bonus_mode')) - { - case "JACKPOT": // ... jackpot - if ((SUB_JACKPOT($points) == -1) && (getConfig('bonus_uid') > 0)) { - // Check points amount first... - $TOTAL = GET_TOTAL_DATA(getConfig('bonus_uid'), "user_points", "points") - GET_TOTAL_DATA(getConfig('bonus_uid'), "user_data", "used_points"); - if ($TOTAL >= $points) { - // Subtract points from userid's account - SUB_POINTS("bonus_payout_jackpot", getConfig('bonus_uid'), $points); + switch (getBonusMode()) { + case 'ADD': // Only add them (no subtraction) + // Ignored + break; + + case 'JACKPOT': // ... jackpot + if ((isExtensionActive('jackpot')) && (subtractPointsFromJackpot($points) === FALSE) && (isValidId($userid))) { + if ($total >= $points) { + // Subtract points from userid's account + $return = subtractPointsFromJackpot('bonus_payout_jackpot', $userid, $points); + } // END - if } // END - if - } // END - if - break; - - case "UID": // ... userid's account - // Check his amount first - $TOTAL = GET_TOTAL_DATA(getConfig('bonus_uid'), "user_points", "points") - GET_TOTAL_DATA(getConfig('bonus_uid'), "user_data", "used_points"); - if ($TOTAL >= $points) { - // Subtract points from userid's account - SUB_POINTS("bonus_payout_uid", getConfig('bonus_uid'), $points); - } else { - // Try to subtract from jackpot - $dummy = SUB_JACKPOT($points); - } - break; - } + break; + + case 'UID': // ... userid's account + if ($total >= $points) { + // Subtract points from userid's account + $return = subtractPoints('bonus_payout_userid', $userid, $points); + } elseif (isExtensionActive('jackpot')) { + // Try to subtract from jackpot + $return = subtractPointsFromJackpot($points); + } + break; + + default: // This should not happen + reportBug(__FUNCTION__, __LINE__, 'Invalid bonus-mode ' . getBonusMode() . ' detected.'); + break; + } // END - switch + + // Return status + return $return; } -// -function BONUS_PURGE_EXPIRED_TURBO_BONUS() { +// 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() - ".getConfig('bonus_timeout').")", __FUNCTION__, __LINE__); - if (SQL_AFFECTEDROWS() > 0) { + $result = sqlQuery('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_bonus_turbo` WHERE (UNIX_TIMESTAMP() - `timemark`) >= {?bonus_timeout?}', __FUNCTION__, __LINE__); + + if (!ifSqlHasZeroAffectedRows()) { // Send out email to admin - SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), ""); - } + sendAdminNotification('{--ADMIN_AUTOPURGE_TURBO_SUBJECT--}', 'admin_purge_turbo', sqlAffectedRows()); + } // END - if } -// + +//----------------------------------------------------------------------------- +// Wrapper Functions +//----------------------------------------------------------------------------- + +// Determines whether the "bonus rallye" is active +function isBonusRallyeActive () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Just determine it + $GLOBALS[__FUNCTION__] = ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (isConfigEntrySet('bonus_active')) && (getBonusActive() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Determines whether the "bonus new_member_notify" is active +function isBonusNewMemberNotifyEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Just determine it + $GLOBALS[__FUNCTION__] = ((isExtensionInstalledAndNewer('bonus', '0.7.7')) && (isConfigEntrySet('bonus_new_member_notify')) && (getBonusNewMemberNotify() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_timeout +function getBonusTimeout () { + // Is there 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 () { + // Is there 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 () { + // Is there 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 () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('turbo_rates'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for login_timeout +function getLoginTimeout () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('login_timeout'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for login_bonus +function getLoginBonus () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('login_bonus'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for turbo_bonus +function getTurboBonus () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('turbo_bonus'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_ref +function getBonusRef () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_ref'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_userid +function getBonusUserid () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_userid'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_active +function getBonusActive () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_active'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_notify_points +function getBonusNotifyPoints () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_notify_points'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_new_member_notify +function getBonusNewMemberNotify () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_new_member_notify'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_stats +function getBonusStats () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_stats'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_order +function getBonusOrder () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_order'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_lines +function getBonusLines () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_lines'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_include_own +function getBonusIncludeOwn () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_include_own'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether bonus_include_own is set to 'Y' +function isBonusIncludeOwnEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = (getBonusIncludeOwn() == 'Y'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_disable_notify +function getBonusDisableNotify () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_disable_notify'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for bonus_enable_notify +function getBonusEnableNotify () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('bonus_enable_notify'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for include_bonus_click +function getIncludeBonusClick () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('include_bonus_click'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether include_bonus_click is set to 'Y' +function isIncludeBonusClickEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_click')) && (getIncludeBonusClick() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for include_bonus_login +function getIncludeBonusLogin () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_login')) && getConfig('include_bonus_login')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether include_bonus_login is set to 'Y' +function isIncludeBonusLoginEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_login')) && (getIncludeBonusLogin() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for include_bonus_order +function getIncludeBonusOrder () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('include_bonus_order'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether include_bonus_order is set to 'Y' +function isIncludeBonusOrderEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_order')) && (getIncludeBonusOrder() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for include_bonus_Ref +function getIncludeBonusRef () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('include_bonus_ref'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether include_bonus_ref is set to 'Y' +function isIncludeBonusRefEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_ref')) && (getIncludeBonusRef() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Getter for include_bonus_stats +function getIncludeBonusStats () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = getConfig('include_bonus_stats'); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// Checks whether include_bonus_stats is set to 'Y' +function isIncludeBonusStatsEnabled () { + // Is there cache? + if (!isset($GLOBALS[__FUNCTION__])) { + // Determine it + $GLOBALS[__FUNCTION__] = ((isConfigEntrySet('include_bonus_stats')) && (getIncludeBonusStats() == 'Y')); + } // END - if + + // Return cache + return $GLOBALS[__FUNCTION__]; +} + +// [EOF] ?>