From dee17d002d87667f7d0f4478e1f0180135618c38 Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Tue, 16 Apr 2013 15:19:05 +0200 Subject: dont show unread count when it is 0, dont bold read feeds, implemented autopaging --- db/itemmapper.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/itemmapper.php b/db/itemmapper.php index 077614695..bffab6348 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -158,7 +158,7 @@ class ItemMapper extends Mapper implements IMapper { $params = array($userId, $id); $sql = 'AND `items`.`feed_id` = ? '; if($offset !== 0){ - $sql .= 'AND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` < ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; @@ -171,7 +171,7 @@ class ItemMapper extends Mapper implements IMapper { $params = array($userId, $id); $sql = 'AND `feeds`.`folder_id` = ? '; if($offset !== 0){ - $sql .= 'AND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` < ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; @@ -184,7 +184,7 @@ class ItemMapper extends Mapper implements IMapper { $params = array($userId); $sql = ''; if($offset !== 0){ - $sql .= 'AND `items`.`id` > ? '; + $sql .= 'AND `items`.`id` < ? '; array_push($params, $offset); } $sql .= 'ORDER BY `items`.`id` DESC '; -- cgit v1.2.3