12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- <?php
- /* For licensing terms, see /license.txt */
- require_once 'dropbox_init.inc.php';
- $file_tbl = Database::get_course_table(TABLE_DROPBOX_FILE);
- $person_tbl = Database::get_course_table(TABLE_DROPBOX_PERSON);
- $course_id = api_get_course_int_id();
- $user_id = api_get_user_id();
- $session_id = api_get_session_id();
- if (empty($course_id)) {
- api_not_allowed();
- }
- if (!api_is_allowed_to_session_edit(false, true)) {
- api_not_allowed();
- }
- echo Display::page_subheader(get_lang('RecoverDropboxFiles'));
- if (isset($_GET['recover_id']) && !empty($_GET['recover_id'])) {
- $recover_id = intval($_GET['recover_id']);
- $sql = "INSERT INTO $person_tbl VALUES('$course_id', $recover_id, $user_id)";
- $result = Database::query($sql);
- if ($result) {
- Display::display_confirmation_message(get_lang('Recovered'));
- }
- }
- $sql = "SELECT * FROM $file_tbl WHERE c_id = $course_id AND session_id = $session_id";
- $result = Database::query($sql);
- if (Database::num_rows($result)) {
- $files = Database::store_result($result);
- $rows = array();
- foreach ($files as $file) {
- //Check if I have this file:
- $sql = "SELECT * FROM $person_tbl WHERE c_id = $course_id AND user_id = $user_id AND file_id = {$file['id']}";
- $result_person = Database::query($sql);
- if (Database::num_rows($result_person) == 0 ) {
- $rows[] = array(
- $file['filename'],
- api_convert_and_format_date($file['upload_date']),
- Display::url(get_lang('Recover'), api_get_self().'?recover_id='.$file['id'], array('class' => 'btn'))
- );
- }
- }
- $headers = array(get_lang('Filename'), get_lang('UploadedDate'), get_lang('Action'));
- echo Display::table($headers, $rows);
- }
- Display::display_footer();
|