From 14fa99eab5750b7d5b2598060b118c8f82deb01a Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 7 Jul 2008 03:05:45 -0400 Subject: UNDO: use DB_DataObject join darcs-hash:20080707070545-84dde-8034bf485a182ac86295c9a7831cfabac3cb2b55.gz --- actions/replies.php | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (limited to 'actions') diff --git a/actions/replies.php b/actions/replies.php index 9b9da8cbe..ce12b4d9f 100644 --- a/actions/replies.php +++ b/actions/replies.php @@ -68,20 +68,27 @@ class RepliesAction extends StreamAction { function show_replies($profile) { $reply = new Reply(); - $notice = new Notice(); $reply->profile_id = $profile->id; + $reply->orderBy('modified DESC'); + $page = ($this->arg('page')) ? ($this->arg('page')+0) : 1; + $reply->limit((($page-1)*NOTICES_PER_PAGE), NOTICES_PER_PAGE + 1); - $reply->joinAdd($notice, 'INNER', NULL, 'notice_id'); - + $cnt = $reply->find(); if ($cnt > 0) { common_element_start('ul', array('id' => 'notices')); for ($i = 0; $i < min($cnt, NOTICES_PER_PAGE); $i++) { if ($reply->fetch()) { + $notice = new Notice(); + $notice->id = $reply->notice_id; + $result = $notice->find(true); + if (!$result) { + continue; + } $this->show_notice($notice, $reply->replied_id); } else { // shouldn't happen! -- cgit v1.2.3-54-g00ecf