assessment/classes/class.ilObjTest.php

Go to the documentation of this file.

<?php
/*
        +-----------------------------------------------------------------------------+
        | ILIAS open source                                                           |
        +-----------------------------------------------------------------------------+
        | Copyright (c) 1998-2001 ILIAS open source, University of Cologne            |
        |                                                                             |
        | This program is free software; you can redistribute it and/or               |
        | modify it under the terms of the GNU General Public License                 |
        | as published by the Free Software Foundation; either version 2              |
        | of the License, or (at your option) any later version.                      |
        |                                                                             |
        | This program is distributed in the hope that it will be useful,             |
        | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
        | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
        | GNU General Public License for more details.                                |
        |                                                                             |
        | You should have received a copy of the GNU General Public License           |
        | along with this program; if not, write to the Free Software                 |
        | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
        +-----------------------------------------------------------------------------+
*/

require_once "./classes/class.ilObject.php";
require_once "./assessment/classes/class.assMarkSchema.php";
//require_once "./classes/class.ilMetaData.php";
require_once "./assessment/classes/class.assQuestion.php";
require_once "./assessment/classes/class.assClozeTest.php";
require_once "./assessment/classes/class.assImagemapQuestion.php";
require_once "./assessment/classes/class.assJavaApplet.php";
require_once "./assessment/classes/class.assMatchingQuestion.php";
require_once "./assessment/classes/class.assMultipleChoice.php";
require_once "./assessment/classes/class.assOrderingQuestion.php";
require_once "./classes/class.ilObjAssessmentFolder.php";
require_once "./classes/class.ilSearch.php";


define("TEST_FIXED_SEQUENCE", 0);
define("TEST_POSTPONE", 1);

define("REPORT_AFTER_QUESTION", 0);
define("REPORT_AFTER_TEST", 1);

define("TYPE_ASSESSMENT", "1");
define("TYPE_SELF_ASSESSMENT", "2");
define("TYPE_NAVIGATION_CONTROLLING", "3");
define("TYPE_ONLINE_TEST", "4");

define("INVITATION_OFF",0);
define("INVITATION_ON",1);

define("COUNT_PARTIAL_SOLUTIONS", 0);
define("COUNT_CORRECT_SOLUTIONS", 1);

define("SCORE_ZERO_POINTS_WHEN_UNANSWERED", 0);
define("SCORE_STANDARD_SCORE_SYSTEM", 1);

class ilObjTest extends ilObject
{
  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 $reporting_date;

  var $evaluation_data;

  var $test_type;

  var $nr_of_tries;

  var $processing_time;
        
        var $enable_processing_time;

  var $starting_time;
  
  var $ending_time;

  var $ects_output;

  var $ects_fx;

        var $test_types;

  var $ects_grades;

        var $random_test;

        var $random_question_count;

        var $count_system;
        
        var $mc_scoring;

        function ilObjTest($a_id = 0,$a_call_by_reference = true)
        {
                global $ilUser;
                $this->type = "tst";
                $this->mark_schema = new ASS_MarkSchema();
                //$this->ilObject($a_id, $a_call_by_reference);
                $this->retrieveTestTypes();
                $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->reporting_date = "";
                $this->nr_of_tries = 0;
                $this->starting_time = "";
                $this->ending_time = "";
                $this->processing_time = "00:00:00";
                $this->enable_processing_time = "0";
                $this->test_type = TYPE_ASSESSMENT;
                $this->ects_output = 0;
                $this->ects_fx = "";
                $this->random_test = 0;
                $this->random_question_count = "";
                $this->count_system = COUNT_PARTIAL_SOLUTIONS;
                $this->mc_scoring = SCORE_ZERO_POINTS_WHEN_UNANSWERED; 
                global $lng;
                $lng->loadLanguageModule("assessment");
                $this->mark_schema->create_simple_schema($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
                );
/*
                if ($a_id == 0)
                {
                        $new_meta =& new ilMetaData();
                        $this->assignMetaData($new_meta);
                }
*/
                $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()
        {
                $this->updateMetaData();
                if (!parent::update())
                {
                        return false;
                }

                // put here object specific stuff
                
                return true;
        }
        
        function createReference() {
                $result = parent::createReference();
                $this->saveToDb();
                return $result;
        }
        
        function getCallingScript()
        {
                return "test.php";
        }
        
        function read($a_force_db = false)
        {
                parent::read($a_force_db);
                $this->loadFromDb();
//              $this->meta_data =& new ilMetaData($this->getType(), $this->getId());
        }

        function ilClone($a_parent_ref)
        {               
                global $rbacadmin;

                // always call parent ilClone function first!!
                $new_ref_id = parent::ilClone($a_parent_ref);
                
                // get object instance of ilCloned object
                //$newObj =& $this->ilias->obj_factory->getInstanceByRefId($new_ref_id);

                // create a local role folder & default roles
                //$roles = $newObj->initDefaultRoles();

                // ...finally assign role to creator of object
                //$rbacadmin->assignUser($roles[0], $newObj->getOwner(), "n");          

                // always destroy objects in ilClone method because ilClone() is recursive and creates instances for each object in subtree!
                //unset($newObj);

                // ... and finally always return new reference ID!!
                return $new_ref_id;
        }

        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()
        {
                $query = sprintf("SELECT active_id FROM tst_active WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                $active_array = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        array_push($active_array, $row["active_id"]);
                }

                $query = sprintf("DELETE FROM tst_active WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                if (count($active_array))
                {
                        foreach ($active_array as $active_id)
                        {
                                $query = sprintf("DELETE FROM tst_times WHERE active_fi = %s",
                                        $this->ilias->db->quote($active_id)
                                );
                                $result = $this->ilias->db->query($query);
                        }
                }

                $query = sprintf("DELETE FROM tst_mark WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("SELECT question_fi FROM tst_test_question WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->removeQuestion($row->question_fi);
                }

                $query = sprintf("DELETE FROM tst_tests WHERE test_id = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM tst_test_random WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                $query = sprintf("DELETE FROM tst_test_random_question WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                $this->removeAllTestEditings();

                $query = sprintf("DELETE FROM tst_test_question WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);

                // delete export files
                $tst_data_dir = ilUtil::getDataDir()."/tst_data";
                $directory = $tst_data_dir."/tst_".$this->getId();
                if (is_dir($directory))
                {
                        $directory = escapeshellarg($directory);
                        exec("rm -rf $directory");
                }
        }

        function initDefaultRoles()
        {
                global $rbacadmin;
                
                // create a local role folder
                //$rfoldObj = $this->createRoleFolder("Local roles","Role Folder of forum obj_no.".$this->getId());

                // create moderator role and assign role to rolefolder...
                //$roleObj = $rfoldObj->createRole("Moderator","Moderator of forum obj_no.".$this->getId());
                //$roles[] = $roleObj->getId();

                //unset($rfoldObj);
                //unset($roleObj);

                return $roles ? $roles : 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()
        {
                $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()
        {
                $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)?__)*[0-9]+\.[a-z]{1,3}\$", $entry))
                        {
                                $file[] = $entry;
                        }
                }

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

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

                return $file;
        }

        
        function _createImportDirectory()
        {
                global $ilias;
                
                $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);
                }
        }

        function _getImportDirectory()
        {
                $import_dir = ilUtil::getDataDir()."/tst_data/tst_import";
                if(@is_dir($import_dir))
                {
                        return $import_dir;
                }
                else
                {
                        return false;
                }
        }

        function createImportDirectory()
        {
                $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()
        {
                $import_dir = ilUtil::getDataDir()."/tst_data/tst_import";
                if(@is_dir($import_dir))
                {
                        return $import_dir;
                }
                else
                {
                        return false;
                }
        }

        
        function retrieveTestTypes()
        {
                global $ilDB;

                $this->test_types = array();
                $query = "SELECT * FROM tst_test_type ORDER BY test_type_id";
                $result = $ilDB->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->test_types[$row->test_type_id] = $row->type_tag;
                }
        }
        
  function testTitleExists($title) 
        {
    $query = sprintf("SELECT * FROM object_data WHERE title = %s AND type = %s",
      $this->ilias->db->quote($title),
                        $this->ilias->db->quote("tst")
    );
    $result = $this->ilias->db->query($query);
    if (strcmp(strtolower(get_class($result)), db_result) == 0) {
      if ($result->numRows() == 1) {
        return TRUE;
      }
    }
    return FALSE;
  }
  
  function duplicate() 
        {
    $clone = $this;
    $clone->set_id(-1);
    $counter = 2;
    while ($this->testTitleExists($this->get_title() . " ($counter)")) {
      $counter++;
    }
    $clone->set_title($this->get_title() . " ($counter)");
    $clone->set_owner($this->ilias->account->id);
    $clone->setAuthor($this->ilias->account->fullname);
    $clone->saveToDb($this->ilias->db);
    // Duplicate questions
    $query = sprintf("SELECT * FROM tst_test_question WHERE test_fi = %s",
      $this->ilias->db->quote($this->getId())
    );
    $result = $this->ilias->db->query($query);
    while ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
      $query = sprintf("INSERT INTO tst_test_question (test_question_id, test_fi, question_fi, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
        $this->ilias->db->quote($clone->getId()),
        $this->ilias->db->quote($data->question_fi),
        $this->ilias->db->quote($data->sequence)
      );
      $insert_result = $this->ilias->db->query($query);
    }
  }
  
        function isComplete()
        {
                if (($this->getTitle()) and ($this->author) and (count($this->mark_schema->mark_steps)) and (count($this->questions)))
                {
                        return true;
                } 
                        else 
                {
                        if ($this->isRandomTest())
                        {
                                $arr = $this->getRandomQuestionpools();
                                if (count($arr) && ($this->getRandomQuestionCount() > 0))
                                {
                                        return true;
                                }
                                $count = 0;
                                foreach ($arr as $array)
                                {
                                        $count += $array["count"];
                                }
                                if ($count)
                                {
                                        return true;
                                }
                        }
                        return false;
                }
        }

        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";
                        }
      $query = sprintf("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",
                                $ilDB->quote("$ects_output"),
                                $ilDB->quote($ects_a . ""),
                                $ilDB->quote($ects_b . ""),
                                $ilDB->quote($ects_c . ""),
                                $ilDB->quote($ects_d . ""),
                                $ilDB->quote($ects_e . ""),
        $fx_support,
                                $this->getTestId()
      );
      $result = $ilDB->query($query);
                        $this->ects_output = $ects_output;
                        $this->ects_fx = $fx_support;
                }
        }

        function saveCompleteStatus() 
        {
    global $ilias;
                
    $db =& $ilias->db;
                $complete = 0;
                if ($this->isComplete()) {
                        $complete = 1;
                }
    if ($this->test_id > 0) {
      $query = sprintf("UPDATE tst_tests SET complete = %s WHERE test_id = %s",
                                $db->quote("$complete"),
        $db->quote($this->test_id)
      );
      $result = $db->query($query);
                }
        }

  function saveToDb($properties_only = FALSE)
  {
    global $ilias;
    $db =& $ilias->db;
                $complete = 0;
                if ($this->isComplete()) {
                        $complete = 1;
                }
                $ects_fx = "NULL";
                if (preg_match("/\d+/", $this->ects_fx))
                {
                        $ects_fx = $this->ects_fx;
                }
                $random_question_count = "NULL";
                if ($this->random_question_count > 0)
                {
                        $random_question_count = $this->ilias->db->quote($this->random_question_count . "");
                }
    if ($this->test_id == -1) {
      // Create new dataset
      $now = getdate();
      $created = sprintf("%04d%02d%02d%02d%02d%02d", $now['year'], $now['mon'], $now['mday'], $now['hours'], $now['minutes'], $now['seconds']);
      $query = sprintf("INSERT INTO tst_tests (test_id, obj_fi, author, test_type_fi, introduction, sequence_settings, score_reporting, nr_of_tries, processing_time, enable_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, created, TIMESTAMP) VALUES (NULL, %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, NULL)",
                                $db->quote($this->getId() . ""),
        $db->quote($this->author . ""),
        $db->quote($this->test_type . ""),
        $db->quote($this->introduction . ""), 
        $db->quote($this->sequence_settings . ""),
        $db->quote($this->score_reporting . ""),
        $db->quote(sprintf("%d", $this->nr_of_tries) . ""),
        $db->quote($this->processing_time . ""),
                                $db->quote("$this->enable_processing_time"),
        $db->quote($this->reporting_date . ""),
        $db->quote($this->starting_time . ""),
        $db->quote($this->ending_time . ""),
                                $db->quote("$complete"),
                                $db->quote($this->ects_output . ""),
                                $db->quote($this->ects_grades["A"] . ""),
                                $db->quote($this->ects_grades["B"] . ""),
                                $db->quote($this->ects_grades["C"] . ""),
                                $db->quote($this->ects_grades["D"] . ""),
                                $db->quote($this->ects_grades["E"] . ""),
                                $ects_fx,
                                $db->quote(sprintf("%d", $this->random_test) . ""),
                                $random_question_count,
                                $db->quote($this->count_system . ""),
                                $db->quote($this->mc_scoring . ""),
        $db->quote($created)
      );
      
                        include_once ("./classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $this->logAction($this->lng->txtlng("assessment", "log_create_new_test", ilObjAssessmentFolder::_getLogLanguage()));
                        }
      $result = $db->query($query);
      if ($result == DB_OK) {
        $this->test_id = $this->ilias->db->getLastInsertId();
      }
    } else {
      // Modify existing dataset
                        $oldrow = array();
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $query = sprintf("SELECT * FROM tst_tests WHERE test_id = %s",
                $db->quote($this->test_id)
                                );
                                $result = $db->query($query);
                                if ($result->numRows() == 1)
                                {
                                        $oldrow = $result->fetchRow(DB_FETCHMODE_ASSOC);
                                }
                        }
      $query = sprintf("UPDATE tst_tests SET author = %s, test_type_fi = %s, introduction = %s, sequence_settings = %s, score_reporting = %s, nr_of_tries = %s, processing_time = %s, enable_processing_time = %s, reporting_date = %s, starting_time = %s, ending_time = %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, complete = %s, count_system = %s, mc_scoring = %s WHERE test_id = %s",
        $db->quote($this->author . ""), 
        $db->quote($this->test_type . ""), 
        $db->quote($this->introduction . ""), 
        $db->quote($this->sequence_settings . ""), 
        $db->quote($this->score_reporting . ""), 
        $db->quote(sprintf("%d", $this->nr_of_tries) . ""), 
        $db->quote($this->processing_time . ""),
                                $db->quote("$this->enable_processing_time"),
        $db->quote($this->reporting_date . ""), 
        $db->quote($this->starting_time . ""), 
        $db->quote($this->ending_time . ""), 
                                $db->quote($this->ects_output . ""),
                                $db->quote($this->ects_grades["A"] . ""),
                                $db->quote($this->ects_grades["B"] . ""),
                                $db->quote($this->ects_grades["C"] . ""),
                                $db->quote($this->ects_grades["D"] . ""),
                                $db->quote($this->ects_grades["E"] . ""),
                                $ects_fx,
                                $db->quote(sprintf("%d", $this->random_test) . ""),
                                $db->quote("$complete"),
                                $db->quote($this->count_system . ""),
                                $db->quote($this->mc_scoring . ""),
        $db->quote($this->test_id)
      );
      $result = $db->query($query);
                        include_once ("./classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                $query = sprintf("SELECT * FROM tst_tests WHERE test_id = %s",
                $db->quote($this->test_id)
                                );
                                $logresult = $db->query($query);
                                $newrow = array();
                                if ($logresult->numRows() == 1)
                                {
                                        $newrow = $logresult->fetchRow(DB_FETCHMODE_ASSOC);
                                }
                                $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)
                                {
                                        $changes = $this->lng->txtlng("assessment", "log_no_test_fields_changed", ilObjAssessmentFolder::_getLogLanguage());
                                }
                                $this->logAction($this->lng->txtlng("assessment", "log_modified_test", ilObjAssessmentFolder::_getLogLanguage()) . " [".$changes."]");
                        }
    }
                if (!$properties_only)
                {
                        if ($result == DB_OK) {
                                if (!$this->isRandomTest())
                                {
                                        $this->saveQuestionsToDb();
                                }
                                $this->mark_schema->saveToDb($this->test_id);
                        }
                }
  }

        function saveQuestionsToDb() 
        {
                $oldquestions = array();
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $query = sprintf("SELECT question_fi FROM tst_test_question WHERE test_fi = %s ORDER BY sequence",
                                $this->ilias->db->quote($this->getTestId())
                        );
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows() > 0)
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        array_push($oldquestions, $row["question_fi"]);
                                }
                        }
                }
                
                // delete existing category relations
    $query = sprintf("DELETE FROM tst_test_question WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                // create new category relations
                foreach ($this->questions as $key => $value) {
                        $query = sprintf("INSERT INTO tst_test_question (test_question_id, test_fi, question_fi, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($this->getTestId() . ""),
                                $this->ilias->db->quote($value . ""),
                                $this->ilias->db->quote($key . "")
                        );
                        $result = $this->ilias->db->query($query);
                }
                include_once ("./classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $query = sprintf("SELECT question_fi FROM tst_test_question WHERE test_fi = %s ORDER BY sequence",
                                $this->ilias->db->quote($this->getTestId())
                        );
                        $result = $this->ilias->db->query($query);
                        $newquestions = array();
                        if ($result->numRows() > 0)
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        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);
                                }
                        }
                }
        }

        function saveRandomQuestion($question_id) 
        {
                global $ilUser;
                
                $query = sprintf("SELECT test_random_question_id FROM tst_test_random_question WHERE test_fi = %s AND user_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($ilUser->id . "")
                );
                $result = $this->ilias->db->query($query);
                
                $query = sprintf("INSERT INTO tst_test_random_question (test_random_question_id, test_fi, user_fi, question_fi, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, NULL)",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($ilUser->id . ""),
                        $this->ilias->db->quote($question_id . ""),
                        $this->ilias->db->quote(($result->numRows()+1) . "")
                );
                $result = $this->ilias->db->query($query);
        }

        function saveRandomQuestionCount($total_questions = "NULL")
        {
                if (strcmp($total_questions, "NULL") != 0)
                {
                        $this->setRandomQuestionCount($total_questions);
                        $total_questions = $this->ilias->db->quote($total_questions);
                }
                $query = sprintf("UPDATE tst_tests SET random_question_count = %s WHERE test_id = %s",
                        $total_questions,
                        $this->ilias->db->quote($this->getTestId() . "")
                );
                $result = $this->ilias->db->query($query);
        }

        function saveRandomQuestionpools($qpl_array) 
        {
                // delete existing random questionpools
    $query = sprintf("DELETE FROM tst_test_random WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                // create new random questionpools
                foreach ($qpl_array as $key => $value) {
                        if ($value["qpl"] > -1)
                        {
                                $count = ilObjQuestionPool::_getQuestionCount($value["qpl"]);
                                if ($value["count"] > $count)
                                {
                                        $value["count"] = $count;
                                }
                                $query = sprintf("INSERT INTO tst_test_random (test_random_id, test_fi, questionpool_fi, num_of_q, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                        $this->ilias->db->quote($this->getTestId() . ""),
                                        $this->ilias->db->quote($value["qpl"] . ""),
                                        $this->ilias->db->quote(sprintf("%d", $value["count"]) . "")
                                );
                                $result = $this->ilias->db->query($query);
                        }
                }
        }

        function &getRandomQuestionpools() 
        {
                $qpls = array();
                $counter = 0;
                $query = sprintf("SELECT * FROM tst_test_random WHERE test_fi = %s ORDER BY test_random_id",
                        $this->ilias->db->quote($this->getTestId() . "")
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $qpls[$counter] = array(
                                        "index" => $counter,
                                        "count" => $row["num_of_q"],
                                        "qpl"   => $row["questionpool_fi"]
                                );
                                $counter++;
                        }
                }
                return $qpls;
        }

        function loadFromDb()
        {
                $db = $this->ilias->db;

                $query = sprintf("SELECT * FROM tst_tests WHERE obj_fi = %s",
                $db->quote($this->getId())
                        );
                $result = $db->query($query);
                if (strcmp(strtolower(get_class($result)), db_result) == 0)
                {
                        if ($result->numRows() == 1)
                        {
                                $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
                                $this->test_id = $data->test_id;
                                $this->author = $data->author;
                                $this->test_type = $data->test_type_fi;
                                $this->introduction = $data->introduction;
                                $this->sequence_settings = $data->sequence_settings;
                                $this->score_reporting = $data->score_reporting;
                                $this->nr_of_tries = $data->nr_of_tries;
                                $this->processing_time = $data->processing_time;
                                $this->enable_processing_time = $data->enable_processing_time;
                                $this->reporting_date = $data->reporting_date;
                                $this->starting_time = $data->starting_time;
                                $this->ending_time = $data->ending_time;
                                $this->ects_output = $data->ects_output;
                                $this->ects_grades = array(
                                        "A" => $data->ects_a,
                                        "B" => $data->ects_b,
                                        "C" => $data->ects_c,
                                        "D" => $data->ects_d,
                                        "E" => $data->ects_e
                                );
                                $this->ects_fx = $data->ects_fx;
                                $this->random_test = $data->random_test;
                                $this->random_question_count = $data->random_question_count;
                                $this->mark_schema->flush();
                                $this->mark_schema->loadFromDb($this->test_id);
                                $this->count_system = $data->count_system;
                                $this->mc_scoring = $data->mc_scoring;
                                $this->loadQuestions();
                        }
                }
        }

        function loadQuestions($user_id = "") 
        {
                global $ilUser;
                
    $db = $this->ilias->db;
                $this->questions = array();
                if (strcmp($user_id, "") == 0)
                {
                        $user_id = $ilUser->id;
                }
                if ($this->isRandomTest())
                {
                        $query = sprintf("SELECT tst_test_random_question.* FROM tst_test_random_question, qpl_questions WHERE tst_test_random_question.test_fi = %s AND tst_test_random_question.user_fi = %s AND qpl_questions.question_id = tst_test_random_question.question_fi ORDER BY sequence",
                                $db->quote($this->test_id . ""),
                                $db->quote($user_id . "")
                        );
                }
                else
                {
                        $query = sprintf("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",
                                $db->quote($this->test_id . "")
                        );
                }
                $result = $db->query($query);
                $index = 1;
                while ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
                        $this->questions[$index++] = $data->question_fi;
                }
        }

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

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

  function getAuthor() 
        {
    return $this->author;
  }

  function isRandomTest() 
        {
    return $this->random_test;
  }

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

  function getIntroduction() 
        {
    return $this->introduction;
  }

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

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

  function setTestType($type = TYPE_ASSESSMENT) 
  {
    $this->test_type = $type;
  }

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

  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;
                        $this->score_reporting = REPORT_AFTER_TEST;
                }
  }

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

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

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

  function _getCountSystem($test_id) 
        {
                global $ilDB;
                $query = sprintf("SELECT count_system FROM tst_tests WHERE test_id = %s",
                        $ilDB->quote($test_id)
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        return $row["count_system"];
                }
    return FALSE;
  }
        
  function getMCScoring() 
        {
    return $this->mc_scoring;
  }

  function _getMCScoring($test_id) 
        {
                global $ilDB;
                $query = sprintf("SELECT  mc_scoring FROM tst_tests WHERE test_id = %s",
                        $ilDB->quote($test_Id)
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        return $row["mc_scoring"];
                }
    return FALSE;
  }

  function getTestType() 
        {
    return $this->test_type;
  }

  function getReportingDate() 
        {
    return $this->reporting_date;
  }

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

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

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

  function getStartingTime() 
        {
    return $this->starting_time;
  }

  function getEndingTime() 
        {
    return $this->ending_time;
  }

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

  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 setStartingTime($starting_time = "") 
        {
    $this->starting_time = $starting_time;
  }

  function setEndingTime($ending_time = "") 
        {
    $this->ending_time = $ending_time;
  }
  
  function setCountSystem($a_count_system = COUNT_PARTIAL_SOLUTIONS) 
        {
    $this->count_system = $a_count_system;
  }
  
  function setMCScoring($a_mc_scoring = SCORE_ZERO_POINTS_WHEN_UNANSWERED) 
        {
    $this->mc_scoring = $a_mc_scoring;
  }
  
        function removeQuestion($question_id) 
        {
                $question = new ASS_Question();
                include_once ("./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();
        }
        
        function clearEvalSelectedUsers()
        {
                $query = sprintf("DELETE FROM tst_eval_users WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
        }
        
        function clearEvalSelectedGroups()
        {
                $query = sprintf("DELETE FROM tst_eval_groups WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
        }

        function removeAllTestEditings($question_id = "") 
        {
                // remove test_active entries, because test has changed
                $this->deleteActiveTests();
                // remove selected users/groups
                $this->clearEvalSelectedUsers();
                $this->clearEvalSelectedGroups();
                
                // remove the question from tst_solutions
                if ($question_id) 
                {
                        $query = sprintf("DELETE FROM tst_solutions WHERE test_fi = %s AND question_fi = %s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($question_id)
                        );
                        $query2 = sprintf("DELETE FROM tst_active_qst_sol_settings WHERE test_fi = %s AND question_fi=%s",
                                $this->ilias->db->quote($this->getTestId()),                            
                                $this->ilias->db->quote($question_id)
                        );
                        $query3 = sprintf("DELETE FROM tst_test_result WHERE test_fi = %s AND question_fi = %s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($question_id)
                        );
                } else {
                        $query = sprintf("DELETE FROM tst_solutions WHERE test_fi = %s",
                                $this->ilias->db->quote($this->getTestId())
                        );
                        $query2 = sprintf("DELETE FROM tst_active_qst_sol_settings WHERE test_fi = %s",
                                $this->ilias->db->quote($this->getTestId())                                                     
                        );                      
                        $query3 = sprintf("DELETE FROM tst_test_result WHERE test_fi = %s",
                                $this->ilias->db->quote($this->getTestId())
                        );
                }
                $result = $this->ilias->db->query($query);
                $result = $this->ilias->db->query($query2);
                $result = $this->ilias->db->query($query3);

                if ($this->isRandomTest())
                {
                        $query = sprintf("DELETE FROM tst_test_random_question WHERE test_fi = %s",
                                $this->ilias->db->quote($this->getTestId())
                        );
                        $result = $this->ilias->db->query($query);
                }
                include_once ("./classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction($this->lng->txtlng("assessment", "log_user_data_removed", ilObjAssessmentFolder::_getLogLanguage()));
                }
        }
        
        function deleteActiveTests() 
        {
                $query = sprintf("DELETE FROM tst_active WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
        }
        
        function deleteResults($user_id = "",$a_delete_active = false) 
        {
                if ($user_id) {
                        $query = sprintf("DELETE FROM tst_solutions WHERE test_fi = %s AND user_fi = %s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($user_id)
                        );
                        $result = $this->ilias->db->query($query);
                        $query = sprintf("DELETE FROM tst_test_result WHERE test_fi = %s AND user_fi = %s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($user_id)
                        );
                        $result = $this->ilias->db->query($query);
                        $sequence_arr = array_flip($this->questions);
                        $sequence = join($sequence_arr, ",");
                        $query = sprintf("UPDATE tst_active SET sequence = %s, lastindex = %s WHERE test_fi = %s and user_fi = %s",
                                $this->ilias->db->quote($sequence),
                                $this->ilias->db->quote("1"),
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($user_id)
                        );
                        $result = $this->ilias->db->query($query);
                        
                        $query = sprintf("DELETE FROM tst_active_qst_sol_settings WHERE test_fi = %s AND user_fi = %s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($user_id)
                        );
                        $result = $this->ilias->db->query($query);
                        

                        if($a_delete_active)
                        {
                                $query = "DELETE FROM tst_active ".
                                        "WHERE user_fi = '".$user_id."' ".
                                        "AND test_fi = '".$this->getTestId()."'";

                                $this->ilias->db->query($query);
                        }
                }
        }
        
        function questionMoveUp($question_id) 
        {
                // Move a question up in sequence
                $query = sprintf("SELECT * FROM tst_test_question WHERE test_fi=%s AND question_fi=%s",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);
                $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
                if ($data->sequence > 1) {
                        // OK, it's not the top question, so move it up
                        $query = sprintf("SELECT * FROM tst_test_question WHERE test_fi=%s AND sequence=%s",
                                $this->ilias->db->quote($this->getTestId()),
                                $this->ilias->db->quote($data->sequence - 1)
                        );
                        $result = $this->ilias->db->query($query);
                        $data_previous = $result->fetchRow(DB_FETCHMODE_OBJECT);
                        // change previous dataset
                        $query = sprintf("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                $this->ilias->db->quote($data->sequence),
                                $this->ilias->db->quote($data_previous->test_question_id)
                        );
                        $result = $this->ilias->db->query($query);
                        // move actual dataset up
                        $query = sprintf("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                $this->ilias->db->quote($data->sequence - 1),
                                $this->ilias->db->quote($data->test_question_id)
                        );
                        $result = $this->ilias->db->query($query);
                        include_once ("./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) 
        {
                // Move a question down in sequence
                $query = sprintf("SELECT * FROM tst_test_question WHERE test_fi=%s AND question_fi=%s",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($question_id)
                );
                $result = $this->ilias->db->query($query);
                $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
                $query = sprintf("SELECT * FROM tst_test_question WHERE test_fi=%s AND sequence=%s",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($data->sequence + 1)
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows() == 1) 
                {
                        // OK, it's not the last question, so move it down
                        $data_next = $result->fetchRow(DB_FETCHMODE_OBJECT);
                        // change next dataset
                        $query = sprintf("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                $this->ilias->db->quote($data->sequence),
                                $this->ilias->db->quote($data_next->test_question_id)
                        );
                        $result = $this->ilias->db->query($query);
                        // move actual dataset down
                        $query = sprintf("UPDATE tst_test_question SET sequence=%s WHERE test_question_id=%s",
                                $this->ilias->db->quote($data->sequence + 1),
                                $this->ilias->db->quote($data->test_question_id)
                        );
                        $result = $this->ilias->db->query($query);
                        include_once ("./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)
        {
                $duplicate_id = $this->duplicateQuestionForTest($question_id);

                // get maximum sequence index in test
                $query = sprintf("SELECT MAX(sequence) AS seq FROM tst_test_question WHERE test_fi=%s",
                        $this->ilias->db->quote($this->getTestId())
                        );
                $result = $this->ilias->db->query($query);
                $sequence = 1;

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

                $query = sprintf("INSERT INTO tst_test_question (test_question_id, test_fi, question_fi, sequence, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($duplicate_id),
                        $this->ilias->db->quote($sequence)
                        );
                $result = $this->ilias->db->query($query);
                if ($result != DB_OK)
                {
                        // Error
                }
                else
                {
                        include_once ("./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
                $query = sprintf("DELETE FROM tst_active WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                        );
                $result = $this->ilias->db->query($query);
                $this->loadQuestions();
                $this->saveCompleteStatus();
        }

        function &getQuestionTitles() 
        {
                $titles = array();
                if (!$this->isRandomTest())
                {
                        global $ilDB;
                        $query = sprintf("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",
                                $ilDB->quote($this->getTestId() . "")
                        );
                        $result = $ilDB->query($query);
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                array_push($titles, $row["title"]);
                        }
                }
                return $titles;
        }
        
        function getQuestionTitle($sequence) 
        {
                global $ilUser;
                if ($ilUser->id > 0)
                {
                        $active = $this->getActiveTestUser($ilUser->id);
                        $seq = split(",", $active->sequence);
                        $query = sprintf("SELECT title from qpl_questions WHERE question_id = %s",
                                $this->ilias->db->quote($this->questions[$seq[$sequence-1]])
                        );
                }
                else
                {
                        $query = sprintf("SELECT title from qpl_questions WHERE question_id = %s",
                                $this->ilias->db->quote($this->questions[$sequence])
                        );
                }
    $result = $this->ilias->db->query($query);
                $row = $result->fetchRow(DB_FETCHMODE_OBJECT);
                return $row->title;
        }

        function getQuestionDataset($question_id) 
        {
                $query = sprintf("SELECT qpl_questions.*, qpl_question_type.type_tag FROM qpl_questions, qpl_question_type WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_question_type.question_type_id",
                        $this->ilias->db->quote("$question_id")
                );
    $result = $this->ilias->db->query($query);
                $row = $result->fetchRow(DB_FETCHMODE_OBJECT);
                return $row;
        }
        
        function &get_qpl_titles() 
        {
                global $rbacsystem;
                
                $qpl_titles = array();
                // get all available questionpools and remove the trashed questionspools
                $query = "SELECT object_data.*, object_data.obj_id, object_reference.ref_id FROM object_data, object_reference WHERE object_data.obj_id = object_reference.obj_id AND object_data.type = 'qpl' ORDER BY object_data.title";
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {               
                        if ($rbacsystem->checkAccess("write", $row->ref_id) && ($this->_hasUntrashedReference($row->obj_id)))
                        {
                                $qpl_titles["$row->obj_id"] = $row->title;
                        }
                }
                return $qpl_titles;
        }
        
        function &getExistingQuestions() 
        {
                global $ilUser;
                $existing_questions = array();
                if ($this->isRandomTest())
                {
                        $query = sprintf("SELECT qpl_questions.original_id FROM qpl_questions, tst_test_random_question WHERE tst_test_random_question.test_fi = %s AND tst_test_random_question.user_fi = %s AND tst_test_random_question.question_fi = qpl_questions.question_id",
                                $this->ilias->db->quote($this->getTestId() . ""),
                                $this->ilias->db->quote($ilUser->id . "")
                        );
                }
                else
                {
                        $query = sprintf("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",
                                $this->ilias->db->quote($this->getTestId())
                        );
                }
                $result = $this->ilias->db->query($query);
                while ($data = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
                        array_push($existing_questions, $data->original_id);
                }
                return $existing_questions;
        }
        
  function getQuestionType($question_id) 
        {
    if ($question_id < 1)
      return -1;
    $query = sprintf("SELECT type_tag FROM qpl_questions, qpl_question_type WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_question_type.question_type_id",
      $this->ilias->db->quote($question_id)
    );
    $result = $this->ilias->db->query($query);
    if ($result->numRows() == 1) {
      $data = $result->fetchRow(DB_FETCHMODE_OBJECT);
      return $data->type_tag;
    } else {
      return "";
    }
  }
        
        function startWorkingTime ($user_id) 
        {
                $result = "";
                if (!($result = $this->getActiveTestUser($user_id))) {
                        $this->setActiveTestUser();
                        $result = $this->getActiveTestUser($user_id);
                }
                $q = sprintf("INSERT INTO tst_times (times_id, active_fi, started, finished, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                        $this->ilias->db->quote($result->active_id),
                        $this->ilias->db->quote(strftime("%Y-%m-%d %H:%M:%S")),
                        $this->ilias->db->quote(strftime("%Y-%m-%d %H:%M:%S"))
                );
                $result = $this->ilias->db->query($q);
                return $this->ilias->db->getLastInsertId();
        }
        
        function updateWorkingTime($times_id)
        {
                $q = sprintf("UPDATE tst_times SET finished = %s WHERE times_id = %s",
                        $this->ilias->db->quote(strftime("%Y-%m-%d %H:%M:%S")),
                        $this->ilias->db->quote($times_id)
                );
                $result = $this->ilias->db->query($q);
        }
  
        function getQuestionIdFromActiveUserSequence($sequence) 
        {
                global $ilUser;

                $active = $this->getActiveTestUser();
                $sequence_array = split(",", $active->sequence);

                return $this->questions[$sequence_array[$sequence-1]];
        }
        
        function &getAllQuestionsForActiveUser() 
        {
                $result_array = array();
                $active = $this->getActiveTestUser();
                $sequence_array = split(",", $active->sequence);
                $all_questions = &$this->getAllQuestions();
                $worked_questions = &$this->getWorkedQuestions();
                foreach ($sequence_array as $sequence)
                {
                        if (in_array($this->questions[$sequence], $worked_questions))
                        {
                                $all_questions[$this->questions[$sequence]]["worked"] = 1;
                        }
                        else
                        {
                                $all_questions[$this->questions[$sequence]]["worked"] = 0;
                        }
                        array_push($result_array, $all_questions[$this->questions[$sequence]]);
                }
                return $result_array;
        }

        function getWrongAnsweredQuestions()
        {
                global $ilUser;

                foreach($all_questions =& $this->getAllQuestionsForActiveUser() as $question)
                {
                        foreach($this->getTestResult($ilUser->getId()) as $result)
                        {
                                if($result['qid'] == $question['question_id'])
                                {
                                        if($result['max'] != $result['reached'])
                                        {
                                                $wrong[] = $question;
                                        }
                                }
                        }
                }
                return $wrong ? $wrong : array();
        }
        function incrementSequenceByResult($a_sequence)
        {
                global $ilUser;

                for($i = $a_sequence+1; $i <= $this->getQuestionCount(); $i++)
                {
                        $qid = $this->getQuestionIdFromActiveUserSequence($i);

                        foreach($this->getTestResult($ilUser->getId()) as $result)
                        {
                                if($qid == $result['qid'])
                                {
                                        if($result['max'] != $result['reached'])
                                        {
                                                return $i;
                                        }
                                }
                        }
                }
                return ($this->getQuestionCount()+1);
        }


        function decrementSequenceByResult($a_sequence)
        {
                for($i = $a_sequence; $i > 0; $i--)
                {
                        $qid = $this->getQuestionIdFromActiveUserSequence($i);

                        foreach($this->getTestResult($ilUser->getId()) as $result)
                        {
                                if($qid == $result['qid'])
                                {
                                        if($result['max'] != $result['reached'])
                                        {
                                                return $i;
                                        }
                                }
                        }
                }
                return 1;
        }

        function getFirstSequence()
        {
                global $ilUser;

                $results = $this->getTestResult($ilUser->getId());

                for($i = 1; $i <= $this->getQuestionCount(); $i++)
                {
                        $qid = $this->getQuestionIdFromActiveUserSequence($i);

                        foreach($results as $result)
                        {
                                if($qid == $result['qid'])
                                {
                                        if(!$result['max'] or $result['max'] != $result['reached'])
                                        {
                                                return $i;
                                        }
                                }
                        }
                }
                return 0;
        }

        
        function &getWorkedQuestions()
        {
                global $ilUser;
                $query = sprintf("SELECT * FROM tst_solutions WHERE user_fi = %s AND test_fi = %s GROUP BY question_fi",
                        $this->ilias->db->quote($ilUser->id),
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                $result_array = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        array_push($result_array, $row->question_fi);
                }
                return $result_array;
        }
        
        function &getAllQuestions()
        {
                global $ilUser;
                
                if ($this->isRandomTest())
                {
                        $query = sprintf("SELECT qpl_questions.* FROM qpl_questions, tst_test_random_question WHERE tst_test_random_question.question_fi = qpl_questions.question_id AND tst_test_random_question.user_fi = %s AND qpl_questions.question_id IN (" . join($this->questions, ",") . ")",
                                $this->ilias->db->quote($ilUser->id . "")
                        );
                }
                else
                {
                        $query = "SELECT qpl_questions.* FROM qpl_questions, tst_test_question WHERE tst_test_question.question_fi = qpl_questions.question_id AND qpl_questions.question_id IN (" . join($this->questions, ",") . ")";
                }
                $result = $this->ilias->db->query($query);
                $result_array = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $result_array[$row["question_id"]] = $row;
                }
                return $result_array;
        }
        
        function getActiveTestUser($user_id = "") 
        {
                global $ilDB;
                global $ilUser;

                $db =& $ilDB->db;
                if (!$user_id) 
                {
                        $user_id = $ilUser->id;
                }
                $query = sprintf("SELECT * FROM tst_active WHERE user_fi = %s AND test_fi = %s",
                        $db->quote($user_id),
                        $db->quote($this->test_id)
                );
                
                $result = $db->query($query);
                if ($result->numRows()) 
                {
                        $this->active = $result->fetchRow(DB_FETCHMODE_OBJECT);
                } 
                else 
                {
                        $this->active = null;
                }
                return $this->active;
        }
        
        function _getActiveTestUser($user_id = "", $test_id = "") {
                global $ilDB;
                global $ilUser;
                
                $db =& $ilDB->db;
                if (!$user_id) {
                        $user_id = $ilUser->id;
                }
                if (!$test_id)
                {
                        return "";
                }
                $query = sprintf("SELECT * FROM tst_active WHERE user_fi = %s AND test_fi = %s",
                        $db->quote($user_id),
                        $db->quote($test_id)
                );
                
                $result = $db->query($query);
                if ($result->numRows()) {
                        return $result->fetchRow(DB_FETCHMODE_OBJECT);
                } else {
                        return "";
                }
        }
        
        function setActiveTestUser($lastindex = 1, $postpone = "", $addTries = false) 
        {
                global $ilDB;
                global $ilUser;
                
                $db =& $ilDB->db;
                $old_active = $this->getActiveTestUser();
                if ($old_active) {
                        $sequence = $old_active->sequence;
                        $postponed = $old_active->postponed;
                        if ($postpone) {
                                $sequence_array = split(",", $sequence);
                                $postpone_sequence = $sequence_array[$postpone-1];
                                $question_id = $this->questions[$postpone_sequence];
                                unset($sequence_array[$postpone-1]);
                                array_push($sequence_array, $postpone_sequence);
                                $sequence = join(",", $sequence_array);
                                $postponed .= ",$question_id";
                                $postponed = preg_replace("/^,/", "", $postponed);
                        }
                        $tries = $old_active->tries;
                        if ($addTries) {
                                $tries++;
                        }
                        $query = sprintf("UPDATE tst_active SET lastindex = %s, sequence = %s, postponed = %s, tries = %s WHERE user_fi = %s AND test_fi = %s",
                                $db->quote($lastindex),
                                $db->quote($sequence),
                                $db->quote($postponed),
                                $db->quote($tries),
                                $db->quote($ilUser->id),
                                $db->quote($this->test_id)
                        );
                } else {
                        $sequence_arr = array_flip($this->questions);
                        $sequence = join($sequence_arr, ",");
                        $query = sprintf("INSERT INTO tst_active (active_id, user_fi, test_fi, sequence, postponed, lastindex, tries, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, %s, NULL)",
                                $db->quote($ilUser->id),
                                $db->quote($this->test_id),
                                $db->quote($sequence),
                                $db->quote(""),
                                $db->quote($lastindex),
                                $db->quote(0)
                        );
                }
                $db->query($query);
        }
        
        function &getTestResult($user_id)
        {
                //              global $ilBench;
                if ($this->isRandomTest())
                {
                        $this->loadQuestions($user_id);
                }
                $add_parameter = "?ref_id=$this->ref_id&cmd=run";
                $total_max_points = 0;
                $total_reached_points = 0;
                
                // retrieve the active test dataset for the user containing
                // questions sequence and other information 
                //$active = $this->getActiveTestUser($user_id);
                //$sequence_array = array();
                //if (strlen($active->sequence))
                //{
                //      $sequence_array = split(",", $active->sequence);
                //      sort($sequence_array, SORT_NUMERIC);
                //}
                $key = 1;
                $result_array = array();
                foreach ($this->questions as $value)
                {
                        $max_points = ASS_Question::_getMaximumPoints($value);
                        $total_max_points += $max_points;
                        $reached_points = ASS_Question::_getReachedPoints($user_id, $this->getTestId(), $value);
                        $total_reached_points += $reached_points;
                        if ($max_points > 0)
                        {
                                $percentvalue = $reached_points / $max_points;
                        }
                        else
                        {
                                $percentvalue = 0;
                        }
                        if (ASS_Question::_getSuggestedSolutionCount($value) == 1)
                        {
                                $solution_array =& ASS_Question::_getSuggestedSolution($value, 0);
                                $href = ASS_Question::_getInternalLinkHref($solution_array["internal_link"]);
                        }
                        elseif (ASS_Question::_getSuggestedSolutionCount($value) > 1)
                        {
                                $href = "see_details_for_further_information";
                        }
                        else
                        {
                                $href = "";
                        }
                        $info =& ASS_Question::_getQuestionInfo($value);
                        $row = array(
                                "nr" => "$key",
                                "title" => "<a href=\"" . $this->getCallingScript() . "$add_parameter&evaluation=" . $value . "\">" . ilUtil::prepareFormOutput($info["title"]) . "</a>",
                                "max" => sprintf("%d", $max_points),
                                "reached" => sprintf("%d", $reached_points),
                                "percent" => sprintf("%2.2f ", ($percentvalue) * 100) . "%",
                                "solution" => $href,
                                "type" => $info["type_tag"],
                                "qid" => $value
                        );
                        array_push($result_array, $row);
                        $key++;
                }
                $result_array["test"]["total_max_points"] = $total_max_points;
                $result_array["test"]["total_reached_points"] = $total_reached_points;
                if ((!$total_reached_points) or (!$total_max_points))
                {
                        $percentage = 0.0;
                }
                else
                {
                        $percentage = ($total_reached_points / $total_max_points) * 100.0;
                }
                $mark_obj = $this->mark_schema->get_matching_mark($percentage);
                $passed = "";
                if ($mark_obj)
                {
                        if ($mark_obj->get_passed())
                        {
                                $passed = 1;
                        }
                        else
                        {
                                $passed = 0;
                        }
                }
                $result_array["test"]["passed"] = $passed;
                return $result_array;
        }


        function &getTestSummary($user_id)
        {
                global $ilDB;
                //              global $ilBench;
                if ($this->isRandomTest())
                {
                        $this->loadQuestions($user_id);
                }
                
                $add_parameter = "?ref_id=$this->ref_id&cmd=run&crs_show_result=0&";
                
                $key = 1;
                $result_array = array();

                $active = $this->getActiveTestUser();
                
                $solved_questions = ilObjTest::_getSolvedQuestions($this->test_id, $user_id);
                $user = new IlObjUser($user_id);
                foreach ($this->questions as $val) {
                        $question =& ilObjTest::_instanciateQuestion($val);
                        if (is_object($question))
                        {                       
                                $answers = $question->getSolutionValues($this->test_id, $user);
                                $visited = count($answers);
                                $solved  = 0;
                                if (array_key_exists($question->getId(),$solved_questions)) {
                                        $solved =  $solved_questions[$question->getId()]->solved; 
                                }
                                
                                $row = array(
                                        "nr" => "$key",                                 
                                        "href_goto" => $this->getCallingScript() . "$add_parameter&sequence=$key",
                                        "href_setsolved" => $this->getCallingScript() . "$add_parameter&question_id=".$question->getId()."&set_solved=".(($solved)?"0":"1"),
                                        "title" => $question->getTitle(),
                                        "qid" => $question->getId(),
                                        "visited" => $visited,
                                        "solved" => (($solved)?"1":"0"),
                                        "description" => $question->getComment(),
                                        "points" => $question->getMaximumPoints()
                                );
                                array_push($result_array, $row);
                                $key++;
                        }                       
                }
                
                return $result_array;
        }

        
        function &_getTestResult($user_id, $test_obj_id) 
        {
                $test = new ilObjTest($test_obj_id, false);
                $test->loadFromDb();
                $result =& $test->getTestResult($user_id);
                return $result;
        }

/*
  MOVED TO ilObjTestAccess

        function _checkCondition($a_exc_id,$a_operator,$a_value)
        {
                global $ilias;

                switch($a_operator)
                {
                        case 'passed':
                                $result = ilObjTest::_getTestResult($ilias->account->getId(), $a_exc_id);
                                if ($result["test"]["passed"])
                                {
                                        return true;
                                }
                                else
                                {
                                        return false;
                                }
                                break;

                        case 'finished':
                                return ilObjTest::_hasFinished($ilias->account->getId(),$a_exc_id);

                        case 'not_finished':
                                return !ilObjTest::_hasFinished($ilias->account->getId(),$a_exc_id);

                        default:
                                return true;
                }
                return true;

        }
*/

/*
        function assignMetaData(&$a_meta_data)
        {
                $this->meta_data =& $a_meta_data;
        }
*/

/*
        function &getMetaData()
        {
                return $this->meta_data;
        }
*/

/*
        function initMeta()
        {
                if (!is_object($this->meta_data))
                {
                        if ($this->getId())
                        {
                                $new_meta =& new ilMetaData($this->getType(), $this->getId());
                        }
                        else
                        {
                                $new_meta =& new ilMetaData();
                        }
                        $this->assignMetaData($new_meta);
                }
        }
*/

        function evalTotalPersons()
        {
                $q = sprintf("SELECT COUNT(*) as total FROM tst_active WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($q);
                $row = $result->fetchRow(DB_FETCHMODE_OBJECT);
                return $row->total;
        }
        
        function canViewResults()
        {
                $result = true;
                if ($this->getTestType() == TYPE_ASSESSMENT || $this->getTestType() == TYPE_ONLINE_TEST)
                {
                        if ($this->getReportingDate())
                        {
                                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 evalLoadStatisticalSettings($user_id)
        {
                $q = sprintf("SELECT * FROM tst_eval_settings WHERE user_fi = %s",
                        $this->ilias->db->quote("$user_id")
                );
                $result = $this->ilias->db->query($q);
                if (!$result->numRows()) 
                {
                        $row = array(
                                "qworkedthrough" => "1",
                                "pworkedthrough" => "1",
                                "timeofwork" => "1",
                                "atimeofwork" => "1",
                                "firstvisit" => "1",
                                "lastvisit" => "1",
                                "resultspoints" => "1",
                                "resultsmarks" => "1",
                                "distancemedian" => "1"
                        );
                } 
                        else 
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        unset($row["eval_settings_id"]);
                }
                return $row;            
        }
        
        function evalSaveStatisticalSettings($settings_array, $user_id)
        {
                $q = sprintf("SELECT * FROM tst_eval_settings WHERE user_fi = %s",
                        $this->ilias->db->quote("$user_id")
                );
                $result = $this->ilias->db->query($q);
                if ($result->numRows() > 0)
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                }
                $update = $row["eval_settings_id"];
                if (!$update) {
                        $q = sprintf("INSERT INTO tst_eval_settings ".
                                         "(eval_settings_id, user_fi, qworkedthrough, pworkedthrough, timeofwork, atimeofwork, firstvisit, " .
                                         "lastvisit, resultspoints, resultsmarks, distancemedian, TIMESTAMP) VALUES " .
                                         "(NULL, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NULL)",
                                $this->ilias->db->quote("$user_id"),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["qworkedthrough"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["pworkedthrough"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["timeofwork"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["atimeofwork"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["firstvisit"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["lastvisit"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["resultspoints"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["resultsmarks"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["distancemedian"]))
                        );
                } 
                        else 
                {
                        $q = sprintf("UPDATE tst_eval_settings SET ".
                                         "qworkedthrough = %s, pworkedthrough = %s, timeofwork = %s, atimeofwork = %s, firstvisit = %s, " .
                                         "lastvisit = %s, resultspoints = %s, resultsmarks = %s, distancemedian = %s " .
                                         "WHERE eval_settings_id = %s",
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["qworkedthrough"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["pworkedthrough"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["timeofwork"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["atimeofwork"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["firstvisit"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["lastvisit"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["resultspoints"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["resultsmarks"])),
                                $this->ilias->db->quote(sprintf("%01d", $settings_array["distancemedian"])),
                                $this->ilias->db->quote("$update")
                        );
                }
                $result = $this->ilias->db->query($q);
        }

        function getCompleteWorkingTime($user_id)
        {
                $q = sprintf("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",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($user_id)
                );
                $result = $this->ilias->db->query($q);
                $time = 0;
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) 
                {
                        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 &evalStatistical($user_id)
        {
//              global $ilBench;
                
                $test_result =& $this->getTestResult($user_id);
                $q = sprintf("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",
                        $this->ilias->db->quote($this->getTestId()),
                        $this->ilias->db->quote($user_id)
                );
                $result = $this->ilias->db->query($q);
                $times = array();
                $first_visit = "";
                $last_visit = "";
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
                        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;
                }
                $mark_obj = $this->mark_schema->get_matching_mark($percentage);
                $first_date = getdate($first_visit);
                $last_date = getdate($last_visit);
                $qworkedthrough = 0;
                $query_worked_through = sprintf("SELECT test_result_id FROM tst_test_result WHERE user_fi = %s AND test_fi = %s",
                //$query_worked_through = sprintf("SELECT DISTINCT(question_fi) FROM tst_solutions WHERE user_fi = %s AND test_fi = %s",
                        $this->ilias->db->quote("$user_id"),
                        $this->ilias->db->quote($this->getTestId())
                );
                $worked_through_result = $this->ilias->db->query($query_worked_through);
                if (!$worked_through_result->numRows())
                {
                        $atimeofwork = 0;
                }
                else
                {
                        $atimeofwork = $max_time / $worked_through_result->numRows();
                }
                $result_mark = "";
                $passed = "";
                if ($mark_obj)
                {
                        $result_mark = $mark_obj->get_short_name();
                        if ($mark_obj->get_passed())
                        {
                                $passed = 1;
                        }
                        else
                        {
                                $passed = 0;
                        }
                }
                $result_array = array(
                        "qworkedthrough" => $worked_through_result->numRows(),
                        "qmax" => count($this->questions),
                        "pworkedthrough" => ($worked_through_result->numRows()) / count($this->questions),
                        "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 &getTotalPointsArray()
        {
                $totalpoints_array = array();
                $all_users =& $this->evalTotalPersonsArray();
                foreach ($all_users as $user_id => $user_name)
                {
                        $test_result =& $this->getTestResult($user_id);
                        array_push($totalpoints_array, $test_result["test"]["total_reached_points"]);
                }
                return $totalpoints_array;
        }
        
        function &getTotalPointsPassedArray()
        {
                $totalpoints_array = array();
                $all_users =& $this->evalTotalPersonsArray();
                foreach ($all_users as $user_id => $user_name)
                {
                        $test_result =& $this->getTestResult($user_id);
                        $reached = $test_result["test"]["total_reached_points"];
                        $total = $test_result["test"]["total_max_points"];
                        $percentage = $reached/$total;
                        $mark = $this->mark_schema->get_matching_mark($percentage*100.0);
                        if ($mark)
                        {
                                if ($mark->get_passed())
                                {
                                        array_push($totalpoints_array, $test_result["test"]["total_reached_points"]);
                                }
                        }
                }
                return $totalpoints_array;
        }

        function &evalTotalPersonsArray()
        {
                $q = sprintf("SELECT tst_active.user_fi, 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",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($q);
                $persons_array = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        if (strlen($row->firstname.$row->lastname.$row->title) == 0)
                        {
                                $persons_array[$row->user_fi] = $this->lng->txt("deleted_user");
                        }
                        else
                        {
                                $persons_array[$row->user_fi] = trim("$row->lastname, $row->firstname $row->title");
                        }
                }
                return $persons_array;
        }
        
        function evalTotalFinished()
        {
                $q = sprintf("SELECT COUNT(*) as total FROM tst_active WHERE test_fi = %s AND tries > 0",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($q);
                $row = $result->fetchRow(DB_FETCHMODE_OBJECT);
                return $row->total;
        }
        
        function evalTotalFinishedPassed()
        {
                $q = sprintf("SELECT * FROM tst_active WHERE test_fi = %s AND tries > 0",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($q);
                $points = array();
                $passed_tests = 0;
                $failed_tests = 0;
                $maximum_points = 0;
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) 
                {
                        $res =& $this->getTestResult($row->user_fi);
                        if ((!$res["test"]["total_reached_points"]) or (!$res["test"]["total_max_points"])) 
                        {
                                $percentage = 0.0;
                        } 
                                else 
                        {
                                $percentage = ($res["test"]["total_reached_points"] / $res["test"]["total_max_points"]) * 100.0;
                        }
                        $mark_obj = $this->mark_schema->get_matching_mark($percentage);
                        $maximum_points = $res["test"]["total_max_points"];
                        if ($mark_obj)
                        {
                                if ($mark_obj->get_passed()) {
                                        $passed_tests++;
                                        array_push($points, $res["test"]["total_reached_points"]);
                                } 
                                        else 
                                {
                                        $failed_tests++;
                                }
                        }
                }
                $reached_points = 0;
                $counter = 0;
                foreach ($points as $key => $value) 
                {
                        $reached_points += $value;
                        $counter++;
                }
                if ($counter) 
                {
                        $average_points = round($reached_points / $counter);
                } 
                        else 
                {
                        $average_points = 0;
                }
                return array(
                        "total_passed" => $passed_tests,
                        "total_failed" => $failed_tests,
                        "average_points" => $average_points,
                        "maximum_points" => $maximum_points
                );
        }
        
        function evalTotalFinishedAverageTime()
        {
                $q = sprintf("SELECT tst_times.* FROM tst_active, tst_times WHERE tst_active.test_fi = %s AND tst_active.tries > 0 AND tst_active.active_id = tst_times.active_fi",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($q);
                $times = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT)) 
                {
                        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 &getAvailableQuestionpoolIDs()
        {
                global $rbacsystem;
                
                $result_array = array();
                $query = "SELECT object_data.*, object_data.obj_id, object_reference.ref_id FROM object_data, object_reference WHERE object_data.obj_id = object_reference.obj_id AND object_data.type = 'qpl'";
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {               
                        if ($rbacsystem->checkAccess("write", $row->ref_id) && ($this->_hasUntrashedReference($row->obj_id)))
                        {
                                array_push($result_array, $row->obj_id);
                        }
                }
                return $result_array;
        }

        function &getAvailableQuestionpools($use_object_id = false)
        {
                global $rbacsystem;
                
                $result_array = array();
                $query = "SELECT object_data.*, object_data.obj_id, object_reference.ref_id FROM object_data, object_reference WHERE object_data.obj_id = object_reference.obj_id AND object_data.type = 'qpl' ORDER BY object_data.title";
                $result = $this->ilias->db->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {               
                        if ($rbacsystem->checkAccess("write", $row->ref_id) && ($this->_hasUntrashedReference($row->obj_id)))
                        {
                                if ($use_object_id)
                                {
                                        $result_array[$row->obj_id] = $row->title;
                                }
                                else
                                {
                                        $result_array[$row->ref_id] = $row->title;
                                }
                        }
                }
                return $result_array;
        }

        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("h" => $hours, "m" => $minutes, "s" => $time_in_seconds);
                return $result;
        }
        
        function randomSelectQuestions($nr_of_questions, $questionpool, $use_obj_id = 0, $qpls = "")
        {
                global $rbacsystem;
                // get the questionpool id if a questionpool ref id was entered
                if ($questionpool != 0)
                {
                        // retrieve object id
                        if (!$use_obj_id)
                        {
                                $query = sprintf("SELECT obj_id FROM object_reference WHERE ref_id = %s",
                                        $this->ilias->db->quote("$questionpool")
                                );
                                $result = $this->ilias->db->query($query);
                                $row = $result->fetchRow(DB_FETCHMODE_ARRAY);
                                $questionpool = $row[0];
                        }
                }
                
                // get all existing questions in the test
                $query = sprintf("SELECT qpl_questions.original_id FROM qpl_questions, tst_test_question WHERE qpl_questions.question_id = tst_test_question.question_fi AND tst_test_question.test_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . "")
                );
                $result = $this->ilias->db->query($query);
                $original_ids = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_ARRAY))
                {
                        if (strcmp($row[0], "") != 0)
                        {
                                array_push($original_ids, $row[0]);
                        }
                }
                $original_clause = "";
                if (count($original_ids))
                {
                        $original_clause = " AND ISNULL(qpl_questions.original_id) AND qpl_questions.question_id NOT IN (" . join($original_ids, ",") . ")";
                }
                
                // get a list of questionpools which are not allowed for the test (only for random selection of questions in test questions editor)
                if (($questionpool == 0) && (!is_array($qpls)))
                {
                        $available_pools =& $this->getAvailableQuestionpoolIDs();
                        $available = "";
                        $constraint_qpls = "";
                        if (count($available_pools))
                        {
                                $available = " AND qpl_questions.obj_fi IN (" . join($available_pools, ",") . ")";
                        }
                        else
                        {
                                return array();
                        }
                }
                
                $result_array = array();
                if ($questionpool == 0)
                {
                        if (is_array($qpls))
                        {
                                if (count($qpls) > 0)
                                {
                                        $qplidx = array();
                                        foreach ($qpls as $idx => $arr)
                                        {
                                                array_push($qplidx, $arr["qpl"]);
                                        }
                                        $constraint_qpls = " AND qpl_questions.obj_fi IN (" . join($qplidx, ",") . ")";
                                }
                        }
                        $query = "SELECT COUNT(question_id) FROM qpl_questions, object_data WHERE ISNULL(qpl_questions.original_id) AND object_data.type = 'qpl' AND object_data.obj_id = qpl_questions.obj_fi$available$constraint_qpls AND qpl_questions.complete = '1'$original_clause";
                }
                        else
                {
                        $query = sprintf("SELECT COUNT(question_id) FROM qpl_questions WHERE ISNULL(qpl_questions.original_id) AND obj_fi = %s$original_clause",
                                $this->ilias->db->quote("$questionpool")
                        );
                }
                $result = $this->ilias->db->query($query);
                $row = $result->fetchRow(DB_FETCHMODE_ARRAY);
                if (($row[0]) <= $nr_of_questions)
                {
                        // take all available questions
                        if ($questionpool == 0)
                        {
                                $query = "SELECT question_id FROM qpl_questions, object_data WHERE ISNULL(qpl_questions.original_id) AND object_data.type = 'qpl' AND object_data.obj_id = qpl_questions.obj_fi$available$constraint_qpls AND qpl_questions.complete = '1'$original_clause";
                        }
                                else
                        {
                                $query = sprintf("SELECT question_id FROM qpl_questions WHERE ISNULL(qpl_questions.original_id) AND obj_fi = %s AND qpl_questions.complete = '1'$original_clause",
                                        $this->ilias->db->quote("$questionpool")
                                );
                        }
                        $result = $this->ilias->db->query($query);
                        while ($row = $result->fetchRow(DB_FETCHMODE_ARRAY))
                        {
                                if ((!in_array($row[0], $this->questions)) && (strcmp($row[0], "") != 0))
                                {
                                        $result_array[$row[0]] = $row[0];
                                }
                        }
                }
                        else
                {
                        // select a random number out of the maximum number of questions
                        mt_srand((double)microtime()*1000000);
                        $random_number = mt_rand(0, $row[0] - 1);
                        $securitycounter = 500;
                        while ((count($result_array) < $nr_of_questions) && ($securitycounter > 0))
                        {
                                if ($questionpool == 0)
                                {
                                        $query = "SELECT question_id FROM qpl_questions, object_data WHERE ISNULL(qpl_questions.original_id) AND object_data.type = 'qpl' AND object_data.obj_id = qpl_questions.obj_fi$available$constraint_qpls AND qpl_questions.complete = '1'$original_clause LIMIT $random_number, 1";
                                }
                                        else
                                {
                                        $query = sprintf("SELECT question_id FROM qpl_questions WHERE ISNULL(qpl_questions.original_id) AND obj_fi = %s AND qpl_questions.complete = '1'$original_clause LIMIT $random_number, 1",
                                                $this->ilias->db->quote("$questionpool")
                                        );
                                }
                                $result = $this->ilias->db->query($query);
                                $result_row = $result->fetchRow(DB_FETCHMODE_ARRAY);
                                if ((!in_array($result_row[0], $this->questions)) && (strcmp($result_row[0], "") != 0))
                                {
                                        $result_array[$result_row[0]] = $result_row[0];
                                }
                                $random_number = mt_rand(0, $row[0] - 1);
                                $securitycounter--;
                        }
                }
                return $result_array;
        }

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

        function getImagePathWeb() 
        {
                $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);
    }
    switch ($question_type) 
                {
      case "qt_multiple_choice_sr":
        $question =& new ASS_MultipleChoiceGUI();
        $question->object->set_response(RESPONSE_SINGLE);
        break;
      case "qt_multiple_choice_mr":
        $question =& new ASS_MultipleChoiceGUI();
        $question->object->set_response(RESPONSE_MULTIPLE);
        break;
      case "qt_cloze":
        $question =& new ASS_ClozeTestGUI();
        break;
      case "qt_matching":
        $question =& new ASS_MatchingQuestionGUI();
        break;
      case "qt_ordering":
        $question =& new ASS_OrderingQuestionGUI();
        break;
      case "qt_imagemap":
        $question =& new ASS_ImagemapQuestionGUI();
        break;
                        case "qt_javaapplet":
                                $question =& new ASS_JavaAppletGUI();
                                break;
                        case "qt_text":
                                $question =& new ASS_TextQuestionGUI();
                                break;
    }
                if ($question_id > 0)
                {
                        $question->object->loadFromDb($question_id);
                }
                return $question;
  }

  function &_instanciateQuestion($question_id) 
        {
                if (strcmp($question_id, "") != 0)
                {
                        $question_type = ASS_Question::_getQuestionType($question_id);

                        switch ($question_type) {
                                case "qt_cloze":
                                        $question = new ASS_ClozeTest();
                                        break;
                                case "qt_matching":
                                        $question = new ASS_MatchingQuestion();
                                        break;
                                case "qt_ordering":
                                        $question = new ASS_OrderingQuestion();
                                        break;
                                case "qt_imagemap":
                                        $question = new ASS_ImagemapQuestion();
                                        break;
                                case "qt_multiple_choice_sr":
                                case "qt_multiple_choice_mr":
                                        $question = new ASS_MultipleChoice();
                                        break;
                                case "qt_javaapplet":
                                        $question = new ASS_JavaApplet();
                                        break;
                                case "qt_text":
                                        $question = new ASS_TextQuestion();
                                        break;

                                default:
                                        // Return false if question id does not exists or type is unknown
                                        return false;
                        }

                        $question->loadFromDb($question_id);
                        return $question;
                }
  }

        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->getTestType() == TYPE_ASSESSMENT || $this->getTestType() == TYPE_ONLINE_TEST) 
                {
                        if ($this->getStartingTime()) 
                        {
                                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->getTestType() == TYPE_ASSESSMENT || $this->getTestType() == TYPE_ONLINE_TEST) 
                {
                        if ($this->getEndingTime()) 
                        {
                                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 getQuestionsTable($sortoptions, $filter_text, $sel_filter_type, $startrow = 0, $completeonly = 0, $filter_question_type = "", $filter_questionpool = "")
        {
                global $ilUser;
                $where = "";
                if (strlen($filter_text) > 0) {
                        switch($sel_filter_type) {
                                case "title":
                                        $where = " AND qpl_questions.title LIKE " . $this->ilias->db->quote("%" . $filter_text . "%");
                                        break;
                                case "comment":
                                        $where = " AND qpl_questions.comment LIKE " . $this->ilias->db->quote("%" . $filter_text . "%");
                                        break;
                                case "author":
                                        $where = " AND qpl_questions.author LIKE " . $this->ilias->db->quote("%" . $filter_text . "%");
                                        break;
                        }
                }
                
                if ($filter_question_type && (strcmp($filter_question_type, "all") != 0))
                {
                        $where .= " AND qpl_question_type.type_tag = " . $this->ilias->db->quote($filter_question_type);
                }
                
                if ($filter_questionpool && (strcmp($filter_questionpool, "all") != 0))
                {
                        $where .= " AND qpl_questions.obj_fi = $filter_questionpool";
                }
  
    // build sort order for sql query
                $order = "";
                $images = array();
    if (count($sortoptions)) {
      foreach ($sortoptions as $key => $value) {
        switch($key) {
          case "title":
            $order = " ORDER BY title $value";
            $images["title"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "comment":
            $order = " ORDER BY comment $value";
            $images["comment"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "type":
            $order = " ORDER BY question_type_id $value";
            $images["type"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "author":
            $order = " ORDER BY author $value";
            $images["author"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "created":
            $order = " ORDER BY created $value";
            $images["created"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "updated":
            $order = " ORDER BY TIMESTAMP14 $value";
            $images["updated"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
          case "qpl":
            $order = " ORDER BY obj_fi $value";
            $images["qpl"] = " <img src=\"" . ilUtil::getImagePath(strtolower($value) . "_order.png", true) . "\" alt=\"" . strtolower($value) . "ending order\" />";
            break;
        }
      }
    }
                $maxentries = $ilUser->prefs["hits_per_page"];
                if ($maxentries < 1)
                {
                        $maxentries = 9999;
                }
                $available_pools =& $this->getAvailableQuestionpoolIDs();
                $available = "";
                if (count($available_pools))
                {
                        $available = " AND qpl_questions.obj_fi IN (" . join($available_pools, ",") . ")";
                }
                else
                {
                        return array();
                }
                if ($completeonly)
                {
                        $available .= " AND qpl_questions.complete = " . $this->ilias->db->quote("1");
                }

                // get all questions in the test
                $query = sprintf("SELECT qpl_questions.original_id, qpl_questions.TIMESTAMP + 0 AS TIMESTAMP14 FROM qpl_questions, tst_test_question WHERE qpl_questions.question_id = tst_test_question.question_fi AND tst_test_question.test_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . "")
                );
                $result = $this->ilias->db->query($query);
                $original_ids = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_ARRAY))
                {
                        if (strcmp($row[0], "") != 0)
                        {
                                array_push($original_ids, $row[0]);
                        }
                }
                $original_clause = " ISNULL(qpl_questions.original_id)";
                if (count($original_ids))
                {
                        $original_clause = " ISNULL(qpl_questions.original_id) AND qpl_questions.question_id NOT IN (" . join($original_ids, ",") . ")";
                }

                $query = "SELECT qpl_questions.question_id, qpl_questions.TIMESTAMP + 0 AS TIMESTAMP14 FROM qpl_questions, qpl_question_type WHERE $original_clause$available AND qpl_questions.question_type_fi = qpl_question_type.question_type_id $where$order$limit";
    $query_result = $this->ilias->db->query($query);
                $max = $query_result->numRows();
                if ($startrow > $max -1)
                {
                        $startrow = $max - ($max % $maxentries);
                }
                else if ($startrow < 0)
                {
                        $startrow = 0;
                }
                $limit = " LIMIT $startrow, $maxentries";
                $query = "SELECT qpl_questions.*, qpl_questions.TIMESTAMP + 0 AS TIMESTAMP14, qpl_question_type.type_tag FROM qpl_questions, qpl_question_type WHERE $original_clause $available AND qpl_questions.question_type_fi = qpl_question_type.question_type_id $where$order$limit";
    $query_result = $this->ilias->db->query($query);
                $rows = array();
                if ($query_result->numRows())
                {
                        while ($row = $query_result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                array_push($rows, $row);
                        }
                }
                $nextrow = $startrow + $maxentries;
                if ($nextrow > $max - 1)
                {
                        $nextrow = $startrow;
                }
                $prevrow = $startrow - $maxentries;
                if ($prevrow < 0)
                {
                        $prevrow = 0;
                }
                return array(
                        "rows" => $rows,
                        "images" => $images,
                        "startrow" => $startrow,
                        "nextrow" => $nextrow,
                        "prevrow" => $prevrow,
                        "step" => $maxentries,
                        "rowcount" => $max
                );
        }
        
        function _getTestType($test_id)
        {
                global $ilDB;
                
                $result = "";
                $query = sprintf("SELECT tst_test_type.type_tag FROM tst_test_type, tst_tests WHERE tst_test_type.test_type_id = tst_tests.test_type_fi AND tst_tests.test_id = %s",
                        $ilDB->quote($test_id)
                );
                $query_result = $ilDB->query($query);
                if ($query_result->numRows())
                {
                        $row = $query_result->fetchRow(DB_FETCHMODE_ASSOC);
                        $result = $row["type_tag"];
                }
                return $result;
        }
        
        function &_getQuestiontypes()
        {
                global $ilDB;
                
                $questiontypes = array();
                $query = "SELECT * FROM qpl_question_type ORDER BY type_tag";
                $query_result = $ilDB->query($query);
                while ($row = $query_result->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        array_push($questiontypes, $row["type_tag"]);
                }
                return $questiontypes;
        }
        
        function to_xml()
        {
                $xml_header = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<questestinterop></questestinterop>\n";
                $domxml = domxml_open_mem($xml_header);
                $root = $domxml->document_element();
                // qti assessment
                $qtiAssessment = $domxml->create_element("assessment");
                $qtiAssessment->set_attribute("ident", "il_".IL_INST_ID."_tst_".$this->getTestId());
                $qtiAssessment->set_attribute("title", $this->getTitle());
                
                // add qti comment
                $qtiComment = $domxml->create_element("qticomment");
                $qtiCommentText = $domxml->create_text_node($this->getDescription());
                $qtiComment->append_child($qtiCommentText);
                $qtiAssessment->append_child($qtiComment);

                // add qti duration
                if ($this->enable_processing_time)
                {
                        $qtiDuration = $domxml->create_element("duration");
                        preg_match("/(\d+):(\d+):(\d+)/", $this->processing_time, $matches);
                        $qtiDurationText = $domxml->create_text_node(sprintf("P0Y0M0DT%dH%dM%dS", $matches[1], $matches[2], $matches[3]));
                        $qtiDuration->append_child($qtiDurationText);
                        $qtiAssessment->append_child($qtiDuration);
                }

                // add the rest of the preferences in qtimetadata tags, because there is no correspondent definition in QTI
                $qtiMetadata = $domxml->create_element("qtimetadata");
                // ILIAS version
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("ILIAS_VERSION");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node($this->ilias->getSetting("ilias_version"));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // test type
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("test_type");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node(sprintf("%d", $this->getTestType()));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // sequence settings
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("sequence_settings");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node(sprintf("%d", $this->getSequenceSettings()));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // author
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("author");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node($this->getAuthor());
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // count system
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("count_system");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node($this->getCountSystem());
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // multiple choice scoring
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("mc_scoring");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node($this->getMCScoring());
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // score reporting date
                if ($this->getReportingDate())
                {
                        $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                        $qtiFieldLabel = $domxml->create_element("fieldlabel");
                        $qtiFieldLabelText = $domxml->create_text_node("reporting_date");
                        $qtiFieldLabel->append_child($qtiFieldLabelText);
                        $qtiFieldEntry = $domxml->create_element("fieldentry");
                        preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->reporting_date, $matches);
                        $qtiFieldEntryText = $domxml->create_text_node(sprintf("P%dY%dM%dDT%dH%dM%dS", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                        $qtiFieldEntry->append_child($qtiFieldEntryText);
                        $qtiMetadatafield->append_child($qtiFieldLabel);
                        $qtiMetadatafield->append_child($qtiFieldEntry);
                        $qtiMetadata->append_child($qtiMetadatafield);
                }
                // number of tries
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("nr_of_tries");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node(sprintf("%d", $this->getNrOfTries()));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // random test
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("random_test");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node(sprintf("%d", $this->isRandomTest()));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // random question count
                $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                $qtiFieldLabel = $domxml->create_element("fieldlabel");
                $qtiFieldLabelText = $domxml->create_text_node("random_question_count");
                $qtiFieldLabel->append_child($qtiFieldLabelText);
                $qtiFieldEntry = $domxml->create_element("fieldentry");
                $qtiFieldEntryText = $domxml->create_text_node(sprintf("%d", $this->getRandomQuestionCount()));
                $qtiFieldEntry->append_child($qtiFieldEntryText);
                $qtiMetadatafield->append_child($qtiFieldLabel);
                $qtiMetadatafield->append_child($qtiFieldEntry);
                $qtiMetadata->append_child($qtiMetadatafield);
                // starting time
                if ($this->getStartingTime())
                {
                        $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                        $qtiFieldLabel = $domxml->create_element("fieldlabel");
                        $qtiFieldLabelText = $domxml->create_text_node("starting_time");
                        $qtiFieldLabel->append_child($qtiFieldLabelText);
                        $qtiFieldEntry = $domxml->create_element("fieldentry");
                        preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->starting_time, $matches);
                        $qtiFieldEntryText = $domxml->create_text_node(sprintf("P%dY%dM%dDT%dH%dM%dS", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                        $qtiFieldEntry->append_child($qtiFieldEntryText);
                        $qtiMetadatafield->append_child($qtiFieldLabel);
                        $qtiMetadatafield->append_child($qtiFieldEntry);
                        $qtiMetadata->append_child($qtiMetadatafield);
                }
                // ending time
                if ($this->getEndingTime())
                {
                        $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                        $qtiFieldLabel = $domxml->create_element("fieldlabel");
                        $qtiFieldLabelText = $domxml->create_text_node("ending_time");
                        $qtiFieldLabel->append_child($qtiFieldLabelText);
                        $qtiFieldEntry = $domxml->create_element("fieldentry");
                        preg_match("/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2})/", $this->ending_time, $matches);
                        $qtiFieldEntryText = $domxml->create_text_node(sprintf("P%dY%dM%dDT%dH%dM%dS", $matches[1], $matches[2], $matches[3], $matches[4], $matches[5], $matches[6]));
                        $qtiFieldEntry->append_child($qtiFieldEntryText);
                        $qtiMetadatafield->append_child($qtiFieldLabel);
                        $qtiMetadatafield->append_child($qtiFieldEntry);
                        $qtiMetadata->append_child($qtiMetadatafield);
                }
                foreach ($this->mark_schema->mark_steps as $index => $mark)
                {
                        // mark steps
                        $qtiMetadatafield = $domxml->create_element("qtimetadatafield");
                        $qtiFieldLabel = $domxml->create_element("fieldlabel");
                        $qtiFieldLabelText = $domxml->create_text_node("mark_step_$index");
                        $qtiFieldLabel->append_child($qtiFieldLabelText);
                        $qtiFieldEntry = $domxml->create_element("fieldentry");
                        $qtiFieldEntryText = $domxml->create_text_node(sprintf("<short>%s</short><official>%s</official><percentage>%.2f</percentage><passed>%d</passed>", $mark->get_short_name(), $mark->get_official_name(), $mark->get_minimum_level(), $mark->get_passed()));
                        $qtiFieldEntry->append_child($qtiFieldEntryText);
                        $qtiMetadatafield->append_child($qtiFieldLabel);
                        $qtiMetadatafield->append_child($qtiFieldEntry);
                        $qtiMetadata->append_child($qtiMetadatafield);
                }
                $qtiAssessment->append_child($qtiMetadata);
                
                // add qti objectives
                $qtiObjectives = $domxml->create_element("objectives");
                $qtiMaterial = $domxml->create_element("material");
                $qtiMaterial->set_attribute("label", "introduction");
                $qtiMatText = $domxml->create_element("mattext");
                $qtiMatTextText = $domxml->create_text_node($this->getIntroduction());
                $qtiMatText->append_child($qtiMatTextText);
                $qtiMaterial->append_child($qtiMatText);
                $qtiObjectives->append_child($qtiMaterial);
                $qtiAssessment->append_child($qtiObjectives);

                // add qti assessmentcontrol
                $qtiAssessmentcontrol = $domxml->create_element("assessmentcontrol");
                $score_reporting = "No";
                switch ($this->getScoreReporting())
                {
                        case "1":
                                $score_reporting = "Yes";
                                break;
                }
                $qtiAssessmentcontrol->set_attribute("solutionswitch", $score_reporting);
                $qtiAssessment->append_child($qtiAssessmentcontrol);
                
                $qtiSection = $domxml->create_element("section");
                $qtiSection->set_attribute("ident", "1");
                $qtiAssessment->append_child($qtiSection);
                
                $root->append_child($qtiAssessment);
                $xml = $domxml->dump_mem(true);
                $domxml->free();
                foreach ($this->questions as $question_id) {
                        $question =& ilObjTest::_instanciateQuestion($question_id);
                        $qti_question = $question->to_xml(false);
                        $qti_question = preg_replace("/<questestinterop>/", "", $qti_question);
                        $qti_question = preg_replace("/<\/questestinterop>/", "", $qti_question);
                        if (strpos($xml, "</section>") !== false)
                        {
                                $xml = str_replace("</section>", "$qti_question</section>", $xml);
                        }
                        else
                        {
                                $xml = str_replace("<section ident=\"1\"/>", "<section ident=\"1\">\n$qti_question</section>", $xml);
                        }
                }
                return $xml;
        }
        
        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")
                {
                        $a_value = ilUtil::insertInstIntoID($a_value);
                }

                return $a_value;
        }


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

                include_once "./content/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("content/classes/Media/class.ilObjMediaObject.php");

                foreach ($this->mob_ids as $mob_id)
                {
                        $expLog->write(date("[y-m-d H:i:s] ")."Media Object ".$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("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 from_xml($xml_text)
        {
                $result = false;
                $this->mark_schema->flush();
                $xml_text = preg_replace("/>\s*?</", "><", $xml_text);
                $domxml = domxml_open_mem($xml_text);
                if (!empty($domxml))
                {
                        $root = $domxml->document_element();
                        $this->setTitle($root->get_attribute("title"));
                        $item = $root;
                        $itemnodes = $item->child_nodes();
                        foreach ($itemnodes as $index => $node)
                        {
                                switch ($node->node_name())
                                {
                                        case "qticomment":
                                                $comment = $node->get_content();
                                                if (strpos($comment, "Author=") !== false)
                                                {
                                                        $comment = str_replace("Author=", "", $comment);
                                                        $this->setAuthor($comment);
                                                }
                                                elseif (strpos($comment, "ILIAS Version=") !== false)
                                                {
                                                }
                                                else
                                                {
                                                        $this->setDescription($comment);
                                                }
                                                break;
                                        case "duration":
                                                $iso8601period = $node->get_content();
                                                if (preg_match("/P(\d+)Y(\d+)M(\d+)DT(\d+)H(\d+)M(\d+)S/", $iso8601period, $matches))
                                                {
                                                        $this->enable_processing_time = 1;
                                                        $this->setProcessingTime(sprintf("%02d:%02d:%02d", $matches[4], $matches[5], $matches[6]));
                                                }
                                                break;
                                        case "assessmentcontrol":
                                                $score_reporting = $node->get_attribute("solutionswitch");
                                                switch (strtolower($score_reporting))
                                                {
                                                        case "1":
                                                        case "yes":
                                                                $score_reporting = 1;
                                                                break;
                                                        default:
                                                                $score_reporting = 0;
                                                                break;
                                                }
                                                $this->setScoreReporting($score_reporting);
                                                break;
                                        case "objectives":
                                                $material = $node->first_child();
                                                if (strcmp($material->get_attribute("label"), "introduction") == 0)
                                                {
                                                        $mattext = $material->first_child();
                                                        $this->setIntroduction($mattext->get_content());
                                                }
                                                break;
                                        case "qtimetadata":
                                                $metadata_fields = $node->child_nodes();
                                                foreach ($metadata_fields as $index => $metadata_field)
                                                {
                                                        $fieldlabel = $metadata_field->first_child();
                                                        $fieldentry = $fieldlabel->next_sibling();
                                                        switch ($fieldlabel->get_content())
                                                        {
                                                                case "sequence_settings":
                                                                        $this->setSequenceSettings($fieldentry->get_content());
                                                                        break;
                                                                case "author":
                                                                        $this->setAuthor($fieldentry->get_content());
                                                                        break;
                                                                case "test_type":
                                                                        $this->setTestType($fieldentry->get_content());
                                                                        break;
                                                                case "reporting_date":
                                                                        $iso8601period = $fieldentry->get_content();
                                                                        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 "nr_of_tries":
                                                                        $this->setNrOfTries($fieldentry->get_content());
                                                                        break;
                                                                case "random_test":
                                                                        $this->setRandomTest($fieldentry->get_content());
                                                                        break;
                                                                case "random_question_count":
                                                                        $this->setRandomQuestionCount($fieldentry->get_content());
                                                                        break;
                                                                case "starting_time":
                                                                        $iso8601period = $fieldentry->get_content();
                                                                        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 = $fieldentry->get_content();
                                                                        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+/", $fieldlabel->get_content()))
                                                        {
                                                                $xmlmark = $fieldentry->get_content();
                                                                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->add_mark_step($mark_short, $mark_official, $mark_percentage, $mark_passed);
                                                        }
                                                }
                                                break;
                                }
                        }
                        $result = true;
                }
                return $result;
        }
        
        function importObject($source, $questionpool_id)
        {
                $ilias_version = "";
                $error = 0;
                if (($source == 'none') || (!$source) || $file_info["error"] > UPLOAD_ERR_OK)
                {
                        $this->ilias->raiseError("No file selected!",$this->ilias->error_obj->FATAL);
                        $error = 1;
                }
                

                if (!$error)
                {
                        // import file as a test
                        $fh = fopen($source, "r");
                        if (!$fh)
                        {
                        $this->ilias->raiseError("Error opening the file!",$this->ilias->error_obj->FATAL);
                                $error = 1;
                                return $error;
                        }

                        $xml = fread($fh, filesize($source));
                        $result = fclose($fh);

                        if (!$result)
                        {
                                $this->ilias->raiseError("Error closing the file!",$this->ilias->error_obj->FATAL);
                                $error = 1;
                                return $error;
                        }

                        $assessment_part = "";
                        if (preg_match("/ILIAS Version\=(\d+)\.(\d+)\.?(\d?)/", $xml, $matches))
                        {
                                $major_version = $matches[1];
                                unset($matches[0]);
                                $ilias_version = join($matches, ".");
                                if ($major_version == 2)
                                {
                                        $this->setTestType(TYPE_SELF_ASSESSMENT);
                                        global $lng;
                                        $lng->loadLanguageModule("assessment");
                                        $this->setTitle($lng->txt("imported_test"));
                                        $assessment_part = $this->to_xml();
                                        if (preg_match("/(<assessment[^>]*>.*?<\/assessment>)/si", $assessment_part, $matches))
                                        {
                                                $assessment_part = $matches[1];
                                        }
                                }
                        }

                        $found_assessment = preg_match("/(<assessment[^>]*>.*?<\/assessment>)/si", $xml, $matches);
                        if ($found_assessment or $assessment_part)
                        {
                                if ((!$found_assessment) and ($assessment_part))
                                {
                                        $matches[1] = $assessment_part;
                                }
                                // read test properties
                                $succeeded = $this->from_xml($matches[1]);

                                if (!$succeeded)
                                {
//                      $this->ilias->raiseError("The test properties do not contain proper values!",$this->ilias->error_obj->MESSAGE);
                                        $error = 1;
                                        return $error;
                                }
                        }
                        else
                        {
//                      $this->ilias->raiseError("No test properties found. Cannot import test!",$this->ilias->error_obj->MESSAGE);
                                $error = 1;
                                return $error;
                        }

                        $question_counter = 1;
                        
                        $this->import_mapping = array();
                        
                        if (preg_match_all("/(<item[^>]*>.*?<\/item>)/si", $xml, $matches))
                        {

                                foreach ($matches[1] as $index => $item)
                                {
                                        // get identifier
                                        if (preg_match("/(<item[^>]*>)/is", $item, $start_tag))
                                        {
                                                if (preg_match("/(ident=\"([^\"]*)\")/is", $start_tag[1], $ident))
                                                {
                                                        $ident = $ident[2];
                                                }
                                        }
                                        
                                        $question = "";
                                        $qt = "";
                                        if (preg_match("/<fieldlabel>QUESTIONTYPE<\/fieldlabel>\s*<fieldentry>(.*?)<\/fieldentry>/is", $item, $questiontype))
                                        {
                                                $qt = $questiontype[1];
                                        }
                                        if (preg_match("/<qticomment>Questiontype\=(.*?)<\/qticomment>/is", $item, $questiontype))
                                        {
                                                $qt = $questiontype[1];
                                        }
                                        if (strlen($qt))
                                        {
                                                switch ($qt)
                                                {
                                                        case CLOZE_TEST_IDENTIFIER:
                                                                $question = new ASS_ClozeTest();
                                                                break;
                                                        case IMAGEMAP_QUESTION_IDENTIFIER:
                                                                $question = new ASS_ImagemapQuestion();
                                                                break;
                                                        case MATCHING_QUESTION_IDENTIFIER:
                                                                $question = new ASS_MatchingQuestion();
                                                                break;
                                                        case MULTIPLE_CHOICE_QUESTION_IDENTIFIER:
                                                                $question = new ASS_MultipleChoice();
                                                                break;
                                                        case ORDERING_QUESTION_IDENTIFIER:
                                                                $question = new ASS_OrderingQuestion();
                                                                break;
                                                        case JAVAAPPLET_QUESTION_IDENTIFIER:
                                                                $question = new ASS_JavaApplet();
                                                                break;
                                                        case TEXT_QUESTION_IDENTIFIER:
                                                                $question = new ASS_TextQuestion();
                                                                break;
                                                }
                                                if ($question)
                                                {
                                                        $question->setObjId($questionpool_id);
                                                        if ($question->from_xml("<questestinterop>$item</questestinterop>"))
                                                        {
                                                                $question->saveToDb();
                                                                $q_1_id = $question->getId();
                                                                $question_id = $question->duplicate(true);
                                                                $this->questions[$question_counter++] = $question_id;
                                                                $this->import_mapping[$ident] = array(
                                                                        "pool" => $q_1_id, "test" => $question_id);
                                                        }
                                                        else
                                                        {
                                                                $this->ilias->raiseError($this->lng->txt("error_importing_question"), $this->ilias->error_obj->MESSAGE);
                                                        }
                                                }
                                        }
                                }
                        }
                }
//echo "<br>"; var_dump($this->import_mapping);
                $result = array(
                        "error" => $error,
                        "version" => $ilias_version
                );
                return $result;
        }
        
        function getImportMapping()
        {
                if (!is_array($this->import_mapping))
                {
                        return array();
                }
                else
                {
                        return $this->import_mapping;
                }
        }
        
        function getECTSGrade($reached_points, $max_points)
        {
                require_once "./classes/class.ilStatistics.php";
                // calculate the median
                $passed_statistics = new ilStatistics();
                $passed_array =& $this->getTotalPointsPassedArray();
                $passed_statistics->setData($passed_array);
                $ects_percentiles = array
                        (
                                "A" => $passed_statistics->quantile($this->ects_grades["A"]),
                                "B" => $passed_statistics->quantile($this->ects_grades["B"]),
                                "C" => $passed_statistics->quantile($this->ects_grades["C"]),
                                "D" => $passed_statistics->quantile($this->ects_grades["D"]),
                                "E" => $passed_statistics->quantile($this->ects_grades["E"])
                        );
                        if (count($passed_array) && ($reached_points >= $ects_percentiles["A"]))
                        {
                                return "A";
                        }
                        else if (count($passed_array) && ($reached_points >= $ects_percentiles["B"]))
                        {
                                return "B";
                        }
                        else if (count($passed_array) && ($reached_points >= $ects_percentiles["C"]))
                        {
                                return "C";
                        }
                        else if (count($passed_array) && ($reached_points >= $ects_percentiles["D"]))
                        {
                                return "D";
                        }
                        else if (count($passed_array) && ($reached_points >= $ects_percentiles["E"]))
                        {
                                return "E";
                        }
                        else if (strcmp($this->ects_fx, "") != 0)
                        {
                                if ($max_points > 0)
                                {
                                        $percentage = ($reached_points / $max_points) * 100.0;
                                }
                                else
                                {
                                        $percentage = 0.0;
                                }
                                if ($percentage >= $this->ects_fx)
                                {
                                        return "FX";
                                }
                                else
                                {
                                        return "F";
                                }
                        }
                        else
                        {
                                return "F";
                        }
        }
        
        function checkMarks()
        {
                return $this->mark_schema->checkMarks();
        }
        
        function updateMetaData()
        {
                global $ilUser;
                include_once("Services/MetaData/classes/class.ilMD.php");
                $md =& new ilMD($this->getId(), 0, $this->getType());
                $md_gen =& $md->getGeneral();
                if ($md_gen == false)
                {
                        include_once 'Services/MetaData/classes/class.ilMDCreator.php';
                        $md_creator = new ilMDCreator($this->getId(),0,$this->getType());
                        $md_creator->setTitle($this->getTitle());
                        $md_creator->setTitleLanguage($ilUser->getPref('language'));
                        $md_creator->create();
                }
                parent::updateMetaData();
        }
        
        function &_getAvailableTests($use_object_id = false)
        {
                global $rbacsystem;
                global $ilDB;
                
                $result_array = array();
                $query = "SELECT object_data.*, object_data.obj_id, object_reference.ref_id FROM object_data, object_reference WHERE object_data.obj_id = object_reference.obj_id AND object_data.type = 'tst' ORDER BY object_data.title";
                $result = $ilDB->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {               
                        if ($rbacsystem->checkAccess("write", $row->ref_id) && (ilObject::_hasUntrashedReference($row->obj_id)))
                        {
                                if ($use_object_id)
                                {
                                        $result_array[$row->obj_id] = $row->title;
                                }
                                else
                                {
                                        $result_array[$row->ref_id] = $row->title;
                                }
                        }
                }
                return $result_array;
        }

        function cloneRandomQuestions($new_id)
        {
                if ($new_id > 0)
                {
                        $query = sprintf("SELECT * FROM tst_test_random WHERE test_fi = %s",
                                $this->ilias->db->quote($this->getTestId() . "")
                        );
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows())
                        {
                                while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        $query = sprintf("INSERT INTO tst_test_random (test_random_id, test_fi, questionpool_fi, num_of_q, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                                $this->ilias->db->quote($new_id . ""),
                                                $this->ilias->db->quote($row["questionpool_fi"] . ""),
                                                $this->ilias->db->quote($row["num_of_q"] . "")
                                        );
                                        $insertresult = $this->ilias->db->query($query);
                                }
                        }
                }
        }
        
        
        function _clone($obj_id)
        {
                $original = new ilObjTest($obj_id, false);
                $original->loadFromDb();
                
                $newObj = new ilObjTest();
                $newObj->setType("tst");
    $counter = 2;
    while ($newObj->testTitleExists($newObj->getTitle() . " ($counter)")) 
                {
      $counter++;
    }
                $newObj->setTitle($original->getTitle() . " ($counter)");
                $newObj->setDescription($original->getDescription());
                $newObj->create(true);
                $newObj->createReference();
                $newObj->putInTree($_GET["ref_id"]);
                $newObj->setPermissions($_GET["ref_id"]);
//              $newObj->notify("new",$_GET["ref_id"],$_GET["parent_non_rbac_id"],$_GET["ref_id"],$newObj->getRefId());
                
                $newObj->author = $original->getAuthor();
                $newObj->introduction = $original->getIntroduction();
                $newObj->mark_schema = $original->mark_schema;
                $newObj->sequence_settings = $original->getSequenceSettings();
                $newObj->score_reporting = $original->getScoreReporting();
                $newObj->reporting_date = $original->getReportingDate();
                $newObj->test_type = $original->getTestType();
                $newObj->nr_of_tries = $original->getNrOfTries();
                $newObj->processing_time = $original->getProcessingTime();
                $newObj->enable_processing_time = $original->getEnableProcessingTime();
                $newObj->starting_time = $original->getStartingTime();
                $newObj->ending_time = $original->getEndingTime();
                $newObj->ects_output = $original->ects_output;
                $newObj->ects_fx = $original->ects_fx;
                $newObj->ects_grades = $original->ects_grades;
                $newObj->random_test = $original->random_test;
                $newObj->random_question_count = $original->random_question_count;
                $newObj->setCountSystem($original->getCountSystem());
                $newObj->setMCScoring($original->getMCScoring());
                $newObj->saveToDb();            
                if ($original->isRandomTest())
                {
                        $newObj->saveRandomQuestionCount($newObj->random_question_count);
                        $original->cloneRandomQuestions($newObj->getTestId());
                }
                else
                {
                        // clone the questions
                        foreach ($original->questions as $key => $question_id)
                        {
                                $question = ilObjTest::_instanciateQuestion($question_id);
                                $newObj->questions[$key] = $question->duplicate();
        //                      $question->id = -1;
                                $original_id = ASS_Question::_getOriginalId($question_id);
                                $question = ilObjTest::_instanciateQuestion($newObj->questions[$key]);
                                $question->saveToDb($original_id);
                        }
                }
                
                $newObj->saveToDb();

                // clone meta data
                include_once("Services/MetaData/classes/class.ilMD.php");
                $md = new ilMD($original->getId(),0,$original->getType());
                $new_md =& $md->cloneMD($newObj->getId(),0,$newObj->getType());
        }

        function _getRefIdFromObjId($obj_id)
        {
                global $ilDB;

                $query = sprintf("SELECT ref_id FROM object_reference WHERE obj_id=%s",
                        $ilDB->quote($obj_id)
                        
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        return $row["ref_id"];
                }
                return 0;
        }
        
        function createRandomSolutionsForAllUsers()
        {
                global $ilDB;
                global $ilUser;
                
                $db =& $ilDB->db;
                $sequence_arr = array_flip($this->questions);
                $sequence = join($sequence_arr, ",");
                require_once("./classes/class.ilObjUser.php");
                $logins = ilObjUser::_getAllUserData(array("login"));

                foreach ($logins as $login)
                {
                        $user_id = $login["usr_id"];
                        $old_active = $this->getActiveTestUser($user_id);
                        if ($old_active) {
                                $query = sprintf("UPDATE tst_active SET lastindex = %s, sequence = %s, postponed = %s, tries = %s WHERE user_fi = %s AND test_fi = %s",
                                        $db->quote("0"),
                                        $db->quote($sequence),
                                        $db->quote(""),
                                        $db->quote("1"),
                                        $db->quote($user_id),
                                        $db->quote($this->getTestId())
                                );
                        } else {
                                $sequence_arr = array_flip($this->questions);
                                $sequence = join($sequence_arr, ",");
                                $query = sprintf("INSERT INTO tst_active (active_id, user_fi, test_fi, sequence, postponed, lastindex, tries, TIMESTAMP) VALUES (NULL, %s, %s, %s, %s, %s, %s, NULL)",
                                        $db->quote($user_id),
                                        $db->quote($this->getTestId()),
                                        $db->quote($sequence),
                                        $db->quote(""),
                                        $db->quote("0"),
                                        $db->quote("1")
                                );
                        }
                        $db->query($query);
                }
                foreach ($this->questions as $question_id) {
                        $question =& ilObjTest::_instanciateQuestion($question_id);
                        foreach ($logins as $login)
                        {
                                $question->createRandomSolution($this->getTestId(), $login["usr_id"]);
                        }
                }
        }

        function &getEvaluationUsers($user_id)
        {
                $users = array();
                $query = sprintf("SELECT tst_eval_users.user_fi, usr_data.firstname, usr_data.lastname FROM tst_eval_users, usr_data WHERE tst_eval_users.test_fi = %s AND tst_eval_users.evaluator_fi = %s AND tst_eval_users.user_fi = usr_data.usr_id",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($user_id . "")
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $users[$row["user_fi"]] = trim($row["firstname"] ." " . $row["lastname"]);
                        }
                }
                return $users;
        }

        function &getEvaluationGroups($user_id)
        {
                $groups = array();
                $query = sprintf("SELECT group_fi FROM tst_eval_groups WHERE test_fi = %s AND evaluator_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($user_id . "")
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows())
                {
                        while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC))
                        {
                                $groups[$row["group_fi"]] = $row["group_fi"];
                        }
                }
                return $groups;
        }
        
        function removeSelectedUser($user_id, $evaluator_id)
        {
                $query = sprintf("DELETE FROM tst_eval_users WHERE test_fi = %s AND user_fi = %s AND evaluator_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($user_id . ""),
                        $this->ilias->db->quote($evaluator_id . "")
                );
                $result = $this->ilias->db->query($query);
        }

        function addSelectedUser($user_id, $evaluator_id)
        {
                $query = sprintf("SELECT user_fi FROM tst_eval_users WHERE test_fi = %s AND evaluator_fi = %s AND user_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($evaluator_id . ""),
                        $this->ilias->db->quote($user_id . "")
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows() < 1)
                {
                        $query = sprintf("INSERT INTO tst_eval_users (eval_users_id, test_fi, evaluator_fi, user_fi, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($this->getTestId() . ""),
                                $this->ilias->db->quote($evaluator_id . ""),
                                $this->ilias->db->quote($user_id . "")
                        );
                        $result = $this->ilias->db->query($query);
                }
        }

        function removeSelectedGroup($group_id, $evaluator_id)
        {
                $query = sprintf("DELETE FROM tst_eval_groups WHERE test_fi = %s AND group_fi = %s AND evaluator_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($group_id . ""),
                        $this->ilias->db->quote($evaluator_id . "")
                );
                $result = $this->ilias->db->query($query);
        }

        function addSelectedGroup($group_id, $evaluator_id)
        {
                $query = sprintf("SELECT group_fi FROM tst_eval_groups WHERE test_fi = %s AND evaluator_fi = %s AND group_fi = %s",
                        $this->ilias->db->quote($this->getTestId() . ""),
                        $this->ilias->db->quote($evaluator_id . ""),
                        $this->ilias->db->quote($group_id . "")
                );
                $result = $this->ilias->db->query($query);
                if ($result->numRows() < 1)
                {
                        $query = sprintf("INSERT INTO tst_eval_groups (eval_groups_id, test_fi, evaluator_fi, group_fi, TIMESTAMP) VALUES (NULL, %s, %s, %s, NULL)",
                                $this->ilias->db->quote($this->getTestId() . ""),
                                $this->ilias->db->quote($evaluator_id . ""),
                                $this->ilias->db->quote($group_id . "")
                        );
                        $result = $this->ilias->db->query($query);
                }
        }
        
        function getQuestionCount()
        {
                $num = 0;
                
                if ($this->isRandomTest())
                {
                        if ($this->getRandomQuestionCount())
                        {
                                $num = $this->getRandomQuestionCount();
                        }
                                else
                        {
                                $qpls =& $this->getRandomQuestionpools();
                                foreach ($qpls as $data)
                                {
                                        $num += $data["count"];
                                }
                        }
                }
                        else
                {
                        $num = count($this->questions);
                }
                return $num;
        }
        
        function _goto($a_target)
        {
                global $rbacsystem, $ilErr, $lng;

                include_once 'classes/class.ilSearch.php';
                        
                // Added this additional check (ParentConditions) to avoid calls of objects inside e.g courses.
                // Will be replaced in future releases by ilAccess::checkAccess()
                if ($rbacsystem->checkAccess("read", $a_target) and ilSearch::_checkParentConditions($a_target))
                {
                        ilUtil::redirect("assessment/test.php?cmd=run&ref_id=$a_target");
                }
                else
                {
                        $ilErr->raiseError($lng->txt("msg_no_perm_read_lm"), $ilErr->FATAL);
                }
        }       

        function removeNonRandomTestData()
        {
                // delete eventually set questions of a previous non-random test
                $this->removeAllTestEditings();
                $query = sprintf("DELETE FROM tst_test_question WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                $this->questions = array();
                $this->saveCompleteStatus();
        }
        
        function removeRandomTestData()
        {
                // delete eventually set random question pools of a previous random test
                $this->removeAllTestEditings();
                $query = sprintf("DELETE FROM tst_test_random WHERE test_fi = %s",
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                $this->questions = array();
                $this->saveCompleteStatus();
        }
        
        function logAction($logtext = "", $question_id = "")
        {
                global $ilUser;

                $original_id = "";
                if (strcmp($question_id, "") != 0)
                {
                        $original_id = ASS_Question::_getOriginalId($question_id);
                }
                include_once "./classes/class.ilObjAssessmentFolder.php";
                ilObjAssessmentFolder::_addLog($ilUser->id, $this->getId(), $logtext, $question_id, $original_id);
        }
        
        function _getObjectIDFromTestID($test_id)
        {
                global $ilDB;
                $object_id = FALSE;
                $query = sprintf("SELECT obj_fi FROM tst_tests WHERE test_id = %s",
                        $ilDB->quote($test_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        $object_id = $row["obj_fi"];
                }
                return $object_id;
        }

        function _getTestIDFromObjectID($object_id)
        {
                global $ilDB;
                $test_id = FALSE;
                $query = sprintf("SELECT test_id FROM tst_tests WHERE obj_fi = %s",
                        $ilDB->quote($object_id . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        $test_id = $row["test_id"];
                }
                return $test_id;
        }

        function getTextAnswer($user_id, $question_id)
        {
                $res = "";
                if (($user_id) && ($question_id))
                {
                        $query = sprintf("SELECT value1 FROM tst_solutions WHERE user_fi = %s AND test_fi = %s AND question_fi = %s",
                                $this->ilias->db->quote($user_id . ""),
                                $this->ilias->db->quote($this->getTestId() . ""),
                                $this->ilias->db->quote($question_id . "")
                        );
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows() == 1)
                        {
                                $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                                $res = $row["value1"];
                        }
                }
                return $res;
        }
        
        function getQuestiontext($question_id)
        {
                $res = "";
                if ($question_id)
                {
                        $query = sprintf("SELECT question_text FROM qpl_questions WHERE question_id = %s",
                                $this->ilias->db->quote($question_id . "")
                        );
                        $result = $this->ilias->db->query($query);
                        if ($result->numRows() == 1)
                        {
                                $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                                $res = $row["question_text"];
                        }
                }
                return $res;            
        }
        
        function &getInvitedUsers($user_id="", $order="login, lastname, firstname")
        {
                $result_array = array();

                if (is_numeric($user_id))
                        $query = sprintf("SELECT usr_id, login, lastname, firstname, t.clientip, test.submitted as test_finished, matriculation, IF(test.active_id IS NULL,0,1) as test_started " .
                                                         "FROM tst_invited_user t, usr_data ".
                                                         "LEFT JOIN tst_active test ON test.user_fi=usr_id AND test.test_fi=t.test_fi ".
                                                         "WHERE t.test_fi = %s and t.user_fi=usr_id AND usr_id=%s ".
                                                         "ORDER BY %s",
                                $this->ilias->db->quote($this->test_id),
                                $user_id,
                                $order
                        );
                else 
                {
                        $query = sprintf("SELECT usr_id, login, lastname, firstname, t.clientip, test.submitted as test_finished, matriculation, IF(test.active_id IS NULL,0,1) as test_started " .                                                                                     
                                                         "FROM tst_invited_user t, usr_data ".
                                                         "LEFT JOIN tst_active test ON test.user_fi=usr_id AND test.test_fi=t.test_fi ".
                                                         "WHERE t.test_fi = %s and t.user_fi=usr_id ".
                                                         "ORDER BY %s",
                                $this->ilias->db->quote($this->test_id),
                                $order
                        );
                }
                
                return $this->getArrayData($query, "usr_id");
        }
        
        function &getUserData($ids)
        {
                if (!is_array($ids) || count($ids) ==0)
                        return array();
                        
                $result_array = array();
                        
                $query = sprintf("SELECT usr_id, login, lastname, firstname, client_ip as clientip FROM usr_data WHERE usr_id IN (%s) ORDER BY login",                  
                        join ($ids,",")
                );
                                
                return $this->getArrayData ($query, "usr_id");          
        }
        
        function &getArrayData($query, $id_field)
        {       
                return ilObjTest::_getArrayData ($query, $id_field);
        }
        
        function &_getArrayData($query, $id_field)
        {       
                global $ilDB;
                $result = $ilDB->query($query);
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $result_array[$row->$id_field]= $row;
                }
                return ($result_array)?$result_array:array();
        }

        function &getGroupData($ids)
        {
                if (!is_array($ids) || count($ids) ==0)
                        return array();
                        
                $result_array = array();
                        
                $query = sprintf("SELECT ref_id, title, description FROM `grp_data` g, object_data o, object_reference r WHERE o.obj_id=grp_id AND o.obj_id = r.obj_id AND ref_id IN (%s)",                     
                        join ($ids,",")
                );
                
                return $this->getArrayData ($query, "ref_id");          
        }
        
        function &getRoleData($ids)
        {
                if (!is_array($ids) || count($ids) ==0)
                        return array();
                        
                $result_array = array();
                        
                $query = sprintf("SELECT obj_id, description, title FROM role_data, object_data o WHERE o.obj_id=role_id AND role_id IN (%s)",                  
                        join ($ids,",")
                );
                
                return $this->getArrayData ($query, "obj_id");          
        }


        function inviteGroup($group_id)
        {                       
                require_once "./classes/class.ilObjGroup.php";
                $group = new ilObjGroup($group_id);
                $members = $group->getGroupMemberIds();
                foreach ($members as $user_id)
                {
                        $this->inviteUser($user_id);
                }               
        }
        
        function inviteRole($role_id)
        {                       
                global $rbacreview;
                $members =  $rbacreview->assignedUsers($role_id,"usr_id");
                foreach ($members as $user_id)
                {
                        $this->inviteUser($user_id);
                }               
        }
        
        
        
        function disinviteUser($user_id)
        {
                $query = sprintf("DELETE FROM tst_invited_user WHERE test_fi = %s AND user_fi = %s",
                        $this->ilias->db->quote($this->test_id),
                        $this->ilias->db->quote($user_id)
                );
                $result = $this->ilias->db->query($query);      
        }

        function inviteUser($user_id, $client_ip="")
        {
                $query = sprintf("INSERT IGNORE INTO tst_invited_user (test_fi, user_fi, clientip) VALUES (%s, %s, %s)",
                        $this->ilias->db->quote($this->test_id),
                        $this->ilias->db->quote($user_id),
                        $this->ilias->db->quote($client_ip)
                );
                
                $result = $this->ilias->db->query($query);
        }
        
                
        function setClientIP($user_id, $client_ip) {            
                $query = sprintf("UPDATE tst_invited_user SET clientip=%s WHERE test_fi=%s and user_fi=%s",
                                $this->ilias->db->quote($client_ip),
                                $this->ilias->db->quote($this->test_id),
                                $this->ilias->db->quote($user_id)
                );
                $insertresult = $this->ilias->db->query($query);
        }
        
        function &getAllSolutionValues()
        {
                global $ilUser;
                $query = sprintf("SELECT * FROM tst_solutions WHERE user_fi = %s AND test_fi = %s GROUP BY question_fi",
                        $this->ilias->db->quote($ilUser->id),
                        $this->ilias->db->quote($this->getTestId())
                );
                $result = $this->ilias->db->query($query);
                
                $result_array = array();
                while ($row = $result->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        array_push($result_array, $row->question_fi);
                }
                return $result_array;
        }
        

        function isOnlineTest() {
                return $this->getTestType()==TYPE_ONLINE_TEST;
        }
        
        
        
        function _getSolvedQuestions ($test_fi, $user_fi, $question_fi = null) {
                global $ilDB;
                if (is_numeric($question_fi))
                        $query = sprintf("SELECT question_fi, solved FROM tst_active_qst_sol_settings " .
                                                 "WHERE user_fi = %s AND test_fi = %s AND question_fi=%s",
                                                        $ilDB->quote($user_fi),
                                                        $ilDB->quote($test_fi),
                                                        $question_fi
                        );
                else $query = sprintf("SELECT question_fi, solved FROM tst_active_qst_sol_settings " .
                                                 "WHERE user_fi = %s AND test_fi = %s",
                        $ilDB->quote($user_fi),
                        $ilDB->quote($test_fi)
                );
                return ilObjTest::_getArrayData ($query, "question_fi");                
        }
        
        
        function setQuestionSetSolved ($value, $question_id, $user_id) {
                $query = sprintf("REPLACE INTO tst_active_qst_sol_settings SET solved=%s, question_fi=%s, test_fi=%s, user_fi=%s",
                        $this->ilias->db->quote($value),
                        $this->ilias->db->quote($question_id),
                        $this->ilias->db->quote($this->test_id),
                        $this->ilias->db->quote($user_id)
                );
                
                $this->ilias->db->query($query);                                
        }
        
        
        function setActiveTestSubmitted($user_id) {
                $query = sprintf("UPDATE tst_active SET submitted=1, tries=1, submittimestamp=NOW() WHERE test_fi=%s AND user_fi=%s",
                        $this->ilias->db->quote($this->test_id),
                        $this->ilias->db->quote($user_id)
                );              
                $this->ilias->db->query($query);                                
                
        }
        
        function isActiveTestSubmitted($user_id = null) {
                global $ilUser;
                if (!is_numeric($user_id))
                        $user_id = $ilUser->getId();
                        
                $query = sprintf("SELECT submitted FROM tst_active WHERE test_fi=%s AND user_fi=%s AND submitted=1",
                        $this->ilias->db->quote($this->test_id),
                        $this->ilias->db->quote($user_id)
                );              
                $result = $this->ilias->db->query($query);              
                
                return  $result->numRows() == 1;
                
        }
        function hasNrOfTriesRestriction () {
                return $this->getNrOfTries() != 0;
        }
        
        
        function isNrOfTriesReached ($tries) {
                return $tries >= (int) $this->getNrOfTries();
        }
        
        
        function getAllTestResults () {
                $participants = $this->getInvitedUsers("matriculation");
                $results = array();             
                $row = array("matriculation" =>  $this->lng->txt("matriculation"),
                                        "lastname" =>  $this->lng->txt("lastname"),
                                        "firstname" => $this->lng->txt("firstname"),                                    
                                        "reached_points" => $this->lng->txt("tst_reached_points"),
                                        "max_points" => $this->lng->txt("tst_maximum_points"),
                                        "percent_value" => $this->lng->txt("tst_percent_solved"),
                                        "mark" => $this->lng->txt("tst_mark"),
                                        "ects" => $this->lng->txt("ects_grade"));
                
                $results[] = $row;
                
                foreach ($participants as $user_id => $user_rec) {
                        $row = array();         
                        $reached_points = 0;
                        $max_points = 0;                                        
                        
                        foreach ($this->questions as $value)
                        {
                        //$value = $this->questions[$seq];
//                              $ilBench->start("getTestResult","instanciate question"); 
                                $question =& ilObjTest::_instanciateQuestion($value);
//                              $ilBench->stop("getTestResult","instanciate question"); 
                                if (is_object($question))
                                {
                                        $max_points += $question->getMaximumPoints();
                                        $reached_points += $question->getReachedPoints($user_id, $this->getTestId()); 
                                }
                        }
                        
                        if ($max_points > 0)
                        {
                                $percentvalue = $reached_points / $max_points;
                        }
                        else
                        {
                                $percentvalue = 0;
                        }                       
                        $mark_obj = $this->mark_schema->get_matching_mark($percentvalue * 100);
                        $passed = "";   
                        if ($mark_obj)
                        {
                                $mark = $mark_obj->get_official_name();
                                $ects_mark = $this->getECTSGrade($reached_points, $max_points);
                        }

                        $row = array(
                                        "matriculation" =>  $user_rec->matriculation,
                                        "lastname" =>  $user_rec->lastname,
                                        "firstname" => $user_rec->firstname,
                                        "reached_points" => $reached_points,
                                        "max_points" => $max_points,
                                        "percent_value" => $percentvalue,
                                        "mark" => $mark,
                                        "ects" => $ects_mark);
                        $results[] = $this->processCSVRow ($row, true);
                }                                                               
                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 getStartingTimeOfUser($user_id)
        {
                global $ilDB;
                
                if ($user_id < 1) return FALSE;
                $query = sprintf("SELECT tst_times.started FROM tst_times, tst_active WHERE tst_active.user_fi = %s AND tst_active.test_fi = %s AND tst_active.active_id = tst_times.active_fi ORDER BY tst_times.started",
                        $ilDB->quote($user_id . ""),
                        $ilDB->quote($this->getTestId() . "")
                );
                $result = $ilDB->query($query);
                if ($result->numRows())
                {
                        $row = $result->fetchRow(DB_FETCHMODE_ASSOC);
                        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 FALSE;
                        }
                }
                else
                {
                        return FALSE;
                }
        }
        
        function isMaxProcessingTimeReached($starting_time)
        {
                if ($this->getEnableProcessingTime())
                {
                        $processing_time = $this->getProcessingTimeInSeconds();
                        $now = mktime();
                        if ($now > ($starting_time + $processing_time))
                        {
                                return TRUE;
                        }
                        else
                        {
                                return FALSE;
                        }
                }
                else
                {
                        return FALSE;
                }
        }
        

} // END class.ilObjTest

?>