getRow($sql);
$_SESSION["gallery_id"] = $gallery["gallery_id"];
}
}
if (isset($_SESSION["gallery_id"])) {
$sql="SELECT * FROM gallery WHERE gallery_id=".$_SESSION["gallery_id"];
$gallery = $my_conn->getRow($sql);
$_SESSION["gallery_name"]=$gallery["name"];
$_SESSION["gallery_notes"]=$gallery["notes"];
}
if ( (!isset($_GET["im"])) && (isset($_SESSION["gallery_id"])) ) {
$sql="SELECT min(photo_id) AS photo_id FROM photo_to_gallery WHERE gallery_id=".$_SESSION["gallery_id"];
$gallery = $my_conn->getRow($sql);
$_GET["im"] = $gallery["photo_id"];
}
//paging stuff for images
//check for session vars and assign if none exist
$_SESSION["gallery_paging"]="";
if (!$_SESSION['gallery_paging']) {
$sql="SELECT p.photo_id FROM photo_to_gallery ptg, photo p WHERE ptg.gallery_id=".$_SESSION["gallery_id"]." AND p.photo_id = ptg.photo_id AND p.public=1 ORDER BY p.photo_id";
$res = $my_conn->query($sql);
foreach ($res as $gallery_images) {
$_SESSION["gallery_paging"].=$gallery_images["photo_id"].",";
}
$_SESSION["gallery_paging"] = substr($_SESSION["gallery_paging"], 0, strlen($_SESSION["gallery_paging"])-1);
}
if ( (isset($_GET["im"])) && ($_GET["im"]!=0) ) {
$sql="SELECT ptg.gallery_id FROM photo_to_gallery ptg, photo p WHERE ptg.photo_id=".$_GET["im"]." AND p.photo_id=ptg.photo_id AND p.public=1";
$gallery = $my_conn->getRow($sql);
$_SESSION["gallery_id"] = $gallery["gallery_id"];
$sql="SELECT p.photo_id, p.filename, p.title, p.description, p.author, p.date, DATE_FORMAT(p.date, '%b %d, %Y') AS date_formatted, p.hires_available_flag, p.height, p.width, p.keywords, c.camera_folder_name FROM photo p, camera c WHERE p.photo_id=".$_GET["im"]." AND p.public=1 AND c.camera_id = p.camera_id";
$db_image = $my_conn->getRow($sql);
if (isset($db_image)) {
$hires_image = $db_image["filename"];
$fb_pagename = "apps|gallery|image|".$_GET["im"];
$exifimage = $server_path.$db_image["camera_folder_name"]."/".strtoupper($db_image["filename"]);
if (file_exists($exifimage)) {
echo "";
$exif_data_available = true;
} else {
$exifimage = $lowres_path.$db_image["camera_folder_name"]."/".$db_image["filename"];
if (file_exists($exifimage)) {
echo "";
$exif_data_available = true;
} else {
echo "";
$exifimage = $lowres_path.$db_image["camera_folder_name"].$db_image["filename"];
if (file_exists($exifimage)) {
echo "";
$exif_data_available = true;
} else {
echo "";
$exif_data_available = false;
}
}
}
?>
= 1) {
print "| previous image | ";
}
if ( ($i > 0) && ($i < count($paging_array)-1) ) {
print ' | ';
}
if ($i != count($paging_array)-1) {
print "next image | ";
}
}
}
?>
| TAGS:TAGS: |
= 1) {
$tags = split(",", $db_image["keywords"]);
$tagscount = count($tags)-1;
for ($i=0; $i<=$tagscount;$i++) {
$str_keywords .= "".$tags[$i]."";
if ($i != $tagscount) $str_keywords .= ", ";
}
}
?>
|
EXIF DATA:
|
| © ".$db_image["author"]."";}?> |
unable to retrieve the requested image
nothing to see here