yFqH7ҵ\\Y;H3B7\"1*ʶ b\n B8҉^@:&[PA(Ȗ5F˚TDԖ#pHHA R[MN1Cl\$i(0B`ҋ:XPbt\"悌p cV#1V\nu5O\n\"ũFYx70\rX S%RsB~\"%BD^6fD|G7 \rΡ7 Ʞ.e,,p";break;case"uk":$e="% )h-Z Ƃh. h- mhĆ& h#˘ .(. ':.h3m.#(1&haѠRuPh&\\-7\0qȓmb#aJ~G+L&x!]bד xB+\nܚ+h\\*Vb֪ &k`Dk_fB,[7L=4hJ|L&k˨&Xd!ֽP:W0H|s*8 /4:=dZURhz\"lB 1BI#c|AG(QnӼ::Mo> *vq ?qϋ#AI/)w3ARkFϼԿY\r}G8*v\\tw}I-;0^?-^j{>lϵ,\n({nP >nO \nhgHڹT} GM,%\$ SVj>CHn 1'c\$OYA s@x /0xe\r2Ci1\$ɡL,Sr#ֽhp\0dVSL\"g&̖,zNQyy{4ً &S+ & \"D\"%DȜ RA*x(xh9( !IH4J}d?\$ Qtg \\RNʄ8&e)(t*\r\r͇drl2,H^Q`\r&ĥ(,㔙Bh-@\rf\n (B+E\$ S3~H҆#M %d;TA*'@m͘NPQ\nҍʜHi8 tChrtej)G29jFy`\"P Ә?\n(q p\":\r&IaL)d)[!Um)ή u-}F=.5E \\GKz ;'*!`Hޤic:У>idW頏D|B:\rY.3\r4 A sҙuzah@ti8[-:KZ aO7;|kul7*'֊+ɜӉh@<6`5h꜎M\$\n\r( #5/[N\"\r<Z,`6 h7PJH@褔I6PH g,-pҍ@R*ڌJPkZ!* 7PM-TaК&B ]3G\"= :--=0\n| )i2T[!^0όSB{O+Pc=+=]X#l@\"Ժ3\rOVu5i:\$[|/:):(:s3C\nH Sj5*-C\r)p̈#r亃(;b@T4ۭh> N8(3&:9.%!c RTιN6\0ۑdn9exAff=QUeY.L!.2'v%k2՚&TA˦4##]P CC8a^h\\m8\\،|V4xD C[܅u䈢x3#Ed4O67& {9 5}ل[_wH@*y t{&09}4c/OƎ~й\\,7r!\\EQJdcq.ػ7HEc<;\0L&D1bȬf\$P!r`Q^1Edĭ\r2dvj'\naD&Rn\0F\n4تZCf3I pD] .dt\"BDpTTcn~ ڍT&U&Rz'ĘRjGk\"\"RQFdzNo 6 Y>0-<2 )'%\nVklqUÚ친4;*f\$dSDI.FHՎB^c>eS'ab< qftηWNფľ3r+%`\0R\$Svb\0Ms\0 \rQu6ԳEKF9Y,lRzX\$ɊB)!I\$e E.C:e_2S{F>\0";break;case"vi":$e="% (ha\rq]Ҍ]c\rTnAjhc,\" b5H؉ q Nd) R!/5!PäA&n&0cAn8 10Lthb*L QCH1b ,Q^cM3s2Nr =v8]&-.c\rF 1XE)C nz 477JqmU`-M@daH9[\rH!y i=Yd\$IXWxmmtWjYoqwD :<6\nc4`P7e' @@#hߢ,*X7@9Cx䐈CJ<(Z8BW J NsZ:\n\n(T! ŵ|]Cb #cj LtnH7F-t: @MP`PH g:V@[_CA-K hReٗEz6<@RcMR JH2CCCŋpN К&B clS% yP⣎uYоHQ)\":VdjdK:tRd(t/0Vc5_hIG*\\?M[h9ͣQpCqH\nt+ծB_cS>R\$2Cϒ')2T*´[1P*2sD6rë`re5pKRxLa SA b8sTHAv]\"h^9{ sH]AE!zNGI\0ڑeJGD0\$ К&B csKaZKaLO\\h̡g)[19A3 }IC`9,k)L]~rD3^N(\$QCAKٝA~+8DXrTPJѕ\nP#p|QLmulti=$this->query($H);}function
store_result(){return$this->multi;}function
next_result(){return
false;}}if(extension_loaded('pdo')){abstract
class
PdoDb
extends
SqlDb{protected$pdo;function
dsn($wb,$U,$F,array$C=array()){$C[\PDO::ATTR_ERRMODE]=\PDO::ERRMODE_SILENT;$C[\PDO::ATTR_STATEMENT_CLASS]=array('Adminer\PdoResult');try{$this->pdo=new
\PDO($wb,$U,$F,$C);}catch(\Exception$Lb){return$Lb->getMessage();}$this->server_info=@$this->pdo->getAttribute(\PDO::ATTR_SERVER_VERSION);return'';}function
quote($P){return$this->pdo->quote($P);}function
query($H,$Jf=false){$I=$this->pdo->query($H);$this->error="";if(!$I){list(,$this->errno,$this->error)=$this->pdo->errorInfo();if(!$this->error)$this->error=lang(23);return
false;}$this->store_result($I);return$I;}function
store_result($I=null){if(!$I){$I=$this->multi;if(!$I)return
false;}if($I->columnCount()){$I->num_rows=$I->rowCount();return$I;}$this->affected_rows=$I->rowCount();return
true;}function
next_result(){$I=$this->multi;if(!is_object($I))return
false;$I->_offset=0;return@$I->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($Gd){$J=$this->fetch($Gd);return($J?array_map(array($this,'unresource'),$J):$J);}private
function
unresource($W){return(is_resource($W)?stream_get_contents($W):$W);}function
fetch_field(){$K=(object)$this->getColumnMeta($this->_offset++);$S=$K->pdo_type;$K->type=($S==\PDO::PARAM_INT?0:15);$K->charsetnr=($S==\PDO::PARAM_LOB||(isset($K->flags)&&in_array("blob",(array)$K->flags))?63:0);return$K;}function
seek($Qd){for($q=0;$q<$Qd;$q++)$this->fetch();}}}function
add_driver($r,$A){SqlDriver::$drivers[$r]=$A;}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($N,$U,$F){$f=new
Db;return($f->attach($N,$U,$F)?:$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$M,array$Z,array$p,array$D=array(),$w=1,$E=0,$ve=false){$Vc=(count($p)selectQueryBuild($M,$Z,$p,$D,$w,$E);if(!$H)$H="SELECT".limit(($_GET["page"]!="last"&&$w&&$p&&$Vc&&JUSH=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$M)."\nFROM ".table($Q),($Z?"\nWHERE ".implode(" AND ",$Z):"").($p&&$Vc?"\nGROUP BY ".implode(", ",$p):"").($D?"\nORDER BY ".implode(", ",$D):""),$w,($E?$w*$E:0),"\n");$gf=microtime(true);$J=$this->conn->query($H);if($ve)echo
adminer()->selectQuery($H,$gf,!$J);return$J;}function
delete($Q,$_e,$w=0){$H="FROM ".table($Q);return
queries("DELETE".($w?limit1($Q,$H,$_e):" $H$_e"));}function
update($Q,array$O,$_e,$w=0,$Te="\n"){$Yf=array();foreach($O
as$v=>$W)$Yf[]="$v = $W";$H=table($Q)." SET$Te".implode(",$Te",$Yf);return
queries("UPDATE".($w?limit1($Q,$H,$_e,$Te):" $H$_e"));}function
insert($Q,array$O){return
queries("INSERT INTO ".table($Q).($O?" (".implode(", ",array_keys($O)).")\nVALUES (".implode(", ",$O).")":" DEFAULT VALUES").$this->insertReturning($Q));}function
insertReturning($Q){return"";}function
insertUpdate($Q,array$L,array$ue){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}function
slowQuery($H,$wf){}function
convertSearch($s,array$W,array$k){return$s;}function
value($W,array$k){return(method_exists($this->conn,'value')?$this->conn->value($W,$k):$W);}function
quoteBinary($Le){return
q($Le);}function
warnings(){}function
tableHelp($A,$Yc=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$of){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(){$J=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$K){$K["null"]=($K["nullable"]=="YES");$J[$K["tab"]][]=$K;}}return$J;}}class
Adminer{static$instance;var$error='';private$values=array();function
name(){return"![](".h(preg_replace("~\\?.*~","",ME)."?file=logo.png&version=5.4.4").")
".lang(24)."";}function
credentials(){return
array(SERVER,$_GET["username"],get_password());}function
connectSsl(){}function
permanentLogin($bb=false){return
password_file($bb);}function
bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
serverName($N){}function
database(){if(connection()){$kb=adminer()->databases(false);return(!$kb?get_val("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1)"):$kb[(information_schema($kb[0])?1:0)]);}}function
operators(){return
array("<=",">=");}function
schemas(){return
schemas();}function
databases($bc=true){return
get_databases($bc);}function
pluginsLinks(){}function
queryTimeout(){return
5;}function
afterConnect(){}function
headers(){}function
csp($eb){return$eb;}function
head($hb=null){return
true;}function
bodyClass(){echo" editor";}function
css(){$J=array();foreach(array("","-dark")as$Gd){$m="adminer$Gd.css";if(file_exists($m)){$Wb=file_get_contents($m);$J["$m?v=".crc32($Wb)]=($Gd?"dark":(preg_match('~prefers-color-scheme:\s*dark~',$Wb)?'':'light'));}}return$J;}function
loginForm(){echo"\n","\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],lang(28))."\n";}function
loginFormField($A,$zc,$X){return$zc.$X."\n";}function
login($od,$F){return
true;}function
tableName($of){return
h(isset($of["Engine"])?($of["Comment"]!=""?$of["Comment"]:$of["Name"]):"");}function
fieldName($k,$D=0){return
h(preg_replace('~\s+\[.*\]$~','',($k["comment"]!=""?$k["comment"]:$k["field"])));}function
selectLinks($of,$O=""){$a=$of["Name"];if($O!==null)echo'
'.lang(29)."\n";}function
foreignKeys($Q){return
foreign_keys($Q);}function
backwardKeys($Q,$nf){$J=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$K)$J[$K["TABLE_NAME"]]["keys"][$K["CONSTRAINT_NAME"]][$K["COLUMN_NAME"]]=$K["REFERENCED_COLUMN_NAME"];foreach($J
as$v=>$W){$A=adminer()->tableName(table_status1($v,true));if($A!=""){$Ne=preg_quote($nf);$Te="(:|\\s*-)?\\s+";$J[$v]["name"]=(preg_match("(^$Ne$Te(.+)|^(.+?)$Te$Ne\$)iu",$A,$z)?$z[2].$z[3]:$A);}else
unset($J[$v]);}return$J;}function
backwardKeysPrint($va,$K){foreach($va
as$Q=>$ua){foreach($ua["keys"]as$Ra){$x=ME.'select='.urlencode($Q);$q=0;foreach($Ra
as$c=>$W)$x
.=where_link($q++,$c,$K[$W]);echo"".h($ua["name"])."";$x=ME.'edit='.urlencode($Q);foreach($Ra
as$c=>$W)$x
.="&set".urlencode("[".bracket_escape($c)."]")."=".urlencode($K[$W]);echo"+ ";}}}function
selectQuery($H,$gf,$Sb=false){return"\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($L,$fc){$J=$L;foreach($L[0]as$v=>$W){if(list($Q,$r,$A)=$this->_foreignColumn($fc,$v)){$Hc=array();foreach($L
as$K)$Hc[$K[$v]]=q($K[$v]);$qb=$this->values[$Q];if(!$qb)$qb=get_key_vals("SELECT $r, $A FROM ".table($Q)." WHERE $r IN (".implode(", ",$Hc).")");foreach($L
as$_=>$K){if(isset($K[$v]))$J[$_][$v]=(string)$qb[$K[$v]];}}}return$J;}function
selectLink($W,$k){}function
selectVal($W,$x,$k,$be){$J="$W";$x=h($x);if(is_blob($k)&&!is_utf8($W)){$J=lang(30,strlen($be));if(preg_match("~^(GIF|\xFF\xD8\xFF|\x89PNG\x0D\x0A\x1A\x0A)~",$be))$J="
";}if(like_bool($k)&&$J!="")$J=(preg_match('~^(1|t|true|y|yes|on)$~i',$W)?lang(31):lang(32));if($x)$J="$J";if(preg_match('~date~',$k["type"]))$J="
$J
";return$J;}function
editVal($W,$k){if(preg_match('~date|timestamp~',$k["type"])&&$W!==null)return
preg_replace('~^(\d{2}(\d+))-(0?(\d+))-(0?(\d+))~',lang(33),$W);return$W;}function
config(){return
array();}function
selectColumnsPrint($M,$d){}function
selectSearchPrint($Z,$d,$u){$Z=(array)$_GET["where"];echo'\n";}function
selectOrderPrint($D,$d,$u){$ae=array();foreach($u
as$v=>$t){$D=array();foreach($t["columns"]as$W)$D[]=$d[$W];if(count(array_filter($D,'strlen'))>1&&$v!="PRIMARY")$ae[$v]=implode(", ",$D);}if($ae)echo'\n";if($_GET["order"])echo"".hidden_fields(array("order"=>array(1=>reset($_GET["order"])),"desc"=>($_GET["desc"]?array(1=>1):array()),))."
\n";}function
selectLimitPrint($w){echo"\n";}function
selectLengthPrint($tf){}function
selectActionPrint($u){echo"\n";}function
selectCommandPrint(){return
true;}function
selectImportPrint(){return
true;}function
selectEmailPrint($Bb,$d){}function
selectColumnsProcess($d,$u){return
array(array(),array());}function
selectSearchProcess($l,$u){$J=array();foreach((array)$_GET["where"]as$v=>$Z){$Oa=$Z["col"];$Vd=$Z["op"];$W=$Z["val"];if(($v>=0&&$Oa!="")||$W!=""){$Ua=array();foreach(($Oa!=""?array($Oa=>$l[$Oa]):$l)as$A=>$k){if($Oa!=""||is_numeric($W)||!preg_match(number_type(),$k["type"])){$A=idf_escape($A);if($Oa!=""&&$k["type"]=="enum"){$Jc=array();foreach($W
as$Xf){if(preg_match('~val-~',$Xf))$Jc[]=q(substr($Xf,4));}$Ua[]=(in_array("null",$W)?"$A IS NULL OR ":"").($Jc?"$A IN (".implode(", ",$Jc).")":"0");}else{$uf=preg_match('~char|text|enum|set~',$k["type"]);$X=adminer()->processInput($k,(!$Vd&&$uf&&preg_match('~^[^%]+$~',$W)?"%$W%":$W));$Ua[]=driver()->convertSearch($A,$Z,$k).($X=="NULL"?" IS".($Vd==">="?" NOT":"")." $X":(in_array($Vd,adminer()->operators())||$Vd=="="?" $Vd $X":($uf?" LIKE $X":" IN (".($X[0]=="'"?str_replace(",","', '",$X):$X).")")));if($v<0&&$W=="0")$Ua[]="$A IS NULL";}}}$J[]=($Ua?"(".implode(" OR ",$Ua).")":"1 = 0");}}return$J;}function
selectOrderProcess($l,$u){$Lc=$_GET["index_order"];if($Lc!="")unset($_GET["order"][1]);if($_GET["order"])return
array(idf_escape(reset($_GET["order"])).($_GET["desc"]?" DESC":""));foreach(($Lc!=""?array($u[$Lc]):$u)as$t){if($Lc!=""||$t["type"]=="INDEX"){$uc=array_filter($t["descs"]);$pb=false;foreach($t["columns"]as$W){if(preg_match('~date|timestamp~',$l[$W]["type"])){$pb=true;break;}}$J=array();foreach($t["columns"]as$v=>$W)$J[]=idf_escape($W).(($uc?$t["descs"][$v]:$pb)?" DESC":"");return$J;}}return
array();}function
selectLimitProcess(){return(isset($_GET["limit"])?intval($_GET["limit"]):50);}function
selectLengthProcess(){return"100";}function
selectEmailProcess($Z,$fc){return
false;}function
selectQueryBuild($M,$Z,$p,$D,$w,$E){return"";}function
messageQuery($H,$vf,$Sb=false){return" ".@date("H:i:s")."";}function
editRowPrint($Q,$l,$K,$T){}function
editFunctions($k){$J=array();if($k["null"]&&preg_match('~blob~',$k["type"]))$J["NULL"]=lang(35);$J[""]=($k["null"]||$k["auto_increment"]||like_bool($k)?"":"*");if(preg_match('~date|time~',$k["type"]))$J["now"]=lang(41);if(preg_match('~_(md5|sha1)$~i',$k["field"],$z))$J[]=strtolower($z[1]);return$J;}function
editInput($Q,$k,$b,$X){if($k["type"]=="enum")return(isset($_GET["select"])?" ":"").enum_input("radio",$b,$k,$X,lang(35));$C=$this->foreignKeyOptions($Q,$k["field"],$X);if($C!==null)return(is_array($C)?"".optionlist($C,(string)$X,true)."":"".""."".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'";$Ac="";if(preg_match('~time~',$k["type"]))$Ac=lang(42);if(preg_match('~date|timestamp~',$k["type"]))$Ac=lang(43).($Ac?" [$Ac]":"");if($Ac)return" ($Ac)";if(preg_match('~_(md5|sha1)$~i',$k["field"]))return"";return'';}function
editHint($Q,$k,$X){return(preg_match('~\s+(\[.*\])$~',($k["comment"]!=""?$k["comment"]:$k["field"]),$z)?h(" $z[1]"):'');}function
processInput($k,$X,$o=""){if($o=="now")return"$o()";$J=$X;if(preg_match('~date|timestamp~',$k["type"])&&preg_match('(^'.str_replace('\$1','(?P\d*)',preg_replace('~(\\\\\\$([2-6]))~','(?P\d{1,2})',preg_quote(lang(33)))).'(.*))',$X,$z))$J=($z["p1"]!=""?$z["p1"]:($z["p2"]!=""?($z["p2"]<70?20:19).$z["p2"]:gmdate("Y")))."-$z[p3]$z[p4]-$z[p5]$z[p6]".end($z);$J=q($J);if($X==""&&like_bool($k))$J="'0'";elseif($X==""&&($k["null"]||!preg_match('~char|text~',$k["type"])))$J="NULL";elseif(preg_match('~^(md5|sha1)$~',$o))$J="$o($J)";return
unconvert_field($k,$J);}function
dumpOutput(){return
array();}function
dumpFormat(){return
array('csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
dumpDatabase($h){}function
dumpTable($Q,$jf,$Yc=0){echo"\xef\xbb\xbf";}function
dumpData($Q,$jf,$H){$I=connection()->query($H,1);if($I){while($K=$I->fetch_assoc()){if($jf=="table"){dump_csv(array_keys($K));$jf="INSERT";}dump_csv($K);}}}function
dumpFilename($Gc){return
friendly_url($Gc);}function
dumpHeaders($Gc,$Id=false){$Ob="csv";header("Content-Type: text/csv; charset=utf-8");return$Ob;}function
dumpFooter(){}function
importServerPath(){}function
homepage(){return
true;}function
navigation($Fd){echo"\n";switch_lang();if($Fd=="auth"){$Zb=true;foreach((array)$_SESSION["pwds"]as$Y=>$Ve){foreach($Ve[""]as$U=>$F){if($F!==null){if($Zb){echo"",script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");$Zb=false;}echo"- ".($U!=""?h($U):"".lang(35)."")."\n";}}}}else{adminer()->databasesPrint($Fd);$da=adminer()->menuActions(array(),$Fd);echo($da?"
\n".implode("\n",$da)."\n":"");if($Fd!="db"&&$Fd!="ns"){$R=table_status('',true);if(!$R)echo"
".lang(11)."\n";else
adminer()->tablesPrint($R);}}}function
syntaxHighlighting($qf){}function
databasesPrint($Fd){}function
menuActions($da,$Fd){return$da;}function
tablesPrint($qf){echo"
",script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($qf
as$K){echo'- ';$A=adminer()->tableName($K);if($A!="")echo"$A\n";}echo"
\n";}function
_foreignColumn($fc,$c){foreach((array)$fc[$c]as$ec){if(count($ec["source"])==1){$A=adminer()->rowDescription($ec["table"]);if($A!=""){$r=idf_escape($ec["target"][0]);return
array($ec["table"],$r,$A);}}}}private
function
foreignKeyOptions($Q,$c,$X=null){if(list($rf,$r,$A)=$this->_foreignColumn(column_foreign_keys($Q),$c)){$J=&$this->values[$rf];if($J===null){$R=table_status1($rf);$J=($R["Rows"]>1000?"":array(""=>"")+get_key_vals("SELECT $r, $A FROM ".table($rf)." ORDER BY 2"));}if(!$J&&$X!==null)return
get_val("SELECT $A FROM ".table($rf)." WHERE $r = ".q($X));return$J;}}}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($oe){if($oe===null){$oe=array();$ya="adminer-plugins";if(is_dir($ya)){foreach(glob("$ya/*.php")as$m)$this->includeOnce($m);}$_c=" href='https://www.adminer.org/plugins/#use'".target_blank();if(file_exists("$ya.php")){$Kc=$this->includeOnce("$ya.php");if(is_array($Kc)){foreach($Kc
as$ne)$oe[get_class($ne)]=$ne;}else$this->error
.=lang(45,"$ya.php",$_c)."
";}foreach(get_declared_classes()as$La){if(!$oe[$La]&&(preg_match('~^Adminer\w~i',$La)||is_subclass_of($La,'Adminer\Plugin'))){$Ee=new
\ReflectionClass($La);$Wa=$Ee->getConstructor();if($Wa&&$Wa->getNumberOfRequiredParameters())$this->error
.=lang(46,$_c,"$La","$ya.php")."
";else$oe[$La]=new$La;}}}$this->plugins=$oe;$ea=new
Adminer;$oe[]=$ea;$Ee=new
\ReflectionObject($ea);foreach($Ee->getMethods()as$Ed){foreach($oe
as$ne){$A=$Ed->getName();if(method_exists($ne,$A))$this->hooks[$A][]=$ne;}}}function
includeOnce($m){return
include_once"./$m";}function
__call($A,array$ge){$ka=array();foreach($ge
as$v=>$W)$ka[]=&$ge[$v];$J=null;foreach($this->hooks[$A]as$ne){$X=call_user_func_array(array($ne,$A),$ka);if($X!==null){if(!self::$append[$A])return$X;$J=$X+(array)$J;}}return$J;}}abstract
class
Plugin{protected$translations=array();function
description(){return$this->lang('');}function
screenshot(){return"";}protected
function
lang($s,$B=null){$ka=func_get_args();$ka[0]=idx($this->translations[LANG],$s)?:$s;return
call_user_func_array('Adminer\lang_format',$ka);}}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($N,$U,$F){mysqli_report(MYSQLI_REPORT_OFF);list($Cc,$pe)=host_port($N);$ff=adminer()->connectSsl();if($ff)$this->ssl_set($ff['key'],$ff['cert'],$ff['ca'],'','');$J=@$this->real_connect(($N!=""?$Cc:ini_get("mysqli.default_host")),($N.$U!=""?$U:ini_get("mysqli.default_user")),($N.$U.$F!=""?$F:ini_get("mysqli.default_pw")),null,(is_numeric($pe)?intval($pe):ini_get("mysqli.default_port")),(is_numeric($pe)?null:$pe),($ff?($ff['verify']!==false?2048:64):0));$this->options(MYSQLI_OPT_LOCAL_INFILE,0);return($J?'':$this->error);}function
set_charset($Ga){if(parent::set_charset($Ga))return
true;parent::set_charset('utf8');return$this->query("SET NAMES $Ga");}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($N,$U,$F){if(ini_bool("mysql.allow_local_infile"))return
lang(47,"'mysql.allow_local_infile'","MySQLi","PDO_MySQL");$this->link=@mysql_connect(($N!=""?$N:ini_get("mysql.default_host")),($N.$U!=""?$U:ini_get("mysql.default_user")),($N.$U.$F!=""?$F: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($Ga){if(function_exists('mysql_set_charset')){if(mysql_set_charset($Ga,$this->link))return
true;mysql_set_charset('utf8',$this->link);}return$this->query("SET NAMES $Ga");}function
quote($P){return"'".mysql_real_escape_string($P,$this->link)."'";}function
select_db($jb){return
mysql_select_db($jb,$this->link);}function
query($H,$Jf=false){$I=@($Jf?mysql_unbuffered_query($H,$this->link):mysql_query($H,$this->link));$this->error="";if(!$I){$this->errno=mysql_errno($this->link);$this->error=mysql_error($this->link);return
false;}if($I===true){$this->affected_rows=mysql_affected_rows($this->link);$this->info=mysql_info($this->link);return
true;}return
new
Result($I);}}class
Result{var$num_rows;private$result;private$offset=0;function
__construct($I){$this->result=$I;$this->num_rows=mysql_num_rows($I);}function
fetch_assoc(){return
mysql_fetch_assoc($this->result);}function
fetch_row(){return
mysql_fetch_row($this->result);}function
fetch_field(){$J=mysql_fetch_field($this->result,$this->offset++);$J->orgtable=$J->table;$J->charsetnr=($J->blob?63:0);return$J;}function
__destruct(){mysql_free_result($this->result);}}}elseif(extension_loaded("pdo_mysql")){class
Db
extends
PdoDb{var$extension="PDO_MySQL";function
attach($N,$U,$F){$C=array(\PDO::MYSQL_ATTR_LOCAL_INFILE=>false);$ff=adminer()->connectSsl();if($ff){if($ff['key'])$C[\PDO::MYSQL_ATTR_SSL_KEY]=$ff['key'];if($ff['cert'])$C[\PDO::MYSQL_ATTR_SSL_CERT]=$ff['cert'];if($ff['ca'])$C[\PDO::MYSQL_ATTR_SSL_CA]=$ff['ca'];if(isset($ff['verify']))$C[\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT]=$ff['verify'];}list($Cc,$pe)=host_port($N);return$this->dsn("mysql:charset=utf8;host=$Cc".($pe?(is_numeric($pe)?";port=":";unix_socket=").$pe:""),$U,$F,$C);}function
set_charset($Ga){return$this->query("SET NAMES $Ga");}function
select_db($jb){return$this->query("USE ".idf_escape($jb));}function
query($H,$Jf=false){$this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,!$Jf);return
parent::query($H,$Jf);}}}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($N,$U,$F){$f=parent::connect($N,$U,$F);if(is_string($f)){if(function_exists('iconv')&&!is_utf8($f)&&strlen($Le=iconv("windows-1250","utf-8",$f))>strlen($f))$f=$Le;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(lang(48)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(49)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(50)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(51)=>array("enum"=>65535,"set"=>64),lang(52)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(53)=>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[lang(50)]["json"]=4294967295;if(min_version('',10.7,$f)){$this->types[lang(50)]["uuid"]=128;$this->insertFunctions['uuid']='uuid';}if(min_version(9,'',$f)){$this->types[lang(48)]["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"])?"UNHEX":($k["type"]=="bit"?doc_link(array('sql'=>'bit-value-literals.html'),"b''"):(preg_match("~geometry|point|linestring|polygon~",$k["type"])?"GeomFromText":"")));}function
insert($Q,array$O){return($O?parent::insert($Q,$O):queries("INSERT INTO ".table($Q)." ()\nVALUES ()"));}function
insertUpdate($Q,array$L,array$ue){$d=array_keys(reset($L));$te="INSERT INTO ".table($Q)." (".implode(", ",$d).") VALUES\n";$Yf=array();foreach($d
as$v)$Yf[$v]="$v = VALUES($v)";$lf="\nON DUPLICATE KEY UPDATE ".implode(", ",$Yf);$Yf=array();$ld=0;foreach($L
as$O){$X="(".implode(", ",$O).")";if($Yf&&(strlen($te)+$ld+strlen($X)+strlen($lf)>1e6)){if(!queries($te.implode(",\n",$Yf).$lf))return
false;$Yf=array();$ld=0;}$Yf[]=$X;$ld+=strlen($X)+2;}return
queries($te.implode(",\n",$Yf).$lf);}function
slowQuery($H,$wf){if(min_version('5.7.8','10.1.2')){if($this->conn->flavor=='maria')return"SET STATEMENT max_statement_time=$wf FOR $H";elseif(preg_match('~^(SELECT\b)(.+)~is',$H,$z))return"$z[1] /*+ MAX_EXECUTION_TIME(".($wf*1000).") */ $z[2]";}}function
convertSearch($s,array$W,array$k){return(preg_match('~char|text|enum|set~',$k["type"])&&!preg_match("~^utf8~",$k["collation"])&&preg_match('~[\x80-\xFF]~',$W['val'])?"CONVERT($s USING ".charset($this->conn).")":$s);}function
quoteBinary($Le){return"X".q(bin2hex($Le));}function
warnings(){$I=$this->conn->query("SHOW WARNINGS");if($I&&$I->num_rows){ob_start();print_select_result($I);return
ob_get_clean();}}function
tableHelp($A,$Yc=false){$qd=($this->conn->flavor=='maria');if(information_schema(DB))return
strtolower("information-schema-".($qd?"$A-table/":str_replace("_","-",$A)."-table.html"));if(DB=="mysql")return($qd?"mysql$A-table/":"system-schema.html");}function
partitionsInfo($Q){$kc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($Q);$I=$this->conn->query("SELECT PARTITION_METHOD, PARTITION_EXPRESSION, PARTITION_ORDINAL_POSITION $kc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");$J=array();list($J["partition_by"],$J["partition"],$J["partitions"])=$I->fetch_row();$je=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $kc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$J["partition_names"]=array_keys($je);$J["partition_values"]=array_values($je);return$J;}function
hasCStyleEscapes(){static$Ea;if($Ea===null){$ef=get_val("SHOW VARIABLES LIKE 'sql_mode'",1,$this->conn);$Ea=(strpos($ef,'NO_BACKSLASH_ESCAPES')===false);}return$Ea;}function
engines(){$J=array();foreach(get_rows("SHOW ENGINES")as$K){if(preg_match("~YES|DEFAULT~",$K["Support"]))$J[]=$K["Engine"];}return$J;}function
indexAlgorithms(array$of){return(preg_match('~^(MEMORY|NDB)$~',$of["Engine"])?array("HASH","BTREE"):array());}}function
idf_escape($s){return"`".str_replace("`","``",$s)."`";}function
table($s){return
idf_escape($s);}function
get_databases($bc){$J=get_session("dbs");if($J===null){$H="SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME";$J=($bc?slow_query($H):get_vals($H));restart_session();set_session("dbs",$J);stop_session();}return$J;}function
limit($H,$Z,$w,$Qd=0,$Te=" "){return" $H$Z".($w?$Te."LIMIT $w".($Qd?" OFFSET $Qd":""):"");}function
limit1($Q,$H,$Z,$Te="\n"){return
limit($H,$Z,1,0,$Te);}function
db_collation($h,array$Qa){$J=null;$bb=get_val("SHOW CREATE DATABASE ".idf_escape($h),1);if(preg_match('~ COLLATE ([^ ]+)~',$bb,$z))$J=$z[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$bb,$z))$J=$Qa[$z[1]][-1];return$J;}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$kb){$J=array();foreach($kb
as$h)$J[$h]=count(get_vals("SHOW TABLES IN ".idf_escape($h)));return$J;}function
table_status($A="",$Tb=false){$J=array();foreach(get_rows($Tb?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($A!=""?"AND TABLE_NAME = ".q($A):"ORDER BY Name"):"SHOW TABLE STATUS".($A!=""?" LIKE ".q(addcslashes($A,"%_\\")):""))as$K){if($K["Engine"]=="InnoDB")$K["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\1',$K["Comment"]);if(!isset($K["Engine"]))$K["Comment"]="";if($A!="")$K["Name"]=$A;$J[$K["Name"]]=$K;}return$J;}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');$J=array();foreach(get_rows("SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = ".q($Q)." ORDER BY ORDINAL_POSITION")as$K){$k=$K["COLUMN_NAME"];$S=$K["COLUMN_TYPE"];$oc=$K["GENERATION_EXPRESSION"];$Rb=$K["EXTRA"];preg_match('~^(VIRTUAL|PERSISTENT|STORED)~',$Rb,$nc);preg_match('~^([^( ]+)(?:\((.+)\))?( unsigned)?( zerofill)?$~',$S,$sd);$i=$K["COLUMN_DEFAULT"];if($i!=""){$Xc=preg_match('~text|json~',$sd[1]);if(!$qd&&$Xc)$i=preg_replace("~^(_\w+)?('.*')$~",'\2',stripslashes($i));if($qd||$Xc){$i=($i=="NULL"?null:preg_replace_callback("~^'(.*)'$~",function($z){return
stripslashes(str_replace("''","'",$z[1]));},$i));}if(!$qd&&preg_match('~binary~',$sd[1])&&preg_match('~^0x(\w*)$~',$i,$z))$i=pack("H*",$z[1]);}$J[$k]=array("field"=>$k,"full_type"=>$S,"type"=>$sd[1],"length"=>$sd[2],"unsigned"=>ltrim($sd[3].$sd[4]),"default"=>($nc?($qd?$oc:stripslashes($oc)):$i),"null"=>($K["IS_NULLABLE"]=="YES"),"auto_increment"=>($Rb=="auto_increment"),"on_update"=>(preg_match('~\bon update (\w+)~i',$Rb,$z)?$z[1]:""),"collation"=>$K["COLLATION_NAME"],"privileges"=>array_flip(explode(",","$K[PRIVILEGES],where,order")),"comment"=>$K["COLUMN_COMMENT"],"primary"=>($K["COLUMN_KEY"]=="PRI"),"generated"=>($nc[1]=="PERSISTENT"?"STORED":$nc[1]),);}return$J;}function
indexes($Q,$g=null){$J=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$g)as$K){$A=$K["Key_name"];$J[$A]["type"]=($A=="PRIMARY"?"PRIMARY":($K["Index_type"]=="FULLTEXT"?"FULLTEXT":($K["Non_unique"]?($K["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$J[$A]["columns"][]=$K["Column_name"];$J[$A]["lengths"][]=($K["Index_type"]=="SPATIAL"?null:$K["Sub_part"]);$J[$A]["descs"][]=null;$J[$A]["algorithm"]=$K["Index_type"];}return$J;}function
foreign_keys($Q){static$le='(?:`(?:[^`]|``)+`|"(?:[^"]|"")+")';$J=array();$cb=get_val("SHOW CREATE TABLE ".table($Q),1);if($cb){preg_match_all("~CONSTRAINT ($le) FOREIGN KEY ?\\(((?:$le,? ?)+)\\) REFERENCES ($le)(?:\\.($le))? \\(((?:$le,? ?)+)\\)(?: ON DELETE (".driver()->onActions."))?(?: ON UPDATE (".driver()->onActions."))?~",$cb,$td,PREG_SET_ORDER);foreach($td
as$z){preg_match_all("~$le~",$z[2],$cf);preg_match_all("~$le~",$z[5],$rf);$J[idf_unescape($z[1])]=array("db"=>idf_unescape($z[4]!=""?$z[3]:$z[4]),"table"=>idf_unescape($z[4]!=""?$z[4]:$z[3]),"source"=>array_map('Adminer\idf_unescape',$cf[0]),"target"=>array_map('Adminer\idf_unescape',$rf[0]),"on_delete"=>($z[6]?:"RESTRICT"),"on_update"=>($z[7]?:"RESTRICT"),);}}return$J;}function
view($A){return
array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\s+AS\s+~isU','',get_val("SHOW CREATE VIEW ".table($A),1)));}function
collations(){$J=array();foreach(get_rows("SHOW COLLATION")as$K){if($K["Default"])$J[$K["Charset"]][-1]=$K["Collation"];else$J[$K["Charset"]][]=$K["Collation"];}ksort($J);foreach($J
as$v=>$W)sort($J[$v]);return$J;}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,$Pa){return
queries("CREATE DATABASE ".idf_escape($h).($Pa?" COLLATE ".q($Pa):""));}function
drop_databases(array$kb){$J=apply_queries("DROP DATABASE",$kb,'Adminer\idf_escape');restart_session();set_session("dbs",null);return$J;}function
rename_database($A,$Pa){$J=false;if(create_database($A,$Pa)){$qf=array();$bg=array();foreach(tables_list()as$Q=>$S){if($S=='VIEW')$bg[]=$Q;else$qf[]=$Q;}$J=(!$qf&&!$bg)||move_tables($qf,$bg,$A);drop_databases($J?array(DB):array());}return$J;}function
auto_increment(){$ra=" 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)){$ra="";break;}if($t["type"]=="PRIMARY")$ra=" UNIQUE";}}return" AUTO_INCREMENT$ra";}function
alter_table($Q,$A,array$l,array$dc,$Ta,$Eb,$Pa,$qa,$ie){$ia=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;}$ia[]=($Q!=""?($k[0]!=""?"CHANGE ".idf_escape($k[0]):"ADD"):" ")." ".implode($k[1]).($Q!=""?$k[2]:"");}else$ia[]="DROP ".idf_escape($k[0]);}$ia=array_merge($ia,$dc);$hf=($Ta!==null?" COMMENT=".q($Ta):"").($Eb?" ENGINE=".q($Eb):"").($Pa?" COLLATE ".q($Pa):"").($qa!=""?" AUTO_INCREMENT=$qa":"");if($ie){$je=array();if($ie["partition_by"]=='RANGE'||$ie["partition_by"]=='LIST'){foreach($ie["partition_names"]as$v=>$W){$X=$ie["partition_values"][$v];$je[]="\n PARTITION ".idf_escape($W)." VALUES ".($ie["partition_by"]=='RANGE'?"LESS THAN":"IN").($X!=""?" ($X)":" MAXVALUE");}}$hf
.="\nPARTITION BY $ie[partition_by]($ie[partition])";if($je)$hf
.=" (".implode(",",$je)."\n)";elseif($ie["partitions"])$hf
.=" PARTITIONS ".(+$ie["partitions"]);}elseif($ie===null)$hf
.="\nREMOVE PARTITIONING";if($Q=="")return
queries("CREATE TABLE ".table($A)." (\n".implode(",\n",$ia)."\n)$hf");if($Q!=$A)$ia[]="RENAME TO ".table($A);if($hf)$ia[]=ltrim($hf);return($ia?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$ia)):true);}function
alter_indexes($Q,$ia){$Fa=array();foreach($ia
as$W)$Fa[]=($W[2]=="DROP"?"\nDROP INDEX ".idf_escape($W[1]):"\nADD $W[0] ".($W[0]=="PRIMARY"?"KEY ":"").($W[1]!=""?idf_escape($W[1])." ":"")."(".implode(", ",$W[2]).")");return
queries("ALTER TABLE ".table($Q).implode(",",$Fa));}function
truncate_tables(array$qf){return
apply_queries("TRUNCATE TABLE",$qf);}function
drop_views(array$bg){return
queries("DROP VIEW ".implode(", ",array_map('Adminer\table',$bg)));}function
drop_tables(array$qf){return
queries("DROP TABLE ".implode(", ",array_map('Adminer\table',$qf)));}function
move_tables(array$qf,array$bg,$rf){$Ge=array();foreach($qf
as$Q)$Ge[]=table($Q)." TO ".idf_escape($rf).".".table($Q);if(!$Ge||queries("RENAME TABLE ".implode(", ",$Ge))){$nb=array();foreach($bg
as$Q)$nb[table($Q)]=view($Q);connection()->select_db($rf);$h=idf_escape(DB);foreach($nb
as$A=>$ag){if(!queries("CREATE VIEW $A AS ".str_replace(" $h."," ",$ag["select"]))||!queries("DROP VIEW $h.$A"))return
false;}return
true;}return
false;}function
copy_tables(array$qf,array$bg,$rf){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($qf
as$Q){$A=($rf==DB?table("copy_$Q"):idf_escape($rf).".".table($Q));if(($_POST["overwrite"]&&!queries("\nDROP TABLE IF EXISTS $A"))||!queries("CREATE TABLE $A LIKE ".table($Q))||!queries("INSERT INTO $A SELECT * FROM ".table($Q)))return
false;foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$K){$Gf=$K["Trigger"];if(!queries("CREATE TRIGGER ".($rf==DB?idf_escape("copy_$Gf"):idf_escape($rf).".".idf_escape($Gf))." $K[Timing] $K[Event] ON $A FOR EACH ROW\n$K[Statement];"))return
false;}}foreach($bg
as$Q){$A=($rf==DB?table("copy_$Q"):idf_escape($rf).".".table($Q));$ag=view($Q);if(($_POST["overwrite"]&&!queries("DROP VIEW IF EXISTS $A"))||!queries("CREATE VIEW $A AS $ag[select]"))return
false;}return
true;}function
trigger($A,$Q){if($A=="")return
array();$L=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($A));return
reset($L);}function
triggers($Q){$J=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$K)$J[$K["Trigger"]]=array($K["Timing"],$K["Event"]);return$J;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
routine($A,$S){$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 = '$S' AND SPECIFIC_NAME = ".q($A)."
ORDER BY ORDINAL_POSITION");$J=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 = '$S' AND ROUTINE_NAME = ".q($A))->fetch_assoc();if($l&&$l[0]['field']=='')$J['returns']=array_shift($l);$J['fields']=$l;return$J;}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($A,array$K){return
idf_escape($A);}function
last_id($I){return
get_val("SELECT LAST_INSERT_ID()");}function
explain(Db$f,$H){return$f->query("EXPLAIN ".(min_version(5.1)&&!min_version(5.7)?"PARTITIONS ":"").$H);}function
found_rows(array$R,array$Z){return($Z||$R["Engine"]!="InnoDB"?null:$R["Rows"]);}function
create_sql($Q,$qa,$jf){$J=get_val("SHOW CREATE TABLE ".table($Q),1);if(!$qa)$J=preg_replace('~ AUTO_INCREMENT=\d+~','',$J);return$J;}function
truncate_sql($Q){return"TRUNCATE ".table($Q);}function
use_sql($jb,$jf=""){$A=idf_escape($jb);$J="";if(preg_match('~CREATE~',$jf)&&($bb=get_val("SHOW CREATE DATABASE $A",1))){set_utf8mb4($bb);if($jf=="DROP+CREATE")$J="DROP DATABASE IF EXISTS $A;\n";$J
.="$bb;\n";}return$J."USE $A";}function
trigger_sql($Q){$J="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$K)$J
.="\nCREATE TRIGGER ".idf_escape($K["Trigger"])." $K[Timing] $K[Event] ON ".table($K["Table"])." FOR EACH ROW\n$K[Statement];;\n";return$J;}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,$J){if(preg_match("~binary~",$k["type"]))$J="UNHEX($J)";if($k["type"]=="bit")$J="CONVERT(b$J, UNSIGNED)";if(preg_match("~geometry|point|linestring|polygon~",$k["type"])){$te=(min_version(8)?"ST_":"");$J=$te."GeomFromText($J, $te"."SRID($k[field]))";}return$J;}function
support($Ub){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':'').')$~',$Ub);}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($Me,$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($xf,$j="",$Da=array(),$yf=""){page_headers();if(is_ajax()&&$j){page_messages($j);exit;}if(!ob_get_level())ob_start('ob_gzhandler',4096);$zf=$xf.($yf!=""?": $yf":"");$_f=strip_tags($zf.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".adminer()->name());echo'
',$_f,'
';$fb=adminer()->css();if(is_int(key($fb)))$fb=array_fill_keys($fb,'light');$wc=in_array('light',$fb)||in_array('',$fb);$tc=in_array('dark',$fb)||in_array('',$fb);$hb=($wc?($tc?null:false):($tc?:null));$Ad=" media='(prefers-color-scheme: dark)'";if($hb!==false)echo"\n";echo"\n",script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=5.4.4");if(adminer()->head($hb))echo"\n","\n";foreach($fb
as$Tf=>$Gd){$b=($Gd=='dark'&&!$hb?$Ad:($Gd=='light'&&$tc?" media='(prefers-color-scheme: light)'":""));echo"\n";}echo"\n\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(lang(55))."';
const thousandsSeparator = '".js_escape(lang(4))."';"),"\n",script("mixin(qs('#help'), {onmouseover: () => { helpOpen = 1; }, onmouseout: helpMouseout});"),"\n","".script("qs('#menuopen').onclick = event => { qs('#foot').classList.toggle('foot'); event.stopPropagation(); }");if($Da!==null){$x=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'
'.get_driver(DRIVER).' » ';$x=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$N=adminer()->serverName(SERVER);$N=($N!=""?$N:lang(56));if($Da===false)echo"$N\n";else{echo"$N » ";if($_GET["ns"]!=""||(DB!=""&&is_array($Da)))echo''.h(DB).' » ';if(is_array($Da)){if($_GET["ns"]!="")echo''.h($_GET["ns"]).' » ';foreach($Da
as$v=>$W){$pb=(is_array($W)?$W[1]:h($W));if($pb!="")echo"$pb » ";}}echo"$xf\n";}}echo"
$zf
\n","
\n";restart_session();page_messages($j);$kb=&get_session("dbs");if(DB!=""&&$kb&&!in_array(DB,$kb,true))$kb=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$eb){$xc=array();foreach($eb
as$v=>$W)$xc[]="$v $W";header("Content-Security-Policy: ".implode("; ",$xc));}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$Od;if(!$Od)$Od=base64_encode(rand_string());return$Od;}function
page_messages($j){$Sf=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Dd=idx($_SESSION["messages"],$Sf);if($Dd){echo"
".implode("
\n
",$Dd)."
".script("messagesPrint();");unset($_SESSION["messages"][$Sf]);}if($j)echo"
$j
\n";if(adminer()->error)echo"
".adminer()->error."
\n";}function
page_footer($Fd=""){echo"
':'').lang(62,target_blank(),'permanentLogin()');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent($G);}}if(!$_COOKIE[$We]&&$_GET[$We]&&ini_bool("session.use_only_cookies"))$j=lang(63);$ge=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?:rand_string()),$ge["lifetime"]);if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);page_header(lang(27),$j,null);echo"\n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists('Adminer\Db')){unset($_SESSION["pwds"][DRIVER]);unset_permanent($G);page_header(lang(65),lang(66,implode(", ",Driver::$extensions)),false);page_footer("auth");exit;}$f='';if(isset($_GET["username"])&&is_string(get_password())){list($Cc,$pe)=host_port(SERVER);if(!preg_match('~^[-a-z0-9.:]*$~i',$Cc))auth_error(lang(67),$G);if(preg_match('~^\s*([-+]?\d+)~',$pe,$z)&&($z[1]<1024||$z[1]>65535))auth_error(lang(68),$G);check_invalid_login($G);$db=adminer()->credentials();$f=Driver::connect($db[0],$db[1],$db[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:lang(69))).(preg_match('~^ | $~',get_password())?'
'.lang(70):'');auth_error($j,$G);}if($_POST["logout"]&&$_SESSION["token"]&&!verify_token()){page_header(lang(57),lang(71));page_footer("db");exit;}if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);stop_session(true);if($pa&&$_POST["token"])$_POST["token"]=get_token();$j='';if($_POST){if(!verify_token()){$Nc="max_input_vars";$zd=ini_get($Nc);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$v){$W=ini_get($v);if($W&&(!$zd||$W<$zd)){$Nc=$v;$zd=$W;}}}$j=(!$_POST["token"]&&$zd?lang(72,"'$Nc'"):lang(71).' '.lang(73));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$j=lang(74,"'post_max_size'");if(isset($_GET["sql"]))$j
.=' '.lang(75);}function
doc_link(array$ke,$sf=""){return"";}function
email_header($xc){return"=?UTF-8?B?".base64_encode($xc)."?=";}function
send_mail($Ab,$kf,$Cd,$kc="",array$Xb=array()){$Hb=PHP_EOL;$Cd=str_replace("\n",$Hb,wordwrap(str_replace("\r","","$Cd\n")));$Ca=uniqid("boundary");$oa="";foreach((array)$Xb["error"]as$v=>$W){if(!$W)$oa
.="--$Ca$Hb"."Content-Type: ".str_replace("\n","",$Xb["type"][$v]).$Hb."Content-Disposition: attachment; filename=\"".preg_replace('~["\n]~','',$Xb["name"][$v])."\"$Hb"."Content-Transfer-Encoding: base64$Hb$Hb".chunk_split(base64_encode(file_get_contents($Xb["tmp_name"][$v])),76,$Hb).$Hb;}$za="";$yc="Content-Type: text/plain; charset=utf-8$Hb"."Content-Transfer-Encoding: 8bit";if($oa){$oa
.="--$Ca--$Hb";$za="--$Ca$Hb$yc$Hb$Hb";$yc="Content-Type: multipart/mixed; boundary=\"$Ca\"";}$yc
.=$Hb."MIME-Version: 1.0$Hb"."X-Mailer: Adminer Editor".($kc?$Hb."From: ".str_replace("\n","",$kc):"");return
mail($Ab,email_header($kf),$za.$Cd.$oa,$yc);}function
like_bool(array$k){return$k["type"]=="bool"||(preg_match('~bit|tinyint~',$k["type"])&&$k["length"]==1);}connection()->select_db(adminer()->database());adminer()->afterConnect();add_driver(DRIVER,lang(27));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"]));$M=array(idf_escape($_GET["field"]));$I=driver()->select($a,$M,array(where($_GET,$l)),$M);$K=($I?$I->fetch_row():array());echo
driver()->value($K[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));$T=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($l
as$A=>$k){if((!$T&&!isset($k["privileges"]["insert"]))||adminer()->fieldName($k)=="")unset($l[$A]);}if($_POST&&!$j&&!isset($_GET["select"])){$y=$_POST["referer"];if($_POST["insert"])$y=($T?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$y))$y=ME."select=".urlencode($a);$u=indexes($a);$Lf=unique_array($_GET["where"],$u);$Ae="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($y,lang(76),driver()->delete($a,$Ae,$Lf?0:1));else{$O=array();foreach($l
as$A=>$k){$W=process_input($k);if($W!==false&&$W!==null)$O[idf_escape($A)]=$W;}if($T){if(!$O)redirect($y);queries_redirect($y,lang(77),driver()->update($a,$O,$Ae,$Lf?0:1));if(is_ajax()){page_headers();page_messages($j);exit;}}else{$I=driver()->insert($a,$O);$jd=($I?last_id($I):0);queries_redirect($y,lang(78,($jd?" $jd":"")),$I);}}}$K=null;if($Z){$M=array();foreach($l
as$A=>$k){if(isset($k["privileges"]["select"])){$ma=($_POST["clone"]&&$k["auto_increment"]?"''":convert_field($k));$M[]=($ma?"$ma AS ":"").idf_escape($A);}}$K=array();if(!support("table"))$M=array("*");if($M){$I=driver()->select($a,$M,array($Z),$M,array(),(isset($_GET["select"])?2:1));if(!$I)$j=error();else{$K=$I->fetch_assoc();if(!$K)$K=false;}if(isset($_GET["select"])&&(!$K||$I->fetch_assoc()))$K=null;}}if(!support("table")&&!$l){if(!$Z){$I=driver()->select($a,array("*"),array(),array("*"));$K=($I?$I->fetch_assoc():false);if(!$K)$K=array(driver()->primary=>"");}if($K){foreach($K
as$v=>$W){if(!$Z)$K[$v]=null;$l[$v]=array("field"=>$v,"null"=>($v!=driver()->primary),"auto_increment"=>($v==driver()->primary));}}}if($_POST["save"])$K=(array)$_POST["fields"]+($K?$K:array());edit_form($a,$l,$K,$T,$j);}elseif(isset($_GET["select"])){$a=$_GET["select"];$R=table_status1($a);$u=indexes($a);$l=fields($a);$hc=column_foreign_keys($a);$Rd=$R["Oid"];$fa=get_settings("adminer_import");$Ke=array();$d=array();$Oe=array();$Zd=array();$tf="";foreach($l
as$v=>$k){$A=adminer()->fieldName($k);$Kd=html_entity_decode(strip_tags($A),ENT_QUOTES);if(isset($k["privileges"]["select"])&&$A!=""){$d[$v]=$Kd;if(is_shortable($k))$tf=adminer()->selectLengthProcess();}if(isset($k["privileges"]["where"])&&$A!="")$Oe[$v]=$Kd;if(isset($k["privileges"]["order"])&&$A!="")$Zd[$v]=$Kd;$Ke+=$k["privileges"];}list($M,$p)=adminer()->selectColumnsProcess($d,$u);$M=array_unique($M);$p=array_unique($p);$Vc=count($p)selectSearchProcess($l,$u);$D=adminer()->selectOrderProcess($l,$u);$w=adminer()->selectLimitProcess();if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$Mf=>$K){$ma=convert_field($l[key($K)]);$M=array($ma?:idf_escape(key($K)));$Z[]=where_check($Mf,$l);$J=driver()->select($a,$M,$Z,$M);if($J)echo
first($J->fetch_row());}exit;}$ue=$Of=array();foreach($u
as$t){if($t["type"]=="PRIMARY"){$ue=array_flip($t["columns"]);$Of=($M?$ue:array());foreach($Of
as$v=>$W){if(in_array(idf_escape($v),$M))unset($Of[$v]);}break;}}if($Rd&&!$ue){$ue=$Of=array($Rd=>0);$u[]=array("type"=>"PRIMARY","columns"=>array($Rd));}if($_POST&&!$j){$fg=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Ja=array();foreach($_POST["check"]as$Ha)$Ja[]=where_check($Ha,$l);$fg[]="((".implode(") OR (",$Ja)."))";}$fg=($fg?"\nWHERE ".implode(" AND ",$fg):"");if($_POST["export"]){save_settings(array("output"=>$_POST["output"],"format"=>$_POST["format"]),"adminer_import");dump_headers($a);adminer()->dumpTable($a,"");$kc=($M?implode(", ",$M):"*").convert_fields($d,$l,$M)."\nFROM ".table($a);$qc=($p&&$Vc?"\nGROUP BY ".implode(", ",$p):"").($D?"\nORDER BY ".implode(", ",$D):"");$H="SELECT $kc$fg$qc";if(is_array($_POST["check"])&&!$ue){$Kf=array();foreach($_POST["check"]as$W)$Kf[]="(SELECT".limit($kc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($W,$l).$qc,1).")";$H=implode(" UNION ALL ",$Kf);}adminer()->dumpData($a,"table",$H);adminer()->dumpFooter();exit;}if(!adminer()->selectEmailProcess($Z,$hc)){if($_POST["save"]||$_POST["delete"]){$I=true;$ga=0;$O=array();if(!$_POST["delete"]){foreach($l
as$A=>$W){$s=bracket_escape($A);if(isset($_POST["fields"][$s])||$_FILES["fields-$s"]){$W=process_input($l[$A]);if($W!==null&&($_POST["clone"]||$W!==false))$O[idf_escape($A)]=($W!==false?$W:idf_escape($A));}}}if($_POST["delete"]||$O){$H=($_POST["clone"]?"INTO ".table($a)." (".implode(", ",array_keys($O)).")\nSELECT ".implode(", ",$O)."\nFROM ".table($a):"");if($_POST["all"]||($ue&&is_array($_POST["check"]))||$Vc){$I=($_POST["delete"]?driver()->delete($a,$fg):($_POST["clone"]?queries("INSERT $H$fg".driver()->insertReturning($a)):driver()->update($a,$O,$fg)));$ga=connection()->affected_rows;if(is_object($I))$ga+=$I->num_rows;}else{foreach((array)$_POST["check"]as$W){$eg="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($W,$l);$I=($_POST["delete"]?driver()->delete($a,$eg,1):($_POST["clone"]?queries("INSERT".limit1($a,$H,$eg)):driver()->update($a,$O,$eg,1)));if(!$I)break;$ga+=connection()->affected_rows;}}}$Cd=lang(79,$ga);if($_POST["clone"]&&$I&&$ga==1){$jd=last_id($I);if($jd)$Cd=lang(78," $jd");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$Cd,$I);if(!$_POST["delete"]){$re=(array)$_POST["fields"];edit_form($a,array_intersect_key($l,$re),$re,!$_POST["clone"],$j);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$j=lang(80);else{$I=true;$ga=0;foreach($_POST["val"]as$Mf=>$K){$O=array();foreach($K
as$v=>$W){$v=bracket_escape($v,true);$O[idf_escape($v)]=(preg_match('~char|text~',$l[$v]["type"])||$W!=""?adminer()->processInput($l[$v],$W):"NULL");}$I=driver()->update($a,$O," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($Mf,$l),($Vc||$ue?0:1)," ");if(!$I)break;$ga+=connection()->affected_rows;}queries_redirect(remove_from_uri(),lang(79,$ga),$I);}}elseif(!is_string($Wb=get_file("csv_file",true)))$j=upload_error($Wb);elseif(!preg_match('~~u',$Wb))$j=lang(81);else{save_settings(array("output"=>$fa["output"],"format"=>$_POST["separator"]),"adminer_import");$I=true;$Ra=array_keys($l);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$Wb,$td);$ga=count($td[0]);driver()->begin();$Te=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$L=array();foreach($td[0]as$v=>$W){preg_match_all("~((?>\"[^\"]*\")+|[^$Te]*)$Te~",$W.$Te,$ud);if(!$v&&!array_diff($ud[1],$Ra)){$Ra=$ud[1];$ga--;}else{$O=array();foreach($ud[1]as$q=>$Oa)$O[idf_escape($Ra[$q])]=($Oa==""&&$l[$Ra[$q]]["null"]?"NULL":q(preg_match('~^".*"$~s',$Oa)?str_replace('""','"',substr($Oa,1,-1)):$Oa));$L[]=$O;}}$I=(!$L||driver()->insertUpdate($a,$L,$ue));if($I)driver()->commit();queries_redirect(remove_from_uri("page"),lang(82,$ga),$I);driver()->rollback();}}}$pf=adminer()->tableName($R);if(is_ajax()){page_headers();ob_start();}else
page_header(lang(40).": $pf",$j);$O=null;if(isset($Ke["insert"])||!support("table")){$ge=array();foreach((array)$_GET["where"]as$W){if(isset($hc[$W["col"]])&&count($hc[$W["col"]])==1&&($W["op"]=="="||(!$W["op"]&&(is_array($W["val"])||!preg_match('~[_%]~',$W["val"])))))$ge["set"."[".bracket_escape($W["col"])."]"]=$W["val"];}$O=$ge?"&".http_build_query($ge):"";}adminer()->selectLinks($R,$O);if(!$d&&support("table"))echo"".lang(83).($l?".":": ".error())."\n";else{echo"
\n";$E=$_GET["page"];$jc=null;if($E=="last"){$jc=get_val(count_rows($a,$Z,$Vc,$p));$E=floor(max(0,intval($jc)-1)/$w);}$Pe=$M;$pc=$p;if(!$Pe){$Pe[]="*";$Za=convert_fields($d,$l,$M);if($Za)$Pe[]=substr($Za,2);}foreach($M
as$v=>$W){$k=$l[idf_unescape($W)];if($k&&($ma=convert_field($k)))$Pe[$v]="$ma AS $W";}if(!$Vc&&$Of){foreach($Of
as$v=>$W){$Pe[]=idf_escape($v);if($pc)$pc[]=idf_escape($v);}}$I=driver()->select($a,$Pe,$Z,$pc,$D,$w,$E,true);if(!$I)echo"".error()."\n";else{if(JUSH=="mssql"&&$E)$I->seek($w*$E);$Cb=array();echo"
\n",(!$p&&$M?"":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,$A)=adminer()->_foreignColumn(column_foreign_keys($_GET["source"]),$_GET["field"])){$w=11;$I=connection()->query("SELECT $r, $A FROM ".table($Q)." WHERE ".(preg_match('~^[0-9]+$~',$_GET["value"])?"$r = $_GET[value] OR ":"")."$A LIKE ".q("$_GET[value]%")." ORDER BY 2 LIMIT $w");for($q=1;($K=$I->fetch_row())&&$q<$w;$q++)echo"".h($K[1])."
\n";if($K)echo"...\n";}exit;}else{page_header(lang(56),"",false);if(adminer()->homepage()){echo"\n",script("tableCheck();");adminer()->pluginsLinks();}}page_footer();