X-Git-Url: http://git.pjr.cc/?p=glcas.git;a=blobdiff_plain;f=libglcas%2Fconfig.php;fp=libglcas%2Fconfig.php;h=649804651f372f3411e5c5de8ddf0b2d60b763d8;hp=2009823460466a5afff92850dbf35c29daf5e664;hb=fd77672af03a95b0d016c0c1cd76c0441a8857d1;hpb=ddd1046cdf03ee9df49543da5a11c804c1498a41

diff --git a/libglcas/config.php b/libglcas/config.php
index 2009823..6498046 100644
--- a/libglcas/config.php
+++ b/libglcas/config.php
@@ -6,74 +6,121 @@ class GLCASConfig {
 	{
 		$this->configPath = "";
 		$this->config = "";
+		$this->dbobject = false;
 	}
 	
 	function loadConfig($configpath)
 	{
 		error_log("loadConfig $configpath");
 		$this->configPath = $configpath;
-		$flt = file_get_contents($configpath);
-		$this->config = unserialize(base64_decode($flt));
 		
+		try {
+			$this->dbobject = new PDO("sqlite:".$this->configPath);
+		} catch(PDOException $exep) {
+			error_log("execpt on db open");
+			return false;
+		}
 		
+		$this->setupTables();
 	}
 	
-	function getConfigVar($var)
+	function setConfig($configname, $configval)
 	{
-		if(isset($this->config["$var"])) {
-			return $this->config["$var"];
-		} else return false;
+		$sql = "delete from config where configname='$configname'";
+		$this->dbobject->query($sql);
+		$sql = "insert into config values ('$configname', '$configval')";
+		$this->dbobject->query($sql);
 	}
 	
-	function setConfigVar($var, $value)
+	function getConfig($configname)
 	{
-		if(is_array($this->config)) {
-			foreach($this->config as $vkey => $val) {
-				if($vkey == "$var") {
-					error_log("reset config of $var to $value");
-					$this->config[$var] = $value;
-					return true;
-				}
-			}
-		} else error_log("config isnt array");
+		$sql = "select configvar from config where configname='$configname'";
+		$res = $this->dbobject->query($sql);
+		$val = null;
+		foreach($res as $row) {
+			$val = $row[0];
+			error_log("foreach, $val\n");
+		}
 		
-		// otherwise, set it
-		error_log("set config of $var to $value");
-		$this->config[$var] = $value;
-
+		return $val;
 	}
 	
-	function delConfigVar($var)
+	function delConfig($configname)
 	{
-		if(is_array($this->config)) {
-			foreach($this->config as $vkey => $val) {
-				if($vkey == "$var") {
-					error_log("remove config of $var to $value");
-					unset($this->config[$var]);
-					return true;
-				}
-			}
-		} else error_log("config isnt array");
+		$sql = "delete from config where configname='$configname'";
+		$this->dbobject->query($sql);
+		
+		return true;
+	}
+	
+	function addData($configType, $configName, $configVal)
+	{
+		$sql = "insert into datatable values (NULL, '$configType', '$configName', '$configVal')";
+		$this->dbobject->query($sql);
+		
+	}
+	
+	function getData($configType, $configName="")
+	{
+		$ret = null;
+		$nret = 0;
+		if($configName == "") {
+			$sql = "select data_val,data_name from datatable where data_type='$configType'";
+		} else {
+			$sql = "select data_val from datatable where data_type='$configType' and data_name='$configName'";
+		}
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			$ret[$nret]["val"] = $row[0];
+			if($configName == "") $ret[$nret]["name"] = $row[1];
+			$nret++;
+		}
+		
+		return $ret;
 	}
 	
-	function saveConfig()
+	function delData($configType, $configName, $configVal)
 	{
-		file_put_contents($this->configPath, base64_encode(serialize($this->config)));
+		$sql = "delete from datatable where data_type='$configType' and data_name='$configName' and data_val='$configVal')";
+		$this->dbobject->query($sql);
 	}
 	
-	function debug()
+	function delAllDAta($configType, $configName)
 	{
-		echo "<pre>";
-		echo "path: ".$this->configPath."\n";
-		print_r($this->config);
-		echo "</pre>";
+		$sql = "delete from datatable where data_type='$configType' and data_name='$configName'";
+		//echo "sql is $sql\n";
+		$this->dbobject->query($sql);
+	}
+	
+	function setupTables()
+	{
+		$sql = "SELECT count(name) FROM sqlite_master WHERE type='table' AND name='config';";
+		$res = $this->dbobject->query($sql);
+		
+		foreach($res as $row) {
+			if($row[0] > 0) {
+				echo "Tables exist\n";
+				return;
+			}
+		}
+		
+		
+		$sql = 'CREATE TABLE "config" ( "configname" TEXT,"configvar" TEXT);';
+		$this->dbobject->query($sql);
+		
+		$sql = 'CREATE TABLE "datatable" ("data_id" INTEGER PRIMARY KEY AUTOINCREMENT,"data_type" TEXT,"data_name" TEXT,"data_val" TEXT);';
+		$this->dbobject->query($sql);
+
+		$sql = 'CREATE TABLE sqlite_sequence(name,seq);';
+		$this->dbobject->query($sql);
 	}
 	
 	private $configPath;
-	private $config;
+	private $dbobject;
 	
 }
-
+		
 function glcas_getWebConfigPath()
 {
 	global $WEB_ROOT_FS, $URL_HANDLERS, $BASE_URL;
@@ -88,5 +135,6 @@ function glcas_getWebConfigPath()
 	//return false;	
 }
 
+		
 
-?>
\ No newline at end of file
+?>