*8ՠ08A:с]wúz>9\n+:iiPoG01)ZږneR֖gMgsLCr8Ѐ!3R)00sIJVPpK\n|9e[ˑD0z4ϑo,N8ns#{蓷z3>BS\";e5VD0[\$7z0=8 T 3Q'RnLyŋ'\0o,\0:[}(|X>xvqW?tBE1wG;!5|0JI@#uņI\\p8!']߮l-lSB,ӗ]1ԕHN8%% /;FGSh\\لct2|W\$t<hO+#BaN1{yw2\\Z&)db',Xxm~H@:d >=-lKJ\0́@rϥ@\"(AZ7h>\\#>\0XrYYxŝq=:Թ\rlomgbD_TxC0.yR]_ZǻWIG Mɪ(|@\0SOs {@k}FXSb8=_l\0=g{HyG s_J\$hkFqd4ω'>vϏ!_7Vq@1zuSejKdyuS.2\"{K?s˦hRd`:yGھ\nQow'hS>LX}eG@9W|Ϲ@_uZ=,!}\0I@#\"'Y`\\?p,Gל_'G T#oH\r\"o}?O鼔7|'=8MQyaH?߮ \0bUd67I O\"-2_0\r?hOt\0\0002~° 4K,oh Pcz`@\"H; ,='S.bSCc욌R,~X@ '8Z0&(np<6]#;C.Ҏ8P3;@L,+>p(#-f1z,8ߠƐP:9R۳)e\0ڢR!\nr{eGA@*nD6N\rR8QK0颽>PNIQ=r<;&fNGJ;UAAP&`);!s\0pp\rn(@%& SdYuC,8O#oRv,#|7\"CpB`jX3~R@v9B#@\n0>T-5/= E\nd\"!;p*nZ\08/jX\r>F Pϐe>OLO0\0)k㦃[ ϳ'L 1 1\0C1T`RʐzĚp< .>5\0> Bnˊ<\"he>кîs!H{ܐ!\r\r\"|>R1d\"U@D63>o\rvL:K2+0쾁>\0 B{!r*Hy;`8\0دd\r02A?+\0Å\0AwSl\r[ԡ6co=0z/J+ꆌW[~C0e30HQPDPY}4#YDp) |@&-/F T aH5#H.A>0;.Yġ *D2=3 pBnuDw\n!zCQ \0HQ4D*7\0J%ıpuD(O=!>u,71TM+31:\"PRQ?P+11= M\$ZlT7,Nq%E!S2&U*>GDS&ozh8881\\:Z0hT C+#ʱA%D!\0XDA3\0!\\#h9bT!dYj2S\nA+ͽHwD`(AB*+%EX.ˠB#ȿ&XeEo\"|r8W2@8Da|NhJ8[۳Wz{Z\"L\0\0Ȇ8x۶X@ Eh;af1;nhZ3E0| 옑AtB,~W8^Ǡ׃<2/ 8+۔O+%P#ή\n?߉?e˔O\\]7(#D۾(!c)NMFE#DXg)0A\0:rB`` QH>!\rB\0V%ceHFHm2B2I`#D>n\n:L9C0\0x(ޏ(\nL\"G\n@`[\ni'\0)y)&(p\0N \"N:8.\r!'4|ל~ʀ\"cDlt0c5kQQר+ZGk!Fc4Rx@&>z=\$(?(\n쀨> ҵCqیt-}G,tGW xqHfb\0\0zT9zwЅDmn'ccbH\0z3! HHz׀Iy\",-\0\"<2'#H`d-#cljĞ`i(_dgȎǂ*j\r\0> 662kj&',@2pl:0lI\rrJDhAz22p`O2h8HĄwtBFg`72{,Kl߰%C%om+X41\n2p ZB!=VܨȀ+H6*\0k%< K',3rI;8\0Z+Eܭ`+lW+Yҵ-tfbQ_-Ӏޅ+ 95LjJ.Gʩ,\\ԅ.\$2J\\-1-cˇ.lfxBqK,dˀ8AKo-3Kr/|/\\r,HϤ!Y10@.&|+J\00P3J-ZQ \r&\nL*jĉ|#Ծ\"˺A/8)1#7\$\"6\n>\n7L1h9\0BZd#b:\0+A22'̕\nt̜O2lʳ.LHC\02+L\\rKk+˳.ꌒ;(Dƀ1sds9P4쌜@.AnhJ13K03J\$\02Lk3Q;3n\0\0,sI@u/VA1UM<Le4D2V% Ap\nȬ235A-Tu53۹1+fL~\n -> ҡM4XLSdٲ͟*\\@ͨYkSDM5 XfDsUs% ̱p+K6/ݒ8Xނ=K6pH%3ͫ7lIK0LDu`P\rSO͙&(;L@ψN>S28(`JErF 2SEMM\$qE\$ã/I\$\\ID\"\n䱺w.tS ђP#\nW-\0Cҵ:jR^S8;d`5ԪaʖE+(XrM;3;B,*1&2XS)< L9;RSNgIs+ӰK7>3@O{.4pO?Tb..~O4S>1SS*4Pȣ>3\0W>2>L7:9|C\$)z@tl:>C\nBi0G,\0FD%p)o\0\n>`)QZIKG%M\0#\0DQ.H'\$E\n \$ܐ%4ID3o:L\$m 0 B\\(8通hDCsDX4TK{x`\n,\nE:p\n'>o\0tI` -\0D/KP`/H\$\n=>UFP0UG}4B\$?E%TWD} *H0T\0t\"!o\0E7R.tfRFu!ԐD\n\0F-4VQH%40uN\0DQRuE )I\n&Qm)ǚm #\\D(\$̓x4WFM&ԜR5H%q[F+IF \nTR3DLoy4TQ/E[ў<t^F)Q+4QI#IF'TiѪX!ѱF*nR>5pKm+sIRE+ԩM\0(R?+HҀJ\"TD\$ 4wQ}Tz\0G8|xR6R 4XR6\n4ymNQNM&RH&2Q/7#қ{'ҍ,|\n .\0>{o#1D;?UҕJ9*jFNщJ #~%-?CL3@EP{`>QȔ%O)4R%I@%,\"I<\$ԉTP>\n\0QP5DkOFTY|[\0&RLHS9GI1䀖M4VHoT-S)QGF [TQRjN#x]N(U8\nuU\n?5,TmԞ??@U\nu-R9U/S \nU3IEStQYJu.QFo\$&i KPC6>5G\0uRu)U'R0ЀDuIUJ@ :V8*Rf%&\\RMU9RfUAU[TUQSe[\0KeZUaUhmS<,Rs`&Tj@G!\\x^0>\0&pQQ)TUPs@%\0W `\$(1Q?\$CQp\nOJX#V7Xu;!YBSc+V#MUWHURDžU-+VmY}\\OKM\$SeToVHT!!<{RZA5R!=3U({@*Ratz\0)QP5H؏հN5+P[9V%\"\nGSL9l\rVؤ[ouUIYR_TYp5O֧\\q`U[Bu'Uw\\mRUԭ\\Es5K\\V\\S{AZ%O\$F>5EWVm`Wd]& \$Ό!RZ}ԅ]}v5ZUgQ^y` !^=FR^vUKex@+r5#@?=uΓsץYNsS!^c5\$.u`\0XE~19JUZ@#1_[4J2\n\$VI4n\0?4aR!U~)&B>tRI0_EkTUS|Uk_8&E(‘?@J5JUBQT}HVjQx\neVsU=VN4ղؗ\\xR34GD\": KQ>[\rY_#!#][j<6خX c#KL}>`'\05XcU[\0(Wt|tR]p/]H2IQO1SQjZHm)d^SXCY\rtu@Jp%M?UQ\n=Rar:ԿE-G\0\$d]meh*QWtc`AY=S\r m-=MwH]J\"䴏f\"{#9TeMcNIDU6g2ݝeaLQ&&uTX51Y>S֊Q#Ij\0WP?ub5FULn)V5R@\$!%oP'EUP-Bp\nF\$S4tUF|{qȓ0Umjs\$ڛjcڐ֫aZI5Xj26&>v\n\r)2_kGTJeQ-cZVMֽz>]acc`tHj6+kM\0>##3l='^6\0èvZ9Se\"bΡB>)/T=9\0`P\$\0]/0ڪ䵏k-6{k[F\r|SѿJMQD=/WXVa'atol冶Xj}C@\"KPom3\0#HVv~{?gx n|[?U[rhG`3#Gk%L\0I`CD \"\0ŧ#cN6ڹfzێ;ѤeeF7/N\r:QG9 \$Iռ]TWGsdWMIfBcۤ!#cnu&(S_wSf&TZ:0CSLN`ܳYj=>ŲZ!=rV]g ӣrXl-.U'uJuJ\0sJ'W%\\>?BVj4J}I/-ҝrRLS3\0,RgqӭTf>1\0_\\V8Ztc耆<^\\llj\0T]CwΓzIZwNpVWjvY>2 o\$|UWL%{toX3_RJ5~6\"Zl}`kceR=^UԎ1ѽw7edvb=\0f,m)Gp-Ӽ)9L>| \"@5`:\0,t@xlJb6aA\0ػAR[A0\$qoAS@<@y\"as.V^讥^\0H[H@bK)z\r=^zB\0No<̇t<x\0ڬ0*RI{^E:{KՐ1E0Y/c\"\04F7'\n0`UT?MPl4r( Z|&t\"ILw+m}Wi\r>U__u63y[8T-V}x_~%7{jMo_E~]P\$JCaXG9\0007Ń5A#\0.\r˴_%\n\r#|B9 :N\$S CB:j6ΉJkuK_W͢ØI=@Tv\n0^o\\Ӡ?/&u._\rC+c~Jb6e\0yѡ\0wxh8j%SVH@N'\\ۯN`n\runKqUB+f>G\r=@Gd\n)FO hʷÈfCɅX|I]3auyUi^9y\no^rt\r8͇#N VY;c*%V<#h9r\rxcv(\ra(xja`g0V̼Qx(glհ{gh`sW<Kj';)Gnq\$p+Ɍ_d^& Dx!bv!EjPV'(=b\r\"bL\0bt\n>J1;ۈ4^sQp`fr`7xE:`1.;7@[>6!*\$`\0`,@?m>>\0LCǸRn/+`;C\0*Yhގ#;3ֺ85:\\\0XH
aM1\\L[YCvN\0+\0t#\$!@*l FdhdF&Ƙf)=04x\0004ED6K䢣\0nN];q4sj-=-8\0sǨDf5p4J^'Ӕ[H^NR FKwz EgF|!codbx\0-6,E_3up /wz(exRaHYce59d\00@2@ҐYfeyYcMוh[ez\rv\\0e\\cʃ[ueNY`ۖ]9h姗~^Yqe]qe_|6!u`fJ{7M{YهjeCS6\0DuasFL}\$ȇ(MbƤ,0Buίт2gxFљ{an:i\rPjerrGBYM+qiYd˙`0,>6fo0o Xf\0VL!fl6 /1e\0>kbf\r!uf<%(r˛a& Y!mBg=@\r; \r5phI9bm\$BYˋgx#@QEOm90\"!tˉЇO* \0>%\$orN&s9f4g~jMfwygy\\`X1y5x^z_,& k|1xA6 \no蔻&xgg{r?緛-|t3}gHgK9JP+?~g6\rhpz(W`\"y:FadŬ6:fi\0A;e^wf >y`-\r\0hr\rr8i\"_ 9CIfXˈ2\"ŢhL~\"%V:!%xyizygvx]}qgZi|`+ _g٣譞6PAʀ\$=9h|p!.!i^iˢ8zVCZ\"(9U)!DgU\0j?`4LTo@BNa{r:\n̟E8æ&=E*Z:\n?g̊h.N5(Shi2*cf@7z\"|rP.ǀL8T'k:(q2&ED2~ر9v8@^X=X`qZQ֮`9j5^@竸nqv3(I6jdT\\ 3,hk3(3PuV|\0阮Uk;JQ. :J\r1nBI\r\0ɬh@?N\nsh\";r~7O\$(5R ʽjFYFܔ~xf\"vۓo˨º#aP<h-3麝/Gxni@\"G?,ZpxX`v4X[I7åXc !b}j_95qti6fٞ5FƹiѱpX'2r0ƺD,#GU2؏I\rl( 챣=Aa쩳-8dbS4~H;06b{Rs3zNބ`ˆ+4<^ay }ryk&4@?~cE@LS@z^qqNx5==2.|'[';v;:SA &[men˵<6ma=Y.神:g腀;Ix[IJ\0~zaYwT\\`V\n~P)zJQ@[{rʉDBv|i-EK;^n{:Nh;2ƀpѴ6罘99XhQ~iA@D j}ozLVѳ~ 8B?#F}FTdezcFg7Η 6#.E££S.J35KɥJ;n5:ySCvoս.{ d\\0?W\0!)'Eg;+\0YNtbp+c\0B=\"cT:BcPIDV0!ROlON~aF|%ߺ)O WoQw:ٟl0h@:օ8Q&[nFp,æ@JTw9(<{ƐO\r ڂ\$m/HnP\$o^U\"{Ė<.nq8\r\0;n硟+3n{D\$7,Ez7\0l!{8x҂.s8PAFxrQۮ1̅p+@d9OP5lK/\\msqvQ/ !z7oEdž:qV5?GHOO\$l+,\r;~Ač錳{`7|Ăr'Ji\rc+|#+<&қ^P&nJhe%dCizXA'D>ΈEk@Bw(.\n99AhNckNd`p`%2\0");}else{header("Content-Type: image/gif");switch($_GET["file"]){case"plus.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0!M*)o) qe#L\0;";break;case"cross.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0##\naFo~y._wa1JGL6]\0\0;";break;case"up.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0 MQN\n}a8yaŶ\0\0;";break;case"down.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0 M*)[W\\L&ٜƶ\0\0;";break;case"arrow.gif":echo"GIF89a\0\n\0\0\0!\0\0\0,\0\0\0\0\0\n\0\0iӲ\0\0;";break;}}exit;}if($_GET["script"]=="version"){$p=file_open_lock(get_temp_dir()."/adminer.version");if($p)file_write_unlock($p,serialize(array("signature"=>$_POST["signature"],"version"=>$_POST["version"])));exit;}global$b,$e,$j,$Jb,$Qb,$ac,$k,$Ec,$Ic,$ba,$bd,$x,$ca,$sd,$ne,$Se,$ig,$Nc,$T,$Qg,$Wg,$dh,$ga;if(!$_SERVER["REQUEST_URI"])$_SERVER["REQUEST_URI"]=$_SERVER["ORIG_PATH_INFO"];if(!strpos($_SERVER["REQUEST_URI"],'?')&&$_SERVER["QUERY_STRING"]!="")$_SERVER["REQUEST_URI"].="?$_SERVER[QUERY_STRING]";if($_SERVER["HTTP_X_FORWARDED_PREFIX"])$_SERVER["REQUEST_URI"]=$_SERVER["HTTP_X_FORWARDED_PREFIX"].$_SERVER["REQUEST_URI"];$ba=($_SERVER["HTTPS"]&&strcasecmp($_SERVER["HTTPS"],"off"))||ini_bool("session.cookie_secure");@ini_set("session.use_trans_sid",false);if(!defined("SID")){session_cache_limiter("");session_name("adminer_sid");$Ie=array(0,preg_replace('~\?.*~','',$_SERVER["REQUEST_URI"]),"",$ba);if(version_compare(PHP_VERSION,'5.2.0')>=0)$Ie[]=true;call_user_func_array('session_set_cookie_params',$Ie);session_start();}remove_slashes(array(&$_GET,&$_POST,&$_COOKIE),$vc);if(function_exists("get_magic_quotes_runtime")&&get_magic_quotes_runtime())set_magic_quotes_runtime(false);@set_time_limit(0);@ini_set("zend.ze1_compatibility_mode",false);@ini_set("precision",15);function
get_lang(){return'de';}function
lang($Pg,$ee=null){if(is_array($Pg)){$Ve=($ee==1?0:1);$Pg=$Pg[$Ve];}$Pg=str_replace("%d","%s",$Pg);$ee=format_number($ee);return
sprintf($Pg,$ee);}if(extension_loaded('pdo')){class
Min_PDO{var$_result,$server_info,$affected_rows,$errno,$error,$pdo;function
__construct(){global$b;$Ve=array_search("SQL",$b->operators);if($Ve!==false)unset($b->operators[$Ve]);}function
dsn($Nb,$V,$G,$te=array()){try{$this->pdo=new
PDO($Nb,$V,$G,$te);}catch(Exception$gc){auth_error(h($gc->getMessage()));}$this->pdo->setAttribute(3,1);$this->pdo->setAttribute(13,array('Min_PDOStatement'));$this->server_info=@$this->pdo->getAttribute(4);}function
quote($hg){return$this->pdo->quote($hg);}function
query($I,$Xg=false){$J=$this->pdo->query($I);$this->error="";if(!$J){list(,$this->errno,$this->error)=$this->pdo->errorInfo();if(!$this->error)$this->error='Unknown error.';return
false;}$this->store_result($J);return$J;}function
multi_query($I){return$this->_result=$this->query($I);}function
store_result($J=null){if(!$J){$J=$this->_result;if(!$J)return
false;}if($J->columnCount()){$J->num_rows=$J->rowCount();return$J;}$this->affected_rows=$J->rowCount();return
true;}function
next_result(){if(!$this->_result)return
false;$this->_result->_offset=0;return@$this->_result->nextRowset();}function
result($I,$l=0){$J=$this->query($I);if(!$J)return
false;$L=$J->fetch();return$L[$l];}}class
Min_PDOStatement
extends
PDOStatement{var$_offset=0,$num_rows;function
fetch_assoc(){return$this->fetch(2);}function
fetch_row(){return$this->fetch(3);}function
fetch_field(){$L=(object)$this->getColumnMeta($this->_offset++);$L->orgtable=$L->table;$L->orgname=$L->name;$L->charsetnr=(in_array("blob",(array)$L->flags)?63:0);return$L;}}}$Jb=array();function
add_driver($u,$E){global$Jb;$Jb[$u]=$E;}class
Min_SQL{var$_conn;function
__construct($e){$this->_conn=$e;}function
select($Q,$N,$Z,$s,$ve=array(),$z=1,$F=0,$cf=false){global$b,$x;$id=(count($s)selectQueryBuild($N,$Z,$s,$ve,$z,$F);if(!$I)$I="SELECT".limit(($_GET["page"]!="last"&&$z!=""&&$s&&$id&&$x=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$N)."\nFROM ".table($Q),($Z?"\nWHERE ".implode(" AND ",$Z):"").($s&&$id?"\nGROUP BY ".implode(", ",$s):"").($ve?"\nORDER BY ".implode(", ",$ve):""),($z!=""?+$z:null),($F?$z*$F:0),"\n");$dg=microtime(true);$K=$this->_conn->query($I);if($cf)echo$b->selectQuery($I,$dg,!$K);return$K;}function
delete($Q,$kf,$z=0){$I="FROM ".table($Q);return
queries("DELETE".($z?limit1($Q,$I,$kf):" $I$kf"));}function
update($Q,$P,$kf,$z=0,$Nf="\n"){$nh=array();foreach($P
as$y=>$X)$nh[]="$y = $X";$I=table($Q)." SET$Nf".implode(",$Nf",$nh);return
queries("UPDATE".($z?limit1($Q,$I,$kf,$Nf):" $I$kf"));}function
insert($Q,$P){return
queries("INSERT INTO ".table($Q).($P?" (".implode(", ",array_keys($P)).")\nVALUES (".implode(", ",$P).")":" DEFAULT VALUES"));}function
insertUpdate($Q,$M,$bf){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}function
slowQuery($I,$Dg){}function
convertSearch($Vc,$X,$l){return$Vc;}function
value($X,$l){return(method_exists($this->_conn,'value')?$this->_conn->value($X,$l):(is_resource($X)?stream_get_contents($X):$X));}function
quoteBinary($Ef){return
q($Ef);}function
warnings(){return'';}function
tableHelp($E){}}class
Adminer{var$operators;function
name(){return"Adminer";}function
credentials(){return
array(SERVER,$_GET["username"],get_password());}function
connectSsl(){}function
permanentLogin($g=false){return
password_file($g);}function
bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
serverName($O){return
h($O);}function
database(){return
DB;}function
databases($xc=true){return
get_databases($xc);}function
schemas(){return
schemas();}function
queryTimeout(){return
2;}function
headers(){}function
csp(){return
csp();}function
head(){return
true;}function
css(){$K=array();$uc="adminer.css";if(file_exists($uc))$K[]="$uc?v=".crc32(file_get_contents($uc));return$K;}function
loginForm(){global$Jb;echo"\n",$this->loginFormField('driver',''.'Datenbank System'.' | ',html_select("auth[driver]",$Jb,DRIVER,"loginDriver(this);")."\n"),$this->loginFormField('server',' |
---|
'.'Server'.' | ',''."\n"),$this->loginFormField('username',' |
---|
'.'Benutzer'.' | ',''.script("focus(qs('#username')); qs('#username').form['auth[driver]'].onchange();")),$this->loginFormField('password',' |
---|
'.'Passwort'.' | ',''."\n"),$this->loginFormField('db',' |
---|
'.'Datenbank'.' | ',''."\n")," |
---|
\n","\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],'Passwort speichern')."\n";}function
loginFormField($E,$Pc,$Y){return$Pc.$Y;}function
login($Cd,$G){if($G=="")return
sprintf('Adminer does not support accessing a database without a password, more information.',target_blank());return
true;}function
tableName($pg){return
h($pg["Name"]);}function
fieldName($l,$ve=0){return''.h($l["field"]).'';}function
selectLinks($pg,$P=""){global$x,$j;echo'
';$Bd=array("select"=>'Daten auswählen');if(support("table")||support("indexes"))$Bd["table"]='Struktur anzeigen';if(support("table")){if(is_view($pg))$Bd["view"]='View ändern';else$Bd["create"]='Tabelle ändern';}if($P!==null)$Bd["edit"]='Neuer Datensatz';$E=$pg["Name"];foreach($Bd
as$y=>$X)echo" $X";echo
doc_link(array($x=>$j->tableHelp($E)),"?"),"\n";}function
foreignKeys($Q){return
foreign_keys($Q);}function
backwardKeys($Q,$og){return
array();}function
backwardKeysPrint($Aa,$L){}function
selectQuery($I,$dg,$pc=false){global$x,$j;$K="
\n";if(!$pc&&($vh=$j->warnings())){$u="warnings";$K=", ".'Warnings'."".script("qsl('a').onclick = partial(toggle, '$u');","")."$K\n$vh
\n";}return"".h(str_replace("\n"," ",$I))."
(".format_time($dg).")".(support("sql")?" ".'Bearbeiten'."":"").$K;}function
sqlCommandQuery($I){return
shorten_utf8(trim($I),1000);}function
rowDescription($Q){return"";}function
rowDescriptions($M,$_c){return$M;}function
selectLink($X,$l){}function
selectVal($X,$_,$l,$Ce){$K=($X===null?"NULL":(preg_match("~char|binary|boolean~",$l["type"])&&!preg_match("~var~",$l["type"])?"$X
":$X));if(preg_match('~blob|bytea|raw|file~',$l["type"])&&!is_utf8($X))$K="".lang(array('%d Byte','%d Bytes'),strlen($Ce))."";if(preg_match('~json~',$l["type"]))$K="$K
";return($_?"$K":$K);}function
editVal($X,$l){return$X;}function
tableStructurePrint($m){echo"
\n";}function
tableIndexesPrint($w){echo"\n";foreach($w
as$E=>$v){ksort($v["columns"]);$cf=array();foreach($v["columns"]as$y=>$X)$cf[]="".h($X)."".($v["lengths"][$y]?"(".$v["lengths"][$y].")":"").($v["descs"][$y]?" DESC":"");echo"$v[type] | ".implode(", ",$cf)."\n";}echo" |
---|
\n";}function
selectColumnsPrint($N,$d){global$Ec,$Ic;print_fieldset("select",'Daten zeigen von',$N);$t=0;$N[""]=array();foreach($N
as$y=>$X){$X=$_GET["columns"][$y];$c=select_input(" name='columns[$t][col]'",$d,$X["col"],($y!==""?"selectFieldChange":"selectAddRow"));echo"".($Ec||$Ic?"".on_help("getTarget(event).value && getTarget(event).value.replace(/ |\$/, '(') + ')'",1).script("qsl('select').onchange = function () { helpClose();".($y!==""?"":" qsl('select, input', this.parentNode).onchange();")." };","")."($c)":$c)."
\n";$t++;}echo"\n";}function
selectSearchPrint($Z,$d,$w){print_fieldset("search",'Suchen',$Z);foreach($w
as$t=>$v){if($v["type"]=="FULLTEXT"){echo"(".implode(", ",array_map('h',$v["columns"])).") AGAINST"," ",script("qsl('input').oninput = selectFieldChange;",""),checkbox("boolean[$t]",1,isset($_GET["boolean"][$t]),"BOOL"),"
\n";}}$Ka="this.parentNode.firstChild.onchange();";foreach(array_merge((array)$_GET["where"],array(array()))as$t=>$X){if(!$X||("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators))){echo"".select_input(" name='where[$t][col]'",$d,$X["col"],($X?"selectFieldChange":"selectAddRow"),"(".'beliebig'.")"),html_select("where[$t][op]",$this->operators,$X["op"],$Ka),"",script("mixin(qsl('input'), {oninput: function () { $Ka }, onkeydown: selectSearchKeydown, onsearch: selectSearchSearch});",""),"
\n";}}echo"\n";}function
selectOrderPrint($ve,$d,$w){print_fieldset("sort",'Ordnen',$ve);$t=0;foreach((array)$_GET["order"]as$y=>$X){if($X!=""){echo"".select_input(" name='order[$t]'",$d,$X,"selectFieldChange"),checkbox("desc[$t]",1,isset($_GET["desc"][$y]),'absteigend')."
\n";$t++;}}echo"".select_input(" name='order[$t]'",$d,"","selectAddRow"),checkbox("desc[$t]",1,false,'absteigend')."
\n","\n";}function
selectLimitPrint($z){echo"\n";}function
selectLengthPrint($Bg){if($Bg!==null){echo"\n";}}function
selectActionPrint($w){echo"\n";}function
selectCommandPrint(){return!information_schema(DB);}function
selectImportPrint(){return!information_schema(DB);}function
selectEmailPrint($Vb,$d){}function
selectColumnsProcess($d,$w){global$Ec,$Ic;$N=array();$s=array();foreach((array)$_GET["columns"]as$y=>$X){if($X["fun"]=="count"||($X["col"]!=""&&(!$X["fun"]||in_array($X["fun"],$Ec)||in_array($X["fun"],$Ic)))){$N[$y]=apply_sql_function($X["fun"],($X["col"]!=""?idf_escape($X["col"]):"*"));if(!in_array($X["fun"],$Ic))$s[]=$N[$y];}}return
array($N,$s);}function
selectSearchProcess($m,$w){global$e,$j;$K=array();foreach($w
as$t=>$v){if($v["type"]=="FULLTEXT"&&$_GET["fulltext"][$t]!="")$K[]="MATCH (".implode(", ",array_map('idf_escape',$v["columns"])).") AGAINST (".q($_GET["fulltext"][$t]).(isset($_GET["boolean"][$t])?" IN BOOLEAN MODE":"").")";}foreach((array)$_GET["where"]as$y=>$X){if("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators)){$Ze="";$db=" $X[op]";if(preg_match('~IN$~',$X["op"])){$Yc=process_length($X["val"]);$db.=" ".($Yc!=""?$Yc:"(NULL)");}elseif($X["op"]=="SQL")$db=" $X[val]";elseif($X["op"]=="LIKE %%")$db=" LIKE ".$this->processInput($m[$X["col"]],"%$X[val]%");elseif($X["op"]=="ILIKE %%")$db=" ILIKE ".$this->processInput($m[$X["col"]],"%$X[val]%");elseif($X["op"]=="FIND_IN_SET"){$Ze="$X[op](".q($X["val"]).", ";$db=")";}elseif(!preg_match('~NULL$~',$X["op"]))$db.=" ".$this->processInput($m[$X["col"]],$X["val"]);if($X["col"]!="")$K[]=$Ze.$j->convertSearch(idf_escape($X["col"]),$X,$m[$X["col"]]).$db;else{$Ya=array();foreach($m
as$E=>$l){if((preg_match('~^[-\d.'.(preg_match('~IN$~',$X["op"])?',':'').']+$~',$X["val"])||!preg_match('~'.number_type().'|bit~',$l["type"]))&&(!preg_match("~[\x80-\xFF]~",$X["val"])||preg_match('~char|text|enum|set~',$l["type"]))&&(!preg_match('~date|timestamp~',$l["type"])||preg_match('~^\d+-\d+-\d+~',$X["val"])))$Ya[]=$Ze.$j->convertSearch(idf_escape($E),$X,$l).$db;}$K[]=($Ya?"(".implode(" OR ",$Ya).")":"1 = 0");}}}return$K;}function
selectOrderProcess($m,$w){$K=array();foreach((array)$_GET["order"]as$y=>$X){if($X!="")$K[]=(preg_match('~^((COUNT\(DISTINCT |[A-Z0-9_]+\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\)|COUNT\(\*\))$~',$X)?$X:idf_escape($X)).(isset($_GET["desc"][$y])?" DESC":"");}return$K;}function
selectLimitProcess(){return(isset($_GET["limit"])?$_GET["limit"]:"50");}function
selectLengthProcess(){return(isset($_GET["text_length"])?$_GET["text_length"]:"100");}function
selectEmailProcess($Z,$_c){return
false;}function
selectQueryBuild($N,$Z,$s,$ve,$z,$F){return"";}function
messageQuery($I,$Cg,$pc=false){global$x,$j;restart_session();$Qc=&get_session("queries");if(!$Qc[$_GET["db"]])$Qc[$_GET["db"]]=array();if(strlen($I)>1e6)$I=preg_replace('~[\x80-\xFF]+$~','',substr($I,0,1e6))."\n…";$Qc[$_GET["db"]][]=array($I,time(),$Cg);$bg="sql-".count($Qc[$_GET["db"]]);$K="".'SQL-Kommando'."\n";if(!$pc&&($vh=$j->warnings())){$u="warnings-".count($Qc[$_GET["db"]]);$K="".'Warnings'.", $K\n$vh
\n";}return" ".@date("H:i:s").""." $K".shorten_utf8($I,1000)."
".($Cg?"
($Cg)":'').(support("sql")?'
'.'Bearbeiten'.'':'').'
';}function
editRowPrint($Q,$m,$L,$eh){}function
editFunctions($l){global$Qb;$K=($l["null"]?"NULL/":"");$eh=isset($_GET["select"])||where($_GET);foreach($Qb
as$y=>$Ec){if(!$y||(!isset($_GET["call"])&&$eh)){foreach($Ec
as$Qe=>$X){if(!$Qe||preg_match("~$Qe~",$l["type"]))$K.="/$X";}}if($y&&!preg_match('~set|blob|bytea|raw|file|bool~',$l["type"]))$K.="/SQL";}if($l["auto_increment"]&&!$eh)$K='Auto-Inkrement';return
explode("/",$K);}function
editInput($Q,$l,$wa,$Y){if($l["type"]=="enum")return(isset($_GET["select"])?" ":"").($l["null"]?" ":"").enum_input("radio",$wa,$l,$Y,0);return"";}function
editHint($Q,$l,$Y){return"";}function
processInput($l,$Y,$q=""){if($q=="SQL")return$Y;$E=$l["field"];$K=q($Y);if(preg_match('~^(now|getdate|uuid)$~',$q))$K="$q()";elseif(preg_match('~^current_(date|timestamp)$~',$q))$K=$q;elseif(preg_match('~^([+-]|\|\|)$~',$q))$K=idf_escape($E)." $q $K";elseif(preg_match('~^[+-] interval$~',$q))$K=idf_escape($E)." $q ".(preg_match("~^(\\d+|'[0-9.: -]') [A-Z_]+\$~i",$Y)?$Y:$K);elseif(preg_match('~^(addtime|subtime|concat)$~',$q))$K="$q(".idf_escape($E).", $K)";elseif(preg_match('~^(md5|sha1|password|encrypt)$~',$q))$K="$q($K)";return
unconvert_field($l,$K);}function
dumpOutput(){$K=array('text'=>'anzeigen','file'=>'Datei');if(function_exists('gzencode'))$K['gz']='gzip';return$K;}function
dumpFormat(){return
array('sql'=>'SQL','csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
dumpDatabase($i){}function
dumpTable($Q,$jg,$kd=0){if($_POST["format"]!="sql"){echo"\xef\xbb\xbf";if($jg)dump_csv(array_keys(fields($Q)));}else{if($kd==2){$m=array();foreach(fields($Q)as$E=>$l)$m[]=idf_escape($E)." $l[full_type]";$g="CREATE TABLE ".table($Q)." (".implode(", ",$m).")";}else$g=create_sql($Q,$_POST["auto_increment"],$jg);set_utf8mb4($g);if($jg&&$g){if($jg=="DROP+CREATE"||$kd==1)echo"DROP ".($kd==2?"VIEW":"TABLE")." IF EXISTS ".table($Q).";\n";if($kd==1)$g=remove_definer($g);echo"$g;\n\n";}}}function
dumpData($Q,$jg,$I){global$e,$x;$Id=($x=="sqlite"?0:1048576);if($jg){if($_POST["format"]=="sql"){if($jg=="TRUNCATE+INSERT")echo
truncate_sql($Q).";\n";$m=fields($Q);}$J=$e->query($I,1);if($J){$dd="";$Ia="";$nd=array();$lg="";$sc=($Q!=''?'fetch_assoc':'fetch_row');while($L=$J->$sc()){if(!$nd){$nh=array();foreach($L
as$X){$l=$J->fetch_field();$nd[]=$l->name;$y=idf_escape($l->name);$nh[]="$y = VALUES($y)";}$lg=($jg=="INSERT+UPDATE"?"\nON DUPLICATE KEY UPDATE ".implode(", ",$nh):"").";\n";}if($_POST["format"]!="sql"){if($jg=="table"){dump_csv($nd);$jg="INSERT";}dump_csv($L);}else{if(!$dd)$dd="INSERT INTO ".table($Q)." (".implode(", ",array_map('idf_escape',$nd)).") VALUES";foreach($L
as$y=>$X){$l=$m[$y];$L[$y]=($X!==null?unconvert_field($l,preg_match(number_type(),$l["type"])&&!preg_match('~\[~',$l["full_type"])&&is_numeric($X)?$X:q(($X===false?0:$X))):"NULL");}$Ef=($Id?"\n":" ")."(".implode(",\t",$L).")";if(!$Ia)$Ia=$dd.$Ef;elseif(strlen($Ia)+4+strlen($Ef)+strlen($lg)<$Id)$Ia.=",$Ef";else{echo$Ia.$lg;$Ia=$dd.$Ef;}}}if($Ia)echo$Ia.$lg;}elseif($_POST["format"]=="sql")echo"-- ".str_replace("\n"," ",$e->error)."\n";}}function
dumpFilename($Uc){return
friendly_url($Uc!=""?$Uc:(SERVER!=""?SERVER:"localhost"));}function
dumpHeaders($Uc,$Ud=false){$Ee=$_POST["output"];$mc=(preg_match('~sql~',$_POST["format"])?"sql":($Ud?"tar":"csv"));header("Content-Type: ".($Ee=="gz"?"application/x-gzip":($mc=="tar"?"application/x-tar":($mc=="sql"||$Ee!="file"?"text/plain":"text/csv")."; charset=utf-8")));if($Ee=="gz")ob_start('ob_gzencode',1e6);return$mc;}function
importServerPath(){return"adminer.sql";}function
homepage(){echo''.($_GET["ns"]==""&&support("database")?''.'Datenbank ändern'."\n":""),(support("scheme")?"".($_GET["ns"]!=""?'Schema ändern':'Schema erstellen')."\n":""),($_GET["ns"]!==""?''.'Datenbankschema'."\n":""),(support("privileges")?"".'Rechte'."\n":"");return
true;}function
navigation($Td){global$ga,$x,$Jb,$e;echo'
';if($Td=="auth"){$Ee="";foreach((array)$_SESSION["pwds"]as$ph=>$Pf){foreach($Pf
as$O=>$lh){foreach($lh
as$V=>$G){if($G!==null){$xb=$_SESSION["db"][$ph][$O][$V];foreach(($xb?array_keys($xb):array(""))as$i)$Ee.="($Jb[$ph]) ".h($V.($O!=""?"@".$this->serverName($O):"").($i!=""?" - $i":""))."\n";}}}}if($Ee)echo"\n".script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");}else{if($_GET["ns"]!==""&&!$Td&&DB!=""){$e->select_db(DB);$S=table_status('',true);}echo
script_src(preg_replace("~\\?.*~","",ME)."?file=jush.js&version=4.8.0");if(support("sql")){echo'
';}$this->databasesPrint($Td);if(DB==""||!$Td){echo"".(support("sql")?"".'SQL-Kommando'."\n".'Importieren'."\n":"")."";if(support("dump"))echo"".'Exportieren'."\n";}if($_GET["ns"]!==""&&!$Td&&DB!=""){echo'".'Tabelle erstellen'."\n";if(!$S)echo"
".'Keine Tabellen.'."\n";else$this->tablesPrint($S);}}}function
databasesPrint($Td){global$b,$e;$h=$this->databases();if(DB&&$h&&!in_array(DB,$h))array_unshift($h,DB);echo'
\n";}function
tablesPrint($S){echo"".script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($S
as$Q=>$eg){$E=$this->tableName($eg);if($E!=""){echo'- ".'zeigen'." ",(support("table")||support("indexes")?'$E":"$E")."\n";}}echo"
\n";}}$b=(function_exists('adminer_object')?adminer_object():new
Adminer);$Jb=array("server"=>"MySQL")+$Jb;if(!defined("DRIVER")){define("DRIVER","server");if(extension_loaded("mysqli")){class
Min_DB
extends
MySQLi{var$extension="MySQLi";function
__construct(){parent::init();}function
connect($O="",$V="",$G="",$ub=null,$Ue=null,$Wf=null){global$b;mysqli_report(MYSQLI_REPORT_OFF);list($Sc,$Ue)=explode(":",$O,2);$cg=$b->connectSsl();if($cg)$this->ssl_set($cg['key'],$cg['cert'],$cg['ca'],'','');$K=@$this->real_connect(($O!=""?$Sc:ini_get("mysqli.default_host")),($O.$V!=""?$V:ini_get("mysqli.default_user")),($O.$V.$G!=""?$G:ini_get("mysqli.default_pw")),$ub,(is_numeric($Ue)?$Ue:ini_get("mysqli.default_port")),(!is_numeric($Ue)?$Ue:$Wf),($cg?64:0));$this->options(MYSQLI_OPT_LOCAL_INFILE,false);return$K;}function
set_charset($La){if(parent::set_charset($La))return
true;parent::set_charset('utf8');return$this->query("SET NAMES $La");}function
result($I,$l=0){$J=$this->query($I);if(!$J)return
false;$L=$J->fetch_array();return$L[$l];}function
quote($hg){return"'".$this->escape_string($hg)."'";}}}elseif(extension_loaded("mysql")&&!((ini_bool("sql.safe_mode")||ini_bool("mysql.allow_local_infile"))&&extension_loaded("pdo_mysql"))){class
Min_DB{var$extension="MySQL",$server_info,$affected_rows,$errno,$error,$_link,$_result;function
connect($O,$V,$G){if(ini_bool("mysql.allow_local_infile")){$this->error=sprintf('Disable %s or enable %s or %s extensions.',"'mysql.allow_local_infile'","MySQLi","PDO_MySQL");return
false;}$this->_link=@mysql_connect(($O!=""?$O:ini_get("mysql.default_host")),("$O$V"!=""?$V:ini_get("mysql.default_user")),("$O$V$G"!=""?$G:ini_get("mysql.default_password")),true,131072);if($this->_link)$this->server_info=mysql_get_server_info($this->_link);else$this->error=mysql_error();return(bool)$this->_link;}function
set_charset($La){if(function_exists('mysql_set_charset')){if(mysql_set_charset($La,$this->_link))return
true;mysql_set_charset('utf8',$this->_link);}return$this->query("SET NAMES $La");}function
quote($hg){return"'".mysql_real_escape_string($hg,$this->_link)."'";}function
select_db($ub){return
mysql_select_db($ub,$this->_link);}function
query($I,$Xg=false){$J=@($Xg?mysql_unbuffered_query($I,$this->_link):mysql_query($I,$this->_link));$this->error="";if(!$J){$this->errno=mysql_errno($this->_link);$this->error=mysql_error($this->_link);return
false;}if($J===true){$this->affected_rows=mysql_affected_rows($this->_link);$this->info=mysql_info($this->_link);return
true;}return
new
Min_Result($J);}function
multi_query($I){return$this->_result=$this->query($I);}function
store_result(){return$this->_result;}function
next_result(){return
false;}function
result($I,$l=0){$J=$this->query($I);if(!$J||!$J->num_rows)return
false;return
mysql_result($J->_result,0,$l);}}class
Min_Result{var$num_rows,$_result,$_offset=0;function
__construct($J){$this->_result=$J;$this->num_rows=mysql_num_rows($J);}function
fetch_assoc(){return
mysql_fetch_assoc($this->_result);}function
fetch_row(){return
mysql_fetch_row($this->_result);}function
fetch_field(){$K=mysql_fetch_field($this->_result,$this->_offset++);$K->orgtable=$K->table;$K->orgname=$K->name;$K->charsetnr=($K->blob?63:0);return$K;}function
__destruct(){mysql_free_result($this->_result);}}}elseif(extension_loaded("pdo_mysql")){class
Min_DB
extends
Min_PDO{var$extension="PDO_MySQL";function
connect($O,$V,$G){global$b;$te=array(PDO::MYSQL_ATTR_LOCAL_INFILE=>false);$cg=$b->connectSsl();if($cg){if(!empty($cg['key']))$te[PDO::MYSQL_ATTR_SSL_KEY]=$cg['key'];if(!empty($cg['cert']))$te[PDO::MYSQL_ATTR_SSL_CERT]=$cg['cert'];if(!empty($cg['ca']))$te[PDO::MYSQL_ATTR_SSL_CA]=$cg['ca'];}$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\d)~',';port=\1',$O)),$V,$G,$te);return
true;}function
set_charset($La){$this->query("SET NAMES $La");}function
select_db($ub){return$this->query("USE ".idf_escape($ub));}function
query($I,$Xg=false){$this->pdo->setAttribute(1000,!$Xg);return
parent::query($I,$Xg);}}}class
Min_Driver
extends
Min_SQL{function
insert($Q,$P){return($P?parent::insert($Q,$P):queries("INSERT INTO ".table($Q)." ()\nVALUES ()"));}function
insertUpdate($Q,$M,$bf){$d=array_keys(reset($M));$Ze="INSERT INTO ".table($Q)." (".implode(", ",$d).") VALUES\n";$nh=array();foreach($d
as$y)$nh[$y]="$y = VALUES($y)";$lg="\nON DUPLICATE KEY UPDATE ".implode(", ",$nh);$nh=array();$zd=0;foreach($M
as$P){$Y="(".implode(", ",$P).")";if($nh&&(strlen($Ze)+$zd+strlen($Y)+strlen($lg)>1e6)){if(!queries($Ze.implode(",\n",$nh).$lg))return
false;$nh=array();$zd=0;}$nh[]=$Y;$zd+=strlen($Y)+2;}return
queries($Ze.implode(",\n",$nh).$lg);}function
slowQuery($I,$Dg){if(min_version('5.7.8','10.1.2')){if(preg_match('~MariaDB~',$this->_conn->server_info))return"SET STATEMENT max_statement_time=$Dg FOR $I";elseif(preg_match('~^(SELECT\b)(.+)~is',$I,$B))return"$B[1] /*+ MAX_EXECUTION_TIME(".($Dg*1000).") */ $B[2]";}}function
convertSearch($Vc,$X,$l){return(preg_match('~char|text|enum|set~',$l["type"])&&!preg_match("~^utf8~",$l["collation"])&&preg_match('~[\x80-\xFF]~',$X['val'])?"CONVERT($Vc USING ".charset($this->_conn).")":$Vc);}function
warnings(){$J=$this->_conn->query("SHOW WARNINGS");if($J&&$J->num_rows){ob_start();select($J);return
ob_get_clean();}}function
tableHelp($E){$Ed=preg_match('~MariaDB~',$this->_conn->server_info);if(information_schema(DB))return
strtolower(($Ed?"information-schema-$E-table/":str_replace("_","-",$E)."-table.html"));if(DB=="mysql")return($Ed?"mysql$E-table/":"system-database.html");}}function
idf_escape($Vc){return"`".str_replace("`","``",$Vc)."`";}function
table($Vc){return
idf_escape($Vc);}function
connect(){global$b,$Wg,$ig;$e=new
Min_DB;$nb=$b->credentials();if($e->connect($nb[0],$nb[1],$nb[2])){$e->set_charset(charset($e));$e->query("SET sql_quote_show_create = 1, autocommit = 1");if(min_version('5.7.8',10.2,$e)){$ig['Zeichenketten'][]="json";$Wg["json"]=4294967295;}return$e;}$K=$e->error;if(function_exists('iconv')&&!is_utf8($K)&&strlen($Ef=iconv("windows-1250","utf-8",$K))>strlen($K))$K=$Ef;return$K;}function
get_databases($xc){$K=get_session("dbs");if($K===null){$I=(min_version(5)?"SELECT SCHEMA_NAME FROM information_schema.SCHEMATA ORDER BY SCHEMA_NAME":"SHOW DATABASES");$K=($xc?slow_query($I):get_vals($I));restart_session();set_session("dbs",$K);stop_session();}return$K;}function
limit($I,$Z,$z,$ge=0,$Nf=" "){return" $I$Z".($z!==null?$Nf."LIMIT $z".($ge?" OFFSET $ge":""):"");}function
limit1($Q,$I,$Z,$Nf="\n"){return
limit($I,$Z,1,0,$Nf);}function
db_collation($i,$Xa){global$e;$K=null;$g=$e->result("SHOW CREATE DATABASE ".idf_escape($i),1);if(preg_match('~ COLLATE ([^ ]+)~',$g,$B))$K=$B[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$g,$B))$K=$Xa[$B[1]][-1];return$K;}function
engines(){$K=array();foreach(get_rows("SHOW ENGINES")as$L){if(preg_match("~YES|DEFAULT~",$L["Support"]))$K[]=$L["Engine"];}return$K;}function
logged_user(){global$e;return$e->result("SELECT USER()");}function
tables_list(){return
get_key_vals(min_version(5)?"SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME":"SHOW TABLES");}function
count_tables($h){$K=array();foreach($h
as$i)$K[$i]=count(get_vals("SHOW TABLES IN ".idf_escape($i)));return$K;}function
table_status($E="",$qc=false){$K=array();foreach(get_rows($qc&&min_version(5)?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($E!=""?"AND TABLE_NAME = ".q($E):"ORDER BY Name"):"SHOW TABLE STATUS".($E!=""?" LIKE ".q(addcslashes($E,"%_\\")):""))as$L){if($L["Engine"]=="InnoDB")$L["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\1',$L["Comment"]);if(!isset($L["Engine"]))$L["Comment"]="";if($E!="")return$L;$K[$L["Name"]]=$L;}return$K;}function
is_view($R){return$R["Engine"]===null;}function
fk_support($R){return
preg_match('~InnoDB|IBMDB2I~i',$R["Engine"])||(preg_match('~NDB~i',$R["Engine"])&&min_version(5.6));}function
fields($Q){$K=array();foreach(get_rows("SHOW FULL COLUMNS FROM ".table($Q))as$L){preg_match('~^([^( ]+)(?:\((.+)\))?( unsigned)?( zerofill)?$~',$L["Type"],$B);$K[$L["Field"]]=array("field"=>$L["Field"],"full_type"=>$L["Type"],"type"=>$B[1],"length"=>$B[2],"unsigned"=>ltrim($B[3].$B[4]),"default"=>($L["Default"]!=""||preg_match("~char|set~",$B[1])?(preg_match('~text~',$B[1])?stripslashes(preg_replace("~^'(.*)'\$~",'\1',$L["Default"])):$L["Default"]):null),"null"=>($L["Null"]=="YES"),"auto_increment"=>($L["Extra"]=="auto_increment"),"on_update"=>(preg_match('~^on update (.+)~i',$L["Extra"],$B)?$B[1]:""),"collation"=>$L["Collation"],"privileges"=>array_flip(preg_split('~, *~',$L["Privileges"])),"comment"=>$L["Comment"],"primary"=>($L["Key"]=="PRI"),"generated"=>preg_match('~^(VIRTUAL|PERSISTENT|STORED)~',$L["Extra"]),);}return$K;}function
indexes($Q,$f=null){$K=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$f)as$L){$E=$L["Key_name"];$K[$E]["type"]=($E=="PRIMARY"?"PRIMARY":($L["Index_type"]=="FULLTEXT"?"FULLTEXT":($L["Non_unique"]?($L["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$K[$E]["columns"][]=$L["Column_name"];$K[$E]["lengths"][]=($L["Index_type"]=="SPATIAL"?null:$L["Sub_part"]);$K[$E]["descs"][]=null;}return$K;}function
foreign_keys($Q){global$e,$ne;static$Qe='(?:`(?:[^`]|``)+`|"(?:[^"]|"")+")';$K=array();$lb=$e->result("SHOW CREATE TABLE ".table($Q),1);if($lb){preg_match_all("~CONSTRAINT ($Qe) FOREIGN KEY ?\\(((?:$Qe,? ?)+)\\) REFERENCES ($Qe)(?:\\.($Qe))? \\(((?:$Qe,? ?)+)\\)(?: ON DELETE ($ne))?(?: ON UPDATE ($ne))?~",$lb,$Gd,PREG_SET_ORDER);foreach($Gd
as$B){preg_match_all("~$Qe~",$B[2],$Xf);preg_match_all("~$Qe~",$B[5],$xg);$K[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('idf_unescape',$Xf[0]),"target"=>array_map('idf_unescape',$xg[0]),"on_delete"=>($B[6]?$B[6]:"RESTRICT"),"on_update"=>($B[7]?$B[7]:"RESTRICT"),);}}return$K;}function
view($E){global$e;return
array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\s+AS\s+~isU','',$e->result("SHOW CREATE VIEW ".table($E),1)));}function
collations(){$K=array();foreach(get_rows("SHOW COLLATION")as$L){if($L["Default"])$K[$L["Charset"]][-1]=$L["Collation"];else$K[$L["Charset"]][]=$L["Collation"];}ksort($K);foreach($K
as$y=>$X)asort($K[$y]);return$K;}function
information_schema($i){return(min_version(5)&&$i=="information_schema")||(min_version(5.5)&&$i=="performance_schema");}function
error(){global$e;return
h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",$e->error));}function
create_database($i,$Wa){return
queries("CREATE DATABASE ".idf_escape($i).($Wa?" COLLATE ".q($Wa):""));}function
drop_databases($h){$K=apply_queries("DROP DATABASE",$h,'idf_escape');restart_session();set_session("dbs",null);return$K;}function
rename_database($E,$Wa){$K=false;if(create_database($E,$Wa)){$vf=array();foreach(tables_list()as$Q=>$U)$vf[]=table($Q)." TO ".idf_escape($E).".".table($Q);$K=(!$vf||queries("RENAME TABLE ".implode(", ",$vf)));if($K)queries("DROP DATABASE ".idf_escape(DB));restart_session();set_session("dbs",null);}return$K;}function
auto_increment(){$za=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$v){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$v["columns"],true)){$za="";break;}if($v["type"]=="PRIMARY")$za=" UNIQUE";}}return" AUTO_INCREMENT$za";}function
alter_table($Q,$E,$m,$zc,$bb,$Yb,$Wa,$ya,$Me){$sa=array();foreach($m
as$l)$sa[]=($l[1]?($Q!=""?($l[0]!=""?"CHANGE ".idf_escape($l[0]):"ADD"):" ")." ".implode($l[1]).($Q!=""?$l[2]:""):"DROP ".idf_escape($l[0]));$sa=array_merge($sa,$zc);$eg=($bb!==null?" COMMENT=".q($bb):"").($Yb?" ENGINE=".q($Yb):"").($Wa?" COLLATE ".q($Wa):"").($ya!=""?" AUTO_INCREMENT=$ya":"");if($Q=="")return
queries("CREATE TABLE ".table($E)." (\n".implode(",\n",$sa)."\n)$eg$Me");if($Q!=$E)$sa[]="RENAME TO ".table($E);if($eg)$sa[]=ltrim($eg);return($sa||$Me?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$sa).$Me):true);}function
alter_indexes($Q,$sa){foreach($sa
as$y=>$X)$sa[$y]=($X[2]=="DROP"?"\nDROP INDEX ".idf_escape($X[1]):"\nADD $X[0] ".($X[0]=="PRIMARY"?"KEY ":"").($X[1]!=""?idf_escape($X[1])." ":"")."(".implode(", ",$X[2]).")");return
queries("ALTER TABLE ".table($Q).implode(",",$sa));}function
truncate_tables($S){return
apply_queries("TRUNCATE TABLE",$S);}function
drop_views($sh){return
queries("DROP VIEW ".implode(", ",array_map('table',$sh)));}function
drop_tables($S){return
queries("DROP TABLE ".implode(", ",array_map('table',$S)));}function
move_tables($S,$sh,$xg){$vf=array();foreach(array_merge($S,$sh)as$Q)$vf[]=table($Q)." TO ".idf_escape($xg).".".table($Q);return
queries("RENAME TABLE ".implode(", ",$vf));}function
copy_tables($S,$sh,$xg){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($S
as$Q){$E=($xg==DB?table("copy_$Q"):idf_escape($xg).".".table($Q));if(($_POST["overwrite"]&&!queries("\nDROP TABLE IF EXISTS $E"))||!queries("CREATE TABLE $E LIKE ".table($Q))||!queries("INSERT INTO $E SELECT * FROM ".table($Q)))return
false;foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$L){$Rg=$L["Trigger"];if(!queries("CREATE TRIGGER ".($xg==DB?idf_escape("copy_$Rg"):idf_escape($xg).".".idf_escape($Rg))." $L[Timing] $L[Event] ON $E FOR EACH ROW\n$L[Statement];"))return
false;}}foreach($sh
as$Q){$E=($xg==DB?table("copy_$Q"):idf_escape($xg).".".table($Q));$rh=view($Q);if(($_POST["overwrite"]&&!queries("DROP VIEW IF EXISTS $E"))||!queries("CREATE VIEW $E AS $rh[select]"))return
false;}return
true;}function
trigger($E){if($E=="")return
array();$M=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($E));return
reset($M);}function
triggers($Q){$K=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")))as$L)$K[$L["Trigger"]]=array($L["Timing"],$L["Event"]);return$K;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
routine($E,$U){global$e,$ac,$bd,$Wg;$qa=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$Yf="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|-- )[^\n]*\n?|--\r?\n)";$Vg="((".implode("|",array_merge(array_keys($Wg),$qa)).")\\b(?:\\s*\\(((?:[^'\")]|$ac)++)\\))?\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$Qe="$Yf*(".($U=="FUNCTION"?"":$bd).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$Vg";$g=$e->result("SHOW CREATE $U ".idf_escape($E),2);preg_match("~\\(((?:$Qe\\s*,?)*)\\)\\s*".($U=="FUNCTION"?"RETURNS\\s+$Vg\\s+":"")."(.*)~is",$g,$B);$m=array();preg_match_all("~$Qe\\s*,?~is",$B[1],$Gd,PREG_SET_ORDER);foreach($Gd
as$He)$m[]=array("field"=>str_replace("``","`",$He[2]).$He[3],"type"=>strtolower($He[5]),"length"=>preg_replace_callback("~$ac~s",'normalize_enum',$He[6]),"unsigned"=>strtolower(preg_replace('~\s+~',' ',trim("$He[8] $He[7]"))),"null"=>1,"full_type"=>$He[4],"inout"=>strtoupper($He[1]),"collation"=>strtolower($He[9]),);if($U!="FUNCTION")return
array("fields"=>$m,"definition"=>$B[11]);return
array("fields"=>$m,"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 = ".q(DB));}function
routine_languages(){return
array();}function
routine_id($E,$L){return
idf_escape($E);}function
last_id(){global$e;return$e->result("SELECT LAST_INSERT_ID()");}function
explain($e,$I){return$e->query("EXPLAIN ".(min_version(5.1)&&!min_version(5.7)?"PARTITIONS ":"").$I);}function
found_rows($R,$Z){return($Z||$R["Engine"]!="InnoDB"?null:$R["Rows"]);}function
types(){return
array();}function
schemas(){return
array();}function
get_schema(){return"";}function
set_schema($Gf,$f=null){return
true;}function
create_sql($Q,$ya,$jg){global$e;$K=$e->result("SHOW CREATE TABLE ".table($Q),1);if(!$ya)$K=preg_replace('~ AUTO_INCREMENT=\d+~','',$K);return$K;}function
truncate_sql($Q){return"TRUNCATE ".table($Q);}function
use_sql($ub){return"USE ".idf_escape($ub);}function
trigger_sql($Q){$K="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$L)$K.="\nCREATE TRIGGER ".idf_escape($L["Trigger"])." $L[Timing] $L[Event] ON ".table($L["Table"])." FOR EACH ROW\n$L[Statement];;\n";return$K;}function
show_variables(){return
get_key_vals("SHOW VARIABLES");}function
process_list(){return
get_rows("SHOW FULL PROCESSLIST");}function
show_status(){return
get_key_vals("SHOW STATUS");}function
convert_field($l){if(preg_match("~binary~",$l["type"]))return"HEX(".idf_escape($l["field"]).")";if($l["type"]=="bit")return"BIN(".idf_escape($l["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$l["type"]))return(min_version(8)?"ST_":"")."AsWKT(".idf_escape($l["field"]).")";}function
unconvert_field($l,$K){if(preg_match("~binary~",$l["type"]))$K="UNHEX($K)";if($l["type"]=="bit")$K="CONV($K, 2, 10) + 0";if(preg_match("~geometry|point|linestring|polygon~",$l["type"]))$K=(min_version(8)?"ST_":"")."GeomFromText($K, SRID($l[field]))";return$K;}function
support($rc){return!preg_match("~scheme|sequence|type|view_trigger|materializedview".(min_version(8)?"":"|descidx".(min_version(5.1)?"":"|event|partitioning".(min_version(5)?"":"|routine|trigger|view")))."~",$rc);}function
kill_process($X){return
queries("KILL ".number($X));}function
connection_id(){return"SELECT CONNECTION_ID()";}function
max_connections(){global$e;return$e->result("SELECT @@max_connections");}function
driver_config(){$Wg=array();$ig=array();foreach(array('Zahlen'=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),'Datum und Zeit'=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),'Zeichenketten'=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),'Listen'=>array("enum"=>65535,"set"=>64),'Binär'=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),'Geometrie'=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),)as$y=>$X){$Wg+=$X;$ig[$y]=array_keys($X);}return
array('possible_drivers'=>array("MySQLi","MySQL","PDO_MySQL"),'jush'=>"sql",'types'=>$Wg,'structured_types'=>$ig,'unsigned'=>array("unsigned","zerofill","unsigned zerofill"),'operators'=>array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","FIND_IN_SET","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL"),'functions'=>array("char_length","date","from_unixtime","lower","round","floor","ceil","sec_to_time","time_to_sec","upper"),'grouping'=>array("avg","count","count distinct","group_concat","max","min","sum"),'edit_functions'=>array(array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",),array(number_type()=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",)),);}}$eb=driver_config();$Ye=$eb['possible_drivers'];$x=$eb['jush'];$Wg=$eb['types'];$ig=$eb['structured_types'];$dh=$eb['unsigned'];$re=$eb['operators'];$Ec=$eb['functions'];$Ic=$eb['grouping'];$Qb=$eb['edit_functions'];if($b->operators===null)$b->operators=$re;define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~\?.*~','',relative_uri()).'?'.(sid()?SID.'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));$ga="4.8.0";function
page_header($Fg,$k="",$Ha=array(),$Gg=""){global$ca,$ga,$b,$Jb,$x;page_headers();if(is_ajax()&&$k){page_messages($k);exit;}$Hg=$Fg.($Gg!=""?": $Gg":"");$Ig=strip_tags($Hg.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$b->name());echo'
',$Ig,'
',script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=4.8.0");if($b->head()){echo'
';foreach($b->css()as$pb){echo'
';}}echo'
';$uc=get_temp_dir()."/adminer.version";if(!$_COOKIE["adminer_version"]&&function_exists('openssl_verify')&&file_exists($uc)&&filemtime($uc)+86400>time()){$qh=unserialize(file_get_contents($uc));$if="-----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($qh["version"],base64_decode($qh["signature"]),$if)==1)$_COOKIE["adminer_version"]=$qh["version"];}echo'
',script("mixin(qs('#help'), {onmouseover: function () { helpOpen = 1; }, onmouseout: helpMouseout});"),'
';if($Ha!==null){$_=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'
'.$Jb[DRIVER].' » ';$_=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$O=$b->serverName(SERVER);$O=($O!=""?$O:'Server');if($Ha===false)echo"$O\n";else{echo"$O » ";if($_GET["ns"]!=""||(DB!=""&&is_array($Ha)))echo''.h(DB).' » ';if(is_array($Ha)){if($_GET["ns"]!="")echo''.h($_GET["ns"]).' » ';foreach($Ha
as$y=>$X){$Cb=(is_array($X)?$X[1]:h($X));if($Cb!="")echo"$Cb » ";}}echo"$Fg\n";}}echo"
$Hg
\n","
\n";restart_session();page_messages($k);$h=&get_session("dbs");if(DB!=""&&$h&&!in_array(DB,$h,true))$h=null;stop_session();define("PAGE_HEADER",1);}function
page_headers(){global$b;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($b->csp()as$ob){$Oc=array();foreach($ob
as$y=>$X)$Oc[]="$y $X";header("Content-Security-Policy: ".implode("; ",$Oc));}$b->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$be;if(!$be)$be=base64_encode(rand_string());return$be;}function
page_messages($k){$fh=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Rd=$_SESSION["messages"][$fh];if($Rd){echo"
".implode("
\n
",$Rd)."
".script("messagesPrint();");unset($_SESSION["messages"][$fh]);}if($k)echo"
$k
\n";}function
page_footer($Td=""){global$b,$T;echo'
';if($Td!="auth"){echo'
';}echo'
',script("setupSubmitHighlight(document);");}function
int32($D){while($D>=2147483648)$D-=4294967296;while($D<=-2147483649)$D+=4294967296;return(int)$D;}function
long2str($W,$uh){$Ef='';foreach($W
as$X)$Ef.=pack('V',$X);if($uh)return
substr($Ef,0,end($W));return$Ef;}function
str2long($Ef,$uh){$W=array_values(unpack('V*',str_pad($Ef,4*ceil(strlen($Ef)/4),"\0")));if($uh)$W[]=strlen($Ef);return$W;}function
xxtea_mx($Ah,$_h,$mg,$md){return
int32((($Ah>>5&0x7FFFFFF)^$_h<<2)+(($_h>>3&0x1FFFFFFF)^$Ah<<4))^int32(($mg^$_h)+($md^$Ah));}function
encrypt_string($gg,$y){if($gg=="")return"";$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($gg,true);$D=count($W)-1;$Ah=$W[$D];$_h=$W[0];$H=floor(6+52/($D+1));$mg=0;while($H-->0){$mg=int32($mg+0x9E3779B9);$Pb=$mg>>2&3;for($Fe=0;$Fe<$D;$Fe++){$_h=$W[$Fe+1];$Vd=xxtea_mx($Ah,$_h,$mg,$y[$Fe&3^$Pb]);$Ah=int32($W[$Fe]+$Vd);$W[$Fe]=$Ah;}$_h=$W[0];$Vd=xxtea_mx($Ah,$_h,$mg,$y[$Fe&3^$Pb]);$Ah=int32($W[$D]+$Vd);$W[$D]=$Ah;}return
long2str($W,false);}function
decrypt_string($gg,$y){if($gg=="")return"";if(!$y)return
false;$y=array_values(unpack("V*",pack("H*",md5($y))));$W=str2long($gg,false);$D=count($W)-1;$Ah=$W[$D];$_h=$W[0];$H=floor(6+52/($D+1));$mg=int32($H*0x9E3779B9);while($mg){$Pb=$mg>>2&3;for($Fe=$D;$Fe>0;$Fe--){$Ah=$W[$Fe-1];$Vd=xxtea_mx($Ah,$_h,$mg,$y[$Fe&3^$Pb]);$_h=int32($W[$Fe]-$Vd);$W[$Fe]=$_h;}$Ah=$W[$D];$Vd=xxtea_mx($Ah,$_h,$mg,$y[$Fe&3^$Pb]);$_h=int32($W[0]-$Vd);$W[0]=$_h;$mg=int32($mg-0x9E3779B9);}return
long2str($W,true);}$e='';$Nc=$_SESSION["token"];if(!$Nc)$_SESSION["token"]=rand(1,1e6);$T=get_token();$Se=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($y)=explode(":",$X);$Se[$y]=$X;}}function
add_invalid_login(){global$b;$p=file_open_lock(get_temp_dir()."/adminer.invalid");if(!$p)return;$gd=unserialize(stream_get_contents($p));$Cg=time();if($gd){foreach($gd
as$hd=>$X){if($X[0]<$Cg)unset($gd[$hd]);}}$fd=&$gd[$b->bruteForceKey()];if(!$fd)$fd=array($Cg+30*60,0);$fd[1]++;file_write_unlock($p,serialize($gd));}function
check_invalid_login(){global$b;$gd=unserialize(@file_get_contents(get_temp_dir()."/adminer.invalid"));$fd=$gd[$b->bruteForceKey()];$ae=($fd[1]>29?$fd[0]-time():0);if($ae>0)auth_error(lang(array('Zu viele erfolglose Login-Versuche. Bitte probieren Sie es in %d Minute noch einmal.','Zu viele erfolglose Login-Versuche. Bitte probieren Sie es in %d Minuten noch einmal.'),ceil($ae/60)));}$xa=$_POST["auth"];if($xa){session_regenerate_id();$ph=$xa["driver"];$O=$xa["server"];$V=$xa["username"];$G=(string)$xa["password"];$i=$xa["db"];set_password($ph,$O,$V,$G);$_SESSION["db"][$ph][$O][$V][$i]=true;if($xa["permanent"]){$y=base64_encode($ph)."-".base64_encode($O)."-".base64_encode($V)."-".base64_encode($i);$df=$b->permanentLogin(true);$Se[$y]="$y:".base64_encode($df?encrypt_string($G,$df):"");cookie("adminer_permanent",implode(" ",$Se));}if(count($_POST)==1||DRIVER!=$ph||SERVER!=$O||$_GET["username"]!==$V||DB!=$i)redirect(auth_url($ph,$O,$V,$i));}elseif($_POST["logout"]&&(!$Nc||verify_token())){foreach(array("pwds","db","dbs","queries")as$y)set_session($y,null);unset_permanent();redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),'Abmeldung erfolgreich.'.' '.'Danke, dass Sie Adminer genutzt haben. Spenden willkommen!');}elseif($Se&&!$_SESSION["pwds"]){session_regenerate_id();$df=$b->permanentLogin();foreach($Se
as$y=>$X){list(,$Qa)=explode(":",$X);list($ph,$O,$V,$i)=array_map('base64_decode',explode("-",$y));set_password($ph,$O,$V,decrypt_string(base64_decode($Qa),$df));$_SESSION["db"][$ph][$O][$V][$i]=true;}}function
unset_permanent(){global$Se;foreach($Se
as$y=>$X){list($ph,$O,$V,$i)=array_map('base64_decode',explode("-",$y));if($ph==DRIVER&&$O==SERVER&&$V==$_GET["username"]&&$i==DB)unset($Se[$y]);}cookie("adminer_permanent",implode(" ",$Se));}function
auth_error($k){global$b,$Nc;$Qf=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$Qf]||$_GET[$Qf])&&!$Nc)$k='Sitzungsdauer abgelaufen, bitte erneut anmelden.';else{restart_session();add_invalid_login();$G=get_password();if($G!==null){if($G===false)$k.=($k?'
':'').sprintf('Das Master-Passwort ist abgelaufen. Implementieren Sie die %s Methode, um es permanent zu machen.',target_blank(),'permanentLogin()
');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent();}}if(!$_COOKIE[$Qf]&&$_GET[$Qf]&&ini_bool("session.use_only_cookies"))$k='Unterstüzung für PHP-Sessions muss aktiviert sein.';$Ie=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?$_COOKIE["adminer_key"]:rand_string()),$Ie["lifetime"]);page_header('Login',$k,null);echo"\n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header('Keine Erweiterungen installiert',sprintf('Keine der unterstützten PHP-Erweiterungen (%s) ist vorhanden.',implode(", ",$Ye)),false);page_footer("auth");exit;}stop_session(true);if(isset($_GET["username"])&&is_string(get_password())){list($Sc,$Ue)=explode(":",SERVER,2);if(preg_match('~^\s*([-+]?\d+)~',$Ue,$B)&&($B[1]<1024||$B[1]>65535))auth_error('Connecting to privileged ports is not allowed.');check_invalid_login();$e=connect();$j=new
Min_Driver($e);}$Cd=null;if(!is_object($e)||($Cd=$b->login($_GET["username"],get_password()))!==true){$k=(is_string($e)?h($e):(is_string($Cd)?$Cd:'Ungültige Anmelde-Informationen.'));auth_error($k.(preg_match('~^ | $~',get_password())?'
'.'There is a space in the input password which might be the cause.':''));}if($_POST["logout"]&&$Nc&&!verify_token()){page_header('Abmelden','CSRF Token ungültig. Bitte die Formulardaten erneut abschicken.');page_footer("db");exit;}if($xa&&$_POST["token"])$_POST["token"]=$T;$k='';if($_POST){if(!verify_token()){$ad="max_input_vars";$Md=ini_get($ad);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$y){$X=ini_get($y);if($X&&(!$Md||$X<$Md)){$ad=$y;$Md=$X;}}}$k=(!$_POST["token"]&&$Md?sprintf('Die maximal erlaubte Anzahl der Felder ist überschritten. Bitte %s erhöhen.',"'$ad'"):'CSRF Token ungültig. Bitte die Formulardaten erneut abschicken.'.' '.'Wenn Sie diese Anfrage nicht von Adminer gesendet haben, schließen Sie diese Seite.');}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$k=sprintf('POST-Daten sind zu groß. Reduzieren Sie die Größe oder vergrößern Sie den Wert %s in der Konfiguration.',"'post_max_size'");if(isset($_GET["sql"]))$k.=' '.'Sie können eine große SQL-Datei per FTP hochladen und dann vom Server importieren.';}function
select($J,$f=null,$ye=array(),$z=0){global$x;$Bd=array();$w=array();$d=array();$Fa=array();$Wg=array();$K=array();odd('');for($t=0;(!$z||$t<$z)&&($L=$J->fetch_row());$t++){if(!$t){echo"":"".'Keine Datensätze.')."\n";return$K;}function
referencable_primary($Lf){$K=array();foreach(table_status('',true)as$qg=>$Q){if($qg!=$Lf&&fk_support($Q)){foreach(fields($qg)as$l){if($l["primary"]){if($K[$qg]){unset($K[$qg]);break;}$K[$qg]=$l;}}}}return$K;}function
adminer_settings(){parse_str($_COOKIE["adminer_settings"],$Sf);return$Sf;}function
adminer_setting($y){$Sf=adminer_settings();return$Sf[$y];}function
set_adminer_settings($Sf){return
cookie("adminer_settings",http_build_query($Sf+adminer_settings()));}function
textarea($E,$Y,$M=10,$Ya=80){global$x;echo"";}function
edit_type($y,$l,$Xa,$o=array(),$oc=array()){global$ig,$Wg,$dh,$ne;$U=$l["type"];echo'
| | ',"',($dh?"':''),(isset($l['on_update'])?"':''),($o?" ":" ");}function
process_length($zd){global$ac;return(preg_match("~^\\s*\\(?\\s*$ac(?:\\s*,\\s*$ac)*+\\s*\\)?\\s*\$~",$zd)&&preg_match_all("~$ac~",$zd,$Gd)?"(".implode(",",$Gd[0]).")":preg_replace('~^[0-9].*~','(\0)',preg_replace('~[^-0-9,+()[\]]~','',$zd)));}function
process_type($l,$Va="COLLATE"){global$dh;return" $l[type]".process_length($l["length"]).(preg_match(number_type(),$l["type"])&&in_array($l["unsigned"],$dh)?" $l[unsigned]":"").(preg_match('~char|text|enum|set~',$l["type"])&&$l["collation"]?" $Va ".q($l["collation"]):"");}function
process_field($l,$Ug){return
array(idf_escape(trim($l["field"])),process_type($Ug),($l["null"]?" NULL":" NOT NULL"),default_value($l),(preg_match('~timestamp|datetime~',$l["type"])&&$l["on_update"]?" ON UPDATE $l[on_update]":""),(support("comment")&&$l["comment"]!=""?" COMMENT ".q($l["comment"]):""),($l["auto_increment"]?auto_increment():null),);}function
default_value($l){$zb=$l["default"];return($zb===null?"":" DEFAULT ".(preg_match('~char|binary|text|enum|set~',$l["type"])||preg_match('~^(?![a-z])~i',$zb)?q($zb):$zb));}function
type_class($U){foreach(array('char'=>'text','date'=>'time|year','binary'=>'blob','enum'=>'set',)as$y=>$X){if(preg_match("~$y|$X~",$U))return" class='$y'";}}function
edit_fields($m,$Xa,$U="TABLE",$o=array()){global$bd;$m=array_values($m);$_b=(($_POST?$_POST["defaults"]:adminer_setting("defaults"))?"":" class='hidden'");$cb=(($_POST?$_POST["comments"]:adminer_setting("comments"))?"":" class='hidden'");echo'
';if($U=="PROCEDURE"){echo'';}echo' | ',($U=="TABLE"?'Spaltenname':'Name des Parameters'),' | Typ',script("qs('#enum-edit').onblur = editingLengthBlur;"),' | Länge
| ','Optionen';if($U=="TABLE"){echo' | NULL
| AI',doc_link(array('sql'=>"example-auto-increment.html",'mariadb'=>"auto_increment/",)),' | Vorgabewert festlegen
',(support("comment")?" | ',"".script("row_count = ".count($m).";"),' |
|
',script("mixin(qsl('tbody'), {onclick: editingClick, onkeydown: editingKeydown, oninput: editingInput});");foreach($m
as$t=>$l){$t++;$ze=$l[($_POST?"orig":"field")];$Gb=(isset($_POST["add"][$t-1])||(isset($l["field"])&&!$_POST["drop_col"][$t]))&&(support("drop_col")||$ze=="");echo'
',($U=="PROCEDURE"?"".html_select("fields[$t][inout]",explode("|",$bd),$l["inout"]):""),' | ';if($Gb){echo'';}echo'';edit_type("fields[$t]",$l,$Xa,$o);if($U=="TABLE"){echo' | ',checkbox("fields[$t][null]",1,$l["null"],"","","block","label-null"),' | | ',checkbox("fields[$t][has_default]",1,$l["has_default"],"","","","label-default"),'',(support("comment")?" | ":"");}echo" | ",(support("move_col")?" "." "." ":""),($ze==""||support("drop_col")?"":"");}}function
process_fields(&$m){$ge=0;if($_POST["up"]){$td=0;foreach($m
as$y=>$l){if(key($_POST["up"])==$y){unset($m[$y]);array_splice($m,$td,0,array($l));break;}if(isset($l["field"]))$td=$ge;$ge++;}}elseif($_POST["down"]){$Bc=false;foreach($m
as$y=>$l){if(isset($l["field"])&&$Bc){unset($m[key($_POST["down"])]);array_splice($m,$ge,0,array($Bc));break;}if(key($_POST["down"])==$y)$Bc=$l;$ge++;}}elseif($_POST["add"]){$m=array_values($m);array_splice($m,key($_POST["add"]),0,array(array()));}elseif(!$_POST["drop_col"])return
false;return
true;}function
normalize_enum($B){return"'".str_replace("'","''",addcslashes(stripcslashes(str_replace($B[0][0].$B[0][0],$B[0][0],substr($B[0],1,-1))),'\\'))."'";}function
grant($r,$ff,$d,$me){if(!$ff)return
true;if($ff==array("ALL PRIVILEGES","GRANT OPTION"))return($r=="GRANT"?queries("$r ALL PRIVILEGES$me WITH GRANT OPTION"):queries("$r ALL PRIVILEGES$me")&&queries("$r GRANT OPTION$me"));return
queries("$r ".preg_replace('~(GRANT OPTION)\([^)]*\)~','\1',implode("$d, ",$ff).$d).$me);}function
drop_create($Kb,$g,$Lb,$_g,$Mb,$A,$Qd,$Od,$Pd,$je,$Yd){if($_POST["drop"])query_redirect($Kb,$A,$Qd);elseif($je=="")query_redirect($g,$A,$Pd);elseif($je!=$Yd){$mb=queries($g);queries_redirect($A,$Od,$mb&&queries($Kb));if($mb)queries($Lb);}else
queries_redirect($A,$Od,queries($_g)&&queries($Mb)&&queries($Kb)&&queries($g));}function
create_trigger($me,$L){global$x;$Eg=" $L[Timing] $L[Event]".($L["Event"]=="UPDATE OF"?" ".idf_escape($L["Of"]):"");return"CREATE TRIGGER ".idf_escape($L["Trigger"]).($x=="mssql"?$me.$Eg:$Eg.$me).rtrim(" $L[Type]\n$L[Statement]",";").";";}function
create_routine($Bf,$L){global$bd,$x;$P=array();$m=(array)$L["fields"];ksort($m);foreach($m
as$l){if($l["field"]!="")$P[]=(preg_match("~^($bd)\$~",$l["inout"])?"$l[inout] ":"").idf_escape($l["field"]).process_type($l,"CHARACTER SET");}$Ab=rtrim("\n$L[definition]",";");return"CREATE $Bf ".idf_escape(trim($L["name"]))." (".implode(", ",$P).")".(isset($_GET["function"])?" RETURNS".process_type($L["returns"],"CHARACTER SET"):"").($L["language"]?" LANGUAGE $L[language]":"").($x=="pgsql"?" AS ".q($Ab):"$Ab;");}function
remove_definer($I){return
preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\1)',logged_user()).'`~','\1',$I);}function
format_foreign_key($n){global$ne;$i=$n["db"];$ce=$n["ns"];return" FOREIGN KEY (".implode(", ",array_map('idf_escape',$n["source"])).") REFERENCES ".($i!=""&&$i!=$_GET["db"]?idf_escape($i).".":"").($ce!=""&&$ce!=$_GET["ns"]?idf_escape($ce).".":"").table($n["table"])." (".implode(", ",array_map('idf_escape',$n["target"])).")".(preg_match("~^($ne)\$~",$n["on_delete"])?" ON DELETE $n[on_delete]":"").(preg_match("~^($ne)\$~",$n["on_update"])?" ON UPDATE $n[on_update]":"");}function
tar_file($uc,$Jg){$K=pack("a100a8a8a8a12a12",$uc,644,0,0,decoct($Jg->size),decoct(time()));$Pa=8*32;for($t=0;$tsend();echo
str_repeat("\0",511-($Jg->size+511)%512);}function
ini_bytes($ad){$X=ini_get($ad);switch(strtolower(substr($X,-1))){case'g':$X*=1024;case'm':$X*=1024;case'k':$X*=1024;}return$X;}function
doc_link($Pe,$Ag="?"){global$x,$e;$Of=$e->server_info;$qh=preg_replace('~^(\d\.?\d).*~s','\1',$Of);$hh=array('sql'=>"https://dev.mysql.com/doc/refman/$qh/en/",'sqlite'=>"https://www.sqlite.org/",'pgsql'=>"https://www.postgresql.org/docs/$qh/",'mssql'=>"https://msdn.microsoft.com/library/",'oracle'=>"https://www.oracle.com/pls/topic/lookup?ctx=db".preg_replace('~^.* (\d+)\.(\d+)\.\d+\.\d+\.\d+.*~s','\1\2',$Of)."&id=",);if(preg_match('~MariaDB~',$Of)){$hh['sql']="https://mariadb.com/kb/en/library/";$Pe['sql']=(isset($Pe['mariadb'])?$Pe['mariadb']:str_replace(".html","/",$Pe['sql']));}return($Pe[$x]?"$Ag":"");}function
ob_gzencode($hg){return
gzencode($hg);}function
db_size($i){global$e;if(!$e->select_db($i))return"?";$K=0;foreach(table_status()as$R)$K+=$R["Data_length"]+$R["Index_length"];return
format_number($K);}function
set_utf8mb4($g){global$e;static$P=false;if(!$P&&preg_match('~\butf8mb4~i',$g)){$P=true;echo"SET NAMES ".charset($e).";\n\n";}}function
connect_error(){global$b,$e,$T,$k,$Jb;if(DB!=""){header("HTTP/1.1 404 Not Found");page_header('Datenbank'.": ".h(DB),'Datenbank ungültig.',true);}else{if($_POST["db"]&&!$k)queries_redirect(substr(ME,0,-1),'Datenbanken wurden entfernt.',drop_databases($_POST["db"]));page_header('Datenbank auswählen',$k,false);echo" \n";foreach(array('database'=>'Datenbank erstellen','privileges'=>'Rechte','processlist'=>'Prozessliste','variables'=>'Variablen','status'=>'Status',)as$y=>$X){if(support($y))echo"$X\n";}echo" ".sprintf('Version %s: %s mit PHP-Erweiterung %s',$Jb[DRIVER],"".h($e->server_info)."","$e->extension")."\n"," ".sprintf('Angemeldet als: %s',"".h(logged_user())."")."\n";$h=$b->databases();if($h){$Hf=support("scheme");$Xa=collations();echo" \n",script("tableCheck();");}}page_footer("db");}if(isset($_GET["status"]))$_GET["variables"]=$_GET["status"];if(isset($_GET["import"]))$_GET["sql"]=$_GET["import"];if(!(DB!=""?$e->select_db(DB):isset($_GET["sql"])||isset($_GET["dump"])||isset($_GET["database"])||isset($_GET["processlist"])||isset($_GET["privileges"])||isset($_GET["user"])||isset($_GET["variables"])||$_GET["script"]=="connect"||$_GET["script"]=="kill")){if(DB!=""||$_GET["refresh"]){restart_session();set_session("dbs",null);}connect_error();exit;}$ne="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";class
TmpFile{var$handler;var$size;function
__construct(){$this->handler=tmpfile();}function
write($hb){$this->size+=strlen($hb);fwrite($this->handler,$hb);}function
send(){fseek($this->handler,0);fpassthru($this->handler);fclose($this->handler);}}$ac="'(?:''|[^'\\\\]|\\\\.)*'";$bd="IN|OUT|INOUT";if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["callf"]))$_GET["call"]=$_GET["callf"];if(isset($_GET["function"]))$_GET["procedure"]=$_GET["function"];if(isset($_GET["download"])){$a=$_GET["download"];$m=fields($a);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$a-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$N=array(idf_escape($_GET["field"]));$J=$j->select($a,$N,array(where($_GET,$m)),$N);$L=($J?$J->fetch_row():array());echo$j->value($L[0],$m[$_GET["field"]]);exit;}elseif(isset($_GET["table"])){$a=$_GET["table"];$m=fields($a);if(!$m)$k=error();$R=table_status1($a,true);$E=$b->tableName($R);page_header(($m&&is_view($R)?$R['Engine']=='materialized view'?'Materialized view':'View':'Tabelle').": ".($E!=""?$E:h($a)),$k);$b->selectLinks($R);$bb=$R["Comment"];if($bb!="")echo"".'Kommentar'.": ".h($bb)."\n";if($m)$b->tableStructurePrint($m);if(!is_view($R)){if(support("indexes")){echo" ".'Indizes'."\n";$w=indexes($a);if($w)$b->tableIndexesPrint($w);echo''.'Indizes ändern'."\n";}if(fk_support($R)){echo" ".'Fremdschlüssel'."\n";$o=foreign_keys($a);if($o){echo"\n","".'Ursprung'." | ".'Ziel'." | ".'ON DELETE'." | ".'ON UPDATE'." | | \n";foreach($o
as$E=>$n){echo"","".implode(", ",array_map('h',$n["source"])).""," | ".($n["db"]!=""?"".h($n["db"]).".":"").($n["ns"]!=""?"".h($n["ns"]).".":"").h($n["table"])."","(".implode(", ",array_map('h',$n["target"])).")"," | ".h($n["on_delete"])."\n"," | ".h($n["on_update"])."\n",' | '.'Ändern'.'';}echo" | \n";}echo''.'Fremdschlüssel hinzufügen'."\n";}}if(support(is_view($R)?"view_trigger":"trigger")){echo" ".'Trigger'."\n";$Tg=triggers($a);if($Tg){echo"\n";foreach($Tg
as$y=>$X)echo"".h($X[0])." | ".h($X[1])." | ".h($y)." | ".'Ändern'."\n";echo" |
---|
\n";}echo''.'Trigger hinzufügen'."\n";}}elseif(isset($_GET["schema"])){page_header('Datenbankschema',"",array(),h(DB.($_GET["ns"]?".$_GET[ns]":"")));$rg=array();$sg=array();$ea=($_GET["schema"]?$_GET["schema"]:$_COOKIE["adminer_schema-".str_replace(".","_",DB)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$ea,$Gd,PREG_SET_ORDER);foreach($Gd
as$t=>$B){$rg[$B[1]]=array($B[2],$B[3]);$sg[]="\n\t'".js_escape($B[1])."': [ $B[2], $B[3] ]";}$Lg=0;$Ca=-1;$Gf=array();$sf=array();$xd=array();foreach(table_status('',true)as$Q=>$R){if(is_view($R))continue;$Ve=0;$Gf[$Q]["fields"]=array();foreach(fields($Q)as$E=>$l){$Ve+=1.25;$l["pos"]=$Ve;$Gf[$Q]["fields"][$E]=$l;}$Gf[$Q]["pos"]=($rg[$Q]?$rg[$Q]:array($Lg,0));foreach($b->foreignKeys($Q)as$X){if(!$X["db"]){$vd=$Ca;if($rg[$Q][1]||$rg[$X["table"]][1])$vd=min(floatval($rg[$Q][1]),floatval($rg[$X["table"]][1]))-1;else$Ca-=.1;while($xd[(string)$vd])$vd-=.0001;$Gf[$Q]["references"][$X["table"]][(string)$vd]=array($X["source"],$X["target"]);$sf[$X["table"]][$Q][(string)$vd]=$X["target"];$xd[(string)$vd]=true;}}$Lg=max($Lg,$Gf[$Q]["pos"][0]+2.5+$Ve);}echo'
';foreach($Gf
as$E=>$Q){echo" ",' '.h($E)."",script("qsl('div').onmousedown = schemaMousedown;");foreach($Q["fields"]as$l){$X=' '.h($l["field"]).'';echo" ".($l["primary"]?" $X":$X);}foreach((array)$Q["references"]as$yg=>$tf){foreach($tf
as$vd=>$pf){$wd=$vd-$rg[$E][1];$t=0;foreach($pf[0]as$Xf)echo"\n ";}}foreach((array)$sf[$E]as$yg=>$tf){foreach($tf
as$vd=>$d){$wd=$vd-$rg[$E][1];$t=0;foreach($d
as$xg)echo"\n ";}}echo"\n \n";}foreach($Gf
as$E=>$Q){foreach((array)$Q["references"]as$yg=>$tf){foreach($tf
as$vd=>$pf){$Sd=$Lg;$Kd=-10;foreach($pf[0]as$y=>$Xf){$We=$Q["pos"][0]+$Q["fields"][$Xf]["pos"];$Xe=$Gf[$yg]["pos"][0]+$Gf[$yg]["fields"][$pf[1][$y]]["pos"];$Sd=min($Sd,$We,$Xe);$Kd=max($Kd,$We,$Xe);}echo" \n";}}}echo'
Dauerhafter Link
';}elseif(isset($_GET["dump"])){$a=$_GET["dump"];if($_POST&&!$k){$kb="";foreach(array("output","format","db_style","routines","events","table_style","auto_increment","triggers","data_style")as$y)$kb.="&$y=".urlencode($_POST[$y]);cookie("adminer_export",substr($kb,1));$S=array_flip((array)$_POST["tables"])+array_flip((array)$_POST["data"]);$mc=dump_headers((count($S)==1?key($S):DB),(DB==""||count($S)>1));$jd=preg_match('~sql~',$_POST["format"]);if($jd){echo"-- Adminer $ga ".$Jb[DRIVER]." ".str_replace("\n"," ",$e->server_info)." dump\n\n";if($x=="sql"){echo"SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
".($_POST["data_style"]?"SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
":"")."
";$e->query("SET time_zone = '+00:00'");$e->query("SET sql_mode = ''");}}$jg=$_POST["db_style"];$h=array(DB);if(DB==""){$h=$_POST["databases"];if(is_string($h))$h=explode("\n",rtrim(str_replace("\r","",$h),"\n"));}foreach((array)$h
as$i){$b->dumpDatabase($i);if($e->select_db($i)){if($jd&&preg_match('~CREATE~',$jg)&&($g=$e->result("SHOW CREATE DATABASE ".idf_escape($i),1))){set_utf8mb4($g);if($jg=="DROP+CREATE")echo"DROP DATABASE IF EXISTS ".idf_escape($i).";\n";echo"$g;\n";}if($jd){if($jg)echo
use_sql($i).";\n\n";$De="";if($_POST["routines"]){foreach(array("FUNCTION","PROCEDURE")as$Bf){foreach(get_rows("SHOW $Bf STATUS WHERE Db = ".q($i),null,"-- ")as$L){$g=remove_definer($e->result("SHOW CREATE $Bf ".idf_escape($L["Name"]),2));set_utf8mb4($g);$De.=($jg!='DROP+CREATE'?"DROP $Bf IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$g;;\n\n";}}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$L){$g=remove_definer($e->result("SHOW CREATE EVENT ".idf_escape($L["Name"]),3));set_utf8mb4($g);$De.=($jg!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$g;;\n\n";}}if($De)echo"DELIMITER ;;\n\n$De"."DELIMITER ;\n\n";}if($_POST["table_style"]||$_POST["data_style"]){$sh=array();foreach(table_status('',true)as$E=>$R){$Q=(DB==""||in_array($E,(array)$_POST["tables"]));$sb=(DB==""||in_array($E,(array)$_POST["data"]));if($Q||$sb){if($mc=="tar"){$Jg=new
TmpFile;ob_start(array($Jg,'write'),1e5);}$b->dumpTable($E,($Q?$_POST["table_style"]:""),(is_view($R)?2:0));if(is_view($R))$sh[]=$E;elseif($sb){$m=fields($E);$b->dumpData($E,$_POST["data_style"],"SELECT *".convert_fields($m,$m)." FROM ".table($E));}if($jd&&$_POST["triggers"]&&$Q&&($Tg=trigger_sql($E)))echo"\nDELIMITER ;;\n$Tg\nDELIMITER ;\n";if($mc=="tar"){ob_end_flush();tar_file((DB!=""?"":"$i/")."$E.csv",$Jg);}elseif($jd)echo"\n";}}if(function_exists('foreign_keys_sql')){foreach(table_status('',true)as$E=>$R){$Q=(DB==""||in_array($E,(array)$_POST["tables"]));if($Q&&!is_view($R))echo
foreign_keys_sql($E);}}foreach($sh
as$rh)$b->dumpTable($rh,$_POST["table_style"],1);if($mc=="tar")echo
pack("x512");}}}if($jd)echo"-- ".$e->result("SELECT NOW()")."\n";exit;}page_header('Exportieren',$k,($_GET["export"]!=""?array("table"=>$_GET["export"]):array()),h(DB));echo'
';$wc=true;foreach($af
as$y=>$X){if($y!=""&&$X>1){echo($wc?"":" ")."".h($y)."";$wc=false;}}}elseif(isset($_GET["privileges"])){page_header('Rechte');echo' '.'Benutzer erstellen'."";$J=$e->query("SELECT User, Host FROM mysql.".(DB==""?"user":"db WHERE ".q(DB)." LIKE Db")." ORDER BY Host, User");$r=$J;if(!$J)$J=$e->query("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1) AS User, SUBSTRING_INDEX(CURRENT_USER, '@', -1) AS Host");echo" \n";}elseif(isset($_GET["sql"])){if(!$k&&$_POST["export"]){dump_headers("sql");$b->dumpTable("","");$b->dumpData("","table",$_POST["query"]);exit;}restart_session();$Rc=&get_session("queries");$Qc=&$Rc[DB];if(!$k&&$_POST["clear"]){$Qc=array();redirect(remove_from_uri("history"));}page_header((isset($_GET["import"])?'Importieren':'SQL-Kommando'),$k);if(!$k&&$_POST){$p=false;if(!isset($_GET["import"]))$I=$_POST["query"];elseif($_POST["webfile"]){$ag=$b->importServerPath();$p=@fopen((file_exists($ag)?$ag:"compress.zlib://$ag.gz"),"rb");$I=($p?fread($p,1e6):false);}else$I=get_file("sql_file",true);if(is_string($I)){if(function_exists('memory_get_usage'))@ini_set("memory_limit",max(ini_bytes("memory_limit"),2*strlen($I)+memory_get_usage()+8e6));if($I!=""&&strlen($I)<1e6){$H=$I.(preg_match("~;[ \t\r\n]*\$~",$I)?"":";");if(!$Qc||reset(end($Qc))!=$H){restart_session();$Qc[]=array($H,time());set_session("queries",$Rc);stop_session();}}$Yf="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|-- )[^\n]*\n?|--\r?\n)";$Bb=";";$ge=0;$Xb=true;$f=connect();if(is_object($f)&&DB!=""){$f->select_db(DB);if($_GET["ns"]!="")set_schema($_GET["ns"],$f);}$ab=0;$cc=array();$Je='[\'"'.($x=="sql"?'`#':($x=="sqlite"?'`[':($x=="mssql"?'[':''))).']|/\*|-- |$'.($x=="pgsql"?'|\$[^$]*\$':'');$Mg=microtime(true);parse_str($_COOKIE["adminer_export"],$la);$Ob=$b->dumpFormat();unset($Ob["sql"]);while($I!=""){if(!$ge&&preg_match("~^$Yf*+DELIMITER\\s+(\\S+)~i",$I,$B)){$Bb=$B[1];$I=substr($I,strlen($B[0]));}else{preg_match('('.preg_quote($Bb)."\\s*|$Je)",$I,$B,PREG_OFFSET_CAPTURE,$ge);list($Bc,$Ve)=$B[0];if(!$Bc&&$p&&!feof($p))$I.=fread($p,1e5);else{if(!$Bc&&rtrim($I)=="")break;$ge=$Ve+strlen($Bc);if($Bc&&rtrim($Bc)!=$Bb){while(preg_match('('.($Bc=='/*'?'\*/':($Bc=='['?']':(preg_match('~^-- |^#~',$Bc)?"\n":preg_quote($Bc)."|\\\\."))).'|$)s',$I,$B,PREG_OFFSET_CAPTURE,$ge)){$Ef=$B[0][0];if(!$Ef&&$p&&!feof($p))$I.=fread($p,1e5);else{$ge=$B[0][1]+strlen($Ef);if($Ef[0]!="\\")break;}}}else{$Xb=false;$H=substr($I,0,$Ve);$ab++;$cf="".$b->sqlCommandQuery($H)." \n";if($x=="sqlite"&&preg_match("~^$Yf*+ATTACH\\b~i",$H,$B)){echo$cf,"".'ATTACH queries are not supported.'."\n";$cc[]=" $ab";if($_POST["error_stops"])break;}else{if(!$_POST["only_errors"]){echo$cf;ob_flush();flush();}$dg=microtime(true);if($e->multi_query($H)&&is_object($f)&&preg_match("~^$Yf*+USE\\b~i",$H))$f->query($H);do{$J=$e->store_result();if($e->error){echo($_POST["only_errors"]?$cf:"")," ".'Fehler in der SQL-Abfrage'.($e->errno?" ($e->errno)":"").": ".error()."\n";$cc[]=" $ab";if($_POST["error_stops"])break
2;}else{$Cg=" (".format_time($dg).")".(strlen($H)<1000?" ".'Bearbeiten'."":"");$na=$e->affected_rows;$vh=($_POST["only_errors"]?"":$j->warnings());$wh="warnings-$ab";if($vh)$Cg.=", ".'Warnings'."".script("qsl('a').onclick = partial(toggle, '$wh');","");$kc=null;$lc="explain-$ab";if(is_object($J)){$z=$_POST["limit"];$ye=select($J,$f,array(),$z);if(!$_POST["only_errors"]){echo" \n";}}else{if(preg_match("~^$Yf*+(CREATE|DROP|ALTER)$Yf++(DATABASE|SCHEMA)\\b~i",$H)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"])echo"".lang(array('Abfrage ausgeführt, %d Datensatz betroffen.','Abfrage ausgeführt, %d Datensätze betroffen.'),$na)."$Cg\n";}echo($vh?" \n$vh \n":"");if($kc){echo"\n";select($kc,$f,$ye);echo" \n";}}$dg=microtime(true);}while($e->next_result());}$I=substr($I,$ge);$ge=0;}}}}if($Xb)echo"".'Kein Kommando vorhanden.'."\n";elseif($_POST["only_errors"]){echo" ".lang(array('SQL-Abfrage erfolgreich ausgeführt.','%d SQL-Abfragen erfolgreich ausgeführt.'),$ab-count($cc))," (".format_time($Mg).")\n";}elseif($cc&&$ab>1)echo" ".'Fehler in der SQL-Abfrage'.": ".implode("",$cc)."\n";}else
echo" ".upload_error($I)."\n";}echo'
';}elseif(isset($_GET["edit"])){$a=$_GET["edit"];$m=fields($a);$Z=(isset($_GET["select"])?($_POST["check"]&&count($_POST["check"])==1?where_check($_POST["check"][0],$m):""):where($_GET,$m));$eh=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($m
as$E=>$l){if(!isset($l["privileges"][$eh?"update":"insert"])||$b->fieldName($l)==""||$l["generated"])unset($m[$E]);}if($_POST&&!$k&&!isset($_GET["select"])){$A=$_POST["referer"];if($_POST["insert"])$A=($eh?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$A))$A=ME."select=".urlencode($a);$w=indexes($a);$Zg=unique_array($_GET["where"],$w);$lf="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($A,'Datensatz wurde gelöscht.',$j->delete($a,$lf,!$Zg));else{$P=array();foreach($m
as$E=>$l){$X=process_input($l);if($X!==false&&$X!==null)$P[idf_escape($E)]=$X;}if($eh){if(!$P)redirect($A);queries_redirect($A,'Datensatz wurde geändert.',$j->update($a,$P,$lf,!$Zg));if(is_ajax()){page_headers();page_messages($k);exit;}}else{$J=$j->insert($a,$P);$ud=($J?last_id():0);queries_redirect($A,sprintf('Datensatz%s wurde eingefügt.',($ud?" $ud":"")),$J);}}}$L=null;if($_POST["save"])$L=(array)$_POST["fields"];elseif($Z){$N=array();foreach($m
as$E=>$l){if(isset($l["privileges"]["select"])){$ua=convert_field($l);if($_POST["clone"]&&$l["auto_increment"])$ua="''";if($x=="sql"&&preg_match("~enum|set~",$l["type"]))$ua="1*".idf_escape($E);$N[]=($ua?"$ua AS ":"").idf_escape($E);}}$L=array();if(!support("table"))$N=array("*");if($N){$J=$j->select($a,$N,array($Z),$N,array(),(isset($_GET["select"])?2:1));if(!$J)$k=error();else{$L=$J->fetch_assoc();if(!$L)$L=false;}if(isset($_GET["select"])&&(!$L||$J->fetch_assoc()))$L=null;}}if(!support("table")&&!$m){if(!$Z){$J=$j->select($a,array("*"),$Z,array("*"));$L=($J?$J->fetch_assoc():false);if(!$L)$L=array($j->primary=>"");}if($L){foreach($L
as$y=>$X){if(!$Z)$L[$y]=null;$m[$y]=array("field"=>$y,"null"=>($y!=$j->primary),"auto_increment"=>($y==$j->primary));}}}edit_form($a,$m,$L,$eh);}elseif(isset($_GET["create"])){$a=$_GET["create"];$Ke=array();foreach(array('HASH','LINEAR HASH','KEY','LINEAR KEY','RANGE','LIST')as$y)$Ke[$y]=$y;$rf=referencable_primary($a);$o=array();foreach($rf
as$qg=>$l)$o[str_replace("`","``",$qg)."`".str_replace("`","``",$l["field"])]=$qg;$Ae=array();$R=array();if($a!=""){$Ae=fields($a);$R=table_status($a);if(!$R)$k='Keine Tabellen.';}$L=$_POST;$L["fields"]=(array)$L["fields"];if($L["auto_increment_col"])$L["fields"][$L["auto_increment_col"]]["auto_increment"]=true;if($_POST)set_adminer_settings(array("comments"=>$_POST["comments"],"defaults"=>$_POST["defaults"]));if($_POST&&!process_fields($L["fields"])&&!$k){if($_POST["drop"])queries_redirect(substr(ME,0,-1),'Tabelle wurde entfernt.',drop_tables(array($a)));else{$m=array();$ra=array();$ih=false;$zc=array();$_e=reset($Ae);$pa=" FIRST";foreach($L["fields"]as$y=>$l){$n=$o[$l["type"]];$Ug=($n!==null?$rf[$n]:$l);if($l["field"]!=""){if(!$l["has_default"])$l["default"]=null;if($y==$L["auto_increment_col"])$l["auto_increment"]=true;$hf=process_field($l,$Ug);$ra[]=array($l["orig"],$hf,$pa);if(!$_e||$hf!=process_field($_e,$_e)){$m[]=array($l["orig"],$hf,$pa);if($l["orig"]!=""||$pa)$ih=true;}if($n!==null)$zc[idf_escape($l["field"])]=($a!=""&&$x!="sqlite"?"ADD":" ").format_foreign_key(array('table'=>$o[$l["type"]],'source'=>array($l["field"]),'target'=>array($Ug["field"]),'on_delete'=>$l["on_delete"],));$pa=" AFTER ".idf_escape($l["field"]);}elseif($l["orig"]!=""){$ih=true;$m[]=array($l["orig"]);}if($l["orig"]!=""){$_e=next($Ae);if(!$_e)$pa="";}}$Me="";if($Ke[$L["partition_by"]]){$Ne=array();if($L["partition_by"]=='RANGE'||$L["partition_by"]=='LIST'){foreach(array_filter($L["partition_names"])as$y=>$X){$Y=$L["partition_values"][$y];$Ne[]="\n PARTITION ".idf_escape($X)." VALUES ".($L["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$Me.="\nPARTITION BY $L[partition_by]($L[partition])".($Ne?" (".implode(",",$Ne)."\n)":($L["partitions"]?" PARTITIONS ".(+$L["partitions"]):""));}elseif(support("partitioning")&&preg_match("~partitioned~",$R["Create_options"]))$Me.="\nREMOVE PARTITIONING";$C='Tabelle wurde geändert.';if($a==""){cookie("adminer_engine",$L["Engine"]);$C='Tabelle wurde erstellt.';}$E=trim($L["name"]);queries_redirect(ME.(support("table")?"table=":"select=").urlencode($E),$C,alter_table($a,$E,($x=="sqlite"&&($ih||$zc)?$ra:$m),$zc,($L["Comment"]!=$R["Comment"]?$L["Comment"]:null),($L["Engine"]&&$L["Engine"]!=$R["Engine"]?$L["Engine"]:""),($L["Collation"]&&$L["Collation"]!=$R["Collation"]?$L["Collation"]:""),($L["Auto_increment"]!=""?number($L["Auto_increment"]):""),$Me));}}page_header(($a!=""?'Tabelle ändern':'Tabelle erstellen'),$k,array("table"=>$a),h($a));if(!$_POST){$L=array("Engine"=>$_COOKIE["adminer_engine"],"fields"=>array(array("field"=>"","type"=>(isset($Wg["int"])?"int":(isset($Wg["integer"])?"integer":"")),"on_update"=>"")),"partition_names"=>array(""),);if($a!=""){$L=$R;$L["name"]=$a;$L["fields"]=array();if(!$_GET["auto_increment"])$L["Auto_increment"]="";foreach($Ae
as$l){$l["has_default"]=isset($l["default"]);$L["fields"][]=$l;}if(support("partitioning")){$Dc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($a);$J=$e->query("SELECT PARTITION_METHOD, PARTITION_ORDINAL_POSITION, PARTITION_EXPRESSION $Dc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");list($L["partition_by"],$L["partitions"],$L["partition"])=$J->fetch_row();$Ne=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $Dc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$Ne[""]="";$L["partition_names"]=array_keys($Ne);$L["partition_values"]=array_values($Ne);}}}$Xa=collations();$Zb=engines();foreach($Zb
as$Yb){if(!strcasecmp($Yb,$L["Engine"])){$L["Engine"]=$Yb;break;}}echo'
';}elseif(isset($_GET["indexes"])){$a=$_GET["indexes"];$Zc=array("PRIMARY","UNIQUE","INDEX");$R=table_status($a,true);if(preg_match('~MyISAM|M?aria'.(min_version(5.6,'10.0.5')?'|InnoDB':'').'~i',$R["Engine"]))$Zc[]="FULLTEXT";if(preg_match('~MyISAM|M?aria'.(min_version(5.7,'10.2.2')?'|InnoDB':'').'~i',$R["Engine"]))$Zc[]="SPATIAL";$w=indexes($a);$bf=array();if($x=="mongo"){$bf=$w["_id_"];unset($Zc[0]);unset($w["_id_"]);}$L=$_POST;if($_POST&&!$k&&!$_POST["add"]&&!$_POST["drop_col"]){$sa=array();foreach($L["indexes"]as$v){$E=$v["name"];if(in_array($v["type"],$Zc)){$d=array();$_d=array();$Db=array();$P=array();ksort($v["columns"]);foreach($v["columns"]as$y=>$c){if($c!=""){$zd=$v["lengths"][$y];$Cb=$v["descs"][$y];$P[]=idf_escape($c).($zd?"(".(+$zd).")":"").($Cb?" DESC":"");$d[]=$c;$_d[]=($zd?$zd:null);$Db[]=$Cb;}}if($d){$jc=$w[$E];if($jc){ksort($jc["columns"]);ksort($jc["lengths"]);ksort($jc["descs"]);if($v["type"]==$jc["type"]&&array_values($jc["columns"])===$d&&(!$jc["lengths"]||array_values($jc["lengths"])===$_d)&&array_values($jc["descs"])===$Db){unset($w[$E]);continue;}}$sa[]=array($v["type"],$E,$P);}}}foreach($w
as$E=>$jc)$sa[]=array($jc["type"],$E,"DROP");if(!$sa)redirect(ME."table=".urlencode($a));queries_redirect(ME."table=".urlencode($a),'Indizes geändert.',alter_indexes($a,$sa));}page_header('Indizes',$k,array("table"=>$a),h($a));$m=array_keys(fields($a));if($_POST["add"]){foreach($L["indexes"]as$y=>$v){if($v["columns"][count($v["columns"])]!="")$L["indexes"][$y]["columns"][]="";}$v=end($L["indexes"]);if($v["type"]||array_filter($v["columns"],'strlen'))$L["indexes"][]=array("columns"=>array(1=>""));}if(!$L){foreach($w
as$y=>$v){$w[$y]["name"]=$y;$w[$y]["columns"][]="";}$w[]=array("columns"=>array(1=>""));$L["indexes"]=$w;}echo'
';}elseif(isset($_GET["database"])){$L=$_POST;if($_POST&&!$k&&!isset($_POST["add_x"])){$E=trim($L["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),'Datenbank wurde entfernt.',drop_databases(array(DB)));}elseif(DB!==$E){if(DB!=""){$_GET["db"]=$E;queries_redirect(preg_replace('~\bdb=[^&]*&~','',ME)."db=".urlencode($E),'Datenbank wurde umbenannt.',rename_database($E,$L["collation"]));}else{$h=explode("\n",str_replace("\r","",$E));$kg=true;$td="";foreach($h
as$i){if(count($h)==1||$i!=""){if(!create_database($i,$L["collation"]))$kg=false;$td=$i;}}restart_session();set_session("dbs",null);queries_redirect(ME."db=".urlencode($td),'Datenbank wurde erstellt.',$kg);}}else{if(!$L["collation"])redirect(substr(ME,0,-1));query_redirect("ALTER DATABASE ".idf_escape($E).(preg_match('~^[a-z0-9_]+$~i',$L["collation"])?" COLLATE $L[collation]":""),substr(ME,0,-1),'Datenbank wurde geändert.');}}page_header(DB!=""?'Datenbank ändern':'Datenbank erstellen',$k,array(),h(DB));$Xa=collations();$E=DB;if($_POST)$E=$L["name"];elseif(DB!="")$L["collation"]=db_collation(DB,$Xa);elseif($x=="sql"){foreach(get_vals("SHOW GRANTS")as$r){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\.\*)?~',$r,$B)&&$B[1]){$E=stripcslashes(idf_unescape("`$B[2]`"));break;}}}echo'
';}elseif(isset($_GET["call"])){$da=($_GET["name"]?$_GET["name"]:$_GET["call"]);page_header('Aufrufen'.": ".h($da),$k);$Bf=routine($_GET["call"],(isset($_GET["callf"])?"FUNCTION":"PROCEDURE"));$Yc=array();$De=array();foreach($Bf["fields"]as$t=>$l){if(substr($l["inout"],-3)=="OUT")$De[$t]="@".idf_escape($l["field"])." AS ".idf_escape($l["field"]);if(!$l["inout"]||substr($l["inout"],0,2)=="IN")$Yc[]=$t;}if(!$k&&$_POST){$Ja=array();foreach($Bf["fields"]as$y=>$l){if(in_array($y,$Yc)){$X=process_input($l);if($X===false)$X="''";if(isset($De[$y]))$e->query("SET @".idf_escape($l["field"])." = $X");}$Ja[]=(isset($De[$y])?"@".idf_escape($l["field"]):$X);}$I=(isset($_GET["callf"])?"SELECT":"CALL")." ".table($da)."(".implode(", ",$Ja).")";$dg=microtime(true);$J=$e->multi_query($I);$na=$e->affected_rows;echo$b->selectQuery($I,$dg,!$J);if(!$J)echo"".error()."\n";else{$f=connect();if(is_object($f))$f->select_db(DB);do{$J=$e->store_result();if(is_object($J))select($J,$f);else
echo" ".lang(array('Routine wurde ausgeführt, %d Datensatz betroffen.','Routine wurde ausgeführt, %d Datensätze betroffen.'),$na)." ".@date("H:i:s")."\n";}while($e->next_result());if($De)select($e->query("SELECT ".implode(", ",$De)));}}echo'
';}elseif(isset($_GET["foreign"])){$a=$_GET["foreign"];$E=$_GET["name"];$L=$_POST;if($_POST&&!$k&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){$C=($_POST["drop"]?'Fremdschlüssel wurde entfernt.':($E!=""?'Fremdschlüssel wurde geändert.':'Fremdschlüssel wurde erstellt.'));$A=ME."table=".urlencode($a);if(!$_POST["drop"]){$L["source"]=array_filter($L["source"],'strlen');ksort($L["source"]);$xg=array();foreach($L["source"]as$y=>$X)$xg[$y]=$L["target"][$y];$L["target"]=$xg;}if($x=="sqlite")queries_redirect($A,$C,recreate_table($a,$a,array(),array(),array(" $E"=>($_POST["drop"]?"":" ".format_foreign_key($L)))));else{$sa="ALTER TABLE ".table($a);$Kb="\nDROP ".($x=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($E);if($_POST["drop"])query_redirect($sa.$Kb,$A,$C);else{query_redirect($sa.($E!=""?"$Kb,":"")."\nADD".format_foreign_key($L),$A,$C);$k='Quell- und Zielspalten müssen vom gleichen Datentyp sein, es muss unter den Zielspalten ein Index existieren und die referenzierten Daten müssen existieren.'." $k";}}}page_header('Fremdschlüssel',$k,array("table"=>$a),h($a));if($_POST){ksort($L["source"]);if($_POST["add"])$L["source"][]="";elseif($_POST["change"]||$_POST["change-js"])$L["target"]=array();}elseif($E!=""){$o=foreign_keys($a);$L=$o[$E];$L["source"][]="";}else{$L["table"]=$a;$L["source"]=array("");}echo'
';}elseif(isset($_GET["view"])){$a=$_GET["view"];$L=$_POST;$Be="VIEW";if($x=="pgsql"&&$a!=""){$eg=table_status($a);$Be=strtoupper($eg["Engine"]);}if($_POST&&!$k){$E=trim($L["name"]);$ua=" AS\n$L[select]";$A=ME."table=".urlencode($E);$C='View wurde geändert.';$U=($_POST["materialized"]?"MATERIALIZED VIEW":"VIEW");if(!$_POST["drop"]&&$a==$E&&$x!="sqlite"&&$U=="VIEW"&&$Be=="VIEW")query_redirect(($x=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($E).$ua,$A,$C);else{$zg=$E."_adminer_".uniqid();drop_create("DROP $Be ".table($a),"CREATE $U ".table($E).$ua,"DROP $U ".table($E),"CREATE $U ".table($zg).$ua,"DROP $U ".table($zg),($_POST["drop"]?substr(ME,0,-1):$A),'View wurde entfernt.',$C,'View wurde erstellt.',$a,$E);}}if(!$_POST&&$a!=""){$L=view($a);$L["name"]=$a;$L["materialized"]=($Be!="VIEW");if(!$k)$k=error();}page_header(($a!=""?'View ändern':'View erstellen'),$k,array("table"=>$a),h($a));echo'
';}elseif(isset($_GET["event"])){$aa=$_GET["event"];$ed=array("YEAR","QUARTER","MONTH","DAY","HOUR","MINUTE","WEEK","SECOND","YEAR_MONTH","DAY_HOUR","DAY_MINUTE","DAY_SECOND","HOUR_MINUTE","HOUR_SECOND","MINUTE_SECOND");$fg=array("ENABLED"=>"ENABLE","DISABLED"=>"DISABLE","SLAVESIDE_DISABLED"=>"DISABLE ON SLAVE");$L=$_POST;if($_POST&&!$k){if($_POST["drop"])query_redirect("DROP EVENT ".idf_escape($aa),substr(ME,0,-1),'Ereignis wurde entfernt.');elseif(in_array($L["INTERVAL_FIELD"],$ed)&&isset($fg[$L["STATUS"]])){$Ff="\nON SCHEDULE ".($L["INTERVAL_VALUE"]?"EVERY ".q($L["INTERVAL_VALUE"])." $L[INTERVAL_FIELD]".($L["STARTS"]?" STARTS ".q($L["STARTS"]):"").($L["ENDS"]?" ENDS ".q($L["ENDS"]):""):"AT ".q($L["STARTS"]))." ON COMPLETION".($L["ON_COMPLETION"]?"":" NOT")." PRESERVE";queries_redirect(substr(ME,0,-1),($aa!=""?'Ereignis wurde geändert.':'Ereignis wurde erstellt.'),queries(($aa!=""?"ALTER EVENT ".idf_escape($aa).$Ff.($aa!=$L["EVENT_NAME"]?"\nRENAME TO ".idf_escape($L["EVENT_NAME"]):""):"CREATE EVENT ".idf_escape($L["EVENT_NAME"]).$Ff)."\n".$fg[$L["STATUS"]]." COMMENT ".q($L["EVENT_COMMENT"]).rtrim(" DO\n$L[EVENT_DEFINITION]",";").";"));}}page_header(($aa!=""?'Ereignis ändern'.": ".h($aa):'Ereignis erstellen'),$k);if(!$L&&$aa!=""){$M=get_rows("SELECT * FROM information_schema.EVENTS WHERE EVENT_SCHEMA = ".q(DB)." AND EVENT_NAME = ".q($aa));$L=reset($M);}echo'
';}elseif(isset($_GET["procedure"])){$da=($_GET["name"]?$_GET["name"]:$_GET["procedure"]);$Bf=(isset($_GET["function"])?"FUNCTION":"PROCEDURE");$L=$_POST;$L["fields"]=(array)$L["fields"];if($_POST&&!process_fields($L["fields"])&&!$k){$ze=routine($_GET["procedure"],$Bf);$zg="$L[name]_adminer_".uniqid();drop_create("DROP $Bf ".routine_id($da,$ze),create_routine($Bf,$L),"DROP $Bf ".routine_id($L["name"],$L),create_routine($Bf,array("name"=>$zg)+$L),"DROP $Bf ".routine_id($zg,$L),substr(ME,0,-1),'Routine wurde entfernt.','Routine wurde geändert.','Routine wurde erstellt.',$da,$L["name"]);}page_header(($da!=""?(isset($_GET["function"])?'Funktion ändern':'Prozedur ändern').": ".h($da):(isset($_GET["function"])?'Funktion erstellen':'Prozedur erstellen')),$k);if(!$_POST&&$da!=""){$L=routine($_GET["procedure"],$Bf);$L["name"]=$da;}$Xa=get_vals("SHOW CHARACTER SET");sort($Xa);$Cf=routine_languages();echo'
';}elseif(isset($_GET["trigger"])){$a=$_GET["trigger"];$E=$_GET["name"];$Sg=trigger_options();$L=(array)trigger($E)+array("Trigger"=>$a."_bi");if($_POST){if(!$k&&in_array($_POST["Timing"],$Sg["Timing"])&&in_array($_POST["Event"],$Sg["Event"])&&in_array($_POST["Type"],$Sg["Type"])){$me=" ON ".table($a);$Kb="DROP TRIGGER ".idf_escape($E).($x=="pgsql"?$me:"");$A=ME."table=".urlencode($a);if($_POST["drop"])query_redirect($Kb,$A,'Trigger wurde entfernt.');else{if($E!="")queries($Kb);queries_redirect($A,($E!=""?'Trigger wurde geändert.':'Trigger wurde erstellt.'),queries(create_trigger($me,$_POST)));if($E!="")queries(create_trigger($me,$L+array("Type"=>reset($Sg["Type"]))));}}$L=$_POST;}page_header(($E!=""?'Trigger ändern'.": ".h($E):'Trigger erstellen'),$k,array("table"=>$a));echo'
';}elseif(isset($_GET["user"])){$fa=$_GET["user"];$ff=array(""=>array("All privileges"=>""));foreach(get_rows("SHOW PRIVILEGES")as$L){foreach(explode(",",($L["Privilege"]=="Grant option"?"":$L["Context"]))as$ib)$ff[$ib][$L["Privilege"]]=$L["Comment"];}$ff["Server Admin"]+=$ff["File access on server"];$ff["Databases"]["Create routine"]=$ff["Procedures"]["Create routine"];unset($ff["Procedures"]["Create routine"]);$ff["Columns"]=array();foreach(array("Select","Insert","Update","References")as$X)$ff["Columns"][$X]=$ff["Tables"][$X];unset($ff["Server Admin"]["Usage"]);foreach($ff["Tables"]as$y=>$X)unset($ff["Databases"][$y]);$Xd=array();if($_POST){foreach($_POST["objects"]as$y=>$X)$Xd[$X]=(array)$Xd[$X]+(array)$_POST["grants"][$y];}$Fc=array();$ke="";if(isset($_GET["host"])&&($J=$e->query("SHOW GRANTS FOR ".q($fa)."@".q($_GET["host"])))){while($L=$J->fetch_row()){if(preg_match('~GRANT (.*) ON (.*) TO ~',$L[0],$B)&&preg_match_all('~ *([^(,]*[^ ,(])( *\([^)]+\))?~',$B[1],$Gd,PREG_SET_ORDER)){foreach($Gd
as$X){if($X[1]!="USAGE")$Fc["$B[2]$X[2]"][$X[1]]=true;if(preg_match('~ WITH GRANT OPTION~',$L[0]))$Fc["$B[2]$X[2]"]["GRANT OPTION"]=true;}}if(preg_match("~ IDENTIFIED BY PASSWORD '([^']+)~",$L[0],$B))$ke=$B[1];}}if($_POST&&!$k){$le=(isset($_GET["host"])?q($fa)."@".q($_GET["host"]):"''");if($_POST["drop"])query_redirect("DROP USER $le",ME."privileges=",'Benutzer wurde entfernt.');else{$Zd=q($_POST["user"])."@".q($_POST["host"]);$Oe=$_POST["pass"];if($Oe!=''&&!$_POST["hashed"]&&!min_version(8)){$Oe=$e->result("SELECT PASSWORD(".q($Oe).")");$k=!$Oe;}$mb=false;if(!$k){if($le!=$Zd){$mb=queries((min_version(5)?"CREATE USER":"GRANT USAGE ON *.* TO")." $Zd IDENTIFIED BY ".(min_version(8)?"":"PASSWORD ").q($Oe));$k=!$mb;}elseif($Oe!=$ke)queries("SET PASSWORD FOR $Zd = ".q($Oe));}if(!$k){$zf=array();foreach($Xd
as$fe=>$r){if(isset($_GET["grant"]))$r=array_filter($r);$r=array_keys($r);if(isset($_GET["grant"]))$zf=array_diff(array_keys(array_filter($Xd[$fe],'strlen')),$r);elseif($le==$Zd){$ie=array_keys((array)$Fc[$fe]);$zf=array_diff($ie,$r);$r=array_diff($r,$ie);unset($Fc[$fe]);}if(preg_match('~^(.+)\s*(\(.*\))?$~U',$fe,$B)&&(!grant("REVOKE",$zf,$B[2]," ON $B[1] FROM $Zd")||!grant("GRANT",$r,$B[2]," ON $B[1] TO $Zd"))){$k=true;break;}}}if(!$k&&isset($_GET["host"])){if($le!=$Zd)queries("DROP USER $le");elseif(!isset($_GET["grant"])){foreach($Fc
as$fe=>$zf){if(preg_match('~^(.+)(\(.*\))?$~U',$fe,$B))grant("REVOKE",array_keys($zf),$B[2]," ON $B[1] FROM $Zd");}}}queries_redirect(ME."privileges=",(isset($_GET["host"])?'Benutzer wurde geändert.':'Benutzer wurde erstellt.'),!$k);if($mb)$e->query("DROP USER $Zd");}}page_header((isset($_GET["host"])?'Benutzer'.": ".h("$fa@$_GET[host]"):'Benutzer erstellen'),$k,array("privileges"=>array('','Rechte')));if($_POST){$L=$_POST;$Fc=$Xd;}else{$L=$_GET+array("host"=>$e->result("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', -1)"));$L["pass"]=$ke;if($ke!="")$L["hashed"]=true;$Fc[(DB==""||$Fc?"":idf_escape(addcslashes(DB,"%_\\"))).".*"]=array();}echo'
';}elseif(isset($_GET["processlist"])){if(support("kill")&&$_POST&&!$k){$pd=0;foreach((array)$_POST["kill"]as$X){if(kill_process($X))$pd++;}queries_redirect(ME."processlist=",lang(array('%d Prozess gestoppt.','%d Prozesse gestoppt.'),$pd),$pd||!$_POST["kill"]);}page_header('Prozessliste',$k);echo'
',script("tableCheck();");}elseif(isset($_GET["select"])){$a=$_GET["select"];$R=table_status1($a);$w=indexes($a);$m=fields($a);$o=column_foreign_keys($a);$he=$R["Oid"];parse_str($_COOKIE["adminer_import"],$ma);$_f=array();$d=array();$Bg=null;foreach($m
as$y=>$l){$E=$b->fieldName($l);if(isset($l["privileges"]["select"])&&$E!=""){$d[$y]=html_entity_decode(strip_tags($E),ENT_QUOTES);if(is_shortable($l))$Bg=$b->selectLengthProcess();}$_f+=$l["privileges"];}list($N,$s)=$b->selectColumnsProcess($d,$w);$id=count($s)selectSearchProcess($m,$w);$ve=$b->selectOrderProcess($m,$w);$z=$b->selectLimitProcess();if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$ah=>$L){$ua=convert_field($m[key($L)]);$N=array($ua?$ua:idf_escape(key($L)));$Z[]=where_check($ah,$m);$K=$j->select($a,$N,$Z,$N);if($K)echo
reset($K->fetch_row());}exit;}$bf=$ch=null;foreach($w
as$v){if($v["type"]=="PRIMARY"){$bf=array_flip($v["columns"]);$ch=($N?$bf:array());foreach($ch
as$y=>$X){if(in_array(idf_escape($y),$N))unset($ch[$y]);}break;}}if($he&&!$bf){$bf=$ch=array($he=>0);$w[]=array("type"=>"PRIMARY","columns"=>array($he));}if($_POST&&!$k){$yh=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Oa=array();foreach($_POST["check"]as$Ma)$Oa[]=where_check($Ma,$m);$yh[]="((".implode(") OR (",$Oa)."))";}$yh=($yh?"\nWHERE ".implode(" AND ",$yh):"");if($_POST["export"]){cookie("adminer_import","output=".urlencode($_POST["output"])."&format=".urlencode($_POST["format"]));dump_headers($a);$b->dumpTable($a,"");$Dc=($N?implode(", ",$N):"*").convert_fields($d,$m,$N)."\nFROM ".table($a);$Hc=($s&&$id?"\nGROUP BY ".implode(", ",$s):"").($ve?"\nORDER BY ".implode(", ",$ve):"");if(!is_array($_POST["check"])||$bf)$I="SELECT $Dc$yh$Hc";else{$Yg=array();foreach($_POST["check"]as$X)$Yg[]="(SELECT".limit($Dc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$m).$Hc,1).")";$I=implode(" UNION ALL ",$Yg);}$b->dumpData($a,"table",$I);exit;}if(!$b->selectEmailProcess($Z,$o)){if($_POST["save"]||$_POST["delete"]){$J=true;$na=0;$P=array();if(!$_POST["delete"]){foreach($d
as$E=>$X){$X=process_input($m[$E]);if($X!==null&&($_POST["clone"]||$X!==false))$P[idf_escape($E)]=($X!==false?$X:idf_escape($E));}}if($_POST["delete"]||$P){if($_POST["clone"])$I="INTO ".table($a)." (".implode(", ",array_keys($P)).")\nSELECT ".implode(", ",$P)."\nFROM ".table($a);if($_POST["all"]||($bf&&is_array($_POST["check"]))||$id){$J=($_POST["delete"]?$j->delete($a,$yh):($_POST["clone"]?queries("INSERT $I$yh"):$j->update($a,$P,$yh)));$na=$e->affected_rows;}else{foreach((array)$_POST["check"]as$X){$xh="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$m);$J=($_POST["delete"]?$j->delete($a,$xh,1):($_POST["clone"]?queries("INSERT".limit1($a,$I,$xh)):$j->update($a,$P,$xh,1)));if(!$J)break;$na+=$e->affected_rows;}}}$C=sprintf('%d Artikel betroffen.',$na);if($_POST["clone"]&&$J&&$na==1){$ud=last_id();if($ud)$C=sprintf('Datensatz%s wurde eingefügt.'," $ud");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$C,$J);if(!$_POST["delete"]){edit_form($a,$m,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$k='Ctrl+Klick zum Bearbeiten des Wertes.';else{$J=true;$na=0;foreach($_POST["val"]as$ah=>$L){$P=array();foreach($L
as$y=>$X){$y=bracket_escape($y,1);$P[idf_escape($y)]=(preg_match('~char|text~',$m[$y]["type"])||$X!=""?$b->processInput($m[$y],$X):"NULL");}$J=$j->update($a,$P," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($ah,$m),!$id&&!$bf," ");if(!$J)break;$na+=$e->affected_rows;}queries_redirect(remove_from_uri(),sprintf('%d Artikel betroffen.',$na),$J);}}elseif(!is_string($tc=get_file("csv_file",true)))$k=upload_error($tc);elseif(!preg_match('~~u',$tc))$k='Die Datei muss UTF-8 kodiert sein.';else{cookie("adminer_import","output=".urlencode($ma["output"])."&format=".urlencode($_POST["separator"]));$J=true;$Ya=array_keys($m);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$tc,$Gd);$na=count($Gd[0]);$j->begin();$Nf=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$M=array();foreach($Gd[0]as$y=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$Nf]*)$Nf~",$X.$Nf,$Hd);if(!$y&&!array_diff($Hd[1],$Ya)){$Ya=$Hd[1];$na--;}else{$P=array();foreach($Hd[1]as$t=>$Ua)$P[idf_escape($Ya[$t])]=($Ua==""&&$m[$Ya[$t]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$Ua))));$M[]=$P;}}$J=(!$M||$j->insertUpdate($a,$M,$bf));if($J)$J=$j->commit();queries_redirect(remove_from_uri("page"),lang(array('%d Datensatz wurde importiert.','%d Datensätze wurden importiert.'),$na),$J);$j->rollback();}}}$qg=$b->tableName($R);if(is_ajax()){page_headers();ob_start();}else
page_header('Daten zeigen von'.": $qg",$k);$P=null;if(isset($_f["insert"])||!support("table")){$P="";foreach((array)$_GET["where"]as$X){if($o[$X["col"]]&&count($o[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!preg_match('~[_%]~',$X["val"]))))$P.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$b->selectLinks($R,$P);if(!$d&&support("table"))echo"".'Auswahl der Tabelle fehlgeschlagen'.($m?".":": ".error())."\n";else{echo" \n";$F=$_GET["page"];if($F=="last"){$Cc=$e->result(count_rows($a,$Z,$id,$s));$F=floor(max(0,$Cc-1)/$z);}$If=$N;$Gc=$s;if(!$If){$If[]="*";$jb=convert_fields($d,$m,$N);if($jb)$If[]=substr($jb,2);}foreach($N
as$y=>$X){$l=$m[idf_unescape($X)];if($l&&($ua=convert_field($l)))$If[$y]="$ua AS $X";}if(!$id&&$ch){foreach($ch
as$y=>$X){$If[]=idf_escape($y);if($Gc)$Gc[]=idf_escape($y);}}$J=$j->select($a,$If,$Z,$Gc,$ve,$z,$F,true);if(!$J)echo"".error()."\n";else{if($x=="mssql"&&$F)$J->seek($z*$F);$Wb=array();echo" \n",(!$s&&$N?"":script("tableCheck();"));}}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$eg=isset($_GET["status"]);page_header($eg?'Status':'Variablen');$oh=($eg?show_status():show_variables());if(!$oh)echo"".'Keine Datensätze.'."\n";else{echo" \n";foreach($oh
as$y=>$X){echo"","".h($y)." "," | ".h($X);}echo" | \n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$ng=array("Data_length"=>0,"Index_length"=>0,"Data_free"=>0);foreach(table_status()as$E=>$R){json_row("Comment-$E",h($R["Comment"]));if(!is_view($R)){foreach(array("Engine","Collation")as$y)json_row("$y-$E",h($R[$y]));foreach($ng+array("Auto_increment"=>0,"Rows"=>0)as$y=>$X){if($R[$y]!=""){$X=format_number($R[$y]);json_row("$y-$E",($y=="Rows"&&$X&&$R["Engine"]==($Zf=="pgsql"?"table":"InnoDB")?"~ $X":$X));if(isset($ng[$y]))$ng[$y]+=($R["Engine"]!="InnoDB"||$y!="Data_free"?$R[$y]:0);}elseif(array_key_exists($y,$R))json_row("$y-$E");}}}foreach($ng
as$y=>$X)json_row("sum-$y",format_number($X));json_row("");}elseif($_GET["script"]=="kill")$e->query("KILL ".number($_POST["kill"]));else{foreach(count_tables($b->databases())as$i=>$X){json_row("tables-$i",$X);json_row("size-$i",db_size($i));}json_row("");}exit;}else{$vg=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($vg&&!$k&&!$_POST["search"]){$J=true;$C="";if($x=="sql"&&$_POST["tables"]&&count($_POST["tables"])>1&&($_POST["drop"]||$_POST["truncate"]||$_POST["copy"]))queries("SET foreign_key_checks = 0");if($_POST["truncate"]){if($_POST["tables"])$J=truncate_tables($_POST["tables"]);$C='Tabellen wurden geleert (truncate).';}elseif($_POST["move"]){$J=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$C='Tabellen verschoben.';}elseif($_POST["copy"]){$J=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$C='Tabellen wurden kopiert.';}elseif($_POST["drop"]){if($_POST["views"])$J=drop_views($_POST["views"]);if($J&&$_POST["tables"])$J=drop_tables($_POST["tables"]);$C='Tabellen wurden entfernt (drop).';}elseif($x!="sql"){$J=($x=="sqlite"?queries("VACUUM"):apply_queries("VACUUM".($_POST["optimize"]?"":" ANALYZE"),$_POST["tables"]));$C='Tabellen wurden optimiert.';}elseif(!$_POST["tables"])$C='Keine Tabellen.';elseif($J=queries(($_POST["optimize"]?"OPTIMIZE":($_POST["check"]?"CHECK":($_POST["repair"]?"REPAIR":"ANALYZE")))." TABLE ".implode(", ",array_map('idf_escape',$_POST["tables"])))){while($L=$J->fetch_assoc())$C.="".h($L["Table"]).": ".h($L["Msg_text"])." ";}queries_redirect(substr(ME,0,-1),$C,$J);}page_header(($_GET["ns"]==""?'Datenbank'.": ".h(DB):'Schema'.": ".h($_GET["ns"])),$k,true);if($b->homepage()){if($_GET["ns"]!==""){echo"".'Tabellen und Views'."\n";$ug=tables_list();if(!$ug)echo"".'Keine Tabellen.'."\n";else{echo" \n",script("tableCheck();");}echo''.'Tabelle erstellen'."\n",(support("view")?''.'View erstellen'."\n":"");if(support("routine")){echo" ".'Routinen'."\n";$Df=routines();if($Df){echo"\n",''.'Name'.' | '.'Typ'.' | '.'Typ des Rückgabewertes'." | | \n";odd('');foreach($Df
as$L){$E=($L["SPECIFIC_NAME"]==$L["ROUTINE_NAME"]?"":"&name=".urlencode($L["ROUTINE_NAME"]));echo'',''.h($L["ROUTINE_NAME"]).'',' | '.h($L["ROUTINE_TYPE"]),' | '.h($L["DTD_IDENTIFIER"]),' | '.'Ändern'."";}echo" | \n";}echo''.(support("procedure")?''.'Prozedur erstellen'.'':'').''.'Funktion erstellen'."\n";}if(support("event")){echo" ".'Ereignisse'."\n";$M=get_rows("SHOW EVENTS");if($M){echo"\n","".'Name'." | ".'Zeitplan'." | ".'Start'." | ".'Ende'." | | \n";foreach($M
as$L){echo"","".h($L["Name"])," | ".($L["Execute at"]?'Zur angegebenen Zeit'." | ".$L["Execute at"]:'Jede'." ".$L["Interval value"]." ".$L["Interval field"]." | $L[Starts]")," | $L[Ends]",' | '.'Ändern'.'';}echo" | \n";$fc=$e->result("SELECT @@event_scheduler");if($fc&&$fc!="ON")echo"event_scheduler : ".h($fc)."\n";}echo'
'.'Ereignis erstellen'."\n";}if($ug)echo
script("ajaxSetHtml('".js_escape(ME)."script=db');");}}}page_footer(); |