X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=dbinstall.php;h=264fc379d229f113d62557a73f0ddf3ee51ed48a;hb=80d8ba7ca7444b575edc4930ee45e46dca66144b;hp=6818e0d3e48b4b1a75c2e07f592dabb8e3edb475;hpb=94081b97e54440c0d7b1b5b3f2faf0db4f0c4687;p=timetracker.git diff --git a/dbinstall.php b/dbinstall.php index 6818e0d3..264fc379 100644 --- a/dbinstall.php +++ b/dbinstall.php @@ -1036,18 +1036,19 @@ if ($_POST) { setChange("update `tt_custom_field_options` cfo inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.23') inner join `tt_custom_fields` cf on cf.id = cfo.field_id set cfo.group_id = cf.group_id, cfo.org_id = cf.org_id where cfo.org_id is null"); setChange("update `tt_custom_field_log` cfl inner join `tt_site_config` sc on (sc.param_name = 'version_db' and sc.param_value = '1.18.23') inner join `tt_custom_fields` cf on cf.id = cfl.field_id set cfl.group_id = cf.group_id, cfl.org_id = cf.org_id where cfl.org_id is null"); setChange("ALTER TABLE `tt_custom_field_options` ADD `status` tinyint(4) default '1' after `value`"); + setChange("UPDATE `tt_site_config` SET param_value = '1.18.24', modified = now() where param_name = 'version_db' and param_value = '1.18.23'"); } if ($_POST["cleanup"]) { $mdb2 = getConnection(); - $inactive_groups = ttOrgHelper::getInactiveOrgs(); + $inactive_orgs = ttOrgHelper::getInactiveOrgs(); - $count = count($inactive_groups); - print "$count inactive groups found...
\n"; + $count = count($inactive_orgs); + print "$count inactive organizations found...
\n"; for ($i = 0; $i < $count; $i++) { - print " deleting group ".$inactive_groups[$i]."
\n"; - $res = ttTeamHelper::delete($inactive_groups[$i]); // TODO: rewrite this to delete subgroups, too. + print " deleting organization ".$inactive_orgs[$i]."
\n"; + $res = ttOrgHelper::deleteOrg($inactive_orgs[$i]); } setChange("OPTIMIZE TABLE tt_client_project_binds");