Parašė Tadziokaz· 2009 Kov. 12 21:03:07
#9
<?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>";
echo "<td align='left'>Vartotoju: ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))." Portale narso: ".dbcount("(*)","online","")."(".dbcount("(*)","online","online_user = '0'")." )</td>
";
echo "</td>
</table>";
?>
Viskas veikia, tik kur Portale narso: ** tai skaiciuoja svecius o ne prisijungusius zmones... Tik susitvarkyk teksto spalva ir pns. Jei nori kad ikisciau ta Vortoju: / Portale narso: į pirma lentele pasakyk padarysiu
Redagavo Tadziokaz· 2009 Kov. 12 21:03:18