<?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) {