All resets rewritten, missing svn:properties added

[mailer.git] / inc / reset / reset_daily.php

diff --git a/inc/reset/reset_daily.php b/inc/reset/reset_daily.php
index da40de9122c28a925f81e84aa2b6e7a38c02bcaf..6071b76d863d1ed6728ba8d154680bc25e963e81 100644 (file)
--- a/inc/reset/reset_daily.php
+++ b/inc/reset/reset_daily.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
  * Mailer v0.2.1-FINAL                                Start: 04/20/2004 *
- * ===================                          Last change: 01/07/2006 *
+ * ===================                          Last change: 06/20/2010 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : reset_daily.php                                  *
@@ -40,25 +40,44 @@
 // Some security stuff...
 if (!defined('__SECURITY')) {
        die();
+} elseif ((getOutputMode() != 0) || (!isResetModeEnabled())) {
+       // Do not execute when script is in CSS mode or no daily reset
+       return;
 } elseif (!isExtensionActive('sql_patches')) {
+       logDebugMessage(__FILE__, __LINE__, 'Not resetting, needed extension disabled.');
        return;
 }
 
-// Do not execute when script is in CSS mode or no daily reset
-if ((getOutputMode() != 0) || (!isResetModeEnabled())) return;
-//* DEBUG: */ outputHtml(basename(__FILE__)."<br />");
-
 // Update user profiles
 if (isExtensionInstalledAndNewer('order', '0.1.1')) {
        // Latest version
-       $result_daily = SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `receive_mails`=`max_mails`, `mail_orders`=0 WHERE receive_mails != max_mails", __FILE__, __LINE__);
+       SQL_QUERY("UPDATE
+       `{?_MYSQL_PREFIX?}_user_data`
+SET
+       `receive_mails`=`max_mails`,
+       `mail_orders`=0
+WHERE
+       `receive_mails` != `max_mails`", __FILE__, __LINE__);
 } else {
        // Obsolete version
-       $result_daily = SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET `receive_mails`=`max_mails` WHERE `receive_mails` != `max_mails`", __FILE__, __LINE__);
+       SQL_QUERY("UPDATE
+       `{?_MYSQL_PREFIX?}_user_data`
+SET
+       `receive_mails`=`max_mails`
+WHERE
+       `receive_mails` != `max_mails`", __FILE__, __LINE__);
 }
 
 // Transfer points from locked_points to points
-$result_daily = SQL_QUERY("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `ref_payout`=0 AND `status`='CONFIRMED' ORDER BY `userid` ASC", __FILE__, __LINE__);
+$result_daily = SQL_QUERY("SELECT
+       `userid`
+FROM
+       `{?_MYSQL_PREFIX?}_user_data`
+WHERE
+       `ref_payout`=0 AND
+       `status`='CONFIRMED'
+ORDER BY
+       `userid` ASC", __FILE__, __LINE__);
 
 //* DEBUG: */ outputHtml(basename(__FILE__).":payout=0;daily|numRows=".SQL_NUMROWS($result_daily)."<br />");
 if (SQL_NUMROWS($result_daily) > 0) {