X-Git-Url: http://git.pjr.cc/?p=PHPIPManager.git;a=blobdiff_plain;f=lib%2Fwww.php;fp=lib%2Fwww.php;h=f9648b9249ce98350fc4c56355a5f014143e405d;hp=70274f52b2e301bac1c11fb4dbc182d5cb3e92b4;hb=46533a511551e2d0f41434adbcaff4d2f057a0ab;hpb=671b623794ad8bd9d8a57f28436a46a62b12ef66

diff --git a/lib/www.php b/lib/www.php
index 70274f5..f9648b9 100644
--- a/lib/www.php
+++ b/lib/www.php
@@ -3,8 +3,12 @@
 $actionRegister["addsuper"] = "www_ip_addSuperRange";
 $actionRegister["allocate"] = "www_ip_allocateRange";
 $actionRegister["allocatesub"] = "www_ip_allocateSubRange";
+$actionRegister["modsubnet"] = "www_ip_modifySubnet";
 $actionRegister["dumpdb"] = "www_db_dumpdb";
 $actionRegister["restoredb"] = "www_db_restoredb";
+$actionRegister["changesubdetails"] = "www_ip_changesubdetails";
+$actionRegister["addhosts"] = "www_ip_addhost";
+$actionRegister["deletehost"] = "www_ip_deletehost";
 
 class www {
 	function Go() {
@@ -72,10 +76,25 @@ Description <input type="text" name="desc"></input>
 			//echo "<pre>";
 		//	print_r($row);
 		//	echo "</pre><hr>";
-			echo "<table border=\"1\"><tr><th>".$row["sn_name"]."</th><td>".$row["sn_ip"]."/".$row["sn_mask"]."</td><td>".$row["sn_desc"]."</td>";
+			echo "<table border=\"1\"><tr><th align=\"left\">".$row["sn_name"]."</th><td>".$row["sn_ip"]."::0/".$row["sn_mask"]."</td><td>".$row["sn_desc"]."</td>";
 			echo "<td><a href=\"?action=allocate&id=".$row["sn_id"]."\">Allocate Subnet</a></td>";
 			echo "<td><a href=\"?action=delete&id=".$row["sn_id"]."\">Delete Supernet</a></td>";
+			echo "</tr>";
 			// now we search for sub's
+			$res2 = $db->dbobject->query("select * from subnet where snid_id='".$row["sn_id"]."'");
+			foreach($res2 as $row2) {
+				// ("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
+				$name = $row2["sn_name"];
+				$subid = $row2["sn_id"];
+				$subnet = $row2["sn_ip"];
+				$mask = $row2["sn_mask"];
+				$desc = $row2["sn_desc"];
+				echo "<tr>";
+				echo "<td><li> <i><a href=\"?action=modsubnet&id=".$row2["sn_id"]."\">$name</a></i></td><td>$subnet::0/$mask</td><td>$desc</td>";
+				echo "<td><a href=\"?action=deletesub&id=".$row2["sn_id"]."\">Delete Subnet</a></td>";
+				//echo "<td><a href=\"?action=addhost&id=".$row["sn_id"]."\">Add Host</a></td>";
+				echo "</tr>";
+			}
 			echo "</table><br>";
 		}
 		
@@ -184,8 +203,116 @@ function www_ip_allocateSubRange()
 	}
 }
 
+function www_ip_modifySubnet()
+{
+	global $db, $wwwConnector;
+
+	$id = $_REQUEST["id"];
+	//("sn_id" INTEGER PRIMARY KEY AUTOINCREMENT,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
+	$sql = "select sn_name,sn_desc,sn_ip from subnet where sn_id=='$id'";
+	$res = $db->dbobject->query($sql);
+	
+	foreach($res as $row) {
+		$sn_name = $row["sn_name"];
+		$sn_desc = $row["sn_desc"];
+		$sn_ip = $row["sn_ip"];
+	}
+	
+	$wwwConnector->header();
+	$wwwConnector->printError();
+	
+	// ("ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,"ho_sn_id" INTEGER,"ho_ip" TEXT,"ho_name" TEXT,"ho_desc" TEXT)
+	?>
+<form method="post" action="?action=changesubdetails&id=<?php echo $id ?>">
+Subnet Name: <input type="text" name="subname" value="<?php echo $sn_name?>">
+Subnet Description: <input type="text" name="subdesc" value="<?php echo $sn_desc?>">
+<input type="submit" name="change" value="Update">
+</form>
+
+<form method="post" action="?action=addhosts&id=<?php echo $id ?>">
+<h3>Add Host</h3>
+Hostname <input type="text" name="hostname">
+IP Address <input type="text" name="hostip" value="<?php echo $sn_ip.":"?>">
+Description <input type="text" name="hostdesc" >
+<input type="submit" name="change" value="Add">
+</form>
+
+
+
+<table border=1>
+<tr><th>Host IP</th><th>Hostname</th><th>Description</th></tr>
+<?php
+	$sql = "select * from hosts where ho_sn_id='$id'";
+	$res = $db->dbobject->query($sql);
+	
+	foreach($res as $row) {
+		$name = $row["ho_name"];
+		$desc = $row["ho_desc"];
+		$ip = $row["ho_ip"];
+		$hid = $row["ho_id"];
+		echo "<tr><td>$ip</td><td>$name</td><td>$desc</td><td><a href=\"?action=deletehost&hostid=$hid&snid=$id\">Delete</a></td></tr>";
+	} 
+?>
+</table>
+
+
+<a href="index.php">Back</a>
+<?php
+
+	$wwwConnector->footer();
+}
+
+function www_ip_deletehost()
+{
+	global $db, $wwwConnector;
+	
+	$id = $_REQUEST["hostid"];
+	$sid = $_REQUEST["snid"];
+	
+	$sql = "delete from hosts where ho_id=='$id'";
+	$db->dbobject->query($sql);
+	
+	header("Location: ?action=modsubnet&id=$sid");
+}
+
+function www_ip_addhost()
+{
+	global $db, $wwwConnector;
+	
+	$id = $_REQUEST["id"];
+	$hn = $_REQUEST["hostname"];
+	$hip = $_REQUEST["hostip"];
+	$desc = $_REQUEST["hostdesc"];
+	
+	$sql = "insert into hosts values (NULL, '$id', '$hip', '$hn', '$desc')";
+	$db->dbobject->query($sql);
+	
+	header("Location: ?action=modsubnet&id=$id");
+}
+
+function www_ip_changesubdetails()
+{
+	global $db, $wwwConnector;
+	
+	$id = $_REQUEST["id"];
+	$name = $_REQUEST["subname"];
+	$desc = $_REQUEST["subdesc"];
+
+	$sql = "update subnet set sn_name='$name', sn_desc='$desc' where sn_id=='$id'";
+	$db->dbobject->query($sql);
+	
+	header("Location: ?action=modsubnet&id=$id");
+}
+
 function www_db_dumpdb()
 {
+	global $db;
+	
+	$datestamp = strftime("%d-%m-%Y-%H.%M.%S");
+	$name = "ipmandbdump-$datestamp.db";
+	header("Content-type: application/octet-stream;\n");
+	header("Content-Disposition: attachment; filename=\"$name\";\n\n");
+	$db->dump();
 }
 
 function www_db_restoredb()