- new feature : RSS notification feed. Feed generator is an external tool

  (FeedCreator class v1.7.2). New file feed.php

- new database field : comments.validation_date (datetime). This field is
  required for notification feed.

- new database field : users.feed_id (varchar(50)). users.feed_id is an
  alias of users.id but is much more complicated to find (50 characters,
  figures or letters, case sensitive) : the purpose is to keep it secret (as
  far as possible).

- new database field : users.last_feed_check (datetime)

- new database field : users.registration_date (datetime)

- bug fixed : no need to add the (unavailable) session id to install.php in
  the installation form.

- modified database field : images.date_available become more precise (date
  to datetime). This precision is needed for notification feed.

- new index : comments_i1 (validation_date). Might be useful for feed
  queries.

- new index : comments_i2 (image_id). Useful each time you want to have
  informations about an element and its associated comments.

- version 9.11 of mysqldump outputs database field names and table names
  with backquote "`" (didn't find how to take them off)


git-svn-id: http://piwigo.org/svn/trunk@801 68402e56-0260-453c-a942-63ccdbb3a9ee

3 files changed, 7 insertions, 3 deletions

diff --git a/admin/picture_modify.php b/admin/picture_modify.php
index 64d6cf04b..532f5aeee 100644
--- a/admin/picture_modify.php
+++ b/admin/picture_modify.php
@@ -180,7 +180,8 @@ $template->assign_vars(array(
   'NAME_IMG'=>isset($_POST['name'])?$_POST['name']:@$row['name'],
   'SIZE_IMG'=>@$row['width'].' * '.@$row['height'],
   'FILESIZE_IMG'=>@$row['filesize'].' KB',
-  'REGISTRATION_DATE_IMG'=> format_date($row['date_available']),
+  'REGISTRATION_DATE_IMG'
+  => format_date($row['date_available'], 'mysql_datetime', true),
   'AUTHOR_IMG'=>isset($_POST['author'])?$_POST['author']:@$row['author'],
   'CREATION_DATE_IMG'=>$date,
   'KEYWORDS_IMG'=>isset($_POST['keywords'])?$_POST['keywords']:@$row['keywords'],
diff --git a/admin/remote_site.php b/admin/remote_site.php
index ba8dc67ce..774358ddf 100644
--- a/admin/remote_site.php
+++ b/admin/remote_site.php
@@ -31,7 +31,8 @@ if (!defined('PHPWG_ROOT_PATH'))
 }
 include_once(PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php');
 
-define('CURRENT_DATE', date('Y-m-d'));
+list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+define('CURRENT_DATE', $dbnow);
 // +-----------------------------------------------------------------------+
 // |                               functions                               |
 // +-----------------------------------------------------------------------+
diff --git a/admin/update.php b/admin/update.php
index bfc3236fc..b0e26a3f7 100644
--- a/admin/update.php
+++ b/admin/update.php
@@ -31,7 +31,9 @@ if (!defined('PHPWG_ROOT_PATH'))
 }
 include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php');
 
-define('CURRENT_DATE', date('Y-m-d'));
+list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+define('CURRENT_DATE', $dbnow);
+
 $error_labels = array('PWG-UPDATE-1' => $lang['update_wrong_dirname_short'],
                       'PWG-UPDATE-2' => $lang['update_missing_tn_short']);
 $errors = array();