function _key4sql($value)
{
if ($this->_keyType == XOBJ_DTYPE_INT) {
$value = intval($value);
} else {
$value = $this->_db->quoteString($value);
}
return $value;
}
/**
* Assign a value to 1 field for tickets matching a set of conditions
*
* @param string $fieldname
* @param string $fieldvalue
* @param object $criteria {@link CriteriaElement}
*
* @return bool FALSE if update failed
* @access public
*/
public function updateAll($fieldname, $fieldvalue, $criteria = null)
{
$set_clause = is_numeric($fieldvalue) ? $fieldname . ' = ' . $fieldvalue : $fieldname . ' = ' . $this->_db->quoteString($fieldvalue);
$sql = 'UPDATE ' . $this->_db->prefix($this->_dbtable) . ' SET ' . $set_clause;
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
$sql .= ' ' . $criteria->renderWhere();
}
if (!($result = $this->_db->query($sql))) {
return false;
}
return true;
}
