X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fcommunity.php;fp=mod%2Fcommunity.php;h=29fcd447944fc2020362f0099038155be2fceb67;hb=4949be60a899105aa7f125227f2767af87afceb2;hp=f1b747917ce6100ff1398e6deec73e0b6e89e6e4;hpb=03aafa8228bbdb0a294265f5865bcc0fb0f82ce1;p=friendica.git diff --git a/mod/community.php b/mod/community.php index f1b747917c..29fcd44794 100644 --- a/mod/community.php +++ b/mod/community.php @@ -183,14 +183,11 @@ function community_content(App $a, $update = 0) function community_getitems($start, $itemspage, $content) { if ($content == 'local') { - $r = dba::p("SELECT " . item_fieldlists() . " FROM `thread` + $r = dba::p("SELECT `item`.`uri`, `item`.`author-link` FROM `thread` INNER JOIN `user` ON `user`.`uid` = `thread`.`uid` AND NOT `user`.`hidewall` INNER JOIN `item` ON `item`.`id` = `thread`.`iid` - AND `item`.`allow_cid` = '' AND `item`.`allow_gid` = '' - AND `item`.`deny_cid` = '' AND `item`.`deny_gid` = ''" . - item_joins() . " AND `contact`.`self` WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated` - AND NOT `thread`.`private` AND `thread`.`wall` + AND NOT `thread`.`private` AND `thread`.`wall` AND `thread`.`origin` ORDER BY `thread`.`commented` DESC LIMIT " . intval($start) . ", " . intval($itemspage) ); return dba::inArray($r);