Пример #1
0
 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);
 }
Пример #2
0
 /**
  * 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'])));
     }
 }