X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=55aba4995f949096c806a830686e695ac2d2e772;hb=9e604ce404fe7d2d8dafc259a5fb8cd826aec5e6;hp=888ecab50391bb7b4cb94539cc9a09aa68f29bc5;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index 888ecab503..55aba4995f 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Spezielle Funktion fuer bonus-Erweiterung * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $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 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,244 +37,209 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; +if (!defined('__SECURITY')) { + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); } -// 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; +// This function must be run *BEFORE* a link is removed from table 'mxchange_user_links' ! +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=%d LIMIT 1", - array($mid), __FILE__, __LINE__); - $bonus = $mid; $mail = "0"; - break; - - case "mailid" : - $result = SQL_QUERY_ESC("SELECT clicks FROM "._MYSQL_PREFIX."_user_stats WHERE id=%d LIMIT 1", - array($mid), __FILE__, __LINE__); - $bonus = "0"; $mail = $mid; - break; + case 'bonusid': + $column = 'bonus_id'; + $bonus = $mid; + break; + + case 'mailid' : + $column = 'mail_id'; + $mail = $mid; + break; + + default: + DEBUG_LOG(__FUNCTION__, __LINE__, sprintf("Invalid type %s detected.", $type)); + break; } - // Load clicks from table as current rank - list($rank) = SQL_FETCHROW($result); + // Is a column name set? + if (empty($column)) { + // No, then abort here + return false; + } // END - if - if ($rank == 1) - { + // Check for entry + $rank = GET_TOTAL_DATA($uid, 'bonus_turbo', 'id', 'userid', true, sprintf(" AND `%s`=%s", $column, $mid)) + 1; + + // 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_rates']); - 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"; + $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=%d LIMIT 1", - array(bigintval($uid)), __FILE__, __LINE__); + SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `turbo_bonus`=`turbo_bonus`+%s WHERE `userid`=%s LIMIT 1", + array(bigintval($uid), $points), __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__); - - if ((GET_EXT_VERSION("bonus") >= "0.3.5") && ($CONFIG['bonus_mode'] != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); + 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') && (getConfig('bonus_mode') != "ADD") && ($points > 0)) BONUS_POINTS_HANDLER($points); } // -function BONUS_MAKE_RANK_ROWS($data, $type, $uid) -{ - global $CONFIG; - $self = false; $OUT = ""; +function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { + $self = false; $OUT = ''; // How many ranks do we have? - $ranks = sizeof(explode(";", $CONFIG['bonus_rates'])) + 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=%d 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); // Remember all values for later use - $self = true; $points = TRANSLATE_COMMA($points); + $self = true; $points = translateComma($points); // Transfer data to template define('__YR_LEVEL' , $rank); define('__YR_POINTS', $points); - define('__YR_TMARK' , MAKE_DATETIME($mark, "1")); + define('__YR_TMARK' , generateDateTime($mark, '1')); // 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); - } + $points = translateComma($points); + } // END - if // Output row - $OUT .= "