diff options
| author | Sahil Tandon <sahil@FreeBSD.org> | 2010-11-27 06:48:59 +0000 |
|---|---|---|
| committer | Sahil Tandon <sahil@FreeBSD.org> | 2010-11-27 06:48:59 +0000 |
| commit | d80c10291a09a72d55486637579207e49bdfef39 (patch) | |
| tree | 358e08681cb292bd4edebe4511870546f6b54157 /security/mailzu/files/patch-lib-DBEngine.class.php | |
| parent | Add entry about potential compatibility problems with (diff) | |
Add a patch to fix quarantine summary in overview. Also
make a note in pkg-message that PHP's short_open_tag
boolean should be true for proper operation of MailZu.
While here, remove MD5 checksum from distinfo.
Bump PORTREVISION as this affects the package.
PR: ports/152540
Submitted by: Michael Ranner <michael@ranner.eu>
Notes
Notes:
svn path=/head/; revision=265259
Diffstat (limited to 'security/mailzu/files/patch-lib-DBEngine.class.php')
| -rw-r--r-- | security/mailzu/files/patch-lib-DBEngine.class.php | 134 |
1 files changed, 134 insertions, 0 deletions
diff --git a/security/mailzu/files/patch-lib-DBEngine.class.php b/security/mailzu/files/patch-lib-DBEngine.class.php new file mode 100644 index 000000000000..a1b7c75134d9 --- /dev/null +++ b/security/mailzu/files/patch-lib-DBEngine.class.php @@ -0,0 +1,134 @@ +--- lib/DBEngine.class.php.orig 2010-11-24 11:32:33.000000000 +0100 ++++ lib/DBEngine.class.php 2010-11-24 11:32:41.000000000 +0100 +@@ -132,7 +132,7 @@ + MAX(stattable.badheaders) AS badheaders, + MAX(stattable.pending) AS pending + FROM ( +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + COUNT(content) AS spam, + 0 AS banned, + 0 AS viruses, +@@ -141,9 +141,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='S' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + COUNT(content) AS banned, + 0 AS viruses, +@@ -152,9 +152,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='B' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + COUNT(content) AS viruses, +@@ -163,9 +163,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='V' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -174,9 +174,9 @@ + FROM msgs INNER JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE content='H' AND NOT (msgs.quar_type = '') + AND msgrcpt.rs IN ('','v') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -184,7 +184,7 @@ + COUNT(content) AS pending + FROM msgs JOIN msgrcpt ON msgs.mail_id=msgrcpt.mail_id + WHERE msgrcpt.rs='p' AND NOT (msgs.quar_type = '') +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + ) AS stattable + GROUP BY date + ORDER BY date"; +@@ -253,7 +253,7 @@ + MAX(stattable.badheaders) AS badheaders, + MAX(stattable.pending) AS pending + FROM ( +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + COUNT(content) AS spam, + 0 AS banned, + 0 AS viruses, +@@ -263,9 +263,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='S' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + COUNT(content) AS banned, + 0 AS viruses, +@@ -275,9 +275,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='B' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + COUNT(content) AS viruses, +@@ -287,9 +287,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='V' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -299,9 +299,9 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE content='H' AND NOT (msgs.quar_type = '') AND msgrcpt.rs IN ('','v') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + UNION +- SELECT CAST(time_iso AS DATE) AS date, ++ SELECT CAST(FROM_UNIXTIME(time_num) AS DATE) AS date, + 0 AS spam, + 0 AS banned, + 0 AS viruses, +@@ -311,7 +311,7 @@ + $join_type maddr AS recip ON msgrcpt.rid=recip.id + WHERE msgrcpt.rs='p' AND NOT (msgs.quar_type = '') + AND $recipEmailClause +- GROUP BY CAST(time_iso AS DATE) ++ GROUP BY CAST(FROM_UNIXTIME(time_num) AS DATE) + ) AS stattable + GROUP BY date + ORDER BY date"; |