require("components/settings.php");
require("components/pager.php");
$page = intval($_GET["p"]);
if (!$page) { $page = 0; }
$grade_get = intval($_GET["g"]);
if (isset($_GET["g"])) {
$grade_filter = "WHERE grade_id = '$grade_get'";
}
$next_offset = $page * $limit;
$sql_limit = " LIMIT $next_offset, $limit";
$active = "collection";
$selected = "";
?>
$query = "SELECT *, grade_id
FROM artwork
INNER JOIN artwork_grade ON artwork.id = artwork_grade.artwork_id
$grade_filter";
$result_num = mysql_query($query);
$filtered_rows = mysql_num_rows($result_num);
showPagerMultiple(
$query, // Database Table
FALSE, // Loop
FALSE // Display ID
);
$query = "SELECT *
FROM artwork";
$result_num = mysql_query($query);
$num_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '1'";
$result_num = mysql_query($query);
$good_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '2'";
$result_num = mysql_query($query);
$crop_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '3' OR grade_id = '4'";
$result_num = mysql_query($query);
$lowmiss_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '5' OR grade_id = '6'";
$result_num = mysql_query($query);
$bad_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '7'";
$result_num = mysql_query($query);
$maybe_rows = mysql_num_rows($result_num);
$query = "SELECT *
FROM artwork_grade
WHERE grade_id = '8'";
$result_num = mysql_query($query);
$damage_rows = mysql_num_rows($result_num);
$directory = "images/artwork/serigraphs/lowres/";
$files = glob($directory . "*.jpg");
if ( $files !== false )
{
$filecount = count( $files );
}
$missing_images = $num_rows - $filecount;
?>
— Total entries.
0 — Potentially usable images.
0 — Unusable images.
if (isset($grade_filter)) {
$result_tag = @mysql_query("SELECT grade FROM grade WHERE id=$grade_get LIMIT 1");
$row = mysql_fetch_array($result_tag);
$grade_name = $row["grade"];
?>
Only showing entries with a grade of .
}
?>
$result = @mysql_query(
"SELECT
id,
archive_number,
piece_number,
image_name,
title,
type,
border,
grade,
grade_id
FROM artwork
LEFT JOIN artwork_grade ON artwork.id = artwork_grade.artwork_id
$grade_filter
ORDER BY id ASC
$sql_limit"
);
while ($row = mysql_fetch_array($result)){
$title = strtolower($row["title"]);
$id = $row["id"];
$type = $row["type"];
$image_name = $row["image_name"];
$archive_number = $row["archive_number"];
$border = $row["border"];
//$grade = $row["grade"];
$grade_id = $row["grade_id"];
if ($grade_id == 1) { $background_color = "#75c486"; }
if ($grade_id == 2 || $grade_id == 7) { $background_color = "#ffd879"; }
if ($grade_id == 3 || $grade_id == 4 || $grade_id == 5 || $grade_id == 6 || $grade_id == 8) { $background_color = "#f77e6f"; }
?>
}
?>
if (isset($grade_filter)) {
$grade_link = intval($_GET["g"]);
$grade_link = "&g=$grade_link";
}
?>
if (isset($limit_back_calc) && $limit_back_calc > -1) { ?>
} ?>
Current Page —
Entries Per Page
if (isset($limit_next_calc)) { ?>
} ?>
require("components/footer.php"); ?>