featureduserssection.php 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596
  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. * Section for featured users
  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. * Section for featured users
  28. *
  29. * @copyright 2009 StatusNet, Inc.
  30. * @license https://www.gnu.org/licenses/agpl.html GNU AGPL v3 or later
  31. */
  32. class FeaturedUsersSection extends ProfileSection
  33. {
  34. public function show()
  35. {
  36. $featured_nicks = common_config('nickname', 'featured');
  37. if (empty($featured_nicks)) {
  38. return;
  39. }
  40. parent::show();
  41. }
  42. public function getProfiles()
  43. {
  44. $featured_nicks = common_config('nickname', 'featured');
  45. if (!$featured_nicks) {
  46. return null;
  47. }
  48. $quoted_nicks = implode(
  49. ',',
  50. array_map(
  51. function (string $nick): string {
  52. return "'{$nick}'";
  53. },
  54. $featured_nicks
  55. )
  56. );
  57. $user_table = common_database_tablename('user');
  58. $limit = PROFILES_PER_SECTION + 1;
  59. $qry = <<<END
  60. SELECT profile.*
  61. FROM profile
  62. INNER JOIN {$user_table} ON profile.id = {$user_table}.id
  63. WHERE profile.nickname IN ({$quoted_nicks})
  64. ORDER BY profile.created DESC, profile.id DESC
  65. LIMIT {$limit};
  66. END;
  67. $profile = Memcached_DataObject::cachedQuery('Profile', $qry, 6 * 3600);
  68. return $profile;
  69. }
  70. public function title()
  71. {
  72. // TRANS: Title for featured users section.
  73. return _('Featured users');
  74. }
  75. public function divId()
  76. {
  77. return 'featured_users';
  78. }
  79. public function moreUrl()
  80. {
  81. return common_local_url('featured');
  82. }
  83. }