diff options
author | Spun Nakandala <supun.nakandala@gmail.com> | 2013-08-16 21:36:11 +0400 |
---|---|---|
committer | Spun Nakandala <supun.nakandala@gmail.com> | 2013-08-16 21:36:11 +0400 |
commit | ba9b2e7fa70c58d3c452f5abb0b0e907e816d68f (patch) | |
tree | 50435e2d457c5cecf11bb91011a59aee3e6ff5a1 | |
parent | b5919530036a79954d0e5c17d27853b356393d03 (diff) |
removed dead code
-rw-r--r-- | tbl_create.php | 214 |
1 files changed, 4 insertions, 210 deletions
diff --git a/tbl_create.php b/tbl_create.php index a2ad474cbe..171d35df4f 100644 --- a/tbl_create.php +++ b/tbl_create.php @@ -99,216 +99,10 @@ if (isset($_REQUEST['do_save_data'])) { // Executes the query $result = $GLOBALS['dbi']->tryQuery($sql_query); - if ($result) { - - // If comments were sent, enable relation stuff - include_once 'libraries/transformations.lib.php'; - - // Update comment table for mime types [MIME] - if (isset($_REQUEST['field_mimetype']) - && is_array($_REQUEST['field_mimetype']) - && $cfg['BrowseMIME'] - ) { - foreach ($_REQUEST['field_mimetype'] as $fieldindex => $mimetype) { - if (isset($_REQUEST['field_name'][$fieldindex]) - && strlen($_REQUEST['field_name'][$fieldindex]) - ) { - PMA_setMIME( - $db, $table, $_REQUEST['field_name'][$fieldindex], $mimetype, - $_REQUEST['field_transformation'][$fieldindex], - $_REQUEST['field_transformation_options'][$fieldindex] - ); - } - } - } - - $message = PMA_Message::success(__('Table %1$s has been created.')); - $message->addParam( - PMA_Util::backquote($db) . '.' . PMA_Util::backquote($table) - ); - - if ($GLOBALS['is_ajax_request'] == true) { - - /** - * construct the html for the newly created table's row to be appended - * to the list of tables. - * - * Logic taken from db_structure.php - */ - - $tbl_url_params = array(); - $tbl_url_params['db'] = $db; - $tbl_url_params['table'] = $table; - $is_show_stats = $cfg['ShowStats']; - - $tbl_stats_result = $GLOBALS['dbi']->query( - 'SHOW TABLE STATUS FROM ' . PMA_Util::backquote($db) - . ' LIKE \'' . PMA_Util::sqlAddSlashes($table, true) . '\';' - ); - $tbl_stats = $GLOBALS['dbi']->fetchAssoc($tbl_stats_result); - $GLOBALS['dbi']->freeResult($tbl_stats_result); - unset($tbl_stats_result); - - if ($is_show_stats) { - $sum_size = (double) 0; - $overhead_size = (double) 0; - $overhead_check = ''; - - $tblsize = doubleval($tbl_stats['Data_length']) - + doubleval($tbl_stats['Index_length']); - $sum_size += $tblsize; - list($formatted_size, $unit) = PMA_Util::formatByteDown( - $tblsize, - 3, - ($tblsize > 0) ? 1 : 0 - ); - if (isset($tbl_stats['Data_free']) && $tbl_stats['Data_free'] > 0) { - list($formatted_overhead, $overhead_unit) - = PMA_Util::formatByteDown( - $tbl_stats['Data_free'], - 3, - ($tbl_stats['Data_free'] > 0) ? 1 : 0 - ); - $overhead_size += $tbl_stats['Data_free']; - } - - if (isset($formatted_overhead)) { - $overhead = '<span>' . $formatted_overhead . '</span>' - . '<span class="unit">' . $overhead_unit . '</span>'; - unset($formatted_overhead); - } else { - $overhead = '-'; - } - } - - $new_table_string = '<tr>' . "\n"; - $new_table_string .= '<td class="center">' - . '<input type="checkbox" id="checkbox_tbl_"' - . ' name="selected_tbl[]" value="'.htmlspecialchars($table).'" />' - . '</td>' . "\n"; - - $new_table_string .= '<th>'; - $new_table_string .= '<a href="sql.php' - . PMA_URL_getCommon($tbl_url_params) . '">' - . htmlspecialchars($table) . '</a>'; - - if (PMA_Tracker::isActive()) { - $truename = str_replace(' ', ' ', htmlspecialchars($table)); - if (PMA_Tracker::isTracked($db, $truename)) { - $new_table_string .= '<a href="tbl_tracking.php' - . PMA_URL_getCommon($tbl_url_params) . '">'; - $new_table_string .= PMA_Util::getImage( - 'eye.png', __('Tracking is active.') - ); - } elseif (PMA_Tracker::getVersion($db, $truename) > 0) { - $new_table_string .= '<a href="tbl_tracking.php' - . PMA_URL_getCommon($tbl_url_params) . '">'; - $new_table_string .= PMA_Util::getImage( - 'eye_grey.png', __('Tracking is not active.') - ); - } - unset($truename); - } - $new_table_string .= '</th>' . "\n"; - - $new_table_string .= '<td>' . $titles['NoBrowse'] . '</td>' . "\n"; - - $new_table_string .= '<td>' - . '<a href="tbl_structure.php' - . PMA_URL_getCommon($tbl_url_params) . '">' - . $titles['Structure'] - . '</a>' - . '</td>' . "\n"; - - $new_table_string .= '<td>' . $titles['NoSearch'] . '</td>' . "\n"; - - $new_table_string .= '<td>' - . '<a href="tbl_change.php' - . PMA_URL_getCommon($tbl_url_params) . '">' - . $titles['Insert'] - . '</a>' - . '</td>' . "\n"; - - $new_table_string .= '<td>' . $titles['NoEmpty'] . '</td>' . "\n"; - - $new_table_string .= '<td>' - . '<a class="drop_table_anchor" href="sql.php' - . PMA_URL_getCommon($tbl_url_params) . '&sql_query=' - . urlencode('DROP TABLE ' . PMA_Util::backquote($table)) . '">' - . $titles['Drop'] - . '</a>' - . '</td>' . "\n"; - - $new_table_string .= '<td class="value">' - . $tbl_stats['Rows'] - . '</td>' . "\n"; - - $new_table_string .= '<td class="nowrap">' - . $tbl_stats['Engine'] - . '</td>' . "\n"; - - $new_table_string .= '<td>' - . '<dfn title="' - . PMA_getCollationDescr($tbl_stats['Collation']) . '">' - . $tbl_stats['Collation'] - .'</dfn>' - . '</td>' . "\n"; - - if ($is_show_stats) { - $new_table_string .= '<td class="value tbl_size">' - . '<a href="tbl_structure.php' - . PMA_URL_getCommon($tbl_url_params) . '#showusage" >' - . '<span>' . $formatted_size . '</span>' - . '<span class="unit">' . $unit . '</span>' - . '</a>' - . '</td>' . "\n" ; - - $new_table_string .= '<td class="value tbl_overhead">' - . $overhead - . '</td>' . "\n" ; - } - $new_table_string .= '</tr>' . "\n"; - - $formatted_sql = PMA_Util::getMessage( - $message, $sql_query, 'success' - ); - - $response = PMA_Response::getInstance(); - $response->addJSON('message', $message); - $response->addJSON('formatted_sql', $formatted_sql); - $response->addJSON('new_table_string', $new_table_string); - } else { - - $display_query = $sql_query; - $sql_query = ''; - - // read table info on this newly created table, in case - // the next page is Structure - $reread_info = true; - include 'libraries/tbl_info.inc.php'; - - // do not switch to sql.php - // as there is no row to be displayed on a new table - if ($cfg['DefaultTabTable'] === 'sql.php') { - include 'tbl_structure.php'; - } else { - include '' . $cfg['DefaultTabTable']; - } - } - } else { - if ($GLOBALS['is_ajax_request'] == true) { - $response = PMA_Response::getInstance(); - $response->isSuccess(false); - $response->addJSON('message', $GLOBALS['dbi']->getError()); - } else { - echo PMA_Util::mysqlDie('', '', '', $err_url, false); - // An error happened while inserting/updating a table definition. - // To prevent total loss of that data, we embed the form once again. - // The variable $regenerate will be used to restore data in - // libraries/tbl_columns_definition_form.inc.php - $num_fields = $_REQUEST['orig_num_fields']; - $regenerate = true; - } + if (!$result) { + $response = PMA_Response::getInstance(); + $response->isSuccess(false); + $response->addJSON('message', $GLOBALS['dbi']->getError()); } exit; } // end do create table |