<?php
+/**
+ * @file src/Core/PConfig.php
+ */
namespace Friendica\Core;
-use dbm;
+use Friendica\Database\DBM;
+use dba;
/**
* @file include/Core/PConfig.php
* The PConfig::get() functions return boolean false for keys that are unset,
* and this could lead to subtle bugs.
*/
-class PConfig {
-
+class PConfig
+{
private static $in_db;
/**
* All configuration values of the given user are stored in global cache
* which is available under the global variable $a->config[$uid].
*
- * @param string $uid
- * The user_id
- * @param string $family
- * The category of the configuration value
+ * @param string $uid The user_id
+ * @param string $family The category of the configuration value
+ *
* @return void
*/
- public static function load($uid, $family) {
+ public static function load($uid, $family)
+ {
$a = get_app();
- $r = q("SELECT `v`,`k` FROM `pconfig` WHERE `cat` = '%s' AND `uid` = %d ORDER BY `cat`, `k`, `id`",
- dbesc($family),
- intval($uid)
- );
- if (dbm::is_result($r)) {
- foreach ($r as $rr) {
+
+ $r = dba::select('pconfig', array('v', 'k'), array('cat' => $family, 'uid' => $uid));
+ if (DBM::is_result($r)) {
+ while ($rr = dba::fetch($r)) {
$k = $rr['k'];
$a->config[$uid][$family][$k] = $rr['v'];
self::$in_db[$uid][$family][$k] = true;
// Negative caching
$a->config[$uid][$family] = "!<unset>!";
}
+ dba::close($r);
}
/**
* Get a particular user's config value from the given category ($family)
* and the $key from a cached storage in $a->config[$uid].
*
- * @param string $uid
- * The user_id
- * @param string $family
- * The category of the configuration value
- * @param string $key
- * The configuration key to query
- * @param mixed $default_value optional
- * The value to return if key is not set (default: null)
- * @param boolean $refresh optional
- * If true the config is loaded from the db and not from the cache (default: false)
+ * @param string $uid The user_id
+ * @param string $family The category of the configuration value
+ * @param string $key The configuration key to query
+ * @param mixed $default_value optional, The value to return if key is not set (default: null)
+ * @param boolean $refresh optional, If true the config is loaded from the db and not from the cache (default: false)
+ *
* @return mixed Stored value or null if it does not exist
*/
- public static function get($uid, $family, $key, $default_value = null, $refresh = false) {
-
+ public static function get($uid, $family, $key, $default_value = null, $refresh = false)
+ {
$a = get_app();
if (!$refresh) {
}
}
- $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)
- );
-
- if (count($ret)) {
- $val = (preg_match("|^a:[0-9]+:{.*}$|s", $ret[0]['v'])?unserialize( $ret[0]['v']):$ret[0]['v']);
+ $ret = dba::select('pconfig', array('v'), array('uid' => $uid, 'cat' => $family, 'k' => $key), array('limit' => 1));
+ if (DBM::is_result($ret)) {
+ $val = (preg_match("|^a:[0-9]+:{.*}$|s", $ret['v']) ? unserialize($ret['v']) : $ret['v']);
$a->config[$uid][$family][$key] = $val;
self::$in_db[$uid][$family][$key] = true;
*
* @note Please do not store booleans - convert to 0/1 integer values!
*
- * @param string $uid
- * The user_id
- * @param string $family
- * The category of the configuration value
- * @param string $key
- * The configuration key to set
- * @param string $value
- * The value to store
+ * @param string $uid The user_id
+ * @param string $family The category of the configuration value
+ * @param string $key The configuration key to set
+ * @param string $value 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)
+ {
$a = get_app();
// We store our setting values in a string variable.
// manage array value
$dbvalue = (is_array($value) ? serialize($value) : $dbvalue);
- if (is_null($stored) || !self::$in_db[$uid][$family][$key]) {
- $ret = q("INSERT INTO `pconfig` (`uid`, `cat`, `k`, `v`) VALUES (%d, '%s', '%s', '%s') ON DUPLICATE KEY UPDATE `v` = '%s'",
- intval($uid),
- dbesc($family),
- dbesc($key),
- dbesc($dbvalue),
- dbesc($dbvalue)
- );
- } else {
- $ret = q("UPDATE `pconfig` SET `v` = '%s' WHERE `uid` = %d AND `cat` = '%s' AND `k` = '%s'",
- dbesc($dbvalue),
- intval($uid),
- dbesc($family),
- dbesc($key)
- );
- }
+ dba::update('pconfig', array('v' => $dbvalue), array('uid' => $uid, 'cat' => $family, 'k' => $key), true);
if ($ret) {
self::$in_db[$uid][$family][$key] = true;
* Removes the configured value from the stored cache in $a->config[$uid]
* and removes it from the database.
*
- * @param string $uid The user_id
- * @param string $family
- * The category of the configuration value
- * @param string $key
- * The configuration key to delete
+ * @param string $uid The user_id
+ * @param string $family The category of the configuration value
+ * @param string $key The configuration key to delete
+ *
* @return mixed
*/
- public static function delete($uid,$family,$key) {
-
+ public static function delete($uid, $family, $key)
+ {
$a = get_app();
if (x($a->config[$uid][$family], $key)) {
unset(self::$in_db[$uid][$family][$key]);
}
- $ret = q("DELETE FROM `pconfig` WHERE `uid` = %d AND `cat` = '%s' AND `k` = '%s'",
- intval($uid),
- dbesc($family),
- dbesc($key)
- );
+ $ret = dba::delete('pconfig', array('uid' => $uid, 'cat' => $family, 'k' => $key));
return $ret;
}
projects / friendica.git / blobdiff