diff options
| author | bluehaze <francesco.sportolari@gmail.com> | 2013-07-01 14:32:22 +0200 |
|---|---|---|
| committer | bluehaze <francesco.sportolari@gmail.com> | 2013-07-01 14:32:22 +0200 |
| commit | 8366f4c4550fd00d869a4836379c2776544e564f (patch) | |
| tree | 9e6ed5700bae86275defbad7d63cef43a0b4b564 /db | |
| parent | 27c109e98ffa127f67e0dbe9ba641684f7dd339a (diff) | |
Modified readAll, readFolder and readFeed SQL queries
Diffstat (limited to 'db')
| -rw-r--r-- | db/itemmapper.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 512de4c88..411396a65 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -124,7 +124,7 @@ class ItemMapper extends Mapper implements IMapper { public function readAll($highestItemId, $time, $userId) { $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` IN (' . 'SELECT `id` FROM `*PREFIX*news_feeds` ' . 'WHERE `user_id` = ? ' . @@ -138,7 +138,7 @@ class ItemMapper extends Mapper implements IMapper { public function readFolder($folderId, $highestItemId, $time, $userId) { $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` IN (' . 'SELECT `id` FROM `*PREFIX*news_feeds` ' . 'WHERE `folder_id` = ? ' . @@ -154,7 +154,7 @@ class ItemMapper extends Mapper implements IMapper { public function readFeed($feedId, $highestItemId, $time, $userId){ $sql = 'UPDATE `*PREFIX*news_items` ' . 'SET `status` = `status` & ? ' . - 'AND `last_modified` = ? ' . + ', `last_modified` = ? ' . 'WHERE `feed_id` = ? ' . 'AND `id` <= ? ' . 'AND EXISTS (' . |