".$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." articles]
";
}
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." links]
";
}
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";
?>