- if (count($featured_nicks) > 0) {
-
- $quoted = array();
-
- foreach ($featured_nicks as $nick) {
- $quoted[] = "'$nick'";
- }
-
- $user = new User;
- $user->whereAdd(sprintf('nickname IN (%s)', implode(',', $quoted)));
- $user->limit(($page - 1) * PROFILES_PER_PAGE, PROFILES_PER_PAGE + 1);
- $user->orderBy('user.nickname ASC');
-
- $user->find();
-
- $profile_ids = array();
-
- while ($user->fetch()) {
- $profile_ids[] = $user->id;
- common_debug("id = $user->id");
- }
-
- $profile = new Profile;
- $profile->whereAdd(sprintf('profile.id IN (%s)', implode(',', $profile_ids)));
- $profile->orderBy('nickname ASC');
-
- $cnt = $profile->find();
-
- common_debug("count = $cnt");
-
- if ($cnt > 0) {
- $featured = new ProfileList($profile);
- $featured->show_list();
- }
-
- $profile->free();
-
- common_pagination($page > 1, $cnt > PROFILES_PER_PAGE, $page, 'featured');
- }
- }
-
-}
\ No newline at end of file
+/**
+ * List of featured users
+ *
+ * @category Public
+ * @package StatusNet
+ * @author Zach Copley <zach@status.net>
+ * @author Evan Prodromou <evan@status.net>
+ * @license http://www.fsf.org/licensing/licenses/agpl-3.0.html GNU Affero General Public License version 3.0
+ * @link http://status.net/
+ */
+class FeaturedAction extends Action
+{
+ var $page = null;
+
+ function isReadOnly($args)
+ {
+ return true;
+ }
+
+ function prepare($args)
+ {
+ parent::prepare($args);
+ $this->page = ($this->arg('page')) ? ($this->arg('page')+0) : 1;
+
+ return true;
+ }
+
+ function title()
+ {
+ if ($this->page == 1) {
+ // TRANS: Page title for first page of featured users.
+ return _('Featured users');
+ } else {
+ // TRANS: Page title for all but first page of featured users.
+ // TRANS: %d is the page number being displayed.
+ return sprintf(_('Featured users, page %d'), $this->page);
+ }
+ }
+
+ function handle($args)
+ {
+ parent::handle($args);
+
+ $this->showPage();
+ }
+
+ function showPageNotice()
+ {
+ $instr = $this->getInstructions();
+ $output = common_markup_to_html($instr);
+ $this->elementStart('div', 'instructions');
+ $this->raw($output);
+ $this->elementEnd('div');
+ }
+
+ function getInstructions()
+ {
+ // TRANS: Description on page displaying featured users.
+ return sprintf(_('A selection of some great users on %s.'),
+ common_config('site', 'name'));
+ }
+
+ function showContent()
+ {
+ // XXX: Note I'm doing it this two-stage way because a raw query
+ // with a JOIN was *not* working. --Zach
+
+ $featured_nicks = common_config('nickname', 'featured');
+
+ if (count($featured_nicks) > 0) {
+
+ $quoted = array();
+
+ foreach ($featured_nicks as $nick) {
+ $quoted[] = "'$nick'";
+ }
+
+ $user = new User;
+ $user->whereAdd(sprintf('nickname IN (%s)', implode(',', $quoted)));
+ $user->limit(($this->page - 1) * PROFILES_PER_PAGE, PROFILES_PER_PAGE + 1);
+ $user->orderBy(common_database_tablename('user') .'.nickname ASC');
+
+ $user->find();
+
+ $profile_ids = array();
+
+ while ($user->fetch()) {
+ $profile_ids[] = $user->id;
+ }
+
+ $profile = new Profile;
+ $profile->whereAdd(sprintf('profile.id IN (%s)', implode(',', $profile_ids)));
+ $profile->orderBy('nickname ASC');
+
+ $cnt = $profile->find();
+
+ if ($cnt > 0) {
+ $featured = new ProfileList($profile, $this);
+ $featured->show();
+ }
+
+ $profile->free();
+
+ $this->pagination($this->page > 1, $cnt > PROFILES_PER_PAGE,
+ $this->page, 'featured');
+ }
+ }
+}