Changeset 12529 for branches/2.3/admin/rating.php
- Timestamp:
- Oct 28, 2011, 9:38:27 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.3/admin/rating.php
r12255 r12529 132 132 $available_order_by= array( 133 133 array(l10n('Rate date'), 'recently_rated DESC'), 134 134 array(l10n('Rating score'), 'score DESC'), 135 135 array(l10n('Average rate'), 'avg_rates DESC'), 136 136 array(l10n('Number of rates'), 'nb_rates DESC'), … … 163 163 $query = ' 164 164 SELECT i.id, 165 166 167 168 i.rating_scoreAS score,169 170 171 172 165 i.path, 166 i.file, 167 i.tn_ext, 168 i.rating_score AS score, 169 MAX(r.date) AS recently_rated, 170 ROUND(AVG(r.rate),2) AS avg_rates, 171 COUNT(r.rate) AS nb_rates, 172 SUM(r.rate) AS sum_rates 173 173 FROM '.RATE_TABLE.' AS r 174 174 LEFT JOIN '.IMAGES_TABLE.' AS i ON r.element_id = i.id … … 246 246 $tpl_image['rates'][] = 247 247 array( 248 'DATE' => format_date($row['date']),248 'DATE' => /*format_date*/($row['date']), 249 249 'RATE' => $row['rate'], 250 250 'USER' => $user_rate,
Note: See TracChangeset
for help on using the changeset viewer.