]> git.mxchange.org Git - friendica.git/blobdiff - include/Core/PConfig.php
Prevent a memory Access Violation when the database isn't connected
[friendica.git] / include / Core / PConfig.php
index 082f1c05c2f85d3097f2daf9655987611631d476..c5e8335d88bbd96fd307d76735c4d64ce2845957 100644 (file)
@@ -29,7 +29,7 @@ class PConfig {
         */
        public static function load($uid,$family) {
                global $a;
-               $r = q("SELECT `v`,`k` FROM `pconfig` WHERE `cat` = '%s' AND `uid` = %d",
+               $r = q("SELECT `v`,`k` FROM `pconfig` WHERE `cat` = '%s' AND `uid` = %d ORDER BY `cat`, `k`, `id`",
                        dbesc($family),
                        intval($uid)
                );
@@ -83,7 +83,7 @@ class PConfig {
                        }
                }
 
-               $ret = q("SELECT `v` FROM `pconfig` WHERE `uid` = %d AND `cat` = '%s' AND `k` = '%s' LIMIT 1",
+               $ret = q("SELECT `v` FROM `pconfig` WHERE `uid` = %d AND `cat` = '%s' AND `k` = '%s' ORDER BY `id` DESC LIMIT 1",
                        intval($uid),
                        dbesc($family),
                        dbesc($key)
@@ -119,7 +119,7 @@ class PConfig {
         *  The value to store
         * @return mixed Stored $value or false
         */
-       public static function set($uid,$family,$key,$value) {
+       public static function set($uid, $family, $key, $value) {
 
                global $a;
 
@@ -136,8 +136,9 @@ ON DUPLICATE KEY UPDATE `v` = '%s'",
                        dbesc($dbvalue),
                        dbesc($dbvalue)
                );
-               if($ret)
+               if ($ret) {
                        return $value;
+               }
                return $ret;
        }