Add helper function to Setting class

Added a static helper function to replacing (or inserting) an option value in the database, longhand.

1 files changed, 17 insertions, 0 deletions

diff --git a/app/class/setting.class.php b/app/class/setting.class.php
index ea5fac3..b48f241 100644
--- a/app/class/setting.class.php
+++ b/app/class/setting.class.php
@@ -23,6 +23,23 @@ class Setting extends Framework
 
         return $res[0]['value'];
     }
+
+    /*
+     * Helper function for setting setting values on the database
+     */
+    static function setValue($key, $value)
+    {
+        $db = parent::getDbConnection();
+        $escdKey = $db->esc($key);
+        $escdValue = $db->esc($value);
+
+        if (self::getValue($key) === false)
+            $query = "INSERT INTO setting (`key`, value) VALUES('" . $escdKey . "', '" . $escdValue . "')";
+        else
+            $query = "UPDATE setting SET value = '" . $escdValue . "' WHERE `key` = '" . $escdKey . "'";
+
+        $db->query($query);
+    }
 }
 
 ?>