From 649ada7100ef40d605b06088d96cd124fa311863 Mon Sep 17 00:00:00 2001 From: friendica Date: Thu, 2 Apr 2015 13:22:48 -0700 Subject: provide ability to have randomised homepage content from a set of pages name home-* --- mod/home.php | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'mod') diff --git a/mod/home.php b/mod/home.php index 7f28a89fc..7bb138d2e 100644 --- a/mod/home.php +++ b/mod/home.php @@ -72,16 +72,20 @@ function home_content(&$a, $update = 0, $load = false) { if($channel_address) { $page_id = 'home'; + $randpage_id = 'home-%'; $u = q("select channel_id from channel where channel_address = '%s' limit 1", dbesc($channel_address) ); + $randfunc = db_getfunc('RAND'); + $r = q("select item.* from item left join item_id on item.id = item_id.iid - where item.uid = %d and sid = '%s' and service = 'WEBPAGE' and - item_restrict = %d limit 1", + where item.uid = %d and ( sid = '%s' or sid like '%s' ) and service = 'WEBPAGE' and + item_restrict = %d ORDER BY $randfunc limit 1", intval($u[0]['channel_id']), dbesc($page_id), + dbesc($randpage_id), intval(ITEM_WEBPAGE) ); -- cgit v1.2.3