diff options
| author | Sean Molenaar <sean@seanmolenaar.eu> | 2020-10-04 20:45:33 +0200 |
|---|---|---|
| committer | Benjamin Brahmer <info@b-brahmer.de> | 2020-11-03 19:58:37 +0100 |
| commit | 10e8c28feaf6d858948285a291231f651ef74728 (patch) | |
| tree | 5c48216dc1ce6a6dd8f292d489bb4a7d03cb5595 /lib/Db/FeedMapper.php | |
| parent | 361cfa55b7302b29e158647060085550b9a3dfe1 (diff) | |
Add migration with foreign keys
Closes #829
Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
Diffstat (limited to 'lib/Db/FeedMapper.php')
| -rw-r--r-- | lib/Db/FeedMapper.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/Db/FeedMapper.php b/lib/Db/FeedMapper.php index 867ba982d..193cf1f5d 100644 --- a/lib/Db/FeedMapper.php +++ b/lib/Db/FeedMapper.php @@ -77,7 +77,7 @@ class FeedMapper extends NewsMapper // think twice when changing this 'AND `items`.`unread` = ? ' . 'WHERE `feeds`.`user_id` = ? ' . - 'AND (`feeds`.`folder_id` = 0 ' . + 'AND (`feeds`.`folder_id` IS NULL ' . 'OR `folders`.`deleted_at` = 0 ' . ') ' . 'AND `feeds`.`deleted_at` = 0 ' . @@ -106,7 +106,7 @@ class FeedMapper extends NewsMapper // POSSIBLE SQL INJECTION RISK WHEN MODIFIED WITHOUT THOUGHT. // think twice when changing this 'AND `items`.`unread` = ? ' . - 'WHERE (`feeds`.`folder_id` = 0 ' . + 'WHERE (`feeds`.`folder_id` IS NULL ' . 'OR `folders`.`deleted_at` = 0 ' . ') ' . 'AND `feeds`.`deleted_at` = 0 ' . |