<?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($delete))
{
$request=mysql_query("SELECT * FROM $name_table_subnet WHERE id=\"$_GET[id]\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$address_array = explode(".",$tmp_request['address']);
$mask_array = explode(".",$tmp_request['mask']);
$cidr = find_net ($tmp_request['address'],$tmp_request['mask']);
$cidr = str_replace("/","",$cidr['cidr']);
?>
<form method="post" action="index.php?include=mainview&page=subnet&action=delete&delete=ok&id=<?php echo $id;?>" name="delete_subnet">
<fieldset class="form">
<legend><img src="images/delete.gif" alt="Delete" align="top"> <?php echo TXT_DELETE; ?> <?php echo TXT_SUBNET; ?></legend>
<label><?php echo TXT_NETWORK; ?></label>
<?php
$request2=mysql_query("SELECT id,name,address,mask FROM $name_table_network WHERE id=$tmp_request[network_id]");
while ($tmp_request2=mysql_fetch_array($request2))
{
$cidr = find_net($tmp_request2['address'],$tmp_request2['mask']);
echo "<input type=\"text\" name=\"network\" size=\"50\" value=\"$tmp_request[name] ($tmp_request2[address]$cidr[cidr])\" READONLY DISABLED><br>";
}
?>
<label><?php echo TXT_NAME; ?></label>
<input type="text" name="name" size="50" value="<?php echo $tmp_request['name']; ?>" READONLY DISABLED><br>
<label><?php echo TXT_ADDRESS; ?></label>
<input type="text" name="oct1" id="oct1" size="3" maxlength="3" value="<?php echo $address_array[0]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="oct2" id="oct2" size="3" maxlength="3" value="<?php echo $address_array[1]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="oct3" id="oct3" size="3" maxlength="3" value="<?php echo $address_array[2]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="oct4" id="oct4" size="3" maxlength="3" value="<?php echo $address_array[3]; ?>" disabled><br>
<label><?php echo TXT_MASK; ?></label>
<input type="text" name="snm" id="snm1" size="3" maxlength="3" value="<?php echo $mask_array[0]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="snm2" id="snm2" size="3" maxlength="3" value="<?php echo $mask_array[1]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="snm3" id="snm3" size="3" maxlength="3" value="<?php echo $mask_array[2]; ?>" disabled><span style="top: -6px;position:relative;">.</span><input type="text" name="snm4" id="snm4" size="3" maxlength="3" value="<?php echo $mask_array[3]; ?>" disabled><span style="position:relative;top:-10px;"> or /</span><input type="text" name="snmbits" size="2" maxlength="2" value="<?php echo $cidr[0]; ?>" disabled><br>
<label><?php echo TXT_CUSTOMERS; ?></label>
<table border="0">
<tr>
<td>
<select name="list1" multiple="multiple" size="10" onDblClick="opt.transferRight()" disabled>
<?php
$customer_array = array();
$request2=mysql_query("SELECT * FROM $name_table_link_customer_subnet WHERE subnet_id=\"$id\"") or die ("ERROR!");
while($tmp_request2=mysql_fetch_array($request2))
{
$request3=mysql_query("SELECT id,name FROM $name_table_customer WHERE id=\"$tmp_request2[customer_id]\"") or die ("ERROR!");
while($tmp_request3=mysql_fetch_array($request3))
{
echo "<option value=\"$tmp_request3[id]\">$tmp_request3[name]</option>";
array_push($customer_array,$tmp_request3['id']);
}
}
?>
</select>
</table>
<label><?php echo TXT_VLAN; ?></label>
<select name="vlan" id="vlan" size="1" style="margin-right:5px;" disabled>
<?php
$request5=mysql_query("SELECT * FROM $name_table_link_subnet_vlan WHERE subnet_id=$id") or die ("ERROR!");
while($tmp_request5=mysql_fetch_array($request5))
{
$previous_vlan = $tmp_request5['vlan_id'];
$request6=mysql_query("SELECT id,name FROM $name_table_vlan WHERE id=$tmp_request5[vlan_id]") or die ("ERROR!");
while($tmp_request6=mysql_fetch_array($request6))
{
echo "<option value=\"$tmp_request6[id]\" SELECTED>$tmp_request6[name]</option>";
}
$request7=mysql_query("SELECT id,name FROM $name_table_vlan WHERE id!=$tmp_request5[vlan_id]") or die ("ERROR!");
while($tmp_request7=mysql_fetch_array($request7))
{
echo "<option value=\"$tmp_request7[id]\">$tmp_request7[name]</option>";
}
}
?>
</select>
<label><?php echo TXT_STATUS; ?></label>
<select name="status" size="1" disabled>
<?php
switch ($tmp_request['status'])
{
case '0':
echo "<option value=\"0\" selected>";
echo TXT_ASSIGNED;
echo "</option>
<option value=\"1\">";
echo TXT_UNUSED;
echo "</option>
<option value=\"2\">";
echo TXT_RESERVED;
echo "</option>";
break;
case '1':
echo "<option value=\"0\">";
echo TXT_ASSIGNED;
echo "</option>
<option value=\"1\" selected>";
echo TXT_UNUSED;
echo "</option>
<option value=\"2\">";
echo TXT_RESERVED;
echo "</option>";
break;
case '2':
echo "<option value=\"0\">";
echo TXT_ASSIGNED;
echo "</option>
<option value=\"1\">";
echo TXT_UNUSED;
echo "</option>
<option value=\"2\" selected>";
echo TXT_RESERVED;
echo "</option>";
break;
}
?>
</select>
<label><?php echo TXT_DESCRIPTION; ?></label>
<textarea name="description" rows="10" cols="50" READONLY DISABLED><?php echo $tmp_request['description']; ?></textarea><br>
<input type="submit" name="submit" value="<?php echo TXT_DELETE_IT_ALL_ASSOCIATED_ITEMS; ?>" onClick="return confirmDelete();"> <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("delete_subnet");
frmvalidator.addValidation("name","req","Please enter the name of the subnet");
frmvalidator.addValidation("name","maxlen=255",
"Max length for Name is 255");
</script>
<?php
}
}
else if ($delete=="ok")
{
$request=mysql_query("SELECT name FROM $name_table_subnet WHERE id=\"$id\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$name=$tmp_request['name'];
}
$query=mysql_query("DELETE FROM $name_table_subnet WHERE id=$id");
$request_ip_address=mysql_query("SELECT id FROM $name_table_ip_address WHERE subnet_id=\"$id\"") or die ("ERROR!");
while($tmp_request_ip_address=mysql_fetch_array($request_ip_address))
{
$query7=mysql_query("DELETE FROM $name_table_link_device_ip_address WHERE ip_address_id=$tmp_request_ip_address[id]");
$query_update=mysql_query("UPDATE $name_table_device SET ip_address_id=\"\" WHERE ip_address_id=\"$tmp_request_ip_address[id]\"") or die ("ERROR!");
}
$query2=mysql_query("DELETE FROM $name_table_ip_address WHERE subnet_id=$id");
$query3=mysql_query("DELETE FROM $name_table_link_subnet_vlan WHERE subnet_id=$id");
$query4=mysql_query("DELETE FROM $name_table_link_customer_subnet WHERE subnet_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
{
$currentdate = date('Y-m-d');
$currenttime = date("H:i:s");
user_log ($_SESSION['login'],$name_table_users,$name_table_users_log,"delete","subnet","$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'].' - delete subnet '.$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_DELETED_SUBNET;
echo "</div><br><a href=\"javascript:history.go(-2);\">";
echo TXT_BACK;
echo "</a></center>";
}
}
else if ($delete=="multiple")
{
foreach ($_POST['delAnn'] as $id)
{
$request=mysql_query("SELECT name FROM $name_table_subnet WHERE id=\"$id\"") or die ("ERROR!");
while($tmp_request=mysql_fetch_array($request))
{
$name=$tmp_request['name'];
}
$query=mysql_query("DELETE FROM $name_table_subnet WHERE id=$id");
$request_ip_address=mysql_query("SELECT id FROM $name_table_ip_address WHERE subnet_id=\"$id\"") or die ("ERROR!");
while($tmp_request_ip_address=mysql_fetch_array($request_ip_address))
{
$query7=mysql_query("DELETE FROM $name_table_link_device_ip_address WHERE ip_address_id=$tmp_request_ip_address[id]");
$query_update=mysql_query("UPDATE $name_table_device SET ip_address_id=\"\" WHERE ip_address_id=\"$tmp_request_ip_address[id]\"") or die ("ERROR!");
}
$query2=mysql_query("DELETE FROM $name_table_ip_address WHERE subnet_id=$id");
$query3=mysql_query("DELETE FROM $name_table_link_subnet_vlan WHERE subnet_id=$id");
$query4=mysql_query("DELETE FROM $name_table_link_customer_subnet WHERE subnet_id=$id");
$currentdate = date('Y-m-d');
$currenttime = date("H:i:s");
user_log ($_SESSION['login'],$name_table_users,$name_table_users_log,"delete","subnet","$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'].' - delete subnet '.$name.'('.$id.')');
$syslog->SetServer($arrayvalue);
$syslog->Send();
}
}
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
{
echo "<center><div id=\"status\" style=\"color:green\"><img src=\"images/info.png\" alt=\"INFO\"><br><br>";
echo TXT_SUCCESSFULLY_DELETED_SUBNET;
echo "</div><br><a href=\"javascript:history.go(-2);\">";
echo TXT_BACK;
echo "</a></center>";
}
}
?>