Config now works with the new database routines

[friendica.git] / src / Core / Config.php

diff --git a/src/Core/Config.php b/src/Core/Config.php
index d454de39218f59071c13f11978e18f71f93f0c69..c0461531338a61e4f87502a0c5519d84e571ada9 100644 (file)
--- a/src/Core/Config.php
+++ b/src/Core/Config.php
@@ -1,6 +1,7 @@
 <?php
 namespace Friendica\Core;
 
+use dba;
 use dbm;
 
 /**
@@ -45,17 +46,15 @@ class Config {
 
                $a = get_app();
 
-               $r = q("SELECT `v`, `k` FROM `config` WHERE `cat` = '%s'", dbesc($family));
-               if (dbm::is_result($r)) {
-                       foreach ($r as $rr) {
-                               $k = $rr['k'];
-                               if ($family === 'config') {
-                                       $a->config[$k] = $rr['v'];
-                               } else {
-                                       $a->config[$family][$k] = $rr['v'];
-                                       self::$cache[$family][$k] = $rr['v'];
-                                       self::$in_db[$family][$k] = true;
-                               }
+               $r = dba::select('config', array('v', 'k'), array('cat' => $family), array("order" => array("cat", "k")));
+               while ($rr = dba::fetch($r)) {
+                       $k = $rr['k'];
+                       if ($family === 'config') {
+                               $a->config[$k] = $rr['v'];
+                       } else {
+                               $a->config[$family][$k] = $rr['v'];
+                               self::$cache[$family][$k] = $rr['v'];
+                               self::$in_db[$family][$k] = true;
                        }
                }
        }
@@ -98,13 +97,11 @@ class Config {
                        }
                }
 
-               $ret = q("SELECT `v` FROM `config` WHERE `cat` = '%s' AND `k` = '%s'",
-                       dbesc($family),
-                       dbesc($key)
-               );
+               $ret = dba::select('config', array('v'), array('cat' => $family, 'k' => $key),
+                                       array("order" => array("cat", "k"), 'limit' => 1));
                if (dbm::is_result($ret)) {
                        // manage array value
-                       $val = (preg_match("|^a:[0-9]+:{.*}$|s", $ret[0]['v']) ? unserialize($ret[0]['v']) : $ret[0]['v']);
+                       $val = (preg_match("|^a:[0-9]+:{.*}$|s", $ret['v']) ? unserialize($ret['v']) : $ret['v']);
 
                        // Assign the value from the database to the cache
                        self::$cache[$family][$key] = $val;
@@ -206,11 +203,8 @@ class Config {
                        unset(self::$cache[$family][$key]);
                        unset(self::$in_db[$family][$key]);
                }
-               $ret = q("DELETE FROM `config` WHERE `cat` = '%s' AND `k` = '%s'",
-                       dbesc($family),
-                       dbesc($key)
-               );
 
+               $ret = dba::delete('config', array('cat' => $family, 'k' => $key));
                return $ret;
        }
 }