From b9a3ef486ebcde18a5ade37865ff8f397185d24f Mon Sep 17 00:00:00 2001 From: Till Brehm <tbrehm@ispconfig.org> Date: Sun, 24 Jul 2016 05:30:59 -0400 Subject: [PATCH] Fixed #3979 Mailbox users unable to save autoresponders --- server/cron_daily.php | 167 ------------------------------------------------------- 1 files changed, 1 insertions(+), 166 deletions(-) diff --git a/server/cron_daily.php b/server/cron_daily.php index 37f4f4d..ff7a095 100644 --- a/server/cron_daily.php +++ b/server/cron_daily.php @@ -1,171 +1,6 @@ <?php -/* -Copyright (c) 2007, Till Brehm, projektfarm Gmbh -All rights reserved. - -Redistribution and use in source and binary forms, with or without modification, -are permitted provided that the following conditions are met: - - * Redistributions of source code must retain the above copyright notice, - this list of conditions and the following disclaimer. - * Redistributions in binary form must reproduce the above copyright notice, - this list of conditions and the following disclaimer in the documentation - and/or other materials provided with the distribution. - * Neither the name of ISPConfig nor the names of its contributors - may be used to endorse or promote products derived from this software without - specific prior written permission. - -THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND -ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED -WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. -IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, -INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, -BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, -DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY -OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING -NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, -EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. -*/ - -require("lib/config.inc.php"); -require("lib/app.inc.php"); - -set_time_limit(0); - -// make sure server_id is always an int -$conf["server_id"] = intval($conf["server_id"]); - - -// Load required base-classes -$app->uses('ini_parser,file,services'); +// the cron daily file is no longer used and was replaced by cron.php -####################################################################################################### -// store the mailbox statistics in the database -####################################################################################################### - -$sql = "SELECT mailuser_id,maildir FROM mail_user WHERE server_id = ".$conf["server_id"]; -$records = $app->db->queryAllRecords($sql); -foreach($records as $rec) { - if(@is_file($rec["maildir"].'/.ispconfig_mailsize')) { - - // rename file - rename($rec["maildir"].'/.ispconfig_mailsize',$rec["maildir"].'/.ispconfig_mailsize_save'); - - // Read the file - $lines = file($rec["maildir"].'/.ispconfig_mailsize_save'); - $mail_traffic = 0; - foreach($lines as $line) { - $mail_traffic += intval($line); - } - unset($lines); - - // Delete backup file - if(@is_file($rec["maildir"].'/.ispconfig_mailsize_save')) unlink($rec["maildir"].'/.ispconfig_mailsize_save'); - - // Save the traffic stats in the sql database - $tstamp = date("Y-m"); - - $sql = "SELECT * FROM mail_traffic WHERE month = '$tstamp' AND mailuser_id = ".$rec["mailuser_id"]; - $tr = $app->db->queryOneRecord($sql); - - $mail_traffic += $tr["traffic"]; - if($tr["traffic_id"] > 0) { - $sql = "UPDATE mail_traffic SET traffic = $mail_traffic WHERE traffic_id = ".$tr["traffic_id"]; - } else { - $sql = "INSERT INTO mail_traffic (month,mailuser_id,traffic) VALUES ('$tstamp',".$rec["mailuser_id"].",$mail_traffic)"; - } - $app->db->query($sql); - echo $sql; - - } - -} - -####################################################################################################### -// Create webalizer statistics -####################################################################################################### - - -$sql = "SELECT domain_id, domain, document_root FROM web_domain WHERE server_id = ".$conf["server_id"]; -$records = $app->db->queryAllRecords($sql); -foreach($records as $rec) { - $yesterday = date("Ymd",time() - 86400); - $logfile = escapeshellcmd($rec["document_root"].'/log/'.$yesterday.'-access.log'); - if(@is_file($logfile)) { - $domain = escapeshellcmd($rec["domain"]); - $statsdir = escapeshellcmd($rec["document_root"].'/web/stats'); - $webalizer = '/usr/bin/webalizer'; - $webalizer_conf = '/etc/webalizer/webalizer.conf'; - if(!@is_dir($statsdir)) mkdir($statsdir); - exec("$webalizer -c $webalizer_conf -n $domain -s $domain -r $domain -q -T -o $statsdir $logfile"); - } -} - -####################################################################################################### -// Manage and compress web logfiles -####################################################################################################### - -$sql = "SELECT domain_id, domain, document_root FROM web_domain WHERE server_id = ".$conf["server_id"]; -$records = $app->db->queryAllRecords($sql); -foreach($records as $rec) { - $yesterday = date("Ymd",time() - 86400); - $logfile = escapeshellcmd($rec["document_root"].'/log/'.$yesterday.'-access.log'); - if(@is_file($logfile)) { - // Compress yesterdays logfile - exec("gzip -c $logfile > $logfile.gz"); - unlink($logfile); - } - - // delete logfiles after 30 days - $month_ago = date("Ymd",time() - 86400 * 30); - $logfile = escapeshellcmd($rec["document_root"].'/log/'.$month_ago.'-access.log.gz'); - if(@is_file($logfile)) { - unlink($logfile); - } -} - -####################################################################################################### -// Cleanup logs in master database (only the "master-server") -####################################################################################################### - -if ($app->dbmaster == $app->db) { - /** 7 days */ - $tstamp = time() - (60*60*24*7); - - /* - * Keep 7 days in sys_log - * (we can delete the old items, because if they are OK, they don't interrest anymore - * if they are NOT ok, the server will try to process them in 1 minute and so the - * error appears again after 1 minute. So it is no problem to delete the old one! - */ - $sql = "DELETE FROM sys_log WHERE tstamp < $tstamp AND server_id != 0"; - $app->dbmaster->query($sql); - - /* - * The sys_datalog is more difficult. - * 1) We have to keet ALL entries with - * server_id=0, because they depend on ALL servers (even if they are not - * actually in the system (and will be insered in 3 days or so). - * 2) We have to keey ALL entries which are not actually precessed by the - * server never mind how old they are! - */ - - /* First we need all servers and the last sys_datalog-id they processed */ - $sql = "SELECT server_id, updated FROM server ORDER BY server_id"; - $records = $app->dbmaster->queryAllRecords($sql); - - /* Then delete server by server */ - foreach($records as $server) { - $sql = "DELETE FROM sys_datalog WHERE tstamp < " . $tstamp . - " AND server_id != 0 " . // to be more secure! - " AND server_id = " . intval($server['server_id']) . - " AND datalog_id < " . intval($server['updated']); -// echo $sql . "\n"; - $app->dbmaster->query($sql); - } -} - -die("finished.\n"); ?> \ No newline at end of file -- Gitblit v1.9.1