public function getSetting($settingName)
{
$settingName = TextMan::cleanSqlField($settingName);
if (array_key_exists($settingName, $this->_settings) === true) {
return $this->_settings[$settingName];
}
$query = $this->_loadedClasses['dbEngine']->runSelect('settings', 'value', '`name` = \'' . $settingName . '\'');
if ($this->_loadedClasses['dbEngine']->runCountRows() !== 1) {
$this->_settings[$settingName] = '';
return '';
}
$fetch = $this->_loadedClasses['dbEngine']->runSingleFetch();
$this->_settings[$settingName] = $fetch['value'];
return $fetch['value'];
}
public function runUpdate($table, $fields, $where)
{
$fieldsarr = '';
$table = TextMan::cleanSqlField($table);
if (is_array($fields) === true) {
foreach ($fields as $key => $value) {
$fieldsarr .= '`' . TextMan::cleanSqlField($key) . '` = \'' . $value . '\', ';
}
$fieldsarr = substr($fieldsarr, 0, strlen($fieldsarr) - 2);
} else {
$fieldsarr = TextMan::cleanSqlField($fields);
}
$query = 'UPDATE `' . $table . '` SET ' . $fieldsarr . ($where === null ? '' : ' WHERE ' . $where);
$this->_currentQuery = $query;
//echo $query . '<br /><br />';
$this->queryResult = mysql_query($query);
// or exit(mysql_error() . '<br />' . $query);
return true;
}
