") { global $connection; if (!is_object($connection2)) { $connection2 = $connection; } $return = array(); $result = $connection2->query($query); if (is_object($result)) { // can return true while ($row = $result->fetch_assoc()) { $return[] = $row; } } elseif (!$result && $error && (headers_sent() || ob_get_level())) { echo $error . error() . "\n"; } return $return; } /** Find unique identifier of a row * @param array * @param array result of indexes() * @return array */ function unique_array($row, $indexes) { foreach ($indexes as $index) { if (ereg("PRIMARY|UNIQUE", $index["type"])) { $return = array(); foreach ($index["columns"] as $key) { if (!isset($row[$key])) { // NULL is ambiguous continue 2; } $return[$key] = $row[$key]; } return $return; } } $return = array(); foreach ($row as $key => $val) { if (!preg_match('~^(COUNT\\((\\*|(DISTINCT )?`(?:[^`]|``)+`)\\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\\(`(?:[^`]|``)+`\\))$~', $key)) { //! columns looking like functions $return[$key] = $val; } } return $return; } /** Create SQL condition from parsed query string * @param array parsed query string * @return string */ function where($where) { global $jush; $return = array(); foreach ((array) $where["where"] as $key => $val) { $return[] = idf_escape(bracket_escape($key, 1)) // 1 - back . (ereg('\\.', $val) || $jush == "mssql" ? " LIKE " . exact_value(addcslashes($val, "%_")) : " = " . exact_value($val)) // LIKE because of floats, but slow with ints, in MS SQL because of text ; //! enum and set } foreach ((array) $where["null"] as $key) { $return[] = idf_escape($key) . " IS NULL"; } return implode(" AND ", $return); } /** Create SQL condition from query string * @param string * @return string */ function where_check($val) { parse_str($val, $check); remove_slashes(array(&$check)); return where($check); } /** Create query string where condition from value * @param int condition order * @param string column identifier * @param string * @return string * @return string */ function where_link($i, $column, $value, $operator = "=") { return "&where%5B$i%5D%5Bcol%5D=" . urlencode($column) . "&where%5B$i%5D%5Bop%5D=" . urlencode($operator) . "&where%5B$i%5D%5Bval%5D=" . urlencode($value); } /** Set cookie valid for 1 month * @param string * @param string * @return bool */ function cookie($name, $value) { global $HTTPS; $params = array( $name, (ereg("\n", $value) ? "" : $value), // HTTP Response Splitting protection in PHP < 5.1.2 time() + 2592000, // 2592000 - 30 days preg_replace('~\\?.*~', '', $_SERVER["REQUEST_URI"]), "", $HTTPS ); if (version_compare(PHP_VERSION, '5.2.0') >= 0) { $params[] = true; // HttpOnly } return call_user_func_array('setcookie', $params); } /** Restart stopped session * @return null */ function restart_session() { if (!ini_bool("session.use_cookies")) { session_start(); } } /** Get session variable for current server * @param string * @return mixed */ function &get_session($key) { return $_SESSION[$key][DRIVER][SERVER][$_GET["username"]]; } /** Set session variable for current server * @param string * @param mixed * @return mixed */ function set_session($key, $val) { $_SESSION[$key][DRIVER][SERVER][$_GET["username"]] = $val; // used also in auth.inc.php } /** Get authenticated URL * @param string * @param string * @param string * @return string */ function auth_url($driver, $server, $username) { global $drivers; preg_match('~([^?]*)\\??(.*)~', remove_from_uri(implode("|", array_keys($drivers)) . "|username|" . session_name()), $match); return "$match[1]?" . (SID && !$_COOKIE ? SID . "&" : "") . ($driver != "server" || $server != "" ? urlencode($driver) . "=" . urlencode($server) . "&" : "") . "username=" . urlencode($username) . ($match[2] ? "&$match[2]" : "") ; } /** Send Location header and exit * @param string null to only set a message * @param string * @return null */ function redirect($location, $message = null) { if (isset($message)) { restart_session(); $_SESSION["messages"][] = $message; } if (isset($location)) { header("Location: " . ($location != "" ? $location : ".")); exit; } } /** Execute query and redirect if successful * @param string * @param string * @param string * @param bool * @param bool * @param bool * @return bool */ function query_redirect($query, $location, $message, $redirect = true, $execute = true, $failed = false) { global $connection, $error, $adminer; if ($execute) { $failed = !$connection->query($query); } $sql = ""; if ($query) { $sql = $adminer->messageQuery($query); } if ($failed) { $error = error() . $sql; return false; } if ($redirect) { redirect($location, $message . $sql); } return true; } /** Execute and remember query * @param string null to return remembered queries * @return Min_Result */ function queries($query = null) { global $connection; static $queries = array(); if (!isset($query)) { // return executed queries without parameter return implode(";\n", $queries); } $queries[] = $query; return $connection->query($query); } /** Apply command to all array items * @param string * @param array * @param callback * @return bool */ function apply_queries($query, $tables, $escape = 'table') { foreach ($tables as $table) { if (!queries("$query " . $escape($table))) { return false; } } return true; } /** Redirect by remembered queries * @param string * @param string * @param bool * @return bool */ function queries_redirect($location, $message, $redirect) { return query_redirect(queries(), $location, $message, $redirect, false, !$redirect); } /** Remove parameter from query string * @param string * @return string */ function remove_from_uri($param = "") { return substr(preg_replace("~(?<=[?&])($param" . (SID ? "" : "|" . session_name()) . ")=[^&]*&~", '', "$_SERVER[REQUEST_URI]&"), 0, -1); } /** Generate page number for pagination * @param int * @return string */ function pagination($page, $current) { return " " . ($page == $current ? $page + 1 : '' . ($page + 1) . ""); } /** Get file contents from $_FILES * @param string * @param bool * @return mixed int for error, string otherwise */ function get_file($key, $decompress = false) { $file = $_FILES[$key]; if (!$file || $file["error"]) { return $file["error"]; } return file_get_contents($decompress && ereg('\\.gz$', $file["name"]) ? "compress.zlib://$file[tmp_name]" : ($decompress && ereg('\\.bz2$', $file["name"]) ? "compress.bzip2://$file[tmp_name]" : $file["tmp_name"] )); //! may not be reachable because of open_basedir } /** Determine upload error * @param int * @return string */ function upload_error($error) { $max_size = ($error == UPLOAD_ERR_INI_SIZE ? ini_get("upload_max_filesize") : null); // post_max_size is checked in index.php return ($error ? lang('Unable to upload a file.') . ($max_size ? " " . lang('Maximum allowed file size is %sB.', $max_size) : "") : lang('File does not exist.')); } /** Generate class for odd rows * @param string return this for odd rows, empty to reset counter * @return string */ function odd($return = ' class="odd"') { static $i = 0; if (!$return) { // reset counter $i = -1; } return ($i++ % 2 ? $return : ''); } /** Check whether the string is in UTF-8 * @param string * @return bool */ function is_utf8($val) { // don't print control chars except \t\r\n return (preg_match('~~u', $val) && !preg_match('~[\\0-\\x8\\xB\\xC\\xE-\\x1F]~', $val)); } /** Shorten UTF-8 string * @param string * @param int * @param string * @return string escaped string with appended ... */ function shorten_utf8($string, $length = 80, $suffix = "") { if (!preg_match("(^([\t\r\n -\x{FFFF}]{0,$length})($)?)u", $string, $match)) { // ~s causes trash in $match[2] under some PHP versions, (.|\n) is slow preg_match("(^([\t\r\n -~]{0,$length})($)?)", $string, $match); } return h($match[1]) . $suffix . (isset($match[2]) ? "" : "..."); } /** Generate friendly URL * @param string * @return string */ function friendly_url($val) { // used for blobs and export return preg_replace('~[^a-z0-9_]~i', '-', $val); } /** Print hidden fields * @param array * @param array * @return null */ function hidden_fields($process, $ignore = array()) { while (list($key, $val) = each($process)) { if (is_array($val)) { foreach ($val as $k => $v) { $process[$key . "[$k]"] = $v; } } elseif (!in_array($key, $ignore)) { echo ''; } } } /** Print hidden fields for GET forms * @return null */ function hidden_fields_get() { echo (SID && !$_COOKIE ? '' : ''); echo (SERVER !== null ? '' : ""); echo ''; } /** Find out foreign keys for each column * @param string * @return array array($col => array()) */ function column_foreign_keys($table) { $return = array(); foreach (foreign_keys($table) as $foreign_key) { foreach ($foreign_key["source"] as $val) { $return[$val][] = $foreign_key; } } return $return; } /** Print enum input field * @param string "radio"|"checkbox" * @param string * @param array * @param mixed int|string|array * @return null */ function enum_input($type, $attrs, $field, $value) { preg_match_all("~'((?:[^']|'')*)'~", $field["length"], $matches); foreach ($matches[1] as $i => $val) { $val = stripcslashes(str_replace("''", "'", $val)); $checked = (is_int($value) ? $value == $i+1 : (is_array($value) ? in_array($i+1, $value) : $value === $val)); echo " '; } } /** Print edit input field * @param array one field from fields() * @param mixed * @param string * @return null */ function input($field, $value, $function) { global $types, $adminer, $jush; $name = h(bracket_escape($field["field"])); echo "