Statistika přístupů
$result = Array();
$tdwidth = 200; $result[0] = MySQL_Query("SELECT * FROM counter_celkem");
$celkem = MySQL_Result($result[0],0);
function MesicniHodnoceni()
{
global $celkem, $tdwidth, $result;
$result[0] = MySQL_Query("Select Max(Pocet) From counter_mesicni");
$maxwidth = MySQL_Result($result[0],0);
$defaultwidth=$tdwidth/$maxwidth;
$result[1] = MySQL_Query("Select Avg(Pocet) From counter_mesicni");
$prumer = MySQL_Result($result[1],0);
echo "
";
echo "";
echo "Měsíc | ";
echo "Graf | ";
echo "Počet | ";
echo "
";
$result[2] = MySQL_Query("SELECT * FROM counter_mesicni");
while ($zaznam = MySQL_Fetch_Object($result[2])):
$month = $zaznam->mesic;
$count = $zaznam->pocet;
$wth = ($count*$defaultwidth)*0.95;
echo "";
echo "".$month." | ";
echo " | ";
echo "".$count." | ";
echo "
";
endwhile;
echo "Průměr: | ";
echo "".$prumer." | ";
echo "
";
echo "";
echo "Celkem: | | ";
echo "".$count." | ";
echo "
";
echo "
";
}
function DenniHodnoceni()
{
global $celkem, $tdwidth, $result, $tentomesic;
$result[1] = MySQL_Query("Select Max(Pocet) From counter_dnes WHERE datum LIKE '%".$tentomesic."%'");
$maxwidth = MySQL_Result($result[1],0);
if ($maxwidth!=0) $defaultwidth=$tdwidth/$maxwidth;
$result[2] = MySQL_Query("Select Avg(Pocet) From counter_dnes");
$prumer = MySQL_Result($result[2],0);
echo "
";
echo "";
echo "Datum | ";
echo "Počet | ";
echo "
";
$result[3] = MySQL_Query("SELECT * FROM counter_dnes WHERE datum LIKE '%".$tentomesic."%' ORDER BY datum DESC");
while ($zaznam = MySQL_Fetch_Object($result[3])):
$datum = $zaznam->datum;
$count = $zaznam->pocet;
$wth = ($count*$defaultwidth)*0.95;
echo "";
echo "".$datum." | ";
echo " | ";
echo "".$count." | ";
echo "
";
endwhile;
echo "";
echo "Průměr: | | ";
echo "".$prumer." | ";
echo "
";
echo "";
echo "Celkem: | | ";
echo "".$celkem." | ";
echo "
";
echo "
";
}
if ($doba==""):
$doba="Den";
endif;
?>
Vyhodnocení návštěvnosti
if ($doba!="mesic"):
if ($tentomesic==""):
$tentomesic = date("-m-");
endif;
DenniHodnoceni();
else:
MesicniHodnoceni();
endif;
?>
$ipadresa = $REMOTE_ADDR;
$result = Array();
$tdwidth = 200;
$result[0] = MySQL_Query("SELECT Max(Pocet) FROM counter_host");
$maxwidth = MySQL_Result($result[0],0);
$defaultwidth = $tdwidth/$maxwidth;
echo "
";
echo "
Statistika návštěvnosti dle IP
";
echo "
";
echo "
";
echo "";
echo "IP Adresa | ";
echo "Poslední přístup | ";
echo "Graf | ";
echo "Počet | ";
echo "
";
$sql = "SELECT * FROM counter_host ORDER BY datum DESC";
$result[1] = Mysql_query($sql);
while ($guest = MySQL_Fetch_Object($result[1])):
$count = $guest->pocet;
$ipad = $guest->ip;
$datum = $guest->datum;
$width = ($count*$defaultwidth)*0.95;
$bgcolor = ($add==$pip)?"rgb(255,255,200)":"white";
echo "";
echo "";
if ($iip=="dom"):
echo GetHostByAddr($ipad);
else:
echo $ipad;
endif;
echo " | ";
echo "".$datum." | ";
echo " | ";
echo "".$count." | ";
echo "
";
endwhile;
echo "
";
echo "
Počet ip adres: ".MySQL_Num_Rows($result[1])."";
?>