Location: PHPKode > projects > Network Traffic Monitor > online/editdevice.php
<?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);

?>  
Return current item: Network Traffic Monitor