aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authorredmatrix <redmatrix@redmatrix.me>2015-08-11 20:16:17 -0700
committerredmatrix <redmatrix@redmatrix.me>2015-08-11 20:16:17 -0700
commit8dd7fab38d0938f87bb3b696b946b18bb09e78af (patch)
treefa958735140be8d8327b1ec9354775d1b861954d /include
parent400d5790f3f461ebe1e35012ad8fa976fe9b2910 (diff)
downloadvolse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.tar.gz
volse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.tar.bz2
volse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.zip
order by name
Diffstat (limited to 'include')
-rw-r--r--include/widgets.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/include/widgets.php b/include/widgets.php
index 698326d36..cfecbdc66 100644
--- a/include/widgets.php
+++ b/include/widgets.php
@@ -1003,7 +1003,7 @@ function widget_forums($arr) {
$perms_sql = item_permissions_sql(local_channel()) . item_normal();
- $r = q("select sum(item_unseen) as unseen, owner_xchan, abook_id, xchan.* from xchan left join item on owner_xchan = xchan_hash left join abook on abook_channel = uid where xchan_pubforum = 1 and uid = %d $perms_sql group by owner_xchan $limit ",
+ $r = q("select sum(item_unseen) as unseen, owner_xchan, abook_id, xchan.* from xchan left join item on owner_xchan = xchan_hash left join abook on abook_channel = uid where xchan_pubforum = 1 and uid = %d $perms_sql group by owner_xchan order by xchan_name $limit ",
intval(local_channel())
);
if($r) {