X-Git-Url: http://git.pjr.cc/?p=PHPIPManager.git;a=blobdiff_plain;f=lib%2Fdb.php;fp=lib%2Fdb.php;h=afa66798d4ce3836bdddba02ac11e9324228e698;hp=0000000000000000000000000000000000000000;hb=bb7eb6654bf2983a7c9d45ad22b0ddbc5608dbe5;hpb=89d9c16291e80d7eb7d37d824e41f799095d3666

diff --git a/lib/db.php b/lib/db.php
new file mode 100644
index 0000000..afa6679
--- /dev/null
+++ b/lib/db.php
@@ -0,0 +1,44 @@
+<?php
+
+// i really dont know why i do another obfuscation layer for db's with adodb.
+class db {
+	function init() {
+
+		$sql = 'CREATE TABLE sqlite_sequence(name,seq);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE "hosts" ("ho_id" INTEGER PRIMARY KEY AUTOINCREMENT,"ho_sn_id" INTEGER,"ho_ip" TEXT,"ho_name" TEXT,"ho_desc" TEXT);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE subnet ("sn_id" INTEGER,"snid_id" INTEGER,"sn_ip" TEXT,"sn_mask" TEXT,"sn_name" TEXT, "sn_desc" TEXT);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE supernet ("sn_id" INTEGER,"sn_name" TEXT,"sn_ip" TEXT,"sn_mask" TEXT,"sn_desc" TEXT);';
+		$this->dbobject->query($sql);
+	}
+	
+	function connect() {
+		global $DB_URI;
+		
+		try {
+			$this->dbobject = new PDO("$DB_URI");
+			error_log("channy is a poof");
+		} catch(PDOException $exep) {
+			error_log("execpt on db open");
+		}
+		
+		if(!$this->dbobject->query("select * from hosts")) {
+			error_log("db open for init");
+			$this->init();
+		}
+	}
+
+	public $dbobject = "";
+}
+
+
+
+$db = new db();
+global $db;
+
+?>
\ No newline at end of file