Linux vps-61133.fhnet.fr 4.9.0-19-amd64 #1 SMP Debian 4.9.320-2 (2022-06-30) x86_64
Apache/2.4.25 (Debian)
Server IP : 93.113.207.21 & Your IP : 216.73.216.119
Domains :
Cant Read [ /etc/named.conf ]
User : www-data
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Readme
/
usr /
share /
phpmyadmin /
libraries /
Delete
Unzip
Name
Size
Permission
Date
Action
bfShapeFiles
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
config
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
controllers
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
dbi
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
di
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
engines
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
gis
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
navigation
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
plugins
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
properties
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
rte
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
sql-parser
[ DIR ]
drwxrwxrwx
2022-03-20 10:35
Advisor.php
15.13
KB
-rw-r--r--
2017-01-23 20:20
Config.php
54.69
KB
-rw-r--r--
2020-10-23 14:39
Console.php
14.82
KB
-rw-r--r--
2017-01-23 20:20
DatabaseInterface.php
95.6
KB
-rw-r--r--
2017-01-23 20:20
DbList.php
1.9
KB
-rw-r--r--
2017-01-23 20:20
DbQbe.php
68.87
KB
-rw-r--r--
2017-01-23 20:20
DbSearch.php
17.21
KB
-rw-r--r--
2017-01-23 20:20
DisplayResults.php
206
KB
-rw-r--r--
2020-10-23 14:39
Error.php
12.7
KB
-rw-r--r--
2017-01-23 20:20
ErrorHandler.php
16.48
KB
-rw-r--r--
2017-01-23 20:20
File.php
18.82
KB
-rw-r--r--
2017-01-23 20:20
Font.php
4.24
KB
-rw-r--r--
2017-01-23 20:20
Footer.php
10.52
KB
-rw-r--r--
2020-10-23 14:39
Header.php
25.34
KB
-rw-r--r--
2017-01-23 20:20
Index.php
23.79
KB
-rw-r--r--
2017-01-23 20:20
IndexColumn.php
4.46
KB
-rw-r--r--
2017-01-23 20:20
Language.php
4.27
KB
-rw-r--r--
2017-01-23 20:20
LanguageManager.php
20.75
KB
-rw-r--r--
2017-01-23 20:20
Linter.php
5.02
KB
-rw-r--r--
2017-01-23 20:20
ListAbstract.php
3.15
KB
-rw-r--r--
2017-01-23 20:20
ListDatabase.php
4.62
KB
-rw-r--r--
2017-01-23 20:20
Menu.php
21.14
KB
-rw-r--r--
2017-01-23 20:20
Message.php
18.67
KB
-rw-r--r--
2017-01-23 20:20
OutputBuffering.php
3.59
KB
-rw-r--r--
2017-01-23 20:20
PDF.php
3.94
KB
-rw-r--r--
2017-01-23 20:20
Partition.php
7.26
KB
-rw-r--r--
2017-01-23 20:20
Psr4Autoloader.php
4.85
KB
-rw-r--r--
2017-01-23 20:20
RecentFavoriteTable.php
11.78
KB
-rw-r--r--
2017-01-23 20:20
Response.php
12.61
KB
-rw-r--r--
2017-01-23 20:20
SavedSearches.php
11.67
KB
-rw-r--r--
2017-01-23 20:20
Scripts.php
7.38
KB
-rw-r--r--
2017-01-23 20:20
ServerStatusData.php
15.72
KB
-rw-r--r--
2017-01-23 20:20
StorageEngine.php
13.61
KB
-rw-r--r--
2017-01-23 20:20
SubPartition.php
3.52
KB
-rw-r--r--
2017-01-23 20:20
SysInfo.php
799
B
-rw-r--r--
2017-01-23 20:20
SysInfoLinux.php
1.92
KB
-rw-r--r--
2017-01-23 20:20
SysInfoSunOS.php
1.86
KB
-rw-r--r--
2017-01-23 20:20
SysInfoWINNT.php
3.08
KB
-rw-r--r--
2017-01-23 20:20
SystemDatabase.php
3.66
KB
-rw-r--r--
2017-01-23 20:20
Table.php
88.12
KB
-rw-r--r--
2017-01-23 20:20
Template.php
4.45
KB
-rw-r--r--
2017-01-23 20:20
Theme.php
11.34
KB
-rw-r--r--
2017-01-23 20:20
ThemeManager.php
12.91
KB
-rw-r--r--
2017-01-23 20:20
Tracker.php
30.35
KB
-rw-r--r--
2017-01-23 20:20
Types.php
6.08
KB
-rw-r--r--
2017-01-23 20:20
TypesMySQL.php
17.26
KB
-rw-r--r--
2017-01-23 20:20
Util.php
172.46
KB
-rw-r--r--
2020-10-23 14:39
VersionInformation.php
7.87
KB
-rw-r--r--
2017-01-23 20:20
ZipFile.php
6.63
KB
-rw-r--r--
2017-01-23 20:20
advisor.lib.php
1.6
KB
-rw-r--r--
2017-01-23 20:20
advisory_rules.txt
25.94
KB
-rw-r--r--
2017-01-23 20:20
autoloader.php
450
B
-rw-r--r--
2017-01-23 20:20
bookmark.lib.php
8.5
KB
-rw-r--r--
2017-01-23 20:20
browse_foreigners.lib.php
9.83
KB
-rw-r--r--
2017-01-23 20:20
central_columns.lib.php
49.38
KB
-rw-r--r--
2017-01-23 20:20
charset_conversion.lib.php
3.54
KB
-rw-r--r--
2017-01-23 20:20
check_user_privileges.lib.php
10.65
KB
-rw-r--r--
2017-01-23 20:20
cleanup.lib.php
1.29
KB
-rw-r--r--
2017-01-23 20:20
common.inc.php
34.38
KB
-rw-r--r--
2020-10-23 14:39
config.default.php
66.5
KB
-rw-r--r--
2017-01-23 20:20
config.values.php
10.17
KB
-rw-r--r--
2017-01-23 20:20
core.lib.php
29.94
KB
-rw-r--r--
2017-01-23 20:20
create_addfield.lib.php
15.68
KB
-rw-r--r--
2017-01-23 20:20
database_interface.inc.php
2.63
KB
-rw-r--r--
2017-01-23 20:20
db_common.inc.php
3.12
KB
-rw-r--r--
2017-01-23 20:20
db_designer.lib.php
10.4
KB
-rw-r--r--
2020-10-23 14:39
db_table_exists.lib.php
3.21
KB
-rw-r--r--
2017-01-23 20:20
display_change_password.lib.php
5.45
KB
-rw-r--r--
2017-01-23 20:20
display_create_table.lib.php
1.53
KB
-rw-r--r--
2017-01-23 20:20
display_export.lib.php
38.11
KB
-rw-r--r--
2017-01-23 20:20
display_git_revision.lib.php
3.04
KB
-rw-r--r--
2020-10-23 14:39
display_import.lib.php
24.34
KB
-rw-r--r--
2017-01-23 20:20
display_import_ajax.lib.php
3.13
KB
-rw-r--r--
2017-01-23 20:20
display_select_lang.lib.php
2.36
KB
-rw-r--r--
2017-01-23 20:20
error.inc.php
1.21
KB
-rw-r--r--
2017-01-23 20:20
error_report.lib.php
10.25
KB
-rw-r--r--
2017-01-23 20:20
export.lib.php
35.16
KB
-rw-r--r--
2017-01-23 20:20
file_listing.lib.php
2.37
KB
-rw-r--r--
2017-01-23 20:20
iconv_wrapper.lib.php
3.88
KB
-rw-r--r--
2017-01-23 20:20
import.lib.php
50.64
KB
-rw-r--r--
2017-01-23 20:20
index.lib.php
1.37
KB
-rw-r--r--
2017-01-23 20:20
information_schema_relations.lib.php
10.95
KB
-rw-r--r--
2017-01-23 20:20
insert_edit.lib.php
112.79
KB
-rw-r--r--
2020-10-23 14:39
ip_allow_deny.lib.php
9.35
KB
-rw-r--r--
2017-01-23 20:20
js_escape.lib.php
4.43
KB
-rw-r--r--
2017-01-23 20:20
kanji-encoding.lib.php
4.46
KB
-rw-r--r--
2017-01-23 20:20
language_stats.inc.php
1.45
KB
-rw-r--r--
2017-01-23 20:20
logging.lib.php
521
B
-rw-r--r--
2017-01-23 20:20
mime.lib.php
704
B
-rw-r--r--
2017-01-23 20:20
mult_submits.inc.php
10.64
KB
-rw-r--r--
2017-01-23 20:20
mult_submits.lib.php
20.44
KB
-rw-r--r--
2017-01-23 20:20
mysql_charsets.inc.php
4.09
KB
-rw-r--r--
2017-01-23 20:20
mysql_charsets.lib.php
10.47
KB
-rw-r--r--
2017-01-23 20:20
mysql_relations.lib.php
5.12
KB
-rw-r--r--
2017-01-23 20:20
normalization.lib.php
33.98
KB
-rw-r--r--
2017-01-23 20:20
opendocument.lib.php
7.94
KB
-rw-r--r--
2017-01-23 20:20
operations.lib.php
73.64
KB
-rw-r--r--
2017-01-23 20:20
parse_analyze.lib.php
2.12
KB
-rw-r--r--
2017-01-23 20:20
plugin_interface.lib.php
19.69
KB
-rw-r--r--
2017-01-23 20:20
pmd_common.php
24.2
KB
-rw-r--r--
2020-10-23 14:39
relation.lib.php
68.41
KB
-rw-r--r--
2017-01-23 20:20
relation_cleanup.lib.php
13.84
KB
-rw-r--r--
2017-01-23 20:20
replication.inc.php
8.82
KB
-rw-r--r--
2017-01-23 20:20
replication_gui.lib.php
37.45
KB
-rw-r--r--
2017-01-23 20:20
sanitizing.lib.php
6.3
KB
-rw-r--r--
2017-01-23 20:20
select_server.lib.php
3.4
KB
-rw-r--r--
2017-01-23 20:20
server_common.inc.php
1.22
KB
-rw-r--r--
2017-01-23 20:20
server_common.lib.php
1.92
KB
-rw-r--r--
2017-01-23 20:20
server_privileges.lib.php
179.22
KB
-rw-r--r--
2020-10-23 14:39
server_status.lib.php
9.92
KB
-rw-r--r--
2017-01-23 20:20
server_status_advisor.lib.php
1.89
KB
-rw-r--r--
2017-01-23 20:20
server_status_monitor.lib.php
26.22
KB
-rw-r--r--
2017-01-23 20:20
server_status_processes.lib.php
9.57
KB
-rw-r--r--
2017-01-23 20:20
server_status_queries.lib.php
4.86
KB
-rw-r--r--
2017-01-23 20:20
server_status_variables.lib.php
28.95
KB
-rw-r--r--
2017-01-23 20:20
server_user_groups.lib.php
12.8
KB
-rw-r--r--
2017-01-23 20:20
server_users.lib.php
1.35
KB
-rw-r--r--
2017-01-23 20:20
session.inc.php
5.22
KB
-rw-r--r--
2017-01-23 20:20
session.lib.php
735
B
-rw-r--r--
2017-01-23 20:20
special_schema_links.lib.php
17.51
KB
-rw-r--r--
2017-01-23 20:20
sql.lib.php
77.51
KB
-rw-r--r--
2017-01-23 20:20
sql_query_form.lib.php
15.71
KB
-rw-r--r--
2017-01-23 20:20
string.lib.php
800
B
-rw-r--r--
2017-01-23 20:20
stringMb.lib.php
1.86
KB
-rw-r--r--
2017-01-23 20:20
stringNative.lib.php
6.82
KB
-rw-r--r--
2017-01-23 20:20
sysinfo.lib.php
1.34
KB
-rw-r--r--
2017-01-23 20:20
tbl_columns_definition_form.inc.php
13.55
KB
-rw-r--r--
2017-01-23 20:20
tbl_common.inc.php
1.3
KB
-rw-r--r--
2017-01-23 20:20
tbl_info.inc.php
3.54
KB
-rw-r--r--
2017-01-23 20:20
tbl_partition_definition.inc.php
5.55
KB
-rw-r--r--
2017-01-23 20:20
tracking.lib.php
54.93
KB
-rw-r--r--
2017-01-23 20:20
transformations.lib.php
14.63
KB
-rw-r--r--
2020-10-23 14:39
url_generating.lib.php
6.77
KB
-rw-r--r--
2017-01-23 20:20
user_preferences.inc.php
2.38
KB
-rw-r--r--
2017-01-23 20:20
user_preferences.lib.php
8.17
KB
-rw-r--r--
2017-01-23 20:20
util.lib.php
749
B
-rw-r--r--
2017-01-23 20:20
vendor_config.php
2.49
KB
-rw-r--r--
2020-10-23 14:39
zip_extension.lib.php
5.38
KB
-rw-r--r--
2017-01-23 20:20
Save
Rename
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * set of functions for tbl_create.php and tbl_addfield.php * * @package PhpMyAdmin */ use PMA\libraries\Table; /** * Transforms the radio button field_key into 4 arrays * * @return array An array of arrays which represents column keys for each index type */ function PMA_getIndexedColumns() { $field_cnt = count($_REQUEST['field_name']); $field_primary = json_decode($_REQUEST['primary_indexes'], true); $field_index = json_decode($_REQUEST['indexes'], true); $field_unique = json_decode($_REQUEST['unique_indexes'], true); $field_fulltext = json_decode($_REQUEST['fulltext_indexes'], true); $field_spatial = json_decode($_REQUEST['spatial_indexes'], true); return array( $field_cnt, $field_primary, $field_index, $field_unique, $field_fulltext, $field_spatial ); } /** * Initiate the column creation statement according to the table creation or * add columns to a existing table * * @param int $field_cnt number of columns * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return array $definitions An array of initial sql statements * according to the request */ function PMA_buildColumnCreationStatement( $field_cnt, $is_create_tbl = true ) { $definitions = array(); for ($i = 0; $i < $field_cnt; ++$i) { // '0' is also empty for php :-( if (empty($_REQUEST['field_name'][$i]) && $_REQUEST['field_name'][$i] != '0' ) { continue; } $definition = PMA_getStatementPrefix($is_create_tbl) . Table::generateFieldSpec( trim($_REQUEST['field_name'][$i]), $_REQUEST['field_type'][$i], $_REQUEST['field_length'][$i], $_REQUEST['field_attribute'][$i], isset($_REQUEST['field_collation'][$i]) ? $_REQUEST['field_collation'][$i] : '', isset($_REQUEST['field_null'][$i]) ? $_REQUEST['field_null'][$i] : 'NOT NULL', $_REQUEST['field_default_type'][$i], $_REQUEST['field_default_value'][$i], isset($_REQUEST['field_extra'][$i]) ? $_REQUEST['field_extra'][$i] : false, isset($_REQUEST['field_comments'][$i]) ? $_REQUEST['field_comments'][$i] : '', isset($_REQUEST['field_virtuality'][$i]) ? $_REQUEST['field_virtuality'][$i] : '', isset($_REQUEST['field_expression'][$i]) ? $_REQUEST['field_expression'][$i] : '' ); $definition .= PMA_setColumnCreationStatementSuffix($i, $is_create_tbl); $definitions[] = $definition; } // end for return $definitions; } /** * Set column creation suffix according to requested position of the new column * * @param int $current_field_num current column number * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string $sql_suffix suffix */ function PMA_setColumnCreationStatementSuffix($current_field_num, $is_create_tbl = true ) { // no suffix is needed if request is a table creation $sql_suffix = ' '; if ($is_create_tbl) { return $sql_suffix; } if ((string) $_REQUEST['field_where'] === 'last') { return $sql_suffix; } // Only the first field can be added somewhere other than at the end if ((int) $current_field_num === 0) { if ((string) $_REQUEST['field_where'] === 'first') { $sql_suffix .= ' FIRST'; } else { $sql_suffix .= ' AFTER ' . PMA\libraries\Util::backquote($_REQUEST['after_field']); } } else { $sql_suffix .= ' AFTER ' . PMA\libraries\Util::backquote( $_REQUEST['field_name'][$current_field_num - 1] ); } return $sql_suffix; } /** * Create relevant index statements * * @param array $index an array of index columns * @param string $index_choice index choice that which represents * the index type of $indexed_fields * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return array an array of sql statements for indexes */ function PMA_buildIndexStatements($index, $index_choice, $is_create_tbl = true ) { $statement = array(); if (!count($index)) { return $statement; } $sql_query = PMA_getStatementPrefix($is_create_tbl) . ' ' . $index_choice; if (! empty($index['Key_name']) && $index['Key_name'] != 'PRIMARY') { $sql_query .= ' ' . PMA\libraries\Util::backquote($index['Key_name']); } $index_fields = array(); foreach ($index['columns'] as $key => $column) { $index_fields[$key] = PMA\libraries\Util::backquote( $_REQUEST['field_name'][$column['col_index']] ); if ($column['size']) { $index_fields[$key] .= '(' . $column['size'] . ')'; } } // end while $sql_query .= ' (' . implode(', ', $index_fields) . ')'; $keyBlockSizes = $index['Key_block_size']; if (! empty($keyBlockSizes)) { $sql_query .= " KEY_BLOCK_SIZE = " . $GLOBALS['dbi']->escapeString($keyBlockSizes); } // specifying index type is allowed only for primary, unique and index only $type = $index['Index_type']; if ($index['Index_choice'] != 'SPATIAL' && $index['Index_choice'] != 'FULLTEXT' && in_array($type, PMA\libraries\Index::getIndexTypes()) ) { $sql_query .= ' USING ' . $type; } $parser = $index['Parser']; if ($index['Index_choice'] == 'FULLTEXT' && ! empty($parser)) { $sql_query .= " WITH PARSER " . $GLOBALS['dbi']->escapeString($parser); } $comment = $index['Index_comment']; if (! empty($comment)) { $sql_query .= " COMMENT '" . $GLOBALS['dbi']->escapeString($comment) . "'"; } $statement[] = $sql_query; return $statement; } /** * Statement prefix for the PMA_buildColumnCreationStatement() * * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string $sql_prefix prefix */ function PMA_getStatementPrefix($is_create_tbl = true) { $sql_prefix = " "; if (! $is_create_tbl) { $sql_prefix = ' ADD '; } return $sql_prefix; } /** * Merge index definitions for one type of index * * @param array $definitions the index definitions to merge to * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * @param array $indexed_columns the columns for one type of index * @param string $index_keyword the index keyword to use in the definition * * @return array $index_definitions */ function PMA_mergeIndexStatements( $definitions, $is_create_tbl, $indexed_columns, $index_keyword ) { foreach ($indexed_columns as $index) { $statements = PMA_buildIndexStatements( $index, " " . $index_keyword . " ", $is_create_tbl ); $definitions = array_merge($definitions, $statements); } return $definitions; } /** * Returns sql statement according to the column and index specifications as * requested * * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string sql statement */ function PMA_getColumnCreationStatements($is_create_tbl = true) { $sql_statement = ""; list($field_cnt, $field_primary, $field_index, $field_unique, $field_fulltext, $field_spatial ) = PMA_getIndexedColumns(); $definitions = PMA_buildColumnCreationStatement( $field_cnt, $is_create_tbl ); // Builds the PRIMARY KEY statements $primary_key_statements = PMA_buildIndexStatements( isset($field_primary[0]) ? $field_primary[0] : array(), " PRIMARY KEY ", $is_create_tbl ); $definitions = array_merge($definitions, $primary_key_statements); // Builds the INDEX statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_index, "INDEX" ); // Builds the UNIQUE statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_unique, "UNIQUE" ); // Builds the FULLTEXT statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_fulltext, "FULLTEXT" ); // Builds the SPATIAL statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_spatial, "SPATIAL" ); if (count($definitions)) { $sql_statement = implode(', ', $definitions); } $sql_statement = preg_replace('@, $@', '', $sql_statement); return $sql_statement; } /** * Returns the partitioning clause * * @return string partitioning clause */ function PMA_getPartitionsDefinition() { $sql_query = ""; if (! empty($_REQUEST['partition_by']) && ! empty($_REQUEST['partition_expr']) && ! empty($_REQUEST['partition_count']) && $_REQUEST['partition_count'] > 1 ) { $sql_query .= " PARTITION BY " . $_REQUEST['partition_by'] . " (" . $_REQUEST['partition_expr'] . ")" . " PARTITIONS " . $_REQUEST['partition_count']; } if (! empty($_REQUEST['subpartition_by']) && ! empty($_REQUEST['subpartition_expr']) && ! empty($_REQUEST['subpartition_count']) && $_REQUEST['subpartition_count'] > 1 ) { $sql_query .= " SUBPARTITION BY " . $_REQUEST['subpartition_by'] . " (" . $_REQUEST['subpartition_expr'] . ")" . " SUBPARTITIONS " . $_REQUEST['subpartition_count']; } if (! empty($_REQUEST['partitions'])) { $i = 0; $partitions = array(); foreach ($_REQUEST['partitions'] as $partition) { $partitions[] = PMA_getPartitionDefinition($partition); $i++; } $sql_query .= " (" . implode(", ", $partitions) . ")"; } return $sql_query; } /** * Returns the definition of a partition/subpartition * * @param array $partition array of partition/subpartition detiails * @param boolean $isSubPartition whether a subpartition * * @return string partition/subpartition definition */ function PMA_getPartitionDefinition($partition, $isSubPartition = false) { $sql_query = " " . ($isSubPartition ? "SUB" : "") . "PARTITION "; $sql_query .= $partition['name']; if (! empty($partition['value_type'])) { $sql_query .= " VALUES " . $partition['value_type']; if ($partition['value_type'] != 'LESS THAN MAXVALUE') { $sql_query .= " (" . $partition['value'] . ")"; } } if (! empty($partition['engine'])) { $sql_query .= " ENGINE = " . $partition['engine']; } if (! empty($partition['comment'])) { $sql_query .= " COMMENT = '" . $partition['comment'] . "'"; } if (! empty($partition['data_directory'])) { $sql_query .= " DATA DIRECTORY = '" . $partition['data_directory'] . "'"; } if (! empty($partition['index_directory'])) { $sql_query .= " INDEX_DIRECTORY = '" . $partition['index_directory'] . "'"; } if (! empty($partition['max_rows'])) { $sql_query .= " MAX_ROWS = " . $partition['max_rows']; } if (! empty($partition['min_rows'])) { $sql_query .= " MIN_ROWS = " . $partition['min_rows']; } if (! empty($partition['tablespace'])) { $sql_query .= " TABLESPACE = " . $partition['tablespace']; } if (! empty($partition['node_group'])) { $sql_query .= " NODEGROUP = " . $partition['node_group']; } if (! empty($partition['subpartitions'])) { $j = 0; $subpartitions = array(); foreach ($partition['subpartitions'] as $subpartition) { $subpartitions[] = PMA_getPartitionDefinition( $subpartition, true ); $j++; } $sql_query .= " (" . implode(", ", $subpartitions) . ")"; } return $sql_query; } /** * Function to get table creation sql query * * @param string $db database name * @param string $table table name * * @return string */ function PMA_getTableCreationQuery($db, $table) { // get column addition statements $sql_statement = PMA_getColumnCreationStatements(true); // Builds the 'create table' statement $sql_query = 'CREATE TABLE ' . PMA\libraries\Util::backquote($db) . '.' . PMA\libraries\Util::backquote(trim($table)) . ' (' . $sql_statement . ')'; // Adds table type, character set, comments and partition definition if (!empty($_REQUEST['tbl_storage_engine']) && ($_REQUEST['tbl_storage_engine'] != 'Default') ) { $sql_query .= ' ENGINE = ' . $_REQUEST['tbl_storage_engine']; } if (!empty($_REQUEST['tbl_collation'])) { $sql_query .= PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']); } if (! empty($_REQUEST['connection']) && ! empty($_REQUEST['tbl_storage_engine']) && $_REQUEST['tbl_storage_engine'] == 'FEDERATED' ) { $sql_query .= " CONNECTION = '" . $GLOBALS['dbi']->escapeString($_REQUEST['connection']) . "'"; } if (!empty($_REQUEST['comment'])) { $sql_query .= ' COMMENT = \'' . $GLOBALS['dbi']->escapeString($_REQUEST['comment']) . '\''; } $sql_query .= PMA_getPartitionsDefinition(); $sql_query .= ';'; return $sql_query; } /** * Function to get the number of fields for the table creation form * * @return int */ function PMA_getNumberOfFieldsFromRequest() { if (isset($_REQUEST['submit_num_fields'])) { // adding new fields $num_fields = min( 4096, intval($_REQUEST['orig_num_fields']) + intval($_REQUEST['added_fields']) ); } elseif (isset($_REQUEST['orig_num_fields'])) { // retaining existing fields $num_fields = min(4096, intval($_REQUEST['orig_num_fields'])); } elseif (isset($_REQUEST['num_fields']) && intval($_REQUEST['num_fields']) > 0 ) { // new table with specified number of fields $num_fields = min(4096, intval($_REQUEST['num_fields'])); } else { // new table with unspecified number of fields $num_fields = 4; } return $num_fields; } /** * Function to execute the column creation statement * * @param string $db current database * @param string $table current table * @param string $err_url error page url * * @return array */ function PMA_tryColumnCreationQuery($db, $table, $err_url) { // get column addition statements $sql_statement = PMA_getColumnCreationStatements(false); // To allow replication, we first select the db to use and then run queries // on this db. if (!($GLOBALS['dbi']->selectDb($db))) { PMA\libraries\Util::mysqlDie( $GLOBALS['dbi']->getError(), 'USE ' . PMA\libraries\Util::backquote($db), false, $err_url ); } $sql_query = 'ALTER TABLE ' . PMA\libraries\Util::backquote($table) . ' ' . $sql_statement . ';'; // If there is a request for SQL previewing. if (isset($_REQUEST['preview_sql'])) { PMA_previewSQL($sql_query); } return array($GLOBALS['dbi']->tryQuery($sql_query) , $sql_query); }