$fp = fopen($conx->getProjectDirectory() . "backupsync.struct.sql", "r");
$datastructure = fread($fp, filesize($conx->getProjectDirectory() . "backupsync.struct.sql"));
fclose($fp);
$queries = getSQLStatements($datastructure);
$conx->setBackupSync(false);
$runquery = new sqlQuery($conx);
foreach ($queries as $query) {
$query = trim($query);
if (strlen($query) > 3) {
$runquery->query($query);
}
}
$fp = fopen($conx->getProjectDirectory() . "backupsync.struct.sql", "w");
fclose($fp);
$error = false;
if (strlen($runquery->getError()) > 5) {
$this->setError("SQL query Error during structure importation : " . $runquery->getError());
$error = true;
}
if ($error) {
$message = "Error, Datastructure import one or more query didn't go true during the structure importation";
$this->setError($message);
} else {
$message = "Importation done";
}
} else {
$message = "Error, Event Controler, Data Structure : mydb_key doesn't match";
$this->setError($message);
}
$disp = new Display($this->getMessagePage());
$disp->addParam("message", $message);
/**
* Try to create a new database
*
* @param string name new database name
* @return true if succed false if not
* @access public
*/
function createDatabase($name)
{
//$b_success = mysql_create_db($name);
$q = new sqlQuery($this->getDbCon());
if ($q->query("CREATE DATABASE " . $name)) {
if (strlen($q->getError()) < 5) {
return true;
} else {
return false;
}
} else {
return false;
}
#return $b_success;
}
$valuelist .= "{$val}, ";
}
}
$fieldlist = ereg_replace(', $', '', $fieldlist);
$valuelist = ereg_replace(', $', '', $valuelist);
$query = "INSERT INTO `{$table}` ({$fieldlist}) VALUES ({$valuelist})";
}
$this->setLog("\n Running query:\n" . $query);
$message = urlencode($strInsertOk);
$sql_query = $query;
$qSaveData = new sqlQuery($this->dbc);
$result = $qSaveData->query($query);
$uniqid = $qSaveData->getInsertId($table, "id" . $table);
$this->addParam("insertid", $uniqid);
if (!$result) {
$error = $qSaveData->getError();
$this->addParam("recordinserted", "no");
$disp->setPage($urlerror);
$disp->addParam("message", $strInsertError . $error);
} else {
$disp->setPage($goto);
if (strlen($setmessage) > 0) {
$strInsertOk = $setmessage;
}
$this->addParam("recordinserted", "yes");
$disp->addParam("message", $strInsertOk);
$disp->addParam("insertid", $uniqid);
$disp->addParam("updage", "no");
}
$this->setDisplayNext($disp);
}
