X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fdaily%2Fdaily_100_bonus.php;h=82cfbd612d1e2053f41deb18116d29e9a08e4ebf;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hp=f51b3dd986fd3b99181f495891a5f9c3a9c68f01;hpb=c3b4eaf29946349ff058691db2dcb615a5379bb2;p=mailer.git diff --git a/inc/daily/daily_100_bonus.php b/inc/daily/daily_100_bonus.php index f51b3dd986..82cfbd612d 100644 --- a/inc/daily/daily_100_bonus.php +++ b/inc/daily/daily_100_bonus.php @@ -6,18 +6,13 @@ * -------------------------------------------------------------------- * * File : daily_100_bonus.php * * -------------------------------------------------------------------- * - * Short description : Check for 100% clickrate order * + * Short description : Check for 100% click rate order * * -------------------------------------------------------------------- * * Kurzbeschreibung : Nach Mailbestaetigungen mit 100% Klickrate s. * * -------------------------------------------------------------------- * - * $Revision:: $ * - * $Date:: $ * - * $Tag:: 0.2.1-FINAL $ * - * $Author:: $ * - * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009 - 2011 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2015 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 * @@ -38,11 +33,11 @@ // Some security stuff... if (!defined('__SECURITY')) { die(); -} elseif ((!isHtmlOutputMode()) || (!isResetModeEnabled())) { - // Do not execute when script is in CSS mode or no daily reset +} elseif ((!isHtmlOutputMode()) || (!isDailyResetEnabled())) { + // Do not execute when script is in non-HTML mode or no daily reset return; } elseif (!isExtensionActive('bonus')) { - logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension disabled.'); + if (isDebugModeEnabled()) logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension ext-bonus disabled.'); return; } @@ -50,8 +45,13 @@ if (!defined('__SECURITY')) { //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset started.'); // Check for 100% klickrate mails -$result_bonus = SQL_QUERY("SELECT - `id`, `userid`, `subject`, `timestamp_ordered`, `clicks`, `url` +$result_bonus = sqlQuery("SELECT + `id`, + `userid`, + `subject`, + `timestamp_ordered`, + `clicks`, + `url` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE @@ -61,11 +61,11 @@ WHERE ORDER BY `userid` ASC", __FILE__, __LINE__); -if (!SQL_HASZERONUMS($result_bonus)) { +if (!ifSqlHasZeroNumRows($result_bonus)) { // We found some mail orders... - while ($content = SQL_FETCHARRAY($result_bonus)) { + while ($content = sqlFetchArray($result_bonus)) { // Add points - SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `bonus_stats`=`bonus_stats`+{?bonus_stats?} WHERE `userid`=%s LIMIT 1", + sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `bonus_stats`=`bonus_stats`+{?bonus_stats?} WHERE `userid`=%s LIMIT 1", array(bigintval($content['userid'])), __FILE__, __LINE__); // Translate some data @@ -76,16 +76,16 @@ if (!SQL_HASZERONUMS($result_bonus)) { sendEmail($content['userid'], '{--MEMBER_BONUS_STATS_SUBJECT--}', $message); // Update database - $result_update = SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `bonus_stats_active`='Y' WHERE `id`=%s LIMIT 1", + $result_update = sqlQueryEscaped("UPDATE `{?_MYSQL_PREFIX?}_user_stats` SET `bonus_stats_active`='Y' WHERE `id`=%s LIMIT 1", array(bigintval($content['id'])), __FILE__, __LINE__); } // END - while // Handle bonus points - handleBonusPoints(getConfig('bonus_stats')); + handleBonusPoints(getBonusStats(), $content['userid']); } // END - if // Free memory -SQL_FREERESULT($result_bonus); +sqlFreeResult($result_bonus); // Debug line //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.');