mirror of
https://github.com/vrana/adminer.git
synced 2025-08-07 23:27:17 +02:00
647 lines
21 KiB
PHP
647 lines
21 KiB
PHP
<?php
|
|
namespace Adminer;
|
|
|
|
class Adminer {
|
|
static $instance;
|
|
public $error = '';
|
|
private $values = array();
|
|
|
|
function name() {
|
|
return "<a href='https://www.adminer.org/editor/'" . target_blank() . " id='h1'><img src='../adminer/static/logo.png' width='24' height='24' alt='' id='logo'>" . lang('Editor') . "</a>";
|
|
}
|
|
|
|
//! driver, ns
|
|
|
|
function credentials() {
|
|
return array(SERVER, $_GET["username"], get_password());
|
|
}
|
|
|
|
function connectSsl() {
|
|
}
|
|
|
|
function permanentLogin($create = false) {
|
|
return password_file($create);
|
|
}
|
|
|
|
function bruteForceKey() {
|
|
return $_SERVER["REMOTE_ADDR"];
|
|
}
|
|
|
|
function serverName($server) {
|
|
}
|
|
|
|
function database() {
|
|
if (connection()) {
|
|
$databases = adminer()->databases(false);
|
|
return (!$databases
|
|
? get_val("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1)") // username without the database list
|
|
: $databases[(information_schema($databases[0]) ? 1 : 0)] // first available database
|
|
);
|
|
}
|
|
}
|
|
|
|
function operators() {
|
|
return array("<=", ">=");
|
|
}
|
|
|
|
function schemas() {
|
|
return schemas();
|
|
}
|
|
|
|
function databases($flush = true) {
|
|
return get_databases($flush);
|
|
}
|
|
|
|
function pluginsLinks(): void {
|
|
}
|
|
|
|
function queryTimeout() {
|
|
return 5;
|
|
}
|
|
|
|
function afterConnect() {
|
|
}
|
|
|
|
function headers() {
|
|
}
|
|
|
|
function csp($csp) {
|
|
return $csp;
|
|
}
|
|
|
|
function head($dark = null) {
|
|
return true;
|
|
}
|
|
|
|
function bodyClass(): void {
|
|
echo " editor";
|
|
}
|
|
|
|
function css() {
|
|
$return = array();
|
|
foreach (array("", "-dark") as $mode) {
|
|
$filename = "adminer$mode.css";
|
|
if (file_exists($filename)) {
|
|
$file = file_get_contents($filename);
|
|
$return["$filename?v=" . crc32($file)] = ($mode
|
|
? "dark"
|
|
: (preg_match('~prefers-color-scheme:\s*dark~', $file) ? '' : 'light')
|
|
);
|
|
}
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function loginForm() {
|
|
echo "<table class='layout'>\n";
|
|
echo adminer()->loginFormField('username', '<tr><th>' . lang('Username') . '<td>', input_hidden("auth[driver]", "server") . '<input name="auth[username]" autofocus value="' . h($_GET["username"]) . '" autocomplete="username" autocapitalize="off">');
|
|
echo adminer()->loginFormField('password', '<tr><th>' . lang('Password') . '<td>', '<input type="password" name="auth[password]" autocomplete="current-password">');
|
|
echo "</table>\n";
|
|
echo "<p><input type='submit' value='" . lang('Login') . "'>\n";
|
|
echo checkbox("auth[permanent]", 1, $_COOKIE["adminer_permanent"], lang('Permanent login')) . "\n";
|
|
}
|
|
|
|
function loginFormField($name, $heading, $value) {
|
|
return $heading . $value . "\n";
|
|
}
|
|
|
|
function login($login, $password) {
|
|
return true;
|
|
}
|
|
|
|
function tableName($tableStatus) {
|
|
return h(isset($tableStatus["Engine"])
|
|
? ($tableStatus["Comment"] != "" ? $tableStatus["Comment"] : $tableStatus["Name"])
|
|
: "" // ignore views
|
|
);
|
|
}
|
|
|
|
function fieldName($field, $order = 0) {
|
|
return h(preg_replace('~\s+\[.*\]$~', '', ($field["comment"] != "" ? $field["comment"] : $field["field"])));
|
|
}
|
|
|
|
function selectLinks($tableStatus, $set = "") {
|
|
$TABLE = $tableStatus["Name"];
|
|
if ($set !== null) {
|
|
echo '<p class="tabs"><a href="' . h(ME . 'edit=' . urlencode($TABLE) . $set) . '">' . lang('New item') . "</a>\n";
|
|
}
|
|
}
|
|
|
|
function foreignKeys($table) {
|
|
return foreign_keys($table);
|
|
}
|
|
|
|
function backwardKeys($table, $tableName) {
|
|
$return = array();
|
|
foreach (
|
|
get_rows("SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_COLUMN_NAME
|
|
FROM information_schema.KEY_COLUMN_USAGE
|
|
WHERE TABLE_SCHEMA = " . q(adminer()->database()) . "
|
|
AND REFERENCED_TABLE_SCHEMA = " . q(adminer()->database()) . "
|
|
AND REFERENCED_TABLE_NAME = " . q($table) . "
|
|
ORDER BY ORDINAL_POSITION", null, "") as $row
|
|
) {
|
|
$return[$row["TABLE_NAME"]]["keys"][$row["CONSTRAINT_NAME"]][$row["COLUMN_NAME"]] = $row["REFERENCED_COLUMN_NAME"];
|
|
}
|
|
foreach ($return as $key => $val) {
|
|
$name = adminer()->tableName(table_status1($key, true));
|
|
if ($name != "") {
|
|
$search = preg_quote($tableName);
|
|
$separator = "(:|\\s*-)?\\s+";
|
|
$return[$key]["name"] = (preg_match("(^$search$separator(.+)|^(.+?)$separator$search\$)iu", $name, $match) ? $match[2] . $match[3] : $name);
|
|
} else {
|
|
unset($return[$key]);
|
|
}
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function backwardKeysPrint($backwardKeys, $row) {
|
|
foreach ($backwardKeys as $table => $backwardKey) {
|
|
foreach ($backwardKey["keys"] as $cols) {
|
|
$link = ME . 'select=' . urlencode($table);
|
|
$i = 0;
|
|
foreach ($cols as $column => $val) {
|
|
$link .= where_link($i++, $column, $row[$val]);
|
|
}
|
|
echo "<a href='" . h($link) . "'>" . h($backwardKey["name"]) . "</a>";
|
|
$link = ME . 'edit=' . urlencode($table);
|
|
foreach ($cols as $column => $val) {
|
|
$link .= "&set" . urlencode("[" . bracket_escape($column) . "]") . "=" . urlencode($row[$val]);
|
|
}
|
|
echo "<a href='" . h($link) . "' title='" . lang('New item') . "'>+</a> ";
|
|
}
|
|
}
|
|
}
|
|
|
|
function selectQuery($query, $start, $failed = false) {
|
|
return "<!--\n" . str_replace("--", "--><!-- ", $query) . "\n(" . format_time($start) . ")\n-->\n";
|
|
}
|
|
|
|
function rowDescription($table) {
|
|
// first varchar column
|
|
foreach (fields($table) as $field) {
|
|
if (preg_match("~varchar|character varying~", $field["type"])) {
|
|
return idf_escape($field["field"]);
|
|
}
|
|
}
|
|
return "";
|
|
}
|
|
|
|
function rowDescriptions($rows, $foreignKeys) {
|
|
$return = $rows;
|
|
foreach ($rows[0] as $key => $val) {
|
|
if (list($table, $id, $name) = $this->_foreignColumn($foreignKeys, $key)) {
|
|
// find all used ids
|
|
$ids = array();
|
|
foreach ($rows as $row) {
|
|
$ids[$row[$key]] = q($row[$key]);
|
|
}
|
|
// uses constant number of queries to get the descriptions, join would be complex, multiple queries would be slow
|
|
$descriptions = $this->values[$table];
|
|
if (!$descriptions) {
|
|
$descriptions = get_key_vals("SELECT $id, $name FROM " . table($table) . " WHERE $id IN (" . implode(", ", $ids) . ")");
|
|
}
|
|
// use the descriptions
|
|
foreach ($rows as $n => $row) {
|
|
if (isset($row[$key])) {
|
|
$return[$n][$key] = (string) $descriptions[$row[$key]];
|
|
}
|
|
}
|
|
}
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function selectLink($val, $field) {
|
|
}
|
|
|
|
function selectVal($val, $link, $field, $original) {
|
|
$return = $val;
|
|
$link = h($link);
|
|
if (preg_match('~blob|bytea~', $field["type"]) && !is_utf8($val)) {
|
|
$return = lang('%d byte(s)', strlen($original));
|
|
if (preg_match("~^(GIF|\xFF\xD8\xFF|\x89PNG\x0D\x0A\x1A\x0A)~", $original)) { // GIF|JPG|PNG, getimagetype() works with filename
|
|
$return = "<img src='$link' alt='$return'>";
|
|
}
|
|
}
|
|
if (like_bool($field) && $return != "") { // bool
|
|
$return = (preg_match('~^(1|t|true|y|yes|on)$~i', $val) ? lang('yes') : lang('no'));
|
|
}
|
|
if ($link) {
|
|
$return = "<a href='$link'" . (is_url($link) ? target_blank() : "") . ">$return</a>";
|
|
}
|
|
// Firefox doesn't support <colgroup>
|
|
if (preg_match('~date~', $field["type"])) {
|
|
$return = "<div class='datetime'>$return</div>";
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function editVal($val, $field) {
|
|
if (preg_match('~date|timestamp~', $field["type"]) && $val !== null) {
|
|
return preg_replace('~^(\d{2}(\d+))-(0?(\d+))-(0?(\d+))~', lang('$1-$3-$5'), $val);
|
|
}
|
|
return $val;
|
|
}
|
|
|
|
function config() {
|
|
return array();
|
|
}
|
|
|
|
function selectColumnsPrint($select, $columns) {
|
|
// can allow grouping functions by indexes
|
|
}
|
|
|
|
function selectSearchPrint($where, $columns, $indexes) {
|
|
$where = (array) $_GET["where"];
|
|
echo '<fieldset id="fieldset-search"><legend>' . lang('Search') . "</legend><div>\n";
|
|
$keys = array();
|
|
foreach ($where as $key => $val) {
|
|
$keys[$val["col"]] = $key;
|
|
}
|
|
$i = 0;
|
|
$fields = fields($_GET["select"]);
|
|
foreach ($columns as $name => $desc) {
|
|
$field = $fields[$name];
|
|
if (preg_match("~enum~", $field["type"]) || like_bool($field)) { //! set - uses 1 << $i and FIND_IN_SET()
|
|
$key = $keys[$name];
|
|
$i--;
|
|
echo "<div>" . h($desc) . ":" . input_hidden("where[$i][col]", $name);
|
|
$val = idx($where[$key], "val");
|
|
echo (like_bool($field)
|
|
? "<select name='where[$i][val]'>" . optionlist(array("" => "", lang('no'), lang('yes')), $val, true) . "</select>"
|
|
: enum_input("checkbox", " name='where[$i][val][]'", $field, (array) $val, ($field["null"] ? 0 : null))
|
|
);
|
|
echo "</div>\n";
|
|
unset($columns[$name]);
|
|
} elseif (is_array($options = $this->foreignKeyOptions($_GET["select"], $name))) {
|
|
if ($fields[$name]["null"]) {
|
|
$options[0] = '(' . lang('empty') . ')';
|
|
}
|
|
$key = $keys[$name];
|
|
$i--;
|
|
echo "<div>" . h($desc) . input_hidden("where[$i][col]", $name) . input_hidden("where[$i][op]", "=") . ": <select name='where[$i][val]'>" . optionlist($options, idx($where[$key], "val"), true) . "</select></div>\n";
|
|
unset($columns[$name]);
|
|
}
|
|
}
|
|
$i = 0;
|
|
foreach ($where as $val) {
|
|
if (($val["col"] == "" || $columns[$val["col"]]) && "$val[col]$val[val]" != "") {
|
|
echo "<div><select name='where[$i][col]'><option value=''>(" . lang('anywhere') . ")" . optionlist($columns, $val["col"], true) . "</select>";
|
|
echo html_select("where[$i][op]", array(-1 => "") + adminer()->operators(), $val["op"]);
|
|
echo "<input type='search' name='where[$i][val]' value='" . h($val["val"]) . "'>" . script("mixin(qsl('input'), {onkeydown: selectSearchKeydown, onsearch: selectSearchSearch});", "") . "</div>\n";
|
|
$i++;
|
|
}
|
|
}
|
|
echo "<div><select name='where[$i][col]'><option value=''>(" . lang('anywhere') . ")" . optionlist($columns, null, true) . "</select>";
|
|
echo script("qsl('select').onchange = selectAddRow;", "");
|
|
echo html_select("where[$i][op]", array(-1 => "") + adminer()->operators());
|
|
echo "<input type='search' name='where[$i][val]'></div>";
|
|
echo script("mixin(qsl('input'), {onchange: function () { this.parentNode.firstChild.onchange(); }, onsearch: selectSearchSearch});");
|
|
echo "</div></fieldset>\n";
|
|
}
|
|
|
|
function selectOrderPrint($order, $columns, $indexes) {
|
|
//! desc
|
|
$orders = array();
|
|
foreach ($indexes as $key => $index) {
|
|
$order = array();
|
|
foreach ($index["columns"] as $val) {
|
|
$order[] = $columns[$val];
|
|
}
|
|
if (count(array_filter($order, 'strlen')) > 1 && $key != "PRIMARY") {
|
|
$orders[$key] = implode(", ", $order);
|
|
}
|
|
}
|
|
if ($orders) {
|
|
echo '<fieldset><legend>' . lang('Sort') . "</legend><div>";
|
|
echo "<select name='index_order'>" . optionlist(array("" => "") + $orders, (idx($_GET["order"], 0) != "" ? "" : $_GET["index_order"]), true) . "</select>";
|
|
echo "</div></fieldset>\n";
|
|
}
|
|
if ($_GET["order"]) {
|
|
echo "<div style='display: none;'>" . hidden_fields(array(
|
|
"order" => array(1 => reset($_GET["order"])),
|
|
"desc" => ($_GET["desc"] ? array(1 => 1) : array()),
|
|
)) . "</div>\n";
|
|
}
|
|
}
|
|
|
|
function selectLimitPrint($limit) {
|
|
echo "<fieldset><legend>" . lang('Limit') . "</legend><div>"; // <div> for easy styling
|
|
echo html_select("limit", array("", 50, 100), $limit);
|
|
echo "</div></fieldset>\n";
|
|
}
|
|
|
|
function selectLengthPrint($text_length) {
|
|
}
|
|
|
|
function selectActionPrint($indexes) {
|
|
echo "<fieldset><legend>" . lang('Action') . "</legend><div>";
|
|
echo "<input type='submit' value='" . lang('Select') . "'>";
|
|
echo "</div></fieldset>\n";
|
|
}
|
|
|
|
function selectCommandPrint() {
|
|
return true;
|
|
}
|
|
|
|
function selectImportPrint() {
|
|
return true;
|
|
}
|
|
|
|
function selectEmailPrint($emailFields, $columns) {
|
|
}
|
|
|
|
function selectColumnsProcess($columns, $indexes) {
|
|
return array(array(), array());
|
|
}
|
|
|
|
function selectSearchProcess($fields, $indexes) {
|
|
$return = array();
|
|
foreach ((array) $_GET["where"] as $key => $where) {
|
|
$col = $where["col"];
|
|
$op = $where["op"];
|
|
$val = $where["val"];
|
|
if (($key >= 0 && $col != "") || $val != "") {
|
|
$conds = array();
|
|
foreach (($col != "" ? array($col => $fields[$col]) : $fields) as $name => $field) {
|
|
if ($col != "" || is_numeric($val) || !preg_match(number_type(), $field["type"])) {
|
|
$name = idf_escape($name);
|
|
if ($col != "" && $field["type"] == "enum") {
|
|
$conds[] = (in_array(0, $val) ? "$name IS NULL OR " : "") . "$name IN (" . implode(", ", array_map('Adminer\q', $val)) . ")";
|
|
} else {
|
|
$text_type = preg_match('~char|text|enum|set~', $field["type"]);
|
|
$value = adminer()->processInput($field, (!$op && $text_type && preg_match('~^[^%]+$~', $val) ? "%$val%" : $val));
|
|
$conds[] = driver()->convertSearch($name, $where, $field) . ($value == "NULL" ? " IS" . ($op == ">=" ? " NOT" : "") . " $value"
|
|
: (in_array($op, adminer()->operators()) || $op == "=" ? " $op $value"
|
|
: ($text_type ? " LIKE $value"
|
|
: " IN (" . ($value[0] == "'" ? str_replace(",", "', '", $value) : $value) . ")"
|
|
)));
|
|
if ($key < 0 && $val == "0") {
|
|
$conds[] = "$name IS NULL";
|
|
}
|
|
}
|
|
}
|
|
}
|
|
$return[] = ($conds ? "(" . implode(" OR ", $conds) . ")" : "1 = 0");
|
|
}
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function selectOrderProcess($fields, $indexes) {
|
|
$index_order = $_GET["index_order"];
|
|
if ($index_order != "") {
|
|
unset($_GET["order"][1]);
|
|
}
|
|
if ($_GET["order"]) {
|
|
return array(idf_escape(reset($_GET["order"])) . ($_GET["desc"] ? " DESC" : ""));
|
|
}
|
|
foreach (($index_order != "" ? array($indexes[$index_order]) : $indexes) as $index) {
|
|
if ($index_order != "" || $index["type"] == "INDEX") {
|
|
$has_desc = array_filter($index["descs"]);
|
|
$desc = false;
|
|
foreach ($index["columns"] as $val) {
|
|
if (preg_match('~date|timestamp~', $fields[$val]["type"])) {
|
|
$desc = true;
|
|
break;
|
|
}
|
|
}
|
|
$return = array();
|
|
foreach ($index["columns"] as $key => $val) {
|
|
$return[] = idf_escape($val) . (($has_desc ? $index["descs"][$key] : $desc) ? " DESC" : "");
|
|
}
|
|
return $return;
|
|
}
|
|
}
|
|
return array();
|
|
}
|
|
|
|
function selectLimitProcess() {
|
|
return (isset($_GET["limit"]) ? intval($_GET["limit"]) : 50);
|
|
}
|
|
|
|
function selectLengthProcess() {
|
|
return "100";
|
|
}
|
|
|
|
function selectEmailProcess($where, $foreignKeys) {
|
|
return false;
|
|
}
|
|
|
|
function selectQueryBuild($select, $where, $group, $order, $limit, $page) {
|
|
return "";
|
|
}
|
|
|
|
function messageQuery($query, $time, $failed = false) {
|
|
return " <span class='time'>" . @date("H:i:s") . "</span><!--\n" . str_replace("--", "--><!-- ", $query) . "\n" . ($time ? "($time)\n" : "") . "-->";
|
|
}
|
|
|
|
function editRowPrint($table, $fields, $row, $update) {
|
|
}
|
|
|
|
function editFunctions($field) {
|
|
$return = array();
|
|
if ($field["null"] && preg_match('~blob~', $field["type"])) {
|
|
$return["NULL"] = lang('empty');
|
|
}
|
|
$return[""] = ($field["null"] || $field["auto_increment"] || like_bool($field) ? "" : "*");
|
|
//! respect driver
|
|
if (preg_match('~date|time~', $field["type"])) {
|
|
$return["now"] = lang('now');
|
|
}
|
|
if (preg_match('~_(md5|sha1)$~i', $field["field"], $match)) {
|
|
$return[] = strtolower($match[1]);
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function editInput($table, $field, $attrs, $value) {
|
|
if ($field["type"] == "enum") {
|
|
return (isset($_GET["select"]) ? "<label><input type='radio'$attrs value='-1' checked><i>" . lang('original') . "</i></label> " : "")
|
|
. enum_input("radio", $attrs, $field, ($value || isset($_GET["select"]) ? $value : ""), ($field["null"] ? "" : null))
|
|
;
|
|
}
|
|
$options = $this->foreignKeyOptions($table, $field["field"], $value);
|
|
if ($options !== null) {
|
|
return (is_array($options)
|
|
? "<select$attrs>" . optionlist($options, $value, true) . "</select>"
|
|
: "<input value='" . h($value) . "'$attrs class='hidden'>"
|
|
. "<input value='" . h($options) . "' class='jsonly'>"
|
|
. "<div></div>"
|
|
. script("qsl('input').oninput = partial(whisper, '" . ME . "script=complete&source=" . urlencode($table) . "&field=" . urlencode($field["field"]) . "&value='); qsl('div').onclick = whisperClick;", "")
|
|
);
|
|
}
|
|
if (like_bool($field)) {
|
|
return '<input type="checkbox" value="1"' . (preg_match('~^(1|t|true|y|yes|on)$~i', $value) ? ' checked' : '') . "$attrs>";
|
|
}
|
|
$hint = "";
|
|
if (preg_match('~time~', $field["type"])) {
|
|
$hint = lang('HH:MM:SS');
|
|
}
|
|
if (preg_match('~date|timestamp~', $field["type"])) {
|
|
$hint = lang('[yyyy]-mm-dd') . ($hint ? " [$hint]" : "");
|
|
}
|
|
if ($hint) {
|
|
return "<input value='" . h($value) . "'$attrs> ($hint)"; //! maxlength
|
|
}
|
|
if (preg_match('~_(md5|sha1)$~i', $field["field"])) {
|
|
return "<input type='password' value='" . h($value) . "'$attrs>";
|
|
}
|
|
return '';
|
|
}
|
|
|
|
function editHint($table, $field, $value) {
|
|
return (preg_match('~\s+(\[.*\])$~', ($field["comment"] != "" ? $field["comment"] : $field["field"]), $match) ? h(" $match[1]") : '');
|
|
}
|
|
|
|
function processInput($field, $value, $function = "") {
|
|
if ($function == "now") {
|
|
return "$function()";
|
|
}
|
|
$return = $value;
|
|
if (preg_match('~date|timestamp~', $field["type"]) && preg_match('(^' . str_replace('\$1', '(?P<p1>\d*)', preg_replace('~(\\\\\\$([2-6]))~', '(?P<p\2>\d{1,2})', preg_quote(lang('$1-$3-$5')))) . '(.*))', $value, $match)) {
|
|
$return = ($match["p1"] != "" ? $match["p1"] : ($match["p2"] != "" ? ($match["p2"] < 70 ? 20 : 19) . $match["p2"] : gmdate("Y"))) . "-$match[p3]$match[p4]-$match[p5]$match[p6]" . end($match);
|
|
}
|
|
$return = q($return);
|
|
if ($value == "" && like_bool($field)) {
|
|
$return = "'0'";
|
|
} elseif ($value == "" && ($field["null"] || !preg_match('~char|text~', $field["type"]))) {
|
|
$return = "NULL";
|
|
} elseif (preg_match('~^(md5|sha1)$~', $function)) {
|
|
$return = "$function($return)";
|
|
}
|
|
return unconvert_field($field, $return);
|
|
}
|
|
|
|
function dumpOutput() {
|
|
return array();
|
|
}
|
|
|
|
function dumpFormat() {
|
|
return array('csv' => 'CSV,', 'csv;' => 'CSV;', 'tsv' => 'TSV');
|
|
}
|
|
|
|
function dumpDatabase($db) {
|
|
}
|
|
|
|
function dumpTable($table, $style, $is_view = 0) {
|
|
echo "\xef\xbb\xbf"; // UTF-8 byte order mark
|
|
}
|
|
|
|
function dumpData($table, $style, $query) {
|
|
$result = connection()->query($query, 1); // 1 - MYSQLI_USE_RESULT
|
|
if ($result) {
|
|
while ($row = $result->fetch_assoc()) {
|
|
if ($style == "table") {
|
|
dump_csv(array_keys($row));
|
|
$style = "INSERT";
|
|
}
|
|
dump_csv($row);
|
|
}
|
|
}
|
|
}
|
|
|
|
function dumpFilename($identifier) {
|
|
return friendly_url($identifier);
|
|
}
|
|
|
|
function dumpHeaders($identifier, $multi_table = false) {
|
|
$ext = "csv";
|
|
header("Content-Type: text/csv; charset=utf-8");
|
|
return $ext;
|
|
}
|
|
|
|
function dumpFooter() {
|
|
}
|
|
|
|
function importServerPath() {
|
|
}
|
|
|
|
function homepage() {
|
|
return true;
|
|
}
|
|
|
|
function navigation($missing) {
|
|
echo "<h1>" . adminer()->name() . " <span class='version'>" . VERSION;
|
|
$new_version = $_COOKIE["adminer_version"];
|
|
echo " <a href='https://www.adminer.org/editor/#download'" . target_blank() . " id='version'>" . (version_compare(VERSION, $new_version) < 0 ? h($new_version) : "") . "</a>";
|
|
echo "</span></h1>\n";
|
|
switch_lang();
|
|
if ($missing == "auth") {
|
|
$first = true;
|
|
foreach ((array) $_SESSION["pwds"] as $vendor => $servers) {
|
|
foreach ($servers[""] as $username => $password) {
|
|
if ($password !== null) {
|
|
if ($first) {
|
|
echo "<ul id='logins'>";
|
|
echo script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");
|
|
$first = false;
|
|
}
|
|
echo "<li><a href='" . h(auth_url($vendor, "", $username)) . "'>" . ($username != "" ? h($username) : "<i>" . lang('empty') . "</i>") . "</a>\n";
|
|
}
|
|
}
|
|
}
|
|
} else {
|
|
adminer()->databasesPrint($missing);
|
|
if ($missing != "db" && $missing != "ns") {
|
|
$table_status = table_status('', true);
|
|
if (!$table_status) {
|
|
echo "<p class='message'>" . lang('No tables.') . "\n";
|
|
} else {
|
|
adminer()->tablesPrint($table_status);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
function syntaxHighlighting($tables) {
|
|
}
|
|
|
|
function databasesPrint($missing) {
|
|
}
|
|
|
|
function tablesPrint($tables) {
|
|
echo "<ul id='tables'>";
|
|
echo script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");
|
|
foreach ($tables as $row) {
|
|
echo '<li>';
|
|
$name = adminer()->tableName($row);
|
|
if ($name != "") { // ignore tables without name
|
|
echo "<a href='" . h(ME) . 'select=' . urlencode($row["Name"]) . "'"
|
|
. bold($_GET["select"] == $row["Name"] || $_GET["edit"] == $row["Name"], "select")
|
|
. " title='" . lang('Select data') . "'>$name</a>\n"
|
|
;
|
|
}
|
|
}
|
|
echo "</ul>\n";
|
|
}
|
|
|
|
function _foreignColumn($foreignKeys, $column) {
|
|
foreach ((array) $foreignKeys[$column] as $foreignKey) {
|
|
if (count($foreignKey["source"]) == 1) {
|
|
$name = adminer()->rowDescription($foreignKey["table"]);
|
|
if ($name != "") {
|
|
$id = idf_escape($foreignKey["target"][0]);
|
|
return array($foreignKey["table"], $id, $name);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
private function foreignKeyOptions($table, $column, $value = null) {
|
|
if (list($target, $id, $name) = $this->_foreignColumn(column_foreign_keys($table), $column)) {
|
|
$return = &$this->values[$target];
|
|
if ($return === null) {
|
|
$table_status = table_status1($target);
|
|
$return = ($table_status["Rows"] > 1000 ? "" : array("" => "") + get_key_vals("SELECT $id, $name FROM " . table($target) . " ORDER BY 2"));
|
|
}
|
|
if (!$return && $value !== null) {
|
|
return get_val("SELECT $name FROM " . table($target) . " WHERE $id = " . q($value));
|
|
}
|
|
return $return;
|
|
}
|
|
}
|
|
}
|