Changeset 420 for trunk/picture.php

Timestamp:

May 20, 2004, 11:22:44 PM (20 years ago)

Author:

z0rglub

Message:

field comments.date becomes a datetime MySQL field type (instead of int)

File:

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

trunk/picture.php

@@ -25 +25 @@
 // | USA.                                                                  |
 // +-----------------------------------------------------------------------+
+
 //----------------------------------------------------------- include
 define('PHPWG_ROOT_PATH','./');
@@ -225 +226 @@
     $reference_date = time() - $conf['anti-flood_time'];
     $query = 'SELECT id FROM '.COMMENTS_TABLE;
-    $query.= ' WHERE date > '.$reference_date;
+    $query.= ' WHERE date > FROM_UNIXTIME('.$reference_date.')';
     $query.= " AND author = '".$author."'";
     $query.= ';';
@@ -234 +235 @@
       $query.= ' (author,date,image_id,content,validated) VALUES (';
       $query.= "'".$author."'";
-      $query.= ','.time().','.$_GET['image_id'];
+      $query.= ',NOW(),'.$_GET['image_id'];
       $query.= ",'".htmlspecialchars( $_POST['content'], ENT_QUOTES)."'";
       if ( !$conf['comments_validation'] or $user['status'] == 'admin' )
@@ -578 +579 @@
     $template->assign_block_vars('comments.comment', array(
     'COMMENT_AUTHOR'=>empty($row['author'])?$lang['guest']:$row['author'],
-    'COMMENT_DATE'=>format_date( $row['date'], 'unix', true ),
+    'COMMENT_DATE'=>format_date( $row['date'], 'mysql_datetime', true ),
         'COMMENT'=>$content
         ));