3 /***************************************************************************
5 * phpfspot, presents your F-Spot photo collection in Web browsers.
7 * Copyright (c) by Andreas Unterkircher
9 * This program is free software; you can redistribute it and/or modify
10 * it under the terms of the GNU General Public License as published by
11 * the Free Software Foundation; either version 2 of the License, or
14 * This program is distributed in the hope that it will be useful,
15 * but WITHOUT ANY WARRANTY; without even the implied warranty of
16 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 * GNU General Public License for more details.
19 * You should have received a copy of the GNU General Public License
20 * along with this program; if not, write to the Free Software
21 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
23 ***************************************************************************/
25 require_once "phpfspot_cfg.php";
26 require_once "phpfspot_db.php";
31 * this class contains the most functions which will to the major
39 * phpfspot configuration
47 * SQLite database handle to f-spot database
55 * SQLite database handle to phpfspot database
63 * Smarty template engine
64 * @link http://smarty.php.net smarty.php.net
65 * @see PHPFSPOT_TMPL()
79 * list of available, not-selected, tags
86 * true if runtime error occued
90 private $runtime_error = false;
93 * F-Spot database version
100 * class constructor ($cfg, $db, $cfg_db, $tmpl, $db_ver)
102 * this function will be called on class construct
103 * and will check requirements, loads configuration,
104 * open databases and start the user session
106 public function __construct()
109 * register PHPFSPOT class global
111 * @global PHPFSPOT $GLOBALS['phpfspot']
114 $GLOBALS['phpfspot'] =& $this;
116 $this->cfg = new PHPFSPOT_CFG;
118 /* verify config settings */
119 if($this->check_config_options()) {
123 /* set application name and version information */
124 $this->cfg->product = "phpfspot";
125 $this->cfg->version = "1.5";
127 $this->sort_orders= array(
128 'date_asc' => 'Date ↑',
129 'date_desc' => 'Date ↓',
130 'name_asc' => 'Name ↑',
131 'name_desc' => 'Name ↓',
132 'tags_asc' => 'Tags ↑',
133 'tags_desc' => 'Tags ↓',
136 /* Check necessary requirements */
137 if(!$this->check_requirements()) {
141 /******* Opening F-Spot's sqlite database *********/
143 /* Check if database file is writeable */
144 if(!is_writeable($this->cfg->fspot_db)) {
145 print $this->cfg->fspot_db ." is not writeable for user ". $this->getuid() ."\n";
149 /* open the database */
150 $this->db = new PHPFSPOT_DB($this, $this->cfg->fspot_db);
152 /* change sqlite temp directory, if requested */
153 if(isset($this->cfg->sqlite_temp_dir)) {
156 temp_store_directory = '". $this->cfg->sqlite_temp_dir ."'
160 $this->dbver = $this->getFspotDBVersion();
162 if(!is_writeable($this->cfg->base_path ."/templates_c")) {
163 print $this->cfg->base_path ."/templates_c: directory is not writeable for user ". $this->getuid() ."\n";
167 if(!is_writeable($this->cfg->thumb_path)) {
168 print $this->cfg->thumb_path .": directory is not writeable for user ". $this->getuid() ."\n";
172 /******* Opening phpfspot's sqlite database *********/
174 /* Check if directory where the database file is stored is writeable */
175 if(!is_writeable(dirname($this->cfg->phpfspot_db))) {
176 print dirname($this->cfg->phpfspot_db) .": directory is not writeable for user ". $this->getuid() ."\n";
180 /* Check if database file is writeable */
181 if(!is_writeable($this->cfg->phpfspot_db)) {
182 print $this->cfg->phpfspot_db ." is not writeable for user ". $this->getuid() ."\n";
186 /* open the database */
187 $this->cfg_db = new PHPFSPOT_DB($this, $this->cfg->phpfspot_db);
189 /* change sqlite temp directory, if requested */
190 if(isset($this->cfg->sqlite_temp_dir)) {
191 $this->cfg_db->db_exec("
193 temp_store_directory = '". $this->cfg->sqlite_temp_dir ."'
197 /* Check if some tables need to be created */
198 $this->check_config_table();
200 /* overload Smarty class with our own template handler */
201 require_once "phpfspot_tmpl.php";
202 $this->tmpl = new PHPFSPOT_TMPL();
204 $this->tmpl->assign('web_path', $this->cfg->web_path);
206 /* check if all necessary indices exist */
207 $this->checkDbIndices();
209 /* if session is not yet started, do it now */
210 if(session_id() == "")
213 if(!isset($_SESSION['tag_condition']))
214 $_SESSION['tag_condition'] = 'or';
216 if(!isset($_SESSION['sort_order']))
217 $_SESSION['sort_order'] = 'date_desc';
219 if(!isset($_SESSION['searchfor_tag']))
220 $_SESSION['searchfor_tag'] = '';
222 // if begin_with is still set but thumbs_per_page is now 0, unset it
223 if(isset($_SESSION['begin_with']) && $this->cfg->thumbs_per_page == 0)
224 unset($_SESSION['begin_with']);
228 public function __destruct()
234 * show - generate html output
236 * this function can be called after the constructor has
237 * prepared everyhing. it will load the index.tpl smarty
238 * template. if necessary it will registere pre-selects
239 * (photo index, photo, tag search, date search) into
242 public function show()
244 $this->tmpl->assign('searchfor_tag', $_SESSION['searchfor_tag']);
245 $this->tmpl->assign('page_title', $this->cfg->page_title);
246 $this->tmpl->assign('current_condition', $_SESSION['tag_condition']);
247 $this->tmpl->assign('template_path', 'themes/'. $this->cfg->theme_name);
250 if($this->is_user_friendly_url()) {
251 $content = $this->parse_user_friendly_url($_SERVER['REQUEST_URI']);
254 if(isset($_GET['mode'])) {
256 $_SESSION['start_action'] = $_GET['mode'];
258 switch($_GET['mode']) {
260 if(isset($_GET['tags'])) {
261 $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']);
263 if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) {
264 $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00");
266 if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) {
267 $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59");
271 if(isset($_GET['tags'])) {
272 $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']);
273 $_SESSION['start_action'] = 'showp';
275 if(isset($_GET['id']) && is_numeric($_GET['id'])) {
276 $_SESSION['current_photo'] = $_GET['id'];
277 $_SESSION['start_action'] = 'showp';
279 if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) {
280 $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00");
282 if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) {
283 $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59");
287 $this->tmpl->show("export.tpl");
291 $this->tmpl->show("slideshow.tpl");
295 if(isset($_GET['tags'])) {
296 $_SESSION['selected_tags'] = $this->extractTags($_GET['tags']);
298 if(isset($_GET['from_date']) && $this->isValidDate($_GET['from_date'])) {
299 $_SESSION['from_date'] = strtotime($_GET['from_date'] ." 00:00:00");
301 if(isset($_GET['to_date']) && $this->isValidDate($_GET['to_date'])) {
302 $_SESSION['to_date'] = strtotime($_GET['to_date'] ." 23:59:59");
310 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date']))
311 $this->tmpl->assign('date_search_enabled', true);
313 $this->tmpl->register_function("sort_select_list", array(&$this, "smarty_sort_select_list"), false);
314 $this->tmpl->assign('from_date', $this->get_calendar('from'));
315 $this->tmpl->assign('to_date', $this->get_calendar('to'));
317 $this->tmpl->assign('preset_selected_tags', $this->getSelectedTags());
318 $this->tmpl->assign('preset_available_tags', $this->getAvailableTags());
320 if(!isset($content)) {
321 if(isset($_SESSION['selected_tags']) && !empty($_SESSION['selected_tags']))
322 $this->tmpl->assign('initial_content', $this->showPhotoIndex());
324 $this->tmpl->assign('initial_content', $this->tmpl->fetch('welcome.tpl'));
327 $this->tmpl->assign('initial_content', $content);
329 $this->tmpl->show("index.tpl");
334 * get_tags - grab all tags of f-spot's database
336 * this function will get all available tags from
337 * the f-spot database and store them within two
338 * arrays within this class for later usage. in
339 * fact, if the user requests (hide_tags) it will
340 * opt-out some of them.
342 * this function is getting called once by show()
344 private function get_tags()
346 $this->avail_tags = Array();
349 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
352 DISTINCT t1.id as id, t1.name as name
355 INNER JOIN photo_tags
356 pt2 ON pt1.photo_id=pt2.photo_id
362 t2.name IN ('".implode("','",$this->cfg->show_tags)."')
364 t1.sort_priority ASC";
366 $result = $this->db->db_query($query_str);
370 $result = $this->db->db_query("
373 ORDER BY sort_priority ASC
377 while($row = $this->db->db_fetch_object($result)) {
379 $tag_id = $row['id'];
380 $tag_name = $row['name'];
382 /* if the user has specified to ignore this tag in phpfspot's
383 configuration, ignore it here so it does not get added to
386 if(in_array($row['name'], $this->cfg->hide_tags))
389 /* if you include the following if-clause and the user has specified
390 to only show certain tags which are specified in phpfspot's
391 configuration, ignore all others so they will not be added to the
393 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags) &&
394 !in_array($row['name'], $this->cfg->show_tags))
398 $this->tags[$tag_id] = $tag_name;
399 $this->avail_tags[$count] = $tag_id;
407 * extract all photo details
409 * retrieve all available details from f-spot's
410 * database and return them as object
411 * @param integer $idx
412 * @return object|null
414 public function get_photo_details($idx)
416 if($this->dbver < 9) {
418 SELECT p.id, p.name, p.time, p.directory_path, p.description
424 SELECT p.id, p.uri, p.time, p.description
429 /* if show_tags is set, only return details for photos which
430 are specified to be shown
432 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
434 INNER JOIN photo_tags pt
438 WHERE p.id='". $idx ."'
439 AND t.name IN ('".implode("','",$this->cfg->show_tags)."')";
443 WHERE p.id='". $idx ."'
447 if($result = $this->db->db_query($query_str)) {
449 $row = $this->db->db_fetch_object($result);
451 if($this->dbver < 9) {
452 $row['uri'] = "file://". $row['directory_path'] ."/". $row['name'];
461 } // get_photo_details
464 * returns aligned photo names
466 * this function returns aligned (length) names for
467 * an specific photo. If the length of the name exceeds
468 * $limit the name will be shrinked (...)
469 * @param integer $idx
470 * @param integer $limit
471 * @return string|null
473 public function getPhotoName($idx, $limit = 0)
475 if($details = $this->get_photo_details($idx)) {
476 if($long_name = $this->parse_uri($details['uri'], 'filename')) {
477 $name = $this->shrink_text($long_name, $limit);
487 * shrink text according provided limit
489 * If the length of the name exceeds $limit the
490 * text will be shortend and some content in between
491 * will be replaced with "..."
493 * @param integer $limit
496 private function shrink_text($text, $limit)
498 if($limit != 0 && strlen($text) > $limit) {
499 $text = substr($text, 0, $limit-5) ."...". substr($text, -($limit-5));
507 * translate f-spoth photo path
509 * as the full-qualified path recorded in the f-spot database
510 * is usally not the same as on the webserver, this function
511 * will replace the path with that one specified in the cfg
512 * @param string $path
515 public function translate_path($path)
517 return str_replace($this->cfg->path_replace_from, $this->cfg->path_replace_to, $path);
522 * control HTML ouput for a single photo
524 * this function provides all the necessary information
525 * for the single photo template.
526 * @param integer photo
528 public function showPhoto($photo)
530 /* get all photos from the current photo selection */
531 $all_photos = $this->getPhotoSelection();
532 $count = count($all_photos);
534 for($i = 0; $i < $count; $i++) {
536 // $get_next will be set, when the photo which has to
537 // be displayed has been found - this means that the
538 // next available is in fact the NEXT image (for the
540 if(isset($get_next)) {
541 $next_img = $all_photos[$i];
545 /* the next photo is our NEXT photo */
546 if($all_photos[$i] == $photo) {
550 $previous_img = $all_photos[$i];
553 if($photo == $all_photos[$i]) {
558 $details = $this->get_photo_details($photo);
565 $orig_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath'));
566 $thumb_path = $this->get_thumb_path($this->cfg->photo_width, $photo);
568 if(!file_exists($orig_path)) {
569 $this->_error("Photo ". $orig_path ." does not exist!<br />\n");
573 if(!is_readable($orig_path)) {
574 $this->_error("Photo ". $orig_path ." is not readable for user ". $this->getuid() ."<br />\n");
578 /* If the thumbnail doesn't exist yet, try to create it */
579 if(!file_exists($thumb_path)) {
580 $this->gen_thumb($photo, true);
581 $thumb_path = $this->get_thumb_path($this->cfg->photo_width, $photo);
584 /* get mime-type, height and width from the original photo */
585 $info = getimagesize($orig_path);
587 /* get EXIF information if JPEG */
588 if($info['mime'] == "image/jpeg") {
589 $meta = $this->get_meta_informations($orig_path);
592 /* If EXIF data are available, use them */
593 if(isset($meta['ExifImageWidth'])) {
594 $meta_res = $meta['ExifImageWidth'] ."x". $meta['ExifImageLength'];
596 $meta_res = $info[0] ."x". $info[1];
599 $meta_date = isset($meta['FileDateTime']) ? strftime("%a %x %X", $meta['FileDateTime']) : "n/a";
600 $meta_make = isset($meta['Make']) ? $meta['Make'] ." / ". $meta['Model'] : "n/a";
601 $meta_size = isset($meta['FileSize']) ? round($meta['FileSize']/1024, 1) ."kbyte" : "n/a";
603 $extern_link = "index.php?mode=showp&id=". $photo;
604 $current_tags = $this->getCurrentTags();
605 if($current_tags != "") {
606 $extern_link.= "&tags=". $current_tags;
608 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
609 $extern_link.= "&from_date=". $this->ts2str($_SESSION['from_date']) ."&to_date=". $this->ts2str($_SESSION['to_date']);
612 $this->tmpl->assign('extern_link', $extern_link);
614 if(!file_exists($thumb_path)) {
615 $this->_error("Can't open file ". $thumb_path ."\n");
619 $info_thumb = getimagesize($thumb_path);
621 $this->tmpl->assign('description', $details['description']);
622 $this->tmpl->assign('image_name', $this->parse_uri($details['uri'], 'filename'));
624 $this->tmpl->assign('width', $info_thumb[0]);
625 $this->tmpl->assign('height', $info_thumb[1]);
626 $this->tmpl->assign('ExifMadeOn', $meta_date);
627 $this->tmpl->assign('ExifMadeWith', $meta_make);
628 $this->tmpl->assign('ExifOrigResolution', $meta_res);
629 $this->tmpl->assign('ExifFileSize', $meta_size);
631 if($this->is_user_friendly_url()) {
632 $this->tmpl->assign('image_url', '/photo/'. $photo ."/". $this->cfg->photo_width);
633 $this->tmpl->assign('image_url_full', '/photo/'. $photo);
636 $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width);
637 $this->tmpl->assign('image_url_full', 'phpfspot_img.php?idx='. $photo);
640 $this->tmpl->assign('image_filename', $this->parse_uri($details['uri'], 'filename'));
642 $this->tmpl->assign('tags', $this->get_photo_tags($photo));
643 $this->tmpl->assign('current_page', $this->getCurrentPage($current, $count));
644 $this->tmpl->assign('current_img', $photo);
647 $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");");
648 $this->tmpl->assign('prev_img', $previous_img);
652 $this->tmpl->assign('next_url', "javascript:showImage(". $next_img .");");
653 $this->tmpl->assign('next_img', $next_img);
655 $this->tmpl->assign('mini_width', $this->cfg->mini_width);
656 $this->tmpl->assign('photo_width', $this->cfg->photo_width);
657 $this->tmpl->assign('photo_number', $i);
658 $this->tmpl->assign('photo_count', count($all_photos));
660 return $this->tmpl->fetch("single_photo.tpl");
665 * all available tags and tag cloud
667 * this function outputs all available tags (time ordered)
668 * and in addition output them as tag cloud (tags which have
669 * many photos will appears more then others)
671 public function getAvailableTags()
673 /* retrive tags from database */
678 $result = $this->db->db_query("
679 SELECT tag_id as id, count(tag_id) as quantity
689 while($row = $this->db->db_fetch_object($result)) {
690 $tags[$row['id']] = $row['quantity'];
693 // change these font sizes if you will
694 $max_size = 125; // max font size in %
695 $min_size = 75; // min font size in %
698 $max_sat = hexdec('cc');
699 $min_sat = hexdec('44');
701 // get the largest and smallest array values
702 $max_qty = max(array_values($tags));
703 $min_qty = min(array_values($tags));
705 // find the range of values
706 $spread = $max_qty - $min_qty;
707 if (0 == $spread) { // we don't want to divide by zero
711 // determine the font-size increment
712 // this is the increase per tag quantity (times used)
713 $step = ($max_size - $min_size)/($spread);
714 $step_sat = ($max_sat - $min_sat)/($spread);
716 // loop through our tag array
717 foreach ($tags as $key => $value) {
719 if(isset($_SESSION['selected_tags']) && in_array($key, $_SESSION['selected_tags']))
722 // calculate CSS font-size
723 // find the $value in excess of $min_qty
724 // multiply by the font-size increment ($size)
725 // and add the $min_size set above
726 $size = $min_size + (($value - $min_qty) * $step);
727 // uncomment if you want sizes in whole %:
730 $color = $min_sat + ($value - $min_qty) * $step_sat;
736 if(isset($this->tags[$key])) {
737 if($this->is_user_friendly_url())
738 $output.= "<a href=\"". $this->cfg->web_path ."/tag/". $key ."\" onclick=\"Tags('add', ". $key ."); return false;\" class=\"tag\" style=\"font-size: ". $size ."%; color: #". $r.$g.$b .";\">". $this->tags[$key] ."</a>, ";
740 $output.= "<a href=\"". $this->cfg->web_path ."/index.php?mode=showpi\" onclick=\"Tags('add', ". $key ."); return false;\" class=\"tag\" style=\"font-size: ". $size ."%; color: #". $r.$g.$b .";\">". $this->tags[$key] ."</a>, ";
744 $output = substr($output, 0, strlen($output)-2);
747 } // getAvailableTags()
750 * output all selected tags
752 * this function output all tags which have been selected
753 * by the user. the selected tags are stored in the
754 * session-variable $_SESSION['selected_tags']
757 public function getSelectedTags($type = 'link')
759 /* retrive tags from database */
764 foreach($this->avail_tags as $tag)
766 // return all selected tags
767 if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags'])) {
772 $output.= "<a href=\"javascript:Tags('del', ". $tag .");\" class=\"tag\">". $this->tags[$tag] ."</a>, ";
776 <div style=\"display: table-cell;\">
777 <div style=\"display: table-row; text-align: center;\">
778 <a href=\"javascript:Tags('del', ". $tag .");\" title=\"". $this->tags[$tag] ."\">
779 <img src=\"phpfspot_img.php?tagidx=". $tag ."\" />
782 <div style=\"display: table-row; text-align: center;\">
783 <a href=\"javascript:Tags('del', ". $tag .");\" title=\"". $this->tags[$tag] ."\">
784 <img src=\"resources/underbar.png\" />
795 $output = substr($output, 0, strlen($output)-2);
799 return "no tags selected";
802 } // getSelectedTags()
805 * add tag to users session variable
807 * this function will add the specified to users current
808 * tag selection. if a date search has been made before
809 * it will be now cleared
812 public function addTag($tag)
814 if(!isset($_SESSION['selected_tags']))
815 $_SESSION['selected_tags'] = Array();
817 if(isset($_SESSION['searchfor_tag']))
818 unset($_SESSION['searchfor_tag']);
820 // has the user requested to hide this tag, and still someone,
821 // somehow tries to add it, don't allow this.
822 if(!isset($this->cfg->hide_tags) &&
823 in_array($this->get_tag_name($tag), $this->cfg->hide_tags))
826 if(!in_array($tag, $_SESSION['selected_tags']))
827 array_push($_SESSION['selected_tags'], $tag);
834 * remove tag to users session variable
836 * this function removes the specified tag from
837 * users current tag selection
841 public function delTag($tag)
843 if(isset($_SESSION['searchfor_tag']))
844 unset($_SESSION['searchfor_tag']);
846 if(isset($_SESSION['selected_tags'])) {
847 $key = array_search($tag, $_SESSION['selected_tags']);
848 unset($_SESSION['selected_tags'][$key]);
849 sort($_SESSION['selected_tags']);
857 * reset tag selection
859 * if there is any tag selection, it will be
862 public function resetTags()
864 if(isset($_SESSION['selected_tags']))
865 unset($_SESSION['selected_tags']);
870 * returns the value for the autocomplet tag-search
873 public function get_xml_tag_list()
875 if(!isset($_GET['search']) || !is_string($_GET['search']))
876 $_GET['search'] = '';
881 /* retrive tags from database */
884 $matched_tags = Array();
886 header("Content-Type: text/xml");
888 $string = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n";
889 $string.= "<results>\n";
891 foreach($this->avail_tags as $tag)
893 if(!empty($_GET['search']) &&
894 preg_match("/". $_GET['search'] ."/i", $this->tags[$tag]) &&
895 count($matched_tags) < $length) {
897 $count = $this->get_num_photos($tag);
900 $string.= " <rs id=\"". $i ."\" info=\"". $count ." photo\">". $this->tags[$tag] ."</rs>\n";
903 $string.= " <rs id=\"". $i ."\" info=\"". $count ." photos\">". $this->tags[$tag] ."</rs>\n";
909 /* if we have collected enough items, break out */
910 if(count($matched_tags) >= $length)
914 $string.= "</results>\n";
918 } // get_xml_tag_list()
924 * if a specific photo was requested (external link)
925 * unset the session variable now
927 public function resetPhotoView()
929 if(isset($_SESSION['current_photo']))
930 unset($_SESSION['current_photo']);
932 } // resetPhotoView();
937 * if any tag search has taken place, reset it now
939 public function resetTagSearch()
941 if(isset($_SESSION['searchfor_tag']))
942 unset($_SESSION['searchfor_tag']);
944 } // resetTagSearch()
949 * if any name search has taken place, reset it now
951 public function resetNameSearch()
953 if(isset($_SESSION['searchfor_name']))
954 unset($_SESSION['searchfor_name']);
956 } // resetNameSearch()
961 * if any date search has taken place, reset
964 public function resetDateSearch()
966 if(isset($_SESSION['from_date']))
967 unset($_SESSION['from_date']);
968 if(isset($_SESSION['to_date']))
969 unset($_SESSION['to_date']);
971 } // resetDateSearch();
974 * return all photo according selection
976 * this function returns all photos based on
977 * the tag-selection, tag- or date-search.
978 * the tag-search also has to take care of AND
979 * and OR conjunctions
982 public function getPhotoSelection()
984 $matched_photos = Array();
985 $additional_where_cond = "";
987 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
988 $from_date = $_SESSION['from_date'];
989 $to_date = $_SESSION['to_date'];
990 $additional_where_cond.= "
991 p.time>='". $from_date ."'
993 p.time<='". $to_date ."'
997 if(isset($_SESSION['searchfor_name'])) {
998 if($this->dbver < 9) {
999 $additional_where_cond.= "
1001 p.name LIKE '%". $_SESSION['searchfor_name'] ."%'
1003 p.description LIKE '%". $_SESSION['searchfor_name'] ."%'
1008 $additional_where_cond.= "
1010 basename(p.uri) LIKE '%". $_SESSION['searchfor_name'] ."%'
1012 p.description LIKE '%". $_SESSION['searchfor_name'] ."%'
1018 if(isset($_SESSION['sort_order'])) {
1019 $order_str = $this->get_sort_order();
1022 /* return a search result */
1023 if(isset($_SESSION['searchfor_tag']) && $_SESSION['searchfor_tag'] != '') {
1025 SELECT DISTINCT pt1.photo_id
1027 INNER JOIN photo_tags pt2
1028 ON pt1.photo_id=pt2.photo_id
1032 ON pt1.photo_id=p.id
1035 WHERE t.name LIKE '%". $_SESSION['searchfor_tag'] ."%' ";
1037 if(isset($additional_where_cond) && !empty($additional_where_cond))
1038 $query_str.= "AND ". $additional_where_cond ." ";
1040 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
1041 $query_str.= "AND t2.name IN ('".implode("','",$this->cfg->show_tags)."')";
1044 if(isset($order_str))
1045 $query_str.= $order_str;
1047 $result = $this->db->db_query($query_str);
1048 while($row = $this->db->db_fetch_object($result)) {
1049 array_push($matched_photos, $row['photo_id']);
1051 return $matched_photos;
1054 /* return according the selected tags */
1055 if(isset($_SESSION['selected_tags']) && !empty($_SESSION['selected_tags'])) {
1057 foreach($_SESSION['selected_tags'] as $tag)
1058 $selected.= $tag .",";
1059 $selected = substr($selected, 0, strlen($selected)-1);
1061 /* photo has to match at least on of the selected tags */
1062 if($_SESSION['tag_condition'] == 'or') {
1064 SELECT DISTINCT pt1.photo_id
1066 INNER JOIN photo_tags pt2
1067 ON pt1.photo_id=pt2.photo_id
1071 ON pt1.photo_id=p.id
1072 WHERE pt1.tag_id IN (". $selected .")
1074 if(isset($additional_where_cond) && !empty($additional_where_cond))
1075 $query_str.= "AND ". $additional_where_cond ." ";
1077 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
1078 $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags)."')";
1081 if(isset($order_str))
1082 $query_str.= $order_str;
1084 /* photo has to match all selected tags */
1085 elseif($_SESSION['tag_condition'] == 'and') {
1087 if(count($_SESSION['selected_tags']) >= 32) {
1088 print "A SQLite limit of 32 tables within a JOIN SELECT avoids to<br />\n";
1089 print "evaluate your tag selection. Please remove some tags from your selection.\n";
1093 /* Join together a table looking like
1095 pt1.photo_id pt1.tag_id pt2.photo_id pt2.tag_id ...
1097 so the query can quickly return all images matching the
1098 selected tags in an AND condition
1103 SELECT DISTINCT pt1.photo_id
1107 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
1114 for($i = 0; $i < count($_SESSION['selected_tags']); $i++) {
1116 INNER JOIN photo_tags pt". ($i+2) ."
1117 ON pt1.photo_id=pt". ($i+2) .".photo_id
1122 ON pt1.photo_id=p.id
1124 $query_str.= "WHERE pt2.tag_id=". $_SESSION['selected_tags'][0]." ";
1125 for($i = 1; $i < count($_SESSION['selected_tags']); $i++) {
1127 AND pt". ($i+2) .".tag_id=". $_SESSION['selected_tags'][$i] ."
1130 if(isset($additional_where_cond) && !empty($additional_where_cond))
1131 $query_str.= "AND ". $additional_where_cond;
1133 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
1134 $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')";
1137 if(isset($order_str))
1138 $query_str.= $order_str;
1142 $result = $this->db->db_query($query_str);
1143 while($row = $this->db->db_fetch_object($result)) {
1144 array_push($matched_photos, $row['photo_id']);
1146 return $matched_photos;
1149 /* return all available photos */
1151 SELECT DISTINCT p.id
1153 LEFT JOIN photo_tags pt
1159 if(isset($additional_where_cond) && !empty($additional_where_cond))
1160 $query_str.= "WHERE ". $additional_where_cond ." ";
1162 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
1163 if(isset($additional_where_cond) && !empty($additional_where_cond))
1164 $query_str.= "AND t.name IN ('".implode("','",$this->cfg->show_tags). "')";
1166 $query_str.= "WHERE t.name IN ('".implode("','",$this->cfg->show_tags). "')";
1169 if(isset($order_str))
1170 $query_str.= $order_str;
1172 $result = $this->db->db_query($query_str);
1173 while($row = $this->db->db_fetch_object($result)) {
1174 array_push($matched_photos, $row['id']);
1176 return $matched_photos;
1178 } // getPhotoSelection()
1181 * control HTML ouput for photo index
1183 * this function provides all the necessary information
1184 * for the photo index template.
1187 public function showPhotoIndex()
1189 $photos = $this->getPhotoSelection();
1191 $count = count($photos);
1193 /* if all thumbnails should be shown on one page */
1194 if(!isset($this->cfg->thumbs_per_page) || $this->cfg->thumbs_per_page == 0) {
1198 /* thumbnails should be splitted up in several pages */
1199 elseif($this->cfg->thumbs_per_page > 0) {
1201 if(!isset($_SESSION['begin_with']) || $_SESSION['begin_with'] == 0) {
1205 $begin_with = $_SESSION['begin_with'];
1208 $end_with = $begin_with + $this->cfg->thumbs_per_page;
1212 $images[$thumbs] = Array();
1213 $img_height[$thumbs] = Array();
1214 $img_width[$thumbs] = Array();
1215 $img_id[$thumbs] = Array();
1216 $img_name[$thumbs] = Array();
1217 $img_fullname[$thumbs] = Array();
1218 $img_title = Array();
1220 for($i = $begin_with; $i < $end_with; $i++) {
1222 if(isset($photos[$i])) {
1224 $images[$thumbs] = $photos[$i];
1225 $img_id[$thumbs] = $i;
1226 $img_name[$thumbs] = htmlspecialchars($this->getPhotoName($photos[$i], 15));
1227 $img_fullname[$thumbs] = htmlspecialchars($this->getPhotoName($photos[$i], 0));
1228 $img_title[$thumbs] = "Click to view photo ". htmlspecialchars($this->getPhotoName($photos[$i], 0));
1230 $thumb_path = $this->get_thumb_path($this->cfg->thumb_width, $photos[$i]);
1232 if(file_exists($thumb_path)) {
1233 $info = getimagesize($thumb_path);
1234 $img_width[$thumbs] = $info[0];
1235 $img_height[$thumbs] = $info[1];
1241 // +1 for for smarty's selection iteration
1244 if(isset($_SESSION['searchfor_tag']) && $_SESSION['searchfor_tag'] != '')
1245 $this->tmpl->assign('searchfor_tag', $_SESSION['searchfor_tag']);
1247 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
1248 $this->tmpl->assign('from_date', $this->ts2str($_SESSION['from_date']));
1249 $this->tmpl->assign('to_date', $this->ts2str($_SESSION['to_date']));
1252 if(isset($_SESSION['selected_tags']) && !empty($_SESSION['selected_tags'])) {
1253 $this->tmpl->assign('tag_result', 1);
1256 /* do we have to display the page selector ? */
1257 if($this->cfg->thumbs_per_page != 0) {
1261 /* calculate the page switchers */
1262 $previous_start = $begin_with - $this->cfg->thumbs_per_page;
1263 $next_start = $begin_with + $this->cfg->thumbs_per_page;
1265 if($begin_with != 0)
1266 $this->tmpl->assign("previous_url", "javascript:showPhotoIndex(". $previous_start .");");
1267 if($end_with < $count)
1268 $this->tmpl->assign("next_url", "javascript:showPhotoIndex(". $next_start .");");
1270 $photo_per_page = $this->cfg->thumbs_per_page;
1271 $last_page = ceil($count / $photo_per_page);
1273 /* get the current selected page */
1274 if($begin_with == 0) {
1278 for($i = $begin_with; $i >= 0; $i-=$photo_per_page) {
1285 for($i = 1; $i <= $last_page; $i++) {
1287 if($current_page == $i)
1288 $style = "style=\"font-size: 125%; text-decoration: underline;\"";
1289 elseif($current_page-1 == $i || $current_page+1 == $i)
1290 $style = "style=\"font-size: 105%;\"";
1291 elseif(($current_page-5 >= $i) && ($i != 1) ||
1292 ($current_page+5 <= $i) && ($i != $last_page))
1293 $style = "style=\"font-size: 75%;\"";
1297 $select = "<a href=\"javascript:showPhotoIndex(". (($i*$photo_per_page)-$photo_per_page) .");\"";
1300 $select.= ">". $i ."</a> ";
1302 // until 9 pages we show the selector from 1-9
1303 if($last_page <= 9) {
1304 $page_select.= $select;
1307 if($i == 1 /* first page */ ||
1308 $i == $last_page /* last page */ ||
1309 $i == $current_page /* current page */ ||
1310 $i == ceil($last_page * 0.25) /* first quater */ ||
1311 $i == ceil($last_page * 0.5) /* half */ ||
1312 $i == ceil($last_page * 0.75) /* third quater */ ||
1313 (in_array($i, array(1,2,3,4,5,6)) && $current_page <= 4) /* the first 6 */ ||
1314 (in_array($i, array($last_page, $last_page-1, $last_page-2, $last_page-3, $last_page-4, $last_page-5)) && $current_page >= $last_page-4) /* the last 6 */ ||
1315 $i == $current_page-3 || $i == $current_page-2 || $i == $current_page-1 /* three before */ ||
1316 $i == $current_page+3 || $i == $current_page+2 || $i == $current_page+1 /* three after */) {
1318 $page_select.= $select;
1326 $page_select.= "......... ";
1331 /* only show the page selector if we have more then one page */
1333 $this->tmpl->assign('page_selector', $page_select);
1337 $current_tags = $this->getCurrentTags();
1338 $extern_link = "index.php?mode=showpi";
1339 $rss_link = "index.php?mode=rss";
1340 if($current_tags != "") {
1341 $extern_link.= "&tags=". $current_tags;
1342 $rss_link.= "&tags=". $current_tags;
1344 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
1345 $extern_link.= "&from_date=". $this->ts2str($_SESSION['from_date']) ."&to_date=". $this->ts2str($_SESSION['to_date']);
1346 $rss_link.= "&from_date=". $this->ts2str($_SESSION['from_date']) ."&to_date=". $this->ts2str($_SESSION['to_date']);
1349 $export_link = "index.php?mode=export";
1350 $slideshow_link = "index.php?mode=slideshow";
1352 $this->tmpl->assign('extern_link', $extern_link);
1353 $this->tmpl->assign('slideshow_link', $slideshow_link);
1354 $this->tmpl->assign('export_link', $export_link);
1355 $this->tmpl->assign('rss_link', $rss_link);
1356 $this->tmpl->assign('count', $count);
1357 $this->tmpl->assign('width', $this->cfg->thumb_width);
1358 $this->tmpl->assign('preview_width', $this->cfg->photo_width);
1359 $this->tmpl->assign('thumb_container_width', $this->cfg->thumb_width);
1360 $this->tmpl->assign('thumb_container_height', $this->cfg->thumb_height+20);
1361 $this->tmpl->assign('images', $images);
1362 $this->tmpl->assign('img_width', $img_width);
1363 $this->tmpl->assign('img_height', $img_height);
1364 $this->tmpl->assign('img_id', $img_id);
1365 $this->tmpl->assign('img_name', $img_name);
1366 $this->tmpl->assign('img_fullname', $img_fullname);
1367 $this->tmpl->assign('img_title', $img_title);
1368 $this->tmpl->assign('thumbs', $thumbs);
1369 $this->tmpl->assign('selected_tags', $this->getSelectedTags('img'));
1371 $result = $this->tmpl->fetch("photo_index.tpl");
1373 /* if we are returning to photo index from an photo-view,
1374 scroll the window to the last shown photo-thumbnail.
1375 after this, unset the last_photo session variable.
1377 if(isset($_SESSION['last_photo'])) {
1378 $result.= "<script language=\"JavaScript\">moveToThumb(". $_SESSION['last_photo'] .");</script>\n";
1379 unset($_SESSION['last_photo']);
1384 } // showPhotoIndex()
1387 * show credit template
1389 public function showCredits()
1391 $this->tmpl->assign('version', $this->cfg->version);
1392 $this->tmpl->assign('product', $this->cfg->product);
1393 $this->tmpl->assign('db_version', $this->dbver);
1394 $this->tmpl->show("credits.tpl");
1399 * create thumbnails for the requested width
1401 * this function creates image thumbnails of $orig_image
1402 * stored as $thumb_image. It will check if the image is
1403 * in a supported format, if necessary rotate the image
1404 * (based on EXIF orientation meta headers) and re-sizing.
1405 * @param string $orig_image
1406 * @param string $thumb_image
1407 * @param integer $width
1410 public function create_thumbnail($orig_image, $thumb_image, $width)
1412 if(!file_exists($orig_image)) {
1416 $mime = $this->get_mime_info($orig_image);
1418 /* check if original photo is a support image type */
1419 if(!$this->checkifImageSupported($mime))
1426 $meta = $this->get_meta_informations($orig_image);
1432 switch($meta['Orientation']) {
1433 case 1: /* top, left */
1434 /* nothing to do */ break;
1435 case 2: /* top, right */
1436 $rotate = 0; $flip_hori = true; break;
1437 case 3: /* bottom, left */
1438 $rotate = 180; break;
1439 case 4: /* bottom, right */
1440 $flip_vert = true; break;
1441 case 5: /* left side, top */
1442 $rotate = 90; $flip_vert = true; break;
1443 case 6: /* right side, top */
1444 $rotate = 90; break;
1445 case 7: /* left side, bottom */
1446 $rotate = 270; $flip_vert = true; break;
1447 case 8: /* right side, bottom */
1448 $rotate = 270; break;
1451 $src_img = @imagecreatefromjpeg($orig_image);
1457 $src_img = @imagecreatefrompng($orig_image);
1461 case 'image/x-portable-pixmap':
1463 $src_img = new Imagick($orig_image);
1464 $handler = "imagick";
1469 if(!isset($src_img) || empty($src_img)) {
1470 print "Can't load image from ". $orig_image ."\n";
1478 /* grabs the height and width */
1479 $cur_width = imagesx($src_img);
1480 $cur_height = imagesy($src_img);
1482 // If requested width is more then the actual image width,
1483 // do not generate a thumbnail, instead safe the original
1484 // as thumbnail but with lower quality. But if the image
1485 // is to heigh too, then we still have to resize it.
1486 if($width >= $cur_width && $cur_height < $this->cfg->thumb_height) {
1487 $result = imagejpeg($src_img, $thumb_image, 75);
1488 imagedestroy($src_img);
1495 $cur_width = $src_img->getImageWidth();
1496 $cur_height = $src_img->getImageHeight();
1498 // If requested width is more then the actual image width,
1499 // do not generate a thumbnail, instead safe the original
1500 // as thumbnail but with lower quality. But if the image
1501 // is to heigh too, then we still have to resize it.
1502 if($width >= $cur_width && $cur_height < $this->cfg->thumb_height) {
1503 $src_img->setCompressionQuality(75);
1504 $src_img->setImageFormat('jpeg');
1505 $src_img->writeImage($thumb_image);
1507 $src_img->destroy();
1514 // If the image will be rotate because EXIF orientation said so
1515 // 'virtually rotate' the image for further calculations
1516 if($rotate == 90 || $rotate == 270) {
1518 $cur_width = $cur_height;
1522 /* calculates aspect ratio */
1523 $aspect_ratio = $cur_height / $cur_width;
1526 if($aspect_ratio < 1) {
1528 $new_h = abs($new_w * $aspect_ratio);
1530 /* 'virtually' rotate the image and calculate it's ratio */
1531 $tmp_w = $cur_height;
1532 $tmp_h = $cur_width;
1533 /* now get the ratio from the 'rotated' image */
1534 $tmp_ratio = $tmp_h/$tmp_w;
1535 /* now calculate the new dimensions */
1537 $tmp_h = abs($tmp_w * $tmp_ratio);
1539 // now that we know, how high they photo should be, if it
1540 // gets rotated, use this high to scale the image
1542 $new_w = abs($new_h / $aspect_ratio);
1544 // If the image will be rotate because EXIF orientation said so
1545 // now 'virtually rotate' back the image for the image manipulation
1546 if($rotate == 90 || $rotate == 270) {
1557 /* creates new image of that size */
1558 $dst_img = imagecreatetruecolor($new_w, $new_h);
1560 imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255));
1562 /* copies resized portion of original image into new image */
1563 imagecopyresampled($dst_img, $src_img, 0, 0, 0, 0, $new_w, $new_h, imagesx($src_img), imagesy($src_img));
1565 /* needs the image to be flipped horizontal? */
1567 $this->_debug("(FLIP)");
1568 $dst_img = $this->flipImage($dst_img, 'hori');
1570 /* needs the image to be flipped vertical? */
1572 $this->_debug("(FLIP)");
1573 $dst_img = $this->flipImage($dst_img, 'vert');
1577 $this->_debug("(ROTATE)");
1578 $dst_img = $this->rotateImage($dst_img, $rotate);
1581 /* write down new generated file */
1582 $result = imagejpeg($dst_img, $thumb_image, 75);
1584 /* free your mind */
1585 imagedestroy($dst_img);
1586 imagedestroy($src_img);
1588 if($result === false) {
1589 print "Can't write thumbnail ". $thumb_image ."\n";
1599 $src_img->resizeImage($new_w, $new_h, Imagick::FILTER_LANCZOS, 1);
1601 /* needs the image to be flipped horizontal? */
1603 $this->_debug("(FLIP)");
1604 $src_img->rotateImage(new ImagickPixel(), 90);
1605 $src_img->flipImage();
1606 $src_img->rotateImage(new ImagickPixel(), -90);
1608 /* needs the image to be flipped vertical? */
1610 $this->_debug("(FLIP)");
1611 $src_img->flipImage();
1615 $this->_debug("(ROTATE)");
1616 $src_img->rotateImage(new ImagickPixel(), $rotate);
1619 $src_img->setCompressionQuality(75);
1620 $src_img->setImageFormat('jpeg');
1622 if(!$src_img->writeImage($thumb_image)) {
1623 print "Can't write thumbnail ". $thumb_image ."\n";
1628 $src_img->destroy();
1635 } // create_thumbnail()
1638 * return all exif meta data from the file
1639 * @param string $file
1642 public function get_meta_informations($file)
1644 return exif_read_data($file);
1646 } // get_meta_informations()
1649 * create phpfspot own sqlite database
1651 * this function creates phpfspots own sqlite database
1652 * if it does not exist yet. this own is used to store
1653 * some necessary informations (md5 sum's, ...).
1655 public function check_config_table()
1657 // if the config table doesn't exist yet, create it
1658 if(!$this->cfg_db->db_check_table_exists("images")) {
1659 $this->cfg_db->db_exec("
1660 CREATE TABLE images (
1661 img_idx int primary key,
1667 } // check_config_table
1670 * Generates a thumbnail from photo idx
1672 * This function will generate JPEG thumbnails from provided F-Spot photo
1675 * 1. Check if all thumbnail generations (width) are already in place and
1677 * 2. Check if the md5sum of the original file has changed
1678 * 3. Generate the thumbnails if needed
1679 * @param integer $idx
1680 * @param integer $force
1681 * @param boolean $overwrite
1683 public function gen_thumb($idx = 0, $force = 0, $overwrite = false)
1687 $resolutions = Array(
1688 $this->cfg->thumb_width,
1689 $this->cfg->photo_width,
1690 $this->cfg->mini_width,
1694 /* get details from F-Spot's database */
1695 $details = $this->get_photo_details($idx);
1697 /* calculate file MD5 sum */
1698 $full_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath'));
1700 if(!file_exists($full_path)) {
1701 $this->_error("File ". $full_path ." does not exist\n");
1705 if(!is_readable($full_path)) {
1706 $this->_error("File ". $full_path ." is not readable for ". $this->getuid() ."\n");
1710 $this->_debug("Image [". $idx ."] ". $this->shrink_text($this->parse_uri($details['uri'], 'filename'), 20) ." Thumbnails:");
1712 /* If Nikon NEF format, we need to treat it another way */
1713 if(isset($this->cfg->dcraw_bin) &&
1714 file_exists($this->cfg->dcraw_bin) &&
1715 is_executable($this->cfg->dcraw_bin) &&
1716 preg_match('/\.nef$/i', $details['uri'])) {
1718 $ppm_path = preg_replace('/\.nef$/i', '.ppm', $full_path);
1720 /* if PPM file does not exist, let dcraw convert it from NEF */
1721 if(!file_exists($ppm_path)) {
1722 system($this->cfg->dcraw_bin ." -a ". $full_path);
1725 /* for now we handle the PPM instead of the NEF */
1726 $full_path = $ppm_path;
1730 $file_md5 = md5_file($full_path);
1733 foreach($resolutions as $resolution) {
1735 $generate_it = false;
1737 $thumb_sub_path = substr($file_md5, 0, 2);
1738 $thumb_path = $this->cfg->thumb_path ."/". $thumb_sub_path ."/". $resolution ."_". $file_md5;
1740 /* if thumbnail-subdirectory does not exist yet, create it */
1741 if(!file_exists(dirname($thumb_path))) {
1742 mkdir(dirname($thumb_path), 0755);
1745 /* if the thumbnail file doesn't exist, create it */
1746 if(!file_exists($thumb_path)) {
1747 $generate_it = true;
1749 /* if the file hasn't changed there is no need to regen the thumb */
1750 elseif($file_md5 != $this->getMD5($idx) || $force) {
1751 $generate_it = true;
1754 if($generate_it || $overwrite) {
1756 $this->_debug(" ". $resolution ."px");
1757 if(!$this->create_thumbnail($full_path, $thumb_path, $resolution))
1765 $this->_debug(" already exist");
1768 /* set the new/changed MD5 sum for the current photo */
1770 $this->setMD5($idx, $file_md5);
1773 $this->_debug("\n");
1778 * returns stored md5 sum for a specific photo
1780 * this function queries the phpfspot database for a
1781 * stored MD5 checksum of the specified photo
1782 * @param integer $idx
1783 * @return string|null
1785 public function getMD5($idx)
1787 $result = $this->cfg_db->db_query("
1790 WHERE img_idx='". $idx ."'
1796 $img = $this->cfg_db->db_fetch_object($result);
1797 return $img['img_md5'];
1802 * set MD5 sum for the specific photo
1803 * @param integer $idx
1804 * @param string $md5
1806 private function setMD5($idx, $md5)
1808 $result = $this->cfg_db->db_exec("
1809 REPLACE INTO images (img_idx, img_md5)
1810 VALUES ('". $idx ."', '". $md5 ."')
1816 * store current tag condition
1818 * this function stores the current tag condition
1819 * (AND or OR) in the users session variables
1820 * @param string $mode
1823 public function setTagCondition($mode)
1825 $_SESSION['tag_condition'] = $mode;
1829 } // setTagCondition()
1832 * invoke tag & date search
1834 * this function will return all matching tags and store
1835 * them in the session variable selected_tags. furthermore
1836 * it also handles the date search.
1837 * getPhotoSelection() will then only return the matching
1841 public function startSearch()
1843 if(isset($_POST['from']) && $this->isValidDate($_POST['from'])) {
1844 $from = $_POST['from'];
1846 if(isset($_POST['to']) && $this->isValidDate($_POST['to'])) {
1850 if(isset($_POST['for_tag']) && is_string($_POST['for_tag'])) {
1851 $searchfor_tag = $_POST['for_tag'];
1852 $_SESSION['searchfor_tag'] = $_POST['for_tag'];
1855 if(isset($_POST['for_name']) && is_string($_POST['for_name'])) {
1856 $searchfor_name = $_POST['for_name'];
1857 $_SESSION['searchfor_name'] = $_POST['for_name'];
1862 if(isset($from) && !empty($from))
1863 $_SESSION['from_date'] = strtotime($from ." 00:00:00");
1865 unset($_SESSION['from_date']);
1867 if(isset($to) && !empty($to))
1868 $_SESSION['to_date'] = strtotime($to ." 23:59:59");
1870 unset($_SESSION['to_date']);
1872 if(isset($searchfor_tag) && !empty($searchfor_tag)) {
1873 /* new search, reset the current selected tags */
1874 $_SESSION['selected_tags'] = Array();
1875 foreach($this->avail_tags as $tag) {
1876 if(preg_match('/'. $searchfor_tag .'/i', $this->tags[$tag]))
1877 array_push($_SESSION['selected_tags'], $tag);
1886 * updates sort order in session variable
1888 * this function is invoked by RPC and will sort the requested
1889 * sort order in the session variable.
1890 * @param string $sort_order
1893 public function updateSortOrder($order)
1895 if(isset($this->sort_orders[$order])) {
1896 $_SESSION['sort_order'] = $order;
1900 return "unkown error";
1902 } // updateSortOrder()
1907 * this function rotates the image according the
1909 * @param string $img
1910 * @param integer $degress
1913 private function rotateImage($img, $degrees)
1915 if(function_exists("imagerotate")) {
1916 $img = imagerotate($img, $degrees, 0);
1918 function imagerotate($src_img, $angle)
1920 $src_x = imagesx($src_img);
1921 $src_y = imagesy($src_img);
1922 if ($angle == 180) {
1926 elseif ($src_x <= $src_y) {
1930 elseif ($src_x >= $src_y) {
1935 $rotate=imagecreatetruecolor($dest_x,$dest_y);
1936 imagealphablending($rotate, false);
1941 for ($y = 0; $y < ($src_y); $y++) {
1942 for ($x = 0; $x < ($src_x); $x++) {
1943 $color = imagecolorat($src_img, $x, $y);
1944 imagesetpixel($rotate, $dest_x - $y - 1, $x, $color);
1950 for ($y = 0; $y < ($src_y); $y++) {
1951 for ($x = 0; $x < ($src_x); $x++) {
1952 $color = imagecolorat($src_img, $x, $y);
1953 imagesetpixel($rotate, $y, $dest_y - $x - 1, $color);
1959 for ($y = 0; $y < ($src_y); $y++) {
1960 for ($x = 0; $x < ($src_x); $x++) {
1961 $color = imagecolorat($src_img, $x, $y);
1962 imagesetpixel($rotate, $dest_x - $x - 1, $dest_y - $y - 1, $color);
1976 $img = imagerotate($img, $degrees);
1985 * returns flipped image
1987 * this function will return an either horizontal or
1988 * vertical flipped truecolor image.
1989 * @param string $image
1990 * @param string $mode
1993 private function flipImage($image, $mode)
1995 $w = imagesx($image);
1996 $h = imagesy($image);
1997 $flipped = imagecreatetruecolor($w, $h);
2001 for ($y = 0; $y < $h; $y++) {
2002 imagecopy($flipped, $image, 0, $y, 0, $h - $y - 1, $w, 1);
2006 for ($x = 0; $x < $w; $x++) {
2007 imagecopy($flipped, $image, $x, 0, $w - $x - 1, 0, 1, $h);
2017 * return all assigned tags for the specified photo
2018 * @param integer $idx
2021 private function get_photo_tags($idx)
2023 $result = $this->db->db_query("
2026 INNER JOIN photo_tags pt
2028 WHERE pt.photo_id='". $idx ."'
2033 while($row = $this->db->db_fetch_object($result)) {
2034 if(isset($this->cfg->hide_tags) && in_array($row['name'], $this->cfg->hide_tags))
2036 $tags[$row['id']] = $row['name'];
2041 } // get_photo_tags()
2044 * create on-the-fly images with text within
2045 * @param string $txt
2046 * @param string $color
2047 * @param integer $space
2048 * @param integer $font
2051 public function showTextImage($txt, $color=000000, $space=4, $font=4, $w=300)
2053 if (strlen($color) != 6)
2056 $int = hexdec($color);
2057 $h = imagefontheight($font);
2058 $fw = imagefontwidth($font);
2059 $txt = explode("\n", wordwrap($txt, ($w / $fw), "\n"));
2060 $lines = count($txt);
2061 $im = imagecreate($w, (($h * $lines) + ($lines * $space)));
2062 $bg = imagecolorallocate($im, 255, 255, 255);
2063 $color = imagecolorallocate($im, 0xFF & ($int >> 0x10), 0xFF & ($int >> 0x8), 0xFF & $int);
2066 foreach ($txt as $text) {
2067 $x = (($w - ($fw * strlen($text))) / 2);
2068 imagestring($im, $font, $x, $y, $text, $color);
2069 $y += ($h + $space);
2072 Header("Content-type: image/png");
2075 } // showTextImage()
2078 * check if all requirements are met
2081 private function check_requirements()
2083 if(!function_exists("imagecreatefromjpeg")) {
2084 print "PHP GD library extension is missing<br />\n";
2088 if($this->cfg->db_access == "native" && !function_exists("sqlite3_open")) {
2089 print "PHP SQLite3 library extension is missing<br />\n";
2093 /* Check for HTML_AJAX PEAR package, lent from Horde project */
2094 ini_set('track_errors', 1);
2095 @include_once 'HTML/AJAX/Server.php';
2096 if(isset($php_errormsg) && preg_match('/Failed opening.*for inclusion/i', $php_errormsg)) {
2097 print "PEAR HTML_AJAX package is missing<br />\n";
2100 @include_once 'Calendar/Calendar.php';
2101 if(isset($php_errormsg) && preg_match('/Failed opening.*for inclusion/i', $php_errormsg)) {
2102 print "PEAR Calendar package is missing<br />\n";
2105 @include_once 'Console/Getopt.php';
2106 if(isset($php_errormsg) && preg_match('/Failed opening.*for inclusion/i', $php_errormsg)) {
2107 print "PEAR Console_Getopt package is missing<br />\n";
2110 @include_once $this->cfg->smarty_path .'/libs/Smarty.class.php';
2111 if(isset($php_errormsg) && preg_match('/Failed opening.*for inclusion/i', $php_errormsg)) {
2112 print "Smarty template engine can not be found in ". $this->cfg->smarty_path ."/libs/Smarty.class.php<br />\n";
2115 ini_restore('track_errors');
2122 } // check_requirements()
2124 private function _debug($text)
2126 if($this->fromcmd) {
2133 * check if specified MIME type is supported
2134 * @param string $mime
2137 public function checkifImageSupported($mime)
2139 $supported_types = Array(
2142 "image/x-portable-pixmap",
2146 if(in_array($mime, $supported_types))
2151 } // checkifImageSupported()
2155 * @param string $text
2157 public function _error($text)
2159 switch($this->cfg->logging) {
2162 print "<img src=\"resources/green_info.png\" alt=\"warning\" />\n";
2163 print $text ."<br />\n";
2169 error_log($text, 3, $his->cfg->log_file);
2173 $this->runtime_error = true;
2178 * output calendard input fields
2179 * @param string $mode
2182 private function get_calendar($mode)
2184 $year = isset($_SESSION[$mode .'_date']) ? date("Y", $_SESSION[$mode .'_date']) : date("Y");
2185 $month = isset($_SESSION[$mode .'_date']) ? date("m", $_SESSION[$mode .'_date']) : date("m");
2186 $day = isset($_SESSION[$mode .'_date']) ? date("d", $_SESSION[$mode .'_date']) : date("d");
2188 $output = "<input type=\"text\" size=\"3\" id=\"". $mode ."year\" value=\"". $year ."\"";
2189 if(!isset($_SESSION[$mode .'_date']))
2190 $output.= " disabled=\"disabled\"";
2192 $output.= "<input type=\"text\" size=\"1\" id=\"". $mode ."month\" value=\"". $month ."\"";
2193 if(!isset($_SESSION[$mode .'_date']))
2194 $output.= " disabled=\"disabled\"";
2196 $output.= "<input type=\"text\" size=\"1\" id=\"". $mode ."day\" value=\"". $day ."\"";
2197 if(!isset($_SESSION[$mode .'_date']))
2198 $output.= " disabled=\"disabled\"";
2206 * output calendar matrix
2207 * @param integer $year
2208 * @param integer $month
2209 * @param integer $day
2211 public function get_calendar_matrix($year = 0, $month = 0, $day = 0)
2213 if (!isset($year)) $year = date('Y');
2214 if (!isset($month)) $month = date('m');
2215 if (!isset($day)) $day = date('d');
2220 require_once CALENDAR_ROOT.'Month/Weekdays.php';
2221 require_once CALENDAR_ROOT.'Day.php';
2224 $month = new Calendar_Month_Weekdays($year,$month);
2227 $prevStamp = $month->prevMonth(true);
2228 $prev = "javascript:setMonth(". date('Y',$prevStamp) .", ". date('n',$prevStamp) .", ". date('j',$prevStamp) .");";
2229 $nextStamp = $month->nextMonth(true);
2230 $next = "javascript:setMonth(". date('Y',$nextStamp) .", ". date('n',$nextStamp) .", ". date('j',$nextStamp) .");";
2232 $selectedDays = array (
2233 new Calendar_Day($year,$month,$day),
2234 new Calendar_Day($year,12,25),
2237 // Build the days in the month
2238 $month->build($selectedDays);
2240 $this->tmpl->assign('current_month', date('F Y',$month->getTimeStamp()));
2241 $this->tmpl->assign('prev_month', $prev);
2242 $this->tmpl->assign('next_month', $next);
2244 while ( $day = $month->fetch() ) {
2246 if(!isset($matrix[$rows]))
2247 $matrix[$rows] = Array();
2251 $dayStamp = $day->thisDay(true);
2252 $link = "javascript:setCalendarDate(". date('Y',$dayStamp) .", ". date('n',$dayStamp).", ". date('j',$dayStamp) .");";
2254 // isFirst() to find start of week
2255 if ( $day->isFirst() )
2258 if ( $day->isSelected() ) {
2259 $string.= "<td class=\"selected\">".$day->thisDay()."</td>\n";
2260 } else if ( $day->isEmpty() ) {
2261 $string.= "<td> </td>\n";
2263 $string.= "<td><a class=\"calendar\" href=\"".$link."\">".$day->thisDay()."</a></td>\n";
2266 // isLast() to find end of week
2267 if ( $day->isLast() )
2268 $string.= "</tr>\n";
2270 $matrix[$rows][$cols] = $string;
2280 $this->tmpl->assign('matrix', $matrix);
2281 $this->tmpl->assign('rows', $rows);
2282 $this->tmpl->show("calendar.tpl");
2284 } // get_calendar_matrix()
2287 * output export page
2288 * @param string $mode
2290 public function getExport($mode)
2292 $pictures = $this->getPhotoSelection();
2293 $current_tags = $this->getCurrentTags();
2295 foreach($pictures as $picture) {
2297 $orig_url = $this->get_phpfspot_url() ."/index.php?mode=showp&id=". $picture;
2298 if($current_tags != "") {
2299 $orig_url.= "&tags=". $current_tags;
2301 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
2302 $orig_url.= "&from_date=". $_SESSION['from_date'] ."&to_date=". $_SESSION['to_date'];
2305 if($this->is_user_friendly_url()) {
2306 $thumb_url = $this->get_phpfspot_url() ."/photo/". $picture ."/". $this->cfg->thumb_width;
2309 $thumb_url = $this->get_phpfspot_url() ."/phpfspot_img.php?idx=". $picture ."&width=". $this->cfg->thumb_width;
2315 // <a href="%pictureurl%"><img src="%thumbnailurl%" ></a>
2316 print htmlspecialchars("<a href=\"". $orig_url ."\"><img src=\"". $thumb_url ."\" /></a>") ."<br />\n";
2320 // "[%pictureurl% %thumbnailurl%]"
2321 print htmlspecialchars("[".$orig_url." ".$thumb_url."&fake=1.jpg]") ."<br />\n";
2324 case 'MoinMoinList':
2325 // " * [%pictureurl% %thumbnailurl%]"
2326 print " " . htmlspecialchars("* [".$orig_url." ".$thumb_url."&fake=1.jpg]") ."<br />\n";
2337 public function getRSSFeed()
2339 Header("Content-type: text/xml; charset=utf-8");
2340 print "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
2343 xmlns:media="http://search.yahoo.com/mrss/"
2344 xmlns:dc="http://purl.org/dc/elements/1.1/"
2347 <title>phpfspot</title>
2348 <description>phpfspot RSS feed</description>
2349 <link><?php print htmlspecialchars($this->get_phpfspot_url()); ?></link>
2350 <pubDate><?php print strftime("%a, %d %b %Y %T %z"); ?></pubDate>
2351 <generator>phpfspot</generator>
2354 $pictures = $this->getPhotoSelection();
2355 $current_tags = $this->getCurrentTags();
2357 foreach($pictures as $picture) {
2359 $orig_url = $this->get_phpfspot_url() ."/index.php?mode=showp&id=". $picture;
2360 if($current_tags != "") {
2361 $orig_url.= "&tags=". $current_tags;
2363 if(isset($_SESSION['from_date']) && isset($_SESSION['to_date'])) {
2364 $orig_url.= "&from_date=". $_SESSION['from_date'] ."&to_date=". $_SESSION['to_date'];
2367 $details = $this->get_photo_details($picture);
2369 if($this->is_user_friendly_url()) {
2370 $thumb_url = $this->get_phpfspot_url() ."/photo/". $picture ."/". $this->cfg->thumb_width;
2373 $thumb_url = $this->get_phpfspot_url() ."/phpfspot_img.php?idx=". $picture ."&width=". $this->cfg->thumb_width;
2376 $thumb_html = htmlspecialchars("
2377 <a href=\"". $orig_url ."\"><img src=\"". $thumb_url ."\" /></a>
2379 ". $details['description']);
2381 $orig_path = $this->translate_path($this->parse_uri($details['uri'], 'fullpath'));
2383 /* get EXIF information if JPEG */
2384 if($details['mime'] == "image/jpeg") {
2385 $meta = $this->get_meta_informations($orig_path);
2388 $meta_date = isset($meta['FileDateTime']) ? $meta['FileDateTime'] : filemtime($orig_path);
2392 <title><?php print htmlspecialchars($this->parse_uri($details['uri'], 'filename')); ?></title>
2393 <link><?php print htmlspecialchars($orig_url); ?></link>
2394 <guid><?php print htmlspecialchars($orig_url); ?></guid>
2395 <dc:date.Taken><?php print strftime("%Y-%m-%dT%H:%M:%S+00:00", $meta_date); ?></dc:date.Taken>
2397 <?php print $thumb_html; ?>
2399 <pubDate><?php print strftime("%a, %d %b %Y %T %z", $meta_date); ?></pubDate>
2414 * return all selected tags as one string
2417 private function getCurrentTags()
2420 if(isset($_SESSION['selected_tags']) && $_SESSION['selected_tags'] != "") {
2421 foreach($_SESSION['selected_tags'] as $tag)
2422 $current_tags.= $tag .",";
2423 $current_tags = substr($current_tags, 0, strlen($current_tags)-1);
2425 return $current_tags;
2427 } // getCurrentTags()
2430 * return the current photo
2432 public function getCurrentPhoto()
2434 if(isset($_SESSION['current_photo'])) {
2435 print $_SESSION['current_photo'];
2437 } // getCurrentPhoto()
2440 * tells the client browser what to do
2442 * this function is getting called via AJAX by the
2443 * client browsers. it will tell them what they have
2444 * to do next. This is necessary for directly jumping
2445 * into photo index or single photo view when the are
2446 * requested with specific URLs
2449 public function whatToDo()
2451 if(isset($_SESSION['current_photo']) && $_SESSION['start_action'] == 'showp') {
2453 elseif(isset($_SESSION['selected_tags']) && !empty($_SESSION['selected_tags'])) {
2454 return "showpi_tags";
2456 elseif(isset($_SESSION['start_action']) && $_SESSION['start_action'] == 'showpi') {
2463 * return the current process-user
2466 private function getuid()
2468 if($uid = posix_getuid()) {
2469 if($user = posix_getpwuid($uid)) {
2470 return $user['name'];
2479 * returns a select-dropdown box to select photo index sort parameters
2480 * @param array $params
2481 * @param smarty $smarty
2484 public function smarty_sort_select_list($params, &$smarty)
2488 foreach($this->sort_orders as $key => $value) {
2489 $output.= "<option value=\"". $key ."\"";
2490 if($key == $_SESSION['sort_order']) {
2491 $output.= " selected=\"selected\"";
2493 $output.= ">". $value ."</option>";
2498 } // smarty_sort_select_list()
2501 * returns the currently selected sort order
2504 private function get_sort_order()
2506 switch($_SESSION['sort_order']) {
2508 return " ORDER BY p.time ASC";
2511 return " ORDER BY p.time DESC";
2514 if($this->dbver < 9) {
2515 return " ORDER BY p.name ASC";
2518 return " ORDER BY basename(p.uri) ASC";
2522 if($this->dbver < 9) {
2523 return " ORDER BY p.name DESC";
2526 return " ORDER BY basename(p.uri) DESC";
2530 return " ORDER BY t.name ASC ,p.time ASC";
2533 return " ORDER BY t.name DESC ,p.time ASC";
2537 } // get_sort_order()
2540 * return the next to be shown slide show image
2542 * this function returns the URL of the next image
2543 * in the slideshow sequence.
2546 public function getNextSlideShowImage()
2548 $all_photos = $this->getPhotoSelection();
2550 if(!isset($_SESSION['slideshow_img']) || $_SESSION['slideshow_img'] == count($all_photos)-1)
2551 $_SESSION['slideshow_img'] = 0;
2553 $_SESSION['slideshow_img']++;
2555 if($this->is_user_friendly_url()) {
2556 return $this->get_phpfspot_url() ."/photo/". $all_photos[$_SESSION['slideshow_img']] ."/". $this->cfg->photo_width;
2559 return $this->get_phpfspot_url() ."/phpfspot_img.php?idx=". $all_photos[$_SESSION['slideshow_img']] ."&width=". $this->cfg->photo_width;
2561 } // getNextSlideShowImage()
2564 * return the previous to be shown slide show image
2566 * this function returns the URL of the previous image
2567 * in the slideshow sequence.
2570 public function getPrevSlideShowImage()
2572 $all_photos = $this->getPhotoSelection();
2574 if(!isset($_SESSION['slideshow_img']) || $_SESSION['slideshow_img'] == 0)
2575 $_SESSION['slideshow_img'] = 0;
2577 $_SESSION['slideshow_img']--;
2579 if($this->is_user_friendly_url()) {
2580 return $this->get_phpfspot_url() ."/photo/". $all_photos[$_SESSION['slideshow_img']] ."/". $this->cfg->photo_width;
2583 return $this->get_phpfspot_url() ."/phpfspot_img.php?idx=". $all_photos[$_SESSION['slideshow_img']] ."&width=". $this->cfg->photo_width;
2585 } // getPrevSlideShowImage()
2587 public function resetSlideShow()
2589 if(isset($_SESSION['slideshow_img']))
2590 unset($_SESSION['slideshow_img']);
2592 } // resetSlideShow()
2597 * this function will get all photos from the fspot
2598 * database and randomly return ONE entry
2600 * saddly there is yet no sqlite3 function which returns
2601 * the bulk result in array, so we have to fill up our
2605 public function get_random_photo()
2614 /* if show_tags is set, only return details for photos which
2615 are specified to be shown
2617 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
2619 INNER JOIN photo_tags pt
2624 t.name IN ('".implode("','",$this->cfg->show_tags)."')";
2627 $result = $this->db->db_query($query_str);
2629 while($row = $this->db->db_fetch_object($result)) {
2630 array_push($all, $row['id']);
2633 return $all[array_rand($all)];
2635 } // get_random_photo()
2638 * get random photo tag photo
2640 * this function will get all photos tagged with the requested
2641 * tag from the fspot database and randomly return ONE entry
2643 * saddly there is yet no sqlite3 function which returns
2644 * the bulk result in array, so we have to fill up our
2648 public function get_random_tag_photo($tagidx)
2655 INNER JOIN photo_tags pt
2659 if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
2667 pt.tag_id LIKE '". $tagidx ."'
2670 /*if(isset($this->cfg->show_tags) && !empty($this->cfg->show_tags)) {
2673 t.name IN ('".implode("','",$this->cfg->show_tags)."')
2677 $result = $this->db->db_query($query_str);
2679 while($row = $this->db->db_fetch_object($result)) {
2680 array_push($all, $row['id']);
2683 return $all[array_rand($all)];
2685 } // get_random_tag_photo()
2688 * validates provided date
2690 * this function validates if the provided date
2691 * contains a valid date and will return true
2693 * @param string $date_str
2696 public function isValidDate($date_str)
2698 $timestamp = strtotime($date_str);
2700 if(is_numeric($timestamp))
2708 * timestamp to string conversion
2709 * @param integer $timestamp
2712 private function ts2str($timestamp)
2714 return strftime("%Y-%m-%d", $timestamp);
2718 * extract tag-names from $_GET['tags']
2719 * @param string $tags_str
2722 private function extractTags($tags_str)
2724 $not_validated = split(',', $tags_str);
2725 $validated = array();
2727 foreach($not_validated as $tag) {
2728 if(is_numeric($tag))
2729 array_push($validated, $tag);
2737 * returns the full path to a thumbnail
2738 * @param integer $width
2739 * @param integer $photo
2742 public function get_thumb_path($width, $photo)
2744 $md5 = $this->getMD5($photo);
2745 $sub_path = substr($md5, 0, 2);
2746 return $this->cfg->thumb_path
2754 } // get_thumb_path()
2757 * returns server's virtual host name
2760 private function get_server_name()
2762 return $_SERVER['SERVER_NAME'];
2763 } // get_server_name()
2766 * returns type of webprotocol which is currently used
2769 private function get_web_protocol()
2771 if(!isset($_SERVER['HTTPS']))
2775 } // get_web_protocol()
2778 * return url to this phpfspot installation
2781 private function get_phpfspot_url()
2783 return $this->get_web_protocol() ."://". $this->get_server_name() . $this->cfg->web_path;
2785 } // get_phpfspot_url()
2788 * returns the number of photos which are tagged with $tag_id
2789 * @param integer $tag_id
2792 public function get_num_photos($tag_id)
2794 if($result = $this->db->db_fetchSingleRow("
2795 SELECT count(*) as number
2798 tag_id LIKE '". $tag_id ."'")) {
2800 return $result['number'];
2806 } // get_num_photos()
2809 * check file exists and is readable
2811 * returns true, if everything is ok, otherwise false
2812 * if $silent is not set, this function will output and
2814 * @param string $file
2815 * @param boolean $silent
2818 private function check_readable($file, $silent = null)
2820 if(!file_exists($file)) {
2822 print "File \"". $file ."\" does not exist.\n";
2826 if(!is_readable($file)) {
2828 print "File \"". $file ."\" is not reachable for user ". $this->getuid() ."\n";
2834 } // check_readable()
2837 * check if all needed indices are present
2839 * this function checks, if some needed indices are already
2840 * present, or if not, create them on the fly. they are
2841 * necessary to speed up some queries like that one look for
2842 * all tags, when show_tags is specified in the configuration.
2844 private function checkDbIndices()
2846 $result = $this->db->db_exec("
2847 CREATE INDEX IF NOT EXISTS
2854 } // checkDbIndices()
2857 * retrive F-Spot database version
2859 * this function will return the F-Spot database version number
2860 * It is stored within the sqlite3 database in the table meta
2861 * @return string|null
2863 public function getFspotDBVersion()
2865 if($result = $this->db->db_fetchSingleRow("
2866 SELECT data as version
2869 name LIKE 'F-Spot Database Version'
2871 return $result['version'];
2875 } // getFspotDBVersion()
2878 * parse the provided URI and will returned the requested chunk
2879 * @param string $uri
2880 * @param string $mode
2883 public function parse_uri($uri, $mode)
2885 if(($components = parse_url($uri)) !== false) {
2889 return basename($components['path']);
2892 return dirname($components['path']);
2895 return $components['path'];
2905 * validate config options
2907 * this function checks if all necessary configuration options are
2908 * specified and set.
2911 private function check_config_options()
2913 if(!isset($this->cfg->page_title) || $this->cfg->page_title == "")
2914 $this->_error("Please set \$page_title in phpfspot_cfg");
2916 if(!isset($this->cfg->base_path) || $this->cfg->base_path == "")
2917 $this->_error("Please set \$base_path in phpfspot_cfg");
2919 if(!isset($this->cfg->web_path) || $this->cfg->web_path == "")
2920 $this->_error("Please set \$web_path in phpfspot_cfg");
2922 if(!isset($this->cfg->thumb_path) || $this->cfg->thumb_path == "")
2923 $this->_error("Please set \$thumb_path in phpfspot_cfg");
2925 if(!isset($this->cfg->smarty_path) || $this->cfg->smarty_path == "")
2926 $this->_error("Please set \$smarty_path in phpfspot_cfg");
2928 if(!isset($this->cfg->fspot_db) || $this->cfg->fspot_db == "")
2929 $this->_error("Please set \$fspot_db in phpfspot_cfg");
2931 if(!isset($this->cfg->db_access) || $this->cfg->db_access == "")
2932 $this->_error("Please set \$db_access in phpfspot_cfg");
2934 if(!isset($this->cfg->phpfspot_db) || $this->cfg->phpfspot_db == "")
2935 $this->_error("Please set \$phpfspot_db in phpfspot_cfg");
2937 if(!isset($this->cfg->thumb_width) || $this->cfg->thumb_width == "")
2938 $this->_error("Please set \$thumb_width in phpfspot_cfg");
2940 if(!isset($this->cfg->thumb_height) || $this->cfg->thumb_height == "")
2941 $this->_error("Please set \$thumb_height in phpfspot_cfg");
2943 if(!isset($this->cfg->photo_width) || $this->cfg->photo_width == "")
2944 $this->_error("Please set \$photo_width in phpfspot_cfg");
2946 if(!isset($this->cfg->mini_width) || $this->cfg->mini_width == "")
2947 $this->_error("Please set \$mini_width in phpfspot_cfg");
2949 if(!isset($this->cfg->thumbs_per_page))
2950 $this->_error("Please set \$thumbs_per_page in phpfspot_cfg");
2952 if(!isset($this->cfg->path_replace_from) || $this->cfg->path_replace_from == "")
2953 $this->_error("Please set \$path_replace_from in phpfspot_cfg");
2955 if(!isset($this->cfg->path_replace_to) || $this->cfg->path_replace_to == "")
2956 $this->_error("Please set \$path_replace_to in phpfspot_cfg");
2958 if(!isset($this->cfg->hide_tags))
2959 $this->_error("Please set \$hide_tags in phpfspot_cfg");
2961 if(!isset($this->cfg->theme_name))
2962 $this->_error("Please set \$theme_name in phpfspot_cfg");
2964 if(!isset($this->cfg->logging))
2965 $this->_error("Please set \$logging in phpfspot_cfg");
2967 if(isset($this->cfg->logging) && $this->cfg->logging == 'logfile') {
2969 if(!isset($this->cfg->log_file))
2970 $this->_error("Please set \$log_file because you set logging = log_file in phpfspot_cfg");
2972 if(!is_writeable($this->cfg->log_file))
2973 $this->_error("The specified \$log_file ". $log_file ." is not writeable!");
2977 /* remove trailing slash, if set */
2978 if($this->cfg->web_path == "/")
2979 $this->cfg->web_path = "";
2980 elseif(preg_match('/\/$/', $this->cfg->web_path))
2981 $this->cfg->web_path = preg_replace('/\/$/', '', $this->cfg->web_path);
2983 return $this->runtime_error;
2985 } // check_config_options()
2988 * cleanup phpfspot own database
2990 * When photos are getting delete from F-Spot, there will remain
2991 * remain some residues in phpfspot own database. This function
2992 * will try to wipe them out.
2994 public function cleanup_phpfspot_db()
2996 $to_delete = Array();
2998 $result = $this->cfg_db->db_query("
3001 ORDER BY img_idx ASC
3004 while($row = $this->cfg_db->db_fetch_object($result)) {
3005 if(!$this->db->db_fetchSingleRow("
3008 WHERE id='". $row['img_idx'] ."'")) {
3010 array_push($to_delete, $row['img_idx'], ',');
3014 print count($to_delete) ." unnecessary objects will be removed from phpfspot's database.\n";
3016 $this->cfg_db->db_exec("
3018 WHERE img_idx IN (". implode($to_delete) .")
3021 } // cleanup_phpfspot_db()
3024 * return first image of the page, the $current photo
3027 * this function is used to find out the first photo of the
3028 * current page, in which the $current photo lies. this is
3029 * used to display the correct photo, when calling showPhotoIndex()
3031 * @param integer $current
3032 * @param integer $max
3035 private function getCurrentPage($current, $max)
3037 if(isset($this->cfg->thumbs_per_page) && !empty($this->cfg->thumbs_per_page)) {
3038 for($page_start = 0; $page_start <= $max; $page_start+=$this->cfg->thumbs_per_page) {
3039 if($current >= $page_start && $current < ($page_start+$this->cfg->thumbs_per_page))
3045 } // getCurrentPage()
3050 * this function tries to find out the correct mime-type
3051 * for the provided file.
3052 * @param string $file
3055 public function get_mime_info($file)
3057 $details = getimagesize($file);
3059 /* if getimagesize() returns empty, try at least to find out the
3062 if(empty($details) && function_exists('mime_content_type')) {
3064 // mime_content_type is marked as deprecated in the documentation,
3065 // but is it really necessary to force users to install a PECL
3067 $details['mime'] = mime_content_type($file);
3070 return $details['mime'];
3072 } // get_mime_info()
3075 * return tag-name by tag-idx
3077 * this function returns the tag-name for the requested
3078 * tag specified by tag-idx.
3079 * @param integer $idx
3082 public function get_tag_name($idx)
3084 if($result = $this->db->db_fetchSingleRow("
3088 id LIKE '". $idx ."'")) {
3090 return $result['name'];
3099 * parse user friendly url which got rewritten by the websever
3100 * @param string $request_uri
3103 private function parse_user_friendly_url($request_uri)
3105 if(preg_match('/\/photoview\/|\/photo\/|\/tag\//', $request_uri)) {
3107 unset($_SESSION['start_action']);
3108 unset($_SESSION['selected_tags']);
3110 $options = explode('/', $request_uri);
3112 switch($options[1]) {
3114 if(is_numeric($options[2])) {
3115 $_GET['mode'] = 'showp';
3116 return $this->showPhoto($options[2]);
3120 if(is_numeric($options[2])) {
3121 require_once "phpfspot_img.php";
3122 $img = new PHPFSPOT_IMG;
3123 if(isset($options[3]) && is_numeric($options[3]))
3124 $img->showImg($options[2], $options[3]);
3126 $img->showImg($options[2]);
3131 if(is_numeric($options[2])) {
3132 $_GET['tags'] = $options[2];
3133 $_SESSION['selected_tags'] = Array($options[2]);
3134 return $this->showPhotoIndex();
3140 } // parse_user_friendly_url()
3143 * check if user-friendly-urls are enabled
3145 * this function will return true, if the config option
3146 * $user_friendly_url has been set. Otherwise false.
3149 private function is_user_friendly_url()
3151 if(isset($this->cfg->user_friendly_url) && $this->cfg->user_friendly_url)
3156 } // is_user_friendly_url()