* -------------------------------------------------------------------- *
* 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 - 2012 by Mailer Developer Team *
+ * 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 *
// Some security stuff...
if (!defined('__SECURITY')) {
die();
-} elseif ((!isHtmlOutputMode()) || (!isResetModeEnabled())) {
+} elseif ((!isHtmlOutputMode()) || (!isDailyResetEnabled())) {
// Do not execute when script is in non-HTML mode or no daily reset
return;
} elseif (!isExtensionActive('bonus')) {
//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset started.');
// Check for 100% klickrate mails
-$result_bonus = SQL_QUERY("SELECT
+$result_bonus = sqlQuery("SELECT
`id`,
`userid`,
`subject`,
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
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
} // END - if
// Free memory
-SQL_FREERESULT($result_bonus);
+sqlFreeResult($result_bonus);
// Debug line
//* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'Daily reset ended.');