Управление сайтом

Файловый менеджер

Имя файла	tbl_indexes.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * Displays index edit/creation form and handles it * * @package PhpMyAdmin / /* * Gets some core libraries / require_once './libraries/common.inc.php'; require_once './libraries/Index.class.php'; require_once './libraries/tbl_common.php'; // Get fields and stores their name/type $fields = array(); foreach (PMA_DBI_get_columns_full($db, $table) as $row) { if (preg_match('@^(set\|enum)$(.+)$$@i', $row['Type'], $tmp)) { $tmp[2] = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1); $fields[$row['Field']] = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')'; } else { $fields[$row['Field']] = $row['Type']; } } // end while // Prepares the form values if (isset($_REQUEST['index'])) { if (is_array($_REQUEST['index'])) { // coming already from form $index = new PMA_Index($_REQUEST['index']); } else { $index = PMA_Index::singleton($db, $table, $_REQUEST['index']); } } else { $index = new PMA_Index; } /* * Process the data from the edit/create index form, * run the query to build the new index * and moves back to "tbl_sql.php" / if (isset($_REQUEST['do_save_data'])) { $error = false; // $sql_query is the one displayed in the query box $sql_query = 'ALTER TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table); // Drops the old index if (! empty($_REQUEST['old_index'])) { if ($_REQUEST['old_index'] == 'PRIMARY') { $sql_query .= ' DROP PRIMARY KEY,'; } else { $sql_query .= ' DROP INDEX ' . PMA_backquote($_REQUEST['old_index']) . ','; } } // end if // Builds the new one switch ($index->getType()) { case 'PRIMARY': if ($index->getName() == '') { $index->setName('PRIMARY'); } elseif ($index->getName() != 'PRIMARY') { $error = PMA_Message::error(__('The name of the primary key must be "PRIMARY"!')); } $sql_query .= ' ADD PRIMARY KEY'; break; case 'FULLTEXT': case 'UNIQUE': case 'INDEX': case 'SPATIAL': if ($index->getName() == 'PRIMARY') { $error = PMA_Message::error(__('Can\'t rename index to PRIMARY!')); } $sql_query .= ' ADD ' . $index->getType() . ' ' . ($index->getName() ? PMA_backquote($index->getName()) : ''); break; } // end switch $index_fields = array(); foreach ($index->getColumns() as $key => $column) { $index_fields[$key] = PMA_backquote($column->getName()); if ($column->getSubPart()) { $index_fields[$key] .= '(' . $column->getSubPart() . ')'; } } // end while if (empty($index_fields)) { $error = PMA_Message::error(__('No index parts defined!')); } else { $sql_query .= ' (' . implode(', ', $index_fields) . ')'; } if (! $error) { PMA_DBI_query($sql_query); $message = PMA_Message::success(__('Table %1$s has been altered successfully')); $message->addParam($table); if ( $GLOBALS['is_ajax_request'] == true) { $extra_data['index_table'] = PMA_Index::getView($table, $db); $extra_data['sql_query'] = PMA_showMessage(null, $sql_query); PMA_ajaxResponse($message, $message->isSuccess(), $extra_data); } $active_page = 'tbl_structure.php'; include './tbl_structure.php'; exit; } else { if ( $GLOBALS['is_ajax_request'] == true) { $extra_data['error'] = $error; PMA_ajaxResponse($error, false); } $error->display(); } } // end builds the new index /* * Display the form to edit/create an index / // Displays headers (if needed) $GLOBALS['js_include'][] = 'indexes.js'; require_once './libraries/tbl_info.inc.php'; if ($GLOBALS['is_ajax_request'] != true) { include_once './libraries/tbl_links.inc.php'; } if (isset($_REQUEST['index']) && is_array($_REQUEST['index'])) { // coming already from form $add_fields = count($_REQUEST['index']['columns']['names']) - $index->getColumnCount(); if (isset($_REQUEST['add_fields'])) { $add_fields += $_REQUEST['added_fields']; } } elseif (isset($_REQUEST['create_index'])) { $add_fields = $_REQUEST['added_fields']; } else { $add_fields = 1; } // end preparing form values ?> <form action="./tbl_indexes.php" method="post" name="index_frm" id="index_frm" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : ''); ?> onsubmit="if (typeof(this.elements['index[Key_name]'].disabled) != 'undefined') { this.elements['index[Key_name]'].disabled = false}"> <?php $form_params = array( 'db' => $db, 'table' => $table, ); if (isset($_REQUEST['create_index'])) { $form_params['create_index'] = 1; } elseif (isset($_REQUEST['old_index'])) { $form_params['old_index'] = $_REQUEST['old_index']; } elseif (isset($_REQUEST['index'])) { $form_params['old_index'] = $_REQUEST['index']; } echo PMA_generate_common_hidden_inputs($form_params); ?> <fieldset id="index_edit_fields"> <?php if ($GLOBALS['is_ajax_request'] != true) { ?> <legend> <?php if (isset($_REQUEST['create_index'])) { echo __('Add index'); } else { echo __('Edit index'); } ?> </legend> <?php } ?> <div class='index_info'> <div> <div class="label"> <strong> <label for="input_index_name"> <?php echo __('Index name:'); ?> <?php echo PMA_showhint(PMA_Message::notice(__('("PRIMARY" <b>must</b> be the name of and <b>only of</b> a primary key!)'))); ?> </label> </strong> </div> <input type="text" name="index[Key_name]" id="input_index_name" size="25" value="<?php echo htmlspecialchars($index->getName()); ?>" onfocus="this.select()" /> </div> <div> <div class="label"> <strong> <label for="select_index_type"> <?php echo __('Index type:'); ?> <?php echo PMA_showMySQLDocu('SQL-Syntax', 'ALTER_TABLE'); ?> </label> </strong> </div> <select name="index[Index_type]" id="select_index_type" > <?php echo $index->generateIndexSelector(); ?> </select> </div> <div class="clearfloat"></div> </div> <table id="index_columns"> <thead> <tr><th><?php echo __('Column'); ?></th> <th><?php echo __('Size'); ?></th> </tr> </thead> <tbody> <?php $odd_row = true; $spatial_types = array( 'geometry', 'point', 'linestring', 'polygon', 'multipoint', 'multilinestring', 'multipolygon', 'geomtrycollection' ); foreach ($index->getColumns() as $column) { ?> <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?> noclick"> <td><select name="index[columns][names][]"> <option value="">-- <?php echo __('Ignore'); ?> --</option> <?php foreach ($fields as $field_name => $field_type) { if (($index->getType() != 'FULLTEXT' \|\| preg_match('/(char\|text)/i', $field_type)) && ($index->getType() != 'SPATIAL' \|\| in_array($field_type, $spatial_types)) ) { echo '<option value="' . htmlspecialchars($field_name) . '"' . (($field_name == $column->getName()) ? ' selected="selected"' : '') . '>' . htmlspecialchars($field_name) . ' [' . htmlspecialchars($field_type) . ']' . '</option>' . "\n"; } } // end foreach $fields ?> </select> </td> <td><input type="text" size="5" onfocus="this.select()" name="index[columns][sub_parts][]" value="<?php if ($index->getType() != 'SPATIAL') { echo $column->getSubPart(); } ?>" /> </td> </tr> <?php $odd_row = !$odd_row; } // end foreach $edited_index_info['Sequences'] for ($i = 0; $i < $add_fields; $i++) { ?> <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?> noclick"> <td><select name="index[columns][names][]"> <option value="">-- <?php echo __('Ignore'); ?> --</option> <?php foreach ($fields as $field_name => $field_type) { echo '<option value="' . htmlspecialchars($field_name) . '">' . htmlspecialchars($field_name) . ' [' . htmlspecialchars($field_type) . ']' . '</option>' . "\n"; } // end foreach $fields ?> </select> </td> <td><input type="text" size="5" onfocus="this.select()" name="index[columns][sub_parts][]" value="" /> </td> </tr> <?php $odd_row = !$odd_row; } // end foreach $edited_index_info['Sequences'] ?> </tbody> </table> </fieldset> <fieldset class="tblFooters"> <?php if ($GLOBALS['is_ajax_request'] != true) { ?> <input type="submit" name="do_save_data" value="<?php echo __('Save'); ?>" /> <span id="addMoreColumns"> <?php echo __('Or') . ' '; printf( __('Add to index  %s column(s)') . "\n", '<input type="text" name="added_fields" size="2" value="1" />' ); echo '<input type="submit" name="add_fields" value="' . __('Go') . '" />' . "\n"; ?> </span> <?php } else { $btn_value = sprintf(__('Add %d column(s) to index'), 1); echo '<div class="slider"></div>'; echo '<div class="add_fields">'; echo '<input type="submit" value="' . $btn_value . '" />'; echo '</div>'; } ?> </fieldset> </form> <?php /* * Displays the footer */ require './libraries/footer.inc.php'; ?>

/admin/phpmyadmin/

Имя	Дата	Размер
..	2026-10-02
examples	2013-04-27
js	2013-04-27
libraries	2015-04-04
locale	2013-04-27
setup	2013-04-27
themes	2013-04-27
ChangeLog	2012-10-10	27 кб.
Documentation.html	2012-10-10	252 кб.
Documentation.txt	2012-10-10	176 кб.
LICENSE	2012-10-10	18 кб.
README	2012-10-10	2 кб.
README.VENDOR	2012-10-10	1 кб.
RELEASE-DATE-3.5.2.2	2012-10-10	29 байт
browse_foreigners.php	2012-10-10	11 кб.
bs_disp_as_mime_type.php	2012-10-10	1 кб.
bs_play_media.php	2012-10-10	2 кб.
changelog.php	2012-10-10	4 кб.
chk_rel.php	2012-10-10	363 байт
config.inc.php	2012-10-10	374 байт
config.inc.php.sample	2012-10-10	374 байт
config.sample.inc.php	2012-10-10	4 кб.
db_create.php	2012-10-10	4 кб.
db_datadict.php	2012-10-10	8 кб.
db_events.php	2012-10-10	773 байт
db_export.php	2012-10-10	3 кб.
db_import.php	2012-10-10	466 байт
db_operations.php	2012-10-10	22 кб.
db_printview.php	2012-10-10	7 кб.
db_qbe.php	2012-10-10	30 кб.
db_routines.php	2012-10-10	964 байт
db_search.php	2012-10-10	13 кб.
db_sql.php	2012-10-10	1 кб.
db_structure.php	2012-10-10	24 кб.
db_tracking.php	2012-10-10	8 кб.
db_triggers.php	2012-10-10	728 байт
docs.css	2012-10-10	3 кб.
enum_editor.php	2012-10-10	5 кб.
export.php	2012-10-10	28 кб.
favicon.ico	2012-10-10	18 кб.
file_echo.php	2012-10-10	2 кб.
gis_data_editor.php	2012-10-10	17 кб.
import.php	2012-10-10	17 кб.
import_status.php	2012-10-10	953 байт
index.php	2012-10-10	6 кб.
license.php	2012-10-10	730 байт
main.php	2012-10-10	17 кб.
navigation.php	2012-10-10	25 кб.
phpinfo.php	2012-10-10	349 байт
phpmyadmin.css.php	2012-10-10	1 кб.
pmd_display_field.php	2012-10-10	2 кб.
pmd_general.php	2012-10-10	35 кб.
pmd_pdf.php	2012-10-10	4 кб.
pmd_relation_new.php	2012-10-10	4 кб.
pmd_relation_upd.php	2012-10-10	2 кб.
pmd_save_pos.php	2012-10-10	2 кб.
prefs_forms.php	2012-10-10	3 кб.
prefs_manage.php	2012-10-10	14 кб.
print.css	2012-10-10	1 кб.
querywindow.php	2012-10-10	6 кб.
robots.txt	2012-10-10	26 байт
schema_edit.php	2012-10-10	4 кб.
schema_export.php	2012-10-10	1 кб.
server_binlog.php	2012-10-10	6 кб.
server_collations.php	2012-10-10	3 кб.
server_databases.php	2012-10-10	10 кб.
server_engines.php	2012-10-10	5 кб.
server_export.php	2012-10-10	2 кб.
server_import.php	2012-10-10	477 байт
server_plugins.php	2012-10-10	7 кб.
server_privileges.php	2012-10-10	107 кб.
server_replication.php	2012-10-10	17 кб.
server_sql.php	2012-10-10	743 байт
server_status.php	2012-10-10	76 кб.
server_synchronize.php	2012-10-10	56 кб.
server_variables.php	2012-10-10	6 кб.
show_config_errors.php	2012-10-10	574 байт
sql.php	2012-10-10	37 кб.
tbl_addfield.php	2012-10-10	8 кб.
tbl_alter.php	2012-10-10	7 кб.
tbl_change.php	2012-10-10	49 кб.
tbl_chart.php	2012-10-10	6 кб.
tbl_create.php	2012-10-10	14 кб.
tbl_export.php	2012-10-10	3 кб.
tbl_get_field.php	2012-10-10	1 кб.
tbl_gis_visualization.php	2012-10-10	7 кб.
tbl_import.php	2012-10-10	624 байт
tbl_indexes.php	2012-10-10	9 кб.
tbl_move_copy.php	2012-10-10	3 кб.
tbl_operations.php	2012-10-10	32 кб.
tbl_printview.php	2012-10-10	14 кб.
tbl_relation.php	2012-10-10	23 кб.
tbl_replace.php	2012-10-10	23 кб.
tbl_row_action.php	2012-10-10	5 кб.
tbl_select.php	2012-10-10	10 кб.
tbl_sql.php	2012-10-10	1 кб.
tbl_structure.php	2012-10-10	39 кб.
tbl_tracking.php	2012-10-10	28 кб.
tbl_triggers.php	2012-10-10	144 байт
tbl_zoom_select.php	2012-10-10	17 кб.
themes.php	2012-10-10	822 байт
transformation_overview.php	2012-10-10	2 кб.
transformation_wrapper.php	2012-10-10	3 кб.
url.php	2012-10-10	391 байт
user_password.php	2012-10-10	4 кб.
view_create.php	2012-10-10	5 кб.
view_operations.php	2012-10-10	3 кб.
webapp.php	2012-10-10	1 кб.

/admin/phpmyadmin