Projekt

Obecné

Profil

Stáhnout (2.33 KB) Statistiky
| Větev: | Tag: | Revize:
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is release under GPLv3 licence.
*
* More info about licence can be found:
* http://www.gnu.org/licenses/gpl-3.0.html
*
* More info about project can be found:
* http://www.freenetis.org/
*
*/

/**
* Config values.
* Do not use these methods use class Settings!
*
* @package Model
* @see Settings#get
* @see Settings#set
*/
class Config_Model extends Model
{
/**
* Gets value from config
*
* @param string $name Key value
* @return string
*/
public function get_value_from_name($name = '')
{
// try if query return exception, for example config table doesn't exist
try
{
$result = $this->db->query("
select value
from config
where name = ?
", $name);

return (!is_null($result) && count($result)) ? $result[0]->value : '';
}
catch (Kohana_Database_Exception $e)
{
return '';
}
}

/**
* Gets all values from config to assoc. array
* where key is name and value is value.
*
* Do not fetch values which containst word 'pass', because of security
* of services provided by freenetis.
*
* @return array
*/
public function get_all_values()
{
// query
$data = $this->db->query("
select name, value
from config
where name not like '%pass%'
order by name
");
// create array
$arr_data = array();
foreach ($data as $row)
{
$arr_data[$row->name] = $row->value;
}
// get data
return $arr_data;
}

/**
* Checks if var exists in config
*
* @param string $name Key value
* @return boolean
*/
public function check_exist_variable($name = '')
{
return ($this->db->query("
select value
from config
where name = ?
", $name)->count() > 0);
}

/**
* Updates value in config
*
* @param string $name Key value
* @param string $value Value
* @return boolean
*/
public function update_variable($name, $value)
{
return $this->db->query("
update config
set value = ?
where name = ?
", $value, $name);
}

/**
* Insert value in config
*
* @param string $name Key value
* @param string $value Value
* @return boolean
*/
public function insert_variable($name, $value)
{
return $this->db->query("
insert into config (name,value)
values(?,?)
", $name, $value);
}

}
(22-22/101)