<?php
require './security.php';
include_once '../scripts/DBAccess.php';
$constellationResult = DBAccess::getConstellations();
$rows = count($constellationResult, 0);
$title = 'Constellations';
$head = '';
$content = " <h1 class=\"heading\">Manage Constellations</h1>\t\n\n<div class='container'>\n<table class=\"eventsTable\" cellspacing=\"0\">\n<tr>\n<th class=\"width20\" >Name</th>\n<th class=\"width50\" >Description</th>\n<th class=\"width20\" >Cartoon</th>\n<th class=\"width10\" >Count</th>\n</tr>\n";
for ($i = 0; $i < $rows; $i++) {
$starPairResult = DBAccess::getStarPairs($constellationResult[$i]['ConstellationID']);
$count = count($starPairResult, 0);
$content = $content . "\n\n\t<tr>\n\t<td class=\"conRow\" >" . $constellationResult[$i]['ConstellationName'] . "</td> \n\t<td class=\"conRow\" >" . $constellationResult[$i]['ConstellationDescription'] . "</td> \n\t<td class=\"conRow\" ><img class=\"width100\" alt=\"Picture of " . $constellationResult[$i]['ConstellationName'] . "\" src=\"" . $constellationResult[$i]['ConstellationCartoon'] . "\" /></td> \n\t<td class=\"conRow centre\" >" . $count . "</td> \n\t<tr /> \n\t\n\t";
}
$content = $content . "\t\n</table></div>";
require '../template/adminTemplate.php';
<?php
include_once './DBAccess.php';
$method = $_GET['method'];
if ($method = 'star-game') {
$fired = false;
//Get the actual constellation to guess
$conResult = DBAccess::getAllConstellationPresent();
$rows = count($conResult, 0);
$randomNumber = mt_rand(0, $rows - 1);
//$randomNumber = $randomNumber * date('s');
//$randomNumber = $randomNumber % ($rows - 1);
$StarPairResult = DBAccess::getStarPairs($conResult[$randomNumber]['ConstellationID']);
$starRows = count($StarPairResult, 0);
$randomPairNo = mt_rand(0, $starRows - 1);
$total = $starRows - 1;
$pictureReal = DBAccess::getPictureByPictureID($StarPairResult[$randomPairNo]['StarPictureID'], NULL);
$pictureLine = DBAccess::getPictureByPictureID($StarPairResult[$randomPairNo]['LinePictureID'], TRUE);
$targetConID = $conResult[$randomNumber]['ConstellationID'];
//Constellation Target
$starID = $StarPairResult[$randomPairNo]['StarPictureID'];
$hash = sha1($targetConID);
$correctAnswer = "";
//Image Details
echo $pictureReal[0]['PictureImage'] . ",";
echo $conResult[$randomNumber]['ConstellationCartoon'] . ",";
$description = $conResult[$randomNumber]['ConstellationDescription'] . ",";
$name = $conResult[$randomNumber]['ConstellationName'];
echo $hash . ", ";
$correctAnswer .= $name . ",";
$correctAnswer .= $targetConID . ",";
