forked from openemr/openemr
-
Notifications
You must be signed in to change notification settings - Fork 1
/
admin.php
126 lines (112 loc) · 3.62 KB
/
admin.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php
// Copyright (C) 2010 Rod Roark <[email protected]>
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
require_once "version.php";
$webserver_root = dirname(__FILE__);
if (stripos(PHP_OS,'WIN') === 0)
$webserver_root = str_replace("\\","/",$webserver_root);
$OE_SITES_BASE = "$webserver_root/sites";
function sqlQuery($statement) {
$row = @mysql_fetch_array(mysql_query($statement), MYSQL_ASSOC);
return $row;
}
?>
<html>
<head>
<title>OpenEMR Site Administration</title>
<link rel='STYLESHEET' href='interface/themes/style_sky_blue.css'>
<style>
tr.head { font-size:10pt; background-color:#cccccc; text-align:center; font-weight:bold; }
tr.detail { font-size:10pt; }
a, a:visited, a:hover { color:#0000cc; text-decoration:none; }
</style>
</head>
<body>
<center>
<p><span class='title'>OpenEMR Site Administration</span></p>
<table width='100%' cellpadding='1' cellspacing='2'>
<tr class='head'>
<td>Site ID</td>
<td>DB Name</td>
<td>Site Name</td>
<td>Version</td>
<td>Action</td>
</tr>
<?php
$dh = opendir($OE_SITES_BASE);
if (!$dh) die("Cannot read directory '$OE_SITES_BASE'.");
$siteslist = array();
while (false !== ($sfname = readdir($dh))) {
if (substr($sfname, 0, 1) == '.') continue;
if ($sfname == 'CVS' ) continue;
$sitedir = "$OE_SITES_BASE/$sfname";
if (!is_dir($sitedir) ) continue;
if (!is_file("$sitedir/sqlconf.php")) continue;
$siteslist[$sfname] = $sfname;
}
closedir($dh);
ksort($siteslist);
foreach ($siteslist as $sfname) {
$sitedir = "$OE_SITES_BASE/$sfname";
$errmsg = '';
++$encount;
$bgcolor = "#" . (($encount & 1) ? "ddddff" : "ffdddd");
echo " <tr class='detail' bgcolor='$bgcolor'>\n";
// Access the site's database.
include "$sitedir/sqlconf.php";
if ($config) {
$dbh = mysql_connect("$host:$port", "$login", "$pass");
if ($dbh === FALSE)
$errmsg = "MySQL connect failed";
else if (!mysql_select_db($dbase, $dbh))
$errmsg = "Access to database failed";
}
echo " <td>$sfname</td>\n";
echo " <td>$dbase</td>\n";
if (!$config) {
echo " <td colspan='3'><a href='setup.php?site=$sfname'>Needs setup, click here to run it</a></td>\n";
}
else if ($errmsg) {
echo " <td colspan='3' style='color:red'>$errmsg</td>\n";
}
else {
// Get site name for display.
$row = sqlQuery("SELECT gl_value FROM globals WHERE gl_name = 'openemr_name' LIMIT 1");
$openemr_name = $row ? $row['gl_value'] : '';
// Get version indicators from the database.
$row = sqlQuery("SHOW TABLES LIKE 'version'");
if (empty($row)) {
$openemr_version = 'Unknown';
$database_version = 0;
}
else {
$row = sqlQuery("SELECT * FROM version LIMIT 1");
$openemr_version = $row['v_major'] . "." . $row['v_minor'] . "." .
$row['v_patch'] . $row['v_tag'];
$database_version = 0 + $row['v_database'];
}
// Display relevant columns.
echo " <td>$openemr_name</td>\n";
echo " <td>$openemr_version</td>\n";
if ($v_database == $database_version) {
echo " <td><a href='interface/login/login_frame.php?site=$sfname'>Log In</a></td>\n";
}
else {
echo " <td><a href='sql_upgrade.php?site=$sfname'>Upgrade Database</a></td>\n";
}
}
echo " </tr>\n";
if ($config && $dbh !== FALSE) mysql_close($dbh);
}
?>
</table>
<form method='post' action='setup.php'>
<p><input type='submit' name='form_submit' value='Add New Site' /></p>
</form>
</center>
</body>
</html>