chamilo / chamilo-lms

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

        $special_course_list = array();

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

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

                $special_course_list[] = '"' . $result_row['item_id'] . '"';

            }

        }

        $without_special_courses = '';

        if (!empty($special_course_list)) {

            $without_special_courses = ' AND course.id NOT IN (' . implode(',', $special_course_list) . ')';

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

        $special_course_list = array();

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

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

                $special_course_list[] = '"' . $result_row['item_id'] . '"';

            }

        }

        $without_special_courses = '';

        if (!empty($special_course_list)) {

                    tcfv.value = 1 ";

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

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

            $special_course_list = array();

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

                $special_course_list[] = '"' . $result_row['item_id'] . '"';

            }

        }

        $without_special_courses = '';

        if (!empty($special_course_list)) {

            $without_special_courses = ' AND course.code NOT IN (' . implode(',', $special_course_list) . ')';