function month(){
$tpl=new templates();
$sql="SELECT WEEK( zDate) AS ttime2, WEEK( zDate) AS ttime, SUM( size ) as tsize, cached FROM squid_cache_perfs
WHERE zDate > DATE_SUB( NOW( ) , INTERVAL 6 MONTH ) AND YEAR(zDate)=YEAR(NOW()) GROUP BY ttime,ttime2, cached ORDER BY ttime2";
$q=new mysql();
$results=$q->QUERY_SQL($sql,"artica_events");
if(!$q->ok){echo $q->mysql_error;return;}
$count=mysql_num_rows($results);
if(mysql_num_rows($results)==0){return;}
if(!$q->ok){echo $q->mysql_error;}
while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){
$size=$ligne["tsize"]/1024;
$size=$size/1000;
if($ligne["cached"]==1){
$ydata2[]=$size;
}else{
$ydata[]=$size;
}
$time[$ligne["ttime"]]=$ligne["ttime"];
}
while (list ($path, $array) = each ($time) ){
$xdata[]=$path;
}
$gp=new artica_graphs();
$gp->width=650;
$gp->height=500;
$gp->filename="ressources/logs/squid-caches-months.png";
$gp->xdata=$xdata;
$gp->ydata=$ydata;
$gp->ydata2=$ydata2;
$gp->y_title=null;
$gp->x_title=$tpl->_ENGINE_parse_body("{week}");
$gp->title=null;
$gp->margin0=true;
$gp->Fillcolor="blue@0.9";
$gp->color="146497";
$tpl=new templates();
$gp->LineLegend=$tpl->javascript_parse_text("{not_cached}");
$gp->LineLegend2=$tpl->javascript_parse_text("{cached}");
//$gp->SetFillColor('green');
$gp->line_green_double();
echo "<center><img src='ressources/logs/squid-caches-months.png'></center>";
}
function clamd_graphs()
{
$tpl = new templates();
$page = CurrentPageName();
$q = new mysql();
$sql = "SELECT AVG(rss) as rss,AVG(vm) as vm,MINUTE(zDate) as tdate,DATE_FORMAT(zDate,'%Y-%m-%d %H:%i') as tdar FROM clamd_mem WHERE zDate<DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i') GROUP BY tdar";
$results = $q->QUERY_SQL($sql, "artica_events");
if (!$q->ok) {
echo "<H2>{$q->mysql_error}</H2><center style='font-size:11px'><code>{$sql}</code></center>";
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$xdata[] = $ligne["tdate"];
$xdata2[] = $ligne["tdate"];
$ydata[] = $ligne["rss"];
$ydata2[] = $ligne["vm"];
}
$targetedfile = "ressources/logs/" . basename(__FILE__) . "." . __FUNCTION__ . ".clamd.1." . date('Y-m-d-H') . ".png";
$gp = new artica_graphs();
$gp->width = 550;
$gp->height = 350;
$gp->filename = "{$targetedfile}";
$gp->xdata = $xdata;
$gp->ydata = $ydata;
$gp->xdata2 = $xdata2;
$gp->ydata2 = $ydata2;
$gp->y_title = null;
$gp->x_title = $tpl->_ENGINE_parse_body("{minutes}");
$gp->title = null;
$gp->margin0 = true;
$gp->Fillcolor = "blue@0.9";
$gp->color = "146497";
$gp->line_green_double();
if (!is_file($targetedfile)) {
writelogs("Fatal \"{$targetedfile}\" no such file!", __FUNCTION__, __FILE__, __LINE__);
return;
}
echo "<img src='{$targetedfile}' style='margin:5px'>";
$sql = "SELECT AVG(rss) as rss,AVG(vm) as vm,HOUR(zDate) as tdate,DATE_FORMAT(zDate,'%Y-%m-%d %H') as tdar FROM clamd_mem WHERE \n\tzDate=DATE_FORMAT(NOW(),'%Y-%m-%d') GROUP BY tdar";
$results = $q->QUERY_SQL($sql, "artica_events");
$xdata = array();
$xdata2 = array();
$ydata = array();
$ydata2 = array();
if (!$q->ok) {
echo "<H2>{$q->mysql_error}</H2><center style='font-size:11px'><code>{$sql}</code></center>";
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$xdata[] = $ligne["tdate"];
$xdata2[] = $ligne["tdate"];
$ydata[] = $ligne["rss"];
$ydata2[] = $ligne["vm"];
}
$targetedfile = "ressources/logs/" . basename(__FILE__) . "." . __FUNCTION__ . ".clamd.2." . date('Y-m-d-H') . ".png";
$gp = new artica_graphs();
$gp->width = 550;
$gp->height = 350;
$gp->filename = "{$targetedfile}";
$gp->xdata = $xdata;
$gp->ydata = $ydata;
$gp->xdata2 = $xdata2;
$gp->ydata2 = $ydata2;
$gp->y_title = null;
$gp->x_title = $tpl->_ENGINE_parse_body("{hours}");
$gp->title = null;
$gp->margin0 = true;
$gp->Fillcolor = "blue@0.9";
$gp->color = "146497";
$gp->line_green_double();
if (!is_file($targetedfile)) {
writelogs("Fatal \"{$targetedfile}\" no such file!", __FUNCTION__, __FILE__, __LINE__);
return;
}
echo "<img src='{$targetedfile}' style='margin:5px'>";
}
