setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("CREATE TABLE IF NOT EXISTS visits ( id INTEGER PRIMARY KEY AUTOINCREMENT, ip TEXT NOT NULL, ip_type TEXT NOT NULL, reverse_dns TEXT, browser TEXT, os TEXT, user_agent TEXT, accept_language TEXT, referer TEXT, host TEXT, remote_port TEXT, https INTEGER, request_method TEXT, created_at TEXT NOT NULL)"); return $pdo; } if (isset($_GET['logout'])) { session_destroy(); header('Location: /stats.php'); exit; } $error=''; if ($_SERVER['REQUEST_METHOD']==='POST') { if (hash_equals(STATS_PASSWORD, $_POST['password'] ?? '')) { $_SESSION['stats_ok']=true; header('Location: /stats.php'); exit; } $error='Onjuist wachtwoord.'; } if (empty($_SESSION['stats_ok'])): ?> Statistieken - <?=h(SITE_NAME)?>

query("SELECT COUNT(*) FROM visits")->fetchColumn(); $unique=(int)$pdo->query("SELECT COUNT(DISTINCT ip) FROM visits")->fetchColumn(); $ipv4=(int)$pdo->query("SELECT COUNT(*) FROM visits WHERE ip_type='IPv4'")->fetchColumn(); $ipv6=(int)$pdo->query("SELECT COUNT(*) FROM visits WHERE ip_type='IPv6'")->fetchColumn(); $latest=$pdo->query("SELECT * FROM visits ORDER BY id DESC LIMIT 100")->fetchAll(PDO::FETCH_ASSOC); $top=$pdo->query("SELECT ip, ip_type, COUNT(*) c, MAX(created_at) last_seen FROM visits GROUP BY ip, ip_type ORDER BY c DESC LIMIT 25")->fetchAll(PDO::FETCH_ASSOC); ?> IP Statistieken - <?=h(SITE_NAME)?>

Dashboard

IP-statistieken

Totaal checks

Unieke IP's

IPv4

IPv6

Top 25 IP-adressen

IP	Type	Aantal	Laatst gezien

Laatste 100 checks

Tijd	IP	Type	Browser	OS	Reverse DNS	Host	User Agent