+ }
+
+ // As personal files are listed in any enrolled courses of the student,
+ // randomly pick one course for bouce.php
+ $end_of_first_course = strpos($enrolled_courses, ",") - 1;
+ $any_one_enrolled_course = substr($enrolled_courses, 1, $end_of_first_course ? $end_of_first_course : -1);
+
+ $sql = "(SELECT date, file_id, file_name, owner_id course_id, description
+ FROM ".TABLE_PREFIX."files
+ WHERE owner_type = ".WORKSPACE_COURSE." AND owner_id IN ".$enrolled_courses.")
+ UNION
+ (SELECT date, file_id, file_name, ".$any_one_enrolled_course." course_id, description
+ FROM ".TABLE_PREFIX."files
+ WHERE owner_type = ".WORKSPACE_PERSONAL." AND owner_id = ".$_SESSION['member_id'].")
+ UNION
+ (SELECT f.date, f.file_id, f.file_name, gt.course_id, f.description
+ FROM ".TABLE_PREFIX."files f, ".TABLE_PREFIX."groups g, ".TABLE_PREFIX."groups_types gt
+ WHERE owner_type = ".WORKSPACE_GROUP."
+ AND f.owner_id = g.group_id
+ AND g.type_id = gt.type_id
+ AND gt.course_id IN ".$enrolled_courses.")
+ ORDER BY date DESC";