".$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_ARTICLE_CATS." ORDER BY article_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM121'].""; echo "

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

"; } //articles { $result = dbquery(" SELECT * FROM ".DB_ARTICLES." INNER JOIN ".DB_ARTICLE_CATS." ON article_cat_id = article_cat ORDER BY article_name ASC"); } $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_CUSTOM_PAGES." 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 if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_FAQ_CATS." ORDER BY faq_cat_name ASC"); } $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM124'].""; echo "

"; while ($data = dbarray($result)) { if (!defined("LANGUAGE")) { $faqcats_count=dbcount("(*)",DB_FAQS,"faq_cat_id=".$data['faq_cat_id']); } else { $res = dbarray(dbquery(" SELECT Count(*) AS num FROM ".DB_FAQS." ff INNER JOIN ".DB_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 if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_FAQS); } else { $result = dbquery(" SELECT * FROM ".DB_FAQS." ff INNER JOIN ".DB_FAQ_CATS." fc ON fc.faq_cat_id = ff.faq_cat_id "); } $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_DOWNLOAD_CATS." ORDER BY download_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM126'].""; echo "

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

"; } //downloads files if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_DOWNLOADS." ORDER BY download_title ASC"); } else { $result = dbquery(" SELECT * FROM ".DB_DOWNLOADS." INNER JOIN ".DB_DOWNLOAD_CATS." ON download_cat_id = download_cat 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']." ".$locale['SM146']."]
"; } echo "

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

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

"; } //weblinks if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_WEBLINKS." ORDER BY weblink_name ASC"); } else { $result = dbquery(" SELECT * FROM ".DB_WEBLINKS." INNER JOIN ".DB_WEBLINK_CATS." ON weblink_cat_id=weblink_cat 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_FORUMS." WHERE 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("(*)",DB_FORUMS, "forum_cat='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM142'].": ".$forums_count."]
"; } echo "

"; } //forums $result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE 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("(*)",DB_THREADS, "forum_id='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM143'].": ".$threads_count."]
"; } echo "

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

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

"; } closetable(); require_once THEMES."templates/footer.php"; ?>