Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
tree: 266227903b
Fetching contributors…

Cannot retrieve contributors at this time

1491 lines (1380 sloc) 60.408 kb
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
*
* @package PhpMyAdmin
*/
/**
*
*/
require_once 'libraries/common.inc.php';
/**
* Does the common work
*/
$response = PMA_Response::getInstance();
$header = $response->getHeader();
$scripts = $header->getScripts();
$scripts->addFile('server_synchronize.js');
require_once 'libraries/server_common.inc.php';
/**
* Contains all the functions specific to synchronization
*/
require 'libraries/server_synchronize.lib.php';
/**
* Increases the time limit up to the configured maximum
*/
@set_time_limit($cfg['ExecTimeLimit']);
/**
* Enables warnings on the page
*/
//$cfg['Error_Handler']['display'] = true;
//$cfg['Error_Handler']['gather'] = true;
/**
* Save the value of token generated for this page
*/
if (isset($_REQUEST['token'])) {
$_SESSION['token'] = $_REQUEST['token'];
}
// variable for code saving
$cons = array ("src", "trg");
/**
* Displays the page when 'Go' is pressed
*/
if ((isset($_REQUEST['submit_connect']))) {
foreach ($cons as $con) {
${"{$con}_host"} = $_REQUEST[$con . '_host'];
${"{$con}_username"} = $_REQUEST[$con . '_username'];
${"{$con}_password"} = $_REQUEST[$con . '_pass'];
${"{$con}_port"} = $_REQUEST[$con . '_port'];
${"{$con}_socket"} = $_REQUEST[$con . '_socket'];
${"{$con}_db"} = $_REQUEST[$con . '_db'];
${"{$con}_type"} = $_REQUEST[$con . '_type'];
if (${"{$con}_type"} == 'cur') {
${"{$con}_connection"} = null;
${"{$con}_server"} = null;
${"{$con}_db"} = $_REQUEST[$con . '_db_sel'];
continue;
}
if (isset(${"{$con}_socket"}) && ! empty(${"{$con}_socket"})) {
${"{$con}_server"}['socket'] = ${"{$con}_socket"};
} else {
${"{$con}_server"}['host'] = ${"{$con}_host"};
if (isset(${"{$con}_port"})
&& ! empty(${"{$con}_port"})
&& ((int)${"{$con}_port"} * 1) > 0
) {
${"{$con}_server"}['port'] = (int)${"{$con}_port"};
}
}
${"{$con}_connection"} = PMA_DBI_connect(
${"{$con}_username"},
${"{$con}_password"}, $is_controluser = false,
${"{$con}_server"}, $auxiliary_connection = true
);
} // end foreach ($cons as $con)
if ((! $src_connection && $src_type != 'cur')
|| (! $trg_connection && $trg_type != 'cur')
) {
/**
* Displays the connection error string if
* connections are not established
*/
echo '<div class="error">';
if (! $src_connection && $src_type != 'cur') {
echo __('Could not connect to the source') . '<br />';
}
if (! $trg_connection && $trg_type != 'cur') {
echo __('Could not connect to the target');
}
echo '</div>';
unset($_REQUEST['submit_connect']);
} else {
/**
* Creating the link object for both source and target databases and
* selecting the source and target databases using these links
*/
foreach ($cons as $con) {
if (${"{$con}_connection"} != null) {
${"{$con}_link"} = PMA_DBI_connect(
${"{$con}_username"},
${"{$con}_password"},
$is_controluser = false,
${"{$con}_server"}
);
} else {
${"{$con}_link"} = null;
}
${"{$con}_db_selected"} = PMA_DBI_select_db(
${"{$con}_db"},
${"{$con}_link"}
);
${"{$con}_version"} = PMA_DBI_fetch_value(
'SELECT VERSION()',
0,
0,
${"{$con}_link"}
);
${"{$con}_is_drizzle"} = (bool)preg_match(
'/\d{4}\./',
${"{$con}_version"}
);
} // end foreach ($cons as $con)
if (($src_db_selected != 1) || ($trg_db_selected != 1)) {
/**
* Displays error string if the database(s) did not exist
*/
echo '<div class="error">';
if ($src_db_selected != 1) {
echo sprintf(
__('\'%s\' database does not exist.'),
htmlspecialchars($src_db)
);
}
if ($trg_db_selected != 1) {
echo sprintf(
__('\'%s\' database does not exist.'),
htmlspecialchars($trg_db)
);
}
echo '</div>';
unset($_REQUEST['submit_connect']);
} else if (($src_db_selected == 1) && ($trg_db_selected == 1)) {
/**
* Using PMA_DBI_get_tables() to get all the tables
* from target and source databases.
*/
$src_tables = PMA_DBI_get_tables($src_db, $src_link);
$source_tables_num = sizeof($src_tables);
$trg_tables = PMA_DBI_get_tables($trg_db, $trg_link);
$target_tables_num = sizeof($trg_tables);
/**
* initializing arrays to save matching and non-matching
* table names from target and source databases.
*/
$unmatched_num_src = 0;
$source_tables_uncommon = array();
$unmatched_num_trg = 0;
$target_tables_uncommon = array();
$matching_tables = array();
$matching_tables_num = 0;
/**
* Using PMA_getMatchingTables to find which of the tables' names match
* in target and source database.
*/
PMA_getMatchingTables(
$trg_tables,
$src_tables,
$matching_tables,
$source_tables_uncommon
);
/**
* Finding the uncommon tables for the target database
* using function PMA_getNonMatchingTargetTables()
*/
PMA_getNonMatchingTargetTables(
$trg_tables,
$matching_tables,
$target_tables_uncommon
);
/**
* Initializing several arrays to save the data and structure
* difference between the source and target databases.
*/
// number of rows in source table that needs to be created in target
// database
$row_count = array();
// number of fields in each matching table
$fields_num = array();
// stores the primary key values for target tables that have
// excessive rows than corresponding source tables.
$delete_array = array();
// stores the primary key values for the rows in each source table
// that are not present in target tables.
$insert_array = array(array(array()));
// stores the primary key values, name of field to be updated,
// value of the field to be updated for each row of matching table.
$update_array = array(array(array()));
// contains the fields' names for each matching table
$matching_tables_fields = array();
// contains the primary keys' names for each matching table
$matching_tables_keys = array();
// coantains the fields for all the source tables that are not
// present in target
$uncommon_tables_fields = array();
$matching_tables_num = sizeof($matching_tables);
// contains the full columns' information for all the source
// tables' columns
$source_columns = array();
// contains the full columns' information for all the target
// tables' columns
$target_columns = array();
// contains names of columns present in source table but absent from
// the corresponding target table
$uncommon_columns = array();
// contains indexes on all the source tables
$source_indexes = array();
// contains indexes on all the target tables
$target_indexes = array();
// contains the indexes name present in source but absent from
// target tables
$add_indexes_array = array();
// contains the keys of all the target tables
$target_tables_keys = array();
// contains the names of all the indexes for each table that need
// to be altered in target database
$alter_indexes_array = array();
// contains the names of indexes that are excessive in target tables
$remove_indexes_array = array();
// contains the criteria for each column that needs to be altered
// in target tables
$alter_str_array = array(array());
// contains the name of columns that need to be added in target tables
$add_column_array = array(array());
/**
* The criteria array contains all the criteria against which columns
* are compared for differences.
*/
$criteria = array(
'Field',
'Type',
'Null',
'Collation',
'Key',
'Default',
'Comment'
);
for ($i = 0; $i < sizeof($matching_tables); $i++) {
/**
* Finding out all the differences structure, data and index diff
* for all the matching tables only
*/
PMA_dataDiffInTables(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $matching_tables_fields, $update_array,
$insert_array, $delete_array, $fields_num, $i,
$matching_tables_keys
);
PMA_structureDiffInTables(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $source_columns, $target_columns,
$alter_str_array, $add_column_array, $uncommon_columns,
$criteria, $target_tables_keys, $i
);
PMA_indexesDiffInTables(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $source_indexes, $target_indexes,
$add_indexes_array, $alter_indexes_array,
$remove_indexes_array, $i
);
}
for ($j = 0; $j < sizeof($source_tables_uncommon); $j++) {
/**
* Finding out the number of rows to be added in tables
* that need to be added in target database
*/
PMA_dataDiffInUncommonTables(
$source_tables_uncommon, $src_db,
$src_link, $j, $row_count
);
}
/**
* Storing all arrays in session for use when page is reloaded
* for each button press
*/
$_SESSION['matching_tables'] = $matching_tables;
$_SESSION['update_array'] = $update_array;
$_SESSION['insert_array'] = $insert_array;
$_SESSION['src_db'] = $src_db;
$_SESSION['trg_db'] = $trg_db;
$_SESSION['matching_fields'] = $matching_tables_fields;
$_SESSION['src_uncommon_tables'] = $source_tables_uncommon;
$_SESSION['src_username'] = $src_username ;
$_SESSION['trg_username'] = $trg_username;
$_SESSION['src_password'] = $src_password;
$_SESSION['trg_password'] = $trg_password;
$_SESSION['trg_password'] = $trg_password;
$_SESSION['src_server'] = $src_server;
$_SESSION['trg_server'] = $trg_server;
$_SESSION['src_type'] = $src_type;
$_SESSION['trg_type'] = $trg_type;
$_SESSION['matching_tables_keys'] = $matching_tables_keys;
$_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
$_SESSION['uncommon_tables_row_count'] = $row_count;
$_SESSION['target_tables_uncommon'] = $target_tables_uncommon;
$_SESSION['uncommon_tables'] = $source_tables_uncommon;
$_SESSION['delete_array'] = $delete_array;
$_SESSION['uncommon_columns'] = $uncommon_columns;
$_SESSION['source_columns'] = $source_columns;
$_SESSION['alter_str_array'] = $alter_str_array;
$_SESSION['target_tables_keys'] = $target_tables_keys;
$_SESSION['add_column_array'] = $add_column_array;
$_SESSION['criteria'] = $criteria;
$_SESSION['target_tables'] = $trg_tables;
$_SESSION['add_indexes_array'] = $add_indexes_array;
$_SESSION['alter_indexes_array'] = $alter_indexes_array;
$_SESSION['remove_indexes_array'] = $remove_indexes_array;
$_SESSION['source_indexes'] = $source_indexes;
$_SESSION['target_indexes'] = $target_indexes;
/**
* Displays the sub-heading and icons showing Structure Synchronization
* and Data Synchronization
*/
?>
<form name="synchronize_form" id="synchronize_form" method="post" action="server_synchronize.php">
<?php echo PMA_generate_common_hidden_inputs('', ''); ?>
<table width="40%">
<tr>
<td>
<img class="icon" src="<?php echo $pmaThemeImage; ?>new_struct.png" width="16" height="16" alt="" />
<?php echo __('Structure Synchronization'); ?>
</td>
<td>
<img class="icon" src="<?php echo $pmaThemeImage; ?>new_data.png" width="16" height="16" alt="" />
<?php echo __('Data Synchronization'); ?>
</td>
</tr>
</table>
<?php
/**
* Displays the tables containing the source tables names,
* their difference with the target tables and target tables names.
*/
PMA_syncDisplayHeaderCompare($src_db, $trg_db);
$rows = array();
/**
* Display the matching tables' names and difference, first
*/
for ($i = 0; $i < count($matching_tables); $i++) {
/**
* Calculating the number of updates for each matching table
*/
if (isset($update_array[$i]) && isset($update_array[$i][0])
&& ! empty($matching_tables_keys[$i][0])
&& isset($update_array[$i][0][$matching_tables_keys[$i][0]])
) {
$num_of_updates = sizeof($update_array[$i]);
} else {
$num_of_updates = 0;
}
/**
* Calculating the number of insertions for each matching table
*/
if (isset($insert_array[$i]) && isset($insert_array[$i][0])
&& ! empty($matching_tables_keys[$i])
&& isset($insert_array[$i][0][$matching_tables_keys[$i][0]])
) {
$num_of_insertions = sizeof($insert_array[$i]);
} else {
$num_of_insertions = 0;
}
/**
* Calculating the number of alter columns, number of columns to be
* added, number of columns to be removed,
* number of index to be added and removed.
*/
$num_alter_cols = 0;
$num_insert_cols = 0;
$num_remove_cols = 0;
$num_add_index = 0;
$num_remove_index = 0;
if (isset($alter_str_array[$i])) {
$num_alter_cols = sizeof($alter_str_array[$i]);
}
if (isset($add_column_array[$i])) {
$num_insert_cols = sizeof($add_column_array[$i]);
}
if (isset($uncommon_columns[$i])) {
$num_remove_cols = sizeof($uncommon_columns[$i]);
}
if (isset($add_indexes_array[$i])) {
$num_add_index = sizeof($add_indexes_array[$i]);
}
if (isset($remove_indexes_array[$i])) {
$num_remove_index = sizeof($remove_indexes_array[$i]);
}
if (isset($alter_indexes_array[$i])) {
$num_add_index += sizeof($alter_indexes_array[$i]);
$num_remove_index += sizeof($alter_indexes_array[$i]);
}
$btn_structure_params = null;
$btn_data_params = null;
/**
* Display the red button of structure synchronization if there
* exists any structure difference or index difference.
*/
if (($num_alter_cols > 0)
|| ($num_insert_cols > 0)
|| ($num_remove_cols > 0)
|| ($num_add_index > 0)
|| ($num_remove_index > 0)
) {
$btn_structure_params = array(
$i,
$num_alter_cols,
$num_insert_cols,
$num_remove_cols,
$num_add_index,
$num_remove_index
);
}
/**
* Display the green button of data synchronization if there exists
* any data difference.
*/
if ((isset($update_array[$i])
|| isset($insert_array[$i]))
&& ! empty($matching_tables_keys[$i])
) {
if (isset($update_array[$i][0][$matching_tables_keys[$i][0]])
|| isset($insert_array[$i][0][$matching_tables_keys[$i][0]])
) {
$btn_data_params = array($i, $num_of_updates,
$num_of_insertions, null, null, null);
}
}
$rows[] = array(
'src_table_name' => $matching_tables[$i],
'dst_table_name' => $matching_tables[$i],
'btn_type' => 'M',
'btn_structure' => $btn_structure_params,
'btn_data' => $btn_data_params
);
}
/**
* Displays the tables' names present in source but missing from target
*/
for ($j = 0; $j < count($source_tables_uncommon); $j++) {
$row = array(
'src_table_name' => '+ ' . $source_tables_uncommon[$j],
'dst_table_name' => $source_tables_uncommon[$j] . ' (' . __('not present') . ')',
'btn_type' => 'U',
'btn_structure' => array($j, null, null, null, null, null),
'btn_data' => null
);
if ($row_count[$j] > 0) {
$row['btn_data'] = array($j, null, $row_count[$j], null, null, null);
}
$rows[] = $row;
}
foreach ($target_tables_uncommon as $tbl_nc_name) {
$rows[] = array(
'src_table_name' => '',
'dst_table_name' => $tbl_nc_name);
}
/**
* Displays the target tables names
*/
PMA_syncDisplayDataCompare($rows);
echo '</table>
</div>
</fieldset>';
/**
* This "list" div will contain a table and each row will depict
* information about structure/data difference in tables.
* Rows will be generated dynamically as soon as the colored
* buttons "D" or "S" are clicked.
*/
echo '<fieldset style="padding:0"><div id="list" style="overflow:auto; height:140px; padding:1em">
<table>
<thead>
<tr style="width: 100%;">
<th id="table_name" style="width: 10%;" colspan="1">' . __('Table') . ' </th>
<th id="str_diff" style="width: 65%;" colspan="6">' . __('Structure Difference') . ' </th>
<th id="data_diff" style="width: 20%;" colspan="2">' . __('Data Difference') . '</th>
</tr>
<tr style="width: 100%;">
<th style="width: 10%;">' . __('Table name') . '</th>
<th style="width: 10%;">' . __('Create table'). '</th>
<th style="width: 11%;">' . __('Add column(s)') . '</th>
<th style="width: 13%;">' . __('Remove column(s)') . '</th>
<th style="width: 11%;">' . __('Alter column(s)') . '</th>
<th style="width: 12%;">' . __('Remove index(s)') . '</th>
<th style="width: 11%;">' . __('Apply index(s)') . '</th>
<th style="width: 10%;">'. __('Update row(s)') . '</th>
<th style="width: 10%;">' . __('Insert row(s)') . '</th>
</tr>
</thead>
<tbody></tbody>
</table>
</div></fieldset>';
/**
* This fieldset displays the checkbox to confirm deletion of previous
* rows from target tables
*/
echo '<fieldset>
<p><input type= "checkbox" name="delete_rows" id ="delete_rows" /><label for="delete_rows">'
. __('Would you like to delete all the previous rows from target tables?')
. '</label> </p>
</fieldset>
<fieldset class="tblFooters">';
echo '<input type="button" name="apply_changes" value="'
. __('Apply Selected Changes')
. '" onclick ="ApplySelectedChanges('
. "'" . htmlspecialchars($_SESSION['token']) . "'" . ')" />';
echo '<input type="submit" name="synchronize_db" value="'
. __('Synchronize Databases') . '" />' . '</fieldset>';
echo '</form>';
}
}
} // end if ((isset($_REQUEST['submit_connect'])))
/**
* Display the page when 'Apply Selected Changes' is pressed
*/
if (isset($_REQUEST['Table_ids'])) {
/**
* Displays success message
*/
echo '<div class="success">'
. __('Selected target tables have been synchronized with source tables.')
. '</div>';
$src_db = $_SESSION['src_db'];
$trg_db = $_SESSION['trg_db'];
$update_array = $_SESSION['update_array'];
$insert_array = $_SESSION['insert_array'];
$src_username = $_SESSION['src_username'];
$trg_username = $_SESSION['trg_username'];
$src_password = $_SESSION['src_password'];
$trg_password = $_SESSION['trg_password'];
$src_server = $_SESSION['src_server'];
$trg_server = $_SESSION['trg_server'];
$src_type = $_SESSION['src_type'];
$trg_type = $_SESSION['trg_type'];
$uncommon_tables = $_SESSION['uncommon_tables'];
$matching_tables = $_SESSION['matching_tables'];
$matching_tables_keys = $_SESSION['matching_tables_keys'];
$matching_tables_fields = $_SESSION['matching_fields'];
$source_tables_uncommon = $_SESSION['src_uncommon_tables'];
$uncommon_tables_fields = $_SESSION['uncommon_tables_fields'];
$target_tables_uncommon = $_SESSION['target_tables_uncommon'];
$row_count = $_SESSION['uncommon_tables_row_count'];
$target_tables = $_SESSION['target_tables'];
$delete_array = $_SESSION['delete_array'];
$uncommon_columns = $_SESSION['uncommon_columns'];
$source_columns = $_SESSION['source_columns'];
$alter_str_array = $_SESSION['alter_str_array'];
$criteria = $_SESSION['criteria'];
$target_tables_keys = $_SESSION['target_tables_keys'];
$add_column_array = $_SESSION['add_column_array'];
$add_indexes_array = $_SESSION['add_indexes_array'];
$alter_indexes_array = $_SESSION['alter_indexes_array'];
$remove_indexes_array = $_SESSION['remove_indexes_array'];
$source_indexes = $_SESSION['source_indexes'];
$target_indexes = $_SESSION['target_indexes'];
$uncommon_cols = $uncommon_columns;
/**
* Creating link object for source and target databases
*/
foreach ($cons as $con) {
if (${"{$con}_type"} != "cur") {
${"{$con}_link"} = PMA_DBI_connect(
${"{$con}_username"},
${"{$con}_password"}, $is_controluser = false, ${"{$con}_server"}
);
} else {
${"{$con}_link"} = null;
// working on current server, so initialize this for tracking
// (does not work if user defined current server as a remote one)
$GLOBALS['db'] = ${"{$con}_db"};
}
} // end foreach ($cons as $con)
/**
* Initializing arrays to save the table ids whose data and structure
* difference is to be applied
*/
// stores id of matching table having data difference
$matching_table_data_diff = array();
// stores id of matching tables having structure difference
$matching_table_structure_diff = array();
// stores id of uncommon tables having structure difference
$uncommon_table_structure_diff = array();
// stores id of uncommon tables having data difference
$uncommon_table_data_diff = array();
for ($i = 0; isset($_REQUEST[$i]); $i++ ) {
if (isset($_REQUEST[$i])) {
$table_id = explode("US", $_REQUEST[$i]);
if (isset($table_id[1])) {
$uncommon_table_structure_diff[] = $table_id[1];
}
$table_id = explode("UD", $_REQUEST[$i]);
if (isset($table_id[1])) {
$uncommon_table_data_diff[] = $table_id[1];
}
$table_id = explode("MS", $_REQUEST[$i]);
if (isset($table_id[1])) {
$matching_table_structure_diff[] = $table_id[1];
}
$table_id = explode("MD", $_REQUEST[$i]);
if (isset($table_id[1])) {
$matching_table_data_diff[] = $table_id[1];
}
}
} // end for
/**
* Applying the structure difference on selected matching tables
*/
for ($q = 0; $q < sizeof($matching_table_structure_diff); $q++) {
if (isset($alter_str_array[$matching_table_structure_diff[$q]])) {
PMA_alterTargetTableStructure(
$trg_db, $trg_link, $matching_tables,
$source_columns, $alter_str_array, $matching_tables_fields,
$criteria, $matching_tables_keys, $target_tables_keys,
$matching_table_structure_diff[$q], false
);
unset($alter_str_array[$matching_table_structure_diff[$q]]);
}
if (isset($add_column_array[$matching_table_structure_diff[$q]])) {
PMA_findDeleteRowsFromTargetTables(
$delete_array, $matching_tables,
$matching_table_structure_diff[$q], $target_tables_keys,
$matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link
);
if (isset($delete_array[$matching_table_structure_diff[$q]])) {
PMA_deleteFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$matching_table_structure_diff[$q], $target_tables_keys,
$delete_array, false
);
unset($delete_array[$matching_table_structure_diff[$q]]);
}
PMA_addColumnsInTargetTable(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $source_columns, $add_column_array,
$matching_tables_fields, $criteria, $matching_tables_keys,
$target_tables_keys, $uncommon_tables, $uncommon_tables_fields,
$matching_table_structure_diff[$q], $uncommon_cols, false
);
unset($add_column_array[$matching_table_structure_diff[$q]]);
}
if (isset($uncommon_columns[$matching_table_structure_diff[$q]])) {
PMA_removeColumnsFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$uncommon_columns, $matching_table_structure_diff[$q], false
);
unset($uncommon_columns[$matching_table_structure_diff[$q]]);
}
if (isset($add_indexes_array[$matching_table_structure_diff[$q]])
|| isset($remove_indexes_array[$matching_table_structure_diff[$q]])
|| isset($alter_indexes_array[$matching_table_structure_diff[$q]])
) {
PMA_applyIndexesDiff(
$trg_db, $trg_link, $matching_tables,
$source_indexes, $target_indexes, $add_indexes_array,
$alter_indexes_array, $remove_indexes_array,
$matching_table_structure_diff[$q], false
);
unset($add_indexes_array[$matching_table_structure_diff[$q]]);
unset($alter_indexes_array[$matching_table_structure_diff[$q]]);
unset($remove_indexes_array[$matching_table_structure_diff[$q]]);
}
}
/**
* Applying the data difference. First checks if structure diff is applied
* or not. If not, then apply structure difference first then apply data
* difference.
*/
for ($p = 0; $p < sizeof($matching_table_data_diff); $p++) {
if ($_REQUEST['checked'] == 'true') {
PMA_findDeleteRowsFromTargetTables(
$delete_array, $matching_tables,
$matching_table_data_diff[$p], $target_tables_keys,
$matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link
);
if (isset($delete_array[$matching_table_data_diff[$p]])) {
PMA_deleteFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$matching_table_data_diff[$p], $target_tables_keys,
$delete_array, false
);
unset($delete_array[$matching_table_data_diff[$p]]);
}
}
if (isset($alter_str_array[$matching_table_data_diff[$p]])) {
PMA_alterTargetTableStructure(
$trg_db, $trg_link, $matching_tables,
$source_columns, $alter_str_array, $matching_tables_fields,
$criteria, $matching_tables_keys, $target_tables_keys,
$matching_table_data_diff[$p], false
);
unset($alter_str_array[$matching_table_data_diff[$p]]);
}
if (isset($add_column_array[$matching_table_data_diff[$p]])) {
PMA_findDeleteRowsFromTargetTables(
$delete_array, $matching_tables,
$matching_table_data_diff[$p], $target_tables_keys,
$matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link
);
if (isset($delete_array[$matching_table_data_diff[$p]])) {
PMA_deleteFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$matching_table_data_diff[$p], $target_tables_keys,
$delete_array, false
);
unset($delete_array[$matching_table_data_diff[$p]]);
}
PMA_addColumnsInTargetTable(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $source_columns, $add_column_array,
$matching_tables_fields, $criteria, $matching_tables_keys,
$target_tables_keys, $uncommon_tables, $uncommon_tables_fields,
$matching_table_data_diff[$p], $uncommon_cols, false
);
unset($add_column_array[$matching_table_data_diff[$p]]);
}
if (isset($uncommon_columns[$matching_table_data_diff[$p]])) {
PMA_removeColumnsFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$uncommon_columns, $matching_table_data_diff[$p], false
);
unset($uncommon_columns[$matching_table_data_diff[$p]]);
}
if ((isset($matching_table_structure_diff[$q])
&& isset($add_indexes_array[$matching_table_structure_diff[$q]]))
|| (isset($matching_table_structure_diff[$q])
&& isset($remove_indexes_array[$matching_table_structure_diff[$q]]))
|| (isset($matching_table_structure_diff[$q])
&& isset($alter_indexes_array[$matching_table_structure_diff[$q]]))
) {
PMA_applyIndexesDiff(
$trg_db, $trg_link, $matching_tables,
$source_indexes, $target_indexes, $add_indexes_array,
$alter_indexes_array, $remove_indexes_array,
$matching_table_structure_diff[$q], false
);
unset($add_indexes_array[$matching_table_structure_diff[$q]]);
unset($alter_indexes_array[$matching_table_structure_diff[$q]]);
unset($remove_indexes_array[$matching_table_structure_diff[$q]]);
}
/**
* Applying the data difference.
*/
PMA_updateTargetTables(
$matching_tables, $update_array, $src_db, $trg_db,
$trg_link, $matching_table_data_diff[$p], $matching_tables_keys, false
);
PMA_insertIntoTargetTable(
$matching_tables, $src_db, $trg_db, $src_link,
$trg_link, $matching_tables_fields, $insert_array,
$matching_table_data_diff[$p], $matching_tables_keys, $source_columns,
$add_column_array, $criteria, $target_tables_keys, $uncommon_tables,
$uncommon_tables_fields, $uncommon_cols, $alter_str_array,
$source_indexes, $target_indexes, $add_indexes_array,
$alter_indexes_array, $delete_array, $update_array, false
);
}
/**
* Updating the session variables to the latest values of the arrays.
*/
$_SESSION['delete_array'] = $delete_array;
$_SESSION['uncommon_columns'] = $uncommon_columns;
$_SESSION['alter_str_array'] = $alter_str_array;
$_SESSION['add_column_array'] = $add_column_array;
$_SESSION['add_indexes_array'] = $add_indexes_array;
$_SESSION['remove_indexes_array'] = $remove_indexes_array;
$_SESSION['insert_array'] = $insert_array;
$_SESSION['update_array'] = $update_array;
/**
* Applying structure difference to selected non-matching tables
* (present in Source but absent from Target).
*/
for ($s = 0; $s < sizeof($uncommon_table_structure_diff); $s++) {
PMA_createTargetTables(
$src_db, $trg_db, $src_link, $trg_link,
$uncommon_tables, $uncommon_table_structure_diff[$s],
$uncommon_tables_fields, false
);
$_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
unset($uncommon_tables[$uncommon_table_structure_diff[$s]]);
}
/**
* Applying data difference to selected non-matching tables
* (present in Source but absent from Target).
* Before data synchronization, structure synchronization is confirmed.
*/
for ($r = 0; $r < sizeof($uncommon_table_data_diff); $r++) {
if (!(in_array($uncommon_table_data_diff[$r], $uncommon_table_structure_diff))) {
if (isset($uncommon_tables[$uncommon_table_data_diff[$r]])) {
PMA_createTargetTables(
$src_db, $trg_db, $src_link, $trg_link,
$uncommon_tables, $uncommon_table_data_diff[$r],
$uncommon_tables_fields, false
);
$_SESSION['uncommon_tables_fields'] = $uncommon_tables_fields;
unset($uncommon_tables[$uncommon_table_data_diff[$r]]);
}
}
PMA_populateTargetTables(
$src_db, $trg_db, $src_link, $trg_link,
$source_tables_uncommon, $uncommon_table_data_diff[$r],
$_SESSION['uncommon_tables_fields'], false
);
unset($row_count[$uncommon_table_data_diff[$r]]);
}
/**
* Again all the tables from source and target database are displayed with
* their differences. The differences have been removed from tables that
* have been synchronized
*/
echo '<form name="applied_difference" id="synchronize_form" method="post" action="server_synchronize.php">'
. PMA_generate_common_hidden_inputs('', '');
PMA_syncDisplayHeaderCompare($src_db, $trg_db);
$rows = array();
for ($i = 0; $i < count($matching_tables); $i++) {
$num_alter_cols = 0;
$num_insert_cols = 0;
$num_remove_cols = 0;
$num_add_index = 0;
$num_remove_index = 0;
if (isset($alter_str_array[$i])) {
$num_alter_cols = sizeof($alter_str_array[$i]);
}
if (isset($add_column_array[$i])) {
$num_insert_cols = sizeof($add_column_array[$i]);
}
if (isset($uncommon_columns[$i])) {
$num_remove_cols = sizeof($uncommon_columns[$i]);
}
if (isset($add_indexes_array[$i])) {
$num_add_index = sizeof($add_indexes_array[$i]);
}
if (isset($remove_indexes_array[$i])) {
$num_remove_index = sizeof($remove_indexes_array[$i]);
}
$btn_structure_params = null;
$btn_data_params = null;
if (($num_alter_cols > 0)
|| ($num_insert_cols > 0)
|| ($num_remove_cols > 0)
|| ($num_add_index > 0)
|| ($num_remove_index > 0)
) {
$btn_structure_params = array($i, $num_alter_cols, $num_insert_cols,
$num_remove_cols, $num_add_index, $num_remove_index);
}
if (! (in_array($i, $matching_table_data_diff))) {
if (isset($matching_tables_keys[$i][0])
&& isset($update_array[$i][0][$matching_tables_keys[$i][0]])
) {
if (isset($update_array[$i])) {
$num_of_updates = sizeof($update_array[$i]);
} else {
$num_of_updates = 0;
}
} else {
$num_of_updates = 0;
}
if (isset($matching_tables_keys[$i][0])
&& isset($insert_array[$i][0][$matching_tables_keys[$i][0]])
) {
if (isset($insert_array[$i])) {
$num_of_insertions = sizeof($insert_array[$i]);
} else {
$num_of_insertions = 0;
}
} else {
$num_of_insertions = 0;
}
if ((isset($matching_tables_keys[$i][0])
&& isset($update_array[$i][0][$matching_tables_keys[$i][0]]))
|| (isset($matching_tables_keys[$i][0])
&& isset($insert_array[$i][0][$matching_tables_keys[$i][0]]))
) {
$btn_data_params = array($i, $num_of_updates, $num_of_insertions,
null, null, null);
}
} else {
unset($update_array[$i]);
unset($insert_array[$i]);
}
$rows[] = array(
'src_table_name' => $matching_tables[$i],
'dst_table_name' => $matching_tables[$i],
'btn_type' => 'M',
'btn_structure' => $btn_structure_params,
'btn_data' => $btn_data_params
);
}
/**
* placing updated value of arrays in session
*
*/
$_SESSION['update_array'] = $update_array;
$_SESSION['insert_array'] = $insert_array;
for ($j = 0; $j < count($source_tables_uncommon); $j++) {
$btn_structure_params = null;
$btn_data_params = null;
/**
* Display the difference only when it has not been applied
*/
if (!(in_array($j, $uncommon_table_structure_diff))) {
if (isset($uncommon_tables[$j])) {
$btn_structure_params = array($j, null, null, null, null, null);
}
$dst_table_name = $source_tables_uncommon[$j] . ' (' . __('not present') . ')';
} else {
unset($uncommon_tables[$j]);
$dst_table_name = $source_tables_uncommon[$j];
}
/**
* Display the difference only when it has not been applied
*/
if (!(in_array($j, $uncommon_table_data_diff))) {
if (isset($row_count[$j]) && ($row_count[$j] > 0)) {
$btn_data_params = array($j, null, $row_count[$j], null, null, null);
}
} else {
unset($row_count[$j]);
}
$rows[] = array(
'src_table_name' => $source_tables_uncommon[$j],
'dst_table_name' => $dst_table_name,
'btn_type' => 'U',
'btn_structure' => $btn_structure_params,
'btn_data' => $btn_data_params
);
}
/**
* placing the latest values of arrays in session
*/
$_SESSION['uncommon_tables'] = $uncommon_tables;
$_SESSION['uncommon_tables_row_count'] = $row_count;
/**
* Displaying the target database tables
*/
foreach ($target_tables_uncommon as $tbl_nc_name) {
$rows[] = array(
'src_table_name' => '',
'dst_table_name' => $tbl_nc_name);
}
PMA_syncDisplayDataCompare($rows);
echo '</table>
</div>
</fieldset>';
/**
* This "list" div will contain a table and each row will depict information about
* structure/data difference in tables.
* Rows will be generated dynamically as soon as the colored buttons "D" or "S"
* are clicked.
*/
echo '<fieldset style="padding:0"><div id="list" style = "overflow:auto; height:140px; padding:1em">';
echo '<table>
<thead>
<tr style="width: 100%;">
<th id="table_name" style="width: 10%;" colspan="1">' . __('Table') . ' </th>
<th id="str_diff" style="width: 65%;" colspan="6">' . __('Structure Difference') . ' </th>
<th id="data_diff" style="width: 20%;" colspan="2">' . __('Data Difference') . '</th>
</tr>
<tr style="width: 100%;">
<th style="width: 10%;">' . __('Table name') . '</th>
<th style="width: 10%;">' . __('Create table'). '</th>
<th style="width: 11%;">' . __('Add column(s)') . '</th>
<th style="width: 13%;">' . __('Remove column(s)') . '</th>
<th style="width: 11%;">' . __('Alter column(s)') . '</th>
<th style="width: 12%;">' . __('Remove index(s)') . '</th>
<th style="width: 11%;">' . __('Apply index(s)') . '</th>
<th style="width: 10%;">' . __('Update row(s)') . '</th>
<th style="width: 10%;">' . __('Insert row(s)') . '</th>
</tr>
</thead>
<tbody></tbody>
</table>
</div></fieldset>';
/**
* This fieldset displays the checkbox to confirm deletion of previous
* rows from target tables
*/
echo '<fieldset>
<p><input type="checkbox" name="delete_rows" id ="delete_rows" /><label for="delete_rows">'
. __('Would you like to delete all the previous rows from target tables?') . '</label> </p>
</fieldset>';
echo '<fieldset class="tblFooters">';
echo '<input type="button" name="apply_changes" value="'
. __('Apply Selected Changes') . '" onclick ="ApplySelectedChanges('
. "'" . htmlspecialchars($_SESSION['token']) . "'" .')" />';
echo '<input type="submit" name="synchronize_db" value="'
. __('Synchronize Databases') . '" />'
. '</fieldset>';
echo '</form>';
}
/**
* Displays the page when 'Synchronize Databases' is pressed.
*/
if (isset($_REQUEST['synchronize_db'])) {
$src_db = $_SESSION['src_db'];
$trg_db = $_SESSION['trg_db'];
$update_array = $_SESSION['update_array'];
$insert_array = $_SESSION['insert_array'];
$src_username = $_SESSION['src_username'];
$trg_username = $_SESSION['trg_username'];
$src_password = $_SESSION['src_password'];
$trg_password = $_SESSION['trg_password'];
$matching_tables = $_SESSION['matching_tables'];
$matching_tables_keys = $_SESSION['matching_tables_keys'];
$matching_tables_fields = $_SESSION['matching_fields'];
$source_tables_uncommon = $_SESSION['src_uncommon_tables'];
$uncommon_tables_fields = $_SESSION['uncommon_tables_fields'];
$target_tables_uncommon = $_SESSION['target_tables_uncommon'];
$row_count = $_SESSION['uncommon_tables_row_count'];
$uncommon_tables = $_SESSION['uncommon_tables'];
$target_tables = $_SESSION['target_tables'];
$delete_array = $_SESSION['delete_array'];
$uncommon_columns = $_SESSION['uncommon_columns'];
$source_columns = $_SESSION['source_columns'];
$alter_str_array = $_SESSION['alter_str_array'];
$criteria = $_SESSION['criteria'];
$target_tables_keys = $_SESSION['target_tables_keys'];
$add_column_array = $_SESSION['add_column_array'];
$add_indexes_array = $_SESSION['add_indexes_array'];
$alter_indexes_array = $_SESSION['alter_indexes_array'];
$remove_indexes_array = $_SESSION['remove_indexes_array'];
$source_indexes = $_SESSION['source_indexes'];
$target_indexes = $_SESSION['target_indexes'];
$uncommon_cols = $uncommon_columns;
/**
* Display success message.
*/
echo '<div class="success">'
. __('Target database has been synchronized with source database')
. '</div>';
/**
* Displaying all the tables of source and target database
* and now no difference is there.
*/
PMA_syncDisplayHeaderCompare($src_db, $trg_db);
$rows = array();
for ($i = 0; $i < count($matching_tables); $i++) {
$rows[] = array(
'src_table_name' => $matching_tables[$i],
'dst_table_name' => $matching_tables[$i]);
}
foreach ($source_tables_uncommon as $tbl_nc_name) {
$rows[] = array(
'src_table_name' => '+ ' . $tbl_nc_name,
'dst_table_name' => $tbl_nc_name);
}
foreach ($target_tables_uncommon as $tbl_nc_name) {
$rows[] = array(
'src_table_name' => '',
'dst_table_name' => $tbl_nc_name);
}
PMA_syncDisplayDataCompare($rows);
echo '</table>
</div>
</fieldset>';
/**
* connecting the source and target servers
*/
if ('cur' != $_SESSION['src_type']) {
$src_link = PMA_DBI_connect(
$src_username,
$src_password,
$is_controluser = false,
$_SESSION['src_server']
);
$src_version = PMA_DBI_fetch_value('SELECT VERSION()', 0, 0, $src_link);
$src_is_drizzle = (bool)preg_match('/\d{4}\./', $src_version);
} else {
$src_link = $GLOBALS['userlink'];
$src_version = PMA_MYSQL_STR_VERSION;
$src_is_drizzle = PMA_DRIZZLE;
// working on current server, so initialize this for tracking
// (does not work if user defined current server as a remote one)
$GLOBALS['db'] = $_SESSION['src_db'];
}
if ('cur' != $_SESSION['trg_type']) {
$trg_link = PMA_DBI_connect(
$trg_username,
$trg_password,
$is_controluser = false,
$_SESSION['trg_server']
);
$trg_version = PMA_DBI_fetch_value('SELECT VERSION()', 0, 0, $trg_link);
$trg_is_drizzle = (bool)preg_match('/\d{4}\./', $trg_version);
} else {
$trg_link = $GLOBALS['userlink'];
$trg_version = PMA_MYSQL_STR_VERSION;
$trg_is_drizzle = PMA_DRIZZLE;
// working on current server, so initialize this for tracking
$GLOBALS['db'] = $_SESSION['trg_db'];
}
/**
* Displaying the queries.
*/
echo '<fieldset><legend>' . __('Executed queries') . '</legend>';
/**
* Applying all sorts of differences for each matching table
*/
for ($p = 0; $p < sizeof($matching_tables); $p++) {
/**
* If the check box is checked for deleting previous rows from the
* target database tables then first find out rows to be deleted
* and then delete the rows.
*/
if (isset($_REQUEST['delete_rows'])) {
PMA_findDeleteRowsFromTargetTables(
$delete_array, $matching_tables, $p,
$target_tables_keys, $matching_tables_keys,
$trg_db, $trg_link, $src_db, $src_link
);
if (isset($delete_array[$p])) {
PMA_deleteFromTargetTable(
$trg_db, $trg_link, $matching_tables, $p,
$target_tables_keys, $delete_array, true
);
unset($delete_array[$p]);
}
}
if (isset($alter_str_array[$p])) {
PMA_alterTargetTableStructure(
$trg_db, $trg_link, $matching_tables,
$source_columns, $alter_str_array, $matching_tables_fields,
$criteria, $matching_tables_keys, $target_tables_keys, $p, true
);
unset($alter_str_array[$p]);
}
if (! empty($add_column_array[$p])) {
PMA_findDeleteRowsFromTargetTables(
$delete_array, $matching_tables, $p,
$target_tables_keys, $matching_tables_keys,
$trg_db, $trg_link, $src_db, $src_link
);
if (isset($delete_array[$p])) {
PMA_deleteFromTargetTable(
$trg_db, $trg_link, $matching_tables, $p,
$target_tables_keys, $delete_array, true
);
unset($delete_array[$p]);
}
PMA_addColumnsInTargetTable(
$src_db, $trg_db, $src_link, $trg_link,
$matching_tables, $source_columns, $add_column_array,
$matching_tables_fields, $criteria, $matching_tables_keys,
$target_tables_keys, $uncommon_tables, $uncommon_tables_fields,
$p, $uncommon_cols, true
);
unset($add_column_array[$p]);
}
if (isset($uncommon_columns[$p])) {
PMA_removeColumnsFromTargetTable(
$trg_db, $trg_link, $matching_tables,
$uncommon_columns, $p, true
);
unset($uncommon_columns[$p]);
}
if (isset($matching_table_structure_diff)
&& (isset($add_indexes_array[$matching_table_structure_diff[$p]])
|| isset($remove_indexes_array[$matching_table_structure_diff[$p]])
|| isset($alter_indexes_array[$matching_table_structure_diff[$p]]))
) {
PMA_applyIndexesDiff(
$trg_db, $trg_link, $matching_tables,
$source_indexes, $target_indexes, $add_indexes_array,
$alter_indexes_array, $remove_indexes_array,
$matching_table_structure_diff[$p], true
);
unset($add_indexes_array[$matching_table_structure_diff[$p]]);
unset($alter_indexes_array[$matching_table_structure_diff[$p]]);
unset($remove_indexes_array[$matching_table_structure_diff[$p]]);
}
PMA_updateTargetTables(
$matching_tables, $update_array, $src_db, $trg_db,
$trg_link, $p, $matching_tables_keys, true
);
PMA_insertIntoTargetTable(
$matching_tables, $src_db, $trg_db, $src_link,
$trg_link, $matching_tables_fields, $insert_array, $p,
$matching_tables_keys, $matching_tables_keys, $source_columns,
$add_column_array, $criteria, $target_tables_keys, $uncommon_tables,
$uncommon_tables_fields, $uncommon_cols, $alter_str_array,
$source_indexes,
$target_indexes, $add_indexes_array,
$alter_indexes_array, $delete_array, $update_array, true
);
}
/**
* Creating and populating tables present in source but absent
* from target database.
*/
for ($q = 0; $q < sizeof($source_tables_uncommon); $q++) {
if (isset($uncommon_tables[$q])) {
PMA_createTargetTables(
$src_db, $trg_db, $src_link, $trg_link,
$source_tables_uncommon, $q, $uncommon_tables_fields, true
);
}
if (isset($row_count[$q])) {
PMA_populateTargetTables(
$src_db, $trg_db, $src_link, $trg_link,
$source_tables_uncommon, $q, $uncommon_tables_fields, true
);
}
}
echo "</fieldset>";
}
/**
* Displays the main page when none of the following buttons is pressed
*/
if (! isset($_REQUEST['submit_connect'])
&& ! isset($_REQUEST['synchronize_db'])
&& ! isset($_REQUEST['Table_ids'])
) {
/**
* Displays the sub-page heading
*/
echo '<h2>' . PMA_Util::getImage('s_sync.png') . __('Synchronize') .'</h2>';
echo '<div id="serverstatus">
<form name="connection_form" id="connection_form" method="post" action="server_synchronize.php"
>' // TODO: add check if all var. are filled in
. PMA_generate_common_hidden_inputs('', '');
echo '<fieldset>';
echo '<legend>' . __('Synchronize') . '</legend>';
/**
* Displays the forms
*/
$databases = PMA_DBI_get_databases_full(
null, false, null, 'SCHEMA_NAME',
'ASC', 0, true
);
$databases_to_hide = array(
'information_schema',
'mysql'
);
if (PMA_DRIZZLE) {
$databases_to_hide[] = 'data_dictionary';
}
if ($GLOBALS['cfg']['AllowArbitraryServer'] === false) {
$possibly_readonly = ' readonly="readonly"';
} else {
$possibly_readonly = '';
}
foreach ($cons as $type) {
if ('src' == $type) {
$database_header = __('Source database');
} else {
$database_header = __('Target database');
}
$database_header .= PMA_Util::showHint(
PMA_sanitize(
sprintf(
'%sAllowArbitraryServer%s',
'[doc@AllowArbitraryServer]', '[/doc]'
)
)
);
?>
<table id="serverconnection_<?php echo $type; ?>_remote" class="data noclick">
<caption class="tblHeaders"><?php echo $database_header; ?></caption>
<tr class="odd">
<td colspan="2" style="text-align: center">
<select name="<?php echo $type; ?>_type" id="<?php echo $type; ?>_type" class="server_selector">
<?php
if ($GLOBALS['cfg']['AllowArbitraryServer']) {
$preselected_option = 'rmt';
echo '<option value="rmt" selected="selected">' . __('Enter manually') . '</option>';
} else {
$preselected_option = 'cur';
}
echo '<option value="cur"';
if ('cur' == $preselected_option) {
echo ' selected="selected"';
}
echo '>' . __('Current connection') . '</option>';
$loaded_dbi = $GLOBALS['cfg']['Server']['extension'];
foreach ($GLOBALS['cfg']['Servers'] as $key => $tmp_server) {
if (empty($tmp_server['host']) && empty($tmp_server['socket'])) {
continue;
}
if (! empty($tmp_server['verbose'])) {
$label = $tmp_server['verbose'];
} else {
$label = $tmp_server['host'];
if (! empty($tmp_server['port'])) {
$label .= ':' . $tmp_server['port'];
}
}
if ($loaded_dbi == 'drizzle' && $tmp_server['extension'] != 'drizzle'
|| $loaded_dbi != 'drizzle' && $tmp_server['extension'] == 'drizzle'
) {
// incompatible connection protocols
$disabled = ' disabled="disabled"';
$value = '';
} else {
$disabled = '';
$value = $tmp_server['host'];
$value .= '||||';
if (empty($tmp_server['port']) && empty($tmp_server['socket'])) {
$value .= '3306';
} else {
$value .= $tmp_server['port'];
}
$value .= '||||';
$value .= $tmp_server['socket'];
$value .= '||||';
$value .= $tmp_server['user'];
$value .= '||||';
$value .= $tmp_server['only_db'];
}
echo '<option value="' . $value . '"' . $disabled . '>'
. sprintf(__('Configuration: %s'), htmlspecialchars($label)) . '</option>';
} // end foreach
?>
</select>
</td>
</tr>
<tr class="even toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_host"><?php echo __('Server'); ?></label></td>
<td><input type="text" name="<?php echo $type; ?>_host" id="<?php echo $type; ?>_host" class="server-host" <?php echo $possibly_readonly; ?>/></td>
</tr>
<tr class="odd toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_port"><?php echo __('Port'); ?></label></td>
<td><input type="text" name="<?php echo $type; ?>_port" id="<?php echo $type; ?>_port" class="server-port" <?php echo $possibly_readonly; ?> value="3306" maxlength="5" size="5" /></td>
</tr>
<tr class="even toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_socket"><?php echo __('Socket'); ?></label></td>
<td><input type="text" name="<?php echo $type; ?>_socket" id="<?php echo $type; ?>_socket" class="server-socket" <?php echo $possibly_readonly; ?>/></td>
</tr>
<tr class="odd toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_username"><?php echo __('User name'); ?></label></td>
<td><input type="text" name="<?php echo $type; ?>_username" id="<?php echo $type; ?>_username" class="server-user" /></td>
</tr>
<tr class="even toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_pass"><?php echo __('Password'); ?></label></td>
<td><input type="password" name="<?php echo $type; ?>_pass" id="<?php echo $type; ?>_pass" class="server-pass" /> </td>
</tr>
<tr class="odd toggler remote-server vmiddle">
<td><label for="<?php echo $type; ?>_db"><?php echo __('Database'); ?></label></td>
<td><input type="text" name="<?php echo $type; ?>_db" id="<?php echo $type; ?>_db" class="server-db" /></td>
</tr>
<tr class="even toggler current-server vmiddle" style="display: none;">
<td><label for="<?php echo $type; ?>_db_sel"><?php echo __('Database'); ?></label></td>
<td>
<?php
$options_list = '';
foreach ($databases as $array_key => $db) {
if (in_array($db['SCHEMA_NAME'], $databases_to_hide)) {
unset($databases[$array_key]);
} else {
$options_list .= '<option>' . htmlspecialchars($db['SCHEMA_NAME']) . '</option>';
}
}
if (count($databases) == 0) {
echo __('No databases');
} else {
echo '<select name="' . $type . '_db_sel" id="' . $type . '_db_sel">'
. $options_list
. '</select>';
unset($options_list);
}
echo '</td> </tr>
</table>';
}
unset ($types, $type);
echo '
</fieldset>
<fieldset class="tblFooters">
<input type="submit" name="submit_connect" value="' . __('Go') .'" id="buttonGo" />
</fieldset>
</form>
</div>
<div class="notice">' . __('Target database will be completely synchronized with source database. Source database will remain unchanged.') . '</div>';
}
?>
Jump to Line
Something went wrong with that request. Please try again.