openside(""); echo ''; echo ''; echo ''; echo '

'; $result = dbquery("SELECT news_id, news_subject FROM ".$db_prefix."news ORDER BY news_id DESC LIMIT 5"); echo 'Najnowsze news`y:
'; while ($row = mysql_fetch_array($result)) { echo '

'; echo($row['news_subject']); echo '
'; } echo '

'; $result = dbquery("SELECT article_id, article_subject FROM ".$db_prefix."articles ORDER BY article_id DESC LIMIT 5"); echo 'Najnowsze artykuły:
'; while ($row = mysql_fetch_array($result)) { echo '

'; echo($row['article_subject']); echo '
'; } echo '

'; $result = dbquery("SELECT download_id, download_title, download_count, download_cat FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 5"); echo 'Najnowsze pliki:
'; while ($row = mysql_fetch_array($result)) { echo '

'; echo($row['download_title']); echo '
'; } echo '

'; echo "Ostatnio na forum:
"; $result = dbquery(" SELECT * FROM ".$db_prefix."threads INNER JOIN ".$db_prefix."forums ON ".$db_prefix."threads.forum_id=".$db_prefix."forums.forum_id WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 5 "); if (dbrows($result) != 0) { while($data = dbarray($result)) { $itemsubject = trimlink($data['thread_subject'], 23); echo "

$itemsubject
\n"; } } else { } echo '

'; closeside();