public function updateItem($setting, $value) { $db = new DB(); $sql = sprintf("update settings set value = %s where setting = %s", $db->escapeString($value), $db->escapeString($setting)); return $db->exec($sql); }
/** * Insert release into Sphinx RT table. * @param $parameters */ public function insertRelease($parameters) { if (!is_null($this->sphinxQL) && $parameters['id']) { $this->sphinxQL->queryExec(sprintf('REPLACE INTO releases_rt (id, name, searchname, fromname, filename) VALUES (%d, %s, %s, %s, %s)', $parameters['id'], $this->sphinxQL->escapeString($parameters['name']), $this->sphinxQL->escapeString($parameters['searchname']), $this->sphinxQL->escapeString($parameters['fromname']), empty($parameters['filename']) ? "''" : $this->sphinxQL->escapeString($parameters['filename']))); } }