".shorten_utf8($I,1000).'

'.($_GET["ns"]==""&&support("database")?''.lang(55)."\n":""),(support("scheme")?"".($_GET["ns"]!=""?lang(56):lang(57))."\n":""),($_GET["ns"]!==""?''.lang(58)."\n":""),(support("privileges")?"".lang(59)."\n":"");return true;}function navigation($Hd){global$fa,$y,$Eb,$g;echo'

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

\n";$pc=false;}$tb=$_SESSION["db"][$Mg][$O][$V];foreach(($tb?array_keys($tb):array(""))as$k)echo"($Eb[$Mg]) ".h($V.($O!=""?"@$O":"").($k!=""?" - $k":""))."
\n";}}}}}else{if($_GET["ns"]!==""&&!$Hd&&DB!=""){$g->select_db(DB);$S=table_status('',true);}if(support("sql")){echo' ';}$this->databasesPrint($Hd);if(DB==""||!$Hd){echo"

".(support("sql")?"".lang(51)."\n".lang(60)."\n":"")."";if(support("dump"))echo"".lang(61)."\n";}if($_GET["ns"]!==""&&!$Hd&&DB!=""){echo'".lang(62)."\n";if(!$S)echo"

".lang(9)."\n";else$this->tablesPrint($S);}}}function databasesPrint($Hd){global$c,$g;$j=$this->databases();echo'

\n";foreach($S as$Q=>$Gf){echo'".lang(64)." ";$F=$this->tableName($Gf);echo(support("table")||support("indexes")?'$F":"$F")."
\n";}}}$c=(function_exists('adminer_object')?adminer_object():new Adminer);if($c->operators===null)$c->operators=$de;function page_header($hg,$m="",$Ha=array(),$ig=""){global$a,$fa,$c,$Eb,$y;page_headers();if(is_ajax()&&$m){page_messages($m);exit;}$jg=$hg.($ig!=""?": $ig":"");$kg=strip_tags($jg.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$c->name());echo' ';if($c->head()){echo' ';if(file_exists("adminer.css")){echo' ';}}echo' >

".lang(12))."\n";return$K;}function referencable_primary($vf){$K=array();foreach(table_status('',true)as$Sf=>$Q){if($Sf!=$vf&&fk_support($Q)){foreach(fields($Sf)as$n){if($n["primary"]){if($K[$Sf]){unset($K[$Sf]);break;}$K[$Sf]=$n;}}}}return$K;}function textarea($F,$Y,$M=10,$Ya=80){global$y;echo"";if(is_array($Y)){foreach($Y as$X)echo h($X[0])."\n\n\n";}else echo h($Y);echo"";}function edit_type($z,$n,$Xa,$tc=array()){global$Kf,$wg,$Cg,$Zd;$U=$n["type"];echo'';if($U&&!isset($wg[$U])&&!isset($tc[$U]))array_unshift($Kf,$U);if($tc)$Kf[lang(81)]=$tc;echo optionlist($Kf,$U),' ';echo"('.lang(82).')'.optionlist($Xa,$n["collation"]).'',($Cg?"'.optionlist($Cg,$n["unsigned"]).'':''),(isset($n['on_update'])?"'.optionlist(array(""=>"(".lang(83).")","CURRENT_TIMESTAMP"),$n["on_update"]).'':''),($tc?"(".lang(84).")".optionlist(explode("|",$Zd),$n["on_delete"])." ":" ");}function process_length($od){global$Vb;return(preg_match("~^\\s*\\(?\\s*$Vb(?:\\s*,\\s*$Vb)*+\\s*\\)?\\s*\$~",$od)&&preg_match_all("~$Vb~",$od,$vd)?"(".implode(",",$vd[0]).")":preg_replace('~^[0-9].*~','(\0)',preg_replace('~[^-0-9,+()[\]]~','',$od)));}function process_type($n,$Va="COLLATE"){global$Cg;return" $n[type]".process_length($n["length"]).(preg_match('~(^|[^o])int|float|double|decimal~',$n["type"])&&in_array($n["unsigned"],$Cg)?" $n[unsigned]":"").(preg_match('~char|text|enum|set~',$n["type"])&&$n["collation"]?" $Va ".q($n["collation"]):"");}function process_field($n,$ug){global$y;$vb=$n["default"];return array(idf_escape(trim($n["field"])),process_type($ug),($n["null"]?" NULL":" NOT NULL"),(isset($vb)?" DEFAULT ".((preg_match('~time~',$n["type"])&&preg_match('~^CURRENT_TIMESTAMP$~i',$vb))||($y=="sqlite"&&preg_match('~^CURRENT_(TIME|TIMESTAMP|DATE)$~i',$vb))||($n["type"]=="bit"&&preg_match("~^([0-9]+|b'[0-1]+')\$~",$vb))||($y=="pgsql"&&preg_match("~^[a-z]+\\(('[^']*')+\\)\$~",$vb))?$vb:q($vb)):""),(preg_match('~timestamp|datetime~',$n["type"])&&$n["on_update"]?" ON UPDATE $n[on_update]":""),(support("comment")&&$n["comment"]!=""?" COMMENT ".q($n["comment"]):""),($n["auto_increment"]?auto_increment():null),);}function type_class($U){foreach(array('char'=>'text','date'=>'time|year','binary'=>'blob','enum'=>'set',)as$z=>$X){if(preg_match("~$z|$X~",$U))return" class='$z'";}}function edit_fields($o,$Xa,$U="TABLE",$tc=array(),$cb=false){global$g,$Pc;$o=array_values($o);echo' ';if($U=="PROCEDURE"){echo' ';}echo'',($U=="TABLE"?lang(85):lang(86)),'',lang(87),' ',lang(88),'',lang(89);if($U=="TABLE"){echo'NULL AI',doc_link(array('sql'=>"example-auto-increment.html",'sqlite'=>"autoinc.html",'pgsql'=>"datatype.html#DATATYPE-SERIAL",'mssql'=>"ms186775.aspx",)),'',lang(90),(support("comment")?"".lang(91):"");}echo'',"",' ';foreach($o as$u=>$n){$u++;$le=$n[($_POST?"orig":"field")];$Ab=(isset($_POST["add"][$u-1])||(isset($n["field"])&&!$_POST["drop_col"][$u]))&&(support("drop_col")||$le=="");echo' ',($U=="PROCEDURE"?"".html_select("fields[$u][inout]",explode("|",$Pc),$n["inout"]):""),'';if($Ab){echo'1?'':' editingAddRow(this);" onkeyup="if (this.value) editingAddRow(this);'),'" maxlength="64" autocapitalize="off">';}echo' ';edit_type("fields[$u]",$n,$Xa,$tc);if($U=="TABLE"){echo'',checkbox("fields[$u][null]",1,$n["null"],"","","block"),' onclick="var field = this.form['fields[' + this.value + '][field]']; if (!field.value) { field.value = 'id'; field.onchange(); }"> ',(support("comment")?"":"");}echo"",(support("move_col")?" "." "." ":""),($le==""||support("drop_col")?"":""),"\n";}}function process_fields(&$o){ksort($o);$Sd=0;if($_POST["up"]){$id=0;foreach($o as$z=>$n){if(key($_POST["up"])==$z){unset($o[$z]);array_splice($o,$id,0,array($n));break;}if(isset($n["field"]))$id=$Sd;$Sd++;}}elseif($_POST["down"]){$vc=false;foreach($o as$z=>$n){if(isset($n["field"])&&$vc){unset($o[key($_POST["down"])]);array_splice($o,$Sd,0,array($vc));break;}if(key($_POST["down"])==$z)$vc=$n;$Sd++;}}elseif($_POST["add"]){$o=array_values($o);array_splice($o,key($_POST["add"]),0,array(array()));}elseif(!$_POST["drop_col"])return false;return true;}function normalize_enum($C){return"'".str_replace("'","''",addcslashes(stripcslashes(str_replace($C[0][0].$C[0][0],$C[0][0],substr($C[0],1,-1))),'\\'))."'";}function grant($s,$Pe,$e,$Yd){if(!$Pe)return true;if($Pe==array("ALL PRIVILEGES","GRANT OPTION"))return($s=="GRANT"?queries("$s ALL PRIVILEGES$Yd WITH GRANT OPTION"):queries("$s ALL PRIVILEGES$Yd")&&queries("$s GRANT OPTION$Yd"));return queries("$s ".preg_replace('~(GRANT OPTION)\\([^)]*\\)~','\\1',implode("$e, ",$Pe).$e).$Yd);}function drop_create($Fb,$i,$Gb,$bg,$Hb,$B,$Ed,$Cd,$Dd,$Vd,$Md){if($_POST["drop"])query_redirect($Fb,$B,$Ed);elseif($Vd=="")query_redirect($i,$B,$Dd);elseif($Vd!=$Md){$lb=queries($i);queries_redirect($B,$Cd,$lb&&queries($Fb));if($lb)queries($Gb);}else queries_redirect($B,$Cd,queries($bg)&&queries($Hb)&&queries($Fb)&&queries($i));}function create_trigger($Yd,$L){global$y;$gg=" $L[Timing] $L[Event]".($L["Event"]=="UPDATE OF"?" ".idf_escape($L["Of"]):"");return"CREATE TRIGGER ".idf_escape($L["Trigger"]).($y=="mssql"?$Yd.$gg:$gg.$Yd).rtrim(" $L[Type]\n$L[Statement]",";").";";}function create_routine($mf,$L){global$Pc;$P=array();$o=(array)$L["fields"];ksort($o);foreach($o as$n){if($n["field"]!="")$P[]=(preg_match("~^($Pc)\$~",$n["inout"])?"$n[inout] ":"").idf_escape($n["field"]).process_type($n,"CHARACTER SET");}return"CREATE $mf ".idf_escape(trim($L["name"]))." (".implode(", ",$P).")".(isset($_GET["function"])?" RETURNS".process_type($L["returns"],"CHARACTER SET"):"").($L["language"]?" LANGUAGE $L[language]":"").rtrim("\n$L[definition]",";").";";}function remove_definer($I){return preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\\1)',logged_user()).'`~','\\1',$I);}function format_foreign_key($p){global$Zd;return" FOREIGN KEY (".implode(", ",array_map('idf_escape',$p["source"])).") REFERENCES ".table($p["table"])." (".implode(", ",array_map('idf_escape',$p["target"])).")".(preg_match("~^($Zd)\$~",$p["on_delete"])?" ON DELETE $p[on_delete]":"").(preg_match("~^($Zd)\$~",$p["on_update"])?" ON UPDATE $p[on_update]":"");}function tar_file($nc,$lg){$K=pack("a100a8a8a8a12a12",$nc,644,0,0,decoct($lg->size),decoct(time()));$Pa=8*32;for($u=0;$usend();echo str_repeat("\0",511-($lg->size+511)%512);}function ini_bytes($Oc){$X=ini_get($Oc);switch(strtolower(substr($X,-1))){case'g':$X*=1024;case'm':$X*=1024;case'k':$X*=1024;}return$X;}function doc_link($Ae){global$y,$g;$Fg=array('sql'=>"http://dev.mysql.com/doc/refman/".substr($g->server_info,0,3)."/en/",'sqlite'=>"http://www.sqlite.org/",'pgsql'=>"http://www.postgresql.org/docs/".substr($g->server_info,0,3)."/static/",'mssql'=>"http://msdn.microsoft.com/library/",'oracle'=>"http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/",);return($Ae[$y]?"^?":"");}function ob_gzencode($Jf){return gzencode($Jf);}function db_size($k){global$g;if(!$g->select_db($k))return"?";$K=0;foreach(table_status()as$R)$K+=$R["Data_length"]+$R["Index_length"];return format_number($K);}function set_utf8mb4($i){global$g;static$P=false;if(!$P&&preg_match('~\butf8mb4~i',$i)){$P=true;echo"SET NAMES ".charset($g).";\n\n";}}function connect_error(){global$c,$g,$T,$m,$Eb;if(DB!=""){header("HTTP/1.1 404 Not Found");page_header(lang(31).": ".h(DB),lang(96),true);}else{if($_POST["db"]&&!$m)queries_redirect(substr(ME,0,-1),lang(97),drop_databases($_POST["db"]));page_header(lang(98),$m,false);echo"

\n";foreach(array('database'=>lang(99),'privileges'=>lang(59),'processlist'=>lang(100),'variables'=>lang(101),'status'=>lang(102),)as$z=>$X){if(support($z))echo"$X\n";}echo"

".lang(103,$Eb[DRIVER],"".h($g->server_info)."","$g->extension")."\n","

".lang(104,"".h(logged_user())."")."\n";$j=$c->databases();if($j){$sf=support("scheme");$Xa=collations();echo"

".lang(91).": ".h($bb)."\n";if($o){echo"\n","\n";foreach($o as$n){echo"

".lang(114)."	".lang(87).(support("comment")?"	".lang(91):"")."
".h($n["field"]),"	".h($n["full_type"])."",($n["null"]?" NULL":""),($n["auto_increment"]?" ".lang(52)."":""),(isset($n["default"])?" [".h($n["default"])."]":""),(support("comment")?"	".nbsp($n["comment"]):""),"\n";}echo"

\n";}if(!is_view($R)){if(support("indexes")){echo"

".lang(115)."

'.lang(116)."\n";}if(fk_support($R)){echo"

".lang(81)."

'.lang(120)."\n";}}if(support(is_view($R)?"view_trigger":"trigger")){echo"

".lang(121)."

'.lang(122)."\n";}}elseif(isset($_GET["schema"])){page_header(lang(58),"",array(),h(DB.($_GET["ns"]?".$_GET[ns]":"")));$Tf=array();$Uf=array();$da=($_GET["schema"]?$_GET["schema"]:$_COOKIE["adminer_schema-".str_replace(".","_",DB)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$da,$vd,PREG_SET_ORDER);foreach($vd as$u=>$C){$Tf[$C[1]]=array($C[2],$C[3]);$Uf[]="\n\t'".js_escape($C[1])."': [ $C[2], $C[3] ]";}$ng=0;$Ca=-1;$rf=array();$cf=array();$md=array();foreach(table_status('',true)as$Q=>$R){if(is_view($R))continue;$Fe=0;$rf[$Q]["fields"]=array();foreach(fields($Q)as$F=>$n){$Fe+=1.25;$n["pos"]=$Fe;$rf[$Q]["fields"][$F]=$n;}$rf[$Q]["pos"]=($Tf[$Q]?$Tf[$Q]:array($ng,0));foreach($c->foreignKeys($Q)as$X){if(!$X["db"]){$kd=$Ca;if($Tf[$Q][1]||$Tf[$X["table"]][1])$kd=min(floatval($Tf[$Q][1]),floatval($Tf[$X["table"]][1]))-1;else$Ca-=.1;while($md[(string)$kd])$kd-=.0001;$rf[$Q]["references"][$X["table"]][(string)$kd]=array($X["source"],$X["target"]);$cf[$X["table"]][$Q][(string)$kd]=$X["target"];$md[(string)$kd]=true;}}$ng=max($ng,$rf[$Q]["pos"][0]+2.5+$Fe);}echo'

',lang(123),' ';}elseif(isset($_GET["dump"])){$b=$_GET["dump"];if($_POST&&!$m){$jb="";foreach(array("output","format","db_style","routines","events","table_style","auto_increment","triggers","data_style")as$z)$jb.="&$z=".urlencode($_POST[$z]);cookie("adminer_export",substr($jb,1));$S=array_flip((array)$_POST["tables"])+array_flip((array)$_POST["data"]);$gc=dump_headers((count($S)==1?key($S):DB),(DB==""||count($S)>1));$Xc=preg_match('~sql~',$_POST["format"]);if($Xc){echo"-- Adminer $fa ".$Eb[DRIVER]." dump\n\n";if($y=="sql"){echo"SET NAMES utf8; SET time_zone = '+00:00'; ".($_POST["data_style"]?"SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; ":"")." ";$g->query("SET time_zone = '+00:00';");}}$Lf=$_POST["db_style"];$j=array(DB);if(DB==""){$j=$_POST["databases"];if(is_string($j))$j=explode("\n",rtrim(str_replace("\r","",$j),"\n"));}foreach((array)$j as$k){$c->dumpDatabase($k);if($g->select_db($k)){if($Xc&&preg_match('~CREATE~',$Lf)&&($i=$g->result("SHOW CREATE DATABASE ".idf_escape($k),1))){set_utf8mb4($i);if($Lf=="DROP+CREATE")echo"DROP DATABASE IF EXISTS ".idf_escape($k).";\n";echo"$i;\n";}if($Xc){if($Lf)echo use_sql($k).";\n\n";$pe="";if($_POST["routines"]){foreach(array("FUNCTION","PROCEDURE")as$mf){foreach(get_rows("SHOW $mf STATUS WHERE Db = ".q($k),null,"-- ")as$L){$i=remove_definer($g->result("SHOW CREATE $mf ".idf_escape($L["Name"]),2));set_utf8mb4($i);$pe.=($Lf!='DROP+CREATE'?"DROP $mf IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$i;;\n\n";}}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$L){$i=remove_definer($g->result("SHOW CREATE EVENT ".idf_escape($L["Name"]),3));set_utf8mb4($i);$pe.=($Lf!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$i;;\n\n";}}if($pe)echo"DELIMITER ;;\n\n$pe"."DELIMITER ;\n\n";}if($_POST["table_style"]||$_POST["data_style"]){$Og=array();foreach(table_status('',true)as$F=>$R){$Q=(DB==""||in_array($F,(array)$_POST["tables"]));$ob=(DB==""||in_array($F,(array)$_POST["data"]));if($Q||$ob){if($gc=="tar"){$lg=new TmpFile;ob_start(array($lg,'write'),1e5);}$c->dumpTable($F,($Q?$_POST["table_style"]:""),(is_view($R)?2:0));if(is_view($R))$Og[]=$F;elseif($ob){$o=fields($F);$c->dumpData($F,$_POST["data_style"],"SELECT *".convert_fields($o,$o)." FROM ".table($F));}if($Xc&&$_POST["triggers"]&&$Q&&($tg=trigger_sql($F,$_POST["table_style"])))echo"\nDELIMITER ;;\n$tg\nDELIMITER ;\n";if($gc=="tar"){ob_end_flush();tar_file((DB!=""?"":"$k/")."$F.csv",$lg);}elseif($Xc)echo"\n";}}foreach($Og as$Ng)$c->dumpTable($Ng,$_POST["table_style"],1);if($gc=="tar")echo pack("x512");}}}if($Xc)echo"-- ".$g->result("SELECT NOW()")."\n";exit;}page_header(lang(61),$m,($_GET["export"]!=""?array("table"=>$_GET["export"]):array()),h(DB));echo'

":" ")."".h($z)."";$pc=false;}}}elseif(isset($_GET["privileges"])){page_header(lang(59));$J=$g->query("SELECT User, Host FROM mysql.".(DB==""?"user":"db WHERE ".q(DB)." LIKE Db")." ORDER BY Host, User");$s=$J;if(!$J)$J=$g->query("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1) AS User, SUBSTRING_INDEX(CURRENT_USER, '@', -1) AS Host");echo"

'.lang(129)."";}elseif(isset($_GET["sql"])){if(!$m&&$_POST["export"]){dump_headers("sql");$c->dumpTable("","");$c->dumpData("","table",$_POST["query"]);exit;}restart_session();$Gc=&get_session("queries");$Fc=&$Gc[DB];if(!$m&&$_POST["clear"]){$Fc=array();redirect(remove_from_uri("history"));}page_header((isset($_GET["import"])?lang(60):lang(51)),$m);if(!$m&&$_POST){$q=false;if(!isset($_GET["import"]))$I=$_POST["query"];elseif($_POST["webfile"]){$q=@fopen((file_exists("adminer.sql")?"adminer.sql":"compress.zlib://adminer.sql.gz"),"rb");$I=($q?fread($q,1e6):false);}else$I=get_file("sql_file",true);if(is_string($I)){if(function_exists('memory_get_usage'))@ini_set("memory_limit",max(ini_bytes("memory_limit"),2*strlen($I)+memory_get_usage()+8e6));if($I!=""&&strlen($I)<1e6){$H=$I.(preg_match("~;[ \t\r\n]*\$~",$I)?"":";");if(!$Fc||reset(end($Fc))!=$H){restart_session();$Fc[]=array($H,time());set_session("queries",$Gc);stop_session();}}$Df="(?:\\s|/\\*.*\\*/|(?:#|-- )[^\n]*\n|--\r?\n)";$wb=";";$Sd=0;$Sb=true;$h=connect();if(is_object($h)&&DB!="")$h->select_db(DB);$ab=0;$Xb=array();$rd=0;$ue='[\'"'.($y=="sql"?'`#':($y=="sqlite"?'`[':($y=="mssql"?'[':''))).']|/\\*|-- |$'.($y=="pgsql"?'|\\$[^$]*\\$':'');$og=microtime(true);parse_str($_COOKIE["adminer_export"],$la);$Jb=$c->dumpFormat();unset($Jb["sql"]);while($I!=""){if(!$Sd&&preg_match("~^$Df*DELIMITER\\s+(\\S+)~i",$I,$C)){$wb=$C[1];$I=substr($I,strlen($C[0]));}else{preg_match('('.preg_quote($wb)."\\s*|$ue)",$I,$C,PREG_OFFSET_CAPTURE,$Sd);list($vc,$Fe)=$C[0];if(!$vc&&$q&&!feof($q))$I.=fread($q,1e5);else{if(!$vc&&rtrim($I)=="")break;$Sd=$Fe+strlen($vc);if($vc&&rtrim($vc)!=$wb){while(preg_match('('.($vc=='/*'?'\\*/':($vc=='['?']':(preg_match('~^-- |^#~',$vc)?"\n":preg_quote($vc)."|\\\\."))).'|$)s',$I,$C,PREG_OFFSET_CAPTURE,$Sd)){$pf=$C[0][0];if(!$pf&&$q&&!feof($q))$I.=fread($q,1e5);else{$Sd=$C[0][1]+strlen($pf);if($pf[0]!="\\")break;}}}else{$Sb=false;$H=substr($I,0,$Fe);$ab++;$Me="

".shorten_utf8(trim($H),1000)."

".lang(130).($g->errno?" ($g->errno)":"").": ".error()."\n";$Xb[]=" $ab";if($_POST["error_stops"])break 2;}elseif(is_object($J)){$_=$_POST["limit"];$ke=select($J,$h,array(),$_);if(!$_POST["only_errors"]){echo"

".lang(133,$g->affected_rows)."$eg\n";}$Ff=microtime(true);}while($g->next_result());$rd+=substr_count($H.$vc,"\n");$I=substr($I,$Sd);$Sd=0;}}}}if($Sb)echo"

".lang(134)."\n";elseif($_POST["only_errors"]){echo"

".lang(135,$ab-count($Xb))," (".format_time($og).")\n";}elseif($Xb&&$ab>1)echo"

".lang(130).": ".implode("",$Xb)."\n";}else echo"

".upload_error($I)."\n";}echo'

".h($I)." ".lang(10)."\n";if(!$g->multi_query($I))echo"

".error()."\n";else{$h=connect();if(is_object($h))$h->select_db(DB);do{$J=$g->store_result();if(is_object($J))select($J,$h);else echo"

".lang(171,$g->affected_rows)."\n";}while($g->next_result());if($pe)select($g->query("SELECT ".implode(", ",$pe)));}}echo'