/phpmyadmin/server_binlog.php
PHP | 218 lines | 157 code | 19 blank | 42 comment | 30 complexity | 8d436b149581d16c7a57a7f52a76646a MD5 | raw file
Possible License(s): Apache-2.0, MPL-2.0-no-copyleft-exception, LGPL-2.1, BSD-2-Clause, GPL-2.0, LGPL-3.0
- <?php
- /* vim: set expandtab sw=4 ts=4 sts=4: */
- /**
- * display the binary logs and the content of the selected
- *
- * @package PhpMyAdmin
- */
- /**
- *
- */
- require_once './libraries/common.inc.php';
- /**
- * Does the common work, provides $binary_logs
- */
- require_once './libraries/server_common.inc.php';
- /**
- * Displays the links
- */
- require_once './libraries/server_links.inc.php';
- $url_params = array();
- /**
- * Need to find the real end of rows?
- */
- if (! isset($_REQUEST['pos'])) {
- $pos = 0;
- } else {
- /* We need this to be a integer */
- $pos = (int) $_REQUEST['pos'];
- }
- if (! isset($_REQUEST['log']) || ! array_key_exists($_REQUEST['log'], $binary_logs)) {
- $_REQUEST['log'] = '';
- } else {
- $url_params['log'] = $_REQUEST['log'];
- }
- $sql_query = 'SHOW BINLOG EVENTS';
- if (! empty($_REQUEST['log'])) {
- $sql_query .= ' IN \'' . $_REQUEST['log'] . '\'';
- }
- if ($GLOBALS['cfg']['MaxRows'] !== 'all') {
- $sql_query .= ' LIMIT ' . $pos . ', ' . (int) $GLOBALS['cfg']['MaxRows'];
- }
- /**
- * Sends the query
- */
- $result = PMA_DBI_query($sql_query);
- /**
- * prepare some vars for displaying the result table
- */
- // Gets the list of fields properties
- if (isset($result) && $result) {
- $num_rows = PMA_DBI_num_rows($result);
- } else {
- $num_rows = 0;
- }
- if (empty($_REQUEST['dontlimitchars'])) {
- $dontlimitchars = false;
- } else {
- $dontlimitchars = true;
- $url_params['dontlimitchars'] = 1;
- }
- /**
- * Displays the sub-page heading
- */
- echo '<h2>' . "\n"
- . ($GLOBALS['cfg']['MainPageIconic'] ? PMA_getImage('s_tbl.png') : '')
- . ' ' . __('Binary log') . "\n"
- . '</h2>' . "\n";
- /**
- * Display log selector.
- */
- if (count($binary_logs) > 1) {
- echo '<form action="server_binlog.php" method="get">';
- echo PMA_generate_common_hidden_inputs($url_params);
- echo '<fieldset><legend>';
- echo __('Select binary log to view');
- echo '</legend><select name="log">';
- $full_size = 0;
- foreach ($binary_logs as $each_log) {
- echo '<option value="' . $each_log['Log_name'] . '"';
- if ($each_log['Log_name'] == $_REQUEST['log']) {
- echo ' selected="selected"';
- }
- echo '>' . $each_log['Log_name'];
- if (isset($each_log['File_size'])) {
- $full_size += $each_log['File_size'];
- echo ' (' . implode(' ', PMA_formatByteDown($each_log['File_size'], 3, 2)) . ')';
- }
- echo '</option>';
- }
- echo '</select> ';
- echo count($binary_logs) . ' ' . __('Files') . ', ';
- if ($full_size > 0) {
- echo implode(' ', PMA_formatByteDown($full_size));
- }
- echo '</fieldset>';
- echo '<fieldset class="tblFooters">';
- echo '<input type="submit" value="' . __('Go') . '" />';
- echo '</fieldset>';
- echo '</form>';
- }
- PMA_showMessage(PMA_Message::success());
- /**
- * Displays the page
- */
- ?>
- <table border="0" cellpadding="2" cellspacing="1">
- <thead>
- <tr>
- <td colspan="6" align="center">
- <?php
- // we do not now how much rows are in the binlog
- // so we can just force 'NEXT' button
- if ($pos > 0) {
- $this_url_params = $url_params;
- if ($pos > $GLOBALS['cfg']['MaxRows']) {
- $this_url_params['pos'] = $pos - $GLOBALS['cfg']['MaxRows'];
- }
- echo '<a href="./server_binlog.php' . PMA_generate_common_url($this_url_params) . '"';
- if ($GLOBALS['cfg']['NavigationBarIconic']) {
- echo ' title="' . _pgettext('Previous page', 'Previous') . '">';
- } else {
- echo '>' . _pgettext('Previous page', 'Previous');
- } // end if... else...
- echo ' < </a> - ';
- }
- $this_url_params = $url_params;
- if ($pos > 0) {
- $this_url_params['pos'] = $pos;
- }
- if ($dontlimitchars) {
- unset($this_url_params['dontlimitchars']);
- ?>
- <a href="./server_binlog.php<?php echo PMA_generate_common_url($this_url_params); ?>"
- title="<?php __('Truncate Shown Queries'); ?>">
- <img src="<?php echo $pmaThemeImage; ?>s_partialtext.png"
- alt="<?php echo __('Truncate Shown Queries'); ?>" /></a>
- <?php
- } else {
- $this_url_params['dontlimitchars'] = 1;
- ?>
- <a href="./server_binlog.php<?php echo PMA_generate_common_url($this_url_params); ?>"
- title="<?php __('Show Full Queries'); ?>">
- <img src="<?php echo $pmaThemeImage; ?>s_fulltext.png"
- alt="<?php echo __('Show Full Queries'); ?>" /></a>
- <?php
- }
- // we do not now how much rows are in the binlog
- // so we can just force 'NEXT' button
- if ($num_rows >= $GLOBALS['cfg']['MaxRows']) {
- $this_url_params = $url_params;
- $this_url_params['pos'] = $pos + $GLOBALS['cfg']['MaxRows'];
- echo ' - <a href="./server_binlog.php' . PMA_generate_common_url($this_url_params) . '"';
- if ($GLOBALS['cfg']['NavigationBarIconic']) {
- echo ' title="' . _pgettext('Next page', 'Next') . '">';
- } else {
- echo '>' . _pgettext('Next page', 'Next');
- } // end if... else...
- echo ' > </a>';
- }
- ?>
- </td>
- </tr>
- <tr>
- <th><?php echo __('Log name'); ?></th>
- <th><?php echo __('Position'); ?></th>
- <th><?php echo __('Event type'); ?></th>
- <th><?php echo __('Server ID'); ?></th>
- <th><?php echo __('Original position'); ?></th>
- <th><?php echo __('Information'); ?></th>
- </tr>
- </thead>
- <tbody>
- <?php
- $odd_row = true;
- while ($value = PMA_DBI_fetch_assoc($result)) {
- if (! $dontlimitchars && PMA_strlen($value['Info']) > $GLOBALS['cfg']['LimitChars']) {
- $value['Info'] = PMA_substr($value['Info'], 0, $GLOBALS['cfg']['LimitChars']) . '...';
- }
- ?>
- <tr class="noclick <?php echo $odd_row ? 'odd' : 'even'; ?>">
- <td> <?php echo $value['Log_name']; ?> </td>
- <td align="right"> <?php echo $value['Pos']; ?> </td>
- <td> <?php echo $value['Event_type']; ?> </td>
- <td align="right"> <?php echo $value['Server_id']; ?> </td>
- <td align="right"> <?php echo isset($value['Orig_log_pos']) ? $value['Orig_log_pos'] : $value['End_log_pos']; ?> </td>
- <td> <?php echo htmlspecialchars($value['Info']); ?> </td>
- </tr>
- <?php
- $odd_row = !$odd_row;
- }
- ?>
- </tbody>
- </table>
- <?php
- /**
- * Sends the footer
- */
- require './libraries/footer.inc.php';
- ?>