<?php
session_start();

require_once('connect.php');
require_once('functions.php');
// Choose language & get text
$lang = getLang();
require_once '../lang/'.$lang.'Strings.php';

$output = getSmallMedia();
echo $output;



function getSmallMedia(){
	//get text
	$siteText = getSiteText();
	
	if(isset($_SESSION['media-groupLinkname'])){
		$groupId = $_SESSION['media-groupLinkname'];
	}
	else{
		$groupId = 'all';	
	}
	
	//output
	$output = '';
	
	$pageName = $_GET['page'];
	//check if medialib
	$result = mysql_query('SELECT docLib FROM _pages WHERE name = "'.$pageName.'" LIMIT 1');
	$record = mysql_fetch_assoc($result);
	$docLib = $record['docLib'];	
	
	
	//menu
	$output .= '<div class="small-lib-menu">';
		$output .= '<ul>';
			$output .= '<li onclick="checkSmallLib(\'media\',\''.$pageName.'\')">'.$siteText['libSubMenuMediaTitle'].'</li>';
			if($docLib == 1) $output .= '<li onclick="checkSmallLib(\'documents\',\''.$pageName.'\')" class="small-lib-menu-non-active">'.$siteText['libSubMenuDocTitle'].'</li>';
			$output .= '<div class="clear">';
		$output .= '</ul>';
	$output .= '</div>';
	
	//content container
 	$output .= '<div class="single-column-content column-margin-left">';
	
		//title
		$output .= '<h1>'.$siteText['libSubMenuMediaFullTitle'].'</h1>';
		//select album
		$output .= '<span class="small-lib-from-album">'.$siteText['fromGroup'].'</span>';
		$output .= '<div class="clear"></div>';
		
		//select menu
		$output .= '<form action="" id="moveToGroupForm" name="moveToGroupForm" method=post>';
			$output .= '<select name="selectToGroup" onChange="updateSessionInner(\'small-lib-con\',\'./php/smallMedia.php\',\'media-groupLinkname\',this.value);" style="width: 198px;">';
				//first option
				$output .= '<option value="all">All</option>';
				// get all media groups and groupid's
				//media groups
				$groupquery = 'SELECT DISTINCT m.id, m.title, m.linkname
							  FROM media_groups AS m, status AS s
							  WHERE s.itemId = m.id
							  AND s.active = "1"
							  ORDER BY title ASC';
				$groupresult = mysql_query($groupquery);
				while($grouprecord = mysql_fetch_assoc($groupresult)){
					$selectGroupId = $grouprecord['id'];
					$selectGroupTitle = $grouprecord['title'];
					$selectGroupLinkname = $grouprecord['linkname'];
					
					$output .= '<option value="'.$selectGroupId.'"';
						if($selectGroupId == $groupId ) $output .= ' selected ';
					$output .= '>'.$selectGroupTitle.'</option>';
				}
			$output .= '</select>';
		$output .= '</form>';
		$output .= '<div class="clear"></div>';
		
		$query = 'SELECT m.id, m.title, m.shortcode, m.type, m.path, m.thumb 
					FROM media AS m, status AS s 
					WHERE s.page="media" 
					AND s.itemId = m.id 
					AND s.active=1 
					ORDER BY m.id DESC';	
		//overwrite the query above
		if($groupId != 'all'){
			$query = 'SELECT m.id, mg.id AS groupId, m.title, m.shortcode, m.type, m.path, m.thumb 
				FROM media AS m, status AS s, media_groups AS mg, media_grouprows AS gr 
				WHERE s.page="media"
				AND s.itemId = m.id 
				AND s.active=1 
				AND mg.id = "'.$groupId.'"
				AND mg.id = gr.groupId
				AND m.id = gr.mediaId
				ORDER BY m.id DESC';
		}
						
		$result = mysql_query($query);
		$numItems = mysql_num_rows($result);
		
		//set max items
		$maxItems = 9;
		$numPages = ceil($numItems / $maxItems); 
		
		$sessionName = 'small-media-'.$groupId.'-page';
		if(isset($_SESSION[$sessionName])){ 
			$thisPage = $_SESSION[$sessionName];
		}
		else{
			$thisPage = 1;
		}
		
		$limitFrom = ($thisPage * $maxItems)-$maxItems;
		
		// get only the number of items that you want
		$selectedQuery = $query .= ' LIMIT '.$limitFrom.', '.$maxItems.';';	
		$result = mysql_query($selectedQuery);
	
		$colCount = 0;
		$count = 0;
		//thumb area
		$output .= '<div class="small-lib-thumbarea">';
			//thumb row
			$output .= '<div class="small-lib-thumbRow">';
		
			while($record = mysql_fetch_assoc($result)){
				$itemId = $record['id'];
				$title = fromDatabase($record['title']);
				$shortcode = $record['shortcode'];
				$type = $record['type'];
				
				if($type == 0){
					$thumb = '../images/uploads/thumb/'.$record['thumb'];
				}
				else if($type == 1){
					$thumb = './images/icons/vimeoSquare.jpg';
				}
				else if($type == 2){
					$thumb = '../images/soundThumb.png';
				}
				else{
					$thumb = './images/icons/youtubeSquare.jpg';
				}
		
				if(strlen($title) > 22){
					$title = substr($title,0,20).'..';	
				}
				
				if($colCount == 0 && $count != 0){
					$output .= '<div class="clear"></div>';
					$output .= '</div>';
					$output .= '<div class="small-lib-thumbRow">';
				}		
				
				$str = '';
				$str .= '<div class=\\\'small-lib-hover-img\\\'><img src=\\\''.$thumb.'\\\' alt=\\\''.inDatabase($title).'\\\' width=\\\'116\\\'/></div>';
				$str .= '<div class=\\\'small-lib-hover-title\\\'>'.inDatabase($title).'<br /><span class=\\\'med-hover-title-sc\\\'>['.$shortcode.']</span></div>';
				
				//$output .= $title.'<br />';
				$output .= '<div class="small-lib-thumb ';
					if($colCount == 2) $output .= ' no-margin-right ';
				
				//$output .= '" id="med-img-'.$itemId.'" onMouseOver="mediaOver('.$itemId.', \''.$str.'\',\'small\' );" onMouseOut="thumbDivMouseOut('.$itemId.');" ><img src="'.$thumb.'" alt="'.$title.'" width="58" onclick="checkInsert(\''.$shortcode.'\');"/></div>';
				$output .= '" id="med-img-'.$itemId.'"><img src="'.$thumb.'" alt="'.$title.'" width="58" onclick="checkInsert(\''.$shortcode.'\');"/></div>';
				
				
				/*$output .= '<div class="'.$arr[$row].'">';			
					$output .= '<img src="'.$thumb.'" class="smallMediaMiniThumb" alt="'.$title.'" />';
					$output .= '<div class="smallMediaTitle">'.$title.'</div>';
					$output .= '<a href="#" class="smallMediaInsert" onclick="checkInsert(\''.$shortcode.'\');"><img src="./images/insert.png" /></a>';
					$output .= '<a href="#" class="smallMediaId">'.$shortcode.'</a>';
				$output .= '</div>';*/
				//$output .= '<input type="button" value="insert" class="insertMedia" onclick="checkInsert(\''.$shortcode.'\');"/></div>';
				
				$colCount++;
				$count++;
				
				if($colCount == 3){
					$colCount = 0;
				}			
			}
			
			$output .= '</div>';
		$output .= '<div class="clear"></div>';
		$output .= '</div>';
		
		//page control
		if($numPages > 1){
			$output .= '<div class="small-lib-page-control-container">';
				if($thisPage != 1){ $output .= '<span class="small-lib-page-control-previous" onclick="updateSessionInner(\'small-lib-con\',\'./php/smallMedia.php?page='.$pageName.'\',\''.$sessionName.'\','.($thisPage-1).');">'.$siteText['prevPage'].'</a></span>'; }
				if($thisPage != $numPages){ $output .= '<span class="small-lib-page-control-next"  onclick="updateSessionInner(\'small-lib-con\',\'./php/smallMedia.php?page='.$pageName.'\',\''.$sessionName.'\','.($thisPage+1).');">'.$siteText['nextPage'].'</a></span>'; }
			$output .= '</div>';
		}
	$output .= '</div>';
	
	return $output;		

}

?>