summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBrenda Wallace <shiny@cpan.org>2009-03-17 10:25:47 +1300
committerBrenda Wallace <shiny@cpan.org>2009-03-17 10:27:29 +1300
commitc2e529c72b17b61f2203466b2bfd73f07b8371f0 (patch)
tree223600fdb609814c51db1309449e012348732f75
parentea5e7ed2ff0873655a8399c5001686bea8a4adf7 (diff)
quoted the users table
-rw-r--r--actions/featured.php10
1 files changed, 8 insertions, 2 deletions
diff --git a/actions/featured.php b/actions/featured.php
index f3bade6a5..14d653cea 100644
--- a/actions/featured.php
+++ b/actions/featured.php
@@ -107,6 +107,7 @@ class FeaturedAction extends Action
$featured_nicks = common_config('nickname', 'featured');
+
if (count($featured_nicks) > 0) {
$quoted = array();
@@ -115,10 +116,15 @@ class FeaturedAction extends Action
$quoted[] = "'$nick'";
}
+ $table = "user";
+ if(common_config('db','quote_identifiers')) {
+ $table = '"' . $table . '"';
+ }
+
$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('user.nickname ASC');
+ $user->orderBy($table .'.nickname ASC');
$user->find();
@@ -145,4 +151,4 @@ class FeaturedAction extends Action
$this->page, 'featured');
}
}
-} \ No newline at end of file
+}