/tools/lang2db.php

https://github.com/dbernar1/Project-Pier · PHP · 108 lines · 90 code · 16 blank · 2 comment · 24 complexity · 348d3273333f51c819c0733a691c5181 MD5 · raw file 

    

  1. <?php
    2. 

  2. 

  3. $counter = 0;
    4. 

  4. 

  5. function walk($path, $filter) {
    6. 

  6.   //echo 'walking '.$path."\n";
    7. 

  7.   if (is_dir($path)) {
    8. 

  8.     walk_dir($path, $filter);
    9. 

  9.   }
    10. 

  10.   if(is_file($path)) {
    11. 

  11.     walk_file($path, $filter);
    12. 

  12.   }
    13. 

  13. }
    14. 

  14. 

  15. function walk_dir($path, $filter) {
    16. 

  16.   if (preg_match('/\/language\/(.*)$/', $path, $matches)) { 
    17. 

  17.     if (strpos($path, $filter)===false) return;
    18. 

  18.     $locale = $matches[1];
    19. 

  19.     //$locale = 'is_is';
    20. 

  20.     add2database($locale, $path);
    21. 

  21.   } else {
    22. 

  22.     if ($dh = opendir($path)) {
    23. 

  23.       while (($file = readdir($dh)) !== false) {
    24. 

  24.         if($file != '.' && $file != '..') {
    25. 

  25.           walk($path.'/'.$file, $filter);
    26. 

  26.         }
    27. 

  27.       }
    28. 

  28.       closedir($dh);
    29. 

  29.     }
    30. 

  30.   }
    31. 

  31. }
    32. 

  32. 

  33. function walk_file($path, $filter) {
    34. 

  34. }
    35. 

  35. 

  36. function add2database($locale, $path) {
    37. 

  37.   global $counter;
    38. 

  38.   echo "$path\n";
    39. 

  39.   $localefile = $locale . '.php';
    40. 

  40.   $parts = explode('_', $locale);
    41. 

  41.   $lc = $parts[0];
    42. 

  42.   $cc = $parts[1];
    43. 

  43.   if ($dh = opendir($path)) {
    44. 

  44. 

  45.     $sql = "insert into `".DB_PREFIX."i18n_locales` (`name`, `description`, `country_code`, `language_code`) values( '$locale', 'Imported $path', '$cc', '$lc' ) ON DUPLICATE KEY UPDATE `id`=`id`;";
    46. 

  46.     mysql_query($sql);
    47. 

  47. 

  48.     $sql = "select id from `".DB_PREFIX."i18n_locales` where `country_code` = '$cc' and `language_code` = '$lc';";
    49. 

  49.     $result = mysql_query($sql);
    50. 

  50.     $row = mysql_fetch_assoc($result);
    51. 

  51.     $locale_id = $row['id'];
    52. 

  52.     while (($file = readdir($dh)) !== false) {
    53. 

  53.       if ($file != '.' && $file != '..' && $file != $localefile) {
    54. 

  54.         $category=$file;
    55. 

  55.         $i=strrpos($file, '.');
    56. 

  56.         if ($i!==false) {
    57. 

  57.           $category=substr($file,0,$i);
    58. 

  58.         }            
    59. 

  59. 

  60.         $sql = "insert into `".DB_PREFIX."i18n_categories` (`name`, `description`) values( '$category', 'Imported $path/$file' ) ON DUPLICATE KEY UPDATE `id`=`id`;";
    61. 

  61.         mysql_query($sql);
    62. 

  62. 

  63.         $sql = "select id from `".DB_PREFIX."i18n_categories` where `name` = '$category';";
    64. 

  64.         $result = mysql_query($sql);
    65. 

  65.         $row = mysql_fetch_assoc($result);
    66. 

  66.         $category_id = $row['id'];
    67. 

  67. 

  68.         $filepath="$path/$file";
    69. 

  69.         $items = include $filepath;
    70. 

  70.         foreach($items as $k => $v) {
    71. 

  71.           $counter++;
    72. 

  72.           $sql = "insert into `".DB_PREFIX."i18n_values` (`locale_id`, `category_id`, `name`, `description`) values( '$locale_id', '$category_id', '$k', '".mysql_real_escape_string($v)."');";
    73. 

  73.           mysql_query($sql);
    74. 

  74.           $e = mysql_error();
    75. 

  75.           echo "$counter : $e : $sql\n";
    76. 

  76.         }
    77. 

  77.       }
    78. 

  78.     }
    79. 

  79.     closedir($dh);
    80. 

  80.   }
    81. 

  81. }
    82. 

  82. 

  83.   if(file_exists('../config/config.php')) {
    84. 

  84.     require_once '../config/config.php';  	
    85. 

  85.   } else {
    86. 

  86.     die('Failed to include config file.');
    87. 

  87.   } // if
    88. 

  88.   
    89. 

  89.   $log_data = file_exists('lang2db.log') ? file_get_contents('lang2db.log') : "=== lang2db ===";
    90. 

  90.   
    91. 

  91.   $link = @mysql_connect(DB_HOST, DB_USER, DB_PASS);
    92. 

  92.   
    93. 

  93.   if($link) {
    94. 

  94.     if(mysql_select_db(DB_NAME, $link)) {
    95. 

  95.       mysql_query("set names 'utf8'");
    96. 

  96. 

  97.       echo '<html><head>';
    98. 

  98.       echo '<meta http-equiv="content-type" content="text/html; charset=utf-8" />';
    99. 

  99. 

  100.       echo '</head><body>';
    101. 

  101.       echo '<xmp>';
    102. 

  102.       walk('../language', 'en_us');
    103. 

  103.       walk('../application/plugins', 'en_us');
    104. 

  104.       echo '</xmp>';
    105. 

  105.       echo '</body></html>';
    106. 

  106.     }
    107. 

  107.   }
    108. 

  108. ?>
    109.