Is very simple php that you can add to menu and put where you want
Obviuusly when efa changes you need to add newly to menu
<?php
/*
MailWatch for MailScanner
Copyright (C) 2003-2011 Steve Freegard (
steve@freegard.name)
Copyright (C) 2011 Garrod Alwood (
garrod.alwood@lorodoes.com)
Copyright (C) 2014-2015 MailWatch Team (
https://github.com/orgs/mailwatch/teams/team-stable)
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
In addition, as a special exception, the copyright holder gives permission to link the code of this program
with those files in the PEAR library that are licensed under the PHP License (or with modified versions of those
files that use the same license as those files), and distribute linked combinations including the two.
You must obey the GNU General Public License in all respects for all of the code used other than those files in the
PEAR library that are licensed under the PHP License. If you modify this program, you may extend this exception to
your version of the program, but you are not obligated to do so.
If you do not wish to do so, delete this exception statement from your version.
As a special exception, you have permission to link this program with the JpGraph library and
distribute executables, as long as you follow the requirements of the GNU GPL in regard to all of the software
in the executable aside from JpGraph.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
// Include of necessary functions
/* require_once("./functions.php"); */
/* require_once("./filter.inc"); */
require_once(__DIR__ . '/functions.php');
require_once(__DIR__ . '/filter.inc.php');
// Authentication checking
session_start();
/* require('login.function.php'); */
require(__DIR__ . '/login.function.php');
// add the header information such as the logo, search, menu, ....
$filter = html_start("* Comet - Analisi Virus", 0, false, true);
$sql = "
SELECT date AS Data,
COUNT(*) AS Totale,
SUM(IF(report LIKE '%Sophos%', 1, 0)) AS Sophos,
SUM(IF(report LIKE '%Sophos%' AND report NOT LIKE '%Clamd%' AND report NOT LIKE '%F-Prot%', 1, 0)) AS SophosOnly,
SUM(IF(report LIKE '%Clamd%', 1, 0)) AS Clam,
SUM(IF(report LIKE '%Clamd%' AND report NOT LIKE '%Sophos%' AND report NOT LIKE '%F-Prot%', 1, 0)) AS ClamOnly,
SUM(IF(report LIKE '%F-Prot%', 1, 0)) AS FProt,
SUM(IF(report LIKE '%F-Prot%' AND report NOT LIKE '%Sophos%' AND report NOT LIKE '%Clamd%' , 1, 0)) AS FProtOnly
FROM maillog WHERE virusinfected > 0
AND report NOT LIKE '%EICAR%' GROUP BY date DESC;
";
$result = dbquery($sql);
//if (!mysql_num_rows($result) > 0) {
// die("Error: no rows retrieved from database\n");
//}
while ($row = mysql_fetch_object($result)) {
$data[] = $row->Data;
$data2[] = $row->Totale;
$data3[] = $row->Sophos;
$data4[] = $row->SophosOnly;
$data5[] = $row->Clam;
$data6[] = $row->ClamOnly;
$data7[] = $row->FProt;
$data8[] = $row->FProtOnly;
}
echo "<TABLE BORDER=\"0\" CELLPADDING=\"10\" CELLSPACING=\"0\" WIDTH=\"100%\">";
echo "<TR style=\"font-size:13px\">";
echo "<TD ALIGN=\"CENTER\"><b>Analisi efficienza motori antivirus</b><br><br>";
echo "<TABLE WIDTH=\"500\" CELLPADDING=2>";
echo "<TR style=\"font-size:13px\">";
echo "<TH BGCOLOR=FFAD33>Data</TH>";
echo "<TH BGCOLOR=ADAD85>Totale</TH>";
echo "<TH BGCOLOR=ADAD85>Sophos</TH>";
echo "<TH BGCOLOR=ADAD85>Only</TH>";
echo "<TH BGCOLOR=ADAD85>Clam</TH>";
echo "<TH BGCOLOR=ADAD85>Only</TH>";
echo "</TR>";
for ($i = 0; $i < count($data); $i++) {
echo "<TR style=\"font-size:12px\">
<TD BGCOLOR=FFD699><b>$data[$i]</b></TD>
<TD BGCOLOR=D6D6C2><b>$data2[$i]</b></TD>
<TD BGCOLOR=D6D6C2><b>$data3[$i]</b></TD>
<TD BGCOLOR=D6D6C2>$data4[$i]</TD>
<TD BGCOLOR=D6D6C2><b>$data5[$i]</b></TD>
<TD BGCOLOR=D6D6C2>$data6[$i]</TD>
</TR>\n";
}
echo "</TABLE>
</TD>
</TR>
</TABLE>";
// Add footer
html_end();
// Close any open db connections
dbclose();