diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-05 16:06:04 +0200 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-04-05 16:06:04 +0200 |
commit | c6a279128ea6483fb06e052d4e85fba75e9e7fe1 (patch) | |
tree | 1700edcad069721f20b263d63d345b7c65b15b67 /db/itemmapper.php | |
parent | 685ff350eb6c91fd8f48d31a4ba6a815d5f6e403 (diff) |
fix #37 by fixing multiple, hard to track down typos
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 35 |
1 files changed, 33 insertions, 2 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index af190cd27..76364283d 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -37,7 +37,36 @@ class ItemMapper extends Mapper implements IMapper { protected function findAllRows($sql, $params, $limit=null, $offset=null) { + /*echo $sql . '<br>'; + + print_r($params); + echo '<br>';*/ + /* works + $sql = 'SELECT `items`.* + FROM `*PREFIX*news_items` `items` + JOIN `*PREFIX*news_feeds` `feeds` + ON `feeds`.`id` = `items`.`feed_id` + AND `feeds`.`user_id` = \'admin\' + AND ((`items`.`status` & 2) = 2) + AND `items`.`feed_id` = 20 + ORDER BY `items`.`id` DESC'; + $params = array();*/ + + /* works not */ + /*$params = array('admin', 2, 2, 20); + $sql = 'SELECT `items`.* + FROM `*PREFIX*news_items` `items` + JOIN `*PREFIX*news_feeds` `feeds` + ON `feeds`.`id` = `items`.`feed_id` + AND `feeds`.`user_id` = ? + AND ((`items`.`status` & ?) = ?) + AND `items`.`feed_id` = ? + ORDER BY `items`.`id` DESC';*/ + + //$result = \OCP\DB::prepare($sql, $limit, $offset)->execute($params); $result = $this->execute($sql, $params, $limit, $offset); + + $items = array(); while($row = $result->fetchRow()){ @@ -47,6 +76,8 @@ class ItemMapper extends Mapper implements IMapper { array_push($items, $item); } + //print_r($items); + return $items; } @@ -67,7 +98,7 @@ class ItemMapper extends Mapper implements IMapper { public function find($id, $userId){ - $sql = $this->makeSelectQuery('AND `*PREFIX*news_items`.`id` = ? '); + $sql = $this->makeSelectQuery('AND `items`.`id` = ? '); $row = $this->findOneQuery($sql, array($userId, $id)); $item = new Item(); @@ -173,7 +204,7 @@ class ItemMapper extends Mapper implements IMapper { public function findByGuidHash($guidHash, $feedId, $userId){ $sql = $this->makeSelectQuery( 'AND `items`.`guid_hash` = ? ' . - 'AND `feed`.`id = ? '); + 'AND `feeds`.`id` = ? '); $row = $this->findOneQuery($sql, array($userId, $guidHash, $feedId)); $item = new Item(); |