Location: PHPKode > projects > OpenDataCenter Network Management System > include/mainview_page/interface/edit.php
<?php
// ----------------------------------------------------------------------
// Copyright (C) 2007 by GREGORY LE BRAS
// ----------------------------------------------------------------------
// LICENSE
//
// This file is part of ODCNMS - Open DataCenter Network Management System
// 
// ODCNMS 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.
// 
// Foobar 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 Foobar; if not, write to the Free Software
// Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
// ----------------------------------------------------------------------
// Original Author of file: GREGORY LE BRAS - http://www.odcnms.org/
// ----------------------------------------------------------------------
?>
<?php

$arrayifType[1] = "other";
$arrayifType[2] = "regular1822";
$arrayifType[3] = "hdh1822";
$arrayifType[4] = "ddnX25";
$arrayifType[5] = "rfc877x25";
$arrayifType[6] = "ethernetCsmacd";
$arrayifType[7] = "iso88023Csmacd";
$arrayifType[8] = "iso88024TokenBus";
$arrayifType[9] = "iso88025TokenRing";
$arrayifType[10] = "iso88026Man";
$arrayifType[11] = "starLan";
$arrayifType[12] = "proteon10Mbit";
$arrayifType[13] = "proteon80Mbit";
$arrayifType[14] = "hyperchannel";
$arrayifType[15] = "fddi";
$arrayifType[16] = "lapb";
$arrayifType[17] = "sdlc";
$arrayifType[18] = "ds1";
$arrayifType[19] = "e1";
$arrayifType[20] = "basicISDN";
$arrayifType[21] = "primaryISDN";
$arrayifType[22] = "propPointToPointSerial";
$arrayifType[23] = "ppp";
$arrayifType[24] = "softwareLoopback";
$arrayifType[25] = "eon";
$arrayifType[26] = "ethernet3Mbit";
$arrayifType[27] = "nsip";
$arrayifType[28] = "slip";
$arrayifType[29] = "ultra";
$arrayifType[30] = "ds3";
$arrayifType[31] = "sip";
$arrayifType[32] = "frameRelay";
$arrayifType[33] = "rs232";
$arrayifType[34] = "para";
$arrayifType[35] = "arcnet";
$arrayifType[36] = "arcnetPlus";
$arrayifType[37] = "atm";
$arrayifType[38] = "miox25";
$arrayifType[39] = "sonet";
$arrayifType[40] = "x25ple";
$arrayifType[41] = "iso88022llc";
$arrayifType[42] = "localTalk";
$arrayifType[43] = "smdsDxi";
$arrayifType[44] = "frameRelayService";
$arrayifType[45] = "v35";
$arrayifType[46] = "hssi";
$arrayifType[47] = "hippi";
$arrayifType[48] = "modem";
$arrayifType[49] = "aal5";
$arrayifType[50] = "sonetPath";
$arrayifType[51] = "sonetVT";
$arrayifType[52] = "smdsIcip";
$arrayifType[53] = "propVirtual";
$arrayifType[54] = "propMultiplexor";
$arrayifType[55] = "ieee80212";
$arrayifType[56] = "fibreChannel";
$arrayifType[57] = "hippiInterface";
$arrayifType[58] = "frameRelayInterconnect";
$arrayifType[59] = "aflane8023";
$arrayifType[60] = "aflane8025";
$arrayifType[61] = "cctEmul";
$arrayifType[62] = "fastEther";
$arrayifType[63] = "isdn";
$arrayifType[64] = "v11";
$arrayifType[65] = "v36";
$arrayifType[66] = "g703at64k";
$arrayifType[67] = "g703at2mb";
$arrayifType[68] = "qllc";
$arrayifType[69] = "fastEtherFX";
$arrayifType[70] = "channel";
$arrayifType[71] = "ieee80211";
$arrayifType[72] = "ibm370parChan";
$arrayifType[73] = "escon";
$arrayifType[74] = "dlsw";
$arrayifType[75] = "isdns";
$arrayifType[76] = "isdnu";
$arrayifType[77] = "lapd";
$arrayifType[78] = "ipSwitch";
$arrayifType[79] = "rsrb";
$arrayifType[80] = "atmLogical";
$arrayifType[81] = "ds0";
$arrayifType[82] = "ds0Bundle";
$arrayifType[83] = "bsc";
$arrayifType[84] = "async";
$arrayifType[85] = "cnr";
$arrayifType[86] = "iso88025Dtr";
$arrayifType[87] = "eplrs";
$arrayifType[88] = "arap";
$arrayifType[89] = "propCnls";
$arrayifType[90] = "hostPad";
$arrayifType[91] = "termPad";
$arrayifType[92] = "frameRelayMPI";
$arrayifType[93] = "x213";
$arrayifType[94] = "adsl";
$arrayifType[95] = "radsl";
$arrayifType[96] = "sdsl";
$arrayifType[97] = "vdsl";
$arrayifType[98] = "iso88025CRFPInt";
$arrayifType[99] = "myrinet";
$arrayifType[100] = "voiceEM";
$arrayifType[101] = "voiceFXO";
$arrayifType[102] = "voiceFXS";
$arrayifType[103] = "voiceEncap";
$arrayifType[104] = "voiceOverIp";
$arrayifType[105] = "atmDxi";
$arrayifType[106] = "atmFuni";
$arrayifType[107] = "atmIma";
$arrayifType[108] = "pppMultilinkBundle";
$arrayifType[109] = "ipOverCdlc";
$arrayifType[110] = "ipOverClaw";
$arrayifType[111] = "stackToStack";
$arrayifType[112] = "virtualIpAddress";
$arrayifType[113] = "mpc";
$arrayifType[114] = "ipOverAtm";
$arrayifType[115] = "iso88025Fiber";
$arrayifType[116] = "tdlc";
$arrayifType[117] = "gigabitEthernet";
$arrayifType[118] = "hdlc";
$arrayifType[119] = "lapf";
$arrayifType[120] = "v37";
$arrayifType[121] = "x25mlp";
$arrayifType[122] = "x25huntGroup";
$arrayifType[123] = "trasnpHdlc";
$arrayifType[124] = "interleave";
$arrayifType[125] = "fast";
$arrayifType[126] = "ip";
$arrayifType[127] = "docsCableMaclayer";
$arrayifType[128] = "docsCableDownstream";
$arrayifType[129] = "docsCableUpstream";
$arrayifType[130] = "a12MppSwitch";
$arrayifType[131] = "tunnel";
$arrayifType[132] = "coffee";
$arrayifType[133] = "ces";
$arrayifType[134] = "atmSubInterface";
$arrayifType[135] = "l2vlan";
$arrayifType[136] = "l3ipvlan";
$arrayifType[137] = "l3ipxvlan";
$arrayifType[138] = "digitalPowerline";
$arrayifType[139] = "mediaMailOverIp";
$arrayifType[140] = "dtm";
$arrayifType[141] = "dcn";
$arrayifType[142] = "ipForward";
$arrayifType[143] = "msdsl";
$arrayifType[144] = "ieee1394";
$arrayifType[145] = "if-gsn";
$arrayifType[146] = "dvbRccMacLayer";
$arrayifType[147] = "dvbRccDownstream";
$arrayifType[148] = "dvbRccUpstream";
$arrayifType[149] = "atmVirtual";
$arrayifType[150] = "mplsTunnel";
$arrayifType[151] = "srp";
$arrayifType[152] = "voiceOverAtm";
$arrayifType[153] = "voiceOverFrameRelay";
$arrayifType[154] = "idsl";
$arrayifType[155] = "compositeLink";
$arrayifType[156] = "ss7SigLink";
$arrayifType[157] = "propWirelessP2P";
$arrayifType[158] = "frForward";
$arrayifType[159] = "rfc1483";
$arrayifType[160] = "usb";
$arrayifType[161] = "ieee8023adLag";
$arrayifType[162] = "bgppolicyaccounting";
$arrayifType[163] = "frf16MfrBundle";
$arrayifType[164] = "h323Gatekeeper";
$arrayifType[165] = "h323Proxy";
$arrayifType[166] = "mpls";
$arrayifType[167] = "mfSigLink";
$arrayifType[168] = "hdsl2";
$arrayifType[169] = "shdsl";
$arrayifType[170] = "ds1FDL";
$arrayifType[171] = "pos";
$arrayifType[172] = "dvbAsiIn";
$arrayifType[173] = "dvbAsiOut";
$arrayifType[174] = "plc";
$arrayifType[175] = "nfas";
$arrayifType[176] = "tr008";
$arrayifType[177] = "gr303RDT";
$arrayifType[178] = "gr303IDT";
$arrayifType[179] = "isup";
$arrayifType[180] = "propDocsWirelessMaclayer";
$arrayifType[181] = "propDocsWirelessDownstream";
$arrayifType[182] = "propDocsWirelessUpstream";
$arrayifType[183] = "hiperlan2";
$arrayifType[184] = "propBWAp2Mp";
$arrayifType[185] = "sonetOverheadChannel";
$arrayifType[186] = "digitalWrapperOverheadChannel";
$arrayifType[187] = "aal2";
$arrayifType[188] = "radioMAC";
$arrayifType[189] = "atmRadio";
$arrayifType[190] = "imt";
$arrayifType[191] = "mvl";
$arrayifType[192] = "reachDSL";
$arrayifType[193] = "frDlciEndPt";
$arrayifType[194] = "atmVciEndPt";
$arrayifType[195] = "opticalChannel";
$arrayifType[196] = "opticalTransport";
$arrayifType[197] = "propAtm";
$arrayifType[198] = "voiceOverCable";
$arrayifType[199] = "infiniband";
$arrayifType[200] = "teLink";
$arrayifType[201] = "q2931";
$arrayifType[202] = "virtualTg";
$arrayifType[203] = "sipTg";
$arrayifType[204] = "sipSig";
$arrayifType[205] = "docsCableUpstreamChannel";
$arrayifType[206] = "econet";
$arrayifType[207] = "pon155";
$arrayifType[208] = "pon622";
$arrayifType[209] = "bridge";
$arrayifType[210] = "linegroup";
$arrayifType[211] = "voiceEMFGD";
$arrayifType[212] = "voiceFGDEANA";
$arrayifType[213] = "voiceDID";
$arrayifType[214] = "mpegTransport";
$arrayifType[215] = "sixToFour";
$arrayifType[216] = "gtp";
$arrayifType[217] = "pdnEtherLoop1";
$arrayifType[218] = "pdnEtherLoop2";
$arrayifType[219] = "opticalChannelGroup";
$arrayifType[220] = "homepna";
$arrayifType[221] = "gfp";
$arrayifType[222] = "ciscoISLvlan";
$arrayifType[223] = "actelisMetaLOOP";
$arrayifType[224] = "fcipLink";
$arrayifType[225] = "rpr";
$arrayifType[226] = "qam";
$arrayifType[227] = "lmp";
$arrayifType[228] = "cblVectaStar";
$arrayifType[229] = "docsCableMCmtsDownstream";
$arrayifType[230] = "adsl2";
$arrayifType[231] = "macSecControlledIF";
$arrayifType[232] = "macSecUncontrolledIF";
$arrayifType[233] = "aviciOpticalEther";
$arrayifType[234] = "atmbond";
$arrayifType[235] = "voiceFGDOS";
$arrayifType[236] = "mocaVersion1";
$arrayifType[237] = "ieee80216WMAN";
$arrayifType[238] = "adsl2plus";
$arrayifType[239] = "dvbRcsMacLayer";
$arrayifType[240] = "dvbTdm";
$arrayifType[241] = "dvbRcsTdma";
$arrayifType[242] = "x86Laps";

if (!isset($edit))
{
	$request=mysql_query("SELECT * FROM $name_table_interface WHERE id=\"$_GET[id]\"") or die ("ERROR!");

	while($tmp_request=mysql_fetch_array($request))
	{
?>
<form method="post" action="index.php?include=mainview&page=interface&action=edit&edit=ok&id=<?php echo $id;?>" name="edit_interface">
	<fieldset class="form">
		<legend><img src="images/edit.gif" alt="Edit" align="top"> <?php echo TXT_EDIT; ?> <?php echo TXT_INTERFACE; ?></legend>
		<label><?php echo TXT_INDEX; ?></label>
		<input type="text" name="index" size="20" value="<?php echo $tmp_request['index']; ?>" disabled readonly><br>
		<label><?php echo TXT_DEVICE; ?></label>
		<select name="device" disabled readonly>
		<?php
		$request2=mysql_query("SELECT device_id FROM $name_table_slot WHERE id=$tmp_request[slot_id]") or die ("ERROR!");

		while($tmp_request2=mysql_fetch_array($request2))
		{
			$requestdevice=mysql_query("SELECT id,name FROM $name_table_device ORDER BY name,id ASC") or die ("ERROR!");

			while($tmp_requestdevice=mysql_fetch_array($requestdevice))
			{
				if ($tmp_requestdevice['id'] == $tmp_request2['device_id'])
				{
					$device_id = $tmp_request2['device_id'];
					echo "<option value=\"$tmp_requestdevice[id]\" selected>$tmp_requestdevice[name]</option>";
				}
				else
				{
					echo "<option value=\"$tmp_requestdevice[id]\">$tmp_requestdevice[name]</option>";	
				}				
			}
		}
		?>
		</select>		
		<label><?php echo TXT_SLOT; ?></label>
		<select name="slot" disabled readonly>
		<?php
		$request3=mysql_query("SELECT id,number,device_id FROM $name_table_slot WHERE device_id=$device_id ORDER BY number,id ASC") or die ("ERROR!");

		while($tmp_request3=mysql_fetch_array($request3))
		{
			if ($tmp_request3['id'] == $tmp_request['slot_id'])
			{
				echo "<option value=\"$tmp_request3[id]\" selected>$tmp_request3[number]</option>";
			}
			else
			{
				echo "<option value=\"$tmp_request3[id]\">$tmp_request3[name]</option>";	
			}
		}
		?>		
		</select>
		<label><?php echo TXT_NAME; ?></label>
		<input type="text" name="name" size="50" value="<?php echo $tmp_request['name']; ?>"><br>
		<label><?php echo TXT_TYPE; ?></label>
		<select name="type">
		<?php
			foreach ($arrayifType as $key => $arrayvalue)
			{
				if ($key == $tmp_request['type'])
				{
					echo "<option value=\"$key\" selected>$arrayvalue</option>";
				}
				else
				{
					echo "<option value=\"$key\">$arrayvalue</option>";
				}
			}							
		?>
		</select>
		<label><?php echo TXT_SPEED; ?></label><select name="speed" id="speed" onchange="javascript:urlredirectdiv('ajax_view.php?what=ajaxinterfacespeed2&interface_id='+this.value,'ajaxinterfacespeed');">
		<?php
			switch ($tmp_request['speed'])
			{			
				case '1000' :
				echo "<option value=\"1001\">1000 Mbps</option>";
				echo "<option value=\"1000\" selected>10/100/1000 Mbps</option>";
				echo "<option value=\"100\">10/100 Mbps</option>";
				echo "<option value=\"10\">10 Mbps</option>";
				echo "<option value=\"other\">".TXT_OTHER."...</option>";
				break;
				
				case '100':
				echo "<option value=\"1001\">1000 Mbps</option>";        
				echo "<option value=\"1000\">10/100/1000 Mbps</option>";				
				echo "<option value=\"100\" selected>10/100 Mbps</option>";
				echo "<option value=\"10\">10 Mbps</option>";		
        echo "<option value=\"other\">".TXT_OTHER."...</option>";
				break;
				
				case '10':
				echo "<option value=\"1001\">1000 Mbps</option>";        
				echo "<option value=\"1000\">10/100/1000 Mbps</option>";					
				echo "<option value=\"100\">10/100 Mbps</option>";				
				echo "<option value=\"10\" selected>10 Mbps</option>";
				echo "<option value=\"other\">".TXT_OTHER."...</option>";        
				break;						
				
				default : 
				echo "<option value=\"".$tmp_request['speed']."\">".$tmp_request['speed']." Mbps</option>";        
				echo "<option value=\"1001\">1000 Mbps</option>";        
				echo "<option value=\"1000\">10/100/1000 Mbps</option>";					
				echo "<option value=\"100\">10/100 Mbps</option>";
				echo "<option value=\"10\">10 Mbps</option>";				
				echo "<option value=\"other\">".TXT_OTHER."...</option>";        
				break;			
			}			
		?>
		</select>
    <div id="ajaxinterfacespeed"></div>    
		<label><?php echo TXT_DESCRIPTION; ?></label>
		<textarea name="description" rows="10" cols="50"><?php echo $tmp_request['description']; ?></textarea><br>
		<input type="submit" name="submit" value="<?php echo TXT_EDIT; ?>"> <input type="button" value="<?php echo TXT_BACK; ?>" onClick="javascript:history.go(-1);">
	</fieldset>
</form>
 <script language="JavaScript" type="text/javascript">
	 var frmvalidator = new Validator("edit_interface");
		 frmvalidator.addValidation("name","req","Please enter the name of the interface");
		 frmvalidator.addValidation("name","maxlen=255",
"Max length for Name is 255");
		 
		 frmvalidator.addValidation("description","req","Please enter the description of the interface");
		 frmvalidator.addValidation("description","maxlen=255","Max length for Description is 255");
</script>
<?php
	}
}
else if ($edit=="ok")
{
	$request=mysql_query("SELECT * FROM $name_table_interface WHERE id=\"$id\"") or die ("ERROR!");

	while($tmp_request=mysql_fetch_array($request))
	{
		$preceding_name = $tmp_request['name'];
		$preceding_description = $tmp_request['description'];
	}

  if ($speed == "other")
  {
    $query=mysql_query("UPDATE $name_table_interface SET name=\"$name\", type=\"$type\", speed=\"$other_interface_speed\", description=\"$description\" WHERE id=$id");
  }
  else
  {
    $query=mysql_query("UPDATE $name_table_interface SET name=\"$name\", type=\"$type\", speed=\"$speed\", description=\"$description\" WHERE id=$id");
  }

	if(!$query)
	{
		echo "<center><div id=\"status\" style=\"color:red\"><img src=\"images/warning.png\" alt=\"WARNING\"><br><br>";
		echo TXT_DATABASE_ERROR;
		echo "</div><br><a href=\"javascript:history.go(-2);\">";
		echo TXT_BACK;
		echo "</a></center>";
	}
	else
	{
    user_log ($_SESSION['login'],$name_table_users,$name_table_users_log,"edit","interface","$name ($id)",$mysql_hostname,$mysql_username,$mysql_password,$mysql_database);
    
		echo "<center><div id=\"status\" style=\"color:green\"><img src=\"images/info.png\" alt=\"INFO\"><br><br>";
		echo TXT_SUCCESSFULLY_EDIT_INTERFACE;
		echo "</div><br><a href=\"javascript:history.go(-2);\">";
		echo TXT_BACK;
		echo "</a></center>";
	}

}
?>
Return current item: OpenDataCenter Network Management System