echo '<i>' . __('Waiting for a local translator.', 'wpml-string-translation') . '</i> ';
echo '<a href="#cancel-local-' . $icl_string['translations'][$lang['code']]['id'] . '" onclick="icl_st_cancel_local_translation(jQuery(this))">' . __('Cancel', 'wpml-string-translation') . '</a>';
echo '</div>';
} else {
if (isset($icl_string['translations'][$lang['code']]) && $icl_string['translations'][$lang['code']]['translator_id'] > 0) {
$_user = get_userdata($icl_string['translations'][$lang['code']]['translator_id']);
if (!empty($_user)) {
echo '<div style="float:left;margin-right:4px;"><small>';
printf(__('Translated by %s on %s', 'wpml-string-translation'), $_user->display_name, $icl_string['translations'][$lang['code']]['translation_date']);
echo '</small></div>';
}
} else {
$icl_pro_status = $wpdb->get_var($wpdb->prepare("\n SELECT c.status FROM {$wpdb->prefix}icl_core_status c\n JOIN {$wpdb->prefix}icl_string_status s ON s.rid = c.rid\n WHERE s.string_translation_id = %d AND target=%s AND status = %d\n ORDER BY s.id DESC LIMIT 1\n ", $icl_string['string_id'], $lang['code'], CMS_TARGET_LANGUAGE_ASSIGNED));
if (!empty($icl_pro_status)) {
echo '<div style="float: left;"><small>';
echo "ICanLocalize: " . icl_decode_translation_status_id($icl_pro_status);
echo '</small></div>';
}
}
}
?>
<?php
if (isset($icl_string['translations'][$lang['code']]['value']) && preg_match('#<([^>]*)>#im', $icl_string['translations'][$lang['code']]['value'])) {
?>
<br clear="all" /><div style="text-align:left;display:none" class="icl_html_preview"></div>
<a href="#" class="alignleft icl_htmlpreview_link">HTML preview</a>
<?php
}
?>
<label><input<?php
function icl_translation_get_string_translation_status($string_id)
{
global $wpdb;
$status = $wpdb->get_var($wpdb->prepare("\r\n SELECT\r\n MIN(cs.status) \r\n FROM\r\n {$wpdb->prefix}icl_core_status cs\r\n JOIN \r\n {$wpdb->prefix}icl_string_status ss\r\n ON\r\n ss.rid = cs.rid\r\n WHERE\r\n ss.string_translation_id=%d\r\n ", $string_id));
if ($status === null) {
return "";
}
$status = icl_decode_translation_status_id($status);
return $status;
}
function icl_translation_get_string_translation_status($string_id) {
global $wpdb;
$status = $wpdb->get_var("
SELECT
MIN(cs.status)
FROM
{$wpdb->prefix}icl_core_status cs
JOIN
{$wpdb->prefix}icl_string_status ss
ON
ss.rid = cs.rid
WHERE
ss.string_translation_id={$string_id}
"
);
if ($status === null){
return "";
}
$status = icl_decode_translation_status_id($status);
return $status;
}
