$keywords[] = $keyword2;
}
if ($keyword3 != "") {
$keywords[] = $keyword3;
}
if (sizeof($keywords) >= 1) {
_generate_search_images($source, $keywords[0], True);
$search_text = "(All) " . $keywords[0];
for ($x = 1; $x < sizeof($keywords); $x++) {
__query("TRUNCATE TABLE exhibit_" . $target, "", "");
_generate_search_comparison($source, $keywords[$x], $target);
$temp_table = $target;
$target = $source;
$source = $temp_table;
$search_text .= ", " . $keywords[$x];
}
}
// source will always contain final results due to for loop.
$search_query = "SELECT * FROM exhibit_" . $source . " WHERE " . _user_permissions($__user['Username'], 'query') . " GROUP BY ImageID, iPhotoLibraryID LIMIT 1000";
_display_search($search_query, $search_text);
__query("DROP TABLE exhibit_" . $source, "", "");
__query("DROP TABLE exhibit_" . $target, "", "");
}
} elseif ($roll and $library) {
_display_images($roll, $library, $__user['Username']);
} else {
_display_rolls($__user['Username']);
}
_page_section("search.png", "Search for photos");
_draw_search_key();
_page_footer();
function _display_rolls($username)
{
global $__dbc;
global $number_of_columns;
global $image_src;
global $rating;
global $table_format;
$query = "SELECT exhibit_Rolls.*, exhibit_Permissions.GroupID AS GroupID, " . "exhibit_Permissions.Public AS Public " . "FROM exhibit_Rolls LEFT JOIN exhibit_Permissions ON " . "(exhibit_Rolls.iPhotoLibraryID=exhibit_Permissions.iPhotoLibraryID AND" . " exhibit_Rolls.RollID=exhibit_Permissions.RollID) WHERE " . _user_permissions($username, 'query') . " ORDER BY RollDate DESC";
$sql_results = __query($query, "", "");
$process_results = array();
echo $table_format;
while ($row = mysql_fetch_array($sql_results)) {
$query = "select GUID, ThumbPath from exhibit_Images where " . "iPhotoLibraryID = " . $row['iPhotoLibraryID'] . " AND " . "ImageID = " . $row['KeyPhoto'];
$image = mysql_fetch_array(__query($query, "", ""));
$image_thumb = $row['iPhotoLibraryID'] . $image["GUID"] . 'T.' . _find_file_extension($image["ThumbPath"]);
$photo_count = "<span class=\"exhibitcontent\">" . $row["PhotoCount"];
if ($row["PhotoCount"] == 1) {
$photo_count .= " photo</span>";
} else {
$photo_count .= " photos</span>";
}
$process_results[] = array("<a href=\"http://www.example.com" . $_SERVER[PHP_SELF] . "?library=" . $row["iPhotoLibraryID"] . "&roll=" . $row["RollID"] . "\">" . "<img border=\"0\" class=\"exhibit\" src=\"" . $image_src . $image_thumb . "\" /></a>", "<span class=\"exhibitcontent\">" . $row["RollName"] . "</span>", "<span class=\"exhibitcontent\">" . $row["RollDate"] . "</span>", $photo_count);
if (count($process_results) == $number_of_columns) {
_print_row($process_results);
unset($process_results);
$process_results = array();
}
}
if (count($process_results) != 0) {
_print_row($process_results);
}
echo "\n\t\t\t\t\t</table>\n";
}
