chamilo / chamilo-lms

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

    $post_list = array();

    while ($row = Database::fetch_array($result)) {

        $row['status'] = '1';

        $post_list[] = $row;

        $sql = "SELECT * FROM $table_posts posts

                LEFT JOIN $table_users users

                ON (posts.poster_id=users.user_id)

                WHERE

                    posts.c_id = $course_id AND

                    posts.thread_id='$thread_id'

                    AND posts.post_parent_id='".$row['post_id']."'

                ORDER BY posts.post_id ASC";

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

        while ($row2 = Database::fetch_array($result2)) {

            $row2['status'] = '0';

            $post_list[] = $row2;

        }

    }

    return $post_list;

}

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

        while ($a_courses = Database::fetch_array($result)) {

            $courseId = $a_courses['c_id'];

            $id_session = $a_courses['session_id'];

            $sql = "SELECT DISTINCT srcru.user_id

                    FROM $tbl_session_course_user AS srcru

                    INNER JOIN $tbl_session_user sru

                    ON (srcru.user_id = sru.user_id AND srcru.session_id = sru.session_id)

                    WHERE

                        sru.relation_type<>".SESSION_RELATION_TYPE_RRHH." AND

                        srcru.c_id = '$courseId' AND

                        srcru.session_id = '$id_session'";

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

            while ($row = Database::fetch_array($rs)) {

                $students[$row['user_id']] = $row['user_id'];

            }

        }

        // Then, courses where $coach_id is coach of the session    //

        $sql = 'SELECT session_course_user.user_id

                FROM '.$tbl_session_course_user.' as session_course_user