' . _('Description Automatic Translation for empty translations') . '';
echo '';
echo '
';
$TableHeader = '
' . _('#') . ' |
' . _('Code') . ' |
' . _('Description') . ' |
' . _('To') . ' |
' . _('Translated') . ' |
';
echo $TableHeader;
$i = 0;
while ($myrow = DB_fetch_array($result)) {
if ($myrow['descriptiontranslation'] == ''){
$TargetLanguage=mb_substr($myrow['language_id'],0,2);
$TranslatedText = translate_via_google_translator($myrow['description'],$TargetLanguage,$SourceLanguage);
$sql = "UPDATE stockdescriptiontranslations " .
"SET descriptiontranslation='" . $TranslatedText . "', " .
"needsrevision= '1' " .
"WHERE stockid='" . $myrow['stockid'] . "' AND (language_id='" . $myrow['language_id'] . "')";
$update = DB_query($sql, $ErrMsg, $DbgMsg, true);
$i++;
printf('
%s |
%s |
%s |
%s |
%s |
',
$i,
$myrow['stockid'],
$myrow['description'],
$myrow['language_id'],
$TranslatedText
);
}
if ($myrow['longdescriptiontranslation'] == ''){
$TargetLanguage=mb_substr($myrow['language_id'],0,2);
$TranslatedText = translate_via_google_translator($myrow['longdescription'],$TargetLanguage,$SourceLanguage);
$sql = "UPDATE stockdescriptiontranslations " .
"SET longdescriptiontranslation='" . $TranslatedText . "', " .
"needsrevision= '1' " .
"WHERE stockid='" . $myrow['stockid'] . "' AND (language_id='" . $myrow['language_id'] . "')";
$update = DB_query($sql, $ErrMsg, $DbgMsg, true);
$i++;
printf('
%s |
%s |
%s |
%s |
%s |
',
$i,
$myrow['stockid'],
$myrow['longdescription'],
$myrow['language_id'],
$TranslatedText
);
}
}
echo '
';
prnMsg(_('Number of translated descriptions via Google API') . ': ' . locale_number_format($i));
} else {
echo '' . ' ' .
_('No item descriptions were automatically translated') . '
';
// Add error message for "Google Translator API Key" empty.
}
include ('includes/footer.php');
?>