lang
[phpmyadmin/crack.git] / server_status.php3
blobd57d13fdbbb4b79e0a49bb12a602efa83eea1663
1 <?php
2 /* $Id$ */
3 // vim: expandtab sw=4 ts=4 sts=4:
6 /**
7 * Does the common work
8 */
9 require('./server_common.inc.php3');
12 /**
13 * Displays the links
15 require('./server_links.inc.php3');
18 /**
19 * InnoDB status
21 if (!empty($innodbstatus)) {
22 echo '<h2>' . "\n"
23 . ' ' . $strInnodbStat . "\n"
24 . '</h2>' . "\n";
25 $sql_query = 'SHOW INNODB STATUS;';
26 $res = PMA_mysql_query($sql_query, $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), $sql_query);
27 $row = PMA_mysql_fetch_row($res);
28 echo '<pre>' . "\n"
29 . htmlspecialchars($row[0]) . "\n"
30 . '</pre>' . "\n";
31 mysql_free_result($res);
32 include('./footer.inc.php3');
33 exit;
36 /**
37 * Displays the sub-page heading
39 echo '<h2>' . "\n"
40 . ' ' . $strServerStatus . "\n"
41 . '</h2>' . "\n";
44 /**
45 * Checks if the user is allowed to do what he tries to...
47 if (!$is_superuser && !$cfg['ShowMysqlInfo']) {
48 echo $strNoPrivileges;
49 include('./footer.inc.php3');
50 exit;
54 /**
55 * Sends the query and buffers the result
57 $res = @PMA_mysql_query('SHOW STATUS;', $userlink) or PMA_mysqlDie(PMA_mysql_error($userlink), 'SHOW STATUS;');
58 while ($row = PMA_mysql_fetch_row($res)) {
59 $serverStatus[$row[0]] = $row[1];
61 @mysql_free_result($res);
62 unset($res);
63 unset($row);
66 /**
67 * Displays the page
69 //Uptime calculation
70 $res = @PMA_mysql_query('SELECT UNIX_TIMESTAMP() - ' . $serverStatus['Uptime'] . ';');
71 $row = PMA_mysql_fetch_row($res);
72 echo sprintf($strServerStatusUptime, PMA_timespanFormat($serverStatus['Uptime']), PMA_localisedDate($row[0])) . "\n";
73 mysql_free_result($res);
74 unset($res);
75 unset($row);
76 //Get query statistics
77 $queryStats = array();
78 $tmp_array = $serverStatus;
79 while (list($name, $value) = each($tmp_array)) {
80 if (substr($name, 0, 4) == 'Com_') {
81 $queryStats[str_replace('_', ' ', substr($name, 4))] = $value;
82 unset($serverStatus[$name]);
85 unset($tmp_array);
87 <ul>
88 <li>
89 <!-- Server Traffic -->
90 <?php echo $strServerTrafficNotes; ?><br />
91 <table border="0">
92 <tr>
93 <td valign="top">
94 <table border="0">
95 <tr>
96 <th colspan="2">&nbsp;<?php echo $strTraffic; ?>&nbsp;</th>
97 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerHour; ?>&nbsp;</th>
98 </tr>
99 <tr>
100 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo $strReceived; ?>&nbsp;</td>
101 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown($serverStatus['Bytes_received'])); ?>&nbsp;</td>
102 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown($serverStatus['Bytes_received'] * 3600 / $serverStatus['Uptime'])); ?>&nbsp;</td>
103 </tr>
104 <tr>
105 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo $strSent; ?>&nbsp;</td>
106 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown($serverStatus['Bytes_sent'])); ?>&nbsp;</td>
107 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown($serverStatus['Bytes_sent'] * 3600 / $serverStatus['Uptime'])); ?>&nbsp;</td>
108 </tr>
109 <tr>
110 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">&nbsp;<?php echo $strTotalUC; ?>&nbsp;</td>
111 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown($serverStatus['Bytes_received'] + $serverStatus['Bytes_sent'])); ?>&nbsp;</td>
112 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo join(' ', PMA_formatByteDown(($serverStatus['Bytes_received'] + $serverStatus['Bytes_sent']) * 3600 / $serverStatus['Uptime'])); ?>&nbsp;</td>
113 </tr>
114 </table>
115 </td>
116 <td valign="top">
117 <table border="0">
118 <tr>
119 <th colspan="2">&nbsp;<?php echo $strConnections; ?>&nbsp;</th>
120 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerHour; ?>&nbsp;</th>
121 <th>&nbsp;%&nbsp;</th>
122 </tr>
123 <tr>
124 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo $strFailedAttempts; ?>&nbsp;</td>
125 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format($serverStatus['Aborted_connects'], 0, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
126 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Aborted_connects'] * 3600 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
127 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo ($serverStatus['Connections'] > 0 ) ? number_format(($serverStatus['Aborted_connects'] * 100 / $serverStatus['Connections']), 2, $number_decimal_separator, $number_thousands_separator) . '&nbsp;%' : '---'; ?>&nbsp;</td>
128 </tr>
129 <tr>
130 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo $strAbortedClients; ?>&nbsp;</td>
131 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format($serverStatus['Aborted_clients'], 0, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
132 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Aborted_clients'] * 3600 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
133 <td bgcolor="<?php echo $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo ($serverStatus['Connections'] > 0 ) ? number_format(($serverStatus['Aborted_clients'] * 100 / $serverStatus['Connections']), 2 , $number_decimal_separator, $number_thousands_separator) . '&nbsp;%' : '---'; ?>&nbsp;</td>
134 </tr>
135 <tr>
136 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">&nbsp;<?php echo $strTotalUC; ?>&nbsp;</td>
137 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format($serverStatus['Connections'], 0, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
138 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Connections'] * 3600 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
139 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;100,00&nbsp;%&nbsp;</td>
140 </tr>
141 </table>
142 </td>
143 </tr>
144 </table>
145 </li>
146 <br />
147 <li>
148 <!-- Queries -->
149 <?php echo sprintf($strQueryStatistics, number_format($serverStatus['Questions'], 0, $number_decimal_separator, $number_thousands_separator)); ?><br />
150 <table border="0">
151 <tr>
152 <td valign="top">
153 <table border="0">
154 <tr>
155 <th colspan="2">&nbsp;<?php echo $strQueryType; ?>&nbsp;</th>
156 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerHour; ?>&nbsp;</th>
157 <th>&nbsp;%&nbsp;</th>
158 </tr>
159 <?php
161 $useBgcolorOne = TRUE;
162 $countRows = 0;
163 while (list($name, $value) = each($queryStats)) {
165 <tr>
166 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo htmlspecialchars($name); ?>&nbsp;</td>
167 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format($value, 0, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
168 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format(($value * 3600 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
169 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>" align="right">&nbsp;<?php echo number_format(($value * 100 / $serverStatus['Questions']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;%&nbsp;</td>
170 </tr>
171 <?php
172 $useBgcolorOne = !$useBgcolorOne;
173 if (++$countRows == ceil(count($queryStats) / 2)) {
174 $useBgcolorOne = TRUE;
176 </table>
177 </td>
178 <td valign="top">
179 <table border="0">
180 <tr>
181 <th colspan="2">&nbsp;<?php echo $strQueryType; ?>&nbsp;</th>
182 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerHour; ?>&nbsp;</th>
183 <th>&nbsp;%&nbsp;</th>
184 </tr>
185 <?php
188 unset($countRows);
189 unset($useBgcolorOne);
191 </table>
192 </td>
193 </tr>
194 <tr>
195 <td colspan="2">
196 <br />
197 <table border="0" align="right">
198 <tr>
199 <th>&nbsp;<?php echo $strTotalUC; ?>&nbsp;</th>
200 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerHour; ?>&nbsp;</th>
201 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerMinute; ?>&nbsp;</th>
202 <th>&nbsp;&oslash;&nbsp;<?php echo $strPerSecond; ?>&nbsp;</th>
203 </tr>
205 <tr>
206 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format($serverStatus['Questions'], 0, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
207 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Questions'] * 3600 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
208 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Questions'] * 60 / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
209 <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>" align="right">&nbsp;<?php echo number_format(($serverStatus['Questions'] / $serverStatus['Uptime']), 2, $number_decimal_separator, $number_thousands_separator); ?>&nbsp;</td>
210 </tr>
212 </table>
213 </td>
214 </table>
215 </li>
216 <?php
217 //Unset used variables
218 unset($serverStatus['Aborted_clients']);
219 unset($serverStatus['Aborted_connects']);
220 unset($serverStatus['Bytes_received']);
221 unset($serverStatus['Bytes_sent']);
222 unset($serverStatus['Connections']);
223 unset($serverStatus['Questions']);
224 unset($serverStatus['Uptime']);
226 if (!empty($serverStatus)) {
228 <br />
229 <li>
230 <!-- Other status variables -->
231 <b><?php echo $strMoreStatusVars; ?></b><br />
232 <table border="0">
233 <tr>
234 <td valign="top">
235 <table border="0">
236 <tr>
237 <th>&nbsp;<?php echo $strVar; ?>&nbsp;</th>
238 <th>&nbsp;<?php echo $strValue; ?>&nbsp;</th>
239 </tr>
240 <?php
241 $useBgcolorOne = TRUE;
242 $countRows = 0;
243 while (list($name, $value) = each($serverStatus)) {
245 <tr>
246 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo htmlspecialchars(str_replace('_', ' ', $name)); ?>&nbsp;</td>
247 <td bgcolor="<?php echo $useBgcolorOne ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; ?>">&nbsp;<?php echo htmlspecialchars($value); ?>&nbsp;</td>
248 </tr>
249 <?php
250 $useBgcolorOne = !$useBgcolorOne;
251 if (++$countRows == ceil(count($serverStatus) / 3) || $countRows == ceil(count($serverStatus) * 2 / 3)) {
252 $useBgcolorOne = TRUE;
254 </table>
255 </td>
256 <td valign="top">
257 <table border="0">
258 <tr>
259 <th>&nbsp;<?php echo $strVar; ?>&nbsp;</th>
260 <th>&nbsp;<?php echo $strValue; ?>&nbsp;</th>
261 </tr>
262 <?php
265 unset($useBgcolorOne);
267 </table>
268 </td>
269 </tr>
270 </table>
271 </li>
272 <?php
274 $res = PMA_mysql_query('SHOW VARIABLES LIKE "have_innodb";', $userlink);
275 if ($res) {
276 $row = PMA_mysql_fetch_row($res);
277 if (!empty($row[1]) && $row[1] == 'YES') {
279 <br />
280 <li>
281 <!-- InnoDB Status -->
282 <a href="./server_status.php3?<?php echo $url_query; ?>&amp;innodbstatus=1">
283 <b><?php echo $strInnodbStat; ?></b>
284 </a>
285 </li>
286 <?php
288 } else {
289 unset($res);
292 </ul>
295 <?php
299 * Sends the footer
301 require('./footer.inc.php3');