query($sql);
if($db_object->num_rows())
{
header("Location: photo.php?ImageID=" . $_POST['Text'] ); // Redirect to photo page
exit;
} else {
// !!!
// User entered a non-existent photo id
$msg = "Invalid photo id. Please enter another id.";
$error = true;
}
} else {
// !!!
// User did'nt fill out all fields
$msg = "Please enter a numeric id.";
$error = true;
}
} else {
if($_POST["Text"])
{
$sql = "SELECT UserID FROM user WHERE Screen_name = '" . $_POST["Text"] . "';";
$db_object->query($sql);
if($row = $db_object->fetch_array())
{
header("Location: archive.php?Author=" . $row['UserID'] ); // Redirect to authors photos
exit;
} else {
// !!!
// User entered a non-existent author
$msg = "Invalid photographer. Please enter another photographer.";
$error = true;
}
} else {
// !!!
// User did'nt fill out all fields
$msg = "Please enter a photographer.";
$error = true;
}
}
}
if(isset($_POST["GoKey"]) && $_POST["GoKey"] == "True")
{
$sql = "SELECT KeyID FROM `keys` WHERE KeyID = '" . $_POST["Key"] . "';";
$db_object->query($sql);
if($row = $db_object->fetch_array())
{
header("Location: archive.php?Key=" . $row['KeyID'] ); // Redirect to key photos
exit;
} else {
// !!!
// User entered a non-existent author
$msg = "Invalid key. Please enter another key.";
$error = true;
}
}
if(isset($_GET["AddError"]) && $_GET["AddError"] == "True")
{
// !!!
// Camera is full or not online
$msg = "Camera is full or not online.";
$error = true;
}
if(isset($_REQUEST["Offset"]) && is_numeric($_REQUEST["Offset"]))
{
$offset = $_REQUEST["Offset"];
} else {
$offset = 0;
}
if(isset($_REQUEST["SortBy"]) && ($_REQUEST["SortBy"] == "Comment" || $_REQUEST["SortBy"] == "Time" || $_REQUEST["SortBy"] == "Recent")) {
$sortBy = $_REQUEST["SortBy"];
} else {
$sortBy = "Time"; // Default sorting option
}
if(isset($_GET["Author"]) && is_numeric($_GET["Author"]))
{
$sql = "SELECT UserID, Screen_name FROM user WHERE UserID = " . $_GET["Author"] . ";";
$db_object->query($sql);
if($row = $db_object->fetch_array())
{
$author = $row["UserID"];
$screenName = $row["Screen_name"];
} else {
// !!!
// User entered a non-existent author
//$msg = "Invalid photographer. Please enter another photographer.";
//$error = true;
$author = 0;
}
} else {
$author = 0;
}
if(isset($_GET["Key"]) && is_numeric($_GET["Key"]))
{
$sql = "SELECT KeyID, Key_name FROM `keys` WHERE KeyID = " . $_GET["Key"] . ";";
$db_object->query($sql);
if($row = $db_object->fetch_array())
{
$key = $row["KeyID"];
$keyName = $row["Key_name"];
} else {
// !!!
// User entered a non-existent author
//$msg = "Invalid photographer. Please enter another photographer.";
//$error = true;
$key = 0;
}
} else {
$key = 0;
}
// Global variables
//----------------------------------
$imagesPerRow = 4;
$imagesPerColumn = 2;
$imagesPerPage = $imagesPerRow * $imagesPerColumn;
$pagesLink = 10;
$midlePage = (int) ($pagesLink / 2);
//----------------------------------
if($author)
{
if($sortBy == "Recent")
{
$sql = "SELECT COUNT(DISTINCT(imagelog.ImageID)) FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND imagelog.UserID = " . $author . " AND Screened = 1;";
} else {
$sql = "SELECT COUNT(*) FROM imagelog WHERE UserID = " . $author . " AND Screened = 1;";
}
} else {
if($sortBy == "Recent")
{
if($key)
{
$sql = "SELECT COUNT(DISTINCT(imagelog.ImageID)) FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND imagelog.KeyID = " . $key . " AND Screened = 1;";
} else {
$sql = "SELECT COUNT(DISTINCT(imagelog.ImageID)) FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND Screened = 1;";
}
} else {
if($key)
{
$sql = "SELECT COUNT(*) FROM imagelog WHERE KeyID = " . $key . " AND Screened = 1;";
} else {
$sql = "SELECT COUNT(*) FROM imagelog WHERE Screened = 1;";
}
}
}
$db_object->query($sql);
$row = $db_object->fetch_array();
$totalImages = $row[0];
if($totalImages)
{
$imageCounter = ($offset >= $totalImages || $offset < 0 ? 0 : $offset);
$prevImageCounter = $imageCounter;
if($sortBy == "Time")
{
if($author)
{
//$sql = "SELECT * FROM imagelog WHERE UserID = " . $author . " AND Screened = 1 ORDER BY TimeInsert DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
$sql = "SELECT * FROM imagelog WHERE UserID = " . $author . " AND Screened = 1 ORDER BY ImageID DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} elseif($key) {
//$sql = "SELECT * FROM imagelog WHERE KeyID = " . $key . " AND Screened = 1 ORDER BY TimeInsert DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
$sql = "SELECT * FROM imagelog WHERE KeyID = " . $key . " AND Screened = 1 ORDER BY ImageID DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} else {
//$sql = "SELECT * FROM imagelog WHERE Screened = 1 ORDER BY TimeInsert DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
$sql = "SELECT * FROM imagelog WHERE Screened = 1 ORDER BY ImageID DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
}
$descr = "time";
$tableVar = 'TimeInsert';
}
elseif($sortBy == "Recent")
{
if($author)
{
$sql = "SELECT imagelog.*, MAX(comments.TimeInsert) AS Recent FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND imagelog.UserID = " . $author . " AND imagelog.Screened = 1 GROUP BY comments.ImageID ORDER BY Recent DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} elseif($key) {
$sql = "SELECT imagelog.*, MAX(comments.TimeInsert) AS Recent FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND imagelog.KeyID = " . $key . " AND imagelog.Screened = 1 GROUP BY comments.ImageID ORDER BY Recent DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} else {
$sql = "SELECT imagelog.*, MAX(comments.TimeInsert) AS Recent FROM imagelog, comments WHERE imagelog.ImageID = comments.ImageID AND imagelog.Screened = 1 GROUP BY comments.ImageID ORDER BY Recent DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
}
$descr = "lastcomment";
$tableVar = 'Recent';
} else {
if($author)
{
$sql = "SELECT * FROM imagelog WHERE UserID = " . $author . " AND imagelog.Screened = 1 ORDER BY Num_comments DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} elseif($key) {
$sql = "SELECT * FROM imagelog WHERE KeyID = " . $key . " AND imagelog.Screened = 1 ORDER BY Num_comments DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
} else {
$sql = "SELECT * FROM imagelog WHERE imagelog.Screened = 1 ORDER BY Num_comments DESC LIMIT " . $imageCounter . "," . $imagesPerPage . ";";
}
$descr = "comments";
$tableVar = 'Num_comments';
}
$db_object->query($sql);
} else {
//$msg = "No photos to display.";
//$error = true;
}
include_once("include/header.php");
include_once("include/msg.php");
//if($totalImages || $sortBy == "Recent")
//{
?>
Notice: Undefined variable: screenName in /var/www/demonstrate.berkeley.edu/html/archive.php on line 250
|
| |
Notice: Undefined variable: keyName in /var/www/demonstrate.berkeley.edu/html/archive.php on line 257
|
| |
fetch_array()))
{
$sql = "SELECT Key_name FROM `keys` WHERE KeyID = " . $row["KeyID"] . ";";
$db_object2->query($sql);
$row2 = $db_object2->fetch_array();
if($currentColumn >= $imagesPerRow) {
$currentColumn = 0;
$currentRow++;
print " | | ";
}
?>
10)
{
print substr($row2["Key_name"], 0, 10) . "...:\n";
} else {
print $row2["Key_name"] . ":\n";
}
?>
Notice: Undefined variable: row in /var/www/demonstrate.berkeley.edu/html/archive.php on line 298
$hour:$min:$sec
$month/$day/$year";
} else {
print "![](\"images/lbl_$descr.gif\") " . $row[$tableVar];
}
?>
|
|
| ';
?>
| No photos to display. |
| |
| |
$imagesPerPage) { ?>
= $totalImages) {
$maxPrevPages = 0;
$maxNextPages = 0;
$currentPage = 1;
}
else {
$maxPrevPages = ($prevImageCounter % $imagesPerPage == 0 ? (int)($prevImageCounter / $imagesPerPage) : (int)($prevImageCounter / $imagesPerPage) + 1);
$currentPage = $maxPrevPages + 1;
if($imageCounter >= $totalImages) {
$maxNextPages = 0;
}
else {
$maxNextPages = (($totalImages - $imageCounter) % $imagesPerPage == 0 ? (int)(($totalImages - $imageCounter) / $imagesPerPage) : (int)(($totalImages - $imageCounter) / $imagesPerPage) + 1);
}
}
if($maxPrevPages >= $midlePage - 1 && $maxNextPages >= $midlePage) {
$startPage = $currentPage + 1 - $midlePage;
$endPage = $currentPage + $midlePage;
}
else if($maxPrevPages >= $midlePage - 1) {
$endPage = $currentPage + $maxNextPages;
$startPage = $currentPage + 1 - $midlePage;
while(($endPage - $startPage + 1 < ($midlePage*2)) && $startPage > 1) { // startPage >= 1
$startPage--;
}
}
else if($maxNextPages >= $midlePage) {
$startPage = 1;
$endPage = $currentPage + $midlePage;
//print $endPage;
while(($endPage - $startPage + 1 < ($midlePage*2)) && ($endPage < $maxPrevPages + $maxNextPages + 1)) { // endPage <=
$endPage++;
}
}
else {
$startPage = 1;
$endPage = $maxPrevPages + $maxNextPages + 1;
}
if($offset > 0 && $offset < $totalImages) {
$temp = $prevImageCounter - $imagesPerPage;
$temp = (($temp < 0 || $temp >= $totalImages) ? 0 : $temp);
echo "![\"Previous\"](\"images/previous.gif\") ";
} else {
echo ' ';
}
//print "Start page: $startPage, $endPage";
for($counter = $startPage; $counter <= $endPage && $startPage != $endPage; $counter++) {
if($counter == $currentPage) {
echo "$counter";
}
else {
$temp = ($counter < $currentPage ? $prevImageCounter - ($maxPrevPages + 1 - $counter) * $imagesPerPage
: $imageCounter + ($counter - $currentPage - 1) * $imagesPerPage);
$temp = (($temp < 0 || $temp >= $totalImages) ? 0 : $temp);
echo "$counter";
}
echo " ";
}
if($imageCounter < $totalImages) {
echo " ![\"Next\"](\"images/next.gif\") ";
} else {
echo '  ';
}
?>
|
| |
|
|
