X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Freset%2Freset_daily.php;h=250730be760b6b571b5ab45adb40cc0bc42c40f9;hp=53a30fc828dee3c66d50770a437b44a61e54b6a0;hb=963e55ca1ea79e255f235e359cde9f7862191dc5;hpb=75ad748a68473ace540251427a74fb781b1145e9 diff --git a/inc/reset/reset_daily.php b/inc/reset/reset_daily.php index 53a30fc828..250730be76 100644 --- a/inc/reset/reset_daily.php +++ b/inc/reset/reset_daily.php @@ -32,8 +32,7 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } @@ -41,14 +40,14 @@ if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) // Update user profiles if (GET_EXT_VERSION("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 $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 -$result_daily = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE ref_payout='0' AND status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__); +$result_daily = SQL_QUERY("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE ref_payout=0 AND status='CONFIRMED' ORDER BY userid", __FILE__, __LINE__); if (SQL_NUMROWS($result_daily) > 0) { @@ -56,15 +55,15 @@ if (SQL_NUMROWS($result_daily) > 0) while (list($uid) = SQL_FETCHROW($result_daily)) { $result_points = SQL_QUERY_ESC("SELECT ref_depth, locked_points FROM "._MYSQL_PREFIX."_user_points -WHERE userid=%d AND locked_points != '0.00000' ORDER BY ref_depth", +WHERE userid=%s AND locked_points != 0.00000 ORDER BY ref_depth", array(bigintval($uid)), __FILE__, __LINE__); if (SQL_NUMROWS($result_points) > 0) { // Ok transfer points while (list($dep, $locked) = SQL_FETCHROW($result_points)) { - $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s, locked_points='0.00000' -WHERE userid=%d AND ref_depth='%s' LIMIT 1", + $result_update = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_points SET points=points+%s, locked_points=0.00000 +WHERE userid=%s AND ref_depth=%s LIMIT 1", array($locked, bigintval($uid), $dep), __FILE__, __LINE__); // Update mediadata as well @@ -85,20 +84,10 @@ WHERE userid=%d AND ref_depth='%s' LIMIT 1", SQL_FREERESULT($result_daily); // Save config value for later references -$CONFIG['last_update'] = time(); +$_CONFIG['last_update'] = time(); // Update database -$result_daily = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_config SET last_update=UNIX_TIMESTAMP() -WHERE config='0' AND last_update != UNIX_TIMESTAMP() LIMIT 1", __FILE__, __LINE__); - -// Destroy cache -if ((GET_EXT_VERSION("cache") >= "0.1.2") && (SQL_AFFECTEDROWS() == 1)) -{ - if ($CACHE->cache_file("config", true)) - { - $CACHE->cache_replace("last_update", time(), "0", $CFG_CACHE); - } -} +UPDATE_CONFIG("last_update", time()); // ?>