
<!-- 
CREATE TABLE SYSC2004 LIKE SYSC2004;
CREATE TABLE SYSC2004_Feedback LIKE SYSC2004_Feedback;
CREATE TABLE SYSC2004_GroupAttempt LIKE SYSC2004_GroupAttempt;
CREATE TABLE SYSC2004_GroupProgress LIKE SYSC2004_GroupProgress;
CREATE TABLE SYSC2004_GroupProgress_Backup LIKE SYSC2004_GroupProgress_Backup;
CREATE TABLE SYSC2004_GroupTime_Backup LIKE SYSC2004_GroupTime_Backup;
CREATE TABLE SYSC2004_GroupTime LIKE SYSC2004_GroupTime;
CREATE TABLE SYSC2004_LabTimes LIKE SYSC2004_LabTimes;
INSERT INTO SYSC2004_LabTimes SELECT * FROM SYSC2004_LabTimes;
CREATE TABLE SYSC2004_UserLogin LIKE SYSC2004_UserLogin;


SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_AttemptLength';
    
SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_ExtraTime';


SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_GroupDetails';
    

SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_Ranking';
    

SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_Results';
    

SELECT  VIEW_DEFINITION 
    FROM    INFORMATION_SCHEMA.VIEWS
    WHERE   TABLE_SCHEMA    = 'dbs8840524' 
    AND     TABLE_NAME      = 'SYSC2004_UserLabTime';
    
CREATE VIEW SYSC2004_AttemptLength AS SELECT SYSC2004_GroupTime.GroupNumber AS GroupNumber, timediff(SYSC2004_GroupTime.TimeGroupEnded, SYSC2004_GroupTime.TimeGroupStarted) AS AttemptLength from SYSC2004_GroupTime group by SYSC2004_GroupTime.GroupNumber;
CREATE VIEW SYSC2004_Results AS select SYSC2004_GroupProgress.GroupNumber AS GroupNumber,(sum(SYSC2004_GroupProgress.CorrectAttempt) + sum(SYSC2004_GroupProgress.WrongAttempt)) AS NumAttempts,sum(SYSC2004_GroupProgress.CorrectAttempt) AS NumCorrect,sum(SYSC2004_GroupProgress.WrongAttempt) AS NumWrong from SYSC2004_GroupProgress group by SYSC2004_GroupProgress.GroupNumber;
CREATE VIEW SYSC2004_ExtraTime AS SELECT SYSC2004_AttemptLength.GroupNumber AS GroupNumber,SYSC2004_Results.NumAttempts AS NumAttempts,SYSC2004_Results.NumCorrect AS NumCorrect,SYSC2004_Results.NumWrong AS NumWrong,SYSC2004_AttemptLength.AttemptLength AS AttemptLength,(case when isnull(SYSC2004_AttemptLength.AttemptLength) then sec_to_time(0) when (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60))) then ((60 + ((3 - SYSC2004_Results.NumCorrect) * 5)) + (SYSC2004_Results.NumWrong * 2)) else (((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) end) AS ExtraTime,(case when isnull(SYSC2004_AttemptLength.AttemptLength) then sec_to_time(0) when ((SYSC2004_Results.NumCorrect = 3) and (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60)))) then addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((60 * 60) + ((SYSC2004_Results.NumWrong * 2) * 60)))) when (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60))) then addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((60 * 60) + ((((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) * 60)))) else addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) * 60))) end) AS AttemptWithPenalty from (dbs8840524.SYSC2004_Results join dbs8840524.SYSC2004_AttemptLength on((SYSC2004_AttemptLength.GroupNumber = SYSC2004_Results.GroupNumber))) where (SYSC2004_AttemptLength.AttemptLength is not null) order by (case when isnull(SYSC2004_AttemptLength.AttemptLength) then sec_to_time(0) when ((SYSC2004_Results.NumCorrect = 3) and (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60)))) then addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((60 * 60) + ((SYSC2004_Results.NumWrong * 2) * 60)))) when (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60))) then addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((60 * 60) + ((((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) * 60)))) else addtime(SYSC2004_AttemptLength.AttemptLength,sec_to_time(((((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) * 60))) end),(case when isnull(SYSC2004_AttemptLength.AttemptLength) then sec_to_time(0) when (SYSC2004_AttemptLength.AttemptLength < sec_to_time((30 * 60))) then ((60 + ((3 - SYSC2004_Results.NumCorrect) * 5)) + (SYSC2004_Results.NumWrong * 2)) else (((3 - SYSC2004_Results.NumCorrect) * 5) + (SYSC2004_Results.NumWrong * 2)) end);
CREATE VIEW SYSC2004_GroupDetails AS select distinct SYSC2004.GroupNumber AS GroupNumber,SYSC2004_GroupTime.GroupName AS GroupName from (SYSC2004_GroupTime join SYSC2004 on((SYSC2004.GroupNumber = SYSC2004_GroupTime.GroupNumber)));
CREATE VIEW SYSC2004_Ranking AS select distinct SYSC2004_GroupDetails.GroupNumber AS GroupNumber,SYSC2004_GroupDetails.GroupName AS GroupName,SYSC2004_ExtraTime.AttemptLength AS AttemptLength,SYSC2004_ExtraTime.NumWrong AS NumWrong,SYSC2004_ExtraTime.ExtraTime AS ExtraTime,SYSC2004_ExtraTime.AttemptWithPenalty AS AttemptWithPenalty from (SYSC2004_GroupDetails join SYSC2004_ExtraTime on((SYSC2004_GroupDetails.GroupNumber = SYSC2004_ExtraTime.GroupNumber))) order by SYSC2004_ExtraTime.AttemptWithPenalty,SYSC2004_ExtraTime.ExtraTime desc;
CREATE VIEW SYSC2004_UserLabTime AS select SYSC2004.StudentID AS StudentID,SYSC2004_LabTimes.Section AS Section,SYSC2004_LabTimes.LabStart AS LabStart,SYSC2004_LabTimes.LabEnd AS LabEnd from (SYSC2004_LabTimes join SYSC2004 on((SYSC2004_LabTimes.Section = convert(SYSC2004.Section using utf8))));

 -->
 
 
<!--INSERT INTO SYSC2004 VALUES(1234, "admin@mail.com", NULL, 0,NULL, NULL);-->
<!DOCTYPE HTML>
<!--
	Hielo by TEMPLATED
	templated.co @templatedco
	Released for free under the Creative Commons Attribution 3.0 license (templated.co/license)
-->
<html>
	<head>
		<title>SYSC2004 - Escape Room</title>
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1">
		<link rel="icon" type="image/x-icon" href="images/my_logo.jpg">
		<link rel="stylesheet" href="assets/css/main.css">
		<link rel="stylesheet" href="assets/css/new_main.css">
		<link rel="stylesheet" href="assets/css/image-zoom.css">
		<link rel="stylesheet" href="assets/css/beakers.css">
		<link rel="stylesheet" href="assets/css/lock.css">
		
		</head>
	<body>

<!-- Header -->
	<header id="header">
		<div class="logo">
			<a href="index.html">SYSC2004 - Escape Room </a><span>by Rami Sabouni</span>
			<!--
			<h3 id = 'timer'></h3>			-->
		</div> 
		<a href="#menu">Menu</a>
		
	</header>
	
	<!-- Nav -->
	
	<nav id="menu">
		<ul class="links">
			<li><a href="index.html">Home</a></li>

			<li><a href="SYSC4504_w24.php">SYSC4504 - Lab 01</a></li>
			<li>
				<ul class="links">
					<li><a href="SYSC4504_w24_game_result.php">SYSC4504 - W24 - Lab 01 - Results</a></li>
				</ul>
				<ul class="links">
					<li><a href="SYSC4504_game_result.php">SYSC4504 - W23 - Lab 01 - Results</a></li>
				</ul>
			</li>
			<li><a href="SYSC4504_Lab04.php">SYSC4504 - Lab 04</a></li>
			<li>
				<ul class="links">
					<li><a href="SYSC4504_Lab04_w24_game_result.php">SYSC4504 - W24 - Lab 04 - Results</a></li>
				</ul>
				<ul class="links">
					<li><a href="SYSC4504_Lab04_game_result.php">SYSC4504 - W23 - Lab 04 - Results</a></li>
				</ul>
			</li>
			<li><a href="SYSC2004.php">SYSC2004 - Lab 1</a></li>
			<li>
				<ul class="links">
					<li><a href="SYSC2004_game_result.php">SYSC2004 - S23 - Lab 1 - Results</a></li>
				</ul>
			</li>
			<li><a href="SYSC2004_Lab13.php">SYSC2004 - Lab 13</a></li>
			<li>
				<ul class="links">
					<li><a href="SYSC2004_Lab13_game_result.php">SYSC2004 - S23 - Lab 13 - Results</a></li>
				</ul>
			</li>
			
			<li><a href="RTOS.php">RTOS - Scheduling Exercise</a></li>
			
			<li>
				<ul class="links">
					<li><a href="RTOS_game_result.php">RTOS - Results</a></li>
				</ul>
			</li>
			<li><a href="ECOR1041_Winter2023.php">ECOR1041</a></li>
			<li>
				<ul class="links">
					<li><a href="ECOR1041_Winter2023_game_result.php">ECOR1041 - W23 - Results</a></li>
					<li><a href="ECOR1041_game_result.php">ECOR1041 - F22 - Results</a></li>
				</ul>
			</li>
			<li><a href="ECOR1042_Winter2023_review.php">ECOR1042</a></li>
			<li>
				<ul class="links">
					<li><a href="ECOR1042_Winter2023_review_game_result.php">ECOR1042 - W23 - Course Review - Results</a></li>
					<li><a href="ECOR1042_Winter2023_game_result.php">ECOR1042 - W23 - Lab02 - Results</a></li>
					<li><a href="ECOR1042_game_result.php">ECOR1042 - F22 - Results</a></li>
				</ul>
			</li>
			<li><a href="IPIS5509.php">IPIS5509</a></li>
			<li>
				<ul class="links">
						<li><a href="IPIS5509_game_results.php">IPIS5509 - F22 - Results</a></li>
				</ul>
			</li>
		</ul>
	</nav>
				
<!-- One -->
	<section id="One" class="wrapper style3">
		<div class="inner">
			<header class="align-center">
				<p>This is an Escape Room for</p>
				<h3>SYSC2004 - Lab 1</h3>
			</header>
		</div>
	</section>

<!-- Two -->
	<section id="two" class="wrapper style2">
		<div class="inner">
			<div class="box">
				<div class="content">
					<header class="align-center">
						<p>SYSC2004 - Lab 1 - Escape Room</p>
					
					<h3>Game Start</h3></header><h3>This escape room was designed for “SYSC2004 - Object Oriented Software Development” students to review some of the C concepts that were discussed in SYSC2006.</h3><h3>To start, enter your carleton email address (mc1@cmail.carleton.ca) and student ID.</h3>You must log in first
<!DOCTYPE html>
<html>
<body>
	<div>
		<h2>Login</h2>
	</div>
	
	<form method="post" action="SYSC2004.php">
			<div class="row uniform">
		<div class="6u$ 12u$(xsmall)">
			<b>Carleton email address</b> (MC1@cmail.carleton.ca): <input type="text" name="StudentEmail" >
		</div>
		<div class="6u$ 12u$(xsmall)">
			<b>Student ID:</b><input type="text" name="StudentID">
		</div>
		<div>
			<button type="submit" name="login_user">Login</button>
		</div>
		
		<!--<p>
			Not yet a member? <a href="SYSC2004.php?register=1">Sign up</a>
		</p>-->
	</div>
	</form>
</body>
</html>					<h3> <a href="SYSC2004.php?logout='1'" style="color: red;">logout</a> </h3>
				</div>
			</div>
		</div>
	</section>

<!-- Footer -->
	<footer id="footer">
		<div class="container">
			<ul class="icons">
				<li><a href="#" class="icon fa-twitter"><span class="label">Twitter</span></a></li>
				<li><a href="#" class="icon fa-facebook"><span class="label">Facebook</span></a></li>
				<li><a href="#" class="icon fa-instagram"><span class="label">Instagram</span></a></li>
				<li><a href="#" class="icon fa-envelope-o"><span class="label">Email</span></a></li>
			</ul>
		</div>
		<div class="copyright">
			&copy; All rights reserved for Dr. Rami Sabouni (rami.sabouni@carleton.ca)
		</div>
	</footer>

<!-- Scripts -->
	<script src="assets/js/jquery.min.js"></script>
	<script src="assets/js/jquery.scrollex.min.js"></script>
	<script src="assets/js/skel.min.js"></script>
	<script src="assets/js/util.js"></script>
	<script src="assets/js/main.js"></script>
	<script src="assets/js/functions.js"></script>
	<script src="assets/js/vendor/jquery.min.js" type="text/javascript"></script>
	<script src="assets/js/image-zoom.js" type="text/javascript"></script>
	<script src="assets/js/lock.js"></script>
	
	
	</body>
</html>