',$this->name(),' ',$ca,' ',(version_compare($ca,$_COOKIE["adminer_version"])<0?h($_COOKIE["adminer_version"]):""),'

",script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");$uc=false;}echo"
• ".($V!=""?h($V):"".lang(7)."")."\n";}}}}else{$this->databasesPrint($Wd);if($Wd!="db"&&$Wd!="ns"){$R=table_status('',true);if(!$R)echo"

  ".lang(9)."\n";else$this->tablesPrint($R);}}}function databasesPrint($Wd){}function tablesPrint($S){echo"

  ",script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($S as$I){echo'
  • ';$B=$this->tableName($I);if(isset($I["Engine"])&&$B!="")echo"$B\n";}echo"
  \n";}function _foreignColumn($Bc,$e){foreach((array)$Bc[$e]as$Ac){if(count($Ac["source"])==1){$B=$this->rowDescription($Ac["table"]);if($B!=""){$t=idf_escape($Ac["target"][0]);return array($Ac["table"],$t,$B);}}}}function _foreignKeyOptions($Q,$e,$Y=null){global$h;if(list($dg,$t,$B)=$this->_foreignColumn(column_foreign_keys($Q),$e)){$H=&$this->_values[$dg];if($H===null){$R=table_status($dg);$H=($R["Rows"]>1000?"":array(""=>"")+get_key_vals("SELECT $t, $B FROM ".table($dg)." ORDER BY 2"));}if(!$H&&$Y!==null)return$h->result("SELECT $B FROM ".table($dg)." WHERE $t = ".q($Y));return$H;}}}$b=(function_exists('adminer_object')?adminer_object():new Adminer);$Mb=array("server"=>"MySQL")+$Mb;if(!defined("DRIVER")){define("DRIVER","server");if(extension_loaded("mysqli")){class Min_DB extends MySQLi{var$extension="MySQLi";function __construct(){parent::init();}function connect($M="",$V="",$E="",$j=null,$Le=null,$If=null){global$b;mysqli_report(MYSQLI_REPORT_OFF);list($Wc,$Le)=explode(":",$M,2);$Pf=$b->connectSsl();if($Pf)$this->ssl_set($Pf['key'],$Pf['cert'],$Pf['ca'],'','');$H=@$this->real_connect(($M!=""?$Wc:ini_get("mysqli.default_host")),($M.$V!=""?$V:ini_get("mysqli.default_user")),($M.$V.$E!=""?$E:ini_get("mysqli.default_pw")),$j,(is_numeric($Le)?$Le:ini_get("mysqli.default_port")),(!is_numeric($Le)?$Le:$If),($Pf?64:0));$this->options(MYSQLI_OPT_LOCAL_INFILE,false);return$H;}function set_charset($Ra){if(parent::set_charset($Ra))return true;parent::set_charset('utf8');return$this->query("SET NAMES $Ra");}function result($F,$o=0){$G=$this->query($F);if(!$G)return false;$I=$G->fetch_array();return$I[$o];}function quote($P){return"'".$this->escape_string($P)."'";}}}elseif(extension_loaded("mysql")&&!((ini_bool("sql.safe_mode")||ini_bool("mysql.allow_local_infile"))&&extension_loaded("pdo_mysql"))){class Min_DB{var$extension="MySQL",$server_info,$affected_rows,$errno,$error,$_link,$_result;function connect($M,$V,$E){if(ini_bool("mysql.allow_local_infile")){$this->error=lang(59,"'mysql.allow_local_infile'","MySQLi","PDO_MySQL");return false;}$this->_link=@mysql_connect(($M!=""?$M:ini_get("mysql.default_host")),("$M$V"!=""?$V:ini_get("mysql.default_user")),("$M$V$E"!=""?$E:ini_get("mysql.default_password")),true,131072);if($this->_link)$this->server_info=mysql_get_server_info($this->_link);else$this->error=mysql_error();return(bool)$this->_link;}function set_charset($Ra){if(function_exists('mysql_set_charset')){if(mysql_set_charset($Ra,$this->_link))return true;mysql_set_charset('utf8',$this->_link);}return$this->query("SET NAMES $Ra");}function quote($P){return"'".mysql_real_escape_string($P,$this->_link)."'";}function select_db($j){return mysql_select_db($j,$this->_link);}function query($F,$Dg=false){$G=@($Dg?mysql_unbuffered_query($F,$this->_link):mysql_query($F,$this->_link));$this->error="";if(!$G){$this->errno=mysql_errno($this->_link);$this->error=mysql_error($this->_link);return false;}if($G===true){$this->affected_rows=mysql_affected_rows($this->_link);$this->info=mysql_info($this->_link);return true;}return new Min_Result($G);}function multi_query($F){return$this->_result=$this->query($F);}function store_result(){return$this->_result;}function next_result(){return false;}function result($F,$o=0){$G=$this->query($F);if(!$G||!$G->num_rows)return false;return mysql_result($G->_result,0,$o);}}class Min_Result{var$num_rows,$_result,$_offset=0;function __construct($G){$this->_result=$G;$this->num_rows=mysql_num_rows($G);}function fetch_assoc(){return mysql_fetch_assoc($this->_result);}function fetch_row(){return mysql_fetch_row($this->_result);}function fetch_field(){$H=mysql_fetch_field($this->_result,$this->_offset++);$H->orgtable=$H->table;$H->orgname=$H->name;$H->charsetnr=($H->blob?63:0);return$H;}function __destruct(){mysql_free_result($this->_result);}}}elseif(extension_loaded("pdo_mysql")){class Min_DB extends Min_PDO{var$extension="PDO_MySQL";function connect($M,$V,$E){global$b;$C=array(PDO::MYSQL_ATTR_LOCAL_INFILE=>false);$Pf=$b->connectSsl();if($Pf){if(!empty($Pf['key']))$C[PDO::MYSQL_ATTR_SSL_KEY]=$Pf['key'];if(!empty($Pf['cert']))$C[PDO::MYSQL_ATTR_SSL_CERT]=$Pf['cert'];if(!empty($Pf['ca']))$C[PDO::MYSQL_ATTR_SSL_CA]=$Pf['ca'];}$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\d)~',';port=\1',$M)),$V,$E,$C);return true;}function set_charset($Ra){$this->query("SET NAMES $Ra");}function select_db($j){return$this->query("USE ".idf_escape($j));}function query($F,$Dg=false){$this->pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,!$Dg);return parent::query($F,$Dg);}}}class Min_Driver extends Min_SQL{function insert($Q,$N){return($N?parent::insert($Q,$N):queries("INSERT INTO ".table($Q)." ()\nVALUES ()"));}function insertUpdate($Q,$J,$Pe){$f=array_keys(reset($J));$Oe="INSERT INTO ".table($Q)." (".implode(", ",$f).") VALUES\n";$Rg=array();foreach($f as$y)$Rg[$y]="$y = VALUES($y)";$Wf="\nON DUPLICATE KEY UPDATE ".implode(", ",$Rg);$Rg=array();$Cd=0;foreach($J as$N){$Y="(".implode(", ",$N).")";if($Rg&&(strlen($Oe)+$Cd+strlen($Y)+strlen($Wf)>1e6)){if(!queries($Oe.implode(",\n",$Rg).$Wf))return false;$Rg=array();$Cd=0;}$Rg[]=$Y;$Cd+=strlen($Y)+2;}return queries($Oe.implode(",\n",$Rg).$Wf);}function slowQuery($F,$kg){if(min_version('5.7.8','10.1.2')){if(preg_match('~MariaDB~',$this->_conn->server_info))return"SET STATEMENT max_statement_time=$kg FOR $F";elseif(preg_match('~^(SELECT\b)(.+)~is',$F,$A))return"$A[1] /*+ MAX_EXECUTION_TIME(".($kg*1000).") */ $A[2]";}}function convertSearch($u,$X,$o){return(preg_match('~char|text|enum|set~',$o["type"])&&!preg_match("~^utf8~",$o["collation"])&&preg_match('~[\x80-\xFF]~',$X['val'])?"CONVERT($u USING ".charset($this->_conn).")":$u);}function warnings(){$G=$this->_conn->query("SHOW WARNINGS");if($G&&$G->num_rows){ob_start();select($G);return ob_get_clean();}}function tableHelp($B){$Kd=preg_match('~MariaDB~',$this->_conn->server_info);if(information_schema(DB))return strtolower(($Kd?"information-schema-$B-table/":str_replace("_","-",$B)."-table.html"));if(DB=="mysql")return($Kd?"mysql$B-table/":"system-database.html");}}function idf_escape($u){return"`".str_replace("`","``",$u)."`";}function table($u){return idf_escape($u);}function connect(){global$b,$U,$Tf;$h=new Min_DB;$wb=$b->credentials();if($h->connect($wb[0],$wb[1],$wb[2])){$h->set_charset(charset($h));$h->query("SET sql_quote_show_create = 1, autocommit = 1");if(min_version('5.7.8',10.2,$h)){$Tf[lang(25)][]="json";$U["json"]=4294967295;}return$h;}$H=$h->error;if(function_exists('iconv')&&!is_utf8($H)&&strlen($rf=iconv("windows-1250","utf-8",$H))>strlen($H))$H=$rf;return$H;}function get_databases($yc){$H=get_session("dbs");if($H===null){$F=(min_version(5)?"SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME":"SHOW DATABASES");$H=($yc?slow_query($F):get_vals($F));restart_session();set_session("dbs",$H);stop_session();}return$H;}function limit($F,$Z,$z,$he=0,$L=" "){return" $F$Z".($z!==null?$L."LIMIT $z".($he?" OFFSET $he":""):"");}function limit1($Q,$F,$Z,$L="\n"){return limit($F,$Z,1,0,$L);}function db_collation($l,$bb){global$h;$H=null;$ub=$h->result("SHOW CREATE DATABASE ".idf_escape($l),1);if(preg_match('~ COLLATE ([^ ]+)~',$ub,$A))$H=$A[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$ub,$A))$H=$bb[$A[1]][-1];return$H;}function engines(){$H=array();foreach(get_rows("SHOW ENGINES")as$I){if(preg_match("~YES|DEFAULT~",$I["Support"]))$H[]=$I["Engine"];}return$H;}function logged_user(){global$h;return$h->result("SELECT USER()");}function tables_list(){return get_key_vals(min_version(5)?"SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME":"SHOW TABLES");}function count_tables($k){$H=array();foreach($k as$l)$H[$l]=count(get_vals("SHOW TABLES IN ".idf_escape($l)));return$H;}function table_status($B="",$nc=false){$H=array();foreach(get_rows($nc&&min_version(5)?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($B!=""?"AND TABLE_NAME = ".q($B):"ORDER BY Name"):"SHOW TABLE STATUS".($B!=""?" LIKE ".q(addcslashes($B,"%_\\")):""))as$I){if($I["Engine"]=="InnoDB")$I["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\1',$I["Comment"]);if(!isset($I["Engine"]))$I["Comment"]="";if($B!="")return$I;$H[$I["Name"]]=$I;}return$H;}function is_view($R){return$R["Engine"]===null;}function fk_support($R){return preg_match('~InnoDB|IBMDB2I~i',$R["Engine"])||(preg_match('~NDB~i',$R["Engine"])&&min_version(5.6));}function fields($Q){$H=array();foreach(get_rows("SHOW FULL COLUMNS FROM ".table($Q))as$I){preg_match('~^([^( ]+)(?:\((.+)\))?( unsigned)?( zerofill)?$~',$I["Type"],$A);$H[$I["Field"]]=array("field"=>$I["Field"],"full_type"=>$I["Type"],"type"=>$A[1],"length"=>$A[2],"unsigned"=>ltrim($A[3].$A[4]),"default"=>($I["Default"]!=""||preg_match("~char|set~",$A[1])?(preg_match('~text~',$A[1])?stripslashes(preg_replace("~^'(.*)'\$~",'\1',$I["Default"])):$I["Default"]):null),"null"=>($I["Null"]=="YES"),"auto_increment"=>($I["Extra"]=="auto_increment"),"on_update"=>(preg_match('~^on update (.+)~i',$I["Extra"],$A)?$A[1]:""),"collation"=>$I["Collation"],"privileges"=>array_flip(preg_split('~, *~',$I["Privileges"])),"comment"=>$I["Comment"],"primary"=>($I["Key"]=="PRI"),"generated"=>preg_match('~^(VIRTUAL|PERSISTENT|STORED)~',$I["Extra"]),);}return$H;}function indexes($Q,$i=null){$H=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$i)as$I){$B=$I["Key_name"];$H[$B]["type"]=($B=="PRIMARY"?"PRIMARY":($I["Index_type"]=="FULLTEXT"?"FULLTEXT":($I["Non_unique"]?($I["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$H[$B]["columns"][]=$I["Column_name"];$H[$B]["lengths"][]=($I["Index_type"]=="SPATIAL"?null:$I["Sub_part"]);$H[$B]["descs"][]=null;}return$H;}function foreign_keys($Q){global$h,$ke;static$He='(?:`(?:[^`]|``)+`|"(?:[^"]|"")+")';$H=array();$vb=$h->result("SHOW CREATE TABLE ".table($Q),1);if($vb){preg_match_all("~CONSTRAINT ($He) FOREIGN KEY ?\\(((?:$He,? ?)+)\\) REFERENCES ($He)(?:\\.($He))? \\(((?:$He,? ?)+)\\)(?: ON DELETE ($ke))?(?: ON UPDATE ($ke))?~",$vb,$Nd,PREG_SET_ORDER);foreach($Nd as$A){preg_match_all("~$He~",$A[2],$Kf);preg_match_all("~$He~",$A[5],$dg);$H[idf_unescape($A[1])]=array("db"=>idf_unescape($A[4]!=""?$A[3]:$A[4]),"table"=>idf_unescape($A[4]!=""?$A[4]:$A[3]),"source"=>array_map('idf_unescape',$Kf[0]),"target"=>array_map('idf_unescape',$dg[0]),"on_delete"=>($A[6]?$A[6]:"RESTRICT"),"on_update"=>($A[7]?$A[7]:"RESTRICT"),);}}return$H;}function view($B){global$h;return array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\s+AS\s+~isU','',$h->result("SHOW CREATE VIEW ".table($B),1)));}function collations(){$H=array();foreach(get_rows("SHOW COLLATION")as$I){if($I["Default"])$H[$I["Charset"]][-1]=$I["Collation"];else$H[$I["Charset"]][]=$I["Collation"];}ksort($H);foreach($H as$y=>$X)asort($H[$y]);return$H;}function information_schema($l){return(min_version(5)&&$l=="information_schema")||(min_version(5.5)&&$l=="performance_schema");}function error(){global$h;return h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",$h->error));}function create_database($l,$d){return queries("CREATE DATABASE ".idf_escape($l).($d?" COLLATE ".q($d):""));}function drop_databases($k){$H=apply_queries("DROP DATABASE",$k,'idf_escape');restart_session();set_session("dbs",null);return$H;}function rename_database($B,$d){$H=false;if(create_database($B,$d)){$S=array();$Vg=array();foreach(tables_list()as$Q=>$T){if($T=='VIEW')$Vg[]=$Q;else$S[]=$Q;}$H=(!$S&&!$Vg)||move_tables($S,$Vg,$B);drop_databases($H?array(DB):array());}return$H;}function auto_increment(){$Fa=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$v){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$v["columns"],true)){$Fa="";break;}if($v["type"]=="PRIMARY")$Fa=" UNIQUE";}}return" AUTO_INCREMENT$Fa";}function alter_table($Q,$B,$p,$_c,$gb,$Yb,$d,$Ea,$Ee){$c=array();foreach($p as$o)$c[]=($o[1]?($Q!=""?($o[0]!=""?"CHANGE ".idf_escape($o[0]):"ADD"):" ")." ".implode($o[1]).($Q!=""?$o[2]:""):"DROP ".idf_escape($o[0]));$c=array_merge($c,$_c);$O=($gb!==null?" COMMENT=".q($gb):"").($Yb?" ENGINE=".q($Yb):"").($d?" COLLATE ".q($d):"").($Ea!=""?" AUTO_INCREMENT=$Ea":"");if($Q=="")return queries("CREATE TABLE ".table($B)." (\n".implode(",\n",$c)."\n)$O$Ee");if($Q!=$B)$c[]="RENAME TO ".table($B);if($O)$c[]=ltrim($O);return($c||$Ee?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$c).$Ee):true);}function alter_indexes($Q,$c){foreach($c as$y=>$X)$c[$y]=($X[2]=="DROP"?"\nDROP INDEX ".idf_escape($X[1]):"\nADD $X[0] ".($X[0]=="PRIMARY"?"KEY ":"").($X[1]!=""?idf_escape($X[1])." ":"")."(".implode(", ",$X[2]).")");return queries("ALTER TABLE ".table($Q).implode(",",$c));}function truncate_tables($S){return apply_queries("TRUNCATE TABLE",$S);}function drop_views($Vg){return queries("DROP VIEW ".implode(", ",array_map('table',$Vg)));}function drop_tables($S){return queries("DROP TABLE ".implode(", ",array_map('table',$S)));}function move_tables($S,$Vg,$dg){global$h;$hf=array();foreach($S as$Q)$hf[]=table($Q)." TO ".idf_escape($dg).".".table($Q);if(!$hf||queries("RENAME TABLE ".implode(", ",$hf))){$Eb=array();foreach($Vg as$Q)$Eb[table($Q)]=view($Q);$h->select_db($dg);$l=idf_escape(DB);foreach($Eb as$B=>$Ug){if(!queries("CREATE VIEW $B AS ".str_replace(" $l."," ",$Ug["select"]))||!queries("DROP VIEW $l.$B"))return false;}return true;}return false;}function copy_tables($S,$Vg,$dg){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($S as$Q){$B=($dg==DB?table("copy_$Q"):idf_escape($dg).".".table($Q));if(($_POST["overwrite"]&&!queries("\nDROP TABLE IF EXISTS $B"))||!queries("CREATE TABLE $B LIKE ".table($Q))||!queries("INSERT INTO $B SELECT * FROM ".table($Q)))return false;foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$I){$zg=$I["Trigger"];if(!queries("CREATE TRIGGER ".($dg==DB?idf_escape("copy_$zg"):idf_escape($dg).".".idf_escape($zg))." $I[Timing] $I[Event] ON $B FOR EACH ROW\n$I[Statement];"))return false;}}foreach($Vg as$Q){$B=($dg==DB?table("copy_$Q"):idf_escape($dg).".".table($Q));$Ug=view($Q);if(($_POST["overwrite"]&&!queries("DROP VIEW IF EXISTS $B"))||!queries("CREATE VIEW $B AS $Ug[select]"))return false;}return true;}function trigger($B){if($B=="")return array();$J=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($B));return reset($J);}function triggers($Q){$H=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$I)$H[$I["Trigger"]]=array($I["Timing"],$I["Event"]);return$H;}function trigger_options(){return array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function routine($B,$T){global$h,$Zb,$kd,$U;$wa=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$Lf="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|-- )[^\n]*\n?|--\r?\n)";$Cg="((".implode("|",array_merge(array_keys($U),$wa)).")\\b(?:\\s*\\(((?:[^'\")]|$Zb)++)\\))?\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$He="$Lf*(".($T=="FUNCTION"?"":$kd).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$Cg";$ub=$h->result("SHOW CREATE $T ".idf_escape($B),2);preg_match("~\\(((?:$He\\s*,?)*)\\)\\s*".($T=="FUNCTION"?"RETURNS\\s+$Cg\\s+":"")."(.*)~is",$ub,$A);$p=array();preg_match_all("~$He\\s*,?~is",$A[1],$Nd,PREG_SET_ORDER);foreach($Nd as$Be)$p[]=array("field"=>str_replace("``","`",$Be[2]).$Be[3],"type"=>strtolower($Be[5]),"length"=>preg_replace_callback("~$Zb~s",'normalize_enum',$Be[6]),"unsigned"=>strtolower(preg_replace('~\s+~',' ',trim("$Be[8] $Be[7]"))),"null"=>1,"full_type"=>$Be[4],"inout"=>strtoupper($Be[1]),"collation"=>strtolower($Be[9]),);if($T!="FUNCTION")return array("fields"=>$p,"definition"=>$A[11]);return array("fields"=>$p,"returns"=>array("type"=>$A[12],"length"=>$A[13],"unsigned"=>$A[15],"collation"=>$A[16]),"definition"=>$A[17],"language"=>"SQL",);}function routines(){return get_rows("SELECT ROUTINE_NAME AS SPECIFIC_NAME, ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ".q(DB));}function routine_languages(){return array();}function routine_id($B,$I){return idf_escape($B);}function last_id(){global$h;return$h->result("SELECT LAST_INSERT_ID()");}function explain($h,$F){return$h->query("EXPLAIN ".(min_version(5.1)&&!min_version(5.7)?"PARTITIONS ":"").$F);}function found_rows($R,$Z){return($Z||$R["Engine"]!="InnoDB"?null:$R["Rows"]);}function types(){return array();}function schemas(){return array();}function get_schema(){return"";}function set_schema($sf,$i=null){return true;}function create_sql($Q,$Ea,$Uf){global$h;$H=$h->result("SHOW CREATE TABLE ".table($Q),1);if(!$Ea)$H=preg_replace('~ AUTO_INCREMENT=\d+~','',$H);return$H;}function truncate_sql($Q){return"TRUNCATE ".table($Q);}function use_sql($j){return"USE ".idf_escape($j);}function trigger_sql($Q){$H="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$I)$H.="\nCREATE TRIGGER ".idf_escape($I["Trigger"])." $I[Timing] $I[Event] ON ".table($I["Table"])." FOR EACH ROW\n$I[Statement];;\n";return$H;}function show_variables(){return get_key_vals("SHOW VARIABLES");}function process_list(){return get_rows("SHOW FULL PROCESSLIST");}function show_status(){return get_key_vals("SHOW STATUS");}function convert_field($o){if(preg_match("~binary~",$o["type"]))return"HEX(".idf_escape($o["field"]).")";if($o["type"]=="bit")return"BIN(".idf_escape($o["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$o["type"]))return(min_version(8)?"ST_":"")."AsWKT(".idf_escape($o["field"]).")";}function unconvert_field($o,$H){if(preg_match("~binary~",$o["type"]))$H="UNHEX($H)";if($o["type"]=="bit")$H="CONV($H, 2, 10) + 0";if(preg_match("~geometry|point|linestring|polygon~",$o["type"]))$H=(min_version(8)?"ST_":"")."GeomFromText($H, SRID($o[field]))";return$H;}function support($oc){return!preg_match("~scheme|sequence|type|view_trigger|materializedview".(min_version(8)?"":"|descidx".(min_version(5.1)?"":"|event|partitioning".(min_version(5)?"":"|routine|trigger|view")))."~",$oc);}function kill_process($X){return queries("KILL ".number($X));}function connection_id(){return"SELECT CONNECTION_ID()";}function max_connections(){global$h;return$h->result("SELECT @@max_connections");}function driver_config(){$U=array();$Tf=array();foreach(array(lang(27)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(28)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(25)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(60)=>array("enum"=>65535,"set"=>64),lang(29)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(31)=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),)as$y=>$X){$U+=$X;$Tf[$y]=array_keys($X);}return array('possible_drivers'=>array("MySQLi","MySQL","PDO_MySQL"),'jush'=>"sql",'types'=>$U,'structured_types'=>$Tf,'unsigned'=>array("unsigned","zerofill","unsigned zerofill"),'operators'=>array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","FIND_IN_SET","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL"),'functions'=>array("char_length","date","from_unixtime","lower","round","floor","ceil","sec_to_time","time_to_sec","upper"),'grouping'=>array("avg","count","count distinct","group_concat","max","min","sum"),'edit_functions'=>array(array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",),array(number_type()=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",)),);}}$jb=driver_config();$Ne=$jb['possible_drivers'];$x=$jb['jush'];$U=$jb['types'];$Tf=$jb['structured_types'];$Jg=$jb['unsigned'];$pe=$jb['operators'];$Ic=$jb['functions'];$Mc=$jb['grouping'];$Rb=$jb['edit_functions'];if($b->operators===null)$b->operators=$pe;define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~\?.*~','',relative_uri()).'?'.(sid()?SID.'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));$ca="4.8.1";function page_header($mg,$n="",$Pa=array(),$ng=""){global$ba,$ca,$b,$Mb,$x;page_headers();if(is_ajax()&&$n){page_messages($n);exit;}$og=$mg.($ng!=""?": $ng":"");$pg=strip_tags($og.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$b->name());echo' ',script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=4.8.1");if($b->head()){echo' ';foreach($b->css()as$yb){echo' ';}}echo' ';$q=get_temp_dir()."/adminer.version";if(!$_COOKIE["adminer_version"]&&function_exists('openssl_verify')&&file_exists($q)&&filemtime($q)+86400>time()){$Tg=unserialize(file_get_contents($q));$Ve="-----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwqWOVuF5uw7/+Z70djoK RlHIZFZPO0uYRezq90+7Amk+FDNd7KkL5eDve+vHRJBLAszF/7XKXe11xwliIsFs DFWQlsABVZB3oisKCBEuI71J4kPH8dKGEWR9jDHFw3cWmoH3PmqImX6FISWbG3B8 h7FIx3jEaw5ckVPVTeo5JRm/1DZzJxjyDenXvBQ/6o9DgZKeNDgxwKzH+sw9/YCO jHnq1cFpOIISzARlrHMa/43YfeNRAm/tsBXjSxembBPo7aQZLAWHmaj5+K19H10B nCpz9Y++cipkVEiKRGih4ZEvjoFysEOdRLj6WiD/uUNky4xGeA6LaJqh5XpkFkcQ fQIDAQAB -----END PUBLIC KEY----- ";if(openssl_verify($Tg["version"],base64_decode($Tg["signature"]),$Ve)==1)$_COOKIE["adminer_version"]=$Tg["version"];}echo' mixin(document.body, {onkeydown: bodyKeydown, onclick: bodyClick',(isset($_COOKIE["adminer_version"])?"":", onload: partial(verifyVersion, '$ca', '".js_escape(ME)."', '".get_token()."')");?>}); document.body.className = document.body.className.replace(/ nojs/, ' js'); var offlineMessage = '
  ',script("mixin(qs('#help'), {onmouseover: function () { helpOpen = 1; }, onmouseout: helpMouseout});"),'
  ';if($Pa!==null){$_=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'

  '.$Mb[DRIVER].' » ';$_=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$M=$b->serverName(SERVER);$M=($M!=""?$M:lang(63));if($Pa===false)echo"$M\n";else{echo"$M » ";if($_GET["ns"]!=""||(DB!=""&&is_array($Pa)))echo''.h(DB).' » ';if(is_array($Pa)){if($_GET["ns"]!="")echo''.h($_GET["ns"]).' » ';foreach($Pa as$y=>$X){$Fb=(is_array($X)?$X[1]:h($X));if($Fb!="")echo"$Fb » ";}}echo"$mg\n";}}echo"

  $og

  \n","

  \n";restart_session();page_messages($n);$k=&get_session("dbs");if(DB!=""&&$k&&!in_array(DB,$k,true))$k=null;stop_session();define("PAGE_HEADER",1);}function page_headers(){global$b;header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");header("X-Frame-Options: deny");header("X-XSS-Protection: 0");header("X-Content-Type-Options: nosniff");header("Referrer-Policy: origin-when-cross-origin");foreach($b->csp()as$xb){$Rc=array();foreach($xb as$y=>$X)$Rc[]="$y $X";header("Content-Security-Policy: ".implode("; ",$Rc));}$b->headers();}function csp(){return array(array("script-src"=>"'self' 'unsafe-inline' 'nonce-".get_nonce()."' 'strict-dynamic'","connect-src"=>"'self'","frame-src"=>"https://www.adminer.org","object-src"=>"'none'","base-uri"=>"'none'","form-action"=>"'self'",),);}function get_nonce(){static$de;if(!$de)$de=base64_encode(rand_string());return$de;}function page_messages($n){$Lg=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Ud=$_SESSION["messages"][$Lg];if($Ud){echo"

  ".implode("

  \n

  ",$Ud)."

  ".script("messagesPrint();");unset($_SESSION["messages"][$Lg]);}if($n)echo"

  $n

  \n";}function page_footer($Wd=""){global$b,$sg;echo'
  ';switch_lang();if($Wd!="auth"){echo'
  ';}echo'
  ';$b->navigation($Wd);echo'
  ',script("setupSubmitHighlight(document);");}function int32($Zd){while($Zd>=2147483648)$Zd-=4294967296;while($Zd<=-2147483649)$Zd+=4294967296;return(int)$Zd;}function long2str($W,$Xg){$rf='';foreach($W as$X)$rf.=pack('V',$X);if($Xg)return substr($rf,0,end($W));return$rf;}function str2long($rf,$Xg){$W=array_values(unpack('V*',str_pad($rf,4*ceil(strlen($rf)/4),"\0")));if($Xg)$W[]=strlen($rf);return$W;}function xxtea_mx($hh,$gh,$Xf,$sd){return int32((($hh>>5&0x7FFFFFF)^$gh<<2)+(($gh>>3&0x1FFFFFFF)^$hh<<4))^int32(($Xf^$gh)+($sd^$hh));}function encrypt_string($Sf,$y){if($Sf=="")return"";$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($Sf,true);$Zd=count($W)-1;$hh=$W[$Zd];$gh=$W[0];$We=floor(6+52/($Zd+1));$Xf=0;while($We-->0){$Xf=int32($Xf+0x9E3779B9);$Qb=$Xf>>2&3;for($_e=0;$_e<$Zd;$_e++){$gh=$W[$_e+1];$Yd=xxtea_mx($hh,$gh,$Xf,$y[$_e&3^$Qb]);$hh=int32($W[$_e]+$Yd);$W[$_e]=$hh;}$gh=$W[0];$Yd=xxtea_mx($hh,$gh,$Xf,$y[$_e&3^$Qb]);$hh=int32($W[$Zd]+$Yd);$W[$Zd]=$hh;}return long2str($W,false);}function decrypt_string($Sf,$y){if($Sf=="")return"";if(!$y)return false;$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($Sf,false);$Zd=count($W)-1;$hh=$W[$Zd];$gh=$W[0];$We=floor(6+52/($Zd+1));$Xf=int32($We*0x9E3779B9);while($Xf){$Qb=$Xf>>2&3;for($_e=$Zd;$_e>0;$_e--){$hh=$W[$_e-1];$Yd=xxtea_mx($hh,$gh,$Xf,$y[$_e&3^$Qb]);$gh=int32($W[$_e]-$Yd);$W[$_e]=$gh;}$hh=$W[$Zd];$Yd=xxtea_mx($hh,$gh,$Xf,$y[$_e&3^$Qb]);$gh=int32($W[0]-$Yd);$W[0]=$gh;$Xf=int32($Xf-0x9E3779B9);}return long2str($W,true);}$h='';$Qc=$_SESSION["token"];if(!$Qc)$_SESSION["token"]=rand(1,1e6);$sg=get_token();$Je=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($y)=explode(":",$X);$Je[$y]=$X;}}function add_invalid_login(){global$b;$Gc=file_open_lock(get_temp_dir()."/adminer.invalid");if(!$Gc)return;$nd=unserialize(stream_get_contents($Gc));$jg=time();if($nd){foreach($nd as$od=>$X){if($X[0]<$jg)unset($nd[$od]);}}$md=&$nd[$b->bruteForceKey()];if(!$md)$md=array($jg+30*60,0);$md[1]++;file_write_unlock($Gc,serialize($nd));}function check_invalid_login(){global$b;$nd=unserialize(@file_get_contents(get_temp_dir()."/adminer.invalid"));$md=($nd?$nd[$b->bruteForceKey()]:array());$ce=($md[1]>29?$md[0]-time():0);if($ce>0)auth_error(lang(65,ceil($ce/60)));}$Ca=$_POST["auth"];if($Ca){session_regenerate_id();$Sg=$Ca["driver"];$M=$Ca["server"];$V=$Ca["username"];$E=(string)$Ca["password"];$l=$Ca["db"];set_password($Sg,$M,$V,$E);$_SESSION["db"][$Sg][$M][$V][$l]=true;if($Ca["permanent"]){$y=base64_encode($Sg)."-".base64_encode($M)."-".base64_encode($V)."-".base64_encode($l);$Se=$b->permanentLogin(true);$Je[$y]="$y:".base64_encode($Se?encrypt_string($E,$Se):"");cookie("adminer_permanent",implode(" ",$Je));}if(count($_POST)==1||DRIVER!=$Sg||SERVER!=$M||$_GET["username"]!==$V||DB!=$l)redirect(auth_url($Sg,$M,$V,$l));}elseif($_POST["logout"]&&(!$Qc||verify_token())){foreach(array("pwds","db","dbs","queries")as$y)set_session($y,null);unset_permanent();redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),lang(66).' '.lang(67));}elseif($Je&&!$_SESSION["pwds"]){session_regenerate_id();$Se=$b->permanentLogin();foreach($Je as$y=>$X){list(,$Wa)=explode(":",$X);list($Sg,$M,$V,$l)=array_map('base64_decode',explode("-",$y));set_password($Sg,$M,$V,decrypt_string(base64_decode($Wa),$Se));$_SESSION["db"][$Sg][$M][$V][$l]=true;}}function unset_permanent(){global$Je;foreach($Je as$y=>$X){list($Sg,$M,$V,$l)=array_map('base64_decode',explode("-",$y));if($Sg==DRIVER&&$M==SERVER&&$V==$_GET["username"]&&$l==DB)unset($Je[$y]);}cookie("adminer_permanent",implode(" ",$Je));}function auth_error($n){global$b,$Qc;$Df=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$Df]||$_GET[$Df])&&!$Qc)$n=lang(68);else{restart_session();add_invalid_login();$E=get_password();if($E!==null){if($E===false)$n.=($n?'
  ':'').lang(69,target_blank(),'permanentLogin()');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent();}}if(!$_COOKIE[$Df]&&$_GET[$Df]&&ini_bool("session.use_only_cookies"))$n=lang(70);$Ce=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?$_COOKIE["adminer_key"]:rand_string()),$Ce["lifetime"]);page_header(lang(36),$n,null);echo"
  \n","

  ";if(hidden_fields($_POST,array("auth")))echo"

  ".lang(71)."\n";echo"

  \n";$b->loginForm();echo"
  \n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header(lang(72),lang(73,implode(", ",$Ne)),false);page_footer("auth");exit;}stop_session(true);if(isset($_GET["username"])&&is_string(get_password())){list($Wc,$Le)=explode(":",SERVER,2);if(preg_match('~^\s*([-+]?\d+)~',$Le,$A)&&($A[1]<1024||$A[1]>65535))auth_error(lang(74));check_invalid_login();$h=connect();$m=new Min_Driver($h);}$Hd=null;if(!is_object($h)||($Hd=$b->login($_GET["username"],get_password()))!==true){$n=(is_string($h)?h($h):(is_string($Hd)?$Hd:lang(32)));auth_error($n.(preg_match('~^ | $~',get_password())?'
  '.lang(75):''));}if($_POST["logout"]&&$Qc&&!verify_token()){page_header(lang(64),lang(76));page_footer("db");exit;}if($Ca&&$_POST["token"])$_POST["token"]=$sg;$n='';if($_POST){if(!verify_token()){$jd="max_input_vars";$Rd=ini_get($jd);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$y){$X=ini_get($y);if($X&&(!$Rd||$X<$Rd)){$jd=$y;$Rd=$X;}}}$n=(!$_POST["token"]&&$Rd?lang(77,"'$jd'"):lang(76).' '.lang(78));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$n=lang(79,"'post_max_size'");if(isset($_GET["sql"]))$n.=' '.lang(80);}function email_header($Rc){return"=?UTF-8?B?".base64_encode($Rc)."?=";}function send_mail($Ub,$Vf,$Td,$Hc="",$sc=array()){$ac=(DIRECTORY_SEPARATOR=="/"?"\n":"\r\n");$Td=str_replace("\n",$ac,wordwrap(str_replace("\r","","$Td\n")));$Oa=uniqid("boundary");$Aa="";foreach((array)$sc["error"]as$y=>$X){if(!$X)$Aa.="--$Oa$ac"."Content-Type: ".str_replace("\n","",$sc["type"][$y]).$ac."Content-Disposition: attachment; filename=\"".preg_replace('~["\n]~','',$sc["name"][$y])."\"$ac"."Content-Transfer-Encoding: base64$ac$ac".chunk_split(base64_encode(file_get_contents($sc["tmp_name"][$y])),76,$ac).$ac;}$Ka="";$Sc="Content-Type: text/plain; charset=utf-8$ac"."Content-Transfer-Encoding: 8bit";if($Aa){$Aa.="--$Oa--$ac";$Ka="--$Oa$ac$Sc$ac$ac";$Sc="Content-Type: multipart/mixed; boundary=\"$Oa\"";}$Sc.=$ac."MIME-Version: 1.0$ac"."X-Mailer: Adminer Editor".($Hc?$ac."From: ".str_replace("\n","",$Hc):"");return mail($Ub,email_header($Vf),$Ka.$Td.$Aa,$Sc);}function like_bool($o){return preg_match("~bool|(tinyint|bit)\\(1\\)~",$o["full_type"]);}$h->select_db($b->database());$ke="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";$Mb[DRIVER]=lang(36);if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["download"])){$a=$_GET["download"];$p=fields($a);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$a-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$K=array(idf_escape($_GET["field"]));$G=$m->select($a,$K,array(where($_GET,$p)),$K);$I=($G?$G->fetch_row():array());echo$m->value($I[0],$p[$_GET["field"]]);exit;}elseif(isset($_GET["edit"])){$a=$_GET["edit"];$p=fields($a);$Z=(isset($_GET["select"])?($_POST["check"]&&count($_POST["check"])==1?where_check($_POST["check"][0],$p):""):where($_GET,$p));$Kg=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($p as$B=>$o){if(!isset($o["privileges"][$Kg?"update":"insert"])||$b->fieldName($o)==""||$o["generated"])unset($p[$B]);}if($_POST&&!$n&&!isset($_GET["select"])){$Gd=$_POST["referer"];if($_POST["insert"])$Gd=($Kg?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$Gd))$Gd=ME."select=".urlencode($a);$w=indexes($a);$Fg=unique_array($_GET["where"],$w);$Ze="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($Gd,lang(81),$m->delete($a,$Ze,!$Fg));else{$N=array();foreach($p as$B=>$o){$X=process_input($o);if($X!==false&&$X!==null)$N[idf_escape($B)]=$X;}if($Kg){if(!$N)redirect($Gd);queries_redirect($Gd,lang(82),$m->update($a,$N,$Ze,!$Fg));if(is_ajax()){page_headers();page_messages($n);exit;}}else{$G=$m->insert($a,$N);$Ad=($G?last_id():0);queries_redirect($Gd,lang(83,($Ad?" $Ad":"")),$G);}}}$I=null;if($_POST["save"])$I=(array)$_POST["fields"];elseif($Z){$K=array();foreach($p as$B=>$o){if(isset($o["privileges"]["select"])){$za=convert_field($o);if($_POST["clone"]&&$o["auto_increment"])$za="''";if($x=="sql"&&preg_match("~enum|set~",$o["type"]))$za="1*".idf_escape($B);$K[]=($za?"$za AS ":"").idf_escape($B);}}$I=array();if(!support("table"))$K=array("*");if($K){$G=$m->select($a,$K,array($Z),$K,array(),(isset($_GET["select"])?2:1));if(!$G)$n=error();else{$I=$G->fetch_assoc();if(!$I)$I=false;}if(isset($_GET["select"])&&(!$I||$G->fetch_assoc()))$I=null;}}if(!support("table")&&!$p){if(!$Z){$G=$m->select($a,array("*"),$Z,array("*"));$I=($G?$G->fetch_assoc():false);if(!$I)$I=array($m->primary=>"");}if($I){foreach($I as$y=>$X){if(!$Z)$I[$y]=null;$p[$y]=array("field"=>$y,"null"=>($y!=$m->primary),"auto_increment"=>($y==$m->primary));}}}edit_form($a,$p,$I,$Kg);}elseif(isset($_GET["select"])){$a=$_GET["select"];$R=table_status1($a);$w=indexes($a);$p=fields($a);$Dc=column_foreign_keys($a);$ie=$R["Oid"];parse_str($_COOKIE["adminer_import"],$ta);$pf=array();$f=array();$hg=null;foreach($p as$y=>$o){$B=$b->fieldName($o);if(isset($o["privileges"]["select"])&&$B!=""){$f[$y]=html_entity_decode(strip_tags($B),ENT_QUOTES);if(is_shortable($o))$hg=$b->selectLengthProcess();}$pf+=$o["privileges"];}list($K,$Jc)=$b->selectColumnsProcess($f,$w);$pd=count($Jc)selectSearchProcess($p,$w);$se=$b->selectOrderProcess($p,$w);$z=$b->selectLimitProcess();if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$Gg=>$I){$za=convert_field($p[key($I)]);$K=array($za?$za:idf_escape(key($I)));$Z[]=where_check($Gg,$p);$H=$m->select($a,$K,$Z,$K);if($H)echo reset($H->fetch_row());}exit;}$Pe=$Ig=null;foreach($w as$v){if($v["type"]=="PRIMARY"){$Pe=array_flip($v["columns"]);$Ig=($K?$Pe:array());foreach($Ig as$y=>$X){if(in_array(idf_escape($y),$K))unset($Ig[$y]);}break;}}if($ie&&!$Pe){$Pe=$Ig=array($ie=>0);$w[]=array("type"=>"PRIMARY","columns"=>array($ie));}if($_POST&&!$n){$ch=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Va=array();foreach($_POST["check"]as$Sa)$Va[]=where_check($Sa,$p);$ch[]="((".implode(") OR (",$Va)."))";}$ch=($ch?"\nWHERE ".implode(" AND ",$ch):"");if($_POST["export"]){cookie("adminer_import","output=".urlencode($_POST["output"])."&format=".urlencode($_POST["format"]));dump_headers($a);$b->dumpTable($a,"");$Hc=($K?implode(", ",$K):"*").convert_fields($f,$p,$K)."\nFROM ".table($a);$Lc=($Jc&&$pd?"\nGROUP BY ".implode(", ",$Jc):"").($se?"\nORDER BY ".implode(", ",$se):"");if(!is_array($_POST["check"])||$Pe)$F="SELECT $Hc$ch$Lc";else{$Eg=array();foreach($_POST["check"]as$X)$Eg[]="(SELECT".limit($Hc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$p).$Lc,1).")";$F=implode(" UNION ALL ",$Eg);}$b->dumpData($a,"table",$F);exit;}if(!$b->selectEmailProcess($Z,$Dc)){if($_POST["save"]||$_POST["delete"]){$G=true;$ua=0;$N=array();if(!$_POST["delete"]){foreach($f as$B=>$X){$X=process_input($p[$B]);if($X!==null&&($_POST["clone"]||$X!==false))$N[idf_escape($B)]=($X!==false?$X:idf_escape($B));}}if($_POST["delete"]||$N){if($_POST["clone"])$F="INTO ".table($a)." (".implode(", ",array_keys($N)).")\nSELECT ".implode(", ",$N)."\nFROM ".table($a);if($_POST["all"]||($Pe&&is_array($_POST["check"]))||$pd){$G=($_POST["delete"]?$m->delete($a,$ch):($_POST["clone"]?queries("INSERT $F$ch"):$m->update($a,$N,$ch)));$ua=$h->affected_rows;}else{foreach((array)$_POST["check"]as$X){$Yg="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$p);$G=($_POST["delete"]?$m->delete($a,$Yg,1):($_POST["clone"]?queries("INSERT".limit1($a,$F,$Yg)):$m->update($a,$N,$Yg,1)));if(!$G)break;$ua+=$h->affected_rows;}}}$Td=lang(84,$ua);if($_POST["clone"]&&$G&&$ua==1){$Ad=last_id();if($Ad)$Td=lang(83," $Ad");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$Td,$G);if(!$_POST["delete"]){edit_form($a,$p,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$n=lang(85);else{$G=true;$ua=0;foreach($_POST["val"]as$Gg=>$I){$N=array();foreach($I as$y=>$X){$y=bracket_escape($y,1);$N[idf_escape($y)]=(preg_match('~char|text~',$p[$y]["type"])||$X!=""?$b->processInput($p[$y],$X):"NULL");}$G=$m->update($a,$N," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($Gg,$p),!$pd&&!$Pe," ");if(!$G)break;$ua+=$h->affected_rows;}queries_redirect(remove_from_uri(),lang(84,$ua),$G);}}elseif(!is_string($rc=get_file("csv_file",true)))$n=upload_error($rc);elseif(!preg_match('~~u',$rc))$n=lang(86);else{cookie("adminer_import","output=".urlencode($ta["output"])."&format=".urlencode($_POST["separator"]));$G=true;$db=array_keys($p);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$rc,$Nd);$ua=count($Nd[0]);$m->begin();$L=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$J=array();foreach($Nd[0]as$y=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$L]*)$L~",$X.$L,$Od);if(!$y&&!array_diff($Od[1],$db)){$db=$Od[1];$ua--;}else{$N=array();foreach($Od[1]as$s=>$ab)$N[idf_escape($db[$s])]=($ab==""&&$p[$db[$s]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$ab))));$J[]=$N;}}$G=(!$J||$m->insertUpdate($a,$J,$Pe));if($G)$G=$m->commit();queries_redirect(remove_from_uri("page"),lang(87,$ua),$G);$m->rollback();}}}$ag=$b->tableName($R);if(is_ajax()){page_headers();ob_start();}else page_header(lang(48).": $ag",$n);$N=null;if(isset($pf["insert"])||!support("table")){$N="";foreach((array)$_GET["where"]as$X){if($Dc[$X["col"]]&&count($Dc[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!preg_match('~[_%]~',$X["val"]))))$N.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$b->selectLinks($R,$N);if(!$f&&support("table"))echo"

  ".lang(88).($p?".":": ".error())."\n";else{echo"

  \n","

  ";hidden_fields_get();echo(DB!=""?''.(isset($_GET["ns"])?'':""):"");echo'',"

  \n";$b->selectColumnsPrint($K,$f);$b->selectSearchPrint($Z,$f,$w);$b->selectOrderPrint($se,$f,$w);$b->selectLimitPrint($z);$b->selectLengthPrint($hg);$b->selectActionPrint($w);echo"
  \n";$D=$_GET["page"];if($D=="last"){$Fc=$h->result(count_rows($a,$Z,$pd,$Jc));$D=floor(max(0,$Fc-1)/$z);}$vf=$K;$Kc=$Jc;if(!$vf){$vf[]="*";$rb=convert_fields($f,$p,$K);if($rb)$vf[]=substr($rb,2);}foreach($K as$y=>$X){$o=$p[idf_unescape($X)];if($o&&($za=convert_field($o)))$vf[$y]="$za AS $X";}if(!$pd&&$Ig){foreach($Ig as$y=>$X){$vf[]=idf_escape($y);if($Kc)$Kc[]=idf_escape($y);}}$G=$m->select($a,$vf,$Z,$Kc,$se,$z,$D,true);if(!$G)echo"

  ".error()."\n";else{if($x=="mssql"&&$D)$G->seek($z*$D);$Wb=array();echo"

  \n";$J=array();while($I=$G->fetch_assoc()){if($D&&$x=="oracle")unset($I["RNUM"]);$J[]=$I;}if($_GET["page"]!="last"&&$z!=""&&$Jc&&$pd&&$x=="sql")$Fc=$h->result(" SELECT FOUND_ROWS()");if(!$J)echo"

  ".lang(12)."\n";else{$Ja=$b->backwardKeys($a,$ag);echo"

  ","",script("mixin(qs('#table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true), onkeydown: editingKeydown});"),"".(!$Jc&&$K?"":"\n";if(is_ajax()){if($z%2==1&&$D%2==1)odd();ob_end_clean();}foreach($b->rowDescriptions($J,$Dc)as$Zd=>$I){$Fg=unique_array($J[$Zd],$w);if(!$Fg){$Fg=array();foreach($J[$Zd]as$y=>$X){if(!preg_match('~^(COUNT\((\*|(DISTINCT )?`(?:[^`]|``)+`)\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\(`(?:[^`]|``)+`\))$~',$y))$Fg[$y]=$X;}}$Gg="";foreach($Fg as$y=>$X){if(($x=="sql"||$x=="pgsql")&&preg_match('~char|text|enum|set~',$p[$y]["type"])&&strlen($X)>64){$y=(strpos($y,'(')?$y:idf_escape($y));$y="MD5(".($x!='sql'||preg_match("~^utf8~",$p[$y]["collation"])?$y:"CONVERT($y USING ".charset($h).")").")";$X=md5($X);}$Gg.="&".($X!==null?urlencode("where[".bracket_escape($y)."]")."=".urlencode($X):"null%5B%5D=".urlencode($y));}echo"".(!$Jc&&$K?"":"";}}}if($Ja)echo"\n";}if(is_ajax())exit;echo"

  ".script("qs('#all-page').onclick = partial(formCheck, /check/);","")." ".lang(89)."");$ae=array();$Ic=array();reset($K);$bf=1;foreach($J[0]as$y=>$X){if(!isset($Ig[$y])){$X=$_GET["columns"][key($K)];$o=$p[$K?($X?$X["col"]:current($K)):$y];$B=($o?$b->fieldName($o,$bf):($X["fun"]?"*":$y));if($B!=""){$bf++;$ae[$y]=$B;$e=idf_escape($y);$Xc=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($y);$Fb="&desc%5B0%5D=1";echo"	".script("mixin(qsl('th'), {onmouseover: partial(columnMouse), onmouseout: partial(columnMouse, ' hidden')});",""),'';echo apply_sql_function($X["fun"],$B)."";echo""," ↓";if(!$X["fun"]){echo' =',script("qsl('a').onclick = partial(selectSearch, '".js_escape($y)."');");}echo"";}$Ic[$y]=$X["fun"];next($K);}}$Dd=array();if($_GET["modify"]){foreach($J as$I){foreach($I as$y=>$X)$Dd[$y]=max($Dd[$y],min(40,strlen(utf8_decode($X))));}}echo($Ja?"	".lang(91):"")."
  ".checkbox("check[]",substr($Gg,1),in_array(substr($Gg,1),(array)$_POST["check"])).($pd||information_schema(DB)?"":" ".lang(92).""));foreach($I as$y=>$X){if(isset($ae[$y])){$o=$p[$y];$X=$m->value($X,$o);if($X!=""&&(!isset($Wb[$y])||$Wb[$y]!=""))$Wb[$y]=(is_mail($X)?$ae[$y]:"");$_="";if(preg_match('~blob|bytea|raw|file~',$o["type"])&&$X!="")$_=ME.'download='.urlencode($a).'&field='.urlencode($y).$Gg;if(!$_&&$X!==null){foreach((array)$Dc[$y]as$Cc){if(count($Dc[$y])==1||end($Cc["source"])==$y){$_="";foreach($Cc["source"]as$s=>$Kf)$_.=where_link($s,$Cc["target"][$s],$J[$Zd][$Kf]);$_=($Cc["db"]!=""?preg_replace('~([?&]db=)[^&]+~','\1'.urlencode($Cc["db"]),ME):ME).'select='.urlencode($Cc["table"]).$_;if($Cc["ns"])$_=preg_replace('~([?&]ns=)[^&]+~','\1'.urlencode($Cc["ns"]),$_);if(count($Cc["source"])==1)break;}}}if($y=="COUNT(*)"){$_=ME."select=".urlencode($a);$s=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$Fg))$_.=where_link($s++,$W["col"],$W["val"],$W["op"]);}foreach($Fg as$sd=>$W)$_.=where_link($s++,$sd,$W);}$X=select_value($X,$_,$o,$hg);$t=h("val[$Gg][".bracket_escape($y)."]");$Y=$_POST["val"][$Gg][bracket_escape($y)];$Sb=!is_array($I[$y])&&is_utf8($X)&&$J[$Zd][$y]==$I[$y]&&!$Ic[$y];$gg=preg_match('~text|lob~',$o["type"]);echo"	".($gg?"$Nc":"");}else{$Id=strpos($X,"…");echo" data-text='".($Id?2:($gg?1:0))."'".($Sb?"":" data-warning='".h(lang(93))."'").">$X	";$b->backwardKeysPrint($Ja,$J[$Zd]);echo"

  \n","

  \n";}if(!is_ajax()){if($J||$D){$fc=true;if($_GET["page"]!="last"){if($z==""||(count($J)<$z&&($J||!$D)))$Fc=($D?$D*$z:0)+count($J);elseif($x!="sql"||!$pd){$Fc=($pd?false:found_rows($R,$Z));if($Fc$z||$D));if($Ae){echo(($Fc===false?count($J)+1:$Fc-$D*$z)>$z?'

  '.lang(94).''.script("qsl('a').onclick = partial(selectLoadMore, ".(+$z).", '".lang(95)."…');",""):''),"\n";}}echo"

  \n";if($J||$D){if($Ae){$Pd=($Fc===false?$D+(count($J)>=$z?2:1):floor(($Fc-1)/$z));echo"

  ";if($x!="simpledb"){echo"

  ".lang(96)."

  ",script("qsl('a').onclick = function () { pageClick(this.href, +prompt('".lang(96)."', '".($D+1)."')); return false; };"),pagination(0,$D).($D>5?" …":"");for($s=max(1,$D-4);$s0){echo($D+5<$Pd?" …":""),($fc&&$Fc!==false?pagination($Pd,$D):" ".lang(97)."");}}else{echo"

  ".lang(96)."

  ",pagination(0,$D).($D>1?" …":""),($D?pagination($D,$D):""),($Pd>$D?pagination($D+1,$D).($Pd>$D+1?" …":""):"");}echo"

  \n";}echo"

  ","

  ".lang(98)."

  ";$Kb=($fc?"":"~ ").$Fc;echo checkbox("all",1,0,($Fc!==false?($fc?"":"~ ").lang(99,$Fc):""),"var checked = formChecked(this, /check/); selectCount('selected', this.checked ? '$Kb' : checked); selectCount('selected2', this.checked || !checked ? '$Kb' : checked);")."\n","

  \n";if($b->selectCommandPrint()){echo'

  ',lang(89),'

  ',lang(100),'

  ',confirm(),'

  ';}$Ec=$b->dumpFormat();foreach((array)$_GET["columns"]as$e){if($e["fun"]){unset($Ec['sql']);break;}}if($Ec){print_fieldset("export",lang(102)." ");$ye=$b->dumpOutput();echo($ye?html_select("output",$ye,$ta["output"])." ":""),html_select("format",$Ec,$ta["format"])," \n","

  \n";}$b->selectEmailPrint(array_filter($Wb,'strlen'),$f);}echo"

  \n";if($b->selectImportPrint()){echo"

  ","".lang(103)."",script("qsl('a').onclick = partial(toggle, 'import');",""),": "," ",html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$ta["format"],1);echo" ","","

  ";}echo"\n","\n",(!$Jc&&$K?"":script("tableCheck();"));}}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["script"])){if($_GET["script"]=="kill")$h->query("KILL ".number($_POST["kill"]));elseif(list($Q,$t,$B)=$b->_foreignColumn(column_foreign_keys($_GET["source"]),$_GET["field"])){$z=11;$G=$h->query("SELECT $t, $B FROM ".table($Q)." WHERE ".(preg_match('~^[0-9]+$~',$_GET["value"])?"$t = $_GET[value] OR ":"")."$B LIKE ".q("$_GET[value]%")." ORDER BY 2 LIMIT $z");for($s=1;($I=$G->fetch_row())&&$s<$z;$s++)echo"".h($I[1])."
  \n";if($I)echo"...\n";}exit;}else{page_header(lang(63),"",false);if($b->homepage()){echo"

  \n","

  ".lang(104).": \n";if($_POST["query"]!="")search_tables();echo"

  \n","\n",script("mixin(qsl('table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true)});"),'','\n";foreach(table_status()as$Q=>$I){$B=$b->tableName($I);if(isset($I["Engine"])&&$B!=""){echo'

  '.script("qs('#check-all').onclick = partial(formCheck, /^tables\[/);",""),'	'.lang(105),'	'.lang(106),"
  '.checkbox("tables[]",$Q,in_array($Q,(array)$_POST["tables"],true)),"	$B";$X=format_number($I["Rows"]);echo"	".($I["Engine"]=="InnoDB"&&$X?"~ $X":$X)."";}}echo"

  \n","

  \n","

  \n",script("tableCheck();");}}page_footer();