docs/lang_file_to_db.php

   1 <?php
   2
   3 // takes the locale/en.php file and loads it into the database language system
   4 // SVN: $Id$
   5
   6 chdir('./../');
   7
   8 require_once('./global.php');
   9
  10 $db->query("TRUNCATE TABLE " . TABLE_PREFIX . "phrase");
  11
  12 $sql = "
  13         INSERT INTO " . TABLE_PREFIX . "phrase
  14                 (varname, phrasetext, imported)
  15         VALUES";
  16
  17
  18 require('./docs/en.php');
  19
  20 foreach ($language AS $varname => $phrase)
  21 {
  22         $sqlbits[] = "
  23                 ('" . $bugsys->escape($varname) . "', '" . $bugsys->escape($phrase) . "', " . time() . ")";
  24 }
  25
  26 $sql .= implode(',', $sqlbits);
  27
  28 echo "<pre>$sql</pre>";
  29
  30 $db->query($sql);
  31
  32 ?>