Index: trunk/core/kernel/db/db_connection.php =================================================================== diff -u -N -r1560 -r3576 --- trunk/core/kernel/db/db_connection.php (.../db_connection.php) (revision 1560) +++ trunk/core/kernel/db/db_connection.php (.../db_connection.php) (revision 3576) @@ -538,5 +538,35 @@ { return $this->errorMessage; } + + function doInsert($fields_hash, $table) + { + $fields_sql = ''; + $values_sql = ''; + foreach ($fields_hash as $field_name => $field_value) { + $fields_sql .= '`'.$field_name.'`,'; + $values_sql .= $this->qstr($field_value).','; + } + + $fields_sql = preg_replace('/(.*),$/', '\\1', $fields_sql); + $values_sql = preg_replace('/(.*),$/', '\\1', $values_sql); + $sql = 'INSERT INTO `'.$table.'` ('.$fields_sql.') VALUES ('.$values_sql.')'; + + return $this->ChangeQuery($sql); + } + + function doUpdate($fields_hash, $table, $key_clause) + { + $fields_sql = ''; + foreach ($fields_hash as $field_name => $field_value) { + $fields_sql .= '`'.$field_name.'` = '.$this->qstr($field_value).','; + } + + $fields_sql = preg_replace('/(.*),$/', '\\1', $fields_sql); + + $sql = 'UPDATE `'.$table.'` SET '.$fields_sql.' WHERE '.$key_clause; + + return $this->ChangeQuery($sql); + } } ?> \ No newline at end of file