openside("Statistika");

echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'>";

echo "\n";

echo "</table>";

echo "<br>Narių Statistika:</b><br>";

$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 "<span class='small'>° naujausias narys</span> ".$locale['on117']."<a 

href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' title='".$data['user_name']."'>".trimlink($data['user_name'], 12)."</a><br />\n";$tag1= date('d');

$tag1= date('d');

$monat1= date('m');

$jahr1= date('Y');

$hanfang = mktime(0,0,0,$monat1,$tag1,$jahr1);

$hende = mktime(23,59,59,$monat1,$tag1,$jahr1);

$ganfang = mktime(0,0,0,$monat1,$tag1-1,$jahr1);

$gende = mktime(23,59,59,$monat1,$tag1-1,$jahr1);

echo "° Naujų narių vakar: ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'")."<br>";

echo "° Naujų narių ?iandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."<br>";

echo "<span class='small'>° I? viso narių: </span> ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))."<br />\n";

closeside();