Changeset 1059 for trunk/admin/rating.php

Timestamp:

Feb 28, 2006, 5:28:06 AM (18 years ago)

Author:

rvelices

Message:

calendar improvements: week on weekly list starts on Monday,
ability to show grayed months/weeks/days (without any picture in it),
added icons for created/posted fields
language uniformization

calendar fixes: correct number of pictures in calendar view,
code simplification (I hope so)

File:

• trunk/admin/rating.php (modified) (7 diffs, 1 prop)

trunk/admin/rating.php

@@ -115 +115 @@
 
 
-$query = 'SELECT COUNT(DISTINCT(i.id)) 
+$query = 'SELECT COUNT(DISTINCT(i.id))
 FROM '.RATE_TABLE.' AS r, '.IMAGES_TABLE.' AS i
 WHERE r.element_id=i.id'. $display_filter .
@@ -147 +147 @@
 $available_order_by= array(
     array(l10n('Rate date'), 'recently_rated DESC'),
-    array(l10n('Average rate'), 'average_rate DESC'), 
-    array(l10n('Number of rates'), 'nb_rates DESC'), 
-    array(l10n('Sum of rates'), 'sum_rates DESC'), 
-    array(l10n('Controversy'), 'std_rates DESC'), 
-    array(l10n('File name'), 'file DESC'), 
+    array(l10n('Average rate'), 'average_rate DESC'),
+    array(l10n('Number of rates'), 'nb_rates DESC'),
+    array(l10n('Sum of rates'), 'sum_rates DESC'),
+    array(l10n('Controversy'), 'std_rates DESC'),
+    array(l10n('File name'), 'file DESC'),
     array(l10n('Creation date'), 'date_creation DESC'),
-    array(l10n('Availability date'), 'date_available DESC'),
+    array(l10n('Post date'), 'date_available DESC'),
 
   );
@@ -169 +169 @@
 }
 
-$query = 'SELECT i.id, i.path, i.file, i.tn_ext, i.average_rate, i.storage_category_id, 
-          MAX(r.date) as recently_rated, COUNT(r.rate) as nb_rates, 
-          SUM(r.rate) as sum_rates, ROUND(STD(r.rate),2) as std_rates 
+$query = 'SELECT i.id, i.path, i.file, i.tn_ext, i.average_rate, i.storage_category_id,
+          MAX(r.date) as recently_rated, COUNT(r.rate) as nb_rates,
+          SUM(r.rate) as sum_rates, ROUND(STD(r.rate),2) as std_rates
 FROM '.RATE_TABLE.' AS r LEFT JOIN '.IMAGES_TABLE.' AS i
 ON r.element_id=i.id
@@ -196 +196 @@
                 'cat=' . $image['storage_category_id'].
                 '&image_id=' . $image['id'];
-    
+
   $query = 'SELECT *
 FROM '.RATE_TABLE.' AS r
@@ -204 +204 @@
   $nb_rates = mysql_num_rows($result);
 
-  $template->assign_block_vars('image', 
+  $template->assign_block_vars('image',
      array(
        'U_THUMB' => $thumbnail_src,
@@ -223 +223 @@
     $url_del = PHPWG_ROOT_PATH.'admin.php'.
                 get_query_string_diff(array('del'));
-    
+
     $del_param = 'e='.$image['id'].
                  '&u='.$row['user_id'].
                  '&a='.$row['anonymous_id'];
-    
+
     $url_del .= '&del='.urlencode(urlencode($del_param));
 
@@ -242 +242 @@
       $user .= '('.$row['anonymous_id'].')';
     }
-    
-    $template->assign_block_vars('image.rate', 
+
+    $template->assign_block_vars('image.rate',
        array(
          'DATE' => format_date($row['date']),