* -------------------------------------------------------------------- *
* 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. *
* -------------------------------------------------------------------- *
* $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 - 2013 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 *
// 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;
}
//* 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
ORDER BY
`userid` ASC", __FILE__, __LINE__);
-if (!SQL_HASZERONUMS($result_bonus)) {
+if (!ifSqlHasZeroNums($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
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.');