From b9eedf6195d64f8c8904fdfd99ae528f1063af4b Mon Sep 17 00:00:00 2001 From: Evan Prodromou Date: Mon, 7 Jul 2008 03:05:45 -0400 Subject: [PATCH] use DB_DataObject join darcs-hash:20080707070545-84dde-581f5b8d356b5b7d27a9b0b331a0e40ddab28cbe.gz --- actions/replies.php | 13 +++---------- 1 file changed, 3 insertions(+), 10 deletions(-) diff --git a/actions/replies.php b/actions/replies.php index ce12b4d9f8..9b9da8cbe6 100644 --- a/actions/replies.php +++ b/actions/replies.php @@ -68,27 +68,20 @@ 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! -- 2.39.5