// Database Table Definitions $tbl_courses = Database::get_main_table(TABLE_MAIN_COURSE); $tbl_sessions = Database::get_main_table(TABLE_MAIN_SESSION); $tbl_announcement = Database::get_course_table(TABLE_ANNOUNCEMENT); $tbl_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY); $course_id = api_get_course_int_id(); $_course = api_get_course_info_by_id($course_id); $group_id = api_get_group_id(); $sessionId = api_get_session_id(); api_protect_course_group(GroupManager::GROUP_TOOL_ANNOUNCEMENT); /* Tracking */ Event::event_access_tool(TOOL_ANNOUNCEMENT); $announcement_id = isset($_GET['id']) ? intval($_GET['id']) : null; $origin = isset($_GET['origin']) ? Security::remove_XSS($_GET['origin']) : null; $action = isset($_GET['action']) ? Security::remove_XSS($_GET['action']) : 'list'; $announcement_number = AnnouncementManager::getNumberAnnouncements(); $homeUrl = api_get_self() . '?action=list&' . api_get_cidreq(); $content = ''; $searchFormToString = ''; switch ($action) { case 'move': /* Move announcement up/down */ if (!empty($_GET['down'])) { $thisAnnouncementId = intval($_GET['down']); $sortDirection = "DESC"; } if (!empty($_GET['up'])) { $thisAnnouncementId = intval($_GET['up']); $sortDirection = "ASC"; } if (!empty($sortDirection)) {