123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109 |
- <?php
- if (!defined('STATUSNET') && !defined('LACONICA')) {
- exit(1);
- }
- class FeaturedUsersSection extends ProfileSection
- {
- function show()
- {
- $featured_nicks = common_config('nickname', 'featured');
- if (empty($featured_nicks)) {
- return;
- }
- parent::show();
- }
- function getProfiles()
- {
- $featured_nicks = common_config('nickname', 'featured');
- if (!$featured_nicks) {
- return null;
- }
- $quoted = array();
- foreach ($featured_nicks as $nick) {
- $quoted[] = "'$nick'";
- }
- $table = "user";
- if(common_config('db','quote_identifiers')) {
- $table = '"' . $table . '"';
- }
- $qry = 'SELECT profile.* ' .
- 'FROM profile JOIN '. $table .' on profile.id = '. $table .'.id ' .
- 'WHERE '. $table .'.nickname in (' . implode(',', $quoted) . ') ' .
- 'ORDER BY profile.created DESC ';
- $limit = PROFILES_PER_SECTION + 1;
- $offset = 0;
- if (common_config('db','type') == 'pgsql') {
- $qry .= ' LIMIT ' . $limit . ' OFFSET ' . $offset;
- } else {
- $qry .= ' LIMIT ' . $offset . ', ' . $limit;
- }
- $profile = Memcached_DataObject::cachedQuery('Profile',
- $qry,
- 6 * 3600);
- return $profile;
- }
- function title()
- {
-
- return _('Featured users');
- }
- function divId()
- {
- return 'featured_users';
- }
- function moreUrl()
- {
- return common_local_url('featured');
- }
- }
|