$FAMS[1]["TITLE"]="{dangerous_websites}";

$FAMS[2]["TITLE"]="{websites_network_pollution}";

$FAMS[3]["TITLE"]="{websites_human_suspects}";

$FAMS[4]["TITLE"]="{websites_heavy_cat}";

$FAMS[5]["TITLE"]="{websites_noprod}";

$page=CurrentPageName();

$tpl=new templates();

header("content-type: application/x-javascript");

$date=time_to_date($_GET["xtime"]);

$title=$tpl->_ENGINE_parse_body("$date {website} {$_GET["familysite"]}");

$title=$tpl->javascript_parse_text("$title::".$FAMS[$_GET["fam"]]["TITLE"]);

$suffix=suffix();

$html="YahooWin3('900','$page?tabs=yes$suffix','$title')";

echo $html;

//$table=date("Ymd",$_GET["xtime"])."_hour";

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$boot=new boostrap_form();

$date=time_to_date($_GET["xtime"]);

$title=$tpl->_ENGINE_parse_body("$date {website} {$_GET["familysite"]}");

$suffix=suffix();

$array["{categories}"]="$page?www-categories=yes$suffix";

$array["{graphs} {websites}"]="$page?www-graĥs=yes$suffix";

$array["{graphs} {members}"]="$page?www-graĥs-members=yes$suffix";

$array["{members}"]="$page?www-members=yes$suffix";

$array[$_GET["familysite"]]="miniadm.webstats.website.infos.php?familysite={$_GET["familysite"]}";

echo "<H3>".$title."</H3>".$boot->build_tab($array);

$t=$_GET["t"];

$familysite=urlencode($_GET["familysite"]);

$suffix="&t=$t&xtime={$_GET["xtime"]}&familysite=$familysite&fam={$_GET["fam"]}";

return $suffix;

$suffix=suffix();

$t=time();

$page=CurrentPageName();

$html="

<div class=BodyContent id='graph-$t'></div>

<div class=BodyContent id='graph1-$t'></div>

<div class=BodyContent id='graph2-$t'></div>

<div class=BodyContent id='graph3-$t'></div>

<script>

AnimateDiv('graph-$t');

AnimateDiv('graph1-$t');

AnimateDiv('graph2-$t');

AnimateDiv('graph3-$t');

Loadjs('$page?graph1=yes&container=graph-$t$suffix');

Loadjs('$page?graph1-1=yes&container=graph1-$t$suffix');

Loadjs('$page?graph2=yes&container=graph2-$t$suffix');

Loadjs('$page?graph3=yes&container=graph3-$t$suffix');

</script>

";

echo $html;

$suffix=suffix();

$t=time();

$page=CurrentPageName();

$html="

<div class=BodyContent id='graph-$t'></div>

<div class=BodyContent id='graph2-$t'></div>

<script>

AnimateDiv('graph-$t');

AnimateDiv('graph2-$t');

Loadjs('$page?graph4=yes&container=graph-$t$suffix');

Loadjs('$page?graph5=yes&container=graph2-$t$suffix');

</script>

";

echo $html;

$suffix=suffix();

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$boot=new boostrap_form();

$form=$boot->SearchFormGen("sitename","sitename-search",$suffix);

echo $form;

$suffix=suffix();

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$boot=new boostrap_form();

$form=$boot->SearchFormGen("sitename,category","categories-search",$suffix);

echo $form;

$suffix=suffix();

$page=CurrentPageName();

$tpl=new templates();

$t=time();

$boot=new boostrap_form();

$form=$boot->SearchFormGen("uid","uid-search",$suffix);

echo $form;

$t=$_GET["t"];

$tpl=new templates();

$MyPage=CurrentPageName();

$q=new mysql_squid_builder();

$users=new usersMenus();

$sock=new sockets();

$boot=new boostrap_form();

$database="squidlogs";

$search='%';

$table=date("Ymd",$_GET["xtime"])."_hour";

$rp=250;

$page=1;

$FORCE_FILTER=null;

$ORDER="ORDER BY size DESC";

if(!$q->TABLE_EXISTS($table, $database)){senderror("$table doesn't exists...");}

if($q->COUNT_ROWS($table, $database)==0){senderror("No data");}

if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}}

if(isset($_POST['page'])) {$page = $_POST['page'];}

$search=string_to_flexquery("uid-search");

if (isset($_POST['rp'])) {$rp = $_POST['rp'];}

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(size) as size, sum(hits) as hits,uid,familysite FROM $table

GROUP BY uid,familysite HAVING `familysite`='$familysite' $search $ORDER LIMIT 0,500";

$results = $q->QUERY_SQL($sql,$database);

if(!$q->ok){senderror($q->mysql_error."<br>$sql");}

while ($ligne = mysql_fetch_assoc($results)) {

$color="black";

$ligne["hits"]=numberFormat($ligne["hits"],0,""," ");

$ligne["size"]=FormatBytes($ligne["size"]/1024);

$UidLink=$boot->trswitch("Loadjs('miniadm.webstats.ByMember.website.byday.php?familysite={$_GET["familysite"]}&uid={$ligne["uid"]}&xtime={$_GET["xtime"]}')");

$tr[]="

<tr>

<td $UidLink><i class='icon-user'></i>&nbsp;{$ligne["uid"]}</a></td>

<td><i class='icon-info-sign'></i>&nbsp;{$ligne["size"]}</td>

<td><i class='icon-info-sign'></i>&nbsp;{$ligne["hits"]}</td>

</tr>";

}

echo $tpl->_ENGINE_parse_body("

<table class='table table-bordered table-hover'>

<thead>

<tr>

<th>{member}</th>

<th>{size}</th>

<th>{hits}</th>

</tr>

</thead>

<tbody>

").@implode("", $tr)."</tbody></table>";

$t=$_GET["t"];

$tpl=new templates();

$MyPage=CurrentPageName();

$q=new mysql_squid_builder();

$users=new usersMenus();

$sock=new sockets();

$boot=new boostrap_form();

$database="squidlogs";

$familysite=$_GET["familysite"];

$search='%';

$table=date("Ymd",$_GET["xtime"])."_hour";

$rp=250;

$page=1;

$boot=new boostrap_form();

$FAMS=$boot->SQUID_CATEGORIES_FAM;

$searchstring=string_to_flexquery("categories-search");

$ORDER=$boot->TableOrder(array("size"=>"DESC"));

if(!$q->TABLE_EXISTS($table)){senderrors("no such table");}

if($q->COUNT_ROWS($table)==0){senderrors("no data");}

//zDate | client | uid | hostname | MAC | familysite | catfam | hits | size

$table="( SELECT sitename,familysite,category,catfam,SUM(size) as size,SUM(hits) as hits FROM `$table` GROUP BY

sitename HAVING familysite='$familysite' AND catfam={$_GET["fam"]}) as t";

$sql="SELECT * FROM $table WHERE 1 $searchstring ORDER BY $ORDER LIMIT 0,250";

$results = $q->QUERY_SQL($sql);

if(!$q->ok){senderrors($q->mysql_error."<br>$sql");}

while ($ligne = mysql_fetch_assoc($results)) {

$md=md5(serialize($ligne));

$fam=$tpl->_ENGINE_parse_body("{$FAMS[$ligne["catfam"]]["TITLE"]}");

$link=null;

$tr[]="

<tr id='$md'>

<td style='font-size:14px' width=50% nowrap $link>{$ligne["sitename"]}</td>

<td style='font-size:14px' width=1% nowrap $link>{$ligne["hits"]}</td>

<td style='font-size:14px' width=1% nowrap $link>{$ligne["size"]}</td>

<td style='font-size:14px' width=1% nowrap $link>{$ligne["category"]}</td>

<td style='font-size:14px' width=50% $link>$fam</td>

</tr>

";

}

echo $boot->TableCompile(array("zDate"=>"{this_month}",

"hits"=>"{hits}",

"size"=>"{size}",

"category"=>"{category}",

"catfam"=>"{behavior}",

),$tr);

$t=$_GET["t"];

$tpl=new templates();

$MyPage=CurrentPageName();

$q=new mysql_squid_builder();

$users=new usersMenus();

$sock=new sockets();

$boot=new boostrap_form();

$database="squidlogs";

$search='%';

$table=date("Ymd",$_GET["xtime"])."_hour";

$rp=250;

$page=1;

$FORCE_FILTER=null;

$ORDER="ORDER BY size DESC";

if(!$q->TABLE_EXISTS($table, $database)){senderror("$table doesn't exists...");}

if($q->COUNT_ROWS($table, $database)==0){senderror("No data");}

if(isset($_POST["sortname"])){if($_POST["sortname"]<>null){$ORDER="ORDER BY {$_POST["sortname"]} {$_POST["sortorder"]}";}}

if(isset($_POST['page'])) {$page = $_POST['page'];}

$search=string_to_flexquery("sitename-search");

if (isset($_POST['rp'])) {$rp = $_POST['rp'];}

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(size) as size, sum(hits) as hits,sitename,familysite FROM $table

GROUP BY sitename,familysite HAVING `familysite`='$familysite' $search $ORDER LIMIT 0,500";

$results = $q->QUERY_SQL($sql,$database);

if(!$q->ok){senderror($q->mysql_error."<br>$sql");}

while ($ligne = mysql_fetch_assoc($results)) {

$color="black";

$ligne["hits"]=numberFormat($ligne["hits"],0,""," ");

$ligne["size"]=FormatBytes($ligne["size"]/1024);

$jsSitename=$boot->trswitch("Loadjs('miniadm.webstats.websites.ByDayBySiteName.php?sitename={$ligne["sitename"]}&xtime={$_GET["xtime"]}')");

$tr[]="

<tr id='$id'>

<td $jsSitename><i class='icon-globe'></i>&nbsp;{$ligne["sitename"]}</a></td>

<td $link><i class='icon-info-sign'></i>&nbsp;{$ligne["size"]}</td>

<td $link><i class='icon-info-sign'></i>&nbsp;{$ligne["hits"]}</td>

</tr>";

}

echo $tpl->_ENGINE_parse_body("

<table class='table table-bordered table-hover'>

<thead>

<tr>

<th>{website}</th>

<th>{size}</th>

<th>{hits}</th>

</tr>

</thead>

<tbody>

").@implode("", $tr)."</tbody></table>";

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(hits) as thits, `hour`,`sitename`,`catfam` FROM $tablename GROUP BY `hour`,`familysite`,`catfam`

HAVING `familysite`='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY `hour`";

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){senderror("$q->mysql_error<br>$sql");}

if(mysql_num_rows($results)>0){

$nb_events=mysql_num_rows($results);

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

$xdata[]=$ligne["hour"];

$ydata[]=$ligne["thits"];

$c++;

}

}

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->xAxis=$xdata;

$highcharts->Title="$familysite: {hits}/{hour}";

$highcharts->yAxisTtitle="{hits}";

$highcharts->xAxisTtitle="{hours}";

$highcharts->datas=array("{hits}"=>$ydata);

echo $highcharts->BuildChart();

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(size) as size, `hour`,`familysite`,`catfam` FROM $tablename GROUP BY `hour`,`familysite`,`catfam`

HAVING `familysite`='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY `hour`";

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){senderror("$q->mysql_error<br>$sql");}

if(mysql_num_rows($results)>0){

$nb_events=mysql_num_rows($results);

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

$xdata[]=$ligne["hour"];

$ligne["size"]=round(($ligne["size"]/1024)/1000);

$ydata[]=$ligne["size"];

$c++;

}

}

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->xAxis=$xdata;

$highcharts->Title="$familysite: {size}/{hour}";

$highcharts->yAxisTtitle="{size}";

$highcharts->xAxisTtitle="{hours}";

$highcharts->datas=array("{size}"=>$ydata);

echo $highcharts->BuildChart();

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(hits) as thits, familysite,sitename,catfam FROM `$tablename`

GROUP BY familysite,sitename ,catfam

HAVING familysite='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY thits DESC LIMIT 0,10";

$unknown=$tpl->_ENGINE_parse_body("{unknown}");

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){$tpl->javascript_senderror($q->mysql_error,$_GET["container"]);}

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if(trim($ligne["sitename"])==null){$ligne["sitename"]=$unknown;}

$PieData[$ligne["sitename"]]=$ligne["thits"];

$c++;

}

$tpl=new templates();

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->PieDatas=$PieData;

$highcharts->ChartType="pie";

$highcharts->PiePlotTitle="{hits}";

$highcharts->Title=$tpl->_ENGINE_parse_body("$familysite: {top_websites_by_hits}");

echo $highcharts->BuildChart();

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(size) as thits, familysite,sitename,catfam FROM `$tablename`

GROUP BY familysite,sitename ,catfam

HAVING familysite='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY thits DESC LIMIT 0,10";

$unknown=$tpl->_ENGINE_parse_body("{unknown}");

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){$tpl->javascript_senderror($q->mysql_error,$_GET["container"]);}

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if(trim($ligne["sitename"])==null){$ligne["sitename"]=$unknown;}

$ligne["thits"]=round(($ligne["thits"]/1024)/1000);

$PieData[$ligne["sitename"]]=$ligne["thits"];

$c++;

}

$tpl=new templates();

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->PieDatas=$PieData;

$highcharts->ChartType="pie";

$highcharts->PiePlotTitle="{hits}";

$highcharts->Title=$tpl->_ENGINE_parse_body("$familysite: {top_websites_by_size} (MB)");

echo $highcharts->BuildChart();

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(hits) as thits, familysite,uid,catfam FROM `$tablename`

GROUP BY familysite,uid,catfam

HAVING familysite='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY thits DESC LIMIT 0,10";

$unknown=$tpl->_ENGINE_parse_body("{unknown}");

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){$tpl->javascript_senderror($q->mysql_error,$_GET["container"]);}

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if(trim($ligne["uid"])==null){$ligne["uid"]=$unknown;}

$PieData[$ligne["uid"]]=$ligne["thits"];

$c++;

}

$tpl=new templates();

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->PieDatas=$PieData;

$highcharts->ChartType="pie";

$highcharts->PiePlotTitle="{hits}";

$highcharts->Title=$tpl->_ENGINE_parse_body("$familysite: {top_members_by_hits}");

echo $highcharts->BuildChart();

$q=new mysql_squid_builder();

$page=CurrentPageName();

$tpl=new templates();

$t=$_GET["t"];

$ff=time();

$tablename=date("Ymd",$_GET["xtime"])."_hour";

$familysite=mysql_escape_string2($_GET["familysite"]);

$sql="SELECT SUM(size) as thits, familysite,uid,catfam FROM `$tablename`

GROUP BY familysite,uid,catfam

HAVING familysite='$familysite' AND `catfam`='{$_GET["fam"]}'

ORDER BY thits DESC LIMIT 0,10";

$unknown=$tpl->_ENGINE_parse_body("{unknown}");

$c=0;

$results=$q->QUERY_SQL($sql);

if(!$q->ok){$tpl->javascript_senderror($q->mysql_error,$_GET["container"]);}

while($ligne=@mysql_fetch_array($results,MYSQL_ASSOC)){

if(trim($ligne["uid"])==null){$ligne["uid"]=$unknown;}

$ligne["thits"]=round(($ligne["thits"]/1024)/1000);

$PieData[$ligne["uid"]]=$ligne["thits"];

$c++;

}

$tpl=new templates();

$highcharts=new highcharts();

$highcharts->container=$_GET["container"];

$highcharts->PieDatas=$PieData;

$highcharts->ChartType="pie";

$highcharts->PiePlotTitle="{hits}";

$highcharts->Title=$tpl->_ENGINE_parse_body("$familysite: {top_members_by_size} (MB)");

echo $highcharts->BuildChart();

}