<?php
/**
 * Created by PhpStorm.
 * User: insu
 * Date: 15-03-05
 * Time: 10:06 AM
 */
require_once __DIR__ . '/../wp-config.php';

$mysqli = @new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if ($mysqli->connect_errno) {
    echo "<h1>Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error . "</h1>\n";
    die(1);
}

$results = $mysqli->query("show tables;");
if ($results === false or $mysqli->connect_errno) {
    echo "MySQL error: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error . "\n";
    die(2);
}
while ($row = $results->fetch_assoc()) {
    $sql = "SHOW TABLE STATUS WHERE Name = '{$row['Tables_in_test']}'";
    $thisTable = $mysqli->query($sql)->fetch_assoc();

    if ($thisTable['Engine'] === 'MyISAM') {
        $sql = "alter table " . $row['Tables_in_test'] . " ENGINE = InnoDB;";
        echo $row['Tables_in_test'] . " is using the " . $thisTable['Engine'] . " Engine. [ Changing ]\n";
        $mysqli->query($sql);
    } else {
        echo $row['Tables_in_test'] . ' is already using the ' . $thisTable['Engine'] . " Engine. [ Ignoring ]\n";
    }
};

die(0);