Changeset 9073

Timestamp:

Feb 3, 2011, 9:18:38 AM (14 years ago)

Author:

plg

Message:

bug 270 fixed: (yes "270", submitted in 2006), time (hour:minute:second) added
in the date_creation field and in the synchronization from EXIF metadata.

Location:

trunk

Files:

• admin/include/functions_metadata.php (modified) (1 diff)
• install/db/96-database.php (added)
• install/piwigo_structure-mysql.sql (modified) (1 diff)
• picture.php (modified) (1 diff)

trunk/admin/include/functions_metadata.php

@@ -90 +90 @@
     if (in_array($pwg_key, array('date_creation', 'date_available')))
     {
-      if (preg_match('/^(\d{4}).(\d{2}).(\d{2})/', $value, $matches))
+      if (preg_match('/^(\d{4}).(\d{2}).(\d{2}) (\d{2}).(\d{2}).(\d{2})/', $value, $matches))
+      {
+        $exif[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3].' '.$matches[4].':'.$matches[5].':'.$matches[6];
+      }
+      elseif (preg_match('/^(\d{4}).(\d{2}).(\d{2})/', $value, $matches))
       {
         $exif[$pwg_key] = $matches[1].'-'.$matches[2].'-'.$matches[3];

trunk/install/piwigo_structure-mysql.sql

@@ -177 +177 @@
   `file` varchar(255) binary NOT NULL default '',
   `date_available` datetime NOT NULL default '0000-00-00 00:00:00',
-  `date_creation` date default NULL,
+  `date_creation` datetime default NULL,
   `tn_ext` varchar(4) default '',
   `name` varchar(255) default NULL,

trunk/picture.php

@@ -860 +860 @@
       'chronology_style'=>'monthly',
       'chronology_view'=>'list',
-      'chronology_date' => explode('-', $picture['current']['date_creation'])
+      'chronology_date' => explode('-', substr($picture['current']['date_creation'], 0, 10))
       )
     );