/**
* Returns the current sql version of the database.
*
* @return string
*/
public function getSQLVersion() {
if ($this->sqlVersion === null) {
try {
$this->sqlVersion = $this->db->getVersion();
}
catch (DatabaseException $e) {
$this->sqlVersion = 'unknown';
}
}
return $this->sqlVersion;
}
/**
* Checks if in the chosen database are tables in conflict with the wcf tables
* which will be created in the next step.
*
* @param wcf\system\database\Database $db
* @param integer $dbNumber
*/
protected function getConflictedTables($db, $dbNumber) {
// get content of the sql structure file
$sql = file_get_contents(TMP_DIR.'setup/db/install.sql');
// installation number value 'n' (WCF_N) must be reflected in the executed sql queries
$sql = StringUtil::replace('wcf1_', 'wcf'.$dbNumber.'_', $sql);
// get all tablenames which should be created
preg_match_all("%CREATE\s+TABLE\s+(\w+)%", $sql, $matches);
// get all installed tables from chosen database
$existingTables = $db->getEditor()->getTableNames();
// check if existing tables are in conflict with wcf tables
$conflictedTables = array();
foreach ($existingTables as $existingTableName) {
foreach ($matches[1] as $wcfTableName) {
if ($existingTableName == $wcfTableName) {
$conflictedTables[] = $wcfTableName;
}
}
}
return $conflictedTables;
}
