binary_logs = $this->dbi->fetchResult( 'SHOW MASTER LOGS', 'Log_name', null, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_STORE ); } /** * Index action * * @return void */ public function indexAction() { /** * Does the common work */ include_once 'libraries/server_common.inc.php'; $url_params = array(); if (! isset($_POST['log']) || ! array_key_exists($_POST['log'], $this->binary_logs) ) { $_POST['log'] = ''; } else { $url_params['log'] = $_POST['log']; } if (!empty($_POST['dontlimitchars'])) { $url_params['dontlimitchars'] = 1; } $this->response->addHTML( Template::get('server/sub_page_header')->render([ 'type' => 'binlog', ]) ); $this->response->addHTML($this->_getLogSelector($url_params)); $this->response->addHTML($this->_getLogInfo($url_params)); } /** * Returns the html for log selector. * * @param array $url_params links parameters * * @return string */ private function _getLogSelector(array $url_params) { return Template::get('server/binlog/log_selector')->render( array( 'url_params' => $url_params, 'binary_logs' => $this->binary_logs, 'log' => $_POST['log'], ) ); } /** * Returns the html for binary log information. * * @param array $url_params links parameters * * @return string */ private function _getLogInfo(array $url_params) { /** * Need to find the real end of rows? */ if (! isset($_POST['pos'])) { $pos = 0; } else { /* We need this to be a integer */ $pos = (int) $_POST['pos']; } $sql_query = 'SHOW BINLOG EVENTS'; if (! empty($_POST['log'])) { $sql_query .= ' IN \'' . $_POST['log'] . '\''; } $sql_query .= ' LIMIT ' . $pos . ', ' . intval($GLOBALS['cfg']['MaxRows']); /** * Sends the query */ $result = $this->dbi->query($sql_query); /** * prepare some vars for displaying the result table */ // Gets the list of fields properties if (isset($result) && $result) { $num_rows = $this->dbi->numRows($result); } else { $num_rows = 0; } if (empty($_POST['dontlimitchars'])) { $dontlimitchars = false; } else { $dontlimitchars = true; $url_params['dontlimitchars'] = 1; } //html output $html = Util::getMessage(Message::success(), $sql_query); $html .= '' . '' . '' . '' . '' . '' . '' . '' . '' . '' . '' . '' . '' . '' . ''; $html .= $this->_getAllLogItemInfo($result, $dontlimitchars); $html .= '' . '

'; $html .= $this->_getNavigationRow($url_params, $pos, $num_rows, $dontlimitchars); $html .= '
' . __('Log name') . '	' . __('Position') . '	' . __('Event type') . '	' . __('Server ID') . '	' . __('Original position') . '	' . __('Information') . '

'; return $html; } /** * Returns the html for Navigation Row. * * @param array $url_params Links parameters * @param int $pos Position to display * @param int $num_rows Number of results row * @param bool $dontlimitchars Whether limit chars * * @return string */ private function _getNavigationRow(array $url_params, $pos, $num_rows, $dontlimitchars) { $html = ""; // we do not know 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']; } $html .= ''; } else { $html .= '>' . _pgettext('Previous page', 'Previous'); } // end if... else... $html .= ' < - '; } $this_url_params = $url_params; if ($pos > 0) { $this_url_params['pos'] = $pos; } if ($dontlimitchars) { unset($this_url_params['dontlimitchars']); $tempTitle = __('Truncate Shown Queries'); $tempImgMode = 'partial'; } else { $this_url_params['dontlimitchars'] = 1; $tempTitle = __('Show Full Queries'); $tempImgMode = 'full'; } $html .= '' . ''; // 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']; $html .= ' - '; } else { $html .= '>' . _pgettext('Next page', 'Next'); } // end if... else... $html .= ' > '; } return $html; } /** * Returns the html for all binary log items. * * @param resource $result MySQL Query result * @param bool $dontlimitchars Whether limit chars * * @return string */ private function _getAllLogItemInfo($result, $dontlimitchars) { $html = ""; while ($value = $this->dbi->fetchAssoc($result)) { $html .= Template::get('server/binlog/log_row')->render( array( 'value' => $value, 'dontlimitchars' => $dontlimitchars, ) ); } return $html; } }