openside("Statistika");
echo "
\n\n\n";
}
}
echo "

"; echo "\n"; $result=dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,10"); 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="\n"; //< }elseif($lastseen<160){ $lastseen="\n"; //< }elseif($iW>0){ if($iW==1) $Text="".$locale['XXX_007'].""; elseif($iW==2 || $iW==3 || $iW==4) $Text="".$locale['XXX_011'].""; else $Text="".$locale['XXX_008'].""; $lastseen="$iW $Text"; }elseif($iD>0){ if($iD==1) $Text="".$locale['XXX_009'].""; else $Text="".$locale['XXX_010'].""; $lastseen="$iD $Text"; }else{ $lastseen="$iH:$iM:$iS"; } echo "

\n"; echo "\n"; echo trimlink($data['user_name'], 15)."

".$lastseen."

";
echo "

Nari� Statistika:
";
$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 "� ".$locale['on117']."".trimlink($data['user_name'], 12)."
\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."'")."
";
echo "� Nauj� nari� ?iandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."
";
echo "� I? viso nari�: ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))."
\n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=103");
$num_rows = mysql_num_rows($result);
//display the result
echo "� Super Administratori�: ".$num_rows."
\n";

$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102");
$num_rows = mysql_num_rows($result);
//display the result
echo "� Administratori�: ".$num_rows."
\n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=102");
$num_rows = mysql_num_rows($result);
//display the result
echo "� Forumo Moderatori�: ".$num_rows."
\n";
$result = dbquery("SELECT count(group_id) FROM ".$db_prefix."user_groups");
echo "� Vartotoj� grupi�: [".dbresult($result, 0)."]
";
echo "

---

Svetain�s Statistika:
";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "� Naujien�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles");
echo "� Straipsni�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "� Siuntini�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(photo_id) FROM ".$db_prefix."photos");
echo "� Nuotrauk�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks");
echo "� Nuorod�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(post_id) FROM ".$db_prefix."posts");
echo "� Forumo prane?im�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments");
echo "� Komentar�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
echo "� ?aukyklos prane?im�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(poll_id) FROM ".$db_prefix."polls");
echo "� Apklaus�: [".dbresult($result, 0)."]
";


closeside();

tabux para?�:
dbcount funkcija pasiziurek...