2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2010 */
6 /* Inclusive Design Institute */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
13 if (!defined('TR_INCLUDE_PATH')) { exit; }
15 function in_array_cin($strItem, $arItems)
17 foreach ($arItems as $key => $strValue)
19 if (strtoupper($strItem) == strtoupper($strValue))
29 //these are the _AT(x) variable names and their include file
30 /* tabs[tab_id] = array(tab_name, file_name, accesskey) */
31 $tabs[0] = array('content', 'edit.inc.php', 'n');
32 $tabs[1] = array('metadata', 'properties.inc.php', 'p');
33 $tabs[2] = array('alternative_content', 'alternatives.inc.php', 'l');
34 $tabs[3] = array('tests', 'tests.inc.php', 't');
40 function output_tabs($current_tab, $changes) {
43 $num_tabs = count($tabs);
45 <table class="etabbed-table" border="0" cellpadding="0" cellspacing="0" width="95%">
48 for ($i=0; $i < $num_tabs; $i++):
49 if ($current_tab == $i):?>
50 <td class="editor_tab_selected">
51 <?php if ($changes[$i]): ?>
52 <img src="<?php echo $_base_path; ?>images/changes_bullet.gif" alt="<?php echo _AT('usaved_changes_made'); ?>" height="12" width="15" />
54 <?php echo _AT($tabs[$i][0]); ?>
56 <td class="tab-spacer"> </td>
58 <td class="editor_tab">
59 <?php if ($changes[$i]): ?>
60 <img src="<?php echo $_base_path; ?>images/changes_bullet.gif" alt="<?php echo _AT('usaved_changes_made'); ?>" height="12" width="15" />
63 <?php echo '<input type="submit" name="button_'.$i.'" value="'._AT($tabs[$i][0]).'" title="'._AT($tabs[$i][0]).' - alt '.$tabs[$i][2].'" class="editor_buttontab" accesskey="'.$tabs[$i][2].'" onmouseover="this.style.cursor=\'pointer\';" '.$clickEvent.' />'; ?>
65 <td class="tab-spacer"> </td>
73 * Strips all tags and encodes special characters in the URL
74 * Returns false if the URL is invalid
77 * @return mixed - returns a stripped and encoded URL or false if URL is invalid
79 function isValidURL($url) {
80 if (substr($url,0,4) === 'http') {
81 return filter_var(filter_var($url, FILTER_SANITIZE_STRING), FILTER_VALIDATE_URL);
87 * Parse the primary resources out of the content and save into db.
88 * Clean up the removed primary resources from db.
89 * @param: $cid: content id
93 function populate_a4a($cid, $content, $formatting){
94 global $db, $my_files;
96 include_once(TR_INCLUDE_PATH.'classes/A4a/A4a.class.php');
97 include_once(TR_INCLUDE_PATH.'classes/XML/XML_HTMLSax/XML_HTMLSax.php'); /* for XML_HTMLSax */
98 include_once(TR_INCLUDE_PATH.'classes/ContentOutputParser.class.php'); /* for parser */
100 $body = format_content($content, $formatting,array());
102 $handler = new ContentOutputParser();
103 $parser = new XML_HTMLSax();
104 $parser->set_object($handler);
105 $parser->set_element_handler('openHandler','closeHandler');
108 $parser->parse($body);
109 $my_files = array_unique($my_files);
111 foreach ($my_files as $file) {
112 /* filter out full urls */
113 $url_parts = @parse_url($file);
115 // file should be relative to content
116 if ((substr($file, 0, 1) == '/')) {
120 // The URL of the movie from youtube.com has been converted above in embed_media().
121 // For example: http://www.youtube.com/watch?v=a0ryB0m0MiM is converted to
122 // http://www.youtube.com/v/a0ryB0m0MiM to make it playable. This creates the problem
123 // that the parsed-out url (http://www.youtube.com/v/a0ryB0m0MiM) does not match with
124 // the URL saved in content table (http://www.youtube.com/watch?v=a0ryB0m0MiM).
125 // The code below is to convert the URL back to original.
126 $file = convertYoutubePlayURLToWatchURL($file);
128 $resources[] = convertAmp($file); // converts & to &
131 if (count($resources) == 0) return;
133 $a4a = new A4a($cid);
134 $db_primary_resources = $a4a->getPrimaryResources();
136 // clean up the removed resources
137 foreach ($db_primary_resources as $primary_rid=>$db_resource){
138 //if this file from our table is not found in the $resource, then it's not used.
139 if(in_array($db_resource['resource'], $resources)===false){
140 $a4a->deletePrimaryResource($primary_rid);
144 // insert the new resources
145 foreach($resources as $primary_resource)
147 if (!$a4a->getPrimaryResourceByName($primary_resource)){
148 $a4a->setPrimaryResource($cid, $primary_resource, $_SESSION['lang']);
153 // save all changes to the DB
154 function save_changes($redir, $current_tab) {
155 global $contentManager, $addslashes, $msg, $_course_id, $_content_id;
157 $_POST['pid'] = intval($_POST['pid']);
158 $_POST['_cid'] = intval($_POST['_cid']);
160 $_POST['alternatives'] = intval($_POST['alternatives']);
162 $_POST['title'] = trim($_POST['title']);
163 $_POST['head'] = trim($_POST['head']);
164 $_POST['use_customized_head'] = isset($_POST['use_customized_head'])?$_POST['use_customized_head']:0;
165 $_POST['body_text'] = trim($_POST['body_text']);
166 $_POST['weblink_text'] = trim($_POST['weblink_text']);
167 $_POST['formatting'] = intval($_POST['formatting']);
168 $_POST['keywords'] = trim($_POST['keywords']);
169 $_POST['test_message'] = trim($_POST['test_message']);
171 //if weblink is selected, use it
172 if ($_POST['formatting']==CONTENT_TYPE_WEBLINK) {
173 $url = $_POST['weblink_text'];
174 $validated_url = isValidURL($url);
175 if (!validated_url || $validated_url !== $url) {
176 $msg->addError(array('INVALID_INPUT', _AT('weblink')));
178 $_POST['body_text'] = $url;
179 $content_type_pref = CONTENT_TYPE_WEBLINK;
182 $content_type_pref = CONTENT_TYPE_CONTENT;
185 /*if (!($release_date = generate_release_date())) {
186 $msg->addError('BAD_DATE');
189 // if ($_POST['title'] == '') {
190 // $msg->addError(array('EMPTY_FIELDS', _AT('title')));
193 // if (!$msg->containsErrors()) {
194 $orig_body_text = $_POST['body_text']; // used to populate a4a tables
195 // $_POST['title'] = $addslashes($_POST['title']);
196 // $_POST['body_text'] = $addslashes($_POST['body_text']);
197 // $_POST['head'] = $addslashes($_POST['head']);
198 // $_POST['keywords'] = $addslashes($_POST['keywords']);
199 // $_POST['test_message'] = $addslashes($_POST['test_message']);
201 // add or edit content
202 if ($_POST['_cid']) {
203 /* editing an existing page */
204 $err = $contentManager->editContent($_POST['_cid'], $_POST['title'], $_POST['body_text'],
205 $_POST['keywords'], $_POST['formatting'],
206 $_POST['head'], $_POST['use_customized_head'],
207 $_POST['test_message']);
208 $cid = $_POST['_cid'];
211 $cid = $contentManager->addContent($_course_id,
218 $_POST['formatting'],
220 $_POST['use_customized_head'],
221 $_POST['test_message'],
223 $_POST['_cid'] = $cid;
224 $_REQUEST['_cid'] = $cid;
226 // re-populate a4a tables based on the new content
227 populate_a4a($cid, $orig_body_text, $_POST['formatting']);
228 if ($cid == 0) return;
231 /* insert glossary terms */
233 if (is_array($_POST['glossary_defs']) && ($num_terms = count($_POST['glossary_defs']))) {
234 global $glossary, $glossary_ids, $msg;
236 foreach($_POST['glossary_defs'] as $w => $d) {
238 $key = in_array_cin($w, $glossary_ids);
240 $d = $addslashes($d);
242 if (($key !== false) && (($glossary[$old_w] != $d) || isset($_POST['related_term'][$old_w])) ) {
244 $related_id = intval($_POST['related_term'][$old_w]);
245 $sql = "UPDATE ".TABLE_PREFIX."glossary SET definition='$d', related_word_id=$related_id WHERE word_id=$key AND course_id=$_SESSION[course_id]";
246 $result = mysql_query($sql, $db);
247 $glossary[$old_w] = $d;
248 } else if ($key === false && ($d != '')) {
250 $related_id = intval($_POST['related_term'][$old_w]);
251 $sql = "INSERT INTO ".TABLE_PREFIX."glossary VALUES (NULL, $_SESSION[course_id], '$w', '$d', $related_id)";
253 $result = mysql_query($sql, $db);
254 $glossary[$old_w] = $d;
258 if (isset($_GET['tab'])) {
259 $current_tab = intval($_GET['tab']);
261 if (isset($_POST['current_tab'])) {
262 $current_tab = intval($_POST['current_tab']);
265 // adapted content: save primary content type
266 if (isset($_POST['use_post_for_alt']))
268 include_once(TR_INCLUDE_PATH.'classes/DAO/PrimaryResourcesTypesDAO.class.php');
269 $primaryResourcesTypesDAO = new PrimaryResourcesTypesDAO();
271 // 1. delete old primary content type
272 $sql = "DELETE FROM ".TABLE_PREFIX."primary_resources_types
273 WHERE primary_resource_id in
274 (SELECT DISTINCT primary_resource_id
275 FROM ".TABLE_PREFIX."primary_resources
276 WHERE content_id=".$cid."
277 AND language_code='".$_SESSION['lang']."')";
278 $primaryResourcesTypesDAO->execute($sql);
280 // 2. insert the new primary content type
281 $sql = "SELECT pr.primary_resource_id, rt.type_id
282 FROM ".TABLE_PREFIX."primary_resources pr, ".
283 TABLE_PREFIX."resource_types rt
284 WHERE pr.content_id = ".$cid."
285 AND pr.language_code = '".$_SESSION['lang']."'";
286 $all_types_rows = $primaryResourcesTypesDAO->execute($sql);
288 if (is_array($all_types_rows)) {
289 foreach ($all_types_rows as $type) {
290 if (isset($_POST['alt_'.$type['primary_resource_id'].'_'.$type['type_id']]))
292 $primaryResourcesTypesDAO->Create($type['primary_resource_id'], $type['type_id']);
293 // $sql = "INSERT INTO ".TABLE_PREFIX."primary_resources_types (primary_resource_id, type_id)
294 // VALUES (".$type['primary_resource_id'].", ".$type['type_id'].")";
295 // $result = mysql_query($sql, $db);
301 include_once(TR_INCLUDE_PATH.'classes/DAO/ContentTestsAssocDAO.class.php');
302 $contentTestsAssocDAO = new ContentTestsAssocDAO();
303 $test_rows = $contentTestsAssocDAO->getByContent($_POST['_cid']);
304 // $sql = 'SELECT * FROM '.TABLE_PREFIX."content_tests_assoc WHERE content_id=$_POST[cid]";
305 // $result = mysql_query($sql, $db);
306 $db_test_array = array();
307 if (is_array($test_rows)) {
308 foreach ($test_rows as $row) {
309 $db_test_array[] = $row['test_id'];
313 if (is_array($_POST['tid']) && sizeof($_POST['tid']) > 0){
314 $toBeDeleted = array_diff($db_test_array, $_POST['tid']);
315 $toBeAdded = array_diff($_POST['tid'], $db_test_array);
317 if (!empty($toBeDeleted)){
318 $tids = implode(",", $toBeDeleted);
319 $sql = 'DELETE FROM '. TABLE_PREFIX . "content_tests_assoc WHERE content_id=$_POST[cid] AND test_id IN ($tids)";
320 $contentTestsAssocDAO->execute($sql);
324 if (!empty($toBeAdded)){
325 foreach ($toBeAdded as $i => $tid){
327 // $sql = 'INSERT INTO '. TABLE_PREFIX . "content_tests_assoc SET content_id=$_POST[cid], test_id=$tid";
328 // $result = mysql_query($sql, $db);
329 if ($contentTestsAssocDAO->Create($_POST['_cid'], $tid) === false){
330 $msg->addError('DB_NOT_UPDATED');
335 //All tests has been removed.
336 $contentTestsAssocDAO->DeleteByContentID($_POST['_cid']);
337 // $sql = 'DELETE FROM '. TABLE_PREFIX . "content_tests_assoc WHERE content_id=$_POST[cid]";
338 // $result = mysql_query($sql, $db);
342 //TODO*******************BOLOGNA****************REMOVE ME**************/
344 if(isset($_SESSION['associated_forum']) && !$msg->containsErrors()){
345 if($_SESSION['associated_forum']=='none'){
346 $sql = "DELETE FROM ".TABLE_PREFIX."content_forums_assoc WHERE content_id='$_POST[cid]'";
347 mysql_query($sql,$db);
349 $sql = "DELETE FROM ".TABLE_PREFIX."content_forums_assoc WHERE content_id='$_POST[cid]'";
350 mysql_query($sql,$db);
351 $associated_forum = $_SESSION['associated_forum'];
352 for($i=0; $i<count($associated_forum); $i++){
353 $sql="INSERT INTO ".TABLE_PREFIX."content_forums_assoc SET content_id='$_POST[cid]',forum_id='$associated_forum[$i]'";
354 mysql_query($sql,$db);
357 unset($_SESSION['associated_forum']);
360 if (!$msg->containsErrors() && $redir) {
361 $_SESSION['save_n_close'] = $_POST['save_n_close'];
363 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
364 header('Location: '.basename($_SERVER['PHP_SELF']).'?_cid='.$cid.SEP.'close='.$addslashes($_POST['save_n_close']).SEP.'tab='.$addslashes($_POST['current_tab']).SEP.'displayhead='.$addslashes($_POST['displayhead']).SEP.'alternatives='.$addslashes($_POST['alternatives']));
371 function generate_release_date($now = false) {
379 $day = intval($_POST['day']);
380 $month = intval($_POST['month']);
381 $year = intval($_POST['year']);
382 $hour = intval($_POST['hour']);
383 $min = intval($_POST['min']);
386 if (!checkdate($month, $day, $year)) {
390 if (strlen($month) == 1){
393 if (strlen($day) == 1){
396 if (strlen($hour) == 1){
399 if (strlen($min) == 1){
402 $release_date = "$year-$month-$day $hour:$min:00";
404 return $release_date;
407 function check_for_changes($row, $row_alternatives) {
408 global $contentManager, $cid, $glossary, $glossary_ids_related, $addslashes;
412 if ($row && strcmp(trim($addslashes($_POST['title'])), addslashes($row['title']))) {
414 } else if (!$row && $_POST['title']) {
418 if ($row && strcmp($addslashes(trim($_POST['head'])), trim(addslashes($row['head'])))) {
420 } else if (!$row && $_POST['head']) {
424 if ($row && strcmp($addslashes(trim($_POST['body_text'])), trim(addslashes($row['text'])))) {
426 } else if (!$row && $_POST['body_text']) {
430 if ($row && strcmp($addslashes(trim($_POST['weblink_text'])), trim(addslashes($row['text'])))) {
432 } else if (!$row && $_POST['weblink_text']) {
436 /* use customized head: */
437 if ($row && isset($_POST['use_customized_head']) && ($_POST['use_customized_head'] != $row['use_customized_head'])) {
442 if ($row && strcmp(trim($_POST['formatting']), $row['formatting'])) {
444 } else if (!$row && $_POST['formatting']) {
449 // if ($row && strcmp(substr(generate_release_date(), 0, -2), substr($row['release_date'], 0, -2))) {
450 // /* the substr was added because sometimes the release_date in the db has the seconds field set, which we dont use */
451 // /* so it would show a difference, even though it should actually be the same, so we ignore the seconds with the -2 */
452 // /* the seconds gets added if the course was created during the installation process. */
453 // $changes[1] = true;
454 // } else if (!$row && strcmp(generate_release_date(), generate_release_date(true))) {
455 // $changes[1] = true;
458 /* related content: */
459 // $row_related = $contentManager->getRelatedContent($cid);
461 // if (is_array($_POST['related']) && is_array($row_related)) {
462 // $sum = array_sum(array_diff($_POST['related'], $row_related));
463 // $sum += array_sum(array_diff($row_related, $_POST['related']));
465 // $changes[1] = true;
467 // } else if (!is_array($_POST['related']) && !empty($row_related)) {
468 // $changes[1] = true;
472 if ($row && strcmp(trim($_POST['keywords']), $row['keywords'])) {
474 } else if (!$row && $_POST['keywords']) {
480 // if (is_array($_POST['glossary_defs'])) {
481 // global $glossary_ids;
482 // foreach ($_POST['glossary_defs'] as $w => $d) {
484 // $key = in_array_cin($w, $glossary_ids);
485 // if ($key === false) {
487 // $changes[2] = true;
489 // } else if ($cid && ($d &&($d != $glossary[$glossary_ids[$key]]))) {
490 // /* changed term */
491 // $changes[2] = true;
496 // if (is_array($_POST['related_term'])) {
497 // foreach($_POST['related_term'] as $term => $r_id) {
498 // if ($glossary_ids_related[$term] != $r_id) {
499 // $changes[2] = true;
506 /* adapted content */
507 if (isset($_POST['use_post_for_alt']))
509 foreach ($_POST as $alt_id => $alt_value) {
510 if (substr($alt_id, 0 ,4) == 'alt_' && $alt_value != $row_alternatives[$alt_id]){
518 if ($row && isset($_POST['test_message']) && $_POST['test_message'] != $row['test_message']){
522 $content_tests = $contentManager->getContentTestsAssoc($cid);
524 if (isset($_POST['visited_tests'])) {
525 if (!is_array($content_tests) && is_array($_POST['tid'])) {
528 if (is_array($content_tests)) {
529 for ($i = 0; $i < count($content_tests); $i++) {
530 if ($content_tests[$i]['test_id'] <> $_POST['tid'][$i]) {
541 function paste_from_file() {
544 include_once(TR_INCLUDE_PATH.'../home/classes/ContentUtility.class.php');
545 if ($_FILES['uploadedfile_paste']['name'] == '') {
546 $msg->addError('FILE_NOT_SELECTED');
549 if ($_FILES['uploadedfile_paste']['name']
550 && (($_FILES['uploadedfile_paste']['type'] == 'text/plain')
551 || ($_FILES['uploadedfile_paste']['type'] == 'text/html')) )
554 $path_parts = pathinfo($_FILES['uploadedfile_paste']['name']);
555 $ext = strtolower($path_parts['extension']);
557 if (in_array($ext, array('html', 'htm'))) {
558 $_POST['body_text'] = file_get_contents($_FILES['uploadedfile_paste']['tmp_name']);
560 /* get the <title></title> of this page */
562 $start_pos = strpos(strtolower($_POST['body_text']), '<title>');
563 $end_pos = strpos(strtolower($_POST['body_text']), '</title>');
565 if (($start_pos !== false) && ($end_pos !== false)) {
566 $start_pos += strlen('<title>');
567 $_POST['title'] = trim(substr($_POST['body_text'], $start_pos, $end_pos-$start_pos));
572 $_POST['head'] = ContentUtility::getHtmlHeadByTag($_POST['body_text'], array("link", "style", "script"));
573 if (strlen(trim($_POST['head'])) > 0)
574 $_POST['use_customized_head'] = 1;
576 $_POST['use_customized_head'] = 0;
578 $_POST['body_text'] = ContentUtility::getHtmlBody($_POST['body_text']);
580 $msg->addFeedback('FILE_PASTED');
581 } else if ($ext == 'txt') {
582 $_POST['body_text'] = file_get_contents($_FILES['uploadedfile_paste']['tmp_name']);
585 $msg->addFeedback('FILE_PASTED');
589 $msg->addError('BAD_FILE_TYPE');
595 //for accessibility checker
596 function write_temp_file() {
599 if (defined('TR_FORCE_GET_FILE') && TR_FORCE_GET_FILE) {
600 $content_base = 'get.php/';
602 $content_base = 'content/' . $_SESSION['course_id'] . '/';
605 if ($_POST['content_path']) {
606 $content_base .= $_POST['content_path'] . '/';
609 $file_name = $_POST['_cid'].'.html';
611 if ($handle = fopen(TR_CONTENT_DIR . $file_name, 'wb+')) {
612 // $temp_content = '<h2>'.TR_print(stripslashes($_POST['title']), 'content.title').'</h2>';
614 // if ($_POST['body_text'] != '') {
615 // $temp_content .= format_content(stripslashes($_POST['body_text']), $_POST['formatting'], $_POST['glossary_defs']);
617 // $temp_title = $_POST['title'];
619 // $html_template = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
620 // "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
621 // <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
623 // <base href="{BASE_HREF}" />
624 // <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
625 // <title>{TITLE}</title>
626 // <meta name="Generator" content="ATutor accessibility checker file - can be deleted">
633 // $page_html = str_replace( array('{BASE_HREF}', '{TITLE}', '{CONTENT}'),
634 // array($content_base, $temp_title, $temp_content),
637 if (!@fwrite($handle, stripslashes($_POST['body_text']))) {
638 $msg->addError('FILE_NOT_SAVED');
641 $msg->addError('FILE_NOT_SAVED');