", "<=", ">=", "!=", "LIKE", "REGEXP", "IN", "IS NULL", "NOT LIKE", "NOT REGEXP", "NOT IN", "IS NOT NULL"); /** Name in title and navigation * @return string */ function name() { return lang('Adminer'); } /** Connection parameters * @return array ($server, $username, $password) */ function credentials() { return array($_GET["server"], $_SESSION["usernames"][$_GET["server"]], $_SESSION["passwords"][$_GET["server"]]); } /** Identifier of selected database * @return string */ function database() { // should be used everywhere instead of $_GET["db"] return $_GET["db"]; } /** Print login form * @param string * @return null */ function loginForm($username) { ?>
">
' . htmlspecialchars($field["field"]) . ''; } /** Links after select heading * @param array result of SHOW TABLE STATUS * @return string */ function selectLinks($tableStatus) { global $SELF; return '' . lang('Table structure') . ''; } /** Find backward keys for table * @param string * @return array $return[$target_table][$key_name][$target_column] = $source_column; */ function backwardKeys($table) { return array(); } /** Query printed in select before execution * @param string query to be executed * @return string */ function selectQuery($query) { global $SELF; // it would be nice if $query can be passed by reference and printed value would be returned but call_user() doesn't allow reference parameters return "

" . htmlspecialchars($query) . " " . lang('Edit') . "\n"; } /** Description of a row in a table * @param string * @return string SQL expression, empty string for no description */ function rowDescription($table) { return ""; } /** Get descriptions of selected data * @param array all data to print * @param array * @return array */ function rowDescriptions($rows, $foreignKeys) { return $rows; } /** Value printed in select table * @param string HTML-escaped value to print * @param string link to foreign key * @param array single field returned from fields() * @return string */ function selectVal($val, $link, $field) { $return = ($field["type"] == "char" ? "$val" : $val); if (ereg('blob|binary', $field["type"]) && !is_utf8($val)) { $return = lang('%d byte(s)', strlen($val)); } return ($link ? "$return" : $return); } /** Value conversion used in select and edit * @param string * @param array single field returned from fields() * @return string */ function editVal($val, $field) { return $val; } /** Print columns box in select * @param array result of selectColumnsProcess() * @param array selectable columns * @return null */ function selectColumnsPrint($select, $columns) { echo '

' . lang('Select') . "
\n"; } /** Print search box in select * @param array result of selectSearchProcess() * @param array selectable columns * @param array * @return null */ function selectSearchPrint($where, $columns, $indexes) { echo '
' . lang('Search') . "
\n"; } /** Print order box in select * @param array result of selectOrderProcess() * @param array selectable columns * @param array * @return null */ function selectOrderPrint($order, $columns, $indexes) { echo '
' . lang('Sort') . "
\n"; } /** Print limit box in select * @param string result of selectLimitProcess() * @return null */ function selectLimitPrint($limit) { echo "
" . lang('Limit') . "
"; //
for easy styling echo ""; echo "
\n"; } /** Print text length box in select * @param string result of selectLengthProcess() * @return null */ function selectLengthPrint($text_length) { if (isset($text_length)) { echo "
" . lang('Text length') . "
"; echo ''; echo "
\n"; } } /** Print action box in select * @return null */ function selectActionPrint() { echo "
" . lang('Action') . "
"; echo ""; echo "
\n"; } /** Process columns box in select * @param array selectable columns * @return array (array(select_expressions), array(group_expressions)) */ function selectColumnsProcess($columns, $indexes) { $select = array(); // select expressions, empty for * $group = array(); // expressions without aggregation - will be used for GROUP BY if an aggregation function is used foreach ((array) $_GET["columns"] as $key => $val) { if ($val["fun"] == "count" || (isset($columns[$val["col"]]) && (!$val["fun"] || in_array($val["fun"], $this->functions) || in_array($val["fun"], $this->grouping)))) { $select[$key] = apply_sql_function($val["fun"], (isset($columns[$val["col"]]) ? idf_escape($val["col"]) : "*")); if (!in_array($val["fun"], $this->grouping)) { $group[] = $select[$key]; } } } return array($select, $group); } /** Process search box in select * @param array * @param array * @return array expressions to join by AND */ function selectSearchProcess($indexes, $fields) { global $dbh; $return = array(); foreach ($indexes as $i => $index) { if ($index["type"] == "FULLTEXT" && strlen($_GET["fulltext"][$i])) { $return[] = "MATCH (" . implode(", ", array_map('idf_escape', $index["columns"])) . ") AGAINST (" . $dbh->quote($_GET["fulltext"][$i]) . (isset($_GET["boolean"][$i]) ? " IN BOOLEAN MODE" : "") . ")"; } } foreach ((array) $_GET["where"] as $val) { if (strlen("$val[col]$val[val]") && in_array($val["op"], $this->operators)) { if ($val["op"] == "AGAINST") { $return[] = "MATCH (" . idf_escape($val["col"]) . ") AGAINST (" . $dbh->quote($val["val"]) . " IN BOOLEAN MODE)"; } else { $in = process_length($val["val"]); $cond = " $val[op]" . (ereg('NULL$', $val["op"]) ? "" : (ereg('IN$', $val["op"]) ? " (" . (strlen($in) ? $in : "NULL") . ")" : " " . $this->processInput($fields[$val["col"]], $val["val"]))); if (strlen($val["col"])) { $return[] = idf_escape($val["col"]) . $cond; } else { // find anywhere $cols = array(); foreach ($fields as $name => $field) { if (is_numeric($val["val"]) || !ereg('int|float|double|decimal', $field["type"])) { $cols[] = $name; } } $return[] = ($cols ? "(" . implode("$cond OR ", array_map('idf_escape', $cols)) . "$cond)" : "0"); } } } } return $return; } /** Process order box in select * @param array * @param array result of selectColumnsProcess() * @param array * @return array expressions to join by comma */ function selectOrderProcess($columns, $select, $indexes) { $return = array(); foreach ((array) $_GET["order"] as $key => $val) { if (isset($columns[$val]) || in_array($val, $select, true)) { $return[] = idf_escape($val) . (isset($_GET["desc"][$key]) ? " DESC" : ""); } } return $return; } /** Process limit box in select * @return string expression to use in LIMIT, will be escaped */ function selectLimitProcess() { return (isset($_GET["limit"]) ? $_GET["limit"] : "30"); } /** Process length box in select * @return string number of characters to shorten texts, will be escaped */ function selectLengthProcess() { return (isset($_GET["text_length"]) ? $_GET["text_length"] : "100"); } /** Print extra text in the end of a select form * @param array fields holding e-mails * @return null */ function selectExtraPrint($emailFields) { } /** Process extras in select form * @param array AND conditions * @return bool true if processed, false to process other parts of form */ function selectExtraProcess($where) { return false; } /** Query printed after execution in the message * @param string executed query * @return string */ function messageQuery($query) { global $SELF; $id = "sql-" . count($_SESSION["messages"]); $_SESSION["history"][$_GET["server"]][$_GET["db"]][] = $query; return " " . lang('SQL command') . "'; } /** Functions displayed in edit form * @param array single field from fields() * @return array */ function editFunctions($field) { $return = array(""); if (!isset($_GET["default"])) { if (ereg('char|date|time', $field["type"])) { $return = (ereg('char', $field["type"]) ? array("", "md5", "sha1", "password", "uuid") : array("", "now")); //! JavaScript for disabling maxlength } if (!isset($_GET["call"]) && (isset($_GET["select"]) || where($_GET))) { // relative functions if (ereg('int|float|double|decimal', $field["type"])) { $return = array("", "+", "-"); } if (ereg('date', $field["type"])) { $return[] = "+ interval"; $return[] = "- interval"; } if (ereg('time', $field["type"])) { $return[] = "addtime"; $return[] = "subtime"; } } } if ($field["null"] || isset($_GET["default"])) { array_unshift($return, "NULL"); } return (isset($_GET["select"]) ? array("orig" => lang('original')) : array()) + $return; } /** Get options to display edit field * @param string table name * @param array single field from fields() * @param string attributes to use inside the tag * @param string * @return string custom input field or empty string for default */ function editInput($table, $field, $attrs, $value) { return ''; } /** Process sent input * @param array single field from fields() * @param string * @param string * @return string expression to use in a query */ function processInput($field, $value, $function = "") { global $dbh; $name = $field["field"]; $return = $dbh->quote($value); if (ereg('^(now|uuid)$', $function)) { $return = "$function()"; } elseif (ereg('^[+-]$', $function)) { $return = idf_escape($name) . " $function $return"; } elseif (ereg('^[+-] interval$', $function)) { $return = idf_escape($name) . " $function " . (preg_match("~^([0-9]+|'[0-9.: -]') [A-Z_]+$~i", $value) ? $value : $return); } elseif (ereg('^(addtime|subtime)$', $function)) { $return = "$function(" . idf_escape($name) . ", $return)"; } elseif (ereg('^(md5|sha1|password)$', $function)) { $return = "$function($return)"; } elseif (ereg('date|time', $field["type"]) && $value == "CURRENT_TIMESTAMP") { $return = $value; } return $return; } /** Prints navigation after Adminer title * @param string can be "auth" if there is no database connection or "db" if there is no database selected * @return null */ function navigation($missing) { global $SELF, $dbh; if ($missing != "auth") { ob_flush(); flush(); $databases = get_databases(); ?>

"> ">

"> "> >

query("SHOW TABLES"); if (!$result->num_rows) { echo "

" . lang('No tables.') . "\n"; } else { echo "

\n"; while ($row = $result->fetch_row()) { echo '' . lang('select') . ' '; echo '' . $this->tableName(array("Name" => $row[0])) . "
\n"; //! Adminer::table_name may work with full table status } } $result->free(); echo '

' . lang('Create new table') . "\n"; } } } }