BnQn3T3d

1<?php
2/** Adminer - Compact database management
3* @link https://www.adminer.org/
4* @author Jakub Vrana, http://www.vrana.cz/
5* @copyright 2007 Jakub Vrana
6* @license http://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
7* @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
8* @version 4.2.3
9*/error_reporting(6135);$oc=!preg_match('~^(unsafe_raw)?$~',ini_get("filter.default"));if($oc||ini_get("filter.default_flags")){foreach(array('_GET','_POST','_COOKIE','_SERVER')as$X){$Ag=filter_input_array(constant("INPUT$X"),FILTER_UNSAFE_RAW);if($Ag)$$X=$Ag;}}if(function_exists("mb_internal_encoding"))mb_internal_encoding("8bit");if(isset($_GET["file"])){if($_SERVER["HTTP_IF_MODIFIED_SINCE"]){header("HTTP/1.1 304 Not Modified");exit;}header("Expires: ".gmdate("D, d M Y H:i:s",time()+365*24*60*60)." GMT");header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");if($_GET["file"]=="favicon.ico"){header("Content-Type: image/x-icon");echo
10lzw_decompress("\0\0lace("\0","&#0;",htmlspecialchars($Jf,ENT_QUOTES,'utf-8'));}function
11nbsp($Jf){return(trim($Jf)!=""?h($Jf):"&nbsp;");}function
12nl_br($Jf){return
13str_replace("\n","<br>",$Jf);}function
14checkbox($F,$Y,$Na,$fd="",$be="",$Ra=""){$K="<input type='checkbox' name='$F' value='".h($Y)."'".($Na?" checked":"").($be?' onclick="'.h($be).'"':'').">";return($fd!=""||$Ra?"<label".($Ra?" class='$Ra'":"").">$K".h($fd)."</label>":$K);}function
15optionlist($fe,$uf=null,$Hg=false){$K="";foreach($fe
16as$bd=>$W){$ge=array($bd=>$W);if(is_array($W)){$K.='<optgroup label="'.h($bd).'">';$ge=$W;}foreach($ge
17as$z=>$X)$K.='<option'.($Hg||is_string($z)?' value="'.h($z).'"':'').(($Hg||is_string($z)?(string)$z:$X)===$uf?' selected':'').'>'.h($X);if(is_array($W))$K.='</optgroup>';}return$K;}function
18html_select($F,$fe,$Y="",$ae=true){if($ae)return"<select name='".h($F)."'".(is_string($ae)?' onchange="'.h($ae).'"':"").">".optionlist($fe,$Y)."</select>";$K="";foreach($fe
19as$z=>$X)$K.="<label><input type='radio' name='".h($F)."' value='".h($z)."'".($z==$Y?" checked":"").">".h($X)."</label>";return$K;}function
20select_input($wa,$fe,$Y="",$De=""){return($fe?"<select$wa><option value=''>$De".optionlist($fe,$Y,true)."</select>":"<input$wa size='10' value='".h($Y)."' placeholder='$De'>");}function
21confirm(){return" onclick=\"return confirm('".lang(0)."');\"";}function
22print_fieldset($v,$nd,$Pg=false,$be=""){echo"<fieldset><legend><a href='#fieldset-$v' onclick=\"".h($be)."return !toggle('fieldset-$v');\">$nd</a></legend><div id='fieldset-$v'".($Pg?"":" class='hidden'").">\n";}function
23bold($Ga,$Ra=""){return($Ga?" class='active $Ra'":($Ra?" class='$Ra'":""));}function
24odd($K=' class="odd"'){static$u=0;if(!$K)$u=-1;return($u++%2?$K:'');}function
25js_escape($Jf){return
26addcslashes($Jf,"\r\n'\\/");}function
27json_row($z,$X=null){static$pc=true;if($pc)echo"{";if($z!=""){echo($pc?"":",")."\n\t\"".addcslashes($z,"\r\n\"\\/").'": '.($X!==null?'"'.addcslashes($X,"\r\n\"\\/").'"':'undefined');$pc=false;}else{echo"\n}\n";$pc=true;}}function
28ini_bool($Oc){$X=ini_get($Oc);return(preg_match('~^(on|true|yes)$~i',$X)||(int)$X);}function
29sid(){static$K;if($K===null)$K=(SID&&!($_COOKIE&&ini_bool("session.use_cookies")));return$K;}function
30set_password($Mg,$O,$V,$_e){$_SESSION["pwds"][$Mg][$O][$V]=($_COOKIE["adminer_key"]&&is_string($_e)?array(encrypt_string($_e,$_COOKIE["adminer_key"])):$_e);}function
31get_password(){$K=get_session("pwds");if(is_array($K))$K=($_COOKIE["adminer_key"]?decrypt_string($K[0],$_COOKIE["adminer_key"]):false);return$K;}function
32q($Jf){global$g;return$g->quote($Jf);}function
33get_vals($I,$d=0){global$g;$K=array();$J=$g->query($I);if(is_object($J)){while($L=$J->fetch_row())$K[]=$L[$d];}return$K;}function
34get_key_vals($I,$h=null,$fg=0){global$g;if(!is_object($h))$h=$g;$K=array();$h->timeout=$fg;$J=$h->query($I);$h->timeout=0;if(is_object($J)){while($L=$J->fetch_row())$K[$L[0]]=$L[1];}return$K;}function
35get_rows($I,$h=null,$m="<p class='error'>"){global$g;$eb=(is_object($h)?$h:$g);$K=array();$J=$eb->query($I);if(is_object($J)){while($L=$J->fetch_assoc())$K[]=$L;}elseif(!$J&&!is_object($h)&&$m&&defined("PAGE_HEADER"))echo$m.error()."\n";return$K;}function
36unique_array($L,$x){foreach($x
37as$w){if(preg_match("~PRIMARY|UNIQUE~",$w["type"])){$K=array();foreach($w["columns"]as$z){if(!isset($L[$z]))continue
382;$K[$z]=$L[$z];}return$K;}}}function
39escape_key($z){if(preg_match('(^([\w(]+)('.str_replace("_",".*",preg_quote(idf_escape("_"))).')([ \w)]+)$)',$z,$C))return$C[1].idf_escape(idf_unescape($C[2])).$C[3];return
40idf_escape($z);}function
41where($Z,$o=array()){global$g,$y;$K=array();foreach((array)$Z["where"]as$z=>$X){$z=bracket_escape($z,1);$d=escape_key($z);$K[]=$d.(($y=="sql"&&preg_match('~^[0-9]*\\.[0-9]*$~',$X))||$y=="mssql"?" LIKE ".q(addcslashes($X,"%_\\")):" = ".unconvert_field($o[$z],q($X)));if($y=="sql"&&preg_match('~char|text~',$o[$z]["type"])&&preg_match("~[^ -@]~",$X))$K[]="$d = ".q($X)." COLLATE ".charset($g)."_bin";}foreach((array)$Z["null"]as$z)$K[]=escape_key($z)." IS NULL";return
42implode(" AND ",$K);}function
43where_check($X,$o=array()){parse_str($X,$Ma);remove_slashes(array(&$Ma));return
44where($Ma,$o);}function
45where_link($u,$d,$Y,$ce="="){return"&where%5B$u%5D%5Bcol%5D=".urlencode($d)."&where%5B$u%5D%5Bop%5D=".urlencode(($Y!==null?$ce:"IS NULL"))."&where%5B$u%5D%5Bval%5D=".urlencode($Y);}function
46convert_fields($e,$o,$N=array()){$K="";foreach($e
47as$z=>$X){if($N&&!in_array(idf_escape($z),$N))continue;$ua=convert_field($o[$z]);if($ua)$K.=", $ua AS ".idf_escape($z);}return$K;}function
48cookie($F,$Y,$qd=2592000){global$ba;$te=array($F,(preg_match("~\n~",$Y)?"":$Y),($qd?time()+$qd:0),preg_replace('~\\?.*~','',$_SERVER["REQUEST_URI"]),"",$ba);if(version_compare(PHP_VERSION,'5.2.0')>=0)$te[]=true;return
49call_user_func_array('setcookie',$te);}function
50restart_session(){if(!ini_bool("session.use_cookies"))session_start();}function
51stop_session(){if(!ini_bool("session.use_cookies"))session_write_close();}function&get_session($z){return$_SESSION[$z][DRIVER][SERVER][$_GET["username"]];}function
52set_session($z,$X){$_SESSION[$z][DRIVER][SERVER][$_GET["username"]]=$X;}function
53auth_url($Mg,$O,$V,$k=null){global$Eb;preg_match('~([^?]*)\\??(.*)~',remove_from_uri(implode("|",array_keys($Eb))."|username|".($k!==null?"db|":"").session_name()),$C);return"$C[1]?".(sid()?SID."&":"").($Mg!="server"||$O!=""?urlencode($Mg)."=".urlencode($O)."&":"")."username=".urlencode($V).($k!=""?"&db=".urlencode($k):"").($C[2]?"&$C[2]":"");}function
54is_ajax(){return($_SERVER["HTTP_X_REQUESTED_WITH"]=="XMLHttpRequest");}function
55redirect($B,$D=null){if($D!==null){restart_session();$_SESSION["messages"][preg_replace('~^[^?]*~','',($B!==null?$B:$_SERVER["REQUEST_URI"]))][]=$D;}if($B!==null){if($B=="")$B=".";header("Location: $B");exit;}}function
56query_redirect($I,$B,$D,$Ye=true,$cc=true,$ic=false,$eg=""){global$g,$m,$c;if($cc){$Ff=microtime(true);$ic=!$g->query($I);$eg=format_time($Ff);}$Ef="";if($I)$Ef=$c->messageQuery($I,$eg);if($ic){$m=error().$Ef;return
57false;}if($Ye)redirect($B,$D.$Ef);return
58true;}function
59queries($I){global$g;static$Te=array();static$Ff;if(!$Ff)$Ff=microtime(true);if($I===null)return
60array(implode("\n",$Te),format_time($Ff));$Te[]=(preg_match('~;$~',$I)?"DELIMITER ;;\n$I;\nDELIMITER ":$I).";";return$g->query($I);}function
61apply_queries($I,$S,$Yb='table'){foreach($S
62as$Q){if(!queries("$I ".$Yb($Q)))return
63false;}return
64true;}function
65queries_redirect($B,$D,$Ye){list($Te,$eg)=queries(null);return
66query_redirect($Te,$B,$D,$Ye,false,!$Ye,$eg);}function
67format_time($Ff){return
68lang(1,max(0,microtime(true)-$Ff));}function
69remove_from_uri($se=""){return
70substr(preg_replace("~(?<=[?&])($se".(SID?"":"|".session_name()).")=[^&]*&~",'',"$_SERVER[REQUEST_URI]&"),0,-1);}function
71pagination($G,$nb){return" ".($G==$nb?$G+1:'<a href="'.h(remove_from_uri("page").($G?"&page=$G".($_GET["next"]?"&next=".urlencode($_GET["next"]):""):"")).'">'.($G+1)."</a>");}function
72get_file($z,$ub=false){$mc=$_FILES[$z];if(!$mc)return
73null;foreach($mc
74as$z=>$X)$mc[$z]=(array)$X;$K='';foreach($mc["error"]as$z=>$m){if($m)return$m;$F=$mc["name"][$z];$mg=$mc["tmp_name"][$z];$fb=file_get_contents($ub&&preg_match('~\\.gz$~',$F)?"compress.zlib://$mg":$mg);if($ub){$Ff=substr($fb,0,3);if(function_exists("iconv")&&preg_match("~^\xFE\xFF|^\xFF\xFE~",$Ff,$ef))$fb=iconv("utf-16","utf-8",$fb);elseif($Ff=="\xEF\xBB\xBF")$fb=substr($fb,3);$K.=$fb."\n\n";}else$K.=$fb;}return$K;}function
75upload_error($m){$_d=($m==UPLOAD_ERR_INI_SIZE?ini_get("upload_max_filesize"):0);return($m?lang(2).($_d?" ".lang(3,$_d):""):lang(4));}function
76repeat_pattern($Be,$od){return
77str_repeat("$Be{0,65535}",$od/65535)."$Be{0,".($od%65535)."}";}function
78is_utf8($X){return(preg_match('~~u',$X)&&!preg_match('~[\\0-\\x8\\xB\\xC\\xE-\\x1F]~',$X));}function
79shorten_utf8($Jf,$od=80,$Nf=""){if(!preg_match("(^(".repeat_pattern("[\t\r\n -\x{FFFF}]",$od).")($)?)u",$Jf,$C))preg_match("(^(".repeat_pattern("[\t\r\n -~]",$od).")($)?)",$Jf,$C);return
80h($C[1]).$Nf.(isset($C[2])?"":"<i>...</i>");}function
81format_number($X){return
82strtr(number_format($X,0,".",lang(5)),preg_split('~~u',lang(6),-1,PREG_SPLIT_NO_EMPTY));}function
83friendly_url($X){return
84preg_replace('~[^a-z0-9_]~i','-',$X);}function
85hidden_fields($Qe,$Lc=array()){while(list($z,$X)=each($Qe)){if(!in_array($z,$Lc)){if(is_array($X)){foreach($X
86as$bd=>$W)$Qe[$z."[$bd]"]=$W;}else
87echo'<input type="hidden" name="'.h($z).'" value="'.h($X).'">';}}}function
88hidden_fields_get(){echo(sid()?'<input type="hidden" name="'.session_name().'" value="'.h(session_id()).'">':''),(SERVER!==null?'<input type="hidden" name="'.DRIVER.'" value="'.h(SERVER).'">':""),'<input type="hidden" name="username" value="'.h($_GET["username"]).'">';}function
89table_status1($Q,$jc=false){$K=table_status($Q,$jc);return($K?$K:array("Name"=>$Q));}function
90column_foreign_keys($Q){global$c;$K=array();foreach($c->foreignKeys($Q)as$p){foreach($p["source"]as$X)$K[$X][]=$p;}return$K;}function
91enum_input($U,$wa,$n,$Y,$Sb=null){global$c;preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$vd);$K=($Sb!==null?"<label><input type='$U'$wa value='$Sb'".((is_array($Y)?in_array($Sb,$Y):$Y===0)?" checked":"")."><i>".lang(7)."</i></label>":"");foreach($vd[1]as$u=>$X){$X=stripcslashes(str_replace("''","'",$X));$Na=(is_int($Y)?$Y==$u+1:(is_array($Y)?in_array($u+1,$Y):$Y===$X));$K.=" <label><input type='$U'$wa value='".($u+1)."'".($Na?' checked':'').'>'.h($c->editVal($X,$n)).'</label>';}return$K;}function
92input($n,$Y,$r){global$g,$wg,$c,$y;$F=h(bracket_escape($n["field"]));echo"<td class='function'>";if(is_array($Y)&&!$r){$ta=array($Y);if(version_compare(PHP_VERSION,5.4)>=0)$ta[]=JSON_PRETTY_PRINT;$Y=call_user_func_array('json_encode',$ta);$r="json";}$gf=($y=="mssql"&&$n["auto_increment"]);if($gf&&!$_POST["save"])$r=null;$yc=(isset($_GET["select"])||$gf?array("orig"=>lang(8)):array())+$c->editFunctions($n);$wa=" name='fields[$F]'";if($n["type"]=="enum")echo
93nbsp($yc[""])."<td>".$c->editInput($_GET["edit"],$n,$wa,$Y);else{$pc=0;foreach($yc
94as$z=>$X){if($z===""||!$X)break;$pc++;}$ae=($pc?" onchange=\"var f = this.form['function[".h(js_escape(bracket_escape($n["field"])))."]']; if ($pc > f.selectedIndex) f.selectedIndex = $pc;\" onkeyup='keyupChange.call(this);'":"");$wa.=$ae;$Dc=(in_array($r,$yc)||isset($yc[$r]));echo(count($yc)>1?"<select name='function[$F]' onchange='functionChange(this);'".on_help("getTarget(event).value.replace(/^SQL\$/, '')",1).">".optionlist($yc,$r===null||$Dc?$r:"")."</select>":nbsp(reset($yc))).'<td>';$Qc=$c->editInput($_GET["edit"],$n,$wa,$Y);if($Qc!="")echo$Qc;elseif($n["type"]=="set"){preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$vd);foreach($vd[1]as$u=>$X){$X=stripcslashes(str_replace("''","'",$X));$Na=(is_int($Y)?($Y>>$u)&1:in_array($X,explode(",",$Y),true));echo" <label><input type='checkbox' name='fields[$F][$u]' value='".(1<<$u)."'".($Na?' checked':'')."$ae>".h($c->editVal($X,$n)).'</label>';}}elseif(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads"))echo"<input type='file' name='fields-$F'$ae>";elseif(($cg=preg_match('~text|lob~',$n["type"]))||preg_match("~\n~",$Y)){if($cg&&$y!="sqlite")$wa.=" cols='50' rows='12'";else{$M=min(12,substr_count($Y,"\n")+1);$wa.=" cols='30' rows='$M'".($M==1?" style='height: 1.2em;'":"");}echo"<textarea$wa>".h($Y).'</textarea>';}elseif($r=="json")echo"<textarea$wa cols='50' rows='12' class='jush-js'>".h($Y).'</textarea>';else{$Bd=(!preg_match('~int~',$n["type"])&&preg_match('~^(\\d+)(,(\\d+))?$~',$n["length"],$C)?((preg_match("~binary~",$n["type"])?2:1)*$C[1]+($C[3]?1:0)+($C[2]&&!$n["unsigned"]?1:0)):($wg[$n["type"]]?$wg[$n["type"]]+($n["unsigned"]?0:1):0));if($y=='sql'&&$g->server_info>=5.6&&preg_match('~time~',$n["type"]))$Bd+=7;echo"<input".((!$Dc||$r==="")&&preg_match('~(?<!o)int~',$n["type"])?" type='number'":"")." value='".h($Y)."'".($Bd?" maxlength='$Bd'":"").(preg_match('~char|binary~',$n["type"])&&$Bd>20?" size='40'":"")."$wa>";}}}function
95process_input($n){global$c;$Kc=bracket_escape($n["field"]);$r=$_POST["function"][$Kc];$Y=$_POST["fields"][$Kc];if($n["type"]=="enum"){if($Y==-1)return
96false;if($Y=="")return"NULL";return+$Y;}if($n["auto_increment"]&&$Y=="")return
97null;if($r=="orig")return($n["on_update"]=="CURRENT_TIMESTAMP"?idf_escape($n["field"]):false);if($r=="NULL")return"NULL";if($n["type"]=="set")return
98array_sum((array)$Y);if($r=="json"){$r="";$Y=json_decode($Y,true);if(!is_array($Y))return
99false;return$Y;}if(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads")){$mc=get_file("fields-$Kc");if(!is_string($mc))return
100false;return
101q($mc);}return$c->processInput($n,$Y,$r);}function
102fields_from_edit(){global$l;$K=array();foreach((array)$_POST["field_keys"]as$z=>$X){if($X!=""){$X=bracket_escape($X);$_POST["function"][$X]=$_POST["field_funs"][$z];$_POST["fields"][$X]=$_POST["field_vals"][$z];}}foreach((array)$_POST["fields"]as$z=>$X){$F=bracket_escape($z,1);$K[$F]=array("field"=>$F,"privileges"=>array("insert"=>1,"update"=>1),"null"=>1,"auto_increment"=>($z==$l->primary),);}return$K;}function
103search_tables(){global$c,$g;$_GET["where"][0]["op"]="LIKE %%";$_GET["where"][0]["val"]=$_POST["query"];$vc=false;foreach(table_status('',true)as$Q=>$R){$F=$c->tableName($R);if(isset($R["Engine"])&&$F!=""&&(!$_POST["tables"]||in_array($Q,$_POST["tables"]))){$J=$g->query("SELECT".limit("1 FROM ".table($Q)," WHERE ".implode(" AND ",$c->selectSearchProcess(fields($Q),array())),1));if(!$J||$J->fetch_row()){if(!$vc){echo"<ul>\n";$vc=true;}echo"<li>".($J?"<a href='".h(ME."select=".urlencode($Q)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]))."'>$F</a>\n":"$F: <span class='error'>".error()."</span>\n");}}}echo($vc?"</ul>":"<p class='message'>".lang(9))."\n";}function
104dump_headers($Jc,$Id=false){global$c;$K=$c->dumpHeaders($Jc,$Id);$qe=$_POST["output"];if($qe!="text")header("Content-Disposition: attachment; filename=".$c->dumpFilename($Jc).".$K".($qe!="file"&&!preg_match('~[^0-9a-z]~',$qe)?".$qe":""));session_write_close();ob_flush();flush();return$K;}function
105dump_csv($L){foreach($L
106as$z=>$X){if(preg_match("~[\"\n,;\t]~",$X)||$X==="")$L[$z]='"'.str_replace('"','""',$X).'"';}echo
107implode(($_POST["format"]=="csv"?",":($_POST["format"]=="tsv"?"\t":";")),$L)."\r\n";}function
108apply_sql_function($r,$d){return($r?($r=="unixepoch"?"DATETIME($d, '$r')":($r=="count distinct"?"COUNT(DISTINCT ":strtoupper("$r("))."$d)"):$d);}function
109get_temp_dir(){$K=ini_get("upload_tmp_dir");if(!$K){if(function_exists('sys_get_temp_dir'))$K=sys_get_temp_dir();else{$nc=@tempnam("","");if(!$nc)return
110false;$K=dirname($nc);unlink($nc);}}return$K;}function
111password_file($i){$nc=get_temp_dir()."/adminer.key";$K=@file_get_contents($nc);if($K||!$i)return$K;$q=@fopen($nc,"w");if($q){chmod($nc,0660);$K=rand_string();fwrite($q,$K);fclose($q);}return$K;}function
112rand_string(){return
113md5(uniqid(mt_rand(),true));}function
114select_value($X,$A,$n,$dg){global$c,$ba;if(is_array($X)){$K="";foreach($X
115as$bd=>$W)$K.="<tr>".($X!=array_values($X)?"<th>".h($bd):"")."<td>".select_value($W,$A,$n,$dg);return"<table cellspacing='0'>$K</table>";}if(!$A)$A=$c->selectLink($X,$n);if($A===null){if(is_mail($X))$A="mailto:$X";if($Se=is_url($X))$A=(($Se=="http"&&$ba)||preg_match('~WebKit~i',$_SERVER["HTTP_USER_AGENT"])?$X:"https://www.adminer.org/redirect/?url=".urlencode($X));}$K=$c->editVal($X,$n);if($K!==null){if($K==="")$K="&nbsp;";elseif(!is_utf8($K))$K="\0";elseif($dg!=""&&is_shortable($n))$K=shorten_utf8($K,max(0,+$dg));else$K=h($K);}return$c->selectVal($K,$A,$n,$X);}function
116is_mail($Pb){$va='[-a-z0-9!#$%&\'*+/=?^_`{|}~]';$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';$Be="$va+(\\.$va+)*@($Db?\\.)+$Db";return
117is_string($Pb)&&preg_match("(^$Be(,\\s*$Be)*\$)i",$Pb);}function
118is_url($Jf){$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';return(preg_match("~^(https?)://($Db?\\.)+$Db(:\\d+)?(/.*)?(\\?.*)?(#.*)?\$~i",$Jf,$C)?strtolower($C[1]):"");}function
119is_shortable($n){return
120preg_match('~char|text|lob|geometry|point|linestring|polygon|string~',$n["type"]);}function
121count_rows($Q,$Z,$Wc,$t){global$y;$I=" FROM ".table($Q).($Z?" WHERE ".implode(" AND ",$Z):"");return($Wc&&($y=="sql"||count($t)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$t).")$I":"SELECT COUNT(*)".($Wc?" FROM (SELECT 1$I$_c) x":$I));}function
122slow_query($I){global$c,$T;$k=$c->database();$fg=$c->queryTimeout();if(support("kill")&&is_object($h=connect())&&($k==""||$h->select_db($k))){$dd=$h->result("SELECT CONNECTION_ID()");echo'<script type="text/javascript">
123var timeout = setTimeout(function () {
124	ajax(\'',js_escape(ME),'script=kill\', function () {
125	}, \'token=',$T,'&kill=',$dd,'\');
126}, ',1000*$fg,');
127</script>
128';}else$h=null;ob_flush();flush();$K=@get_key_vals($I,$h,$fg);if($h){echo"<script type='text/javascript'>clearTimeout(timeout);</script>\n";ob_flush();flush();}return
129array_keys($K);}function
130get_token(){$We=rand(1,1e6);return($We^$_SESSION["token"]).":$We";}function
131verify_token(){list($T,$We)=explode(":",$_POST["token"]);return($We^$_SESSION["token"])==$T;}function
132lzw_decompress($Da){$_b=256;$Ea=8;$Ta=array();$hf=0;$if=0;for($u=0;$u<strlen($Da);$u++){$hf=($hf<<8)+ord($Da[$u]);$if+=8;if($if>=$Ea){$if-=$Ea;$Ta[]=$hf>>$if;$hf&=(1<<$if)-1;$_b++;if($_b>>$Ea)$Ea++;}}$zb=range("\0","\xFF");$K="";foreach($Ta
133as$u=>$Sa){$Ob=$zb[$Sa];if(!isset($Ob))$Ob=$Tg.$Tg[0];$K.=$Ob;if($u)$zb[]=$Tg.$Ob[0];$Tg=$Ob;}return$K;}function
134on_help($Za,$Af=0){return" onmouseover='helpMouseover(this, event, ".h($Za).", $Af);' onmouseout='helpMouseout(this, event);'";}function
135edit_form($b,$o,$L,$Dg){global$c,$y,$T,$m;$Sf=$c->tableName(table_status1($b,true));page_header(($Dg?lang(10):lang(11)),$m,array("select"=>array($b,$Sf)),$Sf);if($L===false)echo"<p class='error'>".lang(12)."\n";echo'<form action="" method="post" enctype="multipart/form-data" id="form">
136';if(!$o)echo"<p class='error'>".lang(13)."\n";else{echo"<table cellspacing='0' onkeydown='return editingKeydown(event);'>\n";foreach($o
137as$F=>$n){echo"<tr><th>".$c->fieldName($n);$vb=$_GET["set"][bracket_escape($F)];if($vb===null){$vb=$n["default"];if($n["type"]=="bit"&&preg_match("~^b'([01]*)'\$~",$vb,$ef))$vb=$ef[1];}$Y=($L!==null?($L[$F]!=""&&$y=="sql"&&preg_match("~enum|set~",$n["type"])?(is_array($L[$F])?array_sum($L[$F]):+$L[$F]):$L[$F]):(!$Dg&&$n["auto_increment"]?"":(isset($_GET["select"])?false:$vb)));if(!$_POST["save"]&&is_string($Y))$Y=$c->editVal($Y,$n);$r=($_POST["save"]?(string)$_POST["function"][$F]:($Dg&&$n["on_update"]=="CURRENT_TIMESTAMP"?"now":($Y===false?null:($Y!==null?'':'NULL'))));if(preg_match("~time~",$n["type"])&&$Y=="CURRENT_TIMESTAMP"){$Y="";$r="now";}input($n,$Y,$r);echo"\n";}if(!support("table"))echo"<tr>"."<th><input name='field_keys[]' onkeyup='keyupChange.call(this);' onchange='fieldChange(this);' value=''>"."<td class='function'>".html_select("field_funs[]",$c->editFunctions(array("null"=>isset($_GET["select"]))))."<td><input name='field_vals[]'>"."\n";echo"</table>\n";}echo"<p>\n";if($o){echo"<input type='submit' value='".lang(14)."'>\n";if(!isset($_GET["select"]))echo"<input type='submit' name='insert' value='".($Dg?lang(15)."' onclick='return !ajaxForm(this.form, \"".lang(16).'...", this)':lang(17))."' title='Ctrl+Shift+Enter'>\n";}echo($Dg?"<input type='submit' name='delete' value='".lang(18)."'".confirm().">\n":($_POST||!$o?"":"<script type='text/javascript'>focus(document.getElementById('form').getElementsByTagName('td')[1].firstChild);</script>\n"));if(isset($_GET["select"]))hidden_fields(array("check"=>(array)$_POST["check"],"clone"=>$_POST["clone"],"all"=>$_POST["all"]));echo'<input type="hidden" name="referer" value="',h(isset($_POST["referer"])?$_POST["referer"]:$_SERVER["HTTP_REFERER"]),'">
138<input type="hidden" name="save" value="1">
139<input type="hidden" name="token" value="',$T,'">
140</form>
141';}global$c,$g,$Eb,$Lb,$Vb,$m,$yc,$Ac,$ba,$Pc,$y,$a,$hd,$Zd,$Ce,$Kf,$Ec,$T,$rg,$wg,$Cg,$fa;if(!$_SERVER["REQUEST_URI"])$_SERVER["REQUEST_URI"]=$_SERVER["ORIG_PATH_INFO"];if(!strpos($_SERVER["REQUEST_URI"],'?')&&$_SERVER["QUERY_STRING"]!="")$_SERVER["REQUEST_URI"].="?$_SERVER[QUERY_STRING]";$ba=$_SERVER["HTTPS"]&&strcasecmp($_SERVER["HTTPS"],"off");@ini_set("session.use_trans_sid",false);session_cache_limiter("");if(!defined("SID")){session_name("adminer_sid");$te=array(0,preg_replace('~\\?.*~','',$_SERVER["REQUEST_URI"]),"",$ba);if(version_compare(PHP_VERSION,'5.2.0')>=0)$te[]=true;call_user_func_array('session_set_cookie_params',$te);session_start();}remove_slashes(array(&$_GET,&$_POST,&$_COOKIE),$oc);if(get_magic_quotes_runtime())set_magic_quotes_runtime(false);@set_time_limit(0);@ini_set("zend.ze1_compatibility_mode",false);@ini_set("precision",20);$hd=array('en'=>'English','ar'=>'العربية','bg'=>'Български','bn'=>'বাংলা','ca'=>'Català','cs'=>'Čeština','da'=>'Dansk','de'=>'Deutsch','el'=>'Ελληνικά','es'=>'Español','et'=>'Eesti','fa'=>'فارسی','fr'=>'Français','gl'=>'Galego','hu'=>'Magyar','id'=>'Bahasa Indonesia','it'=>'Italiano','ja'=>'日本語','ko'=>'한국어','lt'=>'Lietuvių','nl'=>'Nederlands','no'=>'Norsk','pl'=>'Polski','pt'=>'Português','pt-br'=>'Português (Brazil)','ro'=>'Limba Română','ru'=>'Русский язык','sk'=>'Slovenčina','sl'=>'Slovenski','sr'=>'Српски','ta'=>'த‌மிழ்','th'=>'ภาษาไทย','tr'=>'Türkçe','uk'=>'Українська','vi'=>'Tiếng Việt','zh'=>'简体中文','zh-tw'=>'繁體中文',);function
142get_lang(){global$a;return$a;}function
143lang($Kc,$Qd=null){if(is_string($Kc)){$Fe=array_search($Kc,get_translations("en"));if($Fe!==false)$Kc=$Fe;}global$a,$rg;$qg=($rg[$Kc]?$rg[$Kc]:$Kc);if(is_array($qg)){$Fe=($Qd==1?0:($a=='cs'||$a=='sk'?($Qd&&$Qd<5?1:2):($a=='fr'?(!$Qd?0:1):($a=='pl'?($Qd%10>1&&$Qd%10<5&&$Qd/10%10!=1?1:2):($a=='sl'?($Qd%100==1?0:($Qd%100==2?1:($Qd%100==3||$Qd%100==4?2:3))):($a=='lt'?($Qd%10==1&&$Qd%100!=11?0:($Qd%10>1&&$Qd/10%10!=1?1:2)):($a=='ru'||$a=='sr'||$a=='uk'?($Qd%10==1&&$Qd%100!=11?0:($Qd%10>1&&$Qd%10<5&&$Qd/10%10!=1?1:2)):1)))))));$qg=$qg[$Fe];}$ta=func_get_args();array_shift($ta);$uc=str_replace("%d","%s",$qg);if($uc!=$qg)$ta[0]=format_number($Qd);return
144vsprintf($uc,$ta);}function
145switch_lang(){global$a,$hd;echo"<form action='' method='post'>\n<div id='lang'>",lang(19).": ".html_select("lang",$hd,$a,"this.form.submit();")," <input type='submit' value='".lang(20)."' class='hidden'>\n","<input type='hidden' name='token' value='".get_token()."'>\n";echo"</div>\n</form>\n";}if(isset($_POST["lang"])&&verify_token()){cookie("adminer_lang",$_POST["lang"]);$_SESSION["lang"]=$_POST["lang"];$_SESSION["esult(){if(!$this->_result)return
146false;$this->_result->_offset=0;return@$this->_result->nextRowset();}function
147result($I,$n=0){$J=$this->query($I);if(!$J)return
148false;$L=$J->fetch();return$L[$n];}}class
149Min_PDOStatement
150extends
151PDOStatement{var$_offset=0,$num_rows;function
152fetch_assoc(){return$this->fetch(2);}function
153fetch_row(){return$this->fetch(3);}function
154fetch_field(){$L=(object)$this->getColumnMeta($this->_offset++);$L->orgtable=$L->table;$L->orgname=$L->name;$L->charsetnr=(in_array("blob",(array)$L->flags)?63:0);return$L;}}}$Eb=array();class
155Min_SQL{var$_conn;function
156__construct($g){$this->_conn=$g;}function
157select($Q,$N,$Z,$t,$he=array(),$_=1,$G=0,$Me=false){global$c,$y;$Wc=(count($t)<count($N));$I=$c->selectQueryBuild($N,$Z,$t,$he,$_,$G);if(!$I)$I="SELECT".limit(($_GET["page"]!="last"&&+$_&&$t&&$Wc&&$y=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$N)."\nFROM ".table($Q),($Z?"\nWHERE ".implode(" AND ",$Z):"").($t&&$Wc?"\nGROUP BY ".implode(", ",$t):"").($he?"\nORDER BY ".implode(", ",$he):""),($_!=""?+$_:null),($G?$_*$G:0),"\n");$Ff=microtime(true);$K=$this->_conn->query($I);if($Me)echo$c->selectQuery($I,format_time($Ff));return$K;}function
158delete($Q,$Ue,$_=0){$I="FROM ".table($Q);return
159queries("DELETE".($_?limit1($I,$Ue):" $I$Ue"));}function
160update($Q,$P,$Ue,$_=0,$wf="\n"){$Kg=array();foreach($P
161as$z=>$X)$Kg[]="$z = $X";$I=table($Q)." SET$wf".implode(",$wf",$Kg);return
162queries("UPDATE".($_?limit1($I,$Ue):" $I$Ue"));}function
163insert($Q,$P){return
164queries("INSERT INTO ".table($Q).($P?" (".implode(", ",array_keys($P)).")\nVALUES (".implode(", ",$P).")":" DEFAULT VALUES"));}function
165insertUpdate($Q,$M,$Le){return
166false;}function
167begin(){return
168queries("BEGIN");}function
169commit(){return
170queries("COMMIT");}function
171rollback(){return
172queries("ROLLBACK");}}$Eb=array("server"=>"MySQL")+$Eb;if(!defined("DRIVER")){$Ie=array("MySQLi","MySQL","PDO_MySQL");define("DRIVER","server");if(extension_loaded("mysqli")){class
173Min_DB
174extends
175MySQLi{var$extension="MySQLi";function
176__construct(){parent::init();}function
177connect($O,$V,$_e){mysqli_report(MYSQLI_REPORT_OFF);list($Hc,$Ee)=explode(":",$O,2);$K=@$this->real_connect(($O!=""?$Hc:ini_get("mysqli.default_host")),($O.$V!=""?$V:ini_get("mysqli.default_user")),($O.$V.$_e!=""?$_e:ini_get("mysqli.default_pw")),null,(is_numeric($Ee)?$Ee:ini_get("mysqli.default_port")),(!is_numeric($Ee)?$Ee:null));return$K;}function
178set_charset($La){if(parent::set_charset($La))return
179true;parent::set_charset('utf8');return$this->query("SET NAMES $La");}function
180result($I,$n=0){$J=$this->query($I);if(!$J)return
181false;$L=$J->fetch_array();return$L[$n];}function
182quote($Jf){return"'".$this->escape_string($Jf)."'";}}}elseif(extension_loaded("mysql")&&!(ini_get("sql.safe_mode")&&extension_loaded("pdo_mysql"))){class
183Min_DB{var$extension="MySQL",$server_info,$affected_rows,$errno,$error,$_link,$_result;function
184connect($O,$V,$_e){$this->_link=@mysql_connect(($O!=""?$O:ini_get("mysql.default_host")),("$O$V"!=""?$V:ini_get("mysql.default_user")),("$O$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
185set_charset($La){if(function_exists('mysql_set_charset')){if(mysql_set_charset($La,$this->_link))return
186true;mysql_set_charset('utf8',$this->_link);}return$this->query("SET NAMES $La");}function
187quote($Jf){return"'".mysql_real_escape_string($Jf,$this->_link)."'";}function
188select_db($qb){return
189mysql_select_db($qb,$this->_link);}function
190query($I,$xg=false){$J=@($xg?mysql_unbuffered_query($I,$this->_link):mysql_query($I,$this->_link));$this->error="";if(!$J){$this->errno=mysql_errno($this->_link);$this->error=mysql_error($this->_link);return
191false;}if($J===true){$this->affected_rows=mysql_affected_rows($this->_link);$this->info=mysql_info($this->_link);return
192true;}return
193new
194Min_Result($J);}function
195multi_query($I){return$this->_result=$this->query($I);}function
196store_result(){return$this->_result;}function
197next_result(){return
198false;}function
199result($I,$n=0){$J=$this->query($I);if(!$J||!$J->num_rows)return
200false;return
201mysql_result($J->_result,0,$n);}}class
202Min_Result{var$num_rows,$_result,$_offset=0;function
203__construct($J){$this->_result=$J;$this->num_rows=mysql_num_rows($J);}function
204fetch_assoc(){return
205mysql_fetch_assoc($this->_result);}function
206fetch_row(){return
207mysql_fetch_row($this->_result);}function
208fetch_field(){$K=mysql_fetch_field($this->_result,$this->_offset++);$K->orgtable=$K->table;$K->orgname=$K->name;$K->charsetnr=($K->blob?63:0);return$K;}function
209__destruct(){mysql_free_result($this->_result);}}}elseif(extension_loaded("pdo_mysql")){class
210Min_DB
211extends
212Min_PDO{var$extension="PDO_MySQL";function
213connect($O,$V,$_e){$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\\d)~',';port=\\1',$O)),$V,$_e);return
214true;}function
215set_charset($La){$this->query("SET NAMES $La");}function
216select_db($qb){return$this->query("USE ".idf_escape($qb));}function
217query($I,$xg=false){$this->setAttribute(1000,!$xg);return
218parent::query($I,$xg);}}}class
219Min_Driver
220extends
221Min_SQL{function
222insert($Q,$P){return($P?parent::insert($Q,$P):queries("INSERT INTO ".table($Q)." ()\nVALUES ()"));}function
223insertUpdate($Q,$M,$Le){$e=array_keys(reset($M));$Je="INSERT INTO ".table($Q)." (".implode(", ",$e).") VALUES\n";$Kg=array();foreach($e
224as$z)$Kg[$z]="$z = VALUES($z)";$Nf="\nON DUPLICATE KEY UPDATE ".implode(", ",$Kg);$Kg=array();$od=0;foreach($M
225as$P){$Y="(".implode(", ",$P).")";if($Kg&&(strlen($Je)+$od+strlen($Y)+strlen($Nf)>1e6)){if(!queries($Je.implode(",\n",$Kg).$Nf))return
226false;$Kg=array();$od=0;}$Kg[]=$Y;$od+=strlen($Y)+2;}return
227queries($Je.implode(",\n",$Kg).$Nf);}}function
228idf_escape($Kc){return"`".str_replace("`","``",$Kc)."`";}function
229table($Kc){return
230idf_escape($Kc);}function
231connect(){global$c;$g=new
232Min_DB;$mb=$c->credentials();if($g->connect($mb[0],$mb[1],$mb[2])){$g->set_charset(charset($g));$g->query("SET sql_quote_show_create = 1, autocommit = 1");return$g;}$K=$g->error;if(function_exists('iconv')&&!is_utf8($K)&&strlen($pf=iconv("windows-1250","utf-8",$K))>strlen($K))$K=$pf;return$K;}function
233get_databases($qc){global$g;$K=get_session("dbs");if($K===null){$I=($g->server_info>=5?"SELECT SCHEMA_NAME FROM information_schema.SCHEMATA":"SHOW DATABASES");$K=($qc?slow_query($I):get_vals($I));restart_session();set_session("dbs",$K);stop_session();}return$K;}function
234limit($I,$Z,$_,$Sd=0,$wf=" "){return" $I$Z".($_!==null?$wf."LIMIT $_".($Sd?" OFFSET $Sd":""):"");}function
235limit1($I,$Z){return
236limit($I,$Z,1);}function
237db_collation($k,$Xa){global$g;$K=null;$i=$g->result("SHOW CREATE DATABASE ".idf_escape($k),1);if(preg_match('~ COLLATE ([^ ]+)~',$i,$C))$K=$C[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$i,$C))$K=$Xa[$C[1]][-1];return$K;}function
238engines(){$K=array();foreach(get_rows("SHOW ENGINES")as$L){if(preg_match("~YES|DEFAULT~",$L["Support"]))$K[]=$L["Engine"];}return$K;}function
239logged_user(){global$g;return$g->result("SELECT USER()");}function
240tables_list(){global$g;return
241get_key_vals($g->server_info>=5?"SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME":"SHOW TABLES");}function
242count_tables($j){$K=array();foreach($j
243as$k)$K[$k]=count(get_vals("SHOW TABLES IN ".idf_escape($k)));return$K;}function
244table_status($F="",$jc=false){global$g;$K=array();foreach(get_rows($jc&&$g->server_info>=5?"SELECT TABLE_NAME AS Name, Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($F!=""?"AND TABLE_NAME = ".q($F):"ORDER BY Name"):"SHOW TABLE STATUS".($F!=""?" LIKE ".q(addcslashes($F,"%_\\")):""))as$L){if($L["Engine"]=="InnoDB")$L["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\\1',$L["Comment"]);if(!isset($L["Engine"]))$L["Comment"]="";if($F!="")return$L;$K[$L["Name"]]=$L;}return$K;}function
245is_view($R){return$R["Engine"]===null;}function
246fk_support($R){global$g;return
247preg_match('~InnoDB|IBMDB2I~i',$R["Engine"])||(preg_match('~NDB~i',$R["Engine"])&&version_compare($g->server_info,'5.6')>=0);}function
248fields($Q){$K=array();foreach(get_rows("SHOW FULL COLUMNS FROM ".table($Q))as$L){preg_match('~^([^( ]+)(?:\\((.+)\\))?( unsigned)?( zerofill)?$~',$L["Type"],$C);$K[$L["Field"]]=array("field"=>$L["Field"],"full_type"=>$L["Type"],"type"=>$C[1],"length"=>$C[2],"unsigned"=>ltrim($C[3].$C[4]),"default"=>($L["Default"]!=""||preg_match("~char|set~",$C[1])?$L["Default"]:null),"null"=>($L["Null"]=="YES"),"auto_increment"=>($L["Extra"]=="auto_increment"),"on_update"=>(preg_match('~^on update (.+)~i',$L["Extra"],$C)?$C[1]:""),"collation"=>$L["Collation"],"privileges"=>array_flip(preg_split('~, *~',$L["Privileges"])),"comment"=>$L["Comment"],"primary"=>($L["Key"]=="PRI"),);}return$K;}function
249indexes($Q,$h=null){$K=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$h)as$L){$K[$L["Key_name"]]["type"]=($L["Key_name"]=="PRIMARY"?"PRIMARY":($L["Index_type"]=="FULLTEXT"?"FULLTEXT":($L["Non_unique"]?"INDEX":"UNIQUE")));$K[$L["Key_name"]]["columns"][]=$L["Column_name"];$K[$L["Key_name"]]["lengths"][]=$L["Sub_part"];$K[$L["Key_name"]]["descs"][]=null;}return$K;}function
250foreign_keys($Q){global$g,$Zd;static$Be='`(?:[^`]|``)+`';$K=array();$kb=$g->result("SHOW CREATE TABLE ".table($Q),1);if($kb){preg_match_all("~CONSTRAINT ($Be) FOREIGN KEY ?\\(((?:$Be,? ?)+)\\) REFERENCES ($Be)(?:\\.($Be))? \\(((?:$Be,? ?)+)\\)(?: ON DELETE ($Zd))?(?: ON UPDATE ($Zd))?~",$kb,$vd,PREG_SET_ORDER);foreach($vd
251as$C){preg_match_all("~$Be~",$C[2],$Cf);preg_match_all("~$Be~",$C[5],$Yf);$K[idf_unescape($C[1])]=array("db"=>idf_unescape($C[4]!=""?$C[3]:$C[4]),"table"=>idf_unescape($C[4]!=""?$C[4]:$C[3]),"source"=>array_map('idf_unescape',$Cf[0]),"target"=>array_map('idf_unescape',$Yf[0]),"on_delete"=>($C[6]?$C[6]:"RESTRICT"),"on_update"=>($C[7]?$C[7]:"RESTRICT"),);}}return$K;}function
252view($F){global$g;return
253array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\\s+AS\\s+~isU','',$g->result("SHOW CREATE VIEW ".table($F),1)));}function
254collations(){$K=array();foreach(get_rows("SHOW COLLATION")as$L){if($L["Default"])$K[$L["Charset"]][-1]=$L["Collation"];else$K[$L["Charset"]][]=$L["Collation"];}ksort($K);foreach($K
255as$z=>$X)asort($K[$z]);return$K;}function
256information_schema($k){global$g;return($g->server_info>=5&&$k=="information_schema")||($g->server_info>=5.5&&$k=="performance_schema");}function
257error(){global$g;return
258h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",$g->error));}function
259error_line(){global$g;if(preg_match('~ at line ([0-9]+)$~',$g->error,$ef))return$ef[1]-1;}function
260create_database($k,$Wa){return
261queries("CREATE DATABASE ".idf_escape($k).($Wa?" COLLATE ".q($Wa):""));}function
262drop_databases($j){$K=apply_queries("DROP DATABASE",$j,'idf_escape');restart_session();set_session("dbs",null);return$K;}function
263rename_database($F,$Wa){$K=false;if(create_database($F,$Wa)){$ff=array();foreach(tables_list()as$Q=>$U)$ff[]=table($Q)." TO ".idf_escape($F).".".table($Q);$K=(!$ff||queries("RENAME TABLE ".implode(", ",$ff)));if($K)queries("DROP DATABASE ".idf_escape(DB));restart_session();set_session("dbs",null);}return$K;}function
264auto_increment(){$za=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$w){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$w["columns"],true)){$za="";break;}if($w["type"]=="PRIMARY")$za=" UNIQUE";}}return" AUTO_INCREMENT$za";}function
265alter_table($Q,$F,$o,$rc,$bb,$Tb,$Wa,$ya,$xe){$sa=array();foreach($o
266as$n)$sa[]=($n[1]?($Q!=""?($n[0]!=""?"CHANGE ".idf_escape($n[0]):"ADD"):" ")." ".implode($n[1]).($Q!=""?$n[2]:""):"DROP ".idf_escape($n[0]));$sa=array_merge($sa,$rc);$Gf=($bb!==null?" COMMENT=".q($bb):"").($Tb?" ENGINE=".q($Tb):"").($Wa?" COLLATE ".q($Wa):"").($ya!=""?" AUTO_INCREMENT=$ya":"");if($Q=="")return
267queries("CREATE TABLE ".table($F)." (\n".implode(",\n",$sa)."\n)$Gf$xe");if($Q!=$F)$sa[]="RENAME TO ".table($F);if($Gf)$sa[]=ltrim($Gf);return($sa||$xe?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$sa).$xe):true);}function
268alter_indexes($Q,$sa){foreach($sa
269as$z=>$X)$sa[$z]=($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
270queries("ALTER TABLE ".table($Q).implode(",",$sa));}function
271truncate_tables($S){return
272apply_queries("TRUNCATE TABLE",$S);}function
273drop_views($Og){return
274queries("DROP VIEW ".implode(", ",array_map('table',$Og)));}function
275drop_tables($S){return
276queries("DROP TABLE ".implode(", ",array_map('table',$S)));}function
277move_tables($S,$Og,$Yf){$ff=array();foreach(array_merge($S,$Og)as$Q)$ff[]=table($Q)." TO ".idf_escape($Yf).".".table($Q);return
278queries("RENAME TABLE ".implode(", ",$ff));}function
279copy_tables($S,$Og,$Yf){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($S
280as$Q){$F=($Yf==DB?table("copy_$Q"):idf_escape($Yf).".".table($Q));if(!queries("\nDROP TABLE IF EXISTS $F")||!queries("CREATE TABLE $F LIKE ".table($Q))||!queries("INSERT INTO $F SELECT * FROM ".table($Q)))return
281false;}foreach($Og
282as$Q){$F=($Yf==DB?table("copy_$Q"):idf_escape($Yf).".".table($Q));$Ng=view($Q);if(!queries("DROP VIEW IF EXISTS $F")||!queries("CREATE VIEW $F AS $Ng[select]"))return
283false;}return
284true;}function
285trigger($F){if($F=="")return
286array();$M=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($F));return
287reset($M);}function
288triggers($Q){$K=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$L)$K[$L["Trigger"]]=array($L["Timing"],$L["Event"]);return$K;}function
289trigger_options(){return
290array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
291routine($F,$U){global$g,$Vb,$Pc,$wg;$qa=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$vg="((".implode("|",array_merge(array_keys($wg),$qa)).")\\b(?:\\s*\\(((?:[^'\")]|$Vb)++)\\))?\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$Be="\\s*(".($U=="FUNCTION"?"":$Pc).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$vg";$i=$g->result("SHOW CREATE $U ".idf_escape($F),2);preg_match("~\\(((?:$Be\\s*,?)*)\\)\\s*".($U=="FUNCTION"?"RETURNS\\s+$vg\\s+":"")."(.*)~is",$i,$C);$o=array();preg_match_all("~$Be\\s*,?~is",$C[1],$vd,PREG_SET_ORDER);foreach($vd
292as$se){$F=str_replace("``","`",$se[2]).$se[3];$o[]=array("field"=>$F,"type"=>strtolower($se[5]),"length"=>preg_replace_callback("~$Vb~s",'normalize_enum',$se[6]),"unsigned"=>strtolower(preg_replace('~\\s+~',' ',trim("$se[8] $se[7]"))),"null"=>1,"full_type"=>$se[4],"inout"=>strtoupper($se[1]),"collation"=>strtolower($se[9]),);}if($U!="FUNCTION")return
293array("fields"=>$o,"definition"=>$C[11]);return
294array("fields"=>$o,"returns"=>array("type"=>$C[12],"length"=>$C[13],"unsigned"=>$C[15],"collation"=>$C[16]),"definition"=>$C[17],"language"=>"SQL",);}function
295routines(){return
296get_rows("SELECT ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ".q(DB));}function
297routine_languages(){return
298array();}function
299last_id(){global$g;return$g->result("SELECT LAST_INSERT_ID()");}function
300explain($g,$I){return$g->query("EXPLAIN ".($g->server_info>=5.1?"PARTITIONS ":"").$I);}function
301found_rows($R,$Z){return($Z||$R["Engine"]!="InnoDB"?null:$R["Rows"]);}function
302types(){return
303array();}function
304schemas(){return
305array();}function
306get_schema(){return"";}function
307set_schema($rf){return
308true;}function
309create_sql($Q,$ya){global$g;$K=$g->result("SHOW CREATE TABLE ".table($Q),1);if(!$ya)$K=preg_replace('~ AUTO_INCREMENT=\\d+~','',$K);return$K;}function
310truncate_sql($Q){return"TRUNCATE ".table($Q);}function
311use_sql($qb){return"USE ".idf_escape($qb);}function
312trigger_sql($Q,$Lf){$K="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$L)$K.="\n".($Lf=='CREATE+ALTER'?"DROP TRIGGER IF EXISTS ".idf_escape($L["Trigger"]).";;\n":"")."CREATE TRIGGER ".idf_escape($L["Trigger"])." $L[Timing] $L[Event] ON ".table($L["Table"])." FOR EACH ROW\n$L[Statement];;\n";return$K;}function
313show_variables(){return
314get_key_vals("SHOW VARIABLES");}function
315process_list(){return
316get_rows("SHOW FULL PROCESSLIST");}function
317show_status(){return
318get_key_vals("SHOW STATUS");}function
319convert_field($n){if(preg_match("~binary~",$n["type"]))return"HEX(".idf_escape($n["field"]).")";if($n["type"]=="bit")return"BIN(".idf_escape($n["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$n["type"]))return"AsWKT(".idf_escape($n["field"]).")";}function
320unconvert_field($n,$K){if(preg_match("~binary~",$n["type"]))$K="UNHEX($K)";if($n["type"]=="bit")$K="CONV($K, 2, 10) + 0";if(preg_match("~geometry|point|linestring|polygon~",$n["type"]))$K="GeomFromText($K)";return$K;}function
321support($kc){global$g;return!preg_match("~scheme|sequence|type|view_trigger".($g->server_info<5.1?"|event|partitioning".($g->server_info<5?"|routine|trigger|view":""):"")."~",$kc);}$y="sql";$wg=array();$Kf=array();foreach(array(lang(21)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(22)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(23)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(24)=>array("enum"=>65535,"set"=>64),lang(25)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(26)=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),)as$z=>$X){$wg+=$X;$Kf[$z]=array_keys($X);}$Cg=array("unsigned","zerofill","unsigned zerofill");$de=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL");$yc=array("char_length","date","from_unixtime","lower","round","sec_to_time","time_to_sec","upper");$Ac=array("avg","count","count distinct","group_concat","max","min","sum");$Lb=array(array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",),array("(^|[^o])int|float|double|decimal"=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",));}define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~^[^?]*/([^?]*).*~','\\1',$_SERVER["REQUEST_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"])."&":""):''));$fa="4.2.3";class
322Adminer{var$operators;function
323name(){return"<a href='https://www.adminer.org/' target='_blank' id='h1'>Adminer</a>";}function
324credentials(){return
325array(SERVER,$_GET["username"],get_password());}function
326permanentLogin($i=false){return
327password_file($i);}function
328bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
329database(){return
330DB;}function
331databases($qc=true){return
332get_databases($qc);}function
333schemas(){return
334schemas();}function
335queryTimeout(){return
3365;}function
337headers(){return
338true;}function
339head(){return
340true;}function
341loginForm(){global$Eb;echo'<table cellspacing="0">
342<tr><th>',lang(27),'<td>',html_select("auth[driver]",$Eb,DRIVER,"loginDriver(this);"),'<tr><th>',lang(28),'<td><input name="auth[server]" value="',h(SERVER),'" title="hostname[:port]" placeholder="localhost" autocapitalize="off">
343<tr><th>',lang(29),'<td><input name="auth[username]" id="username" value="',h($_GET["username"]),'" autocapitalize="off">
344<tr><th>',lang(30),'<td><input type="password" name="auth[password]">
345<tr><th>',lang(31),'<td><input name="auth[db]" value="',h($_GET["db"]);?>" autocapitalize="off">
346</table>
347<script type="text/javascript">
348var username = document.getElementById('username');
349focus(username);
350username.form['auth[driver]'].onchange();
351</script>
352<?php
353
354echo"<p><input type='submit' value='".lang(32)."'>\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],lang(33))."\n";}function
355login($td,$_e){return
356true;}function
357tableName($Rf){return
358h($Rf["Name"]);}function
359fieldName($n,$he=0){return'<span title="'.h($n["full_type"]).'">'.h($n["field"]).'</span>';}function
360selectLinks($Rf,$P=""){echo'<p class="links">';$sd=array("select"=>lang(34));if(support("table")||support("indexes"))$sd["table"]=lang(35);if(support("table")){if(is_view($Rf))$sd["view"]=lang(36);else$sd["create"]=lang(37);}if($P!==null)$sd["edit"]=lang(38);foreach($sd
361as$z=>$X)echo" <a href='".h(ME)."$z=".urlencode($Rf["Name"]).($z=="edit"?$P:"")."'".bold(isset($_GET[$z])).">$X</a>";echo"\n";}function
362foreignKeys($Q){return
363foreign_keys($Q);}function
364backwardKeys($Q,$Qf){return
365array();}function
366backwardKeysPrint($Aa,$L){}function
367selectQuery($I,$eg){global$y;return"<p><code class='jush-$y'>".h(str_replace("\n"," ",$I))."</code> <span class='time'>($eg)</span>".(support("sql")?" <a href='".h(ME)."sql=".urlencode($I)."'>".lang(10)."</a>":"")."</p>";}function
368rowDescription($Q){return"";}function
369rowDescriptions($M,$sc){return$M;}function
370selectLink($X,$n){}function
371selectVal($X,$A,$n,$oe){$K=($X===null?"<i>NULL</i>":(preg_match("~char|binary~",$n["type"])&&!preg_match("~var~",$n["type"])?"<code>$X</code>":$X));if(preg_match('~blob|bytea|raw|file~',$n["type"])&&!is_utf8($X))$K=lang(39,strlen($oe));return($A?"<a href='".h($A)."'".(is_url($A)?" rel='noreferrer'":"").">$K</a>":$K);}function
372editVal($X,$n){return$X;}function
373selectColumnsPrint($N,$e){global$yc,$Ac;print_fieldset("select",lang(40),$N);$u=0;$N[""]=array();foreach($N
374as$z=>$X){$X=$_GET["columns"][$z];$d=select_input(" name='columns[$u][col]' onchange='".($z!==""?"selectFieldChange(this.form)":"selectAddRow(this)").";'",$e,$X["col"]);echo"<div>".($yc||$Ac?"<select name='columns[$u][fun]' onchange='helpClose();".($z!==""?"":" this.nextSibling.nextSibling.onchange();")."'".on_help("getTarget(event).value && getTarget(event).value.replace(/ |\$/, '(') + ')'",1).">".optionlist(array(-1=>"")+array_filter(array(lang(41)=>$yc,lang(42)=>$Ac)),$X["fun"])."</select>"."($d)":$d)."</div>\n";$u++;}echo"</div></fieldset>\n";}function
375selectSearchPrint($Z,$e,$x){print_fieldset("search",lang(43),$Z);foreach($x
376as$u=>$w){if($w["type"]=="FULLTEXT"){echo"(<i>".implode("</i>, <i>",array_map('h',$w["columns"]))."</i>) AGAINST"," <input type='search' name='fulltext[$u]' value='".h($_GET["fulltext"][$u])."' onchange='selectFieldChange(this.form);'>",checkbox("boolean[$u]",1,isset($_GET["boolean"][$u]),"BOOL"),"<br>\n";}}$_GET["where"]=(array)$_GET["where"];reset($_GET["where"]);$Ka="this.nextSibling.onchange();";for($u=0;$u<=count($_GET["where"]);$u++){list(,$X)=each($_GET["where"]);if(!$X||("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators))){echo"<div>".select_input(" name='where[$u][col]' onchange='$Ka'",$e,$X["col"],"(".lang(44).")"),html_select("where[$u][op]",$this->operators,$X["op"],$Ka),"<input type='search' name='where[$u][val]' value='".h($X["val"])."' onchange='".($X?"selectFieldChange(this.form)":"selectAddRow(this)").";' onkeydown='selectSearchKeydown(this, event);' onsearch='selectSearchSearch(this);'></div>\n";}}echo"</div></fieldset>\n";}function
377selectOrderPrint($he,$e,$x){print_fieldset("sort",lang(45),$he);$u=0;foreach((array)$_GET["order"]as$z=>$X){if($X!=""){echo"<div>".select_input(" name='order[$u]' onchange='selectFieldChange(this.form);'",$e,$X),checkbox("desc[$u]",1,isset($_GET["desc"][$z]),lang(46))."</div>\n";$u++;}}echo"<div>".select_input(" name='order[$u]' onchange='selectAddRow(this);'",$e),checkbox("desc[$u]",1,false,lang(46))."</div>\n","</div></fieldset>\n";}function
378selectLimitPrint($_){echo"<fieldset><legend>".lang(47)."</legend><div>";echo"<input type='number' name='limit' class='size' value='".h($_)."' onchange='selectFieldChange(this.form);'>","</div></fieldset>\n";}function
379selectLengthPrint($dg){if($dg!==null){echo"<fieldset><legend>".lang(48)."</legend><div>","<input type='number' name='text_length' class='size' value='".h($dg)."'>","</div></fieldset>\n";}}function
380selectActionPrint($x){echo"<fieldset><legend>".lang(49)."</legend><div>","<input type='submit' value='".lang(40)."'>"," <span id='noindex' title='".lang(50)."'></span>","<script type='text/javascript'>\n","var indexColumns = ";$e=array();foreach($x
381as$w){if($w["type"]!="FULLTEXT")$e[reset($w["columns"])]=1;}$e[""]=1;foreach($e
382as$z=>$X)json_row($z);echo";\n","selectFieldChange(document.getElementById('form'));\n","</script>\n","</div></fieldset>\n";}function
383selectCommandPrint(){return!information_schema(DB);}function
384selectImportPrint(){return!information_schema(DB);}function
385selectEmailPrint($Qb,$e){}function
386selectColumnsProcess($e,$x){global$yc,$Ac;$N=array();$t=array();foreach((array)$_GET["columns"]as$z=>$X){if($X["fun"]=="count"||($X["col"]!=""&&(!$X["fun"]||in_array($X["fun"],$yc)||in_array($X["fun"],$Ac)))){$N[$z]=apply_sql_function($X["fun"],($X["col"]!=""?idf_escape($X["col"]):"*"));if(!in_array($X["fun"],$Ac))$t[]=$N[$z];}}return
387array($N,$t);}function
388selectSearchProcess($o,$x){global$g,$y;$K=array();foreach($x
389as$u=>$w){if($w["type"]=="FULLTEXT"&&$_GET["fulltext"][$u]!="")$K[]="MATCH (".implode(", ",array_map('idf_escape',$w["columns"])).") AGAINST (".q($_GET["fulltext"][$u]).(isset($_GET["boolean"][$u])?" IN BOOLEAN MODE":"").")";}foreach((array)$_GET["where"]as$X){if("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators)){$db=" $X[op]";if(preg_match('~IN$~',$X["op"])){$Mc=process_length($X["val"]);$db.=" ".($Mc!=""?$Mc:"(NULL)");}elseif($X["op"]=="SQL")$db=" $X[val]";elseif($X["op"]=="LIKE %%")$db=" LIKE ".$this->processInput($o[$X["col"]],"%$X[val]%");elseif($X["op"]=="ILIKE %%")$db=" ILIKE ".$this->processInput($o[$X["col"]],"%$X[val]%");elseif(!preg_match('~NULL$~',$X["op"]))$db.=" ".$this->processInput($o[$X["col"]],$X["val"]);if($X["col"]!="")$K[]=idf_escape($X["col"]).$db;else{$Ya=array();foreach($o
390as$F=>$n){$Yc=preg_match('~char|text|enum|set~',$n["type"]);if((is_numeric($X["val"])||!preg_match('~(^|[^o])int|float|double|decimal|bit~',$n["type"]))&&(!preg_match("~[\x80-\xFF]~",$X["val"])||$Yc)){$F=idf_escape($F);$Ya[]=($y=="sql"&&$Yc&&!preg_match("~^utf8_~",$n["collation"])?"CONVERT($F USING ".charset($g).")":$F);}}$K[]=($Ya?"(".implode("$db OR ",$Ya)."$db)":"0");}}}return$K;}function
391selectOrderProcess($o,$x){$K=array();foreach((array)$_GET["order"]as$z=>$X){if($X!="")$K[]=(preg_match('~^((COUNT\\(DISTINCT |[A-Z0-9_]+\\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\\)|COUNT\\(\\*\\))$~',$X)?$X:idf_escape($X)).(isset($_GET["desc"][$z])?" DESC":"");}return$K;}function
392selectLimitProcess(){return(isset($_GET["limit"])?$_GET["limit"]:"50");}function
393selectLengthProcess(){return(isset($_GET["text_length"])?$_GET["text_length"]:"100");}function
394selectEmailProcess($Z,$sc){return
395false;}function
396selectQueryBuild($N,$Z,$t,$he,$_,$G){return"";}function
397messageQuery($I,$eg){global$y;restart_session();$Fc=&get_session("queries");$v="sql-".count($Fc[$_GET["db"]]);if(strlen($I)>1e6)$I=preg_replace('~[\x80-\xFF]+$~','',substr($I,0,1e6))."\n...";$Fc[$_GET["db"]][]=array($I,time(),$eg);return" <span class='time'>".@date("H:i:s")."</span> <a href='#$v' onclick=\"return !toggle('$v');\">".lang(51)."</a>"."<div id='$v' class='hidden'><pre><code class='jush-$y'>".shorten_utf8($I,1000).'</code></pre>'.($eg?" <span class='time'>($eg)</span>":'').(support("sql")?'<p><a href="'.h(str_replace("db=".urlencode(DB),"db=".urlencode($_GET["db"]),ME).'sql=&history='.(count($Fc[$_GET["db"]])-1)).'">'.lang(10).'</a>':'').'</div>';}function
398editFunctions($n){global$Lb;$K=($n["null"]?"NULL/":"");foreach($Lb
399as$z=>$yc){if(!$z||(!isset($_GET["call"])&&(isset($_GET["select"])||where($_GET)))){foreach($yc
400as$Be=>$X){if(!$Be||preg_match("~$Be~",$n["type"]))$K.="/$X";}if($z&&!preg_match('~set|blob|bytea|raw|file~',$n["type"]))$K.="/SQL";}}if($n["auto_increment"]&&!isset($_GET["select"])&&!where($_GET))$K=lang(52);return
401explode("/",$K);}function
402editInput($Q,$n,$wa,$Y){if($n["type"]=="enum")return(isset($_GET["select"])?"<label><input type='radio'$wa value='-1' checked><i>".lang(8)."</i></label> ":"").($n["null"]?"<label><input type='radio'$wa value=''".($Y!==null||isset($_GET["select"])?"":" checked")."><i>NULL</i></label> ":"").enum_input("radio",$wa,$n,$Y,0);return"";}function
403processInput($n,$Y,$r=""){if($r=="SQL")return$Y;$F=$n["field"];$K=q($Y);if(preg_match('~^(now|getdate|uuid)$~',$r))$K="$r()";elseif(preg_match('~^current_(date|timestamp)$~',$r))$K=$r;elseif(preg_match('~^([+-]|\\|\\|)$~',$r))$K=idf_escape($F)." $r $K";elseif(preg_match('~^[+-] interval$~',$r))$K=idf_escape($F)." $r ".(preg_match("~^(\\d+|'[0-9.: -]') [A-Z_]+$~i",$Y)?$Y:$K);elseif(preg_match('~^(addtime|subtime|concat)$~',$r))$K="$r(".idf_escape($F).", $K)";elseif(preg_match('~^(md5|sha1|password|encrypt)$~',$r))$K="$r($K)";return
404unconvert_field($n,$K);}function
405dumpOutput(){$K=array('text'=>lang(53),'file'=>lang(54));if(function_exists('gzencode'))$K['gz']='gzip';return$K;}function
406dumpFormat(){return
407array('sql'=>'SQL','csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
408dumpDatabase($k){}function
409dumpTable($Q,$Lf,$Zc=0){if($_POST["format"]!="sql"){echo"\xef\xbb\xbf";if($Lf)dump_csv(array_keys(fields($Q)));}else{if($Zc==2){$o=array();foreach(fields($Q)as$F=>$n)$o[]=idf_escape($F)." $n[full_type]";$i="CREATE TABLE ".table($Q)." (".implode(", ",$o).")";}else$i=create_sql($Q,$_POST["auto_increment"]);set_utf8mb4($i);if($Lf&&$i){if($Lf=="DROP+CREATE"||$Zc==1)echo"DROP ".($Zc==2?"VIEW":"TABLE")." IF EXISTS ".table($Q).";\n";if($Zc==1)$i=remove_definer($i);echo"$i;\n\n";}}}function
410dumpData($Q,$Lf,$I){global$g,$y;$xd=($y=="sqlite"?0:1048576);if($Lf){if($_POST["format"]=="sql"){if($Lf=="TRUNCATE+INSERT")echo
411truncate_sql($Q).";\n";$o=fields($Q);}$J=$g->query($I,1);if($J){$Rc="";$Ia="";$cd=array();$Nf="";$lc=($Q!=''?'fetch_assoc':'fetch_row');while($L=$J->$lc()){if(!$cd){$Kg=array();foreach($L
412as$X){$n=$J->fetch_field();$cd[]=$n->name;$z=idf_escape($n->name);$Kg[]="$z = VALUES($z)";}$Nf=($Lf=="INSERT+UPDATE"?"\nON DUPLICATE KEY UPDATE ".implode(", ",$Kg):"").";\n";}if($_POST["format"]!="sql"){if($Lf=="table"){dump_csv($cd);$Lf="INSERT";}dump_csv($L);}else{if(!$Rc)$Rc="INSERT INTO ".table($Q)." (".implode(", ",array_map('idf_escape',$cd)).") VALUES";foreach($L
413as$z=>$X){$n=$o[$z];$L[$z]=($X!==null?unconvert_field($n,preg_match('~(^|[^o])int|float|double|decimal~',$n["type"])&&$X!=''?$X:q($X)):"NULL");}$pf=($xd?"\n":" ")."(".implode(",\t",$L).")";if(!$Ia)$Ia=$Rc.$pf;elseif(strlen($Ia)+4+strlen($pf)+strlen($Nf)<$xd)$Ia.=",$pf";else{echo$Ia.$Nf;$Ia=$Rc.$pf;}}}if($Ia)echo$Ia.$Nf;}elseif($_POST["format"]=="sql")echo"-- ".str_replace("\n"," ",$g->error)."\n";}}function
414dumpFilename($Jc){return
415friendly_url($Jc!=""?$Jc:(SERVER!=""?SERVER:"localhost"));}function
416dumpHeaders($Jc,$Id=false){$qe=$_POST["output"];$gc=(preg_match('~sql~',$_POST["format"])?"sql":($Id?"tar":"csv"));header("Content-Type: ".($qe=="gz"?"application/x-gzip":($gc=="tar"?"application/x-tar":($gc=="sql"||$qe!="file"?"text/plain":"text/csv")."; charset=utf-8")));if($qe=="gz")ob_start('ob_gzencode',1e6);return$gc;}function
417homepage(){echo'<p class="links">'.($_GET["ns"]==""&&support("database")?'<a href="'.h(ME).'database=">'.lang(55)."</a>\n":""),(support("scheme")?"<a href='".h(ME)."scheme='>".($_GET["ns"]!=""?lang(56):lang(57))."</a>\n":""),($_GET["ns"]!==""?'<a href="'.h(ME).'schema=">'.lang(58)."</a>\n":""),(support("privileges")?"<a href='".h(ME)."privileges='>".lang(59)."</a>\n":"");return
418true;}function
419navigation($Hd){global$fa,$y,$Eb,$g;echo'<h1>
420',$this->name(),' <span class="version">',$fa,'</span>
421<a href="https://www.adminer.org/#download" target="_blank" id="version">',(version_compare($fa,$_COOKIE["adminer_version"])<0?h($_COOKIE["adminer_version"]):""),'</a>
422</h1>
423';if($Hd=="auth"){$pc=true;foreach((array)$_SESSION["pwds"]as$Mg=>$zf){foreach($zf
424as$O=>$Ig){foreach($Ig
425as$V=>$_e){if($_e!==null){if($pc){echo"<p id='logins' onmouseover='menuOver(this, event);' onmouseout='menuOut(this);'>\n";$pc=false;}$tb=$_SESSION["db"][$Mg][$O][$V];foreach(($tb?array_keys($tb):array(""))as$k)echo"<a href='".h(auth_url($Mg,$O,$V,$k))."'>($Eb[$Mg]) ".h($V.($O!=""?"@$O":"").($k!=""?" - $k":""))."</a><br>\n";}}}}}else{if($_GET["ns"]!==""&&!$Hd&&DB!=""){$g->select_db(DB);$S=table_status('',true);}if(support("sql")){echo'<script type="text/javascript" src="',h(preg_replace("~\\?.*~","",ME))."?file=jush.js&amp;version=4.2.3&amp;driver=mysql",'"></script>
426<script type="text/javascript">
427';if($S){$sd=array();foreach($S
428as$Q=>$U)$sd[]=preg_quote($Q,'/');echo"var jushLinks = { $y: [ '".js_escape(ME).(support("table")?"table=":"select=")."\$&', /\\b(".implode("|",$sd).")\\b/g ] };\n";foreach(array("bac","bra","sqlite_quo","mssql_bra")as$X)echo"jushLinks.$X = jushLinks.$y;\n";}echo'bodyLoad(\'',(is_object($g)?substr($g->server_info,0,3):""),'\');
429</script>
430';}$this->databasesPrint($Hd);if(DB==""||!$Hd){echo"<p class='links'>".(support("sql")?"<a href='".h(ME)."sql='".bold(isset($_GET["sql"])&&!isset($_GET["import"])).">".lang(51)."</a>\n<a href='".h(ME)."import='".bold(isset($_GET["import"])).">".lang(60)."</a>\n":"")."";if(support("dump"))echo"<a href='".h(ME)."dump=".urlencode(isset($_GET["table"])?$_GET["table"]:$_GET["select"])."' id='dump'".bold(isset($_GET["dump"])).">".lang(61)."</a>\n";}if($_GET["ns"]!==""&&!$Hd&&DB!=""){echo'<a href="'.h(ME).'create="'.bold($_GET["create"]==="").">".lang(62)."</a>\n";if(!$S)echo"<p class='message'>".lang(9)."\n";else$this->tablesPrint($S);}}}function
431databasesPrint($Hd){global$c,$g;$j=$this->databases();echo'<form action="">
432<p id="dbs">
433';hidden_fields_get();$rb=" onmousedown='dbMouseDown(event, this);' onchange='dbChange(this);'";echo"<span title='".lang(63)."'>DB</span>: ".($j?"<select name='db'$rb>".optionlist(array(""=>"")+$j,DB)."</select>":'<input name="db" value="'.h(DB).'" autocapitalize="off">'),"<input type='submit' value='".lang(20)."'".($j?" class='hidden'":"").">\n";if($Hd!="db"&&DB!=""&&$g->select_db(DB)){}echo(isset($_GET["sql"])?'<input type="hidden" name="sql" value="">':(isset($_GET["schema"])?'<input type="hidden" name="schema" value="">':(isset($_GET["dump"])?'<input type="hidden" name="dump" value="">':(isset($_GET["privileges"])?'<input type="hidden" name="privileges" value="">':"")))),"</p></form>\n";}function
434tablesPrint($S){echo"<p id='tables' onmouseover='menuOver(this, event);' onmouseout='menuOut(this);'>\n";foreach($S
435as$Q=>$Gf){echo'<a href="'.h(ME).'select='.urlencode($Q).'"'.bold($_GET["select"]==$Q||$_GET["edit"]==$Q,"select").">".lang(64)."</a> ";$F=$this->tableName($Gf);echo(support("table")||support("indexes")?'<a href="'.h(ME).'table='.urlencode($Q).'"'.bold(in_array($Q,array($_GET["table"],$_GET["create"],$_GET["indexes"],$_GET["foreign"],$_GET["trigger"])),(is_view($Gf)?"view":""),"structure")." title='".lang(35)."'>$F</a>":"<span>$F</span>")."<br>\n";}}}$c=(function_exists('adminer_object')?adminer_object():new
436Adminer);if($c->operators===null)$c->operators=$de;function
437page_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'<!DOCTYPE html>
438<html lang="',$a,'" dir="',lang(65),'">
439<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
440<meta http-equiv="Content-Script-Type" content="text/javascript">
441<meta name="robots" content="noindex">
442<meta name="referrer" content="origin-when-crossorigin">
443<title>',$kg,'</title>
444<link rel="stylesheet" type="text/css" href="',h(preg_replace("~\\?.*~","",ME))."?file=default.css&amp;version=4.2.3&amp;driver=mysql",'">
445<script type="text/javascript" src="',h(preg_replace("~\\?.*~","",ME))."?file=functions.js&amp;version=4.2.3&amp;driver=mysql",'"></script>
446';if($c->head()){echo'<link rel="shortcut icon" type="image/x-icon" href="',h(preg_replace("~\\?.*~","",ME))."?file=favicon.ico&amp;version=4.2.3&amp;driver=mysql",'">
447<link rel="apple-touch-icon" href="',h(preg_replace("~\\?.*~","",ME))."?file=favicon.ico&amp;version=4.2.3&amp;driver=mysql",'">
448';if(file_exists("adminer.css")){echo'<link rel="stylesheet" type="text/css" href="adminer.css">
449';}}echo'
450<body class="',lang(65),' nojs" onkeydown="bodyKeydown(event);" onclick="bodyClick(event);"',(isset($_COOKIE["adminer_version"])?"":" onload=\"verifyVersion('$fa');\"");?>>
451<script type="text/javascript">
452document.body.className = document.body.className.replace(/ nojs/, ' js');
453var offlineMessage = '<?php echo
454js_escape(lang(66)),'\';
455</script>
456
457<div id="help" class="jush-',$y,' jsonly hidden" onmouseover="helpOpen = 1;" onmouseout="helpMouseout(this, event);"></div>
458
459<div id="content">
460';if($Ha!==null){$A=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'<p id="breadcrumb"><a href="'.h($A?$A:".").'">'.$Eb[DRIVER].'</a> &raquo; ';$A=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$O=(SERVER!=""?h(SERVER):lang(28));if($Ha===false)echo"$O\n";else{echo"<a href='".($A?h($A):".")."' accesskey='1' title='Alt+Shift+1'>$O</a> &raquo; ";if($_GET["ns"]!=""||(DB!=""&&is_array($Ha)))echo'<a href="'.h($A."&db=".urlencode(DB).(support("scheme")?"&ns=":"")).'">'.h(DB).'</a> &raquo; ';if(is_array($Ha)){if($_GET["ns"]!="")echo'<a href="'.h(substr(ME,0,-1)).'">'.h($_GET["ns"]).'</a> &raquo; ';foreach($Ha
461as$z=>$X){$xb=(is_array($X)?$X[1]:h($X));if($xb!="")echo"<a href='".h(ME."$z=").urlencode(is_array($X)?$X[0]:$X)."'>$xb</a> &raquo; ";}}echo"$hg\n";}}echo"<h2>$jg</h2>\n","<div id='ajaxstatus' class='jsonly hidden'></div>\n";restart_session();page_messages($m);$j=&get_session("dbs");if(DB!=""&&$j&&!in_array(DB,$j,true))$j=null;stop_session();define("PAGE_HEADER",1);}function
462page_headers(){global$c;header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");if($c->headers()){header("X-Frame-Options: deny");header("X-XSS-Protection: 0");}}function
463page_messages($m){$Eg=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Fd=$_SESSION["messages"][$Eg];if($Fd){echo"<div class='message'>".implode("</div>\n<div class='message'>",$Fd)."</div>\n";unset($_SESSION["messages"][$Eg]);}if($m)echo"<div class='error'>$m</div>\n";}function
464page_footer($Hd=""){global$c,$T;echo'</div>
465
466';switch_lang();if($Hd!="auth"){echo'<form action="" method="post">
467<p class="logout">
468<input type="submit" name="logout" value="',lang(67),'" id="logout">
469<input type="hidden" name="token" value="',$T,'">
470</p>
471</form>
472';}echo'<div id="menu">
473';$c->navigation($Hd);echo'</div>
474<script type="text/javascript">setupSubmitHighlight(document);</script>
475';}function
476int32($E){while($E>=2147483648)$E-=4294967296;while($E<=-2147483649)$E+=4294967296;return(int)$E;}function
477long2str($W,$Qg){$pf='';foreach($W
478as$X)$pf.=pack('V',$X);if($Qg)return
479substr($pf,0,end($W));return$pf;}function
480str2long($pf,$Qg){$W=array_values(unpack('V*',str_pad($pf,4*ceil(strlen($pf)/4),"\0")));if($Qg)$W[]=strlen($pf);return$W;}function
481xxtea_mx($Vg,$Ug,$Of,$bd){return
482int32((($Vg>>5&0x7FFFFFF)^$Ug<<2)+(($Ug>>3&0x1FFFFFFF)^$Vg<<4))^int32(($Of^$Ug)+($bd^$Vg));}function
483encrypt_string($If,$z){if($If=="")return"";$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($If,true);$E=count($W)-1;$Vg=$W[$E];$Ug=$W[0];$H=floor(6+52/($E+1));$Of=0;while($H-->0){$Of=int32($Of+0x9E3779B9);$Kb=$Of>>2&3;for($re=0;$re<$E;$re++){$Ug=$W[$re+1];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Vg=int32($W[$re]+$Jd);$W[$re]=$Vg;}$Ug=$W[0];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Vg=int32($W[$E]+$Jd);$W[$E]=$Vg;}return
484long2str($W,false);}function
485decrypt_string($If,$z){if($If=="")return"";if(!$z)return
486false;$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($If,false);$E=count($W)-1;$Vg=$W[$E];$Ug=$W[0];$H=floor(6+52/($E+1));$Of=int32($H*0x9E3779B9);while($Of){$Kb=$Of>>2&3;for($re=$E;$re>0;$re--){$Vg=$W[$re-1];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Ug=int32($W[$re]-$Jd);$W[$re]=$Ug;}$Vg=$W[$E];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Ug=int32($W[0]-$Jd);$W[0]=$Ug;$Of=int32($Of-0x9E3779B9);}return
487long2str($W,true);}$g='';$Ec=$_SESSION["token"];if(!$Ec)$_SESSION["token"]=rand(1,1e6);$T=get_token();$Ce=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($z)=explode(":",$X);$Ce[$z]=$X;}}function
488add_invalid_login(){global$c;$nc=get_temp_dir()."/adminer.invalid";$q=@fopen($nc,"r+");if(!$q){$q=@fopen($nc,"w");if(!$q)return;}flock($q,LOCK_EX);$Uc=unserialize(stream_get_contents($q));$eg=time();if($Uc){foreach($Uc
489as$Vc=>$X){if($X[0]<$eg)unset($Uc[$Vc]);}}$Tc=&$Uc[$c->bruteForceKey()];if(!$Tc)$Tc=array($eg+30*60,0);$Tc[1]++;$xf=serialize($Uc);rewind($q);fwrite($q,$xf);ftruncate($q,strlen($xf));flock($q,LOCK_UN);fclose($q);}$xa=$_POST["auth"];if($xa){$Uc=unserialize(@file_get_contents(get_temp_dir()."/adminer.invalid"));$Tc=$Uc[$c->bruteForceKey()];$Od=($Tc[1]>30?$Tc[0]-time():0);if($Od>0)auth_error(lang(68,ceil($Od/60)));session_regenerate_id();$Mg=$xa["driver"];$O=$xa["server"];$V=$xa["username"];$_e=(string)$xa["password"];$k=$xa["db"];set_password($Mg,$O,$V,$_e);$_SESSION["db"][$Mg][$O][$V][$k]=true;if($xa["permanent"]){$z=base64_encode($Mg)."-".base64_encode($O)."-".base64_encode($V)."-".base64_encode($k);$Ne=$c->permanentLogin(true);$Ce[$z]="$z:".base64_encode($Ne?encrypt_string($_e,$Ne):"");cookie("adminer_permanent",implode(" ",$Ce));}if(count($_POST)==1||DRIVER!=$Mg||SERVER!=$O||$_GET["username"]!==$V||DB!=$k)redirect(auth_url($Mg,$O,$V,$k));}elseif($_POST["logout"]){if($Ec&&!verify_token()){page_header(lang(67),lang(69));page_footer("db");exit;}else{foreach(array("pwds","db","dbs","queries")as$z)set_session($z,null);unset_permanent();redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),lang(70));}}elseif($Ce&&!$_SESSION["pwds"]){session_regenerate_id();$Ne=$c->permanentLogin();foreach($Ce
490as$z=>$X){list(,$Qa)=explode(":",$X);list($Mg,$O,$V,$k)=array_map('base64_decode',explode("-",$z));set_password($Mg,$O,$V,decrypt_string(base64_decode($Qa),$Ne));$_SESSION["db"][$Mg][$O][$V][$k]=true;}}function
491unset_permanent(){global$Ce;foreach($Ce
492as$z=>$X){list($Mg,$O,$V,$k)=array_map('base64_decode',explode("-",$z));if($Mg==DRIVER&&$O==SERVER&&$V==$_GET["username"]&&$k==DB)unset($Ce[$z]);}cookie("adminer_permanent",implode(" ",$Ce));}function
493auth_error($m){global$c,$Ec;$m=h($m);$_f=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$_f]||$_GET[$_f])&&!$Ec)$m=lang(71);else{add_invalid_login();$_e=get_password();if($_e!==null){if($_e===false)$m.='<br>'.lang(72,'<code>permanentLogin()</code>');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent();}}if(!$_COOKIE[$_f]&&$_GET[$_f]&&ini_bool("session.use_only_cookies"))$m=lang(73);$te=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?$_COOKIE["adminer_key"]:rand_string()),$te["lifetime"]);page_header(lang(32),$m,null);echo"<form action='' method='post'>\n";$c->loginForm();echo"<div>";hidden_fields($_POST,array("auth"));echo"</div>\n","</form>\n";page_footer("auth");exit;}if(isset($_GET["username"])){if(!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header(lang(74),lang(75,implode(", ",$Ie)),false);page_footer("auth");exit;}$g=connect();}$l=new
494Min_Driver($g);if(!is_object($g)||!$c->login($_GET["username"],get_password()))auth_error((is_string($g)?$g:lang(76)));if($xa&&$_POST["token"])$_POST["token"]=$T;$m='';if($_POST){if(!verify_token()){$Oc="max_input_vars";$Ad=ini_get($Oc);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$z){$X=ini_get($z);if($X&&(!$Ad||$X<$Ad)){$Oc=$z;$Ad=$X;}}}$m=(!$_POST["token"]&&$Ad?lang(77,"'$Oc'"):lang(69).' '.lang(78));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$m=lang(79,"'post_max_size'");if(isset($_GET["sql"]))$m.=' '.lang(80);}if(!ini_bool("session.use_cookies")||@ini_set("session.use_cookies",false)!==false)session_write_close();function
495select($J,$h=null,$ke=array(),$_=0){global$y;$sd=array();$x=array();$e=array();$Fa=array();$wg=array();$K=array();odd('');for($u=0;(!$_||$u<$_)&&($L=$J->fetch_row());$u++){if(!$u){echo"<table cellspacing='0' class='nowrap'>\n","<thead><tr>";for($ad=0;$ad<count($L);$ad++){$n=$J->fetch_field();$F=$n->name;$je=$n->orgtable;$ie=$n->orgname;$K[$n->table]=$je;if($ke&&$y=="sql")$sd[$ad]=($F=="table"?"table=":($F=="possible_keys"?"indexes=":null));elseif($je!=""){if(!isset($x[$je])){$x[$je]=array();foreach(indexes($je,$h)as$w){if($w["type"]=="PRIMARY"){$x[$je]=array_flip($w["columns"]);break;}}$e[$je]=$x[$je];}if(isset($e[$je][$ie])){unset($e[$je][$ie]);$x[$je][$ie]=$ad;$sd[$ad]=$je;}}if($n->charsetnr==63)$Fa[$ad]=true;$wg[$ad]=$n->type;echo"<th".($je!=""||$n->name!=$ie?" title='".h(($je!=""?"$je.":"").$ie)."'":"").">".h($F).($ke?doc_link(array('sql'=>"explain-output.html#explain_".strtolower($F))):"");}echo"</thead>\n";}echo"<tr".odd().">";foreach($L
496as$z=>$X){if($X===null)$X="<i>NULL</i>";elseif($Fa[$z]&&!is_utf8($X))$X="<i>".lang(39,strlen($X))."</i>";elseif(!strlen($X))$X="&nbsp;";else{$X=h($X);if($wg[$z]==254)$X="<code>$X</code>";}if(isset($sd[$z])&&!$e[$sd[$z]]){if($ke&&$y=="sql"){$Q=$L[array_search("table=",$sd)];$A=$sd[$z].urlencode($ke[$Q]!=""?$ke[$Q]:$Q);}else{$A="edit=".urlencode($sd[$z]);foreach($x[$sd[$z]]as$Ua=>$ad)$A.="&where".urlencode("[".bracket_escape($Ua)."]")."=".urlencode($L[$ad]);}$X="<a href='".h(ME.$A)."'>$X</a>";}echo"<td>$X";}}echo($u?"</table>":"<p class='message'>".lang(12))."\n";return$K;}function
497referencable_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
498textarea($F,$Y,$M=10,$Ya=80){global$y;echo"<textarea name='$F' rows='$M' cols='$Ya' class='sqlarea jush-$y' spellcheck='false' wrap='off'>";if(is_array($Y)){foreach($Y
499as$X)echo
500h($X[0])."\n\n\n";}else
501echo
502h($Y);echo"</textarea>";}function
503edit_type($z,$n,$Xa,$tc=array()){global$Kf,$wg,$Cg,$Zd;$U=$n["type"];echo'<td><select name="',h($z),'[type]" class="type" onfocus="lastType = selectValue(this);" onchange="editingTypeChange(this);"',on_help("getTarget(event).value",1),'>';if($U&&!isset($wg[$U])&&!isset($tc[$U]))array_unshift($Kf,$U);if($tc)$Kf[lang(81)]=$tc;echo
504optionlist($Kf,$U),'</select>
505<td><input name="',h($z),'[length]" value="',h($n["length"]),'" size="3" onfocus="editingLengthFocus(this);"',(!$n["length"]&&preg_match('~var(char|binary)$~',$U)?" class='required'":""),' onchange="editingLengthChange(this);" onkeyup="this.onchange();"><td class="options">';echo"<select name='".h($z)."[collation]'".(preg_match('~(char|text|enum|set)$~',$U)?"":" class='hidden'").'><option value="">('.lang(82).')'.optionlist($Xa,$n["collation"]).'</select>',($Cg?"<select name='".h($z)."[unsigned]'".(!$U||preg_match('~((^|[^o])int|float|double|decimal)$~',$U)?"":" class='hidden'").'><option>'.optionlist($Cg,$n["unsigned"]).'</select>':''),(isset($n['on_update'])?"<select name='".h($z)."[on_update]'".(preg_match('~timestamp|datetime~',$U)?"":" class='hidden'").'>'.optionlist(array(""=>"(".lang(83).")","CURRENT_TIMESTAMP"),$n["on_update"]).'</select>':''),($tc?"<select name='".h($z)."[on_delete]'".(preg_match("~`~",$U)?"":" class='hidden'")."><option value=''>(".lang(84).")".optionlist(explode("|",$Zd),$n["on_delete"])."</select> ":" ");}function
506process_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
507process_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
508process_field($n,$ug){global$y;$vb=$n["default"];return
509array(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
510type_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
511edit_fields($o,$Xa,$U="TABLE",$tc=array(),$cb=false){global$g,$Pc;$o=array_values($o);echo'<thead><tr class="wrap">
512';if($U=="PROCEDURE"){echo'<td>&nbsp;';}echo'<th>',($U=="TABLE"?lang(85):lang(86)),'<td>',lang(87),'<textarea id="enum-edit" rows="4" cols="12" wrap="off" style="display: none;" onblur="editingLengthBlur(this);"></textarea>
513<td>',lang(88),'<td>',lang(89);if($U=="TABLE"){echo'<td>NULL
514<td><input type="radio" name="auto_increment_col" value=""><acronym title="',lang(52),'">AI</acronym>',doc_link(array('sql'=>"example-auto-increment.html",'sqlite'=>"autoinc.html",'pgsql'=>"datatype.html#DATATYPE-SERIAL",'mssql'=>"ms186775.aspx",)),'<td>',lang(90),(support("comment")?"<td".($cb?"":" class='hidden'").">".lang(91):"");}echo'<td>',"<input type='image' class='icon' name='add[".(support("move_col")?0:count($o))."]' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.3&amp;driver=mysql' alt='+' title='".lang(92)."'>",'<script type="text/javascript">row_count = ',count($o),';</script>
515</thead>
516<tbody onkeydown="return editingKeydown(event);">
517';foreach($o
518as$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'<tr',($Ab?"":" style='display: none;'"),'>
519',($U=="PROCEDURE"?"<td>".html_select("fields[$u][inout]",explode("|",$Pc),$n["inout"]):""),'<th>';if($Ab){echo'<input name="fields[',$u,'][field]" value="',h($n["field"]),'" onchange="editingNameChange(this);',($n["field"]!=""||count($o)>1?'':' editingAddRow(this);" onkeyup="if (this.value) editingAddRow(this);'),'" maxlength="64" autocapitalize="off">';}echo'<input type="hidden" name="fields[',$u,'][orig]" value="',h($le),'">
520';edit_type("fields[$u]",$n,$Xa,$tc);if($U=="TABLE"){echo'<td>',checkbox("fields[$u][null]",1,$n["null"],"","","block"),'<td><label class="block"><input type="radio" name="auto_increment_col" value="',$u,'"';if($n["auto_increment"]){echo' checked';}?> onclick="var field = this.form['fields[' + this.value + '][field]']; if (!field.value) { field.value = 'id'; field.onchange(); }"></label><td><?php
521echo
522checkbox("fields[$u][has_default]",1,$n["has_default"]),'<input name="fields[',$u,'][default]" value="',h($n["default"]),'" onkeyup="keyupChange.call(this);" onchange="this.previousSibling.checked = true;">
523',(support("comment")?"<td".($cb?"":" class='hidden'")."><input name='fields[$u][comment]' value='".h($n["comment"])."' maxlength='".($g->server_info>=5.5?1024:255)."'>":"");}echo"<td>",(support("move_col")?"<input type='image' class='icon' name='add[$u]' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.3&amp;driver=mysql' alt='+' title='".lang(92)."' onclick='return !editingAddRow(this, 1);'>&nbsp;"."<input type='image' class='icon' name='up[$u]' src='".h(preg_replace("~\\?.*~","",ME))."?file=up.gif&amp;version=4.2.3&amp;driver=mysql' alt='^' title='".lang(93)."'>&nbsp;"."<input type='image' class='icon' name='down[$u]' src='".h(preg_replace("~\\?.*~","",ME))."?file=down.gif&amp;version=4.2.3&amp;driver=mysql' alt='v' title='".lang(94)."'>&nbsp;":""),($le==""||support("drop_col")?"<input type='image' class='icon' name='drop_col[$u]' src='".h(preg_replace("~\\?.*~","",ME))."?file=cross.gif&amp;version=4.2.3&amp;driver=mysql' alt='x' title='".lang(95)."' onclick=\"return !editingRemoveRow(this, 'fields\$1[field]');\">":""),"\n";}}function
524process_fields(&$o){ksort($o);$Sd=0;if($_POST["up"]){$id=0;foreach($o
525as$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
526as$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
527false;return
528true;}function
529normalize_enum($C){return"'".str_replace("'","''",addcslashes(stripcslashes(str_replace($C[0][0].$C[0][0],$C[0][0],substr($C[0],1,-1))),'\\'))."'";}function
530grant($s,$Pe,$e,$Yd){if(!$Pe)return
531true;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
532queries("$s ".preg_replace('~(GRANT OPTION)\\([^)]*\\)~','\\1',implode("$e, ",$Pe).$e).$Yd);}function
533drop_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
534queries_redirect($B,$Cd,queries($bg)&&queries($Hb)&&queries($Fb)&&queries($i));}function
535create_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
536create_routine($mf,$L){global$Pc;$P=array();$o=(array)$L["fields"];ksort($o);foreach($o
537as$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
538remove_definer($I){return
539preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\\1)',logged_user()).'`~','\\1',$I);}function
540format_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
541tar_file($nc,$lg){$K=pack("a100a8a8a8a12a12",$nc,644,0,0,decoct($lg->size),decoct(time()));$Pa=8*32;for($u=0;$u<strlen($K);$u++)$Pa+=ord($K[$u]);$K.=sprintf("%06o",$Pa)."\0 ";echo$K,str_repeat("\0",512-strlen($K));$lg->send();echo
542str_repeat("\0",511-($lg->size+511)%512);}function
543ini_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
544doc_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]?"<a href='$Fg[$y]$Ae[$y]' target='_blank' rel='noreferrer'><sup>?</sup></a>":"");}function
545ob_gzencode($Jf){return
546gzencode($Jf);}function
547db_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
548format_number($K);}function
549set_utf8mb4($i){global$g;static$P=false;if(!$P&&preg_match('~\butf8mb4~i',$i)){$P=true;echo"SET NAMES ".charset($g).";\n\n";}}function
550connect_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"<p class='links'>\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"<a href='".h(ME)."$z='>$X</a>\n";}echo"<p>".lang(103,$Eb[DRIVER],"<b>".h($g->server_info)."</b>","<b>$g->extension</b>")."\n","<p>".lang(104,"<b>".h(logged_user())."</b>")."\n";$j=$c->databases();if($j){$sf=support("scheme");$Xa=collations();echo"<form action='' method='post'>\n","<table cellspacing='0' class='checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);'>\n","<thead><tr>".(support("database")?"<td>&nbsp;":"")."<th>".lang(31)." - <a href='".h(ME)."refresh=1'>".lang(105)."</a>"."<td>".lang(106)."<td>".lang(107)."<td>".lang(108)." - <a href='".h(ME)."dbsize=1' onclick=\"return !ajaxSetHtml('".h(js_escape(ME))."script=connect');\">".lang(109)."</a>"."</thead>\n";$j=($_GET["dbsize"]?count_tables($j):array_flip($j));foreach($j
551as$k=>$S){$lf=h(ME)."db=".urlencode($k);echo"<tr".odd().">".(support("database")?"<td>".checkbox("db[]",$k,in_array($k,(array)$_POST["db"])):""),"<th><a href='$lf'>".h($k)."</a>";$Wa=nbsp(db_collation($k,$Xa));echo"<td>".(support("database")?"<a href='$lf".($sf?"&amp;ns=":"")."&amp;database=' title='".lang(55)."'>$Wa</a>":$Wa),"<td align='right'><a href='$lf&amp;schema=' id='tables-".h($k)."' title='".lang(58)."'>".($_GET["dbsize"]?$S:"?")."</a>","<td align='right' id='size-".h($k)."'>".($_GET["dbsize"]?db_size($k):"?"),"\n";}echo"</table>\n",(support("database")?"<fieldset><legend>".lang(110)." <span id='selected'></span></legend><div>\n"."<input type='hidden' name='all' value='' onclick=\"selectCount('selected', formChecked(this, /^db/));\">\n"."<input type='submit' name='drop' value='".lang(111)."'".confirm().">\n"."</div></fieldset>\n":""),"<script type='text/javascript'>tableCheck();</script>\n","<input type='hidden' name='token' value='$T'>\n","</form>\n";}}page_footer("db");}if(isset($_GET["status"]))$_GET["variables"]=$_GET["status"];if(isset($_GET["import"]))$_GET["sql"]=$_GET["import"];if(!(DB!=""?$g->select_db(DB):isset($_GET["sql"])||isset($_GET["dump"])||isset($_GET["database"])||isset($_GET["processlist"])||isset($_GET["privileges"])||isset($_GET["user"])||isset($_GET["variables"])||$_GET["script"]=="connect"||$_GET["script"]=="kill")){if(DB!=""||$_GET["refresh"]){restart_session();set_session("dbs",null);}connect_error();exit;}$Zd="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";class
552TmpFile{var$handler;var$size;function
553__construct(){$this->handler=tmpfile();}function
554write($gb){$this->size+=strlen($gb);fwrite($this->handler,$gb);}function
555send(){fseek($this->handler,0);fpassthru($this->handler);fclose($this->handler);}}$Vb="'(?:''|[^'\\\\]|\\\\.)*'";$Pc="IN|OUT|INOUT";if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["callf"]))$_GET["call"]=$_GET["callf"];if(isset($_GET["function"]))$_GET["procedure"]=$_GET["function"];if(isset($_GET["download"])){$b=$_GET["download"];$o=fields($b);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$b-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$N=array(idf_escape($_GET["field"]));$J=$l->select($b,$N,array(where($_GET,$o)),$N);$L=($J?$J->fetch_row():array());echo$L[0];exit;}elseif(isset($_GET["table"])){$b=$_GET["table"];$o=fields($b);if(!$o)$m=error();$R=table_status1($b,true);page_header(($o&&is_view($R)?lang(112):lang(113)).": ".h($b),$m);$c->selectLinks($R);$bb=$R["Comment"];if($bb!="")echo"<p>".lang(91).": ".h($bb)."\n";if($o){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(114)."<td>".lang(87).(support("comment")?"<td>".lang(91):"")."</thead>\n";foreach($o
556as$n){echo"<tr".odd()."><th>".h($n["field"]),"<td><span title='".h($n["collation"])."'>".h($n["full_type"])."</span>",($n["null"]?" <i>NULL</i>":""),($n["auto_increment"]?" <i>".lang(52)."</i>":""),(isset($n["default"])?" <span title='".lang(90)."'>[<b>".h($n["default"])."</b>]</span>":""),(support("comment")?"<td>".nbsp($n["comment"]):""),"\n";}echo"</table>\n";}if(!is_view($R)){if(support("indexes")){echo"<h3 id='indexes'>".lang(115)."</h3>\n";$x=indexes($b);if($x){echo"<table cellspacing='0'>\n";foreach($x
557as$F=>$w){ksort($w["columns"]);$Me=array();foreach($w["columns"]as$z=>$X)$Me[]="<i>".h($X)."</i>".($w["lengths"][$z]?"(".$w["lengths"][$z].")":"").($w["descs"][$z]?" DESC":"");echo"<tr title='".h($F)."'><th>$w[type]<td>".implode(", ",$Me)."\n";}echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'indexes='.urlencode($b).'">'.lang(116)."</a>\n";}if(fk_support($R)){echo"<h3 id='foreign-keys'>".lang(81)."</h3>\n";$tc=foreign_keys($b);if($tc){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(117)."<td>".lang(118)."<td>".lang(84)."<td>".lang(83)."<td>&nbsp;</thead>\n";foreach($tc
558as$F=>$p){echo"<tr title='".h($F)."'>","<th><i>".implode("</i>, <i>",array_map('h',$p["source"]))."</i>","<td><a href='".h($p["db"]!=""?preg_replace('~db=[^&]*~',"db=".urlencode($p["db"]),ME):($p["ns"]!=""?preg_replace('~ns=[^&]*~',"ns=".urlencode($p["ns"]),ME):ME))."table=".urlencode($p["table"])."'>".($p["db"]!=""?"<b>".h($p["db"])."</b>.":"").($p["ns"]!=""?"<b>".h($p["ns"])."</b>.":"").h($p["table"])."</a>","(<i>".implode("</i>, <i>",array_map('h',$p["target"]))."</i>)","<td>".nbsp($p["on_delete"])."\n","<td>".nbsp($p["on_update"])."\n",'<td><a href="'.h(ME.'foreign='.urlencode($b).'&name='.urlencode($F)).'">'.lang(119).'</a>';}echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'foreign='.urlencode($b).'">'.lang(120)."</a>\n";}}if(support(is_view($R)?"view_trigger":"trigger")){echo"<h3 id='triggers'>".lang(121)."</h3>\n";$tg=triggers($b);if($tg){echo"<table cellspacing='0'>\n";foreach($tg
559as$z=>$X)echo"<tr valign='top'><td>".h($X[0])."<td>".h($X[1])."<th>".h($z)."<td><a href='".h(ME.'trigger='.urlencode($b).'&name='.urlencode($z))."'>".lang(119)."</a>\n";echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'trigger='.urlencode($b).'">'.lang(122)."</a>\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
560as$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'<div id="schema" style="height: ',$ng,'em;" onselectstart="return false;">
561<script type="text/javascript">
562var tablePos = {',implode(",",$Uf)."\n",'};
563var em = document.getElementById(\'schema\').offsetHeight / ',$ng,';
564document.onmousemove = schemaMousemove;
565document.onmouseup = function (ev) {
566	schemaMouseup(ev, \'',js_escape(DB),'\');
567};
568</script>
569';foreach($rf
570as$F=>$Q){echo"<div class='table' style='top: ".$Q["pos"][0]."em; left: ".$Q["pos"][1]."em;' onmousedown='schemaMousedown(this, event);'>",'<a href="'.h(ME).'table='.urlencode($F).'"><b>'.h($F)."</b></a>";foreach($Q["fields"]as$n){$X='<span'.type_class($n["type"]).' title="'.h($n["full_type"].($n["null"]?" NULL":'')).'">'.h($n["field"]).'</span>';echo"<br>".($n["primary"]?"<i>$X</i>":$X);}foreach((array)$Q["references"]as$Zf=>$df){foreach($df
571as$kd=>$Ze){$ld=$kd-$Tf[$F][1];$u=0;foreach($Ze[0]as$Cf)echo"\n<div class='references' title='".h($Zf)."' id='refs$kd-".($u++)."' style='left: $ld"."em; top: ".$Q["fields"][$Cf]["pos"]."em; padding-top: .5em;'><div style='border-top: 1px solid Gray; width: ".(-$ld)."em;'></div></div>";}}foreach((array)$cf[$F]as$Zf=>$df){foreach($df
572as$kd=>$e){$ld=$kd-$Tf[$F][1];$u=0;foreach($e
573as$Yf)echo"\n<div class='references' title='".h($Zf)."' id='refd$kd-".($u++)."' style='left: $ld"."em; top: ".$Q["fields"][$Yf]["pos"]."em; height: 1.25em; background: url(".h(preg_replace("~\\?.*~","",ME))."?file=arrow.gif) no-repeat right center;&amp;version=4.2.3&amp;driver=mysql'><div style='height: .5em; border-bottom: 1px solid Gray; width: ".(-$ld)."em;'></div></div>";}}echo"\n</div>\n";}foreach($rf
574as$F=>$Q){foreach((array)$Q["references"]as$Zf=>$df){foreach($df
575as$kd=>$Ze){$Gd=$ng;$zd=-10;foreach($Ze[0]as$z=>$Cf){$Ge=$Q["pos"][0]+$Q["fields"][$Cf]["pos"];$He=$rf[$Zf]["pos"][0]+$rf[$Zf]["fields"][$Ze[1][$z]]["pos"];$Gd=min($Gd,$Ge,$He);$zd=max($zd,$Ge,$He);}echo"<div class='references' id='refl$kd' style='left: $kd"."em; top: $Gd"."em; padding: .5em 0;'><div style='border-right: 1px solid Gray; margin-top: 1px; height: ".($zd-$Gd)."em;'></div></div>\n";}}}echo'</div>
576<p class="links"><a href="',h(ME."schema=".urlencode($da)),'" id="schema-link">',lang(123),'</a>
577';}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;
578SET time_zone = '+00:00';
579".($_POST["data_style"]?"SET foreign_key_checks = 0;
580SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
581":"")."
582";$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
583as$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
584use_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
585TmpFile;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
586as$Ng)$c->dumpTable($Ng,$_POST["table_style"],1);if($gc=="tar")echo
587pack("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'
588<form action="" method="post">
589<table cellspacing="0">
590';$sb=array('','USE','DROP+CREATE','CREATE');$Vf=array('','DROP+CREATE','CREATE');$pb=array('','TRUNCATE+INSERT','INSERT');if($y=="sql")$pb[]='INSERT+UPDATE';parse_str($_COOKIE["adminer_export"],$L);if(!$L)$L=array("output"=>"text","format"=>"sql","db_style"=>(DB!=""?"":"CREATE"),"table_style"=>"DROP+CREATE","data_style"=>"INSERT");if(!isset($L["events"])){$L["routines"]=$L["events"]=($_GET["dump"]=="");$L["triggers"]=$L["table_style"];}echo"<tr><th>".lang(124)."<td>".html_select("output",$c->dumpOutput(),$L["output"],0)."\n";echo"<tr><th>".lang(125)."<td>".html_select("format",$c->dumpFormat(),$L["format"],0)."\n";echo($y=="sqlite"?"":"<tr><th>".lang(31)."<td>".html_select('db_style',$sb,$L["db_style"]).(support("routine")?checkbox("routines",1,$L["routines"],lang(126)):"").(support("event")?checkbox("events",1,$L["events"],lang(127)):"")),"<tr><th>".lang(107)."<td>".html_select('table_style',$Vf,$L["table_style"]).checkbox("auto_increment",1,$L["auto_increment"],lang(52)).(support("trigger")?checkbox("triggers",1,$L["triggers"],lang(121)):""),"<tr><th>".lang(128)."<td>".html_select('data_style',$pb,$L["data_style"]),'</table>
591<p><input type="submit" value="',lang(61),'">
592<input type="hidden" name="token" value="',$T,'">
593
594<table cellspacing="0">
595';$Ke=array();if(DB!=""){$Na=($b!=""?"":" checked");echo"<thead><tr>","<th style='text-align: left;'><label class='block'><input type='checkbox' id='check-tables'$Na onclick='formCheck(this, /^tables\\[/);'>".lang(107)."</label>","<th style='text-align: right;'><label class='block'>".lang(128)."<input type='checkbox' id='check-data'$Na onclick='formCheck(this, /^data\\[/);'></label>","</thead>\n";$Og="";$Wf=tables_list();foreach($Wf
596as$F=>$U){$Je=preg_replace('~_.*~','',$F);$Na=($b==""||$b==(substr($b,-1)=="%"?"$Je%":$F));$Me="<tr><td>".checkbox("tables[]",$F,$Na,$F,"checkboxClick(event, this); formUncheck('check-tables');","block");if($U!==null&&!preg_match('~table~i',$U))$Og.="$Me\n";else
597echo"$Me<td align='right'><label class='block'><span id='Rows-".h($F)."'></span>".checkbox("data[]",$F,$Na,"","checkboxClick(event, this); formUncheck('check-data');")."</label>\n";$Ke[$Je]++;}echo$Og;if($Wf)echo"<script type='text/javascript'>ajaxSetHtml('".js_escape(ME)."script=db');</script>\n";}else{echo"<thead><tr><th style='text-align: left;'><label class='block'><input type='checkbox' id='check-databases'".($b==""?" checked":"")." onclick='formCheck(this, /^databases\\[/);'>".lang(31)."</label></thead>\n";$j=$c->databases();if($j){foreach($j
598as$k){if(!information_schema($k)){$Je=preg_replace('~_.*~','',$k);echo"<tr><td>".checkbox("databases[]",$k,$b==""||$b=="$Je%",$k,"formUncheck('check-databases');","block")."\n";$Ke[$Je]++;}}}else
599echo"<tr><td><textarea name='databases' rows='10' cols='20'></textarea>";}echo'</table>
600</form>
601';$pc=true;foreach($Ke
602as$z=>$X){if($z!=""&&$X>1){echo($pc?"<p>":" ")."<a href='".h(ME)."dump=".urlencode("$z%")."'>".h($z)."</a>";$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"<form action=''><p>\n";hidden_fields_get();echo"<input type='hidden' name='db' value='".h(DB)."'>\n",($s?"":"<input type='hidden' name='grant' value=''>\n"),"<table cellspacing='0'>\n","<thead><tr><th>".lang(29)."<th>".lang(28)."<th>&nbsp;</thead>\n";while($L=$J->fetch_assoc())echo'<tr'.odd().'><td>'.h($L["User"])."<td>".h($L["Host"]).'<td><a href="'.h(ME.'user='.urlencode($L["User"]).'&host='.urlencode($L["Host"])).'">'.lang(10)."</a>\n";if(!$s||DB!="")echo"<tr".odd()."><td><input name='user' autocapitalize='off'><td><input name='host' value='localhost' autocapitalize='off'><td><input type='submit' value='".lang(10)."'>\n";echo"</table>\n","</form>\n",'<p class="links"><a href="'.h(ME).'user=">'.lang(129)."</a>";}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="<pre id='sql-$ab'><code class='jush-$y'>".shorten_utf8(trim($H),1000)."</code></pre>\n";if(!$_POST["only_errors"]){echo$Me;ob_flush();flush();}$Ff=microtime(true);if($g->multi_query($H)&&is_object($h)&&preg_match("~^$Df*USE\\b~isU",$H))$h->query($H);do{$J=$g->store_result();$eg=" <span class='time'>(".format_time($Ff).")</span>".(strlen($H)<1000?" <a href='".h(ME)."sql=".urlencode(trim($H))."'>".lang(10)."</a>":"");if($g->error){echo($_POST["only_errors"]?$Me:""),"<p class='error'>".lang(130).($g->errno?" ($g->errno)":"").": ".error()."\n";$Xb[]=" <a href='#sql-$ab'>$ab</a>";if($_POST["error_stops"])break
6032;}elseif(is_object($J)){$_=$_POST["limit"];$ke=select($J,$h,array(),$_);if(!$_POST["only_errors"]){echo"<form action='' method='post'>\n";$Pd=$J->num_rows;echo"<p>".($Pd?($_&&$Pd>$_?lang(131,$_):"").lang(132,$Pd):""),$eg;$v="export-$ab";$fc=", <a href='#$v' onclick=\"return !toggle('$v');\">".lang(61)."</a><span id='$v' class='hidden'>: ".html_select("output",$c->dumpOutput(),$la["output"])." ".html_select("format",$Jb,$la["format"])."<input type='hidden' name='query' value='".h($H)."'>"." <input type='submit' name='export' value='".lang(61)."'><input type='hidden' name='token' value='$T'></span>\n";if($h&&preg_match("~^($Df|\\()*SELECT\\b~isU",$H)&&($ec=explain($h,$H))){$v="explain-$ab";echo", <a href='#$v' onclick=\"return !toggle('$v');\">EXPLAIN</a>$fc","<div id='$v' class='hidden'>\n";select($ec,$h,$ke);echo"</div>\n";}else
604echo$fc;echo"</form>\n";}}else{if(preg_match("~^$Df*(CREATE|DROP|ALTER)$Df+(DATABASE|SCHEMA)\\b~isU",$H)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"])echo"<p class='message' title='".h($g->info)."'>".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"<p class='message'>".lang(134)."\n";elseif($_POST["only_errors"]){echo"<p class='message'>".lang(135,$ab-count($Xb))," <span class='time'>(".format_time($og).")</span>\n";}elseif($Xb&&$ab>1)echo"<p class='error'>".lang(130).": ".implode("",$Xb)."\n";}else
605echo"<p class='error'>".upload_error($I)."\n";}echo'
606<form action="" method="post" enctype="multipart/form-data" id="form">
607';$cc="<input type='submit' value='".lang(136)."' title='Ctrl+Enter'>";if(!isset($_GET["import"])){$H=$_GET["sql"];if($_POST)$H=$_POST["query"];elseif($_GET["history"]=="all")$H=$Fc;elseif($_GET["history"]!="")$H=$Fc[$_GET["history"]][0];echo"<p>";textarea("query",$H,20);echo($_POST?"":"<script type='text/javascript'>focus(document.getElementsByTagName('textarea')[0]);</script>\n"),"<p>$cc\n",lang(137).": <input type='number' name='limit' class='size' value='".h($_POST?$_POST["limit"]:$_GET["limit"])."'>\n";}else{echo"<fieldset><legend>".lang(138)."</legend><div>",(ini_bool("file_uploads")?"SQL (&lt; ".ini_get("upload_max_filesize")."B): <input type='file' name='sql_file[]' multiple>\n$cc":lang(139)),"</div></fieldset>\n","<fieldset><legend>".lang(140)."</legend><div>",lang(141,"<code>adminer.sql".(extension_loaded("zlib")?"[.gz]":"")."</code>"),' <input type="submit" name="webfile" value="'.lang(142).'">',"</div></fieldset>\n","<p>";}echo
608checkbox("error_stops",1,($_POST?$_POST["error_stops"]:isset($_GET["import"])),lang(143))."\n",checkbox("only_errors",1,($_POST?$_POST["only_errors"]:isset($_GET["import"])),lang(144))."\n","<input type='hidden' name='token' value='$T'>\n";if(!isset($_GET["import"])&&$Fc){print_fieldset("history",lang(145),$_GET["history"]!="");for($X=end($Fc);$X;$X=prev($Fc)){$z=key($Fc);list($H,$eg,$Nb)=$X;echo'<a href="'.h(ME."sql=&history=$z").'">'.lang(10)."</a>"." <span class='time' title='".@date('Y-m-d',$eg)."'>".@date("H:i:s",$eg)."</span>"." <code class='jush-$y'>".shorten_utf8(ltrim(str_replace("\n"," ",str_replace("\r","",preg_replace('~^(#|-- ).*~m','',$H)))),80,"</code>").($Nb?" <span class='time'>($Nb)</span>":"")."<br>\n";}echo"<input type='submit' name='clear' value='".lang(146)."'>\n","<a href='".h(ME."sql=&history=all")."'>".lang(147)."</a>\n","</div></fieldset>\n";}echo'</form>
609';}elseif(isset($_GET["edit"])){$b=$_GET["edit"];$o=fields($b);$Z=(isset($_GET["select"])?(count($_POST["check"])==1?where_check($_POST["check"][0],$o):""):where($_GET,$o));$Dg=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($o
610as$F=>$n){if(!isset($n["privileges"][$Dg?"update":"insert"])||$c->fieldName($n)=="")unset($o[$F]);}if($_POST&&!$m&&!isset($_GET["select"])){$B=$_POST["referer"];if($_POST["insert"])$B=($Dg?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$B))$B=ME."select=".urlencode($b);$x=indexes($b);$zg=unique_array($_GET["where"],$x);$Ve="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($B,lang(148),$l->delete($b,$Ve,!$zg));else{$P=array();foreach($o
611as$F=>$n){$X=process_input($n);if($X!==false&&$X!==null)$P[idf_escape($F)]=$X;}if($Dg){if(!$P)redirect($B);queries_redirect($B,lang(149),$l->update($b,$P,$Ve,!$zg));if(is_ajax()){page_headers();page_messages($m);exit;}}else{$J=$l->insert($b,$P);$jd=($J?last_id():0);queries_redirect($B,lang(150,($jd?" $jd":"")),$J);}}}$L=null;if($_POST["save"])$L=(array)$_POST["fields"];elseif($Z){$N=array();foreach($o
612as$F=>$n){if(isset($n["privileges"]["select"])){$ua=convert_field($n);if($_POST["clone"]&&$n["auto_increment"])$ua="''";if($y=="sql"&&preg_match("~enum|set~",$n["type"]))$ua="1*".idf_escape($F);$N[]=($ua?"$ua AS ":"").idf_escape($F);}}$L=array();if(!support("table"))$N=array("*");if($N){$J=$l->select($b,$N,array($Z),$N,array(),(isset($_GET["select"])?2:1));$L=$J->fetch_assoc();if(!$L)$L=false;if(isset($_GET["select"])&&(!$L||$J->fetch_assoc()))$L=null;}}if(!support("table")&&!$o){if(!$Z){$J=$l->select($b,array("*"),$Z,array("*"));$L=($J?$J->fetch_assoc():false);if(!$L)$L=array($l->primary=>"");}if($L){foreach($L
613as$z=>$X){if(!$Z)$L[$z]=null;$o[$z]=array("field"=>$z,"null"=>($z!=$l->primary),"auto_increment"=>($z==$l->primary));}}}edit_form($b,$o,$L,$Dg);}elseif(isset($_GET["create"])){$b=$_GET["create"];$ve=array();foreach(array('HASH','LINEAR HASH','KEY','LINEAR KEY','RANGE','LIST')as$z)$ve[$z]=$z;$bf=referencable_primary($b);$tc=array();foreach($bf
614as$Sf=>$n)$tc[str_replace("`","``",$Sf)."`".str_replace("`","``",$n["field"])]=$Sf;$ne=array();$R=array();if($b!=""){$ne=fields($b);$R=table_status($b);if(!$R)$m=lang(9);}$L=$_POST;$L["fields"]=(array)$L["fields"];if($L["auto_increment_col"])$L["fields"][$L["auto_increment_col"]]["auto_increment"]=true;if($_POST&&!process_fields($L["fields"])&&!$m){if($_POST["drop"])queries_redirect(substr(ME,0,-1),lang(151),drop_tables(array($b)));else{$o=array();$ra=array();$Gg=false;$rc=array();ksort($L["fields"]);$me=reset($ne);$pa=" FIRST";foreach($L["fields"]as$z=>$n){$p=$tc[$n["type"]];$ug=($p!==null?$bf[$p]:$n);if($n["field"]!=""){if(!$n["has_default"])$n["default"]=null;if($z==$L["auto_increment_col"])$n["auto_increment"]=true;$Re=process_field($n,$ug);$ra[]=array($n["orig"],$Re,$pa);if($Re!=process_field($me,$me)){$o[]=array($n["orig"],$Re,$pa);if($n["orig"]!=""||$pa)$Gg=true;}if($p!==null)$rc[idf_escape($n["field"])]=($b!=""&&$y!="sqlite"?"ADD":" ").format_foreign_key(array('table'=>$tc[$n["type"]],'source'=>array($n["field"]),'target'=>array($ug["field"]),'on_delete'=>$n["on_delete"],));$pa=" AFTER ".idf_escape($n["field"]);}elseif($n["orig"]!=""){$Gg=true;$o[]=array($n["orig"]);}if($n["orig"]!=""){$me=next($ne);if(!$me)$pa="";}}$xe="";if($ve[$L["partition_by"]]){$ye=array();if($L["partition_by"]=='RANGE'||$L["partition_by"]=='LIST'){foreach(array_filter($L["partition_names"])as$z=>$X){$Y=$L["partition_values"][$z];$ye[]="\n  PARTITION ".idf_escape($X)." VALUES ".($L["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$xe.="\nPARTITION BY $L[partition_by]($L[partition])".($ye?" (".implode(",",$ye)."\n)":($L["partitions"]?" PARTITIONS ".(+$L["partitions"]):""));}elseif(support("partitioning")&&preg_match("~partitioned~",$R["Create_options"]))$xe.="\nREMOVE PARTITIONING";$D=lang(152);if($b==""){cookie("adminer_engine",$L["Engine"]);$D=lang(153);}$F=trim($L["name"]);queries_redirect(ME.(support("table")?"table=":"select=").urlencode($F),$D,alter_table($b,$F,($y=="sqlite"&&($Gg||$rc)?$ra:$o),$rc,($L["Comment"]!=$R["Comment"]?$L["Comment"]:null),($L["Engine"]&&$L["Engine"]!=$R["Engine"]?$L["Engine"]:""),($L["Collation"]&&$L["Collation"]!=$R["Collation"]?$L["Collation"]:""),($L["Auto_increment"]!=""?number($L["Auto_increment"]):""),$xe));}}page_header(($b!=""?lang(37):lang(62)),$m,array("table"=>$b),h($b));if(!$_POST){$L=array("Engine"=>$_COOKIE["adminer_engine"],"fields"=>array(array("field"=>"","type"=>(isset($wg["int"])?"int":(isset($wg["integer"])?"integer":"")))),"partition_names"=>array(""),);if($b!=""){$L=$R;$L["name"]=$b;$L["fields"]=array();if(!$_GET["auto_increment"])$L["Auto_increment"]="";foreach($ne
615as$n){$n["has_default"]=isset($n["default"]);$L["fields"][]=$n;}if(support("partitioning")){$xc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($b);$J=$g->query("SELECT PARTITION_METHOD, PARTITION_ORDINAL_POSITION, PARTITION_EXPRESSION $xc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");list($L["partition_by"],$L["partitions"],$L["partition"])=$J->fetch_row();$ye=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $xc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$ye[""]="";$L["partition_names"]=array_keys($ye);$L["partition_values"]=array_values($ye);}}}$Xa=collations();$Ub=engines();foreach($Ub
616as$Tb){if(!strcasecmp($Tb,$L["Engine"])){$L["Engine"]=$Tb;break;}}echo'
617<form action="" method="post" id="form">
618<p>
619';if(support("columns")||$b==""){echo
620lang(154),': <input name="name" maxlength="64" value="',h($L["name"]),'" autocapitalize="off">
621';if($b==""&&!$_POST){?><script type='text/javascript'>focus(document.getElementById('form')['name']);</script><?php }echo($Ub?"<select name='Engine' onchange='helpClose();'".on_help("getTarget(event).value",1).">".optionlist(array(""=>"(".lang(155).")")+$Ub,$L["Engine"])."</select>":""),' ',($Xa&&!preg_match("~sqlite|mssql~",$y)?html_select("Collation",array(""=>"(".lang(82).")")+$Xa,$L["Collation"]):""),' <input type="submit" value="',lang(14),'">
622';}echo'
623';if(support("columns")){echo'<table cellspacing="0" id="edit-fields" class="nowrap">
624';$cb=($_POST?$_POST["comments"]:$L["Comment"]!="");if(!$_POST&&!$cb){foreach($L["fields"]as$n){if($n["comment"]!=""){$cb=true;break;}}}edit_fields($L["fields"],$Xa,"TABLE",$tc,$cb);echo'</table>
625<p>
626',lang(52),': <input type="number" name="Auto_increment" size="6" value="',h($L["Auto_increment"]),'">
627',checkbox("defaults",1,true,lang(156),"columnShow(this.checked, 5)","jsonly");if(!$_POST["defaults"]){echo'<script type="text/javascript">editingHideDefaults()</script>';}echo(support("comment")?"<label><input type='checkbox' name='comments' value='1' class='jsonly' onclick=\"columnShow(this.checked, 6); toggle('Comment'); if (this.checked) this.form['Comment'].focus();\"".($cb?" checked":"").">".lang(91)."</label>".' <input name="Comment" id="Comment" value="'.h($L["Comment"]).'" maxlength="'.($g->server_info>=5.5?2048:60).'"'.($cb?'':' class="hidden"').'>':''),'<p>
628<input type="submit" value="',lang(14),'">
629';}echo'
630';if($b!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}if(support("partitioning")){$we=preg_match('~RANGE|LIST~',$L["partition_by"]);print_fieldset("partition",lang(157),$L["partition_by"]);echo'<p>
631',"<select name='partition_by' onchange='partitionByChange(this);'".on_help("getTarget(event).value.replace(/./, 'PARTITION BY \$&')",1).">".optionlist(array(""=>"")+$ve,$L["partition_by"])."</select>",'(<input name="partition" value="',h($L["partition"]),'">)
632',lang(158),': <input type="number" name="partitions" class="size',($we||!$L["partition_by"]?" hidden":""),'" value="',h($L["partitions"]),'">
633<table cellspacing="0" id="partition-table"',($we?"":" class='hidden'"),'>
634<thead><tr><th>',lang(159),'<th>',lang(160),'</thead>
635';foreach($L["partition_names"]as$z=>$X){echo'<tr>','<td><input name="partition_names[]" value="'.h($X).'"'.($z==count($L["partition_names"])-1?' onchange="partitionNameChange(this);"':'').' autocapitalize="off">','<td><input name="partition_values[]" value="'.h($L["partition_values"][$z]).'">';}echo'</table>
636</div></fieldset>
637';}echo'<input type="hidden" name="token" value="',$T,'">
638</form>
639';}elseif(isset($_GET["indexes"])){$b=$_GET["indexes"];$Nc=array("PRIMARY","UNIQUE","INDEX");$R=table_status($b,true);if(preg_match('~MyISAM|M?aria'.($g->server_info>=5.6?'|InnoDB':'').'~i',$R["Engine"]))$Nc[]="FULLTEXT";$x=indexes($b);$Le=array();if($y=="mongo"){$Le=$x["_id_"];unset($Nc[0]);unset($x["_id_"]);}$L=$_POST;if($_POST&&!$m&&!$_POST["add"]&&!$_POST["drop_col"]){$sa=array();foreach($L["indexes"]as$w){$F=$w["name"];if(in_array($w["type"],$Nc)){$e=array();$pd=array();$yb=array();$P=array();ksort($w["columns"]);foreach($w["columns"]as$z=>$d){if($d!=""){$od=$w["lengths"][$z];$xb=$w["descs"][$z];$P[]=idf_escape($d).($od?"(".(+$od).")":"").($xb?" DESC":"");$e[]=$d;$pd[]=($od?$od:null);$yb[]=$xb;}}if($e){$dc=$x[$F];if($dc){ksort($dc["columns"]);ksort($dc["lengths"]);ksort($dc["descs"]);if($w["type"]==$dc["type"]&&array_values($dc["columns"])===$e&&(!$dc["lengths"]||array_values($dc["lengths"])===$pd)&&array_values($dc["descs"])===$yb){unset($x[$F]);continue;}}$sa[]=array($w["type"],$F,$P);}}}foreach($x
640as$F=>$dc)$sa[]=array($dc["type"],$F,"DROP");if(!$sa)redirect(ME."table=".urlencode($b));queries_redirect(ME."table=".urlencode($b),lang(161),alter_indexes($b,$sa));}page_header(lang(115),$m,array("table"=>$b),h($b));$o=array_keys(fields($b));if($_POST["add"]){foreach($L["indexes"]as$z=>$w){if($w["columns"][count($w["columns"])]!="")$L["indexes"][$z]["columns"][]="";}$w=end($L["indexes"]);if($w["type"]||array_filter($w["columns"],'strlen'))$L["indexes"][]=array("columns"=>array(1=>""));}if(!$L){foreach($x
641as$z=>$w){$x[$z]["name"]=$z;$x[$z]["columns"][]="";}$x[]=array("columns"=>array(1=>""));$L["indexes"]=$x;}echo'
642<form action="" method="post">
643<table cellspacing="0" class="nowrap">
644<thead><tr>
645<th>',lang(162),'<th><input type="submit" style="left: -1000px; position: absolute;">',lang(163),'<th>',lang(164);?>
646<th><noscript><input type='image' class='icon' name='add[0]' src='" . h(preg_replace("~\\?.*~", "", ME)) . "?file=plus.gif&amp;version=4.2.3&amp;driver=mysql' alt='+' title='<?php echo
647lang(92),'\'></noscript>&nbsp;
648</thead>
649';if($Le){echo"<tr><td>PRIMARY<td>";foreach($Le["columns"]as$z=>$d){echo
650select_input(" disabled",$o,$d),"<label><input disabled type='checkbox'>".lang(46)."</label> ";}echo"<td><td>\n";}$ad=1;foreach($L["indexes"]as$w){if(!$_POST["drop_col"]||$ad!=key($_POST["drop_col"])){echo"<tr><td>".html_select("indexes[$ad][type]",array(-1=>"")+$Nc,$w["type"],($ad==count($L["indexes"])?"indexesAddRow(this);":1)),"<td>";ksort($w["columns"]);$u=1;foreach($w["columns"]as$z=>$d){echo"<span>".select_input(" name='indexes[$ad][columns][$u]' onchange=\"".($u==count($w["columns"])?"indexesAddColumn":"indexesChangeColumn")."(this, '".h(js_escape($y=="sql"?"":$_GET["indexes"]."_"))."');\"",($o?array_combine($o,$o):$o),$d),($y=="sql"||$y=="mssql"?"<input type='number' name='indexes[$ad][lengths][$u]' class='size' value='".h($w["lengths"][$z])."'>":""),($y!="sql"?checkbox("indexes[$ad][descs][$u]",1,$w["descs"][$z],lang(46)):"")," </span>";$u++;}echo"<td><input name='indexes[$ad][name]' value='".h($w["name"])."' autocapitalize='off'>\n","<td><input type='image' class='icon' name='drop_col[$ad]' src='".h(preg_replace("~\\?.*~","",ME))."?file=cross.gif&amp;version=4.2.3&amp;driver=mysql' alt='x' title='".lang(95)."' onclick=\"return !editingRemoveRow(this, 'indexes\$1[type]');\">\n";}$ad++;}echo'</table>
651<p>
652<input type="submit" value="',lang(14),'">
653<input type="hidden" name="token" value="',$T,'">
654</form>
655';}elseif(isset($_GET["database"])){$L=$_POST;if($_POST&&!$m&&!isset($_POST["add_x"])){$F=trim($L["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),lang(165),drop_databases(array(DB)));}elseif(DB!==$F){if(DB!=""){$_GET["db"]=$F;queries_redirect(preg_replace('~\bdb=[^&]*&~','',ME)."db=".urlencode($F),lang(166),rename_database($F,$L["collation"]));}else{$j=explode("\n",str_replace("\r","",$F));$Mf=true;$id="";foreach($j
656as$k){if(count($j)==1||$k!=""){if(!create_database($k,$L["collation"]))$Mf=false;$id=$k;}}restart_session();set_session("dbs",null);queries_redirect(ME."db=".urlencode($id),lang(167),$Mf);}}else{if(!$L["collation"])redirect(substr(ME,0,-1));query_redirect("ALTER DATABASE ".idf_escape($F).(preg_match('~^[a-z0-9_]+$~i',$L["collation"])?" COLLATE $L[collation]":""),substr(ME,0,-1),lang(168));}}page_header(DB!=""?lang(55):lang(169),$m,array(),h(DB));$Xa=collations();$F=DB;if($_POST)$F=$L["name"];elseif(DB!="")$L["collation"]=db_collation(DB,$Xa);elseif($y=="sql"){foreach(get_vals("SHOW GRANTS")as$s){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\\.\\*)?~',$s,$C)&&$C[1]){$F=stripcslashes(idf_unescape("`$C[2]`"));break;}}}echo'
657<form action="" method="post">
658<p>
659',($_POST["add_x"]||strpos($F,"\n")?'<textarea id="name" name="name" rows="10" cols="40">'.h($F).'</textarea><br>':'<input name="name" id="name" value="'.h($F).'" maxlength="64" autocapitalize="off">')."\n".($Xa?html_select("collation",array(""=>"(".lang(82).")")+$Xa,$L["collation"]).doc_link(array('sql'=>"charset-charsets.html",'mssql'=>"ms187963.aspx",)):"");?>
660<script type='text/javascript'>focus(document.getElementById('name'));</script>
661<input type="submit" value="<?php echo
662lang(14),'">
663';if(DB!="")echo"<input type='submit' name='drop' value='".lang(111)."'".confirm().">\n";elseif(!$_POST["add_x"]&&$_GET["db"]=="")echo"<input type='image' class='icon' name='add' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.3&amp;driver=mysql' alt='+' title='".lang(92)."'>\n";echo'<input type="hidden" name="token" value="',$T,'">
664</form>
665';}elseif(isset($_GET["call"])){$ca=$_GET["call"];page_header(lang(170).": ".h($ca),$m);$mf=routine($ca,(isset($_GET["callf"])?"FUNCTION":"PROCEDURE"));$Mc=array();$pe=array();foreach($mf["fields"]as$u=>$n){if(substr($n["inout"],-3)=="OUT")$pe[$u]="@".idf_escape($n["field"])." AS ".idf_escape($n["field"]);if(!$n["inout"]||substr($n["inout"],0,2)=="IN")$Mc[]=$u;}if(!$m&&$_POST){$Ja=array();foreach($mf["fields"]as$z=>$n){if(in_array($z,$Mc)){$X=process_input($n);if($X===false)$X="''";if(isset($pe[$z]))$g->query("SET @".idf_escape($n["field"])." = $X");}$Ja[]=(isset($pe[$z])?"@".idf_escape($n["field"]):$X);}$I=(isset($_GET["callf"])?"SELECT":"CALL")." ".idf_escape($ca)."(".implode(", ",$Ja).")";echo"<p><code class='jush-$y'>".h($I)."</code> <a href='".h(ME)."sql=".urlencode($I)."'>".lang(10)."</a>\n";if(!$g->multi_query($I))echo"<p class='error'>".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
666echo"<p class='message'>".lang(171,$g->affected_rows)."\n";}while($g->next_result());if($pe)select($g->query("SELECT ".implode(", ",$pe)));}}echo'
667<form action="" method="post">
668';if($Mc){echo"<table cellspacing='0'>\n";foreach($Mc
669as$z){$n=$mf["fields"][$z];$F=$n["field"];echo"<tr><th>".$c->fieldName($n);$Y=$_POST["fields"][$F];if($Y!=""){if($n["type"]=="enum")$Y=+$Y;if($n["type"]=="set")$Y=array_sum($Y);}input($n,$Y,(string)$_POST["function"][$F]);echo"\n";}echo"</table>\n";}echo'<p>
670<input type="submit" value="',lang(170),'">
671<input type="hidden" name="token" value="',$T,'">
672</form>
673';}elseif(isset($_GET["foreign"])){$b=$_GET["foreign"];$F=$_GET["name"];$L=$_POST;if($_POST&&!$m&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){$D=($_POST["drop"]?lang(172):($F!=""?lang(173):lang(174)));$B=ME."table=".urlencode($b);$L["source"]=array_filter($L["source"],'strlen');ksort($L["source"]);$Yf=array();foreach($L["source"]as$z=>$X)$Yf[$z]=$L["target"][$z];$L["target"]=$Yf;if($y=="sqlite")queries_redirect($B,$D,recreate_table($b,$b,array(),array(),array(" $F"=>($_POST["drop"]?"":" ".format_foreign_key($L)))));else{$sa="ALTER TABLE ".table($b);$Fb="\nDROP ".($y=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($F);if($_POST["drop"])query_redirect($sa.$Fb,$B,$D);else{query_redirect($sa.($F!=""?"$Fb,":"")."\nADD".format_foreign_key($L),$B,$D);$m=lang(175)."<br>$m";}}}page_header(lang(176),$m,array("table"=>$b),h($b));if($_POST){ksort($L["source"]);if($_POST["add"])$L["source"][]="";elseif($_POST["change"]||$_POST["change-js"])$L["target"]=array();}elseif($F!=""){$tc=foreign_keys($b);$L=$tc[$F];$L["source"][]="";}else{$L["table"]=$b;$L["source"]=array("");}$Cf=array_keys(fields($b));$Yf=($b===$L["table"]?$Cf:array_keys(fields($L["table"])));$af=array_keys(array_filter(table_status('',true),'fk_support'));echo'
674<form action="" method="post">
675<p>
676';if($L["db"]==""&&$L["ns"]==""){echo
677lang(177),':
678',html_select("table",$af,$L["table"],"this.form['change-js'].value = '1'; this.form.submit();"),'<input type="hidden" name="change-js" value="">
679<noscript><p><input type="submit" name="change" value="',lang(178),'"></noscript>
680<table cellspacing="0">
681<thead><tr><th>',lang(117),'<th>',lang(118),'</thead>
682';$ad=0;foreach($L["source"]as$z=>$X){echo"<tr>","<td>".html_select("source[".(+$z)."]",array(-1=>"")+$Cf,$X,($ad==count($L["source"])-1?"foreignAddRow(this);":1)),"<td>".html_select("target[".(+$z)."]",$Yf,$L["target"][$z]);$ad++;}echo'</table>
683<p>
684',lang(84),': ',html_select("on_delete",array(-1=>"")+explode("|",$Zd),$L["on_delete"]),' ',lang(83),': ',html_select("on_update",array(-1=>"")+explode("|",$Zd),$L["on_update"]),doc_link(array('sql'=>"innodb-foreign-key-constraints.html",'pgsql'=>"sql-createtable.html#SQL-CREATETABLE-REFERENCES",'mssql'=>"ms174979.aspx",'oracle'=>"clauses002.htm#sthref2903",)),'<p>
685<input type="submit" value="',lang(14),'">
686<noscript><p><input type="submit" name="add" value="',lang(179),'"></noscript>
687';}if($F!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
688</form>
689';}elseif(isset($_GET["view"])){$b=$_GET["view"];$L=$_POST;if($_POST&&!$m){$F=trim($L["name"]);$ua=" AS\n$L[select]";$B=ME."table=".urlencode($F);$D=lang(180);if($_GET["materialized"])$U="MATERIALIZED VIEW";else{$U="VIEW";if($y=="pgsql"){$Gf=table_status($F);$U=($Gf?strtoupper($Gf["Engine"]):$U);}}if(!$_POST["drop"]&&$b==$F&&$y!="sqlite"&&$U!="MATERIALIZED VIEW")query_redirect(($y=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($F).$ua,$B,$D);else{$ag=$F."_adminer_".uniqid();drop_create("DROP $U ".table($b),"CREATE $U ".table($F).$ua,"DROP $U ".table($F),"CREATE $U ".table($ag).$ua,"DROP $U ".table($ag),($_POST["drop"]?substr(ME,0,-1):$B),lang(181),$D,lang(182),$b,$F);}}if(!$_POST&&$b!=""){$L=view($b);$L["name"]=$b;if(!$m)$m=error();}page_header(($b!=""?lang(36):lang(183)),$m,array("table"=>$b),h($b));echo'
690<form action="" method="post">
691<p>',lang(164),': <input name="name" value="',h($L["name"]),'" maxlength="64" autocapitalize="off">
692<p>';textarea("select",$L["select"]);echo'<p>
693<input type="submit" value="',lang(14),'">
694';if($_GET["view"]!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
695</form>
696';}elseif(isset($_GET["event"])){$aa=$_GET["event"];$Sc=array("YEAR","QUARTER","MONTH","DAY","HOUR","MINUTE","WEEK","SECOND","YEAR_MONTH","DAY_HOUR","DAY_MINUTE","DAY_SECOND","HOUR_MINUTE","HOUR_SECOND","MINUTE_SECOND");$Hf=array("ENABLED"=>"ENABLE","DISABLED"=>"DISABLE","SLAVESIDE_DISABLED"=>"DISABLE ON SLAVE");$L=$_POST;if($_POST&&!$m){if($_POST["drop"])query_redirect("DROP EVENT ".idf_escape($aa),substr(ME,0,-1),lang(184));elseif(in_array($L["INTERVAL_FIELD"],$Sc)&&isset($Hf[$L["STATUS"]])){$qf="\nON SCHEDULE ".($L["INTERVAL_VALUE"]?"EVERY ".q($L["INTERVAL_VALUE"])." $L[INTERVAL_FIELD]".($L["STARTS"]?" STARTS ".q($L["STARTS"]):"").($L["ENDS"]?" ENDS ".q($L["ENDS"]):""):"AT ".q($L["STARTS"]))." ON COMPLETION".($L["ON_COMPLETION"]?"":" NOT")." PRESERVE";queries_redirect(substr(ME,0,-1),($aa!=""?lang(185):lang(186)),queries(($aa!=""?"ALTER EVENT ".idf_escape($aa).$qf.($aa!=$L["EVENT_NAME"]?"\nRENAME TO ".idf_escape($L["EVENT_NAME"]):""):"CREATE EVENT ".idf_escape($L["EVENT_NAME"]).$qf)."\n".$Hf[$L["STATUS"]]." COMMENT ".q($L["EVENT_COMMENT"]).rtrim(" DO\n$L[EVENT_DEFINITION]",";").";"));}}page_header(($aa!=""?lang(187).": ".h($aa):lang(188)),$m);if(!$L&&$aa!=""){$M=get_rows("SELECT * FROM information_schema.EVENTS WHERE EVENT_SCHEMA = ".q(DB)." AND EVENT_NAME = ".q($aa));$L=reset($M);}echo'
697<form action="" method="post">
698<table cellspacing="0">
699<tr><th>',lang(164),'<td><input name="EVENT_NAME" value="',h($L["EVENT_NAME"]),'" maxlength="64" autocapitalize="off">
700<tr><th title="datetime">',lang(189),'<td><input name="STARTS" value="',h("$L[EXECUTE_AT]$L[STARTS]"),'">
701<tr><th title="datetime">',lang(190),'<td><input name="ENDS" value="',h($L["ENDS"]),'">
702<tr><th>',lang(191),'<td><input type="number" name="INTERVAL_VALUE" value="',h($L["INTERVAL_VALUE"]),'" class="size"> ',html_select("INTERVAL_FIELD",$Sc,$L["INTERVAL_FIELD"]),'<tr><th>',lang(102),'<td>',html_select("STATUS",$Hf,$L["STATUS"]),'<tr><th>',lang(91),'<td><input name="EVENT_COMMENT" value="',h($L["EVENT_COMMENT"]),'" maxlength="64">
703<tr><th>&nbsp;<td>',checkbox("ON_COMPLETION","PRESERVE",$L["ON_COMPLETION"]=="PRESERVE",lang(192)),'</table>
704<p>';textarea("EVENT_DEFINITION",$L["EVENT_DEFINITION"]);echo'<p>
705<input type="submit" value="',lang(14),'">
706';if($aa!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
707</form>
708';}elseif(isset($_GET["procedure"])){$ca=$_GET["procedure"];$mf=(isset($_GET["function"])?"FUNCTION":"PROCEDURE");$L=$_POST;$L["fields"]=(array)$L["fields"];if($_POST&&!process_fields($L["fields"])&&!$m){$ag="$L[name]_adminer_".uniqid();drop_create("DROP $mf ".idf_escape($ca),create_routine($mf,$L),"DROP $mf ".idf_escape($L["name"]),create_routine($mf,array("name"=>$ag)+$L),"DROP $mf ".idf_escape($ag),substr(ME,0,-1),lang(193),lang(194),lang(195),$ca,$L["name"]);}page_header(($ca!=""?(isset($_GET["function"])?lang(196):lang(197)).": ".h($ca):(isset($_GET["function"])?lang(198):lang(199))),$m);if(!$_POST&&$ca!=""){$L=routine($ca,$mf);$L["name"]=$ca;}$Xa=get_vals("SHOW CHARACTER SET");sort($Xa);$nf=routine_languages();echo'
709<form action="" method="post" id="form">
710<p>',lang(164),': <input name="name" value="',h($L["name"]),'" maxlength="64" autocapitalize="off">
711',($nf?lang(19).": ".html_select("language",$nf,$L["language"]):""),'<input type="submit" value="',lang(14),'">
712<table cellspacing="0" class="nowrap">
713';edit_fields($L["fields"],$Xa,$mf);if(isset($_GET["function"])){echo"<tr><td>".lang(200);edit_type("returns",$L["returns"],$Xa);}echo'</table>
714<p>';textarea("definition",$L["definition"]);echo'<p>
715<input type="submit" value="',lang(14),'">
716';if($ca!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
717</form>
718';}elseif(isset($_GET["trigger"])){$b=$_GET["trigger"];$F=$_GET["name"];$sg=trigger_options();$L=(array)trigger($F)+array("Trigger"=>$b."_bi");if($_POST){if(!$m&&in_array($_POST["Timing"],$sg["Timing"])&&in_array($_POST["Event"],$sg["Event"])&&in_array($_POST["Type"],$sg["Type"])){$Yd=" ON ".table($b);$Fb="DROP TRIGGER ".idf_escape($F).($y=="pgsql"?$Yd:"");$B=ME."table=".urlencode($b);if($_POST["drop"])query_redirect($Fb,$B,lang(201));else{if($F!="")queries($Fb);queries_redirect($B,($F!=""?lang(202):lang(203)),queries(create_trigger($Yd,$_POST)));if($F!="")queries(create_trigger($Yd,$L+array("Type"=>reset($sg["Type"]))));}}$L=$_POST;}page_header(($F!=""?lang(204).": ".h($F):lang(205)),$m,array("table"=>$b));echo'
719<form action="" method="post" id="form">
720<table cellspacing="0">
721<tr><th>',lang(206),'<td>',html_select("Timing",$sg["Timing"],$L["Timing"],"triggerChange(/^".preg_quote($b,"/")."_[ba][iud]$/, '".js_escape($b)."', this.form);"),'<tr><th>',lang(207),'<td>',html_select("Event",$sg["Event"],$L["Event"],"this.form['Timing'].onchange();"),(in_array("UPDATE OF",$sg["Event"])?" <input name='Of' value='".h($L["Of"])."' class='hidden'>":""),'<tr><th>',lang(87),'<td>',html_select("Type",$sg["Type"],$L["Type"]),'</table>
722<p>',lang(164),': <input name="Trigger" value="',h($L["Trigger"]);?>" maxlength="64" autocapitalize="off">
723<script type="text/javascript">document.getElementById('form')['Timing'].onchange();</script>
724<p><?php textarea("Statement",$L["Statement"]);echo'<p>
725<input type="submit" value="',lang(14),'">
726';if($F!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
727</form>
728';}elseif(isset($_GET["user"])){$ea=$_GET["user"];$Pe=array(""=>array("All privileges"=>""));foreach(get_rows("SHOW PRIVILEGES")as$L){foreach(explode(",",($L["Privilege"]=="Grant option"?"":$L["Context"]))as$hb)$Pe[$hb][$L["Privilege"]]=$L["Comment"];}$Pe["Server Admin"]+=$Pe["File access on server"];$Pe["Databases"]["Create routine"]=$Pe["Procedures"]["Create routine"];unset($Pe["Procedures"]["Create routine"]);$Pe["Columns"]=array();foreach(array("Select","Insert","Update","References")as$X)$Pe["Columns"][$X]=$Pe["Tables"][$X];unset($Pe["Server Admin"]["Usage"]);foreach($Pe["Tables"]as$z=>$X)unset($Pe["Databases"][$z]);$Ld=array();if($_POST){foreach($_POST["objects"]as$z=>$X)$Ld[$X]=(array)$Ld[$X]+(array)$_POST["grants"][$z];}$zc=array();$Wd="";if(isset($_GET["host"])&&($J=$g->query("SHOW GRANTS FOR ".q($ea)."@".q($_GET["host"])))){while($L=$J->fetch_row()){if(preg_match('~GRANT (.*) ON (.*) TO ~',$L[0],$C)&&preg_match_all('~ *([^(,]*[^ ,(])( *\\([^)]+\\))?~',$C[1],$vd,PREG_SET_ORDER)){foreach($vd
729as$X){if($X[1]!="USAGE")$zc["$C[2]$X[2]"][$X[1]]=true;if(preg_match('~ WITH GRANT OPTION~',$L[0]))$zc["$C[2]$X[2]"]["GRANT OPTION"]=true;}}if(preg_match("~ IDENTIFIED BY PASSWORD '([^']+)~",$L[0],$C))$Wd=$C[1];}}if($_POST&&!$m){$Xd=(isset($_GET["host"])?q($ea)."@".q($_GET["host"]):"''");if($_POST["drop"])query_redirect("DROP USER $Xd",ME."privileges=",lang(208));else{$Nd=q($_POST["user"])."@".q($_POST["host"]);$ze=$_POST["pass"];if($ze!=''&&!$_POST["hashed"]){$ze=$g->result("SELECT PASSWORD(".q($ze).")");$m=!$ze;}$lb=false;if(!$m){if($Xd!=$Nd){$lb=queries(($g->server_info<5?"GRANT USAGE ON *.* TO":"CREATE USER")." $Nd IDENTIFIED BY PASSWORD ".q($ze));$m=!$lb;}elseif($ze!=$Wd)queries("SET PASSWORD FOR $Nd = ".q($ze));}if(!$m){$jf=array();foreach($Ld
730as$Rd=>$s){if(isset($_GET["grant"]))$s=array_filter($s);$s=array_keys($s);if(isset($_GET["grant"]))$jf=array_diff(array_keys(array_filter($Ld[$Rd],'strlen')),$s);elseif($Xd==$Nd){$Ud=array_keys((array)$zc[$Rd]);$jf=array_diff($Ud,$s);$s=array_diff($s,$Ud);unset($zc[$Rd]);}if(preg_match('~^(.+)\\s*(\\(.*\\))?$~U',$Rd,$C)&&(!grant("REVOKE",$jf,$C[2]," ON $C[1] FROM $Nd")||!grant("GRANT",$s,$C[2]," ON $C[1] TO $Nd"))){$m=true;break;}}}if(!$m&&isset($_GET["host"])){if($Xd!=$Nd)queries("DROP USER $Xd");elseif(!isset($_GET["grant"])){foreach($zc
731as$Rd=>$jf){if(preg_match('~^(.+)(\\(.*\\))?$~U',$Rd,$C))grant("REVOKE",array_keys($jf),$C[2]," ON $C[1] FROM $Nd");}}}queries_redirect(ME."privileges=",(isset($_GET["host"])?lang(209):lang(210)),!$m);if($lb)$g->query("DROP USER $Nd");}}page_header((isset($_GET["host"])?lang(29).": ".h("$ea@$_GET[host]"):lang(129)),$m,array("privileges"=>array('',lang(59))));if($_POST){$L=$_POST;$zc=$Ld;}else{$L=$_GET+array("host"=>$g->result("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', -1)"));$L["pass"]=$Wd;if($Wd!="")$L["hashed"]=true;$zc[(DB==""||$zc?"":idf_escape(addcslashes(DB,"%_\\"))).".*"]=array();}echo'<form action="" method="post">
732<table cellspacing="0">
733<tr><th>',lang(28),'<td><input name="host" maxlength="60" value="',h($L["host"]),'" autocapitalize="off">
734<tr><th>',lang(29),'<td><input name="user" maxlength="16" value="',h($L["user"]),'" autocapitalize="off">
735<tr><th>',lang(30),'<td><input name="pass" id="pass" value="',h($L["pass"]),'">
736';if(!$L["hashed"]){echo'<script type="text/javascript">typePassword(document.getElementById(\'pass\'));</script>';}echo
737checkbox("hashed",1,$L["hashed"],lang(211),"typePassword(this.form['pass'], this.checked);"),'</table>
738
739';echo"<table cellspacing='0'>\n","<thead><tr><th colspan='2'>".lang(59).doc_link(array('sql'=>"grant.html#priv_level"));$u=0;foreach($zc
740as$Rd=>$s){echo'<th>'.($Rd!="*.*"?"<input name='objects[$u]' value='".h($Rd)."' size='10' autocapitalize='off'>":"<input type='hidden' name='objects[$u]' value='*.*' size='10'>*.*");$u++;}echo"</thead>\n";foreach(array(""=>"","Server Admin"=>lang(28),"Databases"=>lang(31),"Tables"=>lang(113),"Columns"=>lang(114),"Procedures"=>lang(212),)as$hb=>$xb){foreach((array)$Pe[$hb]as$Oe=>$bb){echo"<tr".odd()."><td".($xb?">$xb<td":" colspan='2'").' lang="en" title="'.h($bb).'">'.h($Oe);$u=0;foreach($zc
741as$Rd=>$s){$F="'grants[$u][".h(strtoupper($Oe))."]'";$Y=$s[strtoupper($Oe)];if($hb=="Server Admin"&&$Rd!=(isset($zc["*.*"])?"*.*":".*"))echo"<td>&nbsp;";elseif(isset($_GET["grant"]))echo"<td><select name=$F><option><option value='1'".($Y?" selected":"").">".lang(213)."<option value='0'".($Y=="0"?" selected":"").">".lang(214)."</select>";else
742echo"<td align='center'><label class='block'><input type='checkbox' name=$F value='1'".($Y?" checked":"").($Oe=="All privileges"?" id='grants-$u-all'":($Oe=="Grant option"?"":" onclick=\"if (this.checked) formUncheck('grants-$u-all');\""))."></label>";$u++;}}}echo"</table>\n",'<p>
743<input type="submit" value="',lang(14),'">
744';if(isset($_GET["host"])){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
745</form>
746';}elseif(isset($_GET["processlist"])){if(support("kill")&&$_POST&&!$m){$ed=0;foreach((array)$_POST["kill"]as$X){if(queries("KILL ".number($X)))$ed++;}queries_redirect(ME."processlist=",lang(215,$ed),$ed||!$_POST["kill"]);}page_header(lang(100),$m);echo'
747<form action="" method="post">
748<table cellspacing="0" onclick="tableClick(event);" ondblclick="tableClick(event, true);" class="nowrap checkable">
749';$u=-1;foreach(process_list()as$u=>$L){if(!$u){echo"<thead><tr lang='en'>".(support("kill")?"<th>&nbsp;":"");foreach($L
750as$z=>$X)echo"<th>$z".doc_link(array('sql'=>"show-processlist.html#processlist_".strtolower($z),'pgsql'=>"monitoring-stats.html#PG-STAT-ACTIVITY-VIEW",'oracle'=>"../b14237/dynviews_2088.htm",));echo"</thead>\n";}echo"<tr".odd().">".(support("kill")?"<td>".checkbox("kill[]",$L["Id"],0):"");foreach($L
751as$z=>$X)echo"<td>".(($y=="sql"&&$z=="Info"&&preg_match("~Query|Killed~",$L["Command"])&&$X!="")||($y=="pgsql"&&$z=="current_query"&&$X!="<IDLE>")||($y=="oracle"&&$z=="sql_text"&&$X!="")?"<code class='jush-$y'>".shorten_utf8($X,100,"</code>").' <a href="'.h(ME.($L["db"]!=""?"db=".urlencode($L["db"])."&":"")."sql=".urlencode($X)).'">'.lang(216).'</a>':nbsp($X));echo"\n";}echo'</table>
752<script type=\'text/javascript\'>tableCheck();</script>
753<p>
754';if(support("kill")){echo($u+1)."/".lang(217,$g->result("SELECT @@max_connections")),"<p><input type='submit' value='".lang(218)."'>\n";}echo'<input type="hidden" name="token" value="',$T,'">
755</form>
756';}elseif(isset($_GET["select"])){$b=$_GET["select"];$R=table_status1($b);$x=indexes($b);$o=fields($b);$tc=column_foreign_keys($b);$Td="";if($R["Oid"]){$Td=($y=="sqlite"?"rowid":"oid");$x[]=array("type"=>"PRIMARY","columns"=>array($Td));}parse_str($_COOKIE["adminer_import"],$ma);$kf=array();$e=array();$dg=null;foreach($o
757as$z=>$n){$F=$c->fieldName($n);if(isset($n["privileges"]["select"])&&$F!=""){$e[$z]=html_entity_decode(strip_tags($F),ENT_QUOTES);if(is_shortable($n))$dg=$c->selectLengthProcess();}$kf+=$n["privileges"];}list($N,$t)=$c->selectColumnsProcess($e,$x);$Wc=count($t)<count($N);$Z=$c->selectSearchProcess($o,$x);$he=$c->selectOrderProcess($o,$x);$_=$c->selectLimitProcess();$xc=($N?implode(", ",$N):"*".($Td?", $Td":"")).convert_fields($e,$o,$N)."\nFROM ".table($b);$_c=($t&&$Wc?"\nGROUP BY ".implode(", ",$t):"").($he?"\nORDER BY ".implode(", ",$he):"");if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$_g=>$L){$ua=convert_field($o[key($L)]);$N=array($ua?$ua:idf_escape(key($L)));$Z[]=where_check($_g,$o);$K=$l->select($b,$N,$Z,$N);if($K)echo
758reset($K->fetch_row());}exit;}if($_POST&&!$m){$Sg=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Oa=array();foreach($_POST["check"]as$Ma)$Oa[]=where_check($Ma,$o);$Sg[]="((".implode(") OR (",$Oa)."))";}$Sg=($Sg?"\nWHERE ".implode(" AND ",$Sg):"");$Le=$Bg=null;foreach($x
759as$w){if($w["type"]=="PRIMARY"){$Le=array_flip($w["columns"]);$Bg=($N?$Le:array());break;}}foreach((array)$Bg
760as$z=>$X){if(in_array(idf_escape($z),$N))unset($Bg[$z]);}if($_POST["export"]){cookie("adminer_import","output=".urlencode($_POST["output"])."&format=".urlencode($_POST["format"]));dump_headers($b);$c->dumpTable($b,"");if(!is_array($_POST["check"])||$Bg===array())$I="SELECT $xc$Sg$_c";else{$yg=array();foreach($_POST["check"]as$X)$yg[]="(SELECT".limit($xc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o).$_c,1).")";$I=implode(" UNION ALL ",$yg);}$c->dumpData($b,"table",$I);exit;}if(!$c->selectEmailProcess($Z,$tc)){if($_POST["save"]||$_POST["delete"]){$J=true;$na=0;$P=array();if(!$_POST["delete"]){foreach($e
761as$F=>$X){$X=process_input($o[$F]);if($X!==null&&($_POST["clone"]||$X!==false))$P[idf_escape($F)]=($X!==false?$X:idf_escape($F));}}if($_POST["delete"]||$P){if($_POST["clone"])$I="INTO ".table($b)." (".implode(", ",array_keys($P)).")\nSELECT ".implode(", ",$P)."\nFROM ".table($b);if($_POST["all"]||($Bg===array()&&is_array($_POST["check"]))||$Wc){$J=($_POST["delete"]?$l->delete($b,$Sg):($_POST["clone"]?queries("INSERT $I$Sg"):$l->update($b,$P,$Sg)));$na=$g->affected_rows;}else{foreach((array)$_POST["check"]as$X){$Rg="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o);$J=($_POST["delete"]?$l->delete($b,$Rg,1):($_POST["clone"]?queries("INSERT".limit1($I,$Rg)):$l->update($b,$P,$Rg)));if(!$J)break;$na+=$g->affected_rows;}}}$D=lang(219,$na);if($_POST["clone"]&&$J&&$na==1){$jd=last_id();if($jd)$D=lang(150," $jd");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$D,$J);if(!$_POST["delete"]){edit_form($b,$o,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$m=lang(220);else{$J=true;$na=0;foreach($_POST["val"]as$_g=>$L){$P=array();foreach($L
762as$z=>$X){$z=bracket_escape($z,1);$P[idf_escape($z)]=(preg_match('~char|text~',$o[$z]["type"])||$X!=""?$c->processInput($o[$z],$X):"NULL");}$J=$l->update($b,$P," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($_g,$o),!($Wc||$Bg===array())," ");if(!$J)break;$na+=$g->affected_rows;}queries_redirect(remove_from_uri(),lang(219,$na),$J);}}elseif(!is_string($mc=get_file("csv_file",true)))$m=upload_error($mc);elseif(!preg_match('~~u',$mc))$m=lang(221);else{cookie("adminer_import","output=".urlencode($ma["output"])."&format=".urlencode($_POST["separator"]));$J=true;$Ya=array_keys($o);preg_match_all('~(?>"[^"]*"|[^"\\r\\n]+)+~',$mc,$vd);$na=count($vd[0]);$l->begin();$wf=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$M=array();foreach($vd[0]as$z=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$wf]*)$wf~",$X.$wf,$wd);if(!$z&&!array_diff($wd[1],$Ya)){$Ya=$wd[1];$na--;}else{$P=array();foreach($wd[1]as$u=>$Ua)$P[idf_escape($Ya[$u])]=($Ua==""&&$o[$Ya[$u]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$Ua))));$M[]=$P;}}$J=(!$M||$l->insertUpdate($b,$M,$Le));if($J)$l->commit();queries_redirect(remove_from_uri("page"),lang(222,$na),$J);$l->rollback();}}}$Sf=$c->tableName($R);if(is_ajax()){page_headers();ob_start();}else
763page_header(lang(40).": $Sf",$m);$P=null;if(isset($kf["insert"])||!support("table")){$P="";foreach((array)$_GET["where"]as$X){if(count($tc[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!preg_match('~[_%]~',$X["val"]))))$P.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$c->selectLinks($R,$P);if(!$e&&support("table"))echo"<p class='error'>".lang(223).($o?".":": ".error())."\n";else{echo"<form action='' id='form'>\n","<div style='display: none;'>";hidden_fields_get();echo(DB!=""?'<input type="hidden" name="db" value="'.h(DB).'">'.(isset($_GET["ns"])?'<input type="hidden" name="ns" value="'.h($_GET["ns"]).'">':""):"");echo'<input type="hidden" name="select" value="'.h($b).'">',"</div>\n";$c->selectColumnsPrint($N,$e);$c->selectSearchPrint($Z,$e,$x);$c->selectOrderPrint($he,$e,$x);$c->selectLimitPrint($_);$c->selectLengthPrint($dg);$c->selectActionPrint($x);echo"</form>\n";$G=$_GET["page"];if($G=="last"){$wc=$g->result(count_rows($b,$Z,$Wc,$t));$G=floor(max(0,$wc-1)/$_);}$tf=$N;if(!$tf){$tf[]="*";if($Td)$tf[]=$Td;}$ib=convert_fields($e,$o,$N);if($ib)$tf[]=substr($ib,2);$J=$l->select($b,$tf,$Z,$t,$he,$_,$G,true);if(!$J)echo"<p class='error'>".error()."\n";else{if($y=="mssql"&&$G)$J->seek($_*$G);$Rb=array();echo"<form action='' method='post' enctype='multipart/form-data'>\n";$M=array();while($L=$J->fetch_assoc()){if($G&&$y=="oracle")unset($L["RNUM"]);$M[]=$L;}if($_GET["page"]!="last"&&+$_&&$t&&$Wc&&$y=="sql")$wc=$g->result(" SELECT FOUND_ROWS()");if(!$M)echo"<p class='message'>".lang(12)."\n";else{$Ba=$c->backwardKeys($b,$Sf);echo"<table id='table' cellspacing='0' class='nowrap checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);' onkeydown='return editingKeydown(event);'>\n","<thead><tr>".(!$t&&$N?"":"<td><input type='checkbox' id='all-page' onclick='formCheck(this, /check/);'> <a href='".h($_GET["modify"]?remove_from_uri("modify"):$_SERVER["REQUEST_URI"]."&modify=1")."'>".lang(224)."</a>");$Kd=array();$yc=array();reset($N);$Xe=1;foreach($M[0]as$z=>$X){if($z!=$Td){$X=$_GET["columns"][key($N)];$n=$o[$N?($X?$X["col"]:current($N)):$z];$F=($n?$c->fieldName($n,$Xe):($X["fun"]?"*":$z));if($F!=""){$Xe++;$Kd[$z]=$F;$d=idf_escape($z);$Ic=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($z);$xb="&desc%5B0%5D=1";echo'<th onmouseover="columnMouse(this);" onmouseout="columnMouse(this, \' hidden\');">','<a href="'.h($Ic.($he[0]==$d||$he[0]==$z||(!$he&&$Wc&&$t[0]==$d)?$xb:'')).'">';echo
764apply_sql_function($X["fun"],$F)."</a>";echo"<span class='column hidden'>","<a href='".h($Ic.$xb)."' title='".lang(46)."' class='text'> ↓</a>";if(!$X["fun"])echo'<a href="#fieldset-search" onclick="selectSearch(\''.h(js_escape($z)).'\'); return false;" title="'.lang(43).'" class="text jsonly"> =</a>';echo"</span>";}$yc[$z]=$X["fun"];next($N);}}$pd=array();if($_GET["modify"]){foreach($M
765as$L){foreach($L
766as$z=>$X)$pd[$z]=max($pd[$z],min(40,strlen(utf8_decode($X))));}}echo($Ba?"<th>".lang(225):"")."</thead>\n";if(is_ajax()){if($_%2==1&&$G%2==1)odd();ob_end_clean();}foreach($c->rowDescriptions($M,$tc)as$E=>$L){$zg=unique_array($M[$E],$x);if(!$zg){$zg=array();foreach($M[$E]as$z=>$X){if(!preg_match('~^(COUNT\\((\\*|(DISTINCT )?`(?:[^`]|``)+`)\\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\\(`(?:[^`]|``)+`\\))$~',$z))$zg[$z]=$X;}}$_g="";foreach($zg
767as$z=>$X){if(($y=="sql"||$y=="pgsql")&&strlen($X)>64){$z=(strpos($z,'(')?$z:idf_escape($z));$z="MD5(".($y=='sql'&&preg_match("~^utf8_~",$o[$z]["collation"])?$z:"CONVERT($z USING ".charset($g).")").")";$X=md5($X);}$_g.="&".($X!==null?urlencode("where[".bracket_escape($z)."]")."=".urlencode($X):"null%5B%5D=".urlencode($z));}echo"<tr".odd().">".(!$t&&$N?"":"<td>".checkbox("check[]",substr($_g,1),in_array(substr($_g,1),(array)$_POST["check"]),"","this.form['all'].checked = false; formUncheck('all-page');").($Wc||information_schema(DB)?"":" <a href='".h(ME."edit=".urlencode($b).$_g)."'>".lang(226)."</a>"));foreach($L
768as$z=>$X){if(isset($Kd[$z])){$n=$o[$z];if($X!=""&&(!isset($Rb[$z])||$Rb[$z]!=""))$Rb[$z]=(is_mail($X)?$Kd[$z]:"");$A="";if(preg_match('~blob|bytea|raw|file~',$n["type"])&&$X!="")$A=ME.'download='.urlencode($b).'&field='.urlencode($z).$_g;if(!$A&&$X!==null){foreach((array)$tc[$z]as$p){if(count($tc[$z])==1||end($p["source"])==$z){$A="";foreach($p["source"]as$u=>$Cf)$A.=where_link($u,$p["target"][$u],$M[$E][$Cf]);$A=($p["db"]!=""?preg_replace('~([?&]db=)[^&]+~','\\1'.urlencode($p["db"]),ME):ME).'select='.urlencode($p["table"]).$A;if(count($p["source"])==1)break;}}}if($z=="COUNT(*)"){$A=ME."select=".urlencode($b);$u=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$zg))$A.=where_link($u++,$W["col"],$W["val"],$W["op"]);}foreach($zg
769as$bd=>$W)$A.=where_link($u++,$bd,$W);}$X=select_value($X,$A,$n,$dg);$v=h("val[$_g][".bracket_escape($z)."]");$Y=$_POST["val"][$_g][bracket_escape($z)];$Mb=!is_array($L[$z])&&is_utf8($X)&&$M[$E][$z]==$L[$z]&&!$yc[$z];$cg=preg_match('~text|lob~',$n["type"]);if(($_GET["modify"]&&$Mb)||$Y!==null){$Bc=h($Y!==null?$Y:$L[$z]);echo"<td>".($cg?"<textarea name='$v' cols='30' rows='".(substr_count($L[$z],"\n")+1)."'>$Bc</textarea>":"<input name='$v' value='$Bc' size='$pd[$z]'>");}else{$ud=strpos($X,"<i>...</i>");echo"<td id='$v' onclick=\"selectClick(this, event, ".($ud?2:($cg?1:0)).($Mb?"":", '".h(lang(227))."'").");\">$X";}}}if($Ba)echo"<td>";$c->backwardKeysPrint($Ba,$M[$E]);echo"</tr>\n";}if(is_ajax())exit;echo"</table>\n";}if(($M||$G)&&!is_ajax()){$bc=true;if($_GET["page"]!="last"){if(!+$_)$wc=count($M);elseif($y!="sql"||!$Wc){$wc=($Wc?false:found_rows($R,$Z));if($wc<max(1e4,2*($G+1)*$_))$wc=reset(slow_query(count_rows($b,$Z,$Wc,$t)));else$bc=false;}}if(+$_&&($wc===false||$wc>$_||$G)){echo"<p class='pages'>";$yd=($wc===false?$G+(count($M)>=$_?2:1):floor(($wc-1)/$_));if($y!="simpledb"){echo'<a href="'.h(remove_from_uri("page"))."\" onclick=\"pageClick(this.href, +prompt('".lang(228)."', '".($G+1)."'), event); return false;\">".lang(228)."</a>:",pagination(0,$G).($G>5?" ...":"");for($u=max(1,$G-4);$u<min($yd,$G+5);$u++)echo
770pagination($u,$G);if($yd>0){echo($G+5<$yd?" ...":""),($bc&&$wc!==false?pagination($yd,$G):" <a href='".h(remove_from_uri("page")."&page=last")."' title='~$yd'>".lang(229)."</a>");}echo(($wc===false?count($M)+1:$wc-$G*$_)>$_?' <a href="'.h(remove_from_uri("page")."&page=".($G+1)).'" onclick="return !selectLoadMore(this, '.(+$_).', \''.lang(230).'...\');" class="loadmore">'.lang(231).'</a>':'');}else{echo
771lang(228).":",pagination(0,$G).($G>1?" ...":""),($G?pagination($G,$G):""),($yd>$G?pagination($G+1,$G).($yd>$G+1?" ...":""):"");}}echo"<p class='count'>\n",($wc!==false?"(".($bc?"":"~ ").lang(132,$wc).") ":"");$Bb=($bc?"":"~ ").$wc;echo
772checkbox("all",1,0,lang(232),"var checked = formChecked(this, /check/); selectCount('selected', this.checked ? '$Bb' : checked); selectCount('selected2', this.checked || !checked ? '$Bb' : checked);")."\n";if($c->selectCommandPrint()){echo'<fieldset',($_GET["modify"]?'':' class="jsonly"'),'><legend>',lang(224),'</legend><div>
773<input type="submit" value="',lang(14),'"',($_GET["modify"]?'':' title="'.lang(220).'"'),'>
774</div></fieldset>
775<fieldset><legend>',lang(110),' <span id="selected"></span></legend><div>
776<input type="submit" name="edit" value="',lang(10),'">
777<input type="submit" name="clone" value="',lang(216),'">
778<input type="submit" name="delete" value="',lang(18),'"',confirm(),'>
779</div></fieldset>
780';}$uc=$c->dumpFormat();foreach((array)$_GET["columns"]as$d){if($d["fun"]){unset($uc['sql']);break;}}if($uc){print_fieldset("export",lang(61)." <span id='selected2'></span>");$qe=$c->dumpOutput();echo($qe?html_select("output",$qe,$ma["output"])." ":""),html_select("format",$uc,$ma["format"])," <input type='submit' name='export' value='".lang(61)."'>\n","</div></fieldset>\n";}echo(!$t&&$N?"":"<script type='text/javascript'>tableCheck();</script>\n");}if($c->selectImportPrint()){print_fieldset("import",lang(60),!$M);echo"<input type='file' name='csv_file'> ",html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$ma["format"],1);echo" <input type='submit' name='import' value='".lang(60)."'>","</div></fieldset>\n";}$c->selectEmailPrint(array_filter($Rb,'strlen'),$e);echo"<p><input type='hidden' name='token' value='$T'></p>\n","</form>\n";}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$Gf=isset($_GET["status"]);page_header($Gf?lang(102):lang(101));$Lg=($Gf?show_status():show_variables());if(!$Lg)echo"<p class='message'>".lang(12)."\n";else{echo"<table cellspacing='0'>\n";foreach($Lg
781as$z=>$X){echo"<tr>","<th><code class='jush-".$y.($Gf?"status":"set")."'>".h($z)."</code>","<td>".nbsp($X);}echo"</table>\n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$Pf=array("Data_length"=>0,"Index_length"=>0,"Data_free"=>0);foreach(table_status()as$F=>$R){json_row("Comment-$F",nbsp($R["Comment"]));if(!is_view($R)){foreach(array("Engine","Collation")as$z)json_row("$z-$F",nbsp($R[$z]));foreach($Pf+array("Auto_increment"=>0,"Rows"=>0)as$z=>$X){if($R[$z]!=""){$X=format_number($R[$z]);json_row("$z-$F",($z=="Rows"&&$X&&$R["Engine"]==($Ef=="pgsql"?"table":"InnoDB")?"~ $X":$X));if(isset($Pf[$z]))$Pf[$z]+=($R["Engine"]!="InnoDB"||$z!="Data_free"?$R[$z]:0);}elseif(array_key_exists($z,$R))json_row("$z-$F");}}}foreach($Pf
782as$z=>$X)json_row("sum-$z",format_number($X));json_row("");}elseif($_GET["script"]=="kill")$g->query("KILL ".number($_POST["kill"]));else{foreach(count_tables($c->databases())as$k=>$X){json_row("tables-$k",$X);json_row("size-$k",db_size($k));}json_row("");}exit;}else{$Xf=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($Xf&&!$m&&!$_POST["search"]){$J=true;$D="";if($y=="sql"&&count($_POST["tables"])>1&&($_POST["drop"]||$_POST["truncate"]||$_POST["copy"]))queries("SET foreign_key_checks = 0");if($_POST["truncate"]){if($_POST["tables"])$J=truncate_tables($_POST["tables"]);$D=lang(233);}elseif($_POST["move"]){$J=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(234);}elseif($_POST["copy"]){$J=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(235);}elseif($_POST["drop"]){if($_POST["views"])$J=drop_views($_POST["views"]);if($J&&$_POST["tables"])$J=drop_tables($_POST["tables"]);$D=lang(236);}elseif($y!="sql"){$J=($y=="sqlite"?queries("VACUUM"):apply_queries("VACUUM".($_POST["optimize"]?"":" ANALYZE"),$_POST["tables"]));$D=lang(237);}elseif(!$_POST["tables"])$D=lang(9);elseif($J=queries(($_POST["optimize"]?"OPTIMIZE":($_POST["check"]?"CHECK":($_POST["repair"]?"REPAIR":"ANALYZE")))." TABLE ".implode(", ",array_map('idf_escape',$_POST["tables"])))){while($L=$J->fetch_assoc())$D.="<b>".h($L["Table"])."</b>: ".h($L["Msg_text"])."<br>";}queries_redirect(substr(ME,0,-1),$D,$J);}page_header(($_GET["ns"]==""?lang(31).": ".h(DB):lang(238).": ".h($_GET["ns"])),$m,true);if($c->homepage()){if($_GET["ns"]!==""){echo"<h3 id='tables-views'>".lang(239)."</h3>\n";$Wf=tables_list();if(!$Wf)echo"<p class='message'>".lang(9)."\n";else{echo"<form action='' method='post'>\n";if(support("table")){echo"<fieldset><legend>".lang(240)." <span id='selected2'></span></legend><div>","<input type='search' name='query' value='".h($_POST["query"])."'> <input type='submit' name='search' value='".lang(43)."'>\n","</div></fieldset>\n";if($_POST["search"]&&$_POST["query"]!="")search_tables();}echo"<table cellspacing='0' class='nowrap checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);'>\n",'<thead><tr class="wrap"><td><input id="check-all" type="checkbox" onclick="formCheck(this, /^(tables|views)\[/);">';$Cb=doc_link(array('sql'=>'show-table-status.html'));echo'<th>'.lang(113),'<td>'.lang(241).doc_link(array('sql'=>'storage-engines.html')),'<td>'.lang(106).doc_link(array('sql'=>'charset-mysql.html')),'<td>'.lang(242).$Cb,'<td>'.lang(243).$Cb,'<td>'.lang(244).$Cb,'<td>'.lang(52).doc_link(array('sql'=>'example-auto-increment.html')),'<td>'.lang(245).$Cb,(support("comment")?'<td>'.lang(91).$Cb:''),"</thead>\n";$S=0;foreach($Wf
783as$F=>$U){$Ng=($U!==null&&!preg_match('~table~i',$U));echo'<tr'.odd().'><td>'.checkbox(($Ng?"views[]":"tables[]"),$F,in_array($F,$Xf,true),"","formUncheck('check-all');"),'<th>'.(support("table")||support("indexes")?'<a href="'.h(ME).'table='.urlencode($F).'" title="'.lang(35).'">'.h($F).'</a>':h($F));if($Ng){echo'<td colspan="6"><a href="'.h(ME)."view=".urlencode($F).'" title="'.lang(36).'">'.(preg_match('~materialized~i',$U)?lang(246):lang(112)).'</a>','<td align="right"><a href="'.h(ME)."select=".urlencode($F).'" title="'.lang(34).'">?</a>';}else{foreach(array("Engine"=>array(),"Collation"=>array(),"Data_length"=>array("create",lang(37)),"Index_length"=>array("indexes",lang(116)),"Data_free"=>array("edit",lang(38)),"Auto_increment"=>array("auto_increment=1&create",lang(37)),"Rows"=>array("select",lang(34)),)as$z=>$A){$v=" id='$z-".h($F)."'";echo($A?"<td align='right'>".(support("table")||$z=="Rows"||(support("indexes")&&$z!="Data_length")?"<a href='".h(ME."$A[0]=").urlencode($F)."'$v title='$A[1]'>?</a>":"<span$v>?</span>"):"<td id='$z-".h($F)."'>&nbsp;");}$S++;}echo(support("comment")?"<td id='Comment-".h($F)."'>&nbsp;":"");}echo"<tr><td>&nbsp;<th>".lang(217,count($Wf)),"<td>".nbsp($y=="sql"?$g->result("SELECT @@storage_engine"):""),"<td>".nbsp(db_collation(DB,collations()));foreach(array("Data_length","Index_length","Data_free")as$z)echo"<td align='right' id='sum-$z'>&nbsp;";echo"</table>\n";if(!information_schema(DB)){$Jg="<input type='submit' value='".lang(247)."'".on_help("'VACUUM'")."> ";$ee="<input type='submit' name='optimize' value='".lang(248)."'".on_help($y=="sql"?"'OPTIMIZE TABLE'":"'VACUUM OPTIMIZE'")."> ";echo"<fieldset><legend>".lang(110)." <span id='selected'></span></legend><div>".($y=="sqlite"?$Jg:($y=="pgsql"?$Jg.$ee:($y=="sql"?"<input type='submit' value='".lang(249)."'".on_help("'ANALYZE TABLE'")."> ".$ee."<input type='submit' name='check' value='".lang(250)."'".on_help("'CHECK TABLE'")."> "."<input type='submit' name='repair' value='".lang(251)."'".on_help("'REPAIR TABLE'")."> ":"")))."<input type='submit' name='truncate' value='".lang(252)."'".confirm().on_help($y=="sqlite"?"'DELETE'":"'TRUNCATE".($y=="pgsql"?"'":" TABLE'"))."> "."<input type='submit' name='drop' value='".lang(111)."'".confirm().on_help("'DROP TABLE'").">\n";$j=(support("scheme")?$c->schemas():$c->databases());if(count($j)!=1&&$y!="sqlite"){$k=(isset($_POST["target"])?$_POST["target"]:(support("scheme")?$_GET["ns"]:DB));echo"<p>".lang(253).": ",($j?html_select("target",$j,$k):'<input name="target" value="'.h($k).'" autocapitalize="off">')," <input type='submit' name='move' value='".lang(254)."'>",(support("copy")?" <input type='submit' name='copy' value='".lang(255)."'>":""),"\n";}echo"<input type='hidden' name='all' value='' onclick=\"selectCount('selected', formChecked(this, /^(tables|views)\[/));".(support("table")?" selectCount('selected2', formChecked(this, /^tables\[/) || $S);":"")."\">\n";echo"<input type='hidden' name='token' value='$T'>\n","</div></fieldset>\n";}echo"</form>\n","<script type='text/javascript'>tableCheck();</script>\n";}echo'<p class="links"><a href="'.h(ME).'create=">'.lang(62)."</a>\n",(support("view")?'<a href="'.h(ME).'view=">'.lang(183)."</a>\n":""),(support("materializedview")?'<a href="'.h(ME).'view=&amp;materialized=1">'.lang(256)."</a>\n":"");if(support("routine")){echo"<h3 id='routines'>".lang(126)."</h3>\n";$of=routines();if($of){echo"<table cellspacing='0'>\n",'<thead><tr><th>'.lang(164).'<td>'.lang(87).'<td>'.lang(200)."<td>&nbsp;</thead>\n";odd('');foreach($of
784as$L){echo'<tr'.odd().'>','<th><a href="'.h(ME).($L["ROUTINE_TYPE"]!="PROCEDURE"?'callf=':'call=').urlencode($L["ROUTINE_NAME"]).'">'.h($L["ROUTINE_NAME"]).'</a>','<td>'.h($L["ROUTINE_TYPE"]),'<td>'.h($L["DTD_IDENTIFIER"]),'<td><a href="'.h(ME).($L["ROUTINE_TYPE"]!="PROCEDURE"?'function=':'procedure=').urlencode($L["ROUTINE_NAME"]).'">'.lang(119)."</a>";}echo"</table>\n";}echo'<p class="links">'.(support("procedure")?'<a href="'.h(ME).'procedure=">'.lang(199).'</a>':'').'<a href="'.h(ME).'function=">'.lang(198)."</a>\n";}if(support("event")){echo"<h3 id='events'>".lang(127)."</h3>\n";$M=get_rows("SHOW EVENTS");if($M){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(164)."<td>".lang(257)."<td>".lang(189)."<td>".lang(190)."<td></thead>\n";foreach($M
785as$L){echo"<tr>","<th>".h($L["Name"]),"<td>".($L["Execute at"]?lang(258)."<td>".$L["Execute at"]:lang(191)." ".$L["Interval value"]." ".$L["Interval field"]."<td>$L[Starts]"),"<td>$L[Ends]",'<td><a href="'.h(ME).'event='.urlencode($L["Name"]).'">'.lang(119).'</a>';}echo"</table>\n";$Zb=$g->result("SELECT @@event_scheduler");if($Zb&&$Zb!="ON")echo"<p class='error'><code class='jush-sqlset'>event_scheduler</code>: ".h($Zb)."\n";}echo'<p class="links"><a href="'.h(ME).'event=">'.lang(188)."</a>\n";}if($Wf)echo"<script type='text/javascript'>ajaxSetHtml('".js_escape(ME)."script=db');</script>\n";}}}page_footer();