From 3987de1064de54c945d311fa8b0eab144504891a Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@controlyourself.ca>
Date: Wed, 12 Nov 2008 12:25:17 -0500
Subject: created timestamp on notice_inbox

darcs-hash:20081112172517-5ed1f-4e8534d7898e2134edf4c0a28417b4a5274617d4.gz
---
 classes/User.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'classes/User.php')

diff --git a/classes/User.php b/classes/User.php
index bbc33f72a..370aad07b 100644
--- a/classes/User.php
+++ b/classes/User.php
@@ -330,9 +330,12 @@ class User extends Memcached_DataObject
 		  'FROM notice JOIN notice_inbox ON notice.id = notice_inbox.notice_id ' .
 		  'WHERE notice_inbox.user_id = %d ';
 
+		# NOTE: we override ORDER
+		
 		return Notice::getStream(sprintf($qry, $this->id),
 								 'user:notices_with_friends:' . $this->id,
-								 $offset, $limit, $since_id, $before_id);
+								 $offset, $limit, $since_id, $before_id,
+								 'ORDER BY notice_inbox.created DESC, notice_inbox.id DESC ');
 	}
 	
 	function blowFavesCache() {
-- 
cgit v1.2.3-54-g00ecf