3 require_once "phpfspot_cfg.php";
4 require_once "phpfspot_db.php";
5 require_once "phpfspot_tmpl.php";
17 public function __construct()
19 $this->cfg = new PHPFSPOT_CFG;
21 $this->db = new PHPFSPOT_DB(&$this, $this->cfg->fspot_db);
23 $this->cfg_db = new PHPFSPOT_DB(&$this, $this->cfg->phpfspot_db);
24 $this->check_config_table();
26 $this->tmpl = new PHPFSPOT_TMPL($this);
32 if(!isset($_SESSION['tag_condition']))
33 $_SESSION['tag_condition'] = 'or';
35 if(!isset($_SESSION['searchfor']))
36 $_SESSION['searchfor'] = '';
40 public function __destruct()
45 public function show()
47 $this->tmpl->assign('searchfor', $_SESSION['searchfor']);
48 $this->tmpl->assign('page_title', $this->cfg->page_title);
49 $this->tmpl->assign('current_condition', $_SESSION['tag_condition']);
50 $this->tmpl->show("index.tpl");
54 private function get_tags()
56 $this->avail_tags = Array();
59 $result = $this->db->db_query("
62 ORDER BY sort_priority ASC
65 while($row = $this->db->db_fetch_object($result)) {
68 $tag_name = $row['name'];
70 /* check if config requests to ignore this tag */
71 if(in_array($row['name'], $this->cfg->hide_tags))
74 $this->tags[$tag_id] = $tag_name;
75 $this->avail_tags[$count] = $tag_id;
83 public function get_photo_details($idx)
85 $result = $this->db->db_query("
91 return $this->db->db_fetch_object($result);
93 } // get_photo_details
95 public function translate_path($path, $width = 0)
97 return str_replace($this->cfg->path_replace_from, $this->cfg->path_replace_to, $path);
101 public function showPhoto($photo)
103 $all_photos = $this->getPhotoSelection();
105 foreach($all_photos as $all_photo) {
108 $next_img = $all_photo;
112 if($all_photo == $photo) {
116 $previous_img = $all_photo;
121 $details = $this->get_photo_details($photo);
122 $meta = $this->get_meta_informations($this->translate_path($details['directory_path']) ."/". $details['name']);
123 $info = getimagesize($this->translate_path($details['directory_path']) ."/thumbs/". $this->cfg->photo_width ."_". $details['name']);
125 $this->tmpl->assign('width', $info[0]);
126 $this->tmpl->assign('height', $info[1]);
127 $this->tmpl->assign('c_date', $meta['DateTime']);
128 $this->tmpl->assign('madewith', $meta['Make'] ." ". $meta['Model']);
129 $this->tmpl->assign('image_name', $details['name']);
130 $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width);
131 $this->tmpl->assign('image_url_full', 'phpfspot_img.php?idx='. $photo);
134 $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");");
138 $this->tmpl->assign('next_url', "javascript:showImage(". $next_img .");");
141 $this->tmpl->show("single_photo.tpl");
145 public function getAvailableTags()
147 foreach($this->avail_tags as $tag)
149 if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags']))
152 // return all available (= not selected) tags
153 print "<a href=\"javascript:Tags('add', ". $tag .");\">". $this->tags[$tag] ."</a> ";
157 } // getAvailableTags()
159 public function getSelectedTags()
161 foreach($this->avail_tags as $tag)
163 // return all selected tags
164 if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags'])) {
165 print "<a href=\"javascript:Tags('del', ". $tag .");\">". $this->tags[$tag] ."</a> ";
170 } // getSelectedTags()
172 public function addTag($tag)
174 if(!isset($_SESSION['selected_tags']))
175 $_SESSION['selected_tags'] = Array();
177 array_push($_SESSION['selected_tags'], $tag);
181 public function delTag($tag)
183 if(isset($_SESSION['selected_tags'])) {
184 $key = array_search($tag, $_SESSION['selected_tags']);
185 unset($_SESSION['selected_tags'][$key]);
190 public function resetTags()
192 unset($_SESSION['selected_tags']);
196 public function getPhotoSelection()
198 $tagged_photos = Array();
200 if(isset($_SESSION['selected_tags'])) {
202 foreach($_SESSION['selected_tags'] as $tag)
203 $selected.= $tag .",";
204 $selected = substr($selected, 0, strlen($selected)-1);
206 if($_SESSION['tag_condition'] == 'or') {
207 $result = $this->db->db_query("
208 SELECT DISTINCT photo_id
212 WHERE pt.tag_id IN (". $selected .")
215 while($row = $this->db->db_fetch_object($result)) {
216 array_push($tagged_photos, $row['photo_id']);
219 elseif($_SESSION['tag_condition'] == 'and') {
220 $result = $this->db->db_query("
221 SELECT DISTINCT photo_id, tag_id
225 WHERE pt.tag_id IN (". $selected .")
229 /* now we need to check if each object fulfills the condition
230 and has all the selected tags assigned
232 $match_object = Array();
233 $matches_needed = count($_SESSION['selected_tags']);
234 while($row = $this->db->db_fetch_object($result)) {
235 /* set the counter for this object */
236 if(!isset($match_object[$row['photo_id']]))
237 $match_object[$row['photo_id']] = $matches_needed;
239 /* we have a match? decrement the counter */
240 if(in_array($row['tag_id'], $_SESSION['selected_tags']))
241 $match_object[$row['photo_id']]--;
243 /* if the object has all necessary tags, add it to the result */
244 if($match_object[$row['photo_id']] == 0)
245 array_push($tagged_photos, $row['photo_id']);
250 $result = $this->db->db_query("
251 SELECT DISTINCT photo_id
257 while($row = $this->db->db_fetch_object($result)) {
258 array_push($tagged_photos, $row['photo_id']);
262 return $tagged_photos;
264 } // getPhotoSelection()
266 public function showPhotoIndex()
268 if($_SESSION['searchfor'] == '')
269 $photos = $this->getPhotoSelection();
271 $photos = $this->getSearchResult($_SESSION['searchfor']);
273 $count = count($photos);
277 $images[$rows] = Array();
279 for($i = 0; $i < $count; $i++) {
281 $images[$rows][$cols] = $photos[$i];
283 if($cols == $this->cfg->thumbs_per_row-1) {
286 $images[$rows] = Array();
293 // +1 for for smarty's selection iteration
296 //$images.= "<img src=\"phpfspot_img.php?idx=". $photo ."&width=". $this->cfg->thumb_width ."\" /><br />\n";
298 $this->tmpl->assign('count', $count);
299 $this->tmpl->assign('width', $this->cfg->thumb_width);
300 $this->tmpl->assign('images', $images);
301 $this->tmpl->assign('rows', $rows);
302 $this->tmpl->assign('columns', $this->cfg->thumbs_per_row);
303 $this->tmpl->show("photo_index.tpl");
306 } // showPhotoIndex()
308 public function showBubbleDetails($photo, $direction)
310 if($direction == "up")
311 $direction = "bubbleimg_up";
313 $direction = "bubbleimg_down";
315 $details = $this->get_photo_details($photo);
317 $image_url = "phpfspot_img.php?idx=". $photo ."&width=". $this->cfg->bubble_width;
319 $filesize = filesize($this->translate_path($details['directory_path']) ."/". $details['name']);
320 $filesize = rand($filesize/1024, 2);
322 $img = getimagesize($this->translate_path($details['directory_path']) ."/". $details['name']);
324 $this->tmpl->assign('file_size', $filesize);
325 $this->tmpl->assign('width', $img[0]);
326 $this->tmpl->assign('height', $img[1]);
327 $this->tmpl->assign('file_name', $details['name']);
328 $this->tmpl->assign('image_id', $direction);
329 $this->tmpl->assign('image_url', $image_url);
330 $this->tmpl->show("bubble_details.tpl");
332 } // showBubbleDetails()
334 public function showCredits()
336 $this->tmpl->assign('version', $this->cfg->version);
337 $this->tmpl->assign('product', $this->cfg->product);
338 $this->tmpl->show("credits.tpl");
342 public function create_thumbnail($image, $width)
344 // if thumbnail already exists, don't recreate it
345 if(file_exists(dirname($image) ."/thumbs/". $width ."_". basename($image)))
348 $src_img = @imagecreatefromjpeg($image);
352 /* grabs the height and width */
353 $new_w = imagesx($src_img);
354 $new_h = imagesy($src_img);
356 // If requested width is more then the actual image width,
357 // do not generate a thumbnail
359 if($width >= $new_w) {
360 imagedestroy($src_img);
364 /* calculates aspect ratio */
365 $aspect_ratio = $new_h / $new_w;
369 $new_h = abs($new_w * $aspect_ratio);
371 /* creates new image of that size */
372 $dst_img = imagecreatetruecolor($new_w,$new_h);
374 imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255));
376 /* copies resized portion of original image into new image */
377 imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));
379 /* write down new generated file */
381 if(!file_exists(dirname($image) ."/thumbs"))
382 mkdir(dirname($image) ."/thumbs");
384 $newfile = dirname($image) ."/thumbs/". $width ."_". basename($image);
385 imagejpeg($dst_img, $newfile, 75);
388 imagedestroy($dst_img);
389 imagedestroy($src_img);
392 } // create_thumbnail()
394 public function get_meta_informations($file)
397 return exif_read_data($file);
399 } // get_meta_informations()
401 public function check_config_table()
403 // if the config table doesn't exist yet, create it
404 if(!$this->cfg_db->db_check_table_exists("images")) {
405 $this->cfg_db->db_exec("
406 CREATE TABLE images (
407 img_idx int primary key,
413 } // check_config_table
415 public function gen_thumbs($idx = 0, $fromcmd = 0)
418 /* get all available photos */
419 $all = $this->getPhotoSelection();
424 foreach($all as $photo) {
426 $details = $this->get_photo_details($photo);
428 $full_path = $this->translate_path($details['directory_path']) ."/". $details['name'];
429 $file_md5 = md5_file($full_path);
431 if($fromcmd) print "Image ". $details['name'] ." Thumbnails:";
433 /* if the file hasn't changed there is no need to regen the thumb */
434 if($file_md5 == $this->getMD5($photo)) {
435 if($fromcmd) print " file has not changed - skipping\n";
439 /* set the new/changed MD5 sum for the current photo */
440 $this->setMD5($photo, $file_md5);
442 $resolutions = Array(
443 $this->cfg->thumb_width,
444 $this->cfg->bubble_width,
445 $this->cfg->photo_width
448 /* create thumbnails for the requested resolutions */
449 foreach($resolutions as $resolution) {
450 if($fromcmd) print " ". $resolution ."px";
451 $this->create_thumbnail($full_path, $resolution);
454 if($fromcmd) print "\n";
460 private function getMD5($idx)
462 $result = $this->cfg_db->db_query("
465 WHERE img_idx='". $idx ."'
471 $img = $this->cfg_db->db_fetch_object($result);
472 return $img['img_md5'];
476 private function setMD5($idx, $md5)
478 $result = $this->cfg_db->db_exec("
479 REPLACE INTO images (img_idx, img_md5)
480 VALUES ('". $idx ."', '". $md5 ."')
485 public function setTagCondition($mode)
487 $_SESSION['tag_condition'] = $mode;
489 } // setTagCondition()
491 public function startSearch($searchfor)
493 $_SESSION['searchfor'] = $searchfor;
495 } // showSearchResult()
497 public function getSearchResult($for)
499 $tagged_photos = Array();
501 $result = $this->db->db_query("
502 SELECT DISTINCT photo_id
508 WHERE t.name LIKE '%". $for ."%'
512 while($row = $this->db->db_fetch_object($result)) {
513 array_push($tagged_photos, $row['photo_id']);
516 return $tagged_photos;
518 } // getSearchResult()