translate.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221
  1. <?php
  2. $http_host = $_SERVER['HTTP_HOST'];
  3. include("../../functions.php");
  4. $con = startdb();
  5. if (!checkSession($con)){
  6. header("Location: /index.php");
  7. exit (-1);
  8. }
  9. else{
  10. $id = mysqli_real_escape_string($con, $_GET['id']);
  11. $q = mysqli_query($con, "SELECT * FROM activity WHERE id = $id");
  12. if(mysqli_num_rows($q) == 0){
  13. header("Location: /actividades/translate/");
  14. exit (-1);
  15. }
  16. else{
  17. $r = mysqli_fetch_array($q);
  18. ?>
  19. <html>
  20. <head>
  21. <meta content="text/html; charset=windows-1252" http-equiv="content-type"/>
  22. <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
  23. <title>Traducir <?=$r['title_es']?> - Administraci&oacute;n</title>
  24. <!-- CSS files -->
  25. <link rel="stylesheet" type="text/css" href="/css/ui.css"/>
  26. <link rel="stylesheet" type="text/css" href="/css/actividades.css"/>
  27. <!-- CSS for mobile version -->
  28. <link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/ui.css"/>
  29. <link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/actividades.css"/>
  30. <!-- Script files -->
  31. <script type="text/javascript" src="script.js"></script>
  32. <script type="text/javascript" src="/script/ui.js"></script>
  33. <script src="../../ckeditor/ckeditor.js"></script>
  34. </head>
  35. <body>
  36. <?php
  37. include('../../toolbar.php');
  38. ?>
  39. <div id='content'>
  40. <div class='section'>
  41. <h3>Taducir &#8216;<?=$r["title_es"]?>&#8217;</h3>
  42. <div id='translation_instructions' class='entry'>
  43. <h4>C&oacute;mo traducir</h4>
  44. <ul>
  45. <li>Rellena los campos de abajo para el idioma correspondiente (columna de en medio para ingl&eacute;s, derecha para euskera)</li>
  46. <li>No es necesario traducir todos los campos ni todos los idiomas. Traduce solo lo que sepas y quieras.</li>
  47. <li>Al terminar, recuerda pulsar el boton &#8216;Guardar&#8217; al final de la p&acute;gina.</li>
  48. <li>Muchas gracias por tu trabajo!</li>
  49. </ul>
  50. </div>
  51. <br/><br/>
  52. <form method='post' action='/actividades/translate/apply.php'>
  53. <input type='hidden' name='id' value='<?=$r["id"]?>'/>
  54. <table id='table_translate_languages'>
  55. <tr>
  56. <td class='translate_language'>
  57. <div class='entry translation'>
  58. <h3>Castellano</h3>
  59. <div class='translate_row_title'>
  60. <span class='bold'>T&iacute;tulo: </span><?=$r["title_es"]?>
  61. </div>
  62. <div class='translate_row_description'>
  63. <span class='bold'>Descripci&oacute;n</span>
  64. <br/>
  65. <p><?=$r["text_es"]?></p>
  66. </div>
  67. <?php
  68. if (strlen($r['after_es']) > 0){
  69. ?>
  70. <div class='translate_row_after'>
  71. <span class='bold'>Texto para despu&eacute;s</span>
  72. <br/>
  73. <p><?=$r["after_es"]?></p>
  74. </div>
  75. <?php
  76. }
  77. $q_i = mysqli_query($con, "SELECT id, name_es, name_en, name_eu, description_es, description_en, description_eu, date_format(start, '%H:%i') AS start FROM activity_itinerary WHERE activity = $r[id];");
  78. if (mysqli_num_rows($q_i) > 0){
  79. ?>
  80. <div class='translate_row_itinerary'>
  81. <span class='bold'>Itinerario<br/></span>
  82. <table id='table_translate_itinerary'>
  83. <?php
  84. while ($r_i = mysqli_fetch_array($q_i)){
  85. ?>
  86. <tr>
  87. <td><?=$r_i["start"]?></td>
  88. <td>&nbsp;&nbsp;<?=$r_i["name_es"]?>&nbsp;&nbsp;</td>
  89. <td>&nbsp;&nbsp;<?=$r_i["description_es"]?>&nbsp;&nbsp;</td>
  90. </tr>
  91. <?php
  92. }
  93. ?>
  94. </table>
  95. </div>
  96. <?php
  97. }
  98. ?>
  99. </div>
  100. </td>
  101. <td class='translate_language'>
  102. <div class='entry translation'>
  103. <h3>Ingl&eacute;s</h3>
  104. <div class='translate_row_title'>
  105. <span class='bold'>T&iacute;tulo: </span>
  106. <input required type='text' name='title_en' required value='<?=$r["title_en"]?>'/>
  107. </div>
  108. <div class='translate_row_description'>
  109. <span class='bold'>Descripci&oacute;n</span>
  110. <br/>
  111. <textarea name='text_en' required><?=$r["text_en"]?></textarea>
  112. </div>
  113. <script>CKEDITOR.replace('text_en');</script>
  114. <?php
  115. if (strlen($r['after_es']) > 0){
  116. ?>
  117. <div class='translate_row_after'>
  118. <span class='bold'>Texto para despu&eacute;s</span>
  119. <br/>
  120. <textarea name='after_en' required><?=$r["after_en"]?></textarea>
  121. </div>
  122. <script>CKEDITOR.replace('after_en');</script>
  123. <?php
  124. }
  125. $q_i = mysqli_query($con, "SELECT id, name_es, name_en, name_en, description_es, description_en, description_en, date_format(start, '%H:%i') AS start FROM activity_itinerary WHERE activity = $r[id];");
  126. if (mysqli_num_rows($q_i) > 0){
  127. ?>
  128. <div class='translate_row_itinerary'>
  129. <span class='bold'>Itinerario</span>
  130. <br/>
  131. <table id='table_translate_itinerary'>
  132. <?php
  133. while ($r_i = mysqli_fetch_array($q_i)){
  134. ?>
  135. <tr>
  136. <td><?$r_i["start"]?></td>
  137. <td>
  138. <input type='text' name='it_<?=$r_i["id"]?>_name_en' required value='<?=$r_i["name_en"]?>'/>
  139. </td>
  140. <td>
  141. <textarea name='it_<?=$r_i["id"]?>_desc_en' required><?=$r_i["description_en"]?></textarea>
  142. </td>
  143. </tr>
  144. <?php
  145. }
  146. ?>
  147. </table>
  148. </div>
  149. <?php
  150. }
  151. ?>
  152. </div>
  153. </td>
  154. <td class='translate_language'>
  155. <div class='entry translation'>
  156. <h3>Euskera</h3>
  157. <div class='translate_row_title'>
  158. <span class='bold'>T&iacute;tulo: </span>
  159. <input required type='text' name='title_eu' required value='<?=$r["title_eu"]?>'/>
  160. </div>
  161. <div class='translate_row_description'>
  162. <span class='bold'>Descripci&oacute;n</span>
  163. <br/>
  164. <textarea name='text_eu' required><?=$r["text_eu"]?></textarea>
  165. </div>
  166. <script>CKEDITOR.replace('text_eu');</script>
  167. <?php
  168. if (strlen($r['after_es']) > 0){
  169. ?>
  170. <div class='translate_row_after'>
  171. <span class='bold'>Texto para despu&eacute;s</span>
  172. <br/>
  173. <textarea name='after_eu' required><?=$r["after_eu"]?></textarea>
  174. </div>
  175. <script>CKEDITOR.replace('after_eu');</script>
  176. <?php
  177. }
  178. $q_i = mysqli_query($con, "SELECT id, name_es, name_eu, name_eu, description_es, description_eu, description_eu, date_format(start, '%H:%i') AS start FROM activity_itinerary WHERE activity = $r[id];");
  179. if (mysqli_num_rows($q_i) > 0){
  180. ?>
  181. <div class='translate_row_itinerary'>
  182. <span class='bold'>Itinerario</span>
  183. <br/>
  184. <table id='table_translate_itinerary'>
  185. <?php
  186. while ($r_i = mysqli_fetch_array($q_i)){
  187. ?>
  188. <tr>
  189. <td><?=$r_i["start"]?></td>
  190. <td>
  191. <input type='text' name='it_<?=$r_i["id"]?>_name_eu' required value='<?=$r_i["name_eu"]?>'/>
  192. </td>
  193. <td>
  194. <textarea name='it_<?=$r_i["id"]?>_desc_eu' required><?=$r_i["description_eu"]?></textarea>
  195. </td>
  196. </tr>
  197. <?php
  198. }
  199. ?>
  200. </table>
  201. </div>
  202. <?php
  203. }
  204. ?>
  205. </div>
  206. </td>
  207. </tr>
  208. </table>
  209. <div id='translate_controls'>
  210. <input type='submit' value='Guardar'/>
  211. <input type='button' value='Cancelar y salir' onClick='exitTranslation();'/>
  212. </div>
  213. </form>
  214. ?>
  215. </div>
  216. </div>
  217. </body>
  218. </html>
  219. <?php
  220. }
  221. ?>