tryQuery($sql_query)) { if (! isset($_REQUEST['ajax_dialog'])) { $message = PMA\libraries\Message::rawError($GLOBALS['dbi']->getError()); return; } $response = PMA\libraries\Response::getInstance(); $response->addJSON( 'message', PMA\libraries\Message::error( "" . htmlspecialchars($sql_query) . "

" . $GLOBALS['dbi']->getError() ) ); $response->isSuccess(false); exit; } // If different column names defined for VIEW $view_columns = array(); if (isset($_REQUEST['view']['column_names'])) { $view_columns = explode(',', $_REQUEST['view']['column_names']); } $column_map = $GLOBALS['dbi']->getColumnMapFromSql( $_REQUEST['view']['as'], $view_columns ); $systemDb = $GLOBALS['dbi']->getSystemDatabase(); $pma_transformation_data = $systemDb->getExistingTransformationData( $GLOBALS['db'] ); if ($pma_transformation_data !== false) { // SQL for store new transformation details of VIEW $new_transformations_sql = $systemDb->getNewTransformationDataSql( $pma_transformation_data, $column_map, $_REQUEST['view']['name'], $GLOBALS['db'] ); // Store new transformations if ($new_transformations_sql != '') { $GLOBALS['dbi']->tryQuery($new_transformations_sql); } } unset($pma_transformation_data); if (! isset($_REQUEST['ajax_dialog'])) { $message = PMA\libraries\Message::success(); include 'tbl_structure.php'; } else { $response = PMA\libraries\Response::getInstance(); $response->addJSON( 'message', PMA\libraries\Util::getMessage(PMA\libraries\Message::success(), $sql_query) ); $response->isSuccess(true); } exit; } // prefill values if not already filled from former submission $view = array( 'operation' => 'create', 'or_replace' => '', 'algorithm' => '', 'definer' => '', 'sql_security' => '', 'name' => '', 'column_names' => '', 'as' => $sql_query, 'with' => '', ); if (PMA_isValid($_REQUEST['view'], 'array')) { $view = array_merge($view, $_REQUEST['view']); } $url_params['db'] = $GLOBALS['db']; $url_params['reload'] = 1; /** * Displays the page */ $htmlString = '' . '
' . '
' . PMA_URL_getHiddenInputs($url_params) . '
' . '' . (isset($_REQUEST['ajax_dialog']) ? __('Details') : ($view['operation'] == 'create' ? __('Create view') : __('Edit view')) ) . '' . ''; if ($view['operation'] == 'create') { $htmlString .= '' . '' . '' . ''; $htmlString .= '' . ''; $htmlString .= '' . ''; if ($view['operation'] == 'create') { $htmlString .= '' . ''; } else { $htmlString .= ''; } $htmlString .= '' . ''; $htmlString .= '' . '
' . '
' . __('Definer') . '' . '
SQL SECURITY' . '
' . __('VIEW name') . '' . '
' . '
' . __('Column names') . '' . '
AS' . '