PageRenderTime 59ms CodeModel.GetById 24ms RepoModel.GetById 1ms app.codeStats 0ms

/htdocs/wp-content/plugins/sitepress-multilingual-cms/inc/translation-management/pro-translation.class.php

https://bitbucket.org/dkrzos/phc
PHP | 2138 lines | 1829 code | 222 blank | 87 comment | 202 complexity | 41e364292868e7ffbbffc54924dfffc1 MD5 | raw file
Possible License(s): GPL-2.0

Large files files are truncated, but you can click here to view the full file

  1. <?php
  2. // deprecated - used for string translations
  3. define ( 'CMS_TARGET_LANGUAGE_CREATED', 0);
  4. define ( 'CMS_TARGET_LANGUAGE_ASSIGNED', 1);
  5. define ( 'CMS_TARGET_LANGUAGE_TRANSLATED', 2);
  6. define ( 'CMS_TARGET_LANGUAGE_DONE', 3);
  7. define ( 'CMS_REQUEST_DONE', 6);
  8. define ( 'CMS_REQUEST_FAILED', 7);
  9. class ICL_Pro_Translation{
  10. private $tmg;
  11. protected static $__asian_languages = array('ja', 'ko', 'zh-hans', 'zh-hant', 'mn', 'ne', 'hi', 'pa', 'ta', 'th');
  12. function __construct(){
  13. global $iclTranslationManagement;
  14. $this->tmg =& $iclTranslationManagement;
  15. add_filter('xmlrpc_methods',array($this, 'custom_xmlrpc_methods'));
  16. add_action('post_submitbox_start', array($this, 'post_submitbox_start'));
  17. add_action('icl_ajx_custom_call', array($this, 'ajax_calls'), 10, 2);
  18. add_action('icl_hourly_translation_pickup', array($this, 'poll_for_translations'));
  19. }
  20. function ajax_calls($call, $data){
  21. global $sitepress_settings, $sitepress;
  22. switch($call){
  23. case 'set_pickup_mode':
  24. $method = intval($data['icl_translation_pickup_method']);
  25. $iclsettings['translation_pickup_method'] = $method;
  26. $iclsettings['icl_disable_reminders'] = isset($_POST['icl_disable_reminders']) ? 1 : 0;
  27. $sitepress->save_settings($iclsettings);
  28. if(!empty($sitepress_settings) && !empty($sitepress_settings['site_id']) && !empty($sitepress_settings['access_key'])){
  29. $data['site_id'] = $sitepress_settings['site_id'];
  30. $data['accesskey'] = $sitepress_settings['access_key'];
  31. $data['create_account'] = 0;
  32. $data['pickup_type'] = $method;
  33. $icl_query = new ICanLocalizeQuery();
  34. $res = $icl_query->updateAccount($data);
  35. }
  36. if($method == ICL_PRO_TRANSLATION_PICKUP_XMLRPC){
  37. wp_clear_scheduled_hook('icl_hourly_translation_pickup');
  38. }else{
  39. wp_schedule_event(time(), 'hourly', 'icl_hourly_translation_pickup');
  40. }
  41. echo json_encode(array('message'=>'OK'));
  42. break;
  43. case 'pickup_translations':
  44. if($sitepress_settings['translation_pickup_method']==ICL_PRO_TRANSLATION_PICKUP_POLLING){
  45. $fetched = $this->poll_for_translations(true);
  46. echo json_encode(array('message'=>'OK', 'fetched'=> urlencode('&nbsp;' . sprintf(__('Fetched %d translations.', 'sitepress'), $fetched))));
  47. }else{
  48. echo json_encode(array('error'=>__('Manual pick up is disabled.', 'sitepress')));
  49. }
  50. break;
  51. }
  52. }
  53. function send_post($post, $target_languages, $translator_id = 0){
  54. global $sitepress, $sitepress_settings, $wpdb, $iclTranslationManagement;
  55. // don't wait for init
  56. if(empty($this->tmg->settings)){
  57. $iclTranslationManagement->init();
  58. }
  59. if(is_numeric($post)){
  60. $post = get_post($post);
  61. }
  62. $post_id = $post->ID;
  63. $err = false;
  64. if(!$post){
  65. return false;
  66. }
  67. $orig_lang = $sitepress->get_language_for_element($post_id, 'post_' . $post->post_type);
  68. $__ld = $sitepress->get_language_details($orig_lang);
  69. $orig_lang_for_server = $this->server_languages_map($__ld['english_name']);
  70. if(empty($target_languages)) return false;
  71. // Make sure the previous request is complete.
  72. // Only send if it needs update
  73. foreach($target_languages as $target_lang){
  74. if($target_lang == $orig_lang) continue;
  75. $translation = $this->tmg->get_element_translation($post_id, $target_lang, 'post_' . $post->post_type);
  76. if(empty($translation)){ // translated the first time
  77. $tdata = array(
  78. 'translate_from' => array($orig_lang),
  79. 'translate_to' => array($target_lang=>1),
  80. 'post' => array($post_id),
  81. 'translator' => $translator_id,
  82. 'service' => 'icanlocalize'
  83. );
  84. $this->tmg->send_jobs($tdata);
  85. $translation = $this->tmg->get_element_translation($post_id, $target_lang, 'post_' . $post->post_type);
  86. }
  87. if($translation->needs_update || $translation->status == ICL_TM_NOT_TRANSLATED || $translation->status == ICL_TM_WAITING_FOR_TRANSLATOR){
  88. $iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
  89. if($post->post_type=='page'){
  90. $post_url = get_option('home') . '?page_id=' . ($post_id);
  91. }else{
  92. $post_url = get_option('home') . '?p=' . ($post_id);
  93. }
  94. $__ld = $sitepress->get_language_details($target_lang);
  95. $target_for_server = $this->server_languages_map($__ld['english_name']);
  96. if (isset($post->external_type) && $post->external_type) {
  97. $data['url'] = htmlentities($post_url);
  98. $data['target_languages'] = array($target_for_server);
  99. foreach ($post->string_data as $key => $value) {
  100. $data['contents'][$key] = array(
  101. 'translate' => 1,
  102. 'data' => base64_encode($value),
  103. 'format' => 'base64'
  104. );
  105. }
  106. $data['contents']['original_id'] = array(
  107. 'translate' => 0,
  108. 'data' => $post->post_id,
  109. );
  110. } else {
  111. // TAGS
  112. // ***************************************************************************
  113. foreach(wp_get_object_terms($post_id, 'post_tag') as $tag){
  114. $post_tags[$tag->term_taxonomy_id] = $tag->name;
  115. }
  116. if(@is_array($post_tags)){
  117. //only send tags that don't have a translation
  118. foreach($post_tags as $term_taxonomy_id=>$pc){
  119. $trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_id='{$term_taxonomy_id}' AND element_type='tax_post_tag'");
  120. foreach($target_languages as $lang){
  121. $not_translated = false;
  122. if($trid != $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE language_code='{$lang}' AND trid='{$trid}' AND element_id IS NOT NULL")){
  123. $not_translated = true;
  124. break;
  125. }
  126. }
  127. if($not_translated){
  128. $tags_to_translate[$term_taxonomy_id] = $pc;
  129. }
  130. }
  131. sort($post_tags, SORT_STRING);
  132. }
  133. // CATEGORIES
  134. // ***************************************************************************
  135. foreach(wp_get_object_terms($post_id, 'category') as $cat){
  136. $post_categories[$cat->term_taxonomy_id] = $cat->name;
  137. }
  138. if(@is_array($post_categories)){
  139. //only send categories that don't have a translation
  140. foreach($post_categories as $term_taxonomy_id=>$pc){
  141. $trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_id='{$term_taxonomy_id}' AND element_type='tax_category'");
  142. foreach($target_languages as $lang){
  143. $not_translated = false;
  144. if($trid != $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE language_code='{$lang}' AND trid='{$trid}' AND element_id IS NOT NULL")){
  145. $not_translated = true;
  146. break;
  147. }
  148. }
  149. if($not_translated){
  150. $categories_to_translate[$term_taxonomy_id] = $pc;
  151. }
  152. }
  153. sort($post_categories, SORT_STRING);
  154. }
  155. // CUSTOM TAXONOMIES
  156. // ***************************************************************************
  157. $taxonomies = $wpdb->get_col("
  158. SELECT DISTINCT tx.taxonomy
  159. FROM {$wpdb->term_taxonomy} tx JOIN {$wpdb->term_relationships} tr ON tx.term_taxonomy_id = tr.term_taxonomy_id
  160. WHERE tr.object_id = {$post_id}
  161. ");
  162. foreach($taxonomies as $t){
  163. if(@intval($sitepress_settings['taxonomies_sync_option'][$t]) == 1){
  164. $object_terms = $wpdb->get_results("
  165. SELECT x.term_taxonomy_id, t.name
  166. FROM {$wpdb->terms} t
  167. JOIN {$wpdb->term_taxonomy} x ON t.term_id=x.term_id
  168. JOIN {$wpdb->term_relationships} r ON x.term_taxonomy_id = r.term_taxonomy_id
  169. WHERE x.taxonomy = '{$t}' AND r.object_id = $post_id
  170. ");
  171. foreach($object_terms as $trm){
  172. $trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations
  173. WHERE element_id='{$trm->term_taxonomy_id}' AND element_type='tax_{$t}'");
  174. foreach($target_languages as $lang){
  175. $not_translated = false;
  176. if($trid != $wpdb->get_var("
  177. SELECT trid FROM {$wpdb->prefix}icl_translations WHERE l.english_name='{$lang}' AND trid='{$trid}' AND element_id IS NOT NULL
  178. ")){
  179. $not_translated = true;
  180. break;
  181. }
  182. }
  183. if($not_translated){
  184. $taxonomies_to_translate[$t][$trm->term_taxonomy_id] = $trm->name;
  185. }
  186. }
  187. }
  188. }
  189. $data['url'] = htmlentities($post_url);
  190. $data['contents']['title'] = array(
  191. 'translate'=>1,
  192. 'data'=>base64_encode($post->post_title),
  193. 'format'=>'base64'
  194. );
  195. if($sitepress_settings['translated_document_page_url'] == 'translate'){
  196. $data['contents']['URL'] = array(
  197. 'translate'=>1,
  198. 'data'=>base64_encode($post->post_name),
  199. 'format'=>'base64'
  200. );
  201. }
  202. if(!empty($post->post_excerpt))
  203. $data['contents']['excerpt'] = array(
  204. 'translate'=>1,
  205. 'data'=>base64_encode($post->post_excerpt),
  206. 'format'=>'base64'
  207. );
  208. $data['contents']['body'] = array(
  209. 'translate'=>1,
  210. 'data'=>base64_encode($post->post_content),
  211. 'format'=>'base64'
  212. );
  213. $data['contents']['original_id'] = array(
  214. 'translate'=>0,
  215. 'data'=>$post_id
  216. );
  217. $data['target_languages'] = array($target_for_server);
  218. $custom_fields = array();
  219. foreach((array)$iclTranslationManagement->settings['custom_fields_translation'] as $cf => $op){
  220. if ($op == 2) {
  221. $custom_fields[] = $cf;
  222. }
  223. }
  224. foreach($custom_fields as $cf){
  225. $custom_fields_value = get_post_meta($post_id, $cf, true);
  226. if ($custom_fields_value != '') {
  227. $data['contents']['field-'.$cf] = array(
  228. 'translate' => 1,
  229. 'data' => base64_encode($custom_fields_value),
  230. 'format' => 'base64',
  231. );
  232. $data['contents']['field-'.$cf.'-name'] = array(
  233. 'translate' => 0,
  234. 'data' => $cf,
  235. );
  236. $data['contents']['field-'.$cf.'-type'] = array(
  237. 'translate' => 0,
  238. 'data' => 'custom_field',
  239. );
  240. }
  241. }
  242. if(@is_array($categories_to_translate)){
  243. $data['contents']['categories'] = array(
  244. 'translate'=>1,
  245. 'data'=> implode(',', array_map(create_function('$e', 'return \'&quot;\'.base64_encode($e).\'&quot;\';'), $categories_to_translate)),
  246. 'format'=>'csv_base64'
  247. );
  248. $data['contents']['category_ids'] = array(
  249. 'translate'=>0,
  250. 'data'=> implode(',', array_keys($categories_to_translate)),
  251. 'format'=>''
  252. );
  253. }
  254. if(@is_array($tags_to_translate)){
  255. $data['contents']['tags'] = array(
  256. 'translate'=>1,
  257. 'data'=> implode(',', array_map(create_function('$e', 'return \'&quot;\'.base64_encode($e).\'&quot;\';'), $tags_to_translate)),
  258. 'format'=>'csv_base64'
  259. );
  260. $data['contents']['tag_ids'] = array(
  261. 'translate'=>0,
  262. 'data'=> implode(',', array_keys($tags_to_translate)),
  263. 'format'=>''
  264. );
  265. }
  266. if(@is_array($taxonomies_to_translate)){
  267. foreach($taxonomies_to_translate as $k=>$v){
  268. $data['contents'][$k] = array(
  269. 'translate'=>1,
  270. 'data'=> implode(',', array_map(create_function('$e', 'return \'&quot;\'.base64_encode($e).\'&quot;\';'), $v)),
  271. 'format'=>'csv_base64'
  272. );
  273. $data['contents'][$k.'_ids'] = array(
  274. 'translate'=>0,
  275. 'data'=> implode(',', array_keys($v)),
  276. 'format'=>''
  277. );
  278. }
  279. }
  280. if($post->post_status=='publish'){
  281. $permlink = $post_url;
  282. }else{
  283. $permlink = false;
  284. }
  285. $note = get_post_meta($post_id, '_icl_translator_note', true);
  286. // if this is an old request having a old request_id, include that
  287. if($wpdb->prefix.'icl_content_status' == $wpdb->get_var("SHOW TABLES LIKE '{$wpdb->prefix}icl_content_status'")){
  288. $prev_rid = $wpdb->get_var($wpdb->prepare("SELECT MAX(rid) FROM {$wpdb->prefix}icl_content_status WHERE nid=%d", $post_id));
  289. if(!empty($prev_rid)){
  290. $data['previous_cms_request_id'] = $prev_rid;
  291. }
  292. }
  293. }
  294. $data = apply_filters('icl_data_for_pro_translation', $data);
  295. $xml = $iclq->build_cms_request_xml($data, $orig_lang_for_server);
  296. $cms_id = sprintf('%s_%d_%s_%s', $post->post_type, $post->ID, $orig_lang, $target_lang);
  297. $args = array(
  298. 'cms_id' => $cms_id,
  299. 'xml' => $xml,
  300. 'title' => $post->post_title,
  301. 'to_languages' => array($target_for_server),
  302. 'orig_language' => $orig_lang_for_server,
  303. 'permlink' => isset($permlink) ? $permlink : false,
  304. 'translator_id' => $translator_id,
  305. 'note' => isset($note) ? $note : '',
  306. );
  307. $res = $iclq->send_request($args);
  308. if($res > 0){
  309. $this->tmg->update_translation_status(array(
  310. 'translation_id'=>$translation->translation_id,
  311. 'status' => ICL_TM_IN_PROGRESS,
  312. 'needs_update' => 0
  313. ));
  314. }else{
  315. $_prevstate = $wpdb->get_var($wpdb->prepare("SELECT _prevstate FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation->translation_id));
  316. if(!empty($_prevstate)){
  317. $_prevstate = unserialize($_prevstate);
  318. $wpdb->update($wpdb->prefix . 'icl_translation_status',
  319. array(
  320. 'status' => $_prevstate['status'],
  321. 'translator_id' => $_prevstate['translator_id'],
  322. 'status' => $_prevstate['status'],
  323. 'needs_update' => $_prevstate['needs_update'],
  324. 'md5' => $_prevstate['md5'],
  325. 'translation_service' => $_prevstate['translation_service'],
  326. 'translation_package' => $_prevstate['translation_package'],
  327. 'timestamp' => $_prevstate['timestamp'],
  328. 'links_fixed' => $_prevstate['links_fixed']
  329. ),
  330. array('translation_id'=>$translation->translation_id)
  331. );
  332. }else{
  333. $wpdb->update($wpdb->prefix . 'icl_translation_status',
  334. array('status'=>ICL_TM_NOT_TRANSLATED, 'needs_update'=>0), array('translation_id'=>$translation->translation_id));
  335. }
  336. $err = true;
  337. }
  338. } // if needs translation
  339. } // foreach target lang
  340. return $err ? false : $res; //last $ret
  341. }
  342. public function server_languages_map($language_name, $server2plugin = false){
  343. if(is_array($language_name)){
  344. return array_map(array($this, 'icl_server_languages_map'), $language_name);
  345. }
  346. $map = array(
  347. 'Norwegian Bokmål' => 'Norwegian',
  348. 'Portuguese, Brazil' => 'Portuguese',
  349. 'Portuguese, Portugal' => 'Portugal Portuguese'
  350. );
  351. if($server2plugin){
  352. $map = array_flip($map);
  353. }
  354. if(isset($map[$language_name])){
  355. return $map[$language_name];
  356. }else{
  357. return $language_name;
  358. }
  359. }
  360. function custom_xmlrpc_methods($methods){
  361. $icl_methods['icanlocalize.update_status_by_cms_id'] = array($this, 'get_translated_document');
  362. // for migration to 2.0.0
  363. $icl_methods['icanlocalize.set_translation_status'] = array($this,'_legacy_set_translation_status');
  364. //$icl_methods['icanlocalize.set_translation_status'] = array($this,'get_translated_string'); // use for strings - old method
  365. //$icl_methods['icanlocalize.list_posts'] = array($this, '_list_posts');
  366. //$icl_methods['icanlocalize.translate_post'] = array($this, '_remote_control_translate_post');
  367. $icl_methods['icanlocalize.test_xmlrpc'] = array($this, '_test_xmlrpc');
  368. $icl_methods['icanlocalize.cancel_translation_by_cms_id'] = array($this, '_xmlrpc_cancel_translation');
  369. // for migration to 2.0.0
  370. $icl_methods['icanlocalize.cancel_translation'] = array($this, '_legacy_xmlrpc_cancel_translation');
  371. $icl_methods['icanlocalize.notify_comment_translation'] = array($this, '_xmlrpc_add_message_translation');
  372. $methods = $methods + $icl_methods;
  373. if(defined('XMLRPC_REQUEST') && XMLRPC_REQUEST){
  374. preg_match('#<methodName>([^<]+)</methodName>#i', $GLOBALS['HTTP_RAW_POST_DATA'], $matches);
  375. $method = $matches[1];
  376. if(in_array($method, array_keys($icl_methods))){
  377. //error_reporting(E_NONE);
  378. //ini_set('display_errors', '0');
  379. $old_error_handler = set_error_handler(array($this, "_translation_error_handler"),E_ERROR|E_USER_ERROR);
  380. }
  381. }
  382. return $methods;
  383. }
  384. function _legacy_set_translation_status($args){
  385. global $sitepress_settings, $sitepress, $wpdb;
  386. try{
  387. $signature = $args[0];
  388. $site_id = $args[1];
  389. $request_id = $args[2];
  390. $original_language = $args[3];
  391. $language = $args[4];
  392. $status = $args[5];
  393. $message = $args[6];
  394. if ($site_id != $sitepress_settings['site_id']) {
  395. return 3;
  396. }
  397. //check signature
  398. $signature_chk = sha1($sitepress_settings['access_key'].$sitepress_settings['site_id'].$request_id.$language.$status.$message);
  399. if($signature_chk != $signature){
  400. return 2;
  401. }
  402. $lang_code = $sitepress->get_language_code($this->server_languages_map($language, true));//the 'reverse' language filter
  403. $cms_request_info = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}icl_core_status WHERE rid={$request_id} AND target='{$lang_code}'");
  404. if (empty($cms_request_info)){
  405. $this->_throw_exception_for_mysql_errors();
  406. return 4;
  407. }
  408. if ($this->_legacy_process_translated_document($request_id, $language, $args)){
  409. $this->_throw_exception_for_mysql_errors();
  410. return 1;
  411. } else {
  412. $this->_throw_exception_for_mysql_errors();
  413. return 6;
  414. }
  415. }catch(Exception $e) {
  416. return $e->getMessage();
  417. }
  418. }
  419. function _legacy_process_translated_document($request_id, $language, $args){
  420. global $sitepress_settings, $wpdb, $sitepress, $iclTranslationManagement;
  421. $ret = false;
  422. $iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
  423. $post_type = $wpdb->get_var($wpdb->prepare("SELECT p.post_type FROM {$wpdb->posts} p JOIN {$wpdb->prefix}icl_content_status c ON p.ID = c.nid WHERE c.rid=%d", $request_id));
  424. $trid = $wpdb->get_var($wpdb->prepare("
  425. SELECT trid
  426. FROM {$wpdb->prefix}icl_translations t
  427. JOIN {$wpdb->prefix}icl_content_status c ON t.element_id = c.nid AND t.element_type='post_{$post_type}' AND c.rid=%d",$request_id));
  428. $translation = $iclq->cms_do_download($request_id, $language);
  429. if($translation){
  430. if (icl_is_string_translation($translation)){
  431. $ret = $this->get_translated_string($args);
  432. } else {
  433. // we need to create a cms_id for this
  434. list($lang_from, $lang_to) = $wpdb->get_row($wpdb->prepare("
  435. SELECT origin, target FROM {$wpdb->prefix}icl_core_status WHERE rid=%d ORDER BY id DESC LIMIT 1
  436. ", $request_id), ARRAY_N);
  437. $translation_id = $wpdb->get_var($wpdb->prepare("
  438. SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d and language_code='%s'
  439. ", $trid, $lang_to));
  440. if(!$translation_id){
  441. $wpdb->insert($wpdb->prefix.'icl_translations', array(
  442. 'element_type' => 'post_' . $post_type,
  443. 'trid' => $trid,
  444. 'language_code' => $lang_to,
  445. 'source_language_code' => $lang_from
  446. ));
  447. $translation_id = $wpdb->insert_id;
  448. }
  449. $original_post_id = $wpdb->get_var($wpdb->prepare("SELECT element_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL", $trid));
  450. $translation_package = $iclTranslationManagement->create_translation_package($original_post_id);
  451. $md5 = $iclTranslationManagement->post_md5($original_post_id);
  452. $translator_id = $wpdb->get_var($wpdb->prepare("SELECT post_author FROM {$wpdb->posts} WHERE ID=%d", $original_post_id));
  453. // add translation_status record
  454. list($rid, $update) = $iclTranslationManagement->update_translation_status(array(
  455. 'translation_id' => $translation_id,
  456. 'status' => 2,
  457. 'translator_id' => $translator_id,
  458. 'needs_update' => 0,
  459. 'md5' => $md5,
  460. 'translation_service' => 'icanlocalize',
  461. 'translation_package' => serialize($translation_package)
  462. ));
  463. $job_ids[] = $iclTranslationManagement->add_translation_job($rid, $translator_id, $translation_package);
  464. $ret = $this->add_translated_document($translation_id, $request_id);
  465. }
  466. if($ret){
  467. $iclq->cms_update_request_status($request_id, CMS_TARGET_LANGUAGE_DONE, $language);
  468. }
  469. }
  470. return $ret;
  471. }
  472. /*
  473. * 0 - unknown error
  474. * 1 - success
  475. * 2 - signature mismatch
  476. * 3 - website_id incorrect
  477. * 4 - cms_id not found
  478. * 5 - icl translation not enabled
  479. * 6 - unknown error processing translation
  480. */
  481. function get_translated_document($args){
  482. global $sitepress_settings, $sitepress, $wpdb;
  483. try{
  484. $signature = $args[0];
  485. $site_id = $args[1];
  486. $request_id = $args[2];
  487. $cms_id = $args[3];
  488. $status = $args[4];
  489. $message = $args[5];
  490. if ($site_id != $sitepress_settings['site_id']) {
  491. return 3;
  492. }
  493. //check signature
  494. $signature_chk = sha1($sitepress_settings['access_key'].$sitepress_settings['site_id'].$cms_id.$status.$message);
  495. if($signature_chk != $signature){
  496. return 2;
  497. }
  498. // decode cms_id
  499. $int = preg_match('#(.+)_([0-9]+)_([^_]+)_([^_]+)#', $cms_id, $matches);
  500. $_element_type = $matches[1];
  501. $_element_id = $matches[2];
  502. $_original_lang = $matches[3];
  503. $_lang = $matches[4];
  504. $trid = $sitepress->get_element_trid($_element_id, 'post_'. $_element_type);
  505. if(!$trid){
  506. return 4;
  507. }
  508. $translation = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND language_code=%s", $trid, $_lang));
  509. if (empty($translation)){ // if the translation was deleted re-create it
  510. $wpdb->insert($wpdb->prefix.'icl_translations', array(
  511. 'element_type' => 'post_' . $_element_type,
  512. 'trid' => $trid,
  513. 'language_code' => $_lang,
  514. 'source_language_code' => $_original_lang
  515. ));
  516. $translation_id = $wpdb->insert_id;
  517. $md5 = $this->tmg->post_md5($_element_id);
  518. $translation_package = $this->tmg->create_translation_package($_element_id);
  519. $translator_id = 0; //TO FIX!
  520. list($rid, $update) = $this->tmg->update_translation_status(array(
  521. 'translation_id' => $translation_id,
  522. 'status' => ICL_TM_IN_PROGRESS,
  523. 'translator_id' => $translator_id,
  524. 'needs_update' => 0,
  525. 'md5' => $md5,
  526. 'translation_service' => 'icanlocalize',
  527. 'translation_package' => serialize($translation_package)
  528. ));
  529. $this->tmg->add_translation_job($rid, $translator_id, $translation_package);
  530. }else{
  531. $translation_id = $translation->translation_id;
  532. // if the post is trashed set the element_id to null
  533. if('trash' == $wpdb->get_var($wpdb->prepare("SELECT post_status FROM {$wpdb->posts} WHERE ID=%d", $translation->element_id))){
  534. $wpdb->query("UPDATE {$wpdb->prefix}icl_translations SET element_id = NULL WHERE translation_id={$translation->translation_id}");
  535. }
  536. }
  537. if ($this->add_translated_document($translation_id, $request_id) === true){
  538. $this->_throw_exception_for_mysql_errors();
  539. return 1;
  540. } else {
  541. $this->_throw_exception_for_mysql_errors();
  542. return 6;
  543. }
  544. }catch(Exception $e) {
  545. return $e->getMessage();
  546. }
  547. }
  548. function add_translated_document($translation_id, $request_id){
  549. global $sitepress_settings, $wpdb, $sitepress;
  550. $iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);
  551. $tinfo = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translations WHERE translation_id=%d", $translation_id));
  552. $_lang = $sitepress->get_language_details($tinfo->language_code);
  553. $translation = $iclq->cms_do_download($request_id, $this->server_languages_map($_lang['english_name']));
  554. $translation = apply_filters('icl_data_from_pro_translation', $translation);
  555. $ret = false;
  556. if(!empty($translation)){
  557. $language_code = $wpdb->get_var($wpdb->prepare("
  558. SELECT language_code FROM {$wpdb->prefix}icl_translations WHERE translation_id=%d", $translation_id
  559. ));
  560. $parts = explode('_', $translation['original_id']);
  561. if ($parts[0] == 'external') {
  562. // Translations are saved in the string table for 'external' types
  563. $id = array_pop($parts);
  564. unset($parts[0]);
  565. $type = implode('_', $parts);
  566. unset($translation['original_id']);
  567. foreach($translation as $field => $value){
  568. if (function_exists('icl_st_is_registered_string')) {
  569. $value = str_replace('&#0A;', "\n", $value);
  570. $string_id = icl_st_is_registered_string($type, $id . '_' . $field);
  571. if (!$string_id) {
  572. icl_register_string($type, $id . '_' . $field, $value);
  573. $string_id = icl_st_is_registered_string($type, $id . '_' . $field);
  574. }
  575. if ($string_id) {
  576. icl_add_string_translation($string_id, $language_code, $value, ICL_STRING_TRANSLATION_COMPLETE);
  577. }
  578. }
  579. }
  580. $ret = true;
  581. } else {
  582. $ret = $this->save_post_translation($translation_id, $translation);
  583. }
  584. if($ret){
  585. $lang_details = $sitepress->get_language_details($language_code);
  586. $language_server = $this->server_languages_map($lang_details['english_name']);
  587. $iclq->cms_update_request_status($request_id, CMS_TARGET_LANGUAGE_DONE, $language_server);
  588. $translations = $sitepress->get_element_translations($tinfo->trid, $tinfo->element_type);
  589. if(isset($translations[$tinfo->language_code])){
  590. $iclq->report_back_permalink($request_id, $language_server, $translations[$tinfo->language_code]);
  591. }
  592. }
  593. }
  594. return $ret;
  595. }
  596. function save_post_translation($translation_id, $translation){
  597. global $wpdb, $sitepress_settings, $sitepress, $wp_taxonomies, $icl_adjust_id_url_filter_off;
  598. $icl_adjust_id_url_filter_off = true;
  599. $taxonomies = array_diff(array_keys((array)$wp_taxonomies), array('post_tag','category'));
  600. $tinfo = $wpdb->get_row($wpdb->prepare("
  601. SELECT * FROM {$wpdb->prefix}icl_translations tr
  602. JOIN {$wpdb->prefix}icl_translation_status ts ON ts.translation_id = tr.translation_id
  603. WHERE tr.translation_id=%d", $translation_id));
  604. $lang_code = $tinfo->language_code;
  605. $trid = $tinfo->trid;
  606. $original_post_details = $wpdb->get_row("
  607. SELECT p.post_author, p.post_type, p.post_status, p.comment_status, p.ping_status, p.post_parent, p.menu_order, p.post_date, t.language_code
  608. FROM {$wpdb->prefix}icl_translations t
  609. JOIN {$wpdb->posts} p ON t.element_id = p.ID AND CONCAT('post_',p.post_type) = t.element_type
  610. WHERE trid='{$trid}' AND p.ID = '{$translation['original_id']}'
  611. ");
  612. //is the original post a sticky post?
  613. remove_filter('option_sticky_posts', array($sitepress,'option_sticky_posts')); // remove filter used to get language relevant stickies. get them all
  614. $sticky_posts = get_option('sticky_posts');
  615. $is_original_sticky = $original_post_details->post_type=='post' && in_array($translation['original_id'], $sticky_posts);
  616. $this->_content_fix_image_paths_in_body($translation);
  617. $this->_content_fix_relative_link_paths_in_body($translation);
  618. $this->_content_decode_shortcodes($translation);
  619. // deal with tags
  620. if(isset($translation['tags'])){
  621. $translated_tags = $translation['tags'];
  622. $translated_tag_ids = explode(',', $translation['tag_ids']);
  623. foreach($translated_tags as $k=>$v){
  624. $tag_trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_id='{$translated_tag_ids[$k]}' AND element_type='tax_post_tag'");
  625. // before adding the new term make sure that another tag with the same name doesn't exist. If it does append @lang
  626. // same term name exists in a different language?
  627. $term_different_language = $wpdb->get_var("
  628. SELECT tm.term_id
  629. FROM {$wpdb->term_taxonomy} tx
  630. JOIN {$wpdb->terms} tm ON tx.term_id = tm.term_id
  631. JOIN {$wpdb->prefix}icl_translations tr ON tx.term_taxonomy_id = tr.element_id
  632. WHERE tm.name='".$wpdb->escape($v)."' AND tr.element_type LIKE 'tax\\_%' AND tr.language_code <> '{$lang_code}'
  633. ");
  634. if($term_different_language){
  635. $v .= ' @'.$lang_code;
  636. }
  637. //tag exists? (in the current language)
  638. $etag = get_term_by('name', htmlspecialchars($v), 'post_tag');
  639. if(!$etag){
  640. $etag = get_term_by('name', htmlspecialchars($v) . ' @'.$lang_code, 'post_tag');
  641. }
  642. if(!$etag){
  643. $tmp = wp_insert_term($v, 'post_tag');
  644. if(!is_wp_error($tmp) && isset($tmp['term_taxonomy_id'])){
  645. $wpdb->update($wpdb->prefix.'icl_translations',
  646. array('language_code'=>$lang_code, 'trid'=>$tag_trid, 'source_language_code'=>$original_post_details->language_code),
  647. array('element_type'=>'tax_post_tag','element_id'=>$tmp['term_taxonomy_id']));
  648. }
  649. }else{
  650. $term_taxonomy_id = $etag->term_taxonomy_id;
  651. // check whether we have an orphan translation - the same trid and language but a different element id
  652. $__translation_id = $wpdb->get_var("
  653. SELECT translation_id FROM {$wpdb->prefix}icl_translations
  654. WHERE trid = '{$tag_trid}'
  655. AND language_code = '{$lang_code}'
  656. AND element_id <> '{$term_taxonomy_id}'
  657. ");
  658. if($__translation_id){
  659. $wpdb->query("DELETE FROM {$wpdb->prefix}icl_translations WHERE translation_id={$__translation_id}");
  660. }
  661. $tag_translation_id = $wpdb->get_var("SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE element_id={$term_taxonomy_id} AND element_type='tax_post_tag'");
  662. if($tag_translation_id){
  663. $wpdb->update($wpdb->prefix.'icl_translations',
  664. array('language_code'=>$lang_code, 'trid'=>$tag_trid, 'source_language_code'=>$original_post_details->language_code),
  665. array('element_type'=>'tax_post_tag','translation_id'=>$tag_translation_id));
  666. }else{
  667. $wpdb->insert($wpdb->prefix.'icl_translations',
  668. array('language_code'=>$lang_code, 'trid'=>$tag_trid, 'element_type'=>'tax_post_tag', 'element_id'=>$term_taxonomy_id, 'source_language_code'=>$original_post_details->language_code));
  669. }
  670. }
  671. }
  672. }
  673. $original_post_tags = array();
  674. foreach(wp_get_object_terms($translation['original_id'] , 'post_tag') as $t){
  675. $original_post_tags[] = $t->term_taxonomy_id;
  676. }
  677. if($original_post_tags){
  678. $tag_trids = $wpdb->get_col("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_type='tax_post_tag' AND element_id IN (".join(',',$original_post_tags).")");
  679. if(!empty($tag_trids))
  680. $tag_tr_tts = $wpdb->get_col("SELECT element_id FROM {$wpdb->prefix}icl_translations WHERE element_type='tax_post_tag' AND language_code='{$lang_code}' AND trid IN (".join(',',$tag_trids).")");
  681. if(!empty($tag_tr_tts))
  682. $translated_tags = $wpdb->get_col("SELECT t.name FROM {$wpdb->terms} t JOIN {$wpdb->term_taxonomy} tx ON tx.term_id = t.term_id WHERE tx.taxonomy='post_tag' AND tx.term_taxonomy_id IN (".join(',',$tag_tr_tts).")");
  683. }
  684. // deal with categories
  685. if(isset($translation['categories'])){
  686. $translated_cats = $translation['categories'];
  687. $translated_cats_ids = explode(',', $translation['category_ids']);
  688. foreach($translated_cats as $k=>$v){
  689. //$v = trim(str_replace('<p>', '', $v));
  690. $cat_trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_id='{$translated_cats_ids[$k]}' AND element_type='tax_category'");
  691. // before adding the new term make sure that another tag with the same name doesn't exist. If it does append @lang
  692. // same term name exists in a different language?
  693. $term_different_language = $wpdb->get_var("
  694. SELECT tm.term_id
  695. FROM {$wpdb->term_taxonomy} tx
  696. JOIN {$wpdb->terms} tm ON tx.term_id = tm.term_id
  697. JOIN {$wpdb->prefix}icl_translations tr ON tx.term_taxonomy_id = tr.element_id
  698. WHERE tm.name='".$wpdb->escape($v)."' AND tr.element_type LIKE 'tax\\_%' AND tr.language_code <> '{$lang_code}'
  699. ");
  700. if($term_different_language){
  701. $v .= ' @'.$lang_code;
  702. }
  703. //cat exists?
  704. $ecat = get_term_by('name', htmlspecialchars($v), 'category');
  705. if(!$ecat){
  706. $ecat = get_term_by('name', htmlspecialchars($v) . ' @'.$lang_code, 'category');
  707. }
  708. if(!$ecat){
  709. // get original category parent id
  710. $original_category_parent_id = $wpdb->get_var($wpdb->prepare("SELECT parent FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id=%d",$translated_cats_ids[$k]));
  711. if($original_category_parent_id){
  712. $_op_tax_id = $wpdb->get_var($wpdb->prepare("SELECT term_taxonomy_id FROM {$wpdb->term_taxonomy} WHERE taxonomy='category' AND term_id=%d",$original_category_parent_id));
  713. $_op_trid = $wpdb->get_var($wpdb->prepare("SELECT trid FROM {$wpdb->prefix}icl_translations WHERE element_type='tax_category' AND element_id=%d",$_op_tax_id));
  714. // get id of the translated category parent
  715. $_tp_tax_id = $wpdb->get_var($wpdb->prepare("SELECT element_id FROM {$wpdb->prefix}icl_translations WHERE language_code='{$lang_code}' AND trid=%d",$_op_trid));
  716. if($_tp_tax_id){
  717. $category_parent_id = $wpdb->get_var($wpdb->prepare("SELECT term_id FROM {$wpdb->term_taxonomy} WHERE taxonomy='category' AND term_taxonomy_id=%d",$_tp_tax_id));
  718. }else{
  719. $category_parent_id = 0;
  720. }
  721. }else{
  722. $category_parent_id = 0;
  723. }
  724. $tmp = wp_insert_term($v, 'category', array('parent'=>$category_parent_id));
  725. if(!is_wp_error($tmp) && isset($tmp['term_taxonomy_id'])){
  726. $wpdb->update($wpdb->prefix.'icl_translations',
  727. array('language_code'=>$lang_code, 'trid'=>$cat_trid, 'source_language_code'=>$original_post_details->language_code),
  728. array('element_type'=>'tax_category','element_id'=>$tmp['term_taxonomy_id']));
  729. // if this is a parent category, make sure that nesting is correct for all translations
  730. $orig_cat_tax_id = $wpdb->get_var($wpdb->prepare("SELECT element_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL", $cat_trid));
  731. $orig_cat_term_id = $wpdb->get_var($wpdb->prepare("SELECT term_id FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id=%d AND taxonomy='category'",$orig_cat_tax_id));
  732. $orig_cat_children = $wpdb->get_col($wpdb->prepare("SELECT term_id FROM {$wpdb->term_taxonomy} WHERE parent=%d",$orig_cat_term_id));
  733. if(!empty($orig_cat_children)) foreach($orig_cat_children as $ch){
  734. $_tr_child = icl_object_id($ch, 'category', false, $lang_code);
  735. if($_tr_child){
  736. $wpdb->update($wpdb->term_taxonomy, array('parent'=>$tmp['term_id']), array(
  737. 'taxonomy'=>'category', 'term_id' => $_tr_child
  738. ));
  739. }
  740. }
  741. delete_option('category_children');
  742. }
  743. }else{
  744. $term_taxonomy_id = $ecat->term_taxonomy_id;
  745. // check whether we have an orphan translation - the same trid and language but a different element id
  746. $__translation_id = $wpdb->get_var("
  747. SELECT translation_id FROM {$wpdb->prefix}icl_translations
  748. WHERE trid = '{$cat_trid}'
  749. AND language_code = '{$lang_code}'
  750. AND element_id <> '{$term_taxonomy_id}'
  751. ");
  752. if($__translation_id){
  753. $wpdb->query("DELETE FROM {$wpdb->prefix}icl_translations WHERE translation_id={$__translation_id}");
  754. }
  755. $cat_translation_id = $wpdb->get_var("SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE element_id={$term_taxonomy_id} AND element_type='tax_category'");

Large files files are truncated, but you can click here to view the full file