<?php
#Network Traffic Monitor is an application to monitor the network traffic on all SNMP managable devices.
#
#Copyright (c) 2004, Daimler Trust nv <hide@address.com> - Jan Van Hees <hide@address.com>
#
#This file is part of Network Traffic Monitor.
#
# Network Traffic Monitor 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 2 of the License, or
# (at your option) any later version.
#
# Network Traffic Monitor 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 Network Traffic Monitor; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
/*
* This script provides a user interface to Edit ports
*/
require_once("../auth.php");
require_once ("../config.php");
require_once ("HTML/Template/IT.php");
require_once "HTML/Table.php";
if($_POST['port']){
header("Location: error.php");
exit;
}
$db = dbLogin();
$tpl = new HTML_Template_IT(TEMPLATEDIR);
$tpl->loadTemplatefile("addport.tpl");
$tpl->setVariable("title","Edit Port");
$tpl->setVariable("action","edit.php");
$pid=$_GET['p'];
$did=$_GET['d'];
$gid=$_GET['g'];
$sql = "SELECT ports.pid, ports.did, ports.portnr, ports.portname, ports.speed, ports.burstable, portgroups.gid
FROM ports
INNER JOIN portgroups ON ports.pid=portgroups.pid
WHERE ports.pid=$pid ORDER BY ports.portname";
$temp = $db->query($sql);
while ($row = $temp->fetchrow()){
$pid = $row[0];
$did = $row[1];
$pnr = $row[2];
$pname = $row[3];
$speed = $row[4];
$burst = $row[5];
$gid = $row[6];
}//while fetchrow
$sql = "SELECT groups.gid, groups.groupname FROM groups ORDER BY groups.groupname";
$result = $db->query($sql);
// Get each row of data on each iteration until
// there are no more rows
while ($row = $result->fetchRow()){
if($row[0]==$gid)$selected="selected";
else $selected="";
$gcombo .= "<option value=\"$row[0]\" $selected>$row[1]</option>";
}
$sqlD = "SELECT devices.did, devices.devicename from devices ORDER BY devices.devicename";
$res = $db->query($sqlD);
// Get each row of data on each iteration until
// there are no more rows
while ($row = $res->fetchRow()){
if($row[0]==$did)$selected="selected";
else $selected="";
$combo .= "<option value=\"$row[0]\" $selected>$row[1]</option>";
}
$sqls = "SELECT spid, mbit FROM speed ORDER BY mbit ASC";
$res = $db->query($sqls);
while($row = $res->fetchRow()){
if($row[0]==$speed)$selected = "selected";
else $selected = "";
$speedcombo .="<option value=\"$row[0]\" $selected>$row[1] Mbit/s</option>";
}
$tpl->setVariable("groupoptions", $gcombo);
$tpl->setVariable("deviceoptions", $combo);
$tpl->setVariable("speedoptions", $speedcombo);
$tpl->setVariable("name", $pname);
$tpl->setVariable("number",$pnr);
$tpl->setVariable("pid", $pid);
if($burst == 't')$tpl->setVariable("burstable", "checked");
$content = $tpl->get();
fillFrame($db, $content);
dblogout($db);
?>