addHTML($html); } return; } if (isset($_REQUEST['operation'])) { if ($_REQUEST['operation'] == 'deletePage') { $success = PMA_deletePage($_REQUEST['selected_page']); $response->setRequestStatus($success); } elseif ($_REQUEST['operation'] == 'savePage') { if ($_REQUEST['save_page'] == 'same') { $page = $_REQUEST['selected_page']; } else { // new $page = PMA_createNewPage($_REQUEST['selected_value'], $GLOBALS['db']); $response->addJSON('id', $page); } $success = PMA_saveTablePositions($page); $response->setRequestStatus($success); } elseif ($_REQUEST['operation'] == 'setDisplayField') { PMA_saveDisplayField( $_REQUEST['db'], $_REQUEST['table'], $_REQUEST['field'] ); $response->setRequestStatus(true); } elseif ($_REQUEST['operation'] == 'addNewRelation') { list($success, $message) = PMA_addNewRelation( $_REQUEST['db'], $_REQUEST['T1'], $_REQUEST['F1'], $_REQUEST['T2'], $_REQUEST['F2'], $_REQUEST['on_delete'], $_REQUEST['on_update'] ); $response->setRequestStatus($success); $response->addJSON('message', $message); } elseif ($_REQUEST['operation'] == 'removeRelation') { list($success, $message) = PMA_removeRelation( $_REQUEST['T1'], $_REQUEST['F1'], $_REQUEST['T2'], $_REQUEST['F2'] ); $response->setRequestStatus($success); $response->addJSON('message', $message); } elseif ($_REQUEST['operation'] == 'save_setting_value') { $success = PMA_saveDesignerSetting($_REQUEST['index'], $_REQUEST['value']); $response->setRequestStatus($success); } return; } require 'libraries/db_common.inc.php'; $script_display_field = PMA_getTablesInfo(); $tab_column = PMA_getColumnsInfo(); $script_tables = PMA_getScriptTabs(); $tables_pk_or_unique_keys = PMA_getPKOrUniqueKeys(); $tables_all_keys = PMA_getAllKeys(); $classes_side_menu = PMA_returnClassNamesFromMenuButtons(); $display_page = -1; $selected_page = null; if (isset($_REQUEST['query'])) { $display_page = PMA_getDefaultPage($_REQUEST['db']); } else { if (! empty($_REQUEST['page'])) { $display_page = $_REQUEST['page']; } else { $display_page = PMA_getLoadingPage($_REQUEST['db']); } } if ($display_page != -1) { $selected_page = PMA_getPageName($display_page); } $tab_pos = PMA_getTablePositions($display_page); $script_contr = PMA_getScriptContr(); $params = array('lang' => $GLOBALS['lang']); if (isset($_GET['db'])) { $params['db'] = $_GET['db']; } $response = PMA\libraries\Response::getInstance(); $response->getFooter()->setMinimal(); $header = $response->getHeader(); $header->setBodyId('pmd_body'); $scripts = $header->getScripts(); $scripts->addFile('jquery/jquery.fullscreen.js'); $scripts->addFile('pmd/designer_db.js'); $scripts->addFile('pmd/designer_objects.js'); $scripts->addFile('pmd/designer_page.js'); $scripts->addFile('pmd/history.js'); $scripts->addFile('pmd/move.js'); $scripts->addFile('pmd/init.js'); list( $tables, $num_tables, $total_num_tables, $sub_part, $is_show_stats, $db_is_system_schema, $tooltip_truename, $tooltip_aliasname, $pos ) = PMA\libraries\Util::getDbInfo($db, isset($sub_part) ? $sub_part : ''); // Embed some data into HTML, later it will be read // by pmd/init.js and converted to JS variables. $response->addHTML( PMA_getHtmlForJSFields( $script_tables, $script_contr, $script_display_field, $display_page ) ); $response->addHTML( PMA_getDesignerPageMenu( isset($_REQUEST['query']), $selected_page, $classes_side_menu ) ); $response->addHTML('
'); $response->addHTML( '
' ); $response->addHTML(PMA_getHTMLCanvas()); $response->addHTML(PMA_getHTMLTableList($tab_pos, $display_page)); $response->addHTML( PMA_getDatabaseTables( $tab_pos, $display_page, $tab_column, $tables_all_keys, $tables_pk_or_unique_keys ) ); $response->addHTML('
'); $response->addHTML('
'); // end canvas_outer $response->addHTML('
'); $response->addHTML(PMA_getNewRelationPanel()); $response->addHTML(PMA_getDeleteRelationPanel()); if (isset($_REQUEST['query'])) { $response->addHTML(PMA_getOptionsPanel()); $response->addHTML(PMA_getRenameToPanel()); $response->addHTML(PMA_getHavingQueryPanel()); $response->addHTML(PMA_getAggregateQueryPanel()); $response->addHTML(PMA_getWhereQueryPanel()); $response->addHTML(PMA_getQueryDetails()); } $response->addHTML('
');