- Use sequence names only with PostgreSQL (#1486018)
| | |
| | | CHANGELOG RoundCube Webmail |
| | | =========================== |
| | | |
| | | - Use sequence names only with PostgreSQL (#1486018) |
| | | - Re-designed User Preferences interface |
| | | - Fix MS SQL DDL (#1486020) |
| | | - Fix rcube_mdb2.php: call to setCharset not implemented in mssql driver (#1486019) |
| | |
| | | VALUES (".intval($this->user_id).", ".$this->db->now().", 0, ".join(', ', $a_insert_values).")" |
| | | ); |
| | | |
| | | $insert_id = $this->db->insert_id(get_sequence_name('contacts')); |
| | | $insert_id = $this->db->insert_id('contacts'); |
| | | } |
| | | |
| | | return $insert_id; |
| | |
| | | * Get last inserted record ID |
| | | * For Postgres databases, a sequence name is required |
| | | * |
| | | * @param string Sequence name for increment |
| | | * @param string Table name (to find the incremented sequence) |
| | | * @return mixed ID or FALSE on failure |
| | | * @access public |
| | | */ |
| | | function insert_id($sequence = '') |
| | | function insert_id($table = '') |
| | | { |
| | | if (!$this->db_handle || $this->db_mode=='r') |
| | | return FALSE; |
| | | |
| | | $id = $this->db_handle->lastInsertID($sequence); |
| | | // find sequence name |
| | | if ($table && $this->db_provider == 'pgsql') |
| | | $table = get_sequence_name($table); |
| | | |
| | | $id = $this->db_handle->lastInsertID($table); |
| | | |
| | | return $this->db_handle->isError($id) ? null : $id; |
| | | } |
| | |
| | | call_user_func_array(array($this->db, 'query'), |
| | | array_merge(array($sql), $insert_values)); |
| | | |
| | | return $this->db->insert_id(get_sequence_name('identities')); |
| | | return $this->db->insert_id('identities'); |
| | | } |
| | | |
| | | |
| | |
| | | strip_newlines($data['alias'] ? $data['alias'] : $user_email), |
| | | $_SESSION['language']); |
| | | |
| | | if ($user_id = $dbh->insert_id(get_sequence_name('users'))) |
| | | if ($user_id = $dbh->insert_id('users')) |
| | | { |
| | | // create rcube_user instance to make plugin hooks work |
| | | $user_instance = new rcube_user($user_id); |