<?php

if(!defined('WAMPTRACE_PROCESS')) require 'config.trace.php';
if(WAMPTRACE_PROCESS) {
	$errorTxt = "script ".__FILE__;
	$iw = 1; while(!empty($_SERVER['argv'][$iw])) {$errorTxt .= " ".$_SERVER['argv'][$iw];$iw++;}
	error_log($errorTxt."\n",3,WAMPTRACE_FILE);
}

// Versions of MariaDB
// Already done in refresh.php
//$mariadbVersionList = listDir($c_mariadbVersionDir,'checkMariaDBConf','mariadb');
if(count($mariadbVersionList) == 0) {
	error_log("No version of MariaDB is installed.");
	$glyph = '19';
	$WarningsAtEnd = true;
	$WarningText .= 'Type: item; Caption: "No version of MariaDB is installed"; Glyph: '.$glyph.'; Action:  none
';
}
else {
//MariaDB submenu
$typebase = 'mariadb';
$myPattern = ';WAMPMARIADBMENUSTART';
$DBMSFooter = '';
if($nbDBMS > 1 && $DBMSdefault !== 'mariadb') {
	$DBMSFooter = <<< EOF
Type: separator; Caption: "{$w_defaultDBMS} {$DefaultDBMS}"
Type: item; Caption: "{$w_help} -> MariaDB - MySQL"; Action: run; Filename: "%Windows%\Notepad.exe"; Parameters: "%AeTrayMenuPath%\mariadb_mysql.txt"; ShowCmd: Normal; Glyph: 31
EOF;
	$DBMSHeader = <<< EOF
Type: separator; Caption: "MariaDB {$c_mariadbVersion}"
EOF;
}
else {
	$DBMSHeader = <<< EOF
Type: separator; Caption: "MariaDB {$c_mariadbVersion}  ({$w_defaultDBMS})"
EOF;
}$myreplace = <<< EOF
;WAMPMARIADBMENUSTART
{$DBMSHeader}
Type: submenu; Caption: "{$w_version}"; SubMenu: mariadbVersion; Glyph: 3
Type: servicesubmenu; Caption: "{$w_service} '{$c_mariadbService}'"; Service: {$c_mariadbService}; SubMenu: mariadbService
Type: submenu; Caption: "{$w_mariaSettings}"; SubMenu: mariadb_params; Glyph: 25
Type: item; Caption: "{$w_mariadbConsole}"; Action: run; FileName: "{$c_mariadbConsole}";Parameters: "-u %MariaUser% -p"; Glyph: 0
Type: separator; Caption: "{$w_helpFile}";
Type: item; Caption: "my.ini"; Glyph: 6; Action: run; FileName: "{$c_editor}"; parameters: "{$c_mariadbConfFile}"
Type: item; Caption: "{$w_mariadbLog}	({$logFilesSize['mariadb.log']})"; Glyph: 6; Action: run; FileName: "{$c_logviewer}"; parameters: "{$c_installDir}/{$logDir}mariadb.log"
Type: item; Caption: "{$w_mariadbDoc}"; Action: run; FileName: "{$c_navigator}"; Parameters: "{$c_edge}http://mariadb.com/kb/en/mariadb/documentation"; Glyph: 35
{$MariaTestPortUsed}Type: separator; Caption: "{$w_portUsedMaria}{$c_UsedMariaPort}"
{$TestPort3306}{$MariaTestPortUsed}Type: item; Caption: "{$w_testPortMysql}"; Action: run; FileName: "{$c_phpExe}"; Parameters: "testPort.php 3306 {$c_mariadbService}";WorkingDir: "$c_installDir/scripts"; Flags: waituntilterminated; Glyph: 24
{$MariaTestPortUsed}Type: item; Caption: "{$w_AlternateMariaPort}"; Action: multi; Actions: UseAlternateMariaPort; Glyph: 24
{$MariaTestPortUsed}Type: item; Caption: "{$w_testPortMariaUsed}{$c_UsedMariaPort}"; Action: run; FileName: "{$c_phpExe}"; Parameters: "testPort.php {$c_UsedMariaPort} {$c_mariadbService}";WorkingDir: "$c_installDir/scripts"; Flags: waituntilterminated; Glyph: 24
{$DBMSFooter}
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

// MariaDB submenu Service
$myPattern = ';WAMPMARIADBSERVICESTART';
$myreplace = <<< EOF
;WAMPMARIADBSERVICESTART
[MariaDBService]
Type: separator; Caption: "MariaDB"
Type: item; Caption: "{$w_startResume}"; Action: service; Service: {$c_mariadbService}; ServiceAction: startresume; Flags: ignoreerrors waituntilterminated; Glyph: 9
Type: item; Caption: "{$w_stopService}"; Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: ignoreerrors waituntilterminated; Glyph: 11
Type: item; Caption: "{$w_restartService}"; Action: service; Service: {$c_mariadbService}; ServiceAction: restart; Flags: ignoreerrors waituntilterminated; Glyph: 12
Type: separator
Type: item; Caption: "{$w_installService}"; Action: multi; Actions: MariaDBServiceInstall; Glyph: 8
Type: item; Caption: "{$w_removeService}"; Action: multi; Actions: MariaDBServiceRemove; Glyph: 26
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

$myPattern = ';WAMPMARIADBSERVICEINSTALLSTART';
$myreplace = <<< EOF
;WAMPMARIADBSERVICEINSTALLSTART
[MariaDBServiceInstall]
{$mariaMysqlService}Action: run; FileName: "{$c_mariadbExe}"; Parameters: "{$c_mariadbServiceInstallParams}"; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
{$mariaCmdScService}Action: run; FileName: "CMD"; Parameters: "/D /C sc create {$c_mariadbService} binpath=""{$c_mariadbExeAnti} --defaults-file={$c_mariadbConfFileAnti} {$c_mariadbService}"""; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
Action: resetservices
Action: readconfig
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

$myPattern = ';WAMPMARIADBSERVICEREMOVESTART';
$myreplace = <<< EOF
;WAMPMARIADBSERVICEREMOVESTART
[MariaDBServiceRemove]
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: ignoreerrors waituntilterminated
{$mariaMysqlService}Action: run; FileName: "{$c_mariadbExe}"; Parameters: "{$c_mariadbServiceRemoveParams}"; ShowCmd: hidden; Flags: waituntilterminated
{$mariaCmdScService}Action: run; FileName: "CMD"; Parameters: "/D /C sc delete {$c_mariadbService}"; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
Action: resetservices
Action: readconfig
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

// MariaDB use alternate port submenu
$myPattern = ';WAMPALTERNATEMARIAPORTSTART';
$myreplace = <<< EOF
;WAMPALTERNATEMARIAPORTSTART
[UseAlternateMariaPort]
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: ignoreerrors waituntilterminated
Action: run; FileName: "{$c_phpExe}"; Parameters: "switchMariaPort.php %MariaPort%";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated
{$Apache_Restart}
Action: service; Service: {$c_mariadbService}; ServiceAction: startresume; Flags: ignoreerrors waituntilterminated
Action: multi; Actions: refresh_readconfig; Flags:appendsection
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

//MariaDB console prompt submenu
if($MysqlMariaPromptBool) {
	$myPattern = ';WAMPMARIADBUSECONSOLEPROMPTSTART';
	$myreplace = <<< EOF
;WAMPMARIADBUSECONSOLEPROMPTSTART
[mariadbUseConsolePrompt]
Action: run; FileName: "{$c_phpExe}";Parameters: "switchWampParam.php mariadbUseConsolePrompt {$mariadbConsolePromptChange}"; WorkingDir: "$c_installDir/scripts"; Flags: waituntilterminated
Action: multi; Actions: apache_restart_refresh; Flags:appendsection
EOF;
	$tpl = str_replace($myPattern,$myreplace,$tpl);
}

//MariaDB Tools menu
$myPattern = ';WAMPMARIADBSUPPORTTOOLS';
$myreplace = <<< EOF
;WAMPMARIADBSUPPORTTOOLS
Type: separator; Caption: "{$w_portUsedMaria}{$c_UsedMariaPort}"
{$TestPort3306}Type: item; Caption: "{$w_testPortMysql}"; Action: run; FileName: "{$c_phpExe}"; Parameters: "testPort.php 3306 {$c_mariadbService}";WorkingDir: "$c_installDir/scripts"; Flags: waituntilterminated; Glyph: 24
{$MariaTestPortUsed}Type: item; Caption: "{$w_testPortMariaUsed}{$c_UsedMariaPort}"; Action: run; FileName: "{$c_phpExe}"; Parameters: "testPort.php {$c_UsedMariaPort} {$c_mariadbService}";WorkingDir: "$c_installDir/scripts"; Flags: waituntilterminated; Glyph: 24
Type: item; Caption: "{$w_AlternateMariaPort}"; Action: multi; Actions: UseAlternateMariaPort; Glyph: 24
{$MysqlMariaPrompt}Type: item; Caption: "{$w_settings['mariadbUseConsolePrompt']}: {$mariadbConsolePromptUsed}"; Glyph: 24; Action: multi; Actions: mariadbUseConsolePrompt
EOF;
$tpl = str_replace($myPattern,$myreplace,$tpl);

// ************************
$maPattern = ';WAMPMARIADBVERSIONSTART';
$mareplace = $maPattern."
";
$mareplacemenu = '';
foreach ($mariadbVersionList as $oneMariaDBVersion) {
	$count = 0;
  //File wamp/bin/mariadb/mariadbx.y.z/wampserver.conf
  $maConfile = $c_mariadbVersionDir.'/mariadb'.$oneMariaDBVersion.'/'.$wampBinConfFiles;
  unset($mariadbConf);
  include $maConfile;

	//Check name of the group [wamp...] under '# The MariaDB server' in my.ini file
	//    must be the name of the mariadb service.
	$maIniFile = $c_mariadbVersionDir.'/mariadb'.$oneMariaDBVersion.'/'.$mariadbConf['mariadbConfFile'];
	$maIniContents = file_get_contents($maIniFile);

	if(strpos($maIniContents, "[".$c_mariadbService."]") === false) {
		$maIniContents = preg_replace("/^\[wamp.*\].*\n/m", "[".$c_mariadbService."]\r\n", $maIniContents, 1, $count);
		if(!empty($maIniContents) && $count == 1) {
			write_file($maIniFile,$maIniContents);
			$mariaServer[$oneMariaDBVersion] = 0;
		}
		else { //The MariaDB server has not the same name as mariadb service
			$mariaServer[$oneMariaDBVersion] = -1;
		}
	}
	else
		$mariaServer[$oneMariaDBVersion] = 0;
	unset($maIniContents);

	if($oneMariaDBVersion === $wampConf['mariadbVersion'] && $mariaServer[$oneMariaDBVersion] == 0)
  	$mariaServer[$oneMariaDBVersion] = 1;

	if($mariaServer[$oneMariaDBVersion] == 1) {
    $mareplace .= 'Type: item; Caption: "'.$oneMariaDBVersion.'"; Action: multi; Actions:switchMariaDB'.$oneMariaDBVersion.'; Glyph: 13
';
	}
  elseif($mariaServer[$oneMariaDBVersion] == 0) {
    $mareplace .= 'Type: item; Caption: "'.$oneMariaDBVersion.'"; Action: multi; Actions:switchMariaDB'.$oneMariaDBVersion.'
';

    $mareplacemenu .= <<< EOF
[switchMariaDB{$oneMariaDBVersion}]
Action: closeservices; Flags: ignoreerrors
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: ignoreerrors waituntilterminated
Action: run; FileName: "CMD"; Parameters: "/D /C net stop {$c_mariadbService}"; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
{$mariaMysqlService}Action: run; FileName: "{$c_mariadbExe}"; Parameters: "{$c_mariadbServiceRemoveParams}"; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
{$mariaCmdScService}Action: run; FileName: "CMD"; Parameters: "/D /C sc delete {$c_mariadbService}"; ShowCmd: hidden; Flags: ignoreerrors waituntilterminated
Action: run; FileName: "{$c_phpCli}";Parameters: "switchMariaDBVersion.php {$oneMariaDBVersion}";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated
Action: run; FileName: "{$c_phpCli}";Parameters: "switchMariaPort.php {$c_UsedMariaPort}";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated

EOF;
		if(isset($mariadbConf['mariadbServiceCmd']) && $mariadbConf['mariadbServiceCmd'] == 'windows') {
			$binpath = str_replace('/','\\',$c_mariadbVersionDir.'/mariadb'.$oneMariaDBVersion.'/'.$mariadbConf['mariadbExeDir'].'/'.$mariadbConf['mariadbExeFile']);
			$default = str_replace('/','\\',$c_mariadbVersionDir.'/mariadb'.$oneMariaDBVersion.'/'.$mariadbConf['mariadbConfDir'].'/'.$mariadbConf['mariadbConfFile']);
			$mareplacemenu .= <<< EOF
Action: run; FileName: "CMD"; parameters: "/D /C sc create {$c_mariadbService} binpath=""{$binpath} --defaults-file={$default} {$c_mariadbService}"""; ShowCmd: hidden; Flags: waituntilterminated

EOF;
		}
		else {
			$mareplacemenu .= <<< EOF
Action: run; FileName: "{$c_mariadbVersionDir}/mariadb{$oneMariaDBVersion}/{$mariadbConf['mariadbExeDir']}/{$mariadbConf['mariadbExeFile']}"; Parameters: "{$mariadbConf['mariadbServiceInstallParams']}"; ShowCmd: hidden; Flags: waituntilterminated

EOF;
		}
		$mareplacemenu .= <<< EOF
Action: multi; Actions: mariadb_refresh_start; Flags:appendsection

EOF;
	}
}
$mareplace .= 'Type: submenu; Caption: " "; Submenu: AddingVersions; Glyph: 1

';
$tpl = str_replace($maPattern,$mareplace.$mareplacemenu,$tpl);
// ************************
// Before configuring MariaDB, we need to make sure that all directives
// in the my.ini file have the same syntax.
// Although we can use - or _ in any directive, to be able to handle
// them efficiently, it is better that in the my.ini file
// all directives use _ as in default_storage_engine=
$myIniFileContents = @file_get_contents($c_mariadbConfFile) or die ("my.ini file not found");
//Replace all - by _ in my.ini directives only at the left of = sign
if(preg_match_all('~^(;?[a-z]+-[a-z]+(?:-[a-z]*)*)=?.*\r?$~mi',$myIniFileContents,$matches) > 0) {
	$counts = 0;
	foreach($matches[1] as $value) {
		$myIniFileContents = str_replace($value,str_replace('-','_',$value),$myIniFileContents,$count);
		$counts += $count;
	}
	if($counts > 0) {
		write_file($c_mariadbConfFile,$myIniFileContents);
	}
}
// ************************
// Configuration of MariaDB
// Retrieves the values of the [wampmariadb] or [wampmariadb64] section
$mariadbiniS = parse_ini_file($c_mariadbConfFile, true,INI_SCANNER_RAW);
$mariadbini = $mariadbiniS[$c_mariadbService];
// Retrieve the three values of port used
$MariadbPort['client'] = $mariadbiniS['client']['port'];
$MariadbPort[$c_mariadbService] = $mariadbiniS[$c_mariadbService]['port'];
$MariadbPort['mysqld'] =$mariadbiniS['mysqld']['port'];
// Check if three values are identical and equal to port used in wampmanager.conf
// $wampConf['mariaPortUsed']
if($MariadbPort['client'] <> $MariadbPort[$c_mariadbService] || $MariadbPort['client'] <> $MariadbPort['mysqld'] || $MariadbPort['mysqld'] <> $MariadbPort[$c_mariadbService]) {
	$WarningsAtEnd = true;
	$message = color('red',"\r\nThe three 'port=number' directives in the MariaDB my.ini file:\r\n[client], [".$c_mariadbService."], [mysqld]\r\ndo not have the same port number.\r\n");
	if($doReport)	$wampReport['gen2'] .= $message;
	$WarningText .= 'Type: item; Caption: "Not same MariaDB port"; Glyph: 19; Action: run; FileName: "'.$c_phpExe.'";Parameters: "msg.php 11 '.base64_encode($message).'";WorkingDir: "'.$c_installDir.'/scripts"; Flags: waituntilterminated
';
}
if($MariadbPort['client'] <> $wampConf['mariaPortUsed'] || $MariadbPort[$c_mariadbService] <> $wampConf['mariaPortUsed'] || $MariadbPort['mysqld'] <> $wampConf['mariaPortUsed']) {
	$WarningsAtEnd = true;
	$message = color('red',"\r\nThe three 'port=number' directives in the MariaDB my.ini file:\r\n[client], [".$c_mariadbService."], [mysqld]\r\ndo not have the port number defined in wampmanager.conf: mariaPortUsed\r\n");
	if($doReport)	$wampReport['gen2'] .= $message;
	$WarningText .= 'Type: item; Caption: "MariaDB port not equal"; Glyph: 19; Action: run; FileName: "'.$c_phpExe.'";Parameters: "msg.php 11 '.base64_encode($message).'";WorkingDir: "'.$c_installDir.'/scripts"; Flags: waituntilterminated
';
}

//Check if there is prompt directive into [mysql] section
if(!empty($mariadbiniS['mysql']['prompt'])) {
	$mariadbini += array('prompt' => $mariadbiniS['mysql']['prompt']);
	$mariadbPrompt = true;
}
else {
	$mariadbini += array('prompt' => 'default');
	$mariadbPrompt = false;
}

//Check if default sql_mode
if(!array_key_exists('sql_mode', $mariadbini))
	$mariadbini = $mariadbini + array('sql_mode' => 'default');

//Previously loaded $myIniFileContents = @file_get_contents($c_mariadbConfFile) or die ("my.ini file not found");
//Check if there is a commented or not user sql_mode
$UserSqlMode = (preg_match('/^[;]?sql_mode[ \t]*=[ \t]*"[^"].*$/m',$myIniFileContents) > 0 ? true : false);
//Check if skip_grant_tables is on (uncommented)
if(preg_match('/^skip_grant_tables[\r]?$/m',$myIniFileContents) > 0) {
	$mariadbini = $mariadbini + array('skip_grant_tables' => 'MariaDB On - !! WARNING !!');
}
if($wampConf['mariadbUseConsolePrompt'] == 'on') {
	if(!$mariadbPrompt) {
		//Add prompt = prompt = "\\h-\\v-['\\d']>" under [mysql] section
		$search = '[mysql]
';
		$add = "prompt = \"".str_replace('\\','\\\\', $wampConf['mariadbConsolePrompt'])."\"
";
		$myIniFileContents = str_replace($search, $search.$add, $myIniFileContents, $count);
		if($count > 0) {
			write_file($c_mariadbConfFile,$myIniFileContents);
			$mariadbini['prompt'] = str_replace('\\','\\\\', $wampConf['mariadbConsolePrompt']);
			$mariadbPrompt = true;
		}
	}
}
else {
	if($mariadbPrompt) {
		$myIniFileContents = preg_replace('~(\[mysql\][\r]?\n)prompt[ \t]*=[ \t]*".*"[\r]?\n~',"$1",$myIniFileContents, -1, $count);
		if($count > 0) {
			write_file($c_mariadbConfFile,$myIniFileContents);
			$mariadbini['prompt'] = "default";
			$mariadbPrompt = false;
		}
	}
}

unset($myIniFileContents);

$mariadbErrorMsg = array();
$mariadbParams = array_combine($mariadbParams,$mariadbParams);
foreach($mariadbParams as $next_param_name=>$next_param_text)
{
  if(isset($mariadbini[$next_param_text]))
  {
  	if(array_key_exists($next_param_name, $mariadbParamsNotOnOff)) {
  		if($mariadbParamsNotOnOff[$next_param_name]['change'] !== true) {
  	  	$params_for_mariadb[$next_param_name] = -2;
  	  	if(!empty($mariadbParamsNotOnOff[$next_param_name]['msg']))
  	  		$mariadbErrorMsg[$next_param_name] = "\n".$mariadbParamsNotOnOff[$next_param_name]['msg']."\n";
   	  	else
					$mariadbErrorMsg[$next_param_name] = "\nThe value of this MariaDB parameter must be modified in the file:\n".$c_mariadbConfFile."\nNot to change the wrong file, the best way to access this file is:\nWampmanager icon->MariaDB->my.ini\n";
  		}
  		else {
  	  	$params_for_mariadb[$next_param_name] = -3;
  	  	if($mariadbParamsNotOnOff[$next_param_name]['title'] == 'Special')
  	  		$params_for_mariadb[$next_param_name] = -4;
  		}
  	}
  	elseif(strtolower($mariadbini[$next_param_text]) == "off")
  		$params_for_mariadb[$next_param_name] = 'off';
  	elseif(strtolower($mariadbini[$next_param_text]) == "on")
  		$params_for_mariadb[$next_param_name] = 'on';
  	elseif($mariadbini[$next_param_text] == 0)
  		$params_for_mariadb[$next_param_name] = '0';
  	elseif($mariadbini[$next_param_text] == 1)
  		$params_for_mariadb[$next_param_name] = '1';
  	else
  	  $params_for_mariadb[$next_param_name] = -2;
  }
  else //Parameter in $mariadbParams (config.inc.php) does not exist in my.ini
    $params_for_mariadb[$next_param_name] = -1;
}

$mariadbConfText = ";WAMPMARIADB_PARAMSSTART
";
$mariadbConfTextInfo = $mariadbConfForInfo = "";
$action_sup = array();
$information_only = false;
foreach ($params_for_mariadb as $paramname=>$paramstatus) {
	if($params_for_mariadb[$paramname] == '1' || $params_for_mariadb[$paramname] == 'on') {
    $mariadbConfText .= 'Type: item; Caption: "'.$paramname.'"; Glyph: 13; Action: multi; Actions: maria_'.$mariadbParams[$paramname].'
';
	}
	elseif($params_for_mariadb[$paramname] == '0' || $params_for_mariadb[$paramname] == 'off') {
    $mariadbConfText .= 'Type: item; Caption: "'.$paramname.'"; Action: multi; Actions: maria_'.$mariadbParams[$paramname].'
';
	}
	elseif($params_for_mariadb[$paramname] == -2) { // I blue to indicate different from 0 or 1 or On or Off
		if(!$information_only) {
			$mariadbConfForInfo .= 'Type: separator; Caption: "'.$w_phpparam_info.'"
';
			$information_only = true;
		}
		if($paramname == 'skip_grant_tables') {
			$WarningsAtEnd = true;
			$WarningText .= 'Type: item; Caption: "'.$paramname.' = '.$mariadbini[$paramname].'"; Glyph: 19; Action: multi; Actions: maria_'.$mariadbParams[$paramname].'
';
		}
		if($seeInfoMessage) {
    	$mariadbConfForInfo .= 'Type: item; Caption: "'.$paramname.' = '.$mariadbini[$paramname].'"; Action: multi; Actions: maria_'.$mariadbParams[$paramname].'
';
		}
		else {
    	$mariadbConfForInfo .= 'Type: item; Caption: "'.$paramname.' = '.$mariadbini[$paramname].'"; Action:  none
';
		}
		if($doReport && ($paramname == 'basedir' || $paramname == 'datadir')) $wampReport['mariadb'] .= "\nMariaDB ".$paramname." = ".$mariadbini[$paramname];
	}
	elseif($params_for_mariadb[$paramname] == -3) { // Indicate different from 0 or 1 or On or Off but can be changed
		$action_sup[] = $paramname;
		$text = ($mariadbParamsNotOnOff[$paramname]['title'] == 'Number' ? ' - '.$mariadbParamsNotOnOff[$paramname]['text'][$mariadbini[$paramname]] : '');
		$mariadbConfText .= 'Type: submenu; Caption: "'.$paramname.' = '.$mariadbini[$paramname].$text.'"; Submenu: maria_'.$paramname.'; Glyph: 9
';
	}
	elseif($params_for_mariadb[$paramname] == -4) { // Indicate different from 0 or 1 or On or Off but can be changed with Special treatment
		$action_sup[] = $paramname;
		if($paramname == 'sql_mode') {
			$mariadbConfTextMode = '';
			$default_modes = array(
				'10.1' => array('NONE'),
				'10.2.3' => array('NO_ENGINE_SUBSTITUTION','NO_AUTO_CREATE_USER'),
				'10.2.4' => array('NO_ENGINE_SUBSTITUTION','STRICT_TRANS_TABLES','ERROR_FOR_DIVISION_BY_ZERO','NO_AUTO_CREATE_USER'),
				'valid' => array('ALLOW_INVALID_DATES','ANSI','ANSI_QUOTES','DB2','ERROR_FOR_DIVISION_BY_ZERO','HIGH_NOT_PRECEDENCE','IGNORE_BAD_TABLE_OPTIONS','IGNORE_SPACE','MAXDB','MSSQL','MYSQL323','MYSQL40','NO_AUTO_CREATE_USER','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','NO_DIR_IN_CREATE','NO_ENGINE_SUBSTITUTION','NO_FIELD_OPTIONS','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_UNSIGNED_SUBTRACTION','NO_ZERO_DATE','NO_ZERO_IN_DATE','ONLY_FULL_GROUP_BY','ORACLE','PAD_CHAR_TO_FULL_LENGTH','PIPES_AS_CONCAT','POSTGRESQL','REAL_AS_FLOAT','STRICT_ALL_TABLES','STRICT_TRANS_TABLES','TRADITIONAL'),
				);
				//Memorize default values
				if(version_compare($c_mariadbVersion, '10.2', '<'))
					$default_valeurs = $default_modes['10.1'];
				elseif(version_compare($c_mariadbVersion, '10.2.4', '>='))
					$default_valeurs = $default_modes['10.2.4'];
				else
					$default_valeurs = $default_modes['10.2.3'];

			if(empty($mariadbini['sql_mode'])) {
				$valeurs[0] = 'NONE';
				$m_valeur = 'none';
				$mariadbini['sql_mode'] = 'none';
      	$mariadbConfTextInfo .= 'Type: separator; Caption: "sql_mode: '.$w_mysql_none.'"
';
				$mariadbConfTextInfo .= 'Type: submenu; Caption: "'.$w_mysql_mode.'"; Submenu: mysql_mode; Glyph: 22
';
				$mariadbConfTextMode = 'Type: submenu; Caption: "'.$paramname.'"; Submenu: '.$paramname.$typebase.'; Glyph: 9
';
			}
			elseif($mariadbini['sql_mode'] == 'default') {
				$valeurs = $default_valeurs;
      	$mariadbConfTextInfo .= 'Type: separator; Caption: "sql_mode:  '.$w_mysql_default.'"
';
				$mariadbConfTextInfo .= 'Type: submenu; Caption: "'.$w_mysql_mode.'"; Submenu: mysql_mode; Glyph: 22
';
				$values = implode(' #13 ',$valeurs);
				$mariadbConfTextInfo .= 'Type: item; Caption: "'.$values.'"; Action: none
';
				$m_valeur = 'default';
				$mariadbConfTextMode = 'Type: submenu; Caption: "'.$paramname.'"; Submenu: '.$paramname.$typebase.'; Glyph: 9
';
			}
			else {
				$valeurs = explode(',',$mariadbini['sql_mode']);
				$valeurs = array_map('trim',$valeurs);
     		$mariadbConfTextInfo .= 'Type: separator; Caption: "sql_mode: '.$w_mysql_user.'"
';
				$mariadbConfTextInfo .= 'Type: submenu; Caption: "'.$w_mysql_mode.'"; Submenu: mysql_mode; Glyph: 22
';
				$MyUserError = false;
				foreach($valeurs as $val) {
					//Check if each user value is allowed
					if(in_array($val,$default_modes['valid'])) {
						$UserGlyph = '';
						$notValid = '';
					}
					else {
						$MyUserError = true;
						$UserGlyph = '; Glyph: 19';
						$notValid = ' - Not valid mode';
					}
					$mariadbConfTextInfo .= 'Type: item; Caption: "'.$val.$notValid.'"; Action:  none'.$UserGlyph.'
';
				}
				$m_valeur = 'user';
				$mariadbini['sql_mode'] = 'user';
				$mariadbConfTextMode = 'Type: submenu; Caption: "'.$paramname.'"; Submenu: '.$paramname.$typebase.'; Glyph: 9
';
			}
			$mariadbConfTextInfo .= $mariadbConfTextMode;
		}
		else {
			$mariadbConfText .= 'Type: submenu; Caption: "'.$paramname.' = '.$mariadbini[$paramname].'"; Submenu: maria_'.$paramname.$typebase.'; Glyph: 9
';
		}
	}
}
//Check for supplemtary actions
$MenuSup = $SubMenuSup = array();
if(count($action_sup) > 0) {
	$i = 0;
	foreach($action_sup as $action) {
		$MenuSup[$i] = $SubMenuSup[$i] = '';
		if($mariadbParamsNotOnOff[$action]['title'] == 'Special') {
			if($action == 'sql_mode') {
				$actionToDo = $actionName = $param_value = array();
				if($mariadbini['sql_mode'] == 'default') {
					if($UserSqlMode) {
						$actionToDo[] = 'user';
						$actionName[] = $w_mysql_user;
						$param_value[] = 'user';
					}
					$actionToDo[] = 'none';
					$actionName[] = $w_mysql_none;
					$param_value[] = 'none';
				}
				elseif($mariadbini['sql_mode'] == 'none') {
					if($UserSqlMode) {
						$actionToDo[] = 'user';
						$actionName[] = $w_mysql_user;
						$param_value[] = 'user';
					}
					$actionToDo[] = 'default';
					$actionName[] = $w_mysql_default;
					$param_value[] = 'default';
				}
				if($mariadbini['sql_mode'] == 'user') {
					$actionToDo[] = 'none';
					$actionName[] = $w_mysql_none;
					$param_value[] = 'none';
					$actionToDo[] = 'default';
					$actionName[] = $w_mysql_default;
					$param_value[] = 'default';
				}
				$MenuSup[$i] .= '[sql_mode'.$typebase.']
Type: separator; Caption: "sql_mode"
';
				for($j = 0 ; $j < count($actionToDo) ; $j++) {
					if($actionToDo[$j] == 'default') {
						$MenuSup[$i] .= <<< EOF

Type: separator; Caption: "MariaDB {$c_mariadbVersion}"
Type: separator; Caption: "sql_mode {$actionName[$j]} = "

EOF;
						$values = implode(' #13 ',$default_valeurs);
						$MenuSup[$i] .= 'Type: item; Caption: "'.$values.'"; Action: none
';
					}
				$MenuSup[$i] .= 'Type: item; Caption: "sql_mode -> '.$actionName[$j].'"; Action: multi; Actions: '.$action.$actionToDo[$j].$typebase.'
';
					$SubMenuSup[$i] .= <<< EOF
[{$action}{$actionToDo[$j]}{$typebase}]
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: waituntilterminated
Action: run; FileName: "{$c_phpExe}";Parameters: "changeMariadbParam.php noquotes {$action} {$param_value[$j]}";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated
Action: multi; Actions: mariadb_refresh_start; Flags:appendsection

EOF;
				}
			}
		}
		else {
			$MenuSup[$i] .= '[maria_'.$action.']
Type: separator; Caption: "'.$mariadbParamsNotOnOff[$action]['title'].'"
';
			$c_values = $mariadbParamsNotOnOff[$action]['values'];
			if($mariadbParamsNotOnOff[$action]['quoted'])
				$quoted = 'quotes';
			else
				$quoted = 'noquotes';
			foreach($c_values as $value) {
				if($value == $mariadbini[$action]) continue;
				$text = ($mariadbParamsNotOnOff[$action]['title'] == 'Number' ? " - ".$mariadbParamsNotOnOff[$action]['text'][$value] : "");
				$MenuSup[$i] .= 'Type: item; Caption: "'.$value.$text.'"; Action: multi; Actions: maria_'.$action.$value.'
';
				if(strtolower($value) == 'choose') {
					$param_value = '%'.$mariadbParamsNotOnOff[$action]['title'].'%';
					$param_third = ' '.$mariadbParamsNotOnOff[$action]['title'];
					$c_phpRun = $c_phpExe;
				}
				else {
					$param_value = $value;
					$param_third = '';
					$c_phpRun = $c_phpCli;
				}
				$SubMenuSup[$i] .= <<< EOF
[maria_{$action}{$value}]
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: waituntilterminated
Action: run; FileName: "{$c_phpRun}";Parameters: "changeMariadbParam.php {$quoted} {$action} {$param_value}{$param_third}";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated
Action: multi; Actions: mariadb_refresh_start; Flags:appendsection

EOF;
			}
		}
	$i++;
	}
}
$mariadbConfText .= $mariadbConfTextInfo.$mariadbConfForInfo;

foreach ($params_for_mariadb as $paramname=>$paramstatus) {
	if($params_for_mariadb[$paramname] == '1' || $params_for_mariadb[$paramname] == '0' || $params_for_mariadb[$paramname] == 'on' || $params_for_mariadb[$paramname] == 'off') {
		if($params_for_mariadb[$paramname] == '1' || $params_for_mariadb[$paramname] == '0')
			$SwitchAction = ($params_for_mariadb[$paramname] == '1' ? '0' : '1');
		else
			$SwitchAction = ($params_for_mariadb[$paramname] == 'on' ? 'off' : 'on');
  	$mariadbConfText .= <<< EOF
[maria_{$mariadbParams[$paramname]}]
Action: service; Service: {$c_mariadbService}; ServiceAction: stop; Flags: waituntilterminated
Action: run; FileName: "{$c_phpCli}";Parameters: "switchMariadbParam.php {$mariadbParams[$paramname]} {$SwitchAction}";WorkingDir: "{$c_installDir}/scripts"; Flags: waituntilterminated
Action: multi; Actions: mariadb_refresh_start; Flags:appendsection

EOF;
	}
  elseif($params_for_mariadb[$paramname] == -2)  {//Parameter is neither 'on' nor 'off'
  	$mariadbConfText .= '[maria_'.$mariadbParams[$paramname].']
Action: run; FileName: "'.$c_phpExe.'";Parameters: "msg.php 6 '.base64_encode($paramname).' '.base64_encode($mariadbErrorMsg[$paramname]).'";WorkingDir: "'.$c_installDir.'/scripts"; Flags: waituntilterminated
';
	}
}
if(count($MenuSup) > 0) {
	for($i = 0 ; $i < count($MenuSup); $i++)
		$mariadbConfText .= $MenuSup[$i].$SubMenuSup[$i];
}

$tpl = str_replace(';WAMPMARIADB_PARAMSSTART',$mariadbConfText,$tpl);
$TestPort3306 = ';';
unset($mariadbConfText,$mariadbConfTextInfo,$mariadbConfForInfo,$mariadbConfTextMode);
}

?>