Class.statistieken.inc.php ziet er bij mij zo uit:
<?php
function setstats($page)
{
$datum = mktime(0,0,0,date("n"),date("j"),date("Y"));
$maand = date("n");
$jaar = date("Y");
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
$een = mysql_num_rows(mysql_query("SELECT * FROM stats WHERE type='1'"));
if($een == 0){ @mysql_query("INSERT INTO stats (type,value1,value2,datum) VALUES ('1','0','0','".$datum."')"); }
@mysql_query("DELETE FROM stats WHERE type='4' AND datum !='".$datum."'");
// Totaal
$sql = @mysql_query("SELECT count(1) FROM stats WHERE type='4' AND ip='".$ip."'");
$bezoek = @mysql_result($sql, 0);
if($bezoek == 0)
{
@mysql_query("UPDATE stats SET value1=value1+1, value2=value2+1 WHERE type='1'");
@mysql_query("INSERT INTO stats (type,datum,ip) VALUES ('4','".$datum."','".$ip."')");
}
else
{
@mysql_query("UPDATE stats SET value2=value2+1 WHERE type='1'");
}
// Dagelijks
$sql = @mysql_query("SELECT count(1) FROM stats WHERE type='2' AND datum='".$datum."'");
if(@mysql_result($sql, 0) == 0)
{
@mysql_query("INSERT INTO stats (type,value1,value2,datum,maand,jaar) VALUES ('2','1','1','".$datum."','".$maand."','".$jaar."')");
}
else
{
if($bezoek == 0)
{
@mysql_query("UPDATE stats SET value1=value1+1, value2=value2+1 WHERE type='2' AND datum='".$datum."'");
}
else
{
@mysql_query("UPDATE stats SET value2=value2+1 WHERE type='2' AND datum='".$datum."'");
}
}
// Pagina's
if(!empty($page))
{
$sql = @mysql_query("SELECT count(1) FROM stats WHERE type='3' AND extra='".$page."'");
if(@mysql_result($sql, 0) == 0)
{
@mysql_query("INSERT INTO stats (type,extra,value1) VALUES ('3','".$page."','1')");
}
else
{
@mysql_query("UPDATE stats SET value1=value1+1 WHERE type='3' AND extra='".$page."'");
}
}
// unset variabelen
unset($datum);
unset($maand);
unset($jaar);
unset($ip);
unset($sql);
unset($bezoek);
}
$land_img = array('images/lnd_nld.gif','images/lnd_bel.gif','images/lnd_unk.gif');
function getstats()
{
$terug = array();
$datum = mktime(0,0,0,date("n"),date("j"),date("Y"));
$maand = date("n");
$jaar = date("Y");
$vandaag = mysql_fetch_assoc(mysql_query("SELECT * FROM stats WHERE type='2' AND datum='".$datum."'"));
array_push($terug, 'Vandaag');
array_push($terug, '<table border="0" width="100%"><tr><td>Uniek:</td><td width="100">'.$vandaag['value1'].'</td></tr><tr><td>Hits:</td><td width="100">'.$vandaag['value2'].'</td></tr></table>');
$totaal = mysql_fetch_assoc(mysql_query("SELECT * FROM stats WHERE type='1'"));
array_push($terug, 'Totaal <small>| Sinds: '.date('d-m-Y', $totaal['datum']));
array_push($terug, '<table border="0" width="100%"><tr><td>Uniek:</td><td width="100">'.$totaal['value1'].'</td></tr><tr><td>Hits:</td><td width="100">'.$totaal['value2'].'</td></tr></table>');
$highest_uniek = mysql_fetch_assoc(mysql_query("SELECT * FROM stats WHERE type='2' ORDER BY value1 DESC LIMIT 0,1"));
$highest_hits = mysql_fetch_assoc(mysql_query("SELECT * FROM stats WHERE type='2' ORDER BY value2 DESC LIMIT 0,1"));
array_push($terug, 'Records');
array_push($terug, '<table border="0" width="100%"><tr><td>Uniek:</td><td width="100">'.date("d-m-Y", $highest_uniek['datum']).'</td><td width="100">'.$highest_uniek['value1'].'</td></tr><tr><td>Hits:</td><td width="100">'.date("d-m-Y", $highest_hits['datum']).'</td><td width="100">'.$highest_hits['value2'].'</td></tr></table>');
//Dagen
$dag = '<table border="0" width="100%">';
$dag_naam = array('Zondag','Maandag','Dinsdag','Woensdag','Donderdag','Vrijdag','Zaterdag');
for($i=0; $i <= 6; $i++)
{
$datum2 = mktime(0,0,0,$maand,date("d")-$i,$jaar);
$sql = @mysql_query("SELECT value1, value2 FROM stats WHERE type='2' AND datum='".$datum2."'");
if(@mysql_num_rows($sql)==0)
{
$stats['bezoekers'] = 0;
$stats['hits'] = 0;
}
else
{
$list = @mysql_fetch_array($sql);
$stats['bezoekers'] = $list['value1'];
$stats['hits'] = $list['value2'];
}
if($stats['bezoekers'] != 0)
{
$dag .= '<tr><td>'.$dag_naam[date("w",$datum2)].'</td>
<td width="100">Uniek:</td>
<td width="100">'.$stats['bezoekers'].'</td>
</tr>
<tr>
<td style="border-bottom: 1px solid #dedede;"> </td>
<td width="100" style="border-bottom: 1px solid #dedede;">Hits:</td>
<td width="100" style="border-bottom: 1px solid #dedede;">'.$stats['hits'].'</td>
</tr>';
}
}
$dag .= '</table>';
array_push($terug, 'Afgelopen week');
array_push($terug, $dag);
for($i=0; $i <= 5; $i++)
{
if($maand-$i < 1)
{
$maand2 = 12-($i-$maand);
$jaar2 = $jaar-1;
}
else
{
$maand2 = $maand-$i;
$jaar2 = $jaar;
}
$sql = @mysql_query("SELECT SUM(value1) AS value1, SUM(value2) AS value2 FROM stats WHERE type='2' AND jaar='".$jaar2."' AND maand='".$maand2."' GROUP BY maand");
if(@mysql_num_rows($sql) == 0)
{
$maand_bezoekers[$maand2] = 0;
$maand_hits[$maand2] = 0;
}
else
{
$row = @mysql_fetch_array($sql);
$maand_bezoekers[$maand2] = $row['value1'];
$maand_hits[$maand2] = $row['value2'];
}
}
$maand3 = '<table border="0" width="100%">';
$maand_naam = array('','Januari','Februari','Maart','April','Mei','Juni','Juli','Augustus','September','Oktober','November','December');
for($i=0; $i <= 5; $i++)
{
if($maand-$i < 1)
{
$maand2 = 12-($i-$maand);
$jaar2 = $jaar-1;
}
else
{
$maand2 = $maand-$i;
$jaar2 = $jaar;
}
if($maand_bezoekers[$maand2] != 0)
{
$maand3 .= '<tr><td>'.$maand_naam[$maand2].'</td>
<td width="100">Uniek:</td>
<td width="100">'.$maand_bezoekers[$maand2].'</td>
</tr>
<tr>
<td style="border-bottom: 1px solid #dedede;"> </td>
<td width="100" style="border-bottom: 1px solid #dedede;">Hits:</td>
<td width="100" style="border-bottom: 1px solid #dedede;">'.$maand_hits[$maand2].'</td>
</tr>';
}
}
$maand3 .= '</table>';
array_push($terug, 'Afgelopen half jaar');
array_push($terug, $maand3);
$sql = @mysql_query("SELECT extra, value1 FROM stats WHERE type='3' ORDER BY value1 DESC");
$pagina = '<table border="0" width="100%">';
$i = 1;
while($list = @mysql_fetch_array($sql))
{
$pagina .= '<tr><td>'.$i.'. ' . $list['extra'] . '</td>
<td width="100">Hits:</td>
<td width="100">' . $list['value1'] . '</td>
</tr>';
$i ++;
}
$pagina .= '</table>';
array_push($terug, 'Hits per pagina');
array_push($terug, $pagina);
return $terug;
}
?>
