| 0,0 → 1,98 |
|---|
| <?php |
| /* $Id: server_processlist.php,v 2.16 2006/01/14 23:17:15 cybot_tm Exp $ */ |
| // vim: expandtab sw=4 ts=4 sts=4: |
| |
| require_once('./libraries/common.lib.php'); |
| |
| /** |
| * Does the common work |
| */ |
| require_once('./libraries/server_common.inc.php'); |
| |
| |
| /** |
| * Kills a selected process |
| */ |
| if (!empty($kill)) { |
| if (PMA_DBI_try_query('KILL ' . $kill . ';')) { |
| $message = sprintf($strThreadSuccessfullyKilled, $kill); |
| } else { |
| $message = sprintf($strCouldNotKill, $kill); |
| } |
| } |
| |
| |
| /** |
| * Displays the links |
| */ |
| require('./libraries/server_links.inc.php'); |
| |
| |
| /** |
| * Displays the sub-page heading |
| */ |
| echo '<h2>' . "\n" |
| . ($cfg['MainPageIconic'] ? '<img class="icon" src="' . $pmaThemeImage . 's_process.png" width="16" height="16" alt="" />' : '' ) |
| . $strProcesslist . "\n" |
| . '</h2>' . "\n"; |
| |
| |
| /** |
| * Sends the query and buffers the result |
| */ |
| $sql_query = 'SHOW' . ( empty( $full ) ? '' : ' FULL' ) . ' PROCESSLIST'; |
| $serverProcesses = PMA_DBI_fetch_result( $sql_query ); |
| |
| PMA_showMessage( $GLOBALS['strSuccess'] ); |
| |
| |
| /** |
| * Displays the page |
| */ |
| ?> |
| <table id="tableprocesslist" class="data"> |
| <thead> |
| <tr><td><a href="./server_processlist.php?<?php echo $url_query . (empty($full) ? '&full=1' : ''); ?>" |
| title="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>"> |
| <img src="<?php echo $pmaThemeImage . 's_' . (empty($full) ? 'full' : 'partial'); ?>text.png" |
| width="50" height="20" alt="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>" /> |
| </a></td> |
| <th><?php echo $strId; ?></th> |
| <th><?php echo $strUser; ?></th> |
| <th><?php echo $strHost; ?></th> |
| <th><?php echo $strDatabase; ?></th> |
| <th><?php echo $strCommand; ?></th> |
| <th><?php echo $strTime; ?></th> |
| <th><?php echo $strStatus; ?></th> |
| <th><?php echo $strSQLQuery; ?></th> |
| </tr> |
| </thead> |
| <tbody> |
| <?php |
| $odd_row = true; |
| foreach ( $serverProcesses AS $process ) { |
| ?> |
| <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>"> |
| <td><a href="./server_processlist.php?<?php echo $url_query . '&kill=' . $process['Id']; ?>"><?php echo $strKill; ?></a></td> |
| <td class="value"><?php echo $process['Id']; ?></td> |
| <td><?php echo $process['User']; ?></td> |
| <td><?php echo $process['Host']; ?></td> |
| <td><?php echo (( ! isset( $process['db'] ) || ! strlen($process['db']) ) ? '<i>' . $strNone . '</i>' : $process['db']); ?></td> |
| <td><?php echo $process['Command']; ?></td> |
| <td class="value"><?php echo $process['Time']; ?></td> |
| <td><?php echo (empty($process['State']) ? '---' : $process['State']); ?></td> |
| <td><?php echo (empty($process['Info']) ? '---' : PMA_SQP_formatHtml(PMA_SQP_parse($process['Info']))); ?></td> |
| </tr> |
| <?php |
| $odd_row = ! $odd_row; |
| } |
| ?> |
| </tbody> |
| </table> |
| <?php |
| |
| /** |
| * Sends the footer |
| */ |
| require_once('./libraries/footer.inc.php'); |
| ?> |