phpmyadmin/libraries/pmd_common.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Common functions for Designer
   5  *
   6  * @package PhpMyAdmin-Designer
   7  */
   8 /**
   9  * Block attempts to directly run this script
  10  */
  11 if (! defined('PHPMYADMIN')) {
  12     exit;
  13 }
  14
  15 $GLOBALS['PMD']['STYLE']          = 'default';
  16
  17 $cfgRelation = PMA_getRelationsParam();
  18
  19 /**
  20  * Retrieves table info and stores it in $GLOBALS['PMD']
  21  *
  22  * @return array with table info
  23  */
  24 function PMA_getTablesInfo()
  25 {
  26     $retval = array();
  27
  28     $GLOBALS['PMD']['TABLE_NAME'] = array();// that foreach no error
  29     $GLOBALS['PMD']['OWNER'] = array();
  30     $GLOBALS['PMD']['TABLE_NAME_SMALL'] = array();
  31
  32     $tables = $GLOBALS['dbi']->getTablesFull($GLOBALS['db']);
  33     // seems to be needed later
  34     $GLOBALS['dbi']->selectDb($GLOBALS['db']);
  35     $i = 0;
  36     foreach ($tables as $one_table) {
  37         $GLOBALS['PMD']['TABLE_NAME'][$i]
  38             = $GLOBALS['db'] . "." . $one_table['TABLE_NAME'];
  39         $GLOBALS['PMD']['OWNER'][$i] = $GLOBALS['db'];
  40         $GLOBALS['PMD']['TABLE_NAME_SMALL'][$i] = $one_table['TABLE_NAME'];
  41
  42         $GLOBALS['PMD_URL']['TABLE_NAME'][$i]
  43             = urlencode($GLOBALS['db'] . "." . $one_table['TABLE_NAME']);
  44         $GLOBALS['PMD_URL']['OWNER'][$i] = urlencode($GLOBALS['db']);
  45         $GLOBALS['PMD_URL']['TABLE_NAME_SMALL'][$i]
  46             = urlencode($one_table['TABLE_NAME']);
  47
  48         $GLOBALS['PMD_OUT']['TABLE_NAME'][$i] = htmlspecialchars(
  49             $GLOBALS['db'] . "." . $one_table['TABLE_NAME'], ENT_QUOTES
  50         );
  51         $GLOBALS['PMD_OUT']['OWNER'][$i] = htmlspecialchars(
  52             $GLOBALS['db'], ENT_QUOTES
  53         );
  54         $GLOBALS['PMD_OUT']['TABLE_NAME_SMALL'][$i] = htmlspecialchars(
  55             $one_table['TABLE_NAME'], ENT_QUOTES
  56         );
  57
  58         $GLOBALS['PMD']['TABLE_TYPE'][$i] = /*overload*/mb_strtoupper(
  59             $one_table['ENGINE']
  60         );
  61
  62         $DF = PMA_getDisplayField($GLOBALS['db'], $one_table['TABLE_NAME']);
  63         if ($DF != '') {
  64             $retval[$GLOBALS['PMD_URL']["TABLE_NAME_SMALL"][$i]] = urlencode($DF);
  65         }
  66
  67         $i++;
  68     }
  69
  70     return $retval;
  71 }
  72
  73 /**
  74  * Retrieves table column info
  75  *
  76  * @return array   table column nfo
  77  */
  78 function PMA_getColumnsInfo()
  79 {
  80     $GLOBALS['dbi']->selectDb($GLOBALS['db']);
  81     $tab_column = array();
  82     for ($i = 0, $cnt = count($GLOBALS['PMD']["TABLE_NAME"]); $i < $cnt; $i++) {
  83         $fields_rs = $GLOBALS['dbi']->query(
  84             $GLOBALS['dbi']->getColumnsSql(
  85                 $GLOBALS['db'],
  86                 $GLOBALS['PMD']["TABLE_NAME_SMALL"][$i],
  87                 null,
  88                 true
  89             ),
  90             null,
  91             PMA_DatabaseInterface::QUERY_STORE
  92         );
  93         $tbl_name_i = $GLOBALS['PMD']['TABLE_NAME'][$i];
  94         $j = 0;
  95         while ($row = $GLOBALS['dbi']->fetchAssoc($fields_rs)) {
  96             $tab_column[$tbl_name_i]['COLUMN_ID'][$j]   = $j;
  97             $tab_column[$tbl_name_i]['COLUMN_NAME'][$j] = $row['Field'];
  98             $tab_column[$tbl_name_i]['TYPE'][$j]        = $row['Type'];
  99             $tab_column[$tbl_name_i]['NULLABLE'][$j]    = $row['Null'];
 100             $j++;
 101         }
 102     }
 103     return $tab_column;
 104 }
 105
 106 /**
 107  * Returns JavaScript code for initializing vars
 108  *
 109  * @return string   JavaScript code
 110  */
 111 function PMA_getScriptContr()
 112 {
 113     $GLOBALS['dbi']->selectDb($GLOBALS['db']);
 114     $con = array();
 115     $con["C_NAME"] = array();
 116     $i = 0;
 117     $alltab_rs = $GLOBALS['dbi']->query(
 118         'SHOW TABLES FROM ' . PMA_Util::backquote($GLOBALS['db']),
 119         null,
 120         PMA_DatabaseInterface::QUERY_STORE
 121     );
 122     while ($val = @$GLOBALS['dbi']->fetchRow($alltab_rs)) {
 123         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'internal');
 124         //echo "<br> internal ".$GLOBALS['db']." - ".$val[0]." - ";
 125         //print_r($row);
 126         if ($row !== false) {
 127             foreach ($row as $field => $value) {
 128                 $con['C_NAME'][$i] = '';
 129                 $con['DTN'][$i]    = urlencode($GLOBALS['db'] . "." . $val[0]);
 130                 $con['DCN'][$i]    = urlencode($field);
 131                 $con['STN'][$i]    = urlencode(
 132                     $value['foreign_db'] . "." . $value['foreign_table']
 133                 );
 134                 $con['SCN'][$i]    = urlencode($value['foreign_field']);
 135                 $i++;
 136             }
 137         }
 138         $row = PMA_getForeigners($GLOBALS['db'], $val[0], '', 'foreign');
 139         //echo "<br> INNO ";
 140         //print_r($row);
 141         if ($row !== false) {
 142             foreach ($row['foreign_keys_data'] as $one_key) {
 143                 foreach ($one_key['index_list'] as $index => $one_field) {
 144                     $con['C_NAME'][$i] = '';
 145                     $con['DTN'][$i]    = urlencode($GLOBALS['db'] . "." . $val[0]);
 146                     $con['DCN'][$i]    = urlencode($one_field);
 147                     $con['STN'][$i]    = urlencode(
 148                         (isset($one_key['ref_db_name']) ?
 149                             $one_key['ref_db_name'] : $GLOBALS['db'])
 150                         . "." . $one_key['ref_table_name']
 151                     );
 152                     $con['SCN'][$i] = urlencode($one_key['ref_index_list'][$index]);
 153                     $i++;
 154                 }
 155             }
 156         }
 157     }
 158
 159     $ti = 0;
 160     $retval = array();
 161     for ($i = 0, $cnt = count($con["C_NAME"]); $i < $cnt; $i++) {
 162         $c_name_i = $con['C_NAME'][$i];
 163         $dtn_i = $con['DTN'][$i];
 164         $retval[$ti] = array();
 165         $retval[$ti][$c_name_i] = array();
 166         if (in_array($dtn_i, $GLOBALS['PMD_URL']["TABLE_NAME"])
 167             && in_array($con['STN'][$i], $GLOBALS['PMD_URL']["TABLE_NAME"])
 168         ) {
 169             $retval[$ti][$c_name_i][$dtn_i] = array();
 170             $retval[$ti][$c_name_i][$dtn_i][$con['DCN'][$i]] = array(
 171                 0 => $con['STN'][$i],
 172                 1 => $con['SCN'][$i]
 173             );
 174         }
 175         $ti++;
 176     }
 177     return $retval;
 178 }
 179
 180 /**
 181  * Returns UNIQUE and PRIMARY indices
 182  *
 183  * @return array unique or primary indices
 184  */
 185 function PMA_getPKOrUniqueKeys()
 186 {
 187     return PMA_getAllKeys(true);
 188 }
 189
 190 /**
 191  * Returns all indices
 192  *
 193  * @param bool $unique_only whether to include only unique ones
 194  *
 195  * @return array indices
 196  */
 197 function PMA_getAllKeys($unique_only = false)
 198 {
 199     include_once './libraries/Index.class.php';
 200
 201     $keys = array();
 202
 203     foreach ($GLOBALS['PMD']['TABLE_NAME_SMALL'] as $I => $table) {
 204         $schema = $GLOBALS['PMD']['OWNER'][$I];
 205         // for now, take into account only the first index segment
 206         foreach (PMA_Index::getFromTable($table, $schema) as $index) {
 207             if ($unique_only && ! $index->isUnique()) {
 208                 continue;
 209             }
 210             $columns = $index->getColumns();
 211             foreach ($columns as $column_name => $dummy) {
 212                 $keys[$schema . '.' . $table . '.' . $column_name] = 1;
 213             }
 214         }
 215     }
 216     return $keys;
 217 }
 218
 219 /**
 220  * Return script to create j_tab and h_tab arrays
 221  *
 222  * @return string
 223  */
 224 function PMA_getScriptTabs()
 225 {
 226     $retval = array(
 227         'j_tabs' => array(),
 228         'h_tabs' => array()
 229     );
 230
 231     for ($i = 0, $cnt = count($GLOBALS['PMD']['TABLE_NAME']); $i < $cnt; $i++) {
 232         $j = 0;
 233         if (PMA_Util::isForeignKeySupported($GLOBALS['PMD']['TABLE_TYPE'][$i])) {
 234             $j = 1;
 235         }
 236         $retval['j_tabs'][$GLOBALS['PMD_URL']['TABLE_NAME'][$i]] = $j;
 237         $retval['h_tabs'][$GLOBALS['PMD_URL']['TABLE_NAME'][$i]] = 1;
 238     }
 239     return $retval;
 240 }
 241
 242 /**
 243  * Returns table positions of a given pdf page
 244  *
 245  * @param int $pg pdf page id
 246  *
 247  * @return array of table positions
 248  */
 249 function PMA_getTablePositions($pg)
 250 {
 251     $cfgRelation = PMA_getRelationsParam();
 252     if (! $cfgRelation['pdfwork']) {
 253         return null;
 254     }
 255
 256     $query = "
 257         SELECT CONCAT_WS('.', `db_name`, `table_name`) AS `name`,
 258             `x` AS `X`,
 259             `y` AS `Y`,
 260             1 AS `V`,
 261             1 AS `H`
 262         FROM " . PMA_Util::backquote($cfgRelation['db'])
 263             . "." . PMA_Util::backquote($cfgRelation['table_coords']) . "
 264         WHERE pdf_page_number = " . $pg;
 265
 266     $tab_pos = $GLOBALS['dbi']->fetchResult(
 267         $query,
 268         'name',
 269         null,
 270         $GLOBALS['controllink'],
 271         PMA_DatabaseInterface::QUERY_STORE
 272     );
 273     return $tab_pos;
 274 }
 275
 276 /**
 277  * Returns page name of a given pdf page
 278  *
 279  * @param int $pg pdf page id
 280  *
 281  * @return String table name
 282  */
 283 function PMA_getPageName($pg)
 284 {
 285     $cfgRelation = PMA_getRelationsParam();
 286     if (! $cfgRelation['pdfwork']) {
 287         return null;
 288     }
 289
 290     $query = "SELECT `page_descr`"
 291         . " FROM " . PMA_Util::backquote($cfgRelation['db'])
 292         . "." . PMA_Util::backquote($cfgRelation['pdf_pages'])
 293         . " WHERE " . PMA_Util::backquote('page_nr') . " = " . $pg;
 294     $page_name = $GLOBALS['dbi']->fetchResult(
 295         $query,
 296         null,
 297         null,
 298         $GLOBALS['controllink'],
 299         PMA_DatabaseInterface::QUERY_STORE
 300     );
 301     return count($page_name) ? $page_name[0] : null;
 302 }
 303
 304 /**
 305  * Deletes a given pdf page and its corresponding coordinates
 306  *
 307  * @param int $pg page id
 308  *
 309  * @return boolean success/failure
 310  */
 311 function PMA_deletePage($pg)
 312 {
 313     $cfgRelation = PMA_getRelationsParam();
 314     if (! $cfgRelation['pdfwork']) {
 315         return false;
 316     }
 317
 318     $query = "DELETE FROM " . PMA_Util::backquote($cfgRelation['db'])
 319              . "." . PMA_Util::backquote($cfgRelation['table_coords'])
 320              . " WHERE " . PMA_Util::backquote('pdf_page_number') . " = " . $pg;
 321     $success = PMA_queryAsControlUser(
 322         $query, true, PMA_DatabaseInterface::QUERY_STORE
 323     );
 324
 325     if ($success) {
 326         $query = "DELETE FROM " . PMA_Util::backquote($cfgRelation['db'])
 327                  . "." . PMA_Util::backquote($cfgRelation['pdf_pages'])
 328                  . " WHERE " . PMA_Util::backquote('page_nr') . " = " . $pg;
 329         $success = PMA_queryAsControlUser(
 330             $query, true, PMA_DatabaseInterface::QUERY_STORE
 331         );
 332     }
 333
 334     return (boolean) $success;
 335 }
 336
 337 /**
 338  * Returns the id of the default pdf page of the database.
 339  * Default page is the one which has the same name as the database.
 340  *
 341  * @param string $db database
 342  *
 343  * @return int id of the default pdf page for the database
 344  */
 345 function PMA_getDefaultPage($db)
 346 {
 347     $cfgRelation = PMA_getRelationsParam();
 348     if (! $cfgRelation['pdfwork']) {
 349         return null;
 350     }
 351
 352     $query = "SELECT `page_nr`"
 353         . " FROM " . PMA_Util::backquote($cfgRelation['db'])
 354         . "." . PMA_Util::backquote($cfgRelation['pdf_pages'])
 355         . " WHERE `db_name` = '" . PMA_Util::sqlAddSlashes($db) . "'"
 356         . " AND `page_descr` = '" .  PMA_Util::sqlAddSlashes($db) . "'";
 357
 358     $default_page_no = $GLOBALS['dbi']->fetchResult(
 359         $query,
 360         null,
 361         null,
 362         $GLOBALS['controllink'],
 363         PMA_DatabaseInterface::QUERY_STORE
 364     );
 365
 366     if (count($default_page_no)) {
 367         return $default_page_no[0];
 368     }
 369     return -1;
 370 }
 371
 372 /**
 373  * Get the id of the page to load. If a default page exists it will be returned.
 374  * If no such exists, returns the id of the first page of the database.
 375  *
 376  * @param string $db database
 377  *
 378  * @return int id of the page to load
 379  */
 380 function PMA_getLoadingPage($db)
 381 {
 382     $cfgRelation = PMA_getRelationsParam();
 383     if (! $cfgRelation['pdfwork']) {
 384         return null;
 385     }
 386
 387     $page_no = -1;
 388
 389     $default_page_no = PMA_getDefaultPage($db);
 390     if ($default_page_no != -1) {
 391         $page_no = $default_page_no;
 392     } else {
 393         $query = "SELECT MIN(`page_nr`)"
 394             . " FROM " . PMA_Util::backquote($cfgRelation['db'])
 395             . "." . PMA_Util::backquote($cfgRelation['pdf_pages'])
 396             . " WHERE `db_name` = '" . PMA_Util::sqlAddSlashes($db) . "'";
 397
 398         $min_page_no = $GLOBALS['dbi']->fetchResult(
 399             $query,
 400             null,
 401             null,
 402             $GLOBALS['controllink'],
 403             PMA_DatabaseInterface::QUERY_STORE
 404         );
 405         if (count($min_page_no[0])) {
 406             $page_no = $min_page_no[0];
 407         }
 408     }
 409     return $page_no;
 410 }
 411
 412 /**
 413  * Creates a new page and returns its auto-incrementing id
 414  *
 415  * @param string $pageName name of the page
 416  * @param string $db       name of the database
 417  *
 418  * @return int|null
 419  */
 420 function PMA_createNewPage($pageName, $db)
 421 {
 422     $cfgRelation = PMA_getRelationsParam();
 423     if ($cfgRelation['pdfwork']) {
 424         $pageNumber = PMA_REL_createPage(
 425             $pageName,
 426             $cfgRelation,
 427             $db
 428         );
 429         return $pageNumber;
 430     }
 431     return null;
 432 }
 433
 434 /**
 435  * Saves positions of table(s) of a given pdf page
 436  *
 437  * @param int $pg pdf page id
 438  *
 439  * @return boolean success/failure
 440  */
 441 function PMA_saveTablePositions($pg)
 442 {
 443     $cfgRelation = PMA_getRelationsParam();
 444     if (! $cfgRelation['pdfwork']) {
 445         return false;
 446     }
 447
 448     $query =  "DELETE FROM " . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
 449         . "." . PMA_Util::backquote($GLOBALS['cfgRelation']['table_coords'])
 450         . " WHERE `db_name` = '" . PMA_Util::sqlAddSlashes($_REQUEST['db']) . "'"
 451         . " AND `pdf_page_number` = '" . PMA_Util::sqlAddSlashes($pg) . "'";
 452
 453     $res = PMA_queryAsControlUser($query, true, PMA_DatabaseInterface::QUERY_STORE);
 454
 455     if ($res) {
 456         foreach ($_REQUEST['t_h'] as $key => $value) {
 457             list($DB, $TAB) = explode(".", $key);
 458             if ($value) {
 459                 $query = "INSERT INTO "
 460                     . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . "."
 461                     . PMA_Util::backquote($GLOBALS['cfgRelation']['table_coords'])
 462                     . " (`db_name`, `table_name`, `pdf_page_number`, `x`, `y`)"
 463                     . " VALUES ("
 464                     . "'" . PMA_Util::sqlAddSlashes($DB) . "', "
 465                     . "'" . PMA_Util::sqlAddSlashes($TAB) . "', "
 466                     . "'" . PMA_Util::sqlAddSlashes($pg) . "', "
 467                     . "'" . PMA_Util::sqlAddSlashes($_REQUEST['t_x'][$key]) . "', "
 468                     . "'" . PMA_Util::sqlAddSlashes($_REQUEST['t_y'][$key]) . "')";
 469
 470                 $res = PMA_queryAsControlUser(
 471                     $query,  true, PMA_DatabaseInterface::QUERY_STORE
 472                 );
 473             }
 474         }
 475     }
 476
 477     return (boolean) $res;
 478 }
 479
 480 /**
 481  * Saves the display field for a table.
 482  *
 483  * @param string $db    database name
 484  * @param string $table table name
 485  * @param string $field display field name
 486  *
 487  * @return boolean
 488  */
 489 function PMA_saveDisplayField($db, $table, $field)
 490 {
 491     $cfgRelation = PMA_getRelationsParam();
 492     if (!$cfgRelation['displaywork']) {
 493         return false;
 494     }
 495
 496     $disp = PMA_getDisplayField($db, $table);
 497     if ($disp && $disp === $field) {
 498         $field = '';
 499     }
 500
 501     $upd_query = new PMA_Table($table, $db, $GLOBALS['dbi']);
 502     $upd_query->updateDisplayField($disp, $field, $cfgRelation);
 503
 504     return true;
 505 }
 506
 507 /**
 508  * Adds a new foreign relation
 509  *
 510  * @param string $db        database name
 511  * @param string $T1        foreign table
 512  * @param string $F1        foreign field
 513  * @param string $T2        master table
 514  * @param string $F2        master field
 515  * @param string $on_delete on delete action
 516  * @param string $on_update on update action
 517  *
 518  * @return array array of success/failure and message
 519  */
 520 function PMA_addNewRelation($db, $T1, $F1, $T2, $F2, $on_delete, $on_update)
 521 {
 522     $tables = $GLOBALS['dbi']->getTablesFull($db, $T1);
 523     $type_T1 = /*overload*/mb_strtoupper($tables[$T1]['ENGINE']);
 524     $tables = $GLOBALS['dbi']->getTablesFull($db, $T2);
 525     $type_T2 = /*overload*/mb_strtoupper($tables[$T2]['ENGINE']);
 526
 527     // native foreign key
 528     if (PMA_Util::isForeignKeySupported($type_T1)
 529         && PMA_Util::isForeignKeySupported($type_T2)
 530         && $type_T1 == $type_T2
 531     ) {
 532         // relation exists?
 533         $existrel_foreign = PMA_getForeigners($db, $T2, '', 'foreign');
 534         $foreigner = PMA_searchColumnInForeigners($existrel_foreign, $F2);
 535         if ($foreigner
 536             && isset($foreigner['constraint'])
 537         ) {
 538             return array(false, __('Error: relation already exists.'));
 539         }
 540         // note: in InnoDB, the index does not requires to be on a PRIMARY
 541         // or UNIQUE key
 542         // improve: check all other requirements for InnoDB relations
 543         $result = $GLOBALS['dbi']->query(
 544             'SHOW INDEX FROM ' . PMA_Util::backquote($db)
 545             . '.' . PMA_Util::backquote($T1) . ';'
 546         );
 547
 548         // will be use to emphasis prim. keys in the table view
 549         $index_array1 = array();
 550         while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 551             $index_array1[$row['Column_name']] = 1;
 552         }
 553         $GLOBALS['dbi']->freeResult($result);
 554
 555         $result = $GLOBALS['dbi']->query(
 556             'SHOW INDEX FROM ' . PMA_Util::backquote($db)
 557             . '.' . PMA_Util::backquote($T2) . ';'
 558         );
 559         // will be used to emphasis prim. keys in the table view
 560         $index_array2 = array();
 561         while ($row = $GLOBALS['dbi']->fetchAssoc($result)) {
 562             $index_array2[$row['Column_name']] = 1;
 563         }
 564         $GLOBALS['dbi']->freeResult($result);
 565
 566         if (! empty($index_array1[$F1]) && ! empty($index_array2[$F2])) {
 567             $upd_query  = 'ALTER TABLE ' . PMA_Util::backquote($db)
 568                 . '.' . PMA_Util::backquote($T2)
 569                 . ' ADD FOREIGN KEY ('
 570                 . PMA_Util::backquote($F2) . ')'
 571                 . ' REFERENCES '
 572                 . PMA_Util::backquote($db) . '.'
 573                 . PMA_Util::backquote($T1) . '('
 574                 . PMA_Util::backquote($F1) . ')';
 575
 576             if ($on_delete != 'nix') {
 577                 $upd_query   .= ' ON DELETE ' . $on_delete;
 578             }
 579             if ($on_update != 'nix') {
 580                 $upd_query   .= ' ON UPDATE ' . $on_update;
 581             }
 582             $upd_query .= ';';
 583             if ($GLOBALS['dbi']->tryQuery($upd_query)) {
 584                 return array(true, __('FOREIGN KEY relation has been added.'));
 585             } else {
 586                 $error = $GLOBALS['dbi']->getError();
 587                 return array(
 588                     false,
 589                     __('Error: FOREIGN KEY relation could not be added!')
 590                     . "<br/>" . $error
 591                 );
 592             }
 593         } else {
 594             return array(false, __('Error: Missing index on column(s).'));
 595         }
 596     } else { // internal (pmadb) relation
 597         if ($GLOBALS['cfgRelation']['relwork'] == false) {
 598             return array(false, __('Error: Relational features are disabled!'));
 599         } else {
 600             // no need to recheck if the keys are primary or unique at this point,
 601             // this was checked on the interface part
 602
 603             $q  = "INSERT INTO "
 604                 . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
 605                 . "." . PMA_Util::backquote($GLOBALS['cfgRelation']['relation'])
 606                 . "(master_db, master_table, master_field, "
 607                 . "foreign_db, foreign_table, foreign_field)"
 608                 . " values("
 609                 . "'" . PMA_Util::sqlAddSlashes($db) . "', "
 610                 . "'" . PMA_Util::sqlAddSlashes($T2) . "', "
 611                 . "'" . PMA_Util::sqlAddSlashes($F2) . "', "
 612                 . "'" . PMA_Util::sqlAddSlashes($db) . "', "
 613                 . "'" . PMA_Util::sqlAddSlashes($T1) . "', "
 614                 . "'" . PMA_Util::sqlAddSlashes($F1) . "')";
 615
 616             if (PMA_queryAsControlUser($q, false, PMA_DatabaseInterface::QUERY_STORE)
 617             ) {
 618                 return array(true, __('Internal relation has been added.'));
 619             } else {
 620                 $error = $GLOBALS['dbi']->getError($GLOBALS['controllink']);
 621                 return array(
 622                     false,
 623                     __('Error: Internal relation could not be added!')
 624                     . "<br/>" . $error
 625                 );
 626             }
 627         }
 628     }
 629 }
 630
 631 /**
 632  * Removes a foreign relation
 633  *
 634  * @param string $T1 foreign db.table
 635  * @param string $F1 foreign field
 636  * @param string $T2 master db.table
 637  * @param string $F2 master field
 638  *
 639  * @return array array of success/failure and message
 640  */
 641 function PMA_removeRelation($T1, $F1, $T2, $F2)
 642 {
 643     list($DB1, $T1) = explode(".", $T1);
 644     list($DB2, $T2) = explode(".", $T2);
 645
 646     $tables = $GLOBALS['dbi']->getTablesFull($DB1, $T1);
 647     $type_T1 = /*overload*/mb_strtoupper($tables[$T1]['ENGINE']);
 648     $tables = $GLOBALS['dbi']->getTablesFull($DB2, $T2);
 649     $type_T2 = /*overload*/mb_strtoupper($tables[$T2]['ENGINE']);
 650
 651     if (PMA_Util::isForeignKeySupported($type_T1)
 652         && PMA_Util::isForeignKeySupported($type_T2)
 653         && $type_T1 == $type_T2
 654     ) {
 655         // InnoDB
 656         $existrel_foreign = PMA_getForeigners($DB2, $T2, '', 'foreign');
 657         $foreigner = PMA_searchColumnInForeigners($existrel_foreign, $F2);
 658
 659         if (isset($foreigner['constraint'])) {
 660             $upd_query = 'ALTER TABLE ' . PMA_Util::backquote($DB2)
 661                 . '.' . PMA_Util::backquote($T2) . ' DROP FOREIGN KEY '
 662                 . PMA_Util::backquote($foreigner['constraint']) . ';';
 663             if ($GLOBALS['dbi']->query($upd_query)) {
 664                 return array(true, __('FOREIGN KEY relation has been removed.'));
 665             }
 666
 667             $error = $GLOBALS['dbi']->getError();
 668             return array(
 669                 false,
 670                 __('Error: FOREIGN KEY relation could not be removed!')
 671                 . "<br/>" . $error
 672             );
 673         }
 674     }
 675
 676     // internal relations
 677     $delete_query = "DELETE FROM "
 678         . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . "."
 679         . $GLOBALS['cfgRelation']['relation'] . " WHERE "
 680         . "master_db = '" . PMA_Util::sqlAddSlashes($DB2) . "'"
 681         . " AND master_table = '" . PMA_Util::sqlAddSlashes($T2) . "'"
 682         . " AND master_field = '" . PMA_Util::sqlAddSlashes($F2) . "'"
 683         . " AND foreign_db = '" . PMA_Util::sqlAddSlashes($DB1) . "'"
 684         . " AND foreign_table = '" . PMA_Util::sqlAddSlashes($T1) . "'"
 685         . " AND foreign_field = '" . PMA_Util::sqlAddSlashes($F1) . "'";
 686
 687     $result = PMA_queryAsControlUser(
 688         $delete_query,
 689         false,
 690         PMA_DatabaseInterface::QUERY_STORE
 691     );
 692
 693     if (!$result) {
 694         $error = $GLOBALS['dbi']->getError($GLOBALS['controllink']);
 695         return array(
 696             false,
 697             __('Error: Internal relation could not be removed!') . "<br/>" . $error
 698         );
 699     }
 700
 701     return array(true, __('Internal relation has been removed.'));
 702 }
 703
 704 /**
 705  * Save value for a designer setting
 706  *
 707  * @param string $index setting
 708  * @param string $value value
 709  *
 710  * @return bool whether the operation succeeded
 711  */
 712 function PMA_saveDesignerSetting($index, $value)
 713 {
 714     $cfgRelation = PMA_getRelationsParam();
 715     $cfgDesigner = array(
 716         'user'  => $GLOBALS['cfg']['Server']['user'],
 717         'db'    => $cfgRelation['db'],
 718         'table' => $cfgRelation['designer_settings']
 719     );
 720
 721     $success = true;
 722     if ($GLOBALS['cfgRelation']['designersettingswork']) {
 723
 724         $orig_data_query = "SELECT settings_data"
 725             . " FROM " . PMA_Util::backquote($cfgDesigner['db'])
 726             . "." . PMA_Util::backquote($cfgDesigner['table'])
 727             . " WHERE username = '"
 728             . PMA_Util::sqlAddSlashes($cfgDesigner['user']) . "';";
 729
 730         $orig_data = $GLOBALS['dbi']->fetchSingleRow(
 731             $orig_data_query, 'ASSOC', $GLOBALS['controllink']
 732         );
 733
 734         if (! empty($orig_data)) {
 735             $orig_data = json_decode($orig_data['settings_data'], true);
 736             $orig_data[$index] = $value;
 737             $orig_data = json_encode($orig_data);
 738
 739             $save_query = "UPDATE " . PMA_Util::backquote($cfgDesigner['db'])
 740                 . "." . PMA_Util::backquote($cfgDesigner['table'])
 741                 . " SET settings_data = '" . $orig_data . "'"
 742                 . " WHERE username = '"
 743                 . PMA_Util::sqlAddSlashes($cfgDesigner['user']) . "';";
 744
 745             $success = PMA_queryAsControlUser($save_query);
 746         } else {
 747             $save_data = array($index => $value);
 748
 749             $query = "INSERT INTO " . PMA_Util::backquote($cfgDesigner['db'])
 750                 . "." . PMA_Util::backquote($cfgDesigner['table'])
 751                 . " (username, settings_data)"
 752                 . " VALUES('" . $cfgDesigner['user'] . "',"
 753                 . " '" . json_encode($save_data) . "');";
 754
 755             $success = PMA_queryAsControlUser($query);
 756         }
 757     }
 758
 759     return $success;
 760 }