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; }