$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; }