} if (!isset($dontlimitchars)) { $dontlimitchars = 0; } // hide edit and delete links for information_schema if (PMA_MYSQL_INT_VERSION >= 50002 && isset($db) && $db == 'information_schema') { $disp_mode = 'nnnn110111'; } PMA_displayTable($result, $disp_mode, $analyzed_sql); PMA_DBI_free_result($result); // BEGIN INDEX CHECK See if indexes should be checked. if (isset($query_type) && $query_type == 'check_tbl' && isset($selected) && is_array($selected)) { foreach ($selected as $idx => $tbl_name) { $indexes = $indexes_info = $indexes_data = array(); $tbl_ret_keys = PMA_get_indexes(urldecode($tbl_name), $err_url_0); PMA_extract_indexes($tbl_ret_keys, $indexes, $indexes_info, $indexes_data); $idx_collection = PMA_show_indexes(urldecode($tbl_name), $indexes, $indexes_info, $indexes_data, false); $check = PMA_check_indexes($idx_collection); if (!empty($check)) { ?> <table border="0" cellpadding="2" cellspacing="0"> <tr> <td class="tblHeaders" colspan="7"><?php printf($strIndexWarningTable, urldecode($tbl_name)); ?> </td> </tr> <?php echo $check; ?> </table>
function get_all_keys() { global $db; require_once './libs/tbl_indexes.lib.php'; PMA_DBI_select_db($db); $tables_all_keys = array(); for ($I = 0; $I < sizeof($GLOBALS['PMD']['TABLE_NAME_SMALL']); $I++) { $ret_keys = PMA_get_indexes($GLOBALS['PMD']['TABLE_NAME_SMALL'][$I]); if (!empty($ret_keys)) { // reset those as the function uses them by reference $indexes = $indexes_info = $indexes_data = array(); PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data); // for now, take into account only the first index segment foreach ($indexes_data as $one_index) { $column_name = $one_index[1]['Column_name']; $tables_all_keys[$GLOBALS['PMD']['OWNER'][$I] . '.' . $GLOBALS['PMD']['TABLE_NAME_SMALL'][$I] . '.' . $column_name] = 1; } } } return $tables_all_keys; }