'ВАЖНАЯ ИНФОРМАЦИЯ','lock'=>'yes'), array('evt'=>'БЛИЖАЙШИЕ СОБЫТИЯ','nws'=>'ПОСЛЕДНИЕ НОВОСТИ'), array('ans'=>'АНОНС','lock'=>'yes'), array('doc'=>'ДОКУМЕНТЫ','anl'=>'АНАЛИТИКА'), array('adv'=>'РЕКЛАМА','lock'=>'yes'), array('frm'=>'ДИСКУССИЯ','gls'=>'ГЛОССАРИЙ')); $inf=''; $ans='Ожидается прием электронных платежей через систему WebMoney Transfer'; $adv=''; $count_terms_name='Всего терминов в Тематическом глоссарии'; $count_docs_name='Всего документов в базе'; $count_anl_name='Всего аналитических материалов'; $allevt_name='Весь календарь событий'; $kind_name[c]='Клубные'; $kind_name[w]='Мировые'; } else {$lnv='en'; $sectionname='SITE MAP'; $tbl_rows=array( array('inf'=>'IMPORTANT INFORMATION','lock'=>'yes'), array('evt'=>'NEAREST EVENTS','nws'=>'LATEST NEWS'), array('ans'=>'ANNOUNCEMENT','lock'=>'yes'), array('doc'=>'DOCUMENTS','anl'=>'ANALITICS'), array('adv'=>'ADVERTISING','lock'=>'yes'), array('frm'=>'DISCUSSION','gls'=>'GLOSSARY')); $inf=''; $ans=''; $adv=''; $count_terms_name='Total amount of terms in Topical Glossary'; $count_docs_name='Total amount of documents in legislation base'; $count_anl_name='Total amount of analitical materials'; $allevt_name='Calendar of events'; } $kind_gif[c]='bru'; $kind_gif[w]='gr'; $result = mysql_query("SELECT id,IF(LENGTH(${lnv}text)>200,SUBSTRING(${lnv}text,1,instr(${lnv}text,'

')-1),${lnv}text), date_format(dat,'%d.%m.%Y'),kind,date_format(dat,'%Y-%c-%e') FROM news.newsev WHERE kind IN ('ew','ec') AND ${lnv}lock='no' AND dat > NOW() ORDER BY dat LIMIT 0,3",$db); while($evt_atrib=mysql_fetch_row($result)) {$kind=($evt_atrib[3]=='ec')? 'c':'w'; $evt.=''.$kind_name[$kind].' '.$evt_atrib[2].' - '.strip_tags($evt_atrib[1]).'

';} unset ($evt_atrib); $evt.="
$allevt_name
"; $result = mysql_query("SELECT id, IF(instr(${lnv}text,'

') between 1 and 310 ,SUBSTRING(${lnv}text,1,instr(${lnv}text,'

')-1), SUBSTRING(${lnv}text,1,LOCATE(' ',${lnv}text,310)-1)),date_format(dat,'%d.%m.%Y'),kind FROM news.newsev WHERE ${lnv}lock='no' AND kind IN ('nw','nc') order by dat desc LIMIT 3",$db); while($nws_atrib=mysql_fetch_row($result)) {$kind=($nws_atrib[3]=='nc')? 'c':'w'; $nws.=''.$kind_name[$kind].' '.$nws_atrib[2].' - '.strip_tags($nws_atrib[1]).'

';} unset($nws_atrib); $result = mysql_query("SELECT razdel, fname, rubric, dname, dnamed, demit FROM docbase.${lnv}doc WHERE demit != '0000-00-00' ORDER BY dins DESC LIMIT 3",$db); while($doc_atrib=mysql_fetch_row($result)) {$doc.=''.$doc_atrib[3].' '.$doc_atrib[4].'

';} unset($doc_atrib); $result=mysql_query("SELECT count(fname) FROM docbase.${lnv}doc",$db); $count_docs=mysql_fetch_row($result); $doc.='
'.$count_docs_name.': '.$count_docs[0].'
'; $result = mysql_query("SELECT term, link FROM analit.allprojects WHERE lang='$lnv' AND type='D' ORDER BY idat DESC LIMIT 3",$db); while($anl_atrib=mysql_fetch_row($result)) {$anl.=''.$anl_atrib[0].'

';} unset($anl_atrib); $result=mysql_query("SELECT count(id_n) FROM analit.allprojects WHERE lang='$lnv' AND type='D'",$db); $count_anl=mysql_fetch_row($result); $anl.='
'.$count_anl_name.': '.$count_anl[0].'
'; $result = mysql_query("SELECT id FROM Forum.sections WHERE FIND_IN_SET('r',kind_c) ORDER BY id",$db); while($sec_id=mysql_fetch_row($result)) {$pid[]="a.pid=$sec_id[0]";} unset($sec_id); $or_condition=implode(' OR ',$pid); $result = mysql_query("SELECT a.pid, a.id, a.{$lnv}title, a.{$lnv}author, date_format(max(c.idat),'%d/%m/%Y %H:%i'), max(c.id),max(c.idat) AS fresh FROM Forum.spisok AS a LEFT JOIN Forum.titles AS b USING (id),Forum.spisok AS c WHERE ($or_condition) AND c.nleft>=a.nleft AND c.nright<=a.nright GROUP BY a.id ORDER BY fresh desc LIMIT 3",$db); while($frm_atrib=mysql_fetch_row($result)) {$frm.=''.$frm_atrib[2].' ['.$frm_atrib[4].']

';} unset($frm_atrib); $like=($lnv=='en')? 'NOT LIKE':'LIKE'; $result= mysql_query("SELECT count(id_n) FROM glossy2.gloss WHERE link $like '\_%'",$db); $count_terms=mysql_fetch_row($result); $result= mysql_query("SELECT term, link FROM glossy2.gloss WHERE link $like '\_%' ORDER BY RAND() LIMIT 1",$db); while($gls_atrib=mysql_fetch_row($result)) {$gls.="$gls_atrib[0]
";$zapros=$gls_atrib[1];} unset($gls_atrib); if (file_exists($_SERVER['DOCUMENT_ROOT']."/gloss2/$zapros.txt")) { #$fn = fopen($_SERVER['DOCUMENT_ROOT']."/gloss2/$zapros.txt", "r"); $file_str=file($_SERVER['DOCUMENT_ROOT']."/gloss2/$zapros.txt"); #$numb=0; require ("glosssary/II/inc/doc.inc"); #fclose($fn); } $gls.='
'.$file_str[2].'

'.$count_terms_name.': '.$count_terms[0].'
'; $parentinc='map';$ouwnf="map.$lnv.html"; $leftinc="miss.left"; require ($_SERVER['DOCUMENT_ROOT'].'/inc/start'); ?> ';} echo "$cols\n"; foreach ($row as $key=>$value) {echo "
   $value
\n
${$key}
\n";} echo "

\n"; unset($colspan); unset($cols); unset($divstyle);}} ?>