diff options
| author | Zach Copley <zach@controlyourself.ca> | 2009-01-25 02:03:49 -0800 |
|---|---|---|
| committer | Zach Copley <zach@controlyourself.ca> | 2009-01-25 02:03:49 -0800 |
| commit | 688d38b1015456ae28cf0ef96bab777a47d5a97a (patch) | |
| tree | db08c562f240323c3e0565892e56e0373678ca78 | |
| parent | e2a965c999e1d8096195d063c808a15759ecf5c6 (diff) | |
Fixed broken SQL for people tags view
| -rw-r--r-- | actions/peopletag.php | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/actions/peopletag.php b/actions/peopletag.php index bf2aacb1c..3578c53fd 100644 --- a/actions/peopletag.php +++ b/actions/peopletag.php @@ -49,7 +49,6 @@ class PeopletagAction extends Action $this->showPage(); } - function showContent() { @@ -66,17 +65,18 @@ class PeopletagAction extends Action # XXX: memcached this - $profile->query(sprintf('SELECT profile.* ' . - 'FROM profile JOIN profile_tag ' . - 'ON profile.id = profile_tag.tagger ' . - 'WHERE profile_tag.tagger = profile_tag.tagged ' . - 'AND tag = "%s" ' . - 'ORDER BY profile_tag.modified DESC ', - 'LIMIT 0, %s'), $this->tag, $lim); + $qry = 'SELECT profile.* ' . + 'FROM profile JOIN profile_tag ' . + 'ON profile.id = profile_tag.tagger ' . + 'WHERE profile_tag.tagger = profile_tag.tagged ' . + 'AND tag = "%s" ' . + 'ORDER BY profile_tag.modified DESC'; + + $profile->query(sprintf($qry, $this->tag, $lim)); $pl = new ProfileList($profile, null, $this); $cnt = $pl->show(); - + $this->pagination($this->page > 1, $cnt > PROFILES_PER_PAGE, $this->page, |