class.assQuestion.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. |
   +----------------------------------------------------------------------------+
*/

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

class assQuestion
{
        protected $id;

        protected $title;

        protected $comment;

        protected $owner;

        protected $author;

        protected $question;

        protected $points;

        protected $est_working_time;

        protected $shuffle;

        protected $test_id;

        protected $obj_id;

        protected $ilias;

        protected $tpl;

        protected $lng;

        protected $outputType;

        protected $suggested_solutions;

        protected $original_id;

        protected $page;

        private $nr_of_tries;
        
        private $arrData;
        
        private $external_id;
        
        function __construct(
                $title = "",
                $comment = "",
                $author = "",
                $owner = -1,
                $question = ""
        )
        {
                global $ilias;
                global $lng;
                global $tpl;

                $this->ilias =& $ilias;
                $this->lng =& $lng;
                $this->tpl =& $tpl;

                $this->original_id = null;
                $this->title = $title;
                $this->comment = $comment;
                $this->page = null;
                $this->author = $author;
                $this->setQuestion($question);
                if (!$this->author)
                {
                        $this->author = $this->ilias->account->fullname;
                }
                $this->owner = $owner;
                if ($this->owner <= 0)
                {
                        $this->owner = $this->ilias->account->id;
                }
                $this->id = -1;
                $this->test_id = -1;
                $this->suggested_solutions = array();
                $this->shuffle = 1;
                $this->external_id = '';
                $this->nr_of_tries = "";
                $this->setEstimatedWorkingTime(0,1,0);
                $this->outputType = OUTPUT_HTML;
                $this->arrData = array();
        }

        function fromXML(&$item, &$questionpool_id, &$tst_id, &$tst_object, &$question_counter, &$import_mapping)
        {
                include_once "./Modules/TestQuestionPool/classes/import/qti12/class." . $this->getQuestionType() . "Import.php";
                $classname = $this->getQuestionType() . "Import";
                $import = new $classname($this);
                $import->fromXML($item, $questionpool_id, $tst_id, $tst_object, $question_counter, $import_mapping);
        }
        
        function toXML($a_include_header = true, $a_include_binary = true, $a_shuffle = false, $test_output = false, $force_image_references = false)
        {
                include_once "./Modules/TestQuestionPool/classes/export/qti12/class." . $this->getQuestionType() . "Export.php";
                $classname = $this->getQuestionType() . "Export";
                $export = new $classname($this);
                return $export->toXML($a_include_header, $a_include_binary, $a_shuffle, $test_output, $force_image_references);
        }

        function isComplete()
        {
                return false;
        }

        function questionTitleExists($questionpool_id, $title)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT * FROM qpl_questions WHERE obj_fi = %s AND title = %s",
                        array('integer','text'),
                        array($questionpool_id, $title)
                );
                return ($result->numRows() == 1) ? TRUE : FALSE;
        }

        function setTitle($title = "")
        {
                $this->title = $title;
        }

        function setId($id = -1)
        {
                $this->id = $id;
        }

        function setTestId($id = -1)
        {
                $this->test_id = $id;
        }

        function setComment($comment = "")
        {
                $this->comment = $comment;
        }

        function setOutputType($outputType = OUTPUT_HTML)
        {
                $this->outputType = $outputType;
        }


        function setShuffle($shuffle = true)
        {
                if ($shuffle)
                {
                        $this->shuffle = 1;
                }
                        else
                {
                        $this->shuffle = 0;
                }
        }

        function setEstimatedWorkingTime($hour=0, $min=0, $sec=0)
        {
                $this->est_working_time = array("h" => (int)$hour, "m" => (int)$min, "s" => (int)$sec);
        }

        function keyInArray($searchkey, $array)
        {
                if ($searchKey)
                {
                        foreach ($array as $key => $value)
                        {
                                if (strcmp($key, $searchkey)==0)
                                {
                                        return true;
                                }
                        }
                }
                return false;
        }

        function setAuthor($author = "")
        {
                if (!$author)
                {
                        $author = $this->ilias->account->fullname;
                }
                $this->author = $author;
        }

        function setOwner($owner = "")
        {
                $this->owner = $owner;
        }

        function getTitle()
        {
                return $this->title;
        }

        function getId()
        {
                return $this->id;
        }

        function getShuffle()
        {
                return $this->shuffle;
        }

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

        function getComment()
        {
                return $this->comment;
        }

        function getOutputType()
        {
                return $this->outputType;
        }
        
        function supportsJavascriptOutput()
        {
                return FALSE;
        }

        function getEstimatedWorkingTime()
        {
                if (!$this->est_working_time)
                {
                        $this->est_working_time = array("h" => 0, "m" => 0, "s" => 0);
                }
                return $this->est_working_time;
        }

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

        function getOwner()
        {
                return $this->owner;
        }

        function getObjId()
        {
                return $this->obj_id;
        }

        function setObjId($obj_id = 0)
        {
                $this->obj_id = $obj_id;
        }

  function _getMaximumPoints($question_id) 
        {
                global $ilDB;

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

        function &_getQuestionInfo($question_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT qpl_questions.*, qpl_qst_type.type_tag FROM qpl_qst_type, qpl_questions WHERE qpl_questions.question_id = %s AND qpl_questions.question_type_fi = qpl_qst_type.question_type_id",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows())
                {
                        return $ilDB->fetchAssoc($result);
                }
                else return array();
        }
        
        public static function _getSuggestedSolutionCount($question_id)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT suggested_solution_id FROM qpl_sol_sug WHERE question_fi = %s",
                        array('integer'),
                        array($question_id)
                );
                return $result->numRows();
        }

        public static function _getSuggestedSolutionOutput($question_id)
        {
                $question =& assQuestion::_instanciateQuestion($question_id);
                if (!is_object($question)) return "";
                return $question->getSuggestedSolutionOutput();
        }

        public function getSuggestedSolutionOutput()
        {
                $output = array();
                foreach ($this->suggested_solutions as $solution)
                {
                        switch ($solution["type"])
                        {
                                case "lm":
                                case "st":
                                case "pg":
                                case "git":
                                        array_push($output, '<a href="' . assQuestion::_getInternalLinkHref($solution["internal_link"]) . '">' . $this->lng->txt("solution_hint") . '</a>');
                                        break;
                                case "file":
                                        array_push($output, '<a href="' . $this->getSuggestedSolutionPathWeb() . $solution["value"]["name"] . '">' . ((strlen($solution["value"]["filenme"])) ? ilUtil::prepareFormOutput($solution["value"]["filenme"]) : $this->lng->txt("solution_hint")) . '</a>');
                                        break;
                                case "text":
                                        array_push($output, $this->prepareTextareaOutput($solution["value"]));
                                        break;
                        }
                }
                return join($output, "<br />");
        }

        function &_getSuggestedSolution($question_id, $subquestion_index = 0)
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT * FROM qpl_sol_sug WHERE question_fi = %s AND subquestion_index = %s",
                        array('integer','integer'),
                        array($question_id, $subquestion_index)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return array(
                                "internal_link" => $row["internal_link"],
                                "import_id" => $row["import_id"]
                        );
                }
                else
                {
                        return array();
                }
        }
        
        public function getSuggestedSolutions()
        {
                return $this->suggested_solutions;
        }
        
        function _getReachedPoints($active_id, $question_id, $pass = NULL)
        {
                global $ilDB;

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

        function getReachedPoints($active_id, $pass = NULL)
        {
                return round($this->_getReachedPoints($active_id, $this->getId(), $pass), 2);
        }
        
        function getMaximumPoints()
        {
                return $this->points;
        }
        
        public function calculateResultsFromSolution($active_id, $pass = NULL)
        {
                global $ilDB;
                global $ilUser;
                if (is_null($pass))
                {
                        include_once "./Modules/Test/classes/class.ilObjTest.php";
                        $pass = ilObjTest::_getPass($active_id);
                }
                $reached_points = $this->calculateReachedPoints($active_id, $pass);
                if (is_null($reached_points)) $reached_points = 0;

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

                $next_id = $ilDB->nextId("tst_test_result");
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_result (test_result_id, active_fi, question_fi, pass, points, tstamp) VALUES (%s, %s, %s, %s, %s, %s)", 
                        array("integer","integer", "integer", "integer", "float", "integer"),
                        array(
                                $next_id,
                                $active_id,
                                $this->getId(),
                                $pass,
                                $reached_points,
                                time()
                        )
                );
                include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                {
                        $this->logAction(sprintf($this->lng->txtlng("assessment", "log_user_answered_question", ilObjAssessmentFolder::_getLogLanguage()), $reached_points), $active_id, $this->getId());
                }

                // update test pass results
                $this->_updateTestPassResults($active_id, $pass);

                // Update objective status
                include_once 'Modules/Course/classes/class.ilCourseObjectiveResult.php';
                ilCourseObjectiveResult::_updateObjectiveResult($ilUser->getId(),$active_id,$this->getId());

        }

        function saveWorkingData($active_id, $pass = NULL)
        {
                $this->calculateResultsFromSolution($active_id, $pass);
        }
        
        function _updateTestResultCache($active_id)
        {
                global $ilDB;

                include_once "./Modules/Test/classes/class.ilObjTest.php";
                $pass = ilObjTest::_getResultPass($active_id);

                $result = $ilDB->queryF("SELECT tst_pass_result.* FROM tst_pass_result WHERE active_fi = %s AND pass = %s",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                $row = $ilDB->fetchAssoc($result);
                $max = $row['maxpoints'];
                $reached = $row['points'];
                include_once "./Modules/Test/classes/class.assMarkSchema.php";
                $percentage = (!$max) ? 0 : ($reached / $max) * 100.0;
                $mark = ASS_MarkSchema::_getMatchingMarkFromActiveId($active_id, $percentage);
                $affectedRows = $ilDB->manipulateF("DELETE FROM tst_result_cache WHERE active_fi = %s",
                        array('integer'),
                        array($active_id)
                );
                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_result_cache (active_fi, pass, max_points, reached_points, mark_short, mark_official, passed, failed, tstamp) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s)",
                        array(
                                'integer',
                                'integer',
                                'float',
                                'float',
                                'text',
                                'text',
                                'integer',
                                'integer',
                                'integer'
                        ),
                        array(
                                $active_id,
                                strlen($pass) ? $pass : 0,
                                strlen($max) ? $max : 0,
                                strlen($reached) ? $reached : 0,
                                strlen($mark["short_name"]) ? $mark["short_name"] : " ",
                                strlen($mark["official_name"]) ? $mark["official_name"] : " ",
                                ($mark["passed"]) ? 1 : 0,
                                (!$mark["passed"]) ? 1 : 0,
                                time()
                        )
                );
        }

        function _updateTestPassResults($active_id, $pass)
        {
                global $ilDB;
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                $data = ilObjTest::_getQuestionCountAndPointsForPassOfParticipant($active_id, $pass);
                $time = ilObjTest::_getWorkingTimeOfParticipantForPass($active_id, $pass);
                // update test pass results
                $result = $ilDB->queryF("SELECT SUM(points) reachedpoints, COUNT(question_fi) answeredquestions FROM tst_test_result WHERE active_fi = %s AND pass = %s",
                        array('integer','integer'),
                        array($active_id, $pass)
                );
                if ($result->numRows() > 0)
                {
                        $row = $ilDB->fetchAssoc($result);
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_pass_result WHERE active_fi = %s AND pass = %s",
                                array('integer','integer'),
                                array($active_id, $pass)
                        );
                        $affectedRows = $ilDB->manipulateF("INSERT INTO tst_pass_result (active_fi, pass, points, maxpoints, questioncount, answeredquestions, workingtime, tstamp) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)",
                                array(
                                        'integer',
                                        'integer',
                                        'float',
                                        'float',
                                        'integer',
                                        'integer',
                                        'integer',
                                        'integer'
                                ),
                                array(
                                        $active_id,
                                        $pass,
                                        ($row["reachedpoints"]) ? $row["reachedpoints"] : 0,
                                        $data["points"],
                                        $data["count"],
                                        $row["answeredquestions"],
                                        $time,
                                        time()
                                )
                        );
                }
                assQuestion::_updateTestResultCache($active_id);
                return array(
                        'active_fi' => $active_id,
                        'pass' => $pass,
                        'points' => ($row["reachedpoints"]) ? $row["reachedpoints"] : 0,
                        'maxpoints' => $data["points"],
                        'questioncount' => $data["count"],
                        'answeredquestions' => $row["answeredquestions"],
                        'workingtime' => $time,
                        'tstamp' => time()
                );
        }
        
        function logAction($logtext = "", $active_id = "", $question_id = "")
        {
                global $ilUser;

                $original_id = "";
                if (strcmp($question_id, "") != 0)
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $original_id = assQuestion::_getOriginalId($question_id);
                }
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                ilObjAssessmentFolder::_addLog($ilUser->id, ilObjTest::_getObjectIDFromActiveID($active_id), $logtext, $question_id, $original_id);
        }
        
        function _logAction($logtext = "", $active_id = "", $question_id = "")
        {
                global $ilUser;

                $original_id = "";
                if (strcmp($question_id, "") != 0)
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $original_id = assQuestion::_getOriginalId($question_id);
                }
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                ilObjAssessmentFolder::_addLog($ilUser->id, ilObjTest::_getObjectIDFromActiveID($active_id), $logtext, $question_id, $original_id);
        }
        
        function moveUploadedMediaFile($file, $name)
        {
                $mediatempdir = CLIENT_WEB_DIR . "/assessment/temp";
                if (!@is_dir($mediatempdir)) ilUtil::createDirectory($mediatempdir);
                $temp_name = tempnam($mediatempdir, $name . "_____");
                $temp_name = str_replace("\\", "/", $temp_name);
                @unlink($temp_name);
                if (!ilUtil::moveUploadedFile($file, $name, $temp_name))
                {
                        return FALSE;
                }
                else
                {
                        return $temp_name;
                }
        }
        
        function getSuggestedSolutionPath() {
                return CLIENT_WEB_DIR . "/assessment/$this->obj_id/$this->id/solution/";
        }

        function getJavaPath() {
                return CLIENT_WEB_DIR . "/assessment/$this->obj_id/$this->id/java/";
        }
        
        function getImagePath()
        {
                return CLIENT_WEB_DIR . "/assessment/$this->obj_id/$this->id/images/";
        }

        function getFlashPath() 
        {
                return CLIENT_WEB_DIR . "/assessment/$this->obj_id/$this->id/flash/";
        }

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

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

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

        function getFlashPathWeb()
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                $webdir = ilUtil::removeTrailingPathSeparators(CLIENT_WEB_DIR) . "/assessment/$this->obj_id/$this->id/flash/";
                return str_replace(ilUtil::removeTrailingPathSeparators(ILIAS_ABSOLUTE_PATH), ilUtil::removeTrailingPathSeparators(ILIAS_HTTP_PATH), $webdir);
        }
        
        function &getSolutionValues($active_id, $pass = NULL)
        {
                global $ilDB;

                $values = array();
                
                if (is_null($pass))
                {
                        $pass = $this->getSolutionMaxPass($active_id);
                }

                $result = $ilDB->queryF("SELECT * FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s ORDER BY solution_id",
                        array('integer','integer','integer'),
                        array($active_id, $this->getId(), $pass)
                );
                while   ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($values, $row);
                }

                return $values;
        }

        public static function _getSolutionValues($active_id, $question_id, $pass)
        {
                global $ilDB;

                $values = array();
                $result = $ilDB->queryF("SELECT * FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s ORDER BY solution_id",
                        array('integer','integer','integer'),
                        array($active_id, $question_id, $pass)
                );
                while   ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($values, $row);
                }

                return $values;
        }

        function isInUse($question_id = "")
        {
                global $ilDB;
                
                if ($question_id < 1) $question_id = $this->getId();
                $result = $ilDB->queryF("SELECT COUNT(qpl_questions.question_id) question_count FROM qpl_questions, tst_test_question WHERE qpl_questions.original_id = %s AND qpl_questions.question_id = tst_test_question.question_fi",
                        array('integer'),
                        array($question_id)
                );
                $row = $ilDB->fetchAssoc($result);
                $count = $row["question_count"];

                $result = $ilDB->queryF("SELECT DISTINCT tst_active.test_fi, qpl_questions.question_id FROM qpl_questions, tst_test_rnd_qst, tst_active WHERE qpl_questions.original_id = %s AND qpl_questions.question_id = tst_test_rnd_qst.question_fi AND tst_test_rnd_qst.active_fi = tst_active.active_id",
                        array('integer'),
                        array($question_id)
                );
                $count += $result->numRows();

                return $count;
        }

        function isClone($question_id = "")
        {
                global $ilDB;
                
                if ($question_id < 1) $question_id = $this->id;
                $result = $ilDB->queryF("SELECT original_id FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                $row = $ilDB->fetchAssoc($result);
                return ($row["original_id"] > 0) ? TRUE : FALSE;
        }

        function pcArrayShuffle($array)
        {
                $keys = array_keys($array);
                shuffle($keys);
                $result = array();
                foreach ($keys as $key)
                {
                        $result[$key] = $array[$key];
                }
                return $result;
        }

        function getQuestionTypeFromDb($question_id)
        {
                global $ilDB;

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

        function getAdditionalTableName()
        {
                return "";
        }
        
        function getAnswerTableName()
        {
                return "";
        }

        function deleteAnswers($question_id)
        {
                global $ilDB;
                $answer_table_name = $this->getAnswerTableName();
                if (is_array($answer_table_name))
                {
                        foreach ($answer_table_name as $table)
                        {
                                if (strlen($table))
                                {
                                        $affectedRows = $ilDB->manipulateF("DELETE FROM $table WHERE question_fi = %s",
                                                array('integer'),
                                                array($question_id)
                                        );
                                }
                        }
                }
                else
                {
                        if (strlen($answer_table_name))
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM $answer_table_name WHERE question_fi = %s",
                                        array('integer'),
                                        array($question_id)
                                );
                        }
                }
        }

        function deleteAdditionalTableData($question_id)
        {
                global $ilDB;
                $additional_table_name = $this->getAdditionalTableName();
                if (is_array($additional_table_name))
                {
                        foreach ($additional_table_name as $table)
                        {
                                if (strlen($table))
                                {
                                        $affectedRows = $ilDB->manipulateF("DELETE FROM $table WHERE question_fi = %s",
                                                array('integer'),
                                                array($question_id)
                                        );
                                }
                        }
                }
                else
                {
                        if (strlen($additional_table_name))
                        {
                                $affectedRows = $ilDB->manipulateF("DELETE FROM $additional_table_name WHERE question_fi = %s",
                                        array('integer'),
                                        array($question_id)
                                );
                        }
                }
        }

        protected function deletePageOfQuestion($question_id)
        {
                include_once "./Services/COPage/classes/class.ilPageObject.php";
                $page = new ilPageObject("qpl", $question_id);
                $page->delete();
                return true;
        }

        public function delete($question_id)
        {
                global $ilDB, $ilLog;
                
                if ($question_id < 1) return true; // nothing to do

                $result = $ilDB->queryF("SELECT obj_fi FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        $obj_id = $row["obj_fi"];
                }
                else
                {
                        return true; // nothing to do
                }
                try
                {
                        $this->deletePageOfQuestion($question_id);
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Could not delete page of question $question_id: $e");
                        return false;
                }
                
                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($affectedRows == 0) return false;

                try
                {
                        $this->deleteAdditionalTableData($question_id);
                        $this->deleteAnswers($question_id);
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Could not delete additional table data of question $question_id: $e");
                        return false;
                }

                try
                {
                        // delete the question in the tst_test_question table (list of test questions)
                        $affectedRows = $ilDB->manipulateF("DELETE FROM tst_test_question WHERE question_fi = %s", 
                                array('integer'),
                                array($question_id)
                        );
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Could not delete delete question $question_id from a test: $e");
                        return false;
                }

                try
                {
                        // delete suggested solutions contained in the question
                        $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_sol_sug WHERE question_fi = %s", 
                                array('integer'),
                                array($question_id)
                        );
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Could not delete suggested solutions of question $question_id: $e");
                        return false;
                }
                                
                try
                {
                        $directory = CLIENT_WEB_DIR . "/assessment/" . $obj_id . "/$question_id";
                        if (preg_match("/\d+/", $obj_id) and preg_match("/\d+/", $question_id) and is_dir($directory))
                        {
                                include_once "./Services/Utilities/classes/class.ilUtil.php";
                                ilUtil::delDir($directory);
                        }
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Could not delete question file directory $directory of question $question_id: $e");
                        return false;
                }

                try
                {
                        include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                        $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $question_id);
                        // remaining usages are not in text anymore -> delete them
                        // and media objects (note: delete method of ilObjMediaObject
                        // checks whether object is used in another context; if yes,
                        // the object is not deleted!)
                        foreach($mobs as $mob)
                        {
                                ilObjMediaObject::_removeUsage($mob, "qpl:html", $question_id);
                                if (ilObjMediaObject::_exists($mob))
                                {
                                        $mob_obj =& new ilObjMediaObject($mob);
                                        $mob_obj->delete();
                                }
                        }
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Error deleting the media objects of question $question_id: $e");
                        return false;
                }

                try
                {
                        // update question count of question pool
                        include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                        ilObjQuestionPool::_updateQuestionCount($this->getObjId());
                }
                catch (Exception $e)
                {
                        $ilLog->write("EXCEPTION: Error updating the question pool question count of question pool " . $this->getObjId() . " when deleting question $question_id: $e");
                        return false;
                }
                return true;
        }

        function getTotalAnswers()
        {
                return $this->_getTotalAnswers($this->id);
        }

        function _getTotalAnswers($a_q_id)
        {
                global $ilDB;

                // get all question references to the question id
                $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE original_id = %s OR question_id = %s",
                        array('integer','integer'),
                        array($a_q_id, $a_q_id)
                );
                if ($result->numRows() == 0)
                {
                        return 0;
                }
                $found_id = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($found_id, $row["question_id"]);
                }

                $result = $ilDB->query("SELECT * FROM tst_test_result WHERE " . $ilDB->in('question_fi', $found_id, false, 'integer'));

                return $result->numRows();
        }


        function _getTotalRightAnswers($a_q_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE original_id = %s OR question_id = %s",
                        array('integer','integer'),
                        array($a_q_id, $a_q_id)
                );
                if ($result->numRows() == 0)
                {
                        return 0;
                }
                $found_id = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($found_id, $row["question_id"]);
                }
                $result = $ilDB->query("SELECT * FROM tst_test_result WHERE " . $ilDB->in('question_fi', $found_id, false, 'integer'));
                $answers = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        $reached = $row["points"]; 
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $max = assQuestion::_getMaximumPoints($row["question_fi"]);
                        array_push($answers, array("reached" => $reached, "max" => $max));
                }
                $max = 0.0;
                $reached = 0.0;
                foreach ($answers as $key => $value)
                {
                        $max += $value["max"];
                        $reached += $value["reached"];
                }
                if ($max > 0)
                {
                        return $reached / $max;
                }
                else
                {
                        return 0;
                }
        }

        function _getTitle($a_q_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT title FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($a_q_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["title"];
                }
                else
                {
                        return "";
                }
        }
        
        function _getQuestionText($a_q_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT question_text FROM qpl_questions WHERE question_id = %s",
                                array('integer'),
                                array($a_q_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["question_text"];
                }
                else
                {
                        return "";
                }
        }
        
        
        function copyXHTMLMediaObjectsOfQuestion($a_q_id)
        {
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $a_q_id);
                foreach ($mobs as $mob)
                {
                        ilObjMediaObject::_saveUsage($mob, "qpl:html", $this->getId());
                }
        }
        
        function syncXHTMLMediaObjectsOfQuestion()
        {
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");
                $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $this->getId());
                foreach ($mobs as $mob)
                {
                        ilObjMediaObject::_saveUsage($mob, "qpl:html", $this->original_id);
                }
        }
        
        function createPageObject()
        {
                $qpl_id = $this->getObjId();

                include_once "./Services/COPage/classes/class.ilPageObject.php";
                $this->page = new ilPageObject("qpl", 0);
                $this->page->setId($this->getId());
                $this->page->setParentId($qpl_id);
                $this->page->setXMLContent("<PageObject><PageContent>".
                        "<Question QRef=\"il__qst_".$this->getId()."\"/>".
                        "</PageContent></PageObject>");
                $this->page->create();
        }

        function copyPageOfQuestion($a_q_id)
        {
                if ($a_q_id > 0)
                {
                        include_once "./Services/COPage/classes/class.ilPageObject.php";
                        $page = new ilPageObject("qpl", $a_q_id);

                        $xml = str_replace("il__qst_".$a_q_id, "il__qst_".$this->id, $page->getXMLContent());
                        $this->page->setXMLContent($xml);
                        $this->page->saveMobUsage($xml);
                        $this->page->updateFromXML();
                }
        }

        function getPageOfQuestion()
        {
                include_once "./Services/COPage/classes/class.ilPageObject.php";
                $page = new ilPageObject("qpl", $this->id);
                return $page->getXMLContent();
        }

        function _getQuestionType($question_id) 
        {
                global $ilDB;

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

        function _getQuestionTitle($question_id) 
        {
                global $ilDB;
                
                if ($question_id < 1) return "";

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

        function setOriginalId($original_id)
        {
                $this->original_id = $original_id;
        }
        
        function getOriginalId()
        {
                return $this->original_id;
        }

        function loadFromDb($question_id)
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT external_id FROM qpl_questions WHERE question_id = %s",
                        array("integer"),
                        array($question_id)
                );
                if ($result->numRows() == 1)
                {
                        $data = $ilDB->fetchAssoc($result);
                        $this->external_id = $data['external_id'];
                }
                
                $result = $ilDB->queryF("SELECT * FROM qpl_sol_sug WHERE question_fi = %s",
                        array('integer'),
                        array($this->getId())
                );
                $this->suggested_solutions = array();
                if ($result->numRows())
                {
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $value = (is_array(unserialize($row["value"]))) ? unserialize($row["value"]) : ilRTE::_replaceMediaObjectImageSrc($row["value"], 1);
                                $this->suggested_solutions[$row["subquestion_index"]] = array(
                                        "type" => $row["type"],
                                        "value" => $value,
                                        "internal_link" => $row["internal_link"],
                                        "import_id" => $row["import_id"]
                                );
                        }
                }
        }

        public function createNewQuestion()
        {
                global $ilDB, $ilUser;
                
                $complete = "0";
                $estw_time = $this->getEstimatedWorkingTime();
                $estw_time = sprintf("%02d:%02d:%02d", $estw_time['h'], $estw_time['m'], $estw_time['s']);
                $obj_id = ($this->getObjId() <= 0) ? (ilObject::_lookupObjId((strlen($_GET["ref_id"])) ? $_GET["ref_id"] : $_POST["sel_qpl"])) : $this->getObjId();
                if ($obj_id > 0)
                {
                        $next_id = $ilDB->nextId('qpl_questions');
                        $affectedRows = $ilDB->insert("qpl_questions", array(
                                "question_id" => array("integer", $next_id),
                                "question_type_fi" => array("integer", $this->getQuestionTypeID()),
                                "obj_fi" => array("integer", $obj_id),
                                "title" => array("text", NULL),
                                "description" => array("text", NULL),
                                "author" => array("text", $this->getAuthor()),
                                "owner" => array("integer", $ilUser->getId()),
                                "question_text" => array("clob", NULL),
                                "points" => array("float", 0),
                                "nr_of_tries" => array("integer", 1),
                                "working_time" => array("text", $estw_time),
                                "complete" => array("text", $complete),
                                "created" => array("integer", time()),
                                "external_id" => array("text", $this->getExternalID()),
                                "original_id" => array("integer", NULL),
                                "tstamp" => array("integer", 0)
                        ));
                        $this->setId($next_id);
                        // create page object of question
                        $this->createPageObject();
                }
                return $this->getId();
        }

        public function saveQuestionDataToDb($original_id = "")
        {
                global $ilDB;

                $estw_time = $this->getEstimatedWorkingTime();
                $estw_time = sprintf("%02d:%02d:%02d", $estw_time['h'], $estw_time['m'], $estw_time['s']);

                // cleanup RTE images which are not inserted into the question text
                include_once("./Services/RTE/classes/class.ilRTE.php");
                if ($this->getId() == -1)
                {
                        // Neuen Datensatz schreiben
                        $next_id = $ilDB->nextId('qpl_questions');
                        $affectedRows = $ilDB->insert("qpl_questions", array(
                                "question_id" => array("integer", $next_id),
                                "question_type_fi" => array("integer", $this->getQuestionTypeID()),
                                "obj_fi" => array("integer", $this->getObjId()),
                                "title" => array("text", $this->getTitle()),
                                "description" => array("text", $this->getComment()),
                                "author" => array("text", $this->getAuthor()),
                                "owner" => array("integer", $this->getOwner()),
                                "question_text" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getQuestion(), 0)),
                                "points" => array("float", $this->getMaximumPoints()),
                                "working_time" => array("text", $estw_time),
                                "nr_of_tries" => array("integer", (strlen($this->getNrOfTries())) ? $this->getNrOfTries() : 1),
                                "created" => array("integer", time()),
                                "original_id" => array("integer", ($original_id) ? $original_id : NULL),
                                "external_id" => array("text", $this->getExternalID()),
                                "tstamp" => array("integer", time())
                        ));
                        $this->setId($next_id);
                        // create page object of question
                        $this->createPageObject();
                }
                else
                {
                        // Vorhandenen Datensatz aktualisieren
                        $affectedRows = $ilDB->update("qpl_questions", array(
                                "obj_fi" => array("integer", $this->getObjId()),
                                "title" => array("text", $this->getTitle()),
                                "description" => array("text", $this->getComment()),
                                "author" => array("text", $this->getAuthor()),
                                "question_text" => array("clob", ilRTE::_replaceMediaObjectImageSrc($this->getQuestion(), 0)),
                                "points" => array("float", $this->getMaximumPoints()),
                                "nr_of_tries" => array("integer", (strlen($this->getNrOfTries())) ? $this->getNrOfTries() : 1),
                                "working_time" => array("text", $estw_time),
                                "external_id" => array("text", $this->getExternalID()),
                                "tstamp" => array("integer", time())
                        ), array(
                        "question_id" => array("integer", $this->getId())
                        ));
                }
        }

        function saveToDb($original_id = "")
        {
                global $ilDB;

                $this->updateSuggestedSolutions();
                
                // remove unused media objects from ILIAS
                $this->cleanupMediaObjectUsage();

                $complete = "0";
                if ($this->isComplete())
                {
                        $complete = "1";
                }

                        // update the question time stamp and completion status
                $affectedRows = $ilDB->manipulateF("UPDATE qpl_questions SET tstamp = %s, owner = %s, complete = %s WHERE question_id = %s",
                        array('integer','integer','text', 'integer'),
                        array(time(), ($this->getOwner() <= 0) ? $this->ilias->account->id : $this->getOwner(), $complete, $this->getId())
                );

                // update question count of question pool
                include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                ilObjQuestionPool::_updateQuestionCount($this->obj_id);
        }
        
        protected function onDuplicate($source_question_id)
        {
                $this->duplicateSuggestedSolutionFiles($source_question_id);
        }
        
        protected function onCopy($source_questionpool_id, $source_question_id)
        {
                $this->copySuggestedSolutionFiles($source_questionpool_id, $source_question_id);
        }
        
        public function deleteSuggestedSolutions()
        {
                global $ilDB;
                // delete the links in the qpl_sol_sug table
                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_sol_sug WHERE question_fi = %s",
                        array('integer'),
                        array($this->getId())
                );
                // delete the links in the int_link table
                include_once "./Services/COPage/classes/class.ilInternalLink.php";
                ilInternalLink::_deleteAllLinksOfSource("qst", $this->getId());
                $this->suggested_solutions = array();
                ilUtil::delDir($this->getSuggestedSolutionPath());
        }
        
        function getSuggestedSolution($subquestion_index = 0)
        {
                if (array_key_exists($subquestion_index, $this->suggested_solutions))
                {
                        return $this->suggested_solutions[$subquestion_index];
                }
                else
                {
                        return array();
                }
        }

        function getSuggestedSolutionTitle($subquestion_index = 0)
        {
                if (array_key_exists($subquestion_index, $this->suggested_solutions))
                {
                        $title = $this->suggested_solutions[$subquestion_index]["internal_link"];
                        // TO DO: resolve internal link an get link type and title
                }
                else
                {
                        $title = "";
                }
                return $title;
        }

        function setSuggestedSolution($solution_id = "", $subquestion_index = 0, $is_import = false)
        {
                if (strcmp($solution_id, "") != 0)
                {
                        $import_id = "";
                        if ($is_import)
                        {
                                $import_id = $solution_id;
                                $solution_id = $this->_resolveInternalLink($import_id);
                        }
                        $this->suggested_solutions[$subquestion_index] = array(
                                "internal_link" => $solution_id,
                                "import_id" => $import_id
                        );
                }
        }

        protected function duplicateSuggestedSolutionFiles($question_id)
        {
                global $ilLog;

                foreach ($this->suggested_solutions as $index => $solution)
                {
                        if (strcmp($solution["type"], "file") == 0)
                        {
                                $filepath = $this->getSuggestedSolutionPath();
                                $filepath_original = str_replace("/$this->id/solution", "/$question_id/solution", $filepath);
                                if (!file_exists($filepath))
                                {
                                        ilUtil::makeDirParents($filepath);
                                }
                                $filename = $solution["value"]["name"];
                                if (strlen($filename))
                                {
                                        if (!copy($filepath_original . $filename, $filepath . $filename))
                                        {
                                                $ilLog->write("File could not be duplicated!!!!", $ilLog->ERROR);
                                                $ilLog->write("object: " . print_r($this, TRUE), $ilLog->ERROR);
                                        }
                                }
                        }
                }
        }

        protected function syncSuggestedSolutionFiles($original_id)
        {
                global $ilLog;

                $filepath = $this->getSuggestedSolutionPath();
                $filepath_original = str_replace("/$this->id/solution", "/$original_id/solution", $filepath);
                ilUtil::delDir($filepath_original);
                foreach ($this->suggested_solutions as $index => $solution)
                {
                        if (strcmp($solution["type"], "file") == 0)
                        {
                                if (!file_exists($filepath_original))
                                {
                                        ilUtil::makeDirParents($filepath_original);
                                }
                                $filename = $solution["value"]["name"];
                                if (strlen($filename))
                                {
                                        if (!@copy($filepath . $filename, $filepath_original . $filename))
                                        {
                                                $ilLog->write("File could not be duplicated!!!!", $ilLog->ERROR);
                                                $ilLog->write("object: " . print_r($this, TRUE), $ilLog->ERROR);
                                        }
                                }
                        }
                }
        }

        protected function copySuggestedSolutionFiles($source_questionpool_id, $source_question_id)
        {
                global $ilLog;

                foreach ($this->suggested_solutions as $index => $solution)
                {
                        if (strcmp($solution["type"], "file") == 0)
                        {
                                $filepath = $this->getSuggestedSolutionPath();
                                $filepath_original = str_replace("/$this->obj_id/$this->id/solution", "/$source_questionpool_id/$source_question_id/solution", $filepath);
                                if (!file_exists($filepath))
                                {
                                        ilUtil::makeDirParents($filepath);
                                }
                                $filename = $solution["value"]["name"];
                                if (strlen($filename))
                                {
                                        if (!copy($filepath_original . $filename, $filepath . $filename))
                                        {
                                                $ilLog->write("File could not be copied!!!!", $ilLog->ERROR);
                                                $ilLog->write("object: " . print_r($this, TRUE), $ilLog->ERROR);
                                        }
                                }
                        }
                }
        }

        public function updateSuggestedSolutions($original_id = "")
        {
                global $ilDB;

                $id = (strlen($original_id) && is_numeric($original_id)) ? $original_id : $this->getId();
                include_once "./Services/COPage/classes/class.ilInternalLink.php";
                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_sol_sug WHERE question_fi = %s",
                        array('integer'),
                        array($id)
                );
                ilInternalLink::_deleteAllLinksOfSource("qst", $id);
                include_once("./Services/RTE/classes/class.ilRTE.php");
                foreach ($this->suggested_solutions as $index => $solution)
                {
                        $next_id = $ilDB->nextId('qpl_sol_sug');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO qpl_sol_sug (suggested_solution_id, question_fi, type, value, internal_link, import_id, subquestion_index, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)", 
                                array("integer","integer", "text", "text", "text", "text", "integer","integer"),
                                array(
                                        $next_id,
                                        $id,
                                        $solution["type"],
                                        ilRTE::_replaceMediaObjectImageSrc((is_array($solution["value"])) ? serialize($solution["value"]) : $solution["value"], 0),
                                        $solution["internal_link"],
                                        NULL,
                                        $index,
                                        time()
                                )
                        );
                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $solution["internal_link"], $matches))
                        {
                                ilInternalLink::_saveLink("qst", $id, $matches[2], $matches[3], $matches[1]);
                        }
                }
                if (strlen($original_id) && is_numeric($original_id)) $this->syncSuggestedSolutionFiles($id);
                $this->cleanupMediaObjectUsage();
        }
        
        function saveSuggestedSolution($type, $solution_id = "", $subquestion_index = 0, $value = "")
        {
                global $ilDB;

                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_sol_sug WHERE question_fi = %s AND subquestion_index = %s", 
                        array("integer", "integer"),
                        array(
                                $this->getId(), 
                                $subquestion_index
                        )
                );
                
                $next_id = $ilDB->nextId('qpl_sol_sug');
                include_once("./Services/RTE/classes/class.ilRTE.php");
                $affectedRows = $ilDB->manipulateF("INSERT INTO qpl_sol_sug (suggested_solution_id, question_fi, type, value, internal_link, import_id, subquestion_index, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)", 
                        array("integer","integer", "text", "text", "text", "text", "integer","integer"),
                        array(
                                $next_id,
                                $this->getId(),
                                $type,
                                ilRTE::_replaceMediaObjectImageSrc((is_array($value)) ? serialize($value) : $value, 0),
                                $solution_id,
                                NULL,
                                $subquestion_index,
                                time()
                        )                       
                );
                if ($affectedRows == 1)
                {
                        $this->suggested_solutions["subquestion_index"] = array(
                                "type" => $type,
                                "value" => $value,
                                "internal_link" => $solution_id,
                                "import_id" => ""
                        );
                }
                $this->cleanupMediaObjectUsage();
        }

        function _resolveInternalLink($internal_link)
        {
                if (preg_match("/il_(\d+)_(\w+)_(\d+)/", $internal_link, $matches))
                {
                        include_once "./Services/COPage/classes/class.ilInternalLink.php";
                        include_once "./Modules/LearningModule/classes/class.ilLMObject.php";
                        include_once "./Modules/Glossary/classes/class.ilGlossaryTerm.php";
                        switch ($matches[2])
                        {
                                case "lm":
                                        $resolved_link = ilLMObject::_getIdForImportId($internal_link);
                                        break;
                                case "pg":
                                        $resolved_link = ilInternalLink::_getIdForImportId("PageObject", $internal_link);
                                        break;
                                case "st":
                                        $resolved_link = ilInternalLink::_getIdForImportId("StructureObject", $internal_link);
                                        break;
                                case "git":
                                        $resolved_link = ilInternalLink::_getIdForImportId("GlossaryItem", $internal_link);
                                        break;
                                case "mob":
                                        $resolved_link = ilInternalLink::_getIdForImportId("MediaObject", $internal_link);
                                        break;
                        }
                        if (strcmp($resolved_link, "") == 0)
                        {
                                $resolved_link = $internal_link;
                        }
                }
                else
                {
                        $resolved_link = $internal_link;
                }
                return $resolved_link;
        }
        
        function _resolveIntLinks($question_id)
        {
                global $ilDB;
                $resolvedlinks = 0;
                $result = $ilDB->queryF("SELECT * FROM qpl_sol_sug WHERE question_fi = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $internal_link = $row["internal_link"];
                                include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                                $resolved_link = assQuestion::_resolveInternalLink($internal_link);
                                if (strcmp($internal_link, $resolved_link) != 0)
                                {
                                        // internal link was resolved successfully
                                        $affectedRows = $ilDB->manipulateF("UPDATE qpl_sol_sug SET internal_link = %s WHERE suggested_solution_id = %s",
                                                array('text','integer'),
                                                array($resolved_link, $row["suggested_solution_id"])
                                        );
                                        $resolvedlinks++;
                                }
                        }
                }
                if ($resolvedlinks)
                {
                        // there are resolved links -> reenter theses links to the database

                        // delete all internal links from the database
                        include_once "./Services/COPage/classes/class.ilInternalLink.php";
                        ilInternalLink::_deleteAllLinksOfSource("qst", $question_id);

                        $result = $ilDB->queryF("SELECT * FROM qpl_sol_sug WHERE question_fi = %s",
                                array('integer'),
                                array($question_id)
                        );
                        if ($result->numRows())
                        {
                                while ($row = $ilDB->fetchAssoc($result))
                                {
                                        if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $row["internal_link"], $matches))
                                        {
                                                ilInternalLink::_saveLink("qst", $question_id, $matches[2], $matches[3], $matches[1]);
                                        }
                                }
                        }
                }
        }
        
        function _getInternalLinkHref($target = "")
        {
                global $ilDB;
                $linktypes = array(
                        "lm" => "LearningModule",
                        "pg" => "PageObject",
                        "st" => "StructureObject",
                        "git" => "GlossaryItem",
                        "mob" => "MediaObject"
                );
                $href = "";
                if (preg_match("/il__(\w+)_(\d+)/", $target, $matches))
                {
                        $type = $matches[1];
                        $target_id = $matches[2];
                        include_once "./Services/Utilities/classes/class.ilUtil.php";
                        switch($linktypes[$matches[1]])
                        {
                                case "LearningModule":
                                        $href = "./goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "PageObject":
                                case "StructureObject":
                                        $href = "./goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "GlossaryItem":
                                        $href = "./goto.php?target=" . $type . "_" . $target_id;
                                        break;
                                case "MediaObject":
                                        $href = "./ilias.php?baseClass=ilLMPresentationGUI&obj_type=" . $linktypes[$type] . "&cmd=media&ref_id=".$_GET["ref_id"]."&mob_id=".$target_id;
                                        break;
                        }
                }
                return $href;
        }
        
        function _getOriginalId($question_id)
        {
                global $ilDB;
                $result = $ilDB->queryF("SELECT * FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() > 0)
                {
                        $row = $ilDB->fetchAssoc($result);
                        if ($row["original_id"] > 0)
                        {
                                return $row["original_id"];
                        }
                        else
                        {
                                return $row["question_id"];
                        }
                }
                else
                {
                        return "";
                }
        }

        function syncWithOriginal()
        {
                global $ilDB;

                if ($this->getOriginalId())
                {
                        $id = $this->getId();
                        $original = $this->getOriginalId();

                        $this->setId($this->getOriginalId());
                        $this->setOriginalId(NULL);
                        $this->saveToDb();
                        $this->deletePageOfQuestion($original);
                        $this->createPageObject();
                        $this->copyPageOfQuestion($id);

                        $this->setId($id);
                        $this->setOriginalId($original);
                        $this->updateSuggestedSolutions($original);
                        $this->syncFeedbackGeneric();
                        $this->syncXHTMLMediaObjectsOfQuestion();
                }
        }

        function createRandomSolution($test_id, $user_id)
        {
        }

        function _questionExists($question_id)
        {
                global $ilDB;

                if ($question_id < 1)
                {
                        return false;
                }
                
                $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() == 1)
                {
                        return true;
                }
                else
                {
                        return false;
                }
        }

        function &_instanciateQuestion($question_id) 
        {
                if (strcmp($question_id, "") != 0)
                {
                        $question_type = assQuestion::_getQuestionType($question_id);
                        if (!strlen($question_type)) return null;
                        assQuestion::_includeClass($question_type);
                        $question = new $question_type();
                        $question->loadFromDb($question_id);
                        return $question;
                }
        }
        
        function getPoints()
        {
                if (strcmp($this->points, "") == 0)
                {
                        return 0;
                }
                else
                {
                        return $this->points;
                }
        }

        
        function setPoints($a_points)
        {
                $this->points = $a_points;
        }
        
        function getSolutionMaxPass($active_id)
        {
                return $this->_getSolutionMaxPass($this->getId(), $active_id);
        }

        function _getSolutionMaxPass($question_id, $active_id)
        {
/*              include_once "./Modules/Test/classes/class.ilObjTest.php";
                $pass = ilObjTest::_getPass($active_id);
                return $pass;*/

                // the following code was the old solution which added the non answered
                // questions of a pass from the answered questions of the previous pass
                // with the above solution, only the answered questions of the last pass are counted
                global $ilDB;

                $result = $ilDB->queryF("SELECT MAX(pass) maxpass FROM tst_test_result WHERE active_fi = %s AND question_fi = %s",
                        array('integer','integer'),
                        array($active_id, $question_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return ($row["maxpass"]) ? $row["maxpass"] : 0;
                }
                else
                {
                        return 0;
                }
        }

        function _isWriteable($question_id, $user_id)
        {
                global $ilDB;

                if (($question_id < 1) || ($user_id < 1))
                {
                        return false;
                }
                
                $result = $ilDB->queryF("SELECT obj_fi FROM qpl_questions WHERE question_id = %s",
                        array('integer'),
                        array($question_id)
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        $qpl_object_id = $row["obj_fi"];
                        include_once "./Modules/TestQuestionPool/classes/class.ilObjQuestionPool.php";
                        return ilObjQuestionPool::_isWriteable($qpl_object_id, $user_id);
                }
                else
                {
                        return false;
                }
        }

        function _isUsedInRandomTest($question_id = "")
        {
                global $ilDB;
                
                if ($question_id < 1) return 0;
                $result = $ilDB->queryF("SELECT test_random_question_id FROM tst_test_rnd_qst WHERE question_fi = %s",
                        array('integer'),
                        array($question_id)
                );
                return $result->numRows();
        }

        function calculateReachedPoints($active_id, $pass = NULL, $points = 0)
        {
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                $count_system = ilObjTest::_getCountSystem($active_id);
                if ($count_system == 1)
                {
                        if ($points != $this->getMaximumPoints())
                        {
                                $points = 0;
                        }
                }
                $score_cutting = ilObjTest::_getScoreCutting($active_id);
                if ($score_cutting == 0)
                {
                        if ($points < 0)
                        {
                                $points = 0;
                        }
                }
                return $points;
        }

        public static function _isWorkedThrough($active_id, $question_id, $pass = NULL)
        {
                global $ilDB;

                $points = 0;
                if (is_null($pass))
                {
                        include_once "./Modules/TestQuestionPool/classes/class.assQuestion.php";
                        $pass = assQuestion::_getSolutionMaxPass($question_id, $active_id);
                }
                $result = $ilDB->queryF("SELECT solution_id FROM tst_solutions WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                        array('integer','integer','integer'),
                        array($active_id, $question_id, $pass)
                );
                if ($result->numRows())
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

        public static function _areAnswered($a_user_id,$a_question_ids)
        {
                global $ilDB;

                $res = $ilDB->queryF("SELECT DISTINCT(question_fi) FROM tst_test_result JOIN tst_active ".
                        "ON (active_id = active_fi) ".
                        "WHERE " . $ilDB->in('question_fi', $a_question_ids, false, 'integer') .
                        " AND user_fi = %s",
                        array('integer'),
                        array($a_user_id)
                );
                return ($res->numRows() == count($a_question_ids)) ? true : false;
        }
        
        function isHTML($a_text)
        {
                if (preg_match("/<[^>]*?>/", $a_text))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE; 
                }
        }
        
        function prepareTextareaOutput($txt_output, $prepare_for_latex_output = FALSE)
        {
                include_once "./Services/Utilities/classes/class.ilUtil.php";
                return ilUtil::prepareTextareaOutput($txt_output, $prepare_for_latex_output);
        }

        function QTIMaterialToString($a_material)
        {
                $result = "";
                for ($i = 0; $i < $a_material->getMaterialCount(); $i++)
                {
                        $material = $a_material->getMaterial($i);
                        if (strcmp($material["type"], "mattext") == 0)
                        {
                                $result .= $material["material"]->getContent();
                        }
                        if (strcmp($material["type"], "matimage") == 0)
                        {
                                $matimage = $material["material"];
                                if (preg_match("/(il_([0-9]+)_mob_([0-9]+))/", $matimage->getLabel(), $matches))
                                {
                                        // import an mediaobject which was inserted using tiny mce
                                        if (!is_array($_SESSION["import_mob_xhtml"])) $_SESSION["import_mob_xhtml"] = array();
                                        array_push($_SESSION["import_mob_xhtml"], array("mob" => $matimage->getLabel(), "uri" => $matimage->getUri()));
                                }
                        }
                }
                return $result;
        }
        
        function addQTIMaterial(&$a_xml_writer, $a_material, $close_material_tag = TRUE, $add_mobs = TRUE)
        {
                include_once "./Services/RTE/classes/class.ilRTE.php";
                include_once("./Services/MediaObjects/classes/class.ilObjMediaObject.php");

                $a_xml_writer->xmlStartTag("material");
                $attrs = array(
                        "texttype" => "text/plain"
                );
                if ($this->isHTML($a_material))
                {
                        $attrs["texttype"] = "text/xhtml";
                }
                $a_xml_writer->xmlElement("mattext", $attrs, ilRTE::_replaceMediaObjectImageSrc($a_material, 0));
                if ($add_mobs)
                {
                        $mobs = ilObjMediaObject::_getMobsOfObject("qpl:html", $this->getId());
                        foreach ($mobs as $mob)
                        {
                                $moblabel = "il_" . IL_INST_ID . "_mob_" . $mob;
                                if (strpos($a_material, "mm_$mob") !== FALSE)
                                {
                                        if (ilObjMediaObject::_exists($mob))
                                        {
                                                $mob_obj =& new ilObjMediaObject($mob);
                                                $imgattrs = array(
                                                        "label" => $moblabel,
                                                        "uri" => "objects/" . "il_" . IL_INST_ID . "_mob_" . $mob . "/" . $mob_obj->getTitle()
                                                );
                                        }
                                        $a_xml_writer->xmlElement("matimage", $imgattrs, NULL);
                                }
                        }
                }               
                if ($close_material_tag) $a_xml_writer->xmlEndTag("material");
        }
        
        function createNewImageFileName($image_filename)
        {
                $extension = "";
                if (preg_match("/.*\.(png|jpg|gif|jpeg)$/i", $image_filename, $matches))
                {
                        $extension = "." . $matches[1];
                }
                $image_filename = md5($image_filename) . $extension;
                return $image_filename;
        }

        function _setReachedPoints($active_id, $question_id, $points, $maxpoints, $pass = NULL, $manualscoring = FALSE, $rescoring = FALSE)
        {
                global $ilDB;
                
                if ($points <= $maxpoints)
                {
                        if (is_null($pass))
                        {
                                $pass = assQuestion::_getSolutionMaxPass($question_id, $active_id);
                        }

                        // retrieve the already given points
                        $old_points = 0;
                        $result = $ilDB->queryF("SELECT points FROM tst_test_result WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                                array('integer','integer','integer'),
                                array($active_id, $question_id, $pass)
                        );
                        $manual = ($manualscoring) ? 1 : 0;
                        if ($result->numRows())
                        {
                                $row = $ilDB->fetchAssoc($result);
                                $old_points = $row["points"];
                                $affectedRows = $ilDB->manipulateF("UPDATE tst_test_result SET points = %s, manual = %s, tstamp = %s WHERE active_fi = %s AND question_fi = %s AND pass = %s",
                                        array('float', 'integer', 'integer', 'integer', 'integer', 'integer'),
                                        array($points, $manual, time(), $active_id, $question_id, $pass)
                                );
                        }
                        else
                        {
                                $next_id = $ilDB->nextId('tst_test_result');
                                $affectedRows = $ilDB->manipulateF("INSERT INTO tst_test_result (test_result_id, active_fi, question_fi, points, pass, manual, tstamp) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                                        array('integer', 'integer','integer', 'float', 'integer', 'integer','integer'),
                                        array($next_id, $active_id, $question_id, $points, $pass, $manual, time())
                                );
                        }
                        assQuestion::_updateTestPassResults($active_id, $pass);
                        // finally update objective result
                        include_once "./Modules/Test/classes/class.ilObjTest.php";
                        include_once './Modules/Course/classes/class.ilCourseObjectiveResult.php';
                        ilCourseObjectiveResult::_updateObjectiveResult(ilObjTest::_getUserIdFromActiveId($active_id),$question_id,$points);

                        include_once ("./Modules/Test/classes/class.ilObjAssessmentFolder.php");
                        if (ilObjAssessmentFolder::_enabledAssessmentLogging())
                        {
                                global $lng, $ilUser;
                                include_once "./Modules/Test/classes/class.ilObjTestAccess.php";
                                $username = ilObjTestAccess::_getParticipantData($active_id);
                                if ($rescoring)
                                {
                                        assQuestion::_logAction(sprintf($lng->txtlng("assessment", "log_answer_changed_points_rescore", ilObjAssessmentFolder::_getLogLanguage()), $username, $old_points, $points, $ilUser->getFullname() . " (" . $ilUser->getLogin() . ")"), $active_id, $question_id);
                                }
                                else
                                {
                                        assQuestion::_logAction(sprintf($lng->txtlng("assessment", "log_answer_changed_points", ilObjAssessmentFolder::_getLogLanguage()), $username, $old_points, $points, $ilUser->getFullname() . " (" . $ilUser->getLogin() . ")"), $active_id, $question_id);
                                }
                        }
                        
                        return TRUE;
                }
                        else
                {
                        return FALSE;
                }
        }
        
        function getQuestion() 
        {
                return $this->question;
        }

        function setQuestion($question = "") 
        {
                $this->question = $question;
        }

        function getQuestionType()
        {
                // must be overwritten in every parent class
                return "";
        }
        
        function getQuestionTypeID()
        {
                global $ilDB;
                
                $result = $ilDB->queryF("SELECT question_type_id FROM qpl_qst_type WHERE type_tag = %s",
                        array('text'),
                        array($this->getQuestionType())
                );
                if ($result->numRows() == 1)
                {
                        $row = $ilDB->fetchAssoc($result);
                        return $row["question_type_id"];
                }
                return 0;
        }
        
        function saveFeedbackGeneric($correctness, $feedback)
        {
                global $ilDB;
                
                switch ($correctness)
                {
                        case 0:
                                $correctness = 0;
                                break;
                        case 1:
                        default:
                                $correctness = 1;
                                break;
                }
                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_fb_generic WHERE question_fi = %s AND correctness = %s",
                        array('integer', 'text'),
                        array($this->getId(), $correctness)
                );
                if (strlen($feedback))
                {
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $next_id = $ilDB->nextId('qpl_fb_generic');
                        $affectedRows = $ilDB->manipulateF("INSERT INTO qpl_fb_generic (feedback_id, question_fi, correctness, feedback, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                array('integer','integer','text','text','integer'),
                                array($next_id, $this->getId(), $correctness, ilRTE::_replaceMediaObjectImageSrc($feedback, 0), time())
                        );
                }
        }
        
        function getFeedbackGeneric($correctness)
        {
                global $ilDB;
                
                $feedback = "";
                $result = $ilDB->queryF("SELECT * FROM qpl_fb_generic WHERE question_fi = %s AND correctness = %s",
                        array('integer', 'text'),
                        array($this->getId(), $correctness)
                );
                if ($result->numRows())
                {
                        $row = $ilDB->fetchAssoc($result);
                        include_once("./Services/RTE/classes/class.ilRTE.php");
                        $feedback = ilRTE::_replaceMediaObjectImageSrc($row["feedback"], 1);
                }
                return $feedback;
        }

        function duplicateFeedbackGeneric($original_id)
        {
                global $ilDB;
                
                $feedback = "";
                $result = $ilDB->queryF("SELECT * FROM qpl_fb_generic WHERE question_fi = %s",
                        array('integer'),
                        array($original_id)
                );
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $next_id = $ilDB->nextId('qpl_fb_generic');
                                $affectedRows = $ilDB->manipulateF("INSERT INTO qpl_fb_generic (feedback_id, question_fi, correctness, feedback, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                        array('integer','integer','text','text','integer'),
                                        array($next_id, $this->getId(), $row["correctness"], $row["feedback"], time())
                                );
                        }
                }
        }
        
        function syncFeedbackGeneric()
        {
                global $ilDB;

                $feedback = "";

                // delete generic feedback of the original
                $affectedRows = $ilDB->manipulateF("DELETE FROM qpl_fb_generic WHERE question_fi = %s",
                        array('integer'),
                        array($this->original_id)
                );
                        
                // get generic feedback of the actual question
                $result = $ilDB->queryF("SELECT * FROM qpl_fb_generic WHERE question_fi = %s",
                        array('integer'),
                        array($this->getId())
                );

                // save generic feedback to the original
                if ($result->numRows())
                {
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $next_id = $ilDB->nextId('qpl_fb_generic');
                                $affectedRows = $ilDB->manipulateF("INSERT INTO qpl_fb_generic (feedback_id, question_fi, correctness, feedback, tstamp) VALUES (%s, %s, %s, %s, %s)",
                                        array('integer','integer','text','text','integer'),
                                        array($next_id, $this->original_id, $row["correctness"], $row["feedback"], time())
                                );
                        }
                }
        }
        
        function getRTETextWithMediaObjects()
        {
                // must be called in parent classes. add additional RTE text in the parent
                // classes and call this method to add the standard RTE text
                $collected = $this->getQuestion();
                $collected .= $this->getFeedbackGeneric(0);
                $collected .= $this->getFeedbackGeneric(1);
                foreach ($this->suggested_solutions as $solution_array)
                {
                        $collected .= $solution_array["value"];
                }
                return $collected;
        }

        function cleanupMediaObjectUsage()
        {
                $combinedtext = $this->getRTETextWithMediaObjects();
                include_once("./Services/RTE/classes/class.ilRTE.php");
                ilRTE::_cleanupMediaObjectUsage($combinedtext, "qpl:html", $this->getId());
        }
        
        function &getInstances()
        {
                global $ilDB;

                $result = $ilDB->queryF("SELECT question_id FROM qpl_questions WHERE original_id = %s",
                        array("integer"),
                        array($this->getId())
                );
                $instances = array();
                $ids = array();
                while ($row = $ilDB->fetchAssoc($result))
                {
                        array_push($ids, $row["question_id"]);
                }
                foreach ($ids as $question_id)
                {
                        // check non random tests
                        $result = $ilDB->queryF("SELECT tst_tests.obj_fi FROM tst_tests, tst_test_question WHERE tst_test_question.question_fi = %s AND tst_test_question.test_fi = tst_tests.test_id",
                                array("integer"),
                                array($question_id)
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $instances[$row['obj_fi']] = ilObject::_lookupTitle($row['obj_fi']);
                        }
                        // check random tests
                        $result = $ilDB->queryF("SELECT tst_tests.obj_fi FROM tst_tests, tst_test_rnd_qst, tst_active WHERE tst_test_rnd_qst.active_fi = tst_active.active_id AND tst_test_rnd_qst.question_fi = %s AND tst_tests.test_id = tst_active.test_fi",
                                array("integer"),
                                array($question_id)
                        );
                        while ($row = $ilDB->fetchAssoc($result))
                        {
                                $instances[$row['obj_fi']] = ilObject::_lookupTitle($row['obj_fi']);
                        }
                }
                include_once "./Modules/Test/classes/class.ilObjTest.php";
                foreach ($instances as $key => $value)
                {
                        $instances[$key] = array("obj_id" => $key, "title" => $value, "author" => ilObjTest::_lookupAuthor($key), "refs" => ilObject::_getAllReferences($key));
                }
                return $instances;
        }

        function _needsManualScoring($question_id)
        {
                include_once "./Modules/Test/classes/class.ilObjAssessmentFolder.php";
                $scoring = ilObjAssessmentFolder::_getManualScoringTypes();
                $questiontype = assQuestion::_getQuestionType($question_id);
                if (in_array($questiontype, $scoring))
                {
                        return TRUE;
                }
                else
                {
                        return FALSE;
                }
        }

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

        static function _includeClass($question_type, $gui = 0)
        {
                $type = $question_type;
                if ($gui) $type .= "GUI";
                if (file_exists("./Modules/TestQuestionPool/classes/class.".$type.".php"))
                {
                        include_once "./Modules/TestQuestionPool/classes/class.".$type.".php";
                }
                else
                {
                        global $ilPluginAdmin;
                        $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_MODULE, "TestQuestionPool", "qst");
                        foreach ($pl_names as $pl_name)
                        {
                                $pl = ilPlugin::getPluginObject(IL_COMP_MODULE, "TestQuestionPool", "qst", $pl_name);
                                if (strcmp($pl->getQuestionType(), $question_type) == 0)
                                {
                                        $pl->includeClass("class.".$type.".php");
                                }
                        }
                }
        }

        static function _getQuestionTypeName($type_tag)
        {
                if (file_exists("./Modules/TestQuestionPool/classes/class.".$type_tag.".php"))
                {
                        global $lng;
                        return $lng->txt($type_tag);
                }
                else
                {
                        global $ilPluginAdmin;
                        $pl_names = $ilPluginAdmin->getActivePluginsForSlot(IL_COMP_MODULE, "TestQuestionPool", "qst");
                        foreach ($pl_names as $pl_name)
                        {
                                $pl = ilPlugin::getPluginObject(IL_COMP_MODULE, "TestQuestionPool", "qst", $pl_name);
                                if (strcmp($pl->getQuestionType(), $type_tag) == 0)
                                {
                                        return $pl->getQuestionTypeTranslation();
                                }
                        }
                }
                return "";
        }

        function &_instanciateQuestionGUI($question_id) 
        {
                if (strcmp($question_id, "") != 0)
                {
                        $question_type = assQuestion::_getQuestionType($question_id);
                        $question_type_gui = $question_type . "GUI";
                        assQuestion::_includeClass($question_type, 1);
                        $question_gui = new $question_type_gui();
                        $question_gui->object->loadFromDb($question_id);
                        return $question_gui;
                }
        }
        
        public function setExportDetailsXLS(&$adapter, $startrow, $active_id, $pass)
        {
                return $startrow;
        }

        public function __get($value)
        {
                switch ($value)
                {
                        case "id":
                                return $this->getId();
                                break;
                        case "title":
                                return $this->getTitle();
                                break;
                        case "comment":
                                return $this->getComment();
                                break;
                        case "owner":
                                return $this->getOwner();
                                break;
                        case "author":
                                return $this->getAuthor();
                                break;
                        case "question":
                                return $this->getQuestion();
                                break;
                        case "points":
                                return $this->getPoints();
                                break;
                        case "est_working_time":
                                return $this->getEstimatedWorkingTime();
                                break;
                        case "shuffle":
                                return $this->getShuffle();
                                break;
                        case "test_id":
                                return $this->getTestId();
                                break;
                        case "obj_id":
                                return $this->getObjId();
                                break;
                        case "ilias":
                                return $this->ilias;
                                break;
                        case "tpl":
                                return $this->tpl;
                                break;
                        case "page":
                                return $this->page;
                                break;
                        case "outputType":
                                return $this->getOutputType();
                                break;
                        case "suggested_solutions":
                                return $this->getSuggestedSolutions();
                                break;
                        case "original_id":
                                return $this->getOriginalId();
                                break;
                        default:
                                if (array_key_exists($value, $this->arrData))
                                {
                                        return $this->arrData[$value];
                                }
                                else
                                {
                                        return null;
                                }
                                break;
                }
        }

        public function __set($key, $value)
        {
                switch ($key)
                {
                        case "id":
                                $this->setId($value);
                                break;
                        case "title":
                                $this->setTitle($value);
                                break;
                        case "comment":
                                $this->setComment($value);
                                break;
                        case "owner":
                                $this->setOwner($value);
                                break;
                        case "author":
                                $this->setAuthor($value);
                                break;
                        case "question":
                                $this->setQuestion($value);
                                break;
                        case "points":
                                $this->setPoints($value);
                                break;
                        case "est_working_time":
                                if (is_array($value))
                                {
                                        $this->setEstimatedWorkingTime($value["h"], $value["m"], $value["s"]);
                                }
                                break;
                        case "shuffle":
                                $this->setShuffle($value);
                                break;
                        case "test_id":
                                $this->setTestId($value);
                                break;
                        case "obj_id":
                                $this->setObjId($value);
                                break;
                        case "outputType":
                                $this->setOutputType($value);
                                break;
                        case "original_id":
                                $this->setOriginalId($value);
                                break;
                        case "page":
                                $this->page =& $value;
                                break;
                        default:
                                $this->arrData[$key] = $value;
                                break;
                }
        }
        
        public function getNrOfTries()
        {
                return $this->nr_of_tries;
        }
        
        public function setNrOfTries($a_nr_of_tries)
        {
                $this->nr_of_tries = $a_nr_of_tries;
        }
        
        public function getExternalID()
        {
                if (!strlen($this->external_id))
                {
                        if ($this->getId() > 0)
                        {
                                return "il_".IL_INST_ID."_qst_".$this->getId();
                        }
                        else
                        {
                                return uniqid('', true);
                        }
                }
                else
                {
                        return $this->external_id;
                }
        }
        
        public function setExternalID($id)
        {
                $this->external_id = $id;
        }
}

?>