\n"; // Access the site's database. include "$sitedir/sqlconf.php"; if ($config) { $dbh = mysqli_connect("$host", "$login", "$pass", $dbase, $port); if (!$dbh) { $errmsg = "MySQL connect failed"; } } echo " \n"; echo " \n"; if (!$config) { echo " \n"; } elseif ($errmsg) { echo " \n"; } else { // Get site name for display. $row = sqlQuery("SELECT gl_value FROM globals WHERE gl_name = 'openemr_name' LIMIT 1", $dbh); $openemr_name = $row ? $row['gl_value'] : ''; // Get version indicators from the database. $row = sqlQuery("SHOW TABLES LIKE 'version'", $dbh); if (empty($row)) { $openemr_version = 'Unknown'; $database_version = 0; } else { $row = sqlQuery("SELECT * FROM version LIMIT 1", $dbh); $database_patch_txt = ""; if (!(empty($row['v_realpatch'])) && $row['v_realpatch'] != 0) { $database_patch_txt = " (" . $row['v_realpatch'] . ")"; } $openemr_version = $row['v_major'] . "." . $row['v_minor'] . "." . $row['v_patch'] . $row['v_tag'] . $database_patch_txt; $database_version = 0 + $row['v_database']; $database_acl = 0 + $row['v_acl']; $database_patch = 0 + $row['v_realpatch']; } // Display relevant columns. echo " \n"; echo " \n"; if ($v_database != $database_version) { echo " \n"; } elseif (($v_acl > $database_acl)) { echo " \n"; } elseif (($v_realpatch != $database_patch)) { echo " \n"; } else { echo " \n"; } if (($v_database == $database_version) && ($v_acl <= $database_acl) && ($v_realpatch == $database_patch)) { echo " \n"; echo " \n"; } else { echo " \n"; echo " \n"; } } echo " \n"; if ($config && $dbh !== false) { mysqli_close($dbh); } } ?>

Site ID	DB Name	Site Name	Version	Is Current	Log In	Patient Portal
" . htmlspecialchars($sfname, ENT_NOQUOTES) . "	" . htmlspecialchars($dbase, ENT_NOQUOTES) . "	Needs setup, click here to run it			" . htmlspecialchars($errmsg, ENT_NOQUOTES) . "			" . htmlspecialchars($openemr_name, ENT_NOQUOTES) . "	" . htmlspecialchars($openemr_version, ENT_NOQUOTES) . "	Upgrade Database	Upgrade Access Controls	Patch Database