<?php
session_start();
include_once 'dbconnect.php';
if(!isset($_SESSION['user'])) {
  header("Location: index.php");
}

// ユーザーIDからユーザー名を取り出す
$query = "SELECT * FROM users WHERE user_id=".$_SESSION['user']."";
$result = $mysqli->query($query);

//$result = $mysqli->query($query);
if (!$result) {
  print('クエリーが失敗しました。' . $mysqli->error);
  $mysqli->close();
  exit();
}

$query = "UPDATE users SET hostuser = NOW() WHERE user_id=".$_SESSION['user']."";

$mysqli->query($query);

// ユーザー情報の取り出し
while ($row = $result->fetch_assoc()) {
	if($row['M11']=='finish'){
		$m11 = "〇"; 
	}else{
		$m11 = "―";
	}
	if($row['M12']=='finish'){
		$m12 = "〇"; 
	}else{
		$m12 = "―";
	}
	if($row['M21']=='finish'){
		$m21 = "〇"; 
	}else{
		$m21 = "―";
	}
	if($row['M22']=='finish'){
		$m22 = "〇"; 
	}else{
		$m22 = "―";
	}
	if($row['M31']=='finish'){
		$m31 = "〇"; 
	}else{
		$m31 = "―";
	}
	if($row['M32']=='finish'){
		$m32 = "〇"; 
	}else{
		$m32 = "―";
	}
	if($row['M41']=='finish'){
		$m41 = "〇"; 
	}else{
		$m41 = "―";
	}
	if($row['M42']=='finish'){
		$m42 = "〇"; 
	}else{
		$m42 = "―";
	}
	if($row['M51']=='finish'){
		$m51 = "〇"; 
	}else{
		$m51 = "―";
	}
	if($row['M52']=='finish'){
		$m52 = "〇"; 
	}else{
		$m52 = "―";
	}
	if($row['M13']=='clear'){
		$m13 = "〇"; 
	}else if($row['M13']=='nonclear'){
		$m13 = "×";
	}else{
		$m13 = "―";
	}
	if($row['M23']=='clear'){
		$m23 = "〇"; 
	}else if($row['M23']=='nonclear'){
		$m23 = "×";
	}else{
		$m23 = "―";
	}
	if($row['M33']=='clear'){
		$m33 = "〇"; 
	}else if($row['M33']=='nonclear'){
		$m33 = "×";
	}else{
		$m33 = "―";
	}
	if($row['M43']=='clear'){
		$m43 = "〇"; 
	}else if($row['M43']=='nonclear'){
		$m43 = "×";
	}else{
		$m43 = "―";
	}
	if($row['M53']=='clear'){
		$m53 = "〇"; 
	}else if($row['M53']=='nonclear'){
		$m53 = "×";
	}else{
		$m53 = "―";
	}
	if($row['test0']==0){
		header("Location:test0.html");
//	}else if($row['last']!='no'){
//		$href = "Location:".$row['last'];
//		header($href);
	}
}
// データベースの切断
$result->close();
?>

<!DOCTYPE HTML>
<html lang="ja">
<head>
<!-- Google Tag Manager -->
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-WTLMKDG2');</script>
<!-- End Google Tag Manager -->
<!-- Google tag (gtag.js) -->
<script async src="https://www.googletagmanager.com/gtag/js?id=G-BWEB67BN7H"></script>
<script>
  window.dataLayer = window.dataLayer || [];
  function gtag(){dataLayer.push(arguments);}
  gtag('js', new Date());

  gtag('config', 'G-BWEB67BN7H');
</script>
<!--<meta charset="utf-8" />-->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!--<meta name="viewport" content="width=device-width, initial-scale=1">-->
<title>学習項目一覧</title>
<script>
if(window==top.window) location.href="../../";
</script>
<!--<link rel="stylesheet" href="style.css">-->
<!-- Bootstrap読み込み（スタイリングのため） -->
<!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">-->
</head>
</head>
<body>
<!-- Google Tag Manager (noscript) -->
<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WTLMKDG2"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<!-- End Google Tag Manager (noscript) -->
<div class="col-xs-6 col-xs-offset-3">
<br>
<div align="center"><font size=6>学習項目一覧</font><br><br>
<font size=5>
<table align="center" border=3>
<thead style="background:#ffccff">
<tr>
	<th>項目</th>
	<th>基礎知識編</th>
	<th>ストーリー編</th>
	<th>テスト編</th>
</tr>
</thead>
<tbody>
<tr>
	<td><a href="pswd/main.php">①パスワード設定</a></td>
	<td><?php echo $m41; ?></td>
	<td><?php echo $m42; ?></td>
	<td><?php echo $m43; ?></td>
</tr>
<tr>
	<td><a href="mail/main.php">②メール利用</a></td>
	<td><?php echo $m31; ?></td>
	<td><?php echo $m32; ?></td>
	<td><?php echo $m33; ?></td>
</tr>
<tr>
	<td><a href="web/main.php">③ウェブ利用</a></td>
	<td><?php echo $m51; ?></td>
	<td><?php echo $m52; ?></td>
	<td><?php echo $m53; ?></td>
</tr>
<tr>
	<td><a href="information/main.php">④情報漏洩</a></td>
	<td><?php echo $m21; ?></td>
	<td><?php echo $m22; ?></td>
	<td><?php echo $m23; ?></td>
</tr>
<tr>
	<td><a href="incident/main.php">⑤インシデント対応</a></td>
	<td><?php echo $m11; ?></td>
	<td><?php echo $m12; ?></td>
	<td><?php echo $m13; ?></td>
</tr>
</tbody>
</table>
〇：学習済み/合格，―：未学習，×：不合格<br>
<a href="last.php">前回の学習項目へ</a>
<br><a href="question.html">アンケート</a><br>
<Hr><!-- <br> -->
このページはCookieを利用して進捗状況等を管理しています。<br>
Cookieが無効の場合は学習状況表示が全て未学習になり，<br>
前回の続きから学習する機能は利用できません。<br><Hr><!-- <br> -->
参考サイト<br>
<p class="text">
〇　IPA 5分でできる！自社診断シート<br>
　　<u>https://www.ipa.go.jp/security/manager/know/sme-guide/sme-shindan.html</u><br>
〇　無線LANのメール丸見え　成田・関西・神戸の3空港<br>
　　<u>https://www.nikkei.com/article/DGXLASDG2600E_W4A820C1CR0000/</u><br>
〇　中小企業の情報セキュリティ対策ガイドライン<br>
　　<u>https://www.ipa.go.jp/security/keihatsu/sme/guideline/</u><br>
〇　2016年情報セキュリティインシデントに関する調査報告書～個人情報漏えい～<br>
　　<u>https://www.jnsa.org/result/incident/data/2016incident_survey_ver1.2.pdf</u><br>
</div>
</div>
</body>
</html>