X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=dd4959a04cc94f5938d863851962ddc749242f9c;hp=b132a993113c21336270e40a5bbba60179c03d83;hb=f3e4c2c048761589836fdbe6bd2e46599a1833a7;hpb=f7f6e55ee0d90558ad773ce6168767c0af816696 diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index b132a99311..dd4959a04c 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Spezielle Funktion fuer bonus-Erweiterung * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: stelzi $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -38,79 +43,87 @@ if (!defined('__SECURITY')) { } // This function must be run *BEFORE* a link is removed from table 'mxchange_user_links' ! -function BONUS_ADD_TURBO_POINTS($mid, $uid, $type) -{ - global $_CONFIG; - +function BONUS_ADD_TURBO_POINTS ($mid, $uid, $type) { // Shall we add bonus points? - if ($_CONFIG['bonus_active'] == "N") return; + if (getConfig('bonus_active') != "Y") return false; + + // Init variables + $sql = ""; $bonys = 0; $mail = 0; $column = ""; // Select SQL command - $SQL = ""; switch ($type) { case "bonusid": - $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1", - array($mid), __FILE__, __LINE__); - $bonus = $mid; $mail = 0; + $column = "bonus_id"; + $bonus = $mid; break; case "mailid" : - $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%s LIMIT 1", - array($mid), __FILE__, __LINE__); - $bonus = 0; $mail = $mid; + $column = "mail_id"; + $mail = $mid; + break; + + default: + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Invalid type %s detected.", $type)); break; } + // Is a column name set? + if (empty($column)) { + // No, then abort here + return false; + } // END - if + + // Check for entry + $result = SQL_QUERY_ESC("SELECT COUNT(id) AS cnt FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE userid=%s AND %s=%s LIMIT 1", + array($uid, $column, $mid), __FUNCTION__, __LINE__); + // Load clicks from table as current rank list($rank) = SQL_FETCHROW($result); - if ($rank == 1) - { + // Add one line + $rank++; + + // Free result + SQL_FREERESULT($result); + + // Which rank? + if ($rank == 1) { // First rank! - $rank = 1; - $points = $_CONFIG['turbo_bonus']; - } - else - { + $points = getConfig('turbo_bonus'); + } else { // Anything else so let's explode all entered rank points - $test = explode(";", $_CONFIG['bonus_ranks']); - if (!empty($test[$rank - 2])) - { + $test = explode(";", getConfig('turbo_rates')); + if (!empty($test[$rank - 2])) { // Level found $points = $test[$rank - 2]; - } - else - { + } else { // Level not found! $points = "0.00000"; } } // Add points to his account directly - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1", + array(bigintval($uid)), __FUNCTION__, __LINE__); // Rember this whole data for displaying ranking list - $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_bonus_turbo (userid, mail_id, bonus_id, level, points, timemark) VALUES ('%s', '%s', '%s', '".$rank."', '".$points."', UNIX_TIMESTAMP())", - array(bigintval($uid), bigintval($mail), bigintval($bonus)), __FILE__, __LINE__); + 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($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FUNCTION__, __LINE__); - if ((GET_EXT_VERSION("bonus") >= "0.3.5") && ($_CONFIG['bonus_mode'] != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); + if ((GET_EXT_VERSION("bonus") >= "0.3.5") && (getConfig('bonus_mode') != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); } // -function BONUS_MAKE_RANK_ROWS($data, $type, $uid) -{ - global $_CONFIG; +function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { $self = false; $OUT = ""; // 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, $uid), __FUNCTION__, __LINE__); + if (SQL_NUMROWS($result) == 1) { // Load data list($rank, $points, $mark) = SQL_FETCHROW($result); @@ -124,125 +137,111 @@ function BONUS_MAKE_RANK_ROWS($data, $type, $uid) // Load template define('__YOUR_RANKING_LINE', LOAD_TEMPLATE("show_bonus_yr", true)); - } + } // 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 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++) - { + 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, timemark 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 = "---"; // Are you one of them? - if (empty($userid)) - { - // Nothing found - $userid = "---"; $points = "---"; - } - else - { + if (SQL_NUMROWS($result_users) == 1) { + // Load data + list($userid, $points, $mark) = SQL_FETCHROW($result_users); + // Translate comma $points = TRANSLATE_COMMA($points); - } + } // END - if // Output row - $OUT .= " -  ".$rank.". - ".$userid." - ".$points." -\n"; + $OUT .= " +  ".$rank.". + ".$userid." + ".$points." +\n"; $SW = 3 - $SW; - } - if (!$self) - { + } // END - for + + if (!$self) { // If current user was not found set constant define('__YOUR_RANKING_LINE', BONUS_RANK_YOU_ARE_NOT_FOUND); - } - } - else - { + } // END - if + } else { // No entries found! - $OUT = " - - ".BONUS_NO_RANKS_1.$data.BONUS_NO_RANKS_2." - -\n"; + $OUT = " + +
".BONUS_NO_RANKS_1.$data.BONUS_NO_RANKS_2."
+ +\n"; define('__YOUR_RANKING_LINE', ""); } return $OUT; } // -function BONUS_POINTS_HANDLER($MODE) -{ - global $_CONFIG; - +function BONUS_POINTS_HANDLER ($MODE) { // Shall we add bonus points? - if ($_CONFIG['bonus_active'] == "N") return; + if (getConfig('bonus_active') != "Y") return; // Switch to jackpot-mode when no UID is supplied but userid-mode is selected - if (($_CONFIG['bonus_mode'] == "UID") && ($_CONFIG['bonus_uid'] == "0")) $_CONFIG['bonus_mode'] = "JACKPOT"; + if ((getConfig('bonus_mode') == "UID") && (getConfig('bonus_uid') == "0")) { + // Update database & config + UPDATE_CONFIG('bonus_mode', "JACKPOT"); + } // END - if - if ($MODE == "login_bonus") - { + if ($MODE == "login_bonus") { // Login bonus detected - $points = $_CONFIG['login_bonus']; - } - else - { + $points = getConfig('login_bonus'); + } else { // Direct points supplied $points = $MODE; } // Subtract points from... - switch ($_CONFIG['bonus_mode']) + switch (getConfig('bonus_mode')) { case "JACKPOT": // ... jackpot - if ((SUB_JACKPOT($points) == -1) && ($_CONFIG['bonus_uid'] > 0)) - { + if ((SUB_JACKPOT($points) == -1) && (getConfig('bonus_uid') > 0)) { // Check points amount first... - $TOTAL = GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_data", "used_points"); - if ($TOTAL >= $points) - { + $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($_CONFIG['bonus_uid'], $points); - } - } + SUB_POINTS("bonus_payout_jackpot", getConfig('bonus_uid'), $points); + } // END - if + } // END - if break; case "UID": // ... userid's account // Check his amount first - $TOTAL = GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_points", "points") - GET_TOTAL_DATA($_CONFIG['bonus_uid'], "user_data", "used_points"); - if ($TOTAL >= $points) - { + $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($_CONFIG['bonus_uid'], $points); - } - else - { + SUB_POINTS("bonus_payout_uid", getConfig('bonus_uid'), $points); + } else { // Try to subtract from jackpot $dummy = SUB_JACKPOT($points); } break; } } + // -function BONUS_PURGE_EXPIRED_TURBO_BONUS() -{ - global $_CONFIG; +function BONUS_PURGE_EXPIRED_TURBO_BONUS() { // Remove entries - $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_bonus_turbo WHERE timemark < (UNIX_TIMESTAMP() - ".$_CONFIG['bonus_timeout'].")", __FILE__, __LINE__); + $result = SQL_QUERY("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_bonus_turbo` WHERE timemark < (UNIX_TIMESTAMP() - ".getConfig('bonus_timeout').")", __FUNCTION__, __LINE__); if (SQL_AFFECTEDROWS() > 0) { // Send out email to admin - SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", $DELETED, ""); + SEND_ADMIN_NOTIFICATION(AUTOPURGE_ADMIN_TURBO_SUBJECT, "admin_autopurge_turbo", SQL_AFFECTEDROWS(), ""); } } //