db = sdb::getInstance(); $this->lang = $lang; } public function view($id){ return $this->db->getRow("select *,name_{$this->lang} as name,title_{$this->lang} as title,description_{$this->lang} as description,keywords_{$this->lang} as keywords,about_{$this->lang} as about from menu where id=?",array($id),DB_FETCHMODE_ASSOC); } public function view_params($param1,$value = null){ /* $rt = explode("/" ,$rt); $rt = array_slice($rt, $offset,$length); print $params = implode("/",$rt); if($params) $params .= "/"; */ $params = ($value != null) ? $param1 . '/' . $value . '/' : (($param1 != null) ? $param1 . '/' : $param1); //$params = sprintf("%s/%s/",$param1,$value); return $this->db->getRow("select *,name_{$this->lang} as name,title_{$this->lang} as title,description_{$this->lang} as description,keywords_{$this->lang} as keywords,about_{$this->lang} as about from menu where params=?",array($params),DB_FETCHMODE_ASSOC); } public function getMenuUL($url,$id = 0,&$menu = ''){ // global $menu; $q=$this->db->query("select *,name_{$this->lang} as name from menu where parent_id=? and is_menu=1 order by sort asc",array($id)); if(!$q->numRows()) return; $menu.= "\n"; return $menu; } public function addULBrends(){ $out = "\n"; return $out; } public function addULRubrics($brend_id){ $out = "\n"; return $out; } public function getMenuBottomUL($url,$id = 0,&$menu = ''){ // global $menu; $q=$this->db->query("select *,name_{$this->lang} as name from menu where parent_id=? and is_menu_bottom=1 order by sort asc",array($id)); if(!$q->numRows()) return; $menu.= "\n"; return $menu; } } ?>