chamilo / chamilo-lms

     * @param array $id_list If you want to restrict the structure to only the given IDs

     * @return void

     */

    public function build_forum_topics(

        $session_id = 0,

        $courseId = 0,

        $with_base_content = false,

        $id_list = array()

    ) {

        $table = Database:: get_course_table(TABLE_FORUM_THREAD);

        $sessionCondition = api_get_session_condition(

            $session_id,

            true,

            $with_base_content

        );

        $sql = "SELECT * FROM $table WHERE c_id = $courseId

                $sessionCondition

                ORDER BY thread_title ";

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

        while ($obj = Database::fetch_object($result)) {

            $forum_topic = new ForumTopic($obj);

            $this->course->add_resource($forum_topic);

            $this->build_forum_posts($courseId, $obj->thread_id, $obj->forum_id, true);

        }

    }

    /**

     * @param bool $with_base_content Whether to include content from the course without session or not

     * @param array $id_list If you want to restrict the structure to only the given IDs

     */

    public function build_tool_intro(

        $session_id = 0,

        $courseId = 0,

        $with_base_content = false,

        $id_list = array()

    ) {

        $table = Database:: get_course_table(TABLE_TOOL_INTRO);

        $sessionCondition = api_get_session_condition(

            $session_id,

            true,

            $with_base_content

        );

        $sql = "SELECT * FROM $table

                WHERE c_id = $courseId $sessionCondition";

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

        while ($obj = Database::fetch_object($db_result)) {

            $tool_intro = new ToolIntro($obj->id, $obj->intro_text);

            $this->course->add_resource($tool_intro);

        }

    }

    /**

     * Build a link category