Version 0.1b added 2 years ago by tokyograph

HOW TO INSTALL: To install this package, copy the following code and paste it into your Pods >> Package Manager under the Import tab and follow instructions there.

{"meta":{"version":"181","build":"1265491518"},"pods":{"6":{"name":"ml_languages","label":null,"is_toplevel":"0","detail_page":null,"list_filters":null,"pre_save_helpers":null,"pre_drop_helpers":null,"post_save_helpers":null,"post_drop_helpers":null,"fields":[{"name":"name","label":"Language","comment":"","coltype":"txt","pickval":null,"sister_field_id":"0","weight":"0","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"1","unique":"0","multiple":"0"},{"name":"language_code","label":"Language code","comment":"","coltype":"txt","pickval":"","sister_field_id":"0","weight":"1","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"1","unique":"1","multiple":"0"}]},"7":{"name":"ml_translations","label":"","is_toplevel":"0","detail_page":"","list_filters":null,"pre_save_helpers":"","pre_drop_helpers":"","post_save_helpers":"","post_drop_helpers":"","fields":[{"name":"name","label":"Name","comment":"","coltype":"txt","pickval":null,"sister_field_id":null,"weight":"0","display_helper":null,"input_helper":null,"pick_filter":null,"pick_orderby":null,"required":"1","unique":null,"multiple":null},{"name":"translation_text","label":"Translation text","comment":"","coltype":"desc","pickval":"","sister_field_id":"0","weight":"4","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"0","unique":"0","multiple":"0"},{"name":"field_id","label":"Field ID","comment":"","coltype":"txt","pickval":null,"sister_field_id":"0","weight":"2","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"1","unique":"0","multiple":"0"},{"name":"pod_id","label":"Pod ID","comment":"","coltype":"txt","pickval":null,"sister_field_id":"0","weight":"1","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"1","unique":"0","multiple":"0"},{"name":"language_code","label":"Language","comment":"","coltype":"txt","pickval":null,"sister_field_id":"0","weight":"3","display_helper":"","input_helper":"","pick_filter":"","pick_orderby":"","required":"1","unique":"0","multiple":"0"}]}},"helpers":[{"name":"ml_input","helper_type":"input","phpcode":"<?php\n$lang_pod = new Pod('ml_languages');\n$lang_pod->findRecords('name', 9999);\n$trans_query = pod_query(\"select language_code, translation_text from wp_pod_tbl_ml_translations where pod_id='\" . $this->get_pod_id() . \"' AND field_id='\" . $field['id'] . \"'\");\n\n$lang = array();\n$lang[''] = array('name' => 'Default', 'value' => $value);\nwhile ($lang_pod->fetchRecord()) {\n $lang[$lang_pod->get_field('language_code')] = array('name' => $lang_pod->get_field('name'));\n}\nwhile ($row = mysql_fetch_assoc($trans_query)) {\n $lang[$row['language_code']]['value'] = $row['translation_text'];\n}\n?>\n\n<select onchange=\"ml_input_switch('<?php echo $name; ?>', this);\">\n <?php foreach ($lang as $k => $v) { echo \"<option value=\\\"$k\\\">{$v['name']}<\/option>\"; } ?>\n<\/select>\n<div>\n<?php\nforeach ($lang as $k => $v) {\n $class = $name . (empty($k) ? '' : \"-$k\");\n $value = htmlspecialchars($v['value']);\n if ('code' == $coltype || 'desc' == $coltype) {\n echo \"<textarea class=\\\"form code $class\\\">$value<\/textarea>\";\n }\n elseif ('txt' == $coltype) {\n echo \"<input type=\\\"text\\\" class=\\\"form txt $class\\\" value=\\\"$value\\\" \/>\";\n }\n}\n?>\n<\/div>\n\n<script type=\"text\/javascript\">\n<?php\nglobal $_ml_input_script;\nif ($_ml_input_script !== true) {\n?>\nfunction ml_input_switch(field, sel) {\n var selector = \".\" + field + (jQuery(sel).val() ? \"-\" + jQuery(sel).val() : \"\");\n jQuery('.form').filter(selector).show().siblings().hide();\n}\n<?php\n}\n$_ml_input_script = true;\n?>\njQuery('.form').filter('.<?php echo $name; ?>').siblings().hide();\n<\/script>"},{"name":"ml_postsave","helper_type":"post_save","phpcode":"<?php\n$lang_pod = new Pod('ml_languages');\n$lang_pod->findRecords('name', 9999);\n$lang = array();\nwhile ($lang_pod->fetchRecord()) {\n $lang[] = $lang_pod->get_field('language_code');\n}\n$ml_fields = pod_query(\"select id, name from wp_pod_fields where datatype='$datatype_id' and input_helper='ml_input'\");\nwhile ($ml_field = mysql_fetch_assoc($ml_fields)) {\n foreach ($lang as $trans) {\n $trans_key = $ml_field['name'] . '-' . $trans;\n $trans_value = mysql_real_escape_string($params[$trans_key]);\n $trans_name = \"$pod_id-{$ml_field['id']}-$trans\";\n $trans_exists = pod_query(\"select id from wp_pod_tbl_ml_translations where pod_id='$pod_id' and field_id='{$ml_field['id']}' and language_code='$trans'\");\n if ($row = mysql_fetch_assoc($trans_exists)) {\n pod_query(\"update wp_pod_tbl_ml_translations set translation_text='$trans_value' where id='{$row['id']}'\");\n }\n else {\n pod_query(\"insert into wp_pod_tbl_ml_translations (name, pod_id, field_id, language_code, translation_text) values ('$trans_name', '$pod_id', '{$ml_field['id']}', '$trans', '$trans_value')\");\n }\n }\n}\n?>"},{"name":"ml_translate","helper_type":"display","phpcode":"<?php\n$lang = mysql_real_escape_string(trim($_GET['lang']));\n$output = '';\n\nif (!empty($lang)) {\n $value = mysql_real_escape_string($value);\n $field_pod = pod_query(\"select id from wp_pod_fields where datatype='\" . $this->datatype_id . \"' and name='$value'\");\n if ($row = mysql_fetch_assoc($field_pod)) {\n $field_id = $row['id'];\n $where = \"pod_id='\" . $this->get_pod_id() . \"' AND field_id='$field_id' AND language_code='$lang'\";\n $trans_query = pod_query(\"select translation_text from wp_pod_tbl_ml_translations where $where limit 0, 1\");\n\n if (mysql_num_rows($trans_query) > 0) {\n $trans = mysql_fetch_assoc($trans_query);\n $output = $trans['translation_text'];\n }\n }\n}\n\nif (!empty($output)) {\n echo $output;\n}\nelse {\n echo $this->get_field($value);\n}\n\n?>"}]}

First version

This is an experimental package to provide multilingual support in Pods. It consists of two Pod types (ml_languages, ml_translations) and three helpers (ml_input, ml_postsave, and ml_translate).

This package works with Pods 1.8.1 but may not be compatible with future versions. Use at your own risk.

----------Setup----------
After importing the Package, enter your additional languages in the ml_languages pod. The language_code is the abbreviation you want used in the url (e.g. if you set your Japanese language code to 'ja', then the url will need 'lang=ja' to show the Japanese translations).

You do not need to create an item for your blog's primary language. Only secondary language translations will be stored in the ml_translations pod.

To enable Multilingual Support for a Pod:
1) Add ml_postsave as a post-save helper.
2) For each text/paragraph/code field that you want translations for, set ml_input as the input helper.

Note: Multilingual Support currently does not work with nicEdit. All paragraph text fields will be treated as code fields.

Note: You can disable Multilingual Support for a field by removing the ml_input helper. All translations still remain in the database, so they will be available again if you re-enable the helper later.

----------Displaying Translations----------
The display helper, ml_translate, does not work like a normal display helper - it can not be used with Magic Tags. In order to use it, you must use the pod_helper function and provide the *name* (not the value) of the field you want translated.

Example, within a Template page:
echo $this->pod_helper('ml_translate', 'fieldname');