function squid_events_hours()
{
$today = date('Y-m-d');
$gp = new artica_graphs(dirname(__FILE__) . "/ressources/logs/web/squid.{$today}.wwsize.png", 50);
if (!$gp->checkfile()) {
return "<img src='ressources/logs/web/squid.{$today}.wwsize.png'>";
}
$sql = "SELECT hour,hits,www_size FROM squid_events_hours WHERE `day`='{$today}'";
$q = new mysql();
$results = $q->QUERY_SQL($sql, "artica_events");
$count = mysql_num_rows($results);
writelogs($count . " rows", __FUNCTION__, __FILE__, __LINE__);
if (mysql_num_rows($results) == 0) {
$tpl = new templates();
return $tpl->_ENGINE_parse_body("<H2>{NO_DATA_COME_BACK_LATER}</H2>");
}
if (!$q->ok) {
echo $q->mysql_error;
}
while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) {
$xdata[] = $ligne["hour"];
$ziz = round($ligne["www_size"] / 1024);
$ziz = $ziz / 1000;
$ydata[] = $ziz;
}
$gp->xdata = $xdata;
$gp->ydata = $ydata;
$gp->y_title = "MB";
$gp->x_title = "Hours";
$gp->title = null;
$gp->Fillcolor = "blue@0.9";
$gp->color = "146497";
$gp->line_green();
return "<img src='ressources/logs/web/squid.{$today}.wwsize.png'>";
}
function month_hits(){
$fileName = dirname(__FILE__)."/ressources/logs/month-squid-hits.png";
if(file_get_time_min($fileName)<3600){return null;}
@unlink($fileName);
$g=new artica_graphs($fileName,3600);
if(!$g->checkfile()){
writelogs("return $fileName",__FUNCTION__,__FILE__,__LINE__);
return $fileName;}
$sql="SELECT COUNT(ID) as tcount,DATE_FORMAT(zDate,'%d') as tdate
FROM dansguardian_events
WHERE MONTH(zDate) = MONTH(NOW()) AND YEAR(zDate)=YEAR(NOW())
GROUP BY tdate";
$q=new mysql();
$results=$q->QUERY_SQL($sql,"artica_events");
if(!$q->ok){
writelogs("$q->mysql_error",__FUNCTION__,__FILE__,__LINE__);
}
while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){
if($GLOBALS["VERBOSE"]){echo "{$ligne["tdate"]}:{$ligne["tcount"]} ".__FUNCTION__."\n";}
$g->ydata[]=$ligne["tcount"];
$g->xdata[]=$ligne["tdate"];
}
$g->width=700;
$g->title="this_month hits number";
$g->x_title="days";
$g->y_title="hits_number";
$g->line_green();
@chmod($fileName,0777);
}
