PageRenderTime 97ms CodeModel.GetById 22ms RepoModel.GetById 0ms app.codeStats 1ms

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

https://bitbucket.org/dkrzos/phc
PHP | 3758 lines | 2883 code | 573 blank | 302 comment | 611 complexity | 6562e9287eb76105f6468d7ba157806a MD5 | raw file
Possible License(s): GPL-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. 

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

  21.   
    22. 

  22. class TranslationManagement{
    23. 

  23.     
    24. 

  24.     private $selected_translator = array('ID'=>0);
    25. 

  25.     private $current_translator = array('ID'=>0);
    26. 

  26.     public $messages = array();    
    27. 

  27.     public $dashboard_select = array();
    28. 

  28.     public $settings;
    29. 

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

  30.     
    31. 

  31.     function __construct(){
    32. 

  32.         add_action('init', array($this, 'init'), 15);
    33. 

  33.         
    34. 

  34.         if(isset($_GET['icl_tm_message'])){
    35. 

  35.             $this->messages[] = array(
    36. 

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

  37.                 'text'  => $_GET['icl_tm_message']
    38. 

  38.             );        
    39. 

  39.         }
    40. 

  40.         
    41. 

  41.         add_action('save_post', array($this, 'save_post_actions'), 11, 2); // calling *after* the Sitepress actions
    42. 

  42.         
    43. 

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

  44.         
    45. 

  45.         add_action('icl_ajx_custom_call', array($this, 'ajax_calls'), 10, 2);
    46. 

  46.         add_action('wp_ajax_show_post_content', array($this, '_show_post_content'));
    47. 

  47.                 
    48. 

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

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

  50.         add_filter('icl_additional_translators', array($this, 'icl_additional_translators'), 99, 3);
    51. 

  51.         
    52. 

  52.         add_filter('icl_translators_list', array($this, 'icanlocalize_translators_list'));
    53. 

  53.         
    54. 

  54.         add_action('user_register', array($this, 'clear_cache'));
    55. 

  55.         add_action('profile_update', array($this, 'clear_cache'));
    56. 

  56.         add_action('delete_user', array($this, 'clear_cache'));
    57. 

  57.         add_action('added_existing_user', array($this, 'clear_cache'));
    58. 

  58.         add_action('remove_user_from_blog', array($this, 'clear_cache'));
    59. 

  59.         
    60. 

  60.         add_action('admin_print_scripts', array($this, '_inline_js_scripts'));
    61. 

  61.         
    62. 

  62.         add_action('wp_ajax_icl_tm_user_search', array($this, '_user_search'));
    63. 

  63.         
    64. 

  64.     }
    65. 

  65.     
    66. 

  66.     function save_settings(){
    67. 

  67.         global $sitepress;
    68. 

  68.         $iclsettings['translation-management'] = $this->settings;
    69. 

  69.         $sitepress->save_settings($iclsettings);    
    70. 

  70.     }
    71. 

  71.     
    72. 

  72.     function init(){
    73. 

  73.         
    74. 

  74.         global $wpdb, $current_user, $sitepress_settings, $sitepress, $pagenow;
    75. 

  75. 

  76.         $this->settings =& $sitepress_settings['translation-management'];
    77. 

  77.         
    78. 

  78.         //logic for syncing comments
    79. 

  79.         if($sitepress->get_option('sync_comments_on_duplicates')){
    80. 

  80.             add_action('delete_comment', array($this, 'duplication_delete_comment'));
    81. 

  81.             add_action('edit_comment', array($this, 'duplication_edit_comment'));
    82. 

  82.             add_action('wp_set_comment_status', array($this, 'duplication_status_comment'), 10, 2);
    83. 

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

  84.         }
    85. 

  85.         
    86. 

  86.         $this->initial_custom_field_translate_states();
    87. 

  87.         
    88. 

  88.         // defaults
    89. 

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

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

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

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

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

  94.         
    95. 

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

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

  97.         
    98. 

  98.         get_currentuserinfo();
    99. 

  99.         if(isset($current_user->ID)){
    100. 

  100.             $user = new WP_User($current_user->ID);    
    101. 

  101.         }
    102. 

  102.         
    103. 

  103.         if(empty($user->data)) return;
    104. 

  104.         
    105. 

  105.         $ct['translator_id'] =  $current_user->ID;
    106. 

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

  107.         $ct['user_login'] =  $user->data->user_login;
    108. 

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

  109.         if(empty($ct['language_pairs'])) $ct['language_pairs'] = array();
    110. 

  110.         
    111. 

  111.         $this->current_translator = (object)$ct;
    112. 

  112. 

  113.         $this->load_config_pre_process();            
    114. 

  114.         $this->load_plugins_wpml_config();
    115. 

  115.         $this->load_theme_wpml_config();
    116. 

  116.         $this->load_config_post_process();
    117. 

  117.                 
    118. 

  118.         if(isset($_POST['icl_tm_action'])){
    119. 

  119.             $this->process_request($_POST['icl_tm_action'], $_POST);
    120. 

  120.         }elseif(isset($_GET['icl_tm_action'])){
    121. 

  121.             $this->process_request($_GET['icl_tm_action'], $_GET);
    122. 

  122.         }        
    123. 

  123.         
    124. 

  124.         //$this->load_plugins_wpml_config();
    125. 

  125.         //$this->load_theme_wpml_config();
    126. 

  126.         
    127. 

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

  128.             add_action('admin_notices', array($this, 'show_messages'));    
    129. 

  129.         }else{                               // use custom WP admin notices
    130. 

  130.             add_action('icl_tm_messages', array($this, 'show_messages'));            
    131. 

  131.         }
    132. 

  132.         
    133. 

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

  134.             add_filter('admin_head',array($this, '_show_tinyMCE'));                
    135. 

  135.         }
    136. 

  136.                 
    137. 

  137.         
    138. 

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

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

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

  141.                         $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
    142. 

  142.                         $this->save_settings();
    143. 

  143.             }else{
    144. 

  144.                 add_action('admin_notices', array($this, '_translation_method_notice'));    
    145. 

  145.             }                        
    146. 

  146.         }
    147. 

  147.                 
    148. 

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

  149.             $iclsettings =& $sitepress_settings;
    150. 

  150.             $sitepress->get_icl_translator_status($iclsettings);
    151. 

  151.             $sitepress->save_settings($iclsettings);
    152. 

  152.         }
    153. 

  153.         
    154. 

  154.         // default settings
    155. 

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

  156.             $this->settings['doc_translation_method'] = ICL_TM_TMETHOD_MANUAL;
    157. 

  157.         }        
    158. 

  158.     }
    159. 

  159. 

  160.     function initial_custom_field_translate_states() {
    161. 

  161.         global $wpdb;
    162. 

  162.         
    163. 

  163.         $cf_keys_limit = 1000; // jic
    164. 

  164.         $custom_keys = $wpdb->get_col( "
    165. 

  165.             SELECT meta_key
    166. 

  166.             FROM $wpdb->postmeta
    167. 

  167.             GROUP BY meta_key
    168. 

  168.             ORDER BY meta_key
    169. 

  169.             LIMIT $cf_keys_limit" );
    170. 

    171. 

  171.         $changed = false;
    172. 

  172.         
    173. 

  173.         foreach($custom_keys as $cfield) {
    174. 

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

  175.                 // see if a plugin handles this field
    176. 

  176.                 $override = apply_filters('icl_cf_translate_state', 'nothing', $cfield);
    177. 

  177.                 switch($override) {
    178. 

  178.                     case 'nothing':
    179. 

  179.                         break;
    180. 

  180.                     
    181. 

  181.                     case 'ignore':
    182. 

  182.                         $changed = true;
    183. 

  183.                         $this->settings['custom_fields_translation'][$cfield] = 3;
    184. 

  184.                         break;
    185. 

  185.                     
    186. 

  186.                     case 'translate':
    187. 

  187.                         $changed = true;
    188. 

  188.                         $this->settings['custom_fields_translation'][$cfield] = 2;
    189. 

  189.                         break;
    190. 

  190.                     
    191. 

  191.                     case 'copy':
    192. 

  192.                         $changed = true;
    193. 

  193.                         $this->settings['custom_fields_translation'][$cfield] = 1;
    194. 

  194.                         break;
    195. 

  195.                 }
    196. 

  196. 

  197.             }
    198. 

  198.         }
    199. 

  199.         if ($changed) {
    200. 

  200.             $this->save_settings();
    201. 

  201.         }
    202. 

  202.     }
    203. 

  203.     
    204. 

  204.     function _translation_method_notice(){
    205. 

  205.         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'),
    206. 

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

  207.     }
    208. 

  208.     
    209. 

  209.     function _show_tinyMCE() {
    210. 

  210.         wp_print_scripts('editor');
    211. 

  211.         //add_filter('the_editor', array($this, 'editor_directionality'), 9999);
    212. 

  212.         add_filter('tiny_mce_before_init', array($this, '_mce_set_direction'), 9999);        
    213. 

  213.         add_filter('mce_buttons', array($this, '_mce_remove_fullscreen'), 9999);                    
    214. 

  214.         
    215. 

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

  216.         try{
    217. 

  217.             @wp_tiny_mce();
    218. 

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

  219.     }    
    220. 

  220.     
    221. 

  221.     function _mce_remove_fullscreen($options){
    222. 

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

  223.         return $options;
    224. 

  224.     }
    225. 

  225.     
    226. 

  226.     function _inline_js_scripts(){
    227. 

  227.         // remove fullscreen mode
    228. 

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

  229.             ?>
    230. 

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

  231.             <?php             
    232. 

  232.         }
    233. 

  233.     }
    234. 

  234.     
    235. 

  235. 

  236.     function _mce_set_direction($settings) {
    237. 

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

  238.         if (!empty($job)) {
    239. 

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

  240.             if ($rtl_translation) {
    241. 

  241.                 $settings['directionality'] = 'rtl';
    242. 

  242.             } else {
    243. 

  243.                 $settings['directionality'] = 'ltr';
    244. 

  244.             }
    245. 

  245.         }
    246. 

  246.         return $settings;
    247. 

  247.     }
    248. 

  248. 

  249.     /*
    250. 

  250.     function editor_directionality($tag) {
    251. 

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

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

  253.         if ($rtl_translation) {
    254. 

  254.             $dir = 'dir="rtl"';
    255. 

  255.         } else {
    256. 

  256.             $dir = 'dir="ltr"';
    257. 

  257.         }
    258. 

  258.         return str_replace('<textarea', '<textarea ' . $dir, $tag);
    259. 

  259.     }
    260. 

  260.     */
    261. 

  261.     
    262. 

  262.     function process_request($action, $data){        
    263. 

  263.         $data = stripslashes_deep($data);
    264. 

  264.         switch($action){
    265. 

  265.             case 'add_translator':
    266. 

  266.                 if(wp_create_nonce('add_translator') == $data['add_translator_nonce']){
    267. 

  267.                     // Initial adding
    268. 

  268.                     if (isset($data['from_lang']) && isset($data['to_lang'])) {
    269. 

  269.                       $data['lang_pairs'] = array();
    270. 

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

  271.                     }
    272. 

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

  273.                     $_user = new WP_User($data['user_id']);
    274. 

  274.                     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');                    
    275. 

  275.                 }
    276. 

  276.                 break;
    277. 

  277.             case 'edit_translator':
    278. 

  278.                 if(wp_create_nonce('edit_translator') == $data['edit_translator_nonce']){
    279. 

  279.                     $this->edit_translator($data['user_id'], $data['lang_pairs']);
    280. 

  280.                     $_user = new WP_User($data['user_id']);
    281. 

  281.                     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');
    282. 

  282.                 }
    283. 

  283.                 break;
    284. 

  284.             case 'remove_translator':
    285. 

  285.                 if(wp_create_nonce('remove_translator') == $data['remove_translator_nonce']){
    286. 

  286.                     $this->remove_translator($data['user_id']);
    287. 

  287.                     $_user = new WP_User($data['user_id']);
    288. 

  288.                     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');
    289. 

  289.                 }                
    290. 

  290.                 break;
    291. 

  291.             case 'edit':
    292. 

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

  293.                 break;
    294. 

  294.             case 'dashboard_filter':
    295. 

  295.                 $_SESSION['translation_dashboard_filter'] = $data['filter'];
    296. 

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

  297.                 break;  
    298. 

  298.            case 'sort':
    299. 

  299.                 if(isset($data['sort_by'])) $_SESSION['translation_dashboard_filter']['sort_by'] = $data['sort_by'];
    300. 

  300.                 if(isset($data['sort_order'])) $_SESSION['translation_dashboard_filter']['sort_order'] = $data['sort_order'];
    301. 

  301.                 break;
    302. 

  302.            case 'reset_filters':
    303. 

  303.                 unset($_SESSION['translation_dashboard_filter']);
    304. 

  304.                 break;          
    305. 

  305.            case 'send_jobs':
    306. 

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

  307.                     $this->send_jobs($data);                        
    308. 

  308.                 }   
    309. 

  309.                 break; 
    310. 

  310.            case 'jobs_filter':
    311. 

  311.                 $_SESSION['translation_jobs_filter'] = $data['filter'];                
    312. 

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

  313.                 break;                               
    314. 

  314.            case 'ujobs_filter':
    315. 

  315.                 $_SESSION['translation_ujobs_filter'] = $data['filter'];
    316. 

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

  317.                 break;                                               
    318. 

  318.            case 'save_translation':
    319. 

  319.                 if(!empty($data['resign'])){
    320. 

  320.                     $this->resign_translator($data['job_id']);
    321. 

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

  322.                     exit;
    323. 

  323.                 }else{
    324. 

  324.                     $this->save_translation($data);    
    325. 

  325.                 }                
    326. 

  326.                 break;
    327. 

  327.            case 'save_notification_settings':
    328. 

  328.                 $this->settings['notification'] = $data['notification'];                                
    329. 

  329.                 $this->save_settings();
    330. 

  330.                 $this->messages[] = array(
    331. 

  331.                     'type'=>'updated',
    332. 

  332.                     'text' => __('Preferences saved.', 'sitepress')
    333. 

  333.                 );
    334. 

  334.                 break;
    335. 

  335.            case 'create_job':
    336. 

  336.                 global $current_user;
    337. 

  337.                 if(!isset($this->current_translator->ID) && isset($current_user->ID)){
    338. 

  338.                     $this->current_translator->ID  = $current_user->ID;   
    339. 

  339.                 }
    340. 

  340.                 $data['translator'] = $this->current_translator->ID;
    341. 

  341.                 $job_ids = $this->send_jobs($data);
    342. 

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

  343.                 break;
    344. 

  344.            case 'cancel_jobs':
    345. 

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

  346.                 $this->messages[] = array(
    347. 

  347.                     'type'=>'updated',
    348. 

  348.                     'text' => __('Translation requests cancelled.', 'sitepress')
    349. 

  349.                 );
    350. 

  350.                 break;
    351. 

  351.         }
    352. 

  352.     }
    353. 

  353.     
    354. 

  354.     function ajax_calls($call, $data){
    355. 

  355.         global $wpdb, $sitepress, $sitepress_settings;        
    356. 

  356.         switch($call){
    357. 

  357.             /*
    358. 

  358.             case 'save_dashboard_setting':
    359. 

  359.                 $iclsettings['dashboard'] = $sitepress_settings['dashboard'];
    360. 

  360.                 if(isset($data['setting']) && isset($data['value'])){
    361. 

  361.                     $iclsettings['dashboard'][$data['setting']] = $data['value'];
    362. 

  362.                     $sitepress->save_settings($iclsettings);    
    363. 

  363.                 }
    364. 

  364.                 break;
    365. 

  365.             */
    366. 

  366.             case 'assign_translator':
    367. 

  367.             
    368. 

  368.                 $_exp = explode('-', $data['translator_id']);
    369. 

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

  370.                 $translator_id = $_exp[0];                
    371. 

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

  372.                     if($service == 'icanlocalize'){
    373. 

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

  374.                         global $ICL_Pro_Translation;
    375. 

  375.                         $ICL_Pro_Translation->send_post($job->original_doc_id, array($job->language_code), $translator_id);
    376. 

  376.                         foreach($sitepress_settings['icl_lang_status'] as $lp){
    377. 

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

  378.                                 $contract_id = $lp['contract_id'];
    379. 

  379.                                 $lang_tr_id =  $lp['id']; 
    380. 

  380.                                 break;
    381. 

  381.                             }
    382. 

  382.                         }
    383. 

  383.                         $translator_edit_link = $sitepress->create_icl_popup_link(ICL_API_ENDPOINT . '/websites/' . $sitepress_settings['site_id']
    384. 

  384.                         . '/website_translation_offers/' . $lang_tr_id . '/website_translation_contracts/'
    385. 

  385.                         . $contract_id, array('title' => __('Chat with translator', 'sitepress'), 'unload_cb' => 'icl_thickbox_refresh')) 
    386. 

  386.                         . esc_html(ICL_Pro_Translation::get_translator_name($translator_id))  . '</a> (ICanLocalize)';                    
    387. 

  387.                         
    388. 

  388.                     }else{
    389. 

  389.                         $translator_edit_link = '<a href="'.$this->get_translator_edit_url($data['translator_id']).'">' . 
    390. 

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

  391.                     }
    392. 

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

  393.                 }else{
    394. 

  394.                     echo json_encode(array('error'=>1));
    395. 

  395.                 }
    396. 

  396.                 break;
    397. 

  397.             case 'icl_cf_translation':
    398. 

  398.                 if(!empty($data['cf'])){
    399. 

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

  400.                         $cft[base64_decode($k)] = $v;
    401. 

  401.                     }
    402. 

  402.                     $this->settings['custom_fields_translation'] = $cft;
    403. 

  403.                     $this->save_settings();                    
    404. 

  404.                 }            
    405. 

  405.                 echo '1|';
    406. 

  406.                 break;
    407. 

  407.             case 'icl_doc_translation_method':
    408. 

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

  409.                 $this->save_settings();
    410. 

  410.                 echo '1|';
    411. 

  411.                 break;
    412. 

  412.             case 'reset_duplication':
    413. 

  413.                 $this->reset_duplicate_flag($_POST['post_id']);
    414. 

  414.                 break;
    415. 

  415.             case 'set_duplication':
    416. 

  416.                 $this->set_duplicate($_POST['post_id']);
    417. 

  417.                 break;
    418. 

  418.             case 'make_duplicates':
    419. 

  419.                 $mdata['iclpost'] = array($data['post_id']);
    420. 

  420.                 $langs = explode(',', $data['langs']);
    421. 

  421.                 foreach($langs as $lang){
    422. 

  422.                     $mdata['duplicate_to'][$lang] = 1;       
    423. 

  423.                 }
    424. 

  424.                 $this->make_duplicates($mdata);
    425. 

  425.                 break;
    426. 

  426.         }
    427. 

  427.     }
    428. 

  428.     
    429. 

  429.     function show_messages(){
    430. 

  430.         if(!empty($this->messages)){
    431. 

  431.             foreach($this->messages as $m){
    432. 

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

  433.             }
    434. 

  434.         }
    435. 

  435.     }
    436. 

  436.     
    437. 

  437.     /* TRANSLATORS */
    438. 

  438.     /* ******************************************************************************************** */
    439. 

  439.     function add_translator($user_id, $language_pairs){
    440. 

  440.         global $wpdb;
    441. 

  441.         
    442. 

  442.         $user = new WP_User($user_id);
    443. 

  443.         $user->add_cap('translate');
    444. 

  444.         
    445. 

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

  446.         if(!empty($um)){
    447. 

  447.             foreach($um as $fr=>$to){
    448. 

  448.                 if(isset($language_pairs[$fr])){
    449. 

  449.                     $language_pairs[$fr] = array_merge($language_pairs[$fr], $to);        
    450. 

  450.                 }
    451. 

  451.                 
    452. 

  452.             }
    453. 

  453.         }
    454. 

  454.         
    455. 

  455.         update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);
    456. 

  456.         $this->clear_cache();
    457. 

  457.     }
    458. 

  458. 

  459.     function edit_translator($user_id, $language_pairs){
    460. 

  460.         global $wpdb;
    461. 

  461.         $_user = new WP_User($user_id);
    462. 

  462.         if(empty($language_pairs)){
    463. 

  463.             $this->remove_translator($user_id);                
    464. 

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

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

  466.         }
    467. 

  467.         else{
    468. 

  468.             if(!$_user->has_cap('translate')) $_user->add_cap('translate');
    469. 

  469.             update_user_meta($user_id, $wpdb->prefix . 'language_pairs',  $language_pairs);    
    470. 

  470.         }
    471. 

  471.     }
    472. 

  472.     
    473. 

  473.     function remove_translator($user_id){
    474. 

  474.         global $wpdb;
    475. 

  475.         $user = new WP_User($user_id);
    476. 

  476.         $user->remove_cap('translate');
    477. 

  477.         delete_user_meta($user_id, $wpdb->prefix . 'language_pairs');
    478. 

  478.         $this->clear_cache();
    479. 

  479.     }
    480. 

  480.     
    481. 

  481.     function is_translator($user_id, $args = array()){
    482. 

  482.         // $lang_from
    483. 

  483.         // $lang_to
    484. 

  484.         // $job_id
    485. 

  485.         
    486. 

  486.         //$default_args = array(); 
    487. 

  487.         //extract($default_args);
    488. 

  488.         extract($args, EXTR_OVERWRITE);
    489. 

  489.         
    490. 

  490.         global $wpdb;
    491. 

  491.         $user = new WP_User($user_id);
    492. 

  492.         $is_translator = $user->has_cap('translate');
    493. 

  493.         
    494. 

  494.         if(isset($lang_from) && isset($lang_to)){
    495. 

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

  496.             $is_translator = $is_translator && isset($um[$lang_from][$lang_to]) && $um[$lang_from][$lang_to];
    497. 

  497.         }
    498. 

  498.         if(isset($job_id)){
    499. 

  499.             $translator_id = $wpdb->get_var($wpdb->prepare("
    500. 

  500.                     SELECT j.translator_id  
    501. 

  501.                         FROM {$wpdb->prefix}icl_translate_job j 
    502. 

  502.                         JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    503. 

  503.                     WHERE job_id = %d AND s.translation_service='local'
    504. 

  504.                 ", $job_id));
    505. 

  505.                                                                 
    506. 

  506.             //$is_translator = $is_translator && ($translator_id == $user_id || ($translator_id === '0'));
    507. 

  507.             $is_translator = $is_translator && (($translator_id == $user_id) || empty($translator_id));
    508. 

  508.                 
    509. 

  509.         }
    510. 

  510.         
    511. 

  511.         return $is_translator;
    512. 

  512.     }
    513. 

  513.     
    514. 

  514.     function translator_exists($id, $from, $to, $type = 'local'){
    515. 

  515.         global $sitepress_settings;
    516. 

  516.         $exists = false;
    517. 

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

  518.             foreach($sitepress_settings['icl_lang_status'] as $lpair){
    519. 

  519.                 if($lpair['from'] == $from && $lpair['to'] == $to){
    520. 

  520.                     if(!empty($lpair['translators'])){
    521. 

  521.                         foreach($lpair['translators'] as $t){
    522. 

  522.                             if($t['id'] == $id){
    523. 

  523.                                 $exists = true;
    524. 

  524.                                 break(2);
    525. 

  525.                             }
    526. 

  526.                         }
    527. 

  527.                     }
    528. 

  528.                 }
    529. 

  529.             }
    530. 

  530.         }elseif($type == 'local'){
    531. 

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

  532.         }
    533. 

  533.         return $exists;
    534. 

  534.     }
    535. 

  535.     
    536. 

  536.     function set_default_translator($id, $from, $to, $type = 'local'){
    537. 

  537.         global $sitepress, $sitepress_settings;
    538. 

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

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

  540.         $sitepress->save_settings($iclsettings);
    541. 

  541.     } 
    542. 

  542.     
    543. 

  543.     function get_default_translator($from, $to){
    544. 

  544.         global $sitepress_settings;
    545. 

  545.         if(isset($sitepress_settings['default_translators'][$from][$to])){
    546. 

  546.             $dt = $sitepress_settings['default_translators'][$from][$to];    
    547. 

  547.         }else{
    548. 

  548.             $dt = array();
    549. 

  549.         }
    550. 

  550.         return $dt; 
    551. 

  551.     }   
    552. 

  552.     
    553. 

  553.     public function get_blog_not_translators(){
    554. 

  554.         global $wpdb;
    555. 

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

  556.         if (!empty($cached_translators)) {
    557. 

  557.             return $cached_translators;
    558. 

  558.         }
    559. 

  559.         $sql = "SELECT u.ID, u.user_login, u.display_name, m.meta_value AS caps
    560. 

  560.             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";
    561. 

  561.         $res = $wpdb->get_results($sql);
    562. 

  562.         
    563. 

  563.         $users = array();
    564. 

  564.         foreach($res as $row){            
    565. 

  565.             $caps = @unserialize($row->caps);
    566. 

  566.             if(!isset($caps['translate'])){
    567. 

  567.                 $users[] = $row;    
    568. 

  568.             }  
    569. 

  569.         }                                     
    570. 

  570.         update_option($wpdb->prefix . 'icl_non_translators_cached', $users);
    571. 

  571.         return $users;
    572. 

  572.     }
    573. 

  573. 

  574.     /**
    575. 

  575.      * Implementation of 'icl_translators_list' hook
    576. 

  576.      *
    577. 

  577.      * @global object $sitepress
    578. 

  578.      * @param array $array
    579. 

  579.      * @return array
    580. 

  580.      */
    581. 

  581.     public function icanlocalize_translators_list() {  
    582. 

  582.       global $sitepress_settings, $sitepress;
    583. 

  583.       
    584. 

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

  585.       if (0 != key($lang_status)){
    586. 

  586.         $buf[] = $lang_status;  
    587. 

  587.         $lang_status = $buf;    
    588. 

  588.       }
    589. 

  589.       
    590. 

  590.       $translators = array();
    591. 

  591.       foreach($lang_status as $lpair){
    592. 

  592.           foreach((array)$lpair['translators'] as $translator){
    593. 

  593.             $translators[$translator['id']]['name'] = $translator['nickname'];
    594. 

  594.             $translators[$translator['id']]['langs'][$lpair['from']][] = $lpair['to'];
    595. 

  595.             $translators[$translator['id']]['type'] = 'ICanLocalize';
    596. 

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

  597.                 . '/website_translation_offers/' . $lpair['id'] . '/website_translation_contracts/'
    598. 

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

  599.           }
    600. 

  600.       }
    601. 

  601. 

  602.       return $translators;
    603. 

  603.     }
    604. 

  604.     
    605. 

  605.     public function get_blog_translators($args = array()){
    606. 

  606.         global $wpdb;
    607. 

  607.         $args_default = array('from'=>false, 'to'=>false);
    608. 

  608.         extract($args_default);
    609. 

  609.         extract($args, EXTR_OVERWRITE);
    610. 

  610. 

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

  612. //                    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";
    613. 

  613. //        $res = $wpdb->get_results($sql);
    614. 

  614. 

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

  616. 

  617.         if (empty($cached_translators)) {
    618. 

  618.             $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";
    619. 

  619.             $res = $wpdb->get_results($sql);
    620. 

  620.             update_option($wpdb->prefix . 'icl_translators_cached', $res);
    621. 

  621.         } else {
    622. 

  622.             $res = $cached_translators;
    623. 

  623.         }
    624. 

  624. 

  625.         $users = array();
    626. 

  626.         foreach($res as $row){
    627. 

  627.             $user = new WP_User($row->ID);
    628. 

  628. //            $caps = @unserialize($row->caps);
    629. 

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

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

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

  632. //                continue;
    633. 

  633. //            }
    634. 

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

  635.                 continue;
    636. 

  636.             }
    637. 

  637. //            if(isset($caps['translate'])){
    638. 

  638. //                $users[] = $user;
    639. 

  639. //            }
    640. 

  640.             if($user->has_cap('translate')){
    641. 

  641.                 $users[] = $user;
    642. 

  642.             }
    643. 

  643.         }
    644. 

  644.         return $users;
    645. 

  645.     }
    646. 

  646.     
    647. 

  647.     function get_selected_translator(){
    648. 

  648.         global $wpdb;
    649. 

  649.         if($this->selected_translator['ID']){
    650. 

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

  651.             $this->selected_translator['display_name'] =  $user->data->display_name;
    652. 

  652.             $this->selected_translator['user_login'] =  $user->data->user_login;
    653. 

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

  654.         }else{
    655. 

  655.             $this->selected_translator['ID'] = 0;
    656. 

  656.         }
    657. 

  657.         return (object)$this->selected_translator;    
    658. 

  658.     }
    659. 

  659.     
    660. 

  660.     function get_current_translator(){
    661. 

  661.         return $this->current_translator;
    662. 

  662.     }
    663. 

  663.     
    664. 

  664.     public function get_translator_edit_url($translator_id){
    665. 

  665.         $url = '';
    666. 

  666.         if(!empty($translator_id)){
    667. 

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

  668.         }
    669. 

  669.         return $url;
    670. 

  670.     }
    671. 

  671.     
    672. 

  672.     public function translators_dropdown($args = array()){
    673. 

  673.         global $sitepress_settings;
    674. 

  674.         $args_default = array(
    675. 

  675.             'from'=>false, 'to'=>false,
    676. 

  676.             'name'          => 'translator_id',
    677. 

  677.             'selected'      => 0,
    678. 

  678.             'echo'          => true,
    679. 

  679.             'services'      => array('local')
    680. 

  680.         );
    681. 

  681.         extract($args_default);
    682. 

  682.         extract($args, EXTR_OVERWRITE);
    683. 

  683. 

  684.         $translators = array();
    685. 

  685.         
    686. 

  686.         if(in_array('icanlocalize', $services)){
    687. 

  687.             if(empty($sitepress_settings['icl_lang_status'])) $sitepress_settings['icl_lang_status'] = array();
    688. 

  688.             foreach((array)$sitepress_settings['icl_lang_status'] as $langpair){
    689. 

  689.                 if($from && $from != $langpair['from']) continue;
    690. 

  690.                 if($to && $to != $langpair['to']) continue;
    691. 

  691.                 
    692. 

  692.                 if(!empty($langpair['translators'])){
    693. 

  693.                     if (1 < count($langpair['translators'])) {
    694. 

  694.                         $translators[] = (object) array(
    695. 

  695.                             'ID' => '0-icanlocalize',
    696. 

  696.                             'display_name' => __('First available', 'sitepress'),
    697. 

  697.                             'service'       => 'ICanLocalize'
    698. 

  698.                         );
    699. 

  699.                     }
    700. 

  700.                     foreach($langpair['translators'] as $tr){
    701. 

  701.                         if(!isset($_icl_translators[$tr['id']])){
    702. 

  702.                             $translators[] = $_icl_translators[$tr['id']] = (object) array(
    703. 

  703.                                 'ID'=>$tr['id'].'-icanlocalize', 
    704. 

  704.                                 'display_name'=>$tr['nickname'],
    705. 

  705.                                 'service'       => 'ICanLocalize'
    706. 

  706.                             );            
    707. 

  707.                         }
    708. 

  708.                     }
    709. 

  709.                 }    
    710. 

  710.             }
    711. 

  711.         }
    712. 

  712. 

  713.         if(in_array('local', $services)){
    714. 

  714.             $translators[] = (object) array(
    715. 

  715.                 'ID' => 0,
    716. 

  716.                 'display_name' => __('First available', 'sitepress'),
    717. 

  717.             );
    718. 

  718.             $translators = array_merge($translators, $this->get_blog_translators(array('from'=>$from,'to'=>$to)));
    719. 

  719.         }
    720. 

  720.         
    721. 

  721.         ?>
    722. 

  722.         <select name="<?php echo $name ?>">
    723. 

  723.             <?php foreach($translators as $t):?>
    724. 

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

  725.                  ?> (<?php if(isset($t->service)) echo $t->service; else _e('Local', 'sitepress'); ?>)</option>
    726. 

  726.             <?php endforeach; ?>
    727. 

  727.         </select>
    728. 

  728.         <?php
    729. 

  729.     }
    730. 

  730.     
    731. 

  731.     public function get_number_of_docs_sent($service = 'icanlocalize'){
    732. 

  732.         global $wpdb;
    733. 

  733.         $n = $wpdb->get_var($wpdb->prepare("
    734. 

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

  735.         ", $service));
    736. 

  736.         return $n;
    737. 

  737.     }
    738. 

  738. 

  739.     public function get_number_of_docs_pending($service = 'icanlocalize'){
    740. 

  740.         global $wpdb;
    741. 

  741.         $n = $wpdb->get_var($wpdb->prepare("
    742. 

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

  743.         ", $service));
    744. 

  744.         return $n;        
    745. 

  745.     }
    746. 

  746.     
    747. 

  747.         
    748. 

  748.     /* HOOKS */
    749. 

  749.     /* ******************************************************************************************** */
    750. 

  750.     function save_post_actions($post_id, $post, $force_set_status = false){
    751. 

  751.         global $wpdb, $sitepress, $sitepress_settings, $current_user;
    752. 

  752.         // skip revisions
    753. 

  753.         if($post->post_type == 'revision'){
    754. 

  754.             return;
    755. 

  755.         }
    756. 

  756.         // skip auto-drafts
    757. 

  757.         if($post->post_status == 'auto-draft'){
    758. 

  758.             return;
    759. 

  759.         }
    760. 

  760.         // skip autosave
    761. 

  761.         if(isset($_POST['autosave'])){
    762. 

  762.             return;
    763. 

  763.         }
    764. 

  764. 

  765.         // is this the original document? 
    766. 

  766.         if(!empty($_POST['icl_trid'])){
    767. 

  767.             $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, $_POST['icl_trid']));
    768. 

  768.         }
    769. 

  769.         
    770. 

  770.         // when a manual translation is added/edited make sure to update translation tables
    771. 

  771.         if(!empty($_POST['icl_trid']) && !$is_original){        
    772. 

  772.         
    773. 

  773.             $trid = $_POST['icl_trid'];
    774. 

  774.             $lang = $_POST['icl_post_language'];
    775. 

  775.             
    776. 

  776.             $res = $wpdb->get_row($wpdb->prepare("
    777. 

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

  778.             ", $trid));
    779. 

  779.             $original_post_id = $res->element_id;
    780. 

  780.             $from_lang = $res->language_code;
    781. 

  781.             $original_post = get_post($original_post_id);
    782. 

  782.             $translation_id = $wpdb->get_var($wpdb->prepare("
    783. 

  783.                 SELECT translation_id FROM {$wpdb->prefix}icl_translations WHERE trid=%d AND language_code='%s'
    784. 

  784.             ", $trid, $lang));
    785. 

  785.             $md5 = $this->post_md5($original_post);
    786. 

  786.             
    787. 

  787.         
    788. 

  788.             get_currentuserinfo();
    789. 

  789.             $user_id = $current_user->ID;
    790. 

  790.             
    791. 

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

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

  793.             }
    794. 

  794.             
    795. 

  795.             if($translation_id){
    796. 

  796.                 $translation_package = $this->create_translation_package($original_post_id);                    
    797. 

  797.                 
    798. 

  798.                 list($rid, $update) = $this->update_translation_status(array(
    799. 

  799.                     'translation_id'        => $translation_id,
    800. 

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

  801.                     'translator_id'         => $user_id,
    802. 

  802.                     'needs_update'          => 0,
    803. 

  803.                     'md5'                   => $md5,
    804. 

  804.                     'translation_service'   => 'local',
    805. 

  805.                     'translation_package'   => serialize($translation_package)
    806. 

  806.                 ));
    807. 

  807.                 if(!$update){
    808. 

  808.                     $job_id = $this->add_translation_job($rid, $user_id , $translation_package);
    809. 

  809.                 }else{
    810. 

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

  811.                 }
    812. 

  812.                 
    813. 

  813.                 
    814. 

  814.                 // saving the translation
    815. 

  815.                 $this->save_job_fields_from_post($job_id, $post);
    816. 

  816.                 
    817. 

  817.                 /*    
    818. 

  818.                 $data['complete'] = 1;
    819. 

  819.                 $data['job_id'] = $job_id;
    820. 

  820.                 
    821. 

  821.                 $job = $this->get_translation_job($job_id,1);
    822. 

  822.                 foreach($job->elements as $element){
    823. 

  823.                     $field_data = '';
    824. 

  824.                     switch($element->field_type){
    825. 

  825.                         case 'title':
    826. 

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

  827.                             break;
    828. 

  828.                         case 'body':
    829. 

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

  830.                             break;
    831. 

  831.                         case 'excerpt':
    832. 

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

  833.                             break;                           
    834. 

  834.                         default:
    835. 

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

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

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

  838.                                     if($this->settings['custom_fields_translation'][$cf_name] == 1){ //copy
    839. 

  839.                                         $field_data = get_post_meta($original_post->ID, $cf_name, 1);               
    840. 

  840.                                         $field_data = $this->encode_field_data($field_data, $element->field_format);                             
    841. 

  841.                                     }elseif($this->settings['custom_fields_translation'][$cf_name] == 2){ // translate
    842. 

  842.                                         $field_data = get_post_meta($post->ID, $cf_name, 1);             
    843. 

  843.                                         $field_data = $this->encode_field_data($field_data, $element->field_format);             
    844. 

  844.                                     }
    845. 

  845.                                 }
    846. 

  846.                             }else{
    847. 

  847.                                 // taxonomies                                                 
    848. 

  848.                                 // TBD
    849. 

  849.                             }
    850. 

  850.                     }
    851. 

    852. 

  852.                     $wpdb->update($wpdb->prefix.'icl_translate', 
    853. 

  853.                         array('field_data_translated'=>$field_data, 'field_finished'=>1), 
    854. 

  854.                         array('tid'=>$element->tid)
    855. 

  855.                     );
    856. 

  856.                     
    857. 

  857.                 }
    858. 

  858.                 $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translated'=>1), array('job_id'=>$job_id));    
    859. 

  859.                 */
    860. 

  860.                 
    861. 

  861.             }
    862. 

  862.         }
    863. 

  863.         
    864. 

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

  865.         if(!empty($_POST['icl_trid']) && empty($_POST['icl_minor_edit'])){
    866. 

  866.             $needs_update = false;
    867. 

  867.             $is_original  = false;
    868. 

  868.             $translations = $sitepress->get_element_translations($_POST['icl_trid'], 'post_' . $post->post_type);    
    869. 

  869. 

  870.             foreach($translations as $lang=>$translation){                
    871. 

  871.                 if($translation->original == 1 && $translation->element_id == $post_id){
    872. 

  872.                     $is_original = true;
    873. 

  873.                     break;
    874. 

  874.                 }
    875. 

  875.             }
    876. 

  876.             if($is_original){
    877. 

  877.                 $md5 = $this->post_md5($post_id);
    878. 

  878.                 foreach($translations as $lang=>$translation){                
    879. 

  879.                     if(!$translation->original){
    880. 

  880.                         $emd5 = $wpdb->get_var($wpdb->prepare("SELECT md5 FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation->translation_id));
    881. 

  881.                         if($md5 != $emd5){
    882. 

  882.                             $wpdb->update($wpdb->prefix.'icl_translation_status', array('needs_update'=>1, 'md5'=>$md5), array('translation_id'=>$translation->translation_id));
    883. 

  883.                         }
    884. 

  884.                     }
    885. 

  885.                 }
    886. 

  886.             }
    887. 

  887.         }
    888. 

  888.         
    889. 

  889.         // sync copies/duplicates
    890. 

  890.         $duplicates = $this->get_duplicates($post_id);
    891. 

  891.         foreach($duplicates as $lang => $_pid){
    892. 

  892.             $this->make_duplicate($post_id, $lang);
    893. 

  893.         }
    894. 

  894.         
    895. 

  895.         
    896. 

  896.         // review?
    897. 

  897.         /*
    898. 

  898.         if($_POST['icl_trid']){
    899. 

  899.             //
    900. 

  900.             // get original document
    901. 

  901.             $translations = $sitepress->get_element_translations($_POST['icl_trid'], 'post_' . $post->post_type);
    902. 

  902.             foreach($translations as $t){
    903. 

  903.                 if($t->original){
    904. 

  904.                     $origin = $t->language_code;
    905. 

  905.                 }
    906. 

  906.             }
    907. 

  907.             
    908. 

  908.             // remove ?            
    909. 

  909.             $rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_content_status WHERE nid = %d"), $post_id);
    910. 

  910.             if(!$rid){                
    911. 

  911.                 $wpdb->insert($wpdb->prefix.'icl_content_status', array('nid' => $post_id, 'md5'=>$this->post_md5($post), 'timestamp'=>date('Y-m-d H:i:s')));                
    912. 

  912.                 $rid = $wpdb->insert_id;
    913. 

  913.             }else{
    914. 

  914.                 $wpdb->update($wpdb->prefix.'icl_content_status', array('md5'=>$this->post_md5($post)), array('rid'=>$rid));                
    915. 

  915.             }
    916. 

  916.             
    917. 

  917.             // add update icl_core_status entry
    918. 

  918.             $id = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_core_status WHERE rid = %d AND target= = %s"), $rid, $_POST['icl_post_language']);
    919. 

  919.             if(!$id){
    920. 

  920.                 $wpdb->insert($wpdb->prefix.'icl_core_status', array('rid' => $rid, 'origin' => $origin, 'target' => $_POST['icl_post_language'], 'status' => 1 ));  //!!!!!!!               
    921. 

  921.             }else{
    922. 

  922.                 $wpdb->update($wpdb->prefix.'icl_content_status', array('md5'=>$this->post_md5($post)), array('rid'=>$rid));                
    923. 

  923.             }
    924. 

  924.             
    925. 

  925.         }
    926. 

  926.         */
    927. 

  927.         
    928. 

  928.     }
    929. 

  929.     
    930. 

  930.     function delete_post_actions($post_id){
    931. 

  931.         global $wpdb;
    932. 

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

  933.         if(!empty($post_type)){
    934. 

  934.             $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));                
    935. 

  935.             if($translation_id){
    936. 

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

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

  938.                 if($rid){
    939. 

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

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

  941.                     if(!empty($jobs)){
    942. 

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

  943.                     }
    944. 

  944.                 }
    945. 

  945.             }
    946. 

  946.         }
    947. 

  947.     }
    948. 

  948.     
    949. 

  949.     /* TRANSLATIONS */
    950. 

  950.     /* ******************************************************************************************** */
    951. 

  951.     /**
    952. 

  952.     * calculate post md5
    953. 

  953.     * 
    954. 

  954.     * @param object|int $post
    955. 

  955.     * @return string
    956. 

  956.     * 
    957. 

  957.     * @todo full support for custom posts and custom taxonomies
    958. 

  958.     */
    959. 

  959.     function post_md5($post){
    960. 

  960.         
    961. 

  961.         if (isset($post->external_type) && $post->external_type) {
    962. 

  962.             
    963. 

  963.             $md5str = '';
    964. 

  964.             
    965. 

  965.             foreach ($post->string_data as $key => $value) {
    966. 

  966.                 $md5str .= $key . $value;
    967. 

  967.             }
    968. 

  968.             
    969. 

  969.             
    970. 

  970.         } else {
    971. 

  971.         
    972. 

  972.             $post_tags = $post_categories = $custom_fields_values = array();
    973. 

  973.             
    974. 

  974.             if(is_numeric($post)){
    975. 

  975.                 $post = get_post($post);    
    976. 

  976.             }
    977. 

  977.             
    978. 

  978.             $post_type = $post->post_type;
    979. 

  979.             
    980. 

  980.             if($post_type=='post'){
    981. 

  981.                 foreach(wp_get_object_terms($post->ID, 'post_tag') as $tag){
    982. 

  982.                     $post_tags[] = $tag->name;
    983. 

  983.                 }
    984. 

  984.                 if(is_array($post_tags)){
    985. 

  985.                     sort($post_tags, SORT_STRING);
    986. 

  986.                 }        
    987. 

  987.                 foreach(wp_get_object_terms($post->ID, 'category') as $cat){
    988. 

  988.                     $post_categories[] = $cat->name;
    989. 

  989.                 }    
    990. 

  990.                 if(is_array($post_categories)){
    991. 

  991.                     sort($post_categories, SORT_STRING);
    992. 

  992.                 }
    993. 

  993.                 
    994. 

  994.                 global $wpdb, $sitepress_settings;
    995. 

  995.                 // get custom taxonomies
    996. 

  996.                 $taxonomies = $wpdb->get_col("
    997. 

  997.                     SELECT DISTINCT tx.taxonomy 
    998. 

  998.                     FROM {$wpdb->term_taxonomy} tx JOIN {$wpdb->term_relationships} tr ON tx.term_taxonomy_id = tr.term_taxonomy_id
    999. 

  999.                     WHERE tr.object_id = {$post->ID}
    1000. 

  1000.                 ");
    1001. 

  1001.                 sort($taxonomies, SORT_STRING);
    1002. 

  1002.                 foreach($taxonomies as $t){
    1003. 

  1003.                     if(@intval($sitepress_settings['taxonomies_sync_option'][$t]) == 1){
    1004. 

  1004.                         $taxs = array();
    1005. 

  1005.                         foreach(wp_get_object_terms($post->ID, $t) as $trm){
    1006. 

  1006.                             $taxs[] = $trm->name;
    1007. 

  1007.                         }
    1008. 

  1008.                         if($taxs){
    1009. 

  1009.                             sort($taxs,SORT_STRING);
    1010. 

  1010.                             $all_taxs[] = '['.$t.']:'.join(',',$taxs);
    1011. 

  1011.                         }
    1012. 

  1012.                     }
    1013. 

  1013.                 }
    1014. 

  1014.             }
    1015. 

  1015.             
    1016. 

  1016.             $custom_fields_values = array();
    1017. 

  1017.             if(is_array($this->settings['custom_fields_translation'])){
    1018. 

  1018.                 foreach($this->settings['custom_fields_translation'] as $cf => $op){
    1019. 

  1019.                     if ($op == 2) {
    1020. 

  1020.                         $custom_fields_values[] = get_post_meta($post->ID, $cf, true);
    1021. 

  1021.                     }
    1022. 

  1022.                 }
    1023. 

  1023.             }
    1024. 

  1024.             
    1025. 

  1025.             $md5str =         
    1026. 

  1026.                 $post->post_title . ';' . 
    1027. 

  1027.                 $post->post_content . ';' . 
    1028. 

  1028.                 join(',',$post_tags).';' . 
    1029. 

  1029.                 join(',',$post_categories) . ';' . 
    1030. 

  1030.                 join(',', $custom_fields_values);
    1031. 

  1031.             if(!empty($all_taxs)){
    1032. 

  1032.                 $md5str .= ';' . join(';', $all_taxs);
    1033. 

  1033.             }
    1034. 

  1034.         }
    1035. 

  1035.         $md5 = md5($md5str);
    1036. 

  1036.                     
    1037. 

  1037.         return $md5;        
    1038. 

  1038.     }
    1039. 

  1039.     
    1040. 

  1040.     /**
    1041. 

  1041.     * get documents
    1042. 

  1042.     * 
    1043. 

  1043.     * @param array $args
    1044. 

  1044.     */
    1045. 

  1045.     function get_documents($args){
    1046. 

  1046.         
    1047. 

  1047.         extract($args);
    1048. 

  1048.         
    1049. 

  1049.         global $wpdb, $wp_query, $sitepress;
    1050. 

  1050.         
    1051. 

  1051.         $t_el_types = array_keys($sitepress->get_translatable_documents());
    1052. 

  1052.         
    1053. 

  1053.         // SELECT
    1054. 

  1054.         $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";
    1055. 

  1055.         if($to_lang){
    1056. 

  1056.             $select .= ", iclts.status, iclts.needs_update";
    1057. 

  1057.         }else{
    1058. 

  1058.             foreach($sitepress->get_active_languages() as $lang){
    1059. 

  1059.                 if($lang['code'] == $from_lang) continue;
    1060. 

  1060.                 $tbl_alias_suffix = str_replace('-','_',$lang['code']);                
    1061. 

  1061.                 $select .= ", iclts_{$tbl_alias_suffix}.status AS status_{$tbl_alias_suffix}, iclts_{$tbl_alias_suffix}.needs_update AS needs_update_{$tbl_alias_suffix}";
    1062. 

  1062.             }
    1063. 

  1063.         }
    1064. 

  1064.         
    1065. 

  1065.         // FROM
    1066. 

  1066.         $from   = " {$wpdb->posts} p";
    1067. 

  1067.         
    1068. 

  1068.         // JOIN
    1069. 

  1069.         $join = "";        
    1070. 

  1070.         $join   .= " LEFT JOIN {$wpdb->prefix}icl_translations t ON t.element_id=p.ID\n";    
    1071. 

  1071.         if($to_lang){
    1072. 

  1072.             $tbl_alias_suffix = str_replace('-','_',$to_lang);
    1073. 

  1073.             $join .= " LEFT JOIN {$wpdb->prefix}icl_translations iclt_{$tbl_alias_suffix} 
    1074. 

  1074.                         ON iclt_{$tbl_alias_suffix}.trid=t.trid AND iclt_{$tbl_alias_suffix}.language_code='{$to_lang}'\n";    
    1075. 

  1075.             $join   .= " LEFT JOIN {$wpdb->prefix}icl_translation_status iclts ON iclts.translation_id=iclt_{$tbl_alias_suffix}.translation_id\n";    
    1076. 

  1076.         }else{
    1077. 

  1077.             foreach($sitepress->get_active_languages() as $lang){
    1078. 

  1078.                 if($lang['code'] == $from_lang) continue;
    1079. 

  1079.                 $tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1080. 

  1080.                 $join .= " LEFT JOIN {$wpdb->prefix}icl_translations iclt_{$tbl_alias_suffix} 
    1081. 

  1081.                         ON iclt_{$tbl_alias_suffix}.trid=t.trid AND iclt_{$tbl_alias_suffix}.language_code='{$lang['code']}'\n";    
    1082. 

  1082.                 $join   .= " LEFT JOIN {$wpdb->prefix}icl_translation_status iclts_{$tbl_alias_suffix} 
    1083. 

  1083.                         ON iclts_{$tbl_alias_suffix}.translation_id=iclt_{$tbl_alias_suffix}.translation_id\n";    
    1084. 

  1084.             }
    1085. 

  1085.         }
    1086. 

  1086.         
    1087. 

  1087.         
    1088. 

  1088.         // WHERE
    1089. 

  1089.         $where = " t.language_code = '{$from_lang}' AND p.post_status NOT IN ('trash', 'auto-draft') \n";        
    1090. 

  1090.         if(!empty($type)){
    1091. 

  1091.             $where .= " AND p.post_type = '{$type}'";
    1092. 

  1092.             $where .= " AND t.element_type = 'post_{$type}'\n";
    1093. 

  1093.         }else{
    1094. 

  1094.             $where .= " AND p.post_type IN ('".join("','",$t_el_types)."')\n";
    1095. 

  1095.             foreach($t_el_types as $k=>$v){
    1096. 

  1096.                 $t_el_types[$k] = 'post_' . $v;
    1097. 

  1097.             }
    1098. 

  1098.             $where .= " AND t.element_type IN ('".join("','",$t_el_types)."')\n";
    1099. 

  1099.         }  
    1100. 

  1100.         if(!empty($title)){
    1101. 

  1101.             $where .= " AND p.post_title LIKE '%".$wpdb->escape($title)."%'\n";
    1102. 

  1102.         }
    1103. 

  1103.         
    1104. 

  1104.         if(!empty($status)){
    1105. 

  1105.             $where .= " AND p.post_status = '{$status}'\n";
    1106. 

  1106.         }        
    1107. 

  1107.         
    1108. 

  1108.         if(isset($from_date)){
    1109. 

  1109.             $where .= " AND p.post_date > '{$from_date}'\n";
    1110. 

  1110.         }
    1111. 

  1111. 

  1112.         if(isset($to_date)){
    1113. 

  1113.             $where .= " AND p.post_date > '{$to_date}'\n";
    1114. 

  1114.         }
    1115. 

  1115.         
    1116. 

  1116.         if($tstatus){
    1117. 

  1117.             if($to_lang){
    1118. 

  1118.                 if($tstatus == 'not'){
    1119. 

  1119.                     $where .= " AND (iclts.status IS NULL OR iclts.status = ".ICL_TM_WAITING_FOR_TRANSLATOR." OR iclts.needs_update = 1)\n";    
    1120. 

  1120.                 }elseif($tstatus == 'in_progress'){
    1121. 

  1121.                     $where .= " AND iclts.status = ".ICL_TM_IN_PROGRESS." AND iclts.needs_update = 0\n";    
    1122. 

  1122.                 }elseif($tstatus == 'complete'){
    1123. 

  1123.                     $where .= " AND iclts.status = ".ICL_TM_COMPLETE." AND iclts.needs_update = 0\n";    
    1124. 

  1124.                 }
    1125. 

  1125.                 
    1126. 

  1126.             }else{
    1127. 

  1127.                 if($tstatus == 'not'){
    1128. 

  1128.                     $where .= " AND (";
    1129. 

  1129.                     $wheres = array();
    1130. 

  1130.                     foreach($sitepress->get_active_languages() as $lang){
    1131. 

  1131.                         if($lang['code'] == $from_lang) continue;
    1132. 

  1132.                         $tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1133. 

  1133.                         $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";    
    1134. 

  1134.                     }
    1135. 

  1135.                     $where .= join(' OR ', $wheres) . ")";
    1136. 

  1136.                 }elseif($tstatus == 'in_progress'){
    1137. 

  1137.                     $where .= " AND (";
    1138. 

  1138.                     $wheres = array();
    1139. 

  1139.                     foreach($sitepress->get_active_languages() as $lang){
    1140. 

  1140.                         if($lang['code'] == $from_lang) continue;
    1141. 

  1141.                         $tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1142. 

  1142.                         $wheres[] = "iclts_{$tbl_alias_suffix}.status = ".ICL_TM_IN_PROGRESS."\n";    
    1143. 

  1143.                     }
    1144. 

  1144.                     $where .= join(' OR ', $wheres)  . ")";
    1145. 

  1145.                 }elseif($tstatus == 'complete'){
    1146. 

  1146.                     foreach($sitepress->get_active_languages() as $lang){
    1147. 

  1147.                         if($lang['code'] == $from_lang) continue;
    1148. 

  1148.                         $tbl_alias_suffix = str_replace('-','_',$lang['code']);
    1149. 

  1149.                         $where .= " AND iclts_{$tbl_alias_suffix}.status = ".ICL_TM_COMPLETE." AND iclts_{$tbl_alias_suffix}.needs_update = 0\n";    
    1150. 

  1150.                     }
    1151. 

  1151.                 }
    1152. 

  1152.             }
    1153. 

  1153.         }
    1154. 

  1154.         
    1155. 

  1155.         if(isset($parent_type) && $parent_type == 'page' && $parent_id > 0){            
    1156. 

  1156.             if($parent_all){
    1157. 

  1157.                 $children = icl_get_post_children_recursive($parent_id);    
    1158. 

  1158.                 $where .= ' AND p.ID IN (' . join(',', $children) . ')';
    1159. 

  1159.             }else{
    1160. 

  1160.                 $where .= ' AND p.post_parent=' . intval($parent_id);
    1161. 

  1161.             }
    1162. 

  1162.         }
    1163. 

  1163.         
    1164. 

  1164.         if(isset($parent_type) && $parent_type == 'category' && $parent_id > 0){
    1165. 

  1165.             if($parent_all){
    1166. 

  1166.                 $children = icl_get_tax_children_recursive($parent_id);  
    1167. 

  1167.                 $children[] = $parent_id;
    1168. 

  1168.                 $join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id 
    1169. 

  1169.                             JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'
    1170. 

  1170.                             JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id IN(" . join(',', $children) . ")"; 
    1171. 

  1171.             }else{
    1172. 

  1172.                 $join .= "  JOIN {$wpdb->term_relationships} tr ON p.ID = tr.object_id 
    1173. 

  1173.                             JOIN {$wpdb->term_taxonomy} tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND taxonomy = 'category'
    1174. 

  1174.                             JOIN {$wpdb->terms} tm ON tt.term_id = tm.term_id AND tm.term_id = " . intval($parent_id); 
    1175. 

  1175.             }
    1176. 

  1176.         }
    1177. 

  1177.         
    1178. 

  1178.         // ORDER
    1179. 

  1179.         if($sort_by){
    1180. 

  1180.             $order = " $sort_by ";    
    1181. 

  1181.         }else{
    1182. 

  1182.             $order = " p.post_date DESC";
    1183. 

  1183.         }
    1184. 

  1184.         if($sort_order){
    1185. 

  1185.             $order .= $sort_order;    
    1186. 

  1186.         }else{
    1187. 

  1187.             $order .= 'DESC';    
    1188. 

  1188.         }
    1189. 

  1189.         
    1190. 

  1190.         
    1191. 

  1191.         
    1192. 

  1192.         // LIMIT
    1193. 

  1193.         if(!isset($_GET['paged'])) $_GET['paged'] = 1;
    1194. 

  1194.         $offset = ($_GET['paged']-1)*$limit_no;
    1195. 

  1195.         $limit = " " . $offset . ',' . $limit_no;
    1196. 

  1196.         
    1197. 

  1197.         
    1198. 

  1198.         $sql = "
    1199. 

  1199.             SELECT SQL_CALC_FOUND_ROWS {$select} 
    1200. 

  1200.             FROM {$from}
    1201. 

  1201.             {$join}
    1202. 

  1202.             WHERE {$where}
    1203. 

  1203.             ORDER BY {$order}
    1204. 

  1204.             LIMIT {$limit}
    1205. 

  1205.         ";  
    1206. 

  1206.         
    1207. 

  1207.         $results = $wpdb->get_results($sql);    
    1208. 

  1208.         
    1209. 

  1209.         $count = $wpdb->get_var("SELECT FOUND_ROWS()");
    1210. 

  1210.         
    1211. 

  1211.         $wp_query->found_posts = $count;
    1212. 

  1212.         $wp_query->query_vars['posts_per_page'] = $limit_no;
    1213. 

  1213.         $wp_query->max_num_pages = ceil($wp_query->found_posts/$limit_no);
    1214. 

  1214.         
    1215. 

  1215.         // post process
    1216. 

  1216.         foreach($results as $k=>$v){
    1217. 

  1217.             if($v->is_translation){
    1218. 

  1218.                 $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));    
    1219. 

  1219.                 $_tmp = 'status_' . $source_language;
    1220. 

  1220.                 $v->$_tmp = ICL_TM_COMPLETE;
    1221. 

  1221.             }    
    1222. 

  1222.         }
    1223. 

  1223.           
    1224. 

  1224.         return $results;
    1225. 

  1225.         
    1226. 

  1226.     }   
    1227. 

  1227.     
    1228. 

  1228.     function get_element_translation($element_id, $language, $element_type='post_post'){
    1229. 

  1229.         global $wpdb, $sitepress;
    1230. 

  1230.         $trid = $sitepress->get_element_trid($element_id, $element_type);
    1231. 

  1231.         $translation = array();
    1232. 

  1232.         if($trid){
    1233. 

  1233.             $translation = $wpdb->get_row($wpdb->prepare("
    1234. 

  1234.                 SELECT * 
    1235. 

  1235.                 FROM {$wpdb->prefix}icl_translations tr 
    1236. 

  1236.                 JOIN {$wpdb->prefix}icl_translation_status ts ON tr.translation_id = ts.translation_id 
    1237. 

  1237.                 WHERE tr.trid=%s AND tr.language_code='%s'
    1238. 

  1238.             ", $trid, $language));        
    1239. 

  1239.         }
    1240. 

  1240.         return $translation;
    1241. 

  1241.     }
    1242. 

  1242.     
    1243. 

  1243.     function get_element_translations($element_id, $element_type='post_post', $service = false){
    1244. 

  1244.         global $wpdb, $sitepress;
    1245. 

  1245.         $trid = $sitepress->get_element_trid($element_id, $element_type);
    1246. 

  1246.         $translations = array();
    1247. 

  1247.         if($trid){
    1248. 

  1248.             $service =  $service ? " AND translation_service = '$service'" : '';
    1249. 

  1249.             $translations = $wpdb->get_results($wpdb->prepare("
    1250. 

  1250.                 SELECT * 
    1251. 

  1251.                 FROM {$wpdb->prefix}icl_translations tr 
    1252. 

  1252.                 JOIN {$wpdb->prefix}icl_translation_status ts ON tr.translation_id = ts.translation_id 
    1253. 

  1253.                 WHERE tr.trid=%s {$service} 
    1254. 

  1254.             ", $trid)); 
    1255. 

  1255.             foreach($translations as $k=>$v){
    1256. 

  1256.                 $translations[$v->language_code] = $v;
    1257. 

  1257.                 unset($translations[$k]);
    1258. 

  1258.             }      
    1259. 

  1259.         }
    1260. 

  1260.         return $translations;
    1261. 

  1261.     }
    1262. 

  1262.     
    1263. 

  1263.     /**
    1264. 

  1264.     * returns icon file name according to status code
    1265. 

  1265.     * 
    1266. 

  1266.     * @param int $status
    1267. 

  1267.     */
    1268. 

  1268.     public function status2img_filename($status, $needs_update = 0){
    1269. 

  1269.         if($needs_update){
    1270. 

  1270.             $img_file = 'needs-update.png'; 
    1271. 

  1271.         }else{
    1272. 

  1272.             switch($status){
    1273. 

  1273.                 case ICL_TM_NOT_TRANSLATED: $img_file = 'not-translated.png'; break;
    1274. 

  1274.                 case ICL_TM_WAITING_FOR_TRANSLATOR: $img_file = 'in-progress.png'; break;
    1275. 

  1275.                 case ICL_TM_IN_PROGRESS: $img_file = 'in-progress.png'; break;
    1276. 

  1276.                 case ICL_TM_NEEDS_UPDATE: $img_file = 'needs-update.png'; break;
    1277. 

  1277.                 case ICL_TM_DUPLICATE: $img_file = 'copy.png'; break;
    1278. 

  1278.                 case ICL_TM_COMPLETE: $img_file = 'complete.png'; break;
    1279. 

  1279.                 default: $img_file = '';
    1280. 

  1280.             }
    1281. 

  1281.         }
    1282. 

  1282.         return $img_file;
    1283. 

  1283.     }
    1284. 

  1284.     
    1285. 

  1285.     public function status2text($status){
    1286. 

  1286.         switch($status){
    1287. 

  1287.             case ICL_TM_NOT_TRANSLATED: $text = __('Not translated', 'sitepress'); break;
    1288. 

  1288.             case ICL_TM_WAITING_FOR_TRANSLATOR: $text = __('Waiting for translator', 'sitepress'); break;
    1289. 

  1289.             case ICL_TM_IN_PROGRESS: $text = __('In progress', 'sitepress'); break;
    1290. 

  1290.             case ICL_TM_NEEDS_UPDATE: $text = __('Needs update', 'sitepress'); break;
    1291. 

  1291.             case ICL_TM_DUPLICATE: $text = __('Duplicate', 'sitepress'); break;
    1292. 

  1292.             case ICL_TM_COMPLETE: $text = __('Complete', 'sitepress'); break;
    1293. 

  1293.             default: $text = '';
    1294. 

  1294.         }
    1295. 

  1295.         return $text;
    1296. 

  1296.     } 
    1297. 

  1297.     
    1298. 

  1298.     public function estimate_word_count($data, $lang_code){
    1299. 

  1299.         global $asian_languages;
    1300. 

  1300.         
    1301. 

  1301.         $words = 0;
    1302. 

  1302.         if(isset($data->post_title)){
    1303. 

  1303.             if(in_array($lang_code, $asian_languages)){
    1304. 

  1304.                 $words += strlen(strip_tags($data->post_title)) / 6;
    1305. 

  1305.             } else {
    1306. 

  1306.                 $words += count(explode(' ',$data->post_title));
    1307. 

  1307.             }
    1308. 

  1308.         }
    1309. 

  1309.         if(isset($data->post_content)){
    1310. 

  1310.             if(in_array($lang_code, $asian_languages)){
    1311. 

  1311.                 $words += strlen(strip_tags($data->post_content)) / 6;
    1312. 

  1312.             } else {
    1313. 

  1313.                 $words += count(explode(' ',strip_tags($data->post_content)));
    1314. 

  1314.             }
    1315. 

  1315.         }
    1316. 

  1316.         
    1317. 

  1317.         return (int)$words;
    1318. 

  1318.         
    1319. 

  1319.     }
    1320. 

  1320.     
    1321. 

  1321.     public function estimate_custom_field_word_count($post_id, $lang_code) {
    1322. 

  1322.         global $asian_languages;
    1323. 

  1323. 

  1324.         $words = 0;
    1325. 

  1325.         
    1326. 

  1326.         if(!empty($this->settings['custom_fields_translation']) && is_array($this->settings['custom_fields_translation'])){
    1327. 

  1327.             $custom_fields = array();        
    1328. 

  1328.             foreach($this->settings['custom_fields_translation'] as $cf => $op){
    1329. 

  1329.                 if ($op == 2) {
    1330. 

  1330.                     $custom_fields[] = $cf;
    1331. 

  1331.                 }
    1332. 

  1332.             }
    1333. 

  1333.             foreach($custom_fields as $cf ){
    1334. 

  1334.                 $custom_fields_value = get_post_meta($post_id, $cf, true);
    1335. 

  1335.                 if ($custom_fields_value != "" && is_scalar($custom_fields_value)) {  // only support scalar values fo rnow
    1336. 

  1336.                     if(in_array($lang_code, $asian_languages)){ 
    1337. 

  1337.                         $words += strlen(strip_tags($custom_fields_value)) / 6;
    1338. 

  1338.                     } else {
    1339. 

  1339.                         $words += count(explode(' ',strip_tags($custom_fields_value)));
    1340. 

  1340.                     }
    1341. 

  1341.                 }
    1342. 

  1342.             }
    1343. 

  1343.         }
    1344. 

  1344.                 
    1345. 

  1345.         return (int)$words;
    1346. 

  1346.     }
    1347. 

  1347.     
    1348. 

  1348.     public function decode_field_data($data, $format){
    1349. 

  1349.         if($format == 'base64'){
    1350. 

  1350.             $data = base64_decode($data);
    1351. 

  1351.         }elseif($format == 'csv_base64'){
    1352. 

  1352.             $exp = explode(',', $data);
    1353. 

  1353.             foreach($exp as $k=>$e){
    1354. 

  1354.                 $exp[$k] = base64_decode(trim($e,'"'));
    1355. 

  1355.             }
    1356. 

  1356.             $data = $exp;
    1357. 

  1357.         }
    1358. 

  1358.         return $data;
    1359. 

  1359.     }
    1360. 

  1360.     
    1361. 

  1361.     public function encode_field_data($data, $format){        
    1362. 

  1362.         if($format == 'base64'){
    1363. 

  1363.             $data = base64_encode($data);
    1364. 

  1364.         }elseif($format == 'csv_base64'){
    1365. 

  1365.             $exp = $data;
    1366. 

  1366.             foreach($exp as $k=>$e){
    1367. 

  1367.                 $exp[$k] = '"' . base64_encode(trim($e)) . '"';
    1368. 

  1368.             }
    1369. 

  1369.             $data = join(',', $exp);
    1370. 

  1370.         }
    1371. 

  1371.         return $data;
    1372. 

  1372.     }
    1373. 

  1373.     
    1374. 

  1374.     /**
    1375. 

  1375.     * create translation package 
    1376. 

  1376.     * 
    1377. 

  1377.     * @param object|int $post
    1378. 

  1378.     */
    1379. 

  1379.     function create_translation_package($post){
    1380. 

  1380.         global $sitepress, $sitepress_settings;
    1381. 

  1381.         
    1382. 

  1382.         $package = array();
    1383. 

  1383.         
    1384. 

  1384.        
    1385. 

  1385.         if(is_numeric($post)){
    1386. 

  1386.             $post = get_post($post);    
    1387. 

  1387.         }
    1388. 

  1388. 

  1389.         if (isset($post->external_type) && $post->external_type) {
    1390. 

  1390. 

  1391.             foreach ($post->string_data as $key => $value) {
    1392. 

  1392.                 $package['contents'][$key] = array(
    1393. 

  1393.                     'translate' => 1,
    1394. 

  1394.                     'data'      => $this->encode_field_data($value, 'base64'),
    1395. 

  1395.                     'format'    => 'base64'
    1396. 

  1396.                 );
    1397. 

  1397.             }
    1398. 

  1398.             
    1399. 

  1399.             $package['contents']['original_id'] = array(
    1400. 

  1400.                 'translate' => 0,
    1401. 

  1401.                 'data'      => $post->post_id,
    1402. 

  1402.             );
    1403. 

  1403.             
    1404. 

  1404.         
    1405. 

  1405.         } else {
    1406. 

  1406.             if($post->post_type=='page'){
    1407. 

  1407.                 $package['url'] = htmlentities(get_option('home') . '?page_id=' . ($post->ID));
    1408. 

  1408.             }else{
    1409. 

  1409.                 $package['url'] = htmlentities(get_option('home') . '?p=' . ($post->ID));
    1410. 

  1410.             }
    1411. 

  1411.             
    1412. 

  1412.             $package['contents']['title'] = array(
    1413. 

  1413.                 'translate' => 1,
    1414. 

  1414.                 'data'      => $this->encode_field_data($post->post_title, 'base64'),
    1415. 

  1415.                 'format'    => 'base64'
    1416. 

  1416.             );
    1417. 

  1417.             
    1418. 

  1418.             if($sitepress_settings['translated_document_page_url'] == 'translate'){
    1419. 

  1419.                 $package['contents']['URL'] = array(
    1420. 

  1420.                     'translate' => 1,
    1421. 

  1421.                     'data'      => $this->encode_field_data($post->post_name, 'base64'),
    1422. 

  1422.                     'format'    => 'base64'
    1423. 

  1423.                 );
    1424. 

  1424.             }
    1425. 

  1425.             
    1426. 

  1426.             $package['contents']['body'] = array(
    1427. 

  1427.                 'translate' => 1,
    1428. 

  1428.                 'data'      => $this->encode_field_data($post->post_content, 'base64'),
    1429. 

  1429.                 'format'    => 'base64'
    1430. 

  1430.             );
    1431. 

  1431.     
    1432. 

  1432.             if(!empty($post->post_excerpt)){
    1433. 

  1433.                 $package['contents']['excerpt'] = array(
    1434. 

  1434.                     'translate' => 1,
    1435. 

  1435.                     'data'      => base64_encode($post->post_excerpt),
    1436. 

  1436.                     'format'    => 'base64'
    1437. 

  1437.                 );
    1438. 

  1438.             }
    1439. 

  1439.             
    1440. 

  1440.             $package['contents']['original_id'] = array(
    1441. 

  1441.                 'translate' => 0,
    1442. 

  1442.                 'data'      => $post->ID
    1443. 

  1443.             );
    1444. 

  1444.                     
    1445. 

  1445.             if(!empty($this->settings['custom_fields_translation']))
    1446. 

  1446.             foreach($this->settings['custom_fields_translation'] as $cf => $op){
    1447. 

  1447.                 if ($op == 2) { // translate
    1448. 

  1448.                 
    1449. 

  1449.                     /* */
    1450. 

  1450.                     $custom_fields_value = get_post_meta($post->ID, $cf, true);
    1451. 

  1451.                     if ($custom_fields_value != '' && is_scalar($custom_fields_value)) {
    1452. 

  1452.                         $package['contents']['field-'.$cf] = array(
    1453. 

  1453.                             'translate' => 1,
    1454. 

  1454.                             'data' => $this->encode_field_data($custom_fields_value, 'base64'),
    1455. 

  1455.                             'format' => 'base64'
    1456. 

  1456.                         );
    1457. 

  1457.                         $package['contents']['field-'.$cf.'-name'] = array(
    1458. 

  1458.                             'translate' => 0,
    1459. 

  1459.                             'data' => $cf
    1460. 

  1460.                         );
    1461. 

  1461.                         $package['contents']['field-'.$cf.'-type'] = array(
    1462. 

  1462.                             'translate' => 0,
    1463. 

  1463.                             'data' => 'custom_field'
    1464. 

  1464.                         );
    1465. 

  1465.                     }                    
    1466. 

  1466.                     /* */
    1467. 

  1467.                     /*    
    1468. 

  1468.                     $post_custom = get_post_custom($post->ID);
    1469. 

  1469.                     if(isset($post_custom[$cf])){
    1470. 

  1470.                         $package['contents']['field-'.$cf] = array(
    1471. 

  1471.                             'translate' => 1,
    1472. 

  1472.                             'data' => $this->encode_field_data(serialize($post_custom[$cf]), 'base64'),
    1473. 

  1473.                             'format' => 'base64'
    1474. 

  1474.                         );
    1475. 

  1475.                         $package['contents']['field-'.$cf.'-name'] = array(
    1476. 

  1476.                             'translate' => 0,
    1477. 

  1477.                             'data' => $cf
    1478. 

  1478.                         );
    1479. 

  1479.                         $package['contents']['field-'.$cf.'-type'] = array(
    1480. 

  1480.                             'translate' => 0,
    1481. 

  1481.                             'data' => 'custom_field'
    1482. 

  1482.                         );
    1483. 

  1483.                     }
    1484. 

  1484.                     */
    1485. 

  1485.                 }
    1486. 

  1486.             } 
    1487. 

  1487.             
    1488. 

  1488.             foreach((array)$sitepress->get_translatable_taxonomies(true, $post->post_type) as $taxonomy){
    1489. 

  1489.                 $terms = get_the_terms( $post->ID , $taxonomy );
    1490. 

  1490.                 if(!empty($terms)){
    1491. 

  1491.                     $_taxs = $_tax_ids = array();
    1492. 

  1492.                     foreach($terms as $term){
    1493. 

  1493.                         $_taxs[] = $term->name;    
    1494. 

  1494.                         $_tax_ids[] = $term->term_taxonomy_id;
    1495. 

  1495.                     }
    1496. 

  1496.                     if($taxonomy == 'post_tag'){ 
    1497. 

  1497.                         $tax_package_key  = 'tags'; 
    1498. 

  1498.                         $tax_id_package_key  = 'tag_ids'; 
    1499. 

  1499.                     }
    1500. 

  1500.                     elseif($taxonomy == 'category'){
    1501. 

  1501.                         $tax_package_key  = 'categories'; 
    1502. 

  1502.                         $tax_id_package_key  = 'category_ids'; 
    1503. 

  1503.                     }
    1504. 

  1504.                     else{
    1505. 

  1505.                         $tax_package_key  = $taxonomy;
    1506. 

  1506.                         $tax_id_package_key  = $taxonomy . '_ids'; 
    1507. 

  1507.                     } 
    1508. 

  1508.                     
    1509. 

  1509.                     $package['contents'][$tax_package_key] = array(
    1510. 

  1510.                         'translate' => 1,
    1511. 

  1511.                         'data'      => $this->encode_field_data($_taxs,'csv_base64'),
    1512. 

  1512.                         'format'=>'csv_base64'
    1513. 

  1513.                     );
    1514. 

  1514.                     
    1515. 

  1515.                     $package['contents'][$tax_id_package_key] = array(
    1516. 

  1516.                         'translate' => 0,
    1517. 

  1517.                         'data'      => join(',', $_tax_ids)
    1518. 

  1518.                     );
    1519. 

  1519.                 }            
    1520. 

  1520.             }
    1521. 

  1521.         }
    1522. 

  1522.         return $package;
    1523. 

  1523.     }    
    1524. 

  1524.     
    1525. 

  1525.     /**
    1526. 

  1526.     * add/update icl_translation_status record
    1527. 

  1527.     * 
    1528. 

  1528.     * @param array $data
    1529. 

  1529.     */
    1530. 

  1530.     function update_translation_status($data){
    1531. 

  1531.         global $wpdb;
    1532. 

  1532.         if(!isset($data['translation_id'])) return;
    1533. 

  1533.         if($rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translation_status WHERE translation_id=%d", $data['translation_id']))){
    1534. 

  1534.             
    1535. 

  1535.             $wpdb->update($wpdb->prefix.'icl_translation_status', $data, array('rid'=>$rid));
    1536. 

  1536.             
    1537. 

  1537.             $update = true;
    1538. 

  1538.         }else{
    1539. 

  1539.             $wpdb->insert($wpdb->prefix.'icl_translation_status',$data);
    1540. 

  1540.             $rid = $wpdb->insert_id;
    1541. 

  1541.             $update = false;
    1542. 

  1542.         }    
    1543. 

  1543.         
    1544. 

  1544.         return array($rid, $update);
    1545. 

  1545.     }
    1546. 

  1546. 

  1547.     function _get_post($post_id) {
    1548. 

  1548.         if (is_string($post_id) && strcmp(substr($post_id, 0, strlen('external_')), 'external_')===0) {
    1549. 

  1549.             $item = null;
    1550. 

  1550.             return apply_filters('WPML_get_translatable_item', $item, $post_id);
    1551. 

  1551.         } else {
    1552. 

  1552.             return get_post($post_id);
    1553. 

  1553.         }
    1554. 

  1554.     }
    1555. 

  1555.     /* TRANSLATION JOBS */
    1556. 

  1556.     /* ******************************************************************************************** */   
    1557. 

  1557.     
    1558. 

  1558.     function send_jobs($data){                                
    1559. 

  1559.         global $wpdb, $sitepress;
    1560. 

  1560.         
    1561. 

  1561.         
    1562. 

  1562.         if(!isset($data['tr_action']) && isset($data['translate_to'])){ //adapt new format
    1563. 

  1563.             $data['tr_action'] = $data['translate_to'];
    1564. 

  1564.             unset($data['translate_to']);
    1565. 

  1565.         }
    1566. 

  1566.         
    1567. 

  1567.         // translate_from
    1568. 

  1568.         // tr_action (translate_to)
    1569. 

  1569.         // translator
    1570. 

  1570.         // post
    1571. 

  1571.         // service
    1572. 

  1572.         // defaults
    1573. 

  1573.         $data_default = array(
    1574. 

  1574.             'translate_from'    => $sitepress->get_default_language()
    1575. 

  1575.         );        
    1576. 

  1576.         extract($data_default);
    1577. 

  1577.         extract($data, EXTR_OVERWRITE);
    1578. 

  1578.         
    1579. 

  1579.         // no language selected ?
    1580. 

  1580.         if(!isset($tr_action) || empty($tr_action)){
    1581. 

  1581.             $this->messages[] = array(
    1582. 

  1582.                 'type'=>'error',
    1583. 

  1583.                 'text' => __('Please select at least one language to translate into.', 'sitepress')
    1584. 

  1584.             );
    1585. 

  1585.             $this->dashboard_select = $data; // prepopulate dashboard
    1586. 

  1586.             return;
    1587. 

  1587.         }
    1588. 

  1588.         // no post selected ?
    1589. 

  1589.         if(!isset($iclpost) || empty($iclpost)){
    1590. 

  1590.             $this->messages[] = array(
    1591. 

  1591.                 'type'=>'error',
    1592. 

  1592.                 'text' => __('Please select at least one document to translate.', 'sitepress')
    1593. 

  1593.             );
    1594. 

  1594.             $this->dashboard_select = $data; // prepopulate dashboard
    1595. 

  1595.             return;
    1596. 

  1596.         }
    1597. 

  1597.         
    1598. 

  1598.         $selected_posts = $iclpost;
    1599. 

  1599.         $selected_translators = isset($translator) ? $translator : array();
    1600. 

  1600.         $selected_languages = $tr_action;
    1601. 

  1601.         $job_ids = array();
    1602. 

  1602.         
    1603. 

  1603.         foreach($selected_posts as $post_id){
    1604. 

  1604.             $post = $this->_get_post($post_id); 
    1605. 

  1605.             $post_trid = $sitepress->get_element_trid($post->ID, 'post_' . $post->post_type);
    1606. 

  1606.             $post_translations = $sitepress->get_element_translations($post_trid, 'post_' . $post->post_type);            
    1607. 

  1607.             $md5 = $this->post_md5($post);
    1608. 

  1608.             
    1609. 

  1609.             $translation_package = $this->create_translation_package($post);
    1610. 

  1610.             
    1611. 

  1611.             foreach($selected_languages as $lang => $action){
    1612. 

  1612.                 
    1613. 

  1613.                 // making this a duplicate?
    1614. 

  1614.                 if($action == 2){
    1615. 

  1615.                     // dont send documents that are in progress
    1616. 

  1616.                     $current_translation_status = $this->get_element_translation($post_id, $lang, 'post_' . $post->post_type);                
    1617. 

  1617.                     if($current_translation_status->status == ICL_TM_IN_PROGRESS) continue;
    1618. 

  1618.                     
    1619. 

  1619.                     $job_ids[] = $this->make_duplicate($post_id, $lang);
    1620. 

  1620.                 }elseif($action == 1){    
    1621. 

  1621. 

  1622.                     if(empty($post_translations[$lang])){
    1623. 

  1623.                         $translation_id = $sitepress->set_element_language_details(null , 'post_' . $post->post_type, $post_trid, $lang, $translate_from);
    1624. 

  1624.                     }else{
    1625. 

  1625.                         $translation_id = $post_translations[$lang]->translation_id;
    1626. 

  1626.                     }     
    1627. 

  1627.                     
    1628. 

  1628.                     $current_translation_status = $this->get_element_translation($post_id, $lang, 'post_' . $post->post_type);                
    1629. 

  1629.                     
    1630. 

  1630.                     // don't send documents that are in progress
    1631. 

  1631.                     // don't send documents that are already translated and don't need update
    1632. 

  1632.                     if(!empty($current_translation_status)){
    1633. 

  1633.                         if($current_translation_status->status == ICL_TM_IN_PROGRESS) continue;
    1634. 

  1634.                         if($current_translation_status->status == ICL_TM_COMPLETE && !$current_translation_status->needs_update) continue;
    1635. 

  1635.                     }
    1636. 

  1636.                     
    1637. 

  1637.                     $_status = ICL_TM_WAITING_FOR_TRANSLATOR;
    1638. 

  1638.                     
    1639. 

  1639.                     $_exp = isset($selected_translators[$lang]) ? explode('-', $selected_translators[$lang]) : false;
    1640. 

  1640.                     if(!isset($service)){
    1641. 

  1641.                         $translation_service = isset($_exp[1]) ? $_exp[1] : 'local';
    1642. 

  1642.                     }else{
    1643. 

  1643.                         $translation_service = $service;
    1644. 

  1644.                     }                
    1645. 

  1645.                     $translator_id = $_exp[0];
    1646. 

  1646.                                                     
    1647. 

  1647.                     // set as default translator                
    1648. 

  1648.                     if($translator_id > 0){
    1649. 

  1649.                         $this->set_default_translator($translator_id, $translate_from, $lang, $translation_service);
    1650. 

  1650.                     }
    1651. 

  1651.                     
    1652. 

  1652.                     // add translation_status record        
    1653. 

  1653.                     $data = array(
    1654. 

  1654.                         'translation_id'        => $translation_id,
    1655. 

  1655.                         'status'                => $_status,
    1656. 

  1656.                         'translator_id'         => $translator_id,
    1657. 

  1657.                         'needs_update'          => 0,
    1658. 

  1658.                         'md5'                   => $md5,
    1659. 

  1659.                         'translation_service'   => $translation_service,
    1660. 

  1660.                         'translation_package'   => serialize($translation_package)                    
    1661. 

  1661.                     );
    1662. 

  1662.                     
    1663. 

  1663.                     $_prevstate = $wpdb->get_row($wpdb->prepare("
    1664. 

  1664.                         SELECT status, translator_id, needs_update, md5, translation_service, translation_package, timestamp, links_fixed
    1665. 

  1665.                         FROM {$wpdb->prefix}icl_translation_status
    1666. 

  1666.                         WHERE translation_id = %d                    
    1667. 

  1667.                     ", $translation_id), ARRAY_A);
    1668. 

  1668.                     if(!empty($_prevstate)){
    1669. 

  1669.                         $data['_prevstate'] = serialize($_prevstate);
    1670. 

  1670.                     }                
    1671. 

  1671.                                     
    1672. 

  1672.                     list($rid, $update) = $this->update_translation_status($data);
    1673. 

  1673.                                     
    1674. 

  1674.                     $job_ids[] = $this->add_translation_job($rid, $translator_id, $translation_package);                                                
    1675. 

  1675.                     if( $translation_service == 'icanlocalize' ){
    1676. 

  1676.                         global $ICL_Pro_Translation;
    1677. 

  1677.                         $sent = $ICL_Pro_Translation->send_post($post, array($lang), $translator_id);
    1678. 

  1678.                         if(!$sent){
    1679. 

  1679.                             $job_id = array_pop($job_ids);
    1680. 

  1680.                             $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id));
    1681. 

  1681.                             $wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}icl_translate_job SET revision = NULL WHERE rid=%d ORDER BY job_id DESC LIMIT 1", $rid));
    1682. 

  1682.                             $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id=%d", $job_id));
    1683. 

  1683.                         }
    1684. 

  1684.                     }
    1685. 

  1685.                 } // if / else is making a duplicate
    1686. 

  1686.             }                
    1687. 

  1687.             
    1688. 

  1688.         }
    1689. 

  1689.         
    1690. 

  1690.         $job_ids = array_unique($job_ids);
    1691. 

  1691.         if(array(false) == $job_ids || empty($job_ids)){
    1692. 

  1692.             $this->messages[] = array(
    1693. 

  1693.                 'type'=>'error',
    1694. 

  1694.                 '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')
    1695. 

  1695.             );            
    1696. 

  1696.         }elseif(in_array(false, $job_ids)){
    1697. 

  1697.             $this->messages[] = array(
    1698. 

  1698.                 'type'=>'updated',
    1699. 

  1699.                 'text' => __('Some documents were sent to translation.', 'sitepress')
    1700. 

  1700.             );            
    1701. 

  1701.             $this->messages[] = array(
    1702. 

  1702.                 'type'=>'error',
    1703. 

  1703.                 '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')
    1704. 

  1704.             );
    1705. 

  1705.         }else{
    1706. 

  1706.             $this->messages[] = array(
    1707. 

  1707.                 'type'=>'updated',
    1708. 

  1708.                 'text' => __('Selected document(s) sent to translation.', 'sitepress')
    1709. 

  1709.             );
    1710. 

  1710.         }
    1711. 

  1711. 

  1712.         return $job_ids;
    1713. 

  1713.     }    
    1714. 

  1714.     
    1715. 

  1715.     /**
    1716. 

  1716.     * Adds a translation job record in icl_translate_job
    1717. 

  1717.     * 
    1718. 

  1718.     * @param mixed $rid
    1719. 

  1719.     * @param mixed $translator_id
    1720. 

  1720.     */
    1721. 

  1721.     function add_translation_job($rid, $translator_id, $translation_package){
    1722. 

  1722.         global $wpdb, $current_user;        
    1723. 

  1723.         get_currentuserinfo();
    1724. 

  1724.         if(!$current_user->ID){
    1725. 

  1725.             $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));
    1726. 

  1726.         }else{
    1727. 

  1727.             $manager_id = $current_user->ID;
    1728. 

  1728.         }
    1729. 

  1729.         
    1730. 

  1730.         $translation_status = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translation_status WHERE rid=%d", $rid));
    1731. 

  1731.         
    1732. 

  1732.         // if we have a previous job_id for this rid mark it as the top (last) revision
    1733. 

  1733.         list($prev_job_id, $prev_job_translated) = $wpdb->get_row($wpdb->prepare("
    1734. 

  1734.                     SELECT job_id, translated FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NULL 
    1735. 

  1735.         ", $rid), ARRAY_N);
    1736. 

  1736.         if(!is_null($prev_job_id)){
    1737. 

  1737.          
    1738. 

  1738.             // if previous job is not complete bail out
    1739. 

  1739.             if(!$prev_job_translated){
    1740. 

  1740.                 //trigger_error(sprintf(__('Translation is in progress for job: %s.', 'sitepress'), $prev_job_id), E_USER_NOTICE);
    1741. 

  1741.                 return false;
    1742. 

  1742.             }
    1743. 

  1743.             
    1744. 

  1744.             $last_rev = $wpdb->get_var($wpdb->prepare("
    1745. 

  1745.                 SELECT MAX(revision) AS rev FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NOT NULL 
    1746. 

  1746.             ", $rid));        
    1747. 

  1747.             $wpdb->update($wpdb->prefix . 'icl_translate_job', array('revision'=>$last_rev+1), array('job_id'=>$prev_job_id));
    1748. 

  1748.             
    1749. 

  1749.             $prev_job = $this->get_translation_job($prev_job_id);
    1750. 

  1750.             
    1751. 

  1751.             $original_post = get_post($prev_job->original_doc_id);
    1752. 

  1752.             foreach($prev_job->elements as $element){
    1753. 

  1753.                 $prev_translation[$element->field_type] = $element->field_data_translated;
    1754. 

  1754.                 switch($element->field_type){
    1755. 

  1755.                     case 'title':
    1756. 

  1756.                         if($this->decode_field_data($element->field_data, $element->field_format) == $original_post->post_title){
    1757. 

  1757.                             //$unchanged[$element->field_type] = $element->field_data_translated;
    1758. 

  1758.                             $unchanged[$element->field_type] = true;
    1759. 

  1759.                         }
    1760. 

  1760.                         break;
    1761. 

  1761.                     case 'body':
    1762. 

  1762.                         if($this->decode_field_data($element->field_data, $element->field_format) == $original_post->post_content){
    1763. 

  1763.                             //$unchanged[$element->field_type] = $element->field_data_translated;
    1764. 

  1764.                             $unchanged[$element->field_type] = true;
    1765. 

  1765.                         }
    1766. 

  1766.                         break;
    1767. 

  1767.                     case 'excerpt':
    1768. 

  1768.                         if($this->decode_field_data($element->field_data, $element->field_format) == $original_post->post_excerpt){
    1769. 

  1769.                             //$unchanged[$element->field_type] = $element->field_data_translated;
    1770. 

  1770.                             $unchanged[$element->field_type] = true;
    1771. 

  1771.                         }
    1772. 

  1772.                         break;                    
    1773. 

  1773.                     case 'tags':
    1774. 

  1774.                         $terms = (array)get_the_terms( $prev_job->original_doc_id , 'post_tag' );
    1775. 

  1775.                         $_taxs = array();
    1776. 

  1776.                         foreach($terms as $term){
    1777. 

  1777.                             $_taxs[] = $term->name;    
    1778. 

  1778.                         }
    1779. 

  1779.                         if($element->field_data == $this->encode_field_data($_taxs, $element->field_format)){
    1780. 

  1780.                             //$unchanged['tags'] = $element->field_data_translated;
    1781. 

  1781.                             $unchanged['tags'] = true;
    1782. 

  1782.                         }                    
    1783. 

  1783.                         break;
    1784. 

  1784.                     case 'categories':
    1785. 

  1785.                         $terms = get_the_terms( $prev_job->original_doc_id , 'category' );
    1786. 

  1786.                         $_taxs = array();
    1787. 

  1787.                         foreach($terms as $term){
    1788. 

  1788.                             $_taxs[] = $term->name;    
    1789. 

  1789.                         }
    1790. 

  1790.                         if($element->field_data == $this->encode_field_data($_taxs, $element->field_format)){
    1791. 

  1791.                             //$unchanged['categories'] = $element->field_data_translated;
    1792. 

  1792.                             $unchanged['categories'] = true;
    1793. 

  1793.                         }                                    
    1794. 

  1794.                         break;
    1795. 

  1795.                     default:
    1796. 

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

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

  1798.                             if($this->decode_field_data($element->field_data, $element->field_format) == get_post_meta($prev_job->original_doc_id, $cf_name, 1)){
    1799. 

  1799.                                 //$unchanged[$element->field_type] = $element->field_data_translated;
    1800. 

  1800.                                 $unchanged[$element->field_type] = true;
    1801. 

  1801.                             }
    1802. 

  1802.                         }else{
    1803. 

  1803.                             // taxonomies                                                 
    1804. 

  1804.                             if(taxonomy_exists($element->field_type)){
    1805. 

  1805.                                 $terms = get_the_terms( $prev_job->original_doc_id , $element->field_type );
    1806. 

  1806.                                 $_taxs = array();
    1807. 

  1807.                                 foreach($terms as $term){
    1808. 

  1808.                                     $_taxs[] = $term->name;    
    1809. 

  1809.                                 }
    1810. 

  1810.                                 if($element->field_data == $this->encode_field_data($_taxs, $element->field_format)){
    1811. 

  1811.                                     //$unchanged[$element->field_type] = $field['data_translated'];
    1812. 

  1812.                                     $unchanged[$element->field_type] = true;
    1813. 

  1813.                                 }  
    1814. 

  1814.                             }                                  
    1815. 

  1815.                         }                
    1816. 

  1816.                 }
    1817. 

  1817.             }                    
    1818. 

  1818.         }
    1819. 

  1819.         
    1820. 

  1820.         $wpdb->insert($wpdb->prefix . 'icl_translate_job', array(
    1821. 

  1821.             'rid' => $rid,
    1822. 

  1822.             'translator_id' => $translator_id, 
    1823. 

  1823.             'translated'    => 0,
    1824. 

  1824.             'manager_id'    => $manager_id
    1825. 

  1825.         ));        
    1826. 

  1826.         $job_id = $wpdb->insert_id;
    1827. 

  1827.         
    1828. 

  1828.         foreach($translation_package['contents'] as $field => $value){
    1829. 

  1829.             $job_translate = array(
    1830. 

  1830.                 'job_id'            => $job_id,
    1831. 

  1831.                 'content_id'        => 0,
    1832. 

  1832.                 'field_type'        => $field,
    1833. 

  1833.                 'field_format'      => isset($value['format'])?$value['format']:'',
    1834. 

  1834.                 'field_translate'   => $value['translate'],
    1835. 

  1835.                 'field_data'        => $value['data'],
    1836. 

  1836.                 'field_data_translated' => isset($prev_translation[$field]) ? $prev_translation[$field] : '',
    1837. 

  1837.                 'field_finished'    => 0      
    1838. 

  1838.             );
    1839. 

  1839.             if(isset($unchanged[$field])){                
    1840. 

  1840.                 $job_translate['field_finished'] = 1;
    1841. 

  1841.             }
    1842. 

  1842.             //$job_translate['field_data_translated'] = $unchanged[$field];    
    1843. 

  1843.             
    1844. 

  1844.             $wpdb->insert($wpdb->prefix . 'icl_translate', $job_translate);    
    1845. 

  1845.         }
    1846. 

  1846.         
    1847. 

  1847.         if(!defined('ICL_TM_DISABLE_ALL_NOTIFICATIONS') && $translation_status->translation_service=='local'){
    1848. 

  1848.             if($this->settings['notification']['new-job'] == ICL_TM_NOTIFICATION_IMMEDIATELY){
    1849. 

  1849.                 require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    1850. 

  1850.                 if($job_id){
    1851. 

  1851.                     $tn_notification = new TM_Notification();
    1852. 

  1852.                     if(empty($translator_id)){
    1853. 

  1853.                         $tn_notification->new_job_any($job_id);    
    1854. 

  1854.                     }else{
    1855. 

  1855.                         $tn_notification->new_job_translator($job_id, $translator_id);
    1856. 

  1856.                     }            
    1857. 

  1857.                 }
    1858. 

  1858.             }
    1859. 

  1859.         }
    1860. 

  1860. 

  1861.         return $job_id;
    1862. 

  1862.         
    1863. 

  1863.     }
    1864. 

  1864.     
    1865. 

  1865.     function assign_translation_job($job_id, $translator_id, $service='local'){
    1866. 

  1866.         global $wpdb;
    1867. 

  1867.         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);
    1868. 

  1868.         
    1869. 

  1869.         require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    1870. 

  1870.         $tn_notification = new TM_Notification();
    1871. 

  1871.         if(!empty($prev_translator_id) && $prev_translator_id != $translator_id){
    1872. 

  1872.             if($job_id){
    1873. 

  1873.                 $tn_notification->translator_removed($prev_translator_id, $job_id);
    1874. 

  1874.             }
    1875. 

  1875.         }
    1876. 

  1876.         
    1877. 

  1877.         if($this->settings['notification']['new-job'] == ICL_TM_NOTIFICATION_IMMEDIATELY){
    1878. 

  1878.             if(empty($translator_id)){
    1879. 

  1879.                 $tn_notification->new_job_any($job_id);    
    1880. 

  1880.             }else{
    1881. 

  1881.                 $tn_notification->new_job_translator($job_id, $translator_id);
    1882. 

  1882.             }            
    1883. 

  1883.         }
    1884. 

  1884.         
    1885. 

  1885.         $wpdb->update($wpdb->prefix.'icl_translation_status', 
    1886. 

  1886.             array('translator_id'=>$translator_id, 'status'=>ICL_TM_WAITING_FOR_TRANSLATOR, 'translation_service' => $service),
    1887. 

  1887.             array('rid'=>$rid));
    1888. 

  1888.         $wpdb->update($wpdb->prefix.'icl_translate_job', array('translator_id'=>$translator_id), array('job_id'=>$job_id));
    1889. 

  1889.         return true;
    1890. 

  1890.     }
    1891. 

  1891.     
    1892. 

  1892.     function get_translation_jobs($args = array()){        
    1893. 

  1893.         global $wpdb, $sitepress, $wp_query;
    1894. 

  1894.         
    1895. 

  1895.         // defaults
    1896. 

  1896.         $args_default = array(
    1897. 

  1897.             'translator_id' => 0,
    1898. 

  1898.             'status' => false,
    1899. 

  1899.             'include_unassigned' => false
    1900. 

  1900.         );
    1901. 

  1901.         
    1902. 

  1902.         extract($args_default);
    1903. 

  1903.         extract($args, EXTR_OVERWRITE);
    1904. 

  1904.         
    1905. 

  1905.         $_exp = explode('-', $translator_id);
    1906. 

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

  1907.         $translator_id = $_exp[0];
    1908. 

  1908.         
    1909. 

  1909.         $where = " s.status > " . ICL_TM_NOT_TRANSLATED;
    1910. 

  1910.         if($status != ''){
    1911. 

  1911.             $where .= " AND s.status=" . intval($status);    
    1912. 

  1912.         }    
    1913. 

  1913.         if($status != ICL_TM_DUPLICATE){
    1914. 

  1914.             $where .= " AND s.status <> " . ICL_TM_DUPLICATE;    
    1915. 

  1915.         }    
    1916. 

  1916.         if(!empty($translator_id)){
    1917. 

  1917.             if($include_unassigned){
    1918. 

  1918.                 $where .= " AND (j.translator_id=" . intval($translator_id) . " OR j.translator_id=0) ";    
    1919. 

  1919.             }else{
    1920. 

  1920.                 $where .= " AND j.translator_id=" . intval($translator_id);        
    1921. 

  1921.             }
    1922. 

  1922.             if(!empty($service)){
    1923. 

  1923.                 $where .= " AND s.translation_service='{$service}'";        
    1924. 

  1924.             }
    1925. 

  1925.         }
    1926. 

  1926.         if(!empty($from)){
    1927. 

  1927.             $where .= " AND t.source_language_code='".$wpdb->escape($from)."'";    
    1928. 

  1928.         }
    1929. 

  1929.         if(!empty($to)){
    1930. 

  1930.             $where .= " AND t.language_code='".$wpdb->escape($to)."'";    
    1931. 

  1931.         }
    1932. 

  1932.         
    1933. 

  1933.         // ORDER BY
    1934. 

  1934.         if($include_unassigned){
    1935. 

  1935.             $orderby[] = 'j.translator_id DESC'; 
    1936. 

  1936.         }
    1937. 

  1937.         $orderby[] = ' j.job_id DESC ';
    1938. 

  1938.         $orderby = join(', ', $orderby);
    1939. 

  1939.                 
    1940. 

  1940.         // LIMIT
    1941. 

  1941.         if(!isset($_GET['paged'])) $_GET['paged'] = 1;
    1942. 

  1942.         $offset = ($_GET['paged']-1)*$limit_no;
    1943. 

  1943.         $limit = " " . $offset . ',' . $limit_no;
    1944. 

  1944.                 
    1945. 

  1945.         $jobs = $wpdb->get_results(
    1946. 

  1946.             "SELECT SQL_CALC_FOUND_ROWS 
    1947. 

  1947.                 j.job_id, t.trid, t.language_code, t.source_language_code, 
    1948. 

  1948.                 s.translation_id, s.status, s.needs_update, s.translator_id, u.display_name AS translator_name, s.translation_service 
    1949. 

  1949.                 FROM {$wpdb->prefix}icl_translate_job j
    1950. 

  1950.                     JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    1951. 

  1951.                     JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id
    1952. 

  1952.                     LEFT JOIN {$wpdb->users} u ON s.translator_id = u.ID
    1953. 

  1953.                 WHERE {$where} AND revision IS NULL
    1954. 

  1954.                 ORDER BY {$orderby}
    1955. 

  1955.                 LIMIT {$limit}
    1956. 

  1956.             "
    1957. 

  1957.         ); 
    1958. 

  1958.         
    1959. 

  1959.         $count = $wpdb->get_var("SELECT FOUND_ROWS()");
    1960. 

  1960.         
    1961. 

  1961.         $wp_query->found_posts = $count;
    1962. 

  1962.         $wp_query->query_vars['posts_per_page'] = $limit_no;
    1963. 

  1963.         $wp_query->max_num_pages = ceil($wp_query->found_posts/$limit_no);
    1964. 

  1964.         
    1965. 

  1965.         foreach($jobs as $k=>$row){
    1966. 

  1966.             //original
    1967. 

  1967.             $post_id = $wpdb->get_var($wpdb->prepare("
    1968. 

  1968.                                                      SELECT field_data
    1969. 

  1969.                                                      FROM {$wpdb->prefix}icl_translate
    1970. 

  1970.                                                      WHERE job_id=%d and field_type='original_id'", $row->job_id));
    1971. 

    1972. 

  1972.             $parts = explode('_', $post_id);
    1973. 

  1973.             if ($parts[0] == 'external') {
    1974. 

  1974.                 $jobs[$k]->original_doc_id = $post_id;
    1975. 

  1975. 

  1976.                 $jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("
    1977. 

  1977.                                                          SELECT field_data
    1978. 

  1978.                                                          FROM {$wpdb->prefix}icl_translate
    1979. 

  1979.                                                          WHERE job_id=%d and field_type='name'", $row->job_id)));
    1980. 

  1980.                 if ($jobs[$k]->post_title == "") {
    1981. 

  1981.                     // try the title field.
    1982. 

  1982.                     $jobs[$k]->post_title = base64_decode($wpdb->get_var($wpdb->prepare("
    1983. 

  1983.                                                          SELECT field_data
    1984. 

  1984.                                                          FROM {$wpdb->prefix}icl_translate
    1985. 

  1985.                                                          WHERE job_id=%d and field_type='title'", $row->job_id)));
    1986. 

  1986.                 }
    1987. 

  1987. 

  1988.                 $jobs[$k]->edit_link = $this->tm_post_link($post_id);
    1989. 

  1989.                 $ldf = $sitepress->get_language_details($row->source_language_code);
    1990. 

  1990.             } else {       
    1991. 

  1991.                 $doc = $wpdb->get_row($wpdb->prepare("SELECT ID, post_title, post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));
    1992. 

  1992.                 if ($doc) {
    1993. 

  1993.                     $jobs[$k]->post_title = $doc->post_title;
    1994. 

  1994.                     $jobs[$k]->original_doc_id = $doc->ID;
    1995. 

  1995.                     $jobs[$k]->edit_link = get_edit_post_link($doc->ID);                
    1996. 

  1996.                     $ldf = $sitepress->get_language_details($sitepress->get_element_language_details($post_id, 'post_' . $doc->post_type)->language_code);
    1997. 

  1997.                 } else {
    1998. 

  1998.                     $jobs[$k]->post_title = __("The original has been deleted!", "sitepress");
    1999. 

  1999.                     $jobs[$k]->original_doc_id = 0;
    2000. 

  2000.                     $jobs[$k]->edit_link = "";
    2001. 

  2001.                     $ldf['display_name'] = __("Deleted", "sitepress");
    2002. 

  2002.                 }
    2003. 

  2003.             }
    2004. 

  2004.             $ldt = $sitepress->get_language_details($row->language_code);            
    2005. 

  2005.             $jobs[$k]->lang_text = $ldf['display_name'] . ' &raquo; ' . $ldt['display_name'];
    2006. 

  2006.             if($row->translation_service=='icanlocalize'){
    2007. 

  2007.                 $row->translator_name = ICL_Pro_Translation::get_translator_name($row->translator_id);
    2008. 

  2008.             }
    2009. 

  2009.         }
    2010. 

  2010.        return $jobs; 
    2011. 

  2011.         
    2012. 

  2012.     }
    2013. 

  2013.     
    2014. 

  2014.     function get_translation_job($job_id, $include_non_translatable_elements = false, $auto_assign = false, $revisions = 0){
    2015. 

  2015.         global $wpdb, $sitepress, $current_user;
    2016. 

  2016.         get_currentuserinfo();
    2017. 

  2017.         $job = $wpdb->get_row($wpdb->prepare("
    2018. 

  2018.             SELECT 
    2019. 

  2019.                 j.rid, j.translator_id, j.translated, j.manager_id,
    2020. 

  2020.                 s.status, s.needs_update, s.translation_service,
    2021. 

  2021.                 t.trid, t.language_code, t.source_language_code             
    2022. 

  2022.             FROM {$wpdb->prefix}icl_translate_job j 
    2023. 

  2023.                 JOIN {$wpdb->prefix}icl_translation_status s ON j.rid = s.rid
    2024. 

  2024.                 JOIN {$wpdb->prefix}icl_translations t ON s.translation_id = t.translation_id                
    2025. 

  2025.             WHERE j.job_id = %d", $job_id));
    2026. 

  2026.         
    2027. 

  2027.         $post_id = $wpdb->get_var($wpdb->prepare("
    2028. 

  2028.                                                  SELECT field_data
    2029. 

  2029.                                                  FROM {$wpdb->prefix}icl_translate
    2030. 

  2030.                                                  WHERE job_id=%d and field_type='original_id'", $job_id));
    2031. 

    2032. 

  2032.         $parts = explode('_', $post_id);
    2033. 

  2033.         if ($parts[0] == 'external') {
    2034. 

  2034.             $job->original_doc_id = $post_id;
    2035. 

  2035.             $job->original_doc_title = base64_decode($wpdb->get_var($wpdb->prepare("
    2036. 

  2036.                                                      SELECT field_data
    2037. 

  2037.                                                      FROM {$wpdb->prefix}icl_translate
    2038. 

  2038.                                                      WHERE job_id=%d and field_type='name'", $job_id)));
    2039. 

  2039.             if ($job->original_doc_title == "") {
    2040. 

  2040.                 // try the title field.
    2041. 

  2041.                 $job->original_doc_title = base64_decode($wpdb->get_var($wpdb->prepare("
    2042. 

  2042.                                                          SELECT field_data
    2043. 

  2043.                                                          FROM {$wpdb->prefix}icl_translate
    2044. 

  2044.                                                          WHERE job_id=%d and field_type='title'", $job_id)));
    2045. 

  2045.             }
    2046. 

  2046.             $job->original_post_type = $wpdb->get_var($wpdb->prepare("
    2047. 

  2047.                                                                      SELECT element_type
    2048. 

  2048.                                                                      FROM {$wpdb->prefix}icl_translations
    2049. 

  2049.                                                                      WHERE trid=%d AND language_code='%s'",
    2050. 

  2050.                                                                      $job->trid, $job->source_language_code));
    2051. 

  2051.         } else {        
    2052. 

  2052.             $original = $wpdb->get_row($wpdb->prepare("
    2053. 

  2053.                 SELECT t.element_id, p.post_title, p.post_type
    2054. 

  2054.                 FROM {$wpdb->prefix}icl_translations t 
    2055. 

  2055.                 JOIN {$wpdb->posts} p ON t.element_id = p.ID AND t.trid = %d 
    2056. 

  2056.                 WHERE t.language_code = '%s'", $job->trid, $job->source_language_code));
    2057. 

  2057.             $job->original_doc_title = $original->post_title;
    2058. 

  2058.             $job->original_doc_id = $original->element_id;
    2059. 

  2059.             $job->original_post_type = $original->post_type;
    2060. 

  2060.         }
    2061. 

  2061.         
    2062. 

  2062.         $_ld = $sitepress->get_language_details($job->source_language_code);
    2063. 

  2063.         $job->from_language = $_ld['display_name'];
    2064. 

  2064.         $_ld = $sitepress->get_language_details($job->language_code);
    2065. 

  2065.         $job->to_language = $_ld['display_name'];
    2066. 

  2066.         
    2067. 

  2067.         if(!$include_non_translatable_elements){
    2068. 

  2068.             $jelq = ' AND field_translate = 1';
    2069. 

  2069.         }else{
    2070. 

  2070.             $jelq = '';
    2071. 

  2071.         }
    2072. 

  2072.         $job->elements = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translate WHERE job_id = %d {$jelq} ORDER BY tid ASC", $job_id));        
    2073. 

  2073.         if($job->translator_id == 0 || $job->status == ICL_TM_WAITING_FOR_TRANSLATOR){
    2074. 

  2074.             if($auto_assign){
    2075. 

  2075.                 $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translator_id' => $this->current_translator->translator_id), array('job_id'=>$job_id));
    2076. 

  2076.                 $wpdb->update($wpdb->prefix . 'icl_translation_status', 
    2077. 

  2077.                     array('translator_id' => $this->current_translator->translator_id, 'status' => ICL_TM_IN_PROGRESS), 
    2078. 

  2078.                     array('rid'=>$job->rid)
    2079. 

  2079.                 );
    2080. 

  2080.             }
    2081. 

  2081.         }elseif($job->translator_id != @intval($this->current_translator->translator_id) && !defined('XMLRPC_REQUEST') && $job->manager_id != $current_user->ID){            
    2082. 

  2082.             static $erroronce = array();
    2083. 

  2083.             if(empty($erroronce[$job_id])){
    2084. 

  2084.                 $this->messages[] = array(
    2085. 

  2085.                     'type' => 'error', '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)
    2086. 

  2086.                 );
    2087. 

  2087.                 $erroronce[$job_id] = true;
    2088. 

  2088.             }
    2089. 

  2089.             return false;
    2090. 

  2090.         }
    2091. 

  2091.         
    2092. 

  2092.         //do we have a previous version
    2093. 

  2093.         if($revisions > 0){
    2094. 

  2094.             $prev_version_job_id = $wpdb->get_var($wpdb->prepare("
    2095. 

  2095.                 SELECT MAX(job_id) 
    2096. 

  2096.                 FROM {$wpdb->prefix}icl_translate_job 
    2097. 

  2097.                 WHERE rid=%d AND job_id < %d", $job->rid, $job_id));            
    2098. 

  2098.             if($prev_version_job_id){
    2099. 

  2099.                 $job->prev_version = $this->get_translation_job($prev_version_job_id, false, false, $revisions - 1);
    2100. 

  2100.             }   
    2101. 

  2101.             
    2102. 

  2102.         }
    2103. 

  2103.         
    2104. 

  2104.         // allow adding custom elements
    2105. 

  2105.         $job->elements = apply_filters('icl_job_elements', $job->elements, $post_id, $job_id);
    2106. 

  2106.         
    2107. 

  2107.         return $job;    
    2108. 

  2108.     }
    2109. 

  2109.     
    2110. 

  2110.     function get_translation_job_id($trid, $language_code){
    2111. 

  2111.         global $wpdb, $sitepress;
    2112. 

  2112.         
    2113. 

  2113.         $job_id = $wpdb->get_var($wpdb->prepare("
    2114. 

  2114.             SELECT tj.job_id FROM {$wpdb->prefix}icl_translate_job tj 
    2115. 

  2115.                 JOIN {$wpdb->prefix}icl_translation_status ts ON tj.rid = ts.rid
    2116. 

  2116.                 JOIN {$wpdb->prefix}icl_translations t ON ts.translation_id = t.translation_id
    2117. 

  2117.                 WHERE t.trid = %d AND t.language_code='%s'
    2118. 

  2118.                 ORDER BY tj.job_id DESC LIMIT 1                
    2119. 

  2119.         ", $trid, $language_code));
    2120. 

  2120.         
    2121. 

  2121.         return $job_id;
    2122. 

  2122.     }
    2123. 

  2123.         
    2124. 

  2124.     function _save_translation_field($tid, $field){
    2125. 

  2125.         global $wpdb;
    2126. 

  2126.         $update['field_data_translated'] = $this->encode_field_data($field['data'], $field['format']);
    2127. 

  2127.         if(isset($field['finished']) && $field['finished']){
    2128. 

  2128.             $update['field_finished'] = 1;
    2129. 

  2129.         }
    2130. 

  2130.         $wpdb->update($wpdb->prefix . 'icl_translate', $update, array('tid'=>$tid));    
    2131. 

  2131.     }
    2132. 

  2132. 

  2133.     
    2134. 

  2134.     function save_translation($data){
    2135. 

  2135.         global $wpdb, $sitepress, $sitepress_settings, $ICL_Pro_Translation;
    2136. 

  2136.         
    2137. 

  2137.         $is_incomplete = false;
    2138. 

  2138.         foreach($data['fields'] as $field){
    2139. 

  2139.             $this->_save_translation_field($field['tid'], $field);
    2140. 

  2140.             if(!isset($field['finished']) || !$field['finished']){
    2141. 

  2141.                 $is_incomplete = true;        
    2142. 

  2142.             }
    2143. 

  2143.         }
    2144. 

  2144.         
    2145. 

  2145.         if(!empty($data['complete']) && !$is_incomplete){
    2146. 

  2146.             $wpdb->update($wpdb->prefix . 'icl_translate_job', array('translated'=>1), array('job_id'=>$data['job_id']));    
    2147. 

  2147.             $rid = $wpdb->get_var($wpdb->prepare("SELECT rid FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $data['job_id']));
    2148. 

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

  2149.             $wpdb->update($wpdb->prefix . 'icl_translation_status', array('status'=>ICL_TM_COMPLETE, 'needs_update'=>0), array('rid'=>$rid));
    2150. 

  2150.             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);            
    2151. 

  2151.             $job = $this->get_translation_job($data['job_id'], true);
    2152. 

  2152.             
    2153. 

  2153.             $parts = explode('_', $job->original_doc_id);
    2154. 

  2154.             if ($parts[0] == 'external') {
    2155. 

  2155.                 
    2156. 

  2156.                 // Translations are saved in the string table for 'external' types
    2157. 

  2157.                 
    2158. 

  2158.                 $id = array_pop($parts);
    2159. 

  2159.                 unset($parts[0]);
    2160. 

  2160.                 $type = implode('_', $parts);
    2161. 

  2161. 

  2162.                 foreach($job->elements as $field){
    2163. 

  2163.                     if ($field->field_translate) {
    2164. 

  2164.                         if (function_exists('icl_st_is_registered_string')) {
    2165. 

  2165.                             $string_id = icl_st_is_registered_string($type, $id . '_' . $field->field_type);
    2166. 

  2166.                             if (!$string_id) {
    2167. 

  2167.                                 icl_register_string($type, $id . '_' . $field->field_type, $this->decode_field_data($field->field_data, $field->field_format));
    2168. 

  2168.                                 $string_id = icl_st_is_registered_string($type, $id . '_' . $field->field_type);
    2169. 

  2169.                             }
    2170. 

  2170.                             if ($string_id) {
    2171. 

  2171.                                 icl_add_string_translation($string_id, $job->language_code, $this->decode_field_data($field->field_data_translated, $field->field_format), ICL_STRING_TRANSLATION_COMPLETE);
    2172. 

  2172.                             }
    2173. 

  2173.                         }
    2174. 

  2174.                     }                    
    2175. 

  2175.                 }
    2176. 

  2176.                 
    2177. 

  2177.             } else {
    2178. 

  2178. 

  2179.                 if(!is_null($element_id)){
    2180. 

  2180.                     $postarr['ID'] = $_POST['post_ID'] = $element_id;
    2181. 

  2181.                 }
    2182. 

  2182.                             
    2183. 

  2183.                 foreach($job->elements as $field){
    2184. 

  2184.                     switch($field->field_type){
    2185. 

  2185.                         case 'title': 
    2186. 

  2186.                             $postarr['post_title'] = $this->decode_field_data($field->field_data_translated, $field->field_format); 
    2187. 

  2187.                             break;                            
    2188. 

  2188.                         case 'body':
    2189. 

  2189.                             $postarr['post_content'] = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2190. 

  2190.                             break;
    2191. 

  2191.                         case 'excerpt': 
    2192. 

  2192.                             $postarr['post_excerpt'] = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2193. 

  2193.                             break;
    2194. 

  2194.                         case 'URL':
    2195. 

  2195.                             $postarr['post_name'] = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2196. 

  2196.                             break;
    2197. 

  2197.                         case 'tags': 
    2198. 

  2198.                             $tags = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2199. 

  2199.                             $original_tags = $this->decode_field_data($field->field_data, $field->field_format);
    2200. 

  2200.                             // create tags that don't exist
    2201. 

  2201.                             foreach($tags as $k=>$t){
    2202. 

  2202.                                 $thetag = $sitepress->get_term_by_name_and_lang($t, 'post_tag', $job->language_code);
    2203. 

  2203.                                 $tags[$k] = $t; // Save $t as we may have added @.lang to it
    2204. 

  2204.                                 if(empty($thetag)){
    2205. 

  2205.                                     $the_original_tag = $sitepress->get_term_by_name_and_lang($original_tags[$k], 'post_tag', $job->source_language_code);
    2206. 

  2206.                                     $tmp = wp_insert_term($t, 'post_tag');
    2207. 

  2207.                                     if(!is_wp_error($tmp) && isset($tmp['term_taxonomy_id'])){
    2208. 

  2208.                                         $sitepress->set_term_translation($the_original_tag,
    2209. 

  2209.                                                                             $tmp['term_taxonomy_id'],
    2210. 

  2210.                                                                             'post_tag',
    2211. 

  2211.                                                                             $job->language_code,
    2212. 

  2212.                                                                             $job->source_language_code);
    2213. 

  2213.                                     }
    2214. 

  2214.                                 }
    2215. 

  2215.                             }
    2216. 

  2216.                             $postarr['tags_input'] = join(',', $tags);
    2217. 

  2217.                             $postarr['tax_input']['post_tag'] = $tags;
    2218. 

  2218.                             
    2219. 

  2219.                             break;
    2220. 

  2220.                         case 'categories': 
    2221. 

  2221.                             $cats = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2222. 

  2222.                             $original_cats = $this->decode_field_data($field->field_data, $field->field_format);
    2223. 

  2223.                             $missing_parents = array();
    2224. 

  2224.                             foreach($cats as $k=>$c){
    2225. 

  2225.                                 $parent_missing = false;
    2226. 

  2226.                                 $thecat = $sitepress->get_term_by_name_and_lang($c, 'category', $job->language_code);
    2227. 

  2227.                                 if(empty($thecat)){
    2228. 

  2228.                                     $the_original_cat = $sitepress->get_term_by_name_and_lang($original_cats[$k], 'category', $job->source_language_code);
    2229. 

  2229.                                     if ($the_original_cat) {
    2230. 

  2230.                                         $the_original_cat_parent = $wpdb->get_var("SELECT parent FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id=".$the_original_cat->term_taxonomy_id);
    2231. 

  2231.                                     } else {
    2232. 

  2232.                                         $the_original_cat_parent = false;
    2233. 

  2233.                                     }
    2234. 

  2234.                                     if($the_original_cat_parent){
    2235. 

  2235.                                         $op_tr = icl_object_id($the_original_cat_parent, 'category', false, $job->language_code);
    2236. 

  2236.                                         if (!$op_tr) {
    2237. 

  2237.                                             // The parent is missing. Possibly because we haven't created a translation of it yet
    2238. 

  2238.                                             $parent_missing = true;
    2239. 

  2239.                                         }
    2240. 

  2240.                                     }else{$op_tr = 0;}                                
    2241. 

  2241.                                     $tmp = wp_insert_term($c, 'category', array('parent'=>$op_tr));
    2242. 

  2242.                                     if(!is_wp_error($tmp) && isset($tmp['term_taxonomy_id'])){
    2243. 

  2243.                                         $sitepress->set_term_translation($the_original_cat,
    2244. 

  2244.                                                                             $tmp['term_taxonomy_id'],
    2245. 

  2245.                                                                             'category',
    2246. 

  2246.                                                                             $job->language_code,
    2247. 

  2247.                                                                             $job->source_language_code);
    2248. 

  2248.                                         
    2249. 

  2249.                                     }
    2250. 

  2250.                                     $cat_id = $tmp['term_id'];
    2251. 

  2251.                                 }else{
    2252. 

  2252.                                     $cat_id = $thecat->term_id;
    2253. 

  2253.                                 }
    2254. 

  2254.                                 
    2255. 

  2255.                                 $cat_ids[] = $cat_id;
    2256. 

  2256.                                 
    2257. 

  2257.                                 if ($parent_missing) {
    2258. 

  2258.                                     $missing_parents[$cat_id] = $the_original_cat_parent;
    2259. 

  2259.                                 }
    2260. 

  2260.                             }
    2261. 

  2261. 

  2262.                             // Double check missing parents as they might be available now.
    2263. 

  2263.                             foreach ($missing_parents as $cat_id => $the_original_cat_parent) {
    2264. 

  2264.                                 $op_tr = icl_object_id($the_original_cat_parent, 'category', false, $job->language_code);
    2265. 

  2265.                                 $cat_trid = $sitepress->get_element_trid($cat_id,'tax_category');
    2266. 

  2266.                                 wp_update_term($cat_id, 'category', array('parent' => $op_tr));
    2267. 

  2267.                                 $wpdb->update($wpdb->prefix.'icl_translations', 
    2268. 

  2268.                                     array('language_code'=>$job->language_code, 'trid'=>$cat_trid, 'source_language_code'=>$job->source_language_code), 
    2269. 

  2269.                                     array('element_type'=>'tax_category','element_id'=>$cat_id));
    2270. 

  2270.                             }
    2271. 

  2271. 

  2272.                             $postarr['post_category'] = $cat_ids;
    2273. 

  2273.                             break;
    2274. 

  2274.                         default:
    2275. 

  2275.                             if(in_array($field->field_type, $sitepress->get_translatable_taxonomies(false, $job->original_post_type))){                            
    2276. 

  2276.                                 $taxs = $this->decode_field_data($field->field_data_translated, $field->field_format);
    2277. 

  2277.                                 
    2278. 

  2278.                                 $original_taxs = $this->decode_field_data($field->field_data, $field->field_format);
    2279. 

  2279.                                 $taxonomy = $field->field_type;
    2280. 

  2280.                                 $alltaxs = $tax_ids = array();
    2281. 

  2281.                                 foreach($taxs as $k=>$c){
    2282. 

  2282.                                     $thetax = $sitepress->get_term_by_name_and_lang($c, $taxonomy, $job->language_code);
    2283. 

  2283.                                     
    2284. 

  2284.                                     $taxs[$k] = $c; // Save $c as we may have added @.lang to it
    2285. 

  2285.                                     if(empty($thetax)){
    2286. 

  2286.                                         $the_original_tax = $sitepress->get_term_by_name_and_lang($original_taxs[$k], $taxonomy, $job->source_language_code);                                
    2287. 

  2287.                                         $the_original_tax_parent = $wpdb->get_var("SELECT parent FROM {$wpdb->term_taxonomy} WHERE term_taxonomy_id=".$the_original_tax->term_taxonomy_id);
    2288. 

  2288.                                         if($the_original_tax_parent){
    2289. 

  2289.                                             $op_tr = icl_object_id($the_original_tax_parent, $taxonomy, false, $job->language_code);
    2290. 

  2290.                                         }else{$op_tr = 0;}                                
    2291. 

  2291.                                         
    2292. 

  2292.                                         $tmp = wp_insert_term($c, $taxonomy, array('parent'=>$op_tr));
    2293. 

  2293.                                         if(isset($tmp['term_taxonomy_id'])){                
    2294. 

  2294.                                             $sitepress->set_term_translation($the_original_tax,
    2295. 

  2295.                                                                             $tmp['term_taxonomy_id'],
    2296. 

  2296.                                                                             $taxonomy,
    2297. 

  2297.                                                                             $job->language_code,
    2298. 

  2298.                                                                             $job->source_language_code);
    2299. 

  2299.                                         }
    2300. 

  2300.                                         $tax_id = $tmp['term_id'];
    2301. 

  2301.                                          
    2302. 

  2302.                                     }else{
    2303. 

  2303.                                         $tax_id = $thetax->term_id;
    2304. 

  2304.                                     }                                
    2305. 

  2305.                                     $tax_ids[] = $tax_id;
    2306. 

  2306.                                     $alltaxs[] = $c;
    2307. 

  2307.                                 }
    2308. 

  2308.                                 
    2309. 

  2309.                                 $taxonomy_obj = get_taxonomy($taxonomy);
    2310. 

  2310.                                 // array = hierarchical, string = non-hierarchical.
    2311. 

  2311.                                 if ($taxonomy_obj->hierarchical) {
    2312. 

  2312.                                     $postarr['tax_input'][$taxonomy] = $tax_ids;
    2313. 

  2313.                                 } else {
    2314. 

  2314.                                     $postarr['tax_input'][$taxonomy] = $taxs;
    2315. 

  2315.                                 }
    2316. 

  2316.                             }
    2317. 

  2317.                     }
    2318. 

  2318.                 }
    2319. 

  2319.                             
    2320. 

  2320.                 $original_post = get_post($job->original_doc_id);
    2321. 

  2321.                 
    2322. 

  2322.                 $postarr['post_author'] = $original_post->post_author;  
    2323. 

  2323.                 $postarr['post_type'] = $original_post->post_type;
    2324. 

  2324.                 
    2325. 

  2325.                 if($sitepress_settings['sync_comment_status']){
    2326. 

  2326.                     $postarr['comment_status'] = $original_post->comment_status;
    2327. 

  2327.                 }
    2328. 

  2328.                 if($sitepress_settings['sync_ping_status']){
    2329. 

  2329.                     $postarr['ping_status'] = $original_post->ping_status;
    2330. 

  2330.                 }
    2331. 

  2331.                 if($sitepress_settings['sync_page_ordering']){
    2332. 

  2332.                     $postarr['menu_order'] = $original_post->menu_order;
    2333. 

  2333.                 }
    2334. 

  2334.                 if($sitepress_settings['sync_private_flag'] && $original_post->post_status=='private'){    
    2335. 

  2335.                     $postarr['post_status'] = 'private';
    2336. 

  2336.                 }
    2337. 

  2337.                 if($sitepress_settings['sync_post_date']){
    2338. 

  2338.                     $postarr['post_date'] = $original_post->post_date;
    2339. 

  2339.                 }                
    2340. 

  2340.                 
    2341. 

  2341.                 
    2342. 

  2342.                 if(is_null($element_id)){
    2343. 

  2343.                     $postarr['post_status'] = !$sitepress_settings['translated_document_status'] ? 'draft' : $original_post->post_status;
    2344. 

  2344.                 } else {
    2345. 

  2345.                     // set post_status to the current post status.
    2346. 

  2346.                     $postarr['post_status'] = $wpdb->get_var("SELECT post_status FROM {$wpdb->prefix}posts WHERE ID = ".$element_id);
    2347. 

  2347.                 }
    2348. 

  2348.                 
    2349. 

  2349.                 if($original_post->post_parent){
    2350. 

  2350.                     $post_parent_trid = $wpdb->get_var("SELECT trid FROM {$wpdb->prefix}icl_translations 
    2351. 

  2351.                         WHERE element_type='post_{$original_post->post_type}' AND element_id='{$original_post->post_parent}'");
    2352. 

  2352.                     if($post_parent_trid){
    2353. 

  2353.                         $parent_id = $wpdb->get_var("SELECT element_id FROM {$wpdb->prefix}icl_translations 
    2354. 

  2354.                             WHERE element_type='post_{$original_post->post_type}' AND trid='{$post_parent_trid}' AND language_code='{$job->language_code}'");
    2355. 

  2355.                     }            
    2356. 

  2356.                 }
    2357. 

  2357.                 
    2358. 

  2358.                 if(isset($parent_id) && $sitepress_settings['sync_page_parent']){
    2359. 

  2359.                     $_POST['post_parent'] = $postarr['post_parent'] = $parent_id;  
    2360. 

  2360.                     $_POST['parent_id'] = $postarr['parent_id'] = $parent_id;  
    2361. 

  2361.                 }
    2362. 

  2362.                 
    2363. 

  2363.                 $_POST['trid'] = $trid;
    2364. 

  2364.                 $_POST['lang'] = $job->language_code;
    2365. 

  2365.                 $_POST['skip_sitepress_actions'] = true;
    2366. 

  2366.     
    2367. 

  2367.                 $postarr = apply_filters('icl_pre_save_pro_translation', $postarr);
    2368. 

  2368. 

  2369.                 if(isset($element_id)){ // it's an update so dont change the url
    2370. 

  2370.                     $postarr['post_name'] = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID=%d", $element_id));
    2371. 

  2371.                 }
    2372. 

  2372.                                 
    2373. 

  2373.                 $new_post_id = wp_insert_post($postarr);
    2374. 

  2374.                 do_action('icl_pro_translation_saved', $new_post_id, $data['fields']);
    2375. 

  2375.                 
    2376. 

  2376.                 
    2377. 

  2377.                 // Allow identical slugs
    2378. 

  2378.                 $post_name = sanitize_title($postarr['post_title']);
    2379. 

  2379.                 $post_name_rewritten = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID=%d", $new_post_id));
    2380. 

  2380.                 
    2381. 

  2381.                 $post_name_base = $post_name;
    2382. 

  2382.                 
    2383. 

  2383.                 if($post_name != $post_name_rewritten){
    2384. 

  2384.                     $incr = 1;                    
    2385. 

  2385.                     do{
    2386. 

  2386.                         
    2387. 

  2387.                         $exists = $wpdb->get_var($wpdb->prepare("
    2388. 

  2388.                             SELECT p.ID FROM {$wpdb->posts} p
    2389. 

  2389.                                 JOIN {$wpdb->prefix}icl_translations t ON t.element_id = p.ID AND t.element_type=%s
    2390. 

  2390.                             WHERE p.ID <> %d AND t.language_code = %s AND p.post_name=%s
    2391. 

  2391.                         ", 'post_' . $postarr['post_type'], $new_post_id, $job->language_code, $post_name));
    2392. 

  2392.                         
    2393. 

  2393.                         if($exists){
    2394. 

  2394.                             $incr++;
    2395. 

  2395.                         }else{
    2396. 

  2396.                             break;
    2397. 

  2397.                         }
    2398. 

  2398.                         $post_name = $post_name_base . '-' . $incr;
    2399. 

  2399.                          
    2400. 

  2400.                     }while($exists);
    2401. 

  2401.                     
    2402. 

  2402.                     $wpdb->update($wpdb->posts, array('post_name' => $post_name), array('ID' => $new_post_id));
    2403. 

  2403.                 }
    2404. 

  2404.                     
    2405. 

  2405.                     
    2406. 

  2406.                 
    2407. 

  2407.                 
    2408. 

  2408.     
    2409. 

  2409.                 $ICL_Pro_Translation->_content_fix_links_to_translated_content($new_post_id, $job->language_code);
    2410. 

  2410.                 
    2411. 

  2411.                 // update body translation with the links fixed
    2412. 

  2412.                 $new_post_content = $wpdb->get_var($wpdb->prepare("SELECT post_content FROM {$wpdb->posts} WHERE ID=%d", $new_post_id));
    2413. 

  2413.                 foreach($job->elements as $jel){
    2414. 

  2414.                     if($jel->field_type=='body'){
    2415. 

  2415.                         $fields_data_translated = $this->encode_field_data($new_post_content, $jel->field_format);
    2416. 

  2416.                         break;
    2417. 

  2417.                     }
    2418. 

  2418.                 }
    2419. 

  2419.                 $wpdb->update($wpdb->prefix.'icl_translate', array('field_data_translated'=>$fields_data_translated), array('job_id'=>$data['job_id'], 'field_type'=>'body'));
    2420. 

  2420.                 
    2421. 

  2421.                            
    2422. 

  2422.                 // set stickiness
    2423. 

  2423.                 //is the original post a sticky post?
    2424. 

  2424.                 remove_filter('option_sticky_posts', array($sitepress,'option_sticky_posts')); // remove filter used to get language relevant stickies. get them all
    2425. 

  2425.                 $sticky_posts = get_option('sticky_posts');
    2426. 

  2426.                 $is_original_sticky = $original_post->post_type=='post' && in_array($original_post->ID, $sticky_posts);
    2427. 

  2427.                 
    2428. 

  2428.                 if($is_original_sticky && $sitepress_settings['sync_sticky_flag']){
    2429. 

  2429.                     stick_post($new_post_id);
    2430. 

  2430.                 }else{
    2431. 

  2431.                     if($original_post->post_type=='post' && !is_null($element_id)){
    2432. 

  2432.                         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
    2433. 

  2433.                     }
    2434. 

  2434.                 }
    2435. 

  2435.                  
    2436. 

  2436.                 //sync plugins texts
    2437. 

  2437.                 foreach((array)$this->settings['custom_fields_translation'] as $cf => $op){
    2438. 

  2438.                     if ($op == 1) {
    2439. 

  2439.                         update_post_meta($new_post_id, $cf, get_post_meta($original_post->ID,$cf,true));
    2440. 

  2440.                     }
    2441. 

  2441.                 }
    2442. 

  2442.                            
    2443. 

  2443.                 // set specific custom fields
    2444. 

  2444.                 $copied_custom_fields = array('_top_nav_excluded', '_cms_nav_minihome');    
    2445. 

  2445.                 foreach($copied_custom_fields as $ccf){
    2446. 

  2446.                     $val = get_post_meta($original_post->ID, $ccf, true);
    2447. 

  2447.                     update_post_meta($new_post_id, $ccf, $val);
    2448. 

  2448.                 }    
    2449. 

  2449.                 
    2450. 

  2450.                 // sync _wp_page_template
    2451. 

  2451.                 if($sitepress_settings['sync_page_template']){
    2452. 

  2452.                     $_wp_page_template = get_post_meta($original_post->ID, '_wp_page_template', true);
    2453. 

  2453.                     if(!empty($_wp_page_template)){
    2454. 

  2454.                         update_post_meta($new_post_id, '_wp_page_template', $_wp_page_template);
    2455. 

  2455.                     }
    2456. 

  2456.                 }
    2457. 

  2457.     
    2458. 

  2458.                    
    2459. 

  2459.                 // set the translated custom fields if we have any.
    2460. 

  2460.                 foreach((array)$this->settings['custom_fields_translation'] as $field_name => $val){
    2461. 

  2461.                     if ($val == 2) { // should be translated
    2462. 

  2462.                         // find it in the translation
    2463. 

  2463.                         foreach($job->elements as $name => $eldata) {
    2464. 

  2464.                             if ($eldata->field_data == $field_name) {
    2465. 

  2465.                                 if (preg_match("/field-(.*?)-name/", $eldata->field_type, $match)) {
    2466. 

  2466.                                     $field_id = $match[1];                                
    2467. 

  2467.                                     foreach($job->elements as $k => $v){
    2468. 

  2468.                                         if($v->field_type=='field-'.$field_id){
    2469. 

  2469.                                             $field_translation = $this->decode_field_data($v->field_data_translated, $v->field_format) ;
    2470. 

  2470.                                         }
    2471. 

  2471.                                         if($v->field_type=='field-'.$field_id.'-type'){
    2472. 

  2472.                                             $field_type = $v->field_data;
    2473. 

  2473.                                         }
    2474. 

  2474.                                     }
    2475. 

  2475.                                     if ($field_type == 'custom_field') {
    2476. 

  2476.                                         $field_translation = str_replace ( '&#0A;', "\n", $field_translation );
    2477. 

  2477.                                         // always decode html entities  eg decode &amp; to &
    2478. 

  2478.                                         $field_translation = html_entity_decode($field_translation);
    2479. 

  2479.                                         update_post_meta($new_post_id, $field_name, $field_translation);
    2480. 

  2480.                                     }
    2481. 

  2481.                                 }
    2482. 

  2482.                             }
    2483. 

  2483.                         }
    2484. 

  2484.                     }
    2485. 

  2485.                 }
    2486. 

  2486.                 $link = get_edit_post_link($new_post_id);
    2487. 

  2487.                 if ($link == '') {
    2488. 

  2488.                     // the current user can't edit so just include permalink
    2489. 

  2489.                     $link = get_permalink($new_post_id);
    2490. 

  2490.                 }
    2491. 

  2491.                 if(is_null($element_id)){
    2492. 

  2492.                     $wpdb->update($wpdb->prefix.'icl_translations', array('element_id' => $new_post_id), array('translation_id' => $translation_id) );
    2493. 

  2493.                     $user_message = __('Translation added: ', 'sitepress') . '<a href="'.$link.'">' . $postarr['post_title'] . '</a>.';
    2494. 

  2494.                 }else{
    2495. 

  2495.                     $user_message = __('Translation updated: ', 'sitepress') . '<a href="'.$link.'">' . $postarr['post_title'] . '</a>.';                
    2496. 

  2496.                 }
    2497. 

  2497.             }                                                  
    2498. 

  2498.                         
    2499. 

  2499.             
    2500. 

  2500.             $this->messages[] = array(
    2501. 

  2501.                 'type'=>'updated',
    2502. 

  2502.                 'text' => $user_message
    2503. 

  2503.             );
    2504. 

  2504.             
    2505. 

  2505.             
    2506. 

  2506.             if($this->settings['notification']['completed'] != ICL_TM_NOTIFICATION_NONE){
    2507. 

  2507.                 require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    2508. 

  2508.                 if($data['job_id']){
    2509. 

  2509.                     $tn_notification = new TM_Notification();
    2510. 

  2510.                     $tn_notification->work_complete($data['job_id'], !is_null($element_id));
    2511. 

  2511.                 }
    2512. 

  2512.             }
    2513. 

  2513.             
    2514. 

  2514.             self::set_page_url($new_post_id);
    2515. 

  2515.             
    2516. 

  2516.             // redirect to jobs list
    2517. 

  2517.             wp_redirect(admin_url(sprintf('admin.php?page=%s&%s=%d', 
    2518. 

  2518.                 WPML_TM_FOLDER . '/menu/translations-queue.php', is_null($element_id) ? 'added' : 'updated', is_null($element_id) ? $new_post_id : $element_id )));
    2519. 

  2519.             
    2520. 

  2520.         }else{
    2521. 

  2521.             $this->messages[] = array('type'=>'updated', 'text' => __('Translation (incomplete) saved.', 'sitepress'));
    2522. 

  2522.         }
    2523. 

  2523.         
    2524. 

  2524.     }
    2525. 

  2525.     
    2526. 

  2526.     // returns a front end link to a post according to the user access
    2527. 

  2527.     // hide_empty - if current user doesn't have access to the link don't show at all
    2528. 

  2528.     public function tm_post_link($post_id, $anchor = false, $hide_empty = false){
    2529. 

  2529.         global $current_user;
    2530. 

  2530.         get_currentuserinfo();
    2531. 

  2531.         
    2532. 

  2532.         $parts = explode('_', $post_id);
    2533. 

  2533.         if ($parts[0] == 'external') {
    2534. 

  2534.             
    2535. 

  2535.             $link = '';
    2536. 

  2536.             return apply_filters('WPML_get_link', $link, $post_id, $anchor, $hide_empty);
    2537. 

  2537.         }
    2538. 

  2538.         
    2539. 

  2539.         if(false === $anchor){
    2540. 

  2540.             $anchor = get_the_title($post_id);    
    2541. 

  2541.         }
    2542. 

  2542.         
    2543. 

  2543.         $opost = get_post($post_id);
    2544. 

  2544.         if(($opost->post_status == 'draft' || $opost->post_status == 'private') && $opost->post_author != $current_user->data->ID){
    2545. 

  2545.             if($hide_empty){
    2546. 

  2546.                 $elink = '';                
    2547. 

  2547.             }else{
    2548. 

  2548.                 $elink = sprintf('<i>%s</i>', $anchor);
    2549. 

  2549.             }
    2550. 

  2550.         }else{
    2551. 

  2551.             $elink = sprintf('<a href="%s">%s</a>', get_permalink($post_id), $anchor);    
    2552. 

  2552.         }
    2553. 

  2553.         
    2554. 

  2554.         return $elink;
    2555. 

  2555.         
    2556. 

  2556.     }
    2557. 

  2557.     
    2558. 

  2558.     public function tm_post_permalink($post_id){
    2559. 

  2559.         global $current_user;
    2560. 

  2560.         get_currentuserinfo();
    2561. 

  2561.         
    2562. 

  2562.         $parts = explode('_', $post_id);
    2563. 

  2563.         if ($parts[0] == 'external') {
    2564. 

  2564.             
    2565. 

  2565.             return '';
    2566. 

  2566.         }
    2567. 

  2567.         
    2568. 

  2568.         $opost = get_post($post_id);
    2569. 

  2569.         if(($opost->post_status == 'draft' || $opost->post_status == 'private') && $opost->post_author != $current_user->data->ID){
    2570. 

  2570.             $elink = '';                
    2571. 

  2571.         }else{
    2572. 

  2572.             $elink = get_permalink($post_id);    
    2573. 

  2573.         }
    2574. 

  2574.         
    2575. 

  2575.         return $elink;
    2576. 

  2576.         
    2577. 

  2577.     }
    2578. 

  2578.  
    2579. 

  2579.     //
    2580. 

  2580.     // when the translated post was created, we have the job_id and need to update the job
    2581. 

  2581.     function save_job_fields_from_post($job_id, $post){
    2582. 

  2582.         global $wpdb, $sitepress;
    2583. 

  2583.         $data['complete'] = 1;
    2584. 

  2584.         $data['job_id'] = $job_id;        
    2585. 

  2585.         $job = $this->get_translation_job($job_id,1);
    2586. 

  2586.         
    2587. 

  2587.         if(is_array($job->elements))
    2588. 

  2588.         foreach($job->elements as $element){
    2589. 

  2589.             $field_data = '';
    2590. 

  2590.             switch($element->field_type){
    2591. 

  2591.                 case 'title':
    2592. 

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

  2593.                     break;
    2594. 

  2594.                 case 'body':
    2595. 

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

  2596.                     break;
    2597. 

  2597.                 case 'excerpt':
    2598. 

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

  2599.                     break;                           
    2600. 

  2600.                 default:
    2601. 

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

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

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

  2604.                             if($this->settings['custom_fields_translation'][$cf_name] == 1){ //copy
    2605. 

  2605.                                 $field_data = get_post_meta($original_post->ID, $cf_name, 1);               
    2606. 

  2606.                                 if(is_scalar($field_data))
    2607. 

  2607.                                 $field_data = $this->encode_field_data($field_data, $element->field_format);                             
    2608. 

  2608.                                 else $field_data = '';
    2609. 

  2609.                             }elseif($this->settings['custom_fields_translation'][$cf_name] == 2){ // translate
    2610. 

  2610.                                 $field_data = get_post_meta($post->ID, $cf_name, 1);             
    2611. 

  2611.                                 if(is_scalar($field_data))
    2612. 

  2612.                                 $field_data = $this->encode_field_data($field_data, $element->field_format);                             
    2613. 

  2613.                                 else $field_data = '';
    2614. 

  2614.                             }
    2615. 

  2615.                         }
    2616. 

  2616.                     }else{
    2617. 

  2617.                         if(in_array($element->field_type, $sitepress->get_translatable_taxonomies(true, $post->post_type))){                            
    2618. 

  2618.                             $ids = array();
    2619. 

  2619.                             foreach($job->elements as $je){
    2620. 

  2620.                                 if($je->field_type == $element->field_type .'_ids' ){
    2621. 

  2621.                                     $ids = explode(',', $je->field_data);
    2622. 

  2622.                                 }
    2623. 

  2623.                             }
    2624. 

  2624.                             $translated_tax_names = array();
    2625. 

  2625.                             foreach($ids as $id){
    2626. 

  2626.                                 $translated_tax_id = icl_object_id($id, $element->field_type,false,$job->language_code);
    2627. 

  2627.                                 if($translated_tax_id){
    2628. 

  2628.                                     $translated_tax_names[] = $wpdb->get_var($wpdb->prepare("
    2629. 

  2629.                                         SELECT t.name FROM {$wpdb->terms} t JOIN {$wpdb->term_taxonomy} x ON t.term_id = x.term_id
    2630. 

  2630.                                         WHERE x.term_taxonomy_id = {$translated_tax_id}
    2631. 

  2631.                                     "));
    2632. 

  2632.                                 }
    2633. 

  2633.                             }
    2634. 

  2634.                             $field_data = $this->encode_field_data($translated_tax_names, $element->field_format);
    2635. 

  2635.                             
    2636. 

  2636.                         }
    2637. 

  2637.                     }
    2638. 

  2638.             }            
    2639. 

  2639.             $wpdb->update($wpdb->prefix.'icl_translate', 
    2640. 

  2640.                 array('field_data_translated'=>$field_data, 'field_finished'=>1), 
    2641. 

  2641.                 array('tid'=>$element->tid)
    2642. 

  2642.             );
    2643. 

  2643.             
    2644. 

  2644.         }   
    2645. 

  2645.         
    2646. 

  2646.         $this->mark_job_done($job_id);                
    2647. 

  2647. 

  2648.     }
    2649. 

  2649.     
    2650. 

  2650.     public function determine_translated_taxonomies($elements, $taxonomy, $translated_language){
    2651. 

  2651.         global $sitepress, $wpdb;
    2652. 

  2652.         foreach($elements as $k=>$element){
    2653. 

  2653.             $term = get_term_by('name', $element, $taxonomy);
    2654. 

  2654.             if ($term) {
    2655. 

  2655.                 $trid = $sitepress->get_element_trid($term->term_taxonomy_id, 'tax_' . $taxonomy);
    2656. 

  2656.                 $translations = $sitepress->get_element_translations($trid, 'tax_' . $taxonomy);
    2657. 

  2657.                 if(isset($translations[$translated_language])){
    2658. 

  2658.                     $translated_elements[$k] = $translations[$translated_language]->name;   
    2659. 

  2659.                 }else{
    2660. 

  2660.                     $translated_elements[$k] = '';
    2661. 

  2661.                 }
    2662. 

  2662.             } else {
    2663. 

  2663.                 $translated_elements[$k] = '';
    2664. 

  2664.             }
    2665. 

  2665.         }
    2666. 

  2666.         
    2667. 

  2667.         return $translated_elements;
    2668. 

  2668.     }
    2669. 

  2669.     
    2670. 

  2670.     function mark_job_done($job_id){
    2671. 

  2671.         global $wpdb;
    2672. 

  2672.         $wpdb->update($wpdb->prefix.'icl_translate_job', array('translated'=>1), array('job_id'=>$job_id));
    2673. 

  2673.         $wpdb->update($wpdb->prefix.'icl_translate', array('field_finished'=>1), array('job_id'=>$job_id));
    2674. 

  2674.     }
    2675. 

  2675.     
    2676. 

  2676.     function resign_translator($job_id){
    2677. 

  2677.         global $wpdb;
    2678. 

  2678.         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);
    2679. 

  2679.         
    2680. 

  2680.         if(!empty($translator_id)){
    2681. 

  2681.             if($this->settings['notification']['resigned'] != ICL_TM_NOTIFICATION_NONE){
    2682. 

  2682.                 require_once ICL_PLUGIN_PATH . '/inc/translation-management/tm-notification.class.php';
    2683. 

  2683.                 if($job_id){
    2684. 

  2684.                     $tn_notification = new TM_Notification();
    2685. 

  2685.                     $tn_notification->translator_resigned($translator_id, $job_id);
    2686. 

  2686.                 }
    2687. 

  2687.             }
    2688. 

  2688.         }
    2689. 

  2689.         
    2690. 

  2690.         $wpdb->update($wpdb->prefix.'icl_translate_job', array('translator_id'=>0), array('job_id'=>$job_id));
    2691. 

  2691.         $wpdb->update($wpdb->prefix.'icl_translation_status', array('translator_id'=>0, 'status'=>ICL_TM_WAITING_FOR_TRANSLATOR), array('rid'=>$rid));
    2692. 

  2692.     }
    2693. 

  2693.     
    2694. 

  2694.     // $translation_id - int or array
    2695. 

  2695.     function cancel_translation_request($translation_id){
    2696. 

  2696.         global $wpdb;
    2697. 

  2697.         
    2698. 

  2698.         if(is_array($translation_id)){
    2699. 

  2699.             foreach($translation_id as $id){
    2700. 

  2700.                 $this->cancel_translation_request($id);
    2701. 

  2701.             }
    2702. 

  2702.         }else{
    2703. 

  2703. 

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

  2705.             $job_id = $wpdb->get_var($wpdb->prepare("SELECT job_id FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d AND revision IS NULL ", $rid));
    2706. 

  2706.             $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate_job WHERE job_id=%d", $job_id));
    2707. 

  2707.             $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_translate WHERE job_id=%d", $job_id));
    2708. 

  2708.             
    2709. 

  2709.             $max_job_id = $wpdb->get_var($wpdb->prepare("SELECT MAX(job_id) FROM {$wpdb->prefix}icl_translate_job WHERE rid=%d", $rid));
    2710. 

  2710.             if($max_job_id){
    2711. 

  2711.                 $wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}icl_translate_job SET revision = NULL WHERE job_id=%d", $max_job_id));
    2712. 

  2712.                 $_prevstate = $wpdb->get_var($wpdb->prepare("SELECT _prevstate FROM {$wpdb->prefix}icl_translation_status WHERE translation_id = %d", $translation_id));
    2713. 

  2713.                 if(!empty($_prevstate)){                
    2714. 

  2714.                     $_prevstate = unserialize($_prevstate);
    2715. 

  2715.                     $wpdb->update($wpdb->prefix . 'icl_translation_status', 
    2716. 

  2716.                         array(
    2717. 

  2717.                             'status'                => $_prevstate['status'], 
    2718. 

  2718.                             'translator_id'         => $_prevstate['translator_id'], 
    2719. 

  2719.                             'status'                => $_prevstate['status'], 
    2720. 

  2720.                             'needs_update'          => $_prevstate['needs_update'], 
    2721. 

  2721.                             'md5'                   => $_prevstate['md5'], 
    2722. 

  2722.                             'translation_service'   => $_prevstate['translation_service'], 
    2723. 

  2723.                             'translation_package'   => $_prevstate['translation_package'], 
    2724. 

  2724.                             'timestamp'             => $_prevstate['timestamp'], 
    2725. 

  2725.                             'links_fixed'           => $_prevstate['links_fixed'] 
    2726. 

  2726.                         ), 
    2727. 

  2727.                         array('translation_id'=>$translation_id)
    2728. 

  2728.                     ); 
    2729. 

  2729.                 }                
    2730. 

  2730.             }else{
    2731. 

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

  2732.             }
    2733. 

  2733.         }
    2734. 

  2734.         
    2735. 

  2735.     }    
    2736. 

  2736.     
    2737. 

  2737.     /* WPML CONFIG */
    2738. 

  2738.     /* ******************************************************************************************** */           
    2739. 

  2739.     function _parse_wpml_config($file){
    2740. 

  2740.         global $sitepress, $sitepress_settings;
    2741. 

  2741.         
    2742. 

  2742.         $config = icl_xml2array(file_get_contents($file));    
    2743. 

  2743.         
    2744. 

  2744.         // custom fields
    2745. 

  2745.         if(!empty($config['wpml-config']['custom-fields'])){
    2746. 

  2746.             if(!is_numeric(key(current($config['wpml-config']['custom-fields'])))){
    2747. 

  2747.                 $cf[0] = $config['wpml-config']['custom-fields']['custom-field'];
    2748. 

  2748.             }else{
    2749. 

  2749.                 $cf = $config['wpml-config']['custom-fields']['custom-field'];
    2750. 

  2750.             }
    2751. 

  2751.             foreach($cf as $c){
    2752. 

  2752.                 if($c['attr']['action'] == 'translate'){
    2753. 

  2753.                     $action = 2;
    2754. 

  2754.                 }elseif($c['attr']['action'] == 'copy'){
    2755. 

  2755.                     $action = 1;
    2756. 

  2756.                 }else{
    2757. 

  2757.                     $action = 0;
    2758. 

  2758.                 }
    2759. 

  2759.                 $this->settings['custom_fields_translation'][$c['value']] = $action;        
    2760. 

  2760.                 if(is_array($this->settings['custom_fields_readonly_config']) && !in_array($c['value'], $this->settings['custom_fields_readonly_config'])){
    2761. 

  2761.                 $this->settings['custom_fields_readonly_config'][] = $c['value'];
    2762. 

  2762.             }
    2763. 

  2763.                 
    2764. 

  2764.         }  
    2765. 

  2765.         }  
    2766. 

  2766.         
    2767. 

  2767.         // custom types
    2768. 

  2768.         $cf = array();        
    2769. 

  2769.         if(!empty($config['wpml-config']['custom-types'])){            
    2770. 

  2770.             if(!is_numeric(key(current($config['wpml-config']['custom-types'])))){
    2771. 

  2771.                 $cf[0] = $config['wpml-config']['custom-types']['custom-type'];
    2772. 

  2772.             }else{
    2773. 

  2773.                 $cf = $config['wpml-config']['custom-types']['custom-type'];
    2774. 

  2774.             }
    2775. 

  2775.             foreach($cf as $c){                
    2776. 

  2776.                 $translate = intval($c['attr']['translate']);
    2777. 

  2777.                 if($translate){
    2778. 

  2778.                     $sitepress->verify_post_translations($c['value']);                
    2779. 

  2779.                 }
    2780. 

  2780.                 $this->settings['custom_types_readonly_config'][$c['value']] = $translate;
    2781. 

  2781.                 $sitepress_settings['custom_posts_sync_option'][$c['value']] = $translate;
    2782. 

  2782.             }            
    2783. 

  2783.             add_filter('get_translatable_documents', array($this, '_override_get_translatable_documents'));  
    2784. 

  2784.         }
    2785. 

  2785.         
    2786. 

  2786.         // taxonomies        
    2787. 

  2787.         $cf = array();
    2788. 

  2788.         if(!empty($config['wpml-config']['taxonomies'])){
    2789. 

  2789.             if(!is_numeric(key(current($config['wpml-config']['taxonomies'])))){
    2790. 

  2790.                 $cf[0] = $config['wpml-config']['taxonomies']['taxonomy'];
    2791. 

  2791.             }else{
    2792. 

  2792.                 $cf = $config['wpml-config']['taxonomies']['taxonomy'];
    2793. 

  2793.             }
    2794. 

  2794.             foreach($cf as $c){                
    2795. 

  2795.                 $translate = intval($c['attr']['translate']);
    2796. 

  2796.                 $this->settings['taxonomies_readonly_config'][$c['value']] = $translate;
    2797. 

  2797.                 $sitepress_settings['taxonomies_sync_option'][$c['value']] = $translate;
    2798. 

  2798.             }   
    2799. 

  2799.             add_filter('get_translatable_taxonomies', array($this, '_override_get_translatable_taxonomies'));  
    2800. 

  2800.         }  
    2801. 

  2801.         
    2802. 

  2802.         // admin texts
    2803. 

  2803.         if(function_exists('icl_register_string')){
    2804. 

  2804.             $admin_texts = array();
    2805. 

  2805.             if(!empty($config['wpml-config']['admin-texts'])){
    2806. 

  2806.                 
    2807. 

  2807.                 $type = (dirname($file) == get_template_directory() || dirname($file) == get_stylesheet_directory()) ? 'theme' : 'plugin';
    2808. 

  2808.                 $atid = basename(dirname($file));                                    
    2809. 

  2809.                 
    2810. 

  2810.                 if( !is_numeric(key(@current($config['wpml-config']['admin-texts'])))){
    2811. 

  2811.                     $admin_texts[0] = $config['wpml-config']['admin-texts']['key'];
    2812. 

  2812.                 }else{
    2813. 

  2813.                     $admin_texts = $config['wpml-config']['admin-texts']['key'];
    2814. 

  2814.                 }
    2815. 

  2815.                 
    2816. 

  2816.                 foreach($admin_texts as $a){
    2817. 

  2817.                     $keys = array(); 
    2818. 

  2818.                     if(!isset($a['key'])){
    2819. 

  2819.                         $arr[$a['attr']['name']] = 1;                                
    2820. 

  2820.                         continue;
    2821. 

  2821.                     }elseif(!is_numeric(key($a['key']))){                    
    2822. 

  2822.                         $keys[0] = $a['key'];
    2823. 

  2823.                     }else{
    2824. 

  2824.                         $keys = $a['key'];
    2825. 

  2825.                     }            
    2826. 

  2826.                     
    2827. 

  2827.                     foreach($keys as $key){                
    2828. 

  2828.                         if(isset($key['key'])){
    2829. 

  2829.                             $arr[$a['attr']['name']][$key['attr']['name']] = $this->_read_admin_texts_recursive($key['key']);
    2830. 

  2830.                         }else{
    2831. 

  2831.                             $arr[$a['attr']['name']][$key['attr']['name']] = 1;                                
    2832. 

  2832.                         }
    2833. 

  2833.                     }
    2834. 

  2834.                 }
    2835. 

  2835.                             
    2836. 

  2836.                 foreach($arr as $key => $v){
    2837. 

  2837.                     
    2838. 

  2838.                     
    2839. 

  2839.                     // http://forum.wpml.org/topic.php?id=4888&replies=7#post-23038
    2840. 

  2840.                     // http://forum.wpml.org/topic.php?id=4615
    2841. 

  2841.                     // http://forum.wpml.org/topic.php?id=4761
    2842. 

  2842.                     remove_filter('option_'.$key, 'icl_st_translate_admin_string');   // dont try to translate this one below      
    2843. 

  2843.                     $value = get_option($key);
    2844. 

  2844.                     add_filter('option_'.$key, 'icl_st_translate_admin_string');       // put the filter back on     
    2845. 

  2845.                     
    2846. 

  2846.                     $value = maybe_unserialize($value);       
    2847. 

  2847.                     if(false === $value){                    
    2848. 

  2848.                         unset($arr[$key]);
    2849. 

  2849.                     }if(is_scalar($value)){                    
    2850. 

  2850.                         icl_register_string('admin_texts_' . $type . '_' . $atid, $key , $value);    
    2851. 

  2851.                     }else{                    
    2852. 

  2852.                         if(is_object($value)) $value = (array)$value;                    
    2853. 

  2853.                         if(!empty($value)){
    2854. 

  2854.                             $this->_register_string_recursive($key, $value, $arr[$key], '', $type . '_' . $atid);    
    2855. 

  2855.                         }
    2856. 

  2856.                     }
    2857. 

  2857.                 }
    2858. 

  2858. 

  2859.                 $this->admin_texts_to_translate = array_merge($this->admin_texts_to_translate, $arr);                        
    2860. 

  2860.                 $_icl_admin_option_names = get_option('_icl_admin_option_names');
    2861. 

  2861.                 
    2862. 

  2862.                 //filter out obsolete entries
    2863. 

  2863.                 /*
    2864. 

  2864.                 $_as_changed = false;
    2865. 

  2865.                 foreach($_icl_admin_option_names[$type][$atid] as $k=>$csf){
    2866. 

  2866.                     if(empty($arr[$csf])){
    2867. 

  2867.                         unset($_icl_admin_option_names[$type][$atid][$k]);    
    2868. 

  2868.                     }
    2869. 

  2869.                 }
    2870. 

  2870.                 */
    2871. 

  2871.                                 
    2872. 

  2872.                 $_icl_admin_option_names[$type][$atid] = @array_merge_recursive((array)$_icl_admin_option_names[$type][$atid], $this->_array_keys_recursive($arr));
    2873. 

  2873.                 $_icl_admin_option_names[$type][$atid] = __array_unique_recursive($_icl_admin_option_names[$type][$atid]);
    2874. 

  2874.                 // __array_unique_recursive is declared in the string translation plugin inc/functions.php
    2875. 

  2875.                 
    2876. 

  2876.                 update_option('_icl_admin_option_names', $_icl_admin_option_names);            
    2877. 

  2877.                 
    2878. 

  2878.             }
    2879. 

  2879.         }  
    2880. 

  2880.         
    2881. 

  2881.         // language-switcher-settings
    2882. 

  2882.         if(empty($sitepress_settings['language_selector_initialized']) || (isset($_GET['restore_ls_settings']) && $_GET['restore_ls_settings'] == 1)){
    2883. 

  2883.             if(!empty($config['wpml-config']['language-switcher-settings'])){
    2884. 

  2884.                 
    2885. 

  2885.                 if(!is_numeric(key($config['wpml-config']['language-switcher-settings']['key']))){
    2886. 

  2886.                     $cfgsettings[0] = $config['wpml-config']['language-switcher-settings']['key'];
    2887. 

  2887.                 }else{
    2888. 

  2888.                     $cfgsettings = $config['wpml-config']['language-switcher-settings']['key'];
    2889. 

  2889.                 }
    2890. 

  2890.                 $iclsettings = $this->_read_settings_recursive($cfgsettings);
    2891. 

  2891.                 
    2892. 

  2892.                 $iclsettings['language_selector_initialized'] = 1;
    2893. 

  2893.                 
    2894. 

  2894.                 $sitepress->save_settings($iclsettings);
    2895. 

  2895.                 
    2896. 

  2896.                 if(!empty($sitepress_settings['setup_complete']) && !empty($_GET['page'])){
    2897. 

  2897.                     wp_redirect(admin_url('admin.php?page='.$_GET['page'].'&icl_ls_reset=default#icl_save_language_switcher_options'));
    2898. 

  2898.                 }
    2899. 

  2899.             }
    2900. 

  2900.         }
    2901. 

  2901.         
    2902. 

  2902.     }
    2903. 

  2903.     
    2904. 

  2904.     function _array_keys_recursive($arr){          
    2905. 

  2905.         $arr_rec_ret = array();
    2906. 

  2906.         foreach((array)$arr as $k=>$v){            
    2907. 

  2907.             if(is_array($v)){                
    2908. 

  2908.                 $arr_rec_ret[$k] = $this->_array_keys_recursive($v);
    2909. 

  2909.             }else{
    2910. 

  2910.                 $arr_rec_ret[] = $k;        
    2911. 

  2911.             }
    2912. 

  2912.         }
    2913. 

  2913.         return $arr_rec_ret;
    2914. 

  2914.     }
    2915. 

  2915.     
    2916. 

  2916.     function _read_admin_texts_recursive($keys){
    2917. 

  2917.         if(!is_numeric(key($keys))){
    2918. 

  2918.             $_keys = array($keys);
    2919. 

  2919.             $keys = $_keys;
    2920. 

  2920.             unset($_keys);
    2921. 

  2921.         }
    2922. 

  2922.         foreach($keys as $key){                
    2923. 

  2923.             if(isset($key['key'])){
    2924. 

  2924.                 $arr[$key['attr']['name']] = $this->_read_admin_texts_recursive($key['key']);                    
    2925. 

  2925.             }else{
    2926. 

  2926.                 $arr[$key['attr']['name']] = 1;                            
    2927. 

  2927.             }
    2928. 

  2928.         }
    2929. 

  2929.         return $arr;
    2930. 

  2930.     }
    2931. 

  2931.     
    2932. 

  2932.     function _register_string_recursive($key, $value, $arr, $prefix = '', $suffix){        
    2933. 

  2933.         if(is_scalar($value)){
    2934. 

  2934.             if(!empty($value) && $arr == 1){
    2935. 

  2935.                 icl_register_string('admin_texts_' . $suffix, $prefix . $key , $value);
    2936. 

  2936.             }
    2937. 

  2937.         }else{
    2938. 

  2938.             if(!is_null($value)){
    2939. 

  2939.                 foreach($value as $sub_key=>$sub_value){
    2940. 

  2940.                     if(isset($arr[$sub_key])){
    2941. 

  2941.                         $this->_register_string_recursive($sub_key, $sub_value, $arr[$sub_key], $prefix . '[' . $key .']', $suffix);    
    2942. 

  2942.                     }
    2943. 

  2943.                 }
    2944. 

  2944.             }
    2945. 

  2945.         }
    2946. 

  2946.     }
    2947. 

  2947.     
    2948. 

  2948.     function _read_settings_recursive($cfgsettings){
    2949. 

  2949.         foreach($cfgsettings as $s){
    2950. 

  2950.             if(isset($s['key'])){
    2951. 

  2951.                 if(!is_numeric(key($s['key']))){
    2952. 

  2952.                     $skey[0] = $s['key'];
    2953. 

  2953.                 }else{
    2954. 

  2954.                     $skey = $s['key'];
    2955. 

  2955.                 }
    2956. 

  2956.                 $iclsettings[$s['attr']['name']] = $this->_read_settings_recursive($skey);
    2957. 

  2957.             }else{
    2958. 

  2958.                 $iclsettings[$s['attr']['name']] = $s['value'];
    2959. 

  2959.             }    
    2960. 

  2960.         }        
    2961. 

  2961.         return $iclsettings;
    2962. 

  2962.     }
    2963. 

  2963.     
    2964. 

  2964.     function render_option_writes($option_name, $option_value, $option_key=''){
    2965. 

  2965.         if(!defined('WPML_ST_FOLDER')) return;
    2966. 

  2966.         static $option;
    2967. 

  2967.         if(!$option_key){
    2968. 

  2968.             $option = maybe_unserialize(get_option($option_name));
    2969. 

  2969.             if(is_object($option)){
    2970. 

  2970.                 $option = (array)$option;
    2971. 

  2971.             }
    2972. 

  2972.         }
    2973. 

  2973.         
    2974. 

  2974.         $option_names = get_option('_icl_admin_option_names');        
    2975. 

  2975.         
    2976. 

  2976.         // determine theme/plugin name (string context)
    2977. 

  2977.         if(!empty($option_names['theme'])){
    2978. 

  2978.             foreach((array)$option_names['theme'][basename(get_template_directory())] as $ops=>$val){
    2979. 

  2979.                 
    2980. 

  2980.                 if(!empty($option_key)){
    2981. 

  2981.                     $int = preg_match_all('#\[([^\]]+)\]#', $option_key, $matches);
    2982. 

  2982.                     if($int) $opname = $matches[1][0];
    2983. 

  2983.                 }else{
    2984. 

  2984.                     $opname = $option_name;
    2985. 

  2985.                 }
    2986. 

  2986.                 
    2987. 

  2987.                 if($ops == $opname){
    2988. 

  2988.                     $es_context = 'admin_texts_theme_' . basename(get_template_directory());
    2989. 

  2989.                     break;
    2990. 

  2990.                 }
    2991. 

  2991.             }
    2992. 

  2992.             
    2993. 

  2993.             if(get_template_directory() != get_stylesheet_directory()){
    2994. 

  2994.                 foreach((array)$option_names['theme'][basename(get_stylesheet_directory())] as $ops=>$val){
    2995. 

  2995. 

  2996.                     if(!empty($option_key)){
    2997. 

  2997.                         $int = preg_match_all('#\[([^\]]+)\]#', $option_key, $matches);
    2998. 

  2998.                         if($int) $opname = $matches[1][0];
    2999. 

  2999.                     }else{
    3000. 

  3000.                         $opname = $option_name;
    3001. 

  3001.                     }
    3002. 

  3002.                     
    3003. 

  3003.                     if($ops == $opname){
    3004. 

  3004.                         $es_context = 'admin_texts_theme_' . get_stylesheet_directory();
    3005. 

  3005.                         break;
    3006. 

  3006.                     }
    3007. 

  3007.                 }
    3008. 

  3008.             }
    3009. 

  3009.         }
    3010. 

  3010.         if(!empty($option_names['plugin'])){
    3011. 

  3011.             foreach((array)$option_names['plugin'] as $plugin => $options){
    3012. 

  3012.                 foreach($options as $ops){
    3013. 

  3013.                     if($ops == $option_name){
    3014. 

  3014.                         $es_context = 'admin_texts_plugin_' . $plugin;
    3015. 

  3015.                         break;
    3016. 

  3016.                     }
    3017. 

  3017.                 }            
    3018. 

  3018.             }
    3019. 

  3019.         }
    3020. 

  3020.         
    3021. 

  3021.         
    3022. 

  3022.         
    3023. 

  3023.         echo '<ul class="icl_tm_admin_options">';
    3024. 

  3024.         echo '<li>';
    3025. 

  3025.         
    3026. 

  3026.         
    3027. 

  3027.         if(is_scalar($option_value)){
    3028. 

  3028.             $int = preg_match_all('#\[([^\]]+)\]#', $option_key, $matches);
    3029. 

  3029.             
    3030. 

  3030.             if(count($matches[1]) > 1){
    3031. 

  3031.                 $value = $option;
    3032. 

  3032.                 for($i = 1; $i < count($matches[1]); $i++){
    3033. 

  3033.                     $value = $value[$matches[1][$i]];
    3034. 

  3034.                 }
    3035. 

  3035.                 $value = $value[$option_name];
    3036. 

  3036.                 $edit_link = '';
    3037. 

  3037.             }else{
    3038. 

  3038.                 if(is_scalar($option)){
    3039. 

  3039.                     $value = $option;
    3040. 

  3040.                 }elseif(isset($option[$option_name])){
    3041. 

  3041.                     $value = $option[$option_name];    
    3042. 

  3042.                 }else{
    3043. 

  3043.                     $value = '';
    3044. 

  3044.                 }
    3045. 

  3045. 

  3046.                 if(!$option_key){
    3047. 

  3047.                     $edit_link = '[<a href="'.admin_url('admin.php?page='.WPML_ST_FOLDER.'/menu/string-translation.php&context='.$es_context) . '">' .
    3048. 

  3048.                      __('translate', 'sitepress') . '</a>]';
    3049. 

  3049.                 }else{
    3050. 

  3050.                     $edit_link = '';
    3051. 

  3051.                 }
    3052. 

  3052.             }
    3053. 

  3053.             
    3054. 

  3054.             echo '<li>' . $option_name . ': <i>' . $value . '</i> ' . $edit_link . '</li>';
    3055. 

  3055.         }else{  
    3056. 

  3056.             $edit_link = '[<a href="'.admin_url('admin.php?page='.WPML_ST_FOLDER.'/menu/string-translation.php&context='.$es_context) . '">' .
    3057. 

  3057.                      __('translate', 'sitepress') . '</a>]';          
    3058. 

  3058.             echo '<strong>' . $option_name . '</strong> ' . $edit_link;
    3059. 

  3059.             foreach((array)$option_value as $key=>$value){
    3060. 

  3060.                 $this->render_option_writes($key, $value, $option_key . '[' . $option_name . ']');                
    3061. 

  3061.             }            
    3062. 

  3062.         }
    3063. 

  3063.         echo '</li>';
    3064. 

  3064.         echo '</ul>';        
    3065. 

  3065.     }
    3066. 

  3066.         
    3067. 

  3067.     function _override_get_translatable_documents($types){
    3068. 

  3068.         global $wp_post_types;
    3069. 

  3069.         foreach($types as $k=>$type){
    3070. 

  3070.             if(isset($this->settings['custom_types_readonly_config'][$k]) && !$this->settings['custom_types_readonly_config'][$k]){
    3071. 

  3071.                 unset($types[$k]);
    3072. 

  3072.             }
    3073. 

  3073.         }
    3074. 

  3074.         foreach($this->settings['custom_types_readonly_config'] as $cp=>$translate){
    3075. 

  3075.             if($translate && !isset($types[$cp]) && isset($wp_post_types[$cp])){
    3076. 

  3076.                 $types[$cp] = $wp_post_types[$cp];
    3077. 

  3077.             }
    3078. 

  3078.         }
    3079. 

  3079.         return $types;
    3080. 

  3080.     }
    3081. 

  3081. 

  3082.     function _override_get_translatable_taxonomies($taxs_obj_type){                
    3083. 

  3083.         global $wp_taxonomies, $sitepress;
    3084. 

  3084.         
    3085. 

  3085.         $taxs = $taxs_obj_type['taxs'];        
    3086. 

  3086.         
    3087. 

  3087.         $object_type = $taxs_obj_type['object_type'];
    3088. 

  3088.         foreach($taxs as $k=>$tax){
    3089. 

  3089.             if(!$sitepress->is_translated_taxonomy($tax)){
    3090. 

  3090.                 unset($taxs[$k]);
    3091. 

  3091.             }
    3092. 

  3092.         }
    3093. 

  3093.         
    3094. 

  3094.         foreach($this->settings['taxonomies_readonly_config'] as $tx=>$translate){
    3095. 

  3095.             if($translate && !in_array($tx, $taxs) && isset($wp_taxonomies[$tx]) && in_array($object_type, $wp_taxonomies[$tx]->object_type)){
    3096. 

  3096.                 $taxs[] = $tx;
    3097. 

  3097.             }
    3098. 

  3098.         }        
    3099. 

  3099.         
    3100. 

  3100.         $ret = array('taxs'=>$taxs, 'object_type'=>$taxs_obj_type['object_type']);
    3101. 

  3101.         
    3102. 

  3102.         return $ret;
    3103. 

  3103.     }
    3104. 

  3104.     
    3105. 

  3105.     function load_plugins_wpml_config(){
    3106. 

  3106.         $plugins = get_option('active_plugins');
    3107. 

  3107.         foreach($plugins as $p){
    3108. 

  3108.             $config_file = ABSPATH . '/' . PLUGINDIR . '/' . dirname($p) . '/wpml-config.xml';
    3109. 

  3109.             if(trim(dirname($p),'\/.') && file_exists($config_file)){
    3110. 

  3110.                 $this->_parse_wpml_config($config_file);
    3111. 

  3111.             }
    3112. 

  3112.         }
    3113. 

  3113.         
    3114. 

  3114.         $mu_plugins = wp_get_mu_plugins();
    3115. 

  3115.         if(!empty($mu_plugins)){
    3116. 

  3116.             foreach($mu_plugins as $mup){
    3117. 

  3117.                 if(rtrim(dirname($mup), '/') != WPMU_PLUGIN_DIR){
    3118. 

  3118.                     $config_file = dirname($mup) . '/wpml-config.xml';                         
    3119. 

  3119.                     $this->_parse_wpml_config($config_file);
    3120. 

  3120.                 }
    3121. 

  3121.             }
    3122. 

  3122.         }        
    3123. 

  3123.     }    
    3124. 

  3124. 

  3125.     function load_theme_wpml_config(){
    3126. 

  3126.         if(get_template_directory() != get_stylesheet_directory()){
    3127. 

  3127.             $config_file = get_stylesheet_directory().'/wpml-config.xml';
    3128. 

  3128.             if(file_exists($config_file)){
    3129. 

  3129.                 $this->_parse_wpml_config($config_file);
    3130. 

  3130.             }
    3131. 

  3131.         }
    3132. 

  3132. 

  3133.         $config_file = get_template_directory().'/wpml-config.xml';
    3134. 

  3134.         if(file_exists($config_file)){
    3135. 

  3135.             $this->_parse_wpml_config($config_file);
    3136. 

  3136.         }
    3137. 

  3137.         
    3138. 

  3138.         
    3139. 

  3139.     }
    3140. 

  3140. 

  3141.     function load_config_pre_process(){
    3142. 

  3142.         $this->settings['__custom_types_readonly_config_prev'] = (isset($this->settings['custom_types_readonly_config']) && is_array($this->settings['custom_types_readonly_config'])) ? $this->settings['custom_types_readonly_config'] : array();
    3143. 

  3143.         $this->settings['custom_types_readonly_config'] = array();
    3144. 

  3144.         
    3145. 

  3145.         $this->settings['__custom_fields_readonly_config_prev'] = (isset($this->settings['custom_fields_readonly_config']) && is_array($this->settings['custom_fields_readonly_config'])) ? $this->settings['custom_fields_readonly_config'] : array();
    3146. 

  3146.         $this->settings['custom_fields_readonly_config'] = array();
    3147. 

  3147.         
    3148. 

  3148.     }
    3149. 

  3149.     
    3150. 

  3150.     function load_config_post_process(){
    3151. 

  3151. 

  3152.         $changed = false;
    3153. 

  3153.         foreach($this->settings['__custom_types_readonly_config_prev'] as $pk=>$pv){
    3154. 

  3154.             if(!isset($this->settings['custom_types_readonly_config'][$pk]) || $this->settings['custom_types_readonly_config'][$pk] != $pv){
    3155. 

  3155.                 $changed = true;
    3156. 

  3156.                 break;
    3157. 

  3157.             }                        
    3158. 

  3158.         }
    3159. 

  3159.         foreach($this->settings['custom_types_readonly_config'] as $pk=>$pv){
    3160. 

  3160.             if(!isset($this->settings['__custom_types_readonly_config_prev'][$pk]) || $this->settings['__custom_types_readonly_config_prev'][$pk] != $pv){
    3161. 

  3161.                 $changed = true;
    3162. 

  3162.                 break;
    3163. 

  3163.             }                        
    3164. 

  3164.         }
    3165. 

  3165.         
    3166. 

  3166.         foreach($this->settings['__custom_fields_readonly_config_prev'] as $cf){
    3167. 

  3167.             if(!in_array($cf, $this->settings['custom_fields_readonly_config'])){
    3168. 

  3168.                 $changed = true;
    3169. 

  3169.                 break;
    3170. 

  3170.             }                        
    3171. 

  3171.         }
    3172. 

  3172.         foreach($this->settings['custom_fields_readonly_config'] as $cf){          
    3173. 

  3173.             if(!in_array($cf, $this->settings['__custom_fields_readonly_config_prev'])){
    3174. 

  3174.                 $changed = true;
    3175. 

  3175.                 break;
    3176. 

  3176.             }                        
    3177. 

  3177.         }
    3178. 

  3178.         
    3179. 

  3179.         if($changed){
    3180. 

  3180.             $this->save_settings();    
    3181. 

  3181.         }
    3182. 

  3182.         
    3183. 

  3183.         
    3184. 

  3184.     }
    3185. 

  3185.     
    3186. 

  3186.     public static function icanlocalize_service_info($info = array()) {
    3187. 

  3187.         global $sitepress;
    3188. 

  3188.         $return = array();
    3189. 

  3189.         $return['name'] = 'ICanLocalize';
    3190. 

  3190.         $return['logo'] = ICL_PLUGIN_URL . '/res/img/web_logo_small.png';
    3191. 

  3191.         $return['setup_url'] = $sitepress->create_icl_popup_link('@select-translators;from_replace;to_replace@', array('ar' => 1), true);
    3192. 

  3192.         $return['description'] = __('Looking for a quality translation service? ICanLocalize offers excellent<br /> human service done by expert translators, starts at only $0.09 per word.', 'sitepress');
    3193. 

  3193.         $info['icanlocalize'] = $return;
    3194. 

  3194.         return $info;
    3195. 

  3195.     }
    3196. 

  3196. 

  3197.     public function clear_cache() {
    3198. 

  3198.         global $wpdb;
    3199. 

  3199.         delete_option($wpdb->prefix . 'icl_translators_cached');
    3200. 

  3200.         delete_option($wpdb->prefix . 'icl_non_translators_cached');
    3201. 

  3201.     }
    3202. 

  3202.     
    3203. 

  3203.     // shows post content for visual mode (iframe) in translation editor
    3204. 

  3204.     function _show_post_content(){
    3205. 

  3205.         global $tinymce_version;
    3206. 

  3206.         if($id = @intval($_GET['post_id'])){
    3207. 

  3207.             $post = get_post($id);
    3208. 

  3208.             if($post){
    3209. 

  3209.                 if(@intval($_GET['rtl'])){
    3210. 

  3210.                     $rtl = ' dir="rtl"';
    3211. 

  3211.                 }else{
    3212. 

  3212.                     $rtl = '';
    3213. 

  3213.                 }
    3214. 

  3214.                 echo '<html'.$rtl.'>';
    3215. 

  3215.                 echo '<head>';
    3216. 

  3216.                 $csss = array(
    3217. 

  3217.                     '/' . WPINC . '/js/tinymce/themes/advanced/skins/wp_theme/content.css?ver='.$tinymce_version,
    3218. 

  3218.                     '/' . WPINC . '/js/tinymce/plugins/spellchecker/css/content.css?ver='.$tinymce_version,
    3219. 

  3219.                     '/' . WPINC . '/js/tinymce/plugins/wordpress/css/content.css?ver='.$tinymce_version    
    3220. 

  3220.                 );
    3221. 

  3221.                 foreach($csss as $css){
    3222. 

  3222.                     echo '<link rel="stylesheet" href="'.get_option('siteurl') . $css . '">' . "\n";
    3223. 

  3223.                 }
    3224. 

  3224.                 echo '</head>';
    3225. 

  3225.                 echo '<body>';
    3226. 

  3226.                 switch($_GET['field_type']){                    
    3227. 

  3227.                     default: 
    3228. 

  3228.                         if(0 === strpos($_GET['field_type'], 'field-')){
    3229. 

  3229.                             echo get_post_meta($id, preg_replace('#^field-#', '', $_GET['field_type']), true);
    3230. 

  3230.                         }else{
    3231. 

  3231.                             remove_filter('the_content', 'do_shortcode', 11);
    3232. 

  3232.                             echo apply_filters('the_content', $post->post_content);
    3233. 

  3233.                         }
    3234. 

  3234.                 }
    3235. 

  3235.                 echo '</body>';
    3236. 

  3236.                 echo '</html>';
    3237. 

  3237.                 exit;
    3238. 

  3238.             }else{
    3239. 

  3239.                 wp_die(__('Post not found!', 'sitepress'));
    3240. 

  3240.             }
    3241. 

  3241.             exit;
    3242. 

  3242.         }else{
    3243. 

  3243.             wp_die(__('Post not found!', 'sitepress'));
    3244. 

  3244.         }
    3245. 

  3245.     }
    3246. 

  3246.     
    3247. 

  3247.     function _user_search(){
    3248. 

  3248.         $q = $_POST['q'];
    3249. 

  3249.         
    3250. 

  3250.         $non_translators = $this->get_blog_not_translators();
    3251. 

  3251.         
    3252. 

  3252.         $matched_users = array();
    3253. 

  3253.         foreach($non_translators as $t){
    3254. 

  3254.             if(false !== stripos($t->user_login, $q) || false !== stripos($t->display_name, $q)){
    3255. 

  3255.                 $matched_users[] = $t;        
    3256. 

  3256.             }
    3257. 

  3257.             if(count($matched_users) == 100) break;
    3258. 

  3258.         }
    3259. 

  3259.         
    3260. 

  3260.         if(!empty($matched_users)){
    3261. 

  3261.             $cssheight  = count($matched_users) > 10 ? '200' : 20*count($matched_users) + 5;
    3262. 

  3262.             echo '<select size="10" class="icl_tm_auto_suggest_dd" style="height:'.$cssheight.'px">';
    3263. 

  3263.             foreach($matched_users as $u){
    3264. 

  3264.                 echo '<option value="' . $u->ID . '|' . esc_attr($u->display_name).'">'.$u->display_name . ' ('.$u->user_login.')'.'</option>';
    3265. 

  3265.             
    3266. 

  3266.             }
    3267. 

  3267.             echo '</select>';
    3268. 

  3268.             
    3269. 

  3269.         }else{
    3270. 

  3270.             echo '&nbsp;<span id="icl_user_src_nf">';
    3271. 

  3271.             _e('No matches', 'sitepress');
    3272. 

  3272.             echo '</span>';
    3273. 

  3273.         }
    3274. 

  3274.         
    3275. 

  3275.         
    3276. 

  3276.         exit;
    3277. 

  3277.         
    3278. 

  3278.     }
    3279. 

  3279.     
    3280. 

  3280.     function make_duplicates($data){
    3281. 

  3281.         foreach($data['iclpost'] as $master_post_id){
    3282. 

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

  3283.                 $this->make_duplicate($master_post_id, $lang);                        
    3284. 

  3284.             }
    3285. 

  3285.         }
    3286. 

  3286.     }
    3287. 

  3287.     
    3288. 

  3288.     function make_duplicate($master_post_id, $lang){
    3289. 

  3289.         global $sitepress, $wpdb;
    3290. 

  3290.         
    3291. 

  3291.         $master_post = get_post($master_post_id);
    3292. 

  3292.         
    3293. 

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

  3294.         if($trid){
    3295. 

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

  3296.             
    3297. 

  3297.             if(isset($translations[$lang])){
    3298. 

  3298.                 $postarr['ID'] = $translations[$lang]->element_id;    
    3299. 

  3299.             }
    3300. 

  3300.             
    3301. 

  3301.         }
    3302. 

  3302.         
    3303. 

  3303.         $postarr['post_author']     = $master_post->post_author; 
    3304. 

  3304.         $postarr['post_date']       = $master_post->post_date; 
    3305. 

  3305.         $postarr['post_date_gmt']   = $master_post->post_date_gmt; 
    3306. 

  3306.         $postarr['post_content']    = $master_post->post_content; 
    3307. 

  3307.         $postarr['post_title']      = $master_post->post_title;
    3308. 

  3308.         $postarr['post_excerpt']    = $master_post->post_excerpt;
    3309. 

  3309.         $postarr['post_status']     = $master_post->post_status;
    3310. 

  3310.         $postarr['comment_status']  = $master_post->comment_status;
    3311. 

  3311.         $postarr['ping_status']     = $master_post->ping_status;
    3312. 

  3312.         $postarr['post_name']       = $master_post->post_name;
    3313. 

  3313.         
    3314. 

  3314.         if($master_post->post_parent){
    3315. 

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

  3316.             $postarr['post_parent']     = $parent;
    3317. 

  3317.         }
    3318. 

  3318.         
    3319. 

  3319.         $postarr['menu_order']     = $master_post->menu_order;
    3320. 

  3320.         $postarr['post_type']      = $master_post->post_type;
    3321. 

  3321.         $postarr['post_mime_type'] = $master_post->post_mime_type;
    3322. 

  3322. 

  3323.         
    3324. 

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

  3325.                 
    3326. 

  3326.         $_POST['icl_trid'] = $trid;
    3327. 

  3327.         $_POST['icl_post_language'] = $lang;
    3328. 

  3328.         $_POST['skip_sitepress_actions'] = true;
    3329. 

  3329.         
    3330. 

  3330.         if(isset($postarr['ID'])){
    3331. 

  3331.             $id = wp_update_post($postarr);
    3332. 

  3332.         }else{
    3333. 

  3333.             $id = wp_insert_post($postarr);
    3334. 

  3334.         }
    3335. 

  3335.         
    3336. 

  3336.         if(!is_wp_error($id)){
    3337. 

  3337.             
    3338. 

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

  3339.             
    3340. 

  3340.             $this->save_post_actions($id, get_post($id), $force_set_status = ICL_TM_DUPLICATE);
    3341. 

  3341. 

  3342.             // dup comments
    3343. 

  3343.             if($sitepress->get_option('sync_comments_on_duplicates')){
    3344. 

  3344.                 $this->duplicate_comments($id, $master_post->ID);    
    3345. 

  3345.             }
    3346. 

  3346.             
    3347. 

  3347.             // make sure post name is copied
    3348. 

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

  3349.             
    3350. 

  3350.             update_post_meta($id, '_icl_lang_duplicate_of', $master_post->ID);
    3351. 

  3351.                         
    3352. 

  3352.             // copy custom fields
    3353. 

  3353.             $custom_fields = get_post_custom($master_post_id);
    3354. 

  3354.             foreach($custom_fields as $key => $values){
    3355. 

  3355.                 
    3356. 

  3356.                 // skip some
    3357. 

  3357.                 if(in_array($key, array('_wp_old_slug', '_edit_last', '_edit_lock', '_icl_translator_note'))) continue;
    3358. 

  3358.                 
    3359. 

  3359.                 delete_post_meta($id, $key);        
    3360. 

  3360.                 foreach($values as $value){
    3361. 

  3361.                     add_post_meta($id, $key, $value);        
    3362. 

  3362.                 }
    3363. 

  3363.                 
    3364. 

  3364.             }
    3365. 

  3365.             
    3366. 

  3366.             // sync taxonomies
    3367. 

  3367.             $taxonomies = array_values(get_taxonomies());
    3368. 

  3368.             //exclude_some
    3369. 

  3369.             $taxonomies = array_diff($taxonomies, array('nav_menu', 'link_category'));
    3370. 

  3370.             
    3371. 

  3371.             foreach($taxonomies as $taxonomy){
    3372. 

  3372.                 $is_translated = $sitepress->is_translated_taxonomy($taxonomy);
    3373. 

  3373.                 $terms = wp_get_post_terms($master_post_id, $taxonomy);            
    3374. 

  3374.                 if(!empty($terms)){
    3375. 

  3375.                     $terms_array = array();
    3376. 

  3376.                     foreach($terms as $t){
    3377. 

  3377.                         if($is_translated){
    3378. 

  3378.                             $tr_id = icl_object_id($t->term_id, $taxonomy, false, $lang);
    3379. 

  3379.                             if($tr_id){                                
    3380. 

  3380.                                 if(is_taxonomy_hierarchical($taxonomy)){
    3381. 

  3381.                                     $terms_array[] = $tr_id;
    3382. 

  3382.                                 }else{
    3383. 

  3383.                                     $tr_term = get_term($tr_id, $taxonomy);
    3384. 

  3384.                                     $terms_array[] = $tr_term->name;                                    
    3385. 

  3385.                                 }
    3386. 

  3386.                             }
    3387. 

  3387.                         }else{
    3388. 

  3388.                             if(is_taxonomy_hierarchical($taxonomy)){
    3389. 

  3389.                                 $terms_array[] = $t->term_id;                                        
    3390. 

  3390.                             }else{
    3391. 

  3391.                                 $terms_array[] = $t->name;        
    3392. 

  3392.                             }
    3393. 

  3393.                         }
    3394. 

  3394.                     } 
    3395. 

  3395.                     wp_set_post_terms($id, $terms_array, $taxonomy);
    3396. 

  3396.                 }
    3397. 

  3397.             }
    3398. 

  3398.             $ret = $id;
    3399. 

  3399.             do_action('icl_make_duplicate', $master_post_id, $lang, $postarr, $id);
    3400. 

  3400.             
    3401. 

  3401.         }else{
    3402. 

  3402.             $ret = false;
    3403. 

  3403.         }
    3404. 

  3404.         
    3405. 

  3405.         
    3406. 

  3406.         
    3407. 

  3407.         return $ret;
    3408. 

  3408.         
    3409. 

  3409.     }
    3410. 

  3410.     
    3411. 

  3411.     function make_duplicates_all($master_post_id){
    3412. 

  3412.         global $sitepress;
    3413. 

  3413.         
    3414. 

  3414.         $master_post = get_post($master_post_id);
    3415. 

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

  3416.         
    3417. 

  3417.         $data['iclpost'] = array($master_post_id);
    3418. 

  3418.         foreach($sitepress->get_active_languages() as $lang => $details){
    3419. 

  3419.             if($lang != $language_details_original->language_code){
    3420. 

  3420.                 $data['duplicate_to'][$lang] = 1;       
    3421. 

  3421.             }
    3422. 

  3422.         }
    3423. 

  3423.         
    3424. 

  3424.         $this->make_duplicates($data);
    3425. 

  3425.     }
    3426. 

  3426.     
    3427. 

  3427.     function reset_duplicate_flag($post_id){
    3428. 

  3428.         global $sitepress;
    3429. 

  3429. 

  3430.         $post = get_post($post_id);
    3431. 

  3431.         
    3432. 

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

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

  3434.         
    3435. 

  3435.         foreach($translations as $tr){
    3436. 

  3436.             if($tr->element_id == $post_id){
    3437. 

  3437.                 $this->update_translation_status(array(
    3438. 

  3438.                     'translation_id' => $tr->translation_id,
    3439. 

  3439.                     'status'         => ICL_TM_COMPLETE
    3440. 

  3440.                 ));
    3441. 

  3441.             }
    3442. 

  3442.         }
    3443. 

  3443.         
    3444. 

  3444.         delete_post_meta($post_id, '_icl_lang_duplicate_of');        
    3445. 

  3445.         
    3446. 

  3446.         
    3447. 

  3447.     }
    3448. 

  3448.     
    3449. 

  3449.     function set_duplicate($post_id){
    3450. 

  3450.         global $sitepress;
    3451. 

  3451.         // find original (source) and copy
    3452. 

  3452.         $post = get_post($post_id);
    3453. 

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

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

  3455.         
    3456. 

  3456.         foreach($translations as $lang => $tr){
    3457. 

  3457.             if($tr->original){
    3458. 

  3458.                 $master_post_id = $tr->element_id;
    3459. 

  3459.             }elseif($tr->element_id == $post_id){
    3460. 

  3460.                 $this_language = $lang;
    3461. 

  3461.             }
    3462. 

  3462.         }
    3463. 

  3463.         
    3464. 

  3464.         $this->make_duplicate($master_post_id, $this_language);
    3465. 

  3465.         
    3466. 

  3466.     }
    3467. 

  3467.     
    3468. 

  3468.     function get_duplicates($master_post_id){
    3469. 

  3469.         global $wpdb, $sitepress;
    3470. 

  3470.         
    3471. 

  3471.         $duplicates = array();
    3472. 

  3472.         
    3473. 

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

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

  3475.             
    3476. 

  3476.         foreach($res as $post_id){
    3477. 

  3477.             
    3478. 

  3478.             $post = get_post($post_id);
    3479. 

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

  3480.             
    3481. 

  3481.             $duplicates[$language_details->language_code] = $post_id;
    3482. 

  3482.         }
    3483. 

  3483.         
    3484. 

  3484.         return $duplicates;
    3485. 

  3485.         
    3486. 

  3486.     }
    3487. 

  3487.     
    3488. 

  3488.     function duplicate_comments($post_id, $master_post_id){
    3489. 

  3489.         global $wpdb, $sitepress;
    3490. 

  3490.         
    3491. 

  3491.         // delete existing comments
    3492. 

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

  3493.         foreach($current_comments as $id){
    3494. 

  3494.             wp_delete_comment($id);
    3495. 

  3495.         }
    3496. 

  3496.         
    3497. 

  3497.         
    3498. 

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

  3499.         
    3500. 

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

  3501.         $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));
    3502. 

  3502. 

  3503.         $wpdb->update($wpdb->posts, array('post_count'=>count($original_comments)), array('ID'=>$post_id));        
    3504. 

  3504.     
    3505. 

  3505.         foreach($original_comments as $comment){
    3506. 

  3506.             
    3507. 

  3507.             $original_comment_id = $comment['comment_ID'];
    3508. 

  3508.             unset($comment['comment_ID']);
    3509. 

  3509.             
    3510. 

  3510.             $comment['comment_post_ID'] = $post_id;
    3511. 

  3511.             $wpdb->insert($wpdb->comments, $comment);
    3512. 

  3512.             $comment_id = $wpdb->insert_id;
    3513. 

  3513.             
    3514. 

  3514.             update_comment_meta($comment_id, '_icl_duplicate_of', $original_comment_id);
    3515. 

  3515.             
    3516. 

  3516.             // comment meta
    3517. 

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

  3518.             foreach($meta as $key => $val){
    3519. 

  3519.                 $wpdb->insert($wpdb->commentmeta, array(
    3520. 

  3520.                     'comment_id'    => $comment_id,
    3521. 

  3521.                     'meta_key'      => $key,  
    3522. 

  3522.                     'meta_value'    => $val 
    3523. 

  3523.                 ));
    3524. 

  3524.             }
    3525. 

  3525.             
    3526. 

  3526.             $original_comment_tr = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", 
    3527. 

  3527.                 $original_comment_id, 'comment'));
    3528. 

  3528.             
    3529. 

  3529.             $comment_translation = array(
    3530. 

  3530.                 'element_type'          => 'comment',
    3531. 

  3531.                 'element_id'            => $comment_id,
    3532. 

  3532.                 'trid'                  => $original_comment_tr->trid,
    3533. 

  3533.                 'language_code'         => $language,
    3534. 

  3534.                 /*'source_language_code'  => $original_comment_tr->language_code */
    3535. 

  3535.             );
    3536. 

  3536.             
    3537. 

  3537.             
    3538. 

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

  3539.             
    3540. 

  3540.             $wpdb->insert($wpdb->prefix . 'icl_translations', $comment_translation); 
    3541. 

  3541.             
    3542. 

  3542.         }
    3543. 

  3543.         
    3544. 

  3544.         // sync parents
    3545. 

  3545.         foreach($original_comments as $comment){
    3546. 

  3546.             if($comment['comment_parent']){
    3547. 

  3547.                 
    3548. 

  3548.                 $tr_comment_id = $comments_map[$comment['comment_ID']]['comment']; 
    3549. 

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

  3550.                 if($tr_parent){
    3551. 

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

  3552.                 }
    3553. 

  3553.                                        
    3554. 

  3554.             }
    3555. 

  3555.         }
    3556. 

  3556.          
    3557. 

  3557.                 
    3558. 

  3558.     }
    3559. 

  3559.     
    3560. 

  3560.     function duplication_delete_comment($comment_id){
    3561. 

  3561.         global $wpdb;
    3562. 

  3562.         static $_avoid_8_loop;
    3563. 

  3563.         
    3564. 

  3564.         if(isset($_avoid_8_loop)) return;
    3565. 

  3565.         $_avoid_8_loop = true;
    3566. 

  3566.         
    3567. 

  3567.         $original_comment = get_comment_meta($comment_id, '_icl_duplicate_of', true);        
    3568. 

  3568.         if($original_comment){
    3569. 

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

  3570.             $duplicates = array($original_comment) + array_diff($duplicates, array($comment_id));
    3571. 

  3571.             foreach($duplicates as $dup){
    3572. 

  3572.                 wp_delete_comment($dup);
    3573. 

  3573.             }
    3574. 

  3574.         }else{
    3575. 

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

  3576.             if($duplicates){
    3577. 

  3577.                 foreach($duplicates as $dup){
    3578. 

  3578.                     wp_delete_comment($dup);
    3579. 

  3579.                 }
    3580. 

  3580.             }
    3581. 

  3581.         }
    3582. 

  3582.         
    3583. 

  3583.         unset($_avoid_8_loop);
    3584. 

  3584.     }
    3585. 

  3585.     
    3586. 

  3586.     function duplication_edit_comment($comment_id){
    3587. 

  3587.         global $wpdb;
    3588. 

  3588.         
    3589. 

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

  3590.         unset($comment['comment_ID'], $comment['comment_post_ID']);
    3591. 

  3591.         
    3592. 

  3592.         $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));
    3593. 

  3593.         
    3594. 

  3594.         $original_comment = get_comment_meta($comment_id, '_icl_duplicate_of', true);        
    3595. 

  3595.         if($original_comment){
    3596. 

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

  3597.             $duplicates = array($original_comment) + array_diff($duplicates, array($comment_id));
    3598. 

  3598.         }else{
    3599. 

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

  3600.         }                
    3601. 

  3601.         
    3602. 

  3602.         if(!empty($duplicates)){
    3603. 

  3603.             foreach($duplicates as $dup){
    3604. 

  3604.                 
    3605. 

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

  3606. 

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

  3608.                 
    3609. 

  3609.                 if($comment_meta){
    3610. 

  3610.                     foreach($comment_meta as $key => $value){
    3611. 

  3611.                         update_comment_meta($dup, $meta_key, $meta_value);
    3612. 

  3612.                     }
    3613. 

  3613.                 }
    3614. 

  3614.                 
    3615. 

  3615.             }
    3616. 

  3616.         }
    3617. 

  3617.         
    3618. 

  3618.             
    3619. 

  3619.     }
    3620. 

  3620.     
    3621. 

  3621.     function duplication_status_comment($comment_id, $comment_status){
    3622. 

  3622.         global $wpdb;
    3623. 

  3623.         
    3624. 

  3624.         static $_avoid_8_loop;
    3625. 

  3625.         
    3626. 

  3626.         if(isset($_avoid_8_loop)) return;
    3627. 

  3627.         $_avoid_8_loop = true;
    3628. 

  3628.         
    3629. 

  3629.                 
    3630. 

  3630.         $original_comment = get_comment_meta($comment_id, '_icl_duplicate_of', true);        
    3631. 

  3631.         if($original_comment){
    3632. 

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

  3633.             $duplicates = array($original_comment) + array_diff($duplicates, array($comment_id));
    3634. 

  3634.         }else{
    3635. 

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

  3636.         }                
    3637. 

  3637.         
    3638. 

  3638.         if(!empty($duplicates)){
    3639. 

  3639.             foreach($duplicates as $dup){
    3640. 

  3640.                 wp_set_comment_status($t->element_id, $status);
    3641. 

  3641.             }
    3642. 

  3642.         }
    3643. 

  3643.         
    3644. 

  3644.         unset($_avoid_8_loop);
    3645. 

  3645.         
    3646. 

  3646.         
    3647. 

  3647.     }
    3648. 

  3648.     
    3649. 

  3649.     function duplication_insert_comment($comment_id){
    3650. 

  3650.         global $wpdb, $sitepress;
    3651. 

  3651.         
    3652. 

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

  3653.         
    3654. 

  3654.         // loop duplicate posts, add new comment
    3655. 

  3655.         $post_id = $comment['comment_post_ID'];
    3656. 

  3656.         
    3657. 

  3657.         // if this is a duplicate post
    3658. 

  3658.         $duplicate_of = get_post_meta($post_id, '_icl_lang_duplicate_of', true);
    3659. 

  3659.         if($duplicate_of){
    3660. 

  3660.             $post_duplicates = $this->get_duplicates($duplicate_of);    
    3661. 

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

  3662.             unset($post_duplicates[$_lang]);
    3663. 

  3663.             $_post = get_post($duplicate_of);
    3664. 

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

  3665.             $post_duplicates[$_orig_lang] = $duplicate_of;
    3666. 

  3666.         }else{
    3667. 

  3667.             $post_duplicates = $this->get_duplicates($post_id);    
    3668. 

  3668.         }
    3669. 

  3669.         
    3670. 

  3670.         unset($comment['comment_ID'], $comment['comment_post_ID']);
    3671. 

  3671.         
    3672. 

  3672.         foreach($post_duplicates as $lang => $dup_id){
    3673. 

  3673.             $comment['comment_post_ID'] = $dup_id;
    3674. 

  3674.             
    3675. 

  3675.             if($comment['comment_parent']){
    3676. 

  3676.                 $comment['comment_parent'] = icl_object_id($comment['comment_parent'], 'comment', false, $lang);
    3677. 

  3677.             }
    3678. 

  3678.             
    3679. 

  3679.             
    3680. 

  3680.             $wpdb->insert($wpdb->comments, $comment);
    3681. 

  3681.             
    3682. 

  3682.             $dup_comment_id = $wpdb->insert_id;
    3683. 

  3683.             
    3684. 

  3684.             update_comment_meta($dup_comment_id, '_icl_duplicate_of', $comment_id);
    3685. 

  3685.             
    3686. 

  3686.             // comment meta
    3687. 

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

  3688.             foreach($meta as $key => $val){
    3689. 

  3689.                 $wpdb->insert($wpdb->commentmeta, array(
    3690. 

  3690.                     'comment_id'    => $dup_comment_id,
    3691. 

  3691.                     'meta_key'      => $key,  
    3692. 

  3692.                     'meta_value'    => $val 
    3693. 

  3693.                 ));
    3694. 

  3694.             }
    3695. 

  3695.             
    3696. 

  3696.             $original_comment_tr = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type=%s", 
    3697. 

  3697.                 $comment_id, 'comment'));
    3698. 

  3698.             
    3699. 

  3699.             $comment_translation = array(
    3700. 

  3700.                 'element_type'          => 'comment',
    3701. 

  3701.                 'element_id'            => $dup_comment_id,
    3702. 

  3702.                 'trid'                  => $original_comment_tr->trid,
    3703. 

  3703.                 'language_code'         => $lang,
    3704. 

  3704.                 /*'source_language_code'  => $original_comment_tr->language_code */
    3705. 

  3705.             );
    3706. 

  3706.             
    3707. 

  3707.             $wpdb->insert($wpdb->prefix . 'icl_translations', $comment_translation);             
    3708. 

  3708.                         
    3709. 

  3709.         }
    3710. 

  3710.         
    3711. 

  3711.         
    3712. 

  3712.     }
    3713. 

  3713.     
    3714. 

  3714.     // set slug according to user preference
    3715. 

  3715.     static function set_page_url($post_id){
    3716. 

  3716.         
    3717. 

  3717.         global $sitepress, $sitepress_settings, $wpdb;
    3718. 

  3718.         
    3719. 

  3719.         if($sitepress_settings['translated_document_page_url'] == 'copy-encoded'){
    3720. 

  3720.         
    3721. 

  3721.             $post = $wpdb->get_row($wpdb->prepare("SELECT post_type FROM {$wpdb->posts} WHERE ID=%d", $post_id));                
    3722. 

  3722.             $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));
    3723. 

  3723.             
    3724. 

  3724.             $encode_url = $wpdb->get_var($wpdb->prepare("SELECT encode_url FROM {$wpdb->prefix}icl_languages WHERE code=%s", $translation_row->language_code));
    3725. 

  3725.             if($encode_url){
    3726. 

  3726.             
    3727. 

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

  3728.                 $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));
    3729. 

  3729.                 $post_name_original = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM {$wpdb->posts} WHERE ID = %d", $original_post_id));
    3730. 

  3730.             
    3731. 

  3731.                 $post_name_to_be = $post_name_original;
    3732. 

  3732.                 $taken = true;
    3733. 

  3733.                 $incr = 1;        
    3734. 

  3734.                 do{
    3735. 

  3735.                     $taken = $wpdb->get_var($wpdb->prepare("
    3736. 

  3736.                         SELECT ID FROM {$wpdb->posts} p  
    3737. 

  3737.                         JOIN {$wpdb->prefix}icl_translations t ON p.ID = t.element_id
    3738. 

  3738.                         WHERE ID <> %d AND t.element_type = %s AND t.language_code = %s AND p.post_name = %s
    3739. 

  3739.                         ", $post_id, 'post_' . $post->post_type, $translation_row->language_code, $post_name_to_be ));
    3740. 

  3740.                     if($taken){
    3741. 

  3741.                         $incr++;
    3742. 

  3742.                         $post_name_to_be = $post_name_original . '-' . $incr;
    3743. 

  3743.                     }else{
    3744. 

  3744.                         $taken = false;
    3745. 

  3745.                     }
    3746. 

  3746.                 }while($taken == true);
    3747. 

  3747.                 $wpdb->update($wpdb->posts, array('post_name' => $post_name_to_be), array('ID' => $post_id));
    3748. 

  3748.                 
    3749. 

  3749.             }
    3750. 

  3750.             
    3751. 

  3751.         }
    3752. 

  3752.         
    3753. 

  3753.     }
    3754. 

  3754.     
    3755. 

  3755.     
    3756. 

  3756. }
    3757. 

  3757.   
    3758. 

  3758. ?>
    3759. 

  3759.