<?php

function getPagesPage(){

	//get text
		$siteText = getSiteText();	

	//Dynamic client information
	$result = mysql_query('SELECT website FROM _client LIMIT 1');
	$record = mysql_fetch_assoc($result);
	$clientWebsite = $record['website'];
	if(substr($clientWebsite, 0, 7) != 'http://'){
		$clientWebsite = 'http://'.$clientWebsite;
	}
	
	
	//output
	$output = '';
	
	//submenu
	$output .= '<div id="sub-nav" class="top-rounded">';
			$output .= '<div class="sub-header-bar top-rounded">'.$siteText['libSubMenuTitle'].'</div>';
		$output .= '<div class="single-column-content column-margin-left">';
			$output .= '<ul class="ul-sub-menu">';
					
						//set page (to find active button)
						if(isset($_GET['sub'])){
							$page = $_GET['sub'];	
						}
						else{
							$result = mysql_query('SELECT name FROM _pages ORDER BY pageOrder DESC LIMIT 1');
							$record = mysql_fetch_assoc($result);
							$numPages = mysql_num_rows($result);
							if(mysql_num_rows($result)){
								$page = $record['name'];
							}
							else{
								$page = '';
							}
						}
						
						//get the rest of the pages
						$result = mysql_query('SELECT name, label FROM _pages ORDER BY pageOrder DESC');
						while($record = mysql_fetch_assoc($result)){
							
							$name = $record['name'];
							$label = $record['label'];
							
							$output .= '<li';
							if($page == $name) $output .= ' class="sub-active"'; 
							$output .= '><a href="./pages/'.$name.'/">'.$label.'</a></li>';
						
						}				
			$output .= '</ul>';
			$output .= '<ul class="ul-sub-menu">';
				$rank = getAdminRank();
						if($rank == 1){
							//Add Pages
							$output .= '<li';
							if($page == '_pages') $output .= ' class="sub-active"'; 
							$output .= '><a href="./pages/add-pages/">'.$siteText['addPages'].'</a></li>';
						}
				$output .= '<li class="visit"><a href="'.$clientWebsite.'" target="_blank" class="visit">'.$siteText['visitYourWebsite'].'</a></li>';
			$output .= '</ul>';
		$output .= '<div class="clear"></div>';
		$output .= '</div>';
		$output .= '<div class="clear"></div>';
	$output .= '</div>';
	
	$output .= '<div id="triple-column-container" class="triple-column-container top-rounded">';
	
	if(isset($_GET['sub'])){
		$page = $_GET['sub'];
		
		//content 
		if($page == 'add-pages' && $rank == 1){
			include './php/getAddPages.php';
			$output .= getAddPages();	
		}
		else{
			$result = mysql_query('SELECT name, label, custom FROM _pages ORDER BY pageOrder');
			while($record = mysql_fetch_assoc($result)){
			
				$name = $record['name'];
				$label = $record['label'];
				$custom = $record['custom'];
				
				//if match
				if($page == $name){
					if(empty($custom)){
						include './php/multipage.php';
						$output .= getMultipage($name,$label);					
					}
					else{
						$_SESSION['tmp_linkname'] = $name;
						include './php/'.$custom;
					}
				}
			}
		}
	}
	else{
		//if empty $_GET, get first page
		$result = mysql_query('SELECT name, label, custom FROM _pages ORDER BY pageOrder DESC LIMIT 1');
		$record = mysql_fetch_assoc($result);
		
		if(mysql_num_rows($result) > 0){
			$name = $record['name'];
			$label = $record['label'];
			$custom = $record['custom'];
				
			//load first page
			if(empty($custom)){
				include './php/multipage.php';
				$output .= getMultipage($name, $label);					
			}
			else{
				$_SESSION['tmp_linkname'] = $name;
				include './php/'.$custom;
			}
		}	
		else{
			$output .= $siteText['noPages'];	
		}
	}
	
	$output .= '</div>';
	$output .= '<div class="clear"></div>';

	return $output;	
}

?>