X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fbonus_functions.php;h=a13aec9642ac2bec0e371ffb9c92c3284c2e7c2f;hb=98077af43126dd7c274fe57f6ea0494e906e8943;hp=dd4959a04cc94f5938d863851962ddc749242f9c;hpb=414570c5081d337bb6c28dcf521bd8bca02f69e7;p=mailer.git diff --git a/inc/libs/bonus_functions.php b/inc/libs/bonus_functions.php index dd4959a04c..a13aec9642 100644 --- a/inc/libs/bonus_functions.php +++ b/inc/libs/bonus_functions.php @@ -10,10 +10,10 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Spezielle Funktion fuer bonus-Erweiterung * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Revision:: $ * + * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * - * $Author:: stelzi $ * + * $Author:: $ * * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * @@ -38,34 +38,34 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $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) { // Shall we add bonus points? - if (getConfig('bonus_active') != "Y") return false; + if (getConfig('bonus_active') != 'Y') return false; // Init variables - $sql = ""; $bonys = 0; $mail = 0; $column = ""; + $sql = ''; $bonys = 0; $mail = 0; $column = ''; // Select SQL command switch ($type) { - 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; + 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; } // Is a column name set? @@ -76,7 +76,7 @@ function BONUS_ADD_TURBO_POINTS ($mid, $uid, $type) { // 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__); + array($uid, $column, $mid), __FUNCTION__, __LINE__); // Load clicks from table as current rank list($rank) = SQL_FETCHROW($result); @@ -93,7 +93,7 @@ function BONUS_ADD_TURBO_POINTS ($mid, $uid, $type) { $points = getConfig('turbo_bonus'); } else { // Anything else so let's explode all entered rank points - $test = explode(";", getConfig('turbo_rates')); + $test = explode(';', getConfig('turbo_rates')); if (!empty($test[$rank - 2])) { // Level found $points = $test[$rank - 2]; @@ -105,43 +105,43 @@ function BONUS_ADD_TURBO_POINTS ($mid, $uid, $type) { // Add points to his account directly SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET turbo_bonus=turbo_bonus+".$points." WHERE userid=%s LIMIT 1", - array(bigintval($uid)), __FUNCTION__, __LINE__); + array(bigintval($uid)), __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())", - array(bigintval($uid), bigintval($mail), bigintval($bonus), $rank, $points), __FUNCTION__, __LINE__); + 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); + 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) { - $self = false; $OUT = ""; + $self = false; $OUT = ''; // How many ranks do we have? - $ranks = count(explode(";", getConfig('turbo_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=%s LIMIT 1", - array($type, $data, $uid), __FUNCTION__, __LINE__); + $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, getConfig('bonus_lines')), __FUNCTION__, __LINE__); + $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); @@ -150,10 +150,10 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { 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), __FUNCTION__, __LINE__); + array($type, $data, $rank), __FUNCTION__, __LINE__); // Nothing found by default - $userid = "---"; $points = "---"; + $userid = '---'; $points = '---'; // Are you one of them? if (SQL_NUMROWS($result_users) == 1) { @@ -161,7 +161,7 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { list($userid, $points, $mark) = SQL_FETCHROW($result_users); // Translate comma - $points = TRANSLATE_COMMA($points); + $points = translateComma($points); } // END - if // Output row @@ -181,57 +181,57 @@ function BONUS_MAKE_RANK_ROWS ($data, $type, $uid) { // No entries found! $OUT = " -
".BONUS_NO_RANKS_1.$data.BONUS_NO_RANKS_2."
+
".sprintf(getMessage('BONUS_NO_RANKS'), $data)."
\n"; - define('__YOUR_RANKING_LINE', ""); + define('__YOUR_RANKING_LINE', ''); } return $OUT; } // -function BONUS_POINTS_HANDLER ($MODE) { +function BONUS_POINTS_HANDLER ($mode) { // Shall we add bonus points? - if (getConfig('bonus_active') != "Y") return; + if (getConfig('bonus_active') != 'Y') return; // Switch to jackpot-mode when no UID is supplied but userid-mode is selected - if ((getConfig('bonus_mode') == "UID") && (getConfig('bonus_uid') == "0")) { + if ((getConfig('bonus_mode') == 'UID') && (getConfig('bonus_uid') == '0')) { // 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'); } else { // Direct points supplied - $points = $MODE; + $points = $mode; } // 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); + 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); + } // 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 + // 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; } } @@ -241,8 +241,9 @@ function BONUS_PURGE_EXPIRED_TURBO_BONUS() { $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", SQL_AFFECTEDROWS(), ""); - } + sendAdminNotification(AUTOPURGE_ADMIN_TURBO_SUBJECT, 'admin_autopurge_turbo', SQL_AFFECTEDROWS(), ''); + } // END - if } + // ?>