<?php
/** Adminer Editor - Compact database editor
* @link https://www.adminer.org/
* @author Jakub Vrana, https://www.vrana.cz/
* @copyright 2009 Jakub Vrana
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
* @version 5.4.4
*/namespace
Adminer;const
VERSION="5.4.4";error_reporting(24575);set_error_handler(function($Wb,$Xb){return!!preg_match('~^Undefined (array key|offset|index)~',$Xb);},E_WARNING|E_NOTICE);$nc=!preg_match('~^(unsafe_raw)?$~',ini_get("filter.default"));if($nc||ini_get("filter.default_flags")){foreach(array('_GET','_POST','_COOKIE','_SERVER')as$X){$Vg=filter_input_array(constant("INPUT$X"),FILTER_UNSAFE_RAW);if($Vg)$$X=$Vg;}}if(function_exists("mb_internal_encoding"))mb_internal_encoding("8bit");function
connection($g=null){return($g?:Db::$instance);}function
adminer(){return
Adminer::$instance;}function
driver(){return
Driver::$instance;}function
connect(){$nb=adminer()->credentials();$G=Driver::connect($nb[0],$nb[1],$nb[2]);return(is_object($G)?$G:null);}function
idf_unescape($s){if(!preg_match('~^[`\'"[]~',$s))return$s;$Gd=substr($s,-1);return
str_replace($Gd.$Gd,$Gd,substr($s,1,-1));}function
q($P){return
connection()->quote($P);}function
escape_string($X){return
substr(q($X),1,-1);}function
idx($ma,$v,$i=null){return($ma&&array_key_exists($v,$ma)?$ma[$v]:$i);}function
number($X){return
preg_replace('~[^0-9]+~','',$X);}function
number_type(){return'((?<!o)int(?!er)|numeric|real|float|double|decimal|money)';}function
remove_slashes(array$ih,$nc=false){$G=array();foreach($ih
as$v=>$X)$G[stripslashes($v)]=(is_array($X)?remove_slashes($X,$nc):($nc?$X:stripslashes($X)));return$G;}function
bracket_escape($s,$va=false){static$Fg=array(':'=>':1',']'=>':2','['=>':3','"'=>':4');return
strtr($s,($va?array_flip($Fg):$Fg));}function
min_version($kh,$Rd="",$g=null){$g=connection($g);$Sf=$g->server_info;if($Rd&&preg_match('~([\d.]+)-MariaDB~',$Sf,$y)){$Sf=$y[1];$kh=$Rd;}return$kh&&version_compare($Sf,$kh)>=0;}function
charset(Db$f){return(min_version("5.5.3",0,$f)?"utf8mb4":"utf8");}function
ini_bool($ld){$X=ini_get($ld);return(preg_match('~^(on|true|yes)$~i',$X)||(int)$X);}function
ini_bytes($ld){$X=ini_get($ld);switch(strtolower(substr($X,-1))){case'g':$X=(int)$X*1024;case'm':$X=(int)$X*1024;case'k':$X=(int)$X*1024;}return$X;}function
sid(){static$G;if($G===null)$G=(SID&&!($_COOKIE&&ini_bool("session.use_cookies")));return$G;}function
set_password($jh,$L,$V,$B){$_SESSION["pwds"][$jh][$L][$V]=($_COOKIE["adminer_key"]&&is_string($B)?array(encrypt_string($B,$_COOKIE["adminer_key"])):$B);}function
get_password(){$G=get_session("pwds");if(is_array($G))$G=($_COOKIE["adminer_key"]?decrypt_string($G[0],$_COOKIE["adminer_key"]):false);return$G;}function
get_val($E,$k=0,$cb=null){$cb=connection($cb);$F=$cb->query($E);if(!is_object($F))return
false;$H=$F->fetch_row();return($H?$H[$k]:false);}function
get_vals($E,$d=0){$G=array();$F=connection()->query($E);if(is_object($F)){while($H=$F->fetch_row())$G[]=$H[$d];}return$G;}function
get_key_vals($E,$g=null,$Vf=true){$g=connection($g);$G=array();$F=$g->query($E);if(is_object($F)){while($H=$F->fetch_row()){if($Vf)$G[$H[0]]=$H[1];else$G[]=$H[0];}}return$G;}function
get_rows($E,$g=null,$j="<p class='error'>"){$cb=connection($g);$G=array();$F=$cb->query($E);if(is_object($F)){while($H=$F->fetch_assoc())$G[]=$H;}elseif(!$F&&!$g&&$j&&(defined('Adminer\PAGE_HEADER')||$j=="-- "))echo$j.error()."\n";return$G;}function
unique_array($H,array$u){foreach($u
as$t){if(preg_match("~PRIMARY|UNIQUE~",$t["type"])&&!$t["partial"]){$G=array();foreach($t["columns"]as$v){if(!isset($H[$v]))continue
2;$G[$v]=$H[$v];}return$G;}}}function
escape_key($v){if(preg_match('(^([\w(]+)('.str_replace("_",".*",preg_quote(idf_escape("_"))).')([ \w)]+)$)',$v,$y))return$y[1].idf_escape(idf_unescape($y[2])).$y[3];return
idf_escape($v);}function
where(array$Z,array$l=array()){$G=array();foreach((array)$Z["where"]as$v=>$X){$v=bracket_escape($v,true);$d=escape_key($v);$k=idx($l,$v,array());$kc=$k["type"];$G[]=$d.(JUSH=="sql"&&$kc=="json"?" = CAST(".q($X)." AS JSON)":(JUSH=="pgsql"&&preg_match('~^jsonb?$~',$k["full_type"])?"::jsonb = ".q($X)."::jsonb":(JUSH=="sql"&&is_numeric($X)&&preg_match('~\.~',$X)?" LIKE ".q($X):(JUSH=="mssql"&&strpos($kc,"datetime")===false?" LIKE ".q(preg_replace('~[_%[]~','[\0]',$X)):" = ".unconvert_field($k,q($X))))));if(JUSH=="sql"&&preg_match('~char|text~',$kc)&&preg_match("~[^ -@]~",$X))$G[]="$d = ".q($X)." COLLATE ".charset(connection())."_bin";}foreach((array)$Z["null"]as$v)$G[]=escape_key($v)." IS NULL";return
implode(" AND ",$G);}function
where_check($X,array$l=array()){parse_str($X,$La);remove_slashes(array(&$La));return
where($La,$l);}function
where_link($q,$d,$Y,$Fe="="){return"&where%5B$q%5D%5Bcol%5D=".urlencode($d)."&where%5B$q%5D%5Bop%5D=".urlencode(($Y!==null?$Fe:"IS NULL"))."&where%5B$q%5D%5Bval%5D=".urlencode($Y);}function
convert_fields(array$e,array$l,array$J=array()){$G="";foreach($e
as$v=>$X){if($J&&!in_array(idf_escape($v),$J))continue;$na=convert_field($l[$v]);if($na)$G
.=", $na AS ".idf_escape($v);}return$G;}function
cookie_path(){return
strtr(preg_replace('~\?.*~','',$_SERVER["REQUEST_URI"]),array(";"=>"%3B",","=>"%2C"));}function
cookie($z,$Y,$Ld=2592000){header("Set-Cookie: $z=".rawurlencode($Y).($Ld?"; expires=".gmdate("D, d M Y H:i:s",time()+$Ld)." GMT":"")."; path=".cookie_path().(HTTPS?"; secure":"")."; HttpOnly; SameSite=lax",false);}function
get_url($bh,$ib){$G=@file_get_contents($bh,false,$ib);if(function_exists('http_get_last_response_headers'))$http_response_header=http_get_last_response_headers();return
array($G,(preg_match('~^HTTP/[\d.]+ (\d+)~',$http_response_header[0],$y)?$y[1]:''),);}function
get_settings($kb){parse_str($_COOKIE[$kb],$Wf);return$Wf;}function
get_setting($v,$kb="adminer_settings",$i=null){return
idx(get_settings($kb),$v,$i);}function
save_settings(array$Wf,$kb="adminer_settings"){$Y=http_build_query($Wf+get_settings($kb));cookie($kb,$Y);$_COOKIE[$kb]=$Y;}function
restart_session(){if(!ini_bool("session.use_cookies")&&(!function_exists('session_status')||session_status()==1))session_start();}function
stop_session($uc=false){$dh=ini_bool("session.use_cookies");if(!$dh||$uc){session_write_close();if($dh&&@ini_set("session.use_cookies",'0')===false)session_start();}}function&get_session($v){return$_SESSION[$v][DRIVER][SERVER][$_GET["username"]];}function
set_session($v,$X){$_SESSION[$v][DRIVER][SERVER][$_GET["username"]]=$X;}function
auth_url($jh,$L,$V,$h=null){$ah=remove_from_uri(implode("|",array_keys(SqlDriver::$drivers))."|username|ext|".($h!==null?"db|":"").($jh=='mssql'||$jh=='pgsql'?"":"ns|").session_name());preg_match('~([^?]*)\??(.*)~',$ah,$y);return"$y[1]?".(sid()?SID."&":"").($jh!="server"||$L!=""?urlencode($jh)."=".urlencode($L)."&":"").($_GET["ext"]?"ext=".urlencode($_GET["ext"])."&":"")."username=".urlencode($V).($h!=""?"&db=".urlencode($h):"").($y[2]?"&$y[2]":"");}function
is_ajax(){return($_SERVER["HTTP_X_REQUESTED_WITH"]=="XMLHttpRequest");}function
redirect($Nd,$ee=null){if($ee!==null){restart_session();$_SESSION["messages"][preg_replace('~^[^?]*~','',($Nd!==null?$Nd:$_SERVER["REQUEST_URI"]))][]=$ee;}if($Nd!==null){if($Nd=="")$Nd=".";header("Location: $Nd");exit;}}function
query_redirect($E,$Nd,$ee,$wf=true,$bc=true,$gc=false,$wg=""){if($bc){$fg=microtime(true);$gc=!connection()->query($E);$wg=format_time($fg);}$cg=($E?adminer()->messageQuery($E,$wg,$gc):"");if($gc){adminer()->error
.=error().$cg.script("messagesPrint();")."<br>";return
false;}if($wf)redirect($Nd,$ee.$cg);return
true;}class
Queries{static$queries=array();static$start=0;}function
queries($E){if(!Queries::$start)Queries::$start=microtime(true);Queries::$queries[]=(driver()->delimiter!=';'?$E:(preg_match('~;$~',$E)?"DELIMITER ;;\n$E;\nDELIMITER ":$E).";");return
connection()->query($E);}function
apply_queries($E,array$S,$Yb='Adminer\table'){foreach($S
as$Q){if(!queries("$E ".$Yb($Q)))return
false;}return
true;}function
queries_redirect($Nd,$ee,$wf){$rf=implode("\n",Queries::$queries);$wg=format_time(Queries::$start);return
query_redirect($rf,$Nd,$ee,$wf,false,!$wf,$wg);}function
format_time($fg){return
sprintf('%.3f s',max(0,microtime(true)-$fg));}function
relative_uri(){return
str_replace(":","%3a",preg_replace('~^[^?]*/([^?]*)~','\1',$_SERVER["REQUEST_URI"]));}function
remove_from_uri($Ue=""){return
substr(preg_replace("~(?<=[?&])($Ue".(SID?"":"|".session_name()).")=[^&]*&~",'',relative_uri()."&"),0,-1);}function
get_file($v,$vb=false,$yb=""){$lc=$_FILES[$v];if(!$lc)return
null;foreach($lc
as$v=>$X)$lc[$v]=(array)$X;$G='';foreach($lc["error"]as$v=>$j){if($j)return$j;$z=$lc["name"][$v];$Cg=$lc["tmp_name"][$v];$hb=file_get_contents($vb&&preg_match('~\.gz$~',$z)?"compress.zlib://$Cg":$Cg);if($vb){$fg=substr($hb,0,3);if(function_exists("iconv")&&preg_match("~^\xFE\xFF|^\xFF\xFE~",$fg))$hb=iconv("utf-16","utf-8",$hb);elseif($fg=="\xEF\xBB\xBF")$hb=substr($hb,3);}$G
.=$hb;if($yb)$G
.=(preg_match("($yb\\s*\$)",$hb)?"":$yb)."\n\n";}return$G;}function
upload_error($j){$Zd=($j==UPLOAD_ERR_INI_SIZE?ini_get("upload_max_filesize"):0);return($j?'Unable to upload a file.'.($Zd?" ".sprintf('Maximum allowed file size is %sB.',$Zd):""):'File does not exist.');}function
repeat_pattern($cf,$Jd){return
str_repeat("$cf{0,65535}",$Jd/65535)."$cf{0,".($Jd%65535)."}";}function
is_utf8($X){return(preg_match('~~u',$X)&&!preg_match('~[\0-\x8\xB\xC\xE-\x1F]~',$X));}function
format_number($X){return
strtr(number_format($X,0,".",','),preg_split('~~u','0123456789',-1,PREG_SPLIT_NO_EMPTY));}function
friendly_url($X){return
preg_replace('~\W~i','-',$X);}function
table_status1($Q,$hc=false){$G=table_status($Q,$hc);return($G?reset($G):array("Name"=>$Q));}function
column_foreign_keys($Q){$G=array();foreach(adminer()->foreignKeys($Q)as$n){foreach($n["source"]as$X)$G[$X][]=$n;}return$G;}function
fields_from_edit(){$G=array();foreach((array)$_POST["field_keys"]as$v=>$X){if($X!=""){$X=bracket_escape($X);$_POST["function"][$X]=$_POST["field_funs"][$v];$_POST["fields"][$X]=$_POST["field_vals"][$v];}}foreach((array)$_POST["fields"]as$v=>$X){$z=bracket_escape($v,true);$G[$z]=array("field"=>$z,"privileges"=>array("insert"=>1,"update"=>1,"where"=>1,"order"=>1),"null"=>1,"auto_increment"=>($v==driver()->primary),);}return$G;}function
dump_headers($Zc,$le=false){$G=adminer()->dumpHeaders($Zc,$le);$Qe=$_POST["output"];if($Qe!="text")header("Content-Disposition: attachment; filename=".adminer()->dumpFilename($Zc).".$G".($Qe!="file"&&preg_match('~^[0-9a-z]+$~',$Qe)?".$Qe":""));session_write_close();if(!ob_get_level())ob_start(null,4096);ob_flush();flush();return$G;}function
dump_csv(array$H){$Og=$_POST["format"]=="tsv";foreach($H
as$v=>$X){if(preg_match('~["\n]|^0[^.]|\.\d*0$|'.($Og?'\t':'[,;]|^$').'~',$X))$H[$v]='"'.str_replace('"','""',$X).'"';}echo
implode(($_POST["format"]=="csv"?",":($Og?"\t":";")),$H)."\r\n";}function
apply_sql_function($p,$d){return($p?($p=="unixepoch"?"DATETIME($d, '$p')":($p=="count distinct"?"COUNT(DISTINCT ":strtoupper("$p("))."$d)"):$d);}function
get_temp_dir(){$G=ini_get("upload_tmp_dir");if(!$G){if(function_exists('sys_get_temp_dir'))$G=sys_get_temp_dir();else{$m=@tempnam("","");if(!$m)return'';$G=dirname($m);unlink($m);}}return$G;}function
file_open_lock($m){if(is_link($m))return;$o=@fopen($m,"c+");if(!$o)return;@chmod($m,0660);if(!flock($o,LOCK_EX)){fclose($o);return;}return$o;}function
file_write_unlock($o,$sb){rewind($o);fwrite($o,$sb);ftruncate($o,strlen($sb));file_unlock($o);}function
file_unlock($o){flock($o,LOCK_UN);fclose($o);}function
first(array$ma){return
reset($ma);}function
password_file($lb){$m=get_temp_dir()."/adminer.key";if(!$lb&&!file_exists($m))return'';$o=file_open_lock($m);if(!$o)return'';$G=stream_get_contents($o);if(!$G){$G=rand_string();file_write_unlock($o,$G);}else
file_unlock($o);return$G;}function
rand_string(){return
md5(uniqid(strval(mt_rand()),true));}function
select_value($X,$x,array$k,$ug){if(is_array($X)){$G="";if(array_filter($X,'is_array')==array_values($X)){$Bd=array();foreach($X
as$W)$Bd+=array_fill_keys(array_keys($W),null);foreach(array_keys($Bd)as$_d)$G
.="<th>".h($_d);foreach($X
as$W){$G
.="<tr>";foreach(array_merge($Bd,$W)as$fh)$G
.="<td>".select_value($fh,$x,$k,$ug);}}else{foreach($X
as$_d=>$W)$G
.="<tr>".($X!=array_values($X)?"<th>".h($_d):"")."<td>".select_value($W,$x,$k,$ug);}return"<table>$G</table>";}if(!$x)$x=adminer()->selectLink($X,$k);if($x===null){if(is_mail($X))$x="mailto:$X";if(is_url($X))$x=$X;}$X=driver()->value($X,$k);$G=adminer()->editVal($X,$k);if($G!==null){if(!is_utf8($G))$G="\0";elseif($ug!=""&&is_shortable($k))$G=shorten_utf8($G,max(0,+$ug));else$G=h($G);}return
adminer()->selectVal($G,$x,$k,$X);}function
is_blob(array$k){return
preg_match('~blob|bytea|raw|file~',$k["type"])&&!in_array($k["type"],idx(driver()->structuredTypes(),'User types',array()));}function
is_mail($Nb){$oa='[-a-z0-9!#$%&\'*+/=?^_`{|}~]';$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';$cf="$oa+(\\.$oa+)*@($Db?\\.)+$Db";return
is_string($Nb)&&preg_match("(^$cf(,\\s*$cf)*\$)i",$Nb);}function
is_url($P){$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';return
preg_match("~^((https?):)?//($Db?\\.)+$Db(:\\d+)?(/.*)?(\\?.*)?(#.*)?\$~i",$P);}function
is_shortable(array$k){return!preg_match('~'.number_type().'|date|time|year~',$k["type"]);}function
host_port($L){return(preg_match('~^(\[(.+)]|([^:]*)):([^:]+)$~',$L,$y)?array($y[2].$y[3],$y[4]):array($L,''));}function
count_rows($Q,array$Z,$ud,array$Fc){$E=" FROM ".table($Q).($Z?" WHERE ".implode(" AND ",$Z):"");return($ud&&(JUSH=="sql"||count($Fc)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$Fc).")$E":"SELECT COUNT(*)".($ud?" FROM (SELECT 1$E GROUP BY ".implode(", ",$Fc).") x":$E));}function
slow_query($E){$h=adminer()->database();$xg=adminer()->queryTimeout();$Yf=driver()->slowQuery($E,$xg);$g=null;if(!$Yf&&support("kill")){$g=connect();if($g&&($h==""||$g->select_db($h))){$Cd=get_val(connection_id(),0,$g);echo
script("const timeout = setTimeout(() => { ajax('".js_escape(ME)."script=kill', function () {}, 'kill=$Cd&token=".get_token()."'); }, 1000 * $xg);");}}ob_flush();flush();$G=@get_key_vals(($Yf?:$E),$g,false);if($g){echo
script("clearTimeout(timeout);");ob_flush();flush();}return$G;}function
get_token(){$uf=rand(1,1e6);return($uf^$_SESSION["token"]).":$uf";}function
verify_token(){list($Dg,$uf)=explode(":",$_POST["token"]);return($uf^$_SESSION["token"])==$Dg&&in_array($_SERVER["HTTP_SEC_FETCH_SITE"],array("","same-origin"));}function
lzw_decompress($Ba){$Bb=256;$Ca=8;$Ta=array();$Bf=0;$Cf=0;for($q=0;$q<strlen($Ba);$q++){$Bf=($Bf<<8)+ord($Ba[$q]);$Cf+=8;if($Cf>=$Ca){$Cf-=$Ca;$Ta[]=$Bf>>$Cf;$Bf&=(1<<$Cf)-1;$Bb++;if($Bb>>$Ca)$Ca++;}}$Ab=range("\0","\xFF");$G="";$rh="";foreach($Ta
as$q=>$Sa){$Mb=$Ab[$Sa];if(!isset($Mb))$Mb=$rh.$rh[0];$G
.=$Mb;if($q)$Ab[]=$rh.$Mb[0];$rh=$Mb;}return$G;}function
script($ag,$Eg="\n"){return"<script".nonce().">$ag</script>$Eg";}function
script_src($bh,$wb=false){return"<script src='".h($bh)."'".nonce().($wb?" defer":"")."></script>\n";}function
nonce(){return' nonce="'.get_nonce().'"';}function
input_hidden($z,$Y=""){return"<input type='hidden' name='".h($z)."' value='".h($Y)."'>\n";}function
input_token(){return
input_hidden("token",get_token());}function
target_blank(){return' target="_blank" rel="noreferrer noopener"';}function
h($P){return
str_replace(array('&','<','"',"'","\0"),array('&amp;','&lt;','&quot;','&#039;','&#0;'),$P);}function
nl_br($P){return
str_replace("\n","<br>",$P);}function
checkbox($z,$Y,$Na,$Dd="",$De="",$Qa="",$Fd=""){$G="<input type='checkbox' name='$z' value='".h($Y)."'".($Na?" checked":"").($Fd?" aria-labelledby='$Fd'":"").">".($De?script("qsl('input').onclick = function () { $De };",""):"");return($Dd!=""||$Qa?"<label".($Qa?" class='$Qa'":"").">$G".h($Dd)."</label>":$G);}function
optionlist($_,$Mf=null,$eh=false){$G="";foreach($_
as$_d=>$W){$Ie=array($_d=>$W);if(is_array($W)){$G
.='<optgroup label="'.h($_d).'">';$Ie=$W;}foreach($Ie
as$v=>$X)$G
.='<option'.($eh||is_string($v)?' value="'.h($v).'"':'').($Mf!==null&&($eh||is_string($v)?(string)$v:$X)===$Mf?' selected':'').'>'.h($X);if(is_array($W))$G
.='</optgroup>';}return$G;}function
html_select($z,array$_,$Y="",$Ce="",$Fd=""){static$Dd=0;$Ed="";if(!$Fd&&substr($_[""],0,1)=="("){$Dd++;$Fd="label-$Dd";$Ed="<option value='' id='$Fd'>".h($_[""]);unset($_[""]);}return"<select name='".h($z)."'".($Fd?" aria-labelledby='$Fd'":"").">".$Ed.optionlist($_,$Y)."</select>".($Ce?script("qsl('select').onchange = function () { $Ce };",""):"");}function
html_radios($z,array$_,$Y="",$K=""){$G="";foreach($_
as$v=>$X)$G
.="<label><input type='radio' name='".h($z)."' value='".h($v)."'".($v==$Y?" checked":"").">".h($X)."</label>$K";return$G;}function
confirm($ee="",$Nf="qsl('input')"){return
script("$Nf.onclick = () => confirm('".($ee?js_escape($ee):'Are you sure?')."');","");}function
print_fieldset($r,$Id,$nh=false){echo"<fieldset><legend>","<a href='#fieldset-$r'>$Id</a>",script("qsl('a').onclick = partial(toggle, 'fieldset-$r');",""),"</legend>","<div id='fieldset-$r'".($nh?"":" class='hidden'").">\n";}function
bold($Da,$Qa=""){return($Da?" class='active $Qa'":($Qa?" class='$Qa'":""));}function
js_escape($P){return
addcslashes($P,"\r\n'\\/");}function
pagination($A,$qb){return" ".($A==$qb?$A+1:'<a href="'.h(remove_from_uri("page").($A?"&page=$A".($_GET["next"]?"&next=".urlencode($_GET["next"]):""):"")).'">'.($A+1)."</a>");}function
hidden_fields(array$pf,array$cd=array(),$kf=''){$G=false;foreach($pf
as$v=>$X){if(!in_array($v,$cd)){if(is_array($X))hidden_fields($X,array(),$v);else{$G=true;echo
input_hidden(($kf?$kf."[$v]":$v),$X);}}}return$G;}function
hidden_fields_get(){echo(sid()?input_hidden(session_name(),session_id()):''),(SERVER!==null?input_hidden(DRIVER,SERVER):""),input_hidden("username",$_GET["username"]);}function
file_input($nd){$Wd="max_file_uploads";$Xd=ini_get($Wd);$Yg="upload_max_filesize";$Zg=ini_get($Yg);return(ini_bool("file_uploads")?$nd.script("qsl('input[type=\"file\"]').onchange = partialArg(fileChange, "."$Xd, '".sprintf('Increase %s.',"$Wd = $Xd")."', ".ini_bytes("upload_max_filesize").", '".sprintf('Increase %s.',"$Yg = $Zg")."')"):'File uploads are disabled.');}function
enum_input($T,$qa,array$k,$Y,$Qb=""){preg_match_all("~'((?:[^']|'')*)'~",$k["length"],$Ud);$kf=($k["type"]=="enum"?"val-":"");$Na=(is_array($Y)?in_array("null",$Y):$Y===null);$G=($k["null"]&&$kf?"<label><input type='$T'$qa value='null'".($Na?" checked":"")."><i>$Qb</i></label>":"");foreach($Ud[1]as$X){$X=stripcslashes(str_replace("''","'",$X));$Na=(is_array($Y)?in_array($kf.$X,$Y):$Y===$X);$G
.=" <label><input type='$T'$qa value='".h($kf.$X)."'".($Na?' checked':'').'>'.h(adminer()->editVal($X,$k)).'</label>';}return$G;}function
input(array$k,$Y,$p,$ua=false){$z=h(bracket_escape($k["field"]));echo"<td class='function'>";if(is_array($Y)&&!$p)$p="json";$yd=($p=="json"||preg_match('~^jsonb?$~',$k["full_type"]));if($yd&&$Y!=''&&(JUSH!="pgsql"||$k["type"]!="json"))$Y=json_encode(is_array($Y)?$Y:json_decode($Y),128|64|256);$Af=(JUSH=="mssql"&&$k["auto_increment"]);if($Af&&!$_POST["save"])$p=null;$Cc=(isset($_GET["select"])||$Af?array("orig"=>'original'):array())+adminer()->editFunctions($k);$Ub=driver()->enumLength($k);if($Ub){$k["type"]="enum";$k["length"]=$Ub;}$qa=" name='fields[$z]".($k["type"]=="enum"||$k["type"]=="set"?"[]":"")."'".($ua?" autofocus":"");echo
driver()->unconvertFunction($k)." ";$Q=$_GET["edit"]?:$_GET["select"];if($k["type"]=="enum")echo
h($Cc[""])."<td>".adminer()->editInput($Q,$k,$qa,$Y);else{$Mc=(in_array($p,$Cc)||isset($Cc[$p]));echo(count($Cc)>1?"<select name='function[$z]'>".optionlist($Cc,$p===null||$Mc?$p:"")."</select>".on_help("event.target.value.replace(/^SQL\$/, '')",1).script("qsl('select').onchange = functionChange;",""):h(reset($Cc))).'<td>';$nd=adminer()->editInput($Q,$k,$qa,$Y);if($nd!="")echo$nd;elseif(preg_match('~bool~',$k["type"]))echo"<input type='hidden'$qa value='0'>"."<input type='checkbox'".(preg_match('~^(1|t|true|y|yes|on)$~i',$Y)?" checked='checked'":"")."$qa value='1'>";elseif($k["type"]=="set")echo
enum_input("checkbox",$qa,$k,(is_string($Y)?explode(",",$Y):$Y));elseif(is_blob($k)&&ini_bool("file_uploads"))echo"<input type='file' name='fields-$z'>";elseif($yd)echo"<textarea$qa cols='50' rows='12' class='jush-js'>".h($Y).'</textarea>';elseif(($sg=preg_match('~text|lob|memo~i',$k["type"]))||preg_match("~\n~",$Y)){if($sg&&JUSH!="sqlite")$qa
.=" cols='50' rows='12'";else{$I=min(12,substr_count($Y,"\n")+1);$qa
.=" cols='30' rows='$I'";}echo"<textarea$qa>".h($Y).'</textarea>';}else{$Pg=driver()->types();$be=(!preg_match('~int~',$k["type"])&&preg_match('~^(\d+)(,(\d+))?$~',$k["length"],$y)?((preg_match("~binary~",$k["type"])?2:1)*$y[1]+($y[3]?1:0)+($y[2]&&!$k["unsigned"]?1:0)):($Pg[$k["type"]]?$Pg[$k["type"]]+($k["unsigned"]?0:1):0));if(JUSH=='sql'&&min_version(5.6)&&preg_match('~time~',$k["type"]))$be+=7;echo"<input".((!$Mc||$p==="")&&preg_match('~(?<!o)int(?!er)~',$k["type"])&&!preg_match('~\[\]~',$k["full_type"])?" type='number'":"")." value='".h($Y)."'".($be?" data-maxlength='$be'":"").(preg_match('~char|binary~',$k["type"])&&$be>20?" size='".($be>99?60:40)."'":"")."$qa>";}echo
adminer()->editHint($Q,$k,$Y);$oc=0;foreach($Cc
as$v=>$X){if($v===""||!$X)break;$oc++;}if($oc&&count($Cc)>1)echo
script("qsl('td').oninput = partial(skipOriginal, $oc);");}}function
process_input(array$k){$s=bracket_escape($k["field"]);$p=idx($_POST["function"],$s);if($p=="orig")return(preg_match('~^CURRENT_TIMESTAMP~i',$k["on_update"])?idf_escape($k["field"]):false);if($p=="NULL")return"NULL";if(is_blob($k)&&ini_bool("file_uploads")){$lc=get_file("fields-$s");if(!is_string($lc))return
false;return
driver()->quoteBinary($lc);}$Y=idx($_POST["fields"],$s);if($Y===null)return
false;if($k["type"]=="enum"||driver()->enumLength($k)){$Y=idx($Y,0);if($Y=="orig"||!$Y)return
false;if($Y=="null")return"NULL";$Y=substr($Y,4);}if($k["auto_increment"]&&$Y=="")return
null;if($k["type"]=="set")$Y=implode(",",(array)$Y);if($p=="json"){$p="";$Y=json_decode($Y,true);if(!is_array($Y))return
false;return$Y;}return
adminer()->processInput($k,$Y,$p);}function
search_tables(){$_GET["where"][0]["val"]=$_POST["query"];$Of="<ul>\n";foreach(table_status('',true)as$Q=>$R){$z=adminer()->tableName($R);if(isset($R["Engine"])&&$z!=""&&(!$_POST["tables"]||in_array($Q,$_POST["tables"]))){$F=connection()->query("SELECT".limit("1 FROM ".table($Q)," WHERE ".implode(" AND ",adminer()->selectSearchProcess(fields($Q),array())),1));if(!$F||$F->fetch_row()){$nf="<a href='".h(ME."select=".urlencode($Q)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]))."'>$z</a>";echo"$Of<li>".($F?$nf:"<p class='error'>$nf: ".error())."\n";$Of="";}}}echo($Of?"<p class='message'>".'No tables.':"</ul>")."\n";}function
on_help($Ya,$Xf=0){return
script("mixin(qsl('select, input'), {onmouseover: function (event) { helpMouseover.call(this, event, $Ya, $Xf) }, onmouseout: helpMouseout});","");}function
edit_form($Q,array$l,$H,$U,$j=''){$og=adminer()->tableName(table_status1($Q,true));page_header(($U?'Edit':'Insert'),$j,array("select"=>array($Q,$og)),$og);adminer()->editRowPrint($Q,$l,$H,$U);if($H===false){echo"<p class='error'>".'No rows.'."\n";return;}echo"<form action='' method='post' enctype='multipart/form-data' id='form'>\n";$Lb=false;if(!$l)echo"<p class='error'>".'You have no privileges to update this table.'."\n";else{echo"<table class='layout'>".script("qsl('table').onkeydown = editingKeydown;");$ua=!$_POST;foreach($l
as$z=>$k){echo"<tr><th>".adminer()->fieldName($k);$i=idx($_GET["set"],bracket_escape($z));if($i===null){$i=$k["default"];if($k["type"]=="bit"&&preg_match("~^b'([01]*)'\$~",$i,$yf))$i=$yf[1];if(JUSH=="sql"&&preg_match('~binary~',$k["type"]))$i=bin2hex($i);}$Y=($H!==null?($H[$z]!=""&&JUSH=="sql"&&preg_match("~enum|set~",$k["type"])&&is_array($H[$z])?implode(",",$H[$z]):(is_bool($H[$z])?+$H[$z]:$H[$z])):(!$U&&$k["auto_increment"]?"":(isset($_GET["select"])?false:$i)));if(!$_POST["save"]&&is_string($Y))$Y=adminer()->editVal($Y,$k);if(($U&&!isset($k["privileges"]["update"]))||$k["generated"])echo"<td class='function'><td>".select_value($Y,'',$k,null);else{$Lb=true;$p=($_POST["save"]?idx($_POST["function"],$z,""):($U&&preg_match('~^CURRENT_TIMESTAMP~i',$k["on_update"])?"now":($Y===false?null:($Y!==null?'':'NULL'))));if(!$_POST&&!$U&&$Y==$k["default"]&&preg_match('~^[\w.]+\(~',$Y))$p="SQL";if(preg_match("~time~",$k["type"])&&preg_match('~^CURRENT_TIMESTAMP~i',$Y)){$Y="";$p="now";}if($k["type"]=="uuid"&&$Y=="uuid()"){$Y="";$p="uuid";}if($ua!==false)$ua=($k["auto_increment"]||$p=="now"||$p=="uuid"?null:true);input($k,$Y,$p,$ua);if($ua)$ua=false;}echo"\n";}if(!support("table")&&!fields($Q))echo"<tr>"."<th><input name='field_keys[]'>".script("qsl('input').oninput = fieldChange;")."<td class='function'>".html_select("field_funs[]",adminer()->editFunctions(array("null"=>isset($_GET["select"]))))."<td><input name='field_vals[]'>"."\n";echo"</table>\n";}echo"<p>\n";if($Lb){echo"<input type='submit' value='".'Save'."'>\n";if(!isset($_GET["select"]))echo"<input type='submit' name='insert' value='".($U?'Save and continue edit':'Save and insert next')."' title='Ctrl+Shift+Enter'>\n",($U?script("qsl('input').onclick = function () { return !ajaxForm(this.form, '".'Saving'."…', this); };"):"");}echo($U?"<input type='submit' name='delete' value='".'Delete'."'>".confirm()."\n":"");if(isset($_GET["select"]))hidden_fields(array("check"=>(array)$_POST["check"],"clone"=>$_POST["clone"],"all"=>$_POST["all"]));echo
input_hidden("referer",(isset($_POST["referer"])?$_POST["referer"]:$_SERVER["HTTP_REFERER"])),input_hidden("save",1),input_token(),"</form>\n";}function
shorten_utf8($P,$Jd=80,$jg=""){if(!preg_match("(^(".repeat_pattern("[\t\r\n -\x{10FFFF}]",$Jd).")($)?)u",$P,$y))preg_match("(^(".repeat_pattern("[\t\r\n -~]",$Jd).")($)?)",$P,$y);return
h($y[1]).$jg.(isset($y[2])?"":"<i>…</i>");}function
icon($Yc,$z,$Xc,$zg){return"<button type='submit' name='$z' title='".h($zg)."' class='icon icon-$Yc'><span>$Xc</span></button>";}if(isset($_GET["file"])){if(substr(VERSION,-4)!='-dev'){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");header("Cache-Control: immutable");}@ini_set("zlib.output_compression",'1');if($_GET["file"]=="default.css"){header("Content-Type: text/css; charset=utf-8");echo
lzw_decompress("h:Mhgб\"PimcQCa	2ód<fa:;NBqR;1Lf9u7&)l;3J/CQXr2Mai0)e:LuÝh-923li7mZw4њ<-̴!U,Févt2S,a҇FVXaNq)-ǜh:n59Y;j-_9krٓ;.tTqo0{y\rHnGSZh;i^uxWΒC@k=b/A0+(l\\x:\rb8\00!\0F\nB͎(3\r\\Ȅa'I|(i\n\r4Og@4C@@!QB	°c¯q,\r1Eh&2PZiGH9G\"v4rDR\npJ-A|/.cDu:,=R]U5mVkLLQ@-\\@9%SrMPDIa\r(YY\\@Xp:plLC O,\r2]7?m06pTaҥC;_˗yȴd>bnnܣ3X8\r[ˀ-)i>V[Yy&L3#X|	X\\ù`C#H22.#Z`<sÒ\0uh־M_\niZeO/CӒ_`31>=k3R/;/d\0ڵm7/AXq.sL :\$Fw8߾~Hj\"Գ7gSFLίQ_O'W]c=51X~7;i\r*\nJS1ZctAV86fdy;Y]zIpc3Y]}@\$.+1'>ZcpdGL#k8PzYAuv]s9_Aq:\nKhB;XbAHq,CI`jS[ˌ1Vr;pB)#鐉;4H/*<3L;lf\ns\$K`}Ք7jx`d%j]4YHbYJ`GG.KfI)2MfָXRC̱V,~g\0g6:[j1H:AlIqu3\"q|8<9s'Q]J|\0`pjfObq\$1J>RH(ǔq\n#r@e(yVJ0Q҈6P[C:G伞4^PZ\\(\n)~9R%Sj{70_s	z|8H	\"@#9DVL\$H5WJ@zaJ ^	)2\nQv]ՇQp.˵&h2dM1#[[kf,ոΆWq'fLkgn6G;eהECVY{\0D5Rx\"h\"ݟ7W,ňuc31Cxp<If]ѱ^{/H&sρi9\$֒b0َIK\0]IDG}EDVNýmQ31KT3zq|#!\"	҃k/phy-.! 0dmK~au0>\$:\$VMf٨k6:3L@d1zlg֩iX97<׭#a}s\0\\mZXQ'n.9KC9?lXq깗\$M2FqЎKB:bo#KXnMzȤ\r=fm%fi.q;-7x(@#9F)/M-6.V^*g\n!\$(7GxwDWba{1-ԐGw\r9њ (:'%?0Ά)tjHV8}f\$f^wlKl=1ZZEigֺ1Xثbe&,2rk>޲O{-A]mMDȁ>G;ЗgQo:0.7lLשl|:nD탉-K*NY3x.dt>Ў)\$\$9BeeRGwir[62Ǳ9Xk0̱5^PO>C `XOk7\0Klx;48L\$09*9 hNF>\0rPQo<	\\Fd'L:b.4,29@Hnb- #2`Z.L\rPP\"^.Fh\0\r\0\n`	@ 	no	@@\n0 	\0j@q@	1	 \r\0` V`B\n`\n@fh\0` \n@	F`p1\r\0\\&B|`@NI#ApH\rp	`P	11% -\r6\n2	H*@	`\n  	l`z,\rɠ\r\"lh\0(d226\0]#L^\\%\0\\}\$HC\n<}E%IB>͈I\$r6dfhr</FbxYE'2boj\"m(@r*خ~d\$2U2a#`\\A貶r+Ruh\\'+؉\"G!.nMrW*#+%.h\$cCDƊ-#bO`Pv^W@tS-0-|ܶ)g'hF<\rj*\$4'\rH[ɪ1-Fh:,/ɾJ^ODٍj'\rT-&[DĪ(5E B\"`es\n9\r`h\rV%!MZlP^:o>֯XC):meC/\n8I2\rp2&)oC5m0iuAB3fDS61҈C2/Ҩ\ru14GGؔb쒑=KA3>4*\0TI%?r@!3S8,+?.1%6=\0s쭖XnRB@si(O(lKKu%+P65!.O0{Sj.`ȡiz%");}elseif($_GET["file"]=="dark.css"){header("Content-Type: text/css; charset=utf-8");echo
lzw_decompress("h:Mhgh0LЁd91S!	F!\"-6NbdGg:;Nr)c7\r(Hb81s9k\rc)m8OVAc1c34Of*-P1r416d2ցo#3Bf#	g9Φ،fc\rIb6EC&,bum7aVs#m!hrv\\3\rL:SAdk5naF3e6fSyr!L-K,3L@J˲*J쵣	bc99@H8\\6>`Ŏ;A<T'p&qqE4\rlh<5#pR #I%fBIܲ>ʫ29<Cj27j8jc(n?(a\0@5*3:δ60-AlLP4@ɰ\$H4n311t0͙9WO!rH9Q96F<7\r-xC\n @:\$iضm4Kid{\n6\rxhˋ#^'4V@a<#h0S-c9+pa2cyhBO\$9wiXɔVY9*rHtm	@b|@/l\$z+%p2l.7;&{mXC<l96x9m7R0\\4P)AoxqO#f[;6~P\raTGT0uޟ\n3\\ \\ʎJudCGPZ>d8ҨC?VdLL.(ti>,L");}elseif($_GET["file"]=="functions.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress("':̢i11	4Q6a&:OAIe:NFD|!Cym2\"r<̱/C#:DbqSeJ˦Cܺ\n\nǱS\rZH\$RAܞS+XKvtdg:6EvXŞjmҩej2MB&ʮLC3Q0L-x\nDyNaPn:s͐(cL/(5{Qy4g-i4ڃf(bUko7&ä*ACb`.\r\nCh<\r)`إ`7CʒZX<Q1X@0dp9EQfF\r!(h)\np'#ČH(i*r&<#7K~# A:N6l,\rJP3!@2>CrhN](a0M326UE2'!<#3R<XCH7#n+a\$!2P0.wdr:YE!]<j@\\pl_\rZғTͩZs3\"~9j>WeQ:X/\"\$8X硉@4H:tL܌j~#8_Ax\$x{LEJ4'00<8>c(zX^5Dt;#K_v꩕u1\n`jn'\"Ir7U*!Ynjk@Ì+5)̄3CZB2HV`qæk]<{\r9|gr\\襜:B2781͍d=HLU}^NߔC*/|􊾓V`)8z:Rb8WA:\$2\r/BE~8iYtzX6ǰICQ7 3)6\00N\r갦 \r0ѯ 9~'%Dw'cdi'ta&r11?\\CmSɞ\$ж o&R,!.AHG\"tPv-&	30.	裃!iĕkJ7	:sO\0^'7^(`B(0nL9(\0\n[Uec)Fʛq2R5\r܀e}ܱh.iZ:AYED2@s1d<)H`تI1I\rZGRϔ/\$Oc\"*p'7`]@\\4BXzgABTQ3wc-sr_:բS@2 #Ė\nuP!Te6TaM)\0v(sVAZS<av(A%#&: `C)\r]MIC'/	PHXb\r\nYMzJFJP?JdBllDCS+-r1<w]v!)IKP4EslkV-kj,c,fRdC!&n0RJ2[3x3TB-Glls`hsV)W4SvC:nd-x` ®\$AP-kr^sASV?3E2X,KtSAq7\n^+%skG<aw	DdYڇQgbn\0A{濡9ùl.Hg(0TJ\$h-Bzm\nWY`!lc\0ϪÄՆMLxyk*Z3EU L-~?ii4[ iDZP)hZ\n5\"1tŦd/BrJcN[FժxK߭nDQS?Q\rL'!\nͅII%2萵Q;ǘ8mX-zIFF]t.H	r/[!#\r{̫pH\n4&3r*L臜{Ae\0L(*{kؘDJ_C:U2\0I0,\n;|xef0`1N`6>C){)3(t8dèO_DT^`H:c\0f<Y`f\\&x \nd+5U݇Oz{n-iFYb7vo%)Xh '7UIVwSR}dK_4 Wjnτ\0l\r\0.p@\0@Ȅ[PZIXكcbqtg2 \\i9< Z@i,`^N'uGBr'&\$F(/җ*uɄYiO	`ʑn:paPhnrM	\0кML,\$Nw)\0*l7GrlrQ	Os\"46 bXbӄoXbbeg\r `BВRhJ\"g\rTcj>I-zGolvu\rz\r	D9BK\r^\rY@,BЖL`^#\rwHpDJMXQ&lg&I\01 	P5&n0?gTs٠O!)`v X ͐QЂ\r y!'v.\r	fK! {#*/ඡ\0H\0r(Ȉ`SpcmI)8.s#G\"`Ƈx'ŔE)Qo)&\\VRZ@2bʒf'dZ&,U\r\"*4! \rD'G\\VHi1Rpc\$L2\nbToB8Fk\\\rB\r\0-l\n1354\04SHM4Qr2O%6p5/O5:pL5)Pľ%E361\r4I:S\"LeGs\\Q627=C	,	&D)<;\\~2ˮr076.'?52K6sa6R23SVLM@Fr9pț3j@NSӂk:@)B\0N`!e\n'PX\\YqLV&r+c.]锏h2]4 z`q8c6q4 ӓPg>#.)7Ne\$nB`\" 4L~΂\nu.OBN@R&N(uN@:h\n]6*hPXΠ@,P3S6U:鮟H5L-6T6SC0FsRRB~r:TnA/OP2-H:1e]P-'''8;8WUbYe!\r ^)Ȗp]	j.`</\"Uw3ʸb brA`fF_u^McTB	_Se65`\ra)ec]cAa_oa2>B\$@Q<OHJtx\"gZ\$nW@	D#S\0002#VΕB;N1NKPnv1wEl*YnB4IqZ`z\0\rR'\"픚iO	ps|)=fs1s72i-Gf `P%H\nhI\re\0X'\"\$z͉Yex@|~k yse`\$ZRz \\Wx[v`{\"Rwn'to#r*\0D3~^@xB~Ħ@}BUCx| YPXN`	\n\0Rmz+X:qy*X(No^8[fG\$LZ[vr#Xυe׍\$':\0[\nr\0Z}	b\$S|BcrQH)xРNDeMb ewzXswxAd苂LYC`{}q}Ό  4j4bFO7MN.'WS/uL	|\")IՁU%VUՌ^q'K4=c\"PvV7HI!\n`	㛓firH	tXn\$wFHĂP@rBa@W9`~bu>wbw3M~zw\$J<@\r&IX<_,[,eDuWL%\06\r?bLeKe*l;cXkY\0BL@\n@o\0h%lx=RB's2tpDϧ\"Z=\rBcQ2vBr4lv ^g(% \$\rvС\nP\\~U.R%ٯvГzx_e{3!e,{ewco|0EW!8wѶuitNef:\r(DV@\n{}cAâ׃|*!X¶\r\$LL/ELlU-/WƬc\$l\nUTPNŵt羣SY<,44.s	kv۠R+bdFN!rgs\$?BB2?P\$dtU`U\rāT\"搖EJ@oUx:<3SSIxGzD(7~M|Q~b5+Irzv@wf6#E\"-	(җhS*7\$QlvB%+]2Ohˢrod\rw'!C`biH8ώ(\0 @DdB>,4qHү츠Hbd\0`]e\"b w6;I?uMNj\rbS_!޷wdK\\O}{=ttZ\0DxaN 3Re#w^NPzU=!zLy͸@˸c]l٬[p՞XMspq5*W4Xs^\"@r~|>B5g2	N\$gFu\rzTjB2Anyc^vҸv\nOv:v}\0P[A%3@@Ǌ=cXGy)~u>zĜQXW\"wEwt;mJnfa@Oo;O hVVc^\06,#2s*y2{tXo;lث\n\nZc?`(%4\$&GrT!AݡCmj0ԀC\0D[H/{!Ak!N:5q\0MKC.B7/ @`Ip;PGr`+D<C]ǆ+<,%Hl`09-GsV]J\nu^Vi5/	6\r%T肊:\n!@ nS\"&)mt1f%RVXJtX%@=bU\$`z@X2dD^Pqő4p@\\,B~6??2OP6\0U0@	XKpf6 RR,e8񶁄Z\nk.BfB:7]\"I6JU\$Mpa:4_gpǐ/0@K;pÅTI<AD =!C\nj	忉S<e-a?XRA]@r4ӢӁOD%9n9x'O4-ZtpFK&1f^biB\rPKƢ)%'*Age\r.o@,`BQ7D\$o	*|Z)ҍE9`BC\n0/qبv#?ʽSt3oGmSlFo)?Y#F9SdfGסESyw#>w9籷9xRn8y.).P,+{dtH:!&;	b߈8k-<G4)%ZP֑p~[@.D텸~	(cGˢŨ8Xђ'ڎH=,\noɤBI/!Rt\nvU%DZlRhG*Lp:.V6\"8 Blr\0*<\"3,Ď|R-TGhfLXBtt\0");}elseif($_GET["file"]=="jush.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress('');}elseif($_GET["file"]=="logo.png"){header("Content-Type: image/png");echo"PNG\r\n\n\0\0\0\rIHDR\0\0\09\0\0\09\0\0\0~6\0\0\0000PLTE\0\0\0+NvYtssuIJ/.C\0\0\0tRNS\0@f\0\0\0	pHYs\0\0\0\0\0\0\0IDAT8ՔN@El϶p6G.\$=>	w5r}z7>P#\$Kj7ݶ?4mt&~3!00^Af0\",*4oEX(*Y	6	PcOW܊mr0~/L\rXj#mjC]Gm\0}ߑuA9X\n8VY+D#iqnKQ8J1Q6Y0`PbQ\\h~>:pSɀGEQ=I{*327\neLB~/R(\$) HQni6J	<-.wɪjVmm?SHvƩ\0^q)]U92,;Ǎ'p!X˃LD.tæ/wR	wdr2Ƥ4[=E5S+c\0\0\0\0IENDB`";}exit;}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]";if($_SERVER["HTTP_X_FORWARDED_PREFIX"])$_SERVER["REQUEST_URI"]=$_SERVER["HTTP_X_FORWARDED_PREFIX"].$_SERVER["REQUEST_URI"];define('Adminer\HTTPS',($_SERVER["HTTPS"]&&strcasecmp($_SERVER["HTTPS"],"off"))||ini_bool("session.cookie_secure"));@ini_set("session.use_trans_sid",'0');if(!defined("SID")){session_cache_limiter("");session_name("adminer_sid");session_set_cookie_params(0,cookie_path(),"",HTTPS,true);session_start();}if(function_exists("get_magic_quotes_gpc")&&get_magic_quotes_gpc()){$_GET=remove_slashes($_GET,$nc);$_POST=remove_slashes($_POST,$nc);$_COOKIE=remove_slashes($_COOKIE,$nc);}if(function_exists("get_magic_quotes_runtime")&&get_magic_quotes_runtime())set_magic_quotes_runtime(false);@set_time_limit(0);@ini_set("precision",'16');function
lang($s,$we=null){$la=func_get_args();$la[0]=$s;return
call_user_func_array('Adminer\lang_format',$la);}function
lang_format($Gg,$we=null){if(is_array($Gg)){$hf=($we==1?0:1);$Gg=$Gg[$hf];}$Gg=str_replace("'",'’',$Gg);$la=func_get_args();array_shift($la);$zc=str_replace("%d","%s",$Gg);if($zc!=$Gg)$la[0]=format_number($we);return
vsprintf($zc,$la);}define('Adminer\LANG','en');abstract
class
SqlDb{static$instance;var$extension;var$flavor='';var$server_info;var$affected_rows=0;var$info='';var$errno=0;var$error='';protected$multi;abstract
function
attach($L,$V,$B);abstract
function
quote($P);abstract
function
select_db($tb);abstract
function
query($E,$Qg=false);function
multi_query($E){return$this->multi=$this->query($E);}function
store_result(){return$this->multi;}function
next_result(){return
false;}}if(extension_loaded('pdo')){abstract
class
PdoDb
extends
SqlDb{protected$pdo;function
dsn($Ib,$V,$B,array$_=array()){$_[\PDO::ATTR_ERRMODE]=\PDO::ERRMODE_SILENT;$_[\PDO::ATTR_STATEMENT_CLASS]=array('Adminer\PdoResult');try{$this->pdo=new
\PDO($Ib,$V,$B,$_);}catch(\Exception$Zb){return$Zb->getMessage();}$this->server_info=@$this->pdo->getAttribute(\PDO::ATTR_SERVER_VERSION);return'';}function
quote($P){return$this->pdo->quote($P);}function
query($E,$Qg=false){$F=$this->pdo->query($E);$this->error="";if(!$F){list(,$this->errno,$this->error)=$this->pdo->errorInfo();if(!$this->error)$this->error='Unknown error.';return
false;}$this->store_result($F);return$F;}function
store_result($F=null){if(!$F){$F=$this->multi;if(!$F)return
false;}if($F->columnCount()){$F->num_rows=$F->rowCount();return$F;}$this->affected_rows=$F->rowCount();return
true;}function
next_result(){$F=$this->multi;if(!is_object($F))return
false;$F->_offset=0;return@$F->nextRowset();}}class
PdoResult
extends
\PDOStatement{var$_offset=0,$num_rows;function
fetch_assoc(){return$this->fetch_array(\PDO::FETCH_ASSOC);}function
fetch_row(){return$this->fetch_array(\PDO::FETCH_NUM);}private
function
fetch_array($ie){$G=$this->fetch($ie);return($G?array_map(array($this,'unresource'),$G):$G);}private
function
unresource($X){return(is_resource($X)?stream_get_contents($X):$X);}function
fetch_field(){$H=(object)$this->getColumnMeta($this->_offset++);$T=$H->pdo_type;$H->type=($T==\PDO::PARAM_INT?0:15);$H->charsetnr=($T==\PDO::PARAM_LOB||(isset($H->flags)&&in_array("blob",(array)$H->flags))?63:0);return$H;}function
seek($ye){for($q=0;$q<$ye;$q++)$this->fetch();}}}function
add_driver($r,$z){SqlDriver::$drivers[$r]=$z;}function
get_driver($r){return
SqlDriver::$drivers[$r];}abstract
class
SqlDriver{static$instance;static$drivers=array();static$extensions=array();static$jush;protected$conn;protected$types=array();var$delimiter=";";var$insertFunctions=array();var$editFunctions=array();var$unsigned=array();var$operators=array();var$functions=array();var$grouping=array();var$onActions="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";var$partitionBy=array();var$inout="IN|OUT|INOUT";var$enumLength="'(?:''|[^'\\\\]|\\\\.)*'";var$generated=array();static
function
connect($L,$V,$B){$f=new
Db;return($f->attach($L,$V,$B)?:$f);}function
__construct(Db$f){$this->conn=$f;}function
types(){return
call_user_func_array('array_merge',array_values($this->types));}function
structuredTypes(){return
array_map('array_keys',$this->types);}function
enumLength(array$k){}function
unconvertFunction(array$k){}function
select($Q,array$J,array$Z,array$Fc,array$Je=array(),$w=1,$A=0,$nf=false){$ud=(count($Fc)<count($J));$E=adminer()->selectQueryBuild($J,$Z,$Fc,$Je,$w,$A);if(!$E)$E="SELECT".limit(($_GET["page"]!="last"&&$w&&$Fc&&$ud&&JUSH=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$J)."\nFROM ".table($Q),($Z?"\nWHERE ".implode(" AND ",$Z):"").($Fc&&$ud?"\nGROUP BY ".implode(", ",$Fc):"").($Je?"\nORDER BY ".implode(", ",$Je):""),$w,($A?$w*$A:0),"\n");$fg=microtime(true);$G=$this->conn->query($E);if($nf)echo
adminer()->selectQuery($E,$fg,!$G);return$G;}function
delete($Q,$sf,$w=0){$E="FROM ".table($Q);return
queries("DELETE".($w?limit1($Q,$E,$sf):" $E$sf"));}function
update($Q,array$M,$sf,$w=0,$K="\n"){$ih=array();foreach($M
as$v=>$X)$ih[]="$v = $X";$E=table($Q)." SET$K".implode(",$K",$ih);return
queries("UPDATE".($w?limit1($Q,$E,$sf,$K):" $E$sf"));}function
insert($Q,array$M){return
queries("INSERT INTO ".table($Q).($M?" (".implode(", ",array_keys($M)).")\nVALUES (".implode(", ",$M).")":" DEFAULT VALUES").$this->insertReturning($Q));}function
insertReturning($Q){return"";}function
insertUpdate($Q,array$I,array$D){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}function
slowQuery($E,$xg){}function
convertSearch($s,array$X,array$k){return$s;}function
value($X,array$k){return(method_exists($this->conn,'value')?$this->conn->value($X,$k):$X);}function
quoteBinary($Gf){return
q($Gf);}function
warnings(){}function
tableHelp($z,$xd=false){}function
inheritsFrom($Q){return
array();}function
inheritedTables($Q){return
array();}function
partitionsInfo($Q){return
array();}function
hasCStyleEscapes(){return
false;}function
engines(){return
array();}function
supportsIndex(array$R){return!is_view($R);}function
indexAlgorithms(array$mg){return
array();}function
checkConstraints($Q){return
get_key_vals("SELECT c.CONSTRAINT_NAME, CHECK_CLAUSE
FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS c
JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON c.CONSTRAINT_SCHEMA = t.CONSTRAINT_SCHEMA AND c.CONSTRAINT_NAME = t.CONSTRAINT_NAME".($this->conn->flavor=='maria'?" AND c.TABLE_NAME = ".q($Q):"")."
WHERE c.CONSTRAINT_SCHEMA = ".q($_GET["ns"]!=""?$_GET["ns"]:DB)."
AND t.TABLE_NAME = ".q($Q).(JUSH=="pgsql"?"
AND CHECK_CLAUSE NOT LIKE '% IS NOT NULL'":""),$this->conn);}function
allFields(){$G=array();if(DB!=""){foreach(get_rows("SELECT TABLE_NAME AS tab, COLUMN_NAME AS field, IS_NULLABLE AS nullable, DATA_TYPE AS type, CHARACTER_MAXIMUM_LENGTH AS length".(JUSH=='sql'?", COLUMN_KEY = 'PRI' AS `primary`":"")."
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = ".q($_GET["ns"]!=""?$_GET["ns"]:DB)."
ORDER BY TABLE_NAME, ORDINAL_POSITION",$this->conn)as$H){$H["null"]=($H["nullable"]=="YES");$G[$H["tab"]][]=$H;}}return$G;}}add_driver("sqlite","SQLite");if(isset($_GET["sqlite"])){define('Adminer\DRIVER',"sqlite");if(class_exists("SQLite3")&&$_GET["ext"]!="pdo"){abstract
class
SqliteDb
extends
SqlDb{var$extension="SQLite3";private$link;function
attach($m,$V,$B){$this->link=new
\SQLite3($m);$kh=$this->link->version();$this->server_info=$kh["versionString"];return'';}function
query($E,$Qg=false){$F=@$this->link->query($E);$this->error="";if(!$F){$this->errno=$this->link->lastErrorCode();$this->error=$this->link->lastErrorMsg();return
false;}elseif($F->numColumns())return
new
Result($F);$this->affected_rows=$this->link->changes();return
true;}function
quote($P){return(is_utf8($P)?"'".$this->link->escapeString($P)."'":"x'".first(unpack('H*',$P))."'");}}class
Result{var$num_rows;private$result,$offset=0;function
__construct($F){$this->result=$F;}function
fetch_assoc(){return$this->result->fetchArray(SQLITE3_ASSOC);}function
fetch_row(){return$this->result->fetchArray(SQLITE3_NUM);}function
fetch_field(){$d=$this->offset++;$T=$this->result->columnType($d);return(object)array("name"=>$this->result->columnName($d),"type"=>($T==SQLITE3_TEXT?15:0),"charsetnr"=>($T==SQLITE3_BLOB?63:0),);}function
__destruct(){$this->result->finalize();}}}elseif(extension_loaded("pdo_sqlite")){abstract
class
SqliteDb
extends
PdoDb{var$extension="PDO_SQLite";function
attach($m,$V,$B){return$this->dsn(DRIVER.":$m","","");}}}if(class_exists('Adminer\SqliteDb')){class
Db
extends
SqliteDb{function
attach($m,$V,$B){parent::attach($m,$V,$B);$this->query("PRAGMA foreign_keys = 1");$this->query("PRAGMA busy_timeout = 500");return'';}function
select_db($m){if(is_readable($m)&&$this->query("ATTACH ".$this->quote(preg_match("~(^[/\\\\]|:)~",$m)?$m:dirname($_SERVER["SCRIPT_FILENAME"])."/$m")." AS a"))return!self::attach($m,'','');return
false;}}}class
Driver
extends
SqlDriver{static$extensions=array("SQLite3","PDO_SQLite");static$jush="sqlite";protected$types=array(array("integer"=>0,"real"=>0,"numeric"=>0,"text"=>0,"blob"=>0));var$insertFunctions=array();var$editFunctions=array("integer|real|numeric"=>"+/-","text"=>"||",);var$operators=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","IN","IS NULL","NOT LIKE","NOT IN","IS NOT NULL","SQL");var$functions=array("hex","length","lower","round","unixepoch","upper");var$grouping=array("avg","count","count distinct","group_concat","max","min","sum");static
function
connect($L,$V,$B){if($B!="")return'Database does not support password.';return
parent::connect(":memory:","","");}function
__construct(Db$f){parent::__construct($f);if(min_version(3.31,0,$f))$this->generated=array("STORED","VIRTUAL");}function
structuredTypes(){return
array_keys($this->types[0]);}function
insertUpdate($Q,array$I,array$D){$ih=array();foreach($I
as$M)$ih[]="(".implode(", ",$M).")";return
queries("REPLACE INTO ".table($Q)." (".implode(", ",array_keys(reset($I))).") VALUES\n".implode(",\n",$ih));}function
tableHelp($z,$xd=false){if($z=="sqlite_sequence")return"fileformat2.html#seqtab";if($z=="sqlite_master")return"fileformat2.html#$z";}function
checkConstraints($Q){preg_match_all('~ CHECK *(\( *(((?>[^()]*[^() ])|(?1))*) *\))~',get_val("SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ".q($Q),0,$this->conn),$Ud);return
array_combine($Ud[2],$Ud[2]);}function
allFields(){$G=array();foreach(tables_list()as$Q=>$T){foreach(fields($Q)as$k)$G[$Q][]=$k;}return$G;}}function
idf_escape($s){return'"'.str_replace('"','""',$s).'"';}function
table($s){return
idf_escape($s);}function
get_databases($tc){return
array();}function
limit($E,$Z,$w,$ye=0,$K=" "){return" $E$Z".($w?$K."LIMIT $w".($ye?" OFFSET $ye":""):"");}function
limit1($Q,$E,$Z,$K="\n"){return(preg_match('~^INTO~',$E)||get_val("SELECT sqlite_compileoption_used('ENABLE_UPDATE_DELETE_LIMIT')")?limit($E,$Z,1,0,$K):" $E WHERE rowid = (SELECT rowid FROM ".table($Q).$Z.$K."LIMIT 1)");}function
db_collation($h,$Va){return
get_val("PRAGMA encoding");}function
logged_user(){return
get_current_user();}function
tables_list(){return
get_key_vals("SELECT name, type FROM sqlite_master WHERE type IN ('table', 'view') ORDER BY (name = 'sqlite_sequence'), name");}function
count_tables($ub){return
array();}function
table_status($z=""){$G=array();foreach(get_rows("SELECT name AS Name, type AS Engine, 'rowid' AS Oid, '' AS Auto_increment FROM sqlite_master WHERE type IN ('table', 'view') ".($z!=""?"AND name = ".q($z):"ORDER BY name"))as$H){$H["Rows"]=get_val("SELECT COUNT(*) FROM ".idf_escape($H["Name"]));$G[$H["Name"]]=$H;}foreach(get_rows("SELECT * FROM sqlite_sequence".($z!=""?" WHERE name = ".q($z):""),null,"")as$H)$G[$H["name"]]["Auto_increment"]=$H["seq"];return$G;}function
is_view($R){return$R["Engine"]=="view";}function
fk_support($R){return!get_val("SELECT sqlite_compileoption_used('OMIT_FOREIGN_KEY')");}function
fields($Q){$G=array();$D="";foreach(get_rows("PRAGMA table_".(min_version(3.31)?"x":"")."info(".table($Q).")")as$H){$z=$H["name"];$T=strtolower($H["type"]);$i=$H["dflt_value"];$G[$z]=array("field"=>$z,"type"=>(preg_match('~int~i',$T)?"integer":(preg_match('~char|clob|text~i',$T)?"text":(preg_match('~blob~i',$T)?"blob":(preg_match('~real|floa|doub~i',$T)?"real":"numeric")))),"full_type"=>$T,"default"=>(preg_match("~^'(.*)'$~",$i,$y)?str_replace("''","'",$y[1]):($i=="NULL"?null:$i)),"null"=>!$H["notnull"],"privileges"=>array("select"=>1,"insert"=>1,"update"=>1,"where"=>1,"order"=>1),"primary"=>$H["pk"],);if($H["pk"]){if($D!="")$G[$D]["auto_increment"]=false;elseif(preg_match('~^integer$~i',$T))$G[$z]["auto_increment"]=true;$D=$z;}}$cg=get_val("SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ".q($Q));$s='(("[^"]*+")+|[a-z0-9_]+)';preg_match_all('~'.$s.'\s+text\s+COLLATE\s+(\'[^\']+\'|\S+)~i',$cg,$Ud,PREG_SET_ORDER);foreach($Ud
as$y){$z=str_replace('""','"',preg_replace('~^"|"$~','',$y[1]));if($G[$z])$G[$z]["collation"]=trim($y[3],"'");}preg_match_all('~'.$s.'\s.*GENERATED ALWAYS AS \((.+)\) (STORED|VIRTUAL)~i',$cg,$Ud,PREG_SET_ORDER);foreach($Ud
as$y){$z=str_replace('""','"',preg_replace('~^"|"$~','',$y[1]));$G[$z]["default"]=$y[3];$G[$z]["generated"]=strtoupper($y[4]);}return$G;}function
indexes($Q,$g=null){$g=connection($g);$G=array();$cg=get_val("SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ".q($Q),0,$g);if(preg_match('~\bPRIMARY\s+KEY\s*\((([^)"]+|"[^"]*"|`[^`]*`)++)~i',$cg,$y)){$G[""]=array("type"=>"PRIMARY","columns"=>array(),"lengths"=>array(),"descs"=>array());preg_match_all('~((("[^"]*+")+|(?:`[^`]*+`)+)|(\S+))(\s+(ASC|DESC))?(,\s*|$)~i',$y[1],$Ud,PREG_SET_ORDER);foreach($Ud
as$y){$G[""]["columns"][]=idf_unescape($y[2]).$y[4];$G[""]["descs"][]=(preg_match('~DESC~i',$y[5])?'1':null);}}if(!$G){foreach(fields($Q)as$z=>$k){if($k["primary"])$G[""]=array("type"=>"PRIMARY","columns"=>array($z),"lengths"=>array(),"descs"=>array(null));}}$eg=get_key_vals("SELECT name, sql FROM sqlite_master WHERE type = 'index' AND tbl_name = ".q($Q),$g);foreach(get_rows("PRAGMA index_list(".table($Q).")",$g)as$H){$z=$H["name"];$t=array("type"=>($H["unique"]?"UNIQUE":"INDEX"));$t["lengths"]=array();$t["descs"]=array();foreach(get_rows("PRAGMA index_info(".idf_escape($z).")",$g)as$Ff){$t["columns"][]=$Ff["name"];$t["descs"][]=null;}if(preg_match('~^CREATE( UNIQUE)? INDEX '.preg_quote(idf_escape($z).' ON '.idf_escape($Q),'~').' \((.*)\)$~i',$eg[$z],$yf)){preg_match_all('/("[^"]*+")+( DESC)?/',$yf[2],$Ud);foreach($Ud[2]as$v=>$X){if($X)$t["descs"][$v]='1';}}if(!$G[""]||$t["type"]!="UNIQUE"||$t["columns"]!=$G[""]["columns"]||$t["descs"]!=$G[""]["descs"]||!preg_match("~^sqlite_~",$z))$G[$z]=$t;}return$G;}function
foreign_keys($Q){$G=array();foreach(get_rows("PRAGMA foreign_key_list(".table($Q).")")as$H){$n=&$G[$H["id"]];if(!$n)$n=$H;$n["source"][]=$H["from"];$n["target"][]=$H["to"];}return$G;}function
view($z){return
array("select"=>preg_replace('~^(?:[^`"[]+|`[^`]*`|"[^"]*")* AS\s+~iU','',get_val("SELECT sql FROM sqlite_master WHERE type = 'view' AND name = ".q($z))));}function
collations(){return(isset($_GET["create"])?get_vals("PRAGMA collation_list",1):array());}function
information_schema($h){return
false;}function
error(){return
h(connection()->error);}function
check_sqlite_name($z){$ec="db|sdb|sqlite";if(!preg_match("~^[^\\0]*\\.($ec)\$~",$z)){connection()->error=sprintf('Please use one of the extensions %s.',str_replace("|",", ",$ec));return
false;}return
true;}function
create_database($h,$c){if(file_exists($h)){connection()->error='File exists.';return
false;}if(!check_sqlite_name($h))return
false;try{$x=new
Db();$x->attach($h,'','');}catch(\Exception$Zb){connection()->error=$Zb->getMessage();return
false;}$x->query('PRAGMA encoding = "UTF-8"');$x->query('CREATE TABLE adminer (i)');$x->query('DROP TABLE adminer');return
true;}function
drop_databases($ub){connection()->attach(":memory:",'','');foreach($ub
as$h){if(!check_sqlite_name($h))return
false;if(!@unlink($h)){connection()->error='File exists.';return
false;}}return
true;}function
rename_database($z,$c){if(!check_sqlite_name($z))return
false;connection()->attach(":memory:",'','');connection()->error='File exists.';return@rename(DB,$z);}function
auto_increment(){return" PRIMARY KEY AUTOINCREMENT";}function
alter_table($Q,$z,$l,$vc,$Za,$Rb,$c,$sa,$Ze){$ch=($Q==""||$vc);foreach($l
as$k){if($k[0]!=""||!$k[1]||$k[2]){$ch=true;break;}}$b=array();$Pe=array();foreach($l
as$k){if($k[1]){$b[]=($ch?$k[1]:"ADD ".implode($k[1]));if($k[0]!="")$Pe[$k[0]]=$k[1][0];}}if(!$ch){foreach($b
as$X){if(!queries("ALTER TABLE ".table($Q)." $X"))return
false;}if($Q!=$z&&!queries("ALTER TABLE ".table($Q)." RENAME TO ".table($z)))return
false;}elseif(!recreate_table($Q,$z,$b,$Pe,$vc,$sa))return
false;if($sa){queries("BEGIN");queries("UPDATE sqlite_sequence SET seq = $sa WHERE name = ".q($z));if(!connection()->affected_rows)queries("INSERT INTO sqlite_sequence (name, seq) VALUES (".q($z).", $sa)");queries("COMMIT");}return
true;}function
recreate_table($Q,$z,array$l,array$Pe,array$vc,$sa="",$u=array(),$Gb="",$da=""){if($Q!=""){if(!$l){foreach(fields($Q)as$v=>$k){if($u)$k["auto_increment"]=0;$l[]=process_field($k,$k);$Pe[$v]=idf_escape($v);}}$mf=false;foreach($l
as$k){if($k[6])$mf=true;}$Hb=array();foreach($u
as$v=>$X){if($X[2]=="DROP"){$Hb[$X[1]]=true;unset($u[$v]);}}foreach(indexes($Q)as$Ad=>$t){$e=array();foreach($t["columns"]as$v=>$d){if(!$Pe[$d])continue
2;$e[]=$Pe[$d].($t["descs"][$v]?" DESC":"");}if(!$Hb[$Ad]){if($t["type"]!="PRIMARY"||!$mf)$u[]=array($t["type"],$Ad,$e);}}foreach($u
as$v=>$X){if($X[0]=="PRIMARY"){unset($u[$v]);$vc[]="  PRIMARY KEY (".implode(", ",$X[2]).")";}}foreach(foreign_keys($Q)as$Ad=>$n){foreach($n["source"]as$v=>$d){if(!$Pe[$d])continue
2;$n["source"][$v]=idf_unescape($Pe[$d]);}if(!isset($vc[" $Ad"]))$vc[]=" ".format_foreign_key($n);}queries("BEGIN");}$Ja=array();foreach($l
as$k){if(preg_match('~GENERATED~',$k[3]))unset($Pe[array_search($k[0],$Pe)]);$Ja[]="  ".implode($k);}$Ja=array_merge($Ja,array_filter($vc));foreach(driver()->checkConstraints($Q)as$La){if($La!=$Gb)$Ja[]="  CHECK ($La)";}if($da)$Ja[]="  CHECK ($da)";$rg=($Q==$z?"adminer_$z":$z);if(!queries("CREATE TABLE ".table($rg)." (\n".implode(",\n",$Ja)."\n)"))return
false;if($Q!=""){if($Pe&&!queries("INSERT INTO ".table($rg)." (".implode(", ",$Pe).") SELECT ".implode(", ",array_map('Adminer\idf_escape',array_keys($Pe)))." FROM ".table($Q)))return
false;$Ng=array();foreach(triggers($Q)as$Lg=>$yg){$Kg=trigger($Lg,$Q);$Ng[]="CREATE TRIGGER ".idf_escape($Lg)." ".implode(" ",$yg)." ON ".table($z)."\n$Kg[Statement]";}$sa=$sa?"":get_val("SELECT seq FROM sqlite_sequence WHERE name = ".q($Q));if(!queries("DROP TABLE ".table($Q))||($Q==$z&&!queries("ALTER TABLE ".table($rg)." RENAME TO ".table($z)))||!alter_indexes($z,$u))return
false;if($sa)queries("UPDATE sqlite_sequence SET seq = $sa WHERE name = ".q($z));foreach($Ng
as$Kg){if(!queries($Kg))return
false;}queries("COMMIT");}return
true;}function
index_sql($Q,$T,$z,$e){return"CREATE $T ".($T!="INDEX"?"INDEX ":"").idf_escape($z!=""?$z:uniqid($Q."_"))." ON ".table($Q)." $e";}function
alter_indexes($Q,$b){foreach($b
as$D){if($D[0]=="PRIMARY")return
recreate_table($Q,$Q,array(),array(),array(),"",$b);}foreach(array_reverse($b)as$X){if(!queries($X[2]=="DROP"?"DROP INDEX ".idf_escape($X[1]):index_sql($Q,$X[0],$X[1],"(".implode(", ",$X[2]).")")))return
false;}return
true;}function
truncate_tables($S){return
apply_queries("DELETE FROM",$S);}function
drop_views($mh){return
apply_queries("DROP VIEW",$mh);}function
drop_tables($S){return
apply_queries("DROP TABLE",$S);}function
move_tables($S,$mh,$qg){return
false;}function
trigger($z,$Q){if($z=="")return
array("Statement"=>"BEGIN\n\t;\nEND");$s='(?:[^`"\s]+|`[^`]*`|"[^"]*")+';$Mg=trigger_options();preg_match("~^CREATE\\s+TRIGGER\\s*$s\\s*(".implode("|",$Mg["Timing"]).")\\s+([a-z]+)(?:\\s+OF\\s+($s))?\\s+ON\\s*$s\\s*(?:FOR\\s+EACH\\s+ROW\\s)?(.*)~is",get_val("SELECT sql FROM sqlite_master WHERE type = 'trigger' AND name = ".q($z)),$y);$xe=$y[3];return
array("Timing"=>strtoupper($y[1]),"Event"=>strtoupper($y[2]).($xe?" OF":""),"Of"=>idf_unescape($xe),"Trigger"=>$z,"Statement"=>$y[4],);}function
triggers($Q){$G=array();$Mg=trigger_options();foreach(get_rows("SELECT * FROM sqlite_master WHERE type = 'trigger' AND tbl_name = ".q($Q))as$H){preg_match('~^CREATE\s+TRIGGER\s*(?:[^`"\s]+|`[^`]*`|"[^"]*")+\s*('.implode("|",$Mg["Timing"]).')\s*(.*?)\s+ON\b~i',$H["sql"],$y);$G[$H["name"]]=array($y[1],$y[2]);}return$G;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER","INSTEAD OF"),"Event"=>array("INSERT","UPDATE","UPDATE OF","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
begin(){return
queries("BEGIN");}function
last_id($F){return
get_val("SELECT LAST_INSERT_ROWID()");}function
explain($f,$E){return$f->query("EXPLAIN QUERY PLAN $E");}function
found_rows($R,$Z){}function
types(){return
array();}function
create_sql($Q,$sa,$hg){$G=get_val("SELECT sql FROM sqlite_master WHERE type IN ('table', 'view') AND name = ".q($Q));foreach(indexes($Q)as$z=>$t){if($z=='')continue;$G
.=";\n\n".index_sql($Q,$t['type'],$z,"(".implode(", ",array_map('Adminer\idf_escape',$t['columns'])).")");}return$G;}function
truncate_sql($Q){return"DELETE FROM ".table($Q);}function
use_sql($tb,$hg=""){}function
trigger_sql($Q){return
implode(get_vals("SELECT sql || ';;\n' FROM sqlite_master WHERE type = 'trigger' AND tbl_name = ".q($Q)));}function
show_variables(){$G=array();foreach(get_rows("PRAGMA pragma_list")as$H){$z=$H["name"];if($z!="pragma_list"&&$z!="compile_options"){$G[$z]=array($z,'');foreach(get_rows("PRAGMA $z")as$H)$G[$z][1].=implode(", ",$H)."\n";}}return$G;}function
show_status(){$G=array();foreach(get_vals("PRAGMA compile_options")as$He)$G[]=explode("=",$He,2)+array('','');return$G;}function
convert_field($k){}function
unconvert_field($k,$G){return$G;}function
support($ic){return
preg_match('~^(check|columns|database|drop_col|dump|indexes|descidx|move_col|sql|status|table|trigger|variables|view|view_trigger)$~',$ic);}}add_driver("pgsql","PostgreSQL");if(isset($_GET["pgsql"])){define('Adminer\DRIVER',"pgsql");if(extension_loaded("pgsql")&&$_GET["ext"]!="pdo"){class
PgsqlDb
extends
SqlDb{var$extension="PgSQL";var$timeout=0;private$link,$string,$database=true;function
_error($Wb,$j){if(ini_bool("html_errors"))$j=html_entity_decode(strip_tags($j));$j=preg_replace('~^[^:]*: ~','',$j);$this->error=$j;}function
attach($L,$V,$B){$h=adminer()->database();set_error_handler(array($this,'_error'));list($Vc,$C)=host_port(addcslashes($L,"'\\"));$this->string="host='$Vc'".($C?" port='$C'":"")." user='".addcslashes($V,"'\\")."' password='".addcslashes($B,"'\\")."'";$N=adminer()->connectSsl();if(isset($N["mode"]))$this->string
.=" sslmode='".$N["mode"]."'";$this->link=@pg_connect("$this->string dbname='".($h!=""?addcslashes($h,"'\\"):"postgres")."'",PGSQL_CONNECT_FORCE_NEW);if(!$this->link&&$h!=""){$this->database=false;$this->link=@pg_connect("$this->string dbname='postgres'",PGSQL_CONNECT_FORCE_NEW);}restore_error_handler();if($this->link)pg_set_client_encoding($this->link,"UTF8");return($this->link?'':$this->error);}function
quote($P){return(function_exists('pg_escape_literal')?pg_escape_literal($this->link,$P):"'".pg_escape_string($this->link,$P)."'");}function
value($X,array$k){return($k["type"]=="bytea"&&$X!==null?pg_unescape_bytea($X):$X);}function
select_db($tb){if($tb==adminer()->database())return$this->database;$G=@pg_connect("$this->string dbname='".addcslashes($tb,"'\\")."'",PGSQL_CONNECT_FORCE_NEW);if($G)$this->link=$G;return$G;}function
close(){$this->link=@pg_connect("$this->string dbname='postgres'");}function
query($E,$Qg=false){$F=@pg_query($this->link,$E);$this->error="";if(!$F){$this->error=pg_last_error($this->link);$G=false;}elseif(!pg_num_fields($F)){$this->affected_rows=pg_affected_rows($F);$G=true;}else$G=new
Result($F);if($this->timeout){$this->timeout=0;$this->query("RESET statement_timeout");}return$G;}function
warnings(){if(PHP_VERSION_ID>=70100){$G=implode("\n",pg_last_notice($this->link,2));pg_last_notice($this->link,3);}else$G=pg_last_notice($this->link);return
nl_br(h($G));}function
copyFrom($Q,array$I){$this->error='';set_error_handler(function($Wb,$j){$this->error=(ini_bool('html_errors')?html_entity_decode($j):$j);return
true;});$G=pg_copy_from($this->link,$Q,$I);restore_error_handler();return$G;}}class
Result{var$num_rows;private$result,$offset=0;function
__construct($F){$this->result=$F;$this->num_rows=pg_num_rows($F);}function
fetch_assoc(){return
pg_fetch_assoc($this->result);}function
fetch_row(){return
pg_fetch_row($this->result);}function
fetch_field(){$d=$this->offset++;$G=new
\stdClass;$G->orgtable=pg_field_table($this->result,$d);$G->name=pg_field_name($this->result,$d);$T=pg_field_type($this->result,$d);$G->type=(preg_match(number_type(),$T)?0:15);$G->charsetnr=($T=="bytea"?63:0);return$G;}function
__destruct(){pg_free_result($this->result);}}}elseif(extension_loaded("pdo_pgsql")){class
PgsqlDb
extends
PdoDb{var$extension="PDO_PgSQL";var$timeout=0;function
attach($L,$V,$B){$h=adminer()->database();list($Vc,$C)=host_port(addcslashes($L,"'\\"));$Ib="pgsql:host='$Vc'".($C?" port='$C'":"")." client_encoding=utf8 dbname='".($h!=""?addcslashes($h,"'\\"):"postgres")."'";$N=adminer()->connectSsl();if(isset($N["mode"]))$Ib
.=" sslmode='".$N["mode"]."'";return$this->dsn($Ib,$V,$B);}function
select_db($tb){return(adminer()->database()==$tb);}function
query($E,$Qg=false){$G=parent::query($E,$Qg);if($this->timeout){$this->timeout=0;parent::query("RESET statement_timeout");}return$G;}function
warnings(){}function
copyFrom($Q,array$I){$G=$this->pdo->pgsqlCopyFromArray($Q,$I);$this->error=idx($this->pdo->errorInfo(),2)?:'';return$G;}function
close(){}}}if(class_exists('Adminer\PgsqlDb')){class
Db
extends
PgsqlDb{function
multi_query($E){if(preg_match('~\bCOPY\s+(.+?)\s+FROM\s+stdin;\n?(.*)\n\\\\\.$~is',str_replace("\r\n","\n",$E),$y)){$I=explode("\n",$y[2]);$this->affected_rows=count($I);return$this->copyFrom($y[1],$I);}return
parent::multi_query($E);}}}class
Driver
extends
SqlDriver{static$extensions=array("PgSQL","PDO_PgSQL");static$jush="pgsql";var$operators=array("=","<",">","<=",">=","!=","~","~*","!~","LIKE","LIKE %%","ILIKE","ILIKE %%","IN","IS NULL","NOT LIKE","NOT ILIKE","NOT IN","IS NOT NULL","SQL");var$functions=array("char_length","lower","round","to_hex","to_timestamp","upper");var$grouping=array("avg","count","count distinct","max","min","sum");var$nsOid="(SELECT oid FROM pg_namespace WHERE nspname = current_schema())";static
function
connect($L,$V,$B){$f=parent::connect($L,$V,$B);if(is_string($f))return$f;$kh=get_val("SELECT version()",0,$f);$f->flavor=(preg_match('~CockroachDB~',$kh)?'cockroach':'');$f->server_info=preg_replace('~^\D*([\d.]+[-\w]*).*~','\1',$kh);if(min_version(9,0,$f))$f->query("SET application_name = 'Adminer'");if($f->flavor=='cockroach')add_driver(DRIVER,"CockroachDB");return$f;}function
__construct(Db$f){parent::__construct($f);$this->types=array('Numbers'=>array("smallint"=>5,"integer"=>10,"bigint"=>19,"boolean"=>1,"numeric"=>0,"real"=>7,"double precision"=>16,"money"=>20),'Date and time'=>array("date"=>13,"time"=>17,"timestamp"=>20,"timestamptz"=>21,"interval"=>0),'Strings'=>array("character"=>0,"character varying"=>0,"text"=>0,"tsquery"=>0,"tsvector"=>0,"uuid"=>0,"xml"=>0),'Binary'=>array("bit"=>0,"bit varying"=>0,"bytea"=>0),'Network'=>array("cidr"=>43,"inet"=>43,"macaddr"=>17,"macaddr8"=>23,"txid_snapshot"=>0),'Geometry'=>array("box"=>0,"circle"=>0,"line"=>0,"lseg"=>0,"path"=>0,"point"=>0,"polygon"=>0),);if(min_version(9.2,0,$f)){$this->types['Strings']["json"]=4294967295;if(min_version(9.4,0,$f))$this->types['Strings']["jsonb"]=4294967295;}$this->insertFunctions=array("char"=>"md5","date|time"=>"now",);$this->editFunctions=array(number_type()=>"+/-","date|time"=>"+ interval/- interval","char|text"=>"||",);if(min_version(12,0,$f)){$this->generated[]="STORED";if(min_version(18,0,$f))$this->generated[]="VIRTUAL";}$this->partitionBy=array("RANGE","LIST");if(!$f->flavor)$this->partitionBy[]="HASH";}function
enumLength(array$k){$Sb=$this->types['User types'][$k["type"]];return($Sb?type_values($Sb):"");}function
setUserTypes($Pg){$this->types['User types']=array_flip($Pg);}function
insertReturning($Q){$sa=array_filter(fields($Q),function($k){return$k['auto_increment'];});return(count($sa)==1?" RETURNING ".idf_escape(key($sa)):"");}function
insertUpdate($Q,array$I,array$D){foreach($I
as$M){$U=array();$Z=array();foreach($M
as$v=>$X){$U[]="$v = $X";if(isset($D[idf_unescape($v)]))$Z[]="$v = $X";}if(!(($Z&&queries("UPDATE ".table($Q)." SET ".implode(", ",$U)." WHERE ".implode(" AND ",$Z))&&$this->conn->affected_rows)||queries("INSERT INTO ".table($Q)." (".implode(", ",array_keys($M)).") VALUES (".implode(", ",$M).")")))return
false;}return
true;}function
slowQuery($E,$xg){$this->conn->query("SET statement_timeout = ".(1000*$xg));$this->conn->timeout=1000*$xg;return$E;}function
convertSearch($s,array$X,array$k){$tg="char|text";if(strpos($X["op"],"LIKE")===false)$tg
.="|date|time(stamp)?|boolean|uuid|inet|cidr|macaddr|".number_type();return(preg_match("~$tg~",$k["type"])?$s:"CAST($s AS text)");}function
quoteBinary($Gf){return"'\\x".bin2hex($Gf)."'";}function
warnings(){return$this->conn->warnings();}function
tableHelp($z,$xd=false){$Md=array("information_schema"=>"infoschema","pg_catalog"=>($xd?"view":"catalog"),);$x=$Md[$_GET["ns"]];if($x)return"$x-".str_replace("_","-",$z).".html";}function
inheritsFrom($Q){return
get_rows("SELECT relname AS table, nspname AS ns FROM pg_class JOIN pg_inherits ON inhparent = oid JOIN pg_namespace ON relnamespace = pg_namespace.oid WHERE inhrelid = ".$this->tableOid($Q)." ORDER BY 2, 1");}function
inheritedTables($Q){return
get_rows("SELECT relname AS table, nspname AS ns FROM pg_inherits JOIN pg_class ON inhrelid = oid JOIN pg_namespace ON relnamespace = pg_namespace.oid WHERE inhparent = ".$this->tableOid($Q)." ORDER BY 2, 1");}function
partitionsInfo($Q){$H=(min_version(10)?$this->conn->query("SELECT * FROM pg_partitioned_table WHERE partrelid = ".$this->tableOid($Q))->fetch_assoc():null);if($H){$qa=get_vals("SELECT attname FROM pg_attribute WHERE attrelid = $H[partrelid] AND attnum IN (".str_replace(" ",", ",$H["partattrs"]).")");$Ga=array('h'=>'HASH','l'=>'LIST','r'=>'RANGE');return
array("partition_by"=>$Ga[$H["partstrat"]],"partition"=>implode(", ",array_map('Adminer\idf_escape',$qa)),);}return
array();}function
tableOid($Q){return"(SELECT oid FROM pg_class WHERE relnamespace = $this->nsOid AND relname = ".q($Q)." AND relkind IN ('r', 'm', 'v', 'f', 'p'))";}function
indexAlgorithms(array$mg){static$G=array();if(!$G)$G=get_vals("SELECT amname FROM pg_am".(min_version(9.6)?" WHERE amtype = 'i'":"")." ORDER BY amname = '".($this->conn->flavor=='cockroach'?"prefix":"btree")."' DESC, amname");return$G;}function
supportsIndex(array$R){return$R["Engine"]!="view";}function
hasCStyleEscapes(){static$Ia;if($Ia===null)$Ia=(get_val("SHOW standard_conforming_strings",0,$this->conn)=="off");return$Ia;}}function
idf_escape($s){return'"'.str_replace('"','""',$s).'"';}function
table($s){return
idf_escape($s);}function
get_databases($tc){return
get_vals("SELECT datname FROM pg_database
WHERE datallowconn = TRUE AND has_database_privilege(datname, 'CONNECT')
ORDER BY datname");}function
limit($E,$Z,$w,$ye=0,$K=" "){return" $E$Z".($w?$K."LIMIT $w".($ye?" OFFSET $ye":""):"");}function
limit1($Q,$E,$Z,$K="\n"){return(preg_match('~^INTO~',$E)?limit($E,$Z,1,0,$K):" $E".(is_view(table_status1($Q))?$Z:$K."WHERE ctid = (SELECT ctid FROM ".table($Q).$Z.$K."LIMIT 1)"));}function
db_collation($h,$Va){return
get_val("SELECT datcollate FROM pg_database WHERE datname = ".q($h));}function
logged_user(){return
get_val("SELECT user");}function
tables_list(){$E="SELECT table_name, table_type FROM information_schema.tables WHERE table_schema = current_schema()";if(support("materializedview"))$E
.="
UNION ALL
SELECT matviewname, 'MATERIALIZED VIEW'
FROM pg_matviews
WHERE schemaname = current_schema()";$E
.="
ORDER BY 1";return
get_key_vals($E);}function
count_tables($ub){$G=array();foreach($ub
as$h){if(connection()->select_db($h))$G[$h]=count(tables_list());}return$G;}function
table_status($z=""){static$Oc;if($Oc===null)$Oc=get_val("SELECT 'pg_table_size'::regproc");$G=array();foreach(get_rows("SELECT
	relname AS \"Name\",
	CASE relkind WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' ELSE 'table' END AS \"Engine\"".($Oc?",
	pg_table_size(c.oid) AS \"Data_length\",
	pg_indexes_size(c.oid) AS \"Index_length\"":"").",
	obj_description(c.oid, 'pg_class') AS \"Comment\",
	".(min_version(12)?"''":"CASE WHEN relhasoids THEN 'oid' ELSE '' END")." AS \"Oid\",
	reltuples AS \"Rows\",
	".(min_version(10)?"relispartition::int AS partition,":"")."
	current_schema() AS nspname
FROM pg_class c
WHERE relkind IN ('r', 'm', 'v', 'f', 'p')
AND relnamespace = ".driver()->nsOid."
".($z!=""?"AND relname = ".q($z):"ORDER BY relname"))as$H)$G[$H["Name"]]=$H;return$G;}function
is_view($R){return
in_array($R["Engine"],array("view","materialized view"));}function
fk_support($R){return
true;}function
fields($Q){$G=array();$ja=array('timestamp without time zone'=>'timestamp','timestamp with time zone'=>'timestamptz',);foreach(get_rows("SELECT
	a.attname AS field,
	format_type(a.atttypid, a.atttypmod) AS full_type,
	pg_get_expr(d.adbin, d.adrelid) AS default,
	a.attnotnull::int,
	i.indrelid AS primary,
	col_description(a.attrelid, a.attnum) AS comment".(min_version(10)?",
	a.attidentity".(min_version(12)?",
	a.attgenerated":""):"")."
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_index i ON a.attrelid = i.indrelid AND a.attnum = ANY(i.indkey) AND i.indisprimary
WHERE a.attrelid = ".driver()->tableOid($Q)."
AND NOT a.attisdropped
AND a.attnum > 0
ORDER BY a.attnum")as$H){preg_match('~([^([]+)(\((.*)\))?([a-z ]+)?((\[[0-9]*])*)$~',$H["full_type"],$y);list(,$T,$Jd,$H["length"],$ea,$ma)=$y;$H["length"].=$ma;$Ma=$T.$ea;if(isset($ja[$Ma])){$H["type"]=$ja[$Ma];$H["full_type"]=$H["type"].$Jd.$ma;}else{$H["type"]=$T;$H["full_type"]=$H["type"].$Jd.$ea.$ma;}if(in_array($H['attidentity'],array('a','d')))$H['default']='GENERATED '.($H['attidentity']=='d'?'BY DEFAULT':'ALWAYS').' AS IDENTITY';$H["generated"]=idx(array("s"=>"STORED","v"=>"VIRTUAL"),$H["attgenerated"],"");$H["null"]=!$H["attnotnull"];$H["auto_increment"]=$H['attidentity']||preg_match('~^nextval\(~i',$H["default"])||preg_match('~^unique_rowid\(~',$H["default"]);$H["privileges"]=array("insert"=>1,"select"=>1,"update"=>1,"where"=>1,"order"=>1);if(!$H['generated']&&preg_match('~(.+)::[^,)]+(.*)~',$H["default"],$y))$H["default"]=($y[1]=="NULL"?null:idf_unescape($y[1]).$y[2]);$G[$H["field"]]=$H;}return$G;}function
indexes($Q,$g=null){$g=connection($g);$G=array();$pg=driver()->tableOid($Q);$e=get_key_vals("SELECT attnum, attname FROM pg_attribute WHERE attrelid = $pg AND attnum > 0",$g);foreach(get_rows("SELECT relname, indisunique::int, indisprimary::int, indkey, indoption, amname, pg_get_expr(indpred, indrelid, true) AS partial, pg_get_expr(indexprs, indrelid) AS indexpr
FROM pg_index
JOIN pg_class ON indexrelid = oid
JOIN pg_am ON pg_am.oid = pg_class.relam
WHERE indrelid = $pg
ORDER BY indisprimary DESC, indisunique DESC",$g)as$H){$zf=$H["relname"];$G[$zf]["type"]=($H["indisprimary"]?"PRIMARY":($H["indisunique"]?"UNIQUE":"INDEX"));$G[$zf]["columns"]=array();$G[$zf]["descs"]=array();$G[$zf]["algorithm"]=$H["amname"];$G[$zf]["partial"]=$H["partial"];$hd=preg_split('~(?<=\)), (?=\()~',$H["indexpr"]);foreach(explode(" ",$H["indkey"])as$id)$G[$zf]["columns"][]=($id?$e[$id]:array_shift($hd));foreach(explode(" ",$H["indoption"])as$jd)$G[$zf]["descs"][]=(intval($jd)&1?'1':null);$G[$zf]["lengths"]=array();}return$G;}function
foreign_keys($Q){$G=array();foreach(get_rows("SELECT conname, condeferrable::int AS deferrable, condeferred::int AS deferred, pg_get_constraintdef(oid) AS definition
FROM pg_constraint
WHERE conrelid = ".driver()->tableOid($Q)."
AND contype = 'f'::char
ORDER BY conkey, conname")as$H){$H['deferrable']=($H['deferrable']?'':'NOT ').'DEFERRABLE'.($H['deferred']?' INITIALLY DEFERRED':'');if(preg_match('~FOREIGN KEY\s*\((.+)\)\s*REFERENCES (.+)\((.+)\)(.*)$~iA',$H['definition'],$y)){$H['source']=array_map('Adminer\idf_unescape',array_map('trim',explode(',',$y[1])));if(preg_match('~^(("([^"]|"")+"|[^"]+)\.)?"?("([^"]|"")+"|[^"]+)$~',$y[2],$Sd)){$H['ns']=idf_unescape($Sd[2]);$H['table']=idf_unescape($Sd[4]);}$H['target']=array_map('Adminer\idf_unescape',array_map('trim',explode(',',$y[3])));$H['on_delete']=(preg_match("~ON DELETE (".driver()->onActions.")~",$y[4],$Sd)?$Sd[1]:'NO ACTION');$H['on_update']=(preg_match("~ON UPDATE (".driver()->onActions.")~",$y[4],$Sd)?$Sd[1]:'NO ACTION');$G[$H['conname']]=$H;}}return$G;}function
view($z){return
array("select"=>trim(get_val("SELECT pg_get_viewdef(".driver()->tableOid($z).")")));}function
collations(){return
array();}function
information_schema($h){return
get_schema()=="information_schema";}function
error(){$G=h(connection()->error);if(preg_match('~^(.*\n)?([^\n]*)\n( *)\^(\n.*)?$~s',$G,$y))$G=$y[1].preg_replace('~((?:[^&]|&[^;]*;){'.strlen($y[3]).'})(.*)~','\1<b>\2</b>',$y[2]).$y[4];return
nl_br($G);}function
create_database($h,$c){return
queries("CREATE DATABASE ".idf_escape($h).($c?" ENCODING ".idf_escape($c):""));}function
drop_databases($ub){connection()->close();return
apply_queries("DROP DATABASE",$ub,'Adminer\idf_escape');}function
rename_database($z,$c){connection()->close();return
queries("ALTER DATABASE ".idf_escape(DB)." RENAME TO ".idf_escape($z));}function
auto_increment(){return"";}function
alter_table($Q,$z,$l,$vc,$Za,$Rb,$c,$sa,$Ze){$b=array();$rf=array();if($Q!=""&&$Q!=$z)$rf[]="ALTER TABLE ".table($Q)." RENAME TO ".table($z);$Pf="";foreach($l
as$k){$d=idf_escape($k[0]);$X=$k[1];if(!$X)$b[]="DROP $d";else{$hh=$X[5];unset($X[5]);if($k[0]==""){if(isset($X[6]))$X[1]=($X[1]==" bigint"?" big":($X[1]==" smallint"?" small":" "))."serial";$b[]=($Q!=""?"ADD ":"  ").implode($X);if(isset($X[6]))$b[]=($Q!=""?"ADD":" ")." PRIMARY KEY ($X[0])";}else{if($d!=$X[0])$rf[]="ALTER TABLE ".table($z)." RENAME $d TO $X[0]";$b[]="ALTER $d TYPE$X[1]";$Qf=$Q."_".idf_unescape($X[0])."_seq";$b[]="ALTER $d ".($X[3]?"SET".preg_replace('~GENERATED ALWAYS(.*) (STORED|VIRTUAL)~','EXPRESSION\1',$X[3]):(isset($X[6])?"SET DEFAULT nextval(".q($Qf).")":"DROP DEFAULT"));if(isset($X[6]))$Pf="CREATE SEQUENCE IF NOT EXISTS ".idf_escape($Qf)." OWNED BY ".idf_escape($Q).".$X[0]";$b[]="ALTER $d ".($X[2]==" NULL"?"DROP NOT":"SET").$X[2];}if($k[0]!=""||$hh!="")$rf[]="COMMENT ON COLUMN ".table($z).".$X[0] IS ".($hh!=""?substr($hh,9):"''");}}$b=array_merge($b,$vc);if($Q==""){$O="";if($Ze){$Ra=(connection()->flavor=='cockroach');$O=" PARTITION BY $Ze[partition_by]($Ze[partition])";if($Ze["partition_by"]=='HASH'){$af=+$Ze["partitions"];for($q=0;$q<$af;$q++)$rf[]="CREATE TABLE ".idf_escape($z."_$q")." PARTITION OF ".idf_escape($z)." FOR VALUES WITH (MODULUS $af, REMAINDER $q)";}else{$lf="MINVALUE";foreach($Ze["partition_names"]as$q=>$X){$Y=$Ze["partition_values"][$q];$Xe=" VALUES ".($Ze["partition_by"]=='LIST'?"IN ($Y)":"FROM ($lf) TO ($Y)");if($Ra)$O
.=($q?",":" (")."\n  PARTITION ".(preg_match('~^DEFAULT$~i',$X)?$X:idf_escape($X))."$Xe";else$rf[]="CREATE TABLE ".idf_escape($z."_$X")." PARTITION OF ".idf_escape($z)." FOR$Xe";$lf=$Y;}$O
.=($Ra?"\n)":"");}}array_unshift($rf,"CREATE TABLE ".table($z)." (\n".implode(",\n",$b)."\n)$O");}elseif($b)array_unshift($rf,"ALTER TABLE ".table($Q)."\n".implode(",\n",$b));if($Pf)array_unshift($rf,$Pf);if($Za!==null)$rf[]="COMMENT ON TABLE ".table($z)." IS ".q($Za);foreach($rf
as$E){if(!queries($E))return
false;}return
true;}function
alter_indexes($Q,$b){$lb=array();$Fb=array();$rf=array();foreach($b
as$X){if($X[0]!="INDEX")$lb[]=($X[2]=="DROP"?"\nDROP CONSTRAINT ".idf_escape($X[1]):"\nADD".($X[1]!=""?" CONSTRAINT ".idf_escape($X[1]):"")." $X[0] ".($X[0]=="PRIMARY"?"KEY ":"")."(".implode(", ",$X[2]).")");elseif($X[2]=="DROP")$Fb[]=idf_escape($X[1]);else$rf[]="CREATE INDEX ".idf_escape($X[1]!=""?$X[1]:uniqid($Q."_"))." ON ".table($Q).($X[3]?" USING $X[3]":"")." (".implode(", ",$X[2]).")".($X[4]?" WHERE $X[4]":"");}if($lb)array_unshift($rf,"ALTER TABLE ".table($Q).implode(",",$lb));if($Fb)array_unshift($rf,"DROP INDEX ".implode(", ",$Fb));foreach($rf
as$E){if(!queries($E))return
false;}return
true;}function
truncate_tables($S){return
queries("TRUNCATE ".implode(", ",array_map('Adminer\table',$S)));}function
drop_views($mh){return
drop_tables($mh);}function
drop_tables($S){foreach($S
as$Q){$O=table_status1($Q);if(!queries("DROP ".strtoupper($O["Engine"])." ".table($Q)))return
false;}return
true;}function
move_tables($S,$mh,$qg){foreach(array_merge($S,$mh)as$Q){$O=table_status1($Q);if(!queries("ALTER ".strtoupper($O["Engine"])." ".table($Q)." SET SCHEMA ".idf_escape($qg)))return
false;}return
true;}function
trigger($z,$Q){if($z=="")return
array("Statement"=>"EXECUTE PROCEDURE ()");$e=array();$Z="WHERE trigger_schema = current_schema() AND event_object_table = ".q($Q)." AND trigger_name = ".q($z);foreach(get_rows("SELECT * FROM information_schema.triggered_update_columns $Z")as$H)$e[]=$H["event_object_column"];$G=array();foreach(get_rows('SELECT trigger_name AS "Trigger", action_timing AS "Timing", event_manipulation AS "Event", \'FOR EACH \' || action_orientation AS "Type", action_statement AS "Statement"
FROM information_schema.triggers'."
$Z
ORDER BY event_manipulation DESC")as$H){if($e&&$H["Event"]=="UPDATE")$H["Event"].=" OF";$H["Of"]=implode(", ",$e);if($G)$H["Event"].=" OR $G[Event]";$G=$H;}return$G;}function
triggers($Q){$G=array();foreach(get_rows("SELECT * FROM information_schema.triggers WHERE trigger_schema = current_schema() AND event_object_table = ".q($Q))as$H){$Kg=trigger($H["trigger_name"],$Q);$G[$Kg["Trigger"]]=array($Kg["Timing"],$Kg["Event"]);}return$G;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","UPDATE OF","DELETE","INSERT OR UPDATE","INSERT OR UPDATE OF","DELETE OR INSERT","DELETE OR UPDATE","DELETE OR UPDATE OF","DELETE OR INSERT OR UPDATE","DELETE OR INSERT OR UPDATE OF"),"Type"=>array("FOR EACH ROW","FOR EACH STATEMENT"),);}function
routine($z,$T){$I=get_rows('SELECT routine_definition AS definition, LOWER(external_language) AS language, *
FROM information_schema.routines
WHERE routine_schema = current_schema() AND specific_name = '.q($z));$G=idx($I,0,array());$G["returns"]=array("type"=>$G["type_udt_name"]);$G["fields"]=get_rows('SELECT COALESCE(parameter_name, ordinal_position::text) AS field, data_type AS type, character_maximum_length AS length, parameter_mode AS inout
FROM information_schema.parameters
WHERE specific_schema = current_schema() AND specific_name = '.q($z).'
ORDER BY ordinal_position');return$G;}function
routines(){return
get_rows('SELECT specific_name AS "SPECIFIC_NAME", routine_type AS "ROUTINE_TYPE", routine_name AS "ROUTINE_NAME", type_udt_name AS "DTD_IDENTIFIER"
FROM information_schema.routines
WHERE routine_schema = current_schema()
ORDER BY SPECIFIC_NAME');}function
routine_languages(){return
get_vals("SELECT LOWER(lanname) FROM pg_catalog.pg_language");}function
routine_id($z,$H){$G=array();foreach($H["fields"]as$k){$Jd=$k["length"];$G[]=$k["type"].($Jd?"($Jd)":"");}return
idf_escape($z)."(".implode(", ",$G).")";}function
last_id($F){$H=(is_object($F)?$F->fetch_row():array());return($H?$H[0]:0);}function
explain($f,$E){return$f->query("EXPLAIN $E");}function
found_rows($R,$Z){if(preg_match("~ rows=([0-9]+)~",get_val("EXPLAIN SELECT * FROM ".idf_escape($R["Name"]).($Z?" WHERE ".implode(" AND ",$Z):"")),$yf))return$yf[1];}function
types(){return
get_key_vals("SELECT oid, typname
FROM pg_type
WHERE typnamespace = ".driver()->nsOid."
AND typtype IN ('b','d','e')
AND typelem = 0");}function
type_values($r){$Ub=get_vals("SELECT enumlabel FROM pg_enum WHERE enumtypid = $r ORDER BY enumsortorder");return($Ub?"'".implode("', '",array_map('addslashes',$Ub))."'":"");}function
schemas(){return
get_vals("SELECT nspname FROM pg_namespace ORDER BY nspname");}function
get_schema(){return
get_val("SELECT current_schema()");}function
set_schema($Hf,$g=null){$G=connection($g)->query("SET search_path TO ".idf_escape($Hf));driver()->setUserTypes(types());return$G;}function
foreign_keys_sql($Q){$G="";$O=table_status1($Q);$te=idf_escape($O['nspname']);$rc=foreign_keys($Q);ksort($rc);foreach($rc
as$qc=>$pc)$G
.="ALTER TABLE ONLY $te.".idf_escape($O['Name'])." ADD CONSTRAINT ".idf_escape($qc)." ".preg_replace('~( REFERENCES )([^(.]+\()~',"\\1$te.\\2",$pc["definition"]).";\n";return($G?"$G\n":$G);}function
create_sql($Q,$sa,$hg){$Df=array();$Rf=array();$O=table_status1($Q);$te=idf_escape($O['nspname']);if(is_view($O)){$lh=view($Q);return
rtrim("CREATE VIEW $te.".idf_escape($Q)." AS $lh[select]",";");}$l=fields($Q);if(count($O)<2||empty($l))return
false;$G="CREATE TABLE $te.".idf_escape($O['Name'])." (\n    ";foreach($l
as$k){if($k['default']=="nextval('$O[Name]_$k[field]_seq')"){$k['default']=null;$k['full_type']=preg_replace('~int(eger)?~','serial',$k['full_type']);}$We=idf_escape($k['field']).' '.$k['full_type'].preg_replace('~(nextval\(\')([^.\']+\')~','\1'.str_replace("'","''",$O['nspname']).'.\2',default_value($k)).($k['null']?"":" NOT NULL");$Df[]=$We;if(preg_match('~nextval\(\'([^\']+)\'\)~',$k['default'],$Ud)){$Qf=$Ud[1];$bg=first(get_rows((min_version(10)?"SELECT *, cache_size AS cache_value FROM pg_sequences WHERE schemaname = current_schema() AND sequencename = ".q(idf_unescape($Qf)):"SELECT * FROM $Qf"),null,"-- "));$Rf[]=($hg=="DROP+CREATE"?"DROP SEQUENCE IF EXISTS $te.$Qf;\n":"")."CREATE SEQUENCE $te.$Qf INCREMENT $bg[increment_by] MINVALUE $bg[min_value] MAXVALUE $bg[max_value]".($sa&&$bg['last_value']?" START ".($bg["last_value"]+1):"")." CACHE $bg[cache_value];";}}if(!empty($Rf))$G=implode("\n\n",$Rf)."\n\n$G";$D="";foreach(indexes($Q)as$fd=>$t){if($t['type']=='PRIMARY'){$D=$fd;$Df[]="CONSTRAINT ".idf_escape($fd)." PRIMARY KEY (".implode(', ',array_map('Adminer\idf_escape',$t['columns'])).")";}}foreach(driver()->checkConstraints($Q)as$db=>$fb)$Df[]="CONSTRAINT ".idf_escape($db)." CHECK ($fb)";$G
.=implode(",\n    ",$Df)."\n)";$Xe=driver()->partitionsInfo($O['Name']);if($Xe)$G
.="\nPARTITION BY $Xe[partition_by]($Xe[partition])";$G
.="\nWITH (oids = ".($O['Oid']?'true':'false').");";if($O['Comment'])$G
.="\n\nCOMMENT ON TABLE $te.".idf_escape($O['Name'])." IS ".q($O['Comment']).";";foreach($l
as$jc=>$k){if($k['comment'])$G
.="\n\nCOMMENT ON COLUMN $te.".idf_escape($O['Name']).".".idf_escape($jc)." IS ".q($k['comment']).";";}foreach(get_rows("SELECT indexdef FROM pg_catalog.pg_indexes WHERE schemaname = current_schema() AND tablename = ".q($Q).($D?" AND indexname != ".q($D):""),null,"-- ")as$H)$G
.="\n\n$H[indexdef];";return
rtrim($G,';');}function
truncate_sql($Q){return"TRUNCATE ".table($Q);}function
trigger_sql($Q){$O=table_status1($Q);$G="";foreach(triggers($Q)as$Jg=>$Ig){$Kg=trigger($Jg,$O['Name']);$G
.="\nCREATE TRIGGER ".idf_escape($Kg['Trigger'])." $Kg[Timing] $Kg[Event] ON ".idf_escape($O["nspname"]).".".idf_escape($O['Name'])." $Kg[Type] $Kg[Statement];;\n";}return$G;}function
use_sql($tb,$hg=""){$z=idf_escape($tb);$G="";if(preg_match('~CREATE~',$hg)){if($hg=="DROP+CREATE")$G="DROP DATABASE IF EXISTS $z;\n";$G
.="CREATE DATABASE $z;\n";}return"$G\\connect $z";}function
show_variables(){return
get_rows("SHOW ALL");}function
process_list(){return
get_rows("SELECT * FROM pg_stat_activity ORDER BY ".(min_version(9.2)?"pid":"procpid"));}function
convert_field($k){}function
unconvert_field($k,$G){return$G;}function
support($ic){return
preg_match('~^(check|columns|comment|database|drop_col|dump|descidx|indexes|kill|partial_indexes|routine|scheme|sequence|sql|table|trigger|type|variables|view'.(min_version(9.3)?'|materializedview':'').(min_version(11)?'|procedure':'').(connection()->flavor=='cockroach'?'':'|processlist').')$~',$ic);}function
kill_process($X){return
queries("SELECT pg_terminate_backend(".number($X).")");}function
connection_id(){return"SELECT pg_backend_pid()";}function
max_connections(){return
get_val("SHOW max_connections");}}add_driver("oracle","Oracle (beta)");if(isset($_GET["oracle"])){define('Adminer\DRIVER',"oracle");if(extension_loaded("oci8")&&$_GET["ext"]!="pdo"){class
Db
extends
SqlDb{var$extension="oci8";var$_current_db;private$link;function
_error($Wb,$j){if(ini_bool("html_errors"))$j=html_entity_decode(strip_tags($j));$j=preg_replace('~^[^:]*: ~','',$j);$this->error=$j;}function
attach($L,$V,$B){$this->link=@oci_new_connect($V,$B,$L,"AL32UTF8");if($this->link){$this->server_info=oci_server_version($this->link);return'';}$j=oci_error();return$j["message"];}function
quote($P){return"'".str_replace("'","''",$P)."'";}function
select_db($tb){$this->_current_db=$tb;return
true;}function
query($E,$Qg=false){$F=oci_parse($this->link,$E);$this->error="";if(!$F){$j=oci_error($this->link);$this->errno=$j["code"];$this->error=$j["message"];return
false;}set_error_handler(array($this,'_error'));$G=@oci_execute($F);restore_error_handler();if($G){if(oci_num_fields($F))return
new
Result($F);$this->affected_rows=oci_num_rows($F);oci_free_statement($F);}return$G;}function
timeout($je){return
oci_set_call_timeout($this->link,$je);}}class
Result{var$num_rows;private$result,$offset=1;function
__construct($F){$this->result=$F;}private
function
convert($H){foreach((array)$H
as$v=>$X){if(is_a($X,'OCILob')||is_a($X,'OCI-Lob'))$H[$v]=$X->load();}return$H;}function
fetch_assoc(){return$this->convert(oci_fetch_assoc($this->result));}function
fetch_row(){return$this->convert(oci_fetch_row($this->result));}function
fetch_field(){$d=$this->offset++;$G=new
\stdClass;$G->name=oci_field_name($this->result,$d);$G->type=oci_field_type($this->result,$d);$G->charsetnr=(preg_match("~raw|blob|bfile~",$G->type)?63:0);return$G;}function
__destruct(){oci_free_statement($this->result);}}}elseif(extension_loaded("pdo_oci")){class
Db
extends
PdoDb{var$extension="PDO_OCI";var$_current_db;function
attach($L,$V,$B){return$this->dsn("oci:dbname=//$L;charset=AL32UTF8",$V,$B);}function
select_db($tb){$this->_current_db=$tb;return
true;}}}class
Driver
extends
SqlDriver{static$extensions=array("OCI8","PDO_OCI");static$jush="oracle";var$insertFunctions=array("date"=>"current_date","timestamp"=>"current_timestamp",);var$editFunctions=array("number|float|double"=>"+/-","date|timestamp"=>"+ interval/- interval","char|clob"=>"||",);var$operators=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","IN","IS NULL","NOT LIKE","NOT IN","IS NOT NULL","SQL");var$functions=array("length","lower","round","upper");var$grouping=array("avg","count","count distinct","max","min","sum");function
__construct(Db$f){parent::__construct($f);$this->types=array('Numbers'=>array("number"=>38,"binary_float"=>12,"binary_double"=>21),'Date and time'=>array("date"=>10,"timestamp"=>29,"interval year"=>12,"interval day"=>28),'Strings'=>array("char"=>2000,"varchar2"=>4000,"nchar"=>2000,"nvarchar2"=>4000,"clob"=>4294967295,"nclob"=>4294967295),'Binary'=>array("raw"=>2000,"long raw"=>2147483648,"blob"=>4294967295,"bfile"=>4294967296),);}function
begin(){return
true;}function
insertUpdate($Q,array$I,array$D){foreach($I
as$M){$U=array();$Z=array();foreach($M
as$v=>$X){$U[]="$v = $X";if(isset($D[idf_unescape($v)]))$Z[]="$v = $X";}if(!(($Z&&queries("UPDATE ".table($Q)." SET ".implode(", ",$U)." WHERE ".implode(" AND ",$Z))&&$this->conn->affected_rows)||queries("INSERT INTO ".table($Q)." (".implode(", ",array_keys($M)).") VALUES (".implode(", ",$M).")")))return
false;}return
true;}function
hasCStyleEscapes(){return
true;}}function
idf_escape($s){return'"'.str_replace('"','""',$s).'"';}function
table($s){return
idf_escape($s);}function
get_databases($tc){return
get_vals("SELECT DISTINCT tablespace_name FROM (
SELECT tablespace_name FROM user_tablespaces
UNION SELECT tablespace_name FROM all_tables WHERE tablespace_name IS NOT NULL
)
ORDER BY 1");}function
limit($E,$Z,$w,$ye=0,$K=" "){return($ye?" * FROM (SELECT t.*, rownum AS rnum FROM (SELECT $E$Z) t WHERE rownum <= ".($w+$ye).") WHERE rnum > $ye":($w?" * FROM (SELECT $E$Z) WHERE rownum <= ".($w+$ye):" $E$Z"));}function
limit1($Q,$E,$Z,$K="\n"){return" $E$Z";}function
db_collation($h,$Va){return
get_val("SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET'");}function
logged_user(){return
get_val("SELECT USER FROM DUAL");}function
get_current_db(){$h=connection()->_current_db?:DB;unset(connection()->_current_db);return$h;}function
where_owner($kf,$Re="owner"){if(!$_GET["ns"])return'';return"$kf$Re = sys_context('USERENV', 'CURRENT_SCHEMA')";}function
views_table($e){$Re=where_owner('');return"(SELECT $e FROM all_views WHERE ".($Re?:"rownum < 0").")";}function
tables_list(){$lh=views_table("view_name");$Re=where_owner(" AND ");return
get_key_vals("SELECT table_name, 'table' FROM all_tables WHERE tablespace_name = ".q(DB)."$Re
UNION SELECT view_name, 'view' FROM $lh
ORDER BY 1");}function
count_tables($ub){$G=array();foreach($ub
as$h)$G[$h]=get_val("SELECT COUNT(*) FROM all_tables WHERE tablespace_name = ".q($h));return$G;}function
table_status($z=""){$G=array();$Jf=q($z);$h=get_current_db();$lh=views_table("view_name");$Re=where_owner(" AND ");foreach(get_rows('SELECT table_name "Name", \'table\' "Engine", avg_row_len * num_rows "Data_length", num_rows "Rows" FROM all_tables WHERE tablespace_name = '.q($h).$Re.($z!=""?" AND table_name = $Jf":"")."
UNION SELECT view_name, 'view', 0, 0 FROM $lh".($z!=""?" WHERE view_name = $Jf":"")."
ORDER BY 1")as$H)$G[$H["Name"]]=$H;return$G;}function
is_view($R){return$R["Engine"]=="view";}function
fk_support($R){return
true;}function
fields($Q){$G=array();$Re=where_owner(" AND ");foreach(get_rows("SELECT * FROM all_tab_columns WHERE table_name = ".q($Q)."$Re ORDER BY column_id")as$H){$T=$H["DATA_TYPE"];$Jd="$H[DATA_PRECISION],$H[DATA_SCALE]";if($Jd==",")$Jd=$H["CHAR_COL_DECL_LENGTH"];$G[$H["COLUMN_NAME"]]=array("field"=>$H["COLUMN_NAME"],"full_type"=>$T.($Jd?"($Jd)":""),"type"=>strtolower($T),"length"=>$Jd,"default"=>$H["DATA_DEFAULT"],"null"=>($H["NULLABLE"]=="Y"),"privileges"=>array("insert"=>1,"select"=>1,"update"=>1,"where"=>1,"order"=>1),);}return$G;}function
indexes($Q,$g=null){$G=array();$Re=where_owner(" AND ","aic.table_owner");foreach(get_rows("SELECT aic.*, ac.constraint_type, atc.data_default
FROM all_ind_columns aic
LEFT JOIN all_constraints ac ON aic.index_name = ac.constraint_name AND aic.table_name = ac.table_name AND aic.index_owner = ac.owner
LEFT JOIN all_tab_cols atc ON aic.column_name = atc.column_name AND aic.table_name = atc.table_name AND aic.index_owner = atc.owner
WHERE aic.table_name = ".q($Q)."$Re
ORDER BY ac.constraint_type, aic.column_position",$g)as$H){$fd=$H["INDEX_NAME"];$Xa=$H["DATA_DEFAULT"];$Xa=($Xa?trim($Xa,'"'):$H["COLUMN_NAME"]);$G[$fd]["type"]=($H["CONSTRAINT_TYPE"]=="P"?"PRIMARY":($H["CONSTRAINT_TYPE"]=="U"?"UNIQUE":"INDEX"));$G[$fd]["columns"][]=$Xa;$G[$fd]["lengths"][]=($H["CHAR_LENGTH"]&&$H["CHAR_LENGTH"]!=$H["COLUMN_LENGTH"]?$H["CHAR_LENGTH"]:null);$G[$fd]["descs"][]=($H["DESCEND"]&&$H["DESCEND"]=="DESC"?'1':null);}return$G;}function
view($z){$lh=views_table("view_name, text");$I=get_rows('SELECT text "select" FROM '.$lh.' WHERE view_name = '.q($z));return
reset($I);}function
collations(){return
array();}function
information_schema($h){return
get_schema()=="INFORMATION_SCHEMA";}function
error(){return
h(connection()->error);}function
explain($f,$E){$f->query("EXPLAIN PLAN FOR $E");return$f->query("SELECT * FROM plan_table");}function
found_rows($R,$Z){}function
auto_increment(){return"";}function
alter_table($Q,$z,$l,$vc,$Za,$Rb,$c,$sa,$Ze){$b=$Fb=array();$Ne=($Q?fields($Q):array());foreach($l
as$k){$X=$k[1];if($X&&$k[0]!=""&&idf_escape($k[0])!=$X[0])queries("ALTER TABLE ".table($Q)." RENAME COLUMN ".idf_escape($k[0])." TO $X[0]");$Me=$Ne[$k[0]];if($X&&$Me){$_e=process_field($Me,$Me);if($X[2]==$_e[2])$X[2]="";}if($X)$b[]=($Q!=""?($k[0]!=""?"MODIFY (":"ADD ("):"  ").implode($X).($Q!=""?")":"");else$Fb[]=idf_escape($k[0]);}if($Q=="")return
queries("CREATE TABLE ".table($z)." (\n".implode(",\n",$b)."\n)");return(!$b||queries("ALTER TABLE ".table($Q)."\n".implode("\n",$b)))&&(!$Fb||queries("ALTER TABLE ".table($Q)." DROP (".implode(", ",$Fb).")"))&&($Q==$z||queries("ALTER TABLE ".table($Q)." RENAME TO ".table($z)));}function
alter_indexes($Q,$b){$Fb=array();$rf=array();foreach($b
as$X){if($X[0]!="INDEX"){$X[2]=preg_replace('~ DESC$~','',$X[2]);$lb=($X[2]=="DROP"?"\nDROP CONSTRAINT ".idf_escape($X[1]):"\nADD".($X[1]!=""?" CONSTRAINT ".idf_escape($X[1]):"")." $X[0] ".($X[0]=="PRIMARY"?"KEY ":"")."(".implode(", ",$X[2]).")");array_unshift($rf,"ALTER TABLE ".table($Q).$lb);}elseif($X[2]=="DROP")$Fb[]=idf_escape($X[1]);else$rf[]="CREATE INDEX ".idf_escape($X[1]!=""?$X[1]:uniqid($Q."_"))." ON ".table($Q)." (".implode(", ",$X[2]).")";}if($Fb)array_unshift($rf,"DROP INDEX ".implode(", ",$Fb));foreach($rf
as$E){if(!queries($E))return
false;}return
true;}function
foreign_keys($Q){$G=array();$E="SELECT c_list.CONSTRAINT_NAME as NAME,
c_src.COLUMN_NAME as SRC_COLUMN,
c_dest.OWNER as DEST_DB,
c_dest.TABLE_NAME as DEST_TABLE,
c_dest.COLUMN_NAME as DEST_COLUMN,
c_list.DELETE_RULE as ON_DELETE
FROM ALL_CONSTRAINTS c_list, ALL_CONS_COLUMNS c_src, ALL_CONS_COLUMNS c_dest
WHERE c_list.CONSTRAINT_NAME = c_src.CONSTRAINT_NAME
AND c_list.R_CONSTRAINT_NAME = c_dest.CONSTRAINT_NAME
AND c_list.CONSTRAINT_TYPE = 'R'
AND c_src.TABLE_NAME = ".q($Q);foreach(get_rows($E)as$H)$G[$H['NAME']]=array("db"=>$H['DEST_DB'],"table"=>$H['DEST_TABLE'],"source"=>array($H['SRC_COLUMN']),"target"=>array($H['DEST_COLUMN']),"on_delete"=>$H['ON_DELETE'],"on_update"=>null,);return$G;}function
truncate_tables($S){return
apply_queries("TRUNCATE TABLE",$S);}function
drop_views($mh){return
apply_queries("DROP VIEW",$mh);}function
drop_tables($S){return
apply_queries("DROP TABLE",$S);}function
last_id($F){return
0;}function
schemas(){$G=get_vals("SELECT DISTINCT owner FROM dba_segments WHERE owner IN (SELECT username FROM dba_users WHERE default_tablespace NOT IN ('SYSTEM','SYSAUX')) ORDER BY 1");return($G?:get_vals("SELECT DISTINCT owner FROM all_tables WHERE tablespace_name = ".q(DB)." ORDER BY 1"));}function
get_schema(){return
get_val("SELECT sys_context('USERENV', 'SESSION_USER') FROM dual");}function
set_schema($If,$g=null){return
connection($g)->query("ALTER SESSION SET CURRENT_SCHEMA = ".idf_escape($If));}function
show_variables(){return
get_rows('SELECT name, display_value FROM v$parameter');}function
show_status(){$G=array();$I=get_rows('SELECT * FROM v$instance');foreach(reset($I)as$v=>$X)$G[]=array($v,$X);return$G;}function
process_list(){return
get_rows('SELECT
	sess.process AS "process",
	sess.username AS "user",
	sess.schemaname AS "schema",
	sess.status AS "status",
	sess.wait_class AS "wait_class",
	sess.seconds_in_wait AS "seconds_in_wait",
	sql.sql_text AS "sql_text",
	sess.machine AS "machine",
	sess.port AS "port"
FROM v$session sess LEFT OUTER JOIN v$sql sql
ON sql.sql_id = sess.sql_id
WHERE sess.type = \'USER\'
ORDER BY PROCESS
');}function
convert_field($k){}function
unconvert_field($k,$G){return$G;}function
support($ic){return
preg_match('~^(columns|database|drop_col|indexes|descidx|processlist|scheme|sql|status|table|variables|view)$~',$ic);}}add_driver("mssql","MS SQL");if(isset($_GET["mssql"])){define('Adminer\DRIVER',"mssql");if(extension_loaded("sqlsrv")&&$_GET["ext"]!="pdo"){class
Db
extends
SqlDb{var$extension="sqlsrv";private$link,$result;private
function
get_error(){$this->error="";foreach(sqlsrv_errors()as$j){$this->errno=$j["code"];$this->error
.="$j[message]\n";}$this->error=rtrim($this->error);}function
attach($L,$V,$B){$eb=array("UID"=>$V,"PWD"=>$B,"CharacterSet"=>"UTF-8");$N=adminer()->connectSsl();if(isset($N["Encrypt"]))$eb["Encrypt"]=$N["Encrypt"];if(isset($N["TrustServerCertificate"]))$eb["TrustServerCertificate"]=$N["TrustServerCertificate"];$h=adminer()->database();if($h!="")$eb["Database"]=$h;list($Vc,$C)=host_port($L);$this->link=@sqlsrv_connect($Vc.($C?",$C":""),$eb);if($this->link){$kd=sqlsrv_server_info($this->link);$this->server_info=$kd['SQLServerVersion'];}else$this->get_error();return($this->link?'':$this->error);}function
quote($P){$Rg=strlen($P)!=strlen(utf8_decode($P));return($Rg?"N":"")."'".str_replace("'","''",$P)."'";}function
select_db($tb){return$this->query(use_sql($tb));}function
query($E,$Qg=false){$F=sqlsrv_query($this->link,$E);$this->error="";if(!$F){$this->get_error();return
false;}return$this->store_result($F);}function
multi_query($E){$this->result=sqlsrv_query($this->link,$E);$this->error="";if(!$this->result){$this->get_error();return
false;}return
true;}function
store_result($F=null){if(!$F)$F=$this->result;if(!$F)return
false;if(sqlsrv_field_metadata($F))return
new
Result($F);$this->affected_rows=sqlsrv_rows_affected($F);return
true;}function
next_result(){return$this->result?!!sqlsrv_next_result($this->result):false;}}class
Result{var$num_rows;private$result,$offset=0,$fields;function
__construct($F){$this->result=$F;}private
function
convert($H){foreach((array)$H
as$v=>$X){if(is_a($X,'DateTime'))$H[$v]=$X->format("Y-m-d H:i:s");}return$H;}function
fetch_assoc(){return$this->convert(sqlsrv_fetch_array($this->result,SQLSRV_FETCH_ASSOC));}function
fetch_row(){return$this->convert(sqlsrv_fetch_array($this->result,SQLSRV_FETCH_NUMERIC));}function
fetch_field(){if(!$this->fields)$this->fields=sqlsrv_field_metadata($this->result);$k=$this->fields[$this->offset++];$G=new
\stdClass;$G->name=$k["Name"];$G->type=($k["Type"]==1?254:15);$G->charsetnr=0;return$G;}function
seek($ye){for($q=0;$q<$ye;$q++)sqlsrv_fetch($this->result);}function
__destruct(){sqlsrv_free_stmt($this->result);}}function
last_id($F){return
get_val("SELECT SCOPE_IDENTITY()");}function
explain($f,$E){$f->query("SET SHOWPLAN_ALL ON");$G=$f->query($E);$f->query("SET SHOWPLAN_ALL OFF");return$G;}}else{abstract
class
MssqlDb
extends
PdoDb{function
select_db($tb){return$this->query(use_sql($tb));}function
lastInsertId(){return$this->pdo->lastInsertId();}}function
last_id($F){return
connection()->lastInsertId();}function
explain($f,$E){}if(extension_loaded("pdo_sqlsrv")){class
Db
extends
MssqlDb{var$extension="PDO_SQLSRV";function
attach($L,$V,$B){list($Vc,$C)=host_port($L);return$this->dsn("sqlsrv:Server=$Vc".($C?",$C":""),$V,$B);}}}elseif(extension_loaded("pdo_dblib")){class
Db
extends
MssqlDb{var$extension="PDO_DBLIB";function
attach($L,$V,$B){list($Vc,$C)=host_port($L);return$this->dsn("dblib:charset=utf8;host=$Vc".($C?(is_numeric($C)?";port=":";unix_socket=").$C:""),$V,$B);}}}}class
Driver
extends
SqlDriver{static$extensions=array("SQLSRV","PDO_SQLSRV","PDO_DBLIB");static$jush="mssql";var$insertFunctions=array("date|time"=>"getdate");var$editFunctions=array("int|decimal|real|float|money|datetime"=>"+/-","char|text"=>"+",);var$operators=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","IN","IS NULL","NOT LIKE","NOT IN","IS NOT NULL");var$functions=array("len","lower","round","upper");var$grouping=array("avg","count","count distinct","max","min","sum");var$generated=array("PERSISTED","VIRTUAL");var$onActions="NO ACTION|CASCADE|SET NULL|SET DEFAULT";static
function
connect($L,$V,$B){if($L=="")$L="localhost:1433";return
parent::connect($L,$V,$B);}function
__construct(Db$f){parent::__construct($f);$this->types=array('Numbers'=>array("tinyint"=>3,"smallint"=>5,"int"=>10,"bigint"=>20,"bit"=>1,"decimal"=>0,"real"=>12,"float"=>53,"smallmoney"=>10,"money"=>20),'Date and time'=>array("date"=>10,"smalldatetime"=>19,"datetime"=>19,"datetime2"=>19,"time"=>8,"datetimeoffset"=>10),'Strings'=>array("char"=>8000,"varchar"=>8000,"text"=>2147483647,"nchar"=>4000,"nvarchar"=>4000,"ntext"=>1073741823),'Binary'=>array("binary"=>8000,"varbinary"=>8000,"image"=>2147483647),);}function
insertUpdate($Q,array$I,array$D){$l=fields($Q);$U=array();$Z=array();$M=reset($I);$e="c".implode(", c",range(1,count($M)));$Ha=0;$od=array();foreach($M
as$v=>$X){$Ha++;$z=idf_unescape($v);if(!$l[$z]["auto_increment"])$od[$v]="c$Ha";if(isset($D[$z]))$Z[]="$v = c$Ha";else$U[]="$v = c$Ha";}$ih=array();foreach($I
as$M)$ih[]="(".implode(", ",$M).")";if($Z){$ad=queries("SET IDENTITY_INSERT ".table($Q)." ON");$G=queries("MERGE ".table($Q)." USING (VALUES\n\t".implode(",\n\t",$ih)."\n) AS source ($e) ON ".implode(" AND ",$Z).($U?"\nWHEN MATCHED THEN UPDATE SET ".implode(", ",$U):"")."\nWHEN NOT MATCHED THEN INSERT (".implode(", ",array_keys($ad?$M:$od)).") VALUES (".($ad?$e:implode(", ",$od)).");");if($ad)queries("SET IDENTITY_INSERT ".table($Q)." OFF");}else$G=queries("INSERT INTO ".table($Q)." (".implode(", ",array_keys($M)).") VALUES\n".implode(",\n",$ih));return$G;}function
begin(){return
queries("BEGIN TRANSACTION");}function
tableHelp($z,$xd=false){$Md=array("sys"=>"catalog-views/sys-","INFORMATION_SCHEMA"=>"information-schema-views/",);$x=$Md[get_schema()];if($x)return"relational-databases/system-$x".preg_replace('~_~','-',strtolower($z))."-transact-sql";}}function
idf_escape($s){return"[".str_replace("]","]]",$s)."]";}function
table($s){return($_GET["ns"]!=""?idf_escape($_GET["ns"]).".":"").idf_escape($s);}function
get_databases($tc){return
get_vals("SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')");}function
limit($E,$Z,$w,$ye=0,$K=" "){return($w?" TOP (".($w+$ye).")":"")." $E$Z";}function
limit1($Q,$E,$Z,$K="\n"){return
limit($E,$Z,1,0,$K);}function
db_collation($h,$Va){return
get_val("SELECT collation_name FROM sys.databases WHERE name = ".q($h));}function
logged_user(){return
get_val("SELECT SUSER_NAME()");}function
tables_list(){return
get_key_vals("SELECT name, type_desc FROM sys.all_objects WHERE schema_id = SCHEMA_ID(".q(get_schema()).") AND type IN ('S', 'U', 'V') ORDER BY name");}function
count_tables($ub){$G=array();foreach($ub
as$h){connection()->select_db($h);$G[$h]=get_val("SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES");}return$G;}function
table_status($z=""){$G=array();foreach(get_rows("SELECT ao.name AS Name, ao.type_desc AS Engine, (SELECT cast(value as varchar(max)) FROM fn_listextendedproperty(default, 'SCHEMA', schema_name(schema_id), 'TABLE', ao.name, null, null)) AS Comment
FROM sys.all_objects AS ao
WHERE schema_id = SCHEMA_ID(".q(get_schema()).") AND type IN ('S', 'U', 'V') ".($z!=""?"AND name = ".q($z):"ORDER BY name"))as$H)$G[$H["Name"]]=$H;return$G;}function
is_view($R){return$R["Engine"]=="VIEW";}function
fk_support($R){return
true;}function
fields($Q){$ab=get_key_vals("SELECT objname, cast(value as varchar(max)) FROM fn_listextendedproperty('MS_DESCRIPTION', 'schema', ".q(get_schema()).", 'table', ".q($Q).", 'column', NULL)");$G=array();$ng=get_val("SELECT object_id FROM sys.all_objects WHERE schema_id = SCHEMA_ID(".q(get_schema()).") AND type IN ('S', 'U', 'V') AND name = ".q($Q));foreach(get_rows("SELECT c.max_length, c.precision, c.scale, c.name, c.is_nullable, c.is_identity, c.collation_name, t.name type, d.definition [default], d.name default_constraint, i.is_primary_key
FROM sys.all_columns c
JOIN sys.types t ON c.user_type_id = t.user_type_id
LEFT JOIN sys.default_constraints d ON c.default_object_id = d.object_id
LEFT JOIN sys.index_columns ic ON c.object_id = ic.object_id AND c.column_id = ic.column_id
LEFT JOIN sys.indexes i ON ic.object_id = i.object_id AND ic.index_id = i.index_id
WHERE c.object_id = ".q($ng))as$H){$T=$H["type"];$Jd=(preg_match("~char|binary~",$T)?intval($H["max_length"])/($T[0]=='n'?2:1):($T=="decimal"?"$H[precision],$H[scale]":""));$G[$H["name"]]=array("field"=>$H["name"],"full_type"=>$T.($Jd?"($Jd)":""),"type"=>$T,"length"=>$Jd,"default"=>(preg_match("~^\('(.*)'\)$~",$H["default"],$y)?str_replace("''","'",$y[1]):$H["default"]),"default_constraint"=>$H["default_constraint"],"null"=>$H["is_nullable"],"auto_increment"=>$H["is_identity"],"collation"=>$H["collation_name"],"privileges"=>array("insert"=>1,"select"=>1,"update"=>1,"where"=>1,"order"=>1),"primary"=>$H["is_primary_key"],"comment"=>$ab[$H["name"]],);}foreach(get_rows("SELECT * FROM sys.computed_columns WHERE object_id = ".q($ng))as$H){$G[$H["name"]]["generated"]=($H["is_persisted"]?"PERSISTED":"VIRTUAL");$G[$H["name"]]["default"]=$H["definition"];}return$G;}function
indexes($Q,$g=null){$G=array();foreach(get_rows("SELECT i.name, key_ordinal, is_unique, is_primary_key, c.name AS column_name, is_descending_key
FROM sys.indexes i
INNER JOIN sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE OBJECT_NAME(i.object_id) = ".q($Q),$g)as$H){$z=$H["name"];$G[$z]["type"]=($H["is_primary_key"]?"PRIMARY":($H["is_unique"]?"UNIQUE":"INDEX"));$G[$z]["lengths"]=array();$G[$z]["columns"][$H["key_ordinal"]]=$H["column_name"];$G[$z]["descs"][$H["key_ordinal"]]=($H["is_descending_key"]?'1':null);}return$G;}function
view($z){return
array("select"=>preg_replace('~^(?:[^[]|\[[^]]*])*\s+AS\s+~isU','',get_val("SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = SCHEMA_NAME() AND TABLE_NAME = ".q($z))));}function
collations(){$G=array();foreach(get_vals("SELECT name FROM fn_helpcollations()")as$c)$G[preg_replace('~_.*~','',$c)][]=$c;return$G;}function
information_schema($h){return
get_schema()=="INFORMATION_SCHEMA";}function
error(){return
nl_br(h(preg_replace('~^(\[[^]]*])+~m','',connection()->error)));}function
create_database($h,$c){return
queries("CREATE DATABASE ".idf_escape($h).(preg_match('~^[a-z0-9_]+$~i',$c)?" COLLATE $c":""));}function
drop_databases($ub){return
queries("DROP DATABASE ".implode(", ",array_map('Adminer\idf_escape',$ub)));}function
rename_database($z,$c){if(preg_match('~^[a-z0-9_]+$~i',$c))queries("ALTER DATABASE ".idf_escape(DB)." COLLATE $c");queries("ALTER DATABASE ".idf_escape(DB)." MODIFY NAME = ".idf_escape($z));return
true;}function
auto_increment(){return" IDENTITY".($_POST["Auto_increment"]!=""?"(".number($_POST["Auto_increment"]).",1)":"")." PRIMARY KEY";}function
alter_table($Q,$z,$l,$vc,$Za,$Rb,$c,$sa,$Ze){$b=array();$ab=array();$Ne=fields($Q);foreach($l
as$k){$d=idf_escape($k[0]);$X=$k[1];if(!$X)$b["DROP"][]=" COLUMN $d";else{$X[1]=preg_replace("~( COLLATE )'(\\w+)'~",'\1\2',$X[1]);$ab[$k[0]]=$X[5];unset($X[5]);if(preg_match('~ AS ~',$X[3]))unset($X[1],$X[2]);if($k[0]=="")$b["ADD"][]="\n  ".implode("",$X).($Q==""?substr($vc[$X[0]],16+strlen($X[0])):"");else{$i=$X[3];unset($X[3]);unset($X[6]);if($d!=$X[0])queries("EXEC sp_rename ".q(table($Q).".$d").", ".q(idf_unescape($X[0])).", 'COLUMN'");$b["ALTER COLUMN ".implode("",$X)][]="";$Me=$Ne[$k[0]];if(default_value($Me)!=$i){if($Me["default"]!==null)$b["DROP"][]=" ".idf_escape($Me["default_constraint"]);if($i)$b["ADD"][]="\n $i FOR $d";}}}}if($Q=="")return
queries("CREATE TABLE ".table($z)." (".implode(",",(array)$b["ADD"])."\n)");if($Q!=$z)queries("EXEC sp_rename ".q(table($Q)).", ".q($z));if($vc)$b[""]=$vc;foreach($b
as$v=>$X){if(!queries("ALTER TABLE ".table($z)." $v".implode(",",$X)))return
false;}foreach($ab
as$v=>$X){$Za=substr($X,9);queries("EXEC sp_dropextendedproperty @name = N'MS_Description', @level0type = N'Schema', @level0name = ".q(get_schema()).", @level1type = N'Table', @level1name = ".q($z).", @level2type = N'Column', @level2name = ".q($v));queries("EXEC sp_addextendedproperty
@name = N'MS_Description',
@value = $Za,
@level0type = N'Schema',
@level0name = ".q(get_schema()).",
@level1type = N'Table',
@level1name = ".q($z).",
@level2type = N'Column',
@level2name = ".q($v));}return
true;}function
alter_indexes($Q,$b){$t=array();$Fb=array();foreach($b
as$X){if($X[2]=="DROP"){if($X[0]=="PRIMARY")$Fb[]=idf_escape($X[1]);else$t[]=idf_escape($X[1])." ON ".table($Q);}elseif(!queries(($X[0]!="PRIMARY"?"CREATE $X[0] ".($X[0]!="INDEX"?"INDEX ":"").idf_escape($X[1]!=""?$X[1]:uniqid($Q."_"))." ON ".table($Q):"ALTER TABLE ".table($Q)." ADD PRIMARY KEY")." (".implode(", ",$X[2]).")"))return
false;}return(!$t||queries("DROP INDEX ".implode(", ",$t)))&&(!$Fb||queries("ALTER TABLE ".table($Q)." DROP ".implode(", ",$Fb)));}function
found_rows($R,$Z){}function
foreign_keys($Q){$G=array();$Be=array("CASCADE","NO ACTION","SET NULL","SET DEFAULT");foreach(get_rows("EXEC sp_fkeys @fktable_name = ".q($Q).", @fktable_owner = ".q(get_schema()))as$H){$n=&$G[$H["FK_NAME"]];$n["db"]=$H["PKTABLE_QUALIFIER"];$n["ns"]=$H["PKTABLE_OWNER"];$n["table"]=$H["PKTABLE_NAME"];$n["on_update"]=$Be[$H["UPDATE_RULE"]];$n["on_delete"]=$Be[$H["DELETE_RULE"]];$n["source"][]=$H["FKCOLUMN_NAME"];$n["target"][]=$H["PKCOLUMN_NAME"];}return$G;}function
truncate_tables($S){return
apply_queries("TRUNCATE TABLE",$S);}function
drop_views($mh){return
queries("DROP VIEW ".implode(", ",array_map('Adminer\table',$mh)));}function
drop_tables($S){return
queries("DROP TABLE ".implode(", ",array_map('Adminer\table',$S)));}function
move_tables($S,$mh,$qg){return
apply_queries("ALTER SCHEMA ".idf_escape($qg)." TRANSFER",array_merge($S,$mh));}function
trigger($z,$Q){if($z=="")return
array();$I=get_rows("SELECT s.name [Trigger],
CASE WHEN OBJECTPROPERTY(s.id, 'ExecIsInsertTrigger') = 1 THEN 'INSERT' WHEN OBJECTPROPERTY(s.id, 'ExecIsUpdateTrigger') = 1 THEN 'UPDATE' WHEN OBJECTPROPERTY(s.id, 'ExecIsDeleteTrigger') = 1 THEN 'DELETE' END [Event],
CASE WHEN OBJECTPROPERTY(s.id, 'ExecIsInsteadOfTrigger') = 1 THEN 'INSTEAD OF' ELSE 'AFTER' END [Timing],
c.text
FROM sysobjects s
JOIN syscomments c ON s.id = c.id
WHERE s.xtype = 'TR' AND s.name = ".q($z));$G=reset($I);if($G)$G["Statement"]=preg_replace('~^.+\s+AS\s+~isU','',$G["text"]);return$G;}function
triggers($Q){$G=array();foreach(get_rows("SELECT sys1.name,
CASE WHEN OBJECTPROPERTY(sys1.id, 'ExecIsInsertTrigger') = 1 THEN 'INSERT' WHEN OBJECTPROPERTY(sys1.id, 'ExecIsUpdateTrigger') = 1 THEN 'UPDATE' WHEN OBJECTPROPERTY(sys1.id, 'ExecIsDeleteTrigger') = 1 THEN 'DELETE' END [Event],
CASE WHEN OBJECTPROPERTY(sys1.id, 'ExecIsInsteadOfTrigger') = 1 THEN 'INSTEAD OF' ELSE 'AFTER' END [Timing]
FROM sysobjects sys1
JOIN sysobjects sys2 ON sys1.parent_obj = sys2.id
WHERE sys1.xtype = 'TR' AND sys2.name = ".q($Q))as$H)$G[$H["name"]]=array($H["Timing"],$H["Event"]);return$G;}function
trigger_options(){return
array("Timing"=>array("AFTER","INSTEAD OF"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("AS"),);}function
schemas(){return
get_vals("SELECT name FROM sys.schemas");}function
get_schema(){if($_GET["ns"]!="")return$_GET["ns"];return
get_val("SELECT SCHEMA_NAME()");}function
set_schema($Hf){$_GET["ns"]=$Hf;return
true;}function
create_sql($Q,$sa,$hg){if(is_view(table_status1($Q))){$lh=view($Q);return"CREATE VIEW ".table($Q)." AS $lh[select]";}$l=array();$D=false;foreach(fields($Q)as$z=>$k){$X=process_field($k,$k);if($X[6])$D=true;$l[]=implode("",$X);}foreach(indexes($Q)as$z=>$t){if(!$D||$t["type"]!="PRIMARY"){$e=array();foreach($t["columns"]as$v=>$X)$e[]=idf_escape($X).($t["descs"][$v]?" DESC":"");$z=idf_escape($z);$l[]=($t["type"]=="INDEX"?"INDEX $z":"CONSTRAINT $z ".($t["type"]=="UNIQUE"?"UNIQUE":"PRIMARY KEY"))." (".implode(", ",$e).")";}}foreach(driver()->checkConstraints($Q)as$z=>$La)$l[]="CONSTRAINT ".idf_escape($z)." CHECK ($La)";return"CREATE TABLE ".table($Q)." (\n\t".implode(",\n\t",$l)."\n)";}function
foreign_keys_sql($Q){$l=array();foreach(foreign_keys($Q)as$vc)$l[]=ltrim(format_foreign_key($vc));return($l?"ALTER TABLE ".table($Q)." ADD\n\t".implode(",\n\t",$l).";\n\n":"");}function
truncate_sql($Q){return"TRUNCATE TABLE ".table($Q);}function
use_sql($tb,$hg=""){return"USE ".idf_escape($tb);}function
trigger_sql($Q){$G="";foreach(triggers($Q)as$z=>$Kg)$G
.=create_trigger(" ON ".table($Q),trigger($z,$Q)).";";return$G;}function
convert_field($k){}function
unconvert_field($k,$G){return$G;}function
support($ic){return
preg_match('~^(check|comment|columns|database|drop_col|dump|indexes|descidx|scheme|sql|table|trigger|view|view_trigger)$~',$ic);}}class
Adminer{static$instance;var$error='';private$values=array();function
name(){return"<a href='https://www.adminer.org/editor/'".target_blank()." id='h1'><img src='".h(preg_replace("~\\?.*~","",ME)."?file=logo.png&version=5.4.4")."' width='24' height='24' alt='' id='logo'>".'Editor'."</a>";}function
credentials(){return
array(SERVER,$_GET["username"],get_password());}function
connectSsl(){}function
permanentLogin($lb=false){return
password_file($lb);}function
bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
serverName($L){}function
database(){if(connection()){$ub=adminer()->databases(false);return(!$ub?get_val("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1)"):$ub[(information_schema($ub[0])?1:0)]);}}function
operators(){return
array("<=",">=");}function
schemas(){return
schemas();}function
databases($tc=true){return
get_databases($tc);}function
pluginsLinks(){}function
queryTimeout(){return
5;}function
afterConnect(){}function
headers(){}function
csp($ob){return$ob;}function
head($rb=null){return
true;}function
bodyClass(){echo" editor";}function
css(){$G=array();foreach(array("","-dark")as$ie){$m="adminer$ie.css";if(file_exists($m)){$lc=file_get_contents($m);$G["$m?v=".crc32($lc)]=($ie?"dark":(preg_match('~prefers-color-scheme:\s*dark~',$lc)?'':'light'));}}return$G;}function
loginForm(){echo"<table class='layout'>\n",adminer()->loginFormField('username','<tr><th>'.'Username'.'<td>',input_hidden("auth[driver]","server").'<input name="auth[username]" autofocus value="'.h($_GET["username"]).'" autocomplete="username" autocapitalize="off">'),adminer()->loginFormField('password','<tr><th>'.'Password'.'<td>','<input type="password" name="auth[password]" autocomplete="current-password">'),"</table>\n","<p><input type='submit' value='".'Login'."'>\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],'Permanent login')."\n";}function
loginFormField($z,$Rc,$Y){return$Rc.$Y."\n";}function
login($Od,$B){return
true;}function
tableName($mg){return
h(isset($mg["Engine"])?($mg["Comment"]!=""?$mg["Comment"]:$mg["Name"]):"");}function
fieldName($k,$Je=0){return
h(preg_replace('~\s+\[.*\]$~','',($k["comment"]!=""?$k["comment"]:$k["field"])));}function
selectLinks($mg,$M=""){$a=$mg["Name"];if($M!==null)echo'<p class="tabs"><a href="'.h(ME.'edit='.urlencode($a).$M).'">'.'New item'."</a>\n";}function
foreignKeys($Q){return
foreign_keys($Q);}function
backwardKeys($Q,$lg){$G=array();foreach(get_rows("SELECT TABLE_NAME, CONSTRAINT_NAME, COLUMN_NAME, REFERENCED_COLUMN_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = ".q(adminer()->database())."
AND REFERENCED_TABLE_SCHEMA = ".q(adminer()->database())."
AND REFERENCED_TABLE_NAME = ".q($Q)."
ORDER BY ORDINAL_POSITION",null,"")as$H)$G[$H["TABLE_NAME"]]["keys"][$H["CONSTRAINT_NAME"]][$H["COLUMN_NAME"]]=$H["REFERENCED_COLUMN_NAME"];foreach($G
as$v=>$X){$z=adminer()->tableName(table_status1($v,true));if($z!=""){$Jf=preg_quote($lg);$K="(:|\\s*-)?\\s+";$G[$v]["name"]=(preg_match("(^$Jf$K(.+)|^(.+?)$K$Jf\$)iu",$z,$y)?$y[2].$y[3]:$z);}else
unset($G[$v]);}return$G;}function
backwardKeysPrint($xa,$H){foreach($xa
as$Q=>$wa){foreach($wa["keys"]as$Wa){$x=ME.'select='.urlencode($Q);$q=0;foreach($Wa
as$d=>$X)$x
.=where_link($q++,$d,$H[$X]);echo"<a href='".h($x)."'>".h($wa["name"])."</a>";$x=ME.'edit='.urlencode($Q);foreach($Wa
as$d=>$X)$x
.="&set".urlencode("[".bracket_escape($d)."]")."=".urlencode($H[$X]);echo"<a href='".h($x)."' title='".'New item'."'>+</a> ";}}}function
selectQuery($E,$fg,$gc=false){return"<!--\n".str_replace("--","--><!-- ",$E)."\n(".format_time($fg).")\n-->\n";}function
rowDescription($Q){foreach(fields($Q)as$k){if(preg_match("~varchar|character varying~",$k["type"]))return
idf_escape($k["field"]);}return"";}function
rowDescriptions($I,$xc){$G=$I;foreach($I[0]as$v=>$X){if(list($Q,$r,$z)=$this->_foreignColumn($xc,$v)){$bd=array();foreach($I
as$H)$bd[$H[$v]]=q($H[$v]);$_b=$this->values[$Q];if(!$_b)$_b=get_key_vals("SELECT $r, $z FROM ".table($Q)." WHERE $r IN (".implode(", ",$bd).")");foreach($I
as$ne=>$H){if(isset($H[$v]))$G[$ne][$v]=(string)$_b[$H[$v]];}}}return$G;}function
selectLink($X,$k){}function
selectVal($X,$x,$k,$Oe){$G="$X";$x=h($x);if(is_blob($k)&&!is_utf8($X)){$G=lang_format(array('%d byte','%d bytes'),strlen($Oe));if(preg_match("~^(GIF|\xFF\xD8\xFF|\x89PNG\x0D\x0A\x1A\x0A)~",$Oe))$G="<img src='$x' alt='$G'>";}if(like_bool($k)&&$G!="")$G=(preg_match('~^(1|t|true|y|yes|on)$~i',$X)?'yes':'no');if($x)$G="<a href='$x'".(is_url($x)?target_blank():"").">$G</a>";if(preg_match('~date~',$k["type"]))$G="<div class='datetime'>$G</div>";return$G;}function
editVal($X,$k){if(preg_match('~date|timestamp~',$k["type"])&&$X!==null)return
preg_replace('~^(\d{2}(\d+))-(0?(\d+))-(0?(\d+))~','$1-$3-$5',$X);return$X;}function
config(){return
array();}function
selectColumnsPrint($J,$e){}function
selectSearchPrint($Z,$e,$u){$Z=(array)$_GET["where"];echo'<fieldset id="fieldset-search"><legend>'.'Search'."</legend><div>\n";$Bd=array();foreach($Z
as$v=>$X)$Bd[$X["col"]]=$v;$q=0;$l=fields($_GET["select"]);foreach($e
as$z=>$zb){$k=$l[$z];if($k["type"]=="enum"||like_bool($k)){$v=$Bd[$z];$q--;echo"<div>".h($zb).":".input_hidden("where[$q][col]",$z);$X=idx($Z[$v],"val");echo(like_bool($k)?"<select name='where[$q][val]'>".optionlist(array(""=>"",'no','yes'),$X,true)."</select>":enum_input("checkbox"," name='where[$q][val][]'",$k,(array)$X,'empty')),"</div>\n";unset($e[$z]);}elseif(is_array($_=$this->foreignKeyOptions($_GET["select"],$z))){if($l[$z]["null"])$_[0]='('.'empty'.')';$v=$Bd[$z];$q--;echo"<div>".h($zb).input_hidden("where[$q][col]",$z).input_hidden("where[$q][op]","=").": <select name='where[$q][val]'>".optionlist($_,idx($Z[$v],"val"),true)."</select></div>\n";unset($e[$z]);}}$q=0;foreach($Z
as$X){if(($X["col"]==""||$e[$X["col"]])&&"$X[col]$X[val]"!=""){echo"<div><select name='where[$q][col]'><option value=''>(".'anywhere'.")".optionlist($e,$X["col"],true)."</select>",html_select("where[$q][op]",array(-1=>"")+adminer()->operators(),$X["op"]),"<input type='search' name='where[$q][val]' value='".h($X["val"])."'>".script("mixin(qsl('input'), {onkeydown: selectSearchKeydown, onsearch: selectSearchSearch});","")."</div>\n";$q++;}}echo"<div><select name='where[$q][col]'><option value=''>(".'anywhere'.")".optionlist($e,null,true)."</select>",script("qsl('select').onchange = selectAddRow;",""),html_select("where[$q][op]",array(-1=>"")+adminer()->operators()),"<input type='search' name='where[$q][val]'></div>",script("mixin(qsl('input'), {onchange: function () { this.parentNode.firstChild.onchange(); }, onsearch: selectSearchSearch});"),"</div></fieldset>\n";}function
selectOrderPrint($Je,$e,$u){$Le=array();foreach($u
as$v=>$t){$Je=array();foreach($t["columns"]as$X)$Je[]=$e[$X];if(count(array_filter($Je,'strlen'))>1&&$v!="PRIMARY")$Le[$v]=implode(", ",$Je);}if($Le)echo'<fieldset><legend>'.'Sort'."</legend><div>","<select name='index_order'>".optionlist(array(""=>"")+$Le,(idx($_GET["order"],0)!=""?"":$_GET["index_order"]),true)."</select>","</div></fieldset>\n";if($_GET["order"])echo"<div style='display: none;'>".hidden_fields(array("order"=>array(1=>reset($_GET["order"])),"desc"=>($_GET["desc"]?array(1=>1):array()),))."</div>\n";}function
selectLimitPrint($w){echo"<fieldset><legend>".'Limit'."</legend><div>",html_select("limit",array("",50,100),$w),"</div></fieldset>\n";}function
selectLengthPrint($ug){}function
selectActionPrint($u){echo"<fieldset><legend>".'Action'."</legend><div>","<input type='submit' value='".'Select'."'>","</div></fieldset>\n";}function
selectCommandPrint(){return
true;}function
selectImportPrint(){return
true;}function
selectEmailPrint($Ob,$e){}function
selectColumnsProcess($e,$u){return
array(array(),array());}function
selectSearchProcess($l,$u){$G=array();foreach((array)$_GET["where"]as$v=>$Z){$Ua=$Z["col"];$Ee=$Z["op"];$X=$Z["val"];if(($v>=0&&$Ua!="")||$X!=""){$bb=array();foreach(($Ua!=""?array($Ua=>$l[$Ua]):$l)as$z=>$k){if($Ua!=""||is_numeric($X)||!preg_match(number_type(),$k["type"])){$z=idf_escape($z);if($Ua!=""&&$k["type"]=="enum"){$dd=array();foreach($X
as$gh){if(preg_match('~val-~',$gh))$dd[]=q(substr($gh,4));}$bb[]=(in_array("null",$X)?"$z IS NULL OR ":"").($dd?"$z IN (".implode(", ",$dd).")":"0");}else{$vg=preg_match('~char|text|enum|set~',$k["type"]);$Y=adminer()->processInput($k,(!$Ee&&$vg&&preg_match('~^[^%]+$~',$X)?"%$X%":$X));$bb[]=driver()->convertSearch($z,$Z,$k).($Y=="NULL"?" IS".($Ee==">="?" NOT":"")." $Y":(in_array($Ee,adminer()->operators())||$Ee=="="?" $Ee $Y":($vg?" LIKE $Y":" IN (".($Y[0]=="'"?str_replace(",","', '",$Y):$Y).")")));if($v<0&&$X=="0")$bb[]="$z IS NULL";}}}$G[]=($bb?"(".implode(" OR ",$bb).")":"1 = 0");}}return$G;}function
selectOrderProcess($l,$u){$gd=$_GET["index_order"];if($gd!="")unset($_GET["order"][1]);if($_GET["order"])return
array(idf_escape(reset($_GET["order"])).($_GET["desc"]?" DESC":""));foreach(($gd!=""?array($u[$gd]):$u)as$t){if($gd!=""||$t["type"]=="INDEX"){$Lc=array_filter($t["descs"]);$zb=false;foreach($t["columns"]as$X){if(preg_match('~date|timestamp~',$l[$X]["type"])){$zb=true;break;}}$G=array();foreach($t["columns"]as$v=>$X)$G[]=idf_escape($X).(($Lc?$t["descs"][$v]:$zb)?" DESC":"");return$G;}}return
array();}function
selectLimitProcess(){return(isset($_GET["limit"])?intval($_GET["limit"]):50);}function
selectLengthProcess(){return"100";}function
selectEmailProcess($Z,$xc){return
false;}function
selectQueryBuild($J,$Z,$Fc,$Je,$w,$A){return"";}function
messageQuery($E,$wg,$gc=false){return" <span class='time'>".@date("H:i:s")."</span><!--\n".str_replace("--","--><!-- ",$E)."\n".($wg?"($wg)\n":"")."-->";}function
editRowPrint($Q,$l,$H,$U){}function
editFunctions($k){$G=array();if($k["null"]&&preg_match('~blob~',$k["type"]))$G["NULL"]='empty';$G[""]=($k["null"]||$k["auto_increment"]||like_bool($k)?"":"*");if(preg_match('~date|time~',$k["type"]))$G["now"]='now';if(preg_match('~_(md5|sha1)$~i',$k["field"],$y))$G[]=strtolower($y[1]);return$G;}function
editInput($Q,$k,$qa,$Y){if($k["type"]=="enum")return(isset($_GET["select"])?"<label><input type='radio'$qa value='orig' checked><i>".'original'."</i></label> ":"").enum_input("radio",$qa,$k,$Y,'empty');$_=$this->foreignKeyOptions($Q,$k["field"],$Y);if($_!==null)return(is_array($_)?"<select$qa>".optionlist($_,(string)$Y,true)."</select>":"<input value='".h($Y)."'$qa class='hidden'>"."<input value='".h($_)."' class='jsonly'>"."<div></div>".script("qsl('input').oninput = partial(whisper, '".ME."script=complete&source=".urlencode($Q)."&field=".urlencode($k["field"])."&value='); qsl('div').onclick = whisperClick;",""));if(like_bool($k))return'<input type="checkbox" value="1"'.(preg_match('~^(1|t|true|y|yes|on)$~i',$Y)?' checked':'')."$qa>";$Tc="";if(preg_match('~time~',$k["type"]))$Tc='HH:MM:SS';if(preg_match('~date|timestamp~',$k["type"]))$Tc='[yyyy]-mm-dd'.($Tc?" [$Tc]":"");if($Tc)return"<input value='".h($Y)."'$qa> ($Tc)";if(preg_match('~_(md5|sha1)$~i',$k["field"]))return"<input type='password' value='".h($Y)."'$qa>";return'';}function
editHint($Q,$k,$Y){return(preg_match('~\s+(\[.*\])$~',($k["comment"]!=""?$k["comment"]:$k["field"]),$y)?h(" $y[1]"):'');}function
processInput($k,$Y,$p=""){if($p=="now")return"$p()";$G=$Y;if(preg_match('~date|timestamp~',$k["type"])&&preg_match('(^'.str_replace('\$1','(?P<p1>\d*)',preg_replace('~(\\\\\\$([2-6]))~','(?P<p\2>\d{1,2})',preg_quote('$1-$3-$5'))).'(.*))',$Y,$y))$G=($y["p1"]!=""?$y["p1"]:($y["p2"]!=""?($y["p2"]<70?20:19).$y["p2"]:gmdate("Y")))."-$y[p3]$y[p4]-$y[p5]$y[p6]".end($y);$G=q($G);if($Y==""&&like_bool($k))$G="'0'";elseif($Y==""&&($k["null"]||!preg_match('~char|text~',$k["type"])))$G="NULL";elseif(preg_match('~^(md5|sha1)$~',$p))$G="$p($G)";return
unconvert_field($k,$G);}function
dumpOutput(){return
array();}function
dumpFormat(){return
array('csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
dumpDatabase($h){}function
dumpTable($Q,$hg,$xd=0){echo"\xef\xbb\xbf";}function
dumpData($Q,$hg,$E){$F=connection()->query($E,1);if($F){while($H=$F->fetch_assoc()){if($hg=="table"){dump_csv(array_keys($H));$hg="INSERT";}dump_csv($H);}}}function
dumpFilename($Zc){return
friendly_url($Zc);}function
dumpHeaders($Zc,$le=false){$cc="csv";header("Content-Type: text/csv; charset=utf-8");return$cc;}function
dumpFooter(){}function
importServerPath(){}function
homepage(){return
true;}function
navigation($he){echo"<h1>".adminer()->name()." <span class='version'>".VERSION;$qe=$_COOKIE["adminer_version"];echo" <a href='https://www.adminer.org/editor/#download'".target_blank()." id='version'>".(version_compare(VERSION,$qe)<0?h($qe):"")."</a>","</span></h1>\n";if($he=="auth"){$oc=true;foreach((array)$_SESSION["pwds"]as$jh=>$Tf){foreach($Tf[""]as$V=>$B){if($B!==null){if($oc){echo"<ul id='logins'>",script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");$oc=false;}echo"<li><a href='".h(auth_url($jh,"",$V))."'>".($V!=""?h($V):"<i>".'empty'."</i>")."</a>\n";}}}}else{adminer()->databasesPrint($he);$ca=adminer()->menuActions(array(),$he);echo($ca?"<p class='links'>\n".implode("\n",$ca)."\n":"");if($he!="db"&&$he!="ns"){$R=table_status('',true);if(!$R)echo"<p class='message'>".'No tables.'."\n";else
adminer()->tablesPrint($R);}}}function
syntaxHighlighting($S){}function
databasesPrint($he){}function
menuActions($ca,$he){return$ca;}function
tablesPrint($S){echo"<ul id='tables'>",script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($S
as$H){echo'<li>';$z=adminer()->tableName($H);if($z!="")echo"<a href='".h(ME).'select='.urlencode($H["Name"])."'".bold($_GET["select"]==$H["Name"]||$_GET["edit"]==$H["Name"],"select")." title='".'Select data'."'>$z</a>\n";}echo"</ul>\n";}function
_foreignColumn($xc,$d){foreach((array)$xc[$d]as$wc){if(count($wc["source"])==1){$z=adminer()->rowDescription($wc["table"]);if($z!=""){$r=idf_escape($wc["target"][0]);return
array($wc["table"],$r,$z);}}}}private
function
foreignKeyOptions($Q,$d,$Y=null){if(list($qg,$r,$z)=$this->_foreignColumn(column_foreign_keys($Q),$d)){$G=&$this->values[$qg];if($G===null){$R=table_status1($qg);$G=($R["Rows"]>1000?"":array(""=>"")+get_key_vals("SELECT $r, $z FROM ".table($qg)." ORDER BY 2"));}if(!$G&&$Y!==null)return
get_val("SELECT $z FROM ".table($qg)." WHERE $r = ".q($Y));return$G;}}}class
Plugins{private
static$append=array('dumpFormat'=>true,'dumpOutput'=>true,'editRowPrint'=>true,'editFunctions'=>true,'config'=>true);var$plugins;var$error='';private$hooks=array();function
__construct($gf){if($gf===null){$gf=array();$_a="adminer-plugins";if(is_dir($_a)){foreach(glob("$_a/*.php")as$m)$this->includeOnce($m);}$Sc=" href='https://www.adminer.org/plugins/#use'".target_blank();if(file_exists("$_a.php")){$ed=$this->includeOnce("$_a.php");if(is_array($ed)){foreach($ed
as$ff)$gf[get_class($ff)]=$ff;}else$this->error
.=sprintf('%s must <a%s>return an array</a>.',"<b>$_a.php</b>",$Sc)."<br>";}foreach(get_declared_classes()as$Qa){if(!$gf[$Qa]&&(preg_match('~^Adminer\w~i',$Qa)||is_subclass_of($Qa,'Adminer\Plugin'))){$xf=new
\ReflectionClass($Qa);$gb=$xf->getConstructor();if($gb&&$gb->getNumberOfRequiredParameters())$this->error
.=sprintf('<a%s>Configure</a> %s in %s.',$Sc,"<b>$Qa</b>","<b>$_a.php</b>")."<br>";else$gf[$Qa]=new$Qa;}}}$this->plugins=$gf;$fa=new
Adminer;$gf[]=$fa;$xf=new
\ReflectionObject($fa);foreach($xf->getMethods()as$ge){foreach($gf
as$ff){$z=$ge->getName();if(method_exists($ff,$z))$this->hooks[$z][]=$ff;}}}function
includeOnce($m){return
include_once"./$m";}function
__call($z,array$Ve){$la=array();foreach($Ve
as$v=>$X)$la[]=&$Ve[$v];$G=null;foreach($this->hooks[$z]as$ff){$Y=call_user_func_array(array($ff,$z),$la);if($Y!==null){if(!self::$append[$z])return$Y;$G=$Y+(array)$G;}}return$G;}}abstract
class
Plugin{protected$translations=array();function
description(){return$this->lang('');}function
screenshot(){return"";}protected
function
lang($s,$we=null){$la=func_get_args();$la[0]=idx($this->translations[LANG],$s)?:$s;return
call_user_func_array('Adminer\lang_format',$la);}}Adminer::$instance=(function_exists('adminer_object')?adminer_object():(is_dir("adminer-plugins")||file_exists("adminer-plugins.php")?new
Plugins(null):new
Adminer));SqlDriver::$drivers=array("server"=>"MySQL / MariaDB")+SqlDriver::$drivers;if(!defined('Adminer\DRIVER')){define('Adminer\DRIVER',"server");if(extension_loaded("mysqli")&&$_GET["ext"]!="pdo"){class
Db
extends
\MySQLi{static$instance;var$extension="MySQLi",$flavor='';function
__construct(){parent::init();}function
attach($L,$V,$B){mysqli_report(MYSQLI_REPORT_OFF);list($Vc,$C)=host_port($L);$N=adminer()->connectSsl();if($N)$this->ssl_set($N['key'],$N['cert'],$N['ca'],'','');$G=@$this->real_connect(($L!=""?$Vc:ini_get("mysqli.default_host")),($L.$V!=""?$V:ini_get("mysqli.default_user")),($L.$V.$B!=""?$B:ini_get("mysqli.default_pw")),null,(is_numeric($C)?intval($C):ini_get("mysqli.default_port")),(is_numeric($C)?null:$C),($N?($N['verify']!==false?2048:64):0));$this->options(MYSQLI_OPT_LOCAL_INFILE,0);return($G?'':$this->error);}function
set_charset($Ka){if(parent::set_charset($Ka))return
true;parent::set_charset('utf8');return$this->query("SET NAMES $Ka");}function
next_result(){return
self::more_results()&&parent::next_result();}function
quote($P){return"'".$this->escape_string($P)."'";}}}elseif(extension_loaded("mysql")&&!((ini_bool("sql.safe_mode")||ini_bool("mysql.allow_local_infile"))&&extension_loaded("pdo_mysql"))){class
Db
extends
SqlDb{private$link;function
attach($L,$V,$B){if(ini_bool("mysql.allow_local_infile"))return
sprintf('Disable %s or enable %s or %s extensions.',"'mysql.allow_local_infile'","MySQLi","PDO_MySQL");$this->link=@mysql_connect(($L!=""?$L:ini_get("mysql.default_host")),($L.$V!=""?$V:ini_get("mysql.default_user")),($L.$V.$B!=""?$B:ini_get("mysql.default_password")),true,131072);if(!$this->link)return
mysql_error();$this->server_info=mysql_get_server_info($this->link);return'';}function
set_charset($Ka){if(function_exists('mysql_set_charset')){if(mysql_set_charset($Ka,$this->link))return
true;mysql_set_charset('utf8',$this->link);}return$this->query("SET NAMES $Ka");}function
quote($P){return"'".mysql_real_escape_string($P,$this->link)."'";}function
select_db($tb){return
mysql_select_db($tb,$this->link);}function
query($E,$Qg=false){$F=@($Qg?mysql_unbuffered_query($E,$this->link):mysql_query($E,$this->link));$this->error="";if(!$F){$this->errno=mysql_errno($this->link);$this->error=mysql_error($this->link);return
false;}if($F===true){$this->affected_rows=mysql_affected_rows($this->link);$this->info=mysql_info($this->link);return
true;}return
new
Result($F);}}class
Result{var$num_rows;private$result;private$offset=0;function
__construct($F){$this->result=$F;$this->num_rows=mysql_num_rows($F);}function
fetch_assoc(){return
mysql_fetch_assoc($this->result);}function
fetch_row(){return
mysql_fetch_row($this->result);}function
fetch_field(){$G=mysql_fetch_field($this->result,$this->offset++);$G->orgtable=$G->table;$G->charsetnr=($G->blob?63:0);return$G;}function
__destruct(){mysql_free_result($this->result);}}}elseif(extension_loaded("pdo_mysql")){class
Db
extends
PdoDb{var$extension="PDO_MySQL";function
attach($L,$V,$B){$_=array(\PDO::MYSQL_ATTR_LOCAL_INFILE=>false);$N=adminer()->connectSsl();if($N){if($N['key'])$_[\PDO::MYSQL_ATTR_SSL_KEY]=$N['key'];if($N['cert'])$_[\PDO::MYSQL_ATTR_SSL_CERT]=$N['cert'];if($N['ca'])$_[\PDO::MYSQL_ATTR_SSL_CA]=$N['ca'];if(isset($N['verify']))$_[\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT]=$N['verify'];}list($Vc,$C)=host_port($L);return$this->dsn("mysql:charset=utf8;host=$Vc".($C?(is_numeric($C)?";port=":";unix_socket=").$C:""),$V,$B,$_);}function
set_charset($Ka){return$this->query("SET NAMES $Ka");}function
select_db($tb){return$this->query("USE ".idf_escape($tb));}function
query($E,$Qg=false){$this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,!$Qg);return
parent::query($E,$Qg);}}}class
Driver
extends
SqlDriver{static$extensions=array("MySQLi","MySQL","PDO_MySQL");static$jush="sql";var$unsigned=array("unsigned","zerofill","unsigned zerofill");var$operators=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","FIND_IN_SET","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL");var$functions=array("char_length","date","from_unixtime","lower","round","floor","ceil","sec_to_time","time_to_sec","upper");var$grouping=array("avg","count","count distinct","group_concat","max","min","sum");static
function
connect($L,$V,$B){$f=parent::connect($L,$V,$B);if(is_string($f)){if(function_exists('iconv')&&!is_utf8($f)&&strlen($Gf=iconv("windows-1250","utf-8",$f))>strlen($f))$f=$Gf;return$f;}$f->set_charset(charset($f));$f->query("SET sql_quote_show_create = 1, autocommit = 1");$f->flavor=(preg_match('~MariaDB~',$f->server_info)?'maria':'mysql');add_driver(DRIVER,($f->flavor=='maria'?"MariaDB":"MySQL"));return$f;}function
__construct(Db$f){parent::__construct($f);$this->types=array('Numbers'=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),'Date and time'=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),'Strings'=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),'Lists'=>array("enum"=>65535,"set"=>64),'Binary'=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),'Geometry'=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),);$this->insertFunctions=array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",);$this->editFunctions=array(number_type()=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",);if(min_version('5.7.8',10.2,$f))$this->types['Strings']["json"]=4294967295;if(min_version('',10.7,$f)){$this->types['Strings']["uuid"]=128;$this->insertFunctions['uuid']='uuid';}if(min_version(9,'',$f)){$this->types['Numbers']["vector"]=16383;$this->insertFunctions['vector']='string_to_vector';}if(min_version(5.1,'',$f))$this->partitionBy=array("HASH","LINEAR HASH","KEY","LINEAR KEY","RANGE","LIST");if(min_version(5.7,10.2,$f))$this->generated=array("STORED","VIRTUAL");}function
unconvertFunction(array$k){return(preg_match("~binary~",$k["type"])?"<code class='jush-sql'>UNHEX</code>":($k["type"]=="bit"?doc_link(array('sql'=>'bit-value-literals.html'),"<code>b''</code>"):(preg_match("~geometry|point|linestring|polygon~",$k["type"])?"<code class='jush-sql'>GeomFromText</code>":"")));}function
insert($Q,array$M){return($M?parent::insert($Q,$M):queries("INSERT INTO ".table($Q)." ()\nVALUES ()"));}function
insertUpdate($Q,array$I,array$D){$e=array_keys(reset($I));$kf="INSERT INTO ".table($Q)." (".implode(", ",$e).") VALUES\n";$ih=array();foreach($e
as$v)$ih[$v]="$v = VALUES($v)";$jg="\nON DUPLICATE KEY UPDATE ".implode(", ",$ih);$ih=array();$Jd=0;foreach($I
as$M){$Y="(".implode(", ",$M).")";if($ih&&(strlen($kf)+$Jd+strlen($Y)+strlen($jg)>1e6)){if(!queries($kf.implode(",\n",$ih).$jg))return
false;$ih=array();$Jd=0;}$ih[]=$Y;$Jd+=strlen($Y)+2;}return
queries($kf.implode(",\n",$ih).$jg);}function
slowQuery($E,$xg){if(min_version('5.7.8','10.1.2')){if($this->conn->flavor=='maria')return"SET STATEMENT max_statement_time=$xg FOR $E";elseif(preg_match('~^(SELECT\b)(.+)~is',$E,$y))return"$y[1] /*+ MAX_EXECUTION_TIME(".($xg*1000).") */ $y[2]";}}function
convertSearch($s,array$X,array$k){return(preg_match('~char|text|enum|set~',$k["type"])&&!preg_match("~^utf8~",$k["collation"])&&preg_match('~[\x80-\xFF]~',$X['val'])?"CONVERT($s USING ".charset($this->conn).")":$s);}function
quoteBinary($Gf){return"X".q(bin2hex($Gf));}function
warnings(){$F=$this->conn->query("SHOW WARNINGS");if($F&&$F->num_rows){ob_start();print_select_result($F);return
ob_get_clean();}}function
tableHelp($z,$xd=false){$Qd=($this->conn->flavor=='maria');if(information_schema(DB))return
strtolower("information-schema-".($Qd?"$z-table/":str_replace("_","-",$z)."-table.html"));if(DB=="mysql")return($Qd?"mysql$z-table/":"system-schema.html");}function
partitionsInfo($Q){$Ac="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($Q);$F=$this->conn->query("SELECT PARTITION_METHOD, PARTITION_EXPRESSION, PARTITION_ORDINAL_POSITION $Ac ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");$G=array();list($G["partition_by"],$G["partition"],$G["partitions"])=$F->fetch_row();$af=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $Ac AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$G["partition_names"]=array_keys($af);$G["partition_values"]=array_values($af);return$G;}function
hasCStyleEscapes(){static$Ia;if($Ia===null){$dg=get_val("SHOW VARIABLES LIKE 'sql_mode'",1,$this->conn);$Ia=(strpos($dg,'NO_BACKSLASH_ESCAPES')===false);}return$Ia;}function
engines(){$G=array();foreach(get_rows("SHOW ENGINES")as$H){if(preg_match("~YES|DEFAULT~",$H["Support"]))$G[]=$H["Engine"];}return$G;}function
indexAlgorithms(array$mg){return(preg_match('~^(MEMORY|NDB)$~',$mg["Engine"])?array("HASH","BTREE"):array());}}function
idf_escape($s){return"`".str_replace("`","``",$s)."`";}function
table($s){return
idf_escape($s);}function
get_databases($tc){$G=get_session("dbs");if($G===null){$E="SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME";$G=($tc?slow_query($E):get_vals($E));restart_session();set_session("dbs",$G);stop_session();}return$G;}function
limit($E,$Z,$w,$ye=0,$K=" "){return" $E$Z".($w?$K."LIMIT $w".($ye?" OFFSET $ye":""):"");}function
limit1($Q,$E,$Z,$K="\n"){return
limit($E,$Z,1,0,$K);}function
db_collation($h,array$Va){$G=null;$lb=get_val("SHOW CREATE DATABASE ".idf_escape($h),1);if(preg_match('~ COLLATE ([^ ]+)~',$lb,$y))$G=$y[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$lb,$y))$G=$Va[$y[1]][-1];return$G;}function
logged_user(){return
get_val("SELECT USER()");}function
tables_list(){return
get_key_vals("SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME");}function
count_tables(array$ub){$G=array();foreach($ub
as$h)$G[$h]=count(get_vals("SHOW TABLES IN ".idf_escape($h)));return$G;}function
table_status($z="",$hc=false){$G=array();foreach(get_rows($hc?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($z!=""?"AND TABLE_NAME = ".q($z):"ORDER BY Name"):"SHOW TABLE STATUS".($z!=""?" LIKE ".q(addcslashes($z,"%_\\")):""))as$H){if($H["Engine"]=="InnoDB")$H["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\1',$H["Comment"]);if(!isset($H["Engine"]))$H["Comment"]="";if($z!="")$H["Name"]=$z;$G[$H["Name"]]=$H;}return$G;}function
is_view(array$R){return$R["Engine"]===null;}function
fk_support(array$R){return
preg_match('~InnoDB|IBMDB2I'.(min_version(5.6)?'|NDB':'').'~i',$R["Engine"]);}function
fields($Q){$Qd=(connection()->flavor=='maria');$G=array();foreach(get_rows("SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = ".q($Q)." ORDER BY ORDINAL_POSITION")as$H){$k=$H["COLUMN_NAME"];$T=$H["COLUMN_TYPE"];$Ec=$H["GENERATION_EXPRESSION"];$fc=$H["EXTRA"];preg_match('~^(VIRTUAL|PERSISTENT|STORED)~',$fc,$Dc);preg_match('~^([^( ]+)(?:\((.+)\))?( unsigned)?( zerofill)?$~',$T,$Td);$i=$H["COLUMN_DEFAULT"];if($i!=""){$wd=preg_match('~text|json~',$Td[1]);if(!$Qd&&$wd)$i=preg_replace("~^(_\w+)?('.*')$~",'\2',stripslashes($i));if($Qd||$wd){$i=($i=="NULL"?null:preg_replace_callback("~^'(.*)'$~",function($y){return
stripslashes(str_replace("''","'",$y[1]));},$i));}if(!$Qd&&preg_match('~binary~',$Td[1])&&preg_match('~^0x(\w*)$~',$i,$y))$i=pack("H*",$y[1]);}$G[$k]=array("field"=>$k,"full_type"=>$T,"type"=>$Td[1],"length"=>$Td[2],"unsigned"=>ltrim($Td[3].$Td[4]),"default"=>($Dc?($Qd?$Ec:stripslashes($Ec)):$i),"null"=>($H["IS_NULLABLE"]=="YES"),"auto_increment"=>($fc=="auto_increment"),"on_update"=>(preg_match('~\bon update (\w+)~i',$fc,$y)?$y[1]:""),"collation"=>$H["COLLATION_NAME"],"privileges"=>array_flip(explode(",","$H[PRIVILEGES],where,order")),"comment"=>$H["COLUMN_COMMENT"],"primary"=>($H["COLUMN_KEY"]=="PRI"),"generated"=>($Dc[1]=="PERSISTENT"?"STORED":$Dc[1]),);}return$G;}function
indexes($Q,$g=null){$G=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$g)as$H){$z=$H["Key_name"];$G[$z]["type"]=($z=="PRIMARY"?"PRIMARY":($H["Index_type"]=="FULLTEXT"?"FULLTEXT":($H["Non_unique"]?($H["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$G[$z]["columns"][]=$H["Column_name"];$G[$z]["lengths"][]=($H["Index_type"]=="SPATIAL"?null:$H["Sub_part"]);$G[$z]["descs"][]=null;$G[$z]["algorithm"]=$H["Index_type"];}return$G;}function
foreign_keys($Q){static$cf='(?:`(?:[^`]|``)+`|"(?:[^"]|"")+")';$G=array();$mb=get_val("SHOW CREATE TABLE ".table($Q),1);if($mb){preg_match_all("~CONSTRAINT ($cf) FOREIGN KEY ?\\(((?:$cf,? ?)+)\\) REFERENCES ($cf)(?:\\.($cf))? \\(((?:$cf,? ?)+)\\)(?: ON DELETE (".driver()->onActions."))?(?: ON UPDATE (".driver()->onActions."))?~",$mb,$Ud,PREG_SET_ORDER);foreach($Ud
as$y){preg_match_all("~$cf~",$y[2],$ag);preg_match_all("~$cf~",$y[5],$qg);$G[idf_unescape($y[1])]=array("db"=>idf_unescape($y[4]!=""?$y[3]:$y[4]),"table"=>idf_unescape($y[4]!=""?$y[4]:$y[3]),"source"=>array_map('Adminer\idf_unescape',$ag[0]),"target"=>array_map('Adminer\idf_unescape',$qg[0]),"on_delete"=>($y[6]?:"RESTRICT"),"on_update"=>($y[7]?:"RESTRICT"),);}}return$G;}function
view($z){return
array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\s+AS\s+~isU','',get_val("SHOW CREATE VIEW ".table($z),1)));}function
collations(){$G=array();foreach(get_rows("SHOW COLLATION")as$H){if($H["Default"])$G[$H["Charset"]][-1]=$H["Collation"];else$G[$H["Charset"]][]=$H["Collation"];}ksort($G);foreach($G
as$v=>$X)sort($G[$v]);return$G;}function
information_schema($h){return($h=="information_schema")||(min_version(5.5)&&$h=="performance_schema");}function
error(){return
h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",connection()->error));}function
create_database($h,$c){return
queries("CREATE DATABASE ".idf_escape($h).($c?" COLLATE ".q($c):""));}function
drop_databases(array$ub){$G=apply_queries("DROP DATABASE",$ub,'Adminer\idf_escape');restart_session();set_session("dbs",null);return$G;}function
rename_database($z,$c){$G=false;if(create_database($z,$c)){$S=array();$mh=array();foreach(tables_list()as$Q=>$T){if($T=='VIEW')$mh[]=$Q;else$S[]=$Q;}$G=(!$S&&!$mh)||move_tables($S,$mh,$z);drop_databases($G?array(DB):array());}return$G;}function
auto_increment(){$ta=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$t){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$t["columns"],true)){$ta="";break;}if($t["type"]=="PRIMARY")$ta=" UNIQUE";}}return" AUTO_INCREMENT$ta";}function
alter_table($Q,$z,array$l,array$vc,$Za,$Rb,$c,$sa,$Ze){$b=array();foreach($l
as$k){if($k[1]){$i=$k[1][3];if(preg_match('~ GENERATED~',$i)){$k[1][3]=(connection()->flavor=='maria'?"":$k[1][2]);$k[1][2]=$i;}$b[]=($Q!=""?($k[0]!=""?"CHANGE ".idf_escape($k[0]):"ADD"):" ")." ".implode($k[1]).($Q!=""?$k[2]:"");}else$b[]="DROP ".idf_escape($k[0]);}$b=array_merge($b,$vc);$O=($Za!==null?" COMMENT=".q($Za):"").($Rb?" ENGINE=".q($Rb):"").($c?" COLLATE ".q($c):"").($sa!=""?" AUTO_INCREMENT=$sa":"");if($Ze){$af=array();if($Ze["partition_by"]=='RANGE'||$Ze["partition_by"]=='LIST'){foreach($Ze["partition_names"]as$v=>$X){$Y=$Ze["partition_values"][$v];$af[]="\n  PARTITION ".idf_escape($X)." VALUES ".($Ze["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$O
.="\nPARTITION BY $Ze[partition_by]($Ze[partition])";if($af)$O
.=" (".implode(",",$af)."\n)";elseif($Ze["partitions"])$O
.=" PARTITIONS ".(+$Ze["partitions"]);}elseif($Ze===null)$O
.="\nREMOVE PARTITIONING";if($Q=="")return
queries("CREATE TABLE ".table($z)." (\n".implode(",\n",$b)."\n)$O");if($Q!=$z)$b[]="RENAME TO ".table($z);if($O)$b[]=ltrim($O);return($b?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$b)):true);}function
alter_indexes($Q,$b){$Ja=array();foreach($b
as$X)$Ja[]=($X[2]=="DROP"?"\nDROP INDEX ".idf_escape($X[1]):"\nADD $X[0] ".($X[0]=="PRIMARY"?"KEY ":"").($X[1]!=""?idf_escape($X[1])." ":"")."(".implode(", ",$X[2]).")");return
queries("ALTER TABLE ".table($Q).implode(",",$Ja));}function
truncate_tables(array$S){return
apply_queries("TRUNCATE TABLE",$S);}function
drop_views(array$mh){return
queries("DROP VIEW ".implode(", ",array_map('Adminer\table',$mh)));}function
drop_tables(array$S){return
queries("DROP TABLE ".implode(", ",array_map('Adminer\table',$S)));}function
move_tables(array$S,array$mh,$qg){$_f=array();foreach($S
as$Q)$_f[]=table($Q)." TO ".idf_escape($qg).".".table($Q);if(!$_f||queries("RENAME TABLE ".implode(", ",$_f))){$xb=array();foreach($mh
as$Q)$xb[table($Q)]=view($Q);connection()->select_db($qg);$h=idf_escape(DB);foreach($xb
as$z=>$lh){if(!queries("CREATE VIEW $z AS ".str_replace(" $h."," ",$lh["select"]))||!queries("DROP VIEW $h.$z"))return
false;}return
true;}return
false;}function
copy_tables(array$S,array$mh,$qg){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($S
as$Q){$z=($qg==DB?table("copy_$Q"):idf_escape($qg).".".table($Q));if(($_POST["overwrite"]&&!queries("\nDROP TABLE IF EXISTS $z"))||!queries("CREATE TABLE $z LIKE ".table($Q))||!queries("INSERT INTO $z SELECT * FROM ".table($Q)))return
false;foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$H){$Kg=$H["Trigger"];if(!queries("CREATE TRIGGER ".($qg==DB?idf_escape("copy_$Kg"):idf_escape($qg).".".idf_escape($Kg))." $H[Timing] $H[Event] ON $z FOR EACH ROW\n$H[Statement];"))return
false;}}foreach($mh
as$Q){$z=($qg==DB?table("copy_$Q"):idf_escape($qg).".".table($Q));$lh=view($Q);if(($_POST["overwrite"]&&!queries("DROP VIEW IF EXISTS $z"))||!queries("CREATE VIEW $z AS $lh[select]"))return
false;}return
true;}function
trigger($z,$Q){if($z=="")return
array();$I=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($z));return
reset($I);}function
triggers($Q){$G=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$H)$G[$H["Trigger"]]=array($H["Timing"],$H["Event"]);return$G;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
routine($z,$T){$l=get_rows("SELECT
	PARAMETER_NAME field,
	DATA_TYPE type,
	REGEXP_REPLACE(DTD_IDENTIFIER, '^[^(]+\\\\(?|\\\\)$', '') length,
	REGEXP_REPLACE(DTD_IDENTIFIER, '^[^ ]+ ', '') `unsigned`,
	1 `null`,
	DTD_IDENTIFIER full_type,
	PARAMETER_MODE `inout`,
	CHARACTER_SET_NAME collation
FROM information_schema.PARAMETERS
WHERE SPECIFIC_SCHEMA = DATABASE() AND ROUTINE_TYPE = '$T' AND SPECIFIC_NAME = ".q($z)."
ORDER BY ORDINAL_POSITION");$G=connection()->query("SELECT
	ROUTINE_COMMENT comment,
	CONCAT(IF(IS_DETERMINISTIC = 'YES', 'DETERMINISTIC\\n', ''), IF(SQL_DATA_ACCESS != 'CONTAINS SQL', CONCAT(SQL_DATA_ACCESS, '\\n'), ''), ROUTINE_DEFINITION) definition,
	'SQL' language
FROM information_schema.ROUTINES
WHERE ROUTINE_SCHEMA = DATABASE() AND ROUTINE_TYPE = '$T' AND ROUTINE_NAME = ".q($z))->fetch_assoc();if($l&&$l[0]['field']=='')$G['returns']=array_shift($l);$G['fields']=$l;return$G;}function
routines(){return
get_rows("SELECT SPECIFIC_NAME, ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = DATABASE()");}function
routine_languages(){return
array();}function
routine_id($z,array$H){return
idf_escape($z);}function
last_id($F){return
get_val("SELECT LAST_INSERT_ID()");}function
explain(Db$f,$E){return$f->query("EXPLAIN ".(min_version(5.1)&&!min_version(5.7)?"PARTITIONS ":"").$E);}function
found_rows(array$R,array$Z){return($Z||$R["Engine"]!="InnoDB"?null:$R["Rows"]);}function
create_sql($Q,$sa,$hg){$G=get_val("SHOW CREATE TABLE ".table($Q),1);if(!$sa)$G=preg_replace('~ AUTO_INCREMENT=\d+~','',$G);return$G;}function
truncate_sql($Q){return"TRUNCATE ".table($Q);}function
use_sql($tb,$hg=""){$z=idf_escape($tb);$G="";if(preg_match('~CREATE~',$hg)&&($lb=get_val("SHOW CREATE DATABASE $z",1))){set_utf8mb4($lb);if($hg=="DROP+CREATE")$G="DROP DATABASE IF EXISTS $z;\n";$G
.="$lb;\n";}return$G."USE $z";}function
trigger_sql($Q){$G="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$H)$G
.="\nCREATE TRIGGER ".idf_escape($H["Trigger"])." $H[Timing] $H[Event] ON ".table($H["Table"])." FOR EACH ROW\n$H[Statement];;\n";return$G;}function
show_variables(){return
get_rows("SHOW VARIABLES");}function
show_status(){return
get_rows("SHOW STATUS");}function
process_list(){return
get_rows("SHOW FULL PROCESSLIST");}function
convert_field(array$k){if(preg_match("~binary~",$k["type"]))return"HEX(".idf_escape($k["field"]).")";if($k["type"]=="bit")return"BIN(".idf_escape($k["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$k["type"]))return(min_version(8)?"ST_":"")."AsWKT(".idf_escape($k["field"]).")";}function
unconvert_field(array$k,$G){if(preg_match("~binary~",$k["type"]))$G="UNHEX($G)";if($k["type"]=="bit")$G="CONVERT(b$G, UNSIGNED)";if(preg_match("~geometry|point|linestring|polygon~",$k["type"])){$kf=(min_version(8)?"ST_":"");$G=$kf."GeomFromText($G, $kf"."SRID($k[field]))";}return$G;}function
support($ic){return
preg_match('~^(comment|columns|copy|database|drop_col|dump|indexes|kill|privileges|move_col|procedure|processlist|routine|sql|status|table|trigger|variables|view'.(min_version(5.1)?'|event':'').(min_version(8)?'|descidx':'').(min_version('8.0.16','10.2.1')?'|check':'').')$~',$ic);}function
kill_process($r){return
queries("KILL ".number($r));}function
connection_id(){return"SELECT CONNECTION_ID()";}function
max_connections(){return
get_val("SELECT @@max_connections");}function
types(){return
array();}function
type_values($r){return"";}function
schemas(){return
array();}function
get_schema(){return"";}function
set_schema($Hf,$g=null){return
true;}}define('Adminer\JUSH',Driver::$jush);define('Adminer\SERVER',"".$_GET[DRIVER]);define('Adminer\DB',"$_GET[db]");define('Adminer\ME',preg_replace('~\?.*~','',relative_uri()).'?'.(sid()?SID.'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').($_GET["ext"]?"ext=".urlencode($_GET["ext"]).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));function
page_header($zg,$j="",$Fa=array(),$_g=""){page_headers();if(is_ajax()&&$j){page_messages($j);exit;}if(!ob_get_level())ob_start('ob_gzhandler',4096);$Ag=$zg.($_g!=""?": $_g":"");$Bg=strip_tags($Ag.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".adminer()->name());echo'<!DOCTYPE html>
<html lang="en" dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="robots" content="noindex">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>',$Bg,'</title>
<link rel="stylesheet" href="',h(preg_replace("~\\?.*~","",ME)."?file=default.css&version=5.4.4"),'">
';$pb=adminer()->css();if(is_int(key($pb)))$pb=array_fill_keys($pb,'light');$Nc=in_array('light',$pb)||in_array('',$pb);$Kc=in_array('dark',$pb)||in_array('',$pb);$rb=($Nc?($Kc?null:false):($Kc?:null));$ce=" media='(prefers-color-scheme: dark)'";if($rb!==false)echo"<link rel='stylesheet'".($rb?"":$ce)." href='".h(preg_replace("~\\?.*~","",ME)."?file=dark.css&version=5.4.4")."'>\n";echo"<meta name='color-scheme' content='".($rb===null?"light dark":($rb?"dark":"light"))."'>\n",script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=5.4.4");if(adminer()->head($rb))echo"<link rel='icon' href='data:image/gif;base64,R0lGODlhEAAQAJEAAAQCBPz+/PwCBAROZCH5BAEAAAAALAAAAAAQABAAAAI2hI+pGO1rmghihiUdvUBnZ3XBQA7f05mOak1RWXrNq5nQWHMKvuoJ37BhVEEfYxQzHjWQ5qIAADs='>\n","<link rel='apple-touch-icon' href='".h(preg_replace("~\\?.*~","",ME)."?file=logo.png&version=5.4.4")."'>\n";foreach($pb
as$bh=>$ie){$qa=($ie=='dark'&&!$rb?$ce:($ie=='light'&&$Kc?" media='(prefers-color-scheme: light)'":""));echo"<link rel='stylesheet'$qa href='".h($bh)."'>\n";}echo"\n<body class='".'ltr'." nojs";adminer()->bodyClass();echo"'>\n";$m=get_temp_dir()."/adminer.version";echo
script("mixin(document.body, {onkeydown: bodyKeydown, onclick: bodyClick".(isset($_COOKIE["adminer_version"])?"":", onload: partial(verifyVersion, '".VERSION."')")."});
document.body.classList.replace('nojs', 'js');
const offlineMessage = '".js_escape('You are offline.')."';
const thousandsSeparator = '".js_escape(',')."';"),"<div id='help' class='jush-".JUSH." jsonly hidden'></div>\n",script("mixin(qs('#help'), {onmouseover: () => { helpOpen = 1; }, onmouseout: helpMouseout});"),"<div id='content'>\n","<span id='menuopen' class='jsonly'>".icon("move","","menu","")."</span>".script("qs('#menuopen').onclick = event => { qs('#foot').classList.toggle('foot'); event.stopPropagation(); }");if($Fa!==null){$x=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'<p id="breadcrumb"><a href="'.h($x?:".").'">'.get_driver(DRIVER).'</a> » ';$x=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$L=adminer()->serverName(SERVER);$L=($L!=""?$L:'Server');if($Fa===false)echo"$L\n";else{echo"<a href='".h($x)."' accesskey='1' title='Alt+Shift+1'>$L</a> » ";if($_GET["ns"]!=""||(DB!=""&&is_array($Fa)))echo'<a href="'.h($x."&db=".urlencode(DB).(support("scheme")?"&ns=":"")).'">'.h(DB).'</a> » ';if(is_array($Fa)){if($_GET["ns"]!="")echo'<a href="'.h(substr(ME,0,-1)).'">'.h($_GET["ns"]).'</a> » ';foreach($Fa
as$v=>$X){$zb=(is_array($X)?$X[1]:h($X));if($zb!="")echo"<a href='".h(ME."$v=").urlencode(is_array($X)?$X[0]:$X)."'>$zb</a> » ";}}echo"$zg\n";}}echo"<h2>$Ag</h2>\n","<div id='ajaxstatus' class='jsonly hidden'></div>\n";restart_session();page_messages($j);$ub=&get_session("dbs");if(DB!=""&&$ub&&!in_array(DB,$ub,true))$ub=null;stop_session();define('Adminer\PAGE_HEADER',1);}function
page_headers(){header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");header("X-Frame-Options: deny");header("X-XSS-Protection: 0");header("X-Content-Type-Options: nosniff");header("Referrer-Policy: origin-when-cross-origin");foreach(adminer()->csp(csp())as$ob){$Pc=array();foreach($ob
as$v=>$X)$Pc[]="$v $X";header("Content-Security-Policy: ".implode("; ",$Pc));}adminer()->headers();}function
csp(){return
array(array("script-src"=>"'self' 'unsafe-inline' 'nonce-".get_nonce()."' 'strict-dynamic'","connect-src"=>"'self' https://www.adminer.org","frame-src"=>"'none'","object-src"=>"'none'","base-uri"=>"'none'","form-action"=>"'self'",),);}function
get_nonce(){static$se;if(!$se)$se=base64_encode(rand_string());return$se;}function
page_messages($j){$ah=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$fe=idx($_SESSION["messages"],$ah);if($fe){echo"<div class='message'>".implode("</div>\n<div class='message'>",$fe)."</div>".script("messagesPrint();");unset($_SESSION["messages"][$ah]);}if($j)echo"<div class='error'>$j</div>\n";if(adminer()->error)echo"<div class='error'>".adminer()->error."</div>\n";}function
page_footer($he=""){echo"</div>\n\n<div id='foot' class='foot'>\n<div id='menu'>\n";adminer()->navigation($he);echo"</div>\n";if($he!="auth")echo'<form action="" method="post">
<p class="logout">
<span>',h($_GET["username"])."\n",'</span>
<input type="submit" name="logout" value="Logout" id="logout">
',input_token(),'</form>
';echo"</div>\n\n",script("setupSubmitHighlight(document);");}function
int32($ne){while($ne>=2147483648)$ne-=4294967296;while($ne<=-2147483649)$ne+=4294967296;return(int)$ne;}function
long2str(array$W,$oh){$Gf='';foreach($W
as$X)$Gf
.=pack('V',$X);if($oh)return
substr($Gf,0,end($W));return$Gf;}function
str2long($Gf,$oh){$W=array_values(unpack('V*',str_pad($Gf,4*ceil(strlen($Gf)/4),"\0")));if($oh)$W[]=strlen($Gf);return$W;}function
xxtea_mx($th,$sh,$kg,$_d){return
int32((($th>>5&0x7FFFFFF)^$sh<<2)+(($sh>>3&0x1FFFFFFF)^$th<<4))^int32(($kg^$sh)+($_d^$th));}function
encrypt_string($gg,$v){if($gg=="")return"";$v=array_values(unpack("V*",pack("H*",md5($v))));$W=str2long($gg,true);$ne=count($W)-1;$th=$W[$ne];$sh=$W[0];$qf=floor(6+52/($ne+1));$kg=0;while($qf-->0){$kg=int32($kg+0x9E3779B9);$Jb=$kg>>2&3;for($Se=0;$Se<$ne;$Se++){$sh=$W[$Se+1];$me=xxtea_mx($th,$sh,$kg,$v[$Se&3^$Jb]);$th=int32($W[$Se]+$me);$W[$Se]=$th;}$sh=$W[0];$me=xxtea_mx($th,$sh,$kg,$v[$Se&3^$Jb]);$th=int32($W[$ne]+$me);$W[$ne]=$th;}return
long2str($W,false);}function
decrypt_string($gg,$v){if($gg=="")return"";if(!$v)return
false;$v=array_values(unpack("V*",pack("H*",md5($v))));$W=str2long($gg,false);$ne=count($W)-1;$th=$W[$ne];$sh=$W[0];$qf=floor(6+52/($ne+1));$kg=int32($qf*0x9E3779B9);while($kg){$Jb=$kg>>2&3;for($Se=$ne;$Se>0;$Se--){$th=$W[$Se-1];$me=xxtea_mx($th,$sh,$kg,$v[$Se&3^$Jb]);$sh=int32($W[$Se]-$me);$W[$Se]=$sh;}$th=$W[$ne];$me=xxtea_mx($th,$sh,$kg,$v[$Se&3^$Jb]);$sh=int32($W[0]-$me);$W[0]=$sh;$kg=int32($kg-0x9E3779B9);}return
long2str($W,true);}$ef=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($v)=explode(":",$X);$ef[$v]=$X;}}function
add_invalid_login(){$za=get_temp_dir()."/adminer-invalid";foreach(glob("$za*")?:array($za)as$m){$o=file_open_lock($m);if($o)break;}if(!$o)$o=file_open_lock("$za-".rand_string());if(!$o)return;$sd=json_decode(stream_get_contents($o),true);$wg=time();if($sd){foreach($sd
as$td=>$X){if($X[0]<$wg)unset($sd[$td]);}}$rd=&$sd[adminer()->bruteForceKey()];if(!$rd)$rd=array($wg+30*60,0);$rd[1]++;file_write_unlock($o,json_encode($sd));}function
check_invalid_login(array&$ef){$sd=array();foreach(glob(get_temp_dir()."/adminer-invalid*")as$m){$o=file_open_lock($m);if($o){$sd=json_decode(stream_get_contents($o),true);file_unlock($o);break;}}$rd=idx($sd,adminer()->bruteForceKey(),array());$re=($rd[1]>29?$rd[0]-time():0);if($re>0)auth_error(lang_format(array('Too many unsuccessful logins, try again in %d minute.','Too many unsuccessful logins, try again in %d minutes.'),ceil($re/60)),$ef);}$ra=$_POST["auth"];if($ra){session_regenerate_id();$jh=$ra["driver"];$L=$ra["server"];$V=$ra["username"];$B=(string)$ra["password"];$h=$ra["db"];set_password($jh,$L,$V,$B);$_SESSION["db"][$jh][$L][$V][$h]=true;if($ra["permanent"]){$v=implode("-",array_map('base64_encode',array($jh,$L,$V,$h)));$of=adminer()->permanentLogin(true);$ef[$v]="$v:".base64_encode($of?encrypt_string($B,$of):"");cookie("adminer_permanent",implode(" ",$ef));}if(count($_POST)==1||DRIVER!=$jh||SERVER!=$L||$_GET["username"]!==$V||DB!=$h)redirect(auth_url($jh,$L,$V,$h));}elseif($_POST["logout"]&&(!$_SESSION["token"]||verify_token())){foreach(array("pwds","db","dbs","queries")as$v)set_session($v,null);unset_permanent($ef);redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),'Logout successful.'.' '.'Thanks for using Adminer, consider <a href="https://www.adminer.org/en/donation/">donating</a>.');}elseif($ef&&!$_SESSION["pwds"]){session_regenerate_id();$of=adminer()->permanentLogin();foreach($ef
as$v=>$X){list(,$Pa)=explode(":",$X);list($jh,$L,$V,$h)=array_map('base64_decode',explode("-",$v));set_password($jh,$L,$V,decrypt_string(base64_decode($Pa),$of));$_SESSION["db"][$jh][$L][$V][$h]=true;}}function
unset_permanent(array&$ef){foreach($ef
as$v=>$X){list($jh,$L,$V,$h)=array_map('base64_decode',explode("-",$v));if($jh==DRIVER&&$L==SERVER&&$V==$_GET["username"]&&$h==DB)unset($ef[$v]);}cookie("adminer_permanent",implode(" ",$ef));}function
auth_error($j,array&$ef){$Uf=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$Uf]||$_GET[$Uf])&&!$_SESSION["token"])$j='Session expired, please login again.';else{restart_session();add_invalid_login();$B=get_password();if($B!==null){if($B===false)$j
.=($j?'<br>':'').sprintf('Master password expired. <a href="https://www.adminer.org/en/extension/"%s>Implement</a> %s method to make it permanent.',target_blank(),'<code>permanentLogin()</code>');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent($ef);}}if(!$_COOKIE[$Uf]&&$_GET[$Uf]&&ini_bool("session.use_only_cookies"))$j='Session support must be enabled.';$Ve=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?:rand_string()),$Ve["lifetime"]);if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);page_header('Login',$j,null);echo"<form action='' method='post'>\n","<div>";if(hidden_fields($_POST,array("auth")))echo"<p class='message'>".'The action will be performed after successful login with the same credentials.'."\n";echo"</div>\n";adminer()->loginForm();echo"</form>\n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists('Adminer\Db')){unset($_SESSION["pwds"][DRIVER]);unset_permanent($ef);page_header('No extension',sprintf('None of the supported PHP extensions (%s) are available.',implode(", ",Driver::$extensions)),false);page_footer("auth");exit;}$f='';if(isset($_GET["username"])&&is_string(get_password())){list($Vc,$C)=host_port(SERVER);if(!preg_match('~^[-a-z0-9.:]*$~i',$Vc))auth_error('Invalid server.',$ef);if(preg_match('~^\s*([-+]?\d+)~',$C,$y)&&($y[1]<1024||$y[1]>65535))auth_error('Connecting to privileged ports is not allowed.',$ef);check_invalid_login($ef);$nb=adminer()->credentials();$f=Driver::connect($nb[0],$nb[1],$nb[2]);if(is_object($f)){Db::$instance=$f;Driver::$instance=new
Driver($f);if($f->flavor)save_settings(array("vendor-".DRIVER."-".SERVER=>get_driver(DRIVER)));}}$Od=null;if(!is_object($f)||($Od=adminer()->login($_GET["username"],get_password()))!==true){$j=(is_string($f)?nl_br(h($f)):(is_string($Od)?$Od:'Invalid credentials.')).(preg_match('~^ | $~',get_password())?'<br>'.'There is a space in the input password which might be the cause.':'');auth_error($j,$ef);}if($_POST["logout"]&&$_SESSION["token"]&&!verify_token()){page_header('Logout','Invalid CSRF token. Send the form again.');page_footer("db");exit;}if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);stop_session(true);if($ra&&$_POST["token"])$_POST["token"]=get_token();$j='';if($_POST){if(!verify_token()){$ld="max_input_vars";$ae=ini_get($ld);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$v){$X=ini_get($v);if($X&&(!$ae||$X<$ae)){$ld=$v;$ae=$X;}}}$j=(!$_POST["token"]&&$ae?sprintf('Maximum number of allowed fields exceeded. Please increase %s.',"'$ld'"):'Invalid CSRF token. Send the form again.'.' '.'If you did not send this request from Adminer then close this page.');}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$j=sprintf('Too big POST data. Reduce the data or increase the %s configuration directive.',"'post_max_size'");if(isset($_GET["sql"]))$j
.=' '.'You can upload a big SQL file via FTP and import it from server.';}function
doc_link(array$bf,$sg=""){return"";}function
email_header($Pc){return"=?UTF-8?B?".base64_encode($Pc)."?=";}function
send_mail($Nb,$ig,$ee,$Ac="",array$mc=array()){$Vb=PHP_EOL;$ee=str_replace("\n",$Vb,wordwrap(str_replace("\r","","$ee\n")));$Ea=uniqid("boundary");$pa="";foreach((array)$mc["error"]as$v=>$X){if(!$X)$pa
.="--$Ea$Vb"."Content-Type: ".str_replace("\n","",$mc["type"][$v]).$Vb."Content-Disposition: attachment; filename=\"".preg_replace('~["\n]~','',$mc["name"][$v])."\"$Vb"."Content-Transfer-Encoding: base64$Vb$Vb".chunk_split(base64_encode(file_get_contents($mc["tmp_name"][$v])),76,$Vb).$Vb;}$Aa="";$Qc="Content-Type: text/plain; charset=utf-8$Vb"."Content-Transfer-Encoding: 8bit";if($pa){$pa
.="--$Ea--$Vb";$Aa="--$Ea$Vb$Qc$Vb$Vb";$Qc="Content-Type: multipart/mixed; boundary=\"$Ea\"";}$Qc
.=$Vb."MIME-Version: 1.0$Vb"."X-Mailer: Adminer Editor".($Ac?$Vb."From: ".str_replace("\n","",$Ac):"");return
mail($Nb,email_header($ig),$Aa.$ee.$pa,$Qc);}function
like_bool(array$k){return$k["type"]=="bool"||(preg_match('~bit|tinyint~',$k["type"])&&$k["length"]==1);}connection()->select_db(adminer()->database());if(support("scheme"))set_schema(get_schema());adminer()->afterConnect();add_driver(DRIVER,'Login');if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["download"])){$a=$_GET["download"];$l=fields($a);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$a-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$J=array(idf_escape($_GET["field"]));$F=driver()->select($a,$J,array(where($_GET,$l)),$J);$H=($F?$F->fetch_row():array());echo
driver()->value($H[0],$l[$_GET["field"]]);exit;}elseif(isset($_GET["edit"])){$a=$_GET["edit"];$l=fields($a);$Z=(isset($_GET["select"])?($_POST["check"]&&count($_POST["check"])==1?where_check($_POST["check"][0],$l):""):where($_GET,$l));$U=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($l
as$z=>$k){if((!$U&&!isset($k["privileges"]["insert"]))||adminer()->fieldName($k)=="")unset($l[$z]);}if($_POST&&!$j&&!isset($_GET["select"])){$Nd=$_POST["referer"];if($_POST["insert"])$Nd=($U?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$Nd))$Nd=ME."select=".urlencode($a);$u=indexes($a);$Tg=unique_array($_GET["where"],$u);$tf="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($Nd,'Item has been deleted.',driver()->delete($a,$tf,$Tg?0:1));else{$M=array();foreach($l
as$z=>$k){$X=process_input($k);if($X!==false&&$X!==null)$M[idf_escape($z)]=$X;}if($U){if(!$M)redirect($Nd);queries_redirect($Nd,'Item has been updated.',driver()->update($a,$M,$tf,$Tg?0:1));if(is_ajax()){page_headers();page_messages($j);exit;}}else{$F=driver()->insert($a,$M);$Hd=($F?last_id($F):0);queries_redirect($Nd,sprintf('Item%s has been inserted.',($Hd?" $Hd":"")),$F);}}}$H=null;if($Z){$J=array();foreach($l
as$z=>$k){if(isset($k["privileges"]["select"])){$na=($_POST["clone"]&&$k["auto_increment"]?"''":convert_field($k));$J[]=($na?"$na AS ":"").idf_escape($z);}}$H=array();if(!support("table"))$J=array("*");if($J){$F=driver()->select($a,$J,array($Z),$J,array(),(isset($_GET["select"])?2:1));if(!$F)$j=error();else{$H=$F->fetch_assoc();if(!$H)$H=false;}if(isset($_GET["select"])&&(!$H||$F->fetch_assoc()))$H=null;}}if(!support("table")&&!$l){if(!$Z){$F=driver()->select($a,array("*"),array(),array("*"));$H=($F?$F->fetch_assoc():false);if(!$H)$H=array(driver()->primary=>"");}if($H){foreach($H
as$v=>$X){if(!$Z)$H[$v]=null;$l[$v]=array("field"=>$v,"null"=>($v!=driver()->primary),"auto_increment"=>($v==driver()->primary));}}}if($_POST["save"])$H=(array)$_POST["fields"]+($H?$H:array());edit_form($a,$l,$H,$U,$j);}elseif(isset($_GET["select"])){$a=$_GET["select"];$R=table_status1($a);$u=indexes($a);$l=fields($a);$yc=column_foreign_keys($a);$ze=$R["Oid"];$ga=get_settings("adminer_import");$Ef=array();$e=array();$Kf=array();$Ke=array();$ug="";foreach($l
as$v=>$k){$z=adminer()->fieldName($k);$oe=html_entity_decode(strip_tags($z),ENT_QUOTES);if(isset($k["privileges"]["select"])&&$z!=""){$e[$v]=$oe;if(is_shortable($k))$ug=adminer()->selectLengthProcess();}if(isset($k["privileges"]["where"])&&$z!="")$Kf[$v]=$oe;if(isset($k["privileges"]["order"])&&$z!="")$Ke[$v]=$oe;$Ef+=$k["privileges"];}list($J,$Fc)=adminer()->selectColumnsProcess($e,$u);$J=array_unique($J);$Fc=array_unique($Fc);$ud=count($Fc)<count($J);$Z=adminer()->selectSearchProcess($l,$u);$Je=adminer()->selectOrderProcess($l,$u);$w=adminer()->selectLimitProcess();if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$Ug=>$H){$na=convert_field($l[key($H)]);$J=array($na?:idf_escape(key($H)));$Z[]=where_check($Ug,$l);$G=driver()->select($a,$J,$Z,$J);if($G)echo
first($G->fetch_row());}exit;}$D=$Wg=array();foreach($u
as$t){if($t["type"]=="PRIMARY"){$D=array_flip($t["columns"]);$Wg=($J?$D:array());foreach($Wg
as$v=>$X){if(in_array(idf_escape($v),$J))unset($Wg[$v]);}break;}}if($ze&&!$D){$D=$Wg=array($ze=>0);$u[]=array("type"=>"PRIMARY","columns"=>array($ze));}if($_POST&&!$j){$qh=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Oa=array();foreach($_POST["check"]as$La)$Oa[]=where_check($La,$l);$qh[]="((".implode(") OR (",$Oa)."))";}$qh=($qh?"\nWHERE ".implode(" AND ",$qh):"");if($_POST["export"]){save_settings(array("output"=>$_POST["output"],"format"=>$_POST["format"]),"adminer_import");dump_headers($a);adminer()->dumpTable($a,"");$Ac=($J?implode(", ",$J):"*").convert_fields($e,$l,$J)."\nFROM ".table($a);$Hc=($Fc&&$ud?"\nGROUP BY ".implode(", ",$Fc):"").($Je?"\nORDER BY ".implode(", ",$Je):"");$E="SELECT $Ac$qh$Hc";if(is_array($_POST["check"])&&!$D){$Sg=array();foreach($_POST["check"]as$X)$Sg[]="(SELECT".limit($Ac,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$l).$Hc,1).")";$E=implode(" UNION ALL ",$Sg);}adminer()->dumpData($a,"table",$E);adminer()->dumpFooter();exit;}if(!adminer()->selectEmailProcess($Z,$yc)){if($_POST["save"]||$_POST["delete"]){$F=true;$ha=0;$M=array();if(!$_POST["delete"]){foreach($l
as$z=>$X){$s=bracket_escape($z);if(isset($_POST["fields"][$s])||$_FILES["fields-$s"]){$X=process_input($l[$z]);if($X!==null&&($_POST["clone"]||$X!==false))$M[idf_escape($z)]=($X!==false?$X:idf_escape($z));}}}if($_POST["delete"]||$M){$E=($_POST["clone"]?"INTO ".table($a)." (".implode(", ",array_keys($M)).")\nSELECT ".implode(", ",$M)."\nFROM ".table($a):"");if($_POST["all"]||($D&&is_array($_POST["check"]))||$ud){$F=($_POST["delete"]?driver()->delete($a,$qh):($_POST["clone"]?queries("INSERT $E$qh".driver()->insertReturning($a)):driver()->update($a,$M,$qh)));$ha=connection()->affected_rows;if(is_object($F))$ha+=$F->num_rows;}else{foreach((array)$_POST["check"]as$X){$ph="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$l);$F=($_POST["delete"]?driver()->delete($a,$ph,1):($_POST["clone"]?queries("INSERT".limit1($a,$E,$ph)):driver()->update($a,$M,$ph,1)));if(!$F)break;$ha+=connection()->affected_rows;}}}$ee=lang_format(array('%d item has been affected.','%d items have been affected.'),$ha);if($_POST["clone"]&&$F&&$ha==1){$Hd=last_id($F);if($Hd)$ee=sprintf('Item%s has been inserted.'," $Hd");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$ee,$F);if(!$_POST["delete"]){$if=(array)$_POST["fields"];edit_form($a,array_intersect_key($l,$if),$if,!$_POST["clone"],$j);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$j='Ctrl+click on a value to modify it.';else{$F=true;$ha=0;foreach($_POST["val"]as$Ug=>$H){$M=array();foreach($H
as$v=>$X){$v=bracket_escape($v,true);$M[idf_escape($v)]=(preg_match('~char|text~',$l[$v]["type"])||$X!=""?adminer()->processInput($l[$v],$X):"NULL");}$F=driver()->update($a,$M," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($Ug,$l),($ud||$D?0:1)," ");if(!$F)break;$ha+=connection()->affected_rows;}queries_redirect(remove_from_uri(),lang_format(array('%d item has been affected.','%d items have been affected.'),$ha),$F);}}elseif(!is_string($lc=get_file("csv_file",true)))$j=upload_error($lc);elseif(!preg_match('~~u',$lc))$j='File must be in UTF-8 encoding.';else{save_settings(array("output"=>$ga["output"],"format"=>$_POST["separator"]),"adminer_import");$F=true;$Wa=array_keys($l);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$lc,$Ud);$ha=count($Ud[0]);driver()->begin();$K=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$I=array();foreach($Ud[0]as$v=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$K]*)$K~",$X.$K,$Vd);if(!$v&&!array_diff($Vd[1],$Wa)){$Wa=$Vd[1];$ha--;}else{$M=array();foreach($Vd[1]as$q=>$Ua)$M[idf_escape($Wa[$q])]=($Ua==""&&$l[$Wa[$q]]["null"]?"NULL":q(preg_match('~^".*"$~s',$Ua)?str_replace('""','"',substr($Ua,1,-1)):$Ua));$I[]=$M;}}$F=(!$I||driver()->insertUpdate($a,$I,$D));if($F)driver()->commit();queries_redirect(remove_from_uri("page"),lang_format(array('%d row has been imported.','%d rows have been imported.'),$ha),$F);driver()->rollback();}}}$og=adminer()->tableName($R);if(is_ajax()){page_headers();ob_start();}else
page_header('Select'.": $og",$j);$M=null;if(isset($Ef["insert"])||!support("table")){$Ve=array();foreach((array)$_GET["where"]as$X){if(isset($yc[$X["col"]])&&count($yc[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&(is_array($X["val"])||!preg_match('~[_%]~',$X["val"])))))$Ve["set"."[".bracket_escape($X["col"])."]"]=$X["val"];}$M=$Ve?"&".http_build_query($Ve):"";}adminer()->selectLinks($R,$M);if(!$e&&support("table"))echo"<p class='error'>".'Unable to select the table'.($l?".":": ".error())."\n";else{echo"<form action='' id='form'>\n","<div style='display: none;'>";hidden_fields_get();echo(DB!=""?input_hidden("db",DB).(isset($_GET["ns"])?input_hidden("ns",$_GET["ns"]):""):""),input_hidden("select",$a),"</div>\n";adminer()->selectColumnsPrint($J,$e);adminer()->selectSearchPrint($Z,$Kf,$u);adminer()->selectOrderPrint($Je,$Ke,$u);adminer()->selectLimitPrint($w);adminer()->selectLengthPrint($ug);adminer()->selectActionPrint($u);echo"</form>\n";$A=$_GET["page"];$_c=null;if($A=="last"){$_c=get_val(count_rows($a,$Z,$ud,$Fc));$A=floor(max(0,intval($_c)-1)/$w);}$Lf=$J;$Gc=$Fc;if(!$Lf){$Lf[]="*";$jb=convert_fields($e,$l,$J);if($jb)$Lf[]=substr($jb,2);}foreach($J
as$v=>$X){$k=$l[idf_unescape($X)];if($k&&($na=convert_field($k)))$Lf[$v]="$na AS $X";}if(!$ud&&$Wg){foreach($Wg
as$v=>$X){$Lf[]=idf_escape($v);if($Gc)$Gc[]=idf_escape($v);}}$F=driver()->select($a,$Lf,$Z,$Gc,$Je,$w,$A,true);if(!$F)echo"<p class='error'>".error()."\n";else{if(JUSH=="mssql"&&$A)$F->seek($w*$A);$Pb=array();echo"<form action='' method='post' enctype='multipart/form-data'>\n";$I=array();while($H=$F->fetch_assoc()){if($A&&JUSH=="oracle")unset($H["RNUM"]);$I[]=$H;}if($_GET["page"]!="last"&&$w&&$Fc&&$ud&&JUSH=="sql")$_c=get_val(" SELECT FOUND_ROWS()");if(!$I)echo"<p class='message'>".'No rows.'."\n";else{$ya=adminer()->backwardKeys($a,$og);echo"<div class='scrollable'>","<table id='table' class='nowrap checkable odds'>",script("mixin(qs('#table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true), onkeydown: editingKeydown});"),"<thead><tr>".(!$Fc&&$J?"":"<td><input type='checkbox' id='all-page' class='jsonly'>".script("qs('#all-page').onclick = partial(formCheck, /check/);","")." <a href='".h($_GET["modify"]?remove_from_uri("modify"):$_SERVER["REQUEST_URI"]."&modify=1")."'>".'Modify'."</a>");$pe=array();$Cc=array();reset($J);$vf=1;foreach($I[0]as$v=>$X){if(!isset($Wg[$v])){$X=idx($_GET["columns"],key($J))?:array();$k=$l[$J?($X?$X["col"]:current($J)):$v];$z=($k?adminer()->fieldName($k,$vf):($X["fun"]?"*":h($v)));if($z!=""){$vf++;$pe[$v]=$z;$d=idf_escape($v);$Wc=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($v);$zb="&desc%5B0%5D=1";echo"<th id='th[".h(bracket_escape($v))."]'>".script("mixin(qsl('th'), {onmouseover: partial(columnMouse), onmouseout: partial(columnMouse, ' hidden')});","");$Bc=apply_sql_function($X["fun"],$z);$Zf=isset($k["privileges"]["order"])||$Bc!=$z;echo($Zf?"<a href='".h($Wc.($Je[0]==$d||$Je[0]==$v?$zb:''))."'>$Bc</a>":$Bc);$de=($Zf?"<a href='".h($Wc.$zb)."' title='".'descending'."' class='text'> ↓</a>":'');if(!$X["fun"]&&isset($k["privileges"]["where"])){$de
.='<a href="#fieldset-search" title="'.'Search'.'" class="text jsonly"> =</a>';$de
.=script("qsl('a').onclick = partial(selectSearch, '".js_escape($v)."');");}echo($de?"<span class='column hidden'>$de</span>":"");}$Cc[$v]=$X["fun"];next($J);}}$Kd=array();if($_GET["modify"]){foreach($I
as$H){foreach($H
as$v=>$X)$Kd[$v]=max($Kd[$v],min(40,strlen(utf8_decode($X))));}}echo($ya?"<th>".'Relations':"")."</thead>\n";if(is_ajax())ob_end_clean();foreach(adminer()->rowDescriptions($I,$yc)as$ne=>$H){$Tg=unique_array($I[$ne],$u);if(!$Tg){$Tg=array();reset($J);foreach($I[$ne]as$v=>$X){if(!preg_match('~^(COUNT|AVG|GROUP_CONCAT|MAX|MIN|SUM)\(~',current($J)))$Tg[$v]=$X;next($J);}}$Ug="";foreach($Tg
as$v=>$X){$k=(array)$l[$v];if((JUSH=="sql"||JUSH=="pgsql")&&preg_match('~char|text|enum|set~',$k["type"])&&strlen($X)>64){$v=(strpos($v,'(')?$v:idf_escape($v));$v="MD5(".(JUSH!='sql'||preg_match("~^utf8~",$k["collation"])?$v:"CONVERT($v USING ".charset(connection()).")").")";$X=md5($X);}$Ug
.="&".($X!==null?urlencode("where[".bracket_escape($v)."]")."=".urlencode($X===false?"f":$X):"null%5B%5D=".urlencode($v));}echo"<tr>".(!$Fc&&$J?"":"<td>".checkbox("check[]",substr($Ug,1),in_array(substr($Ug,1),(array)$_POST["check"])).($ud||information_schema(DB)?"":" <a href='".h(ME."edit=".urlencode($a).$Ug)."' class='edit'>".'edit'."</a>"));reset($J);foreach($H
as$v=>$X){if(isset($pe[$v])){$d=current($J);$k=(array)$l[$v];if($X!=""&&(!isset($Pb[$v])||$Pb[$v]!=""))$Pb[$v]=(is_mail($X)?$pe[$v]:"");$x="";if(is_blob($k)&&$X!="")$x=ME.'download='.urlencode($a).'&field='.urlencode($v).$Ug;if(!$x&&$X!==null){foreach((array)$yc[$v]as$n){if(count($yc[$v])==1||end($n["source"])==$v){$x="";foreach($n["source"]as$q=>$ag)$x
.=where_link($q,$n["target"][$q],$I[$ne][$ag]);$x=($n["db"]!=""?preg_replace('~([?&]db=)[^&]+~','\1'.urlencode($n["db"]),ME):ME).'select='.urlencode($n["table"]).$x;if($n["ns"])$x=preg_replace('~([?&]ns=)[^&]+~','\1'.urlencode($n["ns"]),$x);if(count($n["source"])==1)break;}}}if($d=="COUNT(*)"){$x=ME."select=".urlencode($a);$q=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$Tg))$x
.=where_link($q++,$W["col"],$W["val"],$W["op"]);}foreach($Tg
as$_d=>$W)$x
.=where_link($q++,$_d,$W);}$Xc=select_value($X,$x,$k,$ug);$r=h("val[$Ug][".bracket_escape($v)."]");$jf=idx(idx($_POST["val"],$Ug),bracket_escape($v));$U=idx($k["privileges"],"update");$Lb=!is_array($H[$v])&&is_utf8($Xc)&&$I[$ne][$v]==$H[$v]&&!$Cc[$v]&&!$k["generated"]&&$U;$T=(preg_match('~^(AVG|MIN|MAX)\((.+)\)~',$d,$y)?$l[idf_unescape($y[2])]["type"]:$k["type"]);$sg=preg_match('~text|json|lob~',$T);$vd=preg_match(number_type(),$T)||preg_match('~^(CHAR_LENGTH|ROUND|FLOOR|CEIL|TIME_TO_SEC|COUNT|SUM)\(~',$d);echo"<td id='$r'".($vd&&($X===null||is_numeric(strip_tags($Xc))||$T=="money")?" class='number'":"");if(($_GET["modify"]&&$Lb&&$X!==null)||$jf!==null){$Jc=h($jf!==null?$jf:$H[$v]);echo">".($sg?"<textarea name='$r' cols='30' rows='".(substr_count($H[$v],"\n")+1)."'>$Jc</textarea>":"<input name='$r' value='$Jc' size='$Kd[$v]'>");}else{$Pd=strpos($Xc,"<i>…</i>");echo($U?" data-text='".($Pd?2:($sg?1:0))."'".($Lb?"":" data-warning='".h('Use edit link to modify this value.')."'"):"").">$Xc";}}next($J);}if($ya)echo"<td>";adminer()->backwardKeysPrint($ya,$I[$ne]);echo"</tr>\n";}if(is_ajax())exit;echo"</table>\n","</div>\n";}if(!is_ajax()){if($I||$A){$ac=true;if($_GET["page"]!="last"){if(!$w||(count($I)<$w&&($I||!$A)))$_c=($A?$A*$w:0)+count($I);elseif(JUSH!="sql"||!$ud){$_c=($ud?false:found_rows($R,$Z));if(intval($_c)<max(1e4,2*($A+1)*$w))$_c=first(slow_query(count_rows($a,$Z,$ud,$Fc)));elseif(JUSH=='sql'||JUSH=='pgsql')$ac=false;}}$Te=($w&&($_c===false||$_c>$w||$A));if($Te)echo(($_c===false?count($I)+1:$_c-$A*$w)>$w?'<p><a href="'.h(remove_from_uri("page")."&page=".($A+1)).'" class="loadmore">'.'Load more data'.'</a>'.script("qsl('a').onclick = partial(selectLoadMore, $w, '".'Loading'."…');",""):''),"\n";echo"<div class='footer'><div>\n";if($Te){$Yd=($_c===false?$A+(count($I)>=$w?2:1):floor(($_c-1)/$w));echo"<fieldset>";if(JUSH!="simpledb"){echo"<legend><a href='".h(remove_from_uri("page"))."'>".'Page'."</a></legend>",script("qsl('a').onclick = function () { pageClick(this.href, +prompt('".'Page'."', '".($A+1)."')); return false; };"),pagination(0,$A).($A>5?" …":"");for($q=max(1,$A-4);$q<min($Yd,$A+5);$q++)echo
pagination($q,$A);if($Yd>0)echo($A+5<$Yd?" …":""),($ac&&$_c!==false?pagination($Yd,$A):" <a href='".h(remove_from_uri("page")."&page=last")."' title='~$Yd'>".'last'."</a>");}else
echo"<legend>".'Page'."</legend>",pagination(0,$A).($A>1?" …":""),($A?pagination($A,$A):""),($Yd>$A?pagination($A+1,$A).($Yd>$A+1?" …":""):"");echo"</fieldset>\n";}echo"<fieldset>","<legend>".'Whole result'."</legend>";$Cb=($ac?"":"~ ").$_c;$De="const checked = formChecked(this, /check/); selectCount('selected', this.checked ? '$Cb' : checked); selectCount('selected2', this.checked || !checked ? '$Cb' : checked);";echo
checkbox("all",1,0,($_c!==false?($ac?"":"~ ").lang_format(array('%d row','%d rows'),$_c):""),$De)."\n","</fieldset>\n";if(adminer()->selectCommandPrint())echo'<fieldset',($_GET["modify"]?'':' class="jsonly"'),'><legend>Modify</legend><div>
<input type="submit" value="Save"',($_GET["modify"]?'':' title="'.'Ctrl+click on a value to modify it.'.'"'),'>
</div></fieldset>
<fieldset><legend>Selected <span id="selected"></span></legend><div>
<input type="submit" name="edit" value="Edit">
<input type="submit" name="clone" value="Clone">
<input type="submit" name="delete" value="Delete">',confirm(),'</div></fieldset>
';$zc=adminer()->dumpFormat();foreach((array)$_GET["columns"]as$d){if($d["fun"]){unset($zc['sql']);break;}}if($zc){print_fieldset("export",'Export'." <span id='selected2'></span>");$Qe=adminer()->dumpOutput();echo($Qe?html_select("output",$Qe,$ga["output"])." ":""),html_select("format",$zc,$ga["format"])," <input type='submit' name='export' value='".'Export'."'>\n","</div></fieldset>\n";}adminer()->selectEmailPrint(array_filter($Pb,'strlen'),$e);echo"</div></div>\n";}if(adminer()->selectImportPrint())echo"<p>","<a href='#import'>".'Import'."</a>",script("qsl('a').onclick = partial(toggle, 'import');",""),"<span id='import'".($_POST["import"]?"":" class='hidden'").">: ",file_input("<input type='file' name='csv_file'> ".html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$ga["format"])." <input type='submit' name='import' value='".'Import'."'>"),"</span>";echo
input_token(),"</form>\n",(!$Fc&&$J?"":script("tableCheck();"));}}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["script"])){if($_GET["script"]=="kill")connection()->query("KILL ".number($_POST["kill"]));elseif(list($Q,$r,$z)=adminer()->_foreignColumn(column_foreign_keys($_GET["source"]),$_GET["field"])){$w=11;$F=connection()->query("SELECT $r, $z FROM ".table($Q)." WHERE ".(preg_match('~^[0-9]+$~',$_GET["value"])?"$r = $_GET[value] OR ":"")."$z LIKE ".q("$_GET[value]%")." ORDER BY 2 LIMIT $w");for($q=1;($H=$F->fetch_row())&&$q<$w;$q++)echo"<a href='".h(ME."edit=".urlencode($Q)."&where".urlencode("[".bracket_escape(idf_unescape($r))."]")."=".urlencode($H[0]))."'>".h($H[1])."</a><br>\n";if($H)echo"...\n";}exit;}else{page_header('Server',"",false);if(adminer()->homepage()){echo"<form action='' method='post'>\n","<p>".'Search data in tables'.": <input type='search' name='query' value='".h($_POST["query"])."'> <input type='submit' value='".'Search'."'>\n";if($_POST["query"]!="")search_tables();echo"<div class='scrollable'>\n","<table class='nowrap checkable odds'>\n",script("mixin(qsl('table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true)});"),'<thead><tr class="wrap">','<td><input id="check-all" type="checkbox" class="jsonly">'.script("qs('#check-all').onclick = partial(formCheck, /^tables\[/);",""),'<th>'.'Table','<td>'.'Rows',"</thead>\n";foreach(table_status()as$Q=>$H){$z=adminer()->tableName($H);if($z!=""){echo'<tr><td>'.checkbox("tables[]",$Q,in_array($Q,(array)$_POST["tables"],true)),"<th><a href='".h(ME).'select='.urlencode($Q)."'>$z</a>";$X=format_number($H["Rows"]);echo"<td align='right'><a href='".h(ME."edit=").urlencode($Q)."'>".($H["Engine"]=="InnoDB"&&$X?"~ $X":$X)."</a>";}}echo"</table>\n","</div>\n","</form>\n",script("tableCheck();");adminer()->pluginsLinks();}}page_footer();