| | |
| | | $RC = rcube::get_instance(); |
| | | $DB = rcube_db::factory($RC->config->get('db_dsnw')); |
| | | |
| | | $DB->set_debug((bool)$RC->config->get('sql_debug')); |
| | | |
| | | // Connect to database |
| | | $DB->db_connect('w'); |
| | | if (!$DB->is_connected()) { |
| | |
| | | '0.2-alpha' => 2008040500, |
| | | '0.2-beta' => 2008060900, |
| | | '0.2-stable' => 2008092100, |
| | | '0.2.1' => 2008092100, |
| | | '0.2.2' => 2008092100, |
| | | '0.3-stable' => 2008092100, |
| | | '0.3.1' => 2009090400, |
| | | '0.4-beta' => 2009103100, |
| | | '0.4' => 2010042300, |
| | | '0.4.1' => 2010042300, |
| | | '0.4.2' => 2010042300, |
| | | '0.5-beta' => 2010100600, |
| | | '0.5' => 2010100600, |
| | | '0.5.1' => 2010100600, |
| | | '0.5.2' => 2010100600, |
| | | '0.5.3' => 2010100600, |
| | | '0.5.4' => 2010100600, |
| | | '0.6-beta' => 2011011200, |
| | | '0.6' => 2011011200, |
| | | '0.7-beta' => 2011092800, |
| | |
| | | global $DB; |
| | | |
| | | // read DDL file |
| | | if ($lines = file($file)) { |
| | | $sql = ''; |
| | | foreach ($lines as $line) { |
| | | if (preg_match('/^--/', $line) || trim($line) == '') |
| | | continue; |
| | | |
| | | $sql .= $line . "\n"; |
| | | if (preg_match('/(;|^GO)$/', trim($line))) { |
| | | @$DB->query(fix_table_names($sql)); |
| | | $sql = ''; |
| | | if ($error = $DB->is_error()) { |
| | | return $error; |
| | | } |
| | | } |
| | | if ($sql = file_get_contents($file)) { |
| | | if (!$DB->exec_script($sql)) { |
| | | return $DB->is_error(); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | return $DB->is_error(); |
| | | } |
| | | |
| | | function fix_table_names($sql) |
| | | { |
| | | global $DB; |
| | | |
| | | foreach (array('users','identities','contacts','contactgroups','contactgroupmembers','session','cache','cache_index','cache_index','cache_messages','dictionary','searches','system') as $table) { |
| | | $real_table = $DB->table_name($table); |
| | | if ($real_table != $table) { |
| | | $sql = preg_replace("/([^a-z0-9_])$table([^a-z0-9_])/i", "\\1$real_table\\2", $sql); |
| | | } |
| | | } |
| | | |
| | | return $sql; |
| | | } |
| | | |
| | | ?> |