aboutsummaryrefslogtreecommitdiffstats
path: root/admin/include
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--admin/include/functions.php4
-rw-r--r--admin/include/functions_history.inc.php2
2 files changed, 3 insertions, 3 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index 2b6bffa98..16928e9ab 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -596,8 +596,8 @@ function set_random_representant($categories)
SELECT image_id
FROM '.IMAGE_CATEGORY_TABLE.'
WHERE category_id = '.$category_id.'
- ORDER BY RAND()
- LIMIT 0,1
+ ORDER BY '.DB_RANDOM_FUNCTION.'()
+ LIMIT 0 OFFSET 1
;';
list($representative) = pwg_db_fetch_row(pwg_query($query));
diff --git a/admin/include/functions_history.inc.php b/admin/include/functions_history.inc.php
index 824caed42..38d3950eb 100644
--- a/admin/include/functions_history.inc.php
+++ b/admin/include/functions_history.inc.php
@@ -161,7 +161,7 @@ SELECT
WHERE '.$where_separator.'
;';
- // LIMIT '.$page['start'].', '.$conf['nb_logs_page'].'
+ // LIMIT '.$page['start'].' OFFSET '.$conf['nb_logs_page'].'
$result = pwg_query($query);