summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorBernhard Posselt <nukeawhale@gmail.com>2013-04-16 15:19:05 +0200
committerBernhard Posselt <nukeawhale@gmail.com>2013-04-16 15:23:12 +0200
commitdee17d002d87667f7d0f4478e1f0180135618c38 (patch)
treed71c6896bd558b28fa16af0c424b2f4d1aca768c /db
parent8df6d36d49d89f3bb7186b36436606adb039b3f8 (diff)
dont show unread count when it is 0, dont bold read feeds, implemented autopaging
Diffstat (limited to 'db')
-rw-r--r--db/itemmapper.php6
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 ';