function EasySCP_Powerdns_main_configuration_file() { $CreatePDNSPass = DaemonConfigDNS::CreatePDNSPass(); if ($CreatePDNSPass !== true) { return $CreatePDNSPass; } $SavePDNSConfig = DaemonConfigDNS::SavePDNSConfig(); if ($SavePDNSConfig !== true) { return $SavePDNSConfig; } // Creating Panel Main DNS config $sql_param = array(':domain_name' => DaemonConfig::$cfg->{'SERVER_HOSTNAME'}, ':easyscp_domain_id' => '0'); $sql_query = "\n\t\t\tINSERT INTO\n\t\t\t\tpowerdns.domains (easyscp_domain_id, name, type)\n\t\t\tVALUES\n\t\t\t\t(:easyscp_domain_id, :domain_name, 'NATIVE')\n\t\t\t ON DUPLICATE KEY UPDATE\n\t\t\t \tname = :domain_name;\n\t\t"; DB::prepare($sql_query); DB::execute($sql_param)->closeCursor(); $dmn_dns_id = 1; $dmn_name = DaemonConfig::$cfg->{'SERVER_HOSTNAME'}; $dmn_ip = DaemonConfig::$cfg->BASE_SERVER_IP; $sql_param = array(); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => $dmn_name, 'domain_type' => 'SOA', 'domain_content' => 'ns1.' . $dmn_name . '. ' . DaemonConfig::$cfg->{'DEFAULT_ADMIN_ADDRESS'} . ' ' . time() . ' 12000 1800 604800 86400', 'domain_ttl' => '3600', 'domain_prio' => Null); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => 'ns1.' . $dmn_name, 'domain_type' => 'A', 'domain_content' => $dmn_ip, 'domain_ttl' => '7200', 'domain_prio' => NULL); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => $dmn_name, 'domain_type' => 'NS', 'domain_content' => 'ns1.' . $dmn_name, 'domain_ttl' => '28800', 'domain_prio' => NULL); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => 'ns.' . $dmn_name, 'domain_type' => 'CNAME', 'domain_content' => 'ns1.' . $dmn_name, 'domain_ttl' => '7200', 'domain_prio' => NULL); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => $dmn_name, 'domain_type' => 'A', 'domain_content' => $dmn_ip, 'domain_ttl' => '7200', 'domain_prio' => NULL); $sql_param[] = array('domain_id' => $dmn_dns_id, 'domain_name' => DaemonConfig::$cfg->{'BASE_SERVER_VHOST'}, 'domain_type' => 'A', 'domain_content' => $dmn_ip, 'domain_ttl' => '7200', 'domain_prio' => NULL); $sql_query = "\n\t\t\tINSERT INTO\n\t\t\t\tpowerdns.records (domain_id, name, type, content, ttl, prio)\n\t\t\tVALUES\n\t\t\t\t(:domain_id, :domain_name, :domain_type, :domain_content, :domain_ttl, :domain_prio)\n\t\t\tON DUPLICATE KEY UPDATE\n\t\t\t \tname = :domain_name;\n\t\t"; $stmt = DB::prepare($sql_query); foreach ($sql_param as $data) { $stmt->execute($data); } $stmt = Null; unset($stmt); return 'Ok'; }