From 2eb17adc82261776d7bc3b19942e5e6da2778e11 Mon Sep 17 00:00:00 2001 From: Nik Okuntseff Date: Tue, 20 Nov 2018 14:53:15 +0000 Subject: [PATCH] Increased db cleanup scope to 5 orgs at a time. --- WEB-INF/lib/ttOrgHelper.class.php | 4 ++-- WEB-INF/templates/footer.tpl | 2 +- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/WEB-INF/lib/ttOrgHelper.class.php b/WEB-INF/lib/ttOrgHelper.class.php index 6d7ae678..8b3f95ff 100644 --- a/WEB-INF/lib/ttOrgHelper.class.php +++ b/WEB-INF/lib/ttOrgHelper.class.php @@ -63,7 +63,7 @@ class ttOrgHelper { return false; } - // The getInactiveOrgs is a maintenance function that returns an array of inactive organization ids (max 1 for now). + // The getInactiveOrgs is a maintenance function that returns an array of inactive organization ids (max 5 for now). static function getInactiveOrgs() { $inactive_orgs = array(); $mdb2 = getConnection(); @@ -72,7 +72,7 @@ class ttOrgHelper { $cutoff_timestamp = $mdb2->quote(date('Y-m-d', strtotime('-1 year'))); $sql = "select org_id from". " (select max(accessed) as last_access, org_id from tt_users group by org_id order by last_access, org_id) as t". - " where last_access is null or last_access < $cutoff_timestamp limit 1"; // Max 1 orgs at a time for now... + " where last_access is null or last_access < $cutoff_timestamp limit 5"; // Max 5 orgs at a time for now... $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { diff --git a/WEB-INF/templates/footer.tpl b/WEB-INF/templates/footer.tpl index c74e2d02..98ee48de 100644 --- a/WEB-INF/templates/footer.tpl +++ b/WEB-INF/templates/footer.tpl @@ -12,7 +12,7 @@
-
 Anuko Time Tracker 1.18.25.4475 | Copyright © Anuko | +  Anuko Time Tracker 1.18.25.4476 | Copyright © Anuko | {$i18n.footer.credits} | {$i18n.footer.license} | {$i18n.footer.improve} -- 2.20.1