"; //print_r($fusion_images)."
"; //echo get_image("bullet", "test alt", "vertical-align:middle", "Test Title"); //news $i=0; $result = dbquery("SELECT * FROM ".DB_NEWS." WHERE news_draft=0 ORDER BY news_datestamp DESC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM120'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo " bullet ".$data['news_subject']." - ".showdate("longdate", $data['news_datestamp'])."\n"; echo "
\n"; closetable(); } //articles cats $i=0; $result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS." WHERE ".groupaccess("article_cat_access")." ORDER BY article_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM121'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; $articles_count = dbcount("(*)",DB_ARTICLES,"article_cat=".$data['article_cat_id']); echo " bullet ".$data['article_cat_name']." - [".$locale['SM148'].": ".$articles_count."]\n"; echo "
\n"; closetable(); } //articles $i=0; { $result = dbquery(" SELECT * FROM ".DB_ARTICLES." INNER JOIN ".DB_ARTICLE_CATS." ON article_cat_id = article_cat WHERE ".groupaccess("article_cat_access")." AND article_draft=0 ORDER BY article_name ASC"); } $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM122'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo " bullet ".$data['article_subject']." - ".showdate("longdate", $data['article_datestamp'])."\n"; echo "
\n"; closetable(); } //custom pages $i=0; $result = dbquery("SELECT * FROM ".DB_CUSTOM_PAGES." WHERE ".groupaccess("page_access")." ORDER BY page_title ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM123'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo " bullet ".$data['page_title']."\n"; echo "
\n"; closetable(); } //faq cats $i=0; if (!defined("LANGUAGE")) { $result = dbquery("SELECT * FROM ".DB_FAQ_CATS." ORDER BY faq_cat_name ASC"); } $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM124'].""); echo "\n\n"; 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 " \n \n \n"; $i++; } echo "
\n"; echo " bullet ".$data['faq_cat_name']." - [".$faqcats_count."]\n"; echo "
\n"; closetable(); } //faqs $i=0; 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) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM125'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo " bullet ".$data['faq_question']."\n"; echo "
\n"; closetable(); } /* //downloads categories PDP $result = dbquery("SELECT * FROM ".DB_INFUSIONS." WHERE inf_folder='pro_download_panel'"); $rows = dbrows($result); if ($rows!=0) { if (!defined("DB_PDP_CATS")) { define("DB_PDP_CATS", DB_PREFIX."pdp_cats"); } if (!defined("DB_PDP_DOWNLOADS")) { define("DB_PDP_DOWNLOADS", DB_PREFIX."pdp_downloads"); } if (!defined("DB_PDP_FILES")) { define("DB_PDP_FILES", DB_PREFIX."pdp_files"); } //downloads categories PDP function getcats($parentid, $title) { global $data; $result=dbquery("select * from ".DB_PDP_CATS." where cat_id=$parentid"); $data = dbarray($result); if ($data['cat_name']!="") { $title = $data['cat_name']." / ".$title; } if ($data['top_cat']!=0) { $title = getcats($data['top_cat'], $title); } return $title; } $i=0; $result = dbquery("SELECT * FROM ".DB_PDP_CATS." WHERE ".groupaccess("cat_access")." ORDER BY cat_order, cat_id, cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM126'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo "bullet "; echo "".getcats($data['top_cat'], "".$data['cat_name']."")."\n"; echo "
\n"; closetable(); } function getdlcats($parentid, $title, $dl_id, $dl_name, $dl_count, $lang1, $lang2, $file_ver) { global $data; $result=dbquery("select * from ".DB_PDP_CATS." where cat_id=$parentid"); $data = dbarray($result); if ($data['cat_name']!="") { if ($file_ver!=""){ $title = $data['cat_name']." / ".$title." / ".$dl_name. " ".$file_ver; }else{ $title = $data['cat_name']." / ".$title." / ".$dl_name; } }else{ if ($file_ver!=""){ $title = $title." / ".$dl_name. " ".$file_ver; }else{ $title = $title." / ".$dl_name; } } if ($data['top_cat']!=0) { $title = getcats($data['top_cat'], $title); } $title1 = "bullet "; $title2 = " - [".$lang1.": ".$dl_count." ".$lang2."]\n"; return $title1.$title.$title2; } //downloads files PDP $i=0; $result = dbquery(" SELECT td.*, tc.*, tf.* FROM ".DB_PDP_DOWNLOADS." td INNER JOIN ".DB_PDP_CATS." tc ON tc.cat_id = td.cat_id LEFT JOIN ".DB_PDP_FILES." tf ON tf.download_id = td.download_id WHERE ".groupaccess("cat_access")." ORDER BY cat_order, dl_name ASC, file_version DESC "); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM127'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo getdlcats($data['top_cat'],"".$data['cat_name']."",$data['download_id'],"".$data['dl_name']."",$data['download_count'],"".$locale['SM140']."","".$locale['SM146']."","".$data['file_version'].""); echo "
\n"; closetable(); } }else{ */ //downloads categories $i=0; $result = dbquery("SELECT * FROM ".DB_DOWNLOAD_CATS." WHERE ".groupaccess("download_cat_access")." ORDER BY download_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM126'].""); echo "\n\n"; while ($data = dbarray($result)) { $downloads_count = dbcount("(*)",DB_DOWNLOADS,"download_cat=".$data['download_cat_id']); echo " \n \n \n"; $i++; } echo "
\n"; echo "bullet ".$data['download_cat_name']." - [".$downloads_count." ".$locale['SM145']."]\n"; echo "
\n"; closetable(); } /* //downloads files $i=0; 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 WHERE ".groupaccess("download_cat_access")." ORDER BY download_title ASC "); } $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM127'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo "bullet ".$data['download_title']." - [".$locale['SM140'].": ".$data['download_count']." ".$locale['SM146']."]\n"; echo "
\n"; closetable(); } } */ //weblinks cats $i=0; $result = dbquery("SELECT * FROM ".DB_WEBLINK_CATS." WHERE ".groupaccess("weblink_cat_access")." ORDER BY weblink_cat_name ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM128'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; $weblinks_count = dbcount("(*)",DB_WEBLINKS,"weblink_cat=".$data['weblink_cat_id']); echo "bullet ".$data['weblink_cat_name']." - [".$locale['SM147'].": ".$weblinks_count."]\n"; echo "
\n"; closetable(); } //weblinks $i=0; 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 WHERE ".groupaccess("weblink_cat_access")." ORDER BY weblink_name ASC "); } $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM129'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; echo "bullet ".$data['weblink_name']." - [".$locale['SM141'].": ".$data['weblink_count']."]\n"; echo "
\n"; closetable(); } //forums cats $i=0; $result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE ".groupaccess("forum_access")." AND forum_cat=0 ORDER BY forum_order ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM130'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; $forums_count = dbcount("(*)",DB_FORUMS, "forum_cat='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM142'].": ".$forums_count."]\n"; echo "
\n"; closetable(); } //forums $i=0; $result = dbquery("SELECT * FROM ".DB_FORUMS." WHERE ".groupaccess("forum_access")." AND forum_cat!=0 ORDER BY forum_order ASC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM131'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; $threads_count = dbcount("(*)",DB_THREADS, "forum_id='".$data['forum_id']."'"); echo "bullet ".$data['forum_name']." - [".$locale['SM143'].": ".$threads_count."]
"; echo "
\n"; closetable(); } //polls $i=0; $result = dbquery("SELECT * FROM ".DB_POLLS." ORDER BY poll_started DESC"); $rows = dbrows($result); if ($rows!=0) { opentable($locale['SM100'].": ".$settings['sitename']." / ".$locale['SM132'].""); echo "\n\n"; while ($data = dbarray($result)) { echo " \n \n \n"; $i++; } echo "
\n"; $polls_count = dbcount("(*)",DB_POLL_VOTES,"poll_id=".$data['poll_id']); echo "bullet ".$data['poll_title']." - [".$locale['SM144'].": ".$polls_count."]
"; echo "
\n"; closetable(); } require_once THEMES."templates/footer.php"; ?>