<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Set of functions related to designer * * @package PhpMyAdmin */ use PMA\libraries\Message; use PMA\libraries\plugins\SchemaPlugin; if (! defined('PHPMYADMIN')) { exit; } require_once 'libraries/relation.lib.php'; /** * Function to get html to display a page selector * * @param array $cfgRelation information about the configuration storage * @param string $db database name * * @return string html content */ function PMA_getHtmlForPageSelector($cfgRelation, $db) { return PMA\libraries\Template::get('database/designer/page_selector') ->render( array( 'db' => $db, 'cfgRelation' => $cfgRelation ) ); } /** * Function to get html for displaying the page edit/delete form * * @param string $db database name * @param string $operation 'edit' or 'delete' depending on the operation * * @return string html content */ function PMA_getHtmlForEditOrDeletePages($db, $operation) { return PMA\libraries\Template::get('database/designer/edit_delete_pages') ->render( array( 'db' => $db, 'operation' => $operation ) ); } /** * Function to get html for displaying the page save as form * * @param string $db database name * * @return string html content */ function PMA_getHtmlForPageSaveAs($db) { return PMA\libraries\Template::get('database/designer/page_save_as') ->render( array( 'db' => $db ) ); } /** * Retrieve IDs and names of schema pages * * @param string $db database name * * @return array array of schema page id and names */ function PMA_getPageIdsAndNames($db) { $cfgRelation = PMA_getRelationsParam(); $page_query = "SELECT `page_nr`, `page_descr` FROM " . PMA\libraries\Util::backquote($cfgRelation['db']) . "." . PMA\libraries\Util::backquote($cfgRelation['pdf_pages']) . " WHERE db_name = '" . $GLOBALS['dbi']->escapeString($db) . "'" . " ORDER BY `page_descr`"; $page_rs = PMA_queryAsControlUser( $page_query, false, PMA\libraries\DatabaseInterface::QUERY_STORE ); $result = array(); while ($curr_page = $GLOBALS['dbi']->fetchAssoc($page_rs)) { $result[intval($curr_page['page_nr'])] = $curr_page['page_descr']; } return $result; } /** * Function to get html for displaying the schema export * * @param string $db database name * @param int $page the page to be exported * * @return string */ function PMA_getHtmlForSchemaExport($db, $page) { /* Scan for schema plugins */ /* @var $export_list SchemaPlugin[] */ $export_list = PMA_getPlugins( "schema", 'libraries/plugins/schema/', null ); /* Fail if we didn't find any schema plugin */ if (empty($export_list)) { return Message::error( __('Could not load schema plugins, please check your installation!') )->getDisplay(); } return PMA\libraries\Template::get('database/designer/schema_export') ->render( array( 'db' => $db, 'page' => $page, 'export_list' => $export_list ) ); } /** * Returns HTML for including some variable to be accessed by JavaScript * * @param array $script_tables array on foreign key support for each table * @param array $script_contr initialization data array * @param array $script_display_field display fields of each table * @param int $display_page page number of the selected page * * @return string html */ function PMA_getHtmlForJSFields( $script_tables, $script_contr, $script_display_field, $display_page ) { return PMA\libraries\Template::get('database/designer/js_fields') ->render( array( 'script_tables' => $script_tables, 'script_contr' => $script_contr, 'script_display_field' => $script_display_field, 'display_page' => $display_page ) ); } /** * Returns HTML for the menu bar of the designer page * * @param boolean $visualBuilder whether this is visual query builder * @param string $selected_page name of the selected page * @param array $params_array array with class name for various buttons on side * menu * * @return string html */ function PMA_getDesignerPageMenu($visualBuilder, $selected_page, $params_array) { return PMA\libraries\Template::get('database/designer/side_menu') ->render( array( 'visualBuilder' => $visualBuilder, 'selected_page' => $selected_page, 'params_array' => $params_array ) ); } /** * Returns array of stored values of Designer Settings * * @return array stored values */ function PMA_getSideMenuParamsArray() { $params = array(); $cfgRelation = PMA_getRelationsParam(); if ($GLOBALS['cfgRelation']['designersettingswork']) { $query = 'SELECT `settings_data` FROM ' . PMA\libraries\Util::backquote($cfgRelation['db']) . '.' . PMA\libraries\Util::backquote($cfgRelation['designer_settings']) . ' WHERE ' . PMA\libraries\Util::backquote('username') . ' = "' . $GLOBALS['dbi']->escapeString($GLOBALS['cfg']['Server']['user']) . '";'; $result = $GLOBALS['dbi']->fetchSingleRow($query); $params = json_decode($result['settings_data'], true); } return $params; } /** * Returns class names for various buttons on Designer Side Menu * * @return array class names of various buttons */ function PMA_returnClassNamesFromMenuButtons() { $classes_array = array(); $params_array = PMA_getSideMenuParamsArray(); if (isset($params_array['angular_direct']) && $params_array['angular_direct'] == 'angular' ) { $classes_array['angular_direct'] = 'M_butt_Selected_down'; } else { $classes_array['angular_direct'] = 'M_butt'; } if (isset($params_array['snap_to_grid']) && $params_array['snap_to_grid'] == 'on' ) { $classes_array['snap_to_grid'] = 'M_butt_Selected_down'; } else { $classes_array['snap_to_grid'] = 'M_butt'; } if (isset($params_array['pin_text']) && $params_array['pin_text'] == 'true' ) { $classes_array['pin_text'] = 'M_butt_Selected_down'; } else { $classes_array['pin_text'] = 'M_butt'; } if (isset($params_array['relation_lines']) && $params_array['relation_lines'] == 'false' ) { $classes_array['relation_lines'] = 'M_butt_Selected_down'; } else { $classes_array['relation_lines'] = 'M_butt'; } if (isset($params_array['small_big_all']) && $params_array['small_big_all'] == 'v' ) { $classes_array['small_big_all'] = 'M_butt_Selected_down'; } else { $classes_array['small_big_all'] = 'M_butt'; } if (isset($params_array['side_menu']) && $params_array['side_menu'] == 'true' ) { $classes_array['side_menu'] = 'M_butt_Selected_down'; } else { $classes_array['side_menu'] = 'M_butt'; } return $classes_array; } /** * Returns HTML for the canvas element * * @return string html */ function PMA_getHTMLCanvas() { return PMA\libraries\Template::get('database/designer/canvas')->render(); } /** * Return HTML for the table list * * @param array $tab_pos table positions * @param int $display_page page number of the selected page * * @return string html */ function PMA_getHTMLTableList($tab_pos, $display_page) { return PMA\libraries\Template::get('database/designer/table_list') ->render( array( 'tab_pos' => $tab_pos, 'display_page' => $display_page ) ); } /** * Get HTML to display tables on designer page * * @param array $tab_pos tables positions * @param int $display_page page number of the selected page * @param array $tab_column table column info * @param array $tables_all_keys all indices * @param array $tables_pk_or_unique_keys unique or primary indices * * @return string html */ function PMA_getDatabaseTables( $tab_pos, $display_page, $tab_column, $tables_all_keys, $tables_pk_or_unique_keys ) { return PMA\libraries\Template::get('database/designer/database_tables') ->render( array( 'tab_pos' => $tab_pos, 'display_page' => $display_page, 'tab_column' => $tab_column, 'tables_all_keys' => $tables_all_keys, 'tables_pk_or_unique_keys' => $tables_pk_or_unique_keys ) ); } /** * Returns HTML for the new relations panel. * * @return string html */ function PMA_getNewRelationPanel() { return PMA\libraries\Template::get('database/designer/new_relation_panel') ->render(); } /** * Returns HTML for the relations delete panel * * @return string html */ function PMA_getDeleteRelationPanel() { return PMA\libraries\Template::get('database/designer/delete_relation_panel') ->render(); } /** * Returns HTML for the options panel * * @return string html */ function PMA_getOptionsPanel() { return PMA\libraries\Template::get('database/designer/options_panel')->render(); } /** * Get HTML for the 'rename to' panel * * @return string html */ function PMA_getRenameToPanel() { return PMA\libraries\Template::get('database/designer/rename_to_panel') ->render(); } /** * Returns HTML for the 'having' panel * * @return string html */ function PMA_getHavingQueryPanel() { return PMA\libraries\Template::get('database/designer/having_query_panel') ->render(); } /** * Returns HTML for the 'aggregate' panel * * @return string html */ function PMA_getAggregateQueryPanel() { return PMA\libraries\Template::get('database/designer/aggregate_query_panel') ->render(); } /** * Returns HTML for the 'where' panel * * @return string html */ function PMA_getWhereQueryPanel() { return PMA\libraries\Template::get('database/designer/where_query_panel') ->render(); } /** * Returns HTML for the query details panel * * @return string html */ function PMA_getQueryDetails() { return PMA\libraries\Template::get('database/designer/query_details')->render(); }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bfShapeFiles | Folder | 0755 |
|
|
config | Folder | 0755 |
|
|
controllers | Folder | 0755 |
|
|
dbi | Folder | 0755 |
|
|
di | Folder | 0755 |
|
|
engines | Folder | 0755 |
|
|
gis | Folder | 0755 |
|
|
navigation | Folder | 0755 |
|
|
plugins | Folder | 0755 |
|
|
properties | Folder | 0755 |
|
|
rte | Folder | 0755 |
|
|
sql-parser | Folder | 0755 |
|
|
Advisor.php | File | 15.13 KB | 0644 |
|
Config.php | File | 54.7 KB | 0644 |
|
Console.php | File | 14.82 KB | 0644 |
|
DatabaseInterface.php | File | 95.6 KB | 0644 |
|
DbList.php | File | 1.9 KB | 0644 |
|
DbQbe.php | File | 68.87 KB | 0644 |
|
DbSearch.php | File | 17.21 KB | 0644 |
|
DisplayResults.php | File | 206 KB | 0644 |
|
Error.php | File | 12.7 KB | 0644 |
|
ErrorHandler.php | File | 16.48 KB | 0644 |
|
File.php | File | 18.82 KB | 0644 |
|
Font.php | File | 4.24 KB | 0644 |
|
Footer.php | File | 10.52 KB | 0644 |
|
Header.php | File | 25.34 KB | 0644 |
|
Index.php | File | 23.79 KB | 0644 |
|
IndexColumn.php | File | 4.46 KB | 0644 |
|
Language.php | File | 4.27 KB | 0644 |
|
LanguageManager.php | File | 20.75 KB | 0644 |
|
Linter.php | File | 5.02 KB | 0644 |
|
ListAbstract.php | File | 3.15 KB | 0644 |
|
ListDatabase.php | File | 4.62 KB | 0644 |
|
Menu.php | File | 21.14 KB | 0644 |
|
Message.php | File | 18.67 KB | 0644 |
|
OutputBuffering.php | File | 3.59 KB | 0644 |
|
PDF.php | File | 3.94 KB | 0644 |
|
Partition.php | File | 7.26 KB | 0644 |
|
Psr4Autoloader.php | File | 4.85 KB | 0644 |
|
RecentFavoriteTable.php | File | 11.78 KB | 0644 |
|
Response.php | File | 12.61 KB | 0644 |
|
SavedSearches.php | File | 11.67 KB | 0644 |
|
Scripts.php | File | 7.38 KB | 0644 |
|
ServerStatusData.php | File | 15.72 KB | 0644 |
|
StorageEngine.php | File | 13.61 KB | 0644 |
|
SubPartition.php | File | 3.52 KB | 0644 |
|
SysInfo.php | File | 799 B | 0644 |
|
SysInfoLinux.php | File | 1.92 KB | 0644 |
|
SysInfoSunOS.php | File | 1.86 KB | 0644 |
|
SysInfoWINNT.php | File | 3.08 KB | 0644 |
|
SystemDatabase.php | File | 3.66 KB | 0644 |
|
Table.php | File | 88.12 KB | 0644 |
|
Template.php | File | 4.45 KB | 0644 |
|
Theme.php | File | 11.34 KB | 0644 |
|
ThemeManager.php | File | 12.91 KB | 0644 |
|
Tracker.php | File | 30.35 KB | 0644 |
|
Types.php | File | 6.08 KB | 0644 |
|
TypesMySQL.php | File | 17.26 KB | 0644 |
|
Util.php | File | 172.46 KB | 0644 |
|
VersionInformation.php | File | 7.87 KB | 0644 |
|
ZipFile.php | File | 6.63 KB | 0644 |
|
advisor.lib.php | File | 1.6 KB | 0644 |
|
advisory_rules.txt | File | 25.94 KB | 0644 |
|
autoloader.php | File | 450 B | 0644 |
|
bookmark.lib.php | File | 8.5 KB | 0644 |
|
browse_foreigners.lib.php | File | 9.83 KB | 0644 |
|
central_columns.lib.php | File | 49.38 KB | 0644 |
|
charset_conversion.lib.php | File | 3.54 KB | 0644 |
|
check_user_privileges.lib.php | File | 10.65 KB | 0644 |
|
cleanup.lib.php | File | 1.29 KB | 0644 |
|
common.inc.php | File | 34.38 KB | 0644 |
|
config.default.php | File | 66.5 KB | 0644 |
|
config.values.php | File | 10.17 KB | 0644 |
|
core.lib.php | File | 29.94 KB | 0644 |
|
create_addfield.lib.php | File | 15.68 KB | 0644 |
|
database_interface.inc.php | File | 2.63 KB | 0644 |
|
db_common.inc.php | File | 3.12 KB | 0644 |
|
db_designer.lib.php | File | 10.4 KB | 0644 |
|
db_table_exists.lib.php | File | 3.21 KB | 0644 |
|
display_change_password.lib.php | File | 5.45 KB | 0644 |
|
display_create_table.lib.php | File | 1.53 KB | 0644 |
|
display_export.lib.php | File | 38.11 KB | 0644 |
|
display_git_revision.lib.php | File | 3.04 KB | 0644 |
|
display_import.lib.php | File | 24.34 KB | 0644 |
|
display_import_ajax.lib.php | File | 3.13 KB | 0644 |
|
display_select_lang.lib.php | File | 2.36 KB | 0644 |
|
error.inc.php | File | 1.21 KB | 0644 |
|
error_report.lib.php | File | 10.25 KB | 0644 |
|
export.lib.php | File | 35.16 KB | 0644 |
|
file_listing.lib.php | File | 2.37 KB | 0644 |
|
iconv_wrapper.lib.php | File | 3.88 KB | 0644 |
|
import.lib.php | File | 50.64 KB | 0644 |
|
index.lib.php | File | 1.37 KB | 0644 |
|
information_schema_relations.lib.php | File | 10.95 KB | 0644 |
|
insert_edit.lib.php | File | 112.79 KB | 0644 |
|
ip_allow_deny.lib.php | File | 9.35 KB | 0644 |
|
js_escape.lib.php | File | 4.43 KB | 0644 |
|
kanji-encoding.lib.php | File | 4.46 KB | 0644 |
|
language_stats.inc.php | File | 1.45 KB | 0644 |
|
logging.lib.php | File | 521 B | 0644 |
|
mime.lib.php | File | 704 B | 0644 |
|
mult_submits.inc.php | File | 10.64 KB | 0644 |
|
mult_submits.lib.php | File | 20.44 KB | 0644 |
|
mysql_charsets.inc.php | File | 4.09 KB | 0644 |
|
mysql_charsets.lib.php | File | 10.47 KB | 0644 |
|
mysql_relations.lib.php | File | 5.12 KB | 0644 |
|
normalization.lib.php | File | 33.98 KB | 0644 |
|
opendocument.lib.php | File | 7.94 KB | 0644 |
|
operations.lib.php | File | 73.64 KB | 0644 |
|
parse_analyze.lib.php | File | 2.12 KB | 0644 |
|
plugin_interface.lib.php | File | 19.69 KB | 0644 |
|
plugin_interface.lib.php.bak | File | 19.69 KB | 0644 |
|
pmd_common.php | File | 24.2 KB | 0644 |
|
relation.lib.php | File | 68.41 KB | 0644 |
|
relation_cleanup.lib.php | File | 13.84 KB | 0644 |
|
replication.inc.php | File | 8.82 KB | 0644 |
|
replication_gui.lib.php | File | 37.45 KB | 0644 |
|
sanitizing.lib.php | File | 6.3 KB | 0644 |
|
select_server.lib.php | File | 3.4 KB | 0644 |
|
server_common.inc.php | File | 1.22 KB | 0644 |
|
server_common.lib.php | File | 1.92 KB | 0644 |
|
server_privileges.lib.php | File | 179.22 KB | 0644 |
|
server_status.lib.php | File | 9.92 KB | 0644 |
|
server_status_advisor.lib.php | File | 1.89 KB | 0644 |
|
server_status_monitor.lib.php | File | 26.22 KB | 0644 |
|
server_status_processes.lib.php | File | 9.57 KB | 0644 |
|
server_status_queries.lib.php | File | 4.86 KB | 0644 |
|
server_status_variables.lib.php | File | 28.95 KB | 0644 |
|
server_user_groups.lib.php | File | 12.8 KB | 0644 |
|
server_users.lib.php | File | 1.35 KB | 0644 |
|
session.inc.php | File | 5.22 KB | 0644 |
|
session.lib.php | File | 735 B | 0644 |
|
special_schema_links.lib.php | File | 17.51 KB | 0644 |
|
sql.lib.php | File | 77.51 KB | 0644 |
|
sql.lib.php.bak | File | 77.51 KB | 0644 |
|
sql_query_form.lib.php | File | 15.71 KB | 0644 |
|
string.lib.php | File | 800 B | 0644 |
|
stringMb.lib.php | File | 1.86 KB | 0644 |
|
stringNative.lib.php | File | 6.82 KB | 0644 |
|
sysinfo.lib.php | File | 1.34 KB | 0644 |
|
tbl_columns_definition_form.inc.php | File | 13.55 KB | 0644 |
|
tbl_common.inc.php | File | 1.3 KB | 0644 |
|
tbl_info.inc.php | File | 3.54 KB | 0644 |
|
tbl_partition_definition.inc.php | File | 5.55 KB | 0644 |
|
tracking.lib.php | File | 54.93 KB | 0644 |
|
transformations.lib.php | File | 14.63 KB | 0644 |
|
url_generating.lib.php | File | 6.77 KB | 0644 |
|
user_preferences.inc.php | File | 2.38 KB | 0644 |
|
user_preferences.lib.php | File | 8.17 KB | 0644 |
|
util.lib.php | File | 749 B | 0644 |
|
vendor_config.php | File | 2.49 KB | 0644 |
|
zip_extension.lib.php | File | 5.38 KB | 0644 |
|