Lots of changes

[PHPIPManager.git] / lib / db.php

diff --git a/lib/db.php b/lib/db.php
new file mode 100644 (file)
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