| | |
| | | */ |
| | | $domain = $this->dataRecord['domain']; |
| | | |
| | | $sql = "SELECT id FROM dns_soa WHERE origin = '" . $app->db->quote($domain.".") . "'"; |
| | | $res = $app->db->queryOneRecord($sql); |
| | | $sql = "SELECT id FROM dns_soa WHERE origin = ?"; |
| | | $res = $app->db->queryOneRecord($sql, $domain."."); |
| | | if (is_array($res)){ |
| | | $app->error($wb['error_domain_in dnsuse']); |
| | | } |
| | | |
| | | $sql = "SELECT id FROM dns_slave WHERE origin = '" . $app->db->quote($domain.".") . "'"; |
| | | $res = $app->db->queryOneRecord($sql); |
| | | $sql = "SELECT id FROM dns_slave WHERE origin = ?"; |
| | | $res = $app->db->queryOneRecord($sql, $domain."."); |
| | | if (is_array($res)){ |
| | | $app->error($wb['error_domain_in dnsslaveuse']); |
| | | } |
| | | |
| | | $sql = "SELECT domain_id FROM mail_domain WHERE domain = '" . $app->db->quote($domain) . "'"; |
| | | $res = $app->db->queryOneRecord($sql); |
| | | $sql = "SELECT domain_id FROM mail_domain WHERE domain = ?"; |
| | | $res = $app->db->queryOneRecord($sql, $domain); |
| | | if (is_array($res)){ |
| | | $app->error($wb['error_domain_in mailuse']); |
| | | } |
| | | |
| | | $sql = "SELECT domain_id FROM web_domain WHERE (domain = '" . $app->db->quote($domain) . "' AND type IN ('alias', 'vhost', 'vhostalias')) OR (domain LIKE '%." . $app->db->quote($domain) . "' AND type IN ('subdomain', 'vhostsubdomain'))"; |
| | | $res = $app->db->queryOneRecord($sql); |
| | | $sql = "SELECT domain_id FROM web_domain WHERE (domain = ? AND type IN ('alias', 'vhost', 'vhostalias')) OR (domain LIKE ? AND type IN ('subdomain', 'vhostsubdomain'))"; |
| | | $res = $app->db->queryOneRecord($sql, $domain, '%.' . $domain); |
| | | if (is_array($res)){ |
| | | $app->error($wb['error_domain_in webuse']); |
| | | } |