phpmyadmin/pmd_common.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * @author  Ivan A Kirillov (Ivan.A.Kirillov@gmail.com)
   5  * @version $Id$
   6  * @package phpMyAdmin-Designer
   7  */
   8
   9 /**
  10  *
  11  */
  12 require_once './libraries/common.inc.php';
  13 // not understand
  14 require_once './libraries/header_http.inc.php';
  15
  16 $GLOBALS['PMD']['STYLE']          = 'default';
  17
  18 require_once './libraries/relation.lib.php';
  19 $cfgRelation = PMA_getRelationsParam();
  20
  21 $GLOBALS['script_display_field'] =
  22     '<script type="text/javascript">' . "\n" .
  23     '// <![CDATA[' . "\n" .
  24     'var display_field = new Array();' . "\n";
  25
  26 /**
  27  * retrieves table info and stores it in $GLOBALS['PMD']
  28  *
  29  * @uses    $GLOBALS['script_display_field']
  30  * @uses    $GLOBALS['PMD'] to fill it
  31  * @uses    $GLOBALS['db']
  32  * @uses    PMA_DBI_get_tables_full()
  33  * @uses    PMA_DBI_select_db()
  34  * @uses    PMA_getDisplayField()
  35  * @uses    urlencode()
  36  * @uses    htmlspecialchars()
  37  * @uses    strtoupper()
  38  * @uses    urlencode()
  39  */
  40 function get_tabs()
  41 {
  42     $GLOBALS['PMD']['TABLE_NAME'] = array();// that foreach no error
  43     $GLOBALS['PMD']['OWNER'] = array();
  44     $GLOBALS['PMD']['TABLE_NAME_SMALL'] = array();
  45
  46     $tables = PMA_DBI_get_tables_full($GLOBALS['db']);
  47     // seems to be needed later
  48     PMA_DBI_select_db($GLOBALS['db']);
  49     $i = 0;
  50     foreach ($tables as $one_table) {
  51         $GLOBALS['PMD']['TABLE_NAME'][$i] = $GLOBALS['db'] . "." . $one_table['TABLE_NAME'];
  52         $GLOBALS['PMD']['OWNER'][$i] = $GLOBALS['db'];
  53         $GLOBALS['PMD']['TABLE_NAME_SMALL'][$i] = $one_table['TABLE_NAME'];
  54
  55         $GLOBALS['PMD_URL']['TABLE_NAME'][$i] = urlencode($GLOBALS['db'] . "." . $one_table['TABLE_NAME']);
  56         $GLOBALS['PMD_URL']['OWNER'][$i] = urlencode($GLOBALS['db']);
  57         $GLOBALS['PMD_URL']['TABLE_NAME_SMALL'][$i] = urlencode($one_table['TABLE_NAME']);
  58
  59         $GLOBALS['PMD_OUT']['TABLE_NAME'][$i] = htmlspecialchars($GLOBALS['db'] . "." . $one_table['TABLE_NAME'], ENT_QUOTES);
  60         $GLOBALS['PMD_OUT']['OWNER'][$i] = htmlspecialchars($GLOBALS['db'], ENT_QUOTES);
  61         $GLOBALS['PMD_OUT']['TABLE_NAME_SMALL'][$i] = htmlspecialchars($one_table['TABLE_NAME'], ENT_QUOTES);
  62
  63         $GLOBALS['PMD']['TABLE_TYPE'][$i] = strtoupper($one_table['ENGINE']);
  64
  65         $DF = PMA_getDisplayField($GLOBALS['db'], $one_table['TABLE_NAME']);
  66         if ($DF != '') {
  67             $GLOBALS['script_display_field'] .= "  display_field['"
  68                 . $GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i] . "'] = '"
  69                 . urlencode($DF) . "';\n";
  70         }
  71
  72         $i++;
  73     }
  74     $GLOBALS['script_display_field'] .=
  75         '// ]]>' . "\n" .
  76         '</script>' . "\n";
  77     //  return $GLOBALS['PMD'];       // many bases // not use ??????
  78 }
  79
  80 /**
  81  * retrieves table column info
  82  *
  83  * @uses    $GLOBALS['db']
  84  * @uses    PMA_DBI_QUERY_STORE
  85  * @uses    PMA_DBI_select_db()
  86  * @uses    PMA_DBI_query()
  87  * @uses    PMA_DBI_num_rows()
  88  * @uses    PMA_backquote()
  89  * @uses    count()
  90  * @return  array   table column nfo
  91  */
  92 function get_tab_info()
  93 {
  94     PMA_DBI_select_db($GLOBALS['db']);
  95     $tab_column = array();
  96     for ($i = 0; $i < count($GLOBALS['PMD']["TABLE_NAME"]); $i++) {
  97         $fields_rs   = PMA_DBI_query('SHOW FULL FIELDS FROM '.PMA_backquote($GLOBALS['PMD']["TABLE_NAME_SMALL"][$i]), NULL, PMA_DBI_QUERY_STORE);
  98         $j = 0;
  99         while ($row = PMA_DBI_fetch_assoc($fields_rs)) {
 100             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_ID'][$j]   = $j;
 101             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['COLUMN_NAME'][$j] = $row['Field'];
 102             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['TYPE'][$j]        = $row['Type'];
 103             $tab_column[$GLOBALS['PMD']['TABLE_NAME'][$i]]['NULLABLE'][$j]    = $row['Null'];
 104             $j++;
 105         }
 106     }
 107     return $tab_column;
 108 }
 109
 110 /**
 111  * returns JavaScript code for intializing vars
 112  *
 113  * @uses    $GLOBALS['db']
 114  * @uses    PMA_DBI_QUERY_STORE
 115  * @uses    PMA_DBI_select_db()
 116  * @uses    PMA_DBI_query()
 117  * @uses    PMA_backquote()
 118  * @uses    PMA_DBI_fetch_row()
 119  * @uses    PMA_getForeigners()
 120  * @uses    urlencode()
 121  * @uses    count()
 122  * @uses    in_array()
 123  * @return string   JavaScript code
 124  */
 125 function get_script_contr()
 126 {
 127     PMA_DBI_select_db($GLOBALS['db']);
 128     $con["C_NAME"] = array();
 129     $i = 0;
 130     $alltab_rs  = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($GLOBALS['db']), NULL, PMA_DBI_QUERY_STORE);
 131     while ($val = @PMA_DBI_fetch_row($alltab_rs)) {
 132         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'internal');
 133         //echo "<br> internal ".$GLOBALS['db']." - ".$val[0]." - ";
 134         //print_r($row);
 135         if ($row !== false) {
 136             foreach ($row as $field => $value) {
 137                 $con['C_NAME'][$i] = '';
 138                 $con['DTN'][$i]    = urlencode($GLOBALS['db'] . "." . $val[0]);
 139                 $con['DCN'][$i]    = urlencode($field);
 140                 $con['STN'][$i]    = urlencode($value['foreign_db'] . "." . $value['foreign_table']);
 141                 $con['SCN'][$i]    = urlencode($value['foreign_field']);
 142                 $i++;
 143             }
 144         }
 145         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'innodb');
 146         //echo "<br> INNO ";
 147         //print_r($row);
 148         if ($row !== false) {
 149             foreach ($row as $field => $value) {
 150                 $con['C_NAME'][$i] = '';
 151                 $con['DTN'][$i]    = urlencode($GLOBALS['db'].".".$val[0]);
 152                 $con['DCN'][$i]    = urlencode($field);
 153                 $con['STN'][$i]    = urlencode($value['foreign_db'].".".$value['foreign_table']);
 154                 $con['SCN'][$i]    = urlencode($value['foreign_field']);
 155                 $i++;
 156             }
 157         }
 158     }
 159
 160     $ti = 0;
 161     $script_contr =
 162         '<script type="text/javascript">' . "\n" .
 163         '// <![CDATA[' . "\n" .
 164         'var contr = new Array();' . "\n";
 165     for ($i = 0; $i < count($con["C_NAME"]); $i++) {
 166         $js_var = ' contr[' . $ti . ']';
 167         $script_contr .= $js_var . " = new Array();\n";
 168         $js_var .= "['" . $con['C_NAME'][$i] . "']";
 169         $script_contr .= $js_var . " = new Array();\n";
 170         if (in_array($con['DTN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])
 171          && in_array($con['STN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])) {
 172             $js_var .= "['" . $con['DTN'][$i] . "']";
 173             $script_contr .= $js_var . " = new Array();\n";
 174             $m_col = array();//}
 175             $js_var .= "['" . $con['DCN'][$i] . "']";
 176             $script_contr .= $js_var . " = new Array();\n";//}
 177             $script_contr .= $js_var . "[0] = '" . $con['STN'][$i] . "';\n"; //
 178             $script_contr .= $js_var . "[1] = '" . $con['SCN'][$i] . "';\n"; //
 179         }
 180         $ti++;
 181     }
 182     $script_contr .=
 183         '// ]]>' . "\n" .
 184         '</script>' . "\n";
 185     return $script_contr;
 186 }
 187
 188 /**
 189  * @uses    $GLOBALS['db']
 190  * @uses    $GLOBALS['PMD']
 191  * @uses    PMA_DBI_select_db()
 192  * @uses    PMA_get_indexes()
 193  * @uses    PMA_extract_indexes()
 194  * @uses    count()
 195  * @return  array unique or primary indizes
 196  */
 197 function get_pk_or_unique_keys()
 198 {
 199     require_once './libraries/tbl_indexes.lib.php';
 200
 201     PMA_DBI_select_db($GLOBALS['db']);
 202     $tables_pk_or_unique_keys = array();
 203
 204     for ($I = 0; $I < count($GLOBALS['PMD']['TABLE_NAME_SMALL']); $I++) {
 205         $ret_keys = PMA_get_indexes($GLOBALS['PMD']['TABLE_NAME_SMALL'][$I]);
 206         if (! empty($ret_keys)) {
 207             // reset those as the function uses them by reference
 208             $indexes = $indexes_info = $indexes_data = array();
 209             PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data);
 210             // for now, take into account only the first index segment
 211             foreach ($indexes_data as $key_name => $one_index) {
 212                 $column_name = $one_index[1]['Column_name'];
 213                 if (isset($indexes_info[$key_name])
 214                  && $indexes_info[$key_name]['Non_unique'] == 0) {
 215                     $tables_pk_or_unique_keys[$GLOBALS['PMD']['OWNER'][$I] . '.' .$GLOBALS['PMD']['TABLE_NAME_SMALL'][$I] . '.' . $column_name] = 1;
 216                 }
 217             }
 218         }
 219     }
 220     return $tables_pk_or_unique_keys;
 221 }
 222
 223 /**
 224  * returns all indizes
 225  *
 226  * @uses    $GLOBALS['db']
 227  * @uses    $GLOBALS['PMD']
 228  * @uses    PMA_DBI_select_db()
 229  * @uses    PMA_get_indexes()
 230  * @uses    PMA_extract_indexes()
 231  * @uses    count()
 232  * @return  array indizes
 233  */
 234 function get_all_keys()
 235 {
 236     require_once './libraries/tbl_indexes.lib.php';
 237
 238     PMA_DBI_select_db($GLOBALS['db']);
 239     $tables_all_keys = array();
 240
 241     for ($I = 0; $I < count($GLOBALS['PMD']['TABLE_NAME_SMALL']); $I++) {
 242         $ret_keys = PMA_get_indexes($GLOBALS['PMD']['TABLE_NAME_SMALL'][$I]);
 243         if (! empty($ret_keys)) {
 244             // reset those as the function uses them by reference
 245             $indexes = $indexes_info = $indexes_data = array();
 246             PMA_extract_indexes($ret_keys, $indexes, $indexes_info, $indexes_data);
 247             // for now, take into account only the first index segment
 248             foreach ($indexes_data as $one_index) {
 249                 $column_name = $one_index[1]['Column_name'];
 250                 $tables_all_keys[$GLOBALS['PMD']['OWNER'][$I] . '.' .$GLOBALS['PMD']['TABLE_NAME_SMALL'][$I] . '.' . $column_name] = 1;
 251             }
 252         }
 253     }
 254     return $tables_all_keys;
 255 }
 256
 257 /**
 258  *
 259  *
 260  * @uses    $GLOBALS['PMD']
 261  * @uses    count()
 262  * @uses    in_array()
 263  * @return  array   ???
 264  */
 265 function get_script_tabs()
 266 {
 267     $script_tabs =
 268         '<script type="text/javascript">' . "\n" .
 269         '// <![CDATA[' . "\n" .
 270         'var j_tabs = new Array();' . "\n";
 271     for ($i = 0; $i < count($GLOBALS['PMD']['TABLE_NAME']); $i++) {
 272         $script_tabs .= "j_tabs['" . $GLOBALS['PMD_URL']['TABLE_NAME'][$i] . "'] = '"
 273             . $GLOBALS['PMD']['TABLE_TYPE'][$i] . "';\n";
 274     }
 275     $script_tabs .=
 276         '// ]]>' . "\n" .
 277         '</script>' . "\n";
 278     return $script_tabs;
 279 }
 280
 281 /**
 282  * @uses    $GLOBALS['controllink']
 283  * @uses    $cfgRelation['designerwork']
 284  * @uses    $cfgRelation['db']
 285  * @uses    $cfgRelation['designer_coords']
 286  * @uses    PMA_DBI_QUERY_STORE
 287  * @uses    PMA_getRelationsParam()
 288  * @uses    PMA_backquote()
 289  * @uses    PMA_DBI_fetch_result()
 290  * @uses    count()
 291  * @return  array   table positions and sizes
 292  */
 293 function get_tab_pos()
 294 {
 295     $cfgRelation = PMA_getRelationsParam();
 296
 297     if (! $cfgRelation['designerwork']) {
 298         return null;
 299     }
 300
 301     $query = "
 302          SELECT CONCAT_WS('.', `db_name`, `table_name`) AS `name`,
 303                 `x` AS `X`,
 304                 `y` AS `Y`,
 305                 `v` AS `V`,
 306                 `h` AS `H`
 307            FROM " . PMA_backquote($cfgRelation['db']) . "." . PMA_backquote($cfgRelation['designer_coords']);
 308     $tab_pos = PMA_DBI_fetch_result($query, 'name', null, $GLOBALS['controllink'], PMA_DBI_QUERY_STORE);
 309     return count($tab_pos) ? $tab_pos : null;
 310 }
 311
 312 /**
 313  * returns  distinct values from $GLOBALS['PMD']['OWNER']
 314  *
 315  * @uses    array_values()
 316  * @uses    array_unique()
 317  * @uses    $GLOBALS['PMD']['OWNER']
 318  * @return  array   owner
 319  */
 320 function get_owners()
 321 {
 322     return array_values(array_unique($GLOBALS['PMD']['OWNER']));
 323 }
 324
 325 get_tabs();
 326 ?>