static function CheckCreateForErrors($address, $domain, $destination) { global $zdbh; global $controller; $fulladdress = $address . "@" . $domain; $destination = strtolower(str_replace(' ', '', $destination)); if (fs_director::CheckForEmptyValue($address)) { self::$noaddress = true; return false; } if (!self::IsValidEmail($fulladdress)) { self::$validemail = true; return false; } if (!self::IsValidDomain($domain)) { self::$validdomain = true; return false; } $sql = "SELECT * FROM x_mailboxes WHERE mb_address_vc=:fulladdress AND mb_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexists = true; return false; } $sql = "SELECT * FROM x_forwarders WHERE fw_address_vc=:fulladdress AND fw_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexists = true; return false; } $sql = "SELECT * FROM x_forwarders WHERE fw_destination_vc=:fulladdress AND fw_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexists = true; return false; } $sql = "SELECT * FROM x_distlists WHERE dl_address_vc=:fulladdress AND dl_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexists = true; return false; } $sql = "SELECT * FROM x_aliases WHERE al_address_vc=:fulladdress AND al_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexists = true; return false; } return true; }
static function CheckCreateForErrors($address, $dname, $ddomain, $keepmessage) { global $controller; $address = $controller->GetControllerRequest('FORM', 'inAddress'); $destination = strtolower(str_replace(' ', '', $dname . '@' . $ddomain)); if (fs_director::CheckForEmptyValue($address)) { self::$noaddress = true; return false; } if (!self::IsValidEmail($destination)) { self::$validemail = true; return false; } if ($address == $destination) { self::$alreadyexistssame = true; return false; } return true; }
static function CheckCreateForErrorsDistListUser() { global $zdbh; global $controller; $address = $controller->GetControllerRequest('FORM', 'inAddAddress'); $domain = $controller->GetControllerRequest('FORM', 'inAddDomain'); $dlid = $controller->GetControllerRequest('FORM', 'inDLID'); $fulladdress = strtolower(str_replace(' ', '', $address . '@' . $domain)); if (fs_director::CheckForEmptyValue($address)) { self::$noaddress = true; return false; } if (!self::IsValidEmail($fulladdress)) { self::$validemail = true; return false; } $sql = "SELECT * FROM x_distlistusers WHERE du_distlist_fk=:dlid AND du_address_vc=:fulladdress AND du_deleted_ts IS NULL"; $numrows = $zdbh->prepare($sql); $numrows->bindParam(':dlid', $dlid); $numrows->bindParam(':fulladdress', $fulladdress); $numrows->execute(); if ($numrows->fetchColumn() != 0) { self::$alreadyexistsdu = true; return false; } return true; }