X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fcommunity.php;h=e2311515790b5f63f324c8528f6a475fc575fa43;hb=8b20af6ef536e34c3bc9c412cbffa4cf9c0cea53;hp=8d23c4af287b59b7d35c34d005a1c012f1ce303c;hpb=992684c3620185da00663e25eb1460c4b18920ea;p=friendica.git diff --git a/mod/community.php b/mod/community.php index 8d23c4af28..e231151579 100644 --- a/mod/community.php +++ b/mod/community.php @@ -114,6 +114,10 @@ function community_content(&$a, $update = 0) { } function community_getitems($start, $itemspage) { + // Work in progress + if (get_config('system', 'global_community')) + return(community_getpublicitems($start, $itemspage)); + $r = q("SELECT `item`.`uri`, `item`.*, `item`.`id` AS `item_id`, `contact`.`name`, `contact`.`photo`, `contact`.`url`, `contact`.`alias`, `contact`.`rel`, `contact`.`network`, `contact`.`thumb`, `contact`.`self`, `contact`.`writable`, @@ -136,3 +140,19 @@ function community_getitems($start, $itemspage) { return($r); } + +function community_getpublicitems($start, $itemspage) { + $r = q("SELECT `item`.`uri`, `item`.*, `item`.`id` AS `item_id`, + `author-name` AS `name`, `owner-avatar` AS `photo`, + `owner-link` AS `url`, `owner-avatar` AS `thumb` + FROM `item` WHERE `item`.`uid` = 0 + AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = '' + AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = '' + ORDER BY `item`.`received` DESC LIMIT %d, %d", + intval($start), + intval($itemspage) + ); + + return($r); + +}