$totalpages) { $pageNum = 1; } } if ($pageNum == 1) { $rowsPerPage = 35; } $offset = ($pageNum - 1) * $rowsPerPage; if ($_SESSION['admin']) { $query = "SELECT PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage"; } else { $query = "SELECT PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos WHERE Public = 1 ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage"; } if (!$result = @ mysql_query ($query, $connection)) printMySQLerror(); if (mysql_num_rows($result) == 0) { die("Couldn't find this photo!"); } else { while ($photo = mysql_fetch_array($result)) { $cntPhoto++; $photoID = $photo['PhotoID']; $photoFile = $photo['File']; $photoStub = $photo['Stub']; $photoSRC = str_replace(PHOTO_DIR, "http://photos.onfocus.com/photos/", $photoFile); $photoSRC = str_replace("\\", "/", $photoSRC); $photoTitle = $photo['Title']; $photoDescription = $photo['Description']; $photoDate = $photo['DateCreated']; $photoDateTitle = date("l, F jS",strtotime($photoDate)); $photoDateTime = date("g:i A",strtotime($photoDate)); $photoDateTimeMore = date("M jS, Y",strtotime($photoDate))." at ".$photoDateTime; $photoYear = date("Y",strtotime($photoDate)); $thumbYearDir = THUMB_DIR . $photoYear; $thumbBaseFile = $thumbYearDir . "\\" . md5(SALT.$photoID); $thumbFile_m = $thumbBaseFile . "_m.jpg"; $thumbSRC_m = str_replace(THUMB_DIR, "http://photos.onfocus.com/thumbs/", $thumbFile_m); $thumbSRC_m = str_replace("\\", "/", $thumbSRC_m); list($width, $height, $type, $attr) = @getimagesize($photoFile); list($width_m, $height_m, $type_m, $attr_m) = @getimagesize($thumbFile_m); if ($cntPhoto == 1 && $pageNum == 1) { $photoBodyHTML .= <<{$photoDateTitle}

{$photoTitle}

{$photoTitle}
{$photoDescription}
[.] {$photoDateTime}
PHOTOEND; } else { if ($cntThumb == 0) { $photoBodyHTML .= '

Older Photos

'; $photoBodyHTML .= ''; } if ($cntThumb & 1) { $photoBodyHTML .= "
"; } else { $photoBodyHTML .= "
"; } $cntThumb++; $photoBodyHTML .= <<

{$photoTitle}

{$photoTitle}
[.] {$photoDateTimeMore}
THUMBEND; } } } $photoBodyHTML .= "
"; //Assemble page numbers $pageNumbersHTML = ""; for ($p=1; $p <= $totalpages; $p++) { if ($p == $pageNum) { $pageNumbersHTML .= ' '.$p.' '; } else { $pageNumbersHTML .= ' '.$p.' '; } } ?> onfocus - photos
Page: