diff options
author | Mario Vavti <mario@mariovavti.com> | 2018-07-04 10:55:38 +0200 |
---|---|---|
committer | Mario Vavti <mario@mariovavti.com> | 2018-07-04 10:55:38 +0200 |
commit | d9ece80fda867768fb3b8de47bf4eb7c3e6108e8 (patch) | |
tree | db212eaf07ee258892ae9a92cf3d2da5f3ac811d | |
parent | b88a9c2627e632d0f963e0078191eb616e5a1668 (diff) | |
download | volse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.tar.gz volse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.tar.bz2 volse-hubzilla-d9ece80fda867768fb3b8de47bf4eb7c3e6108e8.zip |
order nouveau by created instead of received since ordering by received returns unexpected results once old expired items get re-imported
-rw-r--r-- | Zotlabs/Module/Network.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/Zotlabs/Module/Network.php b/Zotlabs/Module/Network.php index 172157aab..77a08585b 100644 --- a/Zotlabs/Module/Network.php +++ b/Zotlabs/Module/Network.php @@ -480,7 +480,7 @@ class Network extends \Zotlabs\Web\Controller { if($nouveau && $load) { // "New Item View" - show all items unthreaded in reverse created date order - $items = q("SELECT item.*, item.id AS item_id, received FROM item + $items = q("SELECT item.*, item.id AS item_id, created FROM item left join abook on ( item.owner_xchan = abook.abook_xchan $abook_uids ) $net_query WHERE true $uids $item_normal @@ -488,7 +488,7 @@ class Network extends \Zotlabs\Web\Controller { $simple_update $sql_extra $sql_options $sql_nets $net_query2 - ORDER BY item.received DESC $pager_sql " + ORDER BY item.created DESC $pager_sql " ); require_once('include/items.php'); |