<?php 
# Added 2025-06-13 AOLS to prevent deadlocking the server
#exit;
set_time_limit(3);

# pictures.php
#
# The following five lines prevent browsers from caching the page!
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");					/* Date in the past				*/
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");		/* always modified				*/
header("Cache-Control: no-store, no-cache, must-revalidate");		/* anti-cache for HTTP ver. 1.1	*/
header("Cache-Control: post-check=0, pre-check=0", false);			/*								*/
header("Pragma: no-cache");											/* anti-cache for HTTP ver. 1.0 */


/* included files: */
require_once("./include/site_constants.php"); 
require_once("./include/standard_functions.php");
require_once("./include/gui_functions.php");
require_once("./include/db_mysql.php");

/**********************************************************************************/
/********************************** Initialising **********************************/
/**********************************************************************************/



/* Get the microtime in order to find out how long it took to generate the page! */
$page_time_start = get_microtime();


/* Create database object */
$db = new DB_Spencer_Class(array(PRIMARY_DB_HOST, PRIMARY_DB_USER, PRIMARY_DB_PASSWORD, PRIMARY_DB_DATABASE, 0, 0));
$db->query("SET NAMES 'utf8'");

/* Specifies whatever or not there should be a right menu on this page! */
$show_right_menu = false; 


/* Create the class object in order to manage the site cookie */
$coo = new Cookies_Manager_Class("UserCookie");


/* Start session management! Make at the following global variables available:
	SESSION_VERIFIED_USER[]
		(profile_id, username, password, user_level, first_name, middel_name, last_name)
	SESSION_VERIFIED_ADMIN[]
		(admin_id, username, password, admin_level, first_name, middel_name, last_name)	*/
start_page_session();


/* Call this method in order to check for auto login and so if auto_login is set! NOTICE that this method must have a pointer to the cookie as an argument!*/
check_for_autologin($coo);


/* Call the method get_language in order to find out what language the page
   scould be in! NOTICE! that the method take one argument (the pointer og the cookie object)*/
$page_language = get_language($coo);

/* Include the listpictures function!*/
require_once("./include/listpictures.php"); 

/* Get left/right sitemenu picture url*/
$left_sitemenu_picture_id = get_left_sitemenu_picture_id();
if ($show_right_menu) {
	$right_sitemenu_picture_id = get_right_sitemenu_picture_id($left_sitemenu_picture_id);
}


/* Get standard "GET" variables */
if (!$page_id = @$_GET['id']) { $page_id = 'index';}
if (!$page_mode = @$_GET['mode']) { $page_mode = '';}
if (!$page_option = @$_GET['op']) { $page_option = '';}
if (!$referer_url = @$_GET['rurl']) {	$referer_url = ''; }


/**********************************************************************************/
/****************************** Special Initialising ******************************/
/**********************************************************************************/

if (!$page_nr = @$_GET['page_nr']) {
	$page_nr = '1';
} else {
	if (!is_numeric($page_nr) Or (((int) $page_nr) < 1)) {$page_nr = '1';}
}

if (!$page_size = @$_GET['page_size']) {
	$page_size = '25';
} else {
	if (!is_numeric($page_size) Or (((int) $page_size) < 1)) {$page_size = '25';}
	if (((int) $page_size) > 100) {$page_size = '100';}
}

if (!$order_by = @$_GET['order_by']) { $order_by = '';}

if (!$order = @$_GET['order']) { $order = '';}

if (!$species_id = (INT) @$_GET['species_id']) { $species_id = '';}

if (!$photographer_id = (INT) @$_GET['photographer_id']) { $photographer_id = '';}

if (!$pic_title = @$_GET['pic_title']) {
	$pic_title = '';
}else {
	$pic_title = str_replace('"', '', $pic_title);
}

if (!$withcomments = (INT) @$_GET['withcomments']) {$withcomments = 0;}

if (!$picture_id = (INT) @$_GET['picture_id']) { $picture_id = '';}

if (!$country_id = (INT) @$_GET['country_id']) { $country_id = '';}

if (!$pics_section = @$_GET['pics_section']) { $pics_section = '';}

if (!$picture_category_id = @$_GET['picture_category_id']) { $picture_category_id = '';}

if (!$picture_theme_id = (INT) @$_GET['theme_id']) { $picture_theme_id = '';}

if (!$picture_theme_sp = @$_GET['theme_sp']) { $picture_theme_sp = 0;}

if (!$rare_bird_id = @$_GET['rare_bird']) { $rare_bird_id = '';}

if (!$enable_upload_functionality = @$_GET['enable_upload_functionality']) { $enable_upload_functionality = '';}

if (!$picdate_day = (INT) @$_GET['picdate_day']) {
	$picdate_day = '';
} else {
	if (!is_numeric($picdate_day) Or (((int) $picdate_day) < 1) Or (((int) $picdate_day) > 31)) {$picdate_day = '';}
}

if (!$picdate_month = (INT) @$_GET['picdate_month']) {
	$picdate_month = '';
} else {
	if (!is_numeric($picdate_month) Or (((int) $picdate_month) < 1) Or (((int) $picdate_month) > 12)) {$picdate_month = '';}
}

if (!$picdate_year = (INT) @$_GET['picdate_year']) {
	$picdate_year = '';
} else {
	if (!is_numeric($picdate_year) Or (((int) $picdate_year) < 1900)) {$picdate_year = '';}
}

if (!$search = @$_GET['search']) { $search = 0;}

if (!$birdid = (INT) @$_GET['birdid']) { $birdid = 0;}
if (!$subspecies = (INT) @$_GET['subspecies']) { $subspecies = 0;}


/**********************************************************************************/
/************************************ Functions ***********************************/
/**********************************************************************************/

if($page_id == 'search_result') {

	$search_value = str_replace('"', '', @$_GET['search_value']);


	if($search_value) {

	update_statistic_language('pictures.php?id=search_result');
		
	/************************************ SPECIES ************************************/

	$sql_search_species = "Select species.category_id, species." . $page_language . "_name AS bird_name, species.latin_name, species.species_id, COUNT(*) As number_of_photo, SUM(pictures.hits) As number_of_hits, MAX(pictures.upload_date) As latest_picture From tbl_bird_species AS species, tbl_pictures AS pictures Where pictures.species_id = species.species_id";

	$sql_search_species .= " AND (species.dk_name LIKE \"%" . $search_value . "%\" OR species.uk_name LIKE \"%" . $search_value . "%\" OR species.latin_name LIKE \"%" . $search_value . "%\" OR species.uk_name_alt LIKE \"%" . $search_value . "%\" OR species.dk_name_alt LIKE \"%" . $search_value . "%\")";

	$sql_search_species .= " Group by species.species_id Order by species.category_id, species.placement";

	$db->query($sql_search_species, "search_species");

	$number_of_species = $db->db_num_rows("search_species");



	/************************************ COUNTRIES ************************************/

	$sql_search_countries = "Select country." . $page_language . "_country_name AS country_name, country.country_id, COUNT(*) As number_of_photo, SUM(pictures.hits) As number_of_hits, MAX(pictures.hits) As max_hits, MAX(pictures.upload_date) As latest_picture From tbl_country AS country, tbl_pictures AS pictures Where pictures.country_id = country.country_id";

	$sql_search_countries .= " AND (country.dk_country_name LIKE \"%" . $search_value . "%\" OR country.uk_country_name LIKE \"%" . $search_value . "%\")";

	$sql_search_countries .= " Group by country.country_id Order by country_name";

	$db->query($sql_search_countries, "search_countries");

	$number_of_countries = $db->db_num_rows("search_countries");



	/************************************ PHOTOGRAPHERS ************************************/

	$sql_search_photographers = "Select country." . $page_language . "_country_name As country_name, photographer.photographer_name, photographer.photographer_id, COUNT(*) As number_of_photo, SUM(pictures.hits) As number_of_hits, MAX(pictures.hits) As max_hits, MAX(pictures.upload_date) As latest_picture From tbl_country AS country, tbl_photographers AS photographer, tbl_pictures AS pictures Where country.country_id = photographer.country_id AND pictures.photographer_id = photographer.photographer_id";

	$sql_search_photographers .= " AND (photographer.photographer_name LIKE \"%" . $search_value . "%\")";

	$sql_search_photographers .= " Group by photographer.photographer_id Order by photographer.photographer_name";

	$db->query($sql_search_photographers, "search_photographers");

	$number_of_photographers = $db->db_num_rows("search_photographers");

	} else {
		$number_of_species = 0;
		$number_of_countries = 0;
		$number_of_photographers = 0;
	}

	/************************************ RESULT ************************************/

	if(($number_of_species + $number_of_countries + $number_of_photographers) == 1) {
		if($number_of_species == 1) {
			$species_info_row = $db->row("search_species");
			header('Location: pictures.php?id=listpictures&species_id=' . $species_info_row['species_id']);
			exit;
		} elseif($number_of_countries == 1) {
			$country_info_row = $db->row("search_countries");
			header('Location: pictures.php?id=listpictures&country_id=' . $country_info_row['country_id']);
			exit;
		} else {
			$photographer_info_row = $db->row("search_photographers");
			header('Location: pictures.php?id=listpictures&photographer_id=' . $photographer_info_row['photographer_id']);
			exit;
		}
	}

}




/**********************************************************************************/
/*********************************** Page Start ***********************************/
/**********************************************************************************/
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<LINK rel="SHORTCUT ICON" href="http://www.netfugl.dk/favicon.ico">

<title>
<?php 
	echo ($page_language=='dk') ? "Galleriet - " : "The Gallery - ";
	echo SITE_NAME;
?>

</title>
<style type="text/css">
	@import "include/style.css?v=1.0";
</style>

<script src="include/javascript.js" type="text/javascript" language="javascript1.2">
</script>

<link rel="stylesheet" href="include/species/autosuggest/css/autosuggest_inquisitor.css" type="text/css" />
<script type="text/javascript" src="include/species/autosuggest/js/bsn.AutoSuggest_c_2.0.js"></script>

</head>

<body>

<a name='topofpage'></a>


<?php 
	$banner_at_index_page = 0;
	include("./include/page_header.php");
	include("./include/page_main_menu.php");
	include("./include/page_horizontal_bar.php");
?>


<table id='tblmaintable' cellSpacing='0' cellPadding='0' width='100%'>
  <tbody>
	<tr>
		<td id='tblleftmenu' width='<?php echo MENU_LEFT_WIDTH;?>' valign='top'>
			
			<?php 
			
				gui_sitemenu_pic($left_sitemenu_picture_id, false);

				gui_language_flag();

				gui_menubar("Galleriet", "The Gallery");
				gui_menutext_start();
					gui_menutext("pictures.php?id=listpictures&order_by=uploaddate&order=desc", "Seneste oploadede", "Latest uploaded");
					gui_menutext("pictures.php?id=listpictures&order_by=uploaddate&order=desc&country_id=1", "Seneste fra Danmark", "Latest from Denmark");
					gui_menutext("pictures.php?id=listpictures&pics_section=latest_from_abroad", "Seneste udlandsbilleder", "Latest from abroad");
					gui_menutext("pictures.php?id=listpictures&pics_section=from_abroad", "Udlandsbilleder", "Pictures from abroad");
					gui_menutext("pictures.php?id=listpictures&pics_section=rarities_in_wp", "Rariteter i VP", "Rarities in WP");
					gui_menutext("pictures.php?id=listpictures&pics_section=various", "Diverse billeder", "Various pictures");
					gui_menutext("pictures.php?id=listpictures&pics_section=birders_in_field", "Folk i felten", "Birders in field");
					gui_menutext("pictures.php?id=themes&mode=index", "Temaer", "Themes");
					gui_menutext("pictures.php?id=listphotographers", "Fotografer", "Photographers");
					gui_menutext("pictures.php?id=specieslist", "Fugleartsliste", "Bird species list");
					gui_menutext("pictures.php?id=comments_statistics", "Statistik", "Statistics");
					gui_menutext("pictures.php", "Om galleriet", "About the gallery");
					gui_menutext("pictures.php?id=sendpics", "Indsend billeder?", "How to send pictures?");
				gui_menutext_end();

				gui_menubar("Billedesøgning", "Picture search");
				gui_menutext_start();

					echo "<tr><td class='menutext' style=\"text-align: center; padding: 3px;\">";
						echo "<form action='pictures.php' method='get' style=\"margin: 0px;\">";
							echo "<input type='hidden' name='id' value='search_result'>";
							echo "<input type='text' size='16' maxlength='200' name='search_value'>";

							echo "<br />";

							echo "<input type='submit' class='button' value='";
								echo ($page_language == "dk") ? "Søg" : "Search";
							echo "'>";
						echo "</form>";
					echo "</td></tr>";
	
					echo "<tr><td class='menutext' style=\"text-align: center;\">";
						echo "<a href='pictures.php?id=search'>[";
							echo ($page_language == "dk") ? "Avanceret søgning" : "Advanced Search";
						echo "]</a>";
					echo "</td></tr>";

				gui_menutext_end();

				include("./include/menu_items_info_short.php");
				include("./include/menu_items_various.php");

				include("./include/menu_items_search.php");
				include("./include/menu_items_userlogin.php");

				if (isset($_SESSION['SESSION_VERIFIED_ADMIN'])) {
					gui_menubar(SITE_NAME ." Admin", SITE_NAME ." Admin");
					include("./include/menu_items_adminlogin.php");
				}
			
			echo "<br><br>";

			echo "<div align='center'>";
				gui_banner("other", 74);
			echo "</div><br>";

			include("./include/menu_items_tracker.php");

			echo "<br>";
			?>
		</td>

		<td id='tblcontent' valign='top'>

<!--/******************************** Content Page Start *********************************/-->
	
			
<?php   
			gui_header("Galleriet", "The Gallery");
			update_statistic_language('pictures.php');

					// Checking which mode the asp page was called with
					switch ($page_id) {
	
						case 'index' :
							include("./include/pictures/gallery_index.php");
							break;

						case 'themes' :
							include("./include/pictures/gallery_themes.php");
							break;

						case 'showpicture' :
							include("./include/pictures/gallery_showpicture.php");
							break;

						case 'listpictures' :
							if($order_by == 'uploaddate') {
								$enable_upload_functionality = true;
							}

							$initializing_array = array(
								"page_nr" => $page_nr, 
								"page_size" => $page_size, 
								"order_by" => $order_by, 
								"order" => $order, 
								"species_id" => $species_id, 
								"birdid" => $birdid, 
								"subspecies" => $subspecies,
								"photographer_id" => $photographer_id, 
								"country_id" => $country_id,
								"picdate_day" => $picdate_day,
								"picdate_month" => $picdate_month,
								"picdate_year" => $picdate_year,
								"pic_title" => $pic_title,
								"withcomments" => $withcomments, 
								"pics_section" => $pics_section,
								"picture_category_id" => $picture_category_id,
								"picture_theme_id" => $picture_theme_id,
								"rare_bird_id" => $rare_bird_id,
								"enable_year_functionality" => true,
								"enable_species_name_functionality" => true,
								"enable_upload_functionality" => $enable_upload_functionality,
								"enable_order_by_functionality" => true, 
								"enable_page_overview_functionality" => true, 
								"enable_search_criteria_functionality" => true, 
								"show_all_pictures" => false,
								"search" => $search,
							);

							listpictures($initializing_array);

							break;

						case 'search_result' :
							include("./include/pictures/gallery_search_result.php");
							break;

						case 'search' :
							include("./include/pictures/gallery_search.php");
							break;

						case 'listphotographers' :
							include("./include/pictures/gallery_listphotographers.php");
							break;

						case 'showphotographer' :
							include("./include/pictures/gallery_showphotographer.php");
							break;

						case 'specieslist' :
							include("./include/pictures/gallery_specieslist.php");							
							break;

						case 'specieslist_wp' :
							include("./include/pictures/gallery_specieslist_wp_missing.php");							
							break;

						case 'sendpics' :
							include("./include/pictures/gallery_sendpics.php");							
							break;

						case 'latestcomments' :
							include("./include/pictures/gallery_latestcomments.php");							
							break;
							
						case 'latestcommentsadmin' :
							include("./include/pictures/gallery_latestcommentsadmin.php");
							break;

						case 'comments_statistics' :
							include("./include/pictures/gallery_comments_statistics.php");
							break;

						default :
							include("./include/pictures/gallery_index.php");
							break;
					}
					echo "<br>";


echo "<br><div align='center'>";
	echo "<table class='listtable' width='98%' border='0' cellspacing='0' cellpadding='0'>";
		echo "<tbody>";
			echo "<tr class='listrow'>";

				echo "<td class='listcell' style=\"padding: 6px 6px 6px 6px; color: rgb(120, 120, 120); text-align: center;\">";

					echo ($page_language == 'dk') ? "<b>Bemærk:</b> at alle billeder har copyright og må ikke anvendes uden accept fra den respektive fotograf." : "<b>Please note:</b> that all images are copyrighted and cannot be reproduced in any way without permission from the photographers.";

				echo "</td>";
			echo "</tr>";
		echo "</tbody>";
	echo "</table>";
echo "</div>";


					echo "<br>";
					gui_backbutton();
?>


			<!--/****************************** Content Page End *****************************/-->
		</td>

	<?php  if ($show_right_menu) { /********* RIGHT MENU START *********/ ?> 

		<td id='tblrightmenu' width='<?php echo MENU_RIGHT_WIDTH;?>' valign='top'>
			<?php 

				gui_sitemenu_pic($right_sitemenu_picture_id);
	
			?>
		</td>

	<?php  } /********* RIGHT MENU END *********/ ?> 

	</tr>
</tbody>
</table>

<?php 
/* Get the microtime in order to find out how long it took to generate the page! */
$page_time_end = get_microtime();
$page_generated_in_seconds = number_format($page_time_end - $page_time_start, 3, ".", "");

/* include the footer to the page! */

	include("./include/page_horizontal_bar.php");
	include("./include/page_footer.php");


	$db->db_close();




	include("./include/menu_items_fatbirder.php");
?>

</body>
</html>