".$locale['SM120'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['news_subject']." - ".showdate("longdate", $data['news_datestamp'])."
"; } echo "

"; } //articles cats $result = dbquery("SELECT * FROM ".DB_PREFIX."article_cats WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM121'].""; echo "

"; while ($data = dbarray($result)) { $articles_count = dbcount("(*)","articles","article_cat=".$data['article_cat_id']); echo "bullet ".$data['article_cat_name']." - [".$articles_count."]
"; } echo "

"; } //articles $result = dbquery(" SELECT * FROM ".DB_PREFIX."articles INNER JOIN ".DB_PREFIX."article_cats ON article_cat_id = article_cat WHERE ".groupaccess('article_cat_access')." ORDER BY article_datestamp DESC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM122'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['article_subject']." - ".showdate("longdate", $data['article_datestamp'])."
"; } echo "

"; } //custom pages $result = dbquery("SELECT * FROM ".DB_PREFIX."custom_pages WHERE ".groupaccess('page_access')." ORDER BY page_title ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM123'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['page_title']."
"; } echo "

"; } //faq cats $result = dbquery("SELECT * FROM ".DB_PREFIX."faq_cats ORDER BY faq_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM124'].""; echo "

"; while ($data = dbarray($result)) { $res = dbarray(dbquery(" SELECT Count(*) AS num FROM ".DB_PREFIX."faqs ff INNER JOIN ".DB_PREFIX."faq_cats fc ON fc.faq_cat_id = ff.faq_cat_id WHERE ff.faq_cat_id='".$data['faq_cat_id']."'")); $faqcats_count = $res['num']; echo "bullet ".$data['faq_cat_name']." - [".$faqcats_count."]
"; } echo "

"; } //faqs $result = dbquery(" SELECT * FROM ".DB_PREFIX."faqs"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM125'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['faq_question']."
"; } echo "

"; } //downloads categories $result = dbquery("SELECT * FROM ".DB_PREFIX."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM126'].""; echo "

"; while ($data = dbarray($result)) { $downloads_count = dbcount("(*)","downloads","download_cat=".$data['download_cat_id']); echo "bullet ".$data['download_cat_name']." - [".$downloads_count."]
"; } echo "

"; } //downloads files $result = dbquery(" SELECT * FROM ".DB_PREFIX."downloads INNER JOIN ".DB_PREFIX."download_cats ON download_cat_id = download_cat WHERE ".groupaccess('download_cat_access')." ORDER BY download_title ASC "); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM127'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['download_title']." - [".$locale['SM140'].": ".$data['download_count']."]
"; } echo "

"; } //weblinks cats $result = dbquery("SELECT * FROM ".DB_PREFIX."weblink_cats WHERE ".groupaccess('weblink_cat_access')." ORDER BY weblink_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM128'].""; echo "

"; while ($data = dbarray($result)) { $weblinks_count = dbcount("(*)","weblinks","weblink_cat=".$data['weblink_cat_id']); echo "bullet ".$data['weblink_cat_name']." - [".$weblinks_count."]
"; } echo "

"; } //weblinks $result = dbquery(" SELECT * FROM ".DB_PREFIX."weblinks INNER JOIN ".DB_PREFIX."weblink_cats ON weblink_cat_id=weblink_cat WHERE ".groupaccess('weblink_cat_access')." ORDER BY weblink_name ASC "); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM129'].""; echo "

"; while ($data = dbarray($result)) { echo "bullet ".$data['weblink_name']." - [".$locale['SM141'].": ".$data['weblink_count']."]
"; } echo "

"; } //forums cats $result = dbquery("SELECT * FROM ".DB_PREFIX."forums WHERE ".groupaccess('forum_access')." AND forum_cat=0 ORDER BY forum_order ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM130'].""; echo "

"; while ($data = dbarray($result)) { $forums_count = dbcount("(*)", "forums", "forum_cat='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM142'].": ".$forums_count."]
"; } echo "

"; } //forums $result = dbquery("SELECT * FROM ".DB_PREFIX."forums WHERE ".groupaccess('forum_access')." AND forum_cat!=0 ORDER BY forum_order ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM131'].""; echo "

"; while ($data = dbarray($result)) { $threads_count = dbcount("(*)", "threads", "forum_id='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM143'].": ".$threads_count."]
"; } echo "

"; } //polls $result = dbquery("SELECT * FROM ".DB_PREFIX."polls ORDER BY poll_started DESC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM132'].""; echo "

"; while ($data = dbarray($result)) { $polls_count = dbcount("(*)","poll_votes","poll_id=".$data['poll_id']); echo "bullet ".$data['poll_title']." - [".$locale['SM144'].": ".$polls_count."]
"; } echo "

"; } closetable(); include BASEDIR."side_right.php"; include BASEDIR."footer.php"; ?>