X-Git-Url: http://git.pjr.cc/?a=blobdiff_plain;f=lib%2Fdb.php;h=6c6a4d57ebd08a1c4a9246f2889f24352ab3c468;hb=fd8bc263bd1e3923c94f949059d90d93b5faaf76;hp=77a9068dcf5dd9c79a53d7dcf05d057b8cd02811;hpb=0264b5a42242521bd85ab2568f4bf23381df7a36;p=PHPIPManager.git

diff --git a/lib/db.php b/lib/db.php
index 77a9068..6c6a4d5 100644
--- a/lib/db.php
+++ b/lib/db.php
@@ -22,7 +22,6 @@ class db {
 		
 		try {
 			$this->dbobject = new PDO("$DB_URI");
-			error_log("channy is a poof");
 		} catch(PDOException $exep) {
 			error_log("execpt on db open");
 		}
@@ -31,9 +30,35 @@ class db {
 			error_log("db open for init");
 			$this->init();
 		}
+		
 	}
 
 	public $dbobject = "";
+	
+	function dump() {
+		$sql = "select * from supernet";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "sn:".$row["sn_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
+		}
+		$sql = "select * from subnet";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "sbn:".$row["sn_id"].":".$row["snid_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n";
+		}
+		$sql = "select * from hosts";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			echo "hst:".$row["ho_id"].":".$row["ho_sn_id"].":".$row["ho_ip"].":".$row["ho_name"].":".$row["ho_desc"]."\n";
+		}
+	}
+	
+	function restore($restorefile) {
+		
+	}
 }