function _display_search($image_query, $search_text) { global $__dbc; global $number_of_columns; global $image_src; global $rating; global $table_format; $images = __query($image_query, "", ""); echo mysql_info($__dbc); _page_sechead("search.png", "Search Results For: " . $search_text . ". " . mysql_num_rows($images) . " images found."); echo $table_format; while ($row = mysql_fetch_array($images)) { $image_thumb = $row['iPhotoLibraryID'] . $row["GUID"] . 'T.' . _find_file_extension($row["ThumbPath"]); $image_full = $row['iPhotoLibraryID'] . $row["GUID"] . "." . _find_file_extension($row["ImagePath"]); $image_slimbox_caption = "Keywords: "; $keyword_query = "SELECT exhibit_Keywords.Keyword AS Keyword FROM " . "exhibit_Keywords LEFT JOIN " . "exhibit_ImageKeywords ON (exhibit_Keywords.iPhotoLibraryID = " . "exhibit_ImageKeywords.iPhotoLibraryID AND exhibit_Keywords.KeywordID" . "=exhibit_ImageKeywords.KeywordID) WHERE " . "exhibit_ImageKeywords.iPhotoLibraryID=" . $row["iPhotoLibraryID"] . " AND exhibit_ImageKeywords.ImageID=" . $row["ImageID"]; $image_keywords = __query($keyword_query, "", ""); while ($keyword_row = mysql_fetch_array($image_keywords)) { $image_slimbox_caption .= $keyword_row["Keyword"] . ", "; } $image_slimbox_caption = rtrim($image_slimbox_caption, ", ") . "<br />"; if ($row["Comment"] != "") { $image_slimbox_caption .= "Comments: " . $row["Comment"] . "<br />"; } $image_slimbox_caption .= "Date: " . $row["OriginalDate"] . "<br />"; $image_slimbox_caption .= $rating[$row["Rating"]] . "<br />"; $image_slimbox_caption .= "<a href="" . $image_src . $image_full . "">"; if ($row["MediaType"] == "Image") { $image_slimbox_caption .= "(See Full-sized Image)</a>"; } else { $image_slimbox_caption .= "(See Video)</a>"; } $process_results[] = array("<a href=\"" . $image_src . $image_thumb . "\" rel=\"lightbox[" . $roll_name[0] . "]\" title=\"" . $image_slimbox_caption . "\"><img border=\"0\" class=\"exhibit\" " . "src=\"" . $image_src . $image_thumb . "\" /></a>", "<span class=\"exhibitcontent\">" . $row["Comment"] . "</span>", "<span class=\"exhibitcontent\">" . $row["OriginalDate"] . "</span>", "<span class=\"exhibitcontent\">" . $rating[$row["Rating"]] . "</span>"); 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"; }
function _display_permissions() { global $__dbc; global $image_src; global $table_format; $roll_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) " . "ORDER BY RollDate DESC"; $roll_results = __query($roll_query, "", ""); $group_query = "SELECT * FROM exhibit_Groups"; $group_results = __query($group_query, "", ""); $groups = array(); while ($row = mysql_fetch_array($group_results)) { $groups[$row['ID']] = array('GroupName' => $row['GroupName'], 'GroupDescription' => $row['GroupDescription']); } echo $table_format . "<td>Cover </td><td>Roll Name</td><td>Roll Date</td>" . "<td># of Photos </td>" . "<td>Public? </td>" . "<td>Group </td><td> </td>"; $table = array(); while ($row = mysql_fetch_array($roll_results)) { $query = "select GUID, ThumbPath from exhibit_Images where " . "iPhotoLibraryID = " . $row['iPhotoLibraryID'] . " AND " . "ImageID = " . $row['KeyPhoto']; $image = mysql_fetch_array(__query($query, "", "")); $image_thumb = "<td width=\"40px\"><a href=\"http://www.example.com" . $_SERVER[PHP_SELF] . "?library=" . $row["iPhotoLibraryID"] . "&roll=" . $row['RollID'] . "\"><img border=\"0\" " . " class=\"exhibitpermissions\" " . "src=\"" . $image_src . $row['iPhotoLibraryID'] . $image['GUID'] . 'T.' . _find_file_extension($image['ThumbPath']) . "\" /></a></td>"; $photo_count = "<td><span class=\"exhibitcontent\">" . $row["PhotoCount"]; if ($row["PhotoCount"] == 1) { $photo_count .= " photo</span></td>"; } else { $photo_count .= " photos</span></td>"; } $roll_name = "<td><span class=\"exhibitcontent\">" . $row['RollName'] . "</span></td>"; $roll_date = "<td><span class=\"exhibitcontent\">" . $row['RollDate'] . "</span></td>"; $public = "<td><form action=\"" . $_SERVER[PHP_SELF] . "\" method=\"post\">" . "<input type=\"hidden\" name=\"library\" " . "value=\"" . $row['iPhotoLibraryID'] . "\">" . "<input type=\"hidden\" name=\"roll\" " . "value=\"" . $row['RollID'] . "\">" . "<select name=\"public\" size=\"1\">"; if ($row['Public'] == 1) { $public .= "<option value=\"0\">False</option>" . "<option selected value=\"1\">True</option></select></td>"; } else { $public .= "<option selected value=\"0\">False</option>" . "<option value=\"1\">True</option></select></td>"; } $group_list = "<td><select name=\"group\" size=\"1\">"; if (!array_key_exists($row['GroupID'], $groups)) { $group_list .= "<option selected value=\"0\">None.</option>"; } else { $group_list .= "<option value=\"0\">None.</option>"; } foreach ($groups as $key => $value) { if ($row['GroupID'] == $key) { $group_list .= "<option selected value=\"" . $key . "\">" . $value['GroupName'] . "</option>"; } else { $group_list .= "<option value=\"" . $key . "\">" . $value['GroupName'] . "</option>"; } } $group_list .= "</select></td>"; $edit = "<td><input type=\"submit\" value=\" UPDATE \"></form></td>"; $table[] = array($image_thumb, $roll_name, $roll_date, $photo_count, $public, $group_list, $edit); } _print_rows($table); echo "\n\t\t\t\t\t</table>\n"; }