wiki.inc.php 84 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @author Juan Carlos Raña <herodoto@telefonica.net>
  5. * @author Patrick Cool <patrick.cool@UGent.be>, Ghent University, Belgium*
  6. * @author Julio Montoya <gugli100@gmail.com> using the pdf.lib.php library
  7. *
  8. * @package chamilo.wiki
  9. */
  10. /* FUNCTIONS FOR WIKI */
  11. /**
  12. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  13. * @desc This function checks weither the proposed reflink is not in use yet. It is a recursive function because every newly created reflink suggestion
  14. * has to be checked also
  15. */
  16. function createreflink($testvalue)
  17. {
  18. $counter='';
  19. while (!checktitle($testvalue.$counter))
  20. {
  21. $counter++;
  22. echo $counter."-".$testvalue.$counter."<br />";
  23. }
  24. // the reflink has not been found yet, so it is OK
  25. return $testvalue.$counter;
  26. }
  27. /**
  28. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  29. **/
  30. function checktitle($paramwk)
  31. {
  32. global $tbl_wiki;
  33. global $groupfilter;
  34. global $condition_session;
  35. $sql='SELECT * FROM '.$tbl_wiki.' WHERE reflink="'.Database::escape_string($paramwk).'" AND '.$groupfilter.$condition_session.'';
  36. $result=Database::query($sql);
  37. $numberofresults=Database::num_rows($result);
  38. if ($numberofresults==0) // the value has not been found and is this available
  39. {
  40. return true;
  41. }
  42. else // the value has been found
  43. {
  44. return false;
  45. }
  46. }
  47. /**
  48. * @author Juan Carlos Raña <herodoto@telefonica.net>
  49. * check wikilinks that has a page
  50. **/
  51. function links_to($input)
  52. {
  53. $input_array=preg_split("/(\[\[|\]\])/",$input,-1, PREG_SPLIT_DELIM_CAPTURE);
  54. $all_links = array();
  55. foreach ($input_array as $key=>$value)
  56. {
  57. if ($input_array[$key-1]=='[[' AND $input_array[$key+1]==']]')
  58. {
  59. if (api_strpos($value, "|") !== false)
  60. {
  61. $full_link_array=explode("|", $value);
  62. $link=trim($full_link_array[0]);
  63. $title=trim($full_link_array[1]);
  64. }
  65. else
  66. {
  67. $link=trim($value);
  68. $title=trim($value);
  69. }
  70. unset($input_array[$key-1]);
  71. unset($input_array[$key+1]);
  72. $all_links[]= Database::escape_string(str_replace(' ','_',$link)).' '; //replace blank spaces by _ within the links. But to remove links at the end add a blank space
  73. }
  74. }
  75. $output=implode($all_links);
  76. return $output;
  77. }
  78. /*
  79. detect and add style to external links
  80. author Juan Carlos Raña Trabado
  81. **/
  82. function detect_external_link($input)
  83. {
  84. $exlink='href=';
  85. $exlinkStyle='class="wiki_link_ext" href=';
  86. $output=str_replace($exlink, $exlinkStyle, $input);
  87. return $output;
  88. }
  89. /*
  90. detect and add style to anchor links
  91. author Juan Carlos Raña Trabado
  92. **/
  93. function detect_anchor_link($input)
  94. {
  95. $anchorlink='href="#';
  96. $anchorlinkStyle='class="wiki_anchor_link" href="#';
  97. $output=str_replace($anchorlink, $anchorlinkStyle, $input);
  98. return $output;
  99. }
  100. /*
  101. detect and add style to mail links
  102. author Juan Carlos Raña Trabado
  103. **/
  104. function detect_mail_link($input)
  105. {
  106. $maillink='href="mailto';
  107. $maillinkStyle='class="wiki_mail_link" href="mailto';
  108. $output=str_replace($maillink, $maillinkStyle, $input);
  109. return $output;
  110. }
  111. /*
  112. detect and add style to ftp links
  113. author Juan Carlos Raña Trabado
  114. **/
  115. function detect_ftp_link($input)
  116. {
  117. $ftplink='href="ftp';
  118. $ftplinkStyle='class="wiki_ftp_link" href="ftp';
  119. $output=str_replace($ftplink, $ftplinkStyle, $input);
  120. return $output;
  121. }
  122. /*
  123. detect and add style to news links
  124. author Juan Carlos Raña Trabado
  125. **/
  126. function detect_news_link($input)
  127. {
  128. $newslink='href="news';
  129. $newslinkStyle='class="wiki_news_link" href="news';
  130. $output=str_replace($newslink, $newslinkStyle, $input);
  131. return $output;
  132. }
  133. /*
  134. detect and add style to irc links
  135. author Juan Carlos Raña Trabado
  136. **/
  137. function detect_irc_link($input)
  138. {
  139. $irclink='href="irc';
  140. $irclinkStyle='class="wiki_irc_link" href="irc';
  141. $output=str_replace($irclink, $irclinkStyle, $input);
  142. return $output;
  143. }
  144. /*
  145. * This function allows users to have [link to a title]-style links like in most regular wikis.
  146. * It is true that the adding of links is probably the most anoying part of Wiki for the people
  147. * who know something about the wiki syntax.
  148. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  149. * Improvements [[]] and [[ | ]]by Juan Carlos Raña
  150. * Improvements internal wiki style and mark group by Juan Carlos Raña
  151. **/
  152. function make_wiki_link_clickable($input)
  153. {
  154. global $_course;
  155. if (isset($_SESSION['_gid'])) {
  156. $_clean['group_id']=intval($_SESSION['_gid']);
  157. }
  158. if (isset($_GET['group_id'])) {
  159. $_clean['group_id']=intval($_GET['group_id']);
  160. }
  161. $session_id=api_get_session_id(); // TODO: check
  162. $input_array=preg_split("/(\[\[|\]\])/",$input,-1, PREG_SPLIT_DELIM_CAPTURE); //now doubles brackets
  163. foreach ($input_array as $key=>$value)
  164. {
  165. if ($input_array[$key-1]=='[[' AND $input_array[$key+1]==']]') //now doubles brackets
  166. {
  167. /////////// TODO: metawiki
  168. /*
  169. if ($session_id==0)
  170. {
  171. if ($_clean['group_id']==0)
  172. {
  173. $titleg_ex='';
  174. }
  175. else
  176. {
  177. $group_properties = GroupManager :: get_group_properties($_clean['group_id']);
  178. $group_name= $group_properties['name'];
  179. $titleg_ex='<sup><img src="css/wgroup.gif" alt="('.$group_name.')" title="Link to Wikigroup:'.$group_name.'"/></sup>';
  180. }
  181. }
  182. else
  183. {
  184. TODO:logic for sessions
  185. }
  186. */
  187. /////////
  188. //now full wikilink
  189. if (api_strpos($value, "|") !== false){
  190. $full_link_array=explode("|", $value);
  191. $link=trim(strip_tags($full_link_array[0]));
  192. $title=trim($full_link_array[1]);
  193. }
  194. else{
  195. $link=trim(strip_tags($value));
  196. $title=trim($value);
  197. }
  198. //if wikilink is homepage
  199. if($link=='index'){
  200. $title=get_lang('DefaultTitle');
  201. }
  202. if ($link==get_lang('DefaultTitle')){
  203. $link='index';
  204. }
  205. // note: checkreflink checks if the link is still free. If it is not used then it returns true, if it is used, then it returns false. Now the title may be different
  206. if (checktitle(strtolower(str_replace(' ','_',$link))))
  207. {
  208. $link = api_html_entity_decode($link);
  209. $input_array[$key]='<a href="'.api_get_path(WEB_PATH).'main/wiki/index.php?cidReq='.$_course[id].'&action=addnew&amp;title='.api_htmlentities(urlencode($link)).'&session_id='.$session_id.'&group_id='.$_clean['group_id'].'" class="new_wiki_link">'.$title.$titleg_ex.'</a>';
  210. }
  211. else
  212. {
  213. $input_array[$key]='<a href="'.api_get_path(WEB_PATH).'main/wiki/index.php?cidReq='.$_course[id].'&action=showpage&amp;title='.urlencode(strtolower(str_replace(' ','_',$link))).'&session_id='.$session_id.'&group_id='.$_clean['group_id'].'" class="wiki_link">'.$title.$titleg_ex.'</a>';
  214. }
  215. unset($input_array[$key-1]);
  216. unset($input_array[$key+1]);
  217. }
  218. }
  219. $output=implode('',$input_array);
  220. return $output;
  221. }
  222. /**
  223. * This function saves a change in a wiki page
  224. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  225. * @return language string saying that the changes are stored
  226. **/
  227. function save_wiki() {
  228. global $charset, $tbl_wiki, $_course, $tbl_wiki_conf;
  229. // NOTE: visibility, visibility_disc and ratinglock_disc changes are not made here, but through the interce buttons
  230. // cleaning the variables
  231. $_clean['page_id'] = Database::escape_string($_POST['page_id']);
  232. $_clean['reflink'] = Database::escape_string(trim($_POST['reflink']));
  233. $_clean['title'] = Database::escape_string(trim($_POST['title']));
  234. $_clean['content'] = Database::escape_string($_POST['content']);
  235. $_clean['user_id'] = api_get_user_id();
  236. $_clean['assignment'] = Database::escape_string($_POST['assignment']);
  237. $_clean['comment'] = Database::escape_string($_POST['comment']);
  238. $_clean['progress'] = Database::escape_string($_POST['progress']);
  239. $_clean['version'] = intval($_POST['version']) + 1 ;
  240. $_clean['linksto'] = links_to($_clean['content']); //and check links content
  241. $dtime = date( "Y-m-d H:i:s" );
  242. $session_id = api_get_session_id();
  243. if (isset($_SESSION['_gid']))
  244. {
  245. $_clean['group_id']=Database::escape_string($_SESSION['_gid']);
  246. }
  247. if (isset($_GET['group_id']))
  248. {
  249. $_clean['group_id']=Database::escape_string($_GET['group_id']);
  250. }
  251. //cleaning config variables
  252. if(!empty($_POST['task']))
  253. {
  254. $_clean['task']= Database::escape_string($_POST['task']);
  255. }
  256. if(!empty($_POST['feedback1']) || !empty($_POST['feedback2']) || !empty($_POST['feedback3'])) {
  257. $_clean['feedback1']=Database::escape_string($_POST['feedback1']);
  258. $_clean['feedback2']=Database::escape_string($_POST['feedback2']);
  259. $_clean['feedback3']=Database::escape_string($_POST['feedback3']);
  260. $_clean['fprogress1']=Database::escape_string($_POST['fprogress1']);
  261. $_clean['fprogress2']=Database::escape_string($_POST['fprogress2']);
  262. $_clean['fprogress3']=Database::escape_string($_POST['fprogress3']);
  263. }
  264. if(Security::remove_XSS($_POST['initstartdate']==1))
  265. {
  266. $_clean['startdate_assig']=Database::escape_string(get_date_from_select('startdate_assig'));
  267. }
  268. else
  269. {
  270. $_clean['startdate_assig']=Database::escape_string($_POST['startdate_assig']);
  271. }
  272. if(Security::remove_XSS($_POST['initenddate']==1))
  273. {
  274. $_clean['enddate_assig']=Database::escape_string(get_date_from_select('enddate_assig'));
  275. }
  276. else
  277. {
  278. $_clean['enddate_assig']=Database::escape_string($_POST['enddate_assig']);
  279. }
  280. $_clean['delayedsubmit']=Database::escape_string($_POST['delayedsubmit']);
  281. if(!empty($_POST['max_text']) || !empty($_POST['max_version']))
  282. {
  283. $_clean['max_text'] =Database::escape_string($_POST['max_text']);
  284. $_clean['max_version']=Database::escape_string($_POST['max_version']);
  285. }
  286. $sql = "INSERT INTO ".$tbl_wiki." (page_id, reflink, title, content, user_id, group_id, dtime, assignment, comment, progress, version, linksto, user_ip, session_id)
  287. VALUES ('".$_clean['page_id']."','".$_clean['reflink']."','".$_clean['title']."','".$_clean['content']."','".$_clean['user_id']."','".$_clean['group_id']."','".$dtime."','".$_clean['assignment']."','".$_clean['comment']."','".$_clean['progress']."','".$_clean['version']."','".$_clean['linksto']."','".Database::escape_string($_SERVER['REMOTE_ADDR'])."', '".Database::escape_string($session_id)."')";
  288. $result = Database::query($sql);
  289. $Id = Database::insert_id();
  290. if ($Id > 0) {
  291. //insert into item_property
  292. api_item_property_update(api_get_course_info(), TOOL_WIKI, $Id, 'WikiAdded', api_get_user_id(), $_clean['group_id']);
  293. }
  294. if ($_clean['page_id'] ==0) {
  295. $sql='UPDATE '.$tbl_wiki.' SET page_id="'.$Id.'" WHERE id="'.$Id.'"';
  296. Database::query($sql);
  297. }
  298. //update wiki config
  299. if ($_clean['reflink']=='index' && $_clean['version']==1)
  300. {
  301. $sql="INSERT INTO ".$tbl_wiki_conf." (page_id, task, feedback1, feedback2, feedback3, fprogress1, fprogress2, fprogress3, max_text, max_version, startdate_assig, enddate_assig, delayedsubmit)
  302. VALUES ('".$Id."','".$_clean['task']."','".$_clean['feedback1']."','".$_clean['feedback2']."','".$_clean['feedback3']."','".$_clean['fprogress1']."','".$_clean['fprogress2']."','".$_clean['fprogress3']."','".$_clean['max_text']."','".$_clean['max_version']."','".$_clean['startdate_assig']."','".$_clean['enddate_assig']."','".$_clean['delayedsubmit']."')";
  303. }
  304. else
  305. {
  306. $sql='UPDATE'.$tbl_wiki_conf.' SET task="'.$_clean['task'].'", feedback1="'.$_clean['feedback1'].'", feedback2="'.$_clean['feedback2'].'", feedback3="'.$_clean['feedback3'].'", fprogress1="'.$_clean['fprogress1'].'", fprogress2="'.$_clean['fprogress2'].'", fprogress3="'.$_clean['fprogress3'].'", max_text="'.$_clean['max_text'].'", max_version="'.$_clean['max_version'].'", startdate_assig="'.$_clean['startdate_assig'].'", enddate_assig="'.$_clean['enddate_assig'].'", delayedsubmit="'.$_clean['delayedsubmit'].'" WHERE page_id="'.$_clean['page_id'].'"';
  307. }
  308. Database::query($sql);
  309. api_item_property_update($_course, 'wiki', $Id, 'WikiAdded', api_get_user_id(), $_clean['group_id']);
  310. check_emailcue($_clean['reflink'], 'P', $dtime, $_clean['user_id']);
  311. return get_lang('ChangesStored');
  312. }
  313. /**
  314. * This function restore a wikipage
  315. * @author Juan Carlos Raña <herodoto@telefonica.net>
  316. **/
  317. function restore_wikipage($r_page_id, $r_reflink, $r_title, $r_content, $r_group_id, $r_assignment, $r_progress, $c_version, $r_version, $r_linksto)
  318. {
  319. global $tbl_wiki, $_course;
  320. $r_user_id= api_get_user_id();
  321. $r_dtime = date( "Y-m-d H:i:s" );
  322. $r_version = $r_version+1;
  323. $r_comment = get_lang('RestoredFromVersion').': '.$c_version;
  324. $session_id = api_get_session_id();
  325. $sql="INSERT INTO ".$tbl_wiki." (page_id, reflink, title, content, user_id, group_id, dtime, assignment, comment, progress, version, linksto, user_ip, session_id) VALUES ('".$r_page_id."','".$r_reflink."','".$r_title."','".$r_content."','".$r_user_id."','".$r_group_id."','".$r_dtime."','".$r_assignment."','".$r_comment."','".$r_progress."','".$r_version."','".$r_linksto."','".Database::escape_string($_SERVER['REMOTE_ADDR'])."','".Database::escape_string($session_id)."')";
  326. $result=Database::query($sql);
  327. $Id = Database::insert_id();
  328. api_item_property_update($_course, 'wiki', $Id, 'WikiAdded', api_get_user_id(), $r_group_id);
  329. check_emailcue($r_reflink, 'P', $r_dtime, $r_user_id);
  330. return get_lang('PageRestored');
  331. }
  332. /**
  333. * This function delete a wiki
  334. * @author Juan Carlos Raña <herodoto@telefonica.net>
  335. **/
  336. function delete_wiki() {
  337. global $tbl_wiki, $tbl_wiki_conf, $tbl_wiki_discuss, $tbl_wiki_mailcue, $groupfilter, $condition_session;
  338. //identify the first id by group = identify wiki
  339. $sql='SELECT * FROM '.$tbl_wiki.' WHERE '.$groupfilter.$condition_session.' ORDER BY id DESC';
  340. $allpages=Database::query($sql);
  341. while ($row=Database::fetch_array($allpages)) {
  342. $id = $row['id'];
  343. $group_id = $row['group_id'];
  344. $session_id = $row['session_id'];
  345. $page_id = $row['page_id'];
  346. Database::query('DELETE FROM '.$tbl_wiki_conf.' WHERE page_id="'.$id.'"');
  347. Database::query('DELETE FROM '.$tbl_wiki_discuss.' WHERE publication_id="'.$id.'"');
  348. }
  349. Database::query('DELETE FROM '.$tbl_wiki_mailcue.' WHERE session_id="'.$session_id.'" AND group_id="'.$group_id.'"');
  350. Database::query('DELETE FROM '.$tbl_wiki.' WHERE session_id="'.$session_id.'" AND group_id="'.$group_id.'"');
  351. return get_lang('WikiDeleted');
  352. }
  353. /**
  354. * This function saves a new wiki page.
  355. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  356. * @todo consider merging this with the function save_wiki into one single function.
  357. **/
  358. function save_new_wiki() {
  359. global $charset;
  360. global $tbl_wiki;
  361. global $assig_user_id; //need for assignments mode
  362. global $tbl_wiki_conf;
  363. global $page;
  364. // cleaning the variables
  365. $_clean['assignment']=Database::escape_string($_POST['assignment']);
  366. // session_id
  367. $session_id = api_get_session_id();
  368. if($_clean['assignment']==2 || $_clean['assignment']==1) {// Unlike ordinary pages of pages of assignments. Allow create a ordinary page although there is a assignment with the same name
  369. $page = str_replace(' ','_',$_POST['title']."_uass".$assig_user_id);
  370. } else {
  371. $page = str_replace(' ','_',$_POST['title']);
  372. }
  373. $_clean['reflink']=Database::escape_string(strip_tags(api_htmlentities($page)));
  374. $_clean['title']=Database::escape_string(strip_tags(trim($_POST['title'])));
  375. $_clean['content']= Database::escape_string($_POST['content']);
  376. //re-check after strip_tags if the title is empty
  377. if(empty($_clean['title']) || empty($_clean['reflink'])){
  378. return false;
  379. }
  380. if($_clean['assignment']==2) {//config by default for individual assignment (students)
  381. $_clean['user_id']=(int)Database::escape_string($assig_user_id);//Identifies the user as a creator, not the teacher who created
  382. $_clean['visibility']=0;
  383. $_clean['visibility_disc']=0;
  384. $_clean['ratinglock_disc']=0;
  385. } else {
  386. $_clean['user_id']=api_get_user_id();
  387. $_clean['visibility']=1;
  388. $_clean['visibility_disc']=1;
  389. $_clean['ratinglock_disc']=1;
  390. }
  391. $_clean['comment']=Database::escape_string($_POST['comment']);
  392. $_clean['progress']=Database::escape_string($_POST['progress']);
  393. $_clean['version']=1;
  394. if (isset($_SESSION['_gid']))
  395. {
  396. $_clean['group_id']=(int)$_SESSION['_gid'];
  397. }
  398. if (isset($_GET['group_id']))
  399. {
  400. $_clean['group_id']=(int)Database::escape_string($_GET['group_id']);
  401. }
  402. $_clean['linksto'] = links_to($_clean['content']); //check wikilinks
  403. //cleaning config variables
  404. $_clean['task']= Database::escape_string($_POST['task']);
  405. $_clean['feedback1']=Database::escape_string($_POST['feedback1']);
  406. $_clean['feedback2']=Database::escape_string($_POST['feedback2']);
  407. $_clean['feedback3']=Database::escape_string($_POST['feedback3']);
  408. $_clean['fprogress1']=Database::escape_string($_POST['fprogress1']);
  409. $_clean['fprogress2']=Database::escape_string($_POST['fprogress2']);
  410. $_clean['fprogress3']=Database::escape_string($_POST['fprogress3']);
  411. if($_POST['initstartdate']==1) {
  412. $_clean['startdate_assig']=Database::escape_string(get_date_from_select('startdate_assig'));
  413. } else {
  414. $_clean['startdate_assig']=Database::escape_string($_POST['startdate_assig']);
  415. }
  416. if($_POST['initenddate']==1) {
  417. $_clean['enddate_assig']=Database::escape_string(get_date_from_select('enddate_assig'));
  418. } else {
  419. $_clean['enddate_assig']=Database::escape_string($_POST['enddate_assig']);
  420. }
  421. $_clean['delayedsubmit']=Database::escape_string($_POST['delayedsubmit']);
  422. $_clean['max_text']=Database::escape_string($_POST['max_text']);
  423. $_clean['max_version']=Database::escape_string($_POST['max_version']);
  424. //filter no _uass
  425. if (api_eregi('_uass', $_POST['title']) || (api_strtoupper(trim($_POST['title'])) == 'INDEX' || api_strtoupper(trim(api_htmlentities($_POST['title'], ENT_QUOTES, $charset))) == api_strtoupper(api_htmlentities(get_lang('DefaultTitle'), ENT_QUOTES, $charset)))) {
  426. $message= get_lang('GoAndEditMainPage');
  427. Display::display_warning_message($message,false);
  428. } else {
  429. $var=$_clean['reflink'];
  430. $group_id=Security::remove_XSS($_GET['group_id']);
  431. if(!checktitle($var)) {
  432. return get_lang('WikiPageTitleExist').'<a href="index.php?action=edit&amp;title='.$var.'&group_id='.$group_id.'">'.$_POST['title'].'</a>';
  433. } else {
  434. $dtime = date( "Y-m-d H:i:s" );
  435. $sql = "INSERT INTO ".$tbl_wiki." (reflink, title, content, user_id, group_id, dtime, visibility, visibility_disc, ratinglock_disc, assignment, comment, progress, version, linksto, user_ip, session_id) VALUES ('".$_clean['reflink']."','".$_clean['title']."','".$_clean['content']."','".$_clean['user_id']."','".$_clean['group_id']."','".$dtime."','".$_clean['visibility']."','".$_clean['visibility_disc']."','".$_clean['ratinglock_disc']."','".$_clean['assignment']."','".$_clean['comment']."','".$_clean['progress']."','".$_clean['version']."','".$_clean['linksto']."','".Database::escape_string($_SERVER['REMOTE_ADDR'])."', '".Database::escape_string($session_id)."')";
  436. $result = Database::query($sql);
  437. $Id = Database::insert_id();
  438. if ($Id > 0) {
  439. //insert into item_property
  440. api_item_property_update(api_get_course_info(), TOOL_WIKI, $Id, 'WikiAdded', api_get_user_id(), $_clean['group_id']);
  441. }
  442. $sql='UPDATE '.$tbl_wiki.' SET page_id="'.$Id.'" WHERE id="'.$Id.'"';
  443. Database::query($sql);
  444. //insert wiki config
  445. $sql="INSERT INTO ".$tbl_wiki_conf." (page_id, task, feedback1, feedback2, feedback3, fprogress1, fprogress2, fprogress3, max_text, max_version, startdate_assig, enddate_assig, delayedsubmit) VALUES ('".$Id."','".$_clean['task']."','".$_clean['feedback1']."','".$_clean['feedback2']."','".$_clean['feedback3']."','".$_clean['fprogress1']."','".$_clean['fprogress2']."','".$_clean['fprogress3']."','".$_clean['max_text']."','".$_clean['max_version']."','".$_clean['startdate_assig']."','".$_clean['enddate_assig']."','".$_clean['delayedsubmit']."')";
  446. Database::query($sql);
  447. check_emailcue(0, 'A');
  448. return get_lang('NewWikiSaved');
  449. }
  450. }//end filter no _uass
  451. }
  452. /**
  453. * This function displays the form for adding a new wiki page.
  454. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  455. * @return html code
  456. **/
  457. function display_new_wiki_form()
  458. {
  459. global $_course, $page;
  460. ?>
  461. <script type="text/javascript">
  462. function CheckSend()
  463. {
  464. if(document.form1.title.value == "")
  465. {
  466. alert("<?php echo get_lang('NoWikiPageTitle');?>");
  467. document.form1.title.focus();
  468. return false;
  469. }
  470. return true;
  471. }
  472. function setFocus(){
  473. $("#wiki_title").focus();
  474. }
  475. $(document).ready(function () {
  476. setFocus();
  477. });
  478. </script>
  479. <?php
  480. //form
  481. echo '<form name="form1" method="post" onsubmit="return CheckSend()" action="'.api_get_self().'?cidReq='.$_course[id].'&action=showpage&amp;title='.api_htmlentities(urlencode(strtolower(str_replace(' ','_',$page)))).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">';
  482. echo '<div id="wikititle" style="min-height:30px;">';
  483. echo '<div style="width:70%;float:left;"><span class="form_required">*</span> '.get_lang(Title).': <input type="text" id="wiki_title" name="title" value="'.api_htmlentities($_GET['title']).'" size="40"></div>';
  484. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  485. {
  486. $_clean['group_id']=(int)$_SESSION['_gid']; // TODO: check if delete ?
  487. echo'<a href="javascript://" onclick="advanced_parameters()" ><span id="plus_minus" style="float:right">&nbsp;'.Display::return_icon('div_show.gif',get_lang('Show'),array('style'=>'vertical-align:middle')).'&nbsp;'.get_lang('AdvancedParameters').'</span></a>';
  488. echo '<div id="options" style="display:none; margin: 20px;" >';
  489. //task
  490. echo '<div>&nbsp;</div>';
  491. echo '<div style= "border : 1px dotted; padding:4px; margin-top:20px;">';
  492. echo '<input type="checkbox" value="1" name="checktask" onclick="javascript: if(this.checked){document.getElementById(\'option4\').style.display=\'block\';}else{document.getElementById(\'option4\').style.display=\'none\';}"/>&nbsp;
  493. '.Display::return_icon('wiki_task.png', get_lang('DefineTask'),'',22).' '.get_lang('DescriptionOfTheTask').'';
  494. echo '&nbsp;&nbsp;&nbsp;<span id="msg_error4" style="display:none;color:red"></span>';
  495. echo '<div id="option4" style="padding:4px; margin:5px; border:1px dotted; display:none;">';
  496. echo '<table border="0" style="font-weight:normal">';
  497. echo '<tr>';
  498. echo '<td>'.get_lang('DescriptionOfTheTask').'</td>';
  499. echo '</tr>';
  500. echo '<tr>';
  501. //echo '<td><textarea name="task" cols="60" rows="4" >'.stripslashes($row['task']).'</textarea></td>'; // TODO: ¿delete?
  502. echo '<td>'.api_disp_html_area('task', $row['task'], '', '', null, array('ToolbarSet' => 'wiki_task', 'Width' => '580', 'Height' => '200')).'</td>';
  503. echo '</tr>';
  504. echo '</table>';
  505. echo '</div>';
  506. //feedback
  507. echo '<div>&nbsp;</div><input type="checkbox" value="1" name="checkfeedback" onclick="javascript: if(this.checked){document.getElementById(\'option2\').style.display=\'block\';}else{document.getElementById(\'option2\').style.display=\'none\';}"/>&nbsp;'.get_lang('AddFeedback').'';
  508. echo '&nbsp;&nbsp;&nbsp;<span id="msg_error2" style="display:none;color:red"></span>';
  509. echo '<div id="option2" style="padding:4px; margin:5px; border:1px dotted; display:none;">';
  510. echo '<table border="0" style="font-weight:normal" align="center">';
  511. echo '<tr>';
  512. echo '<td colspan="2">'.get_lang('Feedback1').'</td>';
  513. echo '<td colspan="2">'.get_lang('Feedback2').'</td>';
  514. echo '<td colspan="2">'.get_lang('Feedback3').'</td>';
  515. echo '</tr>';
  516. echo '<tr>';
  517. echo '<td colspan="2"><textarea name="feedback1" cols="21" rows="4"></textarea></td>';
  518. echo '<td colspan="2"><textarea name="feedback2" cols="21" rows="4"></textarea></td>';
  519. echo '<td colspan="2"><textarea name="feedback3" cols="21" rows="4"></textarea></td>';
  520. echo '</tr>';
  521. echo '<tr>';
  522. echo '<td>'.get_lang('FProgress').':</td>';
  523. echo '<td><select name="fprogress1">
  524. <option value="0" selected>0</option>
  525. <option value="10">10</option>
  526. <option value="20">20</option>
  527. <option value="30">30</option>
  528. <option value="40">40</option>
  529. <option value="50">50</option>
  530. <option value="60">60</option>
  531. <option value="70">70</option>
  532. <option value="80">80</option>
  533. <option value="90">90</option>
  534. <option value="100">100</option>
  535. </select> %</td>';
  536. echo '<td>'.get_lang('FProgress').':</td>';
  537. echo '<td><select name="fprogress2">
  538. <option value="0" selected>0</option>
  539. <option value="10">10</option>
  540. <option value="20">20</option>
  541. <option value="30">30</option>
  542. <option value="40">40</option>
  543. <option value="50">50</option>
  544. <option value="60">60</option>
  545. <option value="70">70</option>
  546. <option value="80">80</option>
  547. <option value="90">90</option>
  548. <option value="100">100</option>
  549. </select> %</td>';
  550. echo '<td>'.get_lang('FProgress').':</td>';
  551. echo '<td><select name="fprogress3">
  552. <option value="0" selected>0</option>
  553. <option value="10">10</option>
  554. <option value="20">20</option>
  555. <option value="30">30</option>
  556. <option value="40">40</option>
  557. <option value="50">50</option>
  558. <option value="60">60</option>
  559. <option value="70">70</option>
  560. <option value="80">80</option>
  561. <option value="90">90</option>
  562. <option value="100">100</option>
  563. </select> %</td>';
  564. echo '</tr>';
  565. echo '</table>';
  566. echo '</div>';
  567. //time limit
  568. echo '<div>&nbsp;</div><input type="checkbox" value="1" name="checktimelimit" onclick="javascript: if(this.checked){document.getElementById(\'option1\').style.display=\'block\';}else{document.getElementById(\'option1\').style.display=\'none\';}"/>&nbsp;'.get_lang('PutATimeLimit').'';
  569. echo '&nbsp;&nbsp;&nbsp;<span id="msg_error1" style="display:none;color:red"></span>';
  570. echo '<div id="option1" style="padding:4px; margin:5px; border:1px dotted; display:none;">';
  571. echo '<table width="100%" border="0" style="font-weight:normal">';
  572. echo '<tr>';
  573. echo '<td align="right">'.get_lang("StartDate").':</td>';
  574. echo '<td>';
  575. echo draw_date_picker('startdate_assig').' <input type="checkbox" name="initstartdate" value="1"> '.get_lang('Yes').'/'.get_lang('No').'';
  576. echo '</td>';
  577. echo '</tr>';
  578. echo '<tr>';
  579. echo '<td align="right">'.get_lang("EndDate").':</td>';
  580. echo '<td>';
  581. echo draw_date_picker('enddate_assig').' <input type="checkbox" name="initenddate" value="1"> '.get_lang('Yes').'/'.get_lang('No').'';
  582. echo '</td>';
  583. echo '</tr>';
  584. echo '<tr>';
  585. echo '<td align="right">'.get_lang('AllowLaterSends').':</td>';
  586. echo '<td><input type="checkbox" name="delayedsubmit" value="1"></td>';
  587. echo '</tr>';
  588. echo'</table>';
  589. echo '</div>';
  590. //other limit
  591. echo '<div>&nbsp;</div><input type="checkbox" value="1" name="checkotherlimit" onclick="javascript: if(this.checked){document.getElementById(\'option3\').style.display=\'block\';}else{document.getElementById(\'option3\').style.display=\'none\';}"/>&nbsp;'.get_lang('OtherSettings').'';
  592. echo '&nbsp;&nbsp;&nbsp;<span id="msg_error3" style="display:none;color:red"></span>';
  593. echo '<div id="option3" style="padding:4px; margin:5px; border:1px dotted; display:none;">';
  594. echo '<div style="font-weight:normal"; align="center">'.get_lang('NMaxWords').':&nbsp;<input type="text" name="max_text" size="3">&nbsp;&nbsp;'.get_lang('NMaxVersion').':&nbsp;<input type="text" name="max_version" size="3"></div>';
  595. echo '</div>';
  596. echo '</div>';
  597. //to define as an individual assignment
  598. echo '<div style= "border : 1px dotted; padding:4px; margin-top:20px;"><img src="../img/wiki/assignment.png" title="'.get_lang('CreateAssignmentPage').'" alt="'.get_lang('CreateAssignmentPage').'"/>&nbsp;'.get_lang('DefineAssignmentPage').': <input type="checkbox" name="assignment" value="1"></div>'; // 1= teacher 2 =student
  599. //
  600. echo'</div>';
  601. }
  602. echo '</div>';
  603. echo '<div id="wikicontent">';
  604. api_disp_html_area('content', '', '', '', null, api_is_allowed_to_edit(null,true)
  605. ? array('ToolbarSet' => 'Wiki', 'Width' => '100%', 'Height' => '400')
  606. : array('ToolbarSet' => 'WikiStudent', 'Width' => '100%', 'Height' => '400', 'UserStatus' => 'student')
  607. );
  608. echo '<br/>';
  609. echo '<br/>';
  610. echo get_lang('Comments').':&nbsp;&nbsp;<input type="text" name="comment" size="40"><br /><br />';
  611. echo get_lang('Progress').':&nbsp;&nbsp;<select name="progress" id="progress">
  612. <option value="0" selected>0</option>
  613. <option value="10">10</option>
  614. <option value="20">20</option>
  615. <option value="30">30</option>
  616. <option value="40">40</option>
  617. <option value="50">50</option>
  618. <option value="60">60</option>
  619. <option value="70">70</option>
  620. <option value="80">80</option>
  621. <option value="90">90</option>
  622. <option value="100">100</option>
  623. </select> %';
  624. echo '<br/><br/>';
  625. echo '<input type="hidden" name="wpost_id" value="'.md5(uniqid(rand(), true)).'">';//prevent double post
  626. echo '<button class="save" type="submit" name="SaveWikiNew">'.get_lang('langSave').'</button>';//for button icon. Don't change name (see fckeditor/editor/plugins/customizations/fckplugin_compressed.js and fckplugin.js
  627. echo '</div>';
  628. echo '</form>';
  629. }
  630. /**
  631. * This function displays a wiki entry
  632. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  633. * @author Juan Carlos Raña Trabado
  634. * @return html code
  635. **/
  636. function display_wiki_entry($newtitle)
  637. {
  638. global $charset, $tbl_wiki, $tbl_wiki_conf, $groupfilter, $condition_session, $page;
  639. if($newtitle)
  640. {
  641. $pageMIX=$newtitle; //display the page after it is created
  642. }
  643. else
  644. {
  645. $pageMIX=$page;//display current page
  646. }
  647. $_clean['group_id']=(int)$_SESSION['_gid'];
  648. $session_id=api_get_session_id();
  649. if ($_GET['view'])
  650. {
  651. $_clean['view']=(int)Database::escape_string($_GET['view']);
  652. $filter=' AND '.$tbl_wiki.'.id="'.$_clean['view'].'"';
  653. }
  654. //first, check page visibility in the first page version
  655. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($pageMIX).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  656. $result=Database::query($sql);
  657. $row=Database::fetch_array($result);
  658. $KeyVisibility=$row['visibility'];
  659. // second, show the last version
  660. $sql='SELECT * FROM '.$tbl_wiki.', '.$tbl_wiki_conf.' WHERE '.$tbl_wiki_conf.'.page_id='.$tbl_wiki.'.page_id AND '.$tbl_wiki.'.reflink="'.Database::escape_string($pageMIX).'" AND '.$tbl_wiki.'.session_id='.$session_id.' AND '.$tbl_wiki.'.'.$groupfilter.' '.$filter.' ORDER BY id DESC';
  661. $result=Database::query($sql);
  662. $row=Database::fetch_array($result); // we do not need a while loop since we are always displaying the last version
  663. //update visits
  664. if($row['id'])
  665. {
  666. $sql='UPDATE '.$tbl_wiki.' SET hits=(hits+1) WHERE id='.$row['id'].'';
  667. Database::query($sql);
  668. }
  669. // if both are empty and we are displaying the index page then we display the default text.
  670. if ($row['content']=='' AND $row['title']=='' AND $page=='index')
  671. {
  672. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin() || GroupManager :: is_user_in_group(api_get_user_id(),$_SESSION['_gid']))
  673. {
  674. //Table structure for better export to pdf
  675. $default_table_for_content_Start='<table align="center" border="0"><tr><td align="center">';
  676. $default_table_for_content_End='</td></tr></table>';
  677. $content=$default_table_for_content_Start.sprintf(get_lang('DefaultContent'),api_get_path(WEB_IMG_PATH)).$default_table_for_content_End;
  678. $title=get_lang('DefaultTitle');
  679. }
  680. else
  681. {
  682. return Display::display_normal_message(get_lang('WikiStandBy'));
  683. }
  684. }
  685. else
  686. {
  687. $content=Security::remove_XSS($row['content'],COURSEMANAGERLOWSECURITY);
  688. $title= $row['title'];
  689. }
  690. //assignment mode: identify page type
  691. if($row['assignment']==1)
  692. {
  693. $icon_assignment=Display::return_icon('wiki_assignment.png', get_lang('AssignmentDescExtra'),'',22);
  694. }
  695. elseif($row['assignment']==2)
  696. {
  697. $icon_assignment=Display::return_icon('wiki_work.png', get_lang('AssignmentWork'),'',22);
  698. }
  699. //task mode
  700. if (!empty($row['task']))
  701. {
  702. $icon_task=Display::return_icon('wiki_task.png', get_lang('StandardTask'),'',22);
  703. }
  704. //Show page. Show page to all users if isn't hide page. Mode assignments: if student is the author, can view
  705. if($KeyVisibility=="1" || api_is_allowed_to_edit(false,true) || api_is_platform_admin() || ($row['assignment']==2 && $KeyVisibility=="0" && (api_get_user_id()==$row['user_id'])))
  706. {
  707. echo '<div id="wikititle">';
  708. // page action: protecting (locking) the page
  709. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  710. {
  711. if (check_protect_page()==1)
  712. {
  713. $protect_page= Display::return_icon('lock.png', get_lang('PageLockedExtra'),'',22);
  714. $lock_unlock_protect='unlock';
  715. }
  716. else
  717. {
  718. $protect_page= Display::return_icon('unlock.png', get_lang('PageUnlockedExtra'),'',22);
  719. $lock_unlock_protect='lock';
  720. }
  721. }
  722. echo '<span style="float:right;">';
  723. echo '<a href="index.php?action=showpage&amp;actionpage='.$lock_unlock_protect.'&amp;title='.api_htmlentities(urlencode($page)).'">'.$protect_page.'</a>';
  724. echo '</span>';
  725. //page action: visibility
  726. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  727. {
  728. if (check_visibility_page()==1)
  729. {
  730. // TODO: FIX This hides the icon eye closed to users of work they can see yours
  731. //if(($row['assignment']==2 && $KeyVisibility=="0" && (api_get_user_id()==$row['user_id']))==false)
  732. //{
  733. //
  734. // }
  735. $visibility_page= Display::return_icon('visible.png', get_lang('ShowPageExtra'),'',22);
  736. $lock_unlock_visibility='invisible';
  737. }
  738. else
  739. {
  740. $visibility_page= Display::return_icon('invisible.png', get_lang('HidePageExtra'),'',22);
  741. $lock_unlock_visibility='visible';
  742. }
  743. }
  744. echo '<span style="float:right;">';
  745. echo '<a href="index.php?action=showpage&amp;actionpage='.$lock_unlock_visibility.'&amp;title='.api_htmlentities(urlencode($page)).'">'.$visibility_page.'</a>';
  746. echo '</span>';
  747. //page action: notification
  748. if (api_is_allowed_to_session_edit())
  749. {
  750. if (check_notify_page($page)==1) {
  751. $notify_page= Display::return_icon('messagebox_info.png', get_lang('NotifyByEmail'),'',22);
  752. $lock_unlock_notify_page='unlocknotify';
  753. } else {
  754. $notify_page= Display::return_icon('mail.png', get_lang('CancelNotifyByEmail'),'',22);
  755. $lock_unlock_notify_page='locknotify';
  756. }
  757. }
  758. echo '<span style="float:right;">';
  759. echo '<a href="index.php?action=showpage&amp;actionpage='.$lock_unlock_notify_page.'&amp;title='.api_htmlentities(urlencode($page)).'">'.$notify_page.'</a>';
  760. echo '</span>';
  761. //page action: export to pdf
  762. echo '<span style="float:right;padding-top:5px;">';
  763. echo '<form name="form_export2PDF" method="post" action="index.php">';
  764. echo '<input type="hidden" name="action" value="export_to_pdf">';
  765. echo '<input type="hidden" name="wiki_id" value="'.$row['id'].'">';
  766. echo '<input type="image" src="../img/icons/22/pdf.png" border ="0" title="'.get_lang('ExportToPDF').'" alt="'.get_lang('ExportToPDF').'" style=" border:none; margin-top: -9px">';
  767. echo '</form>';
  768. echo '</span>';
  769. //page action: copy last version to doc area
  770. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  771. {
  772. echo '<span style="float:right;">';
  773. echo '<form name="form_export2DOC" method="post" action="index.php" >';
  774. echo '<input type=hidden name="export2DOC" value="export2doc">';
  775. echo '<input type=hidden name="titleDOC" value="'.api_htmlentities($title, ENT_QUOTES, $charset).'">';
  776. echo '<input type=hidden name="contentDOC" value="'.api_htmlentities($content, ENT_QUOTES, $charset).'">';
  777. echo '<input type="image" src="../img/icons/22/export_to_documents.png" border ="0" title="'.get_lang('ExportToDocArea').'" alt="'.get_lang('ExportToDocArea').'" style=" border:none; margin-top: -6px">';
  778. echo '</form>';
  779. echo '</span>';
  780. }
  781. //export to print
  782. ?>
  783. <script>
  784. function goprint()
  785. {
  786. var a = window.open('','','width=800,height=600');
  787. a.document.open("text/html");
  788. a.document.write(document.getElementById('wikicontent').innerHTML);
  789. a.document.close();
  790. a.print();
  791. }
  792. </script>
  793. <?php
  794. echo '<span style="float:right; cursor: pointer;">';
  795. echo Display::return_icon('printer.png', get_lang('Print'),array('onclick' => "javascript: goprint();"),'22');
  796. echo '</span>';
  797. if (empty($title))
  798. {
  799. $title=get_lang('DefaultTitle');
  800. }
  801. if (wiki_exist($title))
  802. {
  803. echo $icon_assignment.'&nbsp;'.$icon_task.'&nbsp;'.api_htmlentities($title);
  804. }
  805. else
  806. {
  807. echo api_htmlentities($title);
  808. }
  809. echo '</div>';
  810. echo '<div id="wikicontent">'. make_wiki_link_clickable(detect_external_link(detect_anchor_link(detect_mail_link(detect_ftp_link(detect_irc_link(detect_news_link($content))))))).'</div>';
  811. echo '<div id="wikifooter">'.get_lang('Progress').': '.$row['progress'].'%&nbsp;&nbsp;&nbsp;'.get_lang('Rating').': '.$row['score'].'&nbsp;&nbsp;&nbsp;'.get_lang('Words').': '.word_count($content).'</div>';
  812. }//end filter visibility
  813. } // end function display_wiki_entry
  814. /**
  815. * This function counted the words in a document. Thanks Adeel Khan
  816. */
  817. function word_count($document) {
  818. $search = array(
  819. '@<script[^>]*?>.*?</script>@si',
  820. '@<style[^>]*?>.*?</style>@siU',
  821. '@<![\s\S]*?--[ \t\n\r]*>@'
  822. );
  823. $document = preg_replace($search, '', $document);
  824. # strip all html tags
  825. $wc = strip_tags($document);
  826. //remove words and remove one letter words commented temporarily because of problems with utf8 support. TODO: fix and enable
  827. # remove 'words' that don't consist of alphanumerical characters or punctuation
  828. //$pattern = "#[^(\w|\d|\'|\"|\.|\!|\?|;|,|\\|\/|\-|:|\&|@)]+#";
  829. //$wc = trim(preg_replace($pattern, " ", $wc));
  830. # remove one-letter 'words' that consist only of punctuation
  831. //$wc = trim(preg_replace("#\s*[(\'|\"|\.|\!|\?|;|,|\\|\/|\-|:|\&|@)]\s*#", " ", $wc)); //
  832. # remove superfluous whitespace
  833. $wc = preg_replace("/\s\s+/", " ", $wc);
  834. # split string into an array of words
  835. $wc = explode(" ", $wc);
  836. # remove empty elements
  837. $wc = array_filter($wc);
  838. # return the number of words
  839. return count($wc);
  840. }
  841. /**
  842. * This function checks if wiki title exist
  843. */
  844. function wiki_exist($title)
  845. {
  846. global $tbl_wiki;
  847. global $groupfilter;
  848. global $condition_session;
  849. $sql='SELECT id FROM '.$tbl_wiki.'WHERE title="'.Database::escape_string($title).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  850. $result=Database::query($sql);
  851. $cant=Database::num_rows($result);
  852. if ($cant>0)
  853. return true;
  854. else
  855. return false;
  856. }
  857. /**
  858. * This function a wiki warning
  859. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  860. * @return html code
  861. **/
  862. function display_wiki_warning($variable)
  863. {
  864. echo '<div class="wiki_warning">'.$variable.'</div>';
  865. }
  866. /**
  867. * Checks if this navigation tab has to be set to active
  868. * @author Patrick Cool <patrick.cool@ugent.be>, Ghent University
  869. * @return html code
  870. */
  871. function is_active_navigation_tab($paramwk)
  872. {
  873. if ($_GET['action']==$paramwk)
  874. {
  875. return ' class="active"';
  876. }
  877. }
  878. /**
  879. * Lock add pages
  880. * @author Juan Carlos Raña <herodoto@telefonica.net>
  881. * return current database status of protect page and change it if get action
  882. */
  883. function check_addnewpagelock()
  884. {
  885. global $tbl_wiki;
  886. global $groupfilter;
  887. global $condition_session;
  888. $_clean['group_id']=(int)$_SESSION['_gid'];
  889. $sql='SELECT * FROM '.$tbl_wiki.'WHERE '.$groupfilter.$condition_session.' ORDER BY id ASC';
  890. $result=Database::query($sql);
  891. $row=Database::fetch_array($result);
  892. $status_addlock=$row['addlock'];
  893. //change status
  894. if (api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  895. {
  896. if ($_GET['actionpage']=='lockaddnew' && $status_addlock==1)
  897. {
  898. $status_addlock=0;
  899. }
  900. if ($_GET['actionpage']=='unlockaddnew' && $status_addlock==0)
  901. {
  902. $status_addlock=1;
  903. }
  904. Database::query('UPDATE '.$tbl_wiki.' SET addlock="'.Database::escape_string($status_addlock).'" WHERE '.$groupfilter.$condition_session.'');
  905. $sql='SELECT * FROM '.$tbl_wiki.'WHERE '.$groupfilter.$condition_session.' ORDER BY id ASC';
  906. $result=Database::query($sql);
  907. $row=Database::fetch_array($result);
  908. }
  909. //show status
  910. return $row['addlock'];
  911. }
  912. /**
  913. * Protect page
  914. * @author Juan Carlos Raña <herodoto@telefonica.net>
  915. * return current database status of protect page and change it if get action
  916. */
  917. function check_protect_page()
  918. {
  919. global $tbl_wiki;
  920. global $page;
  921. global $groupfilter;
  922. global $condition_session;
  923. $_clean['group_id']=(int)$_SESSION['_gid'];
  924. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  925. $result=Database::query($sql);
  926. $row=Database::fetch_array($result);
  927. $status_editlock=$row['editlock'];
  928. $id=$row['id'];
  929. ///change status
  930. if (api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  931. {
  932. if($_GET['actionpage']=='lock' && $status_editlock==0)
  933. {
  934. $status_editlock=1;
  935. }
  936. if($_GET['actionpage']=='unlock' && $status_editlock==1)
  937. {
  938. $status_editlock=0;
  939. }
  940. $sql='UPDATE '.$tbl_wiki.' SET editlock="'.Database::escape_string($status_editlock).'" WHERE id="'.$id.'"';
  941. Database::query($sql);
  942. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  943. $result=Database::query($sql);
  944. $row=Database::fetch_array($result);
  945. }
  946. //show status
  947. return $row['editlock'];
  948. }
  949. /**
  950. * Visibility page
  951. * @author Juan Carlos Raña <herodoto@telefonica.net>
  952. * return current database status of visibility and change it if get action
  953. */
  954. function check_visibility_page()
  955. {
  956. global $tbl_wiki;
  957. global $page;
  958. global $groupfilter;
  959. global $condition_session;
  960. $_clean['group_id']=(int)$_SESSION['_gid'];
  961. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  962. $result=Database::query($sql);
  963. $row=Database::fetch_array($result);
  964. $status_visibility=$row['visibility'];
  965. //change status
  966. if (api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  967. {
  968. if($_GET['actionpage']=='visible' && $status_visibility==0)
  969. {
  970. $status_visibility=1;
  971. }
  972. if($_GET['actionpage']=='invisible' && $status_visibility==1)
  973. {
  974. $status_visibility=0;
  975. }
  976. $sql='UPDATE '.$tbl_wiki.' SET visibility="'.Database::escape_string($status_visibility).'" WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session;
  977. Database::query($sql);
  978. //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
  979. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  980. $result=Database::query($sql);
  981. $row=Database::fetch_array($result);
  982. }
  983. if(empty($row['id']))
  984. {
  985. $row['visibility']= 1;
  986. }
  987. //show status
  988. return $row['visibility'];
  989. }
  990. /**
  991. * Visibility discussion
  992. * @author Juan Carlos Raña <herodoto@telefonica.net>
  993. * return current database status of discuss visibility and change it if get action page
  994. */
  995. function check_visibility_discuss()
  996. {
  997. global $tbl_wiki;
  998. global $page;
  999. global $groupfilter;
  1000. global $condition_session;
  1001. $_clean['group_id']=(int)$_SESSION['_gid'];
  1002. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1003. $result=Database::query($sql);
  1004. $row=Database::fetch_array($result);
  1005. $status_visibility_disc=$row['visibility_disc'];
  1006. //change status
  1007. if (api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  1008. {
  1009. if ($_GET['actionpage']=='showdisc' && $status_visibility_disc==0)
  1010. {
  1011. $status_visibility_disc=1;
  1012. }
  1013. if ($_GET['actionpage']=='hidedisc' && $status_visibility_disc==1)
  1014. {
  1015. $status_visibility_disc=0;
  1016. }
  1017. $sql='UPDATE '.$tbl_wiki.' SET visibility_disc="'.Database::escape_string($status_visibility_disc).'" WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session;
  1018. Database::query($sql);
  1019. //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
  1020. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1021. $result=Database::query($sql);
  1022. $row=Database::fetch_array($result);
  1023. }
  1024. //show status
  1025. return $row['visibility_disc'];
  1026. }
  1027. /**
  1028. * Lock add discussion
  1029. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1030. * return current database status of lock dicuss and change if get action
  1031. */
  1032. function check_addlock_discuss()
  1033. {
  1034. global $tbl_wiki;
  1035. global $page;
  1036. global $groupfilter;
  1037. global $condition_session;
  1038. $_clean['group_id']=(int)$_SESSION['_gid'];
  1039. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1040. $result=Database::query($sql);
  1041. $row=Database::fetch_array($result);
  1042. $status_addlock_disc=$row['addlock_disc'];
  1043. //change status
  1044. if (api_is_allowed_to_edit() || api_is_platform_admin())
  1045. {
  1046. if ($_GET['actionpage']=='lockdisc' && $status_addlock_disc==0)
  1047. {
  1048. $status_addlock_disc=1;
  1049. }
  1050. if ($_GET['actionpage']=='unlockdisc' && $status_addlock_disc==1)
  1051. {
  1052. $status_addlock_disc=0;
  1053. }
  1054. $sql='UPDATE '.$tbl_wiki.' SET addlock_disc="'.Database::escape_string($status_addlock_disc).'" WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session;
  1055. Database::query($sql);
  1056. //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
  1057. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1058. $result=Database::query($sql);
  1059. $row=Database::fetch_array($result);
  1060. }
  1061. //show status
  1062. return $row['addlock_disc'];
  1063. }
  1064. /**
  1065. * Lock rating discussion
  1066. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1067. * Return current database status of rating discuss and change it if get action
  1068. */
  1069. function check_ratinglock_discuss()
  1070. {
  1071. global $tbl_wiki;
  1072. global $page;
  1073. global $groupfilter;
  1074. global $condition_session;
  1075. $_clean['group_id']=(int)$_SESSION['_gid'];
  1076. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1077. $result=Database::query($sql);
  1078. $row=Database::fetch_array($result);
  1079. $status_ratinglock_disc=$row['ratinglock_disc'];
  1080. //change status
  1081. if (api_is_allowed_to_edit(false,true) || api_is_platform_admin())
  1082. {
  1083. if ($_GET['actionpage']=='lockrating' && $status_ratinglock_disc==0)
  1084. {
  1085. $status_ratinglock_disc=1;
  1086. }
  1087. if ($_GET['actionpage']=='unlockrating' && $status_ratinglock_disc==1)
  1088. {
  1089. $status_ratinglock_disc=0;
  1090. }
  1091. $sql='UPDATE '.$tbl_wiki.' SET ratinglock_disc="'.Database::escape_string($status_ratinglock_disc).'" WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session; //Visibility. Value to all,not only for the first
  1092. Database::query($sql);
  1093. //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
  1094. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.Database::escape_string($page).'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1095. $result=Database::query($sql);
  1096. $row=Database::fetch_array($result);
  1097. }
  1098. //show status
  1099. return $row['ratinglock_disc'];
  1100. }
  1101. /**
  1102. * Notify page changes
  1103. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1104. * return the current
  1105. */
  1106. function check_notify_page($reflink)
  1107. {
  1108. global $tbl_wiki;
  1109. global $groupfilter;
  1110. global $tbl_wiki_mailcue;
  1111. global $condition_session;
  1112. $_clean['group_id']=(int)$_SESSION['_gid'];
  1113. $session_id=api_get_session_id();
  1114. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.$reflink.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1115. $result=Database::query($sql);
  1116. $row=Database::fetch_array($result);
  1117. $id=$row['id'];
  1118. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="P"';
  1119. $result=Database::query($sql);
  1120. $row=Database::fetch_array($result);
  1121. $idm=$row['id'];
  1122. if (empty($idm))
  1123. {
  1124. $status_notify=0;
  1125. }
  1126. else
  1127. {
  1128. $status_notify=1;
  1129. }
  1130. //change status
  1131. if ($_GET['actionpage']=='locknotify' && $status_notify==0)
  1132. {
  1133. $sql="INSERT INTO ".$tbl_wiki_mailcue." (id, user_id, type, group_id, session_id) VALUES ('".$id."','".api_get_user_id()."','P','".$_clean['group_id']."','".$session_id."')";
  1134. Database::query($sql);
  1135. $status_notify=1;
  1136. }
  1137. if ($_GET['actionpage']=='unlocknotify' && $status_notify==1)
  1138. {
  1139. $sql='DELETE FROM '.$tbl_wiki_mailcue.' WHERE id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="P"'; //$_clean['group_id'] not necessary. CHECK FOR SESSIONS
  1140. Database::query($sql);
  1141. $status_notify=0;
  1142. }
  1143. //show status
  1144. return $status_notify;
  1145. }
  1146. /**
  1147. * Notify discussion changes
  1148. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1149. * Return current database status of rating discuss and change it if get action
  1150. */
  1151. function check_notify_discuss($reflink)
  1152. {
  1153. global $tbl_wiki;
  1154. global $groupfilter;
  1155. global $tbl_wiki_mailcue;
  1156. global $condition_session;
  1157. $_clean['group_id']=(int)$_SESSION['_gid'];
  1158. $session_id=api_get_session_id();
  1159. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.$reflink.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC';
  1160. $result=Database::query($sql);
  1161. $row=Database::fetch_array($result);
  1162. $id=$row['id'];
  1163. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="D"';
  1164. $result=Database::query($sql);
  1165. $row=Database::fetch_array($result);
  1166. $idm=$row['id'];
  1167. if (empty($idm))
  1168. {
  1169. $status_notify_disc=0;
  1170. }
  1171. else
  1172. {
  1173. $status_notify_disc=1;
  1174. }
  1175. //change status
  1176. if ($_GET['actionpage']=='locknotifydisc' && $status_notify_disc==0)
  1177. {
  1178. $sql="INSERT INTO ".$tbl_wiki_mailcue." (id, user_id, type, group_id, session_id) VALUES ('".$id."','".api_get_user_id()."','D','".$_clean['group_id']."','".$session_id."')";
  1179. Database::query($sql);
  1180. $status_notify_disc=1;
  1181. }
  1182. if ($_GET['actionpage']=='unlocknotifydisc' && $status_notify_disc==1)
  1183. {
  1184. $sql='DELETE FROM '.$tbl_wiki_mailcue.' WHERE id="'.$id.'" AND user_id="'.api_get_user_id().'" AND type="D"'; //$_clean['group_id'] not necessary TODO:CHECK FOR SESSIONS
  1185. Database::query($sql);
  1186. $status_notify_disc=0;
  1187. }
  1188. //show status
  1189. return $status_notify_disc;
  1190. }
  1191. /**
  1192. * Notify all changes
  1193. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1194. */
  1195. function check_notify_all()
  1196. {
  1197. global $tbl_wiki_mailcue;
  1198. $_clean['group_id']=(int)$_SESSION['_gid'];
  1199. $session_id=api_get_session_id();
  1200. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE user_id="'.api_get_user_id().'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"';
  1201. $result=Database::query($sql);
  1202. $row=Database::fetch_array($result);
  1203. $idm=$row['user_id'];
  1204. if (empty($idm))
  1205. {
  1206. $status_notify_all=0;
  1207. }
  1208. else
  1209. {
  1210. $status_notify_all=1;
  1211. }
  1212. //change status
  1213. if ($_GET['actionpage']=='locknotifyall' && $status_notify_all==0)
  1214. {
  1215. $sql="INSERT INTO ".$tbl_wiki_mailcue." (user_id, type, group_id, session_id) VALUES ('".api_get_user_id()."','F','".$_clean['group_id']."','".$session_id."')";
  1216. Database::query($sql);
  1217. $status_notify_all=1;
  1218. }
  1219. if ($_GET['actionpage']=='unlocknotifyall' && $status_notify_all==1)
  1220. {
  1221. $sql='DELETE FROM '.$tbl_wiki_mailcue.' WHERE user_id="'.api_get_user_id().'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"';
  1222. Database::query($sql);
  1223. $status_notify_all=0;
  1224. }
  1225. //show status
  1226. return $status_notify_all;
  1227. }
  1228. function check_emailcue($id_or_ref, $type, $lastime='', $lastuser='')
  1229. {
  1230. global $tbl_wiki;
  1231. global $groupfilter;
  1232. global $tbl_wiki_mailcue;
  1233. global $_course;
  1234. global $condition_session;
  1235. $_clean['group_id']=(int)$_SESSION['_gid'];
  1236. $session_id=api_get_session_id();
  1237. $group_properties = GroupManager :: get_group_properties($_clean['group_id']);
  1238. $group_name= $group_properties['name'];
  1239. $allow_send_mail=false; //define the variable to below
  1240. if ($type=='P')
  1241. {
  1242. //if modifying a wiki page
  1243. //first, current author and time
  1244. //Who is the author?
  1245. $userinfo= Database::get_user_info_from_id($lastuser);
  1246. $email_user_author= get_lang('EditedBy').': '.api_get_person_name($userinfo['firstname'], $userinfo['lastname']);
  1247. //When ?
  1248. $year = substr($lastime, 0, 4);
  1249. $month = substr($lastime, 5, 2);
  1250. $day = substr($lastime, 8, 2);
  1251. $hours=substr($lastime, 11,2);
  1252. $minutes=substr($lastime, 14,2);
  1253. $seconds=substr($lastime, 17,2);
  1254. $email_date_changes=$day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds;
  1255. //second, extract data from first reg
  1256. $sql='SELECT * FROM '.$tbl_wiki.'WHERE reflink="'.$id_or_ref.'" AND '.$groupfilter.$condition_session.' ORDER BY id ASC'; //id_or_ref is reflink from tblwiki
  1257. $result=Database::query($sql);
  1258. $row=Database::fetch_array($result);
  1259. $id=$row['id'];
  1260. $email_page_name=$row['title'];
  1261. if ($row['visibility']==1)
  1262. {
  1263. $allow_send_mail=true; //if visibility off - notify off
  1264. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE 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.
  1265. $result=Database::query($sql);
  1266. $emailtext=get_lang('EmailWikipageModified').' <strong>'.$email_page_name.'</strong> '.get_lang('Wiki');
  1267. }
  1268. }
  1269. elseif ($type=='D')
  1270. {
  1271. //if added a post to discuss
  1272. //first, current author and time
  1273. //Who is the author of last message?
  1274. $userinfo= Database::get_user_info_from_id($lastuser);
  1275. $email_user_author= get_lang('AddedBy').': '.api_get_person_name($userinfo['firstname'], $userinfo['lastname']);
  1276. //When ?
  1277. $year = substr($lastime, 0, 4);
  1278. $month = substr($lastime, 5, 2);
  1279. $day = substr($lastime, 8, 2);
  1280. $hours=substr($lastime, 11,2);
  1281. $minutes=substr($lastime, 14,2);
  1282. $seconds=substr($lastime, 17,2);
  1283. $email_date_changes=$day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds;
  1284. //second, extract data from first reg
  1285. $id=$id_or_ref; //$id_or_ref is id from tblwiki
  1286. $sql='SELECT * FROM '.$tbl_wiki.'WHERE id="'.$id.'" ORDER BY id ASC';
  1287. $result=Database::query($sql);
  1288. $row=Database::fetch_array($result);
  1289. $email_page_name=$row['title'];
  1290. if ($row['visibility_disc']==1)
  1291. {
  1292. $allow_send_mail=true; //if visibility off - notify off
  1293. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE 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
  1294. $result=Database::query($sql);
  1295. $emailtext=get_lang('EmailWikiPageDiscAdded').' <strong>'.$email_page_name.'</strong> '.get_lang('Wiki');
  1296. }
  1297. }
  1298. elseif($type=='A')
  1299. {
  1300. //for added pages
  1301. $id=0; //for tbl_wiki_mailcue
  1302. $sql='SELECT * FROM '.$tbl_wiki.' ORDER BY id DESC'; //the added is always the last
  1303. $result=Database::query($sql);
  1304. $row=Database::fetch_array($result);
  1305. $email_page_name=$row['title'];
  1306. //Who is the author?
  1307. $userinfo= Database::get_user_info_from_id($row['user_id']);
  1308. $email_user_author= get_lang('AddedBy').': '.api_get_person_name($userinfo['firstname'], $userinfo['lastname']);
  1309. //When ?
  1310. $year = substr($row['dtime'], 0, 4);
  1311. $month = substr($row['dtime'], 5, 2);
  1312. $day = substr($row['dtime'], 8, 2);
  1313. $hours=substr($row['dtime'], 11,2);
  1314. $minutes=substr($row['dtime'], 14,2);
  1315. $seconds=substr($row['dtime'], 17,2);
  1316. $email_date_changes=$day.' '.$month.' '.$year.' '.$hours.":".$minutes.":".$seconds;
  1317. if($row['assignment']==0)
  1318. {
  1319. $allow_send_mail=true;
  1320. }
  1321. elseif($row['assignment']==1)
  1322. {
  1323. $email_assignment=get_lang('AssignmentDescExtra').' ('.get_lang('AssignmentMode').')';
  1324. $allow_send_mail=true;
  1325. }
  1326. elseif($row['assignment']==2)
  1327. {
  1328. $allow_send_mail=false; //Mode tasks: avoids notifications to all users about all users
  1329. }
  1330. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE id="'.$id.'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=full
  1331. $result=Database::query($sql);
  1332. $emailtext=get_lang('EmailWikiPageAdded').' <strong>'.$email_page_name.'</strong> '.get_lang('In').' '. get_lang('Wiki');
  1333. }
  1334. elseif($type=='E')
  1335. {
  1336. $id=0;
  1337. $allow_send_mail=true;
  1338. //Who is the author?
  1339. $userinfo= Database::get_user_info_from_id(api_get_user_id()); //current user
  1340. $email_user_author= get_lang('DeletedBy').': '.api_get_person_name($userinfo['firstname'], $userinfo['lastname']);
  1341. //When ?
  1342. $today = date('r'); //current time
  1343. $email_date_changes=$today;
  1344. $sql='SELECT * FROM '.$tbl_wiki_mailcue.'WHERE id="'.$id.'" AND type="F" AND group_id="'.$_clean['group_id'].'" AND session_id="'.$session_id.'"'; //type: P=page, D=discuss, F=wiki
  1345. $result=Database::query($sql);
  1346. $emailtext=get_lang('EmailWikipageDedeleted');
  1347. }
  1348. ///make and send email
  1349. if ($allow_send_mail)
  1350. {
  1351. while ($row=Database::fetch_array($result))
  1352. {
  1353. $userinfo = Database::get_user_info_from_id($row['user_id']); //$row['user_id'] obtained from tbl_wiki_mailcue
  1354. $name_to = api_get_person_name($userinfo['firstname'], $userinfo['lastname'], null, PERSON_NAME_EMAIL_ADDRESS);
  1355. $email_to = $userinfo['email'];
  1356. $sender_name = api_get_setting('emailAdministrator');
  1357. $sender_email = api_get_setting('emailAdministrator');
  1358. $email_subject = get_lang('EmailWikiChanges').' - '.$_course['official_code'];
  1359. $email_body = get_lang('DearUser').' '.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).',<br /><br />';
  1360. if($session_id==0){
  1361. $email_body .= $emailtext.' <strong>'.$_course['name'].' - '.$group_name.'</strong><br /><br /><br />';
  1362. }else{
  1363. $email_body .= $emailtext.' <strong>'.$_course['name'].' ('.api_get_session_name($current_session_id).') - '.$group_name.'</strong><br /><br /><br />';
  1364. }
  1365. $email_body .= $email_user_author.' ('.$email_date_changes.')<br /><br /><br />';
  1366. $email_body .= $email_assignment.'<br /><br /><br />';
  1367. $email_body .= '<font size="-2">'.get_lang('EmailWikiChangesExt_1').': <strong>'.get_lang('NotifyChanges').'</strong><br />';
  1368. $email_body .= get_lang('EmailWikiChangesExt_2').': <strong>'.get_lang('NotNotifyChanges').'</strong></font><br />';
  1369. @api_mail_html($name_to, $email_to, $email_subject, $email_body, $sender_name, $sender_email);
  1370. }
  1371. }
  1372. }
  1373. /**
  1374. * Function export last wiki page version to document area
  1375. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1376. */
  1377. function export2doc($wikiTitle, $wikiContents, $groupId)
  1378. {
  1379. global $_course;
  1380. $session_id=api_get_session_id();
  1381. $template =
  1382. '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  1383. <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="{LANGUAGE}" lang="{LANGUAGE}">
  1384. <head>
  1385. <title>{TITLE}</title>
  1386. <meta http-equiv="Content-Type" content="text/html; charset={ENCODING}" />
  1387. <style type="text/css" media="screen, projection">
  1388. /*<![CDATA[*/
  1389. {CSS}
  1390. /*]]>*/
  1391. </style>
  1392. {ASCIIMATHML_SCRIPT}</head>
  1393. <body dir="{TEXT_DIRECTION}">
  1394. {CONTENT}
  1395. </body>
  1396. </html>';
  1397. $css_file = api_get_path(TO_SYS, WEB_CSS_PATH).api_get_setting('stylesheets').'/default.css';
  1398. if (file_exists($css_file)) {
  1399. $css = @file_get_contents($css_file);
  1400. } else {
  1401. $css = '';
  1402. }
  1403. // Fixing some bugs in css files.
  1404. $root_rel = api_get_path(REL_PATH);
  1405. $css_path = 'main/css/';
  1406. $theme = api_get_setting('stylesheets').'/';
  1407. $css = str_replace('behavior:url("/main/css/csshover3.htc");', '', $css);
  1408. $css = str_replace('main/', $root_rel.'main/', $css);
  1409. $css = str_replace('images/', $root_rel.$css_path.$theme.'images/', $css);
  1410. $css = str_replace('../../img/', $root_rel.'main/img/', $css);
  1411. $asciimathmal_script = (api_contains_asciimathml($wikiContents) || api_contains_asciisvg($wikiContents))
  1412. ? '<script src="'.api_get_path(TO_REL, SCRIPT_ASCIIMATHML).'" type="text/javascript"></script>'."\n" : '';
  1413. $template = str_replace(array('{LANGUAGE}', '{ENCODING}', '{TEXT_DIRECTION}', '{TITLE}', '{CSS}', '{ASCIIMATHML_SCRIPT}'),
  1414. array(api_get_language_isocode(), api_get_system_encoding(), api_get_text_direction(), $wikiTitle, $css, $asciimathmal_script),
  1415. $template);
  1416. if (0 != $groupId)
  1417. {
  1418. $groupPart = '_group' . $groupId; // and add groupId to put the same document title in different groups
  1419. $group_properties = GroupManager :: get_group_properties($groupId);
  1420. $groupPath = $group_properties['directory'];
  1421. }
  1422. else
  1423. {
  1424. $groupPart = '';
  1425. $groupPath ='';
  1426. }
  1427. $exportDir = api_get_path(SYS_COURSE_PATH).api_get_course_path(). '/document'.$groupPath;
  1428. $exportFile = replace_dangerous_char($wikiTitle, 'strict') . $groupPart;
  1429. $clean_wikiContents = trim(preg_replace("/\[\[|\]\]/", " ", $wikiContents));
  1430. $array_clean_wikiContents= explode('|', $clean_wikiContents);
  1431. $wikiContents= $array_clean_wikiContents[1];
  1432. $wikiContents = str_replace('{CONTENT}', $wikiContents, $template);
  1433. // replace relative path by absolute path for courses, so you can see items into this page wiki (images, mp3, etc..) exported in documents
  1434. if (api_strpos($wikiContents,'../../courses/') !== false) {
  1435. $web_course_path = api_get_path(WEB_COURSE_PATH);
  1436. $wikiContents = str_replace('../../courses/',$web_course_path,$wikiContents);
  1437. }
  1438. $doc_id = 0;
  1439. $i = 1;
  1440. while ( file_exists($exportDir . '/' .$exportFile.'_'.$i.'.html') ) $i++; //only export last version, but in new export new version in document area
  1441. $wikiFileName = $exportFile . '_' . $i . '.html';
  1442. $exportPath = $exportDir . '/' . $wikiFileName;
  1443. file_put_contents( $exportPath, $wikiContents );
  1444. $doc_id = add_document($_course, $groupPath.'/'.$wikiFileName, 'file', filesize($exportPath), $wikiTitle);
  1445. api_item_property_update($_course, TOOL_DOCUMENT, $doc_id, 'DocumentAdded', api_get_user_id(), $groupId);
  1446. return $doc_id;
  1447. // TODO: link to go document area
  1448. }
  1449. function export_to_pdf($id, $course_code) {
  1450. require_once api_get_path(LIBRARY_PATH).'pdf.lib.php';
  1451. $data = get_wiki_data($id);
  1452. $content_pdf = api_html_entity_decode($data['content'], ENT_QUOTES, api_get_system_encoding());
  1453. //clean wiki links
  1454. $clean_pdf_content=trim(preg_replace("/\[\[|\]\]/", " ", $content_pdf));
  1455. $array_clean_pdf_content= explode('|', $clean_pdf_content);
  1456. $content_pdf= $array_clean_pdf_content[1];
  1457. $title_pdf = api_html_entity_decode($data['title'], ENT_QUOTES, api_get_system_encoding());
  1458. $title_pdf = api_utf8_encode($title_pdf, api_get_system_encoding());
  1459. $content_pdf = api_utf8_encode($content_pdf, api_get_system_encoding());
  1460. $html='
  1461. <!-- defines the headers/footers - this must occur before the headers/footers are set -->
  1462. <!--mpdf
  1463. <pageheader name="odds" content-left="'.$title_pdf.'" header-style-left="color: #880000; font-style: italic;" line="1" />
  1464. <pagefooter name="odds" content-right="{PAGENO}/{nb}" line="1" />
  1465. <!-- set the headers/footers - they will occur from here on in the document -->
  1466. <!--mpdf
  1467. <setpageheader name="odds" page="odd" value="on" show-this-page="1" />
  1468. <setpagefooter name="odds" page="O" value="on" />
  1469. mpdf-->'.$content_pdf;
  1470. $css_file = api_get_path(TO_SYS, WEB_CSS_PATH).api_get_setting('stylesheets').'/print.css';
  1471. if (file_exists($css_file)) {
  1472. $css = @file_get_contents($css_file);
  1473. } else {
  1474. $css = '';
  1475. }
  1476. $pdf = new PDF();
  1477. $pdf->content_to_pdf($html, $css, $title_pdf, $course_code);
  1478. exit;
  1479. }
  1480. /**
  1481. * Function prevent double post (reload or F5)
  1482. */
  1483. function double_post($wpost_id)
  1484. {
  1485. if(isset($_SESSION['wpost_id']))
  1486. {
  1487. if ($wpost_id == $_SESSION['wpost_id'])
  1488. {
  1489. return false;
  1490. }
  1491. else
  1492. {
  1493. $_SESSION['wpost_id'] = $wpost_id;
  1494. return true;
  1495. }
  1496. }
  1497. else
  1498. {
  1499. $_SESSION['wpost_id'] = $wpost_id;
  1500. return true;
  1501. }
  1502. }
  1503. /**
  1504. * Function wizard individual assignment
  1505. * @author Juan Carlos Raña <herodoto@telefonica.net>
  1506. */
  1507. function auto_add_page_users($assignment_type)
  1508. {
  1509. global $assig_user_id, $session_id; //$assig_user_id is need to identify end reflinks
  1510. $_clean['group_id']=(int)$_SESSION['_gid'];
  1511. if($_clean['group_id']==0)
  1512. {
  1513. //extract course members
  1514. if(!empty($session_id)){
  1515. $a_users_to_add = CourseManager :: get_user_list_from_course_code($_SESSION['_course']['id'], true, $session_id);
  1516. }
  1517. else
  1518. {
  1519. $a_users_to_add = CourseManager :: get_user_list_from_course_code($_SESSION['_course']['id'], true);
  1520. }
  1521. }
  1522. else
  1523. {
  1524. //extract group members
  1525. $subscribed_users = GroupManager :: get_subscribed_users($_clean['group_id']);
  1526. $subscribed_tutors = GroupManager :: get_subscribed_tutors($_clean['group_id']);
  1527. $a_users_to_add_with_duplicates=array_merge($subscribed_users, $subscribed_tutors);
  1528. //remove duplicates
  1529. $a_users_to_add = $a_users_to_add_with_duplicates;
  1530. //array_walk($a_users_to_add, create_function('&$value,$key', '$value = json_encode($value);'));
  1531. $a_users_to_add = array_unique($a_users_to_add);
  1532. //array_walk($a_users_to_add, create_function('&$value,$key', '$value = json_decode($value, true);'));
  1533. }
  1534. //echo print_r($a_users_to_add);
  1535. $all_students_pages = array();
  1536. //data about teacher
  1537. $userinfo=Database::get_user_info_from_id(api_get_user_id());
  1538. require_once api_get_path(INCLUDE_PATH).'/lib/usermanager.lib.php';
  1539. if (api_get_user_id()<>0)
  1540. {
  1541. $image_path = UserManager::get_user_picture_path_by_id(api_get_user_id(),'web',false, true);
  1542. $image_repository = $image_path['dir'];
  1543. $existing_image = $image_path['file'];
  1544. $photo= '<img src="'.$image_repository.$existing_image.'" alt="'.$name.'" width="40" height="50" align="top" title="'.$name.'" />';
  1545. }
  1546. else
  1547. {
  1548. $photo= '<img src="'.api_get_path(WEB_CODE_PATH)."img/unknown.jpg".'" alt="'.$name.'" width="40" height="50" align="top" title="'.$name.'" />';
  1549. }
  1550. //teacher assignment title
  1551. $title_orig=$_POST['title'];
  1552. //teacher assignment reflink
  1553. $link2teacher=$_POST['title']= $title_orig."_uass".api_get_user_id();
  1554. //first: teacher name, photo, and assignment description (original content)
  1555. // $content_orig_A='<div align="center" style="background-color: #F5F8FB; border:double">'.$photo.'<br />'.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).'<br />('.get_lang('Teacher').')</div><br/><div>';
  1556. $content_orig_A='<div align="center" style="background-color: #F5F8FB; border:solid; border-color: #E6E6E6"><table border="0"><tr><td style="font-size:24px">'.get_lang('AssignmentDesc').'</td></tr><tr><td>'.$photo.'<br />'.api_get_person_name($userinfo['firstname'], $userinfo['lastname']).'</td></tr></table></div>';
  1557. $content_orig_B='<br/><div align="center" style="font-size:24px">'.get_lang('AssignmentDescription').': '.$title_orig.'</div><br/>'.$_POST['content'];
  1558. //Second: student list (names, photo and links to their works).
  1559. //Third: Create Students work pages.
  1560. foreach($a_users_to_add as $user_id=>$o_user_to_add)
  1561. {
  1562. if($o_user_to_add['user_id'] != api_get_user_id()) //except that puts the task
  1563. {
  1564. $assig_user_id= $o_user_to_add['user_id']; //identifies each page as created by the student, not by teacher
  1565. $image_path = UserManager::get_user_picture_path_by_id($assig_user_id,'web',false, true);
  1566. $image_repository = $image_path['dir'];
  1567. $existing_image = $image_path['file'];
  1568. $name = api_get_person_name($o_user_to_add['firstname'], $o_user_to_add['lastname']);
  1569. $photo= '<img src="'.$image_repository.$existing_image.'" alt="'.$name.'" width="40" height="50" align="bottom" title="'.$name.'" />';
  1570. $is_tutor_of_group = GroupManager :: is_tutor_of_group($assig_user_id,$_clean['group_id']); //student is tutor
  1571. $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
  1572. if($is_tutor_and_member)
  1573. {
  1574. $status_in_group=get_lang('GroupTutorAndMember');
  1575. }
  1576. else
  1577. {
  1578. if($is_tutor_of_group)
  1579. {
  1580. $status_in_group=get_lang('GroupTutor');
  1581. }
  1582. else
  1583. {
  1584. $status_in_group=" "; //get_lang('GroupStandardMember')
  1585. }
  1586. }
  1587. if($assignment_type==1)
  1588. {
  1589. $_POST['title']= $title_orig;
  1590. $_POST['comment']=get_lang('AssignmentFirstComToStudent');
  1591. $_POST['content']='<div align="center" style="background-color: #F5F8FB; border:solid; border-color: #E6E6E6"><table border="0"><tr><td style="font-size:24px">'.get_lang('AssignmentWork').'</td></tr><tr><td>'.$photo.'<br />'.$name.'</td></tr></table></div>[['.$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
  1592. //AssignmentLinktoTeacherPage
  1593. $all_students_pages[] = '<li>'.strtoupper($o_user_to_add['lastname']).', '.$o_user_to_add['firstname'].' [['.$_POST['title']."_uass".$assig_user_id.' | '.$photo.']] '.$status_in_group.'</li>'; //don't change this line without guaranteeing that users will be ordered by last names in the following format (surname, name)
  1594. //$all_students_pages[] = '<li><table border="0"><tr><td width="200">'.api_get_person_name($o_user_to_add['lastname'], $o_user_to_add['firstname']).'</td><td>[['.$_POST['title']."_uass".$assig_user_id.' | '.$photo.']] '.$status_in_group.'</td></tr></table></li>';
  1595. $_POST['assignment']=2;
  1596. }
  1597. save_new_wiki();
  1598. }
  1599. }//end foreach for each user
  1600. foreach($a_users_to_add as $user_id=>$o_user_to_add)
  1601. {
  1602. if($o_user_to_add['user_id'] == api_get_user_id())
  1603. {
  1604. $assig_user_id=$o_user_to_add['user_id'];
  1605. if($assignment_type==1)
  1606. {
  1607. $_POST['title']= $title_orig;
  1608. $_POST['comment']=get_lang('AssignmentDesc');
  1609. sort($all_students_pages);
  1610. $_POST['content']=$content_orig_A.$content_orig_B.'<br/><div align="center" style="font-size:18px; background-color: #F5F8FB; border:solid; border-color:#E6E6E6">'.get_lang('AssignmentLinkstoStudentsPage').'</div><br/><div style="background-color: #F5F8FB; border:solid; border-color:#E6E6E6"><ol>'.implode($all_students_pages).'</ol></div><br/>';
  1611. $_POST['assignment']=1;
  1612. }
  1613. save_new_wiki();
  1614. }
  1615. } //end foreach to teacher
  1616. }
  1617. /**
  1618. * Enter description here...
  1619. *
  1620. */
  1621. function display_wiki_search_results($search_term, $search_content=0)
  1622. {
  1623. global $tbl_wiki, $groupfilter, $MonthsLong, $condition_session;
  1624. echo '<div class="row"><div class="form_header">'.get_lang('WikiSearchResults').'</div></div>';
  1625. $_clean['group_id']=(int)$_SESSION['_gid'];
  1626. $session_id=api_get_session_id();
  1627. if(api_is_allowed_to_edit(false,true) || api_is_platform_admin()) //only by professors if page is hidden
  1628. {
  1629. if($search_content=='1')
  1630. {
  1631. $sql="SELECT * FROM ".$tbl_wiki." s1 WHERE 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 s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")";// warning don't use group by reflink because don't return the last version
  1632. }
  1633. else
  1634. {
  1635. $sql="SELECT * FROM ".$tbl_wiki." s1 WHERE title LIKE '%".Database::escape_string($search_term)."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")";// warning don't use group by reflink because don't return the last version
  1636. }
  1637. }
  1638. else
  1639. {
  1640. if($search_content=='1')
  1641. {
  1642. $sql="SELECT * FROM ".$tbl_wiki." s1 WHERE 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 s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")";// warning don't use group by reflink because don't return the last version
  1643. }
  1644. else
  1645. {
  1646. $sql="SELECT * FROM ".$tbl_wiki." s1 WHERE visibility=1 AND title LIKE '%".Database::escape_string($search_term)."%' AND id=(SELECT MAX(s2.id) FROM ".$tbl_wiki." s2 WHERE s1.reflink = s2.reflink AND ".$groupfilter.$condition_session.")";// warning don't use group by reflink because don't return the last version
  1647. }
  1648. }
  1649. $result=Database::query($sql);
  1650. //show table
  1651. if (Database::num_rows($result) > 0)
  1652. {
  1653. $row = array ();
  1654. while ($obj = Database::fetch_object($result)) {
  1655. //get author
  1656. $userinfo=Database::get_user_info_from_id($obj->user_id);
  1657. //get time
  1658. $year = substr($obj->dtime, 0, 4);
  1659. $month = substr($obj->dtime, 5, 2);
  1660. $day = substr($obj->dtime, 8, 2);
  1661. $hours = substr($obj->dtime, 11,2);
  1662. $minutes = substr($obj->dtime, 14,2);
  1663. $seconds = substr($obj->dtime, 17,2);
  1664. //get type assignment icon
  1665. if($obj->assignment==1)
  1666. {
  1667. $ShowAssignment=Display::return_icon('wiki_assignment.png', get_lang('AssignmentDesc'),'',22);
  1668. }
  1669. elseif ($obj->assignment==2)
  1670. {
  1671. $ShowAssignment=Display::return_icon('wiki_work.png', get_lang('AssignmentWork'),'',22);
  1672. }
  1673. elseif ($obj->assignment==0)
  1674. {
  1675. $ShowAssignment='<img src="../img/px_transparent.gif" />';
  1676. }
  1677. $row = array ();
  1678. $row[] =$ShowAssignment;
  1679. $row[] = '<a href="'.api_get_self().'?cidReq='.$_course[id].'&action=showpage&title='.api_htmlentities(urlencode($obj->reflink)).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">'.$obj->title.'</a>';
  1680. $row[] = $obj->user_id <>0 ? '<a href="../user/userInfo.php?uInfo='.$userinfo['user_id'].'">'.api_htmlentities(api_get_person_name($userinfo['firstname'], $userinfo['lastname'])).'</a>' : get_lang('Anonymous').' ('.$obj->user_ip.')';
  1681. $row[] = $year.'-'.$month.'-'.$day.' '.$hours.":".$minutes.":".$seconds;
  1682. if(api_is_allowed_to_edit(false,true)|| api_is_platform_admin())
  1683. {
  1684. $showdelete=' <a href="'.api_get_self().'?cidReq='.$_course[id].'&action=delete&title='.api_htmlentities(urlencode($obj->reflink)).'&group_id='.api_htmlentities($_GET['group_id']).'">'.Display::return_icon('delete.png', get_lang('Delete'),'',22);
  1685. }
  1686. $row[] = '<a href="'.api_get_self().'?cidReq='.$_course[id].'&action=edit&title='.api_htmlentities(urlencode($obj->reflink)).'&group_id='.api_htmlentities($_GET['group_id']).'">'.Display::return_icon('edit.png', get_lang('EditPage'),'',22).'</a> <a href="'.api_get_self().'?cidReq='.$_course[id].'&action=discuss&title='.api_htmlentities(urlencode($obj->reflink)).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">
  1687. '.Display::return_icon('discuss.png', get_lang('Discuss'),'',22).'</a> <a href="'.api_get_self().'?cidReq='.$_course[id].'&action=history&title='.api_htmlentities(urlencode($obj->reflink)).'&session_id='.api_htmlentities($_GET['session_id']).'&group_id='.api_htmlentities($_GET['group_id']).'">'.Display::return_icon('history.png', get_lang('History'),'',22).'</a> <a href="'.api_get_self().'?cidReq='.$_course[id].'&action=links&title='.api_htmlentities(urlencode($obj->reflink)).'&group_id='.api_htmlentities($_GET['group_id']).'">'.Display::return_icon('what_link_here.png', get_lang('LinksPages'),'',22).'</a>'.$showdelete;
  1688. $rows[] = $row;
  1689. }
  1690. $table = new SortableTableFromArrayConfig($rows,1,10,'SearchPages_table','','','ASC');
  1691. $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));
  1692. $table->set_header(0,get_lang('Type'), true, array ('style' => 'width:30px;'));
  1693. $table->set_header(1,get_lang('Title'), true);
  1694. $table->set_header(2,get_lang('Author').' ('.get_lang('LastVersion').')', true);
  1695. $table->set_header(3,get_lang('Date').' ('.get_lang('LastVersion').')', true);
  1696. $table->set_header(4,get_lang('Actions'), false, array ('style' => 'width:130px;'));
  1697. $table->display();
  1698. }
  1699. else
  1700. {
  1701. echo get_lang('NoSearchResults');
  1702. }
  1703. }
  1704. /**
  1705. * Enter description here...
  1706. *
  1707. */
  1708. function draw_date_picker($prefix,$default='') {
  1709. if(empty($default)) {
  1710. $default = date('Y-m-d H:i:s');
  1711. }
  1712. $parts = split(' ',$default);
  1713. list($d_year,$d_month,$d_day) = split('-',$parts[0]);
  1714. list($d_hour,$d_minute) = split(':',$parts[1]);
  1715. $month_list = array(
  1716. 1=>get_lang('JanuaryLong'),
  1717. 2=>get_lang('FebruaryLong'),
  1718. 3=>get_lang('MarchLong'),
  1719. 4=>get_lang('AprilLong'),
  1720. 5=>get_lang('MayLong'),
  1721. 6=>get_lang('JuneLong'),
  1722. 7=>get_lang('JulyLong'),
  1723. 8=>get_lang('AugustLong'),
  1724. 9=>get_lang('SeptemberLong'),
  1725. 10=>get_lang('OctoberLong'),
  1726. 11=>get_lang('NovemberLong'),
  1727. 12=>get_lang('DecemberLong')
  1728. );
  1729. $minute = range(10,59);
  1730. array_unshift($minute,'00','01','02','03','04','05','06','07','08','09');
  1731. $date_form = make_select($prefix.'_day', array_combine(range(1,31),range(1,31)), $d_day);
  1732. $date_form .= make_select($prefix.'_month', $month_list, $d_month);
  1733. $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).'&nbsp;&nbsp;&nbsp;&nbsp;';
  1734. $date_form .= make_select($prefix.'_hour', array_combine(range(0,23),range(0,23)), $d_hour).' : ';
  1735. $date_form .= make_select($prefix.'_minute', $minute, $d_minute);
  1736. return $date_form;
  1737. }
  1738. /**
  1739. * Enter description here...
  1740. *
  1741. */
  1742. function make_select($name,$values,$checked='') {
  1743. $output = '<select name="'.$name.'" id="'.$name.'">';
  1744. foreach($values as $key => $value) {
  1745. $output .= '<option value="'.$key.'" '.(($checked==$key)?'selected="selected"':'').'>'.$value.'</option>';
  1746. }
  1747. $output .= '</select>';
  1748. return $output;
  1749. }
  1750. /**
  1751. * Enter description here...
  1752. *
  1753. */
  1754. function get_date_from_select($prefix) {
  1755. 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';
  1756. }
  1757. /**
  1758. * converts 1-9 to 01-09
  1759. */
  1760. function two_digits($number)
  1761. {
  1762. $number = (int)$number;
  1763. return ($number < 10) ? '0'.$number : $number;
  1764. }
  1765. /**
  1766. * Get wiki information
  1767. * @param int wiki id
  1768. * @return array wiki data
  1769. */
  1770. function get_wiki_data($id) {
  1771. global $tbl_wiki;
  1772. $id = intval($id);
  1773. $sql='SELECT * FROM '.$tbl_wiki.' WHERE id = '.$id.' ';
  1774. $result=Database::query($sql);
  1775. $data = array();
  1776. while ($row=Database::fetch_array($result,'ASSOC')) {
  1777. $data = $row;
  1778. }
  1779. return $data;
  1780. }
  1781. ?>