/**
 *	Fix table
 */
function fixTable($table)
{
    global $db;
    # get variables from config file
    $database = new database($db['host'], $db['user'], $db['pass'], $db['name']);
    //get fix
    $query = getTableFix($table);
    /* execute */
    try {
        $database->executeMultipleQuerries($query);
    } catch (Exception $e) {
        die("<div class='alert alert-danger'>" . $e->getMessage() . "</div>");
    }
    # return
    return true;
}
/**
 *	Fix table
 */
function fixTable($table)
{
    global $database;
    //get fix
    $query = getTableFix($table);
    /* execute */
    try {
        $database->executeMultipleQuerries($query);
    } catch (Exception $e) {
        die("<div class='alert alert-danger'>" . $e->getMessage() . "</div>");
    }
    # return
    return true;
}
/* check for errors */
$errors = verifyDatabase();
/* print result */
if (!isset($errors['tableError']) && !isset($errors['fieldError'])) {
    print '<div class="alert alert-success alert-absolute">' . _('All tables and fields are installed properly') . '!</div>' . "\n";
} else {
    //tables
    if (isset($errors['tableError'])) {
        print '<div class="alert alert-danger alert-absolute" style="text-align:left;">' . "\n";
        print '<b>' . _('Missing table') . 's:</b>' . "\n";
        print '<ul class="fix-table">' . "\n";
        foreach ($errors['tableError'] as $table) {
            print '<li>';
            print $table . " ";
            //get fix
            if (!($fix = getTableFix($table))) {
                print "<div class='alert alert-danger'>" . _("Cannot get fix for table") . " {$table}!</div>";
            } else {
                print "<a class='btn btn-xs btn-default btn-tablefix' style='margin-left:8px;' href='' data-tableid='{$table}' data-fieldid='' data-type='table'><i class='fa fa-magic fa-pad-right'></i>" . _("Fix table") . "</a>";
                print "<div id='fix-result-{$table}' style='display:none'></div>";
            }
            print '</li>' . "\n";
        }
        print '</ul>' . "\n";
        print '</div>' . "\n";
    }
    //fields
    if (isset($errors['fieldError'])) {
        print '<div class="alert alert-danger alert-absolute" style="text-align:left;">' . "\n";
        print '<b>' . _('Missing fields') . ':</b>' . "\n";
        print '<ul class="fix-field">' . "\n";