<?php

$INCLUDE_PATH = '/home/karl/examit/php/include';

require "$INCLUDE_PATH/ez_sql.php";
require "$INCLUDE_PATH/globals.php";
require "$INCLUDE_PATH/DB.php";
require "$INCLUDE_PATH/future_codes.php";

$vCode = $_GET['questioncode'];
$id = $_GET['id'];
$vNotFound = false;

# $id should be a positive integer. Reject any ther pattern.
if (!preg_match('/^[0-9]+$/', $id)){
	$id = -1;
}

if (isset( $vCode)){ # retrieve doc via accesscode

	# $vCode should be a 6-character string. Reject any other pattern.
	if (!preg_match('/^[a-zA-Z]+$/', $vCode)){
		$vCode= "INVALID";
	}


	$vQuery = "SELECT docfragment_id, codetype_id FROM accesscode WHERE " .
					"accesscode.id LIKE '$vCode'";

	$vRow = $db->get_row($vQuery);

	# hack for future codes - if the code isn't found in the
	# DB but is one of our as-yet-unpublished future codes
	# show the special 'coming soon' page
	if (!is_object( $vRow)){
		if (isRedirectCode($vCode)){
			$vLocation = "https://edcoexampapers.ie/edco-exam-mobile-audio-app/";
		} else if (isFutureCode( $vCode)){
			$vLocation = "coming_soon.php?questioncode=" . $vCode;
		} else {
			$vReason = '';
			if (isExpiredCode( $vCode)){
				$vReason = '&reason=expired';
			} 
			else if (isProjectMathsCode( $vCode)){
				$vReason = '&reason=projectmaths';
			}	
			else if (isWithdrawnCode( $vCode)){
				$vReason = '&reason=withdrawn';
			}
			$vLocation = "not_found.php?questioncode=" . $vCode . $vReason;
		}
		header("Location: $vLocation\n\n");
	}     

	# as of Jan 2021, we have multiple types of codes in the accesscode table
  # type 1 = tutorial, type 2 = aural, type 3 = teacher PDF downloads
	# redirect to the appropriate handler page for each type.
  switch($vRow->codetype_id){
		case 2: # aural content
			$vLocation = "aural.php?questioncode=" . $vCode;
			header("Location: $vLocation\n\n");
			break;
		case 3: # teacher content - downloadable PDFs
			$vLocation = "teacher.php?questioncode=" . $vCode;
			header("Location: $vLocation\n\n");
			break;
		default:
			break;
  }

	# if we can't retrieve the portal ID from the DB, redirect to
	# the error page
	#if (!is_object( $vRow)){
		#$vLocation = "not_found.php?questioncode=" .$vCode;
		#header("Location: $vLocation\n\n");
	#}     

	$id = $vRow->docfragment_id;
}

# if we've gotten this far, the code is valid or the ID is defined. 
# Pull the tutorial info from the DB
if (isset($id)){ # retrieve doc via ID
	$vDocIDs = array(); // stores the IDs of related documents if available
	$vDocIDs['portal'] = $_GET['port'];
	$vDocIDs['preparatory'] = $_GET['prep'];
	$vDocIDs['solution'] = $_GET['soln'];
	$vDocIDs['tip'] = $_GET['tip'];

	# create link URLs for use in prep/ans/tip navigation section
	$vLinks = array();
	$vLinks['portal'] = sprintf("?id=%s&port=%s&prep=%s&soln=%s&tip=%s", 
					$vDocIDs['portal'], $vDocIDs['portal'], $vDocIDs['preparatory'], $vDocIDs['solution'], $vDocIDs['tip']);
	$vLinks['preparatory'] = sprintf("?id=%s&port=%s&prep=%s&soln=%s&tip=%s", 
					$vDocIDs['preparatory'], $vDocIDs['portal'], $vDocIDs['preparatory'], $vDocIDs['solution'], $vDocIDs['tip']);
	$vLinks['solution'] = sprintf("?id=%s&port=%s&prep=%s&soln=%s&tip=%s", 
					$vDocIDs['solution'], $vDocIDs['portal'], $vDocIDs['preparatory'], $vDocIDs['solution'], $vDocIDs['tip']);
	$vLinks['tip'] = sprintf("?id=%s&port=%s&prep=%s&soln=%s&tip=%s", 
					$vDocIDs['tip'], $vDocIDs['portal'], $vDocIDs['preparatory'], $vDocIDs['solution'], $vDocIDs['tip']);

	$vTypes = array( 
		"portal" => "Portal",
		"preparatory" => "Preparation",
		"solution" => "Answer",
		"tip" => "Smart Tips!"
	);

	// retrieve any images associated with this document
	$vSQL = "SELECT * FROM image_docfragment where docfragment_id='$id'";
	$vResults = $db->get_results($vSQL);

	// for each image associated with this doc, pull it out of the DB and
	// save it to disk
	if (is_array($vResults)){
		foreach ($vResults as $vRow){
			// if the image isn't in the cache we need to extract it from the DB
			// and put it in the image cache.
			if (!isImgCached($vRow->image_id)){
				$vSQL = "SELECT * FROM image where id='" . $vRow->image_id . "'";
				$vRow = $db->get_row($vSQL);
				if (is_object($vRow)){
					saveImage( $vRow->id, $vRow->mimetype, $vRow->data);
				}
			}
		}
	}

	$vSQL = "SELECT title, content, type, subquestion, subject_id FROM docfragment where id='$id'";
	$vRow = $db->get_row($vSQL);

	if (is_object($vRow)){
		$vTitle = $vRow->title;
		$subq = $vRow->subquestion;
		$vData = AddGlossaryInfo( $vRow->content, $vRow->subject_id);
		$vType = $vRow->type;
	} else {
		$vTitle = "could not find tutorial.";
		$vData = "Could not retrieve data for document ID=$id. Please contact the systems administrator.";
	}

	// for all kinds of content except the portal pages, we can
	// just spit the data straight out. For portals, we have to
	// generate a table with links to the appropriate prep, solution
	// and tips pages as well as the correct text description of
	// each question
	if ('portal' == $vType){
		$prep = array();
		$solution = array();
		$tip = array();
	
		if (false != getLinkedFiles( $id, $prep, $solution, $tip)){
			$vData = portalList2( $id, $vData, $prep, $solution, $tip);
			$vTypes['portal'] = $vTitle;
		} else {
			$vData = "No files linked for ID=$id.";
		}
	} 
}

?><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head> <?php 
	// we seem to have some non utf-8 chars in the DB, so best let the browser work this out.
	?>
			<meta http-equiv="Content-Type" content="text/html; charset=utf-8" > 
			<link rel="stylesheet" type="text/css" href="css/styles.css" >
			<script src="js/examit_utils.js?v=20160912"></script>
			<title><?= $vTitle; ?></title>
			<script type="text/javascript">
				$(document).ready(function(){
					setInterval(function(){rotateBanner("#banner_ad img");}, 30000);
				});     
				</script>
    </head>
    <body>
    <div id="container">
			<div id="banner_ad">
				<a href="http://revisewise.ie?src=e-xamit.ie" target="_blank" ><img src="img/top_banner_728_180.jpg" alt="ReviseWise" title="ReviseWise" /></a>
			</div>
	    <div id="nav">
	    	<ul>
	    		<li><a href="/">Home</a></li>
	    		<li><a href="help.html">Help</a></li>
	    		<li><a href="about.html">About</a></li>	
			<li><a href="contact.html">Contact</a></li> 
	    	</ul>
			<div>&nbsp;</div>
	    </div>
	    <div id="inner">
    		<div id="code" class="right">
    			Enter the code found on your <br />Edco Exam Papers here:
					<form action="tutorial.php" method="get">
						<input class="text" type="text" name="questioncode" maxlength="6" size="6" />
						<input type="submit" value="Go!" />
					</form>
			</div>	
			<div id="content"<?php if ('portal' == $vType) { ?> class="portal"<?php } ?> >
				<?php if ('portal' != $vType) { ?>
				<div class="left">
					<h2 class="tab">Question</h2>
					<div id="question" class="box small">
						<div class="top"></div>
						<div class="bg">
							<ul>
								<li>
									<?= $vTitle; ?>
								</li>
								<li class="last">
									<a href="<?= $vLinks['portal']; ?>" title="Go Back">Back to the question &gt;</a>
								</li>
							</ul>
						</div>
						<div class="bot"></div>
					</div>
				</div>
				<div id="nav_pat" class="right">
					<ul>
            <?php if ($vDocIDs['preparatory'] > 0) { ?>
						<li class="preparatory"><a title="preparation" href="<?= $vLinks['preparatory']; ?>"><span>preparation</span></a></li>
						<?php } ?>
						<li class="solution"><a title="answer" href="<?= $vLinks['solution']; ?>"><span>answer</span></a></li>
            <?php if ($vDocIDs['tip'] > 0) { ?>
						<li class="tip"><a title="smart tips" href="<?= $vLinks['tip']; ?>"><span>smart tips</span></a></li>
						<?php } ?>
					</ul>
				</div>
				<?php } ?>
				<div class="clear">
					<div class="box tutorial">
						<div class="icon <?= $vType; ?>"></div>
						<div class="top"></div>
						<div class="bg">
							<h3><?= $vTypes[$vType]; ?></h3>
							<div class="content">
								<?= $vData; ?>
							</div>
						</div>
						<div class="bot"></div>
					</div>
				</div>
			</div>
			<div id="disclaimer" class="clear">
				<ul>
					<li>Help us make e-xamit better - e-mail <a href="mailto:support@e-xamit.ie" title="support@e-xamit.ie">support</a> if you spot any errors!</li>
					<li>&nbsp;</li>
					<li>The content of this site is the intellectual property of e-xamit.ie</li>
					<li><a href="privacy.html" title="Legal and Privacy Information">Legal &amp; privacy information</a></li>
				</ul>
			</div>
		</div>
	</div>
	<div style="display:none">
		<script type="text/javascript">
			var gaJsHost = (("https:" == document.location.protocol) ?  "https://ssl." : "http://www.");
			document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
		</script>
		<script type="text/javascript">
			try {
				var pageTracker = _gat._getTracker("UA-11336401-1");
				pageTracker._trackPageview();
			} catch(err) {}
		</script>
	</div>
    </body>
</html>