X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmails%2Fdoubler_mails.php;h=2055a6b938df563e396c2395c6870093b232a9b4;hp=03da51b034ff205c9b59c53a39f18de4687f313a;hb=8fad776382e63b3f73f8dbe289f229d79cfc2c22;hpb=7db85bc0c45b62c28ba49e728f489ad4bc1c115f diff --git a/inc/mails/doubler_mails.php b/inc/mails/doubler_mails.php index 03da51b034..2055a6b938 100644 --- a/inc/mails/doubler_mails.php +++ b/inc/mails/doubler_mails.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * 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 - 2012 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 * @@ -39,15 +39,21 @@ if (!defined('__SECURITY')) { die(); } elseif (!isExtensionActive('doubler')) { + // Do not execute when extension is absent + return; +} elseif (!isHtmlOutputMode()) { + // Do not execute when script is in CSS mode return; } -// Do not execute when script is in CSS mode -if (!isHtmlOutputMode()) return; - // Initialize variables -$jackpotPoints = '0'; $userPoints = '0'; -if (isExtensionActive('jackpot')) $jackpotPoints = getJackpotPoints(); +$jackpotPoints = '0'; +$userPoints = '0'; + +// @TODO Can this be rewritten to a filter? +if (isExtensionActive('jackpot')) { + $jackpotPoints = getJackpotPoints(); +} // END - if // Get total points of the doubler itself $DOUBLER_POINTS = getDoublerTotalPointsLeft(); @@ -57,9 +63,9 @@ if ($DOUBLER_POINTS == '0') { } // END - if // If not currently doubled set it to zero -unsetGetRequestParameter('DOUBLER_UID'); -unsetPostRequestParameter('DOUBLER_UID'); -setSession('DOUBLER_UID', ''); +unsetGetRequestElement('DOUBLER_USERID'); +unsetPostRequestElement('DOUBLER_USERID'); +setSession('DOUBLER_USERID', ''); if (empty($GLOBALS['local_doubler_userid'])) $GLOBALS['local_doubler_userid'] = '0'; // Check for doubles which we can pay out @@ -70,42 +76,48 @@ FROM LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS u ON - d.userid=u.userid + d.`userid`=u.`userid` WHERE - u.`status`='CONFIRMED' AND - d.points <= %s AND - d.points >= ({?doubler_min?} * 2) AND - d.completed='N' AND - d.is_ref='N' + u.`status`='CONFIRMED' + " . runFilterChain('user_exclusion_sql', ' ') . " AND + d.`points` <= %s AND + d.`points` >= ({?doubler_min?} * 2) AND + d.`completed`='N' AND + d.`is_ref`='N' ORDER BY - d.timemark ASC", + d.`timemark` ASC", array( $DOUBLER_POINTS ), __FILE__, __LINE__); // Check for accounts with limitation $result_main = SQL_QUERY_ESC("SELECT - d.id, d.userid, d.points, d.remote_ip, d.timemark + d.`id`, + d.`userid`, + d.`points`, + d.`remote_ip`, + d.`timemark` FROM `{?_MYSQL_PREFIX?}_doubler` AS d LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS u ON - d.userid=u.userid + d.`userid`=u.`userid` WHERE - u.`status`='CONFIRMED' AND - d.points <= %s AND - d.points >= ({?doubler_min?} * 2) AND - d.completed='N' AND - d.is_ref='N' + u.`status`='CONFIRMED' + " . runFilterChain('user_exclusion_sql', ' ') . " AND + d.`points` <= %s AND + d.`points` >= ({?doubler_min?} * 2) AND + d.`completed`='N' AND + d.`is_ref`='N' ORDER BY - d.timemark ASC + d.`timemark` ASC LIMIT {?doubler_max_sent?}", array( $DOUBLER_POINTS ), __FILE__, __LINE__); -// Do we have entries found? +// Are there entries found? if (((!SQL_HASZERONUMS($result_total)) && (getConfig('doubler_sent_all') == 'Y')) || ((SQL_NUMROWS($result_main) == getConfig('doubler_group_sent')) && (getConfig('doubler_sent_all') != 'Y'))) { // Switch to matching SQL resource $result_load = $result_main; @@ -118,25 +130,28 @@ if (((!SQL_HASZERONUMS($result_total)) && (getConfig('doubler_sent_all') == 'Y') // Only double when points are enougth! if ($DOUBLER_POINTS >= $content['points']) { // Check for his ref points - $ref = countSumTotalData($content['userid'], 'doubler', 'points', 'refid', false, " AND `completed`='N' AND `is_ref`='Y'"); + $refPoints = countSumTotalData($content['userid'], 'doubler', 'points', 'refid', false, " AND `completed`='N' AND `is_ref`='Y'"); // Zero refid when empty (might be helpful!) - if (empty($ref)) $ref = '0'; + if (empty($refPoints)) { + $refPoints = '0'; + } // END - if - if (($ref > 0) && ($GLOBALS['local_doubler_userid'] == $content['userid']) && (!empty($ref))) { - // Referal points found so add them and set line(s) to completed='Y' - $content['points'] += $ref; + if (($refPoints > 0) && ($GLOBALS['local_doubler_userid'] == $content['userid']) && (!empty($refPoints))) { + // Referral points found so add them and set line(s) to completed='Y' + $content['points'] += $refPoints; SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_doubler` SET `completed`='Y' WHERE `refid`=%s AND `completed`='N' AND `is_ref`='Y'", array(bigintval($content['userid'])), __FILE__, __LINE__); } else { - // No referal points found - $ref = '0'; + // No referral points found + $refPoints = '0'; } // Exclude webmaster from doubling... if ($content['userid'] != getConfig('doubler_userid')) { // Add points - addPointsDirectly(sprintf("doubler_%s", strtolower(getConfig('doubler_send_mode'))), $content['userid'], $content['points']); + initReferralSystem(); + addPointsThroughReferralSystem(sprintf("doubler_%s", strtolower(getConfig('doubler_send_mode'))), $content['userid'], $content['points']); } // END - if // Set entry as "payed" @@ -148,20 +163,14 @@ if (((!SQL_HASZERONUMS($result_total)) && (getConfig('doubler_sent_all') == 'Y') // Check for jackpot inclusion in doubling process if (($jackpotPoints > 0) && ($jackpotPoints >= $content['points']) && (getConfig('doubler_jackpot') == 'Y')) { // Subtract points from jackpot - subtractPointsFromJackpot($content['points']); + $okay = subtractPointsFromJackpot($content['points']); $jackpotPoints -= $content['points']; - - // Okay, done! - $okay = true; } // END - if // Exclude also webmaster's id in taking points from webmaster's account if (($userPoints > 0) && ($userPoints >= $content['points']) && ($okay === false) && (getConfig('doubler_userid') > 0) && ($content['userid'] != getConfig('doubler_userid'))) { - // Add points to used points - subtractPoints('doubler_payout', getConfig('doubler_userid'), $content['points']); - - // Okay, done! - $okay = true; + // Subtract points + $okay = subtractPoints('doubler_payout', getConfig('doubler_userid'), $content['points']); } // END - if // Update doubler's account only when others are not updated