';$Je=array("select"=>lang(40));if(support("table")||support("indexes"))$Je["table"]=lang(41);$pe=false;if(support("table")){$pe=is_view($hi);if($pe)$Je["view"]=lang(42);else$Je["create"]=lang(43);}if($O!==null)$Je["edit"]=lang(44);$C=$hi["Name"];foreach($Je
as$y=>$X)echo" $X";echo
doc_link(array(JUSH=>driver()->tableHelp($C,$pe)),"?"),"\n";}function
foreignKeys($R){return
foreign_keys($R);}function
backwardKeys($R,$gi){return
array();}function
backwardKeysPrint(array$Fa,array$K){}function
selectQuery($H,$Xh,$Sc=false){$J="
\n";if(!$Sc&&($yj=driver()->warnings())){$u="warnings";$J=", ".(driver()->functions||driver()->grouping?html_select("columns[$t][fun]",array(-1=>"")+array_filter(array(lang(53)=>driver()->functions,lang(54)=>driver()->grouping)),$X["fun"]).on_help("event.target.value && event.target.value.replace(/ |\$/, '(') + ')'",1).script("qsl('select').onchange = function () { helpClose();".($y!==""?"":" qsl('select, input', this.parentNode).onchange();")." };","")."($d)":$d)."
\n";$t++;}echo"\n";}function
selectSearchPrint(array$Z,array$e,array$x){print_fieldset("search",lang(55),$Z);foreach($x
as$t=>$w){if($w["type"]=="FULLTEXT")echo"".select_input(" name='where[$t][col]'",$e,$X["col"],($X?"selectFieldChange":"selectAddRow"),"(".lang(56).")"),html_select("where[$t][op]",adminer()->operators(),$X["op"],$Ua),"",script("mixin(qsl('input'), {oninput: function () { $Ua }, onkeydown: selectSearchKeydown, onsearch: selectSearchSearch});",""),"
\n";}echo"\n";}function
selectOrderPrint(array$Rf,array$e,array$x){print_fieldset("sort",lang(57),$Rf);$t=0;foreach((array)$_GET["order"]as$y=>$X){if($X!=""){echo"".select_input(" name='order[$t]'",$e,$X,"selectFieldChange"),checkbox("desc[$t]",1,isset($_GET["desc"][$y]),lang(58))."
\n";$t++;}}echo"".select_input(" name='order[$t]'",$e,"","selectAddRow"),checkbox("desc[$t]",1,false,lang(58))."
\n","\n";}function
selectLimitPrint($_){echo"($C) ".h($V.($N!=""?"@".adminer()->serverName($N):"").($k!=""?" - $k":""))."\n";}}}}if($eg)echo"\n".script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");}else{$T=array();if($_GET["ns"]!==""&&!$if&&DB!=""){connection()->select_db(DB);$T=table_status('',true);}adminer()->syntaxHighlighting($T);adminer()->databasesPrint($if);$ka=array();if(DB==""||!$if){if(support("sql")){$ka[]="".lang(63)."";$ka[]="".lang(71)."";}$ka[]="".lang(72)."";}$Vd=$_GET["ns"]!==""&&!$if&&DB!="";if($Vd)$ka[]='".lang(73)."";echo($ka?"\n".implode("\n",$ka)."\n":"");if($Vd){if($T)adminer()->tablesPrint($T);else
echo"
".lang(9)."
\n";}}}function
syntaxHighlighting(array$T){echo
script_src(preg_replace("~\\?.*~","",ME)."?file=jush.js&version=5.2.1",true);if(support("sql")){echo"\n";}echo
script("syntaxHighlighting('".preg_replace('~^(\d\.?\d).*~s','\1',connection()->server_info)."', '".connection()->flavor."');");}function
databasesPrint($if){$j=adminer()->databases();if(DB&&$j&&!in_array(DB,$j))array_unshift($j,DB);echo"\n";}function
tablesPrint(array$T){echo"".script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($T
as$R=>$P){$R="$R";$C=adminer()->tableName($P);if($C!="")echo'- ".lang(76)." ",(support("table")||support("indexes")?'$C":"$C")."\n";}echo"
\n";}}class
Plugins{private
static$va=array('dumpFormat'=>true,'dumpOutput'=>true,'editRowPrint'=>true,'editFunctions'=>true,'config'=>true);var$plugins;var$error='';private$hooks=array();function
__construct($xg){if($xg===null){$xg=array();$Ja="adminer-plugins";if(is_dir($Ja)){foreach(glob("$Ja/*.php")as$p)$Wd=include_once"./$p";}$Hd=" href='https://www.adminer.org/plugins/#use'".target_blank();if(file_exists("$Ja.php")){$Wd=include_once"./$Ja.php";if(is_array($Wd)){foreach($Wd
as$wg)$xg[get_class($wg)]=$wg;}else$this->error
.=lang(77,"$Ja.php",$Hd)."
";}foreach(get_declared_classes()as$eb){if(!$xg[$eb]&&preg_match('~^Adminer\w~i',$eb)){$Yg=new
\ReflectionClass($eb);$xb=$Yg->getConstructor();if($xb&&$xb->getNumberOfRequiredParameters())$this->error
.=lang(78,$Hd,"$eb","$Ja.php")."
";else$xg[$eb]=new$eb;}}}$this->plugins=$xg;$na=new
Adminer;$xg[]=$na;$Yg=new
\ReflectionObject($na);foreach($Yg->getMethods()as$gf){foreach($xg
as$wg){$C=$gf->getName();if(method_exists($wg,$C))$this->hooks[$C][]=$wg;}}}function
__call($C,array$jg){$wa=array();foreach($jg
as$y=>$X)$wa[]=&$jg[$y];$J=null;foreach($this->hooks[$C]as$wg){$Y=call_user_func_array(array($wg,$C),$wa);if($Y!==null){if(!self::$va[$C])return$Y;$J=$Y+(array)$J;}}return$J;}}abstract
class
Plugin{protected$translations=array();function
description(){return$this->lang('');}function
screenshot(){return"";}protected
function
lang($v,$yf=null){$wa=func_get_args();$wa[0]=idx($this->translations[LANG],$v)?:$v;return
call_user_func_array('Adminer\lang_format',$wa);}}Adminer::$he=(function_exists('adminer_object')?adminer_object():(is_dir("adminer-plugins")||file_exists("adminer-plugins.php")?new
Plugins(null):new
Adminer));SqlDriver::$gc=array("server"=>"MySQL / MariaDB")+SqlDriver::$gc;if(!defined('Adminer\DRIVER')){define('Adminer\DRIVER',"server");if(extension_loaded("mysqli")&&$_GET["ext"]!="pdo"){class
Db
extends
\MySQLi{static$he;var$extension="MySQLi",$flavor='';function
__construct(){parent::init();}function
attach($N,$V,$F){mysqli_report(MYSQLI_REPORT_OFF);list($Ld,$yg)=explode(":",$N,2);$Wh=adminer()->connectSsl();if($Wh)$this->ssl_set($Wh['key'],$Wh['cert'],$Wh['ca'],'','');$J=@$this->real_connect(($N!=""?$Ld:ini_get("mysqli.default_host")),($N.$V!=""?$V:ini_get("mysqli.default_user")),($N.$V.$F!=""?$F:ini_get("mysqli.default_pw")),null,(is_numeric($yg)?intval($yg):ini_get("mysqli.default_port")),(is_numeric($yg)?$yg:null),($Wh?($Wh['verify']!==false?2048:64):0));$this->options(MYSQLI_OPT_LOCAL_INFILE,false);return($J?'':$this->error);}function
set_charset($Wa){if(parent::set_charset($Wa))return
true;parent::set_charset('utf8');return$this->query("SET NAMES $Wa");}function
next_result(){return
self::more_results()&&parent::next_result();}function
quote($Q){return"'".$this->escape_string($Q)."'";}}}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,$V,$F){if(ini_bool("mysql.allow_local_infile"))return
lang(79,"'mysql.allow_local_infile'","MySQLi","PDO_MySQL");$this->link=@mysql_connect(($N!=""?$N:ini_get("mysql.default_host")),("$N$V"!=""?$V:ini_get("mysql.default_user")),("$N$V$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($Wa){if(function_exists('mysql_set_charset')){if(mysql_set_charset($Wa,$this->link))return
true;mysql_set_charset('utf8',$this->link);}return$this->query("SET NAMES $Wa");}function
quote($Q){return"'".mysql_real_escape_string($Q,$this->link)."'";}function
select_db($Nb){return
mysql_select_db($Nb,$this->link);}function
query($H,$Xi=false){$I=@($Xi?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,$V,$F){$Pf=array(\PDO::MYSQL_ATTR_LOCAL_INFILE=>false);$Wh=adminer()->connectSsl();if($Wh){if($Wh['key'])$Pf[\PDO::MYSQL_ATTR_SSL_KEY]=$Wh['key'];if($Wh['cert'])$Pf[\PDO::MYSQL_ATTR_SSL_CERT]=$Wh['cert'];if($Wh['ca'])$Pf[\PDO::MYSQL_ATTR_SSL_CA]=$Wh['ca'];if(isset($Wh['verify']))$Pf[\PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT]=$Wh['verify'];}return$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\d)~',';port=\1',$N)),$V,$F,$Pf);}function
set_charset($Wa){return$this->query("SET NAMES $Wa");}function
select_db($Nb){return$this->query("USE ".idf_escape($Nb));}function
query($H,$Xi=false){$this->pdo->setAttribute(\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,!$Xi);return
parent::query($H,$Xi);}}}class
Driver
extends
SqlDriver{static$Pc=array("MySQLi","MySQL","PDO_MySQL");static$re="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,$V,$F){$g=parent::connect($N,$V,$F);if(is_string($g)){if(function_exists('iconv')&&!is_utf8($g)&&strlen($oh=iconv("windows-1250","utf-8",$g))>strlen($g))$g=$oh;return$g;}$g->set_charset(charset($g));$g->query("SET sql_quote_show_create = 1, autocommit = 1");$g->flavor=(preg_match('~MariaDB~',$g->server_info)?'maria':'mysql');add_driver(DRIVER,($g->flavor=='maria'?"MariaDB":"MySQL"));return$g;}function
__construct(Db$g){parent::__construct($g);$this->types=array(lang(25)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(26)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(27)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(80)=>array("enum"=>65535,"set"=>64),lang(28)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(30)=>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,$g))$this->types[lang(27)]["json"]=4294967295;if(min_version('',10.7,$g)){$this->types[lang(27)]["uuid"]=128;$this->insertFunctions['uuid']='uuid';}if(min_version(9,'',$g)){$this->types[lang(25)]["vector"]=16383;$this->insertFunctions['vector']='string_to_vector';}if(min_version(5.7,10.2,$g))$this->generated=array("STORED","VIRTUAL");}function
unconvertFunction(array$n){return(preg_match("~binary~",$n["type"])?"UNHEX":($n["type"]=="bit"?doc_link(array('sql'=>'bit-value-literals.html'),"b''"):(preg_match("~geometry|point|linestring|polygon~",$n["type"])?"GeomFromText":"")));}function
insert($R,array$O){return($O?parent::insert($R,$O):queries("INSERT INTO ".table($R)." ()\nVALUES ()"));}function
insertUpdate($R,array$L,array$G){$e=array_keys(reset($L));$Dg="INSERT INTO ".table($R)." (".implode(", ",$e).") VALUES\n";$qj=array();foreach($e
as$y)$qj[$y]="$y = VALUES($y)";$di="\nON DUPLICATE KEY UPDATE ".implode(", ",$qj);$qj=array();$z=0;foreach($L
as$O){$Y="(".implode(", ",$O).")";if($qj&&(strlen($Dg)+$z+strlen($Y)+strlen($di)>1e6)){if(!queries($Dg.implode(",\n",$qj).$di))return
false;$qj=array();$z=0;}$qj[]=$Y;$z+=strlen($Y)+2;}return
queries($Dg.implode(",\n",$qj).$di);}function
slowQuery($H,$_i){if(min_version('5.7.8','10.1.2')){if($this->conn->flavor=='maria')return"SET STATEMENT max_statement_time=$_i FOR $H";elseif(preg_match('~^(SELECT\b)(.+)~is',$H,$B))return"$B[1] /*+ MAX_EXECUTION_TIME(".($_i*1000).") */ $B[2]";}}function
convertSearch($v,array$X,array$n){return(preg_match('~char|text|enum|set~',$n["type"])&&!preg_match("~^utf8~",$n["collation"])&&preg_match('~[\x80-\xFF]~',$X['val'])?"CONVERT($v USING ".charset($this->conn).")":$v);}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($C,$pe=false){$Ne=($this->conn->flavor=='maria');if(information_schema(DB))return
strtolower("information-schema-".($Ne?"$C-table/":str_replace("_","-",$C)."-table.html"));if(DB=="mysql")return($Ne?"mysql$C-table/":"system-schema.html");}function
hasCStyleEscapes(){static$Ra;if($Ra===null){$Uh=get_val("SHOW VARIABLES LIKE 'sql_mode'",1,$this->conn);$Ra=(strpos($Uh,'NO_BACKSLASH_ESCAPES')===false);}return$Ra;}function
engines(){$J=array();foreach(get_rows("SHOW ENGINES")as$K){if(preg_match("~YES|DEFAULT~",$K["Support"]))$J[]=$K["Engine"];}return$J;}}function
idf_escape($v){return"`".str_replace("`","``",$v)."`";}function
table($v){return
idf_escape($v);}function
get_databases($gd){$J=get_session("dbs");if($J===null){$H="SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME";$J=($gd?slow_query($H):get_vals($H));restart_session();set_session("dbs",$J);stop_session();}return$J;}function
limit($H,$Z,$_,$D=0,$Ah=" "){return" $H$Z".($_?$Ah."LIMIT $_".($D?" OFFSET $D":""):"");}function
limit1($R,$H,$Z,$Ah="\n"){return
limit($H,$Z,1,0,$Ah);}function
db_collation($k,array$jb){$J=null;$i=get_val("SHOW CREATE DATABASE ".idf_escape($k),1);if(preg_match('~ COLLATE ([^ ]+)~',$i,$B))$J=$B[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$i,$B))$J=$jb[$B[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$j){$J=array();foreach($j
as$k)$J[$k]=count(get_vals("SHOW TABLES IN ".idf_escape($k)));return$J;}function
table_status($C="",$Tc=false){$J=array();foreach(get_rows($Tc?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($C!=""?"AND TABLE_NAME = ".q($C):"ORDER BY Name"):"SHOW TABLE STATUS".($C!=""?" LIKE ".q(addcslashes($C,"%_\\")):""))as$K){if($K["Engine"]=="InnoDB")$K["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\1',$K["Comment"]);if(!isset($K["Engine"]))$K["Comment"]="";if($C!="")$K["Name"]=$C;$J[$K["Name"]]=$K;}return$J;}function
is_view(array$S){return$S["Engine"]===null;}function
fk_support(array$S){return
preg_match('~InnoDB|IBMDB2I'.(min_version(5.6)?'|NDB':'').'~i',$S["Engine"]);}function
fields($R){$Ne=(connection()->flavor=='maria');$J=array();foreach(get_rows("SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = ".q($R)." ORDER BY ORDINAL_POSITION")as$K){$n=$K["COLUMN_NAME"];$U=$K["COLUMN_TYPE"];$sd=$K["GENERATION_EXPRESSION"];$Qc=$K["EXTRA"];preg_match('~^(VIRTUAL|PERSISTENT|STORED)~',$Qc,$rd);preg_match('~^([^( ]+)(?:\((.+)\))?( unsigned)?( zerofill)?$~',$U,$Qe);$l=$K["COLUMN_DEFAULT"];if($l!=""){$oe=preg_match('~text|json~',$Qe[1]);if(!$Ne&&$oe)$l=preg_replace("~^(_\w+)?('.*')$~",'\2',stripslashes($l));if($Ne||$oe){$l=($l=="NULL"?null:preg_replace_callback("~^'(.*)'$~",function($B){return
stripslashes(str_replace("''","'",$B[1]));},$l));}if(!$Ne&&preg_match('~binary~',$Qe[1])&&preg_match('~^0x(\w*)$~',$l,$B))$l=pack("H*",$B[1]);}$J[$n]=array("field"=>$n,"full_type"=>$U,"type"=>$Qe[1],"length"=>$Qe[2],"unsigned"=>ltrim($Qe[3].$Qe[4]),"default"=>($rd?($Ne?$sd:stripslashes($sd)):$l),"null"=>($K["IS_NULLABLE"]=="YES"),"auto_increment"=>($Qc=="auto_increment"),"on_update"=>(preg_match('~\bon update (\w+)~i',$Qc,$B)?$B[1]:""),"collation"=>$K["COLLATION_NAME"],"privileges"=>array_flip(explode(",","$K[PRIVILEGES],where,order")),"comment"=>$K["COLUMN_COMMENT"],"primary"=>($K["COLUMN_KEY"]=="PRI"),"generated"=>($rd[1]=="PERSISTENT"?"STORED":$rd[1]),);}return$J;}function
indexes($R,$h=null){$J=array();foreach(get_rows("SHOW INDEX FROM ".table($R),$h)as$K){$C=$K["Key_name"];$J[$C]["type"]=($C=="PRIMARY"?"PRIMARY":($K["Index_type"]=="FULLTEXT"?"FULLTEXT":($K["Non_unique"]?($K["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$J[$C]["columns"][]=$K["Column_name"];$J[$C]["lengths"][]=($K["Index_type"]=="SPATIAL"?null:$K["Sub_part"]);$J[$C]["descs"][]=null;}return$J;}function
foreign_keys($R){static$sg='(?:`(?:[^`]|``)+`|"(?:[^"]|"")+")';$J=array();$Db=get_val("SHOW CREATE TABLE ".table($R),1);if($Db){preg_match_all("~CONSTRAINT ($sg) FOREIGN KEY ?\\(((?:$sg,? ?)+)\\) REFERENCES ($sg)(?:\\.($sg))? \\(((?:$sg,? ?)+)\\)(?: ON DELETE (".driver()->onActions."))?(?: ON UPDATE (".driver()->onActions."))?~",$Db,$Re,PREG_SET_ORDER);foreach($Re
as$B){preg_match_all("~$sg~",$B[2],$Oh);preg_match_all("~$sg~",$B[5],$si);$J[idf_unescape($B[1])]=array("db"=>idf_unescape($B[4]!=""?$B[3]:$B[4]),"table"=>idf_unescape($B[4]!=""?$B[4]:$B[3]),"source"=>array_map('Adminer\idf_unescape',$Oh[0]),"target"=>array_map('Adminer\idf_unescape',$si[0]),"on_delete"=>($B[6]?:"RESTRICT"),"on_update"=>($B[7]?:"RESTRICT"),);}}return$J;}function
view($C){return
array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\s+AS\s+~isU','',get_val("SHOW CREATE VIEW ".table($C),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$y=>$X)sort($J[$y]);return$J;}function
information_schema($k){return($k=="information_schema")||(min_version(5.5)&&$k=="performance_schema");}function
error(){return
h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",connection()->error));}function
create_database($k,$c){return
queries("CREATE DATABASE ".idf_escape($k).($c?" COLLATE ".q($c):""));}function
drop_databases(array$j){$J=apply_queries("DROP DATABASE",$j,'Adminer\idf_escape');restart_session();set_session("dbs",null);return$J;}function
rename_database($C,$c){$J=false;if(create_database($C,$c)){$T=array();$vj=array();foreach(tables_list()as$R=>$U){if($U=='VIEW')$vj[]=$R;else$T[]=$R;}$J=(!$T&&!$vj)||move_tables($T,$vj,$C);drop_databases($J?array(DB):array());}return$J;}function
auto_increment(){$Ca=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$w){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$w["columns"],true)){$Ca="";break;}if($w["type"]=="PRIMARY")$Ca=" UNIQUE";}}return" AUTO_INCREMENT$Ca";}function
alter_table($R,$C,array$o,array$id,$ob,$xc,$c,$Ba,$og){$b=array();foreach($o
as$n){if($n[1]){$l=$n[1][3];if(preg_match('~ GENERATED~',$l)){$n[1][3]=(connection()->flavor=='maria'?"":$n[1][2]);$n[1][2]=$l;}$b[]=($R!=""?($n[0]!=""?"CHANGE ".idf_escape($n[0]):"ADD"):" ")." ".implode($n[1]).($R!=""?$n[2]:"");}else$b[]="DROP ".idf_escape($n[0]);}$b=array_merge($b,$id);$P=($ob!==null?" COMMENT=".q($ob):"").($xc?" ENGINE=".q($xc):"").($c?" COLLATE ".q($c):"").($Ba!=""?" AUTO_INCREMENT=$Ba":"");if($R=="")return
queries("CREATE TABLE ".table($C)." (\n".implode(",\n",$b)."\n)$P$og");if($R!=$C)$b[]="RENAME TO ".table($C);if($P)$b[]=ltrim($P);return($b||$og?queries("ALTER TABLE ".table($R)."\n".implode(",\n",$b).$og):true);}function
alter_indexes($R,$b){$Va=array();foreach($b
as$X)$Va[]=($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($R).implode(",",$Va));}function
truncate_tables(array$T){return
apply_queries("TRUNCATE TABLE",$T);}function
drop_views(array$vj){return
queries("DROP VIEW ".implode(", ",array_map('Adminer\table',$vj)));}function
drop_tables(array$T){return
queries("DROP TABLE ".implode(", ",array_map('Adminer\table',$T)));}function
move_tables(array$T,array$vj,$si){$ch=array();foreach($T
as$R)$ch[]=table($R)." TO ".idf_escape($si).".".table($R);if(!$ch||queries("RENAME TABLE ".implode(", ",$ch))){$Vb=array();foreach($vj
as$R)$Vb[table($R)]=view($R);connection()->select_db($si);$k=idf_escape(DB);foreach($Vb
as$C=>$uj){if(!queries("CREATE VIEW $C AS ".str_replace(" $k."," ",$uj["select"]))||!queries("DROP VIEW $k.$C"))return
false;}return
true;}return
false;}function
copy_tables(array$T,array$vj,$si){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($T
as$R){$C=($si==DB?table("copy_$R"):idf_escape($si).".".table($R));if(($_POST["overwrite"]&&!queries("\nDROP TABLE IF EXISTS $C"))||!queries("CREATE TABLE $C LIKE ".table($R))||!queries("INSERT INTO $C SELECT * FROM ".table($R)))return
false;foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($R,"%_\\")))as$K){$Qi=$K["Trigger"];if(!queries("CREATE TRIGGER ".($si==DB?idf_escape("copy_$Qi"):idf_escape($si).".".idf_escape($Qi))." $K[Timing] $K[Event] ON $C FOR EACH ROW\n$K[Statement];"))return
false;}}foreach($vj
as$R){$C=($si==DB?table("copy_$R"):idf_escape($si).".".table($R));$uj=view($R);if(($_POST["overwrite"]&&!queries("DROP VIEW IF EXISTS $C"))||!queries("CREATE VIEW $C AS $uj[select]"))return
false;}return
true;}function
trigger($C,$R){if($C=="")return
array();$L=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($C));return
reset($L);}function
triggers($R){$J=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($R,"%_\\")))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($C,$U){$ta=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$Ph="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|-- )[^\n]*\n?|--\r?\n)";$zc=driver()->enumLength;$Vi="((".implode("|",array_merge(array_keys(driver()->types()),$ta)).")\\b(?:\\s*\\(((?:[^'\")]|$zc)++)\\))?"."\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$sg="$Ph*(".($U=="FUNCTION"?"":driver()->inout).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$Vi";$i=get_val("SHOW CREATE $U ".idf_escape($C),2);preg_match("~\\(((?:$sg\\s*,?)*)\\)\\s*".($U=="FUNCTION"?"RETURNS\\s+$Vi\\s+":"")."(.*)~is",$i,$B);$o=array();preg_match_all("~$sg\\s*,?~is",$B[1],$Re,PREG_SET_ORDER);foreach($Re
as$ig)$o[]=array("field"=>str_replace("``","`",$ig[2]).$ig[3],"type"=>strtolower($ig[5]),"length"=>preg_replace_callback("~$zc~s",'Adminer\normalize_enum',$ig[6]),"unsigned"=>strtolower(preg_replace('~\s+~',' ',trim("$ig[8] $ig[7]"))),"null"=>true,"full_type"=>$ig[4],"inout"=>strtoupper($ig[1]),"collation"=>strtolower($ig[9]),);return
array("fields"=>$o,"comment"=>get_val("SELECT ROUTINE_COMMENT FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = DATABASE() AND ROUTINE_NAME = ".q($C)),)+($U!="FUNCTION"?array("definition"=>$B[11]):array("returns"=>array("type"=>$B[12],"length"=>$B[13],"unsigned"=>$B[15],"collation"=>$B[16]),"definition"=>$B[17],"language"=>"SQL",));}function
routines(){return
get_rows("SELECT ROUTINE_NAME AS SPECIFIC_NAME, ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = DATABASE()");}function
routine_languages(){return
array();}function
routine_id($C,array$K){return
idf_escape($C);}function
last_id($I){return
get_val("SELECT LAST_INSERT_ID()");}function
explain(Db$g,$H){return$g->query("EXPLAIN ".(min_version(5.1)&&!min_version(5.7)?"PARTITIONS ":"").$H);}function
found_rows(array$S,array$Z){return($Z||$S["Engine"]!="InnoDB"?null:$S["Rows"]);}function
create_sql($R,$Ba,$bi){$J=get_val("SHOW CREATE TABLE ".table($R),1);if(!$Ba)$J=preg_replace('~ AUTO_INCREMENT=\d+~','',$J);return$J;}function
truncate_sql($R){return"TRUNCATE ".table($R);}function
use_sql($Nb){return"USE ".idf_escape($Nb);}function
trigger_sql($R){$J="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($R,"%_\\")),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$n){if(preg_match("~binary~",$n["type"]))return"HEX(".idf_escape($n["field"]).")";if($n["type"]=="bit")return"BIN(".idf_escape($n["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$n["type"]))return(min_version(8)?"ST_":"")."AsWKT(".idf_escape($n["field"]).")";}function
unconvert_field(array$n,$J){if(preg_match("~binary~",$n["type"]))$J="UNHEX($J)";if($n["type"]=="bit")$J="CONVERT(b$J, UNSIGNED)";if(preg_match("~geometry|point|linestring|polygon~",$n["type"])){$Dg=(min_version(8)?"ST_":"");$J=$Dg."GeomFromText($J, $Dg"."SRID($n[field]))";}return$J;}function
support($Uc){return!preg_match("~scheme|sequence|type|view_trigger|materializedview".(min_version(8)?"":"|descidx".(min_version(5.1)?"":"|event|partitioning")).(min_version('8.0.16','10.2.1')?"":"|check")."~",$Uc);}function
kill_process($X){return
queries("KILL ".number($X));}function
connection_id(){return"SELECT CONNECTION_ID()";}function
max_connections(){return
get_val("SELECT @@max_connections");}function
types(){return
array();}function
type_values($u){return"";}function
schemas(){return
array();}function
get_schema(){return"";}function
set_schema($qh,$h=null){return
true;}}define('Adminer\JUSH',Driver::$re);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($Bi,$m="",$Oa=array(),$Ci=""){page_headers();if(is_ajax()&&$m){page_messages($m);exit;}if(!ob_get_level())ob_start('ob_gzhandler',4096);$Di=$Bi.($Ci!=""?": $Ci":"");$Ei=strip_tags($Di.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".adminer()->name());echo'
',$Ei,'
';$Hb=adminer()->css();$Dd=false;$Bd=false;foreach($Hb
as$p){if(strpos($p,"adminer.css")!==false)$Dd=true;if(strpos($p,"adminer-dark.css")!==false)$Bd=true;}$Kb=($Dd?($Bd?null:false):($Bd?:null));$Ze=" media='(prefers-color-scheme: dark)'";if($Kb!==false)echo"\n";echo"\n",script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=5.2.1");if(adminer()->head($Kb))echo"\n","\n";foreach($Hb
as$X)echo"\n";echo"\n\n";$p=get_temp_dir()."/adminer.version";if(!$_COOKIE["adminer_version"]&&function_exists('openssl_verify')&&file_exists($p)&&filemtime($p)+86400>time()){$tj=unserialize(file_get_contents($p));$Mg="-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwqWOVuF5uw7/+Z70djoK
RlHIZFZPO0uYRezq90+7Amk+FDNd7KkL5eDve+vHRJBLAszF/7XKXe11xwliIsFs
DFWQlsABVZB3oisKCBEuI71J4kPH8dKGEWR9jDHFw3cWmoH3PmqImX6FISWbG3B8
h7FIx3jEaw5ckVPVTeo5JRm/1DZzJxjyDenXvBQ/6o9DgZKeNDgxwKzH+sw9/YCO
jHnq1cFpOIISzARlrHMa/43YfeNRAm/tsBXjSxembBPo7aQZLAWHmaj5+K19H10B
nCpz9Y++cipkVEiKRGih4ZEvjoFysEOdRLj6WiD/uUNky4xGeA6LaJqh5XpkFkcQ
fQIDAQAB
-----END PUBLIC KEY-----
";if(openssl_verify($tj["version"],base64_decode($tj["signature"]),$Mg)==1)$_COOKIE["adminer_version"]=$tj["version"];}echo
script("mixin(document.body, {onkeydown: bodyKeydown, onclick: bodyClick".(isset($_COOKIE["adminer_version"])?"":", onload: partial(verifyVersion, '".VERSION."', '".js_escape(ME)."', '".get_token()."')")."});
document.body.classList.replace('nojs', 'js');
const offlineMessage = '".js_escape(lang(82))."';
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($Oa!==null){$A=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'
'.get_driver(DRIVER).' » ';$A=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$N=adminer()->serverName(SERVER);$N=($N!=""?$N:lang(33));if($Oa===false)echo"$N\n";else{echo"$N » ";if($_GET["ns"]!=""||(DB!=""&&is_array($Oa)))echo''.h(DB).' » ';if(is_array($Oa)){if($_GET["ns"]!="")echo''.h($_GET["ns"]).' » ';foreach($Oa
as$y=>$X){$Xb=(is_array($X)?$X[1]:h($X));if($Xb!="")echo"$Xb » ";}}echo"$Bi\n";}}echo"
$Di
\n","
\n";restart_session();page_messages($m);$j=&get_session("dbs");if(DB!=""&&$j&&!in_array(DB,$j,true))$j=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$Gb){$Fd=array();foreach($Gb
as$y=>$X)$Fd[]="$y $X";header("Content-Security-Policy: ".implode("; ",$Fd));}adminer()->headers();}function
csp(){return
array(array("script-src"=>"'self' 'unsafe-inline' 'nonce-".get_nonce()."' 'strict-dynamic'","connect-src"=>"'self'","frame-src"=>"https://www.adminer.org","object-src"=>"'none'","base-uri"=>"'none'","form-action"=>"'self'",),);}function
get_nonce(){static$vf;if(!$vf)$vf=base64_encode(rand_string());return$vf;}function
page_messages($m){$gj=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$ff=idx($_SESSION["messages"],$gj);if($ff){echo"
".implode("
\n
",$ff)."
".script("messagesPrint();");unset($_SESSION["messages"][$gj]);}if($m)echo"
$m
\n";if(adminer()->error)echo"
".adminer()->error."
\n";}function
page_footer($if=""){echo"
\n\n\n\n",script("setupSubmitHighlight(document);");}function
int32($nf){while($nf>=2147483648)$nf-=4294967296;while($nf<=-2147483649)$nf+=4294967296;return(int)$nf;}function
long2str(array$W,$xj){$oh='';foreach($W
as$X)$oh
.=pack('V',$X);if($xj)return
substr($oh,0,end($W));return$oh;}function
str2long($oh,$xj){$W=array_values(unpack('V*',str_pad($oh,4*ceil(strlen($oh)/4),"\0")));if($xj)$W[]=strlen($oh);return$W;}function
xxtea_mx($Dj,$Cj,$ei,$se){return
int32((($Dj>>5&0x7FFFFFF)^$Cj<<2)+(($Cj>>3&0x1FFFFFFF)^$Dj<<4))^int32(($ei^$Cj)+($se^$Dj));}function
encrypt_string($Zh,$y){if($Zh=="")return"";$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($Zh,true);$nf=count($W)-1;$Dj=$W[$nf];$Cj=$W[0];$Ng=floor(6+52/($nf+1));$ei=0;while($Ng-->0){$ei=int32($ei+0x9E3779B9);$oc=$ei>>2&3;for($gg=0;$gg<$nf;$gg++){$Cj=$W[$gg+1];$mf=xxtea_mx($Dj,$Cj,$ei,$y[$gg&3^$oc]);$Dj=int32($W[$gg]+$mf);$W[$gg]=$Dj;}$Cj=$W[0];$mf=xxtea_mx($Dj,$Cj,$ei,$y[$gg&3^$oc]);$Dj=int32($W[$nf]+$mf);$W[$nf]=$Dj;}return
long2str($W,false);}function
decrypt_string($Zh,$y){if($Zh=="")return"";if(!$y)return
false;$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($Zh,false);$nf=count($W)-1;$Dj=$W[$nf];$Cj=$W[0];$Ng=floor(6+52/($nf+1));$ei=int32($Ng*0x9E3779B9);while($ei){$oc=$ei>>2&3;for($gg=$nf;$gg>0;$gg--){$Dj=$W[$gg-1];$mf=xxtea_mx($Dj,$Cj,$ei,$y[$gg&3^$oc]);$Cj=int32($W[$gg]-$mf);$W[$gg]=$Cj;}$Dj=$W[$nf];$mf=xxtea_mx($Dj,$Cj,$ei,$y[$gg&3^$oc]);$Cj=int32($W[0]-$mf);$W[0]=$Cj;$ei=int32($ei-0x9E3779B9);}return
long2str($W,true);}$ug=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($y)=explode(":",$X);$ug[$y]=$X;}}function
add_invalid_login(){$Ha=get_temp_dir()."/adminer.invalid";foreach(glob("$Ha*")?:array($Ha)as$p){$r=file_open_lock($p);if($r)break;}if(!$r)$r=file_open_lock("$Ha-".rand_string());if(!$r)return;$ke=unserialize(stream_get_contents($r));$zi=time();if($ke){foreach($ke
as$le=>$X){if($X[0]<$zi)unset($ke[$le]);}}$je=&$ke[adminer()->bruteForceKey()];if(!$je)$je=array($zi+30*60,0);$je[1]++;file_write_unlock($r,serialize($ke));}function
check_invalid_login(array&$ug){$ke=array();foreach(glob(get_temp_dir()."/adminer.invalid*")as$p){$r=file_open_lock($p);if($r){$ke=unserialize(stream_get_contents($r));file_unlock($r);break;}}$je=idx($ke,adminer()->bruteForceKey(),array());$uf=($je[1]>29?$je[0]-time():0);if($uf>0)auth_error(lang(84,ceil($uf/60)),$ug);}$Aa=$_POST["auth"];if($Aa){session_regenerate_id();$sj=$Aa["driver"];$N=$Aa["server"];$V=$Aa["username"];$F=(string)$Aa["password"];$k=$Aa["db"];set_password($sj,$N,$V,$F);$_SESSION["db"][$sj][$N][$V][$k]=true;if($Aa["permanent"]){$y=implode("-",array_map('base64_encode',array($sj,$N,$V,$k)));$Hg=adminer()->permanentLogin(true);$ug[$y]="$y:".base64_encode($Hg?encrypt_string($F,$Hg):"");cookie("adminer_permanent",implode(" ",$ug));}if(count($_POST)==1||DRIVER!=$sj||SERVER!=$N||$_GET["username"]!==$V||DB!=$k)redirect(auth_url($sj,$N,$V,$k));}elseif($_POST["logout"]&&(!$_SESSION["token"]||verify_token())){foreach(array("pwds","db","dbs","queries")as$y)set_session($y,null);unset_permanent($ug);redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),lang(85).' '.lang(86));}elseif($ug&&!$_SESSION["pwds"]){session_regenerate_id();$Hg=adminer()->permanentLogin();foreach($ug
as$y=>$X){list(,$db)=explode(":",$X);list($sj,$N,$V,$k)=array_map('base64_decode',explode("-",$y));set_password($sj,$N,$V,decrypt_string(base64_decode($db),$Hg));$_SESSION["db"][$sj][$N][$V][$k]=true;}}function
unset_permanent(array&$ug){foreach($ug
as$y=>$X){list($sj,$N,$V,$k)=array_map('base64_decode',explode("-",$y));if($sj==DRIVER&&$N==SERVER&&$V==$_GET["username"]&&$k==DB)unset($ug[$y]);}cookie("adminer_permanent",implode(" ",$ug));}function
auth_error($m,array&$ug){$Gh=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$Gh]||$_GET[$Gh])&&!$_SESSION["token"])$m=lang(87);else{restart_session();add_invalid_login();$F=get_password();if($F!==null){if($F===false)$m
.=($m?'
':'').lang(88,target_blank(),'permanentLogin()');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent($ug);}}if(!$_COOKIE[$Gh]&&$_GET[$Gh]&&ini_bool("session.use_only_cookies"))$m=lang(89);$jg=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?:rand_string()),$jg["lifetime"]);if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);page_header(lang(37),$m,null);echo"\n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists('Adminer\Db')){unset($_SESSION["pwds"][DRIVER]);unset_permanent($ug);page_header(lang(91),lang(92,implode(", ",Driver::$Pc)),false);page_footer("auth");exit;}$g='';if(isset($_GET["username"])&&is_string(get_password())){list($Ld,$yg)=explode(":",SERVER,2);if(preg_match('~^\s*([-+]?\d+)~',$yg,$B)&&($B[1]<1024||$B[1]>65535))auth_error(lang(93),$ug);check_invalid_login($ug);$Fb=adminer()->credentials();$g=Driver::connect($Fb[0],$Fb[1],$Fb[2]);if(is_object($g)){Db::$he=$g;Driver::$he=new
Driver($g);if($g->flavor)save_settings(array("vendor-".DRIVER."-".SERVER=>get_driver(DRIVER)));}}$Le=null;if(!is_object($g)||($Le=adminer()->login($_GET["username"],get_password()))!==true){$m=(is_string($g)?nl_br(h($g)):(is_string($Le)?$Le:lang(94))).(preg_match('~^ | $~',get_password())?'
'.lang(95):'');auth_error($m,$ug);}if($_POST["logout"]&&$_SESSION["token"]&&!verify_token()){page_header(lang(83),lang(96));page_footer("db");exit;}if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);stop_session(true);if($Aa&&$_POST["token"])$_POST["token"]=get_token();$m='';if($_POST){if(!verify_token()){$ce="max_input_vars";$Xe=ini_get($ce);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$y){$X=ini_get($y);if($X&&(!$Xe||$X<$Xe)){$ce=$y;$Xe=$X;}}}$m=(!$_POST["token"]&&$Xe?lang(97,"'$ce'"):lang(96).' '.lang(98));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$m=lang(99,"'post_max_size'");if(isset($_GET["sql"]))$m
.=' '.lang(100);}function
print_select_result($I,$h=null,array$Vf=array(),$_=0){$Je=array();$x=array();$e=array();$Ma=array();$Wi=array();$J=array();for($t=0;(!$_||$t<$_)&&($K=$I->fetch_row());$t++){if(!$t){echo"":"".lang(12))."\n";return$J;}function
referencable_primary($zh){$J=array();foreach(table_status('',true)as$ji=>$R){if($ji!=$zh&&fk_support($R)){foreach(fields($ji)as$n){if($n["primary"]){if($J[$ji]){unset($J[$ji]);break;}$J[$ji]=$n;}}}}return$J;}function
textarea($C,$Y,$L=10,$kb=80){echo"