kinda stubb'ed the old config out for now and tacked it onto the new

[glcas.git] / libglcas / config.php

diff --git a/libglcas/config.php b/libglcas/config.php
index 6498046..499c97b 100644 (file)
--- a/libglcas/config.php
+++ b/libglcas/config.php
@@ -15,7 +15,7 @@ class GLCASConfig {
                $this->configPath = $configpath;
                
                try {
-                       $this->dbobject = new PDO("sqlite:".$this->configPath);
+                       $this->dbobject = new PDO("sqlite:$configpath");
                } catch(PDOException $exep) {
                        error_log("execpt on db open");
                        return false;
@@ -36,7 +36,7 @@ class GLCASConfig {
        {
                $sql = "select configvar from config where configname='$configname'";
                $res = $this->dbobject->query($sql);
-               $val = null;
+               $val = false;
                foreach($res as $row) {
                        $val = $row[0];
                        error_log("foreach, $val\n");
@@ -53,27 +53,43 @@ class GLCASConfig {
                return true;
        }
        
-       function addData($configType, $configName, $configVal)
+       function addData($configType, $configCat, $configName, $configVal)
        {
-               $sql = "insert into datatable values (NULL, '$configType', '$configName', '$configVal')";
+               $sql = "insert into datatable values (NULL, '$configType', '$configCat', $configName', '$configVal')";
                $this->dbobject->query($sql);
                
        }
        
-       function getData($configType, $configName="")
+       function saveConfig()
+       {
+               // stub function for old config method reverse compatability
+       }
+       
+       function getData($configType, $configCat="", $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'";
+               $haveWhere = false;
+               if($configCat != "") {
+                       $haveWhere = true;
+                       $wheredata = "where data_category='$configCat'";
                }
+               
+               if($configName != "") {
+                       if($haveWhere) {
+                               $wheredata .= " and data_name='$configName'";
+                       } else {
+                               $wheredata = "where data_name='$configName'";
+                       }
+               }
+               
+               $sql = "select data_val,data_category,data_name from datatable $wheredata";
                $res = $this->dbobject->query($sql);
                
                foreach($res as $row) {
                        $ret[$nret]["val"] = $row[0];
-                       if($configName == "") $ret[$nret]["name"] = $row[1];
+                       $ret[$nret]["cat"] = $row[1];
+                       $ret[$nret]["name"] = $row[2];
                        $nret++;
                }
                
@@ -86,7 +102,7 @@ class GLCASConfig {
                $this->dbobject->query($sql);
        }
        
-       function delAllDAta($configType, $configName)
+       function delAllDAta($configType, $configCat)
        {
                $sql = "delete from datatable where data_type='$configType' and data_name='$configName'";
                //echo "sql is $sql\n";
@@ -100,7 +116,7 @@ class GLCASConfig {
                
                foreach($res as $row) {
                        if($row[0] > 0) {
-                               echo "Tables exist\n";
+                               //echo "Tables exist\n";
                                return;
                        }
                }
@@ -109,7 +125,7 @@ class GLCASConfig {
                $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);';
+               $sql = 'CREATE TABLE "datatable" ("data_id" INTEGER PRIMARY KEY AUTOINCREMENT,"data_category" TEXT,"data_type" TEXT,"data_name" TEXT,"data_val" TEXT);';
                $this->dbobject->query($sql);
 
                $sql = 'CREATE TABLE sqlite_sequence(name,seq);';