Skip to content

Instantly share code, notes, and snippets.

@mlutfy

mlutfy/civi-multi-lingual.txt

Created January 5, 2018 18:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mlutfy/a592d5c5dfcb84b130b53bea6e157bf4 to your computer and use it in GitHub Desktop.
Save mlutfy/a592d5c5dfcb84b130b53bea6e157bf4 to your computer and use it in GitHub Desktop.
Download ZIP
civi multi-lingual
Raw
civi-multi-lingual.txt
```
MariaDB [testi18n2symbiot]> select * from civicrm_setting;
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
| id | name | value | domain_id | contact_id | is_domain | component_id | created_date | created_id |
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
| 1 | resCacheCode | s:5:"ZxpgU"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:20 | NULL |
| 2 | installed | i:1; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:11 | NULL |
| 3 | userFrameworkResourceURL | s:59:"https://test-i18n2.symbiotic.coop/sites/all/modules/civicrm"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 4 | uploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/upload/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 5 | customFileUploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/custom/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 6 | customPHPPathDir | NULL | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 7 | customTemplateDir | NULL | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 8 | extensionsDir | s:84:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/modules/extensions/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 9 | extensionsURL | s:84:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/modules/extensions"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 10 | imageUploadDir | s:97:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 11 | imageUploadURL | s:98:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
```
After saving, but without enabling multi-lingual:
```
MariaDB [testi18n2symbiot]> select * from civicrm_setting; +----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+ | id | name | value | domain_id | contact_id | is_domain | component_id | created_d
ate | created_id | +----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+ | 1 | resCacheCode | s:5:"MyYUn"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 | | 2 | installed | i:1; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:11 | NULL |
| 3 | userFrameworkResourceURL | s:59:"https://test-i18n2.symbiotic.coop/sites/all/modules/civicrm"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 4 | uploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/upload/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 5 | customFileUploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/custom/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 6 | customPHPPathDir | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 7 | customTemplateDir | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 8 | extensionsDir | s:84:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/modules/extensions/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 9 | extensionsURL | s:84:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/modules/extensions"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 10 | imageUploadDir | s:97:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 11 | imageUploadURL | s:98:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 12 | site_id | s:32:"c9c0c6ab90cb9a74d2a60cfae09bcf72"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:22:24 | 2 |
| 13 | systemStatusCheckResult | i:4; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:22:25 | 2 |
| 14 | navigation | s:8:"WHOlFwfG"; | 1 | 2 | 0 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 15 | languageLimit | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 16 | contact_default_language | s:9:"*default*"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 17 | countryLimit | a:0:{} | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 18 | customTranslateFunction | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 19 | defaultContactCountry | s:4:"1228"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 20 | defaultContactStateProvince | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 21 | defaultCurrency | s:3:"USD"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 22 | fieldSeparator | s:1:","; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 23 | inheritLocale | s:1:"0"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 24 | lcMessages | s:5:"en_US"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 25 | legacyEncoding | s:12:"Windows-1252"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 26 | monetaryThousandSeparator | s:1:","; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 27 | monetaryDecimalPoint | s:1:"."; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 28 | moneyformat | s:5:"%c %a"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 29 | moneyvalueformat | s:3:"%!i"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 30 | provinceLimit | a:0:{} | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
+----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+
30 rows in set (0.00 sec)
```
Raw
gistfile1.txt
```
MariaDB [testi18n2symbiot]> select * from civicrm_setting;
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
| id | name | value | domain_id | contact_id | is_domain | component_id | created_date | created_id |
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
| 1 | resCacheCode | s:5:"ZxpgU"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:20 | NULL |
| 2 | installed | i:1; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:11 | NULL |
| 3 | userFrameworkResourceURL | s:59:"https://test-i18n2.symbiotic.coop/sites/all/modules/civicrm"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 4 | uploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/upload/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 5 | customFileUploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/custom/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 6 | customPHPPathDir | NULL | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 7 | customTemplateDir | NULL | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 8 | extensionsDir | s:84:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/modules/extensions/"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 9 | extensionsURL | s:84:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/modules/extensions"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 10 | imageUploadDir | s:97:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
| 11 | imageUploadURL | s:98:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-05 13:18:21 | NULL |
+----+--------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+---------------------+------------+
```
After saving, but without enabling multi-lingual:
```
MariaDB [testi18n2symbiot]> select * from civicrm_setting; +----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+ | id | name | value | domain_id | contact_id | is_domain | component_id | created_d
ate | created_id | +----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+ | 1 | resCacheCode | s:5:"MyYUn"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 | | 2 | installed | i:1; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:11 | NULL |
| 3 | userFrameworkResourceURL | s:59:"https://test-i18n2.symbiotic.coop/sites/all/modules/civicrm"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 4 | uploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/upload/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 5 | customFileUploadDir | s:86:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/custom/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 6 | customPHPPathDir | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 7 | customTemplateDir | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 8 | extensionsDir | s:84:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/modules/extensions/"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 9 | extensionsURL | s:84:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/modules/extensions"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 10 | imageUploadDir | s:97:"/var/aegir/platforms/civicrm-4.7/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 11 | imageUploadURL | s:98:"https://test-i18n2.symbiotic.coop/sites/test-i18n2.symbiotic.coop/files/civicrm/persist/contribute"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:18:21 | NULL |
| 12 | site_id | s:32:"c9c0c6ab90cb9a74d2a60cfae09bcf72"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:22:24 | 2 |
| 13 | systemStatusCheckResult | i:4; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:22:25 | 2 |
| 14 | navigation | s:8:"WHOlFwfG"; | 1 | 2 | 0 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 15 | languageLimit | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 16 | contact_default_language | s:9:"*default*"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 17 | countryLimit | a:0:{} | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 18 | customTranslateFunction | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 19 | defaultContactCountry | s:4:"1228"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 20 | defaultContactStateProvince | NULL | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 21 | defaultCurrency | s:3:"USD"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 22 | fieldSeparator | s:1:","; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 23 | inheritLocale | s:1:"0"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 24 | lcMessages | s:5:"en_US"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 25 | legacyEncoding | s:12:"Windows-1252"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 26 | monetaryThousandSeparator | s:1:","; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 27 | monetaryDecimalPoint | s:1:"."; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 28 | moneyformat | s:5:"%c %a"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 29 | moneyvalueformat | s:3:"%!i"; | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
| 30 | provinceLimit | a:0:{} | 1 | NULL | 1 | NULL | 2018-01-0
5 13:28:29 | 2 |
+----+-----------------------------+------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+--------------+----------
-----------+------------+
30 rows in set (0.00 sec)
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment