The Internet, 2003-04-13
To: phpMyAdmin community
The development team is pleased to announce version 2.5.0-rc1 (first release candidate) of phpMyAdmin.
Improvements:
* distinct Query window * field contents transformations (inline resized images, links, external programs, etc) * display column comments in exports * automatic update of relations, display fields, comments, bookmarks, etc after table/column changes * new display mode with 90 degree rotated headers * display query time * js row marker now works in vertical mode * SQL history: db- or not-db-based * optional vertical display of the columns in edit mode * optional lightweight menu tabs * InnoDB status monitor * print button in db view * new Export page with dynamic options * better security for docSQL importer * in edit mode, display first the functions that match field type * parameters for bookmarks queries * support for changing auto-increment value * default initial query in browse mode, based on a bookmark with the same name as the table * execute bookmarks when browsing bookmarks table * if available, display Create/Update/Check_time * in browse mode, highlight the fields used in the WHERE condition for the query * automatic layout of the PDF schema * choose results page in browse mode * automatic detection of compression for uploaded data * CHECK TABLE/ANALYSE TABLE for multisubmit actions * support for SHOW FULL PROCESSLIST * can now insert multiple fields at cursor position in the query textarea
Fixes:
* could not insert some words like "$enum$" * bad URL (extra /) for generated PDFs * double password query with http auth * check privileges only shows root user * display SQL query used for an index modification * pdf schema headers footers for long pages * export results and LIMIT * inserting values with quotes * $cfg['PmaAbsoluteUri'] autodetection and CGI mode * escaping of \n, \r and \t characters * handling of disabled ini_get() * go back to fields definition form after an error * support XOR in the parser * check for field type when doing charset conversion * support for HTML entities as db/table/column names * avoid long delays when browsing big tables (MySQL 4) * support for host-based privileges * bad arrow aligning on PDF schema in "same widths" mode * faster record count * "undefined index" error in the data dictionary when using MySQL 3.22 or below * the privileges administration script did not work well with host-based DB privileges * having added a new user, the corresponding SQL query was not displayed * better "superuser" checking mechanism * "wrong parameter count" error when connecting with some strangely compiled php versions * replaced the %e placeholder in the date format string of some translations because it did not have any effect on Windows machines.
Download links, as usual, on http://www.phpmyadmin.net
Marc Delisle, for the team.
Hi all,
The QueryWindow is a good idea :) Here are 2 small changes on the window.open, if you want to add them (queryframe.php) :
- First :
There is sometimes a problem with the syntax <a href="#" onClick="foo"> with certain navigator. I suggest this (more efficient i think)
------------------------------------- 89c89 < $href = '#'; ---
$href = $anchor;
91c91 < $onclick = 'onClick="javascript:open_querywindow('' . $anchor . ''); return false;"'; ---
$onclick = 'onClick="javascript:open_querywindow(this.href); return
false;"'; -------------------------------------
- Second :
Under IE, if you name your windows (second arg of window.open), this work *very very* slowly !!! Watch your CPU load in the task manager (under NT). It is incredible. So, I suggest to set name of window to '' or to '_blank' !
------------------------------------- 60c60 < querywindow=window.open(url + '&db=' + document.queryframeform.db.value + '&table=' + document.queryframeform.table.value, 'js_querywindow','toolbar=0,location=0,directories=0,status=1,menubar=0,scro llbars=yes,resizable=yes,width=<?php echo $cfg['QueryWindowWidth']; ?>,height=<?php echo $cfg['QueryWindowHeight']; ?>'); ---
querywindow=window.open(url + '&db=' +
document.queryframeform.db.value + '&table=' + document.queryframeform.table.value, '','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=yes,res izable=yes,width=<?php echo $cfg['QueryWindowWidth']; ?>,height=<?php echo $cfg['QueryWindowHeight']; ?>'); -------------------------------------
What do you think about this ? I don't know if I still have access to the CVS, so, i'm not sure i can commit these changes (if you are agree with, of course).
HTH,
Armel.
Hi Armel!
Thanks for your suggestions, I just implemented them into CVS. I wasn't aware of JS windows referenced by name cause slowdowns in IE, and haven't experienced them on my installations. Nevertheless, your suggestion doesn't cause troubles in any of my browsers (Mozilla 1.2, IE6, Opera6) so I changed the window name.
And thanks for the hint of that #-thingie. This indeed is more compatible. :)
Regards, Garvin.
-
Armel FAUVEAU -
Garvin Hicking -
Marc Delisle