File Source for addlimits.php

<?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
*/
/**
* Adding limits
* @package dokeos.exercise
* @author
* @version $Id: admin.php 10680 2007-01-11 21:26:23Z pcool $
*/
/*
-----------------------------------------------------------
including the global file
-----------------------------------------------------------
*/
include('../inc/global.inc.php');
/*
-----------------------------------------------------------
Including necessary files
-----------------------------------------------------------
*/
include('exercise.class.php');
include('question.class.php');
include('answer.class.php');
include_once(api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php');
/*
-----------------------------------------------------------
Answer types
-----------------------------------------------------------
*/
define('UNIQUE_ANSWER', 1);
define('MULTIPLE_ANSWER', 2);
define('FILL_IN_BLANKS', 3);
define('MATCHING', 4);
define('FREE_ANSWER', 5);
/*
-----------------------------------------------------------
Language
-----------------------------------------------------------
*/
// name of the language file that needs to be included
$language_file='exercice';
/*
-----------------------------------------------------------
section (for the tabs)
-----------------------------------------------------------
*/
$this_section=SECTION_COURSES;
api_protect_course_script();
/*
-----------------------------------------------------------
Table definitions
@todo: use the Database :: get_course_table functions
-----------------------------------------------------------
*/
$TBL_EXERCICE_QUESTION = Database::get_course_table(TABLE_QUIZ_TEST_QUESTION);
$TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST);
$TBL_QUESTIONS = Database::get_course_table(TABLE_QUIZ_QUESTION);
$TBL_REPONSES = Database::get_course_table('quiz_answer');
$main_user_table = Database :: get_main_table(TABLE_MAIN_USER);
$main_course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
$TBL_TRACK_EXERCICES = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
$TBL_TRACK_ATTEMPT = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);
$dsp_percent = false;
$debug=0;
if($debug>0)
{
echo str_repeat(' ',0).'Entered exercise_result.php'."<br />\n";var_dump($_POST);
}
// general parameters passed via POST/GET
if ( empty ( $origin ) )
{
$origin = $_REQUEST['origin'];
}
if ( empty ( $learnpath_id ) )
{
$learnpath_id = mysql_real_escape_string($_REQUEST['learnpath_id']);
}
if ( empty ( $learnpath_item_id ) )
{
$learnpath_item_id = mysql_real_escape_string($_REQUEST['learnpath_item_id']);
}
if ( empty ( $formSent ) )
{
$formSent= $_REQUEST['formSent'];
}
if ( empty ( $exerciseResult ) )
{
$exerciseResult = $_SESSION['exerciseResult'];
}
if ( empty ( $questionId ) )
{
$questionId = $_REQUEST['questionId'];
}
if ( empty ( $choice ) ) {
$choice = $_REQUEST['choice'];
}
if ( empty ( $questionNum ) )
{
$questionNum = mysql_real_escape_string($_REQUEST['questionNum']);
}
if ( empty ( $nbrQuestions ) )
{
$nbrQuestions = mysql_real_escape_string($_REQUEST['nbrQuestions']);
}
if ( empty ( $questionList ) )
{
$questionList = $_SESSION['questionList'];
}
if ( empty ( $objExercise ) )
{
$objExercise = $_SESSION['objExercise'];
}
$exercise_id = $_GET['exercise_id'];
$is_allowedToEdit=$is_courseAdmin;
$nameTools=get_lang('Exercice');
$interbreadcrumb[]=array("url" => "exercice.php","name" => get_lang('Exercices'));
Display::display_header($nameTools,"Exercise");
/*
-----------------------------------------------------------
Action handling
-----------------------------------------------------------
*/
include('../inc/global.inc.php');
if (isset($_POST['ok']))
{
$message = get_lang('TestLimitsAdded');
Display::display_normal_message($message);
}
?>
<script type="text/javascript">
function selectlimited()
{
document.getElementById('limited').checked="checked";
}
function selectattempts()
{
document.getElementById('attemptlimited').checked="checked";
}
</script>
<h3><?php echo get_lang('AddLimits'); ?></h3>
<br>
<form action="addlimits.php" name="frmlimit" method="post">
<h4>
Time :
</h4>
<input type="hidden" name="exe_id" value="<?php echo $exercise_id; ?>" />
<input type="radio" name="limit" checked="checked" value="0" id="unlimit"><?php echo get_lang('Unlimited'); ?>
<br>
<input type="radio" name="limit" value="1" id="limited"><?php echo get_lang('LimitedTime'); ?>
<select name="minutes" onfocus="selectlimited();" >
<option selected="selected">1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>15</option>
<option>20</option>
<option>25</option>
<option>30</option>
<option>40</option>
<option>50</option>
<option>60</option>
</select><?php echo get_lang('Minutes'); ?>.
<h4>
<?php echo get_lang('Attempts'); ?>:
</h4>
<input type="radio" name="attempt" checked="checked" value="0" id="attemptunlimited"><?php echo get_lang('Unlimited'); ?>
<br>
<input type="radio" name="attempt" value="1" id="attemptlimited"><?php echo get_lang('LimitedAttempts'); ?>
<select name="attempts" onfocus="selectattempts();">
<option selected="selected">1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
</select><?php echo get_lang('Times'); ?>.
<br> <br>
<input type="submit" name="ok" value="<?php echo get_lang('Ok'); ?>">
</form>
<?php
/**
* @todo shouldn't this be moved to the part above (around line 111: action handling)
*/
if (isset($_POST['ok']))
{
$exercise_id = $_POST['exe_id'];
if ($_POST['limit']==1)
{
$minutes = $_POST['minutes'];
$query = "update `".$TBL_EXERCICES."` set ques_time_limit= $minutes where id= $exercise_id";
api_sql_query($query,__FILE__,__LINE__);
}
else
{
$query = "update `".$TBL_EXERCICES."` set ques_time_limit= 0 where id= $exercise_id";
api_sql_query($query,__FILE__,__LINE__);
}
if ($_POST['attempt']==1)
{
$attempts = $_POST['attempts'];
$query = "update `".$TBL_EXERCICES."` set num_attempts = $attempts where id= $exercise_id";
api_sql_query($query,__FILE__,__LINE__);
}
else
{
$query = "update`".$TBL_EXERCICES."` set num_attempts = 0 where id= $exercise_id";
api_sql_query($query,__FILE__,__LINE__);
}
}
?>

Source for file addlimits.php