Changeset 4331 for trunk/include
- Timestamp:
- Nov 21, 2009, 1:15:22 PM (14 years ago)
- Location:
- trunk/include
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
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.