Просмотр поста: Добавления нового плагина - Web Design PHP-Fusion Ukraine плагины и темы для php-fusion шаблоны сайтов форум поддержки.

"; echo "

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

"; } echo "



"; } //articles cats $result = dbquery("SELECT * FROM ".DB_PREFIX."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("(*)","articles","article_cat=".$data['article_cat_id']); echo " ".$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 ORDER BY article_name ASC"); } $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM122'].""; echo "

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

"; } echo "



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

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

"; } echo "



"; } //faq cats if (!defined("LANGUAGE")) { $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)) { if (!defined("LANGUAGE")) { $faqcats_count=dbcount("(*)","faqs","faq_cat_id=".$data['faq_cat_id']); } else { $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 " ".$data['faq_cat_name']." - [".$faqcats_count."]

"; } echo "



"; } //faqs if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_PREFIX."faqs"); } else { $result = dbquery(" SELECT * FROM ".DB_PREFIX."faqs ff INNER JOIN ".DB_PREFIX."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 " ".$data['faq_question']."

"; } echo "



"; } //downloads categories $result = dbquery("SELECT * FROM ".DB_PREFIX."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("(*)","downloads","download_cat=".$data['download_cat_id']); echo " ".$data['download_cat_name']." - [".$downloads_count." ".$locale['SM145']."]

"; } echo "



"; } //downloads files if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_PREFIX."downloads ORDER BY download_title ASC"); } else { $result = dbquery(" SELECT * FROM ".DB_PREFIX."downloads INNER JOIN ".DB_PREFIX."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 " ".$data['download_title']." - [".$locale['SM140'].": ".$data['download_count']." ".$locale['SM146']."]

"; } echo "



"; } //weblinks cats $result = dbquery("SELECT * FROM ".DB_PREFIX."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("(*)","weblinks","weblink_cat=".$data['weblink_cat_id']); echo " ".$data['weblink_cat_name']." - [".$weblinks_count." ññûëîê]

"; } echo "



"; } //weblinks if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_PREFIX."weblinks ORDER BY weblink_name ASC"); } else { $result = dbquery(" SELECT * FROM ".DB_PREFIX."weblinks INNER JOIN ".DB_PREFIX."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 " ".$data['weblink_name']." - [".$locale['SM141'].": ".$data['weblink_count']."]

"; } echo "



"; } //forums cats $result = dbquery("SELECT * FROM ".DB_PREFIX."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("(*)", "forums", "forum_cat='".$data['forum_id']."'"); echo " ".$data['forum_name']." - [".$locale['SM142'].": ".$forums_count."]

"; } echo "



"; } //forums $result = dbquery("SELECT * FROM ".DB_PREFIX."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("(*)", "threads", "forum_id='".$data['forum_id']."'"); echo " ".$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 " ".$data['poll_title']." - [".$locale['SM144'].": ".$polls_count."]

"; } echo "



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