opensidex ("User stat", off);



//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";

echo "<hr>";

echo"<center><b>Użytkowników Online:</b><br></center>";

$result=dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_lastvisit DESC LIMIT 0,7");



		echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" class=\"\">";

		if(dbrows($result)!=0){

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

				$lastseen = time() - $data['user_lastvisit'];

				$iW = sprintf("%2d", floor($lastseen/604800));

				$iD = sprintf("%2d", floor($lastseen/(60*60*24)));

				$iH = sprintf("%02d", floor((($lastseen%604800)%86400)/3600));

				$iM = sprintf("%02d", floor(((($lastseen%604800)%86400)%3600)/60));

				$iS = sprintf("%02d", floor((((($lastseen%604800)%86400)%3600)%60)));

				if ($lastseen < 60) {

					$lastseen="<nobr><font color='009900'>Online</font></nobr>";

				} elseif ($lastseen < 360) {

					$lastseen="<nobr><font color='FF0000'>Ofline</font></nobr>";

				} elseif ($iW > 0) {

					if ($iW == 1) $Text= $locale['OUE_020'];

					else $Text= $locale['OUE_021'];

					$lastseen="<nobr>$iW $Text</nobr>";

				}elseif($iD > 0){

					if ($iD == 1) $Text= $locale['OUE_022'];

					else $Text= $locale['OUE_023'];

					$lastseen="<nobr>$iD $Text</nobr>";

				} else {

					$lastseen="$iH:$iM:$iS";

				}



				echo "<tr><td class=\"small\" align=\"left\"><img src='".THEME."/images/bullet.gif'> <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>";

				echo $data['user_name']."</a></td><td class=\"small2\" align=\"right\">".$lastseen."</td></tr>";

			}

		} 

                        echo "</table>";

		$sitename = dbresult(dbquery("SELECT sitename FROM ".$db_prefix."settings"),0);

closeside();