general function to check if a table exists
[phpfspot.git] / phpfspot.class.php
index 641cc0efbd215feb6d8fb08473e4340837b3f69b..d62be697f2c0677878dff847f7e72edb255d846c 100644 (file)
@@ -19,7 +19,10 @@ class PHPFSPOT {
       $this->cfg = new PHPFSPOT_CFG;
 
       $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();
@@ -102,9 +105,16 @@ class PHPFSPOT {
 
 
       $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 .");");
@@ -329,6 +339,27 @@ class PHPFSPOT {
 
    } // 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
+
 }
 
 ?>