openside("Statistika");
echo "�Nauju nariu ?iandien:<�ia niera uzra?o Lietuvi?kai ?
+ ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."
";
echo "�Nauju nariu vakar:<�ia niera uzra?o Lietuvi?kai ? ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'")."
";
echo "

---

";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
echo "� Saukyklos pranesimu: <�ia niera uzra?o Lietuvi?kai ?[".dbresult($result, 0)."]
";
$result = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments");
echo "� Komentaru: <�ia niera uzra?o Lietuvi?kai ?[".dbresult($result, 0)."]
";
echo "� Forumo pranesimu: <�ia niera uzra?o Lietuvi?kai ?[".dbresult($result, 0)."]
";
echo "

---

";
$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 Admin'u: <�ia niera uzra?o Lietuvi?kai ?".$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 "� Administratoriu:<�ia niera uzra?o Lietuvi?kai ? ".$num_rows."
\n";
echo "

---

";
echo "� Palinkejimas<�ia niera uzra?o Lietuvi?kai ?";
echo "

";
$text = array("� Linkiu gerai praleisti laika!<�ia niera uzra?o Lietuvi?kai ?","� Buk laimingas:) ir a? busiu :)<�ia niera uzra?o Lietuvi?kai ?","� Labas:)");
$cc = count($text) ;
$cl = $cc-1;
$rand = rand(0,$cl);
echo"$text[$rand]";
echo "

";
echo "

---

";
echo "?aukyklos Top 5<�ia niera uzra?o Lietuvi?kai ?";
$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS shout_count FROM ".$db_prefix."shoutbox INNER JOIN
".$db_prefix."users ON shout_name=user_id GROUP BY user_name ORDER BY shout_count DESC LIMIT 0,5");
echo "";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "";
}
}
echo "

"; echo "$data[user_name]

[$data[shout_count]]

";
echo "

";
echo "

---

";
echo "�Info, ip seklys<�ia niera uzra?o Lietuvi?kai ?
\n";

echo " Jmsm6; IP yra: ".$_SERVER['REMOTE_ADDR']."";
echo "
";
echo " Jmsm6; portas:<�ia niera uzra?o Lietuvi?kai ?";$ip = $_SERVER["REMOTE_PORT"];
// Rodomas portas:
print $ip;
echo "
";
echo "
";
echo "

---

";
echo "Siuntiniu Kategorijos<�ia niera uzra?o Lietuvi?kai ?

";
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
$rows = dbrows($result);
if ($rows != 0) {
$counter = 0; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo " ".$data['download_cat_name']." ($num)";
echo "
" ;
$counter++;
}
echo "
";

$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo " Siuntini�: [".dbresult($result, 0)."]
";
$result = dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads");
echo " Atsisi�sta: [".dbresult($result, 0)."]
";

} else {
echo "
Jus negalite matyti siuntiniu turite prisijunkti arba uzsiregistroti <�ia niera uzra?o Lietuvi?kai ?REGISTRACIJA

\n"; <�ia niera uzra?o Lietuvi?kai ?
}

closeside();



DB ZIUREKIT > KAT MANO PANELE BUVO LT KALBA :@

Va nuo ?ito skyriaus kopino ir db ziurekit kad LT kalba

http://www.phpfusion.lt/infusions/paneles/paneles.php?x=dmlldw==&paneles_id=482