docs/mods/_core/languages/language_term.php

   1 <?php
   2 /****************************************************************/
   3 /* ATutor                                                                                                               */
   4 /****************************************************************/
   5 /* Copyright (c) 2002-2010                                      */
   6 /* Inclusive Design Institute                                   */
   7 /* http://atutor.ca                                                                                             */
   8 /*                                                              */
   9 /* This program is free software. You can redistribute it and/or*/
  10 /* modify it under the terms of the GNU General Public License  */
  11 /* as published by the Free Software Foundation.                                */
  12 /****************************************************************/
  13 // $Id$
  14
  15 define('AT_INCLUDE_PATH', '../../../include/');
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');
  17 admin_authenticate(AT_ADMIN_PRIV_LANGUAGES);
  18
  19 if (isset($_POST['submit'])) {
  20         $_POST['variable'] = $addslashes($_POST['variable']);
  21         $_POST['term'] = $addslashes($_POST['term']);
  22         $_POST['text'] = $addslashes($_POST['text']);
  23
  24         $_POST['variable'] = '_c' . $_POST['variable'];
  25
  26         $sql = "REPLACE INTO ".TABLE_PREFIX."language_text VALUES ('$_SESSION[lang]', '{$_POST['variable']}', '{$_POST['term']}', '{$_POST['text']}', NOW(), '')";
  27         mysql_query($sql, $db);
  28         header('Location: '.$_SERVER['PHP_SELF'].'?term='.$_POST['term']);
  29         exit;
  30 } else if (isset($_POST['delete'])) {
  31         $_POST['variable'] = $addslashes($_POST['variable']);
  32         $_POST['term'] = $addslashes($_POST['term']);
  33         $_POST['text'] = $addslashes($_POST['text']);
  34
  35         $_POST['variable'] = '_c' . $_POST['variable'];
  36
  37         $sql = "DELETE FROM ".TABLE_PREFIX."language_text WHERE language_code='$_SESSION[lang]' AND `variable`='{$_POST['variable']}' AND term='{$_POST['term']}' LIMIT 1";
  38         mysql_query($sql, $db);
  39         header('Location: '.$_SERVER['PHP_SELF'].'?term='.$_POST['term']);
  40         exit;
  41 }
  42
  43 require(AT_INCLUDE_PATH.'html/frameset/header.inc.php');
  44 if (isset($_GET['term'])) {
  45         $_GET['term'] = $addslashes($_GET['term']);
  46         $sql = "SELECT * FROM ".TABLE_PREFIX."language_text WHERE language_code='$_SESSION[lang]' AND term='$_GET[term]' ORDER BY `variable` DESC";
  47         $result = mysql_query($sql, $db);
  48         $original_row = mysql_fetch_assoc($result);
  49         $custom_row = mysql_fetch_assoc($result);
  50 }
  51 ?>
  52
  53 <?php if ($original_row): ?>
  54         <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  55         <input type="hidden" name="term" value="<?php echo $_GET['term']; ?>" />
  56         <input type="hidden" name="variable" value="<?php echo $original_row['variable']; ?>" />
  57
  58         <div class="input-form" style="width: 99%">
  59                 <div class="row">
  60                         <h3><?php echo $original_row['term']; ?></h3>
  61                         <?php if ($original_row['context']): ?>
  62                                 <p><?php echo $original_row['context']; ?></p>
  63                         <?php endif; ?>
  64
  65                         <?php if ($custom_row): ?>
  66                                 <h4><?php echo _AT('original_term'); ?></h4>
  67                                 <p><?php echo $original_row['text']; ?></p>
  68                                 <textarea name="text" rows="8" cols="50"><?php echo htmlspecialchars($custom_row['text']); ?></textarea>
  69                         <?php else: ?>
  70                                 <textarea name="text" rows="8" cols="50"><?php echo htmlspecialchars($original_row['text']); ?></textarea>
  71                         <?php endif; ?>
  72                 </div>
  73
  74                 <div class="row">
  75                         <?php
  76                                 $sql    = "SELECT * FROM ".TABLE_PREFIX."language_pages WHERE `term`='$_GET[term]' ORDER BY page LIMIT 11";
  77                                 $result = mysql_query($sql, $db);
  78                                 if (mysql_num_rows($result) > 10) {
  79                                         echo '<strong>'._AT('global_more_than_10_pages').'</strong>';
  80                                 } else {
  81                                         echo '<ul style="padding: 0px; margin: 0px; list-style: none">';
  82                                         while ($page_row = mysql_fetch_assoc($result)) {
  83                                                 echo '<li>'.$page_row['page'] . '</li>';
  84                                         }
  85                                         echo '</ul>';
  86                                 }
  87                          ?>
  88                 </div>
  89
  90                 <div class="buttons row">
  91                         <input type="submit" name="submit" value="<?php echo _AT('save'); ?>" accesskey="s" />
  92                         <?php if ($custom_row): ?>
  93                                 <input type="submit" name="delete" value="<?php echo _AT('delete'); ?>" />
  94                         <?php endif; ?>
  95                 </div>
  96         </div>
  97         </form>
  98 <?php else: ?>
  99         <p><?php echo _AT('select_term_to_edit'); ?></p>
 100 <?php endif; ?>
 101 </body>
 102 </html>