openside("User Stat");

//wszystkich userow

$wszystkich = dbcount("(user_id)", DB_USERS."");

//dzis

$dziķ = dbcount("(user_id)", DB_USERS." WHERE DATE(FROM_UNIXTIME(user_joined)) = DATE(NOW())");

//wczoraj

$wczoraj = dbcount("(user_id)", DB_USERS." WHERE DATE(FROM_UNIXTIME(user_joined)) = DATE(NOW() - INTERVAL 1 DAY)");

//w tym tygodniu

$tydzien = dbcount("(user_id)", DB_USERS." WHERE WEEKOFYEAR(DATE(FROM_UNIXTIME(user_joined))) = WEEKOFYEAR(DATE(NOW()))");

//najnowszy user

$wynik = dbquery("SELECT * FROM ".DB_USERS." ORDER BY user_joined DESC LIMIT 1");      

$r = dbarray($wynik); 

echo "<table border='0' width='100%' class='small'>

<tr>

<td class='small'>Wszystkich:</td><td align='right' class='small'>".number_format($wszystkich)."</td></tr>

<td class='small'>Dziķ:</td><td align='right' class='small'>".number_format($dziķ)."</td></tr>

<td class='small'>Wczoraj:</td><td align='right' class='small'>".number_format($wczoraj)."</td></tr>

<td class='small'>W tym tygodniu:</td><td align='right' class='small'>".number_format($tydzien)."</td></tr>

<td class='small'>Najnowszy:</td><td align='right' class='small'><a href='".BASEDIR."profile.php?lookup=".$r['user_id']."' class='side'>".$r['user_name']."</a></td></tr>

</table>";

closeside();