<?php
class submenu extends ACore {
	
	public function get_content() {
		global $mysqli;
	
		echo '<div id="main">';
		
		if(!$_GET['id_submenu']) {
			echo 'Incorrect menu data';
		}
		else {
			$id_submenu = (int)$_GET['id_submenu'];
			if(!$id_submenu) {
				echo 'Incorrect menu data';
			}
			else {
				$query = "SELECT id_submenu,submenu_name,submenu_content,content_title,project_id FROM submenu WHERE id_submenu='$id_submenu'";
				$result = $mysqli->query($query);
				if(!$result) {
					exit($mysqli->error);
				}
				$row = $result->fetch_assoc();
				
				$proj_id = $row['project_id'];
				
				$row1 = $this->gallery_array($proj_id);

				echo '			<div id="container">
								<div id="content" role="main">
								<div id="post-467" class="post-467 page type-page status-publish hentry">';
				printf('<h1 align="center" class="entry-title-home">%s</h1>',$row['content_title']);
				echo '					<div class="entry-content-home">';
				if($row['submenu_content']) printf("%s",$row['submenu_content']);
				if($row1) {
					echo '<!-- see gallery_shortcode() in wp-includes/media.php -->';
					if ($proj_id == 6) echo '<div id="gallery-1" class="gallery galleryid-467 gallery-columns-1 gallery-size-thumbnail">';
					else echo '<div id="gallery-1" class="gallery galleryid-467 gallery-columns-3 gallery-size-thumbnail">';
					foreach($row1 as $item1) {
						if ($item1['img_thumb_width']==0) $width = 150;
						else $width = $item1['img_thumb_width'];
						if ($item1['img_thumb_height']==0) $height = 150;
						else $height=$item1['img_thumb_height'];
						if ($proj_id == 6 || $proj_id == 21) {
							printf("<dl class='gallery-item'><dt class='gallery-icon'>
						<a title='%s' href='%s' rel='prettyPhoto[%s]'>
						<img class='attachment-thumbnail' src='%s' width='600' height='170' style='border: 0;'>
						</a></dt><dd class='wp-caption-text gallery-caption' style='margin-top: -10px;margin-bottom: 18px;'>%s</dd></dl>
						",$item1['img_title'],$item1['img_src'],$proj_id,$item1['img_thumb_src'],$item1['img_cap']);
						} 
						else {
						printf("<dl class='gallery-item'><dt class='gallery-icon'>
						<a title='%s' href='%s' rel='prettyPhoto[%s]'>
						",$item1['img_title'],$item1['img_src'],$proj_id);
						if ($width >= 600) printf("<img class='attachment-thumbnail' src='%s' width='%s' height='%s' style='border: 0;'>
						",$item1['img_thumb_src'],$width,$height);
						else printf("<img class='attachment-thumbnail' src='%s' width='%s' height='%s'>
						",$item1['img_thumb_src'],$width,$height);
						printf("</a></dt><dd class='wp-caption-text gallery-caption' style='margin-top: -10px;margin-bottom: 18px;'>%s</dd></dl>
						",$item1['img_cap']);
						}
						if ($proj_id == 6 || $proj_id == 21) echo '<BR style="CLEAR: both">';
						if ($width >= 600) echo '<BR style="CLEAR: both">';
					}
					echo '<BR style="CLEAR: both"><!-- end gal -->
					</div>
					';
				}
				echo '					</div><!-- .entry-content -->
</div><!-- #post-## -->
</div><!-- #content -->
</div><!-- #container -->
					';
			}
		}
	}
	
	protected function gallery_array($project_id) {
		global $mysqli;
	
		$query = "SELECT id_gal,img_src,img_thumb_src,img_cap,img_title,img_thumb_width,img_thumb_height FROM gallery WHERE project_id='$project_id'";
		
		$result = $mysqli->query($query);
		if(!$result) {
			exit($mysqli->error);
		}
		
		$row = array();
		
		for($i = 0;$i < mysqli_num_rows($result); $i++) {
			$row[] = $result->fetch_assoc();
		}
		return $row;
	}
	
}
?>