From 42ac47915ba32abcf41d2718b9032e084a7f5f88 Mon Sep 17 00:00:00 2001
From: Evan Prodromou <evan@prodromou.name>
Date: Tue, 22 Jul 2008 12:31:16 -0400
Subject: [PATCH] don't get a count from query

darcs-hash:20080722163116-84dde-3b17b13022b3d97483e911a99ebd23cc4b8da784.gz
---
 actions/all.php  | 24 +++++++++++++-----------
 classes/User.php | 12 ++++++------
 2 files changed, 19 insertions(+), 17 deletions(-)

diff --git a/actions/all.php b/actions/all.php
index 944fec6d4b..ca592a4eb0 100644
--- a/actions/all.php
+++ b/actions/all.php
@@ -78,20 +78,22 @@ class AllAction extends StreamAction {
 			$page = 1;
 		}
 		
-		list($cnt, $notice) = $user->noticesWithFriends(($page-1)*NOTICES_PER_PAGE, NOTICES_PER_PAGE + 1);
+		$notice = $user->noticesWithFriends(($page-1)*NOTICES_PER_PAGE, NOTICES_PER_PAGE + 1);
 											
-		if ($cnt > 0) {
-			common_element_start('ul', array('id' => 'notices'));
-			for ($i = 0; $i < min($cnt, NOTICES_PER_PAGE); $i++) {
-				if ($notice->fetch()) {
-					$this->show_notice($notice);
-				} else {
-					// shouldn't happen!
-					break;
-				}
+		common_element_start('ul', array('id' => 'notices'));
+		
+		$cnt = 0;
+		
+		while ($notice->fetch() && $cnt <= NOTICES_PER_PAGE) {
+			$cnt++;
+			
+			if ($cnt > NOTICES_PER_PAGE) {
+				break;
 			}
-			common_element_end('ul');
+			
+			$this->show_notice($notice);
 		}
+		common_element_end('ul');
 
 		common_pagination($page > 1, $cnt > NOTICES_PER_PAGE,
 						  $page, 'all', array('nickname' => $profile->nickname));
diff --git a/classes/User.php b/classes/User.php
index 7da483653f..b6689761ee 100644
--- a/classes/User.php
+++ b/classes/User.php
@@ -133,12 +133,12 @@ class User extends DB_DataObject
 		
 		$notice = new Notice();
 		
-		$cnt = $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);
+		$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 array($cnt, $notice);
+		return $notice;
 	}
 }
-- 
2.39.5