openside("name");



echo '<table>

<tr>

<td>';

$result = dbquery("SELECT user_id, user_name FROM ".$db_prefix."users ORDER BY user_id DESC LIMIT 10");



echo '<b>Najnowsi użytkownicy:</b><br>';



               $rows = dbrows($result);



               if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.BASEDIR.'profile.php?lookup='.$row['user_id'].'">'.$row['user_name'].'</a><br>';



}



}



else {



echo 'Brak danych do wyświetlenia w statystykach'; }



echo '<hr>';





echo '</td>

<td>';

$result = dbquery("SELECT article_id, article_subject FROM ".$db_prefix."articles ORDER BY article_id DESC LIMIT 10");



echo '<b>Najnowsze artykuły:</b><br>';



               $rows = dbrows($result);



               if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.BASEDIR.'readarticle.php?article_id='.$row['article_id'].'">'.$row['article_subject'].'</a><br>';



}



}



else {



echo 'Brak danych do wyświetlenia w statystykach'; }



echo '<hr><br>';





echo '</td><td>';

$result = dbquery("SELECT article_id, article_subject, article_reads FROM ".$db_prefix."articles ORDER BY article_reads DESC LIMIT 10");



echo '<b>Najczęściej czytane artykuły:</b><br>';



               $rows = dbrows($result);



               if ($rows != 0) {



while ($row = mysql_fetch_array($result))



{



echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="'.BASEDIR.'readarticle.php?article_id='.$row['article_id'].'">'.$row['article_subject'].' ('.$row['article_reads'].')</a><br>';



}



}



else {



echo 'Brak danych do wyświetlenia w statystykach'; }



echo '<hr><br>';



echo '</td></tr></table>';



closeside();