[feladat @ 221]
Applied the database-structure as supplied by Techwolf to make the insert queries work in PostgreSQL versions before 8.2.
This closes ticket:27
<?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");
include_once("inc/header.inc.php");
$record_id = "-1";
if (isset($_GET['id']) && v_num($_GET['id'])) {
$record_id = $_GET['id'];
}
$confirm = "-1";
if (isset($_GET['confirm']) && v_num($_GET['confirm'])) {
$confirm = $_GET['confirm'];
}
if (verify_permission(zone_content_edit_others)) { $perm_content_edit = "all" ; }
elseif (verify_permission(zone_content_edit_own)) { $perm_content_edit = "own" ; }
else { $perm_content_edit = "none" ; }
$user_is_zone_owner = verify_user_is_owner_zoneid($_GET["domain"]);
if ($record_id == "-1" ) {
error(ERR_INV_INPUT);
} else {
if ($confirm == '1') {
if ( delete_record($record_id) ) {
success(SUC_RECORD_DEL);
}
} else {
$zone_id = recid_to_domid($record_id);
$zone_name = get_domain_name_from_id($zone_id);
$user_is_zone_owner = verify_user_is_owner_zoneid($zone_id);
$record_info = get_record_from_id($record_id);
echo " <h2>" . _('Delete record') . " in zone \"" . $zone_name . "\"</h2>\n";
if ( $zone_type == "SLAVE" || $perm_content_edit == "none" || $perm_content_edit == "own" && $user_is_zone_owner == "0" ) {
error(ERR_PERM_EDIT_RECORD);
} else {
echo " <table>\n";
echo " <tr>\n";
echo " <th>Name</th>\n";
echo " <th>Type</th>\n";
echo " <th>Content</th>\n";
echo " <th>Priority</th>\n";
echo " <th>TTL</th>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>" . $record_info['name'] . "</td>\n";
echo " <td>" . $record_info['type'] . "</td>\n";
echo " <td>" . $record_info['content'] . "</td>\n";
echo " <td>" . $record_info['priority'] . "</td>\n";
echo " <td>" . $record_info['ttl'] . "</td>\n";
echo " </tr>\n";
echo " </table>\n";
if (($record_info['type'] == 'NS' && $record_info['name'] == $zone_name) || $record_info['type'] == 'SOA') {
echo " <p>" . _('You are trying to delete a record that is needed for this zone to work.') . "</p>\n";
}
echo " <p>" . _('Are you sure?') . "</p>\n";
echo " <input type=\"button\" class=\"button\" OnClick=\"location.href='" . $_SERVER["REQUEST_URI"] . "&confirm=1'\" value=\"" . _('Yes') . "\">\n";
echo " <input type=\"button\" class=\"button\" OnClick=\"location.href='index.php'\" value=\"" . _('No') . "\">\n";
}
}
}
include_once("inc/footer.inc.php");