[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");include_once("inc/header.inc.php");if(!level(5)){?><h3><?echo_('Oops!');?></h3><p><?echo_('You are not allowed to add supermasters with your current access level!');?></p><?}else{$supermasters=get_supermasters(0);$num_supermasters=($supermasters==-1)?0:count($supermasters);?><h3><?printf(_('List all %s supermasters'),$num_supermasters);?></h3><table><tr><th> </td><th><?echo_('IP address of supermaster');?></td><th><?echo_('Hostname in NS record');?></td><th><?echo_('Account');?></td></tr><?if($num_supermasters==0){?><tr><tdclass="n"> </td><tdclass="n"colspan="3"><?echo_('No supermasters in this listing, sorry.');?></td></tr><?}else{foreach($supermastersas$c){?><tr><tdclass="n"><ahref="delete_supermaster.php?master_ip=<?echo$c["master_ip"]?>"><imgsrc="images/delete.gif"title="<?print_('Delete supermaster').' '.$c["master_ip"];?>"alt="[ <?echo_('Delete supermaster');?> ]"></a></td><tdclass="y"><?echo$c["master_ip"]?></td><tdclass="y"><?echo$c["ns_name"]?></td><tdclass="y"><?echo$c["account"]?></td></tr><?}}?></table><?}include_once("inc/footer.inc.php");?>