chamilo / chamilo-lms

    $course_id = api_get_course_int_id();

    if (api_is_allowed_to_edit(null, true)) {

        $sql = "SELECT count(*) as number_of_posts

                FROM $table_posts posts, $table_threads threads, $table_item_property item_property

                WHERE

                posts.c_id = $course_id AND

                item_property.c_id = $course_id AND

                posts.forum_id='".Database::escape_string($forum_id)."'

                AND posts.thread_id=threads.thread_id

                AND item_property.ref=threads.thread_id

                AND item_property.visibility<>2

                AND item_property.tool='".TOOL_FORUM_THREAD."'

                ";

    } else {

        $sql = "SELECT count(*) as number_of_posts

                FROM $table_posts posts, $table_threads threads, $table_item_property item_property

                WHERE

                posts.c_id = $course_id AND

                item_property.c_id = $course_id AND

                posts.forum_id='".Database::escape_string($forum_id)."'

                AND posts.thread_id=threads.thread_id

                AND item_property.ref=threads.thread_id

                AND item_property.visibility=1

                AND posts.visible=1

                AND item_property.tool='".TOOL_FORUM_THREAD."'

                ";

    }

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

    $row = Database::fetch_array($result);

    $number_of_posts = $row['number_of_posts'];

    $number_of_posts = $row['number_of_posts'];

    // We could loop through the result array and count the number of different group_ids, but I have chosen to use a second sql statement.

    if (api_is_allowed_to_edit(null, true)) {

        $sql = "SELECT count(*) as number_of_topics

                FROM $table_threads threads, $table_item_property item_property

                WHERE

                threads.c_id = $course_id AND

                item_property.c_id = $course_id AND

                threads.forum_id='".Database::escape_string($forum_id)."'

                AND item_property.ref=threads.thread_id

                AND item_property.visibility<>2

                AND item_property.tool='".TOOL_FORUM_THREAD."'

                ";

    } else {

        $sql = "SELECT count(*) as number_of_topics

                FROM $table_threads threads, $table_item_property item_property

                WHERE

                threads.c_id = $course_id AND

                item_property.c_id = $course_id AND

                threads.forum_id='".Database::escape_string($forum_id)."'

                AND item_property.ref=threads.thread_id

                AND item_property.visibility=1

                AND item_property.tool='".TOOL_FORUM_THREAD."'

                ";

    }

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

    $row = Database::fetch_array($result);

    $number_of_topics = $row['number_of_topics'];