[adminer-svn] SF.net SVN: adminer:[1408] branches/sqlite
Database management in a single PHP file
Brought to you by:
jakubvrana
From: <jak...@us...> - 2010-04-09 16:12:42
|
Revision: 1408 http://adminer.svn.sourceforge.net/adminer/?rev=1408&view=rev Author: jakubvrana Date: 2010-04-09 16:12:36 +0000 (Fri, 09 Apr 2010) Log Message: ----------- Spaces Modified Paths: -------------- branches/sqlite/adminer/drivers/mysql.inc.php branches/sqlite/adminer/include/adminer.inc.php branches/sqlite/todo.txt Modified: branches/sqlite/adminer/drivers/mysql.inc.php =================================================================== --- branches/sqlite/adminer/drivers/mysql.inc.php 2010-04-09 15:58:55 UTC (rev 1407) +++ branches/sqlite/adminer/drivers/mysql.inc.php 2010-04-09 16:12:36 UTC (rev 1408) @@ -564,7 +564,7 @@ $alter = array(); foreach ($fields as $field) { $alter[] = ($field[1] - ? ($table != "" ? ($field[0] != "" ? "CHANGE " . idf_escape($field[0]) : "ADD ") : " ") . implode("", $field[1]) . ($table != "" ? " $field[2]" : "") + ? ($table != "" ? ($field[0] != "" ? "CHANGE " . idf_escape($field[0]) : "ADD") : " ") . " " . implode("", $field[1]) . ($table != "" ? " $field[2]" : "") : "DROP " . idf_escape($field[0]) ); } Modified: branches/sqlite/adminer/include/adminer.inc.php =================================================================== --- branches/sqlite/adminer/include/adminer.inc.php 2010-04-09 15:58:55 UTC (rev 1407) +++ branches/sqlite/adminer/include/adminer.inc.php 2010-04-09 16:12:36 UTC (rev 1408) @@ -384,7 +384,7 @@ $id = "sql-" . count($_SESSION["messages"]); $history = &get_session("history"); $history[DB][] = (strlen($query) > 1e6 ? ereg_replace('[\x80-\xFF]+$', '', substr($query, 0, 1e6)) . "\n..." : $query); // [\x80-\xFF] - valid UTF-8, \n - can end by one-line comment - return " <a href='#$id' onclick=\"return !toggle('$id');\">" . lang('SQL command') . "</a><div id='$id' class='hidden'><pre class='jush-$driver'>" . shorten_utf8($query, 1000) . '</pre><a href="' . h(ME . 'sql=&history=' . (count($history[DB]) - 1)) . '">' . lang('Edit') . '</a></div>'; + return " <a href='#$id' onclick=\"return !toggle('$id');\">" . lang('SQL command') . "</a><div id='$id' class='hidden'><pre class='jush-$driver'>" . shorten_utf8($query, 1000) . '</pre><p><a href="' . h(ME . 'sql=&history=' . (count($history[DB]) - 1)) . '">' . lang('Edit') . '</a></div>'; } /** Functions displayed in edit form Modified: branches/sqlite/todo.txt =================================================================== --- branches/sqlite/todo.txt 2010-04-09 15:58:55 UTC (rev 1407) +++ branches/sqlite/todo.txt 2010-04-09 16:12:36 UTC (rev 1408) @@ -12,11 +12,13 @@ Blob download and image display in edit form (important for Editor with hidden fields in select) Add title to Logout, edit (in select) and select (in menu) in style "hever" Shift-click in checkboxes to select range +Export by GET parameters ? LIKE %% operator ? Column and table names auto-completition in SQL textarea ? Aliasing of built-in functions can save 7 KB, function minification can save 7 KB, substitution of repetitive $a["a"] can save 4 KB, substitution of $_GET and friends can save 2 KB, aliasing of $connection->query, $connection->result and $connection->quote can save ~ 3 KB, JS packer can save 1 KB, not enclosing HTML attribute values can save 1.2 KB, replacing \\n by \n can save .3 KB ? Branch binary_compile: LZW compression of translations can save 30 KB, LZW compression of all texts can save 11 KB, remove of base64_decode() + using chars 127-255 in minification can save 1 KB ? AJAX editing - select page has all data to display edit form +? MySQL geometry support Translations - database(s) have been dropped Editor: This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |