Nytt galleri

<?php

	// ************ Skapa variabler
	$username = "xxx";
	$password = "xxx";
	$database = "xxx";
	
	// ************ Kontakta DB-server
	$db = mysql_connect("localhost",$username, $password) or die ("Unable to connect to database");
	
	// ************ Välj databas	
	mysql_select_db($database, $db) or die ("Unable to select database");
	
	
	if(isset($_GET['image']))
	{
		$imageid = intval($_GET['image']);
	}
	
	if(!isset($_GET['image']))
	{
		if(isset($_GET['album']))
		{
			$album = intval($_GET['album']);
		}
		else
		{
			$album = 0;
		}
	}
	if(!isset($_GET['page']))
	{
		$page = 1;
	}
	else
	{
		$page = intval($_GET['page']);
	}
	
	// ***** Kolla vilken sida länken kom från
	if(isset($_GET['ppage']))
	{
		$parent_page = intval($_GET['ppage']);
	}
	else
	{
		$parent_page = 1;
	}
	
	// ************ Hämta info om galleriet
	$query = mysql_query("SELECT * FROM tblgallery", $db);
	$myRow = mysql_fetch_array($query);
	$numRows = $myRow[4];
	$numCols = $myRow[5];
	$gallery_name = $myRow[0];
	$picpath = $myRow[2];
	$last_update = $myRow[1];
	$uploadpath = $myRow[3];
	$total_obj = $numRows * $numCols;
	
	$nextpage = $page + 1;
	$prevpage = $page - 1;

	if($page > 0)
	{
		$page = $page - 1;
	}
	else
	{
		$page = 0;
	}
	
	if($prevpage < 0)
	{
		$prevpage = 0;
	}
	
	// ************ Hämta album
	if(!isset($imageid))
	{
		// ************ Hämta Refid för albumet
		$query = mysql_query("SELECT refid,name FROM tblObjects WHERE id = " . $album, $db);
		$myRow = mysql_fetch_row($query);
		$refid = $myRow[0];
		$albumname = $myRow[1];
		if(!isset($albumname))
		{
			$albumname = $gallery_name;
		}
		
		// ************ Hämta innehållet i albumet
		$query = mysql_query("SELECT * FROM tblObjects WHERE>>
 refid = " . $album . " ORDER BY type", $db);
		$num_rows = mysql_num_rows($query);
		
		if($num_rows < $numCols)
		{
			$numRows = 1;
		}
	
		$maxobjects = $numRows * $numCols;
		$offsetstart = $page * $maxobjects;
		$offsetend = $offsetstart + $maxobjects;			
		
		$num_pages = $num_rows / $maxobjects;
		$num_pages = ceil($num_pages);
		if($num_pages == 0)
		{
			$num_pages = 1;
		}
		
		$query = mysql_query("SELECT * FROM tblObjects WHERE>>
 refid = " . $album . " ORDER BY type, id DESC LIMIT " . $offsetstart . >>
"," . $offsetend, $db);
		$num_rows2 = mysql_num_rows($query);
				
	}
	
	// ************ Hämta bild
	else
	{
		// ************ Hämta Refid för bilden (till parentpilen)
		$query = mysql_query("SELECT refid FROM tblObjects WHERE id = " . $imageid, $db);
		$myRow = mysql_fetch_row($query);
		$refid = $myRow[0];

		// ************ Hämta lista över alla bilder i albumet
		$query = mysql_query("SELECT id FROM tblObjects >>
WHERE refid = " . $refid . " AND type = 1 ORDER BY id DESC", $db);
		$num_images = mysql_num_rows($query);
		$image_list = array();
	
		while($myImg = mysql_fetch_row($query))
		{
			$image_list[] = $myImg[0];
		}

		// ************ Ta reda på bilden innan och efter (för sidbläddrarna)

		$key = array_search($imageid, $image_list);
		
		$curr_img = $image_list[$key];
		$disp_img = $key;
		
		if(array_key_exists(($key + 1), $image_list))
		{
			$next_img = $image_list[($key + 1)];
		}
		if(array_key_exists(($key - 1), $image_list))
		{
				$prev_img = $image_list[($key - 1)];
		}
		
		// ************ Fixa parentpilen för bilder som går över sidgränsen
		
		$query = mysql_query("SELECT id FROM tblObjects >>
WHERE refid = " . $refid . " ORDER BY type, id DESC", $db);
		$object_list = array();
		
		while($myObject = mysql_fetch_row($query))
		{
			$object_list[] = $myObject[0];
		}
		
		$maxObjectsPerPage = $numRows * $numCols;
		
		$key = array_search($imageid, $object_list);
		
		$parentPage = floor($key / $maxObjectsPerPage) + 1;
		
			
		// ************ Hämta bilden
		
		$query = mysql_query("SELECT * FROM tblObjects WHERE>>
 id = " . $imageid . " AND type = 1", $db);
		$myRow = mysql_fetch_array($query);
		
		$img_name = ("." . $picpath . "/" . $myRow[4] . ".jpg");

		$im = imagecreatefromjpeg($img_name);
		
		$picwidth = imagesx($im);
		$picheight = imagesy($im);
		
		imagedestroy($im);
		
	}

	require("Includes/site-top.php");	

?>

			<div class="bild"><img src="Images/bildtopp_subba2.jpg" width="780" height="215" >>
alt="Bildtopp" /></div>
			<div class="row2"><img src="Images/galleri-stor.gif">>
 width="97" height="46" alt="Galleri" /></div>
			<div class="content" style="text-align:center;padding:0px">
				<?php
				
					// ************ Visa bilden
					if(isset($imageid))
					{
						{		
							// ************ Skriv ut parent-pilen

							print("<div class=\"infobar\">\n\t\t\t\t\t<div style=\"float:right\">\n\t\t\t\t\t\t");
							// ************ Skriv ut sidbläddrar-pilarna
							if(isset($prev_img))
							{
								print("<a href=\"" .>>
 $_SERVER['PHP_SELF'] . "?image=" . $prev_img . "&ppage=" . >>
$parentPage . "\"><img src=\"/Images/prev.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t\t");
							}
							else
							{
								print("<img src=\"/Images/prevoff.gif\" alt=\"pil\">\n\t\t\t\t\t\t");
							}
							// ************ Skriv ut parent-pilen
							print("<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?album=" . $refid . "&page=" . >>
$parentPage . "\"><img src=\"Images/parent.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t\t");
							if(isset($next_img))
							{
								print("<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?image=" . $next_img . "&ppage=" . >>
$parentPage . "\"><img src=\"/Images/next.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t");
							}
							else
							{
								print("<img src=\"/Images/nextoff.gif\" alt=\"pil\">\n\t\t\t\t\t");
							}
							print("</div>\n\t\t\t\t\t<div >>
style=\"float:left;padding:2px\">\n\t\t\t\t\t\tImage: " . ($disp_img + >>
1) . "/" . $num_images . "\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t");							
							
							// ************ Visa bilden + info
							print(" <br />\n\t\t\t\t<img>>
 src=\"." . $picpath . "/" . $myRow[4] . ".jpg\" alt=\"bild\" width=\"" . >>
$picwidth ."\" height=\"" . $picheight . "\" class=\"image\" /><br >>
/>\n\t\t\t\t" . $myRow[3] ."\n");
						}
					}
					else
					// ************ Visa innehållet i albumet
					{
						print("<div class=\"infobar\">\n\t\t\t\t\t<div style=\"float:right\">\n\t\t\t\t\t\t");
						// ************ Skriv ut sidbläddrar-pilarna
						if($offsetstart > 0)
						{
							print("<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?album=" . $album . "&page=" . >>
$prevpage . "\"><img src=\"/Images/prev.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t\t");
						}
						else
						{
							print("<img src=\"/Images/prevoff.gif\" alt=\"pil\" />\n\t\t\t\t\t\t");	
						}
						if($album != 0)
						{
							// ************ Skriv ut parent-pilen
							print("<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?album=" . $refid . "&page=" . >>
$parent_page . "\"><img src=\"Images/parent.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t\t");
						}
						else
						{
							print("<img src=\"/Images/upoff.gif\" alt=\"pil\" />\n\t\t\t\t\t\t");
						}
						if($offsetend < $num_rows)
						{
							print("<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?album=" . $album . "&page=" . >>
$nextpage . "\"><img src=\"/Images/next.gif\" >>
style=\"border-style:none\" alt=\"pil\" /></a>\n\t\t\t\t\t");
						}
						else
						{
							print("<img src=\"/Images/nextoff.gif\" alt=\"pil\" />\n\t\t\t\t\t");	
						}
						print("</div>\n\t\t\t\t\t<span >>
style=\"float:left;width:200px;text-align:left;\">\n\t\t\t\t\t\tAlbum: " >>
. $albumname . "\n\t\t\t\t\t</span>\n\t\t\t\t\t<span >>
style=\"padding:2px;width:100px;text-align:left\">\n\t\t\t\t\t\tPage:>>
 " . ($page + 1) . " / " . $num_pages . >>
"\n\t\t\t\t\t</span>\n\t\t\t\t</div>");
						
						// ************ Loopa och skriv ut alla bilder och album
						if(!($num_rows == 0))
						{
							print("\n\t\t\t\t<table class=\"objects\">");
							for($counter1 = 1; $counter1 <= $numRows; $counter1++)
							{
								print("\n\t\t\t\t\t<tr>");
								for($counter2 = 1; $counter2 <= $numCols; $counter2++)
								{
									if($myRow = mysql_fetch_row($query))
									{
										if($myRow[2] == 0)
										{
											print("\n\t\t\t\t\t\t<td class=\"icon\">\n\t\t\t\t\t\t\t<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?album=" . $myRow[0] . "&ppage=" . >>
($page + 1) . "\">\n\t\t\t\t\t\t\t\t<img src=\"/Images/albumicn.gif\" >>
style=\"border-style:none\" alt=\"ikon\" width=\"120\" >>
height=\"90\" /></a>\n\t\t\t\t\t\t\t<br />\n\t\t\t\t\t\t\t" . $myRow[4]>>
 . "\n\t\t\t\t\t\t</td>");
										}
										else
										{
											print("\n\t\t\t\t\t\t<td class=\"icon\">\n\t\t\t\t\t\t\t<a href=\"" . >>
$_SERVER['PHP_SELF'] . "?image=" . $myRow[0] . "&ppage=" . >>
($page + 1) . "\">\n\t\t\t\t\t\t\t\t<img src=\"." . $picpath . "/tmb_" . >>
$myRow[4] . ".gif\" alt=\"tumnagel\" style=\"border-style:none\" >>
width=\"120\" height=\"90\" /></a>\n\t\t\t\t\t\t\t<br >>
/>\n\t\t\t\t\t\t\t \n\t\t\t\t\t\t</td>");
										}
									}
								}
								print("\n\t\t\t\t\t</tr>");
							}
							print("\n\t\t\t\t</table>\n");
						}
					}
				if(($num_rows == 0 AND !(isset($imageid))))
				{
					print(" ");
				}
				?>
		</div>
		<div class="row"></div>
		</div>
	</body>
</html>