{TITLE}

0) { return true; } else { return false; } } /** * This function a wiki warning * @author Patrick Cool , Ghent University * @return html code **/ function display_wiki_warning($variable) { echo '

'.$variable.'

'; } /** * Checks if this navigation tab has to be set to active * @author Patrick Cool , Ghent University * @return html code */ function is_active_navigation_tab($paramwk) { if ($_GET['action'] == $paramwk) { return ' class="active"'; } } /** * Lock add pages * @author Juan Carlos Raña * return current database status of protect page and change it if get action */ function check_addnewpagelock() { global $tbl_wiki; global $groupfilter; global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $course_id = api_get_course_int_id(); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_addlock = $row['addlock']; //change status if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($_GET['actionpage'] == 'lockaddnew' && $status_addlock == 1) { $status_addlock = 0; } if ($_GET['actionpage'] == 'unlockaddnew' && $status_addlock == 0) { $status_addlock = 1; } Database::query( 'UPDATE '.$tbl_wiki.' SET addlock="'.Database::escape_string( $status_addlock ).'" WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.'' ); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } //show status return $row['addlock']; } /** * Protect page * @author Juan Carlos Raña * return current database status of protect page and change it if get action */ function check_protect_page() { global $tbl_wiki; global $page; global $groupfilter; global $condition_session; $course_id = api_get_course_int_id(); $_clean['group_id'] = (int)$_SESSION['_gid']; $sql = 'SELECT * FROM '.$tbl_wiki.'WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_editlock = $row['editlock']; $id = $row['id']; ///change status if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($_GET['actionpage'] == 'lock' && $status_editlock == 0) { $status_editlock = 1; } if ($_GET['actionpage'] == 'unlock' && $status_editlock == 1) { $status_editlock = 0; } $sql = 'UPDATE '.$tbl_wiki.' SET editlock="'.Database::escape_string( $status_editlock ).'" WHERE c_id = '.$course_id.' AND id="'.$id.'"'; Database::query($sql); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } //show status return $row['editlock']; } /** * Visibility page * @author Juan Carlos Raña * return current database status of visibility and change it if get action */ function check_visibility_page() { global $tbl_wiki; global $page; global $groupfilter; global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $course_id = api_get_course_int_id(); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_visibility = $row['visibility']; //change status if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($_GET['actionpage'] == 'visible' && $status_visibility == 0) { $status_visibility = 1; } if ($_GET['actionpage'] == 'invisible' && $status_visibility == 1) { $status_visibility = 0; } $sql = 'UPDATE '.$tbl_wiki.' SET visibility="'.Database::escape_string( $status_visibility ).'" WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session; Database::query($sql); //Although the value now is assigned to all (not only the first), these three lines remain necessary. They do that by changing the page state is made when you press the button and not have to wait to change his page $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } if (empty($row['id'])) { $row['visibility'] = 1; } //show status return $row['visibility']; } /** * Visibility discussion * @author Juan Carlos Raña * @return int current database status of discuss visibility and change it if get action page */ function check_visibility_discuss() { global $tbl_wiki; global $page; global $groupfilter; global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $course_id = api_get_course_int_id(); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_visibility_disc = $row['visibility_disc']; //change status if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($_GET['actionpage'] == 'showdisc' && $status_visibility_disc == 0) { $status_visibility_disc = 1; } if ($_GET['actionpage'] == 'hidedisc' && $status_visibility_disc == 1) { $status_visibility_disc = 0; } $sql = 'UPDATE '.$tbl_wiki.' SET visibility_disc="'.Database::escape_string( $status_visibility_disc ).'" WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session; Database::query($sql); //Although the value now is assigned to all (not only the first), these three lines remain necessary. They do that by changing the page state is made when you press the button and not have to wait to change his page $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } //show status return $row['visibility_disc']; } /** * Lock add discussion * @author Juan Carlos Raña * @return int current database status of lock dicuss and change if get action */ function check_addlock_discuss() { global $tbl_wiki; global $page; global $groupfilter; global $condition_session; $course_id = api_get_course_int_id(); $_clean['group_id'] = (int)$_SESSION['_gid']; $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_addlock_disc = $row['addlock_disc']; //change status if (api_is_allowed_to_edit() || api_is_platform_admin()) { if ($_GET['actionpage'] == 'lockdisc' && $status_addlock_disc == 0) { $status_addlock_disc = 1; } if ($_GET['actionpage'] == 'unlockdisc' && $status_addlock_disc == 1) { $status_addlock_disc = 0; } $sql = 'UPDATE '.$tbl_wiki.' SET addlock_disc="'.Database::escape_string($status_addlock_disc).'" WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session; Database::query($sql); //Although the value now is assigned to all (not only the first), these three lines remain necessary. They do that by changing the page state is made when you press the button and not have to wait to change his page $sql = 'SELECT * FROM '.$tbl_wiki.'WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } //show status return $row['addlock_disc']; } /** * Lock rating discussion * @author Juan Carlos Raña * @return int current database status of rating discuss and change it if get action */ function check_ratinglock_discuss() { global $tbl_wiki; global $page; global $groupfilter; global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $course_id = api_get_course_int_id(); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $status_ratinglock_disc = $row['ratinglock_disc']; //change status if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($_GET['actionpage'] == 'lockrating' && $status_ratinglock_disc == 0) { $status_ratinglock_disc = 1; } if ($_GET['actionpage'] == 'unlockrating' && $status_ratinglock_disc == 1) { $status_ratinglock_disc = 0; } $sql = 'UPDATE '.$tbl_wiki.' SET ratinglock_disc="'.Database::escape_string($status_ratinglock_disc).'" WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session; //Visibility. Value to all,not only for the first Database::query($sql); //Although the value now is assigned to all (not only the first), these three lines remain necessary. They do that by changing the page state is made when you press the button and not have to wait to change his page $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.Database::escape_string( $page ).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); } //show status return $row['ratinglock_disc']; } /** * Notify page changes * @author Juan Carlos Raña * @return int the current notification status */ function check_notify_page($reflink) { global $tbl_wiki; global $groupfilter; global $tbl_wiki_mailcue; global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $session_id = api_get_session_id(); $course_id = api_get_course_int_id(); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.$reflink.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $id = $row['id']; $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND id="'.$id.'" AND user_id="'.api_get_user_id( ).'" AND type="P"'; $result = Database::query($sql); $row = Database::fetch_array($result); $idm = $row['id']; if (empty($idm)) { $status_notify = 0; } else { $status_notify = 1; } //change status if ($_GET['actionpage'] == 'locknotify' && $status_notify == 0) { $sql = "INSERT INTO ".$tbl_wiki_mailcue." (c_id, id, user_id, type, group_id, session_id) VALUES ($course_id, '".$id."','".api_get_user_id()."','P','".$_clean['group_id']."','".$session_id."')"; Database::query($sql); $status_notify = 1; } if ($_GET['actionpage'] == 'unlocknotify' && $status_notify == 1) { $sql = 'DELETE FROM '.$tbl_wiki_mailcue.' WHERE id="'.$id.'" AND user_id="'.api_get_user_id( ).'" AND type="P" AND c_id = '.$course_id; //$_clean['group_id'] not necessary. CHECK FOR SESSIONS Database::query($sql); $status_notify = 0; } //show status return $status_notify; } /** * Notify discussion changes * @author Juan Carlos Raña * @return int current database status of rating discuss and change it if get action */ function check_notify_discuss($reflink) { global $tbl_wiki; global $groupfilter; global $tbl_wiki_mailcue; global $condition_session; $course_id = api_get_course_int_id(); $_clean['group_id'] = (int)$_SESSION['_gid']; $session_id = api_get_session_id(); $sql = 'SELECT * FROM '.$tbl_wiki.'WHERE c_id = '.$course_id.' AND reflink="'.$reflink.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $id = $row['id']; $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND id="'.$id.'" AND user_id="'.api_get_user_id( ).'" AND type="D"'; $result = Database::query($sql); $row = Database::fetch_array($result); $idm = $row['id']; if (empty($idm)) { $status_notify_disc = 0; } else { $status_notify_disc = 1; } //change status if ($_GET['actionpage'] == 'locknotifydisc' && $status_notify_disc == 0) { $sql = "INSERT INTO ".$tbl_wiki_mailcue." (c_id, id, user_id, type, group_id, session_id) VALUES ($course_id, '".$id."','".api_get_user_id()."','D','".$_clean['group_id']."','".$session_id."')"; Database::query($sql); $status_notify_disc = 1; } if ($_GET['actionpage'] == 'unlocknotifydisc' && $status_notify_disc == 1) { $sql = 'DELETE FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND id="'.$id.'" AND user_id="'.api_get_user_id( ).'" AND type="D" AND c_id = '.$course_id; //$_clean['group_id'] not necessary TODO:CHECK FOR SESSIONS Database::query($sql); $status_notify_disc = 0; } //show status return $status_notify_disc; } /** * Notify all changes * @author Juan Carlos Raña */ function check_notify_all() { global $tbl_wiki_mailcue; $course_id = api_get_course_int_id(); $_clean['group_id'] = (int)$_SESSION['_gid']; $session_id = api_get_session_id(); $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND user_id="'.api_get_user_id( ).'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; $result = Database::query($sql); $row = Database::fetch_array($result); $idm = $row['user_id']; if (empty($idm)) { $status_notify_all = 0; } else { $status_notify_all = 1; } //change status if ($_GET['actionpage'] == 'locknotifyall' && $status_notify_all == 0) { $sql = "INSERT INTO ".$tbl_wiki_mailcue." (c_id, user_id, type, group_id, session_id) VALUES ($course_id, '".api_get_user_id()."','F','".$_clean['group_id']."','".$session_id."')"; Database::query($sql); $status_notify_all = 1; } if ($_GET['actionpage'] == 'unlocknotifyall' && $status_notify_all == 1) { $sql = 'DELETE FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND user_id="'.api_get_user_id( ).'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'" AND c_id = '.$course_id; Database::query($sql); $status_notify_all = 0; } //show status return $status_notify_all; } /** * Sends pending e-mails */ function check_emailcue($id_or_ref, $type, $lastime = '', $lastuser = '') { global $tbl_wiki; global $groupfilter; global $tbl_wiki_mailcue; $_course = api_get_course_info(); global $condition_session; $_clean['group_id'] = (int)$_SESSION['_gid']; $session_id = api_get_session_id(); $course_id = api_get_course_int_id(); $group_properties = GroupManager :: get_group_properties($_clean['group_id']); $group_name = $group_properties['name']; $allow_send_mail = false; //define the variable to below if ($type == 'P') { //if modifying a wiki page //first, current author and time //Who is the author? $userinfo = api_get_user_info($lastuser); $email_user_author = get_lang('EditedBy').': '.$userinfo['complete_name']; //When ? $year = substr($lastime, 0, 4); $month = substr($lastime, 5, 2); $day = substr($lastime, 8, 2); $hours = substr($lastime, 11, 2); $minutes = substr($lastime, 14, 2); $seconds = substr($lastime, 17, 2); $email_date_changes = $day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds; //second, extract data from first reg $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND reflink="'.$id_or_ref.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; //id_or_ref is reflink from tblwiki $result = Database::query($sql); $row = Database::fetch_array($result); $id = $row['id']; $email_page_name = $row['title']; if ($row['visibility'] == 1) { $allow_send_mail = true; //if visibility off - notify off $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND id="'.$id.'" AND type="'.$type.'" OR type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=full. $result = Database::query($sql); $emailtext = get_lang('EmailWikipageModified').' '.$email_page_name.' '.get_lang('Wiki'); } } elseif ($type == 'D') { //if added a post to discuss //first, current author and time //Who is the author of last message? $userinfo = api_get_user_info($lastuser); $email_user_author = get_lang('AddedBy').': '.$userinfo['complete_name']; //When ? $year = substr($lastime, 0, 4); $month = substr($lastime, 5, 2); $day = substr($lastime, 8, 2); $hours = substr($lastime, 11, 2); $minutes = substr($lastime, 14, 2); $seconds = substr($lastime, 17, 2); $email_date_changes = $day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds; //second, extract data from first reg $id = $id_or_ref; //$id_or_ref is id from tblwiki $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND id="'.$id.'" ORDER BY id ASC'; $result = Database::query($sql); $row = Database::fetch_array($result); $email_page_name = $row['title']; if ($row['visibility_disc'] == 1) { $allow_send_mail = true; //if visibility off - notify off $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.'WHERE c_id = '.$course_id.' AND id="'.$id.'" AND type="'.$type.'" OR type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=full $result = Database::query($sql); $emailtext = get_lang('EmailWikiPageDiscAdded').' '.$email_page_name.' '.get_lang('Wiki'); } } elseif ($type == 'A') { //for added pages $id = 0; //for tbl_wiki_mailcue $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' ORDER BY id DESC'; //the added is always the last $result = Database::query($sql); $row = Database::fetch_array($result); $email_page_name = $row['title']; //Who is the author? $userinfo = api_get_person_name($row['user_id']); $email_user_author = get_lang('AddedBy').': '.$userinfo['complete_name']; //When ? $year = substr($row['dtime'], 0, 4); $month = substr($row['dtime'], 5, 2); $day = substr($row['dtime'], 8, 2); $hours = substr($row['dtime'], 11, 2); $minutes = substr($row['dtime'], 14, 2); $seconds = substr($row['dtime'], 17, 2); $email_date_changes = $day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds; if ($row['assignment'] == 0) { $allow_send_mail = true; } elseif ($row['assignment'] == 1) { $email_assignment = get_lang('AssignmentDescExtra').' ('.get_lang('AssignmentMode').')'; $allow_send_mail = true; } elseif ($row['assignment'] == 2) { $allow_send_mail = false; //Mode tasks: avoids notifications to all users about all users } $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.' WHERE c_id = '.$course_id.' AND id="'.$id.'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=full $result = Database::query($sql); $emailtext = get_lang('EmailWikiPageAdded').' '.$email_page_name.' '.get_lang( 'In' ).' '.get_lang('Wiki'); } elseif ($type == 'E') { $id = 0; $allow_send_mail = true; //Who is the author? $userinfo = api_get_user_info(api_get_user_id()); //current user $email_user_author = get_lang('DeletedBy').': '.$userinfo['complete_name']; //When ? $today = date('r'); //current time $email_date_changes = $today; $sql = 'SELECT * FROM '.$tbl_wiki_mailcue.'WHERE c_id = '.$course_id.' AND id="'.$id.'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=wiki $result = Database::query($sql); $emailtext = get_lang('EmailWikipageDedeleted'); } ///make and send email if ($allow_send_mail) { while ($row = Database::fetch_array($result)) { $userinfo = api_get_user_info($row['user_id']); //$row['user_id'] obtained from tbl_wiki_mailcue $name_to = api_get_person_name( $userinfo['firstname'], $userinfo['lastname'], null, PERSON_NAME_EMAIL_ADDRESS ); $email_to = $userinfo['email']; $sender_name = api_get_setting('emailAdministrator'); $sender_email = api_get_setting('emailAdministrator'); $email_subject = get_lang('EmailWikiChanges').' - '.$_course['official_code']; $email_body = get_lang('DearUser').' '.api_get_person_name( $userinfo['firstname'], $userinfo['lastname'] ).',

'; if ($session_id == 0) { $email_body .= $emailtext.' '.$_course['name'].' - '.$group_name.'

'; } else { $email_body .= $emailtext.' '.$_course['name'].' ('.api_get_session_name( api_get_session_id() ).') - '.$group_name.'

'; } $email_body .= $email_user_author.' ('.$email_date_changes.')

'; $email_body .= $email_assignment.'

'; $email_body .= ''.get_lang('EmailWikiChangesExt_1').': '.get_lang( 'NotifyChanges' ).'
'; $email_body .= get_lang('EmailWikiChangesExt_2').': '.get_lang( 'NotNotifyChanges' ).'
'; @api_mail_html($name_to, $email_to, $email_subject, $email_body, $sender_name, $sender_email); } } } /** * Function export last wiki page version to document area * @author Juan Carlos Raña */ function export2doc($doc_id) { $_course = api_get_course_info(); $groupId = api_get_group_id(); $session_id = api_get_session_id(); $data = get_wiki_data($doc_id); if (empty($data)) { return false; } $wikiTitle = $data['title']; $wikiContents = $data['content']; $template = ' {TITLE} {ASCIIMATHML_SCRIPT} {CONTENT} '; $css_file = api_get_path(TO_SYS, WEB_CSS_PATH).api_get_setting('stylesheets').'/default.css'; if (file_exists($css_file)) { $css = @file_get_contents($css_file); } else { $css = ''; } // Fixing some bugs in css files. $root_rel = api_get_path(REL_PATH); $css_path = 'main/css/'; $theme = api_get_setting('stylesheets').'/'; $css = str_replace('behavior:url("/main/css/csshover3.htc");', '', $css); $css = str_replace('main/', $root_rel.'main/', $css); $css = str_replace('images/', $root_rel.$css_path.$theme.'images/', $css); $css = str_replace('../../img/', $root_rel.'main/img/', $css); $asciimathmal_script = (Text::api_contains_asciimathml($wikiContents) || Text::api_contains_asciisvg($wikiContents)) ? ''."\n" : ''; $template = str_replace( array( '{LANGUAGE}', '{ENCODING}', '{TEXT_DIRECTION}', '{TITLE}', '{CSS}', '{ASCIIMATHML_SCRIPT}' ), array( api_get_language_isocode(), api_get_system_encoding(), api_get_text_direction(), $wikiTitle, $css, $asciimathmal_script ), $template ); if (0 != $groupId) { $groupPart = '_group'.$groupId; // and add groupId to put the same document title in different groups $group_properties = GroupManager :: get_group_properties($groupId); $groupPath = $group_properties['directory']; } else { $groupPart = ''; $groupPath = ''; } $exportDir = api_get_path(SYS_COURSE_PATH).api_get_course_path().'/document'.$groupPath; $exportFile = api_replace_dangerous_char($wikiTitle, 'strict').$groupPart; //$clean_wikiContents = trim(preg_replace("/\[\[|\]\]/", " ", $wikiContents)); //$array_clean_wikiContents= explode('|', $clean_wikiContents); $wikiContents = trim(preg_replace("/\[[\[]?([^\]|]*)[|]?([^|\]]*)\][\]]?/", "$1", $wikiContents)); //TODO: put link instead of title $wikiContents = str_replace('{CONTENT}', $wikiContents, $template); // replace relative path by absolute path for courses, so you can see items into this page wiki (images, mp3, etc..) exported in documents if (api_strpos($wikiContents, '../../courses/') !== false) { $web_course_path = api_get_path(WEB_COURSE_PATH); $wikiContents = str_replace('../../courses/', $web_course_path, $wikiContents); } $doc_id = 0; $i = 1; while (file_exists( $exportDir.'/'.$exportFile.'_'.$i.'.html' )) { $i++; } //only export last version, but in new export new version in document area $wikiFileName = $exportFile.'_'.$i.'.html'; $exportPath = $exportDir.'/'.$wikiFileName; file_put_contents($exportPath, $wikiContents); $doc_id = FileManager::add_document( $_course, $groupPath.'/'.$wikiFileName, 'file', filesize($exportPath), $wikiTitle ); api_item_property_update($_course, TOOL_DOCUMENT, $doc_id, 'DocumentAdded', api_get_user_id(), $groupId); return $doc_id; // TODO: link to go document area } /** * Exports the wiki page to PDF */ function export_to_pdf($id, $course_code) { $data = get_wiki_data($id); $content_pdf = api_html_entity_decode($data['content'], ENT_QUOTES, api_get_system_encoding()); //clean wiki links $content_pdf = trim(preg_replace("/\[[\[]?([^\]|]*)[|]?([^|\]]*)\][\]]?/", "$1", $content_pdf)); //TODO: It should be better to display the link insted of the tile but it is hard for [[title]] links $title_pdf = api_html_entity_decode($data['title'], ENT_QUOTES, api_get_system_encoding()); $title_pdf = api_utf8_encode($title_pdf, api_get_system_encoding()); $content_pdf = api_utf8_encode($content_pdf, api_get_system_encoding()); $html = ' '.$content_pdf; $css_file = api_get_path(TO_SYS, WEB_CSS_PATH).api_get_setting('stylesheets').'/print.css'; if (file_exists($css_file)) { $css = @file_get_contents($css_file); } else { $css = ''; } $pdf = new PDF(); $pdf->content_to_pdf($html, $css, $title_pdf, $course_code); exit; } /** * Function prevent double post (reload or F5) * */ function double_post($wpost_id) { if (isset($_SESSION['wpost_id'])) { if ($wpost_id == $_SESSION['wpost_id']) { return false; } else { $_SESSION['wpost_id'] = $wpost_id; return true; } } else { $_SESSION['wpost_id'] = $wpost_id; return true; } } /** * Function wizard individual assignment * @author Juan Carlos Raña */ function auto_add_page_users($assignment_type) { global $assig_user_id, $session_id; //$assig_user_id is need to identify end reflinks $_clean['group_id'] = (int)$_SESSION['_gid']; if ($_clean['group_id'] == 0) { //extract course members if (!empty($session_id)) { $a_users_to_add = CourseManager :: get_user_list_from_course_code($_SESSION['_course']['id'], $session_id); } else { $a_users_to_add = CourseManager :: get_user_list_from_course_code($_SESSION['_course']['id'], 0); } } else { //extract group members $subscribed_users = GroupManager :: get_subscribed_users($_clean['group_id']); $subscribed_tutors = GroupManager :: get_subscribed_tutors($_clean['group_id']); $a_users_to_add_with_duplicates = array_merge($subscribed_users, $subscribed_tutors); //remove duplicates $a_users_to_add = $a_users_to_add_with_duplicates; //array_walk($a_users_to_add, create_function('&$value,$key', '$value = json_encode($value);')); $a_users_to_add = array_unique($a_users_to_add); //array_walk($a_users_to_add, create_function('&$value,$key', '$value = json_decode($value, true);')); } //echo print_r($a_users_to_add); $all_students_pages = array(); //data about teacher $userinfo = api_get_user_info(api_get_user_id()); $name = $userinfo['complete_name_login_as']; if (api_get_user_id() <> 0) { $image_path = UserManager::get_user_picture_path_by_id(api_get_user_id(), 'web', false, true); $image_repository = $image_path['dir']; $existing_image = $image_path['file']; $photo = '

'; } else { $photo = '

'; } //teacher assignment title $title_orig = $_POST['title']; //teacher assignment reflink $link2teacher = $_POST['title'] = $title_orig."_uass".api_get_user_id(); //first: teacher name, photo, and assignment description (original content) // $content_orig_A='

'.$photo.'
'.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).'
('.get_lang('Teacher').')

'; $content_orig_A = '

'.get_lang( 'AssignmentDesc' ).'

'.$photo.'
'.Display::tag('span', $name).'

'; $content_orig_B = '

'.get_lang( 'AssignmentDescription' ).': '.$title_orig.'

'.$_POST['content']; //Second: student list (names, photo and links to their works). //Third: Create Students work pages. foreach ($a_users_to_add as $user_id => $o_user_to_add) { if ($o_user_to_add['user_id'] != api_get_user_id()) //except that puts the task { $assig_user_id = $o_user_to_add['user_id']; //identifies each page as created by the student, not by teacher $image_path = UserManager::get_user_picture_path_by_id($assig_user_id, 'web', false, true); $image_repository = $image_path['dir']; $existing_image = $image_path['file']; $username = api_htmlentities(sprintf(get_lang('LoginX'), $o_user_to_add['username'], ENT_QUOTES)); $name = api_get_person_name($o_user_to_add['firstname'], $o_user_to_add['lastname'])." . ".$username; $photo = '

'; $is_tutor_of_group = GroupManager :: is_tutor_of_group( $assig_user_id, $_clean['group_id'] ); //student is tutor $is_tutor_and_member = (GroupManager :: is_tutor_of_group( $assig_user_id, $_clean['group_id'] ) && GroupManager :: is_subscribed($assig_user_id, $_clean['group_id'])); //student is tutor and member if ($is_tutor_and_member) { $status_in_group = get_lang('GroupTutorAndMember'); } else { if ($is_tutor_of_group) { $status_in_group = get_lang('GroupTutor'); } else { $status_in_group = " "; //get_lang('GroupStandardMember') } } if ($assignment_type == 1) { $_POST['title'] = $title_orig; $_POST['comment'] = get_lang('AssignmentFirstComToStudent'); $_POST['content'] = '

'.get_lang( 'AssignmentWork' ).'

'.$photo.'
'.$name.'

[['.$link2teacher.' | '.get_lang( 'AssignmentLinktoTeacherPage' ).']] '; //If $content_orig_B is added here, the task written by the professor was copied to the page of each student. TODO: config options //AssignmentLinktoTeacherPage $all_students_pages[] = '

'. Display::tag( 'span', strtoupper($o_user_to_add['lastname']).', '.$o_user_to_add['firstname'], array('title' => $username) ). ' [['.$_POST['title']."_uass".$assig_user_id.' | '.$photo.']] '.$status_in_group.'

'; //don't change this line without guaranteeing that users will be ordered by last names in the following format (surname, name) //$all_students_pages[] = '

'.api_get_person_name($o_user_to_add['lastname'], $o_user_to_add['firstname']).'

[['.$_POST['title']."_uass".$assig_user_id.' | '.$photo.']] '.$status_in_group.'

'; $_POST['assignment'] = 2; } save_new_wiki(); } } //end foreach for each user foreach ($a_users_to_add as $user_id => $o_user_to_add) { if ($o_user_to_add['user_id'] == api_get_user_id()) { $assig_user_id = $o_user_to_add['user_id']; if ($assignment_type == 1) { $_POST['title'] = $title_orig; $_POST['comment'] = get_lang('AssignmentDesc'); sort($all_students_pages); $_POST['content'] = $content_orig_A.$content_orig_B.'

'.get_lang( 'AssignmentLinkstoStudentsPage' ).'

'.implode( $all_students_pages ).'

'; $_POST['assignment'] = 1; } save_new_wiki(); } } //end foreach to teacher } /** * Displays the results of a wiki search * @param string Search term * @param int Whether to search the contents (1) or just the titles (0) */ function display_wiki_search_results($search_term, $search_content = 0, $all_vers = 0) { global $tbl_wiki, $groupfilter, $MonthsLong, $condition_session; echo ''.get_lang('WikiSearchResults').''; $_clean['group_id'] = (int)$_SESSION['_gid']; $session_id = api_get_session_id(); $course_id = api_get_course_int_id(); //only by professors when page is hidden if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { if ($all_vers == '1') { if ($search_content == '1') { $sql = "SELECT * FROM ".$tbl_wiki." WHERE c_id = $course_id AND title LIKE '%".Database::escape_string( $search_term )."%' OR content LIKE '%".Database::escape_string( $search_term )."%' AND ".$groupfilter.$condition_session.""; //search all pages and all versions } else { $sql = "SELECT * FROM ".$tbl_wiki." WHERE c_id = $course_id AND title LIKE '%".Database::escape_string( $search_term )."%' AND ".$groupfilter.$condition_session.""; //search all pages and all versions } } else { if ($search_content == '1') { $sql = "SELECT * FROM ".$tbl_wiki." s1 WHERE s1.c_id = $course_id AND title LIKE '%".Database::escape_string( $search_term )."%' OR content LIKE '%".Database::escape_string($search_term)."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s2.c_id = $course_id AND s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")"; // warning don't use group by reflink because don't return the last version } else { $sql = " SELECT * FROM ".$tbl_wiki." s1 WHERE s1.c_id = $course_id AND title LIKE '%".Database::escape_string($search_term)."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s2.c_id = $course_id AND s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")"; // warning don't use group by reflink because don't return the last version } } } else { if ($all_vers == '1') { if ($search_content == '1') { $sql = "SELECT * FROM ".$tbl_wiki." WHERE c_id = $course_id AND visibility=1 AND title LIKE '%".Database::escape_string( $search_term )."%' OR content LIKE '%".Database::escape_string( $search_term )."%' AND ".$groupfilter.$condition_session.""; //search all pages and all versions } else { $sql = "SELECT * FROM ".$tbl_wiki." WHERE c_id = $course_id AND visibility=1 AND title LIKE '%".Database::escape_string( $search_term )."%' AND ".$groupfilter.$condition_session.""; //search all pages and all versions } } else { if ($search_content == '1') { $sql = " SELECT * FROM ".$tbl_wiki." s1 WHERE s1.c_id = $course_id AND visibility=1 AND title LIKE '%".Database::escape_string( $search_term )."%' OR content LIKE '%".Database::escape_string($search_term)."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s2.c_id = $course_id AND s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")"; // warning don't use group by reflink because don't return the last version } else { $sql = " SELECT * FROM ".$tbl_wiki." s1 WHERE s1.c_id = $course_id AND visibility=1 AND title LIKE '%".Database::escape_string( $search_term )."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s2.c_id = $course_id AND s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")"; // warning don't use group by reflink because don't return the last version } } } $result = Database::query($sql); //show table if (Database::num_rows($result) > 0) { $row = array(); while ($obj = Database::fetch_object($result)) { //get author $userinfo = api_get_user_info($obj->user_id); //get time $year = substr($obj->dtime, 0, 4); $month = substr($obj->dtime, 5, 2); $day = substr($obj->dtime, 8, 2); $hours = substr($obj->dtime, 11, 2); $minutes = substr($obj->dtime, 14, 2); $seconds = substr($obj->dtime, 17, 2); //get type assignment icon if ($obj->assignment == 1) { $ShowAssignment = Display::return_icon( 'wiki_assignment.png', get_lang('AssignmentDesc'), '', ICON_SIZE_SMALL ); } elseif ($obj->assignment == 2) { $ShowAssignment = Display::return_icon( 'wiki_work.png', get_lang('AssignmentWork'), '', ICON_SIZE_SMALL ); } elseif ($obj->assignment == 0) { $ShowAssignment = '

'; } $row = array(); $row[] = $ShowAssignment; if ($all_vers == '1') { $row[] = ''.api_htmlentities($obj->title).''; } else { $row[] = ''.$obj->title.''; } $row[] = $obj->user_id <> 0 ? ''.api_htmlentities($userinfo['complete_name']).'' : get_lang('Anonymous').' ('.$obj->user_ip.')'; $row[] = $year.'-'.$month.'-'.$day.' '.$hours.":".$minutes.":".$seconds; if ($all_vers == '1') { $row[] = $obj->version; } else { if (api_is_allowed_to_edit(false, true) || api_is_platform_admin()) { $showdelete = ' '.Display::return_icon( 'delete.png', get_lang('Delete'), '', ICON_SIZE_SMALL ); } $row[] = ''.Display::return_icon( 'edit.png', get_lang('EditPage'), '', ICON_SIZE_SMALL ).' '.Display::return_icon( 'discuss.png', get_lang('Discuss'), '', ICON_SIZE_SMALL ).' '.Display::return_icon( 'history.png', get_lang('History'), '', ICON_SIZE_SMALL ).' '.Display::return_icon( 'what_link_here.png', get_lang('LinksPages'), '', ICON_SIZE_SMALL ).''.$showdelete; } $rows[] = $row; } $table = new SortableTableFromArrayConfig($rows, 1, 10, 'SearchPages_table', '', '', 'ASC'); $table->set_additional_parameters( array( 'cidReq' => $_GET['cidReq'], 'action' => $_GET['action'], 'group_id' => Security::remove_XSS($_GET['group_id']), 'mode_table' => 'yes2', 'search_term' => $search_term, 'search_content' => $search_content, 'all_vers' => $all_vers ) ); $table->set_header(0, get_lang('Type'), true, array('style' => 'width:30px;')); $table->set_header(1, get_lang('Title'), true); if ($all_vers == '1') { $table->set_header(2, get_lang('Author'), true); $table->set_header(3, get_lang('Date'), true); $table->set_header(4, get_lang('Version'), true); } else { $table->set_header(2, get_lang('Author').' ('.get_lang('LastVersion').')', true); $table->set_header(3, get_lang('Date').' ('.get_lang('LastVersion').')', true); $table->set_header(4, get_lang('Actions'), false, array('style' => 'width:130px;')); } $table->display(); } else { echo get_lang('NoSearchResults'); } } /** * Returns a date picker * @todo replace this function with the formvalidator datepicker * */ function draw_date_picker($prefix, $default = '') { if (empty($default)) { $default = date('Y-m-d H:i:s'); } $parts = split(' ', $default); list($d_year, $d_month, $d_day) = split('-', $parts[0]); list($d_hour, $d_minute) = split(':', $parts[1]); $month_list = array( 1 => get_lang('JanuaryLong'), 2 => get_lang('FebruaryLong'), 3 => get_lang('MarchLong'), 4 => get_lang('AprilLong'), 5 => get_lang('MayLong'), 6 => get_lang('JuneLong'), 7 => get_lang('JulyLong'), 8 => get_lang('AugustLong'), 9 => get_lang('SeptemberLong'), 10 => get_lang('OctoberLong'), 11 => get_lang('NovemberLong'), 12 => get_lang('DecemberLong') ); $minute = range(10, 59); array_unshift($minute, '00', '01', '02', '03', '04', '05', '06', '07', '08', '09'); $date_form = make_select($prefix.'_day', array_combine(range(1, 31), range(1, 31)), $d_day); $date_form .= make_select($prefix.'_month', $month_list, $d_month); $date_form .= make_select( $prefix.'_year', array( $d_year - 2 => $d_year - 2, $d_year - 1 => $d_year - 1, $d_year => $d_year, $d_year + 1 => $d_year + 1, $d_year + 2 => $d_year + 2 ), $d_year ).' '; $date_form .= make_select($prefix.'_hour', array_combine(range(0, 23), range(0, 23)), $d_hour).' : '; $date_form .= make_select($prefix.'_minute', $minute, $d_minute); return $date_form; } /** * Draws an HTML form select with the given options * */ function make_select($name, $values, $checked = '') { $output = ''; return $output; } /** * Translates a form date into a more usable format * */ function get_date_from_select($prefix) { return $_POST[$prefix.'_year'].'-'.two_digits($_POST[$prefix.'_month']).'-'.two_digits( $_POST[$prefix.'_day'] ).' '.two_digits($_POST[$prefix.'_hour']).':'.two_digits($_POST[$prefix.'_minute']).':00'; } /** * Converts 1-9 to 01-09 */ function two_digits($number) { $number = (int)$number; return ($number < 10) ? '0'.$number : $number; } /** * Get wiki information * @param int wiki id * @return array wiki data */ function get_wiki_data($id) { global $tbl_wiki; $course_id = api_get_course_int_id(); $id = intval($id); $sql = 'SELECT * FROM '.$tbl_wiki.' WHERE c_id = '.$course_id.' AND id = '.$id.' '; $result = Database::query($sql); $data = array(); while ($row = Database::fetch_array($result, 'ASSOC')) { $data = $row; } return $data; }

'.get_lang('Feedback1').'		'.get_lang('Feedback2').'		'.get_lang('Feedback3').'

'.get_lang('FProgress').':	%	'.get_lang('FProgress').':	%	'.get_lang('FProgress').':	%

'.get_lang("StartDate").':	'; echo draw_date_picker('startdate_assig').' '.get_lang( 'Yes' ).'/'.get_lang('No').''; echo '
'.get_lang("EndDate").':	'; echo draw_date_picker('enddate_assig').' '.get_lang( 'Yes' ).'/'.get_lang('No').''; echo '
'.get_lang('AllowLaterSends').':

'.get_lang('DescriptionOfTheTask').'
'.stripslashes($row['task']).'	'.api_disp_html_area( 'task', '', '', '', null, array('ToolbarSet' => 'wiki_task', 'Width' => '580', 'Height' => '200') ).'