openside("User stat");



//wszystkich userow

$userow = dbcount("(user_id)", "users", "user_status<='1'");

echo"<center><b>Użytkowników: ".$userow."</b><br></center>";



//oddzielenie

echo"<hr>";



//dzisiaj

$result = dbquery("SELECT user_id,user_name, user_joined FROM ".$db_prefix."users ORDER BY user_joined DESC");

$time = time(); $today=0;

while($data = dbarray($result)){

$data1 = showdate('%D', $data[user_joined]);

$data2 = showdate('%D', $time);

if($data1 == $data2) $today++;

}

echo" <b>Dzisaj: ".$today."<br>";



//wczoraj

$time1 = time()-86400*1;

$yday = dbcount("(user_id)", "users", "user_joined >= $time1");

echo" <b>Wczoraj: ".$yday."<br>";



//w tygodniu

$time7 = time()-86400*7;

$week = dbcount("(user_id)", "users", "user_joined >= $time7");

echo "<b> W tym tygodniu: </b>".$week."<br>";



//oddzielenie

echo"<hr>";



//najnowszy user

$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));

echo"<center><b>Najnowszy: <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a></b>";

	echo "<hr>";

		$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user='0'");

		echo $locale['011'].dbrows($result)."<br />\n";



closeside();