<?php
session_start();
if($_SESSION['username'])
{
include('config.php');
$username = $_SESSION['username'];
$time=time();
$query = "UPDATE `users` SET `timestamp` = '$time' WHERE username='$username'";
$result = mysql_query($query);
$timestamp = time()-60;
$query1 = "SELECT * FROM `users` WHERE `timestamp` > '$timestamp'";
$result1 = mysql_query($query1);
while($row = mysql_fetch_array($result1, MYSQL_ASSOC))
{
echo "Потребители онлайн: ". $row['username']."</br>";
}
$lastday=time()-86400;
$query2 = "SELECT COUNT(username) FROM users WHERE timestamp>'$lastday'";
$result2 = mysql_query($query2);
while($row = mysql_fetch_array($result2, MYSQL_ASSOC))
{
echo "През последните 24 часа</br> онлайн са били ". $row['COUNT(username)']." потребители";
}
}
else
{
die("");
}
?>
