/**
* mixed fetch(void)
*
* Fetches a row from the query result and populates the Setting object.
*
* @return Setting returns settings object or false if no more rows to fetch
* @access public
*/
public function fetch()
{
$array = parent::fetchRow();
if ($array == false) {
return false;
}
$setting = new Setting();
foreach ($array as $key => $value) {
$setProp = $this->_map[$key]['mutator'];
if ($setProp && $value) {
$setting->{$setProp}(urldecode($value));
}
}
return $setting;
}
/**
* mixed fetch(void)
*
* Fetches a row from the query result.
*
* @return array returns array or false if no more rows to fetch
* @access public
*/
function fetch()
{
$array = parent::fetchRow(MYSQL_NUM);
return $array;
// false or array
}
/**
* mixed fetch(void)
*
* Fetches a row from the query result and populates the History object.
*
* @return History returns family antecedents or false if no more histories to fetch
* @access public
*/
function fetch()
{
$array = parent::fetchRow();
if ($array == false) {
return false;
}
$history = new History();
foreach ($array as $key => $value) {
$setProp = $this->_map[$key]['mutator'];
if ($setProp && $value) {
$history->{$setProp}(urldecode($value));
}
}
return $history;
}
/**
* bool existCssFile(string $file, int $id = 0)
*
* Executes a query
*
* @param string $file filename to know if exists
* @param int $id (optional) key of theme
* @return boolean returns true if file already exists or false if error occurs
* @access public
*/
function existCssFile($file, $id = 0)
{
$theme = new Theme();
if ($theme->isCssReserved($file)) {
$this->_error = "That filename is reserved for internal use.";
return false;
}
unset($theme);
$sql = "SELECT COUNT(css_file)";
$sql .= " FROM " . $this->_table;
$sql .= " WHERE css_file='" . urlencode($file) . "'";
if ($id) {
$sql .= " AND id_theme<>" . intval($id);
}
if (!$this->exec($sql)) {
return false;
}
$array = parent::fetchRow(MYSQL_NUM);
return $array[0] > 0;
}
/**
* bool existLogin(string $login, int $idMember = 0)
*
* Returns true if login already exists
*
* @param string $login staff member login
* @param int $idMember (optional) key of staff member
* @return boolean returns true if login already exists or false if error occurs
* @access public
*/
function existLogin($login, $idMember = 0)
{
$sql = "SELECT COUNT(login)";
$sql .= " FROM " . $this->_table;
$sql .= " WHERE login='******'";
// in BD it is urlencodeaded
if ($idMember) {
$sql .= " AND id_member<>" . intval($idMember);
}
if (!$this->exec($sql)) {
return false;
}
$array = parent::fetchRow(MYSQL_NUM);
return $array[0] > 0;
}
/**
* array fetchAll(string $col = "")
*
* Fetches all rows from the query result.
*
* @param $col (optional) name of the field result
* @return assocArray returns associative array containing domain codes and values.
* @access public
*/
function fetchAll($col = "")
{
if ($col == "") {
$col = "description";
}
$assoc = array();
while ($result = parent::fetchRow()) {
$assoc[$result["code"]] = $result[$col];
}
return $assoc;
}
