/*---------------------------------------------------+ | PHP-Fusion 6 Content Management System +----------------------------------------------------+ | Copyright © 2002 - 2005 Nick Jones | http://www.php-fusion.co.uk/ +----------------------------------------------------+ | Released under the terms & conditions of v2 of the | GNU General Public License. For details refer to | the included gpl.txt file or visit http://gnu.org +---------------------------------------------------- | Site Map Panel v1.0 | by Wooya | http://wooya.mac.aplus.pl +---------------------------------------------------- | Tested with PHP-Fusion v6 and mFusion v6 (1.0) +----------------------------------------------------*/ require_once "../../maincore.php"; require_once BASEDIR."subheader.php"; require_once BASEDIR."side_left.php"; // Check if locale file is available matching the current site locale setting. if (file_exists(INFUSIONS."site_map/locale/".$settings['locale'].".php")) { // Load the locale file matching the current site locale setting. include INFUSIONS."site_map/locale/".$settings['locale'].".php"; } else { // Load the infusion's default locale file. include INFUSIONS."site_map/locale/English.php"; } opentable($locale['SM100'].": ".$settings['sitename']); //news $result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE ".groupaccess('news_visibility')." ORDER BY news_datestamp DESC"); $rows = dbrows($result); if ($rows!=0) { echo "".$locale['SM120'].""; echo "
";
while ($data = dbarray($result)) {
echo " ".$data['news_subject']." - ".showdate("longdate", $data['news_datestamp'])."
";
}
echo "
";
while ($data = dbarray($result)) {
$articles_count = dbcount("(*)","articles","article_cat=".$data['article_cat_id']);
echo " ".$data['article_cat_name']." - [".$articles_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
echo " ".$data['article_subject']." - ".showdate("longdate", $data['article_datestamp'])."
";
}
echo "
";
while ($data = dbarray($result)) {
echo " ".$data['page_title']."
";
}
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 " ".$data['faq_cat_name']." - [".$faqcats_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
echo " ".$data['faq_question']."
";
}
echo "
";
while ($data = dbarray($result)) {
$downloads_count = dbcount("(*)","downloads","download_cat=".$data['download_cat_id']);
echo " ".$data['download_cat_name']." - [".$downloads_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
echo " ".$data['download_title']." - [".$locale['SM140'].": ".$data['download_count']."]
";
}
echo "
";
while ($data = dbarray($result)) {
$weblinks_count = dbcount("(*)","weblinks","weblink_cat=".$data['weblink_cat_id']);
echo " ".$data['weblink_cat_name']." - [".$weblinks_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
echo " ".$data['weblink_name']." - [".$locale['SM141'].": ".$data['weblink_count']."]
";
}
echo "
";
while ($data = dbarray($result)) {
$forums_count = dbcount("(*)", "forums", "forum_cat='".$data['forum_id']."'");
echo " ".$data['forum_name']." - [".$locale['SM142'].": ".$forums_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
$threads_count = dbcount("(*)", "threads", "forum_id='".$data['forum_id']."'");
echo " ".$data['forum_name']." - [".$locale['SM143'].": ".$threads_count."]
";
}
echo "
";
while ($data = dbarray($result)) {
$polls_count = dbcount("(*)","poll_votes","poll_id=".$data['poll_id']);
echo " ".$data['poll_title']." - [".$locale['SM144'].": ".$polls_count."]
";
}
echo "