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 10 for now).
static function getInactiveOrgs() {
$inactive_orgs = array();
$mdb2 = getConnection();
// Determine inactive organizations by querying the database for max access timestamp for its users.
$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...
+ " (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 10"; // Max 10 orgs at a time for now...
$res = $mdb2->query($sql);
if (!is_a($res, 'PEAR_Error')) {
while ($val = $res->fetchRow()) {
'tt_config',
'tt_cron',
'tt_fav_reports',
+ 'tt_templates',
'tt_monthly_quotas',
'tt_predefined_expenses',
'tt_expense_items',
'tt_custom_fields',
'tt_log',
'tt_invoices',
+ 'tt_timesheets',
'tt_user_project_binds',
'tt_users',
'tt_client_project_binds',