openside("Statystyki encyklopedi");



$hasla = dbquery("SELECT count(ency_id) FROM ".$db_prefix."ency");

$cat = dbquery("SELECT count(ency_cat_id) FROM ".$db_prefix."ency_cat");



$year = date('Y');

$month = date('n');

$time = mktime(0, 0, 0, $month, 1, $year);

$dodanych = dbquery("SELECT count(ency_id) FROM ".$db_prefix."ency WHERE ency_datestamp >'$time'");



$result = dbquery("SELECT photo_datestamp FROM ".$db_prefix."photos WHERE photo_id ORDER BY photo_datestamp DESC");

$i_alt = dbresult($result, 0);



echo "<table border='0' width='100%' class='small'>

<tr><td class='small'>Haseł:</td><td align='right' class='small'>".dbresult($hasla, 0)."</td></tr>

<tr><td class='small'>Kategori haseł:</td><td align='right' class='small'>".dbresult($cat, 0)."</td></tr>

<tr><td class='small'>W tym miesiącu:</td><td align='right' class='small'>".dbresult($dodanych, 0)."</td></tr>

<tr><td class='small' colspan='2' align='center'>Ostatnia aktualizacja:<br>".showdate("shortdate", $i_alt)."</td></tr>

<tr><td class='small' colspan='2' align='center'>Ostani dodane:<br></td></tr>";



$wynik = dbquery("SELECT * FROM ".$db_prefix."ency ORDER BY ency_datestamp DESC LIMIT 5");

if(dbrows($wynik) > 0) {    

  

while($r = dbarray($wynik))    

{



echo "<tr><td class='small' colspan='2' align='left'><img src='".THEME."images/bullet.gif' alt=''> ".$r['ency_name']."<br></td></tr>";



}

}



echo "</table>";





closeside();