-
Notifications
You must be signed in to change notification settings - Fork 3
/
view_database_info.php
144 lines (101 loc) · 3.22 KB
/
view_database_info.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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
<?php
/*
* view_database_info.php
*
* View the database login info for userlevel >= 2 users.
*
*/
include_once 'checkinstance.php';
if ( ($_SESSION['userlevel'] < 2) )
{
header('Location: index.php');
exit();
}
include 'config.php';
include 'db.php';
$hostaddr = $dbhost;
if ( $hostaddr == 'localhost' ||
$hostaddr == '127.0.0.1' )
$hostaddr = gethostname();
if ( preg_match( "/novalocal/", $hostaddr ) )
{
$hostaddr = dirname( $org_site );
if ( preg_match( "/\/uslims3/", $hostaddr ) )
$hostaddr = dirname( $hostaddr );
}
// Start displaying page
$page_title = "Database Login Info";
$css = 'css/view_database_info.css';
include 'header.php';
?>
<!-- Begin page content -->
<div id='content'>
<h1 class="title">Database Login Info</h1>
<!-- Place page content here -->
<?php
$parts = explode( "_", $database_name );
$description = ucwords( $parts[ 1 ] . " Database" );
include "config.php";
if ( $_SESSION['authenticatePAM'] ) {
$userNamePAM = $_SESSION['userNamePAM'];
echo <<<HTML
<div id='main'>
<h3>Database Login Info</h3>
<p>In order to configure your UltraScan III application to work with this
database, please use the information printed below. This information
should be entered into the database configuration dialog in UltraScan III,
which can be opened by selecting:</p>
<p>“Edit:Preferences:Database Preferences:Change.”</p>
<p>Then click on “Reset” and enter the following information (use
copy/paste, but don’t add any leading or trailing blanks):</p>
<table cellpadding='4' cellspacing='0'>
<tr><th>Database Description:</th>
<td>You are free to put what you like here</td></tr>
<tr><th>User Name:</th>
<td>$userNamePAM</td></tr>
<tr><th>Password:</th>
<td>The password you logged in here with</td></tr>
<tr><th>Database Name:</th>
<td>$dbname</td></tr>
<tr><th>Host Address</th>
<td>$hostaddr</td></tr>
<tr><th>Investigator Email</th>
<td>{$_SESSION['email']}</td></tr>
<tr><th>Investigator Password</th>
<td>Not used for this database</td></tr>
</table>
</div>
</div>
HTML;
} else {
echo <<<HTML
<div id='main'>
<h3>Database Login Info</h3>
<p>In order to configure your UltraScan III application to work with this
database, please use the information printed below. This information
should be entered into the database configuration dialog in UltraScan III,
which can be opened by selecting:</p>
<p>“Edit:Preferences:Database Preferences:Change.”</p>
<p>Then click on “Reset” and enter the following information (use
copy/paste, but don’t add any leading or trailing blanks):</p>
<table cellpadding='4' cellspacing='0'>
<tr><th>Database Description:</th>
<td>You are free to put what you like here</td></tr>
<tr><th>User Name:</th>
<td>$secure_user</td></tr>
<tr><th>Password:</th>
<td>$secure_pw</td></tr>
<tr><th>Database Name:</th>
<td>$dbname</td></tr>
<tr><th>Host Address</th>
<td>$hostaddr</td></tr>
<tr><th>Investigator Email</th>
<td>{$_SESSION['email']}</td></tr>
<tr><th>Investigator Password</th>
<td>The password you logged in here with</td></tr>
</table>
</div>
</div>
HTML;
}
include 'footer.php';