$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); }