<?php
$db_host = getenv("DB_main_HOST");
$db_user = getenv("DB_main_LOGIN");
$db_name = getenv("DB_main_NAME");
$db_password = getenv("DB_main_PASSWORD");
$db_port = getenv("DB_main_PORT");
$db_prefix = getenv("DB_main_PREFIX");

$socket = null;

if(strpos($db_host, ':') > 0)
{
    $split_host = explode(':', $db_host);
    $db_host = $split_host[0];
    $socket = $split_host[1];
    $db_port = null;
}

$connection = mysqli_connect($db_host, $db_user, $db_password, $db_name, (int)$db_port, $socket);

if(!$connection)
{
    die("Connection Error (".mysqli_connect_errno().") ".mysqli_connect_error());
}

$query = "SHOW TABLES LIKE "."\"".$db_prefix."%\";";
$query_result = mysqli_query($connection, $query);
$tables = array();

while($row = mysqli_fetch_array($query_result, MYSQLI_BOTH))
{
    $tables[] = $row[0];
}

$count_tables = count($tables);

for($i = 0; $i < $count_tables; $i++)
{
    $delete_query = "DROP TABLE ".$tables[$i].";";
    mysqli_query($connection, $delete_query);
}

mysqli_close($connection);