chamilo / chamilo-lms

                $without_special_courses = ' AND course.code NOT IN (' . $sc_string . ')';

            }

            if (!empty($with_special_courses)) {

                $sql = "SELECT DISTINCT(course.code), course.id as real_id

                        FROM $tbl_course_user  course_rel_user

                        LEFT JOIN $tbl_course  course

                        ON course.id = course_rel_user.c_id

                        LEFT JOIN $tbl_user_course_category user_course_category

                        ON course_rel_user.user_course_cat = user_course_category.id

                        WHERE  $with_special_courses

                        GROUP BY course.code

                        ORDER BY user_course_category.sort, course.title, course_rel_user.sort ASC

                    ";

                //

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

                if (Database::num_rows($rs_special_course) > 0) {

                    while ($result_row = Database::fetch_array($rs_special_course)) {

                        $result_row['special_course'] = 1;

                        $course_list[] = $result_row;

                        $codes[] = $result_row['real_id'];

                    }

                }

            }

            // get course list not auto-register. Use Distinct to avoid multiple

            // entries when a course is assigned to a HRD (DRH) as watcher

            }

        }

        if (!empty($defaults['course_users'])) {

            $user_ids = implode("','", $defaults['course_users']);

            $sql = "SELECT user_id FROM $table_user WHERE user_id IN ('$user_ids') $order_clause";

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

            $fixed_users = array();

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

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

            }

            $defaults['course_users'] = $fixed_users;

        }

        if (!empty($defaults['additional_users'])) {

            $defaults['additional_users'] = implode(';', $defaults['additional_users']);