chamilo / chamilo-lms

    $groupIid = (int) $groupIid;

    // Get list from database

    if (!empty($groupIid)) {

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

        $subdirs_query = "AND parent_id = 0";

    } else {

        $group_query = " WHERE w.c_id = $course_id AND (post_group_id = '0' or post_group_id is NULL)  ";

        $subdirs_query = "AND parent_id = 0";

    }

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

                    post_group_id = $groupIid

                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 = $groupIid";

            $subdirs_query = " AND parent_id = 0";

        } else {

            $group_query = " WHERE c_id = $course_id AND (post_group_id = '0' OR post_group_id is NULL) ";

            $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