$userObject->Get($userID);
$domainObject = new Object();
$domainObject->Get($domainID);
$userObject = clone $_SESSION['UserObject'];
$cvType = $cvTypes[$cvTypeID]->description();
$emailToAddress = $contactManager->GetDatabaseMonitors();
$emailFromAddress = "*****@*****.**";
$emailFromName = "iEMS at CRS, Inc.";
$emailReplyToAddress = "*****@*****.**";
$emailSubject = "iEMS: Contact Management Updates for " . $contactProfile->object()->description();
$emailBody = "User " . $userObject->fullName() . " of " . $userObject->Domains(0)->description() . " added the " . $contactUse->description() . " " . $cvType . " contact of " . $contactValue . " for owner of " . $ownerName . " with a priority of " . $priority->level() . " to the contact profile " . $object->description() . " at " . date("H:i:s") . " on " . date("l, F j, Y") . ".";
$emailAttachments = "";
$messageIdentifier = "iEMS" . "." . $userID . "." . $domainID . "." . date("Ymd.His");
//echo "emailToAddress='{$emailToAddress}'<br>\nemailBody='{$emailBody}'<br>\nmessageIdentifier='$messageIdentifier'<br>\n";
$emailQueue = new EmailQueue(0, $emailToAddress, $emailFromAddress, $emailFromName, $emailReplyToAddress, $emailSubject, $emailBody, "", 0, 0, 0, $messageIdentifier, 0, $userID);
$emailQueue->Put();
print viewProfiles($userID, $domainID, null, $emailBody);
}
}
function viewProfiles($userID, $domainID, $errorMessage = null, $alertMessage = null)
{
if (isset($_POST['ContactUse'])) {
$contactUse = $_POST['ContactUse'];
$basicProfiles = $_POST['basicProfiles'];
$_SESSION['ContactUse'] = $contactUse;
$_SESSION['basicProfiles'] = $basicProfiles;
} else {
$contactUse = $_SESSION['ContactUse'];
$basicProfiles = $_SESSION['basicProfiles'];
}
$vpSpin = 0;
function GetDatabaseMonitors()
{
$sql = "select\n cv.ContactValue\n from\n t_objects ldo,\n t_objecttypes ldot,\n t_objects mdo,\n t_objecttypes mdot,\n t_objectxrefs ldx,\n t_objectxrefs lmx,\n t_objectxrefs mdx,\n t_objectxrefs cmx,\n t_contactprofiles cp,\n t_contactuses cu,\n t_contactvalues cv,\n t_contactvaluetypes cvt,\n t_priorities p\n where\n ldx.ChildObjectID = {$this->p_domainID} and\n ldo.ObjectID = ldx.ParentObjectID and\n ldot.ObjectTypeID = ldo.ObjectTypeID and\n ldot.ObjectTypeName = 'domain' and\n lmx.ChildObjectID = ldx.ParentObjectID and\n mdx.ChildObjectID = lmx.ParentObjectID and\n mdx.ParentObjectID = mdx.ChildObjectID and\n mdo.ObjectID = mdx.ParentObjectID and\n mdot.ObjectTypeID = mdo.ObjectTypeID and\n mdot.ObjectTypeName = 'domain' and\n cmx.ParentObjectID = mdo.ObjectID and\n cp.ObjectID = cmx.ChildObjectID and\n cp.IsInactive = 0 and\n cu.ContactUseID = cp.ContactUseID and\n cu.ContactUseName = 'database_monitoring' and\n cv.ContactValueID = cp.ContactValueID and\n cvt.ContactValueTypeID = cv.ContactValueTypeID and\n cvt.ContactValueTypeName = 'email' and\n cv.IsInactive = 0 and\n p.PriorityID = cp.PriorityID\n order by\n p.PriorityLevel";
$result = mysql_query($sql, $this->sqlMasterConnection());
$this->p_databaseMonitors = "";
while ($row = mysql_fetch_assoc($result)) {
$this->p_databaseMonitors .= $row['ContactValue'] . ", ";
}
if (strlen($this->p_databaseMonitors)) {
$this->p_databaseMonitors = substr($this->p_databaseMonitors, 0, strlen($this->p_databaseMonitors) - 2);
}
if (!strlen($this->p_databaseMonitors)) {
$emailQueue = new EmailQueue(0, "*****@*****.**", "*****@*****.**", "iEMS at CRS, Inc.", "*****@*****.**", "CRS_ERROR: iEMS Contact Management Error", "No Database Monitor email addresses found for domain {$this->p_domainID}\n\n" . "sql=\n{$sql}", "", 0, 0, 0, "IEMS." . date("Y-m-d.His"), 0, 1);
$emailQueue->Put();
}
return $this->p_databaseMonitors;
}
