getHeader(); $scripts = $header->getScripts(); $scripts->addFile('jquery/jquery.uitablefilter.js'); $scripts->addFile('jquery/jquery.tablesorter.js'); $scripts->addFile('db_central_columns.js'); $cfgCentralColumns = PMA_centralColumnsGetParams(); $pmadb = $cfgCentralColumns['db']; $pmatable = $cfgCentralColumns['table']; $max_rows = $GLOBALS['cfg']['MaxRows']; if (isset($_REQUEST['edit_central_columns_page'])) { $selected_fld = $_REQUEST['selected_fld']; $selected_db = $_REQUEST['db']; $edit_central_column_page = PMA_getHTMLforEditingPage( $selected_fld, $selected_db ); $response->addHTML($edit_central_column_page); exit; } if (isset($_POST['multi_edit_central_column_save'])) { $message = PMA_updateMultipleColumn(); if (!is_bool($message)) { $response->isSuccess(false); $response->addJSON('message', $message); } } if (isset($_POST['delete_save'])) { $col_name = array(); parse_str($_POST['col_name'], $col_name); $tmp_msg = PMA_deleteColumnsFromList($col_name['selected_fld'], false); } if (isset($_REQUEST['total_rows']) && $_REQUEST['total_rows']) { $total_rows = $_REQUEST['total_rows']; } else { $total_rows = PMA_getCentralColumnsCount($db); } if (isset($_REQUEST['pos'])) { $pos = $_REQUEST['pos']; } else { $pos = 0; } $addNewColumn = PMA_getHTMLforAddNewColumn($db); $response->addHTML($addNewColumn); if ($total_rows <= 0) { $response->addHTML( '
' . __( 'The central list of columns for the current database is empty.' ) . '
' ); $columnAdd = PMA_getHTMLforAddCentralColumn($total_rows, $pos, $db); $response->addHTML($columnAdd); exit; } $table_navigation_html = PMA_getHTMLforTableNavigation($total_rows, $pos, $db); $response->addHTML($table_navigation_html); $columnAdd = PMA_getHTMLforAddCentralColumn($total_rows, $pos, $db); $response->addHTML($columnAdd); $deleteRowForm = '
' . PMA_URL_getHiddenInputs( $db ) . '' . '' . '
'; $response->addHTML($deleteRowForm); $table_struct = '
' . '
' . ''; $response->addHTML($table_struct); $tableheader = PMA_getCentralColumnsTableHeader( 'column_heading', __('Click to sort.'), 2 ); $response->addHTML($tableheader); $result = PMA_getColumnsList($db, $pos, $max_rows); $odd_row = true; $row_num = 0; foreach ($result as $row) { $tableHtmlRow = PMA_getHTMLforCentralColumnsTableRow( $row, $odd_row, $row_num, $db ); $response->addHTML($tableHtmlRow); $odd_row = !$odd_row; $row_num++; } $response->addHTML('
'); $tablefooter = PMA_getCentralColumnsTableFooter($pmaThemeImage, $text_dir); $response->addHTML($tablefooter); $response->addHTML('
'); $message = PMA\libraries\Message::success( sprintf(__('Showing rows %1$s - %2$s.'), ($pos + 1), ($pos + count($result))) ); if (isset($tmp_msg) && $tmp_msg !== true) { $message = $tmp_msg; }