[feladat @ 289]
Bugfix: In postgres an empty string ("") was is not automatically casted to 0. Because of this the use of integer is forced in the $db->quote() function. This fixes ticket:40.
<?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");
verify_permission('templ_perm_edit') ? $perm_templ_perm_edit = "1" : $perm_templ_perm_edit = "0" ;
$permission_templates = get_list_permission_templates() ;
if ($perm_templ_perm_edit == "0") {
error(ERR_PERM_EDIT_PERM_TEMPL);
} else {
echo " <h2>" . _('Permission templates') . "</h2>\n";
echo " <table>\n";
echo " <tr>\n";
echo " <th> </th>\n";
echo " <th>" . _('Name') . "</th>\n";
echo " <th>" . _('Description') . "</th>\n";
echo " </tr>\n";
foreach ($permission_templates as $template) {
$perm_item_list = get_permissions_by_template_id($template['id'], true);
$perm_items = implode(', ', $perm_item_list);
echo " <tr>\n";
if ($perm_templ_perm_edit == "1") {
echo " <td>\n";
echo " <a href=\"edit_perm_templ.php?id=" . $template["id"] . "\"><img src=\"images/edit.gif\" alt=\"[ " . _('Edit template') . "\" ]></a>\n";
echo " <a href=\"delete_perm_templ.php?id=" . $template["id"] . "\"><img src=\"images/delete.gif\" alt=\"[ " . _('Delete template') . "\" ]></a>\n";
echo " </td>\n";
} else {
echo " <td> </td>\n";
}
echo " <td class=\"y\">" . $template['name'] . "</td>\n";
echo " <td class=\"y\">" . $template['descr'] . "</td>\n";
echo " </tr>\n";
}
echo " </table>\n";
echo " <ul>\n";
echo " <li><a href=\"add_perm_templ.php\">" . _('Add permission template') . "</a>.</li>\n";
echo " </ul>\n";
}
include_once("inc/footer.inc.php");
?>