show additional infos in the image preview bubble

[phpfspot.git] / phpfspot.class.php

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 27a0079e30936f194877c3cd582530dedf4e3a8c..ab5cb9e12c165ab9b34dc3fd0349e9f216146e44 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -176,14 +176,20 @@ class PHPFSPOT {
          $selected = substr($selected, 0, strlen($selected)-1);
          $result = $this->db->db_query("
             SELECT DISTINCT photo_id
-            FROM photo_tags
-            WHERE tag_id IN (". $selected .")
+               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
+               FROM photo_tags pt
+            INNER JOIN photos p
+               ON p.id=pt.photo_id
+            ORDER BY p.time ASC
          ");
       }
 
@@ -233,6 +239,32 @@ class PHPFSPOT {
 
    } // showPhotoIndex()
 
+   public function showBubbleDetails($photo, $direction)
+   {
+      if($direction == "up")
+         $direction = "bubbleimg_up";
+      else
+         $direction = "bubbleimg_down";
+
+      $details = $this->get_photo_details($photo);
+
+      $image_url = "phpfspot_img.php?idx=". $photo ."&width=200";
+
+      $filesize = filesize($this->translate_path($details['directory_path'])  ."/". $details['name']);
+      $filesize = rand($filesize/1024, 2);
+
+      $img = getimagesize($this->translate_path($details['directory_path'])  ."/". $details['name']);
+
+      $this->tmpl->assign('file_size', $filesize);
+      $this->tmpl->assign('width', $img[0]);
+      $this->tmpl->assign('height', $img[1]);
+      $this->tmpl->assign('file_name', $details['name']);
+      $this->tmpl->assign('image_id', $direction);
+      $this->tmpl->assign('image_url', $image_url);
+      $this->tmpl->show("bubble_details.tpl");
+
+   }
+
 }
 
 ?>