PageRenderTime 45ms CodeModel.GetById 19ms RepoModel.GetById 1ms app.codeStats 0ms

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

https://bitbucket.org/acipriani/madeinapulia.com
PHP | 4216 lines | 3263 code | 643 blank | 310 comment | 770 complexity | d801fb1245a37a064a7a36afd3c95f6a MD5 | raw file
Possible License(s): GPL-3.0, MIT, BSD-3-Clause, LGPL-2.1, GPL-2.0, Apache-2.0 
    

  1. <?php
    2. 

  2. define ( 'ICL_TM_NOT_TRANSLATED', 0);
    3. 

  3. define ( 'ICL_TM_WAITING_FOR_TRANSLATOR', 1);
    4. 

  4. define ( 'ICL_TM_IN_PROGRESS', 2);
    5. 

  5. define ( 'ICL_TM_NEEDS_UPDATE', 3);  //virt. status code (based on needs_update)
    6. 

  6. define ( 'ICL_TM_DUPLICATE', 9);
    7. 

  7. define ( 'ICL_TM_COMPLETE', 10);
    8. 

  8. 

  9. define('ICL_TM_NOTIFICATION_NONE', 0);
    10. 

  10. define('ICL_TM_NOTIFICATION_IMMEDIATELY', 1);
    11. 

  11. define('ICL_TM_NOTIFICATION_DAILY', 2);
    12. 

  12. 

  13. define('ICL_TM_TMETHOD_MANUAL', 0);
    14. 

  14. define('ICL_TM_TMETHOD_EDITOR', 1);
    15. 

  15. define('ICL_TM_TMETHOD_PRO', 2);
    16. 

  16. 

  17. define('ICL_TM_DOCS_PER_PAGE', 20);
    18. 

  18. 

  19. $asian_languages = array('ja', 'ko', 'zh-hans', 'zh-hant', 'mn', 'ne', 'hi', 'pa', 'ta', 'th');
    20. 

  20. 

  21. if(!class_exists('WPML_Config')) {
    22. 

  22. 	require ICL_PLUGIN_PATH . '/inc/wpml-config/wpml-config.class.php';
    23. 

  23. }
    24. 

  24. 

  25. class TranslationManagement{
    26. 

  26. 

  27. 	private $selected_translator = array('ID'=>0);
    28. 

  28. 	private $current_translator = array('ID'=>0);
    29. 

  29. 	public $messages = array();
    30. 

  30. 	public $dashboard_select = array();
    31. 

  31. 	public $settings;
    32. 

  32. 	public $admin_texts_to_translate = array();
    33. 

  33. 

  34. 	function __construct(){
    35. 

  35. 		add_action('init', array($this, 'init'), 1500);
    36. 

  36. 

  37. 		if(isset($_GET['icl_tm_message'])){
    38. 

  38. 			$this->messages[] = array(
    39. 

  39. 				'type' => isset($_GET['icl_tm_message_type']) ? $_GET['icl_tm_message_type'] : 'updated',
    40. 

  40. 				'text'  => $_GET['icl_tm_message']
    41. 

  41. 			);
    42. 

  42. 		}
    43. 

  43. 

  44. 		add_action('save_post', array($this, 'save_post_actions'), 110, 2); // calling *after* the Sitepress actions
    45. 

  45. 

  46. 		add_action('delete_post', array($this, 'delete_post_actions'), 1, 1); // calling *before* the Sitepress actions
    47. 

  47. 

  48. 		//add_action('edit_term',  array($this, 'edit_term'),11, 2); // calling *after* the Sitepress actions
    49. 

  49. 

  50. 		add_action('icl_ajx_custom_call', array($this, 'ajax_calls'), 10, 2);
    51. 

  51. 		add_action('wp_ajax_show_post_content', array($this, '_show_post_content'));
    52. 

  52. 

  53. 		if(isset($_GET['sm']) && ($_GET['sm'] == 'dashboard' || $_GET['sm'] == 'jobs')){@session_start();}
    54. 

  54. 		elseif(isset($_GET['page']) && preg_match('@/menu/translations-queue\.php$@', $_GET['page'])){@session_start();}
    55. 

  55. 		add_filter('icl_additional_translators', array($this, 'icl_additional_translators'), 99, 3);
    56. 

  56. 

  57. 		add_filter('icl_translators_list', array(__CLASS__, 'icanlocalize_translators_list'));
    58. 

  58. 

  59. 		add_action('user_register', array($this, 'clear_cache'));
    60. 

  60. 		add_action('profile_update', array($this, 'clear_cache'));
    61. 

  61. 		add_action('delete_user', array($this, 'clear_cache'));
    62. 

  62. 		add_action('added_existing_user', array($this, 'clear_cache'));
    63. 

  63. 		add_action('remove_user_from_blog', array($this, 'clear_cache'));
    64. 

  64. 

  65. 		add_action('admin_print_scripts', array($this, '_inline_js_scripts'));
    66. 

  66. 

  67. 		add_action('wp_ajax_icl_tm_user_search', array($this, '_user_search'));
    68. 

  68. 

  69. 		add_action('wp_ajax_icl_tm_abort_translation', array($this, 'abort_translation'));
    70. 

  70. 

  71. 	}
    72. 

  72. 

  73. 	function save_settings()
    74. 

  74. 	{
    75. 

  75. 		global $sitepress, $sitepress_settings;
    76. 

  76. 

  77. 		$iclsettings[ 'translation-management' ] = $this->settings;
    78. 

  78. 		$custom_posts_sync_option                = isset( $sitepress_settings[ 'custom_posts_sync_option' ] ) ? $sitepress_settings[ 'custom_posts_sync_option' ] : false;
    79. 

  79. 

  80. 		if ( is_array( $custom_posts_sync_option ) ) {
    81. 

  81. 			foreach ( $custom_posts_sync_option as $k => $v ) {
    82. 

  82. 				$iclsettings[ 'custom_posts_sync_option' ][ $k ] = $v;
    83. 

  83. 			}
    84. 

  84. 		}
    85. 

  85. 		$sitepress->save_settings( $iclsettings );
    86. 

  86. 	}
    87. 

  87. 

  88. 	function init(){
    89. 

  89. 

  90. 		global $wpdb, $current_user, $sitepress_settings, $sitepress;
    91. 

  91. 

  92. 		$this->settings =& $sitepress_settings['translation-management'];
    93. 

  93. 

  94. 		//logic for syncing comments
    95. 

  95. 		if($sitepress->get_option('sync_comments_on_duplicates')){
    96. 

  96. 			add_action('delete_comment', array($this, 'duplication_delete_comment'));
    97. 

  97. 			add_action('edit_comment', array($this, 'duplication_edit_comment'));
    98. 

  98. 			add_action('wp_set_comment_status', array($this, 'duplication_status_comment'), 10, 2);
    99. 

  99. 			add_action('wp_insert_comment', array($this, 'duplication_insert_comment'), 100);
    100. 

  100. 		}
    101. 

  101. 

  102. 		$this->initial_custom_field_translate_states();
    103. 

  103. 

  104. 		// defaults
    105. 

  105. 		if(!isset($this->settings['notification']['new-job'])) $this->settings['notification']['new-job'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
    106. 

  106. 		if(!isset($this->settings['notification']['completed'])) $this->settings['notification']['completed'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
    107. 

  107. 		if(!isset($this->settings['notification']['resigned'])) $this->settings['notification']['resigned'] = ICL_TM_NOTIFICATION_IMMEDIATELY;
    108. 

  108. 		if(!isset($this->settings['notification']['dashboard'])) $this->settings['notification']['dashboard'] = true;
    109. 

  109. 		if(!isset($this->settings['notification']['purge-old'])) $this->settings['notification']['purge-old'] = 7;
    110. 

  110. 

  111. 		if(!isset($this->settings['custom_fields_translation'])) $this->settings['custom_fields_translation'] = array();
    112. 

  112. 		if(!isset($this->settings['doc_translation_method'])) $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
    113. 

  113. 

  114. 		get_currentuserinfo();
    115. 

  115. 		$user = false;
    116. 

  116. 		if(isset($current_user->ID)){
    117. 

  117. 			$user = new WP_User($current_user->ID);
    118. 

  118. 		}
    119. 

  119. 

  120. 		if(!$user || empty($user->data)) return;
    121. 

  121. 

  122. 		$ct['translator_id'] =  $current_user->ID;
    123. 

  123. 		$ct['display_name'] =  isset($user->data->display_name) ? $user->data->display_name : $user->data->user_login;
    124. 

  124. 		$ct['user_login'] =  $user->data->user_login;
    125. 

  125. 		$ct['language_pairs'] = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);
    126. 

  126. 		if(empty($ct['language_pairs'])) $ct['language_pairs'] = array();
    127. 

  127. 

  128. 		$this->current_translator = (object)$ct;
    129. 

  129. 

  130. 		WPML_Config::load_config();
    131. 

  131. 

  132. 		if(isset($_POST['icl_tm_action'])){
    133. 

  133. 			$this->process_request($_POST['icl_tm_action'], $_POST);
    134. 

  134. 		}elseif(isset($_GET['icl_tm_action'])){
    135. 

  135. 			$this->process_request($_GET['icl_tm_action'], $_GET);
    136. 

  136. 		}
    137. 

  137. 

  138. 		if($GLOBALS['pagenow']=='edit.php'){ // use standard WP admin notices
    139. 

  139. 			add_action('admin_notices', array($this, 'show_messages'));
    140. 

  140. 		}else{                               // use custom WP admin notices
    141. 

  141. 			add_action('icl_tm_messages', array($this, 'show_messages'));
    142. 

  142. 		}
    143. 

  143. 

  144. 		if(isset($_GET['page']) && basename($_GET['page']) == 'translations-queue.php' && isset($_GET['job_id'])){
    145. 

  145. 			add_filter('admin_head',array($this, '_show_tinyMCE'));
    146. 

  146. 		}
    147. 

  147. 

  148. 

  149. 		//if(!isset($this->settings['doc_translation_method'])){
    150. 

  150. 		if(isset($this->settings['doc_translation_method']) && $this->settings['doc_translation_method'] < 0 ){
    151. 

  151. 			if(isset($_GET['sm']) && $_GET['sm']=='mcsetup' && isset($_GET['src']) && $_GET['src']=='notice'){
    152. 

  152. 						$this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
    153. 

  153. 						$this->save_settings();
    154. 

  154. 			}else{
    155. 

  155. 				add_action('admin_notices', array($this, '_translation_method_notice'));
    156. 

  156. 			}
    157. 

  157. 		}
    158. 

  158. 

  159. 		if(defined('WPML_TM_VERSION') && isset($_GET['page']) && $_GET['page'] == WPML_TM_FOLDER. '/menu/main.php' && isset($_GET['sm']) && $_GET['sm'] == 'translators'){
    160. 

  160. 			$iclsettings =& $sitepress_settings;
    161. 

  161. 			$sitepress->get_icl_translator_status($iclsettings);
    162. 

  162. 			$sitepress->save_settings($iclsettings);
    163. 

  163. 		}
    164. 

  164. 

  165. 		// default settings
    166. 

  166. 		if(empty($this->settings['doc_translation_method']) || !defined('WPML_TM_VERSION')){
    167. 

  167. 			$this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
    168. 

  168. 		}
    169. 

  169. 	}
    170. 

  170. 

  171. 	function initial_custom_field_translate_states() {
    172. 

  172. 		global $wpdb;
    173. 

  173. 

  174. 		$cf_keys_limit = 1000; // jic
    175. 

  175. 		$custom_keys = $wpdb->get_col( "
    176. 

  176. 			SELECT meta_key
    177. 

  177. 			FROM $wpdb->postmeta
    178. 

  178. 			GROUP BY meta_key
    179. 

  179. 			ORDER BY meta_key
    180. 

  180. 			LIMIT $cf_keys_limit" );
    181. 

    182. 

  182. 		$changed = false;
    183. 

  183. 

  184. 		foreach($custom_keys as $cfield) {
    185. 

  185. 			if(empty($this->settings['custom_fields_translation'][$cfield]) || $this->settings['custom_fields_translation'][$cfield] == 0) {
    186. 

  186. 				// see if a plugin handles this field
    187. 

  187. 				$override = apply_filters('icl_cf_translate_state', 'nothing', $cfield);
    188. 

  188. 				switch($override) {
    189. 

  189. 					case 'nothing':
    190. 

  190. 						break;
    191. 

  191. 

  192. 					case 'ignore':
    193. 

  193. 						$changed = true;
    194. 

  194. 						$this->settings['custom_fields_translation'][$cfield] = 3;
    195. 

  195. 						break;
    196. 

  196. 

  197. 					case 'translate':
    198. 

  198. 						$changed = true;
    199. 

  199. 						$this->settings['custom_fields_translation'][$cfield] = 2;
    200. 

  200. 						break;
    201. 

  201. 

  202. 					case 'copy':
    203. 

  203. 						$changed = true;
    204. 

  204. 						$this->settings['custom_fields_translation'][$cfield] = 1;
    205. 

  205. 						break;
    206. 

  206. 				}
    207. 

  207. 

  208. 			}
    209. 

  209. 		}
    210. 

  210. 		if ($changed) {
    211. 

  211. 			$this->save_settings();
    212. 

  212. 		}
    213. 

  213. 	}
    214. 

  214. 

  215. 	function _translation_method_notice(){
    216. 

  216. 		echo '<div class="error fade"><p id="icl_side_by_site">'.sprintf(__('New - side-by-site translation editor: <a href="%s">try it</a> | <a href="#cancel">no thanks</a>.', 'sitepress'),
    217. 

  217. 				admin_url('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=mcsetup&src=notice')) . '</p></div>';
    218. 

  218. 	}
    219. 

  219. 

  220. 	function _show_tinyMCE() {
    221. 

  221. 		wp_print_scripts('editor');
    222. 

  222. 		//add_filter('the_editor', array($this, 'editor_directionality'), 9999);
    223. 

  223. 		add_filter('tiny_mce_before_init', array($this, '_mce_set_direction'), 9999);
    224. 

  224. 		add_filter('mce_buttons', array($this, '_mce_remove_fullscreen'), 9999);
    225. 

  225. 

  226. 		if (version_compare($GLOBALS['wp_version'], '3.1.4', '<=') && function_exists('wp_tiny_mce'))
    227. 

  227. 		try{
    228. 

  228. 			/** @noinspection PhpDeprecationInspection */
    229. 

  229. 			@wp_tiny_mce();
    230. 

  230. 		} catch(Exception $e) {  /*don't do anything with this */ }
    231. 

  231. 	}
    232. 

  232. 

  233. 	function _mce_remove_fullscreen($options){
    234. 

  234. 		foreach($options as $k=>$v) if($v == 'fullscreen') unset($options[$k]);
    235. 

  235. 		return $options;
    236. 

  236. 	}
    237. 

  237. 

  238. 	function _inline_js_scripts(){
    239. 

  239. 		// remove fullscreen mode
    240. 

  240. 		if(defined('WPML_TM_FOLDER') && isset($_GET['page']) && $_GET['page'] == WPML_TM_FOLDER . '/menu/translations-queue.php' && isset($_GET['job_id'])){
    241. 

  241. 			?>
    242. 

  242. 			<script type="text/javascript">addLoadEvent(function(){jQuery('#ed_fullscreen').remove();});</script>
    243. 

  243. 			<?php
    244. 

  244. 		}
    245. 

  245. 	}
    246. 

  246. 

  247. 

  248. 	function _mce_set_direction($settings) {
    249. 

  249. 		$job = $this->get_translation_job((int)$_GET['job_id'], false, true);
    250. 

  250. 		if (!empty($job)) {
    251. 

  251. 			$rtl_translation = in_array($job->language_code, array('ar','he','fa'));
    252. 

  252. 			if ($rtl_translation) {
    253. 

  253. 				$settings['directionality'] = 'rtl';
    254. 

  254. 			} else {
    255. 

  255. 				$settings['directionality'] = 'ltr';
    256. 

  256. 			}
    257. 

  257. 		}
    258. 

  258. 		return $settings;
    259. 

  259. 	}
    260. 

  260. 

  261. 	/*
    262. 

  262. 	function editor_directionality($tag) {
    263. 

  263. 		$job = $this->get_translation_job((int)$_GET['job_id'], false, true);
    264. 

  264. 		$rtl_translation = in_array($job->language_code, array('ar','he','fa'));
    265. 

  265. 		if ($rtl_translation) {
    266. 

  266. 			$dir = 'dir="rtl"';
    267. 

  267. 		} else {
    268. 

  268. 			$dir = 'dir="ltr"';
    269. 

  269. 		}
    270. 

  270. 		return str_replace('<textarea', '<textarea ' . $dir, $tag);
    271. 

  271. 	}
    272. 

  272. 	*/
    273. 

  273. 

  274. 	function process_request($action, $data){
    275. 

  275. 		$data = stripslashes_deep($data);
    276. 

  276. 		switch($action){
    277. 

  277. 			case 'add_translator':
    278. 

  278. 				if(wp_create_nonce('add_translator') == $data['add_translator_nonce']){
    279. 

  279. 					// Initial adding
    280. 

  280. 					if (isset($data['from_lang']) && isset($data['to_lang'])) {
    281. 

  281. 					  $data['lang_pairs'] = array();
    282. 

  282. 					  $data['lang_pairs'][$data['from_lang']] = array($data['to_lang'] => 1);
    283. 

  283. 					}
    284. 

  284. 					$this->add_translator($data['user_id'], $data['lang_pairs']);
    285. 

  285. 					$_user = new WP_User($data['user_id']);
    286. 

  286. 					wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('%s has been added as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');
    287. 

  287. 				}
    288. 

  288. 				break;
    289. 

  289. 			case 'edit_translator':
    290. 

  290. 				if(wp_create_nonce('edit_translator') == $data['edit_translator_nonce']){
    291. 

  291. 					$this->edit_translator($data['user_id'], isset($data['lang_pairs']) ? $data['lang_pairs'] : array());
    292. 

  292. 					$_user = new WP_User($data['user_id']);
    293. 

  293. 					wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('Language pairs for %s have been edited.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');
    294. 

  294. 				}
    295. 

  295. 				break;
    296. 

  296. 			case 'remove_translator':
    297. 

  297. 				if(wp_create_nonce('remove_translator') == $data['remove_translator_nonce']){
    298. 

  298. 					$this->remove_translator($data['user_id']);
    299. 

  299. 					$_user = new WP_User($data['user_id']);
    300. 

  300. 					wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.urlencode(sprintf(__('%s has been removed as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated');
    301. 

  301. 				}
    302. 

  302. 				break;
    303. 

  303. 			case 'edit':
    304. 

  304. 				$this->selected_translator['ID'] = intval($data['user_id']);
    305. 

  305. 				break;
    306. 

  306. 			case 'dashboard_filter':
    307. 

  307. 				$_SESSION['translation_dashboard_filter'] = $data['filter'];
    308. 

  308. 				wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/main.php&sm=dashboard');
    309. 

  309. 				break;
    310. 

  310. 		   case 'sort':
    311. 

  311. 				if(isset($data['sort_by'])) $_SESSION['translation_dashboard_filter']['sort_by'] = $data['sort_by'];
    312. 

  312. 				if(isset($data['sort_order'])) $_SESSION['translation_dashboard_filter']['sort_order'] = $data['sort_order'];
    313. 

  313. 				break;
    314. 

  314. 		   case 'reset_filters':
    315. 

  315. 				unset($_SESSION['translation_dashboard_filter']);
    316. 

  316. 				break;
    317. 

  317. 		   case 'send_jobs':
    318. 

  318. 				if(isset($data['iclnonce']) && wp_verify_nonce($data['iclnonce'], 'pro-translation-icl')){
    319. 

  319. 					$this->send_jobs($data);
    320. 

  320. 				}
    321. 

  321. 				break;
    322. 

  322. 		   case 'jobs_filter':
    323. 

  323. 				$_SESSION['translation_jobs_filter'] = $data['filter'];
    324. 

  324. 				wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/main.php&sm=jobs');
    325. 

  325. 				break;
    326. 

  326. 		   case 'ujobs_filter':
    327. 

  327. 				$_SESSION['translation_ujobs_filter'] = $data['filter'];
    328. 

  328. 				wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/translations-queue.php');
    329. 

  329. 				break;
    330. 

  330. 		   case 'save_translation':
    331. 

  331. 				if(!empty($data['resign'])){
    332. 

  332. 					$this->resign_translator($data['job_id']);
    333. 

  333. 					wp_redirect(admin_url('admin.php?page='.WPML_TM_FOLDER.'/menu/translations-queue.php&resigned='.$data['job_id']));
    334. 

  334. 					exit;
    335. 

  335. 				}else{
    336. 

  336. 					$this->save_translation($data);
    337. 

  337. 				}
    338. 

  338. 				break;
    339. 

  339. 		   case 'save_notification_settings':
    340. 

  340. 				$this->settings['notification'] = $data['notification'];
    341. 

  341. 				$this->save_settings();
    342. 

  342. 				$this->messages[] = array(
    343. 

  343. 					'type'=>'updated',
    344. 

  344. 					'text' => __('Preferences saved.', 'sitepress')
    345. 

  345. 				);
    346. 

  346. 				break;
    347. 

  347. 		   case 'create_job':
    348. 

  348. 				global $current_user;
    349. 

  349. 				if(!isset($this->current_translator->ID) && isset($current_user->ID)){
    350. 

  350. 					$this->current_translator->ID  = $current_user->ID;
    351. 

  351. 				}
    352. 

  352. 				$data['translator'] = $this->current_translator->ID;
    353. 

  353. 

  354. 				$job_ids = $this->send_jobs($data);
    355. 

  355. 				wp_redirect('admin.php?page='.WPML_TM_FOLDER . '/menu/translations-queue.php&job_id=' . array_pop($job_ids));
    356. 

  356. 				break;
    357. 

  357. 		   case 'cancel_jobs':
    358. 

  358. 				$ret = $this->cancel_translation_request($data['icl_translation_id']);
    359. 

  359. 				$this->messages[] = array(
    360. 

  360. 					'type'=>'updated',
    361. 

  361. 					'text' => __('Translation requests cancelled.', 'sitepress')
    362. 

  362. 				);
    363. 

  363. 				break;
    364. 

  364. 		}
    365. 

  365. 	}
    366. 

  366. 

  367. 	function ajax_calls( $call, $data ) {
    368. 

  368. 		global $wpdb, $sitepress, $sitepress_settings;
    369. 

  369. 		switch ( $call ) {
    370. 

  370. 			/*
    371. 

  371. 			case 'save_dashboard_setting':
    372. 

  372. 					$iclsettings['dashboard'] = $sitepress_settings['dashboard'];
    373. 

  373. 					if(isset($data['setting']) && isset($data['value'])){
    374. 

  374. 							$iclsettings['dashboard'][$data['setting']] = $data['value'];
    375. 

  375. 							$sitepress->save_settings($iclsettings);
    376. 

  376. 					}
    377. 

  377. 					break;
    378. 

  378. 			*/
    379. 

  379. 			case 'assign_translator':
    380. 

  380. 

  381. 				$_exp          = explode( '-', $data[ 'translator_id' ] );
    382. 

  382. 				$service       = isset( $_exp[ 1 ] ) ? $_exp[ 1 ] : 'local';
    383. 

  383. 				$translator_id = $_exp[ 0 ];
    384. 

  384. 				if ( $this->assign_translation_job( $data[ 'job_id' ], $translator_id, $service ) ) {
    385. 

  385. 					if ( $service == 'icanlocalize' ) {
    386. 

  386. 						$job = $this->get_translation_job( $data[ 'job_id' ] );
    387. 

  387. 						global $ICL_Pro_Translation;
    388. 

  388. 						$ICL_Pro_Translation->send_post( $job->original_doc_id, array( $job->language_code ), $translator_id );
    389. 

  389. 						$lang_tr_id = false;
    390. 

  390. 						$contract_id = false;
    391. 

  391. 						foreach ( $sitepress_settings[ 'icl_lang_status' ] as $lp ) {
    392. 

  392. 							if ( $lp[ 'from' ] == $job->source_language_code && $lp[ 'to' ] == $job->language_code ) {
    393. 

  393. 								$contract_id = $lp[ 'contract_id' ];
    394. 

  394. 								$lang_tr_id  = $lp[ 'id' ];
    395. 

  395. 								break;
    396. 

  396. 							}
    397. 

  397. 						}
    398. 

  398. 						$popup_link = ICL_API_ENDPOINT . '/websites/' . $sitepress_settings[ 'site_id' ] . '/website_translation_offers/' . $lang_tr_id . '/website_translation_contracts/' . $contract_id;
    399. 

  399. 						$popup_args = array(
    400. 

  400. 								'title'     => __( 'Chat with translator', 'sitepress' ),
    401. 

  401. 								'unload_cb' => 'icl_thickbox_refresh'
    402. 

  402. 						);
    403. 

  403. 						$translator_edit_link = $sitepress->create_icl_popup_link( $popup_link, $popup_args );
    404. 

  404. 						$translator_edit_link .= esc_html( ICL_Pro_Translation::get_translator_name( $translator_id ) );
    405. 

  405. 						$translator_edit_link .= '</a> (ICanLocalize)';
    406. 

  406. 

  407. 					} else {
    408. 

  408. 						$translator_edit_link =
    409. 

  409. 								'<a href="' . $this->get_translator_edit_url( $data[ 'translator_id' ] ) . '">' . esc_html( $wpdb->get_var( $wpdb->prepare( "SELECT display_name FROM {$wpdb->users} WHERE ID=%d", $data[ 'translator_id' ] ) ) ) . '</a>';
    410. 

  410. 					}
    411. 

  411. 					echo json_encode( array( 'error' => 0, 'message' => $translator_edit_link, 'status' => $this->status2text( ICL_TM_WAITING_FOR_TRANSLATOR ), 'service' => $service ) );
    412. 

  412. 				} else {
    413. 

  413. 					echo json_encode( array( 'error' => 1 ) );
    414. 

  414. 				}
    415. 

  415. 				break;
    416. 

  416. 			case 'icl_cf_translation':
    417. 

  417. 				if ( !empty( $data[ 'cf' ] ) ) {
    418. 

  418. 					foreach ( $data[ 'cf' ] as $k => $v ) {
    419. 

  419. 						$cft[ base64_decode( $k ) ] = $v;
    420. 

  420. 					}
    421. 

  421. 					if ( isset( $cft ) ) {
    422. 

  422. 						$this->settings['custom_fields_translation'] = $cft;
    423. 

  423. 						$this->save_settings();
    424. 

  424. 					}
    425. 

  425. 

  426. 				}
    427. 

  427. 				echo '1|';
    428. 

  428. 				break;
    429. 

  429. 			case 'icl_doc_translation_method':
    430. 

  430. 				$this->settings['doc_translation_method'] = intval($data['t_method']);
    431. 

  431. 				$sitepress->set_setting( 'hide_how_to_translate', empty( $data[ 'how_to_translate' ] ) );
    432. 

  432. 				if (isset($data[ 'tm_block_retranslating_terms' ])) {
    433. 

  433. 					$sitepress->set_setting( 'tm_block_retranslating_terms', $data[ 'tm_block_retranslating_terms' ] );
    434. 

  434. 				} else {
    435. 

  435. 					$sitepress->set_setting( 'tm_block_retranslating_terms', '' );
    436. 

  436. 				}
    437. 

  437. 				$this->save_settings();
    438. 

  438. 				echo '1|';
    439. 

  439. 				break;
    440. 

  440. 			case 'reset_duplication':
    441. 

  441. 				$this->reset_duplicate_flag( $_POST[ 'post_id' ] );
    442. 

  442. 				break;
    443. 

  443. 			case 'set_duplication':
    444. 

  444. 				$this->set_duplicate( $_POST[ 'post_id' ] );
    445. 

  445. 				break;
    446. 

  446. 			case 'make_duplicates':
    447. 

  447. 				$mdata[ 'iclpost' ] = array( $data[ 'post_id' ] );
    448. 

  448. 				$langs              = explode( ',', $data[ 'langs' ] );
    449. 

  449. 				foreach ( $langs as $lang ) {
    450. 

  450. 					$mdata[ 'duplicate_to' ][ $lang ] = 1;
    451. 

  451. 				}
    452. 

  452. 				$this->make_duplicates( $mdata );
    453. 

  453. 				break;
    454. 

  454. 		}
    455. 

  455. 	}
    456. 

  456. 

  457. 	function show_messages(){
    458. 

  458. 		if(!empty($this->messages)){
    459. 

  459. 			foreach($this->messages as $m){
    460. 

  460. 				echo '<div class="'.$m['type'].' below-h2"><p>' . $m['text'] . '</p></div>';
    461. 

  461. 			}
    462. 

  462. 		}
    463. 

  463. 	}
    464. 

  464. 

  465. 	/* TRANSLATORS */
    466. 

  466. 	/* ******************************************************************************************** */
    467. 

  467. 	function add_translator($user_id, $language_pairs){
    468. 

  468. 		global $wpdb;
    469. 

  469. 

  470. 		$user = new WP_User($user_id);
    471. 

  471. 		$user->add_cap('translate');
    472. 

  472. 

  473. 		$um = get_user_meta($user_id, $wpdb->prefix . 'language_pairs', true);
    474. 

  474. 		if(!empty($um)){
    475. 

  475. 			foreach($um as $fr=>$to){
    476. 

  476. 				if(isset($language_pairs[$fr])){
    477. 

  477. 					$language_pairs[$fr] = array_merge($language_pairs[$fr], $to);
    478. 

  478. 				}
    479. 

  479. 

  480. 			}
    481. 

  481. 		}
    482. 

  482. 

  483. 		update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);
    484. 

  484. 		$this->clear_cache();
    485. 

  485. 	}
    486. 

  486. 

  487. 	function edit_translator($user_id, $language_pairs){
    488. 

  488. 		global $wpdb;
    489. 

  489. 		$_user = new WP_User($user_id);
    490. 

  490. 		if(empty($language_pairs)){
    491. 

  491. 			$this->remove_translator($user_id);
    492. 

  492. 			wp_redirect('admin.php?page='.WPML_TM_FOLDER.'/menu/main.php&sm=translators&icl_tm_message='.
    493. 

  493. 				urlencode(sprintf(__('%s has been removed as a translator for this site.','sitepress'),$_user->data->display_name)).'&icl_tm_message_type=updated'); exit;
    494. 

  494. 		}
    495. 

  495. 		else{
    496. 

  496. 			if(!$_user->has_cap('translate')) $_user->add_cap('translate');
    497. 

  497. 			update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);
    498. 

  498. 		}
    499. 

  499. 	}
    500. 

  500. 

  501. 	function remove_translator($user_id){
    502. 

  502. 		global $wpdb;
    503. 

  503. 		$user = new WP_User($user_id);
    504. 

  504. 		$user->remove_cap('translate');
    505. 

  505. 		delete_user_meta($user_id, $wpdb->prefix . 'language_pairs');
    506. 

  506. 		$this->clear_cache();
    507. 

  507. 	}
    508. 

  508. 

  509. 	function is_translator( $user_id, $args = array() )
    510. 

  510. 	{
    511. 

  511. 		extract( $args, EXTR_OVERWRITE );
    512. 

  512. 

  513. 		global $wpdb;
    514. 

  514. 		$user = new WP_User( $user_id );
    515. 

  515. 

  516. 		$is_translator = $user->has_cap( 'translate' );
    517. 

  517. 

  518. 		// check if user is administrator and return true if he is
    519. 

  519. 		$user_caps = $user->caps;
    520. 

  520. 		if ( isset( $user_caps[ 'activate_plugins' ] ) && $user_caps[ 'activate_plugins' ] == true ) {
    521. 

  521. 			$is_translator = true;
    522. 

  522. 		} else {
    523. 

  523. 

  524. 			if ( isset( $lang_from ) && isset( $lang_to ) ) {
    525. 

  525. 				$um            = get_user_meta( $user_id, $wpdb->prefix . 'language_pairs', true );
    526. 

  526. 				$is_translator = $is_translator && isset( $um[ $lang_from ] ) && isset( $um[ $lang_from ][ $lang_to ] ) && $um[ $lang_from ][ $lang_to ];
    527. 

  527. 			}
    528. 

  528. 			if ( isset( $job_id ) ) {
    529. 

  529. 				$translator_id = $wpdb->get_var( $wpdb->prepare( "
    530. 

  530. 							SELECT j.translator_id
    531. 

  531. 								FROM {$wpdb->prefix}icl_translate_job j
    532. 

  532. 								JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    533. 

  533. 							WHERE job_id = %d AND s.translation_service='local'
    534. 

  534. 						", $job_id ) );
    535. 

    536. 

  536. 				$is_translator = $is_translator && ( ( $translator_id == $user_id ) || empty( $translator_id ) );
    537. 

  537. 			}
    538. 

  538. 

  539. 		}
    540. 

  540. 

  541. 		return $is_translator;
    542. 

  542. 	}
    543. 

  543. 

  544. 	function translator_exists($id, $from, $to, $type = 'local'){
    545. 

  545. 		global $sitepress_settings;
    546. 

  546. 		$exists = false;
    547. 

  547. 		if($type == 'icanlocalize' && !empty($sitepress_settings['icl_lang_status'])){
    548. 

  548. 			foreach($sitepress_settings['icl_lang_status'] as $lpair){
    549. 

  549. 				if($lpair['from'] == $from && $lpair['to'] == $to){
    550. 

  550. 					if(!empty($lpair['translators'])){
    551. 

  551. 						foreach($lpair['translators'] as $t){
    552. 

  552. 							if($t['id'] == $id){
    553. 

  553. 								$exists = true;
    554. 

  554. 								break(2);
    555. 

  555. 							}
    556. 

  556. 						}
    557. 

  557. 					}
    558. 

  558. 				}
    559. 

  559. 			}
    560. 

  560. 		}elseif($type == 'local'){
    561. 

  561. 			$exists = $this->is_translator($id, array('lang_from'=>$from, 'lang_to'=>$to));
    562. 

  562. 		}
    563. 

  563. 		return $exists;
    564. 

  564. 	}
    565. 

  565. 

  566. 	function set_default_translator($id, $from, $to, $type = 'local'){
    567. 

  567. 		global $sitepress, $sitepress_settings;
    568. 

  568. 		$iclsettings['default_translators'] = isset($sitepress_settings['default_translators']) ? $sitepress_settings['default_translators'] : array();
    569. 

  569. 		$iclsettings['default_translators'][$from][$to] = array('id'=>$id, 'type'=>$type);
    570. 

  570. 		$sitepress->save_settings($iclsettings);
    571. 

  571. 	}
    572. 

  572. 

  573. 	function get_default_translator($from, $to){
    574. 

  574. 		global $sitepress_settings;
    575. 

  575. 		if(isset($sitepress_settings['default_translators'][$from][$to])){
    576. 

  576. 			$dt = $sitepress_settings['default_translators'][$from][$to];
    577. 

  577. 		}else{
    578. 

  578. 			$dt = array();
    579. 

  579. 		}
    580. 

  580. 		return $dt;
    581. 

  581. 	}
    582. 

  582. 

  583. 	public static function get_blog_not_translators(){
    584. 

  584. 		global $wpdb;
    585. 

  585. 		$cached_translators = get_option($wpdb->prefix . 'icl_non_translators_cached', array());
    586. 

  586. 		if (!empty($cached_translators)) {
    587. 

  587. 			return $cached_translators;
    588. 

  588. 		}
    589. 

  589. 		$sql = "SELECT u.ID, u.user_login, u.display_name, m.meta_value AS caps
    590. 

  590. 			FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key = '{$wpdb->prefix}capabilities' ORDER BY u.display_name";
    591. 

  591. 		$res = $wpdb->get_results($sql);
    592. 

  592. 

  593. 		$users = array();
    594. 

  594. 		foreach($res as $row){
    595. 

  595. 			$caps = @unserialize($row->caps);
    596. 

  596. 			if(!isset($caps['translate'])){
    597. 

  597. 				$users[] = $row;
    598. 

  598. 			}
    599. 

  599. 		}
    600. 

  600. 		update_option($wpdb->prefix . 'icl_non_translators_cached', $users);
    601. 

  601. 		return $users;
    602. 

  602. 	}
    603. 

  603. 

  604. 	/**
    605. 

  605. 	 * Implementation of 'icl_translators_list' hook
    606. 

  606. 	 *
    607. 

  607. 	 * @global object $sitepress
    608. 

  608. 	 * @param array $array
    609. 

  609. 	 * @return array
    610. 

  610. 	 */
    611. 

  611. 	public static function icanlocalize_translators_list() {
    612. 

  612. 	  global $sitepress_settings, $sitepress;
    613. 

  613. 

  614. 	  $lang_status = isset($sitepress_settings['icl_lang_status']) ? $sitepress_settings['icl_lang_status'] : array();
    615. 

  615. 	  if (0 != key($lang_status)){
    616. 

  616. 		$buf[] = $lang_status;
    617. 

  617. 		$lang_status = $buf;
    618. 

  618. 	  }
    619. 

  619. 

  620. 	  $translators = array();
    621. 

  621. 	  foreach($lang_status as $lpair){
    622. 

  622. 		  foreach((array)$lpair['translators'] as $translator){
    623. 

  623. 			$translators[$translator['id']]['name'] = $translator['nickname'];
    624. 

  624. 			$translators[$translator['id']]['langs'][$lpair['from']][] = $lpair['to'];
    625. 

  625. 			$translators[$translator['id']]['type'] = 'ICanLocalize';
    626. 

  626. 			$translators[$translator['id']]['action'] = $sitepress->create_icl_popup_link(ICL_API_ENDPOINT . '/websites/' . $sitepress_settings['site_id']
    627. 

  627. 				. '/website_translation_offers/' . $lpair['id'] . '/website_translation_contracts/'
    628. 

  628. 				. $translator['contract_id'], array('title' => __('Chat with translator', 'sitepress'), 'unload_cb' => 'icl_thickbox_refresh', 'ar'=>1)) . __('Chat with translator', 'sitepress') . '</a>';
    629. 

  629. 		  }
    630. 

  630. 	  }
    631. 

  631. 

  632. 	  return $translators;
    633. 

  633. 	}
    634. 

  634. 

  635. 	public static function get_blog_translators($args = array()){
    636. 

  636. 		global $wpdb;
    637. 

  637. 		$args_default = array('from'=>false, 'to'=>false);
    638. 

  638. 		extract($args_default);
    639. 

  639. 		extract($args, EXTR_OVERWRITE);
    640. 

  640. 

  641. //        $sql = "SELECT u.ID, u.user_login, u.display_name, u.user_email, m.meta_value AS caps
    642. 

  642. //                    FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key LIKE '{$wpdb->prefix}capabilities' ORDER BY u.display_name";
    643. 

  643. //        $res = $wpdb->get_results($sql);
    644. 

  644. 

  645. 		$cached_translators = get_option($wpdb->prefix . 'icl_translators_cached', array());
    646. 

  646. 

  647. 		if (empty($cached_translators)) {
    648. 

  648. 			$sql = "SELECT u.ID FROM {$wpdb->users} u JOIN {$wpdb->usermeta} m ON u.id=m.user_id AND m.meta_key = '{$wpdb->prefix}language_pairs' ORDER BY u.display_name";
    649. 

  649. 			$res = $wpdb->get_results($sql);
    650. 

  650. 			update_option($wpdb->prefix . 'icl_translators_cached', $res);
    651. 

  651. 		} else {
    652. 

  652. 			$res = $cached_translators;
    653. 

  653. 		}
    654. 

  654. 

  655. 		$users = array();
    656. 

  656. 		foreach($res as $row){
    657. 

  657. 			$user = new WP_User($row->ID);
    658. 

  658. //            $caps = @unserialize($row->caps);
    659. 

  659. //            $row->language_pairs = (array)get_user_meta($row->ID, $wpdb->prefix.'language_pairs', true);
    660. 

  660. 			$user->language_pairs = (array)get_user_meta($row->ID, $wpdb->prefix.'language_pairs', true);
    661. 

  661. //            if(!empty($from) && !empty($to) && (!isset($row->language_pairs[$from][$to]) || !$row->language_pairs[$from][$to])){
    662. 

  662. //                continue;
    663. 

  663. //            }
    664. 

  664. 			if(!empty($from) && !empty($to) && (!isset($user->language_pairs[$from][$to]) || !$user->language_pairs[$from][$to])){
    665. 

  665. 				continue;
    666. 

  666. 			}
    667. 

  667. //            if(isset($caps['translate'])){
    668. 

  668. //                $users[] = $user;
    669. 

  669. //            }
    670. 

  670. 			if($user->has_cap('translate')){
    671. 

  671. 				$users[] = $user;
    672. 

  672. 			}
    673. 

  673. 		}
    674. 

  674. 		return $users;
    675. 

  675. 	}
    676. 

  676. 

  677. 	function get_selected_translator(){
    678. 

  678. 		global $wpdb;
    679. 

  679. 		if($this->selected_translator['ID']){
    680. 

  680. 			$user = new WP_User($this->selected_translator['ID']);
    681. 

  681. 			$this->selected_translator['display_name'] =  $user->data->display_name;
    682. 

  682. 			$this->selected_translator['user_login'] =  $user->data->user_login;
    683. 

  683. 			$this->selected_translator['language_pairs'] = get_user_meta($this->selected_translator['ID'], $wpdb->prefix.'language_pairs', true);
    684. 

  684. 		}else{
    685. 

  685. 			$this->selected_translator['ID'] = 0;
    686. 

  686. 		}
    687. 

  687. 		return (object)$this->selected_translator;
    688. 

  688. 	}
    689. 

  689. 

  690. 	function get_current_translator(){
    691. 

  691. 		return $this->current_translator;
    692. 

  692. 	}
    693. 

  693. 

  694. 	public function get_translator_edit_url($translator_id){
    695. 

  695. 		$url = '';
    696. 

  696. 		if(!empty($translator_id)){
    697. 

  697. 			$url = 'admin.php?page='. WPML_TM_FOLDER .'/menu/main.php&amp;sm=translators&icl_tm_action=edit&amp;user_id='. $translator_id;
    698. 

  698. 		}
    699. 

  699. 		return $url;
    700. 

  700. 	}
    701. 

  701. 

  702. 	public function translators_dropdown( $args = array() ) {
    703. 

  703. 		global $sitepress_settings;
    704. 

  704. 		$args_default = array(
    705. 

  705. 				'from'         => false,
    706. 

  706. 				'to'           => false,
    707. 

  707. 				'name'         => 'translator_id',
    708. 

  708. 				'selected'     => 0,
    709. 

  709. 				'echo'         => true,
    710. 

  710. 				'services'     => array( 'local' ),
    711. 

  711. 				'show_service' => true,
    712. 

  712. 				'disabled'     => false
    713. 

  713. 		);
    714. 

  714. 		extract( $args_default );
    715. 

  715. 		extract( $args, EXTR_OVERWRITE );
    716. 

  716. 

  717. 		$translators = array();
    718. 

  718. 

  719. 		/** @var $from string|false */
    720. 

  720. 		/** @var $to string|false */
    721. 

  721. 		/** @var $name string|false */
    722. 

  722. 		/** @var $selected bool */
    723. 

  723. 		/** @var $echo bool */
    724. 

  724. 		/** @var $services array */
    725. 

  725. 		/** @var $show_service bool */
    726. 

  726. 		/** @var $disabled bool */
    727. 

  727. 		if ( in_array( 'icanlocalize', $services ) ) {
    728. 

  728. 			if ( empty( $sitepress_settings[ 'icl_lang_status' ] ) ) {
    729. 

  729. 				$sitepress_settings[ 'icl_lang_status' ] = array();
    730. 

  730. 			}
    731. 

  731. 			foreach ( (array) $sitepress_settings[ 'icl_lang_status' ] as $language_pair ) {
    732. 

  732. 				if ( $from && $from != $language_pair[ 'from' ] ) {
    733. 

  733. 					continue;
    734. 

  734. 				}
    735. 

  735. 				if ( $to && $to != $language_pair[ 'to' ] ) {
    736. 

  736. 					continue;
    737. 

  737. 				}
    738. 

  738. 

  739. 				if ( !empty( $language_pair[ 'translators' ] ) ) {
    740. 

  740. 					if ( 1 < count( $language_pair[ 'translators' ] ) ) {
    741. 

  741. 						$translators[ ] = (object) array(
    742. 

  742. 								'ID'           => '0-icanlocalize',
    743. 

  743. 								'display_name' => __( 'First available', 'sitepress' ),
    744. 

  744. 								'service'      => 'ICanLocalize'
    745. 

  745. 						);
    746. 

  746. 					}
    747. 

  747. 					foreach ( $language_pair[ 'translators' ] as $tr ) {
    748. 

  748. 						if ( !isset( $_icl_translators[ $tr[ 'id' ] ] ) ) {
    749. 

  749. 							$translators[ ] = $_icl_translators[ $tr[ 'id' ] ] = (object) array(
    750. 

  750. 									'ID'           => $tr[ 'id' ] . '-icanlocalize',
    751. 

  751. 									'display_name' => $tr[ 'nickname' ],
    752. 

  752. 									'service'      => 'ICanLocalize'
    753. 

  753. 							);
    754. 

  754. 						}
    755. 

  755. 					}
    756. 

  756. 				}
    757. 

  757. 			}
    758. 

  758. 		}
    759. 

  759. 

  760. 		if ( in_array( 'local', $services ) ) {
    761. 

  761. 			$translators[ ] = (object) array(
    762. 

  762. 					'ID'           => 0,
    763. 

  763. 					'display_name' => __( 'First available', 'sitepress' ),
    764. 

  764. 			);
    765. 

  765. 			$translators    = array_merge( $translators, self::get_blog_translators( array( 'from' => $from, 'to' => $to ) ) );
    766. 

  766. 		}
    767. 

  767. 		$translators = apply_filters( 'wpml_tm_translators_list', $translators );
    768. 

  768. 		?>
    769. 

  769. 		<select name="<?php echo $name ?>" <?php if ($disabled): ?>disabled="disabled"<?php endif; ?>>
    770. 

  770. 			<?php foreach ( $translators as $t ): ?>
    771. 

  771. 				<option value="<?php echo $t->ID ?>" <?php if ($selected == $t->ID): ?>selected="selected"<?php endif; ?>><?php echo esc_html( $t->display_name );
    772. 

  772. 					?> <?php if ( $show_service ) {
    773. 

  773. 						echo '(';
    774. 

  774. 						echo isset( $t->service ) ? $t->service : _e( 'Local', 'sitepress' );
    775. 

  775. 						echo ')';
    776. 

  776. 					} ?></option>
    777. 

  777. 			<?php endforeach; ?>
    778. 

  778. 		</select>
    779. 

  779. 	<?php
    780. 

  780. 	}
    781. 

  781. 

  782. 	public function get_number_of_docs_sent($service = 'icanlocalize'){
    783. 

  783. 		global $wpdb;
    784. 

  784. 		$n = $wpdb->get_var($wpdb->prepare("
    785. 

  785. 			SELECT COUNT(rid) FROM {$wpdb->prefix}icl_translation_status WHERE translation_service=%s
    786. 

  786. 		", $service));
    787. 

  787. 		return $n;
    788. 

  788. 	}
    789. 

  789. 

  790. 	public function get_number_of_docs_pending($service = 'icanlocalize'){
    791. 

  791. 		global $wpdb;
    792. 

  792. 		$n = $wpdb->get_var($wpdb->prepare("
    793. 

  793. 			SELECT COUNT(rid) FROM {$wpdb->prefix}icl_translation_status WHERE translation_service=%s AND status < " . ICL_TM_COMPLETE . "
    794. 

  794. 		", $service));
    795. 

  795. 		return $n;
    796. 

  796. 	}
    797. 

  797. 

  798. 

  799. 	/* HOOKS */
    800. 

  800. 	/* ******************************************************************************************** */
    801. 

  801. 	function save_post_actions( $post_id, $post, $force_set_status = false )
    802. 

  802. 	{
    803. 

  803. 		global $wpdb, $sitepress, $current_user;
    804. 

  804. 

  805. 		// skip revisions
    806. 

  806. 		if ( $post->post_type == 'revision' ) {
    807. 

  807. 			return;
    808. 

  808. 		}
    809. 

  809. 		// skip auto-drafts
    810. 

  810. 		if ( $post->post_status == 'auto-draft' ) {
    811. 

  811. 			return;
    812. 

  812. 		}
    813. 

  813. 		// skip autosave
    814. 

  814. 		if ( isset( $_POST[ 'autosave' ] ) ) {
    815. 

  815. 			return;
    816. 

  816. 		}
    817. 

  817. 		if ( isset( $_POST[ 'icl_trid' ] ) && is_numeric($_POST['icl_trid']) ) {
    818. 

  818. 			$trid = $_POST['icl_trid'];
    819. 

  819. 		} else {
    820. 

  820. 			$trid = $sitepress->get_element_trid( $post_id, 'post_' . $post->post_type );
    821. 

  821. 		}
    822. 

  822. 

  823. 

  824. 		// set trid and lang code if front-end translation creating
    825. 

  825. 		$trid = apply_filters( 'wpml_tm_save_post_trid_value', isset( $trid ) ? $trid : '', $post_id );
    826. 

  826. 		$lang = apply_filters( 'wpml_tm_save_post_lang_value', isset( $lang ) ? $lang : '', $post_id );
    827. 

  827. 

  828. 		// is this the original document?
    829. 

  829. 		$is_original = false;
    830. 

  830. 		if ( !empty( $trid ) ) {
    831. 

  831. 			$is_original = $wpdb->get_var( $wpdb->prepare( "SELECT source_language_code IS NULL FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND trid=%d", $post_id, $trid ) );
    832. 

  832. 		}
    833. 

  833. 

  834. 		// when a manual translation is added/edited make sure to update translation tables
    835. 

  835. 		if ( !empty( $trid ) && !$is_original ) {
    836. 

  836. 

  837. 			if ( ( !isset( $lang ) || !$lang ) && isset( $_POST[ 'icl_post_language' ] ) && !empty( $_POST[ 'icl_post_language' ] ) ) {
    838. 

  838. 				$lang = $_POST[ 'icl_post_language' ];
    839. 

  839. 			}
    840. 

  840. 

  841. 			$res = $wpdb->get_row( $wpdb->prepare( "
    842. 

  842. 			 SELECT element_id, language_code FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL
    843. 

  843. 		 ", $trid ) );
    844. 

  844. 			if ( $res ) {
    845. 

  845. 				$original_post_id = $res->element_id;
    846. 

  846. 				$from_lang        = $res->language_code;
    847. 

  847. 				$original_post    = get_post( $original_post_id );
    848. 

  848. 				$md5              = $this->post_md5( $original_post );
    849. 

  849. 

  850. 				$translation_id_prepared = $wpdb->prepare( "SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND language_code=%s", $trid, $lang );
    851. 

  851. 				$translation_id          = $wpdb->get_var( $translation_id_prepared );
    852. 

  852. 

  853. 				get_currentuserinfo();
    854. 

  854. 				$user_id = $current_user->ID;
    855. 

  855. 

  856. 

  857. 				if ( !$this->is_translator( $user_id, array( 'lang_from' => $from_lang, 'lang_to' => $lang ) ) ) {
    858. 

  858. 					$this->add_translator( $user_id, array( $from_lang => array( $lang => 1 ) ) );
    859. 

  859. 				}
    860. 

  860. 

  861. 				if ( $translation_id ) {
    862. 

  862. 					$translation_package = $this->create_translation_package( $original_post_id );
    863. 

  863. 

  864. 					list( $rid, $update ) = $this->update_translation_status( array(
    865. 

  865. 																				   'translation_id'      => $translation_id,
    866. 

  866. 																				   'status'              => isset( $force_set_status ) && $force_set_status > 0 ? $force_set_status : ICL_TM_COMPLETE,
    867. 

  867. 																				   'translator_id'       => $user_id,
    868. 

  868. 																				   'needs_update'        => 0,
    869. 

  869. 																				   'md5'                 => $md5,
    870. 

  870. 																				   'translation_service' => 'local',
    871. 

  871. 																				   'translation_package' => serialize( $translation_package )
    872. 

  872. 																			  ) );
    873. 

  873. 					if ( !$update ) {
    874. 

  874. 						$job_id = $this->add_translation_job( $rid, $user_id, $translation_package );
    875. 

  875. 					} else {
    876. 

  876. 						$job_id = $wpdb->get_var( $wpdb->prepare( "SELECT MAX(job_id) FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d GROUP BY rid", $rid ) );
    877. 

  877. 					}
    878. 

  878. 

  879. 					// saving the translation
    880. 

  880. 					$this->save_job_fields_from_post( $job_id, $post );
    881. 

  881. 				}
    882. 

  882. 			}
    883. 

  883. 

  884. 		}
    885. 

  885. 

  886. 		// if this is an original post - compute md5 hash and mark for update if neded
    887. 

  887. 		if ( !empty( $trid ) && empty( $_POST[ 'icl_minor_edit' ] ) ) {
    888. 

  888. 

  889. 			$is_original  = false;
    890. 

  890. 			$translations = $sitepress->get_element_translations( $trid, 'post_' . $post->post_type );
    891. 

  891. 

  892. 			foreach ( $translations as $lang => $translation ) {
    893. 

  893. 				if ( $translation->original == 1 && $translation->element_id == $post_id ) {
    894. 

  894. 					$is_original = true;
    895. 

  895. 					break;
    896. 

  896. 				}
    897. 

  897. 			}
    898. 

  898. 

  899. 			if ( $is_original ) {
    900. 

  900. 				$md5 = $this->post_md5( $post_id );
    901. 

  901. 

  902. 				foreach ( $translations as $lang => $translation ) {
    903. 

  903. 					if ( !$translation->original ) {
    904. 

  904. 						$emd5_prepared = $wpdb->prepare( "SELECT md5 FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation->translation_id );
    905. 

  905. 						$emd5          = $wpdb->get_var( $emd5_prepared );
    906. 

  906. 

  907. 						if ( $md5 != $emd5 ) {
    908. 

  908. 

  909. 							$translation_package = $this->create_translation_package( $post_id );
    910. 

  910. 

  911. 							list( $rid, $update ) = $this->update_translation_status( array(
    912. 

  912. 																						   'translation_id'      => $translation->translation_id,
    913. 

  913. 																						   'needs_update'        => 1,
    914. 

  914. 																						   'md5'                 => $md5,
    915. 

  915. 																						   'translation_package' => serialize( $translation_package )
    916. 

  916. 																					  ) );
    917. 

  917. 

  918. 							// update
    919. 

  919. 

  920. 							$translator_id_prepared = $wpdb->prepare( "SELECT translator_id FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation->translation_id );
    921. 

  921. 							$translator_id          = $wpdb->get_var( $translator_id_prepared );
    922. 

  922. 							$job_id                 = $this->add_translation_job( $rid, $translator_id, $translation_package );
    923. 

  923. 

  924. 							// updating a post that's being translated - update fields in icl_translate
    925. 

  925. 							if ( false === $job_id ) {
    926. 

  926. 								$job_id_prepared = $wpdb->prepare( "SELECT MAX(job_id) FROM {$wpdb->prefix}icl_translate_job WHERE rid = %d", $rid );
    927. 

  927. 								$job_id          = $wpdb->get_var( $job_id_prepared );
    928. 

  928. 								if ( $job_id ) {
    929. 

  929. 									$job = $this->get_translation_job( $job_id );
    930. 

  930. 

  931. 									if ( $job ) {
    932. 

  932. 										foreach ( $job->elements as $element ) {
    933. 

  933. 											unset( $field_data );
    934. 

  934. 											$_taxs_ids = false;
    935. 

  935. 											switch ( $element->field_type ) {
    936. 

  936. 												case 'title':
    937. 

  937. 													$field_data = $this->encode_field_data( $post->post_title, $element->field_format );
    938. 

  938. 													break;
    939. 

  939. 												case 'body':
    940. 

  940. 													$field_data = $this->encode_field_data( $post->post_content, $element->field_format );
    941. 

  941. 													break;
    942. 

  942. 												case 'excerpt':
    943. 

  943. 													$field_data = $this->encode_field_data( $post->post_excerpt, $element->field_format );
    944. 

  944. 													break;
    945. 

  945. 												case 'tags':
    946. 

  946. 													$terms = (array)get_the_terms( $post->ID, 'post_tag' );
    947. 

  947. 													$_taxs = array();
    948. 

  948. 													foreach ( $terms as $term ) {
    949. 

  949. 														$_taxs[ ]     = $term->name;
    950. 

  950. 														$_taxs_ids[ ] = $term->term_taxonomy_id;
    951. 

  951. 													}
    952. 

  952. 													$field_data = $this->encode_field_data( $_taxs, $element->field_format );
    953. 

  953. 													break;
    954. 

  954. 												case 'categories':
    955. 

  955. 													$terms = get_the_terms( $post->ID, 'category' );
    956. 

  956. 													$_taxs = array();
    957. 

  957. 													foreach ( $terms as $term ) {
    958. 

  958. 														$_taxs[ ]     = $term->name;
    959. 

  959. 														$_taxs_ids[ ] = $term->term_taxonomy_id;
    960. 

  960. 													}
    961. 

  961. 													$field_data = $this->encode_field_data( $_taxs, $element->field_format );
    962. 

  962. 													break;
    963. 

  963. 

  964. 												default:
    965. 

  965. 													if ( false !== strpos( $element->field_type, 'field-' ) && !empty( $this->settings[ 'custom_fields_translation' ] ) ) {
    966. 

  966. 														$cf_name = preg_replace( '#^field-#', '', $element->field_type );
    967. 

  967. 														if ( isset( $this->settings[ 'custom_fields_translation' ][ $cf_name ] ) ) {
    968. 

  968. 															$field_data = get_post_meta( $post->ID, $cf_name, 1 );
    969. 

  969. 															$field_data = $this->encode_field_data( $field_data, $element->field_format );
    970. 

  970. 														}
    971. 

  971. 													} else {
    972. 

  972. 														// taxonomies
    973. 

  973. 														if ( taxonomy_exists( $element->field_type ) ) {
    974. 

  974. 															$terms = get_the_terms( $post->ID, $element->field_type );
    975. 

  975. 															$_taxs = array();
    976. 

  976. 															foreach ( $terms as $term ) {
    977. 

  977. 																$_taxs[ ]     = $term->name;
    978. 

  978. 																$_taxs_ids[ ] = $term->term_taxonomy_id;
    979. 

  979. 															}
    980. 

  980. 															$field_data = $this->encode_field_data( $_taxs, $element->field_format );
    981. 

  981. 														}
    982. 

  982. 													}
    983. 

  983. 											}
    984. 

  984. 

  985. 											if ( isset( $field_data ) && $field_data != $element->field_data ) {
    986. 

  986. 

  987. 												$wpdb->update( $wpdb->prefix . 'icl_translate', array( 'field_data' => $field_data ), array( 'tid' => $element->tid ) );
    988. 

  988. 

  989. 												if ( $_taxs_ids && $element->field_type == 'categories' ) {
    990. 

  990. 													$wpdb->update( $wpdb->prefix . 'icl_translate', array( 'field_data' => join( ',', $_taxs_ids ) ), array( 'job_id' => $job_id, 'field_type' => 'category_ids' ) );
    991. 

  991. 												}
    992. 

  992. 

  993. 											}
    994. 

  994. 

  995. 										}
    996. 

  996. 									}
    997. 

  997. 

  998. 								}
    999. 

  999. 

  1000. 							}
    1001. 

  1001. 

  1002. 						}
    1003. 

  1003. 					}
    1004. 

  1004. 				}
    1005. 

  1005. 			}
    1006. 

  1006. 		}
    1007. 

  1007. 

  1008. 		// sync copies/duplicates
    1009. 

  1009. 		$duplicates = $this->get_duplicates( $post_id );
    1010. 

  1010. 		static $duplicated_post_ids;
    1011. 

  1011. 		if ( !isset( $duplicated_post_ids ) ) {
    1012. 

  1012. 			$duplicated_post_ids = array();
    1013. 

  1013. 		}
    1014. 

  1014. 		foreach ( $duplicates as $lang => $_pid ) {
    1015. 

  1015. 			// Avoid infinite recursions
    1016. 

  1016. 			if ( !in_array( $post_id . '|' . $lang, $duplicated_post_ids ) ) {
    1017. 

  1017. 				$duplicated_post_ids[ ] = $post_id . '|' . $lang;
    1018. 

  1018. 				$this->make_duplicate( $post_id, $lang );
    1019. 

  1019. 			}
    1020. 

  1020. 		}
    1021. 

  1021. 

  1022. 	}
    1023. 

  1023. 

  1024. 

  1025. 	function make_duplicates( $data )
    1026. 

  1026. 	{
    1027. 

  1027. 		foreach ( $data[ 'iclpost' ] as $master_post_id ) {
    1028. 

  1028. 			foreach ( $data[ 'duplicate_to' ] as $lang => $one ) {
    1029. 

  1029. 				$this->make_duplicate( $master_post_id, $lang );
    1030. 

  1030. 			}
    1031. 

  1031. 		}
    1032. 

  1032. 	}
    1033. 

  1033. 

  1034. 	function make_duplicate( $master_post_id, $lang )
    1035. 

  1035. 	{
    1036. 

  1036. 		static $duplicated_post_ids;
    1037. 

  1037. 		if(!isset($duplicated_post_ids)) {
    1038. 

  1038. 			$duplicated_post_ids = array();
    1039. 

  1039. 		}
    1040. 

  1040. 

  1041. 		//It is already done? (avoid infinite recursions)
    1042. 

  1042. 		if(in_array($master_post_id . '|' . $lang, $duplicated_post_ids)) {
    1043. 

  1043. 			return true;
    1044. 

  1044. 		}
    1045. 

  1045. 		$duplicated_post_ids[] = $master_post_id . '|' . $lang;
    1046. 

  1046. 

  1047. 		global $sitepress, $sitepress_settings, $wpdb;
    1048. 

  1048. 

  1049. 		do_action( 'icl_before_make_duplicate', $master_post_id, $lang );
    1050. 

  1050. 

  1051. 		$master_post = get_post( $master_post_id );
    1052. 

  1052. 

  1053. 		$is_duplicated = false;
    1054. 

  1054. 		$trid          = $sitepress->get_element_trid( $master_post_id, 'post_' . $master_post->post_type );
    1055. 

  1055. 		if ( $trid ) {
    1056. 

  1056. 			$translations = $sitepress->get_element_translations( $trid, 'post_' . $master_post->post_type );
    1057. 

  1057. 

  1058. 			if ( isset( $translations[ $lang ] ) ) {
    1059. 

  1059. 				$post_array[ 'ID' ] = $translations[ $lang ]->element_id;
    1060. 

  1060. 				$is_duplicated      = get_post_meta( $translations[ $lang ]->element_id, '_icl_lang_duplicate_of', true );
    1061. 

  1061. 			}
    1062. 

  1062. 		}
    1063. 

  1063. 

  1064. 		// covers the case when deleting in bulk from all languages
    1065. 

  1065. 		// setting post_status to trash before wp_trash_post runs issues an WP error
    1066. 

  1066. 		$posts_to_delete_or_restore_in_bulk = array();
    1067. 

  1067. 		if ( isset( $_GET[ 'action' ] ) && ( $_GET[ 'action' ] == 'trash' || $_GET[ 'action' ] == 'untrash' ) && isset( $_GET[ 'lang' ] ) && $_GET[ 'lang' ] == 'all' ) {
    1068. 

  1068. 			static $posts_to_delete_or_restore_in_bulk;
    1069. 

  1069. 			if ( is_null( $posts_to_delete_or_restore_in_bulk ) ) {
    1070. 

  1070. 				$posts_to_delete_or_restore_in_bulk = isset( $_GET[ 'post' ] ) && is_array( $_GET[ 'post' ] ) ? $_GET[ 'post' ] : array();
    1071. 

  1071. 			}
    1072. 

  1072. 		}
    1073. 

  1073. 

  1074. 		$post_array[ 'post_author' ]   = $master_post->post_author;
    1075. 

  1075. 		$post_array[ 'post_date' ]     = $master_post->post_date;
    1076. 

  1076. 		$post_array[ 'post_date_gmt' ] = $master_post->post_date_gmt;
    1077. 

  1077. 		$post_array[ 'post_content' ]  = addslashes_gpc(apply_filters( 'icl_duplicate_generic_string', $master_post->post_content, $lang, array( 'context' => 'post', 'attribute' => 'content', 'key' => $master_post->ID ) ));
    1078. 

  1078. 		$post_array[ 'post_title' ]    = addslashes_gpc(apply_filters( 'icl_duplicate_generic_string', $master_post->post_title, $lang, array( 'context' => 'post', 'attribute' => 'title', 'key' => $master_post->ID ) ));
    1079. 

  1079. 		$post_array[ 'post_excerpt' ]  = addslashes_gpc(apply_filters( 'icl_duplicate_generic_string', $master_post->post_excerpt, $lang, array( 'context' => 'post', 'attribute' => 'excerpt', 'key' => $master_post->ID ) ));
    1080. 

  1080. 

  1081. 		if ( isset( $sitepress_settings[ 'sync_post_status' ] ) && $sitepress_settings[ 'sync_post_status' ] ) {
    1082. 

  1082. 			$sync_post_status = true;
    1083. 

  1083. 		} else {
    1084. 

  1084. 			$sync_post_status = ( !isset( $post_array[ 'ID' ] ) || ( $sitepress_settings[ 'sync_delete' ] && $master_post->post_status == 'trash' ) || $is_duplicated );
    1085. 

  1085. 			$sync_post_status &= ( !$posts_to_delete_or_restore_in_bulk || ( !isset( $post_array[ 'ID' ] ) || !in_array( $post_array[ 'ID' ], $posts_to_delete_or_restore_in_bulk ) ) );
    1086. 

  1086. 		}
    1087. 

  1087. 

  1088. 		if ( $sync_post_status ) {
    1089. 

  1089. 			$post_array[ 'post_status' ] = $master_post->post_status;
    1090. 

  1090. 		}
    1091. 

  1091. 

  1092. 		$post_array[ 'comment_status' ] = $master_post->comment_status;
    1093. 

  1093. 		$post_array[ 'ping_status' ]    = $master_post->ping_status;
    1094. 

  1094. 		$post_array[ 'post_name' ]      = $master_post->post_name;
    1095. 

  1095. 

  1096. 		if ( $master_post->post_parent ) {
    1097. 

  1097. 			$parent                      = icl_object_id( $master_post->post_parent, $master_post->post_type, false, $lang );
    1098. 

  1098. 			$post_array[ 'post_parent' ] = $parent;
    1099. 

  1099. 		}
    1100. 

  1100. 

  1101. 		$post_array[ 'menu_order' ]     = $master_post->menu_order;
    1102. 

  1102. 		$post_array[ 'post_type' ]      = $master_post->post_type;
    1103. 

  1103. 		$post_array[ 'post_mime_type' ] = $master_post->post_mime_type;
    1104. 

  1104. 

  1105. 

  1106. 		$trid = $sitepress->get_element_trid( $master_post->ID, 'post_' . $master_post->post_type );
    1107. 

  1107. 

  1108. 		$_POST[ 'icl_trid' ]               = $trid;
    1109. 

  1109. 		$_POST[ 'icl_post_language' ]      = $lang;
    1110. 

  1110. 		$_POST[ 'skip_sitepress_actions' ] = true;
    1111. 

  1111. 		$_POST[ 'post_type' ]              = $master_post->post_type;
    1112. 

  1112. 

  1113. 		if ( isset( $post_array[ 'ID' ] ) ) {
    1114. 

  1114. 			$id = wp_update_post( $post_array );
    1115. 

  1115. 		} else {
    1116. 

  1116. 			$id = $this->icl_insert_post( $post_array, $lang );
    1117. 

  1117. 		}
    1118. 

  1118. 

  1119. 		require_once ICL_PLUGIN_PATH . '/inc/cache.php';
    1120. 

  1120. 		icl_cache_clear( $post_array[ 'post_type' ] . 's_per_language' );
    1121. 

  1121. 

  1122. 		global $ICL_Pro_Translation;
    1123. 

  1123. 		$ICL_Pro_Translation->_content_fix_links_to_translated_content( $id, $lang );
    1124. 

  1124. 

  1125. 		if ( !is_wp_error( $id ) ) {
    1126. 

  1126. 

  1127. 			$sitepress->set_element_language_details( $id, 'post_' . $master_post->post_type, $trid, $lang );
    1128. 

  1128. 

  1129. 			$this->save_post_actions( $id, get_post( $id ), ICL_TM_DUPLICATE );
    1130. 

  1130. 

  1131. 			$this->duplicate_fix_children( $master_post_id, $lang );
    1132. 

  1132. 

  1133. 			// dup comments
    1134. 

  1134. 			if ( $sitepress->get_option( 'sync_comments_on_duplicates' ) ) {
    1135. 

  1135. 				$this->duplicate_comments( $id, $master_post_id );
    1136. 

  1136. 			}
    1137. 

  1137. 

  1138. 			// make sure post name is copied
    1139. 

  1139. 			$wpdb->update( $wpdb->posts, array( 'post_name' => $master_post->post_name ), array( 'ID' => $id ) );
    1140. 

  1140. 

  1141. 			update_post_meta( $id, '_icl_lang_duplicate_of', $master_post->ID );
    1142. 

  1142. 

  1143. 			if ( $sitepress->get_option( 'sync_post_taxonomies' ) ) {
    1144. 

  1144. 				$this->duplicate_taxonomies( $master_post_id, $lang );
    1145. 

  1145. 			}
    1146. 

  1146. 			$this->duplicate_custom_fields( $master_post_id, $lang );
    1147. 

  1147. 

  1148. 			$ret = $id;
    1149. 

  1149. 			do_action( 'icl_make_duplicate', $master_post_id, $lang, $post_array, $id );
    1150. 

  1150. 

  1151. 		} else {
    1152. 

  1152. 			$ret = false;
    1153. 

  1153. 		}
    1154. 

  1154. 

  1155. 

  1156. 		return $ret;
    1157. 

  1157. 

  1158. 	}
    1159. 

  1159. 

  1160. 	function duplicate_taxonomies( $master_post_id, $lang )
    1161. 

  1161. 	{
    1162. 

  1162. 		global $wpdb, $sitepress;
    1163. 

  1163. 

  1164. 		$post_type = get_post_field( 'post_type', $master_post_id );
    1165. 

  1165. 

  1166. 		$taxonomies = get_object_taxonomies( $post_type );
    1167. 

  1167. 

  1168. 		$trid              = $sitepress->get_element_trid( $master_post_id, 'post_' . $post_type );
    1169. 

  1169. 		$duplicate_post_id = false;
    1170. 

  1170. 		if ( $trid ) {
    1171. 

  1171. 			$translations = $sitepress->get_element_translations( $trid, 'post_' . $post_type, false, false, true );
    1172. 

  1172. 			if ( isset( $translations[ $lang ] ) ) {
    1173. 

  1173. 				$duplicate_post_id = $translations[ $lang ]->element_id;
    1174. 

  1174. 				/* If we have an existing post, we first of all remove all terms currently attached to it.
    1175. 

  1175. 				 * The main reason behind is the removal of the potentially present default category on the post.
    1176. 

  1176. 				 */
    1177. 

  1177. 				wp_delete_object_term_relationships( $duplicate_post_id, $taxonomies );
    1178. 

  1178. 			} else {
    1179. 

  1179. 				return false; // translation not found!
    1180. 

  1180. 			}
    1181. 

  1181. 		}
    1182. 

  1182. 

  1183. 		foreach ( $taxonomies as $taxonomy ) {
    1184. 

  1184. 			if ( $sitepress->is_translated_taxonomy ( $taxonomy ) ) {
    1185. 

  1185. 				WPML_Terms_Translations::sync_post_and_taxonomy_terms_language( $master_post_id, $taxonomy, true );
    1186. 

  1186. 			}
    1187. 

  1187. 		}
    1188. 

  1188. 		return true;
    1189. 

  1189. 	}
    1190. 

  1190. 

  1191. 	function duplicate_custom_fields( $master_post_id, $lang )
    1192. 

  1192. 	{
    1193. 

  1193. 		global $wpdb, $sitepress;
    1194. 

  1194. 

  1195. 		$duplicate_post_id = false;
    1196. 

  1196. 		$post_type = get_post_field( 'post_type', $master_post_id );
    1197. 

  1197. 

  1198. 		$trid = $sitepress->get_element_trid( $master_post_id, 'post_' . $post_type );
    1199. 

  1199. 		if ( $trid ) {
    1200. 

  1200. 			$translations = $sitepress->get_element_translations( $trid, 'post_' . $post_type );
    1201. 

  1201. 			if ( isset( $translations[ $lang ] ) ) {
    1202. 

  1202. 				$duplicate_post_id = $translations[ $lang ]->element_id;
    1203. 

  1203. 			} else {
    1204. 

  1204. 				return false; // translation not found!
    1205. 

  1205. 			}
    1206. 

  1206. 		}
    1207. 

  1207. 

  1208. 		$default_exceptions = array(
    1209. 

  1209. 				'_wp_old_slug',
    1210. 

  1210. 				'_edit_last',
    1211. 

  1211. 				'_edit_lock',
    1212. 

  1212. 				'_icl_translator_note',
    1213. 

  1213. 				'_icl_lang_duplicate_of',
    1214. 

  1214. 				'_wpml_media_duplicate',
    1215. 

  1215. 				'_wpml_media_featured'
    1216. 

  1216. 		);
    1217. 

  1217. 

  1218. 		$exceptions = $default_exceptions;
    1219. 

  1219. 		//Todo: make sure the following filter won't remove the default exceptions
    1220. 

  1220. 		$exceptions = apply_filters('wpml_duplicate_custom_fields_exceptions', $exceptions);
    1221. 

  1221. 

  1222. 		// low level copy
    1223. 

  1223. 		$custom_fields_master    = $wpdb->get_col( $wpdb->prepare( "SELECT meta_key FROM {$wpdb->postmeta} WHERE post_id=%d group by meta_key", $master_post_id ) );
    1224. 

  1224. 		$custom_fields_duplicate = $wpdb->get_col( $wpdb->prepare( "SELECT meta_key FROM {$wpdb->postmeta} WHERE post_id=%d group by meta_key", $duplicate_post_id ) );
    1225. 

  1225. 

  1226. 		$custom_fields_master    = array_diff( $custom_fields_master, $exceptions );
    1227. 

  1227. 		$custom_fields_duplicate = array_diff( $custom_fields_duplicate, $exceptions );
    1228. 

  1228. 

  1229. 		$remove = array_diff( $custom_fields_duplicate, $custom_fields_master );
    1230. 

  1230. 		foreach ( $remove as $key ) {
    1231. 

  1231. 			delete_post_meta( $duplicate_post_id, $key );
    1232. 

  1232. 		}
    1233. 

  1233. 

  1234. 		foreach ( $custom_fields_master as $key ) {
    1235. 

  1235. 			$master_custom_field_values_array    = get_post_meta( $master_post_id, $key );
    1236. 

  1236. 			$master_custom_field_values_single    = get_post_meta( $master_post_id, $key, true );
    1237. 

  1237. 

  1238. 			$is_repeated = false;
    1239. 

  1239. 			if($master_custom_field_values_array != $master_custom_field_values_single) {
    1240. 

  1240. 				//Repeated fields
    1241. 

  1241. 				$master_custom_field_values	= $master_custom_field_values_array;
    1242. 

  1242. 				$is_repeated = true;
    1243. 

  1243. 			} else {
    1244. 

  1244. 				//Field stored as serialized array
    1245. 

  1245. 				$master_custom_field_values[] = $master_custom_field_values_single;
    1246. 

  1246. 			}
    1247. 

  1247. 

  1248. 			if($is_repeated) {
    1249. 

  1249. 				$duplicate_custom_field_values = get_post_meta( $duplicate_post_id, $key );
    1250. 

  1250. 			} else {
    1251. 

  1251. 				$duplicate_custom_field_values[] = get_post_meta( $duplicate_post_id, $key, true );
    1252. 

  1252. 			}
    1253. 

  1253. 

  1254. 			if ( !$duplicate_custom_field_values || $master_custom_field_values != $duplicate_custom_field_values ) {
    1255. 

  1255. 				if($is_repeated) {
    1256. 

  1256. 					//Delete the old one
    1257. 

  1257. 					delete_post_meta($duplicate_post_id, $key);
    1258. 

  1258. 					//And add new ones from the original
    1259. 

  1259. 					foreach($master_custom_field_values as $master_custom_field_value) {
    1260. 

  1260. 						add_post_meta( $duplicate_post_id, $key, addslashes_gpc(apply_filters( 'icl_duplicate_generic_string', $master_custom_field_value, $lang, array( 'context' => 'custom_field', 'attribute' => 'value', 'key' => $key ) ) ) );
    1261. 

  1261. 					}
    1262. 

  1262. 				} else {
    1263. 

  1263. 					update_post_meta( $duplicate_post_id, $key, addslashes_gpc(apply_filters( 'icl_duplicate_generic_string', $master_custom_field_value, $lang, array( 'context' => 'custom_field', 'attribute' => 'value', 'key' => $key ) ) ) );
    1264. 

  1264. 				}
    1265. 

  1265. 			}
    1266. 

  1266. 		}
    1267. 

  1267. 

  1268. 		return true;
    1269. 

  1269. 	}
    1270. 

  1270. 

  1271. 	function duplicate_fix_children( $master_post_id, $lang )
    1272. 

  1272. 	{
    1273. 

  1273. 		global $wpdb;
    1274. 

  1274. 

  1275. 		$post_type       = $wpdb->get_var( $wpdb->prepare( "SELECT post_type FROM {$wpdb->posts} WHERE ID=%d", $master_post_id ) );
    1276. 

  1276. 		$master_children = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts} WHERE post_parent=%d AND post_type != 'revision'", $master_post_id ) );
    1277. 

  1277. 		$dup_parent      = icl_object_id( $master_post_id, $post_type, false, $lang );
    1278. 

  1278. 

  1279. 		if ( $master_children ) {
    1280. 

  1280. 			foreach ( $master_children as $master_child ) {
    1281. 

  1281. 				$dup_child = icl_object_id( $master_child, $post_type, false, $lang );
    1282. 

  1282. 				if ( $dup_child ) {
    1283. 

  1283. 					$wpdb->update( $wpdb->posts, array( 'post_parent' => $dup_parent ), array( 'ID' => $dup_child ) );
    1284. 

  1284. 				}
    1285. 

  1285. 				$this->duplicate_fix_children( $master_child, $lang );
    1286. 

  1286. 			}
    1287. 

  1287. 		}
    1288. 

  1288. 	}
    1289. 

  1289. 

  1290. 	function make_duplicates_all( $master_post_id )
    1291. 

  1291. 	{
    1292. 

  1292. 		global $sitepress;
    1293. 

  1293. 

  1294. 		$master_post               = get_post( $master_post_id );
    1295. 

  1295. 		if($master_post->post_status == 'auto-draft' || $master_post->post_type == 'revision') {
    1296. 

  1296. 			return;
    1297. 

  1297. 		}
    1298. 

  1298. 

  1299. 		$language_details_original = $sitepress->get_element_language_details( $master_post_id, 'post_' . $master_post->post_type );
    1300. 

  1300. 

  1301. 		if(!$language_details_original) return;
    1302. 

  1302. 

  1303. 		$data[ 'iclpost' ] = array( $master_post_id );
    1304. 

  1304. 		foreach ( $sitepress->get_active_languages() as $lang => $details ) {
    1305. 

  1305. 			if ( $lang != $language_details_original->language_code ) {
    1306. 

  1306. 				$data[ 'duplicate_to' ][ $lang ] = 1;
    1307. 

  1307. 			}
    1308. 

  1308. 		}
    1309. 

  1309. 

  1310. 		$this->make_duplicates( $data );
    1311. 

  1311. 	}
    1312. 

  1312. 

  1313. 	function reset_duplicate_flag( $post_id )
    1314. 

  1314. 	{
    1315. 

  1315. 		global $sitepress;
    1316. 

  1316. 

  1317. 		$post = get_post( $post_id );
    1318. 

  1318. 

  1319. 		$trid         = $sitepress->get_element_trid( $post_id, 'post_' . $post->post_type );
    1320. 

  1320. 		$translations = $sitepress->get_element_translations( $trid, 'post_' . $post->post_type );
    1321. 

  1321. 

  1322. 		foreach ( $translations as $tr ) {
    1323. 

  1323. 			if ( $tr->element_id == $post_id ) {
    1324. 

  1324. 				$this->update_translation_status( array(
    1325. 

  1325. 													   'translation_id' => $tr->translation_id,
    1326. 

  1326. 													   'status'         => ICL_TM_COMPLETE
    1327. 

  1327. 												  ) );
    1328. 

  1328. 			}
    1329. 

  1329. 		}
    1330. 

  1330. 

  1331. 		delete_post_meta( $post_id, '_icl_lang_duplicate_of' );
    1332. 

  1332. 

  1333. 

  1334. 	}
    1335. 

  1335. 

  1336. 	function set_duplicate( $post_id )
    1337. 

  1337. 	{
    1338. 

  1338. 		global $sitepress;
    1339. 

  1339. 		// find original (source) and copy
    1340. 

  1340. 		$post         = get_post( $post_id );
    1341. 

  1341. 		$trid         = $sitepress->get_element_trid( $post_id, 'post_' . $post->post_type );
    1342. 

  1342. 		$translations = $sitepress->get_element_translations( $trid, 'post_' . $post->post_type );
    1343. 

  1343. 

  1344. 		foreach ( $translations as $lang => $tr ) {
    1345. 

  1345. 			if ( $tr->original ) {
    1346. 

  1346. 				$master_post_id = $tr->element_id;
    1347. 

  1347. 			} elseif ( $tr->element_id == $post_id ) {
    1348. 

  1348. 				$this_language = $lang;
    1349. 

  1349. 			}
    1350. 

  1350. 		}
    1351. 

  1351. 

  1352. 		$this->make_duplicate( $master_post_id, $this_language );
    1353. 

  1353. 

  1354. 	}
    1355. 

  1355. 

  1356. 	function get_duplicates( $master_post_id )
    1357. 

  1357. 	{
    1358. 

  1358. 		global $wpdb, $sitepress;
    1359. 

  1359. 

  1360. 		$duplicates = array();
    1361. 

  1361. 

  1362. 		$res = $wpdb->get_col( $wpdb->prepare( "SELECT post_id FROM {$wpdb->postmeta}
    1363. 

  1363. 		 WHERE meta_key='_icl_lang_duplicate_of' AND meta_value=%d", $master_post_id ) );
    1364. 

    1365. 

  1365. 		foreach ( $res as $post_id ) {
    1366. 

  1366. 

  1367. 			$post             = get_post( $post_id );
    1368. 

  1368. 			$language_details = $sitepress->get_element_language_details( $post_id, 'post_' . $post->post_type );
    1369. 

  1369. 

  1370. 			$duplicates[ $language_details->language_code ] = $post_id;
    1371. 

  1371. 		}
    1372. 

  1372. 

  1373. 		return $duplicates;
    1374. 

  1374. 

  1375. 	}
    1376. 

  1376. 

  1377. 	function duplicate_comments( $post_id, $master_post_id ) {
    1378. 

  1378. 		global $wpdb, $sitepress;
    1379. 

  1379. 

  1380. 		// delete existing comments
    1381. 

  1381. 		$current_comments = $wpdb->get_results( $wpdb->prepare( "SELECT comment_ID FROM {$wpdb->comments} WHERE comment_post_ID = %d", $post_id ) );
    1382. 

  1382. 		foreach ( $current_comments as $current_comment ) {
    1383. 

  1383. 			if ( isset( $current_comment->comment_ID ) && is_numeric( $current_comment->comment_ID ) ) {
    1384. 

  1384. 				wp_delete_comment( $current_comment->comment_ID );
    1385. 

  1385. 			}
    1386. 

  1386. 		}
    1387. 

  1387. 

  1388. 

  1389. 		$original_comments = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->comments} WHERE comment_post_id = %d", $master_post_id ), ARRAY_A );
    1390. 

  1390. 

  1391. 		$post_type = $wpdb->get_var( $wpdb->prepare( "SELECT post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id ) );
    1392. 

  1392. 		$language  = $wpdb->get_var( $wpdb->prepare( "SELECT language_code FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $post_id, 'post_' . $post_type ) );
    1393. 

  1393. 

  1394. 		$wpdb->update( $wpdb->posts, array( 'comment_count' => count( $original_comments ) ), array( 'ID' => $post_id ) );
    1395. 

  1395. 

  1396. 		foreach ( $original_comments as $comment ) {
    1397. 

  1397. 

  1398. 			$original_comment_id = $comment[ 'comment_ID' ];
    1399. 

  1399. 			unset( $comment[ 'comment_ID' ] );
    1400. 

  1400. 

  1401. 			$comment[ 'comment_post_ID' ] = $post_id;
    1402. 

  1402. 			$wpdb->insert( $wpdb->comments, $comment );
    1403. 

  1403. 			$comment_id = $wpdb->insert_id;
    1404. 

  1404. 

  1405. 			update_comment_meta( $comment_id, '_icl_duplicate_of', $original_comment_id );
    1406. 

  1406. 

  1407. 			// comment meta
    1408. 

  1408. 			$meta = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value FROM {$wpdb->commentmeta} WHERE comment_id=%d", $original_comment_id ) );
    1409. 

  1409. 			foreach ( $meta as $meta_data ) {
    1410. 

  1410. 				if ( is_object( $meta_data ) && isset( $meta_data->meta_key ) && isset( $meta_data->meta_value ) ) {
    1411. 

  1411. 					$wpdb->insert( $wpdb->commentmeta, array(
    1412. 

  1412. 						'comment_id' => $comment_id,
    1413. 

  1413. 						'meta_key'   => $meta_data->meta_key,
    1414. 

  1414. 						'meta_value' => $meta_data->meta_value
    1415. 

  1415. 					) );
    1416. 

  1416. 				}
    1417. 

  1417. 			}
    1418. 

  1418. 

  1419. 			$original_comment_tr = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $original_comment_id, 'comment' ) );
    1420. 

  1420. 

  1421. 			if ( $original_comment_tr && isset( $original_comment_tr->trid ) ) {
    1422. 

  1422. 				$comment_translation = array(
    1423. 

  1423. 					'element_type'  => 'comment',
    1424. 

  1424. 					'element_id'    => $comment_id,
    1425. 

  1425. 					'trid'          => $original_comment_tr->trid,
    1426. 

  1426. 					'language_code' => $language,
    1427. 

  1427. 					/*'source_language_code'  => $original_comment_tr->language_code */
    1428. 

  1428. 				);
    1429. 

  1429. 

  1430. 				$comments_map[ $original_comment_id ] = array( 'trid' => $original_comment_tr->trid, 'comment' => $comment_id );
    1431. 

  1431. 

  1432. 				$existing_translation_tr = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND element_type=%s AND language_code=%s", $original_comment_tr->trid, 'comment', $language ) );
    1433. 

  1433. 

  1434. 				if ( $existing_translation_tr ) {
    1435. 

  1435. 					$wpdb->update( $wpdb->prefix . 'icl_translations', $comment_translation, array( 'trid' => $comment_id, 'element_type' => 'comment', 'language_code' => $language ) );
    1436. 

  1436. 				} else {
    1437. 

  1437. 					$wpdb->insert( $wpdb->prefix . 'icl_translations', $comment_translation );
    1438. 

  1438. 				}
    1439. 

  1439. 			}
    1440. 

  1440. 		}
    1441. 

  1441. 

  1442. 		// sync parents
    1443. 

  1443. 		foreach ( $original_comments as $comment ) {
    1444. 

  1444. 			if ( $comment[ 'comment_parent' ] ) {
    1445. 

  1445. 

  1446. 				$tr_comment_id = $comments_map[ $comment[ 'comment_ID' ] ][ 'comment' ];
    1447. 

  1447. 				$tr_parent     = icl_object_id( $comment[ 'comment_parent' ], 'comment', false, $language );
    1448. 

  1448. 				if ( $tr_parent ) {
    1449. 

  1449. 					$wpdb->update( $wpdb->comments, array( 'comment_parent' => $tr_parent ), array( 'comment_ID' => $tr_comment_id ) );
    1450. 

  1450. 				}
    1451. 

  1451. 

  1452. 			}
    1453. 

  1453. 		}
    1454. 

  1454. 

  1455. 

  1456. 	}
    1457. 

  1457. 

  1458. 	function duplication_delete_comment( $comment_id )
    1459. 

  1459. 	{
    1460. 

  1460. 		global $wpdb;
    1461. 

  1461. 		static $_avoid_8_loop;
    1462. 

  1462. 

  1463. 		if ( isset( $_avoid_8_loop ) ) {
    1464. 

  1464. 			return;
    1465. 

  1465. 		}
    1466. 

  1466. 		$_avoid_8_loop = true;
    1467. 

  1467. 

  1468. 		$original_comment = get_comment_meta( $comment_id, '_icl_duplicate_of', true );
    1469. 

  1469. 		if ( $original_comment ) {
    1470. 

  1470. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $original_comment ) );
    1471. 

  1471. 			$duplicates = array( $original_comment ) + array_diff( $duplicates, array( $comment_id ) );
    1472. 

  1472. 			foreach ( $duplicates as $dup ) {
    1473. 

  1473. 				wp_delete_comment( $dup );
    1474. 

  1474. 			}
    1475. 

  1475. 		} else {
    1476. 

  1476. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $comment_id ) );
    1477. 

  1477. 			if ( $duplicates ) {
    1478. 

  1478. 				foreach ( $duplicates as $dup ) {
    1479. 

  1479. 					wp_delete_comment( $dup );
    1480. 

  1480. 				}
    1481. 

  1481. 			}
    1482. 

  1482. 		}
    1483. 

  1483. 

  1484. 		unset( $_avoid_8_loop );
    1485. 

  1485. 	}
    1486. 

  1486. 

  1487. 	function duplication_edit_comment( $comment_id )
    1488. 

  1488. 	{
    1489. 

  1489. 		global $wpdb;
    1490. 

  1490. 

  1491. 		$comment = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->comments} WHERE comment_ID=%d", $comment_id ), ARRAY_A );
    1492. 

  1492. 		unset( $comment[ 'comment_ID' ], $comment[ 'comment_post_ID' ] );
    1493. 

  1493. 

  1494. 		$comment_meta = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value FROM {$wpdb->commentmeta} WHERE comment_id=%d AND meta_key <> '_icl_duplicate_of'", $comment_id ) );
    1495. 

  1495. 

  1496. 		$original_comment = get_comment_meta( $comment_id, '_icl_duplicate_of', true );
    1497. 

  1497. 		if ( $original_comment ) {
    1498. 

  1498. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $original_comment ) );
    1499. 

  1499. 			$duplicates = array( $original_comment ) + array_diff( $duplicates, array( $comment_id ) );
    1500. 

  1500. 		} else {
    1501. 

  1501. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $comment_id ) );
    1502. 

  1502. 		}
    1503. 

  1503. 

  1504. 		if ( !empty( $duplicates ) ) {
    1505. 

  1505. 			foreach ( $duplicates as $dup ) {
    1506. 

  1506. 

  1507. 				$wpdb->update( $wpdb->comments, $comment, array( 'comment_ID' => $dup ) );
    1508. 

  1508. 

  1509. 				$wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->commentmeta} WHERE comment_id=%d AND meta_key <> '_icl_duplicate_of'", $dup ) );
    1510. 

  1510. 

  1511. 				if ( $comment_meta ) {
    1512. 

  1512. 					foreach ( $comment_meta as $key => $value ) {
    1513. 

  1513. 						update_comment_meta( $dup, $key, $value );
    1514. 

  1514. 					}
    1515. 

  1515. 				}
    1516. 

  1516. 

  1517. 			}
    1518. 

  1518. 		}
    1519. 

  1519. 

  1520. 

  1521. 	}
    1522. 

  1522. 

  1523. 	function duplication_status_comment( $comment_id, $comment_status )
    1524. 

  1524. 	{
    1525. 

  1525. 		global $wpdb;
    1526. 

  1526. 

  1527. 		static $_avoid_8_loop;
    1528. 

  1528. 

  1529. 		if ( isset( $_avoid_8_loop ) ) {
    1530. 

  1530. 			return;
    1531. 

  1531. 		}
    1532. 

  1532. 		$_avoid_8_loop = true;
    1533. 

  1533. 

  1534. 

  1535. 		$original_comment = get_comment_meta( $comment_id, '_icl_duplicate_of', true );
    1536. 

  1536. 		if ( $original_comment ) {
    1537. 

  1537. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $original_comment ) );
    1538. 

  1538. 			$duplicates = array( $original_comment ) + array_diff( $duplicates, array( $comment_id ) );
    1539. 

  1539. 		} else {
    1540. 

  1540. 			$duplicates = $wpdb->get_col( $wpdb->prepare( "SELECT comment_id FROM {$wpdb->commentmeta} WHERE meta_key='_icl_duplicate_of' AND meta_value=%d", $comment_id ) );
    1541. 

  1541. 		}
    1542. 

  1542. 

  1543. 		if ( !empty( $duplicates ) ) {
    1544. 

  1544. 			foreach ( $duplicates as $duplicate ) {
    1545. 

  1545. 				wp_set_comment_status( $duplicate, $comment_status );
    1546. 

  1546. 			}
    1547. 

  1547. 		}
    1548. 

  1548. 

  1549. 		unset( $_avoid_8_loop );
    1550. 

  1550. 

  1551. 

  1552. 	}
    1553. 

  1553. 

  1554. 	function duplication_insert_comment( $comment_id )
    1555. 

  1555. 	{
    1556. 

  1556. 		global $wpdb, $sitepress;
    1557. 

  1557. 

  1558. 		$comment = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->comments} WHERE comment_ID=%d", $comment_id ), ARRAY_A );
    1559. 

  1559. 

  1560. 		// loop duplicate posts, add new comment
    1561. 

  1561. 		$post_id = $comment[ 'comment_post_ID' ];
    1562. 

  1562. 

  1563. 		// if this is a duplicate post
    1564. 

  1564. 		$duplicate_of = get_post_meta( $post_id, '_icl_lang_duplicate_of', true );
    1565. 

  1565. 		if ( $duplicate_of ) {
    1566. 

  1566. 			$post_duplicates = $this->get_duplicates( $duplicate_of );
    1567. 

  1567. 			$_lang           = $wpdb->get_var( $wpdb->prepare( "SELECT language_code FROM {$wpdb->prefix}icl_translations WHERE element_type='comment' AND element_id=%d", $comment_id ) );
    1568. 

  1568. 			unset( $post_duplicates[ $_lang ] );
    1569. 

  1569. 			$_post                          = get_post( $duplicate_of );
    1570. 

  1570. 			$_orig_lang                     = $sitepress->get_language_for_element( $duplicate_of, 'post_' . $_post->post_type );
    1571. 

  1571. 			$post_duplicates[ $_orig_lang ] = $duplicate_of;
    1572. 

  1572. 		} else {
    1573. 

  1573. 			$post_duplicates = $this->get_duplicates( $post_id );
    1574. 

  1574. 		}
    1575. 

  1575. 

  1576. 		unset( $comment[ 'comment_ID' ], $comment[ 'comment_post_ID' ] );
    1577. 

  1577. 

  1578. 		foreach ( $post_duplicates as $lang => $dup_id ) {
    1579. 

  1579. 			$comment[ 'comment_post_ID' ] = $dup_id;
    1580. 

  1580. 

  1581. 			if ( $comment[ 'comment_parent' ] ) {
    1582. 

  1582. 				$comment[ 'comment_parent' ] = icl_object_id( $comment[ 'comment_parent' ], 'comment', false, $lang );
    1583. 

  1583. 			}
    1584. 

  1584. 

  1585. 

  1586. 			$wpdb->insert( $wpdb->comments, $comment );
    1587. 

  1587. 

  1588. 			$dup_comment_id = $wpdb->insert_id;
    1589. 

  1589. 

  1590. 			update_comment_meta( $dup_comment_id, '_icl_duplicate_of', $comment_id );
    1591. 

  1591. 

  1592. 			// comment meta
    1593. 

  1593. 			$meta = $wpdb->get_results( $wpdb->prepare( "SELECT meta_key, meta_value FROM {$wpdb->commentmeta} WHERE comment_id=%d", $comment_id ) );
    1594. 

  1594. 			foreach ( $meta as $key => $val ) {
    1595. 

  1595. 				$wpdb->insert( $wpdb->commentmeta, array(
    1596. 

  1596. 														'comment_id' => $dup_comment_id,
    1597. 

  1597. 														'meta_key'   => $key,
    1598. 

  1598. 														'meta_value' => $val
    1599. 

  1599. 												   ) );
    1600. 

  1600. 			}
    1601. 

  1601. 

  1602. 			$original_comment_tr = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $comment_id, 'comment' ) );
    1603. 

  1603. 

  1604. 			$comment_translation = array(
    1605. 

  1605. 				'element_type'  => 'comment',
    1606. 

  1606. 				'element_id'    => $dup_comment_id,
    1607. 

  1607. 				'trid'          => $original_comment_tr->trid,
    1608. 

  1608. 				'language_code' => $lang,
    1609. 

  1609. 				/*'source_language_code'  => $original_comment_tr->language_code */
    1610. 

  1610. 			);
    1611. 

  1611. 

  1612. 			$wpdb->insert( $wpdb->prefix . 'icl_translations', $comment_translation );
    1613. 

  1613. 

  1614. 		}
    1615. 

  1615. 

  1616. 

  1617. 	}
    1618. 

  1618. 

  1619. 	function delete_post_actions($post_id){
    1620. 

  1620. 		global $wpdb;
    1621. 

  1621. 		$post_type = $wpdb->get_var("SELECT post_type FROM {$wpdb->posts} WHERE ID={$post_id}");
    1622. 

  1622. 		if(!empty($post_type)){
    1623. 

  1623. 			$translation_id = $wpdb->get_var($wpdb->prepare("SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $post_id, 'post_' . $post_type));
    1624. 

  1624. 			if($translation_id){
    1625. 

  1625. 				$rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id));
    1626. 

  1626. 				$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id));
    1627. 

  1627. 				if($rid){
    1628. 

  1628. 					$jobs = $wpdb->get_col($wpdb->prepare("SELECT job_id FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));
    1629. 

  1629. 					$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));
    1630. 

  1630. 					if(!empty($jobs)){
    1631. 

  1631. 						$wpdb->query("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id IN (".join(',', $jobs).")");
    1632. 

  1632. 					}
    1633. 

  1633. 				}
    1634. 

  1634. 			}
    1635. 

  1635. 		}
    1636. 

  1636. 	}
    1637. 

  1637. 

  1638. 	function edit_term($cat_id, $tt_id){
    1639. 

  1639. 		global $wpdb, $sitepress;
    1640. 

  1640. 

  1641. 		$el_type = $wpdb->get_var("SELECT taxonomy FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id={$tt_id}");
    1642. 

  1642. 

  1643. 		if(!$sitepress->is_translated_taxonomy($el_type)){
    1644. 

  1644. 			return;
    1645. 

  1645. 		};
    1646. 

  1646. 

  1647. 		$icl_el_type = 'tax_' . $el_type;
    1648. 

  1648. 

  1649. 		// has trid only when it's a translation of another tag
    1650. 

  1650. 		$trid = isset($_POST['icl_trid']) && (isset($_POST['icl_'.$icl_el_type.'_language'])) ? $_POST['icl_trid']:null;
    1651. 

  1651. 		// see if we have a "translation of" setting.
    1652. 

  1652. 		$src_language = false;
    1653. 

  1653. 		if (isset($_POST['icl_translation_of']) && $_POST['icl_translation_of']) {
    1654. 

  1654. 			$src_term_id = $_POST['icl_translation_of'];
    1655. 

  1655. 			if ($src_term_id != 'none') {
    1656. 

  1656. 				$res = $wpdb->get_row("SELECT trid, language_code
    1657. 

  1657. 					FROM {$wpdb->prefix}icl_translations WHERE element_id={$src_term_id} AND element_type='{$icl_el_type}'");
    1658. 

  1658. 				$trid = $res->trid;
    1659. 

  1659. 				$src_language = $res->language_code;
    1660. 

  1660. 			} else {
    1661. 

  1661. 				$trid = null;
    1662. 

  1662. 			}
    1663. 

  1663. 		}
    1664. 

  1664. 

  1665. 		if(isset($_POST['action']) && $_POST['action'] == 'inline-save-tax'){
    1666. 

  1666. 			$trid = $sitepress->get_element_trid($tt_id, $icl_el_type);
    1667. 

  1667. 		}
    1668. 

  1668. 

  1669. 	// update icl_translate if necessary
    1670. 

  1670. 		// get the terms translations
    1671. 

  1671. 		$element_translations = $sitepress->get_element_translations($trid, $icl_el_type);
    1672. 

  1672. 		$tr_ids = array();
    1673. 

  1673. 		foreach($element_translations as $el_lang => $el_info){
    1674. 

  1674. 			if($tt_id != $el_info->term_id){
    1675. 

  1675. 				$tr_ids[] = $el_info->term_id;
    1676. 

  1676. 			}
    1677. 

  1677. 		}
    1678. 

  1678. 

  1679. 		// does the term taxonomy we are currently editing have a record in the icl_translate?
    1680. 

  1680. 		$results = $wpdb->get_results( $wpdb->prepare(
    1681. 

  1681. 			"SELECT field_data, job_id FROM {$wpdb->prefix}icl_translate WHERE field_type = %s", $el_type.'_ids'
    1682. 

  1682. 		));
    1683. 

  1683. 

  1684. 		if(!empty($results)){
    1685. 

  1685. 			$job_ids = array(); // this will hold the job ids that contain our term under field_data
    1686. 

  1686. 			$job_ids2 = array(); // this will hold the job ids that contain our term under field_data_translated
    1687. 

  1687. 			foreach($results as $result){
    1688. 

  1688. 				$r_ids = explode (',', $result->field_data);
    1689. 

  1689. 				// is the term found?
    1690. 

  1690. 				if(in_array ($tt_id, $r_ids)){
    1691. 

  1691. 					$job_ids[] = $result->job_id;
    1692. 

  1692. 					// this is used further down to identify the correct term name to update
    1693. 

  1693. 					foreach($r_ids as $k => $v){
    1694. 

  1694. 						if($v == $tt_id){
    1695. 

  1695. 							$t_k[] = $k;
    1696. 

  1696. 						}
    1697. 

  1697. 					}
    1698. 

  1698. 				}
    1699. 

  1699. 

  1700. 				// the name of the current category being edited could also be under field_data_translated
    1701. 

  1701. 				if(!empty($tr_ids)){
    1702. 

  1702. 					foreach($tr_ids as $tr_id){
    1703. 

  1703. 						// is the term found?
    1704. 

  1704. 						if(in_array ($tr_id, $r_ids)){
    1705. 

  1705. 							$job_ids2[] = $result->job_id;
    1706. 

  1706. 							// this is used further down to identify the correct term name to update
    1707. 

  1707. 							foreach($r_ids as $k => $v){
    1708. 

  1708. 								if($v == $tr_id){
    1709. 

  1709. 									$t_k2[] = $k;
    1710. 

  1710. 								}
    1711. 

  1711. 							}
    1712. 

  1712. 						}
    1713. 

  1713. 					}
    1714. 

  1714. 				}
    1715. 

  1715. 			}
    1716. 

  1716. 

  1717. 			// if we have job_ids to be updated proceed
    1718. 

  1718. 			if(!empty($job_ids)){
    1719. 

  1719. 				$in = implode (',', $job_ids);
    1720. 

  1720. 				$field_type = ($el_type == 'category' ? 'categories' : $el_type);
    1721. 

  1721. 				//grab the term names
    1722. 

  1722. 				$results = $wpdb->get_results( $wpdb->prepare(
    1723. 

  1723. 					"SELECT tid, field_data, field_format FROM {$wpdb->prefix}icl_translate WHERE job_id IN ({$in}) AND field_type = %s", $field_type
    1724. 

  1724. 				));
    1725. 

  1725. 

  1726. 				$count = 0;
    1727. 

  1727. 				foreach($results as $result){
    1728. 

  1728. 					// decode
    1729. 

  1729. 					$decoded_data = self::decode_field_data($result->field_data, $result->field_format);
    1730. 

  1730. 					// we may have multiple comma separated term names - pass the new term name to the correct one!
    1731. 

  1731. 					$decoded_data[$t_k[$count]] = $_POST['name'];
    1732. 

  1732. 					// encode
    1733. 

  1733. 					$encoded_data =$this->encode_field_data($decoded_data, $result->field_format);
    1734. 

  1734. 					// update
    1735. 

  1735. 					$wpdb->update($wpdb->prefix.'icl_translate',
    1736. 

  1736. 							array('field_data'=>$encoded_data),
    1737. 

  1737. 							array('tid'=>$result->tid)
    1738. 

  1738. 						);
    1739. 

  1739. 				$count++;
    1740. 

  1740. 				}
    1741. 

  1741. 

  1742. 				// update the translation status as "needs_update"
    1743. 

  1743. 				foreach($job_ids as $job_id){
    1744. 

  1744. 					list($translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
    1745. 

  1745. 					// update
    1746. 

  1746. 					$wpdb->update($wpdb->prefix.'icl_translation_status',
    1747. 

  1747. 							array('needs_update'=>1),
    1748. 

  1748. 							array('rid'=>$rid, 'translator_id'=>$translator_id)
    1749. 

  1749. 						);
    1750. 

  1750. 				}
    1751. 

  1751. 			}
    1752. 

  1752. 

  1753. 			// if we have job_ids2 to be updated proceed
    1754. 

  1754. 			if(!empty($job_ids2)){
    1755. 

  1755. 				$in = implode (',', $job_ids2);
    1756. 

  1756. 				$field_type = ($el_type == 'category' ? 'categories' : $el_type);
    1757. 

  1757. 				//grab the term names
    1758. 

  1758. 				$results = $wpdb->get_results( $wpdb->prepare(
    1759. 

  1759. 					"SELECT tid, field_data_translated, field_format FROM {$wpdb->prefix}icl_translate WHERE job_id IN ({$in}) AND field_type  = %s", $field_type
    1760. 

  1760. 				));
    1761. 

  1761. 

  1762. 				$count = 0;
    1763. 

  1763. 				foreach($results as $result){
    1764. 

  1764. 					if(!empty($result->field_data_translated)){
    1765. 

  1765. 						// decode
    1766. 

  1766. 						$decoded_data = self::decode_field_data($result->field_data_translated, $result->field_format);
    1767. 

  1767. 						// we may have multiple comma separated term names - pass the new term name to the correct one!
    1768. 

  1768. 						$decoded_data[$t_k2[$count]] = $_POST['name'];
    1769. 

  1769. 						// encode
    1770. 

  1770. 						$encoded_data =$this->encode_field_data($decoded_data, $result->field_format);
    1771. 

  1771. 						// update
    1772. 

  1772. 						$wpdb->update($wpdb->prefix.'icl_translate',
    1773. 

  1773. 								array('field_data_translated'=>$encoded_data),
    1774. 

  1774. 								array('tid'=>$result->tid)
    1775. 

  1775. 							);
    1776. 

  1776. 					}
    1777. 

  1777. 				$count++;
    1778. 

  1778. 				}
    1779. 

  1779. 			}
    1780. 

  1780. 		}
    1781. 

  1781. 	}
    1782. 

  1782. 

  1783. 	/* TRANSLATIONS */
    1784. 

  1784. 	/* ******************************************************************************************** */
    1785. 

  1785. 	/**
    1786. 

  1786. 	* calculate post md5
    1787. 

  1787. 	*
    1788. 

  1788. 	* @param object|int $post
    1789. 

  1789. 	* @return string
    1790. 

  1790. 	*
    1791. 

  1791. 	* @todo full support for custom posts and custom taxonomies
    1792. 

  1792. 	*/
    1793. 

  1793. 	function post_md5($post){
    1794. 

  1794. 

  1795. 		if (isset($post->external_type) && $post->external_type) {
    1796. 

  1796. 

  1797. 			$md5str = '';
    1798. 

  1798. 

  1799. 			foreach ($post->string_data as $key => $value) {
    1800. 

  1800. 				$md5str .= $key . $value;
    1801. 

  1801. 			}
    1802. 

  1802. 

  1803. 

  1804. 		} else {
    1805. 

  1805. 

  1806. 			$post_tags = $post_categories = $custom_fields_values = array();
    1807. 

  1807. 

  1808. 			if(is_numeric($post)){
    1809. 

  1809. 				$post = get_post($post);
    1810. 

  1810. 			}
    1811. 

  1811. 

  1812. 			foreach(wp_get_object_terms($post->ID, 'post_tag') as $tag){
    1813. 

  1813. 				$post_tags[] = $tag->name;
    1814. 

  1814. 			}
    1815. 

  1815. 			if(is_array($post_tags)){
    1816. 

  1816. 				sort($post_tags, SORT_STRING);
    1817. 

  1817. 			}
    1818. 

  1818. 			foreach(wp_get_object_terms($post->ID, 'category') as $cat){
    1819. 

  1819. 				$post_categories[] = $cat->name;
    1820. 

  1820. 			}
    1821. 

  1821. 			if(is_array($post_categories)){
    1822. 

  1822. 				sort($post_categories, SORT_STRING);
    1823. 

  1823. 			}
    1824. 

  1824. 

  1825. 			global $wpdb, $sitepress_settings;
    1826. 

  1826. 			// get custom taxonomies
    1827. 

  1827. 			$taxonomies = $wpdb->get_col("
    1828. 

  1828. 				SELECT DISTINCT tx.taxonomy
    1829. 

  1829. 				FROM {$wpdb->term_taxonomy} tx JOIN {$wpdb->term_relationships} tr ON tx.term_taxonomy_id = tr.term_taxonomy_id
    1830. 

  1830. 				WHERE tr.object_id = {$post->ID}
    1831. 

  1831. 			");
    1832. 

    1833. 

  1833. 			sort($taxonomies, SORT_STRING);
    1834. 

  1834. 			foreach($taxonomies as $t){
    1835. 

  1835. 				if(taxonomy_exists($t)){
    1836. 

  1836. 					if(@intval($sitepress_settings['taxonomies_sync_option'][$t]) == 1){
    1837. 

  1837. 						$taxs = array();
    1838. 

  1838. 						foreach(wp_get_object_terms($post->ID, $t) as $trm){
    1839. 

  1839. 							$taxs[] = $trm->name;
    1840. 

  1840. 						}
    1841. 

  1841. 						if($taxs){
    1842. 

  1842. 							sort($taxs,SORT_STRING);
    1843. 

  1843. 							$all_taxs[] = '['.$t.']:'.join(',',$taxs);
    1844. 

  1844. 						}
    1845. 

  1845. 					}
    1846. 

  1846. 				}
    1847. 

  1847. 			}
    1848. 

  1848. 

  1849. 			$custom_fields_values = array();
    1850. 

  1850. 			if ( is_array( $this->settings['custom_fields_translation'] ) ) {
    1851. 

  1851. 				foreach ( $this->settings['custom_fields_translation'] as $cf => $op ) {
    1852. 

  1852. 					if ( $op == 2 || $op == 1 ) {
    1853. 

  1853. 						$value = get_post_meta( $post->ID, $cf, true );
    1854. 

  1854. 						if ( !is_array( $value ) && !is_object( $value ) ) {
    1855. 

  1855. 							$custom_fields_values[] = $value;
    1856. 

  1856. 						}
    1857. 

  1857. 					}
    1858. 

  1858. 				}
    1859. 

  1859. 			}
    1860. 

  1860. 

  1861. 			$md5str =
    1862. 

  1862. 				$post->post_title . ';' .
    1863. 

  1863. 				$post->post_content . ';' .
    1864. 

  1864. 				join(',',$post_tags).';' .
    1865. 

  1865. 				join(',',$post_categories) . ';' .
    1866. 

  1866. 				join(',', $custom_fields_values);
    1867. 

  1867. 

  1868. 			if(!empty($all_taxs)){
    1869. 

  1869. 				$md5str .= ';' . join(';', $all_taxs);
    1870. 

  1870. 			}
    1871. 

  1871. 

  1872. 			if($sitepress_settings['translated_document_page_url'] == 'translate'){
    1873. 

  1873. 				$md5str .=  $post->post_name . ';';
    1874. 

  1874. 			}
    1875. 

  1875. 

  1876. 

  1877. 		}
    1878. 

  1878. 

  1879. 		$md5 = md5($md5str);
    1880. 

  1880. 

  1881. 		return $md5;
    1882. 

  1882. 	}
    1883. 

  1883. 

  1884. 	/**
    1885. 

  1885. 	 * get documents
    1886. 

  1886. 	 *
    1887. 

  1887. 	 * @param array $args
    1888. 

  1888. 	 *
    1889. 

  1889. 	 * @return mixed
    1890. 

  1890. 	 */
    1891. 

  1891. 	function get_documents($args){
    1892. 

  1892. 

  1893. 

  1894. 		$parent_id = false;
    1895. 

  1895. 		$parent_all = false;
    1896. 

  1896. 		$to_lang = false;
    1897. 

  1897. 		$from_lang = false;
    1898. 

  1898. 		$tstatus = false;
    1899. 

  1899. 		$sort_by = false;
    1900. 

  1900. 		$sort_order = false;
    1901. 

  1901. 		$limit_no = 0;
    1902. 

  1902. 

  1903. 		extract($args);
    1904. 

  1904. 

  1905. 		global $wpdb, $wp_query, $sitepress;
    1906. 

  1906. 

  1907. 		$t_el_types = array_keys($sitepress->get_translatable_documents());
    1908. 

  1908. 

  1909. 		// SELECT
    1910. 

  1910. 		$select = " p.ID AS post_id, p.post_title, p.post_content, p.post_type, p.post_status, p.post_date, t.trid, t.source_language_code <> '' AS is_translation";
    1911. 

  1911. 		$active_languages = $sitepress->get_active_languages();
    1912. 

  1912. 		if($to_lang){
    1913. 

  1913. 			$select .= ", iclts.status, iclts.needs_update";
    1914. 

  1914. 		}else{
    1915. 

  1915. 			foreach( $active_languages as $lang){
    1916. 

  1916. 				if($lang['code'] == $from_lang) continue;
    1917. 

  1917. 				$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1918. 

  1918. 				$select .= ", iclts_{$tbl_alias_suffix}.status AS status_{$tbl_alias_suffix}, iclts_{$tbl_alias_suffix}.needs_update AS needs_update_{$tbl_alias_suffix}";
    1919. 

  1919. 			}
    1920. 

  1920. 		}
    1921. 

  1921. 

  1922. 		// FROM
    1923. 

  1923. 		$from   = " {$wpdb->posts} p";
    1924. 

  1924. 

  1925. 		// JOIN
    1926. 

  1926. 		$join = "";
    1927. 

  1927. 		$join   .= " LEFT JOIN {$wpdb->prefix}icl_translations t ON t.element_id=p.ID\n";
    1928. 

  1928. 		if($to_lang){
    1929. 

  1929. 			$tbl_alias_suffix = str_replace('-','_',$to_lang);
    1930. 

  1930. 			$join .= " LEFT JOIN {$wpdb->prefix}icl_translations iclt_{$tbl_alias_suffix}
    1931. 

  1931. 						ON iclt_{$tbl_alias_suffix}.trid=t.trid AND iclt_{$tbl_alias_suffix}.language_code='{$to_lang}'\n";
    1932. 

  1932. 			$join   .= " LEFT JOIN {$wpdb->prefix}icl_translation_status iclts ON iclts.translation_id=iclt_{$tbl_alias_suffix}.translation_id\n";
    1933. 

  1933. 		}else{
    1934. 

  1934. 			foreach( $active_languages as $lang){
    1935. 

  1935. 				if($lang['code'] == $from_lang) continue;
    1936. 

  1936. 				$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1937. 

  1937. 				$join .= " LEFT JOIN {$wpdb->prefix}icl_translations iclt_{$tbl_alias_suffix}
    1938. 

  1938. 						ON iclt_{$tbl_alias_suffix}.trid=t.trid AND iclt_{$tbl_alias_suffix}.language_code='{$lang['code']}'\n";
    1939. 

  1939. 				$join   .= " LEFT JOIN {$wpdb->prefix}icl_translation_status iclts_{$tbl_alias_suffix}
    1940. 

  1940. 						ON iclts_{$tbl_alias_suffix}.translation_id=iclt_{$tbl_alias_suffix}.translation_id\n";
    1941. 

  1941. 			}
    1942. 

  1942. 		}
    1943. 

  1943. 

  1944. 

  1945. 		// WHERE
    1946. 

  1946. 		$where = " t.language_code = '{$from_lang}' AND p.post_status NOT IN ('trash', 'auto-draft') \n";
    1947. 

  1947. 		if(!empty($type)){
    1948. 

  1948. 			$where .= " AND p.post_type = '{$type}'";
    1949. 

  1949. 			$where .= " AND t.element_type = 'post_{$type}'\n";
    1950. 

  1950. 		}else{
    1951. 

  1951. 			$where .= " AND p.post_type IN ('".join("','",$t_el_types)."')\n";
    1952. 

  1952. 			foreach($t_el_types as $k=>$v){
    1953. 

  1953. 				$t_el_types[$k] = 'post_' . $v;
    1954. 

  1954. 			}
    1955. 

  1955. 			$where .= " AND t.element_type IN ('".join("','",$t_el_types)."')\n";
    1956. 

  1956. 		}
    1957. 

  1957. 		if(!empty($title)){
    1958. 

  1958. 			$where .= " AND p.post_title LIKE '%".esc_sql($title)."%'\n";
    1959. 

  1959. 		}
    1960. 

  1960. 

  1961. 		if(!empty($status)){
    1962. 

  1962. 			$where .= " AND p.post_status = '{$status}'\n";
    1963. 

  1963. 		}
    1964. 

  1964. 

  1965. 		if(isset($from_date)){
    1966. 

  1966. 			$where .= " AND p.post_date > '{$from_date}'\n";
    1967. 

  1967. 		}
    1968. 

  1968. 

  1969. 		if(isset($to_date)){
    1970. 

  1970. 			$where .= " AND p.post_date > '{$to_date}'\n";
    1971. 

  1971. 		}
    1972. 

  1972. 

  1973. 		if($tstatus){
    1974. 

  1974. 			if($to_lang){
    1975. 

  1975. 				if($tstatus == 'not'){
    1976. 

  1976. 					$where .= " AND (iclts.status IS NULL OR iclts.status = ".ICL_TM_WAITING_FOR_TRANSLATOR." OR iclts.needs_update = 1)\n";
    1977. 

  1977. 				}elseif($tstatus == 'need-update'){
    1978. 

  1978. 					$where .= " AND iclts.needs_update = 1\n";
    1979. 

  1979. 				}elseif($tstatus == 'in_progress'){
    1980. 

  1980. 					$where .= " AND iclts.status = ".ICL_TM_IN_PROGRESS." AND iclts.needs_update = 0\n";
    1981. 

  1981. 				}elseif($tstatus == 'complete'){
    1982. 

  1982. 					$where .= " AND (iclts.status = ".ICL_TM_COMPLETE." OR iclts.status = ".ICL_TM_DUPLICATE.") AND iclts.needs_update = 0\n";
    1983. 

  1983. 				}
    1984. 

  1984. 

  1985. 			}elseif( $active_languages && count($active_languages)>1 ){
    1986. 

  1986. 				if($tstatus == 'not'){
    1987. 

  1987. 					$where .= " AND (";
    1988. 

  1988. 					$wheres = array();
    1989. 

  1989. 					foreach( $active_languages as $lang){
    1990. 

  1990. 						if($lang['code'] == $from_lang) continue;
    1991. 

  1991. 						$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1992. 

  1992. 						$wheres[] = "iclts_{$tbl_alias_suffix}.status IS NULL OR iclts_{$tbl_alias_suffix}.status = ".ICL_TM_WAITING_FOR_TRANSLATOR." OR iclts_{$tbl_alias_suffix}.needs_update = 1\n";
    1993. 

  1993. 					}
    1994. 

  1994. 					$where .= join(' OR ', $wheres) . ")";
    1995. 

  1995. 				}elseif($tstatus == 'need-update'){
    1996. 

  1996. 					$where .= " AND (";
    1997. 

  1997. 					$wheres = array();
    1998. 

  1998. 					foreach( $active_languages as $lang){
    1999. 

  1999. 						if($lang['code'] == $from_lang) continue;
    2000. 

  2000. 						$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    2001. 

  2001. 						$wheres[] = "iclts_{$tbl_alias_suffix}.needs_update = 1\n";
    2002. 

  2002. 					}
    2003. 

  2003. 					$where .= join(' OR ', $wheres) . ")";
    2004. 

  2004. 				}elseif($tstatus == 'in_progress'){
    2005. 

  2005. 					$where .= " AND (";
    2006. 

  2006. 					$wheres = array();
    2007. 

  2007. 					foreach( $active_languages as $lang){
    2008. 

  2008. 						if($lang['code'] == $from_lang) continue;
    2009. 

  2009. 						$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    2010. 

  2010. 						$wheres[] = "iclts_{$tbl_alias_suffix}.status = ".ICL_TM_IN_PROGRESS."\n";
    2011. 

  2011. 					}
    2012. 

  2012. 					$where .= join(' OR ', $wheres)  . ")";
    2013. 

  2013. 				}elseif($tstatus == 'complete'){
    2014. 

  2014. 					foreach( $active_languages as $lang){
    2015. 

  2015. 						if($lang['code'] == $from_lang) continue;
    2016. 

  2016. 						$tbl_alias_suffix = str_replace('-','_',$lang['code']);
    2017. 

  2017. 						$where .= " AND (iclts_{$tbl_alias_suffix}.status = ".ICL_TM_COMPLETE." OR iclts_{$tbl_alias_suffix}.status = ".ICL_TM_DUPLICATE.") AND iclts_{$tbl_alias_suffix}.needs_update = 0\n";
    2018. 

  2018. 					}
    2019. 

  2019. 				}
    2020. 

  2020. 			}
    2021. 

  2021. 		}
    2022. 

  2022. 

  2023. 		if(isset($parent_type) && $parent_type == 'page' && $parent_id > 0){
    2024. 

  2024. 			if($parent_all){
    2025. 

  2025. 				$children = icl_get_post_children_recursive($parent_id);
    2026. 

  2026. 				if(!$children) $children[] = -1;
    2027. 

  2027. 				$where .= ' AND p.ID IN (' . join(',', $children) . ')';
    2028. 

  2028. 			}else{
    2029. 

  2029. 				$where .= ' AND p.post_parent=' . intval($parent_id);
    2030. 

  2030. 			}
    2031. 

  2031. 		}
    2032. 

  2032. 

  2033. 		if(isset($parent_type) && $parent_type == 'category' && $parent_id > 0){
    2034. 

  2034. 			if($parent_all){
    2035. 

  2035. 				$children = icl_get_tax_children_recursive($parent_id);
    2036. 

  2036. 				$children[] = $parent_id;
    2037. 

  2037. 				$join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id
    2038. 

  2038. 							JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'
    2039. 

  2039. 							JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id IN(" . join(',', $children) . ")";
    2040. 

  2040. 			}else{
    2041. 

  2041. 				$join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id
    2042. 

  2042. 							JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'
    2043. 

  2043. 							JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id = " . intval($parent_id);
    2044. 

  2044. 			}
    2045. 

  2045. 		}
    2046. 

  2046. 

  2047. 		// ORDER
    2048. 

  2048. 		if($sort_by){
    2049. 

  2049. 			$order = " $sort_by ";
    2050. 

  2050. 		}else{
    2051. 

  2051. 			$order = " p.post_date DESC";
    2052. 

  2052. 		}
    2053. 

  2053. 		if($sort_order){
    2054. 

  2054. 			$order .= $sort_order;
    2055. 

  2055. 		}else{
    2056. 

  2056. 			$order .= 'DESC';
    2057. 

  2057. 		}
    2058. 

  2058. 

  2059. 

  2060. 

  2061. 		// LIMIT
    2062. 

  2062. 		if(!isset($_GET['paged'])) $_GET['paged'] = 1;
    2063. 

  2063. 		$offset = ($_GET['paged']-1)*$limit_no;
    2064. 

  2064. 		$limit = " " . $offset . ',' . $limit_no;
    2065. 

  2065. 

  2066. 

  2067. 		$sql = "
    2068. 

  2068. 			SELECT SQL_CALC_FOUND_ROWS {$select}
    2069. 

  2069. 			FROM {$from}
    2070. 

  2070. 			{$join}
    2071. 

  2071. 			WHERE {$where}
    2072. 

  2072. 			ORDER BY {$order}
    2073. 

  2073. 			LIMIT {$limit}
    2074. 

  2074. 		";
    2075. 

    2076. 

  2076. 		$results = $wpdb->get_results($sql);
    2077. 

  2077. 

  2078. 		$count = $wpdb->get_var("SELECT FOUND_ROWS()");
    2079. 

  2079. 

  2080. 		$wp_query->found_posts = $count;
    2081. 

  2081. 		$wp_query->query_vars['posts_per_page'] = $limit_no;
    2082. 

  2082. 		$wp_query->max_num_pages = ceil($wp_query->found_posts/$limit_no);
    2083. 

  2083. 

  2084. 		// post process
    2085. 

  2085. 		foreach($results as $k=>$v){
    2086. 

  2086. 			if($v->is_translation){
    2087. 

  2087. 				$source_language = $wpdb->get_var($wpdb->prepare("SELECT language_code FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND source_language_code IS NULL", $v->trid));
    2088. 

  2088. 				$_tmp = 'status_' . $source_language;
    2089. 

  2089. 				$v->$_tmp = ICL_TM_COMPLETE;
    2090. 

  2090. 			}
    2091. 

  2091. 		}
    2092. 

  2092. 

  2093. 		return $results;
    2094. 

  2094. 

  2095. 	}
    2096. 

  2096. 

  2097. 	function get_element_translation($element_id, $language, $element_type='post_post'){
    2098. 

  2098. 		global $wpdb, $sitepress;
    2099. 

  2099. 		$trid = $sitepress->get_element_trid($element_id, $element_type);
    2100. 

  2100. 		$translation = array();
    2101. 

  2101. 		if($trid){
    2102. 

  2102. 			$translation = $wpdb->get_row($wpdb->prepare("
    2103. 

  2103. 				SELECT *
    2104. 

  2104. 				FROM {$wpdb->prefix}icl_translations tr
    2105. 

  2105. 				JOIN {$wpdb->prefix}icl_translation_status ts ON tr.translation_id = ts.translation_id
    2106. 

  2106. 				WHERE tr.trid=%s AND tr.language_code='%s'
    2107. 

  2107. 			", $trid, $language));
    2108. 

  2108. 		}
    2109. 

  2109. 		return $translation;
    2110. 

  2110. 	}
    2111. 

  2111. 

  2112. 	function get_element_translations($element_id, $element_type='post_post', $service = false){
    2113. 

  2113. 		global $wpdb, $sitepress;
    2114. 

  2114. 		$trid = $sitepress->get_element_trid($element_id, $element_type);
    2115. 

  2115. 		$translations = array();
    2116. 

  2116. 		if($trid){
    2117. 

  2117. 			$service =  $service ? " AND translation_service = '$service'" : '';
    2118. 

  2118. 			$translations = $wpdb->get_results($wpdb->prepare("
    2119. 

  2119. 				SELECT *
    2120. 

  2120. 				FROM {$wpdb->prefix}icl_translations tr
    2121. 

  2121. 				JOIN {$wpdb->prefix}icl_translation_status ts ON tr.translation_id = ts.translation_id
    2122. 

  2122. 				WHERE tr.trid=%s {$service}
    2123. 

  2123. 			", $trid));
    2124. 

  2124. 			foreach($translations as $k=>$v){
    2125. 

  2125. 				$translations[$v->language_code] = $v;
    2126. 

  2126. 				unset($translations[$k]);
    2127. 

  2127. 			}
    2128. 

  2128. 		}
    2129. 

  2129. 		return $translations;
    2130. 

  2130. 	}
    2131. 

  2131. 

  2132. 	/**
    2133. 

  2133. 	 * returns icon file name according to status code
    2134. 

  2134. 	 *
    2135. 

  2135. 	 * @param int $status
    2136. 

  2136. 	 * @param int $needs_update
    2137. 

  2137. 	 *
    2138. 

  2138. 	 * @return string
    2139. 

  2139. 	 */
    2140. 

  2140. 	public function status2img_filename($status, $needs_update = 0){
    2141. 

  2141. 		if($needs_update){
    2142. 

  2142. 			$img_file = 'needs-update.png';
    2143. 

  2143. 		}else{
    2144. 

  2144. 			switch($status){
    2145. 

  2145. 				case ICL_TM_NOT_TRANSLATED: $img_file = 'not-translated.png'; break;
    2146. 

  2146. 				case ICL_TM_WAITING_FOR_TRANSLATOR: $img_file = 'in-progress.png'; break;
    2147. 

  2147. 				case ICL_TM_IN_PROGRESS: $img_file = 'in-progress.png'; break;
    2148. 

  2148. 				case ICL_TM_NEEDS_UPDATE: $img_file = 'needs-update.png'; break;
    2149. 

  2149. 				case ICL_TM_DUPLICATE: $img_file = 'copy.png'; break;
    2150. 

  2150. 				case ICL_TM_COMPLETE: $img_file = 'complete.png'; break;
    2151. 

  2151. 				default: $img_file = '';
    2152. 

  2152. 			}
    2153. 

  2153. 		}
    2154. 

  2154. 		return $img_file;
    2155. 

  2155. 	}
    2156. 

  2156. 

  2157. 	public function status2text($status){
    2158. 

  2158. 		switch($status){
    2159. 

  2159. 			case ICL_TM_NOT_TRANSLATED: $text = __('Not translated', 'sitepress'); break;
    2160. 

  2160. 			case ICL_TM_WAITING_FOR_TRANSLATOR: $text = __('Waiting for translator', 'sitepress'); break;
    2161. 

  2161. 			case ICL_TM_IN_PROGRESS: $text = __('In progress', 'sitepress'); break;
    2162. 

  2162. 			case ICL_TM_NEEDS_UPDATE: $text = __('Needs update', 'sitepress'); break;
    2163. 

  2163. 			case ICL_TM_DUPLICATE: $text = __('Duplicate', 'sitepress'); break;
    2164. 

  2164. 			case ICL_TM_COMPLETE: $text = __('Complete', 'sitepress'); break;
    2165. 

  2165. 			default: $text = '';
    2166. 

  2166. 		}
    2167. 

  2167. 		return $text;
    2168. 

  2168. 	}
    2169. 

  2169. 

  2170. 	public static function estimate_word_count($data, $lang_code){
    2171. 

  2171. 		global $asian_languages;
    2172. 

  2172. 

  2173. 		$words = 0;
    2174. 

  2174. 		if(isset($data->post_title)){
    2175. 

  2175. 			if(in_array($lang_code, $asian_languages)){
    2176. 

  2176. 				$words += strlen(strip_tags($data->post_title)) / 6;
    2177. 

  2177. 			} else {
    2178. 

  2178. 				$words += count(preg_split(
    2179. 

  2179. 					'/[\s\/]+/', $data->post_title, 0, PREG_SPLIT_NO_EMPTY));
    2180. 

  2180. 			}
    2181. 

  2181. 		}
    2182. 

  2182. 		if(isset($data->post_content)){
    2183. 

  2183. 			if(in_array($lang_code, $asian_languages)){
    2184. 

  2184. 				$words += strlen(strip_tags($data->post_content)) / 6;
    2185. 

  2185. 			} else {
    2186. 

  2186. 				$words += count(preg_split(
    2187. 

  2187. 					'/[\s\/]+/', strip_tags($data->post_content), 0, PREG_SPLIT_NO_EMPTY));
    2188. 

  2188. 			}
    2189. 

  2189. 		}
    2190. 

  2190. 

  2191. 		return (int)$words;
    2192. 

  2192. 

  2193. 	}
    2194. 

  2194. 

  2195. 	public static function estimate_custom_field_word_count( $post_id, $lang_code ) {
    2196. 

  2196. 		global $asian_languages, $sitepress_settings;
    2197. 

  2197. 

  2198. 		$words = 0;
    2199. 

  2199. 

  2200. 		if ( !empty( $sitepress_settings[ 'translation-management' ][ 'custom_fields_translation' ] ) && is_array( $sitepress_settings[ 'translation-management' ][ 'custom_fields_translation' ] ) ) {
    2201. 

  2201. 			$custom_fields = array();
    2202. 

  2202. 			foreach ( $sitepress_settings[ 'translation-management' ][ 'custom_fields_translation' ] as $cf => $op ) {
    2203. 

  2203. 				if ( $op == 2 ) {
    2204. 

  2204. 					$custom_fields[ ] = $cf;
    2205. 

  2205. 				}
    2206. 

  2206. 			}
    2207. 

  2207. 			foreach ( $custom_fields as $cf ) {
    2208. 

  2208. 				$custom_fields_value = get_post_meta( $post_id, $cf );
    2209. 

  2209. 				if ( $custom_fields_value ) {
    2210. 

  2210. 					if ( is_scalar( $custom_fields_value ) ) { // only support scalar values fo rnow
    2211. 

  2211. 						if ( in_array( $lang_code, $asian_languages ) ) {
    2212. 

  2212. 							$words += strlen( strip_tags( $custom_fields_value ) ) / 6;
    2213. 

  2213. 						} else {
    2214. 

  2214. 							$words += count( preg_split( '/[\s\/]+/', strip_tags( $custom_fields_value ), 0, PREG_SPLIT_NO_EMPTY ) );
    2215. 

  2215. 						}
    2216. 

  2216. 					} else {
    2217. 

  2217. 						foreach ( $custom_fields_value as $custom_fields_value_item ) {
    2218. 

  2218. 							if ( $custom_fields_value_item && is_scalar( $custom_fields_value_item ) ) { // only support scalar values fo rnow
    2219. 

  2219. 								if ( in_array( $lang_code, $asian_languages ) ) {
    2220. 

  2220. 									$words += strlen( strip_tags( $custom_fields_value_item ) ) / 6;
    2221. 

  2221. 								} else {
    2222. 

  2222. 									$words += count( preg_split( '/[\s\/]+/', strip_tags( $custom_fields_value_item ), 0, PREG_SPLIT_NO_EMPTY ) );
    2223. 

  2223. 								}
    2224. 

  2224. 							}
    2225. 

  2225. 						}
    2226. 

  2226. 					}
    2227. 

  2227. 				}
    2228. 

  2228. 			}
    2229. 

  2229. 		}
    2230. 

  2230. 

  2231. 		return (int)$words;
    2232. 

  2232. 	}
    2233. 

  2233. 

  2234. 	public static function decode_field_data($data, $format){
    2235. 

  2235. 		if($format == 'base64'){
    2236. 

  2236. 			$data = base64_decode($data);
    2237. 

  2237. 		}elseif($format == 'csv_base64'){
    2238. 

  2238. 			$exp = explode(',', $data);
    2239. 

  2239. 			foreach($exp as $k=>$e){
    2240. 

  2240. 				$exp[$k] = base64_decode(trim($e,'"'));
    2241. 

  2241. 			}
    2242. 

  2242. 			$data = $exp;
    2243. 

  2243. 		}
    2244. 

  2244. 		return $data;
    2245. 

  2245. 	}
    2246. 

  2246. 

  2247. 	public function encode_field_data($data, $format){
    2248. 

  2248. 		if($format == 'base64'){
    2249. 

  2249. 			$data = base64_encode($data);
    2250. 

  2250. 		}elseif($format == 'csv_base64'){
    2251. 

  2251. 			$exp = $data;
    2252. 

  2252. 			foreach($exp as $k=>$e){
    2253. 

  2253. 				$exp[$k] = '"' . base64_encode(trim($e)) . '"';
    2254. 

  2254. 			}
    2255. 

  2255. 			$data = join(',', $exp);
    2256. 

  2256. 		}
    2257. 

  2257. 		return $data;
    2258. 

  2258. 	}
    2259. 

  2259. 

  2260. 	/**
    2261. 

  2261. 	 * create translation package
    2262. 

  2262. 	 *
    2263. 

  2263. 	 * @param object|int $post
    2264. 

  2264. 	 *
    2265. 

  2265. 	 * @return array
    2266. 

  2266. 	 */
    2267. 

  2267. 	function create_translation_package($post){
    2268. 

  2268. 		global $sitepress, $sitepress_settings;
    2269. 

  2269. 

  2270. 		$package = array();
    2271. 

  2271. 

  2272. 

  2273. 		if(is_numeric($post)){
    2274. 

  2274. 			$post = get_post($post);
    2275. 

  2275. 		}
    2276. 

  2276. 

  2277. 		if (isset($post->external_type) && $post->external_type) {
    2278. 

  2278. 

  2279. 			foreach ($post->string_data as $key => $value) {
    2280. 

  2280. 				$package['contents'][$key] = array(
    2281. 

  2281. 					'translate' => 1,
    2282. 

  2282. 					'data'      => $this->encode_field_data($value, 'base64'),
    2283. 

  2283. 					'format'    => 'base64'
    2284. 

  2284. 				);
    2285. 

  2285. 			}
    2286. 

  2286. 

  2287. 			$package['contents']['original_id'] = array(
    2288. 

  2288. 				'translate' => 0,
    2289. 

  2289. 				'data'      => $post->post_id,
    2290. 

  2290. 			);
    2291. 

  2291. 		} else {
    2292. 

  2292. 			$home_url = get_home_url();
    2293. 

  2293. 			if($post->post_type=='page'){
    2294. 

  2294. 				$package['url'] = htmlentities( $home_url . '?page_id=' . ($post->ID));
    2295. 

  2295. 			}else{
    2296. 

  2296. 				$package['url'] = htmlentities( $home_url . '?p=' . ($post->ID));
    2297. 

  2297. 			}
    2298. 

  2298. 

  2299. 			$package['contents']['title'] = array(
    2300. 

  2300. 				'translate' => 1,
    2301. 

  2301. 				'data'      => $this->encode_field_data($post->post_title, 'base64'),
    2302. 

  2302. 				'format'    => 'base64'
    2303. 

  2303. 			);
    2304. 

  2304. 

  2305. 			if($sitepress_settings['translated_document_page_url'] == 'translate'){
    2306. 

  2306. 				$package['contents']['URL'] = array(
    2307. 

  2307. 					'translate' => 1,
    2308. 

  2308. 					'data'      => $this->encode_field_data($post->post_name, 'base64'),
    2309. 

  2309. 					'format'    => 'base64'
    2310. 

  2310. 				);
    2311. 

  2311. 			}
    2312. 

  2312. 

  2313. 			$package['contents']['body'] = array(
    2314. 

  2314. 				'translate' => 1,
    2315. 

  2315. 				'data'      => $this->encode_field_data($post->post_content, 'base64'),
    2316. 

  2316. 				'format'    => 'base64'
    2317. 

  2317. 			);
    2318. 

  2318. 

  2319. 			if(!empty($post->post_excerpt)){
    2320. 

  2320. 				$package['contents']['excerpt'] = array(
    2321. 

  2321. 					'translate' => 1,
    2322. 

  2322. 					'data'      => base64_encode($post->post_excerpt),
    2323. 

  2323. 					'format'    => 'base64'
    2324. 

  2324. 				);
    2325. 

  2325. 			}
    2326. 

  2326. 

  2327. 			$package['contents']['original_id'] = array(
    2328. 

  2328. 				'translate' => 0,
    2329. 

  2329. 				'data'      => $post->ID
    2330. 

  2330. 			);
    2331. 

  2331. 

  2332. 			if(!empty($this->settings['custom_fields_translation']))
    2333. 

  2333. 			foreach($this->settings['custom_fields_translation'] as $cf => $op){
    2334. 

  2334. 				if ($op == 2) { // translate
    2335. 

  2335. 

  2336. 					/* */
    2337. 

  2337. 					$custom_fields_value = get_post_meta($post->ID, $cf, true);
    2338. 

  2338. 					if ($custom_fields_value != '' && is_scalar($custom_fields_value)) {
    2339. 

  2339. 						$package['contents']['field-'.$cf] = array(
    2340. 

  2340. 							'translate' => 1,
    2341. 

  2341. 							'data' => $this->encode_field_data($custom_fields_value, 'base64'),
    2342. 

  2342. 							'format' => 'base64'
    2343. 

  2343. 						);
    2344. 

  2344. 						$package['contents']['field-'.$cf.'-name'] = array(
    2345. 

  2345. 							'translate' => 0,
    2346. 

  2346. 							'data' => $cf
    2347. 

  2347. 						);
    2348. 

  2348. 						$package['contents']['field-'.$cf.'-type'] = array(
    2349. 

  2349. 							'translate' => 0,
    2350. 

  2350. 							'data' => 'custom_field'
    2351. 

  2351. 						);
    2352. 

  2352. 					}
    2353. 

  2353. 				}
    2354. 

  2354. 			}
    2355. 

  2355. 

  2356. 			foreach((array)$sitepress->get_translatable_taxonomies(true, $post->post_type) as $taxonomy){
    2357. 

  2357. 				$terms = get_the_terms( $post->ID , $taxonomy );
    2358. 

  2358. 				if(!empty($terms)){
    2359. 

  2359. 					$_taxs = $_tax_ids = array();
    2360. 

  2360. 					foreach($terms as $term){
    2361. 

  2361. 						$_taxs[] = $term->name;
    2362. 

  2362. 						$_tax_ids[] = $term->term_taxonomy_id;
    2363. 

  2363. 					}
    2364. 

  2364. 					if($taxonomy == 'post_tag'){
    2365. 

  2365. 						$tax_package_key  = 'tags';
    2366. 

  2366. 						$tax_id_package_key  = 'tag_ids';
    2367. 

  2367. 					}
    2368. 

  2368. 					elseif($taxonomy == 'category'){
    2369. 

  2369. 						$tax_package_key  = 'categories';
    2370. 

  2370. 						$tax_id_package_key  = 'category_ids';
    2371. 

  2371. 					}
    2372. 

  2372. 					else{
    2373. 

  2373. 						$tax_package_key  = $taxonomy;
    2374. 

  2374. 						$tax_id_package_key  = $taxonomy . '_ids';
    2375. 

  2375. 					}
    2376. 

  2376. 

  2377. 					$package['contents'][$tax_package_key] = array(
    2378. 

  2378. 						'translate' => 1,
    2379. 

  2379. 						'data'      => $this->encode_field_data($_taxs,'csv_base64'),
    2380. 

  2380. 						'format'=>'csv_base64'
    2381. 

  2381. 					);
    2382. 

  2382. 

  2383. 					$package['contents'][$tax_id_package_key] = array(
    2384. 

  2384. 						'translate' => 0,
    2385. 

  2385. 						'data'      => join(',', $_tax_ids)
    2386. 

  2386. 					);
    2387. 

  2387. 				}
    2388. 

  2388. 			}
    2389. 

  2389. 		}
    2390. 

  2390. 		return $package;
    2391. 

  2391. 	}
    2392. 

  2392. 

  2393. 	/**
    2394. 

  2394. 	 * add/update icl_translation_status record
    2395. 

  2395. 	 *
    2396. 

  2396. 	 * @param array $data
    2397. 

  2397. 	 *
    2398. 

  2398. 	 * @return array
    2399. 

  2399. 	 */
    2400. 

  2400. 	function update_translation_status($data){
    2401. 

  2401. 		global $wpdb;
    2402. 

  2402. 		if(!isset($data['translation_id'])) return;
    2403. 

  2403. 		$rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $data['translation_id']));
    2404. 

  2404. 		if($rid){
    2405. 

  2405. 

  2406. 			$wpdb->update($wpdb->prefix.'icl_translation_status', $data, array('rid'=>$rid));
    2407. 

  2407. 

  2408. 			$update = true;
    2409. 

  2409. 		}else{
    2410. 

  2410. 			$wpdb->insert($wpdb->prefix.'icl_translation_status',$data);
    2411. 

  2411. 			$rid = $wpdb->insert_id;
    2412. 

  2412. 			$update = false;
    2413. 

  2413. 		}
    2414. 

  2414. 

  2415. 		return array($rid, $update);
    2416. 

  2416. 	}
    2417. 

  2417. 

  2418. 	function _get_post($post_id) {
    2419. 

  2419. 		if (is_string($post_id) && strcmp(substr($post_id, 0, strlen('external_')), 'external_')===0) {
    2420. 

  2420. 			$item = null;
    2421. 

  2421. 			return apply_filters('WPML_get_translatable_item', $item, $post_id);
    2422. 

  2422. 		} else {
    2423. 

  2423. 			return get_post($post_id);
    2424. 

  2424. 		}
    2425. 

  2425. 	}
    2426. 

  2426. 

  2427. 	/* TRANSLATION JOBS */
    2428. 

  2428. 	/* ******************************************************************************************** */
    2429. 

  2429. 

  2430. 	function send_jobs($data){
    2431. 

  2431. 		global $wpdb, $sitepress;
    2432. 

  2432. 

  2433. 		if(!isset($data['tr_action']) && isset($data['translate_to'])){ //adapt new format
    2434. 

  2434. 			$data['tr_action'] = $data['translate_to'];
    2435. 

  2435. 			unset($data['translate_to']);
    2436. 

  2436. 		}
    2437. 

  2437. 

  2438. 		/** @var $translate_from string */
    2439. 

  2439. 		// tr_action (translate_to)
    2440. 

  2440. 		// translator
    2441. 

  2441. 		// post
    2442. 

  2442. 		// service
    2443. 

  2443. 		// defaults
    2444. 

  2444. 		$data_default = array(
    2445. 

  2445. 			'translate_from'    => $sitepress->get_default_language()
    2446. 

  2446. 		);
    2447. 

  2447. 		extract($data_default);
    2448. 

  2448. 		extract($data, EXTR_OVERWRITE);
    2449. 

  2449. 

  2450. 		// no language selected ?
    2451. 

  2451. 		if(!isset($tr_action) || empty($tr_action)){
    2452. 

  2452. 			$this->messages[] = array(
    2453. 

  2453. 				'type'=>'error',
    2454. 

  2454. 				'text' => __('Please select at least one language to translate into.', 'sitepress')
    2455. 

  2455. 			);
    2456. 

  2456. 			$this->dashboard_select = $data; // prepopulate dashboard
    2457. 

  2457. 			return false;
    2458. 

  2458. 		}
    2459. 

  2459. 		// no post selected ?
    2460. 

  2460. 		if(!isset($iclpost) || empty($iclpost)){
    2461. 

  2461. 			$this->messages[] = array(
    2462. 

  2462. 				'type'=>'error',
    2463. 

  2463. 				'text' => __('Please select at least one document to translate.', 'sitepress')
    2464. 

  2464. 			);
    2465. 

  2465. 			$this->dashboard_select = $data; // pre-populate dashboard
    2466. 

  2466. 			return false;
    2467. 

  2467. 		}
    2468. 

  2468. 

  2469. 		$selected_posts = $iclpost;
    2470. 

  2470. 		$selected_translators = isset($translator) ? $translator : array();
    2471. 

  2471. 		$selected_languages = $tr_action;
    2472. 

  2472. 		$job_ids = array();
    2473. 

  2473. 

  2474. 		foreach($selected_posts as $post_id){
    2475. 

  2475. 			$post = $this->_get_post($post_id);
    2476. 

  2476. 			$post_trid = $sitepress->get_element_trid($post->ID, 'post_' . $post->post_type);
    2477. 

  2477. 			$post_translations = $sitepress->get_element_translations($post_trid, 'post_' . $post->post_type);
    2478. 

  2478. 			$md5 = $this->post_md5($post);
    2479. 

  2479. 

  2480. 			$translation_package = $this->create_translation_package($post);
    2481. 

  2481. 

  2482. 			foreach($selected_languages as $lang => $action){
    2483. 

  2483. 

  2484. 				// making this a duplicate?
    2485. 

  2485. 				if($action == 2){
    2486. 

  2486. 					// dont send documents that are in progress
    2487. 

  2487. 					$current_translation_status = $this->get_element_translation($post_id, $lang, 'post_' . $post->post_type);
    2488. 

  2488. 					if($current_translation_status && $current_translation_status->status == ICL_TM_IN_PROGRESS) continue;
    2489. 

  2489. 

  2490. 					$job_ids[] = $this->make_duplicate($post_id, $lang);
    2491. 

  2491. 				}elseif($action == 1){
    2492. 

  2492. 

  2493. 					if(empty($post_translations[$lang])){
    2494. 

  2494. 											$translation_id = $sitepress->set_element_language_details(null , 'post_' . $post->post_type, $post_trid, $lang, $translate_from);
    2495. 

  2495. 					}else{
    2496. 

  2496. 						$translation_id = $post_translations[$lang]->translation_id;
    2497. 

  2497. 					}
    2498. 

  2498. 

  2499. 					$current_translation_status = $this->get_element_translation($post_id, $lang, 'post_' . $post->post_type);
    2500. 

  2500. 

  2501. 					// don't send documents that are in progress
    2502. 

  2502. 					// don't send documents that are already translated and don't need update
    2503. 

  2503. 										// don't send documents that are waiting for translator
    2504. 

  2504. 					if(!empty($current_translation_status)){
    2505. 

  2505. 						if($current_translation_status->status == ICL_TM_IN_PROGRESS) continue;
    2506. 

  2506. 						if($current_translation_status->status == ICL_TM_COMPLETE && !$current_translation_status->needs_update) continue;
    2507. 

  2507. 												if($current_translation_status->status == ICL_TM_WAITING_FOR_TRANSLATOR) continue;
    2508. 

  2508. 					}
    2509. 

  2509. 

  2510. 					$_status = ICL_TM_WAITING_FOR_TRANSLATOR;
    2511. 

  2511. 

  2512. 					$_exp = isset($selected_translators[$lang]) ? explode('-', $selected_translators[$lang]) : false;
    2513. 

  2513. 					if(!isset($service)){
    2514. 

  2514. 						$translation_service = isset($_exp[1]) ? $_exp[1] : 'local';
    2515. 

  2515. 					}else{
    2516. 

  2516. 						$translation_service = $service;
    2517. 

  2517. 					}
    2518. 

  2518. 					$translator_id = $_exp[0];
    2519. 

  2519. 

  2520. 					// set as default translator
    2521. 

  2521. 					if($translator_id > 0){
    2522. 

  2522. 						$this->set_default_translator($translator_id, $translate_from, $lang, $translation_service);
    2523. 

  2523. 					}
    2524. 

  2524. 

  2525. 					// add translation_status record
    2526. 

  2526. 					$data = array(
    2527. 

  2527. 						'translation_id'        => $translation_id,
    2528. 

  2528. 						'status'                => $_status,
    2529. 

  2529. 						'translator_id'         => $translator_id,
    2530. 

  2530. 						'needs_update'          => 0,
    2531. 

  2531. 						'md5'                   => $md5,
    2532. 

  2532. 						'translation_service'   => $translation_service,
    2533. 

  2533. 						'translation_package'   => serialize($translation_package)
    2534. 

  2534. 					);
    2535. 

  2535. 

  2536. 					$_prevstate = $wpdb->get_row($wpdb->prepare("
    2537. 

  2537. 						SELECT status, translator_id, needs_update, md5, translation_service, translation_package, timestamp, links_fixed
    2538. 

  2538. 						FROM {$wpdb->prefix}icl_translation_status
    2539. 

  2539. 						WHERE translation_id = %d
    2540. 

  2540. 					", $translation_id), ARRAY_A);
    2541. 

  2541. 					if(!empty($_prevstate)){
    2542. 

  2542. 						$data['_prevstate'] = serialize($_prevstate);
    2543. 

  2543. 					}
    2544. 

  2544. 

  2545. 					list($rid, $update) = $this->update_translation_status($data);
    2546. 

  2546. 

  2547. 					$job_ids[] = $this->add_translation_job($rid, $translator_id, $translation_package);
    2548. 

  2548. 					if( $translation_service == 'icanlocalize' ){
    2549. 

  2549. 						global $ICL_Pro_Translation;
    2550. 

  2550. 						$sent = $ICL_Pro_Translation->send_post($post, array($lang), $translator_id);
    2551. 

  2551. 						if(!$sent){
    2552. 

  2552. 							$job_id = array_pop($job_ids);
    2553. 

  2553. 							$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id));
    2554. 

  2554. 							$wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}icl_translate_job SET revision = NULL WHERE rid=%d ORDER BY job_id DESC LIMIT 1", $rid));
    2555. 

  2555. 							$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id=%d", $job_id));
    2556. 

  2556. 						}
    2557. 

  2557. 					}
    2558. 

  2558. 				} // if / else is making a duplicate
    2559. 

  2559. 			}
    2560. 

  2560. 

  2561. 		}
    2562. 

  2562. 

  2563. 		$job_ids = array_unique($job_ids);
    2564. 

  2564. 		if(array(false) == $job_ids || empty($job_ids)){
    2565. 

  2565. 			$this->messages[] = array(
    2566. 

  2566. 				'type'=>'error',
    2567. 

  2567. 				'text' => __('No documents were sent to translation. Make sure that translations are not currently in progress or already translated for the selected language(s).', 'sitepress')
    2568. 

  2568. 			);
    2569. 

  2569. 		}elseif(in_array(false, $job_ids)){
    2570. 

  2570. 			$this->messages[] = array(
    2571. 

  2571. 				'type'=>'updated',
    2572. 

  2572. 				'text' => __('Some documents were sent to translation.', 'sitepress')
    2573. 

  2573. 			);
    2574. 

  2574. 			$this->messages[] = array(
    2575. 

  2575. 				'type'=>'error',
    2576. 

  2576. 				'text' => __('Some documents were <i>not</i> sent to translation. Make sure that translations are not currently in progress for the selected language(s).', 'sitepress')
    2577. 

  2577. 			);
    2578. 

  2578. 		}else{
    2579. 

  2579. 			$this->messages[] = array(
    2580. 

  2580. 				'type'=>'updated',
    2581. 

  2581. 				'text' => __('Selected document(s) sent to translation.', 'sitepress')
    2582. 

  2582. 			);
    2583. 

  2583. 		}
    2584. 

  2584. 

  2585. 		return $job_ids;
    2586. 

  2586. 	}
    2587. 

  2587. 

  2588. 	/**
    2589. 

  2589. 	 * Adds a translation job record in icl_translate_job
    2590. 

  2590. 	 *
    2591. 

  2591. 	 * @param mixed $rid
    2592. 

  2592. 	 * @param mixed $translator_id
    2593. 

  2593. 	 * @param       $translation_package
    2594. 

  2594. 	 *
    2595. 

  2595. 	 * @return bool|int
    2596. 

  2596. 	 */
    2597. 

  2597. 	function add_translation_job($rid, $translator_id, $translation_package){
    2598. 

  2598. 		global $wpdb, $current_user;
    2599. 

  2599. 		get_currentuserinfo();
    2600. 

  2600. 		if(!$current_user->ID){
    2601. 

  2601. 			$manager_id = $wpdb->get_var($wpdb->prepare("SELECT manager_id FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d ORDER BY job_id DESC LIMIT 1", $rid));
    2602. 

  2602. 		}else{
    2603. 

  2603. 			$manager_id = $current_user->ID;
    2604. 

  2604. 		}
    2605. 

  2605. 

  2606. 		$translation_status = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translation_status WHERE rid=%d", $rid));
    2607. 

  2607. 

  2608. 		// if we have a previous job_id for this rid mark it as the top (last) revision
    2609. 

  2609. 		list($prev_job_id, $prev_job_translated) = $wpdb->get_row($wpdb->prepare("
    2610. 

  2610. 					SELECT job_id, translated FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NULL
    2611. 

  2611. 		", $rid), ARRAY_N);
    2612. 

  2612. 			if ( !is_null( $prev_job_id ) ) {
    2613. 

  2613. 

  2614. 				// if previous job is not complete bail out
    2615. 

  2615. 				if ( !$prev_job_translated ) {
    2616. 

  2616. 					//trigger_error(sprintf(__('Translation is in progress for job: %s.', 'sitepress'), $prev_job_id), E_USER_NOTICE);
    2617. 

  2617. 					return false;
    2618. 

  2618. 				}
    2619. 

  2619. 

  2620. 				$last_rev = $wpdb->get_var( $wpdb->prepare( "
    2621. 

  2621. 				SELECT MAX(revision) AS rev FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NOT NULL
    2622. 

  2622. 			", $rid ) );
    2623. 

  2623. 				$wpdb->update( $wpdb->prefix . 'icl_translate_job', array( 'revision' => $last_rev + 1 ), array( 'job_id' => $prev_job_id ) );
    2624. 

  2624. 

  2625. 				$prev_job = $this->get_translation_job( $prev_job_id );
    2626. 

  2626. 

  2627. 				if ( isset( $prev_job->original_doc_id ) ) {
    2628. 

  2628. 					$original_post = get_post( $prev_job->original_doc_id );
    2629. 

  2629. 					foreach ( $prev_job->elements as $element ) {
    2630. 

  2630. 						$prev_translation[ $element->field_type ] = $element->field_data_translated;
    2631. 

  2631. 						switch ( $element->field_type ) {
    2632. 

  2632. 							case 'title':
    2633. 

  2633. 								if ( self::decode_field_data( $element->field_data, $element->field_format ) == $original_post->post_title ) {
    2634. 

  2634. 									//$unchanged[$element->field_type] = $element->field_data_translated;
    2635. 

  2635. 									$unchanged[ $element->field_type ] = true;
    2636. 

  2636. 								}
    2637. 

  2637. 								break;
    2638. 

  2638. 							case 'body':
    2639. 

  2639. 								if ( self::decode_field_data( $element->field_data, $element->field_format ) == $original_post->post_content ) {
    2640. 

  2640. 									//$unchanged[$element->field_type] = $element->field_data_translated;
    2641. 

  2641. 									$unchanged[ $element->field_type ] = true;
    2642. 

  2642. 								}
    2643. 

  2643. 								break;
    2644. 

  2644. 							case 'excerpt':
    2645. 

  2645. 								if ( self::decode_field_data( $element->field_data, $element->field_format ) == $original_post->post_excerpt ) {
    2646. 

  2646. 									//$unchanged[$element->field_type] = $element->field_data_translated;
    2647. 

  2647. 									$unchanged[ $element->field_type ] = true;
    2648. 

  2648. 								}
    2649. 

  2649. 								break;
    2650. 

  2650. 							case 'tags':
    2651. 

  2651. 								$terms = get_the_terms( $prev_job->original_doc_id, 'post_tag' );
    2652. 

  2652. 								$_taxs = array();
    2653. 

  2653. 								if ( $terms ) {
    2654. 

  2654. 									foreach ( $terms as $term ) {
    2655. 

  2655. 										$_taxs[ ] = $term->name;
    2656. 

  2656. 									}
    2657. 

  2657. 								}
    2658. 

  2658. 								if ( $element->field_data == $this->encode_field_data( $_taxs, $element->field_format ) ) {
    2659. 

  2659. 									//$unchanged['tags'] = $element->field_data_translated;
    2660. 

  2660. 									$unchanged[ 'tags' ] = true;
    2661. 

  2661. 								}
    2662. 

  2662. 								break;
    2663. 

  2663. 							case 'categories':
    2664. 

  2664. 								$terms = get_the_terms( $prev_job->original_doc_id, 'category' );
    2665. 

  2665. 								$_taxs = array();
    2666. 

  2666. 								if ( $terms ) {
    2667. 

  2667. 									foreach ( $terms as $term ) {
    2668. 

  2668. 										$_taxs[ ] = $term->name;
    2669. 

  2669. 									}
    2670. 

  2670. 								}
    2671. 

  2671. 								if ( $element->field_data == $this->encode_field_data( $_taxs, $element->field_format ) ) {
    2672. 

  2672. 									//$unchanged['categories'] = $element->field_data_translated;
    2673. 

  2673. 									$unchanged[ 'categories' ] = true;
    2674. 

  2674. 								}
    2675. 

  2675. 								break;
    2676. 

  2676. 							default:
    2677. 

  2677. 								if ( false !== strpos( $element->field_type, 'field-' ) && !empty( $this->settings[ 'custom_fields_translation' ] ) ) {
    2678. 

  2678. 									$cf_name = preg_replace( '#^field-#', '', $element->field_type );
    2679. 

  2679. 									if ( self::decode_field_data( $element->field_data, $element->field_format ) == get_post_meta( $prev_job->original_doc_id, $cf_name, 1 ) ) {
    2680. 

  2680. 										//$unchanged[$element->field_type] = $element->field_data_translated;
    2681. 

  2681. 										$unchanged[ $element->field_type ] = true;
    2682. 

  2682. 									}
    2683. 

  2683. 								} else {
    2684. 

  2684. 									// taxonomies
    2685. 

  2685. 									if ( taxonomy_exists( $element->field_type ) ) {
    2686. 

  2686. 										$terms = get_the_terms( $prev_job->original_doc_id, $element->field_type );
    2687. 

  2687. 										$_taxs = array();
    2688. 

  2688. 										if ( $terms ) {
    2689. 

  2689. 											foreach ( $terms as $term ) {
    2690. 

  2690. 												$_taxs[ ] = $term->name;
    2691. 

  2691. 											}
    2692. 

  2692. 										}
    2693. 

  2693. 										if ( $element->field_data == $this->encode_field_data( $_taxs, $element->field_format ) ) {
    2694. 

  2694. 											//$unchanged[$element->field_type] = $field['data_translated'];
    2695. 

  2695. 											$unchanged[ $element->field_type ] = true;
    2696. 

  2696. 										}
    2697. 

  2697. 									}
    2698. 

  2698. 								}
    2699. 

  2699. 						}
    2700. 

  2700. 					}
    2701. 

  2701. 				}
    2702. 

  2702. 			}
    2703. 

  2703. 

  2704. 		$wpdb->insert($wpdb->prefix . 'icl_translate_job', array(
    2705. 

  2705. 			'rid' => $rid,
    2706. 

  2706. 			'translator_id' => $translator_id,
    2707. 

  2707. 			'translated'    => 0,
    2708. 

  2708. 			'manager_id'    => $manager_id
    2709. 

  2709. 		));
    2710. 

  2710. 		$job_id = $wpdb->insert_id;
    2711. 

  2711. 

  2712. 		foreach($translation_package['contents'] as $field => $value){
    2713. 

  2713. 			$job_translate = array(
    2714. 

  2714. 				'job_id'            => $job_id,
    2715. 

  2715. 				'content_id'        => 0,
    2716. 

  2716. 				'field_type'        => $field,
    2717. 

  2717. 				'field_format'      => isset($value['format'])?$value['format']:'',
    2718. 

  2718. 				'field_translate'   => $value['translate'],
    2719. 

  2719. 				'field_data'        => $value['data'],
    2720. 

  2720. 				'field_data_translated' => isset($prev_translation[$field]) ? $prev_translation[$field] : '',
    2721. 

  2721. 				'field_finished'    => 0
    2722. 

  2722. 			);
    2723. 

  2723. 			if(isset($unchanged[$field])){
    2724. 

  2724. 				$job_translate['field_finished'] = 1;
    2725. 

  2725. 			}
    2726. 

  2726. 			//$job_translate['field_data_translated'] = $unchanged[$field];
    2727. 

  2727. 

  2728. 			$wpdb->insert($wpdb->prefix . 'icl_translate', $job_translate);
    2729. 

  2729. 		}
    2730. 

  2730. 

  2731. 		if($this->settings['doc_translation_method'] == ICL_TM_TMETHOD_EDITOR){ // only send notifications if the translation editor method is on
    2732. 

  2732. 			if(!defined('ICL_TM_DISABLE_ALL_NOTIFICATIONS') && $translation_status->translation_service=='local'){
    2733. 

  2733. 				if($this->settings['notification']['new-job'] == ICL_TM_NOTIFICATION_IMMEDIATELY){
    2734. 

  2734. 					require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    2735. 

  2735. 					if($job_id){
    2736. 

  2736. 						$tn_notification = new TM_Notification();
    2737. 

  2737. 						if(empty($translator_id)){
    2738. 

  2738. 							$tn_notification->new_job_any($job_id);
    2739. 

  2739. 						}else{
    2740. 

  2740. 							$tn_notification->new_job_translator($job_id, $translator_id);
    2741. 

  2741. 						}
    2742. 

  2742. 					}
    2743. 

  2743. 				}
    2744. 

  2744. 			}
    2745. 

  2745. 		}
    2746. 

  2746. 

  2747. 		return $job_id;
    2748. 

  2748. 

  2749. 	}
    2750. 

  2750. 

  2751. 	function assign_translation_job($job_id, $translator_id, $service='local'){
    2752. 

  2752. 		global $wpdb, $iclTranslationManagement;
    2753. 

  2753. 

  2754. 		// make sure TM is running
    2755. 

  2755. 		if(empty($this->settings)){
    2756. 

  2756. 			$iclTranslationManagement->init();
    2757. 

  2757. 		}
    2758. 

  2758. 

  2759. 		list($prev_translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
    2760. 

  2760. 

  2761. 		require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    2762. 

  2762. 		$tn_notification = new TM_Notification();
    2763. 

  2763. 		if($this->settings['notification']['resigned'] == ICL_TM_NOTIFICATION_IMMEDIATELY){
    2764. 

  2764. 			if(!empty($prev_translator_id) && $prev_translator_id != $translator_id){
    2765. 

  2765. 				if($job_id){
    2766. 

  2766. 					$tn_notification->translator_removed($prev_translator_id, $job_id);
    2767. 

  2767. 				}
    2768. 

  2768. 			}
    2769. 

  2769. 		}
    2770. 

  2770. 

  2771. 		if($this->settings['notification']['new-job'] == ICL_TM_NOTIFICATION_IMMEDIATELY){
    2772. 

  2772. 			if(empty($translator_id)){
    2773. 

  2773. 				$tn_notification->new_job_any($job_id);
    2774. 

  2774. 			}else{
    2775. 

  2775. 				$tn_notification->new_job_translator($job_id, $translator_id);
    2776. 

  2776. 			}
    2777. 

  2777. 		}
    2778. 

  2778. 

  2779. 		$wpdb->update($wpdb->prefix.'icl_translation_status',
    2780. 

  2780. 			array('translator_id'=>$translator_id, 'status'=>ICL_TM_WAITING_FOR_TRANSLATOR, 'translation_service' => $service),
    2781. 

  2781. 			array('rid'=>$rid));
    2782. 

  2782. 		$wpdb->update($wpdb->prefix.'icl_translate_job', array('translator_id'=>$translator_id), array('job_id'=>$job_id));
    2783. 

  2783. 		return true;
    2784. 

  2784. 	}
    2785. 

  2785. 

  2786. 	function get_translation_jobs($args = array()){
    2787. 

  2787. 		global $wpdb, $sitepress, $wp_query;
    2788. 

  2788. 

  2789. 		// defaults
    2790. 

  2790. 		/** @var $translator_id int */
    2791. 

  2791. 		/** @var $status int */
    2792. 

  2792. 		/** @var $include_unassigned bool */
    2793. 

  2793. 		/** @var $orderby bool|string */
    2794. 

  2794. 		/** @var $limit_no int */
    2795. 

  2795. 		$args_default = array(
    2796. 

  2796. 			'translator_id' => 0,
    2797. 

  2797. 			'status' => false,
    2798. 

  2798. 			'include_unassigned' => false
    2799. 

  2799. 		);
    2800. 

  2800. 

  2801. 		extract($args_default);
    2802. 

  2802. 		extract($args, EXTR_OVERWRITE);
    2803. 

  2803. 

  2804. 		$language_pairs = array();
    2805. 

  2805. 

  2806. 		$_exp = explode('-', $translator_id);
    2807. 

  2807. 		$service = isset($_exp[1]) ? $_exp[1] : 'local';
    2808. 

  2808. 		$translator_id = $_exp[0];
    2809. 

  2809. 

  2810. 		$where = " s.status > " . ICL_TM_NOT_TRANSLATED;
    2811. 

  2811. 		if($status != ''){
    2812. 

  2812. 			$where .= " AND s.status=" . intval($status);
    2813. 

  2813. 		}
    2814. 

  2814. 		if($status != ICL_TM_DUPLICATE){
    2815. 

  2815. 			$where .= " AND s.status <> " . ICL_TM_DUPLICATE;
    2816. 

  2816. 		}
    2817. 

  2817. 		if(!empty($translator_id)){
    2818. 

  2818. 			if($include_unassigned){
    2819. 

  2819. 				$where .= " AND (j.translator_id=" . intval($translator_id) . " OR j.translator_id=0) ";
    2820. 

  2820. 			}else{
    2821. 

  2821. 				$where .= " AND j.translator_id=" . intval($translator_id);
    2822. 

  2822. 			}
    2823. 

  2823. 			if(!empty($service)){
    2824. 

  2824. 				$where .= " AND s.translation_service='{$service}'";
    2825. 

  2825. 			}
    2826. 

  2826. 

  2827. 			$language_pairs = get_user_meta($translator_id, $wpdb->prefix.'language_pairs', true);
    2828. 

  2828. 		}
    2829. 

  2829. 

  2830. 		// HANDLE FROM
    2831. 

  2831. 		if(!empty($from)){
    2832. 

  2832. 			$where .= PHP_EOL . " AND t.source_language_code='".esc_sql($from)."'";
    2833. 

  2833. 		}else{
    2834. 

  2834. 			// only if we filter by translator, make sure to use just the 'from' languages that apply
    2835. 

  2835. 			// in no translator_id, ommit condition and all will be pulled
    2836. 

  2836. 			if($translator_id){
    2837. 

  2837. 				if(!empty($to)){
    2838. 

  2838. 					// get 'from' languages corresdonding to $to (to $translator_id)
    2839. 

  2839. 					$from_languages = array();
    2840. 

  2840. 					foreach($language_pairs as $fl => $tls){
    2841. 

  2841. 						if(isset($tls[$to])) $from_languages[] = $fl;
    2842. 

  2842. 					}
    2843. 

  2843. 					if($from_languages){
    2844. 

  2844. 						$where .= PHP_EOL . sprintf(" AND t.source_language_code IN(%s)", "'" . join("','", $from_languages) . "'");
    2845. 

  2845. 					}
    2846. 

  2846. 				}else{
    2847. 

  2847. 					// all to all case
    2848. 

  2848. 					// get all possible combinations for $translator_id
    2849. 

  2849. 					$from_languages = array_keys($language_pairs);
    2850. 

  2850. 					$where_conditions = array();
    2851. 

  2851. 					foreach($from_languages as $fl){
    2852. 

  2852. 						$to_languages = "'" . join("','", array_keys($language_pairs[$fl])) . "'";
    2853. 

  2853. 						$where_conditions[] = sprintf(" (t.source_language_code='%s' AND t.language_code IN (%s)) ", $fl, $to_languages);
    2854. 

  2854. 					}
    2855. 

  2855. 					if(!empty($where_conditions)){
    2856. 

  2856. 						$where .= PHP_EOL . ' AND ( ' . join (' OR ', $where_conditions) . ')';
    2857. 

  2857. 					}
    2858. 

  2858. 				}
    2859. 

  2859. 			}
    2860. 

  2860. 

  2861. 		}
    2862. 

  2862. 

  2863. 		// HANDLE TO
    2864. 

  2864. 		if(!empty($to)){
    2865. 

  2865. 			$where .= PHP_EOL . " AND t.language_code='".esc_sql($to)."'";
    2866. 

  2866. 		}else{
    2867. 

  2867. 			// only if we filter by translator, make sure to use just the 'from' languages that apply
    2868. 

  2868. 			// in no translator_id, omit condition and all will be pulled
    2869. 

  2869. 			if($translator_id){
    2870. 

  2870. 				if(!empty($from)){
    2871. 

  2871. 					// get languages the user can translate into from $from
    2872. 

  2872. 					$tos = isset($language_pairs[$from]) ? array_keys($language_pairs[$from]) : array();
    2873. 

  2873. 					if($tos){
    2874. 

  2874. 						$where .= PHP_EOL . sprintf(" AND t.language_code IN(%s)", "'" . join("','", $tos) . "'");
    2875. 

  2875. 					}
    2876. 

  2876. 				}else{
    2877. 

  2877. 					// covered by 'all to all case' above
    2878. 

  2878. 				}
    2879. 

  2879. 			}
    2880. 

  2880. 		}
    2881. 

  2881. 

  2882. 		// ORDER BY
    2883. 

  2883. 		if($include_unassigned){
    2884. 

  2884. 			$orderby[] = 'j.translator_id DESC';
    2885. 

  2885. 		}
    2886. 

  2886. 		$orderby[] = ' j.job_id DESC ';
    2887. 

  2887. 		$orderby = join(', ', $orderby);
    2888. 

  2888. 

  2889. 		// LIMIT
    2890. 

  2890. 		if(!isset($_GET['paged'])) $_GET['paged'] = 1;
    2891. 

  2891. 		$offset = ($_GET['paged']-1)*$limit_no;
    2892. 

  2892. 		$limit = " " . $offset . ',' . $limit_no;
    2893. 

  2893. 

  2894. 		$jobs = $wpdb->get_results(
    2895. 

  2895. 			"SELECT SQL_CALC_FOUND_ROWS
    2896. 

  2896. 				j.job_id, t.trid, t.language_code, t.source_language_code,
    2897. 

  2897. 				s.translation_id, s.status, s.needs_update, s.translator_id, u.display_name AS translator_name, s.translation_service
    2898. 

  2898. 				FROM {$wpdb->prefix}icl_translate_job j
    2899. 

  2899. 					JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    2900. 

  2900. 					JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id
    2901. 

  2901. 					LEFT JOIN {$wpdb->users} u ON s.translator_id = u.ID
    2902. 

  2902. 				WHERE {$where} AND revision IS NULL
    2903. 

  2903. 				ORDER BY {$orderby}
    2904. 

  2904. 				LIMIT {$limit}
    2905. 

  2905. 			"
    2906. 

  2906. 		);
    2907. 

  2907. 

  2908. 

  2909. 		//echo '<pre>';
    2910. 

  2910. 		//print_r($wpdb->last_query);
    2911. 

  2911. 		//echo '</pre>';
    2912. 

  2912. 

  2913. 		$count = $wpdb->get_var("SELECT FOUND_ROWS()");
    2914. 

  2914. 

  2915. 		$wp_query->found_posts = $count;
    2916. 

  2916. 		$wp_query->query_vars['posts_per_page'] = $limit_no;
    2917. 

  2917. 		$wp_query->max_num_pages = ceil($wp_query->found_posts/$limit_no);
    2918. 

  2918. 

  2919. 		foreach($jobs as $k=>$row){
    2920. 

  2920. 			//original
    2921. 

  2921. 			$post_id = $wpdb->get_var($wpdb->prepare("
    2922. 

  2922. 													 SELECT field_data
    2923. 

  2923. 													 FROM {$wpdb->prefix}icl_translate
    2924. 

  2924. 													 WHERE job_id=%d and field_type='original_id'", $row->job_id));
    2925. 

    2926. 

  2926. 			$parts = explode('_', $post_id);
    2927. 

  2927. 			if ($parts[0] == 'external') {
    2928. 

  2928. 				$jobs[$k]->original_doc_id = $post_id;
    2929. 

  2929. 

  2930. 				$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("
    2931. 

  2931. 														 SELECT field_data
    2932. 

  2932. 														 FROM {$wpdb->prefix}icl_translate
    2933. 

  2933. 														 WHERE job_id=%d and field_type='name'", $row->job_id)));
    2934. 

  2934. 				if ($jobs[$k]->post_title == "") {
    2935. 

  2935. 					// try the title field.
    2936. 

  2936. 					$jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("
    2937. 

  2937. 														 SELECT field_data
    2938. 

  2938. 														 FROM {$wpdb->prefix}icl_translate
    2939. 

  2939. 														 WHERE job_id=%d and field_type='title'", $row->job_id)));
    2940. 

  2940. 				}
    2941. 

  2941. 				
    2942. 

  2942. 				$jobs[$k]->post_title = apply_filters('WPML_translation_job_title', $jobs[$k]->post_title, $post_id);
    2943. 

  2943. 

  2944. 				$jobs[$k]->edit_link = self::tm_post_link($post_id);
    2945. 

  2945. 				$ldf = $sitepress->get_language_details($row->source_language_code);
    2946. 

  2946. 			} else {
    2947. 

  2947. 				$doc = $wpdb->get_row($wpdb->prepare("SELECT ID, post_title, post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));
    2948. 

  2948. 				if ($doc) {
    2949. 

  2949. 					$jobs[$k]->post_title = $doc->post_title;
    2950. 

  2950. 					$jobs[$k]->original_doc_id = $doc->ID;
    2951. 

  2951. 					$jobs[$k]->edit_link = get_edit_post_link($doc->ID);
    2952. 

  2952. 					$ldf = $sitepress->get_language_details($sitepress->get_element_language_details($post_id, 'post_' . $doc->post_type)->language_code);
    2953. 

  2953. 				} else {
    2954. 

  2954. 					$jobs[$k]->post_title = __("The original has been deleted!", "sitepress");
    2955. 

  2955. 					$jobs[$k]->original_doc_id = 0;
    2956. 

  2956. 					$jobs[$k]->edit_link = "";
    2957. 

  2957. 					$ldf['display_name'] = __("Deleted", "sitepress");
    2958. 

  2958. 				}
    2959. 

  2959. 			}
    2960. 

  2960. 			$ldt = $sitepress->get_language_details($row->language_code);
    2961. 

  2961. 			$jobs[$k]->lang_text = $ldf['display_name'] . ' &raquo; ' . $ldt['display_name'];
    2962. 

  2962. 			if($row->translation_service=='icanlocalize'){
    2963. 

  2963. 				$row->translator_name = ICL_Pro_Translation::get_translator_name($row->translator_id);
    2964. 

  2964. 			}
    2965. 

  2965. 		}
    2966. 

  2966. 	   return $jobs;
    2967. 

  2967. 

  2968. 	}
    2969. 

  2969. 

  2970. 	function get_translation_job($job_id, $include_non_translatable_elements = false, $auto_assign = false, $revisions = 0){
    2971. 

  2971. 		global $wpdb, $sitepress, $current_user;
    2972. 

  2972. 		get_currentuserinfo();
    2973. 

  2973. 		$job = $wpdb->get_row($wpdb->prepare("
    2974. 

  2974. 			SELECT
    2975. 

  2975. 				j.rid, j.translator_id, j.translated, j.manager_id,
    2976. 

  2976. 				s.status, s.needs_update, s.translation_service,
    2977. 

  2977. 				t.trid, t.language_code, t.source_language_code
    2978. 

  2978. 			FROM {$wpdb->prefix}icl_translate_job j
    2979. 

  2979. 				JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    2980. 

  2980. 				JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id
    2981. 

  2981. 			WHERE j.job_id = %d", $job_id));
    2982. 

  2982. 								
    2983. 

  2983. 				if (!$job) {
    2984. 

  2984. 					return false;
    2985. 

  2985. 				}
    2986. 

  2986. 

  2987. 		$post_id = $wpdb->get_var($wpdb->prepare("
    2988. 

  2988. 												 SELECT field_data
    2989. 

  2989. 												 FROM {$wpdb->prefix}icl_translate
    2990. 

  2990. 												 WHERE job_id=%d and field_type='original_id'", $job_id));
    2991. 

    2992. 

  2992. 		$parts = explode('_', $post_id);
    2993. 

  2993. 		if ($parts[0] == 'external') {
    2994. 

  2994. 			$job->original_doc_id = $post_id;
    2995. 

  2995. 			$job->original_doc_title = base64_decode($wpdb->get_var($wpdb->prepare("
    2996. 

  2996. 													 SELECT field_data
    2997. 

  2997. 													 FROM {$wpdb->prefix}icl_translate
    2998. 

  2998. 													 WHERE job_id=%d and field_type='name'", $job_id)));
    2999. 

  2999. 			if ($job->original_doc_title == "") {
    3000. 

  3000. 				// try the title field.
    3001. 

  3001. 				$job->original_doc_title = base64_decode($wpdb->get_var($wpdb->prepare("
    3002. 

  3002. 														 SELECT field_data
    3003. 

  3003. 														 FROM {$wpdb->prefix}icl_translate
    3004. 

  3004. 														 WHERE job_id=%d and field_type='title'", $job_id)));
    3005. 

  3005. 			}
    3006. 

  3006. 			$job->original_post_type = $wpdb->get_var($wpdb->prepare("
    3007. 

  3007. 																	 SELECT element_type
    3008. 

  3008. 																	 FROM {$wpdb->prefix}icl_translations
    3009. 

  3009. 																	 WHERE trid=%d AND language_code=%s",
    3010. 

  3010. 																	 $job->trid, $job->source_language_code));
    3011. 

  3011. 		} else {
    3012. 

  3012. 

  3013. 			$original = $wpdb->get_row($wpdb->prepare("
    3014. 

  3014. 				SELECT t.element_id, p.post_title, p.post_type
    3015. 

  3015. 				FROM {$wpdb->prefix}icl_translations t
    3016. 

  3016. 				JOIN {$wpdb->posts} p ON t.element_id = p.ID AND t.trid = %d
    3017. 

  3017. 				WHERE t.source_language_code IS NULL", $job->trid));
    3018. 

    3019. 

  3019. 			if($original){
    3020. 

  3020. 				$job->original_doc_title = $original->post_title;
    3021. 

  3021. 				$job->original_doc_id = $original->element_id;
    3022. 

  3022. 				$job->original_post_type = $original->post_type;
    3023. 

  3023. 			}
    3024. 

  3024. 		}
    3025. 

  3025. 

  3026. 		$_ld = $sitepress->get_language_details($job->source_language_code);
    3027. 

  3027. 		$job->from_language = $_ld['display_name'];
    3028. 

  3028. 		$_ld = $sitepress->get_language_details($job->language_code);
    3029. 

  3029. 		$job->to_language = $_ld['display_name'];
    3030. 

  3030. 

  3031. 		if(!$include_non_translatable_elements){
    3032. 

  3032. 			$jelq = ' AND field_translate = 1';
    3033. 

  3033. 		}else{
    3034. 

  3034. 			$jelq = '';
    3035. 

  3035. 		}
    3036. 

  3036. 		$job->elements = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translate WHERE job_id = %d {$jelq} ORDER BY tid ASC", $job_id));
    3037. 

  3037. 		if($job->translator_id == 0 || $job->status == ICL_TM_WAITING_FOR_TRANSLATOR){
    3038. 

  3038. 			if($auto_assign){
    3039. 

  3039. 				$wpdb->update($wpdb->prefix . 'icl_translate_job', array('translator_id' => $this->current_translator->translator_id), array('job_id'=>$job_id));
    3040. 

  3040. 				$wpdb->update($wpdb->prefix . 'icl_translation_status',
    3041. 

  3041. 					array('translator_id' => $this->current_translator->translator_id, 'status' => ICL_TM_IN_PROGRESS),
    3042. 

  3042. 					array('rid'=>$job->rid)
    3043. 

  3043. 				);
    3044. 

  3044. 			}
    3045. 

  3045. 		} elseif ( $job->translator_id != @intval( $this->current_translator->translator_id ) && !defined( 'XMLRPC_REQUEST' ) && $job->manager_id != $current_user->ID ) {
    3046. 

  3046. 			// Returns the job for admin users
    3047. 

  3047. 			if ( $this->is_translator($current_user->ID) ) {
    3048. 

  3048. 				return $job;
    3049. 

  3049. 			} else {
    3050. 

  3050. 				static $erroronce = array();
    3051. 

  3051. 				if ( empty( $erroronce[ $job_id ] ) ) {
    3052. 

  3052. 					$this->messages[ ]    = array(
    3053. 

  3053. 						'type' => 'error',
    3054. 

  3054. 						'text' => sprintf( __( "You can't translate this document. It's assigned to a different translator.<br /> Document: <strong>%s</strong> (ID = %d).", 'sitepress' ), $job->original_doc_title, $job_id )
    3055. 

  3055. 					);
    3056. 

  3056. 					$erroronce[ $job_id ] = true;
    3057. 

  3057. 				}
    3058. 

  3058. 

  3059. 				return false;
    3060. 

  3060. 			}
    3061. 

  3061. 		}
    3062. 

  3062. 

  3063. 		//do we have a previous version
    3064. 

  3064. 		if($revisions > 0){
    3065. 

  3065. 			$prev_version_job_id = $wpdb->get_var($wpdb->prepare("
    3066. 

  3066. 				SELECT MAX(job_id)
    3067. 

  3067. 				FROM {$wpdb->prefix}icl_translate_job
    3068. 

  3068. 				WHERE rid=%d AND job_id < %d", $job->rid, $job_id));
    3069. 

  3069. 			if($prev_version_job_id){
    3070. 

  3070. 				$job->prev_version = $this->get_translation_job($prev_version_job_id, false, false, $revisions - 1);
    3071. 

  3071. 			}
    3072. 

  3072. 

  3073. 		}
    3074. 

  3074. 

  3075. 		// allow adding custom elements
    3076. 

  3076. 		$job->elements = apply_filters('icl_job_elements', $job->elements, $post_id, $job_id);
    3077. 

  3077. 

  3078. 		return $job;
    3079. 

  3079. 	}
    3080. 

  3080. 

  3081. 	function get_translation_job_id($trid, $language_code){
    3082. 

  3082. 		global $wpdb, $sitepress;
    3083. 

  3083. 

  3084. 		$job_id = $wpdb->get_var($wpdb->prepare("
    3085. 

  3085. 			SELECT tj.job_id FROM {$wpdb->prefix}icl_translate_job tj
    3086. 

  3086. 				JOIN {$wpdb->prefix}icl_translation_status ts ON tj.rid = ts.rid
    3087. 

  3087. 				JOIN {$wpdb->prefix}icl_translations t ON ts.translation_id = t.translation_id
    3088. 

  3088. 				WHERE t.trid = %d AND t.language_code='%s'
    3089. 

  3089. 				ORDER BY tj.job_id DESC LIMIT 1
    3090. 

  3090. 		", $trid, $language_code));
    3091. 

    3092. 

  3092. 		return $job_id;
    3093. 

  3093. 	}
    3094. 

  3094. 

  3095. 	function _save_translation_field($tid, $field){
    3096. 

  3096. 		global $wpdb;
    3097. 

  3097. 		$update['field_data_translated'] = $this->encode_field_data($field['data'], $field['format']);
    3098. 

  3098. 		if(isset($field['finished']) && $field['finished']){
    3099. 

  3099. 			$update['field_finished'] = 1;
    3100. 

  3100. 		}
    3101. 

  3101. 		$wpdb->update($wpdb->prefix . 'icl_translate', $update, array('tid'=>$tid));
    3102. 

  3102. 	}
    3103. 

  3103. 

  3104. 	function save_translation($data){
    3105. 

  3105. 		global $wpdb, $sitepress, $sitepress_settings, $ICL_Pro_Translation;
    3106. 

  3106. 

  3107. 				$new_post_id = false;
    3108. 

  3108. 		$is_incomplete = false;
    3109. 

  3109. 		foreach($data['fields'] as $field){
    3110. 

  3110. 			$this->_save_translation_field($field['tid'], $field);
    3111. 

  3111. 			if(!isset($field['finished']) || !$field['finished']){
    3112. 

  3112. 				$is_incomplete = true;
    3113. 

  3113. 			}
    3114. 

  3114. 		}
    3115. 

  3115. 

  3116. 		//check if translation job still exists
    3117. 

  3117. 		$job_count = $wpdb->get_var( $wpdb->prepare( "SELECT count(1) FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $data[ 'job_id' ] ) );
    3118. 

  3118. 		if ( $job_count == 0 ) {
    3119. 

  3119. 			wp_redirect( admin_url( sprintf( 'admin.php?page=%s', WPML_TM_FOLDER . '/menu/translations-queue.php', 'job-cancelled' ) ) );
    3120. 

  3120. 			exit;
    3121. 

  3121. 		}
    3122. 

  3122. 

  3123. 		if(!empty($data['complete']) && !$is_incomplete){
    3124. 

  3124. 			$wpdb->update($wpdb->prefix . 'icl_translate_job', array('translated'=>1), array('job_id'=>$data['job_id']));
    3125. 

  3125. 			$rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $data['job_id']));
    3126. 

  3126. 			$translation_id = $wpdb->get_var($wpdb->prepare("SELECT translation_id FROM {$wpdb->prefix}icl_translation_status WHERE rid=%d", $rid));
    3127. 

  3127. 			$wpdb->update($wpdb->prefix . 'icl_translation_status', array('status'=>ICL_TM_COMPLETE, 'needs_update'=>0), array('rid'=>$rid));
    3128. 

  3128. 			list($element_id, $trid) = $wpdb->get_row($wpdb->prepare("SELECT element_id, trid FROM {$wpdb->prefix}icl_translations WHERE translation_id=%d", $translation_id), ARRAY_N);
    3129. 

  3129. 			$job = $this->get_translation_job($data['job_id'], true);
    3130. 

  3130. 

  3131. 			$parts = explode('_', $job->original_doc_id);
    3132. 

  3132. 			if ($parts[0] == 'external') {
    3133. 

  3133. 

  3134. 				// Translations are saved in the string table for 'external' types
    3135. 

  3135. 

  3136. 				$id = array_pop($parts);
    3137. 

  3137. 				unset($parts[0]);
    3138. 

  3138. 				$type = implode('_', $parts);
    3139. 

  3139. 				$type = apply_filters('WPML_get_package_type', $type, $job->original_doc_id);
    3140. 

  3140. 

  3141. 				foreach($job->elements as $field){
    3142. 

  3142. 					if ($field->field_translate) {
    3143. 

  3143. 						if (function_exists('icl_st_is_registered_string')) {
    3144. 

  3144. 							$string_id = icl_st_is_registered_string($type, $id . '_' . $field->field_type);
    3145. 

  3145. 							if (!$string_id) {
    3146. 

  3146. 								icl_register_string($type, $id . '_' . $field->field_type, self::decode_field_data($field->field_data, $field->field_format));
    3147. 

  3147. 								$string_id = icl_st_is_registered_string($type, $id . '_' . $field->field_type);
    3148. 

  3148. 							}
    3149. 

  3149. 							if ($string_id) {
    3150. 

  3150. 								icl_add_string_translation($string_id, $job->language_code, self::decode_field_data($field->field_data_translated, $field->field_format), ICL_STRING_TRANSLATION_COMPLETE);
    3151. 

  3151. 							}
    3152. 

  3152. 						}
    3153. 

  3153. 					}
    3154. 

  3154. 				}
    3155. 

  3155. 

  3156. 			} else {
    3157. 

  3157. 

  3158. 				if(!is_null($element_id)){
    3159. 

  3159. 					$postarr['ID'] = $_POST['post_ID'] = $element_id;
    3160. 

  3160. 				}
    3161. 

  3161. 

  3162. 				foreach($job->elements as $field){
    3163. 

  3163. 					switch($field->field_type){
    3164. 

  3164. 						case 'title':
    3165. 

  3165. 							$postarr['post_title'] = self::decode_field_data($field->field_data_translated, $field->field_format);
    3166. 

  3166. 							break;
    3167. 

  3167. 						case 'body':
    3168. 

  3168. 							$postarr['post_content'] = self::decode_field_data($field->field_data_translated, $field->field_format);
    3169. 

  3169. 							break;
    3170. 

  3170. 						case 'excerpt':
    3171. 

  3171. 							$postarr['post_excerpt'] = self::decode_field_data($field->field_data_translated, $field->field_format);
    3172. 

  3172. 							break;
    3173. 

  3173. 						case 'URL':
    3174. 

  3174. 							$postarr['post_name'] = self::decode_field_data($field->field_data_translated, $field->field_format);
    3175. 

  3175. 							break;
    3176. 

  3176. 						default:
    3177. 

  3177. 							break;
    3178. 

  3178. 					}
    3179. 

  3179. 				}
    3180. 

  3180. 

  3181. 				$original_post = get_post($job->original_doc_id);
    3182. 

  3182. 

  3183. 				$postarr['post_author'] = $original_post->post_author;
    3184. 

  3184. 				$postarr['post_type'] = $original_post->post_type;
    3185. 

  3185. 

  3186. 				if($sitepress_settings['sync_comment_status']){
    3187. 

  3187. 					$postarr['comment_status'] = $original_post->comment_status;
    3188. 

  3188. 				}
    3189. 

  3189. 				if($sitepress_settings['sync_ping_status']){
    3190. 

  3190. 					$postarr['ping_status'] = $original_post->ping_status;
    3191. 

  3191. 				}
    3192. 

  3192. 				if($sitepress_settings['sync_page_ordering']){
    3193. 

  3193. 					$postarr['menu_order'] = $original_post->menu_order;
    3194. 

  3194. 				}
    3195. 

  3195. 				if($sitepress_settings['sync_private_flag'] && $original_post->post_status=='private'){
    3196. 

  3196. 					$postarr['post_status'] = 'private';
    3197. 

  3197. 				}
    3198. 

  3198. 				if($sitepress_settings['sync_post_date']){
    3199. 

  3199. 					$postarr['post_date'] = $original_post->post_date;
    3200. 

  3200. 				}
    3201. 

  3201. 

  3202. 				//set as draft or the same status as original post
    3203. 

  3203. 				$postarr['post_status'] = !$sitepress_settings['translated_document_status'] ? 'draft' : $original_post->post_status;
    3204. 

  3204. 

  3205. 				if($original_post->post_parent){
    3206. 

  3206. 					$post_parent_trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations
    3207. 

  3207. 						WHERE element_type='post_{$original_post->post_type}' AND element_id='{$original_post->post_parent}'");
    3208. 

  3208. 					if($post_parent_trid){
    3209. 

  3209. 						$parent_id = $wpdb->get_var("SELECT element_id FROM {$wpdb->prefix}icl_translations
    3210. 

  3210. 							WHERE element_type='post_{$original_post->post_type}' AND trid='{$post_parent_trid}' AND language_code='{$job->language_code}'");
    3211. 

  3211. 					}
    3212. 

  3212. 				}
    3213. 

  3213. 

  3214. 				if(isset($parent_id) && $sitepress_settings['sync_page_parent']){
    3215. 

  3215. 					$_POST['post_parent'] = $postarr['post_parent'] = $parent_id;
    3216. 

  3216. 					$_POST['parent_id'] = $postarr['parent_id'] = $parent_id;
    3217. 

  3217. 				}
    3218. 

  3218. 

  3219. 				$_POST['trid'] = $trid;
    3220. 

  3220. 				$_POST['lang'] = $job->language_code;
    3221. 

  3221. 				$_POST['skip_sitepress_actions'] = true;
    3222. 

  3222. 

  3223. 				$postarr = apply_filters('icl_pre_save_pro_translation', $postarr);
    3224. 

  3224. 

  3225. 				if(isset($element_id)){ // it's an update so dont change the url
    3226. 

  3226. 					$postarr['post_name'] = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID=%d", $element_id));
    3227. 

  3227. 				}
    3228. 

  3228. 

  3229. 				if(isset($element_id)){ // it's an update so dont change post date
    3230. 

  3230. 					$existing_post = get_post($element_id);
    3231. 

  3231. 					$postarr['post_date'] = $existing_post->post_date;
    3232. 

  3232. 					$postarr['post_date_gmt'] = $existing_post->post_date_gmt;
    3233. 

  3233. 				}
    3234. 

  3234. 

  3235. 				$new_post_id = $this->icl_insert_post( $postarr, $job->language_code );
    3236. 

  3236. 				icl_cache_clear( $postarr['post_type'] . 's_per_language' ); // clear post counter per language in cache
    3237. 

  3237. 

  3238. 				do_action('icl_pro_translation_saved', $new_post_id, $data['fields']);
    3239. 

  3239. 

  3240. 

  3241. 				// Allow identical slugs
    3242. 

  3242. 				$post_name = sanitize_title($postarr['post_title']);
    3243. 

  3243. 				
    3244. 

  3244. 				// for Translated documents options:Page URL = Translate
    3245. 

  3245.                 if(isset($data['fields']['URL']['data']) && $data['fields']['URL']['data']){
    3246. 

  3246.                     $post_name = $data['fields']['URL']['data'];
    3247. 

  3247.                 }
    3248. 

  3248. 

  3249. 				$post_name_rewritten = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID=%d", $new_post_id));
    3250. 

  3250. 

  3251. 				$post_name_base = $post_name;
    3252. 

  3252. 

  3253. 				if ( $post_name != $post_name_rewritten || $postarr[ 'post_type' ] == 'post' || $postarr[ 'post_type' ] == 'page' ) {
    3254. 

  3254. 					$incr = 1;
    3255. 

  3255. 					do{
    3256. 

  3256. 

  3257. 						$exists = $wpdb->get_var($wpdb->prepare("
    3258. 

  3258. 							SELECT p.ID FROM {$wpdb->posts} p
    3259. 

  3259. 								JOIN {$wpdb->prefix}icl_translations t ON t.element_id = p.ID
    3260. 

  3260. 							WHERE p.ID <> %d AND t.language_code = %s AND p.post_name=%s
    3261. 

  3261. 						",  $new_post_id, $job->language_code, $post_name));
    3262. 

    3263. 

  3263. 						if($exists){
    3264. 

  3264. 							$incr++;
    3265. 

  3265. 						}else{
    3266. 

  3266. 							break;
    3267. 

  3267. 						}
    3268. 

  3268. 						$post_name = $post_name_base . '-' . $incr;
    3269. 

  3269. 

  3270. 					}while($exists);
    3271. 

  3271. 

  3272. 					$wpdb->update($wpdb->posts, array('post_name' => $post_name), array('ID' => $new_post_id));
    3273. 

  3273. 				}
    3274. 

  3274. 

  3275. 				$ICL_Pro_Translation->_content_fix_links_to_translated_content($new_post_id, $job->language_code);
    3276. 

  3276. 

  3277. 				// update body translation with the links fixed
    3278. 

  3278. 				$new_post_content = $wpdb->get_var($wpdb->prepare("SELECT post_content FROM {$wpdb->posts} WHERE ID=%d", $new_post_id));
    3279. 

  3279. 				foreach($job->elements as $jel){
    3280. 

  3280. 					if($jel->field_type=='body'){
    3281. 

  3281. 						$fields_data_translated = $this->encode_field_data($new_post_content, $jel->field_format);
    3282. 

  3282. 						break;
    3283. 

  3283. 					}
    3284. 

  3284. 				}
    3285. 

  3285. 				$wpdb->update($wpdb->prefix.'icl_translate', array('field_data_translated'=>$fields_data_translated), array('job_id'=>$data['job_id'], 'field_type'=>'body'));
    3286. 

  3286. 

  3287. 

  3288. 				// set stickiness
    3289. 

  3289. 				//is the original post a sticky post?
    3290. 

  3290. 				remove_filter('option_sticky_posts', array($sitepress,'option_sticky_posts')); // remove filter used to get language relevant stickies. get them all
    3291. 

  3291. 				$sticky_posts = get_option('sticky_posts');
    3292. 

  3292. 				$is_original_sticky = $original_post->post_type=='post' && in_array($original_post->ID, $sticky_posts);
    3293. 

  3293. 

  3294. 				if($is_original_sticky && $sitepress_settings['sync_sticky_flag']){
    3295. 

  3295. 					stick_post($new_post_id);
    3296. 

  3296. 				}else{
    3297. 

  3297. 					if($original_post->post_type=='post' && !is_null($element_id)){
    3298. 

  3298. 						unstick_post($new_post_id); //just in case - if this is an update and the original post stckiness has changed since the post was sent to translation
    3299. 

  3299. 					}
    3300. 

  3300. 				}
    3301. 

  3301. 

  3302. 				//sync plugins texts
    3303. 

  3303. 				foreach((array)$this->settings['custom_fields_translation'] as $cf => $op){
    3304. 

  3304. 					if ($op == 1) {
    3305. 

  3305. 						update_post_meta($new_post_id, $cf, get_post_meta($original_post->ID,$cf,true));
    3306. 

  3306. 					}
    3307. 

  3307. 				}
    3308. 

  3308. 

  3309. 				// set specific custom fields
    3310. 

  3310. 				$copied_custom_fields = array('_top_nav_excluded', '_cms_nav_minihome');
    3311. 

  3311. 				foreach($copied_custom_fields as $ccf){
    3312. 

  3312. 					$val = get_post_meta($original_post->ID, $ccf, true);
    3313. 

  3313. 					update_post_meta($new_post_id, $ccf, $val);
    3314. 

  3314. 				}
    3315. 

  3315. 

  3316. 				// sync _wp_page_template
    3317. 

  3317. 				if($sitepress_settings['sync_page_template']){
    3318. 

  3318. 					$_wp_page_template = get_post_meta($original_post->ID, '_wp_page_template', true);
    3319. 

  3319. 					if(!empty($_wp_page_template)){
    3320. 

  3320. 						update_post_meta($new_post_id, '_wp_page_template', $_wp_page_template);
    3321. 

  3321. 					}
    3322. 

  3322. 				}
    3323. 

  3323. 

  3324. 								// sync post format
    3325. 

  3325. 								if ( $sitepress_settings[ 'sync_post_format' ] ) {
    3326. 

  3326. 									$_wp_post_format = get_post_format( $original_post->ID );
    3327. 

  3327. 									set_post_format( $new_post_id, $_wp_post_format );
    3328. 

  3328. 								}
    3329. 

  3329. 

  3330. 

  3331. 				// set the translated custom fields if we have any.
    3332. 

  3332. 				foreach((array)$this->settings['custom_fields_translation'] as $field_name => $val){
    3333. 

  3333. 					if ($val == 2) { // should be translated
    3334. 

  3334. 						// find it in the translation
    3335. 

  3335. 						foreach($job->elements as $name => $eldata) {
    3336. 

  3336. 							if ($eldata->field_data == $field_name) {
    3337. 

  3337. 								if (preg_match("/field-(.*?)-name/", $eldata->field_type, $match)) {
    3338. 

  3338. 									$field_id = $match[1];
    3339. 

  3339. 									foreach($job->elements as $k => $v){
    3340. 

  3340. 										if($v->field_type=='field-'.$field_id){
    3341. 

  3341. 											$field_translation = self::decode_field_data($v->field_data_translated, $v->field_format) ;
    3342. 

  3342. 										}
    3343. 

  3343. 										if($v->field_type=='field-'.$field_id.'-type'){
    3344. 

  3344. 											$field_type = $v->field_data;
    3345. 

  3345. 										}
    3346. 

  3346. 									}
    3347. 

  3347. 									if (isset($field_type) && $field_type == 'custom_field') {
    3348. 

  3348. 										$field_translation = str_replace ( '&#0A;', "\n", $field_translation );
    3349. 

  3349. 										// always decode html entities  eg decode &amp; to &
    3350. 

  3350. 										$field_translation = html_entity_decode($field_translation);
    3351. 

  3351. 										update_post_meta($new_post_id, $field_name, $field_translation);
    3352. 

  3352. 									}
    3353. 

  3353. 								}
    3354. 

  3354. 							}
    3355. 

  3355. 						}
    3356. 

  3356. 					}
    3357. 

  3357. 				}
    3358. 

  3358. 				$link = get_edit_post_link($new_post_id);
    3359. 

  3359. 				if ($link == '') {
    3360. 

  3360. 					// the current user can't edit so just include permalink
    3361. 

  3361. 					$link = get_permalink($new_post_id);
    3362. 

  3362. 				}
    3363. 

  3363. 				if(is_null($element_id)){
    3364. 

  3364. 					$wpdb->delete ( $wpdb->prefix . 'icl_translations', array( 'element_id' => $new_post_id, 'element_type' => 'post_' . $postarr[ 'post_type' ] ) );
    3365. 

  3365. 					$wpdb->update ( $wpdb->prefix . 'icl_translations', array( 'element_id' => $new_post_id), array('translation_id' => $translation_id) );
    3366. 

  3366. 					$user_message = __('Translation added: ', 'sitepress') . '<a href="'.$link.'">' . $postarr['post_title'] . '</a>.';
    3367. 

  3367. 				}else{
    3368. 

  3368. 					$user_message = __('Translation updated: ', 'sitepress') . '<a href="'.$link.'">' . $postarr['post_title'] . '</a>.';
    3369. 

  3369. 				}
    3370. 

  3370. 

  3371. 				// synchronize the page parent for translations
    3372. 

  3372. 				if ($trid && $sitepress_settings['sync_page_parent']) {
    3373. 

  3373. 					$translations = $sitepress->get_element_translations($trid, 'post_' . $postarr['post_type']);
    3374. 

  3374. 

  3375. 					foreach ($translations as $target_lang => $target_details) {
    3376. 

  3376. 						if ($target_lang != $job->language_code) {
    3377. 

  3377. 							if ($target_details->element_id) {
    3378. 

  3378. 								$sitepress->fix_translated_parent($new_post_id, $target_details->element_id, $target_lang);
    3379. 

  3379. 							}
    3380. 

  3380. 						}
    3381. 

  3381. 					}
    3382. 

  3382. 				}
    3383. 

  3383. 			}
    3384. 

  3384. 

  3385. 						if(isset($user_message)) {
    3386. 

  3386. 							$this->messages[] = array(
    3387. 

  3387. 									'type'=>'updated',
    3388. 

  3388. 									'text' => $user_message
    3389. 

  3389. 							);
    3390. 

  3390. 						}
    3391. 

  3391. 

  3392. 			if($this->settings['notification']['completed'] != ICL_TM_NOTIFICATION_NONE){
    3393. 

  3393. 				require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    3394. 

  3394. 				if($data['job_id']){
    3395. 

  3395. 					$tn_notification = new TM_Notification();
    3396. 

  3396. 					$tn_notification->work_complete($data['job_id'], !is_null($element_id));
    3397. 

  3397. 				}
    3398. 

  3398. 			}
    3399. 

  3399. 

  3400. 			self::set_page_url($new_post_id);
    3401. 

  3401. 

  3402. 			// redirect to jobs list
    3403. 

  3403. 			wp_redirect(admin_url(sprintf('admin.php?page=%s&%s=%d',
    3404. 

  3404. 				WPML_TM_FOLDER . '/menu/translations-queue.php', is_null($element_id) ? 'added' : 'updated', is_null($element_id) ? $new_post_id : $element_id )));
    3405. 

  3405. 

  3406. 		}else{
    3407. 

  3407. 			$this->messages[] = array('type'=>'updated', 'text' => __('Translation (incomplete) saved.', 'sitepress'));
    3408. 

  3408. 		}
    3409. 

  3409. 

  3410. 		/*
    3411. 

  3411. 		 * After all previous functionality the terms form the job are assigned to the new post just created or updated.
    3412. 

  3412. 		 * $overwrite is true by default for now.
    3413. 

  3413. 		 */
    3414. 

  3414. 		$overwrite = true;
    3415. 

  3415. 		WPML_Terms_Translations::save_all_terms_from_job( $data[ 'job_id' ], $new_post_id, $overwrite );
    3416. 

  3416. 

  3417. 		// Set the posts mime type correctly.
    3418. 

  3418.  
    3419. 

  3419. 		if ( isset( $original_post ) && isset( $original_post->ID ) && $original_post->post_type == 'attachment' ) {
    3420. 

  3420. 			$attached_file = get_post_meta ( $original_post->ID, '_wp_attached_file', false );
    3421. 

  3421. 			update_post_meta ( $new_post_id, '_wp_attached_file', array_pop ( $attached_file ) );
    3422. 

  3422. 			$mime_type = get_post_mime_type ( $original_post->ID );
    3423. 

  3423. 			if ( $mime_type ) {
    3424. 

  3424. 				$wpdb->update ( $wpdb->posts, array( 'post_mime_type' => $mime_type ), array( 'ID' => $new_post_id ) );
    3425. 

  3425. 			}
    3426. 

  3426. 		}
    3427. 

  3427. 		
    3428. 

  3428. 		do_action('icl_pro_translation_completed', $new_post_id);
    3429. 

  3429. 

  3430. 	}
    3431. 

  3431. 

  3432. 	// returns a front end link to a post according to the user access
    3433. 

  3433. 	// hide_empty - if current user doesn't have access to the link don't show at all
    3434. 

  3434. 	public static function tm_post_link($post_id, $anchor = false, $hide_empty = false){
    3435. 

  3435. 		global $current_user;
    3436. 

  3436. 		get_currentuserinfo();
    3437. 

  3437. 

  3438. 		$parts = explode('_', $post_id);
    3439. 

  3439. 		if ($parts[0] == 'external') {
    3440. 

  3440. 

  3441. 			$link = '';
    3442. 

  3442. 			return apply_filters('WPML_get_link', $link, $post_id, $anchor, $hide_empty);
    3443. 

  3443. 		}
    3444. 

  3444. 

  3445. 		if(false === $anchor){
    3446. 

  3446. 			$anchor = get_the_title($post_id);
    3447. 

  3447. 		}
    3448. 

  3448. 

  3449. 		$opost = get_post($post_id);
    3450. 

  3450. 		if(!$opost || ($opost->post_status == 'draft' || $opost->post_status == 'private' || $opost->post_status == 'trash') && $opost->post_author != $current_user->data->ID){
    3451. 

  3451. 			if($hide_empty){
    3452. 

  3452. 				$elink = '';
    3453. 

  3453. 			}else{
    3454. 

  3454. 				$elink = sprintf('<i>%s</i>', $anchor);
    3455. 

  3455. 			}
    3456. 

  3456. 		}else{
    3457. 

  3457. 			$elink = sprintf('<a href="%s">%s</a>', get_permalink($post_id), $anchor);
    3458. 

  3458. 		}
    3459. 

  3459. 

  3460. 		return $elink;
    3461. 

  3461. 

  3462. 	}
    3463. 

  3463. 

  3464. 	public function tm_post_permalink($post_id){
    3465. 

  3465. 		global $current_user;
    3466. 

  3466. 		get_currentuserinfo();
    3467. 

  3467. 

  3468. 		$parts = explode('_', $post_id);
    3469. 

  3469. 		if ($parts[0] == 'external') {
    3470. 

  3470. 

  3471. 			return '';
    3472. 

  3472. 		}
    3473. 

  3473. 

  3474. 		$opost = get_post($post_id);
    3475. 

  3475. 		if(!$opost || ($opost->post_status == 'draft' || $opost->post_status == 'private' || $opost->post_status == 'trash') && $opost->post_author != $current_user->data->ID){
    3476. 

  3476. 			$elink = '';
    3477. 

  3477. 		}else{
    3478. 

  3478. 			$elink = get_permalink($post_id);
    3479. 

  3479. 		}
    3480. 

  3480. 

  3481. 		return $elink;
    3482. 

  3482. 

  3483. 	}
    3484. 

  3484. 

  3485. 	// when the translated post was created, we have the job_id and need to update the job
    3486. 

  3486. 	function save_job_fields_from_post($job_id, $post){
    3487. 

  3487. 		global $wpdb, $sitepress;
    3488. 

  3488. 		$data['complete'] = 1;
    3489. 

  3489. 		$data['job_id'] = $job_id;
    3490. 

  3490. 		$job = $this->get_translation_job($job_id,1);
    3491. 

  3491. 

  3492. 		if(is_array($job->elements))
    3493. 

  3493. 		foreach($job->elements as $element){
    3494. 

  3494. 			$field_data = '';
    3495. 

  3495. 			switch($element->field_type){
    3496. 

  3496. 				case 'title':
    3497. 

  3497. 					$field_data = $this->encode_field_data($post->post_title, $element->field_format);
    3498. 

  3498. 					break;
    3499. 

  3499. 				case 'body':
    3500. 

  3500. 					$field_data = $this->encode_field_data($post->post_content, $element->field_format);
    3501. 

  3501. 					break;
    3502. 

  3502. 				case 'excerpt':
    3503. 

  3503. 					$field_data = $this->encode_field_data($post->post_excerpt, $element->field_format);
    3504. 

  3504. 					break;
    3505. 

  3505. 				default:
    3506. 

  3506. 					if(false !== strpos($element->field_type, 'field-') && !empty($this->settings['custom_fields_translation'])){
    3507. 

  3507. 						$cf_name = preg_replace('#^field-#', '', $element->field_type);
    3508. 

  3508. 						if(isset($this->settings['custom_fields_translation'][$cf_name])){
    3509. 

  3509. 							if($this->settings['custom_fields_translation'][$cf_name] == 1){ //copy
    3510. 

  3510. 								// @todo: Check when this code is run, it seems obsolete
    3511. 

  3511. 								$field_data = get_post_meta($job->original_doc_id, $cf_name, 1);
    3512. 

  3512. 								if(is_scalar($field_data))
    3513. 

  3513. 								$field_data = $this->encode_field_data($field_data, $element->field_format);
    3514. 

  3514. 								else $field_data = '';
    3515. 

  3515. 							}elseif($this->settings['custom_fields_translation'][$cf_name] == 2){ // translate
    3516. 

  3516. 								$field_data = get_post_meta($post->ID, $cf_name, 1);
    3517. 

  3517. 								if(is_scalar($field_data))
    3518. 

  3518. 								$field_data = $this->encode_field_data($field_data, $element->field_format);
    3519. 

  3519. 								else $field_data = '';
    3520. 

  3520. 							}
    3521. 

  3521. 						}
    3522. 

  3522. 					}else{
    3523. 

  3523. 						if(in_array($element->field_type, $sitepress->get_translatable_taxonomies(true, $post->post_type))){
    3524. 

  3524. 							$ids = array();
    3525. 

  3525. 							foreach($job->elements as $je){
    3526. 

  3526. 								if($je->field_type == $element->field_type .'_ids' ){
    3527. 

  3527. 									$ids = explode(',', $je->field_data);
    3528. 

  3528. 								}
    3529. 

  3529. 							}
    3530. 

  3530. 							$translated_tax_names = array();
    3531. 

  3531. 							foreach($ids as $id){
    3532. 

  3532. 								$translated_tax_id = icl_object_id($id, $element->field_type,false,$job->language_code);
    3533. 

  3533. 								if($translated_tax_id){
    3534. 

  3534. 									$translated_tax_names[] = $wpdb->get_var($wpdb->prepare("
    3535. 

  3535. 										SELECT t.name FROM {$wpdb->terms} t JOIN {$wpdb->term_taxonomy} x ON t.term_id = x.term_id
    3536. 

  3536. 										WHERE x.term_taxonomy_id = %d
    3537. 

  3537. 									", $translated_tax_id));
    3538. 

  3538. 								}
    3539. 

  3539. 							}
    3540. 

  3540. 							$field_data = $this->encode_field_data($translated_tax_names, $element->field_format);
    3541. 

  3541. 

  3542. 						}
    3543. 

  3543. 					}
    3544. 

  3544. 			}
    3545. 

  3545. 			$wpdb->update($wpdb->prefix.'icl_translate',
    3546. 

  3546. 				array('field_data_translated'=>$field_data, 'field_finished'=>1),
    3547. 

  3547. 				array('tid'=>$element->tid)
    3548. 

  3548. 			);
    3549. 

  3549. 

  3550. 		}
    3551. 

  3551. 

  3552. 		$this->mark_job_done($job_id);
    3553. 

  3553. 

  3554. 	}
    3555. 

  3555. 

  3556. 	public static function determine_translated_taxonomies($elements, $taxonomy, $translated_language){
    3557. 

  3557. 		global $sitepress, $wpdb;
    3558. 

  3558. 		$translated_elements = false;
    3559. 

  3559. 		foreach($elements as $k=>$element){
    3560. 

  3560. 			$term = get_term_by('name', $element, $taxonomy);
    3561. 

  3561. 			if ($term) {
    3562. 

  3562. 				$trid = $sitepress->get_element_trid($term->term_taxonomy_id, 'tax_' . $taxonomy);
    3563. 

  3563. 				$translations = $sitepress->get_element_translations($trid, 'tax_' . $taxonomy);
    3564. 

  3564. 				if(isset($translations[$translated_language])){
    3565. 

  3565. 					$translated_elements[$k] = $translations[$translated_language]->name;
    3566. 

  3566. 				}else{
    3567. 

  3567. 					$translated_elements[$k] = '';
    3568. 

  3568. 				}
    3569. 

  3569. 			} else {
    3570. 

  3570. 				$translated_elements[$k] = '';
    3571. 

  3571. 			}
    3572. 

  3572. 		}
    3573. 

  3573. 

  3574. 		return $translated_elements;
    3575. 

  3575. 	}
    3576. 

  3576. 

  3577. 	function mark_job_done($job_id){
    3578. 

  3578. 		global $wpdb;
    3579. 

  3579. 		$wpdb->update($wpdb->prefix.'icl_translate_job', array('translated'=>1), array('job_id'=>$job_id));
    3580. 

  3580. 		$wpdb->update($wpdb->prefix.'icl_translate', array('field_finished'=>1), array('job_id'=>$job_id));
    3581. 

  3581. 	}
    3582. 

  3582. 

  3583. 	function resign_translator($job_id){
    3584. 

  3584. 		global $wpdb;
    3585. 

  3585. 		list($translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
    3586. 

  3586. 

  3587. 		if(!empty($translator_id)){
    3588. 

  3588. 			if($this->settings['notification']['resigned'] != ICL_TM_NOTIFICATION_NONE){
    3589. 

  3589. 				require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    3590. 

  3590. 				if($job_id){
    3591. 

  3591. 					$tn_notification = new TM_Notification();
    3592. 

  3592. 					$tn_notification->translator_resigned($translator_id, $job_id);
    3593. 

  3593. 				}
    3594. 

  3594. 			}
    3595. 

  3595. 		}
    3596. 

  3596. 

  3597. 		$wpdb->update($wpdb->prefix.'icl_translate_job', array('translator_id'=>0), array('job_id'=>$job_id));
    3598. 

  3598. 		$wpdb->update($wpdb->prefix.'icl_translation_status', array('translator_id'=>0, 'status'=>ICL_TM_WAITING_FOR_TRANSLATOR), array('rid'=>$rid));
    3599. 

  3599. 	}
    3600. 

  3600. 

  3601. 	function remove_translation_job($job_id, $new_translation_status = ICL_TM_WAITING_FOR_TRANSLATOR, $new_translator_id = 0){
    3602. 

  3602. 		global $wpdb;
    3603. 

  3603. 

  3604. 		list($prev_translator_id, $rid) = $wpdb->get_row($wpdb->prepare("SELECT translator_id, rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id), ARRAY_N);
    3605. 

  3605. 

  3606. 		$wpdb->update($wpdb->prefix . 'icl_translate_job', array('translator_id' => $new_translator_id), array('job_id' => $job_id));
    3607. 

  3607. 		$wpdb->update($wpdb->prefix . 'icl_translate', array('field_data_translated' => '', 'field_finished' => 0), array('job_id' => $job_id));
    3608. 

  3608. 

  3609. 		$error = false;
    3610. 

  3610. 

  3611. 		if($rid){
    3612. 

  3612. 			$wpdb->update($wpdb->prefix . 'icl_translation_status', array('status' => $new_translation_status, 'translator_id' => $new_translator_id), array('rid' => $rid));
    3613. 

  3613. 

  3614. 			if($this->settings['notification']['resigned'] == ICL_TM_NOTIFICATION_IMMEDIATELY && !empty($prev_translator_id)){
    3615. 

  3615. 				require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    3616. 

  3616. 				$tn_notification = new TM_Notification();
    3617. 

  3617. 				$tn_notification->translator_removed($prev_translator_id, $job_id);
    3618. 

  3618. 				$tn_notification->mail_queue();
    3619. 

  3619. 			}
    3620. 

  3620. 

  3621. 		}else{
    3622. 

  3622. 			$error = sprintf(__('Translation entry not found for: %d', 'wpml-translation-management'), $job_id);
    3623. 

  3623. 		}
    3624. 

  3624. 

  3625. 	}
    3626. 

  3626. 

  3627. 	function abort_translation(){
    3628. 

  3628. 		global $wpdb;
    3629. 

  3629. 

  3630. 		$job_id = $_POST['job_id'];
    3631. 

  3631. 		$error = '';
    3632. 

  3632. 		$message = '';
    3633. 

  3633. 

  3634. 		$error = $this->remove_translation_job($job_id, ICL_TM_WAITING_FOR_TRANSLATOR, 0);
    3635. 

  3635. 		if(!$error){
    3636. 

  3636. 			$message = __('Job removed', 'wpml-translation-management');
    3637. 

  3637. 		}
    3638. 

  3638. 

  3639. 		echo json_encode(array('message' => $message, 'error' => $error));
    3640. 

  3640. 		exit;
    3641. 

  3641. 

  3642. 	}
    3643. 

  3643. 

  3644. 	// $translation_id - int or array
    3645. 

  3645. 	function cancel_translation_request($translation_id){
    3646. 

  3646. 		global $wpdb;
    3647. 

  3647. 

  3648. 		if(is_array($translation_id)){
    3649. 

  3649. 			foreach($translation_id as $id){
    3650. 

  3650. 				$this->cancel_translation_request($id);
    3651. 

  3651. 			}
    3652. 

  3652. 		}else{
    3653. 

  3653. 

  3654. 			list($rid, $translator_id) = $wpdb->get_row($wpdb->prepare("SELECT rid, translator_id FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id), ARRAY_N);
    3655. 

  3655. 			$job_id = $wpdb->get_var($wpdb->prepare("SELECT job_id FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NULL ", $rid));
    3656. 

  3656. 

  3657. 			if($this->settings['notification']['resigned'] == ICL_TM_NOTIFICATION_IMMEDIATELY && !empty($translator_id)){
    3658. 

  3658. 				require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    3659. 

  3659. 				$tn_notification = new TM_Notification();
    3660. 

  3660. 				$tn_notification->translator_removed($translator_id, $job_id);
    3661. 

  3661. 				$tn_notification->mail_queue();
    3662. 

  3662. 			}
    3663. 

  3663. 

  3664. 			$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id));
    3665. 

  3665. 			$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id=%d", $job_id));
    3666. 

  3666. 

  3667. 			$max_job_id = $wpdb->get_var($wpdb->prepare("SELECT MAX(job_id) FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));
    3668. 

  3668. 			if($max_job_id){
    3669. 

  3669. 				$wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}icl_translate_job SET revision = NULL WHERE job_id=%d", $max_job_id));
    3670. 

  3670. 				$_prevstate = $wpdb->get_var($wpdb->prepare("SELECT _prevstate FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation_id));
    3671. 

  3671. 				if(!empty($_prevstate)){
    3672. 

  3672. 					$_prevstate = unserialize($_prevstate);
    3673. 

  3673. 					$wpdb->update($wpdb->prefix . 'icl_translation_status',
    3674. 

  3674. 						array(
    3675. 

  3675. 							'status'                => $_prevstate['status'],
    3676. 

  3676. 							'translator_id'         => $_prevstate['translator_id'],
    3677. 

  3677. 							'needs_update'          => $_prevstate['needs_update'],
    3678. 

  3678. 							'md5'                   => $_prevstate['md5'],
    3679. 

  3679. 							'translation_service'   => $_prevstate['translation_service'],
    3680. 

  3680. 							'translation_package'   => $_prevstate['translation_package'],
    3681. 

  3681. 							'timestamp'             => $_prevstate['timestamp'],
    3682. 

  3682. 							'links_fixed'           => $_prevstate['links_fixed']
    3683. 

  3683. 						),
    3684. 

  3684. 						array('translation_id'=>$translation_id)
    3685. 

  3685. 					);
    3686. 

  3686. 				}
    3687. 

  3687. 			}else{
    3688. 

  3688. 				$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $translation_id));
    3689. 

  3689. 			}
    3690. 

  3690. 

  3691. 			// delete record from icl_translations if trid is null
    3692. 

  3692. 			$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translations WHERE translation_id=%d AND element_id IS NULL", $translation_id));
    3693. 

  3693. 

  3694. 		}
    3695. 

  3695. 

  3696. 	}
    3697. 

  3697. 

  3698. 

  3699. 	function _array_keys_recursive( $arr )
    3700. 

  3700. 	{
    3701. 

  3701. 		$arr_rec_ret = array();
    3702. 

  3702. 		foreach ( (array)$arr as $k => $v ) {
    3703. 

  3703. 			if ( is_array( $v ) ) {
    3704. 

  3704. 				$arr_rec_ret[ $k ] = $this->_array_keys_recursive( $v );
    3705. 

  3705. 			} else {
    3706. 

  3706. 				$arr_rec_ret[$k] = $v;
    3707. 

  3707. 			}
    3708. 

  3708. 		}
    3709. 

  3709. 

  3710. 		return $arr_rec_ret;
    3711. 

  3711. 	}
    3712. 

  3712. 

  3713. 	function _read_admin_texts_recursive(&$arr, $keys, $config_contexts){
    3714. 

  3714. 		if(!is_numeric(key($keys))){
    3715. 

  3715. 			$_keys = array($keys);
    3716. 

  3716. 			$keys = $_keys;
    3717. 

  3717. 			unset($_keys);
    3718. 

  3718. 		}
    3719. 

  3719. 		if($keys) {
    3720. 

  3720. 			foreach($keys as $key){
    3721. 

  3721. 				if(isset($key['key'])){
    3722. 

  3722. 					$this->_read_admin_texts_recursive($arr, $key['key'], $config_contexts);
    3723. 

  3723. 				}else{
    3724. 

  3724. 					if(isset($config_contexts['wpml-config']['admin-texts']['key'][$key[ 'attr' ][ 'name' ]])) {
    3725. 

  3725. 						$context = $config_contexts['wpml-config']['admin-texts']['key'][$key[ 'attr' ][ 'name' ]]['slug'];
    3726. 

  3726. 						$arr[$context][$key['attr']['name']] = 1;
    3727. 

  3727. 					}
    3728. 

  3728. 				}
    3729. 

  3729. 			}
    3730. 

  3730. 		}
    3731. 

  3731. 		return $arr;
    3732. 

  3732. 	}
    3733. 

  3733. 

  3734. 	function _register_string_recursive($key, $value, $arr, $prefix = '', $suffix){
    3735. 

  3735. 		if(is_scalar($value)){
    3736. 

  3736. 			if(!empty($value) && $arr == 1){
    3737. 

  3737. 				icl_register_string('admin_texts_' . $suffix, $prefix . $key , $value);
    3738. 

  3738. 			}
    3739. 

  3739. 		}else{
    3740. 

  3740. 			if(!is_null($value)){
    3741. 

  3741. 				foreach($value as $sub_key=>$sub_value){
    3742. 

  3742. 					$is_wildcard = false;
    3743. 

  3743. 					if($arr && !isset($arr[$sub_key])){ //wildcard
    3744. 

  3744. 						if ( is_array( $arr ) ) {
    3745. 

  3745. 							$array_keys = array_keys( $arr );
    3746. 

  3746. 							if ( is_array( $array_keys ) ) {
    3747. 

  3747. 								foreach( $array_keys as $array_key){
    3748. 

  3748. 									$array_key = str_replace('/', '\/',  $array_key);
    3749. 

  3749. 									$array_key = '/' . str_replace('*', '(.*)', $array_key) . '/';
    3750. 

  3750. 									if(preg_match($array_key, $sub_key)){
    3751. 

  3751. 										$is_wildcard = true;
    3752. 

  3752. 										$arr[$sub_key] = true; //placeholder
    3753. 

  3753. 										break;
    3754. 

  3754. 									};
    3755. 

  3755. 								}
    3756. 

  3756. 							}
    3757. 

  3757. 						}
    3758. 

  3758. 					}
    3759. 

  3759. 

  3760. 					if(isset($arr[$sub_key]) || $is_wildcard){
    3761. 

  3761. 						$this->_register_string_recursive($sub_key, $sub_value, $arr[$sub_key], $prefix . '[' . $key .']', $suffix);
    3762. 

  3762. 					}
    3763. 

  3763. 

  3764. 				}
    3765. 

  3765. 			}
    3766. 

  3766. 		}
    3767. 

  3767. 	}
    3768. 

  3768. 

  3769. 	function _read_settings_recursive($config_settings){
    3770. 

  3770. 		$iclsettings = false;
    3771. 

  3771. 		foreach($config_settings as $s){
    3772. 

  3772. 			if(isset($s['key'])){
    3773. 

  3773. 				if(!is_numeric(key($s['key']))){
    3774. 

  3774. 					$sub_key[0] = $s['key'];
    3775. 

  3775. 				}else{
    3776. 

  3776. 					$sub_key = $s['key'];
    3777. 

  3777. 				}
    3778. 

  3778. 				$read_settings_recursive = $this->_read_settings_recursive( $sub_key );
    3779. 

  3779. 				if($read_settings_recursive) {
    3780. 

  3780. 					$iclsettings[$s['attr']['name']] = $read_settings_recursive;
    3781. 

  3781. 				}
    3782. 

  3782. 			}else{
    3783. 

  3783. 				$iclsettings[$s['attr']['name']] = $s['value'];
    3784. 

  3784. 			}
    3785. 

  3785. 		}
    3786. 

  3786. 		return $iclsettings;
    3787. 

  3787. 	}
    3788. 

  3788. 

  3789. 	function render_option_writes($name, $value, $key=''){
    3790. 

  3790. 		if(!defined('WPML_ST_FOLDER')) return;
    3791. 

  3791. 		//Cache the previous option, when called recursively
    3792. 

  3792. 		static $option = false;
    3793. 

  3793. 

  3794. 		if(!$key){
    3795. 

  3795. 			$option = maybe_unserialize(get_option($name));
    3796. 

  3796. 			if(is_object($option)){
    3797. 

  3797. 				$option = (array)$option;
    3798. 

  3798. 			}
    3799. 

  3799. 		}
    3800. 

  3800. 

  3801. 		$admin_option_names = get_option('_icl_admin_option_names');
    3802. 

  3802. 

  3803. 		// determine theme/plugin name (string context)
    3804. 

  3804. 		$es_context = '';
    3805. 

  3805. 

  3806. 		foreach($admin_option_names as $context => $element) {
    3807. 

  3807. 			$found = false;
    3808. 

  3808. 			foreach ( (array)$element as $slug => $options ) {
    3809. 

  3809. 				$found = false;
    3810. 

  3810. 				foreach ( (array)$options as $option_key => $option_value ) {
    3811. 

  3811. 					$found = false;
    3812. 

  3812. 					$es_context = '';
    3813. 

  3813. 					if( $option_key == $name ) {
    3814. 

  3814. 						if ( is_scalar( $option_value ) ) {
    3815. 

  3815. 							$es_context = 'admin_texts_' . $context . '_' . $slug;
    3816. 

  3816. 							$found = true;
    3817. 

  3817. 						} elseif ( is_array( $option_value ) && is_array( $value ) && ( $option_value == $value ) ) {
    3818. 

  3818. 							$es_context = 'admin_texts_' . $context . '_' . $slug;
    3819. 

  3819. 							$found = true;
    3820. 

  3820. 						}
    3821. 

  3821. 					}
    3822. 

  3822. 					if($found) break;
    3823. 

  3823. 				}
    3824. 

  3824. 				if($found) break;
    3825. 

  3825. 			}
    3826. 

  3826. 			if($found) break;
    3827. 

  3827. 		}
    3828. 

  3828. 

  3829. 		echo '<ul class="icl_tm_admin_options">';
    3830. 

  3830. 		echo '<li>';
    3831. 

  3831. 

  3832. 		$context_html = '';
    3833. 

  3833. 		if(!$key){
    3834. 

  3834. 			$context_html = '[' . $context . ': ' . $slug . '] ';
    3835. 

  3835. 		}
    3836. 

  3836. 

  3837. 		if(is_scalar($value)){
    3838. 

  3838. 			$int = preg_match_all('#\[([^\]]+)\]#', $key, $matches);
    3839. 

  3839. 

  3840. 			if(count($matches[1]) > 1){
    3841. 

  3841. 				$o_value = $option;
    3842. 

  3842. 				for($i = 1; $i < count($matches[1]); $i++){
    3843. 

  3843. 					$o_value = $o_value[$matches[1][$i]];
    3844. 

  3844. 				}
    3845. 

  3845. 				$o_value = $o_value[$name];
    3846. 

  3846. 				$edit_link = '';
    3847. 

  3847. 			}else{
    3848. 

  3848. 				if(is_scalar($option)){
    3849. 

  3849. 					$o_value = $option;
    3850. 

  3850. 				}elseif(isset($option[$name])){
    3851. 

  3851. 					$o_value = $option[$name];
    3852. 

  3852. 				}else{
    3853. 

  3853. 					$o_value = '';
    3854. 

  3854. 				}
    3855. 

  3855. 

  3856. 				if(!$key){
    3857. 

  3857. 					if(icl_st_is_registered_string($es_context, $name)) {
    3858. 

  3858. 						$edit_link = '[<a href="'.admin_url('admin.php?page='.WPML_ST_FOLDER.'/menu/string-translation.php&context='.$es_context) . '">' . __('translate', 'sitepress') . '</a>]';
    3859. 

  3859. 					} else {
    3860. 

  3860. 						$edit_link = '<div class="updated below-h2">' . __('string not registered', 'sitepress') . '</div>';
    3861. 

  3861. 					}
    3862. 

  3862. 				}else{
    3863. 

  3863. 					$edit_link = '';
    3864. 

  3864. 				}
    3865. 

  3865. 			}
    3866. 

  3866. 

  3867. 			if(false !== strpos($name, '*')){
    3868. 

  3868. 				$o_value = '<span style="color:#bbb">{{ '  . __('Multiple options', 'wpml-translation-management') .  ' }}</span>';
    3869. 

  3869. 			}else{
    3870. 

  3870. 				$o_value = esc_html($o_value);
    3871. 

  3871. 				if(strlen($o_value) > 200){
    3872. 

  3872. 					$o_value = substr($o_value, 0, 200) . ' ...';
    3873. 

  3873. 				}
    3874. 

  3874. 			}
    3875. 

  3875. 			echo '<li>' . $context_html . $name . ': <i>' . $o_value  . '</i> ' . $edit_link . '</li>';
    3876. 

  3876. 		}else{
    3877. 

  3877. 			$edit_link = '[<a href="'.admin_url('admin.php?page='.WPML_ST_FOLDER.'/menu/string-translation.php&context='.$es_context) . '">' . __('translate', 'sitepress') . '</a>]';
    3878. 

  3878. 			echo '<strong>' . $context_html  . $name . '</strong> ' . $edit_link;
    3879. 

  3879. 			if(!icl_st_is_registered_string($es_context, $name)) {
    3880. 

  3880. 				$notice = '<div class="updated below-h2">' . __('some strings might be not registered', 'sitepress') . '</div>';
    3881. 

  3881. 				echo $notice;
    3882. 

  3882. 			}
    3883. 

  3883. 

  3884. 			foreach((array)$value as $o_key=>$o_value){
    3885. 

  3885. 				$this->render_option_writes($o_key, $o_value, $o_key . '[' . $name . ']');
    3886. 

  3886. 			}
    3887. 

  3887. 

  3888. 			//Reset cached data
    3889. 

  3889. 			$option = false;
    3890. 

  3890. 		}
    3891. 

  3891. 		echo '</li>';
    3892. 

  3892. 		echo '</ul>';
    3893. 

  3893. 	}
    3894. 

  3894. 

  3895. 	function _override_get_translatable_documents($types){
    3896. 

  3896. 		global $wp_post_types;
    3897. 

  3897. 		foreach($types as $k=>$type){
    3898. 

  3898. 			if(isset($this->settings['custom_types_readonly_config'][$k]) && !$this->settings['custom_types_readonly_config'][$k]){
    3899. 

  3899. 				unset($types[$k]);
    3900. 

  3900. 			}
    3901. 

  3901. 		}
    3902. 

  3902. 		foreach($this->settings['custom_types_readonly_config'] as $cp=>$translate){
    3903. 

  3903. 			if($translate && !isset($types[$cp]) && isset($wp_post_types[$cp])){
    3904. 

  3904. 				$types[$cp] = $wp_post_types[$cp];
    3905. 

  3905. 			}
    3906. 

  3906. 		}
    3907. 

  3907. 		return $types;
    3908. 

  3908. 	}
    3909. 

  3909. 

  3910. 	function _override_get_translatable_taxonomies($taxs_obj_type){
    3911. 

  3911. 		global $wp_taxonomies, $sitepress;
    3912. 

  3912. 

  3913. 		$taxs = $taxs_obj_type['taxs'];
    3914. 

  3914. 

  3915. 		$object_type = $taxs_obj_type['object_type'];
    3916. 

  3916. 		foreach($taxs as $k=>$tax){
    3917. 

  3917. 			if(!$sitepress->is_translated_taxonomy($tax)){
    3918. 

  3918. 				unset($taxs[$k]);
    3919. 

  3919. 			}
    3920. 

  3920. 		}
    3921. 

  3921. 

  3922. 		foreach($this->settings['taxonomies_readonly_config'] as $tx=>$translate){
    3923. 

  3923. 			if($translate && !in_array($tx, $taxs) && isset($wp_taxonomies[$tx]) && in_array($object_type, $wp_taxonomies[$tx]->object_type)){
    3924. 

  3924. 				$taxs[] = $tx;
    3925. 

  3925. 			}
    3926. 

  3926. 		}
    3927. 

  3927. 

  3928. 		$ret = array('taxs'=>$taxs, 'object_type'=>$taxs_obj_type['object_type']);
    3929. 

  3929. 

  3930. 		return $ret;
    3931. 

  3931. 	}
    3932. 

  3932. 

  3933. 	public static function icanlocalize_service_info($info = array()) {
    3934. 

  3934. 		global $sitepress;
    3935. 

  3935. 		$return = array();
    3936. 

  3936. 		$return['name'] = 'ICanLocalize';
    3937. 

  3937. 		$return['logo'] = ICL_PLUGIN_URL . '/res/img/web_logo_small.png';
    3938. 

  3938. 		$return['setup_url'] = $sitepress->create_icl_popup_link('@select-translators;from_replace;to_replace@', array('ar' => 1), true);
    3939. 

  3939. 		$return['header'] = __('Looking for a quality translation service?', 'sitepress');
    3940. 

  3940. 		$return['description'] = __('ICanLocalize, the makers of WPML, offers excellent<br /> human service done by expert translators, for only $0.09 per word.', 'sitepress');
    3941. 

  3941. 		$info['icanlocalize'] = $return;
    3942. 

  3942. 		return $info;
    3943. 

  3943. 	}
    3944. 

  3944. 

  3945. 	public function clear_cache() {
    3946. 

  3946. 		global $wpdb;
    3947. 

  3947. 		delete_option($wpdb->prefix . 'icl_translators_cached');
    3948. 

  3948. 		delete_option($wpdb->prefix . 'icl_non_translators_cached');
    3949. 

  3949. 	}
    3950. 

  3950. 

  3951. 	// shows post content for visual mode (iframe) in translation editor
    3952. 

  3952. 	function _show_post_content(){
    3953. 

  3953. 		global $tinymce_version;
    3954. 

  3954. 		$data = '';
    3955. 

  3955. 		
    3956. 

  3956. 		$post = $this->_get_post($_GET['post_id']);
    3957. 

  3957. 		
    3958. 

  3958. 		if($post){
    3959. 

  3959. 			
    3960. 

  3960. 			if(0 === strpos($_GET['field_type'], 'field-')){
    3961. 

  3961. 				// A Types field
    3962. 

  3962. 				$data = get_post_meta($_GET['post_id'], preg_replace('#^field-#', '', $_GET['field_type']), true);
    3963. 

  3963. 			}else{
    3964. 

  3964. 				if (isset($post->string_data[$_GET['field_type']])) {
    3965. 

  3965. 					// A string from an external
    3966. 

  3966. 					$data = $post->string_data[$_GET['field_type']];
    3967. 

  3967. 				} else {
    3968. 

  3968. 					// The post body.
    3969. 

  3969. 					remove_filter('the_content', 'do_shortcode', 11);
    3970. 

  3970. 					$data = apply_filters('the_content', $post->post_content);
    3971. 

  3971. 				}
    3972. 

  3972. 			}
    3973. 

  3973. 

  3974. 			if(@intval($_GET['rtl'])){
    3975. 

  3975. 				$rtl = ' dir="rtl"';
    3976. 

  3976. 			}else{
    3977. 

  3977. 				$rtl = '';
    3978. 

  3978. 			}
    3979. 

  3979. 			echo '<html'.$rtl.'>';
    3980. 

  3980. 			echo '<head>';
    3981. 

  3981. 			$csss = array(
    3982. 

  3982. 				'/' . WPINC . '/js/tinymce/themes/advanced/skins/wp_theme/content.css?ver='.$tinymce_version,
    3983. 

  3983. 				'/' . WPINC . '/js/tinymce/plugins/spellchecker/css/content.css?ver='.$tinymce_version,
    3984. 

  3984. 				'/' . WPINC . '/js/tinymce/plugins/wordpress/css/content.css?ver='.$tinymce_version
    3985. 

  3985. 			);
    3986. 

  3986. 			foreach($csss as $css){
    3987. 

  3987. 				echo '<link rel="stylesheet" href="'.site_url() . $css . '">' . "\n";
    3988. 

  3988. 			}
    3989. 

  3989. 			echo '</head>';
    3990. 

  3990. 			echo '<body>';
    3991. 

  3991. 			echo $data;
    3992. 

  3992. 			echo '</body>';
    3993. 

  3993. 			echo '</html>';
    3994. 

  3994. 			exit;
    3995. 

  3995. 		}else{
    3996. 

  3996. 			wp_die(__('Post not found!', 'sitepress'));
    3997. 

  3997. 		}
    3998. 

  3998. 		exit;
    3999. 

  3999. 	}
    4000. 

  4000. 

  4001. 	function _user_search(){
    4002. 

  4002. 		$q = $_POST['q'];
    4003. 

  4003. 

  4004. 		$non_translators = self::get_blog_not_translators();
    4005. 

  4005. 

  4006. 		$matched_users = array();
    4007. 

  4007. 		foreach($non_translators as $t){
    4008. 

  4008. 			if(false !== stripos($t->user_login, $q) || false !== stripos($t->display_name, $q)){
    4009. 

  4009. 				$matched_users[] = $t;
    4010. 

  4010. 			}
    4011. 

  4011. 			if(count($matched_users) == 100) break;
    4012. 

  4012. 		}
    4013. 

  4013. 

  4014. 		if(!empty($matched_users)){
    4015. 

  4015. 			$cssheight  = count($matched_users) > 10 ? '200' : 20*count($matched_users) + 5;
    4016. 

  4016. 			echo '<select size="10" class="icl_tm_auto_suggest_dd" style="height:'.$cssheight.'px">';
    4017. 

  4017. 			foreach($matched_users as $u){
    4018. 

  4018. 				echo '<option value="' . $u->ID . '|' . esc_attr($u->display_name).'">'.$u->display_name . ' ('.$u->user_login.')'.'</option>';
    4019. 

  4019. 

  4020. 			}
    4021. 

  4021. 			echo '</select>';
    4022. 

  4022. 

  4023. 		}else{
    4024. 

  4024. 			echo '&nbsp;<span id="icl_user_src_nf">';
    4025. 

  4025. 			_e('No matches', 'sitepress');
    4026. 

  4026. 			echo '</span>';
    4027. 

  4027. 		}
    4028. 

  4028. 

  4029. 

  4030. 		exit;
    4031. 

  4031. 

  4032. 	}
    4033. 

  4033. 

  4034. 	// set slug according to user preference
    4035. 

  4035. 	static function set_page_url($post_id){
    4036. 

  4036. 

  4037. 		global $sitepress, $sitepress_settings, $wpdb;
    4038. 

  4038. 

  4039. 		if($sitepress_settings['translated_document_page_url'] == 'copy-encoded'){
    4040. 

  4040. 

  4041. 			$post = $wpdb->get_row($wpdb->prepare("SELECT post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));
    4042. 

  4042. 			$translation_row = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", $post_id, 'post_' . $post->post_type));
    4043. 

  4043. 

  4044. 			$encode_url = $wpdb->get_var($wpdb->prepare("SELECT encode_url FROM {$wpdb->prefix}icl_languages WHERE code=%s", $translation_row->language_code));
    4045. 

  4045. 			if($encode_url){
    4046. 

  4046. 

  4047. 				$trid = $sitepress->get_element_trid($post_id, 'post_' . $post->post_type);
    4048. 

  4048. 				$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));
    4049. 

  4049. 				$post_name_original = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID = %d", $original_post_id));
    4050. 

  4050. 

  4051. 				$post_name_to_be = $post_name_original;
    4052. 

  4052. 				$taken = true;
    4053. 

  4053. 				$incr = 1;
    4054. 

  4054. 				do{
    4055. 

  4055. 					$taken = $wpdb->get_var($wpdb->prepare("
    4056. 

  4056. 						SELECT ID FROM {$wpdb->posts} p
    4057. 

  4057. 						JOIN {$wpdb->prefix}icl_translations t ON p.ID = t.element_id
    4058. 

  4058. 						WHERE ID <> %d AND t.element_type = %s AND t.language_code = %s AND p.post_name = %s
    4059. 

  4059. 						", $post_id, 'post_' . $post->post_type, $translation_row->language_code, $post_name_to_be ));
    4060. 

  4060. 					if($taken){
    4061. 

  4061. 						$incr++;
    4062. 

  4062. 						$post_name_to_be = $post_name_original . '-' . $incr;
    4063. 

  4063. 					}else{
    4064. 

  4064. 						$taken = false;
    4065. 

  4065. 					}
    4066. 

  4066. 				}while($taken == true);
    4067. 

  4067. 				$wpdb->update($wpdb->posts, array('post_name' => $post_name_to_be), array('ID' => $post_id));
    4068. 

  4068. 

  4069. 			}
    4070. 

  4070. 

  4071. 		}
    4072. 

  4072. 

  4073. 	}
    4074. 

  4074. 

  4075. 	/**
    4076. 

  4076. 	 * @param $postarr
    4077. 

  4077. 	 *
    4078. 

  4078. 	 * @param $lang
    4079. 

  4079. 	 *
    4080. 

  4080. 	 * @return int|WP_Error
    4081. 

  4081. 	 */
    4082. 

  4082. 	public function icl_insert_post( $postarr, $lang )
    4083. 

  4083. 	{
    4084. 

  4084. 		global $sitepress;
    4085. 

  4085. 		$current_language = $sitepress->get_current_language();
    4086. 

  4086. 		$sitepress->switch_lang( $lang, false );
    4087. 

  4087. 		$new_post_id = wp_insert_post( $postarr );
    4088. 

  4088. 		$sitepress->switch_lang( $current_language, false );
    4089. 

  4089. 

  4090. 		return $new_post_id;
    4091. 

  4091. 	}
    4092. 

  4092. 

  4093. 	/**
    4094. 

  4094. 	 * Add missing language to posts
    4095. 

  4095. 	 *
    4096. 

  4096. 	 * @param array $post_types
    4097. 

  4097. 	 */
    4098. 

  4098. 	protected function add_missing_language_to_posts( $post_types )
    4099. 

  4099. 	{
    4100. 

  4100. 		global $wpdb;
    4101. 

  4101. 

  4102. 		//This will be improved when it will be possible to pass an array to the IN clause
    4103. 

  4103. 		$posts_prepared = "SELECT ID, post_type, post_status FROM {$wpdb->posts} WHERE post_type IN ('" . implode("', '", esc_sql($post_types)) . "')";
    4104. 

  4104. 		$posts = $wpdb->get_results( $posts_prepared );
    4105. 

  4105. 		if ( $posts ) {
    4106. 

  4106. 			foreach ( $posts as $post ) {
    4107. 

  4107. 				$this->add_missing_language_to_post( $post );
    4108. 

  4108. 			}
    4109. 

  4109. 		}
    4110. 

  4110. 	}
    4111. 

  4111. 

  4112. 	/**
    4113. 

  4113. 	 * Add missing language to a given post
    4114. 

  4114. 	 *
    4115. 

  4115. 	 * @param WP_Post $post
    4116. 

  4116. 	 */
    4117. 

  4117. 	protected function add_missing_language_to_post( $post ) {
    4118. 

  4118. 		global $sitepress, $wpdb;
    4119. 

  4119. 

  4120. 		$query_prepared   = $wpdb->prepare( "SELECT translation_id, language_code FROM {$wpdb->prefix}icl_translations WHERE element_type=%s AND element_id=%d", array( 'post_' . $post->post_type, $post->ID ) );
    4121. 

  4121. 		$query_results    = $wpdb->get_row( $query_prepared );
    4122. 

  4122. 

  4123. 		//if translation exists
    4124. 

  4124. 		if (!is_null($query_results)){
    4125. 

  4125. 			$translation_id   = $query_results->translation_id;
    4126. 

  4126. 			$language_code    = $query_results->language_code;
    4127. 

  4127. 		}else{
    4128. 

  4128. 			$translation_id   = null;
    4129. 

  4129. 			$language_code    = null;
    4130. 

  4130. 		}
    4131. 

  4131. 

  4132. 		$urls             = $sitepress->get_setting( 'urls' );
    4133. 

  4133. 		$is_root_page     = $urls && isset( $urls[ 'root_page' ] ) && $urls[ 'root_page' ] == $post->ID;
    4134. 

  4134. 		$default_language = $sitepress->get_default_language();
    4135. 

  4135. 

  4136. 		if ( !$translation_id && !$is_root_page && !in_array( $post->post_status, array( 'auto-draft' ) ) ) {
    4137. 

  4137. 			$sitepress->set_element_language_details( $post->ID, 'post_' . $post->post_type, null, $default_language );
    4138. 

  4138. 		} elseif ( $translation_id && $is_root_page ) {
    4139. 

  4139. 			$trid = $sitepress->get_element_trid( $post->ID, 'post_' . $post->post_type );
    4140. 

  4140. 			if ( $trid ) {
    4141. 

  4141. 				$sitepress->delete_element_translation( $trid, 'post_' . $post->post_type );
    4142. 

  4142. 			}
    4143. 

  4143. 		} elseif ( $translation_id && !$language_code && $default_language ) {
    4144. 

  4144. 			$where = array( 'translation_id' => $translation_id );
    4145. 

  4145. 			$data  = array( 'language_code' => $default_language );
    4146. 

  4146. 			$wpdb->update( $wpdb->prefix . 'icl_translations', $data, $where );
    4147. 

  4147. 		}
    4148. 

  4148. 	}
    4149. 

  4149. 

  4150. 	/**
    4151. 

  4151. 	 * Add missing language to taxonomies
    4152. 

  4152. 	 *
    4153. 

  4153. 	 * @param array $post_types
    4154. 

  4154. 	 */
    4155. 

  4155. 	protected function add_missing_language_to_taxonomies( $post_types )
    4156. 

  4156. 	{
    4157. 

  4157. 		global $sitepress, $wpdb;
    4158. 

  4158. 		$taxonomy_types = array();
    4159. 

  4159. 		foreach ( $post_types as $post_type ) {
    4160. 

  4160. 			$taxonomy_types = array_merge( $sitepress->get_translatable_taxonomies( true, $post_type ), $taxonomy_types );
    4161. 

  4161. 		}
    4162. 

  4162. 		$taxonomy_types = array_unique( $taxonomy_types );
    4163. 

  4163. 		$taxonomies     = $wpdb->get_results( "SELECT taxonomy, term_taxonomy_id FROM {$wpdb->term_taxonomy} WHERE taxonomy IN ('" . join( "','", $taxonomy_types ) . "')" );
    4164. 

  4164. 		if ( $taxonomies ) {
    4165. 

  4165. 			foreach ( $taxonomies as $taxonomy ) {
    4166. 

  4166. 				$this->add_missing_language_to_taxonomy( $taxonomy );
    4167. 

  4167. 			}
    4168. 

  4168. 		}
    4169. 

  4169. 	}
    4170. 

  4170. 

  4171. 	/**
    4172. 

  4172. 	 * Add missing language to a given taxonomy
    4173. 

  4173. 	 *
    4174. 

  4174. 	 * @param OBJECT $taxonomy
    4175. 

  4175. 	 */
    4176. 

  4176. 	protected function add_missing_language_to_taxonomy( $taxonomy )
    4177. 

  4177. 	{
    4178. 

  4178. 		global $sitepress, $wpdb;
    4179. 

  4179. 		$tid_prepared = $wpdb->prepare( "SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE element_type=%s AND element_id=%d", 'tax_' . $taxonomy->taxonomy, $taxonomy->term_taxonomy_id );
    4180. 

  4180. 		$tid          = $wpdb->get_var( $tid_prepared );
    4181. 

  4181. 		if ( !$tid ) {
    4182. 

  4182. 			$sitepress->set_element_language_details( $taxonomy->term_taxonomy_id, 'tax_' . $taxonomy->taxonomy, null, $sitepress->get_default_language() );
    4183. 

  4183. 		}
    4184. 

  4184. 	}
    4185. 

  4185. 

  4186. 	/**
    4187. 

  4187. 	 * Add missing language to comments
    4188. 

  4188. 	 */
    4189. 

  4189. 	protected function add_missing_language_to_comments()
    4190. 

  4190. 	{
    4191. 

  4191. 		global $sitepress, $wpdb;
    4192. 

  4192. 		$comment_ids_prepared = $wpdb->prepare( "SELECT c.comment_ID FROM {$wpdb->comments} c LEFT JOIN {$wpdb->prefix}icl_translations t ON t.element_id = c.comment_id AND t.element_type=%s WHERE t.element_id IS NULL", 'comment' );
    4193. 

  4193. 		$comment_ids          = $wpdb->get_col( $comment_ids_prepared );
    4194. 

  4194. 		if ( $comment_ids ) {
    4195. 

  4195. 			foreach ( $comment_ids as $comment_id ) {
    4196. 

  4196. 				$sitepress->set_element_language_details( $comment_id, 'comment', null, $sitepress->get_default_language() );
    4197. 

  4197. 			}
    4198. 

  4198. 		}
    4199. 

  4199. 	}
    4200. 

  4200. 

  4201. 	/**
    4202. 

  4202. 	 * Add missing language information to entities that don't have this
    4203. 

  4203. 	 * information configured.
    4204. 

  4204. 	 */
    4205. 

  4205. 	public function add_missing_language_information()
    4206. 

  4206. 	{
    4207. 

  4207. 		global $sitepress;
    4208. 

  4208. 		$translatable_documents = array_keys( $sitepress->get_translatable_documents(true) );
    4209. 

  4209. 		if( $translatable_documents ) {
    4210. 

  4210. 			$this->add_missing_language_to_posts( $translatable_documents );
    4211. 

  4211. 			$this->add_missing_language_to_taxonomies( $translatable_documents );
    4212. 

  4212. 		}
    4213. 

  4213. 		$this->add_missing_language_to_comments();
    4214. 

  4214. 	}
    4215. 

  4215. 

  4216. }
    4217. 

  4217.