summaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorBernhard Posselt <nukeawhale@gmail.com>2013-03-25 12:54:38 +0100
committerBernhard Posselt <nukeawhale@gmail.com>2013-03-25 12:54:38 +0100
commit0f9e0e3de77de68cc75ccd69395665f9e1346951 (patch)
treebe6398f7134c3192e4ee0f89a88cbbfadfffc808 /db
parent77ec6f08aa4fb223fba859ca0f6060e84006da43 (diff)
implemented feed update
Diffstat (limited to 'db')
-rw-r--r--db/itemmapper.php16
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;
+ }
+
+
}