diff --git a/htdocs/sql/pmd_common.php b/htdocs/sql/pmd_common.php deleted file mode 100755 --- a/htdocs/sql/pmd_common.php +++ /dev/null @@ -1,326 +0,0 @@ -' . "\n" . - '// ' . "\n" . - '' . "\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 "
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 "
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 = - '' . "\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 = - '' . "\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(); -?>