finished feedmapper

1 files changed, 13 insertions, 1 deletions

diff --git a/db/feedmapper.php b/db/feedmapper.php
index 2a84574df..a2d0f8fc7 100644
--- a/db/feedmapper.php
+++ b/db/feedmapper.php
@@ -57,7 +57,7 @@ class FeedMapper extends NewsMapper {
 			$feed = new Feed();
 			$feed->fromRow($row);
 			array_push($feeds, $feed);
-		}		
+		}
 
 		return $feeds;
 	}
@@ -78,4 +78,16 @@ class FeedMapper extends NewsMapper {
 		return $this->findAllRows($sql);
 	}
 
+
+	public function getStarredCount($userId){
+		$sql = 'SELECT COUNT(*) AS size FROM `*dbprefix*news_feeds` ' .
+			'AND `user_id` = ? ' .
+			'AND ((`status` & ?) > 0)';
+		$params = array($userId, StatusFlag::STARRED);
+
+		$result = $this->execute($sql, $params)->fetchRow();
+
+		return $result['size'];
+	}
+
 }
\ No newline at end of file