Changeset 4331
- Timestamp:
- Nov 21, 2009, 1:15:22 PM (14 years ago)
- Location:
- trunk
- Files:
-
- 11 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/cat_perm.php
r4325 r4331 60 60 FROM '.CATEGORIES_TABLE.' 61 61 WHERE status = \'private\' 62 LIMIT 0 ,162 LIMIT 0 OFFSET 1 63 63 ;'; 64 64 -
trunk/admin/element_set_global.php
r4325 r4331 475 475 WHERE id IN ('.implode(',', $page['cat_elements_id']).') 476 476 '.$conf['order_by'].' 477 LIMIT '.$page['start'].' ,'.$page['nb_images'].'477 LIMIT '.$page['start'].' OFFSET '.$page['nb_images'].' 478 478 ;'; 479 479 //echo '<pre>'.$query.'</pre>'; -
trunk/admin/element_set_unit.php
r4325 r4331 197 197 WHERE id IN ('.implode(',', $page['cat_elements_id']).') 198 198 '.$conf['order_by'].' 199 LIMIT '.$page['start'].' ,'.$page['nb_images'].'199 LIMIT '.$page['start'].' OFFSET '.$page['nb_images'].' 200 200 ;'; 201 201 $result = pwg_query($query); -
trunk/admin/include/functions.php
r4325 r4331 597 597 FROM '.IMAGE_CATEGORY_TABLE.' 598 598 WHERE category_id = '.$category_id.' 599 ORDER BY RAND()600 LIMIT 0 ,1599 ORDER BY '.DB_RANDOM_FUNCTION.'() 600 LIMIT 0 OFFSET 1 601 601 ;'; 602 602 list($representative) = pwg_db_fetch_row(pwg_query($query)); -
trunk/admin/include/functions_history.inc.php
r4325 r4331 162 162 ;'; 163 163 164 // LIMIT '.$page['start'].' ,'.$conf['nb_logs_page'].'164 // LIMIT '.$page['start'].' OFFSET '.$conf['nb_logs_page'].' 165 165 166 166 $result = pwg_query($query); -
trunk/admin/rating.php
r4325 r4331 177 177 GROUP BY r.element_id 178 178 ORDER BY ' . $available_order_by[$order_by_index][1] .' 179 LIMIT '.$start.' ,'.$elements_per_page.'179 LIMIT '.$start.' OFFSET '.$elements_per_page.' 180 180 ;'; 181 181 -
trunk/comments.php
r4325 r4331 327 327 { 328 328 $query.= ' 329 LIMIT '.$start.' ,'.$page['items_number'];329 LIMIT '.$start.' OFFSET '.$page['items_number']; 330 330 } 331 331 $query.= ' -
trunk/include/calendar_monthly.class.php
r4325 r4331 349 349 $query.= ' 350 350 ORDER BY RAND() 351 LIMIT 0 ,1';351 LIMIT 0 OFFSET 1'; 352 352 unset ( $page['chronology_date'][CDAY] ); 353 353 -
trunk/include/functions_notification.inc.php
r4325 r4331 445 445 GROUP BY date_available 446 446 ORDER BY date_available DESC 447 LIMIT 0 ,'.$max_dates.'447 LIMIT 0 OFFSET '.$max_dates.' 448 448 ;'; 449 449 $result = pwg_query($query); … … 465 465 AND tn_ext IS NOT NULL 466 466 ORDER BY RAND(NOW()) 467 LIMIT 0 ,'.$max_elements.'467 LIMIT 0 OFFSET '.$max_elements.' 468 468 ;'; 469 469 $dates[$i]['elements'] = array(); … … 485 485 GROUP BY category_id 486 486 ORDER BY img_count DESC 487 LIMIT 0 ,'.$max_cats.'487 LIMIT 0 OFFSET '.$max_cats.' 488 488 ;'; 489 489 $dates[$i]['categories'] = array(); -
trunk/include/picture_comment.inc.php
r4325 r4331 137 137 $validated_clause.' 138 138 ORDER BY date ASC 139 LIMIT '.$page['start'].' ,'.$conf['nb_comment_page'].'139 LIMIT '.$page['start'].' OFFSET '.$conf['nb_comment_page'].' 140 140 ;'; 141 141 $result = pwg_query( $query ); -
trunk/include/ws_functions.inc.php
r4325 r4331 293 293 GROUP BY i.id 294 294 '.$order_by.' 295 LIMIT '.(int)($params['per_page']*$params['page']).' ,'.(int)$params['per_page'];295 LIMIT '.(int)($params['per_page']*$params['page']).' OFFSET '.(int)$params['per_page']; 296 296 297 297 $result = pwg_query($query); … … 684 684 ORDER BY date 685 685 LIMIT '.(int)($params['comments_per_page']*$params['comments_page']). 686 ' ,'.(int)$params['comments_per_page'];686 ' OFFSET '.(int)$params['comments_per_page']; 687 687 688 688 $result = pwg_query($query); … … 1399 1399 AND ', $where_clauses).' 1400 1400 '.$order_by.' 1401 LIMIT '.(int)($params['per_page']*$params['page']).' ,'.(int)$params['per_page'];1401 LIMIT '.(int)($params['per_page']*$params['page']).' OFFSET '.(int)$params['per_page']; 1402 1402 1403 1403 $result = pwg_query($query);
Note: See TracChangeset
for help on using the changeset viewer.