cfg = new PHPFSPOT_CFG; $this->db = new PHPFSPOT_DB(&$this, $this->cfg->db); $this->tmpl = new PHPFSPOT_TMPL($this); $this->get_tags(); } // __construct() public function __destruct() { } // __destruct() public function show() { $this->tmpl->assign('page_title', $this->cfg->page_title); $this->tmpl->show("index.tpl"); } // show() private function get_tags() { $this->avail_tags = Array(); $count = 0; $result = $this->db->db_query(" SELECT id,name FROM tags ORDER BY sort_priority ASC "); while($row = $this->db->db_fetch_object($result)) { $tag_id = $row['id']; $tag_name = $row['name']; $this->tags[$tag_id] = $tag_name; $this->avail_tags[$count] = $tag_id; $count++; } } // get_tags() public function get_photo_details($idx) { $result = $this->db->db_query(" SELECT * FROM photos WHERE id='". $idx ."' "); return $this->db->db_fetch_object($result); } // get_photo_details public function translate_path($path, $width = 0) { return str_replace($this->cfg->path_replace_from, $this->cfg->path_replace_to, $path); } // translate_path public function showPhoto($photo) { $all_photos = $this->getAllTagPhotos(); foreach($all_photos as $all_photo) { if($get_next) { $next_img = $all_photo; break; } if($all_photo == $photo) { $get_next = 1; } else { $previous_img = $all_photo; } } if(isset($photo)) { $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width); } if($previous_img) { $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");"); } if($next_img) { $this->tmpl->assign('next_url', "javascript:showImage(". $next_img .");"); } $this->tmpl->show("single_photo.tpl"); } // showPhoto() public function getAvailableTags() { foreach($this->avail_tags as $tag) { if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags'])) continue; // return all available (= not selected) tags print "". $this->tags[$tag] ." "; } } // getAvailableTags() public function getSelectedTags() { foreach($this->avail_tags as $tag) { // return all selected tags if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags'])) { print "". $this->tags[$tag] ." "; } } } // getSelectedTags() public function addTag($tag) { if(!isset($_SESSION['selected_tags'])) $_SESSION['selected_tags'] = Array(); array_push($_SESSION['selected_tags'], $tag); } // addTag() public function delTag($tag) { if(isset($_SESSION['selected_tags'])) { $key = array_search($tag, $_SESSION['selected_tags']); unset($_SESSION['selected_tags'][$key]); } } // delTag() public function resetTags() { unset($_SESSION['selected_tags']); } // resetTags() public function getAllTagPhotos() { $tagged_photos = Array(); if(isset($_SESSION['selected_tags'])) { $selected = ""; foreach($_SESSION['selected_tags'] as $tag) $selected.= $tag .","; $selected = substr($selected, 0, strlen($selected)-1); $result = $this->db->db_query(" SELECT DISTINCT photo_id FROM photo_tags pt INNER JOIN photos p ON p.id=pt.photo_id WHERE pt.tag_id IN (". $selected .") ORDER BY p.time ASC "); } else { $result = $this->db->db_query(" SELECT DISTINCT photo_id FROM photo_tags pt INNER JOIN photos p ON p.id=pt.photo_id ORDER BY p.time ASC "); } while($row = $this->db->db_fetch_object($result)) { array_push($tagged_photos, $row['photo_id']); } return $tagged_photos; } // getAllTagPhotos() public function showPhotoIndex() { $photos = $this->getAllTagPhotos(); $count = count($photos); $rows = 0; $cols = 0; $images[$rows] = Array(); for($i = 0; $i < $count; $i++) { $images[$rows][$cols] = $photos[$i]; if($cols == $this->cfg->thumbs_per_row-1) { $cols = 0; $rows++; $images[$rows] = Array(); } else { $cols++; } } // +1 for for smarty's selection iteration $rows++; //$images.= "
\n"; $this->tmpl->assign('count', $count); $this->tmpl->assign('width', $this->cfg->thumb_width); $this->tmpl->assign('images', $images); $this->tmpl->assign('rows', $rows); $this->tmpl->assign('columns', $this->cfg->thumbs_per_row); $this->tmpl->show("photo_index.tpl"); } // showPhotoIndex() } ?>