diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-25 12:54:38 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-25 12:54:38 +0100 |
commit | 0f9e0e3de77de68cc75ccd69395665f9e1346951 (patch) | |
tree | be6398f7134c3192e4ee0f89a88cbbfadfffc808 /db | |
parent | 77ec6f08aa4fb223fba859ca0f6060e84006da43 (diff) |
implemented feed update
Diffstat (limited to 'db')
-rw-r--r-- | db/itemmapper.php | 16 |
1 files changed, 14 insertions, 2 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 0d9469c9d..8f200c39e 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -67,8 +67,8 @@ class ItemMapper extends Mapper implements IMapper { public function find($id, $userId){ - $sql = $this->makeSelectQuery('WHERE `*PREFIX*news_items`.`id` = ? '); - $row = $this->findOneQuery($sql, array($id, $userId)); + $sql = $this->makeSelectQuery('AND `*PREFIX*news_items`.`id` = ? '); + $row = $this->findOneQuery($sql, array($userId, $id)); $item = new Item(); $item->fromRow($row); @@ -168,4 +168,16 @@ class ItemMapper extends Mapper implements IMapper { return $this->findAllRows($sql, $params, $limit); } + + public function findByGuidHash($guidHash, $userId){ + $sql = $this->makeSelectQuery('AND `*PREFIX*news_items`.`guid_hash` = ? '); + $row = $this->findOneQuery($sql, array($userId, $guidHash)); + + $item = new Item(); + $item->fromRow($row); + + return $item; + } + + } |