[Sommaire] [Imprimer]

   1  <?php
   2  /* $Id: server_binlog.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   * Displays the links
  15   */
  16  require  './libraries/server_links.inc.php';
  17  
  18  
  19  /**
  20   * Displays the sub-page heading
  21   */
  22  echo '<h2>' . "\n"
  23     . ($cfg['MainPageIconic'] ? '<img src="' . $pmaThemeImage . 's_process.png" width="16" height="16" border="0" hspace="2" align="middle" alt="" />' : '' )
  24     . '    ' . $strBinaryLog . "\n"
  25     . '</h2>' . "\n";
  26  
  27  if (!isset($log)) {
  28      $log = '';
  29  }
  30  
  31  /**
  32   * Display log selector.
  33   */
  34  if (count($binary_logs) > 1) {
  35      echo '<form action="server_binlog.php" method="get">';
  36      echo PMA_generate_common_hidden_inputs();
  37      echo '<fieldset><legend>';
  38      echo $strSelectBinaryLog;
  39      echo '</legend><select name="log">';
  40      foreach ($binary_logs as $name) {
  41          echo '<option value="' . $name . '"' . ($name == $log ? ' selected="selected"' : '') . '>' . $name . '</option>';
  42      }
  43      echo '</select>';
  44      echo '</fieldset>';
  45      echo '<fieldset class="tblFooters">';
  46      echo '<input type="submit" value="' . $strGo . '" />';
  47      echo '</fieldset>';
  48      echo '</form>';
  49  }
  50  
  51  
  52  $sql_query = 'SHOW BINLOG EVENTS';
  53  if (!empty($log)) {
  54      $sql_query .= ' IN \'' . $log . '\'';
  55  }
  56  
  57  /**
  58   * Sends the query
  59   */
  60  $result = PMA_DBI_query($sql_query);
  61  
  62  PMA_showMessage($GLOBALS['strSuccess']);
  63  
  64  
  65  /**
  66   * Displays the page
  67   */
  68  ?>
  69  <table border="0" cellpadding="2" cellspacing="1">
  70  <tr>
  71      <td colspan="6" align="center">
  72          <a href="./server_binlog.php?<?php echo $url_query . (!empty($log) ? '&amp;log=' . htmlspecialchars($log) : '' ) . (empty($full) ? '&amp;full=1' : ''); ?>"
  73              title="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>">
  74                  <img src="<?php echo $pmaThemeImage . 's_' . (empty($full) ? 'full' : 'partial'); ?>text.png"
  75                      width="50" height="20" border="0"
  76                      alt="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>" /></a></td>
  77  </tr>
  78  <tr>
  79      <th><?php echo $strBinLogName; ?></th>
  80      <th><?php echo $strBinLogPosition; ?></th>
  81      <th><?php echo $strBinLogEventType; ?></th>
  82      <th><?php echo $strBinLogServerId; ?></th>
  83      <th><?php echo $strBinLogOriginalPosition; ?></th>
  84      <th><?php echo $strBinLogInfo; ?></th>
  85  </tr>
  86  <?php
  87  $odd_row = true;
  88  while($value = PMA_DBI_fetch_assoc($result)) {
  89      if (empty($full) && PMA_strlen($value['Info']) > $GLOBALS['cfg']['LimitChars']) {
  90          $value['Info'] = PMA_substr($value['Info'], 0, $GLOBALS['cfg']['LimitChars']) . '...';
  91      }
  92      ?>
  93  <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>">
  94      <td>&nbsp;<?php echo $value['Log_name']; ?>&nbsp;</td>
  95      <td align="right">&nbsp;<?php echo $value['Pos']; ?>&nbsp;</td>
  96      <td>&nbsp;<?php echo $value['Event_type']; ?>&nbsp;</td>
  97      <td align="right">&nbsp;<?php echo $value['Server_id']; ?>&nbsp;</td>
  98      <td align="right">&nbsp;<?php echo isset($value['Orig_log_pos']) ? $value['Orig_log_pos'] : $value['End_log_pos']; ?>&nbsp;</td>
  99      <td>&nbsp;<?php echo htmlspecialchars($value['Info']); ?>&nbsp;</td>
 100  </tr>
 101      <?php
 102      $odd_row = !$odd_row;
 103  }
 104  ?>
 105  </table>
 106  <?php
 107  
 108  
 109  /**
 110   * Sends the footer
 111   */
 112  require_once  './libraries/footer.inc.php';
 113  
 114  ?>