From 585667bdf4a06a7bcde1b7d2b9b42059135343dc Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Fri, 22 Mar 2013 13:47:45 +0100 Subject: dont add feed twice --- db/feedmapper.php | 18 ++++++++++-------- 1 file changed, 10 insertions(+), 8 deletions(-) (limited to 'db/feedmapper.php') diff --git a/db/feedmapper.php b/db/feedmapper.php index 0fc8d3114..131eb2090 100644 --- a/db/feedmapper.php +++ b/db/feedmapper.php @@ -84,16 +84,18 @@ class FeedMapper extends Mapper implements IMapper { } - public function getStarredCount($userId){ - $sql = 'SELECT COUNT(*) AS size FROM `*dbprefix*news_feeds` ' . - 'AND `user_id` = ? ' . - 'AND ((`status` & ?) > 0)'; - $params = array($userId, StatusFlag::STARRED); + public function findByUrlHash($hash, $userId){ + $sql = 'SELECT * FROM `*dbprefix*news_feeds` ' . + 'WHERE `url_hash` = ? ' . + 'AND `user_id` = ?'; + $params = array($hash, $userId); - $result = $this->execute($sql, $params)->fetchRow(); + $row = $this->findQuery($sql, $params); + $feed = new Feed(); + $feed->fromRow($row); - return $result['size']; - } + return $feed; + } } \ No newline at end of file -- cgit v1.2.3