Parašė Tomcis· 2009 Kov. 12 21:03:03
#3
<?php
global $db_prefix;
echo "<table><td width='' >";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "<b><font color='656565'>Iš viso failų: <font color='d2c6b6'><b>".dbresult($result, 0)."</b></font></b><br>\n";
$result = dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads");
echo "<b><font color='656565'>Parsisiūsta: <font color='d2c6b6'><b>".dbresult($result, 0)." kartų</b></font></font></b><br>";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "<b><font color='656565'>Naujienų portale: <font color='d2c6b6'><b>".dbresult($result, 0)."</b></font></font></b><br>";
$result = dbquery("SELECT SUM(news_reads) FROM ".$db_prefix."news");
echo "<b><font color='656565'>Skaityta: <font color='d2c6b6'><b>".dbresult($result, 0)." kartų</b></font></b><br>";
echo "<b><font color='656565'>Turime nariø: <font color='d2c6b6'><b>".dbcount("(user_id)", "users", "user_status<='1'")." </b></font></b> <br>\n";
echo "</td><td>
Vartotoju: ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))." Portale narso: ".dbcount("(*)","online","")."(".dbcount("(*)","online","online_user = '0'")." )
</td>
</table>";
?>
Bandyk.
Redagavo Tomcis· 2009 Kov. 12 21:03:18