diff options
author | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-04-04 03:09:17 +0200 |
---|---|---|
committer | Bernhard Posselt <dev@bernhard-posselt.com> | 2014-04-04 03:09:26 +0200 |
commit | 57e61031877e1f921e7b4446471c61e4c5ac1b13 (patch) | |
tree | 7128e8d03cddd191113e0e8e447dcee5437d37d4 /db/itemmapper.php | |
parent | 8eedcfa1446fb6589cf57ec19ef5b5163b38b5b3 (diff) |
register hooks for deleting feeds, folders and items if a user is deleted, fix #468
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r-- | db/itemmapper.php | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/db/itemmapper.php b/db/itemmapper.php index 1ec283826..5b2ab5346 100644 --- a/db/itemmapper.php +++ b/db/itemmapper.php @@ -300,4 +300,20 @@ class ItemMapper extends Mapper implements IMapper { return (int) $result['max_id']; } + + /** + * Deletes all items of a user + * @param string $userId the name of the user + */ + public function deleteUser($userId) { + $sql = 'DELETE FROM `*PREFIX*news_items` `items` ' . + 'WHERE `items`.`feed_id` IN (' . + 'SELECT `feeds`.`id` FROM `*PREFIX*news_feeds` `feeds` ' . + 'WHERE `feeds`.`user_id` = ?' . + ')'; + + $this->execute($sql, array($userId)); + } + + } |