<?php

	
require_once '../../admin/php/connect.php';
require_once '../../admin/php/functions.php';


$linkname = $_GET['linkname'];
$albumOrder = $_GET['albumOrder'];
$numAlbums = $_GET['numAlbums'];
$key = $_GET['key'];

//start output
$output = '';

//get albumId
$query = 'SELECT id, title
			FROM '.$linkname.'_albums
			WHERE albumOrder = '.$albumOrder.'
			LIMIT 1';
$result = mysql_query($query);
$record = mysql_fetch_assoc($result);
$albumId = $record['id'];
$title = fromDatabase($record['title']);

//get info from database
$photoQuery = 'SELECT DISTINCT id, thumb, filename
			FROM '.$linkname.'_photos
			WHERE albumId = '.$albumId.'
			ORDER by photoOrder DESC ';
$photoResult = mysql_query($photoQuery);
$numPhotos = mysql_num_rows($photoResult);

//set max items
$maxPhotos = 9;
$numPages = ceil($numPhotos / $maxPhotos); 
if($numPages == 0) $numPages = 1;
$thisPage = 1;

//header
$output .= '<div class="spBar">';
	$output .= '<h2 class="floatLeft">'.strtolower($title).'</h1>';
	//$output .= '<span class="projectCount floatRight">1 / 3</span>';
	$output .= '<div class="clear"></div>';
$output .= '</div>';

//rows			
$output .= '<div class="spContent">';
$output .= '<div class="spColumnHolder">';
$output .= '<div class="spColumn">';
$output .= '<div class="spThumbRow">';

$bigColCount = 0;
$colCount = 0;
$photoCount = 0;

while($photoRecord = mysql_fetch_assoc($photoResult)){
	$photoId = $photoRecord['id'];
	$thumb = './images/'.$linkname.'/'.$albumId.'/thumb/'.$photoRecord['thumb'];
	$filename = './images/'.$linkname.'/'.$albumId.'/'.$photoRecord['filename'];
	
	if($bigColCount == 0 && $photoCount != 0){		
		//end row
		$output .= '<div class="clear"></div>';
		$output .= '</div>';
		//end column
		$output .= '<div class="clear"></div>';
		$output .= '</div>';
		//new column
		$output .= '<div class="spColumn">';
		//new row
		$output .= '<div class="spThumbRow">';
	}
	else if($colCount == 0 && $photoCount != 0){
		$output .= '<div class="clear"></div>';
		$output .= '</div>';
		$output .= '<div class="spThumbRow">';
	}
	
	$output .= '<div class="spThumb';
	if($colCount == 2)$output .= ' noMargin';
	$output .= '"><a href="'.$filename.'" class="shadowbox" rel="shadowbox['.$linkname.'-'.$albumId.']" title="Smulders Interieur Heeze"><img src="'.$thumb.'" alt="" height="100"/></a></div>';
				
	$colCount++;
	$bigColCount++;
	$photoCount++;
	
	if($colCount == 3){
		$colCount = 0;
	}	
	
	if($bigColCount == 9){
		$bigColCount = 0;
	}			
}
//end row
$output .= '<div class="clear"></div>';
$output .= '</div>';
//end column
$output .= '<div class="clear"></div>';
$output .= '</div>';
//end columnHolder
$output .= '<div class="clear"></div>';
$output .= '</div>';
//end content
$output .= '</div>';
//pagecontrol
$output .= '<div class="spBar spFooterBar">';
				//$output .= '<span class="floatLeft link"  onClick="smallAlbumNextPage(\'sp4\',\'prev\')"><img src="./images/structure/arrowSmallLeft.png" alt="Smulders Interieur Heeze - vorige project" class="barArrow"/> <span class="adjustKerningV">V</span>orige foto&rsquo;s</span>';
				if($numPages > 1) $output .= '<span class="floatRight link" onClick="smallAlbumNextPage(\''.$linkname.'\','.$key.','.$numPages.','.($thisPage+1).',\'next\');" >Meer foto&rsquo;s <img src="./images/structure/arrowSmallRight.png" alt="Smulders Interieur Heeze - vorige project" class="barArrow"/></span>';
			$output .= '</div>';	

echo $output;
	

?>