/*
 * Plogger - A web based photo gallery
 * Copyright (C) 2005 Mike Johnson
 * 
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or (at
 * your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */
?>

// this file will load all the configuration elements from the database
// and place them into a global associative array called $config

$config = array();
$thumbnail_config = array();

require_once("plog-globals.php");
require_once("plog-functions.php");
require_once("plog-config.php");
connect_db();


$query = "SELECT * FROM `".TABLE_PREFIX."config`";
$result = mysql_query($query) or die(mysql_error() .'<br /><br />'.$query);

if (mysql_num_rows($result) == 0){
	die("No config information in the database.");
}

$config = mysql_fetch_assoc($result);

$config["basedir"] = dirname(__FILE__).DIRECTORY_SEPARATOR;

$url_parts = parse_url($_SERVER["REQUEST_URI"]);
$config["baseurl"] = "http://www.lalovin.com/";

$config["embedded"] = 0;

// try to figure out whether we are embedded (for example running from Wordpress)
// on windows/apache $_SERVER['PATH_TRANSLATED'] uses "/" for directory separators,
// __FILE__ has them the other way, realpath takes care of that.
if (dirname(__FILE__) != dirname(realpath($_SERVER["PATH_TRANSLATED"])) && strpos($_SERVER["PATH_TRANSLATED"],"admin") === false) {
	$config["embedded"] = 1;
	// disable our own cruft-free urls, because the URL has already been processed
	// by WordPress
	$config["use_mod_rewrite"] = 1;
} else {
	$config["baseurl"] = "http://".$_SERVER["SERVER_NAME"]. substr($_SERVER["PHP_SELF"],0,strrpos($_SERVER["PHP_SELF"],"/")) . "/"; 
}

// remove admin/ from the end, if present .. is there a better way to determine the full url?
if (substr($config["baseurl"],-6) == "admin/") {
	$config["baseurl"] = substr($config["baseurl"],0,-6);
}

$config["theme_url"] = $config["gallery_url"]."themes/".basename($config["theme_dir"])."/";
$config['charset'] = 'utf-8';
$config['version'] = 'Beta 3 (dev)';

// charset set with HTTP headers has higher priority that that set in HTML head section
// since some servers set their own charset for PHP files, this should take care of it
// and hopefully doesn't break anything

if (!headers_sent()){
	header('Content-Type: text/html; charset=' . $config['charset']);
}

$query = "SELECT * FROM `".TABLE_PREFIX."thumbnail_config`";
$result = mysql_query($query) or die(mysql_error() .'<br /><br />'.$query);

if (mysql_num_rows($result) == 0){
	die("No thumbnail config information in the database.");
}

$prefix_arr = array(1 => '',2 => 'lrg-',3 => 'rss-',4 => 'tn-');

while($row = mysql_fetch_assoc($result)) {
	$thumbnail_config[$row['id']] = array(
			'filename_prefix' => $prefix_arr[$row['id']],
			'size' => $row['max_size'],
			'timestamp' => $row['update_timestamp'],
			'disabled' => $row['disabled']);
}

// debugging function
function display_uservariables(){
	foreach ($config as $keys => $values) {
		echo "$keys = $values<br>";
	}
}

if (!isset($_SESSION["plogger_sortby"])){
	$_SESSION["plogger_sortby"] = $config['default_sortby'];
}

if (!isset($_SESSION["plogger_sortdir"])){
	$_SESSION["plogger_sortdir"] = $config['default_sortdir'];
}

if (!isset($_SESSION["plogger_details"])){
	$_SESSION["plogger_details"] = 0;

}

?>

function generate_album_names() {
   	global $config;
	
	$output = '';
	$image_count = array();

	$output .=  '<p align="left">';		
//	$output .=  '<form id="jump_menu" name="jump_menu" action="#" method="get"><div>';
//	$output .=  '<select name="jump_menu" onchange="document.location.href = this.options[this.selectedIndex].value;"><option value="#">Jump to...</option>';
	
	// 1. create a list of all albums with at least one photo
	$sql = "SELECT
			`parent_album`,
			COUNT(*) AS `imagecount`
		FROM `".TABLE_PREFIX."pictures`
		GROUP BY `parent_album`";
	$result = run_query($sql);
	
	while($row = mysql_fetch_assoc($result)) {
		$image_count[$row["parent_album"]] = $row["imagecount"];
	}
	
	// 2. get a list of all albums and collections
	$sqlCollection = "SELECT
		`a`.id AS `album_id`,
		`a`.name AS `album_name`,
		`c`.id AS `collection_id`,
		`c`.name AS `collection_name`
	FROM `".TABLE_PREFIX."albums` AS `a`
		LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `a`.`parent_id`=`c`.`id`
	ORDER BY `c`.`name` DESC, `a`.`name` ASC";
	$result = run_query($sqlCollection);
	
	$last_collection = "";
	
	while ($row = mysql_fetch_assoc($result)){
		// skip albums with no images
		if (empty($image_count[$row["album_id"]])) {
			continue;
		}
		
		if ($row["collection_id"] != $last_collection && $row["collection_id"] != "3") {
			$output .= '<br><b><font color"#000000" size="2" face="arial">'.$row["collection_name"].' Pics</font></b><br>';



//			$output .= '<option value="'.generate_url("collection",$row["collection_id"]).'">'.$row["collection_name"].'</option>';
			$last_collection = $row["collection_id"];
		}



    if ((strlen($row["album_name"]) > 31) && $row["collection_id"] != "3") {

		$output .=  '<font size="2" face="arial">&nbsp;&nbsp;&nbsp;<a href="'.generate_url("album",$row["album_id"]).'">'.substr(SmartStripSlashes($row["album_name"]), 0, 27).'...</a></font><br>';
		}


    if ((strlen($row["album_name"]) < 31) && $row["collection_id"] != "3") {

		$output .=  '<font size="2" face="arial">&nbsp;&nbsp;&nbsp;<a href="'.generate_url("album",$row["album_id"]).'">'.substr(SmartStripSlashes($row["album_name"]), 0, 30).'</a></font><br>';
		}


//		$output .=  '<option value="'.generate_url("album",$row["album_id"]).'">'.SmartStripSlashes($row["collection_name"]).' : '.SmartStripSlashes($row["album_name"]);
//		$output .=  '</option>';
	}
	
//	$output .= '</select></div></form>';
	
	return $output;
}



function generate_breadcrumb(){
	global $config;
	
	$id = $GLOBALS["plogger_id"];
	
	switch ($GLOBALS['plogger_level']) {
		case 'collection':
			$row = get_collection_by_id($id);
			
//			$breadcrumbs = ' <a accesskey="/" href="'.$config["baseurl"].'">Collections</a> &raquo; <b>' . SmartStripSlashes($row["name"]) . '</b>';

			$breadcrumbs = ' <b>' . SmartStripSlashes($row["name"]) . '</b>';

			if ($GLOBALS['plogger_mode'] == "slideshow") $breadcrumbs .= ' &raquo; Slideshow';
			
			break;
		case 'slideshow':
		case 'album':
			$row = get_album_by_id($id);
			
			$album_name = SmartStripSlashes($row["name"]);
			$album_link = generate_url("album",$row["id"]);
			
			$row = get_collection_by_id($row["parent_id"]);
			
			$collection_link = '<a accesskey="/" href="' . generate_url("collection",$row["id"]) . '">' . $row["name"] . '</a>';
			
			if ($GLOBALS['plogger_mode'] == "slideshow") {
				
//				$breadcrumbs = ' <a href="'.$config["baseurl"].'">Collections</a> &raquo; ' . $collection_link . ' &raquo; ' . '<a href="'.$album_link.'">'.$album_name.'</a> &raquo; ' . ' <b>Slideshow</b>';

//				$breadcrumbs = '  ' . $collection_link . ' &raquo; ' . '<a href="'.$album_link.'">'.$album_name.'</a> &raquo; ' . ' <b>Slideshow</b>';

			} else {
				
//				$breadcrumbs = ' <a href="'.$config["baseurl"].'">Collections</a> &raquo; ' . $collection_link . ' &raquo; ' . '<b>'.$album_name.'</b>';

				$breadcrumbs = '  ' . $collection_link . ' &raquo; ' . '<b>'.$album_name.'</b>';
			}
			
			break;
		case 'picture':
			$row = get_picture_by_id($id);
			$picture_name = SmartStripSlashes(basename($row["path"]));
			
			$row = get_album_by_id($row["parent_album"]);
			
			$album_link = '<a accesskey="/" href="' . generate_url("album",$row["id"]) . '">' . SmartStripSlashes($row["name"]) . '</a>';
			
			$row = get_collection_by_id($row["parent_id"]);
			
//			$collection_link = ' <a href="'.$config["baseurl"].'">Collections</a> ' . ' &raquo; ' . '<a href="' . generate_url("collection",$row["id"]) . '">' . SmartStripSlashes($row["name"]) . '</a>';

			$collection_link = ' <a href="' . generate_url("collection",$row["id"]) . '">' . SmartStripSlashes($row["name"]) . '</a>';




		
			$breadcrumbs = $collection_link . ' &raquo; ' . $album_link . ' &raquo; ' . '<span id="image_name"><b>   </b></span>';
			
			if ($GLOBALS['plogger_mode'] == "slideshow") $breadcrumbs .= ' &raquo; Slideshow';
			
			break;
		case 'search':
			$breadcrumbs = 'You searched for <b>'.htmlspecialchars($_GET["searchterms"]).'</b>.';
			break;
		default:
			$breadcrumbs = '<FONT size=5><B><FONT face=Verdana color=#5675e9>Daily Dish:</FONT></B></FONT>';
			break;
	}
	
	return '<div align=center>
  <center>
  <table border=0 cellpadding=0 cellspacing=0 width=600>
    <tr>
      <td width=350 align=left><div id="breadcrumb_links">'.$breadcrumbs.'</div></td>
      <td width=250 align=right>
      
         <table  id="header-table" width="100%"><tr><td></td><td id="jump-search-container">'.generate_search_box().'</td></tr></table>

      </td>
    </tr>
  </table>
  </center>
</div>';
}

function generate_title(){
	switch ($GLOBALS['plogger_level']) {
		case 'collection':
			$row = get_collection_by_id($GLOBALS['plogger_id']);
			
			$breadcrumbs = SmartStripSlashes($row["name"]);
			if ($GLOBALS['plogger_mode'] == "slideshow") $breadcrumbs .= ' &raquo; Slideshow';
			
			break;
		case 'slideshow':
		case 'album':
			$row = get_album_by_id($GLOBALS['plogger_id']);
			$album_name = SmartStripSlashes($row["name"]);
						
			$row = get_collection_by_id($row["parent_id"]);
			
			if ($GLOBALS['plogger_mode'] == "slideshow") {
				$breadcrumbs = SmartStripSlashes($row["name"]) . ' &raquo; ' . $album_name.' &raquo; ' . ' Slideshow';
			} else {
				$breadcrumbs = SmartStripSlashes($row["name"]) . ' &raquo; ' . $album_name;
			}
			
			break;
		case 'picture':
			$row = get_picture_by_id($GLOBALS['plogger_id']);
			$picture_name = basename($row["path"]);
			$caption = $row["caption"];
			
			$row = get_album_by_id($row["parent_album"]);
			$album_name = SmartStripSlashes($row["name"]);
			
			$row = get_collection_by_id($row["parent_id"]);
			
			$collection_name = SmartStripSlashes($row["name"]);
			
			$breadcrumbs = $collection_name . ' &raquo; ' . $album_name . ' &raquo; ' . $caption;
			
			if ($GLOBALS['plogger_mode'] == "slideshow") $breadcrumbs .= ' &raquo; Slideshow';
			
			break;
		default:
			$breadcrumbs = 'Celebrity News, Pics, Paparazzi, Candid, Gossip, Nipple Slip, Topless - Your Daily dose of Hollywood!';
	}
	
	return $breadcrumbs;
}

function generate_jump_menu() {
   	global $config;
	
	$output = '';
	$image_count = array();
	
	$output .=  '<form id="jump_menu" name="jump_menu" action="#" method="get"><div>';
	$output .=  '<select name="jump_menu" onchange="document.location.href = this.options[this.selectedIndex].value;"><option value="#">Jump to...</option>';
	
	// 1. create a list of all albums with at least one photo
	$sql = "SELECT
			`parent_album`,
			COUNT(*) AS `imagecount`
		FROM `".TABLE_PREFIX."pictures`
		GROUP BY `parent_album`";
	$result = run_query($sql);
	
	while($row = mysql_fetch_assoc($result)) {
		$image_count[$row["parent_album"]] = $row["imagecount"];
	}
	
	// 2. get a list of all albums and collections
	$sqlCollection = "SELECT
		`a`.id AS `album_id`,
		`a`.name AS `album_name`,
		`c`.id AS `collection_id`,
		`c`.name AS `collection_name`
	FROM `".TABLE_PREFIX."albums` AS `a`
		LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `a`.`parent_id`=`c`.`id`
	ORDER BY `c`.`name` ASC, `a`.`name` ASC";
	$result = run_query($sqlCollection);
	
	$last_collection = "";
	
	while ($row = mysql_fetch_assoc($result)){
		// skip albums with no images
		if (empty($image_count[$row["album_id"]])) {
			continue;
		}
		
		if ($row["collection_id"] != $last_collection) {
			$output .= '<option value="'.generate_url("collection",$row["collection_id"]).'">'.$row["collection_name"].'</option>';
			$last_collection = $row["collection_id"];
		}
		
		$output .=  '<option value="'.generate_url("album",$row["album_id"]).'">'.SmartStripSlashes($row["collection_name"]).' : '.SmartStripSlashes($row["album_name"]);
		$output .=  '</option>';
	}
	
	$output .= '</select></div></form>';
	
	return $output;
}

function generate_exif_table($id, $condensed = 0){
	global $config;
	
	$query = "SELECT * FROM `".TABLE_PREFIX."pictures` WHERE `id`=".intval($id);
	$result = run_query($query);
	
	if (mysql_num_rows($result) > 0){
		$row = mysql_fetch_assoc($result);
		
		foreach($row as $key => $val) if (trim($row[$key]) == '') $row[$key] = '&nbsp;';
		
		$table_data = '<div id="exif_table"><table id="exif_data"';
		
		if (!$_SESSION["plogger_details"]){
			$table_data .= ' style="display: none;"';
		}
		
		// get image size
		$img = $config['basedir'] . 'images/' . SmartStripSlashes($row['path']);
		list($width, $height, $type, $attr) = getimagesize($img);
		$size = round(filesize($img) / 1024, 2);
		
		if (!$condensed) {
			$table_data .= '>
					<tr>
						<td><strong>Dimensions</strong></td>
						<td>'.$width .' x ' .$height.'</td>
					</tr>
					<tr>
						<td><strong>File size</strong></td>
						<td>'.$size.' kbytes</td>
					</tr>
					<tr>
						<td><strong>Taken on</strong></td>
						<td>'.$row["EXIF_date_taken"].'</td>
					</tr>
					<tr>
						<td><strong>Camera model</strong></td>
						<td>'.$row["EXIF_camera"].'</td>
					</tr>
					<tr>
						<td><strong>Shutter speed</strong></td>
						<td>'.$row["EXIF_shutterspeed"].'</td>
					</tr>
					<tr>
						<td><strong>Focal length</strong></td>
						<td>'.$row["EXIF_focallength"].'</td>
					</tr>
					<tr>
						<td><strong>Aperture</strong></td>
						<td>'.$row["EXIF_aperture"].'</td>
					</tr>
				</table></div>';
		} else {
			$table_data .= '><tr><td><strong>Dimensions</strong></td><td>'.$width .' x ' .$height.'</td></tr><tr><td><strong>File size</strong></td><td>'.$size.' kbytes</td></tr><tr><td><strong>Taken on</strong></td><td>'.$row["EXIF_date_taken"].'</td></tr><tr><td><strong>Camera model</strong></td><td>'.$row["EXIF_camera"].'</td></tr><tr><td><strong>Shutter speed</strong></td><td>'.$row["EXIF_shutterspeed"].'</td></tr><tr><td><strong>Focal length</strong></td><td>'.$row["EXIF_focallength"].'</td></tr><tr><td><strong>Aperture</strong></td><td>'.$row["EXIF_aperture"].'</td></tr></table></div>';
		}
	}
	
	return $table_data;
}

function plogger_display_comments() {
	global $config;
	
	if (file_exists(THEME_DIR . '/comments.php')) {
		include(THEME_DIR . '/comments.php');
	} else {
		include($config['basedir'] . '/themes/default/comments.php');
	}
}

// generate header produces the Gallery Name, The Jump Menu, and the Breadcrumb trail
// at the top of the image

function generate_header() {
	global $config;
	
	$output = '<h1 id="gallery-name">'.stripslashes($config["gallery_name"]).'</h1>';
	return $output;
}

function generate_sortby($level,$id){
	global $config;
	
	$output = '';
	
	$id = $GLOBALS["plogger_id"];
	
	$fields = array(
		'date' => 'Date Submitted',
//		'date_taken' => 'Date Taken',
//		'caption' => 'Caption',
//		'filename' => 'Filename',
		'number_of_comments' => 'Number of Comments',
	);
	
	if ($level == "album"){
		// I think this should be a single form and I really should move the javascript functions
		// into a separate file
		
		// I need to merge those 2 forms. and since I'm realoading stuff anyway, I can just
		// create correct urls. oh yeah, baby.
		
		$output .= '
			<form action="#" method="get">
				<span><label for="change_sortby">Sort by:</label>
				<select id="change_sortby" name="change_sortby" 
				onchange="document.location.href = this.options[this.selectedIndex].value;">
				';
		
		foreach($fields as$fkey => $fval) {
			$value = generate_url("album",$id,array(1 => 'sorted','sortby' => $fkey,'sortdir' => $_SESSION['plogger_sortdir']));
			
			$output .= '<option value="'.$value.'"';
			
			if ($_SESSION["plogger_sortby"] == $fkey) {
				$output .= " selected='selected'";
			}
			
			$output .= ">$fval</option>\n";
		}
		
		$output .= "</select></span></form>\n";
	}
	
	return $output;
}

function generate_sortdir($level,$id){
	global $config;
	
	$output = '';
	$id = $GLOBALS["plogger_id"];
	
	$orders = array(
		'asc' => 'Ascending',
		'desc' => 'Descending',
	);
	
	if ($level == "album") {
		$output .= '
			<form action="#" method="get">
				<span><select id="change_sortdir" name="change_sortdir" 
				onchange="document.location.href = this.options[this.selectedIndex].value;">';
		
		foreach($orders as $okey => $oval) {
			$value = generate_url("album",$id,array(1 => 'sorted','sortby' => $_SESSION['plogger_sortby'],'sortdir' => $okey));
			
			$output .= "<option value=\"$value\"";
			
			if(strcasecmp($_SESSION["plogger_sortdir"], $okey) === 0) {
				$output .= ' selected="selected"';
			}
			
			$output .= ">$oval</option>\n";
		}
		
		$output .= '</select></span></form>';		
	}
	
	return $output;
}

function generate_search_box(){
	global $config;
	
	$output = '
		<form action="'.$config["baseurl"].'" method="get">
			<div>
			<input type="hidden" name="level" value="search" />
			<input type="text" name="searchterms" />
			<input class="submit" type="submit" value="Search" />
			</div>
		</form>';
	
	return $output;
}

// benchmark timing
function getmicrotime($t) {
	list($usec, $sec) = explode(" ",$t);
	return ((float)$usec + (float)$sec);
}

// function for generating the slideshow javascript
function generate_slideshow_js($id, $mode) {
	global $config;
	
	// output the link to the slideshow javascript
	$output = '<script type="text/javascript" src="'.$config['gallery_url'].'slideshow.js"></script>';
	return $output;
}

function preload_album_images(){
	global $thumbnail_config;
	$script = "<script type='text/javascript' language='JavaScript'>
	    <!--
	    function preload_images() {
	    if (document.images)
	    {
		preload_image_object = new Image();
		// set image url
		image_url = new Array();";
	      $pic_array = get_picture_by_id($GLOBALS["image_list"]);
	      $i = 0;
	      foreach($pic_array as $pic) {
		      unset($path);
		      $url = generate_thumb($pic["path"],$thumbnail_config[THUMB_LARGE]["prefix"],THUMB_LARGE);
		      $script .= "\t\timage_url[$i] = '$url'\n";
		      $i++;
	      }
	   $script .= "var i = 0;
	       for(i=0; i<image_url.length; i++) 
		 preload_image_object.src = image_url[i];
	    }
	}
	//-->
	</SCRIPT>";
    return $script;
}

function plogger_head() {
	global $config;
	
	$title = generate_title($GLOBALS['plogger_level'], $GLOBALS['plogger_id']);
	
	if ($config["embedded"] == 0) {
		print "<title>" . SmartStripSlashes($config["gallery_name"]) . ": $title </title>\n";
	}
	else {
		print "<title>" . SmartStripSlashes($config["gallery_name"]) . ": $title </title>\n";
	}
	
	print generate_slideshow_js($GLOBALS["plogger_id"], "album");
	print "\n";
	
	// Embed URL to RSS feed for proper level.
	print '<link rel="alternate" type="application/rss+xml" title="RSS Feed" href="'.plogger_rss_link().'" />' . "\n";
	print '<meta http-equiv="Content-Type" content="text/html;charset=' . $config['charset'] . '"/>' . "\n";

	print '<meta name="Description" content="LaLovin is your source for celebrity news, nude celebrity, celebrity sex, celebrity porn, celebrity sex tape, celebrity upskirt, free nude celebiry, celebrity photo, celebrity oops, and more!">' . "\n";
	print '<meta name="Keywords" content="celebrity news, nude celebrity, celebrity sex, celebrity porn, celebrity sex tape, celebrity upskirt, free nude celebrity, celebrity photo, celebrity oops, free celebrity porn, celebrity sex video, celebrity pussy, actor celebrity hot picture, free celebrity sex tape, free celebrity sex video, celebrity boob, sexy celebrity, celebrity nip slip, free nude celebrity picture, celebrity blow job, celebrity camel toe, playboy celebrity, free naked celebrity, nude celebrity video, nude celebrity picture, celebrity nude photo, celeb free nude, celeb sex, celeb oops, celeb porn, celeb upskirt, celeb nude z, celeb sexy, celeb free porn, celeb free nude picture, celeb free sex tape, celeb free naked, celeb nude picture, celeb tit, celeb fuck, celeb naked, celeb free nude pic, celeb nuded, celeb sex tape, celeb male nude, celeb nude pic, celeb pussy, celeb nude video, celeb fake free, celeb free movie nude, celeb hot, celeb free nude video, camel celeb toe, celeb topless, celeb lesbian, celeb playboy, celeb skanky, boob celeb, celeb xxx, celeb pinay, celeb exposed, celeb fake free nude, celeb free naked pic, celeb free sex, celeb jades nude, celeb nip slip, celeb tasteful, celeb pic sexy, celeb nipples, celeb mobo, absolutly celeb free nude pic, celeb jades, celeb star, celeb video, celeb hot pic, celeb fake nude pic, absolutely celeb free gallery nude, celeb free, celeb paparazzi, celeb oops pic, celeb flix, celeb free nude z, celeb sex video, celeb free nude photo, celeb nipple, celeb skirt up, celeb nude z.com, celeb pussy slip, black celeb, celeb movie, busty celeb, celeb nude scene, celeb free picture">' . "\n";
}


function connect_db() {

	if (!PLOGGER_DB_HOST) {
		die("Please run _install.php to set up Plogger.  If you are upgrading from a previous version, please run _upgrade.php.");
	}

	global $PLOGGER_DBH;
	
	$PLOGGER_DBH = mysql_connect(PLOGGER_DB_HOST, PLOGGER_DB_USER, PLOGGER_DB_PW) or die ("Plogger cannot connect to the database because: " . mysql_error());

	mysql_select_db(PLOGGER_DB_NAME);
	
	$mysql_version = mysql_get_server_info();
	$mysql_charset_support = "4.1";
	
	if (1 == version_compare($mysql_version, $mysql_charset_support)) {
	        mysql_query("SET NAMES utf8");
	}

}

function run_query($query) {
	global $PLOGGER_DBH;
	
	$result = @mysql_query($query, $PLOGGER_DBH);
	
	if (!$result){
		$trace = debug_backtrace();
		
		die(mysql_error($PLOGGER_DBH) . '<br /><br />' . $query . '<br /><br />In file: '.$_SERVER["PHP_SELF"] . '<br /><br />On line: ' . $trace[0]["line"]);
	} else {
		return $result;
	}
}

function generate_thumb($path, $prefix, $type = THUMB_SMALL) {
	global $config;
	global $thumbnail_config;
	
	// for relative paths assume that they are relative to images directory,
	// otherwise just use the given pat
	if (file_exists($path)) {
		$source_file_name = $path;
	} else {
		$source_file_name = $config['basedir'] . 'images/' . SmartStripSlashes($path);
	}
	
	// the file might have been deleted and since phpThumb dies in that case
	// try to do something sensible so that the rest of the images can still be seen
	
	// there is a problem in safe mode - if the script and picture file are owned by
	// different users, then the file can not be read.
	
	if (!is_readable($source_file_name)) {
		return false;
	}
	
	$imgdata = @getimagesize($source_file_name);
	
	if (!$imgdata) {

		// unknown image format, bail out
		return false;
	}
	
	// attributes of original image
	$orig_width = $imgdata[0];
	$orig_height = $imgdata[1];
	
	// XXX: food for thought - maybe we can return URL to some kind of error image 
	// if this function fails? 
	
	$base_filename = sanitize_filename(basename($path));
	
	$thumb_config = $thumbnail_config[$type];
	
	if (1 == $thumb_config['disabled']) {
		return $config['baseurl'] . '/images/' . $path;
	}
	
	$prefix = $thumb_config['filename_prefix'] . $prefix . "-";
	
	$thumbpath = $config['basedir'] . 'thumbs/'.$prefix.$base_filename;
	$thumburl = $config['gallery_url'] . 'thumbs/'.$prefix.$base_filename;
	
	// if thumbnail file already exists and is generated after data for a thumbnail type
	// has been changed, then we assume that the thumbnail is valid.
	$thumbnail_timestamp = @filemtime($thumbpath);
	
	if (file_exists($thumbpath) && $thumb_config['timestamp'] < $thumbnail_timestamp) {
		return $thumburl;
	}
	
	// if dimensions of source image are smaller than those of the requested
	// thumbnail, then use the original image as thumbnail
	if ($orig_width <= $thumb_config['size'] && $orig_height <= $thumb_config['size']) {
		copy($source_file_name,$thumbpath);
		return $thumburl;
	}
	
	// no existing thumbnail found or thumbnail config has changed,
	// generate new thumbnail file
	
	list($width, $height, $thumb_type, $attr) = @getimagesize($thumbpath);
	
	require_once($config['basedir'] . 'lib/phpthumb/phpthumb.class.php');
	
	$phpThumb = new phpThumb();
	
	// set data
	$phpThumb->setSourceFileName($source_file_name);
	if ($imgdata[0] > $imgdata[1]) {
		$phpThumb->w = $thumb_config['size'];
	} else {
		$phpThumb->h = $thumb_config['size'];
	}
	
	$phpThumb->q = $config['compression'];
	
	// set zoom crop flag to get image squared off
	if ($type == THUMB_SMALL && $config['square_thumbs']) {
		$phpThumb->zc = 1;
		$phpThumb->h = $thumb_config['size'];
		$phpThumb->w = $thumb_config['size'];
	}
	
	$phpThumb->config_use_exif_thumbnail_for_speed = false;
	
	// Set image height instead of width if not using square thumbs
	if ($type == THUMB_SMALL && !$config['square_thumbs']) {
		$phpThumb->h = $thumb_config['size'];
		$phpThumb->w = '';
	}
	
	if($type == THUMB_NAV) {
		$phpThumb->zc = 1;
		$phpThumb->h = $thumb_config['size'];
		$phpThumb->w = $thumb_config['size'];
	}
	
	// set options (see phpThumb.config.php)
	// here you must preface each option with "config_"
	
	// Set error handling (optional)
	$phpThumb->config_error_die_on_error = false;
	
	// generate & output thumbnail
	if ($phpThumb->GenerateThumbnail()) {
		$phpThumb->RenderToFile($thumbpath);
	} else {
		// do something with debug/error messages
		die('Failed: '.implode("\n", $phpThumb->debugmessages));
	}
	
	return $thumburl;
}

function get_picture_by_id($id, $album_id = null) {
	global $config;
	
	if(is_array($id)) {
		$where_cond = "IN ('".implode("', '",$id)."');";
	} else {
		$where_cond = "= ".intval($id).";";
	}
	
	$sql = "SELECT
			`p`.*,
			`a`.`path` AS `album_path`,
			`c`.`path` AS `collection_path`
		FROM `".TABLE_PREFIX."pictures` AS `p`
			LEFT JOIN `".TABLE_PREFIX."albums` AS `a` ON `p`.`parent_album`=`a`.`id`
			LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `p`.`parent_collection`=`c`.`id`
		WHERE `p`.`id` ".$where_cond;
	
	if ($album_id){
		$sql .= " AND `p`.`parent_album`=".intval($album_id);
	}
	
	$resultPicture = run_query($sql);
	
	if (is_array($id) && mysql_num_rows($resultPicture) > 0) {
		$picdata = array();
		while ($row = mysql_fetch_assoc($resultPicture)) {
			$row['url'] = $config['gallery_url'].'images/'.$row['collection_path'].'/'.$row['album_path'].'/'.basename($row['path']);
			array_unshift($picdata,$row);
		}
	}
	elseif (!is_array($id) && mysql_num_rows($resultPicture) > 0){
		$picdata = mysql_fetch_assoc($resultPicture);
		
		// eventually I want to get rid of the full path in pictures tables to avoid useless data duplication
		// the following is a temporary solution so I don't have to break all the functionality at once
		$picdata['url'] = $config['gallery_url'].'images/'.$picdata['collection_path'].'/'.$picdata['album_path'].'/'.basename($picdata['path']);
	} else {
		$picdata = false;
	}
	
	return $picdata;
}

function get_pictures($album_id, $order = "alpha", $sort = "DESC"){
	global $config;
	
	$query = "SELECT
			`p`.*,
			`a`.`path` AS `album_path`,
			`c`.`path` AS `collection_path`
		FROM `".TABLE_PREFIX."pictures` AS `p`
			LEFT JOIN `".TABLE_PREFIX."albums` AS `a` ON `p`.`parent_album`=`a`.`id`
			LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `p`.`parent_collection`=`c`.`id`
		WHERE `a`.`id`=".intval($album_id);
	
	if ($order == "mod"){
		$query .= "	ORDER BY `p`.`date_submitted` ";
	}
	else {
		$query .= "	ORDER BY `p`.`caption` ";
	}
	
	if ($sort == "ASC"){
		$query .= " ASC ";
	} else {
		$query .= " DESC ";
	}
	
	$result = run_query($query);
	
	$pictures = array();
	
	while ($row = mysql_fetch_assoc($result)){
		// See comment in get_picture_by_id
		$row['url'] = $config['gallery_url'].'images/'.$row['collection_path'].'/'.$row['album_path'].'/'.basename($row['path']);
		$pictures[$row["id"]] = $row;
	}
	
	return $pictures;
}

function get_album_by_id($id) {
	global $config;
	
	$sql = "SELECT
			`a`.*,
			`c`.`path` AS `collection_path`,
			`a`.`path` AS `album_path`,
			`c`.`name` AS `collection_name`,
			`a`.`name` AS `album_name`
		FROM `".TABLE_PREFIX."albums` AS `a`
			LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `a`.`parent_id`=`c`.`id`
			LEFT JOIN `".TABLE_PREFIX."pictures` AS `i` ON `a`.`thumbnail_id`=`i`.`id`
		WHERE `a`.`id` = ".intval($id);
	$result = run_query($sql);
	
	if (mysql_num_rows($result) > 0){
		$album = mysql_fetch_assoc($result);
		
		if ($album["thumbnail_id"] == 0){
			$query = "SELECT
					`id`,
					`path`
				FROM `".TABLE_PREFIX."pictures`
				WHERE `parent_album`=".intval($album["id"])."
				ORDER BY `date_submitted` DESC
				LIMIT 1";
			$result = run_query($query);
			
			if (mysql_num_rows($result) > 0){
				$row = mysql_fetch_assoc($result);
				$album["thumbnail_id"] = $row["id"];
			}
		}
	} else {
		$album = false;
	}
	
	return $album;
}

function get_collection_by_id($id) {
	global $config;
	
	$sqlCollection = "SELECT
			`c`.*,
			`c`.`path` AS `collection_path`
		FROM `".TABLE_PREFIX."collections` AS `c`
			LEFT JOIN `".TABLE_PREFIX."pictures` AS `i` ON `c`.`thumbnail_id`=`i`.`id`
		WHERE `c`.`id`=".intval($id)."
		ORDER BY `c`.`name` ASC";
	$resultCollection = run_query($sqlCollection);
	
	if (mysql_num_rows($resultCollection) == 0){
		$collection = false;
	}
	else {
		$collection = mysql_fetch_assoc($resultCollection);
		
		if ($collection["thumbnail_id"] == 0){
			$query = "SELECT
					`id`,
					`path`
				FROM `".TABLE_PREFIX."pictures`
				WHERE `parent_collection`=".intval($collection["id"])."
				ORDER BY `date_submitted` DESC
				LIMIT 1";
			$result = run_query($query);
			
			if (mysql_num_rows($result) > 0){
				$row = mysql_fetch_assoc($result);
				$collection["thumbnail_id"] = $row["id"];
			}
		}
	}
	
	return $collection;
}

function get_collection_by_name($name) {
	$sql = "SELECT *
		FROM `".TABLE_PREFIX."collections`
		WHERE name = '".mysql_real_escape_string($name)."'";
	$result = run_query($sql);
	
	if (mysql_num_rows($result) > 0){
		$collection = mysql_fetch_assoc($result);
	} else {
		$collection = false;
	}
	
	return $collection;
}

function get_albums($collection_id = null, $sort = "alpha", $order = "DESC") {
	global $config;
	
	$albums = array();
	
	if ($sort == "mod"){
		$query = "SELECT
				`a`.`id` AS `album_id`,
				`a`.`name` AS `album_name`,
				`c`.`id` AS `collection_id`,
				`c`.`name` AS `collection_name`,
				`a`.`description`,
				`a`.`thumbnail_id`
			FROM `".TABLE_PREFIX."pictures` AS `i`
				LEFT JOIN `".TABLE_PREFIX."albums` AS `a` ON `i`.`parent_album`=`a`.`id`
				LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `i`.`parent_collection`=`c`.`id`
				LEFT JOIN `".TABLE_PREFIX."pictures` AS `i2` ON `a`.`thumbnail_id`=`i2`.`id` ";
		
		if ($collection_id){
			$query .= " WHERE `i`.`parent_collection`=".intval($collection_id);
		}
		
		$query .= "
			GROUP BY `i`.`parent_album`
			ORDER BY `i`.`date_submitted` ";
		
		if ($order == "ASC"){
			$query .= " ASC ";
		} else {
			$query .= " DESC ";
		}
	} else {
		$query = "SELECT
				`a`.`id` AS `album_id`,
				`a`.`name` AS `album_name`,
				`c`.`id` AS `collection_id`,
				`c`.`name` AS `collection_name`,
				`a`.`description`,
				`a`.`thumbnail_id`
			FROM `".TABLE_PREFIX."albums` AS `a`
				LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `a`.`parent_id`=`c`.`id`
				LEFT JOIN `".TABLE_PREFIX."pictures` AS `i` ON `a`.`thumbnail_id`=`i`.`id`";
		
		if ($collection_id){
			$query .= " WHERE `c`.id=".intval($collection_id)." ";
		}
		
		$query .= " ORDER BY `c`.`name` ASC, `a`.`name` ASC";
	}
	
	$result = run_query($query);
	
	while ($album = mysql_fetch_assoc($result)) {
		if ($album["thumbnail_id"] == 0){
			$query = "SELECT
					`id`,
					`path`
				FROM `".TABLE_PREFIX."pictures`
				WHERE `parent_album`=".intval($album["album_id"])."
				ORDER BY `date_submitted` DESC
				LIMIT 1";
			$thumb_result = run_query($query);
			
			if (mysql_num_rows($thumb_result) > 0){
				$row = mysql_fetch_assoc($thumb_result);
				$album["thumbnail_id"] = $row["id"];
			}
		}
		
		$albums[$album["album_id"]] = $album;
	}
	
	return $albums;
}

function get_collections($sort = "alpha", $order = "DESC") {
	global $config;
	
	if ($sort == "mod"){
		$query = "SELECT
				`c`.*
			FROM `".TABLE_PREFIX."pictures` AS `i`
				LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `i`.`parent_collection`=`c`.`id`
				LEFT JOIN `".TABLE_PREFIX."pictures` AS `i2` ON `c`.`thumbnail_id`=`i2`.`id`
			GROUP BY `i`.`parent_collection`
			ORDER BY `i`.`date_submitted` ";
		
		if ($order == "ASC"){
			$query .= " ASC ";
		} else {
			$query .= " DESC ";
		}
	} else {
		$query = "SELECT
			`c`.*
		FROM `".TABLE_PREFIX."collections` AS `c`
		ORDER BY `c`.`name` ";
		
		if ($order == "ASC"){
			$query .= " ASC ";
		} else {
			$query .= " DESC ";
		}
	}
	
	$resultCollection = run_query($query);
	
	$collections = array();
	
	while ($collection = mysql_fetch_assoc($resultCollection)){
		if ($collection["thumbnail_id"] == 0){
			$query = "SELECT
					`id`,
					`path`
				FROM `".TABLE_PREFIX."pictures`
				WHERE `parent_collection`=".intval($collection["id"])."
				ORDER BY `date_submitted` DESC
				LIMIT 1";
			$result = run_query($query);
			
			if (mysql_num_rows($result) > 0){
				$row = mysql_fetch_assoc($result);
				$collection["thumbnail_id"] = $row["id"];
			}
		}
		
		$collections[$collection["id"]] = $collection;
	}
	
	return $collections;
}

function SmartAddSlashes($str){
	if (get_magic_quotes_gpc()){
		return $str;
	} else {
		return addslashes($str);
	}
}

function SmartStripSlashes($str){
	if (get_magic_quotes_gpc()){
		return stripslashes($str);
	} else {
		return $str;
	}
}

// this tries hard to figure out level and object id from textual path to a resource, used 
// mostly if mod_rewrite is in use
function resolve_path($str = "") {
	$rv = array();
	$path_parts = explode("/",$str);
	
	$levels = array("collection","album","picture","arg1","arg2");
	
	$current_level = "";
	
	$names = array();
	
	foreach($levels as $key => $level) {
		if (isset($path_parts[$key])) {
			$names[$level] = mysql_escape_string(urldecode(SmartStripSlashes($path_parts[$key])));
			$current_level = $level;
		}
	}
	
	if (!empty($names["collection"])) {
		$sql = "SELECT *
		 	FROM `".TABLE_PREFIX."collections`
			WHERE `path`='".mysql_real_escape_string($names["collection"])."'";
		$result = run_query($sql);
		
		if (mysql_num_rows($result) == 0){
		 	return $rv;
		}
		
		$collection = mysql_fetch_assoc($result);
		
		// what if there are multiple collections with same names? I hope there aren't .. this would
		// suck. But here is an idea, we shouldn't allow the user to enter similar names
		$rv = array("level" => "collection","id" => $collection["id"]);
	}
	
	if (!empty($names['album'])) {
		$sql = "SELECT *
			FROM `".TABLE_PREFIX."albums`
			WHERE `path`='".mysql_real_escape_string($names["album"])."'
				AND `parent_id`=".intval($collection["id"]);
		$result = run_query($sql);
		
		if (mysql_num_rows($result) == 0){
			// no such album, fall back to collection
			return $rv;
		}
		
		$album = mysql_fetch_assoc($result);
		
		// try to detect slideshow. Downside is that you cannot have a picture with that name
		if ('slideshow' == $names['picture']) {
			return array('level' => 'album','mode' => 'slideshow','id' => $album['id']);
		}
		
		// deal with http://plogger/collection/album/sorted/field/asc and friends
		if ('sorted' == $names['picture']) {
			if (isset($names['arg1'])) {
				$_SESSION['plogger_sortby'] = $names['arg1'];
			}
			
			if (isset($names['arg2'])) {
				$_SESSION['plogger_sortdir'] = $names['arg2'];
			}
			
			return array('level' => 'album','id' => $album['id']);
		}
		
		$rv = array('level' => 'album','id' => $album['id']);
	}
	
	if (!empty($names["picture"])) {
		$sql = "SELECT *
			FROM `".TABLE_PREFIX."pictures`
			WHERE `caption`='".mysql_real_escape_string($names["picture"])."'
				AND `parent_album`=".intval($album["id"]);
		$result = run_query($sql);
		
		$picture = mysql_fetch_assoc($result);
		
		// no such caption, perhaps we have better luck with path?
		if (!$picture) {
			$filepath = join("/",$names);
			$sql = "SELECT *
				FROM `".TABLE_PREFIX."pictures`
				WHERE `path`='" . mysql_real_escape_string($filepath)."'
					AND `parent_album`=".intval($album["id"]);
			$result = run_query($sql);
			$picture = mysql_fetch_assoc($result);
		}
		
		// no dice, fall back to album
		if (!$picture) {
			return $rv;
		}
		
		$rv = array("level" => "picture", "id" => $picture["id"]);
	}
	
	return $rv;
}

function generate_pagination($url, $current_page, $items_total, $items_on_page, $extra_params = ''){
	$output = '';
	
	if (!isset($GLOBALS["total_pictures"])) $GLOBALS["total_pictures"] = 0;
	
	if (($items_total == 0) && ($GLOBALS["total_pictures"] > 0)) {
		$items_total = $GLOBALS["total_pictures"];
	}
	
	$num_pages = ceil($items_total / $items_on_page);
	
	// if adding arguments to mod_rewritten urls, then I need ? (question mark) before the arguments
	// otherwise I want &amp;
	$last = substr($url,-1);
	
	if ($last == "/") {
		//$url = substr($url,0,-1);
		$separator = "?";
	} else {
		$separator = "&amp;";
	}
	
	if ($num_pages > 1){
		if ($current_page > 1){
			$output .= ' <a accesskey="," href="'.$url.$separator.'plog_page='.($current_page - 1).$extra_params.'">&laquo;</a> ';
		}
		
		for ($i = 1; $i <= $num_pages; $i++){
			if ($i == $current_page){
				$output .= '<span class="page_link"> ['.$i.'] </span>';
			} else{
				$output .= '<a href="'.$url.$separator.'plog_page='.$i.$extra_params.'" class="page_link">'.$i.'</a> ';
			}
		}
		
		if ($current_page != $num_pages){
			$output .= ' <a accesskey="." href="'.$url.$separator.'plog_page='.($current_page + 1).$extra_params.'">&raquo;</a> ';
		}
	}
	
	return $output;
}

// sanitize filename by replacing international characters with underscores
function sanitize_filename($str) {
	// allow only alphanumeric characters, hyphen, [, ], dot and apostrophe in file names
	// the rest will be replaced
	return preg_replace("/[^\w|\.|'|\-|\[|\]]/","_",$str);
}

function generate_url($level, $id, $arg = array(), $plaintext = false){
	global $config;
	
	$rv = '';
	
	if ($config["use_mod_rewrite"]){
		if ($level == "collection"){
			$query = "SELECT `path` FROM `".TABLE_PREFIX."collections` WHERE `id`=".intval($id);
			$result = run_query($query);
			$row = mysql_fetch_assoc($result);
			$rv = $config["baseurl"].rawurlencode($row["path"]);
		} else if ($level == "album") {
			$query = "SELECT
					`c`.`path` AS `collection_path`,
					`a`.`path` AS `album_path`
				FROM `".TABLE_PREFIX."albums` AS `a`
					LEFT JOIN `".TABLE_PREFIX."collections` AS `c` ON `a`.`parent_id`=`c`.`id`
				WHERE `a`.`id`=".intval($id);
			$result = run_query($query);
			$row = mysql_fetch_assoc($result);
			
			$rv = $config["baseurl"].rawurlencode($row["collection_path"]) . '/' . rawurlencode($row["album_path"]);
			
			// I need to give additional arguments to the url-s
			if (sizeof($arg) > 0) {
				foreach($arg as $aval) {
					$rv .= "/".$aval;
				}
			}
		} else if ($level == "picture") {
			$pic = get_picture_by_id($id);
			$album = $pic["parent_album"];
			$rv = $config["baseurl"].$pic["path"];
		}
	} else {
		if ($level == "collection"){
			return $config['baseurl'].'?level=collection&amp;id='.$id;
		} else if ($level == "album") {
			$rv = $config['baseurl'].'?level=album&amp;id='.$id;
			if (sizeof($arg) > 0) {
				foreach($arg as $akey => $aval) {
					// mod_rewrite url-s need /sorted in them, the old style ones do not.
					// this temporary workaround removes the 'sorted' string
					if ($aval != 'sorted') {
						$rv .= "&amp;$akey=$aval";
					}
				}
			}
		} else if ($level == "picture") {
			$rv = $config['baseurl'].'?level=picture&amp;id='.$id;
		}
	}

	/*	
	if (!$plaintext){
		$rv = str_replace("&amp;","&",$rv);
	}
	*/
	
	return $rv;
}

function add_comment($parent_id,$author,$email,$url,$comment) {
	global $config;
	
	if (empty($config["allow_comments"])) {
		return array("errors" => "Comments disabled");
	}
	
	if (empty($author) || empty($email)) {
		return array("errors" => "Your comment did not post!  Please fill the required fields.");
	}
	
	$ip = $_SERVER["REMOTE_ADDR"];
	$host = gethostbyaddr($ip);
	
	// I want to use the original unescaped values later - to send the email
	$sql_author = mysql_real_escape_string($author);
	$sql_email = mysql_real_escape_string($email);
	$sql_url = mysql_real_escape_string($url);
	$sql_comment = mysql_real_escape_string($comment);
	$sql_ip = mysql_real_escape_string($ip);
	
	$parent_id = intval($parent_id);
	
	$result = array();
	
	$picdata = get_picture_by_id($parent_id);
	
	if (empty($picdata)) {
		return array("errors" => "Could not post comment - no such picture");
	}
	
	if (empty($picdata["allow_comments"])) {
		return array("errors" => "Comments disabled");
	}
	
	if ($config["comments_moderate"] == 1) {
		$approved = 0;
		$notify_msg = " (awaiting your approval)";
	} else {
		$approved = 1;
	}
	
	// right now all comments will be approved, spam protection can be implemented later
	$query = "INSERT INTO `".TABLE_PREFIX."comments` SET 
			`author`='$sql_author', 
			`email`='$sql_email', 
			`url`='$sql_url', 
			`date`=NOW(),
			`comment`='$sql_comment',
			`parent_id`='$parent_id', 
			`approved` = '$approved', 
			`ip` = '$ip'";
	$result = mysql_query($query);
	
	if (!$result) {
		return array("errors" => "Could not post comment " . mysql_error());
	}
	
	// XXX: admin e-mail address should be validated
	if ($config["comments_notify"] && $config["admin_email"]) {
		// create and send notify mail message
		$msg = "New comment posted for picture " . basename($picdata['path']) . " $notify_msg\n\n";
		$msg .= "Author: $author (IP: $ip, $host)\n";
		$msg .= "E-mail: $email\n";
		$msg .= "URI: $url\n\n";
		$msg .= "Comment:\n$comment\n\n";
		$msg .= "You can see all the comments for this picture here:\n";
		$picurl = generate_url("picture",$parent_id);
		$msg .= $picurl;
		mail($config['admin_email'],SmartStripSlashes($config['gallery_name']) . ': new comment from '.$author,$msg,"From: $email");
	}
	
	return array("result" => "Comment added.");
}

// Begin basic Plogger API functions

// plogger_list_categories()
// This function will create a list of nested categorical links
// for use in sidebars

function plogger_list_categories($class) {
	// first select id and name for all collections
	$query = "SELECT * FROM ".TABLE_PREFIX."collections";
	$result = run_query($query);
	
	$output = "<ul class=\"$class\">";
	
	// loop through each collection, output child albums
	while ($row = mysql_fetch_assoc($result)) {
		// output collection name
		$collection_link = '<a href="'.generate_url("collection",$row['id']).'">'.$row['name'].'</a>';
		$output .= "<li>$collection_link</li>";
		
		// loop through child albums
		$query = "SELECT * FROM ".TABLE_PREFIX."albums WHERE parent_id = '$row[id]' ORDER BY name DESC";
		
		$output .= '<ul>';
		while ($albums = mysql_fetch_assoc($result)) {
			$album_link = '<a href="'.generate_url("albums",$albums['id']).'">'.$albums['name'].'</a>';
			$output .= "<li>$album_link</li>";
		}
		
		$output .= '</ul>';
	}
	
	$output .= '</ul>';
	
	echo $output;
}

function is_allowed_extension($ext) {
	return in_array(strtolower($ext),array("jpg","gif","png","bmp"));
}

function plogger_init() {
	global $config;
	
	$page = isset($_GET["plog_page"]) ? intval($_GET["plog_page"]) : 1;
	$from = ($page - 1) * $config["thumb_num"];
	
	if ($from < 0) {
		$from = 0;
	}
	
	$lim = $config["thumb_num"];
	$id = $GLOBALS["plogger_id"];
	
	if ($GLOBALS["plogger_level"] == "search")	{
		plogger_init_search(array(
			'searchterms' => $_GET['searchterms'],
			'from' => $from,
			'limit' => $lim));
	} else if ($GLOBALS["plogger_level"] == "album") {
		plogger_init_pictures(array(
			'type' => 'album',
			'value' => $id,
			'from' => $from,
			'limit' => $lim,
			'sortby' => isset($_SESSION['plogger_sortby']) ? $_SESSION['plogger_sortby'] : '',
			'sortdir' => isset($_SESSION['plogger_sortdir']) ? $_SESSION['plogger_sortdir'] : ''));
	} else if ($GLOBALS["plogger_level"] == "collection") {
		plogger_init_albums(array(
			'from' => $from,
			'limit' => $lim,
			'collection_id' => $id,
			'sortby' => !empty($config['album_sortby']) ? $config['album_sortby'] : 'id',
			'sortdir' => !empty($config['album_sortdir']) ? $config['album_sortdir'] : 'DESC'));
	} else if ($GLOBALS["plogger_level"] == "picture") {
		// first lets load the thumbnail of the picture at the correct size
		plogger_init_picture(array('id' => $id));
	} else {
		// Show all of the collections	
		plogger_init_collections(array(
			'from' => $from,
			'limit' => $lim,
			'sortby' => !empty($config['collection_sortby']) ? $config['collection_sortby'] : 'id',
			'sortdir' => !empty($config['collection_sortdir']) ? $config['collection_sortdir'] : 'DESC'));
	}
}

function plogger_init_picture($arr) {
	$id = intval($arr['id']);
	$sql = "SELECT `id`, `parent_album` FROM `".TABLE_PREFIX."pictures` WHERE `id`=".$id;
	$result = run_query($sql);
	
	$row = mysql_fetch_assoc($result);
	
	if (!$row) {
		return false;
	}
	
	// generate a list of all image id-s so proper prev/next links can be created. This should be a 
	// fast query, even for big albums.
	$image_list = array();
	
	$sql = "SELECT `id` FROM `".TABLE_PREFIX."pictures` WHERE `parent_album`=".$row["parent_album"];
	
	// determine sort ordering
	switch ($_SESSION["plogger_sortby"]){
		case 'number_of_comments':
			$sql = "SELECT
					`p`.`id`,
					COUNT(`comment`) AS `num_comments`
				FROM `".TABLE_PREFIX."pictures` AS `p`
					LEFT JOIN `".TABLE_PREFIX."comments` AS `c` ON `p`.`id`=`c`.`parent_id`
				WHERE `parent_album`=".$row["parent_album"]."
				GROUP BY `p`.`id`
				ORDER BY `num_comments` ";
			break;
		case 'caption':
			$sql .= " ORDER BY `caption` ";
			break;
		case 'date_taken':
			$sql .= " ORDER BY `EXIF_date_taken` ";
			break;
		case 'filename':
			$sql .= " ORDER BY `path` ";
			break;
		case 'date':
		default:
			$sql .= " ORDER BY `date_submitted` ";
			break;
	}
	
	switch (strtoupper($_SESSION["plogger_sortdir"])){
		case 'ASC':
			$sql .= " ASC";
			break;
		case 'DESC':
		default:
			$sql .= " DESC";
			break;
	}
	
	$result = run_query($sql);
	
	while ($image = mysql_fetch_assoc($result)) {
		$image_list[] = $image["id"];
	}
	
	$GLOBALS["image_list"] = $image_list;
	
	// first lets load the thumbnail of the picture at the correct size
	$sql = "SELECT *,
			UNIX_TIMESTAMP(`date_submitted`) AS `unix_date_submitted`,
			UNIX_TIMESTAMP(`EXIF_date_taken`) AS `unix_exif_date_taken`
		FROM `".TABLE_PREFIX."pictures`
		WHERE `id`=$id";
	$result = run_query($sql);
	
	$GLOBALS["available_pictures"] = mysql_num_rows($result);
	$GLOBALS["picture_counter"] = 0;
	$GLOBALS["picture_dbh"] = $result;
	
	// lets load up the comments for the current picture here as well
	$query = "SELECT *,
			UNIX_TIMESTAMP(`date`) AS `unix_date`
		FROM `".TABLE_PREFIX."comments` 
		WHERE `parent_id`=".intval($id)."
			AND `approved`=1";
	$result = run_query($query) or die(mysql_error());
	
	$GLOBALS["available_comments"] = mysql_num_rows($result);
	$GLOBALS["comment_counter"] = 0;
	$GLOBALS["comment_dbh"] = $result;
}

// arr['type'] id|album|collection|latest
// arr['value'] - argument to 

// arr['sortby'] - what field is used for sorting
// arr['sortdir'] - asc|desc

// arr['from'] - where to start in the result set- default to 0
// arr['limit'] - how many pictures to return

function plogger_init_pictures($arr) {
	$sql = "
		FROM `".TABLE_PREFIX."pictures` `p`
			LEFT JOIN `".TABLE_PREFIX."comments` `c` ON `p`.`id`=`c`.`parent_id`";
	
	$type = $arr['type'];
	
	// right now only single id is supported, maybe I want to specify multiple id-s as well
	$value = ($arr['value'] > 0) ? $arr['value'] : -1;
	
	if ('collection' == $type) {
		$sql .= " WHERE p.`parent_collection` = ".$value;
	} elseif ('id' == $type) {
		$sql .= " WHERE p.`id` = ".$value;
	} elseif ('album' == $type) {
		$sql .= " WHERE p.`parent_album` = ".$value;
	} elseif ('latest' == $type) {
		// add nothing, only limit takes effect
	} else {
		// so what do you want anyway? 
		return 0;
	}
	
	$from = 0;
	$limit = 20;
	
	if (isset($arr["from"]) && $arr["from"] > 0) {
		$from = $arr["from"];
	}
	
	// enforce hard-coded max limit
	if (isset($arr['limit']) && $arr['limit'] > 0 && $arr['limit'] <= 100) {
		$limit = $arr['limit'];
	}
	
	$result = run_query("SELECT COUNT(DISTINCT p.`id`) AS cnt " . $sql);
	$row = mysql_fetch_assoc($result);
	
	$GLOBALS["total_pictures"] = $row["cnt"];
	
	// grouping is needed to get comment count
	$sql .= " GROUP BY p.`id`";
	
	// query database and retreive all pictures withing selected album
	// and what about searching? well, what about it ..
	$sort_fields = array(
		'number_of_comments' => 'num_comments',
		'caption' => 'caption',
		'date_taken' => 'EXIF_date_taken',
		'filename' => 'path',
		'date' => 'date_submitted',
		'id' => 'id',
	);
	
	// this is the default
	$sortby = 'date';
	if (isset($arr['sortby']) && isset($sort_fields[$arr['sortby']])) {
		$sortby = $arr['sortby'];
	}
	
	$sortby = $sort_fields[$sortby];
	$sql .= " ORDER BY `$sortby` ";
	
	$sortdir = ' DESC';
	
	if (isset($arr['sortdir']) && (strcasecmp('asc',$arr['sortdir']) === 0)) {
		$sortdir = ' ASC';
	}
	
	$sql .= $sortdir;
	
	// again, this is needed because of the comment counting
	$sql .= ",p.`id` DESC ";
	
	$sql .= " LIMIT ".$from.",".$limit;
	
	$result = run_query("SELECT p.*,
			UNIX_TIMESTAMP(`date_submitted`) AS `unix_date_submitted`,
			UNIX_TIMESTAMP(`EXIF_date_taken`) AS `unix_exif_date_taken`,
			COUNT(`comment`) AS `num_comments` " . $sql);
	
	$GLOBALS["available_pictures"] = mysql_num_rows($result);
	$GLOBALS["picture_counter"] = 0;
	$GLOBALS["picture_dbh"] = $result;
}

// arr['searchterms'] - what to search for, space separates different serach terms
// arr['from'] - where to start in the result set, default 0
// arr['limit'] - and how many items to return, default 20
// arr['sortby'] -
// arr['sortdir'] - 

function plogger_init_search($arr) {
	$terms = explode(" ",$arr['searchterms']);
	$from = 0;
	$limit = 20;
	
	if (isset($arr['from']) && $arr['from'] > 0) {
		$from = $arr['from'];
	}
	
	// enforce hard-coded max limit
	if (isset($arr['limit']) && $arr['limit'] > 0 && $arr['limit'] <= 100) {
		$limit = $arr['limit'];
	}
	
	$query = " FROM `".TABLE_PREFIX."pictures` p LEFT JOIN `".TABLE_PREFIX."comments` c
		ON p.`id` = c.`parent_id` ";
	
	if ((count($terms) != 1) || ($terms[0] != '')){
		$query .= " WHERE ( ";
		foreach ($terms as $term) {
			$query .= "
				`path` LIKE '%".mysql_escape_string($term)."%' OR
				`comment` LIKE '%".mysql_escape_string($term)."%' OR
				`description` LIKE '%".mysql_escape_string($term)."%' OR
				`caption` LIKE '%".mysql_escape_string($term)."%' OR ";
		}
		
		$query = substr($query, 0, strlen($query) - 3) .") ";
	} else {
		// no search terms? no results either
		$query .= " WHERE 1 = 0";
	}
	
	$sort_fields = array('date_submitted','id');
	$sortby = 'date_submitted';
	
	if (isset($arr['sortby']) && in_array($arr['sortby'],$sort_fields)) {
		$sortby = $arr['sortby'];
	}
	
	$sortdir = ' DESC';
	
	if (isset($arr['sortdir']) && 'asc' == $arr['sortdir']) {
		$sortdir = ' ASC';
	}
	
	$result = run_query("SELECT COUNT(DISTINCT p.`id`) AS cnt " . $query);
	$row = mysql_fetch_assoc($result);
	
	$GLOBALS["total_pictures"] = $row["cnt"];
	// and I need sort order here as well
	// from and limit too
	$result = run_query("SELECT `caption`,`path`,p.`id`,c.`comment`,
				UNIX_TIMESTAMP(`date_submitted`) AS `unix_date_submitted` ".$query .
				" GROUP BY p.`id` ORDER BY `$sortby` $sortdir LIMIT $from,$limit");
	
	$GLOBALS["available_pictures"] = mysql_num_rows($result);
	$GLOBALS["picture_counter"] = 0;
	$GLOBALS["picture_dbh"] = $result;
}

function plogger_init_collections($arr) {
	$sql = "SELECT COUNT(DISTINCT `parent_collection`) AS `num_items`
				FROM `".TABLE_PREFIX."pictures`";
	$result = run_query($sql);
	$num_items = mysql_result($result, 'num_items');
	$GLOBALS["total_pictures"] = $num_items;
	
	// create a list of all non-empty collections. Could be done with subqueries, but
	// MySQL 4.0 does not support those
	
	// -1 is just for the case there are no collections at all
	$image_count = array(-1 => -1);
	$album_count = array();
	
	// 1. create a list of all albums with at least one photo
	$sql = "SELECT parent_collection,COUNT(*) AS imagecount
				FROM `".TABLE_PREFIX."pictures` GROUP BY parent_collection";
	$result = run_query($sql);
	while($row = mysql_fetch_assoc($result)) {
		$image_count[$row["parent_collection"]] = $row["imagecount"];
	}
	
	$imlist = join(",",array_keys($image_count));
	
	$cond = '';
	
	if (empty($arr['all_collections'])) {
		$cond = " WHERE parent_id IN ($imlist) ";
	}
	
	$sql = "SELECT parent_id,COUNT(*) AS albumcount
				FROM `".TABLE_PREFIX."albums`
				$cond
				GROUP BY parent_id";
	
	$result = run_query($sql);
	while($row = mysql_fetch_assoc($result)) {
		$album_count[$row["parent_id"]] = $row["albumcount"];
	}
	
	$GLOBALS["album_count"] = $album_count;
	
	// I need to determine correct arguments for LIMIT from the given page number
	$from = $arr['from'];
	$lim = $arr['limit'];
	
	$cond = "";
	
	// by default only collections with pictures are returned
	// override that with passing all_collections as an argument to 
	// this function
	if (empty($arr['all_collections'])) {
		$cond = " WHERE id IN ($imlist) ";
	}
	
	$ordering = " ORDER BY $arr[sortby] $arr[sortdir] ";
	
	$sql = "SELECT * FROM `".TABLE_PREFIX."collections`
				$cond $ordering LIMIT $from,$lim";
	$result = run_query($sql);
	
	$GLOBALS["available_collections"] = mysql_num_rows($result);
	$GLOBALS["collection_counter"] = 0;
	$GLOBALS["collection_dbh"] = $result;
}

function plogger_init_albums($arr) {
	$collection_id = intval($arr['collection_id']);
	$sql = "SELECT COUNT(DISTINCT `parent_album`) AS `num_items`
				FROM `".TABLE_PREFIX."pictures`
				WHERE `parent_collection` = '" . $collection_id . "'";

	$result = run_query($sql);
	$num_items = mysql_result($result, 'num_items');
	
	$GLOBALS["total_pictures"] = $num_items;	

	// create a list of all non-empty albums. Could be done with subqueries, but
	// MySQL 4.0 does not support those

	// -1 is just for the case there are no albums at all. Shouldn't happen if user
	// follows links, but let's deal with it anyway
	$image_count = array(-1 => -1);
	// 1. create a list of all albums with at least one photo
	$sql = "SELECT parent_album,COUNT(*) AS imagecount FROM `".TABLE_PREFIX."pictures` GROUP BY parent_album";
	$result = run_query($sql);
	while($row = mysql_fetch_assoc($result)) {
		$image_count[$row["parent_album"]] = $row["imagecount"];
	}

	$imlist = join(",",array_keys($image_count));

	$from = intval($arr['from']);
	$lim = intval($arr['limit']);

	$cond = '';
	if (empty($arr['all_albums'])) {
		$cond = " AND id IN ($imlist) ";
	}

	$order = " ORDER BY $arr[sortby] $arr[sortdir] ";

	$sql = "SELECT * FROM `".TABLE_PREFIX."albums`
			WHERE `parent_id` = '$collection_id' $cond $order LIMIT $from,$lim";

	$result = run_query($sql);
	$GLOBALS["available_albums"] = mysql_num_rows($result);
	$GLOBALS["album_counter"] = 0;
	$GLOBALS["album_dbh"] = $result;

}

function plogger_get_header() {
	global $config;
	if (file_exists(THEME_DIR . '/header.php')) {
		include(THEME_DIR . '/header.php');
	} else {
		include($config['basedir'] . '/themes/default/header.php');
	}
}

function plogger_get_footer() {
	global $config;
	if (file_exists(THEME_DIR . '/footer.php')) {
		include(THEME_DIR . '/footer.php');
	} else {
		include($config['basedir'] . '/themes/default/footer.php');
	}
}

function plogger_download_selected_button() {
	global $config;
	
	if ($GLOBALS['plogger_level'] != "picture" && $GLOBALS['plogger_mode'] != "slideshow" && $config["allow_dl"]) {
			return '<form action="'.$config['gallery_url'].'plog-download.php" method="post"><input class="submit" type="submit" name="download_selected" value="Download Selected" />';
	}
}

function plogger_print_button() {
	global $config;
	$id = $GLOBALS["plogger_id"];
	
	if ($GLOBALS['plogger_level'] == "picture" && $config["allow_print"]) {
  		return '<a class="print" href="' . $config["gallery_url"] . 'plog-print.php?id='.$id.'">Print Image</a>';
	}
}

function plogger_link_back () {
	return	'<div id="link-back"><a href="http://www.plogger.org/">Powered by Plogger!</a></div>';
}

function plogger_rss_link() {
	global $config;
	
	if ($config["use_mod_rewrite"]) {
		global $path;
		if (isset($path)) 
			$rss_link .= "http://".$_SERVER["SERVER_NAME"]."/".SmartStripSlashes(substr($path,1))."/feed/";
		else
			$rss_link .= $config['gallery_url']."feed/";
				
	} 
	else {
		$rss_link .= $config["gallery_url"] . "plog-rss.php?level=".$GLOBALS['plogger_level']."&amp;id=".$GLOBALS['plogger_id'];
	}

	if ($GLOBALS['plogger_level'] == "search") { // append the search terms
		$separator = $config["use_mod_rewrite"] ? "?" : "&amp;";
		$rss_link .= $separator . "searchterms=".$_GET["searchterms"];
	}
	
	return $rss_link;
}

function plogger_rss_feed_button () {
	global $config;
	
	if ($GLOBALS['plogger_mode'] != "slideshow" && $GLOBALS['plogger_level'] != "picture") {
		$rss_link = "";
		// change the tooltip message to reflect the nature of the RSS aggregate link.
		if ($GLOBALS['plogger_level'] != "") 
				$rss_tooltip = "RSS 2.0 subscribe to this " .$GLOBALS["plogger_level"];
		else
				$rss_tooltip = "RSS 2.0 subscribe to all images";
	
	
		$rss_link = plogger_rss_link();
	
		$rss_tag = '<a href="'.$rss_link.'"><img id="rss-image" src="' . $config["gallery_url"] . 'graphics/rss.gif" title="'.					$rss_tooltip.'" alt="RSS 2.0 Feed"/></a>';
		
		return $rss_tag;
	}

}

function plogger_slideshow_link() {
	
	global $config;
	$id = $GLOBALS["plogger_id"];
	$ss_tag = "";
	if ($GLOBALS['plogger_mode'] != "slideshow") {
		if ($GLOBALS['plogger_level'] == "album") {
			$ss_url = generate_url('album',$GLOBALS['plogger_id'],array('mode' => 'slideshow'));
			$ss_tag = "<a href=\"$ss_url\">View as Slideshow</a>";
		}

		if ($GLOBALS['plogger_level'] == "search") {
			$ss_url = $config['baseurl'] . '?level=search&amp;searchterms=' . $_GET['searchterms'];
			$ss_url .= "&amp;mode=slideshow";
			$ss_tag = "<a href=\"$ss_url\">View as Slideshow</a>";
		}
		
	}
	return $ss_tag;
}

function plogger_sort_control() {

	if ($GLOBALS['plogger_mode'] != 'slideshow')
		return generate_sortby($GLOBALS['plogger_level'],$GLOBALS['plogger_id']).generate_sortdir($GLOBALS['plogger_level'],$GLOBALS['plogger_id']);
	
}

function plogger_pagination_control() {
	global $config;
	
	if ($GLOBALS['plogger_mode'] != 'slideshow') {
		$page = isset($_GET["plog_page"]) ? intval($_GET["plog_page"]) : 1;
		
		if ($GLOBALS['plogger_level'] == "search") {
			$searchterms = urlencode($_GET["searchterms"]);
			$p_url = $config['baseurl']."?level=search&amp;searchterms=$searchterms&amp;id=".$GLOBALS["plogger_id"];
		} 
		else {
			if ($GLOBALS['plogger_level']) {
				$p_url = generate_url($GLOBALS['plogger_level'], $GLOBALS['plogger_id']);
				if ($config["use_mod_rewrite"]) {
					$p_url .= "/";
				}
			}
			else {
				$p_url = $config["baseurl"];
			}
		}
		
		switch($GLOBALS['plogger_level']) {
			case 'search':
				$num_items = $GLOBALS["total_pictures"];
				break;

			case 'album':
				$num_items = plogger_album_picture_count();
				break;

			case 'collection':
				$num_items = plogger_collection_album_count();
				break;

			default:
				$num_items = plogger_count_collections();
				break;
		}
		
		return generate_pagination($p_url, $page, $num_items, $config["thumb_num"]);
	}

}

/*** The following functions can only be used inside the Picture loop ***/
function plogger_has_pictures() {
	return $GLOBALS["picture_counter"] < $GLOBALS["available_pictures"];
}

function plogger_comments_on() {
	global $config;
	return $config["allow_comments"];
}

function plogger_picture_allows_comments() {
		
	$picture = $GLOBALS["current_picture"];
	$id = $picture["id"];
 	return $picture["allow_comments"];
}

function plogger_load_picture() {
	$rv = mysql_fetch_assoc($GLOBALS["picture_dbh"]);
	$GLOBALS["picture_counter"]++;
	$GLOBALS["current_picture"] = $rv;
	return $rv;
}

function plogger_picture_has_comments() {
	return $GLOBALS["comment_counter"] < $GLOBALS["available_comments"];
}

function plogger_load_comment() {
	$rv = mysql_fetch_assoc($GLOBALS["comment_dbh"]);
	$GLOBALS["comment_counter"]++;
	$GLOBALS["current_comment"] = $rv;
	return $rv;
}

function plogger_get_comment_date($format = false) {
	global $config;
	$comment = $GLOBALS["current_comment"];
	if (empty($format)) {
		$format = $config["date_format"];
	}
	return date($format,$comment["unix_date"]);
}

function plogger_get_comment_id() {
	$comment = $GLOBALS["current_comment"];
	return $comment["id"];

}

function plogger_get_comment_email() {
	$comment = $GLOBALS["current_comment"];
	return $comment["email"];

}

function plogger_get_comment_url() {
	$comment = $GLOBALS["current_comment"];
	return htmlspecialchars($comment["url"]);
}

function plogger_get_comment_author() {
	$comment = $GLOBALS["current_comment"];
	return htmlspecialchars(SmartStripSlashes($comment["author"]));
}

function plogger_get_comment_text() {
	$comment = $GLOBALS["current_comment"];
	return htmlspecialchars(SmartStripSlashes($comment["comment"]));
}

function plogger_comment_post_error() {
	if (isset($_SESSION['comment_post_error'])) {
		unset($_SESSION['comment_post_error']);
		return 1;
	}
	else
		return 0;
}

function plogger_comment_moderated() {
	if (isset($_SESSION['comment_moderated'])) {
		unset($_SESSION['comment_moderated']);
		return 1;
	}
	else
		return 0;
}


function plogger_get_picture_url() {
	$row = $GLOBALS["current_picture"];
	return generate_url("picture",$row["id"]);
}

function plogger_get_picture_id() {
	$row = $GLOBALS["current_picture"];
	return $row["id"];
}

function plogger_get_picture_thumb($type = THUMB_SMALL) {
	$pic = $GLOBALS["current_picture"];
	return generate_thumb($pic['path'], $pic['id'], $type);
}

function plogger_get_picture_caption() {
	if (!empty($GLOBALS["current_picture"]["caption"]))
		return SmartStripSlashes($GLOBALS["current_picture"]["caption"]);
	else
		return "&nbsp;";
}

function plogger_get_thumbnail_info() {
	global $thumbnail_config;
	global $config;
	
	$thumb_config = $thumbnail_config[THUMB_SMALL];
	
	$base_filename = sanitize_filename(basename($GLOBALS["current_picture"]["path"]));
	$prefix = $thumb_config['filename_prefix'] . $GLOBALS["current_picture"]["id"] . "-";
	
	$thumbpath = $config['basedir'] . 'thumbs/'.$prefix.$base_filename;
	$image_info = getimagesize($thumbpath);
	
	return $image_info;
}

function plogger_get_source_picture_path() {
	global $config;
	return $config['basedir'].'images/'.SmartStripSlashes($GLOBALS["current_picture"]["path"]);
}

function plogger_get_picture_description() {
	return htmlspecialchars(SmartStripSlashes($GLOBALS["current_picture"]["description"]));
}

function plogger_get_picture_descriptionhtml() {
	return SmartStripSlashes($GLOBALS["current_picture"]["description"]);
}

function plogger_picture_comment_count() {
	$row = $GLOBALS["current_picture"];
	$comment_query = "SELECT COUNT(*) AS `num_comments` FROM `".TABLE_PREFIX."comments` 
	WHERE approved = 1 AND `parent_id`='".$row["id"]."'";
	
	$comment_result = run_query($comment_query);
	$num_comments = mysql_result($comment_result, 0, 'num_comments');
	return $num_comments;
}

function plogger_get_picture_date($format = '',$submitted = 0) {
	global $config;
	$row = $GLOBALS['current_picture'];
	if ($submitted) {
		$date_taken = $row['unix_date_submitted'];
	}
	else {
		$date_taken = !empty($row['unix_exif_date_taken']) ? $row['unix_exif_date_taken'] : $row['unix_date_submitted'];
	}
	if (!$format) {
		$format = $config['date_format'];
	}
	return date($format,$date_taken);
}

function plogger_get_source_picture_url() {
	global $config;
	return (!empty($config['allow_fullpic'])) ? $config["baseurl"].'images/'.SmartStripSlashes($GLOBALS["current_picture"]["path"]) : "#";
}

/**
 * @author derek@plogger.org
 * @return string html list of thumbnails
 */
function plogger_get_thumbnail_nav() {
	global $config;
	if(empty($config["enable_thumb_nav"])) return ''; // return if thumbnail nav turned off
	$image_list = $GLOBALS["image_list"];
	$array_length = count($image_list); // store array length
	$curr = $GLOBALS["current_picture"];
	$pos_array = array_keys($image_list,$curr["id"]);
	$curr_pos = $pos_array[0];
	$range = (isset($config["thumb_nav_range"])) ? $config["thumb_nav_range"] : 0;
	if($range == 0) { // if length is 0, use all thumbs
		// get_picture_by_id modified to take arrays, so pass the whole array
		$thumb_pic_array = get_picture_by_id($image_list);
	} else { // else, add a thumb each side of current for each value of $config['thumb_nav_range']
		$thumb_nav_array = array($curr['id']);
		for($i=1;$i<$range+1;$i++) {		
			// use unshift() to add to the beginning, push() to add to the end
			// check that we haven't run out of images below: that (current image - offset) >= 0
			if($curr_pos - $i >= 0) {
				unset($newpic); // php has problems with reassigning via iteration
				$newpic = $image_list[$curr_pos-$i];
				if(!empty($newpic)) array_unshift($thumb_nav_array, $newpic);
			} else { // grab from the end of the array
				unset($newpic); // php has problems with reassigning via iteration
				$newpic = $image_list[$array_length+($curr_pos-$i)]; // adding a negative value, don't fret
				if(!empty($newpic)) array_unshift($thumb_nav_array, $newpic);
			}
			// check that we haven't run out of images above: (current image + offset) <= (total images)
			if($array_length-1 >= ($curr_pos+$i)) {
				unset($newpic); // php has problems with reassigning via iteration
				$newpic = $image_list[$curr_pos+$i];
				if(!empty($newpic)) array_push($thumb_nav_array, $newpic);
			} else { // grab from the beginning of the array
				unset($newpic); // php has problems with reassigning via iteration
				$newpic = $image_list[($curr_pos + $i) - ($array_length)];
				if(!empty($newpic)) array_push($thumb_nav_array, $newpic);
			}
		}
		$thumb_pic_array = array();
		foreach($thumb_nav_array as $thumb_nav_value) {
			
			array_push($thumb_pic_array,get_picture_by_id($thumb_nav_value));
		}
	}
	return plogger_format_thumb_nav($thumb_pic_array);
}

function plogger_format_thumb_nav($thumb_nav_array) {
	$thumb_nav_out = "\t<ul id='thumb-nav'>\n";
	foreach($thumb_nav_array as $current_thumb_nav) {
		unset($title);unset($img_path);unset($class);unset($link); // php has problems with reassigning via iteration
		$title = (!empty($current_thumb_nav["caption"])) ? $current_thumb_nav["caption"] : "";
		$img_path = generate_thumb($current_thumb_nav["path"], $thumbnail_config[THUMB_NAV]['prefix'], THUMB_NAV);
		$class = ($current_thumb_nav["id"] == $GLOBALS["current_picture"]["id"]) ? "current" : "";
		$link = generate_url("picture",$current_thumb_nav["id"]);
		$thumb_nav_out .= plogger_thumb_nav_item($link, $title, $img_path, $class);
	}
	$thumb_nav_out .= "\t</ul>\n";
	return $thumb_nav_out;
}

function plogger_thumb_nav_item($link, $title, $img_path, $class = '') {
	return "\t\t<li class='$class'><a href='$link' title='$title'><img src='$img_path' /></a></li>\n";
}

function plogger_get_next_picture_url() {
	$image_list = $GLOBALS["image_list"];
	$row = $GLOBALS["current_picture"];
	$current_picture = array_search($row['id'],$image_list);
	$next_link = '';
	if ($current_picture < sizeof($image_list)-1)
	{
		$next_link = generate_url("picture",$image_list[$current_picture+1]);
	}
	return $next_link;
}

function plogger_get_prev_picture_url() {
	$image_list = $GLOBALS["image_list"];
	$row = $GLOBALS["current_picture"];
	$current_picture = array_search($row['id'],$image_list);
	$prev_link = '';
	if ($current_picture > 0) {
		$prev_link = generate_url("picture",$image_list[$current_picture-1]);
	}
	return $prev_link;
}
/*** End of Picture loop functions ***/


/*** The following functions can only be used inside the Collections loop ***/
function plogger_load_collection() {
	$rv = mysql_fetch_assoc($GLOBALS["collection_dbh"]);
	$GLOBALS["collection_counter"]++;
	$GLOBALS["current_collection"] = $rv;
	return $rv;
}

function plogger_has_collections() {
	return $GLOBALS["collection_counter"] < $GLOBALS["available_collections"];
}

function plogger_get_collection_url() {
	$row = $GLOBALS["current_collection"];
	return generate_url("collection",$row["id"]);
}

function plogger_get_collection_thumb() {
	$rv = $GLOBALS["current_collection"];
	// figure out the thumbnail as well
	$thumb_query = "SELECT * FROM `".TABLE_PREFIX."pictures` WHERE ";
	if ($rv["thumbnail_id"] > 0)
		$thumb_query .= " `id`=".$rv["thumbnail_id"];
	else
		$thumb_query .= " `parent_collection`='".$rv["id"]."' ORDER BY `id` DESC LIMIT 1";
	
	$thumb_result = run_query($thumb_query);
	$thumb_data = mysql_fetch_assoc($thumb_result);
	if ($thumb_data) {
		$rv["thumbnail_id"] = $thumb_data["id"];
		$rv["thumbnail_path"] = $thumb_data["path"];
	}
	return generate_thumb($rv['thumbnail_path'], $rv['thumbnail_id'], THUMB_SMALL);
}


function plogger_collection_album_count() {
	if (isset($GLOBALS["album_count"][$GLOBALS["current_collection"]["id"]])) {
		return $GLOBALS["album_count"][$GLOBALS["current_collection"]["id"]];
	} else {
		return 0;
	}
}

function plogger_get_collection_description() {
	return htmlspecialchars(SmartStripSlashes($GLOBALS["current_collection"]["description"]));

}

function plogger_get_collection_name() {
	return htmlspecialchars(SmartStripSlashes($GLOBALS["current_collection"]["name"]));
}

function plogger_get_collection_id() {
	return $GLOBALS["current_collection"]["id"];
}

function plogger_count_collections() {
	
	$numquery = "SELECT COUNT(*) AS `num_collections` FROM `".TABLE_PREFIX."collections`";
		
	$numresult = run_query($numquery);
	$num_albums = mysql_result($numresult, 'num_collections');
	return $num_albums;
}

/*** End of Collection loop functions ***/

/*** The following functions can only be used inside the Albums loop ***/
function plogger_load_album() {
	$rv = mysql_fetch_assoc($GLOBALS["album_dbh"]);
	$GLOBALS["album_counter"]++;
	$GLOBALS["current_album"] = $rv;
	return $rv;
}

function plogger_has_albums() {
	return $GLOBALS["album_counter"] < $GLOBALS["available_albums"];
}

function plogger_get_album_url() {
	$row = $GLOBALS["current_album"];
	return generate_url("album",$row["id"]);
}

function plogger_get_album_thumb() {
	$rv = $GLOBALS["current_album"];
	// figure out the thumbnail as well
	$thumb_query = "SELECT * FROM `".TABLE_PREFIX."pictures` WHERE ";
	if ($rv["thumbnail_id"] > 0)
		$thumb_query .= " `id`=".$rv["thumbnail_id"];
	else
		$thumb_query .= " `parent_album`='".$rv["id"]."' ORDER BY `date_submitted` DESC LIMIT 1";
	
	$thumb_result = run_query($thumb_query);
	$thumb_data = mysql_fetch_assoc($thumb_result);
	if ($thumb_data) {
		$rv["thumbnail_id"] = $thumb_data["id"];
		$rv["thumbnail_path"] = $thumb_data["path"];
	}
	return generate_thumb($rv['thumbnail_path'], $rv['thumbnail_id'], THUMB_SMALL);
}

function plogger_album_picture_count() {
	$row = $GLOBALS["current_album"];
	// XXX: surely this can be optimized?
	$numquery = "SELECT COUNT(*) AS `num_pictures` FROM `".TABLE_PREFIX."pictures` WHERE `parent_album`='".$row["id"]."'";
	$numresult = run_query($numquery);
	return mysql_result($numresult, 'num_pictures');
}

function plogger_get_album_description() {
	return htmlspecialchars(SmartStripSlashes($GLOBALS["current_album"]["description"]));

}

function plogger_get_album_name() {
	return htmlspecialchars(SmartStripSlashes($GLOBALS["current_album"]["name"]));
}

function plogger_get_album_id() {
	return $GLOBALS["current_album"]["id"];
}

function plogger_get_detail_link() {
		if (!$_SESSION["plogger_details"]){
			return '<a accesskey="d" href="javascript:void(0);" onclick="show_details();">Show details</a>';
		}
		else{
			return '<a accesskey="d" href="javascript:void(0);" onclick="hide_details();">Hide details</a>';
		}
}

function plogger_download_checkbox($id) {
	global $config;
	if ($config["allow_dl"])
		return '<input type="checkbox" name="checked[]" value="'.$id.'" />';
	else
		return '';
}

function plogger_get_next_picture_link() {
	$next_url = plogger_get_next_picture_url();

	if ($next_url)
		$next_link = '<a accesskey="." href="'.$next_url.'">Next &raquo;</a>';
	else
		$next_link = '';
		
	return $next_link;
}

function plogger_get_prev_picture_link() {
	$prev_url = plogger_get_prev_picture_url();
	
	if ($prev_url) 
		$prev_link = '<a accesskey="," href="'.$prev_url.'">&laquo; Previous</a>';
	else
		$prev_link = '';
		
	return $prev_link;	
		

}
/*** End of Album loop functions ***/
function get_comments($picture_id){
	$query = "SELECT *
		FROM `".TABLE_PREFIX."comments`
		WHERE `parent_id`=".intval($picture_id)."
		ORDER BY `date` DESC";
	$result = run_query($query);
	
	$comments = array();
	
	while ($row = mysql_fetch_assoc($result)){
		$comments[$row["id"]] = $row;
	}
	
	return $comments;
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

	<head>
		<br />
<b>Fatal error</b>:  Call to undefined function plogger_head() in <b>/usr/www/virtual/buymebuyme/www.lalovin.com/gallery.php</b> on line <b>67</b><br />