[Sommaire] [Imprimer]

   1  <?php
   2  /* $Id: server_processlist.php 9085 2006-05-30 09:26:52Z nijel $ */
   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  ?>