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

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

Имя файла	pmd_common.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * @author Ivan A Kirillov (Ivan.A.Kirillov@gmail.com) * @version $Id$ * @package phpMyAdmin-Designer / /* * / require_once './libraries/common.inc.php'; // not understand require_once './libraries/header_http.inc.php'; $GLOBALS['PMD']['STYLE'] = 'default'; require_once './libraries/relation.lib.php'; $cfgRelation = PMA_getRelationsParam(); $GLOBALS['script_display_field'] = '<script type="text/javascript">' . "\n" . '// <![CDATA[' . "\n" . 'var display_field = new Array();' . "\n"; /* * retrieves table info and stores it in $GLOBALS['PMD'] * * @uses $GLOBALS['script_display_field'] * @uses $GLOBALS['PMD'] to fill it * @uses $GLOBALS['db'] * @uses PMA_DBI_get_tables_full() * @uses PMA_DBI_select_db() * @uses PMA_getDisplayField() * @uses urlencode() * @uses htmlspecialchars() * @uses strtoupper() * @uses urlencode() / function get_tabs() { $GLOBALS['PMD']['TABLE_NAME'] = array();// that foreach no error $GLOBALS['PMD']['OWNER'] = array(); $GLOBALS['PMD']['TABLE_NAME_SMALL'] = array(); $tables = PMA_DBI_get_tables_full($GLOBALS['db']); // seems to be needed later PMA_DBI_select_db($GLOBALS['db']); $i = 0; foreach ($tables as $one_table) { $GLOBALS['PMD']['TABLE_NAME'][$i] = $GLOBALS['db'] . "." . $one_table['TABLE_NAME']; $GLOBALS['PMD']['OWNER'][$i] = $GLOBALS['db']; $GLOBALS['PMD']['TABLE_NAME_SMALL'][$i] = $one_table['TABLE_NAME']; $GLOBALS['PMD_URL']['TABLE_NAME'][$i] = urlencode($GLOBALS['db'] . "." . $one_table['TABLE_NAME']); $GLOBALS['PMD_URL']['OWNER'][$i] = urlencode($GLOBALS['db']); $GLOBALS['PMD_URL']['TABLE_NAME_SMALL'][$i] = urlencode($one_table['TABLE_NAME']); $GLOBALS['PMD_OUT']['TABLE_NAME'][$i] = htmlspecialchars($GLOBALS['db'] . "." . $one_table['TABLE_NAME'], ENT_QUOTES); $GLOBALS['PMD_OUT']['OWNER'][$i] = htmlspecialchars($GLOBALS['db'], ENT_QUOTES); $GLOBALS['PMD_OUT']['TABLE_NAME_SMALL'][$i] = htmlspecialchars($one_table['TABLE_NAME'], ENT_QUOTES); $GLOBALS['PMD']['TABLE_TYPE'][$i] = strtoupper($one_table['ENGINE']); $DF = PMA_getDisplayField($GLOBALS['db'], $one_table['TABLE_NAME']); if ($DF != '') { $GLOBALS['script_display_field'] .= " display_field['" . $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . "'] = '" . urlencode($DF) . "';\n"; } $i++; } $GLOBALS['script_display_field'] .= '// ]]>' . "\n" . '</script>' . "\n"; // return $GLOBALS['PMD']; // many bases // not use ?????? } /* * retrieves table column info * * @uses $GLOBALS['db'] * @uses PMA_DBI_QUERY_STORE * @uses PMA_DBI_select_db() * @uses PMA_DBI_query() * @uses PMA_DBI_num_rows() * @uses PMA_backquote() * @uses count() * @return array table column nfo / function get_tab_info() { PMA_DBI_select_db($GLOBALS['db']); $tab_column = array(); for ($i = 0; $i < count($GLOBALS['PMD']["TABLE_NAME"]); $i++) { $fields_rs = PMA_DBI_query('SHOW FULL FIELDS FROM '.PMA_backquote($GLOBALS['PMD']["TABLE_NAME_SMALL"][$i]), NULL, PMA_DBI_QUERY_STORE); $j = 0; while ($row = PMA_DBI_fetch_assoc($fields_rs)) { $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_ID'][$j] = $j; $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_NAME'][$j] = $row['Field']; $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['TYPE'][$j] = $row['Type']; $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['NULLABLE'][$j] = $row['Null']; $j++; } } return $tab_column; } /* * returns JavaScript code for intializing vars * * @uses $GLOBALS['db'] * @uses PMA_DBI_QUERY_STORE * @uses PMA_DBI_select_db() * @uses PMA_DBI_query() * @uses PMA_backquote() * @uses PMA_DBI_fetch_row() * @uses PMA_getForeigners() * @uses urlencode() * @uses count() * @uses in_array() * @return string JavaScript code / function get_script_contr() { PMA_DBI_select_db($GLOBALS['db']); $con["C_NAME"] = array(); $i = 0; $alltab_rs = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($GLOBALS['db']), NULL, PMA_DBI_QUERY_STORE); while ($val = @PMA_DBI_fetch_row($alltab_rs)) { $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'internal'); //echo "<br> internal ".$GLOBALS['db']." - ".$val[0]." - "; //print_r($row); if ($row !== false) { foreach ($row as $field => $value) { $con['C_NAME'][$i] = ''; $con['DTN'][$i] = urlencode($GLOBALS['db'] . "." . $val[0]); $con['DCN'][$i] = urlencode($field); $con['STN'][$i] = urlencode($value['foreign_db'] . "." . $value['foreign_table']); $con['SCN'][$i] = urlencode($value['foreign_field']); $i++; } } $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'innodb'); //echo "<br> INNO "; //print_r($row); if ($row !== false) { foreach ($row as $field => $value) { $con['C_NAME'][$i] = ''; $con['DTN'][$i] = urlencode($GLOBALS['db'].".".$val[0]); $con['DCN'][$i] = urlencode($field); $con['STN'][$i] = urlencode($value['foreign_db'].".".$value['foreign_table']); $con['SCN'][$i] = urlencode($value['foreign_field']); $i++; } } } $ti = 0; $script_contr = '<script type="text/javascript">' . "\n" . '// <![CDATA[' . "\n" . 'var contr = new Array();' . "\n"; for ($i = 0; $i < count($con["C_NAME"]); $i++) { $js_var = ' contr[' . $ti . ']'; $script_contr .= $js_var . " = new Array();\n"; $js_var .= "['" . $con['C_NAME'][$i] . "']"; $script_contr .= $js_var . " = new Array();\n"; if (in_array($con['DTN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"]) && in_array($con['STN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])) { $js_var .= "['" . $con['DTN'][$i] . "']"; $script_contr .= $js_var . " = new Array();\n"; $m_col = array();//} $js_var .= "['" . $con['DCN'][$i] . "']"; $script_contr .= $js_var . " = new Array();\n";//} $script_contr .= $js_var . "[0] = '" . $con['STN'][$i] . "';\n"; // $script_contr .= $js_var . "[1] = '" . $con['SCN'][$i] . "';\n"; // } $ti++; } $script_contr .= '// ]]>' . "\n" . '</script>' . "\n"; return $script_contr; } /* * @uses $GLOBALS['db'] * @uses $GLOBALS['PMD'] * @uses PMA_DBI_select_db() * @uses PMA_get_indexes() * @uses PMA_extract_indexes() * @uses count() * @return array unique or primary indizes / function get_pk_or_unique_keys() { require_once './libraries/tbl_indexes.lib.php'; PMA_DBI_select_db($GLOBALS['db']); $tables_pk_or_unique_keys = array(); for ($I = 0; $I < count($GLOBALS['PMD']['TABLE_NAME_SMALL']); $I++) { $ret_keys = PMA_get_indexes($GLOBALS['PMD']['TABLE_NAME_SMALL'][$I]); if (! empty($ret_keys)) { // reset those as the function uses them by reference $indexes = $indexes_info = $indexes_data = array(); PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data); // for now, take into account only the first index segment foreach ($indexes_data as $key_name => $one_index) { $column_name = $one_index[1]['Column_name']; if (isset($indexes_info[$key_name]) && $indexes_info[$key_name]['Non_unique'] == 0) { $tables_pk_or_unique_keys[$GLOBALS['PMD']['OWNER'][$I] . '.' .$GLOBALS['PMD']['TABLE_NAME_SMALL'][$I] . '.' . $column_name] = 1; } } } } return $tables_pk_or_unique_keys; } /* * returns all indizes * * @uses $GLOBALS['db'] * @uses $GLOBALS['PMD'] * @uses PMA_DBI_select_db() * @uses PMA_get_indexes() * @uses PMA_extract_indexes() * @uses count() * @return array indizes / function get_all_keys() { require_once './libraries/tbl_indexes.lib.php'; PMA_DBI_select_db($GLOBALS['db']); $tables_all_keys = array(); for ($I = 0; $I < count($GLOBALS['PMD']['TABLE_NAME_SMALL']); $I++) { $ret_keys = PMA_get_indexes($GLOBALS['PMD']['TABLE_NAME_SMALL'][$I]); if (! empty($ret_keys)) { // reset those as the function uses them by reference $indexes = $indexes_info = $indexes_data = array(); PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data); // for now, take into account only the first index segment foreach ($indexes_data as $one_index) { $column_name = $one_index[1]['Column_name']; $tables_all_keys[$GLOBALS['PMD']['OWNER'][$I] . '.' .$GLOBALS['PMD']['TABLE_NAME_SMALL'][$I] . '.' . $column_name] = 1; } } } return $tables_all_keys; } /* * * * @uses $GLOBALS['PMD'] * @uses count() * @uses in_array() * @return array ??? / function get_script_tabs() { $script_tabs = '<script type="text/javascript">' . "\n" . '// <![CDATA[' . "\n" . 'var j_tabs = new Array();' . "\n"; for ($i = 0; $i < count($GLOBALS['PMD']['TABLE_NAME']); $i++) { $script_tabs .= "j_tabs['" . $GLOBALS['PMD_URL']['TABLE_NAME'][$i] . "'] = '" . $GLOBALS['PMD']['TABLE_TYPE'][$i] . "';\n"; } $script_tabs .= '// ]]>' . "\n" . '</script>' . "\n"; return $script_tabs; } /* * @uses $GLOBALS['controllink'] * @uses $cfgRelation['designerwork'] * @uses $cfgRelation['db'] * @uses $cfgRelation['designer_coords'] * @uses PMA_DBI_QUERY_STORE * @uses PMA_getRelationsParam() * @uses PMA_backquote() * @uses PMA_DBI_fetch_result() * @uses count() * @return array table positions and sizes / function get_tab_pos() { $cfgRelation = PMA_getRelationsParam(); if (! $cfgRelation['designerwork']) { return null; } $query = " SELECT CONCAT_WS('.', `db_name`, `table_name`) AS `name`, `x` AS `X`, `y` AS `Y`, `v` AS `V`, `h` AS `H` FROM " . PMA_backquote($cfgRelation['db']) . "." . PMA_backquote($cfgRelation['designer_coords']); $tab_pos = PMA_DBI_fetch_result($query, 'name', null, $GLOBALS['controllink'], PMA_DBI_QUERY_STORE); return count($tab_pos) ? $tab_pos : null; } /* * returns distinct values from $GLOBALS['PMD']['OWNER'] * * @uses array_values() * @uses array_unique() * @uses $GLOBALS['PMD']['OWNER'] * @return array owner */ function get_owners() { return array_values(array_unique($GLOBALS['PMD']['OWNER'])); } get_tabs(); ?>

/admin/myadmin2/

Имя	Дата	Размер
..	2026-10-02
contrib	2013-06-28
js	2013-06-28
lang	2013-06-28
libraries	2015-04-04
pmd	2013-06-28
scripts	2013-06-28
themes	2013-06-28
CREDITS	2013-06-28	127 байт
ChangeLog	2013-06-28	32 кб.
Documentation.html	2013-06-28	218 кб.
Documentation.txt	2013-06-28	154 кб.
INSTALL	2013-06-28	137 байт
LICENSE	2013-06-28	18 кб.
README	2013-06-28	3 кб.
RELEASE-DATE-2.11.11.3	2013-06-28	29 байт
TODO	2013-06-28	196 байт
browse_foreigners.php	2013-06-28	11 кб.
calendar.php	2013-06-28	711 байт
changelog.php	2013-06-28	4 кб.
chk_rel.php	2013-06-28	410 байт
config.inc.php	2013-06-28	2 кб.
config.sample.inc.php	2013-06-28	2 кб.
db_create.php	2013-06-28	1 кб.
db_datadict.php	2013-06-28	10 кб.
db_export.php	2013-06-28	2 кб.
db_import.php	2013-06-28	419 байт
db_operations.php	2013-06-28	19 кб.
db_printview.php	2013-06-28	7 кб.
db_qbe.php	2013-06-28	34 кб.
db_search.php	2013-06-28	14 кб.
db_sql.php	2013-06-28	972 байт
db_structure.php	2013-06-28	22 кб.
docs.css	2013-06-28	4 кб.
error.php	2013-06-28	2 кб.
export.php	2013-06-28	24 кб.
favicon.ico	2013-06-28	18 кб.
import.php	2013-06-28	14 кб.
index.php	2013-06-28	6 кб.
license.php	2013-06-28	618 байт
main.php	2013-06-28	15 кб.
navigation.php	2013-06-28	26 кб.
pdf_pages.php	2013-06-28	27 кб.
pdf_schema.php	2013-06-28	51 кб.
phpinfo.php	2013-06-28	310 байт
phpmyadmin.css.php	2013-06-28	16 кб.
pmd_common.php	2013-06-28	11 кб.
pmd_display_field.php	2013-06-28	2 кб.
pmd_general.php	2013-06-28	18 кб.
pmd_help.php	2013-06-28	829 байт
pmd_pdf.php	2013-06-28	3 кб.
pmd_relation_new.php	2013-06-28	4 кб.
pmd_relation_upd.php	2013-06-28	2 кб.
pmd_save_pos.php	2013-06-28	2 кб.
print.css	2013-06-28	1 кб.
querywindow.php	2013-06-28	9 кб.
readme.php	2013-06-28	610 байт
server_binlog.php	2013-06-28	7 кб.
server_collations.php	2013-06-28	3 кб.
server_databases.php	2013-06-28	13 кб.
server_engines.php	2013-06-28	5 кб.
server_export.php	2013-06-28	2 кб.
server_import.php	2013-06-28	430 байт
server_privileges.php	2013-06-28	108 кб.
server_processlist.php	2013-06-28	3 кб.
server_sql.php	2013-06-28	528 байт
server_status.php	2013-06-28	20 кб.
server_variables.php	2013-06-28	2 кб.
show_config_errors.php	2013-06-28	256 байт
sql.php	2013-06-28	29 кб.
tbl_addfield.php	2013-06-28	9 кб.
tbl_alter.php	2013-06-28	9 кб.
tbl_change.php	2013-06-28	45 кб.
tbl_create.php	2013-06-28	9 кб.
tbl_export.php	2013-06-28	2 кб.
tbl_import.php	2013-06-28	582 байт
tbl_indexes.php	2013-06-28	16 кб.
tbl_move_copy.php	2013-06-28	2 кб.
tbl_operations.php	2013-06-28	19 кб.
tbl_printview.php	2013-06-28	18 кб.
tbl_relation.php	2013-06-28	24 кб.
tbl_replace.php	2013-06-28	12 кб.
tbl_row_action.php	2013-06-28	4 кб.
tbl_select.php	2013-06-28	17 кб.
tbl_sql.php	2013-06-28	911 байт
tbl_structure.php	2013-06-28	34 кб.
themes.php	2013-06-28	1 кб.
transformation_overview.php	2013-06-28	2 кб.
transformation_wrapper.php	2013-06-28	4 кб.
translators.html	2013-06-28	8 кб.
user_password.php	2013-06-28	3 кб.
view_create.php	2013-06-28	4 кб.

/admin/myadmin2