[feladat @ 108]
Modified the SQL statements for PostgreSQL as the tables are created with wrong definitions.
<?php
/* PowerAdmin, a friendly web-based admin tool for PowerDNS.
* See <https://rejo.zenger.nl/poweradmin> for more details.
*
* Copyright 2007, 2008 Rejo Zenger <rejo@zenger.nl>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
require_once("inc/toolkit.inc.php");
if (!level(5))
{
error(ERR_LEVEL_5);
}
if ($_POST["submit"])
{
$domain = trim($_POST["domain"]);
$owner = $_POST["owner"];
$webip = $_POST["webip"];
$mailip = $_POST["mailip"];
$empty = $_POST["empty"];
$dom_type = isset($_POST["dom_type"]) ? $_POST["dom_type"] : "NATIVE";
if(!$empty)
{
$empty = 0;
if(!eregi('in-addr.arpa', $domain) && (!is_valid_ip($webip) || !is_valid_ip($mailip)) )
{
$error = "Web or Mail ip is invalid!";
}
}
if (!$error)
{
if (!is_valid_domain($domain))
{
$error = "Zone name is invalid!";
}
elseif (domain_exists($domain))
{
$error = "Zone already exists!";
}
//elseif (isset($mailip) && is_valid_ip(
else
{
add_domain($domain, $owner, $webip, $mailip, $empty, $dom_type, '');
$success = _('Successfully added master zone.');
}
}
}
include_once("inc/header.inc.php");
if ($error != "")
{
?><div class="error"><? echo _('Error'); ?>: <? echo $error; ?></div><?
}
elseif ($success != "")
{
?><div class="success"><? echo $success; ?></div><?
}
?>
<h2>Add master zone</h2>
<?
// Zone type set to master and native only, slave zones are created
// on a different page.
$zone_types = array("MASTER", "NATIVE");
$users = show_users();
?>
<form method="post" action="add_zone_master.php">
<table>
<tr>
<td class="n"><? echo _('Zone name'); ?>:</td>
<td class="n">
<input type="text" class="input" name="domain" value="<? if ($error) print $_POST["domain"]; ?>">
</td>
</tr>
<tr>
<td class="n"><? echo _('Web IP'); ?>:</td>
<td class="n">
<input type="text" class="input" name="webip" value="<? if ($error) print $_POST["webip"]; ?>">
</td>
</tr>
<tr>
<td class="n"><? echo _('Mail IP'); ?>:</TD>
<td class="n">
<input type="text" class="input" name="mailip" value="<? if ($error) print $_POST["mailip"]; ?>">
</td>
</tr>
<tr>
<td class="n"><? echo _('Owner'); ?>:</td>
<td class="n">
<select name="owner">
<?
foreach ($users as $u)
{
?><option value="<? echo $u['id'] ?>"><? echo $u['fullname'] ?></option><?
}
?>
</select>
</td>
</tr>
<tr>
<td class="n"><? echo _('Zone type'); ?>:</td>
<td class="n">
<select name="dom_type">
<?
foreach($zone_types as $s)
{
?><option value="<? echo $s?>"><? echo $s ?></option><?
}
?>
</select>
</td>
</tr>
<tr>
<td class="n"><? echo _('Create zone without applying records-template'); ?>:</td>
<td class="n"><input type="checkbox" name="empty" value="1"></td>
</tr>
<tr>
<td class="n"> </td>
<td class="n">
<input type="submit" class="button" name="submit" value="<? echo _('Add zone'); ?>">
</td>
</tr>
</table>
</form>
<?
include_once("inc/footer.inc.php");