array('c' => 'c_id', 's' => 'session_id'), 'c_attendance' => array('c' => 'c_id', 's' => 'session_id'), 'c_blog' => array('c' => 'c_id', 's' => 'session_id'), 'c_calendar_event' => array('c' => 'c_id', 's' => 'session_id'), 'c_chat_connected' => array('c' => 'c_id', 's' => 'session_id'), 'c_course_description' => array('c' => 'c_id', 's' => 'session_id'), 'c_document' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_category' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_file' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_post' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_category' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_forum' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread_qualify' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread_qualify_log' => array('c' => 'c_id', 's' => 'session_id'), 'c_glossary' => array('c' => 'c_id', 's' => 'session_id'), 'c_group_info' => array('c' => 'c_id', 's' => 'session_id'), 'c_item_property' => array('c' => 'c_id', 's' => 'id_session'), 'c_link' => array('c' => 'c_id', 's' => 'session_id'), 'c_link_category' => array('c' => 'c_id', 's' => 'session_id'), 'c_lp' => array('c' => 'c_id', 's' => 'session_id'), 'c_lp_view' => array('c' => 'c_id', 's' => 'session_id'), 'c_notebook' => array('c' => 'c_id', 's' => 'session_id'), 'c_quiz' => array('c' => 'c_id', 's' => 'session_id'), 'c_student_publication' => array('c' => 'c_id', 's' => 'session_id'), 'c_survey' => array('c' => 'c_id', 's' => 'session_id'), 'c_survey_invitation' => array('c' => 'c_id', 's' => 'session_id'), 'c_thematic' => array('c' => 'c_id', 's' => 'session_id'), 'c_tool' => array('c' => 'c_id', 's' => 'session_id'), 'c_tool_intro' => array('c' => 'c_id', 's' => 'session_id'), 'c_wiki' => array('c' => 'c_id', 's' => 'session_id'), 'c_wiki_mailcue' => array('c' => 'c_id', 's' => 'session_id'), 'gradebook_category' => array('c' => 'course_code', 's' => 'session_id'), //'session_rel_course', //'session_rel_course_rel_user', //'session_rel_user', 'track_course_ranking' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_access' => array('access_cours_code' => 'c_id', 's' => 'access_session_id'), 'track_e_attempt' => array('c' => 'course_code', 's' => 'session_id'), 'track_e_course_access' => array('c' => 'course_code', 's' => 'session_id'), 'track_e_downloads' => array('c' => 'down_cours_id', 's' => 'down_session_id'), 'track_e_exercices' => array('c' => 'exe_cours_id', 's' => 'session_id'), 'track_e_item_property' => array('c' => 'course_id', 's' => 'session_id'), 'track_e_lastaccess' => array('c' => 'access_cours_code', 's' => 'access_session_id'), 'track_e_links' => array('c' => 'links_cours_id', 's' => 'links_session_id'), 'track_e_online' => array('c' => 'course', 's' => 'session_id'), 'track_e_uploads' => array('c' => 'upload_cours_id', 's' => 'upload_session_id'), 'user_rel_course_vote' => array('c' => 'c_id', 's' => 'session_id'), ); // Users related tables. From those tables above, only a few have data related // to users. Other data need not be changed, otherwise the resources will only // be visible from a specific session. $userTables = array( 'c_attendance' => array('c' => 'c_id', 's' => 'session_id'), 'c_blog' => array('c' => 'c_id', 's' => 'session_id'), 'c_calendar_event' => array('c' => 'c_id', 's' => 'session_id'), 'c_chat_connected' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_category' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_file' => array('c' => 'c_id', 's' => 'session_id'), 'c_dropbox_post' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread_qualify' => array('c' => 'c_id', 's' => 'session_id'), 'c_forum_thread_qualify_log' => array('c' => 'c_id', 's' => 'session_id'), 'c_group_info' => array('c' => 'c_id', 's' => 'session_id'), 'c_lp_view' => array('c' => 'c_id', 's' => 'session_id'), 'c_notebook' => array('c' => 'c_id', 's' => 'session_id'), 'c_student_publication' => array('c' => 'c_id', 's' => 'session_id'), 'c_wiki' => array('c' => 'c_id', 's' => 'session_id'), 'c_wiki_mailcue' => array('c' => 'c_id', 's' => 'session_id'), 'gradebook_category' => array('c' => 'course_code', 's' => 'session_id'), //'session_rel_course', //'session_rel_course_rel_user', //'session_rel_user', 'track_course_ranking' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_access' => array('c' => 'c_id', 's' => 'access_session_id'), 'track_e_attempt' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_course_access' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_downloads' => array('c' => 'c_id', 's' => 'down_session_id'), 'track_e_exercices' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_item_property' => array('c' => 'course_id', 's' => 'session_id'), 'track_e_lastaccess' => array('c' => 'c_id', 's' => 'access_session_id'), 'track_e_links' => array('c' => 'c_id', 's' => 'links_session_id'), 'track_e_online' => array('c' => 'c_id', 's' => 'session_id'), 'track_e_uploads' => array('c' => 'upload_cours_id', 's' => 'upload_session_id'), 'user_rel_course_vote' => array('c' => 'c_id', 's' => 'session_id'), ); /** * Create the sessions * For each existing course, create a session that ends on the last day of the * past month and starts 2 years before that. */ $year = date('Y'); $month = date('m'); $end = api_strtotime($year.'-'.$month.'-01 00:00:00') - 1; $start = $end - (2*365*86400); // Prepare a list of admin users to avoid removing their relation to the base course $sql = 'SELECT user_id FROM '.Database::get_main_table(TABLE_MAIN_ADMIN); $resultAdmin = Database::query($sql); $admins = array(); while ($row = Database::fetch_assoc($resultAdmin)) { $admins[] = $row['user_id']; } $eol = PHP_EOL; $eof = PHP_EOL; if (php_sapi_name() != 'cli') { echo '
';
    $eol = "
".PHP_EOL; $eof = '
'; } $res = Database::select('id, title, code', Database::get_main_table(TABLE_MAIN_COURSE)); foreach ($res as $course) { if ($debug) { echo $course['title'] . $eol; } $sessionTitle = $course['title'] . ' (' . $month . '/' . $year . ' - a)'; $startDate = ($year-2) . '-' . $month . '-01'; $endDate = $year . '-' . $month . '-01'; $id = SessionManager::create_session( $sessionTitle, $startDate, $endDate, 0, 0, 0, $username, 0, SESSION_VISIBLE_READ_ONLY ); while ($id == 'SessionNameAlreadyExists') { if ($debug) { echo "Could not create session $sessionTitle" . $eol; } // Increase the last letter $sessionTitle = substr($sessionTitle, 0, -1) . chr(ord(substr($sessionTitle, -1, 1))+1); $id = SessionManager::create_session( $sessionTitle, $startDate, $endDate, 0, 0, 0, $username, 0, SESSION_VISIBLE_READ_ONLY ); } if ($debug) { echo "Session $sessionTitle created with ID $id" . $eol; } SessionManager::add_courses_to_session($id, array($course['id'])); $resultUsers = Database::query("SELECT user_id FROM " . Database::get_main_table(TABLE_MAIN_COURSE_USER). " WHERE c_id = '" . $course['id'] . "'"); $users = array(); while ($row = Database::fetch_assoc($resultUsers)) { $users[] = $row['user_id']; } if ($debug) { echo count($users) . " users in course " . $course['title'] . " will be moved to session $id (unless they're admins)" . $eol; } SessionManager::subscribe_users_to_session_course($users, $id, $course['code']); foreach ($userTables as $table => $fields) { $table = Database::get_main_database().'.'.$table; //c_id + course_id = int, others = char if ($fields['c'] == 'c_id' or $fields['c'] == 'course_id') { $sql = "UPDATE $table SET " . $fields['s'] . " = $id WHERE " . $fields['c'] . " = " . $course['id']; } else { $sql = "UPDATE $table SET " . $fields['s'] . " = $id WHERE " . $fields['c'] . " = '" . $course['code'] . "'"; } if ($debug) { echo $sql . $eol; } $resultChange = Database::query($sql); } // Now clean up by un-subscribing the user from the course itself manually // to avoid deleting other stuff foreach ($users as $user) { if (in_array($user, $admins)) { // Skip un-subscribing of admin users continue; } $table = Database::get_main_table(TABLE_MAIN_COURSE_USER); $sql = "DELETE FROM $table WHERE user_id = $user AND c_id = '" . $course['id'] . "'"; if ($debug) { echo $sql . $eol; } $resultRemove = Database::query($sql); } } if ($debug) { echo "End of moving process" . $eol; } echo $eof;