Changeset 420 for trunk/comments.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/comments.php (modified) (4 diffs)

trunk/comments.php

@@ -92 +92 @@
 
 foreach ( $conf['last_days'] as $option ) {
-  $url = $PHP_SELF.'?last_days='.($option - 1);
+  $url = $_SERVER['PHP_SELF'].'?last_days='.($option - 1);
   if (defined('IN_ADMIN')) $url.= '&page=comments';
-  $template->assign_block_vars('last_day_option', array (
-    'OPTION'=>$option,
-        'T_STYLE'=>(( $option == MAX_DAYS + 1 )?'text-decoration:underline;':''),
-        'U_OPTION'=>add_session_id( $url )
-        ));
+  $template->assign_block_vars(
+    'last_day_option',
+    array(
+      'OPTION'=>$option,
+      'T_STYLE'=>(( $option == MAX_DAYS + 1 )?'text-decoration:underline;':''),
+      'U_OPTION'=>add_session_id( $url )
+      )
+    );
 }
 
@@ -110 +113 @@
 $query.= ', '.IMAGE_CATEGORY_TABLE.' AS ic';
 $query.= ' WHERE c.image_id = ic.image_id';
-$query.= ' AND date > '.$maxtime;
+$query.= ' AND date > FROM_UNIXTIME('.$maxtime.')';
 if ( $user['status'] != 'admin' )
 {
@@ -174 +177 @@
     $query = 'SELECT * FROM '.COMMENTS_TABLE;
     $query.= ' WHERE image_id = '.$row['image_id'];
-    $query.= ' AND date > '.$maxtime;
+    $query.= ' AND date > FROM_UNIXTIME('.$maxtime.')';
         if ( $user['status'] != 'admin' )
     {
@@ -202 +205 @@
       $replacement = '<span style="font-style:italic;">\1</span>';
       $content = preg_replace( $pattern, $replacement, $content );
-      $template->assign_block_vars('picture.comment',array(
-            'COMMENT_AUTHOR'=>$author,
-                'COMMENT_DATE'=>format_date( $subrow['date'], 'unix', true ),
-                'COMMENT'=>$content,
-                ));
-                if ( $user['status'] == 'admin' )
-                {
-                  $template->assign_block_vars('picture.comment.validation', array(
-                    'ID'=> $subrow['id'],
-                        'CHECKED'=>($subrow['validated']=='false')?'checked="checked"': ''
-                        ));
-                }
+      $template->assign_block_vars(
+        'picture.comment',array(
+          'COMMENT_AUTHOR'=>$author,
+          'COMMENT_DATE'=>format_date( $subrow['date'],'mysql_datetime',true ),
+          'COMMENT'=>$content,
+          ));
+      if ( $user['status'] == 'admin' )
+      {
+        $template->assign_block_vars(
+          'picture.comment.validation', array(
+            'ID'=> $subrow['id'],
+            'CHECKED'=>($subrow['validated']=='false')?'checked="checked"': ''
+            ));
+      }
     }
   }