26 require
'../../main.inc.php';
28 $langs->load(
"admin");
47 print
'<div class="div-table-responsive-no-min">';
48 print
'<table class="noborder centpercent">';
49 print
'<tr class="liste_titre"><td colspan="2">'.$langs->trans(
"Database").
'</td></tr>'.
"\n";
50 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"Version").
'</td><td>'.$db::LABEL.
' '.$db->getVersion().
'</td></tr>'.
"\n";
51 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DatabaseServer").
'</td><td>'.$conf->db->host.
'</td></tr>'.
"\n";
52 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DatabasePort").
'</td><td>'.(empty($conf->db->port) ? $langs->trans(
"Default") : $conf->db->port).
'</td></tr>'.
"\n";
53 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DatabaseName").
'</td><td>'.$conf->db->name.
'</td></tr>'.
"\n";
54 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DriverType").
'</td><td>'.$conf->db->type.($db->getDriverInfo() ?
' ('.$db->getDriverInfo().
')' :
'').
'</td></tr>'.
"\n";
55 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"User").
'</td><td>'.$conf->db->user.
'</td></tr>'.
"\n";
56 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"Password").
'</td><td>'.preg_replace(
'/./i',
'*', $dolibarr_main_db_pass).
'</td></tr>'.
"\n";
57 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DBStoringCharset").
'</td><td>'.$db->getDefaultCharacterSetDatabase().
'</td></tr>'.
"\n";
58 print
'<tr class="oddeven"><td width="300">'.$langs->trans(
"DBSortingCharset").
'</td><td>'.$db->getDefaultCollationDatabase().
'</td></tr>'.
"\n";
64 print
'<div class="div-table-responsive-no-min">';
65 print
'<table class="noborder centpercent">';
66 print
'<tr class="liste_titre"><td colspan="2">'.$langs->trans(
"Tables").
'</td></tr>'.
"\n";
67 print
'<tr class="oddeven"><td width="300"><a href="'.DOL_URL_ROOT.
'/admin/system/database-tables.php?mainmenu=home">'.$langs->trans(
"List").
'</a></td></tr>'.
"\n";
71 $listofvars = $db->getServerParametersValues();
72 $listofstatus = $db->getServerStatusValues();
73 $arraylist = array(
'listofvars',
'listofstatus');
75 if (!count($listofvars) && !count($listofstatus)) {
76 print $langs->trans(
"FeatureNotAvailableWithThisDatabaseDriver");
78 foreach ($arraylist as $listname) {
80 print
'<div class="div-table-responsive-no-min">';
81 print
'<table class="noborder centpercent">';
82 print
'<tr class="liste_titre">';
83 print
'<td width="300">'.$langs->trans(
"Parameters").
'</td>';
84 print
'<td>'.$langs->trans(
"Value").
'</td>';
89 if (preg_match(
'/mysql/i', $db->type)) {
91 'character_set_database'=>array(
'var'=>
'dolibarr_main_db_character_set',
'valifempty'=>
'utf8'),
92 'collation_database'=>array(
'var'=>
'dolibarr_main_db_collation',
'valifempty'=>
'utf8_unicode_ci')
97 if ($listname ==
'listofvars') {
98 $listtouse = $listofvars;
100 if ($listname ==
'listofstatus') {
101 $listtouse = $listofstatus;
104 foreach ($listtouse as $param => $paramval) {
105 print
'<tr class="oddeven">';
109 print
'<td class="wordbreak">';
110 $show = 0; $text =
'';
111 foreach ($arraytest as $key => $val) {
112 if ($key != $param) {
115 $val2 = ${$val[
'var']};
116 $text =
'Should be in line with value of param <b>'.$val[
'var'].
'</b> thas is <b>'.($val2 ? $val2 :
"'' (=".$val[
'valifempty'].
")").
'</b>';
123 print
$form->textwithpicto($paramval, $text);
126 print
$form->textwithpicto($paramval, $text, 1,
'warning');
131 print
'</table>'.
"\n";