='$heute')AND(status=1)) ORDER BY date";
$ergebnis = mysql_db_query($typo_db, $sql, $connect);
if($ergebnis)
{
$zeile = mysql_fetch_row($ergebnis);
$eid = $zeile[0];
$lid = $zeile[1];
$date = $zeile[2];
$time = $zeile[3];
$teaser = $zeile[4];
$text = $zeile[5];
// $status = $zeile[6];
$sql2 = "SELECT * FROM event_location WHERE lid='$lid'";
$ergebnis2 = mysql_db_query($typo_db, $sql2, $connect);
$zeile2 = mysql_fetch_row($ergebnis2);
// $lid = $zeile2[0];
$city = $zeile2[1];
$location = $zeile2[2];
$address = $zeile2[3];
$web = $zeile2[4];
$lon = $zeile2[5];
$lat = $zeile2[6];
// $status = $zeile2[7];
$t = substr($date,8,2);
$m = substr($date,5,2);
$j = substr($date,2,2);
$datum = $t.".".$m.".".$j;
if($date==$heute) $datum = "heute";
echo "\n";
}
}
?>
0)
$ignore = true;
// delete free ips
if ($ignore == false)
{
$sql = "delete from counter_ips where unix_timestamp(NOW())-unix_timestamp(visit) > $counter_expire";
mysql_query($sql);
}
// check for entry
if ($ignore == false)
{
$sql = "select * from counter_ips where ip = '$counter_ip'";
$res = mysql_query($sql);
if (mysql_num_rows($res) == 0)
{
// insert
$sql = "INSERT INTO counter_ips (ip, visit) VALUES ('$counter_ip', NOW())";
mysql_query($sql);
}
else
{
$ignore = true;
$sql = "update counter_ips set visit = NOW() where ip = '$counter_ip'";
mysql_query($sql);
}
}
// online?
$sql = "select * from counter_ips";
$res = mysql_query($sql);
$online = mysql_num_rows($res);
// add counter
if ($ignore == false)
{
// day
if ($day_id == date("z"))
{
$day_value++;
}
else
{
$day_value = 1;
$day_id = date("z");
}
// week
if ($week_id == date("W"))
{
$week_value++;
}
else
{
$week_value = 1;
$week_id = date("W");
}
// month
if ($month_id == date("n"))
{
$month_value++;
}
else
{
$month_value = 1;
$month_id = date("n");
}
// year
if ($year_id == date("Y"))
{
$year_value++;
}
else
{
$year_value = 1;
$year_id = date("Y");
}
// all
$all_value++;
// neuer record?
if ($day_value > $record_value)
{
$record_value = $day_value;
$record_date = date("Y-m-d H:i:s");
}
// speichern und aufräumen
$sql = "update counter_values set day_id = '$day_id', day_value = '$day_value', week_id = '$week_id', week_value = '$week_value', month_id = '$month_id', month_value = '$month_value', year_id = '$year_id', year_value = '$year_value', all_value = '$all_value', record_date = '$record_date', record_value = '$record_value' where id = 1";
mysql_query($sql);
}
if($id==13) // auf kontaktseite vollständige anzeige
{
?>
Besucher: $all_value (seit 27.02.04)\n";
}
}
?>
Besucherstatistik  |
|
» Online » Heute » diese Woche » diesen Monat » dieses Jahr » seit 27.02.2004  Rekord: am
|