diff options
Diffstat (limited to 'phpBB/includes/config/db_text.php')
| -rw-r--r-- | phpBB/includes/config/db_text.php | 163 | 
1 files changed, 0 insertions, 163 deletions
diff --git a/phpBB/includes/config/db_text.php b/phpBB/includes/config/db_text.php deleted file mode 100644 index b365cb5c77..0000000000 --- a/phpBB/includes/config/db_text.php +++ /dev/null @@ -1,163 +0,0 @@ -<?php -/** -* -* @package phpBB3 -* @copyright (c) 2013 phpBB Group -* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2 -* -*/ - -/** -* @ignore -*/ -if (!defined('IN_PHPBB')) -{ -	exit; -} - -/** -* Manages configuration options with an arbitrary length value stored in a TEXT -* column. In constrast to class phpbb_config_db, values are never cached and -* prefetched, but every get operation sends a query to the database. -* -* @package phpBB3 -*/ -class phpbb_config_db_text -{ -	/** -	* Database connection -	* @var phpbb_db_driver -	*/ -	protected $db; - -	/** -	* Name of the database table used. -	* @var string -	*/ -	protected $table; - -	/** -	* @param phpbb_db_driver $db        Database connection -	* @param string          $table     Table name -	*/ -	public function __construct(phpbb_db_driver $db, $table) -	{ -		$this->db = $db; -		$this->table = $this->db->sql_escape($table); -	} - -	/** -	* Sets the configuration option with the name $key to $value. -	* -	* @param string $key       The configuration option's name -	* @param string $value     New configuration value -	* -	* @return null -	*/ -	public function set($key, $value) -	{ -		$this->set_array(array($key => $value)); -	} - -	/** -	* Gets the configuration value for the name $key. -	* -	* @param string $key       The configuration option's name -	* -	* @return string|null      String result on success -	*                          null if there is no such option -	*/ -	public function get($key) -	{ -		$map = $this->get_array(array($key)); - -		return isset($map[$key]) ? $map[$key] : null; -	} - -	/** -	* Removes the configuration option with the name $key. -	* -	* @param string $key       The configuration option's name -	* -	* @return null -	*/ -	public function delete($key) -	{ -		$this->delete_array(array($key)); -	} - -	/** -	* Mass set configuration options: Receives an associative array, -	* treats array keys as configuration option names and associated -	* array values as their configuration option values. -	* -	* @param array $map        Map from configuration names to values -	* -	* @return null -	*/ -	public function set_array(array $map) -	{ -		$this->db->sql_transaction('begin'); - -		foreach ($map as $key => $value) -		{ -			$sql = 'UPDATE ' . $this->table . " -				SET config_value = '" . $this->db->sql_escape($value) . "' -				WHERE config_name = '" . $this->db->sql_escape($key) . "'"; -			$result = $this->db->sql_query($sql); - -			if (!$this->db->sql_affectedrows($result)) -			{ -				$sql = 'INSERT INTO ' . $this->table . ' ' . $this->db->sql_build_array('INSERT', array( -					'config_name'	=> $key, -					'config_value'	=> $value, -				)); -				$this->db->sql_query($sql); -			} -		} - -		$this->db->sql_transaction('commit'); -	} - -	/** -	* Mass get configuration options: Receives a set of configuration -	* option names and returns the result as a key => value map where -	* array keys are configuration option names and array values are -	* associated config option values. -	* -	* @param array $keys       Set of configuration option names -	* -	* @return array            Map from configuration names to values -	*/ -	public function get_array(array $keys) -	{ -		$sql = 'SELECT * -			FROM ' . $this->table . ' -			WHERE ' . $this->db->sql_in_set('config_name', $keys, false, true); -		$result = $this->db->sql_query($sql); - -		$map = array(); -		while ($row = $this->db->sql_fetchrow($result)) -		{ -			$map[$row['config_name']] = $row['config_value']; -		} -		$this->db->sql_freeresult($result); - -		return $map; -	} - -	/** -	* Mass delete configuration options. -	* -	* @param array $keys       Set of configuration option names -	* -	* @return null -	*/ -	public function delete_array(array $keys) -	{ -		$sql = 'DELETE -			FROM ' . $this->table . ' -			WHERE ' . $this->db->sql_in_set('config_name', $keys, false, true); -		$result = $this->db->sql_query($sql); -	} -}  | 
