opentable("Statystyki");

echo '<table width="100%" cellspacing="4" cellpadding="0" border="0">';

echo '<tr><td align="left" valign="top" width="65%">';

$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>';

while ($row = mysql_fetch_array($result))

{

echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="readarticle.php?article_id=';

echo($row['article_id']);

echo '">';

echo($row['article_subject']);

echo '</a><br>';

}

echo '</td><td align="left" valign="top" width="35%">';

$result = dbquery("SELECT download_id, download_title, download_count, download_cat FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 10");

echo '<b>Najnowsze pliki:</b><br>';

while ($row = mysql_fetch_array($result))

{

echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="downloads.php?cat_id=';

echo($row['download_cat']);

echo '&download_id=';

echo($row['download_id']);

echo '">';

echo($row['download_title']);

echo '</a><br>';

}

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

echo '<tr><td align="left" valign="top" width="65%">';

$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>';

while ($row = mysql_fetch_array($result))

{

echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="readarticle.php?readmore=';

echo($row['article_id']);

echo '">';

echo($row['article_subject']);

echo ' (';

echo($row['article_reads']);

echo ')</a><br>';

} 

echo '</td><td align="left" valign="top" width="35%">';

$result = dbquery("SELECT download_id, download_title, download_count, download_cat FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 10");

echo '<b>Najczęściej pobierane pliki:</b><br>';

while ($row = mysql_fetch_array($result))

{

echo '<img src="'.THEME.'images/bullet.gif" alt=""> <a href="downloads.php?cat_id=';

echo($row['download_cat']);

echo '&download_id=';

echo($row['download_id']);

echo '">';

echo($row['download_title']);

echo ' (';

echo($row['download_count']);

echo ')</a><br>';

}

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

closetable();