/** * 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";