summaryrefslogtreecommitdiffstats
path: root/db/itemmapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'db/itemmapper.php')
-rw-r--r--db/itemmapper.php16
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));
+ }
+
+
}