summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--includes/bootstrap.inc5
-rw-r--r--includes/locale.inc35
-rw-r--r--modules/locale/locale.module24
-rw-r--r--modules/locale/locale.schema2
4 files changed, 35 insertions, 31 deletions
diff --git a/includes/bootstrap.inc b/includes/bootstrap.inc
index 7c3d6dae4..2d9034abb 100644
--- a/includes/bootstrap.inc
+++ b/includes/bootstrap.inc
@@ -1057,15 +1057,14 @@ function language_list($field = 'language', $reset = FALSE) {
// Init language list
if (!isset($languages)) {
- if (variable_get('language_count', 1) > 1) {
+ if (module_exists('locale')) {
$result = db_query('SELECT * FROM {languages} ORDER BY weight ASC, name ASC');
while ($row = db_fetch_object($result)) {
$languages['language'][$row->language] = $row;
}
}
else {
- // One language only, the locale tables might not even
- // be in place, so use the default language only.
+ // No locale module, so use the default language only.
$default = language_default();
$languages['language'][$default->language] = $default;
}
diff --git a/includes/locale.inc b/includes/locale.inc
index 00d82da0f..2845db8f5 100644
--- a/includes/locale.inc
+++ b/includes/locale.inc
@@ -498,7 +498,7 @@ function locale_translate_overview_screen() {
}
// Languages with at least one record in the locale table.
- $translations = db_query("SELECT COUNT(*) AS translation, t.language, s.textgroup FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE translation != '' GROUP BY textgroup, language");
+ $translations = db_query("SELECT COUNT(*) AS translation, t.language, s.textgroup FROM {locales_source} s INNER JOIN {locales_target} t ON s.lid = t.lid GROUP BY textgroup, language");
while ($data = db_fetch_object($translations)) {
$ratio = (!empty($groupsums[$data->textgroup]) && $data->translation > 0) ? round(($data->translation/$groupsums[$data->textgroup])*100., 2) : 0;
$rows[$data->language][$data->textgroup] = $data->translation .'/'. $groupsums[$data->textgroup] ." ($ratio%)";
@@ -551,7 +551,7 @@ function locale_translate_seek_form() {
$form['search']['translation'] = array('#type' => 'radios',
'#title' => t('Search in'),
'#default_value' => (!empty($query['translation']) ? $query['translation'] : 'all'),
- '#options' => array('all' => t('All strings in that language'), 'translated' => t('Only translated strings'), 'untranslated' => t('Only untranslated strings')),
+ '#options' => array('all' => t('Both translated and untranslated strings'), 'translated' => t('Only translated strings'), 'untranslated' => t('Only untranslated strings')),
);
$groups = module_invoke_all('locale', 'groups');
$form['search']['group'] = array('#type' => 'radios',
@@ -1704,7 +1704,7 @@ function _locale_parse_js_file($filepath) {
*/
function _locale_export_get_strings($language = NULL, $group = 'default') {
if (isset($language)) {
- $result = db_query("SELECT s.lid, s.source, s.location, t.translation, t.plid, t.plural FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE t.language = '%s' AND s.textgroup = '%s' ORDER BY t.plid, t.plural", $language->language, $group);
+ $result = db_query("SELECT s.lid, s.source, s.location, t.translation, t.plid, t.plural FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = '%s' WHERE s.textgroup = '%s' ORDER BY t.plid, t.plural", $language->language, $group);
}
else {
$result = db_query("SELECT s.lid, s.source, s.location, t.plid, t.plural FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE s.textgroup = '%s' ORDER BY t.plid, t.plural", $group);
@@ -1938,15 +1938,16 @@ function _locale_translate_seek() {
$join = "SELECT s.source, s.location, s.lid, s.textgroup, t.translation, t.language FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid ";
$arguments = array();
+ $limit_language = FALSE;
// Compute LIKE section
switch ($query['translation']) {
case 'translated':
- $where = "WHERE (t.translation LIKE '%%%s%%' AND t.translation != '')";
+ $where = "WHERE (t.translation LIKE '%%%s%%')";
$orderby = "ORDER BY t.translation";
$arguments[] = $query['string'];
break;
case 'untranslated':
- $where = "WHERE (s.source LIKE '%%%s%%' AND t.translation = '')";
+ $where = "WHERE (s.source LIKE '%%%s%%' AND t.translation IS NULL)";
$orderby = "ORDER BY s.source";
$arguments[] = $query['string'];
break;
@@ -1979,14 +1980,16 @@ function _locale_translate_seek() {
break;
// Some different language
default:
- $sql = "$join $where $grouplimit AND t.language = '%s' $orderby";
- $arguments[] = $query['language'];
+ $sql = "$join AND t.language = '%s' $where $grouplimit $orderby";
+ array_unshift($arguments, $query['language']);
+ // Don't show translation flags for other languages, we can't see them with this search.
+ $limit_language = $query['language'];
}
$result = pager_query($sql, 50, 0, NULL, $arguments);
$groups = module_invoke_all('locale', 'groups');
- $header = array(t('Text group'), t('String'), t('Languages'), array('data' => t('Operations'), 'colspan' => '2'));
+ $header = array(t('Text group'), t('String'), ($limit_language) ? t('Language') : t('Languages'), array('data' => t('Operations'), 'colspan' => '2'));
$arr = array();
while ($locale = db_fetch_object($result)) {
$arr[$locale->lid]['group'] = $groups[$locale->textgroup];
@@ -1996,7 +1999,13 @@ function _locale_translate_seek() {
}
$rows = array();
foreach ($arr as $lid => $value) {
- $rows[] = array($value['group'], array('data' => check_plain(truncate_utf8($value['source'], 150, FALSE, TRUE)) .'<br /><small>'. $value['location'] .'</small>'), array('data' => _locale_translate_language_list($value['languages']), 'align' => 'center'), array('data' => l(t('edit'), "admin/build/translate/edit/$lid"), 'class' => 'nowrap'), array('data' => l(t('delete'), "admin/build/translate/delete/$lid"), 'class' => 'nowrap'));
+ $rows[] = array(
+ $value['group'],
+ array('data' => check_plain(truncate_utf8($value['source'], 150, FALSE, TRUE)) .'<br /><small>'. $value['location'] .'</small>'),
+ array('data' => _locale_translate_language_list($value['languages'], $limit_language), 'align' => 'center'),
+ array('data' => l(t('edit'), "admin/build/translate/edit/$lid"), 'class' => 'nowrap'),
+ array('data' => l(t('delete'), "admin/build/translate/delete/$lid"), 'class' => 'nowrap'),
+ );
}
if (count($rows)) {
@@ -2048,7 +2057,7 @@ function _locale_rebuild_js($langcode = NULL) {
// Construct the array for JavaScript translations.
// We sort on plural so that we have all plural forms before singular forms.
- $result = db_query("SELECT s.lid, s.source, t.plid, t.plural, t.translation FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE t.language = '%s' AND s.location LIKE '%%.js%%' AND s.textgroup = 'default' ORDER BY t.plural DESC", $language->language);
+ $result = db_query("SELECT s.lid, s.source, t.plid, t.plural, t.translation FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = '%s' WHERE s.location LIKE '%%.js%%' AND s.textgroup = 'default' ORDER BY t.plural DESC", $language->language);
$translations = $plurals = array();
while ($data = db_fetch_object($result)) {
@@ -2155,7 +2164,7 @@ function _locale_rebuild_js($langcode = NULL) {
/**
* List languages in search result table
*/
-function _locale_translate_language_list($translation) {
+function _locale_translate_language_list($translation, $limit_language) {
// Add CSS
drupal_add_css(drupal_get_path('module', 'locale') .'/locale.css', 'module', 'all', FALSE);
@@ -2163,7 +2172,9 @@ function _locale_translate_language_list($translation) {
unset($languages['en']);
$output = '';
foreach ($languages as $langcode => $language) {
- $output .= (!empty($translation[$langcode])) ? $langcode .' ' : "<em class=\"locale-untranslated\">$langcode</em> ";
+ if (!$limit_language || $limit_language == $langcode) {
+ $output .= (!empty($translation[$langcode])) ? $langcode .' ' : "<em class=\"locale-untranslated\">$langcode</em> ";
+ }
}
return $output;
diff --git a/modules/locale/locale.module b/modules/locale/locale.module
index 417f99f19..a9eb60014 100644
--- a/modules/locale/locale.module
+++ b/modules/locale/locale.module
@@ -331,22 +331,15 @@ function locale($string = NULL, $langcode = NULL) {
}
}
- // We have the translation cached (if it is TRUE, then there is no
- // translation, so there is no point in checking the database)
- if (isset($locale_t[$langcode][$string])) {
- $string = ($locale_t[$langcode][$string] === TRUE ? $string : $locale_t[$langcode][$string]);
- }
+ // If we have the translation cached, skip checking the database
+ if (!isset($locale_t[$langcode][$string])) {
- // We do not have this translation cached, so get it from the DB.
- else {
- $translation = db_fetch_object(db_query("SELECT s.lid, t.translation FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE s.source = '%s' AND t.language = '%s' AND s.textgroup = 'default'", $string, $langcode));
+ // We do not have this translation cached, so get it from the DB.
+ $translation = db_fetch_object(db_query("SELECT s.lid, t.translation FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = '%s' WHERE s.source = '%s' AND s.textgroup = 'default'", $langcode, $string));
if ($translation) {
// We have the source string at least.
- if ($translation->lid) {
- // Cache translation string or TRUE if no translation exists.
- $translation = (empty($translation->translation) ? TRUE : $translation->translation);
- $locale_t[$langcode][$string] = $translation;
- }
+ // Cache translation string or TRUE if no translation exists.
+ $locale_t[$langcode][$string] = (empty($translation->translation) ? TRUE : $translation->translation);
}
else {
// We don't have the source string, cache this as untranslated.
@@ -357,7 +350,7 @@ function locale($string = NULL, $langcode = NULL) {
}
}
- return $string;
+ return ($locale_t[$langcode][$string] === TRUE ? $string : $locale_t[$langcode][$string]);
}
/**
@@ -368,9 +361,10 @@ function locale($string = NULL, $langcode = NULL) {
function locale_refresh_cache() {
$languages = language_list('enabled');
$languages = $languages['1'];
+ unset($languages['en']);
foreach ($languages as $language) {
- $result = db_query("SELECT s.source, t.translation, t.language FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid WHERE t.language = '%s' AND s.textgroup = 'default' AND LENGTH(s.source) < 75", $language->language);
+ $result = db_query("SELECT s.source, t.translation, t.language FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid AND t.language = '%s' WHERE s.textgroup = 'default' AND LENGTH(s.source) < 75", $language->language);
$t = array();
while ($data = db_fetch_object($result)) {
$t[$data->source] = (empty($data->translation) ? TRUE : $data->translation);
diff --git a/modules/locale/locale.schema b/modules/locale/locale.schema
index 70d4fbb5c..f511a020f 100644
--- a/modules/locale/locale.schema
+++ b/modules/locale/locale.schema
@@ -37,7 +37,7 @@ function locale_schema() {
// Drupal path in case of online discovered translations or file path in case of imported strings.
'location' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => ''),
// A module defined group of translations, see hook_locale().
- 'textgroup' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => ''),
+ 'textgroup' => array('type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => 'default'),
// The original string in English.
'source' => array('type' => 'text', 'mysql_type' => 'blob', 'not null' => TRUE),
),
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-26 20:21:54 +0000