window.location.href='error/404'";
exit;
}
$gal_query = "SELECT * FROM gallery WHERE gal_id=" . $gallery;
$img_query = "SELECT * FROM picture WHERE gal_link=" . $gallery . " ORDER BY img_exif_datetime ASC";
$gal_result = mysqli_query($link,$gal_query);
$img_result = mysqli_query($link,$img_query);
if (! $gal_result) {
echo "";
exit;
} else {
$gal_info = mysqli_fetch_assoc($gal_result);
if ($gal_info["gal_private"]=="Y") {
echo "";
exit;
}
}
$gal_dir = "albums/" . basename($gal_info["gal_dir"]);
$phpdate = strtotime($gal_info['gal_date']);
$display_date = date( 'l jS F Y', $phpdate );
$category = "Images";
echo "" . $gal_info['gal_name'] . " Gallery
";
echo "
"; echo "
\n"; if ($gal_info['gal_intro']) { echo "
"; } echo "
"; echo "
";
$prev_result->close();
$next_result->close();
include("./common_sidebar.php");
?>
" . $gal_info['gal_name'] . " Gallery![](" . $cat_icons[$category] . ")
";
echo ""; echo "
Posted in " . $category ." on ". $display_date; echo "
\n"; echo "\n"; if ($gal_info['gal_intro']) { echo "
" . $gal_info['gal_intro'] . "
"; } echo "
";
while ($img = $img_result->fetch_assoc()) {
if (file_exists($gal_dir . "/normal_" . $img["img_filename"])) {
$src = "/" . $gal_dir . "/normal_" . $img["img_filename"];
} else {
$src = "/" . $gal_dir . "/" . $img["img_filename"];
}
if ($img["img_comment"]) {
$comment = $img["img_comment"];
} else {
$comment = $gal_info["gal_name"];
}
if ($img["img_exif_datetime"]) {
$date = date("l jS F Y H:i",strtotime($img["img_exif_datetime"]));
} else {
$date = $gal_info["gal_date"];
}
echo "";
}
echo "
"; echo "
";
$next_query = "SELECT gal_id FROM gallery WHERE gal_date>'" . date("Y-m-d H:i:s",$phpdate) . "' AND gal_private='N' AND gal_id !=" . $_REQUEST["gallery"] . " ORDER BY gal_date ASC LIMIT 1";
$next_result = $link->query($next_query);
$next_row = mysqli_fetch_assoc($next_result);
if ($next_row['gal_id']) echo " Next Gallery";
$prev_query = "SELECT gal_id FROM gallery WHERE gal_date<'" . date("Y-m-d H:i:s",$phpdate) . "' AND gal_private='N' AND gal_id !=" . $_REQUEST["gallery"] . " ORDER BY gal_date DESC LIMIT 1";
$prev_result = $link->query($prev_query);
$prev_row = mysqli_fetch_assoc($prev_result);
if ($prev_row['gal_id']) echo "Previous Gallery ";
echo "