configure_extensions.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Edition of extensions configuration
  5. * @package chamilo.admin
  6. */
  7. // name of the language file that needs to be included
  8. $language_file='admin';
  9. $cidReset=true;
  10. require_once '../inc/global.inc.php';
  11. $this_section=SECTION_PLATFORM_ADMIN;
  12. api_protect_admin_script();
  13. $interbreadcrumb[] = array ('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  14. // Database Table Definitions
  15. $tbl_settings_current = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);
  16. $message = '';
  17. if (isset($_POST['activeExtension'])) {
  18. switch ($_POST['extension_code']) {
  19. case 'visio' :
  20. $sql = 'UPDATE '.$tbl_settings_current.' SET
  21. selected_value="true"
  22. WHERE variable="service_visio"
  23. AND subkey="active"';
  24. $rs = Database::query($sql);
  25. if (Database::affected_rows($rs)>0) {
  26. // select all the courses and insert the tool inside
  27. $sql = 'SELECT id FROM '.Database::get_main_table(TABLE_MAIN_COURSE);
  28. $rs = Database::query($sql);
  29. while($row = Database::fetch_array($rs)){
  30. if(!empty($_POST['visio_host'])) {
  31. $tool_table = Database::get_course_table(TABLE_TOOL_LIST);
  32. $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CONFERENCE."'";
  33. $selectres = Database::query($select);
  34. if (Database::num_rows($selectres)<1) {
  35. $sql = 'INSERT INTO '.$tool_table.' SET
  36. c_id = '.$row['id'].',
  37. name="'.TOOL_VISIO_CONFERENCE.'",
  38. link="conference/index.php?type=conference",
  39. image="visio.gif",
  40. visibility="1",
  41. admin="0",
  42. address="squaregrey.gif",
  43. target="_self",
  44. category="interaction"';
  45. Database::query($sql);
  46. }
  47. $select = "SELECT id FROM $tool_table WHERE c_id =".$row['id']." AND name='".TOOL_VISIO_CLASSROOM."'";
  48. $selectres = Database::query($select);
  49. if(Database::num_rows($selectres)<1) {
  50. $sql = 'INSERT INTO '.$tool_table.' SET
  51. c_id = '.$row['id'].',
  52. name="'.TOOL_VISIO_CLASSROOM.'",
  53. link="conference/index.php?type=classroom",
  54. image="visio.gif",
  55. visibility="1",
  56. admin="0",
  57. address="squaregrey.gif",
  58. target="_self",
  59. category="authoring"';
  60. Database::query($sql);
  61. }
  62. }
  63. }
  64. $message = get_lang('ServiceActivated');
  65. }
  66. $sql = 'UPDATE '.$tbl_settings_current.' SET
  67. selected_value="'.Database::escape_string($_POST['visio_host']).'"
  68. WHERE variable="service_visio"
  69. AND subkey="visio_host"';
  70. $rs = Database::query($sql);
  71. $sql = 'UPDATE '.$tbl_settings_current.' SET
  72. selected_value="'.Database::escape_string($_POST['visio_port']).'"
  73. WHERE variable="service_visio"
  74. AND subkey="visio_port"';
  75. $rs = Database::query($sql);
  76. $sql = 'UPDATE '.$tbl_settings_current.' SET
  77. selected_value="'.Database::escape_string($_POST['visio_pass']).'"
  78. WHERE variable="service_visio"
  79. AND subkey="visio_pass"';
  80. $rs = Database::query($sql);
  81. $sql = 'UPDATE '.$tbl_settings_current.' SET
  82. selected_value="'.($_POST['visio_use_rtmpt']=='true'?'true':'false').'"
  83. WHERE variable="service_visio"
  84. AND subkey="visio_use_rtmpt"';
  85. $rs = Database::query($sql);
  86. if(empty($message)) {
  87. $message = get_lang('ServiceReconfigured');
  88. }
  89. break;
  90. case 'ppt2lp' :
  91. $sql = 'UPDATE '.$tbl_settings_current.' SET
  92. selected_value="true"
  93. WHERE variable="service_ppt2lp"
  94. AND subkey="active"';
  95. $rs = Database::query($sql);
  96. if (Database::affected_rows($rs)>0){
  97. $message = get_lang('ServiceActivated');
  98. }
  99. $sql = 'UPDATE '.$tbl_settings_current.' SET
  100. selected_value="'.addslashes($_POST['host']).'"
  101. WHERE variable="service_ppt2lp"
  102. AND subkey="host"';
  103. Database::query($sql);
  104. $sql = 'UPDATE '.$tbl_settings_current.' SET
  105. selected_value="'.addslashes($_POST['port']).'"
  106. WHERE variable="service_ppt2lp"
  107. AND subkey="port"';
  108. Database::query($sql);
  109. $sql = 'UPDATE '.$tbl_settings_current.' SET
  110. selected_value="'.addslashes($_POST['ftp_password']).'"
  111. WHERE variable="service_ppt2lp"
  112. AND subkey="ftp_password"';
  113. Database::query($sql);
  114. $sql = 'UPDATE '.$tbl_settings_current.' SET
  115. selected_value="'.addslashes($_POST['user']).'"
  116. WHERE variable="service_ppt2lp"
  117. AND subkey="user"';
  118. Database::query($sql);
  119. $sql = 'UPDATE '.$tbl_settings_current.' SET
  120. selected_value="'.addslashes($_POST['path_to_lzx']).'"
  121. WHERE variable="service_ppt2lp"
  122. AND subkey="path_to_lzx"';
  123. Database::query($sql);
  124. $sql = 'UPDATE '.$tbl_settings_current.' SET
  125. selected_value="'.addslashes($_POST['size']).'"
  126. WHERE variable="service_ppt2lp"
  127. AND subkey="size"';
  128. Database::query($sql);
  129. break;
  130. }
  131. }
  132. $listActiveServices = array();
  133. // get the list of active services
  134. $sql = 'SELECT variable FROM '.$tbl_settings_current.'
  135. WHERE variable LIKE "service_%" AND subkey="active" and selected_value="true"';
  136. $rs = Database::query($sql);
  137. while($row = Database::fetch_array($rs)){
  138. $listActiveServices[] = $row['variable'];
  139. }
  140. /*$javascript_service_displayed = '';
  141. if (isset($_GET['display'])) {
  142. $javascript_service_displayed = 'document.getElementById("extension_content_'.$_GET['display'].'").style.display = "block"';
  143. }*/
  144. // javascript to handle accordion behaviour
  145. $javascript_message = '';
  146. if(!empty($message)){
  147. $javascript_message =
  148. '
  149. document.getElementById("message").style.display = "block";
  150. var timer = setTimeout(hideMessage,5000);
  151. ';
  152. }
  153. $htmlHeadXtra[]= '
  154. <script type="text/javascript">
  155. var listeDiv;
  156. var extensionsHeader = new Array();
  157. var extensionsContent = new Array();
  158. window.onload = loadTables;
  159. function loadTables(){
  160. '.$javascript_message.'
  161. var listeDiv = document.getElementsByTagName("div");
  162. // fill extensionsHeader and extensionsContent
  163. for(var i=0 ; i < listeDiv.length ; i++){
  164. if(listeDiv[i].id.indexOf(\'extension_header\')!=-1){
  165. listeDiv[i].onclick = afficheContent;
  166. extensionsHeader.push(listeDiv[i]);
  167. }
  168. if(listeDiv[i].id.indexOf("extension_content")!=-1){
  169. extensionsContent.push(listeDiv[i]);
  170. }
  171. }
  172. '.$javascript_service_displayed.'
  173. }
  174. function hideMessage(){
  175. document.getElementById("message").style.display = "none";
  176. }
  177. function afficheContent(event){
  178. var id = this.id.replace("header","content");
  179. switch(document.getElementById(id).style.display){
  180. case "block" :
  181. document.getElementById(id).style.display = "none";
  182. break;
  183. case "none" :
  184. document.getElementById(id).style.display = "block";
  185. for(var i=0 ; i < extensionsContent.length ; i++){
  186. if(extensionsContent[i].id != id)
  187. extensionsContent[i].style.display = "none";
  188. }
  189. break;
  190. }
  191. }
  192. </script>';
  193. $nameTool = get_lang('ConfigureExtensions');
  194. Display::display_header($nameTool);
  195. ?>
  196. <div id="message" style="display: none">
  197. <?php
  198. if(!empty($message))
  199. Display::display_normal_message($message)
  200. ?>
  201. </div>
  202. <div id="content" align="center">
  203. <!-- INSTRUCTIONS TO ADD AN EXTENSION HERE
  204. - copy paste a "main_*" div
  205. - set the names of the subdiv to extension_header_yourextension and extension_content_yourextension
  206. - extension_content_yourextension is the hidden div where you have to put your form / activation process
  207. - extension_header_yourextension is the name of your extension
  208. - you do not need to add javascript to display / hide your divs
  209. - please fill free to improve the global display of the document
  210. -->
  211. <!-- VISIOCONFERENCE -->
  212. <?php /*
  213. <div id="main_visio">
  214. <div id="extension_header_visio" class="accordion_header">
  215. <a href="#"><?php echo get_lang('Visioconf') ?></a>
  216. </div>
  217. <div id="extension_content_visio" style="display:none" class="accordion_content">
  218. <?php echo get_lang('VisioconfDescription') ?><br /><br />
  219. <table width="100%">
  220. <tr>
  221. <td align="center">
  222. <?php Display::display_icon('screenshot_conf.jpg', get_lang('Visioconf')); ?>
  223. </td>
  224. <td align="center" width="50%">
  225. <?php
  226. $form = new FormValidator('visio');
  227. $form -> addElement('text', 'visio_host', get_lang('VisioHost'));
  228. $form -> addElement('html','<br /><br />');
  229. $form -> addElement('text', 'visio_port', get_lang('VisioPort'));
  230. $form -> addElement('html','<br /><br />');
  231. $form -> addElement('text', 'visio_pass', get_lang('VisioPassword'));
  232. $form -> addElement('html','<br /><br />');
  233. $group = array();
  234. $group[] =& HTML_QuickForm::createElement('radio', 'visio_use_rtmpt',null,get_lang('Yes'),'true');
  235. $group[] =& HTML_QuickForm::createElement('radio', 'visio_use_rtmpt',null,get_lang('No'),'false');
  236. $form->addGroup($group, '', get_lang('VisioUseRtmptTitle').' ('.get_lang('VisioUseRtmptComment').')', '&nbsp;');
  237. //$form -> addElement('text', 'visio_is_web_rtmp', get_lang('VisioRTMPIsWeb'));
  238. //$form -> addElement('html','<br /><br />');
  239. $form -> addElement('hidden', 'extension_code', 'visio');
  240. $defaults = array();
  241. $renderer = $form -> defaultRenderer();
  242. $renderer -> setElementTemplate('<div style="text-align:left">{label}</div><div style="text-align:left">{element}</div>');
  243. $form -> addElement('html','<br /><br />');
  244. if(in_array('service_visio',$listActiveServices))
  245. {
  246. $sql = 'SELECT subkey, selected_value FROM '.$tbl_settings_current.'
  247. WHERE variable = "service_visio"';
  248. $rs = Database::query($sql);
  249. while($row = Database::fetch_array($rs,'ASSOC'))
  250. {
  251. $defaults[$row['subkey']] = $row['selected_value'];
  252. }
  253. $form -> addElement('style_submit_button', 'activeExtension', get_lang('ReconfigureExtension'),'class="save"');
  254. }
  255. else {
  256. $form -> addElement('style_submit_button', 'activeExtension', get_lang('ActivateExtension'),'class="save"');
  257. }
  258. $form -> setDefaults($defaults);
  259. $form -> display();
  260. ?>
  261. </td>
  262. </tr>
  263. </table>
  264. </div>
  265. </div>
  266. */ ?>
  267. <!-- PPT2LP -->
  268. <div id="main_ppt2lp">
  269. <div id="extension_header_ppt2lp" class="accordion_header">
  270. <a href="#"><?php echo get_lang('Ppt2lp') ?></a>
  271. </div>
  272. <div id="extension_content_ppt2lp" style="display:none" class="accordion_content">
  273. <?php echo get_lang('Ppt2lpDescription').' '.get_lang('Ppt2lpVoiceRecordingNeedsRed5') ?><br /><br />
  274. <table width="100%">
  275. <tr>
  276. <td valign="top" align="center">
  277. <?php Display::display_icon('screenshot_ppt2lp.jpg', get_lang('Ppt2lp')); ?>
  278. </td>
  279. <td align="center" width="50%">
  280. <form method="POST" action="<?php echo api_get_self(); ?>">
  281. <?php
  282. $form = new FormValidator('ppt2lp');
  283. $form -> addElement('text', 'host', get_lang('Host'));
  284. $form -> addElement('html','<br /><br />');
  285. $form -> addElement('text', 'port', get_lang('Port'));
  286. $form -> addElement('html','<br /><br />');
  287. $form -> addElement('text', 'user', get_lang('UserOnHost'));
  288. $form -> addElement('html','<br /><br />');
  289. $form -> addElement('text', 'ftp_password', get_lang('FtpPassword'));
  290. $form -> addElement('html','<br /><br />');
  291. $form -> addElement('text', 'path_to_lzx', get_lang('PathToLzx'));
  292. $form -> addElement('html','<br /><br />');
  293. $options = array(
  294. '540x405'=>'540x405',
  295. '640x480'=>'640x480',
  296. '720x540'=>'720x540',
  297. '800x600'=>'800x600',
  298. '1000x750'=>'1000x750'
  299. );
  300. $form -> addElement('select', 'size', get_lang('SlideSize'), $options);
  301. $form -> addElement('hidden', 'extension_code', 'ppt2lp');
  302. $defaults = array();
  303. $renderer = $form -> defaultRenderer();
  304. $renderer -> setElementTemplate('<div style="text-align:left">{label}</div><div style="text-align:left">{element}</div>');
  305. $form -> addElement('html','<br /><br />');
  306. if(in_array('service_ppt2lp',$listActiveServices))
  307. {
  308. $sql = 'SELECT subkey, selected_value FROM '.$tbl_settings_current.'
  309. WHERE variable = "service_ppt2lp"
  310. AND subkey <> "active"';
  311. $rs = Database::query($sql);
  312. while($row = Database::fetch_array($rs,'ASSOC'))
  313. {
  314. $defaults[$row['subkey']] = $row['selected_value'];
  315. }
  316. $form -> addElement('style_submit_button', 'activeExtension', get_lang('ReconfigureExtension'),'class="save"');
  317. }
  318. else {
  319. $defaults['host'] = 'localhost';
  320. $defaults['port'] = '2002';
  321. $defaults['size'] = '720x540';
  322. $form -> addElement('style_submit_button', 'activeExtension', get_lang('ActivateExtension'),'class="save"');
  323. }
  324. $form -> setDefaults($defaults);
  325. $form -> display();
  326. echo '<br />';
  327. ?>
  328. </form>
  329. </td>
  330. </tr>
  331. </table>
  332. </div>
  333. </div>
  334. <?php
  335. /*
  336. <!-- EPHORUS -->
  337. <div id="main_ephorus">
  338. <div id="extension_header_ephorus" class="accordion_header">
  339. <a href="#"><?php echo get_lang('EphorusPlagiarismPrevention') ?></a>
  340. </div>
  341. <div id="extension_content_ephorus" style="display:none;padding:0;width:780px;" class="accordion_content">
  342. <table width="100%" cellpadding="0" cellspacing="0">
  343. <tr>
  344. <td align="center">
  345. <TABLE style="WIDTH: 750px" cellSpacing="0" cellPadding="0" align="middle" border="0">
  346. <TBODY>
  347. <TR>
  348. <TD>
  349. <TABLE style="WIDTH: 475px" cellSpacing="0" cellPadding="0" border="0">
  350. <TBODY>
  351. <TR>
  352. <TD>
  353. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  354. <a title="http://www.ephorus.com/dokeos_activate.html" href="http://www.ephorus.com/dokeos_activate.html" target="_blank">
  355. <?php Display::display_icon('ephorus.gif','Ephorus'); ?>
  356. </a>
  357. </TD>
  358. <TD>
  359. <P align=center>
  360. <FONT color="#669966" size="3"><?php echo get_lang('EphorusLeadersInAntiPlagiarism') ?></FONT>
  361. </P>
  362. </TD>
  363. </TR>
  364. </TBODY>
  365. </TABLE>
  366. </TD>
  367. </TR>
  368. <TR>
  369. <TD>
  370. <P>
  371. <TABLE style="WIDTH: 85%" cellSpacing="0" cellPadding="0" border="0">
  372. <TBODY>
  373. <TR>
  374. <TD width="50">&nbsp;
  375. </TD>
  376. <TD>
  377. <P>
  378. <?php echo get_lang('EphorusDescription') ?>
  379. </P>
  380. <P>
  381. <A title="http://www.ephorus.nl/demo_account_en.html" href="http://www.ephorus.nl/demo_account_en.html" target="_blank"><?php echo get_lang('EphorusClickHereForADemoAccount') ?></A>
  382. </P>
  383. <P>
  384. <A title="http://www.ephorus.nl:80/dokeos_activate.html" href="http://www.ephorus.nl/dokeos_activate.html" target="_blank"><?php echo get_lang('EphorusClickHereForInformationsAndPrices') ?></A>.
  385. </P>
  386. </TD>
  387. </TR>
  388. </TBODY>
  389. </TABLE>
  390. </P>
  391. </TD>
  392. </TR>
  393. </TBODY>
  394. </TABLE>
  395. </td>
  396. </tr>
  397. </table>
  398. </div>
  399. </div>
  400. */
  401. /*
  402. <!-- SEARCH -->
  403. <div id="main_search">
  404. <div id="extension_header_search" class="accordion_header">
  405. <a href="#"><?php echo get_lang('SearchEngine') ?></a>
  406. </div>
  407. <div id="extension_content_search" style="display:none" class="accordion_content">
  408. <?php echo get_lang('SearchEngineDescription') ?><br /><br />
  409. <table width="100%">
  410. <tr>
  411. <td width="50%">
  412. <?php Display::display_icon('screenshot_search.jpg', get_lang('SearchEngine')); ?>
  413. </td>
  414. <td align="center" width="50%">
  415. <form method="POST" action="<?php echo api_get_self(); ?>">
  416. <input type="hidden" name="extension_code" value="search" />
  417. <button type="submit" class="save" name="activeExtension" value="<?php echo get_lang('ActivateExtension') ?>" ><?php echo get_lang('ActivateExtension') ?></button>
  418. </form>
  419. </td>
  420. </tr>
  421. </table>
  422. </div>
  423. </div>
  424. <!-- SERVER STATS -->
  425. <div id="main_serverstats">
  426. <div id="extension_header_serverstats" class="accordion_header">
  427. <a href="#"><?php echo get_lang('ServerStatistics') ?></a>
  428. </div>
  429. <div id="extension_content_serverstats" style="display:none" class="accordion_content">
  430. <?php echo get_lang('ServerStatisticsDescription') ?><br /><br />
  431. <table width="100%">
  432. <tr>
  433. <td width="50%">
  434. <?php Display::display_icon('screenshot_serverstats.jpg', get_lang('ServerStatistics')); ?>
  435. </td>
  436. <td align="center" width="50%">
  437. <form method="POST" action="<?php echo api_get_self(); ?>">
  438. <input type="hidden" name="extension_code" value="serverstats" />
  439. <button type="submit" class="save" name="activeExtension" value="<?php echo get_lang('ActivateExtension') ?>" ><?php echo get_lang('ActivateExtension') ?></button>
  440. </form>
  441. </td>
  442. </tr>
  443. </table>
  444. </div>
  445. </div>
  446. <!-- BANDWIDTH STATS -->
  447. <div id="main_bandwidthstats">
  448. <div id="extension_header_bandwidthstats" class="accordion_header">
  449. <a href="#"><?php echo get_lang('BandWidthStatistics') ?></a>
  450. </div>
  451. <div id="extension_content_bandwidthstats" style="display:none" class="accordion_content">
  452. <?php echo get_lang('BandWidthStatisticsDescription') ?><br /><br />
  453. <table width="100%">
  454. <tr>
  455. <td width="50%">
  456. <?php Display::display_icon('screenshot_bandwidth.jpg', get_lang('BandWidthStatistics')); ?>
  457. </td>
  458. <td align="center" width="50%">
  459. <form method="POST" action="<?php echo api_get_self(); ?>">
  460. <input type="hidden" name="extension_code" value="bandwidthstats" />
  461. <button type="submit" class="save" name="activeExtension" value="<?php echo get_lang('ActivateExtension') ?>" ><?php echo get_lang('ActivateExtension') ?></button>
  462. </form>
  463. </td>
  464. </tr>
  465. </table>
  466. </div>
  467. </div>
  468. */ ?>
  469. </div><!-- /content -->
  470. <?php
  471. Display::display_footer();