$_year = intval(gus(1));
	$_month = validate_month(gus(2));
	gus_die(3);

	if ($_month) {
		if (!validate_date($_year, $_month))
		{
			$events = (new \Databases\Events())->sqlRead("SELECT MAX(date_start) AS date FROM events INNER JOIN events_images ON events.id = events_images.event_id");
			if ($events_row = $events[0] ?? null)
			{
				$_year = intval(substr($events_row['date'], 0, 4));
				$_month = intval(substr($events_row['date'], 5, 2));
			}
			else
			{
				$_year = date('Y');
				$_month = date('n');
			}
			header('Location: ' . DOMAIN . LANGUAGE . 'photos/' . $_year . '/' . str_month($_month) . '/');
			die;
		}
	} else {
		if (!validate_date($_year, 1))
		{
			$events = (new \Databases\Events())->sqlRead("SELECT MAX(date_start) AS date FROM events INNER JOIN events_images ON events.id = events_images.event_id");
			if ($events_row = $events[0] ?? null)
			{
				$_year = intval(substr($events_row['date'], 0, 4));
			}
			else
			{
				$_year = date('Y');
			}
			header('Location: ' . DOMAIN . LANGUAGE . 'photos/' . $_year . '/');
			die;
		}	
	}

	if ($_month) {
		list($previous_year, $previous_month) = change_date('previous_month', $_year, $_month);
		list($next_year, $next_month) = change_date('next_month', $_year, $_month);
	} else {
		list($previous_year) = change_date('previous_year', $_year, 1);
		list($next_year) = change_date('next_year', $_year, 1);
	}

	include('../include/parts/' . $theme . '_header.php');

	$event_type = (new \DatabasesQueries\EventsTypes())->GetEventTypesArray();

	echo box_outside_top(lang('Event Photos', 'Photos D\'événements', ''), '[ <a href="' . DOMAIN . LANGUAGE . 'photos_new_comments/0/page1/">' . lang('Newest Comments For All Events', 'Nouveaux commentaires pour tous les événements', '') . '</a> ]');

	echo box_inside_top();
	if ($_month) {
			echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td style="font-size: 14px; font-weight: bold;">';
			if ($_month) {
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos/' . $previous_year . '/' . str_month($previous_month) . '/">&lt;&lt;</a> ' . utf8_ucwords(str_month($_month)) . ' ' . $_year . ' <a href="' . DOMAIN . LANGUAGE . 'photos/' . $next_year . '/' . str_month($next_month) . '/">&gt;&gt;</a>';
			} else {
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos/' . $previous_year . '/">&lt;&lt;</a> ' . $_year . ' <a href="' . DOMAIN . LANGUAGE . 'photos/' . $next_year . '/">&gt;&gt;</a>';
			}
			echo '</td><td align="right" style="font-size: 14px; font-weight: bold;">';
			if ($_month) {
				echo date_selection('photos', $_year, $_month, "SELECT DISTINCT (YEAR(date_start)) AS year FROM events INNER JOIN events_images ON events.id = events_images.event_id ORDER BY year DESC");
			} else {
				echo date_selection_year('photos', $_year, "SELECT DISTINCT (YEAR(date_start)) AS year FROM events INNER JOIN events_images ON events.id = events_images.event_id ORDER BY year DESC");
			}
			echo '</td></tr></table>';
	} else {
		echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>';
		echo '<td align="left" style="font-size: 14px; font-weight: bold;">';
		$eventsYearsPieces = [];
		$eventsYears = (new \Databases\Events())->sqlRead("SELECT DISTINCT (YEAR(date_start)) AS year FROM events INNER JOIN events_images ON events.id = events_images.event_id ORDER BY year DESC");
		foreach ($eventsYears as $eventsYearsRow)
		{
			if ($_year == $eventsYearsRow['year'])
			{
				$eventsYearsPieces[] =  $eventsYearsRow['year'];
			}
			else
			{
				$eventsYearsPieces[] =  '<a href="' . DOMAIN . LANGUAGE . 'photos/' . $eventsYearsRow['year'] . '">' . $eventsYearsRow['year'] . '</a>';
			}
		}
		echo implode(' ', $eventsYearsPieces);
		echo '</td></tr></table>';
	}
	echo box_inside_bottom();

	$counter = 0;

	if ($_month) {
		$events = (new \Databases\Events())->sqlRead("SELECT DISTINCT events_images.event_id, events.long_url, events.date_start, events.country, events.region, events.city, events.id, events.name, events.type FROM events INNER JOIN events_images ON events.id = events_images.event_id WHERE date_start >= '" . date('Y-m-d H:i:s', mktime(0, 0, 0, $_month, 1, $_year)) . "' AND date_start < '" . date('Y-m-d H:i:s', mktime(0, 0, 0, $_month + 1, 1, $_year)) . "' ORDER BY events.date_start DESC, events.name");
	} else {
		$events = (new \Databases\Events())->sqlRead("SELECT DISTINCT events_images.event_id, events.long_url, events.date_start, events.country, events.region, events.city, events.id, events.name, events.type FROM events INNER JOIN events_images ON events.id = events_images.event_id WHERE date_start >= '" . date('Y-m-d H:i:s', mktime(0, 0, 0, 1, 1, $_year)) . "' AND date_start < '" . date('Y-m-d H:i:s', mktime(0, 0, 0, 1, 1, $_year + 1)) . "' ORDER BY events.date_start DESC, events.name");
	}
	if (count($events))
	{
		echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
		foreach ($events as $events_row)
		{
			$array = array();
			$events_images = (new \Databases\EventsImages())->sqlRead("SELECT events_images.* FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id AND images.width > images.height ORDER BY images.views DESC LIMIT 3");
			foreach ($events_images as $events_images_row)
			{
				$array[] = $events_images_row['image_id'];
			}
			if (count($array) != 3)
			{
				$events_images = (new \Databases\EventsImages())->sqlRead("SELECT events_images.* FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id AND images.width <= images.height ORDER BY images.views DESC LIMIT " . (3 - count($array)));
				foreach ($events_images as $events_images_row)
				{
					$array[] = $events_images_row['image_id'];
				}
			}
			if (count($array) != 3)
			{
				for ($i = count($array); $i < 3; $i++)
				{
					$array[] = 'null';
				}
			}
			$events_images_views_count = (new \Databases\EventsImages())->sqlRead("SELECT SUM(images.views) AS views FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id");
			$events_images_views_count_row = $events_images_views_count[0] ?? ['views' => 0];
			$events_images_count_row = (new \Databases\EventsImages())->count(['event_id' => $events_row['id']]);
			echo '<tr><td colspan="5"><div style="height: 5px; width: 5px; overflow: hidden;"></div></td></tr>';
			echo '<tr>';
			echo '<td valign="top">';
			echo box_image_top('margin: 0px 5px 0px 0px;');
			echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[0] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
			echo box_image_bottom();
			echo '</td>';
			echo '<td valign="top">';
			echo box_image_top('margin: 0px 5px 0px 0px;');
			echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[1] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
			echo box_image_bottom();
			echo '</td>';
			echo '<td valign="top">';
			echo box_image_top('margin: 0px 5px 0px 0px;');
			echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[2] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
			echo box_image_bottom();
			echo '</td>';
			echo '<td width="100%" valign="top" class="inside">';
			echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/" class="large">' . safe_output($events_row['name']) . '</a><br />' . safe_output($events_row['country']) . ($events_row['region'] ? ', ' . safe_output($events_row['region']) : '') . ($events_row['city'] ? ', ' . safe_output($events_row['city']) : '') . '<br /><span class="' . $event_type[$events_row['type']] . '">' . substr($events_row['date_start'], 0, 10) . '</span><br />' . $events_images_count_row . ' ' . lang('photos') . ', ' . number_format($events_images_views_count_row['views'], 0) . ' ' . lang('views');
			echo '</td>';
			echo '</tr>';
			$counter++;
		}
		echo '</table>';
		if ($counter > 2)
		{
			echo '<div style="height: 5px; width: 5px; overflow: hidden;"></div>';
			echo box_inside_top('font-size: 14px; font-weight: bold;');
			echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td style="font-size: 14px; font-weight: bold;">';
			echo 'Legend: ';
			echo '<span class="events_raves">' . lang('Raves', 'Raves', '') . '</span>, ';
			echo '<span class="events_afterhours">' . lang('Afterhours', 'Clubs de fin de nuit', '') . '</span>, ';
			echo '<span class="events_clubs">' . lang('Clubs', 'Clubs', '') . '</span>, ';
			echo '<span class="events_concerts">' . lang('Concerts', 'Concerts', '') . '</span>, ';
			echo '<span class="events_other">' . lang('Other', 'Autre', '') . '</span>.';
			echo '</td></tr></table>';
			echo box_inside_bottom();
			echo '<div style="height: 5px; width: 5px; overflow: hidden;"></div>';
			echo box_inside_top('padding');
			echo '<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr><td style="font-size: 14px; font-weight: bold;">';
			if ($_month) {
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos/' . $previous_year . '/' . str_month($previous_month) . '/">&lt;&lt;</a> ' . utf8_ucwords(str_month($_month)) . ' ' . $_year . ' <a href="' . DOMAIN . LANGUAGE . 'photos/' . $next_year . '/' . str_month($next_month) . '/">&gt;&gt;</a>';
			} else {
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos/' . $previous_year . '/">&lt;&lt;</a> ' . $_year . ' <a href="' . DOMAIN . LANGUAGE . 'photos/' . $next_year . '/">&gt;&gt;</a>';
			}
			echo '</td><td align="right" style="font-size: 14px; font-weight: bold;">';
			if ($_month) {
				echo date_selection('photos', $_year, $_month, "SELECT DISTINCT (YEAR(date_start)) AS year FROM events INNER JOIN events_images ON events.id = events_images.event_id ORDER BY year DESC");
			} else {
				echo date_selection_year('photos', $_year, "SELECT DISTINCT (YEAR(date_start)) AS year FROM events INNER JOIN events_images ON events.id = events_images.event_id ORDER BY year DESC");
			}
			echo '</td></tr></table>';
			echo box_inside_bottom();
		}
	}
	else
	{
		echo box_inside_top('margin: 5px 0px 0px 0px;');
		echo lang('There are no images for events for this time period.', 'Il n\'y a aucune image  D\'événements pour cette période de temps.', '');
		echo box_inside_bottom();
	}
	echo box_outside_bottom(lang('Event Photos', 'Photos D\'événements', ''));

	
	if ($_year == date('Y') && $_month == date('m') && $counter < 8)
	{
		$counter = 0;
		$events = (new \Databases\Events())->sqlRead("SELECT DISTINCT events_images.event_id, events.long_url, events.date_start, events.country, events.region, events.city, events.id, events.name, events.type FROM events INNER JOIN events_images ON events.id = events_images.event_id WHERE date_start >= '" . date('Y-m-d H:i:s', mktime(0, 0, 0, $previous_month, 1, $previous_year)) . "' AND date_start < '" . date('Y-m-d H:i:s', mktime(0, 0, 0, $previous_month + 1, 1, $previous_year)) . "' ORDER BY events.date_start DESC, events.name");
		if (count($events))
		{
			echo box_outside_top('Older Photos');
			echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
			foreach ($events as $events_row)
			{
				$array = array();
				$events_images = (new \Databases\EventsImages())->sqlRead("SELECT events_images.* FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id AND images.width > images.height ORDER BY images.views DESC LIMIT 3");
				foreach ($events_images as $events_images_row)
				{
					$array[] = $events_images_row['image_id'];
				}
				if (count($array) != 3)
				{
					$events_images = (new \Databases\EventsImages())->sqlRead("SELECT events_images.* FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id AND images.width <= images.height ORDER BY images.views DESC LIMIT " . (3 - count($array)));
					foreach ($events_images as $events_images_row)
					{
						$array[] = $events_images_row['image_id'];
					}
				}
				if (count($array) != 3)
				{
					for ($i = count($array); $i < 3; $i++)
					{
						$array[] = 'null';
					}
				}
				$events_images_views_count = (new \Databases\EventsImages())->sqlRead("SELECT SUM(images.views) AS views FROM events_images, images WHERE events_images.event_id = '" . $events_row['id'] . "' AND events_images.image_id = images.id");
				$events_images_views_count_row = $events_images_views_count[0] ?? ['views' => 0];
				$events_images_count_row = (new \Databases\EventsImages())->count(['event_id' => $events_row['id']]);
				echo '<tr><td colspan="5"><div style="height: 5px; width: 5px; overflow: hidden;"></div></td></tr>';
				echo '<tr>';
				echo '<td valign="top">';
				echo box_image_top('margin: 0px 5px 0px 0px;');
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[0] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
				echo box_image_bottom();
				echo '</td>';
				echo '<td valign="top">';
				echo box_image_top('margin: 0px 5px 0px 0px;');
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[1] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
				echo box_image_bottom();
				echo '</td>';
				echo '<td valign="top">';
				echo box_image_top('margin: 0px 5px 0px 0px;');
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/"><img src="' . DOMAIN . LANGUAGE . 'image/thumb/' . $array[2] . '/" width="100" height="75" loading="lazy" alt="" /></a>';
				echo box_image_bottom();
				echo '</td>';
				echo '<td width="100%" valign="top" class="inside">';
				echo '<a href="' . DOMAIN . LANGUAGE . 'photos_event/' . $events_row['long_url'] . '/all/page1/" class="large">' . $events_row['name'] . '</a><br />' . $events_row['country'] . ($events_row['region'] ? ', ' . $events_row['region'] : '') . ($events_row['city'] ? ', ' . $events_row['city'] : '') . '<br /><span class="' . $event_type[$events_row['type']] . '">' . substr($events_row['date_start'], 0, 10) . '</span><br />' . $events_images_count_row . ' ' . lang('photos') . ', ' . number_format($events_images_views_count_row['views'], 0) . ' ' . lang('views');
				echo '</td>';
				echo '</tr>';
				$counter++;
			}
			echo '</table>';
			echo box_outside_bottom('Older Photos');
		}
	}

	include('../include/parts/' . $theme . '_footer.php');