<?php
if (!empty($_POST['form_submit'])) {
$form_old_version = $_POST['form_old_version'];
foreach ($versions as $version => $filename) {
if (strcmp($version, $form_old_version) < 0) {
continue;
}
upgradeFromSqlFile($filename);
}
if (!empty($GLOBALS['ippf_specific'])) {
// Upgrade custom stuff for IPPF.
upgradeFromSqlFile('ippf_upgrade.sql');
}
if (!empty($v_realpatch) && $v_realpatch != "" && $v_realpatch > 0) {
// This release contains a patch file, so process it.
upgradeFromSqlFile('patch.sql');
}
flush();
echo "<font color='green'>Updating global configuration defaults...</font><br />\n";
require_once "library/globals.inc.php";
foreach ($GLOBALS_METADATA as $grpname => $grparr) {
foreach ($grparr as $fldid => $fldarr) {
list($fldname, $fldtype, $flddef, $flddesc) = $fldarr;
if (substr($fldtype, 0, 2) !== 'm_') {
$row = sqlQuery("SELECT count(*) AS count FROM globals WHERE gl_name = '{$fldid}'");
if (empty($row['count'])) {
sqlStatement("INSERT INTO globals ( gl_name, gl_index, gl_value ) " . "VALUES ( '{$fldid}', '0', '{$flddef}' )");
}
}
}
}
<center>
<span class='title'>OpenEMR Database Upgrade</span>
<br>
</center>
<?php
if (!empty($_POST['form_submit'])) {
$form_old_version = $_POST['form_old_version'];
foreach ($versions as $version => $filename) {
if (strcmp($version, $form_old_version) < 0) {
continue;
}
upgradeFromSqlFile($filename);
}
if (!empty($GLOBALS['ippf_specific'])) {
// Upgrade custom stuff for IPPF.
upgradeFromSqlFile('ippf_upgrade.sql');
}
flush();
echo "<font color='green'>Updating global configuration defaults...</font><br />\n";
require_once "library/globals.inc.php";
foreach ($GLOBALS_METADATA as $grpname => $grparr) {
foreach ($grparr as $fldid => $fldarr) {
list($fldname, $fldtype, $flddef, $flddesc) = $fldarr;
if (substr($fldtype, 0, 2) !== 'm_') {
$row = sqlQuery("SELECT count(*) AS count FROM globals WHERE gl_name = '{$fldid}'");
if (empty($row['count'])) {
sqlStatement("INSERT INTO globals ( gl_name, gl_index, gl_value ) " . "VALUES ( '{$fldid}', '0', '{$flddef}' )");
}
}
}
}
xl('OpenEMR Database Upgrade', 'e');
?>
</title>
<link rel='STYLESHEET' href='../../interface/themes/style_sky_blue.css'>
</head>
<body> <br>
<center>
<span class='title'><?php
xl('OpenEMR Database Upgrade for De-identification', 'e');
?>
</span>
<br>
</center>
<?php
if (!empty($_POST['form_submit'])) {
upgradeFromSqlFile("database_de_identification.sql");
// grant file privilege to user
if ($sqlconf["host"] == "localhost") {
$dbh = mysql_connect($sqlconf['host'], $_POST['root_user_name'], $_POST['root_user_pass'], $sqlconf['host']) or die(mysql_error());
} else {
$dbh = mysql_connect($sqlconf['host'] . ":" . $sqlconf['port'], $_POST['root_user_name'], $_POST['root_user_pass']) or die(mysql_error());
}
if ($dbh == FALSE) {
echo "\n";
echo "<p>" . mysql_error() . " (#" . mysql_errno() . ")\n";
break;
}
$login = $sqlconf["login"];
$loginhost = $sqlconf["host"];
mysql_select_db($sqlconf['dbase']) or die(mysql_error());
if (mysql_query("GRANT FILE ON *.* TO '{$login}'@'{$loginhost}'", $dbh) == FALSE) {
