$db_connections = array (0=> array (
'name' => $con['name'],
'host' => $con['host'],
+ 'port' => $con['port'],
'dbname' => $con['dbname'],
'collation' => $con['collation'],
'tbpref' => $table_prefix,
if (!isset($_SESSION['inst_set'])) // default settings
$_SESSION['inst_set'] = array(
'host'=>'localhost',
+ 'port' => '', // 3306
'dbuser' => 'root',
'dbpassword' => '',
'username' => 'admin',
display_error(_('Host name cannot be empty.'));
set_focus('host');
}
+ elseif ($_POST['port'] != '' && !is_numeric($_POST['port'])) {
+ display_error(_('Database port have to be numeric or empty.'));
+ set_focus('port');
+ }
elseif ($_POST['dbuser']=='') {
display_error(_('Database user name cannot be empty.'));
set_focus('dbuser');
else {
$_SESSION['inst_set'] = array_merge($_SESSION['inst_set'], array(
'host' => $_POST['host'],
+ 'port' => $_POST['port'],
'dbuser' => $_POST['dbuser'],
- 'dbpassword' => $_POST['dbpassword'],
+ 'dbpassword' => @html_entity_decode($_POST['dbpassword'], ENT_QUOTES, $_SESSION['language']->encoding=='iso-8859-2' ? 'ISO-8859-1' : $_SESSION['language']->encoding),
'dbname' => $_POST['dbname'],
'tbpref' => $_POST['tbpref'] ? '0_' : '',
'sel_langs' => check_value('sel_langs'),
subpage_title(_('Database Server Settings'));
start_table(TABLESTYLE);
text_row_ex(_("Server Host:"), 'host', 30, 60);
+ text_row_ex(_("Server Port:"), 'port', 30, 60);
text_row_ex(_("Database Name:"), 'dbname', 30);
text_row_ex(_("Database User:"), 'dbuser', 30);
- text_row_ex(_("Database Password:"), 'dbpassword', 30);
+ password_row(_("Database Password:"), 'dbpassword', '');
collations_list_row(_("Database Collation:"), 'collation');
yesno_list_row(_("Use '0_' Table Prefix:"), 'tbpref', 1, _('Yes'), _('No'), false);
check_row(_("Install Additional Language Packs from FA Repository:"), 'sel_langs');
check_row(_("Install Additional COAs from FA Repository:"), 'sel_coas');
end_table(1);
+ display_note(_("Use database user/password with permissions to create new database, or use proper credentials for previously created empty database."));
display_note(_("Select collation you want to use. If you are unsure or you will use various languages, select unicode collation."));
display_note(_("Use table prefix if you share selected database for more than one FA company using the same collation."));
display_note(_("Do not select additional langs nor COAs if you have no working internet connection right now. You can install them later."));
+ display_note(_("Set Only Port value if you cannot use the default port 3306."));
submit_center_first('back', _('<< Back'));
submit_center_last('db_test', _('Continue >>'));
break;