<?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
if (!isset($edit))
{
$request=mysql_query("SELECT * FROM $name_table_vlan WHERE id=\"$_GET[id]\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
?>
<script language="JavaScript">
var opt = new OptionTransfer("list1","list2");
opt.setAutoSort(true);
opt.setDelimiter(";");
opt.saveNewLeftOptions("subnet");
opt.saveRemovedLeftOptions("removed_subnet");
</script>
<form method="post" action="index.php?include=mainview&page=vlan&action=edit&edit=ok&id=<?php echo $id;?>" name="edit_vlan">
<fieldset class="form">
<legend><img src="images/edit.gif" alt="Edit" align="top"> <?php echo TXT_EDIT; ?> <?php echo TXT_VLAN; ?></legend>
<label><?php echo TXT_NAME; ?></label>
<input type="text" name="name" size="50" value="<?php echo $tmp_request['name']; ?>"><br>
<label><?php echo TXT_NUMBER; ?></label>
<input type="text" name="number" size="50" value="<?php echo $tmp_request['number']; ?>"><br>
<label><?php echo TXT_SUBNET; ?></label>
<table border="0">
<tr>
<td>
<select name="list1" multiple="multiple" size="10" onDblClick="opt.transferRight()">
<?php
$subnet_array = array();
$request2=mysql_query("SELECT * FROM $name_table_link_subnet_vlan WHERE vlan_id=\"$id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$request3=mysql_query("SELECT id,name FROM $name_table_subnet WHERE id=\"$tmp_request2[subnet_id]\"") or die ("ERROR!");
while($tmp_request3=mysql_fetch_array($request3))
{
echo "<option value=\"$tmp_request3[id]\">$tmp_request3[name]</option>";
array_push($subnet_array,$tmp_request3['id']);
}
}
?>
</select>
</td>
<td align="center" valign="middle">
<input name="left" value="<?php echo TXT_ADD; ?> <<" ONCLICK="opt.transferLeft()" type="button"><br><br>
<input name="left" value="<?php echo TXT_ADD; ?> <?php echo TXT_ALL; ?> <<" ONCLICK="opt.transferAllLeft()" type="button"><br><br>
<input name="right" value="<?php echo TXT_REMOVE; ?> >>" ONCLICK="opt.transferRight()" type="button"><br><br>
<input name="right" value="<?php echo TXT_REMOVE; ?> <?php echo TXT_ALL; ?> >>" ONCLICK="opt.transferAllRight()" type="button">
</td>
<td>
<select name="list2" multiple="multiple" size="10" onDblClick="opt.transferLeft()">
<?php
$sqlrequest="WHERE ";
$count = 1;
$subnet_array_size = sizeof($subnet_array);
foreach ($subnet_array as $arrayvalue)
{
if ($count == $subnet_array_size)
{
$sqlrequest.="id!=\"$arrayvalue\" ";
}
else
{
$sqlrequest.="id!=\"$arrayvalue\" AND ";
}
$count++;
}
$sqlrequest2="SELECT id,name FROM ".$name_table_subnet." ".$sqlrequest;
$request4=mysql_query($sqlrequest2) or die ("ERROR!");
while($tmp_request4=mysql_fetch_array($request4))
{
echo "<option value=\"$tmp_request4[id]\">$tmp_request4[name]</option>";
}
?>
</select>
</td>
</tr>
</table>
<label><?php echo TXT_DESCRIPTION; ?></label>
<textarea name="description" rows="10" cols="50"><?php echo $tmp_request['description']; ?></textarea><br>
<input type="hidden" name="subnet" value="">
<input type="hidden" name="removed_subnet" value="">
<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_vlan");
frmvalidator.addValidation("name","req","Please enter the name of the vlan");
frmvalidator.addValidation("name","maxlen=255",
"Max length for Name is 255");
frmvalidator.addValidation("number","req","Please enter the number of the vlan");
frmvalidator.addValidation("subnet","req","Please enter the subnet of the vlan");
</script>
<?php
}
}
else if ($edit=="ok")
{
$query=mysql_query("UPDATE $name_table_vlan SET number=\"$number\", name=\"$name\", 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
{
$subnet_value = explode (";", $_POST['subnet']);
foreach ($subnet_value as $arrayvalue)
{
$request=mysql_query("SELECT count(*) FROM $name_table_link_subnet_vlan WHERE subnet_id=\"$arrayvalue\" and vlan_id=\"$id\"") or die ("ERROR!");
$data = mysql_fetch_array($request);
if ($data[0] == 0)
{
$query2=mysql_query("INSERT INTO $name_table_link_subnet_vlan VALUES (\"$arrayvalue\",\"$id\")") or die ("ERROR!");
}
}
$removedsubnet_value = explode (";", $_POST['removed_subnet']);
foreach ($removedsubnet_value as $arrayvalue)
{
$query3=mysql_query("DELETE FROM $name_table_link_subnet_vlan WHERE subnet_id=\"$arrayvalue\" and vlan_id=\"$id\"") or die ("ERROR!");
}
$currentdate = date('Y-m-d');
$currenttime = date("H:i:s");
user_log ($_SESSION['login'],$name_table_users,$name_table_users_log,"edit","vlan","$name ($id)",$mysql_hostname,$mysql_username,$mysql_password,$mysql_database);
foreach ($syslog_server as $arrayvalue)
{
$syslog = new Syslog();
$syslog->SetFacility(13);
$syslog->SetSeverity(5);
$syslog->SetProcess('odcnms');
$syslog->SetHostname('');
$syslog->SetFqdn('');
$syslog->SetIpFrom('');
$syslog->SetContent($currentdate.' '.$currenttime.' user: '.$_SESSION['login'].' - edit vlan '.$name.'('.$id.')');
$syslog->SetServer($arrayvalue);
$syslog->Send();
}
echo "<center><div id=\"status\" style=\"color:green\"><img src=\"images/info.png\" alt=\"INFO\"><br><br>";
echo TXT_SUCCESSFULLY_EDITED_VLAN;
echo "</div><br><a href=\"javascript:history.go(-2);\">";
echo TXT_BACK;
echo "</a></center>";
}
}
?>