".($X!=array_values($X)?"<th>".h($Be):"")."".select_value($W,$_,$n,$Ni);return"";}if(!$_)$_=adminer()->selectLink($X,$n);if($_===null){if(is_mail($X))$_="mailto:$X";if(is_url($X))$_=$X;}$J=adminer()->editVal($X,$n);if($J!==null){if(!is_utf8($J))$J="\0";elseif($Ni!=""&&is_shortable($n))$J=shorten_utf8($J,max(0,+$Ni));else$J=h($J);}returnadminer()->selectVal($J,$_,$n,$X);}functionis_mail($wc){$za='[-a-z0-9!#$%&\'*+/=?^_`{|}~]';$ic='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';$Gg="$za+(\\.$za+)*@($ic?\\.)+$ic";returnis_string($wc)&&preg_match("(^$Gg(,\\s*$Gg)*\$)i",$wc);}functionis_url($Q){$ic='[a-z0-9]([-a-z0-9]{0,61}[a-z0-9])';returnpreg_match("~^(https?)://($ic?\\.)+$ic(:\\d+)?(/.*)?(\\?.*)?(#.*)?\$~i",$Q);}functionis_shortable(array$n){returnpreg_match('~char|text|json|lob|geometry|point|linestring|polygon|string|bytea~',$n["type"]);}functioncount_rows($R,array$Z,$ve,array$yd){$H=" FROM ".table($R).($Z?" WHERE ".implode(" AND ",$Z):"");return($ve&&(JUSH=="sql"||count($yd)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$yd).")$H":"SELECT COUNT(*)".($ve?" FROM (SELECT 1$H GROUP BY ".implode(", ",$yd).") x":$H));}functionslow_query($H){$k=adminer()->database();$Pi=adminer()->queryTimeout();$ci=driver()->slowQuery($H,$Pi);$h=null;if(!$ci&&support("kill")){$h=connect();if($h&&($k==""||$h->select_db($k))){$Ee=get_val(connection_id(),0,$h);echoscript("const timeout = setTimeout(() => { ajax('".js_escape(ME)."script=kill', function () {}, 'kill=$Ee&token=".get_token()."'); }, 1000 * $Pi);");}}ob_flush();flush();$J=@get_key_vals(($ci?:$H),$h,false);if($h){echoscript("clearTimeout(timeout);");ob_flush();flush();}return$J;}functionget_token(){$hh=rand(1,1e6);return($hh^$_SESSION["token"]).":$hh";}functionverify_token(){list($Xi,$hh)=explode(":",$_POST["token"]);return($hh^$_SESSION["token"])==$Xi;}functionlzw_decompress($Ka){$ec=256;$La=8;$ib=array();$uh=0;$vh=0;for($t=0;$t<strlen($Ka);$t++){$uh=($uh<<8)+ord($Ka[$t]);$vh+=8;if($vh>=$La){$vh-=$La;$ib[]=$uh>>$vh;$uh&=(1<<$vh)-1;$ec++;if($ec>>$La)$La++;}}$dc=range("\0","\xFF");$J="";$Rj="";foreach($ibas$t=>$hb){$vc=$dc[$hb];if(!isset($vc))$vc=$Rj.$Rj[0];$J.=$vc;if($t)$dc[]=$Rj.$vc[0];$Rj=$vc;}return$J;}functionscript($ei,$aj="\n"){return"<script".nonce().">$ei</script>$aj";}functionscript_src($xj,$Wb=false){return"<script src='".h($xj)."'".nonce().($Wb?" defer":"")."></script>\n";}functionnonce(){return' nonce="'.get_nonce().'"';}functioninput_hidden($B,$Y=""){return"<input type='hidden' name='".h($B)."' value='".h($Y)."'>\n";}functioninput_token(){returninput_hidden("token",get_token());}functiontarget_blank(){return' target="_blank" rel="noreferrer noopener"';}functionh($Q){returnstr_replace("\0","�",htmlspecialchars($Q,ENT_QUOTES,'utf-8'));}functionnl_br($Q){returnstr_replace("\n","
",$Q);}functioncheckbox($B,$Y,$bb,$Ge="",$Wf="",$fb="",$Ie=""){$J="<input type='checkbox' name='$B' value='".h($Y)."'".($bb?" checked":"").($Ie?" aria-labelledby='$Ie'":"").">".($Wf?script("qsl('input').onclick = function () { $Wf };",""):"");return($Ge!=""||$fb?"<label".($fb?" class='$fb'":"").">$J".h($Ge)."</label>":$J);}functionoptionlist($bg,$Mh=null,$Aj=false){$J="";foreach($bgas$Be=>$W){$cg=array($Be=>$W);if(is_array($W)){$J.='<optgroup label="'.h($Be).'">';$cg=$W;}foreach($cgas$y=>$X)$J.='<option'.($Aj||is_string($y)?' value="'.h($y).'"':'').($Mh!==null&&($Aj||is_string($y)?(string)$y:$X)===$Mh?' selected':'').'>'.h($X);if(is_array($W))$J.='</optgroup>';}return$J;}functionhtml_select($B,array$bg,$Y="",$Vf="",$Ie=""){static$Ge=0;$He="";if(!$Ie&&substr($bg[""],0,1)=="("){$Ge++;$Ie="label-$Ge";$He="<option value='' id='$Ie'>".h($bg[""]);unset($bg[""]);}return"<select name='".h($B)."'".($Ie?" aria-labelledby='$Ie'":"").">".$He.optionlist($bg,$Y)."</select>".($Vf?script("qsl('select').onchange = function () { $Vf };",""):"");}functionhtml_radios($B,array$bg,$Y="",$Qh=""){$J="";foreach($bgas$y=>$X)$J.="<label><input type='radio' name='".h($B)."' value='".h($y)."'".($y==$Y?" checked":"").">".h($X)."</label>$Qh";return$J;}functionconfirm($mf="",$Nh="qsl('input')"){returnscript("$Nh.onclick = () => confirm('".($mf?js_escape($mf):lang(6))."');","");}functionprint_fieldset($u,$Pe,$Lj=false){echo"<fieldset><legend>","<a href='#fieldset-$u'>$Pe</a>",script("qsl('a').onclick = partial(toggle, 'fieldset-$u');",""),"</legend>","<div id='fieldset-$u'".($Lj?"":" class='hidden'").">\n";}functionbold($Na,$fb=""){return($Na?" class='active $fb'":($fb?" class='$fb'":""));}functionjs_escape($Q){returnaddcslashes($Q,"\r\n'\\/");}functionpagination($D,$Kb){return" ".($D==$Kb?$D+1:'<a href="'.h(remove_from_uri("page").($D?"&page=$D".($_GET["next"]?"&next=".urlencode($_GET["next"]):""):"")).'">'.($D+1)."</a>");}functionhidden_fields(array$ah,array$Wd=array(),$Sg=''){$J=false;foreach($ahas$y=>$X){if(!in_array($y,$Wd)){if(is_array($X))hidden_fields($X,array(),$y);else{$J=true;echoinput_hidden(($Sg?$Sg."[$y]":$y),$X);}}}return$J;}functionhidden_fields_get(){echo(sid()?input_hidden(session_name(),session_id()):''),(SERVER!==null?input_hidden(DRIVER,SERVER):""),input_hidden("username",$_GET["username"]);}functionenum_input($U,$_a,array$n,$Y,$zc=null){preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$cf);$J=($zc!==null?"<label><input type='$U'$_a value='$zc'".((is_array($Y)?in_array($zc,$Y):$Y===$zc)?" checked":"")."><i>".lang(7)."</i></label>":"");foreach($cf[1]as$t=>$X){$X=stripcslashes(str_replace("''","'",$X));$bb=(is_array($Y)?in_array($X,$Y):$Y===$X);$J.=" <label><input type='$U'$_a value='".h($X)."'".($bb?' checked':'').'>'.h(adminer()->editVal($X,$n)).'</label>';}return$J;}functioninput(array$n,$Y,$s,$Da=false){$B=h(bracket_escape($n["field"]));echo"<td class='function'>";if(is_array($Y)&&!$s){$Y=json_encode($Y,128|64|256);$s="json";}$th=(JUSH=="mssql"&&$n["auto_increment"]);if($th&&!$_POST["save"])$s=null;$td=(isset($_GET["select"])||$th?array("orig"=>lang(8)):array())+adminer()->editFunctions($n);$fc=stripos($n["default"],"GENERATED ALWAYS AS ")===0?" disabled=''":"";$_a=" name='fields[$B]'$fc".($Da?" autofocus":"");$Ec=driver()->enumLength($n);if($Ec){$n["type"]="enum";$n["length"]=$Ec;}echodriver()->unconvertFunction($n)." ";$R=$_GET["edit"]?:$_GET["select"];if($n["type"]=="enum")echoh($td[""])." | ".adminer()->editInput($R,$n,$_a,$Y);else{$Fd=(in_array($s,$td)||isset($td[$s]));echo(count($td)>1?"<select name='function[$B]'$fc>".optionlist($td,$s===null||$Fd?$s:"")."</select>".on_help("event.target.value.replace(/^SQL\$/, '')",1).script("qsl('select').onchange = functionChange;",""):h(reset($td))).' | ';$ne=adminer()->editInput($R,$n,$_a,$Y);if($ne!="")echo$ne;elseif(preg_match('~bool~',$n["type"]))echo"<input type='hidden'$_a value='0'>"."<input type='checkbox'".(preg_match('~^(1|t|true|y|yes|on)$~i',$Y)?" checked='checked'":"")."$_a value='1'>";elseif($n["type"]=="set"){preg_match_all("~'((?:[^']|'')*)'~",$n["length"],$cf);foreach($cf[1]as$t=>$X){$X=stripcslashes(str_replace("''","'",$X));$bb=in_array($X,explode(",",$Y),true);echo" <label><input type='checkbox' name='fields[$B][$t]' value='".h($X)."'".($bb?' checked':'').">".h(adminer()->editVal($X,$n)).'</label>';}}elseif(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads"))echo"<input type='file' name='fields-$B'>";elseif($s=="json"||preg_match('~^jsonb?$~',$n["type"]))echo"<textarea$_a cols='50' rows='12' class='jush-js'>".h($Y).'</textarea>';elseif(($Li=preg_match('~text|lob|memo~i',$n["type"]))||preg_match("~\n~",$Y)){if($Li&&JUSH!="sqlite")$_a.=" cols='50' rows='12'";else{$L=min(12,substr_count($Y,"\n")+1);$_a.=" cols='30' rows='$L'";}echo"<textarea$_a>".h($Y).'</textarea>';}else{$mj=driver()->types();$jf=(!preg_match('~int~',$n["type"])&&preg_match('~^(\d+)(,(\d+))?$~',$n["length"],$A)?((preg_match("~binary~",$n["type"])?2:1)*$A[1]+($A[3]?1:0)+($A[2]&&!$n["unsigned"]?1:0)):($mj[$n["type"]]?$mj[$n["type"]]+($n["unsigned"]?0:1):0));if(JUSH=='sql'&&min_version(5.6)&&preg_match('~time~',$n["type"]))$jf+=7;echo"<input".((!$Fd||$s==="")&&preg_match('~(?<!o)int(?!er)~',$n["type"])&&!preg_match('~\[\]~',$n["full_type"])?" type='number'":"")." value='".h($Y)."'".($jf?" data-maxlength='$jf'":"").(preg_match('~char|binary~',$n["type"])&&$jf>20?" size='".($jf>99?60:40)."'":"")."$_a>";}echoadminer()->editHint($R,$n,$Y);$dd=0;foreach($tdas$y=>$X){if($y===""||!$X)break;$dd++;}if($dd&&count($td)>1)echoscript("qsl('td').oninput = partial(skipOriginal, $dd);");}}functionprocess_input(array$n){if(stripos($n["default"],"GENERATED ALWAYS AS ")===0)return;$v=bracket_escape($n["field"]);$s=idx($_POST["function"],$v);$Y=$_POST["fields"][$v];if($n["type"]=="enum"||driver()->enumLength($n)){if($Y==-1)returnfalse;if($Y=="")return"NULL";}if($n["auto_increment"]&&$Y=="")returnnull;if($s=="orig")return(preg_match('~^CURRENT_TIMESTAMP~i',$n["on_update"])?idf_escape($n["field"]):false);if($s=="NULL")return"NULL";if($n["type"]=="set")$Y=implode(",",(array)$Y);if($s=="json"){$s="";$Y=json_decode($Y,true);if(!is_array($Y))returnfalse;return$Y;}if(preg_match('~blob|bytea|raw|file~',$n["type"])&&ini_bool("file_uploads")){$bd=get_file("fields-$v");if(!is_string($bd))returnfalse;returndriver()->quoteBinary($bd);}returnadminer()->processInput($n,$Y,$s);}functionsearch_tables(){$_GET["where"][0]["val"]=$_POST["query"];$Ph="<ul>\n";foreach(table_status('',true)as$R=>$S){$B=adminer()->tableName($S);if(isset($S["Engine"])&&$B!=""&&(!$_POST["tables"]||in_array($R,$_POST["tables"]))){$I=connection()->query("SELECT".limit("1 FROM ".table($R)," WHERE ".implode(" AND ",adminer()->selectSearchProcess(fields($R),array())),1));if(!$I||$I->fetch_row()){$Wg="<a href='".h(ME."select=".urlencode($R)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]))."'>$B</a>";echo"$Ph<li>".($I?$Wg:"<p class='error'>$Wg: ".error())."\n";$Ph="";}}}echo($Ph?"<p class='message'>".lang(9):"</ul>")."\n";}functionon_help($ob,$ai=0){returnscript("mixin(qsl('select, input'), {onmouseover: function (event) { helpMouseover.call(this, event, $ob, $ai) }, onmouseout: helpMouseout});","");}functionedit_form($R,array$o,$K,$vj,$m=''){$zi=adminer()->tableName(table_status1($R,true));page_header(($vj?lang(10):lang(11)),$m,array("select"=>array($R,$zi)),$zi);adminer()->editRowPrint($R,$o,$K,$vj);if($K===false){echo"<p class='error'>".lang(12)."\n";return;}echo" |