@@ -51,14+51,14 @@ if ((getOutputMode() != 0) || (!isResetModeEnabled())) return;
// Update user profiles
if (isExtensionInstalledAndNewer('order', '0.1.1')) {
// Latest version
// 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__);
+ $result_daily = 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
} else {
// Obsolete version
- $result_daily = SQL_QUERY("UPDATE `{?_MYSQL_PREFIX?}_user_data` SET receive_mails=max_mails WHERE receive_mails != max_mails", __FILE__, __LINE__);
+ $result_daily = 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
}
// 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__);