Changeset 1042 for trunk/admin/include
- Timestamp:
- Feb 15, 2006, 3:29:26 AM (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/include/functions.php
r1028 r1042 1312 1312 /** 1313 1313 * update images.average_rate field 1314 * 1314 * param int $element_id optional, otherwise applies to all 1315 1315 * @return void 1316 1316 */ 1317 function update_average_rate( )1317 function update_average_rate( $element_id=-1 ) 1318 1318 { 1319 1319 $average_rates = array(); … … 1322 1322 SELECT element_id, 1323 1323 ROUND(AVG(rate),2) AS average_rate 1324 FROM '.RATE_TABLE.' 1325 GROUP BY element_id 1326 ;'; 1324 FROM '.RATE_TABLE; 1325 if ( $element_id != -1 ) 1326 { 1327 $query .= ' WHERE element_id=' . $element_id; 1328 } 1329 $query .= ' GROUP BY element_id;'; 1330 1327 1331 $result = pwg_query($query); 1328 1332 while ($row = mysql_fetch_array($result)) … … 1344 1348 $fields = array('primary' => array('id'), 'update' => array('average_rate')); 1345 1349 mass_updates(IMAGES_TABLE, $fields, $datas); 1350 1351 $query=' 1352 UPDATE '.IMAGES_TABLE .' 1353 LEFT JOIN '.RATE_TABLE.' ON id=element_id 1354 SET average_rate=NULL 1355 WHERE element_id IS NULL'; 1356 if ( $element_id != -1 ) 1357 { 1358 $query .= ' AND id=' . $element_id; 1359 } 1360 pwg_query($query); 1346 1361 } 1347 1362
Note: See TracChangeset
for help on using the changeset viewer.