25 require
'../../main.inc.php';
26 require_once DOL_DOCUMENT_ROOT.
'/core/lib/memory.lib.php';
27 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
28 require_once DOL_DOCUMENT_ROOT.
'/core/lib/geturl.lib.php';
29 require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
30 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
33 $langs->loadLangs(array(
"install",
"other",
"admin"));
35 $action =
GETPOST(
'action',
'aZ09');
50 if ($action ==
'getlastversion') {
51 $result =
getURLContent(
'https://sourceforge.net/projects/dolibarr/rss');
53 if (function_exists(
'simplexml_load_string')) {
54 $sfurl = simplexml_load_string($result[
'content'],
'SimpleXMLElement', LIBXML_NOCDATA|LIBXML_NONET);
56 setEventMessages($langs->trans(
"ErrorPHPDoesNotSupport",
"xml"),
null,
'errors');
68 $title = $langs->trans(
"InfoDolibarr");
75 print
'<div class="div-table-responsive-no-min">';
76 print
'<table class="noborder centpercent">';
77 print
'<tr class="liste_titre"><td class="titlefieldcreate">'.$langs->trans(
"Version").
'</td><td>'.$langs->trans(
"Value").
'</td></tr>'.
"\n";
78 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentVersion").
' ('.$langs->trans(
"Programs").
')</td><td>'.DOL_VERSION;
80 if (empty($conf->global->MAIN_VERSION_LAST_UPGRADE)) {
82 if (DOL_VERSION != $conf->global->MAIN_VERSION_LAST_INSTALL) {
83 print
' '.img_warning($langs->trans(
"RunningUpdateProcessMayBeRequired", DOL_VERSION, $conf->global->MAIN_VERSION_LAST_INSTALL));
87 if (DOL_VERSION != $conf->global->MAIN_VERSION_LAST_UPGRADE) {
88 print
' '.img_warning($langs->trans(
"RunningUpdateProcessMayBeRequired", DOL_VERSION, $conf->global->MAIN_VERSION_LAST_UPGRADE));
92 $version = DOL_VERSION;
93 if (preg_match(
'/[a-z]+/i', $version)) {
96 print
' <a href="https://raw.githubusercontent.com/Dolibarr/dolibarr/'.$version.
'/ChangeLog" target="_blank" rel="noopener noreferrer external">'.$langs->trans(
"SeeChangeLog").
'</a>';
99 if (function_exists(
'curl_init')) {
100 $conf->global->MAIN_USE_RESPONSE_TIMEOUT = 10;
101 print
' - ';
102 if ($action ==
'getlastversion') {
105 while (!empty($sfurl->channel[0]->item[$i]->title) && $i < 10000) {
106 $title = $sfurl->channel[0]->item[$i]->title;
108 if (preg_match(
'/([0-9]+\.([0-9\.]+))/', $title, $reg)) {
109 $newversion = $reg[1];
110 $newversionarray = explode(
'.', $newversion);
111 $versionarray = explode(
'.', $version);
114 $version = $newversion;
121 print $langs->trans(
"LastStableVersion").
' : <b>'.(($version !=
'0.0') ? $version : $langs->trans(
"Unknown")).
'</b>';
122 if ($version !=
'0.0') {
123 print
' <a href="https://raw.githubusercontent.com/Dolibarr/dolibarr/'.$version.
'/ChangeLog" target="_blank" rel="noopener noreferrer external">'.$langs->trans(
"SeeChangeLog").
'</a>';
126 print $langs->trans(
"LastStableVersion").
' : <b>'.$langs->trans(
"UpdateServerOffline").
'</b>';
129 print $langs->trans(
"LastStableVersion").
' : <a href="'.$_SERVER[
"PHP_SELF"].
'?action=getlastversion" class="butAction smallpaddingimp">'.$langs->trans(
"Check").
'</a>';
136 $version = DOL_VERSION;
137 if (preg_match(
'/[a-z]+/i', $version)) {
138 $version =
'develop';
141 print
'</td></tr>'.
"\n";
142 print
'<tr class="oddeven"><td>'.$langs->trans(
"VersionLastUpgrade").
' ('.$langs->trans(
"Database").
')</td><td>'.
getDolGlobalString(
'MAIN_VERSION_LAST_UPGRADE').
'</td></tr>'.
"\n";
143 print
'<tr class="oddeven"><td>'.$langs->trans(
"VersionLastInstall").
'</td><td>'.
getDolGlobalString(
'MAIN_VERSION_LAST_INSTALL').
'</td></tr>'.
"\n";
149 print
'<div class="div-table-responsive-no-min">';
150 print
'<table class="noborder centpercent">';
151 print
'<tr class="liste_titre"><td class="titlefieldcreate">'.$langs->trans(
"Session").
'</td><td colspan="2">'.$langs->trans(
"Value").
'</td></tr>'.
"\n";
152 print
'<tr class="oddeven"><td>'.$langs->trans(
"SessionSavePath").
'</td><td colspan="2">'.session_save_path().
'</td></tr>'.
"\n";
153 print
'<tr class="oddeven"><td>'.$langs->trans(
"SessionName").
'</td><td colspan="2">'.session_name().
'</td></tr>'.
"\n";
154 print
'<tr class="oddeven"><td>'.$langs->trans(
"SessionId").
'</td><td colspan="2">'.session_id().
'</td></tr>'.
"\n";
155 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentSessionTimeOut").
' (session.gc_maxlifetime)</td><td>'.ini_get(
'session.gc_maxlifetime').
' '.$langs->trans(
"seconds");
156 print
'</td><td class="right">';
157 print
'<!-- session.gc_maxlifetime = '.ini_get(
"session.gc_maxlifetime").
' -->'.
"\n";
158 print
'<!-- session.gc_probability = '.ini_get(
"session.gc_probability").
' -->'.
"\n";
159 print
'<!-- session.gc_divisor = '.ini_get(
"session.gc_divisor").
' -->'.
"\n";
160 print
$form->textwithpicto(
'', $langs->trans(
"SessionExplanation", ini_get(
"session.gc_probability"), ini_get(
"session.gc_divisor")));
161 print
"</td></tr>\n";
162 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentTheme").
'</td><td colspan="2">'.$conf->theme.
'</td></tr>'.
"\n";
163 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentMenuHandler").
'</td><td colspan="2">';
164 print $conf->standard_menu;
165 print
'</td></tr>'.
"\n";
166 print
'<tr class="oddeven"><td>'.$langs->trans(
"Screen").
'</td><td colspan="2">';
167 print $_SESSION[
'dol_screenwidth'].
' x '.$_SESSION[
'dol_screenheight'];
168 print
'</td></tr>'.
"\n";
169 print
'<tr class="oddeven"><td>'.$langs->trans(
"Session").
'</td><td colspan="2">';
171 foreach ($_SESSION as $key => $val) {
175 if (is_array($val)) {
176 print $key.
' => array(...)';
182 print
'</td></tr>'.
"\n";
189 if (isset($conf->global->MAIN_OPTIMIZE_SPEED) && ($conf->global->MAIN_OPTIMIZE_SPEED & 0x02)) {
192 print
'<div class="div-table-responsive-no-min">';
193 print
'<table class="noborder centpercent">';
194 print
'<tr class="liste_titre">';
195 print
'<td class="titlefieldcreate">'.$langs->trans(
"LanguageFilesCachedIntoShmopSharedMemory").
'</td>';
196 print
'<td>'.$langs->trans(
"NbOfEntries").
'</td>';
197 print
'<td class="right">'.$langs->trans(
"Address").
'</td>';
200 foreach ($shmoparray as $key => $val) {
201 print
'<tr class="oddeven"><td>'.$key.
'</td>';
202 print
'<td>'.count($val).
'</td>';
203 print
'<td class="right">'.dol_getshmopaddress($key).
'</td>';
214 print
'<div class="div-table-responsive-no-min">';
215 print
'<table class="noborder centpercent">';
216 print
'<tr class="liste_titre"><td class="titlefieldcreate">'.$langs->trans(
"LocalisationDolibarrParameters").
'</td><td>'.$langs->trans(
"Value").
'</td></tr>'.
"\n";
217 print
'<tr class="oddeven"><td>'.$langs->trans(
"LanguageBrowserParameter",
"HTTP_ACCEPT_LANGUAGE").
'</td><td>'.$_SERVER[
"HTTP_ACCEPT_LANGUAGE"].
'</td></tr>'.
"\n";
218 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentUserLanguage").
'</td><td>'.$langs->getDefaultLang().
'</td></tr>'.
"\n";
220 $thousand = $langs->transnoentitiesnoconv(
"SeparatorThousand");
221 if ($thousand ==
'SeparatorThousand') {
224 if ($thousand ==
'None') {
227 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentValueSeparatorThousand").
'</td><td>'.($thousand ==
' ' ? $langs->transnoentitiesnoconv(
"Space") : $thousand).
'</td></tr>'.
"\n";
229 $dec = $langs->transnoentitiesnoconv(
"SeparatorDecimal");
230 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentValueSeparatorDecimal").
'</td><td>'.$dec.
'</td></tr>'.
"\n";
232 print
'<tr class="oddeven"><td> => price2num(1233.56+1)</td><td>'.price2num(1233.56 + 1,
'2').
'</td></tr>'.
"\n";
233 print
'<tr class="oddeven"><td> => price2num('.
"'1".$thousand.
"234".$dec.
"56')</td><td>".
price2num(
"1".$thousand.
"234".$dec.
"56",
'2').
"</td></tr>\n";
234 if (($thousand !=
',' && $thousand !=
'.') || ($thousand !=
' ')) {
235 print
'<tr class="oddeven"><td> => price2num('.
"'1 234.56')</td><td>".
price2num(
"1 234.56",
'2').
"</td>";
238 print
'<tr class="oddeven"><td> => price(1234.56)</td><td>'.price(1234.56).
'</td></tr>'.
"\n";
243 if ($conf->db->type ==
'mysql' || $conf->db->type ==
'mysqli') {
244 print
'<tr class="oddeven"><td>'.$langs->trans(
"MySQLTimeZone").
' (database)</td><td>';
245 $sql =
"SHOW VARIABLES where variable_name = 'system_time_zone'";
246 $resql = $db->query($sql);
248 $obj = $db->fetch_object(
$resql);
249 print
$form->textwithtooltip($obj->Value, $langs->trans(
'TZHasNoEffect'), 2, 1,
img_info(
''));
251 print
'</td></tr>'.
"\n";
253 $txt = $langs->trans(
"OSTZ").
' (variable system TZ): '.(!empty($_ENV[
"TZ"]) ? $_ENV[
"TZ"] : $langs->trans(
"NotDefined")).
'<br>'.
"\n";
254 $txt .= $langs->trans(
"PHPTZ").
' (date_default_timezone_get() / php.ini date.timezone): '.(
getServerTimeZoneString().
" / ".(ini_get(
"date.timezone") ? ini_get(
"date.timezone") : $langs->trans(
"NotDefined"))).
"<br>\n";
255 $txt .= $langs->trans(
"Dolibarr constant MAIN_SERVER_TZ").
': '.(empty($conf->global->MAIN_SERVER_TZ) ? $langs->trans(
"NotDefined") : $conf->global->MAIN_SERVER_TZ);
256 print
'<tr class="oddeven"><td>'.$langs->trans(
"CurrentTimeZone").
'</td><td>';
260 $daylight = round($c - $b);
262 $val = ($a >= 0 ?
'+' :
'').$a;
263 $val .=
' ('.($a ==
'unknown' ?
'unknown' : ($a >= 0 ?
'+' :
'').($a * 3600)).
')';
264 $val .=
' '.getServerTimeZoneString();
265 $val .=
' '.$langs->trans(
"DaylingSavingTime").
': '.($daylight ===
'unknown' ?
'unknown' : ($a == $c ?
yn($daylight) :
yn(0).($daylight ?
' ('.$langs->trans(
'YesInSummer').
')' :
'')));
266 print
$form->textwithtooltip($val, $txt, 2, 1,
img_info(
''));
267 print
'</td></tr>'.
"\n";
268 print
'<tr class="oddeven"><td> => '.$langs->trans(
"CurrentHour").
'</td><td>'.
dol_print_date(
dol_now(
'gmt'),
'dayhour',
'tzserver').
'</td></tr>'.
"\n";
269 print
'<tr class="oddeven"><td> => dol_print_date(0,"dayhourtext")</td><td>'.dol_print_date(0,
"dayhourtext").
'</td>';
270 print
'<tr class="oddeven"><td> => dol_get_first_day(1970,1,false)</td><td>'.dol_get_first_day(1970, 1,
false).
' (=> dol_print_date() or idate() of this value = '.
dol_print_date(
dol_get_first_day(1970, 1,
false),
'dayhour').
')</td>';
271 print
'<tr class="oddeven"><td> => dol_get_first_day(1970,1,true)</td><td>'.dol_get_first_day(1970, 1,
true).
' (=> dol_print_date() or idate() of this value = '.
dol_print_date(
dol_get_first_day(1970, 1,
true),
'dayhour').
')</td>';
273 $tz = (int) $_SESSION[
'dol_tz'] + (
int) $_SESSION[
'dol_dst'];
274 print
'<tr class="oddeven"><td>'.$langs->trans(
"ClientTZ").
'</td><td>'.($tz ? ($tz >= 0 ?
'+' :
'').$tz :
'').
' ('.($tz >= 0 ?
'+' :
'').($tz * 60 * 60).
')';
275 print
' '.$_SESSION[
'dol_tz_string'];
276 print
' '.$langs->trans(
"DaylingSavingTime").
': ';
277 if ($_SESSION[
'dol_dst'] > 0) {
282 if (!empty($_SESSION[
'dol_dst_first'])) {
285 print
'</td></tr>'.
"\n";
286 print
'</td></tr>'.
"\n";
287 print
'<tr class="oddeven"><td> => '.$langs->trans(
"ClientHour").
'</td><td>'.
dol_print_date(
dol_now(
'gmt'),
'dayhour',
'tzuser').
'</td></tr>'.
"\n";
289 $filesystemencoding = ini_get(
"unicode.filesystem_encoding");
290 print
'<tr class="oddeven"><td>'.$langs->trans(
"File encoding").
' (php.ini unicode.filesystem_encoding)</td><td>'.$filesystemencoding.
'</td></tr>'.
"\n";
292 $tmp = ini_get(
"unicode.filesystem_encoding");
293 if (empty($tmp) && !empty($_SERVER[
"WINDIR"])) {
299 if (!empty($conf->global->MAIN_FILESYSTEM_ENCODING)) {
300 $tmp = $conf->global->MAIN_FILESYSTEM_ENCODING;
302 print
'<tr class="oddeven"><td> => '.$langs->trans(
"File encoding").
'</td><td>'.$tmp.
'</td></tr>'.
"\n";
311 $configfileparameters = array(
312 'dolibarr_main_prod' =>
'Production mode (Hide all error messages)',
313 'dolibarr_main_instance_unique_id' => $langs->trans(
"InstanceUniqueID"),
315 'dolibarr_main_url_root' => $langs->trans(
"URLRoot"),
316 '?dolibarr_main_url_root_alt' => $langs->trans(
"URLRoot").
' (alt)',
317 'dolibarr_main_document_root'=> $langs->trans(
"DocumentRootServer"),
318 '?dolibarr_main_document_root_alt' => $langs->trans(
"DocumentRootServer").
' (alt)',
319 'dolibarr_main_data_root' => $langs->trans(
"DataRootServer"),
321 'dolibarr_main_db_host' => $langs->trans(
"DatabaseServer"),
322 'dolibarr_main_db_port' => $langs->trans(
"DatabasePort"),
323 'dolibarr_main_db_name' => $langs->trans(
"DatabaseName"),
324 'dolibarr_main_db_type' => $langs->trans(
"DriverType"),
325 'dolibarr_main_db_user' => $langs->trans(
"DatabaseUser"),
326 'dolibarr_main_db_pass' => $langs->trans(
"DatabasePassword"),
327 'dolibarr_main_db_character_set' => $langs->trans(
"DBStoringCharset"),
328 'dolibarr_main_db_collation' => $langs->trans(
"DBSortingCollation"),
329 '?dolibarr_main_db_prefix' => $langs->trans(
"DatabasePrefix"),
330 'dolibarr_main_db_readonly' => $langs->trans(
"ReadOnlyMode"),
332 'dolibarr_main_authentication' => $langs->trans(
"AuthenticationMode"),
333 '?multicompany_transverse_mode'=> $langs->trans(
"MultiCompanyMode"),
335 '?dolibarr_main_auth_ldap_login_attribute' =>
'dolibarr_main_auth_ldap_login_attribute',
336 '?dolibarr_main_auth_ldap_host' =>
'dolibarr_main_auth_ldap_host',
337 '?dolibarr_main_auth_ldap_port' =>
'dolibarr_main_auth_ldap_port',
338 '?dolibarr_main_auth_ldap_version' =>
'dolibarr_main_auth_ldap_version',
339 '?dolibarr_main_auth_ldap_dn' =>
'dolibarr_main_auth_ldap_dn',
340 '?dolibarr_main_auth_ldap_admin_login' =>
'dolibarr_main_auth_ldap_admin_login',
341 '?dolibarr_main_auth_ldap_admin_pass' =>
'dolibarr_main_auth_ldap_admin_pass',
342 '?dolibarr_main_auth_ldap_debug' =>
'dolibarr_main_auth_ldap_debug',
344 '?dolibarr_lib_ADODB_PATH' =>
'dolibarr_lib_ADODB_PATH',
345 '?dolibarr_lib_FPDF_PATH' =>
'dolibarr_lib_FPDF_PATH',
346 '?dolibarr_lib_TCPDF_PATH' =>
'dolibarr_lib_TCPDF_PATH',
347 '?dolibarr_lib_FPDI_PATH' =>
'dolibarr_lib_FPDI_PATH',
348 '?dolibarr_lib_TCPDI_PATH' =>
'dolibarr_lib_TCPDI_PATH',
349 '?dolibarr_lib_NUSOAP_PATH' =>
'dolibarr_lib_NUSOAP_PATH',
350 '?dolibarr_lib_GEOIP_PATH' =>
'dolibarr_lib_GEOIP_PATH',
351 '?dolibarr_lib_ODTPHP_PATH' =>
'dolibarr_lib_ODTPHP_PATH',
352 '?dolibarr_lib_ODTPHP_PATHTOPCLZIP' =>
'dolibarr_lib_ODTPHP_PATHTOPCLZIP',
353 '?dolibarr_js_CKEDITOR' =>
'dolibarr_js_CKEDITOR',
354 '?dolibarr_js_JQUERY' =>
'dolibarr_js_JQUERY',
355 '?dolibarr_js_JQUERY_UI' =>
'dolibarr_js_JQUERY_UI',
356 '?dolibarr_font_DOL_DEFAULT_TTF' =>
'dolibarr_font_DOL_DEFAULT_TTF',
357 '?dolibarr_font_DOL_DEFAULT_TTF_BOLD' =>
'dolibarr_font_DOL_DEFAULT_TTF_BOLD',
359 'dolibarr_main_restrict_os_commands' =>
'Restrict CLI commands for backups',
360 'dolibarr_main_restrict_ip' =>
'Restrict access to some IPs only',
361 '?dolibarr_mailing_limit_sendbyweb' =>
'Limit nb of email sent by page',
362 '?dolibarr_mailing_limit_sendbycli' =>
'Limit nb of email sent by cli',
363 '?dolibarr_mailing_limit_sendbyday' =>
'Limit nb of email sent per day',
364 '?dolibarr_strict_mode' =>
'Strict mode is on/off',
365 '?dolibarr_nocsrfcheck' =>
'Disable CSRF security checks'
368 print
'<div class="div-table-responsive-no-min">';
369 print
'<table class="noborder centpercent">';
370 print
'<tr class="liste_titre">';
371 print
'<td class="titlefieldcreate">'.$langs->trans(
"Parameters").
' ';
372 print $langs->trans(
"ConfigurationFile").
' ('.$conffiletoshowshort.
')';
374 print
'<td>'.$langs->trans(
"Parameter").
'</td>';
375 print
'<td>'.$langs->trans(
"Value").
'</td>';
378 foreach ($configfileparameters as $key => $value) {
381 if (empty($ignore)) {
382 $newkey = preg_replace(
'/^\?/',
'', $key);
384 if (preg_match(
'/^\?/', $key) && empty(${$newkey})) {
385 if ($newkey !=
'multicompany_transverse_mode' || empty($conf->multicompany->enabled)) {
389 if (strpos($newkey,
'separator') !==
false && $lastkeyshown ==
'separator') {
393 print
'<tr class="oddeven">';
394 if (strpos($newkey,
'separator') !==
false) {
395 print
'<td colspan="3"> </td>';
398 print
"<td>".$value.
'</td>';
400 print
'<td>'.$newkey.
'</td>';
403 if (in_array($newkey, array(
'dolibarr_main_db_pass',
'dolibarr_main_auth_ldap_admin_pass'))) {
404 if (empty($dolibarr_main_prod)) {
405 print
'<!-- '.${$newkey}.
' -->';
410 } elseif ($newkey ==
'dolibarr_main_url_root' && preg_match(
'/__auto__/', ${$newkey})) {
411 print ${$newkey}.
' => '.constant(
'DOL_MAIN_URL_ROOT');
412 } elseif ($newkey ==
'dolibarr_main_document_root_alt') {
413 $tmparray = explode(
',', ${$newkey});
415 foreach ($tmparray as $value2) {
420 if (!is_readable($value2)) {
421 $langs->load(
"errors");
422 print
' '.img_warning($langs->trans(
"ErrorCantReadDir", $value2));
426 } elseif ($newkey ==
'dolibarr_main_instance_unique_id') {
428 global $dolibarr_main_cookie_cryptkey, $dolibarr_main_instance_unique_id;
429 $valuetoshow = $dolibarr_main_instance_unique_id ? $dolibarr_main_instance_unique_id : $dolibarr_main_cookie_cryptkey;
430 if (empty($dolibarr_main_prod)) {
431 print
'<!-- '.${$newkey}.
' -->';
436 if (empty($valuetoshow)) {
437 print
img_warning(
"EditConfigFileToAddEntry",
'dolibarr_main_instance_unique_id');
440 print
'<tr class="oddeven"><td></td><td> => '.$langs->trans(
"HashForPing").
'</td><td>'.md5(
'dolibarr'.$valuetoshow).
'</td></tr>'.
"\n";
441 } elseif ($newkey ==
'dolibarr_main_prod') {
444 $valuetoshow = ${$newkey};
445 if (empty($valuetoshow)) {
446 print
img_warning($langs->trans(
'SwitchThisForABetterSecurity', 1));
448 } elseif ($newkey ==
'dolibarr_nocsrfcheck') {
451 $valuetoshow = ${$newkey};
452 if (!empty($valuetoshow)) {
453 print
img_warning($langs->trans(
'SwitchThisForABetterSecurity', 0));
455 } elseif ($newkey ==
'dolibarr_main_db_readonly') {
458 $valuetoshow = ${$newkey};
459 if (!empty($valuetoshow)) {
460 print
img_warning($langs->trans(
'ReadOnlyMode', 1));
463 print (empty(${$newkey}) ?
'' : ${$newkey});
465 if ($newkey ==
'dolibarr_main_url_root' && ${$newkey} != DOL_MAIN_URL_ROOT) {
466 print
' (currently overwritten by autodetected value: '.DOL_MAIN_URL_ROOT.
')';
471 $lastkeyshown = $newkey;
481 print
'<div class="div-table-responsive-no-min">';
482 print
'<table class="noborder">';
483 print
'<tr class="liste_titre">';
484 print
'<td class="titlefield">'.$langs->trans(
"Parameters").
' '.$langs->trans(
"Database").
'</td>';
485 print
'<td>'.$langs->trans(
"Value").
'</td>';
486 if (empty($conf->multicompany->enabled) || !$user->entity) {
487 print
'<td class="center width="80px"">'.$langs->trans(
"Entity").
'</td>';
493 $sql .=
", ".$db->decrypt(
'name').
" as name";
494 $sql .=
", ".$db->decrypt(
'value').
" as value";
498 $sql .=
" FROM ".MAIN_DB_PREFIX.
"const";
499 if (empty($conf->multicompany->enabled)) {
501 $sql .=
" WHERE entity IN (0,".$conf->entity.
")";
505 $sql .=
" WHERE entity IN (".$db->sanitize($user->entity.
",".$conf->entity).
")";
508 $sql .=
" ORDER BY entity, name ASC";
509 $resql = $db->query($sql);
511 $num = $db->num_rows(
$resql);
515 $obj = $db->fetch_object(
$resql);
517 print
'<tr class="oddeven">';
518 print
'<td class="tdoverflowmax600" title="'.dol_escape_htmltag($obj->name).
'">'.
dol_escape_htmltag($obj->name).
'</td>'.
"\n";
519 print
'<td class="tdoverflowmax300">';
521 if (empty($dolibarr_main_prod)) {
522 print
'<!-- '.$obj->value.
' -->';
529 if (empty($conf->multicompany->enabled) || !$user->entity) {
530 print
'<td class="center" width="80px">'.$obj->entity.
'</td>'.
"\n";