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; }