<?php
if($cookie_id != ""){
$last_action = $_SERVER['REQUEST_URI'];
mysql_query("UPDATE leden SET ip='".haalip()."', last_on='".time()."', last_action='".$last_action."' WHERE id='".$cookie_id."'");
}
else{
echo "";
}
$time = time()-180;
$oquery = mysql_query("SELECT * FROM online WHERE time < $time");
while($orow = mysql_fetch_assoc($oquery)){
mysql_query("DELETE FROM online WHERE id='".$orow['id']."'");
}
if(isset($cookie_id) AND !empty($cookie_id)){
$oquery = mysql_query("SELECT * FROM online WHERE wie='".$cookie_id."'");
$oaantal = mysql_num_rows($oquery);
if($oaantal == TRUE){
$pagina_waar1 = @substr($_SERVER["REQUEST_URI"], "1");
mysql_query("UPDATE online SET pagina='".$pagina_waar1."', time='".time()."' WHERE wie='".$cookie_id."'")or die(mysql_error());
} else {
$pagina_waar = @substr($_SERVER["REQUEST_URI"], "1");
mysql_query("INSERT INTO online (wie, pagina, time, ingelogd, ip) VALUES ('".$cookie_id."', '".$pagina_waar."', '".time()."', '".date("H:i:s")."', '".haalip()."')")or die(mysql_error());
}
} else {
$oquery = mysql_query("SELECT * FROM online WHERE ip='".haalip()."'");
$oaantal = mysql_num_rows($oquery);
if($oaantal == TRUE){
$pagina_waar2 = @substr($_SERVER["REQUEST_URI"], "1");
mysql_query("UPDATE online SET pagina='".$pagina_waar2."', time='".time()."' WHERE ip='".haalip()."'")or die(mysql_error());
} else {
$pagina_waar3 = @substr($_SERVER["REQUEST_URI"], "1");
mysql_query("INSERT INTO online (wie, pagina, time, ingelogd, ip) VALUES ('Gast', '".$pagina_waar3."', '".time()."', '".date("H:i:s")."', '".haalip()."')")or die(mysql_error());
}
}
//statistieken
$jaar12 = date("Y");
$maand12 = date("m");
$dag12 = date("d");
$uur12 = date("H");
$minuut12 = date("i");
$seconden12 = date("s");
$datum12 = date("Y-m-d H:i:s");
$date12 = date("Y-m-d");
$tijd12 = date("H:i:s");
//type1 = unieke bezoekers
//type2 = aantal hits
//unieke bezoekers
$sql123 = mysql_query("SELECT * FROM statistieken WHERE type='1' AND ip='".haalip()."' AND date='".$date12."'") or die(mysql_error());
$bestaat123 = mysql_num_rows($sql123);
if($bestaat123 == "1"){
echo "";
}
else{
$sql = "INSERT INTO statistieken (type, jaar, maand, dag, uur, minuut, seconden, ip, date, datum, tijd) VALUES ('1', '".$jaar12."', '".$maand12."', '".$dag12."', '".$uur12."', '".$minuut12."', '".$seconden12."', '".haalip()."', '".$date12."', '".$datum12."', '".$tijd12."')" or die(mysql_error());
$query = mysql_query($sql);
}
//einde unieke bezoekers
//begin hits
$sql123 = "INSERT INTO statistieken (type, jaar, maand, dag, uur, minuut, seconden, ip, date, datum, tijd) VALUES ('2', '".$jaar12."', '".$maand12."', '".$dag12."', '".$uur12."', '".$minuut12."', '".$seconden12."', '".haalip()."', '".$date12."', '".$datum12."', '".$tijd12."')" or die(mysql_error());
$query123 = mysql_query($sql123);
//einde statistieken
?>
|
