+ public function resetTagSearch()
+ {
+ unset($_SESSION['searchfor']);
+
+ } // resetTagSearch()
+
+ public function getPhotoSelection()
+ {
+ $tagged_photos = Array();
+
+ /* return a search result */
+ if(isset($_SESSION['searchfor']) && $_SESSION['searchfor'] != '') {
+ $result = $this->db->db_query("
+ SELECT DISTINCT photo_id
+ FROM photo_tags pt
+ INNER JOIN photos p
+ ON p.id=pt.photo_id
+ INNER JOIN tags t
+ ON pt.tag_id=t.id
+ WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%'
+ ORDER BY p.time ASC
+ ");
+ while($row = $this->db->db_fetch_object($result)) {
+ array_push($tagged_photos, $row['photo_id']);
+ }
+ return $tagged_photos;
+ }
+
+ /* return according the selected tags */
+ if(isset($_SESSION['selected_tags']) && !empty($_SESSION['selected_tags'])) {
+ $selected = "";
+ foreach($_SESSION['selected_tags'] as $tag)
+ $selected.= $tag .",";
+ $selected = substr($selected, 0, strlen($selected)-1);
+
+ if($_SESSION['tag_condition'] == 'or') {
+ $result = $this->db->db_query("
+ SELECT DISTINCT photo_id
+ FROM photo_tags pt
+ INNER JOIN photos p
+ ON p.id=pt.photo_id
+ WHERE pt.tag_id IN (". $selected .")
+ ORDER BY p.time ASC
+ ");
+ }
+ elseif($_SESSION['tag_condition'] == 'and') {
+
+ /* Join together a table looking like
+
+ pt1.photo_id pt1.tag_id pt2.photo_id pt2.tag_id ...
+
+ so the query can quickly return all images matching the
+ selected tags in an AND condition
+
+ */
+
+ $query_str = "
+ SELECT DISTINCT pt1.photo_id
+ FROM photo_tags pt1
+ ";
+
+ for($i = 0; $i < count($_SESSION['selected_tags']); $i++) {
+ $query_str.= "
+ INNER JOIN photo_tags pt". ($i+2) ."
+ ON pt1.photo_id=pt". ($i+2) .".photo_id
+ ";
+ }
+ $query_str.= "WHERE pt1.tag_id=". $_SESSION['selected_tags'][0];
+ for($i = 1; $i < count($_SESSION['selected_tags']); $i++) {
+ $query_str.= "
+ AND pt". ($i+1) .".tag_id=". $_SESSION['selected_tags'][$i] ."
+ ";
+ }
+ $result = $this->db->db_query($query_str);
+ }
+
+ while($row = $this->db->db_fetch_object($result)) {
+ array_push($tagged_photos, $row['photo_id']);
+ }
+ return $tagged_photos;
+ }
+
+ /* return all available photos */
+ $result = $this->db->db_query("
+ SELECT DISTINCT photo_id
+ FROM photo_tags pt
+ INNER JOIN photos p
+ ON p.id=pt.photo_id
+ ORDER BY p.time ASC
+ ");
+ while($row = $this->db->db_fetch_object($result)) {
+ array_push($tagged_photos, $row['photo_id']);
+ }
+ return $tagged_photos;
+
+ } // getPhotoSelection()
+
+ public function showPhotoIndex()
+ {
+ $photos = $this->getPhotoSelection();
+
+ $count = count($photos);
+
+ if(isset($_SESSION['begin_with']) && $_SESSION['begin_with'] != "")
+ $anchor = $_SESSION['begin_with'];
+
+ if(!isset($this->cfg->rows_per_page) || $this->cfg->rows_per_page == 0) {
+
+ $begin_with = 0;
+ $end_with = $count;
+
+ }
+ elseif($this->cfg->rows_per_page > 0) {
+
+ if(!$_SESSION['begin_with'] || $_SESSION['begin_with'] == 0)
+ $begin_with = 0;
+ else {
+
+ $begin_with = $_SESSION['begin_with'];
+
+ // verify $begin_with - perhaps the thumbs-per-rows or
+ // rows-per-page variables have changed or the jump back
+ // from a photo wasn't exact - so calculate the real new
+ // starting point
+ $multiplicator = $this->cfg->rows_per_page * $this->cfg->thumbs_per_row;
+ for($i = 0; $i <= $count; $i+=$multiplicator) {
+ if($begin_with >= $i && $begin_with < $i+$multiplicator) {
+ $begin_with = $i;
+ break;
+ }
+ }
+ }
+
+ $end_with = $begin_with + ($this->cfg->rows_per_page * $this->cfg->thumbs_per_row);
+ }
+
+
+ $rows = 0;
+ $cols = 0;
+ $images[$rows] = Array();
+ $img_height[$rows] = Array();
+ $img_width[$rows] = Array();
+ $img_id[$rows] = Array();
+
+ for($i = $begin_with; $i < $end_with; $i++) {
+
+ $images[$rows][$cols] = $photos[$i];
+ $img_id[$rows][$cols] = $i;
+
+ $thumb_path = $this->cfg->base_path ."/thumbs/". $this->cfg->thumb_width ."_". $this->getMD5($photos[$i]);
+
+ if(file_exists($thumb_path)) {
+ $info = getimagesize($thumb_path);
+ $img_width[$rows][$cols] = $info[0];
+ $img_height[$rows][$cols] = $info[1];
+ }
+
+ if($cols == $this->cfg->thumbs_per_row-1) {
+ $cols = 0;
+ $rows++;
+ $images[$rows] = Array();
+ $img_width[$rows] = Array();
+ $img_height[$rows] = Array();
+ }
+ else {
+ $cols++;
+ }
+ }
+
+ // +1 for for smarty's selection iteration
+ $rows++;
+
+ if(isset($_SESSION['searchfor']) && $_SESSION['searchfor'] != '')
+ $this->tmpl->assign('searchfor', $_SESSION['searchfor']);
+
+ if($this->cfg->rows_per_page != 0) {
+
+ /* calculate the page switchers */
+ $previous_start = $begin_with - ($this->cfg->rows_per_page * $this->cfg->thumbs_per_row);
+ $next_start = $begin_with + ($this->cfg->rows_per_page * $this->cfg->thumbs_per_row);
+
+ if($begin_with != 0)
+ $this->tmpl->assign("previous_url", "javascript:showPhotoIndex(". $previous_start .");");
+ if($end_with < $count)
+ $this->tmpl->assign("next_url", "javascript:showPhotoIndex(". $next_start .");");
+
+ /* page selector */
+ $photo_per_page = $this->cfg->rows_per_page * $this->cfg->thumbs_per_row;
+
+ /* until 6 pages we show the selector from 1-6
+ everything large will be
+ 1 ... 2 3 4 (5) 6 7 ... 9
+ */
+ $last_page = ceil($count / $photo_per_page);
+
+ if($begin_with == 0) {
+ $current_page = 1;
+ }
+ else {
+ $current_page = 0;
+ for($i = $begin_with; $i >= 0; $i-=$photo_per_page) {
+ $current_page++;
+ }
+ }
+
+ for($i = 1; $i <= $last_page; $i++) {
+
+ if($current_page == $i)
+ $style = "style=\"font-size: 125%;\"";
+ elseif($current_page-1 == $i || $current_page+1 == $i)
+ $style = "style=\"font-size: 105%;\"";
+ elseif(($current_page-5 >= $i) && ($i != 1) ||
+ ($current_page+5 <= $i) && ($i != $last_page))
+ $style = "style=\"font-size: 75%;\"";
+ else
+ $style = "";
+
+ $page_select.= "<a href=\"javascript:showPhotoIndex(". (($i*$photo_per_page)-$photo_per_page) .");\"";
+ if($style != "")
+ $page_select.= $style;
+ $page_select.= ">". $i ."</a> ";
+
+ }
+
+ /* only show the page selector if we have more then one page */
+ if($last_page > 1)
+ $this->tmpl->assign('page_selector', $page_select);
+ }
+
+ $current_tags = "";
+ if($_SESSION['selected_tags'] != "") {
+ foreach($_SESSION['selected_tags'] as $tag)
+ $current_tags.= $tag .",";
+ $current_tags = substr($current_tags, 0, strlen($current_tags)-1);
+ }
+
+ $extern_link = "http://". $_SERVER['SERVER_NAME'] ."/index.php?mode=showpi&tags=". $current_tags;
+
+ $this->tmpl->assign('extern_link', $extern_link);
+ $this->tmpl->assign('count', $count);
+ $this->tmpl->assign('width', $this->cfg->thumb_width);
+ $this->tmpl->assign('images', $images);
+ $this->tmpl->assign('img_width', $img_width);
+ $this->tmpl->assign('img_height', $img_height);
+ $this->tmpl->assign('img_id', $img_id);
+ $this->tmpl->assign('rows', $rows);
+ $this->tmpl->assign('columns', $this->cfg->thumbs_per_row);
+
+ $this->tmpl->show("photo_index.tpl");
+
+ if(isset($anchor))
+ print "<script language=\"JavaScript\">self.location.hash = '#image". $anchor ."';</script>\n";
+
+ } // showPhotoIndex()
+
+ public function showBubbleDetails($photo, $direction)
+ {
+ if($direction == "up")
+ $direction = "bubbleimg_up";
+ else
+ $direction = "bubbleimg_down";
+
+ $details = $this->get_photo_details($photo);
+ $orig_path = $this->translate_path($details['directory_path']) ."/". $details['name'];
+
+ $image_url = "phpfspot_img.php?idx=". $photo ."&width=". $this->cfg->bubble_width;
+
+ $filesize = filesize($orig_path);
+ $filesize = rand($filesize/1024, 2);
+
+ if(!file_exists($orig_path)) {
+ $this->_warning("Photo ". $orig_path ." does not exist!<br />\n");
+ return;
+ }
+
+ if(!is_readable($orig_path)) {
+ $this->_warning("Photo ". $orig_path ." is not readable for user ". get_current_user() ."<br />\n");
+ return;
+ }
+
+ $img = getimagesize($orig_path);
+
+ $this->tmpl->assign('file_size', $filesize);
+ $this->tmpl->assign('width', $img[0]);
+ $this->tmpl->assign('height', $img[1]);
+ $this->tmpl->assign('file_name', $details['name']);
+ $this->tmpl->assign('image_id', $direction);
+ $this->tmpl->assign('image_url', $image_url);
+ $this->tmpl->show("bubble_details.tpl");
+
+ } // showBubbleDetails()
+
+ public function showCredits()
+ {
+ $this->tmpl->assign('version', $this->cfg->version);
+ $this->tmpl->assign('product', $this->cfg->product);
+ $this->tmpl->show("credits.tpl");
+
+ } // showCredits()
+
+ public function create_thumbnail($orig_image, $thumb_image, $width)
+ {
+ if(!file_exists($orig_image))
+ return false;
+
+ $details = getimagesize($orig_image);
+
+ /* check if original photo is a support image type */
+ if(!$this->checkifImageSupported($details['mime']))
+ return false;
+
+ $meta = $this->get_meta_informations($orig_image);
+
+ $rotate = 0;
+ $flip = false;
+
+ switch($meta['Orientation']) {
+
+ case 1:
+ $rotate = 0; $flip = false; break;
+ case 2:
+ $rotate = 0; $flip = true; break;
+ case 3:
+ $rotate = 180; $flip = false; break;
+ case 4:
+ $rotate = 180; $flip = true; break;
+ case 5:
+ $rotate = 90; $flip = true; break;
+ case 6:
+ $rotate = 90; $flip = false; break;
+ case 7:
+ $rotate = 270; $flip = true; break;
+ case 8:
+ $rotate = 270; $flip = false; break;
+ }
+
+ $src_img = @imagecreatefromjpeg($orig_image);
+
+ if(!$src_img) {
+ print "Can't load image from ". $orig_image ."\n";
+ return false;
+ }
+
+ /* grabs the height and width */
+ $cur_width = imagesx($src_img);
+ $cur_height = imagesy($src_img);
+
+ // If requested width is more then the actual image width,
+ // do not generate a thumbnail
+
+ if($width >= $cur_width) {
+ imagedestroy($src_img);
+ return true;
+ }
+
+ /* calculates aspect ratio */
+ $aspect_ratio = $cur_height / $cur_width;
+
+ /* sets new size */
+ if($aspect_ratio < 1) {
+ $new_w = $width;
+ $new_h = abs($new_w * $aspect_ratio);
+ } else {
+ /* 'virtually' rotate the image and calculate it's ratio */
+ $tmp_w = $cur_height;
+ $tmp_h = $cur_width;
+ /* now get the ratio from the 'rotated' image */
+ $tmp_ratio = $tmp_h/$tmp_w;
+ /* now calculate the new dimensions */
+ $tmp_w = $width;
+ $tmp_h = abs($tmp_w * $tmp_ratio);
+
+ // now that we know, how high they photo should be, if it
+ // gets rotated, use this high to scale the image
+ $new_h = $tmp_h;
+ $new_w = abs($new_h / $aspect_ratio);
+ }
+
+ /* creates new image of that size */
+ $dst_img = imagecreatetruecolor($new_w, $new_h);
+
+ imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255));
+
+ /* copies resized portion of original image into new image */
+ imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));
+
+ /* needs the image to be flipped horizontal? */
+ if($flip) {
+ print "(FLIP)";
+ $image = $dst_img;
+ for($x = 0; $x < $new_w; $x++) {
+ imagecopy($dst_img, $image, $x, 0, $w - $x - 1, 0, 1, $h);
+ }
+ }
+
+ if($rotate) {
+ $this->_debug("(ROTATE)");
+ $dst_img = $this->rotateImage($dst_img, $rotate);
+ }
+
+ /* write down new generated file */
+ $result = imagejpeg($dst_img, $thumb_image, 75);
+
+ /* free your mind */
+ imagedestroy($dst_img);
+ imagedestroy($src_img);
+
+ if($result === false) {
+ print "Can't write thumbnail ". $thumb_image ."\n";
+ return false;
+ }
+
+ return true;
+
+ } // create_thumbnail()
+
+ public function get_meta_informations($file)
+ {
+ return exif_read_data($file);
+
+ } // get_meta_informations()
+
+ public function check_config_table()
+ {
+ // if the config table doesn't exist yet, create it
+ if(!$this->cfg_db->db_check_table_exists("images")) {
+ $this->cfg_db->db_exec("
+ CREATE TABLE images (
+ img_idx int primary key,
+ img_md5 varchar(32)
+ )
+ ");
+ }
+
+ } // check_config_table
+
+ /**
+ * Generates a thumbnail from photo idx
+ *
+ * This function will generate JPEG thumbnails from provided F-Spot photo
+ * indizes.
+ *
+ * 1. Check if all thumbnail generations (width) are already in place and
+ * readable
+ * 2. Check if the md5sum of the original file has changed
+ * 3. Generate the thumbnails if needed
+ */
+ public function gen_thumb($idx = 0, $force = 0)
+ {
+ $error = 0;
+
+ $resolutions = Array(
+ $this->cfg->thumb_width,
+ $this->cfg->bubble_width,
+ $this->cfg->photo_width,
+ );
+
+ /* get details from F-Spot's database */
+ $details = $this->get_photo_details($idx);
+
+ /* calculate file MD5 sum */
+ $full_path = $this->translate_path($details['directory_path']) ."/". $details['name'];
+
+ if(!file_exists($full_path)) {
+ $this->_warning("File ". $full_path ." does not exist\n");
+ return;
+ }
+
+ if(!is_readable($full_path)) {
+ $this->_warning("File ". $full_path ." is not readable for ". get_current_user() ."\n");
+ return;
+ }
+
+ $file_md5 = md5_file($full_path);
+
+ $this->_debug("Image [". $idx ."] ". $details['name'] ." Thumbnails:");
+
+ foreach($resolutions as $resolution) {
+
+ $thumb_path = $this->cfg->base_path ."/thumbs/". $resolution ."_". $file_md5;
+
+ /* if the thumbnail file doesn't exist, create it */
+ if(!file_exists($thumb_path)) {
+
+ $this->_debug(" ". $resolution ."px");
+ if(!$this->create_thumbnail($full_path, $thumb_path, $resolution))
+ $error = 1;
+ }
+
+ /* if the file hasn't changed there is no need to regen the thumb */
+ elseif($file_md5 != $this->getMD5($idx) || $force) {
+
+ $this->_debug(" ". $resolution ."px");
+ if(!$this->create_thumbnail($full_path, $thumb_path, $resolution))
+ $error = 1;
+
+ }
+ }
+
+ /* set the new/changed MD5 sum for the current photo */
+ if(!$error) {
+ $this->setMD5($idx, $file_md5);
+ }
+
+ $this->_debug("\n");
+
+ } // gen_thumb()
+
+ public function getMD5($idx)
+ {
+ $result = $this->cfg_db->db_query("
+ SELECT img_md5
+ FROM images
+ WHERE img_idx='". $idx ."'
+ ");
+
+ if(!$result)
+ return 0;
+
+ $img = $this->cfg_db->db_fetch_object($result);
+ return $img['img_md5'];
+
+ } // getMD5()
+
+ private function setMD5($idx, $md5)
+ {
+ $result = $this->cfg_db->db_exec("
+ REPLACE INTO images (img_idx, img_md5)
+ VALUES ('". $idx ."', '". $md5 ."')
+ ");
+
+ } // setMD5()
+
+ public function setTagCondition($mode)
+ {
+ $_SESSION['tag_condition'] = $mode;
+
+ } // setTagCondition()
+
+ public function startTagSearch($searchfor)
+ {
+ $_SESSION['searchfor'] = $searchfor;
+ $_SESSION['selected_tags'] = Array();
+
+ foreach($this->avail_tags as $tag) {
+ if(preg_match('/'. $searchfor .'/i', $this->tags[$tag]))
+ array_push($_SESSION['selected_tags'], $tag);
+ }
+
+ } // startTagSearch()
+
+ private function rotateImage($img, $degrees)
+ {
+ if(function_exists("imagerotate"))
+ $img = imagerotate($img, $degrees, 0);
+ else
+ {
+ function imagerotate($src_img, $angle)
+ {
+ $src_x = imagesx($src_img);
+ $src_y = imagesy($src_img);
+ if ($angle == 180) {
+ $dest_x = $src_x;
+ $dest_y = $src_y;
+ }
+ elseif ($src_x <= $src_y) {
+ $dest_x = $src_y;
+ $dest_y = $src_x;
+ }
+ elseif ($src_x >= $src_y) {
+ $dest_x = $src_y;
+ $dest_y = $src_x;
+ }
+
+ $rotate=imagecreatetruecolor($dest_x,$dest_y);
+ imagealphablending($rotate, false);
+
+ switch ($angle) {
+
+ case 90:
+ for ($y = 0; $y < ($src_y); $y++) {
+ for ($x = 0; $x < ($src_x); $x++) {
+ $color = imagecolorat($src_img, $x, $y);
+ imagesetpixel($rotate, $dest_x - $y - 1, $x, $color);
+ }
+ }
+ break;
+
+ case 270:
+ for ($y = 0; $y < ($src_y); $y++) {
+ for ($x = 0; $x < ($src_x); $x++) {
+ $color = imagecolorat($src_img, $x, $y);
+ imagesetpixel($rotate, $y, $dest_y - $x - 1, $color);
+ }
+ }
+ break;
+
+ case 180:
+ for ($y = 0; $y < ($src_y); $y++) {
+ for ($x = 0; $x < ($src_x); $x++) {
+ $color = imagecolorat($src_img, $x, $y);
+ imagesetpixel($rotate, $dest_x - $x - 1, $dest_y - $y - 1, $color);
+ }
+ }
+ break;
+
+ default: $rotate = $src_img;
+ };
+
+ return $rotate;
+
+ }
+
+ $img = imagerotate($img, $degrees);
+
+ }
+
+ return $img;
+
+ } // rotateImage()
+
+ private function get_photo_tags($idx)
+ {
+ $result = $this->db->db_query("
+ SELECT t.id, t.name
+ FROM tags t
+ INNER JOIN photo_tags pt
+ ON t.id=pt.tag_id
+ WHERE pt.photo_id='". $idx ."'
+ ");
+
+ $tags = Array();
+
+ while($row = $this->db->db_fetch_object($result))
+ $tags[$row['id']] = $row['name'];
+
+ return $tags;
+
+ } // get_photo_tags()
+
+ public function showTextImage($txt, $color=000000, $space=4, $font=4, $w=300)
+ {
+ if (strlen($color) != 6)
+ $color = 000000;
+
+ $int = hexdec($color);
+ $h = imagefontheight($font);
+ $fw = imagefontwidth($font);
+ $txt = explode("\n", wordwrap($txt, ($w / $fw), "\n"));
+ $lines = count($txt);
+ $im = imagecreate($w, (($h * $lines) + ($lines * $space)));
+ $bg = imagecolorallocate($im, 255, 255, 255);
+ $color = imagecolorallocate($im, 0xFF & ($int >> 0x10), 0xFF & ($int >> 0x8), 0xFF & $int);
+ $y = 0;
+
+ foreach ($txt as $text) {
+ $x = (($w - ($fw * strlen($text))) / 2);
+ imagestring($im, $font, $x, $y, $text, $color);
+ $y += ($h + $space);
+ }
+
+ Header("Content-type: image/png");
+ ImagePng($im);
+
+ } // showTextImage()
+
+ private function checkRequirements()
+ {
+ if(!function_exists("imagecreatefromjpeg")) {
+ print "PHP GD library extension is missing<br />\n";
+ $missing = true;
+ }
+
+ if(!function_exists("sqlite3_open")) {
+ print "PHP SQLite3 library extension is missing<br />\n";
+ $missing = true;
+ }
+
+ /* Check for HTML_AJAX PEAR package, lent from Horde project */
+ ini_set('track_errors', 1);
+ @include_once 'HTML/AJAX/Server.php';
+ if(isset($php_errormsg)) {
+ print "PEAR HTML_AJAX package is missing<br />\n";
+ $missing = true;
+ }
+ ini_restore('track_errors');
+
+ if(isset($missing))
+ return false;
+
+ return true;
+
+ } // checkRequirements()
+
+ private function _debug($text)
+ {
+ if($this->fromcmd) {
+ print $text;
+ }
+
+ } // _debug()
+
+ public function checkifImageSupported($mime)
+ {
+ if(in_array($mime, Array("image/jpeg")))
+ return true;
+
+ return false;
+
+ } // checkifImageSupported()
+
+ public function _warning($text)
+ {
+ print "<img src=\"resources/green_info.png\" alt=\"warning\" />\n";
+ print $text;
+
+ } // _warning()
+