Strings Binar

\0\0\0` \0
\0\n @\0
\0`E
tvM'
b0\0
\0");}elseif($_GET["file"]=="default.css"){header("Content-Type: text/css; charset=utf-8");echo
lzw_decompress("\n1
4vb0
:6T\rc
VNFS%~
4'7k
'g\rFB\ry
T7SS
>!\0Z
\"*nS
\0@P\"
3\$4
C YA
}UaHV%G
<A\0\\
w0t6
%MR%
Q<P<:
QH\n
\"+z
4lK{
\na@

ov0
zAYO(
@x&n
{GEb
{\$**
YHZI
.*9t
c=
  a
[\rX
\n+E
@g\"
CI\$
*vuD
&\r\"
S\$)e
\$]Z
7E1k
\$tx\rB
{gi/\"
a|#,Z
\ro=
rO-^
rnO\r

\rc

i\0-\n
J|\r
1>
  h
k\rQ*
(3 \n
!1&7
rU&2f
*Ra%
\\
  i
&Pu*
\$p&
;\rn
pL\nt
3;6r
'h35
2q+6
O7sC\"pm8
m\n@e0
\"11
");}elseif($_GET["file"]=="functions.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress("f:
At^ s
tf6e
q]\"
Pi2IN
*(=2
]`pX9
 \\8
w\"'
X9ES|
Xa=No4t7
\r)8H
44Pc=\n
QN\r
j:9^
!x]\0
HX:W
cbf6I
`NoK
zWXd
3&\0
t{mY
@t\r
I'KT
I\$q%
[R\0n
Jy\r
p\\H
aejk
B1\"
@G 9
4KIl
)-'#
@jO!
)E`\0\n
T']W
Dh\n
\r]9
a2Lm

\"]8
\\K/
e}\rjC
y%
  H
\$sE
\r@&\r
@h'A
0YDh'
W:[=

.YI
\nWp
h\nF
mb\$
VHpn
%l]'
\0k
{\roL
`O q
gk lv
.i~4

|u2N;Bn<
J1b%
7D\0^


p\n
+ Xr
2G\\{
.#%\$K
\$Cr
--H|
1/
  d\"
\0O6R8|S|+
\re(
\r\"8
mNTQ
]jk+1
S\[email protected]
TUFq
;g\\
\"DQ
@\r&+
Db\r1
PL\0
\"O>
C<tJ
\"V]`
w<1f
nl\0
'\$^S
f.eP\r
s)Uj
uT
  5G0
5r<vzl
YiqMD
`{\0r

\n\0
, u;
Q|e/|
HbQs
4\0z
<2\"
24\"qX
\n\0
'1f<m
pPD>!
G\0[a
\0ZK
\$w/
<'%x
h`Ev\\
<xY~
Fq9Tl
V#q-
+rTtg
n}BXZw<,
^\r1
@ly B
\$=}
[~ Y
Yi2s
Y~'Amq
=G4vG\0R
|L\$
    D
GRb!r
1Ki,|

\"q^
\0dO
\nFg
LZny<
T\$c
_')j
Nr\0
\$oj7Z&
Fnh\"
\nFl
a@#d
\$+Q5\n
8\$-
'FI+
\"\$9
!4=`
T(}S
*C5oZ^O
n=
  \"
RGKe
C\0D+(
7Qra
`548
D1@\\
6!^9@c
%@/@m
*\$&?!
n\nHCH{I\"
1O9R
>)=\$Z'
a!#U
e^ia
`fd0
P\"(
(r1j\rX1i
\0p2
-,@%Z
XRCiJ
!3#Y
     nc|@

`cC}(
_2 8M
<
 fm
0yS<
:\0-
I2\0
sb\",
w4\$(
o\r8
 =@7
\$bc\n\\
\".h
\0@9
ogv3
\$1I
5lkg
@d,\n@
eVAr
eQ\"
yR%eJ\"4%[
V\"[
ui%<
Q`T&
\0\n%a\\
!\$L
[:HD\0
Vu0a
9\n`
+Ldl
ogIu1
\$2{
 @D&
41\$
&ze)
Y;z]
T\0.
M_\n
/S\"
 Sm=\\K
\"7Q
\$aE
>MiV
DA^d
fQ\n
r:s)1
S+dF
k^6\0
fi&V>L
la|@
\n:X
\nL&
6|Pe
\"f(l
kP\n
&Nzb\r3
LeoP
ut!^
\"U]
\0\"
\"vF
lq2K
'0um
#N\$0
{\0)
g0a~
I#\0v
\nx<
sd3|
c\">A
}p
  z
\0Z5
TU\"
?h6m
kGr'z
Kq\\*_gW2
");}elseif($_GET["file"]=="jush.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress("v0
J(:=
x8EN
GFmY
8o7\n\r
4\r#`
\r.D`
1(W0
E:68n+
4Z{p\\AU
L7
  U
wuYh
\r#0P
\\jF
h{\"s\n
pdW
\0)\"
O\nR8!
\"Q|9
:z1Uf
e5#U@iUG
;gxL
9\n\nAl~H
\r}b/
j!\r
)TZ0E9M
8PE5-
psK0\r
'\$cL
MpY&
`83B-9F@
\r.y
\\\n
9`G[
~xsL
Xwy\n
!4\"
BhA0
J2P@
oq\0/Q\0of*
Y\0p\\
y\no\0
\rog
15\r
\$M\r
=\n0
x\"p
Zelf\0
Z), ,^
8%2>
NxK:\n
&W/>
h6
  @
O:Yh^
j>7`z
j\rg
i2I\$\"@
ys\$
\$\0
QOf1
\"~0
\"@Z
e3Cu6
Cq#C
DT_D
27#w7
l-1cP
5\0P!`\\\r@
-\0RR
tFH8
kMKCRf@w4B
2
 ,\"
-WX\r
t&7@
0o<>
5<52B
k!>\r
(#mJ
]3ohuJ
@iUzM
H*BD.7
XCV
X\0Q_D]}t
ZR\0
V2O-
\\\0
\rwe
cRIdBOk
+L

OXpf
\n\r
npY;
i2,q
/}{4J

Kuz @
\$\n
J{w8
<i-u
l<o=-
%C=]
\\+>)3
3qmu2
S%6\"IT5

Tuv
\"&Vi
\"uiT

?\r
\"T{[
\nlh@l
{ZVF
p9zK
O9di
==\r.
Zi%P
L`pR0
P+\"
L\nbS
QD(V`.1
\0Q\$
jkzM
1- 3h
<JB[
8\n\0U
\$i#
Ts#]
lo#}
8\nr
:)DY\n*D
2{dZ)A
\$r#
\"P'
i\"p
)\0.
R\0L
VO3o
iR\n
\0\\
1P30(\r
))\0
e7\0
,#\0vU@9
m`\\
']=I
a<RP
\0E@i
\$
  B
hO\0
BcCi
l.C\$
&Cj3
z9Gp
\0i
   \$D
zt[')
h{&Jz
^Y\\Rmn
 Nn*g
\$z4
32\0S
U\$E
<UH

UJuS
g)XDZK
x@d&

U\$
wKDR
X\0+
+QIj\n
v@{c
U5 s
 Jv]
,/+:
iKA

#CK`
lM_^z
@>NB
Z l\r(
\\bD
Z-wo
-UMJc*
\\Q8
\" p
i.Joc
O\\\0
:F\"8
i,Pc
1\0(
0<1\r
2d\"
B\rr
\"?v
.\".\0?w
+\0y
 8@/
g\n8
\n`S
:\0N
Vg(1
\\s

~hBW
c[ys
NcCX
\0^os
B\\QkO[:
2=k`
lHiA
`Gby
;[*_
lH{(;Uo
rpc,
aZCk
\nQQ
p2mP+ d
aX8&,=
\$\r
n`H\\t\"
0@6l
71ym
&~r
   (
/Fz@8
&Rh4
\n\0[
p*}Q
1o8Z
HzW{
}D\$
?xw}
v3R=
m\n\\
H\n^
}\0#
L\n9
#|F8
&{VN
@\nO
H\nh
r\$/
)<#P
p)?#
\niL
N@\$
\$B?0
pe#7
AV?h
\\Au
\"\0
\0ps
DPvA\\
      #
@A\0
\$\0
T+I8
\0\nO
\$!h
|*1\0
dAov
BO\n
q\r?m
Eq\n
\\\$
1
 B;c
o?;\0K
\$>l
\nT^pg
\0*C
4d@(D
@>\$
Av?lnos3
|\"pU
,\\0
qgA6>
SE@#
*\0i\n\\-`*\0q\n\\e
@`>D
*\0e!
3EIL
Gg\n
\"#7
?
 m\r
\\KJ8\r
-2
  4U

C(\$
:NI(J\0
\"w\0
\r[;
\nQ5
+`a+
O.\"J
!\"J
\n`+Aw*
Lg1h[
9Lz?
h>\0>
<:C+
ja+\0
%Qf ;K
MPn3I:f
D <L
^fqd
s7(|
tM.]HS
;7yC
~\rl
XY9A
=4K\n
*sI&
>\rX\r!\0\n
BsVM63
Q9z%`
=CRr
\"KB3
)`Oj+

(
 &v9
[.pGc K#?
2\0k6)
GmOFV
UB`JsV
0
 _B
)A
  ~\r
Q\\`rX
\ra\"
&bUQ
8\0E
\0<\0
\0,J
?B.<
,O\r,
@1\0
/]04
K\nC
9/:WR
Sv^ 0
MD%3
3Id\n
#tPq5h{
\"1M'
hQEN
Qe@\0;
\r<e
eS}Om
4U\rR==
J`P!t8
5\"S

5qS
\0006K
ua .
X\rF
<mXj
\00074
&83&a+
+8+Uz
Z\0D5F
U\rTMZ
}V7T0B
U`4\n
\rw+
T.\$m
;@7m
\ri0
a[x9
    H
HT!X
X\ry
3N=5
8<IGPB
;+\"C
UUo[i`
Yg^5
\">\ra
?:\r
M[7;[v{
yh\0h@
1T0m
Tmq\$
\rTr
^d!5`7
PsN6
MXQ 5
YKqs
s-\0
oM@w\0QyoK
Puo5
\n(%
@>
  R
=E\0
+
 Uj
s]h't
QUUuD
l]AAf
zPTuUQY
Jen5
s=Hu
uuH5n
UPZMN
QmobF
]i\\
G\rT
z\n=:
\rh*s
7(K&
\\\rX
8\$m
WHVC\\5@
P\0\"F
sk(7
Uc}A
C8^!P}
\\-\rSlX{s
ATAW\r
6-_1O
o?7>\n
]E\"JVJe~
\0V
   .\n
S/Dk
");}else{header("Content-Type: image/gif");switch($_GET["file"]){case"plus.gif":echo"GIF89a
\0001
\0\0
\0\0\0!
\0\0
\0,\0\0\0\0
\0;";break;case"cross.gif":echo"GIF89a
\0001
\0\0
\0\0\0!
\0\0
\0,\0\0\0\0
#\na
Fo~y
6]\0\0;";break;case"up.gif":echo"GIF89a
\0001
\0\0
\0\0\0!
\0\0
\0,\0\0\0\0
QN\n
\0;";break;case"down.gif":echo"GIF89a
\0001
\0\0
\0\0\0!
\0\0
\0,\0\0\0\0
\0;";break;case"arrow.gif":echo"GIF89a
\0\n\0
\0\0
\0\0
\0,\0\0\0\0
\0\n\0\0
\0\0;";break;}}exit;}function
connection(){global$g;return$g;}function
adminer(){global$c;return$c;}function
idf_unescape($Kc){$id=substr($Kc,-1);return
str_replace($id.$id,$id,substr($Kc,1,-1));}function
escape_string($X){return
substr(q($X),1,-1);}function
number($X){return
preg_replace('~[^0-9]+~','',$X);}function
remove_slashes($Qe,$oc=false){if(get_magic_quotes_gpc()){while(list($z,$X)=each($Qe)){foreach($X
as$bd=>$W){unset($Qe[$z][$bd]);if(is_array($W)){$Qe[$z][stripslashes($bd)]=$W;$Qe[]=&$Qe[$z][stripslashes($bd)];}else$Qe[$z][stripslashes($bd)]=($oc?$W:stripslashes($W));}}}}function
bracket_escape($Kc,$_a=false){static$pg=array(':'=>':1',']'=>':2','['=>':3');return
strtr($Kc,($_a?array_flip($pg):$pg));}function
charset($g){return(version_compare($g->server_info,"5.5.3")>=0?"utf8mb4":"utf8");}function
h($Jf){return
str_replace("\0","&#0;",htmlspecialchars($Jf,ENT_QUOTES,'utf-8'));}function
nbsp($Jf){return(trim($Jf)!=""?h($Jf):"&nbsp;");}function
nl_br($Jf){return
str_replace("\n","<br>",$Jf);}function
checkbox($F,$Y,$Na,$fd="",$be="",$Ra=""){$K="<input type='checkbox' name='$F' value='".h($Y)."'".($Na?" checked":"").($be?' onclick="'.h($be).'"':'').">";return($fd!=""||$Ra?"<label".($Ra?" class='$Ra'":"").">$K".h($fd)."</label>":$K);}function
optionlist($fe,$uf=null,$Hg=false){$K="";foreach($fe
as$bd=>$W){$ge=array($bd=>$W);if(is_array($W)){$K.='<optgroup label="'.h($bd).'">';$ge=$W;}foreach($ge
as$z=>$X)$K.='<option'.($Hg||is_string($z)?' value="'.h($z).'"':'').(($Hg||is_string($z)?(string)$z:$X)===$uf?' selected':'').'>'.h($X);if(is_array($W))$K.='</optgroup>';}return$K;}function
html_select($F,$fe,$Y="",$ae=true){if($ae)return"<select name='".h($F)."'".(is_string($ae)?' onchange="'.h($ae).'"':"").">".optionlist($fe,$Y)."</select>";$K="";foreach($fe
as$z=>$X)$K.="<label><input type='radio' name='".h($F)."' value='".h($z)."'".($z==$Y?" checked":"").">".h($X)."</label>";return$K;}function
select_input($wa,$fe,$Y="",$De=""){return($fe?"<select$wa><option value=''>$De".optionlist($fe,$Y,true)."</select>":"<input$wa size='10' value='".h($Y)."' placeholder='$De'>");}function
confirm(){return" onclick=\"return confirm('".lang(0)."');\"";}function
print_fieldset($Ic,$nd,$Pg=false,$be=""){echo"<fieldset><legend><a href='#fieldset-$Ic' onclick=\"".h($be)."return !toggle('fieldset-$Ic');\">$nd</a></legend><div id='fieldset-$Ic'".($Pg?"":" class='hidden'").">\n";}function
bold($Ga,$Ra=""){return($Ga?" class='active $Ra'":($Ra?" class='$Ra'":""));}function
odd($K=' class="odd"'){static$v=0;if(!$K)$v=-1;return($v++%2?$K:'');}function
js_escape($Jf){return
addcslashes($Jf,"\r\n'\\/");}function
json_row($z,$X=null){static$pc=true;if($pc)echo"{";if($z!=""){echo($pc?"":",")."\n\t\"".addcslashes($z,"\r\n\"\\/").'": '.($X!==null?'"'.addcslashes($X,"\r\n\"\\/").'"':'undefined');$pc=false;}else{echo"\n}\n";$pc=true;}}function
ini_bool($Oc){$X=ini_get($Oc);return(preg_match('~^(on|true|yes)$~i',$X)||(int)$X);}function
sid(){static$K;if($K===null)$K=(SID&&!($_COOKIE&&ini_bool("session.use_cookies")));return$K;}function
set_password($Mg,$O,$V,$_e){$_SESSION["pwds"][$Mg][$O][$V]=($_COOKIE["adminer_key"]&&is_string($_e)?array(encrypt_string($_e,$_COOKIE["adminer_key"])):$_e);}function
get_password(){$K=get_session("pwds");if(is_array($K))$K=($_COOKIE["adminer_key"]?decrypt_string($K[0],$_COOKIE["adminer_key"]):false);return$K;}function
q($Jf){global$g;return$g->quote($Jf);}function
get_vals($I,$d=0){global$g;$K=array();$J=$g->query($I);if(is_object($J)){while($L=$J->fetch_row())$K[]=$L[$d];}return$K;}function
get_key_vals($I,$h=null,$fg=0){global$g;if(!is_object($h))$h=$g;$K=array();$h->timeout=$fg;$J=$h->query($I);$h->timeout=0;if(is_object($J)){while($L=$J->fetch_row())$K[$L[0]]=$L[1];}return$K;}function
get_rows($I,$h=null,$m="<p class='error'>"){global$g;$eb=(is_object($h)?$h:$g);$K=array();$J=$eb->query($I);if(is_object($J)){while($L=$J->fetch_assoc())$K[]=$L;}elseif(!$J&&!is_object($h)&&$m&&defined("PAGE_HEADER"))echo$m.error()."\n";return$K;}function
unique_array($L,$x){foreach($x
as$w){if(preg_match("~PRIMARY|UNIQUE~",$w["type"])){$K=array();foreach($w["columns"]as$z){if(!isset($L[$z]))continue
2;$K[$z]=$L[$z];}return$K;}}}function
escape_key($z){if(preg_match('(^([\w(]+)('.str_replace("_",".*",preg_quote(idf_escape("_"))).')([ \w)]+)$)',$z,$C))return$C[1].idf_escape(idf_unescape($C[2])).$C[3];return
idf_escape($z);}function
where($Z,$o=array()){global$g,$y;$K=array();foreach((array)$Z["where"]as$z=>$X){$z=bracket_escape($z,1);$d=escape_key($z);$K[]=$d.(($y=="sql"&&preg_match('~^[0-9]*\\.[0-9]*$~',$X))||$y=="mssql"?" LIKE ".q(addcslashes($X,"%_\\")):" = ".unconvert_field($o[$z],q($X)));if($y=="sql"&&preg_match('~char|text~',$o[$z]["type"])&&preg_match("~[^ -@]~",$X))$K[]="$d = ".q($X)." COLLATE ".charset($g)."_bin";}foreach((array)$Z["null"]as$z)$K[]=escape_key($z)." IS NULL";return
implode(" AND ",$K);}function
where_check($X,$o=array()){parse_str($X,$Ma);remove_slashes(array(&$Ma));return
where($Ma,$o);}function
where_link($v,$d,$Y,$ce="="){return"&where%5B$v%5D%5Bcol%5D=".urlencode($d)."&where%5B$v%5D%5Bop%5D=".urlencode(($Y!==null?$ce:"IS NULL"))."&where%5B$v%5D%5Bval%5D=".urlencode($Y);}function
convert_fields($e,$o,$N=array()){$K="";foreach($e
as$z=>$X){if($N&&!in_array(idf_escape($z),$N))continue;$ua=convert_field($o[$z]);if($ua)$K.=", $ua AS ".idf_escape($z);}return$K;}function
cookie($F,$Y,$qd=2592000){global$ba;$te=array($F,(preg_match("~\n~",$Y)?"":$Y),($qd?time()+$qd:0),preg_replace('~\\?.*~','',$_SERVER["REQUEST_URI"]),"",$ba);if(version_compare(PHP_VERSION,'5.2.0')>=0)$te[]=true;return
call_user_func_array('setcookie',$te);}function
restart_session(){if(!ini_bool("session.use_cookies"))session_start();}function
stop_session(){if(!ini_bool("session.use_cookies"))session_write_close();}function&get_session($z){return$_SESSION[$z][DRIVER][SERVER][$_GET["username"]];}function
set_session($z,$X){$_SESSION[$z][DRIVER][SERVER][$_GET["username"]]=$X;}function
auth_url($Mg,$O,$V,$k=null){global$Eb;preg_match('~([^?]*)\\??(.*)~',remove_from_uri(implode("|",array_keys($Eb))."|username|".($k!==null?"db|":"").session_name()),$C);return"$C[1]?".(sid()?SID."&":"").($Mg!="server"||$O!=""?urlencode($Mg)."=".urlencode($O)."&":"")."username=".urlencode($V).($k!=""?"&db=".urlencode($k):"").($C[2]?"&$C[2]":"");}function
is_ajax(){return($_SERVER["HTTP_X_REQUESTED_WITH"]=="XMLHttpRequest");}function
redirect($B,$D=null){if($D!==null){restart_session();$_SESSION["messages"][preg_replace('~^[^?]*~','',($B!==null?$B:$_SERVER["REQUEST_URI"]))][]=$D;}if($B!==null){if($B=="")$B=".";header("Location: $B");exit;}}function
query_redirect($I,$B,$D,$Ye=true,$cc=true,$ic=false,$eg=""){global$g,$m,$c;if($cc){$Ff=microtime(true);$ic=!$g->query($I);$eg=format_time($Ff);}$Ef="";if($I)$Ef=$c->messageQuery($I,$eg);if($ic){$m=error().$Ef;return
false;}if($Ye)redirect($B,$D.$Ef);return
true;}function
queries($I){global$g;static$Te=array();static$Ff;if(!$Ff)$Ff=microtime(true);if($I===null)return
array(implode("\n",$Te),format_time($Ff));$Te[]=(preg_match('~;$~',$I)?"DELIMITER ;;\n$I;\nDELIMITER ":$I).";";return$g->query($I);}function
apply_queries($I,$S,$Yb='table'){foreach($S
as$Q){if(!queries("$I ".$Yb($Q)))return
false;}return
true;}function
queries_redirect($B,$D,$Ye){list($Te,$eg)=queries(null);return
query_redirect($Te,$B,$D,$Ye,false,!$Ye,$eg);}function
format_time($Ff){return
lang(1,max(0,microtime(true)-$Ff));}function
remove_from_uri($se=""){return
substr(preg_replace("~(?<=[?&])($se".(SID?"":"|".session_name()).")=[^&]*&~",'',"$_SERVER[REQUEST_URI]&"),0,-1);}function
pagination($G,$nb){return" ".($G==$nb?$G+1:'<a href="'.h(remove_from_uri("page").($G?"&page=$G".($_GET["next"]?"&next=".urlencode($_GET["next"]):""):"")).'">'.($G+1)."</a>");}function
get_file($z,$ub=false){$mc=$_FILES[$z];if(!$mc)return
null;foreach($mc
as$z=>$X)$mc[$z]=(array)$X;$K='';foreach($mc["error"]as$z=>$m){if($m)return$m;$F=$mc["name"][$z];$mg=$mc["tmp_name"][$z];$fb=file_get_contents($ub&&preg_match('~\\.gz$~',$F)?"compress.zlib://$mg":$mg);if($ub){$Ff=substr($fb,0,3);if(function_exists("iconv")&&preg_match("~^\xFE\xFF|^\xFF\xFE~",$Ff,$ef))$fb=iconv("utf-16","utf-8",$fb);elseif($Ff=="\xEF\xBB\xBF")$fb=substr($fb,3);$K.=$fb."\n\n";}else$K.=$fb;}return$K;}function
upload_error($m){$_d=($m==UPLOAD_ERR_INI_SIZE?ini_get("upload_max_filesize"):0);return($m?lang(2).($_d?" ".lang(3,$_d):""):lang(4));}function
repeat_pattern($Be,$od){return
str_repeat("$Be{0,65535}",$od/65535)."$Be{0,".($od%65535)."}";}function
is_utf8($X){return(preg_match('~~u',$X)&&!preg_match('~[\\0-\\x8\\xB\\xC\\xE-\\x1F]~',$X));}function
shorten_utf8($Jf,$od=80,$Nf=""){if(!preg_match("(^(".repeat_pattern("[\t\r\n -\x{FFFF}]",$od).")($)?)u",$Jf,$C))preg_match("(^(".repeat_pattern("[\t\r\n -~]",$od).")($)?)",$Jf,$C);return
h($C[1]).$Nf.(isset($C[2])?"":"<i>...</i>");}function
format_number($X){return
strtr(number_format($X,0,".",lang(5)),preg_split('~~u',lang(6),-1,PREG_SPLIT_NO_EMPTY));}function
friendly_url($X){return
preg_replace('~[^a-z0-9_]~i','-',$X);}function
hidden_fields($Qe,$Lc=array()){while(list($z,$X)=each($Qe)){if(!in_array($z,$Lc)){if(is_array($X)){foreach($X
as$bd=>$W)$Qe[$z."[$bd]"]=$W;}else
echo'<input type="hidden" name="'.h($z).'" value="'.h($X).'">';}}}function
hidden_fields_get(){echo(sid()?'<input type="hidden" name="'.session_name().'" value="'.h(session_id()).'">':''),(SERVER!==null?'<input type="hidden" name="'.DRIVER.'" value="'.h(SERVER).'">':""),'<input type="hidden" name="username" value="'.h($_GET["username"]).'">';}function
table_status1($Q,$jc=false){$K=table_status($Q,$jc);return($K?$K:array("Name"=>$Q));}function
column_foreign_keys($Q){global$c;$K=array();foreach($c->foreignKeys($Q)as$p){foreach($p["source"]as$X)$K[$X][]=$p;}return$K;}function
enum_input($U,$wa,$n,$Y,$Sb=null){global$c;preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$vd);$K=($Sb!==null?"<label><input type='$U'$wa value='$Sb'".((is_array($Y)?in_array($Sb,$Y):$Y===0)?" checked":"")."><i>".lang(7)."</i></label>":"");foreach($vd[1]as$v=>$X){$X=stripcslashes(str_replace("''","'",$X));$Na=(is_int($Y)?$Y==$v+1:(is_array($Y)?in_array($v+1,$Y):$Y===$X));$K.=" <label><input type='$U'$wa value='".($v+1)."'".($Na?' checked':'').'>'.h($c->editVal($X,$n)).'</label>';}return$K;}function
input($n,$Y,$s){global$g,$wg,$c,$y;$F=h(bracket_escape($n["field"]));echo"<td class='function'>";if(is_array($Y)&&!$s){$ta=array($Y);if(version_compare(PHP_VERSION,5.4)>=0)$ta[]=JSON_PRETTY_PRINT;$Y=call_user_func_array('json_encode',$ta);$s="json";}$gf=($y=="mssql"&&$n["auto_increment"]);if($gf&&!$_POST["save"])$s=null;$xc=(isset($_GET["select"])||$gf?array("orig"=>lang(8)):array())+$c->editFunctions($n);$wa=" name='fields[$F]'";if($n["type"]=="enum")echo
nbsp($xc[""])."<td>".$c->editInput($_GET["edit"],$n,$wa,$Y);else{$pc=0;foreach($xc
as$z=>$X){if($z===""||!$X)break;$pc++;}$ae=($pc?" onchange=\"var f = this.form['function[".h(js_escape(bracket_escape($n["field"])))."]']; if ($pc > f.selectedIndex) f.selectedIndex = $pc;\" onkeyup='keyupChange.call(this);'":"");$wa.=$ae;$Cc=(in_array($s,$xc)||isset($xc[$s]));echo(count($xc)>1?"<select name='function[$F]' onchange='functionChange(this);'".on_help("getTarget(event).value.replace(/^SQL\$/, '')",1).">".optionlist($xc,$s===null||$Cc?$s:"")."</select>":nbsp(reset($xc))).'<td>';$Qc=$c->editInput($_GET["edit"],$n,$wa,$Y);if($Qc!="")echo$Qc;elseif($n["type"]=="set"){preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$vd);foreach($vd[1]as$v=>$X){$X=stripcslashes(str_replace("''","'",$X));$Na=(is_int($Y)?($Y>>$v)&1:in_array($X,explode(",",$Y),true));echo" <label><input type='checkbox' name='fields[$F][$v]' value='".(1<<$v)."'".($Na?' checked':'')."$ae>".h($c->editVal($X,$n)).'</label>';}}elseif(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads"))echo"<input type='file' name='fields-$F'$ae>";elseif(($cg=preg_match('~text|lob~',$n["type"]))||preg_match("~\n~",$Y)){if($cg&&$y!="sqlite")$wa.=" cols='50' rows='12'";else{$M=min(12,substr_count($Y,"\n")+1);$wa.=" cols='30' rows='$M'".($M==1?" style='height: 1.2em;'":"");}echo"<textarea$wa>".h($Y).'</textarea>';}elseif($s=="json")echo"<textarea$wa cols='50' rows='12' class='jush-js'>".h($Y).'</textarea>';else{$Bd=(!preg_match('~int~',$n["type"])&&preg_match('~^(\\d+)(,(\\d+))?$~',$n["length"],$C)?((preg_match("~binary~",$n["type"])?2:1)*$C[1]+($C[3]?1:0)+($C[2]&&!$n["unsigned"]?1:0)):($wg[$n["type"]]?$wg[$n["type"]]+($n["unsigned"]?0:1):0));if($y=='sql'&&$g->server_info>=5.6&&preg_match('~time~',$n["type"]))$Bd+=7;echo"<input".((!$Cc||$s==="")&&preg_match('~(?<!o)int~',$n["type"])?" type='number'":"")." value='".h($Y)."'".($Bd?" maxlength='$Bd'":"").(preg_match('~char|binary~',$n["type"])&&$Bd>20?" size='40'":"")."$wa>";}}}function
process_input($n){global$c;$Kc=bracket_escape($n["field"]);$s=$_POST["function"][$Kc];$Y=$_POST["fields"][$Kc];if($n["type"]=="enum"){if($Y==-1)return
false;if($Y=="")return"NULL";return+$Y;}if($n["auto_increment"]&&$Y=="")return
null;if($s=="orig")return($n["on_update"]=="CURRENT_TIMESTAMP"?idf_escape($n["field"]):false);if($s=="NULL")return"NULL";if($n["type"]=="set")return
array_sum((array)$Y);if($s=="json"){$s="";$Y=json_decode($Y,true);if(!is_array($Y))return
false;return$Y;}if(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads")){$mc=get_file("fields-$Kc");if(!is_string($mc))return
false;return
q($mc);}return$c->processInput($n,$Y,$s);}function
fields_from_edit(){global$l;$K=array();foreach((array)$_POST["field_keys"]as$z=>$X){if($X!=""){$X=bracket_escape($X);$_POST["function"][$X]=$_POST["field_funs"][$z];$_POST["fields"][$X]=$_POST["field_vals"][$z];}}foreach((array)$_POST["fields"]as$z=>$X){$F=bracket_escape($z,1);$K[$F]=array("field"=>$F,"privileges"=>array("insert"=>1,"update"=>1),"null"=>1,"auto_increment"=>($z==$l->primary),);}return$K;}function
search_tables(){global$c,$g;$_GET["where"][0]["op"]="LIKE %%";$_GET["where"][0]["val"]=$_POST["query"];$uc=false;foreach(table_status('',true)as$Q=>$R){$F=$c->tableName($R);if(isset($R["Engine"])&&$F!=""&&(!$_POST["tables"]||in_array($Q,$_POST["tables"]))){$J=$g->query("SELECT".limit("1 FROM ".table($Q)," WHERE ".implode(" AND ",$c->selectSearchProcess(fields($Q),array())),1));if(!$J||$J->fetch_row()){if(!$uc){echo"<ul>\n";$uc=true;}echo"<li>".($J?"<a href='".h(ME."select=".urlencode($Q)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]))."'>$F</a>\n":"$F: <span class='error'>".error()."</span>\n");}}}echo($uc?"</ul>":"<p class='message'>".lang(9))."\n";}function
dump_headers($Jc,$Id=false){global$c;$K=$c->dumpHeaders($Jc,$Id);$qe=$_POST["output"];if($qe!="text")header("Content-Disposition: attachment; filename=".$c->dumpFilename($Jc).".$K".($qe!="file"&&!preg_match('~[^0-9a-z]~',$qe)?".$qe":""));session_write_close();ob_flush();flush();return$K;}function
dump_csv($L){foreach($L
as$z=>$X){if(preg_match("~[\"\n,;\t]~",$X)||$X==="")$L[$z]='"'.str_replace('"','""',$X).'"';}echo
implode(($_POST["format"]=="csv"?",":($_POST["format"]=="tsv"?"\t":";")),$L)."\r\n";}function
apply_sql_function($s,$d){return($s?($s=="unixepoch"?"DATETIME($d, '$s')":($s=="count distinct"?"COUNT(DISTINCT ":strtoupper("$s("))."$d)"):$d);}function
get_temp_dir(){$K=ini_get("upload_tmp_dir");if(!$K){if(function_exists('sys_get_temp_dir'))$K=sys_get_temp_dir();else{$nc=@tempnam("","");if(!$nc)return
false;$K=dirname($nc);unlink($nc);}}return$K;}function
password_file($i){$nc=get_temp_dir()."/adminer.key";$K=@file_get_contents($nc);if($K||!$i)return$K;$r=@fopen($nc,"w");if($r){chmod($nc,0660);$K=rand_string();fwrite($r,$K);fclose($r);}return$K;}function
rand_string(){return
md5(uniqid(mt_rand(),true));}function
select_value($X,$A,$n,$dg){global$c,$ba;if(is_array($X)){$K="";foreach($X
as$bd=>$W)$K.="<tr>".($X!=array_values($X)?"<th>".h($bd):"")."<td>".select_value($W,$A,$n,$dg);return"<table cellspacing='0'>$K</table>";}if(!$A)$A=$c->selectLink($X,$n);if($A===null){if(is_mail($X))$A="mailto:$X";if($Se=is_url($X))$A=(($Se=="http"&&$ba)||preg_match('~WebKit~i',$_SERVER["HTTP_USER_AGENT"])?$X:"$Se://www.adminer.org/redirect/?url=".urlencode($X));}$K=$c->editVal($X,$n);if($K!==null){if($K==="")$K="&nbsp;";elseif(!is_utf8($K))$K="\0";elseif($dg!=""&&is_shortable($n))$K=shorten_utf8($K,max(0,+$dg));else$K=h($K);}return$c->selectVal($K,$A,$n,$X);}function
is_mail($Pb){$va='[-a-z0-9!#$%&\'*+/=?^_`{|}~]';$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';$Be="$va+(\\.$va+)*@($Db?\\.)+$Db";return
is_string($Pb)&&preg_match("(^$Be(,\\s*$Be)*\$)i",$Pb);}function
is_url($Jf){$Db='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';return(preg_match("~^(https?)://($Db?\\.)+$Db(:\\d+)?(/.*)?(\\?.*)?(#.*)?\$~i",$Jf,$C)?strtolower($C[1]):"");}function
is_shortable($n){return
preg_match('~char|text|lob|geometry|point|linestring|polygon|string~',$n["type"]);}function
count_rows($Q,$Z,$Wc,$u){global$y;$I=" FROM ".table($Q).($Z?" WHERE ".implode(" AND ",$Z):"");return($Wc&&($y=="sql"||count($u)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$u).")$I":"SELECT COUNT(*)".($Wc?" FROM (SELECT 1$I$zc) x":$I));}function
slow_query($I){global$c,$T;$k=$c->database();$fg=$c->queryTimeout();if(support("kill")&&is_object($h=connect())&&($k==""||$h->select_db($k))){$dd=$h->result("SELECT CONNECTION_ID()");echo'<script type="text/javascript">
var timeout = setTimeout(function () {
ajax(\'',js_escape(ME),'script=kill\', function () {
}, \'token=',$T,'&kill=',$dd,'\');
}, ',1000*$fg,');
</script>
';}else$h=null;ob_flush();flush();$K=@get_key_vals($I,$h,$fg);if($h){echo"<script type='text/javascript'>clearTimeout(timeout);</script>\n";ob_flush();flush();}return
array_keys($K);}function
get_token(){$We=rand(1,1e6);return($We^$_SESSION["token"]).":$We";}function
verify_token(){list($T,$We)=explode(":",$_POST["token"]);return($We^$_SESSION["token"])==$T;}function
lzw_decompress($Da){$_b=256;$Ea=8;$Ta=array();$hf=0;$if=0;for($v=0;$v<strlen($Da);$v++){$hf=($hf<<8)+ord($Da[$v]);$if+=8;if($if>=$Ea){$if-=$Ea;$Ta[]=$hf>>$if;$hf&=(1<<$if)-1;$_b++;if($_b>>$Ea)$Ea++;}}$zb=range("\0","\xFF");$K="";foreach($Ta
as$v=>$Sa){$Ob=$zb[$Sa];if(!isset($Ob))$Ob=$Tg.$Tg[0];$K.=$Ob;if($v)$zb[]=$Tg.$Ob[0];$Tg=$Ob;}return$K;}function
on_help($Za,$Af=0){return" onmouseover='helpMouseover(this, event, ".h($Za).", $Af);' onmouseout='helpMouseout(this, event);'";}function
edit_form($b,$o,$L,$Dg){global$c,$y,$T,$m;$Sf=$c->tableName(table_status1($b,true));page_header(($Dg?lang(10):lang(11)),$m,array("select"=>array($b,$Sf)),$Sf);if($L===false)echo"<p class='error'>".lang(12)."\n";echo'<form action="" method="post" enctype="multipart/form-data" id="form">
';if(!$o)echo"<p class='error'>".lang(13)."\n";else{echo"<table cellspacing='0' onkeydown='return editingKeydown(event);'>\n";foreach($o
as$F=>$n){echo"<tr><th>".$c->fieldName($n);$vb=$_GET["set"][bracket_escape($F)];if($vb===null){$vb=$n["default"];if($n["type"]=="bit"&&preg_match("~^b'([01]*)'\$~",$vb,$ef))$vb=$ef[1];}$Y=($L!==null?($L[$F]!=""&&$y=="sql"&&preg_match("~enum|set~",$n["type"])?(is_array($L[$F])?array_sum($L[$F]):+$L[$F]):$L[$F]):(!$Dg&&$n["auto_increment"]?"":(isset($_GET["select"])?false:$vb)));if(!$_POST["save"]&&is_string($Y))$Y=$c->editVal($Y,$n);$s=($_POST["save"]?(string)$_POST["function"][$F]:($Dg&&$n["on_update"]=="CURRENT_TIMESTAMP"?"now":($Y===false?null:($Y!==null?'':'NULL'))));if(preg_match("~time~",$n["type"])&&$Y=="CURRENT_TIMESTAMP"){$Y="";$s="now";}input($n,$Y,$s);echo"\n";}if(!support("table"))echo"<tr>"."<th><input name='field_keys[]' onkeyup='keyupChange.call(this);' onchange='fieldChange(this);' value=''>"."<td class='function'>".html_select("field_funs[]",$c->editFunctions(array("null"=>isset($_GET["select"]))))."<td><input name='field_vals[]'>"."\n";echo"</table>\n";}echo"<p>\n";if($o){echo"<input type='submit' value='".lang(14)."'>\n";if(!isset($_GET["select"]))echo"<input type='submit' name='insert' value='".($Dg?lang(15)."' onclick='return !ajaxForm(this.form, \"".lang(16).'...", this)':lang(17))."' title='Ctrl+Shift+Enter'>\n";}echo($Dg?"<input type='submit' name='delete' value='".lang(18)."'".confirm().">\n":($_POST||!$o?"":"<script type='text/javascript'>focus(document.getElementById('form').getElementsByTagName('td')[1].firstChild);</script>\n"));if(isset($_GET["select"]))hidden_fields(array("check"=>(array)$_POST["check"],"clone"=>$_POST["clone"],"all"=>$_POST["all"]));echo'<input type="hidden" name="referer" value="',h(isset($_POST["referer"])?$_POST["referer"]:$_SERVER["HTTP_REFERER"]),'">
<input type="hidden" name="save" value="1">
<input type="hidden" name="token" value="',$T,'">
</form>
';}global$c,$g,$Eb,$Lb,$Vb,$m,$xc,$_c,$ba,$Pc,$y,$a,$hd,$Zd,$Ce,$Kf,$Dc,$T,$rg,$wg,$Cg,$fa;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]";$ba=$_SERVER["HTTPS"]&&strcasecmp($_SERVER["HTTPS"],"off");@ini_set("session.use_trans_sid",false);session_cache_limiter("");if(!defined("SID")){session_name("adminer_sid");$te=array(0,preg_replace('~\\?.*~','',$_SERVER["REQUEST_URI"]),"",$ba);if(version_compare(PHP_VERSION,'5.2.0')>=0)$te[]=true;call_user_func_array('session_set_cookie_params',$te);session_start();}remove_slashes(array(&$_GET,&$_POST,&$_COOKIE),$oc);if(get_magic_quotes_runtime())set_magic_quotes_runtime(false);@set_time_limit(0);@ini_set("zend.ze1_compatibility_mode",false);@ini_set("precision",20);$hd=array('en'=>'English','ar'=>'
','bn'=>'
','ca'=>'Catal
','cs'=>'
tina','da'=>'Dansk','de'=>'Deutsch','es'=>'Espa
ol','et'=>'Eesti','fa'=>'
','fr'=>'Fran
ais','hu'=>'Magyar','id'=>'Bahasa Indonesia','it'=>'Italiano','ja'=>'
','ko'=>'
','lt'=>'Lietuvi
','nl'=>'Nederlands','no'=>'Norsk','pl'=>'Polski','pt'=>'Portugu
s','pt-br'=>'Portugu
s (Brazil)','ro'=>'Limba Rom
','ru'=>'
','sk'=>'Sloven
ina','sl'=>'Slovenski','sr'=>'
','ta'=>'
','th'=>'
','tr'=>'T
e','uk'=>'
','vi'=>'Ti
ng Vi
t','zh'=>'
','zh-tw'=>'
',);function
get_lang(){global$a;return$a;}function
lang($Kc,$Qd=null){if(is_string($Kc)){$Fe=array_search($Kc,get_translations("en"));if($Fe!==false)$Kc=$Fe;}global$a,$rg;$qg=($rg[$Kc]?$rg[$Kc]:$Kc);if(is_array($qg)){$Fe=($Qd==1?0:($a=='cs'||$a=='sk'?($Qd&&$Qd<5?1:2):($a=='fr'?(!$Qd?0:1):($a=='pl'?($Qd%10>1&&$Qd%10<5&&$Qd/10%10!=1?1:2):($a=='sl'?($Qd%100==1?0:($Qd%100==2?1:($Qd%100==3||$Qd%100==4?2:3))):($a=='lt'?($Qd%10==1&&$Qd%100!=11?0:($Qd%10>1&&$Qd/10%10!=1?1:2)):($a=='ru'||$a=='sr'||$a=='uk'?($Qd%10==1&&$Qd%100!=11?0:($Qd%10>1&&$Qd%10<5&&$Qd/10%10!=1?1:2)):1)))))));$qg=$qg[$Fe];}$ta=func_get_args();array_shift($ta);$tc=str_replace("%d","%s",$qg);if($tc!=$qg)$ta[0]=format_number($Qd);return
vsprintf($tc,$ta);}function
switch_lang(){global$a,$hd;echo"<form action='' method='post'>\n<div id='lang'>",lang(19).": ".html_select("lang",$hd,$a,"this.form.submit();")," <input type='submit' value='".lang(20)."' class='hidden'>\n","<input type='hidden' name='token' value='".get_token()."'>\n";echo"</div>\n</form>\n";}if(isset($_POST["lang"])&&verify_token()){cookie("adminer_lang",$_POST["lang"]);$_SESSION["lang"]=$_POST["lang"];$_SESSION["translations"]=array();redirect(remove_from_uri());}$a="en";if(isset($hd[$_COOKIE["adminer_lang"]])){cookie("adminer_lang",$_COOKIE["adminer_lang"]);$a=$_COOKIE["adminer_lang"];}elseif(isset($hd[$_SESSION["lang"]]))$a=$_SESSION["lang"];else{$ka=array();preg_match_all('~([-a-z]+)(;q=([0-9.]+))?~',str_replace("_","-",strtolower($_SERVER["HTTP_ACCEPT_LANGUAGE"])),$vd,PREG_SET_ORDER);foreach($vd
as$C)$ka[$C[1]]=(isset($C[3])?$C[3]:1);arsort($ka);foreach($ka
as$z=>$H){if(isset($hd[$z])){$a=$z;break;}$z=preg_replace('~-.*~','',$z);if(!isset($ka[$z])&&isset($hd[$z])){$a=$z;break;}}}$rg=&$_SESSION["translations"];if($_SESSION["translations_version"]!=3589914440){$rg=array();$_SESSION["translations_version"]=3589914440;}function
get_translations($gd){switch($gd){case"en":$f="A9
OP#I
r\n2
1C`(
S=\$A
+N&\r
PuWR
\r=?X
zE,-m
2(A{\r
k\$\"
pA.7
KJu~4
Nt8g
\$cB
8_
  mc
KAxD
`8Ir
H\nE
%Ib\\

dAH
 \$P,3
5
 I\n*0\r\$
GhwM
6@~\0Q
a/^h
_,ih
9#\rQG
\r\$
= (+
SZ\n?
,LJV
\"Wii2
n\rq}G
/!Im
\$!<%
\rZC
`
 lH
BpG!
e
 VyN
S/28
XT4WN
In
  (\nPKk
/|/T
vX\\P
\"kYj4
1\nl
+O9i
;3gg
)1#'
)nU9
r{B{
*eA\\D
Y&\"
<q**
Hc\rv
E\\d
Q[\$
\neXT
x #N
%D\\
h(ifx
n2;i
-Jb2
\0\\";break;case"ar":$f="
,&\n
]6QM
\\\nl+[\n
GT\r
'T6U1
]N*PZ,
d!iQl(p
tl.n
P\\1q+
\n&T
RF\\
dE+(
1eL0
k&Di
,o8J
m\rG
#FD

\rc(
k\0*
Nv2p
Ax^;
8\$c
I'+k|
MH

\"r_S
O,pT\0
\0U\n
\"JXF
j`\\i(
V^#e,W
%\\K
BzST1:d*
Q\"~
D
 `V
s;Q*
[#\n*
gQB'x
9t&~
(KYa
j;ki
0U@e(o
\0QI
\0)T
_sV*
Z8xa
\r)eya
XUOw:N2
-&Vc
f\"ki\0&M

 FHK
Pd\\rdPtpJ

\"%
p0\$
H`1J\$
@
 C^m@
61Q8
-0%D
6G&.r
%%,\r
(O\r
+tw0
('r\n
IbUq])
\$?\$B
N}\$
J@l4A
\n`";break;case"bn":$f="
\nt

]\0_
XD)L
\$:IK
g5U4
Nd!u>
@'Jx
(n+L
,(_)
4]y3
\\U*
2\$E
OSDU@
\"`Z
\neE5\\
Z7G5
A\0mF
 SK3S0
\"kd[
|\\O
(Cpt~
@PNS
\0\n
aQ]J&
TRVUi
wU\n
u>3P3
A\0A
xS\n
H\rE
\0Sm
{\$pF\n
yP(1L
Cerd1=
T<b[
uU S
i=ru\r
^#3;
6XS

8\nd
rcZ1
\\{G
B\0^
\rL.
nKiml
\\&]{
q/I2
#n[j(
U#r_
rI
  RS
2m\"4
\rLf
b\n\$T
2+\$
Hn
  g
uR3%q
jh7!
\$o#/
be.k
1Bt
    tm
=Nq<S
{T
  )
hpDf
rc@S
Ipg\0
Po+P
6gmKR0
PRYUS6
MKS1
LfeR
r;-T-
QPz_
\r`@
P
 v6F
RRM,
'6u^6xx
cv;C
^QGB
L;Tw?
iu1%\\p
a1\n\n
Gd[)
IMqZ
'+vS
t\n`
";break;case"ca":$f="E9
\\33A
r\n1
\\>R
Y\$l
1\"P
czF9
    (8
%l(A
1,[.
#;<0
^J*;o\\
M\$Kl
&T92
Ax^;
'EB\n6C
,mEh
-rjN
mg\"
\0A

E\$xj
#0@W
\$1h
\0U\n
xMa=2
\\\$
\0aa
& \$
}\"\n
#CqF
I4.d
^P\0E5
+\rD(
|wZA]
U1\r
&TMgD
&1\r

\\p
Ahh+
]r&3>
{\\=5/vn
F6SIj
\np7*
=\".
]s?z
:\0f
\r/J
D&bE33%|w.
qdOd
1\\86
/M\n
R\r\n
d2\0
a1\$
\$:J
TbJ2
-T6D
d0cPN
^G\$
!\0@
O&/D
\nW)
p{g)&J
t\n`
";break;case"cs":$f="O8

FC1
j\nb
dWeH
le2b
?y\$
CJz94
9\r0@
CkH77
LS\$
 @1
   #P
7\rp8
MCCs
<b
  \\
`@=h
6:^x;jm
I[QC'
Bn9K-\$z
e \r
Ax^;
:@dL
I+/%
\"E
1tE\n
*Wpq
F\r-,
iW%\r.H
aR06
JMY=
:\$(P
V)o\\
;eLN
0ugc
A<176iF+i
\\*1
^C\n
4GuL
\"mE
a\"]
U?R{
Kj\r0
{&<

B2fU
\$`u
J1)C
=\nEQ
\"l.
9+
  %tC
9&\"
6Q\0
iB<O
bvQh
+\nMPr
zq\"N
/ M/f
Z(1j
0>.
\$cD
#CVT
V:\"
p%rB
\r-2q.
\$\"
d% ck
(R\"LL2
*+.aE(>
r\$
   \$
|\$E
Nz\$n~(\"
0>ss
/4<t\$\r4>
";break;case"da":$f="E9
\\33AAD
\\\n&
Mpci
 :IM
Js:0
\nNF
h\n!
pQ:]
.74(
3@7-n
jp64c:D
6L T
,J:B0
\r[2
lQ'\r
ab`9^c
.]N@
<\09

!\0
\$8j
f7\ra
:uUW
Kh@;>
.y{Mz\$C
\n R
Uc<3'
;r\"
hE\$
s!@'
*(e>q
\0PP\\ih
R[qk
<S\"8`
{V o_!
MV\"
T(T.
s\"a
xBYmH
o(Nr
bJzCxp
!bOK
:<9'(7
hK\r
\$\\I
P\nXh\\f
MCkl}
VFr!
EEm:dR
j%T\r
_\$

|*:K1
Y@!#5Z:
f/mm
Nd(T
Za\$
eC>4/
@?,v

(\"
\"b2)
8=\"t
t@";break;case"de":$f="S4

'C)
\$RCI
t\n%
aRA`
c\n|j
C\nT
\n7?
.(
  #
I2<`P
xZ\$
apA\nA
eyn^
\\aA
B0@*\r
v1^HO
\0002?
48c0z
Atr3
_X1hB@
1#1(D
0rY\$p
Y9[
(r:F(
H@Jq:c
N2&qA
VxnepIJ
(z@D
;q\$
#(f>
xS\n
0o)L
QEK1
H2/%f/
p \n
Z24>
<8QeF
N?\rE
\r wK3
*W\n
\n\r\0
5JX\n\rd
\"\n
Qo@R
RXuo\"
.66#
\"
  =&
kq*t
^\\E#
TgWqD
P\$X\\d
b6O*
BH`k}RC
hgn2
8i\":
\0C~
p?\r
\re(
\$bNP
\\Tf
h \"f
j'\r
D?lZ
4D\0
%-8ri
I@PJ
X\"H
\"g#
<a\"
\nfp)
8Fvhb
5/*C

H2B4
RZ\rb\\
9.(b
@\rZD
Y#\"84
  ";break;case"es":$f="E9
\\33AAD
Z0%9
(>\")
prcq
(!\0
\n0L#

xJ2CC
R,<uD&
Cj7=
\n\r#M5
l`@7
29FGB

x;Am\r
/i;P:u
7\ra
:\r

bB:#/

M5I
rpY\$
fq\$
c=r@R
I\"!
&A@'
WMN
   =
\rc5?
*#>Lu
\n!8l
m
 LZ#
P\n\n
\\U(\n
}\rrs
pxa2
t5\$
1^L1r
n5=

x*W\$U9
X\n)A
9-&*
%PF*
?j\$*
-{.q4
'P^VS
i5!Ap
F#\$l
!@R(
_VhoB
BG7hXy
C5Tj
tk4~iO
*Cw%r|
w1\$
Y{NI
.DTO
ddIl
P^t'
d \r
Vr#

Fj&On
/+h[K
 dr?
b\"~
:q\\
\$b>UNx6j
cJ>C
2H*8
z8\$
T\$b
CcvMK`
nsR
r*1E6]B
c i\n
t\n`
";break;case"et":$f="K0

FC1
Uj;F
r:\r#
(\\ 1\$i
+\$m
\n\"`Z(;
\\R\r
#:27
PA=8
-#8_fu
\08
D9J{
 ~+~6
7\0`
4Mz0
 *Gh,
#a0h
 !\"92
D&eP
z\n^
(RLK\0^
\$UAH
Ij\r
Ci/\rTX
CZL47
~E i
q'Kq
zrO!
s7\0q
kS!cl%
\\+L_
bh\0
\$\0
SE\r
b.A]\rD
Y*b8Y
SZSlY
a[4\n
^L\0
(ko-
^hxBM
|RKe
\\Kq
~1m(
,S\0k3\0
 K/\0
~\0P
rj\$\$\r
V\rbfM
oXKb
*B8h

\"j
m0&LH%&\"
4\"b;
\"6~
J3#6
\\K\n
Bb7!@@\n
(
 r\\
h\r2l4
*~\0
t\n`
";break;case"fa":$f="
aQ\n
Ma+X
[\"S
)Cfh
\0Sm`
+<NCiW
Mb\"

5o#
\r*F
B:_+
Q%%r
)=t+\$
1@@)
Wb#w,
e\\e
,lh9:
x&\"
\0x0
6
 #p
#)\\
}QI\n\"
&XMY
yMiiA\0%RfV`#6
Z.I+
4B*f
0r\r
z\r\r
,nQpQ
<x&z
&q6NO%
,4n(\$
 A\n
/DDV
R\0=
VJZD
(\"V
~aIiM
eh\$
%\nAH
=sXMh
)X\$
<TIQ
?\ne
\0^[
,4\"d
GAIr
u%\\
7'\nuv
R9Vm
'\$bd
Ts9v
.}dc
M
 CdSM_
X\nv
/{>J
%~eG
\rC~
XOID
{;b{\n
`]0\rD
~}]f
fRj\n
QDdmm`
>cdS
/fK0\0
N7or
M*BO

(LP
P,Ypf
c!D6
>@hr
L^-?
=`";break;case"fr":$f="
i7\n

\ntL
LgSt
g!uz
,shy
6\r#
Kq\0
MrQ

\"P;@
HKJR
-/+\r
\n_J
/L<6
MK6`S
mH
  0
a3YS&
UtiR
C*\r
\rjF
CCx8
Ax^;
\$;
\0a&
T\0002/
@#\"
\0(*
T'AL4
\n7h@
\nHp
d\$
\rk.j
\0R;
BbA+
!\$L2
h'e)
\n\nP
tBJc
\nQlM>D
^tZp
hUA'
%-+cp
HvF&
%WKMR`
SJS !
rlwf\n
Ec9
   CN\"
ZA\\2
HGyE
^ago2
I+\r
^BP\n)
7`aWS
U\"j
@\rN2lD
TlP{
p
 \n
REf
!bFy
n1(!
_#V3
@LZ@
\0E*
\\Xb
;m4)R
13)1
\r\"
";break;case"hu":$f="B4
\\33
NF0Q8
kiL
\\\n
LMBl4
MRr2
X)\no9

FC1
\n!aOL5
*DAq2Q

'c-L
!4Pd&
<W>do6
c\r[
Un\\t
(6<
   YB6
B\"(
M\rI\n
;O\n\$
>G#P
r9\r
 2C;F4
Jc-C
\n\r
AuH3
,B\nHe\rd(5
&|7=
B4eL1
\0dAf
E\\X\nf@
\rVbw'
>m\$j2
\na^
gW<g
`pR\nI
S&eC8yUe
:nAYSje
@PV?
gTPI
%RR(
HzJ9w+/
Gy\n=
(0QIqx:
b\"n
e
 GNi
HizNz
l2Ip
a\"F%
'nU#U
B\"e
0oC'
[oX%
{\$2
[\\=

;}:a
*KDt!
2>yl
'0\"ko
:\"^
\nIb?`
 3*y
\0%m2
~MfX
r\"B.\r
@\$BH\$\n
L<jE%H
ZD\$
3h\"
\n5H&
Y0zT
CVLE
'GW13
a8+
";break;case"id":$f="A7
\r0#X
\"Rn
\"pi

'\r
\0003

&jY
5\r#
B2@3
LC8\r-J
BZ:0
)`Tl
J(3,
*YC\r
J\"r3-
rY
  *
P\n;
 a@'
T2~
   Q
\0cN
@nME
(f
  +
SJ%<

=+@
I 3,
\\Kb!
     g
Ic\$d
Ao@!
\\\$
]QSs
\\CA
J3p_-
)\"2K#
a=Gy4C
\ncB
%!MXjs
W,IU
O*4!4
=Q\$UMB
C?DM\nP4;
5)=0
yea,
V7--
R:{m@V
b|rK7
j0{i
yB8(
AjOV
^BJf'H
k&NI
 b\\SC
j&x(
.c\n
Q\"`
=G&1
`";break;case"it":$f="S4
a9@L&
\"u9
1qp(
NgC,
S|\\
\"'j
\n\"
1'OX
RJ80I
 : k
9/K`
*jR0
s,aY?M
VMj2
\nC*
Y\r43
z'czZ)
~
 8B,
Aw
  8~
6_B1()m
6(0H
:5-\\
A\0Ame
\nOh
+.\r&
\n7)
    0
\0U\n
(fh+q
<S_'
\nvR5
iP:L
:\$T
HT.n
IXxy]e
I0-m4
A[k}b1
(F\r,VL
\rWN+
%m*y-3
?-W\\~#
Z\\<
\$yVWK
LT?u
\ngt]
A%\r
wa0S
e#- d
/ViA
T`D\\
\nPt
Y'e*
p2Hp]
\n\$
7`@:B
n\np@Y)6\r
:`I2
rSE\n
t\n`
";break;case"ja":$f="
\\}%
B\r[
T\n\n>
Ygn4
T:Shi
E:S*L
*8U#
eR6A
`\\;
94B
j:9.
,\\I(\$I
96W
 A *
Ds@@S\$CH
9hQ9
 [VD\"{
\$Y+I
Q%jR
h1T!
)\r`
z\rci3BP
\0x0
(\\0
P7P,
a\rf
\$4w
c@PI\"
u70x3
A\0A}-
O\naQ|
I
 vl
Ho}

\0S\\
Kiq*
:\$]M=
Tkp\"
t\ni8
!QYQS
TDdxA
A\$;
&
  SZ
\$\n
X'u#
kr3s
1r\$
Ta%b
 \n)W
c,f7
IK\0|
bbtA
XfZ`
~F(u
tTM#h
>a>r
=\0.
u\nb9\n

-\0
%\rL6
O9\r
\r\0
.<RAv
\r`@
\0@~@
p=\r
dA%\"
\"2b
IL<@
(\"0
\"\n
7#P5CX
      @
\nB\r
\$";break;case"ko":$f="
iBvr
hY`B
X,H10J
\$i`
\"`YB
i0\\E1\\?
fZDoif@!
9Pv'
TT&%
YNDP
g^7J0
ma-,6
1\rO

-^z3
v:y\"
l\ra
\nS@h
yk2 ((
<RGYK&
xz)E
rl\\
d\r*X
0r\r
jrJh
S#(YZT)
\"rU!
\0S[`
(F\n
SrEH
!P\"
XpnVx)
(d?'
'4xl
@KF|Y\n
\"\\>48
A\$vwO
FV\n,
c&eL
&*>3bxB
==Dm
fT\\
kskmOq
.[UK
:;Vy~:
:8aE}
\n`&I
4H\$*
d\r\0
NR! !.
i*\r
\r`@|
\0@{
ba@b
E2%Fnj
Zcx5cZ5
EZ4-
FY\r
`@\n
OAjN
\0";break;case"lt":$f="T4
Nd)!

@l2
g\$)
=&:\nb+
@t4M
b&Nq
,1XI
(D#H
\nQ{
2Ln<
hJ2F
\rIR,:M#
=e\r
Tl{#
#(P9
ap@!Y
cm'x
C\\6
\\=/
K-;\$i,
I\n\0
<:yB
[f\ra
 %dh
Hr\r_%
\"-,
j\rQ
P\\A\0c\$A
\$\n
xS\n
jM]|jq

tpYm
Uih.GH
,'b;D
\rb)
#plW
 iAg

Q@K!
)2\0
Rf\0W
E\\LL
3dv/
_-LL~
,dlO
2Q\$\n
vR2o
O7PP
Y\\\r
uGH7\\+{
-U\"
/a/S
GksvD
_v\"
k\$v
M\\x
s
 \r
\$LM
LB0L
fK\"
30H6B
BDsC
P'dT\r.
\$nv&
,d^r
TB\n
zZMz
vHJf
 /J]00d
       )j?
\n2(b
";break;case"nl":$f="W2
 &pQ
t)<_u
QO;z
+\"!/C
9\$S
k\"
\"`@7
C\0P
Ef3R
\n:2/
mf8+
Ax^;
7?bI
p;!\0P
m\"Z
{ >N
-_gp
S`#B1E
\"
  c
\r\$
S2AUqE5
+eEv)
dJ|\r
( D6K
3THL
(f
  ,x
lI:!
3E\"
reK\n*^L
Q@PP!
Tg;|J
\n0h91S
{0qAu
b\0e
r,VI,k
+{7&
\$@@
*@(+
S\$g%F
k1!Y
\\:I
K5_o
PZ~\n(d
2iFb
DV&\r
nKO:>
m|ef
>\$-
P 9G>
{c(\$
*c8mBF8OV'J.o
,QO0eMr
DTj\\z
<!BR
\n`";break;case"no":$f="E9
\\33AAD

FC1
AGCy
\n\$
mj4`
\rKM7
*\\^
w6^M
\0D0
.7:Cc
Z5\r
:0+C
k,D2\r
x(-1
\r\n
c`Z4'c
ARPcx
DR:*9
#uH2
it\r
:.p88ct
:%)Z
\0x0
*:'i
F^\nA
96Q4:z&
@ry%
p \r
&(\$
PH
  E~&071B
\"H]\"
\njh
 A\n
71Mr
*eR'H;
\$2JV4
`4/t
Y\0B
\"PIv`
 fvgH'
Z[Of
:Z\"yi
m-))
\n\n
\\8+2
|H@a1
rgDR
 ('K
>_Cu
[s;J
\"|h
%UYo
Gu
  \"
V\n]]
|C`+\rj8
V\r)
.e&6\"
\$\\
{E;\0
\$Bf2%
#0\"
#\0%i4-
M%}
   q

";break;case"pl":$f="C=
\$Gs(
<\n!Gj
X1
  (
\$`P
,Sr1
Tz(\r
({A+(
\$2\"c\"L
HK9C
7\rm:
)1`P
6(o8
8cudC
#(@)
p@\$

1B
bIZZ:
B0]i
YI^86
5(=\r
Ax^;
(*bW
Kl l
!\\-\$G
1/\0
%\$
m\rd|
[Q1%n!
\":F
7R\\M
_:bZ%
1s,F
A<8)
7AAc
S\rO
H1\0
\nI\r
D6)h
\"|1
D?2N
M@JHx
'Q*wM
;&\"
S*5O8F
*/es
a{n/
ZVddZG
F0\0j
LDzhLn
\"Z
   c
U+
  ZD
\nN^
\"=
   :
\$wP
\r2<D2@l27
\nN,
20\r1\"8\r
Whf\$
PGbM

*6c
\"1DZ#
GB=H
K/*b
tc\0
\nT=\r
6Rc

^\ng:s
Ck#AR/G
>4LLc
Eq0{*
40\"";break;case"pt":$f="T2
l@%9
l 7E

&))
X\n\$
\\[\rOZ
2wYn
#\"i
\nD1\0
h\\R
2qlC
\r([

1Lbb
PCbL

Mz&
\09U2|
=j@\\
Ax^;
2ye

.4(K
\nI9^~
t\$@
6FuJ
xS\n
(2P@
 u!d
>Fb3
d b.
p \n
EQcu
\$3'
`9PT
U5_`M1?R
\0U\rq
\0006
\0r\"
je!E
84<`
%nC%
N0S4
e#qyo
j-}R
tQ|Q'
OQp8
s>To
{Ce;O

\r\n
y/\\8
*hV'
<ONb6
J)b<

 ZR
atc\"
j6QB6@
>QZ9n
6%\"3#
_#d/1X
JCr2
/\$b1
>Pot
a\0@\n
";break;case"pt-br":$f="V7
\n'0
\rR 8
Lv>%9
n 7F

&)A
7RA\\yi
9
  P
\\\n&3
R.!0\n
<pH@
sko

X@6 ,
O#bR
c))J
(c(\"
\$c0
(S\$
*\$
   p
83C(
\r\n
\"EC
C0vN
7sNB
Hq18j
\0F\n
~A<'
 A\n
4.tQ*
NQJ;
Lj80
<:aA
O&=\$
\r\$8
RNtO
fS:i
zoMW
6iqS1
wMDSV
`cFb
xw\"
/<D!\\
NB~q
t0KV
Nn'=L
\\F-
\nf!
{\rEh
zt4z
}+y>
OG,q
Y+HQ
AUpf
|]l3
\r\0
!c*_
\n*\r*
\"MB
##:#
@\$Gb\$
\rbr\n
G\$\n
atJb
/DnA
\r#z1@
PB8A
R\0MJ
J\\Q
PC1TMB[%
<@jQ
 ";break;case"ro":$f="S:
\$\"

FC1
AFsy
LFSa
`xHx(
Kk{3
\nB@

N(D
1P#?
oc:
S&6&
p76L
5h||
lS;W
    nER9
K;\r3c
\$\$
\"cP\n
3/\n*
7\ra
**tX
r])/
sq\0^!81
\n\n
[d}
U\0kP
\r*!B
a\rE
    (
(N\n
\0DJ
\nD!
A\0v/
\"E=
,N\n(
@\$KR
e(Db[t
6Pj'
_#S\r
HRh'rV@
KG\0
LW!?b
BhSz
b_L4
gvle
Rt)(
1,43
\$g9
LpfAJu
v
 B5
 AJfT
0L8p
!r.|
@eiO

 4~
\\/K
f3oz
\n<0
0R\$
p
 C/
/%\$
c:\n
Q\nK
\\kD\\\r
7\nB
\"z'
XQ\0
0I,B#
<#4T
\r\$8
dR=%
9c~6
%%\$
S\"b:G>
(%jNNZ/
*Jv=
t\n`
";break;case"ru":$f="
I4Qb
h-Z(
BKW2)R
NKWRi
Ay-]
\n@N'R)
Tq\0(`1
Xi\$fi'B
i6FFc{Y
\$|~
(bi/M.q
\n\"
6\$+N
0\$zTY(
KP-[
D&K<e`
Y:!(
y(8(
\rc8j
!+Hn
\n\"bT
N1k\n
Zjn:
6Ec*
G]QB
 FDp]
\nAJ8M
      !
Cpt@
#R>q
\$(8`a
'8^\"*
q-aI
tM\nW9
3\n!
\r 2v
J\n&q
PFMy
%\nJP
K3t4a
c,^|
(!\nM
mS*uA
0T=9
`v
  !
N\$g+
G92\n
\rU\$
,8Qe
pI1&
9SB}
5\nC
S\n-
>0\$
k)N:
?M#\"\\
.xV#
@\\v
B\"v
=%+\$~
lX Eb
%>D&
de~Bd
In\n'
I\n%=\n
q2g/
T\nR
jwJU
 A0pSq
,CX#
2f\r<d
%rs%
w6sR
:Iy6
BCm|
 Ss6
95T!&
<t48
nJ`C
lTnbKEr0
@*(&PX
i)T'J
L.aJ
r\rS
]#u`
uoH5tR
[DGN
e(3Y
KR\n
(Md60c
8&4.
\0bIiEs{2
q=rw
q'gs
\nMj
k*B3
\r,&
fb&U7i
WL]s0M
^cuPSQM
w`@=
 ";break;case"sk":$f="N0
rxdB\$r:
\rFQ\0
b\nb
2pQZ@
\$5I
\r,} '#L
\$\0
#CB~
SZ;>r
7\rc
22@P
\$6\r
2Ie

acX9hC
B0\\
2'|G
\n(=4nNm
+j(O<
\"c8^
4#{X@
jeu\$
I{.a
bt*_
uH\$X1
N@21GR
ANli
%!\$
CJ}4qa
L*%T
qDhe\rQ
 A-Va
\"qa
:)%!
    :
Y?\"
 A\n
WDX9!
\r\$
?E7LZ):W
 #ed
\\\0a@E
L`2#!
\r\r
05\0
]xQ:+
y^Pff
N4'0J
(<sZP
1&G&
\"\n
\$NfY
Yo6g<
U\nvk
J\n+
\$(IM
U4=l7
\$D\r
\"79
\"Rf
q\"q?T
*Yrf
EO-\\
tmW
GR\$
P>MpBY.

pn<pr9n
'Ox nLF
n\"G
(\$J\n
\rn*\$#
L\"&I
#\$%
\\c-
F>tb0
aJ\$d\$5
\$.T\\f
q*r[P
VYcT
M0M-@
\0iLq
\nLBBBV6C2fs
9
 l@
t\n`
";break;case"sl":$f="S:
ib#L&
g#N\0
'r<m
\nm*
\$\0P
2cLH
\$.K
 @1&#
7\rc
#I,T
\n22TKDh
}_Fvz2
{\$6
B0\\
 C246
(\n^&
8\r+
#C8_drc
\r#x
!cXD
\n@R
q0&D
\$L<
xS\n
-<\0
eZsL
!iyK
&\rf
|Z
  2
\",]
c%>O
 _+\$
f~J^\$
\"6/
2 ^V
d0\"
qVl\r\r/
\$\"
H*\$
\r>='
\\GK)o\0
Zl:;F
3\0O
\r=t
Begq
 V_l
!*\r
jR\n
TjbT
Wy\0O9
%cdIC
\rFH
<b}63
#@U^
niOG
^%HK
j\$po
\$<D+
P,SG
Q
 3N
PsI2
2Q\n

dj8
\\Mq
<cE\"eF
C
 5D\nU
)c.3c
4U-v\r
sJ 'Bx'
,\0@\n
zNC\r
b\n%\"17
l";break;case"sr":$f="
\\33
u6cc
s\$_
.\"u
AcYXZ
d]!HbH
#\n<
=k!|
5Ht~
)ELZ
Kji\n
h3iO
u\r,
Z:2
!-qV
2)!H
GPTU
U^R]m,5
S}[E5
#UCK
\nI6
1kz(
VZ\n
I\$!
A\0A
gBo@s
GI\n]
\"Ij(
csNv#
\0b\r!
y6>(
\\4d
`\n@Ui
Rr}G\$H_
C0at
nQW6
icH5
q\"\r
\$\$

g\\26
t\\!ih
|pY

Ax V
cQn?r
j5\$
K&rV
-y\r
&\$R
|b%@i
\rmF_
!+X*
2I<u
Vk
  HO
fnC@
[\rC
A\$,
BI\0%RG
S#3J
QB\$
.1r}
2fS-z
\"(@
H\"k
oJE3ZD
)X|J,

'U\"
\\2v
OP^_u
OX\n h
8'3\\
T#QBK
I+7+
z";break;case"ta":$f="
S.WA
rj1k
8\nRl
[zR.
8N\"
\no\0
)\rkf
Nr\$
Dq
  M
A5Qt
,3m\0002
^VS*#US0
6u+m
6}SU
k|%(_
:\r#x
YMZr
%uo2e*
Uw}\"
oHnfo)
Z3=e\r
WA\$
0lEa
\nFol
_c6q
(@_?
#xk<A
>P\n
\0004
;b,\"|
B\n=l[
\$a
   5
:xMi-e
%EYa
xS\n
@cmA
gHAh
u0d#yhIk0;][
2+\n
\\n7)
7|kM
9ei]
4{S-
NN:[
sc<&
}n)7
{{?q
\rn^n
cK2yn:
\"6im
4un6
j0b:iXe,
z\rL
\rNk
\$.{
.1\n
),qe.
h\0\"3
4PU%G
c[\"
\r&P
/>qZ!
4'\n3
p3\0i
U\"4X
}\$2j
2<NT+A
OARx
ts\r
3\$B
KCPH
hCP:A
Q>+&
-\"U7N%
o;;4
P#9PH
\n\0
q/2nY
#O6'A
+8HMKT@
'69M
/hPJN
Qg*f
l\"6j
gHae
Ar{jVih
EiVwGt
JD?OG
H\rd'
%e\\
Sc\$
H3gZ
\ne2
\0V\$
3[hr
bVPh
W9\\
/TR'C
W=vOP
'
 Go
Vg^p
4d-C
Fj':
Oery
z\r
\0AU
X,R+(
tQ!.
+3\0\n
1!]1v

.(,
9!4z
`@=[
\n`";break;case"th":$f="
\\!
 \nX:&\0
/\0ZB

2\0
?J\\
s\0C
_6\\+eV
\0MLrS
{q\0
|\\Iq
4\r/
JQpXD1
\rto)
3\0\\
\$\\#S
p\\T
*\\1
rz{N
E)\r82
J4`\\;.
J\r<
]O\\w
?!\0
&QRJ
.}|[
X4(L%
A\0u\r
%\$^v
47\\
\$R.V
 \r!
1\nw
M-bz
Chp?!
LzvF
a@\$
\0@\n
     @)y
\0(*
C
 |NI
I(y=
OWRX
p%Cif
F\\L
sN\n,S
l\$]2
EdJMl
W_m(
CU+(
\\\"\0
)%&1
O-\r
-1c1
hee\nQ
xU,Z94
N)qY
#t.J
[V5T
SuuQ
;TJd
}A\rzNahQBfvh
d8COF-
IpBN
fbJh
f\",
cZvNl
 ,4B,:{JN
bj\rl
J\n0N
h#Xa
HSN{#p
d\$_
\"Rb
uSNb
q5\"
7\$jQO
>k\n
Re4Kp
eETi=25
w\0AG
QBCOI4SIo
?3kGEh

tdZ
06!f
k \r
\rkh
%l+\0
b}jgP
'efi
MCiP
g/d\$
Afdj
VUF
3\\vi#
j3HDE
iURh
FY%fz
;e0:m>q
eq|z1qi
5l`@>
\n`";break;case"tr":$f="E6
\\\nb,

FC1
ASv*|
\\ 7\\
.\n&it2
\n\"d
c
 \\
O\$R
d:|5
)bY/
c/Ldy
UmH7
\"M\r)h
Cq
  e
\">A
Q<
  gu
6\r!
-\r\$\\#
 A\n
C3GD
(\\+lb
iQ!0!fe
n8\n
X\n`
q/A-1
DJI5#\$l
\"hE
\$#h^jm
\r-9!]^
O`.+,m
{`m-
\nFS
i&E>.V
v7hp
)Szw
Zg\r)
\"b~
RDVm
z1.^
cT\r
(3g|
^`@@
\\0x
Kk~;
\rp,A
H\\I^\"
\n@P
\$\"0
*zSQ*
G)6?
*
 \"
\"b8\r
@4EK#
";break;case"uk":$f="
Ms6@Se+
Jsh\$g
6\rV
G!TI
vUXh
\\L+U0\\F
J\\G
4J2l
 h'L
BK#D
&&(kfB
z4M2\n
7sJ!?)
R5hj
'x75C
!M(}
@*I`
V*cc
Z*\r
[a\0
)\$\$
p\r.
2?0x
xe\r
a\rg 4
!U:4D
H\n\0
*\">
?'Q\rn
\0d\r+T
0r\r
UOUX*
\0f:'
C0ae2X;
\n\n#M
I\r*
deuN
ct-/[
9/'E
SWr+pe\$
mb\$
24[[[
r-@@
m3-\r
\$~\0
\nWV
/uo=
\nTE
T5dk
pLs(4
b<D+t
\nB@%&
-R*a~
ny PH
\"E!!
,?\$6
2Q\"
(BK%
k\"q
\$\"4
O\$g&
30?\"
Y#O8
U r2
:Ek:
m61n
2G)6
5#aD
\0#DdG
t~LtOD
901-M
+\"*
=SG>
@
 I(
ED]4d
PNs@
BadR
t%\$
bi\$
t
 \"
CV
  s)
li^rF
#APVO
Nx*,
Q!yw
^v-\$Z
~&-P
~";break;case"vi":$f="Bp
#\$b\$L2
8@q:
{\rB\n'
\n\npL
%Kr!
F! b
g\nb
RI)cg
Ccq>
\"\\
Sjw}_
mb895(,
]Tl4'
#{40
C(@7
|%o4
\nH1>
HPZi
(s}.|
\$H<
GCHs
(l\r
BVi)Y
CN\"
JK P
\0HH\\
ux)\n +
6+P\"
D@Px
(XJ(&

4]kK
E(Os
VJ@\$
\0*v(
w!\$/uBF
 H!M
wV_=\\
5;Vt
\n]]
Zr\r
&x&2h
NOj<
FXlS
]\n(o
0+m\0
K\n+
NZ=l
\"\\
\"\$
\"@g
\\p&\\
.,@cfBd
O\"D
v'j6
i\n1
\r*N\r
g\"p\0
y'O\$'
h2&hF
,L22P#
";break;case"zh":$f="
\$\nr.
Js!Kd
t\nr
U:.Z
\rVWd^%

'c(
:QQ-
K!f]
(r\\
1G)tI
'<}
GI\0D
YRs0
40_K
RY%I
RI73
qXsJ
EB\0N
g1LA
PDoqGrL
8\r8
Ax^;
wx<5y
gADU
@8\n
\"[{T
7'\"
a\\-S
\$k]
&+4R
xS\n
\nA,
\0U\n
C0aV
k\$Zb(
Du\\g
qP\"
u\\o
}[{r+
^%\\
*elX
&E\0(+
v!UBVK
\\?c
4YQJ
xwS0
K3hr
Q\$#2]~
t~!j
K\\S6~
i~\"!^
SF3D0E\0a
0\$8
J;yf
-;gy
\r,:
i*\r
R6\"Z
!\0.N
v4C\"2c*
        @
\$2-
\0@\n
&\$`
45C*e
\n`";break;case"zh-tw":$f="
B(\\
neRQ
Sy:\"<
K&]\n
OLP\0
iiZK
ir_
g9f]
eZ.L
C2IBW
)!Dt
\nY N(Kq
q%\r
a_\$
Lu%I
6:#+u#G
acR9f
DBhB
)nYIDs
f8\r9
dc0z
Ax^;
2jCp

b51
xS\n
J*>CP
&eV[
C8 \nk<
r3/\0
\"4Z
%!<9D
D(\n
\\\"
b\0s
!\n(
x\"R@
.h\\R
\"eL
ycU

.kEi
#\0PL
<BN\nq
a'\0`
pMU?
\nO`
KE'QB71\n
6E0Y;
 #gb#
ZnZS
G;_M.
JQ`I
Mx.x\r
Q\$r
C\\U
)en|
?hLR
L[pm)
8s\n
f:\r
cbf'

p^:Ct
\\#B8
L_\0
`\r\"
4\r*
\ra\0
fa!,
\n`";break;}$rg=array();foreach(explode("\n",lzw_decompress($f))as$X)$rg[]=(strpos($X,"\t")?explode("\t",$X):$X);return$rg;}if(!$rg)$rg=get_translations($a);if(extension_loaded('pdo')){class
Min_PDO
extends
PDO{var$_result,$server_info,$affected_rows,$errno,$error;function
__construct(){global$c;$Fe=array_search("SQL",$c->operators);if($Fe!==false)unset($c->operators[$Fe]);}function
dsn($Ib,$V,$_e){try{parent::__construct($Ib,$V,$_e);}catch(Exception$ac){auth_error($ac->getMessage());}$this->setAttribute(13,array('Min_PDOStatement'));$this->server_info=$this->getAttribute(4);}function
query($I,$xg=false){$J=parent::query($I);$this->error="";if(!$J){list(,$this->errno,$this->error)=$this->errorInfo();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,$n=0){$J=$this->query($I);if(!$J)return
false;$L=$J->fetch();return$L[$n];}}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;}}}$Eb=array();class
Min_SQL{var$_conn;function
Min_SQL($g){$this->_conn=$g;}function
select($Q,$N,$Z,$u,$he=array(),$_=1,$G=0,$Me=false){global$c,$y;$Wc=(count($u)<count($N));$I=$c->selectQueryBuild($N,$Z,$u,$he,$_,$G);if(!$I)$I="SELECT".limit(($_GET["page"]!="last"&&+$_&&$u&&$Wc&&$y=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$N)."\nFROM ".table($Q),($Z?"\nWHERE ".implode(" AND ",$Z):"").($u&&$Wc?"\nGROUP BY ".implode(", ",$u):"").($he?"\nORDER BY ".implode(", ",$he):""),($_!=""?+$_:null),($G?$_*$G:0),"\n");$Ff=microtime(true);$K=$this->_conn->query($I);if($Me)echo$c->selectQuery($I,format_time($Ff));return$K;}function
delete($Q,$Ue,$_=0){$I="FROM ".table($Q);return
queries("DELETE".($_?limit1($I,$Ue):" $I$Ue"));}function
update($Q,$P,$Ue,$_=0,$wf="\n"){$Kg=array();foreach($P
as$z=>$X)$Kg[]="$z = $X";$I=table($Q)." SET$wf".implode(",$wf",$Kg);return
queries("UPDATE".($_?limit1($I,$Ue):" $I$Ue"));}function
insert($Q,$P){return
queries("INSERT INTO ".table($Q).($P?" (".implode(", ",array_keys($P)).")\nVALUES (".implode(", ",$P).")":" DEFAULT VALUES"));}function
insertUpdate($Q,$M,$Le){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}}$Eb=array("server"=>"MySQL")+$Eb;if(!defined("DRIVER")){$Ie=array("MySQLi","MySQL","PDO_MySQL");define("DRIVER","server");if(extension_loaded("mysqli")){class
Min_DB
extends
MySQLi{var$extension="MySQLi";function
Min_DB(){parent::init();}function
connect($O,$V,$_e){mysqli_report(MYSQLI_REPORT_OFF);list($Gc,$Ee)=explode(":",$O,2);$K=@$this->real_connect(($O!=""?$Gc:ini_get("mysqli.default_host")),($O.$V!=""?$V:ini_get("mysqli.default_user")),($O.$V.$_e!=""?$_e:ini_get("mysqli.default_pw")),null,(is_numeric($Ee)?$Ee:ini_get("mysqli.default_port")),(!is_numeric($Ee)?$Ee:null));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,$n=0){$J=$this->query($I);if(!$J)return
false;$L=$J->fetch_array();return$L[$n];}function
quote($Jf){return"'".$this->escape_string($Jf)."'";}}}elseif(extension_loaded("mysql")&&!(ini_get("sql.safe_mode")&&extension_loaded("pdo_mysql"))){class
Min_DB{var$extension="MySQL",$server_info,$affected_rows,$errno,$error,$_link,$_result;function
connect($O,$V,$_e){$this->_link=@mysql_connect(($O!=""?$O:ini_get("mysql.default_host")),("$O$V"!=""?$V:ini_get("mysql.default_user")),("$O$V$_e"!=""?$_e: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($Jf){return"'".mysql_real_escape_string($Jf,$this->_link)."'";}function
select_db($qb){return
mysql_select_db($qb,$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
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,$n=0){$J=$this->query($I);if(!$J||!$J->num_rows)return
false;return
mysql_result($J->_result,0,$n);}}class
Min_Result{var$num_rows,$_result,$_offset=0;function
Min_Result($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,$_e){$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\\d)~',';port=\\1',$O)),$V,$_e);return
true;}function
set_charset($La){$this->query("SET NAMES $La");}function
select_db($qb){return$this->query("USE ".idf_escape($qb));}function
query($I,$xg=false){$this->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,$Le){$e=array_keys(reset($M));$Je="INSERT INTO ".table($Q)." (".implode(", ",$e).") VALUES\n";$Kg=array();foreach($e
as$z)$Kg[$z]="$z = VALUES($z)";$Nf="\nON DUPLICATE KEY UPDATE ".implode(", ",$Kg);$Kg=array();$od=0;foreach($M
as$P){$Y="(".implode(", ",$P).")";if($Kg&&(strlen($Je)+$od+strlen($Y)+strlen($Nf)>1e6)){if(!queries($Je.implode(",\n",$Kg).$Nf))return
false;$Kg=array();$od=0;}$Kg[]=$Y;$od+=strlen($Y)+2;}return
queries($Je.implode(",\n",$Kg).$Nf);}}function
idf_escape($Kc){return"`".str_replace("`","``",$Kc)."`";}function
table($Kc){return
idf_escape($Kc);}function
connect(){global$c;$g=new
Min_DB;$mb=$c->credentials();if($g->connect($mb[0],$mb[1],$mb[2])){$g->set_charset(charset($g));$g->query("SET sql_quote_show_create = 1, autocommit = 1");return$g;}$K=$g->error;if(function_exists('iconv')&&!is_utf8($K)&&strlen($pf=iconv("windows-1250","utf-8",$K))>strlen($K))$K=$pf;return$K;}function
get_databases($qc){global$g;$K=get_session("dbs");if($K===null){$I=($g->server_info>=5?"SELECT SCHEMA_NAME FROM information_schema.SCHEMATA":"SHOW DATABASES");$K=($qc?slow_query($I):get_vals($I));restart_session();set_session("dbs",$K);stop_session();}return$K;}function
limit($I,$Z,$_,$Sd=0,$wf=" "){return" $I$Z".($_!==null?$wf."LIMIT $_".($Sd?" OFFSET $Sd":""):"");}function
limit1($I,$Z){return
limit($I,$Z,1);}function
db_collation($k,$Xa){global$g;$K=null;$i=$g->result("SHOW CREATE DATABASE ".idf_escape($k),1);if(preg_match('~ COLLATE ([^ ]+)~',$i,$C))$K=$C[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$i,$C))$K=$Xa[$C[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$g;return$g->result("SELECT USER()");}function
tables_list(){global$g;return
get_key_vals($g->server_info>=5?"SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME":"SHOW TABLES");}function
count_tables($j){$K=array();foreach($j
as$k)$K[$k]=count(get_vals("SHOW TABLES IN ".idf_escape($k)));return$K;}function
table_status($F="",$jc=false){global$g;$K=array();foreach(get_rows($jc&&$g->server_info>=5?"SELECT TABLE_NAME AS Name, Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($F!=""?"AND TABLE_NAME = ".q($F):"ORDER BY Name"):"SHOW TABLE STATUS".($F!=""?" LIKE ".q(addcslashes($F,"%_\\")):""))as$L){if($L["Engine"]=="InnoDB")$L["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\\1',$L["Comment"]);if(!isset($L["Engine"]))$L["Comment"]="";if($F!="")return$L;$K[$L["Name"]]=$L;}return$K;}function
is_view($R){return$R["Engine"]===null;}function
fk_support($R){global$g;return
preg_match('~InnoDB|IBMDB2I~i',$R["Engine"])||(preg_match('~NDB~i',$R["Engine"])&&version_compare($g->server_info,'5.6')>=0);}function
fields($Q){$K=array();foreach(get_rows("SHOW FULL COLUMNS FROM ".table($Q))as$L){preg_match('~^([^( ]+)(?:\\((.+)\\))?( unsigned)?( zerofill)?$~',$L["Type"],$C);$K[$L["Field"]]=array("field"=>$L["Field"],"full_type"=>$L["Type"],"type"=>$C[1],"length"=>$C[2],"unsigned"=>ltrim($C[3].$C[4]),"default"=>($L["Default"]!=""||preg_match("~char|set~",$C[1])?$L["Default"]:null),"null"=>($L["Null"]=="YES"),"auto_increment"=>($L["Extra"]=="auto_increment"),"on_update"=>(preg_match('~^on update (.+)~i',$L["Extra"],$C)?$C[1]:""),"collation"=>$L["Collation"],"privileges"=>array_flip(preg_split('~, *~',$L["Privileges"])),"comment"=>$L["Comment"],"primary"=>($L["Key"]=="PRI"),);}return$K;}function
indexes($Q,$h=null){$K=array();foreach(get_rows("SHOW INDEX FROM ".table($Q),$h)as$L){$K[$L["Key_name"]]["type"]=($L["Key_name"]=="PRIMARY"?"PRIMARY":($L["Index_type"]=="FULLTEXT"?"FULLTEXT":($L["Non_unique"]?"INDEX":"UNIQUE")));$K[$L["Key_name"]]["columns"][]=$L["Column_name"];$K[$L["Key_name"]]["lengths"][]=$L["Sub_part"];$K[$L["Key_name"]]["descs"][]=null;}return$K;}function
foreign_keys($Q){global$g,$Zd;static$Be='`(?:[^`]|``)+`';$K=array();$kb=$g->result("SHOW CREATE TABLE ".table($Q),1);if($kb){preg_match_all("~CONSTRAINT ($Be) FOREIGN KEY ?\\(((?:$Be,? ?)+)\\) REFERENCES ($Be)(?:\\.($Be))? \\(((?:$Be,? ?)+)\\)(?: ON DELETE ($Zd))?(?: ON UPDATE ($Zd))?~",$kb,$vd,PREG_SET_ORDER);foreach($vd
as$C){preg_match_all("~$Be~",$C[2],$Cf);preg_match_all("~$Be~",$C[5],$Yf);$K[idf_unescape($C[1])]=array("db"=>idf_unescape($C[4]!=""?$C[3]:$C[4]),"table"=>idf_unescape($C[4]!=""?$C[4]:$C[3]),"source"=>array_map('idf_unescape',$Cf[0]),"target"=>array_map('idf_unescape',$Yf[0]),"on_delete"=>($C[6]?$C[6]:"RESTRICT"),"on_update"=>($C[7]?$C[7]:"RESTRICT"),);}}return$K;}function
view($F){global$g;return
array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\\s+AS\\s+~isU','',$g->result("SHOW CREATE VIEW ".table($F),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$z=>$X)asort($K[$z]);return$K;}function
information_schema($k){global$g;return($g->server_info>=5&&$k=="information_schema")||($g->server_info>=5.5&&$k=="performance_schema");}function
error(){global$g;return
h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",$g->error));}function
error_line(){global$g;if(preg_match('~ at line ([0-9]+)$~',$g->error,$ef))return$ef[1]-1;}function
create_database($k,$Wa){return
queries("CREATE DATABASE ".idf_escape($k).($Wa?" COLLATE ".q($Wa):""));}function
drop_databases($j){$K=apply_queries("DROP DATABASE",$j,'idf_escape');restart_session();set_session("dbs",null);return$K;}function
rename_database($F,$Wa){$K=false;if(create_database($F,$Wa)){$ff=array();foreach(tables_list()as$Q=>$U)$ff[]=table($Q)." TO ".idf_escape($F).".".table($Q);$K=(!$ff||queries("RENAME TABLE ".implode(", ",$ff)));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$w){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$w["columns"],true)){$za="";break;}if($w["type"]=="PRIMARY")$za=" UNIQUE";}}return" AUTO_INCREMENT$za";}function
alter_table($Q,$F,$o,$rc,$bb,$Tb,$Wa,$ya,$xe){$sa=array();foreach($o
as$n)$sa[]=($n[1]?($Q!=""?($n[0]!=""?"CHANGE ".idf_escape($n[0]):"ADD"):" ")." ".implode($n[1]).($Q!=""?$n[2]:""):"DROP ".idf_escape($n[0]));$sa=array_merge($sa,$rc);$Gf=($bb!==null?" COMMENT=".q($bb):"").($Tb?" ENGINE=".q($Tb):"").($Wa?" COLLATE ".q($Wa):"").($ya!=""?" AUTO_INCREMENT=$ya":"");if($Q=="")return
queries("CREATE TABLE ".table($F)." (\n".implode(",\n",$sa)."\n)$Gf$xe");if($Q!=$F)$sa[]="RENAME TO ".table($F);if($Gf)$sa[]=ltrim($Gf);return($sa||$xe?queries("ALTER TABLE ".table($Q)."\n".implode(",\n",$sa).$xe):true);}function
alter_indexes($Q,$sa){foreach($sa
as$z=>$X)$sa[$z]=($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($Og){return
queries("DROP VIEW ".implode(", ",array_map('table',$Og)));}function
drop_tables($S){return
queries("DROP TABLE ".implode(", ",array_map('table',$S)));}function
move_tables($S,$Og,$Yf){$ff=array();foreach(array_merge($S,$Og)as$Q)$ff[]=table($Q)." TO ".idf_escape($Yf).".".table($Q);return
queries("RENAME TABLE ".implode(", ",$ff));}function
copy_tables($S,$Og,$Yf){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($S
as$Q){$F=($Yf==DB?table("copy_$Q"):idf_escape($Yf).".".table($Q));if(!queries("\nDROP TABLE IF EXISTS $F")||!queries("CREATE TABLE $F LIKE ".table($Q))||!queries("INSERT INTO $F SELECT * FROM ".table($Q)))return
false;}foreach($Og
as$Q){$F=($Yf==DB?table("copy_$Q"):idf_escape($Yf).".".table($Q));$Ng=view($Q);if(!queries("DROP VIEW IF EXISTS $F")||!queries("CREATE VIEW $F AS $Ng[select]"))return
false;}return
true;}function
trigger($F){if($F=="")return
array();$M=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($F));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($F,$U){global$g,$Vb,$Pc,$wg;$qa=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$vg="((".implode("|",array_merge(array_keys($wg),$qa)).")\\b(?:\\s*\\(((?:[^'\")]|$Vb)++)\\))?\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$Be="\\s*(".($U=="FUNCTION"?"":$Pc).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$vg";$i=$g->result("SHOW CREATE $U ".idf_escape($F),2);preg_match("~\\(((?:$Be\\s*,?)*)\\)\\s*".($U=="FUNCTION"?"RETURNS\\s+$vg\\s+":"")."(.*)~is",$i,$C);$o=array();preg_match_all("~$Be\\s*,?~is",$C[1],$vd,PREG_SET_ORDER);foreach($vd
as$se){$F=str_replace("``","`",$se[2]).$se[3];$o[]=array("field"=>$F,"type"=>strtolower($se[5]),"length"=>preg_replace_callback("~$Vb~s",'normalize_enum',$se[6]),"unsigned"=>strtolower(preg_replace('~\\s+~',' ',trim("$se[8] $se[7]"))),"null"=>1,"full_type"=>$se[4],"inout"=>strtoupper($se[1]),"collation"=>strtolower($se[9]),);}if($U!="FUNCTION")return
array("fields"=>$o,"definition"=>$C[11]);return
array("fields"=>$o,"returns"=>array("type"=>$C[12],"length"=>$C[13],"unsigned"=>$C[15],"collation"=>$C[16]),"definition"=>$C[17],"language"=>"SQL",);}function
routines(){return
get_rows("SELECT ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ".q(DB));}function
routine_languages(){return
array();}function
last_id(){global$g;return$g->result("SELECT LAST_INSERT_ID()");}function
explain($g,$I){return$g->query("EXPLAIN ".($g->server_info>=5.1?"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($rf){return
true;}function
create_sql($Q,$ya){global$g;$K=$g->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($qb){return"USE ".idf_escape($qb);}function
trigger_sql($Q,$Lf){$K="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($Q,"%_\\")),null,"-- ")as$L)$K.="\n".($Lf=='CREATE+ALTER'?"DROP TRIGGER IF EXISTS ".idf_escape($L["Trigger"]).";;\n":"")."CREATE 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($n){if(preg_match("~binary~",$n["type"]))return"HEX(".idf_escape($n["field"]).")";if($n["type"]=="bit")return"BIN(".idf_escape($n["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$n["type"]))return"AsWKT(".idf_escape($n["field"]).")";}function
unconvert_field($n,$K){if(preg_match("~binary~",$n["type"]))$K="UNHEX($K)";if($n["type"]=="bit")$K="CONV($K, 2, 10) + 0";if(preg_match("~geometry|point|linestring|polygon~",$n["type"]))$K="GeomFromText($K)";return$K;}function
support($kc){global$g;return!preg_match("~scheme|sequence|type|view_trigger".($g->server_info<5.1?"|event|partitioning".($g->server_info<5?"|routine|trigger|view":""):"")."~",$kc);}$y="sql";$wg=array();$Kf=array();foreach(array(lang(21)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(22)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(23)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(24)=>array("enum"=>65535,"set"=>64),lang(25)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(26)=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),)as$z=>$X){$wg+=$X;$Kf[$z]=array_keys($X);}$Cg=array("unsigned","zerofill","unsigned zerofill");$de=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL");$xc=array("char_length","date","from_unixtime","lower","round","sec_to_time","time_to_sec","upper");$_c=array("avg","count","count distinct","group_concat","max","min","sum");$Lb=array(array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",),array("(^|[^o])int|float|double|decimal"=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",));}define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~^[^?]*/([^?]*).*~','\\1',$_SERVER["REQUEST_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"])."&":""):''));$fa="4.2.1";class
Adminer{var$operators;function
name(){return"<a href='http://www.adminer.org/' target='_blank' id='h1'>Adminer</a>";}function
credentials(){return
array(SERVER,$_GET["username"],get_password());}function
permanentLogin($i=false){return
password_file($i);}function
bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
database(){return
DB;}function
databases($qc=true){return
get_databases($qc);}function
schemas(){return
schemas();}function
queryTimeout(){return
5;}function
headers(){return
true;}function
head(){return
true;}function
loginForm(){global$Eb;echo'<table cellspacing="0">
<tr><th>',lang(27),'<td>',html_select("auth[driver]",$Eb,DRIVER,"loginDriver(this);"),'<tr><th>',lang(28),'<td><input name="auth[server]" value="',h(SERVER),'" title="hostname[:port]" placeholder="localhost" autocapitalize="off">
<tr><th>',lang(29),'<td><input name="auth[username]" id="username" value="',h($_GET["username"]),'" autocapitalize="off">
<tr><th>',lang(30),'<td><input type="password" name="auth[password]">
<tr><th>',lang(31),'<td><input name="auth[db]" value="',h($_GET["db"]);?>" autocapitalize="off">
</table>
<script type="text/javascript">
var username = document.getElementById('username');
focus(username);
username.form['auth[driver]'].onchange();
</script>
<?php
echo"<p><input type='submit' value='".lang(32)."'>\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],lang(33))."\n";}function
login($td,$_e){return
true;}function
tableName($Rf){return
h($Rf["Name"]);}function
fieldName($n,$he=0){return'<span title="'.h($n["full_type"]).'">'.h($n["field"]).'</span>';}function
selectLinks($Rf,$P=""){echo'<p class="links">';$sd=array("select"=>lang(34));if(support("table")||support("indexes"))$sd["table"]=lang(35);if(support("table")){if(is_view($Rf))$sd["view"]=lang(36);else$sd["create"]=lang(37);}if($P!==null)$sd["edit"]=lang(38);foreach($sd
as$z=>$X)echo" <a href='".h(ME)."$z=".urlencode($Rf["Name"]).($z=="edit"?$P:"")."'".bold(isset($_GET[$z])).">$X</a>";echo"\n";}function
foreignKeys($Q){return
foreign_keys($Q);}function
backwardKeys($Q,$Qf){return
array();}function
backwardKeysPrint($Aa,$L){}function
selectQuery($I,$eg){global$y;return"<p><code class='jush-$y'>".h(str_replace("\n"," ",$I))."</code> <span class='time'>($eg)</span>".(support("sql")?" <a href='".h(ME)."sql=".urlencode($I)."'>".lang(10)."</a>":"")."</p>";}function
rowDescription($Q){return"";}function
rowDescriptions($M,$sc){return$M;}function
selectLink($X,$n){}function
selectVal($X,$A,$n,$oe){$K=($X===null?"<i>NULL</i>":(preg_match("~char|binary~",$n["type"])&&!preg_match("~var~",$n["type"])?"<code>$X</code>":$X));if(preg_match('~blob|bytea|raw|file~',$n["type"])&&!is_utf8($X))$K=lang(39,strlen($oe));return($A?"<a href='".h($A)."'".(is_url($A)?" rel='noreferrer'":"").">$K</a>":$K);}function
editVal($X,$n){return$X;}function
selectColumnsPrint($N,$e){global$xc,$_c;print_fieldset("select",lang(40),$N);$v=0;$N[""]=array();foreach($N
as$z=>$X){$X=$_GET["columns"][$z];$d=select_input(" name='columns[$v][col]' onchange='".($z!==""?"selectFieldChange(this.form)":"selectAddRow(this)").";'",$e,$X["col"]);echo"<div>".($xc||$_c?"<select name='columns[$v][fun]' onchange='helpClose();".($z!==""?"":" this.nextSibling.nextSibling.onchange();")."'".on_help("getTarget(event).value && getTarget(event).value.replace(/ |\$/, '(') + ')'",1).">".optionlist(array(-1=>"")+array_filter(array(lang(41)=>$xc,lang(42)=>$_c)),$X["fun"])."</select>"."($d)":$d)."</div>\n";$v++;}echo"</div></fieldset>\n";}function
selectSearchPrint($Z,$e,$x){print_fieldset("search",lang(43),$Z);foreach($x
as$v=>$w){if($w["type"]=="FULLTEXT"){echo"(<i>".implode("</i>, <i>",array_map('h',$w["columns"]))."</i>) AGAINST"," <input type='search' name='fulltext[$v]' value='".h($_GET["fulltext"][$v])."' onchange='selectFieldChange(this.form);'>",checkbox("boolean[$v]",1,isset($_GET["boolean"][$v]),"BOOL"),"<br>\n";}}$_GET["where"]=(array)$_GET["where"];reset($_GET["where"]);$Ka="this.nextSibling.onchange();";for($v=0;$v<=count($_GET["where"]);$v++){list(,$X)=each($_GET["where"]);if(!$X||("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators))){echo"<div>".select_input(" name='where[$v][col]' onchange='$Ka'",$e,$X["col"],"(".lang(44).")"),html_select("where[$v][op]",$this->operators,$X["op"],$Ka),"<input type='search' name='where[$v][val]' value='".h($X["val"])."' onchange='".($X?"selectFieldChange(this.form)":"selectAddRow(this)").";' onkeydown='selectSearchKeydown(this, event);' onsearch='selectSearchSearch(this);'></div>\n";}}echo"</div></fieldset>\n";}function
selectOrderPrint($he,$e,$x){print_fieldset("sort",lang(45),$he);$v=0;foreach((array)$_GET["order"]as$z=>$X){if($X!=""){echo"<div>".select_input(" name='order[$v]' onchange='selectFieldChange(this.form);'",$e,$X),checkbox("desc[$v]",1,isset($_GET["desc"][$z]),lang(46))."</div>\n";$v++;}}echo"<div>".select_input(" name='order[$v]' onchange='selectAddRow(this);'",$e),checkbox("desc[$v]",1,false,lang(46))."</div>\n","</div></fieldset>\n";}function
selectLimitPrint($_){echo"<fieldset><legend>".lang(47)."</legend><div>";echo"<input type='number' name='limit' class='size' value='".h($_)."' onchange='selectFieldChange(this.form);'>","</div></fieldset>\n";}function
selectLengthPrint($dg){if($dg!==null){echo"<fieldset><legend>".lang(48)."</legend><div>","<input type='number' name='text_length' class='size' value='".h($dg)."'>","</div></fieldset>\n";}}function
selectActionPrint($x){echo"<fieldset><legend>".lang(49)."</legend><div>","<input type='submit' value='".lang(40)."'>"," <span id='noindex' title='".lang(50)."'></span>","<script type='text/javascript'>\n","var indexColumns = ";$e=array();foreach($x
as$w){if($w["type"]!="FULLTEXT")$e[reset($w["columns"])]=1;}$e[""]=1;foreach($e
as$z=>$X)json_row($z);echo";\n","selectFieldChange(document.getElementById('form'));\n","</script>\n","</div></fieldset>\n";}function
selectCommandPrint(){return!information_schema(DB);}function
selectImportPrint(){return!information_schema(DB);}function
selectEmailPrint($Qb,$e){}function
selectColumnsProcess($e,$x){global$xc,$_c;$N=array();$u=array();foreach((array)$_GET["columns"]as$z=>$X){if($X["fun"]=="count"||($X["col"]!=""&&(!$X["fun"]||in_array($X["fun"],$xc)||in_array($X["fun"],$_c)))){$N[$z]=apply_sql_function($X["fun"],($X["col"]!=""?idf_escape($X["col"]):"*"));if(!in_array($X["fun"],$_c))$u[]=$N[$z];}}return
array($N,$u);}function
selectSearchProcess($o,$x){global$g,$y;$K=array();foreach($x
as$v=>$w){if($w["type"]=="FULLTEXT"&&$_GET["fulltext"][$v]!="")$K[]="MATCH (".implode(", ",array_map('idf_escape',$w["columns"])).") AGAINST (".q($_GET["fulltext"][$v]).(isset($_GET["boolean"][$v])?" IN BOOLEAN MODE":"").")";}foreach((array)$_GET["where"]as$X){if("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators)){$db=" $X[op]";if(preg_match('~IN$~',$X["op"])){$Mc=process_length($X["val"]);$db.=" ".($Mc!=""?$Mc:"(NULL)");}elseif($X["op"]=="SQL")$db=" $X[val]";elseif($X["op"]=="LIKE %%")$db=" LIKE ".$this->processInput($o[$X["col"]],"%$X[val]%");elseif($X["op"]=="ILIKE %%")$db=" ILIKE ".$this->processInput($o[$X["col"]],"%$X[val]%");elseif(!preg_match('~NULL$~',$X["op"]))$db.=" ".$this->processInput($o[$X["col"]],$X["val"]);if($X["col"]!="")$K[]=idf_escape($X["col"]).$db;else{$Ya=array();foreach($o
as$F=>$n){$Yc=preg_match('~char|text|enum|set~',$n["type"]);if((is_numeric($X["val"])||!preg_match('~(^|[^o])int|float|double|decimal|bit~',$n["type"]))&&(!preg_match("~[\x80-\xFF]~",$X["val"])||$Yc)){$F=idf_escape($F);$Ya[]=($y=="sql"&&$Yc&&!preg_match("~^utf8_~",$n["collation"])?"CONVERT($F USING ".charset($g).")":$F);}}$K[]=($Ya?"(".implode("$db OR ",$Ya)."$db)":"0");}}}return$K;}function
selectOrderProcess($o,$x){$K=array();foreach((array)$_GET["order"]as$z=>$X){if($X!="")$K[]=(preg_match('~^((COUNT\\(DISTINCT |[A-Z0-9_]+\\()(`(?:[^`]|``)+`|"(?:[^"]|"")+")\\)|COUNT\\(\\*\\))$~',$X)?$X:idf_escape($X)).(isset($_GET["desc"][$z])?" 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,$sc){return
false;}function
selectQueryBuild($N,$Z,$u,$he,$_,$G){return"";}function
messageQuery($I,$eg){global$y;restart_session();$Ec=&get_session("queries");$Ic="sql-".count($Ec[$_GET["db"]]);if(strlen($I)>1e6)$I=preg_replace('~[\x80-\xFF]+$~','',substr($I,0,1e6))."\n...";$Ec[$_GET["db"]][]=array($I,time(),$eg);return" <span class='time'>".@date("H:i:s")."</span> <a href='#$Ic' onclick=\"return !toggle('$Ic');\">".lang(51)."</a>"."<div id='$Ic' class='hidden'><pre><code class='jush-$y'>".shorten_utf8($I,1000).'</code></pre>'.($eg?" <span class='time'>($eg)</span>":'').(support("sql")?'<p><a href="'.h(str_replace("db=".urlencode(DB),"db=".urlencode($_GET["db"]),ME).'sql=&history='.(count($Ec[$_GET["db"]])-1)).'">'.lang(10).'</a>':'').'</div>';}function
editFunctions($n){global$Lb;$K=($n["null"]?"NULL/":"");foreach($Lb
as$z=>$xc){if(!$z||(!isset($_GET["call"])&&(isset($_GET["select"])||where($_GET)))){foreach($xc
as$Be=>$X){if(!$Be||preg_match("~$Be~",$n["type"]))$K.="/$X";}if($z&&!preg_match('~set|blob|bytea|raw|file~',$n["type"]))$K.="/SQL";}}if($n["auto_increment"]&&!isset($_GET["select"])&&!where($_GET))$K=lang(52);return
explode("/",$K);}function
editInput($Q,$n,$wa,$Y){if($n["type"]=="enum")return(isset($_GET["select"])?"<label><input type='radio'$wa value='-1' checked><i>".lang(8)."</i></label> ":"").($n["null"]?"<label><input type='radio'$wa value=''".($Y!==null||isset($_GET["select"])?"":" checked")."><i>NULL</i></label> ":"").enum_input("radio",$wa,$n,$Y,0);return"";}function
processInput($n,$Y,$s=""){if($s=="SQL")return$Y;$F=$n["field"];$K=q($Y);if(preg_match('~^(now|getdate|uuid)$~',$s))$K="$s()";elseif(preg_match('~^current_(date|timestamp)$~',$s))$K=$s;elseif(preg_match('~^([+-]|\\|\\|)$~',$s))$K=idf_escape($F)." $s $K";elseif(preg_match('~^[+-] interval$~',$s))$K=idf_escape($F)." $s ".(preg_match("~^(\\d+|'[0-9.: -]') [A-Z_]+$~i",$Y)?$Y:$K);elseif(preg_match('~^(addtime|subtime|concat)$~',$s))$K="$s(".idf_escape($F).", $K)";elseif(preg_match('~^(md5|sha1|password|encrypt)$~',$s))$K="$s($K)";return
unconvert_field($n,$K);}function
dumpOutput(){$K=array('text'=>lang(53),'file'=>lang(54));if(function_exists('gzencode'))$K['gz']='gzip';return$K;}function
dumpFormat(){return
array('sql'=>'SQL','csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
dumpDatabase($k){}function
dumpTable($Q,$Lf,$Zc=0){if($_POST["format"]!="sql"){echo"\xef\xbb\xbf";if($Lf)dump_csv(array_keys(fields($Q)));}else{if($Zc==2){$o=array();foreach(fields($Q)as$F=>$n)$o[]=idf_escape($F)." $n[full_type]";$i="CREATE TABLE ".table($Q)." (".implode(", ",$o).")";}else$i=create_sql($Q,$_POST["auto_increment"]);set_utf8mb4($i);if($Lf&&$i){if($Lf=="DROP+CREATE"||$Zc==1)echo"DROP ".($Zc==2?"VIEW":"TABLE")." IF EXISTS ".table($Q).";\n";if($Zc==1)$i=remove_definer($i);echo"$i;\n\n";}}}function
dumpData($Q,$Lf,$I){global$g,$y;$xd=($y=="sqlite"?0:1048576);if($Lf){if($_POST["format"]=="sql"){if($Lf=="TRUNCATE+INSERT")echo
truncate_sql($Q).";\n";$o=fields($Q);}$J=$g->query($I,1);if($J){$Rc="";$Ia="";$cd=array();$Nf="";$lc=($Q!=''?'fetch_assoc':'fetch_row');while($L=$J->$lc()){if(!$cd){$Kg=array();foreach($L
as$X){$n=$J->fetch_field();$cd[]=$n->name;$z=idf_escape($n->name);$Kg[]="$z = VALUES($z)";}$Nf=($Lf=="INSERT+UPDATE"?"\nON DUPLICATE KEY UPDATE ".implode(", ",$Kg):"").";\n";}if($_POST["format"]!="sql"){if($Lf=="table"){dump_csv($cd);$Lf="INSERT";}dump_csv($L);}else{if(!$Rc)$Rc="INSERT INTO ".table($Q)." (".implode(", ",array_map('idf_escape',$cd)).") VALUES";foreach($L
as$z=>$X){$n=$o[$z];$L[$z]=($X!==null?unconvert_field($n,preg_match('~(^|[^o])int|float|double|decimal~',$n["type"])&&$X!=''?$X:q($X)):"NULL");}$pf=($xd?"\n":" ")."(".implode(",\t",$L).")";if(!$Ia)$Ia=$Rc.$pf;elseif(strlen($Ia)+4+strlen($pf)+strlen($Nf)<$xd)$Ia.=",$pf";else{echo$Ia.$Nf;$Ia=$Rc.$pf;}}}if($Ia)echo$Ia.$Nf;}elseif($_POST["format"]=="sql")echo"-- ".str_replace("\n"," ",$g->error)."\n";}}function
dumpFilename($Jc){return
friendly_url($Jc!=""?$Jc:(SERVER!=""?SERVER:"localhost"));}function
dumpHeaders($Jc,$Id=false){$qe=$_POST["output"];$gc=(preg_match('~sql~',$_POST["format"])?"sql":($Id?"tar":"csv"));header("Content-Type: ".($qe=="gz"?"application/x-gzip":($gc=="tar"?"application/x-tar":($gc=="sql"||$qe!="file"?"text/plain":"text/csv")."; charset=utf-8")));if($qe=="gz")ob_start('ob_gzencode',1e6);return$gc;}function
homepage(){echo'<p class="links">'.($_GET["ns"]==""&&support("database")?'<a href="'.h(ME).'database=">'.lang(55)."</a>\n":""),(support("scheme")?"<a href='".h(ME)."scheme='>".($_GET["ns"]!=""?lang(56):lang(57))."</a>\n":""),($_GET["ns"]!==""?'<a href="'.h(ME).'schema=">'.lang(58)."</a>\n":""),(support("privileges")?"<a href='".h(ME)."privileges='>".lang(59)."</a>\n":"");return
true;}function
navigation($Hd){global$fa,$y,$Eb,$g;echo'<h1>
',$this->name(),' <span class="version">',$fa,'</span>
<a href="http://www.adminer.org/#download" target="_blank" id="version">',(version_compare($fa,$_COOKIE["adminer_version"])<0?h($_COOKIE["adminer_version"]):""),'</a>
</h1>
';if($Hd=="auth"){$pc=true;foreach((array)$_SESSION["pwds"]as$Mg=>$zf){foreach($zf
as$O=>$Ig){foreach($Ig
as$V=>$_e){if($_e!==null){if($pc){echo"<p id='logins' onmouseover='menuOver(this, event);' onmouseout='menuOut(this);'>\n";$pc=false;}$tb=$_SESSION["db"][$Mg][$O][$V];foreach(($tb?array_keys($tb):array(""))as$k)echo"<a href='".h(auth_url($Mg,$O,$V,$k))."'>($Eb[$Mg]) ".h($V.($O!=""?"@$O":"").($k!=""?" - $k":""))."</a><br>\n";}}}}}else{if($_GET["ns"]!==""&&!$Hd&&DB!=""){$g->select_db(DB);$S=table_status('',true);}if(support("sql")){echo'<script type="text/javascript" src="',h(preg_replace("~\\?.*~","",ME))."?file=jush.js&amp;version=4.2.1&amp;driver=mysql",'"></script>
<script type="text/javascript">
';if($S){$sd=array();foreach($S
as$Q=>$U)$sd[]=preg_quote($Q,'/');echo"var jushLinks = { $y: [ '".js_escape(ME).(support("table")?"table=":"select=")."\$&', /\\b(".implode("|",$sd).")\\b/g ] };\n";foreach(array("bac","bra","sqlite_quo","mssql_bra")as$X)echo"jushLinks.$X = jushLinks.$y;\n";}echo'bodyLoad(\'',(is_object($g)?substr($g->server_info,0,3):""),'\');
</script>
';}$this->databasesPrint($Hd);if(DB==""||!$Hd){echo"<p class='links'>".(support("sql")?"<a href='".h(ME)."sql='".bold(isset($_GET["sql"])&&!isset($_GET["import"])).">".lang(51)."</a>\n<a href='".h(ME)."import='".bold(isset($_GET["import"])).">".lang(60)."</a>\n":"")."";if(support("dump"))echo"<a href='".h(ME)."dump=".urlencode(isset($_GET["table"])?$_GET["table"]:$_GET["select"])."' id='dump'".bold(isset($_GET["dump"])).">".lang(61)."</a>\n";}if($_GET["ns"]!==""&&!$Hd&&DB!=""){echo'<a href="'.h(ME).'create="'.bold($_GET["create"]==="").">".lang(62)."</a>\n";if(!$S)echo"<p class='message'>".lang(9)."\n";else$this->tablesPrint($S);}}}function
databasesPrint($Hd){global$c,$g;$j=$this->databases();echo'<form action="">
<p id="dbs">
';hidden_fields_get();$rb=" onmousedown='dbMouseDown(event, this);' onchange='dbChange(this);'";echo"<span title='".lang(63)."'>DB</span>: ".($j?"<select name='db'$rb>".optionlist(array(""=>"")+$j,DB)."</select>":'<input name="db" value="'.h(DB).'" autocapitalize="off">'),"<input type='submit' value='".lang(20)."'".($j?" class='hidden'":"").">\n";if($Hd!="db"&&DB!=""&&$g->select_db(DB)){}echo(isset($_GET["sql"])?'<input type="hidden" name="sql" value="">':(isset($_GET["schema"])?'<input type="hidden" name="schema" value="">':(isset($_GET["dump"])?'<input type="hidden" name="dump" value="">':(isset($_GET["privileges"])?'<input type="hidden" name="privileges" value="">':"")))),"</p></form>\n";}function
tablesPrint($S){echo"<p id='tables' onmouseover='menuOver(this, event);' onmouseout='menuOut(this);'>\n";foreach($S
as$Q=>$Gf){echo'<a href="'.h(ME).'select='.urlencode($Q).'"'.bold($_GET["select"]==$Q||$_GET["edit"]==$Q,"select").">".lang(64)."</a> ";$F=$this->tableName($Gf);echo(support("table")||support("indexes")?'<a href="'.h(ME).'table='.urlencode($Q).'"'.bold(in_array($Q,array($_GET["table"],$_GET["create"],$_GET["indexes"],$_GET["foreign"],$_GET["trigger"])),(is_view($Gf)?"view":""),"structure")." title='".lang(35)."'>$F</a>":"<span>$F</span>")."<br>\n";}}}$c=(function_exists('adminer_object')?adminer_object():new
Adminer);if($c->operators===null)$c->operators=$de;function
page_header($hg,$m="",$Ha=array(),$ig=""){global$a,$fa,$c,$Eb,$y;page_headers();if(is_ajax()&&$m){page_messages($m);exit;}$jg=$hg.($ig!=""?": $ig":"");$kg=strip_tags($jg.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$c->name());echo'<!DOCTYPE html>
<html lang="',$a,'" dir="',lang(65),'">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Content-Script-Type" content="text/javascript">
<meta name="robots" content="noindex">
<meta name="referrer" content="origin-when-crossorigin">
<title>',$kg,'</title>
<link rel="stylesheet" type="text/css" href="',h(preg_replace("~\\?.*~","",ME))."?file=default.css&amp;version=4.2.1&amp;driver=mysql",'">
<script type="text/javascript" src="',h(preg_replace("~\\?.*~","",ME))."?file=functions.js&amp;version=4.2.1&amp;driver=mysql",'"></script>
';if($c->head()){echo'<link rel="shortcut icon" type="image/x-icon" href="',h(preg_replace("~\\?.*~","",ME))."?file=favicon.ico&amp;version=4.2.1&amp;driver=mysql",'">
<link rel="apple-touch-icon" href="',h(preg_replace("~\\?.*~","",ME))."?file=favicon.ico&amp;version=4.2.1&amp;driver=mysql",'">
';if(file_exists("adminer.css")){echo'<link rel="stylesheet" type="text/css" href="adminer.css">
';}}echo'
<body class="',lang(65),' nojs" onkeydown="bodyKeydown(event);" onclick="bodyClick(event);"',(isset($_COOKIE["adminer_version"])?"":" onload=\"verifyVersion('$fa');\"");?>>
<script type="text/javascript">
document.body.className = document.body.className.replace(/ nojs/, ' js');
var offlineMessage = '<?php echo
js_escape(lang(66)),'\';
</script>
<div id="help" class="jush-',$y,' jsonly hidden" onmouseover="helpOpen = 1;" onmouseout="helpMouseout(this, event);"></div>
<div id="content">
';if($Ha!==null){$A=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'<p id="breadcrumb"><a href="'.h($A?$A:".").'">'.$Eb[DRIVER].'</a> &raquo; ';$A=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$O=(SERVER!=""?h(SERVER):lang(28));if($Ha===false)echo"$O\n";else{echo"<a href='".($A?h($A):".")."' accesskey='1' title='Alt+Shift+1'>$O</a> &raquo; ";if($_GET["ns"]!=""||(DB!=""&&is_array($Ha)))echo'<a href="'.h($A."&db=".urlencode(DB).(support("scheme")?"&ns=":"")).'">'.h(DB).'</a> &raquo; ';if(is_array($Ha)){if($_GET["ns"]!="")echo'<a href="'.h(substr(ME,0,-1)).'">'.h($_GET["ns"]).'</a> &raquo; ';foreach($Ha
as$z=>$X){$xb=(is_array($X)?$X[1]:h($X));if($xb!="")echo"<a href='".h(ME."$z=").urlencode(is_array($X)?$X[0]:$X)."'>$xb</a> &raquo; ";}}echo"$hg\n";}}echo"<h2>$jg</h2>\n","<div id='ajaxstatus' class='jsonly hidden'></div>\n";restart_session();page_messages($m);$j=&get_session("dbs");if(DB!=""&&$j&&!in_array(DB,$j,true))$j=null;stop_session();define("PAGE_HEADER",1);}function
page_headers(){global$c;header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");if($c->headers()){header("X-Frame-Options: deny");header("X-XSS-Protection: 0");}}function
page_messages($m){$Eg=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Fd=$_SESSION["messages"][$Eg];if($Fd){echo"<div class='message'>".implode("</div>\n<div class='message'>",$Fd)."</div>\n";unset($_SESSION["messages"][$Eg]);}if($m)echo"<div class='error'>$m</div>\n";}function
page_footer($Hd=""){global$c,$T;echo'</div>
';switch_lang();if($Hd!="auth"){echo'<form action="" method="post">
<p class="logout">
<input type="submit" name="logout" value="',lang(67),'" id="logout">
<input type="hidden" name="token" value="',$T,'">
</p>
</form>
';}echo'<div id="menu">
';$c->navigation($Hd);echo'</div>
<script type="text/javascript">setupSubmitHighlight(document);</script>
';}function
int32($E){while($E>=2147483648)$E-=4294967296;while($E<=-2147483649)$E+=4294967296;return(int)$E;}function
long2str($W,$Qg){$pf='';foreach($W
as$X)$pf.=pack('V',$X);if($Qg)return
substr($pf,0,end($W));return$pf;}function
str2long($pf,$Qg){$W=array_values(unpack('V*',str_pad($pf,4*ceil(strlen($pf)/4),"\0")));if($Qg)$W[]=strlen($pf);return$W;}function
xxtea_mx($Vg,$Ug,$Of,$bd){return
int32((($Vg>>5&0x7FFFFFF)^$Ug<<2)+(($Ug>>3&0x1FFFFFFF)^$Vg<<4))^int32(($Of^$Ug)+($bd^$Vg));}function
encrypt_string($If,$z){if($If=="")return"";$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($If,true);$E=count($W)-1;$Vg=$W[$E];$Ug=$W[0];$H=floor(6+52/($E+1));$Of=0;while($H-->0){$Of=int32($Of+0x9E3779B9);$Kb=$Of>>2&3;for($re=0;$re<$E;$re++){$Ug=$W[$re+1];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Vg=int32($W[$re]+$Jd);$W[$re]=$Vg;}$Ug=$W[0];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Vg=int32($W[$E]+$Jd);$W[$E]=$Vg;}return
long2str($W,false);}function
decrypt_string($If,$z){if($If=="")return"";if(!$z)return
false;$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($If,false);$E=count($W)-1;$Vg=$W[$E];$Ug=$W[0];$H=floor(6+52/($E+1));$Of=int32($H*0x9E3779B9);while($Of){$Kb=$Of>>2&3;for($re=$E;$re>0;$re--){$Vg=$W[$re-1];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Ug=int32($W[$re]-$Jd);$W[$re]=$Ug;}$Vg=$W[$E];$Jd=xxtea_mx($Vg,$Ug,$Of,$z[$re&3^$Kb]);$Ug=int32($W[0]-$Jd);$W[0]=$Ug;$Of=int32($Of-0x9E3779B9);}return
long2str($W,true);}$g='';$Dc=$_SESSION["token"];if(!$Dc)$_SESSION["token"]=rand(1,1e6);$T=get_token();$Ce=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($z)=explode(":",$X);$Ce[$z]=$X;}}function
add_invalid_login(){global$c;$nc=get_temp_dir()."/adminer.invalid";$r=@fopen($nc,"r+");if(!$r){$r=@fopen($nc,"w");if(!$r)return;}flock($r,LOCK_EX);$Uc=unserialize(stream_get_contents($r));$eg=time();if($Uc){foreach($Uc
as$Vc=>$X){if($X[0]<$eg)unset($Uc[$Vc]);}}$Tc=&$Uc[$c->bruteForceKey()];if(!$Tc)$Tc=array($eg+30*60,0);$Tc[1]++;$xf=serialize($Uc);rewind($r);fwrite($r,$xf);ftruncate($r,strlen($xf));flock($r,LOCK_UN);fclose($r);}$xa=$_POST["auth"];if($xa){$Uc=unserialize(@file_get_contents(get_temp_dir()."/adminer.invalid"));$Tc=$Uc[$c->bruteForceKey()];$Od=($Tc[1]>30?$Tc[0]-time():0);if($Od>0)auth_error(lang(68,ceil($Od/60)));session_regenerate_id();$Mg=$xa["driver"];$O=$xa["server"];$V=$xa["username"];$_e=(string)$xa["password"];$k=$xa["db"];set_password($Mg,$O,$V,$_e);$_SESSION["db"][$Mg][$O][$V][$k]=true;if($xa["permanent"]){$z=base64_encode($Mg)."-".base64_encode($O)."-".base64_encode($V)."-".base64_encode($k);$Ne=$c->permanentLogin(true);$Ce[$z]="$z:".base64_encode($Ne?encrypt_string($_e,$Ne):"");cookie("adminer_permanent",implode(" ",$Ce));}if(count($_POST)==1||DRIVER!=$Mg||SERVER!=$O||$_GET["username"]!==$V||DB!=$k)redirect(auth_url($Mg,$O,$V,$k));}elseif($_POST["logout"]){if($Dc&&!verify_token()){page_header(lang(67),lang(69));page_footer("db");exit;}else{foreach(array("pwds","db","dbs","queries")as$z)set_session($z,null);unset_permanent();redirect(substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1),lang(70));}}elseif($Ce&&!$_SESSION["pwds"]){session_regenerate_id();$Ne=$c->permanentLogin();foreach($Ce
as$z=>$X){list(,$Qa)=explode(":",$X);list($Mg,$O,$V,$k)=array_map('base64_decode',explode("-",$z));set_password($Mg,$O,$V,decrypt_string(base64_decode($Qa),$Ne));$_SESSION["db"][$Mg][$O][$V][$k]=true;}}function
unset_permanent(){global$Ce;foreach($Ce
as$z=>$X){list($Mg,$O,$V,$k)=array_map('base64_decode',explode("-",$z));if($Mg==DRIVER&&$O==SERVER&&$V==$_GET["username"]&&$k==DB)unset($Ce[$z]);}cookie("adminer_permanent",implode(" ",$Ce));}function
auth_error($m){global$c,$Dc;$m=h($m);$_f=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$_f]||$_GET[$_f])&&!$Dc)$m=lang(71);else{add_invalid_login();$_e=get_password();if($_e!==null){if($_e===false)$m.='<br>'.lang(72,'<code>permanentLogin()</code>');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent();}}if(!$_COOKIE[$_f]&&$_GET[$_f]&&ini_bool("session.use_only_cookies"))$m=lang(73);$te=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?$_COOKIE["adminer_key"]:rand_string()),$te["lifetime"]);page_header(lang(32),$m,null);echo"<form action='' method='post'>\n";$c->loginForm();echo"<div>";hidden_fields($_POST,array("auth"));echo"</div>\n","</form>\n";page_footer("auth");exit;}if(isset($_GET["username"])){if(!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header(lang(74),lang(75,implode(", ",$Ie)),false);page_footer("auth");exit;}$g=connect();}$l=new
Min_Driver($g);if(!is_object($g)||!$c->login($_GET["username"],get_password()))auth_error((is_string($g)?$g:lang(76)));if($xa&&$_POST["token"])$_POST["token"]=$T;$m='';if($_POST){if(!verify_token()){$Oc="max_input_vars";$Ad=ini_get($Oc);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$z){$X=ini_get($z);if($X&&(!$Ad||$X<$Ad)){$Oc=$z;$Ad=$X;}}}$m=(!$_POST["token"]&&$Ad?lang(77,"'$Oc'"):lang(69).' '.lang(78));}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$m=lang(79,"'post_max_size'");if(isset($_GET["sql"]))$m.=' '.lang(80);}if(!ini_bool("session.use_cookies")||@ini_set("session.use_cookies",false)!==false)session_write_close();function
select($J,$h=null,$ke=array(),$_=0){global$y;$sd=array();$x=array();$e=array();$Fa=array();$wg=array();$K=array();odd('');for($v=0;(!$_||$v<$_)&&($L=$J->fetch_row());$v++){if(!$v){echo"<table cellspacing='0' class='nowrap'>\n","<thead><tr>";for($ad=0;$ad<count($L);$ad++){$n=$J->fetch_field();$F=$n->name;$je=$n->orgtable;$ie=$n->orgname;$K[$n->table]=$je;if($ke&&$y=="sql")$sd[$ad]=($F=="table"?"table=":($F=="possible_keys"?"indexes=":null));elseif($je!=""){if(!isset($x[$je])){$x[$je]=array();foreach(indexes($je,$h)as$w){if($w["type"]=="PRIMARY"){$x[$je]=array_flip($w["columns"]);break;}}$e[$je]=$x[$je];}if(isset($e[$je][$ie])){unset($e[$je][$ie]);$x[$je][$ie]=$ad;$sd[$ad]=$je;}}if($n->charsetnr==63)$Fa[$ad]=true;$wg[$ad]=$n->type;echo"<th".($je!=""||$n->name!=$ie?" title='".h(($je!=""?"$je.":"").$ie)."'":"").">".h($F).($ke?doc_link(array('sql'=>"explain-output.html#explain_".strtolower($F))):"");}echo"</thead>\n";}echo"<tr".odd().">";foreach($L
as$z=>$X){if($X===null)$X="<i>NULL</i>";elseif($Fa[$z]&&!is_utf8($X))$X="<i>".lang(39,strlen($X))."</i>";elseif(!strlen($X))$X="&nbsp;";else{$X=h($X);if($wg[$z]==254)$X="<code>$X</code>";}if(isset($sd[$z])&&!$e[$sd[$z]]){if($ke&&$y=="sql"){$Q=$L[array_search("table=",$sd)];$A=$sd[$z].urlencode($ke[$Q]!=""?$ke[$Q]:$Q);}else{$A="edit=".urlencode($sd[$z]);foreach($x[$sd[$z]]as$Ua=>$ad)$A.="&where".urlencode("[".bracket_escape($Ua)."]")."=".urlencode($L[$ad]);}$X="<a href='".h(ME.$A)."'>$X</a>";}echo"<td>$X";}}echo($v?"</table>":"<p class='message'>".lang(12))."\n";return$K;}function
referencable_primary($vf){$K=array();foreach(table_status('',true)as$Sf=>$Q){if($Sf!=$vf&&fk_support($Q)){foreach(fields($Sf)as$n){if($n["primary"]){if($K[$Sf]){unset($K[$Sf]);break;}$K[$Sf]=$n;}}}}return$K;}function
textarea($F,$Y,$M=10,$Ya=80){global$y;echo"<textarea name='$F' rows='$M' cols='$Ya' class='sqlarea jush-$y' spellcheck='false' wrap='off'>";if(is_array($Y)){foreach($Y
as$X)echo
h($X[0])."\n\n\n";}else
echo
h($Y);echo"</textarea>";}function
edit_type($z,$n,$Xa,$q=array()){global$Kf,$wg,$Cg,$Zd;$U=$n["type"];echo'<td><select name="',$z,'[type]" class="type" onfocus="lastType = selectValue(this);" onchange="editingTypeChange(this);"',on_help("getTarget(event).value",1),'>';if($U&&!isset($wg[$U])&&!isset($q[$U]))array_unshift($Kf,$U);if($q)$Kf[lang(81)]=$q;echo
optionlist($Kf,$U),'</select>
<td><input name="',$z,'[length]" value="',h($n["length"]),'" size="3" onfocus="editingLengthFocus(this);"',(!$n["length"]&&preg_match('~var(char|binary)$~',$U)?" class='required'":""),' onchange="editingLengthChange(this);" onkeyup="this.onchange();"><td class="options">';echo"<select name='$z"."[collation]'".(preg_match('~(char|text|enum|set)$~',$U)?"":" class='hidden'").'><option value="">('.lang(82).')'.optionlist($Xa,$n["collation"]).'</select>',($Cg?"<select name='$z"."[unsigned]'".(!$U||preg_match('~((^|[^o])int|float|double|decimal)$~',$U)?"":" class='hidden'").'><option>'.optionlist($Cg,$n["unsigned"]).'</select>':''),(isset($n['on_update'])?"<select name='$z"."[on_update]'".(preg_match('~timestamp|datetime~',$U)?"":" class='hidden'").'>'.optionlist(array(""=>"(".lang(83).")","CURRENT_TIMESTAMP"),$n["on_update"]).'</select>':''),($q?"<select name='$z"."[on_delete]'".(preg_match("~`~",$U)?"":" class='hidden'")."><option value=''>(".lang(84).")".optionlist(explode("|",$Zd),$n["on_delete"])."</select> ":" ");}function
process_length($od){global$Vb;return(preg_match("~^\\s*\\(?\\s*$Vb(?:\\s*,\\s*$Vb)*+\\s*\\)?\\s*\$~",$od)&&preg_match_all("~$Vb~",$od,$vd)?"(".implode(",",$vd[0]).")":preg_replace('~^[0-9].*~','(\0)',preg_replace('~[^-0-9,+()[\]]~','',$od)));}function
process_type($n,$Va="COLLATE"){global$Cg;return" $n[type]".process_length($n["length"]).(preg_match('~(^|[^o])int|float|double|decimal~',$n["type"])&&in_array($n["unsigned"],$Cg)?" $n[unsigned]":"").(preg_match('~char|text|enum|set~',$n["type"])&&$n["collation"]?" $Va ".q($n["collation"]):"");}function
process_field($n,$ug){global$y;$vb=$n["default"];return
array(idf_escape(trim($n["field"])),process_type($ug),($n["null"]?" NULL":" NOT NULL"),(isset($vb)?" DEFAULT ".((preg_match('~time~',$n["type"])&&preg_match('~^CURRENT_TIMESTAMP$~i',$vb))||($y=="sqlite"&&preg_match('~^CURRENT_(TIME|TIMESTAMP|DATE)$~i',$vb))||($n["type"]=="bit"&&preg_match("~^([0-9]+|b'[0-1]+')\$~",$vb))||($y=="pgsql"&&preg_match("~^[a-z]+\\(('[^']*')+\\)\$~",$vb))?$vb:q($vb)):""),(preg_match('~timestamp|datetime~',$n["type"])&&$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(preg_match("~$z|$X~",$U))return" class='$z'";}}function
edit_fields($o,$Xa,$U="TABLE",$q=array(),$cb=false){global$g,$Pc;echo'<thead><tr class="wrap">
';if($U=="PROCEDURE"){echo'<td>&nbsp;';}echo'<th>',($U=="TABLE"?lang(85):lang(86)),'<td>',lang(87),'<textarea id="enum-edit" rows="4" cols="12" wrap="off" style="display: none;" onblur="editingLengthBlur(this);"></textarea>
<td>',lang(88),'<td>',lang(89);if($U=="TABLE"){echo'<td>NULL
<td><input type="radio" name="auto_increment_col" value=""><acronym title="',lang(52),'">AI</acronym>',doc_link(array('sql'=>"example-auto-increment.html",'sqlite'=>"autoinc.html",'pgsql'=>"datatype.html#DATATYPE-SERIAL",'mssql'=>"ms186775.aspx",)),'<td>',lang(90),(support("comment")?"<td".($cb?"":" class='hidden'").">".lang(91):"");}echo'<td>',"<input type='image' class='icon' name='add[".(support("move_col")?0:count($o))."]' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.1&amp;driver=mysql' alt='+' title='".lang(92)."'>",'<script type="text/javascript">row_count = ',count($o),';</script>
</thead>
<tbody onkeydown="return editingKeydown(event);">
';foreach($o
as$v=>$n){$v++;$le=$n[($_POST?"orig":"field")];$Ab=(isset($_POST["add"][$v-1])||(isset($n["field"])&&!$_POST["drop_col"][$v]))&&(support("drop_col")||$le=="");echo'<tr',($Ab?"":" style='display: none;'"),'>
',($U=="PROCEDURE"?"<td>".html_select("fields[$v][inout]",explode("|",$Pc),$n["inout"]):""),'<th>';if($Ab){echo'<input name="fields[',$v,'][field]" value="',h($n["field"]),'" onchange="editingNameChange(this);',($n["field"]!=""||count($o)>1?'':' editingAddRow(this);" onkeyup="if (this.value) editingAddRow(this);'),'" maxlength="64" autocapitalize="off">';}echo'<input type="hidden" name="fields[',$v,'][orig]" value="',h($le),'">
';edit_type("fields[$v]",$n,$Xa,$q);if($U=="TABLE"){echo'<td>',checkbox("fields[$v][null]",1,$n["null"],"","","block"),'<td><label class="block"><input type="radio" name="auto_increment_col" value="',$v,'"';if($n["auto_increment"]){echo' checked';}?> onclick="var field = this.form['fields[' + this.value + '][field]']; if (!field.value) { field.value = 'id'; field.onchange(); }"></label><td><?php
echo
checkbox("fields[$v][has_default]",1,$n["has_default"]),'<input name="fields[',$v,'][default]" value="',h($n["default"]),'" onkeyup="keyupChange.call(this);" onchange="this.previousSibling.checked = true;">
',(support("comment")?"<td".($cb?"":" class='hidden'")."><input name='fields[$v][comment]' value='".h($n["comment"])."' maxlength='".($g->server_info>=5.5?1024:255)."'>":"");}echo"<td>",(support("move_col")?"<input type='image' class='icon' name='add[$v]' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.1&amp;driver=mysql' alt='+' title='".lang(92)."' onclick='return !editingAddRow(this, 1);'>&nbsp;"."<input type='image' class='icon' name='up[$v]' src='".h(preg_replace("~\\?.*~","",ME))."?file=up.gif&amp;version=4.2.1&amp;driver=mysql' alt='^' title='".lang(93)."'>&nbsp;"."<input type='image' class='icon' name='down[$v]' src='".h(preg_replace("~\\?.*~","",ME))."?file=down.gif&amp;version=4.2.1&amp;driver=mysql' alt='v' title='".lang(94)."'>&nbsp;":""),($le==""||support("drop_col")?"<input type='image' class='icon' name='drop_col[$v]' src='".h(preg_replace("~\\?.*~","",ME))."?file=cross.gif&amp;version=4.2.1&amp;driver=mysql' alt='x' title='".lang(95)."' onclick=\"return !editingRemoveRow(this, 'fields\$1[field]');\">":""),"\n";}}function
process_fields(&$o){ksort($o);$Sd=0;if($_POST["up"]){$id=0;foreach($o
as$z=>$n){if(key($_POST["up"])==$z){unset($o[$z]);array_splice($o,$id,0,array($n));break;}if(isset($n["field"]))$id=$Sd;$Sd++;}}elseif($_POST["down"]){$uc=false;foreach($o
as$z=>$n){if(isset($n["field"])&&$uc){unset($o[key($_POST["down"])]);array_splice($o,$Sd,0,array($uc));break;}if(key($_POST["down"])==$z)$uc=$n;$Sd++;}}elseif($_POST["add"]){$o=array_values($o);array_splice($o,key($_POST["add"]),0,array(array()));}elseif(!$_POST["drop_col"])return
false;return
true;}function
normalize_enum($C){return"'".str_replace("'","''",addcslashes(stripcslashes(str_replace($C[0][0].$C[0][0],$C[0][0],substr($C[0],1,-1))),'\\'))."'";}function
grant($t,$Pe,$e,$Yd){if(!$Pe)return
true;if($Pe==array("ALL PRIVILEGES","GRANT OPTION"))return($t=="GRANT"?queries("$t ALL PRIVILEGES$Yd WITH GRANT OPTION"):queries("$t ALL PRIVILEGES$Yd")&&queries("$t GRANT OPTION$Yd"));return
queries("$t ".preg_replace('~(GRANT OPTION)\\([^)]*\\)~','\\1',implode("$e, ",$Pe).$e).$Yd);}function
drop_create($Fb,$i,$Gb,$bg,$Hb,$B,$Ed,$Cd,$Dd,$Vd,$Md){if($_POST["drop"])query_redirect($Fb,$B,$Ed);elseif($Vd=="")query_redirect($i,$B,$Dd);elseif($Vd!=$Md){$lb=queries($i);queries_redirect($B,$Cd,$lb&&queries($Fb));if($lb)queries($Gb);}else
queries_redirect($B,$Cd,queries($bg)&&queries($Hb)&&queries($Fb)&&queries($i));}function
create_trigger($Yd,$L){global$y;$gg=" $L[Timing] $L[Event]".($L["Event"]=="UPDATE OF"?" ".idf_escape($L["Of"]):"");return"CREATE TRIGGER ".idf_escape($L["Trigger"]).($y=="mssql"?$Yd.$gg:$gg.$Yd).rtrim(" $L[Type]\n$L[Statement]",";").";";}function
create_routine($mf,$L){global$Pc;$P=array();$o=(array)$L["fields"];ksort($o);foreach($o
as$n){if($n["field"]!="")$P[]=(preg_match("~^($Pc)\$~",$n["inout"])?"$n[inout] ":"").idf_escape($n["field"]).process_type($n,"CHARACTER SET");}return"CREATE $mf ".idf_escape(trim($L["name"]))." (".implode(", ",$P).")".(isset($_GET["function"])?" RETURNS".process_type($L["returns"],"CHARACTER SET"):"").($L["language"]?" LANGUAGE $L[language]":"").rtrim("\n$L[definition]",";").";";}function
remove_definer($I){return
preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\\1)',logged_user()).'`~','\\1',$I);}function
format_foreign_key($p){global$Zd;return" FOREIGN KEY (".implode(", ",array_map('idf_escape',$p["source"])).") REFERENCES ".table($p["table"])." (".implode(", ",array_map('idf_escape',$p["target"])).")".(preg_match("~^($Zd)\$~",$p["on_delete"])?" ON DELETE $p[on_delete]":"").(preg_match("~^($Zd)\$~",$p["on_update"])?" ON UPDATE $p[on_update]":"");}function
tar_file($nc,$lg){$K=pack("a100a8a8a8a12a12",$nc,644,0,0,decoct($lg->size),decoct(time()));$Pa=8*32;for($v=0;$v<strlen($K);$v++)$Pa+=ord($K[$v]);$K.=sprintf("%06o",$Pa)."\0 ";echo$K,str_repeat("\0",512-strlen($K));$lg->send();echo
str_repeat("\0",511-($lg->size+511)%512);}function
ini_bytes($Oc){$X=ini_get($Oc);switch(strtolower(substr($X,-1))){case'g':$X*=1024;case'm':$X*=1024;case'k':$X*=1024;}return$X;}function
doc_link($Ae){global$y,$g;$Fg=array('sql'=>"http://dev.mysql.com/doc/refman/".substr($g->server_info,0,3)."/en/",'sqlite'=>"http://www.sqlite.org/",'pgsql'=>"http://www.postgresql.org/docs/".substr($g->server_info,0,3)."/static/",'mssql'=>"http://msdn.microsoft.com/library/",'oracle'=>"http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/",);return($Ae[$y]?"<a href='$Fg[$y]$Ae[$y]' target='_blank' rel='noreferrer'><sup>?</sup></a>":"");}function
ob_gzencode($Jf){return
gzencode($Jf);}function
db_size($k){global$g;if(!$g->select_db($k))return"?";$K=0;foreach(table_status()as$R)$K+=$R["Data_length"]+$R["Index_length"];return
format_number($K);}function
set_utf8mb4($i){global$g;static$P=false;if(!$P&&preg_match('~\butf8mb4~i',$i)){$P=true;echo"SET NAMES ".charset($g).";\n\n";}}function
connect_error(){global$c,$g,$T,$m,$Eb;if(DB!=""){header("HTTP/1.1 404 Not Found");page_header(lang(31).": ".h(DB),lang(96),true);}else{if($_POST["db"]&&!$m)queries_redirect(substr(ME,0,-1),lang(97),drop_databases($_POST["db"]));page_header(lang(98),$m,false);echo"<p class='links'>\n";foreach(array('database'=>lang(99),'privileges'=>lang(59),'processlist'=>lang(100),'variables'=>lang(101),'status'=>lang(102),)as$z=>$X){if(support($z))echo"<a href='".h(ME)."$z='>$X</a>\n";}echo"<p>".lang(103,$Eb[DRIVER],"<b>".h($g->server_info)."</b>","<b>$g->extension</b>")."\n","<p>".lang(104,"<b>".h(logged_user())."</b>")."\n";$j=$c->databases();if($j){$sf=support("scheme");$Xa=collations();echo"<form action='' method='post'>\n","<table cellspacing='0' class='checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);'>\n","<thead><tr>".(support("database")?"<td>&nbsp;":"")."<th>".lang(31)." - <a href='".h(ME)."refresh=1'>".lang(105)."</a>"."<td>".lang(106)."<td>".lang(107)."<td>".lang(108)." - <a href='".h(ME)."dbsize=1' onclick=\"return !ajaxSetHtml('".js_escape(ME)."script=connect');\">".lang(109)."</a>"."</thead>\n";$j=($_GET["dbsize"]?count_tables($j):array_flip($j));foreach($j
as$k=>$S){$lf=h(ME)."db=".urlencode($k);echo"<tr".odd().">".(support("database")?"<td>".checkbox("db[]",$k,in_array($k,(array)$_POST["db"])):""),"<th><a href='$lf'>".h($k)."</a>";$Wa=nbsp(db_collation($k,$Xa));echo"<td>".(support("database")?"<a href='$lf".($sf?"&amp;ns=":"")."&amp;database=' title='".lang(55)."'>$Wa</a>":$Wa),"<td align='right'><a href='$lf&amp;schema=' id='tables-".h($k)."' title='".lang(58)."'>".($_GET["dbsize"]?$S:"?")."</a>","<td align='right' id='size-".h($k)."'>".($_GET["dbsize"]?db_size($k):"?"),"\n";}echo"</table>\n",(support("database")?"<fieldset><legend>".lang(110)." <span id='selected'></span></legend><div>\n"."<input type='hidden' name='all' value='' onclick=\"selectCount('selected', formChecked(this, /^db/));\">\n"."<input type='submit' name='drop' value='".lang(111)."'".confirm().">\n"."</div></fieldset>\n":""),"<script type='text/javascript'>tableCheck();</script>\n","<input type='hidden' name='token' value='$T'>\n","</form>\n";}}page_footer("db");}if(isset($_GET["status"]))$_GET["variables"]=$_GET["status"];if(isset($_GET["import"]))$_GET["sql"]=$_GET["import"];if(!(DB!=""?$g->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;}$Zd="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";class
TmpFile{var$handler;var$size;function
TmpFile(){$this->handler=tmpfile();}function
write($gb){$this->size+=strlen($gb);fwrite($this->handler,$gb);}function
send(){fseek($this->handler,0);fpassthru($this->handler);fclose($this->handler);}}$Vb="'(?:''|[^'\\\\]|\\\\.)*'";$Pc="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"])){$b=$_GET["download"];$o=fields($b);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$b-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$N=array(idf_escape($_GET["field"]));$J=$l->select($b,$N,array(where($_GET,$o)),$N);$L=($J?$J->fetch_row():array());echo$L[0];exit;}elseif(isset($_GET["table"])){$b=$_GET["table"];$o=fields($b);if(!$o)$m=error();$R=table_status1($b,true);page_header(($o&&is_view($R)?lang(112):lang(113)).": ".h($b),$m);$c->selectLinks($R);$bb=$R["Comment"];if($bb!="")echo"<p>".lang(91).": ".h($bb)."\n";if($o){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(114)."<td>".lang(87).(support("comment")?"<td>".lang(91):"")."</thead>\n";foreach($o
as$n){echo"<tr".odd()."><th>".h($n["field"]),"<td><span title='".h($n["collation"])."'>".h($n["full_type"])."</span>",($n["null"]?" <i>NULL</i>":""),($n["auto_increment"]?" <i>".lang(52)."</i>":""),(isset($n["default"])?" <span title='".lang(90)."'>[<b>".h($n["default"])."</b>]</span>":""),(support("comment")?"<td>".nbsp($n["comment"]):""),"\n";}echo"</table>\n";}if(!is_view($R)){if(support("indexes")){echo"<h3 id='indexes'>".lang(115)."</h3>\n";$x=indexes($b);if($x){echo"<table cellspacing='0'>\n";foreach($x
as$F=>$w){ksort($w["columns"]);$Me=array();foreach($w["columns"]as$z=>$X)$Me[]="<i>".h($X)."</i>".($w["lengths"][$z]?"(".$w["lengths"][$z].")":"").($w["descs"][$z]?" DESC":"");echo"<tr title='".h($F)."'><th>$w[type]<td>".implode(", ",$Me)."\n";}echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'indexes='.urlencode($b).'">'.lang(116)."</a>\n";}if(fk_support($R)){echo"<h3 id='foreign-keys'>".lang(81)."</h3>\n";$q=foreign_keys($b);if($q){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(117)."<td>".lang(118)."<td>".lang(84)."<td>".lang(83)."<td>&nbsp;</thead>\n";foreach($q
as$F=>$p){echo"<tr title='".h($F)."'>","<th><i>".implode("</i>, <i>",array_map('h',$p["source"]))."</i>","<td><a href='".h($p["db"]!=""?preg_replace('~db=[^&]*~',"db=".urlencode($p["db"]),ME):($p["ns"]!=""?preg_replace('~ns=[^&]*~',"ns=".urlencode($p["ns"]),ME):ME))."table=".urlencode($p["table"])."'>".($p["db"]!=""?"<b>".h($p["db"])."</b>.":"").($p["ns"]!=""?"<b>".h($p["ns"])."</b>.":"").h($p["table"])."</a>","(<i>".implode("</i>, <i>",array_map('h',$p["target"]))."</i>)","<td>".nbsp($p["on_delete"])."\n","<td>".nbsp($p["on_update"])."\n",'<td><a href="'.h(ME.'foreign='.urlencode($b).'&name='.urlencode($F)).'">'.lang(119).'</a>';}echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'foreign='.urlencode($b).'">'.lang(120)."</a>\n";}}if(support(is_view($R)?"view_trigger":"trigger")){echo"<h3 id='triggers'>".lang(121)."</h3>\n";$tg=triggers($b);if($tg){echo"<table cellspacing='0'>\n";foreach($tg
as$z=>$X)echo"<tr valign='top'><td>".h($X[0])."<td>".h($X[1])."<th>".h($z)."<td><a href='".h(ME.'trigger='.urlencode($b).'&name='.urlencode($z))."'>".lang(119)."</a>\n";echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'trigger='.urlencode($b).'">'.lang(122)."</a>\n";}}elseif(isset($_GET["schema"])){page_header(lang(58),"",array(),h(DB.($_GET["ns"]?".$_GET[ns]":"")));$Tf=array();$Uf=array();$da=($_GET["schema"]?$_GET["schema"]:$_COOKIE["adminer_schema-".str_replace(".","_",DB)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$da,$vd,PREG_SET_ORDER);foreach($vd
as$v=>$C){$Tf[$C[1]]=array($C[2],$C[3]);$Uf[]="\n\t'".js_escape($C[1])."': [ $C[2], $C[3] ]";}$ng=0;$Ca=-1;$rf=array();$cf=array();$md=array();foreach(table_status('',true)as$Q=>$R){if(is_view($R))continue;$Fe=0;$rf[$Q]["fields"]=array();foreach(fields($Q)as$F=>$n){$Fe+=1.25;$n["pos"]=$Fe;$rf[$Q]["fields"][$F]=$n;}$rf[$Q]["pos"]=($Tf[$Q]?$Tf[$Q]:array($ng,0));foreach($c->foreignKeys($Q)as$X){if(!$X["db"]){$kd=$Ca;if($Tf[$Q][1]||$Tf[$X["table"]][1])$kd=min(floatval($Tf[$Q][1]),floatval($Tf[$X["table"]][1]))-1;else$Ca-=.1;while($md[(string)$kd])$kd-=.0001;$rf[$Q]["references"][$X["table"]][(string)$kd]=array($X["source"],$X["target"]);$cf[$X["table"]][$Q][(string)$kd]=$X["target"];$md[(string)$kd]=true;}}$ng=max($ng,$rf[$Q]["pos"][0]+2.5+$Fe);}echo'<div id="schema" style="height: ',$ng,'em;" onselectstart="return false;">
<script type="text/javascript">
var tablePos = {',implode(",",$Uf)."\n",'};
var em = document.getElementById(\'schema\').offsetHeight / ',$ng,';
document.onmousemove = schemaMousemove;
document.onmouseup = function (ev) {
schemaMouseup(ev, \'',js_escape(DB),'\');
</script>
';foreach($rf
as$F=>$Q){echo"<div class='table' style='top: ".$Q["pos"][0]."em; left: ".$Q["pos"][1]."em;' onmousedown='schemaMousedown(this, event);'>",'<a href="'.h(ME).'table='.urlencode($F).'"><b>'.h($F)."</b></a>";foreach($Q["fields"]as$n){$X='<span'.type_class($n["type"]).' title="'.h($n["full_type"].($n["null"]?" NULL":'')).'">'.h($n["field"]).'</span>';echo"<br>".($n["primary"]?"<i>$X</i>":$X);}foreach((array)$Q["references"]as$Zf=>$df){foreach($df
as$kd=>$Ze){$ld=$kd-$Tf[$F][1];$v=0;foreach($Ze[0]as$Cf)echo"\n<div class='references' title='".h($Zf)."' id='refs$kd-".($v++)."' style='left: $ld"."em; top: ".$Q["fields"][$Cf]["pos"]."em; padding-top: .5em;'><div style='border-top: 1px solid Gray; width: ".(-$ld)."em;'></div></div>";}}foreach((array)$cf[$F]as$Zf=>$df){foreach($df
as$kd=>$e){$ld=$kd-$Tf[$F][1];$v=0;foreach($e
as$Yf)echo"\n<div class='references' title='".h($Zf)."' id='refd$kd-".($v++)."' style='left: $ld"."em; top: ".$Q["fields"][$Yf]["pos"]."em; height: 1.25em; background: url(".h(preg_replace("~\\?.*~","",ME))."?file=arrow.gif) no-repeat right center;&amp;version=4.2.1&amp;driver=mysql'><div style='height: .5em; border-bottom: 1px solid Gray; width: ".(-$ld)."em;'></div></div>";}}echo"\n</div>\n";}foreach($rf
as$F=>$Q){foreach((array)$Q["references"]as$Zf=>$df){foreach($df
as$kd=>$Ze){$Gd=$ng;$zd=-10;foreach($Ze[0]as$z=>$Cf){$Ge=$Q["pos"][0]+$Q["fields"][$Cf]["pos"];$He=$rf[$Zf]["pos"][0]+$rf[$Zf]["fields"][$Ze[1][$z]]["pos"];$Gd=min($Gd,$Ge,$He);$zd=max($zd,$Ge,$He);}echo"<div class='references' id='refl$kd' style='left: $kd"."em; top: $Gd"."em; padding: .5em 0;'><div style='border-right: 1px solid Gray; margin-top: 1px; height: ".($zd-$Gd)."em;'></div></div>\n";}}}echo'</div>
<p class="links"><a href="',h(ME."schema=".urlencode($da)),'" id="schema-link">',lang(123),'</a>
';}elseif(isset($_GET["dump"])){$b=$_GET["dump"];if($_POST&&!$m){$jb="";foreach(array("output","format","db_style","routines","events","table_style","auto_increment","triggers","data_style")as$z)$jb.="&$z=".urlencode($_POST[$z]);cookie("adminer_export",substr($jb,1));$S=array_flip((array)$_POST["tables"])+array_flip((array)$_POST["data"]);$gc=dump_headers((count($S)==1?key($S):DB),(DB==""||count($S)>1));$Xc=preg_match('~sql~',$_POST["format"]);if($Xc){echo"-- Adminer $fa ".$Eb[DRIVER]." dump\n\n";if($y=="sql"){echo"SET NAMES utf8;
SET time_zone = '+00:00';
".($_POST["data_style"]?"SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
":"")."
";$g->query("SET time_zone = '+00:00';");}}$Lf=$_POST["db_style"];$j=array(DB);if(DB==""){$j=$_POST["databases"];if(is_string($j))$j=explode("\n",rtrim(str_replace("\r","",$j),"\n"));}foreach((array)$j
as$k){$c->dumpDatabase($k);if($g->select_db($k)){if($Xc&&preg_match('~CREATE~',$Lf)&&($i=$g->result("SHOW CREATE DATABASE ".idf_escape($k),1))){set_utf8mb4($i);if($Lf=="DROP+CREATE")echo"DROP DATABASE IF EXISTS ".idf_escape($k).";\n";echo"$i;\n";}if($Xc){if($Lf)echo
use_sql($k).";\n\n";$pe="";if($_POST["routines"]){foreach(array("FUNCTION","PROCEDURE")as$mf){foreach(get_rows("SHOW $mf STATUS WHERE Db = ".q($k),null,"-- ")as$L){$i=remove_definer($g->result("SHOW CREATE $mf ".idf_escape($L["Name"]),2));set_utf8mb4($i);$pe.=($Lf!='DROP+CREATE'?"DROP $mf IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$i;;\n\n";}}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$L){$i=remove_definer($g->result("SHOW CREATE EVENT ".idf_escape($L["Name"]),3));set_utf8mb4($i);$pe.=($Lf!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$i;;\n\n";}}if($pe)echo"DELIMITER ;;\n\n$pe"."DELIMITER ;\n\n";}if($_POST["table_style"]||$_POST["data_style"]){$Og=array();foreach(table_status('',true)as$F=>$R){$Q=(DB==""||in_array($F,(array)$_POST["tables"]));$ob=(DB==""||in_array($F,(array)$_POST["data"]));if($Q||$ob){if($gc=="tar"){$lg=new
TmpFile;ob_start(array($lg,'write'),1e5);}$c->dumpTable($F,($Q?$_POST["table_style"]:""),(is_view($R)?2:0));if(is_view($R))$Og[]=$F;elseif($ob){$o=fields($F);$c->dumpData($F,$_POST["data_style"],"SELECT *".convert_fields($o,$o)." FROM ".table($F));}if($Xc&&$_POST["triggers"]&&$Q&&($tg=trigger_sql($F,$_POST["table_style"])))echo"\nDELIMITER ;;\n$tg\nDELIMITER ;\n";if($gc=="tar"){ob_end_flush();tar_file((DB!=""?"":"$k/")."$F.csv",$lg);}elseif($Xc)echo"\n";}}foreach($Og
as$Ng)$c->dumpTable($Ng,$_POST["table_style"],1);if($gc=="tar")echo
pack("x512");}}}if($Xc)echo"-- ".$g->result("SELECT NOW()")."\n";exit;}page_header(lang(61),$m,($_GET["export"]!=""?array("table"=>$_GET["export"]):array()),h(DB));echo'
<form action="" method="post">
<table cellspacing="0">
';$sb=array('','USE','DROP+CREATE','CREATE');$Vf=array('','DROP+CREATE','CREATE');$pb=array('','TRUNCATE+INSERT','INSERT');if($y=="sql")$pb[]='INSERT+UPDATE';parse_str($_COOKIE["adminer_export"],$L);if(!$L)$L=array("output"=>"text","format"=>"sql","db_style"=>(DB!=""?"":"CREATE"),"table_style"=>"DROP+CREATE","data_style"=>"INSERT");if(!isset($L["events"])){$L["routines"]=$L["events"]=($_GET["dump"]=="");$L["triggers"]=$L["table_style"];}echo"<tr><th>".lang(124)."<td>".html_select("output",$c->dumpOutput(),$L["output"],0)."\n";echo"<tr><th>".lang(125)."<td>".html_select("format",$c->dumpFormat(),$L["format"],0)."\n";echo($y=="sqlite"?"":"<tr><th>".lang(31)."<td>".html_select('db_style',$sb,$L["db_style"]).(support("routine")?checkbox("routines",1,$L["routines"],lang(126)):"").(support("event")?checkbox("events",1,$L["events"],lang(127)):"")),"<tr><th>".lang(107)."<td>".html_select('table_style',$Vf,$L["table_style"]).checkbox("auto_increment",1,$L["auto_increment"],lang(52)).(support("trigger")?checkbox("triggers",1,$L["triggers"],lang(121)):""),"<tr><th>".lang(128)."<td>".html_select('data_style',$pb,$L["data_style"]),'</table>
<p><input type="submit" value="',lang(61),'">
<input type="hidden" name="token" value="',$T,'">
<table cellspacing="0">
';$Ke=array();if(DB!=""){$Na=($b!=""?"":" checked");echo"<thead><tr>","<th style='text-align: left;'><label class='block'><input type='checkbox' id='check-tables'$Na onclick='formCheck(this, /^tables\\[/);'>".lang(107)."</label>","<th style='text-align: right;'><label class='block'>".lang(128)."<input type='checkbox' id='check-data'$Na onclick='formCheck(this, /^data\\[/);'></label>","</thead>\n";$Og="";$Wf=tables_list();foreach($Wf
as$F=>$U){$Je=preg_replace('~_.*~','',$F);$Na=($b==""||$b==(substr($b,-1)=="%"?"$Je%":$F));$Me="<tr><td>".checkbox("tables[]",$F,$Na,$F,"checkboxClick(event, this); formUncheck('check-tables');","block");if($U!==null&&!preg_match('~table~i',$U))$Og.="$Me\n";else
echo"$Me<td align='right'><label class='block'><span id='Rows-".h($F)."'></span>".checkbox("data[]",$F,$Na,"","checkboxClick(event, this); formUncheck('check-data');")."</label>\n";$Ke[$Je]++;}echo$Og;if($Wf)echo"<script type='text/javascript'>ajaxSetHtml('".js_escape(ME)."script=db');</script>\n";}else{echo"<thead><tr><th style='text-align: left;'><label class='block'><input type='checkbox' id='check-databases'".($b==""?" checked":"")." onclick='formCheck(this, /^databases\\[/);'>".lang(31)."</label></thead>\n";$j=$c->databases();if($j){foreach($j
as$k){if(!information_schema($k)){$Je=preg_replace('~_.*~','',$k);echo"<tr><td>".checkbox("databases[]",$k,$b==""||$b=="$Je%",$k,"formUncheck('check-databases');","block")."\n";$Ke[$Je]++;}}}else
echo"<tr><td><textarea name='databases' rows='10' cols='20'></textarea>";}echo'</table>
</form>
';$pc=true;foreach($Ke
as$z=>$X){if($z!=""&&$X>1){echo($pc?"<p>":" ")."<a href='".h(ME)."dump=".urlencode("$z%")."'>".h($z)."</a>";$pc=false;}}}elseif(isset($_GET["privileges"])){page_header(lang(59));$J=$g->query("SELECT User, Host FROM mysql.".(DB==""?"user":"db WHERE ".q(DB)." LIKE Db")." ORDER BY Host, User");$t=$J;if(!$J)$J=$g->query("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', 1) AS User, SUBSTRING_INDEX(CURRENT_USER, '@', -1) AS Host");echo"<form action=''><p>\n";hidden_fields_get();echo"<input type='hidden' name='db' value='".h(DB)."'>\n",($t?"":"<input type='hidden' name='grant' value=''>\n"),"<table cellspacing='0'>\n","<thead><tr><th>".lang(29)."<th>".lang(28)."<th>&nbsp;</thead>\n";while($L=$J->fetch_assoc())echo'<tr'.odd().'><td>'.h($L["User"])."<td>".h($L["Host"]).'<td><a href="'.h(ME.'user='.urlencode($L["User"]).'&host='.urlencode($L["Host"])).'">'.lang(10)."</a>\n";if(!$t||DB!="")echo"<tr".odd()."><td><input name='user' autocapitalize='off'><td><input name='host' value='localhost' autocapitalize='off'><td><input type='submit' value='".lang(10)."'>\n";echo"</table>\n","</form>\n",'<p class="links"><a href="'.h(ME).'user=">'.lang(129)."</a>";}elseif(isset($_GET["sql"])){if(!$m&&$_POST["export"]){dump_headers("sql");$c->dumpTable("","");$c->dumpData("","table",$_POST["query"]);exit;}restart_session();$Fc=&get_session("queries");$Ec=&$Fc[DB];if(!$m&&$_POST["clear"]){$Ec=array();redirect(remove_from_uri("history"));}page_header((isset($_GET["import"])?lang(60):lang(51)),$m);if(!$m&&$_POST){$r=false;if(!isset($_GET["import"]))$I=$_POST["query"];elseif($_POST["webfile"]){$r=@fopen((file_exists("adminer.sql")?"adminer.sql":"compress.zlib://adminer.sql.gz"),"rb");$I=($r?fread($r,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(!$Ec||reset(end($Ec))!=$H){restart_session();$Ec[]=array($H,time());set_session("queries",$Fc);stop_session();}}$Df="(?:\\s|/\\*.*\\*/|(?:#|-- )[^\n]*\n|--\r?\n)";$wb=";";$Sd=0;$Sb=true;$h=connect();if(is_object($h)&&DB!="")$h->select_db(DB);$ab=0;$Xb=array();$rd=0;$ue='[\'"'.($y=="sql"?'`#':($y=="sqlite"?'`[':($y=="mssql"?'[':''))).']|/\\*|-- |$'.($y=="pgsql"?'|\\$[^$]*\\$':'');$og=microtime(true);parse_str($_COOKIE["adminer_export"],$la);$Jb=$c->dumpFormat();unset($Jb["sql"]);while($I!=""){if(!$Sd&&preg_match("~^$Df*DELIMITER\\s+(\\S+)~i",$I,$C)){$wb=$C[1];$I=substr($I,strlen($C[0]));}else{preg_match('('.preg_quote($wb)."\\s*|$ue)",$I,$C,PREG_OFFSET_CAPTURE,$Sd);list($uc,$Fe)=$C[0];if(!$uc&&$r&&!feof($r))$I.=fread($r,1e5);else{if(!$uc&&rtrim($I)=="")break;$Sd=$Fe+strlen($uc);if($uc&&rtrim($uc)!=$wb){while(preg_match('('.($uc=='/*'?'\\*/':($uc=='['?']':(preg_match('~^-- |^#~',$uc)?"\n":preg_quote($uc)."|\\\\."))).'|$)s',$I,$C,PREG_OFFSET_CAPTURE,$Sd)){$pf=$C[0][0];if(!$pf&&$r&&!feof($r))$I.=fread($r,1e5);else{$Sd=$C[0][1]+strlen($pf);if($pf[0]!="\\")break;}}}else{$Sb=false;$H=substr($I,0,$Fe);$ab++;$Me="<pre id='sql-$ab'><code class='jush-$y'>".shorten_utf8(trim($H),1000)."</code></pre>\n";if(!$_POST["only_errors"]){echo$Me;ob_flush();flush();}$Ff=microtime(true);if($g->multi_query($H)&&is_object($h)&&preg_match("~^$Df*USE\\b~isU",$H))$h->query($H);do{$J=$g->store_result();$eg=" <span class='time'>(".format_time($Ff).")</span>".(strlen($H)<1000?" <a href='".h(ME)."sql=".urlencode(trim($H))."'>".lang(10)."</a>":"");if($g->error){echo($_POST["only_errors"]?$Me:""),"<p class='error'>".lang(130).($g->errno?" ($g->errno)":"").": ".error()."\n";$Xb[]=" <a href='#sql-$ab'>$ab</a>";if($_POST["error_stops"])break
2;}elseif(is_object($J)){$_=$_POST["limit"];$ke=select($J,$h,array(),$_);if(!$_POST["only_errors"]){echo"<form action='' method='post'>\n";$Pd=$J->num_rows;echo"<p>".($Pd?($_&&$Pd>$_?lang(131,$_):"").lang(132,$Pd):""),$eg;$Ic="export-$ab";$fc=", <a href='#$Ic' onclick=\"return !toggle('$Ic');\">".lang(61)."</a><span id='$Ic' class='hidden'>: ".html_select("output",$c->dumpOutput(),$la["output"])." ".html_select("format",$Jb,$la["format"])."<input type='hidden' name='query' value='".h($H)."'>"." <input type='submit' name='export' value='".lang(61)."'><input type='hidden' name='token' value='$T'></span>\n";if($h&&preg_match("~^($Df|\\()*SELECT\\b~isU",$H)&&($ec=explain($h,$H))){$Ic="explain-$ab";echo", <a href='#$Ic' onclick=\"return !toggle('$Ic');\">EXPLAIN</a>$fc","<div id='$Ic' class='hidden'>\n";select($ec,$h,$ke);echo"</div>\n";}else
echo$fc;echo"</form>\n";}}else{if(preg_match("~^$Df*(CREATE|DROP|ALTER)$Df+(DATABASE|SCHEMA)\\b~isU",$H)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"])echo"<p class='message' title='".h($g->info)."'>".lang(133,$g->affected_rows)."$eg\n";}$Ff=microtime(true);}while($g->next_result());$rd+=substr_count($H.$uc,"\n");$I=substr($I,$Sd);$Sd=0;}}}}if($Sb)echo"<p class='message'>".lang(134)."\n";elseif($_POST["only_errors"]){echo"<p class='message'>".lang(135,$ab-count($Xb))," <span class='time'>(".format_time($og).")</span>\n";}elseif($Xb&&$ab>1)echo"<p class='error'>".lang(130).": ".implode("",$Xb)."\n";}else
echo"<p class='error'>".upload_error($I)."\n";}echo'
<form action="" method="post" enctype="multipart/form-data" id="form">
';$cc="<input type='submit' value='".lang(136)."' title='Ctrl+Enter'>";if(!isset($_GET["import"])){$H=$_GET["sql"];if($_POST)$H=$_POST["query"];elseif($_GET["history"]=="all")$H=$Ec;elseif($_GET["history"]!="")$H=$Ec[$_GET["history"]][0];echo"<p>";textarea("query",$H,20);echo($_POST?"":"<script type='text/javascript'>focus(document.getElementsByTagName('textarea')[0]);</script>\n"),"<p>$cc\n",lang(137).": <input type='number' name='limit' class='size' value='".h($_POST?$_POST["limit"]:$_GET["limit"])."'>\n";}else{echo"<fieldset><legend>".lang(138)."</legend><div>",(ini_bool("file_uploads")?"SQL (&lt; ".ini_get("upload_max_filesize")."B): <input type='file' name='sql_file[]' multiple>\n$cc":lang(139)),"</div></fieldset>\n","<fieldset><legend>".lang(140)."</legend><div>",lang(141,"<code>adminer.sql".(extension_loaded("zlib")?"[.gz]":"")."</code>"),' <input type="submit" name="webfile" value="'.lang(142).'">',"</div></fieldset>\n","<p>";}echo
checkbox("error_stops",1,($_POST?$_POST["error_stops"]:isset($_GET["import"])),lang(143))."\n",checkbox("only_errors",1,($_POST?$_POST["only_errors"]:isset($_GET["import"])),lang(144))."\n","<input type='hidden' name='token' value='$T'>\n";if(!isset($_GET["import"])&&$Ec){print_fieldset("history",lang(145),$_GET["history"]!="");for($X=end($Ec);$X;$X=prev($Ec)){$z=key($Ec);list($H,$eg,$Nb)=$X;echo'<a href="'.h(ME."sql=&history=$z").'">'.lang(10)."</a>"." <span class='time' title='".@date('Y-m-d',$eg)."'>".@date("H:i:s",$eg)."</span>"." <code class='jush-$y'>".shorten_utf8(ltrim(str_replace("\n"," ",str_replace("\r","",preg_replace('~^(#|-- ).*~m','',$H)))),80,"</code>").($Nb?" <span class='time'>($Nb)</span>":"")."<br>\n";}echo"<input type='submit' name='clear' value='".lang(146)."'>\n","<a href='".h(ME."sql=&history=all")."'>".lang(147)."</a>\n","</div></fieldset>\n";}echo'</form>
';}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));$Dg=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($o
as$F=>$n){if(!isset($n["privileges"][$Dg?"update":"insert"])||$c->fieldName($n)=="")unset($o[$F]);}if($_POST&&!$m&&!isset($_GET["select"])){$B=$_POST["referer"];if($_POST["insert"])$B=($Dg?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$B))$B=ME."select=".urlencode($b);$x=indexes($b);$zg=unique_array($_GET["where"],$x);$Ve="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($B,lang(148),$l->delete($b,$Ve,!$zg));else{$P=array();foreach($o
as$F=>$n){$X=process_input($n);if($X!==false&&$X!==null)$P[idf_escape($F)]=$X;}if($Dg){if(!$P)redirect($B);queries_redirect($B,lang(149),$l->update($b,$P,$Ve,!$zg));if(is_ajax()){page_headers();page_messages($m);exit;}}else{$J=$l->insert($b,$P);$jd=($J?last_id():0);queries_redirect($B,lang(150,($jd?" $jd":"")),$J);}}}$L=null;if($_POST["save"])$L=(array)$_POST["fields"];elseif($Z){$N=array();foreach($o
as$F=>$n){if(isset($n["privileges"]["select"])){$ua=convert_field($n);if($_POST["clone"]&&$n["auto_increment"])$ua="''";if($y=="sql"&&preg_match("~enum|set~",$n["type"]))$ua="1*".idf_escape($F);$N[]=($ua?"$ua AS ":"").idf_escape($F);}}$L=array();if(!support("table"))$N=array("*");if($N){$J=$l->select($b,$N,array($Z),$N,array(),(isset($_GET["select"])?2:1));$L=$J->fetch_assoc();if(!$L)$L=false;if(isset($_GET["select"])&&(!$L||$J->fetch_assoc()))$L=null;}}if(!support("table")&&!$o){if(!$Z){$J=$l->select($b,array("*"),$Z,array("*"));$L=($J?$J->fetch_assoc():false);if(!$L)$L=array($l->primary=>"");}if($L){foreach($L
as$z=>$X){if(!$Z)$L[$z]=null;$o[$z]=array("field"=>$z,"null"=>($z!=$l->primary),"auto_increment"=>($z==$l->primary));}}}edit_form($b,$o,$L,$Dg);}elseif(isset($_GET["create"])){$b=$_GET["create"];$ve=array();foreach(array('HASH','LINEAR HASH','KEY','LINEAR KEY','RANGE','LIST')as$z)$ve[$z]=$z;$bf=referencable_primary($b);$q=array();foreach($bf
as$Sf=>$n)$q[str_replace("`","``",$Sf)."`".str_replace("`","``",$n["field"])]=$Sf;$ne=array();$R=array();if($b!=""){$ne=fields($b);$R=table_status($b);if(!$R)$m=lang(9);}$L=$_POST;$L["fields"]=(array)$L["fields"];if($L["auto_increment_col"])$L["fields"][$L["auto_increment_col"]]["auto_increment"]=true;if($_POST&&!process_fields($L["fields"])&&!$m){if($_POST["drop"])queries_redirect(substr(ME,0,-1),lang(151),drop_tables(array($b)));else{$o=array();$ra=array();$Gg=false;$rc=array();ksort($L["fields"]);$me=reset($ne);$pa=" FIRST";foreach($L["fields"]as$z=>$n){$p=$q[$n["type"]];$ug=($p!==null?$bf[$p]:$n);if($n["field"]!=""){if(!$n["has_default"])$n["default"]=null;if($z==$L["auto_increment_col"])$n["auto_increment"]=true;$Re=process_field($n,$ug);$ra[]=array($n["orig"],$Re,$pa);if($Re!=process_field($me,$me)){$o[]=array($n["orig"],$Re,$pa);if($n["orig"]!=""||$pa)$Gg=true;}if($p!==null)$rc[idf_escape($n["field"])]=($b!=""&&$y!="sqlite"?"ADD":" ").format_foreign_key(array('table'=>$q[$n["type"]],'source'=>array($n["field"]),'target'=>array($ug["field"]),'on_delete'=>$n["on_delete"],));$pa=" AFTER ".idf_escape($n["field"]);}elseif($n["orig"]!=""){$Gg=true;$o[]=array($n["orig"]);}if($n["orig"]!=""){$me=next($ne);if(!$me)$pa="";}}$xe="";if($ve[$L["partition_by"]]){$ye=array();if($L["partition_by"]=='RANGE'||$L["partition_by"]=='LIST'){foreach(array_filter($L["partition_names"])as$z=>$X){$Y=$L["partition_values"][$z];$ye[]="\n  PARTITION ".idf_escape($X)." VALUES ".($L["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$xe.="\nPARTITION BY $L[partition_by]($L[partition])".($ye?" (".implode(",",$ye)."\n)":($L["partitions"]?" PARTITIONS ".(+$L["partitions"]):""));}elseif(support("partitioning")&&preg_match("~partitioned~",$R["Create_options"]))$xe.="\nREMOVE PARTITIONING";$D=lang(152);if($b==""){cookie("adminer_engine",$L["Engine"]);$D=lang(153);}$F=trim($L["name"]);queries_redirect(ME.(support("table")?"table=":"select=").urlencode($F),$D,alter_table($b,$F,($y=="sqlite"&&($Gg||$rc)?$ra:$o),$rc,($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"]):""),$xe));}}page_header(($b!=""?lang(37):lang(62)),$m,array("table"=>$b),h($b));if(!$_POST){$L=array("Engine"=>$_COOKIE["adminer_engine"],"fields"=>array(array("field"=>"","type"=>(isset($wg["int"])?"int":(isset($wg["integer"])?"integer":"")))),"partition_names"=>array(""),);if($b!=""){$L=$R;$L["name"]=$b;$L["fields"]=array();if(!$_GET["auto_increment"])$L["Auto_increment"]="";foreach($ne
as$n){$n["has_default"]=isset($n["default"]);$L["fields"][]=$n;}if(support("partitioning")){$wc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($b);$J=$g->query("SELECT PARTITION_METHOD, PARTITION_ORDINAL_POSITION, PARTITION_EXPRESSION $wc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");list($L["partition_by"],$L["partitions"],$L["partition"])=$J->fetch_row();$ye=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $wc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$ye[""]="";$L["partition_names"]=array_keys($ye);$L["partition_values"]=array_values($ye);}}}$Xa=collations();$Ub=engines();foreach($Ub
as$Tb){if(!strcasecmp($Tb,$L["Engine"])){$L["Engine"]=$Tb;break;}}echo'
<form action="" method="post" id="form">
';if(support("columns")||$b==""){echo
lang(154),': <input name="name" maxlength="64" value="',h($L["name"]),'" autocapitalize="off">
';if($b==""&&!$_POST){?><script type='text/javascript'>focus(document.getElementById('form')['name']);</script><?php }echo($Ub?"<select name='Engine' onchange='helpClose();'".on_help("getTarget(event).value",1).">".optionlist(array(""=>"(".lang(155).")")+$Ub,$L["Engine"])."</select>":""),' ',($Xa&&!preg_match("~sqlite|mssql~",$y)?html_select("Collation",array(""=>"(".lang(82).")")+$Xa,$L["Collation"]):""),' <input type="submit" value="',lang(14),'">
';}echo'
';if(support("columns")){echo'<table cellspacing="0" id="edit-fields" class="nowrap">
';$cb=($_POST?$_POST["comments"]:$L["Comment"]!="");if(!$_POST&&!$cb){foreach($L["fields"]as$n){if($n["comment"]!=""){$cb=true;break;}}}edit_fields($L["fields"],$Xa,"TABLE",$q,$cb);echo'</table>
',lang(52),': <input type="number" name="Auto_increment" size="6" value="',h($L["Auto_increment"]),'">
',checkbox("defaults",1,true,lang(156),"columnShow(this.checked, 5)","jsonly");if(!$_POST["defaults"]){echo'<script type="text/javascript">editingHideDefaults()</script>';}echo(support("comment")?"<label><input type='checkbox' name='comments' value='1' class='jsonly' onclick=\"columnShow(this.checked, 6); toggle('Comment'); if (this.checked) this.form['Comment'].focus();\"".($cb?" checked":"").">".lang(91)."</label>".' <input name="Comment" id="Comment" value="'.h($L["Comment"]).'" maxlength="'.($g->server_info>=5.5?2048:60).'"'.($cb?'':' class="hidden"').'>':''),'<p>
<input type="submit" value="',lang(14),'">
';}echo'
';if($b!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}if(support("partitioning")){$we=preg_match('~RANGE|LIST~',$L["partition_by"]);print_fieldset("partition",lang(157),$L["partition_by"]);echo'<p>
',"<select name='partition_by' onchange='partitionByChange(this);'".on_help("getTarget(event).value.replace(/./, 'PARTITION BY \$&')",1).">".optionlist(array(""=>"")+$ve,$L["partition_by"])."</select>",'(<input name="partition" value="',h($L["partition"]),'">)
',lang(158),': <input type="number" name="partitions" class="size',($we||!$L["partition_by"]?" hidden":""),'" value="',h($L["partitions"]),'">
<table cellspacing="0" id="partition-table"',($we?"":" class='hidden'"),'>
<thead><tr><th>',lang(159),'<th>',lang(160),'</thead>
';foreach($L["partition_names"]as$z=>$X){echo'<tr>','<td><input name="partition_names[]" value="'.h($X).'"'.($z==count($L["partition_names"])-1?' onchange="partitionNameChange(this);"':'').' autocapitalize="off">','<td><input name="partition_values[]" value="'.h($L["partition_values"][$z]).'">';}echo'</table>
</div></fieldset>
';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["indexes"])){$b=$_GET["indexes"];$Nc=array("PRIMARY","UNIQUE","INDEX");$R=table_status($b,true);if(preg_match('~MyISAM|M?aria'.($g->server_info>=5.6?'|InnoDB':'').'~i',$R["Engine"]))$Nc[]="FULLTEXT";$x=indexes($b);$Le=array();if($y=="mongo"){$Le=$x["_id_"];unset($Nc[0]);unset($x["_id_"]);}$L=$_POST;if($_POST&&!$m&&!$_POST["add"]&&!$_POST["drop_col"]){$sa=array();foreach($L["indexes"]as$w){$F=$w["name"];if(in_array($w["type"],$Nc)){$e=array();$pd=array();$yb=array();$P=array();ksort($w["columns"]);foreach($w["columns"]as$z=>$d){if($d!=""){$od=$w["lengths"][$z];$xb=$w["descs"][$z];$P[]=idf_escape($d).($od?"(".(+$od).")":"").($xb?" DESC":"");$e[]=$d;$pd[]=($od?$od:null);$yb[]=$xb;}}if($e){$dc=$x[$F];if($dc){ksort($dc["columns"]);ksort($dc["lengths"]);ksort($dc["descs"]);if($w["type"]==$dc["type"]&&array_values($dc["columns"])===$e&&(!$dc["lengths"]||array_values($dc["lengths"])===$pd)&&array_values($dc["descs"])===$yb){unset($x[$F]);continue;}}$sa[]=array($w["type"],$F,$P);}}}foreach($x
as$F=>$dc)$sa[]=array($dc["type"],$F,"DROP");if(!$sa)redirect(ME."table=".urlencode($b));queries_redirect(ME."table=".urlencode($b),lang(161),alter_indexes($b,$sa));}page_header(lang(115),$m,array("table"=>$b),h($b));$o=array_keys(fields($b));if($_POST["add"]){foreach($L["indexes"]as$z=>$w){if($w["columns"][count($w["columns"])]!="")$L["indexes"][$z]["columns"][]="";}$w=end($L["indexes"]);if($w["type"]||array_filter($w["columns"],'strlen'))$L["indexes"][]=array("columns"=>array(1=>""));}if(!$L){foreach($x
as$z=>$w){$x[$z]["name"]=$z;$x[$z]["columns"][]="";}$x[]=array("columns"=>array(1=>""));$L["indexes"]=$x;}echo'
<form action="" method="post">
<table cellspacing="0" class="nowrap">
<thead><tr>
<th>',lang(162),'<th><input type="submit" style="left: -1000px; position: absolute;">',lang(163),'<th>',lang(164);?>
<th><noscript><input type='image' class='icon' name='add[0]' src='" . h(preg_replace("~\\?.*~", "", ME)) . "?file=plus.gif&amp;version=4.2.1&amp;driver=mysql' alt='+' title='<?php echo
lang(92),'\'></noscript>&nbsp;
</thead>
';if($Le){echo"<tr><td>PRIMARY<td>";foreach($Le["columns"]as$z=>$d){echo
select_input(" disabled",$o,$d),"<label><input disabled type='checkbox'>".lang(46)."</label> ";}echo"<td><td>\n";}$ad=1;foreach($L["indexes"]as$w){if(!$_POST["drop_col"]||$ad!=key($_POST["drop_col"])){echo"<tr><td>".html_select("indexes[$ad][type]",array(-1=>"")+$Nc,$w["type"],($ad==count($L["indexes"])?"indexesAddRow(this);":1)),"<td>";ksort($w["columns"]);$v=1;foreach($w["columns"]as$z=>$d){echo"<span>".select_input(" name='indexes[$ad][columns][$v]' onchange=\"".($v==count($w["columns"])?"indexesAddColumn":"indexesChangeColumn")."(this, '".js_escape($y=="sql"?"":$_GET["indexes"]."_")."');\"",($o?array_combine($o,$o):$o),$d),($y=="sql"||$y=="mssql"?"<input type='number' name='indexes[$ad][lengths][$v]' class='size' value='".h($w["lengths"][$z])."'>":""),($y!="sql"?checkbox("indexes[$ad][descs][$v]",1,$w["descs"][$z],lang(46)):"")," </span>";$v++;}echo"<td><input name='indexes[$ad][name]' value='".h($w["name"])."' autocapitalize='off'>\n","<td><input type='image' class='icon' name='drop_col[$ad]' src='".h(preg_replace("~\\?.*~","",ME))."?file=cross.gif&amp;version=4.2.1&amp;driver=mysql' alt='x' title='".lang(95)."' onclick=\"return !editingRemoveRow(this, 'indexes\$1[type]');\">\n";}$ad++;}echo'</table>
<input type="submit" value="',lang(14),'">
<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["database"])){$L=$_POST;if($_POST&&!$m&&!isset($_POST["add_x"])){$F=trim($L["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),lang(165),drop_databases(array(DB)));}elseif(DB!==$F){if(DB!=""){$_GET["db"]=$F;queries_redirect(preg_replace('~\bdb=[^&]*&~','',ME)."db=".urlencode($F),lang(166),rename_database($F,$L["collation"]));}else{$j=explode("\n",str_replace("\r","",$F));$Mf=true;$id="";foreach($j
as$k){if(count($j)==1||$k!=""){if(!create_database($k,$L["collation"]))$Mf=false;$id=$k;}}restart_session();set_session("dbs",null);queries_redirect(ME."db=".urlencode($id),lang(167),$Mf);}}else{if(!$L["collation"])redirect(substr(ME,0,-1));query_redirect("ALTER DATABASE ".idf_escape($F).(preg_match('~^[a-z0-9_]+$~i',$L["collation"])?" COLLATE $L[collation]":""),substr(ME,0,-1),lang(168));}}page_header(DB!=""?lang(55):lang(169),$m,array(),h(DB));$Xa=collations();$F=DB;if($_POST)$F=$L["name"];elseif(DB!="")$L["collation"]=db_collation(DB,$Xa);elseif($y=="sql"){foreach(get_vals("SHOW GRANTS")as$t){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\\.\\*)?~',$t,$C)&&$C[1]){$F=stripcslashes(idf_unescape("`$C[2]`"));break;}}}echo'
<form action="" method="post">
',($_POST["add_x"]||strpos($F,"\n")?'<textarea id="name" name="name" rows="10" cols="40">'.h($F).'</textarea><br>':'<input name="name" id="name" value="'.h($F).'" maxlength="64" autocapitalize="off">')."\n".($Xa?html_select("collation",array(""=>"(".lang(82).")")+$Xa,$L["collation"]).doc_link(array('sql'=>"charset-charsets.html",'mssql'=>"ms187963.aspx",)):"");?>
<script type='text/javascript'>focus(document.getElementById('name'));</script>
<input type="submit" value="<?php echo
lang(14),'">
';if(DB!="")echo"<input type='submit' name='drop' value='".lang(111)."'".confirm().">\n";elseif(!$_POST["add_x"]&&$_GET["db"]=="")echo"<input type='image' class='icon' name='add' src='".h(preg_replace("~\\?.*~","",ME))."?file=plus.gif&amp;version=4.2.1&amp;driver=mysql' alt='+' title='".lang(92)."'>\n";echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["call"])){$ca=$_GET["call"];page_header(lang(170).": ".h($ca),$m);$mf=routine($ca,(isset($_GET["callf"])?"FUNCTION":"PROCEDURE"));$Mc=array();$pe=array();foreach($mf["fields"]as$v=>$n){if(substr($n["inout"],-3)=="OUT")$pe[$v]="@".idf_escape($n["field"])." AS ".idf_escape($n["field"]);if(!$n["inout"]||substr($n["inout"],0,2)=="IN")$Mc[]=$v;}if(!$m&&$_POST){$Ja=array();foreach($mf["fields"]as$z=>$n){if(in_array($z,$Mc)){$X=process_input($n);if($X===false)$X="''";if(isset($pe[$z]))$g->query("SET @".idf_escape($n["field"])." = $X");}$Ja[]=(isset($pe[$z])?"@".idf_escape($n["field"]):$X);}$I=(isset($_GET["callf"])?"SELECT":"CALL")." ".idf_escape($ca)."(".implode(", ",$Ja).")";echo"<p><code class='jush-$y'>".h($I)."</code> <a href='".h(ME)."sql=".urlencode($I)."'>".lang(10)."</a>\n";if(!$g->multi_query($I))echo"<p class='error'>".error()."\n";else{$h=connect();if(is_object($h))$h->select_db(DB);do{$J=$g->store_result();if(is_object($J))select($J,$h);else
echo"<p class='message'>".lang(171,$g->affected_rows)."\n";}while($g->next_result());if($pe)select($g->query("SELECT ".implode(", ",$pe)));}}echo'
<form action="" method="post">
';if($Mc){echo"<table cellspacing='0'>\n";foreach($Mc
as$z){$n=$mf["fields"][$z];$F=$n["field"];echo"<tr><th>".$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"</table>\n";}echo'<p>
<input type="submit" value="',lang(170),'">
<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["foreign"])){$b=$_GET["foreign"];$F=$_GET["name"];$L=$_POST;if($_POST&&!$m&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){$D=($_POST["drop"]?lang(172):($F!=""?lang(173):lang(174)));$B=ME."table=".urlencode($b);$L["source"]=array_filter($L["source"],'strlen');ksort($L["source"]);$Yf=array();foreach($L["source"]as$z=>$X)$Yf[$z]=$L["target"][$z];$L["target"]=$Yf;if($y=="sqlite")queries_redirect($B,$D,recreate_table($b,$b,array(),array(),array(" $F"=>($_POST["drop"]?"":" ".format_foreign_key($L)))));else{$sa="ALTER TABLE ".table($b);$Fb="\nDROP ".($y=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($F);if($_POST["drop"])query_redirect($sa.$Fb,$B,$D);else{query_redirect($sa.($F!=""?"$Fb,":"")."\nADD".format_foreign_key($L),$B,$D);$m=lang(175)."<br>$m";}}}page_header(lang(176),$m,array("table"=>$b),h($b));if($_POST){ksort($L["source"]);if($_POST["add"])$L["source"][]="";elseif($_POST["change"]||$_POST["change-js"])$L["target"]=array();}elseif($F!=""){$q=foreign_keys($b);$L=$q[$F];$L["source"][]="";}else{$L["table"]=$b;$L["source"]=array("");}$Cf=array_keys(fields($b));$Yf=($b===$L["table"]?$Cf:array_keys(fields($L["table"])));$af=array_keys(array_filter(table_status('',true),'fk_support'));echo'
<form action="" method="post">
';if($L["db"]==""&&$L["ns"]==""){echo
lang(177),':
',html_select("table",$af,$L["table"],"this.form['change-js'].value = '1'; this.form.submit();"),'<input type="hidden" name="change-js" value="">
<noscript><p><input type="submit" name="change" value="',lang(178),'"></noscript>
<table cellspacing="0">
<thead><tr><th>',lang(117),'<th>',lang(118),'</thead>
';$ad=0;foreach($L["source"]as$z=>$X){echo"<tr>","<td>".html_select("source[".(+$z)."]",array(-1=>"")+$Cf,$X,($ad==count($L["source"])-1?"foreignAddRow(this);":1)),"<td>".html_select("target[".(+$z)."]",$Yf,$L["target"][$z]);$ad++;}echo'</table>
',lang(84),': ',html_select("on_delete",array(-1=>"")+explode("|",$Zd),$L["on_delete"]),' ',lang(83),': ',html_select("on_update",array(-1=>"")+explode("|",$Zd),$L["on_update"]),doc_link(array('sql'=>"innodb-foreign-key-constraints.html",'pgsql'=>"sql-createtable.html#SQL-CREATETABLE-REFERENCES",'mssql'=>"ms174979.aspx",'oracle'=>"clauses002.htm#sthref2903",)),'<p>
<input type="submit" value="',lang(14),'">
<noscript><p><input type="submit" name="add" value="',lang(179),'"></noscript>
';}if($F!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["view"])){$b=$_GET["view"];$L=$_POST;if($_POST&&!$m){$F=trim($L["name"]);$ua=" AS\n$L[select]";$B=ME."table=".urlencode($F);$D=lang(180);if($_GET["materialized"])$U="MATERIALIZED VIEW";else{$U="VIEW";if($y=="pgsql"){$Gf=table_status($F);$U=($Gf?strtoupper($Gf["Engine"]):$U);}}if(!$_POST["drop"]&&$b==$F&&$y!="sqlite"&&$U!="MATERIALIZED VIEW")query_redirect(($y=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($F).$ua,$B,$D);else{$ag=$F."_adminer_".uniqid();drop_create("DROP $U ".table($b),"CREATE $U ".table($F).$ua,"DROP $U ".table($F),"CREATE $U ".table($ag).$ua,"DROP $U ".table($ag),($_POST["drop"]?substr(ME,0,-1):$B),lang(181),$D,lang(182),$b,$F);}}if(!$_POST&&$b!=""){$L=view($b);$L["name"]=$b;if(!$m)$m=error();}page_header(($b!=""?lang(36):lang(183)),$m,array("table"=>$b),h($b));echo'
<form action="" method="post">
<p>',lang(164),': <input name="name" value="',h($L["name"]),'" maxlength="64" autocapitalize="off">
<p>';textarea("select",$L["select"]);echo'<p>
<input type="submit" value="',lang(14),'">
';if($_GET["view"]!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["event"])){$aa=$_GET["event"];$Sc=array("YEAR","QUARTER","MONTH","DAY","HOUR","MINUTE","WEEK","SECOND","YEAR_MONTH","DAY_HOUR","DAY_MINUTE","DAY_SECOND","HOUR_MINUTE","HOUR_SECOND","MINUTE_SECOND");$Hf=array("ENABLED"=>"ENABLE","DISABLED"=>"DISABLE","SLAVESIDE_DISABLED"=>"DISABLE ON SLAVE");$L=$_POST;if($_POST&&!$m){if($_POST["drop"])query_redirect("DROP EVENT ".idf_escape($aa),substr(ME,0,-1),lang(184));elseif(in_array($L["INTERVAL_FIELD"],$Sc)&&isset($Hf[$L["STATUS"]])){$qf="\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!=""?lang(185):lang(186)),queries(($aa!=""?"ALTER EVENT ".idf_escape($aa).$qf.($aa!=$L["EVENT_NAME"]?"\nRENAME TO ".idf_escape($L["EVENT_NAME"]):""):"CREATE EVENT ".idf_escape($L["EVENT_NAME"]).$qf)."\n".$Hf[$L["STATUS"]]." COMMENT ".q($L["EVENT_COMMENT"]).rtrim(" DO\n$L[EVENT_DEFINITION]",";").";"));}}page_header(($aa!=""?lang(187).": ".h($aa):lang(188)),$m);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'
<form action="" method="post">
<table cellspacing="0">
<tr><th>',lang(164),'<td><input name="EVENT_NAME" value="',h($L["EVENT_NAME"]),'" maxlength="64" autocapitalize="off">
<tr><th title="datetime">',lang(189),'<td><input name="STARTS" value="',h("$L[EXECUTE_AT]$L[STARTS]"),'">
<tr><th title="datetime">',lang(190),'<td><input name="ENDS" value="',h($L["ENDS"]),'">
<tr><th>',lang(191),'<td><input type="number" name="INTERVAL_VALUE" value="',h($L["INTERVAL_VALUE"]),'" class="size"> ',html_select("INTERVAL_FIELD",$Sc,$L["INTERVAL_FIELD"]),'<tr><th>',lang(102),'<td>',html_select("STATUS",$Hf,$L["STATUS"]),'<tr><th>',lang(91),'<td><input name="EVENT_COMMENT" value="',h($L["EVENT_COMMENT"]),'" maxlength="64">
<tr><th>&nbsp;<td>',checkbox("ON_COMPLETION","PRESERVE",$L["ON_COMPLETION"]=="PRESERVE",lang(192)),'</table>
<p>';textarea("EVENT_DEFINITION",$L["EVENT_DEFINITION"]);echo'<p>
<input type="submit" value="',lang(14),'">
';if($aa!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["procedure"])){$ca=$_GET["procedure"];$mf=(isset($_GET["function"])?"FUNCTION":"PROCEDURE");$L=$_POST;$L["fields"]=(array)$L["fields"];if($_POST&&!process_fields($L["fields"])&&!$m){$ag="$L[name]_adminer_".uniqid();drop_create("DROP $mf ".idf_escape($ca),create_routine($mf,$L),"DROP $mf ".idf_escape($L["name"]),create_routine($mf,array("name"=>$ag)+$L),"DROP $mf ".idf_escape($ag),substr(ME,0,-1),lang(193),lang(194),lang(195),$ca,$L["name"]);}page_header(($ca!=""?(isset($_GET["function"])?lang(196):lang(197)).": ".h($ca):(isset($_GET["function"])?lang(198):lang(199))),$m);if(!$_POST&&$ca!=""){$L=routine($ca,$mf);$L["name"]=$ca;}$Xa=get_vals("SHOW CHARACTER SET");sort($Xa);$nf=routine_languages();echo'
<form action="" method="post" id="form">
<p>',lang(164),': <input name="name" value="',h($L["name"]),'" maxlength="64" autocapitalize="off">
',($nf?lang(19).": ".html_select("language",$nf,$L["language"]):""),'<input type="submit" value="',lang(14),'">
<table cellspacing="0" class="nowrap">
';edit_fields($L["fields"],$Xa,$mf);if(isset($_GET["function"])){echo"<tr><td>".lang(200);edit_type("returns",$L["returns"],$Xa);}echo'</table>
<p>';textarea("definition",$L["definition"]);echo'<p>
<input type="submit" value="',lang(14),'">
';if($ca!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["trigger"])){$b=$_GET["trigger"];$F=$_GET["name"];$sg=trigger_options();$L=(array)trigger($F)+array("Trigger"=>$b."_bi");if($_POST){if(!$m&&in_array($_POST["Timing"],$sg["Timing"])&&in_array($_POST["Event"],$sg["Event"])&&in_array($_POST["Type"],$sg["Type"])){$Yd=" ON ".table($b);$Fb="DROP TRIGGER ".idf_escape($F).($y=="pgsql"?$Yd:"");$B=ME."table=".urlencode($b);if($_POST["drop"])query_redirect($Fb,$B,lang(201));else{if($F!="")queries($Fb);queries_redirect($B,($F!=""?lang(202):lang(203)),queries(create_trigger($Yd,$_POST)));if($F!="")queries(create_trigger($Yd,$L+array("Type"=>reset($sg["Type"]))));}}$L=$_POST;}page_header(($F!=""?lang(204).": ".h($F):lang(205)),$m,array("table"=>$b));echo'
<form action="" method="post" id="form">
<table cellspacing="0">
<tr><th>',lang(206),'<td>',html_select("Timing",$sg["Timing"],$L["Timing"],"triggerChange(/^".preg_quote($b,"/")."_[ba][iud]$/, '".js_escape($b)."', this.form);"),'<tr><th>',lang(207),'<td>',html_select("Event",$sg["Event"],$L["Event"],"this.form['Timing'].onchange();"),(in_array("UPDATE OF",$sg["Event"])?" <input name='Of' value='".h($L["Of"])."' class='hidden'>":""),'<tr><th>',lang(87),'<td>',html_select("Type",$sg["Type"],$L["Type"]),'</table>
<p>',lang(164),': <input name="Trigger" value="',h($L["Trigger"]);?>" maxlength="64" autocapitalize="off">
<script type="text/javascript">document.getElementById('form')['Timing'].onchange();</script>
<p><?php textarea("Statement",$L["Statement"]);echo'<p>
<input type="submit" value="',lang(14),'">
';if($F!=""){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["user"])){$ea=$_GET["user"];$Pe=array(""=>array("All privileges"=>""));foreach(get_rows("SHOW PRIVILEGES")as$L){foreach(explode(",",($L["Privilege"]=="Grant option"?"":$L["Context"]))as$hb)$Pe[$hb][$L["Privilege"]]=$L["Comment"];}$Pe["Server Admin"]+=$Pe["File access on server"];$Pe["Databases"]["Create routine"]=$Pe["Procedures"]["Create routine"];unset($Pe["Procedures"]["Create routine"]);$Pe["Columns"]=array();foreach(array("Select","Insert","Update","References")as$X)$Pe["Columns"][$X]=$Pe["Tables"][$X];unset($Pe["Server Admin"]["Usage"]);foreach($Pe["Tables"]as$z=>$X)unset($Pe["Databases"][$z]);$Ld=array();if($_POST){foreach($_POST["objects"]as$z=>$X)$Ld[$X]=(array)$Ld[$X]+(array)$_POST["grants"][$z];}$yc=array();$Wd="";if(isset($_GET["host"])&&($J=$g->query("SHOW GRANTS FOR ".q($ea)."@".q($_GET["host"])))){while($L=$J->fetch_row()){if(preg_match('~GRANT (.*) ON (.*) TO ~',$L[0],$C)&&preg_match_all('~ *([^(,]*[^ ,(])( *\\([^)]+\\))?~',$C[1],$vd,PREG_SET_ORDER)){foreach($vd
as$X){if($X[1]!="USAGE")$yc["$C[2]$X[2]"][$X[1]]=true;if(preg_match('~ WITH GRANT OPTION~',$L[0]))$yc["$C[2]$X[2]"]["GRANT OPTION"]=true;}}if(preg_match("~ IDENTIFIED BY PASSWORD '([^']+)~",$L[0],$C))$Wd=$C[1];}}if($_POST&&!$m){$Xd=(isset($_GET["host"])?q($ea)."@".q($_GET["host"]):"''");if($_POST["drop"])query_redirect("DROP USER $Xd",ME."privileges=",lang(208));else{$Nd=q($_POST["user"])."@".q($_POST["host"]);$ze=$_POST["pass"];if($ze!=''&&!$_POST["hashed"]){$ze=$g->result("SELECT PASSWORD(".q($ze).")");$m=!$ze;}$lb=false;if(!$m){if($Xd!=$Nd){$lb=queries(($g->server_info<5?"GRANT USAGE ON *.* TO":"CREATE USER")." $Nd IDENTIFIED BY PASSWORD ".q($ze));$m=!$lb;}elseif($ze!=$Wd)queries("SET PASSWORD FOR $Nd = ".q($ze));}if(!$m){$jf=array();foreach($Ld
as$Rd=>$t){if(isset($_GET["grant"]))$t=array_filter($t);$t=array_keys($t);if(isset($_GET["grant"]))$jf=array_diff(array_keys(array_filter($Ld[$Rd],'strlen')),$t);elseif($Xd==$Nd){$Ud=array_keys((array)$yc[$Rd]);$jf=array_diff($Ud,$t);$t=array_diff($t,$Ud);unset($yc[$Rd]);}if(preg_match('~^(.+)\\s*(\\(.*\\))?$~U',$Rd,$C)&&(!grant("REVOKE",$jf,$C[2]," ON $C[1] FROM $Nd")||!grant("GRANT",$t,$C[2]," ON $C[1] TO $Nd"))){$m=true;break;}}}if(!$m&&isset($_GET["host"])){if($Xd!=$Nd)queries("DROP USER $Xd");elseif(!isset($_GET["grant"])){foreach($yc
as$Rd=>$jf){if(preg_match('~^(.+)(\\(.*\\))?$~U',$Rd,$C))grant("REVOKE",array_keys($jf),$C[2]," ON $C[1] FROM $Nd");}}}queries_redirect(ME."privileges=",(isset($_GET["host"])?lang(209):lang(210)),!$m);if($lb)$g->query("DROP USER $Nd");}}page_header((isset($_GET["host"])?lang(29).": ".h("$ea@$_GET[host]"):lang(129)),$m,array("privileges"=>array('',lang(59))));if($_POST){$L=$_POST;$yc=$Ld;}else{$L=$_GET+array("host"=>$g->result("SELECT SUBSTRING_INDEX(CURRENT_USER, '@', -1)"));$L["pass"]=$Wd;if($Wd!="")$L["hashed"]=true;$yc[(DB==""||$yc?"":idf_escape(addcslashes(DB,"%_\\"))).".*"]=array();}echo'<form action="" method="post">
<table cellspacing="0">
<tr><th>',lang(28),'<td><input name="host" maxlength="60" value="',h($L["host"]),'" autocapitalize="off">
<tr><th>',lang(29),'<td><input name="user" maxlength="16" value="',h($L["user"]),'" autocapitalize="off">
<tr><th>',lang(30),'<td><input name="pass" id="pass" value="',h($L["pass"]),'">
';if(!$L["hashed"]){echo'<script type="text/javascript">typePassword(document.getElementById(\'pass\'));</script>';}echo
checkbox("hashed",1,$L["hashed"],lang(211),"typePassword(this.form['pass'], this.checked);"),'</table>
';echo"<table cellspacing='0'>\n","<thead><tr><th colspan='2'>".lang(59).doc_link(array('sql'=>"grant.html#priv_level"));$v=0;foreach($yc
as$Rd=>$t){echo'<th>'.($Rd!="*.*"?"<input name='objects[$v]' value='".h($Rd)."' size='10' autocapitalize='off'>":"<input type='hidden' name='objects[$v]' value='*.*' size='10'>*.*");$v++;}echo"</thead>\n";foreach(array(""=>"","Server Admin"=>lang(28),"Databases"=>lang(31),"Tables"=>lang(113),"Columns"=>lang(114),"Procedures"=>lang(212),)as$hb=>$xb){foreach((array)$Pe[$hb]as$Oe=>$bb){echo"<tr".odd()."><td".($xb?">$xb<td":" colspan='2'").' lang="en" title="'.h($bb).'">'.h($Oe);$v=0;foreach($yc
as$Rd=>$t){$F="'grants[$v][".h(strtoupper($Oe))."]'";$Y=$t[strtoupper($Oe)];if($hb=="Server Admin"&&$Rd!=(isset($yc["*.*"])?"*.*":".*"))echo"<td>&nbsp;";elseif(isset($_GET["grant"]))echo"<td><select name=$F><option><option value='1'".($Y?" selected":"").">".lang(213)."<option value='0'".($Y=="0"?" selected":"").">".lang(214)."</select>";else
echo"<td align='center'><label class='block'><input type='checkbox' name=$F value='1'".($Y?" checked":"").($Oe=="All privileges"?" id='grants-$v-all'":($Oe=="Grant option"?"":" onclick=\"if (this.checked) formUncheck('grants-$v-all');\""))."></label>";$v++;}}}echo"</table>\n",'<p>
<input type="submit" value="',lang(14),'">
';if(isset($_GET["host"])){echo'<input type="submit" name="drop" value="',lang(111),'"',confirm(),'>';}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["processlist"])){if(support("kill")&&$_POST&&!$m){$ed=0;foreach((array)$_POST["kill"]as$X){if(queries("KILL ".number($X)))$ed++;}queries_redirect(ME."processlist=",lang(215,$ed),$ed||!$_POST["kill"]);}page_header(lang(100),$m);echo'
<form action="" method="post">
<table cellspacing="0" onclick="tableClick(event);" ondblclick="tableClick(event, true);" class="nowrap checkable">
';$v=-1;foreach(process_list()as$v=>$L){if(!$v){echo"<thead><tr lang='en'>".(support("kill")?"<th>&nbsp;":"");foreach($L
as$z=>$X)echo"<th>$z".doc_link(array('sql'=>"show-processlist.html#processlist_".strtolower($z),'pgsql'=>"monitoring-stats.html#PG-STAT-ACTIVITY-VIEW",'oracle'=>"../b14237/dynviews_2088.htm",));echo"</thead>\n";}echo"<tr".odd().">".(support("kill")?"<td>".checkbox("kill[]",$L["Id"],0):"");foreach($L
as$z=>$X)echo"<td>".(($y=="sql"&&$z=="Info"&&preg_match("~Query|Killed~",$L["Command"])&&$X!="")||($y=="pgsql"&&$z=="current_query"&&$X!="<IDLE>")||($y=="oracle"&&$z=="sql_text"&&$X!="")?"<code class='jush-$y'>".shorten_utf8($X,100,"</code>").' <a href="'.h(ME.($L["db"]!=""?"db=".urlencode($L["db"])."&":"")."sql=".urlencode($X)).'">'.lang(216).'</a>':nbsp($X));echo"\n";}echo'</table>
<script type=\'text/javascript\'>tableCheck();</script>
';if(support("kill")){echo($v+1)."/".lang(217,$g->result("SELECT @@max_connections")),"<p><input type='submit' value='".lang(218)."'>\n";}echo'<input type="hidden" name="token" value="',$T,'">
</form>
';}elseif(isset($_GET["select"])){$b=$_GET["select"];$R=table_status1($b);$x=indexes($b);$o=fields($b);$q=column_foreign_keys($b);$Td="";if($R["Oid"]){$Td=($y=="sqlite"?"rowid":"oid");$x[]=array("type"=>"PRIMARY","columns"=>array($Td));}parse_str($_COOKIE["adminer_import"],$ma);$kf=array();$e=array();$dg=null;foreach($o
as$z=>$n){$F=$c->fieldName($n);if(isset($n["privileges"]["select"])&&$F!=""){$e[$z]=html_entity_decode(strip_tags($F),ENT_QUOTES);if(is_shortable($n))$dg=$c->selectLengthProcess();}$kf+=$n["privileges"];}list($N,$u)=$c->selectColumnsProcess($e,$x);$Wc=count($u)<count($N);$Z=$c->selectSearchProcess($o,$x);$he=$c->selectOrderProcess($o,$x);$_=$c->selectLimitProcess();$wc=($N?implode(", ",$N):"*".($Td?", $Td":"")).convert_fields($e,$o,$N)."\nFROM ".table($b);$zc=($u&&$Wc?"\nGROUP BY ".implode(", ",$u):"").($he?"\nORDER BY ".implode(", ",$he):"");if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$_g=>$L){$ua=convert_field($o[key($L)]);$N=array($ua?$ua:idf_escape(key($L)));$Z[]=where_check($_g,$o);$K=$l->select($b,$N,$Z,$N);if($K)echo
reset($K->fetch_row());}exit;}if($_POST&&!$m){$Sg=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Oa=array();foreach($_POST["check"]as$Ma)$Oa[]=where_check($Ma,$o);$Sg[]="((".implode(") OR (",$Oa)."))";}$Sg=($Sg?"\nWHERE ".implode(" AND ",$Sg):"");$Le=$Bg=null;foreach($x
as$w){if($w["type"]=="PRIMARY"){$Le=array_flip($w["columns"]);$Bg=($N?$Le:array());break;}}foreach((array)$Bg
as$z=>$X){if(in_array(idf_escape($z),$N))unset($Bg[$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"])||$Bg===array())$I="SELECT $wc$Sg$zc";else{$yg=array();foreach($_POST["check"]as$X)$yg[]="(SELECT".limit($wc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o).$zc,1).")";$I=implode(" UNION ALL ",$yg);}$c->dumpData($b,"table",$I);exit;}if(!$c->selectEmailProcess($Z,$q)){if($_POST["save"]||$_POST["delete"]){$J=true;$na=0;$P=array();if(!$_POST["delete"]){foreach($e
as$F=>$X){$X=process_input($o[$F]);if($X!==null&&($_POST["clone"]||$X!==false))$P[idf_escape($F)]=($X!==false?$X:idf_escape($F));}}if($_POST["delete"]||$P){if($_POST["clone"])$I="INTO ".table($b)." (".implode(", ",array_keys($P)).")\nSELECT ".implode(", ",$P)."\nFROM ".table($b);if($_POST["all"]||($Bg===array()&&is_array($_POST["check"]))||$Wc){$J=($_POST["delete"]?$l->delete($b,$Sg):($_POST["clone"]?queries("INSERT $I$Sg"):$l->update($b,$P,$Sg)));$na=$g->affected_rows;}else{foreach((array)$_POST["check"]as$X){$Rg="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$o);$J=($_POST["delete"]?$l->delete($b,$Rg,1):($_POST["clone"]?queries("INSERT".limit1($I,$Rg)):$l->update($b,$P,$Rg)));if(!$J)break;$na+=$g->affected_rows;}}}$D=lang(219,$na);if($_POST["clone"]&&$J&&$na==1){$jd=last_id();if($jd)$D=lang(150," $jd");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$D,$J);if(!$_POST["delete"]){edit_form($b,$o,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$m=lang(220);else{$J=true;$na=0;foreach($_POST["val"]as$_g=>$L){$P=array();foreach($L
as$z=>$X){$z=bracket_escape($z,1);$P[idf_escape($z)]=(preg_match('~char|text~',$o[$z]["type"])||$X!=""?$c->processInput($o[$z],$X):"NULL");}$J=$l->update($b,$P," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($_g,$o),!($Wc||$Bg===array())," ");if(!$J)break;$na+=$g->affected_rows;}queries_redirect(remove_from_uri(),lang(219,$na),$J);}}elseif(!is_string($mc=get_file("csv_file",true)))$m=upload_error($mc);elseif(!preg_match('~~u',$mc))$m=lang(221);else{cookie("adminer_import","output=".urlencode($ma["output"])."&format=".urlencode($_POST["separator"]));$J=true;$Ya=array_keys($o);preg_match_all('~(?>"[^"]*"|[^"\\r\\n]+)+~',$mc,$vd);$na=count($vd[0]);$l->begin();$wf=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$M=array();foreach($vd[0]as$z=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$wf]*)$wf~",$X.$wf,$wd);if(!$z&&!array_diff($wd[1],$Ya)){$Ya=$wd[1];$na--;}else{$P=array();foreach($wd[1]as$v=>$Ua)$P[idf_escape($Ya[$v])]=($Ua==""&&$o[$Ya[$v]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$Ua))));$M[]=$P;}}$J=(!$M||$l->insertUpdate($b,$M,$Le));if($J)$l->commit();queries_redirect(remove_from_uri("page"),lang(222,$na),$J);$l->rollback();}}}$Sf=$c->tableName($R);if(is_ajax()){page_headers();ob_start();}else
page_header(lang(40).": $Sf",$m);$P=null;if(isset($kf["insert"])||!support("table")){$P="";foreach((array)$_GET["where"]as$X){if(count($q[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!preg_match('~[_%]~',$X["val"]))))$P.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$c->selectLinks($R,$P);if(!$e&&support("table"))echo"<p class='error'>".lang(223).($o?".":": ".error())."\n";else{echo"<form action='' id='form'>\n","<div style='display: none;'>";hidden_fields_get();echo(DB!=""?'<input type="hidden" name="db" value="'.h(DB).'">'.(isset($_GET["ns"])?'<input type="hidden" name="ns" value="'.h($_GET["ns"]).'">':""):"");echo'<input type="hidden" name="select" value="'.h($b).'">',"</div>\n";$c->selectColumnsPrint($N,$e);$c->selectSearchPrint($Z,$e,$x);$c->selectOrderPrint($he,$e,$x);$c->selectLimitPrint($_);$c->selectLengthPrint($dg);$c->selectActionPrint($x);echo"</form>\n";$G=$_GET["page"];if($G=="last"){$vc=$g->result(count_rows($b,$Z,$Wc,$u));$G=floor(max(0,$vc-1)/$_);}$tf=$N;if(!$tf){$tf[]="*";if($Td)$tf[]=$Td;}$ib=convert_fields($e,$o,$N);if($ib)$tf[]=substr($ib,2);$J=$l->select($b,$tf,$Z,$u,$he,$_,$G,true);if(!$J)echo"<p class='error'>".error()."\n";else{if($y=="mssql"&&$G)$J->seek($_*$G);$Rb=array();echo"<form action='' method='post' enctype='multipart/form-data'>\n";$M=array();while($L=$J->fetch_assoc()){if($G&&$y=="oracle")unset($L["RNUM"]);$M[]=$L;}if($_GET["page"]!="last"&&+$_&&$u&&$Wc&&$y=="sql")$vc=$g->result(" SELECT FOUND_ROWS()");if(!$M)echo"<p class='message'>".lang(12)."\n";else{$Ba=$c->backwardKeys($b,$Sf);echo"<table id='table' cellspacing='0' class='nowrap checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);' onkeydown='return editingKeydown(event);'>\n","<thead><tr>".(!$u&&$N?"":"<td><input type='checkbox' id='all-page' onclick='formCheck(this, /check/);'> <a href='".h($_GET["modify"]?remove_from_uri("modify"):$_SERVER["REQUEST_URI"]."&modify=1")."'>".lang(224)."</a>");$Kd=array();$xc=array();reset($N);$Xe=1;foreach($M[0]as$z=>$X){if($z!=$Td){$X=$_GET["columns"][key($N)];$n=$o[$N?($X?$X["col"]:current($N)):$z];$F=($n?$c->fieldName($n,$Xe):($X["fun"]?"*":$z));if($F!=""){$Xe++;$Kd[$z]=$F;$d=idf_escape($z);$Hc=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($z);$xb="&desc%5B0%5D=1";echo'<th onmouseover="columnMouse(this);" onmouseout="columnMouse(this, \' hidden\');">','<a href="'.h($Hc.($he[0]==$d||$he[0]==$z||(!$he&&$Wc&&$u[0]==$d)?$xb:'')).'">';echo
apply_sql_function($X["fun"],$F)."</a>";echo"<span class='column hidden'>","<a href='".h($Hc.$xb)."' title='".lang(46)."' class='text'>
</a>";if(!$X["fun"])echo'<a href="#fieldset-search" onclick="selectSearch(\''.h(js_escape($z)).'\'); return false;" title="'.lang(43).'" class="text jsonly"> =</a>';echo"</span>";}$xc[$z]=$X["fun"];next($N);}}$pd=array();if($_GET["modify"]){foreach($M
as$L){foreach($L
as$z=>$X)$pd[$z]=max($pd[$z],min(40,strlen(utf8_decode($X))));}}echo($Ba?"<th>".lang(225):"")."</thead>\n";if(is_ajax()){if($_%2==1&&$G%2==1)odd();ob_end_clean();}foreach($c->rowDescriptions($M,$q)as$E=>$L){$zg=unique_array($M[$E],$x);if(!$zg){$zg=array();foreach($M[$E]as$z=>$X){if(!preg_match('~^(COUNT\\((\\*|(DISTINCT )?`(?:[^`]|``)+`)\\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\\(`(?:[^`]|``)+`\\))$~',$z))$zg[$z]=$X;}}$_g="";foreach($zg
as$z=>$X){if(($y=="sql"||$y=="pgsql")&&strlen($X)>64){$z=(strpos($z,'(')?$z:idf_escape($z));$z="MD5(".($y=='sql'&&preg_match("~^utf8_~",$o[$z]["collation"])?$z:"CONVERT($z USING ".charset($g).")").")";$X=md5($X);}$_g.="&".($X!==null?urlencode("where[".bracket_escape($z)."]")."=".urlencode($X):"null%5B%5D=".urlencode($z));}echo"<tr".odd().">".(!$u&&$N?"":"<td>".checkbox("check[]",substr($_g,1),in_array(substr($_g,1),(array)$_POST["check"]),"","this.form['all'].checked = false; formUncheck('all-page');").($Wc||information_schema(DB)?"":" <a href='".h(ME."edit=".urlencode($b).$_g)."'>".lang(226)."</a>"));foreach($L
as$z=>$X){if(isset($Kd[$z])){$n=$o[$z];if($X!=""&&(!isset($Rb[$z])||$Rb[$z]!=""))$Rb[$z]=(is_mail($X)?$Kd[$z]:"");$A="";if(preg_match('~blob|bytea|raw|file~',$n["type"])&&$X!="")$A=ME.'download='.urlencode($b).'&field='.urlencode($z).$_g;if(!$A&&$X!==null){foreach((array)$q[$z]as$p){if(count($q[$z])==1||end($p["source"])==$z){$A="";foreach($p["source"]as$v=>$Cf)$A.=where_link($v,$p["target"][$v],$M[$E][$Cf]);$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);$v=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$zg))$A.=where_link($v++,$W["col"],$W["val"],$W["op"]);}foreach($zg
as$bd=>$W)$A.=where_link($v++,$bd,$W);}$X=select_value($X,$A,$n,$dg);$Ic=h("val[$_g][".bracket_escape($z)."]");$Y=$_POST["val"][$_g][bracket_escape($z)];$Mb=!is_array($L[$z])&&is_utf8($X)&&$M[$E][$z]==$L[$z]&&!$xc[$z];$cg=preg_match('~text|lob~',$n["type"]);if(($_GET["modify"]&&$Mb)||$Y!==null){$Ac=h($Y!==null?$Y:$L[$z]);echo"<td>".($cg?"<textarea name='$Ic' cols='30' rows='".(substr_count($L[$z],"\n")+1)."'>$Ac</textarea>":"<input name='$Ic' value='$Ac' size='$pd[$z]'>");}else{$ud=strpos($X,"<i>...</i>");echo"<td id='$Ic' onclick=\"selectClick(this, event, ".($ud?2:($cg?1:0)).($Mb?"":", '".h(lang(227))."'").");\">$X";}}}if($Ba)echo"<td>";$c->backwardKeysPrint($Ba,$M[$E]);echo"</tr>\n";}if(is_ajax())exit;echo"</table>\n";}if(($M||$G)&&!is_ajax()){$bc=true;if($_GET["page"]!="last"){if(!+$_)$vc=count($M);elseif($y!="sql"||!$Wc){$vc=($Wc?false:found_rows($R,$Z));if($vc<max(1e4,2*($G+1)*$_))$vc=reset(slow_query(count_rows($b,$Z,$Wc,$u)));else$bc=false;}}if(+$_&&($vc===false||$vc>$_||$G)){echo"<p class='pages'>";$yd=($vc===false?$G+(count($M)>=$_?2:1):floor(($vc-1)/$_));if($y!="simpledb"){echo'<a href="'.h(remove_from_uri("page"))."\" onclick=\"pageClick(this.href, +prompt('".lang(228)."', '".($G+1)."'), event); return false;\">".lang(228)."</a>:",pagination(0,$G).($G>5?" ...":"");for($v=max(1,$G-4);$v<min($yd,$G+5);$v++)echo
pagination($v,$G);if($yd>0){echo($G+5<$yd?" ...":""),($bc&&$vc!==false?pagination($yd,$G):" <a href='".h(remove_from_uri("page")."&page=last")."' title='~$yd'>".lang(229)."</a>");}echo(($vc===false?count($M)+1:$vc-$G*$_)>$_?' <a href="'.h(remove_from_uri("page")."&page=".($G+1)).'" onclick="return !selectLoadMore(this, '.(+$_).', \''.lang(230).'...\');" class="loadmore">'.lang(231).'</a>':'');}else{echo
lang(228).":",pagination(0,$G).($G>1?" ...":""),($G?pagination($G,$G):""),($yd>$G?pagination($G+1,$G).($yd>$G+1?" ...":""):"");}}echo"<p class='count'>\n",($vc!==false?"(".($bc?"":"~ ").lang(132,$vc).") ":"");$Bb=($bc?"":"~ ").$vc;echo
checkbox("all",1,0,lang(232),"var checked = formChecked(this, /check/); selectCount('selected', this.checked ? '$Bb' : checked); selectCount('selected2', this.checked || !checked ? '$Bb' : checked);")."\n";if($c->selectCommandPrint()){echo'<fieldset',($_GET["modify"]?'':' class="jsonly"'),'><legend>',lang(224),'</legend><div>
<input type="submit" value="',lang(14),'"',($_GET["modify"]?'':' title="'.lang(220).'"'),'>
</div></fieldset>
<fieldset><legend>',lang(110),' <span id="selected"></span></legend><div>
<input type="submit" name="edit" value="',lang(10),'">
<input type="submit" name="clone" value="',lang(216),'">
<input type="submit" name="delete" value="',lang(18),'"',confirm(),'>
</div></fieldset>
';}$tc=$c->dumpFormat();foreach((array)$_GET["columns"]as$d){if($d["fun"]){unset($tc['sql']);break;}}if($tc){print_fieldset("export",lang(61)." <span id='selected2'></span>");$qe=$c->dumpOutput();echo($qe?html_select("output",$qe,$ma["output"])." ":""),html_select("format",$tc,$ma["format"])," <input type='submit' name='export' value='".lang(61)."'>\n","</div></fieldset>\n";}echo(!$u&&$N?"":"<script type='text/javascript'>tableCheck();</script>\n");}if($c->selectImportPrint()){print_fieldset("import",lang(60),!$M);echo"<input type='file' name='csv_file'> ",html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$ma["format"],1);echo" <input type='submit' name='import' value='".lang(60)."'>","</div></fieldset>\n";}$c->selectEmailPrint(array_filter($Rb,'strlen'),$e);echo"<p><input type='hidden' name='token' value='$T'></p>\n","</form>\n";}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$Gf=isset($_GET["status"]);page_header($Gf?lang(102):lang(101));$Lg=($Gf?show_status():show_variables());if(!$Lg)echo"<p class='message'>".lang(12)."\n";else{echo"<table cellspacing='0'>\n";foreach($Lg
as$z=>$X){echo"<tr>","<th><code class='jush-".$y.($Gf?"status":"set")."'>".h($z)."</code>","<td>".nbsp($X);}echo"</table>\n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$Pf=array("Data_length"=>0,"Index_length"=>0,"Data_free"=>0);foreach(table_status()as$F=>$R){json_row("Comment-$F",nbsp($R["Comment"]));if(!is_view($R)){foreach(array("Engine","Collation")as$z)json_row("$z-$F",nbsp($R[$z]));foreach($Pf+array("Auto_increment"=>0,"Rows"=>0)as$z=>$X){if($R[$z]!=""){$X=format_number($R[$z]);json_row("$z-$F",($z=="Rows"&&$X&&$R["Engine"]==($Ef=="pgsql"?"table":"InnoDB")?"~ $X":$X));if(isset($Pf[$z]))$Pf[$z]+=($R["Engine"]!="InnoDB"||$z!="Data_free"?$R[$z]:0);}elseif(array_key_exists($z,$R))json_row("$z-$F");}}}foreach($Pf
as$z=>$X)json_row("sum-$z",format_number($X));json_row("");}elseif($_GET["script"]=="kill")$g->query("KILL ".number($_POST["kill"]));else{foreach(count_tables($c->databases())as$k=>$X){json_row("tables-$k",$X);json_row("size-$k",db_size($k));}json_row("");}exit;}else{$Xf=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($Xf&&!$m&&!$_POST["search"]){$J=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"])$J=truncate_tables($_POST["tables"]);$D=lang(233);}elseif($_POST["move"]){$J=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(234);}elseif($_POST["copy"]){$J=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D=lang(235);}elseif($_POST["drop"]){if($_POST["views"])$J=drop_views($_POST["views"]);if($J&&$_POST["tables"])$J=drop_tables($_POST["tables"]);$D=lang(236);}elseif($y!="sql"){$J=($y=="sqlite"?queries("VACUUM"):apply_queries("VACUUM".($_POST["optimize"]?"":" ANALYZE"),$_POST["tables"]));$D=lang(237);}elseif(!$_POST["tables"])$D=lang(9);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())$D.="<b>".h($L["Table"])."</b>: ".h($L["Msg_text"])."<br>";}queries_redirect(substr(ME,0,-1),$D,$J);}page_header(($_GET["ns"]==""?lang(31).": ".h(DB):lang(238).": ".h($_GET["ns"])),$m,true);if($c->homepage()){if($_GET["ns"]!==""){echo"<h3 id='tables-views'>".lang(239)."</h3>\n";$Wf=tables_list();if(!$Wf)echo"<p class='message'>".lang(9)."\n";else{echo"<form action='' method='post'>\n";if(support("table")){echo"<fieldset><legend>".lang(240)." <span id='selected2'></span></legend><div>","<input type='search' name='query' value='".h($_POST["query"])."'> <input type='submit' name='search' value='".lang(43)."'>\n","</div></fieldset>\n";if($_POST["search"]&&$_POST["query"]!="")search_tables();}echo"<table cellspacing='0' class='nowrap checkable' onclick='tableClick(event);' ondblclick='tableClick(event, true);'>\n",'<thead><tr class="wrap"><td><input id="check-all" type="checkbox" onclick="formCheck(this, /^(tables|views)\[/);">';$Cb=doc_link(array('sql'=>'show-table-status.html'));echo'<th>'.lang(113),'<td>'.lang(241).doc_link(array('sql'=>'storage-engines.html')),'<td>'.lang(106).doc_link(array('sql'=>'charset-mysql.html')),'<td>'.lang(242).$Cb,'<td>'.lang(243).$Cb,'<td>'.lang(244).$Cb,'<td>'.lang(52).doc_link(array('sql'=>'example-auto-increment.html')),'<td>'.lang(245).$Cb,(support("comment")?'<td>'.lang(91).$Cb:''),"</thead>\n";$S=0;foreach($Wf
as$F=>$U){$Ng=($U!==null&&!preg_match('~table~i',$U));echo'<tr'.odd().'><td>'.checkbox(($Ng?"views[]":"tables[]"),$F,in_array($F,$Xf,true),"","formUncheck('check-all');"),'<th>'.(support("table")||support("indexes")?'<a href="'.h(ME).'table='.urlencode($F).'" title="'.lang(35).'">'.h($F).'</a>':h($F));if($Ng){echo'<td colspan="6"><a href="'.h(ME)."view=".urlencode($F).'" title="'.lang(36).'">'.(preg_match('~materialized~i',$U)?lang(246):lang(112)).'</a>','<td align="right"><a href="'.h(ME)."select=".urlencode($F).'" title="'.lang(34).'">?</a>';}else{foreach(array("Engine"=>array(),"Collation"=>array(),"Data_length"=>array("create",lang(37)),"Index_length"=>array("indexes",lang(116)),"Data_free"=>array("edit",lang(38)),"Auto_increment"=>array("auto_increment=1&create",lang(37)),"Rows"=>array("select",lang(34)),)as$z=>$A){$Ic=" id='$z-".h($F)."'";echo($A?"<td align='right'>".(support("table")||$z=="Rows"||(support("indexes")&&$z!="Data_length")?"<a href='".h(ME."$A[0]=").urlencode($F)."'$Ic title='$A[1]'>?</a>":"<span$Ic>?</span>"):"<td id='$z-".h($F)."'>&nbsp;");}$S++;}echo(support("comment")?"<td id='Comment-".h($F)."'>&nbsp;":"");}echo"<tr><td>&nbsp;<th>".lang(217,count($Wf)),"<td>".nbsp($y=="sql"?$g->result("SELECT @@storage_engine"):""),"<td>".nbsp(db_collation(DB,collations()));foreach(array("Data_length","Index_length","Data_free")as$z)echo"<td align='right' id='sum-$z'>&nbsp;";echo"</table>\n";if(!information_schema(DB)){$Jg="<input type='submit' value='".lang(247)."'".on_help("'VACUUM'")."> ";$ee="<input type='submit' name='optimize' value='".lang(248)."'".on_help($y=="sql"?"'OPTIMIZE TABLE'":"'VACUUM OPTIMIZE'")."> ";echo"<fieldset><legend>".lang(110)." <span id='selected'></span></legend><div>".($y=="sqlite"?$Jg:($y=="pgsql"?$Jg.$ee:($y=="sql"?"<input type='submit' value='".lang(249)."'".on_help("'ANALYZE TABLE'")."> ".$ee."<input type='submit' name='check' value='".lang(250)."'".on_help("'CHECK TABLE'")."> "."<input type='submit' name='repair' value='".lang(251)."'".on_help("'REPAIR TABLE'")."> ":"")))."<input type='submit' name='truncate' value='".lang(252)."'".confirm().on_help($y=="sqlite"?"'DELETE'":"'TRUNCATE".($y=="pgsql"?"'":" TABLE'"))."> "."<input type='submit' name='drop' value='".lang(111)."'".confirm().on_help("'DROP TABLE'").">\n";$j=(support("scheme")?$c->schemas():$c->databases());if(count($j)!=1&&$y!="sqlite"){$k=(isset($_POST["target"])?$_POST["target"]:(support("scheme")?$_GET["ns"]:DB));echo"<p>".lang(253).": ",($j?html_select("target",$j,$k):'<input name="target" value="'.h($k).'" autocapitalize="off">')," <input type='submit' name='move' value='".lang(254)."'>",(support("copy")?" <input type='submit' name='copy' value='".lang(255)."'>":""),"\n";}echo"<input type='hidden' name='all' value='' onclick=\"selectCount('selected', formChecked(this, /^(tables|views)\[/));".(support("table")?" selectCount('selected2', formChecked(this, /^tables\[/) || $S);":"")."\">\n";echo"<input type='hidden' name='token' value='$T'>\n","</div></fieldset>\n";}echo"</form>\n","<script type='text/javascript'>tableCheck();</script>\n";}echo'<p class="links"><a href="'.h(ME).'create=">'.lang(62)."</a>\n",(support("view")?'<a href="'.h(ME).'view=">'.lang(183)."</a>\n":""),(support("materializedview")?'<a href="'.h(ME).'view=&amp;materialized=1">'.lang(256)."</a>\n":"");if(support("routine")){echo"<h3 id='routines'>".lang(126)."</h3>\n";$of=routines();if($of){echo"<table cellspacing='0'>\n",'<thead><tr><th>'.lang(164).'<td>'.lang(87).'<td>'.lang(200)."<td>&nbsp;</thead>\n";odd('');foreach($of
as$L){echo'<tr'.odd().'>','<th><a href="'.h(ME).($L["ROUTINE_TYPE"]!="PROCEDURE"?'callf=':'call=').urlencode($L["ROUTINE_NAME"]).'">'.h($L["ROUTINE_NAME"]).'</a>','<td>'.h($L["ROUTINE_TYPE"]),'<td>'.h($L["DTD_IDENTIFIER"]),'<td><a href="'.h(ME).($L["ROUTINE_TYPE"]!="PROCEDURE"?'function=':'procedure=').urlencode($L["ROUTINE_NAME"]).'">'.lang(119)."</a>";}echo"</table>\n";}echo'<p class="links">'.(support("procedure")?'<a href="'.h(ME).'procedure=">'.lang(199).'</a>':'').'<a href="'.h(ME).'function=">'.lang(198)."</a>\n";}if(support("event")){echo"<h3 id='events'>".lang(127)."</h3>\n";$M=get_rows("SHOW EVENTS");if($M){echo"<table cellspacing='0'>\n","<thead><tr><th>".lang(164)."<td>".lang(257)."<td>".lang(189)."<td>".lang(190)."<td></thead>\n";foreach($M
as$L){echo"<tr>","<th>".h($L["Name"]),"<td>".($L["Execute at"]?lang(258)."<td>".$L["Execute at"]:lang(191)." ".$L["Interval value"]." ".$L["Interval field"]."<td>$L[Starts]"),"<td>$L[Ends]",'<td><a href="'.h(ME).'event='.urlencode($L["Name"]).'">'.lang(119).'</a>';}echo"</table>\n";$Zb=$g->result("SELECT @@event_scheduler");if($Zb&&$Zb!="ON")echo"<p class='error'><code class='jush-sqlset'>event_scheduler</code>: ".h($Zb)."\n";}echo'<p class="links"><a href="'.h(ME).'event=">'.lang(188)."</a>\n";}if($Wf)echo"<script type='text/javascript'>ajaxSetHtml('".js_escape(ME)."script=db');</script>\n";}}}page_footer();