public function prepare()
{
if (!isset($_GET['id']) || empty($_GET['id']) || !ENABLE_DNSSEC) {
throw new \Exception('The link you are trying to reach is no longer available or invalid.', 404);
}
$soaIDs = User::getAccessibleDomains();
if (!in_array($_GET['id'], $soaIDs)) {
throw new \Exception('Access denied. You\'re not authorized to view this page.', 403);
}
$sql = "SELECT * FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($_GET['id']));
$soa = DNS::getDB()->fetch_array($res);
$records = array();
$ds = array();
$sql = "SELECT * FROM dns_sec WHERE zone = ?";
$res = DNS::getDB()->query($sql, array($_GET['id']));
while ($row = DNS::getDB()->fetch_array($res)) {
if ($row['type'] == 'KSK') {
preg_match("/" . $soa['origin'] . " IN DNSKEY 257 3 ([0-9]+) ([\\s\\S]+)/i", $row['public'], $match);
preg_match("/; This is a key-signing key, keyid ([0-9]+), for " . $soa['origin'] . "/i", $row['public'], $match2);
if (!empty($match) && !empty($match2)) {
if ($match[1] == $row['algo']) {
$ds = DNSSECUtil::calculateDS($soa['origin'], $match[1], $match[2]);
$ds['algo'] = $match[1];
$ds['keyid'] = $match2[1];
}
}
}
$records[] = $row;
}
DNS::getTPL()->assign(array("records" => $records, "soa" => $soa, 'ds' => $ds));
}
/**
* @see \dns\system\cache\builder\AbstractCacheBuilder::rebuild()
*/
public function rebuild(array $parameters)
{
$data = array();
$sql = "SELECT * FROM dns_soa where active = ?";
$statement = DNS::getDB()->query($sql, array(1));
while ($zone = DNS::getDB()->fetch_array($statement)) {
$data[$zone['origin']] = array();
$data[$zone['origin']]['soa'] = $zone;
$data[$zone['origin']]['rr'] = array();
$data[$zone['origin']]['sec'] = array();
/* resource records */
$sql2 = "SELECT * FROM dns_rr where zone = ? and active = ?";
$statement2 = DNS::getDB()->query($sql2, array($zone['id'], 1));
while ($rr = DNS::getDB()->fetch_array($statement2)) {
$data[$zone['origin']]['rr'][] = $rr;
}
if (ENABLE_DNSSEC) {
/* dnssec keys */
$sql3 = "SELECT * FROM dns_sec where zone = ? and active = ?";
$statement3 = DNS::getDB()->query($sql3, array($zone['id'], 1));
while ($sec = DNS::getDB()->fetch_array($statement3)) {
$data[$zone['origin']]['sec'][] = $sec;
}
}
}
return $data;
}
public function prepare()
{
$sql = "SELECT * FROM dns_api WHERE userID = ?";
$res = DNS::getDB()->query($sql, array(DNS::getSession()->userID));
$row = DNS::getDB()->fetch_array($res);
$apiKey = "";
if (isset($row['apiKey'])) {
$apiKey = $row['apiKey'];
}
DNS::getTPL()->assign(array("userID" => DNS::getSession()->userID, "apiKey" => $apiKey));
}
public function prepare()
{
if (User::isReseller() === false) {
throw new \Exeption('Forbidden', 403);
}
if (isset($_POST['origin']) && isset($_POST['submit'])) {
if (!empty($_POST['origin'])) {
$idna = new idna_convert();
$origin = $_POST['origin'];
if (substr($origin, -1) != ".") {
$origin = $origin . ".";
}
$origin = $idna->encode($origin);
$serial = date("Ymd") . "01";
$sql = "SELECT * FROM dns_soa WHERE origin = ?";
$res = DNS::getDB()->query($sql, array($origin));
$soa = DNS::getDB()->fetch_array($res);
if (empty($soa)) {
$soaData = array($origin, DNS_SOA_NS, DNS_SOA_MBOX, $serial, DNS_SOA_REFRESH, DNS_SOA_RETRY, DNS_SOA_EXPIRE, DNS_SOA_MINIMUM_TTL, DNS_SOA_TTL, 1);
$sql = "INSERT INTO dns_soa (id, origin, ns, mbox, serial, refresh, retry, expire, minimum, ttl, active) VALUES (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
DNS::getDB()->query($sql, $soaData);
$soaID = DNS::getDB()->last_id();
$sql = "INSERT INTO dns_soa_to_user (id, userID, soaID) VALUES (null, ?, ?)";
DNS::getDB()->query($sql, array(DNS::getSession()->userID, $soaID));
$sql = "SELECT * FROM dns_template WHERE userID = ?";
$res = DNS::getDB()->query($sql, array(DNS::getSession()->userID));
$tpl = DNS::getDB()->fetch_array($res);
$records = array();
if (!empty($tpl) && !empty($tpl['template'])) {
$records = explode("\n", $tpl['template']);
} else {
$records = explode("\n", DNS_DEFAULT_RECORDS);
}
if (!empty($records)) {
foreach ($records as $record) {
$record = str_replace("{domain}", $origin, $record);
$record = explode(":", $record, 3);
$rrData = array($soaID, $record[0], $record[1], $record[2], $record[1] == "MX" ? 10 : 0, DNS_SOA_MINIMUM_TTL);
$sql = 'INSERT INTO dns_rr (id, zone, name, type, data, aux, ttl) VALUES (NULL, ?, ?, ?, ?, ?, ?)';
DNS::getDB()->query($sql, $rrData);
}
}
DNS::getTPL()->assign(array("error" => '', 'success' => true));
} else {
DNS::getTPL()->assign(array("error" => 'origin', 'origin' => $_POST['origin']));
}
} else {
DNS::getTPL()->assign(array("error" => 'origin'));
}
} else {
DNS::getTPL()->assign(array("error" => ''));
}
}
public function prepare()
{
if (!isset($_GET['id']) || empty($_GET['id']) || !ENABLE_DNSSEC) {
throw new \Exception('The link you are trying to reach is no longer available or invalid.', 404);
}
print_r($_REQUEST);
$soaIDs = User::getAccessibleDomains();
if (!in_array($_GET['id'], $soaIDs)) {
throw new \Exception('Access denied. You\'re not authorized to view this page.', 403);
}
$sql = "SELECT * FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($_GET['id']));
$soa = DNS::getDB()->fetch_array($res);
DNS::getTPL()->assign(array("soa" => $soa));
}
public function prepare()
{
$domains = array();
$soaIDs = User::getAccessibleDomains();
$idna = new idna_convert();
$sortField = "id";
$sortOrder = "ASC";
$sqlOrderBy = "";
$validSortFields = array('id', 'origin', 'serial');
if (isset($_GET['sortField'])) {
if (in_array($_GET['sortField'], $validSortFields)) {
$sortField = $_GET['sortField'];
}
}
if (isset($_GET['sortOrder'])) {
if ($_GET['sortOrder'] == "ASC" || $_GET['sortOrder'] == "DESC") {
$sortOrder = $_GET['sortOrder'];
}
}
if (!empty($sortField) && !empty($sortField)) {
$sqlOrderBy = $sortField . " " . $sortOrder;
}
$pageNo = 1;
if (isset($_GET['pageNo']) && !empty($_GET['pageNo'])) {
$pageNo = intval($_GET['pageNo']);
}
$itemsPerPage = 20;
$pages = 0;
$sqlLimit = $itemsPerPage;
$sqlOffset = ($pageNo - 1) * $itemsPerPage;
$pages = intval(ceil(count($soaIDs) / $itemsPerPage));
if (count($soaIDs) > 0) {
$sql = "SELECT * FROM dns_soa WHERE id IN (" . str_repeat('?, ', count($soaIDs) - 1) . "?)" . (!empty($sqlOrderBy) ? " ORDER BY " . $sqlOrderBy : '') . " LIMIT " . $sqlLimit . " OFFSET " . $sqlOffset;
$res = DNS::getDB()->query($sql, $soaIDs);
while ($row = DNS::getDB()->fetch_array($res)) {
$sql2 = "SELECT count(*) as count FROM dns_rr WHERE zone = ?";
$res2 = DNS::getDB()->query($sql2, array($row['id']));
$row2 = DNS::getDB()->fetch_array($res2);
$row['origin'] = $idna->decode($row['origin']);
$row['rrc'] = $row2['count'];
$domains[] = $row;
}
}
DNS::getTPL()->assign(array('domains' => $domains, 'pageNo' => $pageNo, 'pages' => $pages, 'count' => count($soaIDs), 'sortField' => $sortField, 'sortOrder' => $sortOrder));
}
public function prepare()
{
if (!isset($_GET['id']) || empty($_GET['id'])) {
throw new \Exception('The link you are trying to reach is no longer available or invalid.', 404);
}
$soaIDs = User::getAccessibleDomains();
if (!in_array($_GET['id'], $soaIDs)) {
throw new \Exception('Access denied. You\'re not authorized to view this page.', 403);
}
$idna = new idna_convert();
$sql = "SELECT * FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($_GET['id']));
$soa = DNS::getDB()->fetch_array($res);
$soa['origin'] = $idna->decode($soa['origin']);
DNS::getTPL()->assign(array("soa" => $soa));
$types = array('A', 'AAAA', 'CNAME', 'MX', 'PTR', 'SRV', 'TXT', 'TLSA', 'NS', 'DS');
$error = array();
if (isset($_POST['submit']) && !empty($_POST['submit'])) {
if (isset($_POST['name']) && isset($_POST['ttl']) && !empty($_POST['ttl']) && isset($_POST['type']) && !empty($_POST['type']) && isset($_POST['data']) && !empty($_POST['data'])) {
$type = trim($_POST['type']);
if (!empty($_POST['name'])) {
$name = $idna->encode(trim($_POST['name']));
} else {
$name = $idna->encode(trim($soa['origin']));
}
if (in_array($type, $types)) {
$aux = 0;
if (($type == "MX" || $type == "TLSA" || $type == "SRV" || $type == "DS") && isset($_POST['aux']) && !empty($_POST['aux'])) {
$aux = trim($_POST['aux']);
}
$data = trim($_POST['data']);
if ($type == "SRV" || $type == "DS") {
if (isset($_POST['weight']) && !empty($_POST['weight']) && isset($_POST['port']) && !empty($_POST['port'])) {
if ($type == "SRV") {
$data = $idna->encode($data);
}
$data = trim($_POST['weight']) . ' ' . trim($_POST['port']) . ' ' . $data;
} else {
$error = array_merge($error, array('weight', 'port', 'data'));
}
}
$ttl = $_POST['ttl'];
if ($ttl < DNS_SOA_MINIMUM_TTL) {
$ttl = DNS_SOA_MINIMUM_TTL;
}
if ($type == "TLSA") {
if ($aux != 3) {
// fallback
$aux = 3;
}
if (isset($_POST['weight']) && isset($_POST['port'])) {
if (!is_numeric($_POST['weight'])) {
$error = array_merge($error, array('weight'));
} else {
if (!is_numeric($_POST['port'])) {
$error = array_merge($error, array('weight'));
} else {
if (strlen($_POST['data']) != 64) {
$error = array_merge($error, array('data'));
} else {
$data = trim($_POST['weight']) . ' ' . trim($_POST['port']) . ' ' . $data;
}
}
}
} else {
$error = array_merge($error, array('weight', 'port', 'data'));
}
}
if ($type == "A") {
if (filter_var($data, FILTER_VALIDATE_IP, FILTER_FLAG_IPV4) === false) {
$error = array_merge($error, array('data'));
}
} else {
if ($type == "AAAA") {
if (filter_var($data, FILTER_VALIDATE_IP, FILTER_FLAG_IPV6) === false) {
$error = array_merge($error, array('data'));
}
}
}
} else {
$error = array_merge($error, array('type'));
}
} else {
$error = array_merge($error, array('name', 'ttl', 'data'));
}
$sql = 'SELECT * FROM dns_rr WHERE zone = ? AND name = ? AND type = ? AND data = ?';
$res = DNS::getDB()->query($sql, array($_GET['id'], $name, $type, $data));
$rr = DNS::getDB()->fetch_array($res);
if (!empty($rr)) {
$error = array_merge($error, array('type', 'data'));
}
if (empty($error)) {
$sql = 'INSERT INTO dns_rr (id, zone, name, type, data, aux, ttl) VALUES (NULL, ?, ?, ?, ?, ?, ?)';
if ($type == "SRV" || $type == "DS" || $type == "TLSA") {
DNS::getDB()->query($sql, array($_GET['id'], $name, $type, $data, $aux, $ttl));
} else {
DNS::getDB()->query($sql, array($_GET['id'], $name, $type, $idna->encode($data), $aux, $ttl));
}
$sql = "UPDATE dns_soa SET serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($this->fixSerial($soa['serial']), $soa['id']));
DNS::getTPL()->assign(array('success' => true));
} else {
if ($type == "SRV" || $type == "DS" || $type == "TLSA") {
DNS::getTPL()->assign(array('name' => $idna->decode($name), 'type' => $type, 'weight' => $_POST['weight'], 'port' => $_POST['port'], 'data' => $_POST['data'], 'aux' => $aux, 'ttl' => $ttl));
} else {
DNS::getTPL()->assign(array('name' => $idna->decode($name), 'type' => $type, 'data' => $data, 'aux' => $aux, 'ttl' => $ttl));
}
}
}
DNS::getTPL()->assign(array("error" => $error));
}
public function prepare()
{
if (!isset($_POST['action']) || empty($_POST['action']) || !isset($_POST['dataID'])) {
echo "failure";
exit;
}
$action = trim($_POST['action']);
$dataID = intval(trim($_POST['dataID']));
if ($action == "toggleDomain") {
if (User::isReseller() === false) {
echo "failure";
exit;
}
$soaIDs = User::getAccessibleDomains();
if (!in_array($dataID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "SELECT active, serial FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$soa = DNS::getDB()->fetch_array($res);
$active = $soa['active'] ? 0 : 1;
$sql = "UPDATE dns_soa SET active = ?, serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($active, $this->fixSerial($soa['serial']), $dataID));
echo "success";
exit;
} else {
if ($action == "deleteDomain") {
if (User::isReseller() === false) {
echo "failure";
exit;
}
$soaIDs = User::getAccessibleDomains();
if (!in_array($dataID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "DELETE FROM dns_soa WHERE id = ?";
DNS::getDB()->query($sql, array($dataID));
echo "success";
exit;
} else {
if ($action == "toggleRecord") {
$sql = "SELECT zone FROM dns_rr WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$soaID = $rr['zone'];
$soaIDs = User::getAccessibleDomains();
if (!in_array($soaID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "SELECT active FROM dns_rr WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$active = $rr['active'] ? 0 : 1;
$sql = "UPDATE dns_rr SET active = ? WHERE id = ?";
DNS::getDB()->query($sql, array($active, $dataID));
$sql = "SELECT serial FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($soaID));
$soa = DNS::getDB()->fetch_array($res);
$sql = "UPDATE dns_soa SET serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($this->fixSerial($soa['serial']), $soaID));
echo "success";
exit;
} else {
if ($action == "deleteRecord") {
$sql = "SELECT zone FROM dns_rr WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$soaID = $rr['zone'];
$soaIDs = User::getAccessibleDomains();
if (!in_array($soaID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "DELETE FROM dns_rr WHERE id = ?";
DNS::getDB()->query($sql, array($dataID));
$sql = "SELECT serial FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($soaID));
$soa = DNS::getDB()->fetch_array($res);
$sql = "UPDATE dns_soa SET serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($this->fixSerial($soa['serial']), $soaID));
echo "success";
exit;
} else {
if ($action == "toggleSec") {
$sql = "SELECT zone FROM dns_sec WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$soaID = $rr['zone'];
$soaIDs = User::getAccessibleDomains();
if (!in_array($soaID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "SELECT active FROM dns_sec WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$active = $rr['active'] ? 0 : 1;
$sql = "UPDATE dns_sec SET active = ? WHERE id = ?";
DNS::getDB()->query($sql, array($active, $dataID));
$sql = "SELECT serial FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($soaID));
$soa = DNS::getDB()->fetch_array($res);
$sql = "UPDATE dns_soa SET serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($this->fixSerial($soa['serial']), $soaID));
echo "success";
exit;
} else {
if ($action == "deleteSec") {
$sql = "SELECT zone FROM dns_sec WHERE id = ?";
$res = DNS::getDB()->query($sql, array($dataID));
$rr = DNS::getDB()->fetch_array($res);
$soaID = $rr['zone'];
$soaIDs = User::getAccessibleDomains();
if (!in_array($soaID, $soaIDs)) {
echo "failure";
exit;
}
$sql = "DELETE FROM dns_sec WHERE id = ?";
DNS::getDB()->query($sql, array($dataID));
$sql = "SELECT serial FROM dns_soa WHERE id = ?";
$res = DNS::getDB()->query($sql, array($soaID));
$soa = DNS::getDB()->fetch_array($res);
$sql = "UPDATE dns_soa SET serial = ? WHERE id = ?";
DNS::getDB()->query($sql, array($this->fixSerial($soa['serial']), $soaID));
echo "success";
exit;
} else {
if ($action == "requestApiKey") {
if (User::isLoggedIn()) {
$sql = "SELECT * FROM dns_api WHERE userID = ?";
$res = DNS::getDB()->query($sql, array(DNS::getSession()->userID));
$row = DNS::getDB()->fetch_array($res);
if (empty($row)) {
$apiKey = DNS::generateUUID();
$sql = "INSERT INTO dns_api (id, userID, apiKey) VALUES (NULL, ?, ?)";
DNS::getDB()->query($sql, array(DNS::getSession()->userID, $apiKey));
echo $apiKey;
exit;
}
}
} else {
if ($action == "import") {
if (isset($_POST['zone']) && !empty($_POST['zone'])) {
if ($dataID == 0) {
if (isset($_POST['origin']) && !empty($_POST['origin'])) {
/*
if (User::isReseller() === false) {
echo "failure";
exit;
}
*/
// new zone
}
} else {
$soaIDs = User::getAccessibleDomains();
if (!in_array($dataID, $soaIDs)) {
echo "failure";
exit;
}
$sql = 'SELECT * FROM dns_soa where id = ?';
$res = DNS::getDB()->query($sql, array($dataID));
$res = DNS::getDB()->fetch_array($res);
$soa = $res;
$parser = new ParseZone($_POST['zone'], $soa['origin']);
try {
$parser->parse();
} catch (\Exception $e) {
echo "failure";
exit;
}
$data = $parser->getParsedData();
if (!empty($data['rr'])) {
// delete existing records
foreach ($data['rr'] as $rr) {
// dont update the default ns entrys, we add them automatically, all other ns entrys will be updated
if (strtolower($rr['type']) != "ns" && strtolower($rr['name']) != strtolower($soa['origin'])) {
// import data
}
}
} else {
echo "failure";
exit;
}
}
}
} else {
if ($action == "export") {
$sql = 'SELECT * FROM dns_soa where id = ?';
$res = DNS::getDB()->query($sql, array($dataID));
$res = DNS::getDB()->fetch_array($res);
$soa = $res;
$soaIDs = User::getAccessibleDomains();
if (!in_array($soa['id'], $soaIDs)) {
echo "failure";
exit;
}
$out = ";; Domain:\t" . $soa['origin'] . "\n";
$out .= ";; Exported:\t" . date("Y-m-d H:i:s") . "\n";
$out .= ";; \n";
$out .= ";; This file is intended for use for informational and archival\n";
$out .= ";; purposes ONLY and MUST be edited before use on a production\n";
$out .= ";; DNS server. In particular, you must:\n";
$out .= ";; -- update the SOA record with the correct authoritative name server\n";
$out .= ";; -- update the SOA record with the contact e-mail address information\n";
$out .= ";; -- update the NS record(s) with the authoritative name servers for this domain.\n";
$out .= ";; \n";
$out .= ";; For further information, please consult the BIND documentation\n";
$out .= ";; located on the following website:\n";
$out .= ";; \n";
$out .= ";; http://www.isc.org/\n";
$out .= ";; \n";
$out .= ";; And RFC 1035:\n";
$out .= ";; \n";
$out .= ";; http://www.ietf.org/rfc/rfc1035.txt\n";
$out .= ";; \n";
$out .= ";; Please note that we do NOT offer technical support for any use\n";
$out .= ";; of this zone data, the BIND name server, or any other third-party\n";
$out .= ";; DNS software.\n";
$out .= ";; \n";
$out .= ";;\tUse at your own risk.\n";
$out .= ";; \n";
$out .= $soa['origin'] . "\t" . $soa['minimum'] . "\tIN\tSOA\t" . $soa['ns'] . "\t" . $soa['mbox'] . "\t(\n";
$out .= "\t\t" . $soa['serial'] . "\t; Serial\n";
$out .= "\t\t" . $soa['refresh'] . "\t\t; Refresh\n";
$out .= "\t\t" . $soa['retry'] . "\t\t; Retry\n";
$out .= "\t\t" . $soa['expire'] . "\t\t; Expire\n";
$out .= "\t\t180 )\t\t; Negative Cache TTL\n";
$out .= ";;\n";
$sql = 'SELECT * FROM dns_rr where zone = ?';
$res = DNS::getDB()->query($sql, array($soa['id']));
while ($record = DNS::getDB()->fetch_array($res)) {
if (!$record['active']) {
$out .= ";; ";
}
if ($record['type'] == "MX" || $record['type'] == "SRV" || $record['type'] == "TLSA" || $record['type'] == "DS") {
$out .= $record['name'] . "\t" . $record['ttl'] . "\tIN\t" . $record['type'] . "\t" . $record['aux'] . "\t" . $record['data'] . "\n";
} else {
if ($record['type'] == "TXT") {
$txt = $record['data'];
if (strpos($txt, " ") !== false) {
if (substr($txt, -1) != '"' && substr($txt, 0, 1) != '"') {
if (substr($txt, -1) != "'" && substr($txt, 0, 1) != "'") {
$record['data'] = '"' . $txt . '"';
}
}
}
if (strpos($record['data'], "v=spf1") !== false) {
$out .= $record['name'] . "\t" . $record['ttl'] . "\tIN\tSPF\t" . $record['data'] . "\n";
}
$out .= $record['name'] . "\t" . $record['ttl'] . "\tIN\t" . $record['type'] . "\t" . $record['data'] . "\n";
} else {
$out .= $record['name'] . "\t" . $record['ttl'] . "\tIN\t" . $record['type'] . "\t\t" . $record['data'] . "\n";
}
}
}
echo $out;
exit;
}
}
}
}
}
}
}
}
}
echo "failure";
exit;
}