Changeset 801 for trunk/picture.php

Timestamp:

Jul 16, 2005, 4:29:35 PM (19 years ago)

Author:

plg

Message:

• 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)

File:

• trunk/picture.php (modified) (2 diffs)

trunk/picture.php

@@ -343 +343 @@
          or $conf['anti-flood_time'] == 0 )
     {
-      $query = 'INSERT INTO '.COMMENTS_TABLE;
-      $query.= ' (author,date,image_id,content,validated) VALUES (';
-      $query.= "'".$author."'";
-      $query.= ',NOW(),'.$_GET['image_id'];
-      $query.= ",'".htmlspecialchars( $_POST['content'], ENT_QUOTES)."'";
-      if ( !$conf['comments_validation'] or $user['status'] == 'admin' )
-      {        
-        $query.= ",'true'";
+      list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+
+      $data = array();
+      $data{'author'} = $author;
+      $data{'date'} = $dbnow;
+      $data{'image_id'} = $_GET['image_id'];
+      $data{'content'} = htmlspecialchars( $_POST['content'], ENT_QUOTES);
+      
+      if (!$conf['comments_validation'] or $user['status'] == 'admin')
+      {
+        $data{'validated'} = 'true';
+        $data{'validation_date'} = $dbnow;
       }
       else
       {
-        $query.= ",'false'";
+        $data{'validated'} = 'false';
       }
-      $query.= ');';
-      pwg_query( $query );
+      
+      include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
+      $fields = array('author', 'date', 'image_id', 'content', 'validated',
+                      'validation_date');
+      mass_inserts(COMMENTS_TABLE, $fields, array($data));
+      
       // information message
       $message = $lang['comment_added'];
+
+      if (!$conf['comments_validation'] or $user['status'] == 'admin')
+      
       if ( $conf['comments_validation'] and $user['status'] != 'admin' )
       {
@@ -480 +491 @@
 
 // date of availability
-$availability_date = format_date($picture['current']['date_available']);
+$availability_date = format_date($picture['current']['date_available'],
+                                 'mysql_datetime');
 
 // size in pixels