class.ilObjTest.php

Go to the documentation of this file.

<?php

/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

include_once "./classes/class.ilObject.php";
include_once "./Modules/Test/classes/inc.AssessmentConstants.php";

class ilObjTest extends ilObject
{
        protected $_kiosk;
        
        var $test_id;

        var $invitation = INVITATION_OFF;
        
        
        var $author;
        
        var $metadata;
        
        var $questions;

        var $introduction;
        
        var $mark_schema;
        
        var $sequence_settings;
        
        var $score_reporting;
        
        var $instant_verification;
        
        var $answer_feedback_points;

  var $reporting_date;

  var $evaluation_data;

  var $nr_of_tries;

        var $use_previous_answers;

  var $title_output;

  var $processing_time;

        var $enable_processing_time;

        var $reset_processing_time;

  var $starting_time;

  var $ending_time;

  var $ects_output;

  var $ects_fx;

  var $ects_grades;

        var $random_test;

        var $random_question_count;

        var $count_system;

        var $mc_scoring;

        var $pass_scoring;

        var $shuffle_questions;

        var $results_presentation;

        var $show_summary;

        var $score_cutting;

        var $password;

        var $allowedUsers;

        var $allowedUsersTimeGap;

        var $certificate_visibility;

        var $anonymity;

        var $show_cancel;
        var $autosave;

        var $show_marker;

        var $fixed_participants;

        var $answer_feedback;
        
        var $testSession;

        var $testSequence;
        
        private $_showfinalstatement;

        private $_finalstatement;

        /* Change Sn */
        private $_redirect_after_exam;
        
        private $_redirect_only_kiosk_mode;
        
        private $_exam_pdf;
        /* Change Sn End */

        private $_showinfo;

        private $_forcejs;
        
        private $_customStyle;
        
        protected $mailnotification;
        protected $mailnottype;
        protected $random_questionpool_data;
        protected $exportsettings;
        protected $show_serial;
        
        private $import_dir;

        function ilObjTest($a_id = 0,$a_call_by_reference = true)
        {
                global $ilUser;
                $this->type = "tst";
                include_once "./Modules/Test/classes/class.assMarkSchema.php";
                $this->mark_schema = new ASS_MarkSchema();
                $this->test_id = -1;
                $this->author = $ilUser->fullname;
                $this->introduction = "";
                $this->questions = array();
                $this->sequence_settings = TEST_FIXED_SEQUENCE;
                $this->score_reporting = REPORT_AFTER_TEST;
                $this->instant_verification = 0;
                $this->answer_feedback_points = 0;
                $this->reporting_date = "";
                $this->nr_of_tries = 0;
                $this->_kiosk = 0;
                $this->use_previous_answers = 1;
                $this->title_output = 0;
                $this->starting_time = "";
                $this->ending_time = "";
                $this->processing_time = "00:00:00";
                $this->enable_processing_time = "0";
                $this->reset_processing_time = 0;
                $this->ects_output = 0;
                $this->ects_fx = NULL;
                $this->random_test = 0;
                $this->shuffle_questions = TRUE;
                $this->mailnottype = 0;
                $this->exportsettings = 0;
                $this->show_summary = 8;
                $this->random_question_count = "";
                $this->count_system = COUNT_PARTIAL_SOLUTIONS;
                $this->mc_scoring = SCORE_ZERO_POINTS_WHEN_UNANSWERED;
                $this->score_cutting = SCORE_CUT_QUESTION;
                $this->pass_scoring = SCORE_LAST_PASS;
                $this->answer_feedback = 0;
                $this->password = "";
                $this->certificate_visibility = 0;
                $this->allowedUsers = "";
                $this->_showfinalstatement = FALSE;
                $this->_finalstatement = "";
                $this->_redirect_after_exam = "";
                $this->_redirect_only_kiosk_mode = TRUE;
                $this->_exam_pdf = TRUE;
                $this->_showinfo = TRUE;
                $this->_forcejs = FALSE;
                $this->_customStyle = "";
                $this->allowedUsersTimeGap = "";
                $this->anonymity = 0;
                $this->show_cancel = 1;
                $this->autosave = 0;
                $this->show_marker = 0;
                $this->show_serial = false;
                $this->fixed_participants = 0;
                $this->setShowPassDetails(TRUE);
                $this->setShowSolutionDetails(TRUE);
                $this->setShowSolutionAnswersOnly(FALSE);
                $this->setShowSolutionSignature(FALSE);
                $this->testSession = FALSE;
                $this->testSequence = FALSE;
                $this->mailnotification = 0;
                global $lng;
                $lng->loadLanguageModule("assessment");
                $this->mark_schema->createSimpleSchema($lng->txt("failed_short"), $lng->txt("failed_official"), 0, 0, $lng->txt("passed_short"), $lng->txt("passed_official"), 50, 1);
                $this->ects_grades = array(
                        "A" => 90,
                        "B" => 65,
                        "C" => 35,
                        "D" => 10,
                        "E" => 0
                );
                $this->ilObject($a_id, $a_call_by_reference);
        }

        function create($a_upload = false)
        {
                parent::create();

                // meta data will be created by
                // import parser
                if (!$a_upload)
                {
                        $this->createMetaData();
                }
        }

        function update()
        {
                if (!parent::update())
                {
                        return false;
                }

                // put here object specific stuff

                return true;
        }

        function createReference() {
                $result = parent::createReference();
                $this->saveToDb();
                return $result;
        }

        function read($a_force_db = false)
        {
                parent::read($a_force_db);
                $this->loadFromDb();
        }


        function delete()
        {
                // always call parent delete function first!!
                if (!parent::delete())
                {
                        return false;
                }

                // delet meta data
                $this->deleteMetaData();

                //put here your module specific stuff
                $this->deleteTest();

                return true;
        }

        function deleteTest()
        {
                global $ilDB;
                
                // first of all remove all test editings, because the delete statements used for this
                // contain a subquery for active ids, that are deleted in the next steps
                $this->removeAllTestEditings();

                $result = $ilDB->queryF("SELECT active_id FROM tst_active WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $active_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($active_array, $row["active_id"]);
                }

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_active WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                if (count($active_array))
                {
                        foreach ($active_array as $active_id)
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_times WHERE active_fi = %s",
                                        array('integer'),
                                        array($active_id)
                                );

                                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_sequence WHERE active_fi = %s",
                                        array('integer'),
                                        array($active_id)
                                );
                        }
                }

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_mark WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                $result = $ilDB->queryF("SELECT question_fi FROM tst_test_question WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $this->removeQuestion($row["question_fi"]);
                }

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_tests WHERE test_id = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_random WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                // this delete is allready done by call to removeAllTestEditings some lines above
                /*$affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_rnd_qst WHERE tst_test_rnd_qst.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                        array('integer'),
                        array($this->getTestId())
                );*/

                // moved to top of this method because this method performs delete statements,
                // that use a subquery for active ids, that are allready deleted some lines above
                //$this->removeAllTestEditings();

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_question WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                if ($this->isRandomTest())
                {
                        $this->removeDuplicatedQuestionpools();
                }


                // delete export files
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $tst_data_dir = ilUtil::getDataDir()."/tst_data";
                $directory = $tst_data_dir."/tst_".$this->getId();
                if (is_dir($directory))
                {
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        ilUtil::delDir($directory);
                }
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("tst:html", $this->getId());
                // remaining usages are not in text anymore -> delete them
                // and media objects (note: delete method of ilObjMediaObject
                // checks whether object is used in another context; if yes,
                // the object is not deleted!)
                foreach($mobs as $mob)
                {
                        ilObjMediaObject::_removeUsage($mob, "tst:html", $this->getId());
                        if (ilObjMediaObject::_exists($mob))
                        {
                                $mob_obj =& new ilObjMediaObject($mob);
                                $mob_obj->delete();
                        }
                }
        }

        function initDefaultRoles()
        {
                global $rbacadmin;
                return array();
        }

        function notify($a_event,$a_ref_id,$a_parent_non_rbac_id,$a_node_id,$a_params = 0)
        {
                global $tree;

                switch ($a_event)
                {
                        case "link":

                                //var_dump("<pre>",$a_params,"</pre>");
                                //echo "Module name ".$this->getRefId()." triggered by link event. Objects linked into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;

                        case "cut":

                                //echo "Module name ".$this->getRefId()." triggered by cut event. Objects are removed from target object ref_id: ".$a_ref_id;
                                //exit;
                                break;

                        case "copy":

                                //var_dump("<pre>",$a_params,"</pre>");
                                //echo "Module name ".$this->getRefId()." triggered by copy event. Objects are copied into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;

                        case "paste":

                                //echo "Module name ".$this->getRefId()." triggered by paste (cut) event. Objects are pasted into target object ref_id: ".$a_ref_id;
                                //exit;
                                break;

                        case "new":

                                //echo "Module name ".$this->getRefId()." triggered by paste (new) event. Objects are applied to target object ref_id: ".$a_ref_id;
                                //exit;
                                break;
                }

                // At the beginning of the recursive process it avoids second call of the notify function with the same parameter
                if ($a_node_id==$_GET["ref_id"])
                {
                        $parent_obj =& $this->ilias->obj_factory->getInstanceByRefId($a_node_id);
                        $parent_type = $parent_obj->getType();
                        if ($parent_type == $this->getType())
                        {
                                $a_node_id = (int) $tree->getParentId($a_node_id);
                        }
                }

                parent::notify($a_event,$a_ref_id,$a_parent_non_rbac_id,$a_node_id,$a_params);
        }

        function createExportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $tst_data_dir = ilUtil::getDataDir()."/tst_data";
                ilUtil::makeDir($tst_data_dir);
                if (!is_writable($tst_data_dir))
                {
                        $this->ilias->raiseError("Test Data Directory (".$tst_data_dir
                                .") not writeable.",$this->ilias->error_obj->MESSAGE);
                }

                // create learning module directory (data_dir/lm_data/lm_<id>)
                $tst_dir = $tst_data_dir."/tst_".$this->getId();
                ilUtil::makeDir($tst_dir);
                if (!@is_dir($tst_dir))
                {
                        $this->ilias->raiseError("Creation of Test Directory failed.",$this->ilias->error_obj->MESSAGE);
                }
                // create Export subdirectory (data_dir/lm_data/lm_<id>/Export)
                $export_dir = $tst_dir."/export";
                ilUtil::makeDir($export_dir);
                if (!@is_dir($export_dir))
                {
                        $this->ilias->raiseError("Creation of Export Directory failed.",$this->ilias->error_obj->MESSAGE);
                }
        }

        function getExportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $export_dir = ilUtil::getDataDir()."/tst_data"."/tst_".$this->getId()."/export";
                return $export_dir;
        }

        function getExportFiles($dir)
        {
                // quit if import dir not available
                if (!@is_dir($dir) or
                        !is_writeable($dir))
                {
                        return array();
                }

                // open directory
                $dir = dir($dir);

                // initialize array
                $file = array();

                // get files and save the in the array
                while ($entry = $dir->read())
                {
                        if ($entry != "." and
                                $entry != ".." and
                                //substr($entry, -4) == ".zip" and
                                ereg("^[0-9]{10}_{2}[0-9]+_{2}(test(__results)?(__PDF-Export)?__)*[0-9]+\.[a-z]{1,4}\$", $entry))
                        {
                                $file[] = $entry;
                        }
                }

                // close import directory
                $dir->close();

                // sort files
                sort ($file);
                reset ($file);

                return $file;
        }


        function _createImportDirectory()
        {
                global $ilias;

                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $tst_data_dir = ilUtil::getDataDir()."/tst_data";
                ilUtil::makeDir($tst_data_dir);

                if (!is_writable($tst_data_dir))
                {
                        $ilias->raiseError("Test data directory (".$tst_data_dir
                                .") not writeable.",$ilias->error_obj->FATAL);
                }

                // create test directory (data_dir/tst_data/tst_import)
                $tst_dir = $tst_data_dir."/tst_import";
                ilUtil::makeDir($tst_dir);
                if (!@is_dir($tst_dir))
                {
                        $ilias->raiseError("Creation of test import directory failed.",$ilias->error_obj->FATAL);
                }
                return $tst_dir;
        }

        function _setImportDirectory($a_import_dir = null)
        {
                if (strlen($a_import_dir))
                {
                        $_SESSION["tst_import_dir"] = $a_import_dir;
                }
                else
                {
                        unset($_SESSION["tst_import_dir"]);
                }
        }
        
        function _getImportDirectory()
        {
                if (strlen($_SESSION["tst_import_dir"]))
                {
                        return $_SESSION["tst_import_dir"];
                }
                return null;
        }

        function createImportDirectory()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $tst_data_dir = ilUtil::getDataDir()."/tst_data";
                ilUtil::makeDir($tst_data_dir);

                if (!is_writable($tst_data_dir))
                {
                        $this->ilias->raiseError("Test Data Directory (".$tst_data_dir
                                .") not writeable.",$this->ilias->error_obj->FATAL);
                }

                // create test directory (data_dir/tst_data/tst_import)
                $tst_dir = $tst_data_dir."/tst_import";
                ilUtil::makeDir($tst_dir);
                if (!@is_dir($tst_dir))
                {
                        $ilias->raiseError("Creation of test import directory failed.",$ilias->error_obj->FATAL);
                }
        }

        function getImportDirectory()
        {
                if(strlen($this->import_dir))
                {
                        return $this->import_dir;
                }
                
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $import_dir = ilUtil::getDataDir()."/tst_data/tst_import";
                if (@is_dir($import_dir))
                {
                        return $import_dir;
                }
                else
                {
                        return false;
                }
        }
        
        public function setImportDirectory($a_import_dir)
        {
                $this->import_dir = $a_import_dir;
        }
        

        function hasSingleChoiceQuestions()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT DISTINCT(qpl_qst_type.type_tag) foundtypes FROM qpl_questions, tst_test_result, qpl_qst_type, tst_active WHERE tst_test_result.question_fi = qpl_questions.question_id AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id AND tst_test_result.active_fi = tst_active.active_id AND tst_active.test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $hasSC = false;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (strcmp($row['foundtypes'], 'assSingleChoice') == 0)
                        {
                                $hasSC = true;
                        }
                }
                return $hasSC;
        }

        function isSingleChoiceTest()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT DISTINCT(qpl_qst_type.type_tag) foundtypes FROM qpl_questions, tst_test_result, qpl_qst_type, tst_active WHERE tst_test_result.question_fi = qpl_questions.question_id AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id AND tst_test_result.active_fi = tst_active.active_id AND tst_active.test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        if (strcmp($row['foundtypes'], 'assSingleChoice') == 0)
                        {
                                return TRUE;
                        }
                        else
                        {
                                return false;
                        }
                }
                return FALSE;
        }

        function isSingleChoiceTestWithoutShuffle()
        {
                global $ilDB;

                if (!$this->hasSingleChoiceQuestions()) return false;
                
                $result = $ilDB->queryF("SELECT DISTINCT(qpl_qst_sc.shuffle) foundshuffles FROM qpl_questions, qpl_qst_sc, tst_test_result, qpl_qst_type, tst_active WHERE tst_test_result.question_fi = qpl_questions.question_id AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id AND tst_test_result.active_fi = tst_active.active_id AND qpl_questions.question_id = qpl_qst_sc.question_fi AND tst_active.test_fi = %s AND qpl_qst_type.type_tag = %s",
                        array('integer', 'text'),
                        array($this->getTestId(), 'assSingleChoice')
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return ($row['foundshuffles'] == 0);
                }
                return FALSE;
        }

        function isComplete()
        {
                if ((count($this->mark_schema->mark_steps)) and (count($this->questions)))
                {
                        return 1;
                }
                else
                {
                        if ($this->isRandomTest())
                        {
                                $arr = $this->getRandomQuestionpools();
                                if (count($arr) && ($this->getRandomQuestionCount() > 0))
                                {
                                        return 1;
                                }
                                $count = 0;
                                foreach ($arr as $array)
                                {
                                        $count += $array["count"];
                                }
                                if ($count)
                                {
                                        return 1;
                                }
                        }
                        return 0;
                }
                return 0;
        }

        function _isComplete($obj_id)
        {
                $test = new ilObjTest($obj_id, false);
                $test->loadFromDb();
                return $test->isComplete();
        }

        function saveECTSStatus($ects_output = 0, $fx_support = "", $ects_a = 90, $ects_b = 65, $ects_c = 35, $ects_d = 10, $ects_e = 0)
        {
                global $ilDB;
                if ($this->test_id > 0) 
                {
                        $fx_support = preg_replace("/,/", ".", $fx_support);
                        if (preg_match("/\d+/", $fx_support))
                        {
                                $fx_support = $fx_support;
                        }
                        else
                        {
                                $fx_support = NULL;
                        }
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_tests SET ects_output = %s, ects_a = %s, ects_b = %s, ects_c = %s, ects_d = %s, ects_e = %s, ects_fx = %s WHERE test_id = %s",
                                array('text','float','float','float','float','float','float','integer'),
                                array($ects_output, $ects_a, $ects_b, $ects_c, $ects_d, $ects_e, $fx_support, $this->getTestId())
                        );
                        $this->ects_output = $ects_output;
                        $this->ects_fx = $fx_support;
                }
        }

        function saveCompleteStatus()
        {
                global $ilDB;

                $complete = 0;
                if ($this->isComplete())
                {
                        $complete = 1;
                }
                if ($this->test_id > 0)
                {
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_tests SET complete = %s WHERE test_id = %s",
                                array('text','integer'),
                                array($complete, $this->test_id)
                        );
                }
        }
        
        function getAllRTEContent()
        {
                $result = array();
                array_push($result, $this->getIntroduction());
                array_push($result, $this->getFinalStatement());
                return $result;
        }
        
        function cleanupMediaobjectUsage()
        {
                include_once("./Services/RTE/classes/class.ilRTE.php");
                $completecontent = "";
                foreach ($this->getAllRTEContent() as $content)
                {
                        $completecontent .= $content;
                }
                ilRTE::_cleanupMediaObjectUsage($completecontent, $this->getType() . ":html",
                        $this->getId());
        }

        function saveToDb($properties_only = FALSE)
        {
                global $ilDB, $ilLog;

                // cleanup RTE images
                $this->cleanupMediaobjectUsage();
                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if ($this->test_id == -1)
                {
                        // Create new dataset
                        $next_id = $ilDB->nextId('tst_tests');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO tst_tests (test_id, obj_fi, author, introduction, " .
                                "finalstatement, redirect_after_exam, redirect_only_kiosk_mode, exam_pdf, showinfo, forcejs, customstyle, showfinalstatement, sequence_settings, " .
                                "score_reporting, instant_verification, answer_feedback_points, answer_feedback, anonymity, show_cancel, autosave, show_marker, show_serial, " .
                                "fixed_participants, nr_of_tries, kiosk, use_previous_answers, title_output, processing_time, enable_processing_time, " .
                                "reset_processing_time, reporting_date, starting_time, ending_time, complete, ects_output, ects_a, ects_b, ects_c, ects_d, " .
                                "ects_e, ects_fx, random_test, random_question_count, count_system, mc_scoring, score_cutting, pass_scoring, " .
                                "shuffle_questions, results_presentation, show_summary, password, allowedusers, mailnottype, exportsettings, " .
                                "alloweduserstimegap, certificate_visibility, mailnotification, created, tstamp) " .
                                "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, " .
                                "%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                                array(
                                        'integer', 'integer', 'text', 'text', 
                                        'text', 'text', 'integer', 'integer', 'integer', 'integer', 'text', 'integer', 'integer',
                                        'integer', 'text', 'text', 'text', 'text', 'text', 'text','integer','text',
                                        'text', 'integer', 'integer', 'text', 'text', 'text', 'text',
                                        'integer', 'text', 'text', 'text', 'text', 'text', 'float', 'float', 'float', 'float',
                                        'float', 'float', 'text', 'integer', 'text', 'text', 'text', 'text',
                                        'text', 'integer', 'integer', 'text', 'integer', 'integer', 'integer',
                                        'integer', 'text', 'integer', 'integer', 'integer'
                                ),
                                array(
                                        $next_id, 
                                        $this->getId(), 
                                        $this->getAuthor(), 
                                        ilRTE::_replaceMediaObjectImageSrc($this->getIntroduction(), 0),
                                        ilRTE::_replaceMediaObjectImageSrc($this->getFinalStatement(), 0),
                                        $this->getRedirectAfterExam(),
                                        $this->getRedirectOnlyKioskMode(),
                                        $this->getExamPdf(),
                                        $this->getShowInfo(), 
                                        $this->getForceJS(),
                                        $this->getCustomStyle(),
                                        $this->getShowFinalStatement(),
                                        $this->getSequenceSettings(),
                                        $this->getScoreReporting(), 
                                        $this->getInstantFeedbackSolution(), 
                                        $this->getAnswerFeedbackPoints(),
                                        $this->getAnswerFeedback(),
                                        $this->getAnonymity(), 
                                        $this->getShowCancel(),
                                        $this->getAutosave(),
                                        $this->getShowMarker(),
                                        $this->getShowSerial(),
                                        $this->getFixedParticipants(),
                                        $this->getNrOfTries(), 
                                        $this->getKiosk(),
                                        $this->getUsePreviousAnswers(),
                                        $this->getTitleOutput(), 
                                        $this->getProcessingTime(),
                                        $this->getEnableProcessingTime(),
                                        $this->getResetProcessingTime(),
                                        $this->getReportingDate(),
                                        $this->getStartingTime(), 
                                        $this->getEndingTime(),
                                        $this->isComplete(),
                                        $this->getECTSOutput(),
                                        strlen($this->ects_grades["A"]) ? $this->ects_grades["A"] : NULL, 
                                        strlen($this->ects_grades["B"]) ? $this->ects_grades["B"] : NULL, 
                                        strlen($this->ects_grades["C"]) ? $this->ects_grades["C"] : NULL, 
                                        strlen($this->ects_grades["D"]) ? $this->ects_grades["D"] : NULL, 
                                        strlen($this->ects_grades["E"]) ? $this->ects_grades["E"] : NULL, 
                                        $this->getECTSFX(),
                                        $this->isRandomTest(), 
                                        $this->getRandomQuestionCount(), 
                                        $this->getCountSystem(),
                                        $this->getMCScoring(), 
                                        $this->getScoreCutting(), 
                                        $this->getPassScoring(),
                                        $this->getShuffleQuestions(), 
                                        $this->getResultsPresentation(),
                                        $this->getListOfQuestionsSettings(), 
                                        $this->getPassword(),
                                        $this->getAllowedUsers(),
                                        $this->getMailNotificationType(),
                                        $this->getExportSettings(),
                                        $this->getAllowedUsersTimeGap(),
                                        $this->getCertificateVisibility(), 
                                        $this->getMailNotification(),
                                        time(), 
                                        time()
                                )
                        );
                        $this->test_id = $next_id;

                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_create_new_test", ilObjAssessmentFolder::_getLogLanguage()));
                        }
                }
                else
                {
                        // Modify existing dataset
                        $oldrow = array();
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $result = $ilDB->queryF("SELECT * FROM tst_tests WHERE test_id = %s",
                                        array('integer'),
                                        array($this->test_id)
                                );
                                if ($result->numRows() == 1)
                                {
                                        $oldrow = $ilDB->fetchAssoc($result);
                                }
                        }
                        //echo $this->getRedirectOnlyKioskMode();
                        //echo $this->getExamPdf();
                        //echo $this->getRedirectAfterExam();
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_tests SET author = %s, introduction = %s, " .
                                "finalstatement = %s, redirect_after_exam = %s, redirect_only_kiosk_mode = %s, exam_pdf = %s, showinfo = %s, forcejs = %s, customstyle = %s, showfinalstatement = %s, sequence_settings = %s, " .
                                "score_reporting = %s, instant_verification = %s, answer_feedback_points = %s, answer_feedback = %s, anonymity = %s, show_cancel = %s, autosave = %s, show_marker = %s, show_serial = %s, " .
                                "fixed_participants = %s, nr_of_tries = %s, kiosk = %s, use_previous_answers = %s, title_output = %s, processing_time = %s, enable_processing_time = %s, " . 
                                "reset_processing_time = %s, reporting_date = %s, starting_time = %s, ending_time = %s, complete = %s, ects_output = %s, ects_a = %s, ects_b = %s, ects_c = %s, ects_d = %s, " .
                                "ects_e = %s, ects_fx = %s, random_test = %s, random_question_count = %s, count_system = %s, mc_scoring = %s, score_cutting = %s, pass_scoring = %s, " . 
                                "shuffle_questions = %s, results_presentation = %s, show_summary = %s, password = %s, allowedusers = %s, mailnottype = %s, exportsettings = %s, " . 
                                "alloweduserstimegap = %s, certificate_visibility = %s, mailnotification = %s, tstamp = %s WHERE test_id = %s",
                                array(
                                        'text', 'text',
                                        'text', 'text', 'integer', 'integer', 'integer', 'integer', 'text', 'integer', 'integer',
                                        'integer', 'text', 'text', 'text', 'text', 'text', 'text', 'integer','text',
                                        'text', 'integer', 'integer', 'text', 'text', 'text', 'text',
                                        'integer', 'text', 'text', 'text', 'text', 'text', 'float', 'float', 'float', 'float',
                                        'float', 'float', 'text', 'integer', 'text', 'text', 'text', 'text',
                                        'text', 'integer', 'integer', 'text', 'integer','integer', 'integer',
                                        'integer', 'text', 'integer', 'integer', 'integer'
                                ),
                                array(
                                        $this->getAuthor(), 
                                        ilRTE::_replaceMediaObjectImageSrc($this->getIntroduction(), 0),
                                        ilRTE::_replaceMediaObjectImageSrc($this->getFinalStatement(), 0),
                                        $this->getRedirectAfterExam(),
                                        $this->getRedirectOnlyKioskMode(),
                                        $this->getExamPdf(),
                                        $this->getShowInfo(), 
                                        $this->getForceJS(),
                                        $this->getCustomStyle(),
                                        $this->getShowFinalStatement(),
                                        $this->getSequenceSettings(),
                                        $this->getScoreReporting(), 
                                        $this->getInstantFeedbackSolution(), 
                                        $this->getAnswerFeedbackPoints(),
                                        $this->getAnswerFeedback(),
                                        $this->getAnonymity(), 
                                        $this->getShowCancel(),
                                        $this->getAutosave(),
                                        $this->getShowMarker(),
                                        $this->getShowSerial(),
                                        $this->getFixedParticipants(),
                                        $this->getNrOfTries(), 
                                        $this->getKiosk(),
                                        $this->getUsePreviousAnswers(),
                                        $this->getTitleOutput(), 
                                        $this->getProcessingTime(),
                                        $this->getEnableProcessingTime(),
                                        $this->getResetProcessingTime(),
                                        $this->getReportingDate(),
                                        $this->getStartingTime(), 
                                        $this->getEndingTime(),
                                        $this->isComplete(),
                                        $this->getECTSOutput(),
                                        strlen($this->ects_grades["A"]) ? $this->ects_grades["A"] : NULL, 
                                        strlen($this->ects_grades["B"]) ? $this->ects_grades["B"] : NULL, 
                                        strlen($this->ects_grades["C"]) ? $this->ects_grades["C"] : NULL, 
                                        strlen($this->ects_grades["D"]) ? $this->ects_grades["D"] : NULL, 
                                        strlen($this->ects_grades["E"]) ? $this->ects_grades["E"] : NULL, 
                                        $this->getECTSFX(),
                                        $this->isRandomTest(), 
                                        $this->getRandomQuestionCount(), 
                                        $this->getCountSystem(),
                                        $this->getMCScoring(), 
                                        $this->getScoreCutting(), 
                                        $this->getPassScoring(),
                                        $this->getShuffleQuestions(), 
                                        $this->getResultsPresentation(),
                                        $this->getListOfQuestionsSettings(), 
                                        $this->getPassword(),
                                        $this->getAllowedUsers(),
                                        $this->getMailNotificationType(),
                                        $this->getExportSettings(),
                                        $this->getAllowedUsersTimeGap(),
                                        $this->getCertificateVisibility(), 
                                        $this->getMailNotification(),
                                        time(), 
                                        $this->getTestId()
                                )
                        );

                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $logresult = $ilDB->queryF("SELECT * FROM tst_tests WHERE test_id = %s",
                                        array('integer'),
                                        array($this->getTestId())
                                );
                                $newrow = array();
                                if ($logresult->numRows() == 1)
                                {
                                        $newrow = $ilDB->fetchAssoc($logresult);
                                }
                                $changed_fields = array();
                                foreach ($oldrow as $key => $value)
                                {
                                        if (strcmp($oldrow[$key], $newrow[$key]) != 0)
                                        {
                                                array_push($changed_fields, "$key: " . $oldrow[$key] . " => " . $newrow[$key]);
                                        }
                                }
                                $changes = join($changed_fields, ", ");
                                if (count($changed_fields) > 0)
                                {
                                        $this->logAction($this->lng->txtlng("assessment", "log_modified_test", ilObjAssessmentFolder::_getLogLanguage()) . " [".$changes."]");
                                }
                        }
                        if ($this->evalTotalPersons() > 0)
                        {
                                // reset the finished status of participants if the nr of test passes did change
                                if ($this->getNrOfTries() > 0)
                                {
                                        // set all unfinished tests with nr of passes >= allowed passes finished
                                        $aresult = $ilDB->queryF("SELECT active_id FROM tst_active WHERE test_fi = %s AND tries >= %s AND submitted = %s",
                                                array('integer', 'integer', 'integer'),
                                                array($this->getTestId(), $this->getNrOfTries(), 0)
                                        );
                                        while ($row = $ilDB->fetchAssoc($aresult))
                                        {
                                                $affectedRows = $ilDB->manipulateF("UPDATE tst_active SET submitted = %s, submittimestamp = %s WHERE active_id = %s",
                                                        array('integer', 'timestamp', 'integer'),
                                                        array(1, date('Y-m-d H:i:s'), $row["active_id"])
                                                );
                                        }

                                        // set all finished tests with nr of passes < allowed passes not finished
                                        $aresult = $ilDB->queryF("SELECT active_id FROM tst_active WHERE test_fi = %s AND tries < %s AND submitted = %s",
                                                array('integer', 'integer', 'integer'),
                                                array($this->getTestId(), $this->getNrOfTries()-1, 1)
                                        );
                                        while ($row = $ilDB->fetchAssoc($aresult))
                                        {
                                                $affectedRows = $ilDB->manipulateF("UPDATE tst_active SET submitted = %s, submittimestamp = %s WHERE active_id = %s",
                                                        array('integer', 'timestamp', 'integer'),
                                                        array(0, NULL, $row["active_id"])
                                                );
                                        }
                                }
                                else
                                {
                                        // set all finished tests with nr of passes >= allowed passes not finished
                                        $aresult = $ilDB->queryF("SELECT active_id FROM tst_active WHERE test_fi = %s AND submitted = %s",
                                                array('integer', 'integer'),
                                                array($this->getTestId(), 1)
                                        );
                                        while ($row = $ilDB->fetchAssoc($aresult))
                                        {
                                                $affectedRows = $ilDB->manipulateF("UPDATE tst_active SET submitted = %s, submittimestamp = %s WHERE active_id = %s",
                                                        array('integer', 'timestamp', 'integer'),
                                                        array(0, NULL, $row["active_id"])
                                                );
                                        }
                                }
                        }
                }
                if (!$this->isRandomTest())
                {
                        $this->removeDuplicatedQuestionpools();
                }
                if (!$properties_only)
                {
                        if (PEAR::isError($result)) 
                        {
                                global $ilias;
                                $ilias->raiseError($result->getMessage());
                        }
                        else
                        {
                                if (!$this->isRandomTest())
                                {
                                        $this->saveQuestionsToDb();
                                }
                                $this->mark_schema->saveToDb($this->test_id);
                        }
                }
  }

        function saveQuestionsToDb()
        {
                global $ilDB;

                $oldquestions = array();
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $result = $ilDB->queryF("SELECT question_fi FROM tst_test_question WHERE test_fi = %s ORDER BY sequence",
                                array('integer'),
                                array($this->getTestId())
                        );
                        if ($result->numRows() > 0)
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        array_push($oldquestions, $row["question_fi"]);
                                }
                        }
                }

                // delete existing category relations
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_question WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                // create new category relations
                foreach ($this->questions as $key => $value) 
                {
                        $next_id = $ilDB->nextId('tst_test_question');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_question (test_question_id, test_fi, question_fi, sequence, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer','integer', 'integer', 'integer', 'integer'),
                                array($next_id, $this->getTestId(), $value, $key, time())
                        );
                }
                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $result = $ilDB->queryF("SELECT question_fi FROM tst_test_question WHERE test_fi = %s ORDER BY sequence",
                                array('integer'),
                                array($this->getTestId())
                        );
                        $newquestions = array();
                        if ($result->numRows() > 0)
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        array_push($newquestions, $row["question_fi"]);
                                }
                        }
                        foreach ($oldquestions as $index => $question_id)
                        {
                                if (strcmp($newquestions[$index], $question_id) != 0)
                                {
                                        $pos = array_search($question_id, $newquestions);
                                        if ($pos === FALSE)
                                        {
                                                $this->logAction($this->lng->txtlng("assessment", "log_question_removed", ilObjAssessmentFolder::_getLogLanguage()), $question_id);
                                        }
                                        else
                                        {
                                                $this->logAction($this->lng->txtlng("assessment", "log_question_position_changed", ilObjAssessmentFolder::_getLogLanguage()) . ": " . ($index+1) . " => " . ($pos+1), $question_id);
                                        }
                                }
                        }
                        foreach ($newquestions as $index => $question_id)
                        {
                                if (array_search($question_id, $oldquestions) === FALSE)
                                {
                                        $this->logAction($this->lng->txtlng("assessment", "log_question_added", ilObjAssessmentFolder::_getLogLanguage()) . ": " . ($index+1), $question_id);
                                }
                        }
                }
        }
        
        protected function isNewRandomTest()
        {
                global $ilDB;
                $result = $ilDB->queryF('SELECT copy_id FROM tst_rnd_cpy WHERE tst_fi = %s',
                        array('integer'),
                        array($this->getTestId())
                );
                return $result->numRows() > 0;
        }

        function saveRandomQuestion($active_id, $question_id, $pass = NULL, $maxcount)
        {
                global $ilUser;
                global $ilDB;

                if (is_null($pass)) $pass = 0;
                $result = $ilDB->queryF("SELECT test_random_question_id FROM tst_test_rnd_qst WHERE active_fi = %s AND pass = %s",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                if ($result->numRows() < $maxcount)
                {
                        $duplicate_id = $question_id;
                        if (!$this->isNewRandomTest())
                        {
                                $duplicate_id = $this->getRandomQuestionDuplicate($question_id, $active_id);
                                if ($duplicate_id === FALSE)
                                {
                                        $duplicate_id = $this->duplicateQuestionForTest($question_id);
                                }
                        }
                        $next_id = $ilDB->nextId('tst_test_rnd_qst');
                        $result = $ilDB->manipulateF("INSERT INTO tst_test_rnd_qst (test_random_question_id, active_fi, question_fi, sequence, pass, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                                array('integer','integer','integer','integer','integer','integer'),
                                array($next_id,$active_id, $duplicate_id, $result->numRows()+1, $pass, time())
                        );
                }
        }

        function getRandomQuestionDuplicate($question_id, $active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT qpl_questions.question_id FROM qpl_questions, tst_test_rnd_qst WHERE qpl_questions.original_id = %s AND tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_test_rnd_qst.active_fi = %s",
                        array('integer', 'integer'),
                        array($question_id, $active_id)
                );
                $num = $result->numRows();
                if ($num > 0)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["question_id"];
                }
                else
                {
                        return FALSE;
                }
        }

        function getNrOfResultsForPass($active_id, $pass)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT test_result_id FROM tst_test_result WHERE active_fi = %s AND pass = %s",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                return $result->numRows();
        }

        function hasRandomQuestionsForPass($active_id, $pass)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT test_random_question_id FROM tst_test_rnd_qst WHERE active_fi = %s AND pass = %s",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                return ($result->numRows() > 0) ? true : false;
        }

        function generateRandomQuestions($active_id, $pass = NULL)
        {
                global $ilUser;
                global $ilDB;

                if ($active_id > 0)
                {
                        if ($this->hasRandomQuestionsForPass($active_id, $pass) > 0)
                        {
                                // Something went wrong. Maybe the user pressed the start button twice
                                // Questions already exist so there is no need to create new questions
                                return;
                        }
                        if ($pass > 0)
                        {
                                if ($this->getNrOfResultsForPass($active_id, $pass - 1) == 0)
                                {
                                        // This means that someone maybe reloaded the test submission page
                                        // If there are no existing results for the previous test, it makes
                                        // no sense to create a new set of random questions
                                        return;
                                }
                        }
                }
                else
                {
                        // This may not happen! If it happens, raise a fatal error...
                        global $ilias, $ilErr;
                        $ilias->raiseError(sprintf($this->lng->txt("error_random_question_generation"), $ilUser->getId(), $this->getTestId()), $ilErr->FATAL);
                }

                $num = $this->getRandomQuestionCount();
                if ($num > 0)
                {
                        $qpls =& $this->getRandomQuestionpools();
                        $rndquestions = $this->generateRandomPass($num, $qpls, $pass);
                        $allquestions = array();
                        foreach ($rndquestions as $question_id)
                        {
                                array_push($allquestions, $question_id);
                        }
                        if ($this->getShuffleQuestions())
                        {
                                srand ((float)microtime()*1000000);
                                shuffle($allquestions);
                        }

                        $maxcount = 0;
                        foreach ($qpls as $data)
                        {
                                $maxcount += $data["contains"];
                        }
                        if ($num > $maxcount) $num = $maxcount;
                        foreach ($allquestions as $question_id)
                        {
                                $this->saveRandomQuestion($active_id, $question_id, $pass, $num);
                        }
                }
                else
                {
                        $qpls =& $this->getRandomQuestionpools();
                        $allquestions = array();
                        $maxcount = 0;
                        foreach ($qpls as $key => $value)
                        {
                                if ($value["count"] > 0)
                                {
                                        $rndquestions = $this->generateRandomPass($value["count"], array($value), $pass);
                                        foreach ($rndquestions as $question_id)
                                        {
                                                array_push($allquestions, $question_id);
                                        }
                                }
                                $add = ($value["count"] <= $value["contains"]) ? $value["count"] : $value["contains"];
                                $maxcount += $add;
                        }
                        if ($this->getShuffleQuestions())
                        {
                                srand ((float)microtime()*1000000);
                                shuffle($allquestions);
                        }
                        foreach ($allquestions as $question_id)
                        {
                                $this->saveRandomQuestion($active_id, $question_id, $pass, $maxcount);
                        }
                }
        }

        function saveRandomQuestionCount($total_questions = NULL)
        {
                global $ilDB;

                if (strlen($total_questions))
                {
                        $this->setRandomQuestionCount($total_questions);
                }
                $affectedRows = $ilDB->manipulateF("UPDATE tst_tests SET random_question_count = %s, tstamp = %s WHERE test_id = %s",
                        array('integer', 'integer', 'integer'),
                        array($this->getRandomQuestionCount(), time(), $this->getTestId())
                );
                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction(sprintf($this->lng->txtlng("assessment", "log_total_amount_of_questions", ilObjAssessmentFolder::_getLogLanguage()), $this->getRandomQuestionCount()));
                }
        }

        function &getRandomQuestionpools()
        {
                global $ilDB;

                $qpls = array();
                $counter = 0;
                $result = $ilDB->queryF("SELECT tst_test_random.*, qpl_questionpool.questioncount FROM tst_test_random, qpl_questionpool WHERE tst_test_random.test_fi = %s AND tst_test_random.questionpool_fi = qpl_questionpool.obj_fi ORDER BY sequence, test_random_id",
                        array("integer"),
                        array($this->getTestId())
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $qpls[$counter] = array(
                                        "index" => $counter,
                                        "count" => $row["num_of_q"],
                                        "qpl"   => $row["questionpool_fi"],
                                        "contains" => $row["questioncount"]
                                );
                                $counter++;
                        }
                }
                return $qpls;
        }
        
        public function saveRandomQuestionpools()
        {
                global $ilDB;

                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                // delete existing random questionpools
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_random WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction($this->lng->txtlng("assessment", "log_random_question_pool_deleted", ilObjAssessmentFolder::_getLogLanguage()));
                }
                // delete existing duplicated questions
                $this->removeDuplicatedQuestionpools();
                
                // create new random questionpools
                foreach ($this->random_questionpool_data as $idx => $data) 
                {
                        if ($data->qpl > 0)
                        {
                                // save questionpool information
                                $next_id = $ilDB->nextId('tst_test_random');
                                $result = $ilDB->manipulateF("INSERT INTO tst_test_random (test_random_id, test_fi, questionpool_fi, num_of_q, tstamp, sequence) VALUES (%s, %s, %s, %s, %s, %s)",
                                        array('integer','integer', 'integer', 'integer', 'integer', 'integer'),
                                        array($next_id, $this->getTestId(), $data->qpl, $data->count, time(), $idx)
                                );
                                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                                {
                                        $this->logAction(sprintf($this->lng->txtlng("assessment", "log_random_question_pool_added", ilObjAssessmentFolder::_getLogLanguage()), $value["title"] . " (" . $value["qpl"] . ")", $value["count"]));
                                }
                                // duplicate all questions of the questionpools
                                $this->duplicateQuestionpoolForTest($data->qpl);
                        }
                }
        }

        protected function removeDuplicatedQuestionpools()
        {
                global $ilDB;
                
                $result = $ilDB->queryF('SELECT * FROM tst_rnd_cpy WHERE tst_fi = %s',
                        array('integer'),
                        array($this->getTestId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $question =& ilObjTest::_instanciateQuestion($row['qst_fi']);
                        $question->delete($row['qst_fi']);
                }

                $affectedRows = $ilDB->manipulateF('DELETE FROM tst_rnd_cpy WHERE tst_fi = %s',
                        array('integer'),
                        array($this->getTestId())
                );

                $affectedRows = $ilDB->manipulateF('DELETE FROM tst_rnd_qpl_title WHERE tst_fi = %s',
                        array('integer'),
                        array($this->getTestId())
                );
        }

        public function getUsedRandomQuestionpools()
        {
                global $ilDB;
                if ($this->isNewRandomTest())
                {
                        $result = $ilDB->queryF('SELECT tst_rnd_cpy.*, tst_test_random.num_of_q FROM tst_rnd_cpy, tst_test_random WHERE tst_rnd_cpy.tst_fi = %s AND tst_rnd_cpy.tst_fi = tst_test_random.test_fi AND tst_rnd_cpy.qpl_fi = tst_test_random.questionpool_fi',
                                array('integer'),
                                array($this->getTestId())
                        );
                        $pools = array();
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                if (is_array($pools[$row['qpl_fi']]))
                                {
                                        $pools[$row['qpl_fi']]['count']++;
                                }
                                else
                                {
                                        $pools[$row['qpl_fi']]['count'] = 1;
                                }
                                $pools[$row['qpl_fi']]['num_of_q'] = $row['num_of_q'];
                        }
                        $result = $ilDB->queryF('SELECT * FROM tst_rnd_qpl_title WHERE tst_fi = %s',
                                array('integer'),
                                array($this->getTestId())
                        );

                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $pools[$row['qpl_fi']]['title'] = $row['qpl_title'];
                        }
                        return $pools;
                }
                else
                {
                        $result = $ilDB->queryF('SELECT tst_test_random.* FROM tst_test_random WHERE tst_test_random.test_fi = %s ORDER BY sequence, test_random_id',
                                array('integer'),
                                array($this->getTestId())
                        );
                        $pools = array();
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $pools[$row['questionpool_fi']]['count'] = $row['num_of_q'];
                                $pools[$row['questionpool_fi']]['num_of_q'] = $row['num_of_q'];
                        }
                        $result = $ilDB->queryF('SELECT * FROM tst_rnd_qpl_title WHERE tst_fi = %s',
                                array('integer'),
                                array($this->getTestId())
                        );

                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $pools[$row['qpl_fi']]['title'] = $row['qpl_title'];
                        }
                        return $pools;
                }
        }

        protected function duplicateQuestionpoolForTest($questionpool_id)
        {
                global $ilDB;
                $result = $ilDB->queryF('SELECT question_id FROM qpl_questions WHERE obj_fi = %s AND complete = %s AND original_id IS NULL',
                        array('integer', 'text'),
                        array($questionpool_id, 1)
                );
                $saved_titles = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $question =& ilObjTest::_instanciateQuestion($row['question_id']);
                        $duplicate_id = $question->duplicate(true);
                        if ($duplicate_id > 0)
                        {
                                $next_id = $ilDB->nextId('tst_rnd_cpy');
                                $ilDB->manipulateF('INSERT INTO tst_rnd_cpy (copy_id, tst_fi, qst_fi, qpl_fi) VALUES (%s, %s, %s, %s)',
                                        array('integer', 'integer', 'integer', 'integer'),
                                        array($next_id, $this->getTestId(), $duplicate_id, $questionpool_id)
                                );
                                if (!array_key_exists($questionpool_id, $saved_titles))
                                {
                                        $next_id = $ilDB->nextId('tst_rnd_qpl_title');
                                        $ilDB->manipulateF('INSERT INTO tst_rnd_qpl_title (title_id, tst_fi, qpl_fi, qpl_title) VALUES (%s, %s, %s, %s)',
                                                array('integer', 'integer', 'integer', 'text'),
                                                array($next_id, $this->getTestId(), $questionpool_id, ilObject::_lookupTitle($questionpool_id))
                                        );
                                        $saved_titles[$questionpool_id] = 1;
                                }
                        }
                }
        }

        function addRandomQuestionpoolData($count = 0, $qpl = 0, $position)
        {
                include_once "./Modules/Test/classes/class.ilRandomTestData.php";
                if (array_key_exists($position, $this->random_questionpool_data))
                {
                        $newitems = array();
                        for ($i = 0; $i < $position; $i++)
                        {
                                array_push($newitems, $this->random_questionpool_data[$i]);
                        }
                        array_push($newitems, new ilRandomTestData($count, $qpl));
                        for ($i = $position; $i < count($this->random_questionpool_data); $i++)
                        {
                                array_push($newitems, $this->random_questionpool_data[$i]);
                        }
                        $this->random_questionpool_data = $newitems;
                }
                else
                {
                        array_push($this->random_questionpool_data, new ilRandomTestData($count, $qpl));
                }
        }

        function removeRandomQuestionpoolData($position)
        {
                if (array_key_exists($position, $this->random_questionpool_data))
                {
                        unset($this->random_questionpool_data[$position]);
                }
        }

        function setRandomQuestionpoolData($a_data)
        {
                $this->random_questionpool_data = $a_data;
        }

        function &getRandomQuestionpoolData()
        {
                if (is_array($this->random_questionpool_data) && count($this->random_questionpool_data)) return $this->random_questionpool_data;

                global $ilDB;

                $qpls = array();
                $counter = 0;
                $result = $ilDB->queryF("SELECT tst_test_random.*, qpl_questionpool.questioncount FROM tst_test_random, qpl_questionpool WHERE tst_test_random.test_fi = %s AND tst_test_random.questionpool_fi = qpl_questionpool.obj_fi ORDER BY sequence, test_random_id",
                        array("integer"),
                        array($this->getTestId())
                );
                include_once "./Modules/Test/classes/class.ilRandomTestData.php";
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($qpls, new ilRandomTestData($row['num_of_q'], $row['questionpool_fi']));
                        }
                }
                return $qpls;
        }

        function loadFromDb()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM tst_tests WHERE obj_fi = %s",
                        array('integer'),
                        array($this->getId())
                );
                if ($result->numRows() == 1)
                {
                        $data = $ilDB->fetchObject($result);
                        $this->setTestId($data->test_id);
                        if (strlen($this->getAuthor()) == 0)
                        {
                                $this->saveAuthorToMetadata($data->author);
                        }
                        $this->setAuthor($data->author);
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $this->setIntroduction(ilRTE::_replaceMediaObjectImageSrc($data->introduction, 1));
                        $this->setFinalStatement(ilRTE::_replaceMediaObjectImageSrc($data->finalstatement, 1));
                        /* Change Sn */
                        $this->setRedirectAfterExam($data->redirect_after_exam);
                        $this->setRedirectOnlyKioskMode($data->redirect_only_kiosk_mode);
                        $this->setExamPdf($data->exam_pdf);
                        /* Change Sn End */
                        $this->setShowInfo($data->showinfo);
                        $this->setForceJS($data->forcejs);
                        $this->setCustomStyle($data->customstyle);
                        $this->setShowFinalStatement($data->showfinalstatement);
                        $this->setSequenceSettings($data->sequence_settings);
                        $this->setScoreReporting($data->score_reporting);
                        $this->setInstantFeedbackSolution($data->instant_verification);
                        $this->setAnswerFeedbackPoints($data->answer_feedback_points);
                        $this->setAnswerFeedback($data->answer_feedback);
                        $this->setAnonymity($data->anonymity);
                        $this->setShowCancel($data->show_cancel);
                        $this->setAutosave($data->autosave);
                        $this->setShowMarker($data->show_marker);
                        $this->setShowSerial($data->show_serial);
                        $this->setFixedParticipants($data->fixed_participants);
                        $this->setNrOfTries($data->nr_of_tries);
                        $this->setKiosk($data->kiosk);
                        $this->setUsePreviousAnswers($data->use_previous_answers);
                        $this->setTitleOutput($data->title_output);
                        $this->setProcessingTime($data->processing_time);
                        $this->setEnableProcessingTime($data->enable_processing_time);
                        $this->setResetProcessingTime($data->reset_processing_time);
                        $this->setReportingDate($data->reporting_date);
                        $this->setShuffleQuestions($data->shuffle_questions);
                        $this->setResultsPresentation($data->results_presentation);
                        $this->setListOfQuestionsSettings($data->show_summary);
                        $this->setStartingTime($data->starting_time);
                        $this->setEndingTime($data->ending_time);
                        $this->setECTSOutput($data->ects_output);
                        $this->setECTSGrades(
                                array(
                                        "A" => $data->ects_a,
                                        "B" => $data->ects_b,
                                        "C" => $data->ects_c,
                                        "D" => $data->ects_d,
                                        "E" => $data->ects_e
                                )
                        );
                        $this->setECTSFX($data->ects_fx);
                        $this->setRandomTest($data->random_test);
                        $this->setRandomQuestionCount($data->random_question_count);
                        $this->mark_schema->flush();
                        $this->mark_schema->loadFromDb($this->getTestId());
                        $this->setCountSystem($data->count_system);
                        $this->setMCScoring($data->mc_scoring);
                        $this->setMailNotification($data->mailnotification);
                        $this->setMailNotificationType($data->mailnottype);
                        $this->setExportSettings($data->exportsettings);
                        $this->setScoreCutting($data->score_cutting);
                        $this->setPassword($data->password);
                        $this->setAllowedUsers($data->allowedusers);
                        $this->setAllowedUsersTimeGap($data->alloweduserstimegap);
                        $this->setPassScoring($data->pass_scoring);
                        $this->setCertificateVisibility($data->certificate_visibility);
                        $this->loadQuestions();
                }
        }

function loadQuestions($active_id = "", $pass = NULL)
{
        global $ilUser;
        global $ilDB;

        $this->questions = array();
        if (strcmp($active_id, "") == 0)
        {
                $active_id = $this->getActiveIdOfUser($ilUser->getId());
        }
        if ($this->isRandomTest())
        {
                if (is_null($pass))
                {
                        $pass = $this->_getPass($active_id);
                }
                $result = $ilDB->queryF("SELECT tst_test_rnd_qst.* FROM tst_test_rnd_qst, qpl_questions WHERE tst_test_rnd_qst.active_fi = %s AND qpl_questions.question_id = tst_test_rnd_qst.question_fi AND tst_test_rnd_qst.pass = %s ORDER BY sequence",
                        array('integer', 'integer'),
                        array($active_id, $pass)
                );
                // The following is a fix for random tests prior to ILIAS 3.8. If someone started a random test in ILIAS < 3.8, there
                // is only one test pass (pass = 0) in tst_test_rnd_qst while with ILIAS 3.8 there are questions for every test pass.
                // To prevent problems with tests started in an older version and continued in ILIAS 3.8, the first pass should be taken if
                // no questions are present for a newer pass.
                if ($result->numRows() == 0)
                {
                        $result = $ilDB->queryF("SELECT tst_test_rnd_qst.* FROM tst_test_rnd_qst, qpl_questions WHERE tst_test_rnd_qst.active_fi = %s AND qpl_questions.question_id = tst_test_rnd_qst.question_fi AND tst_test_rnd_qst.pass = 0 ORDER BY sequence",
                                array('integer'),
                                array($active_id)
                        );
                }
        }
        else
        {
                $result = $ilDB->queryF("SELECT tst_test_question.* FROM tst_test_question, qpl_questions WHERE tst_test_question.test_fi = %s AND qpl_questions.question_id = tst_test_question.question_fi ORDER BY sequence",
                        array('integer'),
                        array($this->test_id)
                );
        }
        $index = 1;
        while ($data = $ilDB->fetchAssoc($result))
        {
                $this->questions[$index++] = $data["question_fi"];
        }
}

        function setIntroduction($introduction = "")
        {
                $this->introduction = $introduction;
        }

        public function setFinalStatement($a_statement = "")
        {
                $this->_finalstatement = $a_statement;
        }
        
        /* Change Sn */
        public function setRedirectAfterExam($a_url = "")
        {
                $this->_redirect_after_exam = $a_url;
        }
        
        public function setRedirectOnlyKioskMode($a_int = 1)
        {
                $this->_redirect_only_kiosk_mode = ($a_int) ? 1 : 0;
        }
        
        public function setExamPdf($a_int = 0)
        {
                $this->_exam_pdf = ($a_int) ? 1 : 0;
        }
        /* Change Sn End */
        public function setShowInfo($a_info = 1)
        {
                $this->_showinfo = ($a_info) ? 1 : 0;
        }

        public function setForceJS($a_js = 1)
        {
                $this->_forcejs = ($a_js) ? 1 : 0;
        }
        
        public function setCustomStyle($a_customStyle = NULL)
        {
                $this->_customStyle = $a_customStyle;
        }
        
        public function getCustomStyle()
        {
                return (strlen($this->_customStyle)) ? $this->_customStyle : NULL;
        }
        
        public function getCustomStyles()
        {
                $css_path = ilUtil::getStyleSheetLocation("filesystem", "ta.css", "Modules/Test");
                $css_path = str_replace("ta.css", "customstyles", $css_path) . "/";
                $customstyles = array();
                if (is_dir($css_path))
                {
                        $results = array();
                        include_once "./Services/Utilities/classes/class.ilFileUtils.php";
                        ilFileUtils::recursive_dirscan($css_path, $results);
                        if (is_array($results["file"]))
                        {
                                foreach ($results["file"] as $filename)
                                {
                                        if (strpos($filename, ".css"))
                                        {
                                                array_push($customstyles, $filename);
                                        }
                                }
                        }
                }
                return $customstyles;
        }
        
        public function getTestStyleLocation($mode = "output")
        {
                if (strlen($this->getCustomStyle()))
                {
                        $default = ilUtil::getStyleSheetLocation("filesystem", "ta.css", "Modules/Test");
                        $custom = str_replace("ta.css", "customstyles/" . $this->getCustomStyle(), $default);
                        if (file_exists($custom))
                        {
                                $custom = ilUtil::getStyleSheetLocation($mode, "ta.css", "Modules/Test");
                                $custom = str_replace("ta.css", "customstyles/" . $this->getCustomStyle(), $custom);
                                return $custom;
                        }
                        else
                        {
                                return ilUtil::getStyleSheetLocation($mode, "ta.css", "Modules/Test");
                        }
                }
                else
                {
                        return ilUtil::getStyleSheetLocation($mode, "ta.css", "Modules/Test");
                }
        }

        public function setShowFinalStatement($show = 0)
        {
                $this->_showfinalstatement = ($show) ? 1 : 0;
        }


        function isRandomTest()
        {
                return ($this->random_test) ? 1 : 0;
        }
        
        
        public static function _lookupRandomTest($a_obj_id)
        {
                global $ilDB;
                
                $query = "SELECT random_test FROM tst_tests ".
                        "WHERE obj_fi = ".$ilDB->quote($a_obj_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        return $row->random_test ? true : false;
                }
                return false;
        }

        function getRandomQuestionCount()
        {
                return ($this->random_question_count) ? $this->random_question_count : 0;
        }

        public function getIntroduction()
        {
                return (strlen($this->introduction)) ? $this->introduction : NULL;
        }

        public function getFinalStatement()
        {
                return (strlen($this->_finalstatement)) ? $this->_finalstatement : NULL;
        }
        /* Change Sn */
        public function getRedirectAfterExam()
        {
                return (strlen($this->_redirect_after_exam)) ? $this->_redirect_after_exam : NULL;
        }
        
        public function getRedirectOnlyKioskMode()
        {
                return ($this->_redirect_only_kiosk_mode) ? 1 : 0;
        }
        
        public function getExamPdf()
        {
                return ($this->_exam_pdf) ? 1 : 0;
        }
        /* Change Sn End */
        public function getShowInfo()
        {
                return ($this->_showinfo) ? 1 : 0;
        }

        public function getForceJS()
        {
                return ($this->_forcejs) ? 1 : 0;
        }

        public function getShowFinalStatement()
        {
                return ($this->_showfinalstatement) ? 1 : 0;
        }

        function getTestId()
        {
                return $this->test_id;
        }

        function getECTSOutput()
        {
                return ($this->ects_output) ? 1 : 0;
        }

        function setECTSOutput($a_ects_output)
        {
                $this->ects_output = $a_ects_output ? 1 : 0;
        }

        function getECTSFX()
        {
                return (strlen($this->ects_fx)) ? $this->ects_fx : NULL;
        }

        function setECTSFX($a_ects_fx)
        {
                $this->ects_fx = $a_ects_fx;
        }

        function &getECTSGrades()
        {
                return $this->ects_grades;
        }

        function setECTSGrades($a_ects_grades)
        {
                if (is_array($a_ects_grades))
                {
                        $this->ects_grades = $a_ects_grades;
                }
        }

        function setSequenceSettings($sequence_settings = 0)
        {
                $this->sequence_settings = $sequence_settings;
        }

        function setScoreReporting($score_reporting = 0)
        {
                $this->score_reporting = $score_reporting;
        }

  function setInstantFeedbackSolution($instant_feedback = 0)
        {
                switch ($instant_feedback)
                {
                        case 1:
                                $this->instant_verification = 1;
                                break;
                        default:
                                $this->instant_verification = 0;
                                break;
                }
  }

  function setAnswerFeedback($answer_feedback = 0)
        {
                switch ($answer_feedback)
                {
                        case 1:
                                $this->answer_feedback = 1;
                                break;
                        default:
                                $this->answer_feedback = 0;
                                break;
                }
  }

        function setAnswerFeedbackPoints($answer_feedback_points = 0)
        {
                switch ($answer_feedback_points)
                {
                        case 1:
                                $this->answer_feedback_points = 1;
                                break;
                        default:
                                $this->answer_feedback_points = 0;
                                break;
                }
        }

        function setRandomTest($a_random_test = 0)
        {
                $this->random_test = $a_random_test;
        }

        function setRandomQuestionCount($a_random_question_count = "")
        {
                $this->random_question_count = $a_random_question_count;
        }

        function setReportingDate($reporting_date)
        {
                if (!$reporting_date)
                {
                        $this->reporting_date = "";
                        $this->ects_output = 0;
                }
                else
                {
                        $this->reporting_date = $reporting_date;
                }
        }

        function getSequenceSettings()
        {
                return ($this->sequence_settings) ? $this->sequence_settings : 0;
        }

        function getScoreReporting()
        {
                return ($this->score_reporting) ? $this->score_reporting : 0;
        }

        function getInstantFeedbackSolution()
        {
                return ($this->instant_verification) ? $this->instant_verification : 0;
        }

        function getAnswerFeedback()
        {
                return ($this->answer_feedback) ? $this->answer_feedback : 0;
        }

        function getAnswerFeedbackPoints()
        {
                return ($this->answer_feedback_points) ? $this->answer_feedback_points : 0;
        }

        function getCountSystem()
        {
                return ($this->count_system) ? $this->count_system : 0;
        }

        function _getCountSystem($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_tests.count_system FROM tst_tests, tst_active WHERE tst_active.active_id = %s AND tst_active.test_fi = tst_tests.test_id",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["count_system"];
                }
                return FALSE;
        }

        function getMCScoring()
        {
                return ($this->mc_scoring) ? $this->mc_scoring : 0;
        }

        function getScoreCutting()
        {
                return ($this->score_cutting) ? $this->score_cutting : 0;
        }

        function getPassword()
        {
                return (strlen($this->password)) ? $this->password : NULL;
        }

        function getPassScoring()
        {
                return ($this->pass_scoring) ? $this->pass_scoring : 0;
        }

        function _getPassScoring($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_tests.pass_scoring FROM tst_tests, tst_active WHERE tst_tests.test_id = tst_active.test_fi AND tst_active.active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["pass_scoring"];
                }
                return 0;
        }

        function _getMCScoring($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_tests.mc_scoring FROM tst_tests, tst_active WHERE tst_active.active_id = %s AND tst_active.test_fi = tst_tests.test_id",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["mc_scoring"];
                }
                return FALSE;
        }

        function _getScoreCutting($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_tests.score_cutting FROM tst_tests, tst_active WHERE tst_active.active_id = %s AND tst_tests.test_id = tst_active.test_fi",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["score_cutting"];
                }
                return FALSE;
        }

        function getReportingDate()
        {
                return (strlen($this->reporting_date)) ? $this->reporting_date : NULL;
        }

        function getNrOfTries()
        {
                return ($this->nr_of_tries) ? $this->nr_of_tries : 0;
        }

        function getKiosk()
        {
                return ($this->_kiosk) ? $this->_kiosk : 0;
        }


        function setKiosk($kiosk = 0)
        {
                $this->_kiosk = $kiosk;
        }

        function getKioskMode()
        {
                if (($this->_kiosk & 1) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        public function setKioskMode($a_kiosk = FALSE)
        {
                if ($a_kiosk)
                {
                        $this->_kiosk = $this->_kiosk | 1;
                }
                else
                {
                        if ($this->getKioskMode())
                        {
                                $this->_kiosk = $this->_kiosk ^ 1;
                        }
                }
        }

        public function getShowKioskModeTitle()
        {
                if (($this->_kiosk & 2) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        public function setShowKioskModeTitle($a_title = FALSE)
        {
                if ($a_title)
                {
                        $this->_kiosk = $this->_kiosk | 2;
                }
                else
                {
                        if ($this->getShowKioskModeTitle())
                        {
                                $this->_kiosk = $this->_kiosk ^ 2;
                        }
                }
        }

        public function getShowKioskModeParticipant()
        {
                if (($this->_kiosk & 4) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        public function setShowKioskModeParticipant($a_participant = FALSE)
        {
                if ($a_participant)
                {
                        $this->_kiosk = $this->_kiosk | 4;
                }
                else
                {
                        if ($this->getShowKioskModeParticipant())
                        {
                                $this->_kiosk = $this->_kiosk ^ 4;
                        }
                }
        }

        function getUsePreviousAnswers()
        {
                return ($this->use_previous_answers) ? $this->use_previous_answers : 0;
        }

        function getTitleOutput()
        {
                return ($this->title_output) ? $this->title_output : 0;
        }

        function _getTitleOutput($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_tests.title_output FROM tst_tests, tst_active WHERE tst_tests.test_id = tst_active.test_fi AND tst_active.active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["title_output"];
                }
                return 0;
        }

        function _getUsePreviousAnswers($active_id, $user_active_user_setting = false)
        {
                global $ilDB;
                global $ilUser;

                $use_previous_answers = 1;

                $result = $ilDB->queryF("SELECT tst_tests.use_previous_answers FROM tst_tests, tst_active WHERE tst_tests.test_id = tst_active.test_fi AND tst_active.active_id = %s",
                        array("integer"),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $use_previous_answers = $row["use_previous_answers"];
                }

                if ($use_previous_answers == 1)
                {
                        if ($user_active_user_setting)
                        {
                                $res = $ilUser->getPref("tst_use_previous_answers");
                                if ($res !== FALSE)
                                {
                                        $use_previous_answers = $res;
                                }
                        }
                }
                return $use_previous_answers;
        }

        function getProcessingTime()
        {
                return (strlen($this->processing_time)) ? $this->processing_time : NULL;
        }

        public function getProcessingTimeAsArray()
        {
                if (strlen($this->processing_time))
                {
                        if (preg_match("/(\d{2}):(\d{2}):(\d{2})/is", $this->processing_time, $matches))
                        {
                                if ((int)$matches[1]+(int)$matches[2]+(int)$matches[3] == 0)
                                {
                                        return $this->getEstimatedWorkingTime();
                                }
                                else
                                {
                                        return array(
                                                'hh' => $matches[1],
                                                'mm' => $matches[2],
                                                'ss' => $matches[3],
                                        );
                                }
                        }
                }
                return $this->getEstimatedWorkingTime();
        }

        function getProcessingTimeInSeconds($active_id = "")
        {
                if (preg_match("/(\d{2}):(\d{2}):(\d{2})/", $this->getProcessingTime(), $matches))
                {
                        $extratime = $this->getExtraTime($active_id) * 60;
                        return ($matches[1] * 3600) + ($matches[2] * 60) + $matches[3] + $extratime;
                }
                        else
                {
                        return 0;
                }
        }

                function getSecondsUntilEndingTime()
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getEndingTime(), $matches))
                        {
                                $ending = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = time();
                                return $ending - $now;
                        }
                        else
                        {
                                return 0;
                        }
                }

        function getEnableProcessingTime()
        {
                return ($this->enable_processing_time) ? $this->enable_processing_time : 0;
        }

        function getResetProcessingTime()
        {
                return ($this->reset_processing_time) ? $this->reset_processing_time : 0;
        }

        function getStartingTime()
        {
                return (strlen($this->starting_time)) ? $this->starting_time : NULL;
        }

        function getEndingTime()
        {
                return (strlen($this->ending_time)) ? $this->ending_time : NULL;
        }

        function setNrOfTries($nr_of_tries = 0)
        {
                $this->nr_of_tries = $nr_of_tries;
        }

        function setUsePreviousAnswers($use_previous_answers = 1)
        {
                if ($use_previous_answers)
                {
                        $this->use_previous_answers = 1;
                }
                else
                {
                        $this->use_previous_answers = 0;
                }
        }

        function setTitleOutput($title_output = 0)
        {
                switch ($title_output)
                {
                        case 1:
                                $this->title_output = 1;
                                break;
                        case 2:
                                $this->title_output = 2;
                                break;
                        default:
                                $this->title_output = 0;
                                break;
                }
        }

        function setProcessingTime($processing_time = "00:00:00")
        {
                $this->processing_time = $processing_time;
        }

        function setEnableProcessingTime($enable = 0)
        {
                if ($enable) {
                        $this->enable_processing_time = "1";
                } else {
                        $this->enable_processing_time = "0";
                }
        }

        function setResetProcessingTime($reset = 0)
        {
                if ($reset) 
                {
                        $this->reset_processing_time = 1;
                } 
                else 
                {
                        $this->reset_processing_time = 0;
                }
        }

        function setStartingTime($starting_time = NULL)
        {
                $this->starting_time = $starting_time;
        }

        function setEndingTime($ending_time = NULL)
        {
                $this->ending_time = $ending_time;
        }

        function setCountSystem($a_count_system = COUNT_PARTIAL_SOLUTIONS)
        {
                $this->count_system = $a_count_system;
        }

        function setPassword($a_password = NULL)
        {
                $this->password = $a_password;
        }

        function setScoreCutting($a_score_cutting = SCORE_CUT_QUESTION)
        {
                $this->score_cutting = $a_score_cutting;
        }

        function setMCScoring($a_mc_scoring = SCORE_ZERO_POINTS_WHEN_UNANSWERED)
        {
                $this->mc_scoring = $a_mc_scoring;
        }

        function setPassScoring($a_pass_scoring = SCORE_LAST_PASS)
        {
                switch ($a_pass_scoring)
                {
                        case SCORE_BEST_PASS:
                                $this->pass_scoring = SCORE_BEST_PASS;
                                break;
                        default:
                                $this->pass_scoring = SCORE_LAST_PASS;
                                break;
                }
        }

        function removeQuestion($question_id)
        {
                $question =& ilObjTest::_instanciateQuestion($question_id);
                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction($this->lng->txtlng("assessment", "log_question_removed", ilObjAssessmentFolder::_getLogLanguage()), $question_id);
                }
                $question->delete($question_id);
                $this->removeAllTestEditings($question_id);
                $this->loadQuestions();
                $this->saveQuestionsToDb();
        }

        public function removeAllTestEditings($question_id = "")
        {
                global $ilDB;
                // remove the question from tst_solutions
                if ($question_id)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_solutions WHERE tst_solutions.active_fi IN (SELECT active_id FROM tst_active WHERE test_fi = %s) AND tst_solutions.question_fi = %s",
                                array('integer','integer'),
                                array($this->getTestId(), $question_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_qst_solved WHERE tst_qst_solved.active_fi IN (SELECT active_id FROM tst_active WHERE test_fi = %s) AND tst_qst_solved.question_fi = %s",
                                array('integer','integer'),
                                array($this->getTestId(), $question_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_result WHERE tst_test_result.active_fi IN (SELECT active_id FROM tst_active WHERE test_fi = %s) AND tst_test_result.question_fi = %s",
                                array('integer','integer'),
                                array($this->getTestId(), $question_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_pass_result WHERE tst_pass_result.active_fi IN (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                } 
                else 
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_solutions WHERE tst_solutions.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_qst_solved WHERE tst_qst_solved.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_result WHERE tst_test_result.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_pass_result WHERE tst_pass_result.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_user_data_removed", ilObjAssessmentFolder::_getLogLanguage()));
                        }
                }
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_sequence WHERE tst_sequence.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                        array('integer'),
                        array($this->getTestId())
                );

                if ($this->isRandomTest())
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_rnd_qst WHERE tst_test_rnd_qst.active_fi IN  (SELECT active_id FROM tst_active WHERE test_fi = %s)",
                                array('integer'),
                                array($this->getTestId())
                        );
                }

                // remove test_active entries, because test has changed
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_active WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );

                // remove saved user passwords
                $affectedRows = $ilDB->manipulateF("DELETE FROM usr_pref WHERE keyword = %s",
                        array('text'),
                        array("tst_password_".$this->getTestId())
                );

                // TODO: this shouldn't be here since it is question stuff and should be modular but there's no other solution yet
                // remove file uploads
                if (@is_dir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId()))
                {
                        ilUtil::delDir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId());
                }
        }

        function removeSelectedTestResults($active_ids)
        {
                global $ilDB;

                // remove the question from tst_solutions
                foreach ($active_ids as $active_id)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_solutions WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_qst_solved WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_result WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_pass_result WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );

                        if ($this->isRandomTest())
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_rnd_qst WHERE active_fi = %s",
                                        array('integer'),
                                        array($active_id)
                                );
                        }

                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction(sprintf($this->lng->txtlng("assessment", "log_selected_user_data_removed", ilObjAssessmentFolder::_getLogLanguage()), $this->userLookupFullName($this->_getUserIdFromActiveId($active_id))));
                        }
                }

                // remove test_active entries of selected users
                foreach ($active_ids as $active_id)
                {
                        $usr_id = $this->_getUserIdFromActiveId($active_id);

                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_active WHERE active_id = %s",
                                array('integer'),
                                array($active_id)
                        );

                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_sequence WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );

                        // remove saved user password
                        if ($usr_id > 0)
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM usr_pref WHERE usr_id = %s AND keyword = %s",
                                        array('integer', 'text'),
                                        array($usr_id, "tst_password_".$this->getTestId())
                                );
                        }

                        // TODO: this shouldn't be here since it is question stuff and should be modular but there's no other solution yet
                        // remove file uploads
                        if (@is_dir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId() . "/$active_id"))
                        {
                                ilUtil::delDir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId() . "/$active_id");
                        }
                }
        }

        function removeTestResultsForUser($user_id)
        {
                global $ilDB;

                $active_id = $this->getActiveIdOfUser($user_id);

                // remove the question from tst_solutions
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_solutions WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_qst_solved WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_result WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_pass_result WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );

                if ($this->isRandomTest())
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_rnd_qst WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                }

                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction(sprintf($this->lng->txtlng("assessment", "log_selected_user_data_removed", ilObjAssessmentFolder::_getLogLanguage()), $this->userLookupFullName($this->_getUserIdFromActiveId($active_id))));
                }

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_sequence WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );

                // remove test_active entry
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_active WHERE active_id = %s",
                        array('integer'),
                        array($active_id)
                );

                // remove saved user password
                if ($user_id > 0)
                {
                        $affectedRows = $ilDB->manipulateF("DELETE FROM usr_pref WHERE usr_id = %s AND keyword = %s",
                                array('integer', 'text'),
                                array($user_id, "tst_password_".$this->getTestId())
                        );
                }

                // TODO: this shouldn't be here since it is question stuff and should be modular but there's no other solution yet
                // remove file uploads
                if (@is_dir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId() . "/$active_id"))
                {
                        ilUtil::delDir(CLIENT_WEB_DIR . "/assessment/tst_" . $this->getTestId() . "/$active_id");
                }
        }

        function questionMoveUp($question_id)
        {
                global $ilDB;

                // Move a question up in sequence
                $result = $ilDB->queryF("SELECT * FROM tst_test_question WHERE test_fi=%s AND question_fi=%s",
                        array('integer', 'integer'),
                        array($this->getTestId(), $question_id)
                );
                $data = $ilDB->fetchObject($result);
                if ($data->sequence > 1) 
                {
                        // OK, it's not the top question, so move it up
                        $result = $ilDB->queryF("SELECT * FROM tst_test_question WHERE test_fi=%s AND sequence=%s",
                                array('integer','integer'),
                                array($this->getTestId(), $data->sequence - 1)
                        );
                        $data_previous = $ilDB->fetchObject($result);
                        // change previous dataset
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                array('integer','integer'),
                                array($data->sequence, $data_previous->test_question_id)
                        );
                        // move actual dataset up
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                array('integer','integer'),
                                array($data->sequence - 1, $data->test_question_id)
                        );
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_question_position_changed", ilObjAssessmentFolder::_getLogLanguage()) . ": " . ($data->sequence) . " => " . ($data->sequence-1), $question_id);
                        }
                }
                $this->loadQuestions();
        }

        function questionMoveDown($question_id)
        {
                global $ilDB;

                // Move a question down in sequence
                $result = $ilDB->queryF("SELECT * FROM tst_test_question WHERE test_fi=%s AND question_fi=%s",
                        array('integer','integer'),
                        array($this->getTestId(), $question_id)
                );
                $data = $ilDB->fetchObject($result);
                $result = $ilDB->queryF("SELECT * FROM tst_test_question WHERE test_fi=%s AND sequence=%s",
                        array('integer','integer'),
                        array($this->getTestId(), $data->sequence + 1)
                );
                if ($result->numRows() == 1)
                {
                        // OK, it's not the last question, so move it down
                        $data_next = $ilDB->fetchObject($result);
                        // change next dataset
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                array('integer','integer'),
                                array($data->sequence, $data_next->test_question_id)
                        );
                        // move actual dataset down
                        $affectedRows = $ilDB->manipulateF("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                array('integer','integer'),
                                array($data->sequence + 1, $data->test_question_id)
                        );
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_question_position_changed", ilObjAssessmentFolder::_getLogLanguage()) . ": " . ($data->sequence) . " => " . ($data->sequence+1), $question_id);
                        }
                }
                $this->loadQuestions();
        }

        function duplicateQuestionForTest($question_id)
        {
                global $ilUser;
                $question =& ilObjTest::_instanciateQuestion($question_id);
                $duplicate_id = $question->duplicate(true);

                return $duplicate_id;
        }

        function insertQuestion($question_id)
        {
                global $ilDB;

                $duplicate_id = $this->duplicateQuestionForTest($question_id);

                // get maximum sequence index in test
                $result = $ilDB->queryF("SELECT MAX(sequence) seq FROM tst_test_question WHERE test_fi=%s",
                        array('integer'),
                        array($this->getTestId())
                );
                $sequence = 1;

                if ($result->numRows() == 1)
                {
                        $data = $ilDB->fetchObject($result);
                        $sequence = $data->seq + 1;
                }

                $next_id = $ilDB->nextId('tst_test_question');
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_question (test_question_id, test_fi, question_fi, sequence, tstamp) VALUES (%s, %s, %s, %s, %s)",
                        array('integer', 'integer','integer','integer','integer'),
                        array($next_id, $this->getTestId(), $duplicate_id, $sequence, time())
                );
                if ($affectedRows == 1) 
                {
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_question_added", ilObjAssessmentFolder::_getLogLanguage()) . ": " . $sequence, $duplicate_id);
                        }
                }
                // remove test_active entries, because test has changed
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_active WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $this->loadQuestions();
                $this->saveCompleteStatus();
        }

        function &getQuestionTitles()
        {
                $titles = array();
                if (!$this->isRandomTest())
                {
                        global $ilDB;
                        $result = $ilDB->queryF("SELECT qpl_questions.title FROM tst_test_question, qpl_questions WHERE tst_test_question.test_fi = %s AND tst_test_question.question_fi = qpl_questions.question_id ORDER BY tst_test_question.sequence",
                                array('integer'),
                                array($this->getTestId())
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($titles, $row["title"]);
                        }
                }
                return $titles;
        }

        function &getQuestionTitlesAndIndexes()
        {
                $titles = array();
                if (!$this->isRandomTest())
                {
                        global $ilDB;
                        $result = $ilDB->queryF("SELECT qpl_questions.title, qpl_questions.question_id FROM tst_test_question, qpl_questions WHERE tst_test_question.test_fi = %s AND tst_test_question.question_fi = qpl_questions.question_id ORDER BY tst_test_question.sequence",
                                array('integer'),
                                array($this->getTestId())
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $titles[$row['question_id']] = $row["title"];
                        }
                }
                return $titles;
        }

        function &getQuestionOIDsByAID()
        {
                $oids = array();
                if (!$this->isRandomTest())
                {
                        global $ilDB;
                        $query = sprintf("SELECT qpl_questions.question_id, qpl_questions.original_id FROM tst_test_question, qpl_questions WHERE tst_test_question.test_fi = %s AND tst_test_question.question_fi = qpl_questions.question_id ORDER BY tst_test_question.sequence",
                                $ilDB->quote($this->getTestId() . "")
                        );
                        $result = $ilDB->query($query);
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $oids[$row['question_id']] = $row["original_id"];
                        }
                }
                return $oids;
        }

        function getQuestionTitle($title)
        {
                if ($this->getTitleOutput() == 2)
                {
                        return $this->lng->txt("ass_question");
                }
                else
                {
                        return $title;
                }
        }

        function getQuestionDataset($question_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT qpl_questions.*, qpl_qst_type.type_tag FROM qpl_questions, qpl_qst_type WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id",
                        array('integer'),
                        array($question_id)
                );
                $row = $ilDB->fetchObject($result);
                return $row;
        }

        function &getExistingQuestions($pass = NULL)
        {
                global $ilUser;
                global $ilDB;

                $existing_questions = array();
                $active_id = $this->getActiveIdOfUser($ilUser->getId());
                if ($this->isRandomTest())
                {
                        if (is_null($pass)) $pass = 0;
                        $result = $ilDB->queryF("SELECT qpl_questions.original_id FROM qpl_questions, tst_test_rnd_qst WHERE tst_test_rnd_qst.active_fi = %s AND tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_test_rnd_qst.pass = %s",
                                array('integer','integer'),
                                array($active_id, $pass)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT qpl_questions.original_id FROM qpl_questions, tst_test_question WHERE tst_test_question.test_fi = %s AND tst_test_question.question_fi = qpl_questions.question_id",
                                array('integer'),
                                array($this->getTestId())
                        );
                }
                while ($data = $ilDB->fetchObject($result)) 
                {
                        array_push($existing_questions, $data->original_id);
                }
                return $existing_questions;
        }

  function getQuestionType($question_id)
        {
                global $ilDB;

                if ($question_id < 1) return -1;
                $result = $ilDB->queryF("SELECT type_tag FROM qpl_questions, qpl_qst_type WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() == 1) 
                {
                        $data = $ilDB->fetchObject($result);
                        return $data->type_tag;
                } 
                else 
                {
                        return "";
                }
        }

        function startWorkingTime($active_id, $question_id, $pass)
        {
                global $ilDB;

                $next_id = $ilDB->nextId('tst_times');
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_times (times_id, active_fi, started, finished, pass, question_fi, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                        array('integer', 'integer', 'timestamp', 'timestamp', 'integer', 'integer', 'integer'),
                        array($next_id, $active_id, strftime("%Y-%m-%d %H:%M:%S"), strftime("%Y-%m-%d %H:%M:%S"), $pass, $question_id, time())
                );
                return $next_id;
        }

        function updateWorkingTime($times_id)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("UPDATE tst_times SET finished = %s, tstamp = %s WHERE times_id = %s",
                        array('timestamp', 'integer', 'integer'),
                        array(strftime("%Y-%m-%d %H:%M:%S"), time(), $times_id)
                );
        }

        function &getWorkedQuestions($active_id, $pass = NULL)
        {
                global $ilUser;
                global $ilDB;

                if (is_null($pass))
                {
                        $result = $ilDB->queryF("SELECT question_fi FROM tst_solutions WHERE active_fi = %s AND pass = %s GROUP BY question_fi",
                                array('integer','integer'),
                                array($active_id, 0)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT question_fi FROM tst_solutions WHERE active_fi = %s AND pass = %s GROUP BY question_fi",
                                array('integer','integer'),
                                array($active_id, $pass)
                        );
                }
                $result_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($result_array, $row["question_fi"]);
                }
                return $result_array;
        }

        function isTestFinishedToViewResults($active_id, $currentpass)
        {
                $num = $this->getPassFinishDate($active_id, $currentpass);
                return ((($currentpass > 0) && ($num == 0)) || $this->isTestFinished($active_id)) ? true : false;
        }

        function &getAllQuestions($pass = NULL)
        {
                global $ilUser;
                global $ilDB;

                $result_array = array();
                if ($this->isRandomTest())
                {
                        $active_id = $this->getActiveIdOfUser($ilUser->getId());
                        $this->loadQuestions($active_id, $pass);
                        if (count($this->questions) == 0) return $result_array;
                        if (is_null($pass))
                        {
                                $pass = $this->_getPass($active_id);
                        }
                        $result = $ilDB->queryF("SELECT qpl_questions.* FROM qpl_questions, tst_test_rnd_qst WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id AND tst_test_rnd_qst.active_fi = %s AND tst_test_rnd_qst.pass = %s AND " . $ilDB->in('qpl_questions.question_id', $this->questions, false, 'integer'),
                                array('integer','integer'),
                                array($active_id, $pass)
                        );
                }
                else
                {
                        if (count($this->questions) == 0) return $result_array;
                        $result = $ilDB->query("SELECT qpl_questions.* FROM qpl_questions, tst_test_question WHERE tst_test_question.question_fi = qpl_questions.question_id AND " . $ilDB->in('qpl_questions.question_id', $this->questions, false, 'integer'));
                }
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $result_array[$row["question_id"]] = $row;
                }
                return $result_array;
        }

                function getActiveIdOfUser($user_id = "", $anonymous_id = "")
                {
                        global $ilDB;
                        global $ilUser;

                        if (!$user_id) $user_id = $ilUser->getId();
                        if (($_SESSION["AccountId"] == ANONYMOUS_USER_ID) && (strlen($_SESSION["tst_access_code"][$this->getTestId()])))
                        {
                                $result = $ilDB->queryF("SELECT active_id FROM tst_active WHERE user_fi = %s AND test_fi = %s AND anonymous_id = %s",
                                        array('integer','integer','text'),
                                        array($user_id, $this->test_id, $_SESSION["tst_access_code"][$this->getTestId()])
                                );
                        }
                        else if (strlen($anonymous_id))
                        {
                                $result = $ilDB->queryF("SELECT active_id FROM tst_active WHERE user_fi = %s AND test_fi = %s AND anonymous_id = %s",
                                        array('integer','integer','text'),
                                        array($user_id, $this->test_id, $anonymous_id)
                                );
                        }
                        else
                        {
                                if ($_SESSION["AccountId"] == ANONYMOUS_USER_ID)
                                {
                                        return NULL;
                                }
                                $result = $ilDB->queryF("SELECT active_id FROM tst_active WHERE user_fi = %s AND test_fi = %s",
                                        array('integer','integer'),
                                        array($user_id, $this->test_id)
                                );
                        }
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                return $row["active_id"];
                        }
                        else
                        {
                                return 0;
                        }
                }

        function _getActiveIdOfUser($user_id = "", $test_id = "") 
        {
                global $ilDB;
                global $ilUser;

                if (!$user_id) {
                        $user_id = $ilUser->id;
                }
                if (!$test_id)
                {
                        return "";
                }
                $result = $ilDB->queryF("SELECT tst_active.active_id FROM tst_active WHERE user_fi = %s AND test_fi = %s",
                        array('integer', 'integer'),
                        array($user_id, $test_id)
                );
                if ($result->numRows()) 
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["active_id"];
                } 
                else 
                {
                        return "";
                }
        }

        function pcArrayShuffle($array)
        {
                $keys = array_keys($array);
                shuffle($keys);
                $result = array();
                foreach ($keys as $key)
                {
                        $result[$key] = $array[$key];
                }
                return $result;
        }
        
        function &getTestResult($active_id, $pass = NULL, $ordered_sequence = FALSE)
        {
                global $ilDB;

                $results = $this->getResultsForActiveId($active_id);
                if (is_null($pass))
                {
                        $pass = $results['pass'];
                }
                include_once "./Modules/Test/classes/class.ilTestSequence.php";
                $testSequence = new ilTestSequence($active_id, $pass, $this->isRandomTest());
                $sequence = array();
                if ($ordered_sequence)
                {
                        $sequence = $testSequence->getOrderedSequenceQuestions();
                }
                else
                {
                        $sequence = $testSequence->getUserSequenceQuestions();
                }
                $arrResults = array();
                $solutionresult = $ilDB->queryF("SELECT tst_test_result.question_fi, tst_test_result.points reached, tst_solutions.solution_id workedthru FROM tst_test_result LEFT JOIN tst_solutions ON tst_solutions.active_fi = tst_test_result.active_fi AND tst_solutions.question_fi = tst_test_result.question_fi WHERE tst_test_result.active_fi = %s AND tst_test_result.pass = %s",
                        array('integer', 'integer'),
                        array($active_id, $pass)
                );
                while ($row = $ilDB->fetchAssoc($solutionresult))
                {
                        $arrResults[$row['question_fi']] = $row;
                }

                require_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                $result = $ilDB->query("SELECT qpl_questions.*, qpl_qst_type.type_tag, qpl_sol_sug.question_fi has_sug_sol FROM qpl_qst_type, qpl_questions LEFT JOIN qpl_sol_sug ON qpl_sol_sug.question_fi = qpl_questions.question_id WHERE qpl_qst_type.question_type_id = qpl_questions.question_type_fi AND " . $ilDB->in('qpl_questions.question_id', $sequence, false, 'integer'));
                $found = array();
                $unordered = array();
                $key = 1;
                $pass_max = 0;
                $pass_reached = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $percentvalue = ($row['points']) ? $arrResults[$row['question_id']]['reached'] / $row['points'] : 0;
                        if ($percentvalue < 0) $percentvalue = 0.0;
                        $data = array(
                                "nr" => "$key",
                                "title" => ilUtil::prepareFormOutput($row['title']),
                                "max" => round($row['points'], 2),
                                "reached" => round($arrResults[$row['question_id']]['reached'],2),
                                "percent" => sprintf("%2.2f ", ($percentvalue) * 100) . "%",
                                "solution" => ($row['has_sug_sol']) ? assQuestion::_getSuggestedSolutionOutput($row['question_id']) : '',
                                "type" => $row["type_tag"],
                                "qid" => $row['question_id'],
                                "original_id" => $row["original_id"],
                                "workedthrough" => ($arrResults[$row['question_id']]['workedthru']) ? 1 : 0
                        );
                        $pass_max += round($row['points'], 2);
                        $pass_reached += round($arrResults[$row['question_id']]['reached'], 2);
                        $unordered[$row['question_id']] = $data;
                        $key++;
                }
                $key = 1;
                foreach ($sequence as $qid)
                {
                        $unordered[$qid]['nr'] = $key;
                        array_push($found, $unordered[$qid]);
                        $key++;
                }
                $unordered = null;
                if ($this->getScoreCutting() == 1)
                {
                        if ($results['reached_points'] < 0)
                        {
                                $results['reached_points'] = 0;
                        }
                        if ($pass_reached < 0) $pass_reached = 0;
                }
                $found['pass']['total_max_points'] = $pass_max;
                $found['pass']['total_reached_points'] = $pass_reached;
                $found['pass']['percent'] = ($pass_max > 0) ? $pass_reached / $pass_max : 0;
                $found["test"]["total_max_points"] = $results['max_points'];
                $found["test"]["total_reached_points"] = $results['reached_points'];
                $found["test"]["result_pass"] = $results['pass'];
                if ((!$total_reached_points) or (!$total_max_points))
                {
                        $percentage = 0.0;
                }
                else
                {
                        $percentage = ($total_reached_points / $total_max_points) * 100.0;
                        if ($percentage < 0) $percentage = 0.0;
                }
                $found["test"]["passed"] = $results['passed'];
                return $found;
        }

        function evalTotalPersons()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT COUNT(active_id) total FROM tst_active WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $row = $ilDB->fetchAssoc($result);
                return $row["total"];
        }

        function getCompleteWorkingTime($user_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi AND tst_active.user_fi = %s",
                        array('integer','integer'),
                        array($this->getTestId(), $user_id)
                );
                $time = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["finished"], $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        $time += ($epoch_2 - $epoch_1);
                }
                return $time;
        }

        function &getCompleteWorkingTimeOfParticipants()
        {
                return $this->_getCompleteWorkingTimeOfParticipants($this->getTestId());
        }

        function &_getCompleteWorkingTimeOfParticipants($test_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi ORDER BY tst_times.active_fi, tst_times.started",
                        array('integer'),
                        array($test_id)
                );
                $time = 0;
                $times = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (!array_key_exists($row["active_fi"], $times))
                        {
                                $times[$row["active_fi"]] = 0;
                        }
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["finished"], $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        $times[$row["active_fi"]] += ($epoch_2 - $epoch_1);
                }
                return $times;
        }

        function getCompleteWorkingTimeOfParticipant($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi AND tst_active.active_id = %s ORDER BY tst_times.active_fi, tst_times.started",
                        array('integer','integer'),
                        array($this->getTestId(), $active_id)
                );
                $time = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["finished"], $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        $time += ($epoch_2 - $epoch_1);
                }
                return $time;
        }

        function _getWorkingTimeOfParticipantForPass($active_id, $pass)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM tst_times WHERE active_fi = %s AND pass = %s ORDER BY started",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                $time = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["finished"], $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        $time += ($epoch_2 - $epoch_1);
                }
                return $time;
        }

        function getVisitTimeOfParticipant($active_id)
        {
                return ilObjTest::_getVisitTimeOfParticipant($this->getTestId(), $active_id);
        }

        function _getVisitTimeOfParticipant($test_id, $active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi AND tst_active.active_id = %s ORDER BY tst_times.started",
                        array('integer','integer'),
                        array($test_id, $active_id)
                );
                $firstvisit = 0;
                $lastvisit = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        if ($firstvisit == 0 || $epoch_1 < $firstvisit) $firstvisit = $epoch_1;
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["finished"], $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        if ($epoch_2 > $lastvisit) $lastvisit = $epoch_2;
                }
                return array("firstvisit" => $firstvisit, "lastvisit" => $lastvisit);
        }

        function &evalStatistical($active_id)
        {
                global $ilDB;
//              global $ilBench;
                $pass = ilObjTest::_getResultPass($active_id);
                $test_result =& $this->getTestResult($active_id, $pass);
                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.active_id = %s AND tst_active.active_id = tst_times.active_fi",
                        array('integer'),
                        array($active_id)
                );
                $times = array();
                $first_visit = 0;
                $last_visit = 0;
                while ($row = $ilDB->fetchObject($result)) 
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row->started, $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        if (!$first_visit) {
                                $first_visit = $epoch_1;
                        }
                        if ($epoch_1 < $first_visit) {
                                $first_visit = $epoch_1;
                        }
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row->finished, $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        if (!$last_visit) {
                                $last_visit = $epoch_2;
                        }
                        if ($epoch_2 > $last_visit) {
                                $last_visit = $epoch_2;
                        }
                        $times[$row->active_fi] += ($epoch_2 - $epoch_1);
                }
                $max_time = 0;
                foreach ($times as $key => $value) {
                        $max_time += $value;
                }
                if ((!$test_result["test"]["total_reached_points"]) or (!$test_result["test"]["total_max_points"]))
                {
                        $percentage = 0.0;
                }
                else
                {
                        $percentage = ($test_result["test"]["total_reached_points"] / $test_result["test"]["total_max_points"]) * 100.0;
                        if ($percentage < 0) $percentage = 0.0;
                }
                $mark_obj = $this->mark_schema->getMatchingMark($percentage);
                $first_date = getdate($first_visit);
                $last_date = getdate($last_visit);
                $qworkedthrough = 0;
                foreach ($test_result as $key => $value)
                {
                        if (preg_match("/\d+/", $key))
                        {
                                $qworkedthrough += $value["workedthrough"];
                        }
                }
                if (!$qworkedthrough)
                {
                        $atimeofwork = 0;
                }
                else
                {
                        $atimeofwork = $max_time / $qworkedthrough;
                }
                $result_mark = "";
                $passed = "";
                if ($mark_obj)
                {
                        $result_mark = $mark_obj->getShortName();
                        if ($mark_obj->getPassed())
                        {
                                $passed = 1;
                        }
                        else
                        {
                                $passed = 0;
                        }
                }
                $percent_worked_through = 0;
                if (count($this->questions))
                {
                        $percent_worked_through = $qworkedthrough / count($this->questions);
                }
                $result_array = array(
                        "qworkedthrough" => $qworkedthrough,
                        "qmax" => count($this->questions),
                        "pworkedthrough" => $percent_worked_through,
                        "timeofwork" => $max_time,
                        "atimeofwork" => $atimeofwork,
                        "firstvisit" => $first_date,
                        "lastvisit" => $last_date,
                        "resultspoints" => $test_result["test"]["total_reached_points"],
                        "maxpoints" => $test_result["test"]["total_max_points"],
                        "resultsmarks" => $result_mark,
                        "passed" => $passed,
                        "distancemedian" => "0"
                );
                foreach ($test_result as $key => $value)
                {
                        if (preg_match("/\d+/", $key))
                        {
                                $result_array[$key] = $value;
                        }
                }
                return $result_array;
        }

        function &getTotalPointsPassedArray()
        {
                $totalpoints_array = array();
                $all_users =& $this->evalTotalParticipantsArray();
                foreach ($all_users as $active_id => $user_name)
                {
                        $test_result =& $this->getTestResult($active_id);
                        $reached = $test_result["test"]["total_reached_points"];
                        $total = $test_result["test"]["total_max_points"];
                        $percentage = $total != 0 ? $reached/$total : 0;
                        $mark = $this->mark_schema->getMatchingMark($percentage*100.0);
                        if ($mark)
                        {
                                if ($mark->getPassed())
                                {
                                        array_push($totalpoints_array, $test_result["test"]["total_reached_points"]);
                                }
                        }
                }
                return $totalpoints_array;
        }

        function &getParticipants()
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_active.active_id, usr_data.usr_id, usr_data.firstname, usr_data.lastname, usr_data.title, usr_data.login FROM tst_active LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id WHERE tst_active.test_fi = %s ORDER BY usr_data.lastname ASC",
                        array('integer'),
                        array($this->getTestId())
                );
                $persons_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $name = $this->lng->txt("unknown");
                        $fullname = $this->lng->txt("unknown");
                        $login = "";
                        if (!$this->getAnonymity())
                        {
                                if (strlen($row["firstname"].$row["lastname"].$row["title"]) == 0)
                                {
                                        $name = $this->lng->txt("deleted_user");
                                        $fullname = $this->lng->txt("deleted_user");
                                        $login = $this->lng->txt("unknown");
                                }
                                else
                                {
                                        $login = $row["login"];
                                        if ($row["user_fi"] == ANONYMOUS_USER_ID)
                                        {
                                                $name = $this->lng->txt("unknown");
                                                $fullname = $this->lng->txt("unknown");
                                        }
                                        else
                                        {
                                                $name = trim($row["lastname"] . ", " . $row["firstname"] . " " .  $row["title"]);
                                                $fullname = trim($row["title"] . " " . $row["firstname"] . " " .  $row["lastname"]);
                                        }
                                }
                        }
                        $persons_array[$row["active_id"]] = array(
                                "name" => $name,
                                "fullname" => $fullname,
                                "login" => $login
                        );
                }
                return $persons_array;
        }

        function &evalTotalPersonsArray($name_sort_order = "asc")
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_active.active_id, usr_data.firstname, usr_data.lastname, usr_data.title FROM tst_active LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id WHERE tst_active.test_fi = %s ORDER BY usr_data.lastname " . strtoupper($name_sort_order),
                        array('integer'),
                        array($this->getTestId())
                );
                $persons_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if ($this->getAnonymity())
                        {
                                $persons_array[$row["active_id"]] = $this->lng->txt("unknown");
                        }
                        else
                        {
                                if (strlen($row["firstname"].$row["lastname"].$row["title"]) == 0)
                                {
                                        $persons_array[$row["active_id"]] = $this->lng->txt("deleted_user");
                                }
                                else
                                {
                                        if ($row["user_fi"] == ANONYMOUS_USER_ID)
                                        {
                                                $persons_array[$row["active_id"]] = $row["lastname"];
                                        }
                                        else
                                        {
                                                $persons_array[$row["active_id"]] = trim($row["lastname"] . ", " . $row["firstname"] . " " .  $row["title"]);
                                        }
                                }
                        }
                }
                return $persons_array;
        }

        function &evalTotalParticipantsArray($name_sort_order = "asc")
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tst_active.active_id, usr_data.login, usr_data.firstname, usr_data.lastname, usr_data.title FROM tst_active LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id WHERE tst_active.test_fi = %s ORDER BY usr_data.lastname " . strtoupper($name_sort_order),
                        array('integer'),
                        array($this->getTestId())
                );
                $persons_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if ($this->getAnonymity())
                        {
                                $persons_array[$row["active_id"]] = array("name" => $this->lng->txt("unknown"));
                        }
                        else
                        {
                                if (strlen($row["firstname"].$row["lastname"].$row["title"]) == 0)
                                {
                                        $persons_array[$row["active_id"]] = array("name" => $this->lng->txt("deleted_user"));
                                }
                                else
                                {
                                        if ($row["user_fi"] == ANONYMOUS_USER_ID)
                                        {
                                                $persons_array[$row["active_id"]] = array("name" => $row["lastname"]);
                                        }
                                        else
                                        {
                                                $persons_array[$row["active_id"]] = array("name" => trim($row["lastname"] . ", " . $row["firstname"] . " " .  $row["title"]), "login" => $row["login"]);
                                        }
                                }
                        }
                }
                return $persons_array;
        }

        function evalTotalFinished()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT COUNT(active_id) total FROM tst_active WHERE test_fi = %s AND submitted = %s",
                        array('integer', 'integer'),
                        array($this->getTestId(), 1)
                );
                $row = $ilDB->fetchAssoc($result);
                return $row["total"];
        }

        function &getQuestionsOfTest($active_id)
        {
                global $ilDB;
                if ($this->isRandomTest())
                {
                        $ilDB->setLimit($this->getQuestionCount(), 0);
                        $result = $ilDB->queryF("SELECT tst_test_rnd_qst.sequence, tst_test_rnd_qst.question_fi, " .
                                "tst_test_rnd_qst.pass, qpl_questions.points " .
                                "FROM tst_test_rnd_qst, qpl_questions " .
                                "WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id " .
                                "AND tst_test_rnd_qst.active_fi = %s ORDER BY tst_test_rnd_qst.sequence",
                                array('integer'),
                                array($active_id)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT tst_test_question.sequence, tst_test_question.question_fi, " .
                                "qpl_questions.points " .
                                "FROM tst_test_question, tst_active, qpl_questions " .
                                "WHERE tst_test_question.question_fi = qpl_questions.question_id " .
                                "AND tst_active.active_id = %s AND tst_active.test_fi = tst_test_question.test_fi",
                                array('integer'),
                                array($active_id)
                        );
                }
                $qtest = array();
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($qtest, $row);
                        }
                }
                return $qtest;
        }
        
        function &getQuestionsOfPass($active_id, $pass)
        {
                global $ilDB;
                if ($this->isRandomTest())
                {
                        $ilDB->setLimit($this->getQuestionCount(), 0);
                        $result = $ilDB->queryF("SELECT tst_test_rnd_qst.sequence, tst_test_rnd_qst.question_fi, " .
                                "qpl_questions.points " .
                                "FROM tst_test_rnd_qst, qpl_questions " .
                                "WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id " .
                                "AND tst_test_rnd_qst.active_fi = %s AND tst_test_rnd_qst.pass = %s " .
                                "ORDER BY tst_test_rnd_qst.sequence",
                                array('integer', 'integer'),
                                array($active_id, $pass)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT tst_test_question.sequence, tst_test_question.question_fi, " .
                                "qpl_questions.points " .
                                "FROM tst_test_question, tst_active, qpl_questions " .
                                "WHERE tst_test_question.question_fi = qpl_questions.question_id " .
                                "AND tst_active.active_id = %s AND tst_active.test_fi = tst_test_question.test_fi",
                                array('integer'),
                                array($active_id)
                        );
                }
                $qpass = array();
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($qpass, $row);
                        }
                }
                return $qpass;
        }
        
        function getUnfilteredEvaluationData()
        {
                global $ilDB;
                include_once "./Modules/Test/classes/class.ilTestEvaluationPassData.php";
                include_once "./Modules/Test/classes/class.ilTestEvaluationUserData.php";
                include_once "./Modules/Test/classes/class.ilTestEvaluationData.php";
                $data = new ilTestEvaluationData($this);
                $result = $ilDB->queryF("SELECT tst_test_result.*, qpl_questions.original_id, qpl_questions.title questiontitle, " .
                        "qpl_questions.points maxpoints " .
                        "FROM tst_test_result, qpl_questions, tst_active " .
                        "WHERE tst_active.active_id = tst_test_result.active_fi " .
                        "AND qpl_questions.question_id = tst_test_result.question_fi " .
                        "AND tst_active.test_fi = %s " .
                        "ORDER BY tst_active.active_id, tst_test_result.pass, tst_test_result.tstamp",
                        array('integer'),
                        array($this->getTestId())
                );
                $pass = NULL;
                $checked = array();
                $datasets = 0;
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $data->getParticipant($row["active_fi"])->getPass($row["pass"])->addAnsweredQuestion($row["question_fi"], $row["maxpoints"], $row["points"]);
                }

                foreach (array_keys($data->getParticipants()) as $active_id)
                {
                        if ($this->isRandomTest())
                        {
                                for ($testpass = 0; $testpass <= $data->getParticipant($active_id)->getLastPass(); $testpass++)
                                {
                                        $ilDB->setLimit($this->getQuestionCount(), 0);
                                        $result = $ilDB->queryF("SELECT tst_test_rnd_qst.sequence, tst_test_rnd_qst.question_fi, qpl_questions.original_id, " .
                                                "tst_test_rnd_qst.pass, qpl_questions.points, qpl_questions.title " .
                                                "FROM tst_test_rnd_qst, qpl_questions " .
                                                "WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id " .
                                                "AND tst_test_rnd_qst.pass = %s " .
                                                "AND tst_test_rnd_qst.active_fi = %s ORDER BY tst_test_rnd_qst.sequence",
                                                array('integer','integer'),
                                                array($testpass, $active_id)
                                        );
                                        if ($result->numRows())
                                        {
                                                while ($row = $ilDB->fetchAssoc($result))
                                                {
                                                        $tpass = array_key_exists("pass", $row) ? $row["pass"] : 0;
                                                        $data->getParticipant($active_id)->addQuestion($row["original_id"] ? $row["original_id"] : $row["question_fi"], $row["question_fi"], $row["points"], $row["sequence"], $tpass);
                                                        $data->addQuestionTitle($row["question_fi"], $row["title"]);
                                                }
                                        }
                                }
                        }
                        else
                        {
                                $result = $ilDB->queryF("SELECT tst_test_question.sequence, tst_test_question.question_fi, " .
                                        "qpl_questions.points, qpl_questions.title, qpl_questions.original_id " .
                                        "FROM tst_test_question, tst_active, qpl_questions " .
                                        "WHERE tst_test_question.question_fi = qpl_questions.question_id " .
                                        "AND tst_active.active_id = %s AND tst_active.test_fi = tst_test_question.test_fi ORDER BY tst_test_question.sequence",
                                        array('integer'),
                                        array($active_id)
                                );
                                if ($result->numRows())
                                {
                                        $questionsbysequence = array();
                                        while ($row = $ilDB->fetchAssoc($result))
                                        {
                                                $questionsbysequence[$row["sequence"]] = $row;
                                        }
                                        $seqresult = $ilDB->queryF("SELECT * FROM tst_sequence WHERE active_fi = %s",
                                                array('integer'),
                                                array($active_id)
                                        );
                                        while ($seqrow = $ilDB->fetchAssoc($seqresult))
                                        {
                                                $questionsequence = unserialize($seqrow["sequence"]);
                                                foreach ($questionsequence as $sidx => $seq)
                                                {
                                                        $qsid = $questionsbysequence[$seq]["original_id"] ? $questionsbysequence[$seq]["original_id"] : $questionsbysequence[$seq]["question_fi"];
                                                        $data->getParticipant($active_id)->addQuestion($qsid, $questionsbysequence[$seq]["question_fi"], $questionsbysequence[$seq]["points"], $sidx + 1, $seqrow["pass"]);
                                                        $data->addQuestionTitle($questionsbysequence[$seq]["question_fi"], $questionsbysequence[$seq]["title"]);
                                                }
                                        }
                                }
                        }
                }

                if ($this->ects_output)
                {
                        $passed_array =& $this->getTotalPointsPassedArray();
                }
                foreach (array_keys($data->getParticipants()) as $active_id)
                {
                        $percentage = $data->getParticipant($active_id)->getReachedPointsInPercent();
                        $mark = $this->mark_schema->getMatchingMark($percentage);
                        if (is_object($mark))
                        {
                                $data->getParticipant($active_id)->setMark($mark->getShortName());
                                $data->getParticipant($active_id)->setMarkOfficial($mark->getOfficialName());
                                $data->getParticipant($active_id)->setPassed($mark->getPassed());
                        }
                        if ($this->ects_output)
                        {
                                $ects_mark = $this->getECTSGrade($passed_array, $data->getParticipant($active_id)->getReached(), $data->getParticipant($active_id)->getMaxPoints());
                                $data->getParticipant($active_id)->setECTSMark($ects_mark);
                        }
                        $visitingTime =& $this->getVisitTimeOfParticipant($active_id);
                        $data->getParticipant($active_id)->setFirstVisit($visitingTime["firstvisit"]);
                        $data->getParticipant($active_id)->setLastVisit($visitingTime["lastvisit"]);
                }
                return $data;
        }
        
        function _getQuestionCountAndPointsForPassOfParticipant($active_id, $pass)
        {
                global $ilDB;
                $random = ilObjTest::_lookupRandomTestFromActiveId($active_id);
                if ($random)
                {
                        $result = $ilDB->queryF("SELECT tst_test_rnd_qst.pass, COUNT(tst_test_rnd_qst.question_fi) qcount, " .
                                "SUM(qpl_questions.points) qsum FROM tst_test_rnd_qst, qpl_questions " .
                                "WHERE tst_test_rnd_qst.question_fi = qpl_questions.question_id AND " .
                                "tst_test_rnd_qst.active_fi = %s and pass = %s GROUP BY tst_test_rnd_qst.active_fi, " .
                                "tst_test_rnd_qst.pass",
                                array('integer', 'integer'),
                                array($active_id, $pass)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT COUNT(tst_test_question.question_fi) qcount, " .
                                "SUM(qpl_questions.points) qsum FROM tst_test_question, qpl_questions, tst_active " .
                                "WHERE tst_test_question.question_fi = qpl_questions.question_id AND tst_test_question.test_fi = tst_active.test_fi AND " .
                                "tst_active.active_id = %s GROUP BY tst_test_question.test_fi",
                                array('integer'),
                                array($active_id)
                        );
                }
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return array("count" => $row["qcount"], "points" => $row["qsum"]);
                }
                else
                {
                        return array("count" => 0, "points" => 0);
                }
        }

        function &getCompleteEvaluationData($withStatistics = TRUE, $filterby = "", $filtertext = "")
        {
                include_once "./Modules/Test/classes/class.ilTestEvaluationData.php";
                include_once "./Modules/Test/classes/class.ilTestEvaluationPassData.php";
                include_once "./Modules/Test/classes/class.ilTestEvaluationUserData.php";
                $data = $this->getUnfilteredEvaluationData();
                if ($withStatistics)
                {
                        $data->calculateStatistics();
                }
                $data->setFilter($filterby, $filtertext);
                return $data;
        }
        
        function &evalResultsOverview()
        {
                return $this->_evalResultsOverview($this->getTestId());
        }

        function &_evalResultsOverview($test_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT usr_data.usr_id, usr_data.firstname, usr_data.lastname, usr_data.title, usr_data.login, " .
                        "tst_test_result.*, qpl_questions.original_id, qpl_questions.title questiontitle, " .
                        "qpl_questions.points maxpoints " .
                        "FROM tst_test_result, qpl_questions, tst_active " .
                        "LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id " .
                        "WHERE tst_active.active_id = tst_test_result.active_fi " .
                        "AND qpl_questions.question_id = tst_test_result.question_fi " .
                        "AND tst_active.test_fi = %s " .
                        "ORDER BY tst_active.active_id, tst_test_result.pass, tst_test_result.tstamp",
                        array('integer'),
                        array($test_id)
                );
                $overview = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (!array_key_exists($row["active_fi"], $overview))
                        {
                                $overview[$row["active_fi"]] = array();
                                $overview[$row["active_fi"]]["firstname"] = $row["firstname"];
                                $overview[$row["active_fi"]]["lastname"] = $row["lastname"];
                                $overview[$row["active_fi"]]["title"] = $row["title"];
                                $overview[$row["active_fi"]]["login"] = $row["login"];
                                $overview[$row["active_fi"]]["usr_id"] = $row["usr_id"];
                                $overview[$row["active_fi"]]["started"] = $row["started"];
                                $overview[$row["active_fi"]]["finished"] = $row["finished"];
                        }
                        if (!array_key_exists($row["pass"], $overview[$row["active_fi"]]))
                        {
                                $overview[$row["active_fi"]][$row["pass"]] = array();
                                $overview[$row["active_fi"]][$row["pass"]]["reached"] = 0;
                                $overview[$row["active_fi"]][$row["pass"]]["maxpoints"] = $row["maxpoints"];
                        }
                        array_push($overview[$row["active_fi"]][$row["pass"]], $row);
                        $overview[$row["active_fi"]][$row["pass"]]["reached"] += $row["points"];
                }
                return $overview;
        }

        function &evalResultsOverviewOfParticipant($active_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT usr_data.usr_id, usr_data.firstname, usr_data.lastname, usr_data.title, usr_data.login, " .
                        "tst_test_result.*, qpl_questions.original_id, qpl_questions.title questiontitle, " .
                        "qpl_questions.points maxpoints " .
                        "FROM tst_test_result, qpl_questions, tst_active " .
                        "LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id " .
                        "WHERE tst_active.active_id = tst_test_result.active_fi " .
                        "AND qpl_questions.question_id = tst_test_result.question_fi " .
                        "AND tst_active.test_fi = %s AND tst_active.active_id = %s" .
                        "ORDER BY tst_active.active_id, tst_test_result.pass, tst_test_result.tstamp",
                        array('integer', 'integer'),
                        array($this->getTestId(), $active_id)
                );
                $overview = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (!array_key_exists($row["active_fi"], $overview))
                        {
                                $overview[$row["active_fi"]] = array();
                                $overview[$row["active_fi"]]["firstname"] = $row["firstname"];
                                $overview[$row["active_fi"]]["lastname"] = $row["lastname"];
                                $overview[$row["active_fi"]]["title"] = $row["title"];
                                $overview[$row["active_fi"]]["login"] = $row["login"];
                                $overview[$row["active_fi"]]["usr_id"] = $row["usr_id"];
                                $overview[$row["active_fi"]]["started"] = $row["started"];
                                $overview[$row["active_fi"]]["finished"] = $row["finished"];
                        }
                        if (!array_key_exists($row["pass"], $overview[$row["active_fi"]]))
                        {
                                $overview[$row["active_fi"]][$row["pass"]] = array();
                                $overview[$row["active_fi"]][$row["pass"]]["reached"] = 0;
                                $overview[$row["active_fi"]][$row["pass"]]["maxpoints"] = $row["maxpoints"];
                        }
                        array_push($overview[$row["active_fi"]][$row["pass"]], $row);
                        $overview[$row["active_fi"]][$row["pass"]]["reached"] += $row["points"];
                }
                return $overview;
        }

        function buildName($user_id, $firstname, $lastname, $title)
        {
                global $lng;
                
                $name = "";
                if (strlen($firstname.$lastname.$title) == 0)
                {
                        $name = $lng->txt("deleted_user");
                }
                else
                {
                        if ($user_id == ANONYMOUS_USER_ID)
                        {
                                $name = $lastname;
                        }
                        else
                        {
                                $name = trim($lastname . ", " . $firstname . " " .  $title);
                        }
                        if ($this->getAnonymity())
                        {
                                $name = $lng->txt("anonymous");
                        }
                }
                return $name;
        }

        function _buildName($is_anonymous, $user_id, $firstname, $lastname, $title)
        {
                global $lng;
                $name = "";
                if (strlen($firstname.$lastname.$title) == 0)
                {
                        $name = $lng->txt("deleted_user");
                }
                else
                {
                        if ($user_id == ANONYMOUS_USER_ID)
                        {
                                $name = $lastname;
                        }
                        else
                        {
                                $name = trim($lastname . ", " . $firstname . " " .  $title);
                        }
                        if ($is_anonymous)
                        {
                                $name = $lng->txt("anonymous");
                        }
                }
                return $name;
        }

        function evalTotalStartedAverageTime()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi",
                        array('integer'),
                        array($this->getTestId())
                );
                $times = array();
                while ($row = $ilDB->fetchObject($result))
                {
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row->started, $matches);
                        $epoch_1 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row->finished, $matches);
                        $epoch_2 = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        $times[$row->active_fi] += ($epoch_2 - $epoch_1);
                }
                $max_time = 0;
                $counter = 0;
                foreach ($times as $key => $value)
                {
                        $max_time += $value;
                        $counter++;
                }
                if ($counter)
                {
                        $average_time = round($max_time / $counter);
                }
                        else
                {
                        $average_time = 0;
                }
                return $average_time;
        }

        function &getAvailableQuestionpools($use_object_id = false, $equal_points = false, $could_be_offline = false, $show_path = FALSE, $with_questioncount = FALSE, $permission = "read")
        {
                include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                return ilObjQuestionPool::_getAvailableQuestionpools($use_object_id, $equal_points, $could_be_offline, $show_path, $with_questioncount, $permission);
        }

        function getEstimatedWorkingTime()
        {
                $time_in_seconds = 0;
                foreach ($this->questions as $question_id)
                {
                        $question =& ilObjTest::_instanciateQuestion($question_id);
                        $est_time = $question->getEstimatedWorkingTime();
                        $time_in_seconds += $est_time["h"] * 3600 + $est_time["m"] * 60 + $est_time["s"];
                }
                $hours = (int)($time_in_seconds / 3600) ;
                $time_in_seconds = $time_in_seconds - ($hours * 3600);
                $minutes = (int)($time_in_seconds / 60);
                $time_in_seconds = $time_in_seconds - ($minutes * 60);
                $result = array("hh" => $hours, "mm" => $minutes, "ss" => $time_in_seconds);
                return $result;
        }

        public function generateRandomPass($nr, $qpls, $pass = NULL)
        {
                global $ilDB;
                $qplids = array();
                foreach ($qpls as $arr) array_push($qplids, $arr['qpl']);
                $result = $ilDB->queryF('SELECT * FROM tst_rnd_cpy WHERE tst_fi = %s AND ' . $ilDB->in('qpl_fi', $qplids, false, 'integer'),
                        array('integer'),
                        array($this->getTestId())
                );
                if ($result->numRows())
                {
                        $ids = array();
                        while ($row = $ilDB->fetchAssoc($result)) array_push($ids, $row['qst_fi']);
                        $nr = ($nr > count($ids)) ? count($ids) : $nr;
                        if ($nr == 0) return array();
                        $rand_keys = array_rand($ids, $nr);
                        $selection = array();
                        if (is_array($rand_keys))
                        {
                                foreach ($rand_keys as $key)
                                {
                                        $selection[$ids[$key]] = $ids[$key];
                                }
                        }
                        else
                        {
                                $selection[$ids[$rand_keys]] = $ids[$rand_keys];
                        }
                        return $selection;
                }
                else
                {
                        // old style random questions
                        return $this->randomSelectQuestions($nr, 0, 1, $qplids, $pass);
                }
        }

        function randomSelectQuestions($nr_of_questions, $questionpool, $use_obj_id = 0, $qpls = "", $pass = NULL)
        {
                global $rbacsystem;
                global $ilDB;

                // retrieve object id instead of ref id if necessary
                if (($questionpool != 0) && (!$use_obj_id)) $questionpool = ilObject::_lookupObjId($questionpool);

                // get original ids of all existing questions in the test
                $result = $ilDB->queryF("SELECT qpl_questions.original_id FROM qpl_questions, tst_test_question WHERE qpl_questions.question_id = tst_test_question.question_fi AND qpl_questions.tstamp > 0 AND tst_test_question.test_fi = %s",
                        array("integer"),
                        array($this->getTestId())
                );
                $original_ids = array();
                $paramtypes = array();
                $paramvalues = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($original_ids, $row['original_id']);
                }

                $available = "";
                // get a list of all available questionpools
                if (($questionpool == 0) && (!is_array($qpls)))
                {
                        include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                        $available_pools = array_keys(ilObjQuestionPool::_getAvailableQuestionpools($use_object_id = TRUE, $equal_points = FALSE, $could_be_offline = FALSE, $showPath = FALSE, $with_questioncount = FALSE, "read", ilObject::_lookupOwner($this->getId())));
                        if (count($available_pools))
                        {
                                $available = " AND " . $ilDB->in('obj_fi', $available_pools, false, 'integer');
                        }
                        else
                        {
                                return array();
                        }
                }

                $constraint_qpls = "";
                $result_array = array();
                if ($questionpool == 0)
                {
                        if (is_array($qpls))
                        {
                                if (count($qpls) > 0)
                                {
                                        $constraint_qpls = " AND " . $ilDB->in('obj_fi', $qpls, false, 'integer');
                                }
                        }
                }

                $original_clause = "";
                if (count($original_ids))
                {
                        $original_clause = " AND " . $ilDB->in('question_id', $original_ids, true, 'integer');
                }

                if ($questionpool == 0)
                {
                        $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE original_id IS NULL $available $constraint_qpls AND owner > %s AND complete = %s $original_clause",
                                array('integer', 'text'),
                                array(0, "1")
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE original_id IS NULL AND obj_fi = %s AND owner > %s AND complete = %s $original_clause",
                                array('integer','integer', 'text'),
                                array($questionpool, 0, "1")
                        );
                }
                $found_ids = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($found_ids, $row['question_id']);
                }
                $nr_of_questions = ($nr_of_questions > count($found_ids)) ? count($found_ids) : $nr_of_questions;
                if ($nr_of_questions == 0) return array();
                $rand_keys = array_rand($found_ids, $nr_of_questions);
                $result = array();
                if (is_array($rand_keys))
                {
                        foreach ($rand_keys as $key)
                        {
                                $result[$found_ids[$key]] = $found_ids[$key];
                        }
                }
                else
                {
                        $result[$found_ids[$rand_keys]] = $found_ids[$rand_keys];
                }
                return $result;
        }

        function getImagePath()
        {
                return CLIENT_WEB_DIR . "/assessment/" . $this->getId() . "/images/";
        }

        function getImagePathWeb()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/assessment/" . $this->getId() . "/images/";
                return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
        }

  function &createQuestionGUI($question_type, $question_id = -1)
        {
                if ((!$question_type) and ($question_id > 0))
                {
                        $question_type = $this->getQuestionType($question_id);
                }
                if (!strlen($question_type)) return null;
                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                assQuestion::_includeClass($question_type, 1);
                $question_type_gui = $question_type . "GUI";
                $question = new $question_type_gui();
                if ($question_id > 0)
                {
                        $question->object->loadFromDb($question_id);
                }
                return $question;
  }

  function &_instanciateQuestion($question_id)
        {
                if (strcmp($question_id, "") != 0)
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        return assQuestion::_instanciateQuestion($question_id);
                }
  }

        function moveQuestions($move_questions, $target_index, $insert_mode)
        {
                $this->questions = array_values($this->questions);
                $array_pos = array_search($target_index, $this->questions);
                if ($insert_mode == 0)
                {
                        $part1 = array_slice($this->questions, 0, $array_pos);
                        $part2 = array_slice($this->questions, $array_pos);
                }
                else if ($insert_mode == 1)
                {
                        $part1 = array_slice($this->questions, 0, $array_pos + 1);
                        $part2 = array_slice($this->questions, $array_pos + 1);
                }
                foreach ($move_questions as $question_id)
                {
                        if (!(array_search($question_id, $part1) === FALSE))
                        {
                                unset($part1[array_search($question_id, $part1)]);
                        }
                        if (!(array_search($question_id, $part2) === FALSE))
                        {
                                unset($part2[array_search($question_id, $part2)]);
                        }
                }
                $part1 = array_values($part1);
                $part2 = array_values($part2);
                $new_array = array_values(array_merge($part1, $move_questions, $part2));
                $this->questions = array();
                $counter = 1;
                foreach ($new_array as $question_id)
                {
                        $this->questions[$counter] = $question_id;
                        $counter++;
                }
                $this->saveQuestionsToDb();
        }


        function startingTimeReached()
        {
                if ($this->getStartingTime())
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getStartingTime(), $matches))
                        {
                                $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = mktime();
                                if ($now < $epoch_time)
                                {
                                        // starting time not reached
                                        return false;
                                }
                        }
                }
                return true;
        }

        function endingTimeReached()
        {
                if ($this->getEndingTime())
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getEndingTime(), $matches))
                        {
                                $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = mktime();
                                if ($now > $epoch_time)
                                {
                                        // ending time reached
                                        return true;
                                }
                        }
                }
                return false;
        }

        function getAvailableQuestions($arrFilter, $completeonly = 0)
        {
                global $ilUser;
                global $ilDB;

                include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                $available_pools = array_keys(ilObjQuestionPool::_getAvailableQuestionpools($use_object_id = TRUE, $equal_points = FALSE, $could_be_offline = FALSE, $showPath = FALSE, $with_questioncount = FALSE));
                $available = "";
                if (count($available_pools))
                {
                        $available = " AND " . $ilDB->in('qpl_questions.obj_fi', $available_pools, false, 'integer');
                }
                else
                {
                        return array();
                }
                if ($completeonly)
                {
                        $available .= " AND qpl_questions.complete = " . $ilDB->quote("1", 'text');
                }

                $where = "";
                if (is_array($arrFilter))
                {
                        if (array_key_exists('title', $arrFilter) && strlen($arrFilter['title']))
                        {
                                $where .= " AND " . $ilDB->like('qpl_questions.title', 'text', "%%" . $arrFilter['title'] . "%%");
                        }
                        if (array_key_exists('description', $arrFilter) && strlen($arrFilter['description']))
                        {
                                $where .= " AND " . $ilDB->like('qpl_questions.description', 'text', "%%" . $arrFilter['description'] . "%%");
                        }
                        if (array_key_exists('author', $arrFilter) && strlen($arrFilter['author']))
                        {
                                $where .= " AND " . $ilDB->like('qpl_questions.author', 'text', "%%" . $arrFilter['author'] . "%%");
                        }
                        if (array_key_exists('type', $arrFilter) && strlen($arrFilter['type']))
                        {
                                $where .= " AND qpl_qst_type.type_tag = " . $ilDB->quote($arrFilter['type'], 'text');
                        }
                        if (array_key_exists('qpl', $arrFilter) && strlen($arrFilter['qpl']))
                        {
                                $where .= " AND " . $ilDB->like('object_data.title', 'text', "%%" . $arrFilter['qpl'] . "%%");
                        }
                }

                $original_ids =& $this->getExistingQuestions();
                $original_clause = " qpl_questions.original_id IS NULL";
                if (count($original_ids))
                {
                        $original_clause = " qpl_questions.original_id IS NULL AND " . $ilDB->in('qpl_questions.question_id',  $original_ids, true, 'integer');
                }

                $query_result = $ilDB->query(
                        "SELECT qpl_questions.*, qpl_questions.tstamp, qpl_qst_type.type_tag, qpl_qst_type.plugin, object_data.title qpl " .
                        "FROM qpl_questions, qpl_qst_type, object_data WHERE $original_clause $available AND " .
                        "object_data.obj_id = qpl_questions.obj_fi AND qpl_questions.tstamp > 0 AND " .
                        "qpl_questions.question_type_fi = qpl_qst_type.question_type_id$where");
                $rows = array();
                $types = $this->getQuestionTypeTranslations();
                if ($query_result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($query_result))
                        {
                                $row['ttype'] = $types[$row['type_tag']];
                                if ($row["plugin"])
                                {
                                        if ($this->isPluginActive($row["type_tag"]))
                                        {
                                                array_push($rows, $row);
                                        }
                                }
                                else
                                {
                                        array_push($rows, $row);
                                }
                        }
                }
                return $rows;
        }

        public function &getQuestionTypeTranslations()
        {
                global $ilDB;
                global $lng;
                global $ilLog;
                global $ilPluginAdmin;
                
                $lng->loadLanguageModule("assessment");
                $result = $ilDB->query("SELECT * FROM qpl_qst_type");
                $types = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if ($row["plugin"] == 0)
                        {
                                $types[$row['type_tag']] = $lng->txt($row["type_tag"]);
                        }
                        else
                        {
                                $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_MODULE, "TestQuestionPool", "qst");
                                foreach ($pl_names as $pl_name)
                                {
                                        $pl = ilPlugin::getPluginObject(IL_COMP_MODULE, "TestQuestionPool", "qst", $pl_name);
                                        if (strcmp($pl->getQuestionType(), $row["type_tag"]) == 0)
                                        {
                                                $types[$row['type_tag']] = $pl->getQuestionTypeTranslation();
                                        }
                                }
                        }
                }
                ksort($types);
                return $types;
        }

        function fromXML(&$assessment)
        {
                unset($_SESSION["import_mob_xhtml"]);

                $this->setDescription($assessment->getComment());
                $this->setTitle($assessment->getTitle());

                foreach ($assessment->objectives as $objectives)
                {
                        foreach ($objectives->materials as $material)
                        {
                                $this->setIntroduction($this->QTIMaterialToString($material));
                        }
                }
                if ($assessment->getPresentationMaterial())
                {
                        $this->setFinalStatement($this->QTIMaterialToString($assessment->getPresentationMaterial()));
                }
                
                foreach ($assessment->assessmentcontrol as $assessmentcontrol)
                {
                        switch ($assessmentcontrol->getSolutionswitch())
                        {
                                case "Yes":
                                        $this->setInstantFeedbackSolution(1);
                                        break;
                                default:
                                        $this->setInstantFeedbackSolution(0);
                                        break;
                        }
                }

                foreach ($assessment->qtimetadata as $metadata)
                {
                        switch ($metadata["label"])
                        {
                                case "test_type":
                                        // for old tests with a test type
                                        $type = $metadata["entry"];
                                        switch ($type)
                                        {
                                                case 1:
                                                        // assessment
                                                        $this->setAnonymity(1);
                                                        break;
                                                case 2:
                                                        // self assessment
                                                        break;
                                                case 4:
                                                        // online exam
                                                        $this->setFixedParticipants(1);
                                                        $this->setListOfQuestionsSettings(7);
                                                        $this->setShowSolutionPrintview(1);
                                                        break;
                                                case 5:
                                                        // varying random test
                                                        break;
                                        }
                                        break;
                                case "sequence_settings":
                                        $this->setSequenceSettings($metadata["entry"]);
                                        break;
                                case "author":
                                        $this->setAuthor($metadata["entry"]);
                                        break;
                                case "nr_of_tries":
                                        $this->setNrOfTries($metadata["entry"]);
                                        break;
                                case "kiosk":
                                        $this->setKiosk($metadata["entry"]);
                                        break;
                                case "showfinalstatement":
                                        $this->setShowFinalStatement($metadata["entry"]);
                                        break;
                                case "redirect_after_exam":
                                        $this->setRedirectAfterExam($metadata["entry"]);
                                        break;
                                case "redirect_only_kiosk_mode":
                                        $this->setRedirectOnlyKioskMode($metadata["entry"]);
                                        break;
                                case "exam_pdf":
                                        $this->setExamPdf($metadata["entry"]);
                                         break;
                                case "showinfo":
                                        $this->setShowInfo($metadata["entry"]);
                                        break;
                                case "forcejs":
                                        $this->setForceJS($metadata["entry"]);
                                        break;
                                case "customstyle":
                                        $this->setCustomStyle($metadata["entry"]);
                                        break;
                                case "hide_previous_results":
                                        if ($metadata["entry"] == 0)
                                        {
                                                $this->setUsePreviousAnswers(1);
                                        }
                                        else
                                        {
                                                $this->setUsePreviousAnswers(0);
                                        }
                                        break;
                                case "use_previous_answers":
                                        $this->setUsePreviousAnswers($metadata["entry"]);
                                        break;
                                case "answer_feedback":
                                        $this->setAnswerFeedback($metadata["entry"]);
                                        break;
                                case "hide_title_points":
                                        $this->setTitleOutput($metadata["entry"]);
                                        break;
                                case "title_output":
                                        $this->setTitleOutput($metadata["entry"]);
                                        break;
                                case "random_test":
                                        $this->setRandomTest($metadata["entry"]);
                                        break;
                                case "random_question_count":
                                        $this->setRandomQuestionCount($metadata["entry"]);
                                        break;
                                case "results_presentation":
                                        $this->setResultsPresentation($metadata["entry"]);
                                        break;
                                case "reset_processing_time":
                                        $this->setResetProcessingTime($metadata["entry"]);
                                        break;
                                case "instant_verification":
                                        $this->setInstantFeedbackSolution($metadata["entry"]);
                                        break;
                                case "answer_feedback_points":
                                        $this->setAnswerFeedbackPoints($metadata["entry"]);
                                        break;
                                case "anonymity":
                                        $this->setAnonymity($metadata["entry"]);
                                        break;
                                case "show_cancel":
                                        $this->setShowCancel($metadata["entry"]);
                                        break;
                                case "autosave":
                                        $this->setAutosave($metadata["entry"]);
                                        break;
                                case "show_marker":
                                        $this->setShowMarker($metadata["entry"]);
                                        break;
                                case "show_serial":
                                        $this->setShowSerial($metadata["entry"]);
                                        break;
                                case "fixed_participants":
                                        $this->setFixedParticipants($metadata["entry"]);
                                        break;
                                case "score_reporting":
                                        $this->setScoreReporting($metadata["entry"]);
                                        break;
                                case "shuffle_questions":
                                        $this->setShuffleQuestions($metadata["entry"]);
                                        break;
                                case "count_system":
                                        $this->setCountSystem($metadata["entry"]);
                                        break;
                                case "mc_scoring":
                                        $this->setMCScoring($metadata["entry"]);
                                        break;
                                case "mailnotification":
                                        $this->setMailNotification($metadata["entry"]);
                                        break;
                                case "mailnottype":
                                        $this->setMailNotificationType($metadata["entry"]);
                                        break;
                                case "exportsettings":
                                        $this->setExportSettings($metadata['exportsettings']);
                                        break;
                                case "score_cutting":
                                        $this->setScoreCutting($metadata["entry"]);
                                        break;
                                case "password":
                                        $this->setPassword($metadata["entry"]);
                                        break;
                                case "allowedUsers":
                                        $this->setAllowedUsers($metadata["entry"]);
                                        break;
                                case "allowedUsersTimeGap":
                                        $this->setAllowedUsersTimeGap($metadata["entry"]);
                                        break;
                                case "pass_scoring":
                                        $this->setPassScoring($metadata["entry"]);
                                        break;
                                case "show_summary":
                                        $this->setListOfQuestionsSettings($metadata["entry"]);
                                        break;
                                case "reporting_date":
                                        $iso8601period = $metadata["entry"];
                                        if (preg_match("/P(\d+)Y(\d+)M(\d+)DT(\d+)H(\d+)M(\d+)S/", $iso8601period, $matches))
                                        {
                                                $this->setReportingDate(sprintf("%02d%02d%02d%02d%02d%02d", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                                        }
                                        break;
                                case "processing_time":
                                        $this->setProcessingTime($metadata['entry']);
                                        break;
                                case "enable_processing_time":
                                        $this->setEnableProcessingTime($metadata['entry']);
                                        break;
                                case "starting_time":
                                        $iso8601period = $metadata["entry"];
                                        if (preg_match("/P(\d+)Y(\d+)M(\d+)DT(\d+)H(\d+)M(\d+)S/", $iso8601period, $matches))
                                        {
                                                $this->setStartingTime(sprintf("%02d%02d%02d%02d%02d%02d", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                                        }
                                        break;
                                case "ending_time":
                                        $iso8601period = $metadata["entry"];
                                        if (preg_match("/P(\d+)Y(\d+)M(\d+)DT(\d+)H(\d+)M(\d+)S/", $iso8601period, $matches))
                                        {
                                                $this->setEndingTime(sprintf("%02d%02d%02d%02d%02d%02d", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                                        }
                                        break;
                        }
                        if (preg_match("/mark_step_\d+/", $metadata["label"]))
                        {
                                $xmlmark = $metadata["entry"];
                                preg_match("/<short>(.*?)<\/short>/", $xmlmark, $matches);
                                $mark_short = $matches[1];
                                preg_match("/<official>(.*?)<\/official>/", $xmlmark, $matches);
                                $mark_official = $matches[1];
                                preg_match("/<percentage>(.*?)<\/percentage>/", $xmlmark, $matches);
                                $mark_percentage = $matches[1];
                                preg_match("/<passed>(.*?)<\/passed>/", $xmlmark, $matches);
                                $mark_passed = $matches[1];
                                $this->mark_schema->addMarkStep($mark_short, $mark_official, $mark_percentage, $mark_passed);
                        }
                }
                // handle the import of media objects in XHTML code
                if (is_array($_SESSION["import_mob_xhtml"]))
                {
                        include_once "./Services/MediaObjects/classes/class.ilObjMediaObject.php";
                        include_once "./Services/RTE/classes/class.ilRTE.php";
                        include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                        foreach ($_SESSION["import_mob_xhtml"] as $mob)
                        {
                                $importfile = $this->getImportDirectory() . "/" . $_SESSION["tst_import_subdir"] . "/" . $mob["uri"];
                                if (file_exists($importfile))
                                {
                                        $media_object =& ilObjMediaObject::_saveTempFileAsMediaObject(basename($importfile), $importfile, FALSE);
                                        ilObjMediaObject::_saveUsage($media_object->getId(), "tst:html", $this->getId());
                                        $this->setIntroduction(ilRTE::_replaceMediaObjectImageSrc(str_replace("src=\"" . $mob["mob"] . "\"", "src=\"" . "il_" . IL_INST_ID . "_mob_" . $media_object->getId() . "\"", $this->getIntroduction()), 1));
                                        $this->setFinalStatement(ilRTE::_replaceMediaObjectImageSrc(str_replace("src=\"" . $mob["mob"] . "\"", "src=\"" . "il_" . IL_INST_ID . "_mob_" . $media_object->getId() . "\"", $this->getFinalStatement()), 1));
                                }
                                else
                                {
                                        global $ilLog;
                                        $ilLog->write("Error: Could not open XHTML mob file for test introduction during test import. File $importfile does not exist!");
                                }
                        }
                        $this->saveToDb();
                }
        }

        function exportPagesXML(&$a_xml_writer, $a_inst, $a_target_dir, &$expLog)
        {
                global $ilBench;

                $this->mob_ids = array();
                $this->file_ids = array();

                $attrs = array();
                $attrs["Type"] = "Test";
                $a_xml_writer->xmlStartTag("ContentObject", $attrs);

                // MetaData
                $this->exportXMLMetaData($a_xml_writer);

                // PageObjects
                $expLog->write(date("[y-m-d H:i:s] ")."Start Export Page Objects");
                $ilBench->start("ContentObjectExport", "exportPageObjects");
                $this->exportXMLPageObjects($a_xml_writer, $a_inst, $expLog);
                $ilBench->stop("ContentObjectExport", "exportPageObjects");
                $expLog->write(date("[y-m-d H:i:s] ")."Finished Export Page Objects");

                // MediaObjects
                $expLog->write(date("[y-m-d H:i:s] ")."Start Export Media Objects");
                $ilBench->start("ContentObjectExport", "exportMediaObjects");
                $this->exportXMLMediaObjects($a_xml_writer, $a_inst, $a_target_dir, $expLog);
                $ilBench->stop("ContentObjectExport", "exportMediaObjects");
                $expLog->write(date("[y-m-d H:i:s] ")."Finished Export Media Objects");

                // FileItems
                $expLog->write(date("[y-m-d H:i:s] ")."Start Export File Items");
                $ilBench->start("ContentObjectExport", "exportFileItems");
                $this->exportFileItems($a_target_dir, $expLog);
                $ilBench->stop("ContentObjectExport", "exportFileItems");
                $expLog->write(date("[y-m-d H:i:s] ")."Finished Export File Items");

                $a_xml_writer->xmlEndTag("ContentObject");
        }

        function exportXMLMetaData(&$a_xml_writer)
        {
                include_once "./Services/MetaData/classes/class.ilMD2XML.php";
                $md2xml = new ilMD2XML($this->getId(), 0, $this->getType());
                $md2xml->setExportMode(true);
                $md2xml->startExport();
                $a_xml_writer->appendXML($md2xml->getXML());
        }

        function modifyExportIdentifier($a_tag, $a_param, $a_value)
        {
                if ($a_tag == "Identifier" && $a_param == "Entry")
                {
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        $a_value = ilUtil::insertInstIntoID($a_value);
                }

                return $a_value;
        }


        function exportXMLPageObjects(&$a_xml_writer, $a_inst, &$expLog)
        {
                global $ilBench;

                include_once "./Modules/LearningModule/classes/class.ilLMPageObject.php";

                foreach ($this->questions as $question_id)
                {
                        $ilBench->start("ContentObjectExport", "exportPageObject");
                        $expLog->write(date("[y-m-d H:i:s] ")."Page Object ".$question_id);

                        $attrs = array();
                        $a_xml_writer->xmlStartTag("PageObject", $attrs);


                        // export xml to writer object
                        $ilBench->start("ContentObjectExport", "exportPageObject_XML");
                        $page_object = new ilPageObject("qpl", $question_id);
                        $page_object->buildDom();
                        $page_object->insertInstIntoIDs($a_inst);
                        $mob_ids = $page_object->collectMediaObjects(false);
                        $file_ids = $page_object->collectFileItems();
                        $xml = $page_object->getXMLFromDom(false, false, false, "", true);
                        $xml = str_replace("&","&amp;", $xml);
                        $a_xml_writer->appendXML($xml);
                        $page_object->freeDom();
                        unset ($page_object);

                        $ilBench->stop("ContentObjectExport", "exportPageObject_XML");

                        // collect media objects
                        $ilBench->start("ContentObjectExport", "exportPageObject_CollectMedia");
                        //$mob_ids = $page_obj->getMediaObjectIDs();
                        foreach($mob_ids as $mob_id)
                        {
                                $this->mob_ids[$mob_id] = $mob_id;
                        }
                        $ilBench->stop("ContentObjectExport", "exportPageObject_CollectMedia");

                        // collect all file items
                        $ilBench->start("ContentObjectExport", "exportPageObject_CollectFileItems");
                        //$file_ids = $page_obj->getFileItemIds();
                        foreach($file_ids as $file_id)
                        {
                                $this->file_ids[$file_id] = $file_id;
                        }
                        $ilBench->stop("ContentObjectExport", "exportPageObject_CollectFileItems");

                        $a_xml_writer->xmlEndTag("PageObject");
                        //unset($page_obj);

                        $ilBench->stop("ContentObjectExport", "exportPageObject");


                }
        }

        function exportXMLMediaObjects(&$a_xml_writer, $a_inst, $a_target_dir, &$expLog)
        {
                include_once "./Services/MediaObjects/classes/class.ilObjMediaObject.php";

                foreach ($this->mob_ids as $mob_id)
                {
                        $expLog->write(date("[y-m-d H:i:s] ")."Media Object ".$mob_id);
                        if (ilObjMediaObject::_exists($mob_id))
                        {
                                $media_obj = new ilObjMediaObject($mob_id);
                                $media_obj->exportXML($a_xml_writer, $a_inst);
                                $media_obj->exportFiles($a_target_dir);
                                unset($media_obj);
                        }
                }
        }

        function exportFileItems($a_target_dir, &$expLog)
        {
                include_once "./Modules/File/classes/class.ilObjFile.php";

                foreach ($this->file_ids as $file_id)
                {
                        $expLog->write(date("[y-m-d H:i:s] ")."File Item ".$file_id);
                        $file_obj = new ilObjFile($file_id, false);
                        $file_obj->export($a_target_dir);
                        unset($file_obj);
                }
        }

        function getImportMapping()
        {
                if (!is_array($this->import_mapping))
                {
                        return array();
                }
                else
                {
                        return $this->import_mapping;
                }
        }

        function getECTSGrade($passed_array, $reached_points, $max_points)
        {
                return ilObjTest::_getECTSGrade($passed_array, $reached_points, $max_points, $this->ects_grades["A"], $this->ects_grades["B"], $this->ects_grades["C"], $this->ects_grades["D"], $this->ects_grades["E"], $this->ects_fx);
        }

        function _getECTSGrade($points_passed, $reached_points, $max_points, $a, $b, $c, $d, $e, $fx)
        {
                include_once "./classes/class.ilStatistics.php";
                // calculate the median
                $passed_statistics = new ilStatistics();
                $passed_statistics->setData($points_passed);
                $ects_percentiles = array
                (
                        "A" => $passed_statistics->quantile($a),
                        "B" => $passed_statistics->quantile($b),
                        "C" => $passed_statistics->quantile($c),
                        "D" => $passed_statistics->quantile($d),
                        "E" => $passed_statistics->quantile($e)
                );
                if (count($points_passed) && ($reached_points >= $ects_percentiles["A"]))
                {
                        return "A";
                }
                else if (count($points_passed) && ($reached_points >= $ects_percentiles["B"]))
                {
                        return "B";
                }
                else if (count($points_passed) && ($reached_points >= $ects_percentiles["C"]))
                {
                        return "C";
                }
                else if (count($points_passed) && ($reached_points >= $ects_percentiles["D"]))
                {
                        return "D";
                }
                else if (count($points_passed) && ($reached_points >= $ects_percentiles["E"]))
                {
                        return "E";
                }
                else if (strcmp($fx, "") != 0)
                {
                        if ($max_points > 0)
                        {
                                $percentage = ($reached_points / $max_points) * 100.0;
                                if ($percentage < 0) $percentage = 0.0;
                        }
                        else
                        {
                                $percentage = 0.0;
                        }
                        if ($percentage >= $fx)
                        {
                                return "FX";
                        }
                        else
                        {
                                return "F";
                        }
                }
                else
                {
                        return "F";
                }
        }

        function checkMarks()
        {
                return $this->mark_schema->checkMarks();
        }
        
        function getMarkSchema()
        {
                return $this->mark_schema;
        }

  function setAuthor($author = "")
        {
    $this->author = $author;
  }

        function saveAuthorToMetadata($a_author = "")
        {
                $md =& new ilMD($this->getId(), 0, $this->getType());
                $md_life =& $md->getLifecycle();
                if (!$md_life)
                {
                        if (strlen($a_author) == 0)
                        {
                                global $ilUser;
                                $a_author = $ilUser->getFullname();
                        }

                        $md_life =& $md->addLifecycle();
                        $md_life->save();
                        $con =& $md_life->addContribute();
                        $con->setRole("Author");
                        $con->save();
                        $ent =& $con->addEntity();
                        $ent->setEntity($a_author);
                        $ent->save();
                }
        }

        function createMetaData()
        {
                parent::createMetaData();
                $this->saveAuthorToMetadata();
        }

  function getAuthor()
        {
                $author = array();
                include_once "./Services/MetaData/classes/class.ilMD.php";
                $md =& new ilMD($this->getId(), 0, $this->getType());
                $md_life =& $md->getLifecycle();
                if ($md_life)
                {
                        $ids =& $md_life->getContributeIds();
                        foreach ($ids as $id)
                        {
                                $md_cont =& $md_life->getContribute($id);
                                if (strcmp($md_cont->getRole(), "Author") == 0)
                                {
                                        $entids =& $md_cont->getEntityIds();
                                        foreach ($entids as $entid)
                                        {
                                                $md_ent =& $md_cont->getEntity($entid);
                                                array_push($author, $md_ent->getEntity());
                                        }
                                }
                        }
                }
                return join($author, ",");
  }

  function _lookupAuthor($obj_id)
        {
                $author = array();
                include_once "./Services/MetaData/classes/class.ilMD.php";
                $md =& new ilMD($obj_id, 0, "tst");
                $md_life =& $md->getLifecycle();
                if ($md_life)
                {
                        $ids =& $md_life->getContributeIds();
                        foreach ($ids as $id)
                        {
                                $md_cont =& $md_life->getContribute($id);
                                if (strcmp($md_cont->getRole(), "Author") == 0)
                                {
                                        $entids =& $md_cont->getEntityIds();
                                        foreach ($entids as $entid)
                                        {
                                                $md_ent =& $md_cont->getEntity($entid);
                                                array_push($author, $md_ent->getEntity());
                                        }
                                }
                        }
                }
                return join($author, ",");
  }

        function &_getAvailableTests($use_object_id = FALSE)
        {
                global $ilUser;
                global $ilDB;

                $result_array = array();
                $tests = ilUtil::_getObjectsByOperations("tst","write", $ilUser->getId(), -1);
                if (count($tests))
                {
                        $titles = ilObject::_prepareCloneSelection($tests, "tst");
                        foreach ($tests as $ref_id)
                        {
                                if ($use_object_id)
                                {
                                        $obj_id = ilObject::_lookupObjId($ref_id);
                                        $result_array[$obj_id] = $titles[$ref_id];
                                }
                                else
                                {
                                        $result_array[$ref_id] = $titles[$ref_id];
                                }
                        }
                }
                return $result_array;
        }

        function cloneRandomQuestions($new_id)
        {
                global $ilDB;

                if ($new_id > 0)
                {
                        $result = $ilDB->queryF("SELECT * FROM tst_test_random WHERE test_fi = %s ORDER BY sequence, test_random_id",
                                array('integer'),
                                array($this->getTestId())
                        );
                        if ($result->numRows())
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        $next_id = $ilDB->nextId('tst_test_random');
                                        $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_random (test_random_id, test_fi, questionpool_fi, num_of_q, tstamp, sequence) VALUES (%s, %s, %s, %s, %s, %s)",
                                                array('integer', 'integer', 'integer', 'integer', 'integer', 'integer'),
                                                array($next_id, $new_id, $row["questionpool_fi"], $row["num_of_q"], time(), $row['sequence'])
                                        );
                                }
                        }
                }
        }
        
        
        public function cloneObject($a_target_id,$a_copy_id = 0)
        {
                global $ilDB,$ilLog;
                
                $this->loadFromDb();
                
                // Copy settings
                $newObj = parent::cloneObject($a_target_id,$a_copy_id);
                $this->cloneMetaData($newObj);
                $newObj->setAnonymity($this->getAnonymity());
                $newObj->setAnswerFeedback($this->getAnswerFeedback());
                $newObj->setAnswerFeedbackPoints($this->getAnswerFeedbackPoints());
                $newObj->setAuthor($this->getAuthor());
                $newObj->setCountSystem($this->getCountSystem());
                $newObj->setECTSFX($this->getECTSFX());
                $newObj->setECTSGrades($this->getECTSGrades());
                $newObj->setECTSOutput($this->getECTSOutput());
                $newObj->setEnableProcessingTime($this->getEnableProcessingTime());
                $newObj->setEndingTime($this->getEndingTime());
                $newObj->setFixedParticipants($this->getFixedParticipants());
                $newObj->setInstantFeedbackSolution($this->getInstantFeedbackSolution());
                $newObj->setIntroduction($this->getIntroduction());
                $newObj->setFinalStatement($this->getFinalStatement());
                /* Change Sn */
                $newObj->setRedirectAfterExam($this->getRedirectAfterExam());
                $newObj->setRedirectOnlyKioskMode($this->getRedirectOnlyKioskMode());
                $newObj->setExamPdf($this->getExamPdf());
                /* Change Sn End */
                $newObj->setShowInfo($this->getShowInfo());
                $newObj->setForceJS($this->getForceJS());
                $newObj->setCustomStyle($this->getCustomStyle());
                $newObj->setShowFinalStatement($this->getShowFinalStatement());
                $newObj->setListOfQuestionsSettings($this->getListOfQuestionsSettings());
                $newObj->setKiosk($this->getKiosk());
                $newObj->setMCScoring($this->getMCScoring());
                $newObj->setMailNotification($this->getMailNotification());
                $newObj->setMailNotificationType($this->getMailNotificationType());
                $newObj->setNrOfTries($this->getNrOfTries());
                $newObj->setPassScoring($this->getPassScoring());
                $newObj->setPassword($this->getPassword());
                $newObj->setProcessingTime($this->getProcessingTime());
                $newObj->setRandomQuestionCount($this->getRandomQuestionCount());
                $newObj->setRandomTest($this->isRandomTest());
                $newObj->setReportingDate($this->getReportingDate());
                $newObj->setResetProcessingTime($this->getResetProcessingTime());
                $newObj->setResultsPresentation($this->getResultsPresentation());
                $newObj->setScoreCutting($this->getScoreCutting());
                $newObj->setScoreReporting($this->getScoreReporting());
                $newObj->setSequenceSettings($this->getSequenceSettings());
                $newObj->setShowCancel($this->getShowCancel());
                $newObj->setAutosave($this->getAutosave());
                $newObj->setShowMarker($this->getShowMarker());
                $newObj->setShuffleQuestions($this->getShuffleQuestions());
                $newObj->setStartingTime($this->getStartingTime());
                $newObj->setTitleOutput($this->getTitleOutput());
                $newObj->setUsePreviousAnswers($this->getUsePreviousAnswers());
                $newObj->setCertificateVisibility($this->getCertificateVisibility());
                $newObj->mark_schema = clone $this->mark_schema;
                $newObj->saveToDb();
                
                // clone certificate
                include_once "./Services/Certificate/classes/class.ilCertificate.php";
                include_once "./Modules/Test/classes/class.ilTestCertificateAdapter.php";
                $cert = new ilCertificate(new ilTestCertificateAdapter($this));
                $newcert = new ilCertificate(new ilTestCertificateAdapter($newObj));
                $cert->cloneCertificate($newcert);
                
                if ($this->isRandomTest())
                {
                        $newObj->saveRandomQuestionCount($newObj->getRandomQuestionCount());
                        $this->cloneRandomQuestions($newObj->getTestId());
                }
                else
                {
                        include_once("./Services/CopyWizard/classes/class.ilCopyWizardOptions.php");
                        $cwo = ilCopyWizardOptions::_getInstance($a_copy_id);
                        
                        // clone the questions
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        foreach ($this->questions as $key => $question_id)
                        {
                                $question = ilObjTest::_instanciateQuestion($question_id);
                                $newObj->questions[$key] = $question->duplicate();
                                $original_id = assQuestion::_getOriginalId($question_id);
                                $question = ilObjTest::_instanciateQuestion($newObj->questions[$key]);
                                $question->saveToDb($original_id);
                                
                                // Save the mapping of old question id <-> new question id
                                // This will be used in class.ilObjCourse::cloneDependencies to copy learning objectives
                                $cwo->appendMapping($this->getRefId().'_'.$question_id,$newObj->getRefId().'_'.$newObj->questions[$key]);
                                $ilLog->write(__METHOD__.': Added mapping '.$this->getRefId().'_'.$question_id.' <-> ' .
                                                $newObj->getRefId().'_'.$newObj->questions[$key]);
                        }
                }
                $newObj->saveToDb();
                return $newObj;
        }

        function getQuestionCount()
        {
                $num = 0;

                if ($this->isRandomTest())
                {
                        if ($this->getRandomQuestionCount())
                        {
                                $num = $this->getRandomQuestionCount();
                                $qpls =& $this->getRandomQuestionpools();
                                $maxcount = 0;
                                foreach ($qpls as $data)
                                {
                                        $maxcount += $data["contains"];
                                }
                                if ($num > $maxcount) $num = $maxcount;
                        }
                                else
                        {
                                $qpls =& $this->getRandomQuestionpools();
                                foreach ($qpls as $data)
                                {
                                        $add = ($data["count"] <= $data["contains"]) ? $data["count"] : $data["contains"];
                                        $num += $add;
                                }
                        }
                }
                        else
                {
                        $num = count($this->questions);
                }
                return $num;
        }

        function _getQuestionCount($test_id)
        {
                global $ilDB;

                $num = 0;

                $result = $ilDB->queryF("SELECT * FROM tst_tests WHERE test_id = %s",
                        array('integer'),
                        array($test_id)
                );
                if (!$result->numRows())
                {
                        return 0;
                }
                $test = $ilDB->fetchAssoc($result);

                if ($test["random_test"] == 1)
                {
                        $qpls = array();
                        $counter = 0;
                        $result = $ilDB->queryF("SELECT * FROM tst_test_random WHERE test_fi = %s ORDER BY sequence, test_random_id",
                                array('integer'),
                                array($test_id)
                        );
                        if ($result->numRows())
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        $countresult = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE obj_fi =  %s AND qpl_questions.tstamp > 0 AND original_id IS NULL",
                                                array('integer'),
                                                $row["questionpool_fi"]
                                        );
                                        $contains = $countresult->numRows();
                                        $qpls[$counter] = array(
                                                "index" => $counter,
                                                "count" => $row["num_of_q"],
                                                "qpl"   => $row["questionpool_fi"],
                                                "contains" => $contains
                                        );
                                        $counter++;
                                }
                        }
                        if ($test["random_question_count"] > 0)
                        {
                                $num = $test["random_question_count"];
                                $maxcount = 0;
                                foreach ($qpls as $data)
                                {
                                        $maxcount += $data["contains"];
                                }
                                if ($num > $maxcount) $num = $maxcount;
                        }
                                else
                        {
                                $num = 0;
                                foreach ($qpls as $data)
                                {
                                        $add = ($data["count"] <= $data["contains"]) ? $data["count"] : $data["contains"];
                                        $num += $add;
                                }
                        }
                }
                else
                {
                        $result = $ilDB->queryF("SELECT test_question_id FROM tst_test_question WHERE test_fi = %s",
                                array('integer'),
                                array($test_id)
                        );
                        $num = $result->numRows();
                }
                return $num;
        }

        function removeNonRandomTestData()
        {
                global $ilDB;

                // delete eventually set questions of a previous non-random test
                $this->removeAllTestEditings();
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_question WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $this->questions = array();
                $this->saveCompleteStatus();
        }

        function removeRandomTestData()
        {
                global $ilDB;
                // delete eventually set random question pools of a previous random test
                $this->removeAllTestEditings();
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_random WHERE test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                $this->questions = array();
                $this->saveCompleteStatus();
        }

        function logAction($logtext = "", $question_id = "")
        {
                global $ilUser;

                $original_id = "";
                if (strcmp($question_id, "") != 0)
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $original_id = assQuestion::_getOriginalId($question_id);
                }
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                ilObjAssessmentFolder::_addLog($ilUser->getId(), $this->getId(), $logtext, $question_id, $original_id, TRUE, $this->getRefId());
        }

        function _getObjectIDFromTestID($test_id)
        {
                global $ilDB;
                $object_id = FALSE;
                $result = $ilDB->queryF("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
                        array('integer'),
                        array($test_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $object_id = $row["obj_fi"];
                }
                return $object_id;
        }

        function _getObjectIDFromActiveID($active_id)
        {
                global $ilDB;
                $object_id = FALSE;
                $result = $ilDB->queryF("SELECT tst_tests.obj_fi FROM tst_tests, tst_active WHERE tst_tests.test_id = tst_active.test_fi AND tst_active.active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $object_id = $row["obj_fi"];
                }
                return $object_id;
        }

        function _getTestIDFromObjectID($object_id)
        {
                global $ilDB;
                $test_id = FALSE;
                $result = $ilDB->queryF("SELECT test_id FROM tst_tests WHERE obj_fi = %s",
                        array('integer'),
                        array($object_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        $test_id = $row["test_id"];
                }
                return $test_id;
        }

        function getTextAnswer($active_id, $question_id, $pass = NULL)
        {
                global $ilDB;

                $res = "";
                if (($active_id) && ($question_id))
                {
                        if (is_null($pass))
                        {
                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                $pass = assQuestion::_getSolutionMaxPass($question_id, $active_id);
                        }
                        $result = $ilDB->queryF("SELECT value1 FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                                array('integer', 'integer', 'integer'),
                                array($active_id, $question_id, $pass)
                        );
                        if ($result->numRows() == 1)
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $res = $row["value1"];
                        }
                }
                return $res;
        }

        function getQuestiontext($question_id)
        {
                global $ilDB;

                $res = "";
                if ($question_id)
                {
                        $result = $ilDB->queryF("SELECT question_text FROM qpl_questions WHERE question_id = %s",
                                array('integer'),
                                array($question_id)
                        );
                        if ($result->numRows() == 1)
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $res = $row["question_text"];
                        }
                }
                return $res;
        }

        function &getInvitedUsers($user_id="", $order="login, lastname, firstname")
        {
                global $ilDB;

                $result_array = array();

                if ($this->getAnonymity())
                {
                        if (is_numeric($user_id))
                        {
                                $result = $ilDB->queryF("SELECT tst_active.active_id, tst_active.tries, usr_id, %s login, %s lastname, %s firstname, tst_invited_user.clientip, " .
                                        "tst_active.submitted test_finished, matriculation FROM usr_data, tst_invited_user " .
                                        "LEFT JOIN tst_active ON tst_active.user_fi = tst_invited_user.user_fi AND tst_active.test_fi = tst_invited_user.test_fi " .
                                        "WHERE tst_invited_user.test_fi = %s and tst_invited_user.user_fi=usr_data.usr_id AND usr_data.usr_id=%s " .
                                        "ORDER BY $order",
                                        array('text', 'text', 'text', 'integer', 'integer'),
                                        array("", $this->lng->txt("unknown"), "", $this->getTestId(), $user_id)
                                );
                        }
                        else
                        {
                                $result = $ilDB->queryF("SELECT tst_active.active_id, usr_id, %s login, %s lastname, %s firstname, tst_invited_user.clientip, " .
                                        "tst_active.submitted test_finished, matriculation FROM usr_data, tst_invited_user " .
                                        "LEFT JOIN tst_active ON tst_active.user_fi = tst_invited_user.user_fi AND tst_active.test_fi = tst_invited_user.test_fi " .
                                        "WHERE tst_invited_user.test_fi = %s and tst_invited_user.user_fi=usr_data.usr_id " .
                                        "ORDER BY $order",
                                        array('text', 'text', 'text', 'integer'),
                                        array("", $this->lng->txt("unknown"), "", $this->getTestId())
                                );
                        }
                }
                else
                {
                        if (is_numeric($user_id))
                        {
                                $result = $ilDB->queryF("SELECT tst_active.active_id, tst_active.tries, usr_id, login, lastname, firstname, tst_invited_user.clientip, " .
                                        "tst_active.submitted test_finished, matriculation FROM usr_data, tst_invited_user " .
                                        "LEFT JOIN tst_active ON tst_active.user_fi = tst_invited_user.user_fi " .
                                        "WHERE tst_invited_user.test_fi = %s and tst_invited_user.user_fi=usr_data.usr_id AND usr_data.usr_id=%s " .
                                        "ORDER BY $order",
                                        array('integer', 'integer'),
                                        array($this->getTestId(), $user_id)
                                );
                        }
                        else
                        {
                                $result = $ilDB->queryF("SELECT tst_active.active_id, tst_active.tries, usr_id, login, lastname, firstname, tst_invited_user.clientip, " .
                                        "tst_active.submitted test_finished, matriculation FROM usr_data, tst_invited_user " .
                                        "LEFT JOIN tst_active ON tst_active.user_fi = tst_invited_user.user_fi " .
                                        "WHERE tst_invited_user.test_fi = %s and tst_invited_user.user_fi=usr_data.usr_id " .
                                        "ORDER BY $order",
                                        array('integer'),
                                        array($this->getTestId())
                                );
                        }
                }
                $result_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $result_array[$row['usr_id']]= $row;
                }
                return $result_array;
        }

        function &getTestParticipants()
        {
                global $ilDB;

                if ($this->getAnonymity())
                {
                        $result = $ilDB->queryF("SELECT tst_active.active_id, tst_active.tries, tst_active.user_fi usr_id, %s login, %s lastname, %s firstname, tst_active.submitted test_finished, usr_data.matriculation, usr_data.active ".
                                "FROM tst_active LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id WHERE tst_active.test_fi = %s ORDER BY usr_data.lastname " . strtoupper($name_sort_order),
                                array('text', 'text', 'text', 'integer'),
                                array("", $this->lng->txt("unknown"), "", $this->getTestId())
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT tst_active.active_id, tst_active.tries, tst_active.user_fi usr_id, usr_data.login, usr_data.lastname, usr_data.firstname, tst_active.submitted test_finished, usr_data.matriculation, usr_data.active ".
                                "FROM tst_active LEFT JOIN usr_data ON tst_active.user_fi = usr_data.usr_id WHERE tst_active.test_fi = %s ORDER BY usr_data.lastname " . strtoupper($name_sort_order),
                                array('integer'),
                                array($this->getTestId())
                        );
                }
                $data = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $data[$row['active_id']] = $row;
                }
                foreach ($data as $index => $participant)
                {
                        if (strlen(trim($participant["firstname"].$participant["lastname"])) == 0)
                        {
                                $data[$index]["lastname"] = $this->lng->txt("deleted_user");
                        }
                }
                return $data;
        }
        
        public function getTestParticipantsForManualScoring($filter = NULL)
        {
                global $ilDB;
                
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                $scoring = ilObjAssessmentFolder::_getManualScoring();
                if (count($scoring) == 0) return array();

                $participants =& $this->getTestParticipants();
                $filtered_participants = array();
                foreach ($participants as $active_id => $participant)
                {
                        $result = $ilDB->queryF("SELECT tst_test_result.manual FROM tst_test_result,qpl_questions WHERE tst_test_result.question_fi = qpl_questions.question_id AND " . $ilDB->in('qpl_questions.question_type_fi', $scoring, false, 'integer') . " AND tst_test_result.active_fi = %s", 
                                array("integer"),
                                array($active_id)
                        );
                        $count = $result->numRows();
                        if ($count > 0)
                        {
                                switch ($filter)
                                {
                                        case 1: // only active users
                                                if ($participant->active) $filtered_participants[$active_id] = $participant;
                                                break;
                                        case 2: // only inactive users
                                                if (!$participant->active) $filtered_participants[$active_id] = $participant;
                                                break;
                                        case 3: // all users
                                                $filtered_participants[$active_id] = $participant;
                                                break;
                                        case 4:
                                                // already scored participants
                                                //$found = 0;
                                                //while ($row = $ilDB->fetchAssoc($result))
                                                //{
                                                //      if ($row["manual"]) $found++;
                                                //}
                                                //if ($found == $count) 
                                                //{
                                                        //$filtered_participants[$active_id] = $participant;
                                                //}
                                                //else
                                                //{
                                                        $assessmentSetting = new ilSetting("assessment");
                                                        $manscoring_done = $assessmentSetting->get("manscoring_done_" . $active_id);
                                                        if ($manscoring_done) $filtered_participants[$active_id] = $participant;
                                                //}
                                                break;
                                        case 5:
                                                // unscored participants
                                                //$found = 0;
                                                //while ($row = $ilDB->fetchAssoc($result))
                                                //{
                                                //      if ($row["manual"]) $found++;
                                                //}
                                                //if ($found == 0) 
                                                //{
                                                        $assessmentSetting = new ilSetting("assessment");
                                                        $manscoring_done = $assessmentSetting->get("manscoring_done_" . $active_id);
                                                        if (!$manscoring_done) $filtered_participants[$active_id] = $participant;
                                                //}
                                                break;
                                        case 6:
                                                // partially scored participants
                                                $found = 0;
                                                while ($row = $ilDB->fetchAssoc($result))
                                                {
                                                        if ($row["manual"]) $found++;
                                                }
                                                if (($found > 0) && ($found < $count)) $filtered_participants[$active_id] = $participant;
                                                break;
                                        default:
                                                $filtered_participants[$active_id] = $participant;
                                                break;
                                }
                        }
                }
                return $filtered_participants;
        }

        function &getUserData($ids)
        {
                global $ilDB;
                global $lng;
                
                if (!is_array($ids) || count($ids) ==0) return array();

                if ($this->getAnonymity())
                {
                        $result = $ilDB->queryF("SELECT usr_id, %s login, %s lastname, %s firstname, client_ip clientip FROM usr_data WHERE " . $ilDB->in('usr_id', $ids, false, 'integer') . " ORDER BY login",
                                array('text', 'text', 'text'),
                                array("", $lng->txt("unknown"), "")
                        );
                }
                else
                {
                        $result = $ilDB->query("SELECT usr_id, login, lastname, firstname, client_ip clientip FROM usr_data WHERE " . $ilDB->in('usr_id', $ids, false, 'integer') . " ORDER BY login");
                }

                $result_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $result_array[$row["usr_id"]]= $row;
                }
                return $result_array;
        }

        function &getGroupData($ids)
        {
                if (!is_array($ids) || count($ids) ==0) return array();
                $result = array();
                foreach ($ids as $ref_id)
                {
                        $obj_id = ilObject::_lookupObjId($ref_id);
                        $result[$ref_id] = array("ref_id" => $ref_id, "title" => ilObject::_lookupTitle($obj_id), "description" => ilObject::_lookupDescription($obj_id));
                }
                return $result;
        }

        function &getRoleData($ids)
        {
                if (!is_array($ids) || count($ids) ==0) return array();
                $result = array();
                foreach ($ids as $obj_id)
                {
                        $result[$obj_id] = array("obj_id" => $obj_id, "title" => ilObject::_lookupTitle($obj_id), "description" => ilObject::_lookupDescription($obj_id));
                }
                return $result;
        }


        function inviteGroup($group_id)
        {
                include_once "./Modules/Group/classes/class.ilObjGroup.php";
                $group = new ilObjGroup($group_id);
                $members = $group->getGroupMemberIds();
                include_once './Services/User/classes/class.ilObjUser.php';
                foreach ($members as $user_id)
                {
                        $this->inviteUser($user_id, ilObjUser::_lookupClientIP($user_id));
                }
        }

        function inviteRole($role_id)
        {
                global $rbacreview;
                $members =  $rbacreview->assignedUsers($role_id,"usr_id");
                include_once './Services/User/classes/class.ilObjUser.php';
                foreach ($members as $user_id)
                {
                        $this->inviteUser($user_id, ilObjUser::_lookupClientIP($user_id));
                }
        }



        function disinviteUser($user_id)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_invited_user WHERE test_fi = %s AND user_fi = %s",
                        array('integer', 'integer'),
                        array($this->getTestId(), $user_id)
                );
        }

        function inviteUser($user_id, $client_ip="")
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_invited_user WHERE test_fi = %s AND user_fi = %s",
                        array('integer', 'integer'),
                        array($this->getTestId(), $user_id)
                );
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_invited_user (test_fi, user_fi, clientip, tstamp) VALUES (%s, %s, %s, %s)",
                        array('integer', 'integer', 'text', 'integer'),
                        array($this->getTestId(), $user_id, (strlen($client_ip)) ? $client_ip : NULL, time())
                );
        }


        function setClientIP($user_id, $client_ip)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("UPDATE tst_invited_user SET clientip = %s, tstamp = %s WHERE test_fi=%s and user_fi=%s",
                        array('text', 'integer', 'integer', 'integer'),
                        array((strlen($client_ip)) ? $client_ip : NULL, time(), $this->getTestId(), $user_id)
                );
        }

        function _getSolvedQuestions($active_id, $question_fi = null)
        {
                global $ilDB;
                if (is_numeric($question_fi))
                {
                        $result = $ilDB->queryF("SELECT question_fi, solved FROM tst_qst_solved WHERE active_fi = %s AND question_fi=%s",
                                array('integer', 'integer'),
                                array($active_id, $question_fi)
                        );
                }
                else
                {
                        $result = $ilDB->queryF("SELECT question_fi, solved FROM tst_qst_solved WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                }
                $result_array = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $result_array[$row["question_fi"]]= $row;
                }
                return $result_array;
        }


        function setQuestionSetSolved($value, $question_id, $user_id)
        {
                global $ilDB;

                $active_id = $this->getActiveIdOfUser($user_id);
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_qst_solved WHERE active_fi = %s AND question_fi = %s",
                        array('integer', 'integer'),
                        array($active_id, $question_id)
                );
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_qst_solved (solved, question_fi, active_fi) VALUES (%s, %s, %s)",
                        array('integer', 'integer', 'integer'),
                        array($value, $question_id, $active_id)
                );
        }


        function setActiveTestSubmitted($user_id)
        {
                global $ilDB, $ilLog;

                $affectedRows = $ilDB->manipulateF("UPDATE tst_active SET submitted = %s, submittimestamp = %s, tstamp = %s WHERE test_fi = %s AND user_fi = %s",
                        array('integer', 'timestamp', 'integer', 'integer', 'integer'),
                        array(1, date('Y-m-d H:i:s'), time(), $this->getTestId(), $user_id)
                );
                $this->testSession = NULL;
        }

        function isTestFinished($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT submitted FROM tst_active WHERE active_id=%s AND submitted=%s",
                        array('integer', 'integer'),
                        array($active_id, 1)
                );
                return $result->numRows() == 1;
        }

        function isActiveTestSubmitted($user_id = null)
        {
                global $ilUser;
                global $ilDB;

                if (!is_numeric($user_id))
                        $user_id = $ilUser->getId();

                $result = $ilDB->queryF("SELECT submitted FROM tst_active WHERE test_fi=%s AND user_fi=%s AND submitted=%s",
                        array('integer', 'integer', 'integer'),
                        array($this->getTestId(), $user_id, 1)
                );
                return $result->numRows() == 1;
        }
        
        function hasNrOfTriesRestriction()
        {
                return $this->getNrOfTries() != 0;
        }


        function isNrOfTriesReached($tries)
        {
                return $tries >= (int) $this->getNrOfTries();
        }


        function getAllTestResults($participants, $prepareForCSV = true)
        {
                global $lng;
                
                $results = array();
                $row = array(
                        "user_id" => $lng->txt("user_id"),
                        "matriculation" =>  $lng->txt("matriculation"),
                        "lastname" =>  $lng->txt("lastname"),
                        "firstname" => $lng->txt("firstname"),
                        "login" =>$lng->txt("login"),
                        "reached_points" => $lng->txt("tst_reached_points"),
                        "max_points" => $lng->txt("tst_maximum_points"),
                        "percent_value" => $lng->txt("tst_percent_solved"),
                        "mark" => $lng->txt("tst_mark"),
                        "ects" => $lng->txt("ects_grade")
                );
                $results[] = $row;
                if (count($participants))
                {
                        if ($this->ects_output)
                        {
                                $passed_array =& $this->getTotalPointsPassedArray();
                        }
                        foreach ($participants as $active_id => $user_rec)
                        {
                                $row = array();
                                $reached_points = 0;
                                $max_points = 0;
                                foreach ($this->questions as $value)
                                {
                                        $question =& ilObjTest::_instanciateQuestion($value);
                                        if (is_object($question))
                                        {
                                                $max_points += $question->getMaximumPoints();
                                                $reached_points += $question->getReachedPoints($active_id);
                                        }
                                }
                                if ($max_points > 0)
                                {
                                        $percentvalue = $reached_points / $max_points;
                                        if ($percentvalue < 0) $percentvalue = 0.0;
                                }
                                else
                                {
                                        $percentvalue = 0;
                                }
                                $mark_obj = $this->mark_schema->getMatchingMark($percentvalue * 100);
                                $passed = "";
                                if ($mark_obj)
                                {
                                        $mark = $mark_obj->getOfficialName();
                                        $ects_mark = $this->getECTSGrade($passed_array, $reached_points, $max_points);
                                }
                                if ($this->getAnonymity())
                                {
                                        $user_rec['firstname'] = "";
                                        $user_rec['lastname'] = $lng->txt("unknown");
                                }
                                $row = array(
                                        "user_id"=>$user_rec['usr_id'],
                                        "matriculation" =>  $user_rec['matriculation'],
                                        "lastname" =>  $user_rec['lastname'],
                                        "firstname" => $user_rec['firstname'],
                                        "login"=>$user_rec['login'],
                                        "reached_points" => $reached_points,
                                        "max_points" => $max_points,
                                        "percent_value" => $percentvalue,
                                        "mark" => $mark,
                                        "ects" => $ects_mark
                                );
                                $results[] = $prepareForCSV ? $this->processCSVRow ($row, true) : $row;
                        }
                }
                return $results;
        }

        function &processCSVRow($row, $quoteAll = FALSE, $separator = ";")
        {
                $resultarray = array();
                foreach ($row as $rowindex => $entry)
                {
                        $surround = FALSE;
                        if ($quoteAll)
                        {
                                $surround = TRUE;
                        }
                        if (strpos($entry, "\"") !== FALSE)
                        {
                                $entry = str_replace("\"", "\"\"", $entry);
                                $surround = TRUE;
                        }
                        if (strpos($entry, $separator) !== FALSE)
                        {
                                $surround = TRUE;
                        }
                        // replace all CR LF with LF (for Excel for Windows compatibility
                        $entry = str_replace(chr(13).chr(10), chr(10), $entry);
                        if ($surround)
                        {
                            $resultarray[$rowindex] = utf8_decode("\"" . $entry . "\"");
                        }
                        else
                        {
                                $resultarray[$rowindex] = utf8_decode($entry);
                        }
                }
                return $resultarray;
        }

        function _getPass($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT tries FROM tst_active WHERE active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["tries"];
                }
                else
                {
                        return 0;
                }
        }

                function _getMaxPass($active_id)
                {
                        global $ilDB;
                        $result = $ilDB->queryF("SELECT MAX(pass) maxpass FROM tst_test_result WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $max = $row["maxpass"];
                        }
                        else
                        {
                                $max = NULL;
                        }
                        return $max;
                }

        function _getBestPass($active_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT * FROM tst_pass_result WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $bestrow = null;
                        $bestpoints = -1;
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                if ($row["points"] > $bestpoints) 
                                {
                                        $bestrow = $row;
                                        $bestpoints = $row["points"];
                                }
                        }
                        if (is_array($bestrow))
                        {
                                return $bestrow["pass"];
                        }
                        else
                        {
                                return 0;
                        }
                }
                else
                {
                        return 0;
                }
        }

        function _getResultPass($active_id)
        {
                $counted_pass = NULL;
                if (ilObjTest::_getPassScoring($active_id) == SCORE_BEST_PASS)
                {
                        $counted_pass = ilObjTest::_getBestPass($active_id);
                }
                else
                {
                        $counted_pass = ilObjTest::_getMaxPass($active_id);
                }
                return $counted_pass;
        }

        function getAnsweredQuestionCount($active_id, $pass = NULL)
        {
                if ($this->isRandomTest())
                {
                        $this->loadQuestions($active_id, $pass);
                }
                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                $workedthrough = 0;
                foreach ($this->questions as $value)
                {
                        if (assQuestion::_isWorkedThrough($active_id, $value, $pass))
                        {
                                $workedthrough += 1;
                        }
                }
                return $workedthrough;
        }

        function getPassFinishDate($active_id, $pass)
        {
                global $ilDB;
                if (is_null($pass)) $pass = 0;
                $result = $ilDB->queryF("SELECT tst_test_result.tstamp FROM tst_test_result WHERE active_fi = %s AND pass = %s ORDER BY tst_test_result.tstamp DESC",
                        array('integer', 'integer'),
                        array($active_id, $pass)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["tstamp"];
                }
                else
                {
                        return 0;
                }
        }

        function isExecutable($user_id, $allowPassIncrease = FALSE)
        {
                $result = array(
                        "executable" => true,
                        "errormessage" => ""
                );
                if (!$this->startingTimeReached())
                {
                        $result["executable"] = false;
                        $result["errormessage"] = sprintf($this->lng->txt("detail_starting_time_not_reached"), ilFormat::ftimestamp2datetimeDB($this->getStartingTime()));
                        return $result;
                }
                if ($this->endingTimeReached())
                {
                        $result["executable"] = false;
                        $result["errormessage"] = sprintf($this->lng->txt("detail_ending_time_reached"), ilFormat::ftimestamp2datetimeDB($this->getEndingTime()));
                        return $result;
                }

                $active_id = $this->getActiveIdOfUser($user_id);

                if ($this->getEnableProcessingTime())
                {
                        if ($active_id > 0)
                        {
                                $starting_time = $this->getStartingTimeOfUser($active_id);
                                if ($starting_time !== FALSE)
                                {
                                        if ($this->isMaxProcessingTimeReached($starting_time, $active_id))
                                        {
                                                if ($allowPassIncrease && $this->getResetProcessingTime() && (($this->getNrOfTries() == 0) || ($this->getNrOfTries() > ($this->_getPass($active_id)+1))))
                                                {
                                                        // a test pass was quitted because the maximum processing time was reached, but the time
                                                        // will be resetted for future passes, so if there are more passes allowed, the participant may
                                                        // start the test again.
                                                        // This code block is only called when $allowPassIncrease is TRUE which only happens when
                                                        // the test info page is opened. Otherwise this will lead to unexpected results!
                                                        $this->getTestSession()->increasePass();
                                                        $this->getTestSession()->setLastSequence(0);
                                                        $this->getTestSession()->saveToDb();
                                                }
                                                else
                                                {
                                                        $result["executable"] = false;
                                                        $result["errormessage"] = $this->lng->txt("detail_max_processing_time_reached");
                                                }
                                                return $result;
                                        }
                                }
                        }
                }

                if ($this->hasNrOfTriesRestriction() && ($active_id > 0) && $this->isNrOfTriesReached($this->getTestSession($active_id)->getPass()))
                {
                        $result["executable"] = false;
                        $result["errormessage"] = $this->lng->txt("maximum_nr_of_tries_reached");
                        return $result;
                }
                
                if ($this->getTestSession($active_id)->isSubmitted())
                {
                        $result["executable"] = FALSE;
                        $result["errormessage"] = $this->lng->txt("maximum_nr_of_tries_reached");
                        return $result;
                }

                // TODO: max. processing time

                return $result;
        }

        function canViewResults()
        {
                $result = true;
                if ($this->getScoreReporting() == 4) return false;
                if ($this->getReportingDate())
                {
                        if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getReportingDate(), $matches))
                        {
                                $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                $now = mktime();
                                if ($now < $epoch_time)
                                {
                                        $result = false;
                                }
                        }
                }
                return $result;
        }

        function canShowTestResults($user_id)
        {
                $active_id = $this->getActiveIdOfUser($user_id);
                if ($active_id > 0)
                {
                        $starting_time = $this->getStartingTimeOfUser($active_id);
                }
                $notimeleft = FALSE;
                if ($starting_time !== FALSE)
                {
                        if ($this->isMaxProcessingTimeReached($starting_time, $active_id))
                        {
                                $notimeleft = TRUE;
                        }
                }
                $result = TRUE;
                if (!$this->isTestFinishedToViewResults($active_id, $this->getTestSession($active_id)->getPass()) && ($this->getScoreReporting() == REPORT_AFTER_TEST))
                {
                        $result = FALSE;
                }
                if (($this->endingTimeReached()) || $notimeleft) $result = TRUE;
                $result = $result & $this->canViewResults();
                return $result;
        }

        function canEditMarks()
        {
                $total = $this->evalTotalPersons();
                if ($total > 0)
                {
                        if ($this->getReportingDate())
                        {
                                if (preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->getReportingDate(), $matches))
                                {
                                        $epoch_time = mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                                        $now = mktime();
                                        if ($now < $epoch_time)
                                        {
                                                return true;
                                        }
                                }
                        }
                        return false;
                }
                else
                {
                        return true;
                }
        }

        function getStartingTimeOfParticipants()
        {
                global $ilDB;
                
                $times = array();
                $result = $ilDB->query("SELECT tst_times.active_fi, tst_times.started FROM tst_times, tst_active WHERE tst_times.active_fi = tst_active.active_id ORDER BY tst_times.tstamp DESC");
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $times[$row['active_fi']] = $row['started'];
                }
                return $times;
        }

        function getTimeExtensionsOfParticipants()
        {
                global $ilDB;
                
                $times = array();
                $result = $ilDB->queryF("SELECT tst_addtime.active_fi, tst_addtime.additionaltime FROM tst_addtime, tst_active WHERE tst_addtime.active_fi = tst_active.active_id AND tst_active.test_fi = %s",
                        array('integer'),
                        array($this->getTestId())
                );
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $times[$row['active_fi']] = $row['additionaltime'];
                }
                return $times;
        }

        function getStartingTimeOfUser($active_id)
        {
                global $ilDB;

                if ($active_id < 1) return FALSE;
                $pass = ($this->getResetProcessingTime()) ? $this->_getPass($active_id) : 0;
                $result = $ilDB->queryF("SELECT tst_times.started FROM tst_times WHERE tst_times.active_fi = %s AND tst_times.pass = %s ORDER BY tst_times.started",
                        array('integer', 'integer'),
                        array($active_id, $pass)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        if (preg_match("/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/", $row["started"], $matches))
                        {
                                return mktime($matches[4], $matches[5], $matches[6], $matches[2], $matches[3], $matches[1]);
                        }
                        else
                        {
                                return mktime();
                        }
                }
                else
                {
                        return mktime();
                }
        }
        
        function isMaxProcessingTimeReached($starting_time, $active_id)
        {
                if ($this->getEnableProcessingTime())
                {
                        $processing_time = $this->getProcessingTimeInSeconds($active_id);
                        $now = mktime();
                        if ($now > ($starting_time + $processing_time))
                        {
                                return TRUE;
                        }
                        else
                        {
                                return FALSE;
                        }
                }
                else
                {
                        return FALSE;
                }
        }

        function &getTestQuestions()
        {
                global $ilDB;
                $query_result = $ilDB->queryF("SELECT qpl_questions.*, qpl_qst_type.type_tag, tst_test_question.sequence FROM qpl_questions, qpl_qst_type, tst_test_question WHERE qpl_questions.question_type_fi = qpl_qst_type.question_type_id AND tst_test_question.test_fi = %s AND tst_test_question.question_fi = qpl_questions.question_id ORDER BY tst_test_question.sequence",
                        array('integer'),
                        array($this->getTestId())
                );
                $removableQuestions = array();
                while ($row = $ilDB->fetchAssoc($query_result))
                {
                        array_push($removableQuestions, $row);
                }
                return $removableQuestions;
        }

        function getShuffleQuestions()
        {
                return ($this->shuffle_questions) ? 1 : 0;
        }

        function setShuffleQuestions($a_shuffle)
        {
                $this->shuffle_questions = ($a_shuffle) ? 1 : 0;
        }

        function getListOfQuestionsSettings()
        {
                return ($this->show_summary) ? $this->show_summary : 0;
        }

        function setListOfQuestionsSettings($a_value = 0)
        {
                $this->show_summary = $a_value;
        }

        function getListOfQuestions()
        {
                if (($this->show_summary & 1) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function setListOfQuestions($a_value = TRUE)
        {
                if ($a_value)
                {
                        $this->show_summary = 1;
                }
                else
                {
                        $this->show_summary = 0;
                }
        }

        function getListOfQuestionsStart()
        {
                if (($this->show_summary & 2) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function setListOfQuestionsStart($a_value = TRUE)
        {
                if ($a_value && $this->getListOfQuestions())
                {
                        $this->show_summary = $this->show_summary | 2;
                }
                if (!$a_value && $this->getListOfQuestions())
                {
                        if ($this->getListOfQuestionsStart())
                        {
                                $this->show_summary = $this->show_summary ^ 2;
                        }
                }
        }

        function getListOfQuestionsEnd()
        {
                if (($this->show_summary & 4) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function setListOfQuestionsEnd($a_value = TRUE)
        {
                if ($a_value && $this->getListOfQuestions())
                {
                        $this->show_summary = $this->show_summary | 4;
                }
                if (!$a_value && $this->getListOfQuestions())
                {
                        if ($this->getListOfQuestionsEnd())
                        {
                                $this->show_summary = $this->show_summary ^ 4;
                        }
                }
        }

                function getListOfQuestionsDescription()
                {
                        if (($this->show_summary & 8) > 0)
                        {
                                return TRUE;
                        }
                        else
                        {
                                return FALSE;
                        }
                }

                function setListOfQuestionsDescription($a_value = TRUE)
                {
                        if ($a_value && $this->getListOfQuestions())
                        {
                                $this->show_summary = $this->show_summary | 8;
                        }
                        if (!$a_value && $this->getListOfQuestions())
                        {
                                if ($this->getListOfQuestionsDescription())
                                {
                                        $this->show_summary = $this->show_summary ^ 8;
                                }
                        }
                }

        function getResultsPresentation()
        {
                return ($this->results_presentation) ? $this->results_presentation : 0;
        }

        function getShowPassDetails()
        {
                if (($this->results_presentation & 1) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function getShowSolutionDetails()
        {
                if (($this->results_presentation & 2) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function getShowSolutionPrintview()
        {
                if (($this->results_presentation & 4) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function getShowSolutionFeedback()
        {
                if (($this->results_presentation & 8) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

                function getShowSolutionAnswersOnly()
                {
                        if (($this->results_presentation & 16) > 0)
                        {
                                return TRUE;
                        }
                        else
                        {
                                return FALSE;
                        }
                }

                function getShowSolutionSignature()
                {
                        if (($this->results_presentation & 32) > 0)
                        {
                                return TRUE;
                        }
                        else
                        {
                                return FALSE;
                        }
                }

        function getShowSolutionSuggested()
        {
                if (($this->results_presentation & 64) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function getShowSolutionListComparison()
        {
                if (($this->results_presentation & 128) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function getShowSolutionAnwersBeforeFinish()
        {
                if (($this->results_presentation & 256) > 0)
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function setResultsPresentation($a_results_presentation = 3)
        {
                $this->results_presentation = $a_results_presentation;
        }

        function setShowPassDetails($a_details = 1)
        {
                if ($a_details)
                {
                        $this->results_presentation = $this->results_presentation | 1;
                }
                else
                {
                        if ($this->getShowPassDetails())
                        {
                                $this->results_presentation = $this->results_presentation ^ 1;
                        }
                }
        }

        function setShowSolutionDetails($a_details = 1)
        { 
                if ($a_details)
                {
                        $this->results_presentation = $this->results_presentation | 2;
                }
                else
                {
                        if ($this->getShowSolutionDetails())
                        {
                                $this->results_presentation = $this->results_presentation ^ 2;
                        }
                }
        }

        function setShowSolutionPrintview($a_printview = 1)
        {
                if ($a_printview)
                {
                        $this->results_presentation = $this->results_presentation | 4;
                }
                else
                {
                        if ($this->getShowSolutionPrintview())
                        {
                                $this->results_presentation = $this->results_presentation ^ 4;
                        }
                }
        }

        function setShowSolutionFeedback($a_feedback = TRUE)
        {
                if ($a_feedback)
                {
                        $this->results_presentation = $this->results_presentation | 8;
                }
                else
                {
                        if ($this->getShowSolutionFeedback())
                        {
                                $this->results_presentation = $this->results_presentation ^ 8;
                        }
                }
        }

                function setShowSolutionAnswersOnly($a_full = TRUE)
                {
                        if ($a_full)
                        {
                                $this->results_presentation = $this->results_presentation | 16;
                        }
                        else
                        {
                                if ($this->getShowSolutionAnswersOnly())
                                {
                                        $this->results_presentation = $this->results_presentation ^ 16;
                                }
                        }
                }

                function setShowSolutionSignature($a_signature = FALSE)
                {
                        if ($a_signature)
                        {
                                $this->results_presentation = $this->results_presentation | 32;
                        }
                        else
                        {
                                if ($this->getShowSolutionSignature())
                                {
                                        $this->results_presentation = $this->results_presentation ^ 32;
                                }
                        }
                }

        function setShowSolutionSuggested($a_solution = FALSE)
        {
                if ($a_solution)
                {
                        $this->results_presentation = $this->results_presentation | 64;
                }
                else
                {
                        if ($this->getShowSolutionSuggested())
                        {
                                $this->results_presentation = $this->results_presentation ^ 64;
                        }
                }
        }

        function setShowSolutionListComparison($a_comparison = FALSE)
        {
                if ($a_comparison)
                {
                        $this->results_presentation = $this->results_presentation | 128;
                }
                else
                {
                        if ($this->getShowSolutionListComparison())
                        {
                                $this->results_presentation = $this->results_presentation ^ 128;
                        }
                }
        }

        function setShowSolutionAnwersBeforeFinish($a_value = FALSE)
        {
                if ($a_value)
                {
                        $this->results_presentation = $this->results_presentation | 256;
                }
                else
                {
                if ($this->getShowSolutionAnwersBeforeFinish())
                        {
                                $this->results_presentation = $this->results_presentation ^ 256;
                        }
                }
        }
        
        function createNewAccessCode()
        {
                // create a 5 character code
                $codestring = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
                mt_srand();
                $code = "";
                for ($i = 1; $i <=5; $i++)
                {
                        $index = mt_rand(0, strlen($codestring)-1);
                        $code .= substr($codestring, $index, 1);
                }
                // verify it against the database
                while ($this->isAccessCodeUsed($code))
                {
                        $code = $this->createNewAccessCode();
                }
                return $code;
        }

        function isAccessCodeUsed($code)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT anonymous_id FROM tst_active WHERE test_fi = %s AND anonymous_id = %s",
                        array('integer', 'text'),
                        array($this->getTestId(), $code)
                );
                return ($result->numRows() > 0) ? true : false;
        }

        public static function _getUserIdFromActiveId($active_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT user_fi FROM tst_active WHERE active_id = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["user_fi"];
                }
                else
                {
                        return -1;
                }
        }

        function getAccessCodeSession()
        {
                $id = $this->getTestId();
                if (!is_array($_SESSION["tst_access_code"]))
                {
                        return "";
                }
                else
                {
                        return $_SESSION["tst_access_code"]["$id"];
                }
        }

        function setAccessCodeSession($access_code)
        {
                $id = $this->getTestId();
                if (!is_array($_SESSION["tst_access_code"]))
                {
                        $_SESSION["tst_access_code"] = array();
                }
                $_SESSION["tst_access_code"]["$id"] = $access_code;
        }

        function unsetAccessCodeSession()
        {
                $id = $this->getTestId();
                unset($_SESSION["tst_access_code"]["$id"]);
        }

        function getAllowedUsers()
        {
                return ($this->allowedUsers) ? $this->allowedUsers : 0;
        }

        function setAllowedUsers($a_allowed_users)
        {
                $this->allowedUsers = $a_allowed_users;
        }

        function getAllowedUsersTimeGap()
        {
                return ($this->allowedUsersTimeGap) ? $this->allowedUsersTimeGap : 0;
        }

        function setAllowedUsersTimeGap($a_allowed_users_time_gap)
        {
                $this->allowedUsersTimeGap = $a_allowed_users_time_gap;
        }

        function checkMaximumAllowedUsers()
        {
                global $ilDB;

                $nr_of_users = $this->getAllowedUsers();
                $time_gap = ($this->getAllowedUsersTimeGap()) ? $this->getAllowedUsersTimeGap() : 60;
                if (($nr_of_users > 0) && ($time_gap > 0))
                {
                        $now = mktime();
                        $time_border = $now - $time_gap;
                        $str_time_border = strftime("%Y%m%d%H%M%S", $time_border);
                        $result = $ilDB->queryF("SELECT DISTINCT tst_times.active_fi FROM tst_times, tst_active WHERE tst_times.tstamp > %s AND tst_times.active_fi = tst_active.active_id AND tst_active.test_fi = %s",
                                array('integer', 'integer'),
                                array($time_border, $this->getTestId())
                        );
                        if ($result->numRows() >= $nr_of_users)
                        {
                                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                                {
                                        $this->logAction($this->lng->txtlng("assessment", "log_could_not_enter_test_due_to_simultaneous_users", ilObjAssessmentFolder::_getLogLanguage()));
                                }
                                return FALSE;
                        }
                        else
                        {
                                return TRUE;
                        }
                }
                return TRUE;
        }

        function _getLastAccess($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT finished FROM tst_times WHERE active_fi = %s ORDER BY finished DESC",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["finished"];
                }
                return "";
        }

        function isHTML($a_text)
        {
                if (preg_match("/<[^>]*?>/", $a_text))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function QTIMaterialToString($a_material)
        {
                $result = "";
                for ($i = 0; $i < $a_material->getMaterialCount(); $i++)
                {
                        $material = $a_material->getMaterial($i);
                        if (strcmp($material["type"], "mattext") == 0)
                        {
                                $result .= $material["material"]->getContent();
                        }
                        if (strcmp($material["type"], "matimage") == 0)
                        {
                                $matimage = $material["material"];
                                if (preg_match("/(il_([0-9]+)_mob_([0-9]+))/", $matimage->getLabel(), $matches))
                                {
                                        // import an mediaobject which was inserted using tiny mce
                                        if (!is_array($_SESSION["import_mob_xhtml"])) $_SESSION["import_mob_xhtml"] = array();
                                        array_push($_SESSION["import_mob_xhtml"], array("mob" => $matimage->getLabel(), "uri" => $matimage->getUri()));
                                }
                        }
                }
                global $ilLog;
                $ilLog->write(print_r($_SESSION["import_mob_xhtml"], true));
                return $result;
        }

        function prepareTextareaOutput($txt_output, $prepare_for_latex_output = FALSE)
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                return ilUtil::prepareTextareaOutput($txt_output, $prepare_for_latex_output);
        }

        function saveCertificateVisibility($a_value)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("UPDATE tst_tests SET certificate_visibility = %s, tstamp = %s WHERE test_id = %s",
                        array('text', 'integer', 'integer'),
                        array($a_value, time(), $this->getTestId())
                );
        }

        function getCertificateVisibility()
        {
                return (strlen($this->certificate_visibility)) ? $this->certificate_visibility : 0;
        }

        function setCertificateVisibility($a_value)
        {
                $this->certificate_visibility = $a_value;
        }

        function getAnonymity()
        {
                return ($this->anonymity) ? 1 : 0;
        }

        function setAnonymity($a_value = 0)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->anonymity = 1;
                                break;
                        default:
                                $this->anonymity = 0;
                                break;
                }
        }

        function getShowCancel()
        {
                return ($this->show_cancel) ? 1 : 0;
        }

        function setShowCancel($a_value = 1)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->show_cancel = 1;
                                break;
                        default:
                                $this->show_cancel = 0;
                                break;
                }
        }

        function getAutosave()
        {
                return ($this->autosave) ? 1 : 0;
        }

        function setAutosave($a_value = 1)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->autosave = 1;
                                break;
                        default:
                                $this->autosave = 0;
                                break;
                }
        }

        function getShowMarker()
        {
                return ($this->show_marker) ? 1 : 0;
        }

        function setShowMarker($a_value = 1)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->show_marker = 1;
                                break;
                        default:
                                $this->show_marker = 0;
                                break;
                }
        }

        function getFixedParticipants()
        {
                return ($this->fixed_participants) ? 1 : 0;
        }

        function setFixedParticipants($a_value = 1)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->fixed_participants = 1;
                                break;
                        default:
                                $this->fixed_participants = 0;
                                break;
                }
        }

        function _lookupAnonymity($a_obj_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT anonymity FROM tst_tests WHERE obj_fi = %s",
                        array('integer'),
                        array($a_obj_id)
                );
                while($row = $ilDB->fetchAssoc($result))
                {
                        return $row['anonymity'];
                }
                return 0;
        }

        function _lookupRandomTestFromActiveId($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT tst_tests.random_test FROM tst_tests, tst_active WHERE tst_active.active_id = %s AND tst_active.test_fi = tst_tests.test_id",
                        array('integer'),
                        array($active_id)
                );
                while($row = $ilDB->fetchAssoc($result))
                {
                        return $row['random_test'];
                }
                return 0;
        }

        function userLookupFullName($user_id, $overwrite_anonymity = FALSE, $sorted_order = FALSE, $suffix = "")
        {
                global $lng;
                
                if ($this->getAnonymity() && !$overwrite_anonymity)
                {
                        return $lng->txt("unknown") . $suffix;
                }
                else
                {
                        include_once './Services/User/classes/class.ilObjUser.php';
                        $uname = ilObjUser::_lookupName($user_id);
                        if (strlen($uname["firstname"].$uname["lastname"]) == 0) $uname["firstname"] = $lng->txt("deleted_user");
                        if ($sorted_order)
                        {
                                return trim($uname["lastname"] . ", " . $uname["firstname"]) .  $suffix;
                        }
                        else
                        {
                                return trim($uname["firstname"] . " " . $uname["lastname"]) .  $suffix;
                        }
                }
        }

        function getStartTestLabel($active_id)
        {
                //if ($this->getNrOfTries() == 1)
                //{
                //      return $this->lng->txt("tst_start_test");
                //}
                $active_pass = $this->_getPass($active_id);
                $res = $this->getNrOfResultsForPass($active_id, $active_pass);
                if ($res == 0)
                {
                        if ($active_pass == 0)
                        {
                                return $this->lng->txt("tst_start_test");
                        }
                        else
                        {
                                return $this->lng->txt("tst_start_new_test_pass");
                        }
                }
                else
                {
                        return $this->lng->txt("tst_resume_test");
                }
        }

        function &getAvailableDefaults($sortby = "name", $sortorder = "asc")
        {
                global $ilDB;
                global $ilUser;
                
                $result = $ilDB->queryF("SELECT * FROM tst_test_defaults WHERE user_fi = %s ORDER BY $sortby $sortorder",
                        array('integer'),
                        array($ilUser->getId())
                );
                $defaults = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $defaults[$row["test_defaults_id"]] = $row;
                }
                return $defaults;
        }
        
        function &getTestDefaults($test_defaults_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT * FROM tst_test_defaults WHERE test_defaults_id = %s",
                        array('integer'),
                        array($test_defaults_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row;
                }
                else
                {
                        return NULL;
                }
        }
        
        function deleteDefaults($test_default_id)
        {
                global $ilDB;
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_defaults WHERE test_defaults_id = %s",
                        array('integer'),
                        array($test_default_id)
                );
        }
        
        function addDefaults($a_name)
        {
                global $ilDB;
                global $ilUser;
                $testsettings = array(
                        "TitleOutput" => $this->getTitleOutput(),
                        "PassScoring" => $this->getPassScoring(),
                        "Introduction" => $this->getIntroduction(),
                        "FinalStatement" => $this->getFinalStatement(),
                        /* Change Sn */
                        "RedirectAfterExam" => $this->getRedirectAfterExam(),
                        "RedirectOnlyKioskMode" => $this->getRedirectOnlyKioskMode(),
                        "ExamPdf" => $this->getExamPdf(),
                        /* Change Sn End */
                        "ShowInfo" => $this->getShowInfo(),
                        "ForceJS" => $this->getForceJS(),
                        "CustomStyle" => $this->getCustomStyle(),
                        "ShowFinalStatement" => $this->getShowFinalStatement(),
                        "SequenceSettings" => $this->getSequenceSettings(),
                        "ScoreReporting" => $this->getScoreReporting(),
                        "InstantFeedbackSolution" => $this->getInstantFeedbackSolution(),
                        "AnswerFeedback" => $this->getAnswerFeedback(),
                        "AnswerFeedbackPoints" => $this->getAnswerFeedbackPoints(),
                        "ResultsPresentation" => $this->getResultsPresentation(),
                        "Anonymity" => $this->getAnonymity(),
                        "ShowCancel" => $this->getShowCancel(),
                        "Autosave" => $this->getAutosave(),
                        "ShowMarker" => $this->getShowMarker(),
                        "ReportingDate" => $this->getReportingDate(),
                        "NrOfTries" => $this->getNrOfTries(),
                        "Shuffle" => $this->getShuffleQuestions(),
                        "Kiosk" => $this->getKiosk(),
                        "Serial" => $this->getShowSerial(),
                        "Shuffle" => $this->getShuffleQuestions(),
                        "UsePreviousAnswers" => $this->getUsePreviousAnswers(),
                        "ProcessingTime" => $this->getProcessingTime(),
                        "EnableProcessingTime" => $this->getEnableProcessingTime(),
                        "ResetProcessingTime" => $this->getResetProcessingTime(),
                        "StartingTime" => $this->getStartingTime(),
                        "EndingTime" => $this->getEndingTime(),
                        "ECTSOutput" => $this->getECTSOutput(),
                        "ECTSFX" => $this->getECTSFX(),
                        "ECTSGrades" => $this->getECTSGrades(),
                        "isRandomTest" => $this->isRandomTest(),
                        "RandomQuestionCount" => $this->getRandomQuestionCount(),
                        "CountSystem" => $this->getCountSystem(),
                        "MCScoring" => $this->getMCScoring(),
                        "mailnotification" => $this->getMailNotification(),
                        "mailnottype" => $this->getMailNotificationType(),
                        "exportsettings" => $this->getExportSettings(),
                        "ListOfQuestionsSettings" => $this->getListOfQuestionsSettings()
                );
                $next_id = $ilDB->nextId('tst_test_defaults');
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_defaults (test_defaults_id, name, user_fi, defaults, marks, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                        array('integer', 'text', 'integer', 'text', 'text', 'integer'),
                        array($next_id, $a_name, $ilUser->getId(), serialize($testsettings), serialize($this->mark_schema), time())
                );
        }
        
        function applyDefaults($test_defaults_id)
        {
                $total = $this->evalTotalPersons();
                $result = FALSE;
                if (($this->getQuestionCount() == 0) && ($total == 0))
                {
                        // only apply if there are no questions added and not user datasets exist
                        $defaults =& $this->getTestDefaults($test_defaults_id);
                        $testsettings = unserialize($defaults["defaults"]);
                        include_once "./Modules/Test/classes/class.assMarkSchema.php";
                        $this->mark_schema = unserialize($defaults["marks"]);
                        $this->setTitleOutput($testsettings["TitleOutput"]);
                        $this->setPassScoring($testsettings["PassScoring"]);
                        $this->setIntroduction($testsettings["Introduction"]);
                        $this->setFinalStatement($testsettings["FinalStatement"]);
                        /* Change Sn */
                        $this->setRedirectAfterExam($testsettings["RedirectAfterExam"]);
                        $this->setRedirectOnlyKioskMode($testsettings["RedirectOnlyKioskMode"]);
                        $this->setExamPdf($testsettings["ExamPdf"]);
                        /* Change Sn End */
                        $this->setShowInfo($testsettings["ShowInfo"]);
                        $this->setForceJS($testsettings["ForceJS"]);
                        $this->setCustomStyle($testsettings["CustomStyle"]);
                        $this->setShowFinalStatement($testsettings["ShowFinalStatement"]);
                        $this->setSequenceSettings($testsettings["SequenceSettings"]);
                        $this->setScoreReporting($testsettings["ScoreReporting"]);
                        $this->setInstantFeedbackSolution($testsettings["InstantFeedbackSolution"]);
                        $this->setAnswerFeedback($testsettings["AnswerFeedback"]);
                        $this->setAnswerFeedbackPoints($testsettings["AnswerFeedbackPoints"]);
                        $this->setResultsPresentation($testsettings["ResultsPresentation"]);
                        $this->setAnonymity($testsettings["Anonymity"]);
                        $this->setShowCancel($testsettings["ShowCancel"]);
                        $this->setAutosave($testsettings["Autosave"]);
                        $this->setShowMarker($testsettings["ShowMarker"]);
                        $this->setReportingDate($testsettings["ReportingDate"]);
                        $this->setShuffleQuestions($testsettings["this"]);
                        $this->setNrOfTries($testsettings["NrOfTries"]);
                        $this->setUsePreviousAnswers($testsettings["UsePreviousAnswers"]);
                        $this->setProcessingTime($testsettings["ProcessingTime"]);
                        $this->setResetProcessingTime($testsettings["ResetProcessingTime"]);
                        $this->setShuffleQuestions($testsettings["Shuffle"]);
                        $this->setEnableProcessingTime($testsettings["EnableProcessingTime"]);
                        $this->setStartingTime($testsettings["StartingTime"]);
                        $this->setKiosk($testsettings["Kiosk"]);
                        $this->setShowSerial($testsettings["Serial"]);
                        $this->setEndingTime($testsettings["EndingTime"]);
                        $this->setECTSOutput($testsettings["ECTSOutput"]);
                        $this->setECTSFX($testsettings["ECTSFX"]);
                        $this->setECTSGrades($testsettings["ECTSGrades"]);
                        $this->setRandomTest($testsettings["isRandomTest"]);
                        $this->setRandomQuestionCount($testsettings["RandomQuestionCount"]);
                        $this->setCountSystem($testsettings["CountSystem"]);
                        $this->setMCScoring($testsettings["MCScoring"]);
                        $this->setMailNotification($testsettings["mailnotification"]);
                        $this->setMailNotificationType($testsettings["mailnottype"]);
                        $this->setExportSettings($testsettings['exportsettings']);
                        $this->setListOfQuestionsSettings($testsettings["ListOfQuestionsSettings"]);
                        $this->saveToDb();
                        $result = TRUE;
                }
                return $result;
        }

        public function deliverPDFFromHTML($content, $title = NULL, $filename = NULL)
        {
                global $ilLog;
                $content = preg_replace("/href=\".*?\"/", "", $content);
                $printbody = new ilTemplate("tpl.il_as_tst_print_body.html", TRUE, TRUE, "Modules/Test");
                $printbody->setVariable("TITLE", ilUtil::prepareFormOutput($this->getTitle()));
                $printbody->setVariable("ADM_CONTENT", $content);
                $printbody->setCurrentBlock("css_file");
                $printbody->setVariable("CSS_FILE", $this->getTestStyleLocation("filesystem"));
                $printbody->parseCurrentBlock();
                $printbody->setCurrentBlock("css_file");
                $printbody->setVariable("CSS_FILE", ilUtil::getStyleSheetLocation("filesystem", "delos.css"));
                $printbody->parseCurrentBlock();
                $printoutput = $printbody->get();
                $html = str_replace("href=\"./", "href=\"" . ILIAS_HTTP_PATH . "/", $printoutput);
        $html = str_replace("img src=\"./", "img src=\"" . ILIAS_HTTP_PATH . "/", $html);
                $html = preg_replace("/<div id=\"dontprint\">.*?<\\/div>/ims", "", $html);
                if (extension_loaded("tidy"))
                {
                        $config = array(
                                "indent"         => false,
                                "output-xml"     => true,
                                "numeric-entities" => true
                        );
                        $tidy = new tidy();
                        $tidy->parseString($html, $config, 'utf8');
                        $tidy->cleanRepair();
                        $html = tidy_get_output($tidy);
                        $html = preg_replace("/^.*?(<html)/", "\\1", $html);
                }
                else
                {
                        $html = str_replace("&nbsp;", "&#160;", $html);
                        $html = str_replace("&otimes;", "X", $html);
                }
                $title = ($title) ? $title : $this->getTitle();
 
                
                $active_id = $_GET["active_id"];
                include_once './Services/User/classes/class.ilObjUser.php';
                $user_id = $this->_getUserIdFromActiveId($active_id);
                $uname = ilObjUser::_lookupName($user_id);
                $filename_pdf = $uname['lastname']."_".$uname['firstname']."_".$uname['login']."_"; 
                
                
                
                $pdfSetting = new ilSetting("pdf");
                include_once "./Services/PDF/classes/class.ilHTMLToPDF.php";
                $transformer = null;
                switch ($pdfSetting->get('html_to_pdf_method'))
                {
                        case 'fop':
                                include_once "./Services/PDF/classes/class.ilHTMLToPDFTransformerUsingFOP.php";
                                $transformer = new ilHTMLtoPDFTransformerUsingFOP($filename_pdf . $title . '.pdf');
                                $transformer->xsl = "./Modules/Test/xml/question2fo.xsl";
                                break;
                        case 'webkit':
                                include_once "./Services/PDF/classes/class.ilHTMLToPDFTransformerUsingWebkit.php";
                                $transformer = new ilHTMLtoPDFTransformerUsingWebkit($filename_pdf . $title . '.pdf');
                                break;
                }
                if (is_object($transformer))
                {
                        $generator = new ilHTMLtoPDF($transformer);
                        if ($filename)
                          {
                            $generator->createPDFFileFromHTMLString($html, $filename);
                          }
                        else
                          {                           
                            $generator->deliverPDFFromHTMLString($html);
                          }
                }
        }
                
        static function getManualFeedback($active_id, $question_id, $pass)
        {
                global $ilDB;
                $feedback = "";
                $result = $ilDB->queryF("SELECT feedback FROM tst_manual_fb WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                        array('integer', 'integer', 'integer'),
                        array($active_id, $question_id, $pass)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $feedback = ilRTE::_replaceMediaObjectImageSrc($row["feedback"], 1);
                }
                return $feedback;
        }
        
        function saveManualFeedback($active_id, $question_id, $pass, $feedback)
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_manual_fb WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                        array('integer', 'integer', 'integer'),
                        array($active_id, $question_id, $pass)
                );

                if (strlen($feedback))
                {
                        $next_id = $ilDB->nextId('tst_manual_fb');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO tst_manual_fb (manual_feedback_id, active_fi, question_fi, pass, feedback, tstamp) VALUES (%s, %s, %s, %s, %s, %s)",
                                array('integer', 'integer', 'integer', 'integer', 'text', 'integer'),
                                array($next_id, $active_id, $question_id, $pass, ilRTE::_replaceMediaObjectImageSrc($feedback, 0), time())
                        );
                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                global $lng, $ilUser;
                                include_once "./Modules/Test/classes/class.ilObjTestAccess.php";
                                $username = ilObjTestAccess::_getParticipantData($active_id);
                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                $this->logAction(sprintf($lng->txtlng("assessment", "log_manual_feedback", ilObjAssessmentFolder::_getLogLanguage()), $ilUser->getFullname() . " (" . $ilUser->getLogin() . ")", $username, assQuestion::_getQuestionTitle($question_id), $feedback));
                        }
                }
                if (PEAR::isError($result)) 
                {
                        global $ilias;
                        $ilias->raiseError($result->getMessage());
                }
                else
                {
                        return TRUE;
                }
        }
        
        function getJavaScriptOutput()
        {
                global $ilUser;
                if (strcmp($_GET["tst_javascript"], "0") == 0) return FALSE;
                if ($this->getForceJS()) return TRUE;
                $assessmentSetting = new ilSetting("assessment");
                return ($ilUser->getPref("tst_javascript") === FALSE) ? $assessmentSetting->get("use_javascript") : $ilUser->getPref("tst_javascript");
        }
        
        function &createTestSession()
        {
                global $ilUser;
                
                include_once "./Modules/Test/classes/class.ilTestSession.php";
                $testSession = FALSE;
                $testSession = new ilTestSession();
                $testSession->setRefId($this->getRefId());
                $testSession->setTestId($this->getTestId());
                $testSession->setUserId($ilUser->getId());
                $testSession->setAnonymousId($_SESSION["tst_access_code"][$this->getTestId()]);
                $testSession->saveToDb();
                $this->testSession =& $testSession;
                return $this->testSession;
        }
        
        public function setTestId($a_id)
        {
                $this->test_id = $a_id;
        }

        function &setTestSession($active_id = "")
        {
                if (is_object($this->testSession) && ($this->testSession->getActiveId() > 0)) return $this->testSession;
                
                global $ilUser;
                
                include_once "./Modules/Test/classes/class.ilTestSession.php";
                $testSession = FALSE;
                if ($active_id > 0)
                {
                        $testSession = new ilTestSession($active_id);
                        $testSession->setRefId($this->getRefId());
                }
                else
                {
                        $testSession = new ilTestSession();
                        $testSession->setRefId($this->getRefId());
                        $testSession->loadTestSession($this->getTestId(), $ilUser->getId(), $_SESSION["tst_access_code"][$this->getTestId()]);
                }
                $this->testSession =& $testSession;
                return $this->testSession;
        }
        
        function &getTestSession($active_id = "")
        {
                if (is_object($this->testSession) && ($this->testSession->getActiveId() > 0)) return $this->testSession;
                return $this->setTestSession($active_id);
        }
        
        function &createTestSequence($active_id, $pass, $shuffle)
        {
                include_once "./Modules/Test/classes/class.ilTestSequence.php";
                $this->testSequence = new ilTestSequence($active_id, $pass, $this->isRandomTest());
                if (!$this->testSequence->hasSequence())
                {
                        $this->testSequence->createNewSequence($this->getQuestionCount(), $shuffle);
                        $this->testSequence->saveToDb();
                }
        }
        
        function &getTestSequence($active_id = "", $pass = "")
        {
                if (is_object($this->testSequence) && ($this->testSequence->getActiveId() > 0)) return $this->testSequence;
                
                include_once "./Modules/Test/classes/class.ilTestSequence.php";
                if (($active_id > 0) && (strlen($pass)))
                {
                        $this->testSequence = new ilTestSequence($active_id, $pass, $this->isRandomTest());
                }
                else
                {
                        $this->testSequence = new ilTestSequence($this->getTestSession()->getActiveId(), $this->getTestSession()->getPass(), $this->isRandomTest());
                }
                return $this->testSequence;
        }
        
        function hideCorrectAnsweredQuestions()
        {
                if ($this->getTestSession()->getActiveId() > 0)
                {
                        $result = $this->getTestResult($this->getTestSession()->getActiveId(), $this->getTestSession()->getPass(), TRUE);
                        foreach ($result as $sequence => $question)
                        {
                                if (is_numeric($sequence))
                                {
                                        if ($question["reached"] == $question["max"])
                                        {
                                                $this->getTestSequence()->hideQuestion($question["qid"]);
                                        }
                                }
                        }
                        $this->getTestSequence()->saveToDb();
                }
        }
        
        function getDetailedTestResults($participants)
        {
                global $lng;
                
                $results = array();
                if (count($participants))
                {
                        foreach ($participants as $active_id => $user_rec)
                        {
                                $row = array();
                                $reached_points = 0;
                                $max_points = 0;
                                foreach ($this->questions as $value)
                                {
                                        $question =& ilObjTest::_instanciateQuestion($value);
                                        if (is_object($question))
                                        {
                                                $max_points += $question->getMaximumPoints();
                                                $reached_points += $question->getReachedPoints($active_id);
                                                if ($max_points > 0)
                                                {
                                                        $percentvalue = $reached_points / $max_points;
                                                        if ($percentvalue < 0) $percentvalue = 0.0;
                                                }
                                                else
                                                {
                                                        $percentvalue = 0;
                                                }
                                                if ($this->getAnonymity())
                                                {
                                                        $user_rec['firstname'] = "";
                                                        $user_rec['lastname'] = $lng->txt("unknown");
                                                }
                                                $row = array(
                                                        "user_id"=>$user_rec['usr_id'],
                                                        "matriculation" =>  $user_rec['matriculation'],
                                                        "lastname" =>  $user_rec['lastname'],
                                                        "firstname" => $user_rec['firstname'],
                                                        "login"=>$user_rec['login'],
                                                        "question_id" => $question->getId(),
                                                        "question_title" => $question->getTitle(),
                                                        "reached_points" => $reached_points,
                                                        "max_points" => $max_points
                                                );
                                                $results[] = $row;
                                        }
                                }
                        }
                }
                return $results;
        }

        function _lookupTestObjIdForQuestionId($a_q_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT t.obj_fi obj_id FROM tst_test_question q, tst_tests t WHERE q.test_fi = t.test_id AND q.question_fi = %s",
                        array('integer'),
                        array($a_q_id)
                );
                $rec = $ilDB->fetchAssoc($result);
                return $rec["obj_id"];
        }

        function isPluginActive($a_pname)
        {
                global $ilPluginAdmin;
                if ($ilPluginAdmin->isActive(IL_COMP_MODULE, "TestQuestionPool", "qst", $a_pname))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        function setEvaluationAdditionalFields($fields)
        {
                $assessmentSetting = new ilSetting("assessment");
                $assessmentSetting->set("evalFields_" . $this->getId(), serialize($fields));
        }
        
        function getEvaluationAdditionalFields()
        {
                include_once "./Modules/Test/classes/class.ilObjTestGUI.php";
                include_once "./Modules/Test/classes/tables/class.ilEvaluationAllTableGUI.php";
                $table_gui = new ilEvaluationAllTableGUI(new ilObjTestGUI(), 'outEvaluation');
                return $table_gui->getSelectedColumns();
        }

        protected function getPassed($active_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT passed FROM tst_result_cache WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row['passed'];
                }
                else
                {
                        $counted_pass = ilObjTest::_getResultPass($active_id);
                        $result_array =& $this->getTestResult($active_id, $counted_pass);
                        return $result_array["test"]["passed"];
                }
        }

        function canShowCertificate($user_id, $active_id)
        {
                if ($this->canShowTestResults($user_id))
                {
                        include_once "./Services/Certificate/classes/class.ilCertificate.php";
                        include_once "./Modules/Test/classes/class.ilTestCertificateAdapter.php";
                        $cert = new ilCertificate(new ilTestCertificateAdapter($this));
                        if ($cert->isComplete())
                        {
                                $vis = $this->getCertificateVisibility();
                                $showcert = FALSE;
                                switch ($vis)
                                {
                                        case 0:
                                                $showcert = TRUE;
                                                break;
                                        case 1:
                                                if ($this->getPassed($active_id))
                                                {
                                                        $showcert = TRUE;
                                                }
                                                break;
                                        case 2:
                                                $showcert = FALSE;
                                                break;
                                }
                                if ($showcert)
                                {
                                        return TRUE;
                                }
                                else
                                {
                                        return FALSE;
                                }
                        }
                        else
                        {
                                return FALSE;
                        }
                }
                else
                {
                        return FALSE;
                }
        }

        function getParticipantsForTestAndQuestion($test_id, $question_id)
        {
                global $ilDB;
                /*$result = $ilDB->queryF("SELECT tst_test_result.active_fi, tst_test_result.question_fi, tst_test_result.pass FROM tst_test_result, tst_active, qpl_questions WHERE tst_active.active_id = tst_test_result.active_fi AND tst_active.test_fi = %s AND tst_test_result.question_fi = qpl_questions.question_id AND qpl_questions.original_id = %s",
                        array('integer', 'integer'),
                        array($test_id, $question_id)
                );*/
                $result = $ilDB->queryF("SELECT tst_test_result.active_fi, tst_test_result.question_fi, tst_test_result.pass FROM tst_test_result, tst_active, usr_data WHERE tst_active.active_id = tst_test_result.active_fi AND tst_active.test_fi = %s AND tst_test_result.question_fi = %s AND tst_active.user_fi=usr_data.usr_id ORDER BY usr_data.lastname ASC",
                        array('integer', 'integer'),
                        array($test_id, $question_id)
                );
                $foundusers = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        if (!array_key_exists($row["active_fi"], $foundusers))
                        {
                                $foundusers[$row["active_fi"]] = array();
                        }
                        array_push($foundusers[$row["active_fi"]], array("pass" => $row["pass"], "qid" => $row["question_fi"]));
                }
                return $foundusers;
        }

        public function getAggregatedResultsData()
        {
                $data =& $this->getCompleteEvaluationData();
                $foundParticipants =& $data->getParticipants();
                $results = array("overview" => array(), "questions" => array());
                if (count($foundParticipants)) 
                {
                        $results["overview"][$this->lng->txt("tst_eval_total_persons")] = count($foundParticipants);
                        $total_finished = $this->evalTotalFinished();
                        $results["overview"][$this->lng->txt("tst_eval_total_finished")] = $total_finished;
                        $average_time = $this->evalTotalStartedAverageTime();
                        $diff_seconds = $average_time;
                        $diff_hours    = floor($diff_seconds/3600);
                        $diff_seconds -= $diff_hours   * 3600;
                        $diff_minutes  = floor($diff_seconds/60);
                        $diff_seconds -= $diff_minutes * 60;
                        $results["overview"][$this->lng->txt("tst_eval_total_finished_average_time")] = sprintf("%02d:%02d:%02d", $diff_hours, $diff_minutes, $diff_seconds);
                        $total_passed = 0;
                        $total_passed_reached = 0;
                        $total_passed_max = 0;
                        $total_passed_time = 0;
                        foreach ($foundParticipants as $userdata)
                        {
                                if ($userdata->getPassed()) 
                                {
                                        $total_passed++;
                                        $total_passed_reached += $userdata->getReached();
                                        $total_passed_max += $userdata->getMaxpoints();
                                        $total_passed_time += $userdata->getTimeOfWork();
                                }
                        }
                        $average_passed_reached = $total_passed ? $total_passed_reached / $total_passed : 0;
                        $average_passed_max = $total_passed ? $total_passed_max / $total_passed : 0;
                        $average_passed_time = $total_passed ? $total_passed_time / $total_passed : 0;
                        $results["overview"][$this->lng->txt("tst_eval_total_passed")] = $total_passed;
                        $results["overview"][$this->lng->txt("tst_eval_total_passed_average_points")] = sprintf("%2.2f", $average_passed_reached) . " " . strtolower($this->lng->txt("of")) . " " . sprintf("%2.2f", $average_passed_max);
                        $average_time = $average_passed_time;
                        $diff_seconds = $average_time;
                        $diff_hours    = floor($diff_seconds/3600);
                        $diff_seconds -= $diff_hours   * 3600;
                        $diff_minutes  = floor($diff_seconds/60);
                        $diff_seconds -= $diff_minutes * 60;
                        $results["overview"][$this->lng->txt("tst_eval_total_passed_average_time")] = sprintf("%02d:%02d:%02d", $diff_hours, $diff_minutes, $diff_seconds);
                } 

                foreach ($data->getQuestionTitles() as $question_id => $question_title)
                {
                        $answered = 0;
                        $reached = 0;
                        $max = 0;
                        foreach ($foundParticipants as $userdata)
                        {
                                for ($i = 0; $i <= $userdata->getLastPass(); $i++)
                                {
                                        if (is_object($userdata->getPass($i)))
                                        {
                                                $question =& $userdata->getPass($i)->getAnsweredQuestionByQuestionId($question_id);
                                                if (is_array($question))
                                                {
                                                        $answered++;
                                                        $reached += $question["reached"];
                                                        $max += $question["points"];
                                                }
                                        }
                                }
                        }
                        $percent = $max ? $reached/$max * 100.0 : 0;
                        $counter++;
                        $results["questions"][$question_id] = array(
                                $question_title, 
                                sprintf("%.2f", $answered ? $reached / $answered : 0) . " " . strtolower($this->lng->txt("of")) . " " . sprintf("%.2f", $answered ? $max / $answered : 0),
                                sprintf("%.2f", $percent) . "%",
                                $answered,
                                sprintf("%.2f", $answered ? $reached / $answered : 0),
                                sprintf("%.2f", $answered ? $max / $answered : 0),
                                $percent / 100.0
                        );
                }
                return $results;
        }
        
        function getXMLZip()
        {
                include_once("./Modules/Test/classes/class.ilTestExport.php");
                $test_exp = new ilTestExport($this, "xml");
                return $test_exp->buildExportFile();
        }
        
        public function getMailNotification()
        {
                return $this->mailnotification;
        }
        
        public function setMailNotification($a_notification)
        {
                $this->mailnotification = $a_notification;
        }
        
        public function sendSimpleNotification($active_id)
        {
                include_once "./Services/Mail/classes/class.ilMail.php";
                $mail = new ilMail(ANONYMOUS_USER_ID);

                $usr_data = $this->userLookupFullName(ilObjTest::_getUserIdFromActiveId($active_id));
                $message = new ilTemplate("tpl.il_as_tst_finish_notification_simple.html", TRUE, TRUE, "Modules/Test");
                $message->setVariable('TEXT_TEST_TITLE', $this->lng->txt('title'));
                $message->setVariable('VALUE_TEST_TITLE', $this->getTitle());
                $message->setVariable('TEXT_USER_NAME', $this->lng->txt('username'));
                $message->setVariable('VALUE_USER_NAME', $usr_data);
                $message->setVariable('TEXT_FINISH_TIME', $this->lng->txt('tst_finished'));
                ilDatePresentation::setUseRelativeDates(false);
                $message->setVariable('VALUE_FINISH_TIME', ilDatePresentation::formatDate(new ilDateTime(time(), IL_CAL_UNIX)));
                
                $res = $mail->sendMail(
                        ilObjUser::_lookupLogin($this->getOwner()), // to
                        "", // cc
                        "", // bcc
                        sprintf($this->lng->txt('tst_user_finished_test'), $this->getTitle()), // subject
                        $message->get(), // message
                        array(), // attachments
                        array('normal') // type
                );      
                global $ilLog; $ilLog->write("sending mail: " . $res);
        }
        

        public function sendAdvancedNotification($active_id)
        {
                include_once "./Services/Mail/classes/class.ilMail.php";
                $mail = new ilMail(ANONYMOUS_USER_ID);

                $usr_data = $this->userLookupFullName(ilObjTest::_getUserIdFromActiveId($active_id));
                $message = new ilTemplate("tpl.il_as_tst_finish_notification_simple.html", TRUE, TRUE, "Modules/Test");
                $message->setVariable('TEXT_TEST_TITLE', $this->lng->txt('title'));
                $message->setVariable('VALUE_TEST_TITLE', $this->getTitle());
                $message->setVariable('TEXT_USER_NAME', $this->lng->txt('username'));
                $message->setVariable('VALUE_USER_NAME', $usr_data);
                $message->setVariable('TEXT_FINISH_TIME', $this->lng->txt('tst_finished'));
                ilDatePresentation::setUseRelativeDates(false);
                $message->setVariable('VALUE_FINISH_TIME', ilDatePresentation::formatDate(new ilDateTime(time(), IL_CAL_UNIX)));

                include_once "./Modules/Test/classes/class.ilTestExport.php";
                $exportObj = new ilTestExport($this, "results");
                $file = $exportObj->exportToExcel($deliver = FALSE, 'active_id', $active_id, $passedonly = FALSE);
                include_once "./classes/class.ilFileDataMail.php";
                $fd = new ilFileDataMail(ANONYMOUS_USER_ID);
                $fd->copyAttachmentFile($file, "result_" . $active_id . ".xls");
                $file_names[] = "result_" . $active_id . ".xls";
                $result = $mail->sendMail(
                        ilObjUser::_lookupLogin($this->getOwner()), // to
                        "", // cc
                        "", // bcc
                        sprintf($this->lng->txt('tst_user_finished_test'), $this->getTitle()), // subject
                        $message->get(), // message
                        count($file_names) ? $file_names : array(), // attachments
                        array('normal') // type
                );
                if(count($file_names))
                {
                        $fd->unlinkFiles($file_names);
                        unset($fd);
                        @unlink($file);
                }
        }

        function createRandomSolutions($number)
        {
                global $ilDB;
                
                // 1. get a user
                $query = "SELECT usr_id FROM usr_data";
                $result = $ilDB->query($query);
                while ($data = $ilDB->fetchAssoc($result))
                {
                        $activequery = sprintf("SELECT user_fi FROM tst_active WHERE test_fi = %s AND user_fi = %s",
                                $ilDB->quote($this->getTestId()),
                                $ilDB->quote($data['usr_id'])
                        );
                        $activeresult = $ilDB->query($activequery);
                        if ($activeresult->numRows() == 0)
                        {
                                $user_id = $data['usr_id'];
                                if ($user_id != 13)
                                {
                                        include_once "./Modules/Test/classes/class.ilTestSession.php";
                                        $testSession = FALSE;
                                        $testSession = new ilTestSession();
                                        $testSession->setRefId($this->getRefId());
                                        $testSession->setTestId($this->getTestId());
                                        $testSession->setUserId($user_id);
                                        $testSession->saveToDb();
                                        $passes = ($this->getNrOfTries()) ? $this->getNrOfTries() : 10;
                                        $nr_of_passes = rand(1, $passes);
                                        $active_id = $testSession->getActiveId();
                                        for ($pass = 0; $pass < $nr_of_passes; $pass++)
                                        {
                                                include_once "./Modules/Test/classes/class.ilTestSequence.php";
                                                $testSequence = new ilTestSequence($active_id, $pass, $this->isRandomTest());
                                                if (!$testSequence->hasSequence())
                                                {
                                                        $testSequence->createNewSequence($this->getQuestionCount(), $shuffle);
                                                        $testSequence->saveToDb();
                                                }
                                                for ($seq = 1; $seq <= count($this->questions); $seq++)
                                                {
                                                        $question_id = $testSequence->getQuestionForSequence($seq);
                                                        $objQuestion = ilObjTest::_instanciateQuestion($question_id);
                                                        $objQuestion->createRandomSolution($testSession->getActiveId(), $pass);
                                                }
                                                if ($pass < $nr_of_passes - 1)
                                                {
                                                        $testSession->increasePass();
                                                        $testSession->setLastSequence(0);
                                                        $testSession->saveToDb();
                                                }
                                                else
                                                {
                                                        $this->setActiveTestSubmitted($user_id);
                                                }
                                        }
                                        $number--;
                                        if ($number == 0) return;
                                }
                        }
                }
        }
        
        public function getResultsForActiveId($active_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT * FROM tst_result_cache WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                if (!$result->numRows())
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        assQuestion::_updateTestResultCache($active_id);
                        $result = $ilDB->queryF("SELECT * FROM tst_result_cache WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                }
                $row = $ilDB->fetchAssoc($result);
                return $row;
                
        }

        function getRunDates()
        {
          global $ilLog;
          $metafiles = glob(ARCHIVE_HTML_DIR . "/*.metafile");
          $ilLog->write("Metafiles: ".print_r($metafiles,true));
          $testid = $this->getTestId();
          $dates = array();
          foreach ($metafiles as $metafile)
            {
              if (preg_match('/(\d\d\d\d-\d\d-\d\d)\_' . $testid . '/',$metafile, $matches))
                {
                  $dates[] = $matches[1];
                }
            }

          return $dates;
        }

        function getRunPackageDates()
        {
          $dates_in = $this->getRunDates();
          $dates_out = array();
          $testid = $this->getTestId();

          foreach($dates_in as $date)
            {
              if (file_exists(ARCHIVE_PDF_DIR . "/" . $date . '_' . $testid . '.zip'))
                {
                  $dates_out[] = $date;
                }
            }
          
          return $dates_out;
        }

        /* TODO: the following prototypes make it abundantly clear that I should really
           be developing an ilTestRun class */

        function hasRun($date)
        {
          // TODO: check $date syntax?

          $dates =  $this->getRunDates();
          return in_array($date, $dates, TRUE);
        }

        function hasRunPackage($date)
        {
          // TODO: check $date syntax?

          $dates = $this->getRunPackageDates();
          return in_array($date, $dates, TRUE);
        }
          

        function packageRun($date)
        {
          global $ilLog;

          if (!preg_match("/^\d\d\d\d-\d\d-\d\d$/", $date))
            {
              $ilLog->write("$date doesn't seem to be a date in YYYY-MM-DD format");
              return false;
            }

          // okay, first check if we have results for this date...
          if (!($this->hasRun($date)))
            {
              $ilLog->write("no run for $date");
              return false;
            }
          if ($this->hasRunPackage($date))
            {
              $ilLog->write("run for $date already packaged, returning");
              // returning true is okay - run has already been packaged
              return true;
            }
          $testid = $this->getTestId();  
          $archive_id = $date . "_" . $testid;

          $html_files = glob(ARCHIVE_HTML_DIR . "/" . $archive_id . "_*.html");
          if(empty($html_files))
            {
              $ilLog->write("No HTML archives found for run");
              return false;
            }
          
          // next up: create target directory for PDF versions of HTML run archives
          // TODO make paths configurable
          $pdfdir = ARCHIVE_PDF_DIR . "/" . $archive_id;
          if (file_exists($pdfdir))
            {
              if (!is_dir($pdfdir))
                {
                  /* quietly clobber (nobody has any business dropping files with
                   * archive ID names in the output directory)
                   */
                  if(!unlink($pdfdir))
                    {
                      $ilLog->write("Could not delete bogus file blocking location for PDF output directory ($pdfdir)");
                      return false;
                    }
                }
              else
                {
                  $ilLog->write("PDF output directory for run already exists");
                  return false;
                }
            }
          // TODO make mode, user and group configurable?
          $oldumask = umask(0);
          if (!mkdir($pdfdir, 0755))
            {
              $ilLog->write("Could not create PDF output directory for run");
              return false;
            }
          umask($oldumask);
          
          // let's get ourselves a PDF generator
          $pdfSetting = new ilSetting("pdf");
          include_once "./Services/PDF/classes/class.ilHTMLToPDF.php";
          $transformer = null;
          switch ($pdfSetting->get('html_to_pdf_method'))
            {
            case 'fop':
              include_once "./Services/PDF/classes/class.ilHTMLToPDFTransformerUsingFOP.php";
              $transformer = new ilHTMLtoPDFTransformerUsingFOP($pdf_file);
              $transformer->xsl = "./Modules/Test/xml/question2fo.xsl";
              break;
            case 'webkit':
              include_once "./Services/PDF/classes/class.ilHTMLToPDFTransformerUsingWebkit.php";
              $transformer = new ilHTMLtoPDFTransformerUsingWebkit($pdf_file);
              break;
            }
          if (is_object($transformer))
            {
              $generator = new ilHTMLtoPDF($transformer);
            }
          else
            {
              $ilLog->write("Could not generate PDF transformer");
              return false;
            }
          
          
          // create PDF files and key file lines
          $keylines = array();
          $pdf_filenames = array();
          $pdf_filelocalnames = array();
          foreach($html_files as $html_filename)
            {
              $html_file_parts = pathinfo($html_filename);
              $pdf_file_basename = $html_file_parts['filename'] . ".pdf";
              $pdf_filename = $pdfdir . "/" . $pdf_file_basename;
              $pdf_filelocalname = $archive_id . "/" . $pdf_file_basename;
              $ilLog->write("Converting HTML file ".$html_filename." into PDF file ".$pdf_filename);
              $generator->createPDFFileFromHTMLFile($html_filename, $pdf_filename);
              $keylines[] = (hash('sha512', file_get_contents($pdf_filename))." ".$pdf_file_basename);
              $pdf_filenames[] = $pdf_filename;
              $pdf_filelocalnames[] = $pdf_filelocalname;
            }
          
          // write key file
          $keyfilename = $pdfdir . "/" . $archive_id . ".key";
          $keyfilelocalname = $archive_id . "/" . $archive_id . ".key";
          $keyfile = fopen($keyfilename, 'w');
          if (!$keyfile)
            {
              $ilLog->write("Could not write key file");
              return false;
            }
          foreach ($keylines as $line)
            {
              fwrite($keyfile, $line . "\n");
            }
          fclose($keyfile);
          
          $metafile_basename = $archive_id . ".metafile";
          $metafile_source = ARCHIVE_HTML_DIR . "/" . $metafile_basename;
          $metafile_target = $pdfdir . "/" . $metafile_basename;
          $metafile_localname = $archive_id . "/" . $metafile_basename;
          if (!copy($metafile_source, $metafile_target))
            {
              $ilLog->write("Could not copy $metafile_source to $metafile_target");
              return false;
            }
          
          include_once "./Modules/Test/classes/class.ilTestExport.php";
          $exporter = new ilTestExport($this, "results");
          $excelfile = $exporter->exportToExcel($deliver = FALSE);
          $excelfile_target = $pdfdir . "/" . $archive_id . "_results.xls";
          $excelfile_localname = $archive_id . "/" . $archive_id . "_results.xls";
          if (!rename($excelfile, $excelfile_target))
            {
              $ilLog->write("Could not move $excelfile to $excelfile_target");
              return false;
            }

          // ****************************************************************************
          // BEGIN ugly code to get scoring template
          // ****************************************************************************
          $this->lng = new ilLanguage($_SESSION['lang']);
          $this->lng->loadLanguageModule("assessment");
          $scoring_template = $pdfdir . "/" . $archive_id . "_scoring.pdf";
          $scoring_template_localname = $archive_id . "/" . $archive_id . "_scoring.pdf";

          // the following is lifted straight from ilObjTestGUI::printobject()
          // ugly, but I wasn't able to figure out how to create an ilObjTestGUI
          // and tell it to print itself from outside an interactive HTTP session
          //$this->getQuestionsSubTabs();
          $template = new ilTemplate("tpl.il_as_tst_print_test_confirm.html", TRUE, TRUE, "Modules/Test");

          // $this->ctrl->setParameter($this, "pdf", "1");
          $template->setCurrentBlock("pdf_export");
          // $template->setVariable("PDF_URL", $this->ctrl->getLinkTarget($this, "print"));
          // $this->ctrl->setParameter($this, "pdf", "");
          $template->setVariable("PDF_TEXT", $this->lng->txt("pdf_export"));
          $template->setVariable("PDF_IMG_ALT", $this->lng->txt("pdf_export"));
          $template->setVariable("PDF_IMG_URL", ilUtil::getHtmlPath(ilUtil::getImagePath("application-pdf.png")));
          $template->parseCurrentBlock();
        
          $template->addCss(ilUtil::getStyleSheetLocation("output", "test_print.css", "Modules/Test"), "print");
                
          $print_date = date("c"); // ISO 8601 timestamp FTW
          $max_points= 0;
          $counter = 1;

          foreach ($this->questions as $question) 
            {           
              $template->setCurrentBlock("question");
              $question_gui = $this->createQuestionGUI("", $question);
              $template->setVariable("COUNTER_QUESTION", $counter.".");
              $template->setVariable("QUESTION_ID", $question_gui->object->getId());
              $template->setVariable("QUESTION_TITLE", ilUtil::prepareFormOutput($question_gui->object->getTitle()));
              if ($question_gui->object->getMaximumPoints() == 1)
                {
                  $template->setVariable("QUESTION_POINTS", $question_gui->object->getMaximumPoints() . " " . $this->lng->txt("point"));
                }
              else
                {
                  $template->setVariable("QUESTION_POINTS", $question_gui->object->getMaximumPoints() . " " . $this->lng->txt("points"));
                }
              $result_output = $question_gui->getSolutionOutput("", NULL, FALSE, TRUE, FALSE, $this->getShowSolutionFeedback());
              if (strlen($result_output) == 0) $result_output = $question_gui->getPreview(FALSE);
              $result_html = str_replace("src=\"../","src=\"" . ILIAS_HTTP_PATH . "/",$result_output);
              $template->setVariable("SOLUTION_OUTPUT", $result_html);
              $template->parseCurrentBlock("question");
              $counter ++;
              $max_points += $question_gui->object->getMaximumPoints();
            }
          
          // $template->setCurrentBlock("navigation_buttons");
          // $template->setVariable("BUTTON_PRINT", $this->lng->txt("print"));
          // $template->parseCurrentBlock();
          
          $template->setVariable("TITLE", ilUtil::prepareFormOutput($this->getTitle()));
          $template->setVariable("PRINT_TEST", ilUtil::prepareFormOutput($this->lng->txt("tst_print")));
          $template->setVariable("TXT_PRINT_DATE", ilUtil::prepareFormOutput($this->lng->txt("date")));
          $template->setVariable("VALUE_PRINT_DATE", ilUtil::prepareFormOutput($print_date));
          $template->setVariable("TXT_MAXIMUM_POINTS", ilUtil::prepareFormOutput($this->lng->txt("tst_maximum_points")));
          $template->setVariable("VALUE_MAXIMUM_POINTS", ilUtil::prepareFormOutput($max_points));
          
          $this->deliverPDFFromHTML($template->get(), $this->getTitle(), $scoring_template);
          // ****************************************************************************
          // END ugly code to get scoring template
          // ****************************************************************************

          // now create the archive
          $zip = new ZipArchive();
          $zipfilebasename = $archive_id . ".zip";
          $zipfilename =  ARCHIVE_PDF_DIR . "/" . $zipfilebasename;
          if (TRUE !== $zip->open($zipfilename, ZIPARCHIVE::CREATE))
            {
              $ilLog->write("Could not create ZIP file $zipfilename");
              return false;
            }
          for ($i=0; $i<count($pdf_filenames); $i++)
            {
              $zip->addFile($pdf_filenames[$i], $pdf_filelocalnames[$i]);
            }
          $zip->addFile($keyfilename, $keyfilelocalname);
          $zip->addFile($metafile_target, $metafile_localname);
          $zip->addFile($excelfile_target, $excelfile_localname);
          $zip->addFile($scoring_template, $scoring_template_localname);
          $zip->close();

          return true;
        }
        
        /* returns filename of run package for date, or '' if none exists */

        function getRunPackageFilename($date)
        {
          if ($this->hasRunPackage($date))
            {
              $testid = $this->getTestId();
              return ARCHIVE_PDF_DIR . "/" . $date . '_' . $testid . '.zip';
            }
          else
            {
              return '';
            }
        }

        function deleteRunPackage($date)
        {
          $packagefilename = $this->getRunPackageFilename($date);
          if ('' === $packagefilename)
            {
              return false;
            }
          else
            {
              unlink ($packagefilename);

              // cut suffix off to make directory name
              $pdfdirname = substr($packagefilename, 0, -4);
              // recursively delete directory and contents
              // I can't believe there is no library function for this. PHP FTW.
              $diriterator = new RecursiveDirectoryIterator($pdfdirname);
              $diriterator->setFlags(RecursiveDirectoryIterator::SKIP_DOTS);
              $iterator =
                new RecursiveIteratorIterator($diriterator,
                                              RecursiveIteratorIterator::CHILD_FIRST);
              foreach ($iterator as $file)
                {
                  if ($file->isDir())
                    {
                      rmdir($file->getPathname());
                    }
                  else
                    {
                      unlink($file->getPathname());
                    }
                }
              rmdir($pdfdirname);
              
              // TODO there should be some kind of error handling
              return true;
            }
        }

        function obliterateRun($date)
        {
                  global $ilLog;

          if (!preg_match("/^\d\d\d\d-\d\d-\d\d$/", $date))
            {
              $ilLog->write("$date doesn't seem to be a date in YYYY-MM-DD format");
              return false;
            }

          // okay, first check if we have results for this date...
          if (!($this->hasRun($date)))
            {
              $ilLog->write("no run for $date");
              return false;
            }
          if ($this->hasRunPackage($date))
            {
              $ilLog->write("run for $date has package, deleting it");
              $this->deleteRunPackage($date);
            }
          $testid = $this->getTestId();  
          $archive_id = $date . "_" . $testid;

          $files_to_delete = glob(ARCHIVE_HTML_DIR . "/" . $archive_id . "_*.html");
          $files_to_delete[] = ARCHIVE_HTML_DIR . "/" . $archive_id . ".metafile";
          if(empty($files_to_delete))
            {
              $ilLog->write("No HTML archives or metafile found for run");
              return false;
            }
          else
            {
              foreach ($files_to_delete as $file_to_delete)
                {
                  unlink($file_to_delete);
                }
            }
          return true;
        }
       
        public function getMailNotificationType()
        {
                if ($this->mailnottype == 1)
                {
                        return $this->mailnottype;
                }
                else
                {
                        return 0;
                }
        }
        
        public function setMailNotificationType($a_type)
        {
                if ($a_type == 1)
                {
                        $this->mailnottype = 1;
                }
                else
                {
                        $this->mailnottype = 0;
                }
        }
        
        public function getExportSettings()
        {
                if ($this->exportsettings)
                {
                        return $this->exportsettings;
                }
                else
                {
                        return 0;
                }
        }
        
        public function setExportSettings($a_settings)
        {
                if ($a_settings)
                {
                        $this->exportsettings = $a_settings;
                }
                else
                {
                        $this->exportsettings = 0;
                }
        }
        
        public function getExportSettingsSingleChoiceShort()
        {
                if (($this->exportsettings & 1) > 0)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }
        
        public function setExportSettingsSingleChoiceShort($a_settings)
        {
                if ($a_settings)
                {
                        $this->exportsettings = $this->exportsettings | 1;
                }
                else
                {
                        if ($this->getExportSettingsSingleChoiceShort())
                        {
                                $this->exportsettings = $this->exportsettings ^ 1;
                        }
                }
        }

        public function getExportSettingsRespectShuffle()
        {
                if (($this->exportsettings & 2) > 0)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }
        
        public function setExportSettingsRespectShuffle($a_settings)
        {
                if ($a_settings)
                {
                        $this->exportsettings = $this->exportsettings | 2;
                }
                else
                {
                        if ($this->getExportSettingsRespectShuffle())
                        {
                                $this->exportsettings = $this->exportsettings ^ 2;
                        }
                }
        }
        
        public function getQuestions()
        {
                return $this->questions;
        }
        
        public function getExtraTime($active_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT additionaltime FROM tst_addtime WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                if ($result->numRows() > 0)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row['additionaltime'];
                }
                return 0;
        }

        public function addExtraTime($active_id, $minutes)
        {
                global $ilDB;
                
                $participants = array();
                if ($active_id == 0)
                {
                        $result = $ilDB->queryF("SELECT active_id FROM tst_active WHERE test_fi = %s",
                                array('integer'),
                                array($this->getTestId())
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                array_push($participants, $row['active_id']);
                        }
                }
                else
                {
                        array_push($participants, $active_id);
                }
                foreach ($participants as $active_id)
                {
                        $result = $ilDB->queryF("SELECT active_fi FROM tst_addtime WHERE active_fi = %s",
                                array('integer'),
                                array($active_id)
                        );
                        if ($result->numRows() > 0)
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_addtime WHERE active_fi = %s",
                                        array('integer'),
                                        array($active_id)
                                );
                        }

                        $result = $ilDB->manipulateF("UPDATE tst_active SET tries = %s, submitted = %s, submittimestamp = %s WHERE active_id = %s",
                                array('integer','integer','timestamp','integer'),
                                array(0, 0, NULL, $active_id)
                        );

                        $result = $ilDB->manipulateF("INSERT INTO tst_addtime (active_fi, additionaltime, tstamp) VALUES (%s, %s, %s)",
                                array('integer','integer','integer'),
                                array($active_id, $minutes, time())
                        );

                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction(sprintf($this->lng->txtlng("assessment", "log_added_extratime", ilObjAssessmentFolder::_getLogLanguage()), $minutes, $active_id));
                        }
                }
        }
        
        public function recalculateSolutions()
        {
                $participants = $this->getCompleteEvaluationData(false)->getParticipants();
                if (is_array($participants))
                {
                        require_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        foreach ($participants as $active_id => $userdata)
                        {
                                if (is_object($userdata) && is_array($userdata->getPasses()))
                                {
                                        $passes = $userdata->getPasses();
                                        foreach ($passes as $pass => $passdata)
                                        {
                                                if (is_object($passdata))
                                                {
                                                        $questions = $passdata->getAnsweredQuestions();
                                                        if (is_array($questions))
                                                        {
                                                                foreach ($questions as $questiondata)
                                                                {
                                                                        $question_gui = $this->createQuestionGUI("", $questiondata['id']);
                                                                        if (is_object($question_gui))
                                                                        {
                                                                                $reached = $question_gui->object->calculateReachedPoints($active_id, $pass);
                                                                                assQuestion::_setReachedPoints($active_id, $questiondata['id'], $reached, $question_gui->object->getMaximumPoints(), $pass, false, true);
                                                                        }
                                                                }
                                                        }
                                                }
                                        }
                                }
                        }
                }
        }

        public function getShowSerial()
        {
                return ($this->show_serial) ? 1 : 0;
        }

        public function setShowSerial($a_value = 1)
        {
                switch ($a_value)
                {
                        case 1:
                                $this->show_serial = 1;
                                break;
                        default:
                                $this->show_serial = 0;
                                break;
                }
        }
        
        public function getSerial()
        {
                return $this->getTestSession()->getActiveId();
        }
        
} // END class.ilObjTest

?>