9 `'Cۗ889 xQ\0e4QʘlPVbT4 \\W/\n`  7\"hq4ZM6T\rr\\C{h7\rx67J2.39KH,!mƆo\$.[\r&#\$ X:\rܺ3b-8SLK.-ҥ\rH@ml:;J0LR2! A 2 m0eI-:U\r9MWL0GcJv2(F9`C1HRSd9%U1Sna|.ԁ`8:#C2*[o4X~7j\\ 6/09\r;;VnnމvkHB%.k\">[\nlp9cFZs|>6 5l1Vΐ67:\"Azde\\5*մ]p[*Am)Kt[\n8g= ;2z|̣4t8.N#ʲB\"9%HQw qdF\$&VQ#Q'_m ̡ \rh Xrt0j5W4ד m\"CAF!엖h>b007;84Ka \0p aHXF1:8U9HIó;sQ7FcLpXM@e吞+g(73O3pblEE>Chb%DI8E' #)=%CjY1yh;cA6jK\r9Ž\$|g-Zo\0z\$+DVw*WpJ\\FO'ɲa1m,_ڧ\r1Po;\05e\r& 3^\r6MR2T\05?~5 P >85hn1;\rRL8`\\@`;z\n\0ԃ89RyZP@ib?ƭv\$<% A\r?\0Sʥ BÞ4JҨ:`#Hi7ε+}voJVڰ 9W2Q\rTD`f wLI]MKd7*rk*j\nASjF-[ezzrʁfU3~\\ZZ{)>>Ѓp*;zDbw]mC\n訓KBBm@ִ>wU’*N(baƶ@fv)`\0uD)mD@/49jHBm1I5DR uE9Aӗ=1b0ey1s;-]s 5\\\n1;Q^bi;YJ2d!s#kg hށ] W)>VIx]r;6JLcprd{pyM-UVH5'\ntвlpHoeZϨqeXF`Gy\r!Ww*Dut%dQ/p:iht&Pe,J͌t!O76GgRC[skvqU}yhAGV|lFޅL^.]u&w![jnnڏ[kCvkrmOɭJ>WT0\npMCbtVG|oy8c");}elseif($_GET["file"]=="functions.js"){header("Content-Type: text/javascript; charset=utf-8");echo lzw_decompress("f:gCI\n:saPi2\nOgc e6Le7s)Ћ\rHGI3as'cDi6N2H8uFR#r7#v}@`Qo5aI,2O'8R-q:PS(a*w(%p-C \" XS`\\F֬h83`X:O,) 898c<#0L9 ?(R#e=\n:*0D9C@{ZO8ioVvkAr8&..cHE>H_hWU51r* ^ (bxܡY1&XH6ؓ.9xP\r.`v484daXV6FEHHfc-^=txY\r%xeQ,X=1!svjkQ2 %W? Ů=dY&ٓVX4ـ\\5Xì!}NgvڃWY*Qi&lѵZ#Ց\rA\$ev5o#ޛ5gc3MTCL>vH<`*]_;%;Vi4X'`ij0gOۥi9ƙےdFk/lŞnc\n/ l[ ŠPa8%!1v/SUcoJ:4J+BvJ\rb{,|\0zcYl\ni.!)dmJ!' B\nC\\ i\$J\"2+IkJ \$Gy\$#ܲi/CAbbC(:UX2& , Q;~/Ky9?\r6tV!6CP hYEl䏞(ؖTp'3C<dc?yCe0@&A?= %A:JD&SQ6R)Ab`0@u9(!0R\nF Š wC\\υrܙ #~2'\$ :K`h@Eb[~ Tlf5BR]{\"-\0L>\r\$@\n(&\r9\0vh*ɇ*X!_djpy`jYwJ\$R(uaM+nxspU^Ap`ͤIH\nf02)!4a9 EwC ˩ LPAi)p3Au AIAHu !g͕UZUc *Mxf :^Xp+V KC#+ WhCP! ;[pn\\%k \0,ڨ87xQC\nY\rbXvC d\nA;lF,_wr4RPHA!;&^Ͳ\"6;=#CI 9f':DY!B+sxV8lÓ\"鑃HU%\"Z6u\re0[pa. +^``b5#CM\$ I˚AP5C\r SdWN6H[ SR\\+X=kλ׺Sr^(oo7\\huklHaC(mnRBUup2C1[|ٽbeG0\"CG?\$x7n\$Z=ZӦsi5f&,fhiIyn20DvETxM{`ܤGN#遂Z,ƒ/ R\$#\\I- |0-0NP ;s-v҆nwGtndiH|4(+v&Ņ+KL\nJ\$ԩ:\\Q/F\n?mFj 3 p DHKv Ⱥɜ\0X*\rʚ\n0 e\n%\riOflNM%]UQ QL-S±T4!U5T\nndi0#EMi./U\rZF j;H☎d`mݩ\ntQS e|iQt d12,DY 1UQSUcdE)\\L F\$@V{W6\"LlTA\$6abOdrLp c,esΞ<2`@bXP\$3@˃P,KVխ^MLu1 @ct-(`\09n2sb/ Fm)Hl5@nl\$q+:/ d,\n޵. 4\$ w0\$dV0\"rW4678VtqBaupÀI<\$#x`wd9^*kuofBEp g2f4 L!r=\0 \" \r< hU%ThBk#>'Cp\n (\r2\"3lMԋ7Gx.,Uu%Dt wy^Mf\" (vU3uJ^HC_IUYkSc_ylcc]rF_q%W#]@rkv3-cyVHJG<ZT@V8\$6o2H@\rª\0=ݍ\"39z:K uK >B\$r.J*l'kophxvL`w1 !M4\"I\$\"o\$>˙Bea\"DBoʶ+ B0Pxp&7|p{|}7ְ\$-P@beVYmoMo\0Nzn*>΄)-Hl!hpg &tZ㜤\0!8 ɩZK@DZG F秩. lz%(x}'<Ū(<XZǬњ ɮgwzz{e'{;@噱(&R^Eݛx宛Y\"MܒV\n5zlzr[x˪ G\$OW@Zx, be fdƻ2EËIDYT%k{J\\\rU N '_ɽf|w޵,l7kt1RD>ЋXZЊ|y|Z{|բ\r%;#\0eZ,\rKt\r >>\$>??c?+@  @ʰcqfc+3Ș؀&x]N*|b2R_\$< \rl [*`\n~b]jB\rqˣQ꾼+(W| +ep9j}RiJ6p\r-S0tHJ`7Dcp)\nߢ\\%aQ Cf6\ne\n>@%h%I `\0uAX K `8+ I\\(\rń\0lH#]*y\$,H ?EFC7`țE@rGpLB3H,0+s\r\0\0!9Hua4 0aJ(\0DqgaJ!m~Aa&à/ *p\"IBD\r!9!vL:Ċ!\$AKe\0lb i6%YzKrlRK\"AF{ 6XH&: h~9_2Ws>\$Ћ pC@vz0և8\\vp:s_\\:Y\rB\$|iGR# YR9\0D28?+}YᩇJ#CiVCT6Q9piteLp\$4\$D#@@|gRc\rF8Q&@5r\0XV5\\fh @v, /\0\n&/!d qKRm;aD2d\0002b\$ L/1,E4@<}aی\$1*`>0 :d   - Ä\rDYl(6[6ksf' 8I TJDUD:A2hd\0a\0)2:B3:Z1=@-qN\\!\$kfNw `n\$LCR5pcE3Ca\0=Hjڒg-ژE e.\0!o,'wI`\\s6RE}e0F\\m|F>q ?jД6i p +N9qup2eɑm.+L~\$\"Rs]iqCИjZgx`6t.b,ͩkY\\`'Sljհ!ln\0Wg+:+c6~KFʖĩ-h9-H@SDG;Π_ \n)fnQ-*C֩{MSnZ ED\0)Pg]6b%%Hj&%-* 9}j 43@*(m\$QDۆҹ(m¼ukjO\" ,1Vv%s1kP` /@0>F>#X8%lⴹKS|Yw0u̧bÉX4p\0\n%\0ZQ2WWEkoɇjy .Z\0 PptHR>,%)k `|,prZhZ,P|CFLxn .PReVoB;xDk)M?n`/5Ilqh\0צ5Ehq폴A ˉUdkDOy;ƆëA.OrƄ!H ^ҋD3Ig>ce~Zon_^+!h|*3ޢG[nڶjp 7H/T+3lP{<2ʞЩ)\"ãލYˣA2:&\0ۃ~cK\nD4GNg.`RB1H.j{}n|/o`]f_6y`\r x^@\\R='ς_{ X-\\)L EPl\\\0]hareӝ8NG^I:ܵJ%r~-܍ 1g+gVoσzm>54)mm\$oEbܒ)mEѨK6!* \nӔq 0?wPKg1i~X`\0XY Z *Dh 1El\r\0:?\r>#2@3h2袰Æ&Oе.Ʉ(.LbVEь s:88{>χAoHrySdvmr׃f>jO\nÀ5ֳ͂A002>nf16q3”]+arFx6 S-3e +x̤/jhD\r-\nјG7z2i.A9f`YTx9\"^\\nݣs9{0s83\$:#3Y6{0\nJ \$#D\\ļ@Ў3u0\"*.rs؛5G_ȎDdHKm]\\4\0;d}[ S2ܜ}ޞKd& t rf *j +Px܍\r7M8A[#m\n\n𧀯9+ZH|H[_ź| j5H|U1^u] P L`Xgh _r smZ:l]ihsK>ec 9 p7jCLRp ``");}else{header("Content-Type: image/gif");switch($_GET["file"]){case"plus.gif":echo"GIF87a\0\0\0\0\0\0\0\0\0\0,\0\0\0\0\0\0\0!M*)o) qe#L\0;";break;case"cross.gif":echo"GIF87a\0\0\0\0\0\0\0\0\0\0,\0\0\0\0\0\0\0##\naFo~y._wa1J GL6]\0\0;";break;case"up.gif":echo"GIF87a\0\0\0\0\0\0\0\0\0\0,\0\0\0\0\0\0\0 MQN\n}a8yaŶ\0\0;";break;case"down.gif":echo"GIF87a\0\0\0\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;}function connection(){global$h;return$h;}function adminer(){global$c;return$c;}function idf_unescape($Ic){$cd=substr($Ic,-1);return str_replace($cd.$cd,$cd,substr($Ic,1,-1));}function escape_string($X){return substr(q($X),1,-1);}function remove_slashes($De,$lc=false){if(get_magic_quotes_gpc()){while(list($z,$X)=each($De)){foreach($X as$Vc=>$W){unset($De[$z][$Vc]);if(is_array($W)){$De[$z][stripslashes($Vc)]=$W;$De[]=&$De[$z][stripslashes($Vc)];}else$De[$z][stripslashes($Vc)]=($lc?$W:stripslashes($W));}}}}function bracket_escape($Ic,$ya=false){static$Yf=array(':'=>':1',']'=>':2','['=>':3');return strtr($Ic,($ya?array_flip($Yf):$Yf));}function h($tf){return htmlspecialchars(str_replace("\0","",$tf),ENT_QUOTES);}function nbsp($tf){return(trim($tf)!=""?h($tf):" ");}function nl_br($tf){return str_replace("\n","
",$tf);}function checkbox($F,$Y,$Ka,$Zc="",$Sd="",$Na=""){$L="";return($Zc!=""||$Na?"$L".h($Zc)."":$L);}function optionlist($Vd,$ff=null,$rg=false){$L="";foreach($Vd as$Vc=>$W){$Wd=array($Vc=>$W);if(is_array($W)){$L.='';$Wd=$W;}foreach($Wd as$z=>$X)$L.=''.h($X);if(is_array($W))$L.='';}return$L;}function html_select($F,$Vd,$Y="",$Rd=true){if($Rd)return"";$L="";foreach($Vd as$z=>$X)$L.="";return$L;}function confirm($fb=""){return" onclick=\"return confirm('".lang(0).($fb?" (' + $fb + ')":"")."');\"";}function print_fieldset($u,$hd,$xg=false,$Sd=""){echo"
$hd
\n";}function selectSearchPrint($Z,$f,$w){print_fieldset("search",lang(35),$Z);foreach($w as$t=>$v){if($v["type"]=="FULLTEXT"){echo"(".implode(", ",array_map('h',$v["columns"])).") AGAINST"," ",checkbox("boolean[$t]",1,isset($_GET["boolean"][$t]),"BOOL"),"
\n";}}$_GET["where"]=(array)$_GET["where"];reset($_GET["where"]);$Ia="this.nextSibling.onchange();";for($t=0;$t<=count($_GET["where"]);$t++){list(,$X)=each($_GET["where"]);if(!$X||("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators))){echo"
",html_select("where[$t][op]",$this->operators,$X["op"],$Ia),"
\n";}}echo"\n";}function selectOrderPrint($Xd,$f,$w){print_fieldset("sort",lang(37),$Xd);$t=0;foreach((array)$_GET["order"]as$z=>$X){if(isset($f[$X])){echo"
",checkbox("desc[$t]",1,isset($_GET["desc"][$z]),lang(38))."
\n";$t++;}}echo"
",checkbox("desc[$t]",1,false,lang(38))."
\n","\n";}function selectLimitPrint($_){echo"
".lang(39)."
";echo"","
\n";}function selectLengthPrint($Nf){if($Nf!==null){echo"
".lang(40)."
","","
\n";}}function selectActionPrint($w){echo"
".lang(41)."
",""," ","\n","
\n";}function selectCommandPrint(){return!information_schema(DB);}function selectImportPrint(){return!information_schema(DB);}function selectEmailPrint($Lb,$f){}function selectColumnsProcess($f,$w){global$xc,$Ac;$O=array();$zc=array();foreach((array)$_GET["columns"]as$z=>$X){if($X["fun"]=="count"||(isset($f[$X["col"]])&&(!$X["fun"]||in_array($X["fun"],$xc)||in_array($X["fun"],$Ac)))){$O[$z]=apply_sql_function($X["fun"],(isset($f[$X["col"]])?idf_escape($X["col"]):"*"));if(!in_array($X["fun"],$Ac))$zc[]=$O[$z];}}return array($O,$zc);}function selectSearchProcess($o,$w){global$y;$L=array();foreach($w as$t=>$v){if($v["type"]=="FULLTEXT"&&$_GET["fulltext"][$t]!="")$L[]="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$X){if("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators)){$Za=" $X[op]";if(ereg('IN$',$X["op"])){$Kc=process_length($X["val"]);$Za.=" (".($Kc!=""?$Kc:"NULL").")";}elseif($X["op"]=="SQL")$Za=" $X[val]";elseif($X["op"]=="LIKE %%")$Za=" LIKE ".$this->processInput($o[$X["col"]],"%$X[val]%");elseif(!ereg('NULL$',$X["op"]))$Za.=" ".$this->processInput($o[$X["col"]],$X["val"]);if($X["col"]!="")$L[]=idf_escape($X["col"]).$Za;else{$Ua=array();foreach($o as$F=>$n){$Tc=ereg('char|text|enum|set',$n["type"]);if((is_numeric($X["val"])||!ereg('(^|[^o])int|float|double|decimal|bit',$n["type"]))&&(!ereg("[\x80-\xFF]",$X["val"])||$Tc)){$F=idf_escape($F);$Ua[]=($y=="sql"&&$Tc&&!ereg('^utf8',$n["collation"])?"CONVERT($F USING utf8)":$F);}}$L[]=($Ua?"(".implode("$Za OR ",$Ua)."$Za)":"0");}}}return$L;}function selectOrderProcess($o,$w){$L=array();foreach((array)$_GET["order"]as$z=>$X){if(isset($o[$X])||preg_match('~^((COUNT\\(DISTINCT |[A-Z0-9_]+\\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\\)|COUNT\\(\\*\\))$~',$X))$L[]=(isset($o[$X])?idf_escape($X):$X).(isset($_GET["desc"][$z])?" DESC":"");}return$L;}function selectLimitProcess(){return(isset($_GET["limit"])?$_GET["limit"]:"50");}function selectLengthProcess(){return(isset($_GET["text_length"])?$_GET["text_length"]:"100");}function selectEmailProcess($Z,$pc){return false;}function selectQueryBuild($O,$Z,$zc,$Xd,$_,$H){return"";}function messageQuery($J){global$y;restart_session();$Dc=&get_session("queries");$u="sql-".count($Dc[$_GET["db"]]);if(strlen($J)>1e6)$J=ereg_replace('[\x80-\xFF]+$','',substr($J,0,1e6))."\n...";$Dc[$_GET["db"]][]=array($J,time());return" ".@date("H:i:s")." ".lang(43)."';}function editFunctions($n){global$Hb;$L=($n["null"]?"NULL/":"");foreach($Hb as$z=>$xc){if(!$z||(!isset($_GET["call"])&&(isset($_GET["select"])||where($_GET)))){foreach($xc as$qe=>$X){if(!$qe||ereg($qe,$n["type"]))$L.="/$X";}if($z&&!ereg('set|blob|bytea|raw|file',$n["type"]))$L.="/SQL";}}return explode("/",$L);}function editInput($R,$n,$va,$Y){if($n["type"]=="enum")return(isset($_GET["select"])?" ":"").($n["null"]?" ":"").enum_input("radio",$va,$n,$Y,0);return"";}function processInput($n,$Y,$r=""){if($r=="SQL")return$Y;$F=$n["field"];$L=q($Y);if(ereg('^(now|getdate|uuid)$',$r))$L="$r()";elseif(ereg('^current_(date|timestamp)$',$r))$L=$r;elseif(ereg('^([+-]|\\|\\|)$',$r))$L=idf_escape($F)." $r $L";elseif(ereg('^[+-] interval$',$r))$L=idf_escape($F)." $r ".(preg_match("~^(\\d+|'[0-9.: -]') [A-Z_]+$~i",$Y)?$Y:$L);elseif(ereg('^(addtime|subtime|concat)$',$r))$L="$r(".idf_escape($F).", $L)";elseif(ereg('^(md5|sha1|password|encrypt)$',$r))$L="$r($L)";return unconvert_field($n,$L);}function dumpOutput(){$L=array('text'=>lang(44),'file'=>lang(45));if(function_exists('gzencode'))$L['gz']='gzip';return$L;}function dumpFormat(){return array('sql'=>'SQL','csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function dumpDatabase($l){}function dumpTable($R,$vf,$Uc=0){if($_POST["format"]!="sql"){echo"\xef\xbb\xbf";if($vf)dump_csv(array_keys(fields($R)));}elseif($vf){if($Uc==2){$o=array();foreach(fields($R)as$F=>$n)$o[]=idf_escape($F)." $n[full_type]";$j="CREATE TABLE ".table($R)." (".implode(", ",$o).")";}else$j=create_sql($R,$_POST["auto_increment"]);if($j){if($vf=="DROP+CREATE"||$Uc==1)echo"DROP ".($Uc==2?"VIEW":"TABLE")." IF EXISTS ".table($R).";\n";if($Uc==1)$j=remove_definer($j);echo"$j;\n\n";}}}function dumpData($R,$vf,$J){global$h,$y;$qd=($y=="sqlite"?0:1048576);if($vf){if($_POST["format"]=="sql"){if($vf=="TRUNCATE+INSERT")echo truncate_sql($R).";\n";$o=fields($R);}$K=$h->query($J,1);if($K){$Pc="";$Ga="";$Wc=array();$xf="";$ic=($R!=''?'fetch_assoc':'fetch_row');while($M=$K->$ic()){if(!$Wc){$tg=array();foreach($M as$X){$n=$K->fetch_field();$Wc[]=$n->name;$z=idf_escape($n->name);$tg[]="$z = VALUES($z)";}$xf=($vf=="INSERT+UPDATE"?"\nON DUPLICATE KEY UPDATE ".implode(", ",$tg):"").";\n";}if($_POST["format"]!="sql"){if($vf=="table"){dump_csv($Wc);$vf="INSERT";}dump_csv($M);}else{if(!$Pc)$Pc="INSERT INTO ".table($R)." (".implode(", ",array_map('idf_escape',$Wc)).") VALUES";foreach($M as$z=>$X){$n=$o[$z];$M[$z]=($X!==null?unconvert_field($n,ereg('(^|[^o])int|float|double|decimal',$n["type"])&&$X!=''?$X:q($X)):"NULL");}$bf=($qd?"\n":" ")."(".implode(",\t",$M).")";if(!$Ga)$Ga=$Pc.$bf;elseif(strlen($Ga)+4+strlen($bf)+strlen($xf)<$qd)$Ga.=",$bf";else{echo$Ga.$xf;$Ga=$Pc.$bf;}}}if($Ga)echo$Ga.$xf;}elseif($_POST["format"]=="sql")echo"-- ".str_replace("\n"," ",$h->error)."\n";}}function dumpFilename($Hc){return friendly_url($Hc!=""?$Hc:(SERVER!=""?SERVER:"localhost"));}function dumpHeaders($Hc,$Bd=false){$fe=$_POST["output"];$dc=(ereg('sql',$_POST["format"])?"sql":($Bd?"tar":"csv"));header("Content-Type: ".($fe=="gz"?"application/x-gzip":($dc=="tar"?"application/x-tar":($dc=="sql"||$fe!="file"?"text/plain":"text/csv")."; charset=utf-8")));if($fe=="gz")ob_start('gzencode',1e6);return$dc;}function homepage(){echo'

'.($_GET["ns"]==""?''.lang(46)."\n":""),(support("scheme")?"".($_GET["ns"]!=""?lang(47):lang(48))."\n":""),($_GET["ns"]!==""?''.lang(49)."\n":""),(support("privileges")?"".lang(50)."\n":"");return true;}function navigation($Ad){global$fa,$T,$y,$Ab;echo'

',$this->name(),' ',$fa,' ',(version_compare($fa,$_COOKIE["adminer_version"])<0?h($_COOKIE["adminer_version"]):""),'

';if($Ad=="auth"){$mc=true;foreach((array)$_SESSION["pwds"]as$_b=>$jf){foreach($jf as$P=>$sg){foreach($sg as$V=>$pe){if($pe!==null){if($mc){echo"

\n";$mc=false;}$pb=$_SESSION["db"][$_b][$P][$V];foreach(($pb?array_keys($pb):array(""))as$l)echo"($Ab[$_b]) ".h($V.($P!=""?"@$P":"").($l!=""?" - $l":""))."
\n";}}}}}else{echo'

';if(DB==""||!$Ad){echo"".lang(43)."\n";if(support("dump"))echo"".lang(52)."\n";}echo'

';$this->databasesPrint($Ad);if($_GET["ns"]!==""&&!$Ad&&DB!=""){echo'

".lang(54)."\n";$Ff=table_status('',true);if(!$Ff)echo"

".lang(7)."\n";else{$this->tablesPrint($Ff);$ld=array();foreach($Ff as$R=>$U)$ld[]=preg_quote($R,'/');echo"\n";}}}}function databasesPrint($Ad){global$h;$k=$this->databases();echo'

';hidden_fields_get();$nb=" onmousedown='dbMouseDown(event, this);' onchange='dbChange(this);'";echo($k?"":''),"\n";if($Ad!="db"&&DB!=""&&$h->select_db(DB)){}echo(isset($_GET["sql"])?'':(isset($_GET["schema"])?'':(isset($_GET["dump"])?'':""))),"

\n";}function tablesPrint($Ff){echo"

\n";foreach($Ff as$R=>$qf){echo'".lang(56)." ",'".$this->tableName($qf)."
\n";}}}$c=(function_exists('adminer_object')?adminer_object():new Adminer);if($c->operators===null)$c->operators=$Ud;function page_header($Qf,$m="",$Fa=array(),$Rf=""){global$a,$c,$h,$Ab;header("Content-Type: text/html; charset=utf-8");if($c->headers()){header("X-Frame-Options: deny");header("X-XSS-Protection: 0");}$Sf=$Qf.($Rf!=""?": ".h($Rf):"");$Tf=strip_tags($Sf.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$c->name());echo' ',$Tf,' ';if($c->head()){echo' ';if(file_exists("adminer.css")){echo' ';}}echo'

';if($Fa!==null){$A=substr(preg_replace('~(username|db|ns)=[^&]*&~','',ME),0,-1);echo'

$Sf

\n";restart_session();$pg=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$zd=$_SESSION["messages"][$pg];if($zd){echo"
".implode("
\n
",$zd)."
\n";unset($_SESSION["messages"][$pg]);}$k=&get_session("dbs");if(DB!=""&&$k&&!in_array(DB,$k,true))$k=null;stop_session();if($m)echo"
$m
\n";define("PAGE_HEADER",1);}function page_footer($Ad=""){global$c;echo'
';switch_lang();echo' ';}function int32($E){while($E>=2147483648)$E-=4294967296;while($E<=-2147483649)$E+=4294967296;return(int)$E;}function long2str($W,$yg){$bf='';foreach($W as$X)$bf.=pack('V',$X);if($yg)return substr($bf,0,end($W));return$bf;}function str2long($bf,$yg){$W=array_values(unpack('V*',str_pad($bf,4*ceil(strlen($bf)/4),"\0")));if($yg)$W[]=strlen($bf);return$W;}function xxtea_mx($Cg,$Bg,$yf,$Vc){return int32((($Cg>>5&0x7FFFFFF)^$Bg<<2)+(($Bg>>3&0x1FFFFFFF)^$Cg<<4))^int32(($yf^$Bg)+($Vc^$Cg));}function encrypt_string($sf,$z){if($sf=="")return"";$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($sf,true);$E=count($W)-1;$Cg=$W[$E];$Bg=$W[0];$I=floor(6+52/($E+1));$yf=0;while($I-->0){$yf=int32($yf+0x9E3779B9);$Gb=$yf>>2&3;for($ge=0;$ge<$E;$ge++){$Bg=$W[$ge+1];$Cd=xxtea_mx($Cg,$Bg,$yf,$z[$ge&3^$Gb]);$Cg=int32($W[$ge]+$Cd);$W[$ge]=$Cg;}$Bg=$W[0];$Cd=xxtea_mx($Cg,$Bg,$yf,$z[$ge&3^$Gb]);$Cg=int32($W[$E]+$Cd);$W[$E]=$Cg;}return long2str($W,false);}function decrypt_string($sf,$z){if($sf=="")return"";if(!$z)return false;$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($sf,false);$E=count($W)-1;$Cg=$W[$E];$Bg=$W[0];$I=floor(6+52/($E+1));$yf=int32($I*0x9E3779B9);while($yf){$Gb=$yf>>2&3;for($ge=$E;$ge>0;$ge--){$Cg=$W[$ge-1];$Cd=xxtea_mx($Cg,$Bg,$yf,$z[$ge&3^$Gb]);$Bg=int32($W[$ge]-$Cd);$W[$ge]=$Bg;}$Cg=$W[$E];$Cd=xxtea_mx($Cg,$Bg,$yf,$z[$ge&3^$Gb]);$Bg=int32($W[0]-$Cd);$W[0]=$Bg;$yf=int32($yf-0x9E3779B9);}return long2str($W,true);}$h='';$T=$_SESSION["token"];if(!$_SESSION["token"])$_SESSION["token"]=rand(1,1e6);$re=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($z)=explode(":",$X);$re[$z]=$X;}}$d=$_POST["auth"];if($d){session_regenerate_id();$_SESSION["pwds"][$d["driver"]][$d["server"]][$d["username"]]=$d["password"];$_SESSION["db"][$d["driver"]][$d["server"]][$d["username"]][$d["db"]]=true;if($d["permanent"]){$z=base64_encode($d["driver"])."-".base64_encode($d["server"])."-".base64_encode($d["username"])."-".base64_encode($d["db"]);$Ae=$c->permanentLogin(true);$re[$z]="$z:".base64_encode($Ae?encrypt_string($d["password"],$Ae):"");cookie("adminer_permanent",implode(" ",$re));}if(count($_POST)==1||DRIVER!=$d["driver"]||SERVER!=$d["server"]||$_GET["username"]!==$d["username"]||DB!=$d["db"])redirect(auth_url($d["driver"],$d["server"],$d["username"],$d["db"]));}elseif($_POST["logout"]){if($T&&$_POST["token"]!=$T){page_header(lang(53),lang(58));page_footer("db");exit;}else{foreach(array("pwds","db","dbs","queries")as$z)set_session($z,null);unset_permanent();redirect(substr(preg_replace('~(username|db|ns)=[^&]*&~','',ME),0,-1),lang(59));}}elseif($re&&!$_SESSION["pwds"]){session_regenerate_id();$Ae=$c->permanentLogin();foreach($re as$z=>$X){list(,$Ma)=explode(":",$X);list($_b,$P,$V,$l)=array_map('base64_decode',explode("-",$z));$_SESSION["pwds"][$_b][$P][$V]=decrypt_string(base64_decode($Ma),$Ae);$_SESSION["db"][$_b][$P][$V][$l]=true;}}function unset_permanent(){global$re;foreach($re as$z=>$X){list($_b,$P,$V,$l)=array_map('base64_decode',explode("-",$z));if($_b==DRIVER&&$P==SERVER&&$V==$_GET["username"]&&$l==DB)unset($re[$z]);}cookie("adminer_permanent",implode(" ",$re));}function auth_error($Xb=null){global$h,$c,$T;$kf=session_name();$m="";if(!$_COOKIE[$kf]&&$_GET[$kf]&&ini_bool("session.use_only_cookies"))$m=lang(60);elseif(isset($_GET["username"])){if(($_COOKIE[$kf]||$_GET[$kf])&&!$T)$m=lang(61);else{$pe=&get_session("pwds");if($pe!==null){$m=h($Xb?$Xb->getMessage():(is_string($h)?$h:lang(62)));if($pe===false)$m.='
'.lang(63,'permanentLogin()');$pe=null;}unset_permanent();}}page_header(lang(22),$m,null);echo"
\n";$c->loginForm();echo"
";hidden_fields($_POST,array("auth"));echo"
\n","
\n";page_footer("auth");}if(isset($_GET["username"])){if(!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header(lang(64),lang(65,implode(", ",$we)),false);page_footer("auth");exit;}$h=connect();}if(is_string($h)||!$c->login($_GET["username"],get_session("pwds"))){auth_error();exit;}$T=$_SESSION["token"];if($d&&$_POST["token"])$_POST["token"]=$T;$m='';if($_POST){if($_POST["token"]!=$T){$Mc="max_input_vars";$ud=ini_get($Mc);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$z){$X=ini_get($z);if($X&&(!$ud||$X<$ud)){$Mc=$z;$ud=$X;}}}$m=(!$_POST["token"]&&$ud?lang(66,"'$Mc'"):lang(58));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$m=lang(67,"'post_max_size'");if(isset($_GET["sql"]))$m.=' '.lang(68);}if(!ini_bool("session.use_cookies")||@ini_set("session.use_cookies",false)!==false){session_cache_limiter("");session_write_close();}function connect_error(){global$c,$h,$T,$m,$Ab;$k=array();if(DB!=""){header("HTTP/1.1 404 Not Found");page_header(lang(21).": ".h(DB),lang(69),true);}else{if($_POST["db"]&&!$m)queries_redirect(substr(ME,0,-1),lang(70),drop_databases($_POST["db"]));page_header(lang(71),$m,false);echo"

".lang(72)."\n";foreach(array('privileges'=>lang(50),'processlist'=>lang(73),'variables'=>lang(74),'status'=>lang(75),)as$z=>$X){if(support($z))echo"$X\n";}echo"

".lang(76,$Ab[DRIVER],"$h->server_info","$h->extension")."\n","

".lang(77,"".h(logged_user())."")."\n";$Oe="".lang(78)."\n";$k=$c->databases();if($k){$ef=support("scheme");$Ta=collations();echo"

\n","\n","\n";foreach($k as$l){$Xe=h(ME)."db=".urlencode($l);echo"
 ".lang(21)."".lang(79)."".lang(80)."
".checkbox("db[]",$l,in_array($l,(array)$_POST["db"])),"".h($l)."","".nbsp(db_collation($l,$Ta))."","?","\n";}echo"
\n","\n","

\n","\n",$Oe,"

\n";}else echo"

$Oe";}page_footer("db");if($k)echo"\n";}if(isset($_GET["status"]))$_GET["variables"]=$_GET["status"];if(!(DB!=""?$h->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;}function select($K,$i=null,$Gc="",$ae=array()){$ld=array();$w=array();$f=array();$Da=array();$gg=array();$L=array();odd('');for($t=0;$M=$K->fetch_row();$t++){if(!$t){echo"\n","";for($x=0;$xfetch_field();$F=$n->name;$Zd=$n->orgtable;$Yd=$n->orgname;$L[$n->table]=$Zd;if($Gc)$ld[$x]=($F=="table"?"table=":($F=="possible_keys"?"indexes=":null));elseif($Zd!=""){if(!isset($w[$Zd])){$w[$Zd]=array();foreach(indexes($Zd,$i)as$v){if($v["type"]=="PRIMARY"){$w[$Zd]=array_flip($v["columns"]);break;}}$f[$Zd]=$w[$Zd];}if(isset($f[$Zd][$Yd])){unset($f[$Zd][$Yd]);$w[$Zd][$Yd]=$x;$ld[$x]=$Zd;}}if($n->charsetnr==63)$Da[$x]=true;$gg[$x]=$n->type;$F=h($F);echo"name!=$Yd?" title='".h(($Zd!=""?"$Zd.":"").$Yd)."'":"").">".($Gc?"$F":$F);}echo"\n";}echo"";foreach($M as$z=>$X){if($X===null)$X="NULL";elseif($Da[$z]&&!is_utf8($X))$X="".lang(31,strlen($X))."";elseif(!strlen($X))$X=" ";else{$X=h($X);if($gg[$z]==254)$X="$X";}if(isset($ld[$z])&&!$f[$ld[$z]]){if($Gc){$R=$M[array_search("table=",$ld)];$A=$ld[$z].urlencode($ae[$R]!=""?$ae[$R]:$R);}else{$A="edit=".urlencode($ld[$z]);foreach($w[$ld[$z]]as$Qa=>$x)$A.="&where".urlencode("[".bracket_escape($Qa)."]")."=".urlencode($M[$x]);}$X="$X";}echo"
$X";}}echo($t?"
":"

".lang(82))."\n";return$L;}function referencable_primary($gf){$L=array();foreach(table_status('',true)as$Bf=>$R){if($Bf!=$gf&&fk_support($R)){foreach(fields($Bf)as$n){if($n["primary"]){if($L[$Bf]){unset($L[$Bf]);break;}$L[$Bf]=$n;}}}}return$L;}function textarea($F,$Y,$N=10,$Ua=80){echo"";}function edit_type($z,$n,$Ta,$q=array()){global$uf,$gg,$ng,$Qd;echo' ';echo"',($ng?"':''),(isset($n['on_update'])?"':''),($q?" ":" ");}function process_length($id){global$Rb;return(preg_match("~^\\s*(?:$Rb)(?:\\s*,\\s*(?:$Rb))*\\s*\$~",$id)&&preg_match_all("~$Rb~",$id,$od)?implode(",",$od[0]):preg_replace('~[^0-9,+-]~','',$id));}function process_type($n,$Ra="COLLATE"){global$ng;return" $n[type]".($n["length"]!=""?"(".process_length($n["length"]).")":"").(ereg('(^|[^o])int|float|double|decimal',$n["type"])&&in_array($n["unsigned"],$ng)?" $n[unsigned]":"").(ereg('char|text|enum|set',$n["type"])&&$n["collation"]?" $Ra ".q($n["collation"]):"");}function process_field($n,$eg){return array(idf_escape(trim($n["field"])),process_type($eg),($n["null"]?" NULL":" NOT NULL"),(isset($n["default"])?" DEFAULT ".((ereg("time",$n["type"])&&eregi('^CURRENT_TIMESTAMP$',$n["default"]))||($n["type"]=="bit"&&ereg("^([0-9]+|b'[0-1]+')\$",$n["default"]))?$n["default"]:q($n["default"])):""),($n["type"]=="timestamp"&&$n["on_update"]?" ON UPDATE $n[on_update]":""),(support("comment")&&$n["comment"]!=""?" COMMENT ".q($n["comment"]):""),($n["auto_increment"]?auto_increment():null),);}function type_class($U){foreach(array('char'=>'text','date'=>'time|year','binary'=>'blob','enum'=>'set',)as$z=>$X){if(ereg("$z|$X",$U))return" class='$z'";}}function edit_fields($o,$Ta,$U="TABLE",$q=array(),$Ya=false){global$h,$Nc;echo' ';if($U=="PROCEDURE"){echo' ';}echo'',($U=="TABLE"?lang(87):lang(88)),'',lang(89),' ',lang(90),'',lang(91);if($U=="TABLE"){echo'NULL AI ',lang(93),(support("comment")?"

".lang(94).": ".h($Xa)."\n";if($o){echo"\n","\n";foreach($o as$n){echo"
".lang(101)."".lang(89).(support("comment")?"".lang(94):"")."
".h($n["field"]),"".h($n["full_type"]).($n["null"]?" NULL":"").($n["auto_increment"]?" ".lang(92)."":""),(isset($n["default"])?" [".h($n["default"])."]":""),(support("comment")?"".nbsp($n["comment"]):""),"\n";}echo"
\n";if(!is_view($S)){echo"

".lang(102)."

\n";$w=indexes($b);if($w){echo"\n";foreach($w as$F=>$v){ksort($v["columns"]);$_e=array();foreach($v["columns"]as$z=>$X)$_e[]="".h($X)."".($v["lengths"][$z]?"(".$v["lengths"][$z].")":"").($v["descs"][$z]?" DESC":"");echo"
$v[type]".implode(", ",$_e)."\n";}echo"
\n";}echo'

'.lang(103)."\n";if(fk_support($S)){echo"

".lang(83)."

\n";$q=foreign_keys($b);if($q){echo"\n","\n";foreach($q as$F=>$p){echo"","
".lang(104)."".lang(105)."".lang(86)."".lang(85).($y!="sqlite"?" ":"")."
".implode(", ",array_map('h',$p["source"]))."","".($p["db"]!=""?"".h($p["db"]).".":"").($p["ns"]!=""?"".h($p["ns"]).".":"").h($p["table"])."","(".implode(", ",array_map('h',$p["target"])).")","".nbsp($p["on_delete"])."\n","".nbsp($p["on_update"])."\n",($y=="sqlite"?"":''.lang(106).'');}echo"
\n";}if($y!="sqlite")echo'

'.lang(107)."\n";}if(support("trigger")){echo"

".lang(108)."

\n";$dg=triggers($b);if($dg){echo"\n";foreach($dg as$z=>$X)echo"
$X[0]$X[1]".h($z)."".lang(106)."\n";echo"
\n";}echo'

'.lang(109)."\n";}}}}elseif(isset($_GET["schema"])){page_header(lang(49),"",array(),DB.($_GET["ns"]?".$_GET[ns]":""));$Cf=array();$Df=array();$F="adminer_schema";$da=($_GET["schema"]?$_GET["schema"]:$_COOKIE[($_COOKIE["$F-".DB]?"$F-".DB:$F)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$da,$od,PREG_SET_ORDER);foreach($od as$t=>$C){$Cf[$C[1]]=array($C[2],$C[3]);$Df[]="\n\t'".js_escape($C[1])."': [ $C[2], $C[3] ]";}$Wf=0;$Aa=-1;$df=array();$Ne=array();$gd=array();foreach(table_status('',true)as$R=>$S){if(is_view($S))continue;$te=0;$df[$R]["fields"]=array();foreach(fields($R)as$F=>$n){$te+=1.25;$n["pos"]=$te;$df[$R]["fields"][$F]=$n;}$df[$R]["pos"]=($Cf[$R]?$Cf[$R]:array($Wf,0));foreach($c->foreignKeys($R)as$X){if(!$X["db"]){$ed=$Aa;if($Cf[$R][1]||$Cf[$X["table"]][1])$ed=min(floatval($Cf[$R][1]),floatval($Cf[$X["table"]][1]))-1;else$Aa-=.1;while($gd[(string)$ed])$ed-=.0001;$df[$R]["references"][$X["table"]][(string)$ed]=array($X["source"],$X["target"]);$Ne[$X["table"]][$R][(string)$ed]=$X["target"];$gd[(string)$ed]=true;}}$Wf=max($Wf,$df[$R]["pos"][0]+2.5+$te);}echo'

';foreach($df as$F=>$R){echo"
",''.h($F)."";foreach($R["fields"]as$n){$X=''.h($n["field"]).'';echo"
".($n["primary"]?"$X":$X);}foreach((array)$R["references"]as$Jf=>$Pe){foreach($Pe as$ed=>$Ke){$fd=$ed-$Cf[$F][1];$t=0;foreach($Ke[0]as$mf)echo"\n
";}}foreach((array)$Ne[$F]as$Jf=>$Pe){foreach($Pe as$ed=>$f){$fd=$ed-$Cf[$F][1];$t=0;foreach($f as$If)echo"\n
";}}echo"\n
\n";}foreach($df as$F=>$R){foreach((array)$R["references"]as$Jf=>$Pe){foreach($Pe as$ed=>$Ke){$_d=$Wf;$sd=-10;foreach($Ke[0]as$z=>$mf){$ue=$R["pos"][0]+$R["fields"][$mf]["pos"];$ve=$df[$Jf]["pos"][0]+$df[$Jf]["fields"][$Ke[1][$z]]["pos"];$_d=min($_d,$ue,$ve);$sd=max($sd,$ue,$ve);}echo"
\n";}}}echo'

',lang(110),' ';}elseif(isset($_GET["dump"])){$b=$_GET["dump"];if($_POST&&!$m){$eb="";foreach(array("output","format","db_style","routines","events","table_style","auto_increment","triggers","data_style")as$z)$eb.="&$z=".urlencode($_POST[$z]);cookie("adminer_export",substr($eb,1));$Ff=array_flip((array)$_POST["tables"])+array_flip((array)$_POST["data"]);$dc=dump_headers((count($Ff)==1?key($Ff):DB),(DB==""||count($Ff)>1));$Sc=ereg('sql',$_POST["format"]);if($Sc)echo"-- Adminer $fa ".$Ab[DRIVER]." dump ".($y!="sql"?"":"SET NAMES utf8; ".($_POST["data_style"]?"SET foreign_key_checks = 0; SET time_zone = ".q(substr(preg_replace('~^[^-]~','+\0',$h->result("SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP)")),0,6))."; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; ":"")." ");$vf=$_POST["db_style"];$k=array(DB);if(DB==""){$k=$_POST["databases"];if(is_string($k))$k=explode("\n",rtrim(str_replace("\r","",$k),"\n"));}foreach((array)$k as$l){$c->dumpDatabase($l);if($h->select_db($l)){if($Sc&&ereg('CREATE',$vf)&&($j=$h->result("SHOW CREATE DATABASE ".idf_escape($l),1))){if($vf=="DROP+CREATE")echo"DROP DATABASE IF EXISTS ".idf_escape($l).";\n";echo"$j;\n";}if($Sc){if($vf)echo use_sql($l).";\n\n";$ee="";if($_POST["routines"]){foreach(array("FUNCTION","PROCEDURE")as$Ye){foreach(get_rows("SHOW $Ye STATUS WHERE Db = ".q($l),null,"-- ")as$M)$ee.=($vf!='DROP+CREATE'?"DROP $Ye IF EXISTS ".idf_escape($M["Name"]).";;\n":"").remove_definer($h->result("SHOW CREATE $Ye ".idf_escape($M["Name"]),2)).";;\n\n";}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$M)$ee.=($vf!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($M["Name"]).";;\n":"").remove_definer($h->result("SHOW CREATE EVENT ".idf_escape($M["Name"]),3)).";;\n\n";}if($ee)echo"DELIMITER ;;\n\n$ee"."DELIMITER ;\n\n";}if($_POST["table_style"]||$_POST["data_style"]){$wg=array();foreach(table_status('',true)as$F=>$S){$R=(DB==""||in_array($F,(array)$_POST["tables"]));$kb=(DB==""||in_array($F,(array)$_POST["data"]));if($R||$kb){if($dc=="tar"){$Uf=new TmpFile;ob_start(array($Uf,'write'),1e5);}$c->dumpTable($F,($R?$_POST["table_style"]:""),(is_view($S)?2:0));if(is_view($S))$wg[]=$F;elseif($kb){$o=fields($F);$c->dumpData($F,$_POST["data_style"],"SELECT *".convert_fields($o,$o)." FROM ".table($F));}if($Sc&&$_POST["triggers"]&&$R&&($dg=trigger_sql($F,$_POST["table_style"])))echo"\nDELIMITER ;;\n$dg\nDELIMITER ;\n";if($dc=="tar"){ob_end_flush();tar_file((DB!=""?"":"$l/")."$F.csv",$Uf);}elseif($Sc)echo"\n";}}foreach($wg as$vg)$c->dumpTable($vg,$_POST["table_style"],1);if($dc=="tar")echo pack("x512");}}}if($Sc)echo"-- ".$h->result("SELECT NOW()")."\n";exit;}page_header(lang(111),$m,($_GET["export"]!=""?array("table"=>$_GET["export"]):array()),DB);echo'

';$ob=array('','USE','DROP+CREATE','CREATE');$Ef=array('','DROP+CREATE','CREATE');$lb=array('','TRUNCATE+INSERT','INSERT');if($y=="sql")$lb[]='INSERT+UPDATE';parse_str($_COOKIE["adminer_export"],$M);if(!$M)$M=array("output"=>"text","format"=>"sql","db_style"=>(DB!=""?"":"CREATE"),"table_style"=>"DROP+CREATE","data_style"=>"INSERT");if(!isset($M["events"])){$M["routines"]=$M["events"]=($_GET["dump"]=="");$M["triggers"]=$M["table_style"];}echo"
".lang(112)."".html_select("output",$c->dumpOutput(),$M["output"],0)."\n";echo"
".lang(113)."".html_select("format",$c->dumpFormat(),$M["format"],0)."\n";echo($y=="sqlite"?"":"
".lang(21)."".html_select('db_style',$ob,$M["db_style"]).(support("routine")?checkbox("routines",1,$M["routines"],lang(114)):"").(support("event")?checkbox("events",1,$M["events"],lang(115)):"")),"
".lang(80)."".html_select('table_style',$Ef,$M["table_style"]).checkbox("auto_increment",1,$M["auto_increment"],lang(92)).(support("trigger")?checkbox("triggers",1,$M["triggers"],lang(108)):""),"
".lang(116)."".html_select('data_style',$lb,$M["data_style"]),'

';$ye=array();if(DB!=""){$Ka=($b!=""?"":" checked");echo"","\n";$wg="";$Gf=tables_list();foreach($Gf as$F=>$U){$xe=ereg_replace("_.*","",$F);$Ka=($b==""||$b==(substr($b,-1)=="%"?"$xe%":$F));$_e="\n";$k=$c->databases();if($k){foreach($k as$l){if(!information_schema($l)){$xe=ereg_replace("_.*","",$l);echo"
","","
".checkbox("tables[]",$F,$Ka,$F,"checkboxClick(event, this); formUncheck('check-tables');","block");if($U!==null&&!eregi("table",$U))$wg.="$_e\n";else echo"$_e\n";$ye[$xe]++;}echo$wg;if($Gf)echo"\n";}else{echo"
".checkbox("databases[]",$l,$b==""||$b=="$xe%",$l,"formUncheck('check-databases');","block")."\n";$ye[$xe]++;}}}else echo"
";}echo'

';$mc=true;foreach($ye as$z=>$X){if($z!=""&&$X>1){echo($mc?"

":" ")."".h($z)."";$mc=false;}}}elseif(isset($_GET["privileges"])){page_header(lang(50));$K=$h->query("SELECT User, Host FROM mysql.".(DB==""?"user":"db WHERE ".q(DB)." LIKE Db")." ORDER BY Host, User");$s=$K;if(!$K)$K=$h->query("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1) AS User, SUBSTRING_INDEX(CURRENT_USER, '@', -1) AS Host");echo"

\n";hidden_fields_get();echo"\n",($s?"":"\n"),"\n","\n";while($M=$K->fetch_assoc())echo'
".lang(19)."".lang(18)." 
'.h($M["User"])."".h($M["Host"]).''.lang(30)."\n";if(!$s||DB!="")echo"\n";echo"
\n","

\n",'

'.lang(117)."";}elseif(isset($_GET["sql"])){if(!$m&&$_POST["export"]){dump_headers("sql");$c->dumpTable("","");$c->dumpData("","table",$_POST["query"]);exit;}restart_session();$Ec=&get_session("queries");$Dc=&$Ec[DB];if(!$m&&$_POST["clear"]){$Dc=array();redirect(remove_from_uri("history"));}page_header(lang(43),$m);if(!$m&&$_POST){$tc=false;$J=$_POST["query"];if($_POST["webfile"]){$tc=@fopen((file_exists("adminer.sql")?"adminer.sql":"compress.zlib://adminer.sql.gz"),"rb");$J=($tc?fread($tc,1e6):false);}elseif($_FILES&&$_FILES["sql_file"]["error"][0]!=4)$J=get_file("sql_file",true);if(is_string($J)){if(function_exists('memory_get_usage'))@ini_set("memory_limit",max(ini_bytes("memory_limit"),2*strlen($J)+memory_get_usage()+8e6));if($J!=""&&strlen($J)<1e6){$I=$J.(ereg(";[ \t\r\n]*\$",$J)?"":";");if(!$Dc||reset(end($Dc))!=$I){restart_session();$Dc[]=array($I,time());set_session("queries",$Ec);stop_session();}}$nf="(?:\\s|/\\*.*\\*/|(?:#|-- )[^\n]*\n|--\n)";$sb=";";$Jd=0;$Nb=true;$i=connect();if(is_object($i)&&DB!="")$i->select_db(DB);$Wa=0;$Tb=array();$kd=0;$je='[\'"'.($y=="sql"?'`#':($y=="sqlite"?'`[':($y=="mssql"?'[':''))).']|/\\*|-- |$'.($y=="pgsql"?'|\\$[^$]*\\$':'');$Xf=microtime();parse_str($_COOKIE["adminer_export"],$ka);$Fb=$c->dumpFormat();unset($Fb["sql"]);while($J!=""){if(!$Jd&&preg_match("~^$nf*DELIMITER\\s+(\\S+)~i",$J,$C)){$sb=$C[1];$J=substr($J,strlen($C[0]));}else{preg_match('('.preg_quote($sb)."\\s*|$je)",$J,$C,PREG_OFFSET_CAPTURE,$Jd);list($rc,$te)=$C[0];if(!$rc&&$tc&&!feof($tc))$J.=fread($tc,1e5);else{if(!$rc&&rtrim($J)=="")break;$Jd=$te+strlen($rc);if($rc&&rtrim($rc)!=$sb){while(preg_match('('.($rc=='/*'?'\\*/':($rc=='['?']':(ereg('^-- |^#',$rc)?"\n":preg_quote($rc)."|\\\\."))).'|$)s',$J,$C,PREG_OFFSET_CAPTURE,$Jd)){$bf=$C[0][0];if(!$bf&&$tc&&!feof($tc))$J.=fread($tc,1e5);else{$Jd=$C[0][1]+strlen($bf);if($bf[0]!="\\")break;}}}else{$Nb=false;$I=substr($J,0,$te);$Wa++;$_e="

".shorten_utf8(trim($I),1000)."
\n";if(!$_POST["only_errors"]){echo$_e;ob_flush();flush();}$pf=microtime();if($h->multi_query($I)&&is_object($i)&&preg_match("~^$nf*USE\\b~isU",$I))$i->query($I);do{$K=$h->store_result();$Ob=microtime();$Of=" (".format_time($pf,$Ob).")".(strlen($I)<1000?" ".lang(30)."":"");if($h->error){echo($_POST["only_errors"]?$_e:""),"

".lang(118).($h->errno?" ($h->errno)":"").": ".error()."\n";$Tb[]=" $Wa";if($_POST["error_stops"])break 2;}elseif(is_object($K)){$ae=select($K,$i);if(!$_POST["only_errors"]){echo"

\n","

".($K->num_rows?lang(119,$K->num_rows):"").$Of;$u="export-$Wa";$cc=", ".lang(111)."\n";if($i&&preg_match("~^($nf|\\()*SELECT\\b~isU",$I)&&($bc=explain($i,$I))){$u="explain-$Wa";echo", EXPLAIN$cc","

\n";}else echo$cc;echo"
\n";}}else{if(preg_match("~^$nf*(CREATE|DROP|ALTER)$nf+(DATABASE|SCHEMA)\\b~isU",$I)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"])echo"

".lang(120,$h->affected_rows)."$Of\n";}$pf=$Ob;}while($h->next_result());$kd+=substr_count($I.$rc,"\n");$J=substr($J,$Jd);$Jd=0;}}}}if($Nb)echo"

".lang(121)."\n";elseif($_POST["only_errors"]){echo"

".lang(122,$Wa-count($Tb))," (".format_time($Xf,microtime()).")\n";}elseif($Tb&&$Wa>1)echo"

".lang(118).": ".implode("",$Tb)."\n";}else echo"

".upload_error($J)."\n";}echo'

';$I=$_GET["sql"];if($_POST)$I=$_POST["query"];elseif($_GET["history"]=="all")$I=$Dc;elseif($_GET["history"]!="")$I=$Dc[$_GET["history"]][0];textarea("query",$I,20);echo($_POST?"":"\n"),"

".(ini_bool("file_uploads")?lang(123).': (< '.ini_get("upload_max_filesize").'B)':lang(124)),'

',checkbox("error_stops",1,$_POST["error_stops"],lang(125))."\n",checkbox("only_errors",1,$_POST["only_errors"],lang(126))."\n";print_fieldset("webfile",lang(127),$_POST["webfile"],"document.getElementById('form')['only_errors'].checked = true; ");echo lang(128,"adminer.sql".(extension_loaded("zlib")?"[.gz]":"").""),' ',"\n";if($Dc){print_fieldset("history",lang(130),$_GET["history"]!="");for($X=end($Dc);$X;$X=prev($Dc)){$z=key($Dc);list($I,$Of)=$X;echo''.lang(30)." ".@date("H:i:s",$Of)." ".shorten_utf8(ltrim(str_replace("\n"," ",str_replace("\r","",preg_replace('~^(#|-- ).*~m','',$I)))),80,"")."
\n";}echo"\n","".lang(132)."\n","\n";}echo'

';}elseif(isset($_GET["edit"])){$b=$_GET["edit"];$o=fields($b);$Z=(isset($_GET["select"])?(count($_POST["check"])==1?where_check($_POST["check"][0],$o):""):where($_GET,$o));$og=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($o as$F=>$n){if(!isset($n["privileges"][$og?"update":"insert"])||$c->fieldName($n)=="")unset($o[$F]);}if($_POST&&!$m&&!isset($_GET["select"])){$B=$_POST["referer"];if($_POST["insert"])$B=($og?null:$_SERVER["REQUEST_URI"]);elseif(!ereg('^.+&select=.+$',$B))$B=ME."select=".urlencode($b);$w=indexes($b);$jg=unique_array($_GET["where"],$w);$He="\nWHERE $Z";if(isset($_POST["delete"])){$J="FROM ".table($b);query_redirect("DELETE".($jg?" $J$He":limit1($J,$He)),$B,lang(133));}else{$Q=array();foreach($o as$F=>$n){$X=process_input($n);if($X!==false&&$X!==null)$Q[idf_escape($F)]=($og?"\n".idf_escape($F)." = $X":$X);}if($og){if(!$Q)redirect($B);$J=table($b)." SET".implode(",",$Q);query_redirect("UPDATE".($jg?" $J$He":limit1($J,$He)),$B,lang(134));}else{$K=insert_into($b,$Q);$dd=($K?last_id():0);queries_redirect($B,lang(135,($dd?" $dd":"")),$K);}}}$Bf=$c->tableName(table_status1($b,true));page_header(($og?lang(30):lang(136)),$m,array("select"=>array($b,$Bf)),$Bf);$M=null;if($_POST["save"])$M=(array)$_POST["fields"];elseif($Z){$O=array();foreach($o as$F=>$n){if(isset($n["privileges"]["select"])){$ta=convert_field($n);if($_POST["clone"]&&$n["auto_increment"])$ta="''";if($y=="sql"&&ereg("enum|set",$n["type"]))$ta="1*".idf_escape($F);$O[]=($ta?"$ta AS ":"").idf_escape($F);}}$M=array();if($O){$N=get_rows("SELECT".limit(implode(", ",$O)." FROM ".table($b)," WHERE $Z",(isset($_GET["select"])?2:1)));$M=(isset($_GET["select"])&&count($N)!=1?null:reset($N));}}if($M===false)echo"

".lang(82)."\n";echo'

';if(!$o)echo"

".lang(137)."\n";else{echo"\n";foreach($o as$F=>$n){echo"
".$c->fieldName($n);$rb=$_GET["set"][bracket_escape($F)];if($rb===null){$rb=$n["default"];if($n["type"]=="bit"&&ereg("^b'([01]*)'\$",$rb,$Qe))$rb=$Qe[1];}$Y=($M!==null?($M[$F]!=""&&$y=="sql"&&ereg("enum|set",$n["type"])?(is_array($M[$F])?array_sum($M[$F]):+$M[$F]):$M[$F]):(!$og&&$n["auto_increment"]?"":(isset($_GET["select"])?false:$rb)));if(!$_POST["save"]&&is_string($Y))$Y=$c->editVal($Y,$n);$r=($_POST["save"]?(string)$_POST["function"][$F]:($og&&$n["on_update"]=="CURRENT_TIMESTAMP"?"now":($Y===false?null:($Y!==null?'':'NULL'))));if(ereg("time",$n["type"])&&$Y=="CURRENT_TIMESTAMP"){$Y="";$r="now";}input($n,$Y,$r);echo"\n";}echo"
\n";}echo'

';if($o){echo"\n";if(!isset($_GET["select"]))echo"\n";}echo($og?"\n":($_POST||!$o?"":"\n"));if(isset($_GET["select"]))hidden_fields(array("check"=>(array)$_POST["check"],"clone"=>$_POST["clone"],"all"=>$_POST["all"]));echo'

';}elseif(isset($_GET["create"])){$b=$_GET["create"];$ke=array('HASH','LINEAR HASH','KEY','LINEAR KEY','RANGE','LIST');$Me=referencable_primary($b);$q=array();foreach($Me as$Bf=>$n)$q[str_replace("`","``",$Bf)."`".str_replace("`","``",$n["field"])]=$Bf;$de=array();$S=array();if($b!=""){$de=fields($b);$S=table_status($b);if(!$S)$m=lang(7);}$M=$_POST;$M["fields"]=(array)$M["fields"];if($M["auto_increment_col"])$M["fields"][$M["auto_increment_col"]]["auto_increment"]=true;if($_POST&&!process_fields($M["fields"])&&!$m){if($_POST["drop"])query_redirect("DROP TABLE ".table($b),substr(ME,0,-1),lang(142));else{$o=array();$qa=array();$qg=false;$oc=array();ksort($M["fields"]);$ce=reset($de);$oa=" FIRST";foreach($M["fields"]as$z=>$n){$p=$q[$n["type"]];$eg=($p!==null?$Me[$p]:$n);if($n["field"]!=""){if(!$n["has_default"])$n["default"]=null;if($z==$M["auto_increment_col"])$n["auto_increment"]=true;$Ee=process_field($n,$eg);$qa[]=array($n["orig"],$Ee,$oa);if($Ee!=process_field($ce,$ce)){$o[]=array($n["orig"],$Ee,$oa);if($n["orig"]!=""||$oa)$qg=true;}if($p!==null)$oc[idf_escape($n["field"])]=($b!=""&&$y!="sqlite"?"ADD":" ")." FOREIGN KEY (".idf_escape($n["field"]).") REFERENCES ".table($q[$n["type"]])." (".idf_escape($eg["field"]).")".(ereg("^($Qd)\$",$n["on_delete"])?" ON DELETE $n[on_delete]":"");$oa=" AFTER ".idf_escape($n["field"]);}elseif($n["orig"]!=""){$qg=true;$o[]=array($n["orig"]);}if($n["orig"]!=""){$ce=next($de);if(!$ce)$oa="";}}$me="";if(in_array($M["partition_by"],$ke)){$ne=array();if($M["partition_by"]=='RANGE'||$M["partition_by"]=='LIST'){foreach(array_filter($M["partition_names"])as$z=>$X){$Y=$M["partition_values"][$z];$ne[]="\n PARTITION ".idf_escape($X)." VALUES ".($M["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$me.="\nPARTITION BY $M[partition_by]($M[partition])".($ne?" (".implode(",",$ne)."\n)":($M["partitions"]?" PARTITIONS ".(+$M["partitions"]):""));}elseif(support("partitioning")&&ereg("partitioned",$S["Create_options"]))$me.="\nREMOVE PARTITIONING";$D=lang(143);if($b==""){cookie("adminer_engine",$M["Engine"]);$D=lang(144);}$F=trim($M["name"]);queries_redirect(ME."table=".urlencode($F),$D,alter_table($b,$F,($y=="sqlite"&&($qg||$oc)?$qa:$o),$oc,$M["Comment"],($M["Engine"]&&$M["Engine"]!=$S["Engine"]?$M["Engine"]:""),($M["Collation"]&&$M["Collation"]!=$S["Collation"]?$M["Collation"]:""),($M["Auto_increment"]!=""?+$M["Auto_increment"]:""),$me));}}page_header(($b!=""?lang(27):lang(145)),$m,array("table"=>$b),$b);if(!$_POST){$M=array("Engine"=>$_COOKIE["adminer_engine"],"fields"=>array(array("field"=>"","type"=>(isset($gg["int"])?"int":(isset($gg["integer"])?"integer":"")))),"partition_names"=>array(""),);if($b!=""){$M=$S;$M["name"]=$b;$M["fields"]=array();if(!$_GET["auto_increment"])$M["Auto_increment"]="";foreach($de as$n){$n["has_default"]=isset($n["default"]);$M["fields"][]=$n;}if(support("partitioning")){$uc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($b);$K=$h->query("SELECT PARTITION_METHOD, PARTITION_ORDINAL_POSITION, PARTITION_EXPRESSION $uc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");list($M["partition_by"],$M["partitions"],$M["partition"])=$K->fetch_row();$ne=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $uc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$ne[""]="";$M["partition_names"]=array_keys($ne);$M["partition_values"]=array_values($ne);}}}$Ta=collations();$Qb=engines();foreach($Qb as$Pb){if(!strcasecmp($Pb,$M["Engine"])){$M["Engine"]=$Pb;break;}}echo'

',lang(146),': ';if($b==""&&!$_POST){?>"(".lang(147).")")+$Qb,$M["Engine"]):""),' ',($Ta&&!ereg("sqlite|mssql",$y)?html_select("Collation",array(""=>"(".lang(84).")")+$Ta,$M["Collation"]):""),' ';$Ya=($_POST?$_POST["comments"]:$M["Comment"]!="");if(!$_POST&&!$Ya){foreach($M["fields"]as$n){if($n["comment"]!=""){$Ya=true;break;}}}edit_fields($M["fields"],$Ta,"TABLE",$q,$Ya);echo'

',lang(92),': ',checkbox("defaults",1,true,lang(93),"columnShow(this.checked, 5)","jsonly");if(!$_POST["defaults"]){echo'';}echo(support("comment")?"".' ':''),'

';if($_GET["create"]!=""){echo'';}if(support("partitioning")){$le=ereg('RANGE|LIST',$M["partition_by"]);print_fieldset("partition",lang(148),$M["partition_by"]);echo'

',html_select("partition_by",array(-1=>"")+$ke,$M["partition_by"],"partitionByChange(this);"),'() ',lang(149),': ';foreach($M["partition_names"]as$z=>$X){echo'',' ';}echo'

';}elseif(isset($_GET["indexes"])){$b=$_GET["indexes"];$Lc=array("PRIMARY","UNIQUE","INDEX");$S=table_status($b,true);if(eregi("MyISAM|M?aria".($h->server_info>=5.6?"|InnoDB":""),$S["Engine"]))$Lc[]="FULLTEXT";$w=indexes($b);if($y=="sqlite"){unset($Lc[0]);unset($w[""]);}$M=$_POST;if($_POST&&!$m&&!$_POST["add"]){$ra=array();foreach($M["indexes"]as$v){$F=$v["name"];if(in_array($v["type"],$Lc)){$f=array();$jd=array();$ub=array();$Q=array();ksort($v["columns"]);foreach($v["columns"]as$z=>$e){if($e!=""){$id=$v["lengths"][$z];$tb=$v["descs"][$z];$Q[]=idf_escape($e).($id?"(".(+$id).")":"").($tb?" DESC":"");$f[]=$e;$jd[]=($id?$id:null);$ub[]=$tb;}}if($f){$ac=$w[$F];if($ac){ksort($ac["columns"]);ksort($ac["lengths"]);ksort($ac["descs"]);if($v["type"]==$ac["type"]&&array_values($ac["columns"])===$f&&(!$ac["lengths"]||array_values($ac["lengths"])===$jd)&&array_values($ac["descs"])===$ub){unset($w[$F]);continue;}}$ra[]=array($v["type"],$F,"(".implode(", ",$Q).")");}}}foreach($w as$F=>$ac)$ra[]=array($ac["type"],$F,"DROP");if(!$ra)redirect(ME."table=".urlencode($b));queries_redirect(ME."table=".urlencode($b),lang(152),alter_indexes($b,$ra));}page_header(lang(102),$m,array("table"=>$b),$b);$o=array_keys(fields($b));if($_POST["add"]){foreach($M["indexes"]as$z=>$v){if($v["columns"][count($v["columns"])]!="")$M["indexes"][$z]["columns"][]="";}$v=end($M["indexes"]);if($v["type"]||array_filter($v["columns"],'strlen')||array_filter($v["lengths"],'strlen')||array_filter($v["descs"]))$M["indexes"][]=array("columns"=>array(1=>""));}if(!$M){foreach($w as$z=>$v){$w[$z]["name"]=$z;$w[$z]["columns"][]="";}$w[]=array("columns"=>array(1=>""));$M["indexes"]=$w;}echo'
';$x=1;foreach($M["indexes"]as$v){echo"
',lang(153),'',lang(154),'',lang(155),'
".html_select("indexes[$x][type]",array(-1=>"")+$Lc,$v["type"],($x==count($M["indexes"])?"indexesAddRow(this);":1))."";ksort($v["columns"]);$t=1;foreach($v["columns"]as$z=>$e){echo"".html_select("indexes[$x][columns][$t]",array(-1=>"")+$o,$e,($t==count($v["columns"])?"indexesAddColumn":"indexesChangeColumn")."(this, '".js_escape($y=="sql"?"":$_GET["indexes"]."_")."');"),($y=="sql"||$y=="mssql"?"":""),($y!="sql"?checkbox("indexes[$x][descs][$t]",1,$v["descs"][$z],lang(38)):"")," ";$t++;}echo"\n";$x++;}echo'

';}elseif(isset($_GET["database"])){$M=$_POST;if($_POST&&!$m&&!isset($_POST["add_x"])){restart_session();$F=trim($M["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),lang(156),drop_databases(array(DB)));}elseif(DB!==$F){if(DB!=""){$_GET["db"]=$F;queries_redirect(preg_replace('~db=[^&]*&~','',ME)."db=".urlencode($F),lang(157),rename_database($F,$M["collation"]));}else{$k=explode("\n",str_replace("\r","",$F));$wf=true;$cd="";foreach($k as$l){if(count($k)==1||$l!=""){if(!create_database($l,$M["collation"]))$wf=false;$cd=$l;}}queries_redirect(ME."db=".urlencode($cd),lang(158),$wf);}}else{if(!$M["collation"])redirect(substr(ME,0,-1));query_redirect("ALTER DATABASE ".idf_escape($F).(eregi('^[a-z0-9_]+$',$M["collation"])?" COLLATE $M[collation]":""),substr(ME,0,-1),lang(159));}}page_header(DB!=""?lang(46):lang(160),$m,array(),DB);$Ta=collations();$F=DB;if($_POST)$F=$M["name"];elseif(DB!="")$M["collation"]=db_collation(DB,$Ta);elseif($y=="sql"){foreach(get_vals("SHOW GRANTS")as$s){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\\.\\*)?~',$s,$C)&&$C[1]){$F=stripcslashes(idf_unescape("`$C[2]`"));break;}}}echo'

',($_POST["add_x"]||strpos($F,"\n")?'
':'')."\n".($Ta?html_select("collation",array(""=>"(".lang(84).")")+$Ta,$M["collation"]):"");?> ';if(DB!="")echo"\n";elseif(!$_POST["add_x"]&&$_GET["db"]=="")echo"\n";echo'

';}elseif(isset($_GET["call"])){$ca=$_GET["call"];page_header(lang(161).": ".h($ca),$m);$Ye=routine($ca,(isset($_GET["callf"])?"FUNCTION":"PROCEDURE"));$Kc=array();$ee=array();foreach($Ye["fields"]as$t=>$n){if(substr($n["inout"],-3)=="OUT")$ee[$t]="@".idf_escape($n["field"])." AS ".idf_escape($n["field"]);if(!$n["inout"]||substr($n["inout"],0,2)=="IN")$Kc[]=$t;}if(!$m&&$_POST){$Ha=array();foreach($Ye["fields"]as$z=>$n){if(in_array($z,$Kc)){$X=process_input($n);if($X===false)$X="''";if(isset($ee[$z]))$h->query("SET @".idf_escape($n["field"])." = $X");}$Ha[]=(isset($ee[$z])?"@".idf_escape($n["field"]):$X);}$J=(isset($_GET["callf"])?"SELECT":"CALL")." ".idf_escape($ca)."(".implode(", ",$Ha).")";echo"

".h($J)." ".lang(30)."\n";if(!$h->multi_query($J))echo"

".error()."\n";else{$i=connect();if(is_object($i))$i->select_db(DB);do{$K=$h->store_result();if(is_object($K))select($K,$i);else echo"

".lang(162,$h->affected_rows)."\n";}while($h->next_result());if($ee)select($h->query("SELECT ".implode(", ",$ee)));}}echo'

';if($Kc){echo"\n";foreach($Kc as$z){$n=$Ye["fields"][$z];$F=$n["field"];echo"
".$c->fieldName($n);$Y=$_POST["fields"][$F];if($Y!=""){if($n["type"]=="enum")$Y=+$Y;if($n["type"]=="set")$Y=array_sum($Y);}input($n,$Y,(string)$_POST["function"][$F]);echo"\n";}echo"
\n";}echo'

';}elseif(isset($_GET["foreign"])){$b=$_GET["foreign"];$F=$_GET["name"];$M=$_POST;if($_POST&&!$m&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){if($_POST["drop"])query_redirect("ALTER TABLE ".table($b)."\nDROP ".($y=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($F),ME."table=".urlencode($b),lang(163));else{$mf=array_filter($M["source"],'strlen');ksort($mf);$If=array();foreach($mf as$z=>$X)$If[$z]=$M["target"][$z];query_redirect("ALTER TABLE ".table($b).($F!=""?"\nDROP ".($y=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($F).",":"")."\nADD FOREIGN KEY (".implode(", ",array_map('idf_escape',$mf)).") REFERENCES ".table($M["table"])." (".implode(", ",array_map('idf_escape',$If)).")".(ereg("^($Qd)\$",$M["on_delete"])?" ON DELETE $M[on_delete]":"").(ereg("^($Qd)\$",$M["on_update"])?" ON UPDATE $M[on_update]":""),ME."table=".urlencode($b),($F!=""?lang(164):lang(165)));$m=lang(166)."
$m";}}page_header(lang(167),$m,array("table"=>$b),$b);if($_POST){ksort($M["source"]);if($_POST["add"])$M["source"][]="";elseif($_POST["change"]||$_POST["change-js"])$M["target"]=array();}elseif($F!=""){$q=foreign_keys($b);$M=$q[$F];$M["source"][]="";}else{$M["table"]=$b;$M["source"]=array("");}$mf=array_keys(fields($b));$If=($b===$M["table"]?$mf:array_keys(fields($M["table"])));$Le=array_keys(array_filter(table_status('',true),'fk_support'));echo'

';if($M["db"]==""&&$M["ns"]==""){echo lang(168),': ',html_select("table",$Le,$M["table"],"this.form['change-js'].value = '1'; this.form.submit();"),'

';$x=0;foreach($M["source"]as$z=>$X){echo"","
',lang(104),'',lang(105),'
".html_select("source[".(+$z)."]",array(-1=>"")+$mf,$X,($x==count($M["source"])-1?"foreignAddRow(this);":1)),"".html_select("target[".(+$z)."]",$If,$M["target"][$z]);$x++;}echo'

',lang(86),': ',html_select("on_delete",array(-1=>"")+explode("|",$Qd),$M["on_delete"]),' ',lang(85),': ',html_select("on_update",array(-1=>"")+explode("|",$Qd),$M["on_update"]),'

';}if($F!=""){echo'';}echo'

';}elseif(isset($_GET["view"])){$b=$_GET["view"];$M=$_POST;if($_POST&&!$m){$F=trim($M["name"]);$ta=" AS\n$M[select]";$B=ME."table=".urlencode($F);$D=lang(171);if(!$_POST["drop"]&&$b==$F&&$y!="sqlite")query_redirect(($y=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($F).$ta,$B,$D);else{$Kf=$F."_adminer_".uniqid();drop_create("DROP VIEW ".table($b),"CREATE VIEW ".table($F).$ta,"DROP VIEW ".table($F),"CREATE VIEW ".table($Kf).$ta,"DROP VIEW ".table($Kf),($_POST["drop"]?substr(ME,0,-1):$B),lang(172),$D,lang(173),$b,$F);}}if(!$_POST&&$b!=""){$M=view($b);$M["name"]=$b;if(!$m)$m=$h->error;}page_header(($b!=""?lang(26):lang(174)),$m,array("table"=>$b),$b);echo'

',lang(155),':

';textarea("select",$M["select"]);echo'

';if($_GET["view"]!=""){echo'';}echo'

';}elseif(isset($_GET["event"])){$aa=$_GET["event"];$Qc=array("YEAR","QUARTER","MONTH","DAY","HOUR","MINUTE","WEEK","SECOND","YEAR_MONTH","DAY_HOUR","DAY_MINUTE","DAY_SECOND","HOUR_MINUTE","HOUR_SECOND","MINUTE_SECOND");$rf=array("ENABLED"=>"ENABLE","DISABLED"=>"DISABLE","SLAVESIDE_DISABLED"=>"DISABLE ON SLAVE");$M=$_POST;if($_POST&&!$m){if($_POST["drop"])query_redirect("DROP EVENT ".idf_escape($aa),substr(ME,0,-1),lang(175));elseif(in_array($M["INTERVAL_FIELD"],$Qc)&&isset($rf[$M["STATUS"]])){$cf="\nON SCHEDULE ".($M["INTERVAL_VALUE"]?"EVERY ".q($M["INTERVAL_VALUE"])." $M[INTERVAL_FIELD]".($M["STARTS"]?" STARTS ".q($M["STARTS"]):"").($M["ENDS"]?" ENDS ".q($M["ENDS"]):""):"AT ".q($M["STARTS"]))." ON COMPLETION".($M["ON_COMPLETION"]?"":" NOT")." PRESERVE";queries_redirect(substr(ME,0,-1),($aa!=""?lang(176):lang(177)),queries(($aa!=""?"ALTER EVENT ".idf_escape($aa).$cf.($aa!=$M["EVENT_NAME"]?"\nRENAME TO ".idf_escape($M["EVENT_NAME"]):""):"CREATE EVENT ".idf_escape($M["EVENT_NAME"]).$cf)."\n".$rf[$M["STATUS"]]." COMMENT ".q($M["EVENT_COMMENT"]).rtrim(" DO\n$M[EVENT_DEFINITION]",";").";"));}}page_header(($aa!=""?lang(178).": ".h($aa):lang(179)),$m);if(!$M&&$aa!=""){$N=get_rows("SELECT * FROM information_schema.EVENTS WHERE EVENT_SCHEMA = ".q(DB)." AND EVENT_NAME = ".q($aa));$M=reset($N);}echo'
',lang(155),'
',lang(180),'
',lang(181),'
',lang(182),' ',html_select("INTERVAL_FIELD",$Qc,$M["INTERVAL_FIELD"]),'
',lang(75),'',html_select("STATUS",$rf,$M["STATUS"]),'
',lang(94),'
 ',checkbox("ON_COMPLETION","PRESERVE",$M["ON_COMPLETION"]=="PRESERVE",lang(183)),'

';textarea("EVENT_DEFINITION",$M["EVENT_DEFINITION"]);echo'

';if($aa!=""){echo'';}echo'

';}elseif(isset($_GET["procedure"])){$ca=$_GET["procedure"];$Ye=(isset($_GET["function"])?"FUNCTION":"PROCEDURE");$M=$_POST;$M["fields"]=(array)$M["fields"];if($_POST&&!process_fields($M["fields"])&&!$m){$Kf="$M[name]_adminer_".uniqid();drop_create("DROP $Ye ".idf_escape($ca),create_routine($Ye,$M),"DROP $Ye ".idf_escape($M["name"]),create_routine($Ye,array("name"=>$Kf)+$M),"DROP $Ye ".idf_escape($Kf),substr(ME,0,-1),lang(184),lang(185),lang(186),$ca,$M["name"]);}page_header(($ca!=""?(isset($_GET["function"])?lang(187):lang(188)).": ".h($ca):(isset($_GET["function"])?lang(189):lang(190))),$m);if(!$_POST&&$ca!=""){$M=routine($ca,$Ye);$M["name"]=$ca;}$Ta=get_vals("SHOW CHARACTER SET");sort($Ta);$Ze=routine_languages();echo'

',lang(155),': ',($Ze?lang(9).": ".html_select("language",$Ze,$M["language"]):""),' ';edit_fields($M["fields"],$Ta,$Ye);if(isset($_GET["function"])){echo"
".lang(191);edit_type("returns",$M["returns"],$Ta);}echo'

';textarea("definition",$M["definition"]);echo'

';if($ca!=""){echo'';}echo'

';}elseif(isset($_GET["trigger"])){$b=$_GET["trigger"];$F=$_GET["name"];$cg=trigger_options();$bg=array("INSERT","UPDATE","DELETE");$M=(array)trigger($F)+array("Trigger"=>$b."_bi");if($_POST){if(!$m&&in_array($_POST["Timing"],$cg["Timing"])&&in_array($_POST["Event"],$bg)&&in_array($_POST["Type"],$cg["Type"])){$Pd=" ON ".table($b);$Bb="DROP TRIGGER ".idf_escape($F).($y=="pgsql"?$Pd:"");$B=ME."table=".urlencode($b);if($_POST["drop"])query_redirect($Bb,$B,lang(192));else{if($F!="")queries($Bb);queries_redirect($B,($F!=""?lang(193):lang(194)),queries(create_trigger($Pd,$_POST)));if($F!="")queries(create_trigger($Pd,$M+array("Type"=>reset($cg["Type"]))));}}$M=$_POST;}page_header(($F!=""?lang(195).": ".h($F):lang(196)),$m,array("table"=>$b));echo'
',lang(197),'',html_select("Timing",$cg["Timing"],$M["Timing"],"if (/^".preg_quote($b,"/")."_[ba][iud]$/.test(this.form['Trigger'].value)) this.form['Trigger'].value = '".js_escape($b)."_' + selectValue(this).charAt(0).toLowerCase() + selectValue(this.form['Event']).charAt(0).toLowerCase();"),'
',lang(198),'',html_select("Event",$bg,$M["Event"],"this.form['Timing'].onchange();"),'
',lang(89),'',html_select("Type",$cg["Type"],$M["Type"]),'

',lang(155),':

';textarea("Statement",$M["Statement"]);echo'

';if($F!=""){echo'';}echo'

';}elseif(isset($_GET["user"])){$ea=$_GET["user"];$Ce=array(""=>array("All privileges"=>""));foreach(get_rows("SHOW PRIVILEGES")as$M){foreach(explode(",",($M["Privilege"]=="Grant option"?"":$M["Context"]))as$db)$Ce[$db][$M["Privilege"]]=$M["Comment"];}$Ce["Server Admin"]+=$Ce["File access on server"];$Ce["Databases"]["Create routine"]=$Ce["Procedures"]["Create routine"];unset($Ce["Procedures"]["Create routine"]);$Ce["Columns"]=array();foreach(array("Select","Insert","Update","References")as$X)$Ce["Columns"][$X]=$Ce["Tables"][$X];unset($Ce["Server Admin"]["Usage"]);foreach($Ce["Tables"]as$z=>$X)unset($Ce["Databases"][$z]);$Ed=array();if($_POST){foreach($_POST["objects"]as$z=>$X)$Ed[$X]=(array)$Ed[$X]+(array)$_POST["grants"][$z];}$yc=array();$Nd="";if(isset($_GET["host"])&&($K=$h->query("SHOW GRANTS FOR ".q($ea)."@".q($_GET["host"])))){while($M=$K->fetch_row()){if(preg_match('~GRANT (.*) ON (.*) TO ~',$M[0],$C)&&preg_match_all('~ *([^(,]*[^ ,(])( *\\([^)]+\\))?~',$C[1],$od,PREG_SET_ORDER)){foreach($od as$X){if($X[1]!="USAGE")$yc["$C[2]$X[2]"][$X[1]]=true;if(ereg(' WITH GRANT OPTION',$M[0]))$yc["$C[2]$X[2]"]["GRANT OPTION"]=true;}}if(preg_match("~ IDENTIFIED BY PASSWORD '([^']+)~",$M[0],$C))$Nd=$C[1];}}if($_POST&&!$m){$Od=(isset($_GET["host"])?q($ea)."@".q($_GET["host"]):"''");if($_POST["drop"])query_redirect("DROP USER $Od",ME."privileges=",lang(199));else{$Gd=q($_POST["user"])."@".q($_POST["host"]);$oe=$_POST["pass"];if($oe!=''&&!$_POST["hashed"]){$oe=$h->result("SELECT PASSWORD(".q($oe).")");$m=!$oe;}$hb=false;if(!$m){if($Od!=$Gd){$hb=queries(($h->server_info<5?"GRANT USAGE ON *.* TO":"CREATE USER")." $Gd IDENTIFIED BY PASSWORD ".q($oe));$m=!$hb;}elseif($oe!=$Nd)queries("SET PASSWORD FOR $Gd = ".q($oe));}if(!$m){$Ve=array();foreach($Ed as$Id=>$s){if(isset($_GET["grant"]))$s=array_filter($s);$s=array_keys($s);if(isset($_GET["grant"]))$Ve=array_diff(array_keys(array_filter($Ed[$Id],'strlen')),$s);elseif($Od==$Gd){$Ld=array_keys((array)$yc[$Id]);$Ve=array_diff($Ld,$s);$s=array_diff($s,$Ld);unset($yc[$Id]);}if(preg_match('~^(.+)\\s*(\\(.*\\))?$~U',$Id,$C)&&(!grant("REVOKE",$Ve,$C[2]," ON $C[1] FROM $Gd")||!grant("GRANT",$s,$C[2]," ON $C[1] TO $Gd"))){$m=true;break;}}}if(!$m&&isset($_GET["host"])){if($Od!=$Gd)queries("DROP USER $Od");elseif(!isset($_GET["grant"])){foreach($yc as$Id=>$Ve){if(preg_match('~^(.+)(\\(.*\\))?$~U',$Id,$C))grant("REVOKE",array_keys($Ve),$C[2]," ON $C[1] FROM $Gd");}}}queries_redirect(ME."privileges=",(isset($_GET["host"])?lang(200):lang(201)),!$m);if($hb)$h->query("DROP USER $Gd");}}page_header((isset($_GET["host"])?lang(19).": ".h("$ea@$_GET[host]"):lang(117)),$m,array("privileges"=>array('',lang(50))));if($_POST){$M=$_POST;$yc=$Ed;}else{$M=$_GET+array("host"=>$h->result("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', -1)"));$M["pass"]=$Nd;if($Nd!="")$M["hashed"]=true;$yc[(DB==""||$yc?"":idf_escape(addcslashes(DB,"%_\\"))).".*"]=array();}echo'
',lang(18),'
',lang(19),'
',lang(20),' ';if(!$M["hashed"]){echo'';}echo checkbox("hashed",1,$M["hashed"],lang(202),"typePassword(this.form['pass'], this.checked);"),'
';echo"\n","\n";foreach(array(""=>"","Server Admin"=>lang(18),"Databases"=>lang(21),"Tables"=>lang(100),"Columns"=>lang(101),"Procedures"=>lang(203),)as$db=>$tb){foreach((array)$Ce[$db]as$Be=>$Xa){echo"$tb'.h($Be);$t=0;foreach($yc as$Id=>$s){$F="'grants[$t][".h(strtoupper($Be))."]'";$Y=$s[strtoupper($Be)];if($db=="Server Admin"&&$Id!=(isset($yc["*.*"])?"*.*":".*"))echo"
".lang(50)."";$t=0;foreach($yc as$Id=>$s){echo''.($Id!="*.*"?"":"*.*");$t++;}echo"
 ";elseif(isset($_GET["grant"]))echo"";else echo"";$t++;}}}echo"
\n",'

';if(isset($_GET["host"])){echo'';}echo'

';}elseif(isset($_GET["processlist"])){if(support("kill")&&$_POST&&!$m){$Yc=0;foreach((array)$_POST["kill"]as$X){if(queries("KILL ".(+$X)))$Yc++;}queries_redirect(ME."processlist=",lang(206,$Yc),$Yc||!$_POST["kill"]);}page_header(lang(73),$m);echo'
';$t=-1;foreach(process_list()as$t=>$M){if(!$t){echo"".(support("kill")?"\n";}echo"".(support("kill")?"
 ":"");foreach($M as$z=>$X)echo"".($y=="sql"?"$z":$z);echo"
".checkbox("kill[]",$M["Id"],0):"");foreach($M as$z=>$X)echo"".(($y=="sql"&&$z=="Info"&&ereg("Query|Killed",$M["Command"])&&$X!="")||($y=="pgsql"&&$z=="current_query"&&$X!="")||($y=="oracle"&&$z=="sql_text"&&$X!="")?"".shorten_utf8($X,100,"").' '.lang(207).'':nbsp($X));echo"\n";}echo'

';if(support("kill")){echo($t+1)."/".lang(208,$h->result("SELECT @@max_connections")),"

\n";}echo'

';}elseif(isset($_GET["select"])){$b=$_GET["select"];$S=table_status1($b);$w=indexes($b);$o=fields($b);$q=column_foreign_keys($b);$Kd="";if($S["Oid"]){$Kd=($y=="sqlite"?"rowid":"oid");$w[]=array("type"=>"PRIMARY","columns"=>array($Kd));}parse_str($_COOKIE["adminer_import"],$la);$We=array();$f=array();$Nf=null;foreach($o as$z=>$n){$F=$c->fieldName($n);if(isset($n["privileges"]["select"])&&$F!=""){$f[$z]=html_entity_decode(strip_tags($F),ENT_QUOTES);if(is_shortable($n))$Nf=$c->selectLengthProcess();}$We+=$n["privileges"];}list($O,$zc)=$c->selectColumnsProcess($f,$w);$Rc=count($zc)selectSearchProcess($o,$w);$Xd=$c->selectOrderProcess($o,$w);$_=$c->selectLimitProcess();$uc=($O?implode(", ",$O):"*".($Kd?", $Kd":"")).convert_fields($f,$o,$O)."\nFROM ".table($b);$_c=($zc&&$Rc?"\nGROUP BY ".implode(", ",$zc):"").($Xd?"\nORDER BY ".implode(", ",$Xd):"");if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$kg=>$M){$ta=convert_field($o[key($M)]);echo$h->result("SELECT".limit($ta?$ta:idf_escape(key($M))." FROM ".table($b)," WHERE ".where_check($kg,$o).($Z?" AND ".implode(" AND ",$Z):"").($Xd?" ORDER BY ".implode(", ",$Xd):""),1));}exit;}if($_POST&&!$m){$_g=$Z;if(is_array($_POST["check"]))$_g[]="((".implode(") OR (",array_map('where_check',$_POST["check"]))."))";$_g=($_g?"\nWHERE ".implode(" AND ",$_g):"");$ze=$mg=null;foreach($w as$v){if($v["type"]=="PRIMARY"){$ze=array_flip($v["columns"]);$mg=($O?$ze:array());break;}}foreach((array)$mg as$z=>$X){if(in_array(idf_escape($z),$O))unset($mg[$z]);}if($_POST["export"]){cookie("adminer_import","output=".urlencode($_POST["output"])."&format=".urlencode($_POST["format"]));dump_headers($b);$c->dumpTable($b,"");if(!is_array($_POST["check"])||$mg===array())$J="SELECT $uc$_g$_c";else{$ig=array();foreach($_POST["check"]as$X)$ig[]="(SELECT".limit($uc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o).$_c,1).")";$J=implode(" UNION ALL ",$ig);}$c->dumpData($b,"table",$J);exit;}if(!$c->selectEmailProcess($Z,$q)){if($_POST["save"]||$_POST["delete"]){$K=true;$ma=0;$J=table($b);$Q=array();if(!$_POST["delete"]){foreach($f as$F=>$X){$X=process_input($o[$F]);if($X!==null){if($_POST["clone"])$Q[idf_escape($F)]=($X!==false?$X:idf_escape($F));elseif($X!==false)$Q[]=idf_escape($F)." = $X";}}$J.=($_POST["clone"]?" (".implode(", ",array_keys($Q)).")\nSELECT ".implode(", ",$Q)."\nFROM ".table($b):" SET\n".implode(",\n",$Q));}if($_POST["delete"]||$Q){$Va="UPDATE";if($_POST["delete"]){$Va="DELETE";$J="FROM $J";}if($_POST["clone"]){$Va="INSERT";$J="INTO $J";}if($_POST["all"]||($mg===array()&&is_array($_POST["check"]))||$Rc){$K=queries("$Va $J$_g");$ma=$h->affected_rows;}else{foreach((array)$_POST["check"]as$X){$K=queries($Va.limit1($J,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o)));if(!$K)break;$ma+=$h->affected_rows;}}}$D=lang(210,$ma);if($_POST["clone"]&&$K&&$ma==1){$dd=last_id();if($dd)$D=lang(135," $dd");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$D,$K);}elseif(!$_POST["import"]){if(!$_POST["val"])$m=lang(211);else{$K=true;$ma=0;foreach($_POST["val"]as$kg=>$M){$Q=array();foreach($M as$z=>$X){$z=bracket_escape($z,1);$Q[]=idf_escape($z)." = ".(ereg('char|text',$o[$z]["type"])||$X!=""?$c->processInput($o[$z],$X):"NULL");}$J=table($b)." SET ".implode(", ",$Q);$zg=" WHERE ".where_check($kg,$o).($Z?" AND ".implode(" AND ",$Z):"");$K=queries("UPDATE".($Rc||$mg===array()?" $J$zg":limit1($J,$zg)));if(!$K)break;$ma+=$h->affected_rows;}queries_redirect(remove_from_uri(),lang(210,$ma),$K);}}elseif(!is_string($jc=get_file("csv_file",true)))$m=upload_error($jc);elseif(!preg_match('~~u',$jc))$m=lang(212);else{cookie("adminer_import","output=".urlencode($la["output"])."&format=".urlencode($_POST["separator"]));$K=true;$Ua=array_keys($o);preg_match_all('~(?>"[^"]*"|[^"\\r\\n]+)+~',$jc,$od);$ma=count($od[0]);begin();$hf=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));foreach($od[0]as$z=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$hf]*)$hf~",$X.$hf,$pd);if(!$z&&!array_diff($pd[1],$Ua)){$Ua=$pd[1];$ma--;}else{$Q=array();foreach($pd[1]as$t=>$Qa)$Q[idf_escape($Ua[$t])]=($Qa==""&&$o[$Ua[$t]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$Qa))));$K=insert_update($b,$Q,$ze);if(!$K)break;}}if($K)queries("COMMIT");queries_redirect(remove_from_uri("page"),lang(213,$ma),$K);queries("ROLLBACK");}}}$Bf=$c->tableName($S);if(is_ajax())ob_start();page_header(lang(32).": $Bf",$m);$Q=null;if(isset($We["insert"])){$Q="";foreach((array)$_GET["where"]as$X){if(count($q[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!ereg('[_%]',$X["val"]))))$Q.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$c->selectLinks($S,$Q);if(!$f)echo"

".lang(214).($o?".":": ".error())."\n";else{echo"

\n","
";hidden_fields_get();echo(DB!=""?''.(isset($_GET["ns"])?'':""):"");echo'',"
\n";$c->selectColumnsPrint($O,$f);$c->selectSearchPrint($Z,$f,$w);$c->selectOrderPrint($Xd,$f,$w);$c->selectLimitPrint($_);$c->selectLengthPrint($Nf);$c->selectActionPrint($w);echo"
\n";$H=$_GET["page"];if($H=="last"){$sc=$h->result("SELECT COUNT(*) FROM ".table($b).($Z?" WHERE ".implode(" AND ",$Z):""));$H=floor(max(0,$sc-1)/$_);}$J=$c->selectQueryBuild($O,$Z,$zc,$Xd,$_,$H);if(!$J)$J="SELECT".limit((+$_&&$zc&&$Rc&&$y=="sql"?"SQL_CALC_FOUND_ROWS ":"").$uc,($Z?"\nWHERE ".implode(" AND ",$Z):"").$_c,($_!=""?+$_:null),($H?$_*$H:0),"\n");echo$c->selectQuery($J);$K=$h->query($J);if(!$K)echo"

".error()."\n";else{if($y=="mssql"&&$H)$K->seek($_*$H);$Mb=array();echo"

\n";$N=array();while($M=$K->fetch_assoc()){if($H&&$y=="oracle")unset($M["RNUM"]);$N[]=$M;}if($_GET["page"]!="last")$sc=(+$_&&$zc&&$Rc?($y=="sql"?$h->result(" SELECT FOUND_ROWS()"):$h->result("SELECT COUNT(*) FROM ($J) x")):count($N));if(!$N)echo"

".lang(82)."\n";else{$_a=$c->backwardKeys($b,$Bf);echo"\n","".(!$zc&&$O?"":"\n";if(is_ajax()){if($_%2==1&&$H%2==1)odd();ob_end_clean();}foreach($c->rowDescriptions($N,$q)as$E=>$M){$jg=unique_array($N[$E],$w);if(!$jg){$jg=array();foreach($N[$E]as$z=>$X){if(!preg_match('~^(COUNT\\((\\*|(DISTINCT )?`(?:[^`]|``)+`)\\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\\(`(?:[^`]|``)+`\\))$~',$z))$jg[$z]=$X;}}$kg="";foreach($jg as$z=>$X){if(strlen($X)>64){$z="MD5(".(strpos($z,'(')?$z:idf_escape($z)).")";$X=md5($X);}$kg.="&".($X!==null?urlencode("where[".bracket_escape($z)."]")."=".urlencode($X):"null%5B%5D=".urlencode($z));}echo"".(!$zc&&$O?"":"\n";}if(is_ajax())exit;echo"
".lang(215)."");$Dd=array();$xc=array();reset($O);$Ie=1;foreach($N[0]as$z=>$X){if($z!=$Kd){$X=$_GET["columns"][key($O)];$n=$o[$O?($X?$X["col"]:current($O)):$z];$F=($n?$c->fieldName($n,$Ie):"*");if($F!=""){$Ie++;$Dd[$z]=$F;$e=idf_escape($z);$Gc=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($z);$tb="&desc%5B0%5D=1";echo'','';echo(!$O||$X?apply_sql_function($X["fun"],$F):h(current($O)))."";echo"";}$xc[$z]=$X["fun"];next($O);}}$jd=array();if($_GET["modify"]){foreach($N as$M){foreach($M as$z=>$X)$jd[$z]=max($jd[$z],min(40,strlen(utf8_decode($X))));}}echo($_a?"".lang(216):"")."
".checkbox("check[]",substr($kg,1),in_array(substr($kg,1),(array)$_POST["check"]),"","this.form['all'].checked = false; formUncheck('all-page');").($Rc||information_schema(DB)?"":" ".lang(215).""));foreach($M as$z=>$X){if(isset($Dd[$z])){$n=$o[$z];if($X!=""&&(!isset($Mb[$z])||$Mb[$z]!=""))$Mb[$z]=(is_mail($X)?$Dd[$z]:"");$A="";$X=$c->editVal($X,$n);if($X!==null){if(ereg('blob|bytea|raw|file',$n["type"])&&$X!="")$A=ME.'download='.urlencode($b).'&field='.urlencode($z).$kg;if($X==="")$X=" ";elseif($Nf!=""&&is_shortable($n))$X=shorten_utf8($X,max(0,+$Nf));else$X=h($X);if(!$A){foreach((array)$q[$z]as$p){if(count($q[$z])==1||end($p["source"])==$z){$A="";foreach($p["source"]as$t=>$mf)$A.=where_link($t,$p["target"][$t],$N[$E][$mf]);$A=($p["db"]!=""?preg_replace('~([?&]db=)[^&]+~','\\1'.urlencode($p["db"]),ME):ME).'select='.urlencode($p["table"]).$A;if(count($p["source"])==1)break;}}}if($z=="COUNT(*)"){$A=ME."select=".urlencode($b);$t=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$jg))$A.=where_link($t++,$W["col"],$W["val"],$W["op"]);}foreach($jg as$Vc=>$W)$A.=where_link($t++,$Vc,$W);}}if(!$A&&($A=$c->selectLink($M[$z],$n))===null){if(is_mail($M[$z]))$A="mailto:$M[$z]";if($Fe=is_url($M[$z]))$A=($Fe=="http"&&$ba?$M[$z]:"$Fe://www.adminer.org/redirect/?url=".urlencode($M[$z]));}$u=h("val[$kg][".bracket_escape($z)."]");$Y=$_POST["val"][$kg][bracket_escape($z)];$Bc=h($Y!==null?$Y:$M[$z]);$nd=strpos($X,"...");$Ib=is_utf8($X)&&$N[$E][$z]==$M[$z]&&!$xc[$z];$Mf=ereg('text|lob',$n["type"]);echo(($_GET["modify"]&&$Ib)||$Y!==null?"".($Mf?"":""):"".$c->selectVal($X,$A,$n));}}if($_a)echo"";$c->backwardKeysPrint($_a,$N[$E]);echo"
\n",(!$zc&&$O?"":"\n");}if(($N||$H)&&!is_ajax()){$Wb=true;if($_GET["page"]!="last"&&+$_&&!$Rc&&($sc>=$_||$H)){$sc=found_rows($S,$Z);if($sc$_||$H)){echo"

";$rd=($sc===false?$H+(count($N)>=$_?2:1):floor(($sc-1)/$_));echo'".lang(218).":",pagination(0,$H).($H>5?" ...":"");for($t=max(1,$H-4);$t0){echo($H+5<$rd?" ...":""),($Wb&&$sc!==false?pagination($rd,$H):" ".lang(219)."");}echo(($sc===false?count($N)+1:$sc-$H*$_)>$_?' '.lang(221).'':'');}echo"

\n",($sc!==false?"(".($Wb?"":"~ ").lang(119,$sc).") ":""),checkbox("all",1,0,lang(222))."\n";if($c->selectCommandPrint()){echo'

',lang(30),'
';}$qc=$c->dumpFormat();foreach((array)$_GET["columns"]as$e){if($e["fun"]){unset($qc['sql']);break;}}if($qc){print_fieldset("export",lang(111));$fe=$c->dumpOutput();echo($fe?html_select("output",$fe,$la["output"])." ":""),html_select("format",$qc,$la["format"])," \n","\n";}}if($c->selectImportPrint()){print_fieldset("import",lang(51),!$N);echo" ",html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$la["format"],1);echo" ","\n";}$c->selectEmailPrint(array_filter($Mb,'strlen'),$f);echo"

\n","
\n";}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$qf=isset($_GET["status"]);page_header($qf?lang(75):lang(74));$ug=($qf?show_status():show_variables());if(!$ug)echo"

".lang(82)."\n";else{echo"\n";foreach($ug as$z=>$X){echo"","
".h($z)."","".nbsp($X);}echo"
\n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$zf=array("Data_length"=>0,"Index_length"=>0,"Data_free"=>0);foreach(table_status()as$F=>$S){$u=js_escape($F);json_row("Comment-$u",nbsp($S["Comment"]));if(!is_view($S)){foreach(array("Engine","Collation")as$z)json_row("$z-$u",nbsp($S[$z]));foreach($zf+array("Auto_increment"=>0,"Rows"=>0)as$z=>$X){if($S[$z]!=""){$X=number_format($S[$z],0,'.',lang(8));json_row("$z-$u",($z=="Rows"&&$X&&$S["Engine"]==($of=="pgsql"?"table":"InnoDB")?"~ $X":$X));if(isset($zf[$z]))$zf[$z]+=($S["Engine"]!="InnoDB"||$z!="Data_free"?$S[$z]:0);}elseif(array_key_exists($z,$S))json_row("$z-$u");}}}foreach($zf as$z=>$X)json_row("sum-$z",number_format($X,0,'.',lang(8)));json_row("");}elseif($_GET["script"]=="kill")$h->query("KILL ".(+$_POST["kill"]));else{foreach(count_tables($c->databases())as$l=>$X)json_row("tables-".js_escape($l),$X);json_row("");}exit;}else{$Hf=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($Hf&&!$m&&!$_POST["search"]){$K=true;$D="";if($y=="sql"&&count($_POST["tables"])>1&&($_POST["drop"]||$_POST["truncate"]||$_POST["copy"]))queries("SET foreign_key_checks = 0");if($_POST["truncate"]){if($_POST["tables"])$K=truncate_tables($_POST["tables"]);$D=lang(223);}elseif($_POST["move"]){$K=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(224);}elseif($_POST["copy"]){$K=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(225);}elseif($_POST["drop"]){if($_POST["views"])$K=drop_views($_POST["views"]);if($K&&$_POST["tables"])$K=drop_tables($_POST["tables"]);$D=lang(226);}elseif($y!="sql"){$K=($y=="sqlite"?queries("VACUUM"):apply_queries("VACUUM".($_POST["optimize"]?"":" ANALYZE"),$_POST["tables"]));$D=lang(227);}elseif(!$_POST["tables"])$D=lang(7);elseif($K=queries(($_POST["optimize"]?"OPTIMIZE":($_POST["check"]?"CHECK":($_POST["repair"]?"REPAIR":"ANALYZE")))." TABLE ".implode(", ",array_map('idf_escape',$_POST["tables"])))){while($M=$K->fetch_assoc())$D.="".h($M["Table"]).": ".h($M["Msg_text"])."
";}queries_redirect(substr(ME,0,-1),$D,$K);}page_header(($_GET["ns"]==""?lang(21).": ".h(DB):lang(228).": ".h($_GET["ns"])),$m,true);if($c->homepage()){if($_GET["ns"]!==""){echo"

".lang(229)."

\n";$Gf=tables_list();if(!$Gf)echo"

".lang(7)."\n";else{echo"

\n","

".lang(230).": \n";if($_POST["search"]&&$_POST["query"]!="")search_tables();echo"\n",'\n";foreach($Gf as$F=>$U){$vg=($U!==null&&!eregi("table",$U));echo'
',''.lang(100),''.lang(231),''.lang(79),''.lang(232),''.lang(233),''.lang(234),''.lang(92),''.lang(235),(support("comment")?''.lang(94):''),"
'.checkbox(($vg?"views[]":"tables[]"),$F,in_array($F,$Hf,true),"","formUncheck('check-all');"),''.h($F).'';if($vg){echo''.lang(99).'','?';}else{foreach(array("Engine"=>array(),"Collation"=>array(),"Data_length"=>array("create",lang(27)),"Index_length"=>array("indexes",lang(103)),"Data_free"=>array("edit",lang(28)),"Auto_increment"=>array("auto_increment=1&create",lang(27)),"Rows"=>array("select",lang(24)),)as$z=>$A)echo($A?"?":" ");}echo(support("comment")?" ":"");}echo"
 ".lang(208,count($Gf)),"".nbsp($y=="sql"?$h->result("SELECT @@storage_engine"):""),"".nbsp(db_collation(DB,collations()));foreach(array("Data_length","Index_length","Data_free")as$z)echo" ";echo"
\n","\n";if(!information_schema(DB)){echo"

".(ereg('^(sql|sqlite|pgsql)$',$y)?($y!="sqlite"?" ":"")." ":"").($y=="sql"?" ":"")." \n";$k=(support("scheme")?schemas():$c->databases());if(count($k)!=1&&$y!="sqlite"){$l=(isset($_POST["target"])?$_POST["target"]:(support("scheme")?$_GET["ns"]:DB));echo"

".lang(241).": ",($k?html_select("target",$k,$l):'')," ",(support("copy")?" ":""),"\n";}echo"\n";}echo"

\n";}echo'

'.lang(145)."\n";if(support("view"))echo''.lang(174)."\n";if(support("routine")){echo"

".lang(114)."

\n";$af=routines();if($af){echo"\n",'\n";odd('');foreach($af as$M){echo'','
'.lang(155).''.lang(89).''.lang(191)." 
'.h($M["ROUTINE_NAME"]).'',''.h($M["ROUTINE_TYPE"]),''.h($M["DTD_IDENTIFIER"]),''.lang(106)."";}echo"
\n";}echo'

'.(support("procedure")?''.lang(190).' ':'').''.lang(189)."\n";}if(support("event")){echo"

".lang(115)."

\n";$N=get_rows("SHOW EVENTS");if($N){echo"\n","\n";foreach($N as$M){echo"","
".lang(155)."".lang(244)."".lang(180)."".lang(181)."
".h($M["Name"]),"".($M["Execute at"]?lang(245)."".$M["Execute at"]:lang(182)." ".$M["Interval value"]." ".$M["Interval field"]."$M[Starts]"),"$M[Ends]",''.lang(106).'';}echo"
\n";$Vb=$h->result("SELECT @@event_scheduler");if($Vb&&$Vb!="ON")echo"

event_scheduler: ".h($Vb)."\n";}echo'

'.lang(179)."\n";}if($Gf)echo"\n";}}}page_footer();