$nsProduct->Redir("no_permission", "", "error");
}
/////////////////////////////////////////////
///////// call any process functions
if (!$nsUser->DEMO) {
if (!$HostId && ValidArr($EditArr) && ValidVar($EditId) == "new") {
CreateCompany($EditArr);
}
if (!$HostId && ValidArr($EditArr) && ValidId($EditId)) {
UpdateCompany($EditId, $EditArr);
}
if (ValidId($DeleteId)) {
DeleteCompany($DeleteId);
}
if (ValidId($DeleteHost)) {
DeleteHost($EditId, $DeleteHost);
}
if ($HostId == "new" && ValidArr($EditArr)) {
CreateNewHost($EditId, $EditArr);
}
if (ValidId($HostId) && !ValidVar($EditPage) && !ValidVar($EditEvent) && ValidArr($EditArr)) {
UpdateHost($HostId, $EditArr);
}
if ($EditPage == "new" && ValidArr($EditArr)) {
AddSitePage($HostId, $EditArr);
}
if (ValidId($EditPage) && ValidArr($EditArr)) {
UpdatePage($EditPage, $EditArr);
}
if (ValidId($DeletePage)) {
DeletePage($DeletePage);
function DeleteCompany($Id, $NoRedir = false)
{
global $Db, $nsProduct, $Logs, $Lang;
$Users = array();
$Query = "SELECT USER_ID FROM " . PFX . "_tracker_user WHERE COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
$Users[] = $Row->USER_ID;
}
for ($i = 0; $i < count($Users); $i++) {
$Query = "DELETE FROM " . PFX . "_system_user WHERE ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_column WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_settings WHERE USER_ID = " . $Users[$i];
$Db->Query($Query);
}
$Query = "SELECT ID FROM " . PFX . "_tracker_site WHERE COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
DeleteHost($Id, $Row->ID, false, true);
}
DeleteCompanyActions($Id);
DeleteCompanySaleItems($Id);
$Query = "SELECT ID FROM " . PFX . "_tracker_campaign WHERE PARENT_ID=0 AND COMPANY_ID={$Id}";
$Sql = new Query($Query);
while ($Row = $Sql->Row()) {
DeleteCampaign($Row->ID, true);
}
$Query = "DELETE FROM " . PFX . "_tracker_config WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_const_group WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_user_report WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
$Query = "DELETE FROM " . PFX . "_tracker_watch WHERE COMPANY_ID={$Id}";
$Db->Query($Query);
DropStatTables($Id);
$Query = "DELETE FROM " . PFX . "_tracker_client WHERE ID = {$Id}";
$Db->Query($Query);
if (!$NoRedir) {
$nsProduct->Redir("company", "RDlt=1");
}
}
function DeleteHosts($Arr)
{
foreach ($Arr as $Key => $Value) {
if ($Value != 1) {
continue;
}
DeleteHost($Key);
}
}
