".error()."\n";return$J;}function table_status($C="",$Fc=false){$J=array();foreach(($C!=""?array($C=>true):tables_list())as$R=>$U){$K=array("Name"=>$R,"Auto_increment"=>"");if(!$Fc){$xe=sdb_request('DomainMetadata',array('DomainName'=>$R));if($xe){foreach(array("Rows"=>"ItemCount","Data_length"=>"ItemNamesSizeBytes","Index_length"=>"AttributeValuesSizeBytes","Data_free"=>"AttributeNamesSizeBytes",)as$y=>$X)$K[$y]=(string)$xe->$X;}}if($C!="")return$K;$J[$R]=$K;}return$J;}function explain($g,$H){}function error(){global$g;return h($g->error);}function information_schema(){}function is_view($S){}function indexes($R,$h=null){return array(array("type"=>"PRIMARY","columns"=>array("itemName()")),);}function fields($R){return fields_from_edit();}function foreign_keys($R){return array();}function table($u){return idf_escape($u);}function idf_escape($u){return"`".str_replace("`","``",$u)."`";}function limit($H,$Z,$z,$D=0,$Dg=" "){return" $H$Z".($z!==null?$Dg."LIMIT $z":"");}function unconvert_field($o,$J){return$J;}function fk_support($S){}function engines(){return array();}function alter_table($R,$C,$p,$Rc,$sb,$oc,$nb,$La,$wf){return($R==""&&sdb_request('CreateDomain',array('DomainName'=>$C)));}function drop_tables($T){foreach($T as$R){if(!sdb_request('DeleteDomain',array('DomainName'=>$R)))return false;}return true;}function count_tables($l){foreach($l as$m)return array($m=>count(tables_list()));}function found_rows($S,$Z){return($Z?null:$S["Rows"]);}function last_id(){}function hmac($Ba,$Gb,$y,$Zf=false){$Ua=64;if(strlen($y)>$Ua)$y=pack("H*",$Ba($y));$y=str_pad($y,$Ua,"\0");$Ld=$y^str_repeat("\x36",$Ua);$Md=$y^str_repeat("\x5C",$Ua);$J=$Ba($Md.pack("H*",$Ba($Ld.$Gb)));if($Zf)$J=pack("H*",$J);return$J;}function sdb_request($va,$F=array()){global$b,$g;list($md,$F['AWSAccessKeyId'],$_g)=$b->credentials();$F['Action']=$va;$F['Timestamp']=gmdate('Y-m-d\TH:i:s+00:00');$F['Version']='2009-04-15';$F['SignatureVersion']=2;$F['SignatureMethod']='HmacSHA1';ksort($F);$H='';foreach($F as$y=>$X)$H.='&'.rawurlencode($y).'='.rawurlencode($X);$H=str_replace('%7E','~',substr($H,1));$H.="&Signature=".urlencode(base64_encode(hmac('sha1',"POST\n".preg_replace('~^https?://~','',$md)."\n/\n$H",$_g,true)));@ini_set('track_errors',1);$Jc=@file_get_contents((preg_match('~^https?://~',$md)?$md:"http://$md"),false,stream_context_create(array('http'=>array('method'=>'POST','content'=>$H,'ignore_errors'=>1,))));if(!$Jc){$g->error=$php_errormsg;return false;}libxml_use_internal_errors(true);$ui=simplexml_load_string($Jc);if(!$ui){$n=libxml_get_last_error();$g->error=$n->message;return false;}if($ui->Errors){$n=$ui->Errors->Error;$g->error="$n->Message ($n->Code)";return false;}$g->error='';$nh=$va."Result";return($ui->$nh?$ui->$nh:true);}function sdb_request_all($va,$nh,$F=array(),$wh=0){$J=array();$Vg=($wh?microtime(true):0);$z=(preg_match('~LIMIT\s+(\d+)\s*$~i',$F['SelectExpression'],$B)?$B[1]:0);do{$ui=sdb_request($va,$F);if(!$ui)break;foreach($ui->$nh as$jc)$J[]=$jc;if($z&&count($J)>=$z){$_GET["next"]=$ui->NextToken;break;}if($wh&µtime(true)-$Vg>$wh)return false;$F['NextToken']=$ui->NextToken;if($z)$F['SelectExpression']=preg_replace('~\d+\s*$~',$z-count($J),$F['SelectExpression']);}while($ui->NextToken);return$J;}$x="simpledb";$Ye=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","IN","IS NULL","NOT LIKE","IS NOT NULL");$Zc=array();$ed=array("count");$gc=array(array("json"));}$Yb["mongo"]="MongoDB (beta)";if(isset($_GET["mongo"])){$Hf=array("mongo");define("DRIVER","mongo");if(class_exists('MongoDB')){class Min_DB{var$extension="Mongo",$error,$last_id,$_link,$_db;function connect($N,$V,$G){global$b;$m=$b->database();$bf=array();if($V!=""){$bf["username"]=$V;$bf["password"]=$G;}if($m!="")$bf["db"]=$m;try{$this->_link=@new MongoClient("mongodb://$N",$bf);return true;}catch(Exception$vc){$this->error=$vc->getMessage();return false;}}function query($H){return false;}function select_db($k){try{$this->_db=$this->_link->selectDB($k);return true;}catch(Exception$vc){$this->error=$vc->getMessage();return false;}}function quote($Q){return$Q;}}class Min_Result{var$num_rows,$_rows=array(),$_offset=0,$_charset=array();function __construct($I){foreach($I as$Id){$K=array();foreach($Id as$y=>$X){if(is_a($X,'MongoBinData'))$this->_charset[$y]=63;$K[$y]=(is_a($X,'MongoId')?'ObjectId("'.strval($X).'")':(is_a($X,'MongoDate')?gmdate("Y-m-d H:i:s",$X->sec)." GMT":(is_a($X,'MongoBinData')?$X->bin:(is_a($X,'MongoRegex')?strval($X):(is_object($X)?get_class($X):$X)))));}$this->_rows[]=$K;foreach($K as$y=>$X){if(!isset($this->_rows[0][$y]))$this->_rows[0][$y]=null;}}$this->num_rows=count($this->_rows);}function fetch_assoc(){$K=current($this->_rows);if(!$K)return$K;$J=array();foreach($this->_rows[0]as$y=>$X)$J[$y]=$K[$y];next($this->_rows);return$J;}function fetch_row(){$J=$this->fetch_assoc();if(!$J)return$J;return array_values($J);}function fetch_field(){$Od=array_keys($this->_rows[0]);$C=$Od[$this->_offset++];return(object)array('name'=>$C,'charsetnr'=>$this->_charset[$C],);}}}class Min_Driver extends Min_SQL{public$Kf="_id";function select($R,$M,$Z,$cd,$df=array(),$z=1,$E=0,$Mf=false){$M=($M==array("*")?array():array_fill_keys($M,true));$Pg=array();foreach($df as$X){$X=preg_replace('~ DESC$~','',$X,1,$Bb);$Pg[$X]=($Bb?-1:1);}return new Min_Result($this->_conn->_db->selectCollection($R)->find(array(),$M)->sort($Pg)->limit(+$z)->skip($E*$z));}function insert($R,$O){try{$J=$this->_conn->_db->selectCollection($R)->insert($O);$this->_conn->errno=$J['code'];$this->_conn->error=$J['err'];$this->_conn->last_id=$O['_id'];return!$J['err'];}catch(Exception$vc){$this->_conn->error=$vc->getMessage();return false;}}}function connect(){global$b;$g=new Min_DB;$j=$b->credentials();if($g->connect($j[0],$j[1],$j[2]))return$g;return$g->error;}function error(){global$g;return h($g->error);}function logged_user(){global$b;$j=$b->credentials();return$j[1];}function get_databases($Qc){global$g;$J=array();$Kb=$g->_link->listDBs();foreach($Kb['databases']as$m)$J[]=$m['name'];return$J;}function collations(){return array();}function db_collation($m,$ob){}function count_tables($l){global$g;$J=array();foreach($l as$m)$J[$m]=count($g->_link->selectDB($m)->getCollectionNames(true));return$J;}function tables_list(){global$g;return array_fill_keys($g->_db->getCollectionNames(true),'table');}function table_status($C="",$Fc=false){$J=array();foreach(tables_list()as$R=>$U){$J[$R]=array("Name"=>$R);if($C==$R)return$J[$R];}return$J;}function information_schema(){}function is_view($S){}function drop_databases($l){global$g;foreach($l as$m){$kg=$g->_link->selectDB($m)->drop();if(!$kg['ok'])return false;}return true;}function indexes($R,$h=null){global$g;$J=array();foreach($g->_db->selectCollection($R)->getIndexInfo()as$v){$Qb=array();foreach($v["key"]as$d=>$U)$Qb[]=($U==-1?'1':null);$J[$v["name"]]=array("type"=>($v["name"]=="_id_"?"PRIMARY":($v["unique"]?"UNIQUE":"INDEX")),"columns"=>array_keys($v["key"]),"lengths"=>array(),"descs"=>$Qb,);}return$J;}function fields($R){return fields_from_edit();}function convert_field($o){}function unconvert_field($o,$J){return$J;}function foreign_keys($R){return array();}function fk_support($S){}function engines(){return array();}function found_rows($S,$Z){global$g;return$g->_db->selectCollection($_GET["select"])->count($Z);}function alter_table($R,$C,$p,$Rc,$sb,$oc,$nb,$La,$wf){global$g;if($R==""){$g->_db->createCollection($C);return true;}}function drop_tables($T){global$g;foreach($T as$R){$kg=$g->_db->selectCollection($R)->drop();if(!$kg['ok'])return false;}return true;}function truncate_tables($T){global$g;foreach($T as$R){$kg=$g->_db->selectCollection($R)->remove();if(!$kg['ok'])return false;}return true;}function alter_indexes($R,$c){global$g;foreach($c as$X){list($U,$C,$O)=$X;if($O=="DROP")$J=$g->_db->command(array("deleteIndexes"=>$R,"index"=>$C));else{$e=array();foreach($O as$d){$d=preg_replace('~ DESC$~','',$d,1,$Bb);$e[$d]=($Bb?-1:1);}$J=$g->_db->selectCollection($R)->ensureIndex($e,array("unique"=>($U=="UNIQUE"),"name"=>$C,));}if($J['errmsg']){$g->error=$J['errmsg'];return false;}}return true;}function last_id(){global$g;return$g->last_id;}function table($u){return$u;}function idf_escape($u){return$u;}function support($Gc){return preg_match("~database|indexes~",$Gc);}$x="mongo";$Ye=array("=");$Zc=array();$ed=array();$gc=array(array("json"));}$Yb["elastic"]="Elasticsearch (beta)";if(isset($_GET["elastic"])){$Hf=array("json");define("DRIVER","elastic");if(function_exists('json_decode')){class Min_DB{var$extension="JSON",$server_info,$errno,$error,$_url;function rootQuery($zf,$xb=array(),$ye='GET'){@ini_set('track_errors',1);$Jc=@file_get_contents($this->_url.'/'.ltrim($zf,'/'),false,stream_context_create(array('http'=>array('method'=>$ye,'content'=>json_encode($xb),'ignore_errors'=>1,))));if(!$Jc){$this->error=$php_errormsg;return$Jc;}if(!preg_match('~^HTTP/[0-9.]+ 2~i',$http_response_header[0])){$this->error=$Jc;return false;}$J=json_decode($Jc,true);if($J===null){$this->errno=json_last_error();if(function_exists('json_last_error_msg'))$this->error=json_last_error_msg();else{$wb=get_defined_constants(true);foreach($wb['json']as$C=>$Y){if($Y==$this->errno&&preg_match('~^JSON_ERROR_~',$C)){$this->error=$C;break;}}}}return$J;}function query($zf,$xb=array(),$ye='GET'){return$this->rootQuery(($this->_db!=""?"$this->_db/":"/").ltrim($zf,'/'),$xb,$ye);}function connect($N,$V,$G){preg_match('~^(https?://)?(.*)~',$N,$B);$this->_url=($B[1]?$B[1]:"http://")."$V:$G@$B[2]/";$J=$this->query('');if($J)$this->server_info=$J['version']['number'];return(bool)$J;}function select_db($k){$this->_db=$k;return true;}function quote($Q){return$Q;}}class Min_Result{var$num_rows,$_rows;function __construct($L){$this->num_rows=count($this->_rows);$this->_rows=$L;reset($this->_rows);}function fetch_assoc(){$J=current($this->_rows);next($this->_rows);return$J;}function fetch_row(){return array_values($this->fetch_assoc());}}}class Min_Driver extends Min_SQL{function select($R,$M,$Z,$cd,$df=array(),$z=1,$E=0,$Mf=false){global$b;$Gb=array();$H="$R/_search";if($M!=array("*"))$Gb["fields"]=$M;if($df){$Pg=array();foreach($df as$lb){$lb=preg_replace('~ DESC$~','',$lb,1,$Bb);$Pg[]=($Bb?array($lb=>"desc"):$lb);}$Gb["sort"]=$Pg;}if($z){$Gb["size"]=+$z;if($E)$Gb["from"]=($E*$z);}foreach($Z as$X){list($lb,$We,$X)=explode(" ",$X,3);if($lb=="_id")$Gb["query"]["ids"]["values"][]=$X;elseif($lb.$X!=""){$rh=array("term"=>array(($lb!=""?$lb:"_all")=>$X));if($We=="=")$Gb["query"]["filtered"]["filter"]["and"][]=$rh;else$Gb["query"]["filtered"]["query"]["bool"]["must"][]=$rh;}}if($Gb["query"]&&!$Gb["query"]["filtered"]["query"]&&!$Gb["query"]["ids"])$Gb["query"]["filtered"]["query"]=array("match_all"=>array());$Vg=microtime(true);$zg=$this->_conn->query($H,$Gb);if($Mf)echo$b->selectQuery("$H: ".print_r($Gb,true),format_time($Vg));if(!$zg)return false;$J=array();foreach($zg['hits']['hits']as$ld){$K=array();if($M==array("*"))$K["_id"]=$ld["_id"];$p=$ld['_source'];if($M!=array("*")){$p=array();foreach($M as$y)$p[$y]=$ld['fields'][$y];}foreach($p as$y=>$X){if($Gb["fields"])$X=$X[0];$K[$y]=(is_array($X)?json_encode($X):$X);}$J[]=$K;}return new Min_Result($J);}}function connect(){global$b;$g=new Min_DB;$j=$b->credentials();if($g->connect($j[0],$j[1],$j[2]))return$g;return$g->error;}function support($Gc){return preg_match("~database|table|columns~",$Gc);}function logged_user(){global$b;$j=$b->credentials();return$j[1];}function get_databases(){global$g;$J=$g->rootQuery('_aliases');if($J){$J=array_keys($J);sort($J,SORT_STRING);}return$J;}function collations(){return array();}function db_collation($m,$ob){}function engines(){return array();}function count_tables($l){global$g;$J=$g->query('_mapping');if($J)$J=array_map('count',$J);return$J;}function tables_list(){global$g;$J=$g->query('_mapping');if($J)$J=array_fill_keys(array_keys($J[$g->_db]["mappings"]),'table');return$J;}function table_status($C="",$Fc=false){global$g;$zg=$g->query("_search?search_type=count",array("facets"=>array("count_by_type"=>array("terms"=>array("field"=>"_type",)))),"POST");$J=array();if($zg){foreach($zg["facets"]["count_by_type"]["terms"]as$R){$J[$R["term"]]=array("Name"=>$R["term"],"Engine"=>"table","Rows"=>$R["count"],);if($C!=""&&$C==$R["term"])return$J[$C];}}return$J;}function error(){global$g;return h($g->error);}function information_schema(){}function is_view($S){}function indexes($R,$h=null){return array(array("type"=>"PRIMARY","columns"=>array("_id")),);}function fields($R){global$g;$I=$g->query("$R/_mapping");$J=array();if($I){$he=$I[$R]['properties'];if(!$he)$he=$I[$g->_db]['mappings'][$R]['properties'];if($he){foreach($he as$C=>$o){$J[$C]=array("field"=>$C,"full_type"=>$o["type"],"type"=>$o["type"],"privileges"=>array("insert"=>1,"select"=>1,"update"=>1),);if($o["properties"]){unset($J[$C]["privileges"]["insert"]);unset($J[$C]["privileges"]["update"]);}}}}return$J;}function foreign_keys($R){return array();}function table($u){return$u;}function idf_escape($u){return$u;}function convert_field($o){}function unconvert_field($o,$J){return$J;}function fk_support($S){}function found_rows($S,$Z){return null;}function create_database($m){global$g;return$g->rootQuery(urlencode($m),array(),'PUT');}function drop_databases($l){global$g;return$g->rootQuery(urlencode(implode(',',$l)),array(),'DELETE');}function drop_tables($T){global$g;$J=true;foreach($T as$R)$J=$J&&$g->query(urlencode($R),array(),'DELETE');return$J;}$x="elastic";$Ye=array("=","query");$Zc=array();$ed=array();$gc=array(array("json"));}$Yb=array("server"=>"MySQL")+$Yb;if(!defined("DRIVER")){$Hf=array("MySQLi","MySQL","PDO_MySQL");define("DRIVER","server");if(extension_loaded("mysqli")){class Min_DB extends MySQLi{var$extension="MySQLi";function __construct(){parent::init();}function connect($N="",$V="",$G="",$k=null,$Df=null,$Og=null){mysqli_report(MYSQLI_REPORT_OFF);list($md,$Df)=explode(":",$N,2);$J=@$this->real_connect(($N!=""?$md:ini_get("mysqli.default_host")),($N.$V!=""?$V:ini_get("mysqli.default_user")),($N.$V.$G!=""?$G:ini_get("mysqli.default_pw")),$k,(is_numeric($Df)?$Df:ini_get("mysqli.default_port")),(!is_numeric($Df)?$Df:$Og));return$J;}function set_charset($ab){if(parent::set_charset($ab))return true;parent::set_charset('utf8');return$this->query("SET NAMES $ab");}function result($H,$o=0){$I=$this->query($H);if(!$I)return false;$K=$I->fetch_array();return$K[$o];}function quote($Q){return"'".$this->escape_string($Q)."'";}}}elseif(extension_loaded("mysql")&&!(ini_get("sql.safe_mode")&&extension_loaded("pdo_mysql"))){class Min_DB{var$extension="MySQL",$server_info,$affected_rows,$errno,$error,$_link,$_result;function connect($N,$V,$G){$this->_link=@mysql_connect(($N!=""?$N:ini_get("mysql.default_host")),("$N$V"!=""?$V:ini_get("mysql.default_user")),("$N$V$G"!=""?$G:ini_get("mysql.default_password")),true,131072);if($this->_link)$this->server_info=mysql_get_server_info($this->_link);else$this->error=mysql_error();return(bool)$this->_link;}function set_charset($ab){if(function_exists('mysql_set_charset')){if(mysql_set_charset($ab,$this->_link))return true;mysql_set_charset('utf8',$this->_link);}return$this->query("SET NAMES $ab");}function quote($Q){return"'".mysql_real_escape_string($Q,$this->_link)."'";}function select_db($k){return mysql_select_db($k,$this->_link);}function query($H,$Sh=false){$I=@($Sh?mysql_unbuffered_query($H,$this->_link):mysql_query($H,$this->_link));$this->error="";if(!$I){$this->errno=mysql_errno($this->_link);$this->error=mysql_error($this->_link);return false;}if($I===true){$this->affected_rows=mysql_affected_rows($this->_link);$this->info=mysql_info($this->_link);return true;}return new Min_Result($I);}function multi_query($H){return$this->_result=$this->query($H);}function store_result(){return$this->_result;}function next_result(){return false;}function result($H,$o=0){$I=$this->query($H);if(!$I||!$I->num_rows)return false;return mysql_result($I->_result,0,$o);}}class Min_Result{var$num_rows,$_result,$_offset=0;function __construct($I){$this->_result=$I;$this->num_rows=mysql_num_rows($I);}function fetch_assoc(){return mysql_fetch_assoc($this->_result);}function fetch_row(){return mysql_fetch_row($this->_result);}function fetch_field(){$J=mysql_fetch_field($this->_result,$this->_offset++);$J->orgtable=$J->table;$J->orgname=$J->name;$J->charsetnr=($J->blob?63:0);return$J;}function __destruct(){mysql_free_result($this->_result);}}}elseif(extension_loaded("pdo_mysql")){class Min_DB extends Min_PDO{var$extension="PDO_MySQL";function connect($N,$V,$G){$this->dsn("mysql:charset=utf8;host=".str_replace(":",";unix_socket=",preg_replace('~:(\\d)~',';port=\\1',$N)),$V,$G);return true;}function set_charset($ab){$this->query("SET NAMES $ab");}function select_db($k){return$this->query("USE ".idf_escape($k));}function query($H,$Sh=false){$this->setAttribute(1000,!$Sh);return parent::query($H,$Sh);}}}class Min_Driver extends Min_SQL{function insert($R,$O){return($O?parent::insert($R,$O):queries("INSERT INTO ".table($R)." ()\nVALUES ()"));}function insertUpdate($R,$L,$Kf){$e=array_keys(reset($L));$If="INSERT INTO ".table($R)." (".implode(", ",$e).") VALUES\n";$ji=array();foreach($e as$y)$ji[$y]="$y = VALUES($y)";$bh="\nON DUPLICATE KEY UPDATE ".implode(", ",$ji);$ji=array();$be=0;foreach($L as$O){$Y="(".implode(", ",$O).")";if($ji&&(strlen($If)+$be+strlen($Y)+strlen($bh)>1e6)){if(!queries($If.implode(",\n",$ji).$bh))return false;$ji=array();$be=0;}$ji[]=$Y;$be+=strlen($Y)+2;}return queries($If.implode(",\n",$ji).$bh);}}function idf_escape($u){return"`".str_replace("`","``",$u)."`";}function table($u){return idf_escape($u);}function connect(){global$b,$Rh,$Yg;$g=new Min_DB;$j=$b->credentials();if($g->connect($j[0],$j[1],$j[2])){$g->set_charset(charset($g));$g->query("SET sql_quote_show_create = 1, autocommit = 1");if(version_compare($g->server_info,'5.7.8')>=0){$Yg[lang(23)][]="json";$Rh["json"]=4294967295;}return$g;}$J=$g->error;if(function_exists('iconv')&&!is_utf8($J)&&strlen($vg=iconv("windows-1250","utf-8",$J))>strlen($J))$J=$vg;return$J;}function get_databases($Qc){global$g;$J=get_session("dbs");if($J===null){$H=($g->server_info>=5?"SELECT SCHEMA_NAME FROM information_schema.SCHEMATA":"SHOW DATABASES");$J=($Qc?slow_query($H):get_vals($H));restart_session();set_session("dbs",$J);stop_session();}return$J;}function limit($H,$Z,$z,$D=0,$Dg=" "){return" $H$Z".($z!==null?$Dg."LIMIT $z".($D?" OFFSET $D":""):"");}function limit1($H,$Z){return limit($H,$Z,1);}function db_collation($m,$ob){global$g;$J=null;$i=$g->result("SHOW CREATE DATABASE ".idf_escape($m),1);if(preg_match('~ COLLATE ([^ ]+)~',$i,$B))$J=$B[1];elseif(preg_match('~ CHARACTER SET ([^ ]+)~',$i,$B))$J=$ob[$B[1]][-1];return$J;}function engines(){$J=array();foreach(get_rows("SHOW ENGINES")as$K){if(preg_match("~YES|DEFAULT~",$K["Support"]))$J[]=$K["Engine"];}return$J;}function logged_user(){global$g;return$g->result("SELECT USER()");}function tables_list(){global$g;return get_key_vals($g->server_info>=5?"SELECT TABLE_NAME, TABLE_TYPE FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ORDER BY TABLE_NAME":"SHOW TABLES");}function count_tables($l){$J=array();foreach($l as$m)$J[$m]=count(get_vals("SHOW TABLES IN ".idf_escape($m)));return$J;}function table_status($C="",$Fc=false){global$g;$J=array();foreach(get_rows($Fc&&$g->server_info>=5?"SELECT TABLE_NAME AS Name, ENGINE AS Engine, TABLE_COMMENT AS Comment FROM information_schema.TABLES WHERE TABLE_SCHEMA = DATABASE() ".($C!=""?"AND TABLE_NAME = ".q($C):"ORDER BY Name"):"SHOW TABLE STATUS".($C!=""?" LIKE ".q(addcslashes($C,"%_\\")):""))as$K){if($K["Engine"]=="InnoDB")$K["Comment"]=preg_replace('~(?:(.+); )?InnoDB free: .*~','\\1',$K["Comment"]);if(!isset($K["Engine"]))$K["Comment"]="";if($C!="")return$K;$J[$K["Name"]]=$K;}return$J;}function is_view($S){return$S["Engine"]===null;}function fk_support($S){global$g;return preg_match('~InnoDB|IBMDB2I~i',$S["Engine"])||(preg_match('~NDB~i',$S["Engine"])&&version_compare($g->server_info,'5.6')>=0);}function fields($R){$J=array();foreach(get_rows("SHOW FULL COLUMNS FROM ".table($R))as$K){preg_match('~^([^( ]+)(?:\\((.+)\\))?( unsigned)?( zerofill)?$~',$K["Type"],$B);$J[$K["Field"]]=array("field"=>$K["Field"],"full_type"=>$K["Type"],"type"=>$B[1],"length"=>$B[2],"unsigned"=>ltrim($B[3].$B[4]),"default"=>($K["Default"]!=""||preg_match("~char|set~",$B[1])?$K["Default"]:null),"null"=>($K["Null"]=="YES"),"auto_increment"=>($K["Extra"]=="auto_increment"),"on_update"=>(preg_match('~^on update (.+)~i',$K["Extra"],$B)?$B[1]:""),"collation"=>$K["Collation"],"privileges"=>array_flip(preg_split('~, *~',$K["Privileges"])),"comment"=>$K["Comment"],"primary"=>($K["Key"]=="PRI"),);}return$J;}function indexes($R,$h=null){$J=array();foreach(get_rows("SHOW INDEX FROM ".table($R),$h)as$K){$C=$K["Key_name"];$J[$C]["type"]=($C=="PRIMARY"?"PRIMARY":($K["Index_type"]=="FULLTEXT"?"FULLTEXT":($K["Non_unique"]?($K["Index_type"]=="SPATIAL"?"SPATIAL":"INDEX"):"UNIQUE")));$J[$C]["columns"][]=$K["Column_name"];$J[$C]["lengths"][]=($K["Index_type"]=="SPATIAL"?null:$K["Sub_part"]);$J[$C]["descs"][]=null;}return$J;}function foreign_keys($R){global$g,$Te;static$Af='`(?:[^`]|``)+`';$J=array();$Cb=$g->result("SHOW CREATE TABLE ".table($R),1);if($Cb){preg_match_all("~CONSTRAINT ($Af) FOREIGN KEY ?\\(((?:$Af,? ?)+)\\) REFERENCES ($Af)(?:\\.($Af))? \\(((?:$Af,? ?)+)\\)(?: ON DELETE ($Te))?(?: ON UPDATE ($Te))?~",$Cb,$ke,PREG_SET_ORDER);foreach($ke as$B){preg_match_all("~$Af~",$B[2],$Qg);preg_match_all("~$Af~",$B[5],$oh);$J[idf_unescape($B[1])]=array("db"=>idf_unescape($B[4]!=""?$B[3]:$B[4]),"table"=>idf_unescape($B[4]!=""?$B[4]:$B[3]),"source"=>array_map('idf_unescape',$Qg[0]),"target"=>array_map('idf_unescape',$oh[0]),"on_delete"=>($B[6]?$B[6]:"RESTRICT"),"on_update"=>($B[7]?$B[7]:"RESTRICT"),);}}return$J;}function view($C){global$g;return array("select"=>preg_replace('~^(?:[^`]|`[^`]*`)*\\s+AS\\s+~isU','',$g->result("SHOW CREATE VIEW ".table($C),1)));}function collations(){$J=array();foreach(get_rows("SHOW COLLATION")as$K){if($K["Default"])$J[$K["Charset"]][-1]=$K["Collation"];else$J[$K["Charset"]][]=$K["Collation"];}ksort($J);foreach($J as$y=>$X)asort($J[$y]);return$J;}function information_schema($m){global$g;return($g->server_info>=5&&$m=="information_schema")||($g->server_info>=5.5&&$m=="performance_schema");}function error(){global$g;return h(preg_replace('~^You have an error.*syntax to use~U',"Syntax error",$g->error));}function create_database($m,$nb){return queries("CREATE DATABASE ".idf_escape($m).($nb?" COLLATE ".q($nb):""));}function drop_databases($l){$J=apply_queries("DROP DATABASE",$l,'idf_escape');restart_session();set_session("dbs",null);return$J;}function rename_database($C,$nb){$J=false;if(create_database($C,$nb)){$ig=array();foreach(tables_list()as$R=>$U)$ig[]=table($R)." TO ".idf_escape($C).".".table($R);$J=(!$ig||queries("RENAME TABLE ".implode(", ",$ig)));if($J)queries("DROP DATABASE ".idf_escape(DB));restart_session();set_session("dbs",null);}return$J;}function auto_increment(){$Ma=" PRIMARY KEY";if($_GET["create"]!=""&&$_POST["auto_increment_col"]){foreach(indexes($_GET["create"])as$v){if(in_array($_POST["fields"][$_POST["auto_increment_col"]]["orig"],$v["columns"],true)){$Ma="";break;}if($v["type"]=="PRIMARY")$Ma=" UNIQUE";}}return" AUTO_INCREMENT$Ma";}function alter_table($R,$C,$p,$Rc,$sb,$oc,$nb,$La,$wf){$c=array();foreach($p as$o)$c[]=($o[1]?($R!=""?($o[0]!=""?"CHANGE ".idf_escape($o[0]):"ADD"):" ")." ".implode($o[1]).($R!=""?$o[2]:""):"DROP ".idf_escape($o[0]));$c=array_merge($c,$Rc);$P=($sb!==null?" COMMENT=".q($sb):"").($oc?" ENGINE=".q($oc):"").($nb?" COLLATE ".q($nb):"").($La!=""?" AUTO_INCREMENT=$La":"");if($R=="")return queries("CREATE TABLE ".table($C)." (\n".implode(",\n",$c)."\n)$P$wf");if($R!=$C)$c[]="RENAME TO ".table($C);if($P)$c[]=ltrim($P);return($c||$wf?queries("ALTER TABLE ".table($R)."\n".implode(",\n",$c).$wf):true);}function alter_indexes($R,$c){foreach($c as$y=>$X)$c[$y]=($X[2]=="DROP"?"\nDROP INDEX ".idf_escape($X[1]):"\nADD $X[0] ".($X[0]=="PRIMARY"?"KEY ":"").($X[1]!=""?idf_escape($X[1])." ":"")."(".implode(", ",$X[2]).")");return queries("ALTER TABLE ".table($R).implode(",",$c));}function truncate_tables($T){return apply_queries("TRUNCATE TABLE",$T);}function drop_views($oi){return queries("DROP VIEW ".implode(", ",array_map('table',$oi)));}function drop_tables($T){return queries("DROP TABLE ".implode(", ",array_map('table',$T)));}function move_tables($T,$oi,$oh){$ig=array();foreach(array_merge($T,$oi)as$R)$ig[]=table($R)." TO ".idf_escape($oh).".".table($R);return queries("RENAME TABLE ".implode(", ",$ig));}function copy_tables($T,$oi,$oh){queries("SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'");foreach($T as$R){$C=($oh==DB?table("copy_$R"):idf_escape($oh).".".table($R));if(!queries("\nDROP TABLE IF EXISTS $C")||!queries("CREATE TABLE $C LIKE ".table($R))||!queries("INSERT INTO $C SELECT * FROM ".table($R)))return false;}foreach($oi as$R){$C=($oh==DB?table("copy_$R"):idf_escape($oh).".".table($R));$ni=view($R);if(!queries("DROP VIEW IF EXISTS $C")||!queries("CREATE VIEW $C AS $ni[select]"))return false;}return true;}function trigger($C){if($C=="")return array();$L=get_rows("SHOW TRIGGERS WHERE `Trigger` = ".q($C));return reset($L);}function triggers($R){$J=array();foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($R,"%_\\")))as$K)$J[$K["Trigger"]]=array($K["Timing"],$K["Event"]);return$J;}function trigger_options(){return array("Timing"=>array("BEFORE","AFTER"),"Event"=>array("INSERT","UPDATE","DELETE"),"Type"=>array("FOR EACH ROW"),);}function routine($C,$U){global$g,$qc,$yd,$Rh;$Ca=array("bool","boolean","integer","double precision","real","dec","numeric","fixed","national char","national varchar");$Qh="((".implode("|",array_merge(array_keys($Rh),$Ca)).")\\b(?:\\s*\\(((?:[^'\")]|$qc)++)\\))?\\s*(zerofill\\s*)?(unsigned(?:\\s+zerofill)?)?)(?:\\s*(?:CHARSET|CHARACTER\\s+SET)\\s*['\"]?([^'\"\\s,]+)['\"]?)?";$Af="\\s*(".($U=="FUNCTION"?"":$yd).")?\\s*(?:`((?:[^`]|``)*)`\\s*|\\b(\\S+)\\s+)$Qh";$i=$g->result("SHOW CREATE $U ".idf_escape($C),2);preg_match("~\\(((?:$Af\\s*,?)*)\\)\\s*".($U=="FUNCTION"?"RETURNS\\s+$Qh\\s+":"")."(.*)~is",$i,$B);$p=array();preg_match_all("~$Af\\s*,?~is",$B[1],$ke,PREG_SET_ORDER);foreach($ke as$qf){$C=str_replace("``","`",$qf[2]).$qf[3];$p[]=array("field"=>$C,"type"=>strtolower($qf[5]),"length"=>preg_replace_callback("~$qc~s",'normalize_enum',$qf[6]),"unsigned"=>strtolower(preg_replace('~\\s+~',' ',trim("$qf[8] $qf[7]"))),"null"=>1,"full_type"=>$qf[4],"inout"=>strtoupper($qf[1]),"collation"=>strtolower($qf[9]),);}if($U!="FUNCTION")return array("fields"=>$p,"definition"=>$B[11]);return array("fields"=>$p,"returns"=>array("type"=>$B[12],"length"=>$B[13],"unsigned"=>$B[15],"collation"=>$B[16]),"definition"=>$B[17],"language"=>"SQL",);}function routines(){return get_rows("SELECT ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ".q(DB)." ORDER BY ROUTINE_NAME");}function routines_filter(){$r=get_rows("SELECT LEFT(ROUTINE_NAME, 5) as routine FROM information_schema.ROUTINES WHERE ROUTINE_SCHEMA = ".q(DB)." GROUP BY LEFT(ROUTINE_NAME,5) ORDER BY ROUTINE_NAME");$d=array();foreach($r as $k=>$v)$d[]="{$v['routine']}";return join('',$d);}function routine_languages(){return array();}function last_id(){global$g;return$g->result("SELECT LAST_INSERT_ID()");}function explain($g,$H){return$g->query("EXPLAIN ".($g->server_info>=5.1?"PARTITIONS ":"").$H);}function found_rows($S,$Z){return($Z||$S["Engine"]!="InnoDB"?null:$S["Rows"]);}function types(){return array();}function schemas(){return array();}function get_schema(){return"";}function set_schema($xg){return true;}function create_sql($R,$La){global$g;$J=$g->result("SHOW CREATE TABLE ".table($R),1);if(!$La)$J=preg_replace('~ AUTO_INCREMENT=\\d+~','',$J);return$J;}function truncate_sql($R){return"TRUNCATE ".table($R);}function use_sql($k){return"USE ".idf_escape($k);}function trigger_sql($R,$Zg){$J="";foreach(get_rows("SHOW TRIGGERS LIKE ".q(addcslashes($R,"%_\\")),null,"-- ")as$K)$J.="\n".($Zg=='CREATE+ALTER'?"DROP TRIGGER IF EXISTS ".idf_escape($K["Trigger"]).";;\n":"")."CREATE TRIGGER ".idf_escape($K["Trigger"])." $K[Timing] $K[Event] ON ".table($K["Table"])." FOR EACH ROW\n$K[Statement];;\n";return$J;}function show_variables(){return get_key_vals("SHOW VARIABLES");}function process_list(){return get_rows("SHOW FULL PROCESSLIST");}function show_status(){return get_key_vals("SHOW STATUS");}function replication_status($U){return get_rows("SHOW $U STATUS");}function convert_field($o){if(preg_match("~binary~",$o["type"]))return"HEX(".idf_escape($o["field"]).")";if($o["type"]=="bit")return"BIN(".idf_escape($o["field"])." + 0)";if(preg_match("~geometry|point|linestring|polygon~",$o["type"]))return"AsWKT(".idf_escape($o["field"]).")";}function unconvert_field($o,$J){if(preg_match("~binary~",$o["type"]))$J="UNHEX($J)";if($o["type"]=="bit")$J="CONV($J, 2, 10) + 0";if(preg_match("~geometry|point|linestring|polygon~",$o["type"]))$J="GeomFromText($J)";return$J;}function support($Gc){global$g;return!preg_match("~scheme|sequence|type|view_trigger|materializedview".($g->server_info<5.1?"|event|partitioning".($g->server_info<5?"|routine|trigger|view":""):"")."~",$Gc);}function kill_process($X){return queries("KILL ".number($X));}function connection_id(){return"SELECT CONNECTION_ID()";}function max_connections(){global$g;return$g->result("SELECT @@max_connections");}$x="sql";$Rh=array();$Yg=array();foreach(array(lang(25)=>array("tinyint"=>3,"smallint"=>5,"mediumint"=>8,"int"=>10,"bigint"=>20,"decimal"=>66,"float"=>12,"double"=>21),lang(26)=>array("date"=>10,"datetime"=>19,"timestamp"=>19,"time"=>10,"year"=>4),lang(23)=>array("char"=>255,"varchar"=>65535,"tinytext"=>255,"text"=>65535,"mediumtext"=>16777215,"longtext"=>4294967295),lang(30)=>array("enum"=>65535,"set"=>64),lang(27)=>array("bit"=>20,"binary"=>255,"varbinary"=>65535,"tinyblob"=>255,"blob"=>65535,"mediumblob"=>16777215,"longblob"=>4294967295),lang(29)=>array("geometry"=>0,"point"=>0,"linestring"=>0,"polygon"=>0,"multipoint"=>0,"multilinestring"=>0,"multipolygon"=>0,"geometrycollection"=>0),)as$y=>$X){$Rh+=$X;$Yg[$y]=array_keys($X);}$Yh=array("unsigned","zerofill","unsigned zerofill");$Ye=array("=","<",">","<=",">=","!=","LIKE","LIKE %%","REGEXP","IN","IS NULL","NOT LIKE","NOT REGEXP","NOT IN","IS NOT NULL","SQL");$Zc=array("char_length","date","from_unixtime","lower","round","sec_to_time","time_to_sec","upper");$ed=array("avg","count","count distinct","group_concat","max","min","sum");$gc=array(array("char"=>"md5/sha1/password/encrypt/uuid","binary"=>"md5/sha1","date|time"=>"now",),array("(^|[^o])int|float|double|decimal"=>"+/-","date"=>"+ interval/- interval","time"=>"addtime/subtime","char|text"=>"concat",));}define("SERVER",$_GET[DRIVER]);define("DB",$_GET["db"]);define("ME",preg_replace('~^[^?]*/([^?]*).*~','\\1',$_SERVER["REQUEST_URI"]).'?'.(sid()?SID.'&':'').(SERVER!==null?DRIVER."=".urlencode(SERVER).'&':'').(isset($_GET["username"])?"username=".urlencode($_GET["username"]).'&':'').(DB!=""?'db='.urlencode(DB).'&'.(isset($_GET["ns"])?"ns=".urlencode($_GET["ns"])."&":""):''));$ia="4.3.1";class Adminer{var$operators;function name(){return"Adminer";}function credentials(){return array(SERVER,$_GET["username"],get_password());}function permanentLogin($i=false){return password_file($i);}function bruteForceKey(){return$_SERVER["REMOTE_ADDR"];}function database(){return DB;}function databases($Qc=true){return get_databases($Qc);}function schemas(){return schemas();}function queryTimeout(){return 5;}function headers(){return true;}function head(){return true;}function loginForm(){global$Yb;echo'

',lang(31),'	',html_select("auth[driver]",$Yb,DRIVER),'
',lang(32),'
',lang(33),'
',lang(34),'
',lang(35),'

',"

\n",checkbox("auth[permanent]",1,$_COOKIE["adminer_permanent"],lang(37))."\n";}function login($fe,$G){global$x;if($x=="sqlite")return lang(38,'login()');return true;}function tableName($fh){return h($fh["Name"]);}function fieldName($o,$df=0){return''.h($o["field"]).'';}function selectLinks($fh,$O=""){echo'

';$ee=array("select"=>lang(39));if(support("table")||support("indexes"))$ee["table"]=lang(40);if(support("table")){if(is_view($fh))$ee["view"]=lang(41);else$ee["create"]=lang(42);}if($O!==null)$ee["edit"]=lang(43);foreach($ee as$y=>$X)echo" $X";echo"\n";}function foreignKeys($R){return foreign_keys($R);}function backwardKeys($R,$eh){return array();}function backwardKeysPrint($Oa,$K){}function selectQuery($H,$vh){global$x;return"

".h(str_replace("\n"," ",$H))." ($vh)".(support("sql")?" ".lang(10)."":"")."