X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmails%2Fdoubler_mails.php;h=91f3988d91f3b71b8da61fc987eb956c184dfda5;hb=e17685c65d1a48c061b7c4f64c7a23c165430460;hp=69852389ddef0c34a27192fcf136c38966e6ddbd;hpb=83574a6475896fbdc231e685e2ebb0ee4f3e6eba;p=mailer.git diff --git a/inc/mails/doubler_mails.php b/inc/mails/doubler_mails.php index 69852389dd..91f3988d91 100644 --- a/inc/mails/doubler_mails.php +++ b/inc/mails/doubler_mails.php @@ -1,7 +1,7 @@ = %s AND + d.points >= ({?doubler_min?} * 2) AND d.completed='N' AND d.is_ref='N' ORDER BY d.timemark ASC", array( - $DOUBLER_POINTS, - getConfig(('doubler_min') * 2) + $DOUBLER_POINTS ), __FILE__, __LINE__); // Check for accounts with limitation @@ -97,23 +101,23 @@ ON WHERE u.`status`='CONFIRMED' AND d.points <= %s AND - d.points >= %s AND + d.points >= ({?doubler_min?} * 2) AND d.completed='N' AND d.is_ref='N' ORDER BY d.timemark ASC -LIMIT %d", +LIMIT {?doubler_max_sent?}", array( - $DOUBLER_POINTS, - getConfig(('doubler_min') * 2), - getConfig('doubler_max_sent') + $DOUBLER_POINTS ), __FILE__, __LINE__); // Do we have entries found? -if (((SQL_NUMROWS($result_total) > 0) && (getConfig('doubler_sent_all') == 'Y')) || ((SQL_NUMROWS($result_main) == getConfig('doubler_group_sent')) && (getConfig('doubler_sent_all') != 'Y'))) { +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; - if ((SQL_NUMROWS($result_total) > 0) && (getConfig('doubler_sent_all') == 'Y')) $result_load = $result_total; + if ((!SQL_HASZERONUMS($result_total)) && (getConfig('doubler_sent_all') == 'Y')) { + $result_load = $result_total; + } // END - if // At least one account was found while ($content = SQL_FETCHARRAY($result_load)) { @@ -125,7 +129,7 @@ if (((SQL_NUMROWS($result_total) > 0) && (getConfig('doubler_sent_all') == 'Y')) // Zero refid when empty (might be helpful!) if (empty($ref)) $ref = '0'; - if (($ref > 0) && ($GLOBALS['doubler_userid'] == $content['userid']) && (!empty($ref))) { + 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; SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_doubler` SET `completed`='Y' WHERE `refid`=%s AND `completed`='N' AND `is_ref`='Y'", @@ -148,17 +152,17 @@ if (((SQL_NUMROWS($result_total) > 0) && (getConfig('doubler_sent_all') == 'Y')) $okay = false; // Check for jackpot inclusion in doubling process - if (($jackpot > 0) && ($jackpot >= $content['points']) && (getConfig('doubler_jackpot') == 'Y')) { + if (($jackpotPoints > 0) && ($jackpotPoints >= $content['points']) && (getConfig('doubler_jackpot') == 'Y')) { // Subtract points from jackpot subtractPointsFromJackpot($content['points']); - $jackpot -= $content['points']; + $jackpotPoints -= $content['points']; // Okay, done! $okay = true; } // END - if // Exclude also webmaster's id in taking points from webmaster's account - if (($user > 0) && ($user >= $content['points']) && ($okay === false) && (getConfig('doubler_userid') > 0) && ($content['userid'] != getConfig('doubler_userid'))) { + 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']); @@ -177,20 +181,11 @@ if (((SQL_NUMROWS($result_total) > 0) && (getConfig('doubler_sent_all') == 'Y')) $DOUBLER_POINTS -= $content['points']; // Prepare array - $content = array( - // Doubler transmission id - 'id' => $content['id'], - // Doubled points - 'points' => translateComma($content['points']), - // Timemark - 'when' => generateDateTime($content['timemark'], 2), - // IP number when the member submitted the doubling form - 'ip' => $content['remote_ip'], - ); + $content['timemark'] = generateDateTime($content['timemark'], 2); // Load mail template and send mail away... $message = loadEmailTemplate('member_doubler', $content, $content['userid']); - sendEmail($content['userid'], getMessage('DOUBLER_MEMBER_SUBJECT'), $message); + sendEmail($content['userid'], '{--MEMBER_DOUBLER_SUBJECT--}', $message); } // END - if } // END - while } // END - if