Changeset 11827 for trunk/admin/rating.php
- Timestamp:
- Jul 25, 2011, 8:04:50 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/rating.php
r8728 r11827 86 86 ;'; 87 87 pwg_query($query); 88 update_ average_rate( $vars['e'] );88 update_rating_score( $vars['e'] ); 89 89 } 90 90 … … 101 101 102 102 103 $query = 'SELECT COUNT(DISTINCT(i.id)) 104 FROM '.RATE_TABLE.' AS r, '.IMAGES_TABLE.' AS i 105 WHERE r.element_id=i.id'. $page['user_filter'] . 106 ';'; 103 $query = 'SELECT COUNT(DISTINCT(r.element_id)) 104 FROM '.RATE_TABLE.' AS r 105 WHERE 1=1'. $page['user_filter']; 107 106 list($nb_images) = pwg_db_fetch_row(pwg_query($query)); 108 107 … … 132 131 $available_order_by= array( 133 132 array(l10n('Rate date'), 'recently_rated DESC'), 134 array(l10n('Average rate'), 'average_rate DESC'), 133 array(l10n('Rating score'), 'score DESC'), 134 array(l10n('Average rate'), 'avg_rates DESC'), 135 135 array(l10n('Number of rates'), 'nb_rates DESC'), 136 136 array(l10n('Sum of rates'), 'sum_rates DESC'), … … 165 165 i.file, 166 166 i.tn_ext, 167 i.average_rate ,167 i.average_rate AS score, 168 168 MAX(r.date) AS recently_rated, 169 ROUND(AVG(r.rate),2) AS avg_rates, 169 170 COUNT(r.rate) AS nb_rates, 170 171 SUM(r.rate) AS sum_rates … … 208 209 'U_THUMB' => $thumbnail_src, 209 210 'U_URL' => $image_url, 210 'AVG_RATE' => $image['average_rate'], 211 'SCORE_RATE' => $image['score'], 212 'AVG_RATE' => $image['avg_rates'], 211 213 'SUM_RATE' => $image['sum_rates'], 212 214 'NB_RATES' => (int)$image['nb_rates'],
Note: See TracChangeset
for help on using the changeset viewer.