/**
* prints out diagnostic info for pma relation feature
*
* @param array $cfgRelation Relation configuration
*
* @return string
*/
function PMA_getRelationsParamDiagnostic($cfgRelation)
{
$retval = '';
$messages = array();
$messages['error'] = '<font color="red"><strong>' . __('not OK') . '</strong></font>';
$messages['ok'] = '<font color="green"><strong>' . _pgettext('Correctly working', 'OK') . '</strong></font>';
$messages['enabled'] = '<font color="green">' . __('Enabled') . '</font>';
$messages['disabled'] = '<font color="red">' . __('Disabled') . '</font>';
if (empty($cfgRelation['db'])) {
$retval .= __('Configuration of pmadb… ') . $messages['error'] . PMA_Util::showDocu('setup', 'linked-tables') . '<br />' . "\n" . __('General relation features') . ' <font color="green">' . __('Disabled') . '</font>' . "\n";
if (!empty($GLOBALS['db']) && $GLOBALS['cfg']['ZeroConf']) {
$retval .= PMA_getHtmlFixPMATables(true);
}
} else {
$retval .= '<table>' . "\n";
if (!$cfgRelation['allworks'] && $GLOBALS['cfg']['ZeroConf']) {
$retval .= PMA_getHtmlFixPMATables(false);
$retval .= '<br />';
}
$retval .= PMA_getDiagMessageForParameter('pmadb', $cfgRelation['db'], $messages, 'pmadb');
$retval .= PMA_getDiagMessageForParameter('relation', isset($cfgRelation['relation']), $messages, 'relation');
$retval .= PMA_getDiagMessageForFeature(__('General relation features'), 'relwork', $messages);
$retval .= PMA_getDiagMessageForParameter('table_info', isset($cfgRelation['table_info']), $messages, 'table_info');
$retval .= PMA_getDiagMessageForFeature(__('Display Features'), 'displaywork', $messages);
$retval .= PMA_getDiagMessageForParameter('table_coords', isset($cfgRelation['table_coords']), $messages, 'table_coords');
$retval .= PMA_getDiagMessageForParameter('pdf_pages', isset($cfgRelation['pdf_pages']), $messages, 'pdf_pages');
$retval .= PMA_getDiagMessageForFeature(__('Designer and creation of PDFs'), 'pdfwork', $messages);
$retval .= PMA_getDiagMessageForParameter('column_info', isset($cfgRelation['column_info']), $messages, 'column_info');
$retval .= PMA_getDiagMessageForFeature(__('Displaying Column Comments'), 'commwork', $messages, false);
$retval .= PMA_getDiagMessageForFeature(__('Browser transformation'), 'mimework', $messages);
if ($cfgRelation['commwork'] && !$cfgRelation['mimework']) {
$retval .= '<tr><td colspan=2 class="left error">';
$retval .= __('Please see the documentation on how to' . ' update your column_info table. ');
$retval .= PMA_Util::showDocu('config', 'cfg_Servers_column_info');
$retval .= '</td></tr>';
}
$retval .= PMA_getDiagMessageForParameter('bookmarktable', isset($cfgRelation['bookmark']), $messages, 'bookmark');
$retval .= PMA_getDiagMessageForFeature(__('Bookmarked SQL query'), 'bookmarkwork', $messages);
$retval .= PMA_getDiagMessageForParameter('history', isset($cfgRelation['history']), $messages, 'history');
$retval .= PMA_getDiagMessageForFeature(__('SQL history'), 'historywork', $messages);
$retval .= PMA_getDiagMessageForParameter('recent', isset($cfgRelation['recent']), $messages, 'recent');
$retval .= PMA_getDiagMessageForFeature(__('Persistent recently used tables'), 'recentwork', $messages);
$retval .= PMA_getDiagMessageForParameter('favorite', isset($cfgRelation['favorite']), $messages, 'favorite');
$retval .= PMA_getDiagMessageForFeature(__('Persistent favorite tables'), 'favoritework', $messages);
$retval .= PMA_getDiagMessageForParameter('table_uiprefs', isset($cfgRelation['table_uiprefs']), $messages, 'table_uiprefs');
$retval .= PMA_getDiagMessageForFeature(__('Persistent tables\' UI preferences'), 'uiprefswork', $messages);
$retval .= PMA_getDiagMessageForParameter('tracking', isset($cfgRelation['tracking']), $messages, 'tracking');
$retval .= PMA_getDiagMessageForFeature(__('Tracking'), 'trackingwork', $messages);
$retval .= PMA_getDiagMessageForParameter('userconfig', isset($cfgRelation['userconfig']), $messages, 'userconfig');
$retval .= PMA_getDiagMessageForFeature(__('User preferences'), 'userconfigwork', $messages);
$retval .= PMA_getDiagMessageForParameter('users', isset($cfgRelation['users']), $messages, 'users');
$retval .= PMA_getDiagMessageForParameter('usergroups', isset($cfgRelation['usergroups']), $messages, 'usergroups');
$retval .= PMA_getDiagMessageForFeature(__('Configurable menus'), 'menuswork', $messages);
$retval .= PMA_getDiagMessageForParameter('navigationhiding', isset($cfgRelation['navigationhiding']), $messages, 'navigationhiding');
$retval .= PMA_getDiagMessageForFeature(__('Hide/show navigation items'), 'navwork', $messages);
$retval .= PMA_getDiagMessageForParameter('savedsearches', isset($cfgRelation['savedsearches']), $messages, 'savedsearches');
$retval .= PMA_getDiagMessageForFeature(__('Saving Query-By-Example searches'), 'savedsearcheswork', $messages);
$retval .= PMA_getDiagMessageForParameter('central_columns', isset($cfgRelation['central_columns']), $messages, 'central_columns');
$retval .= PMA_getDiagMessageForFeature(__('Managing Central list of columns'), 'central_columnswork', $messages);
$retval .= '</table>' . "\n";
if (!$cfgRelation['allworks']) {
$retval .= '<p>' . __('Quick steps to setup advanced features:') . '</p>';
$retval .= '<ul>';
$retval .= '<li>';
$retval .= sprintf(__('Create the needed tables with the ' . '<code>%screate_tables.sql</code>.'), htmlspecialchars(SQL_DIR));
$retval .= ' ' . PMA_Util::showDocu('setup', 'linked-tables');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Create a pma user and give access to these tables.');
$retval .= ' ' . PMA_Util::showDocu('config', 'cfg_Servers_controluser');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Enable advanced features in configuration file ' . '(<code>config.inc.php</code>), for example by ' . 'starting from <code>config.sample.inc.php</code>.');
$retval .= ' ' . PMA_Util::showDocu('setup', 'quick-install');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Re-login to phpMyAdmin to load the updated configuration file.');
$retval .= '</li>';
$retval .= '</ul>';
}
}
return $retval;
}
/**
* prints out diagnostic info for pma relation feature
*
* @param array $cfgRelation Relation configuration
*
* @return string
*/
function PMA_getRelationsParamDiagnostic($cfgRelation)
{
$retval = '';
$messages['error'] = '<font color="red"><strong>' . __('not OK') . '</strong></font>' . ' [ <a href="%s" target="documentation">' . __('Documentation') . '</a> ]';
$messages['ok'] = '<font color="green"><strong>' . _pgettext('Correctly working', 'OK') . '</strong></font>';
$messages['enabled'] = '<font color="green">' . __('Enabled') . '</font>';
$messages['disabled'] = '<font color="red">' . __('Disabled') . '</font>';
if (false === $GLOBALS['cfg']['Server']['pmadb']) {
$retval .= 'PMA Database ... ' . sprintf($messages['error'], 'pmadb') . '<br />' . "\n" . __('General relation features') . ' <font color="green">' . __('Disabled') . '</font>' . "\n";
} else {
$retval .= '<table>' . "\n";
$retval .= PMA_getDiagMessageForParameter('pmadb', $GLOBALS['cfg']['Server']['pmadb'], $messages, 'pmadb');
$retval .= PMA_getDiagMessageForParameter('relation', isset($cfgRelation['relation']), $messages, 'relation');
$retval .= PMA_getDiagMessageForFeature(__('General relation features'), 'relwork', $messages);
$retval .= PMA_getDiagMessageForParameter('table_info', isset($cfgRelation['table_info']), $messages, 'table_info');
$retval .= PMA_getDiagMessageForFeature(__('Display Features'), 'displaywork', $messages);
$retval .= PMA_getDiagMessageForParameter('table_coords', isset($cfgRelation['table_coords']), $messages, 'table_coords');
$retval .= PMA_getDiagMessageForParameter('pdf_pages', isset($cfgRelation['pdf_pages']), $messages, 'pdf_pages');
$retval .= PMA_getDiagMessageForFeature(__('Creation of PDFs'), 'pdfwork', $messages);
$retval .= PMA_getDiagMessageForParameter('column_info', isset($cfgRelation['column_info']), $messages, 'column_info');
$retval .= PMA_getDiagMessageForFeature(__('Displaying Column Comments'), 'commwork', $messages, false);
$retval .= PMA_getDiagMessageForFeature(__('Browser transformation'), 'mimework', $messages);
if ($cfgRelation['commwork'] && !$cfgRelation['mimework']) {
$retval .= '<tr><td colspan=2 class="left">';
$retval .= __('Please see the documentation on how to update your column_comments table.');
$retval .= '</td></tr>';
}
$retval .= PMA_getDiagMessageForParameter('bookmarktable', isset($cfgRelation['bookmark']), $messages, 'bookmark');
$retval .= PMA_getDiagMessageForFeature(__('Bookmarked SQL query'), 'bookmarkwork', $messages);
$retval .= PMA_getDiagMessageForParameter('history', isset($cfgRelation['history']), $messages, 'history');
$retval .= PMA_getDiagMessageForFeature(__('SQL history'), 'historywork', $messages);
$retval .= PMA_getDiagMessageForParameter('designer_coords', isset($cfgRelation['designer_coords']), $messages, 'designer_coords');
$retval .= PMA_getDiagMessageForFeature(__('Designer'), 'designerwork', $messages);
$retval .= PMA_getDiagMessageForParameter('recent', isset($cfgRelation['recent']), $messages, 'recent');
$retval .= PMA_getDiagMessageForFeature(__('Persistent recently used tables'), 'recentwork', $messages);
$retval .= PMA_getDiagMessageForParameter('table_uiprefs', isset($cfgRelation['table_uiprefs']), $messages, 'table_uiprefs');
$retval .= PMA_getDiagMessageForFeature(__('Persistent tables\' UI preferences'), 'uiprefswork', $messages);
$retval .= PMA_getDiagMessageForParameter('tracking', isset($cfgRelation['tracking']), $messages, 'tracking');
$retval .= PMA_getDiagMessageForFeature(__('Tracking'), 'trackingwork', $messages);
$retval .= PMA_getDiagMessageForParameter('userconfig', isset($cfgRelation['userconfig']), $messages, 'userconfig');
$retval .= PMA_getDiagMessageForFeature(__('User preferences'), 'userconfigwork', $messages);
$retval .= PMA_getDiagMessageForParameter('users', isset($cfgRelation['users']), $messages, 'users');
$retval .= PMA_getDiagMessageForParameter('usergroups', isset($cfgRelation['usergroups']), $messages, 'usergroups');
$retval .= PMA_getDiagMessageForFeature(__('Configurable menus'), 'menuswork', $messages);
$retval .= PMA_getDiagMessageForParameter('navigationhiding', isset($cfgRelation['navigationhiding']), $messages, 'navigationhiding');
$retval .= PMA_getDiagMessageForFeature(__('Hide/show navigation items'), 'navwork', $messages);
$retval .= '</table>' . "\n";
$retval .= '<p>' . __('Quick steps to setup advanced features:') . '</p>';
$retval .= '<ul>';
$retval .= '<li>';
$retval .= __('Create the needed tables with the ' . '<code>examples/create_tables.sql</code>.');
$retval .= ' ' . PMA_Util::showDocu('setup', 'linked-tables');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Create a pma user and give access to these tables.');
$retval .= ' ' . PMA_Util::showDocu('config', 'cfg_Servers_controluser');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Enable advanced features in configuration file ' . '(<code>config.inc.php</code>), for example by ' . 'starting from <code>config.sample.inc.php</code>.');
$retval .= ' ' . PMA_Util::showDocu('setup', 'quick-install');
$retval .= '</li>';
$retval .= '<li>';
$retval .= __('Re-login to phpMyAdmin to load the updated configuration file.');
$retval .= '</li>';
$retval .= '</ul>';
}
return $retval;
}
