1 files changed, 63 insertions, 0 deletions
diff --git a/www/inc/db.class.inc.php b/www/inc/db.class.inc.php
new file mode 100644
index 0000000..00804a7
--- /dev/null
+++ b/www/inc/db.class.inc.php
@@ -0,0 +1,63 @@
+<?php
+/* SQLite DB class for storing
+   - image views,
+	 - user comments
+*/
+
+$dbfile = "$root/$gallery_dir/photos.db";
+
+//unfortunately in php4, the SQLiteDatabse class isn't created so we have to
+
+class SQLiteDatabase {
+	var $dbfile;
+
+	function SQLiteDatabase ($dbfile) {
+		
+		$this->dbfile = $dbfile;
+		//if db file doesn't exist, fill with skeleton
+		if (file_exists($this->dbfile)) {
+			$this->dbres = sqlite_open($this->dbfile, 0666, $sqliteerror);
+		} else {
+			//fill with skeleton
+			$folder = dirname($this->dbfile);
+			if (!is_writable($folder)) { //we need write permission to create database
+				die("<p style=\"color:red;\">cannot create dabase. check permissions.</p>\n");
+			} else {
+				$this->dbres = sqlite_open($this->dbfile, 0666, $sqliteerror);
+				//photo table
+				$sql = "create table photo (id INTEGER PRIMARY KEY, caption TEXT, ";
+				$sql .= "counter INTEGER, number INTEGER, album TEXT, name TEXT)";
+				$this->query($sql);
+				//comment table
+				$sql = "create table comment (id INTEGER PRIMARY KEY, user TEXT, ";
+				$sql .= "comment_body TEXT, photo_id INT, date DATETIME)";
+				$this->query($sql);
+			}
+		}
+	}
+
+	function query($sql) {
+		global $page;
+
+		if (!$this->result = sqlite_query($this->dbres, $sql)) {
+				print "Query failed, <span style=\"color: blue;\"><pre>$sql</pre></style>\n";
+				print sqlite_error_string (sqlite_last_error($this->dbres));
+				$page->footer();
+				exit;
+		}
+	}
+
+	function count() {
+		return sqlite_num_rows($this->result);
+	}
+
+	function rewind() { //just to abstract from sqlite
+		sqlite_rewind($this->result);
+	}
+	
+}
+
+
+$db = new SQLiteDatabase("$dbfile");
+
+?>