connection Database connection object
protected $table; ///< string Settings table name
protected $blog_id; ///< string Blog ID
protected $global_settings = array(); ///< array Global settings array
protected $local_settings = array(); ///< array Local settings array
protected $settings = array(); ///< array Associative settings array
protected $ns; ///< string Current namespace
/**
Object constructor. Retrieves blog settings and puts them in $settings
array. Local (blog) settings have a highest priority than global settings.
@param name string ID for this namespace
*/
public function __construct(&$core, $blog_id, $name, $rs=null)
{
if (preg_match('/^[a-zA-Z][a-zA-Z0-9]+$/',$name)) {
$this->ns = $name;
} else {
throw new Exception(sprintf(__('Invalid setting dcNamespace: %s'),$name));
}
$this->con =& $core->con;
$this->table = $core->prefix.'setting';
$this->blog_id =& $blog_id;
$this->getSettings($rs);
}
private function getSettings($rs=null)
{
if ($rs == null) {
$strReq = 'SELECT blog_id, setting_id, setting_value, '.
'setting_type, setting_label, setting_ns '.
'FROM '.$this->table.' '.
"WHERE (blog_id = '".$this->con->escape($this->blog_id)."' ".
'OR blog_id IS NULL) '.
"AND setting_ns = '".$this->con->escape($this->ns)."' ".
'ORDER BY setting_id DESC ';
try {
$rs = $this->con->select($strReq);
} catch (Exception $e) {
trigger_error(__('Unable to retrieve settings:').' '.$this->con->error(), E_USER_ERROR);
}
}
while ($rs->fetch())
{
if ($rs->f('setting_ns') != $this->ns){
break;
}
$id = trim($rs->f('setting_id'));
$value = $rs->f('setting_value');
$type = $rs->f('setting_type');
if ($type == 'float' || $type == 'double') {
$type = 'float';
} elseif ($type != 'boolean' && $type != 'integer') {
$type = 'string';
}
settype($value,$type);
$array = $rs->blog_id ? 'local' : 'global';
$this->{$array.'_settings'}[$id] = array(
'ns' => $this->ns,
'value' => $value,
'type' => $type,
'label' => (string) $rs->f('setting_label'),
'global' => $rs->blog_id == ''
);
}
$this->settings = $this->global_settings;
foreach ($this->local_settings as $id => $v) {
$this->settings[$id] = $v;
}
return true;
}
private function settingExists($id,$global=false)
{
$array = $global ? 'global' : 'local';
return isset($this->{$array.'_settings'}[$id]);
}
/**
Returns setting value if exists.
@param n string Setting name
@return mixed
*/
public function get($n)
{
if (isset($this->settings[$n]['value'])) {
return $this->settings[$n]['value'];
}
return null;
}
/**
Returns global setting value if exists.
@param n string setting name
@return mixed
*/
public function getGlobal($n)
{
if (isset($this->global_settings[$n]['value'])) {
return $this->global_settings[$n]['value'];
}
return null;
}
/**
Returns local setting value if exists.
@param n string setting name
@return mixed
*/
public function getLocal($n)
{
if (isset($this->local_settings[$n]['value'])) {
return $this->local_settings[$n]['value'];
}
return null;
}
/**
Magic __get method.
@copydoc ::get
*/
public function __get($n)
{
return $this->get($n);
}
/**
Sets a setting in $settings property. This sets the setting for script
execution time only and if setting exists.
@param n string Setting name
@param v mixed Setting value
*/
public function set($n,$v)
{
if (isset($this->settings[$n])) {
$this->settings[$n]['value'] = $v;
}
}
/**
Magic __set method.
@copydoc ::set
*/
public function __set($n,$v)
{
$this->set($n,$v);
}
/**
Creates or updates a setting.
$type could be 'string', 'integer', 'float', 'boolean' or null. If $type is
null and setting exists, it will keep current setting type.
$value_change allow you to not change setting. Useful if you need to change
a setting label or type and don't want to change its value.
@param id string Setting ID
@param value mixed Setting value
@param type string Setting type
@param label string Setting label
@param value_change boolean Change setting value or not
@param global boolean Setting is global
*/
public function put($id,$value,$type=null,$label=null,$value_change=true,$global=false)
{
if (!preg_match('/^[a-zA-Z][a-zA-Z0-9_]+$/',$id)) {
throw new Exception(sprintf(__('%s is not a valid setting id'),$id));
}
# We don't want to change setting value
if (!$value_change)
{
if (!$global && $this->settingExists($id,false)) {
$value = $this->local_settings[$id]['value'];
} elseif ($this->settingExists($id,true)) {
$value = $this->global_settings[$id]['value'];
}
}
# Setting type
if ($type == 'double')
{
$type = 'float';
}
elseif ($type === null)
{
if (!$global && $this->settingExists($id,false)) {
$type = $this->local_settings[$id]['type'];
} elseif ($this->settingExists($id,true)) {
$type = $this->global_settings[$id]['type'];
} else {
$type = 'string';
}
}
elseif ($type != 'boolean' && $type != 'integer' && $type != 'float')
{
$type = 'string';
}
# We don't change label
if ($label == null)
{
if (!$global && $this->settingExists($id,false)) {
$label = $this->local_settings[$id]['label'];
} elseif ($this->settingExists($id,true)) {
$label = $this->global_settings[$id]['label'];
}
}
settype($value,$type);
$cur = $this->con->openCursor($this->table);
$cur->setting_value = ($type == 'boolean') ? (string) (integer) $value : (string) $value;
$cur->setting_type = $type;
$cur->setting_label = $label;
#If we are local, compare to global value
if (!$global && $this->settingExists($id,true))
{
$g = $this->global_settings[$id];
$same_setting = $g['ns'] == $this->ns && $g['value'] == $value
&& $g['type'] == $type && $g['label'] == $label;
# Drop setting if same value as global
if ($same_setting && $this->settingExists($id,false)) {
$this->drop($id);
} elseif ($same_setting) {
return;
}
}
if ($this->settingExists($id,$global) && $this->ns == $this->settings[$id]['ns'])
{
if ($global) {
$where = 'WHERE blog_id IS NULL ';
} else {
$where = "WHERE blog_id = '".$this->con->escape($this->blog_id)."' ";
}
$cur->update($where."AND setting_id = '".$this->con->escape($id)."' AND setting_ns = '".$this->con->escape($this->ns)."' ");
}
else
{
$cur->setting_id = $id;
$cur->blog_id = $global ? null : $this->blog_id;
$cur->setting_ns = $this->ns;
$cur->insert();
}
}
/**
Rename an existing setting in a Namespace
@param $oldId string Current setting name
@param $newId string New setting name
@return boolean
*/
public function rename($oldId,$newId)
{
if (!$this->ns) {
throw new Exception(__('No namespace specified'));
}
if (!array_key_exists($oldId,$this->settings) || array_key_exists($newId,$this->settings)) {
return false;
}
// Rename the setting in the settings array
$this->settings[$newId] = $this->settings[$oldId];
unset($this->settings[$oldId]);
// Rename the setting in the database
$strReq = 'UPDATE '.$this->table.
" SET setting_id = '".$this->con->escape($newId)."' ".
" WHERE setting_ns = '".$this->con->escape($this->ns)."' ".
" AND setting_id = '".$this->con->escape($oldId)."' ";
$this->con->execute($strReq);
return true;
}
/**
Removes an existing setting in a Namespace
@param id string Setting ID
*/
public function drop($id)
{
if (!$this->ns) {
throw new Exception(__('No namespace specified'));
}
$strReq = 'DELETE FROM '.$this->table.' ';
if ($this->blog_id === null) {
$strReq .= 'WHERE blog_id IS NULL ';
} else {
$strReq .= "WHERE blog_id = '".$this->con->escape($this->blog_id)."' ";
}
$strReq .= "AND setting_id = '".$this->con->escape($id)."' ";
$strReq .= "AND setting_ns = '".$this->con->escape($this->ns)."' ";
$this->con->execute($strReq);
}
/**
Removes all existing settings in a Namespace
@param force_global boolean Force global pref drop
*/
public function dropAll($force_global=false)
{
if (!$this->ns) {
throw new Exception(__('No namespace specified'));
}
$strReq = 'DELETE FROM '.$this->table.' ';
if (($force_global) || ($this->blog_id === null)) {
$strReq .= 'WHERE blog_id IS NULL ';
$global = true;
} else {
$strReq .= "WHERE blog_id = '".$this->con->escape($this->blog_id)."' ";
$global = false;
}
$strReq .= "AND setting_ns = '".$this->con->escape($this->ns)."' ";
$this->con->execute($strReq);
$array = $global ? 'global' : 'local';
unset($this->{$array.'_settings'});
$this->{$array.'_settings'} = array();
$array = $global ? 'local' : 'global';
$this->settings = $this->{$array.'_settings'};
}
/**
Returns $settings property content.
@return array
*/
public function dumpSettings()
{
return $this->settings;
}
/**
Returns $global_settings property content.
@return array
*/
public function dumpGlobalSettings()
{
return $this->global_settings;
}
}
?>