Git December 2011

git@phpmyadmin.net

5 participants
151 discussions

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_7_1-23849-gd39a230
by Rouslan Placella 02 Dec '11

02 Dec '11

The branch, master has been updated via d39a2309922e5646034262a37024b1bdb363a207 (commit) from 14b9e4cfa3673f36ae02e508f164cd9bdf0a4a26 (commit) - Log ----------------------------------------------------------------- commit d39a2309922e5646034262a37024b1bdb363a207 Author: asdfrede <asdfrede(a)users.sourceforge.net> Date: Fri Dec 2 00:48:19 2011 +0000 Fixed bug #3408377 - Deleting table from the DB does not change the table counter ----------------------------------------------------------------------- Summary of changes: ChangeLog | 1 + db_structure.php | 13 +++--- js/db_structure.js | 116 +++++++++++++++++++++++++++++++++++++++------------ js/functions.js | 3 + js/messages.php | 10 ++++ tbl_create.php | 6 +- 6 files changed, 112 insertions(+), 37 deletions(-) diff --git a/ChangeLog b/ChangeLog index 45d46a5..bc69949 100644 --- a/ChangeLog +++ b/ChangeLog @@ -61,6 +61,7 @@ phpMyAdmin - ChangeLog + patch #3432835 [interface] Add useful intermediate pages to pageselector + [interface] Improved index editor + View editing via a generated ALTER VIEW +- bug #3408377 [interface] Deleting table from the DB does not change the table counter 3.4.9.0 (not yet released) - bug #3442028 [edit] Inline editing enum fields with null shows no dropdown diff --git a/db_structure.php b/db_structure.php index 16df6a7..aae36e6 100644 --- a/db_structure.php +++ b/db_structure.php @@ -14,6 +14,7 @@ $GLOBALS['js_include'][] = 'jquery/jquery-ui-1.8.16.custom.js'; $GLOBALS['js_include'][] = 'db_structure.js'; $GLOBALS['js_include'][] = 'tbl_change.js'; $GLOBALS['js_include'][] = 'jquery/timepicker.js'; +$GLOBALS['js_include'][] = 'jquery/jquery.sprintf.js'; /** * Prepares the tables list if the user where not redirected to this script @@ -244,8 +245,8 @@ foreach ($tables as $keyname => $each_table) { if ($is_show_stats) { if (isset($formatted_overhead)) { $overhead = '<a href="tbl_structure.php?' - . $tbl_url_query . '#showusage">' . $formatted_overhead - . ' ' . $overhead_unit . '</a>' . "\n"; + . $tbl_url_query . '#showusage"><span>' . $formatted_overhead + . '</span> <span class="unit">' . $overhead_unit . '</span></a>' . "\n"; unset($formatted_overhead); $overhead_check .= "document.getElementById('checkbox_tbl_" . ($i + 1) . "').checked = true;"; @@ -472,8 +473,8 @@ foreach ($tables as $keyname => $each_table) { <?php if ($is_show_stats) { ?> <td class="value tbl_size"><a href="tbl_structure.php?<?php echo $tbl_url_query; ?>#showusage" - ><?php echo $formatted_size . ' ' . $unit; ?></a></td> - <td class="value"><?php echo $overhead; ?></td> + ><?php echo '<span>' . $formatted_size . '</span> <span class="unit">' . $unit . '</span>'; ?></a></td> + <td class="value tbl_overhead"><?php echo $overhead; ?></td> <?php } // end if ?> <?php } elseif ($table_is_view) { ?> <td class="value">-</td> @@ -502,7 +503,7 @@ if ($is_show_stats) { </tbody> <tbody id="tbl_summary_row"> <tr><th></th> - <th align="center" nowrap="nowrap"> + <th align="center" nowrap="nowrap" class="tbl_num"> <?php // for blobstreaming - if the number of tables is 0, set tableReductionCount to 0 // (we don't want negative numbers here) @@ -543,7 +544,7 @@ if (!($cfg['PropertiesNumColumns'] > 1)) { if ($is_show_stats) { ?> <th class="value tbl_size"><?php echo $sum_formatted . ' ' . $unit; ?></th> - <th class="value"><?php echo $overhead_formatted . ' ' . $overhead_unit; ?></th> + <th class="value tbl_overhead"><?php echo $overhead_formatted . ' ' . $overhead_unit; ?></th> <?php } ?> diff --git a/js/db_structure.js b/js/db_structure.js index c00bd45..f9d9c13 100644 --- a/js/db_structure.js +++ b/js/db_structure.js @@ -20,35 +20,90 @@ /** * Adjust number of rows and total size in the summary - * when emptying or dropping a table - * - * @param jQuery object $this_anchor + * when truncating, creating, dropping or inserting into a table */ -function PMA_adjustTotals($this_anchor) -{ - var $parent_tr = $this_anchor.closest('tr'); - var $rows_td = $parent_tr.find('.tbl_rows'); - var $size_td = $parent_tr.find('.tbl_size'); - var num_rows = parseInt($rows_td.text()); - // set number of rows to 0 - // (not really needed in case we are dropping the table) - $rows_td.text('0'); - // set size to unknown (not sure how to get the exact - // value here, as an empty InnoDB table would have a size) - $size_td.text('-'); - - // try to compute a new total row number - if (! isNaN(num_rows)) { - $total_rows_td = $('#tbl_summary_row').find('.tbl_rows'); - var total_rows = parseInt($total_rows_td.text()); - if (! isNaN(total_rows)) { - $total_rows_td.text(total_rows - num_rows); +function PMA_adjustTotals() { + var byteUnits = new Array( + PMA_messages['strB'], + PMA_messages['strKiB'], + PMA_messages['strMiB'], + PMA_messages['strGiB'], + PMA_messages['strTiB'], + PMA_messages['strPiB'], + PMA_messages['strEiB'] + ); + /** + * @var $allTr jQuery object that references all the rows in the list of tables + */ + var $allTr = $("#tablesForm table.data tbody:first tr"); + // New summary values for the table + var tableSum = $allTr.size(); + var rowsSum = 0; + var sizeSum = 0; + var overheadSum = 0; + + $allTr.each(function () { + var $this = $(this); + // Get the number of rows for this SQL table + var strRows = $this.find('.tbl_rows').text(); + strRows = strRows.replace(/[,.]/g , ''); + var intRow = parseInt(strRows, 10); + if (! isNaN(intRow)) { + rowsSum += intRow; + } + // Extract the size and overhead + var valSize = 0; + var valOverhead = 0; + var strSize = $.trim($this.find('.tbl_size span:not(.unit)').text()); + var strSizeUnit = $.trim($this.find('.tbl_size span.unit').text()); + var strOverhead = $.trim($this.find('.tbl_overhead span:not(.unit)').text()); + var strOverheadUnit = $.trim($this.find('.tbl_overhead span.unit').text()); + // Given a value and a unit, such as 100 and KiB, for the table size + // and overhead calculate their numeric values in bytes, such as 102400 + for (var i = 0; i < byteUnits.length; i++) { + if (strSizeUnit == byteUnits[i]) { + var tmpVal = parseFloat(strSize); + valSize = tmpVal * Math.pow(1024, i); + break; + } + } + for (var i = 0; i < byteUnits.length; i++) { + if (strOverheadUnit == byteUnits[i]) { + var tmpVal = parseFloat(strOverhead); + valOverhead = tmpVal * Math.pow(1024, i); + break; + } } + sizeSum += valSize; + overheadSum += valOverhead; + }); + // Add some commas for readablility: + // 1000000 becomes 1,000,000 + var strRowSum = rowsSum + ""; + var regex = /(\d+)(\d{3})/; + while (regex.test(strRowSum)) { + strRowSum = strRowSum.replace(regex, '$1' + ',' + '$2'); + } + // Calculate the magnitude for the size and overhead values + var size_magnitude = 0, overhead_magnitude = 0; + while (sizeSum >= 1024) { + sizeSum /= 1024; + size_magnitude++; } + while (overheadSum >= 1024) { + overheadSum /= 1024; + overhead_magnitude++; + } + + sizeSum = Math.round(sizeSum * 10) / 10; + overheadSum = Math.round(overheadSum * 10) / 10; - // prefix total size with "~" - var $total_size_td = $('#tbl_summary_row').find('.tbl_size'); - $total_size_td.text($total_size_td.text().replace(/^/,'~')); + // Update summary with new data + var $summary = $("#tbl_summary_row"); + $summary.find('.tbl_num').text($.sprintf(PMA_messages['strTables'], tableSum)); + $summary.find('.tbl_rows').text(strRowSum); + $summary.find('.tbl_size').text(sizeSum + " " + byteUnits[size_magnitude]); + $summary.find('.tbl_overhead').text(overheadSum + " " + byteUnits[overhead_magnitude]); } $(document).ready(function() { @@ -146,6 +201,7 @@ $(document).ready(function() { } /**Update the row count at the tableForm*/ current_insert_table.closest('tr').find('.value.tbl_rows').html(data.row_count); + PMA_adjustTotals(); }) // end $.post() }) // end insert table button "Go" @@ -182,6 +238,7 @@ $(document).ready(function() { } /**Update the row count at the tableForm*/ current_insert_table.closest('tr').find('.value.tbl_rows').html(data.row_count); + PMA_adjustTotals(); }) // end $.post() }); @@ -217,16 +274,19 @@ $(document).ready(function() { $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true}, function(data) { if (data.success == true) { PMA_ajaxShowMessage(data.message); + // Adjust table statistics + var $tr = $this_anchor.closest('tr'); + $tr.find('.tbl_rows').text('0'); + $tr.find('.tbl_size, .tbl_overhead').text('-'); //Fetch inner span of this anchor //and replace the icon with its disabled version var span = $this_anchor.html().replace(/b_empty/, 'bd_empty'); - PMA_adjustTotals($this_anchor); - //To disable further attempts to truncate the table, //replace the a element with its inner span (modified) $this_anchor .replaceWith(span) .removeClass('truncate_table_anchor'); + PMA_adjustTotals(); } else { PMA_ajaxShowMessage(PMA_messages['strErrorProcessingRequest'] + " : " + data.error, false); } @@ -267,8 +327,8 @@ $(document).ready(function() { $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true}, function(data) { if (data.success == true) { PMA_ajaxShowMessage(data.message); - PMA_adjustTotals($this_anchor); $curr_row.hide("medium").remove(); + PMA_adjustTotals(); if (window.parent && window.parent.frame_navigation) { window.parent.frame_navigation.location.reload(); diff --git a/js/functions.js b/js/functions.js index 08b8655..1e2bbad 100644 --- a/js/functions.js +++ b/js/functions.js @@ -2131,6 +2131,9 @@ $(document).ready(function() { //Sort the table $(tables_table).PMA_sort_table('th'); + + // Adjust summary row + PMA_adjustTotals(); } //Refresh navigation frame as a new table has been added diff --git a/js/messages.php b/js/messages.php index 2534567..5aba16f 100644 --- a/js/messages.php +++ b/js/messages.php @@ -121,6 +121,16 @@ $js_messages['strBytesReceived'] = __('Bytes received'); $js_messages['strConnections'] = __('Connections'); $js_messages['strProcesses'] = __('Processes'); +/* summary row */ +$js_messages['strB'] = __('B'); +$js_messages['strKiB'] = __('KiB'); +$js_messages['strMiB'] = __('MiB'); +$js_messages['strGiB'] = __('GiB'); +$js_messages['strTiB'] = __('TiB'); +$js_messages['strPiB'] = __('PiB'); +$js_messages['strEiB'] = __('EiB'); +$js_messages['strTables'] = __('%d table(s)'); + /* l10n: Questions is the name of a MySQL Status variable */ $js_messages['strQuestions'] = __('Questions'); $js_messages['strTraffic'] = __('Traffic'); diff --git a/tbl_create.php b/tbl_create.php index ae42d75..63cd26a 100644 --- a/tbl_create.php +++ b/tbl_create.php @@ -261,7 +261,7 @@ if (isset($_REQUEST['do_save_data'])) { } if (isset($formatted_overhead)) { - $overhead = $formatted_overhead . ' ' . $overhead_unit; + $overhead = '<span>' . $formatted_overhead . '</span> <span class="unit">' . $overhead_unit . '</span>'; unset($formatted_overhead); } else { $overhead = '-'; @@ -310,8 +310,8 @@ if (isset($_REQUEST['do_save_data'])) { $new_table_string .= '<td> <dfn title="' . PMA_getCollationDescr($tbl_stats['Collation']) . '">'. $tbl_stats['Collation'] .'</dfn></td>' . "\n"; if ($is_show_stats) { - $new_table_string .= '<td class="value"> <a href="tbl_structure.php' . PMA_generate_common_url($tbl_url_params) . '#showusage" >' . $formatted_size . ' ' . $unit . '</a> </td>' . "\n" ; - $new_table_string .= '<td class="value">' . $overhead . '</td>' . "\n" ; + $new_table_string .= '<td class="value tbl_size"> <a href="tbl_structure.php' . PMA_generate_common_url($tbl_url_params) . '#showusage" ><span>' . $formatted_size . '</span> <span class="unit">' . $unit . '</class></a> </td>' . "\n" ; + $new_table_string .= '<td class="value tbl_overhead">' . $overhead . '</td>' . "\n" ; } $new_table_string .= '</tr>' . "\n"; hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin website branch, master, updated. 23f165c6d8ed9fa195a47ce8a639a6c45007705e
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, master has been updated via 23f165c6d8ed9fa195a47ce8a639a6c45007705e (commit) from eac2f79af41b95b906bf308bbe61f1065cf4b6bc (commit) - Log ----------------------------------------------------------------- commit 23f165c6d8ed9fa195a47ce8a639a6c45007705e Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:39:52 2011 -0500 PMASA-2011-18 ----------------------------------------------------------------------- Summary of changes: templates/security/PMASA-2011-18 | 57 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 57 insertions(+), 0 deletions(-) create mode 100644 templates/security/PMASA-2011-18 diff --git a/templates/security/PMASA-2011-18 b/templates/security/PMASA-2011-18 new file mode 100644 index 0000000..2965f59 --- /dev/null +++ b/templates/security/PMASA-2011-18 @@ -0,0 +1,57 @@ +<html xmlns:py="http://genshi.edgewall.org/" xmlns:xi="http://www.w3.org/2001/XInclude" py:strip=""> + +<py:def function="announcement_id"> +PMASA-2011-18 +</py:def> + +<py:def function="announcement_date"> +2011-12-01 +</py:def> + +<py:def function="announcement_summary"> +Multiple XSS. +</py:def> + +<py:def function="announcement_description"> +Using crafted database names, it was possible to produce XSS in the Database Synchronize and Database rename panels. +Using an invalid and crafted SQL query, it was possible to produce XSS when editing a query on a table overview panel or when using the view creation dialog. +Using a crafted column type, it was possible to produce XSS in the table search and create index dialogs. +</py:def> + +<py:def function="announcement_mitigation"> +These attacks are unlikely to succeed on a victim. +</py:def> + +<py:def function="announcement_severity"> +We consider these vulnerabilities to be non critical. +</py:def> + +<py:def function="announcement_affected"> +Versions 3.4.x are affected. +</py:def> + +<py:def function="announcement_solution"> +Upgrade to phpMyAdmin 3.4.8 or newer or apply the related patch listed below. +</py:def> + +<py:def function="announcement_references"> +Thanks to <a href="http://www.majorsecurity.net">David Vieira-Kurz</a> for reporting the Database Synchronize and rename issues. +Thanks to Maxim Rupp for reporting the invalid SQL query issue. +Thanks to <a href="http://www.defcontn.com">R.Harikrishnan</a> for reporting the database rename and view creation issues. +</py:def> + +<py:def function="announcement_cve">CVE-2011-4634</py:def> + +<py:def function="announcement_cwe">661 79</py:def> + +<py:def function="announcement_commits"> +1490533d91e9d3820e78ca4eac7981886eaea2cb +b289fe082441dc739939b0ba15dae0d9dc6cee92 +dac8d6ce256333ff45b5f46270304b8657452740 +077c10020e349e8c1beb46309098992fde616913 +</py:def> + +<xi:include href="_page.tpl" /> +</html> + + hooks/post-receive -- phpMyAdmin website

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, TESTING, updated. RELEASE_3_4_8-51-g31998e7
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, TESTING has been updated via 31998e782b5f7eb7146076ec71e428e95a776c4e (commit) via 3550b5adee887540a44a31bd5654f8c93d98d408 (commit) from 230f4ed39612515c20b1e91c05c2d0198a356567 (commit) - Log ----------------------------------------------------------------- commit 31998e782b5f7eb7146076ec71e428e95a776c4e Merge: 230f4ed 3550b5a Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:21:25 2011 -0500 Merge branch 'MAINT_3_4_8' into TESTING ----------------------------------------------------------------------- Summary of changes: ChangeLog | 2 +- Documentation.html | 4 ++-- README | 2 +- libraries/Config.class.php | 2 +- 4 files changed, 5 insertions(+), 5 deletions(-) diff --git a/ChangeLog b/ChangeLog index f45b137..38ca784 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,7 +1,7 @@ phpMyAdmin - ChangeLog ====================== -3.4.8.0 (not yet released) +3.4.8.0 (2011-12-01) - bug #3425230 [interface] enum data split at space char (more space to edit) - bug #3426840 [interface] ENUM/SET editor can't handle commas in values - bug #3427256 [interface] no links to browse/empty views and tables diff --git a/Documentation.html b/Documentation.html index 3d9f3c3..87a65d2 100644 --- a/Documentation.html +++ b/Documentation.html @@ -9,7 +9,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>phpMyAdmin 3.4.8-rc1 - Documentation</title> + <title>phpMyAdmin 3.4.8 - Documentation</title> <link rel="stylesheet" type="text/css" href="docs.css" /> </head> @@ -17,7 +17,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <div id="header"> <h1> <a href="http://www.phpmyadmin.net/">php<span class="myadmin">MyAdmin</span></a> - 3.4.8-rc1 + 3.4.8 Documentation </h1> </div> diff --git a/README b/README index 65349d8..12e5e4e 100644 --- a/README +++ b/README @@ -1,7 +1,7 @@ phpMyAdmin - Readme =================== -Version 3.4.8-rc1 +Version 3.4.8 A set of PHP-scripts to manage MySQL over the web. diff --git a/libraries/Config.class.php b/libraries/Config.class.php index bd02527..cbcb3e4 100644 --- a/libraries/Config.class.php +++ b/libraries/Config.class.php @@ -96,7 +96,7 @@ class PMA_Config */ function checkSystem() { - $this->set('PMA_VERSION', '3.4.8-rc1'); + $this->set('PMA_VERSION', '3.4.8'); /** * @deprecated */ hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, STABLE, updated. RELEASE_3_4_8-29-g2d9f23b
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, STABLE has been updated via 2d9f23ba49e6b207c420961f308a45db0ef59c7a (commit) via 3550b5adee887540a44a31bd5654f8c93d98d408 (commit) via b00745d352c89a5e52673e717e6cbef43dc229d6 (commit) via 29455fe79bc9896129d7004e0242c451f4a32cc8 (commit) via ff0ea2f9b960359234fab02a74b156bc9bb1e383 (commit) via cf5faa1dd1bcae329eddb793765ad2ba3e4471dc (commit) via f414a0ec32626c3f0084bd020daba2b4553d244b (commit) via 035c112eafeb57201c63f0b94d7485d41762922f (commit) via 077c10020e349e8c1beb46309098992fde616913 (commit) via dac8d6ce256333ff45b5f46270304b8657452740 (commit) via bc45a1048d2f5ca8a532f774ddb1dd80985dff3d (commit) via 1490533d91e9d3820e78ca4eac7981886eaea2cb (commit) via b289fe082441dc739939b0ba15dae0d9dc6cee92 (commit) via e2b6af5a99b9a053609ff76724fdc4a6a48dd14e (commit) via e7877fba46743be0b351c526ccac216731ab8c1e (commit) via 81f6766f962d6cea3742f3936032d234e6ce9d53 (commit) via b5c45d0d35c203fe1b8e1c720ae8af7e40f4ce6c (commit) via 8219f7c544c8ffd2ba0df2034900a7f591af3219 (commit) via 2e92b86f92df4dc4d295e7ad7250ab4a3c29bbf2 (commit) via ac430ea21d6f49b781a9cda9940a5675d56f168e (commit) via b6f02c7aed3af85a00fbf05c47a5ccade75fa076 (commit) via 0212c7c01562418410c559ca081ef6239e6b13cb (commit) via 849b6818f81cae1d5ae0a6857b6e5839a8b3ea10 (commit) via e51a1cb73df8f3706fe0bb50ccdcae7fa2f893eb (commit) via f674e3dbe952d9c4a7864067d7c286e9b01f527a (commit) via edea25b07b51c2c5e277323f8047fcd82e695f7e (commit) via bd0ad7377e92325d92d1de40ba52b8e89bc19664 (commit) via 2dfd1dca1490959f4ee594eb7de9e3e996fd6b4c (commit) via efc03d8c8cfa354f703c7a40780035efa93235a4 (commit) via cc2fe91e767d2c38855f1bb866d71c4a721b82cd (commit) via 19c0de6be237e3393b65b93ee4ef67ee3be68c18 (commit) via c51353df21ea86afb8b6197b70560489bfee0e1d (commit) via 8721f7b1601295186f4b9df5dee285911c8aaaf7 (commit) via 8170d03d3cd4892f71db9b89cdf442006bcc1167 (commit) via b94febeb89b208e935b58dc80d2b07446d35d9b0 (commit) via d22fae4201f299d4f3fcac1ac4bc136a422c5d26 (commit) via 0b24e6943505fad97e7fba3263bf863cdb7c01dd (commit) via e2cb83aa24e1b750af2a4f83cfdfa9cab043988b (commit) via a691fce64ca56c90d0d4b9af525a785d95eabd6b (commit) via f7cb55cb626158d81ac606927142d8f55444b9ff (commit) via 694c1cdf751e1fcbe2435087e3cea0dcd85ca458 (commit) via d590bccda2409f3d1e168c470a6af3fe38531106 (commit) via bdfd9ead762a3003dcbdbb043a3288bfe1f1eecc (commit) via 0112ff6ba522b6d18fee298357a3fda1d9cea0cf (commit) via d4cce87b263ed00654588fa068c7ec73422fd465 (commit) via a3132f6e91f04dc8f885f4141e6d397460421fa4 (commit) from a8cea1918a48ddde91e52d59c26700d41499fcc8 (commit) - Log ----------------------------------------------------------------- commit 2d9f23ba49e6b207c420961f308a45db0ef59c7a Merge: a8cea19 3550b5a Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:21:26 2011 -0500 Merge branch 'MAINT_3_4_8' into STABLE ----------------------------------------------------------------------- Summary of changes: ChangeLog | 29 ++- Documentation.html | 12 +- README | 2 +- browse_foreigners.php | 5 + db_structure.php | 64 +++- import.php | 2 +- js/db_operations.js | 2 +- js/db_search.js | 24 +- js/functions.js | 68 ++-- js/sql.js | 5 + js/tbl_change.js | 19 +- js/tbl_structure.js | 5 + libraries/Config.class.php | 2 +- libraries/Error.class.php | 2 +- libraries/auth/cookie.auth.lib.php | 4 + libraries/auth/http.auth.lib.php | 4 + libraries/common.lib.php | 5 +- libraries/db_info.inc.php | 4 + libraries/import/ods.php | 3 - libraries/import/xml.php | 3 - libraries/select_lang.lib.php | 2 +- libraries/server_synchronize.lib.php | 639 ++++++++++++++++--------------- libraries/sqlparser.data.php | 3 +- libraries/vendor_config.php | 6 + po/af.po | 2 +- po/ar.po | 2 +- po/az.po | 2 +- po/be.po | 2 +- po/be(a)latin.po | 2 +- po/bg.po | 16 +- po/bn.po | 2 +- po/br.po | 2 +- po/bs.po | 2 +- po/ca.po | 2 +- po/cs.po | 2 +- po/cy.po | 2 +- po/da.po | 2 +- po/de.po | 2 +- po/el.po | 2 +- po/en_GB.po | 2 +- po/es.po | 2 +- po/et.po | 2 +- po/eu.po | 79 +++-- po/fa.po | 2 +- po/fi.po | 2 +- po/fr.po | 2 +- po/gl.po | 2 +- po/he.po | 2 +- po/hi.po | 2 +- po/hr.po | 2 +- po/hu.po | 95 ++++-- po/id.po | 2 +- po/it.po | 2 +- po/ja.po | 2 +- po/ka.po | 2 +- po/ko.po | 2 +- po/lt.po | 2 +- po/lv.po | 2 +- po/mk.po | 2 +- po/ml.po | 2 +- po/mn.po | 2 +- po/ms.po | 2 +- po/nb.po | 2 +- po/nl.po | 2 +- po/pl.po | 2 +- po/pt.po | 2 +- po/pt_BR.po | 2 +- po/ro.po | 4 +- po/ru.po | 2 +- po/si.po | 2 +- po/sk.po | 2 +- po/sl.po | 2 +- po/sq.po | 2 +- po/sr.po | 2 +- po/sr(a)latin.po | 2 +- po/sv.po | 2 +- po/ta.po | 2 +- po/te.po | 2 +- po/th.po | 2 +- po/tr.po | 2 +- po/tt.po | 2 +- po/ug.po | 2 +- po/uk.po | 2 +- po/ur.po | 2 +- po/uz.po | 2 +- po/uz(a)latin.po | 2 +- po/zh_CN.po | 2 +- po/zh_TW.po | 2 +- tbl_indexes.php | 4 +- tbl_select.php | 4 +- themes/pmahomme/css/theme_right.css.php | 6 +- 91 files changed, 700 insertions(+), 542 deletions(-) diff --git a/ChangeLog b/ChangeLog index 6ada51e..e7c3bf9 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,8 +1,35 @@ phpMyAdmin - ChangeLog ====================== +3.4.8.0 (2011-12-01) +- bug #3425230 [interface] enum data split at space char (more space to edit) +- bug #3426840 [interface] ENUM/SET editor can't handle commas in values +- bug #3427256 [interface] no links to browse/empty views and tables +- bug #3430377 [interface] Deleted search results remain visible +- bug #3428627 [import] ODS import ignores memory limits +- bug #3426836 [interface] Visual column separation +- bug #3428065 [parser] TRUE not recognized by parser ++ patch #3433770 [config] Make location of php-gettext configurable +- patch #3430291 [import] Handle conflicts in some open_basedir situations +- bug #3431427 [display] Dropdown results - setting NULL does not work +- patch #3428764 [edit] Inline edit on multi-server configuration +- patch #3437354 [core] Notice: Array to string conversion in PHP 5.4 +- [interface] When ShowTooltipAliasTB is true, VIEW is wrongly shown as the + view name in main panel db Structure page +- bug #3439292 [core] Fail to synchronize column with name of keyword +- bug #3425156 [interface] Add column after drop +- [interface] Avoid showing the password in phpinfo()'s output +- bug #3441572 [GUI] 'newer version of phpMyAdmin' message not shown in IE8 +- bug #3407235 [interface] Entering the key through a lookup window does not reset NULL +- [security] Self-XSS on database names (Synchronize), see PMASA-2011-18 +- [security] Self-XSS on database names (Operations/rename), see PMASA-2011-18 +- [security] Self-XSS on column type (Create index), see PMASA-2011-18 +- [security] Self-XSS on column type (table Search), see PMASA-2011-18 +- [security] Self-XSS on invalid query (table overview), see PMASA-2011-18 + 3.4.7.1 (2011-11-10) -- [security] Fixed possible local file inclusion in XML import (CVE-2011-4107). +- [security] Fixed possible local file inclusion in XML import +(CVE-2011-4107). 3.4.7.0 (2011-10-23) - bug #3418610 [interface] Links in navigation when $cfg['MainPageIconic'] = false diff --git a/Documentation.html b/Documentation.html index 083da6e..87a65d2 100644 --- a/Documentation.html +++ b/Documentation.html @@ -9,7 +9,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>phpMyAdmin 3.4.7.1 - Documentation</title> + <title>phpMyAdmin 3.4.8 - Documentation</title> <link rel="stylesheet" type="text/css" href="docs.css" /> </head> @@ -17,7 +17,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <div id="header"> <h1> <a href="http://www.phpmyadmin.net/">php<span class="myadmin">MyAdmin</span></a> - 3.4.7.1 + 3.4.8 Documentation </h1> </div> @@ -1446,7 +1446,7 @@ CREATE DATABASE,ALTER DATABASE,DROP DATABASE</pre> </dd> <dt id="cfg_LeftFrameDBTree">$cfg['LeftFrameDBTree'] boolean</dt> - <dd>In light mode, defines whether to display the names of databases (in the + <dd>Defines whether to display the names of databases (in the selector) using a tree, see also <a href="#cfg_LeftFrameDBSeparator" class="configrule">$cfg['LeftFrameDBSeparator']</a>. </dd> @@ -3510,8 +3510,7 @@ have either the <a href="http://pecl.php.net/package/APC">APC</a> extension group under which Apache runs. </li> <li> - You should use PHP safe mode, to protect from other users that try - to include your <i>config.inc.php</i> in their scripts. + Follow security recommendations for PHP and your webserver. </li> </ul> @@ -4585,7 +4584,7 @@ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA <li>Marc Delisle <marc_at_infomarc.info> <ul> - <li>multi-language version</li> + <li>multi-language version in December 1998</li> <li>various fixes and improvements</li> <li><abbr title="structured query language">SQL</abbr> analyser (most of it)</li> <li>current project maintainer</li> @@ -4596,7 +4595,6 @@ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA <li>started SourceForge phpMyAdmin project in March 2001</li> <li>sync'ed different existing CVS trees with new features and bugfixes</li> <li>multi-language improvements, dynamic language selection</li> - <li>current project maintainer</li> <li>many bugfixes and improvements</li> </ul></li> diff --git a/README b/README index 488cb04..12e5e4e 100644 --- a/README +++ b/README @@ -1,7 +1,7 @@ phpMyAdmin - Readme =================== -Version 3.4.7.1 +Version 3.4.8 A set of PHP-scripts to manage MySQL over the web. diff --git a/browse_foreigners.php b/browse_foreigners.php index c8867af..e88c20f 100644 --- a/browse_foreigners.php +++ b/browse_foreigners.php @@ -104,9 +104,11 @@ require_once './libraries/header_scripts.inc.php'; if (opener && opener.document && opener.document.insertForm) { var field = 'fields'; + var field_null = 'fields_null'; <?php if (isset($rownumber)) { ?> var element_name = field + '[multi_edit][<?php echo htmlspecialchars($rownumber); ?>][' + fieldmd5 + ']'; + var null_name = field_null + '[multi_edit][<?php echo htmlspecialchars($rownumber); ?>][' + fieldmd5 + ']'; <?php } else { ?> var element_name = field + '[]'; <?php } ?> @@ -120,6 +122,9 @@ require_once './libraries/header_scripts.inc.php'; if (opener.document.insertForm.elements[element_name]) { // Edit/Insert form opener.document.insertForm.elements[element_name].value = key; + if (opener.document.insertForm.elements[null_name]) { + opener.document.insertForm.elements[null_name].checked = false; + } self.close(); return false; } else if (opener.document.insertForm.elements[element_name_alt]) { diff --git a/db_structure.php b/db_structure.php index d81af5d..b704759 100644 --- a/db_structure.php +++ b/db_structure.php @@ -254,31 +254,57 @@ foreach ($tables as $keyname => $each_table) { $hidden_fields[] = '<input type="hidden" name="views[]" value="' . htmlspecialchars($each_table['TABLE_NAME']) . '" />'; } - if ($each_table['TABLE_ROWS'] > 0) { - $browse_table = '<a href="sql.php?' . $tbl_url_query . '&pos=0">' . $titles['Browse'] . '</a>'; - $search_table = '<a href="tbl_select.php?' . $tbl_url_query . '">' . $titles['Search'] . '</a>'; - $browse_table_label = '<a href="sql.php?' . $tbl_url_query . '&pos=0">' . $truename . '</a>'; + /* + * Always activate links for Browse, Search and Empty, even if + * the icons are greyed, because + * 1. for views, we don't know the number of rows at this point + * 2. for tables, another source could have populated them since the + * page was generated + * + * I could have used the PHP ternary conditional operator but I find + * the code easier to read without this operator. + */ + if ($each_table['TABLE_ROWS'] > 0 || $table_is_view) { + $may_have_rows = true; } else { - $browse_table = $titles['NoBrowse']; - $search_table = $titles['NoSearch']; - $browse_table_label = '<a href="tbl_structure.php?' . $tbl_url_query . '">' . $truename . '</a>'; + $may_have_rows = false; } + $browse_table = '<a href="sql.php?' . $tbl_url_query . '&pos=0">'; + if ($may_have_rows) { + $browse_table .= $titles['Browse']; + } else { + $browse_table .= $titles['NoBrowse']; + } + $browse_table .= '</a>'; + + $search_table = '<a href="tbl_select.php?' . $tbl_url_query . '">'; + if ($may_have_rows) { + $search_table .= $titles['Search']; + } else { + $search_table .= $titles['NoSearch']; + } + $search_table .= '</a>'; + + $browse_table_label = '<a href="sql.php?' . $tbl_url_query . '&pos=0">' . $truename . '</a>'; if (! $db_is_information_schema) { - if (! empty($each_table['TABLE_ROWS'])) { - $empty_table = '<a '; - if ($GLOBALS['cfg']['AjaxEnable']) { - $empty_table .= 'class="truncate_table_anchor"'; - } - $empty_table .= ' href="sql.php?' . $tbl_url_query - . '&sql_query='; - $empty_table .= urlencode('TRUNCATE ' . PMA_backquote($each_table['TABLE_NAME'])) - . '&message_to_show=' - . urlencode(sprintf(__('Table %s has been emptied'), htmlspecialchars($each_table['TABLE_NAME']))) - .'">' . $titles['Empty'] . '</a>'; + $empty_table = '<a '; + if ($GLOBALS['cfg']['AjaxEnable']) { + $empty_table .= 'class="truncate_table_anchor"'; + } + $empty_table .= ' href="sql.php?' . $tbl_url_query + . '&sql_query='; + $empty_table .= urlencode('TRUNCATE ' . PMA_backquote($each_table['TABLE_NAME'])) + . '&message_to_show=' + . urlencode(sprintf(__('Table %s has been emptied'), htmlspecialchars($each_table['TABLE_NAME']))) + .'">'; + if ($may_have_rows) { + $empty_table .= $titles['Empty']; } else { - $empty_table = $titles['NoEmpty']; + $empty_table .= $titles['NoEmpty']; } + $empty_table .= '</a>'; + $drop_query = 'DROP ' . ($table_is_view ? 'VIEW' : 'TABLE') . ' ' . PMA_backquote($each_table['TABLE_NAME']); diff --git a/import.php b/import.php index d706b60..07e5d18 100644 --- a/import.php +++ b/import.php @@ -259,7 +259,7 @@ if ($import_file != 'none' && !$error) { if (is_writable($tmp_subdir)) { - $import_file_new = $tmp_subdir . basename($import_file); + $import_file_new = $tmp_subdir . basename($import_file) . uniqid(); if (move_uploaded_file($import_file, $import_file_new)) { $import_file = $import_file_new; $file_to_unlink = $import_file_new; diff --git a/js/db_operations.js b/js/db_operations.js index b053694..ad39635 100644 --- a/js/db_operations.js +++ b/js/db_operations.js @@ -32,7 +32,7 @@ $(document).ready(function() { var $form = $(this); - var question = 'CREATE DATABASE ' + $('#new_db_name').val() + ' / DROP DATABASE ' + window.parent.db; + var question = escapeHtml('CREATE DATABASE ' + $('#new_db_name').val() + ' / DROP DATABASE ' + window.parent.db); PMA_prepareForAjaxRequest($form); /** diff --git a/js/db_search.js b/js/db_search.js index 79c444e..f9a9416 100644 --- a/js/db_search.js +++ b/js/db_search.js @@ -48,18 +48,20 @@ function deleteResult(result_path , msg , ajaxEnable){ { if(ajaxEnable) { + var $msg = PMA_ajaxShowMessage(PMA_messages['strDeleting']); /** Load the deleted option to the page*/ - $('#browse-results').load(result_path + " '"+'#result_query' + "'"); - $('#sqlqueryform').load(result_path + " '"+'#sqlqueryform' + "'"); - $('#togglequerybox').html(PMA_messages['strHideQueryBox']); - - /** Refresh the search results after the deletion */ - document.getElementById('buttonGo'). click(); - //PMA_ajaxShowMessage(PMA_messages['strDeleting']); - /** Show the results of the deletion option */ - $('#browse-results').show(); - $('#sqlqueryform').show(); - $('#togglequerybox').show(); + $('#browse-results').load(result_path + " '"+'#result_query' + "'", function () { // FIXME: no need for two ajax reqests here + $('#sqlqueryform').load(result_path + " '"+'#sqlqueryform' + "'", function () { // since they both fetch the same page + /** Refresh the search results after the deletion */ + document.getElementById('buttonGo').click(); + $('#togglequerybox').html(PMA_messages['strHideQueryBox']); + PMA_ajaxRemoveMessage($msg); + /** Show the results of the deletion option */ + $('#browse-results').show(); + $('#sqlqueryform').show(); + $('#togglequerybox').show(); + }); + }); } else { diff --git a/js/functions.js b/js/functions.js index b076661..824c174 100644 --- a/js/functions.js +++ b/js/functions.js @@ -1842,24 +1842,48 @@ $(document).ready(function() { $("#popup_background").fadeIn("fast"); $("#enum_editor").fadeIn("fast"); - // Get the values - var values = $(this).parent().prev("input").attr("value").split(","); - $.each(values, function(index, val) { - if(jQuery.trim(val) != "") { - // enclose the string in single quotes if it's not already - if(val.substr(0, 1) != "'") { - val = "'" + val; - } - if(val.substr(val.length-1, val.length) != "'") { - val = val + "'"; - } - // escape the single quotes, except the mandatory ones enclosing the entire string - val = val.substr(1, val.length-2).replace(/''/g, "'").replace(/\\\\/g, '\\').replace(/\\'/g, "'").replace(/'/g, "'"); - // escape the greater-than symbol - val = val.replace(/>/g, ">"); - $("#enum_editor #values").append("<input type='text' value=" + val + " />"); + // Get the values as a string + var inputstring = $(this) + .parent() + .prev("input") + .val(); + // Escape html entities + inputstring = $('<div/>') + .text(inputstring) + .html(); + // Parse the values, escaping quotes and + // slashes on the fly, into an array + var values = []; + var in_string = false; + var curr, next, buffer = ''; + for (var i=0; i<inputstring.length; i++) { + curr = inputstring.charAt(i); + next = i == inputstring.length ? '' : inputstring.charAt(i+1); + if (! in_string && curr == "'") { + in_string = true; + } else if (in_string && curr == "\\" && next == "\\") { + buffer += "\"; + i++; + } else if (in_string && next == "'" && (curr == "'" || curr == "\\")) { + buffer += "'"; + i++; + } else if (in_string && curr == "'") { + in_string = false; + values.push(buffer); + buffer = ''; + } else if (in_string) { + buffer += curr; } - }); + } + if (buffer.length > 0) { + values.push(buffer); + } + // Add the parsed values to the editor + for (var i=0; i<values.length; i++) { + $("#enum_editor #values").append( + "<input type='text' value='" + values[i] + "' />" + ); + } // So we know which column's data is being edited $("#enum_editor").append("<input type='hidden' value='" + $(this).parent().prev("input").attr("id") + "' />"); return false; @@ -2249,15 +2273,7 @@ $(document).ready(function() { * Load version information asynchronously. */ if ($('.jsversioncheck').length > 0) { - (function() { - var s = document.createElement('script'); - s.type = 'text/javascript'; - s.async = true; - s.src = 'http://www.phpmyadmin.net/home_page/version.js'; - s.onload = PMA_current_version; - var x = document.getElementsByTagName('script')[0]; - x.parentNode.insertBefore(s, x); - })(); + $.getScript('http://www.phpmyadmin.net/home_page/version.js', PMA_current_version); } /** diff --git a/js/sql.js b/js/sql.js index ad91104..3ad3d6e 100644 --- a/js/sql.js +++ b/js/sql.js @@ -705,6 +705,7 @@ $(document).ready(function() { // Make the Ajax call and get the data, wrap it and insert it $.post('sql.php', { 'token' : window.parent.token, + 'server' : window.parent.server, 'db' : window.parent.db, 'ajax_request' : true, 'sql_query' : sql_query, @@ -728,6 +729,7 @@ $(document).ready(function() { var post_params = { 'ajax_request' : true, 'get_relational_values' : true, + 'server' : window.parent.server, 'db' : window.parent.db, 'table' : window.parent.table, 'column' : field_name, @@ -753,6 +755,7 @@ $(document).ready(function() { var post_params = { 'ajax_request' : true, 'get_enum_values' : true, + 'server' : window.parent.server, 'db' : window.parent.db, 'table' : window.parent.table, 'column' : field_name, @@ -776,6 +779,7 @@ $(document).ready(function() { var post_params = { 'ajax_request' : true, 'get_set_values' : true, + 'server' : window.parent.server, 'db' : window.parent.db, 'table' : window.parent.table, 'column' : field_name, @@ -991,6 +995,7 @@ $(document).ready(function() { 'sql_query' : sql_query, 'disp_direction' : disp_mode, 'token' : window.parent.token, + 'server' : window.parent.server, 'db' : window.parent.db, 'table' : window.parent.table, 'clause_is_unique' : nonunique, diff --git a/js/tbl_change.js b/js/tbl_change.js index 8fc7eca..234e4e1 100644 --- a/js/tbl_change.js +++ b/js/tbl_change.js @@ -26,14 +26,13 @@ function nullify(theType, urlField, md5Field, multi_edit) rowForm.elements['funcs' + multi_edit + '[' + md5Field + ']'].selectedIndex = -1; } - // "SET" field , "ENUM" field with more than 20 characters - // or foreign key field (drop-down) - if (theType == 1 || theType == 3 || theType == 4) { - rowForm.elements['field_' + md5Field + multi_edit + '[]'].selectedIndex = -1; + // "ENUM" field with more than 20 characters + if (theType == 1) { + rowForm.elements['fields' + multi_edit + '[' + md5Field + ']'][1].selectedIndex = -1; } // Other "ENUM" field else if (theType == 2) { - var elts = rowForm.elements['field_' + md5Field + multi_edit + '[]']; + var elts = rowForm.elements['fields' + multi_edit + '[' + md5Field + ']']; // when there is just one option in ENUM: if (elts.checked) { elts.checked = false; @@ -45,9 +44,17 @@ function nullify(theType, urlField, md5Field, multi_edit) } // end if } + // "SET" field + else if (theType == 3) { + rowForm.elements['fields' + multi_edit + '[' + md5Field + '][]'].selectedIndex = -1; + } + // Foreign key field (drop-down) + else if (theType == 4) { + rowForm.elements['fields' + multi_edit + '[' + md5Field + ']'].selectedIndex = -1; + } // foreign key field (with browsing icon for foreign values) else if (theType == 6) { - rowForm.elements['field_' + md5Field + multi_edit + '[]'].value = ''; + rowForm.elements['fields' + multi_edit + '[' + md5Field + ']'].value = ''; } // Other field types else /*if (theType == 5)*/ { diff --git a/js/tbl_structure.js b/js/tbl_structure.js index 493f0eb..97ec6c2 100644 --- a/js/tbl_structure.js +++ b/js/tbl_structure.js @@ -42,6 +42,10 @@ $(document).ready(function() { */ var curr_column_name = $(curr_row).children('th').children('label').text(); /** + * @var $after_field_item Corresponding entry in the 'After' field. + */ + var $after_field_item = $("select[name='after_field'] option[value='" + curr_column_name + "']"); + /** * @var question String containing the question to be asked for confirmation */ var question = PMA_messages['strDoYouReally'] + ' :\n ALTER TABLE `' + escapeHtml(curr_table_name) + '` DROP `' + escapeHtml(curr_column_name) + '`'; @@ -53,6 +57,7 @@ $(document).ready(function() { $.get(url, {'is_js_confirmed' : 1, 'ajax_request' : true}, function(data) { if(data.success == true) { PMA_ajaxShowMessage(data.message); + $after_field_item.remove(); $(curr_row).hide("medium").remove(); } else { diff --git a/libraries/Config.class.php b/libraries/Config.class.php index f42ad6e..cbcb3e4 100644 --- a/libraries/Config.class.php +++ b/libraries/Config.class.php @@ -96,7 +96,7 @@ class PMA_Config */ function checkSystem() { - $this->set('PMA_VERSION', '3.4.7.1'); + $this->set('PMA_VERSION', '3.4.8'); /** * @deprecated */ diff --git a/libraries/Error.class.php b/libraries/Error.class.php index 2cfd5fe..595799b 100644 --- a/libraries/Error.class.php +++ b/libraries/Error.class.php @@ -175,7 +175,7 @@ class PMA_Error extends PMA_Message $this->getMessage() . $this->getFile() . $this->getLine() . - $this->getBacktrace() + serialize($this->getBacktrace()) ); } diff --git a/libraries/auth/cookie.auth.lib.php b/libraries/auth/cookie.auth.lib.php index c04d5a2..93b567a 100644 --- a/libraries/auth/cookie.auth.lib.php +++ b/libraries/auth/cookie.auth.lib.php @@ -549,6 +549,10 @@ function PMA_auth_set_user() $cfg['Server']['user'] = $GLOBALS['PHP_AUTH_USER']; $cfg['Server']['password'] = $GLOBALS['PHP_AUTH_PW']; + // Avoid showing the password in phpinfo()'s output + unset($GLOBALS['PHP_AUTH_PW']); + unset($_SERVER['PHP_AUTH_PW']); + $_SESSION['last_access_time'] = time(); // Name and password cookies need to be refreshed each time diff --git a/libraries/auth/http.auth.lib.php b/libraries/auth/http.auth.lib.php index b3d305a..b4bc030 100644 --- a/libraries/auth/http.auth.lib.php +++ b/libraries/auth/http.auth.lib.php @@ -207,6 +207,10 @@ function PMA_auth_set_user() $cfg['Server']['user'] = $PHP_AUTH_USER; $cfg['Server']['password'] = $PHP_AUTH_PW; + // Avoid showing the password in phpinfo()'s output + unset($GLOBALS['PHP_AUTH_PW']); + unset($_SERVER['PHP_AUTH_PW']); + return true; } // end of the 'PMA_auth_set_user()' function diff --git a/libraries/common.lib.php b/libraries/common.lib.php index ad38266..caeeee2 100644 --- a/libraries/common.lib.php +++ b/libraries/common.lib.php @@ -1059,13 +1059,10 @@ function PMA_showMessage($message, $sql_query = null, $type = 'notice', $is_view } else { // Parse SQL if needed $parsed_sql = PMA_SQP_parse($query_base); - if (PMA_SQP_isError()) { - unset($parsed_sql); - } } // Analyze it - if (isset($parsed_sql)) { + if (isset($parsed_sql) && ! PMA_SQP_isError()) { $analyzed_display_query = PMA_SQP_analyze($parsed_sql); // Here we append the LIMIT added for navigation, to // enable its display. Adding it higher in the code diff --git a/libraries/db_info.inc.php b/libraries/db_info.inc.php index 44dc3a8..4dc7eb0 100644 --- a/libraries/db_info.inc.php +++ b/libraries/db_info.inc.php @@ -75,6 +75,10 @@ function PMA_fillTooltip(&$tooltip_truename, &$tooltip_aliasname, $table) // remove InnoDB comment from end, just the minimal part (*? is non greedy) $table['Comment'] = preg_replace('@; InnoDB free:.*?$@', '', $table['Comment']); } + // views have VIEW as comment so it's not a real comment put by a user + if ('VIEW' == $table['Comment']) { + $table['Comment'] = ''; + } if (empty($table['Comment'])) { $table['Comment'] = $table['Name']; } else { diff --git a/libraries/import/ods.php b/libraries/import/ods.php index 9016016..cd48f68 100644 --- a/libraries/import/ods.php +++ b/libraries/import/ods.php @@ -42,9 +42,6 @@ if (isset($plugin_list)) { return; } -ini_set('memory_limit', '128M'); -set_time_limit(120); - $i = 0; $len = 0; $buffer = ""; diff --git a/libraries/import/xml.php b/libraries/import/xml.php index ce20fe7..0afbd15 100644 --- a/libraries/import/xml.php +++ b/libraries/import/xml.php @@ -35,9 +35,6 @@ if (isset($plugin_list)) { return; } -ini_set('memory_limit', '128M'); -set_time_limit(120); - $i = 0; $len = 0; $buffer = ""; diff --git a/libraries/select_lang.lib.php b/libraries/select_lang.lib.php index 137b83a..530f150 100644 --- a/libraries/select_lang.lib.php +++ b/libraries/select_lang.lib.php @@ -373,7 +373,7 @@ $GLOBALS['lang_path'] = './locale/'; /** * Load gettext functions. */ -require './libraries/php-gettext/gettext.inc'; +require GETTEXT_INC; /** * @global string interface language diff --git a/libraries/server_synchronize.lib.php b/libraries/server_synchronize.lib.php index c9f1242..53ad9d7 100644 --- a/libraries/server_synchronize.lib.php +++ b/libraries/server_synchronize.lib.php @@ -1,27 +1,27 @@ -<?php +<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** -* PMA_getMatchingTables places matching tables in source +* PMA_getMatchingTables places matching tables in source * and target databases in $matching_tables array whereas * $uncommon_source_tables array gets the tables present in * source database but are absent from target database. * Criterion for matching tables is just comparing their names. -* -* @param $trg_tables array of target database table names, -* @param $src_tables array of source database table names, -* -* @param &$matching_tables empty array passed by reference to save names of matching tables, -* @param &$uncommon_source_tables empty array passed by reference to save names of tables present in +* +* @param $trg_tables array of target database table names, +* @param $src_tables array of source database table names, +* +* @param &$matching_tables empty array passed by reference to save names of matching tables, +* @param &$uncommon_source_tables empty array passed by reference to save names of tables present in * source database but absent from target database */ - + function PMA_getMatchingTables($trg_tables, $src_tables, &$matching_tables, &$uncommon_source_tables) { - for($k=0; $k< sizeof($src_tables); $k++) { - $present_in_target = false; - for($l=0; $l < sizeof($trg_tables); $l++) { - if ($src_tables[$k] === $trg_tables[$l]) { + for($k=0; $k< sizeof($src_tables); $k++) { + $present_in_target = false; + for($l=0; $l < sizeof($trg_tables); $l++) { + if ($src_tables[$k] === $trg_tables[$l]) { $present_in_target = true; $matching_tables[] = $src_tables[$k]; } @@ -35,30 +35,30 @@ function PMA_getMatchingTables($trg_tables, $src_tables, &$matching_tables, &$un /** * PMA_getNonMatchingTargetTables() places tables present * in target database but are absent from source database -* -* @param $trg_tables array of target database table names, -* -* @param $matching_tables $matching tables array containing names of matching tables, -* @param &$uncommon_target_tables empty array passed by reference to save names of tables presnet in +* +* @param $trg_tables array of target database table names, +* +* @param $matching_tables $matching tables array containing names of matching tables, +* @param &$uncommon_target_tables empty array passed by reference to save names of tables presnet in * target database but absent from source database */ function PMA_getNonMatchingTargetTables($trg_tables, $matching_tables, &$uncommon_target_tables) { for($c=0; $c<sizeof($trg_tables) ;$c++) { - $match = false; + $match = false; for($d=0; $d < sizeof($matching_tables); $d++) { if ($trg_tables[$c] === $matching_tables[$d]) { $match=true; - } + } } if ($match === false) { $uncommon_target_tables[] = $trg_tables[$c]; - } + } } } - + /** * PMA_dataDiffInTables() finds the difference in source and target matching tables by * first comparing source table's primary key entries with target table enteries. @@ -67,32 +67,32 @@ function PMA_getNonMatchingTargetTables($trg_tables, $matching_tables, &$uncommo * field values also, in order to check whether update is required or not. * If update is required, it is placed in $update_array * Otherwise that entry is placed in the $insert_array. - * + * * @uses PMA_DBI_get_fields() * @uses PMA_DBI_get_column_values() * @uses PMA_DBI_fetch_result() - * + * * @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server - * @param $index Index of a table from $matching_table array - * - * @param $update_array A three dimensional array passed by reference to + * @param $index Index of a table from $matching_table array + * + * @param $update_array A three dimensional array passed by reference to * contain updates required for each matching table - * @param $insert_array A three dimensional array passed by reference to + * @param $insert_array A three dimensional array passed by reference to * contain inserts required for each matching table - * @param $fields_num A two dimensional array passed by reference to + * @param $fields_num A two dimensional array passed by reference to * contain number of fields for each matching table * @param $matching_table array containing matching table names - * + * * @param $matching_tables_fields A two dimensional array passed by reference to contain names of fields for each matching table - * + * * @param $matching_tables_keys A two dimensional array passed by reference to contain names of keys for each matching table - */ + */ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching_table, &$matching_tables_fields, &$update_array, &$insert_array, &$delete_array, &$fields_num, $matching_table_index, &$matching_tables_keys) -{ +{ if (isset($matching_table[$matching_table_index])) { $fld = array(); $fld_results = PMA_DBI_get_fields($src_db, $matching_table[$matching_table_index], $src_link); @@ -104,80 +104,80 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching $is_key[] = $field_name; } $fld[] = $field_name; - } + } } - $matching_tables_fields[$matching_table_index] = $fld; + $matching_tables_fields[$matching_table_index] = $fld; $fields_num[$matching_table_index] = sizeof($fld); $matching_tables_keys[$matching_table_index] = $is_key; - - $source_result_set = PMA_DBI_get_column_values($src_db, $matching_table[$matching_table_index], $is_key, $src_link); + + $source_result_set = PMA_DBI_get_column_values($src_db, $matching_table[$matching_table_index], $is_key, $src_link); $source_size = sizeof($source_result_set); - + $trg_fld_results = PMA_DBI_get_fields($trg_db, $matching_table[$matching_table_index], $trg_link); $all_keys_match = true; $trg_keys = array(); - + if (isset($trg_fld_results)) { foreach ($trg_fld_results as $each_field) { if ($each_field['Key'] == 'PRI') { - $trg_keys[] = $each_field['Field']; + $trg_keys[] = $each_field['Field']; if (! (in_array($each_field['Field'], $is_key))) { $all_keys_match = false; - } - } - } + } + } + } } $update_row = 0; $insert_row = 0; $update_field = 0; $insert_field = 0; - $starting_index = 0; - - for ($j = 0; $j < $source_size; $j++) { + $starting_index = 0; + + for ($j = 0; $j < $source_size; $j++) { $starting_index = 0; - $update_field = 0; + $update_field = 0; if (isset($source_result_set[$j]) && ($all_keys_match)) { // Query the target server to see which rows already exist - $trg_select_query = "SELECT * FROM " . PMA_backquote($trg_db) . "." + $trg_select_query = "SELECT * FROM " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_table[$matching_table_index]) . " WHERE "; - + if (sizeof($is_key) == 1) { - $trg_select_query .= $is_key[0]. "='" . $source_result_set[$j] . "'"; + $trg_select_query .= PMA_backquote($is_key[0]). "='" . $source_result_set[$j] . "'"; } elseif (sizeof($is_key) > 1){ for ($k=0; $k < sizeof($is_key); $k++) { - $trg_select_query .= $is_key[$k] . "='" . $source_result_set[$j][$is_key[$k]] . "'"; + $trg_select_query .= PMA_backquote($is_key[$k]) . "='" . $source_result_set[$j][$is_key[$k]] . "'"; if ($k < (sizeof($is_key)-1)){ - $trg_select_query .= " AND "; + $trg_select_query .= " AND "; } - } + } } - + $target_result_set = PMA_DBI_fetch_result($trg_select_query, null, null, $trg_link); if ($target_result_set) { // Fetch the row from the source server to do a comparison - $src_select_query = "SELECT * FROM " . PMA_backquote($src_db) . "." + $src_select_query = "SELECT * FROM " . PMA_backquote($src_db) . "." . PMA_backquote($matching_table[$matching_table_index]) . " WHERE "; - + if (sizeof($is_key) == 1) { - $src_select_query .= $is_key[0] . "='" . $source_result_set[$j] . "'"; + $src_select_query .= PMA_backquote($is_key[0]) . "='" . $source_result_set[$j] . "'"; } else if(sizeof($is_key) > 1){ for ($k=0; $k< sizeof($is_key); $k++) { - $src_select_query .= $is_key[$k] . "='" . $source_result_set[$j][$is_key[$k]] . "'"; + $src_select_query .= PMA_backquote($is_key[$k]) . "='" . $source_result_set[$j][$is_key[$k]] . "'"; if ($k < (sizeof($is_key) - 1)){ - $src_select_query .= " AND "; + $src_select_query .= " AND "; } } - } - + } + $src_result_set = PMA_DBI_fetch_result($src_select_query, null, null, $src_link); - + /** * Comparing each corresponding field of the source and target matching rows. - * Placing the primary key, value of primary key, field to be updated, and the - * new value of field to be updated in each row of the update array. + * Placing the primary key, value of primary key, field to be updated, and the + * new value of field to be updated in each row of the update array. */ for ($m = 0; ($m < $fields_num[$matching_table_index]) && ($starting_index == 0) ; $m++) { if (isset($src_result_set[0][$fld[$m]])) { @@ -187,19 +187,19 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching if ($source_result_set[$j]) { $update_array[$matching_table_index][$update_row][$is_key[0]] = $source_result_set[$j]; } - } elseif (sizeof($is_key) > 1) { + } elseif (sizeof($is_key) > 1) { for ($n=0; $n < sizeof($is_key); $n++) { if (isset($src_result_set[0][$is_key[$n]])) { $update_array[$matching_table_index][$update_row][$is_key[$n]] = $src_result_set[0][$is_key[$n]]; } } } - + $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m]; - + $update_field++; if (isset($src_result_set[0][$fld[$m]])) { - $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; + $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; $update_field++; } $starting_index = $m; @@ -209,21 +209,21 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching if (sizeof($is_key) == 1) { if ($source_result_set[$j]) { $update_array[$matching_table_index][$update_row][$is_key[0]] = $source_result_set[$j]; - + } - } elseif (sizeof($is_key) > 1) { + } elseif (sizeof($is_key) > 1) { for ($n = 0; $n < sizeof($is_key); $n++) { if (isset($src_result_set[0][$is_key[$n]])) { $update_array[$matching_table_index][$update_row][$is_key[$n]] = $src_result_set[0][$is_key[$n]]; } } } - + $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m]; - + $update_field++; if (isset($src_result_set[0][$fld[$m]])) { - $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; + $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; $update_field++; } $starting_index = $m; @@ -232,28 +232,28 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching } } for ($m = $starting_index + 1; $m < $fields_num[$matching_table_index] ; $m++) - { + { if (isset($src_result_set[0][$fld[$m]])) { - if (isset($target_result_set[0][$fld[$m]])) { + if (isset($target_result_set[0][$fld[$m]])) { if (($src_result_set[0][$fld[$m]] != $target_result_set[0][$fld[$m]]) && (!(in_array($fld[$m], $is_key)))) { - $update_row--; + $update_row--; $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m]; $update_field++; if ($src_result_set[0][$fld[$m]]) { $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; $update_field++; } - $update_row++; + $update_row++; } } else { - $update_row--; + $update_row--; $update_array[$matching_table_index][$update_row][$update_field] = $fld[$m]; $update_field++; if ($src_result_set[0][$fld[$m]]) { $update_array[$matching_table_index][$update_row][$update_field] = $src_result_set[0][$fld[$m]]; $update_field++; } - $update_row++; + $update_row++; } } } @@ -265,7 +265,7 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching if (isset($source_result_set[$j])) { $insert_array[$matching_table_index][$insert_row][$is_key[0]] = $source_result_set[$j]; } - } elseif (sizeof($is_key) > 1) { + } elseif (sizeof($is_key) > 1) { for($l = 0; $l < sizeof($is_key); $l++) { if (isset($source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]])) { $insert_array[$matching_table_index][$insert_row][$is_key[$l]] = $source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]]; @@ -277,13 +277,13 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching } else { /** * Placing the primary key, and the value of primary key of the row that is to be inserted in the target table - * This condition is met when there is an additional column in the source table + * This condition is met when there is an additional column in the source table */ if (sizeof($is_key) == 1) { if (isset($source_result_set[$j])) { $insert_array[$matching_table_index][$insert_row][$is_key[0]] = $source_result_set[$j]; } - } elseif (sizeof($is_key) > 1) { + } elseif (sizeof($is_key) > 1) { for ($l = 0; $l < sizeof($is_key); $l++) { if (isset($source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]])) { $insert_array[$matching_table_index][$insert_row][$is_key[$l]] = $source_result_set[$j][$matching_tables_fields[$matching_table_index][$l]]; @@ -293,34 +293,34 @@ function PMA_dataDiffInTables($src_db, $trg_db, $src_link, $trg_link, &$matching $insert_row++; } } // for loop ends - } -} + } +} /** * PMA_findDeleteRowsFromTargetTables finds the rows which are to be deleted from target table. * @uses sizeof() * @uses PMA_DBI_get_column_values() * @uses in_array() -* -* @param $delete_array array containing rows that are to be deleted +* +* @param $delete_array array containing rows that are to be deleted * @param $matching_table array containing matching table names * @param $matching_table_index index of a table from $matching_table array * @param $trg_keys array of target table keys * @param $src_keys array of source table keys * @param $trg_db name of target database * @param $trg_link connection established with target server -* @param $src_db name of source database +* @param $src_db name of source database * @param $src_link connection established with source server -* +* */ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $matching_table_index, $trg_keys, $src_keys, $trg_db, $trg_link,$src_db, $src_link) { if (isset($trg_keys[$matching_table_index])) { - $target_key_values = PMA_DBI_get_column_values($trg_db, $matching_table[$matching_table_index], $trg_keys[$matching_table_index], $trg_link); - $target_row_size = sizeof($target_key_values); + $target_key_values = PMA_DBI_get_column_values($trg_db, $matching_table[$matching_table_index], $trg_keys[$matching_table_index], $trg_link); + $target_row_size = sizeof($target_key_values); } if (isset($src_keys[$matching_table_index])) { - $source_key_values = PMA_DBI_get_column_values($src_db, $matching_table[$matching_table_index], $src_keys[$matching_table_index], $src_link); - $source_size = sizeof($source_key_values); + $source_key_values = PMA_DBI_get_column_values($src_db, $matching_table[$matching_table_index], $src_keys[$matching_table_index], $src_link); + $source_size = sizeof($source_key_values); } $all_keys_match = 1; for ($a = 0; $a < sizeof($trg_keys[$matching_table_index]); $a++) { @@ -328,7 +328,7 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma if (! (in_array($trg_keys[$matching_table_index][$a], $src_keys[$matching_table_index]))) { $all_keys_match = 0; } - } + } } if (! ($all_keys_match)) { if (isset($target_key_values)) { @@ -337,17 +337,17 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma } if (isset($trg_keys[$matching_table_index])) { if ((sizeof($trg_keys[$matching_table_index]) == 1) && $all_keys_match) { - $row = 0; + $row = 0; if (isset($target_key_values)) { for ($i = 0; $i < sizeof($target_key_values); $i++) { if (! (in_array($target_key_values[$i], $source_key_values))) { $delete_array[$matching_table_index][$row] = $target_key_values[$i]; - $row++; + $row++; } - } + } } } elseif ((sizeof($trg_keys[$matching_table_index]) > 1) && $all_keys_match) { - $row = 0; + $row = 0; if (isset($target_key_values)) { for ($i = 0; $i < sizeof($target_key_values); $i++) { $is_present = false; @@ -356,7 +356,7 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma for ($k = 0; $k < sizeof($trg_keys[$matching_table_index]); $k++) { if ($target_key_values[$i][$trg_keys[$matching_table_index][$k]] != $source_key_values[$j][$trg_keys[$matching_table_index][$k]]) { $check = false; - } + } } if ($check) { $is_present = true; @@ -368,16 +368,16 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma } $row++; } - } - } + } + } } - } + } } /** * PMA_dataDiffInUncommonTables() finds the data difference in $source_tables_uncommon * @uses PMA_DBI_fetch_result() -* +* * @param $source_tables_uncommon array of table names; containing table names that are in source db and not in target db * @param $src_db name of source database * @param $src_link connection established with source server @@ -387,9 +387,9 @@ function PMA_findDeleteRowsFromTargetTables(&$delete_array, $matching_table, $ma function PMA_dataDiffInUncommonTables($source_tables_uncommon, $src_db, $src_link, $index, &$row_count) { - $query = "SELECT COUNT(*) FROM " . PMA_backquote($src_db) . "." . PMA_backquote($source_tables_uncommon[$index]); - $rows = PMA_DBI_fetch_result($query, null, null, $src_link); - $row_count[$index] = $rows[0]; + $query = "SELECT COUNT(*) FROM " . PMA_backquote($src_db) . "." . PMA_backquote($source_tables_uncommon[$index]); + $rows = PMA_DBI_fetch_result($query, null, null, $src_link); + $row_count[$index] = $rows[0]; } /** @@ -397,35 +397,35 @@ function PMA_dataDiffInUncommonTables($source_tables_uncommon, $src_db, $src_lin * * @uses PMA_DBI_fetch_result() * @uses PMA_backquote() -* -* @param $table Array containing matching tables' names +* +* @param $table Array containing matching tables' names * @param $update_array A three dimensional array containing field * value updates required for each matching table -* @param $src_db Name of source database +* @param $src_db Name of source database * @param $trg_db Name of target database * @param $trg_link Connection established with target server -* @param $matching_table_index index of matching table in matching_table_array +* @param $matching_table_index index of matching table in matching_table_array * @param $display true/false value -*/ +*/ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_link, $matching_table_index, $matching_table_keys, $display) -{ +{ if (isset($update_array[$matching_table_index])) { if (sizeof($update_array[$matching_table_index])) { - + for ($update_row = 0; $update_row < sizeof($update_array[$matching_table_index]); $update_row++) { - - if (isset($update_array[$matching_table_index][$update_row])) { + + if (isset($update_array[$matching_table_index][$update_row])) { $update_fields_num = sizeof($update_array[$matching_table_index][$update_row])-sizeof($matching_table_keys[$matching_table_index]); if ($update_fields_num > 0) { - $query = "UPDATE " . PMA_backquote($trg_db) . "." .PMA_backquote($table[$matching_table_index]) . " SET "; - + $query = "UPDATE " . PMA_backquote($trg_db) . "." .PMA_backquote($table[$matching_table_index]) . " SET "; + for ($update_field = 0; $update_field < $update_fields_num; $update_field = $update_field+2) { if (isset($update_array[$matching_table_index][$update_row][$update_field]) && isset($update_array[$matching_table_index][$update_row][$update_field+1])) { - $query .= $update_array[$matching_table_index][$update_row][$update_field] . "='" . $update_array[$matching_table_index][$update_row][$update_field+1] . "'"; + $query .= PMA_backquote($update_array[$matching_table_index][$update_row][$update_field]) . "='" . $update_array[$matching_table_index][$update_row][$update_field+1] . "'"; } if ($update_field < ($update_fields_num - 2)) { - $query .= ", "; + $query .= ", "; } } $query .= " WHERE "; @@ -433,8 +433,8 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li for ($key = 0; $key < sizeof($matching_table_keys[$matching_table_index]); $key++) { if (isset($matching_table_keys[$matching_table_index][$key])) { - - $query .= $matching_table_keys[$matching_table_index][$key] . "='" . $update_array[$matching_table_index][$update_row][$matching_table_keys[$matching_table_index][$key]] . "'"; + + $query .= PMA_backquote($matching_table_keys[$matching_table_index][$key]) . "='" . $update_array[$matching_table_index][$update_row][$matching_table_keys[$matching_table_index][$key]] . "'"; } if ($key < (sizeof($matching_table_keys[$matching_table_index]) - 1)) { $query .= " AND "; @@ -443,29 +443,29 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li } if ($display == true) { echo "<p>" . $query . "</p>"; - } + } PMA_DBI_try_query($query, $trg_link, 0); } - } + } } } } } /** * PMA_insertIntoTargetTable() inserts missing rows in the target table using $array_insert[$matching_table_index] -* +* * @uses PMA_DBI_fetch_result() * @uses PMA_backquote() -* -* +* +* * @param $matching_table array containing matching table names * @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server * @param $table_fields array containing field names of a table -* @param $array_insert -* @param $matching_table_index index of matching table in matching_table_array +* @param $array_insert +* @param $matching_table_index index of matching table in matching_table_array * @param $matching_tables_keys array containing field names that are keys in the matching table * @param $source_columns array containing source column information * @param $add_column_array array containing column names that are to be added in target table @@ -474,79 +474,79 @@ function PMA_updateTargetTables($table, $update_array, $src_db, $trg_db, $trg_li * @param $uncommon_tables array containing table names that are present in source db but not in targt db * @param $uncommon_tables_fields array containing field names of the uncommon tables * @param $uncommon_cols column names that are present in target table and not in source table -* @param $alter_str_array array containing column names that are to be altered -* @param $source_indexes column names on which indexes are made in source table -* @param $target_indexes column names on which indexes are made in target table +* @param $alter_str_array array containing column names that are to be altered +* @param $source_indexes column names on which indexes are made in source table +* @param $target_indexes column names on which indexes are made in target table * @param $add_indexes_array array containing column names on which index is to be added in target table -* @param $alter_indexes_array array containing column names whose indexes are to be altered. Only index name and uniqueness of an index can be changed +* @param $alter_indexes_array array containing column names whose indexes are to be altered. Only index name and uniqueness of an index can be changed * @param $delete_array array containing rows that are to be deleted * @param $update_array array containing rows that are to be updated in target * @param $display true/false value * */ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, $trg_link, $table_fields, &$array_insert, $matching_table_index, - $matching_tables_keys, $source_columns, &$add_column_array, $criteria, $target_tables_keys, $uncommon_tables, &$uncommon_tables_fields,$uncommon_cols, + $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, $display) -{ +{ if(isset($array_insert[$matching_table_index])) { if (sizeof($array_insert[$matching_table_index])) { for ($insert_row = 0; $insert_row< sizeof($array_insert[$matching_table_index]); $insert_row++) { if (isset($array_insert[$matching_table_index][$insert_row][$matching_tables_keys[$matching_table_index][0]])) { - + $select_query = "SELECT * FROM " . PMA_backquote($src_db) . "." . PMA_backquote($matching_table[$matching_table_index]) . " WHERE "; for ($i = 0; $i < sizeof($matching_tables_keys[$matching_table_index]); $i++) { $select_query .= $matching_tables_keys[$matching_table_index][$i] . "='"; $select_query .= $array_insert[$matching_table_index][$insert_row][$matching_tables_keys[$matching_table_index][$i]] . "'" ; - + if ($i < (sizeof($matching_tables_keys[$matching_table_index]) - 1)) { - $select_query.= " AND "; + $select_query.= " AND "; } } $select_query .= "; "; $result = PMA_DBI_fetch_result ($select_query, null, null, $src_link); $insert_query = "INSERT INTO " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_table[$matching_table_index]) ." ("; - - for ($field_index = 0; $field_index < sizeof($table_fields[$matching_table_index]); $field_index++) + + for ($field_index = 0; $field_index < sizeof($table_fields[$matching_table_index]); $field_index++) { - $insert_query .= $table_fields[$matching_table_index][$field_index]; - - $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db ."' + $insert_query .= PMA_backquote($table_fields[$matching_table_index][$field_index]); + + $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db ."' AND TABLE_NAME = '" . $matching_table[$matching_table_index]. "'AND COLUMN_NAME = '" . $table_fields[$matching_table_index][$field_index] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;" ; - + $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $trg_link); if (sizeof($is_fk_result) > 0) { for ($j = 0; $j < sizeof($is_fk_result); $j++) { $table_index = array_keys($matching_table, $is_fk_result[$j]['REFERENCED_TABLE_NAME']); - + if (isset($alter_str_array[$table_index[0]])) { PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, $source_columns, $alter_str_array, $matching_tables_fields, $criteria, $matching_tables_keys, $target_tables_keys, $table_index[0], $display); - unset($alter_str_array[$table_index[0]]); - } + unset($alter_str_array[$table_index[0]]); + } if (isset($uncommon_columns[$table_index[0]])) { PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $table_index[0], $display); - unset($uncommon_columns[$table_index[0]]); - } + unset($uncommon_columns[$table_index[0]]); + } if (isset($add_column_array[$table_index[0]])) { PMA_findDeleteRowsFromTargetTables($delete_array, $matching_tables, $table_index[0], $target_tables_keys, $matching_tables_keys, $trg_db, $trg_link, $src_db, $src_link); - + if (isset($delete_array[$table_index[0]])) { PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index[0], $target_tables_keys, $delete_array, $display); - unset($delete_array[$table_index[0]]); - } - PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $matching_tables, $source_columns, $add_column_array, + unset($delete_array[$table_index[0]]); + } + 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, $table_index[0], $uncommon_cols, $display); unset($add_column_array[$table_index[0]]); } - if (isset($add_indexes_array[$table_index[0]]) || isset($remove_indexes_array[$table_index[0]]) + if (isset($add_indexes_array[$table_index[0]]) || isset($remove_indexes_array[$table_index[0]]) || isset($alter_indexes_array[$table_index[0]])) { - PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, - $remove_indexes_array, $table_index[0], $display); - + PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, + $remove_indexes_array, $table_index[0], $display); + unset($add_indexes_array[$table_index[0]]); unset($alter_indexes_array[$table_index[0]]); unset($remove_indexes_array[$table_index[0]]); @@ -559,16 +559,16 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, if (isset($array_insert[$table_index[0]])) { PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, $trg_link, $table_fields, $array_insert, $table_index[0], $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, $display); + $uncommon_tables_fields, $uncommon_cols, $alter_str_array, $source_indexes, $target_indexes, $add_indexes_array, + $alter_indexes_array, $delete_array, $update_array, $display); unset($array_insert[$table_index[0]]); - } + } } } if ($field_index < sizeof($table_fields[$matching_table_index])-1) { $insert_query .= ", "; } - } + } $insert_query .= ") VALUES("; if (sizeof($table_fields[$matching_table_index]) == 1) { $insert_query .= "'" . PMA_sqlAddslashes($result[0]) . "'"; @@ -581,35 +581,35 @@ function PMA_insertIntoTargetTable($matching_table, $src_db, $trg_db, $src_link, } if ($field_index < (sizeof($table_fields[$matching_table_index])) - 1) { $insert_query .= " ," ; - } + } } - } + } $insert_query .= ");"; if ($display == true) { PMA_displayQuery($insert_query); } PMA_DBI_try_query($insert_query, $trg_link, 0); - } + } } } } -} +} /** -* PMA_createTargetTables() Create the missing table $uncommon_table in target database -* +* PMA_createTargetTables() Create the missing table $uncommon_table in target database +* * @uses PMA_DBI_get_fields() * @uses PMA_backquote() * @uses PMA_DBI_fetch_result() -* -* @param $src_db name of source database +* +* @param $src_db name of source database * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $src_link connection established with source server * @param $uncommon_table name of table present in source but not in target -* @param $table_index index of table in matching_table_array +* @param $table_index index of table in matching_table_array * @param $uncommon_tables_fields field names of the uncommon table * @param $display true/false value -*/ +*/ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncommon_tables, $table_index, &$uncommon_tables_fields, $display) { if (isset($uncommon_tables[$table_index])) { @@ -619,20 +619,20 @@ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncomm $field_name = $each_field['Field']; $fields[] = $field_name; } - $uncommon_tables_fields[$table_index] = $fields; - + $uncommon_tables_fields[$table_index] = $fields; + $Create_Query = PMA_DBI_fetch_value("SHOW CREATE TABLE " . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), 0, 1, $src_link); // Replace the src table name with a `dbname`.`tablename` - $Create_Table_Query = preg_replace('/' . preg_quote(PMA_backquote($uncommon_tables[$table_index]), '/') . '/', + $Create_Table_Query = preg_replace('/' . preg_quote(PMA_backquote($uncommon_tables[$table_index]), '/') . '/', PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]), $Create_Query, $limit = 1 ); - $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' + $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' AND TABLE_NAME = '" . $uncommon_tables[$table_index] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;" ; - + $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link); if (sizeof($is_fk_result) > 0) { for ($j = 0; $j < sizeof($is_fk_result); $j++) @@ -641,14 +641,14 @@ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncomm $table_index = array_keys($uncommon_tables, $is_fk_result[$j]['REFERENCED_TABLE_NAME']); PMA_createTargetTables($src_db, $trg_db, $trg_link, $src_link, $uncommon_tables, $table_index[0], $uncommon_tables_fields, $display); unset($uncommon_tables[$table_index[0]]); - } + } } } if ($display == true) { echo '<p>' . $Create_Table_Query . '</p>'; } PMA_DBI_try_query($Create_Table_Query, $trg_link, 0); - } + } } /** * PMA_populateTargetTables() inserts data into uncommon tables after they have been created @@ -656,24 +656,24 @@ function PMA_createTargetTables($src_db, $trg_db, $src_link, $trg_link, &$uncomm * @uses PMA_backquote() * @uses sizeof() * @uses PMA_DBI_try_query() -* +* * @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server -* @param $uncommon_tables array containing uncommon table names (table names that are present in source but not in target db) -* @param $table_index index of table in matching_table_array +* @param $uncommon_tables array containing uncommon table names (table names that are present in source but not in target db) +* @param $table_index index of table in matching_table_array * @param $uncommon_tables_fields field names of the uncommon table * @param $display true/false value * * FIXME: This turns NULL values into '' (empty string) */ -function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display) -{ +function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display) +{ $display = false; // todo: maybe display some of the queries if they are not too numerous $unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED); if (false !== $unbuffered_result) { - $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES'; + $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES'; while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) { $insert_query .= '('; $key_of_last_value = count($one_row) - 1; @@ -694,53 +694,54 @@ function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncom } } /** -* PMA_deleteFromTargetTable() delete rows from target table +* PMA_deleteFromTargetTable() delete rows from target table * @uses sizeof() * @uses PMA_backquote() * @uses PMA_DBI_try_query() -* -* +* +* * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $matching_tables array containing matching table names * @param $table_index index of table in matching_table_array * @param $target_table_keys primary key names of the target tables -* @param $delete array array containing the key values of rows that are to be deleted +* @param $delete array array containing the key values of rows that are to be deleted * @param $display true/false value */ -function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index, $target_tables_keys, $delete_array, $display) +function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_index, $target_tables_keys, $delete_array, $display) { for($i = 0; $i < sizeof($delete_array[$table_index]); $i++) { if (isset($target_tables_keys[$table_index])) { - $delete_query = 'DELETE FROM ' . PMA_backquote($trg_db) . '.' .PMA_backquote($matching_tables[$table_index]) . ' WHERE '; + $delete_query = 'DELETE FROM ' . PMA_backquote($trg_db) . '.' .PMA_backquote($matching_tables[$table_index]) . ' WHERE '; for($y = 0; $y < sizeof($target_tables_keys[$table_index]); $y++) { - $delete_query .= $target_tables_keys[$table_index][$y] . " = '"; - + + $delete_query .= PMA_backquote($target_tables_keys[$table_index][$y]) . " = '"; + if (sizeof($target_tables_keys[$table_index]) == 1) { - $delete_query .= $delete_array[$table_index][$i] . "'"; + $delete_query .= $delete_array[$table_index][$i] . "'"; } elseif (sizeof($target_tables_keys[$table_index]) > 1) { $delete_query .= $delete_array[$table_index][$i][$target_tables_keys[$table_index][$y]] . "'"; } if ($y < (sizeof($target_tables_keys[$table_index]) - 1)) { $delete_query .= ' AND '; } - $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' + $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' AND REFERENCED_TABLE_NAME = '" . $matching_tables[$table_index]."' AND REFERENCED_COLUMN_NAME = '" . $target_tables_keys[$table_index][$y] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;"; - + $pk_query_result = PMA_DBI_fetch_result($pk_query, null, null, $trg_link); $result_size = sizeof($pk_query_result); - + if ($result_size > 0) { for ($b = 0; $b < $result_size; $b++) { - $drop_pk_query = "DELETE FROM " . PMA_backquote($pk_query_result[$b]['TABLE_SCHEMA']) . "." . PMA_backquote($pk_query_result[$b]['TABLE_NAME']) . " WHERE " . $pk_query_result[$b]['COLUMN_NAME'] . " = " . $target_tables_keys[$table_index][$y] . ";"; + $drop_pk_query = "DELETE FROM " . PMA_backquote($pk_query_result[$b]['TABLE_SCHEMA']) . "." . PMA_backquote($pk_query_result[$b]['TABLE_NAME']) . " WHERE " . PMA_backquote($pk_query_result[$b]['COLUMN_NAME']) . " = " . $target_tables_keys[$table_index][$y] . ";"; PMA_DBI_try_query($drop_pk_query, $trg_link, 0); - } - } - } + } + } + } } if ($display == true) { - echo '<p>' . $delete_query . '</p>'; + echo '<p>' . $delete_query . '</p>'; } PMA_DBI_try_query($delete_query, $trg_link, 0); } @@ -753,45 +754,45 @@ function PMA_deleteFromTargetTable($trg_db, $trg_link, $matching_tables, $table_ * If column exists in target table but criteria is different then it is palced in $alter_str_array. * If column does not exist in source table but is present in target table then it is placed in $uncommon_columns. * Keys for all the source tables that have a corresponding target table are placed in $matching_tables_keys. -* Keys for all the target tables that have a corresponding source table are placed in $target_tables_keys. -* +* Keys for all the target tables that have a corresponding source table are placed in $target_tables_keys. +* * @uses PMA_DBI_get_columns_full() -* @uses sizeof() -* -* @param $src_db name of source database +* @uses sizeof() +* +* @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server * @param $matching_tables array containing names of matching tables * @param $source_columns array containing columns information of the source tables * @param $target_columns array containing columns information of the target tables -* @param $alter_str_array three dimensional associative array first index being the matching table index, second index being column name for which target +* @param $alter_str_array three dimensional associative array first index being the matching table index, second index being column name for which target * column have some criteria different and third index containing the criteria which is different. -* @param $add_column_array two dimensional associative array, first index of the array contain the matching table number and second index contain the +* @param $add_column_array two dimensional associative array, first index of the array contain the matching table number and second index contain the * column name which is to be added in the target table * @param $uncommon_columns array containing the columns that are present in the target table but not in the source table * @param $criteria array containing the criterias which are to be checked for field that is present in source table and target table * @param $target_tables_keys array containing the field names which is key in the target table -* @param $matching_table_index integer number of the matching table -* +* @param $matching_table_index integer number of the matching table +* */ function 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, $matching_table_index) + &$add_column_array, &$uncommon_columns, $criteria, &$target_tables_keys, $matching_table_index) { //Gets column information for source and target table $source_columns[$matching_table_index] = PMA_DBI_get_columns_full($src_db, $matching_tables[$matching_table_index], null, $src_link); $target_columns[$matching_table_index] = PMA_DBI_get_columns_full($trg_db, $matching_tables[$matching_table_index], null, $trg_link); foreach ($source_columns[$matching_table_index] as $column_name => $each_column) { if (isset($target_columns[$matching_table_index][$column_name]['Field'])) { - //If column exists in target table then matches criterias like type, null, collation, key, default, comment of the column + //If column exists in target table then matches criterias like type, null, collation, key, default, comment of the column for ($i = 0; $i < sizeof($criteria); $i++) { if ($source_columns[$matching_table_index][$column_name][$criteria[$i]] != $target_columns[$matching_table_index][$column_name][$criteria[$i]]) { if (($criteria[$i] == 'Default') && ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == '' )) { - $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = 'None'; + $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = 'None'; } else { if (! (($criteria[$i] == 'Key') && (($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL') - || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL') - || ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI') + || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'MUL') + || ($source_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI') || ($target_columns[$matching_table_index][$column_name][$criteria[$i]] == 'UNI')))) { $alter_str_array[$matching_table_index][$column_name][$criteria[$i]] = $source_columns[$matching_table_index][$column_name][$criteria[$i]]; } @@ -805,17 +806,17 @@ function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matc //Finds column names that are present in target table but not in source table foreach ($target_columns[$matching_table_index] as $fld_name => $each_column) { if (! (isset($source_columns[$matching_table_index][$fld_name]['Field']))) { - $fields_uncommon[] = $fld_name; + $fields_uncommon[] = $fld_name; } if ($target_columns[$matching_table_index][$fld_name]['Key'] == 'PRI') { $keys[] = $fld_name; } } if (isset($fields_uncommon)) { - $uncommon_columns[$matching_table_index] = $fields_uncommon; + $uncommon_columns[$matching_table_index] = $fields_uncommon; } if (isset($keys)) { - $target_tables_keys[$matching_table_index] = $keys; + $target_tables_keys[$matching_table_index] = $keys; } } /** @@ -827,8 +828,8 @@ function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matc * @uses PMA_createTargetTables() * @uses PMA_DBI_try_query() * @uses PMA_DBI_fetch_result() -* -* @param $src_db name of source database +* +* @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server @@ -836,7 +837,7 @@ function PMA_structureDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matc * @param $source_columns array containing columns information of the source tables * @param $add_column_array array containing the names of the column(field) that are to be added in the target * @param $matching_tables_fields -* @param $criteria array containing the criterias +* @param $criteria array containing the criterias * @param $matching_tables_keys array containing the field names which is key in the source table * @param $target_tables_keys array containing the field names which is key in the target table * @param $uncommon_tables array containing the table names that are present in source db and not in target db @@ -851,12 +852,12 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma for ($i = 0; $i < sizeof($matching_tables_fields[$table_counter]); $i++) { if (isset($add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]])) { $query = "ALTER TABLE " . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$table_counter]). " ADD COLUMN " . - $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . " " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Type']; - + PMA_backquote($add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]]) . " " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Type']; + if($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Null'] == 'NO') { $query .= ' Not Null '; } elseif ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Null'] == 'YES') { - $query .= ' Null '; + $query .= ' Null '; } if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Collation'] != '') { $query .= ' COLLATE ' . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Collation']; @@ -865,45 +866,45 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma $query .= " DEFAULT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Default']; } if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment'] != '') { - $query .= " COMMENT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment']; - } - if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Key'] == 'PRI' ) { + $query .= " COMMENT " . $source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Comment']; + } + if ($source_columns[$table_counter][$matching_tables_fields[$table_counter][$i]]['Key'] == 'PRI' ) { $trg_key_size = sizeof($target_tables_keys[$table_counter]); if ($trg_key_size) { $check = true; - for ($a = 0; ($a < $trg_key_size) && ($check); $a++) { + for ($a = 0; ($a < $trg_key_size) && ($check); $a++) { if (! (in_array($target_tables_keys[$table_counter], $uncommon_cols))) { $check = false; - } + } } if (! $check) { - $query .= " ,DROP PRIMARY KEY " ; + $query .= " ,DROP PRIMARY KEY " ; } - } + } $query .= " , ADD PRIMARY KEY ("; for ($t = 0; $t < sizeof($matching_tables_keys[$table_counter]); $t++) { - $query .= $matching_tables_keys[$table_counter][$t]; + $query .= PMA_backquote($matching_tables_keys[$table_counter][$t]); if ($t < (sizeof($matching_tables_keys[$table_counter]) - 1)) { $query .= " , " ; } } $query .= ")"; } - + $query .= ";"; if ($display == true) { echo '<p>' . $query . '</p>'; } PMA_DBI_try_query($query, $trg_link, 0); - + //Checks if column to be added is a foreign key or not $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '" . $matching_tables[$table_counter] . "' AND COLUMN_NAME ='" . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;"; - + $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link); - - //If column is a foreign key then it is checked that referenced table exist in target db. If referenced table does not exist in target db then + + //If column is a foreign key then it is checked that referenced table exist in target db. If referenced table does not exist in target db then //it is created first. if (isset($is_fk_result)) { if (in_array($is_fk_result[0]['REFERENCED_TABLE_NAME'], $uncommon_tables)) { @@ -912,12 +913,12 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma PMA_createTargetTables($src_db, $trg_db, $trg_link, $src_link, $uncommon_tables, $table_index[0], $uncommon_tables_fields); unset($uncommon_tables[$table_index[0]]); } - $fk_query = "ALTER TABLE " . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$table_counter]) . - "ADD CONSTRAINT FOREIGN KEY " . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . " + $fk_query = "ALTER TABLE " . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$table_counter]) . + "ADD CONSTRAINT FOREIGN KEY " . PMA_backquote($add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]]) . " (" . $add_column_array[$table_counter][$matching_tables_fields[$table_counter][$i]] . ") REFERENCES " . PMA_backquote($trg_db) . '.' . PMA_backquote($is_fk_result[0]['REFERENCED_TABLE_NAME']) . " (" . $is_fk_result[0]['REFERENCED_COLUMN_NAME'] . ");"; - - PMA_DBI_try_query($fk_query, $trg_link, null); + + PMA_DBI_try_query($fk_query, $trg_link, null); } } } @@ -929,31 +930,31 @@ function PMA_addColumnsInTargetTable($src_db, $trg_db, $src_link, $trg_link, $ma * @uses array_keys() * @uses PMA_checkForeignKeys() * uses PMA_createTargetTables() -* +* * @param $src_db name of source database * @param $src_link connection established with source server * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $referenced_table table whose column is a foreign key in another table -* @param $uncommon_tables array containing names that are uncommon +* @param $uncommon_tables array containing names that are uncommon * @param $uncommon_tables_fields field names of the uncommon table * @param $display true/false value */ function PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link ,$referenced_table, &$uncommon_tables, &$uncommon_tables_fields, $display) { - $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' + $is_fk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $src_db . "' AND TABLE_NAME = '" . $referenced_table . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;"; - + $is_fk_result = PMA_DBI_fetch_result($is_fk_query, null, null, $src_link); if (sizeof($is_fk_result) > 0) { for ($j = 0; $j < sizeof($is_fk_result); $j++) { if (in_array($is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables)) { $table_index = array_keys($uncommon_tables, $is_fk_result[$j]['REFERENCED_TABLE_NAME']); - PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link, $is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables, - $uncommon_tables_fields, $display); + PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link, $is_fk_result[$j]['REFERENCED_TABLE_NAME'], $uncommon_tables, + $uncommon_tables_fields, $display); PMA_createTargetTables($src_db, $trg_db, $trg_link, $src_link, $uncommon_tables, $table_index[0], $uncommon_tables_fields, $display); unset($uncommon_tables[$table_index[0]]); - } + } } } } @@ -964,14 +965,14 @@ function PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link ,$reference * @uses is_string() * @uses is_numeric() * @uses PMA_DBI_try_query() -* -* +* +* * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $matching_tables array containing names of matching tables * @param $source_columns array containing columns information of the source table * @param $alter_str_array array containing the column name and criteria which is to be altered for the targert table -* @param $matching_tables_fields array containing the name of the fields for the matching table +* @param $matching_tables_fields array containing the name of the fields for the matching table * @param $criteria array containing the criterias * @param $matching_tables_keys array containing the field names which is key in the source table * @param $target_tables_keys array containing the field names which is key in the target table @@ -979,7 +980,7 @@ function PMA_checkForeignKeys($src_db, $src_link, $trg_db, $trg_link ,$reference * @param $display true/false value */ function 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_index, $display) + &$matching_tables_keys, &$target_tables_keys, $matching_table_index, $display) { $check = true; $sql_query = ''; @@ -1001,29 +1002,29 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s } $pri_query .= " ADD PRIMARY KEY ("; for ($z = 0; $z < sizeof($matching_tables_keys[$matching_table_index]); $z++) { - $pri_query .= $matching_tables_keys[$matching_table_index][$z]; + $pri_query .= PMA_backquote($matching_tables_keys[$matching_table_index][$z]); if ($z < (sizeof($matching_tables_keys[$matching_table_index]) - 1)) { $pri_query .= " , " ; } } $pri_query .= ");"; } - + if (isset($pri_query)) { if ($display == true) { echo '<p>' . $pri_query . '</p>'; } - PMA_DBI_try_query($pri_query, $trg_link, 0); + PMA_DBI_try_query($pri_query, $trg_link, 0); } for ($t = 0; $t < sizeof($matching_tables_fields[$matching_table_index]); $t++) { if ((isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]])) && (sizeof($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]) > 0)) { - $sql_query = 'ALTER TABLE ' . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$matching_table_index]) . ' MODIFY ' . - $matching_tables_fields[$matching_table_index][$t] . ' ' . $source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type']; + $sql_query = 'ALTER TABLE ' . PMA_backquote($trg_db) . '.' . PMA_backquote($matching_tables[$matching_table_index]) . ' MODIFY ' . + PMA_backquote($matching_tables_fields[$matching_table_index][$t]) . ' ' . $source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type']; $found = false; for ($i = 0; $i < sizeof($criteria); $i++) { if (isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]) && $criteria[$i] != 'Key') { - $found = true; + $found = true; if (($criteria[$i] == 'Type') && (! isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i+1]]))) { if ($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i + 1]] == 'NO') { $sql_query .= " Not Null" ; @@ -1049,12 +1050,12 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s } elseif($criteria[$i] == 'Default') { if(! (isset($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[2]]))) { $sql_query .= " Not Null " ; - } + } if (is_string($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]])) { if ($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type'] != 'timestamp') { $sql_query .= " DEFAULT '" . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]] . "'"; } elseif($source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]]['Type'] == 'timestamp') { - $sql_query .= " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]; + $sql_query .= " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]; } } elseif (is_numeric($alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]])) { $sql_query .= " DEFAULT " . $alter_str_array[$matching_table_index][$matching_tables_fields[$matching_table_index][$t]][$criteria[$i]]; @@ -1082,7 +1083,7 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s for($p = 0; $p < sizeof($matching_tables_keys[$matching_table_index]); $p++) { if ((isset($alter_str_array[$matching_table_index][$matching_tables_keys[$matching_table_index][$p]]['Key']))) { $check = true; - $query .= ' MODIFY ' . $matching_tables_keys[$matching_table_index][$p] . ' ' + $query .= ' MODIFY ' . PMA_backquote($matching_tables_keys[$matching_table_index][$p]) . ' ' . $source_columns[$matching_table_index][$matching_tables_fields[$matching_table_index][$p]]['Type'] . ' Not Null '; if ($p < (sizeof($matching_tables_keys[$matching_table_index]) - 1)) { $query .= ', '; @@ -1092,7 +1093,7 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s if ($check) { if ($display == true) { echo '<p>' . $query . '</p>'; - } + } PMA_DBI_try_query($query, $trg_link, 0); } } @@ -1101,13 +1102,13 @@ function PMA_alterTargetTableStructure($trg_db, $trg_link, $matching_tables, &$s * PMA_removeColumnsFromTargetTable() removes the columns which are present in target table but not in source table. * @uses sizeof() * @uses PMA_DBI_try_query() -* @uses PMA_DBI_fetch_result() -* +* @uses PMA_DBI_fetch_result() +* * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $matching_tables array containing names of matching tables * @param $uncommon_columns array containing the names of the column which are to be dropped from the target table -* @param $table_counter index of the matching table as in $matchiing_tables array +* @param $table_counter index of the matching table as in $matchiing_tables array * @param $display true/false value */ function PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $uncommon_columns, $table_counter, $display) @@ -1116,67 +1117,67 @@ function PMA_removeColumnsFromTargetTable($trg_db, $trg_link, $matching_tables, $drop_query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]); for ($a = 0; $a < sizeof($uncommon_columns[$table_counter]); $a++) { //Checks if column to be removed is a foreign key in any table - $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' + $pk_query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = '" . $trg_db . "' AND REFERENCED_TABLE_NAME = '" . $matching_tables[$table_counter]."' AND REFERENCED_COLUMN_NAME = '" . $uncommon_columns[$table_counter][$a] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;"; - + $pk_query_result = PMA_DBI_fetch_result($pk_query, null, null, $trg_link); $result_size = sizeof($pk_query_result); - + if ($result_size > 0) { for ($b = 0; $b < $result_size; $b++) { $drop_pk_query = "ALTER TABLE " . PMA_backquote($pk_query_result[$b]['TABLE_SCHEMA']) . "." . PMA_backquote($pk_query_result[$b]['TABLE_NAME']) . " - DROP FOREIGN KEY " . $pk_query_result[$b]['CONSTRAINT_NAME'] . ", DROP COLUMN " . $pk_query_result[$b]['COLUMN_NAME'] . ";"; - PMA_DBI_try_query($drop_pk_query, $trg_link, 0); - } - } - $query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '" + DROP FOREIGN KEY " . PMA_backquote($pk_query_result[$b]['CONSTRAINT_NAME']) . ", DROP COLUMN " . PMA_backquote($pk_query_result[$b]['COLUMN_NAME']) . ";"; + PMA_DBI_try_query($drop_pk_query, $trg_link, 0); + } + } + $query = "SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA = '" . $trg_db . "' AND TABLE_NAME = '" . $matching_tables[$table_counter]. "' AND COLUMN_NAME = '" . $uncommon_columns[$table_counter][$a] . "' AND TABLE_NAME <> REFERENCED_TABLE_NAME;"; $result = PMA_DBI_fetch_result($query, null, null, $trg_link); if (sizeof($result) > 0) { - $drop_query .= " DROP FOREIGN KEY " . $result[0]['CONSTRAINT_NAME'] . ","; + $drop_query .= " DROP FOREIGN KEY " . PMA_backquote($result[0]['CONSTRAINT_NAME']) . ","; } - $drop_query .= " DROP COLUMN " . $uncommon_columns[$table_counter][$a]; + $drop_query .= " DROP COLUMN " . PMA_backquote($uncommon_columns[$table_counter][$a]); if ($a < (sizeof($uncommon_columns[$table_counter]) - 1)) { $drop_query .= " , " ; - } + } } $drop_query .= ";" ; - + if ($display == true) { echo '<p>' . $drop_query . '</p>'; } - PMA_DBI_try_query($drop_query, $trg_link, 0); - } -} + PMA_DBI_try_query($drop_query, $trg_link, 0); + } +} /** * PMA_indexesDiffInTables() compares the source table indexes with target table indexes and keep the indexes to be added in target table in $add_indexes_array * indexes to be altered in $alter_indexes_array and indexes to be removed from target table in $remove_indexes_array. * Only keyname and uniqueness characteristic of the indexes are altered. * @uses sizeof() * @uses PMA_DBI_get_table_indexes() -* -* @param $src_db name of source database +* +* @param $src_db name of source database * @param $trg_db name of target database * @param $src_link connection established with source server * @param $trg_link connection established with target server * @param $matching_tables array containing the matching tables name -* @param $source_indexes array containing the indexes of the source table +* @param $source_indexes array containing the indexes of the source table * @param $target_indexes array containing the indexes of the target table * @param $add_indexes_array array containing the name of the column on which the index is to be added in the target table * @param $alter_indexes_array array containing the key name which needs to be altered * @param $remove_indexes_array array containing the key name of the index which is to be removed from the target table -* @param $table_counter number of the matching table +* @param $table_counter number of the matching table */ function 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, $table_counter) { //Gets indexes information for source and target table $source_indexes[$table_counter] = PMA_DBI_get_table_indexes($src_db, $matching_tables[$table_counter],$src_link); - $target_indexes[$table_counter] = PMA_DBI_get_table_indexes($trg_db, $matching_tables[$table_counter],$trg_link); + $target_indexes[$table_counter] = PMA_DBI_get_table_indexes($trg_db, $matching_tables[$table_counter],$trg_link); for ($a = 0; $a < sizeof($source_indexes[$table_counter]); $a++) { $found = false; $z = 0; @@ -1194,15 +1195,15 @@ function PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matchi } } } - $z++; + $z++; } if ($found === false) { if(! ($source_indexes[$table_counter][$a]['Key_name'] == 'PRIMARY')) { - $add_indexes_array [$table_counter][] = $source_indexes[$table_counter][$a]['Column_name']; + $add_indexes_array [$table_counter][] = $source_indexes[$table_counter][$a]['Column_name']; } } } - + //Finds indexes that exist on target table but not on source table for ($b = 0; $b < sizeof($target_indexes[$table_counter]); $b++) { $found = false; @@ -1212,31 +1213,31 @@ function PMA_indexesDiffInTables($src_db, $trg_db, $src_link, $trg_link, $matchi if ($target_indexes[$table_counter][$b]['Column_name'] == $source_indexes[$table_counter][$c]['Column_name']) { $found = true; } - $c++; + $c++; } if ($found === false) { - $remove_indexes_array[$table_counter][] = $target_indexes[$table_counter][$b]['Key_name']; + $remove_indexes_array[$table_counter][] = $target_indexes[$table_counter][$b]['Key_name']; } } } /** -* PMA_applyIndexesDiff() create indexes, alters indexes and remove indexes. +* PMA_applyIndexesDiff() create indexes, alters indexes and remove indexes. * @uses sizeof() * @uses PMA_DBI_try_query() -* +* * @param $trg_db name of target database * @param $trg_link connection established with target server * @param $matching_tables array containing the matching tables name -* @param $source_indexes array containing the indexes of the source table +* @param $source_indexes array containing the indexes of the source table * @param $target_indexes array containing the indexes of the target table * @param $add_indexes_array array containing the column names on which indexes are to be created in target table * @param $alter_indexes_array array containing the column names for which indexes are to be altered * @param $remove_indexes_array array containing the key name of the indexes which are to be removed from the target table -* @param $table_counter number of the matching table +* @param $table_counter number of the matching table * @param $display true/false value */ -function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, +function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_indexes, $target_indexes, $add_indexes_array, $alter_indexes_array, $remove_indexes_array, $table_counter, $display) { //Adds indexes on target table @@ -1244,12 +1245,12 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind $sql = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]) . " ADD" ; for ($a = 0; $a < sizeof($source_indexes[$table_counter]); $a++) { if (isset($add_indexes_array[$table_counter][$a])) { - for ($b = 0; $b < sizeof($source_indexes[$table_counter]); $b++) { + for ($b = 0; $b < sizeof($source_indexes[$table_counter]); $b++) { if ($source_indexes[$table_counter][$b]['Column_name'] == $add_indexes_array[$table_counter][$a]) { if ($source_indexes[$table_counter][$b]['Non_unique'] == '0') { $sql .= " UNIQUE "; } - $sql .= " INDEX " . $source_indexes[$table_counter][$b]['Key_name'] . " (" . $add_indexes_array[$table_counter][$a] . " );"; + $sql .= " INDEX " . PMA_backquote($source_indexes[$table_counter][$b]['Key_name']) . " (" . $add_indexes_array[$table_counter][$a] . " );"; if ($display == true) { echo '<p>' . $sql . '</p>'; } @@ -1265,9 +1266,9 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind $query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]); for ($a = 0; $a < sizeof($alter_indexes_array[$table_counter]); $a++) { if (isset($alter_indexes_array[$table_counter][$a])) { - $query .= ' DROP INDEX ' . PMA_backquote($alter_indexes_array[$table_counter][$a]) . " , ADD "; + $query .= ' DROP INDEX ' . PMA_backquote($alter_indexes_array[$table_counter][$a]) . " , ADD "; $got_first_index_column = false; - for ($z = 0; $z < sizeof($source_indexes[$table_counter]); $z++) { + for ($z = 0; $z < sizeof($source_indexes[$table_counter]); $z++) { if ($source_indexes[$table_counter][$z]['Key_name'] == $alter_indexes_array[$table_counter][$a]) { if (! $got_first_index_column) { if ($source_indexes[$table_counter][$z]['Non_unique'] == '0') { @@ -1294,26 +1295,26 @@ function PMA_applyIndexesDiff ($trg_db, $trg_link, $matching_tables, $source_ind $drop_index_query = "ALTER TABLE " . PMA_backquote($trg_db) . "." . PMA_backquote($matching_tables[$table_counter]); for ($a = 0; $a < sizeof($target_indexes[$table_counter]); $a++) { if (isset($remove_indexes_array[$tab$table_counter]); $a++) {PMA_backquote($matching_tables[$table_counter]); er][$a] . " );";[$b]['COLUMN_NAME']) . ";";ing_table_index][$t]]) > 0)) {AME']) . " = " . $target_tables_keys[$table_index][$y] . ";";�!�!�6*��07*��xT"�* -*�� *�� *�6*��`�� *�6*��O"�*u�� *@"�*�D"�*�I"�*�� *xT"�* -*��+*��k�� *�!�!�6*��07*��H�!�*.*�� *�� *�6*��`�� *�6*��6*��6*��8�!�*�p�07*��u�� *�� *.*��,*��k�� *GHIJKMNOP�6*��07*��H��!�*�/*�� *�� *�6*��0O"�*u�� *`"�*� �!�*@"�*�D"�*�I"�*�� *H��!�*�/*��-*��k�� *8��!�*�/*��.*��k�� *(��!�*�/*��@.*��k�� *��!�*�/*��p.*��k�� * �N"�*u�� *�I"�*�(*��X�!�*e�� *�D"�*/*��yX�!�*e�� *@"�*@/*��ZX�!�*e�� *��!�*`"�*� �!�*@"�*�d"�*�D"�*�I"�*�� *8�!�*�z!�*07*��p��!�*�0*��/*��k�� *5678:<=>?@BD�6*��07*��w!�*07*��u�� *�!�*p/*��z!�*e�� *�!�*�_@f�S Q��l��F!�*07*��w!�*2*��0*��k�� *u]�� 4Q��U^Qʉ��u��*ēv�6*��07*��HD!�*d�!�*p8*��p�"�*�p�"�*��}!�*�6*��08*��6*��P3*��o"�*u�� *�d"�*�9*��p�"�*�8*��4*��p�"�*87*��le_counter][$a])) { - $drop_index_query .= " DROP INDEX " . $remove_indexes_array[$table_counter][$a]; + $drop_index_query .= " DROP INDEX " . PMA_backquote($remove_indexes_array[$table_counter][$a]); } if ($a < (sizeof($remove_indexes_array[$table_counter]) - 1)) { $drop_index_query .= " , " ; } } - $drop_index_query .= " ; " ; + $drop_index_query .= " ; " ; if ($display == true) { echo '<p>' . $drop_index_query . '</p>'; } - PMA_DBI_try_query($drop_index_query, $trg_link, 0); + PMA_DBI_try_query($drop_index_query, $trg_link, 0); } } /** * PMA_displayQuery() displays a query, taking the maximum display size - * into account - * @uses $GLOBALS['cfg']['MaxCharactersInDisplayedSQL'] - * - * @param $query the query to display + * into account + * @uses $GLOBALS['cfg']['MaxCharactersInDisplayedSQL'] + * + * @param $query the query to display */ function PMA_displayQuery($query) { if (strlen($query) > $GLOBALS['cfg']['MaxCharactersInDisplayedSQL']) { @@ -1323,18 +1324,18 @@ function PMA_displayQuery($query) { } /** - * PMA_syncDisplayHeaderSource() shows the header for source database - * @uses $_SESSION['src_type'] - * @uses $_SESSION['src_server']['host'] + * PMA_syncDisplayHeaderSource() shows the header for source database + * @uses $_SESSION['src_type'] + * @uses $_SESSION['src_server']['host'] * - * @param string $src_db source db name + * @param string $src_db source db name */ function PMA_syncDisplayHeaderSource($src_db) { echo '<div id="serverstatus" style = "overflow: auto; width: 1020px; height: 220px; border-left: 1px gray solid; border-bottom: 1px gray solid; padding:0px; margin-bottom: 1em "> '; echo '<table id="serverstatusconnections" class="data" width="55%">'; echo '<tr>'; - echo '<th>' . __('Source database') . ': ' . $src_db . '<br />('; + echo '<th>' . __('Source database') . ': ' . htmlspecialchars($src_db) . '<br />('; if ('cur' == $_SESSION['src_type']) { echo __('Current server'); } else { @@ -1347,17 +1348,17 @@ function PMA_syncDisplayHeaderSource($src_db) { /** * PMA_syncDisplayHeaderTargetAndMatchingTables() shows the header for target database and the matching tables - * @uses $_SESSION['trg_type'] - * @uses $_SESSION['trg_server']['host'] - * - * @param string $trg_db target db name + * @uses $_SESSION['trg_type'] + * @uses $_SESSION['trg_server']['host'] + * + * @param string $trg_db target db name * @param array $matching_tables - * @return boolean $odd_row current value of this toggle + * @return boolean $odd_row current value of this toggle */ function PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables) { echo '<table id="serverstatusconnections" class="data" width="43%">'; echo '<tr>'; - echo '<th>' . __('Target database') . ': '. $trg_db . '<br />('; + echo '<th>' . __('Target database') . ': '. htmlspecialchars($trg_db) . '<br />('; if ('cur' == $_SESSION['trg_type']) { echo __('Current server'); } else { @@ -1375,10 +1376,10 @@ function PMA_syncDisplayHeaderTargetAndMatchingTables($trg_db, $matching_tables) } /** - * PMA_syncDisplayBeginTableRow() displays the TR tag for alternating colors - * - * @param boolean $odd_row current status of the toggle - * @return boolean $odd_row final status of the toggle + * PMA_syncDisplayBeginTableRow() displays the TR tag for alternating colors + * + * @param boolean $odd_row current status of the toggle + * @return boolean $odd_row final status of the toggle */ function PMA_syncDisplayBeginTableRow($odd_row) { $odd_row = ! $odd_row; diff --git a/libraries/sqlparser.data.php b/libraries/sqlparser.data.php index c7dacc6..9f2ea12 100644 --- a/libraries/sqlparser.data.php +++ b/libraries/sqlparser.data.php @@ -657,6 +657,7 @@ $PMA_SQPdata_reserved_word = array ( 'TO', 'TRAILING', 'TRANSACTIONAL', // 5.1 ? + 'TRUE', 'TRUNCATE', 'TYPE', 'TYPES', @@ -684,7 +685,7 @@ $PMA_SQPdata_reserved_word = array ( * * @global integer MySQL reserved words count */ -$PMA_SQPdata_reserved_word_cnt = 287; +$PMA_SQPdata_reserved_word_cnt = 288; /** * words forbidden to be used as column or table name wihtout quotes diff --git a/libraries/vendor_config.php b/libraries/vendor_config.php index 41f7c23..7983b9f 100644 --- a/libraries/vendor_config.php +++ b/libraries/vendor_config.php @@ -59,4 +59,10 @@ define('CUSTOM_FOOTER_FILE', CONFIG_DIR . 'config.footer.inc.php'); * Default value for check for version upgrades. */ define('VERSION_CHECK_DEFAULT', true); + +/** + * Path to gettext.inc file. Useful when you want php-gettext somewhere else, + * eg. /usr/share/php/gettext/gettext.inc. + */ +define('GETTEXT_INC', './libraries/php-gettext/gettext.inc'); ?> diff --git a/po/af.po b/po/af.po index eaec6ec..dd7e3b5 100644 --- a/po/af.po +++ b/po/af.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-30 23:04+0200\n" diff --git a/po/ar.po b/po/ar.po index 66c10c9..826bfed 100644 --- a/po/ar.po +++ b/po/ar.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-21 13:56+0200\n" diff --git a/po/az.po b/po/az.po index 27757c3..127733d 100644 --- a/po/az.po +++ b/po/az.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:11+0100\n" diff --git a/po/be.po b/po/be.po index 3e63938..1479c8f 100644 --- a/po/be.po +++ b/po/be.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:12+0100\n" diff --git a/po/be(a)latin.po b/po/be(a)latin.po index 0af0310..656f933 100644 --- a/po/be(a)latin.po +++ b/po/be(a)latin.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-30 23:09+0200\n" diff --git a/po/bg.po b/po/bg.po index 5dee1d4..0dadff3 100644 --- a/po/bg.po +++ b/po/bg.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-22 12:51+0200\n" @@ -4193,7 +4193,7 @@ msgstr "CSV за MS Excel данни" #: libraries/config/user_preferences.forms.php:239 #: libraries/export/htmlword.php:17 msgid "Microsoft Word 2000" -msgstr "" +msgstr "Microsoft Word 2000" #: libraries/config/setup.forms.php:346 #: libraries/config/user_preferences.forms.php:248 libraries/export/odt.php:21 @@ -6820,7 +6820,7 @@ msgstr "Покажи всички" #: pmd_general.php:141 msgid "Hide/Show Tables with no relation" -msgstr "" +msgstr "Показване/скриване таблици без релации" #: pmd_general.php:181 #, fuzzy @@ -9273,7 +9273,7 @@ msgstr "Заявление" #: tbl_printview.php:377 tbl_structure.php:834 msgid "static" -msgstr "" +msgstr "статичен" #: tbl_printview.php:379 tbl_structure.php:836 msgid "dynamic" @@ -9511,7 +9511,7 @@ msgstr "Версия" #: tbl_tracking.php:640 #, php-format msgid "Deactivate tracking for %s.%s" -msgstr "" +msgstr "Изключване проследяването за %s.%s" #: tbl_tracking.php:642 msgid "Deactivate now" @@ -9520,7 +9520,7 @@ msgstr "Деактивиране сега" #: tbl_tracking.php:653 #, php-format msgid "Activate tracking for %s.%s" -msgstr "" +msgstr "Включване проследяването за %s.%s" #: tbl_tracking.php:655 msgid "Activate now" @@ -9533,11 +9533,11 @@ msgstr "Създаване на версия %s от %s.%s" #: tbl_tracking.php:672 msgid "Track these data definition statements:" -msgstr "" +msgstr "Проследяване следните изрази за дефиниране на данни" #: tbl_tracking.php:680 msgid "Track these data manipulation statements:" -msgstr "" +msgstr "Проследяване следните изрази за манипулиране на данни" #: tbl_tracking.php:688 #, fuzzy diff --git a/po/bn.po b/po/bn.po index 6c8eb47..98394ea 100644 --- a/po/bn.po +++ b/po/bn.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-10-21 01:36+0200\n" diff --git a/po/br.po b/po/br.po index a47a222..e3dfe9f 100644 --- a/po/br.po +++ b/po/br.po @@ -5,7 +5,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-07-02 22:10+0200\n" diff --git a/po/bs.po b/po/bs.po index 34bb0ac..fc66516 100644 --- a/po/bs.po +++ b/po/bs.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:12+0100\n" diff --git a/po/ca.po b/po/ca.po index 3f46db1..53ecba4 100644 --- a/po/ca.po +++ b/po/ca.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-23 09:57+0200\n" diff --git a/po/cs.po b/po/cs.po index 3fd0a83..2ce082d 100644 --- a/po/cs.po +++ b/po/cs.po @@ -4,7 +4,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-10 14:03+0100\n" diff --git a/po/cy.po b/po/cy.po index 03af559..0eb721c 100644 --- a/po/cy.po +++ b/po/cy.po @@ -4,7 +4,7 @@ # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-06-07 20:23+0200\n" diff --git a/po/da.po b/po/da.po index 66e1507..f66dea5 100644 --- a/po/da.po +++ b/po/da.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-07 01:17+0200\n" diff --git a/po/de.po b/po/de.po index 4fa3e3c..f75a2d7 100644 --- a/po/de.po +++ b/po/de.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-23 04:28+0200\n" diff --git a/po/el.po b/po/el.po index dd06b6d..84a471e 100644 --- a/po/el.po +++ b/po/el.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-05 11:15+0200\n" diff --git a/po/en_GB.po b/po/en_GB.po index 66f06b4..b2d3192 100644 --- a/po/en_GB.po +++ b/po/en_GB.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-10 16:24+0200\n" diff --git a/po/es.po b/po/es.po index 82a9fa0..ef7a1de 100644 --- a/po/es.po +++ b/po/es.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-02 11:10+0200\n" diff --git a/po/et.po b/po/et.po index a665761..7382be4 100644 --- a/po/et.po +++ b/po/et.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:14+0100\n" diff --git a/po/eu.po b/po/eu.po index 5f96bc0..ddfd21a 100644 --- a/po/eu.po +++ b/po/eu.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-21 14:53+0200\n" @@ -95,23 +95,28 @@ msgstr "Erabili balio hau" #: bs_disp_as_mime_type.php:29 bs_play_media.php:35 #: libraries/blobstreaming.lib.php:331 +#, fuzzy msgid "No blob streaming server configured!" -msgstr "" +msgstr "Ez dago blob streaming zerbitzaria konfiguraturik!" #: bs_disp_as_mime_type.php:35 +#, fuzzy msgid "Failed to fetch headers" -msgstr "" +msgstr "Akatsa goiburuak bilatzerakoan" #: bs_disp_as_mime_type.php:41 +#, fuzzy msgid "Failed to open remote URL" -msgstr "" +msgstr "Akatsa kompo esteka zabaltzerakoan" #: changelog.php:32 license.php:28 -#, php-format +#, fuzzy, php-format msgid "" "The %s file is not available on this system, please visit www.phpmyadmin.net " "for more information." msgstr "" +"%s filtxategia ez dago eskuragarri sisteman, joan www.phpmyadmin.net " +"informazio gehiagorako" #: db_create.php:58 #, fuzzy, php-format @@ -308,7 +313,7 @@ msgstr "Datuak soilik" #: db_operations.php:493 msgid "CREATE DATABASE before copying" -msgstr "" +msgstr "DATU-BASEA SORTU kopiatu aurretik " #: db_operations.php:496 libraries/config/messages.inc.php:124 #: libraries/config/messages.inc.php:125 libraries/config/messages.inc.php:127 @@ -622,11 +627,11 @@ msgstr "%s taula ezabatu egin da" #: db_structure.php:293 tbl_create.php:295 msgid "Tracking is active." -msgstr "" +msgstr "Jarraipena aktibatuta dago." #: db_structure.php:295 tbl_create.php:297 msgid "Tracking is not active." -msgstr "" +msgstr "Jarraipena ez dago aktibatuta." #: db_structure.php:379 libraries/display_tbl.lib.php:2076 #, php-format @@ -634,11 +639,13 @@ msgid "" "This view has at least this number of rows. Please refer to %sdocumentation" "%s." msgstr "" +"Ikuspegi honek gutxienez errenkada kopuru hau dauka. Mesedez %sdocumentation" +"%s erreferentzia egin." #: db_structure.php:393 db_structure.php:407 libraries/header.inc.php:137 #: libraries/tbl_info.inc.php:60 tbl_structure.php:206 test/theme.php:73 msgid "View" -msgstr "" +msgstr "Ikusipegia" #: db_structure.php:444 libraries/db_structure.lib.php:40 #: libraries/server_links.inc.php:90 server_replication.php:31 @@ -652,9 +659,9 @@ msgid "Sum" msgstr "Gehiketa" #: db_structure.php:455 libraries/StorageEngine.class.php:351 -#, php-format +#, fuzzy, php-format msgid "%s is the default storage engine on this MySQL server." -msgstr "" +msgstr "%s da MySQL zerbitzarian lehenetsitako biltegiratzeko mota." #: db_structure.php:483 db_structure.php:500 db_structure.php:501 #: libraries/display_tbl.lib.php:2217 libraries/display_tbl.lib.php:2222 @@ -729,7 +736,7 @@ msgstr "Datu-hiztegia" #: db_tracking.php:79 msgid "Tracked tables" -msgstr "" +msgstr "Taulak jarraipenarekin" #: db_tracking.php:84 libraries/config/messages.inc.php:482 #: libraries/export/htmlword.php:89 libraries/export/latex.php:162 @@ -746,7 +753,7 @@ msgstr "Datu-basea" #: db_tracking.php:86 msgid "Last version" -msgstr "" +msgstr "Azken bertsioa" #: db_tracking.php:87 tbl_tracking.php:589 #, fuzzy @@ -755,7 +762,7 @@ msgstr "Sortu" #: db_tracking.php:88 tbl_tracking.php:590 msgid "Updated" -msgstr "" +msgstr "Eguneratua" #: db_tracking.php:89 libraries/common.lib.php:1354 #: libraries/server_links.inc.php:50 server_processlist.php:71 @@ -772,15 +779,15 @@ msgstr "Ekintza" #: db_tracking.php:101 js/messages.php:34 msgid "Delete tracking data for this table" -msgstr "" +msgstr "Ezabatu taula honetako jarraipen datuak" #: db_tracking.php:119 tbl_tracking.php:543 tbl_tracking.php:601 msgid "active" -msgstr "" +msgstr "Aktibo" #: db_tracking.php:121 tbl_tracking.php:545 tbl_tracking.php:603 msgid "not active" -msgstr "" +msgstr "Ez aktibo" #: db_tracking.php:134 #, fuzzy @@ -789,7 +796,7 @@ msgstr "Eragiketak" #: db_tracking.php:135 tbl_tracking.php:374 tbl_tracking.php:621 msgid "Tracking report" -msgstr "" +msgstr "Jarraipen informea " #: db_tracking.php:136 tbl_tracking.php:246 tbl_tracking.php:623 #, fuzzy @@ -798,7 +805,7 @@ msgstr "Egitura soilik" #: db_tracking.php:181 msgid "Untracked tables" -msgstr "" +msgstr "Jarraipen gabeko taulak" #: db_tracking.php:201 db_tracking.php:203 tbl_structure.php:626 #: tbl_structure.php:628 @@ -821,20 +828,21 @@ msgid "Enter each value in a separate field." msgstr "" #: enum_editor.php:57 +#, fuzzy msgid "+ Restart insertion and add a new value" -msgstr "" +msgstr "+ Berriz hasi txertatzen eta gehitu balio berria" #: enum_editor.php:67 msgid "Output" -msgstr "" +msgstr "Irteera" #: enum_editor.php:68 msgid "Copy and paste the joined values into the \"Length/Values\" field" -msgstr "" +msgstr "Kopiatu eta itsatsi batutako balioak \"Luzera/Balioak\" eremuan" #: export.php:73 msgid "Selected export type has to be saved in file!" -msgstr "" +msgstr "Aukeratutako esportatze formatuak fitxategian gorde behar da!" #: export.php:164 export.php:189 export.php:670 #, php-format @@ -896,18 +904,19 @@ msgid "The bookmark has been deleted." msgstr "Gordetako kontsulta ezabatu da." #: import.php:400 +#, fuzzy msgid "Showing bookmark" -msgstr "" +msgstr "Erakutsi laster-markak" #: import.php:402 sql.php:885 -#, php-format +#, fuzzy, php-format msgid "Bookmark %s created" -msgstr "" +msgstr "%s laster-marka sortu da" #: import.php:408 import.php:414 #, php-format msgid "Import has been successfully finished, %d queries executed." -msgstr "" +msgstr "Inportatzea zuzen burutu da, %d kontsulta exekutatuta_." #: import.php:423 msgid "" @@ -944,11 +953,11 @@ msgstr "" #: server_synchronize.php:734 server_synchronize.php:762 #: server_synchronize.php:790 server_synchronize.php:802 msgid "Click to select" -msgstr "" +msgstr "Egin klik hautatzeko" #: js/messages.php:26 msgid "Click to unselect" -msgstr "" +msgstr "Klik desautatzeko" #: js/messages.php:27 libraries/import.lib.php:103 sql.php:195 msgid "\"DROP DATABASE\" statements are disabled." @@ -960,7 +969,7 @@ msgstr "Benetan nahi al duzu " #: js/messages.php:31 libraries/mult_submits.inc.php:242 sql.php:278 msgid "You are about to DESTROY a complete database!" -msgstr "" +msgstr "Datu-base osoa SUNTSITZERA zoaz!" #: js/messages.php:32 msgid "Dropping Event" @@ -978,16 +987,18 @@ msgid "Deleting tracking data" msgstr "Datuak txertatu eta ordezkatzea baimentzen du." #: js/messages.php:36 +#, fuzzy msgid "Dropping Primary Key/Index" -msgstr "" +msgstr "Ezabatu Giltza nagusi/Indizea" #: js/messages.php:37 +#, fuzzy msgid "This operation could take a long time. Proceed anyway?" -msgstr "" +msgstr "Eragiketa honek luze jo lezake. Jarraitu nahi?" #: js/messages.php:40 msgid "You are about to DISABLE a BLOB Repository!" -msgstr "" +msgstr "BLOG biltegi bat DESGAITZERA zoaz!" #: js/messages.php:41 #, php-format @@ -1044,7 +1055,7 @@ msgstr "Hautatutako erabiltzaileak baztertu" #: js/messages.php:56 libraries/tbl_properties.inc.php:792 #: tbl_tracking.php:246 tbl_tracking.php:374 msgid "Close" -msgstr "" +msgstr "Itxi" #: js/messages.php:60 libraries/tbl_properties.inc.php:797 pmd_general.php:388 #: pmd_general.php:425 pmd_general.php:545 pmd_general.php:593 diff --git a/po/fa.po b/po/fa.po index ff3652a..fd23feb 100644 --- a/po/fa.po +++ b/po/fa.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-05-19 03:54+0200\n" diff --git a/po/fi.po b/po/fi.po index 5f8c034..099b180 100644 --- a/po/fi.po +++ b/po/fi.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-11-26 21:29+0200\n" diff --git a/po/fr.po b/po/fr.po index 52cfa13..72759c6 100644 --- a/po/fr.po +++ b/po/fr.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-10 19:23+0200\n" diff --git a/po/gl.po b/po/gl.po index 9848a68..986f478 100644 --- a/po/gl.po +++ b/po/gl.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-21 14:50+0200\n" diff --git a/po/he.po b/po/he.po index 25f74cf..2922095 100644 --- a/po/he.po +++ b/po/he.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-02 20:17+0200\n" diff --git a/po/hi.po b/po/hi.po index a748d8d..42364d7 100644 --- a/po/hi.po +++ b/po/hi.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-24 00:23+0200\n" diff --git a/po/hr.po b/po/hr.po index 1e9d274..128117e 100644 --- a/po/hr.po +++ b/po/hr.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-21 14:54+0200\n" diff --git a/po/hu.po b/po/hu.po index 89f4d3a..5071e4a 100644 --- a/po/hu.po +++ b/po/hu.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-05-05 12:49+0200\n" @@ -2675,7 +2675,7 @@ msgstr "SQL kompatibilitási mód" #: libraries/config/messages.inc.php:120 libraries/export/sql.php:111 msgid "<code>CREATE TABLE</code> options:" -msgstr "" +msgstr "<code>CREATE TABLE</code> beállítások:" #: libraries/config/messages.inc.php:121 msgid "Creation/Update/Check dates" @@ -4825,13 +4825,15 @@ msgstr "Importálandó fájl" #: libraries/display_import.lib.php:156 #, php-format msgid "File may be compressed (%s) or uncompressed." -msgstr "" +msgstr "A fájl lehet tömörített (%s) vagy tömörítetlen." #: libraries/display_import.lib.php:158 msgid "" "A compressed file's name must end in <b>.[format].[compression]</b>. " "Example: <b>.sql.zip</b>" msgstr "" +"A tömörített fájl nevének <b>.[formátum].[tömörítés]</b> végződésűnek kell " +"lennie. Például: <b>.sql.zip</b>" #: libraries/display_import.lib.php:178 msgid "File uploads are not allowed on this server." @@ -4874,7 +4876,7 @@ msgstr "Az elejétől kihagyandó rekordok (lekérdezések) száma" #: libraries/display_import.lib.php:250 msgid "Format-Specific Options:" -msgstr "" +msgstr "Formátum specifikus beállítások:" #: libraries/display_select_lang.lib.php:44 #: libraries/display_select_lang.lib.php:45 setup/frames/index.inc.php:71 @@ -4966,7 +4968,7 @@ msgstr "Böngésző átalakítása" #: libraries/display_tbl.lib.php:1218 msgid "Copy" -msgstr "" +msgstr "Másolás" #: libraries/display_tbl.lib.php:1233 libraries/display_tbl.lib.php:1245 msgid "The row has been deleted" @@ -5610,7 +5612,7 @@ msgstr "PHP verzió" #: libraries/export/mediawiki.php:15 msgid "MediaWiki Table" -msgstr "" +msgstr "MediaWiki tábla" #: libraries/export/pdf.php:17 msgid "PDF" @@ -5628,13 +5630,15 @@ msgstr "A jelentés címe" #: libraries/export/php_array.php:16 msgid "PHP array" -msgstr "" +msgstr "PHP tömb" #: libraries/export/sql.php:33 msgid "" "Display comments <i>(includes info such as export timestamp, PHP version, " "and server version)</i>" msgstr "" +"Megjegyzések megjelenítése <i>(olyan információk, mint az exportálás " +"időbélyege, a PHP verziója és a szerver verziója)</i>" #: libraries/export/sql.php:35 #, fuzzy @@ -5647,11 +5651,15 @@ msgid "" "Include a timestamp of when databases were created, last updated, and last " "checked" msgstr "" +"Tartalmazza azokat az időbélyegeket, amikor az adatbázis létrejött, utoljára " +"frissült és utoljára ellenőrizve lett" #: libraries/export/sql.php:65 msgid "" "Database system or older MySQL server to maximize output compatibility with:" msgstr "" +"Adatbázis rendszer vagy régebbi MySQL szerver a kimenet kompatibilitásának " +"maximalizálása ezzel:" #: libraries/export/sql.php:72 libraries/export/sql.php:105 #: libraries/export/sql.php:107 @@ -5674,19 +5682,19 @@ msgstr "" #: libraries/export/sql.php:136 msgid "Instead of <code>INSERT</code> statements, use:" -msgstr "" +msgstr "Az <code>INSERT</code> utasítás helyett használjon:" #: libraries/export/sql.php:138 msgid "<code>INSERT DELAYED</code> statements" -msgstr "" +msgstr "<code>INSERT DELAYED</code> utasítások" #: libraries/export/sql.php:140 msgid "<code>INSERT IGNORE</code> statements" -msgstr "" +msgstr "<code>INSERT IGNORE</code> utasítások" #: libraries/export/sql.php:147 msgid "Function to use when dumping data:" -msgstr "" +msgstr "Adatkiíráskor használt függvények:" #: libraries/export/sql.php:151 msgid "Syntax to use when inserting data:" @@ -5698,6 +5706,9 @@ msgid "" "    Example: <code>INSERT INTO tbl_name (col_A,col_B,col_C) VALUES " "(1,2,3)</code>" msgstr "" +"tartalmazza az oszlopneveket minden <code>INSERT</code> utasítás <br /> " +"      Példa: <code>INSERT INTO tbl_name (col_A,col_B,col_C) " +"VALUES (1,2,3)</code>" #: libraries/export/sql.php:155 msgid "" @@ -5705,30 +5716,41 @@ msgid "" "    Example: <code>INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), " "(7,8,9)</code>" msgstr "" +"több sor beszúrása minden <code>INSERT</code> utasításba<br />     " +"  Példa: <code>INSERT INTO tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)</" +"code>" #: libraries/export/sql.php:156 msgid "" "both of the above<br />       Example: <code>INSERT INTO " "tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)</code>" msgstr "" +"mindkettő a fentiek közül<br />       Példa: <code>INSERT " +"INTO tbl_name (col_A,col_B) VALUES (1,2,3), (4,5,6), (7,8,9)</code>" #: libraries/export/sql.php:157 msgid "" "neither of the above<br />       Example: <code>INSERT INTO " "tbl_name VALUES (1,2,3)</code>" msgstr "" +"egyik sem a fentiek közül<br />       Példa: <code>INSERT " +"INTO tbl_name VALUES (1,2,3)</code>" #: libraries/export/sql.php:167 msgid "" "Dump binary columns in hexadecimal notation <i>(for example, \"abc\" becomes " "0x616263)</i>" msgstr "" +"Bináris oszlopok kiírása hexadecimális átírással <i>(például, \"abc\" " +"helyett 0x616263)</i>" #: libraries/export/sql.php:171 msgid "" "Dump TIMESTAMP columns in UTC <i>(enables TIMESTAMP columns to be dumped and " "reloaded between servers in different time zones)</i>" msgstr "" +"A TIMESTAMP oszlopok kiírása UTC-ben <i>(engedélyezi a TIMESTAMP oszlopok " +"kiírását és újratölti a különböző időzónában lévő szerverek között)</i>" #: libraries/export/sql.php:209 libraries/export/xml.php:34 msgid "Procedures" @@ -5773,7 +5795,7 @@ msgstr "XML" #: libraries/export/xml.php:30 msgid "Object creation options (all are recommended)" -msgstr "" +msgstr "Objektum-létrehozási beállítások (mindegyik javasolt)" #: libraries/export/xml.php:40 #, fuzzy @@ -5844,6 +5866,8 @@ msgid "" "The first line of the file contains the table column names <i>(if this is " "unchecked, the first line will become part of the data)</i>" msgstr "" +"A fájl első sora tartalmazza a tábla oszlopneveit <i>(ha ez nincs " +"kiválasztva, az első sor az adat része lesz)</i>" #: libraries/import/csv.php:39 msgid "" @@ -5903,10 +5927,12 @@ msgstr "Ez a beépülő modul nem támogatja a tömörített importálásokat!" #: libraries/import/ods.php:28 msgid "Import percentages as proper decimals <i>(ex. 12.00% to .12)</i>" msgstr "" +"Százalékos értékek importálása pontos tizedestörtként <i>(pl. 12.00% " +"helyett .12)</i>" #: libraries/import/ods.php:29 msgid "Import currencies <i>(ex. $5.00 to 5.00)</i>" -msgstr "" +msgstr "Valuták importálása <i>(pl. $5.00 helyett 5.00)</i>" #: libraries/import/sql.php:32 #, fuzzy @@ -6201,30 +6227,36 @@ msgstr "SQL-előzmények" #: libraries/relation.lib.php:147 msgid "User preferences" -msgstr "" +msgstr "Felhasználói beállítások" #: libraries/relation.lib.php:151 msgid "Quick steps to setup advanced features:" -msgstr "" +msgstr "Gyors lépések a haladó funkciók beállításához:" #: libraries/relation.lib.php:153 msgid "" "Create the needed tables with the <code>script/create_tables.sql</code>." msgstr "" +"Hozza létre a kívánt táblákat a <code>script/create_tables.sql</code> " +"használatával." #: libraries/relation.lib.php:154 msgid "Create a pma user and give access to these tables." msgstr "" +"Hozzon létre egy pma felhasználót és adjon hozzáférést ezekhez a táblákhoz." #: libraries/relation.lib.php:155 msgid "" "Enable advanced features in configuration file (<code>config.inc.php</" "code>), for example by starting from <code>config.sample.inc.php</code>." msgstr "" +"Engedélyezze a haladó funkciókat a beállító fájlban (<code>config.inc.php</" +"code>), például induljon ki a <code>config.sample.inc.php</code> fájlból." #: libraries/relation.lib.php:156 msgid "Re-login to phpMyAdmin to load the updated configuration file." msgstr "" +"Jelentkezzen be újra a phpMyAdminba a frissített beállítófájl betöltéséhez." #: libraries/relation.lib.php:1175 msgid "no description" @@ -6362,7 +6394,7 @@ msgstr "A(z) %s fájl nem tartalmaz semmilyen kulcsazonosítót" #: libraries/schema/Export_Relation_Schema.class.php:207 msgid "SCHEMA ERROR: " -msgstr "" +msgstr "SÉMA HIBA: " #: libraries/schema/Pdf_Relation_Schema.class.php:877 #: libraries/schema/Pdf_Relation_Schema.class.php:1118 @@ -6552,7 +6584,7 @@ msgstr "Új szerver" #: libraries/server_synchronize.lib.php:1344 msgid "Difference" -msgstr "" +msgstr "Különbség" #: libraries/server_synchronize.lib.php:1360 server_synchronize.php:1118 #, fuzzy @@ -6768,7 +6800,7 @@ msgstr "" #: libraries/tbl_properties.inc.php:371 msgid "ENUM or SET data too long?" -msgstr "" +msgstr "ENUM vagy SET adat túl nagy?" #: libraries/tbl_properties.inc.php:373 msgid "Get more editing space" @@ -7030,6 +7062,8 @@ msgid "" "Your preferences will be saved for current session only. Storing them " "permanently requires %sphpMyAdmin configuration storage%s." msgstr "" +"A beállításai csak a jelenlegi munkamenethez lesznek elmentve. A végleges " +"tároláshoz szükséges a %sphpMyAdmin beállítás tároló%s." #: libraries/user_preferences.lib.php:142 #, fuzzy @@ -7222,6 +7256,9 @@ msgid "" "functionality will be missing. For example navigation frame will not refresh " "automatically." msgstr "" +"A JavaScript támogatás hiányzik vagy le van tiltva a böngészőben, ezért " +"néhány phpMyAdmin funkcionalitás hiányozni fog. Például a navigációs keret " +"nem fog automatikusan frissülni." #: main.php:331 #, php-format @@ -7417,7 +7454,7 @@ msgstr "A(z) %1$s tábla elkészült." #: pmd_pdf.php:37 msgid "Page creation failed" -msgstr "" +msgstr "Az oldal létrehozása meghiúsult" #: pmd_pdf.php:89 #, fuzzy @@ -7500,11 +7537,11 @@ msgstr "" #: prefs_manage.php:112 msgid "Configuration contains incorrect data for some fields." -msgstr "" +msgstr "A beállítás rossz adatot tartalmaz néhány mezőben." #: prefs_manage.php:128 msgid "Do you want to import remaining settings?" -msgstr "" +msgstr "Szeretné importálni a megmaradt beállításokat?" #: prefs_manage.php:225 prefs_manage.php:251 msgid "Saved on: @DATE@" @@ -7522,7 +7559,7 @@ msgstr "Importálás a böngészőből" #: prefs_manage.php:248 msgid "Settings will be imported from your browser's local storage." -msgstr "" +msgstr "A beállítások a böngészője helyi tárolójából lesznek importálva." #: prefs_manage.php:254 #, fuzzy @@ -7532,7 +7569,7 @@ msgstr "Egyéb alapbeállítások" #: prefs_manage.php:258 prefs_manage.php:312 msgid "This feature is not supported by your web browser" -msgstr "" +msgstr "Az ön web böngészője nem támogatja ezt a szolgáltatást" #: prefs_manage.php:263 #, fuzzy @@ -7546,22 +7583,26 @@ msgid "" "You can set more settings by modifying config.inc.php, eg. by using %sSetup " "script%s." msgstr "" +"További beállításokat állíthat be a config.inc.php modosításával, pl. " +"%sBeállító parancsfájl%s használatával." #: prefs_manage.php:302 msgid "Save to browser's storage" -msgstr "" +msgstr "Mentés a böngésző tárolójába" #: prefs_manage.php:306 msgid "Settings will be saved in your browser's local storage." -msgstr "" +msgstr "A beállítások a böngészője helyi tárolójába lesznek mentve." #: prefs_manage.php:308 msgid "Existing settings will be overwritten!" -msgstr "" +msgstr "A meglévő beállítások felülíródnak!" #: prefs_manage.php:323 msgid "You can reset all your settings and restore them to default values." msgstr "" +"Alaphelyzetbe állíthatja az összes beállítását és visszaállíthatja azokat az " +"alapértelmezett értékekre." #: querywindow.php:93 msgid "Import files" @@ -9165,7 +9206,7 @@ msgstr "Nézet szerkezete" #: server_synchronize.php:420 server_synchronize.php:863 msgid "Data Difference" -msgstr "" +msgstr "Adatkülönbség" #: server_synchronize.php:425 server_synchronize.php:868 msgid "Add column(s)" diff --git a/po/id.po b/po/id.po index e544cd3..4198ee4 100644 --- a/po/id.po +++ b/po/id.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-16 22:04+0200\n" diff --git a/po/it.po b/po/it.po index 798b614..488298d 100644 --- a/po/it.po +++ b/po/it.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-05 14:27+0200\n" diff --git a/po/ja.po b/po/ja.po index 5834858..676b419 100644 --- a/po/ja.po +++ b/po/ja.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-05-05 11:38+0200\n" diff --git a/po/ka.po b/po/ka.po index a10c457..fd25b5a 100644 --- a/po/ka.po +++ b/po/ka.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:14+0100\n" diff --git a/po/ko.po b/po/ko.po index 91da7de..6007848 100644 --- a/po/ko.po +++ b/po/ko.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-06-16 18:18+0200\n" diff --git a/po/lt.po b/po/lt.po index a320cbb..a3a8daf 100644 --- a/po/lt.po +++ b/po/lt.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-05 15:52+0200\n" diff --git a/po/lv.po b/po/lv.po index 8a2f5d4..1810279 100644 --- a/po/lv.po +++ b/po/lv.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:16+0100\n" diff --git a/po/mk.po b/po/mk.po index 7aba17b..66d2fee 100644 --- a/po/mk.po +++ b/po/mk.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:16+0100\n" diff --git a/po/ml.po b/po/ml.po index fb12ba5..13fe780 100644 --- a/po/ml.po +++ b/po/ml.po @@ -3,7 +3,7 @@ # This file is distributed under the same license as the phpMyAdmin package. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-10 14:03+0100\n" diff --git a/po/mn.po b/po/mn.po index d3567f7..e64e264 100644 --- a/po/mn.po +++ b/po/mn.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:17+0100\n" diff --git a/po/ms.po b/po/ms.po index a75bcc5..d256d6f 100644 --- a/po/ms.po +++ b/po/ms.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:17+0100\n" diff --git a/po/nb.po b/po/nb.po index d94eb70..22b5307 100644 --- a/po/nb.po +++ b/po/nb.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-07 11:21+0200\n" diff --git a/po/nl.po b/po/nl.po index 0b63c7f..2268c56 100644 --- a/po/nl.po +++ b/po/nl.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-16 20:18+0200\n" diff --git a/po/pl.po b/po/pl.po index f3d2a06..fe81bcd 100644 --- a/po/pl.po +++ b/po/pl.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-24 16:21+0200\n" diff --git a/po/pt.po b/po/pt.po index 1fa8a6a..a53d8ef 100644 --- a/po/pt.po +++ b/po/pt.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-26 03:23+0200\n" diff --git a/po/pt_BR.po b/po/pt_BR.po index 2d05d94..154d6b1 100644 --- a/po/pt_BR.po +++ b/po/pt_BR.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-14 17:44+0200\n" diff --git a/po/ro.po b/po/ro.po index daf13c4..8df7f70 100644 --- a/po/ro.po +++ b/po/ro.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-22 02:28+0200\n" @@ -97,7 +97,7 @@ msgstr "Folosește această valoare" #: bs_disp_as_mime_type.php:29 bs_play_media.php:35 #: libraries/blobstreaming.lib.php:331 msgid "No blob streaming server configured!" -msgstr "" +msgstr "Nici un server de streaming aglomerat nu a fost configurat!" #: bs_disp_as_mime_type.php:35 #, fuzzy diff --git a/po/ru.po b/po/ru.po index e8cb0a1..0b6eac4 100644 --- a/po/ru.po +++ b/po/ru.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-13 21:17+0200\n" diff --git a/po/si.po b/po/si.po index eb59166..f7e29c2 100644 --- a/po/si.po +++ b/po/si.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-05-04 14:56+0200\n" diff --git a/po/sk.po b/po/sk.po index 5fe4596..bab233c 100644 --- a/po/sk.po +++ b/po/sk.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Projct-Id-Version: phpMyAdmin 3.4.7-dev\n"sourceforge.net\n"!"ckage.azokat az "�lásokat!"ни"lid; border-bottom: 1px gray solid; padding:0px; margin-bottom: 1em "> '; ";";ing_table_index][$t]]) > 0)) {AME']) . " = " . $target_tables_keys[$table_index][$y] . ";";�!�!�6*��07*��xT"�* -*�� *�� *�6*��`�� *�6*��O"�*u�� *@"�*�D"�*�I"�*�� *xT"�* -*��+*��k�� *�!�!�6*��07*��H�!�*.*�� *�� *�6*��`�� *�6*��6*��6*��8�!�*�p�07*��u�� *�� *.*��,*��k�� *GHIJKMNOP�6*��07*��H��!�*�/*�� *�� *�6*��0O"�*u�� *`"�*� �!�*@"�*�D"�*�I"�*�� *H��!�*�/*��-*��k�� *8��!�*�/*��.*��k�� *(��!�*�/*��@.*��k�� *��!�*�/*��p.*��k�� * �N"�*u�� *�I"�*�(*��X�!�*e�� *�D"�*/*��yX�!�*e�� *@"�*@/*��ZX�!�*e�� *��!�*`"�*� �!�*@"�*�d"�*�D"�*�I"�*�� *8�!�*�z!�*07*��p��!�*�0*��/*��k�� *5678:<=>?@BD�6*��07*��w!�*07*��u�� *�!�*p/*��z!�*e�� *�!�*�_@f�S Q��l��F!�*07*��w!�*2*��0*��k�� *u]�� 4Q��U^Qʉ��u��*ēv�6*��07*��HD!�*d�!�*p8*��p�"�*�p�"�*��}!�*�6*��08*��6*��P3*��o"�*u�� *�d"�*�9*��p�"�*�8*��4*��p�"�*87*��ect-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-22 02:26+0200\n" diff --git a/po/sl.po b/po/sl.po index 8aa1bcb..1b22603 100644 --- a/po/sl.po +++ b/po/sl.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-24 22:38+0200\n" diff --git a/po/sq.po b/po/sq.po index 4353ceb..904de0b 100644 --- a/po/sq.po +++ b/po/sq.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-21 14:51+0200\n" diff --git a/po/sr.po b/po/sr.po index 008157b..967e007 100644 --- a/po/sr.po +++ b/po/sr.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-06 18:43+0200\n" diff --git a/po/sr(a)latin.po b/po/sr(a)latin.po index 2053fd6..4656025 100644 --- a/po/sr(a)latin.po +++ b/po/sr(a)latin.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-12-02 14:49+0200\n" diff --git a/po/sv.po b/po/sv.po index 23c2200..0d5555c 100644 --- a/po/sv.po +++ b/po/sv.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-02-16 21:42+0200\n" diff --git a/po/ta.po b/po/ta.po index 3ee7147..897151d 100644 --- a/po/ta.po +++ b/po/ta.po @@ -4,7 +4,7 @@ # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-04-16 10:43+0200\n" diff --git a/po/te.po b/po/te.po index 9b0f4e2..b6e31e3 100644 --- a/po/te.po +++ b/po/te.po @@ -4,7 +4,7 @@ # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-07 17:06+0200\n" diff --git a/po/th.po b/po/th.po index d75e282..2f99797 100644 --- a/po/th.po +++ b/po/th.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-03-12 09:19+0100\n" diff --git a/po/tr.po b/po/tr.po index 076883c..bb25dbb 100644 --- a/po/tr.po +++ b/po/tr.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-17 19:11+0200\n" diff --git a/po/tt.po b/po/tt.po index b26519d..a71a452 100644 --- a/po/tt.po +++ b/po/tt.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-22 02:25+0200\n" diff --git a/po/ug.po b/po/ug.po index acaf125..787d793 100644 --- a/po/ug.po +++ b/po/ug.po @@ -4,7 +4,7 @@ # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-08-26 11:59+0200\n" diff --git a/po/uk.po b/po/uk.po index 91e457a..c79afcd 100644 --- a/po/uk.po +++ b/po/uk.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-12-28 22:26+0200\n" diff --git a/po/ur.po b/po/ur.po index 83fd683..ad07264 100644 --- a/po/ur.po +++ b/po/ur.po @@ -4,7 +4,7 @@ # FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-04-23 08:37+0200\n" diff --git a/po/uz.po b/po/uz.po index d666d5d..6022af9 100644 --- a/po/uz.po +++ b/po/uz.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-22 02:31+0200\n" diff --git a/po/uz(a)latin.po b/po/uz(a)latin.po index 01a9094..8d96a43 100644 --- a/po/uz(a)latin.po +++ b/po/uz(a)latin.po @@ -1,7 +1,7 @@ # Automatically generated <>, 2010. msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2010-07-22 02:30+0200\n" diff --git a/po/zh_CN.po b/po/zh_CN.po index 304d0b9..a4d7900 100644 --- a/po/zh_CN.po +++ b/po/zh_CN.po @@ -1,7 +1,7 @@ # msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-03-04 09:47+0200\n" diff --git a/po/zh_TW.po b/po/zh_TW.po index 6096617..e03674c 100644 --- a/po/zh_TW.po +++ b/po/zh_TW.po @@ -1,6 +1,6 @@ msgid "" msgstr "" -"Project-Id-Version: phpMyAdmin 3.4.7-dev\n" +"Project-Id-Version: phpMyAdmin 3.4.8-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-10-06 09:23+0200\n" "PO-Revision-Date: 2011-05-31 09:47+0800\n" diff --git a/tbl_indexes.php b/tbl_indexes.php index 54923a0..ac32387 100644 --- a/tbl_indexes.php +++ b/tbl_indexes.php @@ -200,7 +200,7 @@ foreach ($index->getColumns() as $column) { || preg_match('/(char|text)/i', $field_type)) { echo '<option value="' . htmlspecialchars($field_name) . '"' . (($field_name == $column->getName()) ? ' selected="selected"' : '') . '>' - . htmlspecialchars($field_name) . ' [' . $field_type . ']' + . htmlspecialchars($field_name) . ' [' . htmlspecialchars($field_type) . ']' . '</option>' . "\n"; } } // end foreach $fields @@ -222,7 +222,7 @@ for ($i = 0; $i < $add_fields; $i++) { <?php foreach ($fields as $field_name => $field_type) { echo '<option value="' . htmlspecialchars($field_name) . '">' - . htmlspecialchars($field_name) . ' [' . $field_type . ']' + . htmlspecialchars($field_name) . ' [' . htmlspecialchars($field_type) . ']' . '</option>' . "\n"; } // end foreach $fields ?> diff --git a/tbl_select.php b/tbl_select.php index 2cb0086..8414222 100644 --- a/tbl_select.php +++ b/tbl_select.php @@ -124,7 +124,7 @@ if (!isset($param) || $param[0] == '') { ?> <tr class="noclick <?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>"> <th><?php echo htmlspecialchars($fields_list[$i]); ?></th> - <td><?php echo $fields_type[$i]; ?></td> + <td><?php echo htmlspecialchars($fields_type[$i]); ?></td> <td><?php echo $fields_collation[$i]; ?></td> <td><select name="func[]"> <?php @@ -190,7 +190,7 @@ if (!isset($param) || $param[0] == '') { <?php } elseif (strncasecmp($fields_type[$i], 'enum', 4) == 0) { // e n u m s - $enum_value=explode(', ', str_replace("'", '', substr($fields_type[$i], 5, -1))); + $enum_value=explode(', ', str_replace("'", '', substr(htmlspecialchars($fields_type[$i]), 5, -1))); $cnt_enum_value = count($enum_value); echo ' <select name="fields[' . $i . '][]"' .' multiple="multiple" size="' . min(3, $cnt_enum_value) . '">' . "\n"; diff --git a/themes/pmahomme/css/theme_right.css.php b/themes/pmahomme/css/theme_right.css.php index fba2f23..08f8ca5 100644 --- a/themes/pmahomme/css/theme_right.css.php +++ b/themes/pmahomme/css/theme_right.css.php @@ -65,7 +65,10 @@ h2 a img{display:inline;} .data{ margin: 0 0 12px 0; +} +#table_results td.data { +border-right: 1px solid #BBBBBB; } h3 { @@ -372,9 +375,10 @@ table tr.odd th, } /* even items 2,4,6,8,... */ +/* (tested on CRTs and ACLs) */ table tr.even th, .even { - background: #f3f3f3; + background: #DFDFDF; } /* odd table rows 1,3,5,7,... */ hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin annotated tag, RELEASE_3_4_8, created. RELEASE_3_4_8
by Marc Delisle 01 Dec '11

01 Dec '11

The annotated tag, RELEASE_3_4_8 has been created at 874669aab627e1d635d8b03a884153153b6c2097 (tag) tagging 3550b5adee887540a44a31bd5654f8c93d98d408 (commit) replaces RELEASE_3_4_8RC1 tagged by Marc Delisle on Thu Dec 1 12:21:24 2011 -0500 - Log ----------------------------------------------------------------- Released 3.4.8 Marc Delisle (1): 3.4.8 release ----------------------------------------------------------------------- hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_7_1-23848-g14b9e4c
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, master has been updated via 14b9e4cfa3673f36ae02e508f164cd9bdf0a4a26 (commit) from 684556adb0b1fa9823702e4df47402e55555a437 (commit) - Log ----------------------------------------------------------------- commit 14b9e4cfa3673f36ae02e508f164cd9bdf0a4a26 Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:18:06 2011 -0500 3.4.8 release ----------------------------------------------------------------------- Summary of changes: ChangeLog | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index c4e6afa..45d46a5 100644 --- a/ChangeLog +++ b/ChangeLog @@ -67,7 +67,7 @@ phpMyAdmin - ChangeLog - bug #3442004 [interface] DB suggestion not correct for user with underscore - bug #3438420 [core] Magic quotes removed in PHP 5.4 -3.4.8.0 (not yet released) +3.4.8.0 (2011-12-01) - bug #3425230 [interface] enum data split at space char (more space to edit) - bug #3426840 [interface] ENUM/SET editor can't handle commas in values - bug #3427256 [interface] no links to browse/empty views and tables hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, QA_3_4, updated. RELEASE_3_4_7_1-48-g9832c28
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, QA_3_4 has been updated via 9832c283f40c10d56a2e1dc3bd57525131ca1e4c (commit) from 5e6173015709d67c40877bcf51a5c4520e83f9de (commit) - Log ----------------------------------------------------------------- commit 9832c283f40c10d56a2e1dc3bd57525131ca1e4c Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:17:47 2011 -0500 3.4.8 release ----------------------------------------------------------------------- Summary of changes: ChangeLog | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/ChangeLog b/ChangeLog index 5355551..2f886e4 100644 --- a/ChangeLog +++ b/ChangeLog @@ -6,7 +6,7 @@ phpMyAdmin - ChangeLog - bug #3442004 [interface] DB suggestion not correct for user with underscore - bug #3438420 [core] Magic quotes removed in PHP 5.4 -3.4.8.0 (not yet released) +3.4.8.0 (2011-12-01) - bug #3425230 [interface] enum data split at space char (more space to edit) - bug #3426840 [interface] ENUM/SET editor can't handle commas in values - bug #3427256 [interface] no links to browse/empty views and tables hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, MAINT_3_4_8, updated. RELEASE_3_4_8RC1-1-g3550b5a
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, MAINT_3_4_8 has been updated via 3550b5adee887540a44a31bd5654f8c93d98d408 (commit) from b00745d352c89a5e52673e717e6cbef43dc229d6 (commit) - Log ----------------------------------------------------------------- commit 3550b5adee887540a44a31bd5654f8c93d98d408 Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 12:15:59 2011 -0500 3.4.8 release ----------------------------------------------------------------------- Summary of changes: ChangeLog | 2 +- Documentation.html | 4 ++-- README | 2 +- libraries/Config.class.php | 2 +- 4 files changed, 5 insertions(+), 5 deletions(-) diff --git a/ChangeLog b/ChangeLog index 7c40e9d..e7c3bf9 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,7 +1,7 @@ phpMyAdmin - ChangeLog ====================== -3.4.8.0 (not yet released) +3.4.8.0 (2011-12-01) - bug #3425230 [interface] enum data split at space char (more space to edit) - bug #3426840 [interface] ENUM/SET editor can't handle commas in values - bug #3427256 [interface] no links to browse/empty views and tables diff --git a/Documentation.html b/Documentation.html index 3d9f3c3..87a65d2 100644 --- a/Documentation.html +++ b/Documentation.html @@ -9,7 +9,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> - <title>phpMyAdmin 3.4.8-rc1 - Documentation</title> + <title>phpMyAdmin 3.4.8 - Documentation</title> <link rel="stylesheet" type="text/css" href="docs.css" /> </head> @@ -17,7 +17,7 @@ vim: expandtab ts=4 sw=4 sts=4 tw=78 <div id="header"> <h1> <a href="http://www.phpmyadmin.net/">php<span class="myadmin">MyAdmin</span></a> - 3.4.8-rc1 + 3.4.8 Documentation </h1> </div> diff --git a/README b/README index 65349d8..12e5e4e 100644 --- a/README +++ b/README @@ -1,7 +1,7 @@ phpMyAdmin - Readme =================== -Version 3.4.8-rc1 +Version 3.4.8 A set of PHP-scripts to manage MySQL over the web. diff --git a/libraries/Config.class.php b/libraries/Config.class.php index bd02527..cbcb3e4 100644 --- a/libraries/Config.class.php +++ b/libraries/Config.class.php @@ -96,7 +96,7 @@ class PMA_Config */ function checkSystem() { - $this->set('PMA_VERSION', '3.4.8-rc1'); + $this->set('PMA_VERSION', '3.4.8'); /** * @deprecated */ hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_7_1-23845-g5c21f85
by Michal Čihař 01 Dec '11

01 Dec '11

The branch, master has been updated via 5c21f8577e6a995dd8d99f64cdfd01d5f4c39de6 (commit) via e1e2282d8d2b0e703439a855d3b244ebfb89a2cc (commit) via f17408ae6df7aaddeb109651eab8b409834c4c4f (commit) via 87a2410c5e7171f04b46b090fc8204dbb9df6035 (commit) via a47939f338d313b551936d45618a03e4b365dba4 (commit) via 54bf831f77f3d0c4de280e75202d42d894875e21 (commit) via 1e7d4211dcf5a1251a570ff23b81af510cfdcb72 (commit) via c24cd3fac00ab907a72c55e29778b33ef903e925 (commit) via 85bbe04a83f3a4e1f9bae1611214653b77136f28 (commit) via fe90f254c292f81bf04de5fe596caf66aec6b047 (commit) via 0d31a33cc958ef4126168226a4458826b5853efd (commit) from e2228eed7795063c9007b46177d20a07d285a021 (commit) - Log ----------------------------------------------------------------- commit 5c21f8577e6a995dd8d99f64cdfd01d5f4c39de6 Merge: e2228ee e1e2282 Author: Michal Čihař <mcihar(a)suse.cz> Date: Thu Dec 1 12:04:47 2011 +0100 Merge remote-tracking branch 'pootle/master' commit e1e2282d8d2b0e703439a855d3b244ebfb89a2cc Merge: f17408a 0b04f90 Author: Pootle server <pootle(a)cihar.com> Date: Thu Dec 1 02:40:14 2011 +0100 Merge remote-tracking branch 'origin/master' commit f17408ae6df7aaddeb109651eab8b409834c4c4f Author: Burak Yavuz <hitowerdigit(a)hotmail.com> Date: Wed Nov 30 22:40:52 2011 +0200 Translation update done using Pootle. commit 87a2410c5e7171f04b46b090fc8204dbb9df6035 Author: Burak Yavuz <hitowerdigit(a)hotmail.com> Date: Wed Nov 30 22:29:34 2011 +0200 Translation update done using Pootle. commit a47939f338d313b551936d45618a03e4b365dba4 Author: Matías Bellone <matiasbellone(a)gmail.com> Date: Wed Nov 30 22:12:20 2011 +0200 Translation update done using Pootle. commit 54bf831f77f3d0c4de280e75202d42d894875e21 Author: Matías Bellone <matiasbellone(a)gmail.com> Date: Wed Nov 30 22:12:03 2011 +0200 Translation update done using Pootle. commit 1e7d4211dcf5a1251a570ff23b81af510cfdcb72 Author: Marc Delisle <marc(a)infomarc.info> Date: Wed Nov 30 21:52:09 2011 +0200 Translation update done using Pootle. commit c24cd3fac00ab907a72c55e29778b33ef903e925 Author: dannybeckett <daniel.beckett(a)gmail.com> Date: Wed Nov 30 21:51:46 2011 +0200 Translation update done using Pootle. commit 85bbe04a83f3a4e1f9bae1611214653b77136f28 Merge: fe90f25 5e090e3 Author: Pootle server <pootle(a)cihar.com> Date: Wed Nov 30 18:40:15 2011 +0100 Merge remote-tracking branch 'origin/master' commit fe90f254c292f81bf04de5fe596caf66aec6b047 Author: Domen <dbc334(a)gmail.com> Date: Wed Nov 30 18:28:03 2011 +0200 Translation update done using Pootle. commit 0d31a33cc958ef4126168226a4458826b5853efd Author: Domen <dbc334(a)gmail.com> Date: Wed Nov 30 18:27:18 2011 +0200 Translation update done using Pootle. ----------------------------------------------------------------------- Summary of changes: po/es.po | 7 ++++--- po/fr.po | 7 ++++--- po/sl.po | 11 ++++++----- po/tr.po | 7 ++++--- 4 files changed, 18 insertions(+), 14 deletions(-) diff --git a/po/es.po b/po/es.po index 615ff00..f3375eb 100644 --- a/po/es.po +++ b/po/es.po @@ -4,7 +4,7 @@ msgstr "" "Project-Id-Version: phpMyAdmin 3.5.0-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-11-30 14:18+0100\n" -"PO-Revision-Date: 2011-11-20 19:31+0200\n" +"PO-Revision-Date: 2011-11-30 22:12+0200\n" "Last-Translator: Matías Bellone <matiasbellone(a)gmail.com>\n" "Language-Team: spanish <es(a)li.org>\n" "Language: es\n" @@ -4744,12 +4744,13 @@ msgid "" "Limits number of table preferences which are stored in database, the oldest " "records are automatically removed" msgstr "" +"Limita la cantidad de preferencias sobre tablas que serán almacenadas en la " +"base de datos, las más antiguas serán eliminadas automáticamente" #: libraries/config/messages.inc.php:403 -#, fuzzy #| msgid "Maximum number of tables displayed in table list" msgid "Maximal number of table preferences to store" -msgstr "Número máximo de tablas mostradas en una lista de tablas" +msgstr "Número máximo de preferencias sobre tablas a almacenar" #: libraries/config/messages.inc.php:404 msgid "Try to connect without password" diff --git a/po/fr.po b/po/fr.po index f79e71e..1e6885f 100644 --- a/po/fr.po +++ b/po/fr.po @@ -4,7 +4,7 @@ msgstr "" "Project-Id-Version: phpMyAdmin 3.5.0-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-11-30 14:18+0100\n" -"PO-Revision-Date: 2011-11-23 17:16+0200\n" +"PO-Revision-Date: 2011-11-30 21:51+0200\n" "Last-Translator: Marc Delisle <marc(a)infomarc.info>\n" "Language-Team: french <fr(a)li.org>\n" "Language: fr\n" @@ -4709,12 +4709,13 @@ msgid "" "Limits number of table preferences which are stored in database, the oldest " "records are automatically removed" msgstr "" +"Limite le nombre de préférences de tables qui sont stockées dans la base de " +"données, les entrées les plus anciennes sont automatiquement effacées" #: libraries/config/messages.inc.php:403 -#, fuzzy #| msgid "Maximum number of tables displayed in table list" msgid "Maximal number of table preferences to store" -msgstr "Nombre maximum de tables affichées dans la liste des tables" +msgstr "Nombre maximum de préférences de tables à conserver" #: libraries/config/messages.inc.php:404 msgid "Try to connect without password" diff --git a/po/sl.po b/po/sl.po index 849d1cf..4ea2f5e 100644 --- a/po/sl.po +++ b/po/sl.po @@ -4,15 +4,15 @@ msgstr "" "Project-Id-Version: phpMyAdmin 3.5.0-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-11-30 14:18+0100\n" -"PO-Revision-Date: 2011-11-21 22:01+0200\n" +"PO-Revision-Date: 2011-11-30 18:27+0200\n" "Last-Translator: Domen <dbc334(a)gmail.com>\n" "Language-Team: slovenian <sl(a)li.org>\n" "Language: sl\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" -"Plural-Forms: nplurals=4; plural=(n%100==1 ? 0 : n%100==2 ? 1 : n%100==3 || n" -"%100==4 ? 2 : 3);\n" +"Plural-Forms: nplurals=4; plural=(n%100==1 ? 0 : n%100==2 ? 1 : n%100==3 || " +"n%100==4 ? 2 : 3);\n" "X-Generator: Pootle 2.1.6\n" #: browse_foreigners.php:35 browse_foreigners.php:53 js/messages.php:329 @@ -4687,12 +4687,13 @@ msgid "" "Limits number of table preferences which are stored in database, the oldest " "records are automatically removed" msgstr "" +"Omeji število nastavitev tabel, ki so shranjene v zbirki podatkov; " +"najstarejši zapisi bodo samodejno odstranjeni" #: libraries/config/messages.inc.php:403 -#, fuzzy #| msgid "Maximum number of tables displayed in table list" msgid "Maximal number of table preferences to store" -msgstr "Največje število tabel prikazanih na seznamu tabel" +msgstr "Največje število shranjenih nastavitev tabel" #: libraries/config/messages.inc.php:404 msgid "Try to connect without password" diff --git a/po/tr.po b/po/tr.po index 49b0074..7e4a48d 100644 --- a/po/tr.po +++ b/po/tr.po @@ -4,7 +4,7 @@ msgstr "" "Project-Id-Version: phpMyAdmin 3.5.0-dev\n" "Report-Msgid-Bugs-To: phpmyadmin-devel(a)lists.sourceforge.net\n" "POT-Creation-Date: 2011-11-30 14:18+0100\n" -"PO-Revision-Date: 2011-11-21 19:24+0200\n" +"PO-Revision-Date: 2011-11-30 22:29+0200\n" "Last-Translator: Burak Yavuz <hitowerdigit(a)hotmail.com>\n" "Language-Team: turkish <tr(a)li.org>\n" "Language: tr\n" @@ -4690,12 +4690,13 @@ msgid "" "Limits number of table preferences which are stored in database, the oldest " "records are automatically removed" msgstr "" +"Veritabanında depolanan tablo tercihlerinin sayısını sınırlandırır, en eski " +"kayıtlar otomatik olarak kaldırılır." #: libraries/config/messages.inc.php:403 -#, fuzzy #| msgid "Maximum number of tables displayed in table list" msgid "Maximal number of table preferences to store" -msgstr "Tablo listesinde görüntülenecek olan en fazla tablo sayısıdır" +msgstr "Depolamak için en fazla tablo tercihleri sayısıdır" #: libraries/config/messages.inc.php:404 msgid "Try to connect without password" hooks/post-receive -- phpMyAdmin

1 0

[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_7_1-23834-ge2228ee
by Marc Delisle 01 Dec '11

01 Dec '11

The branch, master has been updated via e2228eed7795063c9007b46177d20a07d285a021 (commit) from 0b04f907565ecde39010aa5b6b342cdbe7d4713c (commit) - Log ----------------------------------------------------------------- commit e2228eed7795063c9007b46177d20a07d285a021 Author: Marc Delisle <marc(a)infomarc.info> Date: Thu Dec 1 05:54:37 2011 -0500 View editing via a generated ALTER VIEW ----------------------------------------------------------------------- Summary of changes: ChangeLog | 1 + tbl_structure.php | 1 + 2 files changed, 2 insertions(+), 0 deletions(-) diff --git a/ChangeLog b/ChangeLog index 9fb4838..c4e6afa 100644 --- a/ChangeLog +++ b/ChangeLog @@ -60,6 +60,7 @@ phpMyAdmin - ChangeLog + rfe #1632106 [interface] Improved error handling + patch #3432835 [interface] Add useful intermediate pages to pageselector + [interface] Improved index editor ++ View editing via a generated ALTER VIEW 3.4.9.0 (not yet released) - bug #3442028 [edit] Inline editing enum fields with null shows no dropdown diff --git a/tbl_structure.php b/tbl_structure.php index 9de9d5a..c2a4bd2 100644 --- a/tbl_structure.php +++ b/tbl_structure.php @@ -595,6 +595,7 @@ if (! $tbl_is_view && ! $db_is_information_schema) { if ($tbl_is_view) { $create_view = PMA_DBI_get_definition($db, 'VIEW', $table); + $create_view = preg_replace('@^CREATE@', 'ALTER', $create_view); echo PMA_linkOrButton( 'tbl_sql.php' . PMA_generate_common_url( $url_params + hooks/post-receive -- phpMyAdmin

1 0

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

Git December 2011