Code: Alles auswählen
<?php include($_SERVER["DOCUMENT_ROOT"].'/includes/config.inc');
$ip = $_SERVER["REMOTE_ADDR"];
$datum = date("d.m.Y");
// Alte IP-Adresse löschen
$ablaufzeit = time() - 300; // 300 Sekunden (= 5min.) IP Sperre!
//-----------------------------------------------
$sql = "DELETE * FROM counter_ip WHERE zeit <= $ablaufzeit ";
// Ist die IP-Adresse schon in der Tabelle
if ( $sql = "SELECT ip FROM counter_ip WHERE ip=$ip ")
{
// Nein, IP-Adresse und Timestamp eintragen
$sql = "INSERT INTO counter_ip (ip,zeit) VALUES ('$ip','time()')";
// Counter aktualisieren
$sql = "UPDATE counter_stats SET besucher=besucher + 1 WHERE datum=$datum";
if (mysqli_num_rows()==0)
{
sql = "INSERT INTO counter_stats (datum,besucher) VALUES ('$datum','1');";
}
}
// Hits aktualisieren
mysqli_query("UPDATE counter_stats SET hits=hits + 1 WHERE datum=$datum");
// -----------------------------------------------------------------------------------------------------------------
// Counter Daten von heute
list($besucher_heute, $hits_heute) = mysqli_fetch_row(mysqli_query("SELECT besucher,hits FROM counter_stats WHERE datum = '$datum'"));
// Counter Daten gesamt
list($besucher_gesamt, $hits_gesamt) = mysqli_fetch_row(mysqli_query("SELECT sum(besucher), sum(hits) FROM counter_stats WHERE 1"));
// Hits von Gestern
list($hits_gestern, $besucher_gestern) = mysqli_fetch_row(mysqli_query("SELECT * FROM counter_stats WHERE datum = '$datum'"));
// Besucher Online
list($besucher_online) = mysqli_fetch_row(mysqli_query("SELECT COUNT(*) AS ip FROM counter_ip"));
// registrierte Besucher Online
list($besucher_online_reg) = mysqli_fetch_row(mysqli_query("SELECT COUNT(*) AS ip FROM users "));
// Besucher Gestern
$sql = "SELECT * FROM counter_stats ORDER BY id DESC LIMIT 1,1 ";
if($result = $db->query($sql));
{
while($row = $result->fetch_assoc())
{
$besucher_gestern = $row['besucher'];
$hits_gestern = $row['hits'];
}
// Anzeigen
echo '
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0428 $datum </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0205 $besucher_online_reg </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0200 $besucher_online </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0201 number_format($besucher_heute, 0, ",", ".") </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0369 $besucher_gestern </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0202 number_format($besucher_gesamt, 0, ",", ".") </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0203 number_format($hits_heute, 0, ",", ".") </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/m.gif> <span class=text>$text_0370 number_format($hits_gestern, 0, ",", ".") </span><br>
<img src=$pfad/layout/spacer.gif><img src=$pfad/layout/navi/e.gif> <span class=text>$text_0204 number_format($hits_gesamt, 0, ",", ".") </span><br>
';
?>