X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=blobdiff_plain;f=phpfspot.class.php;h=826fafd2d1101b792306590de0cd032731443a7d;hp=82722529e89790adf21ad110a5736b76f93c6d90;hb=757e336f0ac6fc2c636706343d4c63aff2f228e6;hpb=33dba06cdcb7b66063bb941aa5f2a985de3fed94 diff --git a/phpfspot.class.php b/phpfspot.class.php index 8272252..826fafd 100644 --- a/phpfspot.class.php +++ b/phpfspot.class.php @@ -33,6 +33,9 @@ class PHPFSPOT { var $tags; var $avail_tags; + private $runtime_error = false; + private $dbver; + /** * class constructor * @@ -44,9 +47,23 @@ class PHPFSPOT { { $this->cfg = new PHPFSPOT_CFG; + /* verify config settings */ + if($this->check_config_options()) { + exit(1); + } + /* set application name and version information */ $this->cfg->product = "phpfspot"; - $this->cfg->version = "1.2"; + $this->cfg->version = "1.3"; + + $this->sort_orders= array( + 'date_asc' => 'Date ↑', + 'date_desc' => 'Date ↓', + 'name_asc' => 'Name ↑', + 'name_desc' => 'Name ↓', + 'tags_asc' => 'Tags ↑', + 'tags_desc' => 'Tags ↓', + ); /* Check necessary requirements */ if(!$this->checkRequirements()) { @@ -54,17 +71,29 @@ class PHPFSPOT { } $this->db = new PHPFSPOT_DB($this, $this->cfg->fspot_db); - + if(!is_writeable($this->cfg->fspot_db)) { + print $this->cfg->fspot_db ." is not writeable for user ". $this->getuid() ."\n"; + exit(1); + } + + $this->dbver = $this->getFspotDBVersion(); + if(!is_writeable(dirname($this->cfg->phpfspot_db))) { - print dirname($this->cfg->phpfspot_db) .": directory is not writeable!"; + print dirname($this->cfg->phpfspot_db) .": directory is not writeable for user ". $this->getuid() ."\n"; exit(1); } - + + if(!is_writeable($this->cfg->base_path ."/templates_c")) { + print $this->cfg->base_path ."/templates_c: directory is not writeable for user ". $this->getuid() ."\n"; + exit(1); + } + $this->cfg_db = new PHPFSPOT_DB($this, $this->cfg->phpfspot_db); if(!is_writeable($this->cfg->phpfspot_db)) { print $this->cfg->phpfspot_db ." is not writeable for user ". $this->getuid() ."\n"; exit(1); } + $this->check_config_table(); /* include Smarty template engine */ @@ -76,9 +105,12 @@ class PHPFSPOT { require_once "phpfspot_tmpl.php"; $this->tmpl = new PHPFSPOT_TMPL($this); - $this->get_tags(); + /* check if all necessary indices exist */ + $this->checkDbIndices(); - session_start(); + /* if session is not yet started, do it now */ + if(session_id() == "") + session_start(); if(!isset($_SESSION['tag_condition'])) $_SESSION['tag_condition'] = 'or'; @@ -89,8 +121,8 @@ class PHPFSPOT { if(!isset($_SESSION['searchfor'])) $_SESSION['searchfor'] = ''; - // if begin_with is still set but rows_per_page is now 0, unset it - if(isset($_SESSION['begin_with']) && $this->cfg->rows_per_page == 0) + // if begin_with is still set but thumbs_per_page is now 0, unset it + if(isset($_SESSION['begin_with']) && $this->cfg->thumbs_per_page == 0) unset($_SESSION['begin_with']); } // __construct() @@ -116,65 +148,68 @@ class PHPFSPOT { $this->tmpl->assign('current_condition', $_SESSION['tag_condition']); $this->tmpl->assign('template_path', 'themes/'. $this->cfg->theme_name); - $_SESSION['start_action'] = $_GET['mode']; + if(isset($_GET['mode'])) { - switch($_GET['mode']) { - case 'showpi': - if(isset($_GET['tags'])) { - $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); - } - if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { - $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00"); - } - if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { - $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59"); - } - break; - case 'showp': - if(isset($_GET['tags'])) { - $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); - $_SESSION['start_action'] = 'showp'; - } - if(isset($_GET['id']) && is_numeric($_GET['id'])) { - $_SESSION['current_photo'] = $_GET['id']; - $_SESSION['start_action'] = 'showp'; - } - if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { - $_SESSION['from_date'] = strtotime($_GET['from_date']); - } - if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { - $_SESSION['to_date'] = strtotime($_GET['to_date']); - } - break; - case 'export': - $this->tmpl->show("export.tpl"); - return; - break; - case 'slideshow': - $this->tmpl->show("slideshow.tpl"); - return; - break; - case 'rss': - if(isset($_GET['tags'])) { - $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); - } - if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { - $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00"); - } - if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { - $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59"); - } - $this->getRSSFeed(); - return; - break; + $_SESSION['start_action'] = $_GET['mode']; + + switch($_GET['mode']) { + case 'showpi': + if(isset($_GET['tags'])) { + $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); + } + if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { + $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00"); + } + if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { + $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59"); + } + break; + case 'showp': + if(isset($_GET['tags'])) { + $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); + $_SESSION['start_action'] = 'showp'; + } + if(isset($_GET['id']) && is_numeric($_GET['id'])) { + $_SESSION['current_photo'] = $_GET['id']; + $_SESSION['start_action'] = 'showp'; + } + if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { + $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00"); + } + if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { + $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59"); + } + break; + case 'export': + $this->tmpl->show("export.tpl"); + return; + break; + case 'slideshow': + $this->tmpl->show("slideshow.tpl"); + return; + break; + case 'rss': + if(isset($_GET['tags'])) { + $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']); + } + if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) { + $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00"); + } + if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) { + $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59"); + } + $this->getRSSFeed(); + return; + break; + } } if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) $this->tmpl->assign('date_search_enabled', true); + $this->tmpl->register_function("sort_select_list", array(&$this, "smarty_sort_select_list"), false); $this->tmpl->assign('from_date', $this->get_calendar('from')); $this->tmpl->assign('to_date', $this->get_calendar('to')); - $this->tmpl->assign('sort_field', $this->get_sort_field()); $this->tmpl->assign('content_page', 'welcome.tpl'); $this->tmpl->show("index.tpl"); @@ -199,7 +234,7 @@ class PHPFSPOT { if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) { $query_str=" SELECT - DISTINCT t1.id,t1.name + DISTINCT t1.id as id, t1.name as name FROM photo_tags pt1 INNER JOIN photo_tags @@ -209,11 +244,10 @@ class PHPFSPOT { INNER JOIN tags t2 ON t2.id=pt2.tag_id WHERE - t2.name IN (' - ".implode("','",$this->cfg->show_tags)." - ') + t2.name IN ('".implode("','",$this->cfg->show_tags)."') ORDER BY t1.sort_priority ASC"; + $result = $this->db->db_query($query_str); } else @@ -262,10 +296,18 @@ class PHPFSPOT { */ public function get_photo_details($idx) { - $query_str = " - SELECT p.id, p.name, p.time, p.directory_path, p.description - FROM photos p - "; + if($this->dbver < 9) { + $query_str = " + SELECT p.id, p.name, p.time, p.directory_path, p.description + FROM photos p + "; + } + else { + $query_str = " + SELECT p.id, p.uri, p.time, p.description + FROM photos p + "; + } /* if show_tags is set, only return details for photos which are specified to be shown @@ -285,8 +327,19 @@ class PHPFSPOT { "; } - $result = $this->db->db_query($query_str); - return $this->db->db_fetch_object($result); + if($result = $this->db->db_query($query_str)) { + + $row = $this->db->db_fetch_object($result); + + if($this->dbver < 9) { + $row['uri'] = "file://". $row['directory_path'] ."/". $row['name']; + } + + return $row; + + } + + return null; } // get_photo_details @@ -300,10 +353,14 @@ class PHPFSPOT { public function getPhotoName($idx, $limit = 0) { if($details = $this->get_photo_details($idx)) { - $name = $this->shrink_text($details['name'], $limit); - return $name; + if($long_name = $this->parse_uri($details['uri'], 'filename')) { + $name = $this->shrink_text($long_name, $limit); + return $name; + } } + return null; + } // getPhotoName() /** @@ -379,15 +436,17 @@ class PHPFSPOT { return; } - $orig_path = $this->translate_path($details['directory_path']) ."/". $details['name']; + $orig_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath')); $thumb_path = $this->get_thumb_path($this->cfg->photo_width, $photo); if(!file_exists($orig_path)) { $this->_error("Photo ". $orig_path ." does not exist!
\n"); + return; } if(!is_readable($orig_path)) { $this->_error("Photo ". $orig_path ." is not readable for user ". $this->getuid() ."
\n"); + return; } /* If the thumbnail doesn't exist yet, try to create it */ @@ -422,30 +481,29 @@ class PHPFSPOT { $this->tmpl->assign('extern_link', $extern_link); - if(file_exists($thumb_path)) { + if(!file_exists($thumb_path)) { + $this->_error("Can't open file ". $thumb_path ."\n"); + return; + } - $info = getimagesize($thumb_path); + $info = getimagesize($thumb_path); - $this->tmpl->assign('description', $details['description']); - $this->tmpl->assign('image_name', $details['name']); + $this->tmpl->assign('description', $details['description']); + $this->tmpl->assign('image_name', $this->parse_uri($details['uri'], 'filename')); - $this->tmpl->assign('width', $info[0]); - $this->tmpl->assign('height', $info[1]); - $this->tmpl->assign('ExifMadeOn', $meta_date); - $this->tmpl->assign('ExifMadeWith', $meta_make); - $this->tmpl->assign('ExifOrigResolution', $meta_res); - $this->tmpl->assign('ExifFileSize', $meta_size); - - $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width); - $this->tmpl->assign('image_url_full', 'phpfspot_img.php?idx='. $photo); + $this->tmpl->assign('width', $info[0]); + $this->tmpl->assign('height', $info[1]); + $this->tmpl->assign('ExifMadeOn', $meta_date); + $this->tmpl->assign('ExifMadeWith', $meta_make); + $this->tmpl->assign('ExifOrigResolution', $meta_res); + $this->tmpl->assign('ExifFileSize', $meta_size); + + $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width); + $this->tmpl->assign('image_url_full', 'phpfspot_img.php?idx='. $photo); + $this->tmpl->assign('image_filename', $this->parse_uri($details['uri'], 'filename')); - $this->tmpl->assign('tags', $this->get_photo_tags($photo)); - $this->tmpl->assign('current', $current); - } - else { - $this->_error("Can't open file ". $thumb_path ."\n"); - return; - } + $this->tmpl->assign('tags', $this->get_photo_tags($photo)); + $this->tmpl->assign('current', $current); if($previous_img) { $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");"); @@ -473,6 +531,9 @@ class PHPFSPOT { */ public function getAvailableTags() { + /* retrive tags from database */ + $this->get_tags(); + $output = ""; $result = $this->db->db_query(" @@ -514,10 +575,10 @@ class PHPFSPOT { if(isset($_SESSION['selected_tags']) && in_array($key, $_SESSION['selected_tags'])) continue; - // calculate CSS font-size - // find the $value in excess of $min_qty - // multiply by the font-size increment ($size) - // and add the $min_size set above + // calculate CSS font-size + // find the $value in excess of $min_qty + // multiply by the font-size increment ($size) + // and add the $min_size set above $size = $min_size + (($value - $min_qty) * $step); // uncomment if you want sizes in whole %: $size = ceil($size); @@ -542,7 +603,11 @@ class PHPFSPOT { */ public function getSelectedTags() { + /* retrive tags from database */ + $this->get_tags(); + $output = ""; + foreach($this->avail_tags as $tag) { // return all selected tags @@ -551,8 +616,13 @@ class PHPFSPOT { } } - $output = substr($output, 0, strlen($output)-2); - print $output; + if($output != "") { + $output = substr($output, 0, strlen($output)-2); + return $output; + } + else { + return "no tags selected"; + } } // getSelectedTags() @@ -568,6 +638,9 @@ class PHPFSPOT { if(!isset($_SESSION['selected_tags'])) $_SESSION['selected_tags'] = Array(); + if(isset($_SESSION['searchfor'])) + unset($_SESSION['searchfor']); + if(!in_array($tag, $_SESSION['selected_tags'])) array_push($_SESSION['selected_tags'], $tag); @@ -581,6 +654,9 @@ class PHPFSPOT { */ public function delTag($tag) { + if(isset($_SESSION['searchfor'])) + unset($_SESSION['searchfor']); + if(isset($_SESSION['selected_tags'])) { $key = array_search($tag, $_SESSION['selected_tags']); unset($_SESSION['selected_tags'][$key]); @@ -672,19 +748,23 @@ class PHPFSPOT { /* return a search result */ if(isset($_SESSION['searchfor']) && $_SESSION['searchfor'] != '') { $query_str = " - SELECT DISTINCT photo_id - FROM photo_tags pt - INNER JOIN photos p - ON p.id=pt.photo_id + SELECT DISTINCT pt1.photo_id + FROM photo_tags pt1 + INNER JOIN photo_tags pt2 + ON pt1.photo_id=pt2.photo_id INNER JOIN tags t - ON pt.tag_id=t.id - WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%'"; + ON pt1.tag_id=t.id + INNER JOIN photos p + ON pt1.photo_id=p.id + INNER JOIN tags t2 + ON pt2.tag_id=t2.id + WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%' "; if(isset($additional_where_cond)) $query_str.= "AND ". $additional_where_cond ." "; if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) { - $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags)."')"; + $query_str.= "AND t2.name IN ('".implode("','",$this->cfg->show_tags)."')"; } if(isset($order_str)) @@ -704,15 +784,18 @@ class PHPFSPOT { $selected.= $tag .","; $selected = substr($selected, 0, strlen($selected)-1); + /* photo has to match at least on of the selected tags */ if($_SESSION['tag_condition'] == 'or') { $query_str = " - SELECT DISTINCT pt.photo_id - FROM photo_tags pt - INNER JOIN photos p - ON p.id=pt.photo_id + SELECT DISTINCT pt1.photo_id + FROM photo_tags pt1 + INNER JOIN photo_tags pt2 + ON pt1.photo_id=pt2.photo_id INNER JOIN tags t - ON pt.tag_id=t.id - WHERE pt.tag_id IN (". $selected .") + ON pt2.tag_id=t.id + INNER JOIN photos p + ON pt1.photo_id=p.id + WHERE pt1.tag_id IN (". $selected .") "; if(isset($additional_where_cond)) $query_str.= "AND ". $additional_where_cond ." "; @@ -724,6 +807,7 @@ class PHPFSPOT { if(isset($order_str)) $query_str.= $order_str; } + /* photo has to match all selected tags */ elseif($_SESSION['tag_condition'] == 'and') { if(count($_SESSION['selected_tags']) >= 32) { @@ -790,18 +874,22 @@ class PHPFSPOT { /* return all available photos */ $query_str = " - SELECT DISTINCT photo_id - FROM photo_tags pt - INNER JOIN photos p + SELECT DISTINCT p.id + FROM photos p + LEFT JOIN photo_tags pt ON p.id=pt.photo_id - INNER JOIN tags t + LEFT JOIN tags t ON pt.tag_id=t.id "; + if(isset($additional_where_cond)) $query_str.= "WHERE ". $additional_where_cond ." "; if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) { - $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')"; + if(isset($additional_where_cond)) + $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')"; + else + $query_str.= "WHERE t.name IN ('".implode("','",$this->cfg->show_tags). "')"; } if(isset($order_str)) @@ -809,7 +897,7 @@ class PHPFSPOT { $result = $this->db->db_query($query_str); while($row = $this->db->db_fetch_object($result)) { - array_push($matched_photos, $row['photo_id']); + array_push($matched_photos, $row['id']); } return $matched_photos; @@ -830,75 +918,54 @@ class PHPFSPOT { 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) { + if(!isset($this->cfg->thumbs_per_page) || $this->cfg->thumbs_per_page == 0) { $begin_with = 0; $end_with = $count; } - elseif($this->cfg->rows_per_page > 0) { + elseif($this->cfg->thumbs_per_page > 0) { - if(!$_SESSION['begin_with'] || $_SESSION['begin_with'] == 0) + if(!isset($_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); + $end_with = $begin_with + $this->cfg->thumbs_per_page; } - - $rows = 0; - $cols = 0; - $images[$rows] = Array(); - $img_height[$rows] = Array(); - $img_width[$rows] = Array(); - $img_id[$rows] = Array(); - $img_name[$rows] = Array(); + $thumbs = 0; + $images[$thumbs] = Array(); + $img_height[$thumbs] = Array(); + $img_width[$thumbs] = Array(); + $img_id[$thumbs] = Array(); + $img_name[$thumbs] = Array(); $img_title = Array(); for($i = $begin_with; $i < $end_with; $i++) { - $images[$rows][$cols] = $photos[$i]; - $img_id[$rows][$cols] = $i; - $img_name[$rows][$cols] = htmlspecialchars($this->getPhotoName($photos[$i], 15)); - $img_title[$rows][$cols] = "Click to view photo ". htmlspecialchars($this->getPhotoName($photos[$i], 0)); + if(isset($photos[$i])) { - $thumb_path = $this->get_thumb_path($this->cfg->thumb_width, $photos[$i]); + $images[$thumbs] = $photos[$i]; + $img_id[$thumbs] = $i; + $img_name[$thumbs] = htmlspecialchars($this->getPhotoName($photos[$i], 15)); + $img_title[$thumbs] = "Click to view photo ". htmlspecialchars($this->getPhotoName($photos[$i], 0)); - if(file_exists($thumb_path)) { - $info = getimagesize($thumb_path); - $img_width[$rows][$cols] = $info[0]; - $img_height[$rows][$cols] = $info[1]; - } + $thumb_path = $this->get_thumb_path($this->cfg->thumb_width, $photos[$i]); - if($cols == $this->cfg->thumbs_per_row-1) { - $cols = 0; - $rows++; - $images[$rows] = Array(); - $img_width[$rows] = Array(); - $img_height[$rows] = Array(); - } - else { - $cols++; - } - } + if(file_exists($thumb_path)) { + $info = getimagesize($thumb_path); + $img_width[$thumbs] = $info[0]; + $img_height[$thumbs] = $info[1]; + } + $thumbs++; + } + } // +1 for for smarty's selection iteration - $rows++; + $thumbs++; if(isset($_SESSION['searchfor']) && $_SESSION['searchfor'] != '') $this->tmpl->assign('searchfor', $_SESSION['searchfor']); @@ -913,18 +980,20 @@ class PHPFSPOT { } /* do we have to display the page selector ? */ - if($this->cfg->rows_per_page != 0) { + if($this->cfg->thumbs_per_page != 0) { + + $page_select = ""; /* 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); + $previous_start = $begin_with - $this->cfg->thumbs_per_page; + $next_start = $begin_with + $this->cfg->thumbs_per_page; 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 .");"); - $photo_per_page = $this->cfg->rows_per_page * $this->cfg->thumbs_per_row; + $photo_per_page = $this->cfg->thumbs_per_page; $last_page = ceil($count / $photo_per_page); /* get the current selected page */ @@ -1012,14 +1081,15 @@ class PHPFSPOT { $this->tmpl->assign('rss_link', $rss_link); $this->tmpl->assign('count', $count); $this->tmpl->assign('width', $this->cfg->thumb_width); + $this->tmpl->assign('thumb_container_width', $this->cfg->thumb_width); + $this->tmpl->assign('thumb_container_height', $this->cfg->thumb_height+20); $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('img_name', $img_name); $this->tmpl->assign('img_title', $img_title); - $this->tmpl->assign('rows', $rows); - $this->tmpl->assign('columns', $this->cfg->thumbs_per_row); + $this->tmpl->assign('thumbs', $thumbs); $this->tmpl->show("photo_index.tpl"); @@ -1035,6 +1105,7 @@ class PHPFSPOT { { $this->tmpl->assign('version', $this->cfg->version); $this->tmpl->assign('product', $this->cfg->product); + $this->tmpl->assign('db_version', $this->dbver); $this->tmpl->show("credits.tpl"); } // showCredits() @@ -1062,26 +1133,26 @@ class PHPFSPOT { $meta = $this->get_meta_informations($orig_image); $rotate = 0; - $flip = false; + $flip_hori = false; + $flip_vert = false; switch($meta['Orientation']) { - case 1: /* top, left */ - $rotate = 0; $flip = false; break; + /* nothing to do */ break; case 2: /* top, right */ - $rotate = 0; $flip = true; break; + $rotate = 0; $flip_hori = true; break; case 3: /* bottom, left */ - $rotate = 180; $flip = false; break; + $rotate = 180; break; case 4: /* bottom, right */ - $rotate = 180; $flip = true; break; + $flip_vert = true; break; case 5: /* left side, top */ - $rotate = 90; $flip = true; break; + $rotate = 90; $flip_vert = true; break; case 6: /* right side, top */ - $rotate = 90; $flip = false; break; + $rotate = 90; break; case 7: /* left side, bottom */ - $rotate = 270; $flip = true; break; + $rotate = 270; $flip_vert = true; break; case 8: /* right side, bottom */ - $rotate = 270; $flip = false; break; + $rotate = 270; break; } $src_img = @imagecreatefromjpeg($orig_image); @@ -1097,9 +1168,9 @@ class PHPFSPOT { // If requested width is more then the actual image width, // do not generate a thumbnail, instead safe the original - // as thumbnail but with lower quality - - if($width >= $cur_width) { + // as thumbnail but with lower quality. But if the image + // is to heigh too, then we still have to resize it. + if($width >= $cur_width && $cur_height < $this->cfg->thumb_height) { $result = imagejpeg($src_img, $thumb_image, 75); imagedestroy($src_img); return true; @@ -1153,12 +1224,14 @@ class PHPFSPOT { 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($flip_hori) { + $this->_debug("(FLIP)"); + $dst_img = $this->flipImage($dst_img, 'hori'); + } + /* needs the image to be flipped vertical? */ + if($flip_vert) { + $this->_debug("(FLIP)"); + $dst_img = $this->flipImage($dst_img, 'vert'); } if($rotate) { @@ -1223,7 +1296,7 @@ class PHPFSPOT { * 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) + public function gen_thumb($idx = 0, $force = 0, $overwrite = false) { $error = 0; @@ -1237,7 +1310,7 @@ class PHPFSPOT { $details = $this->get_photo_details($idx); /* calculate file MD5 sum */ - $full_path = $this->translate_path($details['directory_path']) ."/". $details['name']; + $full_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath')); if(!file_exists($full_path)) { $this->_error("File ". $full_path ." does not exist\n"); @@ -1251,9 +1324,13 @@ class PHPFSPOT { $file_md5 = md5_file($full_path); - $this->_debug("Image [". $idx ."] ". $this->shrink_text($details['name'], 20) ." Thumbnails:"); + $this->_debug("Image [". $idx ."] ". $this->shrink_text($this->parse_uri($details['uri'], 'filename'), 20) ." Thumbnails:"); + + $changes = false; foreach($resolutions as $resolution) { + + $generate_it = false; $thumb_sub_path = substr($file_md5, 0, 2); $thumb_path = $this->cfg->thumb_path ."/". $thumb_sub_path ."/". $resolution ."_". $file_md5; @@ -1264,21 +1341,27 @@ class PHPFSPOT { /* 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; + $generate_it = true; } /* if the file hasn't changed there is no need to regen the thumb */ elseif($file_md5 != $this->getMD5($idx) || $force) { + $generate_it = true; + } + + if($generate_it || $overwrite) { $this->_debug(" ". $resolution ."px"); if(!$this->create_thumbnail($full_path, $thumb_path, $resolution)) $error = 1; + $changes = true; } } + if(!$changes) { + $this->_debug(" already exist"); + } + /* set the new/changed MD5 sum for the current photo */ if(!$error) { $this->setMD5($idx, $file_md5); @@ -1343,16 +1426,19 @@ class PHPFSPOT { * getPhotoSelection() will then only return the matching * photos. */ - public function startSearch($searchfor, $sort_order, $from = 0, $to = 0) + public function startSearch($searchfor, $from = 0, $to = 0) { + $this->get_tags(); + $_SESSION['searchfor'] = $searchfor; - $_SESSION['sort_order'] = $sort_order; + if($from != 0) - $_SESSION['from_date'] = strtotime($from); + $_SESSION['from_date'] = strtotime($from ." 00:00:00"); else unset($_SESSION['from_date']); + if($to != 0) - $_SESSION['to_date'] = strtotime($to); + $_SESSION['to_date'] = strtotime($to ." 23:59:59"); else unset($_SESSION['to_date']); @@ -1367,6 +1453,23 @@ class PHPFSPOT { } // startSearch() + /** + * updates sort order in session variable + * + * this function is invoked by RPC and will sort the requested + * sort order in the session variable. + */ + public function updateSortOrder($order) + { + if(isset($this->sort_orders[$order])) { + $_SESSION['sort_order'] = $order; + return "ok"; + } + + return "unkown error"; + + } // updateSortOrder() + /** * rotate image * @@ -1444,6 +1547,35 @@ class PHPFSPOT { } // rotateImage() + /** + * returns flipped image + * + * this function will return an either horizontal or + * vertical flipped truecolor image. + */ + private function flipImage($image, $mode) + { + $w = imagesx($image); + $h = imagesy($image); + $flipped = imagecreatetruecolor($w, $h); + + switch($mode) { + case 'vert': + for ($y = 0; $y < $h; $y++) { + imagecopy($flipped, $image, 0, $y, 0, $h - $y - 1, $w, 1); + } + break; + case 'hori': + for ($x = 0; $x < $w; $x++) { + imagecopy($flipped, $image, $x, 0, $w - $x - 1, 0, 1, $h); + } + break; + } + + return $flipped; + + } // flipImage() + /** * return all assigned tags for the specified photo */ @@ -1522,6 +1654,11 @@ class PHPFSPOT { print "PEAR Calendar package is missing
\n"; $missing = true; } + @include_once 'Console/Getopt.php'; + if(isset($php_errormsg) && preg_match('/Failed opening.*for inclusion/i', $php_errormsg)) { + print "PEAR Console_Getopt package is missing
\n"; + $missing = true; + } ini_restore('track_errors'); if(isset($missing)) @@ -1554,9 +1691,10 @@ class PHPFSPOT { public function _error($text) { switch($this->cfg->logging) { + default: case 'display': print "\"warning\"\n"; - print $text; + print $text ."
\n"; break; case 'errorlog': error_log($text); @@ -1566,6 +1704,8 @@ class PHPFSPOT { break; } + $this->runtime_error = true; + } // _error() /** @@ -1573,19 +1713,23 @@ class PHPFSPOT { */ private function get_calendar($mode) { - $year = $_SESSION[$mode .'_date'] ? date("Y", $_SESSION[$mode .'_date']) : date("Y"); - $month = $_SESSION[$mode .'_date'] ? date("m", $_SESSION[$mode .'_date']) : date("m"); - $day = $_SESSION[$mode .'_date'] ? date("d", $_SESSION[$mode .'_date']) : date("d"); + $year = isset($_SESSION[$mode .'_date']) ? date("Y", $_SESSION[$mode .'_date']) : date("Y"); + $month = isset($_SESSION[$mode .'_date']) ? date("m", $_SESSION[$mode .'_date']) : date("m"); + $day = isset($_SESSION[$mode .'_date']) ? date("d", $_SESSION[$mode .'_date']) : date("d"); $output = " ". $details['description']); - $orig_path = $this->translate_path($details['directory_path']) ."/". $details['name']; + $orig_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath')); $meta = $this->get_meta_informations($orig_path); $meta_date = isset($meta['FileDateTime']) ? $meta['FileDateTime'] : filemtime($orig_path); ?> - <?php print htmlspecialchars($details['name']); ?> + <?php print htmlspecialchars($this->parse_uri($details['uri'], 'filename')); ?> @@ -1784,7 +1928,7 @@ class PHPFSPOT { private function getCurrentTags() { $current_tags = ""; - if($_SESSION['selected_tags'] != "") { + if(isset($_SESSION['selected_tags']) && $_SESSION['selected_tags'] != "") { foreach($_SESSION['selected_tags'] as $tag) $current_tags.= $tag .","; $current_tags = substr($current_tags, 0, strlen($current_tags)-1); @@ -1846,20 +1990,21 @@ class PHPFSPOT { /** * returns a select-dropdown box to select photo index sort parameters */ - private function get_sort_field() + public function smarty_sort_select_list($params, &$smarty) { - $output = ""; + return $output; - } // get_sort_field() + } // smarty_sort_select_list() /** * returns the currently selected sort order @@ -1874,10 +2019,26 @@ class PHPFSPOT { return " ORDER BY p.time DESC"; break; case 'name_asc': - return " ORDER BY p.name ASC"; + if($this->dbver < 9) { + return " ORDER BY p.name ASC"; + } + else { + return " ORDER BY basename(p.uri) ASC"; + } break; case 'name_desc': - return " ORDER BY p.name DESC"; + if($this->dbver < 9) { + return " ORDER BY p.name DESC"; + } + else { + return " ORDER BY basename(p.uri) DESC"; + } + break; + case 'tags_asc': + return " ORDER BY t.name ASC ,p.time ASC"; + break; + case 'tags_desc': + return " ORDER BY t.name DESC ,p.time ASC"; break; } @@ -2064,6 +2225,151 @@ class PHPFSPOT { } // check_readable() -} + /** + * check if all needed indices are present + * + * this function checks, if some needed indices are already + * present, or if not, create them on the fly. they are + * necessary to speed up some queries like that one look for + * all tags, when show_tags is specified in the configuration. + */ + private function checkDbIndices() + { + $result = $this->db->db_exec(" + CREATE INDEX IF NOT EXISTS + phototag + ON + photo_tags + (photo_id, tag_id) + "); + + } // checkDbIndices() + + /** + * retrive F-Spot database version + * + * this function will return the F-Spot database version number + * It is stored within the sqlite3 database in the table meta + */ + public function getFspotDBVersion() + { + if($result = $this->db->db_fetchSingleRow(" + SELECT data as version + FROM meta + WHERE + name LIKE 'F-Spot Database Version' + ")) + return $result['version']; + + return null; + + } // getFspotDBVersion() + + /** + * parse the provided URI and will returned the + * requested chunk + */ + public function parse_uri($uri, $mode) + { + if(($components = parse_url($uri)) !== false) { + + switch($mode) { + case 'filename': + return basename($components['path']); + break; + case 'dirname': + return dirname($components['path']); + break; + case 'fullpath': + return $components['path']; + break; + } + } + + return $uri; + + } // parse_uri() + + /** + * validate config options + * + * this function checks if all necessary configuration options are + * specified and set. + */ + private function check_config_options() + { + if(!isset($this->cfg->page_title) || $this->cfg->page_title == "") + $this->_error("Please set \$page_title in phpfspot_cfg"); + + if(!isset($this->cfg->base_path) || $this->cfg->base_path == "") + $this->_error("Please set \$base_path in phpfspot_cfg"); + + if(!isset($this->cfg->web_path) || $this->cfg->web_path == "") + $this->_error("Please set \$web_path in phpfspot_cfg"); + + if(!isset($this->cfg->thumb_path) || $this->cfg->thumb_path == "") + $this->_error("Please set \$thumb_path in phpfspot_cfg"); + + if(!isset($this->cfg->smarty_path) || $this->cfg->smarty_path == "") + $this->_error("Please set \$smarty_path in phpfspot_cfg"); + + if(!isset($this->cfg->fspot_db) || $this->cfg->fspot_db == "") + $this->_error("Please set \$fspot_db in phpfspot_cfg"); + + if(!isset($this->cfg->db_access) || $this->cfg->db_access == "") + $this->_error("Please set \$db_access in phpfspot_cfg"); + + if(!isset($this->cfg->phpfspot_db) || $this->cfg->phpfspot_db == "") + $this->_error("Please set \$phpfspot_db in phpfspot_cfg"); + + if(!isset($this->cfg->thumb_width) || $this->cfg->thumb_width == "") + $this->_error("Please set \$thumb_width in phpfspot_cfg"); + + if(!isset($this->cfg->thumb_height) || $this->cfg->thumb_height == "") + $this->_error("Please set \$thumb_height in phpfspot_cfg"); + + if(!isset($this->cfg->photo_width) || $this->cfg->photo_width == "") + $this->_error("Please set \$photo_width in phpfspot_cfg"); + + if(!isset($this->cfg->mini_width) || $this->cfg->mini_width == "") + $this->_error("Please set \$mini_width in phpfspot_cfg"); + + if(!isset($this->cfg->thumbs_per_page)) + $this->_error("Please set \$thumbs_per_page in phpfspot_cfg"); + + if(!isset($this->cfg->path_replace_from) || $this->cfg->path_replace_from == "") + $this->_error("Please set \$path_replace_from in phpfspot_cfg"); + + if(!isset($this->cfg->path_replace_to) || $this->cfg->path_replace_to == "") + $this->_error("Please set \$path_replace_to in phpfspot_cfg"); + + if(!isset($this->cfg->hide_tags)) + $this->_error("Please set \$hide_tags in phpfspot_cfg"); + + if(!isset($this->cfg->theme_name)) + $this->_error("Please set \$theme_name in phpfspot_cfg"); + + if(!isset($this->cfg->logging)) + $this->_error("Please set \$logging in phpfspot_cfg"); + + if(isset($this->cfg->logging) && $this->cfg->logging == 'logfile') { + + if(!isset($this->cfg->log_file)) + $this->_error("Please set \$log_file because you set logging = log_file in phpfspot_cfg"); + + if(!is_writeable($this->cfg->log_file)) + $this->_error("The specified \$log_file ". $log_file ." is not writeable!"); + + } + + /* check for pending slash on web_path */ + if(!preg_match("/\/$/", $this->web_path)) + $this->web_path.= "/"; + + return $this->runtime_error; + + } // check_config_options() + +} // class PHPFSPOT ?>