chamilo / chamilo-lms

                GROUP BY threads.forum_id";

        // Course Admin

        if (api_is_allowed_to_edit()) {

            // Select all the forum information of all forums (that are not deleted).

            $sql = "SELECT item_properties.*, forum.* 

                    FROM $table_forums forum

                    INNER JOIN $table_item_property item_properties

                    ON (

                        forum.forum_id = item_properties.ref AND

                        forum.c_id = item_properties.c_id

                    )

                    WHERE

                        item_properties.visibility <> 2 AND

                        item_properties.tool = '".TOOL_FORUM."'

                        $condition_session AND

                        forum.c_id = $course_id AND

                        item_properties.c_id = $course_id

                        $includeGroupsForumSelect

                    ORDER BY forum_order ASC";

            // Select the number of threads of the forums (only the threads that are not deleted).

            $sql2 = "SELECT count(*) AS number_of_threads, threads.forum_id

                    FROM $table_threads threads

                    INNER JOIN $table_item_property item_properties

                    ON (

                        threads.thread_id = item_properties.ref AND

                        threads.c_id = item_properties.c_id

                        $sessionIdLink

                    )

                    WHERE

                        item_properties.visibility<>2 AND

                        item_properties.tool='".TOOL_FORUM_THREAD."' AND

                        threads.c_id = $course_id AND

                        item_properties.c_id = $course_id

                    GROUP BY threads.forum_id";

        }

    } else {

        // GETTING ONE SPECIFIC FORUM

        /* We could do the splitup into student and course admin also but we want

            GROUP BY threads.forum_id";

    // Course Admin

    if (api_is_allowed_to_edit()) {

        // Select all the forum information of all forums (that are not deleted).

        $sql = "SELECT *

                FROM $table_forums forum INNER JOIN $table_item_property item_properties

                ON (forum.forum_id = item_properties.ref AND item_properties.c_id = forum.c_id)

                WHERE

                    forum.forum_of_group = $groupId AND

                    forum.c_id = $course_id AND

                    item_properties.c_id = $course_id AND                    

                    item_properties.visibility <> 2 AND

                    item_properties.tool = '".TOOL_FORUM."'

                ORDER BY forum_order ASC";

        // Select the number of threads of the forums (only the threads that are not deleted).

        $sql2 = "SELECT count(thread_id) AS number_of_threads, threads.forum_id

                 FROM $table_threads threads INNER JOIN $table_item_property item_properties

                 ON (threads.thread_id=item_properties.ref AND item_properties.c_id = threads.c_id)

                 WHERE

                    threads.c_id = $course_id AND

                    item_properties.c_id = $course_id AND

                    item_properties.visibility <> 2 AND

                    item_properties.tool='".TOOL_FORUM_THREAD."'

                GROUP BY threads.forum_id";

        // Select the number of posts of the forum.

        $sql3 = "SELECT count(post_id) AS number_of_posts, forum_id

                FROM $table_posts

                WHERE c_id = $course_id 

                GROUP BY forum_id";

    }

    // Handling all the forum information.

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

    $forum_list = array();