<?php
class md{

	var $prefix = DB_PREFIX;
	
	public function __construct($registry) {
		$this->db = $registry->get('db');
	}

	public function page($q) {
  		$query = $this->db->query("SELECT c.*,t.static_file 
  		FROM ".$this->prefix."site_content c 
  		JOIN ".$this->prefix."site_templates t
  		ON t.id=c.template
  		WHERE alias='$q'");
			
		return $query->row;
  	}  

	public function nav($menu,$ul='top',$q='',$parent='') {  	
		
		!empty($parent) ?
		$query_string="AND c.id=(SELECT parent FROM ".$this->prefix."site_content WHERE alias='$parent')":
		$query_string='';
	
		$nav = $this->db->query("
		SELECT pagetitle,c.id,alias,isfolder ,menutitle
		FROM ".$this->prefix."site_content c
		WHERE parent=0
		AND hidemenu=0
		AND published=1
		AND id_menu='$menu'
		$query_string
		ORDER BY menuindex
		");
		//return $nav;
	
		echo '<ul class="'.$ul.'">';
		foreach($nav->rows as $link){
			$id = $link['id'];
			$q == $link['alias'] ?
			$class = ' class="active"':
			$class = '';

			echo '<li'.$class.'>';
			if($link['isfolder'] < 1){ 
				echo '<a href="'.$link['alias'].'">'.utf8_encode($link['menutitle']).'</a>';
			}
			else{
				echo '<span>'.$link['pagetitle'].'</span>';	
			}
			$subs=$this->db->query
			("SELECT menutitle,alias FROM ".$this->prefix."site_content
				WHERE parent='$id'
				AND hidemenu=0
				AND published=1
				ORDER BY menuindex
			");
			if($subs->num_rows > 0){
				echo '<ul>';
				foreach($subs->rows as $sub){
					echo '<li><a href="'.$sub['alias'].'">'.$sub['menutitle'].'</a></li>';
				}
				echo '</ul>';	
			}
			echo '</li>';
		}
		echo '</ul>';
	}

	function listPeople($id=''){
		$query = $this->db->query
			("SELECT name,firstname,alias,image,email,resume FROM md_aboutlist WHERE status =1");

			return $query;

	}
	 function getNoticias(){
	 	$query = $this->db->query
	 		("SELECT post_id,post_title,post_content,post_image,post_date
	 			FROM ".$this->prefix."posts WHERE published = 1 AND is_active=1 ORDER BY post_id DESC");
	 	return $query;	
	 }
	
}