function process_forms()
{
global $wpdb;
require_once ICL_PLUGIN_PATH . '/lib/Snoopy.class.php';
require_once ICL_PLUGIN_PATH . '/lib/xml2array.php';
require_once ICL_PLUGIN_PATH . '/lib/icl_api.php';
if (isset($_POST['icl_post_action'])) {
switch ($_POST['icl_post_action']) {
case 'save_theme_localization':
$locales = array();
foreach ($_POST as $k => $v) {
if (0 !== strpos($k, 'locale_file_name_') || !trim($v)) {
continue;
}
$locales[str_replace('locale_file_name_', '', $k)] = $v;
}
if (!empty($locales)) {
$this->set_locale_file_names($locales);
}
break;
}
return;
}
$create_account = isset($_POST['icl_create_account_nonce']) && $_POST['icl_create_account_nonce'] == wp_create_nonce('icl_create_account');
$create_account_and_transfer = isset($_POST['icl_create_account_and_transfer_nonce']) && $_POST['icl_create_account_and_transfer_nonce'] == wp_create_nonce('icl_create_account_and_transfer');
$config_account = isset($_POST['icl_configure_account_nonce']) && $_POST['icl_configure_account_nonce'] == wp_create_nonce('icl_configure_account');
$create_support_account = isset($_POST['icl_create_support_account_nonce']) && $_POST['icl_create_support_account_nonce'] == wp_create_nonce('icl_create_support_account');
$config_support_account = isset($_POST['icl_configure_support_account_nonce']) && $_POST['icl_configure_support_account_nonce'] == wp_create_nonce('icl_configure_support_account');
$use_existing_account = isset($_POST['icl_use_account_nonce']) && $_POST['icl_use_account_nonce'] == wp_create_nonce('icl_use_account');
$transfer_to_account = isset($_POST['icl_transfer_account_nonce']) && $_POST['icl_transfer_account_nonce'] == wp_create_nonce('icl_transfer_account');
if ($create_account || $config_account || $create_support_account || $config_support_account) {
if (isset($_POST['icl_content_trans_setup_back_2'])) {
// back button in wizard mode.
$this->settings['content_translation_setup_wizard_step'] = 2;
$this->save_settings();
} else {
$user = $_POST['user'];
$user['create_account'] = isset($_POST['icl_create_account_nonce']) || isset($_POST['icl_create_support_account_nonce']) ? 1 : 0;
$user['platform_kind'] = 2;
$user['cms_kind'] = 1;
$user['blogid'] = $wpdb->blogid ? $wpdb->blogid : 1;
$user['url'] = get_home_url();
$user['title'] = get_option('blogname');
$user['description'] = $this->settings['icl_site_description'];
$user['is_verified'] = 1;
if ($user['create_account'] && defined('ICL_AFFILIATE_ID') && defined('ICL_AFFILIATE_KEY')) {
$user['affiliate_id'] = ICL_AFFILIATE_ID;
$user['affiliate_key'] = ICL_AFFILIATE_KEY;
}
$user['interview_translators'] = $this->settings['interview_translators'];
$user['project_kind'] = $this->settings['website_kind'];
/*
if(is_null($user['project_kind']) || $user['project_kind']==''){
$_POST['icl_form_errors'] = __('Please select the kind of website','sitepress');
return;
}
*/
$user['pickup_type'] = intval($this->settings['translation_pickup_method']);
$notifications = 0;
if ($this->settings['icl_notify_complete']) {
$notifications += 1;
}
if ($this->settings['alert_delay']) {
$notifications += 2;
}
$user['notifications'] = $notifications;
// prepare language pairs
$pay_per_use = $this->settings['translator_choice'] == 1;
$language_pairs = $this->settings['language_pairs'];
$lang_pairs = array();
if (isset($language_pairs)) {
foreach ($language_pairs as $k => $v) {
$english_fr = $wpdb->get_var("SELECT english_name FROM {$wpdb->prefix}icl_languages WHERE code='{$k}' ");
$pay_per_use_increment = 0;
foreach ($v as $k => $v) {
$pay_per_use_increment++;
$english_to = $wpdb->get_var("SELECT english_name FROM {$wpdb->prefix}icl_languages WHERE code='{$k}' ");
$lang_pairs['from_language' . $pay_per_use_increment] = ICL_Pro_Translation::server_languages_map($english_fr);
$lang_pairs['to_language' . $pay_per_use_increment] = ICL_Pro_Translation::server_languages_map($english_to);
if ($pay_per_use) {
$lang_pairs['pay_per_use' . $pay_per_use_increment] = 1;
}
}
}
}
$icl_query = new ICanLocalizeQuery();
list($site_id, $access_key) = $icl_query->createAccount(array_merge($user, $lang_pairs));
if (!$site_id) {
$user['pickup_type'] = ICL_PRO_TRANSLATION_PICKUP_POLLING;
list($site_id, $access_key) = $icl_query->createAccount(array_merge($user, $lang_pairs));
}
if (!$site_id) {
if ($access_key) {
$_POST['icl_form_errors'] = $access_key;
} else {
$_POST['icl_form_errors'] = __('An unknown error has occurred when communicating with the ICanLocalize server. Please try again.', 'sitepress');
// We will force the next try to be http.
update_option('_force_mp_post_http', 1);
}
} else {
if ($create_account || $config_account) {
$iclsettings['site_id'] = $site_id;
$iclsettings['access_key'] = $access_key;
$iclsettings['icl_account_email'] = $user['email'];
// set the support data the same.
$iclsettings['support_site_id'] = $site_id;
$iclsettings['support_access_key'] = $access_key;
$iclsettings['support_icl_account_email'] = $user['email'];
} else {
$iclsettings['support_site_id'] = $site_id;
$iclsettings['support_access_key'] = $access_key;
$iclsettings['support_icl_account_email'] = $user['email'];
}
if (isset($user['pickup_type']) && $user['pickup_type'] == ICL_PRO_TRANSLATION_PICKUP_POLLING) {
$iclsettings['translation_pickup_method'] = ICL_PRO_TRANSLATION_PICKUP_POLLING;
}
$this->save_settings($iclsettings);
if ($user['create_account'] == 1) {
$_POST['icl_form_success'] = __('A project on ICanLocalize has been created.', 'sitepress') . '<br />';
} else {
$_POST['icl_form_success'] = __('Project added', 'sitepress');
}
$this->get_icl_translator_status($iclsettings);
$this->save_settings($iclsettings);
}
if (!$create_support_account && !$config_support_account && intval($site_id) > 0 && $access_key && $this->settings['content_translation_setup_complete'] == 0 && $this->settings['content_translation_setup_wizard_step'] == 3 && !isset($_POST['icl_form_errors'])) {
// we are running the wizard, so we can finish it now.
$this->settings['content_translation_setup_complete'] = 1;
$this->settings['content_translation_setup_wizard_step'] = 0;
$this->save_settings();
}
}
} elseif ($use_existing_account || $transfer_to_account || $create_account_and_transfer) {
if (isset($_POST['icl_content_trans_setup_back_2'])) {
// back button in wizard mode.
$this->settings['content_translation_setup_wizard_step'] = 2;
$this->save_settings();
} else {
if ($transfer_to_account) {
$_POST['user']['email'] = $_POST['user']['email2'];
}
// we will be using the support account for the icl_account
$this->settings['site_id'] = $this->settings['support_site_id'];
$this->settings['access_key'] = $this->settings['support_access_key'];
$this->settings['icl_account_email'] = $this->settings['support_icl_account_email'];
$this->save_settings();
if ($transfer_to_account || $create_account_and_transfer) {
if (!$this->transfer_icl_account($create_account_and_transfer)) {
return;
}
}
// we are running the wizard, so we can finish it now.
$this->settings['content_translation_setup_complete'] = 1;
$this->settings['content_translation_setup_wizard_step'] = 0;
$this->save_settings();
$iclsettings['site_id'] = $this->settings['site_id'];
$iclsettings['access_key'] = $this->settings['access_key'];
$this->get_icl_translator_status($iclsettings);
$this->save_settings($iclsettings);
}
} elseif (isset($_POST['icl_initial_languagenonce']) && $_POST['icl_initial_languagenonce'] == wp_create_nonce('icl_initial_language')) {
$this->prepopulate_translations($_POST['icl_initial_language_code']);
$wpdb->update($wpdb->prefix . 'icl_languages', array('active' => '1'), array('code' => $_POST['icl_initial_language_code']));
$blog_default_cat = get_option('default_category');
$blog_default_cat_tax_id = $wpdb->get_var("SELECT term_taxonomy_id FROM {$wpdb->term_taxonomy} WHERE term_id='{$blog_default_cat}' AND taxonomy='category'");
if (isset($_POST['save_one_language'])) {
$this->settings['setup_wizard_step'] = 0;
$this->settings['setup_complete'] = 1;
} else {
$this->settings['setup_wizard_step'] = 2;
}
$this->settings['default_categories'] = array($_POST['icl_initial_language_code'] => $blog_default_cat_tax_id);
$this->settings['existing_content_language_verified'] = 1;
$this->settings['default_language'] = $_POST['icl_initial_language_code'];
$this->settings['admin_default_language'] = $this->admin_language = $_POST['icl_initial_language_code'];
// set the locale in the icl_locale_map (if it's not set)
$q = "SELECT code FROM {$wpdb->prefix}icl_locale_map WHERE code=%s";
$q_prepared = $wpdb->prepare($q, $_POST['icl_initial_language_code']);
if (!$wpdb->get_var($q_prepared)) {
$q = "SELECT default_locale FROM {$wpdb->prefix}icl_languages WHERE code=%s";
$q_prepared = $wpdb->prepare($q, $_POST['icl_initial_language_code']);
$default_locale = $wpdb->get_var($q_prepared);
if ($default_locale) {
$wpdb->insert($wpdb->prefix . 'icl_locale_map', array('code' => $_POST['icl_initial_language_code'], 'locale' => $default_locale));
}
}
$this->save_settings();
global $sitepress_settings;
$sitepress_settings = $this->settings;
$this->get_active_languages(true);
//refresh active languages list
do_action('icl_initial_language_set');
} elseif (isset($_POST['icl_language_pairs_formnounce']) && $_POST['icl_language_pairs_formnounce'] == wp_create_nonce('icl_language_pairs_form')) {
$this->save_language_pairs();
$this->settings['content_translation_languages_setup'] = 1;
// Move onto the site description page
$this->settings['content_translation_setup_wizard_step'] = 2;
$this->settings['website_kind'] = 2;
$this->settings['interview_translators'] = 1;
$this->save_settings();
} elseif (isset($_POST['icl_site_description_wizardnounce']) && $_POST['icl_site_description_wizardnounce'] == wp_create_nonce('icl_site_description_wizard')) {
if (isset($_POST['icl_content_trans_setup_back_2'])) {
// back button.
$this->settings['content_translation_languages_setup'] = 0;
$this->settings['content_translation_setup_wizard_step'] = 1;
$this->save_settings();
} elseif (isset($_POST['icl_content_trans_setup_next_2']) || isset($_POST['icl_content_trans_setup_next_2_enter'])) {
// next button.
$description = $_POST['icl_description'];
if ($description == "") {
$_POST['icl_form_errors'] = __('Please provide a short description of the website so that translators know what background is required from them.', 'sitepress');
} else {
$this->settings['icl_site_description'] = $description;
$this->settings['content_translation_setup_wizard_step'] = 3;
$this->save_settings();
}
}
}
}
function icl_register_string($context, $name, $value, $allow_empty_value = false)
{
global $wpdb, $sitepress, $sitepress_settings, $ICL_Pro_Translation;
// if the default language is not set up return without doing anything
if (!isset($sitepress_settings['existing_content_language_verified']) || !$sitepress_settings['existing_content_language_verified']) {
return;
}
// Check if cached (so exists)
$cached = icl_t_cache_lookup($context, $name);
if ($cached && isset($cached['original']) && $cached['original'] == $value) {
return;
}
$language = $sitepress->get_default_language();
$res = $wpdb->get_row("SELECT id, value, status, language FROM {$wpdb->prefix}icl_strings WHERE context='" . $wpdb->escape($context) . "' AND name='" . $wpdb->escape($name) . "'");
if ($res) {
$string_id = $res->id;
$update_string = array();
if ($value != $res->value) {
$update_string['value'] = $value;
}
if ($language != $res->language) {
$update_string['language'] = $language;
}
if (!empty($update_string)) {
$wpdb->update($wpdb->prefix . 'icl_strings', $update_string, array('id' => $string_id));
$wpdb->update($wpdb->prefix . 'icl_string_translations', array('status' => ICL_STRING_TRANSLATION_NEEDS_UPDATE), array('string_id' => $string_id));
icl_update_string_status($string_id);
}
} else {
if (!empty($value) && is_scalar($value) && trim($value) || $allow_empty_value) {
$string = array('language' => $language, 'context' => $context, 'name' => $name, 'value' => $value, 'status' => ICL_STRING_TRANSLATION_NOT_TRANSLATED);
$wpdb->insert($wpdb->prefix . 'icl_strings', $string);
$string_id = $wpdb->insert_id;
} else {
$string_id = 0;
}
}
global $WPML_Sticky_Links;
if (!empty($WPML_Sticky_Links) && $WPML_Sticky_Links->settings['sticky_links_strings']) {
require_once ICL_PLUGIN_PATH . '/inc/translation-management/pro-translation.class.php';
ICL_Pro_Translation::_content_make_links_sticky($string_id, 'string', false);
}
return $string_id;
}
function send_comment_to_translation($comment_id, $to_language)
{
global $wpdb, $sitepress_settings, $sitepress;
$iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
$from_lang = $sitepress->get_language_details($this->user_language);
$to_lang = $sitepress->get_language_details($to_language);
$from_lang_server = ICL_Pro_Translation::server_languages_map($from_lang['english_name']);
$to_lang_server = ICL_Pro_Translation::server_languages_map($to_lang['english_name']);
$body = $wpdb->get_var("SELECT comment_content FROM {$wpdb->comments} WHERE comment_ID={$comment_id}");
$rid = $iclq->cms_create_message($body, $from_lang_server, $to_lang_server);
if ($rid > 0) {
// does this comment already exist in the messages status queue?
$msid = $wpdb->get_var("SELECT id FROM {$wpdb->prefix}icl_message_status WHERE object_type='comment' AND object_id={$comment_id}");
if ($msid) {
$wpdb->update($wpdb->prefix . 'icl_message_status', array('rid' => $rid, 'md5' => md5($body), 'status' => MESSAGE_TRANSLATION_IN_PROGRESS), array('id' => $msid));
} else {
$wpdb->insert($wpdb->prefix . 'icl_message_status', array('rid' => $rid, 'object_id' => $comment_id, 'from_language' => $this->user_language, 'to_language' => $to_language, 'md5' => md5($body), 'object_type' => 'comment', 'status' => MESSAGE_TRANSLATION_IN_PROGRESS));
}
}
}
function _icl_translation_send_strings_icanlocalize($string_ids, $target)
{
global $wpdb, $sitepress, $sitepress_settings;
if (!$sitepress_settings['st']['strings_language']) {
$sitepress_settings['st']['strings_language'] = $sitepress->get_default_language();
}
$target_details = $sitepress->get_language_details($target);
// get all the untranslated strings
$untranslated = array();
foreach ($string_ids as $st_id) {
$status = $wpdb->get_var($wpdb->prepare("SELECT status FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d and language=%s", $st_id, $target));
if ($status != ICL_STRING_TRANSLATION_COMPLETE) {
$untranslated[] = $st_id;
}
}
if (sizeof($untranslated) > 0) {
// Something to translate.
$target_for_server = array(ICL_Pro_Translation::server_languages_map($target_details['english_name']));
//filter some language names to match the names on the server
$data = array('url' => '', 'target_languages' => $target_for_server);
$string_values = array();
foreach ($untranslated as $st_id) {
$string = $wpdb->get_row($wpdb->prepare("SELECT context, name, value FROM {$wpdb->prefix}icl_strings WHERE id=%d", $st_id));
$string_values[$st_id] = $string->value;
$data['contents']['string-' . $st_id . '-context'] = array('translate' => 0, 'data' => base64_encode(htmlspecialchars($string->context)), 'format' => 'base64');
$data['contents']['string-' . $st_id . '-name'] = array('translate' => 0, 'data' => base64_encode(htmlspecialchars($string->name)), 'format' => 'base64');
$data['contents']['string-' . $st_id . '-value'] = array('translate' => 1, 'data' => base64_encode(htmlspecialchars($string->value)), 'format' => 'base64');
}
$iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
$orig_lang = $sitepress->get_language_details($sitepress_settings['st']['strings_language']);
$orig_lang_for_server = ICL_Pro_Translation::server_languages_map($orig_lang['english_name']);
$timestamp = date('Y-m-d H:i:s');
$xml = $iclq->build_cms_request_xml($data, $orig_lang_for_server);
$args = array('xml' => $xml, 'title' => "String translations", 'to_languages' => $target_for_server, 'orig_language' => $orig_lang_for_server);
$res = $iclq->send_request($args);
if ($res > 0) {
foreach ($string_values as $st_id => $value) {
$wpdb->insert($wpdb->prefix . 'icl_string_status', array('rid' => $res, 'string_translation_id' => $st_id, 'timestamp' => $timestamp, 'md5' => md5($value)));
//insert rid
}
$wpdb->insert($wpdb->prefix . 'icl_core_status', array('rid' => $res, 'origin' => $orig_lang['code'], 'target' => $target, 'status' => CMS_REQUEST_WAITING_FOR_PROJECT_CREATION));
return $res;
} else {
return 0;
}
}
}
function get_translation_jobs($args = array())
{
global $wpdb, $sitepress, $wp_query;
// defaults
/** @var $translator_id int */
/** @var $status int */
/** @var $include_unassigned bool */
/** @var $orderby bool|string */
/** @var $limit_no int */
$args_default = array('translator_id' => 0, 'status' => false, 'include_unassigned' => false);
extract($args_default);
extract($args, EXTR_OVERWRITE);
$language_pairs = array();
$_exp = explode('-', $translator_id);
$service = isset($_exp[1]) ? $_exp[1] : 'local';
$translator_id = $_exp[0];
$where = " s.status > " . ICL_TM_NOT_TRANSLATED;
if ($status != '') {
$where .= " AND s.status=" . intval($status);
}
if ($status != ICL_TM_DUPLICATE) {
$where .= " AND s.status <> " . ICL_TM_DUPLICATE;
}
if (!empty($translator_id)) {
if ($include_unassigned) {
$where .= " AND (j.translator_id=" . intval($translator_id) . " OR j.translator_id=0) ";
} else {
$where .= " AND j.translator_id=" . intval($translator_id);
}
if (!empty($service)) {
$where .= " AND s.translation_service='{$service}'";
}
$language_pairs = get_user_meta($translator_id, $wpdb->prefix . 'language_pairs', true);
}
// HANDLE FROM
if (!empty($from)) {
$where .= PHP_EOL . " AND t.source_language_code='" . esc_sql($from) . "'";
} else {
// only if we filter by translator, make sure to use just the 'from' languages that apply
// in no translator_id, ommit condition and all will be pulled
if ($translator_id) {
if (!empty($to)) {
// get 'from' languages corresdonding to $to (to $translator_id)
$from_languages = array();
foreach ($language_pairs as $fl => $tls) {
if (isset($tls[$to])) {
$from_languages[] = $fl;
}
}
if ($from_languages) {
$where .= PHP_EOL . sprintf(" AND t.source_language_code IN(%s)", "'" . join("','", $from_languages) . "'");
}
} else {
// all to all case
// get all possible combinations for $translator_id
$from_languages = array_keys($language_pairs);
$where_conditions = array();
foreach ($from_languages as $fl) {
$to_languages = "'" . join("','", array_keys($language_pairs[$fl])) . "'";
$where_conditions[] = sprintf(" (t.source_language_code='%s' AND t.language_code IN (%s)) ", $fl, $to_languages);
}
if (!empty($where_conditions)) {
$where .= PHP_EOL . ' AND ( ' . join(' OR ', $where_conditions) . ')';
}
}
}
}
// HANDLE TO
if (!empty($to)) {
$where .= PHP_EOL . " AND t.language_code='" . esc_sql($to) . "'";
} else {
// only if we filter by translator, make sure to use just the 'from' languages that apply
// in no translator_id, omit condition and all will be pulled
if ($translator_id) {
if (!empty($from)) {
// get languages the user can translate into from $from
$tos = isset($language_pairs[$from]) ? array_keys($language_pairs[$from]) : array();
if ($tos) {
$where .= PHP_EOL . sprintf(" AND t.language_code IN(%s)", "'" . join("','", $tos) . "'");
}
} else {
// covered by 'all to all case' above
}
}
}
// ORDER BY
if ($include_unassigned) {
$orderby[] = 'j.translator_id DESC';
}
$orderby[] = ' j.job_id DESC ';
$orderby = join(', ', $orderby);
// LIMIT
if (!isset($_GET['paged'])) {
$_GET['paged'] = 1;
}
$offset = ($_GET['paged'] - 1) * $limit_no;
$limit = " " . $offset . ',' . $limit_no;
$jobs = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS\n\t\t\t\tj.job_id, t.trid, t.language_code, t.source_language_code,\n\t\t\t\ts.translation_id, s.status, s.needs_update, s.translator_id, u.display_name AS translator_name, s.translation_service\n\t\t\t\tFROM {$wpdb->prefix}icl_translate_job j\n\t\t\t\t\tJOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid\n\t\t\t\t\tJOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id\n\t\t\t\t\tLEFT JOIN {$wpdb->users} u ON s.translator_id = u.ID\n\t\t\t\tWHERE {$where} AND revision IS NULL\n\t\t\t\tORDER BY {$orderby}\n\t\t\t\tLIMIT {$limit}\n\t\t\t");
//echo '<pre>';
//print_r($wpdb->last_query);
//echo '</pre>';
$count = $wpdb->get_var("SELECT FOUND_ROWS()");
$wp_query->found_posts = $count;
$wp_query->query_vars['posts_per_page'] = $limit_no;
$wp_query->max_num_pages = ceil($wp_query->found_posts / $limit_no);
foreach ($jobs as $k => $row) {
//original
$post_id = $wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\t\t\t\t\t SELECT field_data\n\t\t\t\t\t\t\t\t\t\t\t\t\t FROM {$wpdb->prefix}icl_translate\n\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE job_id=%d and field_type='original_id'", $row->job_id));
$parts = explode('_', $post_id);
if ($parts[0] == 'external') {
$jobs[$k]->original_doc_id = $post_id;
$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t SELECT field_data\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM {$wpdb->prefix}icl_translate\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE job_id=%d and field_type='name'", $row->job_id)));
if ($jobs[$k]->post_title == "") {
// try the title field.
$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t SELECT field_data\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM {$wpdb->prefix}icl_translate\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t WHERE job_id=%d and field_type='title'", $row->job_id)));
}
$jobs[$k]->post_title = apply_filters('WPML_translation_job_title', $jobs[$k]->post_title, $post_id);
$jobs[$k]->edit_link = self::tm_post_link($post_id);
$ldf = $sitepress->get_language_details($row->source_language_code);
} else {
$doc = $wpdb->get_row($wpdb->prepare("SELECT ID, post_title, post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));
if ($doc) {
$jobs[$k]->post_title = $doc->post_title;
$jobs[$k]->original_doc_id = $doc->ID;
$jobs[$k]->edit_link = get_edit_post_link($doc->ID);
$ldf = $sitepress->get_language_details($sitepress->get_element_language_details($post_id, 'post_' . $doc->post_type)->language_code);
} else {
$jobs[$k]->post_title = __("The original has been deleted!", "sitepress");
$jobs[$k]->original_doc_id = 0;
$jobs[$k]->edit_link = "";
$ldf['display_name'] = __("Deleted", "sitepress");
}
}
$ldt = $sitepress->get_language_details($row->language_code);
$jobs[$k]->lang_text = $ldf['display_name'] . ' » ' . $ldt['display_name'];
if ($row->translation_service == 'icanlocalize') {
$row->translator_name = ICL_Pro_Translation::get_translator_name($row->translator_id);
}
}
return $jobs;
}
echo $post->post_type;
?>
" />
<?php
wp_nonce_field('send_translation_request_nonce', '_icl_nonce_pt_' . $post->ID);
?>
<input type="button" disabled="disabled" id="icl_pt_send" class="button-primary alignright" value="<?php
echo esc_html(__('Send to translation', 'wpml-translation-management'));
?>
" style="clear: right;"/>
<br clear="all" />
<?php
} else {
?>
<?php
$estimated_cost = sprintf("%.2f", (ICL_Pro_Translation::estimate_word_count($post, $selected_language) + ICL_Pro_Translation::estimate_custom_field_word_count($post->ID, $selected_language)) * 0.09);
?>
<div style="text-align: right;margin:0 5px 5px 0;white-space:nowrap;">
<?php
printf(__('Estimated cost: %s USD', 'wpml-translation-management'), $estimated_cost);
?>
<br />
(<?php
echo $sitepress->create_icl_popup_link('http://www.icanlocalize.com/destinations/go?name=cms-cost-estimate&iso=' . $sitepress->get_locale($sitepress->get_admin_language()) . '&src=' . get_option('home'), array('ar' => 1, 'title' => __('Cost estimate', 'wpml-translation-management'))) . __('why estimated?', 'wpml-translation-management');
?>
</a>)
</div>
<br />
<p><b><?php
echo $sitepress->create_icl_popup_link('http://www.icanlocalize.com/destinations/go?name=moreinfo-wp&iso=' . $sitepress->get_locale($sitepress->get_admin_language()) . '&src=' . get_option('home'), array('title' => __('About Our Translators', 'wpml-translation-management'), 'ar' => 1));
// included from Sitepress::reminder_popups
//
// NOTE: this is also used for other popup links to ICanLocalize
global $wpdb;
$target = $_GET['target'];
$auto_resize = isset($_GET['auto_resize']) && $_GET['auto_resize'];
$unload_cb = isset($_GET['unload_cb']) ? $_GET['unload_cb'] : false;
if (preg_match('|^@select-translators;([^;]+);([^;]+)@|', $target, $matches)) {
$from_lang = $matches[1];
$to_lang = $matches[2];
require_once ICL_PLUGIN_PATH . '/lib/Snoopy.class.php';
require_once ICL_PLUGIN_PATH . '/lib/xml2array.php';
require_once ICL_PLUGIN_PATH . '/lib/icl_api.php';
$icl_query = new ICanLocalizeQuery();
foreach ($this->get_active_languages() as $lang) {
$lang_server[$lang['code']] = ICL_Pro_Translation::server_languages_map($lang['english_name']);
}
if (!$this->icl_account_configured()) {
$user['create_account'] = 1;
$user['anon'] = 1;
$user['platform_kind'] = 2;
$user['cms_kind'] = 1;
$user['blogid'] = $wpdb->blogid ? $wpdb->blogid : 1;
$user['url'] = get_option('siteurl');
$user['title'] = get_option('blogname');
$user['description'] = @strval($this->settings['icl_site_description']);
$user['is_verified'] = 1;
if (defined('ICL_AFFILIATE_ID') && defined('ICL_AFFILIATE_KEY')) {
$user['affiliate_id'] = ICL_AFFILIATE_ID;
$user['affiliate_key'] = ICL_AFFILIATE_KEY;
}
//break;
//break;
case 'icl_cms_id_fix':
$iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
$p = $wpdb->get_row("SELECT t.* FROM {$wpdb->prefix}icl_translations t JOIN {$wpdb->prefix}icl_translation_status s ON t.translation_id=s.translation_id\n WHERE t.element_type LIKE 'post\\_%' AND t.source_language_code IS NOT NULL AND s.translation_service='icanlocalize' LIMIT {$_REQUEST['offset']}, 1");
if (!empty($p)) {
$original_id = $wpdb->get_var($wpdb->prepare("SELECT element_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL", $p->trid));
if ($p->element_type == 'post_page') {
$permalink = get_option('home') . '?page_id=' . $original_id;
} else {
$permalink = get_option('home') . '?p=' . $original_id;
}
$_lang_details = $sitepress->get_language_details($p->source_language_code);
$from_language = ICL_Pro_Translation::server_languages_map($_lang_details['english_name']);
$_lang_details = $sitepress->get_language_details($p->language_code);
$to_language = ICL_Pro_Translation::server_languages_map($_lang_details['english_name']);
$cms_id = sprintf('%s_%d_%s_%s', preg_replace('#^post_#', '', $p->element_type), $original_id, $p->source_language_code, $p->language_code);
$ret = $iclq->update_cms_id(compact('permalink', 'from_language', 'to_language', 'cms_id'));
if ($ret != $cms_id && $iclq->error()) {
echo json_encode(array('errors' => 1, 'message' => $iclq->error(), 'cont' => 0));
} else {
echo json_encode(array('errors' => 0, 'message' => 'OK', 'cont' => 1));
}
} else {
echo json_encode(array('errors' => 0, 'message' => __('Done', 'sitepress'), 'cont' => 0));
}
exit;
//break;
//break;
case 'icl_cleanup':
global $sitepress, $wpdb, $wp_post_types;
/** * Creates and sends translation snapshots. *
* Called by the scheduled cron event.
*/
function send_translation_snapshots()
{
if (!defined('ICL_PLUGIN_PATH')) {
return;
}
require_once ICL_PLUGIN_PATH . '/inc/translation-management/pro-translation.class.php';
global $sitepress, $sitepress_settings;
if (isset($sitepress_settings['site_id'])) {
$jobs = $this->get_translation_jobs();
$total_word_count = $this->get_translation_word_count($jobs);
// Do not send snapshots when nothing changed
$icl_settings = $sitepress->get_settings();
if (isset($icl_settings['snapshot_word_count']) and $icl_settings['snapshot_word_count'] == $total_word_count) {
return;
} else {
$icl_settings['snapshot_word_count'] = $total_word_count;
$sitepress->save_settings($icl_settings);
}
$datetime = new DateTime();
if (!empty($total_word_count['total'])) {
foreach ($total_word_count['total'] as $from => $to_list) {
foreach ($to_list as $to => $value) {
// Convert language names to icanlocalize format
$from_language_name = ICL_Pro_Translation::server_languages_map($from);
$to_language_name = ICL_Pro_Translation::server_languages_map($to);
$params = array('date' => $datetime->format("Y-m-d\\TH:i:s-P"), 'from_language_name' => $from_language_name, 'to_language_name' => $to_language_name, 'words_to_translate' => $value, 'translated_words' => $total_word_count['finished'][$from][$to]);
$this->send_translation_snapshot_to_icl($params);
}
}
}
}
}
$sitepress->save_settings(array('quote-get' => $saved));
echo __('An unknown error has occurred when communicating with the ICanLocalize server. Please try again.', 'sitepress') . '<br /><br />';
require_once ICL_PLUGIN_PATH . '/inc/quote/quote-get.php';
exit;
}
}
/**
* Set URL query
*/
$language_pairs = array($saved['from'] => $saved['to']);
$lang_pairs = array();
$incr = 1;
$query = '';
if (isset($language_pairs)) {
foreach ($language_pairs as $k => $v) {
$english_from = $wpdb->get_var("SELECT english_name FROM {$wpdb->prefix}icl_languages WHERE code='{$k}' ");
$query .= '&to_lang_num=' . count($v);
$query .= '&from_language_name=' . $english_from;
foreach ($v as $k => $v) {
$english_to = $wpdb->get_var("SELECT english_name FROM {$wpdb->prefix}icl_languages WHERE code='{$k}' ");
$query .= '&to_language_name_' . $incr . '=' . ICL_Pro_Translation::server_languages_map($english_to);
$incr++;
}
}
}
$url = ICL_API_ENDPOINT . '/websites/' . $site_id . '/quote?accesskey=' . $access_key . '&locale=' . $sitepress->get_default_language() . $query . '&compact=1';
// Call reopen JS
echo '<script type="text/javascript">icl_thickbox_reopen(\'' . $url . '\');</script>';
exit;
}
}
function get_translation_jobs($args = array())
{
global $wpdb, $sitepress, $wp_query;
// defaults
$args_default = array('translator_id' => 0, 'status' => false, 'include_unassigned' => false);
extract($args_default);
extract($args, EXTR_OVERWRITE);
$_exp = explode('-', $translator_id);
$service = isset($_exp[1]) ? $_exp[1] : 'local';
$translator_id = $_exp[0];
$where = " s.status > " . ICL_TM_NOT_TRANSLATED;
if ($status != '') {
$where .= " AND s.status=" . intval($status);
}
if (!empty($translator_id)) {
if ($include_unassigned) {
$where .= " AND (j.translator_id=" . intval($translator_id) . " OR j.translator_id=0) ";
} else {
$where .= " AND j.translator_id=" . intval($translator_id);
}
if (!empty($service)) {
$where .= " AND s.translation_service='{$service}'";
}
}
if (!empty($from)) {
$where .= " AND t.source_language_code='" . $wpdb->escape($from) . "'";
}
if (!empty($to)) {
$where .= " AND t.language_code='" . $wpdb->escape($to) . "'";
}
// ORDER BY
if ($include_unassigned) {
$orderby[] = 'j.translator_id DESC';
}
$orderby[] = ' j.job_id DESC ';
$orderby = join(', ', $orderby);
// LIMIT
if (!isset($_GET['paged'])) {
$_GET['paged'] = 1;
}
$offset = ($_GET['paged'] - 1) * $limit_no;
$limit = " " . $offset . ',' . $limit_no;
$jobs = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS \n j.job_id, t.trid, t.language_code, t.source_language_code, \n s.translation_id, s.status, s.needs_update, s.translator_id, u.display_name AS translator_name, s.translation_service \n FROM {$wpdb->prefix}icl_translate_job j\n JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid\n JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id\n LEFT JOIN {$wpdb->users} u ON s.translator_id = u.ID\n WHERE {$where} AND revision IS NULL\n ORDER BY {$orderby}\n LIMIT {$limit}\n ");
$count = $wpdb->get_var("SELECT FOUND_ROWS()");
$wp_query->found_posts = $count;
$wp_query->query_vars['posts_per_page'] = $limit_no;
$wp_query->max_num_pages = ceil($wp_query->found_posts / $limit_no);
foreach ($jobs as $k => $row) {
//original
$post_id = $wpdb->get_var($wpdb->prepare("\n SELECT field_data\n FROM {$wpdb->prefix}icl_translate\n WHERE job_id=%d and field_type='original_id'", $row->job_id));
$parts = explode('_', $post_id);
if ($parts[0] == 'external') {
$jobs[$k]->original_doc_id = $post_id;
$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("\n SELECT field_data\n FROM {$wpdb->prefix}icl_translate\n WHERE job_id=%d and field_type='name'", $row->job_id)));
if ($jobs[$k]->post_title == "") {
// try the title field.
$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("\n SELECT field_data\n FROM {$wpdb->prefix}icl_translate\n WHERE job_id=%d and field_type='title'", $row->job_id)));
}
$jobs[$k]->edit_link = $this->tm_post_link($post_id);
$ldf = $sitepress->get_language_details($row->source_language_code);
} else {
$doc = $wpdb->get_row($wpdb->prepare("SELECT ID, post_title, post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));
if ($doc) {
$jobs[$k]->post_title = $doc->post_title;
$jobs[$k]->original_doc_id = $doc->ID;
$jobs[$k]->edit_link = get_edit_post_link($doc->ID);
$ldf = $sitepress->get_language_details($sitepress->get_element_language_details($post_id, 'post_' . $doc->post_type)->language_code);
} else {
$jobs[$k]->post_title = __("The original has been deleted!", "sitepress");
$jobs[$k]->original_doc_id = 0;
$jobs[$k]->edit_link = "";
$ldf['display_name'] = __("Deleted", "sitepress");
}
}
$ldt = $sitepress->get_language_details($row->language_code);
$jobs[$k]->lang_text = $ldf['display_name'] . ' » ' . $ldt['display_name'];
if ($row->translation_service == 'icanlocalize') {
$row->translator_name = ICL_Pro_Translation::get_translator_name($row->translator_id);
}
}
return $jobs;
}
function get_translation_jobs($args = array())
{
global $wpdb, $sitepress, $wp_query;
// defaults
$args_default = array('translator_id' => 0, 'status' => false, 'include_unassigned' => false);
extract($args_default);
extract($args, EXTR_OVERWRITE);
$_exp = explode('-', $translator_id);
$service = isset($_exp[1]) ? $_exp[1] : 'local';
$translator_id = $_exp[0];
$where = "1";
if ($status != '') {
$where .= " AND s.status=" . intval($status);
}
if (!empty($translator_id)) {
if ($include_unassigned) {
$where .= " AND (j.translator_id=" . intval($translator_id) . " OR j.translator_id=0) ";
} else {
$where .= " AND j.translator_id=" . intval($translator_id);
}
if (!empty($service)) {
$where .= " AND s.translation_service='{$service}'";
}
}
if (!empty($from)) {
$where .= " AND t.source_language_code='" . $wpdb->escape($from) . "'";
}
if (!empty($to)) {
$where .= " AND t.language_code='" . $wpdb->escape($to) . "'";
}
// ORDER BY
if ($include_unassigned) {
$orderby[] = 'j.translator_id DESC';
}
$orderby[] = ' j.job_id DESC ';
$orderby = join(', ', $orderby);
// LIMIT
if (!isset($_GET['paged'])) {
$_GET['paged'] = 1;
}
$offset = ($_GET['paged'] - 1) * $limit_no;
$limit = " " . $offset . ',' . $limit_no;
$jobs = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS \r\n j.job_id, t.trid, t.language_code, t.source_language_code, s.status, s.needs_update, s.translator_id, u.display_name AS translator_name, s.translation_service \r\n FROM {$wpdb->prefix}icl_translate_job j\r\n JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid\r\n JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id\r\n LEFT JOIN {$wpdb->users} u ON s.translator_id = u.ID\r\n WHERE {$where} AND revision IS NULL\r\n ORDER BY {$orderby}\r\n LIMIT {$limit}\r\n ");
$count = $wpdb->get_var("SELECT FOUND_ROWS()");
$wp_query->found_posts = $count;
$wp_query->query_vars['posts_per_page'] = $limit_no;
$wp_query->max_num_pages = ceil($wp_query->found_posts / $limit_no);
foreach ($jobs as $k => $row) {
//original
$doc = $wpdb->get_row($wpdb->prepare("\r\n SELECT p.ID, p.post_title \r\n FROM {$wpdb->prefix}icl_translations t \r\n JOIN {$wpdb->posts} p ON p.ID = t.element_id\r\n WHERE t.trid = %d AND t.language_code = '%s'", $row->trid, $row->source_language_code));
$jobs[$k]->post_title = $doc->post_title;
$jobs[$k]->edit_link = get_edit_post_link($doc->ID);
$ldt = $sitepress->get_language_details($row->language_code);
$ldf = $sitepress->get_language_details($row->source_language_code);
$jobs[$k]->lang_text = $ldf['display_name'] . ' » ' . $ldt['display_name'];
if ($row->translation_service == 'icanlocalize') {
$row->translator_name = ICL_Pro_Translation::get_translator_name($row->translator_id);
}
}
return $jobs;
}
public function register_string($context, $name, $value, $allow_empty_value = false)
{
global $wpdb, $sitepress_settings;
/* cpt slugs - do not register them when scanning themes and plugins
* if name starting from 'URL slug: '
* and context is different from 'WordPress'
*/
if (substr($name, 0, 10) === 'URL slug: ' && 'WordPress' !== $context) {
return false;
}
// if the default language is not set up return without doing anything
if (!isset($sitepress_settings['existing_content_language_verified']) || !$sitepress_settings['existing_content_language_verified']) {
return false;
}
$translation = $this->string_from_registered($value, $name, $context);
if ($translation == $value) {
return false;
}
$language = isset($sitepress_settings['st']['strings_language']) ? $sitepress_settings['st']['strings_language'] : 'en';
$query = $wpdb->prepare("SELECT id, value, status, language FROM {$wpdb->prefix}icl_strings WHERE context=%s AND name=%s", $context, $name);
$res = $wpdb->get_row($query);
if ($res) {
$string_id = $res->id;
$update_string = array();
/*
* If Sticky Links plugin is active and set to change links in Strings,
* we need to process $value and change links into sticky before comparing
* with saved in DB $res->value.
* Otherwise after every String Translation screen refresh status of this string
* will be changed into 'needs update'
*/
$alp_settings = get_option('alp_settings');
if (!empty($alp_settings['sticky_links_strings']) && $alp_settings['sticky_links_strings'] && defined('WPML_STICKY_LINKS_VERSION')) {
// sticky links plugin is active?
require_once ICL_PLUGIN_PATH . '/inc/absolute-links/absolute-links.class.php';
$absolute_links_object = new AbsoluteLinks();
$alp_broken_links = array();
$value = $absolute_links_object->_process_generic_text($value, $alp_broken_links);
}
if ($value != $res->value) {
$update_string['value'] = $value;
}
if ($language != $res->language) {
$update_string['language'] = $language;
}
if (!empty($update_string)) {
$wpdb->update($wpdb->prefix . 'icl_strings', $update_string, array('id' => $string_id));
$wpdb->update($wpdb->prefix . 'icl_string_translations', array('status' => ICL_STRING_TRANSLATION_NEEDS_UPDATE), array('string_id' => $string_id));
icl_update_string_status($string_id);
}
} else {
$string_id = $this->save_string($value, $allow_empty_value, $language, $context, $name);
}
global $WPML_Sticky_Links;
if (!empty($WPML_Sticky_Links) && $WPML_Sticky_Links->settings['sticky_links_strings']) {
require_once ICL_PLUGIN_PATH . '/inc/translation-management/pro-translation.class.php';
ICL_Pro_Translation::_content_make_links_sticky($string_id, 'string', false);
}
$this->name_cache[$name . $context] = $value;
return $string_id;
}
