groupsbypostssection.php 2.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php
  2. // This file is part of GNU social - https://www.gnu.org/software/social
  3. //
  4. // GNU social is free software: you can redistribute it and/or modify
  5. // it under the terms of the GNU Affero General Public License as published by
  6. // the Free Software Foundation, either version 3 of the License, or
  7. // (at your option) any later version.
  8. //
  9. // GNU social is distributed in the hope that it will be useful,
  10. // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11. // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  12. // GNU Affero General Public License for more details.
  13. //
  14. // You should have received a copy of the GNU Affero General Public License
  15. // along with GNU social. If not, see <http://www.gnu.org/licenses/>.
  16. /**
  17. * Groups with the most posts section
  18. *
  19. * @category Widget
  20. * @package GNUsocial
  21. * @author Evan Prodromou <evan@status.net>
  22. * @copyright 2009 StatusNet, Inc.
  23. * @license https://www.gnu.org/licenses/agpl.html GNU AGPL v3 or later
  24. */
  25. defined('GNUSOCIAL') || die();
  26. /**
  27. * Groups with the most posts section
  28. *
  29. * @category Widget
  30. * @package GNUsocial
  31. * @author Evan Prodromou <evan@status.net>
  32. * @license https://www.gnu.org/licenses/agpl.html GNU AGPL v3 or later
  33. */
  34. class GroupsByPostsSection extends GroupSection
  35. {
  36. public function getGroups()
  37. {
  38. $limit = GROUPS_PER_SECTION;
  39. $qry = <<<END
  40. SELECT *
  41. FROM user_group INNER JOIN (
  42. SELECT group_id AS id, COUNT(group_id) AS value
  43. FROM group_inbox
  44. GROUP BY group_id
  45. ) AS t1 USING (id)
  46. ORDER BY value DESC LIMIT {$limit};
  47. END;
  48. $group = Memcached_DataObject::cachedQuery('User_group', $qry, 3600);
  49. return $group;
  50. }
  51. public function title()
  52. {
  53. // TRANS: Title for groups with the most posts section.
  54. return _('Active groups');
  55. }
  56. public function divId()
  57. {
  58. return 'top_groups_by_post';
  59. }
  60. }