assign('LANG', $lang);
$options=getArray('* FROM options', ''); //print_r($options);
$ADMIN_EMAIL = $options[1]['value']; //echo $options[1]['value'];
$TO_EMAIL = $options[1]['value'];
//$tpl->assign('ADDRESS_FIRM',$options[0]['value']);
/**
* Navigation system
*/
$a=getArray("* FROM tree", "WHERE pid=0 AND id<>1 AND visible<>0 ORDER BY sortorder");
$allprev=getPrev("* FROM tree", $id, 0);
foreach($a as $k => $v){
$tpl->assign('NAME', $v["name_$lang"]);
(!empty($v['url']) ? $tpl->assign('REF', $v['url']) : $tpl->assign('REF', "?lang=$lang&id={$v['id']}"));
if(!empty($v["name_$lang"])){
$tpl->parse('MAIN.MENU.MENU_ROW');
}
if($a1=getArray("* FROM tree", $w="WHERE pid={$v['id']} ORDER BY sortorder")){
//if($is_active)
foreach($a1 as $k1 => $v1){
$is_active1 = (($v1['id'] == $id)||(in_array($v1['id'], $allprev)));
$tpl->assign('NAME', $v1["name_$lang"]);
$tpl->assign('REF', "/?lang=$lang&id={$v1['id']}");
$tpl->parse('MAIN.MENU.SUB.'.($is_active1 ? 'ACTIVE' : 'NORMAL'));
} $tpl->parse('MAIN.MENU.SUB');
}
$tpl->parse('MAIN.MENU.EMPTY');
$tpl->parse('MAIN.MENU');
}
/**
* News on main
*/
$a=getArray("*, DATE_FORMAT(date, '%d-%m-%Y') AS adate FROM news", "ORDER BY date desc LIMIT 2");
if(!empty($a)) foreach($a as $k => $v){
$tpl->assign('NAME', $v["name_$lang"]);
$tpl->assign('DATE', $v['adate']);
$tpl->assign('ANON', $v["annonce_$lang"]);
(!empty($v['download_pic'])) ? ($tpl->assign('PIC', "![\"{$v['name']}\"](\"/{$v['download_pic']}\")
")) : ($tpl->assign('PIC', ' '));
$tpl->assign('REF', "/?id=7&id_news={$v['id']}&lang=$lang");
$tpl->parse('MAIN.ALLNEWS');
}
/**
* Module selection
*/
switch($id){
case 7: //Main page
//break;
default:
$a=getArray("* FROM tree", "WHERE id=$id");
if(!empty($a)) foreach($a as $k => $v){
if(file_exists($v['plugin'])) {
include ($v['plugin']);
}
$tpl->assign('TITLE', $v["name_$lang"]);
$tpl->assign('DESCRIPTION', $v['description']);
$tpl->assign('KEYWORDS', $v['keywords']);
$tpl->assign('BODY', $v["content_$lang"].$plugin_echo);
}
}
// Sape
/*if (!defined('_SAPE_USER')) {
define('_SAPE_USER', '66b40c9fc60bbbc99e8ccbfe3bb1f03f');
}
if(file_exists($_SERVER['DOCUMENT_ROOT'].'/'._SAPE_USER.'/sape.php')) {
require_once($_SERVER['DOCUMENT_ROOT'].'/'._SAPE_USER.'/sape.php');
$options = array();
$options['verbose'] = false;
$options['charset'] = 'WINDOWS-1251';
$options['force_show_code'] = false;
$options['debug'] = false;
$options['host'] = $_SERVER['SERVER_NAME'];
$options['fetch_remote_type'] = 'socket';
$sape = new SAPE_client($options);
$sapelinks = $sape->return_links();
if(!empty($sapelinks)) {
$style1='margin:10px; font-size:10px; color:#5e5e5e; float:left;';
$style2='text-decoration:none; font-size:10px; color:#5e5e5e;';
$sapelinks=''.$sapelinks.'
';
} else {
$sapelinks='';
}
$tpl->assign('SAPE', $sapelinks);
} else {
$tpl->assign('SAPE', '');
}*/
$tpl->parsemain();
$tpl->out('MAIN');
function getArray($q='', $w=''){
$result=mysql_query("SELECT $q $w"); //echo "SELECT $q $w";
while ($a = @mysql_fetch_array($result, MYSQL_ASSOC)) {
$ret[] = $a;
}
return $ret;
}
function getItem($q='', $w=''){
$result=mysql_query("SELECT $q $w"); //echo "SELECT $q $w";
$ret = mysql_fetch_array($result, MYSQL_ASSOC);
return $ret;
}
/**
* tree methods
*/
function getPrev($q, $tid, $rootid, $linkName = "pid") {
global $ret;
if(!isset($ret)) $ret=array();
$tid = intval($tid);
$a=getItem($q, "WHERE id=$tid");
$ret[]=$a['id'];
if($a['pid']!=$rootid){
getPrev($q, $a['pid'], $rootid);
}
return $ret;
}
function delspecialchars($str){
//убрать все дополнительные символы (кавычки, скобки, плюсы, запятые, тире... вроде других пока не встречал)
$symbols = array("\"", "'", "(", ")", "+", ",", "-", "\\", "/", "|", ">", "<", "$", "%", "#", "*");
$str = str_replace($symbols, " ", $str);
//А этот код заменяет не только пробелы, но и невидимые символы, перводы сторок, признак конца файла и пр.
$str = trim($str);
$str = preg_replace('|[\s]+|',' ',$str);
return $str;
}
function ShowTree($ParentID, $lvl) {
global $lvl;
$lvl++;
$sql="SELECT * FROM tree WHERE pid=".$ParentID;
mysql_query($sql);
$result=mysql_query($sql);
if (mysql_num_rows($result) > 0) {
echo("");
while ( $row = mysql_fetch_array($result) ) {
$id1 = $row["id"];
echo("- ");
echo "".$row["name"]."\n";
ShowTree($id1, $lvl);
$lvl--;
}
echo("
");
}
}
?>