libraries/server_bin_log.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3
   4 /**
   5  * functions for displaying server binary log
   6  *
   7  * @usedby  server_binlog.php
   8  *
   9  * @package PhpMyAdmin
  10  */
  11 if (! defined('PHPMYADMIN')) {
  12     exit;
  13 }
  14
  15 /**
  16  * Returns the html for log selector.
  17  *
  18  * @param Array $binary_log_file_names Binary logs file names
  19  * @param Array $url_params            links parameters
  20  *
  21  * @return string
  22  */
  23 function PMA_getLogSelector($binary_log_file_names, $url_params)
  24 {
  25     $html = "";
  26     if (count($binary_log_file_names) > 1) {
  27         $html .= '<form action="server_binlog.php" method="get">';
  28         $html .= PMA_URL_getHiddenInputs($url_params);
  29         $html .= '<fieldset><legend>';
  30         $html .= __('Select binary log to view');
  31         $html .= '</legend><select name="log">';
  32         $full_size = 0;
  33         foreach ($binary_log_file_names as $each_log) {
  34             $html .= '<option value="' . $each_log['Log_name'] . '"';
  35             if ($each_log['Log_name'] == $_REQUEST['log']) {
  36                 $html .= ' selected="selected"';
  37             }
  38             $html .= '>' . $each_log['Log_name'];
  39             if (isset($each_log['File_size'])) {
  40                 $full_size += $each_log['File_size'];
  41                 $html .= ' ('
  42                     . implode(
  43                         ' ',
  44                         PMA_Util::formatByteDown(
  45                             $each_log['File_size'], 3, 2
  46                         )
  47                     )
  48                     . ')';
  49             }
  50             $html .= '</option>';
  51         }
  52         $html .= '</select> ';
  53         $html .= count($binary_log_file_names) . ' ' . __('Files') . ', ';
  54         if ($full_size > 0) {
  55             $html .= implode(
  56                 ' ', PMA_Util::formatByteDown($full_size)
  57             );
  58         }
  59         $html .= '</fieldset>';
  60         $html .= '<fieldset class="tblFooters">';
  61         $html .= '<input type="submit" value="' . __('Go') . '" />';
  62         $html .= '</fieldset>';
  63         $html .= '</form>';
  64     }
  65
  66     return $html;
  67 }
  68
  69 /**
  70  * Returns the html for binary log information.
  71  *
  72  * @param Array $binary_log_file_names Binary logs file names
  73  * @param Array $url_params            links parameters
  74  *
  75  * @return string
  76  */
  77 function PMA_getLogInfo($binary_log_file_names, $url_params)
  78 {
  79     /**
  80      * Need to find the real end of rows?
  81      */
  82     if (! isset($_REQUEST['pos'])) {
  83         $pos = 0;
  84     } else {
  85         /* We need this to be a integer */
  86         $pos = (int) $_REQUEST['pos'];
  87     }
  88
  89     $sql_query = 'SHOW BINLOG EVENTS';
  90     if (! empty($_REQUEST['log'])) {
  91         $sql_query .= ' IN \'' . $_REQUEST['log'] . '\'';
  92     }
  93     $sql_query .= ' LIMIT ' . $pos . ', ' . (int) $GLOBALS['cfg']['MaxRows'];
  94
  95     /**
  96      * Sends the query
  97      */
  98     $result = $GLOBALS['dbi']->query($sql_query);
  99
 100     /**
 101      * prepare some vars for displaying the result table
 102      */
 103     // Gets the list of fields properties
 104     if (isset($result) && $result) {
 105         $num_rows = $GLOBALS['dbi']->numRows($result);
 106     } else {
 107         $num_rows = 0;
 108     }
 109
 110     if (empty($_REQUEST['dontlimitchars'])) {
 111         $dontlimitchars = false;
 112     } else {
 113         $dontlimitchars = true;
 114         $url_params['dontlimitchars'] = 1;
 115     }
 116
 117     //html output
 118     $html  = PMA_Util::getMessage(PMA_Message::success(), $sql_query);
 119     $html .= '<table cellpadding="2" cellspacing="1" id="binlogTable">'
 120         . '<thead>'
 121         . '<tr>'
 122         . '<td colspan="6" class="center">';
 123
 124     $html .= PMA_getNavigationRow($url_params, $pos, $num_rows, $dontlimitchars);
 125
 126     $html .=  '</td>'
 127         . '</tr>'
 128         . '<tr>'
 129         . '<th>' . __('Log name') . '</th>'
 130         . '<th>' . __('Position') . '</th>'
 131         . '<th>' . __('Event type') . '</th>'
 132         . '<th>' . __('Server ID') . '</th>'
 133         . '<th>' . __('Original position') . '</th>'
 134         . '<th>' . __('Information') . '</th>'
 135         . '</tr>'
 136         . '</thead>'
 137         . '<tbody>';
 138
 139     $html .= PMA_getAllLogItemInfo($result, $dontlimitchars);
 140
 141     $html .= '</tbody>'
 142         . '</table>';
 143
 144     return $html;
 145 }
 146
 147 /**
 148  * Returns the html for Navigation Row.
 149  *
 150  * @param Array $url_params     Links parameters
 151  * @param int   $pos            Position to display
 152  * @param int   $num_rows       Number of results row
 153  * @param bool  $dontlimitchars Whether limit chars
 154  *
 155  * @return string
 156  */
 157 function PMA_getNavigationRow($url_params, $pos, $num_rows, $dontlimitchars)
 158 {
 159     $html = "";
 160     // we do not know how much rows are in the binlog
 161     // so we can just force 'NEXT' button
 162     if ($pos > 0) {
 163         $this_url_params = $url_params;
 164         if ($pos > $GLOBALS['cfg']['MaxRows']) {
 165             $this_url_params['pos'] = $pos - $GLOBALS['cfg']['MaxRows'];
 166         }
 167
 168         $html .= '<a href="server_binlog.php'
 169             . PMA_URL_getCommon($this_url_params) . '"';
 170         if (PMA_Util::showIcons('TableNavigationLinksMode')) {
 171             $html .= ' title="' . _pgettext('Previous page', 'Previous') . '">';
 172         } else {
 173             $html .= '>' . _pgettext('Previous page', 'Previous');
 174         } // end if... else...
 175         $html .= ' &lt; </a> - ';
 176     }
 177
 178     $this_url_params = $url_params;
 179     if ($pos > 0) {
 180         $this_url_params['pos'] = $pos;
 181     }
 182     if ($dontlimitchars) {
 183         unset($this_url_params['dontlimitchars']);
 184         $tempTitle = __('Truncate Shown Queries');
 185         $tempImgMode = 'partial';
 186     } else {
 187         $this_url_params['dontlimitchars'] = 1;
 188         $tempTitle = __('Show Full Queries');
 189         $tempImgMode = 'full';
 190     }
 191     $html .= '<a href="server_binlog.php' . PMA_URL_getCommon($this_url_params)
 192         . '" title="' . $tempTitle . '">'
 193         . '<img src="' .$GLOBALS['pmaThemeImage'] . 's_' . $tempImgMode . 'text.png"'
 194         . 'alt="' . $tempTitle . '" /></a>';
 195
 196     // we do not now how much rows are in the binlog
 197     // so we can just force 'NEXT' button
 198     if ($num_rows >= $GLOBALS['cfg']['MaxRows']) {
 199         $this_url_params = $url_params;
 200         $this_url_params['pos'] = $pos + $GLOBALS['cfg']['MaxRows'];
 201         $html .= ' - <a href="server_binlog.php'
 202             . PMA_URL_getCommon($this_url_params)
 203             . '"';
 204         if (PMA_Util::showIcons('TableNavigationLinksMode')) {
 205             $html .= ' title="' . _pgettext('Next page', 'Next') . '">';
 206         } else {
 207             $html .= '>' . _pgettext('Next page', 'Next');
 208         } // end if... else...
 209         $html .= ' &gt; </a>';
 210     }
 211
 212     return $html;
 213 }
 214
 215 /**
 216  * Returns the html for all binary log items.
 217  *
 218  * @param resource $result         MySQL Query result
 219  * @param bool     $dontlimitchars Whether limit chars
 220  *
 221  * @return string
 222  */
 223 function PMA_getAllLogItemInfo($result, $dontlimitchars)
 224 {
 225     $html = "";
 226     $odd_row = true;
 227     while ($value = $GLOBALS['dbi']->fetchAssoc($result)) {
 228         $html .= '<tr class="noclick ' . ($odd_row ? 'odd' : 'even') . '">'
 229             . '<td>&nbsp;' . $value['Log_name'] . '&nbsp;</td>'
 230             . '<td class="right">&nbsp;' . $value['Pos'] . '&nbsp;</td>'
 231             . '<td>&nbsp;' . $value['Event_type'] . '&nbsp;</td>'
 232             . '<td class="right">&nbsp;' . $value['Server_id'] . '&nbsp;</td>'
 233             . '<td class="right">&nbsp;'
 234             . (isset($value['Orig_log_pos'])
 235             ? $value['Orig_log_pos'] : $value['End_log_pos'])
 236             . '&nbsp;</td>'
 237             . '<td>&nbsp;' . PMA_Util::formatSql($value['Info'], ! $dontlimitchars)
 238             . '&nbsp;</td></tr>';
 239
 240         $odd_row = !$odd_row;
 241     }
 242     return $html;
 243 }
 244
 245 ?>