sql.php

<?php
error_reporting(E_ALL);
if(!extension_loaded('mysqli') && !extension_loaded('pdo_mysql')) die('Install mysqli or pdo_mysql extension!');
session_name('SQL');
session_start();
$bg=2;
$step=20;
$version="3.29";
$bbs=['False','True'];
$deny=['mysql','information_schema','performance_schema','sys'];
class DBT {
	public static $sqltype=['mysqli','pdo_mysql'];
	private $_cnx,$_query,$_fetch=[],$_num_col,$dbty;
	private static $instance=NULL;
	public static function factory($host,$user,$pwd,$db=''){
		if(!isset(self::$instance))
		try{
		self::$instance=new DBT($host,$user,$pwd,$db);
		}catch(Exception $ex){
		return false;
		}
		return self::$instance;
	}
	public function __construct($host,$user,$pwd,$db){
		$ty=self::$sqltype;
		if(extension_loaded($ty[0])) $this->dbty=$ty[0];
		else $this->dbty=$ty[1];
		$host=explode(":",$host);
		if($this->dbty==self::$sqltype[0]){
			mysqli_report(MYSQLI_REPORT_ALL);
			$this->_cnx=new mysqli($host[0],$user,$pwd,$db,empty($host[1])?3306:$host[1]);
			mysqli_report(MYSQLI_REPORT_OFF);
		}else{
			$this->_cnx=new PDO("mysql:host=".$host[0].";port=".(empty($host[1])?3306:$host[1]).";dbname=".$db,$user,$pwd);
			$this->_cnx->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
		}
	}
	public function db($db){
		return $this->_cnx->query("USE `$db`");
	}
	public function query($sql){
		try{
		if($this->dbty==self::$sqltype[0]){
		mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
		$this->_query=$this->_cnx->query($sql);
		mysqli_report(MYSQLI_REPORT_OFF);
		}else{
		$this->_query=$this->_cnx->query($sql);
		}
		return $this;
		}catch(Exception $e){
		return false;
		}
	}
	public function begin(){
		if($this->dbty==self::$sqltype[0]){
		$this->_cnx->autocommit(FALSE);
		return $this->_cnx->begin_transaction();
		}else{
		return $this->_cnx->beginTransaction();
		}
	}
	public function commit(){
		return $this->_cnx->commit();
	}
	public function last(){
		if($this->dbty==self::$sqltype[0]) return $this->_cnx->affected_rows;
		else return $this->_query->rowCount();
	}
	public function fetch($mode=0){
	$res=[];
	if($this->dbty==self::$sqltype[0]){
		if($mode==1){
		while($row=$this->_query->fetch_row()){
		$res[]=$row;
		}
		}elseif($mode==2){
		while($row=$this->_query->fetch_assoc()){
		$res[]=$row;
		}
		}else{
		return $this->_query->fetch_row();
		}
		return $res;
	}else{
		if($mode==1 || $mode==2){
		switch($mode){
		case 1: $this->_query->setFetchMode(PDO::FETCH_NUM); break;
		case 2: $this->_query->setFetchMode(PDO::FETCH_ASSOC); break;
		}
		return $this->_query->fetchAll();
		}else{
		return $this->_query->fetch(PDO::FETCH_NUM);
		}
	}
	}
	public function num_row(){
		if($this->dbty==self::$sqltype[0]) return $this->_query->num_rows;
		else return $this->_query->rowCount();
	}
	public function num_col(){
		if($this->dbty==self::$sqltype[0]) return $this->_query->field_count;
		else return $this->_query->columnCount();
	}
}
class ED {
	public $con,$path,$sg,$u_db,$fieldtype,$sqlda,$cif='@#$';
	public function __construct(){
	$pi=(isset($_SERVER['PATH_INFO']) ? $_SERVER['PATH_INFO'] : @getenv('PATH_INFO'));
	$this->sg=preg_split('!/!',$pi,-1,PREG_SPLIT_NO_EMPTY);
	$scheme='http'.(empty($_SERVER['HTTPS'])===true || $_SERVER['HTTPS']==='off' ? '' : 's').'://';
	$r_uri=isset($_SERVER['PATH_INFO'])===true ? $_SERVER['REQUEST_URI'] : $_SERVER['PHP_SELF'];
	$script=$_SERVER['SCRIPT_NAME'];
	$this->path=$scheme.$_SERVER['HTTP_HOST'].(strpos($r_uri,$script)===0 ? $script : rtrim(dirname($script),'/.\\')).'/';
	$this->fieldtype=['Numbers'=>['INT','TINYINT','SMALLINT','MEDIUMINT','BIGINT','DOUBLE','DECIMAL','FLOAT'],'Strings'=>['VARCHAR','CHAR','TEXT','TINYTEXT','MEDIUMTEXT','LONGTEXT'],'DateTime'=>['DATE','DATETIME','TIME','TIMESTAMP','YEAR'],'Binary'=>['BIT','BLOB','TINYBLOB','MEDIUMBLOB','LONGBLOB'],'Lists'=>['ENUM','SET'],'Spatial'=>['GEOMETRY','POINT','LINESTRING','POLYGON','MULTIPOINT','MULTILINESTRING','MULTIPOLYGON','GEOMETRYCOLLECTION']];
	$this->sqlda=['CONTAINS SQL'=>'CONTAINS SQL','NO SQL'=>'NO SQL','READS SQL DATA'=>'READS SQL DATA','MODIFIES SQL DATA'=>'MODIFIES SQL DATA'];
	}
	public function sanitize($el){
		return preg_replace(['/[^A-Za-z0-9]/'],'_',trim($el));
	}
	public function utf($fi){
		if(function_exists("iconv") && preg_match("~^\xFE\xFF|^\xFF\xFE~",$fi)) $fi=iconv("utf-16","utf-8",$fi);
		return $fi;
	}
	public function form($url,$enc=''){
		return "<form action='".$this->path.$url."' method='post'".($enc==1 ? " enctype='multipart/form-data'":"").">";
	}
	public function fieldtypes($slct=''){
		$ft='';
		foreach($this->fieldtype as $fdk=>$fdtype){
		if(is_array($fdtype)){
		$ft.="<optgroup label='$fdk'>";
		foreach($fdtype as $fdty) $ft.="<option value='$fdty'".(($slct!='' && $fdty==$slct)?" selected":"").">$fdty</option>";
		$ft.="</optgroup>";
		}
		}
		return $ft;
	}
	public function post($idxk='',$op=''){
		if($idxk==='' && !empty($_POST)) return ($_SERVER['REQUEST_METHOD']==='POST' ? TRUE : FALSE);
		if(!isset($_POST[$idxk])) return FALSE;
		if(is_array($_POST[$idxk])){
			if(isset($op) && is_numeric($op)){
			return $_POST[$idxk][$op];
			}else{
			$aout=[];
			foreach($_POST[$idxk] as $key=>$val){
			if($val !='') $aout[$key]=$val;
			}
			}
		}else $aout=$_POST[$idxk];
		if($op=='i') return isset($aout);
		if($op=='e') return empty($aout);
		if($op=='!i') return !isset($aout);
		if($op=='!e') return !empty($aout);
		return $aout;
	}
	public function redir($way='',$msg=[]){
		if(count($msg) > 0){
		foreach($msg as $ks=>$ms) $_SESSION[$ks]=$ms;
		}
		header('Location: '.$this->path.$way);exit;
	}
	public function enco($str) {
		$iv=random_bytes(16);
		$key=hash_hmac('sha256',$iv,$this->cif,true);
		while(strlen($key) < strlen($str)) $key .= hash_hmac('sha256',substr($key,-32),$this->cif,true);
		$cipher=$str ^ substr($key,0,strlen($str));
		$tag=hash_hmac('sha256',$iv.$cipher,$this->cif,true);
		return base64_encode($iv.$tag.$cipher);
	}
	public function deco($str) {
		$data=base64_decode($str,true);
		if($data===false || strlen($data)<48) return false;
		$iv=substr($data,0,16);
		$tag=substr($data,16,32);
		$cipher=substr($data,48);
		$expectedTag=hash_hmac('sha256',$iv.$cipher,$this->cif,true);
		if(!hash_equals($expectedTag,$tag)) return false;
		$key=hash_hmac('sha256',$iv,$this->cif,true);
		while(strlen($key) < strlen($cipher)) $key .= hash_hmac('sha256',substr($key,-32),$this->cif,true);
		return $cipher ^ substr($key,0,strlen($cipher));
	}
	public function priv($pr,$redir=NULL){
		$usr=$_SESSION['user'];
		$ho=$_SESSION['host'];
		$u_pr=$this->con->query("SELECT PRIVILEGE_TYPE FROM information_schema.USER_PRIVILEGES WHERE `GRANTEE`='\'$usr\'@\'$ho\''")->fetch(1);
		$p=[];
		if(!empty($u_pr[0][0]) && $u_pr[0][0]=="USAGE"){
		if(isset($this->sg[1])){
		$db=$this->sg[1];
		$s_pr=$this->con->query("SELECT PRIVILEGE_TYPE FROM information_schema.SCHEMA_PRIVILEGES WHERE `GRANTEE`='\'$usr\'@\'$ho\'' AND `TABLE_SCHEMA`='$db'")->fetch(1);
		foreach($s_pr as $s_p) $p[]=$s_p[0];
		}
		}else{
		$p=[];
		foreach($u_pr as $u_p) $p[]=$u_p[0];
		}
		if((is_array($pr) && count(array_intersect($pr,$p))<1) || !in_array($pr,$p)){
		if($redir!==NULL) $this->redir($redir,["err"=>"No Privileges"]);
		return false;
		}
		return true;
	}
	public function collate($name,$curr=''){
		$se=[];
		$sel="<select name='$name'><option value=''>&nbsp;</option>";
		$q_clls=$this->con->query("SHOW COLLATION");
		foreach($q_clls->fetch(1) as $r_clls) $se[$r_clls[1]][]=$r_clls[0];
		ksort($se);
		foreach($se as $ke=>$va) asort($se[$ke]);
		foreach($se as $k=>$ss){
		$sel.="<optgroup label='$k'>";
		foreach($ss as $s) $sel.="<option value='$s'".($s==$curr?" selected":"").">$s</option>";
		$sel.="</optgroup>";
		}
		return $sel."</select>";
	}
	public function check($level=[],$param=[]){
		if(isset($_SESSION['token']) && !empty($_SESSION['user'])){//check login
			$pwd=$this->deco($_SESSION['token']);
			$usr=$_SESSION['user'];
			$ho=$_SESSION['host'];
			$this->con=DBT::factory($ho,$usr,$pwd);
			if($this->con===false) $this->redir("50",['err'=>"Can't connect to the server"]);
			$h='HTTP_X_REQUESTED_WITH';
			if(isset($_SERVER[$h]) && !empty($_SERVER[$h]) && strtolower($_SERVER[$h]) == 'xmlhttprequest') session_regenerate_id(true);
		}else{
			$this->redir("50");
		}
		//list DBs
		$this->u_db=$this->con->query("select SCHEMA_NAME,DEFAULT_COLLATION_NAME from information_schema.SCHEMATA")->fetch(1);
		$rem=call_user_func_array('array_merge',$this->u_db);
		if(!$this->priv("SHOW DATABASES")) unset($this->u_db[array_search('information_schema',$rem)]);
		//check db
		if(isset($this->sg[1])) $db=$this->sg[1];
		if(in_array('1',$level)){
			$se=$this->con->db($db);
			if(!$se) $this->redir();
		}
		if(in_array('2',$level)){//check table
			if(empty($this->sg[2])) $this->redir("5/$db",['err'=>"No table"]);
			$q_com=$this->con->query("SHOW TABLE STATUS FROM `$db` like '".$this->sg[2]."'");
			if(!$q_com->num_row()) $this->redir("5/$db");
			foreach($q_com->fetch(2) as $r_com){
			if(stristr($r_com['Comment'],'Unknown storage')==true) $this->redir("5/$db");
			if($r_com['Comment']=='VIEW' && $this->sg[0]!=20) $this->redir("5/$db");//prevent to show view as table
			}
			$q_=$this->con->query("SELECT COUNT(*) FROM `".$this->sg[2]."`");
			if(!$q_) $this->redir("5/$db",['err'=>"No records"]);
		}
		if(in_array('3',$level)){//check field
			$tb=$this->sg[2];
			$sq="SHOW FIELDS FROM `$db`.`$tb` LIKE '";
			$qr=$this->con->query($sq.$this->sg[3]."'");
			if(!$qr->num_row()) $this->redir($param['redir']."/$db/".$tb);
			if(isset($this->sg[5])){
			$qr2=$this->con->query($sq.$this->sg[5]."'");
			if(!$qr2->num_row()) $this->redir($param['redir']."/$db/$tb");
			}
		}
		if(in_array('4',$level)){//check paginate
			if(!is_numeric($param['pg']) || $param['pg'] > $param['total'] || $param['pg'] < 1) $this->redir($param['redir']);
		}
		if(in_array('5',$level)){//check spp
			$sp=['view','trigger','procedure','function','event'];
			$op=$this->sg[0];
			$tb=$this->sg[2];
			$sg3=$this->sg[3];
			if($op!=49 && ($op==40 && $sg3!=$sp[0])||($op==41 && $sg3!=$sp[1])||($op==42 && $sg3!=$sp[2] && $sg3!=$sp[3])||($op==43 && $sg3!=$sp[4])) $this->redir("5/".$db);
			if($sg3==$sp[0]){//check view
				$q=$this->con->query("SHOW CREATE VIEW `$tb`");
				if(!$q) $this->redir("5/$db");
			}elseif($sg3==$sp[1]){//check trigger
				$this->priv("TRIGGER","5/$db");
				$q=$this->con->query("SHOW TRIGGERS FROM `$db` WHERE `Trigger`='$tb'")->fetch();
				if($tb !=$q[0]) $this->redir("5/$db");
			}elseif($sg3==$sp[4]){//check event
				$this->priv("EVENT","5/$db");
				$q=$this->con->query("SHOW EVENTS FROM `$db` LIKE '$tb'")->fetch();
				if($tb !=$q[1]) $this->redir("5/$db");
			}else{//check routine
				$this->priv("CREATE ROUTINE","5/$db");
				$q=$this->con->query("SHOW $sg3 STATUS WHERE `Db`='$db' AND `Name`='$tb'")->fetch();
				if($tb !=$q[1]) $this->redir("5/$db");
			}
		}
		if(in_array('6',$level)){//check user
		$this->priv("CREATE USER","52");
		if(empty($this->sg[2])){
		$u1='';$h1=base64_decode($this->sg[1]);
		}else{
		$u1=$this->sg[1];$h1=base64_decode($this->sg[2]);
		}
		$q_exist=$this->con->query("SELECT EXISTS(SELECT 1 FROM information_schema.USER_PRIVILEGES WHERE `GRANTEE`='\'$u1\'@\'$h1\'');")->fetch();
		if($q_exist[0]!=1) $this->redir("52");
		}
	}
	public function menu($db='',$tb='',$left='',$sp=[]){
		$str='';
		if($db==1 || $db!='') $str.="<div class='l2'><ul><li><a href='{$this->path}'>Databases</a></li>";
		if($db!='' && $db!=1) $str.="<li><a href='{$this->path}31/$db'>Export</a></li><li><a href='{$this->path}5/$db'>Tables</a></li>";

		$dv="<li class='divider'>---</li>";
		if($tb!="") $str.=$dv."<li><a href='{$this->path}10/$db/$tb'>Structure</a></li><li><a href='{$this->path}20/$db/$tb'>Browse</a></li><li><a href='{$this->path}21/$db/$tb'>Insert</a></li><li><a href='{$this->path}24/$db/$tb'>Search</a></li><li><a class='del' href='{$this->path}25/$db/$tb'>Empty</a></li><li><a class='del' href='{$this->path}26/$db/$tb'>Drop</a></li>";//table
		if(!empty($sp[1]) && $sp[0]=='view') $str.=$dv."<li><a href='{$this->path}40/$db/{$sp[1]}/view'>Structure</a></li><li><a href='{$this->path}20/$db/{$sp[1]}'>Browse</a></li><li><a class='del' href='{$this->path}49/$db/{$sp[1]}/view'>Drop</a></li>";//view
		if($db!='') $str.="</ul></div>";

		if($db!="" && $db!=1){//db select
		$str.="<div class='l3 auto'><select onchange='location=this.value;'><optgroup label='Databases'>";
		foreach($this->u_db as $udb) $str.="<option value='{$this->path}{$this->sg[0]}/{$udb[0]}'".($udb[0]==$db?" selected":"").">{$udb[0]}</option>";
		$str.="</optgroup></select>";

		$q_tbs=[]; $c_sp=empty($sp) ? "":count($sp);
		if($tb!="" || $c_sp >1){//table select
		$q_tbs=$this->con->query("SELECT TABLE_NAME,TABLE_TYPE FROM information_schema.tables WHERE `TABLE_SCHEMA`='$db' ORDER BY TABLE_TYPE,TABLE_NAME")->fetch(1);
		$sl2="<select onchange='location=this.value;'>";
		$qtype='';
		foreach($q_tbs as $r_tbs){
		if($qtype !=$r_tbs[1]){
		if($qtype !='') $sl2.='</optgroup>';
		$sl2.='<optgroup label="'.$r_tbs[1].'s">';
		}
		$in=($r_tbs[1]=='VIEW'?[20,40]:[10,20,21,24]);
		$sl2.="<option value='{$this->path}".(in_array($this->sg[0],$in)?$this->sg[0]:20)."/$db/".$r_tbs[0]."'".($r_tbs[0]==$tb || ($c_sp >1 && $r_tbs[0]==$sp[1])?" selected":"").">{$r_tbs[0]}</option>";
		$qtype=$r_tbs[1];
		}
		if($qtype!='') $sl2.='</optgroup>';
		if($c_sp <1 || $sp[0]=='view') $str.=$sl2."</select>".((!empty($_SESSION["_sqlsearch_{$db}_{$tb}"]) && $this->sg[0]==20) ? " [<a href='{$this->path}24/$db/$tb/reset'>reset search</a>]":"");
		else $str.=" ".$sp[0].": ".$sp[1];
		}
		$str.="</div>";
		}

		$str.="<div class='container'>";
		if($left==2) $str.="<div class='col3'>";
		$f=1;$nrf_op='';
		while($f<50){
		$nrf_op.="<option value='$f'>$f</option>";
		++$f;
		}
		if($left==1) $str.="<div class='col1'>".
		$this->form("30/$db")."<textarea name='qtxt'></textarea><br/><button type='submit'>Run sql</button></form>
		<h3>Import</h3><small>sql, csv, json, xml, gz, zip</small>".$this->form("30/$db",1)."<input type='file' name='importfile'/>
		<input type='hidden' name='send' value='ja'/><br/><button type='submit'>Upload (&lt;".ini_get("upload_max_filesize")."B)</button></form>
		<h3>Create Table</h3>".$this->form("6/$db")."<input type='text' name='ctab'/><br/>
		Number of fields<br/><select name='nrf'>$nrf_op</select><br/><button type='submit'>Create</button></form>
		<h3>Rename DB</h3>".$this->form("3/$db")."<input type='text' name='rdb'/><br/>Collation<br/>".$this->collate("rdbcll")."<br/><button type='submit'>Rename</button></form>
		<h3>Create</h3><a href='{$this->path}40/$db'>View</a><a href='{$this->path}41/$db'>Trigger</a><a href='{$this->path}42/$db'>Routine</a><a href='{$this->path}43/$db'>Event</a></div><div class='col2'>";
		return $str;
	}
	public function pg_number($pg,$totalpg){
		if($totalpg > 1){
		if($this->sg[0]==20) $lnk=$this->path."20/".$this->sg[1]."/".$this->sg[2];
		elseif($this->sg[0]==5) $lnk=$this->path."5/".$this->sg[1];
		$pgs='';$k=1;
		while($k <= $totalpg){
		$pgs.="<option ".(($k==$pg) ? "selected>":"value='$lnk/$k'>")."$k</option>";
		++$k;
		}
		$lft=($pg>1?"<a href='$lnk/1'>First</a><a href='$lnk/".($pg-1)."'>Prev</a>":"");
		$rgt=($pg < $totalpg?"<a href='$lnk/".($pg+1)."'>Next</a><a href='$lnk/$totalpg'>Last</a>":"");
		return "<div class='pg'>$lft<select onchange='location=this.value;'>$pgs</select>$rgt</div>";
		}
	}
	public function imp_csv($fname,$body){
		$exist=$this->con->query("SELECT 1 FROM `$fname`");
		if(!$exist) $this->redir("5/".$this->sg[1],['err'=>"Table not exist"]);
		$fname=$this->sanitize($fname);
		$e=[];
		if(@is_file($body)) $body=file_get_contents($body);
		$body=$this->utf($body);
		$body=preg_replace('/^\xEF\xBB\xBF|^\xFE\xFF|^\xFF\xFE/','',$body);
		//delimiter
		$delims=[';'=> 0,','=> 0];
		foreach($delims as $dl=> &$cnt) $cnt=count(str_getcsv($body,$dl));
		$mark=array_search(max($delims),$delims);
		//data
		$data=explode("\n",str_replace(["\r\n","\n\r","\r"],"\n",$body));
		$row=null;
		foreach($data as $item){
			$row.=$item;
			if(trim($row)===''){
			$row=null;
			continue;
			}elseif(substr_count($row,'"') % 2 !==0){
			$row.=PHP_EOL;
			continue;
			}
			$rows[]=str_getcsv($row,$mark,'"','"');
			$row=null;
		}
		foreach($rows as $k=>$rw){
		if($k>0){
		$e1="INSERT INTO `$fname`(".implode(',',$rows[0]).") VALUES(";
		foreach($rw as $r) $e1.=(is_numeric($r)?$r:"'".str_replace("'","''",$r)."'").',';
		$e[]=substr($e1,0,-1).");";
		}
		}
		if(empty($e)) $this->redir("5/".$this->sg[1],['err'=>"Query failed"]);
		return $e;
	}
	public function imp_json($fname,$body){
		$exist=$this->con->query("SELECT 1 FROM `$fname`");
		if(!$exist) $this->redir("5/".$this->sg[1],['err'=>"Table not exist"]);
		$e=[];
		if(@is_file($body)) $body=file_get_contents($body);
		$body=$this->utf($body);
		$rgxj="~^\xEF\xBB\xBF|^\xFE\xFF|^\xFF\xFE|(\/\/).*\n*|(\/\*)*.*(\*\/)\n*|((\"*.*\")*('*.*')*)(*SKIP)(*F)~";
		$ex=preg_split($rgxj,$body,-1,PREG_SPLIT_NO_EMPTY);
		$lines=json_decode($ex[0],true);
		$jr='';
		foreach($lines[0] as $k=>$li) $jr.=$k.",";
		foreach($lines as $line){
		$jv='';
		foreach($line as $ky=>$el) $jv.=(is_numeric($el)?$el:"'".$el."'").",";
		$e[]="INSERT INTO `$fname`(".substr($jr,0,-1).") VALUES (".substr($jv,0,-1).")";
		}
		return $e;
	}
	public function imp_xml($body){
		$e=[];
		if(@is_file($body)) $body=file_get_contents($body);
		$body=$this->utf($body);
		libxml_use_internal_errors(false);
		$xml=simplexml_load_string($body,"SimpleXMLElement",LIBXML_COMPACT);
		$nspace=$xml->getNameSpaces(true);
		$ns=key($nspace);
		//structure
		$db=$xml->children($nspace[$ns])->{'structure_schemas'}->{'database'}->attributes();
		$cll=(string)$db->collate;
		$db=(string)$db->name;
		$se=$this->con->db($db);
		if(!$se) $sq[]=["CREATE DATABASE `$db`".(empty($cll)?"":" COLLATE `{$cll}`").";"];
		$sq[]=["USE `$db`;"];
		if(isset($nspace[$ns]) && isset($xml->children($nspace[$ns])->{'structure_schemas'}->{'database'}->{'table'})){
			$stru=$xml->children($nspace[$ns])->{'structure_schemas'}->{'database'}->{'table'};
			foreach($stru as $st){
			$sq[]=explode(";",str_replace("\t\t\t","",(string)$st));
			}
		}
		$sq=(empty($sq) ? $sq : call_user_func_array('array_merge',$sq));
		//data
		$data=$xml->xpath('//database/table');
		foreach($data as $dt){
			$tt=$dt->attributes();
			$co='';$va='';
			foreach($dt as $dt2){
			$tv=$dt2->attributes();
			$co.=(string)$tv['name'].",";
			$va.="'".$dt2."',";
			}
			if($co!='' && $va!='') $e[]="INSERT INTO `$db`.`".(string)$tt['name']."`(".substr($co,0,-1).") VALUES(".substr($va,0,-1).");";
		}
		return array_merge($sq,$e);
	}
	public function tb_structure($db,$tb,$fopt,$tab,$r_st){
		$sql='';
		if(in_array('drop',$fopt)){//option drop
			$sql.="\n{$tab}DROP TABLE IF EXISTS `$tb`;";
		}
		$ifnot='';
		if(in_array('ifnot',$fopt)){//option if not exist
			$ifnot.="IF NOT EXISTS ";
		}
		$q_ex=$this->con->query("SHOW FULL FIELDS FROM `$tb` FROM `$db`");
		if($q_ex){
		$sq="\n{$tab}CREATE TABLE $ifnot`$tb`(";
		foreach($q_ex->fetch(2) as $r_ex){
			$nul=($r_ex['Null']=='YES' ? "NULL":"NOT NULL");
			$def='';
			if($r_ex['Default']!=''){
			$def.=" default ".(stristr($r_ex['Default'],'CURRENT_TIMESTAMP') ? $r_ex['Default']:"'".$r_ex['Default']."'");
			}
			$clls=(($r_ex['Collation']!='' && $r_ex['Collation']!='NULL' && $r_ex['Collation']!=$r_st[14]) ? " COLLATE '".$r_ex['Collation']."'" : "");
			$xtr=($r_ex['Extra']!='' ? " ".$r_ex['Extra'] : "");
			$sq.="\n{$tab}`".$r_ex['Field']."` ".$r_ex['Type']." ".$nul.$clls.$def.$xtr.",";
		}
		$idx1=[];$idx2=[];$idx3=[];$idx4=[];
		$q_sidx=$this->con->query("SHOW KEYS FROM `$tb` FROM `$db`");
		if($q_sidx){
		foreach($q_sidx->fetch(2) as $r_sidx){
		if($r_sidx['Key_name']=='PRIMARY') $idx1[]=$r_sidx['Column_name'];
		elseif($r_sidx['Index_type']=='FULLTEXT') $idx4[$r_sidx['Key_name']][]=$r_sidx['Column_name'];
		elseif($r_sidx['Non_unique']==1) $idx2[$r_sidx['Key_name']][]=$r_sidx['Column_name'];
		elseif($r_sidx['Non_unique']==0) $idx3[$r_sidx['Key_name']][]=$r_sidx['Column_name'];
		}
		}
		$sq.=(count($idx1) > 0 ? "\n{$tab}PRIMARY KEY(`".implode("`,`",$idx1)."`),":"");
		foreach($idx2 as $k2=>$q2){
		if(is_array($q2)) $sq.="\n{$tab}KEY `$k2` (`".implode("`,`",$q2)."`),";
		else $sq.="\n{$tab}KEY `".$k2."` (`$q2`),";
		}
		foreach($idx3 as $k3=>$q3){
		if(is_array($q3)) $sq.="\n{$tab}UNIQUE KEY `$k3` (`".implode("`,`",$q3)."`),";
		else $sq.="\n{$tab}UNIQUE KEY `$k3` (`$q3`),";
		}
		foreach($idx4 as $k4=>$q4){
		if(is_array($q4)) $sq.="\n{$tab}FULLTEXT INDEX `$k4` (`".implode("`,`",$q4)."`),";
		else $sq.="\n{$tab}FULLTEXT INDEX `$k4` (`$q4`),";
		}
		$q_kcu=$this->con->query("SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ke JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS re on ke.constraint_name=re.constraint_name WHERE ke.`CONSTRAINT_SCHEMA`='$db' AND ke.`TABLE_NAME`='$tb' AND ke.`REFERENCED_COLUMN_NAME` IS NOT NULL");
		if($q_kcu->num_row()){
		foreach($q_kcu->fetch(2) as $r_kcu){
		$sq.="\n{$tab}CONSTRAINT `".$r_kcu['CONSTRAINT_NAME']."` FOREIGN KEY (`".$r_kcu['COLUMN_NAME']."`) REFERENCES `".$r_kcu['REFERENCED_TABLE_NAME']."`(`".$r_kcu['REFERENCED_COLUMN_NAME']."`)".($r_kcu['DELETE_RULE']=='RESTRICT'?'':' ON DELETE '.$r_kcu['DELETE_RULE']).($r_kcu['UPDATE_RULE']=='RESTRICT'?'':' ON UPDATE '.$r_kcu['UPDATE_RULE']).",";
		}
		}
		$q_chk=$this->con->query("SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS WHERE `CONSTRAINT_SCHEMA`='$db' AND `TABLE_NAME`='$tb'");
		if($q_chk && $q_chk->num_row()){
		foreach($q_chk->fetch(2) as $r_chk){
		$sq.="\n{$tab}CONSTRAINT {$r_chk['CONSTRAINT_NAME']} CHECK({$r_chk['CHECK_CLAUSE']}),";
		}
		}
		$sql.=substr($sq,0,-1)."\n{$tab})";
		$co=($r_st[17]=='' ? "":" COMMENT='".addslashes($r_st[17])."'");
		$auto=(in_array('auto',$fopt) && $r_st[10] > 1 ? " AUTO_INCREMENT=".$r_st[10] : "");//option auto
		$sql.=($r_st[17]!='VIEW' ? " ENGINE=".$r_st[1].(empty($r_st[14])?"":" DEFAULT CHARSET=".strtok($r_st[14],'_')).$co.$auto:"").";";
		}
		return $sql;
	}
	public function getTables($db){
		$tbs=[];$vws=[];
		if($this->post('tbs')=='' && $this->post('dbs')!=''){
			$tabs=$this->con->query("SHOW TABLES FROM `$db`")->fetch(1);
			$tabs=empty($tabs) ? []:call_user_func_array('array_merge',$tabs);
		}else{
			$tabs=$this->post('tbs');
		}
		foreach($tabs as $tb){
			$r_st=$this->con->query("SHOW TABLE STATUS FROM `$db` like '$tb'")->fetch();
			if($r_st){
			if(preg_match('/view/i',$r_st[17])){
				array_push($vws,$tb);
			}else{
				array_push($tbs,$tb);
			}
			}
		}
		return [$tbs,$vws];
	}
	public function create_ro($db,$pn){
		if(is_numeric(substr($pn,0,1))) $this->redir("5/".$db,['err'=>"Not a valid name"]);
		$roty=$this->post('roty');
		$rtn="CREATE DEFINER=`".$_SESSION['user']."`@`".$_SESSION['host']."` $roty `".$pn."`";
		$rt2="(";
		$roc=count($this->post('ropty'));
		if($roty=='PROCEDURE'){
			$rc2=0;
			while($rc2 < $roc){
			if($this->post('roppa',$rc2)==''){
			$rt2.=' ';
			}else{
			$rt2.=$this->post('ropin',$rc2)." `".$this->post('roppa',$rc2)."` ".$this->post('ropty',$rc2).($this->post('ropva',$rc2)!=''?"(".$this->post('ropva',$rc2).")":"");
			if(in_array($this->post('ropty',$rc2),$this->fieldtype['Numbers'])){
			$rt2.=($this->post('rop1',$rc2)!=''?" ".$this->post('rop1',$rc2):"");
			}
			if(in_array($this->post('ropty',$rc2),$this->fieldtype['Strings'])){
			$rt2.=($this->post('rop2',$rc2)!=''?" CHARSET ".$this->post('rop2',$rc2):"");
			}
			$rt2.=",";
			}
			++$rc2;
			}
			$rtn.=substr($rt2,0,-1).") ";
		}elseif($roty=='FUNCTION'){
			$rc3=0;
			while($rc3 < $roc){
			$rt2.="`".$this->post('roppa',$rc3)."` ".$this->post('ropty',$rc3).($this->post('ropva',$rc3)!=''?"(".$this->post('ropva',$rc3).")":"");
			if(in_array($this->post('ropty',$rc3),$this->fieldtype['Numbers'])){
			$rt2.=($this->post('rop1',$rc3)!=''?" ".$this->post('rop1',$rc3):"");
			}
			if(in_array($this->post('ropty',$rc3),$this->fieldtype['Strings'])){
			$rt2.=($this->post('rop2',$rc3)!=''?" CHARSET ".$this->post('rop2',$rc3):"");
			}
			$rt2.=",";
			++$rc3;
			}
			$rtn.=substr($rt2,0,-1).") RETURNS ".$this->post('rorty').($this->post('rorva','!e')?"(".$this->post('rorva').")":"");
			if(in_array($this->post('rorty'),$this->fieldtype['Numbers'])){
			$rtn.=($this->post('rorop1','!e')?" ".$this->post('rorop1'):"");
			}
			if(in_array($this->post('rorty'),$this->fieldtype['Strings'])){
			$rtn.=($this->post('rorop2','!e')?" CHARSET ".$this->post('rorop2'):"");
			}
		}
		$rtn.=" ".$this->sqlda[$this->post('rosda')].($this->post('rodet','i')?" DETERMINISTIC":"").($this->post('rosec')=='INVOKER'?" SQL SECURITY INVOKER":"").($this->post('rocom','!e')?" COMMENT '".$this->post('rocom')."'":"")."\n".$this->post('rodf');
		return $this->con->query($rtn);
	}
}
$ed=new ED;
$head='<!DOCTYPE html><html lang="en"><head>
<meta charset="utf-8"><title>EdMyAdmin</title>
<style>
*{margin:0;padding:0;font-size:14px;color:#333;font-family:Arial}
html{-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%;background:#fff}
html,textarea{overflow:auto}
.container{overflow:auto;overflow-y:hidden;-ms-overflow-y:hidden;white-space:nowrap;scrollbar-width:thin}
[hidden],.mn ul{display:none}
.m1{position:absolute;right:0;top:0}
.mn li:hover ul{display:block;position:absolute}
.ce{text-align:center}
.right{float:right}
.link{padding:3px 0}
.pg *{margin:0 2px;width:auto}
caption{font-weight:bold;border:2px solid #9be}
.l1 ul,.l2 ul{list-style:none}
.left{float:left}
.left button{margin:0 1px}
h3{margin:2px 0 1px;padding:2px 0}
a{color:#842;text-decoration:none}
a:hover{text-decoration:underline}
a,a:active,a:hover{outline:0}
table a,.l1 a,.l2 a,.col1 a{padding:0 2px}
table{border-collapse:collapse;border-spacing:0;border-bottom:1px solid #555}
td,th{padding:4px;vertical-align:top}
input[type=checkbox],input[type=radio]{position:relative;vertical-align:middle;bottom:1px}
input[type=text],input[type=password],input[type=file],textarea,button,select{width:100%;padding:2px;border:1px solid #9be;outline:none;border-radius:3px;box-sizing:border-box}
optgroup option{padding-left:8px}
textarea,select[multiple]{min-height:90px}
textarea{white-space:pre-wrap;min-width:180px}
.msg{position:fixed;top:0;right:0;z-index:9}
.ok,.err{padding:8px;font-weight:bold}
.ok{background:#efe;color:#080;border-bottom:2px solid #080}
.err{background:#fee;color:#f00;border-bottom:2px solid #f00}
.l1,th,button{background:#9be}
.l2,.c1,.col1,h3{background:#cdf}
.c2,.mn ul{background:#fff}
.l3,tr:hover.r,button:hover{background:#fe3 !important}
.ok,.err,.l2 li,.mn>li{display:inline-block;zoom:1}
.col1,.col2{display:table-cell}
.col1{vertical-align:top;padding:3px}
.col1,.dw{width:180px}
.col2 table{margin:3px}
.col3 table,.dw{margin:3px auto}
.auto button,.auto input,.auto select{width:auto}
.l3.auto select{border:0;padding:0;background:#fe3}
.l1,.l2,.l3,.wi{width:100%}
.msg,.a,.bb{cursor:pointer}
.handle,.bb *{font:1.5rem/1rem Arial;font-weight:bold;vertical-align:middle}
.handle:hover{cursor:move}
tr.dragging{opacity:0.5}
tr.drag-over{background:#9be}
.upr{list-style:none;overflow:auto;overflow-x:hidden;height:90px}
</style>
</head><body>'.(empty($_SESSION['ok'])?'':'<div class="msg ok">'.$_SESSION['ok'].'</div>').(empty($_SESSION['err'])?'':'<div class="msg err">'.$_SESSION['err'].'</div>').'<div class="l1"><b><a href="https://github.com/edmondsql/edmyadmin">EdMyAdmin '.$version.'</a></b>'.(isset($ed->sg[0]) && $ed->sg[0]==50 ? "":'<ul class="mn m1"><li>More <small>&#9660;</small><ul><li><a href="'.$ed->path.'60">Info</a></li><li><a href="'.$ed->path.'60/var">Variables</a></li><li><a href="'.$ed->path.'60/status">Status</a></li><li><a href="'.$ed->path.'60/process">Processes</a></li></ul></li><li><a href="'.$ed->path.'52">Users</a></li><li><a href="'.$ed->path.'51">Logout ['.(isset($_SESSION['user']) ? $_SESSION['user']:"").']</a></li></ul>').'</div>';
$stru="<table><caption>Structure</caption><tr><th>Field</th><th>Type</th><th>Value</th><th>Attributes</th><th>Null</th><th>Default</th><th>Collation</th><th>AI <input type='radio' name='ex[]'/></th>".(isset($ed->sg[0]) && $ed->sg[0]==11?"<th>Position</th>":"")."</tr>";
$inttype=[''=>'&nbsp;','UNSIGNED'=>'unsigned','ZEROFILL'=>'zerofill','UNSIGNED ZEROFILL'=>'unsigned zerofill','on update CURRENT_TIMESTAMP'=>'on update'];

if(!isset($ed->sg[0])) $ed->sg[0]=0;
switch($ed->sg[0]){
default:
case ""://show DBs
	$ed->check();
	echo $head.$ed->menu()."<div class='col1'>Create Database".$ed->form("2").
	"<input type='text' name='dbc'/><p>Collation</p>".$ed->collate("dbcll").
	"<br/><button type='submit'>Create</button></form></div><div class='col2'><table><tr><th>Databases</th><th>Collation</th><th>Tables</th><th><a href='{$ed->path}31'>EXP</a>/ Actions</th></tr>";
	foreach($ed->u_db as $r_db){
	$db0=$r_db[0];
	$bg=($bg==1)?2:1;
	$q_tbs=$ed->con->query("SHOW TABLES FROM `$db0`");
	echo "<tr class='r c$bg'><td>$db0</td><td>".$r_db[1]."</td><td>".$q_tbs->num_row()."</td><td>
	<a href='{$ed->path}31/$db0'>Exp</a><a class='del' href='{$ed->path}4/$db0'>Drop</a>
	<a href='{$ed->path}5/$db0'>Browse</a></td></tr>";
	}
	echo "</table>";
break;

case "2"://created DB
	$ed->check();
	if($ed->post('dbc','!e')){
	$db=$ed->sanitize($ed->post('dbc'));
	$q_cc=$ed->con->query("CREATE DATABASE `$db`".($ed->post('dbcll','!e')?" COLLATE '".$ed->post('dbcll')."'":""));
	if($q_cc) $ed->redir("",['ok'=>"Created DB"]);
	$ed->redir("",['err'=>"Create DB failed"]);
	}
	$ed->redir("",['err'=>"DB name must not be empty"]);
break;

case "3"://rename DB
	$ed->check([1]);
	$db=$ed->sg[1];
	if($ed->post('rdbcll','!e') && $ed->post('rdb','e')){
	$ed->con->query("ALTER DATABASE `$db` COLLATE ".$ed->post('rdbcll'));
	$ed->redir("",['ok'=>"Changed collation"]);
	}
	if($ed->post('rdb','!e')){
	$ndb=$ed->sanitize($ed->post('rdb'));
	$q_db=call_user_func_array('array_merge',$ed->u_db);
	if(in_array($ndb,$q_db)){
	$ed->con->query("ALTER DATABASE `$db` COLLATE ".$ed->post('rdbcll'));
	$ed->redir("",['ok'=>"Changed collation"]);
	}
	$q_ren=$ed->con->query("CREATE DATABASE `$ndb`".($ed->post('rdbcll','!e')?" COLLATE '".$ed->post('rdbcll')."'":""));//create DB
	if(!$q_ren) $ed->redir("",['err'=>"Don't have privilege to create the DB"]);
	//table
	$q_tb=$ed->con->query("SELECT TABLE_NAME,TABLE_TYPE FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='$db'");
	if($q_tb->num_row()){
	foreach($q_tb->fetch(1) as $r_tb){
	if($r_tb[1] !='VIEW'){
	$r_tb0=$r_tb[0];
	$ed->con->query("CREATE TABLE `$ndb`.`$r_tb0` LIKE `$db`.`$r_tb0`");
	$ed->con->query("INSERT `$ndb`.`$r_tb0` SELECT * FROM `$db`.`$r_tb0`");
	}
	}
	}
	//view
	if($ed->priv("CREATE VIEW")){
	$q_viv=$ed->con->query("SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE `TABLE_SCHEMA`='$db'");
	if($q_viv->num_row()){
	foreach($q_viv->fetch(1) as $r_vi){
	$ed->con->query("CREATE VIEW `$ndb`.`".$r_vi[0]."` AS ".str_replace("`".$db."`","`".$ndb."`",$r_vi[1]));
	}
	}
	}
	//routine
	if($ed->priv("CREATE ROUTINE") && $ed->priv("ALTER ROUTINE")){
	$q_aro=$ed->con->query("SELECT ROUTINE_NAME,ROUTINE_TYPE FROM information_schema.ROUTINES WHERE `ROUTINE_SCHEMA`='$db'");
	if($q_aro->num_row()){
	foreach($q_aro->fetch(1) as $r_aro){
	$q_ros=$ed->con->query("SHOW CREATE ".$r_aro[1]." `$db`.`".$r_aro[0]."`")->fetch();
	$ed->con->query("USE `$ndb`");
	$ed->con->query($q_ros[2]);
	}
	}
	}
	//event
	if($ed->priv("EVENT")){
	$all_ev=$ed->con->query("SHOW EVENTS FROM `$db`");
	if($all_ev->num_row()){
	foreach($all_ev->fetch(1) as $aev) $ed->con->query("ALTER EVENT `$db`.`".$aev[1]."` RENAME TO `$ndb`.`".$aev[1]."`");
	}
	}
	//trigger
	if($ed->priv("TRIGGER")){
	$q_tg=$ed->con->query("SHOW TRIGGERS FROM `$db`");
	if($q_tg->num_row()){
	foreach($q_tg->fetch(1) as $r_tg){
	$ed->con->query("USE `$ndb`");
	$ed->con->query("CREATE TRIGGER `".$r_tg[0]."` ".$r_tg[4]." ".$r_tg[1]." ON `$ndb`.`".$r_tg[2]."` FOR EACH ROW ".$r_tg[3]);
	}
	}
	}
	//drop old DB
	$ed->con->query("DROP DATABASE `$db`");
	$ed->redir("",['ok'=>"Successfully renamed"]);
	}else $ed->redir("5/$db",['err'=>"DB name must not be empty"]);
break;

case "4"://Drop DB
	$ed->check([1]);
	$ed->priv("DROP","");
	$db=$ed->sg[1];
	if(!in_array($db,$deny)){
	$q_drodb=$ed->con->query("DROP DATABASE `$db`");
	if($q_drodb) $ed->redir("",['ok'=>"Succeful deleted DB"]);
	}
	$ed->redir('',['err'=>"Delete DB failed"]);
break;

case "5"://Show Tables
	$ed->check([1]);
	$db=$ed->sg[1];
	$q_tbs=$ed->con->query("SELECT TABLE_NAME,TABLE_TYPE,ENGINE,TABLE_COLLATION,TABLE_COMMENT FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='$db'");
	$ttalr=$q_tbs->num_row();
	$tables=[];
	//paginate
	if($ttalr > 0){
	foreach($q_tbs->fetch(1) as $r_tbs) $tables[]=[0=>$r_tbs[0],1=>$r_tbs[1],2=>$r_tbs[2],3=>$r_tbs[3],4=>$r_tbs[4]];
	$ttalpg=ceil($ttalr/$step);
	if(empty($ed->sg[2])){
		$pg=1;
	}else{
		$pg=$ed->sg[2];
		$ed->check([4],['pg'=>$pg,'total'=>$ttalpg,'redir'=>"5/$db"]);
	}
	}
	echo $head.$ed->menu($db,'',1);
	if($ttalr > 0){//start rows
	echo "<table><tr><th>Table</th><th>Rows</th><th>Engine</th><th>Collate</th><th>Comments</th><th>Actions</th></tr>";
	$ofset=($pg - 1) * $step;
	$max=$step + $ofset;
	while($ofset < $max){
		if(!empty($tables[$ofset][0])){
		$bg=($bg==1)?2:1;
		$tbs=$tables[$ofset][0];
		$_vl="/$db/".$tbs;
		if($tables[$ofset][1]=='VIEW'){
			$lk="40{$_vl}/view";$dro="49{$_vl}/view";
		}else{
			$lk="10".$_vl;$dro="26".$_vl;
		}
		$q_rows[0]=0;
		$q_t=$ed->con->query("SELECT COUNT(*) FROM `$tbs`");
		if($q_t) $q_rows=$q_t->fetch();
		echo "<tr class='r c$bg'><td>$tbs</td><td>{$q_rows[0]}</td><td>{$tables[$ofset][2]}</td><td>{$tables[$ofset][3]}</td><td>{$tables[$ofset][4]}</td><td><a href='{$ed->path}$lk'>Structure</a><a class='del' href='{$ed->path}$dro'>Drop</a><a href='{$ed->path}20/$db/$tbs'>Browse</a></td></tr>";
		}
		++$ofset;
	}
	echo "</table>".$ed->pg_number($pg,$ttalpg);
	}//end rows
	//triggers
	$q_trg=$ed->con->query("SHOW TRIGGERS FROM `$db`");
	if($q_trg->num_row()){
		echo "<table><tr><th>Trigger</th><th>Table</th><th>Timing</th><th>Event</th><th>Actions</th></tr>";
		foreach($q_trg->fetch(1) as $r_tg){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg'><td>{$r_tg[0]}</td><td>{$r_tg[2]}</td><td>".$r_tg[4]."</td><td>{$r_tg[1]}</td><td><a href='{$ed->path}41/$db/{$r_tg[0]}/trigger'>Edit</a><a class='del' href='{$ed->path}49/$db/{$r_tg[0]}/trigger'>Drop</a></td></tr>";
		}
	echo "</table>";
	}
	//spp
	$tsp='';
	$spps=['procedure','function'];
	$q_sp=[];
	foreach($spps as $spp){
		$q_spp=$ed->con->query("SHOW $spp STATUS");
		if($q_spp){
		foreach($q_spp->fetch(1) as $r_spp){
		if($r_spp[0]==$db){
		$tsp=1;
		$q_sp[]=$r_spp;
		}
		}
		}
	}
	if($tsp==1){
	echo "<table><tr><th>Routine</th><th>Type</th><th>Comments</th><th>Actions</th></tr>";
	foreach($q_sp as $r_sp){
		$bg=($bg==1)?2:1;
		if($r_sp[0]==$db){
		echo "<tr class='r c$bg'><td>{$r_sp[1]}</td><td>{$r_sp[2]}</td><td>".(strlen($r_sp[7]) > 70 ? substr($r_sp[7],0,70)."[...]":$r_sp[7])
		."</td><td><a href='{$ed->path}42/{$r_sp[0]}/{$r_sp[1]}/".strtolower($r_sp[2])."'>Edit</a><a href='{$ed->path}48/{$r_sp[0]}/{$r_sp[1]}/".strtolower($r_sp[2])."'>Execute</a><a class='del' href='{$ed->path}49/{$r_sp[0]}/{$r_sp[1]}/".strtolower($r_sp[2])."'>Drop</a></td></tr>";
		}
	}
	echo "</table>";
	}
	//events
	if(!in_array($db,$deny)){
	$q_eve=$ed->con->query("SHOW EVENTS FROM `$db`");
	if($q_eve)
	if($q_eve->num_row()){
	echo "<table><tr><th>Event</th><th>Schedule</th><th>Start</th><th>End</th><th>Actions</th></tr>";
	foreach($q_eve->fetch(2) as $r_eve){
	$bg=($bg==1)?2:1;
	echo "<tr class='r c$bg'><td>{$r_eve['Name']}</td><td>".
	($r_eve['Type']=='RECURRING' ? "Every ".$r_eve['Interval value'].$r_eve['Interval field']."</td><td>{$r_eve['Starts']}</td><td>".$r_eve['Ends']:"AT </td><td>{$r_eve['Execute at']}</td><td>")."</td><td><a href='{$ed->path}43/$db/{$r_eve['Name']}/event'>Edit</a><a class='del' href='{$ed->path}49/$db/{$r_eve['Name']}/event'>Drop</a></td></tr>";
	}
	echo "</table>";
	}
	}
break;

case "6"://create table
	$ed->check([1]);
	$db=$ed->sg[1];
	if($ed->post('ctab','!e') && !is_numeric(substr($ed->post('ctab'),0,1)) && $ed->post('nrf','!e') && is_numeric($ed->post('nrf')) && $ed->post('nrf')>0 ){
	echo $head.$ed->menu($db,'',2);
	if($ed->post('crtb','i')){
		$qry1="CREATE TABLE ".$ed->sanitize($ed->post('ctab'))."(";
		$nf=0;
		while($nf<$ed->post('nrf')){
			$c1=$ed->post('fi'.$nf); $c2=$ed->post('ty'.$nf);
			$c3=($ed->post('va'.$nf,'!e') ? "(".$ed->post('va'.$nf).")":"");
			$c4=($ed->post('at'.$nf,'!e') ? " ".$ed->post('at'.$nf):"");
			$c5=$ed->post('nc'.$nf);
			$c7=($ed->post('ex','!e') && $ed->post('ex',0)!='on' && $ed->post('ex',0)==$nf ? " AUTO_INCREMENT PRIMARY KEY":"");
			$c6=($ed->post('de'.$nf,'!e') ? " default '".$ed->post('de'.$nf)."'":"");
			$c8=($ed->post('clls'.$nf,'!e') ? " collate ".$ed->post('clls'.$nf):"");
			if(stripos($c4,'on update') || $ed->post('de'.$nf)=='CURRENT_TIMESTAMP'){
			$c8.=$c4;$c4='';
			$c6=($ed->post('de'.$nf,'!e') ? " default ".$ed->post('de'.$nf):"");
			}
			$qry1.=$c1." ".$c2.$c3.$c4." ".$c5.$c6.$c7.$c8.",";
			++$nf;
		}
		$qry2=substr($qry1,0,-1);
		$qry=$qry2.")".($ed->post('engs')==""?"":" ENGINE=".$ed->post('engs')).($ed->post('tcomm')!=""?" COMMENT='".$ed->post('tcomm')."'":"").";";
		echo "<p>".($ed->con->query($qry) ? "<b>OK!</b> $qry" : "<b>FAILED!</b> $qry")."</p>";
	}else{
		echo $ed->form("6/$db")."
		<input type='hidden' name='ctab' value='".$ed->sanitize($ed->post('ctab'))."'/>
		<input type='hidden' name='nrf' value='".$ed->post('nrf')."'/>".$stru;
		$nf=0;
		while($nf<$ed->post('nrf')){
			$bg=($bg==1)?2:1;
			echo "<tr class='c$bg'><td><input type='text' name='fi$nf'/></td>
			<td><select name='ty$nf'>".$ed->fieldtypes()."</select></td>
			<td><input type='text' name='va$nf'/></td><td><select name='at$nf'>";
			foreach($inttype as $intk=>$intt) echo "<option value='$intk'>$intt</option>";
			echo "</select></td>
			<td><select name='nc$nf'><option value='NOT NULL'>NOT NULL</option><option value='NULL'>NULL</option></select></td>
			<td><input type='text' name='de$nf'/></td><td>".
			$ed->collate("clls".$nf)."</td><td><input type='radio' name='ex[]' value='$nf'/></td></tr>";
			++$nf;
		}
		echo "<tr><td colspan='1'>Engine<br/><select name='engs'><option value=''>&nbsp;</option>";
		$q_eng=$ed->con->query("SELECT ENGINE FROM information_schema.ENGINES WHERE ENGINE IS NOT NULL AND SUPPORT<>'NO'")->fetch(1);
		foreach($q_eng as $r_eng){
			echo "<option value='{$r_eng[0]}'>{$r_eng[0]}</option>";
		}
		echo "</select></td><td colspan='7'>Table Comment:<br/><input type='text' name='tcomm'/></td></tr>
		<tr><td colspan='8'><button type='submit' name='crtb'>Create Table</button></td></tr></table></form>";
	}
	}else{
		$ed->redir("5/$db",['err'=>"Create table failed"]);
	}
break;

case "9":
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	if($ed->post('cll','i')){//change table collation
		$q_altcll=$ed->con->query("ALTER TABLE `$db`.`$tb` CONVERT TO CHARACTER SET ".strtok($ed->post('cll'),'_')." COLLATE ".$ed->post('cll'));
		if($q_altcll) $ed->redir("10/$db/".$tb,['ok'=>"Successfully changed"]);
		$ed->redir("10/$db/$tb",['err'=>"Change failed"]);
	}
	if($ed->post('engs','i')){//change table engine
		$q_engs=$ed->con->query("ALTER TABLE `$db`.`$tb` ENGINE=".$ed->post('engs'));
		if($q_engs) $ed->redir("5/$db/$tb",['ok'=>"Successfully changed"]);
		$ed->redir("10/$db/$tb",['err'=>"Change failed"]);
	}
	if($ed->post('copytab','!e')){//copy table in new DB
		$ndb=$ed->post('copytab');
		$q_altchk=$ed->con->query("SELECT 1 FROM `$ndb`.`$tb`");
		if($q_altchk) $ed->redir("10/$db/".$tb,['err'=>"Table already exists"]);
		$q_altcrt=$ed->con->query("CREATE TABLE `$ndb`.`$tb` LIKE `$db`.`$tb`");
		$q_altins=$ed->con->query("INSERT `$ndb`.`$tb` SELECT * FROM `$db`.`$tb`");
		if($q_altcrt && $q_altins) $ed->redir("10/$db/$tb",['ok'=>"Successfully copied"]);
		$ed->redir("10/$db/$tb",['err'=>"Copy table failed"]);
	}
	if($ed->post('changeb','i') && $ed->post('changec','i')){//table comment
		$ed->con->query("ALTER TABLE `$tb` COMMENT=\"".addslashes($ed->post('changec'))."\"");
		$ed->redir("10/$db/$tb",['ok'=>"Changed table comment"]);
	}
	if($ed->post('rtab','!e')){//rename table
		$ntb=$ed->sanitize($ed->post('rtab'));
		if(is_numeric(substr($ntb,0,1))) $ed->redir("5/$db",['err'=>"Not a valid table name"]);
		$q_creatt=$ed->con->query("SELECT count(*) FROM `$ntb`");
		if(!$q_creatt){//prevent create duplicate
		//create table
		$q_ttab=$ed->con->query("SELECT TABLE_NAME,TABLE_TYPE FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='$db' AND `TABLE_NAME`='$tb'");
		$r_ttr=$q_ttab->fetch();
		$ed->con->query("CREATE TABLE `$ntb` LIKE `".$r_ttr[0]."`");
		$ed->con->query("INSERT INTO `$ntb` SELECT * FROM `".$r_ttr[0]."`");
		//rename table in view
		if($ed->priv("SHOW VIEW") && $ed->priv("CREATE VIEW")){
		$q_vtb=$ed->con->query("SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE `TABLE_SCHEMA`='$db'");
		if($q_vtb->num_row()){
		foreach($q_vtb->fetch(1) as $r_tv){
		$ed->con->query("DROP VIEW IF EXISTS `$db`.`".$r_tv[0]."`");
		$ed->con->query("CREATE VIEW `$db`.`".$r_tv[0]."` AS ".str_replace("`".$tb."`","`".$ntb."`",$r_tv[1]));
		}
		}
		}
		//rename table in procedure
		if($ed->priv("CREATE ROUTINE") && $ed->priv("ALTER ROUTINE")){
		$q_prs=$ed->con->query("SELECT ROUTINE_NAME,ROUTINE_TYPE FROM information_schema.ROUTINES WHERE `ROUTINE_SCHEMA`='$db'");
		if($q_prs){
		foreach($q_prs->fetch(1) as $r_prs){
		$q_ros=$ed->con->query("SHOW CREATE ".$r_prs[1]." `$db`.`".$r_prs[0]."`")->fetch();
		$retb=preg_replace("/\`".$tb."\`|\b".$tb."\b/i","`".$ntb."`",$q_ros[2]);
		$ed->con->query("DROP ".$r_prs[1]." `".$r_prs[0]."`");
		$ed->con->query($retb);
		}
		}
		}
		//rename table in event
		if($ed->priv("EVENT")){
		$q_evn=$ed->con->query("SELECT EVENT_NAME,EVENT_DEFINITION FROM information_schema.EVENTS WHERE `EVENT_SCHEMA`='$db'");
		if($q_evn)
		if($q_evn->num_row()){
		foreach($q_evn->fetch(1) as $r_evn){
		$evb=preg_replace("/\`".$tb."\`|\b".$tb."\b/i","`".$ntb."`",$r_evn[1]);
		$ed->con->query("ALTER EVENT `".$r_evn[0]."` DO ".$evb);
		}
		}
		}
		//rename table in triggers
		if($ed->priv("TRIGGER")){
		$q_trg=$ed->con->query("SHOW TRIGGERS FROM `$db`");
		if($q_trg->num_row()){
		foreach($q_trg->fetch(1) as $r_trg){
		$ed->con->query("DROP TRIGGER IF EXISTS `$db`.`".$r_trg[0]."`");
		$ed->con->query("CREATE TRIGGER `".$r_trg[0]."` ".$r_trg[4]." ".$r_trg[1]." ON `$ntb` FOR EACH ROW ".$r_trg[3]);
		}
		}
		}
		//drop table
		$ed->con->query("DROP TABLE `$tb`");
		$ed->redir("5/$db",['ok'=>"Successfully renamed"]);
		}else $ed->redir("5/$db",['err'=>"Table already exist"]);
	}
	if($ed->post('n1','!e') && $ed->post('n2','!e')){//reorder
		$q_co=$ed->con->query("SHOW FULL FIELDS FROM `$tb`")->fetch(1);
		foreach($q_co as $k=>$r_co){
		if($ed->post('n1')==$r_co[0] && $r_co[4]!='PRI' && empty($r_co[6])){
		$ed->con->query("ALTER TABLE `$tb` MODIFY COLUMN ".$r_co[0]." ".$r_co[1]." ".($r_co[3]=='NO'?'NOT NULL':'NULL')." ".(($ed->post('n2')=="x" && $q_co[0][4]!='PRI' && empty($q_co[0][6]))?"FIRST":"AFTER ".$ed->post('n2')));
		}
		}
		exit;
	}
	if($ed->post('idx','!e') && is_array($ed->post('idx'))){//create index
		$idx='`'.implode('`,`',$ed->post('idx')).'`';
		$idxn=implode('_',$ed->post('idx'));
		if($ed->post('primary','i')){
		$q=$ed->con->query("ALTER TABLE `$tb` DROP PRIMARY KEY,ADD PRIMARY KEY($idx)");
		if(!$q) $ed->con->query("ALTER TABLE `$tb` ADD PRIMARY KEY($idx)");
		}elseif($ed->post('unique','i')){
		$ed->con->query("ALTER TABLE `$tb` ADD UNIQUE KEY($idx)");
		}elseif($ed->post('index','i')){
		$ed->con->query("ALTER TABLE `$tb` ADD INDEX($idx)");
		}elseif($ed->post('fulltext','i')){
		$ed->con->query("ALTER TABLE `$tb` ADD FULLTEXT INDEX($idx)");
		}
		$ed->redir("10/$db/$tb",['ok'=>"Successfully created"]);
	}
	if(isset($ed->sg[3])){//drop index
		if($ed->sg[3]=="PRIMARY"){
		$q_alt=$ed->con->query("ALTER TABLE `$tb` DROP PRIMARY KEY");
		}elseif(!empty($ed->sg[4]) && $ed->sg[4]=='fk'){
		$q_alt=$ed->con->query("ALTER TABLE `$tb` DROP FOREIGN KEY ".$ed->sg[3]);
		}elseif(!empty($ed->sg[4]) && $ed->sg[4]=='check'){
		$q_alt=$ed->con->query("ALTER TABLE `$tb` DROP CONSTRAINT ".$ed->sg[3]);
		}else{
		$q_key=$ed->con->query("SHOW KEYS FROM `$tb`");
		if($q_key){
		foreach($q_key->fetch(2) as $r_key){
		if($r_key['Key_name']==$ed->sg[3]) $keys=$r_key['Key_name'];
		}
		$q_alt=$ed->con->query("ALTER TABLE `$tb` DROP INDEX $keys");
		}
		}
		if($q_alt) $ed->redir("10/$db/$tb",['ok'=>"Successfully dropped"]);
		else $ed->redir("10/$db/$tb",['err'=>"Drop index failed"]);
	}
	$ed->redir("5/$db",['err'=>"Action failed"]);
break;

case "10"://structure
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	echo $head.$ed->menu($db,$tb,1);
	echo $ed->form("9/$db/$tb")."<table><caption>Structure</caption><thead><tr><th><input type='checkbox' onclick='toggle(this,\"idx[]\")'/></th><th>Field</th><th>Type</th><th>Null</th><th>Collation</th><th>Default</th><th>Extra</th><th>Actions</th></tr></thead><tbody class='sort'>";
	$q_fi=$ed->con->query("SHOW FULL FIELDS FROM `$tb`");
	$r_flds=$q_fi->num_row();
	foreach($q_fi->fetch(2) as $r_fi){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg' id='".$r_fi['Field']."'><td><input type='checkbox' name='idx[]' value='".$r_fi['Field']."'/></td><td>".$r_fi['Field']."</td><td>".$r_fi['Type']."</td><td>".$r_fi['Null']."</td>";
		echo "<td>".($r_fi['Collation']!='NULL' ? $r_fi['Collation']:'')."</td>";
		echo "<td>".$r_fi['Default']."</td><td>".$r_fi['Extra']."</td><td><a href='{$ed->path}12/$db/$tb/{$r_fi['Field']}'>change</a><a class='del' href='{$ed->path}13/$db/$tb/{$r_fi['Field']}'>drop</a><a href='{$ed->path}11/$db/$tb/{$r_fi['Field']}'>add</a><span draggable='true' class='handle' title='move'>&#x21F5;</span></td></tr>";
	}
	$q_comm=$ed->con->query("SELECT TABLE_COMMENT FROM INFORMATION_SCHEMA.TABLES WHERE `TABLE_SCHEMA`='$db' AND `TABLE_NAME`='$tb'")->fetch();
	echo "</tbody><tfoot><tr><td colspan='3'><button type='submit' name='changeb'>Change Comment</button></td><td colspan='5'><input type='text' name='changec' value=\"".$q_comm[0]."\"/></td></tr>
	<tr><td class='auto' colspan='8'><div class='left'><button type='submit' name='primary'>Primary</button><button type='submit' name='index'>Index</button><button type='submit' name='unique'>Unique</button><button type='submit' name='fulltext'>Fulltext</button></div><div class='right link'><a href='{$ed->path}27/$db/$tb/analyze'>Analyze</a><a href='{$ed->path}27/$db/$tb/optimize'>Optimize</a><a href='{$ed->path}27/$db/$tb/check'>Check</a><a href='{$ed->path}27/$db/$tb/repair'>Repair</a></div></td></tr></tfoot></table></form>
	<table><caption>Index</caption><tr><th>Key name</th><th>Field</th><th>Type</th><th>Actions</th></tr>";
	$q_idx=$ed->con->query("SHOW KEYS FROM `$tb`");
	if($q_idx->num_row()){
	foreach($q_idx->fetch(2) as $r_idx){
		if($r_idx['Index_type']=="BTREE"){
		if($r_idx['Non_unique']==1) $idxtyp="INDEX";
		elseif($r_idx['Key_name']=="PRIMARY") $idxtyp="PRIMARY";
		else $idxtyp="UNIQUE";
		}elseif($r_idx['Index_type']=="FULLTEXT"){
		$idxtyp="FULLTEXT";
		}
		$idxs[$r_idx['Key_name']]['type']=$idxtyp;
		$idxs[$r_idx['Key_name']]['column'][]=$r_idx['Column_name'];
	}
	if(count($idxs) > 0){
	foreach($idxs as $iNam=>$iCol){
	$bg=($bg==1)?2:1;
	echo "<tr class='r c$bg'><td>".$iNam."</td><td>";
	foreach($iCol['column'] as $col) echo $col."<br/>";
	echo "</td><td>".$iCol['type'];
	echo "</td><td><a class='del' href='{$ed->path}9/$db/$tb/$iNam'>drop</a></td></tr>";
	}
	}
	}
	$q_chk=$ed->con->query("SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS WHERE `CONSTRAINT_SCHEMA`='$db' AND `TABLE_NAME`='$tb'");
	if($q_chk && $q_chk->num_row()){
	foreach($q_chk->fetch(2) as $r_chk){
	$bg=($bg==1)?2:1;
	echo "<tr class='r c$bg'><td colspan='2'>{$r_chk['CHECK_CLAUSE']}</td><td>CHECK</td><td><a class='del' href='{$ed->path}9/$db/$tb/{$r_chk['CONSTRAINT_NAME']}/check'>drop</a></td></tr>";
	}
	}
	$q_rf=$ed->con->query("SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE `CONSTRAINT_SCHEMA`='$db' AND `TABLE_NAME`='$tb' AND `REFERENCED_COLUMN_NAME` IS NOT NULL");
	echo "</table><table><caption>Foreign keys</caption><tr><th>Field</th><th>Target</th><th>On delete</th><th>On update</th><th>Actions <a href='{$ed->path}14/$db/$tb'>add</a></th></tr>";
	if($q_rf->num_row()){
	$q_ref=$ed->con->query("SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ke JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS re on ke.constraint_name=re.constraint_name WHERE ke.`CONSTRAINT_SCHEMA`='$db' AND ke.`TABLE_NAME`='$tb' AND ke.`REFERENCED_COLUMN_NAME` IS NOT NULL");
	foreach($q_ref->fetch(2) as $r_ref){
	$bg=($bg==1)?2:1;$cnstr=$r_ref['CONSTRAINT_NAME'];
	echo "<tr class='r c$bg'><td>".$r_ref['COLUMN_NAME']."</td><td>".$r_ref['REFERENCED_TABLE_NAME'].".".$r_ref['REFERENCED_COLUMN_NAME']."</td><td>".$r_ref['DELETE_RULE']."</td><td>".$r_ref['UPDATE_RULE']."</td><td><a href='{$ed->path}14/$db/$tb/$cnstr'>change</a><a class='del' href='{$ed->path}9/$db/$tb/$cnstr/fk'>drop</a></td></tr>";
	}
	}
	echo "</table><table class='c1'><tr><td>Rename Table<br/>".$ed->form("9/$db/$tb")."<input type='text' name='rtab'/><br/><button type='submit'>Rename</button></form><br/>Copy Table to Database<br/>".$ed->form("9/$db/$tb")."<select name='copytab'>";
	foreach($ed->u_db as $r_ldb){
		$rdb=$r_ldb[0];
		if(!in_array($rdb,$deny)) echo "<option value='$rdb'".($rdb==$db?" selected":"").">$rdb</option>";
	}
	echo "</select><br/><button type='submit'>Copy</button></form><br/>";
	$q_cll=$ed->con->query("SHOW TABLE STATUS FROM `$db` like '$tb'");
	$r_cll=$q_cll->fetch(2);
	echo "Change Table Collation<br/>".$ed->form("9/$db/$tb").$ed->collate("cll",$r_cll[0]['Collation']).
	"<br/><button type='submit'>Change</button></form><br/>Change Table Engine<br/>".$ed->form("9/$db/$tb")."<select name='engs'>";
	$q_def=$ed->con->query("SELECT ENGINE FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='$db' AND `TABLE_NAME`='$tb'")->fetch();
	$q_eng=$ed->con->query("SELECT ENGINE FROM information_schema.ENGINES WHERE ENGINE IS NOT NULL AND SUPPORT<>'NO'")->fetch(1);
	foreach($q_eng as $r_eng){
		$r_eng0=$r_eng[0];
		echo "<option value='$r_eng0'".($q_def[0]==$r_eng0?" selected":"").">$r_eng0</option>";
	}
	echo "</select><br/><button type='submit'>Change</button></form></td></tr></table>";
break;

case "11"://Add field
	$ed->check([1,2,3],['redir'=>10]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$id=$ed->sg[3];
	if($ed->post('fi','!e') && $ed->post('ty','!e') && !is_numeric(substr($ed->post('fi'),0,1))){
		$va=($ed->post('va','!e') ? "(".$ed->post('va').")":"");
		$at=($ed->post('at')!='' ? " ".$ed->post('at'):"");
		$def=($ed->post('de','!e') ? " default '".$ed->post('de')."'":"");
		$clls=($ed->post('clls','!e') ? " collate ".$ed->post('clls'):"");
		$ex=($ed->post('ex','!e') && $ed->post('ex',0)==1 ? " AUTO_INCREMENT PRIMARY KEY":"");
		$col=($ed->post('col')=="FIRST" ? " FIRST":" AFTER ".$ed->post('col'));
		if(stripos($at,'on update') || $ed->post('de')=='CURRENT_TIMESTAMP'){
		$def=($ed->post('de','!e') ? " default ".$ed->post('de'):"");
		$ex=$at; $at='';
		}
		$e=$ed->con->query("ALTER TABLE `$tb` ADD ".$ed->sanitize($ed->post('fi'))." ".$ed->post('ty').$va.$at." ".$ed->post('nc').$def.$clls.$ex.$col);
		if($e) $ed->redir("10/$db/$tb",['ok'=>"Successfully added"]);
		else $ed->redir("10/$db/$tb",['err'=>"Add field failed"]);
	}else{
		echo $head.$ed->menu($db,$tb,2).$ed->form("11/$db/$tb/$id").$stru.
		"<tr><td><input type='text' name='fi'/></td><td><select name='ty'>".$ed->fieldtypes()."</select></td><td><input type='text' name='va'/></td><td><select name='at'>";
		foreach($inttype as $ke=>$ar) echo "<option value='$ke'>$ar</option>";
		echo "</select></td><td><select name='nc'><option value='NOT NULL'>NOT NULL</option><option value='NULL'>NULL</option></select></td>
		<td><input type='text' name='de'/></td><td>".$ed->collate("clls")."</td><td><input type='radio' name='ex[]' value='1'/></td>
		<td><select name='col'><option value='$id'>after: $id</option><option value='FIRST'>first</option></select></td>
		</tr><tr><td colspan='9'><button type='submit'>Add</button></td></tr></table></form>";
	}
break;

case "12"://structure change
	$ed->check([1,2,3],['redir'=>10]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	if($ed->post('fi','!e') && $ed->post('ty','!e') && !is_numeric(substr($ed->post('fi'),0,1))){//structure update
		$fi=$ed->sanitize($ed->post('fi'));
		$fi_=$ed->post('fi_');
		$va=($ed->post('va','e') ? "":"(".$ed->post('va').")");
		$at=($ed->post('at','e') ? "":" ".$ed->post('at'));
		$def=($ed->post('de','e') ? "":" default '".$ed->post('de')."'");
		$clls=($ed->post('clls','e') ? "":" collate ".$ed->post('clls'));
		if(stripos($at,'on update') || $ed->post('de')=='CURRENT_TIMESTAMP'){
		$def=($ed->post('de','e') ? "":" default ".$ed->post('de'));
		$def.=$at; $at='';
		}
		if($ed->post('ex','!e') && $ed->post('ex',0)==1){
		$ex=" AUTO_INCREMENT";
		$q_pri=$ed->con->query("SHOW KEYS FROM `$db`.`$tb`");
		if($q_pri->num_row()){
		foreach($q_pri->fetch(2) as $r_pri){
			if($r_pri['Key_name'] !="PRIMARY" && $r_pri['Column_name'] !=$fi_) $ex.=" PRIMARY KEY";
		}
		}else $ex.=" PRIMARY KEY";
		}else $ex="";
		$ok=$ed->con->query("ALTER TABLE `$tb` CHANGE ".$fi_." ".$ed->sanitize($ed->post('fi'))." ".$ed->post('ty').$va.$at." ".$ed->post('nc').$def.$clls.$ex);
		if($ok){
		//replace in view
		if($ed->priv("DROP") && $ed->priv("SHOW VIEW") && $ed->priv("CREATE VIEW")){
		$q_vw=$ed->con->query("SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE `TABLE_SCHEMA`='$db'");
		if($q_vw->num_row()){
		foreach($q_vw->fetch(1) as $r_vw){
		if(strrpos($r_vw[1],"`$db`.`$tb`")==true){
		$ed->con->query("DROP VIEW IF EXISTS ".$r_vw[0]);
		$ed->con->query("CREATE VIEW `".$r_vw[0]."` AS ".str_replace("`".$fi_."`","`".$fi."`",$r_vw[1]));
		}
		}
		}
		}
		//repalce in trigger
		if($ed->priv("TRIGGER")){
		$q_tge=$ed->con->query("SHOW TRIGGERS FROM `$db` WHERE `Table`='$tb'");
		if($q_tge->num_row()){
		foreach($q_tge->fetch(1) as $r_tge){
		if($r_tge[2]==$tb){
		$stt=preg_replace("/\b".$fi_."\b/i",$fi,$r_tge[3]);
		$ed->con->query("DROP TRIGGER IF EXISTS `$db`.`".$r_tge[0]."`");
		$ed->con->query("CREATE TRIGGER `".$r_tge[0]."` ".$r_tge[4]." ".$r_tge[1]." ON `".$r_tge[2]."` FOR EACH ROW $stt");
		}
		}
		}
		}
		//replace in procedure (no function)
		if($ed->priv("ALTER ROUTINE")){
		$q_prs=$ed->con->query("SELECT ROUTINE_NAME,ROUTINE_TYPE FROM information_schema.ROUTINES WHERE `ROUTINE_SCHEMA`='$db'");
		if($q_prs->num_row()){
		foreach($q_prs->fetch(1) as $r_prs){
		$q_ros=$ed->con->query("SHOW CREATE ".$r_prs[1]." `$db`.`".$r_prs[0]."`")->fetch();
		$refi=preg_replace("/\b".$fi_."\b/i",$fi,$q_ros[2]);
		$ed->con->query("DROP ".$r_prs[1]." `".$r_prs[0]."`");
		$ed->con->query($refi);
		}
		}
		}
		//replace field in event
		if($ed->priv("EVENT")){
		$q_evn=$ed->con->query("SELECT EVENT_NAME,EVENT_DEFINITION FROM information_schema.EVENTS WHERE `EVENT_SCHEMA`='$db'");
		if($q_evn && $q_evn->num_row()){
		foreach($q_evn->fetch(1) as $r_evn){
		if(strrpos($r_evn[1],$tb)==true){
		$evb=preg_replace("/\b".$fi_."\b/i",$fi,$r_evn[1]);
		$ed->con->query("ALTER EVENT `".$r_evn[0]."` DO ".$evb);
		}
		}
		}
		}
		}
		$ed->redir("10/$db/$tb",['ok'=>"Successfully changed"]);
	}else{//structure form
	echo $head.$ed->menu($db,$tb,2);
	echo $ed->form("12/$db/$tb/".$ed->sg[3]).$stru;
	$r_fe=$ed->con->query("SHOW FULL FIELDS FROM `$db`.`$tb` LIKE '".$ed->sg[3]."'")->fetch();
	$fe_type=preg_split("/[()]+/",$r_fe[1],-1,PREG_SPLIT_NO_EMPTY);
	echo "<tr><td><input type='hidden' name='fi_' value='".$r_fe[0]."'/><input type='text' name='fi' value=".$r_fe[0]."/></td>
	<td><select name='ty'>".$ed->fieldtypes(strtoupper($fe_type[0]))."</select></td>
	<td><input type='text' name='va' value=\"".(isset($fe_type[1])?$fe_type[1]:"")."\"/></td><td><select name='at'>";
	$fe_atr=substr($r_fe[1],strpos($r_fe[1]," ")+1);
	$big=strtoupper($fe_atr);
	foreach($inttype as $b=>$b2) echo "<option value='$b'".($b==$big || (!empty($r_fe[6]) && $r_fe[6]==$b) ? " selected":"").">".$b2."</option>";
	echo "</select></td><td><select name='nc'>";
	$cc=['NOT NULL','NULL'];
	foreach($cc as $c) echo("<option value='$c'".(($r_fe[3]=="YES" && $c=="NULL")?" selected":"").">$c</option>");
	echo "</select></td><td><input type='text' name='de' value='".$r_fe[5]."'/></td><td>".$ed->collate("clls",$r_fe[2]).
	"</td><td><input type='radio' name='ex[]' value='1' ".($r_fe[6]=="auto_increment" ? "checked":"")."/></td>
	</tr><tr><td colspan='8'><button type='submit'>Change field</button></td></tr></table></form>";
	}
break;

case "13"://drop field
	$ed->check([1,2,3],['redir'=>10]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$fi=$ed->sg[3];
	//drop view with field
	$q_vi=$ed->con->query("SHOW TABLE STATUS FROM `$db`");
	foreach($q_vi->fetch(2) as $r_vi){
	if($r_vi['Comment']=='VIEW'){
	$r_tb=$r_vi['Name'];
	$q_sv=$ed->con->query("SHOW CREATE VIEW `$db`.`$r_tb`");
	$r_sv=$q_sv->fetch();
	if(strpos($r_sv[1],"`$tb`.`$fi`")!==false) $ed->con->query("DROP VIEW `$db`.`$r_tb`");
	}
	}
	$q_drofd=$ed->con->query("ALTER TABLE `$tb` DROP ".$fi);
	if($q_drofd) $ed->redir("10/$db/$tb",['ok'=>"Successfully deleted"]);
	$ed->redir("10/$db/$tb",['err'=>"Field delete failed"]);
break;

case "14"://fk
	$ed->check([1,2],['redir'=>10]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$fk_r='';$fkty=['RESTRICT','NO ACTION','CASCADE','SET NULL','SET DEFAULT'];
	$q_fs=$ed->con->query("SHOW FIELDS FROM `$tb`")->fetch(2);
	$fld=[];
	foreach($q_fs as $r_fs) $fld[]=$r_fs['Field'];
	if($ed->post('tname','!e') && $ed->post('tcol','!e')){
	$ed->con->query("ALTER TABLE `$tb` ".(empty($ed->sg[3])?'':"DROP FOREIGN KEY `{$ed->sg[3]}`, ")."ADD FOREIGN KEY (`".$ed->post('field')."`) REFERENCES `".$ed->post('tname')."` (`".$ed->post('tcol')."`) ON DELETE ".$ed->post('drule')." ON UPDATE ".$ed->post('urule'));
	$ed->redir("10/$db/$tb",['ok'=>"Successfully ".(empty($ed->sg[3])?"add":"changed")]);
	}
	if(empty($ed->sg[3])){
	$fk_r.="<tr><td><select name='field'>";
	foreach($fld as $fd) $fk_r.="<option value='$fd'>$fd</option>";
	$fk_r.="</select></td><td><input type='text' name='tname'/></td><td><input type='text' name='tcol'/></td><td><select name='drule'>";
	foreach($fkty as $fkt) $fk_r.="<option value='$fkt'>$fkt</option>";
	$fk_r.="</select></td><td><select name='urule'>";
	foreach($fkty as $fkt) $fk_r.="<option value='$fkt'>$fkt</option>";
	$fk_r.="</select></td></tr>";
	}else{
	$fk=$ed->sg[3];
	$q_rf=$ed->con->query("SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ke JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS re on ke.constraint_name=re.constraint_name WHERE ke.`CONSTRAINT_SCHEMA`='$db' AND ke.`TABLE_NAME`='$tb' AND ke.`CONSTRAINT_NAME`='$fk'");
	if($q_rf->num_row()<1) $ed->redir("10/$db/$tb",['err'=>"Foreign key not exist"]);
	foreach($q_rf->fetch(2) as $r_rf){
	$fk_r.="<tr><td><select name='field'>";
	foreach($fld as $fd) $fk_r.="<option value='$fd'".($fd==$r_rf['COLUMN_NAME']?" selected":"").">$fd</option>";
	$fk_r.="</select></td><td><input type='text' name='tname' value='".$r_rf['REFERENCED_TABLE_NAME']."'/></td><td><input type='text' name='tcol' value='".$r_rf['REFERENCED_COLUMN_NAME']."'/></td><td><select name='drule'>";
	foreach($fkty as $fkt) $fk_r.="<option value='$fkt'".($fkt==$r_rf['DELETE_RULE']?" selected":"").">$fkt</option>";
	$fk_r.="</select></td><td><select name='urule'>";
	foreach($fkty as $fkt) $fk_r.="<option value='$fkt'".($fkt==$r_rf['UPDATE_RULE']?" selected":"").">$fkt</option>";
	$fk_r.="</select></td></tr>";
	}
	}
	echo $head.$ed->menu($db,$tb,2);
	echo $ed->form("14/$db/$tb".(empty($ed->sg[3])?'':"/$fk"));
	echo "<table><caption>TABLE FOREIGN KEY</caption><tr><th>FIELD</th><th>TARGET TABLE</th><th>TARGET FIELD</th><th>ON DELETE</th><th>ON UPDATE</th></tr>".$fk_r."<tr><td colspan='9'><button type='submit'>Change</button></td></tr></table></form>";
break;

case "20"://table browse
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$ed->con->query("SET NAMES 'utf8'");
	$where=(empty($_SESSION["_sqlsearch_{$db}_{$tb}"])?"":" ".$_SESSION["_sqlsearch_{$db}_{$tb}"]);
	$q_cnt=$ed->con->query("SELECT COUNT(*) FROM `$tb`".$where)->fetch();
	$totalr=$q_cnt[0];
	$totalpg=ceil($totalr/$step);
	if(empty($ed->sg[3])){
	$pg=1;
	}else{
	$pg=$ed->sg[3];
	$ed->check([1,4],['pg'=>$pg,'total'=>$totalpg,'redir'=>"20/$db/$tb"]);
	}
	$offset=($pg - 1) * $step;

	$q_vic=$ed->con->query("SHOW TABLE STATUS FROM `$db` like '$tb'")->fetch();
	echo $head.$ed->menu($db,($q_vic[17]=='VIEW'?'':$tb),1,($q_vic[17]=='VIEW'?['view',$tb]:''));
	echo "<table><tr>";
	if($q_vic[17]!='VIEW'){echo "<th>Actions</th>";}
	$q_bro=$ed->con->query("SHOW FIELDS FROM `$tb`");
	$r_cl=$q_bro->num_row();
	$coln=[];//field
	$colt=[];//type
	$cols=[];
	foreach($q_bro->fetch(2) as $r_bro){
		$cols[]=(stristr($r_bro['Type'],'bit')?"BIN(".$r_bro['Field']." + 0) AS ".$r_bro['Field']:'`'.$r_bro['Field'].'`');
		$coln[]=$r_bro['Field'];
		$colt[]=$r_bro['Type'];
		echo "<th>".$r_bro['Field']."</th>";
	}
	echo "</tr>";
	$q_res=$ed->con->query(empty($select) ? "SELECT ".implode(",",$cols)." FROM `$tb`{$where} LIMIT $offset,$step" : $select);
	foreach($q_res->fetch(1) as $r_rw){
		$bg=($bg==1)?2:1;
		$nu=$coln[0]."/".($r_rw[0]==""?"isnull":base64_encode($r_rw[0])).(isset($colt[1]) && (stristr($colt[1],"int") || stristr($colt[1],"varchar")) && stristr($colt[1],"blob")==false && !empty($coln[1]) && !empty($r_rw[1]) ? "/".$coln[1]."/".base64_encode($r_rw[1]):"");
		echo "<tr class='r c$bg'>";
		if($q_vic[17]!='VIEW'){
		echo "<td><a href='{$ed->path}22/$db/$tb/$nu'>Edit</a><a class='del' href='{$ed->path}23/$db/$tb/$nu'>Delete</a></td>";
		}
		$i=0;
		while($i<$r_cl){
			$val=($r_rw[$i]==''?'':htmlentities($r_rw[$i]));
			echo "<td>";
			if(stristr($colt[$i],"blob")==true && !in_array($db,$deny)){
				$le=strlen($r_rw[$i]);
				echo "blob: ".($le>4 ? "<a href='{$ed->path}33/$db/$tb/$nu/".$coln[$i]."'>".number_format(($le/1024),2)." KB</a>":"0.00 KB");
			}elseif(strlen($val) > 70){
				echo substr($val,0,70)."[...]";
			}else{
				echo $val;
			}
			echo "</td>";
			++$i;
		}
		echo "</tr>";
	}
	echo "</table>";
	echo $ed->pg_number($pg,$totalpg);
break;

case "21"://table insert
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$q_col=$ed->con->query("SHOW COLUMNS FROM `$tb`");
	$coln=[];//field
	$colt=[];//type
	$colu=[];//null
	foreach($q_col->fetch(2) as $r_brw){
		$coln[]=$r_brw['Field'];
		$colt[]=$r_brw['Type'];
		$colu[]=$r_brw['Null'];
	}
	if($ed->post('save','i') || $ed->post('save2','i')){
		$qr1="INSERT INTO `$tb` (";
		$qr2="";
		$qr3="VALUES(";
		$qr4="";
		$n=0;
		while($n<count($coln)){
			if($ed->post('r'.$n,'!e') || !empty($_FILES["r".$n]['tmp_name'])){
			$qr2.=$coln[$n].",";
			if(stristr($colt[$n],"blob")==true){
				if(!empty($_FILES["r".$n]['tmp_name'])){
				$qr4.="'".addslashes(file_get_contents($_FILES["r".$n]['tmp_name']))."',";
				}else{
				$qr4.="'',";
				}
			}elseif(stristr($colt[$n],'bit')==true){
				preg_match("/\((.*)\)/",$colt[$n],$mat);
				$qr4.="b'".(($mat[1] > 1)?$ed->post('r'.$n):$ed->post('r'.$n,0))."',";
			}else{
				if(!empty($_FILES['r'.$n]['tmp_name'])){
				$blb=addslashes(file_get_contents($_FILES['r'.$n]['tmp_name']));
				$qr4.="'{$blb}',";
				}else{
				$qr4.=(($ed->post('r'.$n,'e') && $colu[$n]=='YES')? "NULL":"'".addslashes($ed->post('r'.$n))."'").",";
				}
			}
			}
			++$n;
		}
		$qr2=substr($qr2,0,-1).") ";
		$qr4=substr($qr4,0,-1).")";
		$q_rins=$ed->con->query($qr1.$qr2.$qr3.$qr4);
		if($ed->post('save2','i')) $rr=21;
		else $rr=20;
		if($q_rins) $ed->redir("$rr/$db/$tb",['ok'=>"Successfully inserted"]);
		else $ed->redir("$rr/$db/$tb",['err'=>"Insert failed"]);
	}else{
		echo $head.$ed->menu($db,$tb,1).$ed->form("21/$db/$tb",1)."<table><caption>Insert Row</caption>";
		$j=0;
		while($j<count($coln)){
			echo "<tr><td>".$coln[$j]."</td><td>";
			if(stristr($colt[$j],"enum")==true OR stristr($colt[$j],"set")==true){//enum
			$enums=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$colt[$j]));
			echo "<select name='r{$j}'>";
			foreach($enums as $enm){
			echo "<option value='{$enm}'>$enm</option>";
			}
			echo "</select>";
			}elseif(substr($colt[$j],0,3)=='bit'){//bit
				preg_match("/\((.*)\)/",$colt[$j],$mat);
				if($mat[1] > 1){
				echo "<input type='text' name='r{$j}'/>";
				}else{
				foreach($bbs as $kj=>$bb){
				echo "<input type='radio' name='r{$j}[]' value='$kj'/> $bb ";
				}
				}
			}elseif(stristr($colt[$j],"blob")==true && !in_array($db,$deny)){//blob
			echo "<input type='file' name='r{$j}'/>";
			}elseif(stristr($colt[$j],"text")==true){//text
			echo "<textarea name='r{$j}'></textarea>";
			}else{
			echo "<input type='text' name='r{$j}'/>";
			}
			++$j;
		}
		echo "<tr><td><button type='submit' name='save'>Save</button></td><td><button type='submit' name='save2'>Save &amp; Insert Next</button></td></tr></table></form>";
	}
break;

case "22"://table edit row
	$ed->check([1,2,3],['redir'=>'20']);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$nu=$ed->sg[3];
	if(empty($nu)) $ed->redir("20/$db/$tb",['err'=>"Can't edit empty field"]);
	$id=($ed->sg[4]=="isnull"?"":base64_decode($ed->sg[4]));
	$nu1=(empty($ed->sg[5])?"":$ed->sg[5]); $id1=(empty($ed->sg[6])?"":base64_decode($ed->sg[6]));
	$q_col=$ed->con->query("SHOW COLUMNS FROM `$tb`");
	$coln=[];//field
	$colt=[];//type
	$colu=[];//null
	$cols=[];
	foreach($q_col->fetch(2) as $r_brw){
		$cols[]=(stristr($r_brw['Type'],'bit')?"BIN(".$r_brw['Field']." + 0) AS ".$r_brw['Field']:'`'.$r_brw['Field'].'`');
		$coln[]=$r_brw['Field'];
		$colt[]=$r_brw['Type'];
		$colu[]=$r_brw['Null'];
	}
	$nul=("(".$nu." IS NULL OR ".$nu."='')");
	if($ed->post('edit','i')){//update
		$qr1="UPDATE `$tb` SET ";
		$qr2="";
		$p=0;
		while($p<count($coln)){
			if(stristr($colt[$p],"blob")==true){
				if($ed->post('r'.$p,'i')){
				$qr2.=$coln[$p]."='',";
				}elseif(!empty($_FILES["te".$p]['tmp_name'])){
				$blb=addslashes(file_get_contents($_FILES["te".$p]['tmp_name']));
				$qr2.=$coln[$p]."='".$blb."',";
				}
			}elseif(stristr($colt[$p],'bit')==true){
				preg_match("/\((.*)\)/",$colt[$p],$mat);
				$qr2.=$coln[$p]."=b'".(($mat[1] > 1)?$ed->post("te".$p):$ed->post("te".$p,0))."',";
			}else{
				$qr2.=$coln[$p]."=".(($ed->post('te'.$p,'e') && !is_numeric($ed->post('te'.$p)) && $colu[$p]=='YES')? "NULL":"'".addslashes($ed->post('te'.$p))."'").",";
			}
			++$p;
		}
		$qr2=substr($qr2,0,-1);
		$qr3=" WHERE ".($id==""?$nul:$nu."='".addslashes($id)."'").(!empty($nu1) && !empty($id1)?" AND $nu1='".addslashes($id1)."'":"")." LIMIT 1";
		$q_upd=$ed->con->query($qr1.$qr2.$qr3);
		if($q_upd) $ed->redir("20/$db/$tb",['ok'=>"Successfully updated"]);
		else $ed->redir("20/$db/$tb",['err'=>"Update failed"]);
	}else{//edit form
		$q_rst=$ed->con->query("SELECT ".implode(",",$cols)." FROM `$tb` WHERE ".($id==""?$nul:$nu."='".addslashes($id)."'").(!empty($colt[1]) && stristr($colt[1],"blob")==false && !empty($nu1) && !empty($id1)?" AND $nu1='".addslashes($id1)."'":""));
		if($q_rst->num_row() < 1) $ed->redir("20/$db/$tb",['err'=>"Edit failed"]);
		$r_rx=$q_rst->fetch();
		echo $head.$ed->menu($db,$tb,1).$ed->form("22/$db/$tb/$nu/".($id==""?"isnull":base64_encode($id)).(!empty($colt[1]) && stristr($colt[1],"blob")==false && !empty($nu1) && !empty($id1)?"/$nu1/".base64_encode($r_rx['1']):""),1)."<table><caption>Edit Row</caption>";
		$k=0;
		while($k<count($coln)){
			echo "<tr><td>".$coln[$k]."</td><td>";
			if(stristr($colt[$k],"enum")==true OR stristr($colt[$k],"set")==true){//enum
				$enums=explode("','",preg_replace("/(enum|set)\('(.+?)'\)/","\\2",$colt[$k]));
				echo "<select name='te{$k}'>";
				foreach($enums as $enm){
				echo "<option value='{$enm}'".($r_rx[$k]==$enm ? " selected":"").">$enm</option>";
				}
				echo "</select>";
			}elseif(stristr($colt[$k],'bit')==true){//bit
				preg_match("/\((.*)\)/",$colt[$k],$mat);
				if($mat[1] > 1){
				echo "<input type='text' name='te{$k}' value='".$r_rx[$k]."'/>";
				}else{
				foreach($bbs as $kk=>$bb){
				echo "<input type='radio' name='te{$k}[]' value='$kk'".($r_rx[$k]==$kk ? " checked":"")."/> $bb ";
				}
				}
			}elseif(stristr($colt[$k],"blob")==true && !in_array($db,$deny)){//blob
			echo number_format((strlen($r_rx[$k])/1024),2)." KB<i class='right'><input type='checkbox' name='r{$k}'/> reset</i><br/><input type='file' name='te{$k}'/>";
			}elseif(stristr($colt[$k],"text")==true){//text
			echo "<textarea name='te{$k}'>".($r_rx[$k]==''?'':htmlentities($r_rx[$k],ENT_QUOTES))."</textarea>";
			}else{
			echo "<input type='text' name='te{$k}' value='".($r_rx[$k]==''?'':htmlentities($r_rx[$k],ENT_QUOTES))."'/>";
			}
			echo "</td></tr>";
			++$k;
		}
	echo "<tr><td><a class='del right link' href='{$ed->path}23/$db/$tb/$nu/".($id==""?"isnull":base64_encode($id)).(!empty($nu1) && !empty($id1)?"/$nu1/".base64_encode($id1):"")."'>Delete</a></td><td><button type='submit' name='edit'>Update</button></td></tr></table></form>";
	}
break;

case "23"://table delete row
	$ed->check([1,2,3],['redir'=>'20']);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$nu=$ed->sg[3];
	$id=$ed->sg[4];
	$nul=("(".$nu." IS NULL OR ".$nu."='')");
	$q_delro=$ed->con->query("DELETE FROM `$tb` WHERE ".($id=="isnull"?$nul:$nu."='".addslashes(base64_decode($id))."'").(!empty($ed->sg[5]) && !empty($ed->sg[6])?" AND ".$ed->sg[5]."='".addslashes(base64_decode($ed->sg[6]))."'":"")." LIMIT 1");
	if($q_delro && $q_delro->last()) $ed->redir("20/$db/$tb",['ok'=>"Successfully deleted"]);
	else $ed->redir("20/$db/$tb",['err'=>"Delete row failed"]);
break;

case "24"://search
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	unset($_SESSION["_sqlsearch_{$db}_{$tb}"]);
	if(!empty($ed->sg[3]) && $ed->sg[3]=='reset'){
	$ed->redir("20/$db/$tb",['ok'=>"Reset search"]);
	}
	$q_se=$ed->con->query("SHOW COLUMNS FROM `$tb`")->fetch(2);
	$cond1=['=','&lt;','&gt;','&lt;=','&gt;=','!=','LIKE','NOT LIKE','REGEXP','NOT REGEXP'];
	$cond2=['BETWEEN','NOT BETWEEN'];
	$cond3=['IN','NOT IN'];
	$cond4=['IS NULL','IS NOT NULL'];
	$cond=array_merge($cond1,$cond2,$cond3,$cond4);
	//post
	if($ed->post('search','i')){
	$search_cond=[];
	foreach($q_se as $r_se){
		if($ed->post($r_se['Field'],'!e') || in_array($ed->post('cond__'.$r_se['Field']),$cond4)){
		$fd=$r_se['Field'];
		$cd=$ed->post('cond__'.$fd);
		$po=$ed->post($fd);
		if(in_array($cd,$cond2)){
		$sl=preg_split("/[,]+/",$po);
		$sl2=(!empty($sl[1])?$sl[1]:$sl[0]);
		$search_cond[]=$fd." ".$cd." '".$sl[0]."' AND '".$sl2."'";
		}
		elseif(in_array($cd,$cond3)) $search_cond[]=$fd." ".$cd." ('".$po."')";
		elseif(in_array($cd,$cond4)) $search_cond[]=$fd." ".$cd;
		else $search_cond[]=$fd." ".html_entity_decode($ed->post('cond__'.$fd))." '$po'";
		}
	}
	$se_str=($search_cond?"WHERE ":"").implode(" AND ",$search_cond).($ed->post('order_field','!e')?" ORDER BY ".$ed->post('order_field')." ".$ed->post('order_ord')." ":"");
	$_SESSION["_sqlsearch_{$db}_{$tb}"]=$se_str;
	$ed->redir("20/$db/$tb");
	}

	echo $head.$ed->menu($db,$tb,1).$ed->form("24/$db/$tb")."<table><caption>Search</caption>";
	$conds="";
	foreach($cond as $cnd) $conds.="<option value='$cnd'>$cnd</option>";
	$fields="<option value=''>&nbsp;</option>";
	foreach($q_se as $r_se){
	$fl=$r_se['Field'];
	$fields.="<option value='$fl'>$fl</option>";
	echo "<tr><td>$fl</td><td><select name='cond__".$fl."'>$conds</select></td><td><input type='text' name='$fl'/></td></tr>";
	}
	echo "<tr class='c1'><td>Order</td><td><select name='order_field'>$fields</select></td><td><select name='order_ord'><option value='ASC'>ASC</option><option value='DESC'>DESC</option></select></td></tr>
	<tr><td colspan='3'><button type='submit' name='search'>Search</button></td></tr></table></form>";
break;

case "25"://table empty
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$ed->priv("DROP","20/$db/$tb");
	$ed->con->query("TRUNCATE TABLE `$tb`");
	$ed->redir("20/$db/$tb",['ok'=>"Table is empty"]);
break;

case "26"://table drop
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$ed->priv("DROP","5/$db");
	$ed->con->query("DROP TABLE `$tb`");
	//drop view
	$q_rw=$ed->con->query("SELECT TABLE_SCHEMA,TABLE_NAME,VIEW_DEFINITION FROM information_schema.views WHERE `TABLE_SCHEMA`='$db'");
	if($q_rw->num_row()){
	foreach($q_rw->fetch(2) as $r_rw){
	$q=$ed->con->query($r_rw['VIEW_DEFINITION']);
	if(!$q) $ed->con->query("DROP VIEW `".$r_rw['TABLE_NAME']."`");
	}
	}
	//drop procedure (no function)
	$q_rp=$ed->con->query("SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM information_schema.ROUTINES WHERE `ROUTINE_SCHEMA`='$db' AND `ROUTINE_TYPE`='PROCEDURE'");
	if($q_rp){
	foreach($q_rp->fetch(1) as $r_rp){
	if(preg_match('/\`'.$tb.'\`|\b'.$tb.'\b/',$r_rp[1])) $ed->con->query("DROP PROCEDURE `".$r_rp[0]."`");
	}
	}
	//drop event
	$q_evn=$ed->con->query("SELECT EVENT_NAME,EVENT_DEFINITION FROM information_schema.EVENTS WHERE `EVENT_SCHEMA`='$db'");
	foreach($q_evn->fetch(2) as $r_evn){
	if(preg_match('/\`'.$tb.'\`|\b'.$tb.'\b/',$r_evn['EVENT_DEFINITION'])) $ed->con->query("DROP EVENT `$db`.`".$r_evn['EVENT_NAME']."`");
	}
	$ed->redir("5/$db",['ok'=>"Successfully dropped"]);
break;

case "27"://optimize,analyze,check,repair
	$ed->check([1,2]);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$op=$ed->sg[3];
	$ops=['optimize','analyze','check','repair'];
	if(in_array($db,$deny)) $ed->redir("10/$db/$tb",['err'=>"Action restricted on this table"]);
	if(!empty($op) && in_array($op,$ops)){
	$q_op=$ed->con->query($op." TABLE ".$tb);
	if($op=='check' || $op=='repair'){
	$r_op=$q_op->fetch();
	if($r_op[3]=='OK') $ed->redir("10/$db/$tb",['ok'=>"Successfully executed"]);
	else $ed->redir("10/$db/$tb",['err'=>$r_op[3]]);
	}
	$ed->redir("10/$db/$tb",['ok'=>"Successfully executed"]);
	}else $ed->redir("10/$db/$tb",['err'=>"Action {$op} failed"]);
break;

case "30"://import
	$ed->check([1]);
	$db=$ed->sg[1];
	$ed->con->query("SET NAMES utf8");
	$out="";
	$q=0;
	set_time_limit(7200);
	if($ed->post()){
	$e='';
	$rgex="~^\xEF\xBB\xBF|^\xFE\xFF|^\xFF\xFE|(?i)DELIMITER.*[^ ]|(\#|--).*|(\/\*).*(\*\/;*)|([\$$|//].*[^\$$|//])|\(([^)]*\)*(\"*.*\")*('*.*'))(*SKIP)(*F)|(?is)(BEGIN.*?END)(*SKIP)(*F)|(?<=;)(?![ ]*$)~";
	if($ed->post('qtxt','!e')){//in textarea
		$qtxt=$ed->post('qtxt');
		if(preg_match('/^\b(describe|explain|select|show)\b/is',$qtxt)){
			$q_sel=$ed->con->query($qtxt);
			if($q_sel){
			$q_sel=$q_sel->fetch(2);
			echo $head.$ed->menu($db,'',1)."<table><tr>";
			foreach($q_sel[0] as $k=>$r_sel) echo "<th>$k</th>";
			echo "</tr>";
			foreach($q_sel as $r_sel){
			$bg=($bg==1)?2:1;
			echo "<tr class='r c$bg'>";
			foreach($r_sel as $r_se) echo "<td>$r_se</td>";
			echo "</tr>";
			}
			echo "</table>";
			}else $ed->redir("5/$db",['err'=>"Wrong query"]);
		}else{
			$e=preg_split($rgex,$qtxt,-1,PREG_SPLIT_NO_EMPTY);
		}
	}elseif($ed->post('send','i') && $ed->post('send')=="ja"){//from file
		if(empty($_FILES['importfile']['tmp_name'])){
		$ed->redir("5/$db",['err'=>"No file to upload"]);
		}else{
		$tmp=$_FILES['importfile']['tmp_name'];
		$file=$_FILES['importfile']['name'];
		preg_match("/^(.*)\.(sql|csv|json|xml|gz|zip)$/i",$file,$ext);
		if($ext[2]=='sql'){
			$fi=$ed->utf(file_get_contents($tmp));
			$e=preg_split($rgex,$fi,-1,PREG_SPLIT_NO_EMPTY);
		}elseif($ext[2]=='csv'){
			$e=$ed->imp_csv($ext[1],$tmp);
		}elseif($ext[2]=='json'){
			$e=$ed->imp_json($ext[1],$tmp);
		}elseif($ext[2]=='xml'){
			$e=$ed->imp_xml($tmp);
		}elseif($ext[2]=='gz'){
			if(($fgz=fopen($tmp,'r')) !==FALSE){
				if(@fread($fgz,3) !="\x1F\x8B\x08"){
				$ed->redir("5/$db",['err'=>"Not a valid GZ file"]);
				}
				fclose($fgz);
			}
			if(@function_exists('gzopen')){
				preg_match("/^(.*)\.(sql|csv|json|xml|tar)$/i",$ext[1],$ex);
				$gzfile=@gzopen($tmp,'rb');
				if(!$gzfile){
				$ed->redir("5/$db",['err'=>"Open GZ failed"]);
				}
				$e='';
				while(!gzeof($gzfile)){
				$e.=gzgetc($gzfile);
				}
				gzclose($gzfile);
				if($ex[2]=='sql') $e=preg_split($rgex,$ed->utf($e),-1,PREG_SPLIT_NO_EMPTY);
				elseif($ex[2]=='csv') $e=$ed->imp_csv($ex[1],$e);
				elseif($ex[2]=='json') $e=$ed->imp_json($ex[1],$e);
				elseif($ex[2]=='xml') $e=$ed->imp_xml($e);
				elseif($ex[2]=='tar'){
					$fh=gzopen($tmp,'rb');
					$fsize=strlen($e);
					$total=0;$e=[];
					while(false !== ($block=gzread($fh,512))){
					$total+=512;
					$t=unpack("a100name/a8mode/a8uid/a8gid/a12size/a12mtime",$block);
					$file=['name'=>$t['name'],'mode'=>@octdec($t['mode']),'uid'=>@octdec($t['uid']),'size'=>@octdec($t['size']),'mtime'=>@octdec($t['mtime'])];
					$file['bytes']=($file['size'] + 511) & ~511;
					if($file['bytes'] > 0){
					$block=gzread($fh,$file['bytes']);
					$buf=substr($block,0,$file['size']);
					$fi=trim($file['name']);
					preg_match("/^(.*)\.(sql|csv|json|xml)$/i",$fi,$tx);
					if($tx[2]=='sql') $e[]=preg_split($rgex,$ed->utf($buf),-1,PREG_SPLIT_NO_EMPTY);
					elseif($tx[2]=='csv') $e[]=$ed->imp_csv($tx[1],$buf);
					elseif($tx[2]=='json') $e[]=$ed->imp_json($tx[1],$buf);
					elseif($tx[2]=='xml') $e[]=$ed->imp_xml($buf);
					$total+=$file['bytes'];
					}
					if($total >= $fsize-1024) break;
					}
					gzclose($fh);
					$e=call_user_func_array('array_merge',$e);
				}
			}else{
				$ed->redir("5/$db",['err'=>"Open GZ failed"]);
			}
		}elseif($ext[2]=='zip'){
			if(($fzip=fopen($tmp,'r')) !==FALSE){
				if(@fread($fzip,4) !="\x50\x4B\x03\x04"){
				$ed->redir("5/$db",['err'=>"Not a valid ZIP file"]);
				}
				fclose($fzip);
			}
			$e=[];
			$zip=new ZipArchive;
			$res=$zip->open($tmp);
			if($res === TRUE){
				$i=0;
				while($i < $zip->numFiles){
				$zentry=$zip->getNameIndex($i);
				$buf=$zip->getFromName($zentry);
				preg_match("/^(.*)\.(sql|csv|json|xml)$/i",$zentry,$zn);
				if(!empty($zn[2])){
				if($zn[2]=='sql') $e[]=preg_split($rgex,$ed->utf($buf),-1,PREG_SPLIT_NO_EMPTY);
				elseif($zn[2]=='csv') $e[]=$ed->imp_csv($zn[1],$buf);
				elseif($zn[2]=='json') $e[]=$ed->imp_json($zn[1],$buf);
				elseif($zn[2]=='xml') $e[]=$ed->imp_xml($buf);
				}
				++$i;
				}
				$zip->close();
				if(count($e) != count($e,COUNT_RECURSIVE)) $e=call_user_func_array('array_merge',$e);
			}
		}else{
			$ed->redir("5/$db",['err'=>"Disallowed extension"]);
		}
		}
	}else{
		$ed->redir("5/$db",['err'=>"Query failed"]);
	}
	if(!empty($e) && is_array($e)){
		$ed->con->begin();
		foreach($e as $qry){
			$qry=trim($qry);
			if(!empty($qry)){
				$exc=$ed->con->query($qry);
				$op=['insert','update','delete'];
				$p_qry=strtolower(substr($qry,0,6));
				if(in_array($p_qry,$op) && $exc) $exc=$exc->last();
				if($exc) ++$q;
				else $out.="<p><b>FAILED!</b> $qry</p>";
			}
		}
		$ed->con->commit();
		echo $head.$ed->menu($db)."<div class='col2'><p>Successfully executed: <b>$q quer".($q>1?'ies':'y')."</b></p>$out";
	}
	}else $ed->redir("5/$db",[]);
break;

case "31"://export form
	$ed->check();
	echo $head;
	$div="<div class='dw'><h3 class='l1'>Export</h3>";
	if(empty($ed->sg[1])){
	echo $ed->menu(1,'',2).$ed->form("32").$div."<h3>Select database(s)</h3>
	<p><input type='checkbox' onclick='selectall(this,\"dbs\");dbx()'/> All/None</p>
	<select id='dbs' name='dbs[]' multiple='multiple' onchange='dbx()'>";
	foreach($ed->u_db as $udb){
	$udb=$udb[0];
	if(!in_array($udb,$deny)) echo "<option value='$udb'>$udb</option>";
	}
	echo "</select>";
	}else{
	$db=$ed->sg[1];
	$q_tts=$ed->con->query("SHOW TABLES FROM `$db`");
	if($q_tts->num_row()){
	echo $ed->menu($db,'',2).$ed->form("32/$db").$div."<h3>Select table(s)</h3>
	<p><input type='checkbox' onchange='selectall(this,\"tbs\");dbx(\"tbs\")'/> All/None</p>
	<select id='tbs' name='tbs[]' multiple='multiple' onchange='dbx(\"tbs\")'>";
	foreach($q_tts->fetch(1) as $r_tt) echo "<option value='".$r_tt[0]."'>".$r_tt[0]."</option>";
	echo "</select>";
	}else{
	$ed->redir("5/$db",["err"=>"No export empty DB"]);
	}
	}
	echo "<h3><input type='checkbox' onclick='toggle(this,\"fopt[]\");fmt()'/> Options</h3>";
	$opts=['structure'=>'Structure','data'=>'Data','drop'=>'Drop if exist','ifnot'=>'If not exist','auto'=>'Auto Increment','lock'=>'Lock table','cdb'=>'Create DB','trigger'=>'Triggers','procfunc'=>'Routines','event'=>'Events'];
	foreach($opts as $k=> $opt) echo "<p><input type='checkbox' name='fopt[]' value='$k'/> $opt</p>";
	echo "<h3>File format</h3>";
	$ffo=['sql'=>'SQL','xls'=>'Spreadsheet','xml'=>'XML','doc'=>'Word'];
	if(!empty($ed->sg[1])) $ffo=array_merge($ffo,['json'=>'JSON','csv1'=>'CSV,','csv2'=>'CSV;']);
	foreach($ffo as $k=> $ff) echo "<p><input type='radio' name='ffmt[]' onclick='fmt()' value='$k'".($k=='sql' ? ' checked':'')."/> $ff</p>";
	echo "<h3>File compression</h3><p><select name='ftype'>";
	$fty=['plain'=>'None','zip'=>'Zip','gz'=>'GZ'];
	foreach($fty as $k=> $ft) echo "<option value='$k'>$ft</option>";
	echo "</select></p><button type='submit' name='exp'>Export</button></div></form>";
break;

case "32"://export
	if($ed->post('exp','i')){
	$ed->check();
	$ffmt=$ed->post('ffmt'); $ftype=$ed->post('ftype');
	$dbs=(empty($ed->sg[1])?($ed->post('dbs')?$ed->post('dbs'):[]):[$ed->sg[1]]);
	if((!empty($ed->sg[1]) && $ed->post('tbs')=='') || (empty($ed->sg[1]) && $ed->post('dbs')=='')){
		$ed->redir("31".(empty($ed->sg[1])?'':'/'.$ed->sg[1]),['err'=>"You didn't selected any DB/Table"]);
	}
	if($ed->post('fopt')=='' && in_array($ffmt[0],['sql','doc','xml'])){//export options
		$ed->redir("31".(empty($ed->sg[1])?'':'/'.$ed->sg[1]),['err'=>"You didn't selected any option"]);
	}else{
		$fopt=$ed->post('fopt');
	}
	if($ffmt[0]=='sql'){//sql format
		$ffty="text/plain"; $ffext=".sql"; $fname=(count($dbs)>1 ? 'all':$dbs[0]).$ffext;
		foreach($dbs as $db){
		$sq="-- EdMyAdmin $version SQL Dump\n\n";
		if(in_array('cdb',$fopt)){//option create db
			$cll=$ed->con->query("SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='$db';")->fetch();
			$sq.="CREATE DATABASE ";
			if(in_array('ifnot',$fopt)){//option if not exist
			$sq.="IF NOT EXISTS ";
			}
			$sq.="`$db` COLLATE `{$cll[0]}`;\nUSE `$db`;\n";
		}
		list($tbs,$vws)=$ed->getTables($db);
		foreach($tbs as $tb){
			$r_st=$ed->con->query("SHOW TABLE STATUS FROM `$db` like '$tb'")->fetch();
			if(in_array('structure',$fopt)){//structure
				$sq.=$ed->tb_structure($db,$tb,$fopt,'',$r_st)."\n";
			}
			if(in_array('data',$fopt)){//option data
				$q_fil=$ed->con->query("SHOW FIELDS FROM `$db`.`$tb`");
				$cols=$q_fil->num_row();
				$r_fil=$q_fil->fetch(1);
				$q_rx=$ed->con->query("SELECT * FROM `$db`.`$tb`");
				if($q_rx){
					if($r_st[17] !='VIEW'){
					$sq.="\n";
					if(in_array('lock',$fopt)) $sq.="LOCK TABLES `$tb` WRITE;\n";
					foreach($q_rx->fetch(1) as $r_rx){
						$ins="INSERT INTO `$tb` VALUES (";
						$inn="";
						$e=0;
						while($e<$cols){
							$bi=$r_fil[$e][1];//blob
							if(stristr($bi,"blob")==true){
								if(empty($r_rx[$e])){
								$inn.="'', ";
								}elseif(strpos($r_rx[$e],"\0")==true){
								$inn.="0x".bin2hex($r_rx[$e]).", ";
								}else{
								$inn.="'".addslashes($r_rx[$e])."', ";
								}
							}elseif(is_numeric($r_rx[$e])){
							$inn.=$r_rx[$e].", ";
							}elseif(empty($r_rx[$e]) && $r_fil[$e][2]=='YES'){
							$inn.="NULL, ";
							}elseif(empty($r_rx[$e]) && $r_fil[$e][2]=='NO'){
							$inn.="'', ";
							}else{
							$inn.=($r_rx[$e]==''?'':"'".preg_replace(["/\r\n|\r|\n/","/'/"],["\\n","\'"],$r_rx[$e])."', ");
							}
							++$e;
						}
						$ins.=substr($inn,0,-2);
						$sq.=$ins.");\n";
					}
					if(in_array('lock',$fopt)) $sq.="UNLOCK TABLES;\n";
					$sq.="\n";
					}
				}
			}
		}
		if($vws !='' && in_array('structure',$fopt)){//export views
		foreach($vws as $vw){
			$q_rw=$ed->con->query("SHOW CREATE VIEW `$db`.`$vw`");
			if($q_rw){
			if(in_array('drop',$fopt)){//option drop
			$sq.="\nDROP VIEW IF EXISTS `$vw`;\n";
			}
			foreach($q_rw->fetch(1) as $r_rr){
			$sq.=$r_rr[1].";\n";
			}
			$sq.="\n";
			}
		}
		}
		$sqs='';
		if(in_array('trigger',$fopt)){//option trigger
			$q_trg=$ed->con->query("SELECT TRIGGER_NAME,ACTION_TIMING,EVENT_MANIPULATION,EVENT_OBJECT_TABLE,ACTION_STATEMENT FROM information_schema.triggers WHERE TRIGGER_SCHEMA='$db'");
			if($q_trg){
			$sqs.="\n";
			foreach($q_trg->fetch(1) as $r_row){
				if(in_array('drop',$fopt)){//option drop
				$sqs.="DROP TRIGGER IF EXISTS `".$r_row[0]."`;\n";
				}
				$sqs.="CREATE TRIGGER `".$r_row[0]."` ".$r_row[1]." ".$r_row[2]." ON `".$r_row[3]."` FOR EACH ROW\n".$r_row[4]."$$\n\n";
			}
			}
		}
		if(in_array('procfunc',$fopt)){//option routine
			$q_pr=$ed->con->query("SELECT ROUTINE_TYPE,ROUTINE_NAME FROM information_schema.routines WHERE ROUTINE_SCHEMA='$db'");
			if($q_pr){
			$sqs.="\n";
			foreach($q_pr->fetch(1) as $r_px){
				if(in_array('drop',$fopt)){//option drop
				$sqs.="DROP ".$r_px[0]." IF EXISTS `".$r_px[1]."`;\n";
				}
				$q_rs=$ed->con->query("SHOW CREATE ".$r_px[0]." `$db`.`".$r_px[1]."`");
				foreach($q_rs->fetch(1) as $r_rs){
				$sqs.=$r_rs[2]."$$\n\n";
				}
			}
			}
		}
		if(in_array('event',$fopt)){//option event
			$q_eev=$ed->con->query("SELECT EVENT_NAME FROM information_schema.EVENTS WHERE EVENT_SCHEMA='$db'");
			if($q_eev){
			$sqs.="\n";
			foreach($q_eev->fetch(1) as $r_eev){
				if(in_array('drop',$fopt)){//option drop
				$sqs.="DROP EVENT IF EXISTS `".$r_eev[0]."`;\n";
				}
				$q_rev=$ed->con->query("SHOW CREATE EVENT `$db`.`".$r_eev[0]."`")->fetch(1);
				foreach($q_rev as $r_rev){
				$sqs.=$r_rev[3]."$$\n\n";
				}
			}
			}
		}
		$sq.=(trim($sqs)!=''?"\nDELIMITER $$\n".$sqs."DELIMITER ;\n":"");
		if($ftype!="plain" && count($dbs)>1) $sql[$db.$ffext]=$sq;
		else $sql=$sq;
		}
	}elseif($ffmt[0]=='csv1' || $ffmt[0]=='csv2'){//csv format
		$db=$dbs[0];
		list($tbs)=$ed->getTables($db);
		$ffty="text/csv"; $ffext=".csv"; $fname=$db.$ffext;
		$sql=[];
		$sign=($ffmt[0]=='csv1'?',':';');
		if(empty($tbs[0])) $ed->redir("31/".$db,['err'=>"Select a table"]);
		foreach($tbs as $tb){
			$sq='';
			$q_csv=$ed->con->query("SHOW FIELDS FROM `$db`.`$tb`")->fetch(2);
			foreach($q_csv as $r_csv) $sq.=$r_csv['Field'].$sign;
			$sq=substr($sq,0,-1)."\n";
			$q_rs=$ed->con->query("SELECT * FROM `$db`.`$tb`")->fetch(1);
			foreach($q_rs as $r_rs){
			foreach($r_rs as $r_r) $sq.=(is_numeric($r_r) ? $r_r : "\"".preg_replace(["/\r\n|\r|\n/","/'/","/\"/"],["\\n","\'","\"\""],$r_r)."\"").$sign;
			$sq=substr($sq,0,-1)."\n";
			}
			$sql[$tb.$ffext]=$sq;
		}
		if($ftype=="plain" || count($tbs)<2){
		$fname=$tbs[0].$ffext;
		$sql=$sql[$fname];
		}
	}elseif($ffmt[0]=='json'){//json format
		$db=$dbs[0];
		list($tbs)=$ed->getTables($db);
		$ffty="text/json"; $ffext=".json"; $fname=$db.$ffext;
		$sql=[];
		foreach($tbs as $tb){
			$sq='';
			$q_jso=$ed->con->query("SELECT * FROM `$db`.`$tb`");
			if($q_jso->num_row() > 0){
			$sq.='[';
			foreach($q_jso->fetch(2) as $k_jso=>$r_jso){
			$jh='{';
			foreach($r_jso as $k_jo=>$r_jo) $jh.='"'.$k_jo.'":'.(is_numeric($r_jo)?$r_jo:'"'.preg_replace(["/\r\n|\r|\n/","/\t/","/'/","/\"/"],["\\n","\\t","''","\\\""],$r_jo).'"').',';
			$sq.=substr($jh,0,-1).'},';
			}
			$sq=substr($sq,0,-1).']';
			}
			$sql[$tb.$ffext]=$sq;
		}
		if($ftype=="plain" || count($tbs)<2){
		$fname=$tbs[0].$ffext;
		$sql=$sql[$fname];
		}
	}elseif($ffmt[0]=='doc'){//doc format
		$ffty="application/msword"; $ffext=".doc"; $fname=(count($dbs)>1 ? 'all':$dbs[0]).$ffext;
		foreach($dbs as $db){
		list($tbs)=$ed->getTables($db);
		$sq='<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:word" 	xmlns="http://www.w3.org/TR/REC-html40"><!DOCTYPE html><html><head><meta http-equiv="Content-type" content="text/html;charset=utf-8"></head><body>';
		foreach($tbs as $tb){
		$q_doc=$ed->con->query("SHOW FIELDS FROM `$db`.`$tb`")->fetch(2);
		if(in_array('structure',$fopt)){
			$wh='<table border=1 cellpadding=0 cellspacing=0 style="border-collapse: collapse"><tr bgcolor="#eeeeee">';
			foreach($q_doc[0] as $r_k=>$r_doc) $wh.='<th>'.$r_k.'</th>';
			$wh.='</tr>';
			foreach($q_doc as $r_doc){
				$wh.='<tr>';
				foreach($r_doc as $r_d1) $wh.='<td>'.$r_d1.'</td>';
				$wh.='</tr>';
			}
			$wh.='</table><br>';
		}
		$wb='';
		if(in_array('data',$fopt)){
			$wb='<table border=1 cellpadding=0 cellspacing=0 style="border-collapse: collapse"><tr>';
			foreach($q_doc as $r_dc) $wb.='<th>'.$r_dc['Field'].'</th>';
			$wb.="</tr>";
			$q_dc2=$ed->con->query("SELECT * FROM `$db`.`$tb`")->fetch(1);
			foreach($q_dc2 as $r_dc2){
			$wb.="<tr>";
			foreach($r_dc2 as $r_d2) $wb.='<td>'.$r_d2.'</td>';
			$wb.="</tr>";
			}
			$wb.='</table><br>';
		}
		$sq.=$wh.$wb;
		}
		$sq.='</body></html>';
		if($ftype!="plain" && count($dbs)>1) $sql[$db.$ffext]=$sq;
		else $sql=$sq;
		}
	}elseif($ffmt[0]=='xls'){//xls format
		$ffty="application/excel"; $ffext=".xls"; $fname=(count($dbs)>1 ? 'all':$dbs[0]).$ffext;
		foreach($dbs as $db){
		list($tbs)=$ed->getTables($db);
		$sq='<?xml version="1.0"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">';
		foreach($tbs as $tb){
			$xh='<Worksheet ss:Name="'.$tb.'"><Table><Row>';
			$q_xl1=$ed->con->query("SHOW FIELDS FROM `$db`.`$tb`")->fetch(2);
			foreach($q_xl1 as $r_xl1) $xh.='<Cell><Data ss:Type="String">'.$r_xl1['Field'].'</Data></Cell>';
			$xh.='</Row>';
			$q_xl2=$ed->con->query("SELECT * FROM `$db`.`$tb`")->fetch(1);
			foreach($q_xl2 as $r_xl2){
			$xh.='<Row>';
			foreach($r_xl2 as $r_x2) $xh.='<Cell><Data ss:Type="'.(is_numeric($r_x2)?'Number':'String').'">'.htmlentities($r_x2).'</Data></Cell>';
			$xh.='</Row>';
			}
			$sq.=$xh.'</Table></Worksheet>';
		}
		$sq.='</Workbook>';
		if($ftype!="plain" && count($dbs)>1) $sql[$db.$ffext]=$sq;
		else $sql=$sq;
		}
	}elseif($ffmt[0]=='xml'){//xml format
		$ffty="application/xml"; $ffext=".xml"; $fname=(count($dbs)>1 ? 'all':$dbs[0]).$ffext;
		foreach($dbs as $db){
		list($tbs,$vws)=$ed->getTables($db);
		$sq="<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<!-- EdMyAdmin $version XML Dump -->\n<export version=\"1.0\" xmlns:ed=\"https://github.com/edmondsql\">";
		if(in_array('structure',$fopt)){
		$cll=$ed->con->query("SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='$db';")->fetch();
		$sq.="\n\t<ed:structure_schemas>";
		$sq.="\n\t\t<ed:database name=\"$db\" collate=\"{$cll[0]}\">";
		foreach($tbs as $tb){
			$sq.="\n\t\t\t<ed:table name=\"$tb\">";
			$r_st=$ed->con->query("SHOW TABLE STATUS FROM `$db` like '$tb'")->fetch();
			$sq.=$ed->tb_structure($db,$tb,$fopt,"\t\t\t",$r_st);
			$sq.="\n\t\t\t</ed:table>";
		}
		foreach($vws as $vw){
			$sq.="\n\t\t\t<ed:table name=\"$vw\">";
			$r_vi=$ed->con->query("SELECT VIEW_DEFINITION FROM information_schema.VIEWS WHERE `TABLE_SCHEMA`='$db' AND `TABLE_NAME`='$vw'")->fetch();
			$sq.="\n\t\t\tCREATE VIEW `$vw` AS ".$r_vi[0];
			$sq.="\n\t\t\t</ed:table>";
		}
		$sq.="\n\t\t</ed:database>\n\t</ed:structure_schemas>";
		}
		$sq2='';
		if(in_array('data',$fopt)){
		$sq2="\n\t<database name=\"$db\">";
		foreach($tbs as $tb){
		$q_xm1=$ed->con->query("SHOW FIELDS FROM `$db`.`$tb`")->fetch(1);
		$q_xm2=$ed->con->query("SELECT * FROM `$db`.`$tb`")->fetch(1);
		foreach($q_xm2 as $r_=>$r_xm2){
			$sq2.="\n\t\t<table name=\"$tb\">";
			$x=0;
			foreach($r_xm2 as $r_x2){
			$sq2.="\n\t\t\t<column name=\"".$q_xm1[$x][0]."\">".addslashes(htmlspecialchars($r_x2))."</column>";
			++$x;
			}
			$sq2.="\n\t\t</table>";
		}
		}
		$sq2.="\n\t</database>";
		}
		$sq.=$sq2."\n</export>";
		if($ftype!="plain" && count($dbs)>1) $sql[$db.$ffext]=$sq;
		else $sql=$sq;
		}
	}

	if($ftype=="gz"){//gz
		$zty="application/x-gzip"; $zext=".gz";
		ini_set('zlib.output_compression','Off');
		if(is_array($sql) && count($sql)>1){
		$sq='';
		foreach($sql as $qname=>$sqa){
			$tmpf=tmpfile();
			$len=strlen($sqa);
			$ctxt=pack("a100a8a8a8a12a12",$qname,644,0,0,decoct($len),decoct(time()));
			$checksum=8*32;
			for($i=0; $i < strlen($ctxt); $i++) $checksum +=ord($ctxt[$i]);
			$ctxt.=sprintf("%06o",$checksum)."\0 ";
			$ctxt.=str_repeat("\0",512 - strlen($ctxt));
			$ctxt.=$sqa;
			$ctxt.=str_repeat("\0",511 - ($len + 511) % 512);
			fwrite($tmpf,$ctxt);
			fseek($tmpf,0);
			$fs=fstat($tmpf);
			$sq.=fread($tmpf,$fs['size']);
			fclose($tmpf);
		}
		$fname=$db.".tar";
		$sql=$sq.pack('a1024','');
		}
		$sql=gzencode($sql,9);
		header('Accept-Encoding: gzip;q=0,deflate;q=0');
	}elseif($ftype=="zip"){//zip
		$zty="application/x-zip";
		$zext=".zip";
		$info=[];
		$ctrl_dir=[];
		$eof="\x50\x4b\x05\x06\x00\x00\x00\x00";
		$old_offset=0;
		if(is_array($sql)) $sqlx=$sql;
		else $sqlx[$fname]=$sql;
		foreach($sqlx as $qname=>$sqa){
		$ti=getdate();
		if($ti['year'] < 1980){
		$ti['year']=1980;$ti['mon']=1;$ti['mday']=1;$ti['hours']=0;$ti['minutes']=0;$ti['seconds']=0;
		}
		$time=(($ti['year'] - 1980) << 25) | ($ti['mon'] << 21) | ($ti['mday'] << 16) | ($ti['hours'] << 11) | ($ti['minutes'] << 5) | ($ti['seconds'] >> 1);
		$dtime=substr("00000000".dechex($time),-8);
		$hexdtime='\x'.$dtime[6].$dtime[7].'\x'.$dtime[4].$dtime[5].'\x'.$dtime[2].$dtime[3].'\x'.$dtime[0].$dtime[1];
		eval('$hexdtime="'.$hexdtime.'";');
		$fr="\x50\x4b\x03\x04\x14\x00\x00\x00\x08\x00".$hexdtime;
		$unc_len=strlen($sqa);
		$crc=crc32($sqa);
		$zdata=gzcompress($sqa);
		$zdata=substr(substr($zdata,0,strlen($zdata) - 4),2);
		$c_len=strlen($zdata);
		$fr.=pack('V',$crc).pack('V',$c_len).pack('V',$unc_len).pack('v',strlen($qname)).pack('v',0).$qname.$zdata;
		$info[]=$fr;
		$cdrec="\x50\x4b\x01\x02\x00\x00\x14\x00\x00\x00\x08\x00".$hexdtime.
		pack('V',$crc).pack('V',$c_len).pack('V',$unc_len).pack('v',strlen($qname)).
		pack('v',0).pack('v',0).pack('v',0).pack('v',0).pack('V',32).pack('V',$old_offset);
		$old_offset +=strlen($fr);
		$cdrec.=$qname;
		$ctrl_dir[]=$cdrec;
		}
		$ctrldir=implode('',$ctrl_dir);
		$end=$ctrldir.$eof.pack('v',sizeof($ctrl_dir)).pack('v',sizeof($ctrl_dir)).pack('V',strlen($ctrldir)).pack('V',$old_offset)."\x00\x00";
		$datax=implode('',$info);
		$sql=$datax.$end;
	}
	header("Cache-Control: no-store,no-cache,must-revalidate,pre-check=0,post-check=0,max-age=0");
	header("Content-Type: ".($ftype=="plain" ? $ffty."; charset=utf-8":$zty));
	header("Content-Length: ".strlen($sql));
	header("Content-Disposition: attachment; filename=".$fname.($ftype=="plain" ? "":$zext));
	die($sql);
	}
break;

case "33"://blob download
	$ed->check([1,2,3],['redir'=>'20']);
	$db=$ed->sg[1];
	$tb=$ed->sg[2];
	$nu=$ed->sg[3];
	$id=base64_decode($ed->sg[4]);
	if(empty($ed->sg[7])){
	$ph=$ed->sg[5];$nu1="";
	}else{
	$ph=$ed->sg[7];$nu1=" AND `".$ed->sg[5]."`='".base64_decode($ed->sg[6])."'";
	}
	$r_ph=$ed->con->query("SELECT $ph FROM `$tb` WHERE `$nu`='$id'$nu1 LIMIT 1")->fetch();
	$r_ph=$r_ph[0];$len=strlen($r_ph);
	$tp='application/octet-stream';$xt='bin';
	if($len>3){
	if(substr($r_ph,0,3)=="\xFF\xD8\xFF"){$tp='image/jpg';$xt='jpg';}
	elseif(substr($r_ph,0,3)=="GIF"){$tp='image/gif';$xt='gif';}
	elseif(substr($r_ph,0,4)=="\x89PNG"){$tp='image/png';$xt='png';}
	elseif(substr($r_ph,0,4)=="RIFF"){$tp='image/webp';$xt='webp';}
	}
	header("Content-type: $tp");
	header("Content-Length: $len");
	header("Content-Disposition: attachment; filename={$tb}-blob.{$xt}");
	die($r_ph);
break;

case "40"://view
	if(!isset($ed->sg[2]) && !isset($ed->sg[3])){//add
		$ed->check([1]);
		$db=$ed->sg[1];
		$ed->priv("CREATE VIEW","5/$db");
		$r_uv=[0=>'',1=>''];
		if($ed->post('uv1','!e') && $ed->post('uv2','!e')){
			$tb=$ed->sanitize($ed->post('uv1'));
			$exi=$ed->con->query("SELECT 1 FROM `$tb`");
			if($exi) $ed->redir("5/$db",['err'=>"This name exist"]);
			$vstat=$ed->post('uv2');
			$stat=$ed->con->query($vstat);
			if(!$stat) $ed->redir("5/$db",['err'=>"Wrong statement"]);
			$v_cre=$ed->con->query("CREATE VIEW `$tb` AS $vstat");
			if($v_cre) $ed->redir("5/$db",['ok'=>"Successfully created"]);
			else $ed->redir("5/$db",['err'=>"Create view failed"]);
		}
		echo $head.$ed->menu($db,'',2).$ed->form("40/$db");
		$b_lbl="Create";
	}else{//edit
		$ed->check([1,5]);
		$db=$ed->sg[1];$sp=$ed->sg[2];$ty=$ed->sg[3];
		$ed->priv("SHOW VIEW","5/$db");
		$r_uv=$ed->con->query("SELECT TABLE_NAME,VIEW_DEFINITION FROM information_schema.VIEWS WHERE `TABLE_SCHEMA`='$db' AND `TABLE_NAME`='$sp'")->fetch();
		if($ed->post('uv1','!e') && $ed->post('uv2','!e')){
			$tb=$ed->sanitize($ed->post('uv1'));
			if(is_numeric(substr($tb,0,1))) $ed->redir("5/$db",['err'=>"Not a valid name"]);
			$exi=$ed->con->query("SELECT 1 FROM `$tb`");
			if($exi && $tb!=$r_uv[0]) $ed->redir("5/$db",['err'=>"This name exist"]);
			$vstat=$ed->post('uv2');
			$stat=$ed->con->query($vstat);
			if(!$stat) $ed->redir("5/$db",['err'=>"Wrong statement"]);
			$ed->con->query("DROP VIEW IF EXISTS `$sp`");
			$ed->con->query("CREATE VIEW `$tb` AS $vstat");
			$ed->redir("5/$db",['ok'=>"Successfully updated"]);
		}
		echo $head.$ed->menu($db,'',2,[$ty,$sp]).$ed->form("40/$db/$sp/$ty");
		$b_lbl="Edit";
	}
	echo "<table><tr><th colspan='2'>$b_lbl View</th></tr><tr><td>Name</td><td><input type='text' name='uv1' value='".$r_uv[0]."'/></td></tr><tr><td>Statement</td><td><textarea name='uv2'>".$r_uv[1]."</textarea></td></tr><tr><td colspan='2'><button type='submit'>Save</button></td></tr></table></form>";
break;

case "41"://trigger
	if(!isset($ed->sg[2]) && !isset($ed->sg[3])){//add
		$ed->check([1]);
		$db=$ed->sg[1];
		$ed->priv("TRIGGER","5/$db");
		$r_tge=[0=>'',1=>'',2=>'',3=>'',4=>''];
		if($ed->post('utg1','!e') && $ed->post('utg5','!e')){
		$utg1=$ed->sanitize($ed->post('utg1'));
		if(is_numeric(substr($t_nm,0,1))) $ed->redir("41/$db",['err'=>"Not a valid name"]);
		$utg2=$ed->post('utg2');$utg3=$ed->post('utg3');$utg4=$ed->post('utg4');$utg5=$ed->post('utg5');
		$q_tgcrt=$ed->con->query("CREATE TRIGGER `$utg1` $utg2 $utg3 ON `$utg4` FOR EACH ROW $utg5");
		if($q_tgcrt) $ed->redir("5/$db",['ok'=>"Successfully created"]);
		else $ed->redir("5/$db",['err'=>"Create failed"]);
		}
		echo $head.$ed->menu($db,'',2).$ed->form("41/$db");
		$t_lbl="Create";
	}else{//edit
		$ed->check([1,5]);
		$db=$ed->sg[1];$sp=$ed->sg[2];$ty=$ed->sg[3];
		if($ed->post('utg1','!e') && $ed->post('utg5','!e')){
			$utg1=$ed->sanitize($ed->post('utg1'));
			$utg2=$ed->post('utg2');$utg3=$ed->post('utg3');$utg4=$ed->post('utg4');$utg5=$ed->post('utg5');
			if(is_numeric(substr($utg1,0,1))) $ed->redir("5/$db",['err'=>"Not a valid name"]);
			$sess=$ed->con->query("SHOW CREATE $ty `$db`.`$sp`")->fetch();
			$_SESSION['t_tmp']=$sess[2];
			$ed->con->query("DROP $ty IF EXISTS `$db`.`$sp`");
			$q_tgcrt=$ed->con->query("CREATE TRIGGER `$utg1` $utg2 $utg3 ON `$utg4` FOR EACH ROW $utg5");
			if($q_tgcrt){
			unset($_SESSION["t_tmp"]);
			$ed->redir("5/$db",['ok'=>"Successfully updated"]);
			}else{
			$ed->con->query($_SESSION["t_tmp"]);
			unset($_SESSION["t_tmp"]);
			$ed->redir("41/$db/$sp/$ty",['err'=>"Update failed"]);
			}
		}
		$r_tge=$ed->con->query("SELECT TRIGGER_NAME,EVENT_OBJECT_TABLE,ACTION_TIMING,EVENT_MANIPULATION,ACTION_STATEMENT FROM information_schema.TRIGGERS WHERE `TRIGGER_SCHEMA`='$db' AND `TRIGGER_NAME`='$sp'")->fetch();
		echo $head.$ed->menu($db,'',2,[$ty,$sp]).$ed->form("41/$db/$sp/$ty");
		$t_lbl="Edit";
	}
	$tgtb=[];//list tables
	$q_trgt=$ed->con->query("SHOW TABLE STATUS FROM `$db`")->fetch(2);
	foreach($q_trgt as $r_trgt){
	if($r_trgt['Comment']!='VIEW'){
	$tgtb[]=$r_trgt['Name'];
	}
	}
	echo "<table><tr><th colspan='2'>$t_lbl Trigger</th></tr><tr><td>Trigger Name</td><td><input type='text' name='utg1' value='".$r_tge[0]."'/></td></tr><tr><td>Table</td><td><select name='utg4'>";
	foreach($tgtb as $tgt) echo "<option value='$tgt'".($r_tge[1]==$tgt? " selected":"").">$tgt</option>";
	echo "</select></td></tr><tr><td>Time</td><td><select name='utg2'>";
	$tm=['BEFORE','AFTER'];
	foreach($tm as $tn) echo "<option value='$tn'".($r_tge[2]==$tn?" selected":"").">$tn</option>";
	echo "</select></td></tr><tr><td>Event</td><td><select name='utg3'>";
	$evm=['INSERT','UPDATE','DELETE'];
	foreach($evm as $evn) echo "<option value='$evn'".($r_tge[3]==$evn?" selected":"").">$evn</option>";
	echo "</select></td></tr><tr><td>Definition</td><td><textarea name='utg5'>".$r_tge[4]."</textarea></td></tr><tr><td colspan='2'><button type='submit'>Save</button></td></tr></table></form>";
break;

case "42"://routine
	if(!isset($ed->sg[2]) && !isset($ed->sg[3])){//add
		$ed->check([1]);
		$db=$ed->sg[1];
		$ed->priv("ALTER ROUTINE","5/$db");
		$r_rou=[0=>'',1=>'',4=>'',5=>'NO',6=>'',7=>'',8=>''];$plist=[1];
		if($ed->post('ronme','!e') && $ed->post('rodf','!e')){
			$r_new=$ed->sanitize($ed->post('ronme'));
			$crea=$ed->create_ro($db,$r_new);
			if($crea) $ed->redir("5/$db",['ok'=>"Created routine"]);
			else $ed->redir("5/$db",['err'=>"Create failed"]);
		}
		echo $head.$ed->menu($db,'',2).$ed->form("42/$db");
		$t_lbl="Create";
	}else{//edit
		$ed->check([1,5]);
		$db=$ed->sg[1];$sp=$ed->sg[2];$ty=$ed->sg[3];
		if($ed->post('ronme','!e') && $ed->post('rodf','!e')){
			$r_new=$ed->sanitize($ed->post('ronme'));
			$r_tmp=$r_new.'_'.uniqid(mt_rand());
			$crea=$ed->create_ro($db,$r_tmp);
			$ed->con->query("DROP $ty IF EXISTS `$r_tmp`");
			if($crea){
			$ed->con->query("DROP $ty IF EXISTS `$sp`");
			$ed->create_ro($db,$r_new);
			$ed->redir("5/$db",['ok'=>"Updated routine"]);
			}else $ed->redir("42/$db/$sp/$ty",['err'=>"Update failed"]);
		}
		$r_rou=$ed->con->query("SELECT routine_name,routine_type,character_set_client,dtd_identifier,routine_definition,is_deterministic,security_type,sql_data_access,routine_comment FROM information_schema.ROUTINES WHERE `ROUTINE_SCHEMA`='$db' AND `ROUTINE_NAME`='$sp'")->fetch();
		//function return
		if($r_rou[3] && stripos($r_rou[3],') ')) $retrn=preg_split('/[()]\s*/',$r_rou[3]);
		else $retrn=($r_rou[3]=='' ? '':explode(" ",$r_rou[3]));
		if(empty($retrn[2]) && !empty($r_rou[2])){
		$retrn=is_array($retrn)?$retrn:[$retrn];
		$retrn[2]=$r_rou[2];
		}
		if(!empty($retrn[2])) $retrn[2]=str_replace("CHARSET ","",$retrn[2]);
		//param_list
		$q_plist=$ed->con->query("SHOW CREATE $ty `$db`.`$sp`")->fetch();
		preg_match('#\((([^()]*|(?R))*)\)#',$q_plist[2],$r_plist);
		$plist=preg_split("/\(.*?\)(*SKIP)(*F)|,/",$r_plist[1]);
		echo $head.$ed->menu($db,'',2,[$ty,$sp]).$ed->form("42/$db/$sp/$ty");
		$t_lbl="Edit";
	}
	if(empty($retrn)) $retrn=[0=>'',1=>'',2=>''];
	$swcl="<option value=''>&nbsp;</option>";
	$q_swcl=$ed->con->query("SHOW CHARACTER SET")->fetch(1);
	$pfs=['PROCEDURE','FUNCTION'];
	echo "<table><tr><th colspan='2'>$t_lbl Routine</th></tr>
	<tr><td>Name</td><td><input type='text' name='ronme' value='".$r_rou[0]."'/></td></tr>
	<tr><td>Type</td><td><select id='rou' name='roty'>";
	foreach($pfs as $pf) echo "<option value='$pf'".($pf==$r_rou[1]?" selected":"").">$pf</option>";
	echo "</select></td></tr><tr><td>Parameters</td><td>
	<table><tr><th class='rou1'>Direction</th><th>Name</th><th>Type</th><th>Values</th><th>Options</th><th></th></tr>";
	$p=1;
	$p_f1=($r_rou[1]=='PROCEDURE' ? '(\w+)\s+':'');
	while($p<=count($plist)){
	$p_curr=$plist[$p-1];
	$p_f2=(stripos($p_curr,')')?'\s*[\(](.*)[\)]':'(.*)');
	$p_f3=(stripos($p_curr,'CHARSET')?'\s+CHARSET\s+(.*)':'');
	preg_match('/'.$p_f1.'`(.*)`\s+(.*)'.$p_f2.$p_f3.'/',$p_curr,$pre);
	if(isset($r_rou[1]) && $r_rou[1]=='PROCEDURE') array_shift($pre);
	if(empty($pre)) $pre=[0=>'',1=>'',2=>'',3=>'',4=>''];
	echo "<tr id='rr_{$p}'><td class='rou1'>
		<select name='ropin[]'>";
		$inouts=['IN','OUT','INOUT'];
		foreach($inouts as $inout) echo "<option value='$inout'".($inout==trim($pre[0])?" selected":"").">$inout</option>";
		echo "</select>
		</td><td><input type='text' name='roppa[]' value='".$pre[1]."'/></td><td>
		<select id='pty_{$p}' name='ropty[]'>".$ed->fieldtypes(trim($pre[2]))."</select>
		</td><td><input type='text' name='ropva[]' value='".($pre[3]!='CHARSET'?$pre[3]:'')."'/></td><td>
		<select class='pa1' name='rop1[]'>";
		foreach($inttype as $itk=>$itt){
		echo "<option value='$itk'".(!empty($pre[4]) && trim($pre[4])==$itk?" selected":"").">$itt</option>";
		}
		echo "</select><select class='pa2' name='rop2[]'>".$swcl;
		foreach($q_swcl as $r_rocl) echo "<option value='".$r_rocl[0]."'".(!empty($pre[4]) && $pre[4]==$r_rocl[0]?" selected":"").">".$r_rocl[0]."</option>";
		echo "</select></td><td class='bb'><span onclick='plus(this)'>+</span> <span onclick=\"minus(this)\">&#150;</span></td></tr>";
	++$p;
	}
	echo "</table></td></tr><tr class='rou2 auto'><td>Return type</td><td><select id='pty2' name='rorty'>".($retrn[0]!=""?$ed->fieldtypes(strtoupper($retrn[0])):$ed->fieldtypes())."</select>
	<input type='text' name='rorva' value='".((isset($retrn[1]) && $retrn[1]!='CHARSET')?$retrn[1]:"")."'/>
	<select id='px1' name='rorop1'>";
	foreach($inttype as $itk=>$itt){
	echo "<option value='$itk'".($retrn[2]==$itt?" selected":"").">$itt</option>";
	}
	echo "</select><select id='px2' name='rorop2'>";
	foreach($q_swcl as $r_rocl){
	echo "<option value='".$r_rocl[0]."'".($retrn[2]==$r_rocl[0]?" selected":"").">".$r_rocl[0]."</option>";
	}
	echo "</select></td></tr>
	<tr><td>Definition</td><td><textarea name='rodf'>".$r_rou[4]."</textarea></td></tr>
	<tr><td>Deterministic</td><td><input type='checkbox' name='rodet'".($r_rou[5]=="NO"?"":" checked")."/></td></tr>
	<tr><td>Security type</td><td><select name='rosec'>";
	$dfns=['DEFINER','INVOKER'];
	foreach($dfns as $dfn) echo "<option value='$dfn'".($r_rou[6]==$dfn?" selected":"").">$dfn</option>";
	echo "</select></td></tr>
	<tr><td>SQL data access</td><td><select name='rosda'>";
	foreach($ed->sqlda as $sda) echo "<option value='$sda'".($r_rou[7]==$sda?" selected":"").">$sda</option>";
	echo "</select></td></tr><tr><td>Comment</td><td><textarea name='rocom'>".$r_rou[8]."</textarea></td></tr>
	<tr><td colspan='2'><button type='submit'>Save</button></td></tr></table></form>";
break;

case "43"://event
	if(!isset($ed->sg[2]) && !isset($ed->sg[3])){//add
		$ed->check([1]);
		$db=$ed->sg[1];
		$ed->priv("EVENT","5/$db");
		$r_eve=[0=>'',1=>'',2=>'',3=>'',4=>'',5=>'',7=>'',8=>'',9=>'',10=>''];
		if($ed->post('evnme','!e') && $ed->post('evstat','!e')){
			$evn=$ed->sanitize($ed->post('evnme'));
			if(is_numeric(substr($evn,0,1))) $ed->redir("43/$db",['err'=>"Not a valid name"]);
			$q_evcrt=$ed->con->query("CREATE EVENT `$evn` ON SCHEDULE ".($ed->post('evpre','i')? "AT '".$ed->post('evsta')."'":"EVERY '".$ed->post('evevr1')."' ".$ed->post('evevr2')." STARTS '".$ed->post('evsta')."' ENDS '".$ed->post('evend')."'")." ON COMPLETION".($ed->post('evpre','i')?"":" NOT")." PRESERVE ".$ed->post('evendi')." COMMENT '".$ed->post('evcom')."' DO ".$ed->post('evstat'));
			if($q_evcrt) $ed->redir("5/$db",['ok'=>"Successfully created"]);
			else $ed->redir("5/$db",['err'=>"Create event failed"]);
		}
		echo $head.$ed->menu($db,'',2).$ed->form("43/$db");
		$t_lbl="Create";
	}else{//edit
		$ed->check([1,5]);
		$db=$ed->sg[1];$sp=$ed->sg[2];$ty=$ed->sg[3];
		if($ed->post('evnme','!e') && $ed->post('evstat','!e')){
			$evn=$ed->sanitize($ed->post('evnme'));
			if(is_numeric(substr($evn,0,1))) $ed->redir("5/$db",['err'=>"Not a valid name"]);
			$q_evcrt=$ed->con->query("ALTER EVENT `$sp` ON SCHEDULE ".
			($ed->post('evone','!e') ? "AT '".$ed->post('evsta')."'":"EVERY '".$ed->post('evevr1')."' ".$ed->post('evevr2')." STARTS '".$ed->post('evsta')."' ENDS '".$ed->post('evend')."'").
			" ON COMPLETION".($ed->post('evpre','!e')?"":" NOT")." PRESERVE ".$ed->post('evendi')." COMMENT '".$ed->post('evcom')."' DO ".$ed->post('evstat'));
			if(!$q_evcrt) $ed->redir("5/$db",['err'=>"Update event failed"]);
			if($sp !=$evn){
			$q_evren=$ed->con->query("ALTER EVENT `$sp` RENAME TO $evn");
			if(!$q_evren) $ed->redir("5/$db",['err'=>"Rename event failed"]);
			}
			$ed->redir("5/$db",['ok'=>"Updated event"]);
		}
		$r_eve=$ed->con->query("SELECT EVENT_NAME,STARTS,ENDS,EVENT_TYPE,INTERVAL_VALUE,INTERVAL_FIELD,EXECUTE_AT,STATUS,EVENT_COMMENT,ON_COMPLETION,EVENT_DEFINITION FROM information_schema.EVENTS WHERE `EVENT_SCHEMA`='$db' AND `EVENT_NAME`='$sp'")->fetch();
		echo $head.$ed->menu($db,'',2,[$ty,$sp]).$ed->form("43/$db/$sp/$ty");
		$t_lbl="Edit";
	}

	echo "<table><tr><th colspan='2'>$t_lbl Event</th></tr>
	<tr><td>Name</td><td><input type='text' name='evnme' value='".$r_eve[0]."'/></td></tr>
	<tr><td>Start</td><td><input type='text' name='evsta' value='".($r_eve[3]=='ONE TIME'?$r_eve[6]:$r_eve[1])."'/></td></tr>
	<tr id='evend'><td>End</td><td><input type='text' name='evend' value='".$r_eve[2]."'/></td></tr>
	<tr><td>One time</td><td><input type='checkbox' id='one' name='evone'".($r_eve[3]=='ONE TIME'?" checked":"")."/></td></tr>
	<tr id='every'><td>Every</td><td class='auto'><input type='text' name='evevr1' size='3' value='".$r_eve[4]."'/><select name='evevr2'>";
	$evr=['YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE','WEEK','SECOND','YEAR_MONTH','DAY_HOUR','DAY_MINUTE','DAY_SECOND','HOUR_MINUTE','HOUR_SECOND','MINUTE_SECOND'];
	foreach($evr as $vr) echo "<option value='$vr'".($r_eve[5]==$vr?" selected":"").">$vr</option>";
	echo "</select></td></tr><tr><td>Status</td><td><select name='evendi'>";
	$stv=['ENABLED'=>'ENABLE','DISABLED'=>'DISABLE','SLAVESIDE_DISABLED'=>'DISABLE ON SLAVE'];
	foreach($stv as $ktv=>$tv) echo "<option value='$tv'".($r_eve[7]==$ktv?" selected":"").">$tv</option>";
	echo "</select></td></tr>
	<tr><td>Comment</td><td><input type='text' name='evcom' value='".$r_eve[8]."'/></td></tr>
	<tr><td>On completion preserve</td><td><input type='checkbox' name='evpre'".($r_eve[9]=='PRESERVE'?' checked':'')."/></td></tr>
	<tr><td>Statement</td><td><textarea name='evstat'>".$r_eve[10]."</textarea></td></tr>
	<tr><td colspan='2'><button type='submit'>Save</button></td></tr></table></form>";
break;

case "48"://execute
	$ed->check([1,5]);
	$db=$ed->sg[1];$sp=$ed->sg[2];$ty=$ed->sg[3];
	$ed->priv("EXECUTE","5/$db");
	echo $head.$ed->menu($db,'',1,[$ty,$sp]).$ed->form("48/$db/$sp/$ty");
	$q_plist=$ed->con->query("SHOW CREATE $ty `$db`.`$sp`")->fetch();
	preg_match('#\((([^()]*|(?R))*)\)#',$q_plist[2],$r_plist);
	$plist=preg_split("/\(.*?\)(*SKIP)(*F)|,/",$r_plist[1]);
	echo "<table><tr><th colspan='2'>Execute Routine</th></tr>";
	$fi=[];$out='';$i=0;
	foreach($plist as $lst){
	preg_match('/(.*)`(.*?)`/',$lst,$ls);
	if(!empty($ls)){
	$rr="<tr><td>".$ls[2]."</td><td><input type='text' name='".$ls[2]."'/></td></tr>";
	if($ty=='procedure' && trim($ls[1])=='IN'){
	$fi[]=$ls[2];echo $rr;
	}elseif($ty=='procedure' && trim($ls[1])=='OUT'){
	$out.="@'".$ls[2]."',"; ++$i;
	}elseif($ty=='function'){
	$fi[]=$ls[2];echo $rr;
	}
	}
	}
	echo "<tr><td colspan='2'><button type='submit' name='run'>Call</button></td></tr></table></form>";
	if($ed->post('run','i')){
	echo "<table><tr><th colspan='2'>Executed `$sp`</th></tr>";
	$re='';
	foreach($fi as $f) $re.="'".$ed->post($f)."',";
	$re=substr($re,0,-1);
	$out=substr($out,0,-1);
	if($ty=='function'){
		$q_ex=$ed->con->query("SELECT `$sp`".(empty($fi)?"":"($re)"));
		if($q_ex){
		$q_ex=$q_ex->fetch();
		echo "<tr><td><input type='text' value='".$q_ex[0]."'/></td></tr>";
		}
	}elseif($ty=='procedure'){
		$c="";
		if($re!='' && $out!='') $c="($re,$out)";
		elseif($re!='') $c="($re)";
		elseif($out!='') $c="($out)";
		$ed->con->query("CALL `$sp`".$c);
		if($out!=''){
		$q_ex=$ed->con->query("SELECT $out")->fetch();
		$j=0;
		while($j<$i){
		echo "<tr><td><input type='text' value='".$q_ex[$j]."'/></td></tr>";
		++$j;
		}
		}
	}
	echo "</table>";
	}
break;

case "49"://drop sp
	$ed->check([1,5]);
	$q_drosp=$ed->con->query("DROP ".$ed->sg[3]." `".$ed->sg[1]."`.`".$ed->sg[2]."`");
	if($q_drosp) $ed->redir("5/".$ed->sg[1],['ok'=>"Successfully dropped"]);
break;

case "50"://login
	if($ed->post('lhost','!e') && $ed->post('username','!e') && $ed->post('password','i')){
	$_SESSION['user']=$ed->post('username');
	$_SESSION['host']=$ed->post('lhost');
	$_SESSION['token']=$ed->enco($ed->post('password'));
	$ed->redir();
	}
	session_unset();
	session_destroy();
	echo $head.$ed->menu('','',2).$ed->form("50")."<div class='dw'><h3>LOGIN</h3>
	<div>Host<br/><input type='text' id='host' name='lhost' value='localhost'/></div>
	<div>Username<br/><input type='text' name='username' value='root'/></div>
	<div>Password<br/><input type='password' name='password'/></div>
	<div><button type='submit'>Login</button></div></div></form>";
break;

case "51"://logout
	session_unset();
	session_destroy();
	$ed->redir();
break;

case "52"://users
	$ed->check();
	echo $head.$ed->menu(1,'',2)."<table><tr><th>User</th><th>Host</th><th><a href='{$ed->path}53'>Add</a></th></tr>";
	$q_usr=$ed->con->query("SELECT DISTINCT GRANTEE FROM information_schema.USER_PRIVILEGES ORDER BY GRANTEE")->fetch(1);
	foreach($q_usr as $r_usr){
	$bg=($bg==1)?2:1;
	preg_match("/'(.*)'@'(.*)'/",$r_usr[0],$r_us);
	echo "<tr class='r c$bg'><td>".$r_us[1]."</td><td>".$r_us[2]."</td><td><a class='del' href='{$ed->path}59/".$r_us[1]."/".base64_encode($r_us[2])."'>Drop</a><a href='{$ed->path}53/".$r_us[1]."/".base64_encode($r_us[2])."'>Edit</a></td></tr>";
	}
	echo "</table>";
break;

case "53"://add,edit,update user
	$ed->check();
	$ed->priv("CREATE USER","52");
	if(empty($ed->sg[2])){
	$hh=(empty($ed->sg[1])?"":base64_decode($ed->sg[1])); $uu='';
	}else{
	$hh=(empty($ed->sg[2])?"":base64_decode($ed->sg[2])); $uu=$ed->sg[1];
	}
	$hh2=base64_encode($hh);
	if($ed->post('savepri','i') || $ed->post('savepric','i')){
	if(empty($hh)){
		if($ed->post('username','i') && $ed->post('host','!e')){
		$uu=$ed->sanitize($ed->post('username'));
		$hh=$ed->post('host');
		$passwd=($ed->post('password','e') ? "":" IDENTIFIED BY '".$ed->post('password')."'");
		$q_exist=$ed->con->query("SELECT EXISTS(SELECT 1 FROM information_schema.USER_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\'');")->fetch();
		if($q_exist[0]) $ed->redir("52",['err'=>"Username already exist"]);
		$ed->con->query("CREATE USER '$uu'@'$hh'".$passwd);
		}
	}else{
		$ed->check([6]);
		$ed->con->query("REVOKE ALL PRIVILEGES ON *.* FROM '$uu'@'$hh'");
		$ed->con->query("REVOKE GRANT OPTION ON *.* FROM '$uu'@'$hh'");
	}
	$priall=($ed->post('priall','e')?"":$ed->post('priall'));
	$prialls=($ed->post('prialls','e')?"":$ed->post('prialls'));
	$grant=($ed->post('agrant','!e')?" GRANT OPTION":"");
	$max1=($ed->post('MAX_QUERIES_PER_HOUR','e')?0:$ed->post('MAX_QUERIES_PER_HOUR'));
	$max2=($ed->post('MAX_UPDATES_PER_HOUR','e')?0:$ed->post('MAX_UPDATES_PER_HOUR'));
	$max3=($ed->post('MAX_CONNECTIONS_PER_HOUR','e')?0:$ed->post('MAX_CONNECTIONS_PER_HOUR'));
	$max4=($ed->post('MAX_USER_CONNECTIONS','e')?0:$ed->post('MAX_USER_CONNECTIONS'));
	$with=" WITH{$grant} MAX_QUERIES_PER_HOUR $max1 MAX_UPDATES_PER_HOUR $max2 MAX_CONNECTIONS_PER_HOUR $max3 MAX_USER_CONNECTIONS $max4";
	$passwd=($ed->post('password','e') ? "":" IDENTIFIED BY '".$ed->post('password')."'");
	if($priall=='on') $prs="ALL PRIVILEGES";
	if($priall !='on' && !empty($prialls)) $prs=implode(",",$prialls);
	if(!empty($prs)) $ed->con->query("GRANT $prs ON *.* TO '$uu'@'$hh'".$passwd.$with);
	if(empty($prs)) $ed->con->query("GRANT USAGE ON *.* TO '$uu'@'$hh'".$passwd.$with);
	if($ed->post('password','!e')){
	$ed->con->query("SET PASSWORD FOR '$uu'@'$hh'=PASSWORD('".$ed->post('password')."')");
	}
	if($ed->post('host','!e') || $ed->post('username','!e')){
	$comma=(($ed->post('host','e') && $ed->post('username','e'))?"":",");
	$ed->con->query("UPDATE mysql.user SET ".($ed->post('host','e')?"":"host='".$ed->post('host')."'").$comma.($ed->post('username','e')?"":"user='".$ed->post('username')."'")." WHERE host='$hh' AND user='$uu'");
	}
	$ed->con->query("FLUSH PRIVILEGES");
	$ed->con->query("FLUSH USER_RESOURCES");
	if($ed->post('savepric','i')) $ed->redir("53/".$ed->post('username')."/".base64_encode($ed->post('host')));
	$ed->redir("52",["ok"=>"Added user / privileges"]);
	}
	//revoke db
	if($ed->post('rvkdb','!e')){
	$ed->con->query("REVOKE ALL PRIVILEGES ON `".$ed->post('rvkdb')."`.* FROM '$uu'@'$hh'");
	$ed->con->query("REVOKE GRANT OPTION ON `".$ed->post('rvkdb')."`.* FROM '$uu'@'$hh'");
	$ed->con->query("FLUSH PRIVILEGES");
	$ed->con->query("FLUSH USER_RESOURCES");
	$ed->redir("53/$uu/$hh2");
	}
	//global priv
	$q_pri=$ed->con->query("SELECT PRIVILEGE_TYPE,IS_GRANTABLE FROM information_schema.USER_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\''")->fetch(1);
	$a_pri=[];
	if($q_pri){
	$a_gr=$q_pri[0][1];
	if($q_pri[0][0]!="USAGE") foreach($q_pri as $r_pri) $a_pri[]=$r_pri[0];
	}else $a_gr='';
	//dbs priv
	$q_dbpri=$ed->con->query("SELECT TABLE_SCHEMA,PRIVILEGE_TYPE,IS_GRANTABLE FROM information_schema.SCHEMA_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\'' ORDER BY TABLE_SCHEMA")->fetch(1);
	$db_pri=[];
	if($q_dbpri){
	foreach($q_dbpri as $r_dbpri) $db_pri[$r_dbpri[0]][$r_dbpri[1]]=$r_dbpri[2];
	}
	//usage
	$q_tbpri=$ed->con->query("SELECT DISTINCT TABLE_SCHEMA FROM information_schema.TABLE_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\'' UNION
	SELECT DISTINCT TABLE_SCHEMA FROM information_schema.COLUMN_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\''")->fetch(1);
	if($q_tbpri){
	foreach($q_tbpri as $ke=>$r_tbpri) $db_pri[$r_tbpri[0]]['USAGE']='NO';
	}
	//max
	if(!empty($hh)){
	$mx=$ed->con->query("SELECT max_questions,max_updates,max_connections,max_user_connections FROM mysql.user WHERE `User`='$uu' AND `Host`='$hh'");
	if($mx) $mx=$mx->fetch();
	}
	$mx1=(empty($mx[0])?0:$mx[0]);$mx2=(empty($mx[1])?0:$mx[1]);$mx3=(empty($mx[2])?0:$mx[2]);$mx4=(empty($mx[3])?0:$mx[3]);
	//form
	$q_prs=$ed->con->query("SHOW PRIVILEGES")->fetch(1);
	echo $head.$ed->menu(1,'',2).$ed->form("53/$uu/$hh2")."<table><tr><th colspan='2'>User Privileges</th></tr>
	<tr><td>Host </td><td><input type='text' name='host' value='$hh'/></td></tr>
	<tr><td>Name </td><td><input type='text' name='username' value='$uu'/></td></tr>
	<tr><td>Password </td><td><input type='password' name='password'/></td></tr>";
	echo "<tr><td>Global Privileges</td><td><input type='checkbox' name='priall' onclick='toggle(this,\"prialls[]\")'/> All privileges</td></tr>
	<tr><td></td><td class='c1'><ul class='upr'>";
	foreach($q_prs as $r_prs){
	if($r_prs[0]!='Grant option' && $r_prs[0]!='Usage' && $r_prs[0]!='Proxy')
	echo "<li><input type='checkbox' name='prialls[]' value='".$r_prs[0]."'".(in_array(strtoupper($r_prs[0]),$a_pri)? " checked":"")."/> ".$r_prs[0]."</li>";
	}
	echo "</ul></td></tr>
	<tr><td>Options</td><td><input type='checkbox' name='agrant' value='GRANT OPTION'".($a_gr=="YES" ? " checked":"")."/> Grant Option</td></tr>
	<tr><td>Max queries/hour</td><td><input type='text' name='MAX_QUERIES_PER_HOUR' value='$mx1'/></td></tr>
	<tr><td>Max updates/hour</td><td><input type='text' name='MAX_UPDATES_PER_HOUR' value='$mx2'/></td></tr>
	<tr><td>Max connections/hour</td><td><input type='text' name='MAX_CONNECTIONS_PER_HOUR' value='$mx3'/></td></tr>
	<tr><td>Max user connections</td><td><input type='text' name='MAX_USER_CONNECTIONS' value='$mx4'/></td></tr>
	<tr><td class='c1'><button type='submit' name='savepri'>Save</button></td><td class='c1'><button type='submit' name='savepric'>Save &amp; Continue</button></td></tr></table></form>";
	if(!empty($hh)){
	echo "<table><tr><td class='c1'>Select DB<br/>".$ed->form("54/$uu/$hh2")."<select name='dbn'><option value=''>--select--</option>";
	foreach($ed->u_db as $r_dbs){
	$r_dbs0=$r_dbs[0];
	if(!in_array($r_dbs0,$deny)){
	echo "<option value='$r_dbs0'>$r_dbs0</option>";
	}
	}
	echo "</select><br/><button type='submit' name='adddbpri'>Add</button></form></td></tr>";
	if(!empty($db_pri)){
	foreach($db_pri as $k=>$_pri){
	$gr=array_values(array_unique($_pri));
	echo "<tr><td class='auto'>".$ed->form("53/$uu/$hh2")."<input type='hidden' name='rvkdb' value='$k'/><button type='submit'>Revoke</button></form>
	<b>$k</b>".($gr[0]=="YES"?" [GRANT]":"")."<br/>".(count($_pri)>=18?"ALL PRIVILEGES":implode(" ",array_keys($_pri)))."</td></tr>";
	}
	}
	}
	echo "</table>";
break;

case "54"://db priv
	$ed->check([6]);
	$ed->priv("CREATE USER","52");
	if(empty($ed->sg[2])){
	$hh=base64_decode($ed->sg[1]); $uu='';
	}else{
	$hh=base64_decode($ed->sg[2]); $uu=$ed->sg[1];
	}
	$hh2=base64_encode($hh);
	if($ed->post('dbn','e') && empty($_SESSION['_dbn'])) $ed->redir("53/$uu/$hh2",['err'=>"DB not exist"]);
	elseif($ed->post('dbn','!e')) $dbn=$_SESSION['_dbn']=$ed->post('dbn');
	else $dbn=$_SESSION['_dbn'];
	if($ed->post('savedb','i') || $ed->post('savedbc','i')){
		$ed->con->query("REVOKE ALL PRIVILEGES ON `$dbn`.* FROM '$uu'@'$hh'");
		$ed->con->query("REVOKE GRANT OPTION ON `$dbn`.* FROM '$uu'@'$hh'");
		$ed->con->query("DELETE FROM mysql.db WHERE `User`='$uu' AND `Host`='$hh' AND `Db`='$dbn'");
		$ed->con->query("GRANT ".($ed->post("pridbs","!e")?implode(", ",$ed->post("pridbs")):"")." ON `$dbn`.* TO '$uu'@'$hh'".($ed->post('dbgrant','!e')?" WITH GRANT OPTION":""));
		$ed->con->query("FLUSH PRIVILEGES");
		$ed->con->query("FLUSH USER_RESOURCES");
		if($ed->post('savedbc','i')) $ed->redir("54/$uu/$hh2");
		$ed->redir("53/$uu/$hh2",['ok'=>"Added DB privileges"]);
	}
	//revoke tb
	if($ed->post('rvktb','!e')){
	$ed->con->query("REVOKE ALL PRIVILEGES ON `$dbn`.`".$ed->post('rvktb')."` FROM '$uu'@'$hh'");
	$ed->con->query("REVOKE GRANT OPTION ON `$dbn`.`".$ed->post('rvktb')."` FROM '$uu'@'$hh'");
	$ed->con->query("FLUSH PRIVILEGES");
	$ed->con->query("FLUSH USER_RESOURCES");
	$ed->redir("54/$uu/$hh2");
	}
	//db priv
	$q_dbpri=$ed->con->query("SELECT PRIVILEGE_TYPE,IS_GRANTABLE FROM information_schema.SCHEMA_PRIVILEGES WHERE `GRANTEE`='\'$uu\'@\'$hh\'' AND TABLE_SCHEMA='$dbn' ORDER BY TABLE_SCHEMA")->fetch(1);
	$db_pri=[];$dbgr='';
	if($q_dbpri){
	$dbgr=$q_dbpri[0][1];
	foreach($q_dbpri as $r_dbpri) $db_pri[]=$r_dbpri[0];
	}
	//tb priv
	$slct="SELECT TABLE_NAME,PRIVILEGE_TYPE,IS_GRANTABLE FROM";
	$wher="WHERE `TABLE_SCHEMA`='$dbn' AND `GRANTEE`='\'$uu\'@\'$hh\''";
	$q_tbpri=$ed->con->query($slct." information_schema.TABLE_PRIVILEGES $wher UNION $slct information_schema.COLUMN_PRIVILEGES ".$wher." ORDER BY PRIVILEGE_TYPE")->fetch(1);
	$tbpri=[];
	if($q_tbpri){
	foreach($q_tbpri as $r_tbpri) $tbpri[$r_tbpri[0]][$r_tbpri[1]]=$r_tbpri[2];
	}

	$q_db=call_user_func_array('array_merge',$ed->u_db);
	if(!in_array($dbn,$q_db)) $ed->redir("52",['err'=>"DB not exist"]);
	$q_tb=$ed->con->query("SHOW TABLES FROM `$dbn`")->fetch(1);
	$q_prs=$ed->con->query("SHOW PRIVILEGES")->fetch(1);
	echo $head.$ed->menu(1,'',2).$ed->form("54/$uu/$hh2").
	"<table><tr><th colspan='2'>Database Privileges</th></tr>
	<tr><td>Selected DB</td><td><select name='dbs'><option value='$dbn'>$dbn</option></select></td></tr>
	<tr><td>DB Privileges</td><td><input type='checkbox' onclick='toggle(this,\"pridbs[]\")'/> All privileges</td></tr>
	<tr><td></td><td class='c1'><ul class='upr'>";
	foreach($q_prs as $r_prs){
	if($r_prs[0]=='Event' || stripos($r_prs[1],'Server')===false && $r_prs[0]!='Grant option' && $r_prs[0]!='Usage' && $r_prs[0]!='Proxy')
	echo "<li><input type='checkbox' name='pridbs[]' value='".$r_prs[0]."'".(in_array(strtoupper($r_prs[0]),$db_pri)?" checked":"")."/> ".$r_prs[0]."</li>";
	}
	echo "</ul></td></tr>
	<tr><td>DB Options</td><td><input type='checkbox' name='dbgrant' value='GRANT OPTION'".($dbgr=="YES"?" checked":"")."/> Grant Option</td></tr>
	<tr><td class='c1'><button type='submit' name='savedb'>Save</button></td><td class='c1'><button type='submit' name='savedbc'>Save &amp; Continue</button></td></tr></table></form>";

	echo "<table><tr><td class='c1'>Select Table<br/>".$ed->form("55/$uu/$hh2").
	"<input type='hidden' name='dbn' value='$dbn'/><select name='tbn'><option value=''>--select--</option>";
	foreach($q_tb as $r_tb){
	echo "<option value='".$r_tb[0]."'>".$r_tb[0]."</option>";
	}
	echo "</select><br/><button type='submit' name='addtbpri'>Add</button></form></td></tr>";
	if(!empty($tbpri)){
	foreach($tbpri as $k=>$_tpr){
	$gr=array_values(array_unique($_tpr));
	echo "<tr><td class='auto'>".$ed->form("54/$uu/$hh2")."<input type='hidden' name='rvktb' value='$k'/><button type='submit'>Revoke</button></form> <b>$k</b>".($gr[0]=="YES"?" [GRANT]":"")."<br/>".(count($_tpr)>=12?"ALL PRIVILEGES":implode(" ",array_keys($_tpr)))."</td></tr>";
	}
	}
	echo "</table>";
break;

case "55"://tb priv
	$ed->check([6]);
	$ed->priv("CREATE USER","52");
	if(empty($ed->sg[2])){
	$hh=base64_decode($ed->sg[1]); $uu='';
	}else{
	$hh=base64_decode($ed->sg[2]); $uu=$ed->sg[1];
	}
	$hh2=base64_encode($hh);
	if($ed->post('dbn','e') && empty($_SESSION['_dbn'])) $ed->redir("53/$uu/$hh2",['err'=>"DB not exist"]);
	elseif($ed->post('dbn','!e')) $dbn=$_SESSION['_dbn']=$ed->post('dbn');
	else $dbn=$_SESSION['_dbn'];
	$q_db=call_user_func_array('array_merge',$ed->u_db);
	if(!in_array($dbn,$q_db)) $ed->redir("53/$uu/$hh2",['err'=>"DB not exist"]);
	if($ed->post('tbn','e')) $ed->redir("54/$uu/$hh2",['err'=>"Table not exist"]);
	$tbn=$ed->post('tbn');
	if($ed->post("savetb","i")){
		$ed->con->query("REVOKE ALL PRIVILEGES ON `$dbn`.`$tbn` FROM '$uu'@'$hh'");
		$ed->con->query("REVOKE GRANT OPTION ON `$dbn`.`$tbn` FROM '$uu'@'$hh'");
		$ed->con->query("DELETE FROM mysql.tables_priv WHERE `User`='$uu' AND `Host`='$hh' AND `Db`='$dbn' AND `Table_name`='$tbn'");
		$ed->con->query("DELETE FROM mysql.columns_priv WHERE `User`='$uu' AND `Host`='$hh' AND `Db`='$dbn' AND `Table_name`='$tbn'");
		$f1=($ed->post('fi1','!e')?" SELECT(`".implode("`,`",$ed->post('fi1'))."`),":"");
		$f2=($ed->post('fi2','!e')?" INSERT(`".implode("`,`",$ed->post('fi2'))."`),":"");
		$f3=($ed->post('fi3','!e')?" UPDATE(`".implode("`,`",$ed->post('fi3'))."`),":"");
		$f4=($ed->post('fi4','!e')?" REFERENCES(`".implode("`,`",$ed->post('fi4'))."`),":"");
		$f5=($ed->post('tbpr','!e')?" ".implode(",",$ed->post('tbpr')).",":"");
		$ed->con->query("GRANT".substr($f1.$f2.$f3.$f4.$f5,0,-1)." ON `$dbn`.`$tbn` TO '$uu'@'$hh'".($ed->post('tbgr','!e')?" WITH GRANT OPTION":""));
		$ed->con->query("FLUSH PRIVILEGES");
		$ed->con->query("FLUSH USER_RESOURCES");
		$ed->redir("54/$uu/$hh2",['ok'=>"Added Table privileges"]);
	}
	$tblistpr=['ALTER','CREATE','DELETE','DROP','INDEX','CREATE VIEW','SHOW VIEW','TRIGGER'];
	$q_fi=$ed->con->query("SHOW COLUMNS FROM `$dbn`.`$tbn`")->fetch(2);
	//tb priv
	$q_tbpr=$ed->con->query("SELECT PRIVILEGE_TYPE,IS_GRANTABLE FROM information_schema.TABLE_PRIVILEGES WHERE `TABLE_SCHEMA`='$dbn' AND `TABLE_NAME`='$tbn' AND `GRANTEE`='\'$uu\'@\'$hh\''")->fetch(1);
	$r_tpr=[];$gr=[0=>''];
	if($q_tbpr){
	foreach($q_tbpr as $r_tbpr) $r_tpr[$r_tbpr[0]]=$r_tbpr[1];
	$gr=array_values(array_unique($r_tpr));
	}
	//col priv
	$q_colpr=$ed->con->query("SELECT PRIVILEGE_TYPE,COLUMN_NAME,IS_GRANTABLE FROM information_schema.COLUMN_PRIVILEGES WHERE `TABLE_SCHEMA`='$dbn' AND `TABLE_NAME`='$tbn' AND `GRANTEE`='\'$uu\'@\'$hh\''")->fetch(1);
	$r_cpr=[];$gr2='';
	if($q_colpr){
	foreach($q_colpr as $r_colpr) $r_cpr[$r_colpr[0]][$r_colpr[1]]=$r_colpr[2];
	$gr2=$q_colpr[0][2];
	}

	echo $head.$ed->menu(1,'',2).$ed->form("55/$uu/$hh2").
	"<input type='hidden' name='tbn' value='$tbn'/><table><tr><th colspan='5'>Table Privileges</th></tr>
	<tr><td class='c1'>SELECT</td><td class='c1'>INSERT</td><td class='c1'>UPDATE</td><td class='c1'>REFERENCES</td>
	<td class='c1'><input type='checkbox' name='tbgr'".(($gr[0]=="YES" || $gr2=="YES")?" checked":"")."/> GRANT</td></tr>
	<tr><td><input type='checkbox' onclick='selectall(this,\"fi1\")'/> All/None<br/>
	<select id='fi1' name='fi1[]' multiple='multiple'>";
	foreach($q_fi as $r_fi) echo "<option value='".$r_fi['Field']."'".(isset($r_cpr['SELECT']) && in_array($r_fi['Field'],array_keys($r_cpr['SELECT']))?" selected":"").">".$r_fi['Field']."</option>";
	echo "</select></td>
	<td><input type='checkbox' onclick='selectall(this,\"fi2\")'/> All/None<br/>
	<select id='fi2' name='fi2[]' multiple='multiple'>";
	foreach($q_fi as $r_fi) echo "<option value='".$r_fi['Field']."'".(isset($r_cpr['INSERT']) && in_array($r_fi['Field'],array_keys($r_cpr['INSERT']))?" selected":"").">".$r_fi['Field']."</option>";
	echo "</select></td>
	<td><input type='checkbox' onclick='selectall(this,\"fi3\")'/> All/None<br/>
	<select id='fi3' name='fi3[]' multiple='multiple'>";
	foreach($q_fi as $r_fi) echo "<option value='".$r_fi['Field']."'".(isset($r_cpr['UPDATE']) && in_array($r_fi['Field'],array_keys($r_cpr['UPDATE']))?" selected":"").">".$r_fi['Field']."</option>";
	echo "</select></td>
	<td><input type='checkbox' onclick='selectall(this,\"fi4\")'/> All/None<br/>
	<select id='fi4' name='fi4[]' multiple='multiple'>";
	foreach($q_fi as $r_fi) echo "<option value='".$r_fi['Field']."'".(isset($r_cpr['REFERENCES']) && in_array($r_fi['Field'],array_keys($r_cpr['REFERENCES']))?" selected":"").">".$r_fi['Field']."</option>";
	echo "</select></td><td>";
	foreach($tblistpr as $tblpr){
	echo "<input type='checkbox' name='tbpr[]' value='$tblpr'".(in_array($tblpr,array_keys($r_tpr))?" checked":"")."/> $tblpr<br/>";
	}
	echo "</td></tr><tr><td colspan='5'><button type='submit' name='savetb'>Save</button></td></tr></table></form>";
break;

case "59"://drop user
	$ed->check([6]);
	$ed->priv("CREATE USER","52");
	if(empty($ed->sg[2])){
	$hh=base64_decode($ed->sg[1]); $uu='';
	}else{
	$hh=base64_decode($ed->sg[2]); $uu=$ed->sg[1];
	}
	$ed->con->query("REVOKE ALL PRIVILEGES ON *.* FROM '$uu'@'$hh'");
	$ed->con->query("REVOKE GRANT OPTION ON *.* FROM '$uu'@'$hh'");
	$ed->con->query("DELETE FROM mysql.db WHERE `User`='$uu' AND `Host`='$hh'");
	$ed->con->query("DELETE FROM mysql.tables_priv WHERE `User`='$uu' AND `Host`='$hh'");
	$ed->con->query("DELETE FROM mysql.columns_priv WHERE `User`='$uu' AND `Host`='$hh'");
	$ed->con->query("DROP USER '$uu'@'$hh'");
	$ed->con->query("FLUSH PRIVILEGES");
	$ed->redir("52",['ok'=>"Successfully deleted"]);
break;

case "60"://info
	$ed->check();
	echo $head.$ed->menu(1,'',2)."<table>";
	if(empty($ed->sg[1])){
		$use=(extension_loaded('mysqli')?'mysqli':'pdo_mysql');
		echo "<tr><th colspan='2'>INFO</th></tr>";
		$q_var=['Extension'=>$use,'DB'=>$ed->con->query('select version()')->fetch()[0],'Php'=>PHP_VERSION,'Software'=>$_SERVER['SERVER_SOFTWARE']];
		foreach($q_var as $r_k=>$r_var){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg'><td>$r_k</td><td>$r_var</td></tr>";
		}
	}elseif($ed->sg[1]=='var'){
		echo "<tr><th>Variable</th><th>Value</th></tr>";
		$q_var=$ed->con->query("SHOW VARIABLES")->fetch(1);
		foreach($q_var as $r_var){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg'><td>".$r_var[0]."</td><td>".htmlspecialchars($r_var[1])."</td></tr>";
		}
	}elseif($ed->sg[1]=='status'){
		echo "<tr><th>Variable</th><th>Value</th></tr>";
		$q_sts=$ed->con->query("SHOW STATUS")->fetch(1);
		foreach($q_sts as $r_sts){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg'><td>".$r_sts[0]."</td><td>".$r_sts[1]."</td></tr>";
		}
	}elseif($ed->sg[1]=='process'){
		if($ed->post('killp','i')) $ed->con->query("KILL ".$ed->post('pid'));
		$q_prs=$ed->con->query("SHOW FULL PROCESSLIST")->fetch(2);
		$kys=array_keys($q_prs[0]);
		echo "<tr><th>&nbsp;</th>";
		foreach($kys as $ky) echo "<th>$ky</th>";
		echo "</tr>";
		foreach($q_prs as $r_prs){
		$bg=($bg==1)?2:1;
		echo "<tr class='r c$bg'><td>".$ed->form("60/process")."<input type='hidden' name='pid' value='".$r_prs['Id']."'/><button type='submit' name='killp'>Kill</button></form></td>";
		foreach($kys as $ky) echo "<td>".$r_prs[$ky]."</td>";
		echo "</tr>";
		}
	}
	echo "</table>";
break;
}
unset($_POST,$_SESSION["ok"],$_SESSION["err"]);
?></div></div><div class="l1 ce"><a href="http://edmondsql.github.io">edmondsql</a></div>
<script>
const $=(s)=>document.querySelector(s);
const $$=(s)=>document.querySelectorAll(s);
const $n=(s)=>document.getElementsByName(s);
const $cn=(s)=>document.getElementsByClassName(s);
const $c=(s)=>document.createElement(s);
Element.prototype.show=function(ty=null){this.style.display=(ty=='b')?'inline-block':'';}
Element.prototype.hide=function(){this.style.display='none';}
HTMLCollection.prototype.showAll=function(){
for(let i=0; i < this.length;i++){
this[i].style.display='';
}
};
HTMLCollection.prototype.hideAll=function(){
for(let i=0; i < this.length;i++){
this[i].style.display='none';
}
};
const host=$("#host");
if(host)host.focus();

let msg=$$(".msg");
$$(".del").forEach(d=>{
d.addEventListener('click',(e)=>{
e.preventDefault();
msg.forEach(m=>m.remove());
let hrf=e.target.getAttribute("href"),nMsg=$c("div"),nOk=$c("div"),nEr=$c("div");
nMsg.className='msg';
nOk.className='ok';nOk.innerText='Yes';
nEr.className='err';nEr.innerText='No';
nMsg.appendChild(nOk);nMsg.lastChild.onclick=()=>window.location=hrf;
nMsg.appendChild(nEr);nMsg.lastChild.onclick=()=>nMsg.remove();
document.body.appendChild(nMsg);
document.body.addEventListener('keyup',(e)=>{
e.preventDefault();
let key=e.which||e.keyCode||e.key||0;
if(key==32||key==89)window.location=hrf;
if(key==27||key==78)nMsg.remove();
});
});
});
msg.forEach(m=>{if(m.innerText!="")setTimeout(()=>{m.remove()},7000);m.addEventListener('dblclick',()=>m.remove())});

if($('#one')){
if($('#one').checked==true){$('#every').hide();$('#evend').hide()}else{$('#every').show();$('#evend').show()}
$("#one").addEventListener("click",function(){if($('#one').checked==true){$('#every').hide();$('#evend').hide()}else{$('#every').show();$('#evend').show()}});//add event
}
if($("#rou")){
if($("#rou").value=="FUNCTION"){$cn("rou1").hideAll();$cn("rou2").showAll();}else{$cn("rou1").showAll();$cn("rou2").hideAll();}
$("#rou").addEventListener("change",function(){//routine
if(this.value=="FUNCTION"){$cn("rou1").hideAll();$cn("rou2").showAll();}else{$cn("rou1").showAll();$cn("rou2").hideAll();}
});
}
//param rows
let a,i,rou_p=$$('[id^="pty_"]').length;
for(i=1;i <=rou_p;i++) routine(i);
//priv all
for(a=1;a<5;a++){
if($("#fi"+a)){
let fc=$("#fi"+a).options.length,fs=($("#fi"+a).selectedOptions||'').length;
if(fc==fs) $("#fi"+a).parentNode.querySelector("[type=checkbox]").checked=true;
}
}
function minus(el){//routine remove row
let crr=$$('[id^="rr_"]').length;
if(crr>1) el.closest("tr").remove();
}
function plus(el){//routine clone row
let cid=el.closest("tr").getAttribute("id"),cnt=$$('[id^="rr_"]').length + 1;
let cl=$('#'+cid).cloneNode(true);$('#'+cid).after(cl);cl.setAttribute("id","rr_"+cnt);
$("#rr_"+cnt).querySelector('[id^="pty_"]').setAttribute("id","pty_"+cnt);
$$('[id^="rr_"]').forEach(function(t,i){t.setAttribute("id","rr_"+(i+1));});
$$('[id^="pty_"]').forEach(function(t,i){t.setAttribute("id","pty_"+(i+1));});
routine(cnt);
}
function routine(id){
const ar1=["INT","TINYINT","SMALLINT","MEDIUMINT","BIGINT","DOUBLE","DECIMAL","FLOAT"],ar2=["VARCHAR","CHAR","TEXT","TINYTEXT","MEDIUMTEXT","LONGTEXT"];
//function returns
let ej=$("#pty2"),ej1=$("#px1"),ej2=$("#px2");
function routin2(){
if(ar1.includes(ej.value)){ej1.show('b');ej2.hide();}else if(ar2.includes(ej.value)){ej1.hide();ej2.show('b');}else{ej1.hide();ej2.hide();}
}
routin2();
ej.addEventListener("change",function(){routin2();});
//options
function routin1(ix){
let el=$("#pty_"+ix)?$("#pty_"+ix).value:'',el1=$("#rr_"+ix+" .pa1"),el2=$("#rr_"+ix+" .pa2");
if(ar1.includes(el)){el1.show('b');el2.hide();}else if(ar2.includes(el)){el1.hide();el2.show('b');}else{el1.hide();el2.hide();}
}
if(id===undefined) id=0;
routin1(id);
$("#pty_"+id).addEventListener("change",function(){routin1(id);});
}

(function(){
let draggedItem=null,tbody=$('.sort');
function handleDragStart(e){
if(!e.target.classList.contains('handle')){
e.preventDefault();
return;
}
draggedItem=e.target.closest('tr');
setTimeout(()=>{draggedItem.classList.add('dragging');},0);
e.dataTransfer.effectAllowed='move';
e.dataTransfer.setData('text/plain','');
}
function handleDragOver(e){
e.preventDefault();
const targetRow=e.target.closest('tr');
if(targetRow && targetRow !== draggedItem && !targetRow.classList.contains('dragging')){
const rect=targetRow.getBoundingClientRect();
const next=(e.clientY - rect.top)/(rect.bottom - rect.top) > 0.5;
if(next){
targetRow.parentNode.insertBefore(draggedItem,targetRow.nextSibling);
}else{
targetRow.parentNode.insertBefore(draggedItem,targetRow);
}
Array.from(targetRow.parentNode.children).forEach(child=>child.classList.remove('drag-over'));
targetRow.classList.add('drag-over');
}
}
function handleDragEnd(e){
if(draggedItem){
draggedItem.classList.remove('dragging');
Array.from(draggedItem.parentNode.children).forEach(child=>child.classList.remove('drag-over'));
}
const xhr=new window.XMLHttpRequest();
xhr.open("POST","<?=$ed->path.'9/'.(empty($ed->sg[1])?'':$ed->sg[1].'/').(empty($ed->sg[2])?'':$ed->sg[2])?>");
xhr.setRequestHeader("Content-type","application/x-www-form-urlencoded");
xhr.onload=function(){
(xhr.readyState == 4 && xhr.status == 200) ? location.reload():alert('Error: '+xhr.status);
}
pre="x";
if(draggedItem.previousElementSibling && draggedItem.previousElementSibling.nodeName=="TR") pre=draggedItem.previousElementSibling.getAttribute("id");
xhr.send("n1="+draggedItem.getAttribute("id")+"&n2="+pre);
draggedItem=null;
}
function addDragAndDrop(){
if(!tbody) return;
tbody.addEventListener('dragstart',handleDragStart);
tbody.addEventListener('dragover',handleDragOver);
tbody.addEventListener('dragleave',(e)=>{
const targetRow=e.target.closest('tr');
if(targetRow)targetRow.classList.remove('drag-over');
});
tbody.addEventListener('drop',handleDragEnd);
tbody.addEventListener('dragend',handleDragEnd);
}
addDragAndDrop();
})();
function selectall(cb,lb){
let i,multi=$('#'+lb);
if(cb.checked){for(i=0;i<multi.options.length;i++) multi.options[i].selected=true;
}else{multi.selectedIndex=-1;}
}
function toggle(cb,el){
let i,cbox=$n(el);
for(i=0;i<cbox.length;i++) cbox[i].checked=cb.checked;
}
function fmt(){
let j,opt=$n("fopt[]"),ff=$n("ffmt[]"),to=opt.length,ch="",ft=$n("ftype")[0];
for(j=0; ff[j]; ++j){if(ff[j].checked) ch=ff[j].value;}
if($('#tbs'))dbx('tbs');
if(ch=="sql"){
for(let k=0;k<to;k++) opt[k].parentElement.show();
}else if(ch=="doc"||ch=="xml"){
let k,n=ch=="xml"?4:2;
for(k=0;k<n;k++) opt[k].parentElement.show();
for(k=n;k<to;k++){opt[k].parentElement.hide();opt[k].checked=false}
}else{
for(let i=0;i<to;i++){opt[i].parentElement.hide();opt[i].checked=false}
}
}
function dbx(el='dbs'){
let j,ch="",ft=$n("ftype")[0],ff=$n("ffmt[]"),db=$$("#"+el+" option:checked").length,dbs=$('#dbs'),arr=["json","csv1","csv2"];
for(j=0;ff[j];++j){if(ff[j].checked) ch=ff[j].value;}
if(ft[0].value!="plain"){
if((db<2 && (dbs||arr.indexOf(ch)>-1))||(db>1 && (dbs||arr.indexOf(ch)==-1))){
let op=$c("option");
op.value="plain";op.text="None";
ft.options.add(op,0);
ft.options[0].selected=true;
}
}
if(db>1 && ft[0].value=="plain" && (dbs||arr.indexOf(ch)>-1))ft[0].remove();
}
</script>
</body></html>