".$locale['SM120']."";
echo "";
while ($data = dbarray($result)) {
echo "![bullet](".THEME."images/bullet.gif)
".$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";
?>