V1rus Private

Viewing: check_mysql_engines

#!/usr/local/bin/php

<?php

$output = explode(PHP_EOL, shell_exec('sudo mysql -u root -e \'show engines\' | awk {\'print $1" "$2\'} | tail -n +2'));
$engines = ['InnoDB', 'MRG_MYISAM', 'MEMORY', 'MyISAM', 'ARCHIVE'];

foreach ($output as $string) {
    list($k, $v) = explode(' ', $string);
    $result[ $k ] = $v;
}

foreach ($engines as $engine) {
    if ($result[$engine] == 'NO') {
        $answer[]=$engine;
    }
}

if (empty($answer)) {
    echo "MySQL Engines OK.";
    exit(0);
} else {
    echo json_encode(['error' => 'true', 'failed_engines' => $answer], JSON_PRETTY_PRINT);
    exit(2);
}

User / IP	: 216.73.217.108
Host / Server	: 190.92.174.125 / aerosofthealthcare.com
System	: Linux s3739.bom1.stableserver.net 4.18.0-513.24.1.lve.2.el8.x86_64 #1 SMP Fri May 24 12:42:50 UTC 2024 x86_64