"; # 1 ################################# НОВОСТИ echo "\n\n"; $rsult = dbquery("SELECT news_id FROM ".$db_prefix."news");// Проверяем наличие новостей $rows1 = dbrows($rsult); // в таблице news if ($rows1!=0) { echo "

\n".$locale['MySM120']."\n"; echo "
"; echo "
"; $result = dbquery("SELECT news_cat_id, news_cat_name FROM ".$db_prefix."news_cats"); $rows = dbrows($result); echo "\n
- ".$data['news_cat_name']."
  "; $rsult = dbquery("SELECT news_subject, news_news, news_datestamp, news_id FROM ".$db_prefix."news WHERE news_cat= ".$data['news_cat_id'].""); echo "
  - ".$dt['news_subject']."
    "; } echo "
  "; } } ###################################### Категория не указанна $rsult = dbquery("SELECT news_subject, news_news, news_datestamp, news_id FROM ".$db_prefix."news WHERE news_cat= 0 "); $rows = dbrows($rsult); if ($rows!=0) { echo "
- ".$locale['MySM152'].""; echo "
  - ".$dt['news_subject']."
    "; } echo "
  ";} ############################################ echo "
"; echo "

"; echo "

\n"; } # 2 ################################# СТАТЬИ echo "\n\n"; $result = dbquery("SELECT article_cat_id, article_cat_name, article_cat_description FROM ".$db_prefix."article_cats "); $rows2 = dbrows($result); if ($rows2!=0) { echo "\n

\n".$locale['MySM121']."\n
- ".$data['article_cat_name']."
  "; if ($articles_count!=0) { echo "
  - ".$dt['article_subject']."
    "; } echo "
  "; } else { echo "
  - ".$locale['MySM140'].""; echo "
  "; } } echo "
"; echo "

"; echo "

"; } # 3 ############# FAQ echo "\n\n"; $result = dbquery("SELECT faq_cat_id, faq_cat_name, faq_cat_description FROM ".DB_PREFIX."faq_cats "); $rows3 = dbrows($result); if ($rows3!=0) { echo "

\n".$locale['MySM122']."\n
- ".$data['faq_cat_name']." - [".$faqcats_count."]
  "; if ($faqcats_count!=0) { echo "
  - ".$dat['faq_question']."
    "; } echo "
  "; } else { echo "
  - ".$locale['MySM141'].""; echo "
  "; } } echo "
"; echo "

"; echo "

"; } # 4 ################################# ФОТОАЛЬБОМ echo "\n\n"; $result = dbquery("SELECT album_id, album_title, album_description FROM ".$db_prefix."photo_albums "); $rows4 = dbrows($result); if ($rows4 !=0) { echo "

\n".$locale['MySM127']."\n
- ".$data['album_title']." - [".$photo_count."]
  "; if ($photo_count!=0) { $resul = dbquery("SELECT photo_id, photo_title, photo_datestamp, photo_description FROM ".$db_prefix."photos WHERE album_id= ".$data['album_id'].""); echo "
  - ".$dat['photo_title']."
    "; } echo "
  "; } else { echo "
  - ".$locale['MySM142']."
  "; echo "
  "; } } echo "
"; echo "

"; echo "

"; } # 5 ################################# ФОРУМЫ echo "\n\n"; $result = dbquery("SELECT forum_id, forum_name FROM ".$db_prefix."forums WHERE forum_cat=0 ORDER BY forum_order"); $rows5 = dbrows($result); if ($rows5!=0) { echo "

\n".$locale['MySM125']."\n"; echo "
- ".$data['forum_name']."
  "; if ($forums_count!=0) { $ressult = dbquery("SELECT forum_id, forum_name, forum_order, forum_description FROM ".$db_prefix."forums WHERE forum_cat=".$data['forum_id']." ORDER BY forum_order"); echo "
  "; while ($datta = dbarray($ressult)) { echo "\n\n"; echo "
  - ".$datta['forum_name']."
    "; $ret = dbquery("SELECT forum_id, thread_id, thread_subject FROM ".$db_prefix."threads WHERE forum_id=".$datta['forum_id']." order by thread_subject asc"); $rows6 = dbrows($ret); if ($rows6!=0) { echo "
    "; while ($data = dbarray($ret)) { //////////// $result = dbquery( "SELECT post_message FROM ".$db_prefix."posts LEFT JOIN ".$db_prefix."users ON ".$db_prefix."posts.post_author=".$db_prefix."users.user_id WHERE thread_id='".$data['thread_id']."' ORDER BY post_datestamp LIMIT 0,1" ); $title = mysql_result($result,0); $title = parseubb($title); $title = chop(strip_tags($title)); //////////// echo "
    "; } echo "
    "; } else { echo"
    "; } echo "
  "; } } else { echo "
  - ".$locale['MySM144']."
  "; } echo "
  "; } echo "
"; echo "

"; echo "

"; } # 6 #################################ССЫЛКИ echo "\n\n"; $result = dbquery("SELECT weblink_cat_id, weblink_cat_name, weblink_cat_description FROM ".$db_prefix."weblink_cats "); $rows6 = dbrows($result); if ($rows6!=0) { echo "

\n".$locale['MySM124']."\n"; echo "
- ".$data['weblink_cat_name']." - [".$weblinks_count."]
  "; if ($weblinks_count!=0) { echo "
  "; $rest = dbquery("SELECT weblink_id, weblink_name, weblink_count, weblink_description FROM ".$db_prefix."weblinks WHERE weblink_cat= ".$data['weblink_cat_id'].""); echo "
  - ".$dt['weblink_name']." - [".$locale['MySM131'].": ".$dt['weblink_count']."]
    "; } echo "
  "; } else { echo "
  - ".$locale['MySM145']."
  "; } echo "
  "; } echo "
"; echo "

"; echo "

"; } # 7 ################################# ФАЙЛЫ echo "\n\n"; $rst = dbquery("SELECT download_cat_id, download_cat_name, download_cat_description FROM ".$db_prefix."download_cats"); $rows7 = dbrows($rst); if ($rows7!=0) { echo "

\n".$locale['MySM123']."\n"; echo "
- ".$data['download_cat_name']." - [".$downloads_count."]
  "; if ($downloads_count!=0) { $rlt =dbquery("SELECT download_cat, download_id, download_title, download_count, download_description FROM ".$db_prefix."downloads WHERE download_cat= ".$data['download_cat_id'].""); echo "
  - ".$datt['download_title']." - [".$locale['MySM130'].": ".$datt['download_count']."]
    "; } echo "
    "; } else { echo "
    - ".$locale['MySM146']."
      
      "; } echo "
    "; } echo "
  "; echo "
"; echo "

"; } # 8 ################ АРХИВ ОПРОСОВ echo "\n\n"; $result = dbquery("SELECT poll_id, poll_title FROM ".DB_PREFIX."polls WHERE poll_ended!='0' ORDER BY poll_id DESC"); // ORDER BY poll_started DESC $rows8 = dbrows($result); if ($rows8!=0) { echo "
- \n".$locale['MySM126']." \n"; echo "
  - ".$data['poll_title']." - [".$locale['MySM134'].": ".$polls_count."]
    "; } echo "
  "; echo "
";} #################### if ($rows1==0 && $rows2==0 && $rows3==0 && $rows4==0 && $rows5==0 && $rows6==0 && $rows7==0 && $rows8==0 ) { echo '
'; echo '
'; echo $locale['MySM151']; echo ' '; echo $settings['sitename']; echo ' '; echo $locale['MySM152']; echo '

'; echo "

"; } echo "

[ ".$locale['MySM150']." ]

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