visibility != 2 $querypath = Database::escape_string($querypath); $sql = "SELECT url, title FROM $tbl_student_publication AS work, $prop_table AS props WHERE props.c_id = $course_id AND work.c_id = $course_id AND props.tool='work' AND work.id=props.ref AND work.url LIKE 'work".$querypath."/%' AND work.filetype='file' AND props.visibility<>'2'"; $query = Database::query($sql); //add tem to the zip file while ($not_deleted_file = Database::fetch_assoc($query)) { if (file_exists($sys_course_path.$_course['path'].'/'.$not_deleted_file['url'])) { $files[basename($not_deleted_file['url'])] = $not_deleted_file['title']; $zip_folder->add($sys_course_path.$_course['path'].'/'.$not_deleted_file['url'], PCLZIP_OPT_REMOVE_PATH, $sys_course_path.$_course['path'].'/work', PCLZIP_CB_PRE_ADD, 'my_pre_add_callback'); } } } else { //for other users, we need to create a zipfile with only visible files and folders if ($path == '/') { $querypath = ''; // to prevent ...path LIKE '//%'... in query } else { $querypath = $path; } $querypath = Database::escape_string($querypath); $sql = "SELECT url, title FROM $tbl_student_publication AS work, $prop_table AS props WHERE props.c_id = $course_id AND work.c_id = $course_id AND props.tool='work' AND work.accepted = 1 AND work.id=props.ref AND work.url LIKE 'work".$querypath."/%' AND work.filetype='file' AND props.visibility = '1' AND props.insert_user_id='".api_get_user_id()."' "; $query = Database::query($sql); //add tem to the zip file while ($not_deleted_file = Database::fetch_assoc($query)) { if (file_exists($sys_course_path.$_course['path'].'/'.$not_deleted_file['url'])) { $files[basename($not_deleted_file['url'])] = $not_deleted_file['title']; $zip_folder->add($sys_course_path.$_course['path'].'/'.$not_deleted_file['url'], PCLZIP_OPT_REMOVE_PATH, $sys_course_path.$_course['path'].'/work', PCLZIP_CB_PRE_ADD, 'my_pre_add_callback'); } } }//end for other users //logging event_download(basename($path).'.zip (folder)'); //start download of created file $name = basename($path).'.zip'; if (Security::check_abs_path($temp_zip_file, api_get_path(SYS_ARCHIVE_PATH))) { DocumentManager::file_send_for_download($temp_zip_file, true, $name); @unlink($temp_zip_file); exit; } /* Extra function (only used here) */ function my_pre_add_callback($p_event, &$p_header) { global $files; if (isset($files[basename($p_header['stored_filename'])])) { $p_header['stored_filename'] = $files[basename($p_header['stored_filename'])]; return 1; } return 0; } /** * Return the difference between two arrays, as an array of those key/values * Use this as array_diff doesn't give the * * @param array $arr1 first array * @param array $arr2 second array * @return difference between the two arrays */ function diff($arr1, $arr2) { $res = array(); $r = 0; foreach ($arr1 as $av) { if (!in_array($av, $arr2)) { $res[$r] = $av; $r++; } } return $res; }