diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-08-11 20:16:17 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-08-11 20:16:17 -0700 |
| commit | 8dd7fab38d0938f87bb3b696b946b18bb09e78af (patch) | |
| tree | fa958735140be8d8327b1ec9354775d1b861954d | |
| parent | 400d5790f3f461ebe1e35012ad8fa976fe9b2910 (diff) | |
| download | volse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.tar.gz volse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.tar.bz2 volse-hubzilla-8dd7fab38d0938f87bb3b696b946b18bb09e78af.zip | |
order by name
| -rw-r--r-- | include/widgets.php | 2 |
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) { |