chamilo / chamilo-lms

                    post_group_id = '".$group_id."'

                ORDER BY sent_date DESC";

    } else {

        if (!empty($group_id)) {

            // set to select only messages posted by the user's group

            $group_query = " WHERE c_id = $course_id AND post_group_id = '".$group_id."' ";

            $subdirs_query = "AND parent_id = 0";

        } else {

            $group_query = " WHERE c_id = $course_id AND  post_group_id = '0' ";

            $subdirs_query = "AND parent_id = 0";

        }

        //@todo how we can active or not an assignment?

        $active_condition = ' AND active IN (1, 0)';

        $sql = "SELECT * FROM  $work_table

    // Get list from database

    if (!empty($group_id)) {

        $group_query = " WHERE w.c_id = $course_id AND post_group_id = '".$group_id."' ";

        $subdirs_query = "AND parent_id = 0";

    } else {

        $group_query = " WHERE w.c_id = $course_id AND post_group_id = '0' ";

        $subdirs_query = "AND parent_id = 0";

    }

    $active_condition = ' AND active IN (1, 0)';