diff options
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index ef86e551a..d68b1fbec 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -13,7 +13,7 @@ namespace OCA\News\Db; -use \OCP\IDBConnection; +use OCP\IDBConnection; class ItemMapper extends NewsMapper { @@ -328,4 +328,16 @@ class ItemMapper extends NewsMapper { } + /** + * Returns a list of ids and userid of all items + */ + public function findAllItemIdsAndUsers() { + $sql = 'SELECT `items`.`id`, `feeds`.`user_id` ' . + 'FROM `*PREFIX*news_items` `items` ' . + 'JOIN `*PREFIX*news_feeds` `feeds` ' . + 'ON `items`.`feed_id` = `feeds`.`id`'; + return $this->execute($sql)->fetchAll(); + } + + } |