From 891d231bbe4ee4499cf9e62013971b85a0542404 Mon Sep 17 00:00:00 2001 From: Habeas Codice Date: Fri, 23 Jan 2015 17:25:05 -0800 Subject: rand() fixes --- mod/dirsearch.php | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'mod/dirsearch.php') diff --git a/mod/dirsearch.php b/mod/dirsearch.php index 4a44feb7d..06d530849 100644 --- a/mod/dirsearch.php +++ b/mod/dirsearch.php @@ -355,14 +355,15 @@ function dir_parse_query($s) { function list_public_sites() { + $rand = db_getfunc('rand'); $realm = get_directory_realm(); if($realm == DIRECTORY_REALM) { - $r = q("select * from site where site_access != 0 and site_register !=0 and ( site_realm = '%s' or site_realm = '') order by rand()", + $r = q("select * from site where site_access != 0 and site_register !=0 and ( site_realm = '%s' or site_realm = '') order by $rand", dbesc($realm) ); } else { - $r = q("select * from site where site_access != 0 and site_register !=0 and site_realm = '%s' order by rand()", + $r = q("select * from site where site_access != 0 and site_register !=0 and site_realm = '%s' order by $rand", dbesc($realm) ); } -- cgit v1.2.3