From 65164295778caa2c4e623e7c8e195f2aa3560121 Mon Sep 17 00:00:00 2001
From: Marius Burkard <m.burkard@pixcept.de>
Date: Thu, 07 Apr 2016 13:19:58 -0400
Subject: [PATCH] - Changed 0000-00-00 date and datetime values to NULL (mySQL compatibility), Fixes: #3690
---
interface/web/mail/backup_stats.php | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/interface/web/mail/backup_stats.php b/interface/web/mail/backup_stats.php
index 97b8b97..ec32d35 100644
--- a/interface/web/mail/backup_stats.php
+++ b/interface/web/mail/backup_stats.php
@@ -18,6 +18,7 @@
public function prepareDataRow($rec)
{
global $app;
+ $app->uses('functions');
$rec = parent::prepareDataRow($rec);
@@ -28,6 +29,9 @@
}
$recBackup = $app->db->queryOneRecord('SELECT COUNT(backup_id) AS backup_count FROM mail_backup WHERE mailuser_id = ?', $rec['mailuser_id']);
$rec['backup_copies_exists'] = $recBackup['backup_count'];
+ unset($recBackup);
+ $recBackup = $app->db->queryOneRecord('SELECT SUM(filesize) AS backup_size FROM mail_backup WHERE mailuser_id = ?', $rec['mailuser_id']);
+ $rec['backup_size'] = $app->functions->formatBytes($recBackup['backup_size']);
return $rec;
}
--
Gitblit v1.9.1