chamilo / chamilo-lms

     *

     * @return int

     */

	public static function getCategoryForQuestion($questionId, $courseId ="")

    {

		$result = 0;

        if (empty($courseId) || $courseId == "") {

            $courseId = api_get_course_int_id();

        }

		$table = Database::get_course_table(TABLE_QUIZ_QUESTION_REL_CATEGORY);

        $questionId = intval($questionId);

		$sql = "SELECT category_id

		        FROM $table

		        WHERE question_id = $questionId AND c_id = $courseId";

		$res = Database::query($sql);

		if (Database::num_rows($res) > 0) {

            $data = Database::fetch_array($res);

			$result = $data['category_id'];

		}

		return $result;

	}

	/**

	 * true if question id has a category

     *

     * @return int is id of test category

     */

    public static function get_category_id_for_title($title, $courseId = 0)

    {

        $out_res = 0;

        if (empty($courseId)) {

            $courseId = api_get_course_int_id();

        }

        $courseId = intval($courseId);

        $tbl_cat = Database::get_course_table(TABLE_QUIZ_QUESTION_CATEGORY);

        $sql = "SELECT id FROM $tbl_cat

                WHERE c_id = $courseId AND title = '".Database::escape_string($title)."'";

        $res = Database::query($sql);

        if (Database::num_rows($res) > 0) {

            $data = Database::fetch_array($res);

            $out_res = $data['id'];

        }

        return $out_res;

    }

    /**

     * Add a relation between question and category in table c_quiz_question_rel_category