diff options
Diffstat (limited to 'classes/article.php')
-rw-r--r-- | classes/article.php | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/classes/article.php b/classes/article.php index e0c8d3e6d..64c04e140 100644 --- a/classes/article.php +++ b/classes/article.php @@ -864,4 +864,17 @@ class Article extends Handler_Protected { return $rv; } + static function purge_orphans($do_output = false) { + + // purge orphaned posts in main content table + $result = db_query("DELETE FROM ttrss_entries WHERE + NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id)"); + + if ($do_output) { + $rows = db_affected_rows($result); + _debug("Purged $rows orphaned posts."); + } + } + + } |