X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Fcommunity.php;fp=mod%2Fcommunity.php;h=4b755e18ce6ebc58eb5b09b210029175e53b9c64;hb=e12b6e01a23ede9e7e134bc4615d14dc618ebebd;hp=7c480d259e3aefd05b901aba803d471f9fa88df7;hpb=708d034c6de330a7b3d2d3f3138cd139fdd3f69f;p=friendica.git diff --git a/mod/community.php b/mod/community.php index 7c480d259e..4b755e18ce 100644 --- a/mod/community.php +++ b/mod/community.php @@ -190,14 +190,14 @@ function community_getitems($start, $itemspage, $content) item_joins() . " AND `contact`.`self` WHERE `thread`.`visible` AND NOT `thread`.`deleted` AND NOT `thread`.`moderated` AND NOT `thread`.`private` AND `thread`.`wall` - ORDER BY `thread`.`received` DESC LIMIT " . intval($start) . ", " . intval($itemspage) + ORDER BY `thread`.`commented` DESC LIMIT " . intval($start) . ", " . intval($itemspage) ); return dba::inArray($r); } elseif ($content == 'global') { $r = dba::p("SELECT " . item_fieldlists() . " FROM `thread` INNER JOIN `item` ON `item`.`id` = `thread`.`iid` " . item_joins() . "WHERE `thread`.`uid` = 0 AND `verb` = ? - ORDER BY `thread`.`created` DESC LIMIT " . intval($start) . ", " . intval($itemspage), + ORDER BY `thread`.`commented` DESC LIMIT " . intval($start) . ", " . intval($itemspage), ACTIVITY_POST ); return dba::inArray($r);