';$wg=[];$gk=($this->settings->isSelectionPreferred()&&!$this->settings->isNavigationReversed())||(!$this->settings->isSelectionPreferred()&&$this->settings->isNavigationReversed());if($gk)$wg["select"]=[lang(34),"data"];if(support("table")||support("indexes"))$wg["table"]=[lang(35),"structure"];if(!$gk)$wg["select"]=[lang(34),"data"];$Q=$ll["Name"];$Lf=false;if(support("table")){$Lf=is_view($ll);if(!$Lf){if($Q!="")$wg["create"]=[lang(36),"edit"];}elseif(support("view"))$wg["view"]=[lang(37),"edit"];}if($xf!==null)$wg["edit"]=[lang(8),"item-add"];$ui=$xf?"&".http_build_query($xf):"";foreach($wg
as$t=>$W)echo" ",icon($W[1]),"$W[0] ";echo
doc_link([DIALECT=>Driver::get()->tableHelp($Q,$Lf)],icon("help").lang(38)),"\n";}function
formatSelectQuery($G,$Rk,$Id=false){$cl=support("sql");$Tm=!$Id?Driver::get()->warnings():null;if($cl)$G
.=";";$fl=DIALECT=="elastic"||DIALECT=="mongo"?"json":DIALECT;$I="
",icon("handle","handle jsonly");if(Driver::get()->getFunctions()||Driver::get()->getGrouping())echo
html_select("columns[$p][fun]",[-1=>""]+array_filter([lang(57)=>Driver::get()->getFunctions(),lang(58)=>Driver::get()->getGrouping()]),isset($W["fun"])?$W["fun"]:null),help_script_command("value && value.replace(/ |\$/, '(') + ')'",true),script("qsl('select').onchange = (event) => { ".($t!==""?"":" qsl('select, input:not(.remove)', event.target.parentNode).onchange();")." };",""),"($b)";else
echo$b;echo" ",icon_solo("remove")," ",script("qsl('#fieldset-select .remove').onclick = selectRemoveRow;",""),"
\n";$p++;}print_fieldset_end("select",true);}function
printSelectionSearch(array$Z,array$c,array$s){print_fieldset_start("search",lang(60),"search",(bool)$Z);foreach($s
as$p=>$r){if($r["type"]=="FULLTEXT"){echo"",select_input(" name='where[$p][col]'",$c,$W["col"],($W?"selectFieldChange":"selectAddRow"),"(".lang(61).")"),html_select("where[$p][op]",$this->getOperators(),$W["op"],$mb),"",icon_solo("remove")," ",script('qsl("#fieldset-search .remove").onclick = selectRemoveRow;',""),"
\n";}print_fieldset_end("search");}function
printSelectionOrder(array$C,array$c,array$s){print_fieldset_start("sort",lang(62),"sort",(bool)$C,true);$_GET["order"][""]="";$p=0;foreach((array)$_GET["order"]as$t=>$W){if($t!=""&&$W=="")continue;echo"",icon("handle","handle jsonly"),select_input("name='order[$p]'",$c,$W,$t!==""?"selectFieldChange":"selectAddRow")," ",checkbox("desc[$p]",1,isset($_GET["desc"][$t]),lang(63))," ",icon_solo("remove")," ",script('qsl("#fieldset-sort .remove").onclick = selectRemoveRow;',""),"
\n";$p++;}print_fieldset_end("sort",true);}function
printSelectionLimit($v){echo"\n";if(support("sql")&&$vl){$wg=[];foreach($vl
as$Q=>$T)$wg[]=js_escape_re($Q);$kl=support("table")&&!$this->config->isSelectionPreferred()?"table":"select";echo"window.jushLinks = { ".DIALECT.": {\n",js_escape_key(ME.$kl.'=$&'),': /\b(?getConfig()->isSqlAutocompletionEnabled()&&(isset($_GET["sql"])||isset($_GET["trigger"])||isset($_GET["check"]))){$wl=array_fill_keys(array_keys($vl),[]);foreach(Driver::get()->getAllFields()as$Q=>$k){foreach($k
as$j)$wl[$Q][]=$j["field"];}echo"window.addEventListener('DOMContentLoaded', () => { autocompletion = jush.autocompleteSql('".idf_escape("")."', ".json_encode($wl,JSON_HEX_TAG)."); });\n";}echo"\n";}echo
script("let autocompletion;\nwindow.addEventListener('DOMContentLoaded', () => { initSyntaxHighlighting('".js_escape(doc_version())."', '".js_escape(Connection::get()->getFlavor())."', autocompletion); });");}}function
printDatabaseSwitcher($hh){$f=$this->admin->getDatabases();if(!$f&&DIALECT!="sqlite")return;echo"\n";}function
printTableList(array$vl){$ad=$this->settings->isNavigationDual()||$this->settings->isNavigationHover();$Vg=($ad?"class='dual".($this->settings->isNavigationHover()?" hover":"")."'":($this->settings->isNavigationReversed()?"class='reversed'":""));echo"
";foreach($vl
as$Q=>$O){$Q="$Q";$_=$this->admin->getTableName($O);if($_==""||(isset($O["Partition"])?$O["Partition"]:false))continue;echo"";$wa=in_array($Q,[$_GET["table"],$_GET["select"],$_GET["create"],$_GET["indexes"],$_GET["foreign"],$_GET["trigger"],$_GET["check"],$_GET["view"]]);$xb="primary".(is_view($O)?" view":"");$dl=support("table")||support("indexes");$dk=h(ME)."select=".urlencode($Q);$ml=h(ME)."table=".urlencode($Q);if($this->settings->isSelectionPreferred()){if($this->settings->isNavigationReversed()&&$dl)echo" ",icon("structure")," ";echo"$_ ";if($ad&&$dl)echo" ",icon_solo("structure")," ";}else{if($this->settings->isNavigationReversed())echo" ",icon("data")," ";if($dl)echo"$_ ";else
echo"$_ ";if($ad)echo" ",icon_solo("data")," ";}echo" \n";}echo" ".lang(87)." "."".html_radios("navigationMode",$B,($ra=$this->settings->getParameter("navigationMode"))!==null?$ra:"")."".lang(88)." "." ".lang(89)." "."".html_select("preferSelection",$B,($ra=$this->settings->getParameter("preferSelection"))!==null?$ra:"","","label-links",true)."".lang(90)." "." ".lang(91);echo"\n";return$I;}function
referencable_primary($ik){$I=[];foreach(table_status('',true)as$ol=>$Q){if($ol!=$ik&&fk_support($Q)){foreach(fields($ol)as$j){if($j["primary"]){if($I[$ol]){unset($I[$ol]);break;}$I[$ol]=$j;}}}}return$I;}function
textarea($_,$X,$K=10,$Gb=80){echo"";}function
select_input($Na,$B,$X="",$Oh="",$Mi=""){if($B&&$X!=""&&!isset($B[$X]))$B=[$X=>$X]+$B;$_l=($B?"select":"input");return"<$_l $Na".($B?">$Mi".optionlist($B,$X,true)."":" size='10' value='".h($X)."' placeholder='$Mi'>").($Oh?script("qsl('$_l').onchange = $Oh;",""):"");}function
json_row($t,$W=null){static$Zd=true;if($Zd)echo"{";if($t!=""){echo($Zd?"":",")."\n\t\"".addcslashes($t,"\r\n\t\"\\/").'": '.($W!==null?'"'.addcslashes($W,"\r\n\t\"\\/").'"':'null');$Zd=false;}else{echo"\n}\n";$Zd=true;}}function
edit_type($t,$j,$Cb,$ke=[],$Hd=[]){$T=isset($j["type"])?$j["type"]:null;echo'';$Uc=Driver::get()->getTypes();if($T&&!isset($Uc[$T])&&!isset($ke[$T])&&!in_array($T,$Hd))$Hd[]=$T;$Vk=Driver::get()->getStructuredTypes();if($ke)$Vk[lang(92)]=$ke;echo
optionlist(array_merge($Hd,$Vk),$T),' ',($Cb?"('.lang(93).')'.optionlist($Cb,isset($j["collation"])?$j["collation"]:null).' '.optionlist(Driver::get()->getUnsigned(),isset($j["unsigned"])?$j["unsigned"]:null).' '.optionlist([""=>"(".lang(94).")","CURRENT_TIMESTAMP"],(preg_match('~^CURRENT_TIMESTAMP~i',$j["on_update"])?"CURRENT_TIMESTAMP":$j["on_update"])).' ':''),($ke?"(".lang(95).")".optionlist(Driver::get()->getOnActions(),isset($j["on_delete"])?$j["on_delete"]:null)." \n";if(support("move_col"))echo"",($T=="TABLE"?lang(96):lang(97))," \n","",lang(45),"",script("gid('enum-edit').onblur = onFieldLengthBlur;")," \n","",lang(98)," \n","",lang(99)," \n";if($T=="TABLE")echo"NULL \n","AI ",doc_link(['pgsql'=>"datatype-numeric.html#DATATYPE-SERIAL",]),"",lang(49)," \n",support("comment")?"\n":"";echo"","",icon_solo("add")," ",(support("move_col")?"":script("qsl('button').onclick = onAddLastFieldRowClick;")),script("row_count = ".count($k).";")," \n"," \n";foreach($k
as$p=>$j){$p++;$hi=$j[($_POST?"orig":"field")];$Kc=(isset($_POST["add"][$p-1])||(isset($j["field"])&&!(isset($_POST["drop_col"][$p])?$_POST["drop_col"][$p]:null)))&&(support("drop_col")||$hi=="");echo"\n";if(support("move_col"))echo"",icon_solo("handle"),"";if($T=="PROCEDURE")echo" ",html_select("fields[$p][inout]",Driver::get()->getInOut(),$j["inout"])," \n";echo"";if($Kc)echo" \n";if($T=="TABLE"){echo"",checkbox("fields[$p][null]",1,$j["null"],"","","block","label-null")," \n";$sb=$j["auto_increment"]?"checked":"";echo"";if(Driver::get()->getGenerated())echo
html_select("fields[$p][generated]",array_merge(["","DEFAULT"],Driver::get()->getGenerated()),$j["generated"]);else
echo
checkbox("fields[$p][generated]",1,$j["generated"],"","","","label-default");$Na="name='fields[$p][default]' aria-labelledby='label-default'";$X=h($j["default"]);if(str_contains($X,"\n")){if($X[0]=="\n")$X="\n$X";echo"";}else
echo" \n";if(support("comment")){$Lg=Connection::get()->isMinVersion("5.5")?1024:255;$Na="name='fields[$p][comment]' data-maxlength='$Lg' aria-labelledby='label-comment'";$X=h($j["comment"]);echo"";if(str_contains($X,"\n")){if($X[0]=="\n")$X="\n$X";echo"";}else
echo" \n";}}echo"";if(support("move_col"))echo"",icon_solo("add")," ","",icon_solo("arrow-up")," ","",icon_solo("arrow-down")," ";if($hi==""||support("drop_col"))echo"",icon_solo("remove")," ";echo" \n\n";}echo" ";}function
process_fields(&$k){$Fh=0;if($_POST["up"]){$gg=0;foreach($k
as$t=>$j){if(key($_POST["up"])==$t){unset($k[$t]);array_splice($k,$gg,0,[$j]);break;}if(isset($j["field"]))$gg=$Fh;$Fh++;}}elseif($_POST["down"]){$pe=false;foreach($k
as$t=>$j){if(isset($j["field"])&&$pe){unset($k[key($_POST["down"])]);array_splice($k,$Fh,0,[$pe]);break;}if(key($_POST["down"])==$t)$pe=$j;$Fh++;}}elseif($_POST["add"]){$k=array_values($k);array_splice($k,key($_POST["add"]),0,[[]]);}elseif(!$_POST["drop_col"])return
false;return
true;}function
normalize_enum($y){$W=$y[0];return"'".str_replace("'","''",addcslashes(stripcslashes(str_replace($W[0].$W[0],$W[0],substr($W,1,-1))),'\\'))."'";}function
grant($ze,array$fj,$c,$Mh,$_m){if(!$fj)return
true;if($fj==["ALL PRIVILEGES","GRANT OPTION"]){if($ze)return(bool)queries("GRANT ALL PRIVILEGES ON $Mh TO $_m WITH GRANT OPTION");else
return
queries("REVOKE ALL PRIVILEGES ON $Mh FROM $_m")&&queries("REVOKE GRANT OPTION ON $Mh FROM $_m");}if($fj==["GRANT OPTION","PROXY"]){if($ze)return(bool)queries("GRANT PROXY ON $Mh TO $_m WITH GRANT OPTION");else
return(bool)queries("REVOKE PROXY ON $Mh FROM $_m");}return(bool)queries(($ze?"GRANT ":"REVOKE ").preg_replace('~(GRANT OPTION)\([^)]*\)~','$1',implode("$c, ",$fj).$c)." ON $Mh ".($ze?"TO ":"FROM ").$_m);}function
drop_create($Wc,$gc,$Xc,$El,$Yc,$x,$Zg,$Xg,$Yg,$Lh,$yh){if($_POST["drop"])query_redirect($Wc,$x,$Zg);elseif($Lh=="")query_redirect($gc,$x,$Yg);elseif($Lh!=$yh){$ic=queries($gc);queries_redirect($x,$Xg,$ic&&queries($Wc));if($ic)queries($Xc);}else
queries_redirect($x,$Xg,queries($El)&&queries($Yc)&&queries($Wc)&&queries($gc));}function
create_trigger($Mh,array$dm){$Ol=" $dm[Timing] $dm[Event]".(preg_match('~ OF~',$dm["Event"])?" $dm[Of]":"");return"CREATE TRIGGER ".idf_escape($dm["Trigger"]).(DIALECT=="mssql"?$Mh.$Ol:$Ol.$Mh).rtrim(" $dm[Type]\n$dm[Statement]",";").";";}function
create_routine($Mj,$J){$yk=[];$k=(array)$J["fields"];ksort($k);$hf=implode("|",Driver::get()->getInOut());foreach($k
as$j){if($j["field"]!="")$yk[]=(preg_match("~^($hf)\$~",$j["inout"])?"$j[inout] ":"").idf_escape($j["field"]).process_type($j,"CHARACTER SET");}$_c=rtrim($J["definition"],";");return"CREATE $Mj ".idf_escape(trim($J["name"]))." (".implode(", ",$yk).")".($Mj=="FUNCTION"?" RETURNS".process_type($J["returns"],"CHARACTER SET"):"").($J["language"]?" LANGUAGE $J[language]":"").(DIALECT=="pgsql"?" AS ".q($_c):"\n$_c;");}function
remove_definer($G){return
preg_replace('~^([A-Z =]+) DEFINER=`'.preg_replace('~@(.*)~','`@`(%|\1)',logged_user()).'`~','\1',$G);}function
format_foreign_key($n){$Nh=implode("|",Driver::get()->getOnActions());$g=$n["db"];$Bh=$n["ns"];return" FOREIGN KEY (".implode(", ",array_map('AdminNeo\idf_escape',$n["source"])).") REFERENCES ".($g!=""&&$g!=$_GET["db"]?idf_escape($g).".":"").($Bh!=""&&$Bh!=$_GET["ns"]?idf_escape($Bh).".":"").idf_escape($n["table"])." (".implode(", ",array_map('AdminNeo\idf_escape',$n["target"])).")".(preg_match("~^($Nh)\$~",$n["on_delete"])?" ON DELETE $n[on_delete]":"").(preg_match("~^($Nh)\$~",$n["on_update"])?" ON UPDATE $n[on_update]":"").(isset($n["deferrable"])?" $n[deferrable]":"");}function
tar_file($m,TmpFile$Sl){$Ne=pack("a100a8a8a8a12a12",$m,644,0,0,decoct($Sl->getSize()),decoct(time()));$ub=8*32;for($p=0;$psend();echo
str_repeat("\0",511-($Sl->getSize()+511)%512);}function
doc_link(array$Ii,$Fl="? "){if(!(isset($Ii[DIALECT])?$Ii[DIALECT]:null))return"";$Jm=doc_version();$vm=['sql'=>"https://dev.mysql.com/doc/refman/$Jm/en/",'sqlite'=>"https://www.sqlite.org/",'pgsql'=>"https://www.postgresql.org/docs/".(Connection::get()->isCockroachDB()?"current":$Jm)."/",'mssql'=>"https://learn.microsoft.com/en-us/sql/",'oracle'=>"https://www.oracle.com/pls/topic/lookup?ctx=db".str_replace(".","",$Jm)."&id=",'elastic'=>"https://www.elastic.co/guide/en/elasticsearch/reference/$Jm/",];if(Connection::get()->isMariaDB()){$vm['sql']="https://mariadb.com/docs/server/";$Ii['sql']=isset($Ii['mariadb'])?$Ii['mariadb']:str_replace(".html","",$Ii['sql']);}return"$Fl ";}function
doc_version(){return
preg_replace('~^(\d\.?\d).*~s','\1',Connection::get()->getVersion());}function
db_size($g){if(!Connection::get()->selectDatabase($g))return"?";$I=0;foreach(table_status()as$R)$I+=$R["Data_length"]+$R["Index_length"];return
format_number($I);}function
set_utf8mb4($gc){static$yk=false;if(!$yk&&preg_match('~\butf8mb4~i',$gc)){$yk=true;echo"SET NAMES ".charset(Connection::get()).";\n\n";}}error_reporting(E_ALL&~E_DEPRECATED);set_error_handler(function($td,$i){return(bool)preg_match('~^Undefined (array key|offset|index)~',$i);},E_WARNING|E_NOTICE);;$Wd=!preg_match('~^(unsafe_raw)?$~',ini_get("filter.default"));if($Wd||ini_get("filter.default_flags")){foreach(['_GET','_POST','_COOKIE','_SERVER']as$W){$pm=filter_input_array(constant("INPUT$W"),FILTER_UNSAFE_RAW);if($pm)$$W=$pm;}}if(function_exists("mb_internal_encoding"))mb_internal_encoding("8bit");class
Server{private$params;private$key;function
__construct(array$ui,$t=null){$this->params=$ui;$this->key=$t;}function
getKey(){return
isset($this->key)?$this->key:substr(md5($this->getDriver().$this->getServer()),0,8);}function
getDriver(){return$this->params["driver"];}function
getServer(){return
isset($this->params["server"])?$this->params["server"]:"";}function
getDatabase(){return
isset($this->params["database"])?$this->params["database"]:"";}function
getName(){return
isset($this->params["name"])?$this->params["name"]:(isset($this->params["server"])?$this->params["server"]:"");}function
getUsername(){return
isset($this->params["username"])?$this->params["username"]:"";}function
getPassword(){return
isset($this->params["password"])?$this->params["password"]:"";}function
hasCredentials(){return$this->getUsername()!=""||$this->getPassword()!="";}function
getConfigParams(){$ui=isset($this->params["config"])?$this->params["config"]:[];$ye=["servers"];foreach($ye
as$ti){if(isset($ui[$ti]))unset($ui[$ti]);}return$ui;}}class
Config{static$NavigationSimple="simple";static$NavigationDual="dual";static$NavigationHover="hover";static$NavigationReversed="reversed";private$params;private$servers=[];function
__construct(array$ui){$this->params=$ui;if(isset($this->params["servers"])){foreach($this->params["servers"]as$t=>$M){$qk=new
Server($M,is_string($t)?$t:null);$this->params["servers"][$t]=$qk;$this->servers[$qk->getKey()]=$qk;}}}function
getTheme(){return
isset($this->params["theme"])?$this->params["theme"]:"default";}function
getColorVariant(){return
isset($this->params["colorVariant"])?$this->params["colorVariant"]:"blue";}function
getCssUrls(){return$this->parseList(isset($this->params["cssUrls"])?$this->params["cssUrls"]:[]);}function
getJsUrls(){return$this->parseList(isset($this->params["jsUrls"])?$this->params["jsUrls"]:[]);}function
getNavigationMode(){return
isset($this->params["navigationMode"])?$this->params["navigationMode"]:self::$NavigationSimple;}function
isNavigationSimple(){return$this->getNavigationMode()==self::$NavigationSimple;}function
isNavigationDual(){return$this->getNavigationMode()==self::$NavigationDual;}function
isNavigationReversed(){return$this->getNavigationMode()==self::$NavigationReversed;}function
isSelectionPreferred(){return
isset($this->params["preferSelection"])?$this->params["preferSelection"]:false;}function
isJsonValuesDetection(){return
isset($this->params["jsonValuesDetection"])?$this->params["jsonValuesDetection"]:false;}function
isJsonValuesAutoFormat(){return
isset($this->params["jsonValuesAutoFormat"])?$this->params["jsonValuesAutoFormat"]:false;}function
isRelationLinks(){return
isset($this->params["relationLinks"])?$this->params["relationLinks"]:false;}function
getRecordsPerPage(){return(int)(isset($this->params["recordsPerPage"])?$this->params["recordsPerPage"]:50);}function
getEnumAsSelectThreshold(){if(array_key_exists("enumAsSelectThreshold",$this->params))return$this->params["enumAsSelectThreshold"]!==null?(int)$this->params["enumAsSelectThreshold"]:null;else
return
5;}function
isVersionVerificationEnabled(){return
isset($this->params["versionVerification"])?$this->params["versionVerification"]:true;}function
isSqlAutocompletionEnabled(){return
isset($this->params["sqlAutocompletion"])?$this->params["sqlAutocompletion"]:true;}function
getHiddenDatabases(){return$this->parseList(isset($this->params["hiddenDatabases"])?$this->params["hiddenDatabases"]:[]);}function
getHiddenSchemas(){return$this->parseList(isset($this->params["hiddenSchemas"])?$this->params["hiddenSchemas"]:[]);}function
getVisibleCollations(){return$this->parseList(isset($this->params["visibleCollations"])?$this->params["visibleCollations"]:[]);}function
getDefaultDriver(array$Vc){$Tc=isset($this->params["defaultDriver"])?$this->params["defaultDriver"]:null;return$Tc&&isset($Vc[$Tc])?$Tc:key($Vc);}function
getDefaultServer(){$M=isset($this->params["defaultServer"])?$this->params["defaultServer"]:null;if($M===null)return
null;$qk=isset($this->params["servers"][$M])?$this->params["servers"][$M]:null;if($qk)return$qk->getKey();return$M;}function
getDefaultDatabase(){return
isset($this->params["defaultDatabase"])?$this->params["defaultDatabase"]:null;}function
getDefaultPasswordHash(){return
isset($this->params["defaultPasswordHash"])?$this->params["defaultPasswordHash"]:null;}function
getSslKey(){return
isset($this->params["sslKey"])?$this->params["sslKey"]:null;}function
getSslCertificate(){return
isset($this->params["sslCertificate"])?$this->params["sslCertificate"]:null;}function
getSslCaCertificate(){return
isset($this->params["sslCaCertificate"])?$this->params["sslCaCertificate"]:null;}function
getSslTrustServerCertificate(){return
isset($this->params["sslTrustServerCertificate"])?$this->params["sslTrustServerCertificate"]:null;}function
getSslEncrypt(){return
isset($this->params["sslEncrypt"])?$this->params["sslEncrypt"]:null;}function
getSslMode(){return
isset($this->params["sslMode"])?$this->params["sslMode"]:null;}function
hasServers(){return
isset($this->params["servers"]);}function
getServerPairs(array$Vc){$Dk=null;foreach($this->servers
as$M){if(!isset($Vc[$M->getDriver()]))continue;if(!$Dk)$Dk=$M->getDriver();elseif($M->getDriver()!=$Dk){$Dk=null;break;}}$rk=[];foreach($this->servers
as$t=>$M){if(!isset($Vc[$M->getDriver()]))continue;$pk=$M->getName();if($Dk&&$pk)$rk[$t]=$pk;else$rk[$t]=$Vc[$M->getDriver()].($pk!=""?" - $pk":"");}return$rk;}function
getServer($ok){return
isset($this->servers[$ok])?$this->servers[$ok]:null;}function
applyServer($M){$M=$this->getServer($M);if(!$M)return;$this->params=array_merge($this->params,$M->getConfigParams());}private
function
parseList($yg){if(is_array($yg))return$yg;return
preg_split('~\s*,\s*~',(string)$yg);}}class
Settings{private
static$CookieName="neo_settings";static$ColorSchemeLight="light";static$ColorSchemeDark="dark";static$NavigationWidthMin=10;static$NavigationWidthMax=30;private$config;private$params=[];function
__construct(Config$Tb){$this->config=$Tb;if(isset($_COOKIE[self::$CookieName])){parse_str($_COOKIE[self::$CookieName],$this->params);$this->save();}if(isset($_COOKIE["neo_lang"])){$this->updateParameter("lang",$_COOKIE["neo_lang"]);unset($_COOKIE["neo_lang"]);cookie("neo_lang","",-3600);}}static
function
readParameter($t){parse_str(isset($_COOKIE[self::$CookieName])?$_COOKIE[self::$CookieName]:"",$ui);return
isset($ui[$t])?$ui[$t]:null;}function
getParameter($t,$h=null){return
isset($this->params[$t])?$this->params[$t]:$h;}function
updateParameter($t,$X){$this->updateParameters([$t=>$X]);}function
updateParameters(array$ui){$this->params=array_filter(array_merge($this->params,$ui),function($X){return$X!==null;});$this->save();}private
function
save(){cookie(self::$CookieName,http_build_query($this->params),7776000);}function
getTheme(){return($ra=$this->getParameter("theme"))!==null?$ra:$this->config->getTheme();}function
getColorScheme(){return$this->getParameter("colorScheme");}function
getNavigationMode(){return($ra=$this->getParameter("navigationMode"))!==null?$ra:$this->config->getNavigationMode();}function
isNavigationSimple(){return$this->getNavigationMode()==Config::$NavigationSimple;}function
isNavigationDual(){return$this->getNavigationMode()==Config::$NavigationDual;}function
isNavigationHover(){return$this->getNavigationMode()==Config::$NavigationHover;}function
isNavigationReversed(){return$this->getNavigationMode()==Config::$NavigationReversed;}function
getNavigationWidth(){$an=$this->getParameter("navigationWidth");if($an===null)return
null;return
min(max((float)$an,self::$NavigationWidthMin),self::$NavigationWidthMax);}function
isSelectionPreferred(){return($ra=$this->getParameter("preferSelection"))!==null?$ra:$this->config->isSelectionPreferred();}function
isRelationLinks(){return
isset($this->params["relationLinks"])?$this->params["relationLinks"]:$this->config->isRelationLinks();}function
getRecordsPerPage(){return($ra=$this->getParameter("recordsPerPage"))!==null?$ra:$this->config->getRecordsPerPage();}function
getEnumAsSelectThreshold(){$X=$this->getParameter("enumAsSelectThreshold");if($X<0)return
null;return$X!==null?(int)$X:$this->config->getEnumAsSelectThreshold();}}class
Hash{static
function
hkdf($u,$t,$qf="",$Rj=""){if(extension_loaded("hash")&&PHP_VERSION_ID>=70120)return
hash_hkdf("sha1",$t,$u,$qf,$Rj);if($Rj=="")$Rj=str_repeat("\0",20);$gj=self::hmacSha1($t,$Rj);$Jh="";for($Vf="",$cb=1;!isset($Jh[$u-1]);$cb++){$Vf=self::hmacSha1($Vf.$qf.chr($cb),$gj);$Jh
.=$Vf;}return
substr($Jh,0,$u);}static
function
hmacSha1($e,$t){if(!extension_loaded("hash"))return
hash_hmac("sha1",$e,$t,true);if(strlen($t)>64)$t=sha1($t,true);$t=str_pad($t,64,"\0");$Df=($t^str_repeat("\x36",64));$Rh=($t^str_repeat("\x5C",64));return
sha1($Rh.sha1($Df.$e,true),true);}}class
Random{static
function
strongKey(){return
strtr(rtrim(base64_encode(Random::bytes(32)),"="),"+/","-_");}static
function
bytes($u){if(PHP_VERSION_ID>=70000)return
random_bytes($u);$H=self::tryAlternatives($u);if($H!==false)return$H;$H=self::lastResortRandom($u);if($H!==false)return$H;throw
new
Exception("Error generating random bytes");}private
static
function
tryAlternatives($u){if(extension_loaded("libsodium"))return
\Sodium\randombytes_buf($u);$om=DIRECTORY_SEPARATOR==="/";if($om){$H=self::readDevUrandom($u);if($H!==false)return$H;}$gb=$om&&PHP_VERSION_ID>50609&&PHP_VERSION_ID<50613;if(extension_loaded("mcrypt")&&!$gb){$H=mcrypt_create_iv($u,MCRYPT_DEV_URANDOM);if($H!==false)return$H;}$hb=PHP_VERSION_ID<50444||(PHP_VERSION_ID>50500&&PHP_VERSION_ID<50528)||(PHP_VERSION_ID>50600&&PHP_VERSION_ID<50612);if(extension_loaded("openssl")&&!$hb){$H=openssl_random_pseudo_bytes($u,$Uk);if($Uk)return$H;}return
false;}private
static
function
readDevUrandom($u){static$l=null;if($l===null)$l=@fopen("/dev/urandom","rb");if(!$l)return
false;$Cj=$u;$H="";do{$e=fread($l,$Cj);if($e===false)return
false;$Cj-=strlen($e);$H
.=$e;}while($Cj>0);return$H;}private
static
function
readCapicom($u){$Ib=new
\COM("CAPICOM.Utilities.1");$Cj=$u;$H="";do{$e=base64_decode((string)$Ib->GetRandom($u,0));$Cj-=strlen($e);$H
.=$e;}while($Cj>0);return$H;}private
static
function
lastResortRandom($u){static$t=null;static$Rj=null;if($t===null){$e=$_SERVER;$e[]=uniqid("",true);shuffle($e);$t=sha1(serialize($e),true);if(extension_loaded("openssl"))$Rj=openssl_random_pseudo_bytes(20);else{$Rj="";for($p=0;$p<20;$p++)$Rj
.=chr((mt_rand()^mt_rand())%256);}}else{if((ord($t)%2===0)===(ord($Rj)%2===0))$t=Hash::hmacSha1($t,$Rj);else$Rj=Hash::hmacSha1($Rj,$t);}return
Hash::hkdf($u,$t,"$u",$Rj);}}if(!function_exists("str_starts_with")){function
str_starts_with($Me,$wh){return
strpos($Me,$wh)===0;}}if(!function_exists("str_contains")){function
str_contains($Me,$wh){return
strpos($Me,$wh)!==false;}}if(!function_exists("password_verify")){function
password_verify($E,$Le){return
false;}}if(!function_exists("ini_set")){function
ini_set($Xh,$X){return
false;}}function
version(){return
VERSION;}function
idf_unescape($df){if(!preg_match('~^[`\'"[]~',$df))return$df;$gg=substr($df,-1);return
str_replace($gg.$gg,$gg,substr($df,1,-1));}function
q($P){return
Connection::get()->quote($P);}function
number($W){return
preg_replace('~[^0-9]+~','',$W);}function
number_type(){return'((^|[^o])int(?!er)|numeric|real|float|double|decimal|money)';}function
remove_slashes(array$Y,$Wd=false){$I=[];foreach($Y
as$t=>$W)$I[stripslashes($t)]=(is_array($W)?remove_slashes($W,$Wd):($Wd?$W:stripslashes($W)));return$I;}function
bracket_escape($df,$Ua=false){static$Yl=[':'=>':1',']'=>':2','['=>':3','"'=>':4'];return
strtr($df,($Ua?array_flip($Yl):$Yl));}function
min_version($Jm,$Fg=null,$d=null){if(!$d)$d=Connection::get();if($Fg&&$d->isMariaDB())$Jm=$Fg;return$Jm&&$d->isMinVersion($Jm);}function
charset(Connection$d){return($d->isMinVersion("5.5.3")?"utf8mb4":"utf8");}function
link_files($_,array$Vd){switch($_){case'favicon-blue.ico':$m='favicon-blue-0f5ce53a66b1e25395d0048da369f19e__dc9919c6.ico';break;case'favicon-green.ico':$m='favicon-green-def78cfa7c465c8b0e9966e3eb87407d__dc9919c6.ico';break;case'favicon-orange.ico':$m='favicon-orange-cd68622e75276fdf7c60d1e9d4deee14__dc9919c6.ico';break;case'favicon-purple.ico':$m='favicon-purple-d4b02fdcc3abcc374a77c65f88513c01__dc9919c6.ico';break;case'favicon-red.ico':$m='favicon-red-c2ebb34a8df5aba28e15d87728a151df__dc9919c6.ico';break;case'favicon-blue.svg':$m='favicon-blue-17e440832c1eac07527560a0d6f0d2ee__dc9919c6.svg';break;case'favicon-green.svg':$m='favicon-green-bb254c95a033f67e3d433a3df63e160d__dc9919c6.svg';break;case'favicon-orange.svg':$m='favicon-orange-53ca3b502d7fb29f01bfbf87fc4d6b24__dc9919c6.svg';break;case'favicon-purple.svg':$m='favicon-purple-4cfd57d31ab991e8071fe34060cd3123__dc9919c6.svg';break;case'favicon-red.svg':$m='favicon-red-a006e401273230fd6be80568c8361b57__dc9919c6.svg';break;case'apple-touch-icon-blue.png':$m='apple-touch-icon-blue-f2a5f6f50418d7293b806faf273fe381__dc9919c6.png';break;case'apple-touch-icon-green.png':$m='apple-touch-icon-green-903cc109ea077cd9e91508416c5e335a__dc9919c6.png';break;case'apple-touch-icon-orange.png':$m='apple-touch-icon-orange-6efda14fd1d3c45382c67d7f324bdccf__dc9919c6.png';break;case'apple-touch-icon-purple.png':$m='apple-touch-icon-purple-2388fa66883b7c5e6b4cf5c795eae8fc__dc9919c6.png';break;case'apple-touch-icon-red.png':$m='apple-touch-icon-red-507228751d2170d047e72142d2c02390__dc9919c6.png';break;case'logo.svg':$m='logo-de272eb4bdca9c6fffd38c073270fb1a__9d7e398f.svg';break;case'jush.css':$m='jush-b3a93b18444da26820ff61746521dede__c1fc09bb.css';break;case'jush-dark.css':$m='jush-dark-f8dac59c6ad1018686e52a0e0357e421__2ec7793c.css';break;case'jush.js':$m='jush-9e355eb4d469abcfdb02830fb404cb16__e60c1fa7.js';break;case'icons.svg':$m='icons-70163a2695280bf75edba563e7b5471b__2ec7793c.svg';break;case'default-blue.css':$m='default-blue-e7acfdb81453b86f081569afa115859e__58308477.css';break;case'default-green.css':$m='default-green-268f042072e76ab07aa2fd0350e0aa0c__58308477.css';break;case'default-orange.css':$m='default-orange-e4e5ea626cdcbe83e07c7933dc04f916__58308477.css';break;case'default-purple.css':$m='default-purple-6b1de1f635d52b55797976fef486a515__58308477.css';break;case'default-red.css':$m='default-red-0f424ea89c2a43c6eb0ec8f0e22362a5__58308477.css';break;case'default-blue-dark.css':$m='default-blue-dark-1061ad7d216f143e3626560b92b66061__136f6b79.css';break;case'default-green-dark.css':$m='default-green-dark-6176b1c7b42ee9f244b3a9c3d8065728__136f6b79.css';break;case'default-orange-dark.css':$m='default-orange-dark-ef164a8d58dc89b2719f881377f73c89__136f6b79.css';break;case'default-purple-dark.css':$m='default-purple-dark-0f4fa03fa2d9287ef390780e90d9b06d__136f6b79.css';break;case'default-red-dark.css':$m='default-red-dark-3c1e28afe2cc92815bc7347df0d5776f__136f6b79.css';break;case'main.js':$m='main-0864f21d8576870afa2ea1b4d2bb6be8__169bbed7.js';break;default:$m=null;break;}if(!$m)return
null;return
BASE_URL."?file=".urldecode($m);}function
ini_bool($Xh){$W=ini_get($Xh);return
preg_match('~^(on|true|yes)$~i',$W)||(int)$W;}function
ini_bytes($sf){$W=ini_get($sf);switch(strtolower(substr($W,-1))){case'g':$W=(int)$W*1024;case'm':$W=(int)$W*1024;case'k':$W=(int)$W*1024;}return$W;}function
max_input_vars($J,$ni){$Ig=(int)ini_get("max_input_vars");return($Ig?(int)floor(($Ig-$ni)/$J):0);}function
max_input_vars_error(){$sf="max_input_vars";return
lang(103,"$sf = ".(int)ini_get($sf));}function
sid(){static$I;if($I===null)$I=(session_id()&&!($_COOKIE&&ini_bool("session.use_cookies")));return$I;}function
save_driver_name($Tc,$M,$_){restart_session();$_SESSION["drivers"][$Tc][$M]=$_;stop_session();}function
get_driver_name($Tc,$M=null){return
isset($_SESSION["drivers"][$Tc][$M])?$_SESSION["drivers"][$Tc][$M]:Drivers::get($Tc);}function
save_login($Tc,$M,$U,$E,$g=""){$t=isset($_COOKIE["neo_key"])?$_COOKIE["neo_key"]:null;$_SESSION["pwds"][$Tc][$M][$U]=$t?[encrypt_string($E,$t)]:$E;$_SESSION["db"][$Tc][$M][$U][$g]=true;}function
delete_login($Tc,$M,$U){unset($_SESSION["pwds"][$Tc][$M][$U]);unset($_SESSION["db"][$Tc][$M][$U]);}function
get_password(){$E=get_session("pwds");if(is_array($E))return$_COOKIE["neo_key"]?decrypt_string($E[0],$_COOKIE["neo_key"]):false;return$E;}function
get_vals($G,$b=0){$I=[];$H=Connection::get()->query($G);if(is_object($H)){while($J=$H->fetchRow())$I[]=$J[$b];}return$I;}function
get_key_vals($G,$d=null,$zk=true){if(!$d)$d=Connection::get();$I=[];$H=$d->query($G);if(is_object($H)){while($J=$H->fetchRow()){if($zk)$I[$J[0]]=$J[1];else$I[]=$J[0];}}return$I;}function
get_rows($G,$d=null,$i=""){if(!$d)$d=Connection::get();$I=[];$H=$d->query($G);if(is_object($H)){while($J=$H->fetchAssoc())$I[]=$J;}elseif(!$H&&!is_object($d)&&$i&&(defined("AdminNeo\PAGE_HEADER")||$i=="-- "))echo$i.error()."\n";return$I;}function
unique_array(array$J,array$s){foreach($s
as$r){if(!preg_match("~PRIMARY|UNIQUE~",$r["type"])&&!$r["partial"])continue;$lm=[];foreach($r["columns"]as$t){if(!isset($J[$t]))continue
2;$lm[$t]=$J[$t];}return$lm;}return
null;}function
escape_key($t){if(preg_match('(^([\w(]+)('.str_replace("_",".*",preg_quote(idf_escape("_"))).')([ \w)]+)$)',$t,$y))return$y[1].idf_escape(idf_unescape($y[2])).$y[3];return
idf_escape($t);}function
where($Z,$k=[]){$Sb=[];foreach((array)$Z["where"]as$t=>$W){$t=bracket_escape($t,true);$b=escape_key($t);$j=isset($k[$t])?$k[$t]:null;$Rd=isset($j["type"])?$j["type"]:null;$te=isset($j["full_type"])?$j["full_type"]:null;$Hf=$j&&(is_blob($j)||preg_match('~binary~',$Rd));if($Hf&&!is_utf8($W))$Sb[]="$b = ".Driver::get()->quoteBinary($W);elseif(DIALECT=="sql"&&$Rd=="json")$Sb[]="$b = CAST(".q($W)." AS JSON)";elseif(DIALECT=="pgsql"&&preg_match('~^jsonb?$~',$te))$Sb[]="$b::jsonb = ".q($W)."::jsonb";elseif(DIALECT=="sql"&&is_numeric($W)&&strpos($W,".")!==false)$Sb[]="$b LIKE ".q($W);elseif(DIALECT=="mssql"&&strpos($Rd,"datetime")===false)$Sb[]="$b LIKE ".q(preg_replace('~[_%[]~','[\0]',$W));else$Sb[]="$b = ".(isset($k[$t])?unconvert_field($k[$t],q($W)):q($W));if(DIALECT=="sql"&&preg_match('~char|text~',$Rd)&&preg_match("~[^ -@]~",$W))$Sb[]="$b = ".q($W)." COLLATE ".charset(Connection::get())."_bin";}foreach((array)$Z["null"]as$t)$Sb[]=escape_key($t)." IS NULL";return
implode(" AND ",$Sb);}function
where_columns($Z,$k=[]){$c=[];foreach((array)$Z["null"]as$t)$c[$t]=true;foreach((array)$Z["where"]as$t=>$W){$t=bracket_escape($t,true);foreach($k
as$_=>$j){if($t==$_||strpos($t,idf_escape($_))!==false)$c[$_]=true;}}return$c;}function
where_check($W,$k=[]){parse_str($W,$ob);remove_slashes([&$ob]);return
where($ob,$k);}function
where_link($p,$b,$X,$Uh="="){return"&where%5B$p%5D%5Bcol%5D=".urlencode($b)."&where%5B$p%5D%5Bop%5D=".urlencode(($X!==null?$Uh:"IS NULL"))."&where%5B$p%5D%5Bval%5D=".urlencode($X);}function
convert_fields(array$c,array$k,array$L=[]){$H="";foreach($c
as$t=>$W){if($L&&!in_array(idf_escape($t),$L))continue;$Ma=convert_field($k[$t]);if($Ma)$H
.=", $Ma AS ".idf_escape($t);}return$H;}function
cookie_path(){return
strtr(preg_replace('~\?.*~','',$_SERVER["REQUEST_URI"]),[";"=>"%3B",","=>"%2C"]);}function
cookie($_,$X,$qg=2592000){header("Set-Cookie: $_=".rawurlencode($X).($qg?"; expires=".gmdate("D, d M Y H:i:s",time()+$qg)." GMT":"")."; path=".cookie_path().(HTTPS?"; secure":"")."; HttpOnly; SameSite=lax",false);}function
get_url($um,$bc){$I=@file_get_contents($um,false,$bc);if(function_exists('http_get_last_response_headers'))$http_response_header=($ra=http_get_last_response_headers())!==null?$ra:[];return[$I,isset($http_response_header)?$http_response_header:[]];}function
get_settings($ec="neo_settings"){parse_str(isset($_COOKIE[$ec])?$_COOKIE[$ec]:"",$N);return$N;}function
get_setting($t,$ec="neo_settings"){$N=get_settings($ec);return
isset($N[$t])?$N[$t]:null;}function
save_settings(array$N,$ec="neo_settings"){cookie($ec,http_build_query($N+get_settings($ec)));}function
restart_session(){if(!ini_bool("session.use_cookies")&&session_status()==PHP_SESSION_NONE)session_start();}function
stop_session($he=false){$ym=ini_bool("session.use_cookies");if(!$ym||$he){session_write_close();if($ym&&ini_set("session.use_cookies","0")===false)session_start();}}function&get_session($t){return$_SESSION[$t][DRIVER][SERVER][$_GET["username"]];}function
set_session($t,$W){$_SESSION[$t][DRIVER][SERVER][$_GET["username"]]=$W;}function
auth_url($Im,$M,$U,$g=null){$tm=remove_from_uri(implode("|",array_keys(Drivers::getList()))."|username|ext|".($g!==null?"db|":"").($Im=='mssql'||$Im=='pgsql'?"":"ns|").session_name());preg_match('~([^?]*)\??(.*)~',$tm,$y);return"$y[1]?".(sid()?session_name()."=".urlencode(session_id())."&":"").urlencode($Im)."=".urlencode($M)."&".($_GET["ext"]?"ext=".urlencode($_GET["ext"])."&":"")."username=".urlencode($U).($g!=""?"&db=".urlencode($g):"").($y[2]?"&$y[2]":"");}function
is_ajax(){return($_SERVER["HTTP_X_REQUESTED_WITH"]=="XMLHttpRequest");}function
redirect($x,$Wg=null){if($Wg!==null){restart_session();$_SESSION["messages"][preg_replace('~^[^?]*~','',($x!==null?$x:$_SERVER["REQUEST_URI"]))][]=$Wg;}if($x!==null){if($x=="")$x=".";header("Location: $x");exit;}}function
query_redirect($G,$x,$Wg,$tj=true,$zd=true,$Id=false,$Ml=""){if($zd){$Rk=microtime(true);$Id=!Connection::get()->query($G);$Ml=format_time($Rk);}$Nk=$G?Admin::get()->formatMessageQuery($G,$Ml,$Id):"";if($Id){Admin::get()->addError(error().$Nk.script("initToggles();"));return
false;}if($tj)redirect($x,$Wg.$Nk);return
true;}function
queries_redirect($x,$Wg,$tj){$kj=implode("\n",Queries::$queries);$Ml=format_time(Queries::$start);return
query_redirect($kj,$x,$Wg,$tj,false,!$tj,$Ml);}class
Queries{static$queries=[];static$start=0.0;}function
queries($G){if(!Queries::$start)Queries::$start=microtime(true);if(support("sql")){Queries::$queries[]=(preg_match('~;$~',$G)?"DELIMITER ;;\n$G;\nDELIMITER ":$G).";";return
Connection::get()->query($G);}else{Queries::$queries[]=$G;return[];}}function
apply_queries($G,array$vl,$vd='AdminNeo\table'){foreach($vl
as$Q){if(!queries("$G ".$vd($Q)))return
false;}return
true;}function
format_time($Rk){return
lang(104,max(0,microtime(true)-$Rk));}function
relative_uri(){return
str_replace(":","%3a",preg_replace('~^[^?]*/([^?]*)~','\1',$_SERVER["REQUEST_URI"]));}function
remove_from_uri($ti=""){return
substr(preg_replace("~(?<=[?&])($ti".(sid()?"":"|".session_name()).")=[^&]*&~",'',relative_uri()."&"),0,-1);}function
get_file($t,$vc=false,$Ac=""){$l=$_FILES[$t];if(!$l)return
null;foreach($l
as$t=>$W)$l[$t]=(array)$W;$I='';foreach($l["error"]as$t=>$i){if($i)return$i;$_=$l["name"][$t];$Tl=$l["tmp_name"][$t];$Zb=file_get_contents($vc&&preg_match('~\.gz$~',$_)?"compress.zlib://$Tl":$Tl);if($vc){$Rk=substr($Zb,0,3);if(function_exists("iconv")&&preg_match("~^\xFE\xFF|^\xFF\xFE~",$Rk))$Zb=iconv("utf-16","utf-8",$Zb);elseif($Rk=="\xEF\xBB\xBF")$Zb=substr($Zb,3);}if($Ac){if(!preg_match("~$Ac\\s*\$~",$Zb))$Zb
.=";";$Zb
.="\n\n";}$I
.=$Zb;}return$I;}function
upload_error($i){$Qg=($i==UPLOAD_ERR_INI_SIZE?ini_get("upload_max_filesize"):0);return($i?lang(105).($Qg?" ".lang(106,$Qg):""):lang(107));}function
repeat_pattern($Ji,$u){return
str_repeat("$Ji{0,65535}",$u/65535)."$Ji{0,".($u%65535)."}";}function
is_utf8($W){return(preg_match('~~u',$W)&&!preg_match('~[\0-\x8\xB\xC\xE-\x1F]~',$W));}function
format_number($W){return
strtr(number_format($W,0,".",lang(108)),preg_split('~~u',lang(109),-1,PREG_SPLIT_NO_EMPTY));}function
format_rows(array$R){$K=$R["Rows"];$Ja=($K&&(DIALECT=="sqlite"||(isset($R["Engine"])?$R["Engine"]:"")==(DIALECT=="pgsql"?"table":"InnoDB")));return($Ja?"~ ":"").format_number($K);}function
friendly_url($W){return
preg_replace('~\W~i','-',$W);}function
table_status1($Q,$Kd=false){$I=table_status($Q,$Kd);return($I?reset($I):["Name"=>$Q]);}function
column_foreign_keys($Q){$I=[];foreach(Admin::get()->getForeignKeys($Q)as$n){foreach($n["source"]as$W)$I[$W][]=$n;}return$I;}function
fields_from_edit(){$I=[];foreach((array)$_POST["field_keys"]as$t=>$W){if($W!=""){$W=bracket_escape($W);$_POST["function"][$W]=$_POST["field_funs"][$t];$_POST["fields"][$W]=$_POST["field_vals"][$t];}}foreach((array)$_POST["fields"]as$t=>$W){$_=bracket_escape($t,true);$I[$_]=["field"=>$_,"full_type"=>"varchar","type"=>"varchar","privileges"=>["insert"=>1,"update"=>1,"where"=>1,"order"=>1],"null"=>true,"auto_increment"=>($t==Driver::get()->primary),];}return$I;}function
dump_headers($bf,$oh=false){$bf=friendly_url($bf).date("-Ymd-His");$Fd=Admin::get()->sendDumpHeaders($bf,$oh);$pi=$_POST["output"];if($pi!="text")header("Content-Disposition: attachment; filename=$bf.$Fd".($pi!="file"&&preg_match('~^[0-9a-z]+$~',$pi)?".$pi":""));session_write_close();if(!ob_get_level())ob_start(null,4096);ob_flush();flush();return$Fd;}function
dump_table_order(array$uh,array$zj){$Zf=array_flip($uh);$ci=[];$Rm=[];$nc=false;$Qm=function($_)use(&$Qm,&$ci,&$Rm,&$nc,$Zf,$zj){if(isset($ci[$_]))return;if(isset($Rm[$_])){$nc=true;return;}$Rm[$_]=true;foreach(isset($zj[$_])?$zj[$_]:[]as$xj){if(isset($Zf[$xj]))$Qm($xj);}unset($Rm[$_]);$ci[$_]=true;};foreach($uh
as$_)$Qm($_);return($nc?null:array_keys($ci));}function
dump_csv($J){$gm=$_POST["format"]=="tsv";foreach($J
as$t=>$W){if(preg_match('~["\n]|^0[^.]|\.\d*0$|'.($gm?'\t':'[,;]|^$').'~',$W))$J[$t]='"'.str_replace('"','""',$W).'"';}echo
implode(($_POST["format"]=="csv"?",":($gm?"\t":";")),$J)."\r\n";}function
apply_sql_function($o,$b){return($o?($o=="unixepoch"?"DATETIME($b, '$o')":($o=="count distinct"?"COUNT(DISTINCT ":strtoupper("$o("))."$b)"):$b);}function
get_temp_dir(){$Hi=ini_get("upload_tmp_dir");if(!$Hi)$Hi=sys_get_temp_dir();return$Hi;}function
open_file_with_lock($m){if(is_link($m))return
null;$l=@fopen($m,"c+");if(!$l)return
null;@chmod($m,0660);if(!flock($l,LOCK_EX)){fclose($l);return
null;}return$l;}function
write_and_unlock_file($l,$e){rewind($l);fwrite($l,$e);ftruncate($l,strlen($e));unlock_file($l);}function
unlock_file($l){flock($l,LOCK_UN);fclose($l);}function
first(array$La){return
reset($La);}function
get_private_key($gc){$m=get_temp_dir()."/adminneo.key";if(!$gc&&!file_exists($m))return
false;$l=open_file_with_lock($m);if(!$l)return
false;$t=stream_get_contents($l);if(!$t){$t=Random::strongKey();write_and_unlock_file($l,$t);}else
unlock_file($l);return$t;}function
get_random_string(){return
Random::strongKey();}function
select_value($W,$w,$j,$Il){if(is_array($W)){$I="";if(array_filter($W,'is_array')==array_values($W)){$Wf=[];foreach($W
as$V)$Wf+=array_fill_keys(array_keys($V),null);foreach(array_keys($Wf)as$Rf)$I
.="
".h($Rf);foreach($W
as$V){$I
.=" ";foreach(array_merge($Wf,$V)as$Cm)$I
.="".select_value($Cm,$w,$j,$Il);}}else{foreach($W
as$Rf=>$V)$I
.=" ".($W!=array_values($W)?"".h($Rf):"")." ".select_value($V,$w,$j,$Il);}return"";}$Wj="";if($j&&$W!==null&&($Il===null||strlen($W)<=$Il)&&($Y=Driver::get()->explodeArrayValue($W,$j["full_type"],$Wj))){$Vj=$j;$Vj["type"]=$Vj["full_type"]=$Wj;$I=select_array_value($Y,$W,$w,$Vj,$Il);return
Driver::get()->implodeArrayValues($I,$j["full_type"]);}if(!$w)$w=Admin::get()->getFieldValueLink($W,$j);if($j)$W=Connection::get()->formatValue($W,$j);$I=$j?Admin::get()->formatFieldValue($W,$j):$W;if($I!==null){if(!is_utf8($I))$I="\0";elseif($Il!=""&&is_shortable($j))$I=truncate_utf8($I,max(0,+$Il));else$I=h($I);}return
Admin::get()->formatSelectionValue($I,$w,$j,$W);}function
select_array_value(array$Y,$W,$w,array$j,$Il){$H=[];foreach($Y
as$X){if(is_array($X))$H[]=select_array_value($X,$W,$w,$j,$Il);else{$ag=preg_replace('~(where%5B\d+%5D%5Bval%5D=)'.preg_quote(urlencode($W),"~")."~",'${1}'.urlencode($X),$w);$H[]=select_value($X,$ag,$j,$Il);}}return$H;}function
is_blob(array$j){$im=Driver::get()->getStructuredTypes();$T=lang(110);return
preg_match('~blob|bytea|raw|file'.(DIALECT=="mssql"?'|binary|image':'').'~',$j["type"])&&!in_array($j["type"],isset($im[$T])?$im[$T]:[]);}function
is_generated_always(array$j){return(isset($j["generated"])?$j["generated"]:"")!=""||stripos((string)(isset($j["default"])?$j["default"]:""),"GENERATED ALWAYS AS ")===0;}function
is_mail($X){return
is_string($X)&&filter_var($X,FILTER_VALIDATE_EMAIL);}function
is_web_url($X){if(!is_string($X)||!preg_match('~^(https?:)?//~i',$X))return
false;$Pb=parse_url($X);if(!$Pb)return
false;$um=$X;if(isset($Pb['path'])){$nd=array_map('urlencode',explode('/',$Pb['path']));$um=str_replace($Pb['path'],implode('/',$nd),$um);}if(isset($Pb['query'])){parse_str($Pb['query'],$ui);$um=str_replace($Pb['query'],http_build_query($ui),$um);}if(!isset($Pb['scheme']))$um="https:$um";return(bool)filter_var($um,FILTER_VALIDATE_URL);}function
is_shortable($j){return$j&&!preg_match('~'.number_type().'|date|time|year~',$j["type"]);}function
host_port($M){return(preg_match('~^(:([^:].*)|(\[(.+)]|(([^:]+://)?[^:]+))(:(\d+))?)$~',$M,$y)?[(isset($y[4])?$y[4]:"").(isset($y[5])?$y[5]:""),$y[2].(isset($y[8])?$y[8]:"")]:[$M,'']);}function
count_rows($Q,$Z,$If,$_e){$G=" FROM ".table($Q).($Z?" WHERE ".implode(" AND ",$Z):"");return($If&&(DIALECT=="sql"||count($_e)==1)?"SELECT COUNT(DISTINCT ".implode(", ",$_e).")$G":"SELECT COUNT(*)".($If?" FROM (SELECT 1$G GROUP BY ".implode(", ",$_e).") x":$G));}function
slow_query($G){$g=Admin::get()->getDatabase();$Nl=Admin::get()->getQueryTimeout();$Fk=Driver::get()->slowQuery($G,$Nl);$d=null;if(!$Fk&&support("kill")){$d=connect();if($d&&($g==""||$d->selectDatabase($g))){$Xf=number($d->getValue(connection_id()));echo'
const timeout = setTimeout(() => {
ajax(\'',js_escape(ME),'script=kill\', function() {
}, \'kill=',$Xf,'&token=',get_token(),'\');
}, ',1000*$Nl,');
';}}ob_flush();flush();$I=@get_key_vals(($Fk?:$G),$d,false);if($d){echo
script("clearTimeout(timeout);");ob_flush();flush();}return$I;}function
get_token(){$pj=rand(1,1e6);return($pj^$_SESSION["token"]).":$pj";}function
verify_token(){list($Ul,$pj)=explode(":",$_POST["token"]);return($pj^$_SESSION["token"])==$Ul&&in_array($_SERVER["HTTP_SEC_FETCH_SITE"],["","same-origin"]);}function
script($Jk,$Xl="\n"){return"$Jk$Xl";}function
script_src($um,$zc=false){return"\n";}function
nonce(){return' nonce="'.get_nonce().'"';}function
input_hidden($_,$X=""){return"… ");}function
icon_solo($q){return
icon($q,"solo");}function
icon_chevron_down(){return
icon("chevron-down","chevron");}function
icon_chevron_right(){return
icon("chevron-down","chevron-right");}function
icon($q,$xb=null){$q=h($q);return"$I".h($bg)."":$I);}function
optionlist($B,$fk=null,$zm=false){$I="";foreach($B
as$Rf=>$V){$Zh=[$Rf=>$V];if(is_array($V)){$I
.='';$Zh=$V;}foreach($Zh
as$t=>$W)$I
.=''.h($W);if(is_array($V))$I
.=' ';}return$I;}function
html_select($_,$B,$X="",$Oh="",$dg="",$zm=false){static$bg=0;$cg="";if(!$dg&&substr(isset($B[""])?$B[""]:"",0,1)=="("){$bg++;$dg="label-$bg";$cg="".h($B[""]);unset($B[""]);}return"".$cg.optionlist($B,$X,$zm)." ".($Oh?script("qsl('select').onchange = function () { $Oh };",""):"");}function
html_radios($_,$B,$X=""){$H="";foreach($B
as$t=>$W)$H
.=" ";return$H;}function
confirm($Wg="",$hk="qsl('input')"){return
script("$hk.onclick = () => confirm('".js_escape($Wg?:lang(111))."');","");}function
print_fieldset_start($q,$mg,$af,$Om=false,$Hk=false){echo"","$mg ";}function
print_fieldset_end($q,$Hk=false){echo"
",script("initFieldset('$q');","");if($Hk)echo
script("initSortable('#fieldset-$q .fieldset-content');","");echo" \n";}function
bold($db,$xb=""){return($db?" class='$xb active'":($xb?" class='$xb'":""));}function
js_escape($P){return
str_replace("<","\\x3C",addcslashes($P,"\r\n'\\"));}function
js_escape_key($P){return'"'.str_replace("<","\\x3C",addcslashes($P,"\r\n\t\"\\")).'"';}function
js_escape_re($P){return
addcslashes(preg_quote($P,"/"),"\r\n");}function
pagination($D,$kc){return"".($D==$kc?"".($D+1)." ":''.($D+1)." ")." ";}function
print_hidden_fields(array$hj,array$ef=[],$Yi=""){$H=false;foreach($hj
as$t=>$W){if(!in_array($t,$ef)){if(is_array($W))print_hidden_fields($W,[],$t);else{$H=true;echo
input_hidden($Yi?$Yi."[$t]":$t,$W);}}}return$H;}function
hidden_fields_get(){if(sid())echo
input_hidden(session_name(),session_id());if(SERVER!==null)echo
input_hidden(DRIVER,SERVER);echo
input_hidden("username",$_GET["username"]);}function
enum_input($Na,array$j,$X,$kd=null,$rb=false){preg_match_all("~'((?:[^']|'')*)'~",$j["length"],$z);$Y=$z[1];$Ll=Admin::get()->getSettings()->getEnumAsSelectThreshold();$L=!$rb&&$Ll!==null&&count($Y)>$Ll;$T=$rb?"checkbox":"radio";$xa=$L?"selected":"checked";$H=$L?"":"";if($L&&$j["null"]&&$kd!==""){$sb=$X===null?$xa:"";$H
.="".lang(112)." ";else$H
.="".lang(112)." ".lang(112)." "):h(Admin::get()->formatFieldValue($W,$j));if($L)$H
.="$oe ";else$H
.=" ":"";return$H;}function
input($j,$X,$o,$Ra=false){$_=h(bracket_escape($j["field"]));$im=Driver::get()->getTypes();$Jf=isset($j["full_type"])&&Admin::get()->detectJson($j["full_type"],$X,true);$Dj=(DIALECT=="mssql"&&$j["auto_increment"]&&!$_POST["clone"]);if($Dj&&!$_POST["save"])$o=null;if(in_array($j["type"],Driver::get()->getUserTypes())){$sd=type_values($im[$j["type"]]);if($sd){$j["type"]="enum";$j["length"]=$sd;}}$Na=" name='fields[$_]' ".($Ra?" autofocus":"");$ve=(isset($_GET["select"])||$Dj?["orig"=>lang(113)]:[])+Admin::get()->getFieldFunctions($j);$Je=(in_array($o,$ve)||isset($ve[$o]));echo"",Driver::get()->getUnconvertFunction($j)." ";if(count($ve)>1){$fk=$o===null||$Je?$o:"";echo"".optionlist($ve,$fk)." ",help_script_command("value.replace(/^SQL\$/, '')",true),script("qsl('select').onchange = functionChange;","");}else
echo
h(reset($ve));echo" ";$tf=Admin::get()->getFieldInput(isset($_GET["edit"])?$_GET["edit"]:null,$j,$Na,$X,$o);if($tf!="")echo$tf;elseif(preg_match('~bool~',$j["type"]))echo"";foreach($z[1]as$W){$W=stripcslashes(str_replace("''","'",$W));$sb=$X!==null&&in_array($W,explode(",",$X),true);$sb=$sb?"checked":"";$oe=$W===""?("".lang(112)." "):h(Admin::get()->formatFieldValue($W,$j));echo" ";}elseif(is_blob($j)&&ini_bool("file_uploads"))echo"$Re ";if(count($ve)>1)echo
script("qs('select', qsl('td').previousSibling).onchange(null, true);","");$ae=0;foreach($ve
as$t=>$W){if($t===""||!$W)break;$ae++;}if(count($ve)>1)echo
script("qsl('td').oninput = partial(skipOriginal, $ae);");}function
process_input($j){if(is_generated_always($j))return
null;$df=bracket_escape($j["field"]);$o=isset($_POST["function"][$df])?$_POST["function"][$df]:"";if($o=="orig")return(preg_match('~^CURRENT_TIMESTAMP~i',$j["on_update"])?idf_escape($j["field"]):false);if($o=="NULL")return
Driver::get()->getNull();if(is_blob($j)&&ini_bool("file_uploads")){$l=get_file("fields-$df");if(!is_string($l))return
false;return
Driver::get()->quoteBinary($l);}$X=isset($_POST["fields"][$df])?$_POST["fields"][$df]:(isset($_FILES["fields"]["name"][$df])?$_FILES["fields"]["name"][$df]:null);if($X===null)return
false;if($j["auto_increment"]&&$X=="")return
null;if($j["type"]=="set")$X=implode(",",(array)$X);if($o=="json"){$X=json_decode($X,true);if(!is_array($X))return
false;return$X;}return
Admin::get()->processFieldInput($j,$X,$o);}function
search_tables(){$_GET["where"][0]["val"]=$_POST["query"];$Ij=$ud=[];foreach(table_status("",true)as$Q=>$R){$ol=Admin::get()->getTableName($R);if(!isset($R["Engine"])||$ol==""||($_POST["tables"]&&!in_array($Q,$_POST["tables"])))continue;$H=Connection::get()->query("SELECT".limit("1 FROM ".table($Q)," WHERE ".implode(" AND ",Admin::get()->processSelectionSearch(fields($Q),[])),1));if($H&&!$H->fetchRow())continue;$w=h(ME."select=".urlencode($Q)."&where[0][op]=".urlencode($_GET["where"][0]["op"])."&where[0][val]=".urlencode($_GET["where"][0]["val"]));if($H)$Ij[]="".icon("search")."$ol ".lang(78)."
\n";}function
help_script($Fl,$Ck=false){return
script("initHelpFor(qsl('select, input'), '".h($Fl)."', $Ck);","");}function
help_script_command($Jb,$Ck=false){return
script("initHelpFor(qsl('select, input'), (value) => { return $Jb; }, $Ck);","");}function
edit_form($Q,$k,$J,$sm){$ol=Admin::get()->getTableName(table_status1($Q,true));$S=$sm?lang(39):lang(114);page_header("$S: $ol",["select"=>[$Q,$ol],$S]);if($J===false){echo"".lang(91)."\n";return;}echo"
\n";}function
file_upload_form_script($le,$uf){$Kg=ini_get("max_file_uploads");$Qg=ini_get("upload_max_filesize");$Rg=ini_bytes("upload_max_filesize");return
script("initFilesUploadForm('".js_escape($le)."', '".js_escape($uf)."', "."$Kg, '".js_escape(lang(121,$Kg,"'max_file_uploads'"))."', "."$Rg, '".js_escape(lang(122,$Qg,"'upload_max_filesize'"))."')");}function
compress_alphabet(){return
strtr(implode(range('"','~')),"'\\","!\n");}function
decompress_string($P){$Ga=array_flip(str_split(compress_alphabet()));$u=strlen($P);$Fm=($u?13*($u-1)/2-$Ga[$P[0]]:0);$Za="";$Gj=0;$Hj=0;for($p=1;$p<$u;$p+=2){$Gj=($Gj<<13)+$Ga[$P[$p]]*93+$Ga[$P[$p+1]];$Hj+=13;while($Hj>=8&&$Fm>=8){$Hj-=8;$Fm-=8;$Za
.=chr($Gj>>$Hj);$Gj&=(1<<$Hj)-1;}}if($Za=="")return"";return
function_exists('gzinflate')?gzinflate($Za):inflate($Za);}function
inflate($Za){$ng=[3,4,5,6,7,8,9,10,11,13,15,17,19,23,27,31,35,43,51,59,67,83,99,115,131,163,195,227,258];$og=[0,0,0,0,0,0,0,0,1,1,1,1,2,2,2,2,3,3,3,3,4,4,4,4,5,5,5,5,0];$Mc=[1,2,3,4,5,7,9,13,17,25,33,49,65,97,129,193,257,385,513,769,1025,1537,2049,3073,4097,6145,8193,12289,16385,24577];$Oc=[0,0,0,0,1,1,2,2,3,3,4,4,5,5,6,6,7,7,8,8,9,9,10,10,11,11,12,12,13,13];$I="";$F=0;do{$Yd=inflate_bits($Za,$F,1);$T=inflate_bits($Za,$F,2);if(!$T){$F=($F+7)&~7;$u=inflate_bits($Za,$F,16);$F+=16;$I
.=substr($Za,$F>>3,$u);$F+=$u<<3;}else{if($T==1){$_g=array_merge(array_fill(0,144,8),array_fill(0,112,9),array_fill(0,24,7),array_fill(0,8,8));$Pc=array_fill(0,30,5);}else{$zg=inflate_bits($Za,$F,5)+257;$Nc=inflate_bits($Za,$F,5)+1;$C=[16,17,18,0,8,7,9,6,10,5,11,4,12,3,13,2,14,1,15];$ch=array_fill(0,19,0);$bh=inflate_bits($Za,$F,4)+4;for($p=0;$p<$bh;$p++)$ch[$C[$p]]=inflate_bits($Za,$F,3);$dh=inflate_table($ch);$pg=[];while(count($pg)<$zg+$Nc){$el=inflate_symbol($Za,$F,$dh);if($el==16)$pg=array_merge($pg,array_fill(0,inflate_bits($Za,$F,2)+3,end($pg)));elseif($el==17)$pg=array_merge($pg,array_fill(0,inflate_bits($Za,$F,3)+3,0));elseif($el==18)$pg=array_merge($pg,array_fill(0,inflate_bits($Za,$F,7)+11,0));else$pg[]=$el;}$_g=array_slice($pg,0,$zg);$Pc=array_slice($pg,$zg);}$Ag=inflate_table($_g);$Rc=inflate_table($Pc);while(($el=inflate_symbol($Za,$F,$Ag))!=256){if($el<256)$I
.=chr($el);else{$u=$ng[$el-257]+inflate_bits($Za,$F,$og[$el-257]);$Qc=inflate_symbol($Za,$F,$Rc);$Fh=strlen($I)-$Mc[$Qc]-inflate_bits($Za,$F,$Oc[$Qc]);for($p=0;$p<$u;$p++)$I
.=$I[$Fh+$p];}}}}while(!$Yd);return$I;}function
inflate_bits($Za,&$F,$fc){$I=0;for($p=0;$p<$fc;$p++){$I+=((ord($Za[$F>>3])>>($F&7))&1)<<$p;$F++;}return$I;}function
inflate_table(array$pg){$Q=[];$zb=0;for($ab=1;$ab<=max($pg);$ab++){foreach($pg
as$el=>$u){if($u==$ab){$Q[$ab][$zb]=$el;$zb++;}}$zb<<=1;}return$Q;}function
inflate_symbol($Za,&$F,array$Q){$zb=0;$ab=0;do{$zb=($zb<<1)+inflate_bits($Za,$F,1);$ab++;}while(!isset($Q[$ab][$zb]));return$Q[$ab][$zb];}if(isset($_GET["file"]))load_compiled_file($_GET["file"]);function
load_compiled_file($m){if($m==""){http_response_code(404);exit;}if($_SERVER["HTTP_IF_MODIFIED_SINCE"]){http_response_code(304);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");ini_set("zlib.output_compression","1");$Fd=pathinfo($m,PATHINFO_EXTENSION);switch($Fd){case"css":header("Content-Type: text/css; charset=utf-8");break;case"js":header("Content-Type: text/javascript; charset=utf-8");break;case"ico":header("Content-Type: image/x-icon");break;case"png":header("Content-Type: image/png");break;case"svg":header("Content-Type: image/svg+xml");break;}switch($m){case'favicon-blue-0f5ce53a66b1e25395d0048da369f19e__dc9919c6.ico':$e='AAABAAEAICAAAAEAIAC6AQAAFgAAAIlQTkcNChoKAAAADUlIRFIAAAAgAAAAIAgGAAAAc3p69AAAAYFJREFUeNrV1wEEGmEYh/FztCYBRATANhCAAEGAEGZowEUFhM2G6A4QAJksoMi2AYRlAxgcAUgthAS2yTFo5d2DDzbO6r2PhB9APY73z+cUn3+6qbsJcFGCjxlCbPHL2CLEDD5KcG0EPESAH5ArfUeAtDbgCb5BElrjsSbgI8SSD5qAM8SSsyZAbNIErCGWrDQBTYglTe0ZNnCAKB3gJR2iAnwsIBdawEchyRC9jompoYUe3hg9tFCL+dNX2ivo4wEcpTT6EF0AsEMHeTgXyqODnf4M489phC7aeGq00cUIK1s7sLr1DryEWPJCE5DBBJLQBJkkO9DAHnKlPbwkO/AMjuGijCGWiCD/iLDEEGW4f/2WIuA3qnBiZPHIyMKJUcVJe4ZHDJCDc6UcBjhqz/AEMSKMUf9PTA51jBFBAN0X+AKJEWGDr8YGESTGZ02AB7HE0wSk8B6S0DuktDvgYgRRegvXxsuogjnkQnNUrL8NUUSAKUL8NEJMEaB4x4/TG/gDMBOIUjRp9w0AAAAASUVORK5CYII=';break;case'favicon-green-def78cfa7c465c8b0e9966e3eb87407d__dc9919c6.ico':$e='AAABAAEAICAAAAEAIAC+AQAAFgAAAIlQTkcNChoKAAAADUlIRFIAAAAgAAAAIAgGAAAAc3p69AAAAYVJREFUeNpiYOhiAFBfBxBohGEcxs/RmgQQEQDbQAACBAFCmBDgogLCZkN0BwiATBZQZNsAgmwAgyMAuRZCAtvkGLTy7sEHcFbvfWT4AbjH8f75Huq/CXBRgY8lQuzx29gjxBI+KnBtBDxFgJ+QO/1AgKw24AW+Q1La4rkm4DPEkk+agCvEkqsmQKxSBGwhlkSagA7Eko72DNs4QZRO8NIOUQk+1pAbreGjlGaI3ibENNDFEO+MIbpoJHz0jfYKRngCRymLEUQXABzQRxHOjYro4wBJGwAAEaYYoIeXRg8DTBHZ2oHo0TvwGmLJK01ADnNISnPkFAEA2jhC7nSEl2YHmnAMF1VMsEEMAQDE2GCCKlw4RlMT8Ad1OAnyeGbk4SSo46I9wzPGKMC5UwFjnLVneIEYMWZo/SOmgBZmiCGA7g98hSSIscM3Y4cYkuCLJsCDWOJpAjL4CEnpAzLaHXAxhSi9h2vjZVTDCnKjFWqw/jYsI8ACIX4ZIRYIUMbfEW3maO8YAIxSqCXQN5/tAAAAAElFTkSuQmCC';break;case'favicon-orange-cd68622e75276fdf7c60d1e9d4deee14__dc9919c6.ico':$e='AAABAAEAICAAAAEAIAC7AQAAFgAAAIlQTkcNChoKAAAADUlIRFIAAAAgAAAAIAgGAAAAc3p69AAAAYJJREFUeNrV1wHkGnEUwPFztCYBRATANhCAAEGAEGbIwEUFhM2G6A4QAJksoMi2AQTZAAZHAEsthAS2yTFo5f2/OHCcv3v3I+EDcO/reI+f9fO1dVN3E2CjAhcL+NjjX2gPHwu4qMA2EfAUHv5AEvoND1ltwAv8gqS0xXNNwFeIIV80AVeIIVdNgBilCNhCDNloAtoQQ9raNWzhBFE6wUl7iEpwsUoweAUXpTSH6H1MTAMdDPAhNEAHjZih77RbMMQTWEpZDCG6AOCAHooJBhfRw0G/hvHrNEEfXbwMddHHBBtTd2Bz6zvwFmLIG01ADjNISjPk0tyBFo6QhI5w0tyBV7BCNqoYY40AEhFgjTGqsCPfShzwH3VYMfJ4FsrDilHHRbuGZ4xQgJVQASOctWt4ifzeKZooPDK0iSkCCKD7A98hMQLs8CO0iwyM+qYJcCCGOJqADD5DUvqEjPYO2JhAlD7CNvEyqmGZYPASNRh/G5bhYQ4ff0M+5vBQvrfH6W09ALYCTFLvUfsXAAAAAElFTkSuQmCC';break;case'favicon-purple-d4b02fdcc3abcc374a77c65f88513c01__dc9919c6.ico':$e='AAABAAEAICAAAAEAIAC6AQAAFgAAAIlQTkcNChoKAAAADUlIRFIAAAAgAAAAIAgGAAAAc3p69AAAAYFJREFUeNrV1wEEGmEYh/FztCYBRATANhCAAEGAEGYIcFEBYbMhugM0AJksoMi2AYRlAxgcAUgthAS2yTFo5d2DDzbO6r2PhB9APY73z+e8Ln66qbsJcFGCjxlCbPHL2CLEDD5KcG0EPESAH5ArfUeAtDbgCb5BElrjsSbgI8SSD5qAM8SSsyZAbNIErCGWrDQBTYglTe0ZNnCAKB3gJR2iAnwsIBdawEchyRC9iompoYUe3hg9tFCL+dOX2ivo4wEcpTT6EF0AsEMHeTgXyqODnf4M489phC7aeGq00cUIK1s7sLr1DryAWPJcE5DBBJLQBJkkO9DAHnKlPbwkO/AMjuGijCGWiCD/iLDEEGW4f/2WIuA3qnBiZPHIyMKJUcVJe4ZHDJCDc6UcBjhqz/AEMSKMUf9PTA51jBFBAN0X+AKJEWGDr8YGESTGZ02AB7HE0wSk8B6S0DuktDvgYgRRegvXxsuogjnkQnNUrL8NUUSAKUL8NEJMEaB4x4/TG/gD0xZAYUYkFLAAAAAASUVORK5CYII=';break;case'favicon-red-c2ebb34a8df5aba28e15d87728a151df__dc9919c6.ico':$e='AAABAAEAICAAAAEAIAC7AQAAFgAAAIlQTkcNChoKAAAADUlIRFIAAAAgAAAAIAgGAAAAc3p69AAAAYJJREFUeNrV1wHkGnEUwPFztCYBRAQY20AAAgQBQpghwEUFhM2G6A4QAJksoMi2AQTZBhgcAUgthAS2yTFo5f2/OHCcv3v3I+EDcO/reI+f9eOZdVN3E2CjAhcL+NjjX2gPHwu4qMA2EfAUHv5AEvoND1ltwEv8gqS0xQtNwFeIIV80AVeIIVdNgBilCNhCDNloAtoQQ9raNWzhBFE6wUl7iEpwsUoweAUXpTSH6H1MTAMdDPAhNEAHjZih77RbMMQTWEpZDCG6AOCAHooJBhfRw0G/hvHrNEEfXbwKddHHBBtTd2Bz6zvwFmLIG01ADjNISjPk0tyBFo6QhI5w0tyB17BCNqoYY40AEhFgjTGqsCPfShzwH3VYMfJ4HsrDilHHRbuGZ4xQgJVQASOctWt4ifzeKZooPDK0iSkCCKD7A98hMQLs8DO0iwyM+qYJcCCGOJqADD5DUvqEjPYO2JhAlD7CNvEyqmGZYPASNRh/G5bhYQ4ff0M+5vBQvrfH6W09AE8YAEN5XivhAAAAAElFTkSuQmCC';break;case'favicon-blue-17e440832c1eac07527560a0d6f0d2ee__dc9919c6.svg':$e='+]C6?xmhS1%06rQeBnDc14r_7Z0b9uqO=xV5=22d05hr#V]F`V>ZD,#JA9[$XEV-*TBfz7Z%
rEJw!G!cT+[7>-u:iVU)N$iv%ySN.`._&}sV@FUIuH)%cY-0#OXWPT8t./3Oid8~R]3?9n;/Qs
Y2!K`1Q9d
tys6C=xmJfXFCT%0xl`H&%njK7`N[.q6jET6kV
VqmiJoIrZ#rsP~q0vDNpAL]HDZf!uSL)$_)^vZ:Xk![_HKh=C|S~PjqHcgjUutq#-~?PmA#>d,^BJ&icL,/i,2N?:udHuPgxk>l07BF^82,>cspK:`^P,q[%?5=4<`h.?.kJ"X_a_mu|Z>-SL,/k)gDk#g):;if"T:5u9
?>JfFYF#KP)D%8xDljc2l^mJ<^%4+Iu=v?FB.Y^67X>9:@KMfCyqQL.-Kmn#DsAler%=^*ps8vI)CEG%8
bknN$znn
D-t3DO&3,C5<7r@2q],)F!d(nhsf)H-JU7?!^"9+Xtpm.q8>NCVHgU$kcVodiJa6[qLov!)IR#}x3*ku*P%3jGe?w?dILBVvhJ~,bFMpBcD%CK/#{0d-|Mu[Pn{fe.3aFbOf6.%,.opHOIuO9';break;case'favicon-orange-53ca3b502d7fb29f01bfbf87fc4d6b24__dc9919c6.svg':$e='&bw,v+Y%P7|fhq*F156s0beWd,6`ay=p@_gN3Z=jciDmX_i72]oyww{Z~&Ut4M]*axgl)b!a1ju/uH<*9Xo
=
Ul9*$m_7{*MB>d@6aDhpC0Rt_1D-,/u//bLNxN!Dc[m?bh@-`9rmyGW2b(F%J[Qafv1UZr>a>F6JA8g[!0b@[fJtmTv4e%TYc-0#j"5iK2z=wl
*E@MT<:>g}6hisx;^`kO(cefsRGicdC|"j9npLdO:cM^+&QT[{IL-Wu]3@7yXoO46wh/&9Sd+Vo~(7pzhcG()N3^n#?6MAX=Pd
]uX2I0XtRaah;-u5eKzydbLJw$UJhJ]
fe:Fe6mt>cu';break;case'favicon-purple-4cfd57d31ab991e8071fe34060cd3123__dc9919c6.svg':$e='+rM=td#VYm/o}bPN3Z=AH2GFCrK4TIrcvu65o!8H3d"9V^}B7s3mnUM&Wx87ya:7X
mAh1Y7Wu72FB8FRoD/k0uYFG=PV;h%?KNUP%#GQ^
2w"
SkNgvI0*kTGqx))i0|m-597vz$R_y_,ef$l~LS;5RSh?>{b"
&+evz;:0eol+,pv/]hQo|q*A;p{F69^H{
F#X:3c%4:=Hdpu{k&lMXV@E/#GL#?#)e-WHQiGP@.%eYsSRXBg!n9tO*z&WP*$Up~J1]E18NCC{!iER:u`UBQ5(*#viS-0S(llO)OsT0bALBjGk4Bt}3Hwkvp!81Fs-^5[}2H/0[(gXX++'English','id'=>'Bahasa Indonesia','ms'=>'Bahasa Melayu','bs'=>'Bosanski','ca'=>'Català','cs'=>'Čeština','da'=>'Dansk','de'=>'Deutsch','et'=>'Eesti','es'=>'Español','fr'=>'Français','gl'=>'Galego','hr'=>'Hrvatski','it'=>'Italiano','lv'=>'Latviešu','lt'=>'Lietuvių','ro'=>'Limba Română','hu'=>'Magyar','nl'=>'Nederlands','no'=>'Norsk','pl'=>'Polski','pt'=>'Português','pt-BR'=>'Português (Brazil)','sk'=>'Slovenčina','sl'=>'Slovenski','fi'=>'Suomi','sv'=>'Svenska','vi'=>'Tiếng Việt','tr'=>'Türkçe','bg'=>'Български','el'=>'Ελληνικά','ru'=>'Русский','sr'=>'Српски','uk'=>'Українська','he'=>'עברית','ar'=>'العربية','fa'=>'فارسی','hi'=>'हिन्दी','bn'=>'বাংলা','ta'=>'தமிழ்','th'=>'ภาษาไทย','ka'=>'ქართული','ja'=>'日本語','zh'=>'简体中文','zh-TW'=>'繁體中文','ko'=>'한국어',];private$language;private$translations;private
static$instance=null;static
function
create($fg){if(self::$instance)die(__CLASS__." instance already exists.\n");return
self::$instance=new
static($fg);}static
function
get(){if(!self::$instance)exit(__CLASS__." instance not found.\n");return
self::$instance;}protected
function
__construct($fg){$this->language=$fg;}function
getLanguage(){return$this->language;}function
setTranslations(array$am){$this->translations=$am;}function
getTranslations(){return$this->translations;}function
translate($t,$A=null){$t=$this->convertTranslationKey($t);$Zl=isset($this->translations[$t])?$this->translations[$t]:$t;$fg=$this->language;if(is_array($Zl)){$F=($A==1?0:($fg=='cs'||$fg=='sk'?($A&&$A<5?1:2):($fg=='fr'?(!$A?0:1):($fg=='pl'?($A%10>1&&$A%10<5&&$A/10%10!=1?1:2):($fg=='sl'?($A%100==1?0:($A%100==2?1:($A%100==3||$A%100==4?2:3))):($fg=='lt'?($A%10==1&&$A%100!=11?0:($A%10>1&&$A/10%10!=1?1:2)):($fg=='lv'?($A%10==1&&$A%100!=11?0:($A?1:2)):($fg=='ro'?(!$A||($A%100>0&&$A%100<20)?1:2):($fg=='bs'||$fg=='hr'||$fg=='ru'||$fg=='sr'||$fg=='uk'?($A%10==1&&$A%100!=11?0:($A%10>1&&$A%10<5&&$A/10%10!=1?1:2)):1)))))))));$Zl=$Zl[$F];}$Zl=str_replace("'",'’',$Zl);$Ka=func_get_args();array_shift($Ka);$me=str_replace("%d","%s",$Zl);if($me!=$Zl)$Ka[0]=format_number($A);return
vsprintf($me,$Ka);}function
convertTranslationKey($t){static$ld=null;if(is_string($t)){if(!$ld)$ld=get_translations("en");if(($r=array_search($t,$ld))!==false)$t=$r;elseif(($r=get_plural_translation_id($t))!==null)$t=$r;}return$t;}}function
get_available_languages(){return
array('en'=>true,);}function
get_lang(){return
Locale::get()->getLanguage();}function
lang($t,$A=null){return
call_user_func_array([Locale::get(),"translate"],func_get_args());}function
get_language_options(){$Sa=get_available_languages();if(count($Sa)==1)return[];$B=[];foreach(Locale::$Languages
as$fg=>$S){if(isset($Sa[$fg]))$B[$fg]=$S;}return$B;}function
language_select(){$B=get_language_options();if(!$B)return;echo"\n";}$Sa=get_available_languages();$fg=array_keys($Sa)[0];$Xi=null;if(isset($_POST["lang"])&&isset($Sa[$_POST["lang"]])&&verify_token()){$Xi=$_SESSION["lang"]=$_POST["lang"];$_SESSION["translations"]=[];}$Tj=($ra=Settings::readParameter("lang"))!==null?$ra:(isset($_COOKIE["neo_lang"])?$_COOKIE["neo_lang"]:null);if($Tj!==null&&isset($Sa[$Tj]))$fg=$Tj;elseif(isset($_SESSION["lang"])&&isset($Sa[$_SESSION["lang"]]))$fg=$_SESSION["lang"];elseif(isset($_SERVER["HTTP_ACCEPT_LANGUAGE"])){$ta=[];preg_match_all('~([-a-z]+)(;q=([0-9.]+))?~',str_replace("_","-",strtolower($_SERVER["HTTP_ACCEPT_LANGUAGE"])),$z,PREG_SET_ORDER);foreach($z
as$y)$ta[$y[1]]=(isset($y[3])?$y[3]:1);arsort($ta);foreach($ta
as$t=>$jj){if(isset($Sa[$t])){$fg=$t;break;}$t=preg_replace('~-.*~','',$t);if(!isset($ta[$t])&&isset($Sa[$t])){$fg=$t;break;}}}Locale::create($fg);abstract
class
Connection{protected$flavor=null;protected$version;protected$affectedRows=0;protected$errno=0;protected$error="";protected$multiResult;private
static$instance=null;static
function
create(){if(self::$instance)die(__CLASS__." instance already exists.\n");return
self::$instance=new
static();}static
function
createSecondary(){return
new
static();}static
function
get(){if(!self::$instance)exit(__CLASS__." instance not found.\n");return
self::$instance;}static
function
exists(){return
self::$instance!==null;}protected
function
__construct(){}function
getDefaultServerName(){return"";}function
openPasswordless($M,$U,$E,$Tk=true){$He=Admin::get()->getConfig()->getDefaultPasswordHash()!="";if($E!=""&&($Tk||$He)&&$this->open($M,$U,"")){$H=Admin::get()->verifyDefaultPassword($E);if($H!==true){$this->error=$H;return
false;}return
true;}return$this->open($M,$U,$E);}abstract
function
open($M,$U,$E);function
getFlavor(){return$this->flavor;}function
isMariaDB(){return$this->flavor=="mariadb";}function
isCockroachDB(){return$this->flavor=="cockroach";}function
getVersion(){return$this->version;}function
isMinVersion($Jm){return
version_compare($this->version,$Jm)>=0;}function
getAffectedRows(){return$this->affectedRows;}function
setAffectedRows($Aa){$this->affectedRows=$Aa;}function
getErrno(){return$this->errno;}function
getError(){return$this->error;}function
setError($i){$this->error=$i;}abstract
function
selectDatabase($_);abstract
function
quote($P);function
formatValue($X,array$j){return$X;}abstract
function
query($G,$jm=false);function
getQueryInfo(){return
null;}function
getResult($G,$j=0){return$this->getValue($G,$j);}function
getValue($G,$Md=0){$H=$this->query($G);if(!is_object($H))return
false;$J=$H->fetchRow();return$J?$J[$Md]:false;}function
multiQuery($G){$this->multiResult=$this->query($G);return(bool)($this->multiResult);}function
storeResult($H=null){return$this->multiResult;}function
nextResult(){return
false;}}abstract
class
Result{protected$rowsCount;function
__construct($Pj){$this->rowsCount=$Pj;}function
getRowsCount(){return$this->rowsCount;}abstract
function
fetchAssoc();abstract
function
fetchRow();abstract
function
fetchField();function
seek($Fh){return
false;}}if(extension_loaded('pdo')){abstract
class
PdoConnection
extends
Connection{protected$pdo;protected$multiResult;protected
function
dsn($Zc,$U,$E,array$B=[]){$B[PDO::ATTR_ERRMODE]=PDO::ERRMODE_SILENT;try{$this->pdo=new
PDO($Zc,$U,$E,$B);}catch(Exception$yd){$this->error=$yd->getMessage();return
false;}$this->version=preg_replace('~^\D*([\d.]+).*~',"$1",(string)@$this->pdo->getAttribute(PDO::ATTR_SERVER_VERSION));return
true;}function
quote($P){return$this->pdo->quote($P);}function
query($G,$jm=false){$Sk=$this->pdo->query($G);$this->error="";if(!$Sk){list(,$this->errno,$this->error)=$this->pdo->errorInfo();if(!$this->error)$this->error=lang(123);return
false;}$H=new
PdoResult($Sk);$this->storeResult($H);return$H;}function
storeResult($H=null){if(!$H){$H=$this->multiResult;if(!$H)return
false;}if($H->getColumnsCount())return$H;$this->affectedRows=$H->getAffectedRowsCount();return
true;}function
nextResult(){return$this->multiResult&&$this->multiResult->nextRowset();}}class
PdoResult
extends
Result{private$statement;private$offset=0;function
__construct(PDOStatement$Sk){parent::__construct(max($Sk->columnCount()?$Sk->rowCount():0,0));$this->statement=$Sk;}function
getColumnsCount(){return$this->statement->columnCount();}function
getAffectedRowsCount(){return$this->statement->rowCount();}function
fetchAssoc(){return$this->fetchArray(PDO::FETCH_ASSOC);}function
fetchRow(){return$this->fetchArray(PDO::FETCH_NUM);}private
function
fetchArray($ih){$H=$this->statement->fetch($ih);return$H?array_map([$this,'unresource'],$H):$H;}private
function
unresource($X){return
is_resource($X)?stream_get_contents($X):$X;}function
fetchField(){$J=$this->statement->getColumnMeta($this->offset++);if($J===false)return
false;$T=$J["pdo_type"];$J["type"]=($T==PDO::PARAM_INT?0:15);$J["charsetnr"]=($T==\PDO::PARAM_LOB||(isset($J["flags"])&&in_array("blob",(array)$J["flags"]))?63:0);return(object)$J;}function
seek($Fh){for($p=0;$p<$Fh;$p++){if($this->statement->fetch()===false)return
false;;}return
true;}function
nextRowset(){$this->offset=0;return@$this->statement->nextRowset();}}}class
Drivers{private
static$drivers=[];private
static$extensions=[];static
function
add($q,$_,array$Gd){self::$drivers[$q]=$_;self::$extensions[$q]=$Gd;}static
function
setName($q,$_){if(isset(self::$drivers[$q]))self::$drivers[$q]=$_;}static
function
get($q){return
isset(self::$drivers[$q])?self::$drivers[$q]:null;}static
function
getList(){return
self::$drivers;}static
function
getExtensions($q){return
isset(self::$extensions[$q])?self::$extensions[$q]:[];}}function
get_drivers(){return
Drivers::getList();}abstract
class
Driver{static$EnumLengthPattern="'(?:''|[^'\\\\]|\\\\.)*'";protected$connection;protected$admin;protected$types=[];protected$unsigned=[];protected$generated=[];protected$operators=[];protected$likeOperator="LIKE %%";protected$functions=[];protected$grouping=[];protected$inOut=["IN","OUT","INOUT"];protected$onActions=["RESTRICT","CASCADE","SET NULL","SET DEFAULT","NO ACTION"];protected$partitionBy=[];protected$insertFunctions=[];protected$editFunctions=[];protected$systemDatabases=[];protected$systemSchemas=[];private
static$instance=null;static
function
create(Connection$d,$za){if(self::$instance)die(__CLASS__." instance already exists.\n");return
self::$instance=new
static($d,$za);}static
function
get(){if(!self::$instance)exit(__CLASS__." instance not found.\n");return
self::$instance;}protected
function
__construct(Connection$d,$za){$this->connection=$d;$this->admin=$za;}function
getTypes(){return
call_user_func_array("array_merge",array_values($this->types));}function
getStructuredTypes(){return
array_map("array_keys",$this->types);}function
setUserTypes(array$im){$this->types[lang(110)]=array_flip($im);}function
getUserTypes(){$t=lang(110);return
array_keys(isset($this->types[$t])?$this->types[$t]:[]);}function
getUnsigned(){return$this->unsigned;}function
getGenerated(){return$this->generated;}function
getOperators(){return$this->operators;}function
getLikeOperator(){return$this->likeOperator;}function
getFunctions(){return$this->functions;}function
getGrouping(){return$this->grouping;}function
getInOut(){return$this->inOut;}function
getOnActions(){return$this->onActions;}function
getPartitionBy(){return$this->partitionBy;}function
getInsertFunctions(){return$this->insertFunctions;}function
getEditFunctions(){return$this->editFunctions;}function
getSystemDatabases(){return$this->systemDatabases;}function
getSystemSchemas(){return$this->systemSchemas;}function
getUnconvertFunction(array$j){return"";}function
select($Q,array$L,array$Z,array$_e,array$C=[],$v=1,$D=0,$dj=false){$If=(count($_e)connection->query($G);if($dj)echo
Admin::get()->formatSelectQuery($G,$Rk,!$I);return$I;}function
delete($Q,$mj,$v=0){$G="FROM ".table($Q);return
queries("DELETE".($v?limit1($Q,$G,$mj):" $G$mj"));}function
update($Q,array$rj,$mj,$v=0,$kk="\n"){$Y=[];foreach($rj
as$t=>$W)$Y[]="$t = $W";$G=table($Q)." SET$kk".implode(",$kk",$Y);return
queries("UPDATE".($v?limit1($Q,$G,$mj,$kk):" $G$mj"));}function
insert($Q,array$rj){return
queries("INSERT INTO ".table($Q).($rj?" (".implode(", ",array_keys($rj)).")\nVALUES (".implode(", ",$rj).")":" DEFAULT VALUES").$this->getInsertReturningSql($Q));}function
getInsertReturningSql($Q){return"";}function
insertUpdate($Q,array$sj,array$cj){return
false;}function
begin(){return
queries("BEGIN");}function
commit(){return
queries("COMMIT");}function
rollback(){return
queries("ROLLBACK");}function
slowQuery($G,$Nl){return
null;}function
convertSearch($df,array$Z,array$j){return$df;}function
getNull(){return"NULL";}function
getTypeName(stdClass$j){return
isset($j->native_type)?$j->native_type:"";}function
quoteBinary($P){return
q($P);}function
warnings(){return
null;}function
tableHelp($_,$Gf=false){return
null;}function
supportsIndex(array$ll){return!is_view($ll);}function
getIndexAlgorithms(array$ll){return[];}function
getIndexOpclasses(){return[];}function
getInheritedTables($Q){return[];}function
getParentTables($Q){return[];}function
isPartition($Q){return
false;}function
getPartitionsInfo($Q){return[];}function
hasCStyleEscapes(){return
false;}function
engines(){return[];}function
explodeArrayValue($X,$T,&$Uj){return[];}function
implodeArrayValues(array$Y,$T){return"";}function
checkConstraints($Q){return
get_key_vals("SELECT c.CONSTRAINT_NAME, CHECK_CLAUSE
FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS c
JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON c.CONSTRAINT_SCHEMA = t.CONSTRAINT_SCHEMA
AND c.CONSTRAINT_NAME = t.CONSTRAINT_NAME".($this->connection->isMariaDB()?" AND c.TABLE_NAME = ".q($Q):"")."
WHERE c.CONSTRAINT_SCHEMA = ".q($_GET["ns"]!=""?$_GET["ns"]:DB)."
AND t.TABLE_NAME = ".q($Q).(DIALECT=="pgsql"?"
AND CHECK_CLAUSE NOT LIKE '% IS NOT NULL'":""),$this->connection);}function
getAllFields(){if(DB=="")return[];$Da=[];$Pf=(DIALECT=="pgsql"||DIALECT=="mssql");$cj=(DIALECT=="sql"?"c.COLUMN_KEY = 'PRI'":($Pf?"k.COLUMN_NAME":""));$K=get_rows("SELECT c.TABLE_NAME AS tab, c.COLUMN_NAME AS field, c.IS_NULLABLE AS nullable,
c.DATA_TYPE AS type, c.CHARACTER_MAXIMUM_LENGTH AS length".($cj?",
$cj AS ".idf_escape("primary"):"")."
FROM INFORMATION_SCHEMA.COLUMNS c".($Pf?"
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t
ON c.TABLE_SCHEMA = t.TABLE_SCHEMA AND c.TABLE_NAME = t.TABLE_NAME AND t.CONSTRAINT_TYPE = 'PRIMARY KEY'
LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE k
ON t.CONSTRAINT_SCHEMA = k.CONSTRAINT_SCHEMA AND t.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_SCHEMA = k.TABLE_SCHEMA AND c.TABLE_NAME = k.TABLE_NAME AND c.COLUMN_NAME = k.COLUMN_NAME":"")."
WHERE c.TABLE_SCHEMA = ".q($_GET["ns"]!=""?$_GET["ns"]:DB)."
ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION",$this->connection);foreach($K
as$J){$J["null"]=($J["nullable"]=="YES");$Da[$J["tab"]][]=$J;}return$Da;}}Drivers::add("pgsql","PostgreSQL",["PgSQL","PDO_PgSQL"]);if(isset($_GET["pgsql"])){define("AdminNeo\DRIVER","pgsql");define("AdminNeo\DIALECT","pgsql");if(extension_loaded("pgsql")&&$_GET["ext"]!="pdo"){define("AdminNeo\DRIVER_EXTENSION","PgSQL");class
PgSqlConnectionBase
extends
Connection{var$timeout=0;private$connection;private$connectionString;private$hasDefaultDatabase;function
open($M,$U,$E){$g=Admin::get()->getDatabase();set_error_handler(function($td,$i){if(ini_bool("html_errors"))$i=html_entity_decode(strip_tags($i));$i=preg_replace('~^[^:]*: ~','',$i);$this->error=$i;});list($We,$Si)=host_port($M);$this->connectionString=($We!=""?"host=$We ":"").($Si?"port=$Si ":"")."user='".addcslashes($U,"'\\")."' password='".addcslashes($E,"'\\")."'";$Qk=Admin::get()->getConfig()->getSslMode();if($Qk)$this->connectionString
.=" sslmode='$Qk'";$this->connection=@pg_connect("$this->connectionString dbname='".($g!=""?addcslashes($g,"'\\"):"postgres")."'",PGSQL_CONNECT_FORCE_NEW);if(!$this->connection&&$g!=""){$this->hasDefaultDatabase=false;$this->connection=@pg_connect("$this->connectionString dbname='postgres'",PGSQL_CONNECT_FORCE_NEW);}else$this->hasDefaultDatabase=true;restore_error_handler();if($this->connection){$Km=$this->getValue("SELECT version()");$this->flavor=str_contains($Km,"CockroachDB")?"cockroach":null;$this->version=preg_replace('~^\D*([\d.]+[-\w]*).*~',"$1",$Km);pg_set_client_encoding($this->connection,"UTF8");}return(bool)$this->connection;}function
quote($P){return(function_exists('pg_escape_literal')?pg_escape_literal($this->connection,$P):"'".pg_escape_string($this->connection,$P)."'");}function
formatValue($X,array$j){if($j["type"]=="bytea"&&$X!==null)return
pg_unescape_bytea($X);return
parent::formatValue($X,$j);}function
selectDatabase($_){if($_==Admin::get()->getDatabase())return$this->hasDefaultDatabase;$I=@pg_connect("$this->connectionString dbname='".addcslashes($_,"'\\")."'",PGSQL_CONNECT_FORCE_NEW);if($I)$this->connection=$I;return(bool)$I;}function
close(){$this->connection=@pg_connect("$this->connectionString dbname='postgres'");}function
query($G,$jm=false){if(!$this->connection){$this->error="Invalid connection.";return
false;}$H=@pg_query($this->connection,$G);$this->error="";if(!$H){$this->error=pg_last_error($this->connection);$I=false;}elseif(!pg_num_fields($H)){$this->affectedRows=pg_affected_rows($H);$I=true;}else$I=new
PgSqlResult($H);if($this->timeout){$this->timeout=0;$this->query("RESET statement_timeout");}return$I;}function
getValue($G,$Md=0){$H=$this->query($G);return
is_object($H)?$H->fetchValue($Md):false;}function
warnings(){if(PHP_VERSION_ID>=70100){$Tm=pg_last_notice($this->connection,PGSQL_NOTICE_ALL);if(!$Tm)return
null;$Tm=implode("\n",$Tm);pg_last_notice($this->connection,PGSQL_NOTICE_CLEAR);}else{$Tm=pg_last_notice($this->connection);if(!$Tm)return
null;}return
nl2br(h($Tm));}function
copyFrom($Q,array$K){$this->error="";set_error_handler(function($td,$i){$this->error=ini_bool("html_errors")?html_entity_decode($i):$i;});$H=pg_copy_from($this->connection,$Q,$K);restore_error_handler();return$H;}}class
PgSqlResult
extends
Result{private$resource;private$offset=0;function
__construct($Fj){parent::__construct(pg_num_rows($Fj));$this->resource=$Fj;}function
fetchAssoc(){return
pg_fetch_assoc($this->resource);}function
fetchRow(){return
pg_fetch_row($this->resource);}function
fetchValue($Md){return$this->getRowsCount()?pg_fetch_result($this->resource,0,$Md):false;}function
fetchField(){$b=$this->offset++;$_=pg_field_name($this->resource,$b);if($_===false)return
false;$T=pg_field_type($this->resource,$b);if($T===false)return
false;$fi=pg_field_table($this->resource,$b);return(object)['orgtable'=>($fi!==false?$fi:""),'name'=>$_,'native_type'=>$T,'type'=>(preg_match(number_type(),$T)?0:15),'charsetnr'=>($T=="bytea"?63:0),];}}}elseif(extension_loaded("pdo_pgsql")){define("AdminNeo\DRIVER_EXTENSION","PDO_PgSQL");class
PgSqlConnectionBase
extends
PdoConnection{var$timeout=0;function
open($M,$U,$E){$g=Admin::get()->getDatabase();list($We,$Si)=host_port($M);$Zc="pgsql:".($We!=""?"host=$We ":"").($Si?"port=$Si ":"")."client_encoding=utf8 dbname='".($g!=""?addcslashes($g,"'\\"):"postgres")."'";$Qk=Admin::get()->getConfig()->getSslMode();if($Qk)$Zc
.=" sslmode='$Qk'";if(!$this->dsn($Zc,$U,$E))return
false;$Km=$this->getValue("SELECT version()");$this->flavor=str_contains($Km,"CockroachDB")?"cockroach":null;return
true;}function
selectDatabase($_){return
Admin::get()->getDatabase()==$_;}function
query($G,$jm=false){$I=parent::query($G,$jm);if($this->timeout){$this->timeout=0;parent::query("RESET statement_timeout");}return$I;}function
warnings(){return
null;}function
copyFrom($Q,array$K){$H=$this->pdo->pgsqlCopyFromArray($Q,$K);$ud=$this->pdo->errorInfo();$this->error=isset($ud[2])?$ud[2]:"";return$H;}function
close(){}}}if(class_exists('AdminNeo\PgSqlConnectionBase')){class
PgSqlConnection
extends
PgSqlConnectionBase{private$localhostServer=false;function
open($M,$U,$E){if($M=="localhost")$this->localhostServer=true;return
parent::open($M,$U,$E);}function
getDefaultServerName(){return$this->localhostServer?"localhost":"";}function
multiQuery($G){if(preg_match('~\bCOPY\s+(.+?)\s+FROM\s+stdin;\n?(.*)\n\\\\\.$~is',str_replace("\r\n","\n",$G),$z)){$K=explode("\n",$z[2]);$this->affectedRows=count($K);return$this->copyFrom($z[1],$K);}return
parent::multiQuery($G);}}}class
PgSqlDriver
extends
Driver{protected
function
__construct(Connection$d,$za){parent::__construct($d,$za);$this->types=[lang(124)=>["smallint"=>5,"integer"=>10,"bigint"=>19,"boolean"=>1,"numeric"=>0,"real"=>7,"double precision"=>16,"money"=>20,],lang(125)=>["date"=>13,"time"=>17,"timestamp"=>20,"timestamptz"=>21,"interval"=>0,],lang(126)=>["character"=>0,"character varying"=>0,"text"=>0,"tsquery"=>0,"tsvector"=>0,"uuid"=>0,"xml"=>0,],lang(127)=>["bit"=>0,"bit varying"=>0,"bytea"=>0,],lang(128)=>["cidr"=>43,"inet"=>43,"macaddr"=>17,"macaddr8"=>23,"txid_snapshot"=>0,],lang(129)=>["box"=>0,"circle"=>0,"line"=>0,"lseg"=>0,"path"=>0,"point"=>0,"polygon"=>0,],];if($d->isMinVersion("9.2")){$this->types[lang(126)]["json"]=4294967295;if($d->isMinVersion("9.4"))$this->types[lang(126)]["jsonb"]=4294967295;}if($d->isMinVersion("12")){$this->generated[]="STORED";if($d->isMinVersion("18"))$this->generated[]="VIRTUAL";}$this->operators=["=","<",">","<=",">=","!=","~","~*","!~","!~*","LIKE","LIKE %%","NOT LIKE","ILIKE","ILIKE %%","NOT ILIKE","IN","NOT IN","IS NULL","IS NOT NULL","SQL",];$this->functions=["char_length","lower","upper","round","to_hex","to_timestamp",];$this->grouping=["sum","min","max","avg","count","count distinct",];$this->partitionBy=["RANGE","LIST"];if(!$d->isCockroachDB())$this->partitionBy[]="HASH";$this->insertFunctions=["char"=>"md5","date|time"=>"now",];$this->editFunctions=[number_type()=>"+/-","date|time"=>"+ interval/- interval","char|text"=>"||",];$this->systemDatabases=["template1"];$this->systemSchemas=["information_schema","pg_catalog","pg_toast","pg_temp_*","pg_toast_temp_*"];}function
getNsOidSql(){return"(SELECT oid FROM pg_namespace WHERE nspname = current_schema())";}function
getInsertReturningSql($Q){$Pa=array_filter(fields($Q),function($j){return$j['auto_increment'];});return
count($Pa)==1?" RETURNING ".idf_escape(key($Pa)):"";}function
insertUpdate($Q,array$sj,array$cj){foreach($sj
as$rj){$sm=[];$Z=[];foreach($rj
as$t=>$W){$sm[]="$t = $W";if(isset($cj[idf_unescape($t)]))$Z[]="$t = $W";}if(!(($Z&&queries("UPDATE ".table($Q)." SET ".implode(", ",$sm)." WHERE ".implode(" AND ",$Z))&&Connection::get()->getAffectedRows())||queries("INSERT INTO ".table($Q)." (".implode(", ",array_keys($rj)).") VALUES (".implode(", ",$rj).")")))return
false;}return
true;}function
slowQuery($G,$Nl){$this->connection->query("SET statement_timeout = ".(1000*$Nl));$this->connection->timeout=1000*$Nl;return$G;}function
convertSearch($df,array$Z,array$j){$Hl="char|text";if(strpos($Z["op"],"LIKE")===false)$Hl
.="|date|time(stamp)?|boolean|uuid|inet|cidr|macaddr|".number_type();return(preg_match("~$Hl~",$j["type"])?$df:"CAST($df AS text)");}function
quoteBinary($P){return"'\\x".bin2hex($P)."'";}function
warnings(){return$this->connection->warnings();}function
tableHelp($_,$Gf=false){$wg=["information_schema"=>"infoschema","pg_catalog"=>($Gf?"view":"catalog"),];$w=$wg[$_GET["ns"]];if($w)return"$w-".str_replace("_","-",$_).".html";return
null;}function
getInheritedTables($Q){return
get_rows("SELECT relname AS \"table\", nspname AS ns
FROM pg_inherits
JOIN pg_class ON inhrelid = oid
JOIN pg_namespace ON relnamespace = pg_namespace.oid
WHERE inhparent = ".$this->tableOid($Q).(Connection::get()->isMinVersion("10")?" AND relispartition::int = 0":"")." ORDER BY 2, 1");}function
getParentTables($Q){return
get_rows("SELECT relname AS \"table\", nspname AS ns
FROM pg_class
JOIN pg_inherits ON inhparent = oid
JOIN pg_namespace ON relnamespace = pg_namespace.oid
WHERE inhrelid = ".$this->tableOid($Q)." ORDER BY 2, 1");}function
isPartition($Q){return
Connection::get()->isMinVersion("10")&&$this->connection->getValue("SELECT relispartition::int FROM pg_class WHERE oid = ".$this->tableOid($Q));}function
getPartitionsInfo($Q){if(!$this->connection->isMinVersion("10"))return[];$J=$this->connection->query("SELECT * FROM pg_partitioned_table WHERE partrelid = ".$this->tableOid($Q))->fetchAssoc();if(!$J)return[];$Na=get_vals("SELECT attname FROM pg_attribute WHERE attrelid = {$J["partrelid"]} AND attnum IN (".str_replace(" ",", ",$J["partattrs"]).")");$ib=['h'=>'HASH','l'=>'LIST','r'=>'RANGE'];$qf=["partition_by"=>$ib[$J["partstrat"]],"partition"=>implode(", ",array_map('AdminNeo\idf_escape',$Na)),];$Ei=get_key_vals("SELECT relname, pg_get_expr(c.relpartbound, c.oid) AS bound
FROM pg_inherits
JOIN pg_class c ON inhrelid = oid
WHERE inhparent = ".$this->tableOid($Q)." ORDER BY 1");$qf["partition_names"]=array_keys($Ei);$qf["partition_values"]=array_map(function($X){return
str_replace("FOR VALUES ","",$X);},array_values($Ei));return$qf;}function
tableOid($Q){return"(SELECT oid FROM pg_class WHERE relnamespace = ".$this->getNsOidSql()." AND relname = ".q($Q)." AND relkind IN ('r', 'm', 'v', 'f', 'p'))";}function
getIndexAlgorithms(array$ll){static$fh=[];if(!$fh)$fh=get_vals("SELECT amname FROM pg_am".($this->connection->isMinVersion("9.6")?" WHERE amtype = 'i'":"")." ORDER BY amname = '".($this->connection->isCockroachDB()?"prefix":"btree")."' DESC, amname");return$fh;}function
getIndexOpclasses(){static$Th=[];if(!$Th&&!$this->connection->isCockroachDB())$Th=get_vals("SELECT DISTINCT opcname FROM pg_catalog.pg_opclass WHERE NOT opcdefault ORDER BY opcname");return$Th;}function
supportsIndex(array$ll){return$ll["Engine"]!="view";}function
hasCStyleEscapes(){static$jb;if($jb===null)$jb=($this->connection->getValue("SHOW standard_conforming_strings")=="off");return$jb;}function
explodeArrayValue($X,$T,&$Uj){$Hm=["oidvector"=>"oid","int2vector"=>"smallint",];$Uj=isset($Hm[$T])?$Hm[$T]:null;if($Uj)return
explode(" ",$X);if(preg_match('~^(.+)\[]$~',$T,$z)){$Uj=$z[1];$X=preg_replace('~^\{(.*)}$~',"$1",$X);$Ef=str_contains($Uj,"json");if($Ef){$Y=explode('","',trim($X,'"'));array_walk($Y,function(&$V){$V=str_replace('\"','"',$V);});}elseif(preg_match('~^(\{+)(.*)(}+)$~',$X,$z)){$Y=explode("$z[3],$z[1]",$z[2]);array_walk($Y,function(&$V)use($z){$V=$z[1].$V.$z[3];});}else$Y=explode(",",$X);if(!$Ef&&$Y[0][0]=="{"){$T=$Uj;array_walk($Y,function(&$V)use($T,&$Uj){$V=$this->explodeArrayValue($V,$T,$Uj);});}elseif(!$Ef&&isset($this->types[lang(126)][$Uj])){array_walk($Y,function(&$V){$V=preg_replace('~^\'(.*)\'$~',"$1",$V);});}return$Y;}return[];}function
implodeArrayValues(array$Y,$T){if($T=="oidvector"||$T=="int2vector")return
implode(" ",$Y);if(preg_match('~^([^[]+)(\[])+$~',$T,$z)){$Ff=isset($this->types[lang(126)][$z[1]]);$Ef=str_contains($T,"json");array_walk($Y,function(&$V)use($T,$Ff,$Ef){if(is_array($V))$V=$this->implodeArrayValues($V,$T);elseif($Ef)$V="\"$V\"";elseif($Ff)$V="'$V'";});return"{".implode(",",$Y)."}";}return"";}}function
create_driver(Connection$d){return
PgSqlDriver::create($d,Admin::get());}function
idf_escape($df){return'"'.str_replace('"','""',$df).'"';}function
table($df){return
idf_escape($df);}function
connect($cj=false,&$i=null){$d=$cj?PgSqlConnection::create():PgSqlConnection::createSecondary();list($M,$U,$E)=Admin::get()->getCredentials();$H=$d->openPasswordless($M,$U,$E,false);$ud=[];if(!$H&&$M==""&&preg_match('~connection to server on socket .+ failed: No such file or directory~U',$d->getError())){$ud[]=$d->getError();$M="localhost";$H=$d->openPasswordless($M,$U,$E,false);}if(!$H){$ud[]=$d->getError();$i=implode("\n",$ud);return
null;}if($d->isMinVersion("9"))$d->query("SET application_name = 'AdminNeo'");if($cj&&$d->isCockroachDB()){Drivers::setName(DRIVER,"CockroachDB");save_driver_name(DRIVER,$M,"CockroachDB");}return$d;}function
get_databases($ge){return
get_vals("SELECT datname FROM pg_database
WHERE datallowconn = TRUE AND has_database_privilege(datname, 'CONNECT')
ORDER BY datname");}function
limit($G,$Z,$v,$Fh=0,$kk=" "){return" $G$Z".($v?$kk."LIMIT $v".($Fh?" OFFSET $Fh":""):"");}function
limit1($Q,$G,$Z,$kk="\n"){return(preg_match('~^INTO~',$G)?limit($G,$Z,1,0,$kk):" $G".(is_view(table_status1($Q))?$Z:$kk."WHERE ctid = (SELECT ctid FROM ".table($Q).$Z.$kk."LIMIT 1)"));}function
db_collation($g,array$Cb){return
Connection::get()->getValue("SELECT datcollate FROM pg_database WHERE datname = ".q($g));}function
logged_user(){return
Connection::get()->getValue("SELECT user");}function
tables_list(){$G="SELECT table_name, table_type FROM information_schema.tables WHERE table_schema = current_schema()";if(support("materializedview"))$G
.="
UNION ALL
SELECT matviewname, 'MATERIALIZED VIEW'
FROM pg_matviews
WHERE schemaname = current_schema()";$G
.="
ORDER BY 1";return
get_key_vals($G);}function
count_tables(array$f){$I=[];foreach($f
as$g){if(Connection::get()->selectDatabase($g))$I[$g]=count(tables_list());}return$I;}function
table_status($_="",$Kd=false){static$Ke;if($Ke===null)$Ke=Connection::get()->getValue("SELECT 'pg_table_size'::regproc");$I=[];foreach(get_rows("SELECT
relname AS \"Name\",
CASE relkind WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' ELSE 'table' END AS \"Engine\",
CASE relkind WHEN 'p' THEN 'partitioned' ELSE '' END AS \"Create_options\"".($Ke?",
pg_table_size(c.oid) AS \"Data_length\",
pg_indexes_size(c.oid) AS \"Index_length\"":"").",
obj_description(c.oid, 'pg_class') AS \"Comment\",
".(Connection::get()->isMinVersion("12")?"''":"CASE WHEN relhasoids THEN 'oid' ELSE '' END")." AS \"Oid\",
reltuples AS \"Rows\",
".(Connection::get()->isMinVersion("10")?"relispartition::int AS \"Partition\",":"")."
current_schema() AS nspname
FROM pg_class c
WHERE relkind IN ('r', 'm', 'v', 'f', 'p')
AND relnamespace = ".Driver::get()->getNsOidSql()."
".($_!=""?"AND relname = ".q($_):"ORDER BY relname"))as$J)$I[$J["Name"]]=$J;return$I;}function
is_view(array$R){return
in_array($R["Engine"],["view","materialized view"]);}function
fk_support(array$R){return
true;}function
fields($Q){$I=[];$Ca=['timestamp without time zone'=>'timestamp','timestamp with time zone'=>'timestamptz',];foreach(get_rows("SELECT
a.attname AS field,
format_type(a.atttypid, a.atttypmod) AS full_type,
a.attndims, pg_get_expr(d.adbin, d.adrelid) AS default,
a.attnotnull::int,
i.indrelid AS primary,
col_description(a.attrelid, a.attnum) AS comment".(Connection::get()->isMinVersion("10")?",
a.attidentity".(Connection::get()->isMinVersion("12")?",
a.attgenerated":""):"")."
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_index i ON a.attrelid = i.indrelid AND a.attnum = ANY(i.indkey) AND i.indisprimary
WHERE a.attrelid = ".Driver::get()->tableOid($Q)."
AND NOT a.attisdropped
AND a.attnum > 0
ORDER BY a.attnum")as$J){preg_match('~([^([]+)(\((.*)\))?([a-z ]+)?((\[[0-9]*])*)$~',$J["full_type"],$y);list(,$T,$u,$J["length"],$ya,$La)=$y;$qb=$T.$ya;if(isset($Ca[$qb])){$J["type"]=$Ca[$qb];$J["full_type"]=$J["type"].$u;}else{$J["type"]=$T;$J["full_type"]=$J["type"].$u.$ya;}for($p=0;$p<$J["attndims"];$p++){$J["length"].=$La;$J["full_type"].=$La;}if(in_array($J['attidentity'],['a','d']))$J['default']='GENERATED '.($J['attidentity']=='d'?'BY DEFAULT':'ALWAYS').' AS IDENTITY';$B=["s"=>"STORED","v"=>"VIRTUAL"];$J["generated"]=(isset($B[$J["attgenerated"]])?$B[$J["attgenerated"]]:"");$J["null"]=!$J["attnotnull"];$J["auto_increment"]=$J['attidentity']||preg_match('~^nextval\(~i',$J["default"])||preg_match('~^unique_rowid\(~',$J["default"]);$J["privileges"]=["insert"=>1,"select"=>1,"update"=>1,"where"=>1,"order"=>1];if(!$J['generated']&&preg_match('~(.+)::[^,)]+(.*)~s',$J["default"],$y))$J["default"]=($y[1]=="NULL"?null:idf_unescape($y[1]).$y[2]);$I[$J["field"]]=$J;}return$I;}function
indexes($Q,$d=null){if(!is_object($d))$d=Connection::get();$I=[];$ql=Driver::get()->tableOid($Q);$c=get_key_vals("SELECT attnum, attname FROM pg_attribute WHERE attrelid = $ql AND attnum > 0",$d);foreach(get_rows("SELECT relname, indisunique::int, indisprimary::int, indkey, indoption, amname,
pg_get_expr(indpred, indrelid, true) AS partial, pg_get_expr(indexprs, indrelid) AS indexpr".($d->isCockroachDB()?"":",
(SELECT string_agg(CASE WHEN opcdefault THEN '' ELSE opcname END, ' ' ORDER BY s)
FROM generate_subscripts(indclass, 1) AS s
JOIN pg_catalog.pg_opclass ON pg_opclass.oid = indclass[s]) AS opclasses")."
FROM pg_index
JOIN pg_class ON indexrelid = oid
JOIN pg_am ON pg_am.oid = pg_class.relam
WHERE indrelid = $ql
ORDER BY indisprimary DESC, indisunique DESC",$d)as$J){$Bj=$J["relname"];$I[$Bj]["type"]=($J["indisprimary"]?"PRIMARY":($J["indisunique"]?"UNIQUE":"INDEX"));$I[$Bj]["columns"]=[];$I[$Bj]["descs"]=[];$I[$Bj]["algorithm"]=$J["amname"];$I[$Bj]["partial"]=$J["partial"];$nf=preg_split('~(?<=\)), (?=\()~',$J["indexpr"]);foreach(explode(" ",$J["indkey"])as$of)$I[$Bj]["columns"][]=($of?$c[$of]:array_shift($nf));foreach(explode(" ",$J["indoption"])as$pf)$I[$Bj]["descs"][]=(intval($pf)&1?'1':null);$I[$Bj]["opclasses"]=(isset($J["opclasses"])?explode(" ",$J["opclasses"]):[]);$I[$Bj]["lengths"]=[];}return$I;}function
foreign_keys($Q){$Nh=implode("|",Driver::get()->getOnActions());$I=[];foreach(get_rows("SELECT conname, condeferrable::int AS deferrable, condeferred::int AS deferred, pg_get_constraintdef(oid) AS definition
FROM pg_constraint
WHERE conrelid = ".Driver::get()->tableOid($Q)."
AND contype = 'f'::char
ORDER BY conkey, conname")as$J){$J['deferrable']=($J['deferrable']?'':'NOT ').'DEFERRABLE'.($J['deferred']?' INITIALLY DEFERRED':'');if(preg_match('~FOREIGN KEY\s*\((.+)\)\s*REFERENCES (.+)\((.+)\)(.*)$~iA',$J['definition'],$y)){$J['source']=array_map('AdminNeo\idf_unescape',array_map('trim',explode(',',$y[1])));if(preg_match('~^(("([^"]|"")+"|[^"]+)\.)?"?("([^"]|"")+"|[^"]+)$~',$y[2],$Gg)){$J['ns']=idf_unescape($Gg[2]);$J['table']=idf_unescape($Gg[4]);}$J['target']=array_map('AdminNeo\idf_unescape',array_map('trim',explode(',',$y[3])));$J['on_delete']=(preg_match("~ON DELETE ($Nh)~",$y[4],$Gg)?$Gg[1]:'NO ACTION');$J['on_update']=(preg_match("~ON UPDATE ($Nh)~",$y[4],$Gg)?$Gg[1]:'NO ACTION');$I[$J['conname']]=$J;}}return$I;}function
backward_keys($Q){$G="SELECT s.constraint_name, s.table_schema, s.table_name, s.column_name, t.column_name AS referenced_column_name
FROM information_schema.key_column_usage s
JOIN information_schema.referential_constraints r USING (constraint_catalog, constraint_schema, constraint_name)
JOIN information_schema.key_column_usage t ON r.unique_constraint_catalog = t.constraint_catalog
AND r.unique_constraint_schema = t.constraint_schema
AND r.unique_constraint_name = t.constraint_name
AND r.constraint_catalog = t.constraint_catalog
AND r.constraint_schema = t.constraint_schema
AND r.unique_constraint_name = t.constraint_name
AND s.position_in_unique_constraint = t.ordinal_position
WHERE t.table_catalog = ".q(DB)."
AND t.table_schema = ".q($_GET["ns"])."
AND t.table_name = ".q($Q)."
ORDER BY s.ordinal_position";return
get_rows($G,null,"");}function
view($_){return["select"=>trim(Connection::get()->getValue("SELECT pg_get_viewdef(".Driver::get()->tableOid($_).")"))];}function
collations(){return[];}function
information_schema($g,$Xj=""){return
in_array($Xj!=""?$Xj:get_schema(),["information_schema","pg_catalog","pg_toast"]);}function
error(){$I=h(Connection::get()->getError());if(preg_match('~^(.*\n)?([^\n]*)\n( *)\^(\n.*)?$~s',$I,$y))$I=$y[1].preg_replace('~((?:[^&]|&[^;]*;){'.strlen($y[3]).'})(.*)~','\1\2 ',$y[2]).$y[4];return
nl2br($I);}function
create_database($g,$Bb){return(bool)queries("CREATE DATABASE ".idf_escape($g).($Bb?" ENCODING ".idf_escape($Bb):""));}function
drop_databases(array$f){Connection::get()->close();return
apply_queries("DROP DATABASE",$f,'AdminNeo\idf_escape');}function
rename_database($_,$Bb){Connection::get()->close();return(bool)queries("ALTER DATABASE ".idf_escape(DB)." RENAME TO ".idf_escape($_));}function
auto_increment(){return"";}function
alter_table($Q,$_,array$k,array$ie,$Lb,$pd,$Bb,$Qa,$Di){$Ha=[];$kj=[];if($Q!=""&&$Q!=$_)$kj[]="ALTER TABLE ".table($Q)." RENAME TO ".table($_);$lk="";foreach($k
as$j){$b=idf_escape($j[0]);$W=$j[1];if(!$W)$Ha[]="DROP $b";else{$Em=$W[5];unset($W[5]);if($j[0]==""){if(isset($W[6]))$W[1]=($W[1]==" bigint"?" big":($W[1]==" smallint"?" small":" "))."serial";$Ha[]=($Q!=""?"ADD ":" ").implode($W);if(isset($W[6]))$Ha[]=($Q!=""?"ADD":" ")." PRIMARY KEY ($W[0])";}else{if($b!=$W[0])$kj[]="ALTER TABLE ".table($_)." RENAME $b TO $W[0]";$Ha[]="ALTER $b TYPE$W[1]";$mk=$Q."_".idf_unescape($W[0])."_seq";$Ha[]="ALTER $b ".($W[3]?"SET".preg_replace('~GENERATED ALWAYS(.*) (STORED|VIRTUAL)~','EXPRESSION\1',$W[3]):(isset($W[6])?"SET DEFAULT nextval(".q($mk).")":"DROP DEFAULT"));if(isset($W[6]))$lk="CREATE SEQUENCE IF NOT EXISTS ".idf_escape($mk)." OWNED BY ".idf_escape($Q).".$W[0]";$Ha[]="ALTER $b ".($W[2]==" NULL"?"DROP NOT":"SET").$W[2];}if($j[0]!=""||$Em!="")$kj[]="COMMENT ON COLUMN ".table($_).".$W[0] IS ".($Em!=""?substr($Em,9):"''");}}$Ha=array_merge($Ha,$ie);if($Q==""){$O="";if($Di){$O=" PARTITION BY {$Di["partition_by"]}({$Di["partition"]})";if($Di["partition_by"]=='HASH'){$Ei=(int)$Di["partitions"];for($p=0;$p<$Ei;$p++)$kj[]="CREATE TABLE ".idf_escape($_."_$p")." PARTITION OF ".idf_escape($_)." FOR VALUES WITH (MODULUS $Ei, REMAINDER $p)";}else{$yb=Connection::get()->isCockroachDB();$bj="MINVALUE";foreach($Di["partition_names"]as$p=>$W){$X=$Di["partition_values"][$p];$zi=" VALUES ".($Di["partition_by"]=='LIST'?"IN ($X)":"FROM ($bj) TO ($X)");if($yb)$O
.=($p?",":" (")."\n PARTITION ".(preg_match('~^DEFAULT$~i',$W)?$W:idf_escape($W)).$zi;else$kj[]="CREATE TABLE ".idf_escape($_."_$W")." PARTITION OF ".idf_escape($_)." FOR$zi";$bj=$X;}$O
.=$yb?"\n)":"";}}array_unshift($kj,"CREATE TABLE ".table($_)." (\n".implode(",\n",$Ha)."\n)$O");}elseif($Ha)array_unshift($kj,"ALTER TABLE ".table($Q)."\n".implode(",\n",$Ha));if($lk)array_unshift($kj,$lk);if($Lb!==null)$kj[]="COMMENT ON TABLE ".table($_)." IS ".q($Lb);if($Qa!="");foreach($kj
as$G){if(!queries($G))return
false;}return
true;}function
alter_indexes($Q,array$Ha){$gc=[];$Wc=[];$kj=[];foreach($Ha
as$W){if($W[0]!="INDEX")$gc[]=($W[2]=="DROP"?"\nDROP CONSTRAINT ".idf_escape($W[1]):"\nADD".($W[1]!=""?" CONSTRAINT ".idf_escape($W[1]):"")." $W[0] ".($W[0]=="PRIMARY"?"KEY ":"")."(".implode(", ",$W[2]).")");elseif($W[2]=="DROP")$Wc[]=idf_escape($W[1]);else$kj[]="CREATE INDEX ".idf_escape($W[1]!=""?$W[1]:uniqid($Q."_"))." ON ".table($Q).($W[3]?" USING $W[3]":"")." (".implode(", ",$W[2]).")".($W[4]?" WHERE $W[4]":"");}if($gc)array_unshift($kj,"ALTER TABLE ".table($Q).implode(",",$gc));if($Wc)array_unshift($kj,"DROP INDEX ".implode(", ",$Wc));foreach($kj
as$G){if(!queries($G))return
false;}return
true;}function
truncate_tables(array$vl){return(bool)queries("TRUNCATE ".implode(", ",array_map('AdminNeo\table',$vl)));}function
drop_views(array$Nm){return
drop_tables($Nm);}function
drop_tables(array$vl){foreach($vl
as$Q){$O=table_status1($Q);if(!queries("DROP ".strtoupper($O["Engine"])." ".table($Q)))return
false;}return
true;}function
move_tables(array$vl,array$Nm,$Bl){foreach(array_merge($vl,$Nm)as$Q){$O=table_status1($Q);if(!queries("ALTER ".strtoupper($O["Engine"])." ".table($Q)." SET SCHEMA ".idf_escape($Bl)))return
false;}return
true;}function
trigger($_,$Q){if($_=="")return["Statement"=>"EXECUTE PROCEDURE ()"];$c=[];$Z="WHERE trigger_schema = current_schema() AND event_object_table = ".q($Q)." AND trigger_name = ".q($_);foreach(get_rows("SELECT * FROM information_schema.triggered_update_columns $Z")as$J)$c[]=$J["event_object_column"];$dm=[];foreach(get_rows('SELECT trigger_name AS "Trigger", action_timing AS "Timing", event_manipulation AS "Event",
\'FOR EACH \' || action_orientation AS "Type", action_statement AS "Statement"
FROM information_schema.triggers '."$Z ORDER BY event_manipulation DESC")as$J){if($c&&$J["Event"]=="UPDATE")$J["Event"].=" OF";$J["Of"]=implode(", ",$c);if($dm)$J["Event"].=" OR $dm[Event]";$dm=$J;}return$dm;}function
triggers($Q){$I=[];foreach(get_rows("SELECT * FROM information_schema.triggers WHERE trigger_schema = current_schema() AND event_object_table = ".q($Q))as$J){$dm=trigger($J["trigger_name"],$Q);$I[$dm["Trigger"]]=[$dm["Timing"],$dm["Event"]];}return$I;}function
trigger_options(){return["Timing"=>["BEFORE","AFTER"],"Event"=>["INSERT","UPDATE","UPDATE OF","DELETE","INSERT OR UPDATE","INSERT OR UPDATE OF","DELETE OR INSERT","DELETE OR UPDATE","DELETE OR UPDATE OF","DELETE OR INSERT OR UPDATE","DELETE OR INSERT OR UPDATE OF",],"Type"=>["FOR EACH ROW","FOR EACH STATEMENT"],];}function
routine($_,$T){$qf=get_rows('SELECT routine_definition, LOWER(external_language) AS language, type_udt_name
FROM information_schema.routines
WHERE routine_schema = current_schema() AND specific_name = '.q($_));$qf=isset($qf[0])?$qf[0]:[];$k=get_rows("SELECT COALESCE(parameter_name, ordinal_position::text) AS field,
CASE data_type WHEN 'USER-DEFINED' THEN udt_name WHEN 'ARRAY' THEN substr(udt_name, 2) || '[]' ELSE data_type END AS type,
character_maximum_length AS length, parameter_mode AS inout
FROM information_schema.parameters
WHERE specific_schema = current_schema() AND specific_name = ".q($_)."
ORDER BY ordinal_position");return["fields"=>$k,"returns"=>["type"=>preg_replace('~^_(.*)~','\1[]',isset($qf["type_udt_name"])?$qf["type_udt_name"]:"")],"definition"=>isset($qf["routine_definition"])?$qf["routine_definition"]:null,"language"=>isset($qf["language"])?$qf["language"]:null,"comment"=>null,];}function
routines(){return
get_rows('SELECT specific_name AS "SPECIFIC_NAME", routine_name AS "ROUTINE_NAME", routine_type AS "ROUTINE_TYPE", type_udt_name AS "DTD_IDENTIFIER", null AS ROUTINE_COMMENT
FROM information_schema.routines
WHERE routine_schema = current_schema()'.(Connection::get()->isCockroachDB()?'':"
AND substring(specific_name, '[0-9]+\$')::oid NOT IN (SELECT objid FROM pg_catalog.pg_depend WHERE classid = 'pg_proc'::regclass AND deptype = 'e')").'
ORDER BY SPECIFIC_NAME');}function
routine_languages(){return
get_vals("SELECT LOWER(lanname) FROM pg_catalog.pg_language");}function
routine_id($_,array$J){$I=[];foreach($J["fields"]as$j){$u=$j["length"];$I[]=$j["type"].($u?"($u)":"");}return
idf_escape($_)."(".implode(", ",$I).")";}function
last_id($H){$J=$H
instanceof
Result?$H->fetchRow():[];return$J?$J[0]:0;}function
explain(Connection$d,$G){return$d->query("EXPLAIN $G");}function
found_rows(array$R,array$Z){if(preg_match("~ rows=([0-9]+)~",Connection::get()->getValue("EXPLAIN SELECT * FROM ".idf_escape($R["Name"]).($Z?" WHERE ".implode(" AND ",$Z):"")),$Aj))return(int)$Aj[1];return
null;}function
types($Gd=false){return
get_key_vals("SELECT oid, typname
FROM pg_type
WHERE typnamespace = ".Driver::get()->getNsOidSql()."
AND typtype IN ('b','d','e')
AND typelem = 0".($Gd||Connection::get()->isCockroachDB()?'':"
AND oid NOT IN (SELECT objid FROM pg_catalog.pg_depend WHERE classid = 'pg_type'::regclass AND deptype = 'e')"));}function
type_values($q){$sd=get_vals("SELECT enumlabel FROM pg_enum WHERE enumtypid = $q ORDER BY enumsortorder");if(!$sd)return"";return"'".implode("', '",array_map('addslashes',$sd))."'";}function
schemas(){return
get_vals("SELECT nspname FROM pg_namespace ORDER BY nspname");}function
get_schema(){return
Connection::get()->getValue("SELECT current_schema()");}function
set_schema($Xj,$d=null){if(!$d)$d=Connection::get();$H=(bool)$d->query("SET search_path TO ".idf_escape($Xj));Driver::get()->setUserTypes(types(true));return$H;}function
foreign_keys_sql($Q){$I="";$O=table_status1($Q);$Bh=idf_escape($O['nspname']);$de=foreign_keys($Q);ksort($de);foreach($de
as$ce=>$be)$I
.="ALTER TABLE ONLY $Bh.".idf_escape($O['Name'])." ADD CONSTRAINT ".idf_escape($ce)." ".preg_replace('~( REFERENCES )([^(.]+\()~',"\\1$Bh.\\2",$be["definition"]).";\n";return($I?"$I\n":$I);}function
foreign_key_checks_sql($md){return"SET session_replication_role = ".($md?"DEFAULT":"replica").";\n";}function
restart_sequences_sql($Q){$I="";foreach(fields($Q)as$j){if(!$j["auto_increment"]||preg_match('~^unique_rowid\(~',$j["default"]))continue;$lk="pg_get_serial_sequence(".q(table($Q)).", ".q($j["field"]).")";$b=idf_escape($j["field"]);$I
.="SELECT setval($lk, MAX($b)) FROM ".table($Q)." HAVING MAX($b) IS NOT NULL;\n";}return$I;}function
create_sql($Q,$Qa,$Wk){$Jj=[];$nk=[];$O=table_status1($Q);$Bh=idf_escape($O['nspname']);if(is_view($O)){$Lm=view($Q);return
rtrim("CREATE VIEW $Bh.".idf_escape($Q)." AS $Lm[select]",";");}$k=fields($Q);if(count($O)<2||empty($k))return"";$I="CREATE TABLE $Bh.".idf_escape($O['Name'])." (\n ";foreach($k
as$j){if($j['default']=="nextval('$O[Name]_$j[field]_seq')"){$j['default']=null;$j['full_type']=preg_replace('~int(eger)?~','serial',$j['full_type']);}$xi=idf_escape($j['field']).' '.$j['full_type'].preg_replace('~(nextval\(\')([^.\']+\')~','\1'.str_replace("'","''",$O['nspname']).'.\2',default_value($j)).($j['null']?"":" NOT NULL");$Jj[]=$xi;if(preg_match('~nextval\(\'([^\']+)\'\)~',$j['default'],$z)){$mk=$z[1];$K=get_rows((Connection::get()->isMinVersion("10")?"SELECT *, cache_size AS cache_value FROM pg_sequences WHERE schemaname = current_schema() AND sequencename = ".q(idf_unescape($mk)):"SELECT * FROM $mk"),null,"-- ");if($K){$Mk=first($K);$nk[]=($Wk=="DROP+CREATE"?"DROP SEQUENCE IF EXISTS $Bh.$mk;\n":"")."CREATE SEQUENCE $Bh.$mk INCREMENT $Mk[increment_by] MINVALUE $Mk[min_value] MAXVALUE $Mk[max_value]".($Qa&&$Mk['last_value']?" START ".($Mk["last_value"]+1):"")." CACHE $Mk[cache_value];";}}}if(!empty($nk))$I=implode("\n\n",$nk)."\n\n$I";$cj="";foreach(indexes($Q)as$lf=>$r){if($r['type']=='PRIMARY'){$cj=$lf;$Jj[]="CONSTRAINT ".idf_escape($lf)." PRIMARY KEY (".implode(', ',array_map('AdminNeo\idf_escape',$r['columns'])).")";}}foreach(Driver::get()->checkConstraints($Q)as$Ub=>$Xb)$Jj[]="CONSTRAINT ".idf_escape($Ub)." CHECK ($Xb)";$I
.=implode(",\n ",$Jj)."\n)";$zi=Driver::get()->getPartitionsInfo($O['Name']);if($zi)$I
.="\nPARTITION BY {$zi["partition_by"]}({$zi["partition"]})";$I
.="\nWITH (oids = ".($O['Oid']?'true':'false').");";if($O['Comment'])$I
.="\n\nCOMMENT ON TABLE $Bh.".idf_escape($O['Name'])." IS ".q($O['Comment']).";";foreach($k
as$Pd=>$j){if($j['comment'])$I
.="\n\nCOMMENT ON COLUMN $Bh.".idf_escape($O['Name']).".".idf_escape($Pd)." IS ".q($j['comment']).";";}foreach(get_rows("SELECT indexdef FROM pg_catalog.pg_indexes WHERE schemaname = current_schema() AND tablename = ".q($Q).($cj?" AND indexname != ".q($cj):""),null,"-- ")as$J)$I
.="\n\n$J[indexdef];";return
rtrim($I,';');}function
truncate_sql($Q){return"TRUNCATE ".table($Q);}function
trigger_sql($Q){$O=table_status1($Q);$Nk="";foreach(triggers($Q)as$cm=>$bm){$dm=trigger($cm,$O['Name']);$Nk
.="\nCREATE TRIGGER ".idf_escape($dm['Trigger'])." $dm[Timing] $dm[Event] ON ".idf_escape($O["nspname"]).".".idf_escape($O['Name'])." $dm[Type] $dm[Statement];;\n";}return$Nk;}function
create_database_sql($rc,$Wk=""){$_=idf_escape($rc);$Jb="";if(str_contains($Wk,"CREATE")){if($Wk=="DROP+CREATE")$Jb="DROP DATABASE IF EXISTS $_;\n";$Jb
.="CREATE DATABASE $_;\n";}return$Jb;}function
use_sql($rc,$Wk=""){return'\connect '.idf_escape($rc).";\n";}function
show_variables(){return
get_rows("SHOW ALL");}function
process_list(){return
get_rows("SELECT * FROM pg_stat_activity ORDER BY ".(Connection::get()->isMinVersion("9.2")?"pid":"procpid"));}function
convert_field(array$j){return
null;}function
unconvert_field(array$j,$I){return$I;}function
support($Ld){if($Ld=="processlist")return!Connection::get()->isCockroachDB();elseif($Ld=="materializedview")return
Connection::get()->isMinVersion("9.3");elseif($Ld=="procedure")return
Connection::get()->isMinVersion("11");return
preg_match('~^(check|columns|comment|database|drop_col|dump|descidx|fast_status|indexes|kill|partial_indexes|routine|scheme|sequence|sql|table|trigger|type|variables|view)$~',$Ld);}function
kill_process($W){return
queries("SELECT pg_terminate_backend(".number($W).")");}function
connection_id(){return"SELECT pg_backend_pid()";}function
max_connections(){return(int)Connection::get()->getValue("SHOW max_connections");}}$Qi="adminneo-plugins";if(is_dir($Qi)){foreach(glob("$Qi/*.php")as$m)include_once$m;}function
get_translations($eg){switch($eg){case'en':$Qb=')X/+JaMAp,z0
Y+"&I/g5m.fI,3%v3OjRAYh
SXdB=b??hR,(W^O_sOh[mx^O2qSz5e
%lyV"F/%L>rXI<&/#WhM"XTH~X8:!%_eI%4RYu>j-LG:?iwpJ3N5)({?wxGx7%T6iPPt6dfI`V3
cH`?omlj(obMXY_T5C;L[di[`M;aFK_o&Yj}^DvxW(&k6>eoFKkD[|?Vs"+).H)[p1BJ47aiY
#KR6p+SD,))He0>ycA!->?qlZU_,-1BKpp&2zVdh_I7fa,{vM0gs=QwtunalMW`d;<`H"L!fDS@IqA$^M)hO@HIYKSJb}h}"d-ny"aIW;.bV?^-i*-lr[+XS>a}WhnbmcC2xss>LnIGnW@(LRg@aXL7q],K`qf*)AucD_-VVJ
kWDA>sfp"$I>Q8[@qrDGFqSu<=P]8S<)q,?qn6wp:Xk`y^9Q{i`cn:.3V@kVl:vDQP
[[`dYX;0
gWGM[]?9+n|:PY^)Z,MQ@[jnonctWyJ@+yz="z)2C;A/SEBf77FEIo94#5`Edh1rZb8@z&,c?j&N^mn4%ID?v4/:57j=H4Rc,4hxc`ZMb=C2-K$mk^/mEKh9)]wbAB+N/DN%n[be9#D)NN4Y#gJ[
EA#4X($HDK;)C-ENJQCA"B,-(,y9x^oDM-KFqCE[|sRw&,WcA:d`j%ex
]uLLoZG/p5i.a#!XVh**NVIa6h"r17>%Ki9cw%16exme4qHm7*8/?$w=mrHpaz^z*qH!+
yh7*AU.f8J5lPr#UJ?2;eI9y6X0l@`W0,?/$I<]OfJ[[$
lQ_B@V5t.SWepYtKLpA.*?r;R.XUd2C`_9jQlQ;SZT3&o^2Z=)/cR[5y`./Vk)+h#/J5*".T@SBW(q9x.N[$?NNzD1rJ`6wq!:7h#-PoR(Y[!+rckssII_$<0XA:1u*`0,d_olw.#MN;YI2+,qUNx1tTF(EW+"gQCEv6CTXat:0FBA!mICae`Y0coZULC"JP))g:,0a3-wWQ=k[a^pbs20?J&M-OR$[.Qx#U/j-%/SN%B]
nX/1y4UorRLv..fRZ>>#
Y>lPfLrpoh3F*>f7T97WhBhbk=Hr.>i9)Mbg
7f.Iq&@xYxM5!eVR7-55HQ$kv3Lf+P`9P<-5btT
,y0u9T_c2WA`9hX!(Gn=ftt:.n%(grSh38dE../PfBfb7=+Eix!o88-?0W01_#t(An;EjzY/G>m$)ux#kn1m&kDQJ|84)>7$Y$.&I*k=,YqkCccO9P,&*7N[HNeu4
DCC-Vqtg`[
DCWi2y;b[@n=weHYLKa+(1%[6eVjK)8-t`gG9;;>ZGRJ@)+.4/Ef3JrW{_AA`u4G?IRon=Eli
nN]RZnoQ>XJ3S_t5w#Vitl4=h3{9(>Ff`1Cq@SLStMy@
DToyHwZd9_sle%U*0jGVBxaFj`5yJGkcE,WZxj.,B?4ge7P`awX4&P#eK^}AquT010j?Z,.r))`Bfyl<>{"8)V,y)gu:oe;l>9Ys_CNtiYMM,#K/h>?rvZenDq406If2)WmY#pNCt<1Nbn`??`=9^([BK`^Y9FtfWP%l?f_~Op_B87Vi1~@4bKt13$V87Ti4.i[1tnf?j7[$UkjWI)jm+.<7B#*?btuQG:bz*$,Ac9vNRb/^N^DW<)-DeuKBLG
05
d45^EtJgT>WZk0jjyXk.3V4tXAZXwpe{JqJb;66TByU>lorht#X#7?G/*_]|?*
^My;C
6gH8:]oo)7?x;,Pt{AOLT[Uc1*OlT6X`}0:.^.aaJ]<1CtMYf0?>#GAvQ>o4tI%EBvt/pTppf"pIl&onCw^b@osFOofF!Zc;5g
$UeSP:Vd,$n+!M^8)66`=:SXD,ICDr%:BOPEzk;>6tltHL)g&S^GVu}S6CNL|qkO6)u
[V{sw+phWaj8n,8xEeI8w3
m2X^AJ=_8o*Ley`)HNA!YJjb_W#]HtR$.op0%t;
8VC$k/]c`)7!]Yq2nP]UJ8H:q_.]6K[M?b?x4
2QKR92U141,'%d process(es) have been killed.'=>274,'%d query(s) executed OK.'=>196,'Query executed OK, %d row(s) affected.'=>194,'%d row(s) have been imported.'=>281,'Routine has been called, %d row(s) affected.'=>233,'%d row(s)'=>193,'%d byte(s)'=>43,'%d item(s) have been affected.'=>278,);return
isset($Ri[$t])?$Ri[$t]:null;}$am=$_SESSION["translations"];$fg=Locale::get()->getLanguage();if($_SESSION["translations_version"]!=1187325438){$am=[];$_SESSION["translations_version"]=1187325438;}if($_SESSION["translations_language"]!=$fg){$am=[];$_SESSION["translations_language"]=$fg;}if(!$am){$am=get_translations($fg);$_SESSION["translations"]=$am;}Locale::get()->setTranslations($am);$za=null;$mc=false;$_f=null;if(function_exists('\adminneo_instance')){$za=\adminneo_instance();$mc=true;}elseif(file_exists("adminneo-instance.php")){$za=include_once"adminneo-instance.php";$mc=true;}if($mc&&!$za
instanceof
Admin&&!$za
instanceof
Pluginer){$za=null;$vg="href=https://github.com/adminneo-org/adminneo#advanced-customizations ".target_blank();$_f=lang(130,"adminneo-instance.php ","adminneo_instance() ","Admin::create()")." ".lang(1)." ";}if(!$za)$za=Admin::create();if($_f)$za->addError($_f);if($Xi!==null&&!isset($_GET["settings"])){$za->getSettings()->updateParameter("lang",$Xi);redirect(remove_from_uri());}if(!defined("AdminNeo\DRIVER")){define("AdminNeo\DRIVER",null);define("AdminNeo\DIALECT",null);}define("AdminNeo\SERVER",DRIVER?$_GET[DRIVER]:null);define("AdminNeo\DB",isset($_GET["db"])?$_GET["db"]:"");define("AdminNeo\BASE_URL",preg_replace('~\?.*~','',relative_uri()));define("AdminNeo\ME",BASE_URL.'?'.(sid()?session_name()."=".urlencode(session_id()).'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').($_GET["ext"]?"ext=".urlencode($_GET["ext"]).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));define("AdminNeo\HOME_URL",BASE_URL?:".");define("AdminNeo\SERVER_HOME_URL",substr(preg_replace('~\b(username|db|ns)=[^&]*&~','',ME),0,-1)?:".");if(isset($_GET["set"])){header("Content-Type: text/javascript; charset=utf-8");if(!verify_token()){header("HTTP/1.1 403 Forbidden");exit;}if($_GET["set"]=="navigation-width"){$an=isset($_POST["width"])?$_POST["width"]:"";if($an!=""){$an=min(max((float)$an,Settings::$NavigationWidthMin),Settings::$NavigationWidthMax);Admin::get()->getSettings()->updateParameter("navigationWidth",sprintf("%.2F",$an));}else
Admin::get()->getSettings()->updateParameter("navigationWidth",null);}if($_GET["set"]=="export-settings")Admin::get()->getSettings()->updateParameters(["exportFormat"=>isset($_POST["format"])?$_POST["format"]:"","exportOutput"=>isset($_POST["output"])?$_POST["output"]:"",]);exit;}const
VERSION="5.8.0";function
page_header($S,$eb=[]){if(!headers_sent()&&!array_sum(array_column(ob_get_status(true),"buffer_used")))ini_set("zlib.output_compression","1");page_headers();if(is_ajax()&&Admin::get()->getErrors()){page_messages();exit;}if(!ob_get_level())ob_start(null,4096);$S=strip_tags($S);$uk=$eb!==false&&$eb!==null&&SERVER!=""?" - ".h(Admin::get()->getServerName(SERVER)):"";$wk=strip_tags(Admin::get()->getServiceTitle());$Ql=$S.$uk." - ".($wk!=""?$wk:"AdminNeo");echo'
getLanguage(),'\' dir=\'',lang(131),'\' class=\'',lang(131),' nojs\'>
',$Ql,'
';$Eb=validate_color_variant(Admin::get()->getConfig()->getColorVariant());echo"
// The event handlers and the classes are registered by functions.js.
const offlineMessage = \'',js_escape(lang(132)),'\';
const thousandsSeparator = \'',js_escape(lang(108)),'\';
',"
",script("initHelpPopup();"),'',"\n","\n","
\n","
$S \n","
\n";restart_session();page_messages();$f=&get_session("dbs");if(DB!=""&&$f&&!in_array(DB,$f,true))$f=null;stop_session();define("AdminNeo\PAGE_HEADER",1);ob_flush();flush();}function
validate_color_variant($Eb){list(,$Eb)=validate_theme("default",$Eb);return$Eb;}function
validate_theme($Jl,$Eb){$Kl=get_available_themes();if(isset($Kl[$Jl][$Eb]))return[$Jl,$Eb];if(isset($Kl["default"][$Eb]))return["default",$Eb];reset($Kl["default"]);return["default",key($Kl["default"])];}function
get_available_themes(){return
array('default'=>array('blue'=>true,'green'=>true,'orange'=>true,'purple'=>true,'red'=>true,),);}function
get_theme_titles($Eb){$Kl=get_available_themes();$Rl=[];foreach($Kl
as$Jl=>$Fb){if(isset($Fb[$Eb])?$Fb[$Eb]:false)$Rl[$Jl]=($Jl=="default"?"Neo":ucwords(str_replace("-"," ",$Jl)));}return$Rl;}function
page_headers(){header("Content-Type: text/html; charset=utf-8");header("Cache-Control: no-cache");header("X-XSS-Protection: 0");header("X-Content-Type-Options: nosniff");header("Referrer-Policy: origin-when-cross-origin");header("X-Frame-Options: DENY");$jc=["script-src"=>"'self' 'unsafe-inline' 'nonce-".get_nonce()."' 'strict-dynamic'","connect-src"=>"'self' https://api.github.com/repos/adminneo-org/adminneo/releases/latest","frame-src"=>"'self'","object-src"=>"'none'","base-uri"=>"'none'","form-action"=>"'self'",];Admin::get()->updateCspHeader($jc);$Hc=[];foreach($jc
as$Gc=>$Kk)$Hc[]="$Gc $Kk";header("Content-Security-Policy: ".implode("; ",$Hc));Admin::get()->sendHeaders();}function
get_nonce(){static$Ah;if(!$Ah)$Ah=Random::strongKey();return$Ah;}function
page_messages(){$tm=preg_replace('~^[^?]*~','',$_SERVER["REQUEST_URI"]);$ah=isset($_SESSION["messages"][$tm])?$_SESSION["messages"][$tm]:null;if($ah){foreach($ah
as$Wg)echo"
$Wg
\n",script("initToggles(qsl('.message'));");unset($_SESSION["messages"][$tm]);}foreach(Admin::get()->getErrors()as$i)echo"
$i
\n";}function
page_footer($hh=null){echo"
\n","
\n","
\n";$ig=isset($_COOKIE["neo_version"])?$_COOKIE["neo_version"]:null;echo"\n";Admin::get()->printNavigation($hh);echo"\n","
\n","
\n","
".icon($W[1])."$W[0] ";}if($xg)echo"$xg
\n";echo"".lang(160,Drivers::get(DRIVER),"".h(Connection::get()->getVersion())." ","".DRIVER_EXTENSION." ")."\n","
".lang(161,"".h(logged_user())." ")."\n";$f=Admin::get()->getDatabases();if($f){$Zj=support("scheme");$Ea=collations();echo"
\n",script("tableCheck();");}}echo''.icon("database-add").lang(75)." \n";page_footer("db");exit;}if(support("scheme")){if(DB!=""&&$_GET["ns"]!==""){if(!isset($_GET["ns"]))redirect(preg_replace('~(?<=[?&])db=[^&]+~','\\0&ns='.urlencode(get_schema()),relative_uri()));if(!set_schema($_GET["ns"])){Admin::get()->addError(lang(168));header("HTTP/1.1 404 Not Found");page_header(lang(81).": ".h($_GET["ns"]),true);page_footer("ns");exit;}}}if(isset($_GET["select"])&&($_POST["edit"]||$_POST["clone"])&&!$_POST["save"])$_GET["edit"]=$_GET["select"];if(isset($_GET["callf"]))$_GET["call"]=$_GET["callf"];if(isset($_GET["function"]))$_GET["procedure"]=$_GET["function"];if(isset($_GET["download"])){$a=$_GET["download"];$k=fields($a);header("Content-Type: application/octet-stream");header("Content-Disposition: attachment; filename=".friendly_url("$a-".implode("_",$_GET["where"])).".".friendly_url($_GET["field"]));$L=[idf_escape($_GET["field"])];$H=Driver::get()->select($a,$L,[where($_GET,$k)],$L);$J=($H?$H->fetchRow():[]);echo
Connection::get()->formatValue($J[0],$k[$_GET["field"]]);exit;}elseif(isset($_GET["table"])){$a=$_GET["table"];$k=fields($a);if(!$k)Admin::get()->addError(error()?:lang(78));$R=table_status1($a,true);$_=Admin::get()->getTableName($R);$Kj=[];foreach($k
as$t=>$j)$Kj+=$j["privileges"];$S=$k&&is_view($R)?$R['Engine']=='materialized view'?lang(169):lang(170):lang(9);$ol=$_!=""?$_:h($a);page_header("$S: $ol",[$ol]);$yf=null;if(isset($Kj["insert"])||!support("table"))$yf=[];Admin::get()->printTableMenu($R,$yf);$qf=[];if(!preg_match("~sqlite|mssql|pgsql~",DIALECT)&&isset($R["Engine"]))$qf[]=lang(171).": ".h($R["Engine"]);if(isset($R["Collation"]))$qf[]=lang(46).": ".h($R["Collation"]);if($qf)echo"
",implode(", ",$qf),"
";if($k)Admin::get()->printTableStructure($k);$Lb=$R["Comment"];if($Lb!="")echo"",lang(47),": ",Admin::get()->formatComment($Lb),"
\n";if(!is_view($R))$ed=''.icon("edit").lang(36)." \n";elseif(support("view"))$ed='
'.icon("edit").lang(37)." \n";else$ed="";if($qf||$k||$Lb!="")echo$ed;$vi=Driver::get()->getParentTables($a);if($vi){echo"
".lang(172)." \n";Admin::get()->printRelatedTables($vi);}if(Driver::get()->getPartitionBy()&&str_contains(isset($R["Create_options"])?$R["Create_options"]:"","partitioned")){$Fi=Driver::get()->getPartitionsInfo($a);if($Fi){echo"".lang(50)." \n";Admin::get()->printTablePartitions($Fi);if(DIALECT!="pgsql")echo$ed;}}$rf=Driver::get()->getInheritedTables($a);if($rf){echo"".lang(173)." \n";Admin::get()->printRelatedTables($rf);}if(support("indexes")&&Driver::get()->supportsIndex($R)){echo"".lang(174)." \n";$s=indexes($a);if($s)Admin::get()->printTableIndexes($s,$R);echo''.icon("edit").lang(175)." \n";}if(!is_view($R)){if(fk_support($R)){echo"
".lang(92)." \n";$ke=foreign_keys($a);if($ke){echo"\n","".lang(176)." ".lang(177)." ".lang(95)." ".lang(94)." ","".implode(" , ",array_map('AdminNeo\h',$n["source"]))." ","".($n["db"]!=""&&$n["db"]!=DB?"".h($n["db"])." .":"").($n["ns"]!=""&&$n["ns"]!=$_GET["ns"]?"".h($n["ns"])." .":"").h($n["table"])." ","(".implode(" , ",array_map('AdminNeo\h',$n["target"]))." )","".h($n["on_delete"])," ".h($n["on_update"]),' '.lang(178).' ',"\n";echo"
\n";}echo''.icon("add").lang(179)." \n";}if(support("check")){echo"
".lang(180)." \n";$pb=Driver::get()->checkConstraints($a);if($pb){echo"\n";foreach($pb
as$t=>$W)echo"","".truncate_utf8(preg_replace('~\s+~',' ',ltrim($W))),"".lang(178)." ","\n";echo"
\n";}echo''.icon("add").lang(181)." \n";}}if(support(is_view($R)?"view_trigger":"trigger")){echo"
".lang(182)." \n";$fm=triggers($a);if($fm){echo"\n";foreach($fm
as$t=>$W)echo"".h($W[0])." ".h($W[1])." ".h($t)." ".lang(178)." \n";echo"
\n";}echo''.icon("add").lang(183)." \n";}}elseif(isset($_GET["schema"])){$Pl=h(": ".DB.($_GET["ns"]?".$_GET[ns]":""));page_header(lang(72).$Pl,[lang(72)]);$rl=[];$sl=[];$Qd=[];$oa=($_GET["schema"]?:$_COOKIE["neo_schema-".str_replace(".","_",DB)]);preg_match_all('~([^:]+):([-0-9.]+)x([-0-9.]+)(_|$)~',$oa,$z,PREG_SET_ORDER);foreach($z
as$y){$rl[$y[1]]=[(float)$y[2],(float)$y[3]];$sl[]="\n'".js_escape($y[1])."': [ $y[2], $y[3] ]";}$tg=1.4;$Vl=0;$Xa=-1;$Xj=[];$yj=[];$lg=[];$Fa=Driver::get()->getAllFields();foreach(table_status('',true)as$Q=>$R){if(is_view($R))continue;$F=0;$Xj[$Q]["fields"]=[];foreach(isset($Fa[$Q])?$Fa[$Q]:[]as$j){$F=round($F+$tg,2);$Qd[$Q][$j["field"]]=$F;$Xj[$Q]["fields"][$j["field"]]=$j;}$Xj[$Q]["pos"]=(isset($rl[$Q])?$rl[$Q]:[$Vl,0]);foreach(Admin::get()->getForeignKeys($Q)as$W){if(!$W["db"]){$jg=$Xa;if((isset($rl[$Q][1])?$rl[$Q][1]:0)||(isset($rl[$W["table"]][1])?$rl[$W["table"]][1]:0))$jg=min(floatval(isset($rl[$Q][1])?$rl[$Q][1]:0),floatval(isset($rl[$W["table"]][1])?$rl[$W["table"]][1]:0))-1;else$Xa-=.1;while($lg[(string)$jg])$jg-=.0001;$Xj[$Q]["references"][$W["table"]][(string)$jg]=[$W["source"],$W["target"]];$yj[$W["table"]][$Q][(string)$jg]=$W["target"];$lg[(string)$jg]=true;}}$Vl=max($Vl,round($Xj[$Q]["pos"][0]+$tg+$F+1,2));}echo"
\n";foreach($Xj
as$_=>$Q){$Oe=round($tg+count($Q["fields"])*$tg+0.4,2);echo"
","
",'
","
";foreach($Q["fields"]as$j){$W=''.h($j["field"]).' ';echo"".($j["primary"]?"$W ":$W)." ";}echo" ","
";foreach((array)$Q["references"]as$Cl=>$_j){foreach($_j
as$jg=>$uj){$kg=$jg-(isset($rl[$_][1])?$rl[$_][1]:0);$p=0;foreach($uj[0]as$Jk){echo"\n
";$p++;}}}foreach((array)$yj[$_]as$Cl=>$_j){foreach($_j
as$jg=>$c){$kg=$jg-(isset($rl[$_][1])?$rl[$_][1]:0);$p=0;foreach($c
as$Bl){echo"\n
";$p++;}}}echo"\n
\n";}foreach($Xj
as$_=>$Q){foreach((array)$Q["references"]as$Cl=>$_j){if($Xj[$Cl]){foreach($_j
as$jg=>$uj){$gh=$Vl;$Og=-10;foreach($uj[0]as$t=>$Jk){$Ti=$Q["pos"][0]+$Qd[$_][$Jk];$Ui=$Xj[$Cl]["pos"][0]+$Qd[$Cl][$uj[1][$t]];$gh=round(min($gh,$Ti,$Ui),2);$Og=round(max($Og,$Ti,$Ui),2);}echo"
\n";}}}}echo"
","",lang(184)," ","
\n";}elseif(isset($_GET["dump"])){$a=$_GET["dump"];$N=Admin::get()->getSettings();if($_POST){$N->updateParameters(["dumpFormat"=>$_POST["format"],"dumpDbStyle"=>$_POST["db_style"],"dumpTypes"=>isset($_POST["types"])?$_POST["types"]:(support("type")?"":null),"dumpRoutines"=>isset($_POST["routines"])?$_POST["routines"]:(support("routine")?"":null),"dumpEvents"=>isset($_POST["events"])?$_POST["events"]:(support("event")?"":null),"dumpTableStyle"=>$_POST["table_style"],"dumpAutoIncrement"=>isset($_POST["auto_increment"])?$_POST["auto_increment"]:"","dumpTriggers"=>isset($_POST["triggers"])?$_POST["triggers"]:(support("trigger")?"":null),"dumpDataStyle"=>$_POST["data_style"],"dumpOutput"=>$_POST["output"],]);if(DB!="")$f=[DB];else{$f=isset($_POST["databases"])?$_POST["databases"]:[];if(is_string($f))$f=explode("\n",rtrim(str_replace("\r","",$f),"\n"));}$Yj=isset($_POST["schemas"])?$_POST["schemas"]:[];$vl=array_flip(isset($_POST["tables"])?$_POST["tables"]:[])+array_flip(isset($_POST["data"])?$_POST["data"]:[]);if(count($vl)==1)$bf=key($vl);elseif(count($Yj)==1)$bf=$Yj[0];elseif(count($f)==1)$bf=$f[0];else$bf=Admin::get()->getServerName(SERVER,true,"server");$Ed=dump_headers($bf,DB==""||$_GET["ns"]===""||count($vl)>1);$Kf=preg_match('~sql~',$_POST["format"]);$pc=$Kf&&$_POST["data_style"]&&!$_POST["table_style"]&&DIALECT!="sql";if($Kf){echo"-- AdminNeo ".VERSION." ".Drivers::get(DRIVER)." ".Connection::get()->getVersion()." dump\n\n";if(DIALECT=="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';
":"")."
";Connection::get()->query("SET time_zone = '+00:00'");Connection::get()->query("SET sql_mode = ''");}}$Wk=$_POST["db_style"];foreach($f
as$g){Admin::get()->dumpDatabase($g);if(Connection::get()->selectDatabase($g)){if($Kf){if($Wk)echo
create_database_sql($g,$Wk),use_sql($g,$Wk)."\n";$oi="";if($_POST["types"]){foreach(types()as$q=>$T){$sd=type_values($q);if($sd)$oi
.=($Wk!='DROP+CREATE'?"DROP TYPE IF EXISTS ".idf_escape($T).";;\n":"")."CREATE TYPE ".idf_escape($T)." AS ENUM ($sd);\n\n";else$oi
.="-- Could not export type $T\n\n";}}if($_POST["routines"]){foreach(routines()as$J){$_=$J["ROUTINE_NAME"];$Mj=$J["ROUTINE_TYPE"];$gc=create_routine($Mj,["name"=>$_]+routine($J["SPECIFIC_NAME"],$Mj));set_utf8mb4($gc);$oi
.=($Wk!='DROP+CREATE'?"DROP $Mj IF EXISTS ".idf_escape($_).";;\n":"")."$gc;\n\n";}}if($_POST["events"]){foreach(get_rows("SHOW EVENTS",null,"-- ")as$J){$gc=remove_definer(Connection::get()->getValue("SHOW CREATE EVENT ".idf_escape($J["Name"]),3));set_utf8mb4($gc);$oi
.=($Wk!='DROP+CREATE'?"DROP EVENT IF EXISTS ".idf_escape($J["Name"]).";;\n":"")."$gc;;\n\n";}}echo($oi&&DIALECT=='sql'?"DELIMITER ;;\n\n$oi"."DELIMITER ;\n\n":$oi);}if($_POST["table_style"]||$_POST["data_style"]){foreach(($_GET["ns"]===""?(array)$_POST["schemas"]:(DB!=""||!support("scheme")?[""]:Admin::get()->getSchemas(true)))as$Xj){if($Xj!="")set_schema($Xj);$yl=table_status('',true);$pl=array_keys($yl);$Ic=false;if($pc&&$pl){$zj=[];foreach($pl
as$_){if(!is_view($yl[$_])&&(DB==""||$_GET["ns"]===""||in_array($_,(array)$_POST["data"]))){foreach(foreign_keys($_)as$n)$zj[$_][]=$n["table"];}}$di=dump_table_order($pl,$zj);if($di)$pl=$di;else$Ic=function_exists('AdminNeo\foreign_key_checks_sql');}if($Ic)echo
foreign_key_checks_sql(false)."\n";$Nm=[];foreach($pl
as$_){$R=$yl[$_];$Q=(DB==""||$_GET["ns"]===""||in_array($_,(array)$_POST["tables"]));$e=(DB==""||$_GET["ns"]===""||in_array($_,(array)$_POST["data"]));if($Q||$e){$Sl=null;if($Ed=="tar"){$Sl=new
TmpFile();ob_start([$Sl,'write'],1e5);}$hc=($Q?$_POST["table_style"]:"");Admin::get()->dumpTable($_,$hc,(is_view($R)?2:0));if(is_view($R)&&$Ed!="tar")$Nm[]=$_;elseif($e){$k=fields($_);Admin::get()->dumpData($_,$_POST["data_style"],"SELECT *".convert_fields($k,$k)." FROM ".table($_));if($Kf&&!$hc&&$_POST["auto_increment"]&&function_exists('AdminNeo\restart_sequences_sql'))echo"\n".restart_sequences_sql($_);}if($Kf&&$_POST["triggers"]&&$Q&&($fm=trigger_sql($_)))echo"\nDELIMITER ;;\n$fm\nDELIMITER ;\n";if($Ed=="tar"){ob_end_flush();tar_file((DB!=""?"":"$g/")."$_.csv",$Sl);}elseif($Kf)echo"\n";}}if($Ic)echo
foreign_key_checks_sql(true)."\n";if($_POST["table_style"]&&function_exists('AdminNeo\foreign_keys_sql')){foreach($yl
as$_=>$R){$Q=(DB==""||$_GET["ns"]===""||in_array($_,(array)$_POST["tables"]));if($Q&&!is_view($R))echo
foreign_keys_sql($_);}}foreach($Nm
as$Lm)Admin::get()->dumpTable($Lm,$_POST["table_style"],1);if($Ed=="tar")echo
pack("x512");}}}}if($Kf)echo"-- ".gmdate("Y-m-d H:i:s e")."\n";exit;}$_=DB!=""?h(DB):h(Admin::get()->getServerName(SERVER));page_header(lang(74).": $_",($_GET["export"]!=""?["table"=>$_GET["export"]]:[lang(74)]));echo"\n";$wg=[];foreach($Zi
as$t=>$W){if($t!=""&&$W>1)$wg[]="".icon("check").h($t)."* ";}if($wg)echo"",implode("",$wg),"
\n";}elseif(isset($_GET["sql"])){$N=Admin::get()->getSettings();if($_POST["export"]){$N->updateParameters(["exportFormat"=>$_POST["format"],"exportOutput"=>$_POST["output"],]);dump_headers("sql");Admin::get()->dumpTable("","");Admin::get()->dumpData("","table",$_POST["query"]);exit;}restart_session();$Te=&get_session("queries");$Se=&$Te[DB];if($_POST["clear"]){$Se=[];redirect(remove_from_uri("history"));}stop_session();$S=isset($_GET["import"])?lang(73):lang(41);page_header($S,[$S]);$sg="--".(DIALECT=="sql"?" ":"");if($_POST){$re=false;if(!isset($_GET["import"]))$G=$_POST["query"];elseif($_POST["webfile"]){$ff=Admin::get()->getImportFilePath();if($ff){if(file_exists($ff))$re=fopen($ff,"rb");elseif(file_exists("$ff.gz"))$re=fopen("compress.zlib://$ff.gz","rb");}$G=$re?fread($re,1e6):false;}else$G=get_file("sql_file",true,";");if(is_string($G)){if(($Ug=ini_bytes("memory_limit"))!="-1")ini_set("memory_limit",max($Ug,strval(2*strlen($G)+memory_get_usage()+8e6)));if($G!=""&&strlen($G)<1e6){$jj=$G.(preg_match("~;[ \t\r\n]*\$~",$G)?"":";");if(!$Se||first(end($Se))!=$jj){restart_session();$Se[]=[$jj,time()];set_session("queries",$Te);stop_session();}}$Lk="(?:\\s|/\\*[\s\S]*?\\*/|(?:#|$sg)[^\n]*\n?|--\r?\n)";$Ac=";";$Bc=1;$Fh=0;$kd=true;$Vb=connect();if($Vb&&DB!=""){$Vb->selectDatabase(DB);if($_GET["ns"]!="")set_schema($_GET["ns"],$Vb);}$Kb=0;$ud=[];$wi='[\'"'.(DIALECT=="sql"?'`#':(DIALECT=="sqlite"?'`[':(DIALECT=="mssql"?'[':''))).']|/\*|'.$sg.'|$'.(DIALECT=="pgsql"?'|\$([a-zA-Z]\w*)?\$':'');$Wl=microtime(true);$bd=Admin::get()->getDumpFormats();unset($bd["sql"]);while($G!=""){if(!$Fh&&preg_match("~^$Lk*+DELIMITER\\s+(\\S+)~i",$G,$y)){$Ac=preg_quote($y[1]);$Bc=strlen($y[1]);$ne=Admin::get()->formatSqlCommandQuery(trim($y[0]));if($ne!="")echo"$ne".Admin::get()->formatSqlCommandQuery(trim($jj))."".lang(190,preg_match('~ATTACH~i',$y[1])?'ATTACH':'VACUUM INTO')."\n";$ud[]=" $Kb ";if($_POST["error_stops"])break;}else{if(!$_POST["only_errors"]){echo$dj;ob_flush();flush();}$Rk=microtime(true);if(Connection::get()->multiQuery($jj)&&is_object($Vb)&&preg_match("~^$Lk*+USE\\b~i",$jj))$Vb->query($jj);do{$H=Connection::get()->storeResult();if(Connection::get()->getError()){echo($_POST["only_errors"]?$dj:""),"
",lang(191),(!empty(Connection::get()->getErrno())?" (".Connection::get()->getErrno().")":""),": ",error()."
\n";$ud[]=" $Kb ";if($_POST["error_stops"])break
2;}else{$Ml=" (".format_time($Rk).") ";$fd=(strlen($jj)<1000?" ".icon("edit").lang(39)." ":"");$nj=Connection::get()->getQueryInfo();$_a=Connection::get()->getAffectedRows();$Tm=($_POST["only_errors"]?null:Driver::get()->warnings());$Vm="warnings-$Kb";$Wm=$Tm?"".lang(40).icon_chevron_down()." ":null;$Ad=$gi=null;$Bd="explain-$Kb";$Cd=false;$Dd="export-$Kb";$v=0;if(is_object($H)){if(!$_POST["only_errors"])echo"\n";$v=(int)$_POST["limit"];$gi=print_select_result($H,$Vb,[],$v);if(!$_POST["only_errors"]){echo"
";$Dh=$H->getRowsCount();echo($Dh?($v&&$Dh>$v?lang(192,$v):"").lang(193,$Dh):""),$Ml,$fd,$Wm;if($Vb&&preg_match("~^($Lk|\\()*+SELECT\\b~i",$jj)&&($Ad=explain($Vb,$jj)))echo"Explain".icon_chevron_down()." ";$Cd=true;echo"".lang(74).icon_chevron_down()." ","
\n";}}else{if(preg_match("~^$Lk*+(CREATE|DROP|ALTER)$Lk++(DATABASE|SCHEMA)\\b~i",$jj)){restart_session();set_session("dbs",null);stop_session();}if(!$_POST["only_errors"]){echo"
",lang(194,$_a),"$Ml $fd";if($Wm)echo", $Wm";echo"
\n";}}if(!$_POST["only_errors"])echo
script("initToggles(qsl('p'));");if($Tm)echo"
\n$Tm
\n";if($Ad){echo"
\n";print_select_result($Ad,$Vb,$gi);echo"
\n";}if($Cd){echo"
\n";}if(is_object($H)&&!$_POST["only_errors"])echo"
".lang(195)."\n";elseif($_POST["only_errors"]){$Ih=$Kb-count($ud);echo"
".lang(196,$Kb-count($ud))," (".format_time($Wl).") \n";}elseif($ud&&$Kb>1)echo"
".lang(191).": ".implode("",$ud)."\n";}else
echo"
".upload_error($G)."\n";}echo"
\n";}elseif(isset($_GET["edit"])){$a=$_GET["edit"];$k=fields($a);$Z=(isset($_GET["select"])?($_POST["check"]&&count($_POST["check"])==1?where_check($_POST["check"][0],$k):""):where($_GET,$k));$sm=(isset($_GET["select"])?$_POST["edit"]:$Z);foreach($k
as$_=>$j){if((!$sm&&!isset($j["privileges"]["insert"]))||Admin::get()->getFieldName($j)=="")unset($k[$_]);}if($_POST&&!isset($_GET["select"])){$x=$_POST["referer"];if($_POST["insert"])$x=($sm?null:$_SERVER["REQUEST_URI"]);elseif(!preg_match('~^.+&select=.+$~',$x))$x=ME."select=".urlencode($a);$s=indexes($a);$mm=unique_array(isset($_GET["where"])?$_GET["where"]:[],$s);$oj="\nWHERE $Z";if(isset($_POST["delete"]))queries_redirect($x,lang(209),(bool)Driver::get()->delete($a,$oj,$mm?0:1));else{$yk=[];foreach($k
as$_=>$j){$W=process_input($j);if($W!==false&&$W!==null)$yk[idf_escape($_)]=$W;}if($sm){if(!$yk)redirect($x);queries_redirect($x,lang(210),(bool)Driver::get()->update($a,$yk,$oj,$mm?0:1));if(is_ajax()){page_headers();page_messages();exit;}}else{$H=Driver::get()->insert($a,$yk);$hg=($H?last_id($H):0);queries_redirect($x,lang(211,($hg?" $hg":"")),(bool)$H);}}}$J=null;if($Z){$L=[];foreach($k
as$_=>$j){if(isset($j["privileges"]["select"])){$Ma=($_POST["clone"]&&$j["auto_increment"]?"''":convert_field($j));$L[]=($Ma?"$Ma AS ":"").idf_escape($_);}}$J=[];if(!support("table"))$L=["*"];if($L){$H=Driver::get()->select($a,$L,[$Z],$L,[],(isset($_GET["select"])?2:1));if(!$H)Admin::get()->addError(error());else{$J=$H->fetchAssoc();if(!$J)$J=false;}if(isset($_GET["select"])&&(!$J||$H->fetchAssoc()))$J=null;}}if(!support("table")&&!$k){if(!$Z){$H=Driver::get()->select($a,["*"],[],["*"]);$J=($H?$H->fetchAssoc():false);if(!$J)$J=[Driver::get()->primary=>""];}if($J){foreach($J
as$t=>$W){if(!$Z)$J[$t]=null;$k[$t]=["field"=>$t,"null"=>($t!=Driver::get()->primary),"auto_increment"=>($t==Driver::get()->primary)];}}}if(isset($_POST["save"])?$_POST["save"]:false){$Vi=[];foreach((isset($_POST["fields"])?$_POST["fields"]:[])as$t=>$W)$Vi[bracket_escape($t,true)]=$W;$J=$Vi+($J?:[]);}if($_POST["edit"]){$hd=array_filter($k,function($j){return!(isset($j["generated"])?$j["generated"]:null);});}else$hd=$k;edit_form($a,$hd,$J,$sm);}elseif(isset($_GET["create"])){$a=$_GET["create"];$Bi=Driver::get()->getPartitionBy();$Fi=$Bi?Driver::get()->getPartitionsInfo($a):[];$wj=referencable_primary($a);$ke=[];foreach($wj
as$ol=>$j)$ke[str_replace("`","``",$ol)."`".str_replace("`","``",$j["field"])]=$ol;$ji=[];$R=[];if($a!=""){$ji=fields($a);$R=table_status1($a);if(count($R)<2)Admin::get()->addError(lang(78));}$J=$_POST;$J["Comment"]=normalize_newlines($J["Comment"]);$J["fields"]=(array)$J["fields"];if($J["auto_increment_col"])$J["fields"][$J["auto_increment_col"]]["auto_increment"]=true;if($_POST&&!Admin::get()->getErrors())Admin::get()->getSettings()->updateParameter("commentsOpened",isset($_POST["comments"])?$_POST["comments"]:null);if($_POST&&!process_fields($J["fields"])&&!Admin::get()->getErrors()){if($_POST["drop"])queries_redirect(substr(ME,0,-1),lang(212),drop_tables([$a]));else{$k=[];$Fa=[];$xm=false;$ie=[];$ii=reset($ji);$Ba=" FIRST";foreach($J["fields"]as$t=>$j){$n=$ke[$j["type"]];$hm=($n!==null?$wj[$n]:$j);if($j["field"]!=""){if(!$j["generated"])$j["default"]=null;$ij=process_field($j,$hm);$Fa[]=[$j["orig"],$ij,$Ba];if(!$ii||$ij!==process_field($ii,$ii)){$k[]=[$j["orig"],$ij,$Ba];if($j["orig"]!=""||$Ba)$xm=true;}if($n!==null)$ie[idf_escape($j["field"])]=($a!=""&&DIALECT!="sqlite"?"ADD":" ").format_foreign_key(['table'=>$ke[$j["type"]],'source'=>[$j["field"]],'target'=>[$hm["field"]],'on_delete'=>$j["on_delete"],]);$Ba=" AFTER ".idf_escape($j["field"]);}elseif($j["orig"]!=""){$xm=true;$k[]=[$j["orig"]];}if($j["orig"]!=""){$ii=next($ji);if(!$ii)$Ba="";}}$Di=[];if(in_array($J["partition_by"],$Bi)){foreach($J
as$t=>$W){if(preg_match('~^partition~',$t))$Di[$t]=$W;}foreach($Di["partition_names"]as$t=>$_){if($_===""){unset($Di["partition_names"][$t]);unset($Di["partition_values"][$t]);}}$Di["partition_names"]=array_values($Di["partition_names"]);$Di["partition_values"]=array_values($Di["partition_values"]);if($Di==$Fi)$Di=[];}elseif(str_contains(isset($R["Create_options"])?$R["Create_options"]:"","partitioned"))$Di=null;$Wg=lang(213);if($a==""){cookie("neo_engine",isset($J["Engine"])?$J["Engine"]:"");$Wg=lang(214);}$_=trim($J["name"]);$x=ME.(support("table")?"table=":"select=").urlencode($_);$H=alter_table($a,$_,(DIALECT=="sqlite"&&($xm||$ie)?$Fa:$k),$ie,($J["Comment"]!=$R["Comment"]?$J["Comment"]:null),($J["Engine"]&&$J["Engine"]!=$R["Engine"]?$J["Engine"]:""),($J["Collation"]&&$J["Collation"]!=$R["Collation"]?$J["Collation"]:""),($J["Auto_increment"]!=""?number($J["Auto_increment"]):""),$Di);if($H&&!Queries::$queries)redirect($x);queries_redirect($x,$Wg,$H);}}if($a!="")page_header(lang(36).": ".h($a),["table"=>$a,lang(36)]);else
page_header(lang(77),[lang(77)]);if(!$_POST){$im=Driver::get()->getTypes();$J=["Engine"=>$_COOKIE["neo_engine"],"fields"=>[["field"=>"","type"=>(isset($im["int"])?"int":(isset($im["integer"])?"integer":"")),"on_update"=>""]],"partition_names"=>[""],];if($a!=""){$J=$R;$J["name"]=$a;$J["fields"]=[];if(!$_GET["auto_increment"])$J["Auto_increment"]="";foreach($ji
as$j){$j["generated"]=$j["generated"]?:(isset($j["default"])?"DEFAULT":"");$J["fields"][]=$j;}if($Bi){$J+=$Fi;$J["partition_names"][]="";$J["partition_values"][]="";}}}$Tf=[];if($J["Collation"])$Tf[$J["Collation"]]=true;foreach($J["fields"]as$j){if($j["collation"])$Tf[$j["collation"]]=true;}$Cb=Admin::get()->getCollations(array_keys($Tf));$qd=Driver::get()->engines();foreach($qd
as$pd){if(!strcasecmp($pd,$J["Engine"])){$J["Engine"]=$pd;break;}}$Jg=max_input_vars(12,20);if($Jg){$Pe=(count($J["fields"])>$Jg?"":" hidden");echo"".max_input_vars_error()."\n";}echo"\n";}elseif(isset($_GET["indexes"])){$a=$_GET["indexes"];$mf=["PRIMARY","UNIQUE","INDEX"];$R=table_status1($a,true);$jf=Driver::get()->getIndexAlgorithms($R);$d=Connection::get();$Eg=$d->isMariaDB();if(preg_match('~MyISAM|M?aria'.($d->isMinVersion($Eg?"10.0.5":"5.6")?'|InnoDB':'').'~i',$R["Engine"]))$mf[]="FULLTEXT";if(preg_match('~MyISAM|M?aria'.($d->isMinVersion($Eg?"10.2.2":"5.7")?'|InnoDB':'').'~i',$R["Engine"]))$mf[]="SPATIAL";if($Eg&&$d->isMinVersion("11.7")&&preg_match('~MyISAM|InnoDB~i',$R["Engine"]))$mf[]="VECTOR";$s=indexes($a);$k=fields($a);$cj=[];if(DIALECT=="mongo"){$cj=$s["_id_"];unset($mf[0]);unset($s["_id_"]);}$J=$_POST;if($J){$N=Admin::get()->getSettings();if($N->getParameter("indexOptions")!==null)$N->updateParameter("indexOptions",null);}if($_POST&&!$_POST["add"]&&!$_POST["drop_col"]){$Ha=[];foreach($J["indexes"]as$r){$_=$r["name"];if(in_array($r["type"],$mf)){$c=[];$pg=[];$Ec=[];$Th=[];$if=$jf?(in_array($r["algorithm"],$jf)?$r["algorithm"]:first($jf)):"";$kf=(support("partial_indexes")?$r["partial"]:"");$yk=[];ksort($r["columns"]);foreach($r["columns"]as$t=>$b){if($b!=""){$u=isset($r["lengths"][$t])?$r["lengths"][$t]:null;$Cc=isset($r["descs"][$t])?$r["descs"][$t]:null;$Sh=isset($r["opclasses"][$t])?$r["opclasses"][$t]:null;$yk[]=($k[$b]?idf_escape($b):$b).($u?"(".(+$u).")":"").($Sh!=""?" ".idf_escape($Sh):"").($Cc?" DESC":"");$c[]=$b;$pg[]=($u?:null);$Ec[]=$Cc;$Th[]="$Sh";}}$_d=$s[$_];if($_d){ksort($_d["columns"]);ksort($_d["lengths"]);ksort($_d["descs"]);if($r["type"]==$_d["type"]&&array_values($_d["columns"])===$c&&(!$_d["lengths"]||array_values($_d["lengths"])===$pg)&&array_values($_d["descs"])===$Ec&&(!$_d["opclasses"]||array_values($_d["opclasses"])===$Th)&&(!$jf||$_d["algorithm"]===$if)&&$_d["partial"]==$kf){unset($s[$_]);continue;}}if($c)$Ha[]=[$r["type"],$_,$yk,$if,$kf];}}foreach($s
as$_=>$_d)$Ha[]=[$_d["type"],$_,"DROP"];if(!$Ha)redirect(ME."table=".urlencode($a));queries_redirect(ME."table=".urlencode($a),lang(220),alter_indexes($a,$Ha));}page_header(lang(175).": ".h($a),["table"=>$a,lang(175)]);$Sd=array_keys($k);if($_POST["add"]){foreach($J["indexes"]as$t=>$r){if($r["columns"][count($r["columns"])]!="")$J["indexes"][$t]["columns"][]="";}$r=end($J["indexes"]);if($r["type"]||array_filter($r["columns"],'strlen'))$J["indexes"][]=["columns"=>[1=>""]];}if(!$J){foreach($s
as$t=>$r){$s[$t]["name"]=$t;$s[$t]["columns"][]="";}$s[]=["columns"=>[1=>""]];$J["indexes"]=$s;}$pg=(DIALECT=="sql"||DIALECT=="mssql");$Th=Driver::get()->getIndexOpclasses();if($_POST)$Bk=$_POST["options"];else{$Bk=false;foreach($s
as$r){if(array_filter(isset($r["lengths"])?$r["lengths"]:[])||array_filter(isset($r["descs"])?$r["descs"]:[])||array_filter(isset($r["opclasses"])?$r["opclasses"]:[])||(isset($r["partial"])?$r["partial"]:"")!=""){$Bk=true;break;}}}echo"\n";}elseif(isset($_GET["database"])){$J=$_POST;if($_POST&&!isset($_POST["add_x"])){$_=trim($J["name"]);if($_POST["drop"]){$_GET["db"]="";queries_redirect(remove_from_uri("db|database"),lang(225),drop_databases([DB]));}elseif(DB!==$_){if(DB!=""){$_GET["db"]=$_;queries_redirect(preg_replace('~\bdb=[^&]*&~','',ME)."db=".urlencode($_),lang(226),rename_database($_,$J["collation"]));}else{$f=explode("\n",str_replace("\r","",$_));$Yk=true;$gg="";foreach($f
as$g){if(count($f)==1||$g!=""){if(!create_database($g,$J["collation"]))$Yk=false;$gg=$g;}}restart_session();set_session("dbs",null);queries_redirect(ME."db=".urlencode($gg),lang(227),$Yk);}}else{if(!$J["collation"])redirect(substr(ME,0,-1));query_redirect("ALTER DATABASE ".idf_escape($_).(preg_match('~^[a-z0-9_]+$~i',$J["collation"])?" COLLATE $J[collation]":""),substr(ME,0,-1),lang(228));}}if(DB!="")page_header(lang(70).": ".h(DB),[lang(70)]);else
page_header(lang(75),[lang(75)]);$_=DB;if($_POST)$_=$J["name"];elseif(DB!="")$J["collation"]=db_collation(DB,collations());elseif(DIALECT=="sql"){foreach(get_vals("SHOW GRANTS")as$ze){if(preg_match('~ ON (`(([^\\\\`]|``|\\\\.)*)%`\.\*)?~',$ze,$y)&&$y[1]){$_=stripcslashes(idf_unescape("`$y[2]`"));break;}}}$Cb=Admin::get()->getCollations($J["collation"]?[$J["collation"]]:[]);echo"\n";}elseif(isset($_GET["scheme"])){$J=$_POST;if($_POST){$w=preg_replace('~ns=[^&]*&~','',ME)."ns=";if($_POST["drop"])query_redirect("DROP SCHEMA ".idf_escape($_GET["ns"]),$w,lang(229));else{$_=trim($J["name"]);$w
.=urlencode($_);if($_GET["ns"]=="")query_redirect("CREATE SCHEMA ".idf_escape($_),$w,lang(230));elseif($_GET["ns"]!=$_)query_redirect("ALTER SCHEMA ".idf_escape($_GET["ns"])." RENAME TO ".idf_escape($_),$w,lang(231));else
redirect($w);}}if($_GET["ns"]!="")page_header(lang(71).": ".h($_GET["ns"]),[lang(71)]);else
page_header(lang(76),[lang(76)]);if(!$J)$J["name"]=$_GET["ns"];echo"\n";}elseif(isset($_GET["call"])){$na=$_GET["name"]?:$_GET["call"];page_header(lang(232).": ".h($na),[lang(232)]);$Mj=routine($_GET["call"],(isset($_GET["callf"])?"FUNCTION":"PROCEDURE"));$gf=[];$oi=[];foreach($Mj["fields"]as$p=>$j){if(substr($j["inout"],-3)=="OUT"&&DIALECT=='sql')$oi[$p]="@".idf_escape($j["field"])." AS ".idf_escape($j["field"]);if(!$j["inout"]||substr($j["inout"],0,2)=="IN")$gf[]=$p;}if($_POST){$lb=[];foreach($Mj["fields"]as$t=>$j){$W="";if(in_array($t,$gf)){$W=process_input($j);if($W===false)$W="''";if(isset($oi[$t]))Connection::get()->query("SET @".idf_escape($j["field"])." = $W");}if(isset($oi[$t]))$lb[]="@".idf_escape($j["field"]);elseif(in_array($t,$gf))$lb[]=$W;}$G=(isset($_GET["callf"])?"SELECT ":"CALL ").($Mj["returns"]&&$Mj["returns"]["type"]=="record"?"* FROM ":"").table($na)."(".implode(", ",$lb).")";$Rk=microtime(true);$H=Connection::get()->multiQuery($G);$_a=Connection::get()->getAffectedRows();echo
Admin::get()->formatSelectQuery($G,$Rk,!$H);if(!$H)echo"".error()."\n";else{$Vb=connect();if($Vb)$Vb->selectDatabase(DB);do{$H=Connection::get()->storeResult();if(is_object($H))print_select_result($H,$Vb);else
echo"
".lang(233,$_a)." ".@date("H:i:s")." \n";}while(Connection::get()->nextResult());if($oi)print_select_result(Connection::get()->query("SELECT ".implode(", ",$oi)));}}echo"
\n";$Lb=$Mj["comment"];if($Lb!==null&&$Lb!==""){$Lb=h(trim($Mj["comment"],"\n"));if(preg_match('~^ +~',$Lb,$z)){preg_match_all("~^($z[0]|$)~m",$Lb,$ug);if(count($ug[0])==substr_count($Lb,"\n"))$Lb=preg_replace("~^($z[0])~m","",$Lb);}$Lb=preg_replace('~(^|[^\n]\n)(Description|Parameters|Example)\n~',"$1\n$2 \n",$Lb);echo"\n";}}elseif(isset($_GET["foreign"])){$a=$_GET["foreign"];$_=$_GET["name"];$J=$_POST;if($_POST&&!$_POST["add"]&&!$_POST["change"]&&!$_POST["change-js"]){if(!$_POST["drop"]){$J["source"]=array_filter($J["source"],'strlen');ksort($J["source"]);$Bl=[];foreach($J["source"]as$t=>$W)$Bl[$t]=$J["target"][$t];$J["target"]=$Bl;}if(DIALECT=="sqlite")$H=recreate_table($a,$a,[],[],[" $_"=>($J["drop"]?"":" ".format_foreign_key($J))]);else{$Ha="ALTER TABLE ".table($a);$H=($_==""||queries("$Ha DROP ".(DIALECT=="sql"?"FOREIGN KEY ":"CONSTRAINT ").idf_escape($_)));if(!$J["drop"])$H=queries("$Ha ADD".format_foreign_key($J));}queries_redirect(ME."table=".urlencode($a),($J["drop"]?lang(234):($_!=""?lang(235):lang(236))),(bool)$H);if(!$J["drop"])Admin::get()->addError(lang(237));}if($_!="")page_header(lang(238).": ".h($_),["table"=>$a,lang(238)]);else
page_header(lang(179).": ".h($a),["table"=>$a,lang(179)]);if($_POST){ksort($J["source"]);if($_POST["change"]||$_POST["change-js"])$J["target"]=[];else$J["source"][]="";}elseif($_!=""){$ke=foreign_keys($a);$J=$ke[$_];$J["source"][]="";}else{$J["table"]=$a;$J["source"]=[""];}echo"\n";}elseif(isset($_GET["view"])){$a=$_GET["view"];$J=$_POST;$li="VIEW";if(DIALECT=="pgsql"&&$a!=""){$O=table_status1($a);$li=strtoupper($O["Engine"]);}if($_POST){$_=trim($J["name"]);$Ma=" AS\n$J[select]";$x=ME."table=".urlencode($_);$Wg=lang(243);$T=($_POST["materialized"]?"MATERIALIZED VIEW":"VIEW");if(!$_POST["drop"]&&$a==$_&&DIALECT!="sqlite"&&$T=="VIEW"&&$li=="VIEW")query_redirect((DIALECT=="mssql"?"ALTER":"CREATE OR REPLACE")." VIEW ".table($_).$Ma,$x,$Wg);else{$Dl=$_."_adminneo_".uniqid();drop_create("DROP $li ".table($a),"CREATE $T ".table($_).$Ma,"DROP $T ".table($_),"CREATE $T ".table($Dl).$Ma,"DROP $T ".table($Dl),($_POST["drop"]?substr(ME,0,-1):$x),lang(244),$Wg,lang(245),$a,$_);}}if(!$_POST&&$a!=""){$J=view($a);$J["name"]=$a;$J["materialized"]=($li!="VIEW");if($i=error())Admin::get()->addError($i);}if($a!="")page_header(lang(37).": ".h($a),["table"=>$a,lang(37)]);else
page_header(lang(246),[lang(246)]);echo"\n";}elseif(isset($_GET["procedure"])){$na=($_GET["name"]?:$_GET["procedure"]);$Mj=(isset($_GET["function"])?"FUNCTION":"PROCEDURE");$J=$_POST;$J["fields"]=(array)$J["fields"];if($_POST&&!process_fields($J["fields"])){foreach($J["fields"]as$t=>$j){if($j["field"]=="")unset($J["fields"][$t]);}$Kh=routine_id($na,routine($_GET["procedure"],$Mj));$xh=routine_id($J["name"],$J);$gc=create_routine($Mj,$J);$x=substr(ME,0,-1);$Wg=lang(247);if(!$_POST["drop"]&&$Kh==$xh&&(DIALECT!="sql"||Connection::get()->isMariaDB()))query_redirect(substr_replace($gc,' OR REPLACE',6,0),$x,$Wg);else{$Dl="$J[name]_adminer_".uniqid();drop_create("DROP $Mj $Kh",$gc,"DROP $Mj $xh",create_routine($Mj,["name"=>$Dl]+$J),"DROP $Mj ".routine_id($Dl,$J),$x,lang(248),$Wg,lang(249),$na,$J["name"]);}}if($na!=""){$S=isset($_GET["function"])?lang(250):lang(251);page_header($S.": ".h($na),[$S]);}else{$S=isset($_GET["function"])?lang(252):lang(253);page_header($S,[$S]);}if(!$_POST){if($na=="")$J["language"]="sql";else{$J=routine($_GET["procedure"],$Mj);$J["name"]=$na;}}$nb=get_vals("SHOW CHARACTER SET");sort($nb);$Nj=routine_languages();echo"\n";}elseif(isset($_GET["sequence"])){$pa=$_GET["sequence"];$J=$_POST;if($_POST){$w=substr(ME,0,-1);$_=trim($J["name"]);if($_POST["drop"])query_redirect("DROP SEQUENCE ".idf_escape($pa),$w,lang(255));elseif($pa=="")query_redirect("CREATE SEQUENCE ".idf_escape($_),$w,lang(256));elseif($pa!=$_)query_redirect("ALTER SEQUENCE ".idf_escape($pa)." RENAME TO ".idf_escape($_),$w,lang(257));else
redirect($w);}if($pa!="")page_header(lang(258).": ".h($pa),[h($pa)]);else
page_header(lang(259),[lang(260)]);if(!$J)$J["name"]=$pa;echo"\n";}elseif(isset($_GET["type"])){$qa=$_GET["type"];$J=$_POST;if($_POST){$w=substr(ME,0,-1);if($_POST["drop"])query_redirect("DROP TYPE ".idf_escape($qa),$w,lang(261));else
query_redirect("CREATE TYPE ".idf_escape(trim($J["name"]))." $J[as]",$w,lang(262));}if($qa!="")page_header(lang(263).": ".h($qa),[h($qa)]);else
page_header(lang(260),[lang(260)]);if(!$J)$J["as"]="AS ";echo"\n";}elseif(isset($_GET["check"])){$a=$_GET["check"];$_=$_GET["name"];$J=$_POST;if($J){if(DIALECT=="sqlite")$Yk=recreate_table($a,$a,[],[],[],"",[],"$_",($J["drop"]?"":$J["clause"]));else{$Yk=($_==""||queries("ALTER TABLE ".table($a)." DROP CONSTRAINT ".idf_escape($_)));if(!$J["drop"])$Yk=(bool)queries("ALTER TABLE ".table($a)." ADD".($J["name"]!=""?" CONSTRAINT ".idf_escape($J["name"]):"")." CHECK ($J[clause])");}queries_redirect(ME."table=".urlencode($a),($J["drop"]?lang(264):($_!=""?lang(265):lang(266))),$Yk);}if($_!="")page_header(lang(267).": ".h($_),["table"=>$a,lang(267)]);else
page_header(lang(181).": ".h($a),["table"=>$a,lang(181)]);if(!$J){$tb=Driver::get()->checkConstraints($a);$J=["name"=>$_,"clause"=>$tb[$_]];}echo"\n";}elseif(isset($_GET["trigger"])){$a=$_GET["trigger"];$_=isset($_GET["name"])?$_GET["name"]:"";$em=trigger_options();$J=trigger($_,$a)+["Trigger"=>$a."_bi"];if($_POST){if(in_array($_POST["Timing"],$em["Timing"])&&in_array($_POST["Event"],$em["Event"])&&in_array($_POST["Type"],$em["Type"])){$Mh=" ON ".table($a);$Wc="DROP TRIGGER ".idf_escape($_).(DIALECT=="pgsql"?$Mh:"");$x=ME."table=".urlencode($a);if($_POST["drop"])query_redirect($Wc,$x,lang(268));else{if($_!="")queries($Wc);queries_redirect($x,($_!=""?lang(269):lang(270)),(bool)queries(create_trigger($Mh,$_POST)));if($_!="")queries(create_trigger($Mh,$J+["Type"=>reset($em["Type"])]));}}$J=$_POST;}if($_!="")page_header(lang(271).": ".h($_),["table"=>$a,lang(271)]);else
page_header(lang(183).": ".h($a),["table"=>$a,lang(183)]);echo"\n";}elseif(isset($_GET["processlist"])){if(support("kill")){if($_POST){$Yf=0;foreach((array)$_POST["kill"]as$W){if(kill_process($W))$Yf++;}queries_redirect(ME."processlist=",lang(274,$Yf),$Yf||!$_POST["kill"]);}}page_header(lang(157),[lang(157)]);echo"\n",script("tableCheck();");}elseif(isset($_GET["select"])){$a=$_GET["select"];$R=table_status1($a);$s=indexes($a);$k=fields($a);$ke=column_foreign_keys($a);$Gh=$R["Oid"];$Kj=[];$c=[];$bk=[];$bi=[];$Il=null;foreach($k
as$t=>$j){$_=Admin::get()->getFieldName($j);$sh=html_entity_decode(strip_tags($_),ENT_QUOTES);if(isset($j["privileges"]["select"])&&$_!=""){$c[$t]=$sh;if(is_shortable($j))$Il=Admin::get()->processSelectionLength();}if(isset($j["privileges"]["where"])&&$_!="")$bk[$t]=$sh;if(isset($j["privileges"]["order"])&&$_!="")$bi[$t]=$sh;$Kj+=$j["privileges"];}list($L,$_e)=Admin::get()->processSelectionColumns($c,$s);$L=array_unique($L);$_e=array_unique($_e);$If=count($_e)processSelectionSearch($k,$s);$C=Admin::get()->processSelectionOrder($k,$s);$v=Admin::get()->processSelectionLimit();if($_GET["modify"]&&!Admin::get()->isDataEditAllowed())redirect(ME."select=".urlencode($a));if($_GET["val"]&&is_ajax()){header("Content-Type: text/plain; charset=utf-8");foreach($_GET["val"]as$nm=>$J){$Ma=convert_field($k[key($J)]);$L=[$Ma?:idf_escape(key($J))];$Z[]=where_check($nm,$k);$I=Driver::get()->select($a,$L,$Z,$L);if($I)echo
first($I->fetchRow());}exit;}$cj=$qm=[];foreach($s
as$r){if($r["type"]=="PRIMARY"){$cj=array_flip($r["columns"]);$qm=($L?$cj:[]);foreach($qm
as$t=>$W){if(in_array(idf_escape($t),$L))unset($qm[$t]);}break;}}if($Gh&&!$cj){$cj=$qm=[$Gh=>0];$s[]=["type"=>"PRIMARY","columns"=>[$Gh]];}$N=Admin::get()->getSettings();if($_POST){$Ym=$Z;if(!$_POST["all"]&&is_array($_POST["check"])){$tb=[];foreach($_POST["check"]as$ob)$tb[]=where_check($ob,$k);$Ym[]="((".implode(") OR (",$tb)."))";}$Ym=($Ym?"\nWHERE ".implode(" AND ",$Ym):"");if($_POST["export"]){$N->updateParameters(["exportFormat"=>$_POST["format"],"exportOutput"=>$_POST["output"],]);dump_headers($a);Admin::get()->dumpTable($a,"");$se=($L?implode(", ",$L):"*").convert_fields($c,$k,$L)."\nFROM ".table($a);$Ce=($_e&&$If?"\nGROUP BY ".implode(", ",$_e):"").($C?"\nORDER BY ".implode(", ",$C):"");if(!is_array($_POST["check"])||$cj)$G="SELECT $se$Ym$Ce";else{$km=[];foreach($_POST["check"]as$W)$km[]="(SELECT".limit($se,"\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($W,$k).$Ce,1).")";$G=implode(" UNION ALL ",$km);}Admin::get()->dumpData($a,"table",$G);exit;}if($_POST["save"]||$_POST["delete"]){$H=true;$_a=0;$yk=[];if(!$_POST["delete"]){$jk=array_keys($_POST["fields"]+$_POST["function"]);foreach($jk
as$_){$W=process_input($k[$_]);if($W!==null&&($_POST["clone"]||$W!==false))$yk[idf_escape($_)]=($W!==false?$W:idf_escape($_));}}if($_POST["delete"]||$yk){if($_POST["clone"])$G="INTO ".table($a)." (".implode(", ",array_keys($yk)).")\nSELECT ".implode(", ",$yk)."\nFROM ".table($a);if($_POST["all"]||($cj&&is_array($_POST["check"]))||$If){$H=($_POST["delete"]?Driver::get()->delete($a,$Ym):($_POST["clone"]?queries("INSERT $G$Ym".Driver::get()->getInsertReturningSql($a)):Driver::get()->update($a,$yk,$Ym)));$_a=Connection::get()->getAffectedRows();if(is_object($H))$_a+=$H->getRowsCount();}else{foreach((array)$_POST["check"]as$W){$Xm="\nWHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($W,$k);$H=($_POST["delete"]?Driver::get()->delete($a,$Xm,1):($_POST["clone"]?queries("INSERT".limit1($a,$G,$Xm)):Driver::get()->update($a,$yk,$Xm,1)));if(!$H)break;$_a+=Connection::get()->getAffectedRows();}}}$Wg=lang(278,$_a);if($_POST["clone"]&&$H&&$_a==1){$hg=last_id($H);if($hg)$Wg=lang(211," $hg");}queries_redirect(remove_from_uri($_POST["all"]&&$_POST["delete"]?"page":""),$Wg,(bool)$H);if(!$_POST["delete"]){$hd=array_filter($k,function($j){return!(isset($j["generated"])?$j["generated"]:null);});edit_form($a,$hd,(array)$_POST["fields"],!$_POST["clone"]);page_footer();exit;}}elseif(!$_POST["import"]){if(!$_POST["val"])Admin::get()->addError(lang(279));else{$Yk=true;$_a=0;foreach($_POST["val"]as$nm=>$J){$yk=[];foreach($J
as$t=>$W){$t=bracket_escape($t,true);$yk[idf_escape($t)]=(preg_match('~char|text~',$k[$t]["type"])||$W!=""?Admin::get()->processFieldInput($k[$t],$W):"NULL");}$Yk=(bool)Driver::get()->update($a,$yk," WHERE ".($Z?implode(" AND ",$Z)." AND ":"").where_check($nm,$k),($If||$cj?0:1)," ");if(!$Yk)break;$_a+=Connection::get()->getAffectedRows();}queries_redirect(remove_from_uri(),lang(278,$_a),$Yk);}}elseif(!is_string($l=get_file("csv_file",true)))Admin::get()->addError(upload_error($l));elseif(!preg_match('~~u',$l))Admin::get()->addError(lang(280));else{$N->updateParameter("exportFormat",$_POST["import_format"]);$Gb=array_keys($k);preg_match_all('~(?>"[^"]*"|[^"\r\n]+)+~',$l,$z);$_a=count($z[0]);Driver::get()->begin();$kk=($_POST["import_format"]=="csv;"?";":($_POST["import_format"]=="tsv"?"\t":","));$K=[];foreach($z[0]as$t=>$W){preg_match_all("~((?>\"[^\"]*\")+|[^$kk]*)$kk~",$W.$kk,$Hg);if(!$t&&!array_diff($Hg[1],$Gb)){$Gb=$Hg[1];$_a--;}else{$yk=[];foreach($Hg[1]as$p=>$_b)$yk[idf_escape($Gb[$p])]=($_b==""&&$k[$Gb[$p]]["null"]?"NULL":q(preg_match('~^".*"$~s',$_b)?str_replace('""','"',substr($_b,1,-1)):$_b));$K[]=$yk;}}$Yk=!$K||Driver::get()->insertUpdate($a,$K,$cj);if($Yk)Driver::get()->commit();queries_redirect(remove_from_uri("page"),lang(281,$_a),$Yk);Driver::get()->rollback();}}$ol=Admin::get()->getTableName($R);if(is_ajax()){page_headers();ob_start();}else
page_header(lang(56).": $ol",[$ol]);$yf=null;if(isset($Kj["insert"])||!support("table")){$yf=[];foreach((array)$_GET["where"]as$W){if(isset($ke[$W["col"]])&&count($ke[$W["col"]])==1&&($W["op"]=="="||(!$W["op"]&&(is_array($W["val"])||!preg_match('~[_%]~',$W["val"])))))$yf["preset"."[".bracket_escape($W["col"])."]"]=$W["val"];}}Admin::get()->printTableMenu($R,$yf);if(!$c&&support("table"))echo"".lang(282).($k?".":": ".error())."\n";else{echo"
\n";$D=isset($_GET["page"])?$_GET["page"]:null;if($D=="last"){$qe=Connection::get()->getValue(count_rows($a,$Z,$If,$_e));$D=(int)floor(max(0,intval($qe)-1)/$v);}else{$qe=false;$D=(int)$D;}$ck=$L;$Ae=$_e;if(!$ck){$ck[]="*";$dc=convert_fields($c,$k,$L);if($dc)$ck[]=substr($dc,2);}foreach($L
as$t=>$W){$j=$k[idf_unescape($W)];if($j&&($Ma=convert_field($j)))$ck[$t]="$Ma AS $W";}if(DIALECT=="pgsql"||DIALECT=="mssql"){foreach((array)$_GET["columns"]as$t=>$W){if(isset($ck[$t])&&$W["fun"])$ck[$t].=" AS ".idf_escape(apply_sql_function($W["fun"],($W["col"]!=""?$W["col"]:"*")));}}if(!$If&&$qm){foreach($qm
as$t=>$W){$ck[]=idf_escape($t);if($Ae)$Ae[]=idf_escape($t);}}$H=Driver::get()->select($a,$ck,$Z,$Ae,$C,$v,$D,true);if(!$H)echo"".error()."\n";else{if(DIALECT=="mssql"&&$D)$H->seek($v*$D);$K=[];while($J=$H->fetchAssoc()){if($D&&DIALECT=="oracle")unset($J["RNUM"]);$K[]=$J;}if($_GET["modify"]&&$K){$Pg=max_input_vars(count($K[0])+1,20);echo($Pg&&count($K)>$Pg?"
".max_input_vars_error()."\n":"");}echo"
\n",(!$_e&&$L?"":script("tableCheck();"));}else
echo"\n";}}if(is_ajax()){ob_end_clean();exit;}}elseif(isset($_GET["variables"])){$O=isset($_GET["status"]);$S=$O?lang(159):lang(158);page_header($S,[$S]);$Gm=($O?Admin::get()->getStatusVariables():Admin::get()->getServerVariables());if(!$Gm)echo"",lang(91),"
\n";else{echo"\n";}}elseif(isset($_GET["script"])){header("Content-Type: text/javascript; charset=utf-8");if($_GET["script"]=="db"){$bl=["Data_length"=>0,"Index_length"=>0,"Data_free"=>0];$e=[];$sc=null;foreach(table_status()as$_=>$R){$e["Comment-$_"]=h($R["Comment"]);if(!is_view($R)||preg_match('~materialized~i',$R["Engine"])){$e["Engine-$_"]=h($R["Engine"]);$Bb=isset($R["Collation"])?$R["Collation"]:"";if($Bb==""){if($sc===null)$sc=db_collation(DB,collations())??"";$Bb=$sc;}$e["Collation-$_"]=h($Bb);foreach($bl+["Auto_increment"=>0,"Rows"=>0]as$t=>$W){if($R[$t]!=""){$W=format_number($R[$t]);if($W>=0)$e["$t-$_"]=($t=="Rows"?format_rows($R):$W);if(isset($bl[$t]))$bl[$t]+=($R["Engine"]!="InnoDB"||$t!="Data_free"?$R[$t]:0);}elseif(array_key_exists($t,$R))$e["$t-$_"]="?";}}}if(function_exists('AdminNeo\db_status'))$bl=db_status();foreach($bl
as$t=>$W)$e["sum-$t"]=format_number($W);echo
json_encode($e,JSON_UNESCAPED_UNICODE);}elseif($_GET["script"]=="kill")Connection::get()->query("KILL ".number($_POST["kill"]));else{$e=[];foreach(count_tables(Admin::get()->getDatabases(false))as$g=>$W){$e["tables-$g"]=$W;$e["size-$g"]=db_size($g);}echo
json_encode($e,JSON_UNESCAPED_UNICODE);}exit;}else{$zl=array_merge((array)$_POST["tables"],(array)$_POST["views"]);if($zl&&!$_POST["search"]){$H=true;$Wg="";if(DIALECT=="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"])$H=truncate_tables($_POST["tables"]);$Wg=lang(291);}elseif($_POST["move"]){$H=move_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$Wg=lang(292);}elseif($_POST["copy"]){$H=copy_tables((array)$_POST["tables"],(array)$_POST["views"],$_POST["target"]);$Wg=lang(293);}elseif($_POST["drop"]){if($_POST["views"])$H=drop_views($_POST["views"]);if($H&&$_POST["tables"])$H=drop_tables($_POST["tables"]);$Wg=lang(294);}elseif(DIALECT=="sqlite"&&$_POST["check"]){foreach((array)$_POST["tables"]as$Q){foreach(get_rows("PRAGMA integrity_check(".q($Q).")")as$J)$Wg
.="".h($Q)." : ".h($J["integrity_check"])."".h($J["Table"])." : ".h($J["Msg_text"])."".lang(296)." \n";$Yj=Admin::get()->getSchemas();if(!$Yj)echo"".lang(297)."\n";else{echo"
';}echo''.icon("database-add").lang(76)." \n";}else{echo"
".lang(299)." \n";$tl=['sql'=>'show-table-status.html','mariadb'=>'reference/sql-statements/administrative-sql-statements/show/show-table-status'];$sc=db_collation(DB,collations());$c=["Engine"=>["label"=>lang(171),"doc"=>'',],];if($sc!="")$c["Collation"]=["label"=>lang(46),"doc"=>'',];$c+=["Data_length"=>["label"=>lang(300),"doc"=>doc_link($tl+['pgsql'=>'functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT','oracle'=>'REFRN20286']),"link"=>"create","title"=>lang(36),],"Index_length"=>["label"=>lang(301),"doc"=>doc_link($tl+['pgsql'=>'functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT']),"link"=>"indexes","title"=>lang(175),],"Data_free"=>["label"=>lang(302),"doc"=>doc_link($tl),"link"=>"edit","title"=>lang(8),],"Auto_increment"=>["label"=>lang(48),"doc"=>'',"link"=>"auto_increment=1&create","title"=>lang(36),],"Rows"=>["label"=>lang(303),"doc"=>doc_link($tl+['pgsql'=>'catalog-pg-class.html#CATALOG-PG-CLASS','oracle'=>'REFRN20286']),"link"=>"select","title"=>lang(34),],];if(support("comment"))$c["Comment"]=["label"=>lang(47),"doc"=>doc_link($tl+['pgsql'=>'functions-info.html#FUNCTIONS-INFO-COMMENT-TABLE']),];$C=(is_string($_GET["order"])?$_GET["order"]:"");$Dc=null;if(preg_match('~^(.+)-(asc|desc)$~',$C,$y)){$C=$y[1];$Dc=($y[2]=="desc");}if($C!="__table"&&!isset($c[$C]))$C="";if($Dc===null)$Dc=isset($c[$C]["link"]);$bn=($C!=""&&$C!="__table")||support("fast_status");$xl=($bn?table_status():tables_list());if(!$xl)echo"".lang(78)."\n";else{echo"
\n",script("tableCheck();");}echo'',icon("table-add"),lang(77)," \n";if(support("view"))echo'',icon("view-add"),lang(246)," \n";if(support("routine")){echo"
".lang(186)." \n";$Oj=routines();if($Oj){$Nb=$Oj[0]["ROUTINE_COMMENT"]!==null;echo"\n",'','',lang(223),' ',lang(45),' ',lang(254)," ";if($Nb)echo"",lang(47)," ";echo" ','',h($J["ROUTINE_NAME"]),' ',h($J["ROUTINE_TYPE"]),' ','',h($J["DTD_IDENTIFIER"]),' ';if($Nb)echo'',truncate_utf8(preg_replace('~\s{2,}~'," ",trim($J["ROUTINE_COMMENT"])),50),' ';echo''.lang(178)."
\n";}echo'';if(support("procedure"))echo'',icon("function-add"),lang(253)," ";echo'',icon("function-add"),lang(252)," \n","
\n";}if(support("sequence")){echo"".lang(315)." \n";$nk=get_vals("SELECT sequence_name FROM information_schema.sequences WHERE sequence_schema = current_schema() ORDER BY sequence_name");if($nk){echo"\n","",lang(223)," ","",h($W)," ","",lang(178),"
\n";}echo"",icon("add"),lang(259),"
\n";}if(support("type")){echo"".lang(110)." \n";$Am=types();if($Am){echo"\n","",lang(223)," ","",h($W)," ","",lang(178),"
\n";}echo"",icon("add"),lang(260),"
\n";}}}page_footer();