Changeset 4334 for trunk/admin
- Timestamp:
- Nov 21, 2009, 8:52:50 PM (14 years ago)
- Location:
- trunk/admin
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/cat_perm.php
r4331 r4334 60 60 FROM '.CATEGORIES_TABLE.' 61 61 WHERE status = \'private\' 62 LIMIT 0 OFFSET162 LIMIT 1 63 63 ;'; 64 64 -
trunk/admin/element_set_global.php
r4331 r4334 475 475 WHERE id IN ('.implode(',', $page['cat_elements_id']).') 476 476 '.$conf['order_by'].' 477 LIMIT '.$page['start'].' OFFSET '.$page['nb_images'].' 478 ;'; 479 //echo '<pre>'.$query.'</pre>'; 477 LIMIT '.$page['nb_images'].' OFFSET '.$page['start'].' 478 ;'; 480 479 $result = pwg_query($query); 481 480 482 481 // template thumbnail initialization 483 484 482 while ($row = pwg_db_fetch_assoc($result)) 485 483 { -
trunk/admin/element_set_unit.php
r4331 r4334 197 197 WHERE id IN ('.implode(',', $page['cat_elements_id']).') 198 198 '.$conf['order_by'].' 199 LIMIT '.$page[' start'].' OFFSET '.$page['nb_images'].'199 LIMIT '.$page['nb_images'].' OFFSET '.$page['start'].' 200 200 ;'; 201 201 $result = pwg_query($query); -
trunk/admin/include/functions.php
r4331 r4334 598 598 WHERE category_id = '.$category_id.' 599 599 ORDER BY '.DB_RANDOM_FUNCTION.'() 600 LIMIT 0 OFFSET1600 LIMIT 1 601 601 ;'; 602 602 list($representative) = pwg_db_fetch_row(pwg_query($query)); -
trunk/admin/include/functions_history.inc.php
r4331 r4334 162 162 ;'; 163 163 164 // LIMIT '.$ page['start'].' OFFSET '.$conf['nb_logs_page'].'164 // LIMIT '.$conf['nb_logs_page'].' OFFSET '.$page['start'].' 165 165 166 166 $result = pwg_query($query); -
trunk/admin/rating.php
r4331 r4334 177 177 GROUP BY r.element_id 178 178 ORDER BY ' . $available_order_by[$order_by_index][1] .' 179 LIMIT '.$ start.' OFFSET '.$elements_per_page.'179 LIMIT '.$elements_per_page.' OFFSET '.$start.' 180 180 ;'; 181 181
Note: See TracChangeset
for help on using the changeset viewer.