summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorZach Copley <zach@controlyourself.ca>2009-01-25 02:03:49 -0800
committerZach Copley <zach@controlyourself.ca>2009-01-25 02:03:49 -0800
commit688d38b1015456ae28cf0ef96bab777a47d5a97a (patch)
treedb08c562f240323c3e0565892e56e0373678ca78
parente2a965c999e1d8096195d063c808a15759ecf5c6 (diff)
Fixed broken SQL for people tags view
-rw-r--r--actions/peopletag.php18
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,