X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=0.2.1%2Finc%2Flibs%2Ftransfer_functions.php;fp=0.2.1%2Finc%2Flibs%2Ftransfer_functions.php;h=80ebfab0bb892dca04645946694261d1f1bcbb64;hb=7bc25dd08431c94ce9edca131d56c1a36b13c28a;hp=0c6d01f4adc38a51a477cf19d067e1fd06fb0361;hpb=157ee010917df5ca07e6d31b42f67417b2516d74;p=mailer.git diff --git a/0.2.1/inc/libs/transfer_functions.php b/0.2.1/inc/libs/transfer_functions.php index 0c6d01f4ad..80ebfab0bb 100644 --- a/0.2.1/inc/libs/transfer_functions.php +++ b/0.2.1/inc/libs/transfer_functions.php @@ -1,88 +1,88 @@ - $max) - { - // Update overdue transfers - $remove = SQL_NUMROWS($result) - $max; - - // This will make it really old, so the final removal query will find it - $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_transfers_in SET time_trans='0' ORDER BY id LIMIT ".$remove, __FILE__, __LINE__); - } - // Second get total out-going lines - $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY id", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > $max) - { - // Update overdue transfers - $remove = SQL_NUMROWS($result) - $max; - - // This will make it really old, so the final removal query will find it - $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_transfers_out SET time_trans='0' ORDER BY id LIMIT ".$remove, __FILE__, __LINE__); - } - - // Remove old in-going transfers - $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE time_trans < ".(time() - $age), __FILE__, __LINE__); - $REMOVE = SQL_AFFECTEDROWS($link); - - // Remove old out-going transfers - $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE time_trans < ".(time() - $age), __FILE__, __LINE__); - $REMOVE += SQL_AFFECTEDROWS($link); - - // Only send email to admin(s) when we have removed entries - if ($REMOVE > 0) - { - if (GET_EXT_VERSION("admins") >= "0.4.1") - { - SEND_ADMIN_EMAILS_PRO(TRANSFER_ADMIN_AUTOPURGE, "admin_transfer_ap", $REMOVE, 0); - } - else - { - $msg = LOAD_EMAIL_TEMPLATE("admin_transfer_ap", $REMOVE, 0); - SEND_ADMIN_EMAILS(TRANSFER_ADMIN_AUTOPURGE, $msg); - } - } -} -// -?> + $max) + { + // Update overdue transfers + $remove = SQL_NUMROWS($result) - $max; + + // This will make it really old, so the final removal query will find it + $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_transfers_in SET time_trans='0' ORDER BY id LIMIT ".$remove, __FILE__, __LINE__); + } + // Second get total out-going lines + $result = SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_user_transfers_out ORDER BY id", __FILE__, __LINE__); + if (SQL_NUMROWS($result) > $max) + { + // Update overdue transfers + $remove = SQL_NUMROWS($result) - $max; + + // This will make it really old, so the final removal query will find it + $result = SQL_QUERY("UPDATE "._MYSQL_PREFIX."_user_transfers_out SET time_trans='0' ORDER BY id LIMIT ".$remove, __FILE__, __LINE__); + } + + // Remove old in-going transfers + $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_in WHERE time_trans < ".(time() - $age), __FILE__, __LINE__); + $REMOVE = SQL_AFFECTEDROWS($link); + + // Remove old out-going transfers + $result = SQL_QUERY("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_transfers_out WHERE time_trans < ".(time() - $age), __FILE__, __LINE__); + $REMOVE += SQL_AFFECTEDROWS($link); + + // Only send email to admin(s) when we have removed entries + if ($REMOVE > 0) + { + if (GET_EXT_VERSION("admins") >= "0.4.1") + { + SEND_ADMIN_EMAILS_PRO(TRANSFER_ADMIN_AUTOPURGE, "admin_transfer_ap", $REMOVE, 0); + } + else + { + $msg = LOAD_EMAIL_TEMPLATE("admin_transfer_ap", $REMOVE, 0); + SEND_ADMIN_EMAILS(TRANSFER_ADMIN_AUTOPURGE, $msg); + } + } +} +// +?>