server_processlist.php

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