Files
AvianVisitors/scripts/adminer-fr.php
Alexandre eeb2048ca6 Adminer iframe ? (#78)
* Show Adminer in iframe

* Add a link to open in a new page if needed

* X-Frame-Options to SameOrigin

* Use uppercase as per standard
2024-06-01 09:03:54 +02:00

908 lines
191 KiB
PHP
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?php
/** Adminer - Compact database management
* @link https://www.adminer.org/
* @author Jakub Vrana, https://www.vrana.cz/
* @copyright 2007 Jakub Vrana
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
* @version 4.8.1
*/$_GET['sqlite']='';class
AdminerPlugin
extends
Adminer{var$plugins;function
_findRootClass($Ja){do$K=$Ja;while($Ja=get_parent_class($Ja));return$K;}function
__construct($Ge){if($Ge===null){$Ge=array();foreach(get_declared_classes()as$Ja){if(preg_match('~^Adminer.~i',$Ja)&&strcasecmp($this->_findRootClass($Ja),'Adminer'))$Ge[$Ja]=new$Ja;}}$this->plugins=$Ge;}function
_callParent($s,$c){return
call_user_func_array(array('parent',$s),$c);}function
_applyPlugin($s,$c){foreach($this->plugins
as$Fe){if(method_exists($Fe,$s)){switch(count($c)){case
0:$K=$Fe->$s();break;case
1:$K=$Fe->$s($c[0]);break;case
2:$K=$Fe->$s($c[0],$c[1]);break;case
3:$K=$Fe->$s($c[0],$c[1],$c[2]);break;case
4:$K=$Fe->$s($c[0],$c[1],$c[2],$c[3]);break;case
5:$K=$Fe->$s($c[0],$c[1],$c[2],$c[3],$c[4]);break;case
6:$K=$Fe->$s($c[0],$c[1],$c[2],$c[3],$c[4],$c[5]);break;default:trigger_error('Too many parameters.',E_USER_WARNING);}if($K!==null)return$K;}}return$this->_callParent($s,$c);}function
_appendPlugin($s,$c){$K=$this->_callParent($s,$c);foreach($this->plugins
as$Fe){if(method_exists($Fe,$s)){$Y=call_user_func_array(array($Fe,$s),$c);if($Y)$K+=$Y;}}return$K;}function
dumpFormat(){$c=func_get_args();return$this->_appendPlugin(__FUNCTION__,$c);}function
dumpOutput(){$c=func_get_args();return$this->_appendPlugin(__FUNCTION__,$c);}function
editRowPrint($R,$n,$L,$Kg){$c=func_get_args();return$this->_appendPlugin(__FUNCTION__,$c);}function
editFunctions($m){$c=func_get_args();return$this->_appendPlugin(__FUNCTION__,$c);}function
name(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
credentials(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
connectSsl(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
permanentLogin($h=false){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
bruteForceKey(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
serverName($O){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
database(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
schemas(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
databases($mc=true){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
queryTimeout(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
headers(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
csp(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
head(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
css(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
loginForm(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
loginFormField($F,$Ec,$Y){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
login($rd,$_e){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
tableName($Vf){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
fieldName($m,$fe=0){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLinks($Vf,$P=""){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
foreignKeys($R){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
backwardKeys($R,$Uf){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
backwardKeysPrint($va,$L){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectQuery($I,$Lf,$fc=false){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
sqlCommandQuery($I){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
rowDescription($R){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
rowDescriptions($M,$pc){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLink($X,$m){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectVal($X,$A,$m,$ne){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
editVal($X,$m){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
tableStructurePrint($n){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
tableIndexesPrint($x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectColumnsPrint($N,$e){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectSearchPrint($Z,$e,$x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectOrderPrint($fe,$e,$x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLimitPrint($_){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLengthPrint($ig){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectActionPrint($x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectCommandPrint(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectImportPrint(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectEmailPrint($Lb,$e){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectColumnsProcess($e,$x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectSearchProcess($n,$x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectOrderProcess($n,$x){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLimitProcess(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectLengthProcess(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectEmailProcess($Z,$pc){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
selectQueryBuild($N,$Z,$t,$fe,$_,$G){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
messageQuery($I,$jg,$fc=false){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
editInput($R,$m,$ra,$Y){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
editHint($R,$m,$Y){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
processInput($m,$Y,$s=""){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
dumpDatabase($j){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
dumpTable($R,$Pf,$Yc=0){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
dumpData($R,$Pf,$I){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
dumpFilename($Jc){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
dumpHeaders($Jc,$Id=false){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
importServerPath(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
homepage(){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
navigation($Hd){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
databasesPrint($Hd){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}function
tablesPrint($T){$c=func_get_args();return$this->_applyPlugin(__FUNCTION__,$c);}}class
FCSqliteConnectionWithoutCredentials{function
loginForm(){$b=adminer();echo'<div class="error">'.'Attention : ne l\'utilisez pas dans un environnement de production !'.'</div>',"<table cellspacing='0' class='layout'>\n",'<input type="hidden" name="auth[driver]" value="sqlite">',$b->loginFormField('db','<tr><th>'.'Base de données'.'<td>','<input name="auth[db]" value="'.h($_GET["db"]).'" autocapitalize="off">'."\n"),"</table>\n","<p><input type='submit' value='".'Authentification'."'>\n";return
true;}function
login($rd,$_e){return
true;}}function
adminer_object(){$Ge=array(new
FCSqliteConnectionWithoutCredentials());return
new
AdminerPlugin($Ge);}function
adminer_errors($Rb,$Tb){return!!preg_match('~^(Trying to access array offset on value of type null|Undefined array key)~',$Tb);}error_reporting(6135);set_error_handler('adminer_errors',E_WARNING);$kc=!preg_match('~^(unsafe_raw)?$~',ini_get("filter.default"));if($kc||ini_get("filter.default_flags")){foreach(array('_GET','_POST','_COOKIE','_SERVER')as$X){$Hg=filter_input_array(constant("INPUT$X"),FILTER_UNSAFE_RAW);if($Hg)$$X=$Hg;}}if(function_exists("mb_internal_encoding"))mb_internal_encoding("8bit");function
connection(){global$f;return$f;}function
adminer(){global$b;return$b;}function
version(){global$da;return$da;}function
idf_unescape($Kc){if(!preg_match('~^[`\'"]~',$Kc))return$Kc;$hd=substr($Kc,-1);return
str_replace($hd.$hd,$hd,substr($Kc,1,-1));}function
escape_string($X){return
substr(q($X),1,-1);}function
number($X){return
preg_replace('~[^0-9]+~','',$X);}function
number_type(){return'((?<!o)int(?!er)|numeric|real|float|double|decimal|money)';}function
remove_slashes($Te,$kc=false){if(function_exists("get_magic_quotes_gpc")&&get_magic_quotes_gpc()){while(list($z,$X)=each($Te)){foreach($X
as$ad=>$W){unset($Te[$z][$ad]);if(is_array($W)){$Te[$z][stripslashes($ad)]=$W;$Te[]=&$Te[$z][stripslashes($ad)];}else$Te[$z][stripslashes($ad)]=($kc?$W:stripslashes($W));}}}}function
bracket_escape($Kc,$ua=false){static$vg=array(':'=>':1',']'=>':2','['=>':3','"'=>':4');return
strtr($Kc,($ua?array_flip($vg):$vg));}function
min_version($Xg,$td="",$g=null){global$f;if(!$g)$g=$f;$yf=$g->server_info;if($td&&preg_match('~([\d.]+)-MariaDB~',$yf,$C)){$yf=$C[1];$Xg=$td;}return(version_compare($yf,$Xg)>=0);}function
charset($f){return(min_version("5.5.3",0,$f)?"utf8mb4":"utf8");}function
script($Ff,$ug="\n"){return"<script".nonce().">$Ff</script>$ug";}function
script_src($Mg){return"<script src='".h($Mg)."'".nonce()."></script>\n";}function
nonce(){return' nonce="'.get_nonce().'"';}function
target_blank(){return' target="_blank" rel="noreferrer noopener"';}function
h($Q){return
str_replace("\0","&#0;",htmlspecialchars($Q,ENT_QUOTES,'utf-8'));}function
nl_br($Q){return
str_replace("\n","<br>",$Q);}function
checkbox($F,$Y,$Fa,$ed="",$Yd="",$Ja="",$fd=""){$K="<input type='checkbox' name='$F' value='".h($Y)."'".($Fa?" checked":"").($fd?" aria-labelledby='$fd'":"").">".($Yd?script("qsl('input').onclick = function () { $Yd };",""):"");return($ed!=""||$Ja?"<label".($Ja?" class='$Ja'":"").">$K".h($ed)."</label>":$K);}function
optionlist($de,$tf=null,$Qg=false){$K="";foreach($de
as$ad=>$W){$ee=array($ad=>$W);if(is_array($W)){$K.='<optgroup label="'.h($ad).'">';$ee=$W;}foreach($ee
as$z=>$X)$K.='<option'.($Qg||is_string($z)?' value="'.h($z).'"':'').(($Qg||is_string($z)?(string)$z:$X)===$tf?' selected':'').'>'.h($X);if(is_array($W))$K.='</optgroup>';}return$K;}function
html_select($F,$de,$Y="",$Xd=true,$fd=""){if($Xd)return"<select name='".h($F)."'".($fd?" aria-labelledby='$fd'":"").">".optionlist($de,$Y)."</select>".(is_string($Xd)?script("qsl('select').onchange = function () { $Xd };",""):"");$K="";foreach($de
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($ra,$de,$Y="",$Xd="",$Ee=""){$cg=($de?"select":"input");return"<$cg$ra".($de?"><option value=''>$Ee".optionlist($de,$Y,true)."</select>":" size='10' value='".h($Y)."' placeholder='$Ee'>").($Xd?script("qsl('$cg').onchange = $Xd;",""):"");}function
confirm($D="",$uf="qsl('input')"){return
script("$uf.onclick = function () { return confirm('".($D?js_escape($D):'Êtes-vous certain(e) ?')."'); };","");}function
print_fieldset($v,$md,$ah=false){echo"<fieldset><legend>","<a href='#fieldset-$v'>$md</a>",script("qsl('a').onclick = partial(toggle, 'fieldset-$v');",""),"</legend>","<div id='fieldset-$v'".($ah?"":" class='hidden'").">\n";}function
bold($Aa,$Ja=""){return($Aa?" class='active $Ja'":($Ja?" class='$Ja'":""));}function
odd($K=' class="odd"'){static$u=0;if(!$K)$u=-1;return($u++%2?$K:'');}function
js_escape($Q){return
addcslashes($Q,"\r\n'\\/");}function
json_row($z,$X=null){static$lc=true;if($lc)echo"{";if($z!=""){echo($lc?"":",")."\n\t\"".addcslashes($z,"\r\n\t\"\\/").'": '.($X!==null?'"'.addcslashes($X,"\r\n\"\\/").'"':'null');$lc=false;}else{echo"\n}\n";$lc=true;}}function
ini_bool($Pc){$X=ini_get($Pc);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($Wg,$O,$Rg,$_e){$_SESSION["pwds"][$Wg][$O][$Rg]=($_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($Q){global$f;return$f->quote($Q);}function
get_vals($I,$d=0){global$f;$K=array();$J=$f->query($I);if(is_object($J)){while($L=$J->fetch_row())$K[]=$L[$d];}return$K;}function
get_key_vals($I,$g=null,$Af=true){global$f;if(!is_object($g))$g=$f;$K=array();$J=$g->query($I);if(is_object($J)){while($L=$J->fetch_row()){if($Af)$K[$L[0]]=$L[1];else$K[]=$L[0];}}return$K;}function
get_rows($I,$g=null,$l="<p class='error'>"){global$f;$Xa=(is_object($g)?$g:$f);$K=array();$J=$Xa->query($I);if(is_object($J)){while($L=$J->fetch_assoc())$K[]=$L;}elseif(!$J&&!is_object($g)&&$l&&defined("PAGE_HEADER"))echo$l.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,$n=array()){global$f,$y;$K=array();foreach((array)$Z["where"]as$z=>$X){$z=bracket_escape($z,1);$d=escape_key($z);$K[]=$d.($y=="sql"&&is_numeric($X)&&preg_match('~\.~',$X)?" LIKE ".q($X):($y=="mssql"?" LIKE ".q(preg_replace('~[_%[]~','[\0]',$X)):" = ".unconvert_field($n[$z],q($X))));if($y=="sql"&&preg_match('~char|text~',$n[$z]["type"])&&preg_match("~[^ -@]~",$X))$K[]="$d = ".q($X)." COLLATE ".charset($f)."_bin";}foreach((array)$Z["null"]as$z)$K[]=escape_key($z)." IS NULL";return
implode(" AND ",$K);}function
where_check($X,$n=array()){parse_str($X,$Ea);remove_slashes(array(&$Ea));return
where($Ea,$n);}function
where_link($u,$d,$Y,$Zd="="){return"&where%5B$u%5D%5Bcol%5D=".urlencode($d)."&where%5B$u%5D%5Bop%5D=".urlencode(($Y!==null?$Zd:"IS NULL"))."&where%5B$u%5D%5Bval%5D=".urlencode($Y);}function
convert_fields($e,$n,$N=array()){$K="";foreach($e
as$z=>$X){if($N&&!in_array(idf_escape($z),$N))continue;$pa=convert_field($n[$z]);if($pa)$K.=", $pa AS ".idf_escape($z);}return$K;}function
cookie($F,$Y,$pd=2592000){global$aa;return
header("Set-Cookie: $F=".urlencode($Y).($pd?"; expires=".gmdate("D, d M Y H:i:s",time()+$pd)." GMT":"")."; path=".preg_replace('~\?.*~','',$_SERVER["REQUEST_URI"]).($aa?"; secure":"")."; HttpOnly; SameSite=lax",false);}function
restart_session(){if(!ini_bool("session.use_cookies"))session_start();}function
stop_session($nc=false){$Pg=ini_bool("session.use_cookies");if(!$Pg||$nc){session_write_close();if($Pg&&@ini_set("session.use_cookies",false)===false)session_start();}}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($Wg,$O,$Rg,$j=null){global$zb;preg_match('~([^?]*)\??(.*)~',remove_from_uri(implode("|",array_keys($zb))."|username|".($j!==null?"db|":"").session_name()),$C);return"$C[1]?".(sid()?SID."&":"").($Wg!="server"||$O!=""?urlencode($Wg)."=".urlencode($O)."&":"")."username=".urlencode($Rg).($j!=""?"&db=".urlencode($j):"").($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,$bf=true,$Xb=true,$fc=false,$jg=""){global$f,$l,$b;if($Xb){$Lf=microtime(true);$fc=!$f->query($I);$jg=format_time($Lf);}$Hf="";if($I)$Hf=$b->messageQuery($I,$jg,$fc);if($fc){$l=error().$Hf.script("messagesPrint();");return
false;}if($bf)redirect($B,$D.$Hf);return
true;}function
queries($I){global$f;static$We=array();static$Lf;if(!$Lf)$Lf=microtime(true);if($I===null)return
array(implode("\n",$We),format_time($Lf));$We[]=(preg_match('~;$~',$I)?"DELIMITER ;;\n$I;\nDELIMITER ":$I).";";return$f->query($I);}function
apply_queries($I,$T,$Ub='table'){foreach($T
as$R){if(!queries("$I ".$Ub($R)))return
false;}return
true;}function
queries_redirect($B,$D,$bf){list($We,$jg)=queries(null);return
query_redirect($We,$B,$D,$bf,false,!$bf,$jg);}function
format_time($Lf){return
sprintf('%.3f s',max(0,microtime(true)-$Lf));}function
relative_uri(){return
str_replace(":","%3a",preg_replace('~^[^?]*/([^?]*)~','\1',$_SERVER["REQUEST_URI"]));}function
remove_from_uri($te=""){return
substr(preg_replace("~(?<=[?&])($te".(SID?"":"|".session_name()).")=[^&]*&~",'',relative_uri()."&"),0,-1);}function
pagination($G,$fb){return" ".($G==$fb?$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,$nb=false){$jc=$_FILES[$z];if(!$jc)return
null;foreach($jc
as$z=>$X)$jc[$z]=(array)$X;$K='';foreach($jc["error"]as$z=>$l){if($l)return$l;$F=$jc["name"][$z];$rg=$jc["tmp_name"][$z];$Ya=file_get_contents($nb&&preg_match('~\.gz$~',$F)?"compress.zlib://$rg":$rg);if($nb){$Lf=substr($Ya,0,3);if(function_exists("iconv")&&preg_match("~^\xFE\xFF|^\xFF\xFE~",$Lf,$hf))$Ya=iconv("utf-16","utf-8",$Ya);elseif($Lf=="\xEF\xBB\xBF")$Ya=substr($Ya,3);$K.=$Ya."\n\n";}else$K.=$Ya;}return$K;}function
upload_error($l){$zd=($l==UPLOAD_ERR_INI_SIZE?ini_get("upload_max_filesize"):0);return($l?'Impossible d\'importer le fichier.'.($zd?" ".sprintf('La taille maximale des fichiers est de %sB.',$zd):""):'Le fichier est introuvable.');}function
repeat_pattern($Be,$nd){return
str_repeat("$Be{0,65535}",$nd/65535)."$Be{0,".($nd%65535)."}";}function
is_utf8($X){return(preg_match('~~u',$X)&&!preg_match('~[\0-\x8\xB\xC\xE-\x1F]~',$X));}function
shorten_utf8($Q,$nd=80,$Rf=""){if(!preg_match("(^(".repeat_pattern("[\t\r\n -\x{10FFFF}]",$nd).")($)?)u",$Q,$C))preg_match("(^(".repeat_pattern("[\t\r\n -~]",$nd).")($)?)",$Q,$C);return
h($C[1]).$Rf.(isset($C[2])?"":"<i>…</i>");}function
format_number($X){return
strtr(number_format($X,0,".",','),preg_split('~~u','0123456789',-1,PREG_SPLIT_NO_EMPTY));}function
friendly_url($X){return
preg_replace('~[^a-z0-9_]~i','-',$X);}function
hidden_fields($Te,$Lc=array(),$Me=''){$K=false;foreach($Te
as$z=>$X){if(!in_array($z,$Lc)){if(is_array($X))hidden_fields($X,array(),$z);else{$K=true;echo'<input type="hidden" name="'.h($Me?$Me."[$z]":$z).'" value="'.h($X).'">';}}}return$K;}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($R,$gc=false){$K=table_status($R,$gc);return($K?$K:array("Name"=>$R));}function
column_foreign_keys($R){global$b;$K=array();foreach($b->foreignKeys($R)as$p){foreach($p["source"]as$X)$K[$X][]=$p;}return$K;}function
enum_input($V,$ra,$m,$Y,$Nb=null){global$b;preg_match_all("~'((?:[^']|'')*)'~",$m["length"],$ud);$K=($Nb!==null?"<label><input type='$V'$ra value='$Nb'".((is_array($Y)?in_array($Nb,$Y):$Y===0)?" checked":"")."><i>".'vide'."</i></label>":"");foreach($ud[1]as$u=>$X){$X=stripcslashes(str_replace("''","'",$X));$Fa=(is_int($Y)?$Y==$u+1:(is_array($Y)?in_array($u+1,$Y):$Y===$X));$K.=" <label><input type='$V'$ra value='".($u+1)."'".($Fa?' checked':'').'>'.h($b->editVal($X,$m)).'</label>';}return$K;}function
input($m,$Y,$s){global$Cg,$b,$y;$F=h(bracket_escape($m["field"]));echo"<td class='function'>";if(is_array($Y)&&!$s){$c=array($Y);if(version_compare(PHP_VERSION,5.4)>=0)$c[]=JSON_PRETTY_PRINT;$Y=call_user_func_array('json_encode',$c);$s="json";}$if=($y=="mssql"&&$m["auto_increment"]);if($if&&!$_POST["save"])$s=null;$uc=(isset($_GET["select"])||$if?array("orig"=>'original'):array())+$b->editFunctions($m);$ra=" name='fields[$F]'";if($m["type"]=="enum")echo
h($uc[""])."<td>".$b->editInput($_GET["edit"],$m,$ra,$Y);else{$Bc=(in_array($s,$uc)||isset($uc[$s]));echo(count($uc)>1?"<select name='function[$F]'>".optionlist($uc,$s===null||$Bc?$s:"")."</select>".on_help("getTarget(event).value.replace(/^SQL\$/, '')",1).script("qsl('select').onchange = functionChange;",""):h(reset($uc))).'<td>';$Rc=$b->editInput($_GET["edit"],$m,$ra,$Y);if($Rc!="")echo$Rc;elseif(preg_match('~bool~',$m["type"]))echo"<input type='hidden'$ra value='0'>"."<input type='checkbox'".(preg_match('~^(1|t|true|y|yes|on)$~i',$Y)?" checked='checked'":"")."$ra value='1'>";elseif($m["type"]=="set"){preg_match_all("~'((?:[^']|'')*)'~",$m["length"],$ud);foreach($ud[1]as$u=>$X){$X=stripcslashes(str_replace("''","'",$X));$Fa=(is_int($Y)?($Y>>$u)&1:in_array($X,explode(",",$Y),true));echo" <label><input type='checkbox' name='fields[$F][$u]' value='".(1<<$u)."'".($Fa?' checked':'').">".h($b->editVal($X,$m)).'</label>';}}elseif(preg_match('~blob|bytea|raw|file~',$m["type"])&&ini_bool("file_uploads"))echo"<input type='file' name='fields-$F'>";elseif(($hg=preg_match('~text|lob|memo~i',$m["type"]))||preg_match("~\n~",$Y)){if($hg&&$y!="sqlite")$ra.=" cols='50' rows='12'";else{$M=min(12,substr_count($Y,"\n")+1);$ra.=" cols='30' rows='$M'".($M==1?" style='height: 1.2em;'":"");}echo"<textarea$ra>".h($Y).'</textarea>';}elseif($s=="json"||preg_match('~^jsonb?$~',$m["type"]))echo"<textarea$ra cols='50' rows='12' class='jush-js'>".h($Y).'</textarea>';else{$Ad=(!preg_match('~int~',$m["type"])&&preg_match('~^(\d+)(,(\d+))?$~',$m["length"],$C)?((preg_match("~binary~",$m["type"])?2:1)*$C[1]+($C[3]?1:0)+($C[2]&&!$m["unsigned"]?1:0)):($Cg[$m["type"]]?$Cg[$m["type"]]+($m["unsigned"]?0:1):0));if($y=='sql'&&min_version(5.6)&&preg_match('~time~',$m["type"]))$Ad+=7;echo"<input".((!$Bc||$s==="")&&preg_match('~(?<!o)int(?!er)~',$m["type"])&&!preg_match('~\[\]~',$m["full_type"])?" type='number'":"")." value='".h($Y)."'".($Ad?" data-maxlength='$Ad'":"").(preg_match('~char|binary~',$m["type"])&&$Ad>20?" size='40'":"")."$ra>";}echo$b->editHint($_GET["edit"],$m,$Y);$lc=0;foreach($uc
as$z=>$X){if($z===""||!$X)break;$lc++;}if($lc)echo
script("mixin(qsl('td'), {onchange: partial(skipOriginal, $lc), oninput: function () { this.onchange(); }});");}}function
process_input($m){global$b,$k;$Kc=bracket_escape($m["field"]);$s=$_POST["function"][$Kc];$Y=$_POST["fields"][$Kc];if($m["type"]=="enum"){if($Y==-1)return
false;if($Y=="")return"NULL";return+$Y;}if($m["auto_increment"]&&$Y=="")return
null;if($s=="orig")return(preg_match('~^CURRENT_TIMESTAMP~i',$m["on_update"])?idf_escape($m["field"]):false);if($s=="NULL")return"NULL";if($m["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~',$m["type"])&&ini_bool("file_uploads")){$jc=get_file("fields-$Kc");if(!is_string($jc))return
false;return$k->quoteBinary($jc);}return$b->processInput($m,$Y,$s);}function
fields_from_edit(){global$k;$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==$k->primary),);}return$K;}function
search_tables(){global$b,$f;$_GET["where"][0]["val"]=$_POST["query"];$wf="<ul>\n";foreach(table_status('',true)as$R=>$S){$F=$b->tableName($S);if(isset($S["Engine"])&&$F!=""&&(!$_POST["tables"]||in_array($R,$_POST["tables"]))){$J=$f->query("SELECT".limit("1 FROM ".table($R)," WHERE ".implode(" AND ",$b->selectSearchProcess(fields($R),array())),1));if(!$J||$J->fetch_row()){$Qe="<a href='".h(ME."select=".urlencode($R)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]))."'>$F</a>";echo"$wf<li>".($J?$Qe:"<p class='error'>$Qe: ".error())."\n";$wf="";}}}echo($wf?"<p class='message'>".'Aucune table.':"</ul>")."\n";}function
dump_headers($Jc,$Id=false){global$b;$K=$b->dumpHeaders($Jc,$Id);$qe=$_POST["output"];if($qe!="text")header("Content-Disposition: attachment; filename=".$b->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]|^0|\.\d*0$~',$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{$o=@tempnam("","");if(!$o)return
false;$K=dirname($o);unlink($o);}}return$K;}function
file_open_lock($o){$r=@fopen($o,"r+");if(!$r){$r=@fopen($o,"w");if(!$r)return;chmod($o,0660);}flock($r,LOCK_EX);return$r;}function
file_write_unlock($r,$hb){rewind($r);fwrite($r,$hb);ftruncate($r,strlen($hb));flock($r,LOCK_UN);fclose($r);}function
password_file($h){$o=get_temp_dir()."/adminer.key";$K=@file_get_contents($o);if($K||!$h)return$K;$r=@fopen($o,"w");if($r){chmod($o,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,$m,$ig){global$b;if(is_array($X)){$K="";foreach($X
as$ad=>$W)$K.="<tr>".($X!=array_values($X)?"<th>".h($ad):"")."<td>".select_value($W,$A,$m,$ig);return"<table cellspacing='0'>$K</table>";}if(!$A)$A=$b->selectLink($X,$m);if($A===null){if(is_mail($X))$A="mailto:$X";if(is_url($X))$A=$X;}$K=$b->editVal($X,$m);if($K!==null){if(!is_utf8($K))$K="\0";elseif($ig!=""&&is_shortable($m))$K=shorten_utf8($K,max(0,+$ig));else$K=h($K);}return$b->selectVal($K,$A,$m,$X);}function
is_mail($Kb){$qa='[-a-z0-9!#$%&\'*+/=?^_`{|}~]';$yb='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';$Be="$qa+(\\.$qa+)*@($yb?\\.)+$yb";return
is_string($Kb)&&preg_match("(^$Be(,\\s*$Be)*\$)i",$Kb);}function
is_url($Q){$yb='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';return
preg_match("~^(https?)://($yb?\\.)+$yb(:\\d+)?(/.*)?(\\?.*)?(#.*)?\$~i",$Q);}function
is_shortable($m){return
preg_match('~char|text|json|lob|geometry|point|linestring|polygon|string|bytea~',$m["type"]);}function
count_rows($R,$Z,$Wc,$t){global$y;$I=" FROM ".table($R).($Z?" WHERE ".implode(" AND ",$Z):"");return($Wc&&($y=="sql"||count($t)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$t).")$I":"SELECT COUNT(*)".($Wc?" FROM (SELECT 1$I GROUP BY ".implode(", ",$t).") x":$I));}function
slow_query($I){global$b,$U,$k;$j=$b->database();$kg=$b->queryTimeout();$Ef=$k->slowQuery($I,$kg);if(!$Ef&&support("kill")&&is_object($g=connect())&&($j==""||$g->select_db($j))){$dd=$g->result(connection_id());echo'<script',nonce(),'>
var timeout = setTimeout(function () {
ajax(\'',js_escape(ME),'script=kill\', function () {
}, \'kill=',$dd,'&token=',$U,'\');
}, ',1000*$kg,');
</script>
';}else$g=null;ob_flush();flush();$K=@get_key_vals(($Ef?$Ef:$I),$g,false);if($g){echo
script("clearTimeout(timeout);");ob_flush();flush();}return$K;}function
get_token(){$Ze=rand(1,1e6);return($Ze^$_SESSION["token"]).":$Ze";}function
verify_token(){list($U,$Ze)=explode(":",$_POST["token"]);return($Ze^$_SESSION["token"])==$U;}function
lzw_decompress($ya){$vb=256;$za=8;$La=array();$jf=0;$kf=0;for($u=0;$u<strlen($ya);$u++){$jf=($jf<<8)+ord($ya[$u]);$kf+=8;if($kf>=$za){$kf-=$za;$La[]=$jf>>$kf;$jf&=(1<<$kf)-1;$vb++;if($vb>>$za)$za++;}}$ub=range("\0","\xFF");$K="";foreach($La
as$u=>$Ka){$Jb=$ub[$Ka];if(!isset($Jb))$Jb=$gh.$gh[0];$K.=$Jb;if($u)$ub[]=$gh.$Jb[0];$gh=$Jb;}return$K;}function
on_help($Ra,$Cf=0){return
script("mixin(qsl('select, input'), {onmouseover: function (event) { helpMouseover.call(this, event, $Ra, $Cf) }, onmouseout: helpMouseout});","");}function
edit_form($R,$n,$L,$Kg){global$b,$y,$U,$l;$Wf=$b->tableName(table_status1($R,true));page_header(($Kg?'Modifier':'Insérer'),$l,array("select"=>array($R,$Wf)),$Wf);$b->editRowPrint($R,$n,$L,$Kg);if($L===false)echo"<p class='error'>".'Aucun résultat.'."\n";echo'<form action="" method="post" enctype="multipart/form-data" id="form">
';if(!$n)echo"<p class='error'>".'Vous n\'avez pas les droits pour mettre à jour cette table.'."\n";else{echo"<table cellspacing='0' class='layout'>".script("qsl('table').onkeydown = editingKeydown;");foreach($n
as$F=>$m){echo"<tr><th>".$b->fieldName($m);$ob=$_GET["set"][bracket_escape($F)];if($ob===null){$ob=$m["default"];if($m["type"]=="bit"&&preg_match("~^b'([01]*)'\$~",$ob,$hf))$ob=$hf[1];}$Y=($L!==null?($L[$F]!=""&&$y=="sql"&&preg_match("~enum|set~",$m["type"])?(is_array($L[$F])?array_sum($L[$F]):+$L[$F]):(is_bool($L[$F])?+$L[$F]:$L[$F])):(!$Kg&&$m["auto_increment"]?"":(isset($_GET["select"])?false:$ob)));if(!$_POST["save"]&&is_string($Y))$Y=$b->editVal($Y,$m);$s=($_POST["save"]?(string)$_POST["function"][$F]:($Kg&&preg_match('~^CURRENT_TIMESTAMP~i',$m["on_update"])?"now":($Y===false?null:($Y!==null?'':'NULL'))));if(!$_POST&&!$Kg&&$Y==$m["default"]&&preg_match('~^[\w.]+\(~',$Y))$s="SQL";if(preg_match("~time~",$m["type"])&&preg_match('~^CURRENT_TIMESTAMP~i',$Y)){$Y="";$s="now";}input($m,$Y,$s);echo"\n";}if(!support("table"))echo"<tr>"."<th><input name='field_keys[]'>".script("qsl('input').oninput = fieldChange;")."<td class='function'>".html_select("field_funs[]",$b->editFunctions(array("null"=>isset($_GET["select"]))))."<td><input name='field_vals[]'>"."\n";echo"</table>\n";}echo"<p>\n";if($n){echo"<input type='submit' value='".'Enregistrer'."'>\n";if(!isset($_GET["select"])){echo"<input type='submit' name='insert' value='".($Kg?'Enr. et continuer édition':'Enr. et insérer prochain')."' title='Ctrl+Shift+Enter'>\n",($Kg?script("qsl('input').onclick = function () { return !ajaxForm(this.form, '".'Enregistrement'."…', this); };"):"");}}echo($Kg?"<input type='submit' name='delete' value='".'Effacer'."'>".confirm()."\n":($_POST||!$n?"":script("focus(qsa('td', qs('#form'))[1].firstChild);")));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="',$U,'">
</form>
';}if(isset($_GET["file"])){if($_SERVER["HTTP_IF_MODIFIED_SINCE"]){header("HTTP/1.1 304 Not Modified");exit;}header("Expires: ".gmdate("D, d M Y H:i:s",time()+365*24*60*60)." GMT");header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");header("Cache-Control: immutable");if($_GET["file"]=="favicon.ico"){header("Content-Type: image/x-icon");echo
lzw_decompress("\0\0\0` \0\0\n @\0C\"\0`EQ?tvM'Jdd\\b0\0\"s5AXPaJ08#RTz`#.cXȀ?-\0Im?.M\0ȯ/(%\0");}elseif($_GET["file"]=="default.css"){header("Content-Type: text/css; charset=utf-8");echo
lzw_decompress("\n1ٌ̇l7B14vb0fsn2Bѱ٘n:#(b.\rDc)a7El ñi1̎s-4f i7t4yZf4iATVV f:Ϧ,:1b2`# >:7G1sLXD*bv<܌#e@:4!fot:<o\ni',a_:iBv|N4.5Nfivphl֚O= OFQk\$id2T p6-Z6h:a,2#8А#6nJht4O42ok*r@p@!?6r[L:2Bj!HbP=!1V\"0\nSD7C!! +=tC.C: +=%c1MR/EȒ42`8(ӹ[W =yS b=BS+ ɯ@pL4Ydq6 Ac܌Ψk[&>Zpkm]u-c:Ntδpҝ8=#[.ޯ~myPP|I֛Q9v[Q\nr'g+T2Vz48( Ey*#j2]R)[NR\$<>:>\$;>\rHT\nwN <Gw\\Y_Rt^>\r}S\rz4=\nL%J\",Z8i0u?s3 #ى:E]xs^8K^*0w~:iv2w^77cu+U%{P*4̼LX./!1Cqx!HFdLĠ`6 5fĆ=Hl V1\0a2;6_ه\0&ZSd)KE'n[ X\0F[Pޘ@!Y,`\"ڷ0Ee9 yF>9bF5:\0}Ĵ(\$37H MA6R{Mq7GCC m2(Ct>[-t/&C ]etG̬4@r><Sq/QhmL#K|6fKP\r%tV=\"SH\$} )w,W\0Fu@b 9\rr2#DXyOI>n Ǣ%'_t\rτz \\1hl]Q5Mp6kqh\$H~|!*4`SS tPP\\g7\n-:袪plBc(wO0\\:w p4{TjO6HÊrq\n%%y']\$aZ.fcq*-FWkzjlg:\$\"N\r#dÂsc̠\"j\rՒPh1/DA)[knp76YR{MP@\n-a6[zJH,dlBho+#Dr^^eE ĜaPJGzt2XVȳB_%K=Eb§kU(.!ܮ8 I.@Kxn:P32mH C*:vT\nR 0uҧ]P /JQd{L޳:Y2bT 34cV=L4r !BY6MeLio9< GƕЙMhm^UN Tr 5HiM/n흳T[-<__3/Xr(< uҖG NX20\r\$^:'9O;k fN'ab,V1HI!%6@\$EGڜ1(mUrս`iN+Ü)0lf0[UV-:I^\$sb\reugh~9߈bf+0 hXrݬ!\$e,w+3_Ak\nkrʛcu WdY\\={.čgp8t\rRZvJ:>Y|+@Ct\rjt6 %?ǎ>/ 9F`וv~KRWz lmwL9Y* qxzSeݛ~Dxɟi72_{53t_z3d)C\$?KӪP%T& &\0PNA^~p Ϝ\r\$b*+D6궦ψJ\$(olh&KBS>;zxoz>oZ\nʋ[vȜ2OxِV0f2Blbk6ZkhXcd0*KTH=πp0lV \rnm)((:#E:CC \rG\ré0i :`Z1Q\n:\r\0 q:`-M#}1;q#|ShlD\0fiDpL``0y1\r=MQ\\ %oq\0 1211 ќbi:\r/Ѣ `)0@›I1NCOZ1q1 ,\rdIǦvj1 tB⁒0:0 1A2V0%f i3!&QRc%q&w%\rV#Qw`% m*ry&i+r{*(rg(#(2()R@i- 1\"\0R.e.r, ry(2Cb!Bޏ3%ҵ,R1&tba\rL-3 \0 Bp194O'R3*=\$[^iI;/3i5 &}17# ѹ8\"789*23!!1\\\08rk9;S23 ړ*:q]5S<#383# e=>~9S螳r)T* a@іbes:-*;,ؙ3!i #1 +n *@3i71_FS;3F\rA3>x: \r0@-/w7SJ3 .F\$OB%4+t'gLq\rJtJM2\r7T@)ⓣd2P>ΰFi಴\nr\0bk(DKQ1\"2tP\r,\$KCt5#)P#Pi. U2C~\"");}elseif($_GET["file"]=="functions.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress("f:gCI\n83)781x:\nOg#)r7\n\"`|2gSiH)NS\r\"0@)`(\$s6O!V/=' T4=iS6IOG#XVCsZ1.hp8,[H ~Cz2lc3sIb4\nF8TIU*fzr0EyfY.:I(c΋!_l^^(N{S)rqYl٦33\n+GyixV3wuh^ra۔c\r(.ˆCh<\r)ѣ`743'm5\nP:2Pq C}ī38B0hRr(0b\\0Hr44B!p\$rZZ2܉.Ƀ(\\5 |\nC(\"P. NRTΓ>HN8HP\\7Jp~2%OC1.C8·H*jS( / 6KU<2 pOI`ⳈdOH5-4pX25-Ңۈz7 \" (P\\32:]U ߅!]<Aۤl\r\0v#J8wmɤ<ɠ%m;p#`XDiZN09 `wJD29t*yNiIh\\9:xﭵyl*ȈY8W?ޛ3 !\"6n[\r*\$ Ƨnzx9\r|*3ףp:(p\\;mz9Œ8Nj2\rHH&(z7ik cet2:SHȠ/)x@tri98V+^WڦkZYlʣ4Ƌ\\E{7\0pDi-T0l%=˃9(5\n\nn,4\0a}܃.Rs\02B\\b1S\0003,XPHJspd K CA!2*W2\$+f^\n1zE Iv\\2.*AE(db܄9Dh&?HsQ2x~nÁJT2&eRGQTwݑP\\)6sh\\3\0R '\r+*;RH.!['~%t< pK#‘!lLe,&\$ `CXӆ0֭:Mh ڜG!&3D<!23?hJe h\rmNiNHl7vWI . -5֧ey\rEJ\ni* \$@RU0,\$UEªu)@(tSJkp!~d`>\n ;#\rp9jɹ]&Nc(rTQUS\08n`ybLO5,>xf䴒+\"I{kM[\r% [ e a1! ԮF@b)R720\nWLܜҮtd+0wgl0n@ɢiM\nAM5n\$EױNl%1 AkriFBol,muNx-_֤C( fl\r1p[9x(izQl8C XU TbI`p+V\0;CbX+ϒs]H[kxG*]awn!6mSIK~/ӥ7eeNS/;dA>}l~ %^ fآpڜDEat\nx=*dTj2j\n ,e=M84aj@Tsnf\n6\rd0Y'%ԓ~ Ҩ< AHG8΃\$z{u2*a>(wK.bP{o´ z#28= 8>A,e+Cx*-b=m,alzk\$W,mJiʧ+0[ .RsKXZ L2`(CvZ\$׹,D?HNxX)M\$,*\nѣ\$<qşh!SxsA!:K}RA2kXp\n<l3VV}g&Yݍ!+;<YYE3rَCo5ճkkۣtU)[}ul:D+Ϗ _o h1400bK  lG#|UdIK7^@O\0HHi6\r\\cg\02B*e\n zr !nWz& {H'\$X w@8DGr*H'p#Į\nd , ,;g~ \0#E\rI`'%E.]` Л %&m\r%4Sv#\nfH\$% -#qBQ-c2 & ] qh\rl]sh 7n# -jEFrl&d zF6\"|s@z )0rpڏ\0X\0|DL<!o*D{.B<E0nB( |\r\n^ h!r\$(^~/pqBO,\\#RR%dHj ` ̭ V bSdiEohr<i/k\$-\$o+ŋlO&evƒijMPA'u' ( M(h/+WDSo. n.n((\"h&p//1D̊j娸E&⦀,'l\$/.,dWbbO3BsH:J`!.,F7(Կ  1ls ҎŢqX\r~R鰱`ҞY*:RrJ%L+n\"\r͇H!qb2Li%Wj#9ObE.I:67\06+%. a7E8VS?(DGӳB%;/<\r >M@HD s Z[tHEnx(Rx@GkjW>#T/8c8Q0_IIGII!YEdE^tdth`DV!C8\rb3!3@33N}ZB3 330M(>}\\tf fI\r 337 X\"td,\nbtNO`P;ܕҭ\$\nZѭ5U5WU^hotPM/5K4EjKQ&53GXXx)<5D\rV\nr5b܀\\J\">1S\r[-D u\r)00Yˢ k{\n#\r^|uܻU_nU4U~Yt\rI@䏳R 3:uePMS0TwWXDKOU;U\nOYYQ,M[\0_DWJ*\rg(]\r\"ZC6u+YY6ô0q(8}3AX3Th9jjfMtPJbqMP5>Yk%&\\1 dE4 Yn \$<U]Ӊ1mbֶ^\"NVppeMWܢ\\)\n \nf7\n2 r8=Ek7tV7PLa6v@'6ij&>;`a \0pڨ(J)\\nĬm\02eqJPtf j\"[\0X,<\\ +md~ s%omn),ׄԇ\r48\r mEH]HWM0D߀~ˁK E}|f^\r>-z]2sxDd[stS \0Qf-K`twT9Z \nB9 Nb<BI5ooJpJNd\r2\"xHCݍ:9Yn16zr+z\\m T @Y2lQ<2O+%.Ӄh0AZ2R1/hH\rXaNB& M@[xʮ8&LV͜v*jۚGH\\ٮ &s\0Q\\\"b \rBsw BN`7Co(\nè19*E SU0U t'|m?h[\$.#5 pyB@R]@|{P\0x/ w%EsBdCU~O׷P@X]Z31{eLYڐ\\(*R` \nQCF*pX|`N\$[@U Z`Zd\"\\\")I:toD \0[-g*`hu%,IHm6}Nͳ\$ MUYf&1e]pzImG/ w !\\#54IdEhqѬkx|kqDbz?>:[LƬZX:jw5 Y0 “\$\0CdSg{@\n` C M # t}xN{۰)CFKZj\0PFYBpFk0<>D<JEg\r.28U@*5fkJD4TDU76/@ K+J@=WIOD85MN\$R\05\r_EIϳNly\\qUQ \n@ۺpP۱7ԽN\rR{*qm\$\0Rԓq È+U@BOf*MC`_ ˵NT5٦C׻ \\We&_X_؍hB3%FW|Gޛ'[łV#^\r GRPFg Yi z\n+^/\\6bdmh@qAh),JWcmem]ӏekZb0Y]ymfeB;OwapDW{\0-2/bNsֽ޾RaϮh&qt\n\"iRmhzeFS7PP:BsmY d7}3?*tlT}~=c 3;TL5* ~#Asx-7f5`#\"NbG@e[s-M6qq he5\0Ң*bISFή9}p-`{ɖkP0T<Z90<՚\r;!g\r\nK \n\0*\nb7(_@,e2\r]K+\0p C\\Ѣ,0^@;X\r?\$\rj+/BPJ{\"a6|\n\0\\5  15 6 .[U د\0d8Y:!=X.uC!SopB7ůRh\\hE=y:< :u280siTsB@\$ @u Q.T0M\\/d+ƃ\n= dA) \r@@h38.eZa|.7 Ykc'D#Y@Xq=M44B AMdU\"Hw4(>8C?e_`X:A9øpGGy6FXrl1ػBÅ9RzhB{\0^-0%D5F\"\"™i`nAf \"tDZ\"_V\$!/D٦̀F,25jTy\0Nx\rYl#Eq\nB2\n64!/ \nQ*;)bRZ0\0CDo ˞48e\nS%\\PIk(0u/ G\\}4FpG_G?)got[v\0?b;`(یNS)\nx=+@7j0,1Åz>0GcLVX %Q+oFܶ>Q-clwz5G@(hcHr?Nb@lx3U`rwUt8=l#l䨉8E\"O6\n1e`\\hKfV/зPaYKO x Ojr7F;B̒>ЦV\rĖ|'Jz#PBY5\0NC^\n~LrRgeZ\0x^i<Q/)%@ʐfBHf{%P\"\"@)DE(iM2S*yS\"e̒1ט\n4`ʩ>Q*ynTu ~%+WXKQ[ʔlPYy#D٬D<FL@6'\rF`!%\n0c˩%c8WrpG.TDoUL2*|\$:Xt5XYIp# ^\n:#D@1\r*K7@D\0CCxBhEnK,1\"*y[#!יٙl_/x\05Z4\0005Jh\"2 %Yaa1SO4%niPߴq_ ʽ6~I\\ddD3g^@^6 _HD.ksL@ɈnI~\rb@ӀNt\0s]:uX b@^1\02?T6dLNe+\0:Ёlz6q=̺x N6O,%@s0\n\\) L<C|PbA>I\" ^K4g IXi@PjE&/1@f Nx0 co,C'y#6F@РH0{z3t|cXMJ.*B)ZDQ\0T-vXa*,*<b#xјdPKG8 yK \\# =)g ȑh&8])C\nô9zW\\gM 7! ,9\$T\",%.F!˚ A--g\0002R>KE'U_I9˼j(Q@@4/7'J.RT\0]KSDAp5\rH0!´e d@Rҝ9S;7HBbxJ_viU`@SAMXGXiU *':VWJvDN'\$zh\$d_yZ]Y]P*h֧e;pe\$kw*7NDTx_ԧGi&PԆb\\EH\$iE\"cr0l?>C(W@322aI{B`ڳiŸGo^6E\rGMp1iIX\00032Kzl&ֆ'IL\\\"7>j(>jFG_& 10IA31=h q\0Fķ_JԳVΖ܆q՚ (/dOC_sm<gx\0\"\n@EkH\0J8(km[S4\nY40+ L \n#Bӫb%R ֖׭R:<\$!ۥr; %|ʨ(|H\0]cҡ= 0Z\"\"=X)fN6V}F=[ৢhu-\0tbW~QiJL5׭q#kbWnQT!encS[+ִE<-a]ŃYb\n\nJ~|JɃ8 Lpo NܨJ.ŃS2c9jy-`a\0*ֈ@\0+mg61Me\0Q _}!IGL f) Xo ,Shx\0000\"h+LM јZ j\0/\$>u*Z9Ze+JtzRKԯDyq0C-fmBI|HBsQlX.|c[ ZhZlx@'mlKrQ26]ҷnd[񎩇d\"GJ9uBoan@nlW|*gX\nn2F |x`DkuPP!Q\rr`W/ 1[-o,71bUsN7Gq.\\Q\"CCT\"*?uts]٩Pz[[YFϹFD3\"]u۝)w z:#Iiwp ɛ{o0n;\\x\0qm&~79 [HqdLO2v|Bt\\ƤHdH\" N\n\0 GgFF}\"&QEK{}\rrכt7Nuó[Agh;S¥ |y[Ն_bȨ!+RZX@0NP%jD¯z [U\"{e8>EL4Jн07 d Q^`0`]c<g@hy8p.ef\neh aXmSjBژQ\"\rK3=>ǪAX[,,\"'<%aӴ.\$\0%\0sVpM\$@j>}Ve\$@̈́ #(3:`UYu @V#E G/XD\$havxS\"]k18aя9dJROӊs`EJUom{lB8(\n}eib, ;N͇Q\\ǸI5yR\$!>\\ʉguj*?nM޲h\r%U(dNd#}pA:-\\ A*42I\r֣ 0h@\\Ե83rq]d8\"Qƙ:cy4 ᑚda€Π6>UA:@2\$eh2FəN+\rԀ(Ard*\0[#cj>!(SLe TM 9\0W:BD3J_@srue +'B}\"B\"z2rlxF[L˲Ea9cdb^,UC=/2/\$C#8}D6 `^;6B0U7_= ,1j1V[. H9(1ҏLzC \$.Afh㖫DrY He~or19م\\߄P)\"Q,eLw0\0;w Xǝqo~>9>}dc\0gfq&9-J#3^4m/\0\0006n8>䈴cph_A@[7|9\$pMh>5KE=hAt^V \" cB;it@,\n)s`;4Iy-0yeʨUBv3HPG5s|\r\$01l3(*oF~PK.,'J/Ӳtd:n\njYz(wZ#Z Io@1λ \$=VWz nB aAq@Ip @lH{UoXfӿ\\z.,-\\ڗ^y n^BqzX㉡\$*J72D4.!M0DFGLmc*mcI^tjl7替SQ.ihLڱB6Ԅh&Jl\\Wecf%kj pR=i@.(2klHUW\"ojp!S5pL'`\0O *Q3X“lJ\08\n\r*ar`<&XBh8!x& Bht\$]cLd<`\0ςawO%;BCQ\r̭pPQZZAu=N&ia\nmK6I}n t\nd)bp\"g'07u&@ 78XNx\$BZB/MgBiѧ\\mmIĀ;5=#&4PՍqA\\,q\ncBw\0BgjD@;=0mk\rIJ` '5k-{\0_Mu2׆q>)9W\n d+ԧG\rn4O:581:Κ?(yGgWK \r7m5.eHhJAk# L..\\=UЄ:>7W+^yDbGOZ4r(|xPr,y8qaܩO2kn#p2Ljؔ.cUcłj\$8Ĭ~7ZR:׆89Ψw(aL%-,쿌#f%8|c%XW\n}6H˞#&J,'zMMຑ܆ /y6YQںdәd:Ep2gg/,Ո'8 ^;UWN{OCziKXڔNdGRCJYiy#>zSMUcRORԾ0)0]:=Ϟt'\$srF67  =\$B !qs 1\"v%Il<b!ۮ6(Cd-^<H`~2KzKٜԱ y,qA*\0}Cpb\\S5'(|MW5;\$5 T|;kt@;9);i.;_F=DM`H\0 N @%wdPb\$H|k[dCI!:l,<utNeϝW^w'6Dfu ihIZ:~ϣrz3+uoCs2buaXwWK HԶ27>WyMJrpTL|`f:Atd|i[wjW 7aueA5Q' ʐ\0 3Ҿ\$\rk)a;H=֐~IGI<\"I1'蠙Gcm\0P\nw#>xB\"Em|2\$}<3PYXgo<qE\"`4g8r]\n:qVbTm9K&ғĤm7)@Qz=ߵűH\n}Oi}\r٣.vpJW&u550 5PI\nl\0O5*= P-H \0f%tぺ*S:?ȂHq4K@Ԭ܂.O(Z\$]onzA!t85<WR2[8n5\$I浕Z]'}ET\n.&7V@_Do&J64ij\$ELut+IТأ~SSZT XPYz\"\$V_]M(7t_S /tĂmH:\05- _Z'# 1P,}(~\0!Җ`-P\ney (`9O!;5\n\${UA7![ YF> 8&!CLH(\0'Ǐ2d\r%;k抐4_O>5@DҼ\0VA6' AYSrԾ4+h@bOM\0@\rJm0\08O;kӠA(6| `8 \0&EV\0VwkNKxdpsALAXku\0t Ԣ.>(NK'fldA?++N~kPR\0xʑBK]bU\\̛d\0S@Q͉b\0\0b\0_\\@\nNOA PfԏAj M4<9 +`S w3T7XT!\0ePAIb 1!\04' @!8\0/!:K, CASXfeM.::t._d81v`B\"!.^*N.^\n&\r(. O0@Pnjڗ#&rH< !3(i @Aa { ¬#S6𨘶F@Y[O(./B) L02B؈-ƀqpJ<\0\n\0/@8C4P\r )F\$q.]\"B# #\\84\$s:.(*Oi>|#T'`Bua/CTKaX8`p\0`\0");}elseif($_GET["file"]=="jush.js"){header("Content-Type: text/javascript; charset=utf-8");echo
lzw_decompress("v0F==FS _6r:ECIo:CXc\r؄J(:=Ea28x?'iSANNxsNBVl0S Ul(D|҄P>E㩶yH ch-3Eb bpEp9.~\n?Kbiw|`d.x8EN!23\rYy6GFmY8o7\n\r0\0Dbc!Q7Шd8~N)Eг`Ns`S)O /<x9o3n2!r:;+9\n<`b\\?`4\r#`<Be B#N \r.D`j4par >8\$c1cc{n7ANRLi\r1!( j´+62X8+.\r!xh' 6S\0RO\n1(W07q:NE:68n+մ5_(s\r /m6P@EQ9\nV-\".:J8weqX]Y XezW 7Z1hQfuj4Z{p\\AUJ<k@ɍ@}&L7 UwuYh2@u P7Ah3 ÛXEͅZ]l@Mplv) HWy>Y-Y/hC[*F#~!`\r#0Pf \\^%B<\\fޱ&/OL\\jFjZ1\\:ƴ>NXaFAfh{\"s\n64?8^p\"ȸ\\e(PNq[gr&}PhW*r_sPh\nom#.\0@pdW \$ҺQ۽Tl0 HdH)ۏ )PHgUBe\rt:\0)\"t,[(DO\nR8!Ƭ֚lAV4hSq<@}gK]]=90'wA<a~WD|A2XU2yŊ=p)\0P sn3rf\0FvG I@%+_I` \r.NKI[ʖSJaUfSzM %\"Q|9Bcaq\08#<a:z1Uf>Zle5#U@iUG‚ns;gxLpP?BQ\\b 龒Q=7:ݡQ\r:t:y( \nd)\nX;CaA\rPGH!@9\n\nAl~HV\nsիƯbBr3\rP% ф\r}b/Α\$5PC\"wB_UgAt^QUjBvh졄4) +)<j^<L4U*Bg*nʖ- 9 O\$طzyM3\\9.oE(i 7 tߚ-&\nj!\ryyD1g]yR7\"~)TZ0E9MYZt Xe!f@{Ȭyl 8;R{8Įe+UL'F18PE5- _!7[2J;HRǹ8p痲݇@0,ծpsK0\r4\$sJ4DZI'\$cLRMpY&iz3GzҚJ%P-[/xT{pzCv:V'\\KJaM&Ӿ\"eo^Q+h^iT1ORl,5[ݘ\$)jLƁU`S`Z ^|r=n登TU 1Hykt+\0vD\r <ƙjGt*3%kY ܲT*|\"ClhE(\r8r{0D_.6и;rBjO'ۜ>\$`^69#4Xmh8:c0;;\\'(t'+ ̷^ ]Nv#,vOiϖ><SA\\\\!3*tl`u\0p'7P9bs{v{7\"{ra(^Eg/U9g/`\nL\n)(Aa\"  &P@O\n0(M&FJ'! 0<H*|*OZm*n/b/ .o\0dn)i:RP2m\0/vOXFʳψ\"000bgj\$n0} @ =MƂ 0nP/pot.̽ g\0)o\n0\rF bio}\n̯ NQ ' xFaJL\r\r0' d oep4Dʐq(~ \rEprQVFHlKjN&j!H`_bh\r1 n!Ɏ z \\\r`V_k\"\\ׂ'V\0ʾ`ACV`\r%\rk@NB !\n\0Z 6\$d,%%laH\n#S\$ !\$@2I\$r{!J2HZM\\hb, '||cj~gr`ļ\$ +A1E <L\$Y%-FDdL\n@bVf;2_(Lп <%@ڜ,\"dNer\0`Z 4'ld9-#`Ŗj6ƣvN͐f&B\$ (Z&278I P\rk\\2`\rdLb@E2`P( B' 0&:dB1^؉*\r\0c<K|5sZ`O35=@5C>@W* =\0N<g6s67Sm7u? {<&L.3~D\rŚ x),rin/O\0o{0k]3>m1\0I@9T34+ԙ@eGFMC\rE3Etm!#1D @H(n <g,V`R]@3Cr7s~GIi@\0v5\rV' P\r\$<b%(DdPWb fO x\0} lb&vj4LSִԶ5&dsF M4\".HM01uL\"/J`{xǐYu*\"U.I53Q3QJg5s&jьu٭ЪGQ MTmGBt l-c*\rZ7*hs/RUVBNˈԊiLk.trYi-S3\\TOM^G>ZQj\"iMsSS\$Ib fu:SB|i8 v#D4`.^HM_ռuUz`ZJ e@Cea\"mb6ԯJR T?ԣXMZІpQvjjV{C\r7 5{P]\r?QAA2񾠓V)Ji-N 99fl Jm;u@<FѠej ĦI<+CW@Zl1<2iF7`KG~L&+NYtWH飑w ls'gq+LzbizŢzW zdW(y)vE4,\0 \"d\$B{!)1U5b p#}m=@w P\0\r `O| ɍYEOu_\n`F`}M.#1f*ա zuc xf8kZRs2ʂ-Z2+ʷ(sUcDѷ X!u&-vPر\0'LX Lo >Վ\r@P\rxFEȭ % =5N֜?7NÅw`hX98 qzd%6̂t/ Ll,KaN~ ,'ǀM\rf9w!xx[ϑG8;xA-I&5\$D\$%´ ]&o-39Lzy6 ;uzZ 8_ɐx\0D?X7yOY.#38ǀeQ*Gwm Y ]YOYF)z#\$e)/z?z;^FZg`^e# ?eM3u0>\"?@חXv\"\r6v~OV~^gđٞ'f6:-Z~ O6;zx;&!+{9Mٳd \r,9W ݭ:\rٜ@睂+]-[gۇ[s[iiqyx+|7{7|w}E WWk|J؁xmq xwyj#e(ߞþ {ڏyM@ɂY(g͚-J(@ ;y#SYp@%so9;+ ;ZNٯº kVu[x|qON? `u6||X س|Ox!:ϗY]c\rh9n 8' \rS.1USȸX+z]ɵ?C\r\\ \$`)U|ˤ|Ѩx'՜<̙e|ͳ LMylкO]FD}yuĒ,XL\\x;UWtv\\OxWJ9ȒR5WiMi[Kf(\0\rM7;6KʦI\rxv\rV3ɱ.R|^2^0߾\$Q[Dܣ>1'^X ~t1\"6L+AeI~@ pM>m<SK-HT76SMfg=GPʰP\r>2Sb\$C[()%Q#G`uGwp\rkKezhjzi(rOT=7~ 4\"ef~ dVZU-b'VJZ7)T8.<RM\$'by\n5_ wU`ei޿JbguS?`+ Mg7`\0_- _?F\0X[J8&~D#{P\"\0\0F ?*^wО:u3xK^w߯y[Ԟ(#/zr_g?\0?1wMR&M?StT]ݴG:I)B v1<t6:W{x:=ޚ:!!\0xq&0}z\"]ozjw6JP۞[\\ }`S\0qHM/7BP]FT8S5 /I\r\n O0aQ\n>2j;=ڬdA=pVL)X\n¦`e\$TƦQJk7*O .ġ\r\$#pWT>!v|}נ.%,; f*?\0pD! #:MRcB/06 7@ \0VvghZ\nR\"@F EI\n8&2bXPĬͤ=h[+ʉ\r:F\0:*\r}#!\"c ;hŦ/0ޒEj]Z\0@iW_h;VRbP%! b]SBUl r\r-\0\"Q=Ih FLFxRэ@\0*j5k\00' @ElOHCx@\"G41`ϼP(G91\0\"f:Qʍ @`'>7ȎdR41>rIHGt\nRH 71fh)D8B`(V<Q8c? 2E4j\09\r͐@\0'FD,!H=*E(?Ѫ&xd_HǢE6~uG\0RXZ~P'U=@l+A\nhIiƔPGZ`\$P.;E\0} Q%jAWإ\$!3r1 {Ӊ%i=IfK!e\$80!h#\\HF|i8tl\$lli*(GL  \$x.q\"Wzs{8d`&W\0&E15jWbćVR-#{\0Xig*7VF3`p@#7 0[Ү[éh˖\\o{T]Ŧᑀ8l`f@reh\nW2*@\0`K(L̷\0vT\0c'L: 0@L1T0bhW|\\-DN\ns3\"2&\rU+^ReSni0u˚b J2sps^n<Fla\0\0mA2`|؟6 nr\0Dټ7&mߧ-)\\݌\n= ;*bT y7c|o/:tP<Y:K&C 'G/@Q*8 v/&W6p.\0u3Bq:(eOPp \r0(ac>N| t\n6v_e;y6fgQ;yβ[S gǰOuddH H=Z\r'qC*)gEO \" !k('`\nkhT*s5REa\n#!1\0;S@( lI v\rnj~63 ΈI:h\n.2pl9Bt 0\$bp+ǀ*tJsJQ8;4P(ҧѶ!.Ppk@)65 !(\n+{`=H,Ɂ\\Ѵ4\"[C1-luo4[E%\"w] ( ʏTe)KAE={ \n`;?-G5I.%q%EsgFs KGn4i/,i0ux)73SzgV[hDp'L<TM jP*o\nH\n4M-WNA/@8mHRptpV=h*0 1;\0uGT6@s\0)6ƣT\\(\"U,C:5iKlۧE*\"r.@jRJQ/L@SZP)(jjJL*\0\r-Q*g9~P@H\n-e\0Qw%^ ET< 2He\0 e#;ITl+A+C*Yh/D\\!鬚8»3EE/}0tJ|1Qmn%(p!\n±U)\rsEX5u%B- w]*E)<+qyV@mFH BN#]YQ1:V#\$<&Xxt@]GԶj)-@qL\ncIY?qC\rv(@X\0Ov<R3XQJ 99lxCuīd vTZkl\rJ\\o&?o6Eq\r '3ɪJ6'Y@6FZ50VTyC`\0VS!&66rDf`ꛨJvqzF@ݵ҅Z.\$kXkJ\\\"\"֝i:E\roX\0>PPmi]\0aV=I6jK3ZQmEb0: 32V4N6!l@hhU>: E>j0g\\|Sh7yބ\$,5aė7&:[WX4q Jׂc8!HVDĎ+D:9,DUa!X\$ЯڋG܌Bt9-+otLqKx6&%xtR\"πRIWA`c}l6~*0vkp68z+qXw*EIN*qPKFO\0,(|k *YF5;<6@QU\"\rbOAXÎvv)Ho`ST pbj1+ŋe ʀQx8@ 5\\Q,ĉNޘb#YHp1kB8NoX3,#Uک'\"eeH#zq^rG[:\rmng 5V]-(W0~kh\\ Z`lk ojW!.hF[tAweM૫3!nK_SFj-S[r̀w0^hf-?X5/IY V7ad 8bqbn\n1YRvT,+!NT2I߷K`K\"O)\nY4!}K^D@na \$@ \$Aj\\D[= bHpSOAGho!F@lU`Xn\$\\͈_˘` HB]2 \"z0i1\\w.fy޻K)  p0XS>1 *,]\r\"<cQ\$tq. <+t,]L!{gX\$6v %GH EX*0ۊ)q nC)I\" `KF@d5Ap{\\pɾNr'S(+5Њ+\"ĀU0iː! nMbrK r|a@x|ka 9WR4\"?5pۓkߒ7—Hp5YpWG#rʶAWD+`=\"}@H\\pЀߋ)C3!sO:)_F/\r4<A\nn/T3f7P16OYлϲq;؁aXtS<9nwsx@1Ξxs?3Ş@54 oȃ0pR\0 yqL&S^:Q>\\4OInZnv3 3+PL( .x\$«CCnAkc:L6rwhnrZ==jђ6}MGu~3bg4s6sQ#:3g~v3<+<a}ϧ=e8'n)ӞcCz4L=h{iJ^~wgDjL^=6ΧNӔ\\DNE?h:S*>+uhh҅WE1jxt't[wS9T[,jvtA#T9jK-ޠYiQe?_Wz @JkWYhpuj|z4 im O5\0>|9זgVyu=}gs_Vsծ{k@r^(wH'a=iN4_{6tϨϗe[h-Ul?J0O\0^Hl\0.Zxu\"< /7 i:\nǠ;!3_0`\0H`2\0H#h[P<עgm@~(\0ߵk Yv#>\nz\n@Q\n(G\n'k5n@_`Ї_l1wpPw\0coEl{ݾ7o0Ibϝnz {8w=|/y3a߼#xq@ka!\08dmR[wvNjRGp8v\$Zmt ǽuop`2m|;#xmn~;VE3O\r,~ow[N} clyO;?~^j\"Wz:'xW. u(Ýq<gvhWq\\8)M\\5vڷx=hib-|bpyDЕHh\rcey7pxG@D= 1!4Ra\r9!\0'Y@>iS>oofsO 9.\"Fl20E!QːD9 dBW4\0y `RoF>Fa00 2<IP'\\I\0\$\n R aU.\"1ІeY砢Zq1|#G!PP\0|HFnp>W:`YP%ď\na8P> `]4`<r\0Îz484`mh:ΪHDj+p>*8ՠ08A:с]wúz>9\n+:iiPoG01)ZږneR֖gMgsLCr!3R )00sIJVPpK\n|9e[ˑD0z4ϑo,N8ns#{蓷z3>BS\";e5VD0[\$7z0=8 T 3Q'RnL'\0o,\0:[}(| X>xvqW? tBE1wG;!݋5΀|0JI@#uņI\\p8!'l-lSB,ӗ]1ԕHN8%% /;FGSh\\لct2|W\$t<hO+#BaN1{yw2\\Z&)db',X xm~H@:d >=- lK܏J\0́@rϥ@\"( AZ7h>\\#>\0XrYYxŝq=:Թ\rlomgbD_TxC0.yR]_ZǻWI G Mɪ(|@\0SOs {@k}FXSb8=_ l\0=g{HyG s_J\$hkFqd4ω'>vϏ!_7Vq@1zuSejKdyuS.2\"{K?s˦hRd `:yGھ\nQ ow'hS>LX}eG@9W|Ϲ@_uZ=,!}\0I@#\"'Y`\\?p,Gל_'G T#oH\r\"o}?O鼔7|'=8MQyaH?߮ \0bUd67I O\"-2_0\r ?hO׿t\0\0002~° 4K,oh Pcz`@\"H; ,= 'S.bSCcR,~X@ '8Z0&(np<pȣ32(.@R3@^\r+@,\$ ϟEtB,⪀ʰh\r><6]#;C8P3;@L,+>p(#-f1z,8ߠƐP:9R۳)e\0ڢR!\nr{eGA@*nD6N\rR8QK0>PN IQ=r<;& fNGJ;UAAP&`);!s\0pp\rn(@%& SdY uC,8O#oRv,#|7\"CpB`j X3 ~R@v9B# @\n 0>T-5/= E\n ˆd\"!;p*nZ\08/jX\r>F Pϐe>OL O  0\0 )k㦃[ ϳ'L 1 1\0C1T `RʐzĚp< .>5\0 > Bnˊ<\"heî s! H!\r\r\"|>R1d\"U@D63>o\r vL:K2+0쾁>\0 B{!r*Hy;`8\0دd\r02A?+\0Å\0Aw Sl\r6co=0z/J +W[~C0e30HQPDPY}4# YDp) |@&-/F T aH5#H.A>0;.Yġ *D2=3 pBnuDw\n!zCQ \0HQ4D*7\0J%ıpuD(O=!>u,71TM+31:\"PRQ?P+11= M\$ZlT7,Nq%E!S2&U*>GDS&ozh8881\\:Z0hT C+#ʱA%D!\0XDA3\0!\\#h9bT!dYj2S\nA+ͽHwD`(AB*+%EX.ˠB#ȿ &XeEo\"|r8W2@8Da|NhJ8[۳Wz{Z\"L\0\0Ȇ8x۶X@ Eh;af1;nhZ3E0|AtB,~W8^Ǡ׃<2/ 8+۔O+%P#ή\n?߉?O\\]7(# (!c)NMFE#DXg)0A\0:rB``  QHc!\n59MXpQ^GNH'z5Ƞ9{M\0^ \0'!fWόs\0(3\nw@5F\"}.^ġBtjGMA9XBb`-4ch)ՀvÚ|@QqCq萴}9Lzx\"16+7qI~Ge{qE9D H\0/JJ2i*\nIȏR\n\$ z!V0`3P܃RT0\rHjM\\!W!p`N#]!H\" \"pZr\$BCq2\0 \$s\$)#0\$#ř6wH1S6FL2/Ǥ1 z@tlǂ>`)r@\0? ,\$\n7>&i <@\05 D>Iĕ2X #>UL +2 \\JB\0%\0 #%, \"Zd2b?0I#\$\n` zs@+I\n&\n>#酽&*%\0(ch \$ɖ> &8jv(0\0p )\nd'I](*NX`&\$ (\$̓x 2Io%u+(@3J4%L>(\\nKTCJ)'l\0JU(ܖ#K)@ɀ(4rq\$x \"\0 #I#*2<?r#bz5v\$&\\!ʱ*hx\\\0&I8 ɾtc뀞!?\n/ɻ+L`\"BI, Mҕɺ?C\$>\nK\$0+, \"ʞ\0,de\$R&\n\0)#IܬN&#Hrʼp \0@2`\0; #:-n, 2ɑ%tdI.0\\tKlH&' R:X1*IDԽ@'#/\n\$ʫ0`'˝002:L .,rb1-CJ`\rK-K0?;IJ##M&I?< \"=+̀(̣ҟJ2:(\\*R'4ŀ-Z* <L\"H:\rPAݷ.s.\r E` 82cX ?2p31X\$_\0/LXb 3*J@E Dr[ӽ^ [3O2ГjG 1; 5 ^l&B\0`P<`K3ʡ':xFHNkH\$hrGʠP l\0Q4k[2`섮VQ+ Z;B6)x,O \"v,%\"U8\"\0SnQN @_ʹۅ4 O N4\rӇ샑mL\0pk\"M98nMeE@1؂+2!p,r գY?1fAY@b? Q8e> ?7;NiVL\nX`\"`\0I7py`;E!4DL <6#D\"J <Nh@p 627[+N2 cx\"Ҁ=<g8JO!z~");}else{header("Content-Type: image/gif");switch($_GET["file"]){case"plus.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0!M*)o) qe#L\0;";break;case"cross.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0##\naFo~y._wa1J GL6]\0\0;";break;case"up.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0 MQN\n}a8y\0\0;";break;case"down.gif":echo"GIF89a\0\0\0001\0\0\0\0\0!\0\0\0,\0\0\0\0\0\0 M*)[W\\L&ٜƶ\0\0;";break;case"arrow.gif":echo"GIF89a\0\n\0\0\0!\0\0\0,\0\0\0\0\0\n\0\0iӲ޻\0\0;";break;}}exit;}if($_GET["script"]=="version"){$r=file_open_lock(get_temp_dir()."/adminer.version");if($r)file_write_unlock($r,serialize(array("signature"=>$_POST["signature"],"version"=>$_POST["version"])));exit;}global$b,$f,$k,$zb,$Gb,$Qb,$l,$uc,$yc,$aa,$Qc,$y,$ba,$gd,$Wd,$De,$Of,$Cc,$U,$xg,$Cg,$Jg,$da;if(!$_SERVER["REQUEST_URI"])$_SERVER["REQUEST_URI"]=$_SERVER["ORIG_PATH_INFO"];if(!strpos($_SERVER["REQUEST_URI"],'?')&&$_SERVER["QUERY_STRING"]!="")$_SERVER["REQUEST_URI"].="?$_SERVER[QUERY_STRING]";if($_SERVER["HTTP_X_FORWARDED_PREFIX"])$_SERVER["REQUEST_URI"]=$_SERVER["HTTP_X_FORWARDED_PREFIX"].$_SERVER["REQUEST_URI"];$aa=($_SERVER["HTTPS"]&&strcasecmp($_SERVER["HTTPS"],"off"))||ini_bool("session.cookie_secure");@ini_set("session.use_trans_sid",false);if(!defined("SID")){session_cache_limiter("");session_name("adminer_sid");$ue=array(0,preg_replace('~\?.*~','',$_SERVER["REQUEST_URI"]),"",$aa);if(version_compare(PHP_VERSION,'5.2.0')>=0)$ue[]=true;call_user_func_array('session_set_cookie_params',$ue);session_start();}remove_slashes(array(&$_GET,&$_POST,&$_COOKIE),$kc);if(function_exists("get_magic_quotes_runtime")&&get_magic_quotes_runtime())set_magic_quotes_runtime(false);@set_time_limit(0);@ini_set("zend.ze1_compatibility_mode",false);@ini_set("precision",15);function
get_lang(){return'fr';}function
lang($wg,$Qd=null){if(is_array($wg)){$Ie=($Qd==1?0:(!$Qd?0:1));$wg=$wg[$Ie];}$wg=str_replace("%d","%s",$wg);$Qd=format_number($Qd);return
sprintf($wg,$Qd);}if(extension_loaded('pdo')){class
Min_PDO{var$_result,$server_info,$affected_rows,$errno,$error,$pdo;function
__construct(){global$b;$Ie=array_search("SQL",$b->operators);if($Ie!==false)unset($b->operators[$Ie]);}function
dsn($Db,$Rg,$_e,$de=array()){$de[PDO::ATTR_ERRMODE]=PDO::ERRMODE_SILENT;$de[PDO::ATTR_STATEMENT_CLASS]=array('Min_PDOStatement');try{$this->pdo=new
PDO($Db,$Rg,$_e,$de);}catch(Exception$Vb){auth_error(h($Vb->getMessage()));}$this->server_info=@$this->pdo->getAttribute(PDO::ATTR_SERVER_VERSION);}function
quote($Q){return$this->pdo->quote($Q);}function
query($I,$Dg=false){$J=$this->pdo->query($I);$this->error="";if(!$J){list(,$this->errno,$this->error)=$this->pdo->errorInfo();if(!$this->error)$this->error='Unknown error.';return
false;}$this->store_result($J);return$J;}function
multi_query($I){return$this->_result=$this->query($I);}function
store_result($J=null){if(!$J){$J=$this->_result;if(!$J)return
false;}if($J->columnCount()){$J->num_rows=$J->rowCount();return$J;}$this->affected_rows=$J->rowCount();return
true;}function
next_result(){if(!$this->_result)return
false;$this->_result->_offset=0;return@$this->_result->nextRowset();}function
result($I,$m=0){$J=$this->query($I);if(!$J)return
false;$L=$J->fetch();return$L[$m];}}class
Min_PDOStatement
extends
PDOStatement{var$_offset=0,$num_rows;function
fetch_assoc(){return$this->fetch(PDO::FETCH_ASSOC);}function
fetch_row(){return$this->fetch(PDO::FETCH_NUM);}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;}}}$zb=array();function
add_driver($v,$F){global$zb;$zb[$v]=$F;}class
Min_SQL{var$_conn;function
__construct($f){$this->_conn=$f;}function
select($R,$N,$Z,$t,$fe=array(),$_=1,$G=0,$Qe=false){global$b,$y;$Wc=(count($t)<count($N));$I=$b->selectQueryBuild($N,$Z,$t,$fe,$_,$G);if(!$I)$I="SELECT".limit(($_GET["page"]!="last"&&$_!=""&&$t&&$Wc&&$y=="sql"?"SQL_CALC_FOUND_ROWS ":"").implode(", ",$N)."\nFROM ".table($R),($Z?"\nWHERE ".implode(" AND ",$Z):"").($t&&$Wc?"\nGROUP BY ".implode(", ",$t):"").($fe?"\nORDER BY ".implode(", ",$fe):""),($_!=""?+$_:null),($G?$_*$G:0),"\n");$Lf=microtime(true);$K=$this->_conn->query($I);if($Qe)echo$b->selectQuery($I,$Lf,!$K);return$K;}function
delete($R,$Xe,$_=0){$I="FROM ".table($R);return
queries("DELETE".($_?limit1($R,$I,$Xe):" $I$Xe"));}function
update($R,$P,$Xe,$_=0,$xf="\n"){$Ug=array();foreach($P
as$z=>$X)$Ug[]="$z = $X";$I=table($R)." SET$xf".implode(",$xf",$Ug);return
queries("UPDATE".($_?limit1($R,$I,$Xe,$xf):" $I$Xe"));}function
insert($R,$P){return
queries("INSERT INTO ".table($R).($P?" (".implode(", ",array_keys($P)).")\nVALUES (".implode(", ",$P).")":" DEFAULT VALUES"));}function
insertUpdate($R,$M,$Oe){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}function
slowQuery($I,$kg){}function
convertSearch($Kc,$X,$m){return$Kc;}function
value($X,$m){return(method_exists($this->_conn,'value')?$this->_conn->value($X,$m):(is_resource($X)?stream_get_contents($X):$X));}function
quoteBinary($pf){return
q($pf);}function
warnings(){return'';}function
tableHelp($F){}}$zb["sqlite"]="SQLite 3";$zb["sqlite2"]="SQLite 2";if(isset($_GET["sqlite"])||isset($_GET["sqlite2"])){define("DRIVER",(isset($_GET["sqlite"])?"sqlite":"sqlite2"));if(class_exists(isset($_GET["sqlite"])?"SQLite3":"SQLiteDatabase")){if(isset($_GET["sqlite"])){class
Min_SQLite{var$extension="SQLite3",$server_info,$affected_rows,$errno,$error,$_link;function
__construct($o){$this->_link=new
SQLite3($o);$Xg=$this->_link->version();$this->server_info=$Xg["versionString"];}function
query($I){$J=@$this->_link->query($I);$this->error="";if(!$J){$this->errno=$this->_link->lastErrorCode();$this->error=$this->_link->lastErrorMsg();return
false;}elseif($J->numColumns())return
new
Min_Result($J);$this->affected_rows=$this->_link->changes();return
true;}function
quote($Q){return(is_utf8($Q)?"'".$this->_link->escapeString($Q)."'":"x'".reset(unpack('H*',$Q))."'");}function
store_result(){return$this->_result;}function
result($I,$m=0){$J=$this->query($I);if(!is_object($J))return
false;$L=$J->_result->fetchArray();return$L[$m];}}class
Min_Result{var$_result,$_offset=0,$num_rows;function
__construct($J){$this->_result=$J;}function
fetch_assoc(){return$this->_result->fetchArray(SQLITE3_ASSOC);}function
fetch_row(){return$this->_result->fetchArray(SQLITE3_NUM);}function
fetch_field(){$d=$this->_offset++;$V=$this->_result->columnType($d);return(object)array("name"=>$this->_result->columnName($d),"type"=>$V,"charsetnr"=>($V==SQLITE3_BLOB?63:0),);}function
__desctruct(){return$this->_result->finalize();}}}else{class
Min_SQLite{var$extension="SQLite",$server_info,$affected_rows,$error,$_link;function
__construct($o){$this->server_info=sqlite_libversion();$this->_link=new
SQLiteDatabase($o);}function
query($I,$Dg=false){$Fd=($Dg?"unbufferedQuery":"query");$J=@$this->_link->$Fd($I,SQLITE_BOTH,$l);$this->error="";if(!$J){$this->error=$l;return
false;}elseif($J===true){$this->affected_rows=$this->changes();return
true;}return
new
Min_Result($J);}function
quote($Q){return"'".sqlite_escape_string($Q)."'";}function
store_result(){return$this->_result;}function
result($I,$m=0){$J=$this->query($I);if(!is_object($J))return
false;$L=$J->_result->fetch();return$L[$m];}}class
Min_Result{var$_result,$_offset=0,$num_rows;function
__construct($J){$this->_result=$J;if(method_exists($J,'numRows'))$this->num_rows=$J->numRows();}function
fetch_assoc(){$L=$this->_result->fetch(SQLITE_ASSOC);if(!$L)return
false;$K=array();foreach($L
as$z=>$X)$K[idf_unescape($z)]=$X;return$K;}function
fetch_row(){return$this->_result->fetch(SQLITE_NUM);}function
fetch_field(){$F=$this->_result->fieldName($this->_offset++);$Be='(\[.*]|"(?:[^"]|"")*"|(.+))';if(preg_match("~^($Be\\.)?$Be\$~",$F,$C)){$R=($C[3]!=""?$C[3]:idf_unescape($C[2]));$F=($C[5]!=""?$C[5]:idf_unescape($C[4]));}return(object)array("name"=>$F,"orgname"=>$F,"orgtable"=>$R,);}}}}elseif(extension_loaded("pdo_sqlite")){class
Min_SQLite
extends
Min_PDO{var$extension="PDO_SQLite";function
__construct($o){$this->dsn(DRIVER.":$o","","");}}}if(class_exists("Min_SQLite")){class
Min_DB
extends
Min_SQLite{function
__construct(){parent::__construct(":memory:");$this->query("PRAGMA foreign_keys = 1");}function
select_db($o){if(is_readable($o)&&$this->query("ATTACH ".$this->quote(preg_match("~(^[/\\\\]|:)~",$o)?$o:dirname($_SERVER["SCRIPT_FILENAME"])."/$o")." AS a")){parent::__construct($o);$this->query("PRAGMA foreign_keys = 1");$this->query("PRAGMA busy_timeout = 500");return
true;}return
false;}function
multi_query($I){return$this->_result=$this->query($I);}function
next_result(){return
false;}}}class
Min_Driver
extends
Min_SQL{function
insertUpdate($R,$M,$Oe){$Ug=array();foreach($M
as$P)$Ug[]="(".implode(", ",$P).")";return
queries("REPLACE INTO ".table($R)." (".implode(", ",array_keys(reset($M))).") VALUES\n".implode(",\n",$Ug));}function
tableHelp($F){if($F=="sqlite_sequence")return"fileformat2.html#seqtab";if($F=="sqlite_master")return"fileformat2.html#$F";}}function
idf_escape($Kc){return'"'.str_replace('"','""',$Kc).'"';}function
table($Kc){return
idf_escape($Kc);}function
connect(){global$b;list(,,$_e)=$b->credentials();if($_e!="")return'Database does not support password.';return
new
Min_DB;}function
get_databases(){return
array();}function
limit($I,$Z,$_,$Sd=0,$xf=" "){return" $I$Z".($_!==null?$xf."LIMIT $_".($Sd?" OFFSET $Sd":""):"");}function
limit1($R,$I,$Z,$xf="\n"){global$f;return(preg_match('~^INTO~',$I)||$f->result("SELECT sqlite_compileoption_used('ENABLE_UPDATE_DELETE_LIMIT')")?limit($I,$Z,1,0,$xf):" $I WHERE rowid = (SELECT rowid FROM ".table($R).$Z.$xf."LIMIT 1)");}function
db_collation($j,$Pa){global$f;return$f->result("PRAGMA encoding");}function
engines(){return
array();}function
logged_user(){return
get_current_user();}function
tables_list(){return
get_key_vals("SELECT name, type FROM sqlite_master WHERE type IN ('table', 'view') ORDER BY (name = 'sqlite_sequence'), name");}function
count_tables($i){return
array();}function
table_status($F=""){global$f;$K=array();foreach(get_rows("SELECT name AS Name, type AS Engine, 'rowid' AS Oid, '' AS Auto_increment FROM sqlite_master WHERE type IN ('table', 'view') ".($F!=""?"AND name = ".q($F):"ORDER BY name"))as$L){$L["Rows"]=$f->result("SELECT COUNT(*) FROM ".idf_escape($L["Name"]));$K[$L["Name"]]=$L;}foreach(get_rows("SELECT * FROM sqlite_sequence",null,"")as$L)$K[$L["name"]]["Auto_increment"]=$L["seq"];return($F!=""?$K[$F]:$K);}function
is_view($S){return$S["Engine"]=="view";}function
fk_support($S){global$f;return!$f->result("SELECT sqlite_compileoption_used('OMIT_FOREIGN_KEY')");}function
fields($R){global$f;$K=array();$Oe="";foreach(get_rows("PRAGMA table_info(".table($R).")")as$L){$F=$L["name"];$V=strtolower($L["type"]);$ob=$L["dflt_value"];$K[$F]=array("field"=>$F,"type"=>(preg_match('~int~i',$V)?"integer":(preg_match('~char|clob|text~i',$V)?"text":(preg_match('~blob~i',$V)?"blob":(preg_match('~real|floa|doub~i',$V)?"real":"numeric")))),"full_type"=>$V,"default"=>(preg_match("~'(.*)'~",$ob,$C)?str_replace("''","'",$C[1]):($ob=="NULL"?null:$ob)),"null"=>!$L["notnull"],"privileges"=>array("select"=>1,"insert"=>1,"update"=>1),"primary"=>$L["pk"],);if($L["pk"]){if($Oe!="")$K[$Oe]["auto_increment"]=false;elseif(preg_match('~^integer$~i',$V))$K[$F]["auto_increment"]=true;$Oe=$F;}}$Hf=$f->result("SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ".q($R));preg_match_all('~(("[^"]*+")+|[a-z0-9_]+)\s+text\s+COLLATE\s+(\'[^\']+\'|\S+)~i',$Hf,$ud,PREG_SET_ORDER);foreach($ud
as$C){$F=str_replace('""','"',preg_replace('~^"|"$~','',$C[1]));if($K[$F])$K[$F]["collation"]=trim($C[3],"'");}return$K;}function
indexes($R,$g=null){global$f;if(!is_object($g))$g=$f;$K=array();$Hf=$g->result("SELECT sql FROM sqlite_master WHERE type = 'table' AND name = ".q($R));if(preg_match('~\bPRIMARY\s+KEY\s*\((([^)"]+|"[^"]*"|`[^`]*`)++)~i',$Hf,$C)){$K[""]=array("type"=>"PRIMARY","columns"=>array(),"lengths"=>array(),"descs"=>array());preg_match_all('~((("[^"]*+")+|(?:`[^`]*+`)+)|(\S+))(\s+(ASC|DESC))?(,\s*|$)~i',$C[1],$ud,PREG_SET_ORDER);foreach($ud
as$C){$K[""]["columns"][]=idf_unescape($C[2]).$C[4];$K[""]["descs"][]=(preg_match('~DESC~i',$C[5])?'1':null);}}if(!$K){foreach(fields($R)as$F=>$m){if($m["primary"])$K[""]=array("type"=>"PRIMARY","columns"=>array($F),"lengths"=>array(),"descs"=>array(null));}}$Kf=get_key_vals("SELECT name, sql FROM sqlite_master WHERE type = 'index' AND tbl_name = ".q($R),$g);foreach(get_rows("PRAGMA index_list(".table($R).")",$g)as$L){$F=$L["name"];$w=array("type"=>($L["unique"]?"UNIQUE":"INDEX"));$w["lengths"]=array();$w["descs"]=array();foreach(get_rows("PRAGMA index_info(".idf_escape($F).")",$g)as$of){$w["columns"][]=$of["name"];$w["descs"][]=null;}if(preg_match('~^CREATE( UNIQUE)? INDEX '.preg_quote(idf_escape($F).' ON '.idf_escape($R),'~').' \((.*)\)$~i',$Kf[$F],$hf)){preg_match_all('/("[^"]*+")+( DESC)?/',$hf[2],$ud);foreach($ud[2]as$z=>$X){if($X)$w["descs"][$z]='1';}}if(!$K[""]||$w["type"]!="UNIQUE"||$w["columns"]!=$K[""]["columns"]||$w["descs"]!=$K[""]["descs"]||!preg_match("~^sqlite_~",$F))$K[$F]=$w;}return$K;}function
foreign_keys($R){$K=array();foreach(get_rows("PRAGMA foreign_key_list(".table($R).")")as$L){$p=&$K[$L["id"]];if(!$p)$p=$L;$p["source"][]=$L["from"];$p["target"][]=$L["to"];}return$K;}function
view($F){global$f;return
array("select"=>preg_replace('~^(?:[^`"[]+|`[^`]*`|"[^"]*")* AS\s+~iU','',$f->result("SELECT sql FROM sqlite_master WHERE name = ".q($F))));}function
collations(){return(isset($_GET["create"])?get_vals("PRAGMA collation_list",1):array());}function
information_schema($j){return
false;}function
error(){global$f;return
h($f->error);}function
check_sqlite_name($F){global$f;$dc="db|sdb|sqlite";if(!preg_match("~^[^\\0]*\\.($dc)\$~",$F)){$f->error=sprintf('Veuillez utiliser l\'une des extensions %s.',str_replace("|",", ",$dc));return
false;}return
true;}function
create_database($j,$Oa){global$f;if(file_exists($j)){$f->error='Le fichier existe.';return
false;}if(!check_sqlite_name($j))return
false;try{$A=new
Min_SQLite($j);}catch(Exception$Vb){$f->error=$Vb->getMessage();return
false;}$A->query('PRAGMA encoding = "UTF-8"');$A->query('CREATE TABLE adminer (i)');$A->query('DROP TABLE adminer');return
true;}function
drop_databases($i){global$f;$f->__construct(":memory:");foreach($i
as$j){if(!@unlink($j)){$f->error='Le fichier existe.';return
false;}}return
true;}function
rename_database($F,$Oa){global$f;if(!check_sqlite_name($F))return
false;$f->__construct(":memory:");$f->error='Le fichier existe.';return@rename(DB,$F);}function
auto_increment(){return" PRIMARY KEY".(DRIVER=="sqlite"?" AUTOINCREMENT":"");}function
alter_table($R,$F,$n,$oc,$Ta,$Ob,$Oa,$ta,$ye){global$f;$Og=($R==""||$oc);foreach($n
as$m){if($m[0]!=""||!$m[1]||$m[2]){$Og=true;break;}}$oa=array();$oe=array();foreach($n
as$m){if($m[1]){$oa[]=($Og?$m[1]:"ADD ".implode($m[1]));if($m[0]!="")$oe[$m[0]]=$m[1][0];}}if(!$Og){foreach($oa
as$X){if(!queries("ALTER TABLE ".table($R)." $X"))return
false;}if($R!=$F&&!queries("ALTER TABLE ".table($R)." RENAME TO ".table($F)))return
false;}elseif(!recreate_table($R,$F,$oa,$oe,$oc,$ta))return
false;if($ta){queries("BEGIN");queries("UPDATE sqlite_sequence SET seq = $ta WHERE name = ".q($F));if(!$f->affected_rows)queries("INSERT INTO sqlite_sequence (name, seq) VALUES (".q($F).", $ta)");queries("COMMIT");}return
true;}function
recreate_table($R,$F,$n,$oe,$oc,$ta,$x=array()){global$f;if($R!=""){if(!$n){foreach(fields($R)as$z=>$m){if($x)$m["auto_increment"]=0;$n[]=process_field($m,$m);$oe[$z]=idf_escape($z);}}$Pe=false;foreach($n
as$m){if($m[6])$Pe=true;}$Bb=array();foreach($x
as$z=>$X){if($X[2]=="DROP"){$Bb[$X[1]]=true;unset($x[$z]);}}foreach(indexes($R)as$bd=>$w){$e=array();foreach($w["columns"]as$z=>$d){if(!$oe[$d])continue
2;$e[]=$oe[$d].($w["descs"][$z]?" DESC":"");}if(!$Bb[$bd]){if($w["type"]!="PRIMARY"||!$Pe)$x[]=array($w["type"],$bd,$e);}}foreach($x
as$z=>$X){if($X[0]=="PRIMARY"){unset($x[$z]);$oc[]=" PRIMARY KEY (".implode(", ",$X[2]).")";}}foreach(foreign_keys($R)as$bd=>$p){foreach($p["source"]as$z=>$d){if(!$oe[$d])continue
2;$p["source"][$z]=idf_unescape($oe[$d]);}if(!isset($oc[" $bd"]))$oc[]=" ".format_foreign_key($p);}queries("BEGIN");}foreach($n
as$z=>$m)$n[$z]=" ".implode($m);$n=array_merge($n,array_filter($oc));$fg=($R==$F?"adminer_$F":$F);if(!queries("CREATE TABLE ".table($fg)." (\n".implode(",\n",$n)."\n)"))return
false;if($R!=""){if($oe&&!queries("INSERT INTO ".table($fg)." (".implode(", ",$oe).") SELECT ".implode(", ",array_map('idf_escape',array_keys($oe)))." FROM ".table($R)))return
false;$Ag=array();foreach(triggers($R)as$zg=>$lg){$yg=trigger($zg);$Ag[]="CREATE TRIGGER ".idf_escape($zg)." ".implode(" ",$lg)." ON ".table($F)."\n$yg[Statement]";}$ta=$ta?0:$f->result("SELECT seq FROM sqlite_sequence WHERE name = ".q($R));if(!queries("DROP TABLE ".table($R))||($R==$F&&!queries("ALTER TABLE ".table($fg)." RENAME TO ".table($F)))||!alter_indexes($F,$x))return
false;if($ta)queries("UPDATE sqlite_sequence SET seq = $ta WHERE name = ".q($F));foreach($Ag
as$yg){if(!queries($yg))return
false;}queries("COMMIT");}return
true;}function
index_sql($R,$V,$F,$e){return"CREATE $V ".($V!="INDEX"?"INDEX ":"").idf_escape($F!=""?$F:uniqid($R."_"))." ON ".table($R)." $e";}function
alter_indexes($R,$oa){foreach($oa
as$Oe){if($Oe[0]=="PRIMARY")return
recreate_table($R,$R,array(),array(),array(),0,$oa);}foreach(array_reverse($oa)as$X){if(!queries($X[2]=="DROP"?"DROP INDEX ".idf_escape($X[1]):index_sql($R,$X[0],$X[1],"(".implode(", ",$X[2]).")")))return
false;}return
true;}function
truncate_tables($T){return
apply_queries("DELETE FROM",$T);}function
drop_views($Zg){return
apply_queries("DROP VIEW",$Zg);}function
drop_tables($T){return
apply_queries("DROP TABLE",$T);}function
move_tables($T,$Zg,$dg){return
false;}function
trigger($F){global$f;if($F=="")return
array("Statement"=>"BEGIN\n\t;\nEND");$Kc='(?:[^`"\s]+|`[^`]*`|"[^"]*")+';$_g=trigger_options();preg_match("~^CREATE\\s+TRIGGER\\s*$Kc\\s*(".implode("|",$_g["Timing"]).")\\s+([a-z]+)(?:\\s+OF\\s+($Kc))?\\s+ON\\s*$Kc\\s*(?:FOR\\s+EACH\\s+ROW\\s)?(.*)~is",$f->result("SELECT sql FROM sqlite_master WHERE type = 'trigger' AND name = ".q($F)),$C);$Rd=$C[3];return
array("Timing"=>strtoupper($C[1]),"Event"=>strtoupper($C[2]).($Rd?" OF":""),"Of"=>idf_unescape($Rd),"Trigger"=>$F,"Statement"=>$C[4],);}function
triggers($R){$K=array();$_g=trigger_options();foreach(get_rows("SELECT * FROM sqlite_master WHERE type = 'trigger' AND tbl_name = ".q($R))as$L){preg_match('~^CREATE\s+TRIGGER\s*(?:[^`"\s]+|`[^`]*`|"[^"]*")+\s*('.implode("|",$_g["Timing"]).')\s*(.*?)\s+ON\b~i',$L["sql"],$C);$K[$L["name"]]=array($C[1],$C[2]);}return$K;}function
trigger_options(){return
array("Timing"=>array("BEFORE","AFTER","INSTEAD OF"),"Event"=>array("INSERT","UPDATE","UPDATE OF","DELETE"),"Type"=>array("FOR EACH ROW"),);}function
begin(){return
queries("BEGIN");}function
last_id(){global$f;return$f->result("SELECT LAST_INSERT_ROWID()");}function
explain($f,$I){return$f->query("EXPLAIN QUERY PLAN $I");}function
found_rows($S,$Z){}function
types(){return
array();}function
schemas(){return
array();}function
get_schema(){return"";}function
set_schema($rf){return
true;}function
create_sql($R,$ta,$Pf){global$f;$K=$f->result("SELECT sql FROM sqlite_master WHERE type IN ('table', 'view') AND name = ".q($R));foreach(indexes($R)as$F=>$w){if($F=='')continue;$K.=";\n\n".index_sql($R,$w['type'],$F,"(".implode(", ",array_map('idf_escape',$w['columns'])).")");}return$K;}function
truncate_sql($R){return"DELETE FROM ".table($R);}function
use_sql($jb){}function
trigger_sql($R){return
implode(get_vals("SELECT sql || ';;\n' FROM sqlite_master WHERE type = 'trigger' AND tbl_name = ".q($R)));}function
show_variables(){global$f;$K=array();foreach(array("auto_vacuum","cache_size","count_changes","default_cache_size","empty_result_callbacks","encoding","foreign_keys","full_column_names","fullfsync","journal_mode","journal_size_limit","legacy_file_format","locking_mode","page_size","max_page_count","read_uncommitted","recursive_triggers","reverse_unordered_selects","secure_delete","short_column_names","synchronous","temp_store","temp_store_directory","schema_version","integrity_check","quick_check")as$z)$K[$z]=$f->result("PRAGMA $z");return$K;}function
show_status(){$K=array();foreach(get_vals("PRAGMA compile_options")as$ce){list($z,$X)=explode("=",$ce,2);$K[$z]=$X;}return$K;}function
convert_field($m){}function
unconvert_field($m,$K){return$K;}function
support($hc){return
preg_match('~^(columns|database|drop_col|dump|indexes|descidx|move_col|sql|status|table|trigger|variables|view|view_trigger)$~',$hc);}function
driver_config(){$Cg=array("integer"=>0,"real"=>0,"numeric"=>0,"text"=>0,"blob"=>0);return
array('possible_drivers'=>array((isset($_GET["sqlite"])?"SQLite3":"SQLite"),"PDO_SQLite"),'jush'=>"sqlite",'types'=>$Cg,'structured_types'=>array_keys($Cg),'unsigned'=>array(),'operators'=>array("=","<",">","<=",">=","!=","LIKE","LIKE %%","IN","IS NULL","NOT LIKE","NOT IN","IS NOT NULL","SQL"),'functions'=>array("hex","length","lower","round","unixepoch","upper"),'grouping'=>array("avg","count","count distinct","group_concat","max","min","sum"),'edit_functions'=>array(array(),array("integer|real|numeric"=>"+/-","text"=>"||",)),);}}class
Adminer{var$operators;function
name(){return"<a href='https://www.adminer.org/'".target_blank()." id='h1'>Adminer</a>";}function
credentials(){return
array(SERVER,$_GET["username"],get_password());}function
connectSsl(){}function
permanentLogin($h=false){return
password_file($h);}function
bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function
serverName($O){return
h($O);}function
database(){return
DB;}function
databases($mc=true){return
get_databases($mc);}function
schemas(){return
schemas();}function
queryTimeout(){return
2;}function
headers(){}function
csp(){return
csp();}function
head(){return
true;}function
css(){$K=array();$o="adminer.css";if(file_exists($o))$K[]="$o?v=".crc32(file_get_contents($o));return$K;}function
loginForm(){global$zb;echo"<table cellspacing='0' class='layout'>\n",$this->loginFormField('driver','<tr><th>'.'Système'.'<td>',html_select("auth[driver]",$zb,DRIVER,"loginDriver(this);")."\n"),$this->loginFormField('server','<tr><th>'.'Serveur'.'<td>','<input name="auth[server]" value="'.h(SERVER).'" title="hostname[:port]" placeholder="localhost" autocapitalize="off">'."\n"),$this->loginFormField('username','<tr><th>'.'Utilisateur'.'<td>','<input name="auth[username]" id="username" value="'.h($_GET["username"]).'" autocomplete="username" autocapitalize="off">'.script("focus(qs('#username')); qs('#username').form['auth[driver]'].onchange();")),$this->loginFormField('password','<tr><th>'.'Mot de passe'.'<td>','<input type="password" name="auth[password]" autocomplete="current-password">'."\n"),$this->loginFormField('db','<tr><th>'.'Base de données'.'<td>','<input name="auth[db]" value="'.h($_GET["db"]).'" autocapitalize="off">'."\n"),"</table>\n","<p><input type='submit' value='".'Authentification'."'>\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],'Authentification permanente')."\n";}function
loginFormField($F,$Ec,$Y){return$Ec.$Y;}function
login($rd,$_e){if($_e=="")return
sprintf('Adminer does not support accessing a database without a password, <a href="https://www.adminer.org/en/password/"%s>more information</a>.',target_blank());return
true;}function
tableName($Vf){return
h($Vf["Name"]);}function
fieldName($m,$fe=0){return'<span title="'.h($m["full_type"]).'">'.h($m["field"]).'</span>';}function
selectLinks($Vf,$P=""){global$y,$k;echo'<p class="links">';$qd=array("select"=>'Afficher les données');if(support("table")||support("indexes"))$qd["table"]='Afficher la structure';if(support("table")){if(is_view($Vf))$qd["view"]='Modifier une vue';else$qd["create"]='Modifier la table';}if($P!==null)$qd["edit"]='Nouvel élément';$F=$Vf["Name"];foreach($qd
as$z=>$X)echo" <a href='".h(ME)."$z=".urlencode($F).($z=="edit"?$P:"")."'".bold(isset($_GET[$z])).">$X</a>";echo
doc_link(array($y=>$k->tableHelp($F)),"?"),"\n";}function
foreignKeys($R){return
foreign_keys($R);}function
backwardKeys($R,$Uf){return
array();}function
backwardKeysPrint($va,$L){}function
selectQuery($I,$Lf,$fc=false){global$y,$k;$K="</p>\n";if(!$fc&&($ch=$k->warnings())){$v="warnings";$K=", <a href='#$v'>".'Warnings'."</a>".script("qsl('a').onclick = partial(toggle, '$v');","")."$K<div id='$v' class='hidden'>\n$ch</div>\n";}return"<p><code class='jush-$y'>".h(str_replace("\n"," ",$I))."</code> <span class='time'>(".format_time($Lf).")</span>".(support("sql")?" <a href='".h(ME)."sql=".urlencode($I)."'>".'Modifier'."</a>":"").$K;}function
sqlCommandQuery($I){return
shorten_utf8(trim($I),1000);}function
rowDescription($R){return"";}function
rowDescriptions($M,$pc){return$M;}function
selectLink($X,$m){}function
selectVal($X,$A,$m,$ne){$K=($X===null?"<i>NULL</i>":(preg_match("~char|binary|boolean~",$m["type"])&&!preg_match("~var~",$m["type"])?"<code>$X</code>":$X));if(preg_match('~blob|bytea|raw|file~',$m["type"])&&!is_utf8($X))$K="<i>".lang(array('%d octet','%d octets'),strlen($ne))."</i>";if(preg_match('~json~',$m["type"]))$K="<code class='jush-js'>$K</code>";return($A?"<a href='".h($A)."'".(is_url($A)?target_blank():"").">$K</a>":$K);}function
editVal($X,$m){return$X;}function
tableStructurePrint($n){echo"<div class='scrollable'>\n","<table cellspacing='0' class='nowrap'>\n","<thead><tr><th>".'Colonne'."<td>".'Type'.(support("comment")?"<td>".'Commentaire':"")."</thead>\n";foreach($n
as$m){echo"<tr".odd()."><th>".h($m["field"]),"<td><span title='".h($m["collation"])."'>".h($m["full_type"])."</span>",($m["null"]?" <i>NULL</i>":""),($m["auto_increment"]?" <i>".'Incrément automatique'."</i>":""),(isset($m["default"])?" <span title='".'Valeur par défaut'."'>[<b>".h($m["default"])."</b>]</span>":""),(support("comment")?"<td>".h($m["comment"]):""),"\n";}echo"</table>\n","</div>\n";}function
tableIndexesPrint($x){echo"<table cellspacing='0'>\n";foreach($x
as$F=>$w){ksort($w["columns"]);$Qe=array();foreach($w["columns"]as$z=>$X)$Qe[]="<i>".h($X)."</i>".($w["lengths"][$z]?"(".$w["lengths"][$z].")":"").($w["descs"][$z]?" DESC":"");echo"<tr title='".h($F)."'><th>$w[type]<td>".implode(", ",$Qe)."\n";}echo"</table>\n";}function
selectColumnsPrint($N,$e){global$uc,$yc;print_fieldset("select",'Sélectionner',$N);$u=0;$N[""]=array();foreach($N
as$z=>$X){$X=$_GET["columns"][$z];$d=select_input(" name='columns[$u][col]'",$e,$X["col"],($z!==""?"selectFieldChange":"selectAddRow"));echo"<div>".($uc||$yc?"<select name='columns[$u][fun]'>".optionlist(array(-1=>"")+array_filter(array('Fonctions'=>$uc,'Agrégation'=>$yc)),$X["fun"])."</select>".on_help("getTarget(event).value && getTarget(event).value.replace(/ |\$/, '(') + ')'",1).script("qsl('select').onchange = function () { helpClose();".($z!==""?"":" qsl('select, input', this.parentNode).onchange();")." };","")."($d)":$d)."</div>\n";$u++;}echo"</div></fieldset>\n";}function
selectSearchPrint($Z,$e,$x){print_fieldset("search",'Rechercher',$Z);foreach($x
as$u=>$w){if($w["type"]=="FULLTEXT"){echo"<div>(<i>".implode("</i>, <i>",array_map('h',$w["columns"]))."</i>) AGAINST"," <input type='search' name='fulltext[$u]' value='".h($_GET["fulltext"][$u])."'>",script("qsl('input').oninput = selectFieldChange;",""),checkbox("boolean[$u]",1,isset($_GET["boolean"][$u]),"BOOL"),"</div>\n";}}$Da="this.parentNode.firstChild.onchange();";foreach(array_merge((array)$_GET["where"],array(array()))as$u=>$X){if(!$X||("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators))){echo"<div>".select_input(" name='where[$u][col]'",$e,$X["col"],($X?"selectFieldChange":"selectAddRow"),"(".'n\'importe où'.")"),html_select("where[$u][op]",$this->operators,$X["op"],$Da),"<input type='search' name='where[$u][val]' value='".h($X["val"])."'>",script("mixin(qsl('input'), {oninput: function () { $Da }, onkeydown: selectSearchKeydown, onsearch: selectSearchSearch});",""),"</div>\n";}}echo"</div></fieldset>\n";}function
selectOrderPrint($fe,$e,$x){print_fieldset("sort",'Trier',$fe);$u=0;foreach((array)$_GET["order"]as$z=>$X){if($X!=""){echo"<div>".select_input(" name='order[$u]'",$e,$X,"selectFieldChange"),checkbox("desc[$u]",1,isset($_GET["desc"][$z]),'décroissant')."</div>\n";$u++;}}echo"<div>".select_input(" name='order[$u]'",$e,"","selectAddRow"),checkbox("desc[$u]",1,false,'décroissant')."</div>\n","</div></fieldset>\n";}function
selectLimitPrint($_){echo"<fieldset><legend>".'Limite'."</legend><div>";echo"<input type='number' name='limit' class='size' value='".h($_)."'>",script("qsl('input').oninput = selectFieldChange;",""),"</div></fieldset>\n";}function
selectLengthPrint($ig){if($ig!==null){echo"<fieldset><legend>".'Longueur du texte'."</legend><div>","<input type='number' name='text_length' class='size' value='".h($ig)."'>","</div></fieldset>\n";}}function
selectActionPrint($x){echo"<fieldset><legend>".'Action'."</legend><div>","<input type='submit' value='".'Sélectionner'."'>"," <span id='noindex' title='".'Scan de toute la table'."'></span>","<script".nonce().">\n","var indexColumns = ";$e=array();foreach($x
as$w){$gb=reset($w["columns"]);if($w["type"]!="FULLTEXT"&&$gb)$e[$gb]=1;}$e[""]=1;foreach($e
as$z=>$X)json_row($z);echo";\n","selectFieldChange.call(qs('#form')['select']);\n","</script>\n","</div></fieldset>\n";}function
selectCommandPrint(){return!information_schema(DB);}function
selectImportPrint(){return!information_schema(DB);}function
selectEmailPrint($Lb,$e){}function
selectColumnsProcess($e,$x){global$uc,$yc;$N=array();$t=array();foreach((array)$_GET["columns"]as$z=>$X){if($X["fun"]=="count"||($X["col"]!=""&&(!$X["fun"]||in_array($X["fun"],$uc)||in_array($X["fun"],$yc)))){$N[$z]=apply_sql_function($X["fun"],($X["col"]!=""?idf_escape($X["col"]):"*"));if(!in_array($X["fun"],$yc))$t[]=$N[$z];}}return
array($N,$t);}function
selectSearchProcess($n,$x){global$f,$k;$K=array();foreach($x
as$u=>$w){if($w["type"]=="FULLTEXT"&&$_GET["fulltext"][$u]!="")$K[]="MATCH (".implode(", ",array_map('idf_escape',$w["columns"])).") AGAINST (".q($_GET["fulltext"][$u]).(isset($_GET["boolean"][$u])?" IN BOOLEAN MODE":"").")";}foreach((array)$_GET["where"]as$z=>$X){if("$X[col]$X[val]"!=""&&in_array($X["op"],$this->operators)){$Me="";$Va=" $X[op]";if(preg_match('~IN$~',$X["op"])){$Nc=process_length($X["val"]);$Va.=" ".($Nc!=""?$Nc:"(NULL)");}elseif($X["op"]=="SQL")$Va=" $X[val]";elseif($X["op"]=="LIKE %%")$Va=" LIKE ".$this->processInput($n[$X["col"]],"%$X[val]%");elseif($X["op"]=="ILIKE %%")$Va=" ILIKE ".$this->processInput($n[$X["col"]],"%$X[val]%");elseif($X["op"]=="FIND_IN_SET"){$Me="$X[op](".q($X["val"]).", ";$Va=")";}elseif(!preg_match('~NULL$~',$X["op"]))$Va.=" ".$this->processInput($n[$X["col"]],$X["val"]);if($X["col"]!="")$K[]=$Me.$k->convertSearch(idf_escape($X["col"]),$X,$n[$X["col"]]).$Va;else{$Qa=array();foreach($n
as$F=>$m){if((preg_match('~^[-\d.'.(preg_match('~IN$~',$X["op"])?',':'').']+$~',$X["val"])||!preg_match('~'.number_type().'|bit~',$m["type"]))&&(!preg_match("~[\x80-\xFF]~",$X["val"])||preg_match('~char|text|enum|set~',$m["type"]))&&(!preg_match('~date|timestamp~',$m["type"])||preg_match('~^\d+-\d+-\d+~',$X["val"])))$Qa[]=$Me.$k->convertSearch(idf_escape($F),$X,$m).$Va;}$K[]=($Qa?"(".implode(" OR ",$Qa).")":"1 = 0");}}}return$K;}function
selectOrderProcess($n,$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,$pc){return
false;}function
selectQueryBuild($N,$Z,$t,$fe,$_,$G){return"";}function
messageQuery($I,$jg,$fc=false){global$y,$k;restart_session();$Fc=&get_session("queries");if(!$Fc[$_GET["db"]])$Fc[$_GET["db"]]=array();if(strlen($I)>1e6)$I=preg_replace('~[\x80-\xFF]+$~','',substr($I,0,1e6))."\n…";$Fc[$_GET["db"]][]=array($I,time(),$jg);$Jf="sql-".count($Fc[$_GET["db"]]);$K="<a href='#$Jf' class='toggle'>".'Requête SQL'."</a>\n";if(!$fc&&($ch=$k->warnings())){$v="warnings-".count($Fc[$_GET["db"]]);$K="<a href='#$v' class='toggle'>".'Warnings'."</a>, $K<div id='$v' class='hidden'>\n$ch</div>\n";}return" <span class='time'>".@date("H:i:s")."</span>"." $K<div id='$Jf' class='hidden'><pre><code class='jush-$y'>".shorten_utf8($I,1000)."</code></pre>".($jg?" <span class='time'>($jg)</span>":'').(support("sql")?'<p><a href="'.h(str_replace("db=".urlencode(DB),"db=".urlencode($_GET["db"]),ME).'sql=&history='.(count($Fc[$_GET["db"]])-1)).'">'.'Modifier'.'</a>':'').'</div>';}function
editRowPrint($R,$n,$L,$Kg){}function
editFunctions($m){global$Gb;$K=($m["null"]?"NULL/":"");$Kg=isset($_GET["select"])||where($_GET);foreach($Gb
as$z=>$uc){if(!$z||(!isset($_GET["call"])&&$Kg)){foreach($uc
as$Be=>$X){if(!$Be||preg_match("~$Be~",$m["type"]))$K.="/$X";}}if($z&&!preg_match('~set|blob|bytea|raw|file|bool~',$m["type"]))$K.="/SQL";}if($m["auto_increment"]&&!$Kg)$K='Incrément automatique';return
explode("/",$K);}function
editInput($R,$m,$ra,$Y){if($m["type"]=="enum")return(isset($_GET["select"])?"<label><input type='radio'$ra value='-1' checked><i>".'original'."</i></label> ":"").($m["null"]?"<label><input type='radio'$ra value=''".($Y!==null||isset($_GET["select"])?"":" checked")."><i>NULL</i></label> ":"").enum_input("radio",$ra,$m,$Y,0);return"";}function
editHint($R,$m,$Y){return"";}function
processInput($m,$Y,$s=""){if($s=="SQL")return$Y;$F=$m["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($m,$K);}function
dumpOutput(){$K=array('text'=>'ouvrir','file'=>'enregistrer');if(function_exists('gzencode'))$K['gz']='gzip';return$K;}function
dumpFormat(){return
array('sql'=>'SQL','csv'=>'CSV,','csv;'=>'CSV;','tsv'=>'TSV');}function
dumpDatabase($j){}function
dumpTable($R,$Pf,$Yc=0){if($_POST["format"]!="sql"){echo"\xef\xbb\xbf";if($Pf)dump_csv(array_keys(fields($R)));}else{if($Yc==2){$n=array();foreach(fields($R)as$F=>$m)$n[]=idf_escape($F)." $m[full_type]";$h="CREATE TABLE ".table($R)." (".implode(", ",$n).")";}else$h=create_sql($R,$_POST["auto_increment"],$Pf);set_utf8mb4($h);if($Pf&&$h){if($Pf=="DROP+CREATE"||$Yc==1)echo"DROP ".($Yc==2?"VIEW":"TABLE")." IF EXISTS ".table($R).";\n";if($Yc==1)$h=remove_definer($h);echo"$h;\n\n";}}}function
dumpData($R,$Pf,$I){global$f,$y;$wd=($y=="sqlite"?0:1048576);if($Pf){if($_POST["format"]=="sql"){if($Pf=="TRUNCATE+INSERT")echo
truncate_sql($R).";\n";$n=fields($R);}$J=$f->query($I,1);if($J){$Sc="";$Ca="";$cd=array();$Rf="";$ic=($R!=''?'fetch_assoc':'fetch_row');while($L=$J->$ic()){if(!$cd){$Ug=array();foreach($L
as$X){$m=$J->fetch_field();$cd[]=$m->name;$z=idf_escape($m->name);$Ug[]="$z = VALUES($z)";}$Rf=($Pf=="INSERT+UPDATE"?"\nON DUPLICATE KEY UPDATE ".implode(", ",$Ug):"").";\n";}if($_POST["format"]!="sql"){if($Pf=="table"){dump_csv($cd);$Pf="INSERT";}dump_csv($L);}else{if(!$Sc)$Sc="INSERT INTO ".table($R)." (".implode(", ",array_map('idf_escape',$cd)).") VALUES";foreach($L
as$z=>$X){$m=$n[$z];$L[$z]=($X!==null?unconvert_field($m,preg_match(number_type(),$m["type"])&&!preg_match('~\[~',$m["full_type"])&&is_numeric($X)?$X:q(($X===false?0:$X))):"NULL");}$pf=($wd?"\n":" ")."(".implode(",\t",$L).")";if(!$Ca)$Ca=$Sc.$pf;elseif(strlen($Ca)+4+strlen($pf)+strlen($Rf)<$wd)$Ca.=",$pf";else{echo$Ca.$Rf;$Ca=$Sc.$pf;}}}if($Ca)echo$Ca.$Rf;}elseif($_POST["format"]=="sql")echo"-- ".str_replace("\n"," ",$f->error)."\n";}}function
dumpFilename($Jc){return
friendly_url($Jc!=""?$Jc:(SERVER!=""?SERVER:"localhost"));}function
dumpHeaders($Jc,$Id=false){$qe=$_POST["output"];$bc=(preg_match('~sql~',$_POST["format"])?"sql":($Id?"tar":"csv"));header("Content-Type: ".($qe=="gz"?"application/x-gzip":($bc=="tar"?"application/x-tar":($bc=="sql"||$qe!="file"?"text/plain":"text/csv")."; charset=utf-8")));if($qe=="gz")ob_start('ob_gzencode',1e6);return$bc;}function
importServerPath(){return"adminer.sql";}function
homepage(){echo'<p class="links">'.($_GET["ns"]==""&&support("database")?'<a href="'.h(ME).'database=">'.'Modifier la base de données'."</a>\n":""),(support("scheme")?"<a href='".h(ME)."scheme='>".($_GET["ns"]!=""?'Modifier le schéma':'Créer un schéma')."</a>\n":""),($_GET["ns"]!==""?'<a href="'.h(ME).'schema=">'.'Schéma de la base de données'."</a>\n":""),(support("privileges")?"<a href='".h(ME)."privileges='>".'Privilèges'."</a>\n":"");return
true;}function
navigation($Hd){global$da,$y,$zb,$f;echo'<h1>
',$this->name(),' <span class="version">',$da,'</span>
<a href="https://www.adminer.org/#download"',target_blank(),' id="version">',(version_compare($da,$_COOKIE["adminer_version"])<0?h($_COOKIE["adminer_version"]):""),'</a>
</h1>
';if($Hd=="auth"){$qe="";foreach((array)$_SESSION["pwds"]as$Wg=>$zf){foreach($zf
as$O=>$Sg){foreach($Sg
as$Rg=>$_e){if($_e!==null){$mb=$_SESSION["db"][$Wg][$O][$Rg];foreach(($mb?array_keys($mb):array(""))as$j)$qe.="<li><a href='".h(auth_url($Wg,$O,$Rg,$j))."'>($zb[$Wg]) ".h($Rg.($O!=""?"@".$this->serverName($O):"").($j!=""?" - $j":""))."</a>\n";}}}}if($qe)echo"<ul id='logins'>\n$qe</ul>\n".script("mixin(qs('#logins'), {onmouseover: menuOver, onmouseout: menuOut});");}else{$T=array();if($_GET["ns"]!==""&&!$Hd&&DB!=""){$f->select_db(DB);$T=table_status('',true);}echo
script_src(preg_replace("~\\?.*~","",ME)."?file=jush.js&version=4.8.1");if(support("sql")){echo'<script',nonce(),'>
';if($T){$qd=array();foreach($T
as$R=>$V)$qd[]=preg_quote($R,'/');echo"var jushLinks = { $y: [ '".js_escape(ME).(support("table")?"table=":"select=")."\$&', /\\b(".implode("|",$qd).")\\b/g ] };\n";foreach(array("bac","bra","sqlite_quo","mssql_bra")as$X)echo"jushLinks.$X = jushLinks.$y;\n";}$yf=$f->server_info;echo'bodyLoad(\'',(is_object($f)?preg_replace('~^(\d\.?\d).*~s','\1',$yf):""),'\'',(preg_match('~MariaDB~',$yf)?", true":""),');
</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"])).">".'Requête SQL'."</a>\n<a href='".h(ME)."import='".bold(isset($_GET["import"])).">".'Importer'."</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"])).">".'Exporter'."</a>\n";}if($_GET["ns"]!==""&&!$Hd&&DB!=""){echo'<a href="'.h(ME).'create="'.bold($_GET["create"]==="").">".'Créer une table'."</a>\n";if(!$T)echo"<p class='message'>".'Aucune table.'."\n";else$this->tablesPrint($T);}}}function
databasesPrint($Hd){global$b,$f;$i=$this->databases();if(DB&&$i&&!in_array(DB,$i))array_unshift($i,DB);echo'<form action="">
<p id="dbs">
';hidden_fields_get();$kb=script("mixin(qsl('select'), {onmousedown: dbMouseDown, onchange: dbChange});");echo"<span title='".'base de données'."'>".'DB'."</span>: ".($i?"<select name='db'>".optionlist(array(""=>"")+$i,DB)."</select>$kb":"<input name='db' value='".h(DB)."' autocapitalize='off'>\n"),"<input type='submit' value='".'Utiliser'."'".($i?" class='hidden'":"").">\n";foreach(array("import","sql","schema","dump","privileges")as$X){if(isset($_GET[$X])){echo"<input type='hidden' name='$X' value=''>";break;}}echo"</p></form>\n";}function
tablesPrint($T){echo"<ul id='tables'>".script("mixin(qs('#tables'), {onmouseover: menuOver, onmouseout: menuOut});");foreach($T
as$R=>$Mf){$F=$this->tableName($Mf);if($F!=""){echo'<li><a href="'.h(ME).'select='.urlencode($R).'"'.bold($_GET["select"]==$R||$_GET["edit"]==$R,"select")." title='".'Afficher les données'."'>".'select'."</a> ",(support("table")||support("indexes")?'<a href="'.h(ME).'table='.urlencode($R).'"'.bold(in_array($R,array($_GET["table"],$_GET["create"],$_GET["indexes"],$_GET["foreign"],$_GET["trigger"])),(is_view($Mf)?"view":"structure"))." title='".'Afficher la structure'."'>$F</a>":"<span>$F</span>")."\n";}}echo"</ul>\n";}}$b=(function_exists('adminer_object')?adminer_object():new
Adminer);$Wa=driver_config();$Le=$Wa['possible_drivers'];$y=$Wa['jush'];$Cg=$Wa['types'];$Of=$Wa['structured_types'];$Jg=$Wa['unsigned'];$ae=$Wa['operators'];$uc=$Wa['functions'];$yc=$Wa['grouping'];$Gb=$Wa['edit_functions'];if($b->operators===null)$b->operators=$ae;define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~\?.*~','',relative_uri()).'?'.(sid()?SID.'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));$da="4.8.1";function
page_header($mg,$l="",$Ba=array(),$ng=""){global$ba,$da,$b,$zb,$y;page_headers();if(is_ajax()&&$l){page_messages($l);exit;}$og=$mg.($ng!=""?": $ng":"");$pg=strip_tags($og.(SERVER!=""&&SERVER!="localhost"?h(" - ".SERVER):"")." - ".$b->name());echo'<!DOCTYPE html>
<html lang="fr" dir="ltr">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="robots" content="noindex">
<title>',$pg,'</title>
<link rel="stylesheet" type="text/css" href="',h(preg_replace("~\\?.*~","",ME)."?file=default.css&version=4.8.1"),'">
',script_src(preg_replace("~\\?.*~","",ME)."?file=functions.js&version=4.8.1");if($b->head()){echo'<link rel="shortcut icon" type="image/x-icon" href="',h(preg_replace("~\\?.*~","",ME)."?file=favicon.ico&version=4.8.1"),'">
<link rel="apple-touch-icon" href="',h(preg_replace("~\\?.*~","",ME)."?file=favicon.ico&version=4.8.1"),'">
';foreach($b->css()as$eb){echo'<link rel="stylesheet" type="text/css" href="',h($eb),'">
';}}echo'
<body class="ltr nojs">
';$o=get_temp_dir()."/adminer.version";if(!$_COOKIE["adminer_version"]&&function_exists('openssl_verify')&&file_exists($o)&&filemtime($o)+86400>time()){$Xg=unserialize(file_get_contents($o));$Ve="-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAwqWOVuF5uw7/+Z70djoK
RlHIZFZPO0uYRezq90+7Amk+FDNd7KkL5eDve+vHRJBLAszF/7XKXe11xwliIsFs
DFWQlsABVZB3oisKCBEuI71J4kPH8dKGEWR9jDHFw3cWmoH3PmqImX6FISWbG3B8
h7FIx3jEaw5ckVPVTeo5JRm/1DZzJxjyDenXvBQ/6o9DgZKeNDgxwKzH+sw9/YCO
jHnq1cFpOIISzARlrHMa/43YfeNRAm/tsBXjSxembBPo7aQZLAWHmaj5+K19H10B
nCpz9Y++cipkVEiKRGih4ZEvjoFysEOdRLj6WiD/uUNky4xGeA6LaJqh5XpkFkcQ
fQIDAQAB
-----END PUBLIC KEY-----
";if(openssl_verify($Xg["version"],base64_decode($Xg["signature"]),$Ve)==1)$_COOKIE["adminer_version"]=$Xg["version"];}echo'<script',nonce(),'>
mixin(document.body, {onkeydown: bodyKeydown, onclick: bodyClick',(isset($_COOKIE["adminer_version"])?"":", onload: partial(verifyVersion, '$da', '".js_escape(ME)."', '".get_token()."')");?>});
document.body.className = document.body.className.replace(/ nojs/, ' js');
var offlineMessage = '<?php echo
js_escape('Vous êtes hors ligne.'),'\';
var thousandsSeparator = \'',js_escape(','),'\';
</script>
<div id="help" class="jush-',$y,' jsonly hidden"></div>
',script("mixin(qs('#help'), {onmouseover: function () { helpOpen = 1; }, onmouseout: helpMouseout});"),'
<div id="content">
';if($Ba!==null){$A=substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1);echo'<p id="breadcrumb"><a href="'.h($A?$A:".").'">'.$zb[DRIVER].'</a> &raquo; ';$A=substr(preg_replace('~\b(db|ns)=[^&]*&~','',ME),0,-1);$O=$b->serverName(SERVER);$O=($O!=""?$O:'Serveur');if($Ba===false)echo"$O\n";else{echo"<a href='".h($A)."' accesskey='1' title='Alt+Shift+1'>$O</a> &raquo; ";if($_GET["ns"]!=""||(DB!=""&&is_array($Ba)))echo'<a href="'.h($A."&db=".urlencode(DB).(support("scheme")?"&ns=":"")).'">'.h(DB).'</a> &raquo; ';if(is_array($Ba)){if($_GET["ns"]!="")echo'<a href="'.h(substr(ME,0,-1)).'">'.h($_GET["ns"]).'</a> &raquo; ';foreach($Ba
as$z=>$X){$sb=(is_array($X)?$X[1]:h($X));if($sb!="")echo"<a href='".h(ME."$z=").urlencode(is_array($X)?$X[0]:$X)."'>$sb</a> &raquo; ";}}echo"$mg\n";}}echo"<h2>$og</h2>\n","<div id='ajaxstatus' class='jsonly hidden'></div>\n";restart_session();page_messages($l);$i=&get_session("dbs");if(DB!=""&&$i&&!in_array(DB,$i,true))$i=null;stop_session();define("PAGE_HEADER",1);}function
page_headers(){global$b;header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");header("X-Frame-Options: SAMEORIGIN");header("X-XSS-Protection: 0");header("X-Content-Type-Options: nosniff");header("Referrer-Policy: origin-when-cross-origin");foreach($b->csp()as$db){$Dc=array();foreach($db
as$z=>$X)$Dc[]="$z $X";header("Content-Security-Policy: ".implode("; ",$Dc));}$b->headers();}function
csp(){return
array(array("script-src"=>"'self' 'unsafe-inline' 'nonce-".get_nonce()."' 'strict-dynamic'","connect-src"=>"'self'","frame-src"=>"https://www.adminer.org","object-src"=>"'none'","base-uri"=>"'none'","form-action"=>"'self'",),);}function
get_nonce(){static$Nd;if(!$Nd)$Nd=base64_encode(rand_string());return$Nd;}function
page_messages($l){$Lg=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$Ed=$_SESSION["messages"][$Lg];if($Ed){echo"<div class='message'>".implode("</div>\n<div class='message'>",$Ed)."</div>".script("messagesPrint();");unset($_SESSION["messages"][$Lg]);}if($l)echo"<div class='error'>$l</div>\n";}function
page_footer($Hd=""){global$b,$U;echo'</div>
';if($Hd!="auth"){echo'<form action="" method="post">
<p class="logout">
<input type="submit" name="logout" value="Déconnexion" id="logout">
<input type="hidden" name="token" value="',$U,'">
</p>
</form>
';}echo'<div id="menu">
';$b->navigation($Hd);echo'</div>
',script("setupSubmitHighlight(document);");}function
int32($E){while($E>=2147483648)$E-=4294967296;while($E<=-2147483649)$E+=4294967296;return(int)$E;}function
long2str($W,$bh){$pf='';foreach($W
as$X)$pf.=pack('V',$X);if($bh)return
substr($pf,0,end($W));return$pf;}function
str2long($pf,$bh){$W=array_values(unpack('V*',str_pad($pf,4*ceil(strlen($pf)/4),"\0")));if($bh)$W[]=strlen($pf);return$W;}function
xxtea_mx($ih,$hh,$Sf,$ad){return
int32((($ih>>5&0x7FFFFFF)^$hh<<2)+(($hh>>3&0x1FFFFFFF)^$ih<<4))^int32(($Sf^$hh)+($ad^$ih));}function
encrypt_string($Nf,$z){if($Nf=="")return"";$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($Nf,true);$E=count($W)-1;$ih=$W[$E];$hh=$W[0];$H=floor(6+52/($E+1));$Sf=0;while($H-->0){$Sf=int32($Sf+0x9E3779B9);$Fb=$Sf>>2&3;for($re=0;$re<$E;$re++){$hh=$W[$re+1];$Jd=xxtea_mx($ih,$hh,$Sf,$z[$re&3^$Fb]);$ih=int32($W[$re]+$Jd);$W[$re]=$ih;}$hh=$W[0];$Jd=xxtea_mx($ih,$hh,$Sf,$z[$re&3^$Fb]);$ih=int32($W[$E]+$Jd);$W[$E]=$ih;}return
long2str($W,false);}function
decrypt_string($Nf,$z){if($Nf=="")return"";if(!$z)return
false;$z=array_values(unpack("V*",pack("H*",md5($z))));$W=str2long($Nf,false);$E=count($W)-1;$ih=$W[$E];$hh=$W[0];$H=floor(6+52/($E+1));$Sf=int32($H*0x9E3779B9);while($Sf){$Fb=$Sf>>2&3;for($re=$E;$re>0;$re--){$ih=$W[$re-1];$Jd=xxtea_mx($ih,$hh,$Sf,$z[$re&3^$Fb]);$hh=int32($W[$re]-$Jd);$W[$re]=$hh;}$ih=$W[$E];$Jd=xxtea_mx($ih,$hh,$Sf,$z[$re&3^$Fb]);$hh=int32($W[0]-$Jd);$W[0]=$hh;$Sf=int32($Sf-0x9E3779B9);}return
long2str($W,true);}$f='';$Cc=$_SESSION["token"];if(!$Cc)$_SESSION["token"]=rand(1,1e6);$U=get_token();$De=array();if($_COOKIE["adminer_permanent"]){foreach(explode(" ",$_COOKIE["adminer_permanent"])as$X){list($z)=explode(":",$X);$De[$z]=$X;}}function
add_invalid_login(){global$b;$r=file_open_lock(get_temp_dir()."/adminer.invalid");if(!$r)return;$Uc=unserialize(stream_get_contents($r));$jg=time();if($Uc){foreach($Uc
as$Vc=>$X){if($X[0]<$jg)unset($Uc[$Vc]);}}$Tc=&$Uc[$b->bruteForceKey()];if(!$Tc)$Tc=array($jg+30*60,0);$Tc[1]++;file_write_unlock($r,serialize($Uc));}function
check_invalid_login(){global$b;$Uc=unserialize(@file_get_contents(get_temp_dir()."/adminer.invalid"));$Tc=($Uc?$Uc[$b->bruteForceKey()]:array());$Md=($Tc[1]>29?$Tc[0]-time():0);if($Md>0)auth_error(lang(array('Trop de connexions échouées, essayez à nouveau dans %d minute.','Trop de connexions échouées, essayez à nouveau dans %d minutes.'),ceil($Md/60)));}$sa=$_POST["auth"];if($sa){session_regenerate_id();$Wg=$sa["driver"];$O=$sa["server"];$Rg=$sa["username"];$_e=(string)$sa["password"];$j=$sa["db"];set_password($Wg,$O,$Rg,$_e);$_SESSION["db"][$Wg][$O][$Rg][$j]=true;if($sa["permanent"]){$z=base64_encode($Wg)."-".base64_encode($O)."-".base64_encode($Rg)."-".base64_encode($j);$Re=$b->permanentLogin(true);$De[$z]="$z:".base64_encode($Re?encrypt_string($_e,$Re):"");cookie("adminer_permanent",implode(" ",$De));}if(count($_POST)==1||DRIVER!=$Wg||SERVER!=$O||$_GET["username"]!==$Rg||DB!=$j)redirect(auth_url($Wg,$O,$Rg,$j));}elseif($_POST["logout"]&&(!$Cc||verify_token())){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),'Au revoir !'.' '.'Thanks for using Adminer, consider <a href="https://www.adminer.org/en/donation/">donating</a>.');}elseif($De&&!$_SESSION["pwds"]){session_regenerate_id();$Re=$b->permanentLogin();foreach($De
as$z=>$X){list(,$Ia)=explode(":",$X);list($Wg,$O,$Rg,$j)=array_map('base64_decode',explode("-",$z));set_password($Wg,$O,$Rg,decrypt_string(base64_decode($Ia),$Re));$_SESSION["db"][$Wg][$O][$Rg][$j]=true;}}function
unset_permanent(){global$De;foreach($De
as$z=>$X){list($Wg,$O,$Rg,$j)=array_map('base64_decode',explode("-",$z));if($Wg==DRIVER&&$O==SERVER&&$Rg==$_GET["username"]&&$j==DB)unset($De[$z]);}cookie("adminer_permanent",implode(" ",$De));}function
auth_error($l){global$b,$Cc;$_f=session_name();if(isset($_GET["username"])){header("HTTP/1.1 403 Forbidden");if(($_COOKIE[$_f]||$_GET[$_f])&&!$Cc)$l='Session expirée, veuillez vous authentifier à nouveau.';else{restart_session();add_invalid_login();$_e=get_password();if($_e!==null){if($_e===false)$l.=($l?'<br>':'').sprintf('Le mot de passe a expiré. <a href="https://www.adminer.org/en/extension/"%s>Implémentez</a> la méthode %s afin de le rendre permanent.',target_blank(),'<code>permanentLogin()</code>');set_password(DRIVER,SERVER,$_GET["username"],null);}unset_permanent();}}if(!$_COOKIE[$_f]&&$_GET[$_f]&&ini_bool("session.use_only_cookies"))$l='Veuillez activer les sessions.';$ue=session_get_cookie_params();cookie("adminer_key",($_COOKIE["adminer_key"]?$_COOKIE["adminer_key"]:rand_string()),$ue["lifetime"]);page_header('Authentification',$l,null);echo"<form action='' method='post'>\n","<div>";if(hidden_fields($_POST,array("auth")))echo"<p class='message'>".'The action will be performed after successful login with the same credentials.'."\n";echo"</div>\n";$b->loginForm();echo"</form>\n";page_footer("auth");exit;}if(isset($_GET["username"])&&!class_exists("Min_DB")){unset($_SESSION["pwds"][DRIVER]);unset_permanent();page_header('Extension introuvable',sprintf('Aucune des extensions PHP supportées (%s) n\'est disponible.',implode(", ",$Le)),false);page_footer("auth");exit;}stop_session(true);if(isset($_GET["username"])&&is_string(get_password())){list($Hc,$He)=explode(":",SERVER,2);if(preg_match('~^\s*([-+]?\d+)~',$He,$C)&&($C[1]<1024||$C[1]>65535))auth_error('Connecting to privileged ports is not allowed.');check_invalid_login();$f=connect();$k=new
Min_Driver($f);}$rd=null;if(!is_object($f)||($rd=$b->login($_GET["username"],get_password()))!==true){$l=(is_string($f)?h($f):(is_string($rd)?$rd:'Authentification échouée.'));auth_error($l.(preg_match('~^ | $~',get_password())?'<br>'.'There is a space in the input password which might be the cause.':''));}if($_POST["logout"]&&$Cc&&!verify_token()){page_header('Déconnexion','Token CSRF invalide. Veuillez renvoyer le formulaire.');page_footer("db");exit;}if($sa&&$_POST["token"])$_POST["token"]=$U;$l='';if($_POST){if(!verify_token()){$Pc="max_input_vars";$_d=ini_get($Pc);if(extension_loaded("suhosin")){foreach(array("suhosin.request.max_vars","suhosin.post.max_vars")as$z){$X=ini_get($z);if($X&&(!$_d||$X<$_d)){$Pc=$z;$_d=$X;}}}$l=(!$_POST["token"]&&$_d?sprintf('Le nombre maximum de champs est dépassé. Veuillez augmenter %s.',"'$Pc'"):'Token CSRF invalide. Veuillez renvoyer le formulaire.'.' '.'Si vous n\'avez pas envoyé cette requête depuis Adminer, alors fermez cette page.');}}elseif($_SERVER["REQUEST_METHOD"]=="POST"){$l=sprintf('Données POST trop grandes. Réduisez la taille des données ou augmentez la valeur de %s dans la configuration de PHP.',"'post_max_size'");if(isset($_GET["sql"]))$l.=' '.'Vous pouvez uploader un gros fichier SQL par FTP et ensuite l\'importer depuis le serveur.';}function
select($J,$g=null,$ie=array(),$_=0){global$y;$qd=array();$x=array();$e=array();$_a=array();$Cg=array();$K=array();odd('');for($u=0;(!$_||$u<$_)&&($L=$J->fetch_row());$u++){if(!$u){echo"<div class='scrollable'>\n","<table cellspacing='0' class='nowrap'>\n","<thead><tr>";for($Zc=0;$Zc<count($L);$Zc++){$m=$J->fetch_field();$F=$m->name;$he=$m->orgtable;$ge=$m->orgname;$K[$m->table]=$he;if($ie&&$y=="sql")$qd[$Zc]=($F=="table"?"table=":($F=="possible_keys"?"indexes=":null));elseif($he!=""){if(!isset($x[$he])){$x[$he]=array();foreach(indexes($he,$g)as$w){if($w["type"]=="PRIMARY"){$x[$he]=array_flip($w["columns"]);break;}}$e[$he]=$x[$he];}if(isset($e[$he][$ge])){unset($e[$he][$ge]);$x[$he][$ge]=$Zc;$qd[$Zc]=$he;}}if($m->charsetnr==63)$_a[$Zc]=true;$Cg[$Zc]=$m->type;echo"<th".($he!=""||$m->name!=$ge?" title='".h(($he!=""?"$he.":"").$ge)."'":"").">".h($F).($ie?'':"");}echo"</thead>\n";}echo"<tr".odd().">";foreach($L
as$z=>$X){$A="";if(isset($qd[$z])&&!$e[$qd[$z]]){if($ie&&$y=="sql"){$R=$L[array_search("table=",$qd)];$A=ME.$qd[$z].urlencode($ie[$R]!=""?$ie[$R]:$R);}else{$A=ME."edit=".urlencode($qd[$z]);foreach($x[$qd[$z]]as$Ma=>$Zc)$A.="&where".urlencode("[".bracket_escape($Ma)."]")."=".urlencode($L[$Zc]);}}elseif(is_url($X))$A=$X;if($X===null)$X="<i>NULL</i>";elseif($_a[$z]&&!is_utf8($X))$X="<i>".lang(array('%d octet','%d octets'),strlen($X))."</i>";else{$X=h($X);if($Cg[$z]==254)$X="<code>$X</code>";}if($A)$X="<a href='".h($A)."'".(is_url($A)?target_blank():'').">$X</a>";echo"<td>$X";}}echo($u?"</table>\n</div>":"<p class='message'>".'Aucun résultat.')."\n";return$K;}function
referencable_primary($vf){$K=array();foreach(table_status('',true)as$Wf=>$R){if($Wf!=$vf&&fk_support($R)){foreach(fields($Wf)as$m){if($m["primary"]){if($K[$Wf]){unset($K[$Wf]);break;}$K[$Wf]=$m;}}}}return$K;}function
adminer_settings(){parse_str($_COOKIE["adminer_settings"],$Bf);return$Bf;}function
adminer_setting($z){$Bf=adminer_settings();return$Bf[$z];}function
set_adminer_settings($Bf){return
cookie("adminer_settings",http_build_query($Bf+adminer_settings()));}function
textarea($F,$Y,$M=10,$Qa=80){global$y;echo"<textarea name='$F' rows='$M' cols='$Qa' 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,$m,$Pa,$q=array(),$ec=array()){global$Of,$Cg,$Jg,$Wd;$V=$m["type"];echo'<td><select name="',h($z),'[type]" class="type" aria-labelledby="label-type">';if($V&&!isset($Cg[$V])&&!isset($q[$V])&&!in_array($V,$ec))$ec[]=$V;if($q)$Of['Clés étrangères']=$q;echo
optionlist(array_merge($ec,$Of),$V),'</select><td><input name="',h($z),'[length]" value="',h($m["length"]),'" size="3"',(!$m["length"]&&preg_match('~var(char|binary)$~',$V)?" class='required'":"");echo' aria-labelledby="label-length"><td class="options">',"<select name='".h($z)."[collation]'".(preg_match('~(char|text|enum|set)$~',$V)?"":" class='hidden'").'><option value="">('.'interclassement'.')'.optionlist($Pa,$m["collation"]).'</select>',($Jg?"<select name='".h($z)."[unsigned]'".(!$V||preg_match(number_type(),$V)?"":" class='hidden'").'><option>'.optionlist($Jg,$m["unsigned"]).'</select>':''),(isset($m['on_update'])?"<select name='".h($z)."[on_update]'".(preg_match('~timestamp|datetime~',$V)?"":" class='hidden'").'>'.optionlist(array(""=>"(".'ON UPDATE'.")","CURRENT_TIMESTAMP"),(preg_match('~^CURRENT_TIMESTAMP~i',$m["on_update"])?"CURRENT_TIMESTAMP":$m["on_update"])).'</select>':''),($q?"<select name='".h($z)."[on_delete]'".(preg_match("~`~",$V)?"":" class='hidden'")."><option value=''>(".'ON DELETE'.")".optionlist(explode("|",$Wd),$m["on_delete"])."</select> ":" ");}function
process_length($nd){global$Qb;return(preg_match("~^\\s*\\(?\\s*$Qb(?:\\s*,\\s*$Qb)*+\\s*\\)?\\s*\$~",$nd)&&preg_match_all("~$Qb~",$nd,$ud)?"(".implode(",",$ud[0]).")":preg_replace('~^[0-9].*~','(\0)',preg_replace('~[^-0-9,+()[\]]~','',$nd)));}function
process_type($m,$Na="COLLATE"){global$Jg;return" $m[type]".process_length($m["length"]).(preg_match(number_type(),$m["type"])&&in_array($m["unsigned"],$Jg)?" $m[unsigned]":"").(preg_match('~char|text|enum|set~',$m["type"])&&$m["collation"]?" $Na ".q($m["collation"]):"");}function
process_field($m,$Bg){return
array(idf_escape(trim($m["field"])),process_type($Bg),($m["null"]?" NULL":" NOT NULL"),default_value($m),(preg_match('~timestamp|datetime~',$m["type"])&&$m["on_update"]?" ON UPDATE $m[on_update]":""),(support("comment")&&$m["comment"]!=""?" COMMENT ".q($m["comment"]):""),($m["auto_increment"]?auto_increment():null),);}function
default_value($m){$ob=$m["default"];return($ob===null?"":" DEFAULT ".(preg_match('~char|binary|text|enum|set~',$m["type"])||preg_match('~^(?![a-z])~i',$ob)?q($ob):$ob));}function
type_class($V){foreach(array('char'=>'text','date'=>'time|year','binary'=>'blob','enum'=>'set',)as$z=>$X){if(preg_match("~$z|$X~",$V))return" class='$z'";}}function
edit_fields($n,$Pa,$V="TABLE",$q=array()){global$Qc;$n=array_values($n);$pb=(($_POST?$_POST["defaults"]:adminer_setting("defaults"))?"":" class='hidden'");$Ua=(($_POST?$_POST["comments"]:adminer_setting("comments"))?"":" class='hidden'");echo'<thead><tr>
';if($V=="PROCEDURE"){echo'<td>';}echo'<th id="label-name">',($V=="TABLE"?'Nom de la colonne':'Nom du paramètre'),'<td id="label-type">Type<textarea id="enum-edit" rows="4" cols="12" wrap="off" style="display: none;"></textarea>',script("qs('#enum-edit').onblur = editingLengthBlur;"),'<td id="label-length">Longueur
<td>','Options';if($V=="TABLE"){echo'<td id="label-null">NULL
<td><input type="radio" name="auto_increment_col" value=""><acronym id="label-ai" title="Incrément automatique">AI</acronym>',doc_link(array('sqlite'=>"autoinc.html",)),'<td id="label-default"',$pb,'>Valeur par défaut
',(support("comment")?"<td id='label-comment'$Ua>".'Commentaire':"");}echo'<td>',"<input type='image' class='icon' name='add[".(support("move_col")?0:count($n))."]' src='".h(preg_replace("~\\?.*~","",ME)."?file=plus.gif&version=4.8.1")."' alt='+' title='".'Ajouter le prochain'."'>".script("row_count = ".count($n).";"),'</thead>
<tbody>
',script("mixin(qsl('tbody'), {onclick: editingClick, onkeydown: editingKeydown, oninput: editingInput});");foreach($n
as$u=>$m){$u++;$je=$m[($_POST?"orig":"field")];$wb=(isset($_POST["add"][$u-1])||(isset($m["field"])&&!$_POST["drop_col"][$u]))&&(support("drop_col")||$je=="");echo'<tr',($wb?"":" style='display: none;'"),'>
',($V=="PROCEDURE"?"<td>".html_select("fields[$u][inout]",explode("|",$Qc),$m["inout"]):""),'<th>';if($wb){echo'<input name="fields[',$u,'][field]" value="',h($m["field"]),'" data-maxlength="64" autocapitalize="off" aria-labelledby="label-name">';}echo'<input type="hidden" name="fields[',$u,'][orig]" value="',h($je),'">';edit_type("fields[$u]",$m,$Pa,$q);if($V=="TABLE"){echo'<td>',checkbox("fields[$u][null]",1,$m["null"],"","","block","label-null"),'<td><label class="block"><input type="radio" name="auto_increment_col" value="',$u,'"';if($m["auto_increment"]){echo' checked';}echo' aria-labelledby="label-ai"></label><td',$pb,'>',checkbox("fields[$u][has_default]",1,$m["has_default"],"","","","label-default"),'<input name="fields[',$u,'][default]" value="',h($m["default"]),'" aria-labelledby="label-default">',(support("comment")?"<td$Ua><input name='fields[$u][comment]' value='".h($m["comment"])."' data-maxlength='".(min_version(5.5)?1024:255)."' aria-labelledby='label-comment'>":"");}echo"<td>",(support("move_col")?"<input type='image' class='icon' name='add[$u]' src='".h(preg_replace("~\\?.*~","",ME)."?file=plus.gif&version=4.8.1")."' alt='+' title='".'Ajouter le prochain'."'> "."<input type='image' class='icon' name='up[$u]' src='".h(preg_replace("~\\?.*~","",ME)."?file=up.gif&version=4.8.1")."' alt='↑' title='".'Déplacer vers le haut'."'> "."<input type='image' class='icon' name='down[$u]' src='".h(preg_replace("~\\?.*~","",ME)."?file=down.gif&version=4.8.1")."' alt='↓' title='".'Déplacer vers le bas'."'> ":""),($je==""||support("drop_col")?"<input type='image' class='icon' name='drop_col[$u]' src='".h(preg_replace("~\\?.*~","",ME)."?file=cross.gif&version=4.8.1")."' alt='x' title='".'Effacer'."'>":"");}}function
process_fields(&$n){$Sd=0;if($_POST["up"]){$hd=0;foreach($n
as$z=>$m){if(key($_POST["up"])==$z){unset($n[$z]);array_splice($n,$hd,0,array($m));break;}if(isset($m["field"]))$hd=$Sd;$Sd++;}}elseif($_POST["down"]){$rc=false;foreach($n
as$z=>$m){if(isset($m["field"])&&$rc){unset($n[key($_POST["down"])]);array_splice($n,$Sd,0,array($rc));break;}if(key($_POST["down"])==$z)$rc=$m;$Sd++;}}elseif($_POST["add"]){$n=array_values($n);array_splice($n,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($vc,$Se,$e,$Vd){if(!$Se)return
true;if($Se==array("ALL PRIVILEGES","GRANT OPTION"))return($vc=="GRANT"?queries("$vc ALL PRIVILEGES$Vd WITH GRANT OPTION"):queries("$vc ALL PRIVILEGES$Vd")&&queries("$vc GRANT OPTION$Vd"));return
queries("$vc ".preg_replace('~(GRANT OPTION)\([^)]*\)~','\1',implode("$e, ",$Se).$e).$Vd);}function
drop_create($_b,$h,$Ab,$gg,$Cb,$B,$Dd,$Bd,$Cd,$Ud,$Ld){if($_POST["drop"])query_redirect($_b,$B,$Dd);elseif($Ud=="")query_redirect($h,$B,$Cd);elseif($Ud!=$Ld){$cb=queries($h);queries_redirect($B,$Bd,$cb&&queries($_b));if($cb)queries($Ab);}else
queries_redirect($B,$Bd,queries($gg)&&queries($Cb)&&queries($_b)&&queries($h));}function
create_trigger($Vd,$L){global$y;$lg=" $L[Timing] $L[Event]".(preg_match('~ OF~',$L["Event"])?" $L[Of]":"");return"CREATE TRIGGER ".idf_escape($L["Trigger"]).($y=="mssql"?$Vd.$lg:$lg.$Vd).rtrim(" $L[Type]\n$L[Statement]",";").";";}function
create_routine($nf,$L){global$Qc,$y;$P=array();$n=(array)$L["fields"];ksort($n);foreach($n
as$m){if($m["field"]!="")$P[]=(preg_match("~^($Qc)\$~",$m["inout"])?"$m[inout] ":"").idf_escape($m["field"]).process_type($m,"CHARACTER SET");}$qb=rtrim("\n$L[definition]",";");return"CREATE $nf ".idf_escape(trim($L["name"]))." (".implode(", ",$P).")".(isset($_GET["function"])?" RETURNS".process_type($L["returns"],"CHARACTER SET"):"").($L["language"]?" LANGUAGE $L[language]":"").($y=="pgsql"?" AS ".q($qb):"$qb;");}function
remove_definer($I){return
preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\1)',logged_user()).'`~','\1',$I);}function
format_foreign_key($p){global$Wd;$j=$p["db"];$Od=$p["ns"];return" FOREIGN KEY (".implode(", ",array_map('idf_escape',$p["source"])).") REFERENCES ".($j!=""&&$j!=$_GET["db"]?idf_escape($j).".":"").($Od!=""&&$Od!=$_GET["ns"]?idf_escape($Od).".":"").table($p["table"])." (".implode(", ",array_map('idf_escape',$p["target"])).")".(preg_match("~^($Wd)\$~",$p["on_delete"])?" ON DELETE $p[on_delete]":"").(preg_match("~^($Wd)\$~",$p["on_update"])?" ON UPDATE $p[on_update]":"");}function
tar_file($o,$qg){$K=pack("a100a8a8a8a12a12",$o,644,0,0,decoct($qg->size),decoct(time()));$Ha=8*32;for($u=0;$u<strlen($K);$u++)$Ha+=ord($K[$u]);$K.=sprintf("%06o",$Ha)."\0 ";echo$K,str_repeat("\0",512-strlen($K));$qg->send();echo
str_repeat("\0",511-($qg->size+511)%512);}function
ini_bytes($Pc){$X=ini_get($Pc);switch(strtolower(substr($X,-1))){case'g':$X*=1024;case'm':$X*=1024;case'k':$X*=1024;}return$X;}function
doc_link($Ae,$hg="<sup>?</sup>"){global$y,$f;$yf=$f->server_info;$Xg=preg_replace('~^(\d\.?\d).*~s','\1',$yf);$Ng=array('sql'=>"https://dev.mysql.com/doc/refman/$Xg/en/",'sqlite'=>"https://www.sqlite.org/",'pgsql'=>"https://www.postgresql.org/docs/$Xg/",'mssql'=>"https://msdn.microsoft.com/library/",'oracle'=>"https://www.oracle.com/pls/topic/lookup?ctx=db".preg_replace('~^.* (\d+)\.(\d+)\.\d+\.\d+\.\d+.*~s','\1\2',$yf)."&id=",);if(preg_match('~MariaDB~',$yf)){$Ng['sql']="https://mariadb.com/kb/en/library/";$Ae['sql']=(isset($Ae['mariadb'])?$Ae['mariadb']:str_replace(".html","/",$Ae['sql']));}return($Ae[$y]?"<a href='".h($Ng[$y].$Ae[$y])."'".target_blank().">$hg</a>":"");}function
ob_gzencode($Q){return
gzencode($Q);}function
db_size($j){global$f;if(!$f->select_db($j))return"?";$K=0;foreach(table_status()as$S)$K+=$S["Data_length"]+$S["Index_length"];return
format_number($K);}function
set_utf8mb4($h){global$f;static$P=false;if(!$P&&preg_match('~\butf8mb4~i',$h)){$P=true;echo"SET NAMES ".charset($f).";\n\n";}}function
connect_error(){global$b,$f,$U,$l,$zb;if(DB!=""){header("HTTP/1.1 404 Not Found");page_header('Base de données'.": ".h(DB),'Base de données invalide.',true);}else{if($_POST["db"]&&!$l)queries_redirect(substr(ME,0,-1),'Les bases de données ont été supprimées.',drop_databases($_POST["db"]));page_header('Sélectionner la base de données',$l,false);echo"<p class='links'>\n";foreach(array('database'=>'Créer une base de données','privileges'=>'Privilèges','processlist'=>'Liste des processus','variables'=>'Variables','status'=>'Statut',)as$z=>$X){if(support($z))echo"<a href='".h(ME)."$z='>$X</a>\n";}echo"<p>".sprintf('Version de %s : %s via l\'extension PHP %s',$zb[DRIVER],"<b>".h($f->server_info)."</b>","<b>$f->extension</b>")."\n","<p>".sprintf('Authentifié en tant que : %s',"<b>".h(logged_user())."</b>")."\n";$i=$b->databases();if($i){$rf=support("scheme");$Pa=collations();echo"<form action='' method='post'>\n","<table cellspacing='0' class='checkable'>\n",script("mixin(qsl('table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true)});"),"<thead><tr>".(support("database")?"<td>":"")."<th>".'Base de données'." - <a href='".h(ME)."refresh=1'>".'Rafraîchir'."</a>"."<td>".'Interclassement'."<td>".'Tables'."<td>".'Taille'." - <a href='".h(ME)."dbsize=1'>".'Calcul'."</a>".script("qsl('a').onclick = partial(ajaxSetHtml, '".js_escape(ME)."script=connect');","")."</thead>\n";$i=($_GET["dbsize"]?count_tables($i):array_flip($i));foreach($i
as$j=>$T){$mf=h(ME)."db=".urlencode($j);$v=h("Db-".$j);echo"<tr".odd().">".(support("database")?"<td>".checkbox("db[]",$j,in_array($j,(array)$_POST["db"]),"","","",$v):""),"<th><a href='$mf' id='$v'>".h($j)."</a>";$Oa=h(db_collation($j,$Pa));echo"<td>".(support("database")?"<a href='$mf".($rf?"&amp;ns=":"")."&amp;database=' title='".'Modifier la base de données'."'>$Oa</a>":$Oa),"<td align='right'><a href='$mf&amp;schema=' id='tables-".h($j)."' title='".'Schéma de la base de données'."'>".($_GET["dbsize"]?$T:"?")."</a>","<td align='right' id='size-".h($j)."'>".($_GET["dbsize"]?db_size($j):"?"),"\n";}echo"</table>\n",(support("database")?"<div class='footer'><div>\n"."<fieldset><legend>".'Sélectionnée(s)'." <span id='selected'></span></legend><div>\n"."<input type='hidden' name='all' value=''>".script("qsl('input').onclick = function () { selectCount('selected', formChecked(this, /^db/)); };")."<input type='submit' name='drop' value='".'Supprimer'."'>".confirm()."\n"."</div></fieldset>\n"."</div></div>\n":""),"<input type='hidden' name='token' value='$U'>\n","</form>\n",script("tableCheck();");}}page_footer("db");}if(isset($_GET["status"]))$_GET["variables"]=$_GET["status"];if(isset($_GET["import"]))$_GET["sql"]=$_GET["import"];if(!(DB!=""?$f->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;}$Wd="RESTRICT|NO ACTION|CASCADE|SET NULL|SET DEFAULT";class
TmpFile{var$handler;var$size;function
__construct(){$this->handler=tmpfile();}function
write($Za){$this->size+=strlen($Za);fwrite($this->handler,$Za);}function
send(){fseek($this->handler,0);fpassthru($this->handler);fclose($this->handler);}}$Qb="'(?:''|[^'\\\\]|\\\\.)*'";$Qc="IN|OUT|INOUT";if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["download"])){$a=$_GET["download"];$n=fields($a);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$a-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$N=array(idf_escape($_GET["field"]));$J=$k->select($a,$N,array(where($_GET,$n)),$N);$L=($J?$J->fetch_row():array());echo$k->value($L[0],$n[$_GET["field"]]);exit;}elseif(isset($_GET["table"])){$a=$_GET["table"];$n=fields($a);if(!$n)$l=error();$S=table_status1($a,true);$F=$b->tableName($S);page_header(($n&&is_view($S)?$S['Engine']=='materialized view'?'Vue matérialisée':'Vue':'Table').": ".($F!=""?$F:h($a)),$l);$b->selectLinks($S);$Ta=$S["Comment"];if($Ta!="")echo"<p class='nowrap'>".'Commentaire'.": ".h($Ta)."\n";if($n)$b->tableStructurePrint($n);if(!is_view($S)){if(support("indexes")){echo"<h3 id='indexes'>".'Index'."</h3>\n";$x=indexes($a);if($x)$b->tableIndexesPrint($x);echo'<p class="links"><a href="'.h(ME).'indexes='.urlencode($a).'">'.'Modifier les index'."</a>\n";}if(fk_support($S)){echo"<h3 id='foreign-keys'>".'Clés étrangères'."</h3>\n";$q=foreign_keys($a);if($q){echo"<table cellspacing='0'>\n","<thead><tr><th>".'Source'."<td>".'Cible'."<td>".'ON DELETE'."<td>".'ON UPDATE'."<td></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>".h($p["on_delete"])."\n","<td>".h($p["on_update"])."\n",'<td><a href="'.h(ME.'foreign='.urlencode($a).'&name='.urlencode($F)).'">'.'Modifier'.'</a>';}echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'foreign='.urlencode($a).'">'.'Ajouter une clé étrangère'."</a>\n";}}if(support(is_view($S)?"view_trigger":"trigger")){echo"<h3 id='triggers'>".'Déclencheurs'."</h3>\n";$Ag=triggers($a);if($Ag){echo"<table cellspacing='0'>\n";foreach($Ag
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($a).'&name='.urlencode($z))."'>".'Modifier'."</a>\n";echo"</table>\n";}echo'<p class="links"><a href="'.h(ME).'trigger='.urlencode($a).'">'.'Ajouter un déclencheur'."</a>\n";}}elseif(isset($_GET["schema"])){page_header('Schéma de la base de données',"",array(),h(DB.($_GET["ns"]?".$_GET[ns]":"")));$Xf=array();$Yf=array();$ca=($_GET["schema"]?$_GET["schema"]:$_COOKIE["adminer_schema-".str_replace(".","_",DB)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$ca,$ud,PREG_SET_ORDER);foreach($ud
as$u=>$C){$Xf[$C[1]]=array($C[2],$C[3]);$Yf[]="\n\t'".js_escape($C[1])."': [ $C[2], $C[3] ]";}$sg=0;$xa=-1;$qf=array();$ff=array();$ld=array();foreach(table_status('',true)as$R=>$S){if(is_view($S))continue;$Ie=0;$qf[$R]["fields"]=array();foreach(fields($R)as$F=>$m){$Ie+=1.25;$m["pos"]=$Ie;$qf[$R]["fields"][$F]=$m;}$qf[$R]["pos"]=($Xf[$R]?$Xf[$R]:array($sg,0));foreach($b->foreignKeys($R)as$X){if(!$X["db"]){$jd=$xa;if($Xf[$R][1]||$Xf[$X["table"]][1])$jd=min(floatval($Xf[$R][1]),floatval($Xf[$X["table"]][1]))-1;else$xa-=.1;while($ld[(string)$jd])$jd-=.0001;$qf[$R]["references"][$X["table"]][(string)$jd]=array($X["source"],$X["target"]);$ff[$X["table"]][$R][(string)$jd]=$X["target"];$ld[(string)$jd]=true;}}$sg=max($sg,$qf[$R]["pos"][0]+2.5+$Ie);}echo'<div id="schema" style="height: ',$sg,'em;">
<script',nonce(),'>
qs(\'#schema\').onselectstart = function () { return false; };
var tablePos = {',implode(",",$Yf)."\n",'};
var em = qs(\'#schema\').offsetHeight / ',$sg,';
document.onmousemove = schemaMousemove;
document.onmouseup = partialArg(schemaMouseup, \'',js_escape(DB),'\');
</script>
';foreach($qf
as$F=>$R){echo"<div class='table' style='top: ".$R["pos"][0]."em; left: ".$R["pos"][1]."em;'>",'<a href="'.h(ME).'table='.urlencode($F).'"><b>'.h($F)."</b></a>",script("qsl('div').onmousedown = schemaMousedown;");foreach($R["fields"]as$m){$X='<span'.type_class($m["type"]).' title="'.h($m["full_type"].($m["null"]?" NULL":'')).'">'.h($m["field"]).'</span>';echo"<br>".($m["primary"]?"<i>$X</i>":$X);}foreach((array)$R["references"]as$eg=>$gf){foreach($gf
as$jd=>$cf){$kd=$jd-$Xf[$F][1];$u=0;foreach($cf[0]as$Ff)echo"\n<div class='references' title='".h($eg)."' id='refs$jd-".($u++)."' style='left: $kd"."em; top: ".$R["fields"][$Ff]["pos"]."em; padding-top: .5em;'><div style='border-top: 1px solid Gray; width: ".(-$kd)."em;'></div></div>";}}foreach((array)$ff[$F]as$eg=>$gf){foreach($gf
as$jd=>$e){$kd=$jd-$Xf[$F][1];$u=0;foreach($e
as$dg)echo"\n<div class='references' title='".h($eg)."' id='refd$jd-".($u++)."' style='left: $kd"."em; top: ".$R["fields"][$dg]["pos"]."em; height: 1.25em; background: url(".h(preg_replace("~\\?.*~","",ME)."?file=arrow.gif) no-repeat right center;&version=4.8.1")."'><div style='height: .5em; border-bottom: 1px solid Gray; width: ".(-$kd)."em;'></div></div>";}}echo"\n</div>\n";}foreach($qf
as$F=>$R){foreach((array)$R["references"]as$eg=>$gf){foreach($gf
as$jd=>$cf){$Gd=$sg;$yd=-10;foreach($cf[0]as$z=>$Ff){$Je=$R["pos"][0]+$R["fields"][$Ff]["pos"];$Ke=$qf[$eg]["pos"][0]+$qf[$eg]["fields"][$cf[1][$z]]["pos"];$Gd=min($Gd,$Je,$Ke);$yd=max($yd,$Je,$Ke);}echo"<div class='references' id='refl$jd' style='left: $jd"."em; top: $Gd"."em; padding: .5em 0;'><div style='border-right: 1px solid Gray; margin-top: 1px; height: ".($yd-$Gd)."em;'></div></div>\n";}}}echo'</div>
<p class="links"><a href="',h(ME."schema=".urlencode($ca)),'" id="schema-link">Lien permanent</a>
';}elseif(isset($_GET["dump"])){$a=$_GET["dump"];if($_POST&&!$l){$bb="";foreach(array("output","format","db_style","routines","events","table_style","auto_increment","triggers","data_style")as$z)$bb.="&$z=".urlencode($_POST[$z]);cookie("adminer_export",substr($bb,1));$T=array_flip((array)$_POST["tables"])+array_flip((array)$_POST["data"]);$bc=dump_headers((count($T)==1?key($T):DB),(DB==""||count($T)>1));$Xc=preg_match('~sql~',$_POST["format"]);if($Xc){echo"-- Adminer $da ".$zb[DRIVER]." ".str_replace("\n"," ",$f->server_info)." dump\n\n";if($y=="sql"){echo"SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
".($_POST["data_style"]?"SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
":"")."
";$f->query("SET time_zone = '+00:00'");$f->query("SET sql_mode = ''");}}$Pf=$_POST["db_style"];$i=array(DB);if(DB==""){$i=$_POST["databases"];if(is_string($i))$i=explode("\n",rtrim(str_replace("\r","",$i),"\n"));}foreach((array)$i
as$j){$b->dumpDatabase($j);if($f->select_db($j)){if($Xc&&preg_match('~CREATE~',$Pf)&&($h=$f->result("SHOW CREATE DATABASE ".idf_escape($j),1))){set_utf8mb4($h);if($Pf=="DROP+CREATE")echo"DROP DATABASE IF EXISTS ".idf_escape($j).";\n";echo"$h;\n";}if($Xc){if($Pf)echo
use_sql($j).";\n\n";$pe="";if($_POST["routines"]){foreach(array("FUNCTION","PROCEDURE")as$nf){foreach(get_rows("SHOW $nf STATUS WHERE Db = ".q($j),null,"-- ")as$L){$h=remove_definer($f->result("SHOW CREATE $nf ".idf_escape($L["Name"]),2));set_utf8mb4($h);$pe.=($Pf!='DROP+CREATE'?"DROP $nf IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$h;;\n\n";}}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$L){$h=remove_definer($f->result("SHOW CREATE EVENT ".idf_escape($L["Name"]),3));set_utf8mb4($h);$pe.=($Pf!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($L["Name"]).";;\n":"")."$h;;\n\n";}}if($pe)echo"DELIMITER ;;\n\n$pe"."DELIMITER ;\n\n";}if($_POST["table_style"]||$_POST["data_style"]){$Zg=array();foreach(table_status('',true)as$F=>$S){$R=(DB==""||in_array($F,(array)$_POST["tables"]));$hb=(DB==""||in_array($F,(array)$_POST["data"]));if($R||$hb){if($bc=="tar"){$qg=new
TmpFile;ob_start(array($qg,'write'),1e5);}$b->dumpTable($F,($R?$_POST["table_style"]:""),(is_view($S)?2:0));if(is_view($S))$Zg[]=$F;elseif($hb){$n=fields($F);$b->dumpData($F,$_POST["data_style"],"SELECT *".convert_fields($n,$n)." FROM ".table($F));}if($Xc&&$_POST["triggers"]&&$R&&($Ag=trigger_sql($F)))echo"\nDELIMITER ;;\n$Ag\nDELIMITER ;\n";if($bc=="tar"){ob_end_flush();tar_file((DB!=""?"":"$j/")."$F.csv",$qg);}elseif($Xc)echo"\n";}}if(function_exists('foreign_keys_sql')){foreach(table_status('',true)as$F=>$S){$R=(DB==""||in_array($F,(array)$_POST["tables"]));if($R&&!is_view($S))echo
foreign_keys_sql($F);}}foreach($Zg
as$Yg)$b->dumpTable($Yg,$_POST["table_style"],1);if($bc=="tar")echo
pack("x512");}}}if($Xc)echo"-- ".$f->result("SELECT NOW()")."\n";exit;}page_header('Exporter',$l,($_GET["export"]!=""?array("table"=>$_GET["export"]):array()),h(DB));echo'
<form action="" method="post">
<table cellspacing="0" class="layout">
';$lb=array('','USE','DROP+CREATE','CREATE');$Zf=array('','DROP+CREATE','CREATE');$ib=array('','TRUNCATE+INSERT','INSERT');if($y=="sql")$ib[]='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>".'Sortie'."<td>".html_select("output",$b->dumpOutput(),$L["output"],0)."\n";echo"<tr><th>".'Format'."<td>".html_select("format",$b->dumpFormat(),$L["format"],0)."\n";echo($y=="sqlite"?"":"<tr><th>".'Base de données'."<td>".html_select('db_style',$lb,$L["db_style"]).(support("routine")?checkbox("routines",1,$L["routines"],'Routines'):"").(support("event")?checkbox("events",1,$L["events"],'Évènements'):"")),"<tr><th>".'Tables'."<td>".html_select('table_style',$Zf,$L["table_style"]).checkbox("auto_increment",1,$L["auto_increment"],'Incrément automatique').(support("trigger")?checkbox("triggers",1,$L["triggers"],'Déclencheurs'):""),"<tr><th>".'Données'."<td>".html_select('data_style',$ib,$L["data_style"]),'</table>
<p><input type="submit" value="Exporter">
<input type="hidden" name="token" value="',$U,'">
<table cellspacing="0">
',script("qsl('table').onclick = dumpClick;");$Ne=array();if(DB!=""){$Fa=($a!=""?"":" checked");echo"<thead><tr>","<th style='text-align: left;'><label class='block'><input type='checkbox' id='check-tables'$Fa>".'Tables'."</label>".script("qs('#check-tables').onclick = partial(formCheck, /^tables\\[/);",""),"<th style='text-align: right;'><label class='block'>".'Données'."<input type='checkbox' id='check-data'$Fa></label>".script("qs('#check-data').onclick = partial(formCheck, /^data\\[/);",""),"</thead>\n";$Zg="";$ag=tables_list();foreach($ag
as$F=>$V){$Me=preg_replace('~_.*~','',$F);$Fa=($a==""||$a==(substr($a,-1)=="%"?"$Me%":$F));$Qe="<tr><td>".checkbox("tables[]",$F,$Fa,$F,"","block");if($V!==null&&!preg_match('~table~i',$V))$Zg.="$Qe\n";else
echo"$Qe<td align='right'><label class='block'><span id='Rows-".h($F)."'></span>".checkbox("data[]",$F,$Fa)."</label>\n";$Ne[$Me]++;}echo$Zg;if($ag)echo
script("ajaxSetHtml('".js_escape(ME)."script=db');");}else{echo"<thead><tr><th style='text-align: left;'>","<label class='block'><input type='checkbox' id='check-databases'".($a==""?" checked":"").">".'Base de données'."</label>",script("qs('#check-databases').onclick = partial(formCheck, /^databases\\[/);",""),"</thead>\n";$i=$b->databases();if($i){foreach($i
as$j){if(!information_schema($j)){$Me=preg_replace('~_.*~','',$j);echo"<tr><td>".checkbox("databases[]",$j,$a==""||$a=="$Me%",$j,"","block")."\n";$Ne[$Me]++;}}}else
echo"<tr><td><textarea name='databases' rows='10' cols='20'></textarea>";}echo'</table>
</form>
';$lc=true;foreach($Ne
as$z=>$X){if($z!=""&&$X>1){echo($lc?"<p>":" ")."<a href='".h(ME)."dump=".urlencode("$z%")."'>".h($z)."</a>";$lc=false;}}}elseif(isset($_GET["sql"])){if(!$l&&$_POST["export"]){dump_headers("sql");$b->dumpTable("","");$b->dumpData("","table",$_POST["query"]);exit;}restart_session();$Gc=&get_session("queries");$Fc=&$Gc[DB];if(!$l&&$_POST["clear"]){$Fc=array();redirect(remove_from_uri("history"));}page_header((isset($_GET["import"])?'Importer':'Requête SQL'),$l);if(!$l&&$_POST){$r=false;if(!isset($_GET["import"]))$I=$_POST["query"];elseif($_POST["webfile"]){$If=$b->importServerPath();$r=@fopen((file_exists($If)?$If:"compress.zlib://$If.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(!$Fc||reset(end($Fc))!=$H){restart_session();$Fc[]=array($H,time());set_session("queries",$Gc);stop_session();}}$Gf="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|-- )[^\n]*\n?|--\r?\n)";$rb=";";$Sd=0;$Nb=true;$g=connect();if(is_object($g)&&DB!=""){$g->select_db(DB);if($_GET["ns"]!="")set_schema($_GET["ns"],$g);}$Sa=0;$Sb=array();$ve='[\'"'.($y=="sql"?'`#':($y=="sqlite"?'`[':($y=="mssql"?'[':''))).']|/\*|-- |$'.($y=="pgsql"?'|\$[^$]*\$':'');$tg=microtime(true);parse_str($_COOKIE["adminer_export"],$ia);$Eb=$b->dumpFormat();unset($Eb["sql"]);while($I!=""){if(!$Sd&&preg_match("~^$Gf*+DELIMITER\\s+(\\S+)~i",$I,$C)){$rb=$C[1];$I=substr($I,strlen($C[0]));}else{preg_match('('.preg_quote($rb)."\\s*|$ve)",$I,$C,PREG_OFFSET_CAPTURE,$Sd);list($rc,$Ie)=$C[0];if(!$rc&&$r&&!feof($r))$I.=fread($r,1e5);else{if(!$rc&&rtrim($I)=="")break;$Sd=$Ie+strlen($rc);if($rc&&rtrim($rc)!=$rb){while(preg_match('('.($rc=='/*'?'\*/':($rc=='['?']':(preg_match('~^-- |^#~',$rc)?"\n":preg_quote($rc)."|\\\\."))).'|$)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{$Nb=false;$H=substr($I,0,$Ie);$Sa++;$Qe="<pre id='sql-$Sa'><code class='jush-$y'>".$b->sqlCommandQuery($H)."</code></pre>\n";if($y=="sqlite"&&preg_match("~^$Gf*+ATTACH\\b~i",$H,$C)){echo$Qe,"<p class='error'>".'ATTACH queries are not supported.'."\n";$Sb[]=" <a href='#sql-$Sa'>$Sa</a>";if($_POST["error_stops"])break;}else{if(!$_POST["only_errors"]){echo$Qe;ob_flush();flush();}$Lf=microtime(true);if($f->multi_query($H)&&is_object($g)&&preg_match("~^$Gf*+USE\\b~i",$H))$g->query($H);do{$J=$f->store_result();if($f->error){echo($_POST["only_errors"]?$Qe:""),"<p class='error'>".'Erreur dans la requête'.($f->errno?" ($f->errno)":"").": ".error()."\n";$Sb[]=" <a href='#sql-$Sa'>$Sa</a>";if($_POST["error_stops"])break
2;}else{$jg=" <span class='time'>(".format_time($Lf).")</span>".(strlen($H)<1000?" <a href='".h(ME)."sql=".urlencode(trim($H))."'>".'Modifier'."</a>":"");$ka=$f->affected_rows;$ch=($_POST["only_errors"]?"":$k->warnings());$dh="warnings-$Sa";if($ch)$jg.=", <a href='#$dh'>".'Warnings'."</a>".script("qsl('a').onclick = partial(toggle, '$dh');","");$Zb=null;$ac="explain-$Sa";if(is_object($J)){$_=$_POST["limit"];$ie=select($J,$g,array(),$_);if(!$_POST["only_errors"]){echo"<form action='' method='post'>\n";$Pd=$J->num_rows;echo"<p>".($Pd?($_&&$Pd>$_?sprintf('%d / ',$_):"").lang(array('%d ligne','%d lignes'),$Pd):""),$jg;if($g&&preg_match("~^($Gf|\\()*+SELECT\\b~i",$H)&&($Zb=explain($g,$H)))echo", <a href='#$ac'>Explain</a>".script("qsl('a').onclick = partial(toggle, '$ac');","");$v="export-$Sa";echo", <a href='#$v'>".'Exporter'."</a>".script("qsl('a').onclick = partial(toggle, '$v');","")."<span id='$v' class='hidden'>: ".html_select("output",$b->dumpOutput(),$ia["output"])." ".html_select("format",$Eb,$ia["format"])."<input type='hidden' name='query' value='".h($H)."'>"." <input type='submit' name='export' value='".'Exporter'."'><input type='hidden' name='token' value='$U'></span>\n"."</form>\n";}}else{if(preg_match("~^$Gf*+(CREATE|DROP|ALTER)$Gf++(DATABASE|SCHEMA)\\b~i",$H)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"])echo"<p class='message' title='".h($f->info)."'>".lang(array('Requête exécutée avec succès, %d ligne modifiée.','Requête exécutée avec succès, %d lignes modifiées.'),$ka)."$jg\n";}echo($ch?"<div id='$dh' class='hidden'>\n$ch</div>\n":"");if($Zb){echo"<div id='$ac' class='hidden'>\n";select($Zb,$g,$ie);echo"</div>\n";}}$Lf=microtime(true);}while($f->next_result());}$I=substr($I,$Sd);$Sd=0;}}}}if($Nb)echo"<p class='message'>".'Aucune commande à exécuter.'."\n";elseif($_POST["only_errors"]){echo"<p class='message'>".lang(array('%d requête exécutée avec succès.','%d requêtes exécutées avec succès.'),$Sa-count($Sb))," <span class='time'>(".format_time($tg).")</span>\n";}elseif($Sb&&$Sa>1)echo"<p class='error'>".'Erreur dans la requête'.": ".implode("",$Sb)."\n";}else
echo"<p class='error'>".upload_error($I)."\n";}echo'
<form action="" method="post" enctype="multipart/form-data" id="form">
';$Xb="<input type='submit' value='".'Exécuter'."' title='Ctrl+Enter'>";if(!isset($_GET["import"])){$H=$_GET["sql"];if($_POST)$H=$_POST["query"];elseif($_GET["history"]=="all")$H=$Fc;elseif($_GET["history"]!="")$H=$Fc[$_GET["history"]][0];echo"<p>";textarea("query",$H,20);echo
script(($_POST?"":"qs('textarea').focus();\n")."qs('#form').onsubmit = partial(sqlSubmit, qs('#form'), '".js_escape(remove_from_uri("sql|limit|error_stops|only_errors|history"))."');"),"<p>$Xb\n",'Limiter les lignes'.": <input type='number' name='limit' class='size' value='".h($_POST?$_POST["limit"]:$_GET["limit"])."'>\n";}else{echo"<fieldset><legend>".'Importer un fichier'."</legend><div>";$zc=(extension_loaded("zlib")?"[.gz]":"");echo(ini_bool("file_uploads")?"SQL$zc (&lt; ".ini_get("upload_max_filesize")."B): <input type='file' name='sql_file[]' multiple>\n$Xb":'L\'importation de fichier est désactivée.'),"</div></fieldset>\n";$Mc=$b->importServerPath();if($Mc){echo"<fieldset><legend>".'Depuis le serveur'."</legend><div>",sprintf('Fichier %s du serveur Web',"<code>".h($Mc)."$zc</code>"),' <input type="submit" name="webfile" value="'.'Exécuter le fichier'.'">',"</div></fieldset>\n";}echo"<p>";}echo
checkbox("error_stops",1,($_POST?$_POST["error_stops"]:isset($_GET["import"])||$_GET["error_stops"]),'Arrêter en cas d\'erreur')."\n",checkbox("only_errors",1,($_POST?$_POST["only_errors"]:isset($_GET["import"])||$_GET["only_errors"]),'Montrer seulement les erreurs')."\n","<input type='hidden' name='token' value='$U'>\n";if(!isset($_GET["import"])&&$Fc){print_fieldset("history",'Historique',$_GET["history"]!="");for($X=end($Fc);$X;$X=prev($Fc)){$z=key($Fc);list($H,$jg,$Ib)=$X;echo'<a href="'.h(ME."sql=&history=$z").'">'.'Modifier'."</a>"." <span class='time' title='".@date('Y-m-d',$jg)."'>".@date("H:i:s",$jg)."</span>"." <code class='jush-$y'>".shorten_utf8(ltrim(str_replace("\n"," ",str_replace("\r","",preg_replace('~^(#|-- ).*~m','',$H)))),80,"</code>").($Ib?" <span class='time'>($Ib)</span>":"")."<br>\n";}echo"<input type='submit' name='clear' value='".'Effacer'."'>\n","<a href='".h(ME."sql=&history=all")."'>".'Tout modifier'."</a>\n","</div></fieldset>\n";}echo'</form>
';}elseif(isset($_GET["edit"])){$a=$_GET["edit"];$n=fields($a);$Z=(isset($_GET["select"])?($_POST["check"]&&count($_POST["check"])==1?where_check($_POST["check"][0],$n):""):where($_GET,$n));$Kg=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($n
as$F=>$m){if(!isset($m["privileges"][$Kg?"update":"insert"])||$b->fieldName($m)==""||$m["generated"])unset($n[$F]);}if($_POST&&!$l&&!isset($_GET["select"])){$B=$_POST["referer"];if($_POST["insert"])$B=($Kg?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$B))$B=ME."select=".urlencode($a);$x=indexes($a);$Fg=unique_array($_GET["where"],$x);$Ye="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($B,'L\'élément a été supprimé.',$k->delete($a,$Ye,!$Fg));else{$P=array();foreach($n
as$F=>$m){$X=process_input($m);if($X!==false&&$X!==null)$P[idf_escape($F)]=$X;}if($Kg){if(!$P)redirect($B);queries_redirect($B,'L\'élément a été modifié.',$k->update($a,$P,$Ye,!$Fg));if(is_ajax()){page_headers();page_messages($l);exit;}}else{$J=$k->insert($a,$P);$id=($J?last_id():0);queries_redirect($B,sprintf('L\'élément%s a été inséré.',($id?" $id":"")),$J);}}}$L=null;if($_POST["save"])$L=(array)$_POST["fields"];elseif($Z){$N=array();foreach($n
as$F=>$m){if(isset($m["privileges"]["select"])){$pa=convert_field($m);if($_POST["clone"]&&$m["auto_increment"])$pa="''";if($y=="sql"&&preg_match("~enum|set~",$m["type"]))$pa="1*".idf_escape($F);$N[]=($pa?"$pa AS ":"").idf_escape($F);}}$L=array();if(!support("table"))$N=array("*");if($N){$J=$k->select($a,$N,array($Z),$N,array(),(isset($_GET["select"])?2:1));if(!$J)$l=error();else{$L=$J->fetch_assoc();if(!$L)$L=false;}if(isset($_GET["select"])&&(!$L||$J->fetch_assoc()))$L=null;}}if(!support("table")&&!$n){if(!$Z){$J=$k->select($a,array("*"),$Z,array("*"));$L=($J?$J->fetch_assoc():false);if(!$L)$L=array($k->primary=>"");}if($L){foreach($L
as$z=>$X){if(!$Z)$L[$z]=null;$n[$z]=array("field"=>$z,"null"=>($z!=$k->primary),"auto_increment"=>($z==$k->primary));}}}edit_form($a,$n,$L,$Kg);}elseif(isset($_GET["create"])){$a=$_GET["create"];$we=array();foreach(array('HASH','LINEAR HASH','KEY','LINEAR KEY','RANGE','LIST')as$z)$we[$z]=$z;$ef=referencable_primary($a);$q=array();foreach($ef
as$Wf=>$m)$q[str_replace("`","``",$Wf)."`".str_replace("`","``",$m["field"])]=$Wf;$le=array();$S=array();if($a!=""){$le=fields($a);$S=table_status($a);if(!$S)$l='Aucune table.';}$L=$_POST;$L["fields"]=(array)$L["fields"];if($L["auto_increment_col"])$L["fields"][$L["auto_increment_col"]]["auto_increment"]=true;if($_POST)set_adminer_settings(array("comments"=>$_POST["comments"],"defaults"=>$_POST["defaults"]));if($_POST&&!process_fields($L["fields"])&&!$l){if($_POST["drop"])queries_redirect(substr(ME,0,-1),'La table a été effacée.',drop_tables(array($a)));else{$n=array();$na=array();$Og=false;$oc=array();$ke=reset($le);$ma=" FIRST";foreach($L["fields"]as$z=>$m){$p=$q[$m["type"]];$Bg=($p!==null?$ef[$p]:$m);if($m["field"]!=""){if(!$m["has_default"])$m["default"]=null;if($z==$L["auto_increment_col"])$m["auto_increment"]=true;$Ue=process_field($m,$Bg);$na[]=array($m["orig"],$Ue,$ma);if(!$ke||$Ue!=process_field($ke,$ke)){$n[]=array($m["orig"],$Ue,$ma);if($m["orig"]!=""||$ma)$Og=true;}if($p!==null)$oc[idf_escape($m["field"])]=($a!=""&&$y!="sqlite"?"ADD":" ").format_foreign_key(array('table'=>$q[$m["type"]],'source'=>array($m["field"]),'target'=>array($Bg["field"]),'on_delete'=>$m["on_delete"],));$ma=" AFTER ".idf_escape($m["field"]);}elseif($m["orig"]!=""){$Og=true;$n[]=array($m["orig"]);}if($m["orig"]!=""){$ke=next($le);if(!$ke)$ma="";}}$ye="";if($we[$L["partition_by"]]){$ze=array();if($L["partition_by"]=='RANGE'||$L["partition_by"]=='LIST'){foreach(array_filter($L["partition_names"])as$z=>$X){$Y=$L["partition_values"][$z];$ze[]="\n PARTITION ".idf_escape($X)." VALUES ".($L["partition_by"]=='RANGE'?"LESS THAN":"IN").($Y!=""?" ($Y)":" MAXVALUE");}}$ye.="\nPARTITION BY $L[partition_by]($L[partition])".($ze?" (".implode(",",$ze)."\n)":($L["partitions"]?" PARTITIONS ".(+$L["partitions"]):""));}elseif(support("partitioning")&&preg_match("~partitioned~",$S["Create_options"]))$ye.="\nREMOVE PARTITIONING";$D='La table a été modifiée.';if($a==""){cookie("adminer_engine",$L["Engine"]);$D='La table a été créée.';}$F=trim($L["name"]);queries_redirect(ME.(support("table")?"table=":"select=").urlencode($F),$D,alter_table($a,$F,($y=="sqlite"&&($Og||$oc)?$na:$n),$oc,($L["Comment"]!=$S["Comment"]?$L["Comment"]:null),($L["Engine"]&&$L["Engine"]!=$S["Engine"]?$L["Engine"]:""),($L["Collation"]&&$L["Collation"]!=$S["Collation"]?$L["Collation"]:""),($L["Auto_increment"]!=""?number($L["Auto_increment"]):""),$ye));}}page_header(($a!=""?'Modifier la table':'Créer une table'),$l,array("table"=>$a),h($a));if(!$_POST){$L=array("Engine"=>$_COOKIE["adminer_engine"],"fields"=>array(array("field"=>"","type"=>(isset($Cg["int"])?"int":(isset($Cg["integer"])?"integer":"")),"on_update"=>"")),"partition_names"=>array(""),);if($a!=""){$L=$S;$L["name"]=$a;$L["fields"]=array();if(!$_GET["auto_increment"])$L["Auto_increment"]="";foreach($le
as$m){$m["has_default"]=isset($m["default"]);$L["fields"][]=$m;}if(support("partitioning")){$tc="FROM information_schema.PARTITIONS WHERE TABLE_SCHEMA = ".q(DB)." AND TABLE_NAME = ".q($a);$J=$f->query("SELECT PARTITION_METHOD, PARTITION_ORDINAL_POSITION, PARTITION_EXPRESSION $tc ORDER BY PARTITION_ORDINAL_POSITION DESC LIMIT 1");list($L["partition_by"],$L["partitions"],$L["partition"])=$J->fetch_row();$ze=get_key_vals("SELECT PARTITION_NAME, PARTITION_DESCRIPTION $tc AND PARTITION_NAME != '' ORDER BY PARTITION_ORDINAL_POSITION");$ze[""]="";$L["partition_names"]=array_keys($ze);$L["partition_values"]=array_values($ze);}}}$Pa=collations();$Pb=engines();foreach($Pb
as$Ob){if(!strcasecmp($Ob,$L["Engine"])){$L["Engine"]=$Ob;break;}}echo'
<form action="" method="post" id="form">
<p>
';if(support("columns")||$a==""){echo'Nom de la table: <input name="name" data-maxlength="64" value="',h($L["name"]),'" autocapitalize="off">
';if($a==""&&!$_POST)echo
script("focus(qs('#form')['name']);");echo($Pb?"<select name='Engine'>".optionlist(array(""=>"(".'moteur'.")")+$Pb,$L["Engine"])."</select>".on_help("getTarget(event).value",1).script("qsl('select').onchange = helpClose;"):""),' ',($Pa&&!preg_match("~sqlite|mssql~",$y)?html_select("Collation",array(""=>"(".'interclassement'.")")+$Pa,$L["Collation"]):""),' <input type="submit" value="Enregistrer">
';}echo'
';if(support("columns")){echo'<div class="scrollable">
<table cellspacing="0" id="edit-fields" class="nowrap">
';edit_fields($L["fields"],$Pa,"TABLE",$q);echo'</table>
',script("editFields();"),'</div>
<p>
Incrément automatique: <input type="number" name="Auto_increment" size="6" value="',h($L["Auto_increment"]),'">
',checkbox("defaults",1,($_POST?$_POST["defaults"]:adminer_setting("defaults")),'Valeurs par défaut',"columnShow(this.checked, 5)","jsonly"),(support("comment")?checkbox("comments",1,($_POST?$_POST["comments"]:adminer_setting("comments")),'Commentaire',"editingCommentsClick(this, true);","jsonly").' <input name="Comment" value="'.h($L["Comment"]).'" data-maxlength="'.(min_version(5.5)?2048:60).'">':''),'<p>
<input type="submit" value="Enregistrer">
';}echo'
';if($a!=""){echo'<input type="submit" name="drop" value="Supprimer">',confirm(sprintf('Drop %s?',$a));}if(support("partitioning")){$xe=preg_match('~RANGE|LIST~',$L["partition_by"]);print_fieldset("partition",'Partitionner par',$L["partition_by"]);echo'<p>
',"<select name='partition_by'>".optionlist(array(""=>"")+$we,$L["partition_by"])."</select>".on_help("getTarget(event).value.replace(/./, 'PARTITION BY \$&')",1).script("qsl('select').onchange = partitionByChange;"),'(<input name="partition" value="',h($L["partition"]),'">)
Partitions: <input type="number" name="partitions" class="size',($xe||!$L["partition_by"]?" hidden":""),'" value="',h($L["partitions"]),'">
<table cellspacing="0" id="partition-table"',($xe?"":" class='hidden'"),'>
<thead><tr><th>Nom de la partition<th>Valeurs</thead>
';foreach($L["partition_names"]as$z=>$X){echo'<tr>','<td><input name="partition_names[]" value="'.h($X).'" autocapitalize="off">',($z==count($L["partition_names"])-1?script("qsl('input').oninput = partitionNameChange;"):''),'<td><input name="partition_values[]" value="'.h($L["partition_values"][$z]).'">';}echo'</table>
</div></fieldset>
';}echo'<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["indexes"])){$a=$_GET["indexes"];$Oc=array("PRIMARY","UNIQUE","INDEX");$S=table_status($a,true);if(preg_match('~MyISAM|M?aria'.(min_version(5.6,'10.0.5')?'|InnoDB':'').'~i',$S["Engine"]))$Oc[]="FULLTEXT";if(preg_match('~MyISAM|M?aria'.(min_version(5.7,'10.2.2')?'|InnoDB':'').'~i',$S["Engine"]))$Oc[]="SPATIAL";$x=indexes($a);$Oe=array();if($y=="mongo"){$Oe=$x["_id_"];unset($Oc[0]);unset($x["_id_"]);}$L=$_POST;if($_POST&&!$l&&!$_POST["add"]&&!$_POST["drop_col"]){$oa=array();foreach($L["indexes"]as$w){$F=$w["name"];if(in_array($w["type"],$Oc)){$e=array();$od=array();$tb=array();$P=array();ksort($w["columns"]);foreach($w["columns"]as$z=>$d){if($d!=""){$nd=$w["lengths"][$z];$sb=$w["descs"][$z];$P[]=idf_escape($d).($nd?"(".(+$nd).")":"").($sb?" DESC":"");$e[]=$d;$od[]=($nd?$nd:null);$tb[]=$sb;}}if($e){$Yb=$x[$F];if($Yb){ksort($Yb["columns"]);ksort($Yb["lengths"]);ksort($Yb["descs"]);if($w["type"]==$Yb["type"]&&array_values($Yb["columns"])===$e&&(!$Yb["lengths"]||array_values($Yb["lengths"])===$od)&&array_values($Yb["descs"])===$tb){unset($x[$F]);continue;}}$oa[]=array($w["type"],$F,$P);}}}foreach($x
as$F=>$Yb)$oa[]=array($Yb["type"],$F,"DROP");if(!$oa)redirect(ME."table=".urlencode($a));queries_redirect(ME."table=".urlencode($a),'Index modifiés.',alter_indexes($a,$oa));}page_header('Index',$l,array("table"=>$a),h($a));$n=array_keys(fields($a));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">
<div class="scrollable">
<table cellspacing="0" class="nowrap">
<thead><tr>
<th id="label-type">Type d\'index
<th><input type="submit" class="wayoff">Colonne (longueur)
<th id="label-name">Nom
<th><noscript>',"<input type='image' class='icon' name='add[0]' src='".h(preg_replace("~\\?.*~","",ME)."?file=plus.gif&version=4.8.1")."' alt='+' title='".'Ajouter le prochain'."'>",'</noscript>
</thead>
';if($Oe){echo"<tr><td>PRIMARY<td>";foreach($Oe["columns"]as$z=>$d){echo
select_input(" disabled",$n,$d),"<label><input disabled type='checkbox'>".'décroissant'."</label> ";}echo"<td><td>\n";}$Zc=1;foreach($L["indexes"]as$w){if(!$_POST["drop_col"]||$Zc!=key($_POST["drop_col"])){echo"<tr><td>".html_select("indexes[$Zc][type]",array(-1=>"")+$Oc,$w["type"],($Zc==count($L["indexes"])?"indexesAddRow.call(this);":1),"label-type"),"<td>";ksort($w["columns"]);$u=1;foreach($w["columns"]as$z=>$d){echo"<span>".select_input(" name='indexes[$Zc][columns][$u]' title='".'Colonne'."'",($n?array_combine($n,$n):$n),$d,"partial(".($u==count($w["columns"])?"indexesAddColumn":"indexesChangeColumn").", '".js_escape($y=="sql"?"":$_GET["indexes"]."_")."')"),($y=="sql"||$y=="mssql"?"<input type='number' name='indexes[$Zc][lengths][$u]' class='size' value='".h($w["lengths"][$z])."' title='".'Longueur'."'>":""),(support("descidx")?checkbox("indexes[$Zc][descs][$u]",1,$w["descs"][$z],'décroissant'):"")," </span>";$u++;}echo"<td><input name='indexes[$Zc][name]' value='".h($w["name"])."' autocapitalize='off' aria-labelledby='label-name'>\n","<td><input type='image' class='icon' name='drop_col[$Zc]' src='".h(preg_replace("~\\?.*~","",ME)."?file=cross.gif&version=4.8.1")."' alt='x' title='".'Effacer'."'>".script("qsl('input').onclick = partial(editingRemoveRow, 'indexes\$1[type]');");}$Zc++;}echo'</table>
</div>
<p>
<input type="submit" value="Enregistrer">
<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["database"])){$L=$_POST;if($_POST&&!$l&&!isset($_POST["add_x"])){$F=trim($L["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),'La base de données a été supprimée.',drop_databases(array(DB)));}elseif(DB!==$F){if(DB!=""){$_GET["db"]=$F;queries_redirect(preg_replace('~\bdb=[^&]*&~','',ME)."db=".urlencode($F),'La base de données a été renommée.',rename_database($F,$L["collation"]));}else{$i=explode("\n",str_replace("\r","",$F));$Qf=true;$hd="";foreach($i
as$j){if(count($i)==1||$j!=""){if(!create_database($j,$L["collation"]))$Qf=false;$hd=$j;}}restart_session();set_session("dbs",null);queries_redirect(ME."db=".urlencode($hd),'La base de données a été créée.',$Qf);}}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),'La base de données a été modifiée.');}}page_header(DB!=""?'Modifier la base de données':'Créer une base de données',$l,array(),h(DB));$Pa=collations();$F=DB;if($_POST)$F=$L["name"];elseif(DB!="")$L["collation"]=db_collation(DB,$Pa);elseif($y=="sql"){foreach(get_vals("SHOW GRANTS")as$vc){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\.\*)?~',$vc,$C)&&$C[1]){$F=stripcslashes(idf_unescape("`$C[2]`"));break;}}}echo'
<form action="" method="post">
<p>
',($_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).'" data-maxlength="64" autocapitalize="off">')."\n".($Pa?html_select("collation",array(""=>"(".'interclassement'.")")+$Pa,$L["collation"]).'':""),script("focus(qs('#name'));"),'<input type="submit" value="Enregistrer">
';if(DB!="")echo"<input type='submit' name='drop' value='".'Supprimer'."'>".confirm(sprintf('Drop %s?',DB))."\n";elseif(!$_POST["add_x"]&&$_GET["db"]=="")echo"<input type='image' class='icon' name='add' src='".h(preg_replace("~\\?.*~","",ME)."?file=plus.gif&version=4.8.1")."' alt='+' title='".'Ajouter le prochain'."'>\n";echo'<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["foreign"])){$a=$_GET["foreign"];$F=$_GET["name"];$L=$_POST;if($_POST&&!$l&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){$D=($_POST["drop"]?'La clé étrangère a été effacée.':($F!=""?'La clé étrangère a été modifiée.':'La clé étrangère a été créée.'));$B=ME."table=".urlencode($a);if(!$_POST["drop"]){$L["source"]=array_filter($L["source"],'strlen');ksort($L["source"]);$dg=array();foreach($L["source"]as$z=>$X)$dg[$z]=$L["target"][$z];$L["target"]=$dg;}if($y=="sqlite")queries_redirect($B,$D,recreate_table($a,$a,array(),array(),array(" $F"=>($_POST["drop"]?"":" ".format_foreign_key($L)))));else{$oa="ALTER TABLE ".table($a);$_b="\nDROP ".($y=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($F);if($_POST["drop"])query_redirect($oa.$_b,$B,$D);else{query_redirect($oa.($F!=""?"$_b,":"")."\nADD".format_foreign_key($L),$B,$D);$l='Les colonnes de source et de destination doivent être du même type, il doit y avoir un index sur les colonnes de destination et les données référencées doivent exister.'."<br>$l";}}}page_header('Clé étrangère',$l,array("table"=>$a),h($a));if($_POST){ksort($L["source"]);if($_POST["add"])$L["source"][]="";elseif($_POST["change"]||$_POST["change-js"])$L["target"]=array();}elseif($F!=""){$q=foreign_keys($a);$L=$q[$F];$L["source"][]="";}else{$L["table"]=$a;$L["source"]=array("");}echo'
<form action="" method="post">
';$Ff=array_keys(fields($a));if($L["db"]!="")$f->select_db($L["db"]);if($L["ns"]!="")set_schema($L["ns"]);$df=array_keys(array_filter(table_status('',true),'fk_support'));$dg=array_keys(fields(in_array($L["table"],$df)?$L["table"]:reset($df)));$Xd="this.form['change-js'].value = '1'; this.form.submit();";echo"<p>".'Table visée'.": ".html_select("table",$df,$L["table"],$Xd)."\n";if($y=="pgsql")echo'Schéma'.": ".html_select("ns",$b->schemas(),$L["ns"]!=""?$L["ns"]:$_GET["ns"],$Xd);elseif($y!="sqlite"){$mb=array();foreach($b->databases()as$j){if(!information_schema($j))$mb[]=$j;}echo'DB'.": ".html_select("db",$mb,$L["db"]!=""?$L["db"]:$_GET["db"],$Xd);}echo'<input type="hidden" name="change-js" value="">
<noscript><p><input type="submit" name="change" value="Modifier"></noscript>
<table cellspacing="0">
<thead><tr><th id="label-source">Source<th id="label-target">Cible</thead>
';$Zc=0;foreach($L["source"]as$z=>$X){echo"<tr>","<td>".html_select("source[".(+$z)."]",array(-1=>"")+$Ff,$X,($Zc==count($L["source"])-1?"foreignAddRow.call(this);":1),"label-source"),"<td>".html_select("target[".(+$z)."]",$dg,$L["target"][$z],1,"label-target");$Zc++;}echo'</table>
<p>
ON DELETE: ',html_select("on_delete",array(-1=>"")+explode("|",$Wd),$L["on_delete"]),' ON UPDATE: ',html_select("on_update",array(-1=>"")+explode("|",$Wd),$L["on_update"]),'','<p>
<input type="submit" value="Enregistrer">
<noscript><p><input type="submit" name="add" value="Ajouter une colonne"></noscript>
';if($F!=""){echo'<input type="submit" name="drop" value="Supprimer">',confirm(sprintf('Drop %s?',$F));}echo'<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["view"])){$a=$_GET["view"];$L=$_POST;$me="VIEW";if($y=="pgsql"&&$a!=""){$Mf=table_status($a);$me=strtoupper($Mf["Engine"]);}if($_POST&&!$l){$F=trim($L["name"]);$pa=" AS\n$L[select]";$B=ME."table=".urlencode($F);$D='La vue a été modifiée.';$V=($_POST["materialized"]?"MATERIALIZED VIEW":"VIEW");if(!$_POST["drop"]&&$a==$F&&$y!="sqlite"&&$V=="VIEW"&&$me=="VIEW")query_redirect(($y=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($F).$pa,$B,$D);else{$fg=$F."_adminer_".uniqid();drop_create("DROP $me ".table($a),"CREATE $V ".table($F).$pa,"DROP $V ".table($F),"CREATE $V ".table($fg).$pa,"DROP $V ".table($fg),($_POST["drop"]?substr(ME,0,-1):$B),'La vue a été effacée.',$D,'La vue a été créée.',$a,$F);}}if(!$_POST&&$a!=""){$L=view($a);$L["name"]=$a;$L["materialized"]=($me!="VIEW");if(!$l)$l=error();}page_header(($a!=""?'Modifier une vue':'Créer une vue'),$l,array("table"=>$a),h($a));echo'
<form action="" method="post">
<p>Nom: <input name="name" value="',h($L["name"]),'" data-maxlength="64" autocapitalize="off">
',(support("materializedview")?" ".checkbox("materialized",1,$L["materialized"],'Vue matérialisée'):""),'<p>';textarea("select",$L["select"]);echo'<p>
<input type="submit" value="Enregistrer">
';if($a!=""){echo'<input type="submit" name="drop" value="Supprimer">',confirm(sprintf('Drop %s?',$a));}echo'<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["trigger"])){$a=$_GET["trigger"];$F=$_GET["name"];$_g=trigger_options();$L=(array)trigger($F,$a)+array("Trigger"=>$a."_bi");if($_POST){if(!$l&&in_array($_POST["Timing"],$_g["Timing"])&&in_array($_POST["Event"],$_g["Event"])&&in_array($_POST["Type"],$_g["Type"])){$Vd=" ON ".table($a);$_b="DROP TRIGGER ".idf_escape($F).($y=="pgsql"?$Vd:"");$B=ME."table=".urlencode($a);if($_POST["drop"])query_redirect($_b,$B,'Le déclencheur a été supprimé.');else{if($F!="")queries($_b);queries_redirect($B,($F!=""?'Le déclencheur a été modifié.':'Le déclencheur a été créé.'),queries(create_trigger($Vd,$_POST)));if($F!="")queries(create_trigger($Vd,$L+array("Type"=>reset($_g["Type"]))));}}$L=$_POST;}page_header(($F!=""?'Modifier un déclencheur'.": ".h($F):'Ajouter un déclencheur'),$l,array("table"=>$a));echo'
<form action="" method="post" id="form">
<table cellspacing="0" class="layout">
<tr><th>Temps<td>',html_select("Timing",$_g["Timing"],$L["Timing"],"triggerChange(/^".preg_quote($a,"/")."_[ba][iud]$/, '".js_escape($a)."', this.form);"),'<tr><th>Évènement<td>',html_select("Event",$_g["Event"],$L["Event"],"this.form['Timing'].onchange();"),(in_array("UPDATE OF",$_g["Event"])?" <input name='Of' value='".h($L["Of"])."' class='hidden'>":""),'<tr><th>Type<td>',html_select("Type",$_g["Type"],$L["Type"]),'</table>
<p>Nom: <input name="Trigger" value="',h($L["Trigger"]),'" data-maxlength="64" autocapitalize="off">
',script("qs('#form')['Timing'].onchange();"),'<p>';textarea("Statement",$L["Statement"]);echo'<p>
<input type="submit" value="Enregistrer">
';if($F!=""){echo'<input type="submit" name="drop" value="Supprimer">',confirm(sprintf('Drop %s?',$F));}echo'<input type="hidden" name="token" value="',$U,'">
</form>
';}elseif(isset($_GET["select"])){$a=$_GET["select"];$S=table_status1($a);$x=indexes($a);$n=fields($a);$q=column_foreign_keys($a);$Td=$S["Oid"];parse_str($_COOKIE["adminer_import"],$ja);$lf=array();$e=array();$ig=null;foreach($n
as$z=>$m){$F=$b->fieldName($m);if(isset($m["privileges"]["select"])&&$F!=""){$e[$z]=html_entity_decode(strip_tags($F),ENT_QUOTES);if(is_shortable($m))$ig=$b->selectLengthProcess();}$lf+=$m["privileges"];}list($N,$t)=$b->selectColumnsProcess($e,$x);$Wc=count($t)<count($N);$Z=$b->selectSearchProcess($n,$x);$fe=$b->selectOrderProcess($n,$x);$_=$b->selectLimitProcess();if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$Gg=>$L){$pa=convert_field($n[key($L)]);$N=array($pa?$pa:idf_escape(key($L)));$Z[]=where_check($Gg,$n);$K=$k->select($a,$N,$Z,$N);if($K)echo
reset($K->fetch_row());}exit;}$Oe=$Ig=null;foreach($x
as$w){if($w["type"]=="PRIMARY"){$Oe=array_flip($w["columns"]);$Ig=($N?$Oe:array());foreach($Ig
as$z=>$X){if(in_array(idf_escape($z),$N))unset($Ig[$z]);}break;}}if($Td&&!$Oe){$Oe=$Ig=array($Td=>0);$x[]=array("type"=>"PRIMARY","columns"=>array($Td));}if($_POST&&!$l){$fh=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$Ga=array();foreach($_POST["check"]as$Ea)$Ga[]=where_check($Ea,$n);$fh[]="((".implode(") OR (",$Ga)."))";}$fh=($fh?"\nWHERE ".implode(" AND ",$fh):"");if($_POST["export"]){cookie("adminer_import","output=".urlencode($_POST["output"])."&format=".urlencode($_POST["format"]));dump_headers($a);$b->dumpTable($a,"");$tc=($N?implode(", ",$N):"*").convert_fields($e,$n,$N)."\nFROM ".table($a);$xc=($t&&$Wc?"\nGROUP BY ".implode(", ",$t):"").($fe?"\nORDER BY ".implode(", ",$fe):"");if(!is_array($_POST["check"])||$Oe)$I="SELECT $tc$fh$xc";else{$Eg=array();foreach($_POST["check"]as$X)$Eg[]="(SELECT".limit($tc,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$n).$xc,1).")";$I=implode(" UNION ALL ",$Eg);}$b->dumpData($a,"table",$I);exit;}if(!$b->selectEmailProcess($Z,$q)){if($_POST["save"]||$_POST["delete"]){$J=true;$ka=0;$P=array();if(!$_POST["delete"]){foreach($e
as$F=>$X){$X=process_input($n[$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($a)." (".implode(", ",array_keys($P)).")\nSELECT ".implode(", ",$P)."\nFROM ".table($a);if($_POST["all"]||($Oe&&is_array($_POST["check"]))||$Wc){$J=($_POST["delete"]?$k->delete($a,$fh):($_POST["clone"]?queries("INSERT $I$fh"):$k->update($a,$P,$fh)));$ka=$f->affected_rows;}else{foreach((array)$_POST["check"]as$X){$eh="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($X,$n);$J=($_POST["delete"]?$k->delete($a,$eh,1):($_POST["clone"]?queries("INSERT".limit1($a,$I,$eh)):$k->update($a,$P,$eh,1)));if(!$J)break;$ka+=$f->affected_rows;}}}$D=lang(array('%d élément a été modifié.','%d éléments ont été modifiés.'),$ka);if($_POST["clone"]&&$J&&$ka==1){$id=last_id();if($id)$D=sprintf('L\'élément%s a été inséré.'," $id");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$D,$J);if(!$_POST["delete"]){edit_form($a,$n,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])$l='Ctrl+cliquez sur une valeur pour la modifier.';else{$J=true;$ka=0;foreach($_POST["val"]as$Gg=>$L){$P=array();foreach($L
as$z=>$X){$z=bracket_escape($z,1);$P[idf_escape($z)]=(preg_match('~char|text~',$n[$z]["type"])||$X!=""?$b->processInput($n[$z],$X):"NULL");}$J=$k->update($a,$P," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($Gg,$n),!$Wc&&!$Oe," ");if(!$J)break;$ka+=$f->affected_rows;}queries_redirect(remove_from_uri(),lang(array('%d élément a été modifié.','%d éléments ont été modifiés.'),$ka),$J);}}elseif(!is_string($jc=get_file("csv_file",true)))$l=upload_error($jc);elseif(!preg_match('~~u',$jc))$l='Les fichiers doivent être encodés en UTF-8.';else{cookie("adminer_import","output=".urlencode($ja["output"])."&format=".urlencode($_POST["separator"]));$J=true;$Qa=array_keys($n);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$jc,$ud);$ka=count($ud[0]);$k->begin();$xf=($_POST["separator"]=="csv"?",":($_POST["separator"]=="tsv"?"\t":";"));$M=array();foreach($ud[0]as$z=>$X){preg_match_all("~((?>\"[^\"]*\")+|[^$xf]*)$xf~",$X.$xf,$vd);if(!$z&&!array_diff($vd[1],$Qa)){$Qa=$vd[1];$ka--;}else{$P=array();foreach($vd[1]as$u=>$Ma)$P[idf_escape($Qa[$u])]=($Ma==""&&$n[$Qa[$u]]["null"]?"NULL":q(str_replace('""','"',preg_replace('~^"|"$~','',$Ma))));$M[]=$P;}}$J=(!$M||$k->insertUpdate($a,$M,$Oe));if($J)$J=$k->commit();queries_redirect(remove_from_uri("page"),lang(array('%d ligne a été importée.','%d lignes ont été importées.'),$ka),$J);$k->rollback();}}}$Wf=$b->tableName($S);if(is_ajax()){page_headers();ob_start();}else
page_header('Sélectionner'.": $Wf",$l);$P=null;if(isset($lf["insert"])||!support("table")){$P="";foreach((array)$_GET["where"]as$X){if($q[$X["col"]]&&count($q[$X["col"]])==1&&($X["op"]=="="||(!$X["op"]&&!preg_match('~[_%]~',$X["val"]))))$P.="&set".urlencode("[".bracket_escape($X["col"])."]")."=".urlencode($X["val"]);}}$b->selectLinks($S,$P);if(!$e&&support("table"))echo"<p class='error'>".'Impossible de sélectionner la table'.($n?".":": ".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($a).'">',"</div>\n";$b->selectColumnsPrint($N,$e);$b->selectSearchPrint($Z,$e,$x);$b->selectOrderPrint($fe,$e,$x);$b->selectLimitPrint($_);$b->selectLengthPrint($ig);$b->selectActionPrint($x);echo"</form>\n";$G=$_GET["page"];if($G=="last"){$sc=$f->result(count_rows($a,$Z,$Wc,$t));$G=floor(max(0,$sc-1)/$_);}$sf=$N;$wc=$t;if(!$sf){$sf[]="*";$ab=convert_fields($e,$n,$N);if($ab)$sf[]=substr($ab,2);}foreach($N
as$z=>$X){$m=$n[idf_unescape($X)];if($m&&($pa=convert_field($m)))$sf[$z]="$pa AS $X";}if(!$Wc&&$Ig){foreach($Ig
as$z=>$X){$sf[]=idf_escape($z);if($wc)$wc[]=idf_escape($z);}}$J=$k->select($a,$sf,$Z,$wc,$fe,$_,$G,true);if(!$J)echo"<p class='error'>".error()."\n";else{if($y=="mssql"&&$G)$J->seek($_*$G);$Mb=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"&&$_!=""&&$t&&$Wc&&$y=="sql")$sc=$f->result(" SELECT FOUND_ROWS()");if(!$M)echo"<p class='message'>".'Aucun résultat.'."\n";else{$wa=$b->backwardKeys($a,$Wf);echo"<div class='scrollable'>","<table id='table' cellspacing='0' class='nowrap checkable'>",script("mixin(qs('#table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true), onkeydown: editingKeydown});"),"<thead><tr>".(!$t&&$N?"":"<td><input type='checkbox' id='all-page' class='jsonly'>".script("qs('#all-page').onclick = partial(formCheck, /check/);","")." <a href='".h($_GET["modify"]?remove_from_uri("modify"):$_SERVER["REQUEST_URI"]."&modify=1")."'>".'Modification'."</a>");$Kd=array();$uc=array();reset($N);$af=1;foreach($M[0]as$z=>$X){if(!isset($Ig[$z])){$X=$_GET["columns"][key($N)];$m=$n[$N?($X?$X["col"]:current($N)):$z];$F=($m?$b->fieldName($m,$af):($X["fun"]?"*":$z));if($F!=""){$af++;$Kd[$z]=$F;$d=idf_escape($z);$Ic=remove_from_uri('(order|desc)[^=]*|page').'&order%5B0%5D='.urlencode($z);$sb="&desc%5B0%5D=1";echo"<th id='th[".h(bracket_escape($z))."]'>".script("mixin(qsl('th'), {onmouseover: partial(columnMouse), onmouseout: partial(columnMouse, ' hidden')});",""),'<a href="'.h($Ic.($fe[0]==$d||$fe[0]==$z||(!$fe&&$Wc&&$t[0]==$d)?$sb:'')).'">';echo
apply_sql_function($X["fun"],$F)."</a>";echo"<span class='column hidden'>","<a href='".h($Ic.$sb)."' title='".'décroissant'."' class='text'> ↓</a>";if(!$X["fun"]){echo'<a href="#fieldset-search" title="'.'Rechercher'.'" class="text jsonly"> =</a>',script("qsl('a').onclick = partial(selectSearch, '".js_escape($z)."');");}echo"</span>";}$uc[$z]=$X["fun"];next($N);}}$od=array();if($_GET["modify"]){foreach($M
as$L){foreach($L
as$z=>$X)$od[$z]=max($od[$z],min(40,strlen(utf8_decode($X))));}}echo($wa?"<th>".'Relations':"")."</thead>\n";if(is_ajax()){if($_%2==1&&$G%2==1)odd();ob_end_clean();}foreach($b->rowDescriptions($M,$q)as$E=>$L){$Fg=unique_array($M[$E],$x);if(!$Fg){$Fg=array();foreach($M[$E]as$z=>$X){if(!preg_match('~^(COUNT\((\*|(DISTINCT )?`(?:[^`]|``)+`)\)|(AVG|GROUP_CONCAT|MAX|MIN|SUM)\(`(?:[^`]|``)+`\))$~',$z))$Fg[$z]=$X;}}$Gg="";foreach($Fg
as$z=>$X){if(($y=="sql"||$y=="pgsql")&&preg_match('~char|text|enum|set~',$n[$z]["type"])&&strlen($X)>64){$z=(strpos($z,'(')?$z:idf_escape($z));$z="MD5(".($y!='sql'||preg_match("~^utf8~",$n[$z]["collation"])?$z:"CONVERT($z USING ".charset($f).")").")";$X=md5($X);}$Gg.="&".($X!==null?urlencode("where[".bracket_escape($z)."]")."=".urlencode($X):"null%5B%5D=".urlencode($z));}echo"<tr".odd().">".(!$t&&$N?"":"<td>".checkbox("check[]",substr($Gg,1),in_array(substr($Gg,1),(array)$_POST["check"])).($Wc||information_schema(DB)?"":" <a href='".h(ME."edit=".urlencode($a).$Gg)."' class='edit'>".'modifier'."</a>"));foreach($L
as$z=>$X){if(isset($Kd[$z])){$m=$n[$z];$X=$k->value($X,$m);if($X!=""&&(!isset($Mb[$z])||$Mb[$z]!=""))$Mb[$z]=(is_mail($X)?$Kd[$z]:"");$A="";if(preg_match('~blob|bytea|raw|file~',$m["type"])&&$X!="")$A=ME.'download='.urlencode($a).'&field='.urlencode($z).$Gg;if(!$A&&$X!==null){foreach((array)$q[$z]as$p){if(count($q[$z])==1||end($p["source"])==$z){$A="";foreach($p["source"]as$u=>$Ff)$A.=where_link($u,$p["target"][$u],$M[$E][$Ff]);$A=($p["db"]!=""?preg_replace('~([?&]db=)[^&]+~','\1'.urlencode($p["db"]),ME):ME).'select='.urlencode($p["table"]).$A;if($p["ns"])$A=preg_replace('~([?&]ns=)[^&]+~','\1'.urlencode($p["ns"]),$A);if(count($p["source"])==1)break;}}}if($z=="COUNT(*)"){$A=ME."select=".urlencode($a);$u=0;foreach((array)$_GET["where"]as$W){if(!array_key_exists($W["col"],$Fg))$A.=where_link($u++,$W["col"],$W["val"],$W["op"]);}foreach($Fg
as$ad=>$W)$A.=where_link($u++,$ad,$W);}$X=select_value($X,$A,$m,$ig);$v=h("val[$Gg][".bracket_escape($z)."]");$Y=$_POST["val"][$Gg][bracket_escape($z)];$Hb=!is_array($L[$z])&&is_utf8($X)&&$M[$E][$z]==$L[$z]&&!$uc[$z];$hg=preg_match('~text|lob~',$m["type"]);echo"<td id='$v'";if(($_GET["modify"]&&$Hb)||$Y!==null){$_c=h($Y!==null?$Y:$L[$z]);echo">".($hg?"<textarea name='$v' cols='30' rows='".(substr_count($L[$z],"\n")+1)."'>$_c</textarea>":"<input name='$v' value='$_c' size='$od[$z]'>");}else{$sd=strpos($X,"<i>…</i>");echo" data-text='".($sd?2:($hg?1:0))."'".($Hb?"":" data-warning='".h('Utilisez le lien "modifier" pour modifier cette valeur.')."'").">$X</td>";}}}if($wa)echo"<td>";$b->backwardKeysPrint($wa,$M[$E]);echo"</tr>\n";}if(is_ajax())exit;echo"</table>\n","</div>\n";}if(!is_ajax()){if($M||$G){$Wb=true;if($_GET["page"]!="last"){if($_==""||(count($M)<$_&&($M||!$G)))$sc=($G?$G*$_:0)+count($M);elseif($y!="sql"||!$Wc){$sc=($Wc?false:found_rows($S,$Z));if($sc<max(1e4,2*($G+1)*$_))$sc=reset(slow_query(count_rows($a,$Z,$Wc,$t)));else$Wb=false;}}$se=($_!=""&&($sc===false||$sc>$_||$G));if($se){echo(($sc===false?count($M)+1:$sc-$G*$_)>$_?'<p><a href="'.h(remove_from_uri("page")."&page=".($G+1)).'" class="loadmore">'.'Charger plus de données'.'</a>'.script("qsl('a').onclick = partial(selectLoadMore, ".(+$_).", '".'Chargement'."…');",""):''),"\n";}}echo"<div class='footer'><div>\n";if($M||$G){if($se){$xd=($sc===false?$G+(count($M)>=$_?2:1):floor(($sc-1)/$_));echo"<fieldset>";if($y!="simpledb"){echo"<legend><a href='".h(remove_from_uri("page"))."'>".'Page'."</a></legend>",script("qsl('a').onclick = function () { pageClick(this.href, +prompt('".'Page'."', '".($G+1)."')); return false; };"),pagination(0,$G).($G>5?" …":"");for($u=max(1,$G-4);$u<min($xd,$G+5);$u++)echo
pagination($u,$G);if($xd>0){echo($G+5<$xd?" …":""),($Wb&&$sc!==false?pagination($xd,$G):" <a href='".h(remove_from_uri("page")."&page=last")."' title='~$xd'>".'dernière'."</a>");}}else{echo"<legend>".'Page'."</legend>",pagination(0,$G).($G>1?" …":""),($G?pagination($G,$G):""),($xd>$G?pagination($G+1,$G).($xd>$G+1?" …":""):"");}echo"</fieldset>\n";}echo"<fieldset>","<legend>".'Résultat entier'."</legend>";$xb=($Wb?"":"~ ").$sc;echo
checkbox("all",1,0,($sc!==false?($Wb?"":"~ ").lang(array('%d ligne','%d lignes'),$sc):""),"var checked = formChecked(this, /check/); selectCount('selected', this.checked ? '$xb' : checked); selectCount('selected2', this.checked || !checked ? '$xb' : checked);")."\n","</fieldset>\n";if($b->selectCommandPrint()){echo'<fieldset',($_GET["modify"]?'':' class="jsonly"'),'><legend>Modification</legend><div>
<input type="submit" value="Enregistrer"',($_GET["modify"]?'':' title="'.'Ctrl+cliquez sur une valeur pour la modifier.'.'"'),'>
</div></fieldset>
<fieldset><legend>Sélectionnée(s) <span id="selected"></span></legend><div>
<input type="submit" name="edit" value="Modifier">
<input type="submit" name="clone" value="Cloner">
<input type="submit" name="delete" value="Effacer">',confirm(),'</div></fieldset>
';}$qc=$b->dumpFormat();foreach((array)$_GET["columns"]as$d){if($d["fun"]){unset($qc['sql']);break;}}if($qc){print_fieldset("export",'Exporter'." <span id='selected2'></span>");$qe=$b->dumpOutput();echo($qe?html_select("output",$qe,$ja["output"])." ":""),html_select("format",$qc,$ja["format"])," <input type='submit' name='export' value='".'Exporter'."'>\n","</div></fieldset>\n";}$b->selectEmailPrint(array_filter($Mb,'strlen'),$e);}echo"</div></div>\n";if($b->selectImportPrint()){echo"<div>","<a href='#import'>".'Importer'."</a>",script("qsl('a').onclick = partial(toggle, 'import');",""),"<span id='import' class='hidden'>: ","<input type='file' name='csv_file'> ",html_select("separator",array("csv"=>"CSV,","csv;"=>"CSV;","tsv"=>"TSV"),$ja["format"],1);echo" <input type='submit' name='import' value='".'Importer'."'>","</span>","</div>";}echo"<input type='hidden' name='token' value='$U'>\n","</form>\n",(!$t&&$N?"":script("tableCheck();"));}}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$Mf=isset($_GET["status"]);page_header($Mf?'Statut':'Variables');$Vg=($Mf?show_status():show_variables());if(!$Vg)echo"<p class='message'>".'Aucun résultat.'."\n";else{echo"<table cellspacing='0'>\n";foreach($Vg
as$z=>$X){echo"<tr>","<th><code class='jush-".$y.($Mf?"status":"set")."'>".h($z)."</code>","<td>".h($X);}echo"</table>\n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$Tf=array("Data_length"=>0,"Index_length"=>0,"Data_free"=>0);foreach(table_status()as$F=>$S){json_row("Comment-$F",h($S["Comment"]));if(!is_view($S)){foreach(array("Engine","Collation")as$z)json_row("$z-$F",h($S[$z]));foreach($Tf+array("Auto_increment"=>0,"Rows"=>0)as$z=>$X){if($S[$z]!=""){$X=format_number($S[$z]);json_row("$z-$F",($z=="Rows"&&$X&&$S["Engine"]==($Hf=="pgsql"?"table":"InnoDB")?"~ $X":$X));if(isset($Tf[$z]))$Tf[$z]+=($S["Engine"]!="InnoDB"||$z!="Data_free"?$S[$z]:0);}elseif(array_key_exists($z,$S))json_row("$z-$F");}}}foreach($Tf
as$z=>$X)json_row("sum-$z",format_number($X));json_row("");}elseif($_GET["script"]=="kill")$f->query("KILL ".number($_POST["kill"]));else{foreach(count_tables($b->databases())as$j=>$X){json_row("tables-$j",$X);json_row("size-$j",db_size($j));}json_row("");}exit;}else{$bg=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($bg&&!$l&&!$_POST["search"]){$J=true;$D="";if($y=="sql"&&$_POST["tables"]&&count($_POST["tables"])>1&&($_POST["drop"]||$_POST["truncate"]||$_POST["copy"]))queries("SET foreign_key_checks = 0");if($_POST["truncate"]){if($_POST["tables"])$J=truncate_tables($_POST["tables"]);$D='Les tables ont été tronquées.';}elseif($_POST["move"]){$J=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D='Les tables ont été déplacées.';}elseif($_POST["copy"]){$J=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$D='Les tables ont été copiées.';}elseif($_POST["drop"]){if($_POST["views"])$J=drop_views($_POST["views"]);if($J&&$_POST["tables"])$J=drop_tables($_POST["tables"]);$D='Les tables ont été effacées.';}elseif($y!="sql"){$J=($y=="sqlite"?queries("VACUUM"):apply_queries("VACUUM".($_POST["optimize"]?"":" ANALYZE"),$_POST["tables"]));$D='Les tables ont bien été optimisées.';}elseif(!$_POST["tables"])$D='Aucune table.';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"]==""?'Base de données'.": ".h(DB):'Schéma'.": ".h($_GET["ns"])),$l,true);if($b->homepage()){if($_GET["ns"]!==""){echo"<h3 id='tables-views'>".'Tables et vues'."</h3>\n";$ag=tables_list();if(!$ag)echo"<p class='message'>".'Aucune table.'."\n";else{echo"<form action='' method='post'>\n";if(support("table")){echo"<fieldset><legend>".'Rechercher dans les tables'." <span id='selected2'></span></legend><div>","<input type='search' name='query' value='".h($_POST["query"])."'>",script("qsl('input').onkeydown = partialArg(bodyKeydown, 'search');","")," <input type='submit' name='search' value='".'Rechercher'."'>\n","</div></fieldset>\n";if($_POST["search"]&&$_POST["query"]!=""){$_GET["where"][0]["op"]="LIKE %%";search_tables();}}echo"<div class='scrollable'>\n","<table cellspacing='0' class='nowrap checkable'>\n",script("mixin(qsl('table'), {onclick: tableClick, ondblclick: partialArg(tableClick, true)});"),'<thead><tr class="wrap">','<td><input id="check-all" type="checkbox" class="jsonly">'.script("qs('#check-all').onclick = partial(formCheck, /^(tables|views)\[/);",""),'<th>'.'Table','<td>'.'Moteur'.'','<td>'.'Interclassement'.'','<td>'.'Longueur des données'.'','<td>'.'Longueur de l\'index'.'','<td>'.'Espace inutilisé'.'','<td>'.'Incrément automatique'.'','<td>'.'Lignes'.'',(support("comment")?'<td>'.'Commentaire'.'':''),"</thead>\n";$T=0;foreach($ag
as$F=>$V){$Yg=($V!==null&&!preg_match('~table|sequence~i',$V));$v=h("Table-".$F);echo'<tr'.odd().'><td>'.checkbox(($Yg?"views[]":"tables[]"),$F,in_array($F,$bg,true),"","","",$v),'<th>'.(support("table")||support("indexes")?"<a href='".h(ME)."table=".urlencode($F)."' title='".'Afficher la structure'."' id='$v'>".h($F).'</a>':h($F));if($Yg){echo'<td colspan="6"><a href="'.h(ME)."view=".urlencode($F).'" title="'.'Modifier une vue'.'">'.(preg_match('~materialized~i',$V)?'Vue matérialisée':'Vue').'</a>','<td align="right"><a href="'.h(ME)."select=".urlencode($F).'" title="'.'Afficher les données'.'">?</a>';}else{foreach(array("Engine"=>array(),"Collation"=>array(),"Data_length"=>array("create",'Modifier la table'),"Index_length"=>array("indexes",'Modifier les index'),"Data_free"=>array("edit",'Nouvel élément'),"Auto_increment"=>array("auto_increment=1&create",'Modifier la table'),"Rows"=>array("select",'Afficher les données'),)as$z=>$A){$v=" 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)."'$v title='$A[1]'>?</a>":"<span$v>?</span>"):"<td id='$z-".h($F)."'>");}$T++;}echo(support("comment")?"<td id='Comment-".h($F)."'>":"");}echo"<tr><td><th>".sprintf('%d au total',count($ag)),"<td>".h($y=="sql"?$f->result("SELECT @@default_storage_engine"):""),"<td>".h(db_collation(DB,collations()));foreach(array("Data_length","Index_length","Data_free")as$z)echo"<td align='right' id='sum-$z'>";echo"</table>\n","</div>\n";if(!information_schema(DB)){echo"<div class='footer'><div>\n";$Tg="<input type='submit' value='".'Vide'."'> ".on_help("'VACUUM'");$be="<input type='submit' name='optimize' value='".'Optimiser'."'> ".on_help($y=="sql"?"'OPTIMIZE TABLE'":"'VACUUM OPTIMIZE'");echo"<fieldset><legend>".'Sélectionnée(s)'." <span id='selected'></span></legend><div>".($y=="sqlite"?$Tg:($y=="pgsql"?$Tg.$be:($y=="sql"?"<input type='submit' value='".'Analyser'."'> ".on_help("'ANALYZE TABLE'").$be."<input type='submit' name='check' value='".'Vérifier'."'> ".on_help("'CHECK TABLE'")."<input type='submit' name='repair' value='".'Réparer'."'> ".on_help("'REPAIR TABLE'"):"")))."<input type='submit' name='truncate' value='".'Tronquer'."'> ".on_help($y=="sqlite"?"'DELETE'":"'TRUNCATE".($y=="pgsql"?"'":" TABLE'")).confirm()."<input type='submit' name='drop' value='".'Supprimer'."'>".on_help("'DROP TABLE'").confirm()."\n";$i=(support("scheme")?$b->schemas():$b->databases());if(count($i)!=1&&$y!="sqlite"){$j=(isset($_POST["target"])?$_POST["target"]:(support("scheme")?$_GET["ns"]:DB));echo"<p>".'Déplacer vers une autre base de données'.": ",($i?html_select("target",$i,$j):'<input name="target" value="'.h($j).'" autocapitalize="off">')," <input type='submit' name='move' value='".'Déplacer'."'>",(support("copy")?" <input type='submit' name='copy' value='".'Copier'."'> ".checkbox("overwrite",1,$_POST["overwrite"],'overwrite'):""),"\n";}echo"<input type='hidden' name='all' value=''>";echo
script("qsl('input').onclick = function () { selectCount('selected', formChecked(this, /^(tables|views)\[/));".(support("table")?" selectCount('selected2', formChecked(this, /^tables\[/) || $T);":"")." }"),"<input type='hidden' name='token' value='$U'>\n","</div></fieldset>\n","</div></div>\n";}echo"</form>\n",script("tableCheck();");}echo'<p class="links"><a href="'.h(ME).'create=">'.'Créer une table'."</a>\n",(support("view")?'<a href="'.h(ME).'view=">'.'Créer une vue'."</a>\n":"");if($ag)echo
script("ajaxSetHtml('".js_escape(ME)."script=db');");}}}page_footer();