$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 = '
';
$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 .= <<

THUMBEND;
}
$photoBodyHTML .= "";
}
//Assemble page numbers
$pageNumbersHTML = "";
for ($p=1; $p <= $totalpages; $p++) {
if ($p == $pageNum) {
$pageNumbersHTML .= ' '.$p.' ';
}
else {
$pageNumbersHTML .= ' '.$p.' ';
}
}
?>
: tag:
Page:
all photos |
blog | photos
cc 1998-2007 pb.