<?php
/*************************************
 * SPDX-FileCopyrightText: 2009-2020 Vtenext S.r.l. <info@vtenext.com>
 * SPDX-License-Identifier: AGPL-3.0-only
 ************************************/
session_start();

if(empty($_SESSION['authentication_key'])) {
	die($installationStrings['ERR_NOT_AUTHORIZED_TO_PERFORM_THE_OPERATION']);
}
if($_REQUEST['ajax'] == true) {
	if($_SESSION['authentication_key'] != $_REQUEST['auth_key']) {
		die($installationStrings['ERR_NOT_AUTHORIZED_TO_PERFORM_THE_OPERATION']);
	}	
}

$configFileInfo = $_SESSION['config_file_info'];

require_once('adodb/adodb.inc.php');

$db = &NewADOConnection($configFileInfo['db_type']);
$db->NConnect($configFileInfo['db_hostname'], $configFileInfo['db_username'], $configFileInfo['db_password'], $configFileInfo['db_name']);

require_once('include/utils/DBHealthCheck.php');
$dbHealthCheck = new DBHealthCheck($db);
$dbHostName = $dbHealthCheck->dbHostName;
$dbName = $dbHealthCheck->dbName;
if(!empty($_REQUEST['forceDbCheck']) || $_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] != true) {
	// function to update  engine type of table if parameter is prowided otherwise update all
	if($_REQUEST['updateTableEngine'] == true) {
		 if(!empty($_REQUEST['updateEngineForTable'])) {
		 	$dbHealthCheck->updateTableEngineType(htmlentities($_REQUEST['updateEngineForTable']));
		 }
		 elseif($_REQUEST['updateEngineForAllTables'] == true) {
		 	$dbHealthCheck->updateAllTablesEngineType();
		 }
	}

	$unHealthyTablesList = $dbHealthCheck->getUnhealthyTablesList();
	$noOfTables = count($unHealthyTablesList);
	if ($noOfTables <= 0) {
		$_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] = true;
		if($_REQUEST['ajax'] == true) {
			echo "TABLE_TYPE_FIXED";
		}
	} else {		
		$_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] = false;
	}
}

if ($_REQUEST['viewDBReport'] == true) {
	if($_SESSION['authentication_key'] != $_REQUEST['auth_key']) {
		die($installationStrings['ERR_NOT_AUTHORIZED_TO_PERFORM_THE_OPERATION']);
	}
	$auth_key = $_REQUEST['auth_key'];
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<title><?php echo $installationStrings['LBL_VTE_CRM']. ' - ' . $installationStrings['LBL_DATABASE_CHECK']; ?></title>
	<link REL="SHORTCUT ICON" HREF="<?php echo get_logo_install('favicon'); ?>">	<!-- crmv@18123 -->
	<link href="include/install/install.css" rel="stylesheet" type="text/css">
	<script type='text/javascript'>
	function correctTableEngineType(tableName) {
		var form = document.updateForm;
		form.updateEngineForTable.value = tableName;
		form.submit();
	}
	</script>
</head>
<body class="small cwPageBg">
	<div style="height: 30em">
		<table width="99%" cellspacing="0" cellpadding="0" border="0" align="center">
			<tr>
				<td align="left" class="cwHeadBg heading2">&nbsp;<?php echo $installationStrings['LBL_DATABASE_CHECK']; ?></td>
				<!-- crmv@18123 -->
				<td class="cwHeadBg1" align=right style="padding-right:10px;"><img src="<?php echo get_logo_install('header'); ?>" alt="<?php echo $enterprise_mode.' '.$enterprise_current_version. ' (build ' .$enterprise_current_build. ') '; ?>" title="<?php echo $enterprise_mode.' '.$enterprise_current_version. ' (build ' .$enterprise_current_build. ') '; ?>"></td>
				<!-- crmv@18123e -->
			</tr>
		</table>
		<table cellpadding="10" cellspacing="0" border="0" width="99%" height="45%" align="center">
			<tr>
				<td background="include/install/images/installbg.png" align="center" class="small">				
					<?php if($_SESSION[$dbName.'_'.$dbHostName.'_HealthApproved'] == true) { ?>
					<table class="cwContentDisplay" cellpadding="10" cellspacing="10" border="0" width="97%" style="height: 100%" align="center">
						<tr>
							<td class="contentDisplay">
								<div class="textCenter higherLineHeight">
									<?php echo $installationStrings['MSG_TABLES_IN_INNODB']; ?>.<br />	
									<?php echo $installationStrings['MSG_CLOSE_WINDOW_TO_PROCEED']; ?>.<br />							
									<input type="button" class="small edit" value="<?php echo $installationStrings['LBL_CLOSE']; ?>" name="Close" onClick="window.close()" />
								</div>
							</td>
						</tr>
					</table>
					<?php } else { ?>
					<table class="cwContentDisplay" cellpadding="10" cellspacing="10" border="0" width="97%" align="center">
						<tr>
							<td class="contentDisplay">
								<div>
									<?php echo $installationStrings['LBL_RECOMMENDATION_FOR_PROPERLY_WORKING_CRM']; ?>:					
									<ul>
								    	<li><?php echo $installationStrings['LBL_TABLES_SHOULD_BE_INNODB']; ?>. ( <a href="http://dev.mysql.com/doc/refman/5.0/en/innodb.html" target="_about"><?php echo $installationStrings['QUESTION_WHAT_IS_INNODB']; ?>?</a>).<br/></li>
								    	<li><?php echo $installationStrings['LBL_TABLES_CHARSET_TO_BE_UTF8']; ?>.<br/></li>
									</ul>
								</div>
							</td>
						</tr>
					</table>	 
					<table class="cwContentDisplay" cellpadding="10" cellspacing="0" border="0" width="97%" align="center">
						<tr>
							<td>
								<table cellpadding="0" cellspacing="0" border="0" width="95%" align="center">
									<tr>
										<td align="right">
											<form action="install.php" name="submitForm">
												<input type="hidden" name="file" value="VerifyDBHealth.php" />
												<input type="hidden" name="viewDBReport" value="true" />
												<input type="hidden" name="auth_key" value="<?php echo $auth_key; ?>" />
												<input type="hidden" name="updateTableEngine" value="true" />
												<input type="hidden" name="updateEngineForAllTables" value="true" />
												<input align="right" class="small edit" type="button" name="fix" title="<?php echo $installationStrings['LBL_FIX_ENGINE_FOR_ALL_TABLES']; ?>" value="<?php echo $installationStrings['LBL_FIX_ENGINE_FOR_ALL_TABLES']; ?>" onclick="document.submitForm.submit();" />
											</form>
											<form action='install.php' name='updateForm'>
												<input type='hidden' name='file' value='VerifyDBHealth.php' />
												<input type="hidden" name="viewDBReport" value="true" />
												<input type='hidden' name='auth_key' value='<?php echo $auth_key; ?>' />
												<input type='hidden' name='updateTableEngine' value='true' />
												<input type='hidden' name='updateEngineForTable' value='' />
											</form>
										</td>
									</tr>
								</table>
							</td>
						</tr>
						<tr>
							<td>
								<table id="unhealthyTablesList" width="95%" border="0px" cellpadding="3" cellspacing="0" align="center">
									<tr>
										<td class="fontBold small"><?php echo $installationStrings['LBL_TABLE']; ?></td>
										<td class="fontBold small"><?php echo $installationStrings['LBL_CHARACTER_SET']; ?></td>
										<td class="fontBold small"><?php echo $installationStrings['LBL_TYPE']; ?></td>
									</tr>
									<?php for($i=0; $i<$noOfTables; ++$i) {
											$tableName = $unHealthyTablesList[$i]['name'];
											$engineType = $unHealthyTablesList[$i]['engine'];
											$characterSet = $unHealthyTablesList[$i]['characterset'];
									?>
									<tr>
										<td><?php echo $tableName; ?></td>
										<td><?php echo $characterSet; ?></td>
										<td><font style='color:red;'><?php echo $engineType; ?></font>&nbsp;&nbsp;(<a href='javascript:correctTableEngineType("<?php echo $tableName; ?>");' title='<?php echo $installationStrings['LBL_CORRECT_ENGINE_TYPE']; ?>'  style='cursor:pointer;'><?php echo $installationStrings['LBL_FIX_NOW']; ?></a>)</td>
									</tr>
									<?php } ?>
								</table>
								<?php } ?>
							</td>
						</tr>
					</table>
				</td>
			</tr>
		</table>
	</div>
</body>
</html>
<?php } ?>