diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-16 15:19:05 +0200 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-16 15:23:12 +0200 |
commit | dee17d002d87667f7d0f4478e1f0180135618c38 (patch) | |
tree | d71c6896bd558b28fa16af0c424b2f4d1aca768c /db/itemmapper.php | |
parent | 8df6d36d49d89f3bb7186b36436606adb039b3f8 (diff) |
dont show unread count when it is 0, dont bold read feeds, implemented autopaging
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 6 |
1 files changed, 3 insertions, 3 deletions
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 '; |