From a2d799815a95e9c76e81525d1007b38971662e6d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 3 Oct 2010 12:19:09 +0400 Subject: remove unnecessary mentions of global_purge_old_posts; add debugging to purge_orphans() --- functions.php | 25 ++++++++++++------------- 1 file changed, 12 insertions(+), 13 deletions(-) (limited to 'functions.php') diff --git a/functions.php b/functions.php index 115bdfebd..cdbfa4cae 100644 --- a/functions.php +++ b/functions.php @@ -228,7 +228,7 @@ } // function purge_feed /** - * Purge old posts from old feeds. + * Purge old posts from old feeds. Not used anymore, purging is done after feed update. * * @param mixed $link A database connection * @param boolean $do_output Set to true to enable printed output, false by default. @@ -236,7 +236,7 @@ * @access public * @return void */ - function global_purge_old_posts($link, $do_output = false, $limit = false) { + /* function global_purge_old_posts($link, $do_output = false, $limit = false) { $random_qpart = sql_random_function(); @@ -276,16 +276,9 @@ } } - // purge orphaned posts in main content table - $result = db_query($link, "DELETE FROM ttrss_entries WHERE - (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); - - if ($do_output) { - $rows = db_affected_rows($link, $result); - _debug("Purged $rows orphaned posts."); - } + purge_orphans($link, $do_output); - } // function global_purge_old_posts + } // function global_purge_old_posts */ function feed_purge_interval($link, $feed_id) { @@ -328,10 +321,16 @@ purge_orphans($link); } - function purge_orphans($link) { + function purge_orphans($link, $do_output = false) { + // purge orphaned posts in main content table - db_query($link, "DELETE FROM ttrss_entries WHERE + $result = db_query($link, "DELETE FROM ttrss_entries WHERE (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); + + if ($do_output) { + $rows = db_affected_rows($link, $result); + _debug("Purged $rows orphaned posts."); + } } function get_feed_update_interval($link, $feed_id) { -- cgit v1.2.3