<?php
/*
    DOKEOS - elearning and course management software

    For a full list of contributors, see documentation/credits.html

    This program is free software; you can redistribute it and/or
    modify it under the terms of the GNU General Public License
    as published by the Free Software Foundation; either version 2
    of the License, or (at your option) any later version.
    See "documentation/licence.html" more details.

    Contact:
		Dokeos
		Rue des Palais 44 Paleizenstraat
		B-1030 Brussels - Belgium
		Tel. +32 (2) 211 34 56
*/


/**
*	This file generates the ActionScript variables code used by the HotSpot .swf
*	@package dokeos.exercise
* 	@author Toon Keppens
* 	@version $Id: admin.php 10680 2007-01-11 21:26:23Z pcool $
*/


include('exercise.class.php');
include('question.class.php');
include('answer.class.php');
include('../inc/global.inc.php');

// set vars
$userId        = $_user['user_id'];
$questionId    = $_GET['modifyAnswers'];
$exe_id    = $_GET['exe_id'];
$from_db = isset($_GET['from_db']) ? $_GET['from_db'] : 0;
$objQuestion = Question :: read($questionId);
$TBL_ANSWERS   = Database::get_course_table(TABLE_QUIZ_ANSWER);
$documentPath  = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document';

$picturePath   = $documentPath.'/images';
$pictureName   = $objQuestion->selectPicture();
$pictureSize   = getimagesize($picturePath.'/'.$objQuestion->selectPicture());
$pictureWidth  = $pictureSize[0];
$pictureHeight = $pictureSize[1];

$courseLang = $_course['language'];
$courseCode = $_course['sysCode'];
$coursePath = $_course['path'];

// Query db for answers
$sql = "SELECT id, answer, hotspot_coordinates, hotspot_type FROM $TBL_ANSWERS WHERE question_id = '$questionId' ORDER BY id";
$result = api_sql_query($sql,__FILE__,__LINE__);

// Init
$output = "hotspot_lang=$courseLang&hotspot_image=$pictureName&hotspot_image_width=$pictureWidth&hotspot_image_height=$pictureHeight&courseCode=$coursePath";
$i = 0;

while ($hotspot = mysql_fetch_array($result))
{
	$output .= "&hotspot_".$hotspot['id']."=true";
	// Square or rectancle
	if ($hotspot['hotspot_type'] == 'square' )
	{
		$output .= "&hotspot_".$hotspot['id']."_type=square";
	}

	// Circle or ovale
	if ($hotspot['hotspot_type'] == 'circle')
	{
		$output .= "&hotspot_".$hotspot['id']."_type=circle";
	}

	// Polygon
	if ($hotspot['hotspot_type'] == 'poly')
	{
		$output .= "&hotspot_".$hotspot['id']."_type=poly";
	}

	$output .= "&hotspot_".$hotspot['id']."_coord=".$hotspot['hotspot_coordinates']."";

	$i++;
}

// Generate empty
$i++;
for ($i; $i <= 12; $i++)
{
	$output .= "&hotspot_".$i."=false";
}

// set vars
$questionId    = $_GET['modifyAnswers'];
$course_code = $_course['id'];

// Get clicks
if(isset($_SESSION['exerciseResultCoordinates']) && $from_db==0)
{
	foreach ($_SESSION['exerciseResultCoordinates'][$questionId] as $coordinate)
	{
		$output2 .= $coordinate."|";
	}
}
else
{
	// get it from db
	$tbl_track_e_hotspot = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_HOTSPOT);
	$sql = 'SELECT hotspot_coordinate 
			FROM '.$tbl_track_e_hotspot.'
			WHERE hotspot_question_id = '.intval($questionId).'
			AND hotspot_course_code = "'.Database::escape_string($course_code).'"
			AND hotspot_exe_id='.intval($exe_id);
	
	$rs = @api_sql_query($sql); // don't output error because we are in Flash execution.
	while($row = Database :: fetch_array($rs))
	{
		$output2 .= $row['hotspot_coordinate']."|";
	}
}

$output .= "&p_hotspot_answers=".substr($output2,0,-1)."&done=done";

$explode = explode('&', $output);

echo $output;
?>