From 4acce6725656bb0bb2654177666ed45ee3fd09bf Mon Sep 17 00:00:00 2001
From: bradymiller <bradymiller@users.sourceforge.net>
Date: Thu, 10 Mar 2016 21:54:32 -0800
Subject: [PATCH] Support for RTL(right to left) setting in the translation
 pipeline

---
 contrib/util/language_translations/buildLanguageDatabase.pl      | 9 ++++++---
 .../util/language_translations/combineConstantsSpreadsheet.pl    | 2 +-
 2 files changed, 7 insertions(+), 4 deletions(-)

diff --git a/contrib/util/language_translations/buildLanguageDatabase.pl b/contrib/util/language_translations/buildLanguageDatabase.pl
index 7ab06c416..ef1956640 100644
--- a/contrib/util/language_translations/buildLanguageDatabase.pl
+++ b/contrib/util/language_translations/buildLanguageDatabase.pl
@@ -59,10 +59,11 @@ my $logFile = "log.txt";
 my $stats = "stats.txt";
 my $constantIdColumn = 0; # 0 is lowest
 my $constantColumn = 1; # 0 is lowest 
-my $constantRow = 5; # 0 is lowest
+my $constantRow = 6; # 0 is lowest
 my $languageNumRow = 0; # 0 is lowest
 my $languageIdRow = 1; # 0 is lowest
 my $languageNameRow = 2; # 0 is lowest
+my $languageIsRtlRow = 3; # 0 is lowest
 
 # variables for checking/fixing constants application 
 my $checkFilename; # holds list of constants if checking
@@ -392,9 +393,10 @@ sub createLanguages() {
  my @numberRow = split($de,$page[$languageNumRow]);
  my @idRow = split($de,$page[$languageIdRow]);
  my @nameRow = split($de,$page[$languageNameRow]);
- $tempReturn .= "INSERT INTO `lang_languages`   (`lang_id`, `lang_code`, `lang_description`) VALUES\n";
+ my @rtlRow = split($de,$page[$languageIsRtlRow]);
+ $tempReturn .= "INSERT INTO `lang_languages`   (`lang_id`, `lang_code`, `lang_description`, `lang_is_rtl`) VALUES\n";
  for (my $i = $constantColumn; $i < @numberRow; $i++) {
-  $tempReturn .= "(".$numberRow[$i].", '".$idRow[$i]."', '".$nameRow[$i]."'),\n";
+  $tempReturn .= "(".$numberRow[$i].", '".$idRow[$i]."', '".$nameRow[$i]."', '".@rtlRow[$i]."'),\n";
   $tempCounter = $numberRow[$i];
      
   # set up for statistics later
@@ -415,6 +417,7 @@ CREATE TABLE `lang_languages` (
   `lang_id` int(11) NOT NULL auto_increment,
   `lang_code` char(2) NOT NULL default '',
   `lang_description` varchar(100) default NULL,
+  `lang_is_rtl` TINYINT DEFAULT 0,
   UNIQUE KEY `lang_id` (`lang_id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=".$tempCounter." ;
 \n
diff --git a/contrib/util/language_translations/combineConstantsSpreadsheet.pl b/contrib/util/language_translations/combineConstantsSpreadsheet.pl
index 45b4fe374..4c54442f7 100644
--- a/contrib/util/language_translations/combineConstantsSpreadsheet.pl
+++ b/contrib/util/language_translations/combineConstantsSpreadsheet.pl
@@ -30,7 +30,7 @@ my @spreadsheet;
 my @newSpreadsheet;
 my $inputSpreadsheet;
 my $inputConstants;
-my $constantRow = 5; # from spreadsheet, 0 is lowest
+my $constantRow = 6; # from spreadsheet, 0 is lowest
 my $constantColumn = 1; # from spreadsheet, 0 is lowest
 my $constantIdColumn = 0; # from spreadsheet, 0 is lowest
 
-- 
2.11.4.GIT