phpgroupware-cvs
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-cvs] phpgwapi/setup default_records.inc.php, 1.4.2.6.2.2,

From: Dave Hall <address@hidden>
Subject: [Phpgroupware-cvs] phpgwapi/setup default_records.inc.php, 1.4.2.6.2.2, 1.4.2.6.2.3 setup.inc.php, 1.37.2.6.2.11, 1.37.2.6.2.12 tables_update.inc.php, 1.53.2.9.2.18, 1.53.2.9.2.19
Date: Wed, 08 Oct 2003 06:27:35 +0000 
Update of /cvsroot/phpgroupware/phpgwapi/setup
In directory subversions:/tmp/cvs-serv15049

Modified Files:
      Tag: Version-0_9_16-branch
        default_records.inc.php setup.inc.php tables_update.inc.php 
Log Message:
iso compliance for language codes

Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/default_records.inc.php,v
retrieving revision 1.4.2.6.2.2
retrieving revision 1.4.2.6.2.3
diff -C2 -d -r1.4.2.6.2.2 -r1.4.2.6.2.3
*** default_records.inc.php     8 Sep 2003 13:26:38 -0000       1.4.2.6.2.2
--- default_records.inc.php     8 Oct 2003 06:27:32 -0000       1.4.2.6.2.3
***************
*** 25,29 ****
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bh','Bihari','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bi','Bislama','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bn','Bengali / Bangla','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bo','Tibetan','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('br','Breton','No')");
--- 25,29 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bh','Bihari','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bi','Bislama','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bn','Bengali','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('bo','Tibetan','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('br','Breton','No')");
***************
*** 36,40 ****
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('dz','Bhutani','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('el','Greek','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('en','English / US','Yes')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('eo','Esperanto','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('es','Spanish','Yes')");
--- 36,40 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('dz','Bhutani','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('el','Greek','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('en','English','Yes')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('eo','Esperanto','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('es','Spanish','Yes')");
***************
*** 48,56 ****
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('fy','Frisian','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ga','Irish','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gd','Gaelic / Scots Gaelic','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gl','Galician','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gn','Guarani','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gu','Gujarati','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ha','Hausa','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('hi','Hindi','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('hr','Croatian','No')");
--- 48,57 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('fy','Frisian','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ga','Irish','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gd','Scots Gaelic','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gl','Galician','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gn','Guarani','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('gu','Gujarati','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ha','Hausa','No')");
+       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('he','Hebrew','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('hi','Hindi','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('hr','Croatian','No')");
***************
*** 60,69 ****
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ie','Interlingue','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ik','Inupiak','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('in','Indonesian','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('is','Icelandic','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('it','Italian','Yes')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('iw','Hebrew','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ja','Japanese','Yes')");
-       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ji','Yiddish','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('jw','Javanese','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ka','Georgian','No')");
--- 61,69 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ie','Interlingue','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ik','Inupiak','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('id','Indonesian','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('is','Icelandic','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('it','Italian','Yes')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('iu', 'Inuktitut', 'No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ja','Japanese','Yes')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('jw','Javanese','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ka','Georgian','No')");
***************
*** 138,141 ****
--- 138,142 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('tt','Tatar','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('tw','Twi','No')");
+       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ug', 'Uigur', 'No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('uk','Ukrainian','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('ur','Urdu','No')");
***************
*** 145,151 ****
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('wo','Wolof','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('xh','Xhosa','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('yo','Yoruba','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zh','Chinese','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zt','Chinese(Taiwan)','Yes')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zu','Zulu','No')");
  
--- 146,153 ----
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('wo','Wolof','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('xh','Xhosa','No')");
+       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('yi','Yiddish','No')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('yo','Yoruba','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zh','Chinese (Simplified)','No')");
!       $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zt','Chinese (Traditional)','Yes')");
        $oProc->query("INSERT INTO phpgw_languages (lang_id, lang_name, 
available) VALUES ('zu','Zulu','No')");
  

Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/setup.inc.php,v
retrieving revision 1.37.2.6.2.11
retrieving revision 1.37.2.6.2.12
diff -C2 -d -r1.37.2.6.2.11 -r1.37.2.6.2.12
*** setup.inc.php       8 Sep 2003 14:46:20 -0000       1.37.2.6.2.11
--- setup.inc.php       8 Oct 2003 06:27:32 -0000       1.37.2.6.2.12
***************
*** 16,20 ****
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
!       $setup_info['phpgwapi']['version']   = '0.9.14.509';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.24';
        $setup_info['phpgwapi']['enable']    = 3;
--- 16,20 ----
        $setup_info['phpgwapi']['name']      = 'phpgwapi';
        $setup_info['phpgwapi']['title']     = 'phpgwapi';
!       $setup_info['phpgwapi']['version']   = '0.9.14.510';
        $setup_info['phpgwapi']['versions']['current_header'] = '1.24';
        $setup_info['phpgwapi']['enable']    = 3;

Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/phpgwapi/setup/tables_update.inc.php,v
retrieving revision 1.53.2.9.2.18
retrieving revision 1.53.2.9.2.19
diff -C2 -d -r1.53.2.9.2.18 -r1.53.2.9.2.19
*** tables_update.inc.php       29 Sep 2003 22:55:36 -0000      1.53.2.9.2.18
--- tables_update.inc.php       8 Oct 2003 06:27:32 -0000       1.53.2.9.2.19
***************
*** 1752,1754 ****
--- 1752,1782 ----
                return $GLOBALS['setup_info']['phpgwapi']['currentver'];
        }
+ 
+       $test[] = '0.9.14.509';
+       //fix some languages to be ISO 639 compliant
+       //Source: http://www.geo-guide.de/info/tools/languagecode.html
+       function phpgwapi_upgrade0_9_14_509()
+       {
+               //Indonesian code fix
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_id='id' WHERE lang_id='in'");
+               //bn name fix
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_name='Bengali' WHERE lang_id='bn'");
+               //English is English not English US - the US didn't invent it!
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_name='English' WHERE lang_id='en'");
+               //gd name fix
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_name='Scots Gaelic' WHERE lang_id='gd'");
+               //Hebrew code fix
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_id='he' WHERE lang_id='iw'");
+               //Yiddish code fix
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_id='yi' WHERE lang_id='ji'");
+               //Make Chinese names clearer
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_name='Chinese (Simplified)' WHERE lang_id='zh'");
+               $GLOBALS['phpgw_setup']->oProc->query("UPDATE phpgw_languages 
SET lang_name='Chinese (Traditional)' WHERE lang_id='zt'");
+               //Add Missing Languages
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_languages(lang_id, lang_name, available) VALUES('iu', 'Inuktitut', 
'No')");
+               $GLOBALS['phpgw_setup']->oProc->query("INSERT INTO 
phpgw_languages(lang_id, lang_name, available) VALUES('ug', 'Uigur', 'No')");
+               
+               $GLOBALS['setup_info']['phpgwapi']['currentver'] = '0.9.14.510';
+               return $GLOBALS['setup_info']['phpgwapi']['currentver'];
+       }
  ?>
reply via email to
[Prev in Thread] Current Thread [Next in Thread]