summaryrefslogtreecommitdiff
path: root/classes
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2008-09-09 03:22:24 -0400
committerCiaranG <ciaran@ciarang.com>2008-09-09 03:22:24 -0400
commit26634ef0a08234980835698e40b23a291305d1f8 (patch)
treeedb8255b42a7d5da8da942e1084976b9f79e2199 /classes
parenteb4df223e6bb63c4a81e744c74b2f7fae335a8a0 (diff)
Initial support for PostgreSQL
darcs-hash:20080909072224-f6e2c-881bd2e7fb032f336fecae9ca5ce527dd821d3dc.gz
Diffstat (limited to 'classes')
-rw-r--r--classes/User.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/classes/User.php b/classes/User.php
index 9251a9a84..96a7482ea 100644
--- a/classes/User.php
+++ b/classes/User.php
@@ -145,13 +145,13 @@ class User extends DB_DataObject
function noticesWithFriends($offset=0, $limit=20) {
$notice = new Notice();
-
+
$notice->query('SELECT notice.* ' .
'FROM notice JOIN subscription on notice.profile_id = subscription.subscribed ' .
'WHERE subscription.subscriber = ' . $this->id . ' ' .
'ORDER BY created DESC, notice.id DESC ' .
'LIMIT ' . $offset . ', ' . $limit);
-
+
return $notice;
}