server_processlist.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 require_once('./libraries/common.lib.php');
   6
   7 /**
   8  * Does the common work
   9  */
  10 require_once('./libraries/server_common.inc.php');
  11
  12
  13 /**
  14  * Kills a selected process
  15  */
  16 if (!empty($kill)) {
  17     if (PMA_DBI_try_query('KILL ' . $kill . ';')) {
  18         $message = sprintf($strThreadSuccessfullyKilled, $kill);
  19     } else {
  20         $message = sprintf($strCouldNotKill, $kill);
  21     }
  22 }
  23
  24
  25 /**
  26  * Displays the links
  27  */
  28 require('./libraries/server_links.inc.php');
  29
  30
  31 /**
  32  * Displays the sub-page heading
  33  */
  34 echo '<h2>' . "\n"
  35    . ($cfg['MainPageIconic'] ? '<img class="icon" src="' . $pmaThemeImage . 's_process.png" width="16" height="16" alt="" />' : '' )
  36    . $strProcesslist . "\n"
  37    . '</h2>' . "\n";
  38
  39
  40 /**
  41  * Sends the query
  42  */
  43 $sql_query = 'SHOW' . ( empty( $full ) ? '' : ' FULL' ) . ' PROCESSLIST';
  44 $result = PMA_DBI_query($sql_query);
  45
  46 PMA_showMessage( $GLOBALS['strSuccess'] );
  47
  48
  49 /**
  50  * Displays the page
  51  */
  52 ?>
  53 <table id="tableprocesslist" class="data">
  54 <thead>
  55 <tr><td><a href="./server_processlist.php?<?php echo $url_query . (empty($full) ? '&amp;full=1' : ''); ?>"
  56             title="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>">
  57         <img src="<?php echo $pmaThemeImage . 's_' . (empty($full) ? 'full' : 'partial'); ?>text.png"
  58             width="50" height="20" alt="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>" />
  59         </a></td>
  60     <th><?php echo $strId; ?></th>
  61     <th><?php echo $strUser; ?></th>
  62     <th><?php echo $strHost; ?></th>
  63     <th><?php echo $strDatabase; ?></th>
  64     <th><?php echo $strCommand; ?></th>
  65     <th><?php echo $strTime; ?></th>
  66     <th><?php echo $strStatus; ?></th>
  67     <th><?php echo $strSQLQuery; ?></th>
  68 </tr>
  69 </thead>
  70 <tbody>
  71 <?php
  72 $odd_row = true;
  73 while($process = PMA_DBI_fetch_assoc($result)) {
  74     ?>
  75 <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>">
  76     <td><a href="./server_processlist.php?<?php echo $url_query . '&amp;kill=' . $process['Id']; ?>"><?php echo $strKill; ?></a></td>
  77     <td class="value"><?php echo $process['Id']; ?></td>
  78     <td><?php echo $process['User']; ?></td>
  79     <td><?php echo $process['Host']; ?></td>
  80     <td><?php echo (( ! isset( $process['db'] ) || ! strlen($process['db']) ) ? '<i>' . $strNone . '</i>' : $process['db']); ?></td>
  81     <td><?php echo $process['Command']; ?></td>
  82     <td class="value"><?php echo $process['Time']; ?></td>
  83     <td><?php echo (empty($process['State']) ? '---' : $process['State']); ?></td>
  84     <td><?php echo (empty($process['Info']) ? '---' : PMA_SQP_formatHtml(PMA_SQP_parse($process['Info']))); ?></td>
  85 </tr>
  86     <?php
  87     $odd_row = ! $odd_row;
  88 }
  89 ?>
  90 </tbody>
  91 </table>
  92 <?php
  93
  94 /**
  95  * Sends the footer
  96  */
  97 require_once('./libraries/footer.inc.php');
  98 ?>