X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttOrgHelper.class.php;h=3145d1d7ea865db8d0530a6c0b9ab1efd1b4590e;hb=d79981a845ee5c1e6dd404ee221d97a539f0aac8;hp=f77d1eb6e1f37b574f9e81418c866b42c4d436ff;hpb=059ee30555153c4a73ee68f80c78351f15feb723;p=timetracker.git diff --git a/WEB-INF/lib/ttOrgHelper.class.php b/WEB-INF/lib/ttOrgHelper.class.php index f77d1eb6..3145d1d7 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 5 for now). + // The getInactiveOrgs is a maintenance function that returns an array of inactive organization ids (max 10 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 where org_id > 0 group by org_id order by last_access, org_id) as t". - " where last_access is null or last_access < $cutoff_timestamp limit 5"; // Max 5 orgs at a time for now... + " where last_access is null or last_access < $cutoff_timestamp limit 10"; // Max 10 orgs at a time for now... $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -94,6 +94,7 @@ class ttOrgHelper { 'tt_config', 'tt_cron', 'tt_fav_reports', + 'tt_templates', 'tt_monthly_quotas', 'tt_predefined_expenses', 'tt_expense_items', @@ -101,6 +102,7 @@ class ttOrgHelper { 'tt_custom_field_options', 'tt_custom_fields', 'tt_log', + 'tt_timesheets', // TODO: check if order is correct. After doing export. 'tt_invoices', 'tt_user_project_binds', 'tt_users',