$totalpages) { $pageNum = 1; } } if ($pageNum == 1) { $rowsPerPage = 48; } $offset = ($pageNum - 1) * $rowsPerPage; if ($_SESSION['admin']) { $query = "SELECT photos.PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos INNER JOIN tags on photos.PhotoID = tags.PhotoID WHERE Tag = '$tag_f' ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage"; } else { $query = "SELECT photos.PhotoID, File, Title, Description, DateCreated, Public, Stub FROM Photos INNER JOIN tags on photos.PhotoID = tags.PhotoID WHERE Public = 1 AND Tag = '$tag_f' ORDER BY DateCreated DESC LIMIT $offset, $rowsPerPage"; } if (!$result = @ mysql_query ($query, $connection)) logerror(); if (mysql_num_rows($result) == 0) { die("Couldn't find any photos!"); } else { $photoBodyHTML = '

Tag: '.$tag.'

'; $photoBodyHTML .= '
'; while ($photo = mysql_fetch_array($result)) { $cntPhoto++; $photoID = $photo['PhotoID']; $photoFile = $photo['File']; $photoStub = $photo['Stub']; $photoSRC = str_replace(PHOTO_DIR, PHOTO_URL, $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_s = $thumbBaseFile . "_s.jpg"; $thumbSRC_s = str_replace(THUMB_DIR, THUMB_URL, $thumbFile_s); $thumbSRC_s = str_replace("\\", "/", $thumbSRC_s); list($width, $height, $type, $attr) = @getimagesize($photoFile); $widthCSS = ($width - 10); list($width_s, $height_s, $type_s, $attr_s) = @getimagesize($thumbFile_m); $cntThumb++; $photoBodyHTML .= <<{$photoTitle}
THUMBEND; } $photoBodyHTML .= ""; } //Assemble page numbers $pageNumbersHTML = ""; for ($p=1; $p <= $totalpages; $p++) { if ($p == $pageNum) { $pageNumbersHTML .= ' '.$p.' '; } else { $pageNumbersHTML .= ' '.$p.' '; } } ?> <?php print APP_TITLE ?>: tag: <?php print $tag ?>
phases
onfocus * photossun
 
Page:
all photos | blog | photos cc 1998-2007 pb.