diff options
| author | CiaranG <ciaran@ciarang.com> | 2009-03-06 19:28:15 +0000 |
|---|---|---|
| committer | CiaranG <ciaran@ciarang.com> | 2009-03-06 19:28:15 +0000 |
| commit | 896f0340bf3710b79b117236e940b487a4b56460 (patch) | |
| tree | 13687bb218f164a7d63f6ea1eec420950063a2f6 | |
| parent | 87e5badcb6e8d89e2c85e2bf4be3748b8cd5f940 (diff) | |
Fixed problem with group lists not display all details - broken (by me) in 115519a5e7e84e57656c653918efb39ab4107fe9
| -rw-r--r-- | lib/groupsbymemberssection.php | 4 | ||||
| -rw-r--r-- | lib/groupsbypostssection.php | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/lib/groupsbymemberssection.php b/lib/groupsbymemberssection.php index 5f26c6626..963e21f15 100644 --- a/lib/groupsbymemberssection.php +++ b/lib/groupsbymemberssection.php @@ -45,10 +45,10 @@ class GroupsByMembersSection extends GroupSection { function getGroups() { - $qry = 'SELECT user_group.id, count(*) as value ' . + $qry = 'SELECT user_group.*, count(*) as value ' . 'FROM user_group JOIN group_member '. 'ON user_group.id = group_member.group_id ' . - 'GROUP BY user_group.id ' . + 'GROUP BY user_group.id,user_group.nickname,user_group.fullname,user_group.homepage,user_group.description,user_group.location,user_group.original_logo,user_group.homepage_logo,user_group.stream_logo,user_group.mini_logo,user_group.created,user_group.modified ' . 'ORDER BY value DESC '; $limit = GROUPS_PER_SECTION; diff --git a/lib/groupsbypostssection.php b/lib/groupsbypostssection.php index 1a60ddb4f..325b4033f 100644 --- a/lib/groupsbypostssection.php +++ b/lib/groupsbypostssection.php @@ -45,10 +45,10 @@ class GroupsByPostsSection extends GroupSection { function getGroups() { - $qry = 'SELECT user_group.id, count(*) as value ' . + $qry = 'SELECT user_group.*, count(*) as value ' . 'FROM user_group JOIN group_inbox '. 'ON user_group.id = group_inbox.group_id ' . - 'GROUP BY user_group.id ' . + 'GROUP BY user_group.id,user_group.nickname,user_group.fullname,user_group.homepage,user_group.description,user_group.location,user_group.original_logo,user_group.homepage_logo,user_group.stream_logo,user_group.mini_logo,user_group.created,user_group.modified ' . 'ORDER BY value DESC '; $limit = GROUPS_PER_SECTION; |