fix operator for paging

1 files changed, 10 insertions, 3 deletions

diff --git a/db/itemmapper.php b/db/itemmapper.php
index ff17596c2..d3c8164ae 100644
--- a/db/itemmapper.php
+++ b/db/itemmapper.php
@@ -166,12 +166,19 @@ class ItemMapper extends Mapper implements IMapper {
 		return $this->findEntities($sql, $params);
 	}
 
+	private function getOperator($oldestFirst) {
+		if($oldestFirst) {
+			return '>';
+		} else {
+			return '<';
+		}
+	}
 
 	public function findAllFeed($id, $limit, $offset, $status, $userId, $oldestFirst=false){
 		$params = [$userId, $id];
 		$sql = 'AND `items`.`feed_id` = ? ';
 		if($offset !== 0){
-			$sql .= 'AND `items`.`id` < ? ';
+			$sql .= 'AND `items`.`id` ' . $this->getOperator($oldestFirst) . ' ? ';
 			$params[] = $offset;
 		}
 		$sql = $this->makeSelectQueryStatus($sql, $status, $oldestFirst);
@@ -183,7 +190,7 @@ class ItemMapper extends Mapper implements IMapper {
 		$params = [$userId, $id];
 		$sql = 'AND `feeds`.`folder_id` = ? ';
 		if($offset !== 0){
-			$sql .= 'AND `items`.`id` < ? ';
+			$sql .= 'AND `items`.`id` ' . $this->getOperator($oldestFirst) . ' ? ';
 			$params[] = $offset;
 		}
 		$sql = $this->makeSelectQueryStatus($sql, $status, $oldestFirst);
@@ -195,7 +202,7 @@ class ItemMapper extends Mapper implements IMapper {
 		$params = [$userId];
 		$sql = '';
 		if($offset !== 0){
-			$sql .= 'AND `items`.`id` < ? ';
+			$sql .= 'AND `items`.`id` ' . $this->getOperator($oldestFirst) . ' ? ';
 			$params[] = $offset;
 		}
 		$sql = $this->makeSelectQueryStatus($sql, $status, $oldestFirst);