Thread: [adminer-svn] SF.net SVN: adminer:[1187] trunk/adminer/db.inc.php
Database management in a single PHP file
Brought to you by:
jakubvrana
From: <jak...@us...> - 2009-10-13 19:32:59
|
Revision: 1187 http://adminer.svn.sourceforge.net/adminer/?rev=1187&view=rev Author: jakubvrana Date: 2009-10-13 19:32:49 +0000 (Tue, 13 Oct 2009) Log Message: ----------- Link alter view Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2009-10-13 13:05:10 UTC (rev 1186) +++ trunk/adminer/db.inc.php 2009-10-13 19:32:49 UTC (rev 1187) @@ -60,7 +60,9 @@ } echo "<td>" . nbsp($row["Comment"]); } else { - echo '<td colspan="8"><a href="' . h(ME) . "select=" . urlencode($name) . '">' . lang('View') . '</a>'; + echo '<td colspan="6"><a href="' . h(ME) . "view=" . urlencode($name) . '">' . lang('View') . '</a>'; + echo '<td align="right"><a href="' . h(ME) . "select=" . urlencode($name) . '">?</a>'; + echo '<td> '; } } echo "</table>\n"; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2009-10-13 20:09:09
|
Revision: 1191 http://adminer.svn.sourceforge.net/adminer/?rev=1191&view=rev Author: jakubvrana Date: 2009-10-13 20:08:58 +0000 (Tue, 13 Oct 2009) Log Message: ----------- Disable foreign_key_checks only with drop and truncate Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2009-10-13 20:01:52 UTC (rev 1190) +++ trunk/adminer/db.inc.php 2009-10-13 20:08:58 UTC (rev 1191) @@ -4,7 +4,7 @@ if ($tables_views && !$error) { $result = true; $message = ""; - if (count($_POST["tables"]) > 1) { + if (count($_POST["tables"]) > 1 && ($_POST["drop"] || $_POST["truncate"])) { queries("SET foreign_key_checks = 0"); // allows to truncate or drop several tables at once } if (isset($_POST["truncate"])) { @@ -21,6 +21,7 @@ $rename[] = idf_escape($table) . " TO " . idf_escape($_POST["target"]) . "." . idf_escape($table); } $result = queries("RENAME TABLE " . implode(", ", $rename)); + //! move triggers $message = lang('Tables have been moved.'); } elseif ((!isset($_POST["drop"]) || !$_POST["views"] || queries("DROP VIEW " . implode(", ", array_map('idf_escape', $_POST["views"])))) && (!$_POST["tables"] || ($result = queries((isset($_POST["optimize"]) ? "OPTIMIZE" : (isset($_POST["check"]) ? "CHECK" : (isset($_POST["repair"]) ? "REPAIR" : (isset($_POST["drop"]) ? "DROP" : "ANALYZE")))) . " TABLE " . implode(", ", array_map('idf_escape', $_POST["tables"]))))) This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2009-12-10 11:56:17
|
Revision: 1262 http://adminer.svn.sourceforge.net/adminer/?rev=1262&view=rev Author: jakubvrana Date: 2009-12-10 11:55:59 +0000 (Thu, 10 Dec 2009) Log Message: ----------- Whitespace Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2009-12-08 22:57:39 UTC (rev 1261) +++ trunk/adminer/db.inc.php 2009-12-10 11:55:59 UTC (rev 1262) @@ -24,7 +24,7 @@ //! move triggers $message = lang('Tables have been moved.'); } elseif ((!isset($_POST["drop"]) || !$_POST["views"] || queries("DROP VIEW " . implode(", ", array_map('idf_escape', $_POST["views"])))) - && (!$_POST["tables"] || ($result = queries((isset($_POST["optimize"]) ? "OPTIMIZE" : (isset($_POST["check"]) ? "CHECK" : (isset($_POST["repair"]) ? "REPAIR" : (isset($_POST["drop"]) ? "DROP" : "ANALYZE")))) . " TABLE " . implode(", ", array_map('idf_escape', $_POST["tables"]))))) + && (!$_POST["tables"] || ($result = queries((isset($_POST["optimize"]) ? "OPTIMIZE" : (isset($_POST["check"]) ? "CHECK" : (isset($_POST["repair"]) ? "REPAIR" : (isset($_POST["drop"]) ? "DROP" : "ANALYZE")))) . " TABLE " . implode(", ", array_map('idf_escape', $_POST["tables"]))))) ) { if (isset($_POST["drop"])) { $message = lang('Tables have been dropped.'); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2010-03-02 22:28:12
|
Revision: 1338 http://adminer.svn.sourceforge.net/adminer/?rev=1338&view=rev Author: jakubvrana Date: 2010-03-02 22:28:05 +0000 (Tue, 02 Mar 2010) Log Message: ----------- Remove buttons from information_schema Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2010-03-02 16:33:28 UTC (rev 1337) +++ trunk/adminer/db.inc.php 2010-03-02 22:28:05 UTC (rev 1338) @@ -81,11 +81,13 @@ echo "<td align='right'>" . number_format($sums[$val], 0, '.', lang(',')); } echo "</table>\n"; - echo "<p><input type='hidden' name='token' value='$token'><input type='submit' value='" . lang('Analyze') . "'> <input type='submit' name='optimize' value='" . lang('Optimize') . "'> <input type='submit' name='check' value='" . lang('Check') . "'> <input type='submit' name='repair' value='" . lang('Repair') . "'> <input type='submit' name='truncate' value='" . lang('Truncate') . "' onclick=\"return confirm('" . lang('Are you sure?') . " (' + formChecked(this, /tables/) + ')');\"> <input type='submit' name='drop' value='" . lang('Drop') . "' onclick=\"return confirm('" . lang('Are you sure?') . " (' + formChecked(this, /tables|views/) + ')');\">\n"; - $dbs = get_databases(); - if (count($dbs) != 1) { - $db = (isset($_POST["target"]) ? $_POST["target"] : DB); - echo "<p>" . lang('Move to other database') . ($dbs ? ": " . html_select("target", $dbs, $db) : ': <input name="target" value="' . h($db) . '">') . " <input type='submit' name='move' value='" . lang('Move') . "'>\n"; + if (!information_schema(DB)) { + echo "<p><input type='hidden' name='token' value='$token'><input type='submit' value='" . lang('Analyze') . "'> <input type='submit' name='optimize' value='" . lang('Optimize') . "'> <input type='submit' name='check' value='" . lang('Check') . "'> <input type='submit' name='repair' value='" . lang('Repair') . "'> <input type='submit' name='truncate' value='" . lang('Truncate') . "' onclick=\"return confirm('" . lang('Are you sure?') . " (' + formChecked(this, /tables/) + ')');\"> <input type='submit' name='drop' value='" . lang('Drop') . "' onclick=\"return confirm('" . lang('Are you sure?') . " (' + formChecked(this, /tables|views/) + ')');\">\n"; + $dbs = get_databases(); + if (count($dbs) != 1) { + $db = (isset($_POST["target"]) ? $_POST["target"] : DB); + echo "<p>" . lang('Move to other database') . ($dbs ? ": " . html_select("target", $dbs, $db) : ': <input name="target" value="' . h($db) . '">') . " <input type='submit' name='move' value='" . lang('Move') . "'>\n"; + } } echo "</form>\n"; } This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2010-03-23 17:14:28
|
Revision: 1350 http://adminer.svn.sourceforge.net/adminer/?rev=1350&view=rev Author: jakubvrana Date: 2010-03-23 17:14:22 +0000 (Tue, 23 Mar 2010) Log Message: ----------- Link Create table from tables overview (thanks to Stepan Kocourek) Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2010-03-23 16:03:34 UTC (rev 1349) +++ trunk/adminer/db.inc.php 2010-03-23 17:14:22 UTC (rev 1350) @@ -92,8 +92,9 @@ echo "</form>\n"; } +echo '<p><a href="' . h(ME) . 'create=">' . lang('Create table') . "</a>\n"; if ($connection->server_info >= 5) { - echo '<p><a href="' . h(ME) . 'view=">' . lang('Create view') . "</a>\n"; + echo ' <a href="' . h(ME) . 'view=">' . lang('Create view') . "</a>\n"; echo "<h3>" . lang('Routines') . "</h3>\n"; $result = $connection->query("SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = " . $connection->quote(DB)); if ($result->num_rows) { This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2010-04-22 09:22:25
|
Revision: 1474 http://adminer.svn.sourceforge.net/adminer/?rev=1474&view=rev Author: jakubvrana Date: 2010-04-22 09:22:19 +0000 (Thu, 22 Apr 2010) Log Message: ----------- Bold table names in message (bug #2990383) Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2010-04-22 00:33:46 UTC (rev 1473) +++ trunk/adminer/db.inc.php 2010-04-22 09:22:19 UTC (rev 1474) @@ -30,7 +30,7 @@ $message = lang('Tables have been dropped.'); } elseif ($_POST["tables"] && ($result = queries(($_POST["optimize"] ? "OPTIMIZE" : ($_POST["check"] ? "CHECK" : ($_POST["repair"] ? "REPAIR" : "ANALYZE"))) . " TABLE " . implode(", ", array_map('idf_escape', $_POST["tables"]))))) { while ($row = $result->fetch_assoc()) { - $message .= h("$row[Table]: $row[Msg_text]") . "<br>"; + $message .= "<b>" . h($row["Table"]) . "</b>: " . h($row["Msg_text"]) . "<br>"; } } queries_redirect(substr(ME, 0, -1), $message, $result); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <jak...@us...> - 2010-04-27 15:56:49
|
Revision: 1505 http://adminer.svn.sourceforge.net/adminer/?rev=1505&view=rev Author: jakubvrana Date: 2010-04-27 15:56:42 +0000 (Tue, 27 Apr 2010) Log Message: ----------- Improve routines listing (thanks to paranoiq) Modified Paths: -------------- trunk/adminer/db.inc.php Modified: trunk/adminer/db.inc.php =================================================================== --- trunk/adminer/db.inc.php 2010-04-27 15:56:13 UTC (rev 1504) +++ trunk/adminer/db.inc.php 2010-04-27 15:56:42 UTC (rev 1505) @@ -96,11 +96,14 @@ echo "<h3>" . lang('Routines') . "</h3>\n"; $result = $connection->query("SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = " . $connection->quote(DB)); if ($result->num_rows) { + odd(''); echo "<table cellspacing='0'>\n"; + echo '<thead><tr><th>' . lang('Name') . '<td>' . lang('Type') . '<td>' . lang('Return type') . "<td> </thead>\n"; while ($row = $result->fetch_assoc()) { - echo "<tr>"; - echo "<td>" . h($row["ROUTINE_TYPE"]); + echo '<tr' . odd() . '>'; echo '<th><a href="' . h(ME) . ($row["ROUTINE_TYPE"] == "FUNCTION" ? 'callf=' : 'call=') . urlencode($row["ROUTINE_NAME"]) . '">' . h($row["ROUTINE_NAME"]) . '</a>'; + echo '<td>' . h($row["ROUTINE_TYPE"]); + echo '<td>' . h($row["DTD_IDENTIFIER"]); echo '<td><a href="' . h(ME) . ($row["ROUTINE_TYPE"] == "FUNCTION" ? 'function=' : 'procedure=') . urlencode($row["ROUTINE_NAME"]) . '">' . lang('Alter') . "</a>"; } echo "</table>\n"; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |