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