// Displays the results in a table if (empty($disp_mode)) { // see the "PMA_setDisplayMode()" function in // libraries/display_tbl.lib.php $disp_mode = 'urdr111101'; } // hide edit and delete links for information_schema if (PMA_MYSQL_INT_VERSION >= 50002 && $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) { $check = PMA_check_indexes($tbl_name); 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> <?php }
$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> <?php }
?> </th> <th colspan="2"><?php echo $strAction; ?> </th> <th colspan="2"><?php echo $strField; ?> </th> </tr> </thead> <tbody> <?php $idx_collection = PMA_show_indexes($table, $indexes, $indexes_info, $indexes_data, true); echo PMA_check_indexes($ret_keys); } else { // none indexes echo '<tbody>' . '<tr><td colspan="7"><div class="warning">' . $strNoIndex . '</div></td></tr>' . "\n"; } ?> <tr class="tblFooters"><td colspan="7"> <?php echo sprintf($strCreateIndex, '<input type="text" size="2" name="idx_num_fields" value="1" />'); ?> <input type="submit" name="create_index" value="<?php echo $strGo; ?> " onclick="return checkFormElementInRange(this.form,