X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=phpfspot.git;a=blobdiff_plain;f=phpfspot.class.php;h=d62be697f2c0677878dff847f7e72edb255d846c;hp=27a0079e30936f194877c3cd582530dedf4e3a8c;hb=dac334b46e3f2d939f8d106b98dc82a102e72423;hpb=415b51224f80a7ac111ffc2ad09f298849fcca4d

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 27a0079..d62be69 100644
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -8,6 +8,7 @@ class PHPFSPOT {
 
    var $cfg;
    var $db;
+   var $cfg_db;
    var $tmpl;
    var $tags;
    var $avail_tags;
@@ -17,7 +18,11 @@ class PHPFSPOT {
    {
       $this->cfg = new PHPFSPOT_CFG;
 
-      $this->db = new PHPFSPOT_DB(&$this, $this->cfg->db);
+      $this->db = new PHPFSPOT_DB(&$this, $this->cfg->fspot_db);
+
+      $this->cfg_db = new PHPFSPOT_DB(&$this, $this->cfg->phpfspot_db);
+      $this->check_config_table();
+
       $this->tmpl = new PHPFSPOT_TMPL($this);
 
       $this->get_tags();
@@ -98,9 +103,18 @@ class PHPFSPOT {
          }
       }
 
-      if(isset($photo)) {
-         $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width);
-      }
+
+      $details = $this->get_photo_details($photo);
+      $meta = $this->get_meta_informations($this->translate_path($details['directory_path']) ."/". $details['name']);
+      $info = getimagesize($this->translate_path($details['directory_path']) ."/thumbs/". $this->cfg->photo_width ."_". $details['name']);
+
+      $this->tmpl->assign('width', $info[0]);
+      $this->tmpl->assign('height', $info[1]);
+      $this->tmpl->assign('c_date', $meta['DateTime']);
+      $this->tmpl->assign('madewith', $meta['Make'] ." ". $meta['Model']);
+      $this->tmpl->assign('image_name', $details['name']);
+      $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);
 
       if($previous_img) {
          $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");");
@@ -176,14 +190,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 +253,113 @@ 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");
+
+   } // showBubbleDetails()
+
+   public function showCredits()
+   {
+      $this->tmpl->assign('version', $this->cfg->version);
+      $this->tmpl->assign('product', $this->cfg->product);
+      $this->tmpl->show("credits.tpl");
+
+   } // showCredits()
+
+   public function resize_image($image, $width)
+   {  
+      // if thumbnail already exists, don't recreate it
+      if(file_exists(dirname($image) ."/thumbs/". $width ."_". basename($image)))
+         return;
+
+      $src_img = @imagecreatefromjpeg($image);
+
+      if($src_img)
+      {  
+         /* grabs the height and width */
+         $new_w = imagesx($src_img);
+         $new_h = imagesy($src_img);
+
+         // If requested width is more then the actual image width,
+         // do not generate a thumbnail
+
+         if($width >= $new_w) {
+            imagedestroy($src_img);
+            return;
+         }
+
+         /* calculates aspect ratio */
+         $aspect_ratio = $new_h / $new_w;
+
+         /* sets new size */
+         $new_w = $width;
+         $new_h = abs($new_w * $aspect_ratio);
+
+         /* creates new image of that size */
+         $dst_img = imagecreatetruecolor($new_w,$new_h);
+
+         imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255));
+
+         /* copies resized portion of original image into new image */
+         imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));
+
+         /* write down new generated file */
+
+         if(!file_exists(dirname($image) ."/thumbs"))
+            mkdir(dirname($image) ."/thumbs");
+
+         $newfile = dirname($image) ."/thumbs/". $width ."_". basename($image);
+         imagejpeg($dst_img, $newfile, 75);
+
+         /* free your mind */
+         imagedestroy($dst_img);
+         imagedestroy($src_img);
+      }
+
+   } // resize_image()
+
+   public function get_meta_informations($file)
+   {
+
+      return exif_read_data($file);
+
+   } // get_meta_informations()
+
+   public function check_config_table()
+   {
+      // if the config table doesn't exist yet, create it
+      if(!$this->cfg_db->db_check_table_exists("images")) {
+         $this->cfg_db->db_exec("
+            CREATE TABLE images (
+               img_idx int primary key,
+               img_md5 varchar(32)
+            )
+            ");
+      }
+
+   } // check_config_table
+
 }
 
 ?>