move to Article:

+       static function purge_orphans($do_output = false) {

move to Feeds

+       static function getGlobalUnread($user_id = false) {
+       static function getCategoryTitle($cat_id) {
+       static function getLabelUnread($label_id, $owner_uid = false) {

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.");
+		}
+	}
+
+
 }