server_synchronize.php

   1 <?php
   2
   3 /* vim: set expandtab sw=4 ts=4 sts=4: */
   4 /**
   5  *
   6  * @version $Id$
   7  * @package phpMyAdmin
   8  */
   9
  10 /**
  11 *
  12 */
  13 require_once './libraries/common.inc.php';
  14
  15 /**
  16  * Does the common work
  17  */
  18 $GLOBALS['js_include'][] = 'functions.js';
  19 $GLOBALS['js_include'][] = 'mootools.js';
  20 require_once './libraries/server_common.inc.php';
  21
  22 /**
  23 * Contains all the functions specific to synchronization
  24 */
  25 require './libraries/server_synchronize.lib.php';
  26
  27 /**
  28  * Increases the time limit up to the configured maximum
  29  */
  30 @set_time_limit($cfg['ExecTimeLimit']);
  31
  32 /**
  33  * Displays the links
  34  */
  35 require './libraries/server_links.inc.php';
  36
  37 /**
  38 * Enables warnings on the page
  39 */
  40 //$cfg['Error_Handler']['display'] = true;
  41 //$cfg['Error_Handler']['gather'] = true;
  42
  43 /**
  44 * Save the value of token generated for this page
  45 */
  46 if (isset($_REQUEST['token'])) {
  47     $_SESSION['token'] = $_REQUEST['token'];
  48 }
  49
  50 // variable for code saving
  51 $cons = array ("src", "trg");
  52
  53 /**
  54  * Displays the page when 'Go' is pressed
  55  */
  56
  57 if ((isset($_REQUEST['submit_connect']))) {
  58     foreach ($cons as $con) {
  59         ${"{$con}_host"}     = $_REQUEST[$con.'_host'];
  60         ${"{$con}_username"} = $_REQUEST[$con.'_username'];
  61         ${"{$con}_password"} = $_REQUEST[$con.'_pass'];
  62         ${"{$con}_port"}     = $_REQUEST[$con.'_port'];
  63         ${"{$con}_socket"}   = $_REQUEST[$con.'_socket'];
  64         ${"{$con}_db"}       = $_REQUEST[$con.'_db'];
  65         ${"{$con}_type"}         = $_REQUEST[$con.'_type'];
  66
  67         if (${"{$con}_type"} == 'cur') {
  68                 ${"{$con}_connection"} = null;
  69                 ${"{$con}_server"} = null;
  70                 ${"{$con}_db"}       = $_REQUEST[$con.'_db_sel'];
  71                 continue;
  72         }
  73
  74         if (isset(${"{$con}_socket"}) && ! empty(${"{$con}_socket"})) {
  75                 ${"{$con}_server"}['socket'] = ${"{$con}_socket"};
  76         } else {
  77                 ${"{$con}_server"}['host'] = ${"{$con}_host"};
  78                 if (isset(${"{$con}_port"}) && ! empty(${"{$con}_port"}) && ((int)${"{$con}_port"} * 1) > 0) {
  79                     ${"{$con}_server"}['port'] = ${"{$con}_port"};
  80                 }
  81         }
  82
  83         ${"{$con}_connection"} = PMA_DBI_connect(${"{$con}_username"}, ${"{$con}_password"}, $is_controluser = false, ${"{$con}_server"}, $auxiliary_connection = true);
  84     } // end foreach ($cons as $con)
  85
  86     if ((! $src_connection && $src_type == 'rmt') || (! $trg_connection && $trg_type == 'rmt')) {
  87         /**
  88         * Displays the connection error string if
  89         * connections are not established
  90         */
  91
  92         echo '<div class="error">' . "\n" ;
  93         if(! $src_connection && $src_type == 'rmt') {
  94             echo $GLOBALS['strCouldNotConnectSource'].'<br />';
  95         }
  96         if(! $trg_connection && $trg_type == 'rmt'){
  97             echo $GLOBALS['strCouldNotConnectTarget'];
  98         }
  99         echo '</div>';
 100         unset($_REQUEST['submit_connect']);
 101
 102     } else {
 103         /**
 104         * Creating the link object for both source and target databases and
 105         * selecting the source and target databases using these links
 106         */
 107             foreach ($cons as $con) {
 108                 if (${"{$con}_connection"} != null) {
 109                     ${"{$con}_link"} = PMA_DBI_connect(${"{$con}_username"}, ${"{$con}_password"}, $is_controluser = false, ${"{$con}_server"});
 110                 } else {
 111                 ${"{$con}_link"} = null;
 112             }
 113                 ${"{$con}_db_selected"} = PMA_DBI_select_db(${"{$con}_db"}, ${"{$con}_link"});
 114             } // end foreach ($cons as $con)
 115
 116         if (($src_db_selected != 1) || ($trg_db_selected != 1)) {
 117             /**
 118             * Displays error string if the database(s) did not exist
 119             */
 120             echo '<div class="error">' . "\n" ;
 121             if ($src_db_selected != 1) {
 122                 echo sprintf($GLOBALS['strDatabaseNotExisting'], $src_db);
 123             }
 124             if ($trg_db_selected != 1) {
 125                 echo sprintf($GLOBALS['strDatabaseNotExisting'], $trg_db);
 126             }
 127             echo '</div>';
 128             unset($_REQUEST['submit_connect']);
 129
 130         } else if (($src_db_selected == 1) && ($trg_db_selected == 1)) {
 131
 132             /**
 133             * Using PMA_DBI_get_tables() to get all the tables
 134             * from target and source databases.
 135             */
 136             $src_tables = PMA_DBI_get_tables($src_db, $src_link);
 137             $source_tables_num = sizeof($src_tables);
 138
 139             $trg_tables = PMA_DBI_get_tables($trg_db, $trg_link);
 140             $target_tables_num = sizeof($trg_tables);
 141
 142             /**
 143             * initializing arrays to save matching and non-matching
 144             * table names from target and source databases.
 145             */
 146             $unmatched_num_src = 0;
 147             $source_tables_uncommon = array();
 148             $unmatched_num_trg = 0;
 149             $target_tables_uncommon = array();
 150             $matching_tables = array();
 151             $matching_tables_num = 0;
 152
 153             /**
 154             * Using PMA_getMatchingTables to find which of the tables' names match
 155             * in target and source database.
 156             */
 157             PMA_getMatchingTables($trg_tables, $src_tables, $matching_tables, $source_tables_uncommon);
 158             /**
 159             * Finding the uncommon tables for the target database
 160             * using function PMA_getNonMatchingTargetTables()
 161             */
 162             PMA_getNonMatchingTargetTables($trg_tables, $matching_tables, $target_tables_uncommon);
 163
 164             /**
 165             * Initializing several arrays to save the data and structure
 166             * difference between the source and target databases.
 167             */
 168             $row_count = array();   //number of rows in source table that needs to be created in target database
 169             $fields_num = array();  //number of fields in each matching table
 170             $delete_array = array(); //stores the primary key values for target tables that have excessive rows than corresponding source tables.
 171             $insert_array = array(array(array()));// stores the primary key values for the rows in each source table that are not present in target tables.
 172             $update_array = array(array(array())); //stores the primary key values, name of field to be updated, value of the field to be updated for
 173                                                     // each row of matching table.
 174             $matching_tables_fields = array(); //contains the fields' names for each matching table
 175             $matching_tables_keys   = array(); //contains the primary keys' names for each matching table
 176             $uncommon_tables_fields = array(); //coantains the fields for all the source tables that are not present in target
 177             $matching_tables_num = sizeof($matching_tables);
 178
 179             $source_columns = array();  //contains the full columns' information for all the source tables' columns
 180             $target_columns = array();  //contains the full columns' information for all the target tables' columns
 181             $uncommon_columns = array(); //contains names of columns present in source table but absent from the corresponding target table
 182             $source_indexes = array();   //contains indexes on all the source tables
 183             $target_indexes = array();   //contains indexes on all the target tables
 184             $add_indexes_array = array(); //contains the indexes name present in source but absent from target tables
 185             $target_tables_keys = array(); //contains the keys of all the target tables
 186             $alter_indexes_array = array();  //contains the names of all the indexes for each table that need to be altered in target database
 187             $remove_indexes_array = array();  //contains the names of indexes that are excessive in target tables
 188             $alter_str_array = array(array());  //contains the criteria for each column that needs to be altered in target tables
 189             $add_column_array = array(array()); //contains the name of columns that need to be added in target tables
 190             /**
 191             * The criteria array contains all the criteria against which columns are compared for differences.
 192             */
 193             $criteria = array('Field', 'Type', 'Null', 'Collation', 'Key', 'Default', 'Comment');
 194
 195             for($i = 0; $i < sizeof($matching_tables); $i++) {
 196                 /**
 197                 * Finding out all the differences structure, data and index diff for all the matching tables only
 198                 */
 199                 PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $matching_tables_fields, $update_array, $insert_array,
 200                 $delete_array, $fields_num, $i, $matching_tables_keys);
 201
 202                 PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $source_columns,
 203                 $target_columns, $alter_str_array, $add_column_array, $uncommon_columns, $criteria, $target_tables_keys, $i);
 204
 205                 PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $source_indexes, $target_indexes,
 206                 $add_indexes_array, $alter_indexes_array,$remove_indexes_array, $i);
 207             }
 208
 209             for($j = 0; $j < sizeof($source_tables_uncommon); $j++) {
 210                 /**
 211                 * Finding out the number of rows to be added in tables that need to be added in target database
 212                 */
 213                 PMA_dataDiffInUncommonTables($source_tables_uncommon, $src_db, $src_link, $j, $row_count);
 214             }
 215             /**
 216             * Storing all arrays in session for use when page is reloaded for each button press
 217             */
 218             $_SESSION['matching_tables'] = $matching_tables;
 219             $_SESSION['update_array'] = $update_array;
 220             $_SESSION['insert_array'] = $insert_array;
 221             $_SESSION['src_db'] = $src_db;
 222             $_SESSION['trg_db'] =  $trg_db;
 223             $_SESSION['matching_fields'] = $matching_tables_fields;
 224             $_SESSION['src_uncommon_tables'] = $source_tables_uncommon;
 225             $_SESSION['src_username'] = $src_username ;
 226             $_SESSION['trg_username'] = $trg_username;
 227             $_SESSION['src_password'] = $src_password;
 228             $_SESSION['trg_password'] = $trg_password;
 229             $_SESSION['trg_password'] = $trg_password;
 230             $_SESSION['src_server']   = $src_server;
 231                 $_SESSION['trg_server']   = $trg_server;
 232                 $_SESSION['src_type']     = $src_type;
 233             $_SESSION['trg_type']     = $trg_type;
 234             $_SESSION['matching_tables_keys'] = $matching_tables_keys;
 235             $_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
 236             $_SESSION['uncommon_tables_row_count'] = $row_count;
 237             $_SESSION['target_tables_uncommon'] = $target_tables_uncommon;
 238             $_SESSION['uncommon_tables'] = $source_tables_uncommon;
 239             $_SESSION['delete_array'] = $delete_array;
 240             $_SESSION['uncommon_columns'] = $uncommon_columns;
 241             $_SESSION['source_columns'] = $source_columns;
 242             $_SESSION['alter_str_array'] = $alter_str_array;
 243             $_SESSION['target_tables_keys'] = $target_tables_keys;
 244             $_SESSION['add_column_array'] = $add_column_array;
 245             $_SESSION['criteria'] = $criteria;
 246             $_SESSION['target_tables'] = $trg_tables;
 247             $_SESSION['add_indexes_array'] = $add_indexes_array;
 248             $_SESSION['alter_indexes_array'] = $alter_indexes_array;
 249             $_SESSION['remove_indexes_array'] = $remove_indexes_array;
 250             $_SESSION['source_indexes'] = $source_indexes;
 251             $_SESSION['target_indexes'] = $target_indexes;
 252
 253             /**
 254             * Displays the sub-heading and icons showing Structure Synchronization and Data Synchronization
 255             */
 256             echo '<form name="synchronize_form" id="synchronize_form" method="POST" action="server_synchronize.php">'
 257             . PMA_generate_common_hidden_inputs('', '');
 258             echo '<table id="serverstatustraffic" class="data" width = "50%">
 259             <tr>
 260             <td> <h2>' . "\n"
 261             . ($GLOBALS['cfg']['MainPageIconic']
 262             ? '<img class="icon" src="' . $pmaThemeImage . 'new_struct.jpg" width="32"'
 263             . ' height="32" alt="" />' . "\n"
 264             : '')
 265             . $strStructureSyn . "\n"
 266             .'</h2>' . "\n" .'</td>';
 267             echo '<td> <h2>' . "\n"
 268             . ($GLOBALS['cfg']['MainPageIconic']
 269             ? '<img class="icon" src="' . $pmaThemeImage . 'new_data.jpg" width="32"'
 270             . ' height="32" alt="" />' . "\n"
 271             : '')
 272             . $strDataSyn . "\n"
 273             . '</h2>' . "\n" .'</td>';
 274             echo '</tr>
 275             </table>';
 276
 277             /**
 278             * Displays the tables containing the source tables names, their difference with the target tables and target tables names
 279             */
 280             PMA_syncDisplayHeaderSource($src_db);
 281             $odd_row = false;
 282             /**
 283             * Display the matching tables' names and difference, first
 284             */
 285             for($i = 0; $i < count($matching_tables); $i++) {
 286                 $num_of_updates = 0;
 287                 $num_of_insertions = 0;
 288                 /**
 289                 * Calculating the number of updates for each matching table
 290                 */
 291                 if (isset($update_array[$i])) {
 292                     if (isset($update_array[$i][0][$matching_tables_keys[$i][0]])) {
 293                         if (isset($update_array[$i])) {
 294                             $num_of_updates = sizeof($update_array[$i]);
 295                         } else {
 296                              $num_of_updates = 0;
 297                         }
 298                     } else {
 299                             $num_of_updates = 0;
 300                     }
 301                 }
 302                 /**
 303                 * Calculating the number of insertions for each matching table
 304                 */
 305                 if (isset($insert_array[$i])) {
 306                     if (isset($insert_array[$i][0][$matching_tables_keys[$i][0]])) {
 307                         if (isset($insert_array[$i])) {
 308                             $num_of_insertions = sizeof($insert_array[$i]);
 309                         } else {
 310                             $num_of_insertions = 0;
 311                         }
 312                     } else {
 313                         $num_of_insertions = 0;
 314                     }
 315                 }
 316                 /**
 317                 * Displays the name of the matching table
 318                 */
 319                 $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 320                 echo '<td>' . $matching_tables[$i]. "\n" . '</td>
 321                 <td align="center">';
 322                 /**
 323                 * Calculating the number of alter columns, number of columns to be added, number of columns to be removed,
 324                 * number of index to added and renmoved.
 325                 */
 326                 $num_alter_cols  = 0;
 327                 $num_insert_cols = 0;
 328                 $num_remove_cols = 0;
 329                 $num_add_index   = 0;
 330                 $num_remove_index = 0;
 331
 332                 if (isset($alter_str_array[$i])) {
 333                     $num_alter_cols = sizeof($alter_str_array[$i]);
 334                 }
 335                 if (isset($add_column_array[$i])) {
 336                     $num_insert_cols = sizeof($add_column_array[$i]);
 337                 }
 338                 if (isset($uncommon_columns[$i])) {
 339                    $num_remove_cols = sizeof($uncommon_columns[$i]);
 340                 }
 341                 if (isset($add_indexes_array[$i])) {
 342                     $num_add_index = sizeof($add_indexes_array[$i]);
 343                 }
 344                 if (isset($remove_indexes_array[$i])) {
 345                    $num_remove_index = sizeof($remove_indexes_array[$i]);
 346                 }
 347                 /**
 348                 * Display the red button of structure synchronization if there exists any structure difference or index difference.
 349                 */
 350                 if (($num_alter_cols > 0) || ($num_insert_cols > 0) || ($num_remove_cols > 0) || ($num_add_index > 0) ||($num_remove_index > 0)) {
 351
 352                    echo '<img class="icon" src="' . $pmaThemeImage . 'new_struct.jpg" width="29"  height="29"
 353                    alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 354                    onClick="showDetails('."'MS".$i."'".','."'".$num_alter_cols."'".','."'".$num_insert_cols.
 355                    "'".','."'".$num_remove_cols."'".','."'".$num_add_index."'".','."'".$num_remove_index."'"
 356                    .', this ,'."'". $matching_tables[$i] ."'".')"/>'. "\n" ;
 357
 358                 }
 359                 /**
 360                 * Display the green button of data synchronization if there exists any data difference.
 361                 */
 362                 if (isset($update_array[$i]) || isset($insert_array[$i])) {
 363                     if (isset($update_array[$i][0][$matching_tables_keys[$i][0]]) || isset($insert_array[$i][0][$matching_tables_keys[$i][0]])) {
 364
 365                         echo '<img class="icon" src="' . $pmaThemeImage . 'new_data.jpg" width="29" height="29"
 366                         alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 367                          onClick="showDetails('."'MD".$i."'".','."'".$num_of_updates."'".','."'".$num_of_insertions.
 368                          "'".','."'".null."'".','."'".null."'".','."'".null."'".', this ,'."'". $matching_tables[$i] ."'".')" />'. "\n";
 369                     }
 370                 }
 371                 echo '</td>
 372                 </tr>';
 373             }
 374             /**
 375             * Displays the tables' names present in source but missing from target
 376             */
 377             for ($j = 0; $j < count($source_tables_uncommon); $j++) {
 378                 $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 379                 echo '<td> + ' .$source_tables_uncommon[$j]. "\n" . '</td> ';
 380
 381                 echo '<td align="center"><img class="icon" src="' . $pmaThemeImage .  'new_struct.jpg" width="29"  height="29"
 382                 alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 383                 onClick="showDetails('."'US".$j."'".','."'".null."'".','."'".null."'".','."'".null."'".','."'".null."'".','."'".null."'".', this ,'
 384                 ."'". $source_tables_uncommon[$j] ."'".')"/>'. "\n" ;
 385
 386                 if ($row_count[$j] > 0)
 387                 {
 388                     echo '<img class="icon" src="' . $pmaThemeImage . 'new_data.jpg" width="29"'.' height="29"
 389                     alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 390                     onClick="showDetails('."'UD".$j."'".','."'".null."'".','."'".$row_count[$j]."'".','."'".null.
 391                     "'".','."'".null."'".','."'".null."'".', this ,'."'". $source_tables_uncommon[$j] ."'".')" />'. "\n";
 392                 }
 393                 echo '</td>
 394                 </tr>';
 395             }
 396             foreach ($target_tables_uncommon as $tbl_nc_name) {
 397                 $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 398                 echo '<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td><td></td>';
 399                 echo '</tr>';
 400             }
 401             /**
 402             * Displays the target tables names
 403             */
 404             echo '</table>';
 405
 406             $odd_row = PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables);
 407             foreach ($source_tables_uncommon as $tbl_nc_name) {
 408                 $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 409                 echo '<td>' .$tbl_nc_name . "\n" . ' (' . $GLOBALS['strNotPresent'] . ')</td>
 410                 </tr>';
 411             }
 412             foreach ($target_tables_uncommon as $tbl_nc_name) {
 413                 $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 414                 echo '<td> - ' .$tbl_nc_name . '</td>';
 415                 echo '</tr>';
 416             }
 417             echo '</table>';
 418             echo '</div>';
 419
 420             /**
 421             * This "list" div will contain a table and each row will depict information about structure/data diffrence in tables.
 422             * Rows will be generated dynamically as soon as the colored  buttons "D" or "S"  are clicked.
 423             */
 424
 425             echo '<div id="list" style = "overflow: auto; width: 1020px; height: 140px;
 426             border-left: 1px gray solid; border-bottom: 1px gray solid;
 427             padding:0px; margin: 0px">
 428
 429             <table>
 430                 <thead>
 431                 <tr style="width: 100%;">
 432                     <th id="table_name" style="width: 10%;" colspan="1">'. $strTable .' </th>
 433                     <th id="str_diff"   style="width: 65%;" colspan="6">'. $strStructureDiff .' </th>
 434                     <th id="data_diff"  style="width: 20%;" colspan="2">'. $strDataDiff .'</th>
 435                 </tr>
 436                 <tr style="width: 100%;">
 437                     <th style="width: 10%; background-color:#CCCCCC">'. $strTableName .'</th>
 438                     <th style="width: 10%; background-color:#CCCCCC">'. $strCreateTable .'</th>
 439                     <th style="width: 11%; background-color:#CCCCCC">'. $strTableAddColumn .'</th>
 440                     <th style="width: 13%; background-color:#CCCCCC">'. $strTableRemoveColumn .'</th>
 441                     <th style="width: 11%; background-color:#CCCCCC">'. $strTableAlterColumn .'</th>
 442                     <th style="width: 12%; background-color:#CCCCCC">'. $strTableRemoveIndex .'</th>
 443                     <th style="width: 11%; background-color:#CCCCCC">'. $strTableApplyIndex .'</th>
 444                     <th style="width: 10%; background-color:#CCCCCC">'. $strTableUpdateRow .'</th>
 445                     <th style="width: 10%; background-color:#CCCCCC">'. $strTableInsertRow .'</th>
 446                 </tr>
 447                 </thead>
 448                 <tbody></tbody>
 449             </table>
 450             </div>';
 451             /**
 452             *  This fieldset displays the checkbox to confirm deletion of previous rows from target tables
 453             */
 454             echo '<fieldset>
 455             <p><input type= "checkbox" name="delete_rows" id ="delete_rows" />' . $strTableDeleteRows . ' </p>
 456             </fieldset>
 457             <fieldset class="tblFooters">' . "\n";
 458             echo '<input type="button" name="apply_changes" value="' . $GLOBALS['strApplyChanges']
 459              .'" onClick ="ApplySelectedChanges('."'". $_SESSION['token'] ."'".')" />';
 460             echo '<input type="submit" name="synchronize_db" value="'. $GLOBALS['strSynchronizeDb'] .'" />'
 461             . "\n" . '</fieldset>' . "\n";
 462             echo '</form>';
 463         }
 464     }
 465 } // end if ((isset($_REQUEST['submit_connect'])))
 466
 467  /**
 468  * Display the page when 'Apply Selected Changes' is pressed
 469  */
 470 if (isset($_REQUEST['Table_ids'])) {
 471     /**
 472     * Displays success message
 473     */
 474     echo '<div class="success">' . $GLOBALS['strHaveBeenSynchronized'] . '</div>';
 475
 476     $src_db = $_SESSION['src_db'];
 477     $trg_db = $_SESSION['trg_db'];
 478     $update_array = $_SESSION['update_array'];
 479     $insert_array = $_SESSION['insert_array'];
 480     $src_username = $_SESSION['src_username'];
 481     $trg_username = $_SESSION['trg_username'];
 482     $src_password = $_SESSION['src_password'];
 483     $trg_password = $_SESSION['trg_password'];
 484     $src_server   = $_SESSION['src_server'];
 485     $trg_server   = $_SESSION['trg_server'];
 486     $src_type     = $_SESSION['src_type'];
 487     $trg_type     = $_SESSION['trg_type'];
 488     $uncommon_tables = $_SESSION['uncommon_tables'];
 489     $matching_tables = $_SESSION['matching_tables'];
 490     $matching_tables_keys = $_SESSION['matching_tables_keys'];
 491     $matching_tables_fields = $_SESSION['matching_fields'];
 492     $source_tables_uncommon = $_SESSION['src_uncommon_tables'];
 493     $uncommon_tables_fields = $_SESSION['uncommon_tables_fields'];
 494     $target_tables_uncommon = $_SESSION['target_tables_uncommon'];
 495     $row_count = $_SESSION['uncommon_tables_row_count'];
 496     $target_tables = $_SESSION['target_tables'];
 497
 498     $delete_array = $_SESSION['delete_array'];
 499     $uncommon_columns = $_SESSION['uncommon_columns'];
 500     $source_columns = $_SESSION['source_columns'];
 501     $alter_str_array = $_SESSION['alter_str_array'];
 502     $criteria = $_SESSION['criteria'];
 503     $target_tables_keys = $_SESSION['target_tables_keys'];
 504     $add_column_array = $_SESSION['add_column_array'];
 505     $add_indexes_array = $_SESSION['add_indexes_array'];
 506     $alter_indexes_array = $_SESSION['alter_indexes_array'];
 507     $remove_indexes_array = $_SESSION['remove_indexes_array'];
 508     $source_indexes = $_SESSION['source_indexes'];
 509     $target_indexes = $_SESSION['target_indexes'];
 510     $uncommon_cols = $uncommon_columns;
 511
 512     /**
 513     * Creating link object for source and target databases
 514     */
 515     foreach ($cons as $con) {
 516         if (${"{$con}_type"}=="rmt") {
 517             ${"{$con}_link"} = PMA_DBI_connect(${"{$con}_username"}, ${"{$con}_password"}, $is_controluser = false, ${"{$con}_server"});
 518         } else {
 519             ${"{$con}_link"} = null;
 520             // working on current server, so initialize this for tracking
 521             // (does not work if user defined current server as a remote one)
 522             $GLOBALS['db'] = ${"{$con}_db"};
 523         }
 524     } // end foreach ($cons as $con)
 525
 526     /**
 527     * Initializing arrays to save the table ids whose data and structure difference is to be applied
 528     */
 529     $matching_table_data_diff = array();  //stores id of matching table having data difference
 530     $matching_table_structure_diff = array(); //stores id of matching tables having structure difference
 531     $uncommon_table_structure_diff = array(); //stores id of uncommon tables having structure difference
 532     $uncommon_table_data_diff = array();     //stores id of uncommon tables having data difference
 533
 534     for ($i = 0; isset($_REQUEST[$i]); $i++ ) {
 535         if (isset($_REQUEST[$i])) {
 536             $table_id = split("US", $_REQUEST[$i]);
 537             if (isset($table_id[1])) {
 538                 $uncommon_table_structure_diff[] = $table_id[1];
 539             }
 540             $table_id = split("UD", $_REQUEST[$i]);
 541             if (isset($table_id[1])) {
 542                 $uncommon_table_data_diff[] = $table_id[1];
 543             }
 544             $table_id = split("MS", $_REQUEST[$i]);
 545             if (isset($table_id[1])) {
 546                 $matching_table_structure_diff[] = $table_id[1];
 547             }
 548
 549             $table_id = split("MD", $_REQUEST[$i]);
 550             if (isset($table_id[1])) {
 551                  $matching_table_data_diff[] = $table_id[1];
 552             }
 553         }
 554     } // end for
 555     /**
 556     * Applying the structure difference on selected matching tables
 557     */
 558     for($q = 0 ; $q < sizeof($matching_table_structure_diff); $q++)
 559     {
 560         if (isset($alter_str_array[$matching_table_structure_diff[$q]])) {
 561
 562             PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, $source_columns, $alter_str_array, $matching_tables_fields,
 563             $criteria, $matching_tables_keys, $target_tables_keys, $matching_table_structure_diff[$q], false);
 564
 565             unset($alter_str_array[$matching_table_structure_diff[$q]]);
 566         }
 567         if (isset($add_column_array[$matching_table_structure_diff[$q]])) {
 568
 569             PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $matching_table_structure_diff[$q], $target_tables_keys,
 570             $matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link);
 571
 572             if (isset($delete_array[$matching_table_structure_diff[$q]])) {
 573
 574                 PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $matching_table_structure_diff[$q], $target_tables_keys, $delete_array, false);
 575
 576                 unset($delete_array[$matching_table_structure_diff[$q]]);
 577             }
 578             PMA_addColumnsInTargetTable($src_db, $trg_db,$src_link, $trg_link, $matching_tables, $source_columns, $add_column_array, $matching_tables_fields,
 579             $criteria, $matching_tables_keys, $target_tables_keys, $uncommon_tables,$uncommon_tables_fields, $matching_table_structure_diff[$q], $uncommon_cols, false);
 580
 581             unset($add_column_array[$matching_table_structure_diff[$q]]);
 582         }
 583         if (isset($uncommon_columns[$matching_table_structure_diff[$q]])) {
 584
 585             PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $matching_table_structure_diff[$q], false);
 586
 587             unset($uncommon_columns[$matching_table_structure_diff[$q]]);
 588         }
 589         if (isset($add_indexes_array[$matching_table_structure_diff[$q]]) || isset($remove_indexes_array[$matching_table_structure_diff[$q]])
 590             || isset($alter_indexes_array[$matching_table_structure_diff[$q]])) {
 591
 592             PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array,
 593             $remove_indexes_array, $matching_table_structure_diff[$q], false);
 594
 595             unset($add_indexes_array[$matching_table_structure_diff[$q]]);
 596             unset($alter_indexes_array[$matching_table_structure_diff[$q]]);
 597             unset($remove_indexes_array[$matching_table_structure_diff[$q]]);
 598         }
 599     }
 600     /**
 601     * Applying the data difference. First checks if structure diff is applied or not.
 602     * If not, then apply structure difference first then apply data difference.
 603     */
 604     for($p = 0; $p < sizeof($matching_table_data_diff); $p++)
 605     {
 606         if ($_REQUEST['checked'] == 'true') {
 607
 608             PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $matching_table_data_diff[$p], $target_tables_keys,
 609             $matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link);
 610
 611             if (isset($delete_array[$matching_table_data_diff[$p]])) {
 612
 613                 PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $matching_table_data_diff[$p], $target_tables_keys, $delete_array, false);
 614
 615                 unset($delete_array[$matching_table_data_diff[$p]]);
 616             }
 617         }
 618         if (isset($alter_str_array[$matching_table_data_diff[$p]])) {
 619
 620             PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, $source_columns, $alter_str_array, $matching_tables_fields,
 621             $criteria, $matching_tables_keys, $target_tables_keys, $matching_table_data_diff[$p], false);
 622
 623             unset($alter_str_array[$matching_table_data_diff[$p]]);
 624         }
 625         if (isset($add_column_array[$matching_table_data_diff[$p]])) {
 626
 627             PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $matching_table_data_diff[$p], $target_tables_keys,
 628             $matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link);
 629
 630             if (isset($delete_array[$matching_table_data_diff[$p]])) {
 631
 632                 PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $matching_table_data_diff[$p], $target_tables_keys, $delete_array, false);
 633
 634                 unset($delete_array[$matching_table_data_diff[$p]]);
 635             }
 636             PMA_addColumnsInTargetTable($src_db, $trg_db,$src_link, $trg_link, $matching_tables, $source_columns, $add_column_array, $matching_tables_fields,
 637             $criteria, $matching_tables_keys, $target_tables_keys, $uncommon_tables, $uncommon_tables_fields, $matching_table_data_diff[$p], $uncommon_cols, false);
 638
 639             unset($add_column_array[$matching_table_data_diff[$p]]);
 640         }
 641         if (isset($uncommon_columns[$matching_table_data_diff[$p]])) {
 642
 643             PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $matching_table_data_diff[$p], false);
 644
 645             unset($uncommon_columns[$matching_table_data_diff[$p]]);
 646         }
 647         if ((isset($matching_table_structure_diff[$q]) && isset($add_indexes_array[$matching_table_structure_diff[$q]]))
 648             || (isset($matching_table_structure_diff[$q]) && isset($remove_indexes_array[$matching_table_structure_diff[$q]]))
 649             || (isset($matching_table_structure_diff[$q]) && isset($alter_indexes_array[$matching_table_structure_diff[$q]]))) {
 650
 651             PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array,
 652             $remove_indexes_array, $matching_table_structure_diff[$q], false);
 653
 654             unset($add_indexes_array[$matching_table_structure_diff[$q]]);
 655             unset($alter_indexes_array[$matching_table_structure_diff[$q]]);
 656             unset($remove_indexes_array[$matching_table_structure_diff[$q]]);
 657         }
 658         /**
 659         * Applying the data difference.
 660         */
 661         PMA_updateTargetTables($matching_tables, $update_array, $src_db, $trg_db, $trg_link, $matching_table_data_diff[$p], $matching_tables_keys, false);
 662
 663         PMA_insertIntoTargetTable($matching_tables, $src_db, $trg_db, $src_link, $trg_link , $matching_tables_fields, $insert_array,
 664         $matching_table_data_diff[$p], $matching_tables_keys, $source_columns, $add_column_array, $criteria, $target_tables_keys,
 665         $uncommon_tables, $uncommon_tables_fields, $uncommon_cols, $alter_str_array, $source_indexes, $target_indexes, $add_indexes_array,
 666         $alter_indexes_array, $delete_array, $update_array, false);
 667     }
 668     /**
 669     * Updating the session variables to the latest values of the arrays.
 670     */
 671     $_SESSION['delete_array'] = $delete_array;
 672     $_SESSION['uncommon_columns'] = $uncommon_columns;
 673     $_SESSION['alter_str_array']  = $alter_str_array;
 674     $_SESSION['add_column_array'] = $add_column_array;
 675     $_SESSION['add_indexes_array'] = $add_indexes_array;
 676     $_SESSION['remove_indexes_array'] = $remove_indexes_array;
 677     $_SESSION['insert_array'] = $insert_array;
 678     $_SESSION['update_array'] = $update_array;
 679
 680     /**
 681     * Applying structure difference to selected non-matching tables (present in Source but absent from Target).
 682     */
 683     for($s = 0; $s < sizeof($uncommon_table_structure_diff); $s++)
 684     {
 685         PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $uncommon_table_structure_diff[$s], $uncommon_tables_fields, false);
 686         $_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
 687
 688         unset($uncommon_tables[$uncommon_table_structure_diff[$s]]);
 689     }
 690     /**
 691     * Applying data difference to selected non-matching tables (present in Source but absent from Target).
 692     * Before data synchronization, structure synchronization is confirmed.
 693     */
 694     for($r = 0; $r < sizeof($uncommon_table_data_diff); $r++)
 695     {
 696         if (!(in_array($uncommon_table_data_diff[$r], $uncommon_table_structure_diff))) {
 697             if (isset($uncommon_tables[$uncommon_table_data_diff[$r]])) {
 698
 699                 PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $uncommon_table_data_diff[$r], $uncommon_tables_fields, false);
 700                 $_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
 701
 702                 unset($uncommon_tables[$uncommon_table_data_diff[$r]]);
 703             }
 704         }
 705         PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $source_tables_uncommon, $uncommon_table_data_diff[$r],
 706         $_SESSION['uncommon_tables_fields'], false);
 707
 708         unset($row_count[$uncommon_table_data_diff[$r]]);
 709     }
 710     /**
 711     * Again all the tables from source and target database are displayed with their differences.
 712     * The differences have been removed from tables that have been synchronized
 713     */
 714     echo '<form name="applied_difference" id="synchronize_form" method="POST" action="server_synchronize.php">'
 715     . PMA_generate_common_hidden_inputs('', '');
 716
 717     PMA_syncDisplayHeaderSource($src_db);
 718     $odd_row = false;
 719     for($i = 0; $i < count($matching_tables); $i++) {
 720         $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 721         echo '<td align="center">' . $matching_tables[$i]. "\n" . '</td>
 722         <td align="center">';
 723
 724         $num_alter_cols  = 0;
 725         $num_insert_cols = 0;
 726         $num_remove_cols = 0;
 727         $num_add_index = 0;
 728         $num_remove_index = 0;
 729
 730         if (isset($alter_str_array[$i])) {
 731             $num_alter_cols = sizeof($alter_str_array[$i]);
 732         }
 733         if (isset($add_column_array[$i])) {
 734             $num_insert_cols = sizeof($add_column_array[$i]);
 735         }
 736         if (isset($uncommon_columns[$i])) {
 737             $num_remove_cols = sizeof($uncommon_columns[$i]);
 738         }
 739         if (isset($add_indexes_array[$i])) {
 740             $num_add_index = sizeof($add_indexes_array[$i]);
 741         }
 742         if (isset($remove_indexes_array[$i])) {
 743             $num_remove_index = sizeof($remove_indexes_array[$i]);
 744         }
 745
 746         if (($num_alter_cols > 0) || ($num_insert_cols > 0) || ($num_remove_cols > 0) || ($num_add_index > 0) ||($num_remove_index > 0)) {
 747             echo '<img class="icon" src="' . $pmaThemeImage .  'new_struct.jpg" width="29"  height="29"
 748             alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 749             onClick="showDetails('."'MS".$i."'".','."'".$num_alter_cols."'".','."'".$num_insert_cols."'"
 750             .','."'".$num_remove_cols."'".','."'".$num_add_index."'".','."'".$num_remove_index."'".',
 751             this ,'."'". $matching_tables[$i] ."'".')"/>'. "\n" ;
 752         }
 753         if (!(in_array($i, $matching_table_data_diff))) {
 754
 755             if (isset($matching_tables_keys[$i][0]) && isset($update_array[$i][0][$matching_tables_keys[$i][0]])) {
 756                 if (isset($update_array[$i])) {
 757                     $num_of_updates = sizeof($update_array[$i]);
 758                 } else {
 759                     $num_of_updates = 0;
 760                 }
 761             } else {
 762                 $num_of_updates = 0;
 763             }
 764             if (isset($matching_tables_keys[$i][0]) && isset($insert_array[$i][0][$matching_tables_keys[$i][0]])) {
 765                 if (isset($insert_array[$i])) {
 766                     $num_of_insertions = sizeof($insert_array[$i]);
 767                 } else {
 768                     $num_of_insertions = 0;
 769                 }
 770             } else {
 771                 $num_of_insertions = 0;
 772             }
 773
 774             if ((isset($matching_tables_keys[$i][0]) && isset($update_array[$i][0][$matching_tables_keys[$i][0]]))
 775                 || (isset($matching_tables_keys[$i][0]) && isset($insert_array[$i][0][$matching_tables_keys[$i][0]]))) {
 776                 echo '<img class="icon" src="' . $pmaThemeImage . 'new_data.jpg" width="29" height="29"
 777                 alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 778                 onClick="showDetails('."'MD".$i."'".','."'".$num_of_updates."'".','."'".$num_of_insertions.
 779                 "'".','."'".null."'".','."'".null."'".','."'".null."'".', this ,'."'". $matching_tables[$i] ."'".')" />';
 780             }
 781         } else {
 782             unset($update_array[$i]);
 783             unset($insert_array[$i]);
 784         }
 785         echo '</td>
 786         </tr>';
 787     }
 788     /**
 789     * placing updated value of arrays in session
 790     *
 791     */
 792     $_SESSION['update_array'] = $update_array;
 793     $_SESSION['insert_array'] = $insert_array;
 794
 795     for ($j = 0; $j < count($source_tables_uncommon); $j++) {
 796         $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 797         echo '<td align="center"> + ' .$source_tables_uncommon[$j]. "\n" . '</td>
 798         <td align="center">';
 799         /**
 800         * Display the difference only when it has not been applied
 801         */
 802         if (!(in_array($j, $uncommon_table_structure_diff))) {
 803             if (isset($uncommon_tables[$j])) {
 804                 echo '<img class="icon" src="' . $pmaThemeImage  .'new_struct.jpg" width="29"  height="29"
 805                 alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 806                 onClick="showDetails('."'US".$j."'".','."'".null."'".','."'".null."'".','."'".null."'"
 807                 .','."'".null."'".','."'".null."'".', this ,'."'". $source_tables_uncommon[$j] ."'".')"/>' . "\n" .' ';
 808             }
 809         } else {
 810             unset($uncommon_tables[$j]);
 811         }
 812         /**
 813         * Display the difference only when it has not been applied
 814         */
 815         if (!(in_array($j, $uncommon_table_data_diff))) {
 816             if (isset($row_count[$j]) && ($row_count > 0)) {
 817                 echo '<img class="icon" src="' . $pmaThemeImage . 'new_data.jpg" width="29"'.' height="29"
 818                 alt="' . $GLOBALS['strClickToSelect'] . '" onmouseover="change_Image(this);" onmouseout="change_Image(this);"
 819                 onClick="showDetails('."'UD".$j."'".','."'".null."'".','."'".$row_count[$j]."'".','."'"
 820                 .null."'".','."'".null."'".','."'".null."'".', this ,'."'". $source_tables_uncommon[$j] ."'".')" />'. "\n";
 821             }
 822         } else {
 823             unset($row_count[$j]);
 824         }
 825
 826         echo '</td>
 827         </tr>';
 828     }
 829     /**
 830     * placing the latest values of arrays in session
 831     */
 832
 833     $_SESSION['uncommon_tables'] = $uncommon_tables;
 834     $_SESSION['uncommon_tables_row_count'] = $row_count;
 835
 836
 837     /**
 838     * Displaying the target database tables
 839     */
 840     foreach ($target_tables_uncommon as $tbl_nc_name) {
 841         $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 842         echo '<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td><td></td>';
 843         echo '</tr>';
 844     }
 845     echo '</table>';
 846     $odd_row = PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables);
 847     foreach ($source_tables_uncommon as $tbl_nc_name) {
 848         $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 849         if (in_array($tbl_nc_name, $uncommon_tables)) {
 850             echo '<td>' .$tbl_nc_name . "\n" . ' (' .  $GLOBALS['strNotPresent'] . ')</td>';
 851         } else {
 852             echo '<td>' .$tbl_nc_name . "\n" . '</td>';
 853         }
 854         echo '
 855         </tr>';
 856     }
 857     foreach ($target_tables_uncommon as $tbl_nc_name) {
 858         $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 859         echo '<td> - ' .$tbl_nc_name . '</td>';
 860         echo '</tr>';
 861     }
 862     echo '</table>
 863     </div>';
 864
 865     /**
 866     * This "list" div will contain a table and each row will depict information about structure/data diffrence in tables.
 867     * Rows will be generated dynamically as soon as the colored  buttons "D" or "S"  are clicked.
 868     */
 869
 870     echo '<div id="list" style = "overflow: auto; width: 1020px; height: 140px;
 871           border-left: 1px gray solid; border-bottom: 1px gray solid;
 872           padding:0px; margin: 0px">';
 873
 874     echo '<table>
 875           <thead>
 876             <tr style="width: 100%;">
 877                 <th id="table_name" style="width: 10%;" colspan="1">'. $strTable .' </th>
 878                 <th id="str_diff"   style="width: 65%;" colspan="6">'. $strStructureDiff .' </th>
 879                 <th id="data_diff"  style="width: 20%;" colspan="2">'. $strDataDiff .'</th>
 880             </tr>
 881             <tr style="width: 100%;">
 882                 <th style="width: 10%; background-color:#CCCCCC">'. $strTableName .'</th>
 883                 <th style="width: 10%; background-color:#CCCCCC">'. $strCreateTable .'</th>
 884                 <th style="width: 11%; background-color:#CCCCCC">'. $strTableAddColumn .'</th>
 885                 <th style="width: 13%; background-color:#CCCCCC">'. $strTableRemoveColumn .'</th>
 886                 <th style="width: 11%; background-color:#CCCCCC">'. $strTableAlterColumn .'</th>
 887                 <th style="width: 12%; background-color:#CCCCCC">'. $strTableRemoveIndex .'</th>
 888                 <th style="width: 11%; background-color:#CCCCCC">'. $strTableApplyIndex .'</th>
 889                 <th style="width: 10%; background-color:#CCCCCC">'. $strTableUpdateRow .'</th>
 890                 <th style="width: 10%; background-color:#CCCCCC">'. $strTableInsertRow .'</th>
 891             </tr>
 892             </thead>
 893             <tbody></tbody>
 894          </table>
 895         </div>';
 896
 897     /**
 898     *  This fieldset displays the checkbox to confirm deletion of previous rows from target tables
 899     */
 900     echo '<fieldset>
 901     <p><input type= "checkbox" name="delete_rows" id ="delete_rows" />' . $strTableDeleteRows . ' </p>
 902     </fieldset>';
 903
 904     echo '<fieldset class="tblFooters">' . "\n";
 905     echo '<input type="button" name="apply_changes" value="' . $GLOBALS['strApplyChanges'].'"
 906           onClick ="ApplySelectedChanges('."'". $_SESSION['token'] ."'".')" />';
 907     echo '<input type="submit" name="synchronize_db" value="'. $GLOBALS['strSynchronizeDb'] .'" />'
 908           . "\n" . '</fieldset>' . "\n";
 909     echo '</form>';
 910 }
 911
 912 /**
 913 * Displays the page when 'Synchronize Databases' is pressed.
 914 */
 915
 916 if (isset($_REQUEST['synchronize_db'])) {
 917
 918     $src_db = $_SESSION['src_db'];
 919     $trg_db = $_SESSION['trg_db'];
 920     $update_array = $_SESSION['update_array'];
 921     $insert_array = $_SESSION['insert_array'];
 922     $src_username = $_SESSION['src_username'];
 923     $trg_username = $_SESSION['trg_username'];
 924     $src_password = $_SESSION['src_password'];
 925     $trg_password = $_SESSION['trg_password'];
 926     $matching_tables = $_SESSION['matching_tables'];
 927     $matching_tables_keys = $_SESSION['matching_tables_keys'];
 928     $matching_tables_fields = $_SESSION['matching_fields'];
 929     $source_tables_uncommon = $_SESSION['src_uncommon_tables'];
 930     $uncommon_tables_fields = $_SESSION['uncommon_tables_fields'];
 931     $target_tables_uncommon = $_SESSION['target_tables_uncommon'];
 932     $row_count = $_SESSION['uncommon_tables_row_count'];
 933     $uncommon_tables = $_SESSION['uncommon_tables'];
 934     $target_tables = $_SESSION['target_tables'];
 935
 936     $delete_array = $_SESSION['delete_array'];
 937     $uncommon_columns = $_SESSION['uncommon_columns'];
 938     $source_columns = $_SESSION['source_columns'];
 939     $alter_str_array = $_SESSION['alter_str_array'];
 940     $criteria = $_SESSION['criteria'];
 941     $target_tables_keys = $_SESSION['target_tables_keys'];
 942     $add_column_array = $_SESSION['add_column_array'];
 943     $add_indexes_array = $_SESSION['add_indexes_array'];
 944     $alter_indexes_array = $_SESSION['alter_indexes_array'];
 945     $remove_indexes_array = $_SESSION['remove_indexes_array'];
 946     $source_indexes = $_SESSION['source_indexes'];
 947     $target_indexes = $_SESSION['target_indexes'];
 948     $uncommon_cols = $uncommon_columns;
 949
 950    /**
 951    * Display success message.
 952    */
 953     echo '<div class="success">' . $GLOBALS['strTargetDatabaseHasBeenSynchronized'] . '</div>';
 954     /**
 955     * Displaying all the tables of source and target database and now no difference is there.
 956     */
 957     PMA_syncDisplayHeaderSource($src_db);
 958
 959         $odd_row = false;
 960         for($i = 0; $i < count($matching_tables); $i++)
 961         {
 962             $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 963             echo '<td>' . $matching_tables[$i]. "\n" . '</td>
 964             <td></td>
 965             </tr>';
 966         }
 967         for ($j = 0; $j < count($source_tables_uncommon); $j++) {
 968             $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 969             echo '<td> + ' .$source_tables_uncommon[$j]. "\n" . '</td> ';
 970             echo '<td></td>
 971             </tr>';
 972         }
 973         foreach ($target_tables_uncommon as $tbl_nc_name) {
 974             $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 975             echo '<td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </td><td></td>';
 976             echo '</tr>';
 977         }
 978         echo '</table>';
 979         $odd_row = PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables);
 980         foreach ($source_tables_uncommon as $tbl_nc_name) {
 981             $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 982             echo '<td>' .$tbl_nc_name . "\n" . ' </td>
 983             </tr>';
 984         }
 985         foreach ($target_tables_uncommon as $tbl_nc_name) {
 986             $odd_row = PMA_syncDisplayBeginTableRow($odd_row);
 987             echo '<td>  ' .$tbl_nc_name . '</td>';
 988             echo '</tr>';
 989         }
 990     echo '</table> </div>';
 991
 992     /**
 993     * connecting the source and target servers
 994     */
 995     if ('rmt' == $_SESSION['src_type']) {
 996         $src_link = PMA_DBI_connect($src_username, $src_password, $is_controluser = false, $_SESSION['src_server']);
 997     } else {
 998         $src_link = $GLOBALS['userlink'];
 999         // working on current server, so initialize this for tracking
1000         // (does not work if user defined current server as a remote one)
1001         $GLOBALS['db'] = $_SESSION['src_db'];
1002     }
1003     if ('rmt' == $_SESSION['trg_type']) {
1004         $trg_link = PMA_DBI_connect($trg_username, $trg_password, $is_controluser = false, $_SESSION['trg_server']);
1005     } else {
1006         $trg_link = $GLOBALS['userlink'];
1007         // working on current server, so initialize this for tracking
1008         $GLOBALS['db'] = $_SESSION['trg_db'];
1009     }
1010
1011     /**
1012     * Displaying the queries.
1013     */
1014     echo '<h5>' . $GLOBALS['strQueriesExecuted'] . '</h5>';
1015     echo '<div id="serverstatus" style = "overflow: auto; width: 1050px; height: 180px;
1016          border-left: 1px gray solid; border-bottom: 1px gray solid; padding: 0px; margin: 0px"> ';
1017     /**
1018     * Applying all sorts of differences for each matching table
1019     */
1020     for($p = 0; $p <sizeof($matching_tables); $p++) {
1021         /**
1022         *  If the check box is checked for deleting previous rows from the target database tables then
1023         *  first find out rows to be deleted and then delete the rows.
1024         */
1025         if (isset($_REQUEST['delete_rows'])) {
1026             PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $p, $target_tables_keys, $matching_tables_keys,
1027             $trg_db, $trg_link, $src_db, $src_link);
1028
1029             if (isset($delete_array[$p])) {
1030                 PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $p, $target_tables_keys, $delete_array, true);
1031                 unset($delete_array[$p]);
1032             }
1033         }
1034         if (isset($alter_str_array[$p])) {
1035
1036             PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, $source_columns, $alter_str_array, $matching_tables_fields,
1037             $criteria, $matching_tables_keys, $target_tables_keys, $p, true);
1038             unset($alter_str_array[$p]);
1039         }
1040         if (isset($add_column_array[$p])) {
1041
1042             PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $p, $target_tables_keys, $matching_tables_keys,
1043             $trg_db, $trg_link, $src_db, $src_link);
1044
1045             if (isset($delete_array[$p])) {
1046                 PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $p, $target_tables_keys, $delete_array, true);
1047                 unset($delete_array[$p]);
1048             }
1049             PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $source_columns, $add_column_array, $matching_tables_fields,
1050             $criteria, $matching_tables_keys, $target_tables_keys, $uncommon_tables,$uncommon_tables_fields, $p, $uncommon_cols, true);
1051             unset($add_column_array[$p]);
1052         }
1053         if (isset($uncommon_columns[$p])) {
1054
1055             PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $p, true);
1056             unset($uncommon_columns[$p]);
1057         }
1058         if (isset($matching_table_structure_diff) &&
1059             (isset($add_indexes_array[$matching_table_structure_diff[$p]])
1060             || isset($remove_indexes_array[$matching_table_structure_diff[$p]])
1061             || isset($alter_indexes_array[$matching_table_structure_diff[$p]]))) {
1062
1063             PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array,
1064             $remove_indexes_array, $matching_table_structure_diff[$p], true);
1065
1066             unset($add_indexes_array[$matching_table_structure_diff[$p]]);
1067             unset($alter_indexes_array[$matching_table_structure_diff[$p]]);
1068             unset($remove_indexes_array[$matching_table_structure_diff[$p]]);
1069         }
1070
1071         PMA_updateTargetTables($matching_tables, $update_array, $src_db, $trg_db, $trg_link, $p, $matching_tables_keys, true);
1072
1073         PMA_insertIntoTargetTable($matching_tables, $src_db, $trg_db, $src_link, $trg_link , $matching_tables_fields, $insert_array,$p, $matching_tables_keys,
1074         $matching_tables_keys,$source_columns, $add_column_array, $criteria, $target_tables_keys,$uncommon_tables, $uncommon_tables_fields,$uncommon_cols,
1075         $alter_str_array,$source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, $delete_array, $update_array, true);
1076     }
1077
1078     /**
1079     *  Creating and populating tables present in source but absent from target database.
1080     */
1081     for($q = 0; $q < sizeof($source_tables_uncommon) ;$q++) {
1082         if (isset($uncommon_tables[$q])) {
1083             PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, $source_tables_uncommon, $q, $uncommon_tables_fields, true);
1084         }
1085         if (isset($row_count[$q])) {
1086             PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $source_tables_uncommon, $q, $uncommon_tables_fields, true);
1087         }
1088     }
1089     echo "</div>";
1090 }
1091
1092 /**
1093  * Displays the main page when none of the following buttons is pressed
1094  */
1095
1096  if (!isset($_REQUEST['submit_connect']) && !isset($_REQUEST['synchronize_db']) && !isset($_REQUEST['Table_ids']) )
1097 {
1098 /**
1099 * Displays the sub-page heading
1100 */
1101     echo '<h2>' . "\n"
1102     . ($GLOBALS['cfg']['MainPageIconic']
1103     ? '<img class="icon" src="' . $pmaThemeImage . 's_sync.png" width="18"'
1104         .' height="18" alt="" />'
1105     : '')
1106     . $strSynchronize . "\n"
1107     .'</h2>' . "\n";
1108
1109     echo  '<div id="serverstatus">
1110     <form name="connection_form" id="connection_form" method="POST" action="server_synchronize.php"
1111    >' // TODO: add check if all var. are filled in
1112     . PMA_generate_common_hidden_inputs('', '');
1113     echo '<fieldset>'."\n";
1114     echo '<legend>'. $GLOBALS['strSynchronize']. '</legend>'."\n";
1115  /**
1116  * Displays the forms
1117  */
1118
1119     $databases = PMA_DBI_get_databases_full(null, false, null, 'SCHEMA_NAME',
1120         'ASC', 0, true);
1121
1122     foreach ($cons as $type) {
1123       echo '<table id="serverconnection_'.$type.'_remote" class="data">
1124       <tr>
1125           <th colspan="2">'. $GLOBALS['strDatabase_'.$type] .'</th>
1126       </tr>
1127       <tr class="odd">
1128           <td colspan="2" style="text-align: center">
1129              <select name="'.$type.'_type" id="'.$type.'_type">
1130               <option value="rmt">'.$GLOBALS['strRemoteServer'].'</option>
1131               <option value="cur">'.$GLOBALS['strCurrentServer'].'</option>
1132              </select>
1133           </td>
1134       </tr>
1135         <tr class="even" id="'.$type.'tr1">
1136             <td>'. $GLOBALS['strHost']. '</td>
1137             <td><input type="text" name="'.$type.'_host" /></td>
1138         </tr>
1139         <tr class="odd" id="'.$type.'tr2">
1140             <td>'. $GLOBALS['strPort']. '</td>
1141             <td><input type="text" name="'.$type.'_port" value="3306" maxlength="5" size="5" /></td>
1142         </tr>
1143         <tr class="even" id="'.$type.'tr3">
1144             <td>'. $GLOBALS['strSocket']. '</td>
1145             <td><input type="text" name="'.$type.'_socket" /></td>
1146         </tr>
1147         <tr class="odd" id="'.$type.'tr4">
1148             <td>'. $GLOBALS['strUserName']. '</td>
1149             <td><input type="text" name="'.$type.'_username" /></td>
1150         </tr>
1151         <tr class="even" id="'.$type.'tr5">
1152             <td>'. $GLOBALS['strPassword']. '</td>
1153             <td><input type="password" name="'.$type.'_pass" /> </td>
1154         </tr>
1155         <tr class="odd" id="'.$type.'tr6">
1156             <td>'. $GLOBALS['strDatabase']. '</td>
1157             <td><input type="text" name="'.$type.'_db" /></td>
1158         </tr>
1159         <tr class="even" id="'.$type.'tr7" style="display: none;">
1160             <td>'. $GLOBALS['strDatabase']. '</td>
1161             <td>
1162               <select name="'.$type.'_db_sel">
1163         ';
1164         foreach ($databases as $db) {
1165             if ($db['SCHEMA_NAME'] != 'mysql'
1166              && $db['SCHEMA_NAME'] != 'information_schema') {
1167                  echo '         <option>' . $db['SCHEMA_NAME'] . '</option>'."\n";
1168         }
1169         }
1170         echo '
1171               </select>
1172             </td>
1173         </tr>
1174       </table>';
1175
1176     // Add JS to show/hide rows based on the selection
1177       PMA_js(''.
1178         '$(\''.$type.'_type\').addEvent(\'change\',function() {'."\n".
1179         '    if ($(\''.$type.'tr1\').getStyle(\'display\')=="none") {'."\n".
1180         '       for (var i=1; i<7; i++)'."\n".
1181         '               $(\''.$type.'tr\'+i).tween(\'display\', \'table-row\');'."\n".
1182         '       $(\''.$type.'tr7\').tween(\'display\', \'none\');'."\n".
1183         '    }'."\n".
1184         '   else {'."\n".
1185         '       for (var i=1; i<7; i++)'."\n".
1186         '               $(\''.$type.'tr\'+i).tween(\'display\', \'none\');'."\n".
1187         '       $(\''.$type.'tr7\').tween(\'display\', \'table-row\');'."\n".
1188         '    }'."\n".
1189         '});'."\n"
1190         );
1191    }
1192    unset ($types, $type);
1193
1194     echo '
1195     </fieldset>
1196     <fieldset class="tblFooters">
1197         <input type="submit" name="submit_connect" value="' .$GLOBALS['strGo'] .'" id="buttonGo" />
1198     </fieldset>
1199     </form>
1200     </div>
1201     <div class="notice">' . $strSynchronizationNote . '</div>';
1202 }
1203
1204  /**
1205  * Displays the footer
1206  */
1207 require_once './libraries/footer.inc.php';
1208 ?>