chamilo / chamilo-lms

    // Handling the thread count information.

    $result2 = Database::query($sql2);

    while ($row2 = Database::fetch_array($result2, 'ASSOC')) {

        if (is_array($forum_list)) {

            if (array_key_exists($row2['forum_id'], $forum_list)) {

                $forum_list[$row2['forum_id']]['number_of_threads'] = $row2['number_of_threads'];

            }

        }

    }

    // Handling the post count information.

    $result3 = Database::query($sql3);

    // Handling the post count information.

    $result3 = Database::query($sql3);

    while ($row3 = Database::fetch_array($result3, 'ASSOC')) {

        if (is_array($forum_list)) {

            if (array_key_exists($row3['forum_id'], $forum_list)) {

                // This is needed because sql3 takes also the deleted forums into account.

                $forum_list[$row3['forum_id']]['number_of_posts'] = $row3['number_of_posts'];

            }

        }

    }

    // Finding the last post information (last_post_id, last_poster_id, last_post_date, last_poster_name, last_poster_lastname, last_poster_firstname).

    if (!empty($forum_list)) {