prepare("SELECT `lastSeen` FROM `users` WHERE `banned` = 0 AND `hideStatus` = 0 ORDER BY `lastSeen` DESC;"); $stmt->execute(); $hcount = 0; foreach($stmt as $result) { $from_time = strtotime($result['lastSeen']); $timeSince = round(abs($to_time - $from_time) / 60,2); if ($timeSince < 1440){ $hcount++; } } $stmt = $GLOBALS['dbcon']->prepare("SELECT COUNT(*) FROM `users`;"); $stmt->execute(); $users = $stmt->fetchColumn(0); ?>
Users currently online
Statistics
We currently have registered users.
In the past 24 hours, there have been users online.