PageRenderTime 73ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 1ms

/wp-content/plugins/wpml-string-translation/inc/functions.php

https://bitbucket.org/acipriani/madeinapulia.com
PHP | 2963 lines | 2343 code | 469 blank | 151 comment | 546 complexity | c25a6991b5a201f95a94d3a846626dd6 MD5 | raw file
Possible License(s): GPL-3.0, MIT, BSD-3-Clause, LGPL-2.1, GPL-2.0, Apache-2.0 
    

  1. <?php

    2. 

  2. 

    3. 

  3. $icl_st_string_translation_statuses = array(

    4. 

  4.     ICL_STRING_TRANSLATION_COMPLETE => __('Translation complete','wpml-string-translation'),

    5. 

  5.     ICL_STRING_TRANSLATION_PARTIAL => __('Partial translation','wpml-string-translation'),

    6. 

  6.     ICL_STRING_TRANSLATION_NEEDS_UPDATE => __('Translation needs update','wpml-string-translation'),

    7. 

  7.     ICL_STRING_TRANSLATION_NOT_TRANSLATED => __('Not translated','wpml-string-translation'),

    8. 

  8.     ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR => __('Waiting for translator','wpml-string-translation')

    9. 

  9. );

    10. 

  10. 

    11. 

  11. add_action('plugins_loaded', 'icl_st_init');

    12. 

  12. 

    13. 

  13. if(!defined('XMLRPC')){

    14. 

  14.     // called separately for XMLRPC post saves

    15. 

  15.     add_action('save_post', 'icl_st_fix_links_in_strings', 19);

    16. 

  16. }

    17. 

  17. 

    18. 

  18. //add_filter('xmlrpc_methods','icl_add_custom_xmlrpc_methods');

    19. 

  19. 

    20. 

  20. function icl_st_init(){                       

    21. 

  21.     global $sitepress_settings, $sitepress, $wpdb, $icl_st_err_str;

    22. 

  22. 

    23. 

  23.     if ( $GLOBALS['pagenow'] == 'site-new.php' && isset($_REQUEST['action']) && 'add-site' == $_REQUEST['action'] ) return;

    24. 

  24.     

    25. 

  25.     add_action('icl_update_active_languages', 'icl_update_string_status_all');

    26. 

  26.     add_action('update_option_blogname', 'icl_st_update_blogname_actions',5,2);

    27. 

  27.     add_action('update_option_blogdescription', 'icl_st_update_blogdescription_actions',5,2);

    28. 

  28. 

    29. 

  29.     if(isset($_GET['icl_action']) && $_GET['icl_action'] == 'view_string_in_page'){

    30. 

  30.         icl_st_string_in_page($_GET['string_id']);

    31. 

  31.         exit;

    32. 

  32.     }

    33. 

  33. 

    34. 

  34.     if(isset($_GET['icl_action']) && $_GET['icl_action'] == 'view_string_in_source'){

    35. 

  35.         icl_st_string_in_source($_GET['string_id']);

    36. 

  36.         exit;

    37. 

  37.     }

    38. 

  38.     

    39. 

  39.     if ( get_magic_quotes_gpc() && isset($_GET['page']) && $_GET['page'] == WPML_ST_FOLDER . '/menu/string-translation.php'){

    40. 

  40.         $_POST = stripslashes_deep( $_POST );         

    41. 

  41.     }

    42. 

  42.               

    43. 

  43.     if(!isset($sitepress_settings['existing_content_language_verified']) || !$sitepress_settings['existing_content_language_verified']){

    44. 

  44.         return;

    45. 

  45.     }          

    46. 

  46.     

    47. 

  47.     if(!isset($sitepress_settings['st']['sw'])){

    48. 

  48.         $sitepress_settings['st']['sw'] = array();  //no settings for now

    49. 

  49.         $sitepress->save_settings($sitepress_settings); 

    50. 

  50.         $init_all = true;

    51. 

  51.     }

    52. 

  52.     

    53. 

  53.     if(!isset($sitepress_settings['st']['strings_per_page'])){

    54. 

  54.         $sitepress_settings['st']['strings_per_page'] = 10;

    55. 

  55.         $sitepress->save_settings($sitepress_settings); 

    56. 

  56.     }elseif(isset($_GET['strings_per_page']) && $_GET['strings_per_page'] > 0){

    57. 

  57.         $sitepress_settings['st']['strings_per_page'] = $_GET['strings_per_page'];

    58. 

  58.         $sitepress->save_settings($sitepress_settings); 

    59. 

  59.     }

    60. 

  60.     if(!isset($sitepress_settings['st']['icl_st_auto_reg'])){

    61. 

  61.         $sitepress_settings['st']['icl_st_auto_reg'] = 'disable';

    62. 

  62.         $sitepress->save_settings($sitepress_settings); 

    63. 

  63.     }

    64. 

  64.     if(empty($sitepress_settings['st']['strings_language'])){

    65. 

  65.         $iclsettings['st']['strings_language'] = $sitepress_settings['st']['strings_language'] = 'en';

    66. 

  66.         $sitepress->save_settings($iclsettings);

    67. 

  67.     }

    68. 

  68.     

    69. 

  69.     if(!isset($sitepress_settings['st']['translated-users'])) $sitepress_settings['st']['translated-users'] = array();

    70. 

  70.     

    71. 

  71.     if((isset($_POST['iclt_st_sw_save']) && wp_verify_nonce($_POST['_wpnonce'], 'icl_sw_form')) || isset($init_all)){

    72. 

  72.             if(isset($init_all)){

    73. 

  73.                 

    74. 

  74.                 icl_register_string('WP',__('Blog Title','wpml-string-translation'), get_option('blogname'));

    75. 

  75.                 icl_register_string('WP',__('Tagline', 'wpml-string-translation'), get_option('blogdescription'));

    76. 

  76. 

    77. 

  77.                 __icl_st_init_register_widget_titles();

    78. 

  78.                 

    79. 

  79.                 // create a list of active widgets

    80. 

  80.                 $active_text_widgets = array();

    81. 

  81.                 $widgets = (array)get_option('sidebars_widgets');

    82. 

  82.                 foreach($widgets as $k=>$w){             

    83. 

  83.                     if('wp_inactive_widgets' != $k && $k != 'array_version'){

    84. 

  84.                         if(is_array($widgets[$k])){

    85. 

  85.                             foreach($widgets[$k] as $v){

    86. 

  86.                                 if(preg_match('#text-([0-9]+)#i',$v, $matches)){

    87. 

  87.                                     $active_text_widgets[] = $matches[1];

    88. 

  88.                                 }                            

    89. 

  89.                             }

    90. 

  90.                         }

    91. 

  91.                     }

    92. 

  92.                 }

    93. 

  93.                                                                 

    94. 

  94.                 $widget_text = get_option('widget_text');

    95. 

  95.                 if(is_array($widget_text)){

    96. 

  96.                     foreach($widget_text as $k=>$w){

    97. 

  97.                         if(!empty($w) && isset($w['title']) && in_array($k, $active_text_widgets)){

    98. 

  98.                             icl_register_string('Widgets', 'widget body - ' . md5($w['text']), $w['text']);

    99. 

  99.                         }

    100. 

  100.                     }

    101. 

  101.                 }

    102. 

  102.             }  

    103. 

  103.                     

    104. 

  104.             if(isset($_POST['iclt_st_sw_save'])){

    105. 

  105.                 $updat_string_statuses = false;

    106. 

  106.                 $sitepress_settings['st']['sw'] = $_POST['icl_st_sw'];

    107. 

  107.                 if($sitepress_settings['st']['strings_language'] != $_POST['icl_st_sw']['strings_language']){

    108. 

  108.                     $updat_string_statuses = true;

    109. 

  109.                 }

    110. 

  110.                 $sitepress_settings['st']['strings_language'] = $_POST['icl_st_sw']['strings_language'];

    111. 

  111.                 $sitepress->save_settings($sitepress_settings); 

    112. 

  112.                                 

    113. 

  113.                 $wpdb->query($wpdb->prepare("UPDATE {$wpdb->prefix}icl_strings SET language=%s WHERE language <> %s", 

    114. 

  114.                     $sitepress_settings['st']['strings_language'], $sitepress_settings['st']['strings_language']));

    115. 

  115.                 

    116. 

  116.                 if($updat_string_statuses){

    117. 

  117.                     icl_update_string_status_all();

    118. 

  118.                 }

    119. 

  119.                 

    120. 

  120.                 

    121. 

  121.                 //register author strings                

    122. 

  122.                 if(!empty($sitepress_settings['st']['translated-users'])){

    123. 

  123.                     icl_st_register_user_strings_all();

    124. 

  124.                 }

    125. 

  125.                 

    126. 

  126.                 wp_redirect(admin_url('admin.php?page='. WPML_ST_FOLDER .'/menu/string-translation.php&updated=true'));

    127. 

  127.             }

    128. 

  128.             

    129. 

  129.     }

    130. 

  130. 

    131. 

  131. 	// handle po file upload

    132. 

  132. 	if ( isset( $_POST[ 'icl_po_upload' ] ) && wp_verify_nonce( $_POST[ '_wpnonce' ], 'icl_po_form' ) ) {

    133. 

  133. 		global $icl_st_po_strings;

    134. 

  134. 

    135. 

  135. 		if ( $_FILES[ 'icl_po_file' ][ 'size' ] == 0 ) {

    136. 

  136. 			$icl_st_err_str = __( 'File upload error', 'wpml-string-translation' );

    137. 

  137. 		} else {

    138. 

  138. 			$lines             = file( $_FILES[ 'icl_po_file' ][ 'tmp_name' ] );

    139. 

  139. 			$icl_st_po_strings = array();

    140. 

  140. 

    141. 

  141. 			$fuzzy = 0;

    142. 

  142. 			for ( $k = 0; $k < count( $lines ); $k ++ ) {

    143. 

  143. 				$date_time_flag = false;

    144. 

  144. 				if ( 0 === strpos( $lines[ $k ], '#, fuzzy' ) ) {

    145. 

  145. 					$fuzzy = 1;

    146. 

  146. 					$k ++;

    147. 

  147. 				}

    148. 

  148. 				$name = false;

    149. 

  149. 				if ( 0 === strpos( $lines[ $k ], '# wpml-name: ' ) ) {

    150. 

  150. 					$name = preg_replace( "/^# wpml-name: /i", '', trim( $lines[ $k ] ) );

    151. 

  151. 					$k ++;

    152. 

  152. 				}

    153. 

  153. 

    154. 

  154. 				if ( preg_match( '/msgctxt/', $lines[ $k ] ) ) { //we look for the line that poedit needs for unique identification of the string

    155. 

  155. 

    156. 

  156. 					if ( preg_match( '/wpmldatei18/', $lines[ $k ] ) ) { //if it contains the date_time setting we add the flag to escape the control structures in the date time placeholder string

    157. 

  157. 						$date_time_flag = true;

    158. 

  158. 					}

    159. 

  159. 					$k ++;

    160. 

  160. 				}

    161. 

  161. 				$int = preg_match( '#msgid "(.+)"#im', trim( $lines[ $k ] ), $matches );

    162. 

  162. 				if ( $int ) {

    163. 

  163. 					$string = str_replace( '\"', '"', $matches[ 1 ] );

    164. 

  164. 					$int    = preg_match( '#msgstr "(.+)"#im', trim( $lines[ $k + 1 ] ), $matches );

    165. 

  165. 					if ( $int ) {

    166. 

  166. 						$translation = str_replace( '\"', '"', $matches[ 1 ] );

    167. 

  167. 					} else {

    168. 

  168. 						$translation = "";

    169. 

  169. 					}

    170. 

  170. 

    171. 

  171. 					if ( $name === false ) {

    172. 

  172. 						$name = md5( $string );

    173. 

  173. 					}

    174. 

  174. 

    175. 

  175. 					$string_exists = $wpdb->get_var( "

    176. 

  176.                         SELECT id FROM {$wpdb->prefix}icl_strings 

    177. 

  177.                         WHERE context='" . esc_sql( $_POST[ 'icl_st_i_context_new' ] ? $_POST[ 'icl_st_i_context_new' ] : $_POST[ 'icl_st_i_context' ] ) . "'

    178. 

  178.                         AND name='" . $name . "'" );

    179. 

  179. 

    180. 

  180. 					if ( $date_time_flag ) {

    181. 

  181. 						$string      = str_replace( "\\\\", "\\", $string );

    182. 

  182. 						$translation = str_replace( "\\\\", "\\", $translation );

    183. 

  183. 						$name        = str_replace( "\\\\", "\\", $name );

    184. 

  184. 					}

    185. 

  185. 

    186. 

  186. 					$icl_st_po_strings[ ] = array(

    187. 

  187. 						'string'      => $string,

    188. 

  188. 						'translation' => $translation,

    189. 

  189. 						'name'        => $name,

    190. 

  190. 						'fuzzy'       => $fuzzy,

    191. 

  191. 						'exists'      => $string_exists

    192. 

  192. 					);

    193. 

  193. 					$k ++;

    194. 

  194. 				}

    195. 

  195. 				if ( ! trim( $lines[ $k ] ) ) {

    196. 

  196. 					$fuzzy = 0;

    197. 

  197. 				}

    198. 

  198. 			}

    199. 

  199. 			if ( empty( $icl_st_po_strings ) ) {

    200. 

  200. 				$icl_st_err_str = __( 'No string found', 'wpml-string-translation' );

    201. 

  201. 			}

    202. 

  202. 		}

    203. 

  203. 	} elseif ( isset( $_POST[ 'action' ] ) && 'icl_st_save_strings' == $_POST[ 'action' ] ) {

    204. 

  204. 		$arr = array_intersect_key( $_POST[ 'icl_strings' ], array_flip( $_POST[ 'icl_strings_selected' ] ) );

    205. 

  205. 		//$arr = array_map('html_entity_decode', $arr);

    206. 

  206. 		if ( isset( $_POST[ 'icl_st_po_language' ] ) ) {

    207. 

  207. 			$arr_t = array_intersect_key( $_POST[ 'icl_translations' ], array_flip( $_POST[ 'icl_strings_selected' ] ) );

    208. 

  208. 			$arr_f = array_intersect_key( $_POST[ 'icl_fuzzy' ], array_flip( $_POST[ 'icl_strings_selected' ] ) );

    209. 

  209. 			//$arr_t = array_map('html_entity_decode', $arr_t);

    210. 

  210. 		}

    211. 

  211. 

    212. 

  212. 		foreach ( $arr as $k => $string ) {

    213. 

  213. 

    214. 

  214. 			$name = isset( $_POST[ 'icl_name' ][ $k ] ) && $_POST[ 'icl_name' ][ $k ] ? $_POST[ 'icl_name' ][ $k ] : md5( $string );

    215. 

  215. 

    216. 

  216. 			$string_id = icl_register_string( $_POST[ 'icl_st_domain_name' ], $name, $string );

    217. 

  217. 			if ( $string_id && isset( $_POST[ 'icl_st_po_language' ] ) ) {

    218. 

  218. 				if ( $arr_t[ $k ] != "" ) {

    219. 

  219. 					if ( $arr_f[ $k ] ) {

    220. 

  220. 						$_status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    221. 

  221. 					} else {

    222. 

  222. 						$_status = ICL_STRING_TRANSLATION_COMPLETE;

    223. 

  223. 					}

    224. 

  224. 					icl_add_string_translation( $string_id, $_POST[ 'icl_st_po_language' ], $arr_t[ $k ], $_status );

    225. 

  225. 					icl_update_string_status( $string_id );

    226. 

  226. 				}

    227. 

  227. 			}

    228. 

  228. 		}

    229. 

  229. 	}

    230. 

  230.     

    231. 

  231.     //handle po export

    232. 

  232.     if(isset($_POST['icl_st_pie_e']) && wp_verify_nonce($_POST['_wpnonce'], 'icl_po_export')){

    233. 

  233.         //force some filters

    234. 

  234.         if(isset($_GET['status'])) unset($_GET['status']);

    235. 

  235.         $_GET['show_results']='all';

    236. 

  236.         if($_POST['icl_st_e_context']){

    237. 

  237.             $_GET['context'] = $_POST['icl_st_e_context'];

    238. 

  238.         }

    239. 

  239.                                                     

    240. 

  240.         $_GET['translation_language'] = $_POST['icl_st_e_language'];

    241. 

  241.         $strings = icl_get_string_translations();

    242. 

  242.         if(!empty($strings)){

    243. 

  243.             $po = icl_st_generate_po_file($strings, !isset($_POST['icl_st_pe_translations']));

    244. 

  244.         }else{

    245. 

  245.             $po = "";  

    246. 

  246.         }

    247. 

  247.         if(!isset($_POST['icl_st_pe_translations'])){

    248. 

  248.             $popot = 'pot';

    249. 

  249.             $poname = $_POST['icl_st_e_context'] ? urlencode($_POST['icl_st_e_context']) : 'all_context'; 

    250. 

  250.         }else{

    251. 

  251.             $popot = 'po';

    252. 

  252.             $poname = $_GET['translation_language'];

    253. 

  253.         }

    254. 

  254.         header("Content-Type: application/force-download");

    255. 

  255.         header("Content-Type: application/octet-stream");

    256. 

  256.         header("Content-Type: application/download");

    257. 

  257.         header("Content-Disposition: attachment; filename=".$poname.'.'.$popot.";");

    258. 

  258.         header("Content-Length: ". strlen($po));

    259. 

  259.         echo $po;

    260. 

  260.         exit(0);

    261. 

  261.     }

    262. 

  262.     

    263. 

  263.     // handle string translation request

    264. 

  264.     elseif(isset($_POST['icl_st_action']) && $_POST['icl_st_action'] == 'send_strings'){        

    265. 

  265.         

    266. 

  266.         if($_POST['iclnonce'] == wp_create_nonce('icl-string-translation')){

    267. 

  267.             $_POST = stripslashes_deep($_POST);

    268. 

  268.             $services = $_POST['service'];

    269. 

  269.             $string_ids = explode(',', $_POST['strings']);

    270. 

  270.             $translate_to = array();

    271. 

  271.             foreach($_POST['translate_to'] as $lang_to=>$one){

    272. 

  272.                 if(isset($services[$lang_to])){

    273. 

  273.                     $translate_to[$lang_to] = $services[$lang_to];

    274. 

  274.                 }

    275. 

  275.             }

    276. 

  276.             if(!empty($translate_to)){

    277. 

  277.                 icl_translation_send_strings($string_ids, $translate_to);

    278. 

  278.             }

    279. 

  279.         }        

    280. 

  280.     }

    281. 

  281.     

    282. 

  282.     

    283. 

  283.     // hook into blog title and tag line    

    284. 

  284.     add_filter('option_blogname', 'icl_sw_filters_blogname');

    285. 

  285.     add_filter('option_blogdescription', 'icl_sw_filters_blogdescription');        

    286. 

  286.     add_filter('widget_title', 'icl_sw_filters_widget_title', 0);  //highest priority

    287. 

  287.     add_filter('widget_text', 'icl_sw_filters_widget_text', 0); //highest priority

    288. 

  288.                          

    289. 

  289.     if(isset($sitepress_settings['theme_localization_type']) && $sitepress_settings['theme_localization_type']==1){

    290. 

  290.         add_filter('gettext', 'icl_sw_filters_gettext', 9, 3);

    291. 

  291.         add_filter('gettext_with_context', 'icl_sw_filters_gettext_with_context', 1, 4);

    292. 

  292.         add_filter('ngettext', 'icl_sw_filters_ngettext', 9, 5);

    293. 

  293.         add_filter('ngettext_with_context', 'icl_sw_filters_nxgettext', 9, 6);

    294. 

  294.     }

    295. 

  295.     

    296. 

  296.     $widget_groups = $wpdb->get_results("SELECT option_name, option_value FROM {$wpdb->options} WHERE option_name LIKE 'widget\\_%'");

    297. 

  297.     foreach($widget_groups as $w){

    298. 

  298.         add_action('update_option_' . $w->option_name, 'icl_st_update_widget_title_actions', 5, 2);

    299. 

  299.     }

    300. 

  300.     

    301. 

  301.     add_action('update_option_widget_text', 'icl_st_update_text_widgets_actions', 5, 2);

    302. 

  302.     add_action('update_option_sidebars_widgets', '__icl_st_init_register_widget_titles');

    303. 

  303.     

    304. 

  304.     if($icl_st_err_str){

    305. 

  305.         add_action('admin_notices', 'icl_st_admin_notices');

    306. 

  306.     }

    307. 

  307. 		if (isset($_REQUEST['string-translated']) && $_REQUEST['string-translated'] == true) {

    308. 

  308. 			add_action('admin_notices', 'icl_st_admin_notices_string_updated');

    309. 

  309. 		}

    310. 

  310.     

    311. 

  311.     add_filter('get_the_author_first_name', 'icl_st_author_first_name_filter', 10, 2);

    312. 

  312.     add_filter('get_the_author_last_name', 'icl_st_author_last_name_filter', 10, 2);

    313. 

  313.     add_filter('get_the_author_nickname', 'icl_st_author_nickname_filter', 10, 2);

    314. 

  314.     add_filter('get_the_author_description', 'icl_st_author_description_filter', 10, 2);

    315. 

  315.     add_filter('the_author', 'icl_st_author_displayname_filter', 10);

    316. 

  316.     

    317. 

  317. }

    318. 

  318. 

    319. 

  319. 

    320. 

  320. add_action('profile_update', 'icl_st_register_user_strings');

    321. 

  321. add_action('user_register', 'icl_st_register_user_strings');

    322. 

  322. 

    323. 

  323. function __icl_st_init_register_widget_titles(){

    324. 

  324.     global $wpdb;        

    325. 

  325.     

    326. 

  326.     // create a list of active widgets

    327. 

  327.     $active_widgets = array();

    328. 

  328.     $widgets = (array)get_option('sidebars_widgets');    

    329. 

  329.     

    330. 

  330.     foreach($widgets as $k=>$w){                     

    331. 

  331.         if('wp_inactive_widgets' != $k && $k != 'array_version'){

    332. 

  332.             if(is_array($widgets[$k]))

    333. 

  333.             foreach($widgets[$k] as $v){                

    334. 

  334.                 $active_widgets[] = $v;

    335. 

  335.             }

    336. 

  336.         }

    337. 

  337.     }                      

    338. 

  338.     foreach($active_widgets as $aw){        

    339. 

  339.         $int = preg_match('#-([0-9]+)$#i',$aw, $matches);

    340. 

  340.         if($int){

    341. 

  341.             $suffix = $matches[1];

    342. 

  342.         }else{

    343. 

  343.             $suffix = 1;

    344. 

  344.         }

    345. 

  345.         $name = preg_replace('#-[0-9]+#','',$aw);                

    346. 

  346.         //if($name == 'rss-links') $name = 'rss';

    347. 

  347.         

    348. 

  348.         //$w = $wpdb->get_row("SELECT option_name, option_value FROM {$wpdb->options} WHERE option_name = 'widget_{$name}'");

    349. 

  349.         //$value = unserialize($w->option_value);

    350. 

  350.         $value = get_option("widget_".$name);

    351. 

  351.         if(isset($value[$suffix]['title']) && $value[$suffix]['title']){

    352. 

  352.             $w_title = $value[$suffix]['title'];     

    353. 

  353.         }else{

    354. 

  354.             $w_title = __icl_get_default_widget_title($aw);

    355. 

  355.             $value[$suffix]['title'] = $w_title;

    356. 

  356.             update_option("widget_".$name, $value);

    357. 

  357.         }

    358. 

  358.         

    359. 

  359.         if($w_title){            

    360. 

  360.             icl_register_string('Widgets', 'widget title - ' . md5($w_title), $w_title);                                    

    361. 

  361.             

    362. 

  362.         }

    363. 

  363.     }    

    364. 

  364. }

    365. 

  365. 

    366. 

  366. function __icl_get_default_widget_title($id){

    367. 

  367.     if(preg_match('#archives(-[0-9]+)?$#i',$id)){                        

    368. 

  368.         $w_title = 'Archives';

    369. 

  369.     }elseif(preg_match('#categories(-[0-9]+)?$#i',$id)){

    370. 

  370.         $w_title = 'Categories';

    371. 

  371.     }elseif(preg_match('#calendar(-[0-9]+)?$#i',$id)){

    372. 

  372.         $w_title = 'Calendar';

    373. 

  373.     }elseif(preg_match('#links(-[0-9]+)?$#i',$id)){

    374. 

  374.         $w_title = 'Links';

    375. 

  375.     }elseif(preg_match('#meta(-[0-9]+)?$#i',$id)){

    376. 

  376.         $w_title = 'Meta';

    377. 

  377.     }elseif(preg_match('#pages(-[0-9]+)?$#i',$id)){

    378. 

  378.         $w_title = 'Pages';

    379. 

  379.     }elseif(preg_match('#recent-posts(-[0-9]+)?$#i',$id)){

    380. 

  380.         $w_title = 'Recent Posts';

    381. 

  381.     }elseif(preg_match('#recent-comments(-[0-9]+)?$#i',$id)){

    382. 

  382.         $w_title = 'Recent Comments';

    383. 

  383.     }elseif(preg_match('#rss-links(-[0-9]+)?$#i',$id)){

    384. 

  384.         $w_title = 'RSS';

    385. 

  385.     }elseif(preg_match('#search(-[0-9]+)?$#i',$id)){

    386. 

  386.         $w_title = 'Search';

    387. 

  387.     }elseif(preg_match('#tag-cloud(-[0-9]+)?$#i',$id)){

    388. 

  388.         $w_title = 'Tag Cloud';

    389. 

  389.     }else{

    390. 

  390.         $w_title = false;

    391. 

  391.     }  

    392. 

  392.     return $w_title;  

    393. 

  393. }

    394. 

  394. 

    395. 

  395. function icl_register_string($context, $name, $value, $allow_empty_value = false){    

    396. 

  396.     global $wpdb, $sitepress_settings;

    397. 

  397. 

    398. 

  398.     /* cpt slugs - do not register them when scanning themes and plugins

    399. 

  399.      * if name starting from 'URL slug: '

    400. 

  400.      * and context is different from 'WordPress'

    401. 

  401.      */

    402. 

  402.     if (substr($name, 0, 10) === 'URL slug: ' && 'WordPress' !== $context) {

    403. 

  403.         return false;

    404. 

  404.     }

    405. 

  405. 

    406. 

  406.     // if the default language is not set up return without doing anything

    407. 

  407.     if( 

    408. 

  408.         !isset($sitepress_settings['existing_content_language_verified']) || 

    409. 

  409.         !$sitepress_settings['existing_content_language_verified']

    410. 

  410.     ){

    411. 

  411.         return false;

    412. 

  412.     }       

    413. 

  413.     

    414. 

  414.     // Check if cached (so exists)    

    415. 

  415.     $cached = icl_t_cache_lookup($context, $name);

    416. 

  416.     if ($cached && isset($cached['original']) && $cached['original'] == $value) {

    417. 

  417.         return false;

    418. 

  418.     }

    419. 

  419.     

    420. 

  420.     $language = isset($sitepress_settings['st']['strings_language']) ? $sitepress_settings['st']['strings_language'] : 'en';

    421. 

  421.     $res = $wpdb->get_row("SELECT id, value, status, language FROM {$wpdb->prefix}icl_strings WHERE context='".esc_sql($context)."' AND name='".esc_sql($name)."'");

    422. 

  422.     if($res){

    423. 

  423.         $string_id = $res->id;

    424. 

  424.         $update_string = array();

    425. 

  425.         

    426. 

  426.         

    427. 

  427.         /*

    428. 

  428.          * If Sticky Links plugin is active and set to change links in Strings,

    429. 

  429.          * we need to process $value and change links into sticky before comparing

    430. 

  430.          * with saved in DB $res->value. 

    431. 

  431.          * Otherwise after every String Translation screen refresh status of this string

    432. 

  432.          * will be changed into 'needs update'

    433. 

  433.          */

    434. 

  434.         $alp_settings = get_option('alp_settings');

    435. 

  435.         if (!empty($alp_settings['sticky_links_strings']) // do we have setting about sticky links in strings?

    436. 

  436.                 && $alp_settings['sticky_links_strings'] // is this set to TRUE?

    437. 

  437.                 && defined('WPML_STICKY_LINKS_VERSION')) { // sticky links plugin is active?

    438. 

  438.             require_once ICL_PLUGIN_PATH . '/inc/absolute-links/absolute-links.class.php';        

    439. 

  439.             $absolute_links_object = new AbsoluteLinks;

    440. 

  440.             $alp_broken_links = array();

    441. 

  441.             $value = $absolute_links_object->_process_generic_text($value, $alp_broken_links);

    442. 

  442.         }

    443. 

  443.         

    444. 

  444.         

    445. 

  445.         if($value != $res->value){

    446. 

  446.             $update_string['value'] = $value;

    447. 

  447.         }

    448. 

  448.         if($language != $res->language){

    449. 

  449.             $update_string['language'] = $language;

    450. 

  450.         }

    451. 

  451.         if(!empty($update_string)){

    452. 

  452.             $wpdb->update($wpdb->prefix.'icl_strings', $update_string, array('id'=>$string_id));

    453. 

  453.             $wpdb->update($wpdb->prefix.'icl_string_translations', array('status'=>ICL_STRING_TRANSLATION_NEEDS_UPDATE), array('string_id'=>$string_id));

    454. 

  454.             icl_update_string_status($string_id);

    455. 

  455.         }        

    456. 

  456.     }else{

    457. 

  457.         if(!empty($value) && is_scalar($value) && trim($value) || $allow_empty_value){

    458. 

  458.             $string = array(

    459. 

  459.                 'language' => $language,

    460. 

  460.                 'context' => $context,

    461. 

  461.                 'name' => $name,

    462. 

  462.                 'value' => $value,

    463. 

  463.                 'status' => ICL_STRING_TRANSLATION_NOT_TRANSLATED,

    464. 

  464.             );

    465. 

  465.             $wpdb->insert($wpdb->prefix.'icl_strings', $string);

    466. 

  466.             $string_id = $wpdb->insert_id;

    467. 

  467.         }else{

    468. 

  468.             $string_id = 0;

    469. 

  469.         }

    470. 

  470.     } 

    471. 

  471.     global $WPML_Sticky_Links;

    472. 

  472.     if(!empty($WPML_Sticky_Links) && $WPML_Sticky_Links->settings['sticky_links_strings']){        

    473. 

  473.         require_once ICL_PLUGIN_PATH . '/inc/translation-management/pro-translation.class.php';

    474. 

  474.         ICL_Pro_Translation::_content_make_links_sticky($string_id, 'string', false);   

    475. 

  475.     }

    476. 

  476.     return $string_id; 

    477. 

  477. }

    478. 

  478. 

    479. 

  479. add_filter('register_string_for_translation', 'icl_register_string', 10, 4);

    480. 

  480. 

    481. 

  481. function icl_translate($context, $name, $original_value = false, $allow_empty_value = false, &$has_translation = null) {

    482. 

  482. 		global $sitepress;

    483. 

  483. 		$current_language = $sitepress->get_current_language();   

    484. 

  484.     static $cache = null;

    485. 

  485.     if (isset($cache[$context][$name][$current_language])) {

    486. 

  486. 			if ( $cache[$context][$name][$current_language] != $original_value ) {

    487. 

  487. 				$has_translation = true;

    488. 

  488. 			} else {

    489. 

  489. 				$has_translation = false;

    490. 

  490. 			}

    491. 

  491.       return $cache[$context][$name][$current_language];

    492. 

  492.     }

    493. 

  493.     icl_register_string($context, $name, $original_value, $allow_empty_value);

    494. 

  494.     $cache[$context][$name][$current_language] = icl_t($context, $name, $original_value, $has_translation);

    495. 

  495.     return $cache[$context][$name][$current_language];

    496. 

  496. }

    497. 

  497. 

    498. 

  498. function icl_st_is_registered_string($context, $name){

    499. 

  499.     global $wpdb;

    500. 

  500.     static $cache = array();

    501. 

  501.     if(isset($cache[$context][$name])){

    502. 

  502.         $string_id = $cache[$context][$name];

    503. 

  503.     }else{

    504. 

  504.         $string_id = $wpdb->get_var("

    505. 

  505.             SELECT id 

    506. 

  506.             FROM {$wpdb->prefix}icl_strings WHERE context='".esc_sql($context)."' AND name='".esc_sql($name)."'");

    507. 

  507.         $cache[$context][$name] = $string_id;

    508. 

  508.     }

    509. 

  509.     return $string_id;

    510. 

  510. }

    511. 

  511. 

    512. 

  512. function icl_st_string_has_translations($context, $name){

    513. 

  513.     global $wpdb;

    514. 

  514.     $sql = "

    515. 

  515.         SELECT COUNT(st.id) 

    516. 

  516.         FROM {$wpdb->prefix}icl_string_translations st 

    517. 

  517.         JOIN {$wpdb->prefix}icl_strings s ON s.id=st.string_id

    518. 

  518.         WHERE s.name='".esc_sql($name)."' AND s.context='".esc_sql($context)."'

    519. 

  519.     ";

    520. 

  520.     return $wpdb->get_var($sql);

    521. 

  521. }

    522. 

  522. 

    523. 

  523. function icl_rename_string($context, $old_name, $new_name){

    524. 

  524.     global $wpdb;

    525. 

  525.     $wpdb->update($wpdb->prefix.'icl_strings', array('name'=>$new_name), array('context'=>$context, 'name'=>$old_name));

    526. 

  526. }

    527. 

  527. 

    528. 

  528. function icl_update_string_status($string_id){

    529. 

  529.     global $wpdb, $sitepress, $sitepress_settings;    

    530. 

  530.     $st = $wpdb->get_results($wpdb->prepare("SELECT language, status FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d", $string_id));    

    531. 

  531.     

    532. 

  532.     if($st){  

    533. 

  533. 

    534. 

  534. 		if (isset($sitepress_settings['st']['strings_language'])) {

    535. 

  535. 			$strings_language = $sitepress_settings['st']['strings_language'];

    536. 

  536. 		} else {

    537. 

  537. 			$strings_language = false;

    538. 

  538. 		}

    539. 

  539. 		foreach($st as $t){

    540. 

  540. 			if( $strings_language != $t->language){

    541. 

  541. 				$translations[$t->language] = $t->status;

    542. 

  542. 			}

    543. 

  543. 		}  

    544. 

  544.         

    545. 

  545.         $active_languages = $sitepress->get_active_languages();

    546. 

  546.         

    547. 

  547.         if(empty($translations) || max($translations) == ICL_STRING_TRANSLATION_NOT_TRANSLATED){

    548. 

  548.             $status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    549. 

  549.         }elseif( in_array(ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR,$translations) ){            

    550. 

  550.             $status = ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR;

    551. 

  551.         }elseif(count($translations) < count($active_languages) - intval(in_array($strings_language, array_keys($active_languages)))){

    552. 

  552.             if(in_array(ICL_STRING_TRANSLATION_NEEDS_UPDATE,$translations)){

    553. 

  553.                 $status = ICL_STRING_TRANSLATION_NEEDS_UPDATE;

    554. 

  554.             }elseif(in_array(ICL_STRING_TRANSLATION_COMPLETE,$translations)){

    555. 

  555.                 $status = ICL_STRING_TRANSLATION_PARTIAL;            

    556. 

  556.             }else{

    557. 

  557.                 $status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    558. 

  558.             }            

    559. 

  559.         }elseif(ICL_STRING_TRANSLATION_NEEDS_UPDATE == array_unique($translations)){            

    560. 

  560.             $status = ICL_STRING_TRANSLATION_NEEDS_UPDATE;

    561. 

  561.         }else{

    562. 

  562.             if(in_array(ICL_STRING_TRANSLATION_NEEDS_UPDATE,$translations)){

    563. 

  563.                 $status = ICL_STRING_TRANSLATION_NEEDS_UPDATE;

    564. 

  564.             }elseif(in_array(ICL_STRING_TRANSLATION_NOT_TRANSLATED,$translations)){

    565. 

  565.                 $status = ICL_STRING_TRANSLATION_PARTIAL;            

    566. 

  566.             }else{

    567. 

  567.                 $status = ICL_STRING_TRANSLATION_COMPLETE;            

    568. 

  568.             }

    569. 

  569.         }

    570. 

  570.     }else{

    571. 

  571.         $status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;        

    572. 

  572.     }    

    573. 

  573.     $wpdb->update($wpdb->prefix.'icl_strings', array('status'=>$status), array('id'=>$string_id));

    574. 

  574.     return $status;    

    575. 

  575. }

    576. 

  576. 

    577. 

  577. function icl_update_string_status_all(){

    578. 

  578.     global $wpdb;

    579. 

  579.     $res = $wpdb->get_col("SELECT id FROM {$wpdb->prefix}icl_strings");

    580. 

  580.     foreach($res as $id){

    581. 

  581.         icl_update_string_status($id);

    582. 

  582.     }

    583. 

  583. }

    584. 

  584. 

    585. 

  585. function icl_unregister_string($context, $name){

    586. 

  586.     global $wpdb; 

    587. 

  587.     $string_id = $wpdb->get_var("SELECT id FROM {$wpdb->prefix}icl_strings WHERE context='".esc_sql($context)."' AND name='".esc_sql($name)."'");       

    588. 

  588.     if($string_id){

    589. 

  589.         $wpdb->query( $wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_strings WHERE id=%d", $string_id));

    590. 

  590.         $wpdb->query( $wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d", $string_id));

    591. 

  591.         $wpdb->query( $wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_string_positions WHERE string_id=%d", $string_id));

    592. 

  592.     }

    593. 

  593.     do_action('icl_st_unregister_string', $string_id);

    594. 

  594. }  

    595. 

  595. 

    596. 

  596. function __icl_unregister_string_multi($arr){

    597. 

  597.     global $wpdb; 

    598. 

  598.     $str = join(',', array_map('intval', $arr));

    599. 

  599.     $wpdb->query("

    600. 

  600.         DELETE s.*, t.* FROM {$wpdb->prefix}icl_strings s LEFT JOIN {$wpdb->prefix}icl_string_translations t ON s.id = t.string_id

    601. 

  601.         WHERE s.id IN ({$str})");

    602. 

  602.     $wpdb->query("DELETE FROM {$wpdb->prefix}icl_string_positions WHERE string_id IN ({$str})");

    603. 

  603.     do_action('icl_st_unregister_string_multi', $arr);

    604. 

  604. }  

    605. 

  605. 

    606. 

  606. function icl_t($context, $name, $original_value=false, &$has_translation=null, $dont_auto_register = false){

    607. 

  607.     global $sitepress, $sitepress_settings;

    608. 

  608.     

    609. 

  609.         // we need this to devide static $results cache by blogs in multiblog

    610. 

  610. 		$blog_id = 0;

    611. 

  611. 		if (isset($GLOBALS['blog_id'])) {

    612. 

  612. 			$blog_id = $GLOBALS['blog_id'];

    613. 

  613. 		}

    614. 

  614. 		

    615. 

  615.     // if the default language is not set up return

    616. 

  616.     if(!isset($sitepress_settings['existing_content_language_verified'])){        

    617. 

  617.         if(isset($has_translation)) $has_translation = false;

    618. 

  618.         return $original_value !== false ? $original_value : $name;

    619. 

  619.     }

    620. 

  620. 

    621. 

  621.     $current_language = get_current_string_language( $name );

    622. 

  622.     $default_language = !empty($sitepress_settings['st']['strings_language']) ? $sitepress_settings['st']['strings_language'] : $sitepress->get_default_language();

    623. 

  623. 		

    624. 

  624. 		$cache_key_args = array($blog_id, $current_language, $default_language, $context, $name, $original_value);

    625. 

  625. 		$cache_key      = md5( json_encode( $cache_key_args ) );

    626. 

  626. 		$cache_group    = '_icl_t';

    627. 

  627. 		$found          = false;

    628. 

  628. 		

    629. 

  629. 		$to_return = wp_cache_get($cache_key, $cache_group, false, $found);

    630. 

  630. 		

    631. 

  631. 		if ($found) {

    632. 

  632. 			if ($to_return == $original_value) {

    633. 

  633. 				$has_translation = false;

    634. 

  634. 			} else {

    635. 

  635. 				$has_translation = true;

    636. 

  636. 			}

    637. 

  637. 			return $to_return;

    638. 

  638. 		}

    639. 

  639. 		

    640. 

  640.     if($current_language == $default_language && $original_value){

    641. 

  641.         

    642. 

  642.         $ret_val = $original_value;

    643. 

  643.         if(isset($has_translation)) $has_translation = false;

    644. 

  644.         

    645. 

  645.     }else{

    646. 

  646.         $result = icl_t_cache_lookup($context, $name);

    647. 

  647.         

    648. 

  648.         $is_string_change = _icl_is_string_change($result, $original_value);

    649. 

  649.         

    650. 

  650.         if (($result === false || $is_string_change) && !is_admin() && !$dont_auto_register && $context != 'Widgets') {

    651. 

  651.             

    652. 

  652.             static $string_registrations_per_request = 0;

    653. 

  653.             

    654. 

  654.             if($string_registrations_per_request < ICL_STRING_TRANSLATION_AUTO_REGISTER_THRESHOLD){

    655. 

  655.             

    656. 

  656.                 // See if we should auto register the strings.

    657. 

  657.                 if (isset($sitepress_settings['st']['icl_st_auto_reg'])) {

    658. 

  658.                     $auto_reg = $sitepress_settings['st']['icl_st_auto_reg'];

    659. 

  659.                 } else {

    660. 

  660.                     $auto_reg = 'disable';

    661. 

  661.                 }

    662. 

  662.                 

    663. 

  663.                 if($auto_reg == 'auto-always' || ($auto_reg == 'auto-admin' && current_user_can('manage_options'))){

    664. 

  664.                     icl_register_string($context, $name, $original_value);

    665. 

  665.                     $string_registrations_per_request++;

    666. 

  666.                 }

    667. 

  667.                 

    668. 

  668.             }

    669. 

  669.             

    670. 

  670.         }

    671. 

  671.         if($result === false || ( is_array($result) && ( !isset($result['value']) || ( isset($result['translated']) && !$result['translated'] && $original_value ) ) ) ){        

    672. 

  672.             $ret_val = $original_value;    

    673. 

  673.             if(isset($has_translation)) $has_translation = false;

    674. 

  674.         }else{

    675. 

  675.             $ret_val = $result['value'];    

    676. 

  676.             if(isset($has_translation)) $has_translation = true;

    677. 

  677.         }

    678. 

  678.         

    679. 

  679.     }

    680. 

  680. 		

    681. 

  681. 		wp_cache_set($cache_key, $ret_val, $cache_group);

    682. 

  682. 		

    683. 

  683.     return $ret_val;

    684. 

  684. }

    685. 

  685. 

    686. 

  686. /**

    687. 

  687.  * @param $name

    688. 

  688.  *

    689. 

  689.  * Checks whether a given string is to be translated in the Admin back-end.

    690. 

  690.  * Currently only tagline and title of a site are to be translated.

    691. 

  691.  * All other admin strings are to always be displayed in the user admin language.

    692. 

  692.  *

    693. 

  693.  * @return bool

    694. 

  694.  */

    695. 

  695. function is_translated_admin_string( $name ) {

    696. 

  696.     $translated = false;

    697. 

  697. 

    698. 

  698.     $exclusions = array( 'Tagline', 'Blog Title' );

    699. 

  699. 

    700. 

  700.     if ( in_array( $name, $exclusions ) ) {

    701. 

  701.         $translated = true;

    702. 

  702.     }

    703. 

  703. 

    704. 

  704.     return $translated;

    705. 

  705. }

    706. 

  706. 

    707. 

  707. /**

    708. 

  708.  * @param $name

    709. 

  709.  * Returns the language the current string is to be translated into.

    710. 

  710.  *

    711. 

  711.  * @return string

    712. 

  712.  */

    713. 

  713. function get_current_string_language( $name ) {

    714. 

  714.     global $sitepress;

    715. 

  715. 

    716. 

  716.     if ( defined( 'DOING_AJAX' ) ) {

    717. 

  717.         $current_language = $sitepress->get_language_cookie();

    718. 

  718.     } else {

    719. 

  719.         $current_language = $sitepress->get_current_language();

    720. 

  720.     }

    721. 

  721. 

    722. 

  722. 	/*

    723. 

  723. 	 * The logic for this is a little different in the admin backend. Here we always use the user admin language if the admin backend is accessed.

    724. 

  724. 	 * We have to take care of two exceptions though.

    725. 

  725. 	 * 1. Plugins doing admin ajax calls in the frontend.

    726. 

  726. 	 * 2. Certain strings are to always be translated in the admin backend.

    727. 

  727. 	 * 3. We have to handle special exception when check_if_admin_action_from_referrer is not available yet (during upgrade)

    728. 

  728. 	 */

    729. 

  729. 	if (version_compare(ICL_SITEPRESS_VERSION, '3.1.7.2', '>')) {

    730. 

  730. 		if (defined('WP_ADMIN') && ( $sitepress->check_if_admin_action_from_referer() || !defined('DOING_AJAX') ) && !is_translated_admin_string($name)) {

    731. 

  731. 			$current_user = $sitepress->get_current_user();

    732. 

  732. 			if (isset($current_user->ID)) {

    733. 

  733. 				$current_language = $sitepress->get_user_admin_language($current_user->ID);

    734. 

  734. 			}

    735. 

  735. 		}

    736. 

  736. 	}

    737. 

  737. 

    738. 

  738. 	return $current_language;

    739. 

  739. }

    740. 

  740. 

    741. 

  741. /**

    742. 

  742.  * Helper function for icl_t()

    743. 

  743.  * @param array $result

    744. 

  744.  * @param string $original_value

    745. 

  745.  * @return boolean

    746. 

  746.  */

    747. 

  747. function _icl_is_string_change($result, $original_value) {

    748. 

  748. 	

    749. 

  749. 	if ($result == false) {

    750. 

  750. 		return false;

    751. 

  751. 	} 

    752. 

  752. 	

    753. 

  753. 	if (!isset($result['value'])) {

    754. 

  754. 		return false;

    755. 

  755. 	}

    756. 

  756. 	return (

    757. 

  757.                 $result['translated'] && $result['original'] != $original_value ||

    758. 

  758.                 !$result['translated'] && $result['value'] != $original_value

    759. 

  759.             );

    760. 

  760. }

    761. 

  761. 

    762. 

  762. add_filter('translate_string', 'icl_t', 10, 5);

    763. 

  763. 

    764. 

  764. function icl_add_string_translation($string_id, $language, $value = null, $status = false, $translator_id = null){

    765. 

  765.     global $wpdb, $sitepress;

    766. 

  766.     

    767. 

  767.     $current_user = $sitepress->get_current_user();

    768. 

  768.     

    769. 

  769.     

    770. 

  770.     $res = $wpdb->get_row("SELECT id, value, status FROM {$wpdb->prefix}icl_string_translations WHERE string_id='".esc_sql($string_id)."' AND language='".esc_sql($language)."'");

    771. 

  771.     

    772. 

  772.     // the same string should not be sent two times to translation

    773. 

  773.     if(isset($res->status) && $res->status == ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR && is_null($value)){

    774. 

  774.         return false;        

    775. 

  775.     }

    776. 

  776.     

    777. 

  777.     if($res){

    778. 

  778.         $st_id = $res->id;

    779. 

  779.         $st_update = array();

    780. 

  780.         if(!is_null($value) && $value != $res->value){  // null $value is for sending to translation. don't override existing.

    781. 

  781.             $st_update['value'] = $value;

    782. 

  782.         }

    783. 

  783.         if($status){

    784. 

  784.             $st_update['status'] = $status;

    785. 

  785.         }elseif($status === ICL_STRING_TRANSLATION_NOT_TRANSLATED){

    786. 

  786.             $st_update['status'] = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    787. 

  787.         } 

    788. 

  788.         

    789. 

  789.         if(!empty($st_update)){

    790. 

  790.             if(!is_null($translator_id)){

    791. 

  791.                 $st_update['translator_id'] = $current_user->ID;

    792. 

  792.             }

    793. 

  793.             $st_update['translation_date'] = current_time("mysql");

    794. 

  794.             $wpdb->update($wpdb->prefix.'icl_string_translations', $st_update, array('id'=>$st_id));

    795. 

  795.         }        

    796. 

  796.     }else{

    797. 

  797.         if(!$status){

    798. 

  798.             $status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    799. 

  799.         }

    800. 

  800.         $st = array(

    801. 

  801.             'string_id' => $string_id,

    802. 

  802.             'language'  => $language,

    803. 

  803.             'status'    => $status

    804. 

  804.         );

    805. 

  805.         if(!is_null($value)){

    806. 

  806.             $st['value'] = $value;

    807. 

  807.         }

    808. 

  808.         if(!is_null($translator_id)){

    809. 

  809.             $st_update['translator_id'] = $current_user->ID;

    810. 

  810.         }        

    811. 

  811.         $wpdb->insert($wpdb->prefix.'icl_string_translations', $st);

    812. 

  812.         $st_id = $wpdb->insert_id;

    813. 

  813.     }    

    814. 

  814.     

    815. 

  815.     if(isset($GLOBALS['ICL_Pro_Translation'])){

    816. 

  816.         $GLOBALS['ICL_Pro_Translation']->_content_fix_links_to_translated_content($st_id, $language, 'string');    

    817. 

  817.     }

    818. 

  818.                                          

    819. 

  819.     icl_update_string_status($string_id);

    820. 

  820.     

    821. 

  821.     do_action('icl_st_add_string_translation', $st_id);

    822. 

  822.     

    823. 

  823.     return $st_id;

    824. 

  824. }

    825. 

  825. 

    826. 

  826. /**

    827. 

  827.  * 

    828. 

  828.  * @global WPDB $wpdb

    829. 

  829.  * @global array $sitepress_settings

    830. 

  830.  * @param string $option_name

    831. 

  831.  * @param string $language

    832. 

  832.  * @param string $new_value

    833. 

  833.  * @param int|bool $status

    834. 

  834.  * @param int $translator_id

    835. 

  835.  * @param int $rec_level

    836. 

  836.  * @return boolean|mixed

    837. 

  837.  */

    838. 

  838. function icl_update_string_translation($option_name, $language, $new_value = null, $status = false, $translator_id = null, $rec_level = 0) {

    839. 

  839. 	global $wpdb, $sitepress_settings;

    840. 

  840. 	

    841. 

  841. 	if (!is_array($new_value)) {

    842. 

  842. 		$new_value = (array) $new_value;

    843. 

  843. 	}

    844. 

  844. 	

    845. 

  845. 	$updated = array();

    846. 

  846. 	

    847. 

  847. 	foreach ($new_value as $index => $value) {

    848. 

  848. 

    849. 

  849. 		if (is_array($value)) {

    850. 

  850. 			$name = "[". $option_name ."][" . $index . "]";

    851. 

  851. 			$result = icl_update_string_translation($name, $language, $value, $status, $translator_id, $rec_level + 1);

    852. 

  852. 			$updated[] = array_sum( explode(",", $result) );

    853. 

  853. 		} else {

    854. 

  854. 			if (is_string($index)) {

    855. 

  855. 				if ($rec_level == 0) {

    856. 

  856. 					$name = "[". $option_name ."]" . $index;

    857. 

  857. 				} else {

    858. 

  858. 					$name = $option_name . $index;

    859. 

  859. 				}

    860. 

  860. 			} else {

    861. 

  861. 				$name = $option_name;

    862. 

  862. 			}

    863. 

  863. 			

    864. 

  864. 			$select_original_string = "SELECT * FROM {$wpdb->prefix}icl_strings WHERE name = %s AND language = %s";

    865. 

  865. 			$original_string = $wpdb->get_row($wpdb->prepare($select_original_string, $name, $sitepress_settings['st']['strings_language']));

    866. 

  866. 			if (!$original_string || !isset($original_string->id) || !is_numeric($original_string->id)) {

    867. 

  867. 				continue;

    868. 

  868. 			}

    869. 

  869. 

    870. 

  870. 			$updated[] = icl_add_string_translation($original_string->id, $language, $value, $status, $translator_id);

    871. 

  871. 			

    872. 

  872. 		}

    873. 

  873. 

    874. 

  874. 		

    875. 

  875. 	}

    876. 

  876. 	

    877. 

  877. 	if (array_sum($updated) > 0) {

    878. 

  878. 		return join(",", $updated);

    879. 

  879. 	} else {

    880. 

  880. 		return false;

    881. 

  881. 	}

    882. 

  882. 	

    883. 

  883. 	

    884. 

  884. }

    885. 

  885. 

    886. 

  886. function icl_get_string_id($string, $context){

    887. 

  887.     global $wpdb;

    888. 

  888.     $id = (int) $wpdb->get_var($wpdb->prepare("SELECT id FROM {$wpdb->prefix}icl_strings WHERE value=%s AND context=%s", $string, $context));    

    889. 

  889.     return $id;

    890. 

  890. }

    891. 

  891. 

    892. 

  892. function icl_get_string_translations($offset=0){

    893. 

  893.     global $wpdb, $sitepress, $sitepress_settings, $wp_query, $icl_st_string_translation_statuses;

    894. 

  894.     $string_translations = array();

    895. 

  895.     

    896. 

  896.     $current_user = $sitepress->get_current_user();

    897. 

  897.     

    898. 

  898.     $extra_cond = "";

    899. 

  899.     if(icl_st_is_translator() && isset($_GET['status']) && preg_match("#".ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR."-(.+)#", $_GET['status'], $matches)){

    900. 

  900.         $status_filter = ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR;

    901. 

  901.         $status_filter_lang = $matches[1];

    902. 

  902.         $lcode_alias = str_replace('-', '', $status_filter_lang);

    903. 

  903.         $extra_cond .= " AND str_{$lcode_alias}.language = '{$status_filter_lang}' ";        

    904. 

  904.     }else{

    905. 

  905.         $status_filter = isset($_GET['status']) ? intval($_GET['status']) : false;    

    906. 

  906.     }

    907. 

  907.     

    908. 

  908.     $search_filter = isset($_GET['search']) ? $_GET['search'] : false;

    909. 

  909.     $exact_match   = isset($_GET['em']) ? $_GET['em'] == 1 : false;

    910. 

  910.     

    911. 

  911.     if($status_filter !== false){

    912. 

  912.         if($status_filter == ICL_STRING_TRANSLATION_COMPLETE){

    913. 

  913.             $extra_cond .= " AND s.status = " . ICL_STRING_TRANSLATION_COMPLETE;

    914. 

  914.         }elseif($status_filter == ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR){

    915. 

  915.             ; // do nothing

    916. 

  916.         }else{

    917. 

  917.             $extra_cond .= " AND status IN (" . ICL_STRING_TRANSLATION_PARTIAL . "," . ICL_STRING_TRANSLATION_NEEDS_UPDATE . "," . ICL_STRING_TRANSLATION_NOT_TRANSLATED . "," . ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR . ")";

    918. 

  918.         }        

    919. 

  919.     }

    920. 

  920.     

    921. 

  921.     if($search_filter != false){

    922. 

  922.         if($exact_match){

    923. 

  923.             $extra_cond .= " AND s.value = '". esc_sql($search_filter)."' ";            

    924. 

  924.         }else{

    925. 

  925.             $extra_cond .= " AND s.value LIKE '%". esc_sql($search_filter)."%' ";            

    926. 

  926.         }

    927. 

  927.     }

    928. 

  928.     

    929. 

  929.     $context_filter = isset($_GET['context']) ? $_GET['context'] : false;

    930. 

  930.     if($context_filter !== false){

    931. 

  931.         $extra_cond .= " AND s.context = '" . esc_sql($context_filter) . "'";

    932. 

  932.     }

    933. 

  933.     

    934. 

  934.     if(isset($_GET['show_results']) && $_GET['show_results']=='all'){

    935. 

  935.         $limit = 9999;

    936. 

  936.         $offset = 0;

    937. 

  937.     }else{       

    938. 

  938.         $limit = $sitepress_settings['st']['strings_per_page']; 

    939. 

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

    940. 

  940.         $offset = ($_GET['paged']-1)*$limit;

    941. 

  941.     }

    942. 

  942.     

    943. 

  943.     /* TRANSLATOR - START */

    944. 

  944.     if(icl_st_is_translator()){

    945. 

  945.         

    946. 

  946.         $user_lang_pairs = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);    

    947. 

  947.         

    948. 

  948.         if(!empty($status_filter_lang)){

    949. 

  949.             

    950. 

  950.             $_joins = $_sels = $_where = array();

    951. 

  951.             foreach($sitepress->get_active_languages() as $l){

    952. 

  952.                 if($l['code'] == $sitepress_settings['st']['strings_language']) continue;

    953. 

  953.                 $lcode_alias = str_replace('-', '', $l['code']);

    954. 

  954.                 $_sels[]  = "str_{$lcode_alias}.id AS id_{$lcode_alias}, 

    955. 

  955.                              str_{$lcode_alias}.status AS status_{$lcode_alias}, 

    956. 

  956.                              str_{$lcode_alias}.value AS value_{$lcode_alias},

    957. 

  957.                              str_{$lcode_alias}.translator_id AS translator_{$lcode_alias}, 

    958. 

  958.                              str_{$lcode_alias}.translation_date AS date_{$lcode_alias}

    959. 

  959.                              ";

    960. 

  960.                 $_joins[] = " LEFT JOIN {$wpdb->prefix}icl_string_translations str_{$lcode_alias} ON str_{$lcode_alias}.string_id = s.id AND str_{$lcode_alias}.language = '{$l['code']}'";    

    961. 

  961.             }

    962. 

  962. 

    963. 

  963.             $sql = "

    964. 

  964.                 SELECT SQL_CALC_FOUND_ROWS s.id AS string_id, s.language AS string_language, s.context, s.name, s.value, s.status,

    965. 

  965.                     " . join(", ", $_sels) . "

    966. 

  966.                 FROM  {$wpdb->prefix}icl_strings s 

    967. 

  967.                 " . join("\n", $_joins) . "

    968. 

  968.                 WHERE 

    969. 

  969.                     str_{$status_filter_lang}.status = %d AND

    970. 

  970.                     (str_{$status_filter_lang}.translator_id IS NULL OR str_{$status_filter_lang}.translator_id = %d)

    971. 

  971.                     {$extra_cond}

    972. 

  972.                 ORDER BY string_id DESC

    973. 

  973.                 LIMIT {$offset},{$limit}

    974. 

  974.             ";    

    975. 

  975. 						$sql_prepared = $wpdb->prepare($sql, array(ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR, $current_user->ID));

    976. 

  976.             $res = $wpdb->get_results($sql_prepared, ARRAY_A);

    977. 

  977.             

    978. 

  978.         }else{

    979. 

  979.             $_joins = $_sels = $_where = array();

    980. 

  980.             

    981. 

  981.             foreach($sitepress->get_active_languages() as $l){

    982. 

  982.                 

    983. 

  983.                 if($l['code'] == $sitepress_settings['st']['strings_language'] 

    984. 

  984.                     || empty($user_lang_pairs[$sitepress_settings['st']['strings_language']][$l['code']])) continue;

    985. 

  985.                 $lcode_alias = str_replace('-', '', $l['code']);

    986. 

  986.                 $lcode_alias = str_replace('-', '', $l['code']);

    987. 

  987.                 

    988. 

  988.                 $_sels[]  = "str_{$lcode_alias}.id AS id_{$lcode_alias}, 

    989. 

  989.                              str_{$lcode_alias}.status AS status_{$lcode_alias}, 

    990. 

  990.                              str_{$lcode_alias}.value AS value_{$lcode_alias},

    991. 

  991.                              str_{$lcode_alias}.translator_id AS translator_{$lcode_alias}, 

    992. 

  992.                              str_{$lcode_alias}.translation_date AS date_{$lcode_alias}

    993. 

  993.                              ";

    994. 

  994.                 $_joins[] = "LEFT JOIN {$wpdb->prefix}icl_string_translations str_{$lcode_alias} ON str_{$lcode_alias}.string_id = s.id AND str_{$lcode_alias}.language='{$l['code']}'";

    995. 

  995.                 

    996. 

  996.                 if($status_filter == ICL_STRING_TRANSLATION_COMPLETE){

    997. 

  997.                     $_where[] .= " AND str_{$lcode_alias}.status = " . ICL_STRING_TRANSLATION_COMPLETE;

    998. 

  998.                 }else{

    999. 

  999.                     if(empty($_lwhere)){     

    1000. 

  1000.                         $_lwhere = ' AND (';             

    1001. 

  1001.                         foreach($sitepress->get_active_languages() as $l2){

    1002. 

  1002.                             if($l2['code'] == $sitepress_settings['st']['strings_language'] || empty($user_lang_pairs[$sitepress_settings['st']['strings_language']][$l2['code']])) continue;

    1003. 

  1003.                             $l2code_alias = str_replace('-', '', $l2['code']);

    1004. 

  1004.                             $_lwheres[] = " str_{$l2code_alias}.status = " . ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR . " OR 

    1005. 

  1005.                                                 str_{$l2code_alias}.translator_id = " . $current_user->ID ;

    1006. 

  1006.                         }

    1007. 

  1007.                         $_lwhere .= join(' OR ', $_lwheres )  . ')';

    1008. 

  1008.                         $_where[] = $_lwhere;

    1009. 

  1009.                     }

    1010. 

  1010.                 }        

    1011. 

  1011.                 

    1012. 

  1012.             }

    1013. 

  1013.             

    1014. 

  1014. 

    1015. 

  1015.             $sql = "

    1016. 

  1016.                 SELECT SQL_CALC_FOUND_ROWS s.id AS string_id, s.language AS string_language, s.context, s.name, s.value, s.status, ".

    1017. 

  1017.                 join(', ', $_sels) . "

    1018. 

  1018.                 FROM {$wpdb->prefix}icl_strings s " . join("\n", $_joins) . "

    1019. 

  1019.                 WHERE s.language = '{$sitepress_settings['st']['strings_language']}' ".join(' ', $_where) . "

    1020. 

  1020.                     {$extra_cond}

    1021. 

  1021.                 ORDER BY s.id DESC

    1022. 

  1022.                 LIMIT {$offset},{$limit}

    1023. 

  1023.                 ";

    1024. 

  1024. 

    1025. 

  1025.             $res = $wpdb->get_results($sql, ARRAY_A);

    1026. 

  1026.         }

    1027. 

  1027.         

    1028. 

  1028.         $wp_query->found_posts = $wpdb->get_var("SELECT FOUND_ROWS()");

    1029. 

  1029.         $wp_query->query_vars['posts_per_page'] = $limit;

    1030. 

  1030.         $wp_query->max_num_pages = ceil($wp_query->found_posts/$limit);

    1031. 

  1031.         

    1032. 

  1032.         if($res){

    1033. 

  1033.             if(!empty($status_filter_lang)){

    1034. 

  1034.                 foreach($res as $row){

    1035. 

  1035.                     

    1036. 

  1036.                     $_translations = array();

    1037. 

  1037.                     foreach($sitepress->get_active_languages() as $l){

    1038. 

  1038.                         if($l['code'] == $sitepress_settings['st']['strings_language']) continue;

    1039. 

  1039.                         $lcode_alias = str_replace('-', '', $l['code']);

    1040. 

  1040.                         if($row['id_'. $lcode_alias]){

    1041. 

  1041.                             $_translations[$l['code']] = array(

    1042. 

  1042.                                 'id' => $row['id_'. $lcode_alias],

    1043. 

  1043.                                 'status' => $row['status_'. $lcode_alias],

    1044. 

  1044.                                 'language' => $l['code'],

    1045. 

  1045.                                 'value' => $row['value_'. $lcode_alias],

    1046. 

  1046.                                 'translator_id' => $row['translator_'. $lcode_alias],

    1047. 

  1047.                                 'translation_date' => $row['date_'. $lcode_alias]

    1048. 

  1048.                             );

    1049. 

  1049.                         }

    1050. 

  1050.                     }

    1051. 

  1051.                     

    1052. 

  1052.                     

    1053. 

  1053.                     $string_translations[$row['string_id']] = array(

    1054. 

  1054.                         'string_id'             => $row['string_id'],

    1055. 

  1055.                         'string_language'       => $row['string_language'],

    1056. 

  1056.                         'context'               => $row['context'],

    1057. 

  1057.                         'name'                  => $row['name'],

    1058. 

  1058.                         'value'                 => $row['value'],

    1059. 

  1059.                         'status'                => ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR,

    1060. 

  1060.                         'translations'          => $_translations

    1061. 

  1061.                     );                    

    1062. 

  1062.                 }

    1063. 

  1063.             }else{

    1064. 

  1064.                 foreach($res as $row){

    1065. 

  1065. 

    1066. 

  1066.                     $_translations = array();

    1067. 

  1067.                     

    1068. 

  1068.                     $_status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    1069. 

  1069.                     $_statuses = array();

    1070. 

  1070.                     foreach($sitepress->get_active_languages() as $l){

    1071. 

  1071.                         if($l['code'] == $sitepress_settings['st']['strings_language'] || empty($user_lang_pairs[$sitepress_settings['st']['strings_language']][$l['code']])) continue;

    1072. 

  1072.                         $lcode_alias = str_replace('-', '', $l['code']);

    1073. 

  1073.                         if($row['id_'. $lcode_alias]){

    1074. 

  1074.                             $_translations[$l['code']] = array(

    1075. 

  1075.                                 'id' => $row['id_'. $lcode_alias],

    1076. 

  1076.                                 'status' => $row['status_'. $lcode_alias],

    1077. 

  1077.                                 'language' => $l['code'],

    1078. 

  1078.                                 'value' => $row['value_'. $lcode_alias],

    1079. 

  1079.                                 'translator_id' => $row['translator_'. $lcode_alias],

    1080. 

  1080.                                 'translation_date' => $row['date_'. $lcode_alias]

    1081. 

  1081.                             );

    1082. 

  1082.                         }

    1083. 

  1083.                         

    1084. 

  1084.                         $_statuses[$l['code']] = @intval($row['status_'. $lcode_alias]);

    1085. 

  1085.                         

    1086. 

  1086.                         if($row['status_'. $lcode_alias] == ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR){

    1087. 

  1087.                             $_status == ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR; 

    1088. 

  1088.                         } 

    1089. 

  1089.                         

    1090. 

  1090.                     }

    1091. 

  1091.                     $_statuses = array_values($_statuses);

    1092. 

  1092.                     $_statuses = array_unique($_statuses);

    1093. 

  1093.                     

    1094. 

  1094.                     if($_statuses == array(ICL_STRING_TRANSLATION_NOT_TRANSLATED)){

    1095. 

  1095.                         $_status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;     

    1096. 

  1096.                     }elseif($_statuses == array(ICL_STRING_TRANSLATION_COMPLETE, ICL_STRING_TRANSLATION_NOT_TRANSLATED)){

    1097. 

  1097.                         $_status = ICL_STRING_TRANSLATION_PARTIAL;

    1098. 

  1098.                     }elseif($_statuses == array(ICL_STRING_TRANSLATION_COMPLETE)){

    1099. 

  1099.                         $_status = ICL_STRING_TRANSLATION_COMPLETE;     

    1100. 

  1100.                     }elseif(in_array(ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR, $_statuses) || in_array(ICL_STRING_TRANSLATION_NEEDS_UPDATE, $_statuses)){

    1101. 

  1101.                         $_status = ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR;

    1102. 

  1102.                     }    

    1103. 

  1103.                                           

    1104. 

  1104.                     

    1105. 

  1105.                     $string_translations[$row['string_id']] = array(

    1106. 

  1106.                         'string_id'             => $row['string_id'],

    1107. 

  1107.                         'string_language'       => $row['string_language'],

    1108. 

  1108.                         'context'               => $row['context'],

    1109. 

  1109.                         'name'                  => $row['name'],

    1110. 

  1110.                         'value'                 => $row['value'],

    1111. 

  1111.                         'status'                => $_status,

    1112. 

  1112.                         'translations'          => $_translations

    1113. 

  1113.                     );

    1114. 

  1114.                 }

    1115. 

  1115.                 

    1116. 

  1116.             }

    1117. 

  1117.             

    1118. 

  1118.         }        

    1119. 

  1119.     /* TRANSLATOR - END */    

    1120. 

  1120.     }else{

    1121. 

  1121.         

    1122. 

  1122.         // removed check for language = default lang        

    1123. 

  1123.         if($status_filter != ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR){

    1124. 

  1124.             $res = $wpdb->get_results("

    1125. 

  1125.                 SELECT SQL_CALC_FOUND_ROWS id AS string_id, language AS string_language, context, name, value, status                

    1126. 

  1126.                 FROM  {$wpdb->prefix}icl_strings s

    1127. 

  1127.                 WHERE 

    1128. 

  1128.                     1

    1129. 

  1129.                     {$extra_cond}

    1130. 

  1130.                 ORDER BY string_id DESC

    1131. 

  1131.                 LIMIT {$offset},{$limit}

    1132. 

  1132.             ", ARRAY_A);

    1133. 

  1133.         }else{

    1134. 

  1134.             $res = $wpdb->get_results("

    1135. 

  1135.                 SELECT SQL_CALC_FOUND_ROWS s.id AS string_id, s.language AS string_language, s.context, s.name, s.value, " . ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR . " AS status                

    1136. 

  1136.                 FROM  {$wpdb->prefix}icl_strings s

    1137. 

  1137.                 JOIN {$wpdb->prefix}icl_string_translations str ON str.string_id = s.id

    1138. 

  1138.                 WHERE 

    1139. 

  1139.                     str.status = " . ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR . "

    1140. 

  1140.                     {$extra_cond}

    1141. 

  1141.                 ORDER BY string_id DESC

    1142. 

  1142.                 LIMIT {$offset},{$limit}

    1143. 

  1143.             ", ARRAY_A);

    1144. 

  1144.         }

    1145. 

  1145.         

    1146. 

  1146.         if(!is_null($wp_query)){        

    1147. 

  1147.             $wp_query->found_posts = $wpdb->get_var("SELECT FOUND_ROWS()");

    1148. 

  1148.             $wp_query->query_vars['posts_per_page'] = $limit;

    1149. 

  1149.             $wp_query->max_num_pages = ceil($wp_query->found_posts/$limit);

    1150. 

  1150.         }

    1151. 

  1151.         

    1152. 

  1152.         if($res){

    1153. 

  1153.             $extra_cond = '';

    1154. 

  1154.             if(isset($_GET['translation_language'])){

    1155. 

  1155.                 $extra_cond .= " AND language='".esc_sql($_GET['translation_language'])."'";    

    1156. 

  1156.             }

    1157. 

  1157.             

    1158. 

  1158.             foreach($res as $row){

    1159. 

  1159.                 $string_translations[$row['string_id']] = $row;

    1160. 

  1160.                 $tr = $wpdb->get_results( $wpdb->prepare("

    1161. 

  1161.                     SELECT id, language, status, value, translator_id, translation_date  

    1162. 

  1162.                     FROM {$wpdb->prefix}icl_string_translations 

    1163. 

  1163.                     WHERE string_id=%d {$extra_cond}

    1164. 

  1164.                 ", $row['string_id']), ARRAY_A);

    1165. 

  1165.                 if($tr){

    1166. 

  1166.                     foreach($tr as $t){

    1167. 

  1167.                         $string_translations[$row['string_id']]['translations'][$t['language']] = $t;

    1168. 

  1168.                     }                

    1169. 

  1169.                 }

    1170. 

  1170.                 

    1171. 

  1171.             }

    1172. 

  1172.         }

    1173. 

  1173.     }

    1174. 

  1174.     

    1175. 

  1175.     return $string_translations;

    1176. 

  1176. }

    1177. 

  1177. 

    1178. 

  1178. /**

    1179. 

  1179.  * Returns indexed array with language code and value of string

    1180. 

  1180.  *

    1181. 

  1181.  * @param int         $string_id     ID of string in icl_strings DB table

    1182. 

  1182.  * @param bool|string $language_code false, or language code

    1183. 

  1183.  *

    1184. 

  1184.  * @return string

    1185. 

  1185.  */

    1186. 

  1186. function icl_get_string_by_id( $string_id, $language_code = false ) {

    1187. 

  1187. 	global $wpdb, $sitepress_settings;

    1188. 

  1188. 

    1189. 

  1189. 	if ( !$language_code ) {

    1190. 

  1190. 		$language_code = $sitepress_settings[ 'st' ][ 'strings_language' ];

    1191. 

  1191. 	}

    1192. 

  1192. 

    1193. 

  1193. 	if ( $language_code == $sitepress_settings[ 'st' ][ 'strings_language' ] ) {

    1194. 

  1194. 

    1195. 

  1195. 		$result_prepared = $wpdb->prepare( "SELECT language, value FROM {$wpdb->prefix}icl_strings WHERE id=%d", $string_id );

    1196. 

  1196. 		$result = $wpdb->get_row( $result_prepared );

    1197. 

  1197. 

    1198. 

  1198. 		if ( $result ) {

    1199. 

  1199. 			return $result->value;

    1200. 

  1200. 		}

    1201. 

  1201. 

    1202. 

  1202. 	} else {

    1203. 

  1203. 		$translations = icl_get_string_translations_by_id( $string_id );

    1204. 

  1204. 		if ( isset( $translations[ $language_code ] ) ) {

    1205. 

  1205. 			return $translations[ $language_code ]['value'];

    1206. 

  1206. 		}

    1207. 

  1207. 	}

    1208. 

  1208. 

    1209. 

  1209. 	return false;

    1210. 

  1210. }

    1211. 

  1211. 

    1212. 

  1212. function icl_get_string_translations_by_id($string_id){

    1213. 

  1213.     global $wpdb;

    1214. 

  1214.     

    1215. 

  1215.     $translations = array();

    1216. 

  1216.     

    1217. 

  1217.     $results = $wpdb->get_results($wpdb->prepare("SELECT language, value, status FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d", $string_id));

    1218. 

  1218.     foreach($results as $row){

    1219. 

  1219.         $translations[$row->language] = array('value' => $row->value, 'status' => $row->status);

    1220. 

  1220.     }

    1221. 

  1221.     

    1222. 

  1222.     return $translations;

    1223. 

  1223.     

    1224. 

  1224. }

    1225. 

  1225. 

    1226. 

  1226. function icl_get_relative_translation_status($string_id, $translator_id){

    1227. 

  1227.     global $wpdb, $sitepress, $sitepress_settings;

    1228. 

  1228.     

    1229. 

  1229.     $current_user = $sitepress->get_current_user();

    1230. 

  1230.     

    1231. 

  1231.     $user_lang_pairs = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);    

    1232. 

  1232.     

    1233. 

  1233.     $src_langs = array_intersect(array_keys($sitepress->get_active_languages()), array_keys($user_lang_pairs[$sitepress_settings['st']['strings_language']]));

    1234. 

  1234.     

    1235. 

  1235.     if(empty($src_langs)) return ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    1236. 

  1236.     

    1237. 

  1237.     $sql = "SELECT st.status

    1238. 

  1238.             FROM {$wpdb->prefix}icl_strings s 

    1239. 

  1239.             JOIN {$wpdb->prefix}icl_string_translations st ON s.id = st.string_id

    1240. 

  1240.             WHERE st.language IN ('" . join("','", $src_langs) . "') AND s.id = %d

    1241. 

  1241.     ";

    1242. 

  1242.     $statuses = $wpdb->get_col($wpdb->prepare($sql, $string_id));

    1243. 

  1243.     

    1244. 

  1244.     $status = ICL_STRING_TRANSLATION_NOT_TRANSLATED;

    1245. 

  1245.     $one_incomplete = false;

    1246. 

  1246.     foreach($statuses as $s){

    1247. 

  1247.         if($s == ICL_STRING_TRANSLATION_COMPLETE){

    1248. 

  1248.             $status = ICL_STRING_TRANSLATION_COMPLETE;        

    1249. 

  1249.         }elseif($s == ICL_STRING_TRANSLATION_NOT_TRANSLATED){

    1250. 

  1250.             $one_incomplete = true;

    1251. 

  1251.         }

    1252. 

  1252.     }

    1253. 

  1253.     

    1254. 

  1254.     if($status == ICL_STRING_TRANSLATION_COMPLETE && $one_incomplete){

    1255. 

  1255.         $status = ICL_STRING_TRANSLATION_PARTIAL;        

    1256. 

  1256.     }

    1257. 

  1257.     

    1258. 

  1258.     return $status;

    1259. 

  1259.     

    1260. 

  1260. }

    1261. 

  1261. 

    1262. 

  1262. function icl_get_strings_tracked_in_pages($string_translations){

    1263. 

  1263.     global $wpdb;

    1264. 

  1264.     // get string position in page - if found

    1265. 

  1265.     $found_strings = $strings_in_page = array();

    1266. 

  1266.     foreach(array_keys((array)$string_translations) as $string_id){

    1267. 

  1267.         $found_strings[] = $string_id;

    1268. 

  1268.     }

    1269. 

  1269.     if($found_strings){

    1270. 

  1270.         $res = $wpdb->get_results("

    1271. 

  1271.             SELECT kind, string_id  FROM {$wpdb->prefix}icl_string_positions 

    1272. 

  1272.             WHERE string_id IN (".implode(',', $found_strings).")");

    1273. 

  1273.         foreach($res as $row){

    1274. 

  1274.             $strings_in_page[$row->kind][$row->string_id] = true;

    1275. 

  1275.         }

    1276. 

  1276.     }

    1277. 

  1277.     return $strings_in_page;

    1278. 

  1278. }

    1279. 

  1279. 

    1280. 

  1280. function icl_sw_filters_blogname($val){

    1281. 

  1281. 	$val = icl_t('WP', 'Blog Title', $val);

    1282. 

  1282. 	return $val;

    1283. 

  1283. }

    1284. 

  1284. 

    1285. 

  1285. function icl_sw_filters_blogdescription($val){

    1286. 

  1286. 	$val = icl_t('WP', 'Tagline', $val);

    1287. 

  1287.   return $val;

    1288. 

  1288. }

    1289. 

  1289. 

    1290. 

  1290. function icl_sw_filters_widget_title($val){

    1291. 

  1291. 	$val = icl_t('Widgets', 'widget title - ' . md5($val) , $val);

    1292. 

  1292.   return $val;  

    1293. 

  1293. }

    1294. 

  1294. 

    1295. 

  1295. function icl_sw_filters_widget_text($val){ 

    1296. 

  1296. 	$val = icl_t('Widgets', 'widget body - ' . md5($val) , $val);

    1297. 

  1297.   return $val;

    1298. 

  1298. }

    1299. 

  1299. 

    1300. 

  1300. /**

    1301. 

  1301.  * @param      $translation

    1302. 

  1302.  * @param      $text

    1303. 

  1303.  * @param      $domain

    1304. 

  1304.  * @param bool $name

    1305. 

  1305.  *

    1306. 

  1306.  * @return bool|mixed|string

    1307. 

  1307.  */

    1308. 

  1308. function icl_sw_filters_gettext( $translation, $text, $domain, $name = false )

    1309. 

  1309. {

    1310. 

  1310. 	global $sitepress_settings, $sitepress;

    1311. 

  1311. //	static $front_end_language = false;

    1312. 

  1312. 	$has_translation = 0;

    1313. 

  1313. 

    1314. 

  1314. 	if ( defined( 'DOING_AJAX' ) ) {

    1315. 

  1315. 		$current_language = $sitepress->get_language_cookie();

    1316. 

  1316. 	} elseif ( is_admin() ) {

    1317. 

  1317. 		$current_language = $sitepress->get_admin_language();

    1318. 

  1318. 	} else {

    1319. 

  1319. //		if(!$front_end_language) {

    1320. 

  1320. 		$current_language = $sitepress->get_current_language();

    1321. 

  1321. //			$front_end_language = $current_language;

    1322. 

  1322. //		} else {

    1323. 

  1323. //			$current_language = $front_end_language;

    1324. 

  1324. //	}

    1325. 

  1325. 		if ($current_language == $sitepress_settings['st']['strings_language'] ) {

    1326. 

  1326. 			return $translation;

    1327. 

  1327. 		}

    1328. 

  1328. 	}

    1329. 

  1329. 

    1330. 

  1330. 	$cache_name      = $translation . $text . $domain . $current_language;

    1331. 

  1331. 	$ret_translation = wp_cache_get( $cache_name );

    1332. 

  1332. 	if ( $ret_translation ) {

    1333. 

  1333. 		return $ret_translation;

    1334. 

  1334. 	}

    1335. 

  1335. 

    1336. 

  1336. 	if(!defined('ICL_STRING_TRANSLATION_DYNAMIC_CONTEXT')) {

    1337. 

  1337. 		define('ICL_STRING_TRANSLATION_DYNAMIC_CONTEXT', 'wpml_string');

    1338. 

  1338. 	}

    1339. 

  1339. 

    1340. 

  1340. 	$register_dynamic_string = false;

    1341. 

  1341. 	if($domain == ICL_STRING_TRANSLATION_DYNAMIC_CONTEXT) {

    1342. 

  1342. 		$register_dynamic_string = true;

    1343. 

  1343. 	}

    1344. 

  1344. 

    1345. 

  1345. 	static $gettext_calls = array( '__', '_e', '_ex', '_n', '_n_noop', '_nx', '_nx_noop', '_x', 'esc_attr__', 'esc_attr_e', 'esc_attr_x', 'esc_html__', 'esc_html_e', 'esc_html_x', );

    1346. 

  1346. 

    1347. 

  1347. 	$dbt             = $sitepress->get_backtrace(6);

    1348. 

  1348. 	$dbt4            = isset( $dbt[ 4 ][ 'file' ] ) ? str_replace( '\\', '/', $dbt[ 4 ][ 'file' ] ) : '';

    1349. 

  1349. 	$dbt5            = isset( $dbt[ 5 ][ 'file' ] ) ? str_replace( '\\', '/', $dbt[ 5 ][ 'file' ] ) : '';

    1350. 

  1350. 	$wp_plugin_dir   = str_replace( '\\', '/', WP_PLUGIN_DIR );

    1351. 

  1351. 	$wpmu_plugin_dir = str_replace( '\\', '/', WPMU_PLUGIN_DIR );

    1352. 

  1352. 

    1353. 

  1353. 	if ( 0 === strpos( $dbt4, $wp_plugin_dir ) ) {

    1354. 

  1354. 		if ( dirname( $dbt4 ) == $wp_plugin_dir ) {

    1355. 

  1355. 			$plugin_folder = basename( str_replace( $wp_plugin_dir, '', $dbt4 ) );

    1356. 

  1356. 		} else {

    1357. 

  1357. 			$exp           = explode( '/', ltrim( str_replace( $wp_plugin_dir, '', $dbt4 ), '/' ) );

    1358. 

  1358. 			$plugin_folder = $exp[ 0 ];

    1359. 

  1359. 		}

    1360. 

  1360. 		$context = 'plugin ' . $plugin_folder;

    1361. 

  1361. 	} elseif ( 0 === strpos( $dbt5, $wp_plugin_dir ) && in_array( $dbt[ 5 ][ 'function' ], $gettext_calls ) ) {

    1362. 

  1362. 		if ( dirname( $dbt4 ) == $wp_plugin_dir ) {

    1363. 

  1363. 			$plugin_folder = basename( str_replace( $wp_plugin_dir, '', $dbt5 ) );

    1364. 

  1364. 		} else {

    1365. 

  1365. 			$exp           = explode( '/', ltrim( str_replace( $wp_plugin_dir, '', $dbt5 ), '/' ) );

    1366. 

  1366. 			$plugin_folder = $exp[ 0 ];

    1367. 

  1367. 		}

    1368. 

  1368. 		$context = 'plugin ' . $plugin_folder;

    1369. 

  1369. 	} elseif ( 0 === strpos( $dbt4, $wpmu_plugin_dir ) ) {

    1370. 

  1370. 		$context = ( $domain != 'default' ) ? 'plugin ' . $domain : 'plugin';

    1371. 

  1371. 	} elseif ( 0 === strpos( $dbt5, $wpmu_plugin_dir ) && in_array( $dbt[ 5 ][ 'function' ], $gettext_calls ) ) {

    1372. 

  1372. 		$context = ( $domain != 'default' ) ? 'plugin ' . $domain : 'plugin';

    1373. 

  1373. 	} else {

    1374. 

  1374. 		$context = ( $domain != 'default' ) ? 'theme ' . $domain : 'WordPress';

    1375. 

  1375. 	}

    1376. 

  1376. 

    1377. 

  1377. 	if ( isset( $sitepress_settings[ 'st' ][ 'track_strings' ] ) && $sitepress_settings[ 'st' ][ 'track_strings' ] && current_user_can( 'edit_others_posts' ) ) {

    1378. 

  1378. 		// track strings if the user has enabled this and if it's and editor or admin

    1379. 

  1379. 		icl_st_track_string( $text, $context, ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_PAGE );

    1380. 

  1380. 	}

    1381. 

  1381. 

    1382. 

  1382. 	if($register_dynamic_string) {

    1383. 

  1383. 		// register strings if the user has used ICL_STRING_TRANSLATION_DYNAMIC_CONTEXT (or it's value) as a text domain

    1384. 

  1384. 		icl_register_string($context, $name, $text);

    1385. 

  1385. 	}

    1386. 

  1386. 

    1387. 

  1387. 	if ( empty( $name ) ) {

    1388. 

  1388. 		$name = md5( $text );

    1389. 

  1389. 	}

    1390. 

  1390. 

    1391. 

  1391. 	$ret_translation = icl_t( $context, $name, $text, $has_translation );

    1392. 

  1392. 	if ( false === $has_translation ) {

    1393. 

  1393. 		$ret_translation = $translation;

    1394. 

  1394. 	}

    1395. 

  1395. 

    1396. 

  1396. 	if ( isset( $_GET[ 'icl_string_track_value' ] ) && isset( $_GET[ 'icl_string_track_context' ] )

    1397. 

  1397. 		&& stripslashes( $_GET[ 'icl_string_track_context' ] ) == $context && stripslashes( $_GET[ 'icl_string_track_value' ] ) == $text

    1398. 

  1398. 	) {

    1399. 

  1399. 		$ret_translation = '<span style="background-color:' . $sitepress_settings[ 'st' ][ 'hl_color' ] . '">' . $ret_translation . '</span>';

    1400. 

  1400. 	}

    1401. 

  1401. 

    1402. 

  1402. 	wp_cache_set( $cache_name, $ret_translation );

    1403. 

  1403. 

    1404. 

  1404. 	return $ret_translation;

    1405. 

  1405. }

    1406. 

  1406. 

    1407. 

  1407. function icl_sw_filters_gettext_with_context($translation, $text, $_gettext_context, $domain){

    1408. 

  1408.     return icl_sw_filters_gettext($translation, $text, $domain, $_gettext_context . ': ' . $text);

    1409. 

  1409. }

    1410. 

  1410. 

    1411. 

  1411. function icl_sw_filters_ngettext($translation, $single, $plural, $number, $domain, $_gettext_context = false){    

    1412. 

  1412.     if($number == 1){

    1413. 

  1413.         return icl_sw_filters_gettext($translation, $single, $domain, $_gettext_context);    

    1414. 

  1414.     }else{

    1415. 

  1415.         return icl_sw_filters_gettext($translation, $plural, $domain, $_gettext_context);            

    1416. 

  1416.     }

    1417. 

  1417. }

    1418. 

  1418. 

    1419. 

  1419. function icl_sw_filters_nxgettext($translation, $single, $plural, $number, $_gettext_context, $domain){        

    1420. 

  1420.     return icl_sw_filters_ngettext($translation, $single, $plural, $number, $domain, $_gettext_context);

    1421. 

  1421. }

    1422. 

  1422. 

    1423. 

  1423. function icl_st_author_first_name_filter($value, $user_id){

    1424. 

  1424.     global $sitepress_settings;

    1425. 

  1425.     

    1426. 

  1426.     if(false === $user_id){

    1427. 

  1427.         global $authordata;

    1428. 

  1428.         $user_id = $authordata->data->ID;

    1429. 

  1429.     }

    1430. 

  1430.     

    1431. 

  1431.     $user = new WP_User($user_id);        

    1432. 

  1432.     if ( is_array( $user->roles ) && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1433. 

  1433.         $value = icl_st_translate_author_fields('first_name', $value, $user_id);

    1434. 

  1434.     }

    1435. 

  1435.         

    1436. 

  1436.     return $value;

    1437. 

  1437. }

    1438. 

  1438. 

    1439. 

  1439. function icl_st_author_last_name_filter($value, $user_id){

    1440. 

  1440.     global $sitepress_settings;

    1441. 

  1441.     

    1442. 

  1442.     if(false === $user_id){

    1443. 

  1443.         global $authordata;

    1444. 

  1444.         $user_id = $authordata->data->ID;

    1445. 

  1445.     }

    1446. 

  1446.     

    1447. 

  1447.     $user = new WP_User($user_id);        

    1448. 

  1448.     if ( is_array( $user->roles ) && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1449. 

  1449.         $value = icl_st_translate_author_fields('last_name', $value, $user_id);

    1450. 

  1450.     }

    1451. 

  1451.         

    1452. 

  1452.     return $value;

    1453. 

  1453. }

    1454. 

  1454. 

    1455. 

  1455. function icl_st_author_nickname_filter($value, $user_id){

    1456. 

  1456.     global $sitepress_settings;

    1457. 

  1457. 

    1458. 

  1458.     if(false === $user_id){

    1459. 

  1459.         global $authordata;

    1460. 

  1460.         $user_id = $authordata->data->ID;

    1461. 

  1461.     }

    1462. 

  1462.     

    1463. 

  1463.     $user = new WP_User($user_id);        

    1464. 

  1464.     if ( is_array( $user->roles ) && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1465. 

  1465.         $value = icl_st_translate_author_fields('nickname', $value, $user_id);

    1466. 

  1466.     }

    1467. 

  1467.         

    1468. 

  1468.     return $value;

    1469. 

  1469. }    

    1470. 

  1470. 

    1471. 

  1471. function icl_st_author_description_filter($value, $user_id){

    1472. 

  1472.     global $sitepress_settings;

    1473. 

  1473.     

    1474. 

  1474.     if(false === $user_id){

    1475. 

  1475.         global $authordata;

    1476. 

  1476.         if(empty($authordata->data)) return $value;

    1477. 

  1477.         $user_id = $authordata->data->ID;

    1478. 

  1478.     }

    1479. 

  1479.     

    1480. 

  1480.     $user = new WP_User($user_id);        

    1481. 

  1481. 

    1482. 

  1482. 	if(!isset($sitepress_settings['st']['translated-users'])) $sitepress_settings['st']['translated-users'] = array();

    1483. 

  1483. 

    1484. 

  1484.     if ( is_array( $user->roles ) && is_array($sitepress_settings['st']['translated-users']) && array_intersect($user->roles, $sitepress_settings['st']['translated-users'])){

    1485. 

  1485.         $value = icl_st_translate_author_fields('description', $value, $user_id);

    1486. 

  1486.     }

    1487. 

  1487.     

    1488. 

  1488.     return $value;

    1489. 

  1489. }    

    1490. 

  1490. 

    1491. 

  1491. function icl_st_author_displayname_filter($value){

    1492. 

  1492.     global $authordata, $sitepress_settings;

    1493. 

  1493.     

    1494. 

  1494.     if(isset($authordata->ID)){    

    1495. 

  1495.         $user = new WP_User($authordata->ID);        

    1496. 

  1496.         if ( is_array( $user->roles ) && isset($sitepress_settings['st']['translated-users']) && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1497. 

  1497.             $value = icl_st_translate_author_fields('display_name', $value, isset($authordata->ID)?$authordata->ID:null);

    1498. 

  1498.         }

    1499. 

  1499.     }

    1500. 

  1500.     

    1501. 

  1501.     return $value;

    1502. 

  1502. }        

    1503. 

  1503. 

    1504. 

  1504. function icl_st_translate_author_fields($field, $value, $user_id){

    1505. 

  1505.     global $sitepress_settings, $sitepress;

    1506. 

  1506.     

    1507. 

  1507.     $current_user = $sitepress->get_current_user();

    1508. 

  1508.     

    1509. 

  1509.     if(empty($user_id)) $user_id = $current_user->ID;

    1510. 

  1510. 	if(!isset($sitepress_settings['st']['translated-users'])) $sitepress_settings['st']['translated-users'] = array();

    1511. 

  1511.     

    1512. 

  1512.     $user = new WP_User($user_id);        

    1513. 

  1513.     if ( is_array( $user->roles ) && is_array($sitepress_settings['st']['translated-users'])  && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1514. 

  1514.         $value = icl_translate('Authors', $field . '_' . $user_id, $value, true);

    1515. 

  1515.     }

    1516. 

  1516. 

    1517. 

  1517.     return $value;

    1518. 

  1518. }

    1519. 

  1519. 

    1520. 

  1520. function icl_st_register_user_strings($user_id){

    1521. 

  1521.     global $sitepress_settings;

    1522. 

  1522.     

    1523. 

  1523.     $user = new WP_User($user_id);        

    1524. 

  1524. 

    1525. 

  1525. 	if(!isset($sitepress_settings['st']['translated-users'])) $sitepress_settings['st']['translated-users'] = array();

    1526. 

  1526. 

    1527. 

  1527.     if ( is_array( $user->roles ) && is_array($sitepress_settings['st']['translated-users'])  && array_intersect($user->roles, (array)$sitepress_settings['st']['translated-users'])){

    1528. 

  1528.         $fields = array('first_name', 'last_name', 'nickname', 'description');                  

    1529. 

  1529.         foreach($fields as $field){

    1530. 

  1530.             icl_register_string('Authors', $field . '_' . $user_id, get_the_author_meta($field, $user_id), true, true);

    1531. 

  1531.         }

    1532. 

  1532.         

    1533. 

  1533.         icl_register_string('Authors', 'display_name_' . $user_id, $user->display_name, true, true);    

    1534. 

  1534.     }

    1535. 

  1535. } 

    1536. 

  1536.     

    1537. 

  1537. function icl_st_register_user_strings_all(){

    1538. 

  1538.     global $wpdb;

    1539. 

  1539.     $users = get_users(array('blog_id'=>$wpdb->blogid, 'fields'=>'ID'));

    1540. 

  1540.     foreach($users as $uid){

    1541. 

  1541.         icl_st_register_user_strings($uid);

    1542. 

  1542.     }    

    1543. 

  1543. }

    1544. 

  1544. 

    1545. 

  1545. function icl_st_update_string_actions($context, $name, $old_value, $new_value, $force_complete = false){

    1546. 

  1546.     global $wpdb;  

    1547. 

  1547.     if($new_value != $old_value){        

    1548. 

  1548.         $string = $wpdb->get_row($wpdb->prepare("SELECT id, value, status FROM {$wpdb->prefix}icl_strings WHERE context=%s AND name=%s", $context, $name));    

    1549. 

  1549.         if(!$string){

    1550. 

  1550.             icl_register_string($context, $name, $new_value);

    1551. 

  1551.             return;

    1552. 

  1552.         }

    1553. 

  1553.         $wpdb->update($wpdb->prefix . 'icl_strings', array('value'=>$new_value), array('id'=>$string->id));

    1554. 

  1554.         if($string->status == ICL_STRING_TRANSLATION_COMPLETE || $string->status == ICL_STRING_TRANSLATION_PARTIAL){

    1555. 

  1555. 	        /*if $force_complete is set to true, all translations will be marked as complete even if a string's original value is updated

    1556. 

  1556. 	        This is currently only used to allow editing tagline and blogname for one language, without influencing other languages

    1557. 

  1557. 	        */

    1558. 

  1558. 	        if ( $force_complete ) {

    1559. 

  1559. 		        $new_status = ICL_STRING_TRANSLATION_COMPLETE;

    1560. 

  1560. 	        } else {

    1561. 

  1561. 		        $new_status = ICL_STRING_TRANSLATION_NEEDS_UPDATE;

    1562. 

  1562. 	        }

    1563. 

  1563.             $wpdb->update($wpdb->prefix . 'icl_string_translations', array('status'=>$new_status), array('string_id'=>$string->id));

    1564. 

  1564.             $wpdb->update($wpdb->prefix . 'icl_strings', array('status'=>$new_status), array('id'=>$string->id));

    1565. 

  1565.         }

    1566. 

  1566.         

    1567. 

  1567.         if($context == 'Widgets' && $new_value){

    1568. 

  1568.             if(0 === strpos($name, 'widget title - ')){

    1569. 

  1569.                 icl_rename_string('Widgets', 'widget title - ' . md5($old_value), 'widget title - ' . md5($new_value));

    1570. 

  1570.             }elseif(0 === strpos($name, 'widget body - ')){

    1571. 

  1571.                 icl_rename_string('Widgets', 'widget body - ' . md5($old_value), 'widget body - ' . md5($new_value));

    1572. 

  1572.             }

    1573. 

  1573.         }        

    1574. 

  1574.         

    1575. 

  1575.     }

    1576. 

  1576.     

    1577. 

  1577. }

    1578. 

  1578. 

    1579. 

  1579. function icl_st_update_blogname_actions($old, $new){

    1580. 

  1580.     icl_st_update_string_actions('WP', 'Blog Title', $old, $new, true );

    1581. 

  1581. }

    1582. 

  1582. 

    1583. 

  1583. function icl_st_update_blogdescription_actions($old, $new){

    1584. 

  1584.     icl_st_update_string_actions('WP', 'Tagline', $old, $new, true );

    1585. 

  1585. }

    1586. 

  1586. 

    1587. 

  1587. function icl_st_update_widget_title_actions($old_options, $new_options){        

    1588. 

  1588.     

    1589. 

  1589.     if(isset($new_options['title'])){ // case of 1 instance only widgets

    1590. 

  1590.         $buf = $new_options;

    1591. 

  1591.         unset($new_options);

    1592. 

  1592.         $new_options[0] = $buf;

    1593. 

  1593.         unset($buf);

    1594. 

  1594.         $buf = $old_options;

    1595. 

  1595.         unset($old_options);

    1596. 

  1596.         $old_options[0] = $buf;

    1597. 

  1597.         unset($buf);        

    1598. 

  1598.     }

    1599. 

  1599.     

    1600. 

  1600.     foreach($new_options as $k=>$o){

    1601. 

  1601.         if(isset($o['title'])){

    1602. 

  1602.             if(isset($old_options[$k]['title']) && $old_options[$k]['title']){

    1603. 

  1603.                 icl_st_update_string_actions('Widgets', 'widget title - ' . md5($old_options[$k]['title']), $old_options[$k]['title'], $o['title']);        

    1604. 

  1604.             }else{                

    1605. 

  1605.                 if($new_options[$k]['title']){          

    1606. 

  1606.                     icl_register_string('Widgets', 'widget title - ' . md5($new_options[$k]['title']), $new_options[$k]['title']);

    1607. 

  1607.                 }                

    1608. 

  1608.             }            

    1609. 

  1609.         }

    1610. 

  1610.     }    

    1611. 

  1611. }

    1612. 

  1612. 

    1613. 

  1613. function icl_st_update_text_widgets_actions($old_options, $new_options){

    1614. 

  1614.     global $sitepress_settings, $wpdb;

    1615. 

  1615.     

    1616. 

  1616.     // remove filter for showing permalinks instead of sticky links while saving

    1617. 

  1617.     $GLOBALS['__disable_absolute_links_permalink_filter'] = 1;

    1618. 

  1618.     

    1619. 

  1619.     $widget_text = get_option('widget_text');    

    1620. 

  1620.     if(is_array($widget_text)){

    1621. 

  1621.         foreach($widget_text as $k=>$w){

    1622. 

  1622.             if(isset($old_options[$k]['text']) && trim($old_options[$k]['text']) && $old_options[$k]['text'] != $w['text']){

    1623. 

  1623.                 $old_md5 = md5($old_options[$k]['text']);

    1624. 

  1624.                 $string = $wpdb->get_row($wpdb->prepare("SELECT id, value, status FROM {$wpdb->prefix}icl_strings WHERE context=%s AND name=%s", 'Widgets', 'widget body - ' . $old_md5));    

    1625. 

  1625.                 if ($string) {

    1626. 

  1626.                     icl_st_update_string_actions('Widgets', 'widget body - ' . $old_md5, $old_options[$k]['text'], $w['text']);

    1627. 

  1627.                 } else {

    1628. 

  1628.                     icl_register_string('Widgets', 'widget body - ' . md5($w['text']), $w['text']);

    1629. 

  1629.                 }

    1630. 

  1630.             }elseif(isset($new_options[$k]['text']) && $old_options[$k]['text']!=$new_options[$k]['text']){

    1631. 

  1631.                 icl_register_string('Widgets', 'widget body - ' . md5($new_options[$k]['text']), $new_options[$k]['text']);

    1632. 

  1632.             }

    1633. 

  1633.         }

    1634. 

  1634.     }

    1635. 

  1635. 

    1636. 

  1636.     // add back the filter for showing permalinks instead of sticky links after saving

    1637. 

  1637.     unset($GLOBALS['__disable_absolute_links_permalink_filter']);

    1638. 

  1638.     

    1639. 

  1639. }

    1640. 

  1640. 

    1641. 

  1641. function icl_t_cache_lookup($context, $name){

    1642. 

  1642.     global $sitepress, $wpdb;

    1643. 

  1643. //	static $front_end_language = false;

    1644. 

  1644.     

    1645. 

  1645.     static $icl_st_cache;

    1646. 

  1646.     $ret_value = false;

    1647. 

  1647. 		

    1648. 

  1648. 		$blog_id = 0;

    1649. 

  1649. 		if (isset($GLOBALS['blog_id'])) {

    1650. 

  1650. 			$blog_id = $GLOBALS['blog_id'];

    1651. 

  1651. 		}

    1652. 

  1652. 

    1653. 

  1653.     $current_language = get_current_string_language( $name );

    1654. 

  1654. 

    1655. 

  1655. 	if(!isset($icl_st_cache[$blog_id][$current_language][$context])){  //CACHE MISS (context)

    1656. 

  1656.         

    1657. 

  1657.         $icl_st_cache[$blog_id][$current_language][$context] = array();

    1658. 

  1658.         // workaround for multi-site setups - part i

    1659. 

  1659. 				// @todo find out why somebody added this workaround, now workarounded again by konrad (part $name != "Blog Title" )

    1660. 

  1660.         global $switched, $_wp_switched_stack;

    1661. 

  1661.         if(isset($switched) && $switched && $_wp_switched_stack && $name != "Blog Title"){

    1662. 

  1662.             $prev_blog_id = $wpdb->blogid;

    1663. 

  1663.             $wpdb->set_blog_id($_wp_switched_stack[0]);

    1664. 

  1664.         }

    1665. 

  1665.         

    1666. 

  1666.         // THE QUERY

    1667. 

  1667.         $res = $wpdb->get_results($wpdb->prepare("

    1668. 

  1668.             SELECT s.name, s.value, t.value AS translation_value, t.status

    1669. 

  1669.             FROM  {$wpdb->prefix}icl_strings s

    1670. 

  1670.             LEFT JOIN {$wpdb->prefix}icl_string_translations t ON s.id = t.string_id

    1671. 

  1671.             WHERE s.context = %s

    1672. 

  1672.                 AND (t.language = %s OR t.language IS NULL)

    1673. 

  1673.             ", $context, $current_language), ARRAY_A);        

    1674. 

  1674.         // workaround for multi-site setups - part ii

    1675. 

  1675.         if(isset($switched) && $switched && $_wp_switched_stack && $name != "Blog Title"){

    1676. 

  1676.             $wpdb->set_blog_id($prev_blog_id);

    1677. 

  1677.         }   

    1678. 

  1678. 

    1679. 

  1679.         // SAVE QUERY RESULTS

    1680. 

  1680.         if($res){

    1681. 

  1681.             foreach($res as $row){                

    1682. 

  1682.                 if($row['status'] != ICL_STRING_TRANSLATION_COMPLETE || empty($row['translation_value'])){

    1683. 

  1683.                     $icl_st_cache[$blog_id][$current_language][$context][$row['name']]['translated'] = false;

    1684. 

  1684.                     $icl_st_cache[$current_language][$context][$row['name']]['value'] = $row['value'];

    1685. 

  1685.                 }else{

    1686. 

  1686.                     $icl_st_cache[$blog_id][$current_language][$context][$row['name']]['translated'] = true;

    1687. 

  1687.                     $icl_st_cache[$blog_id][$current_language][$context][$row['name']]['value'] = $row['translation_value'];

    1688. 

  1688.                     $icl_st_cache[$blog_id][$current_language][$context][$row['name']]['original'] = $row['value'];

    1689. 

  1689.                 }

    1690. 

  1690.             }

    1691. 

  1691.         }

    1692. 

  1692.         

    1693. 

  1693.     }

    1694. 

  1694.         

    1695. 

  1695.     if(isset($icl_st_cache[$blog_id][$current_language][$context][$name])){           

    1696. 

  1696.         $ret_value = $icl_st_cache[$blog_id][$current_language][$context][$name];                             

    1697. 

  1697.     }    

    1698. 

  1698.         

    1699. 

  1699.     return $ret_value;    

    1700. 

  1700. }

    1701. 

  1701. 

    1702. 

  1702. function icl_st_get_contexts($status){

    1703. 

  1703.     global $wpdb, $sitepress, $sitepress_settings;    

    1704. 

  1704.     $extra_cond = '';

    1705. 

  1705. 	$joins = '';

    1706. 

  1706. 	$results = false;

    1707. 

  1707. 

    1708. 

  1708.     $current_user = $sitepress->get_current_user();

    1709. 

  1709.     

    1710. 

  1710.     if($status !== false){

    1711. 

  1711.         if($status == ICL_STRING_TRANSLATION_COMPLETE){

    1712. 

  1712.             $extra_cond .= " AND s.status = " . ICL_STRING_TRANSLATION_COMPLETE;

    1713. 

  1713.         }else{

    1714. 

  1714.             $extra_cond .= " AND s.status IN (" . ICL_STRING_TRANSLATION_PARTIAL . "," . ICL_STRING_TRANSLATION_NEEDS_UPDATE . "," . ICL_STRING_TRANSLATION_NOT_TRANSLATED . ")";

    1715. 

  1715.         }        

    1716. 

  1716.     }

    1717. 

  1717. 

    1718. 

  1718.     if(icl_st_is_translator()){

    1719. 

  1719.         $user_langs = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);

    1720. 

  1720. 

    1721. 

  1721.         $active_langs = $sitepress->get_active_languages();

    1722. 

  1722.         if(!empty($user_langs[$sitepress_settings['st']['strings_language']])){

    1723. 

  1723.             

    1724. 

  1724.             foreach($user_langs[$sitepress_settings['st']['strings_language']] as $lang=>$one){

    1725. 

  1725.                 if(isset($active_langs[$lang])){

    1726. 

  1726.                     $lcode_alias = str_replace('-', '', $lang);

    1727. 

  1727.                     $joins[] = " JOIN {$wpdb->prefix}icl_string_translations {$lcode_alias}_str ON {$lcode_alias}_str.string_id = s.id AND {$lcode_alias}_str.language='{$lcode_alias}' AND

    1728. 

  1728.                     ( 

    1729. 

  1729.                         {$lcode_alias}_str.status = " . ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR . 

    1730. 

  1730.                         " OR {$lcode_alias}_str.translator_id = " . $current_user->ID

    1731. 

  1731.                     . ")" . "\n";

    1732. 

  1732.                         

    1733. 

  1733.                 }            

    1734. 

  1734.                 

    1735. 

  1735.             }            

    1736. 

  1736.             

    1737. 

  1737.             $sql = "

    1738. 

  1738.                 SELECT s.context, COUNT(s.context) AS c FROM {$wpdb->prefix}icl_strings s

    1739. 

  1739.                 ".join("\n", $joins)."

    1740. 

  1740.                 WHERE 1 {$extra_cond} 

    1741. 

  1741.                 GROUP BY context

    1742. 

  1742.                 ORDER BY context ASC

    1743. 

  1743.             ";

    1744. 

  1744. 	        

    1745. 

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

    1746. 

  1746.         }

    1747. 

  1747.         

    1748. 

  1748.     }else{

    1749. 

  1749.         $results = $wpdb->get_results( $wpdb->prepare("

    1750. 

  1750.             SELECT context, COUNT(context) AS c

    1751. 

  1751.             FROM {$wpdb->prefix}icl_strings s

    1752. 

  1752.             WHERE language=%s {$extra_cond}

    1753. 

  1753.             GROUP BY context 

    1754. 

  1754.             ORDER BY context ASC", $sitepress_settings['st']['strings_language']));

    1755. 

  1755.         

    1756. 

  1756.     }

    1757. 

  1757.     

    1758. 

  1758.     return $results;

    1759. 

  1759. }

    1760. 

  1760. 

    1761. 

  1761. function icl_st_admin_notices(){

    1762. 

  1762.     global $icl_st_err_str;

    1763. 

  1763.     if($icl_st_err_str){

    1764. 

  1764.         echo '<div class="error"><p>' . $icl_st_err_str . '</p></div>';

    1765. 

  1765.     }    

    1766. 

  1766. }

    1767. 

  1767. 

    1768. 

  1768. function icl_st_scan_theme_files($dir = false, $recursion = 0){

    1769. 

  1769.     require_once ICL_PLUGIN_PATH . '/inc/potx.php';

    1770. 

  1770.     static $scan_stats = false;

    1771. 

  1771.     static $recursion, $scanned_files = array();

    1772. 

  1772.     global $icl_scan_theme_found_domains, $sitepress, $sitepress_settings;

    1773. 

  1773.     if($dir === false){  

    1774. 

  1774.         $dir = TEMPLATEPATH;

    1775. 

  1775.     }

    1776. 

  1776.     if(!$scan_stats){

    1777. 

  1777.         $scan_stats = sprintf(__('Scanning theme folder: %s', 'wpml-string-translation'),$dir) . PHP_EOL;

    1778. 

  1778.     }    

    1779. 

  1779.                             

    1780. 

  1780.     $dh = opendir($dir);    

    1781. 

  1781.     while(false !== ($file = readdir($dh))){

    1782. 

  1782. 		if(0 === strpos($file, '.')) continue;

    1783. 

  1783.         

    1784. 

  1784.         if(is_dir($dir . "/" . $file)){

    1785. 

  1785.             $recursion++;

    1786. 

  1786.             $scan_stats .= str_repeat("\t",$recursion) . sprintf(__('Opening folder: %s', 'wpml-string-translation'), $dir . "/" . $file) . PHP_EOL;

    1787. 

  1787.             icl_st_scan_theme_files($dir . "/" . $file, $recursion);            

    1788. 

  1788.             $recursion--;

    1789. 

  1789.         }elseif(preg_match('#(\.php|\.inc)$#i', $file)){     

    1790. 

  1790.             // THE potx way

    1791. 

  1791.             $scan_stats .=  str_repeat("\t",$recursion) . sprintf(__('Scanning file: %s', 'wpml-string-translation'), $dir . "/" . $file) . PHP_EOL;

    1792. 

  1792.             $scanned_files[] = $dir . "/" . $file;

    1793. 

  1793.             _potx_process_file($dir . "/" . $file, 0, '__icl_st_scan_theme_files_store_results','_potx_save_version', POTX_API_7);

    1794. 

  1794.         }else{

    1795. 

  1795.             $scan_stats .=  str_repeat("\t",$recursion) . sprintf(__('Skipping file: %s', 'wpml-string-translation'), $dir . "/" . $file) . PHP_EOL;    

    1796. 

  1796.         }

    1797. 

  1797.     }

    1798. 

  1798.     

    1799. 

  1799.     if($dir == TEMPLATEPATH && TEMPLATEPATH != STYLESHEETPATH){

    1800. 

  1800.         static $double_scan = true;

    1801. 

  1801.         icl_st_scan_theme_files(STYLESHEETPATH);            

    1802. 

  1802.         $double_scan = false;

    1803. 

  1803.     }

    1804. 

  1804.     

    1805. 

  1805.     if(!$recursion && (empty($double_scan) || !$double_scan)){

    1806. 

  1806.         global $__icl_registered_strings;

    1807. 

  1807.         $scan_stats .= __('Done scanning files', 'wpml-string-translation') . PHP_EOL;

    1808. 

  1808.             $sitepress_settings['st']['theme_localization_domains'] = array_keys($icl_scan_theme_found_domains);

    1809. 

  1809.             $sitepress->save_settings($sitepress_settings);

    1810. 

  1810.             closedir($dh);

    1811. 

  1811.             $scan_stats_all = __('= Your theme was scanned for texts =', 'wpml-string-translation') . '<br />' . 

    1812. 

  1812.                           __('The following files were processed:', 'wpml-string-translation') . '<br />' .

    1813. 

  1813.                           '<ol style="font-size:10px;"><li>' . join('</li><li>', $scanned_files) . '</li></ol>' . 

    1814. 

  1814.                           sprintf(__('WPML found %s strings. They were added to the string translation table.','wpml-string-translation'),count($__icl_registered_strings)) . 

    1815. 

  1815.                           '<br /><a href="#" onclick="jQuery(this).next().toggle();return false;">' . __('More details', 'wpml-string-translation') . '</a>'.

    1816. 

  1816.                           '<textarea style="display:none;width:100%;height:150px;font-size:10px;">' . $scan_stats . '</textarea>'; 

    1817. 

  1817.             return $scan_stats_all;

    1818. 

  1818.     }

    1819. 

  1819.     

    1820. 

  1820. }

    1821. 

  1821.                                                 

    1822. 

  1822. function __icl_st_scan_theme_files_store_results($string, $domain, $_gettext_context, $file, $line){

    1823. 

  1823.     

    1824. 

  1824.     global $icl_scan_theme_found_domains;

    1825. 

  1825. 

    1826. 

  1826.     $string = str_replace(array('\"',"\\'"), array('"',"'"), $string);

    1827. 

  1827.     //replace extra backslashes added by _potx_process_file

    1828. 

  1828.     $string = str_replace(array('\\\\'), array('\\'), $string);

    1829. 

  1829.     

    1830. 

  1830.     if(!isset($icl_scan_theme_found_domains[$domain])){

    1831. 

  1831.         $icl_scan_theme_found_domains[$domain] = true;

    1832. 

  1832.     }

    1833. 

  1833.     global $wpdb, $__icl_registered_strings;

    1834. 

  1834.     

    1835. 

  1835.     $context = false;

    1836. 

  1836.     

    1837. 

  1837.     if(!isset($__icl_registered_strings)){

    1838. 

  1838.         $__icl_registered_strings = array();

    1839. 

  1839.         

    1840. 

  1840.         // clear existing entries (both source and page type)

    1841. 

  1841.         $context  = $domain ? 'theme ' . $domain : 'WordPress';

    1842. 

  1842.         $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_string_positions WHERE string_id IN 

    1843. 

  1843.             (SELECT id FROM {$wpdb->prefix}icl_strings WHERE context = %s)", $context));        

    1844. 

  1844.     }

    1845. 

  1845.     

    1846. 

  1846.     if(!isset($__icl_registered_strings[$domain.'||'.$string.'||'.$_gettext_context])){

    1847. 

  1847.         if(!$domain){

    1848. 

  1848.             $context = 'WordPress';

    1849. 

  1849.         }else{

    1850. 

  1850.             $context = 'theme ' . $domain;            

    1851. 

  1851.         }        

    1852. 

  1852.         

    1853. 

  1853.         $name = $_gettext_context ? $_gettext_context . ': ' . $string  : md5($string);

    1854. 

  1854.         icl_register_string($context, $name, $string);

    1855. 

  1855.         

    1856. 

  1856.         $__icl_registered_strings[$domain.'||'.$string.'||'.$_gettext_context] = true;

    1857. 

  1857.     }                

    1858. 

  1858.     

    1859. 

  1859.     // store position in source

    1860. 

  1860.     icl_st_track_string($string, $context, ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_SOURCE, $file, $line);              

    1861. 

  1861. }

    1862. 

  1862. 

    1863. 

  1863. function icl_st_scan_plugin_files($plugin, $recursion = 0){

    1864. 

  1864.     require_once ICL_PLUGIN_PATH . '/inc/potx.php';

    1865. 

  1865.     static $recursion, $scanned_files = array();

    1866. 

  1866.     static $scan_stats = false;

    1867. 

  1867.     global $icl_scan_plugin_found_domains, $icl_st_p_scan_plugin_id,

    1868. 

  1868.            $sitepress, $sitepress_settings;

    1869. 

  1869.     

    1870. 

  1870.     if(!$recursion){

    1871. 

  1871.         $icl_st_p_scan_plugin_id = str_replace(WP_PLUGIN_DIR .'/', '', $plugin);

    1872. 

  1872.         $icl_st_p_scan_plugin_id = str_replace(WPMU_PLUGIN_DIR .'/', '', $icl_st_p_scan_plugin_id);

    1873. 

  1873.     }

    1874. 

  1874.     

    1875. 

  1875.     if(is_file($plugin) && !$recursion){ // case of one-file plugins

    1876. 

  1876.         $scan_stats = sprintf(__('Scanning file: %s', 'wpml-string-translation'), $plugin) . PHP_EOL;

    1877. 

  1877.         _potx_process_file($plugin, 0, '__icl_st_scan_plugin_files_store_results','_potx_save_version', POTX_API_7);                    

    1878. 

  1878.         $scanned_files[] = $plugin;

    1879. 

  1879.     }else{

    1880. 

  1880.         $dh = opendir($plugin);    

    1881. 

  1881.         while(false !== ($file = readdir($dh))){

    1882. 

  1882.             if(0 === strpos($file, '.')) continue;

    1883. 

  1883.             if(is_dir($plugin . "/" . $file)){

    1884. 

  1884.                 $recursion++;

    1885. 

  1885.                 $scan_stats .= str_repeat("\t",$recursion-1) . sprintf(__('Opening folder: %s', 'wpml-string-translation'), "/" . $file) . PHP_EOL;

    1886. 

  1886.                 icl_st_scan_plugin_files($plugin . "/" . $file, $recursion);            

    1887. 

  1887.                 $recursion--;

    1888. 

  1888.             }elseif(preg_match('#(\.php|\.inc)$#i', $file)){     

    1889. 

  1889.                 $scan_stats .=  str_repeat("\t",$recursion) . sprintf(__('Scanning file: %s', 'wpml-string-translation'), "/" . $file) . PHP_EOL;

    1890. 

  1890.                 $scanned_files[] = "/" . $file;

    1891. 

  1891.                 _potx_process_file($plugin . "/" . $file, 0, '__icl_st_scan_plugin_files_store_results','_potx_save_version', POTX_API_7);

    1892. 

  1892.             }else{

    1893. 

  1893.                 $scan_stats .=  str_repeat("\t",$recursion) . sprintf(__('Skipping file: %s', 'wpml-string-translation'), "/" . $file) . PHP_EOL;    

    1894. 

  1894.             }

    1895. 

  1895.         }        

    1896. 

  1896.     }

    1897. 

  1897.     

    1898. 

  1898.     

    1899. 

  1899.     if(!$recursion){

    1900. 

  1900.         global $__icl_registered_strings;

    1901. 

  1901.         if(is_null($__icl_registered_strings)){

    1902. 

  1902.             $__icl_registered_strings = array();    

    1903. 

  1903.         }        

    1904. 

  1904.         $scan_stats .= __('Done scanning files', 'wpml-string-translation') . PHP_EOL;                    

    1905. 

  1905.         

    1906. 

  1906.         /*

    1907. 

  1907.         if(is_array($icl_scan_plugin_found_domains)){

    1908. 

  1908.             $existing_domains = $sitepress_settings['st']['plugins_localization_domains'];

    1909. 

  1909.             if(is_array($existing_domains)){

    1910. 

  1910.                 $sitepress_settings['st']['plugins_localization_domains'] = array_unique(array_merge(array_keys($icl_scan_plugin_found_domains), $existing_domains));

    1911. 

  1911.             }else{

    1912. 

  1912.                 $sitepress_settings['st']['plugins_localization_domains'] = array_keys($icl_scan_plugin_found_domains);

    1913. 

  1913.             }

    1914. 

  1914.             $sitepress->save_settings($sitepress_settings);

    1915. 

  1915.         }

    1916. 

  1916.         */

    1917. 

  1917.         

    1918. 

  1918.         unset($icl_st_p_scan_plugin_id);        

    1919. 

  1919.         $scan_stats = '<textarea style="width:100%;height:150px;font-size:10px;">' . $scan_stats . "\n" .

    1920. 

  1920.                        count($scanned_files) . ' scanned files' . "\n";    

    1921. 

  1921.         if(count($__icl_registered_strings)){

    1922. 

  1922.             $scan_stats .=  sprintf(__('WPML found %s strings. They were added to the string translation table.','wpml-string-translation'),count($__icl_registered_strings)) . "\n";

    1923. 

  1923.         }else{

    1924. 

  1924.             $scan_stats .=  __('No strings found.','wpml-string-translation') . "\n";

    1925. 

  1925.         }

    1926. 

  1926.         $scan_stats .= '</textarea>';

    1927. 

  1927.                         

    1928. 

  1928.         

    1929. 

  1929.         $scan_stats_ret = $scan_stats;               

    1930. 

  1930.         

    1931. 

  1931.         $scan_stats = false;

    1932. 

  1932.         

    1933. 

  1933.         return $scan_stats_ret;

    1934. 

  1934.     }    

    1935. 

  1935.     

    1936. 

  1936. }

    1937. 

  1937. 

    1938. 

  1938. function __icl_st_scan_plugin_files_store_results($string, $domain, $_gettext_context, $file, $line){

    1939. 

  1939.     global $icl_scan_plugin_found_domains, $icl_st_p_scan_plugin_id;

    1940. 

  1940.     

    1941. 

  1941.     $string = str_replace(array('\"',"\\'"), array('"',"'"), $string);

    1942. 

  1942.     //replace extra backslashes added by _potx_process_file

    1943. 

  1943.     $string = str_replace(array('\\\\'), array('\\'), $string);        

    1944. 

  1944.         

    1945. 

  1945.     //if(!isset($icl_scan_plugin_found_domains[$domain])){

    1946. 

  1946.     //    $icl_scan_plugin_found_domains[$domain] = true;

    1947. 

  1947.     //}    

    1948. 

  1948.     global $wpdb, $__icl_registered_strings;

    1949. 

  1949.     if(empty($__icl_registered_strings) ){

    1950. 

  1950.         $__icl_registered_strings = array();

    1951. 

  1951.         

    1952. 

  1952.         // clear existing entries (both source and page type)        

    1953. 

  1953.         $context  = $icl_st_p_scan_plugin_id ? 'plugin ' . $icl_st_p_scan_plugin_id : 'plugins';

    1954. 

  1954. 				$wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->prefix}icl_string_positions WHERE string_id IN 

    1955. 

  1955.             (SELECT id FROM {$wpdb->prefix}icl_strings WHERE context = %s)", $context)); 

    1956. 

  1956.     }

    1957. 

  1957.     

    1958. 

  1958.     if(!isset($__icl_registered_strings[$icl_st_p_scan_plugin_id.'||'.$string])){

    1959. 

  1959.         

    1960. 

  1960.         $name = $_gettext_context ? $_gettext_context . ': ' . $string  : md5($string);

    1961. 

  1961.         

    1962. 

  1962.         if(!$domain){

    1963. 

  1963.             icl_register_string('plugins', $name, $string);

    1964. 

  1964.         }else{

    1965. 

  1965.             icl_register_string('plugin ' . $icl_st_p_scan_plugin_id, $name, $string);

    1966. 

  1966.         }        

    1967. 

  1967.         $__icl_registered_strings[$icl_st_p_scan_plugin_id.'||'.$string] = true;

    1968. 

  1968.     }  

    1969. 

  1969.     

    1970. 

  1970.     // store position in source

    1971. 

  1971.     icl_st_track_string($string, 'plugin ' . $icl_st_p_scan_plugin_id, ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_SOURCE, $file, $line);              

    1972. 

  1972.     

    1973. 

  1973. }

    1974. 

  1974. 

    1975. 

  1975. function get_theme_localization_stats(){

    1976. 

  1976.     global $sitepress_settings, $wpdb;

    1977. 

  1977.     $stats = false;

    1978. 

  1978.     if(isset($sitepress_settings['st']['theme_localization_domains'])){    

    1979. 

  1979.         foreach((array)$sitepress_settings['st']['theme_localization_domains'] as $domain){

    1980. 

  1980.             $domains[] = $domain ? 'theme ' . $domain : 'theme';

    1981. 

  1981.         }

    1982. 

  1982.         $results = $wpdb->get_results("

    1983. 

  1983.             SELECT context, status, COUNT(id) AS c 

    1984. 

  1984.             FROM {$wpdb->prefix}icl_strings

    1985. 

  1985.             WHERE context IN ('".join("','",$domains)."')

    1986. 

  1986.             GROUP BY context, status            

    1987. 

  1987.         ");

    1988. 

  1988.         foreach($results as $r){

    1989. 

  1989.             if(!isset($stats[$r->context]['complete'])){

    1990. 

  1990.                 $stats[$r->context]['complete'] = 0;

    1991. 

  1991.             }

    1992. 

  1992.             if(!isset($stats[$r->context]['incomplete'])){

    1993. 

  1993.                 $stats[$r->context]['incomplete'] = 0;

    1994. 

  1994.             }            

    1995. 

  1995.             if($r->status == ICL_STRING_TRANSLATION_COMPLETE){

    1996. 

  1996.                 $stats[$r->context]['complete'] = $r->c; 

    1997. 

  1997.             }else{

    1998. 

  1998.                 $stats[$r->context]['incomplete'] += $r->c; 

    1999. 

  1999.             }

    2000. 

  2000.             

    2001. 

  2001.         }

    2002. 

  2002.     }

    2003. 

  2003.    return $stats; 

    2004. 

  2004. }

    2005. 

  2005. 

    2006. 

  2006. function get_plugin_localization_stats(){

    2007. 

  2007.     global $sitepress_settings, $wpdb;

    2008. 

  2008.     $stats = false;

    2009. 

  2009. 

    2010. 

  2010.     $results = $wpdb->get_results("

    2011. 

  2011.         SELECT context, status, COUNT(id) AS c 

    2012. 

  2012.         FROM {$wpdb->prefix}icl_strings

    2013. 

  2013.         WHERE context LIKE ('plugin %')

    2014. 

  2014.         GROUP BY context, status            

    2015. 

  2015.     ");

    2016. 

  2016.     

    2017. 

  2017.     foreach($results as $r){

    2018. 

  2018.         if(!isset($stats[$r->context]['complete'])){

    2019. 

  2019.             $stats[$r->context]['complete'] = 0;

    2020. 

  2020.         }

    2021. 

  2021.         if(!isset($stats[$r->context]['incomplete'])){

    2022. 

  2022.             $stats[$r->context]['incomplete'] = 0;

    2023. 

  2023.         }            

    2024. 

  2024.         if($r->status == ICL_STRING_TRANSLATION_COMPLETE){

    2025. 

  2025.             $stats[$r->context]['complete'] = $r->c; 

    2026. 

  2026.         }else{

    2027. 

  2027.             $stats[$r->context]['incomplete'] += $r->c; 

    2028. 

  2028.         }

    2029. 

  2029.         

    2030. 

  2030.     }

    2031. 

  2031.     

    2032. 

  2032.     return $stats;     

    2033. 

  2033. }

    2034. 

  2034. 

    2035. 

  2035. function icl_st_generate_po_file($strings, $potonly = false){

    2036. 

  2036. 

    2037. 

  2037.     

    2038. 

  2038.     require_once('po_parser.class.php');

    2039. 

  2039.     

    2040. 

  2040.     $po = po_parser::create_po( $strings, $potonly = false );

    2041. 

  2041.     

    2042. 

  2042.     return $po;

    2043. 

  2043. }

    2044. 

  2044. 

    2045. 

  2045. function icl_st_track_string($text, $context, $kind = ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_PAGE, $file = null, $line = null){

    2046. 

  2046.     global $wpdb;

    2047. 

  2047.     // get string id

    2048. 

  2048.     $string_id = $wpdb->get_var("SELECT id FROM {$wpdb->prefix}icl_strings WHERE context='".esc_sql($context)."' AND value='".esc_sql($text)."'");    

    2049. 

  2049.     if($string_id){

    2050. 

  2050.         // get existing records

    2051. 

  2051.         $string_records_count = $wpdb->get_var("SELECT COUNT(id) 

    2052. 

  2052.                                         FROM {$wpdb->prefix}icl_string_positions 

    2053. 

  2053.                                         WHERE string_id = '{$string_id}' AND kind = " . $kind);

    2054. 

  2054.         if(ICL_STRING_TRANSLATION_STRING_TRACKING_THRESHOLD > $string_records_count){        

    2055. 

  2055.             if($kind == ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_PAGE){

    2056. 

  2056.                 // get page url

    2057. 

  2057.                 $https = isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on' ? 's':'';

    2058. 

  2058.                 $position = 'http' . $https . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];

    2059. 

  2059.             }else{

    2060. 

  2060.                 $position = $file . '::' . $line;

    2061. 

  2061.             }

    2062. 

  2062.             

    2063. 

  2063.             if(!$wpdb->get_var("SELECT id FROM {$wpdb->prefix}icl_string_positions 

    2064. 

  2064.                                 WHERE string_id='{$string_id}' AND position_in_page='".esc_sql($position)."' AND kind='".$kind."'")){

    2065. 

  2065.                 $wpdb->insert($wpdb->prefix . 'icl_string_positions', array(

    2066. 

  2066.                     'string_id' => $string_id,

    2067. 

  2067.                     'kind' => $kind,

    2068. 

  2068.                     'position_in_page' => $position

    2069. 

  2069.                 ));                    

    2070. 

  2070.             }

    2071. 

  2071.             

    2072. 

  2072.         }

    2073. 

  2073.     }

    2074. 

  2074. }

    2075. 

  2075. 

    2076. 

  2076. function icl_st_string_in_page($string_id){

    2077. 

  2077.     global $wpdb;

    2078. 

  2078.     // get urls   

    2079. 

  2079.     $urls = $wpdb->get_col($wpdb->prepare("SELECT position_in_page 

    2080. 

  2080.                             FROM {$wpdb->prefix}icl_string_positions 

    2081. 

  2081.                             WHERE string_id = %d AND kind = %d", $string_id, ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_PAGE));

    2082. 

  2082.     if(!empty($urls)){

    2083. 

  2083.         $string = $wpdb->get_row($wpdb->prepare("SELECT context, value FROM {$wpdb->prefix}icl_strings WHERE id=%d", $string_id));

    2084. 

  2084.         echo '<div id="icl_show_source_top">';

    2085. 

  2085.         for($i = 0; $i < count($urls); $i++){

    2086. 

  2086.             $c = $i+1;

    2087. 

  2087.             if(strpos($urls[$i], '?') !== false){

    2088. 

  2088.                 $urls[$i] .= '&icl_string_track_value=' . $string->value;

    2089. 

  2089.             }else{

    2090. 

  2090.                 $urls[$i] .= '?icl_string_track_value=' . $string->value;

    2091. 

  2091.             }            

    2092. 

  2092.             $urls[$i] .= '&icl_string_track_context=' . $string->context;

    2093. 

  2093. 

    2094. 

  2094.             echo '<a href="#" onclick="jQuery(\'#icl_string_track_frame_wrap iframe\').attr(\'src\',\''.esc_url($urls[$i]).'\');jQuery(\'#icl_string_track_url a\').html(\''.esc_url($urls[$i]).'\').attr(\'href\',  \''.esc_url($urls[$i]).'\'); return false;">'.$c.'</a><br />';

    2095. 

  2095.             

    2096. 

  2096.         }

    2097. 

  2097.         echo '</div>';

    2098. 

  2098.         echo '<div id="icl_string_track_frame_wrap">';        

    2099. 

  2099.         echo '<iframe onload="iclResizeIframe()" src="'.$urls[0].'" width="10" height="10" frameborder="0" marginheight="0" marginwidth="0"></iframe>';

    2100. 

  2100.         echo '<div id="icl_string_track_url" class="icl_string_track_url"><a href="'.esc_url($urls[0]).'">' . esc_html($urls[0]) . "</a></div>\n";

    2101. 

  2101.         echo '</div>';        

    2102. 

  2102.     }else{

    2103. 

  2103.         _e('No records found', 'wpml-string-translation');

    2104. 

  2104.     }

    2105. 

  2105. }

    2106. 

  2106. 

    2107. 

  2107. function icl_st_string_in_source($string_id){

    2108. 

  2108.     global $wpdb, $sitepress_settings;

    2109. 

  2109.     // get positions    

    2110. 

  2110.     $files = $wpdb->get_col($wpdb->prepare("SELECT position_in_page 

    2111. 

  2111.                             FROM {$wpdb->prefix}icl_string_positions 

    2112. 

  2112.                             WHERE string_id = %d AND kind = %d", $string_id, ICL_STRING_TRANSLATION_STRING_TRACKING_TYPE_SOURCE));

    2113. 

  2113.     

    2114. 

  2114.     if(!empty($files)){

    2115. 

  2115.         $string = $wpdb->get_row($wpdb->prepare("SELECT context, value FROM {$wpdb->prefix}icl_strings WHERE id=%d",$string_id));        

    2116. 

  2116.         echo '<div id="icl_show_source_top">';

    2117. 

  2117.         for($i = 0; $i < count($files); $i++){            

    2118. 

  2118.             $c = $i+1;

    2119. 

  2119.             $exp = explode('::', $files[$i]);

    2120. 

  2120.             $line = $exp[1];

    2121. 

  2121.             echo '<a href="#" onclick="icl_show_in_source('.$i.','.$line.')">'.$c.'</a><br />';

    2122. 

  2122.         }

    2123. 

  2123.         echo '</div>';

    2124. 

  2124.         echo '<div id="icl_show_source_wrap">';

    2125. 

  2125.         for($i = 0; $i < count($files); $i++){            

    2126. 

  2126.             $exp = explode('::', $files[$i]);

    2127. 

  2127.             $file = $exp[0];

    2128. 

  2128.             if(!file_exists($file) || !is_readable($file)) continue;

    2129. 

  2129.             $line = $exp[1];

    2130. 

  2130.             echo '<div class="icl_string_track_source" id="icl_string_track_source_'.$i.'"';

    2131. 

  2131.             if($i > 0){

    2132. 

  2132.                 echo 'style="display:none"';

    2133. 

  2133.             }else{

    2134. 

  2134.                 $first_pos = $line;

    2135. 

  2135.             }

    2136. 

  2136.             echo '>';

    2137. 

  2137.             if($i == 0){

    2138. 

  2138.                 echo '<script type="text/javascript">icl_show_in_source_scroll_once = ' . $line . '</script>';

    2139. 

  2139.             }

    2140. 

  2140.             echo '<div class="icl_string_track_filename">' . $file . "</div>\n";

    2141. 

  2141.             echo '<pre>';        

    2142. 

  2142.             $content = file($file);

    2143. 

  2143.             echo '<ol>';

    2144. 

  2144.             $hl_color = !empty($sitepress_settings['st']['hl_color'])?$sitepress_settings['st']['hl_color']:'#FFFF00';

    2145. 

  2145.             foreach($content as $k=>$l){

    2146. 

  2146.                 if($k == $line-1){

    2147. 

  2147.                     $hl =  ' style="background-color:'.$hl_color.';"';

    2148. 

  2148.                 }else{

    2149. 

  2149.                     $hl = '';   

    2150. 

  2150.                 }

    2151. 

  2151.                 echo '<li id="icl_source_line_'.$i.'_'.$k.'"'.$hl.'">' . esc_html($l) . '&nbsp;</li>';

    2152. 

  2152.             }

    2153. 

  2153.             echo '</ol>';

    2154. 

  2154.             echo '</pre>';

    2155. 

  2155.             echo '</div>'; 

    2156. 

  2156.         }

    2157. 

  2157.         echo '</div>';

    2158. 

  2158.     }else{

    2159. 

  2159.         _e('No records found', 'wpml-string-translation');

    2160. 

  2160.     }    

    2161. 

  2161. }

    2162. 

  2162. 

    2163. 

  2163. function _icl_st_hide_random($str){

    2164. 

  2164.     $str = preg_replace('#^((.+)( - ))?([a-z0-9]{32})$#', '$2', $str);

    2165. 

  2165.     return $str;

    2166. 

  2166. }

    2167. 

  2167. 

    2168. 

  2168. function _icl_st_get_options_writes($path){

    2169. 

  2169.     static $found_writes = array();

    2170. 

  2170.     if(is_dir($path)){        

    2171. 

  2171.         $dh = opendir($path);

    2172. 

  2172.         while($file = readdir($dh)){

    2173. 

  2173.             if($file=="." || $file=="..") continue;

    2174. 

  2174.             if(is_dir($path . '/' . $file)){

    2175. 

  2175.                 _icl_st_get_options_writes($path . '/' . $file);                

    2176. 

  2176.             }elseif(preg_match('#(\.php|\.inc)$#i', $file)){

    2177. 

  2177.                 $content = file_get_contents($path . '/' . $file);

    2178. 

  2178.                 $int = preg_match_all('#(add|update)_option\(([^,]+),([^)]+)\)#im', $content, $matches);

    2179. 

  2179.                 if($int){

    2180. 

  2180.                     foreach($matches[2] as $m){

    2181. 

  2181.                         $option_name = trim($m);

    2182. 

  2182.                         if(0 === strpos($option_name, '"') || 0 === strpos($option_name, "'")){

    2183. 

  2183.                             $option_name = trim($option_name, "\"'");

    2184. 

  2184.                         }elseif(false === strpos($option_name, '$')){

    2185. 

  2185.                             if(false !== strpos($option_name, '::')){

    2186. 

  2186.                                 $cexp = explode('::', $option_name);

    2187. 

  2187.                                 if (class_exists($cexp[0])){

    2188. 

  2188.                                     if (defined($cexp[0].'::'. $cexp[1])){

    2189. 

  2189.                                         $option_name = constant($cexp[0].'::'. $cexp[1]);

    2190. 

  2190.                                     }

    2191. 

  2191.                                 }

    2192. 

  2192.                             }else{

    2193. 

  2193.                                 if (defined( $option_name )){

    2194. 

  2194.                                     $option_name = constant($option_name);

    2195. 

  2195.                                 }

    2196. 

  2196.                             }                            

    2197. 

  2197.                         }else{

    2198. 

  2198.                             $option_name = false;

    2199. 

  2199.                         }

    2200. 

  2200.                         if($option_name){

    2201. 

  2201.                             $found_writes[] = $option_name;

    2202. 

  2202.                         }

    2203. 

  2203.                     }

    2204. 

  2204.                 }

    2205. 

  2205.             }

    2206. 

  2206.         }

    2207. 

  2207.     } 

    2208. 

  2208.     return $found_writes;

    2209. 

  2209. }

    2210. 

  2210. 

    2211. 

  2211. function icl_st_scan_options_strings(){

    2212. 

  2212.     global $wpdb;

    2213. 

  2213.     

    2214. 

  2214.     $options = array();

    2215. 

  2215.     

    2216. 

  2216.     // scan theme php file for update_option(), add_option()

    2217. 

  2217.     $options_names = _icl_st_get_options_writes(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY);

    2218. 

  2218.     

    2219. 

  2219.     

    2220. 

  2220.     $options_names = array_merge($options_names, _icl_st_get_options_writes(ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY));

    2221. 

  2221.     $options_names = array_unique($options_names);

    2222. 

  2222.     $options_names = array_map('esc_sql', $options_names);

    2223. 

  2223.             

    2224. 

  2224.     if(!empty($options_names)){   

    2225. 

  2225.         $res = $wpdb->get_results("SELECT option_name, option_value FROM $wpdb->options WHERE option_name IN ('".join("','", $options_names)."')");

    2226. 

  2226.         foreach($res as $row){

    2227. 

  2227.             $options[$row->option_name] = maybe_unserialize($row->option_value);

    2228. 

  2228.             // try unserializing twice - just in case (see Arras Theme)

    2229. 

  2229.             $options[$row->option_name] = maybe_unserialize($options[$row->option_name]);

    2230. 

  2230.         }

    2231. 

  2231.     }

    2232. 

  2232.     

    2233. 

  2233.     

    2234. 

  2234.     $_icl_admin_option_names = get_option('_icl_admin_option_names', array());

    2235. 

  2235.     

    2236. 

  2236.     $_icl_admin_option_names = @array_merge_recursive($_icl_admin_option_names, $options_names);

    2237. 

  2237.     $_icl_admin_option_names = __array_unique_recursive($_icl_admin_option_names);

    2238. 

  2238.     

    2239. 

  2239.     update_option('_icl_admin_option_names', $_icl_admin_option_names);

    2240. 

  2240.          

    2241. 

  2241.     return $options;

    2242. 

  2242. }

    2243. 

  2243. 

    2244. 

  2244. function icl_st_render_option_writes($option_name, $option_value, $option_key=''){    

    2245. 

  2245.     $has_translations = '';

    2246. 

  2246.     if(is_array($option_value) || is_object($option_value)){

    2247. 

  2247.         echo '<h4><a class="icl_stow_toggler" href="#">- ' . $option_name . '</a></h4>';

    2248. 

  2248.         echo '<ul class="icl_st_option_writes">';

    2249. 

  2249.         foreach($option_value as $key=>$value){

    2250. 

  2250.             echo '<li>';

    2251. 

  2251.             icl_st_render_option_writes($key, $value, $option_key . '[' . $option_name . ']');    

    2252. 

  2252.             echo '</li>';

    2253. 

  2253.         }        

    2254. 

  2254.         echo '</ul>';

    2255. 

  2255.     }elseif(is_string($option_value) || is_numeric($option_value)){

    2256. 

  2256.         if(icl_st_is_registered_string('admin_texts_theme_' . get_option('template'), $option_key . $option_name)){

    2257. 

  2257.             $checked = ' checked="checked"';

    2258. 

  2258.             if(icl_st_string_has_translations('admin_texts_theme_' . get_option('template'), $option_key . $option_name)){

    2259. 

  2259.                 $has_translations = ' class="icl_st_has_translations"';

    2260. 

  2260.             }else{

    2261. 

  2261.                 $has_translations = '';

    2262. 

  2262.             }            

    2263. 

  2263.         }else{

    2264. 

  2264.             $checked = '';

    2265. 

  2265.         }        

    2266. 

  2266.         if(is_numeric($option_value)){

    2267. 

  2267.             $class = 'icl_st_numeric';

    2268. 

  2268.         }else{

    2269. 

  2269.             $class = 'icl_st_string';

    2270. 

  2270.         }

    2271. 

  2271.         

    2272. 

  2272.         global $iclTranslationManagement;

    2273. 

  2273.         

    2274. 

  2274.         $int = preg_match_all('#\[([^\]]+)\]#', $option_key.'['.$option_name.']', $matches);

    2275. 

  2275.         $_v = $iclTranslationManagement->admin_texts_to_translate;

    2276. 

  2276.         if($int){

    2277. 

  2277.             foreach($matches[1] as $m){

    2278. 

  2278.                 if(isset($_v[$m])){

    2279. 

  2279.                     $_v = $_v[$m];

    2280. 

  2280.                 }else{

    2281. 

  2281.                     $_v = 0;

    2282. 

  2282.                     break;

    2283. 

  2283.                 }

    2284. 

  2284.             }

    2285. 

  2285.         }

    2286. 

  2286.         

    2287. 

  2287.         if($_v){

    2288. 

  2288.             $disabled = ' disabled="disabled"';

    2289. 

  2289.         }else{

    2290. 

  2290.             $disabled = '';

    2291. 

  2291.         }

    2292. 

  2292.         echo '<div class="icl_st_admin_string '.$class.'">';

    2293. 

  2293.         echo '<input'.$disabled.' type="hidden" name="icl_admin_options'.$option_key.'['.$option_name.']" value=""  />';

    2294. 

  2294.         echo '<input'.$disabled.$has_translations.' type="checkbox" name="icl_admin_options'.$option_key.'['.$option_name.']" value="'.esc_attr($option_value).'"

    2295. 

  2295.             '.$checked.' />';

    2296. 

  2296.         echo '<input type="text" readonly="readonly" value="'.$option_name.'" size="32" />'; 

    2297. 

  2297.         echo '<input type="text" value="'.esc_attr($option_value).'" readonly="readonly" size="48" />';

    2298. 

  2298.         //echo '<br /><input type="text" size="100" value="icl_admin_options'.$option_key.'['.$option_name.']" />';

    2299. 

  2299.         echo '</div><br clear="all" />';

    2300. 

  2300.     }

    2301. 

  2301. }

    2302. 

  2302. 

    2303. 

  2303. function icl_register_admin_options($array, $key=""){    

    2304. 

  2304.     

    2305. 

  2305.     foreach($array as $k=>$v){

    2306. 

  2306.         if(is_array($v)){

    2307. 

  2307.             icl_register_admin_options($v, $key . '['.$k.']');

    2308. 

  2308.         }else{

    2309. 

  2309.             if($v === ''){

    2310. 

  2310.                 icl_unregister_string('admin_texts_theme_' . get_option('template'), $key . $k);

    2311. 

  2311.             }else{

    2312. 

  2312.                 icl_register_string('admin_texts_theme_' . get_option('template'), $key . $k, $v);

    2313. 

  2313.                 

    2314. 

  2314.                 $int = preg_match_all('#\[([^\]]+)\]#', $key, $matches);

    2315. 

  2315.                 $vals = array();

    2316. 

  2316.                 if(count($matches[1]) > 0){

    2317. 

  2317.                     

    2318. 

  2318.                     $vals[] = $k;

    2319. 

  2319.                     for($i = count($matches[1]) - 1; $i >= 0 ; $i--){

    2320. 

  2320.                         $tmp = $vals;

    2321. 

  2321.                         unset($vals);

    2322. 

  2322.                         $vals[$matches[1][$i]] = $tmp;

    2323. 

  2323.                     }

    2324. 

  2324.                     

    2325. 

  2325.                 }else{

    2326. 

  2326.                     

    2327. 

  2327.                     $vals[0] = $k;

    2328. 

  2328.                 }

    2329. 

  2329.                 

    2330. 

  2330.                 

    2331. 

  2331.                 $_icl_admin_option_names = get_option('_icl_admin_option_names');

    2332. 

  2332.                 

    2333. 

  2333.                 

    2334. 

  2334.                 $_icl_admin_option_names['theme'][get_option('template')] =                     

    2335. 

  2335.                     array_merge_recursive((array)$_icl_admin_option_names['theme'][get_option('template')], $vals);

    2336. 

  2336.                 

    2337. 

  2337.                 $_icl_admin_option_names['theme'][get_option('template')] = __array_unique_recursive($_icl_admin_option_names['theme'][get_option('template')]);

    2338. 

  2338.                 

    2339. 

  2339.                 update_option('_icl_admin_option_names', $_icl_admin_option_names); 

    2340. 

  2340.                 

    2341. 

  2341.             }            

    2342. 

  2342.         }

    2343. 

  2343.     }      

    2344. 

  2344.     

    2345. 

  2345.     

    2346. 

  2346. }

    2347. 

  2347. 

    2348. 

  2348. function __array_unique_recursive($array){

    2349. 

  2349.     $scalars = array();

    2350. 

  2350.     foreach($array as $key=>$value){

    2351. 

  2351.         if(is_scalar($value)){

    2352. 

  2352.             if(isset($scalars[$value])){

    2353. 

  2353.                 unset($array[$key]);

    2354. 

  2354.             }else{

    2355. 

  2355.                 $scalars[$value] = true;    

    2356. 

  2356.             }

    2357. 

  2357.         }elseif(is_array($value)){

    2358. 

  2358.             $array[$key] = __array_unique_recursive($value);

    2359. 

  2359.         }

    2360. 

  2360.     }   

    2361. 

  2361.     return $array; 

    2362. 

  2362. }

    2363. 

  2363. 

    2364. 

  2364. function _icl_st_filter_empty_options_out($array){

    2365. 

  2365.     $empty_found = false;

    2366. 

  2366.     foreach($array as $k=>$v){

    2367. 

  2367.         if(is_array($v) && !empty($v)){

    2368. 

  2368.             list($array[$k], $empty_found) = _icl_st_filter_empty_options_out($v);

    2369. 

  2369.         }else{

    2370. 

  2370.             if(empty($v)){

    2371. 

  2371.                 unset($array[$k]);

    2372. 

  2372.                 $empty_found = true;

    2373. 

  2373.             }

    2374. 

  2374.         }

    2375. 

  2375.     }

    2376. 

  2376.     return array($array, $empty_found);

    2377. 

  2377. }

    2378. 

  2378. 

    2379. 

  2379. function wpml_register_admin_strings($serialized_array){

    2380. 

  2380.     try{

    2381. 

  2381.         icl_register_admin_options(unserialize($serialized_array));    

    2382. 

  2382.     }catch(Exception $e){

    2383. 

  2383.         trigger_error($e->getMessage(), E_USER_WARNING);

    2384. 

  2384.     }

    2385. 

  2385. }

    2386. 

  2386. 

    2387. 

  2387. add_action('plugins_loaded', 'icl_st_set_admin_options_filters', 10);

    2388. 

  2388. function icl_st_set_admin_options_filters() {

    2389. 

  2389. 	static $option_names;

    2390. 

  2390. 	if ( empty( $option_names ) ) {

    2391. 

  2391. 		$option_names = get_option( '_icl_admin_option_names' );

    2392. 

  2392. 	}

    2393. 

  2393. 

    2394. 

  2394. 	if ( !empty( $option_names[ 'theme' ] ) && !empty( $option_names[ 'theme' ][ basename( ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY ) ] ) ) {

    2395. 

  2395. 		foreach ( $option_names[ 'theme' ][ basename( ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY ) ] as $option_key => $option ) {

    2396. 

  2396. 			add_filter( 'option_' . $option_key, 'icl_st_translate_admin_string' );

    2397. 

  2397. 		}

    2398. 

  2398. 		if ( ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY != ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY && !empty( $option_names[ 'theme' ][ basename( ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY ) ] ) ) {

    2399. 

  2399. 			foreach ( (array)$option_names[ 'theme' ][ basename( ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY ) ] as $option_key => $option ) {

    2400. 

  2400. 				add_filter( 'option_' . $option_key, 'icl_st_translate_admin_string' );

    2401. 

  2401. 			}

    2402. 

  2402. 		}

    2403. 

  2403. 	}

    2404. 

  2404. 	if ( !empty( $option_names[ 'plugin' ] ) ) {

    2405. 

  2405. 		foreach ( $option_names[ 'plugin' ] as $plugin => $options ) {

    2406. 

  2406. 			foreach ( (array)$options as $option_key => $option ) {

    2407. 

  2407. 				add_filter( 'option_' . $option_key, 'icl_st_translate_admin_string' );

    2408. 

  2408. 			}

    2409. 

  2409. 		}

    2410. 

  2410. 	}

    2411. 

  2411. }

    2412. 

  2412. 

    2413. 

  2413. function icl_st_translate_admin_string($option_value, $key="", $name="", $rec_level = 0){

    2414. 

  2414. 

    2415. 

  2415. 	if ( !defined( 'ICL_SITEPRESS_VERSION' ) || ICL_PLUGIN_INACTIVE ) {

    2416. 

  2416. 		return $option_value;

    2417. 

  2417. 	}

    2418. 

  2418. 

    2419. 

  2419. 	// determine option name

    2420. 

  2420. 	if ( !$name && $rec_level == 0 ) {

    2421. 

  2421. 		$ob = debug_backtrace();

    2422. 

  2422. 		if ( is_scalar( $ob[ 2 + $rec_level ][ 'args' ][ 0 ] ) ) {

    2423. 

  2423. 			$name = preg_replace( '@^option_@', '', $ob[ 2 + $rec_level ][ 'args' ][ 0 ] );

    2424. 

  2424. 		}

    2425. 

  2425. 	}

    2426. 

  2426. 	

    2427. 

  2427.     // cache - phase 1 - check/get

    2428. 

  2428.     static $__icl_st_cache;

    2429. 

  2429.     if($rec_level == 0){

    2430. 

  2430.         if(isset($__icl_st_cache[$name]) && apply_filters( 'icl_st_admin_string_return_cached', true, $name ) ) {

    2431. 

  2431.             //echo "FROM CACHE $name<br />";

    2432. 

  2432.             return $__icl_st_cache[$name];    

    2433. 

  2433.         }

    2434. 

  2434.         

    2435. 

  2435.     }

    2436. 

  2436.     

    2437. 

  2437.     // case of double-serialized options (See Arras theme)   

    2438. 

  2438.     $serialized = false;

    2439. 

  2439.     if(is_serialized( $option_value )){

    2440. 

  2440.         $option_value = @unserialize($option_value);

    2441. 

  2441.         $serialized = true;

    2442. 

  2442.     }

    2443. 

  2443.     

    2444. 

  2444.     //if(is_object($option_value)){

    2445. 

  2445.         //$option_value = (array)$option_value;

    2446. 

  2446.     //}

    2447. 

  2447.     

    2448. 

  2448.     if(is_array($option_value) || is_object($option_value)){

    2449. 

  2449.         foreach($option_value as $k=>$value){            

    2450. 

  2450.             

    2451. 

  2451.             $val = icl_st_translate_admin_string($value, $key . '[' . $name . ']' , $k, $rec_level+1);

    2452. 

  2452.             

    2453. 

  2453.             if(is_object($option_value)){

    2454. 

  2454.                 $option_value->$k = $val;

    2455. 

  2455.             }else{

    2456. 

  2456.                 $option_value[$k] = $val;

    2457. 

  2457.             }   

    2458. 

  2458.         }            

    2459. 

  2459.         

    2460. 

  2460.     }else{   

    2461. 

  2461.         static $option_names;

    2462. 

  2462.         if(empty($option_names)) $option_names = get_option('_icl_admin_option_names');                

    2463. 

  2463.         // determine theme/plugin name

    2464. 

  2464.         

    2465. 

  2465.          if(!empty($option_names['theme']) && !empty($option_names['theme'][basename(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY)])){

    2466. 

  2466.             if(isset($option_names['theme'][basename(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY)]))

    2467. 

  2467.             foreach((array)$option_names['theme'][basename(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY)] as $ops=>$val){                

    2468. 

  2468.                 if(!empty($key)){

    2469. 

  2469.                     $int = preg_match_all('#\[([^\]]+)\]#', $key, $matches);

    2470. 

  2470.                     if($int) $opname = $matches[1][0];

    2471. 

  2471.                 }else{

    2472. 

  2472.                     $opname = $name;

    2473. 

  2473.                 }

    2474. 

  2474.                 

    2475. 

  2475.                 if($ops == $opname){

    2476. 

  2476.                     $key_suff = 'theme_' . basename(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY);

    2477. 

  2477.                     break;

    2478. 

  2478.                 }

    2479. 

  2479.             }

    2480. 

  2480.             

    2481. 

  2481.             if(ICL_STRING_TRANSLATION_TEMPLATE_DIRECTORY != ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY){

    2482. 

  2482.                 if(isset($option_names['theme'][basename(ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY)]))

    2483. 

  2483.                 foreach((array)$option_names['theme'][basename(ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY)] as $ops=>$val){

    2484. 

  2484.                     

    2485. 

  2485.                     if(!empty($key)){

    2486. 

  2486.                         $int = preg_match_all('#\[([^\]]+)\]#', $key, $matches);

    2487. 

  2487.                         if($int) $opname = $matches[1][0];

    2488. 

  2488.                     }else{

    2489. 

  2489.                         $opname = $name;

    2490. 

  2490.                     }

    2491. 

  2491.                     

    2492. 

  2492.                     if($ops == $opname){

    2493. 

  2493.                         $key_suff = 'theme_' . ICL_STRING_TRANSLATION_STYLESHEET_DIRECTORY;

    2494. 

  2494.                         break;

    2495. 

  2495.                     }

    2496. 

  2496.                 }

    2497. 

  2497.             }

    2498. 

  2498.         }

    2499. 

  2499.         

    2500. 

  2500.         if(!empty($option_names['plugin'])){

    2501. 

  2501.             foreach((array)$option_names['plugin'] as $plugin => $options){

    2502. 

  2502.                 foreach($options as $kops=>$ops){             

    2503. 

  2503.                     if(is_array($ops)){

    2504. 

  2504.                         $arrkey = explode('][', trim($key, '[]'));

    2505. 

  2505.                         $_val = $options;                       

    2506. 

  2506.                         for($i=0; $i<count($arrkey); $i++){

    2507. 

  2507.                             if(isset($_val[$arrkey[$i]])){

    2508. 

  2508.                                 $_val = $_val[$arrkey[$i]];                                 

    2509. 

  2509.                             }else{

    2510. 

  2510.                                 break;

    2511. 

  2511.                             }

    2512. 

  2512.                         }

    2513. 

  2513.                         if(in_array($name, $_val)){ // seems not work since WPML 3.1, added next elseif which works

    2514. 

  2514.                             $key_suff = 'plugin_' . $plugin;

    2515. 

  2515.                             break;

    2516. 

  2516.                         }elseif (in_array($name, array_keys($_val))) {

    2517. 

  2517.                             $key_suff = 'plugin_' . $plugin;

    2518. 

  2518.                             break;

    2519. 

  2519.                         }

    2520. 

  2520.                     }elseif($ops == $name){ // seems not work since WPML 3.1, added next elseif which works

    2521. 

  2521.                         $key_suff = 'plugin_' . $plugin;

    2522. 

  2522.                         break;

    2523. 

  2523.                     }elseif ($kops == $name) {

    2524. 

  2524.                         $key_suff = 'plugin_' . $plugin;

    2525. 

  2525.                         break;

    2526. 

  2526.                     }

    2527. 

  2527.                 }            

    2528. 

  2528.             }

    2529. 

  2529.         }       

    2530. 

  2530.         

    2531. 

  2531.         if(!empty($key_suff)){

    2532. 

  2532.             $tr = icl_t('admin_texts_' . $key_suff, $key . $name, $option_value, $hast, true);                

    2533. 

  2533.         } 

    2534. 

  2534.                 

    2535. 

  2535.         if(isset($tr)){

    2536. 

  2536.             $option_value = $tr;

    2537. 

  2537.         }

    2538. 

  2538.         

    2539. 

  2539.     }

    2540. 

  2540.     

    2541. 

  2541.     // case of double-serialized options (See Arras theme)   

    2542. 

  2542.     if($serialized){

    2543. 

  2543.         $option_value = serialize($option_value);

    2544. 

  2544.     }

    2545. 

  2545.     

    2546. 

  2546.     // cache - phase 2 - set

    2547. 

  2547.     if($rec_level == 0){

    2548. 

  2548.         $__icl_st_cache[$name] = $option_value;

    2549. 

  2549.     }

    2550. 

  2550.     

    2551. 

  2551.     /*

    2552. 

  2552.      * if sticky links plugin is enabled and set to change links into sticky 

    2553. 

  2553.      * in strings, change those links back into permalinks when displayed

    2554. 

  2554.      */

    2555. 

  2555.     if (is_string($option_value) and class_exists("WPML_Sticky_links")) {

    2556. 

  2556. 		global $WPML_Sticky_Links;

    2557. 

  2557. 		if(isset($WPML_Sticky_Links)) {

    2558. 

  2558. 			if ($WPML_Sticky_Links->settings['sticky_links_strings']) {

    2559. 

  2559. 				$option_value = $WPML_Sticky_Links->show_permalinks($option_value);

    2560. 

  2560. 			}

    2561. 

  2561. 		}

    2562. 

  2562.     }

    2563. 

  2563.     

    2564. 

  2564.     return $option_value;

    2565. 

  2565. }

    2566. 

  2566. 

    2567. 

  2567. function icl_st_get_mo_files($path){

    2568. 

  2568.     static $mo_files = array();

    2569. 

  2569.     

    2570. 

  2570.     if ( function_exists('realpath') )

    2571. 

  2571.         $path = realpath($path);

    2572. 

  2572.     

    2573. 

  2573.     if(is_dir($path) && is_readable($path)){

    2574. 

  2574.         $dh = opendir($path);

    2575. 

  2575.         if($dh !== false){

    2576. 

  2576.             while($f = readdir($dh)){            

    2577. 

  2577.                 if(0 !== strpos($f, '.')){    

    2578. 

  2578.                     if(is_dir($path . '/' . $f)){

    2579. 

  2579.                         icl_st_get_mo_files($path . '/' . $f);

    2580. 

  2580.                     }else{

    2581. 

  2581.                         if(preg_match('#\.mo$#', $f)){                    

    2582. 

  2582.                             $mo_files[] = $path . '/' . $f;

    2583. 

  2583.                         }

    2584. 

  2584.                     }

    2585. 

  2585.                 }

    2586. 

  2586.             }    

    2587. 

  2587.         }

    2588. 

  2588.     }

    2589. 

  2589.     

    2590. 

  2590.     return $mo_files;

    2591. 

  2591. }

    2592. 

  2592. 

    2593. 

  2593. function icl_st_load_translations_from_mo($mo_file){

    2594. 

  2594.     $translations = array();

    2595. 

  2595.     $mo = new MO();     

    2596. 

  2596.     $mo->import_from_file( $mo_file );

    2597. 

  2597.     foreach($mo->entries as $str=>$v){

    2598. 

  2598.         $str = str_replace("\n",'\n', $str);

    2599. 

  2599.         $translations[$str] = $v->translations[0];

    2600. 

  2600.     }

    2601. 

  2601.     return $translations;

    2602. 

  2602. }

    2603. 

  2603. 

    2604. 

  2604. // fix links in existing strings according to the new translation added

    2605. 

  2605. function icl_st_fix_links_in_strings($post_id){

    2606. 

  2606.     static $runnonce = false;

    2607. 

  2607.     if($runnonce){

    2608. 

  2608.         return;

    2609. 

  2609.     }

    2610. 

  2610.     $runonce = true;

    2611. 

  2611. 

    2612. 

  2612.     if(isset($_POST['autosave']) && $_POST['autosave']) return;

    2613. 

  2613.     

    2614. 

  2614.     if(isset($_POST['post_ID'])){

    2615. 

  2615.         $post_id = $_POST['post_ID'];

    2616. 

  2616.     }

    2617. 

  2617.     

    2618. 

  2618.     global $wpdb, $sitepress;

    2619. 

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

    2620. 

  2620.     if($language){

    2621. 

  2621.         if($sitepress->get_default_language()==$language){

    2622. 

  2622.             $strings = $wpdb->get_col($wpdb->prepare("SELECT id FROM {$wpdb->prefix}icl_strings WHERE language=%s",$language));

    2623. 

  2623.         }else{

    2624. 

  2624.             $strings = $wpdb->get_col($wpdb->prepare("SELECT id FROM {$wpdb->prefix}icl_string_translations WHERE language=%s",$language));

    2625. 

  2625.         }

    2626. 

  2626.             

    2627. 

  2627.         foreach($strings as $string_id){

    2628. 

  2628.             _icl_content_fix_links_to_translated_content($string_id, $language, 'string');

    2629. 

  2629.         }

    2630. 

  2630.     

    2631. 

  2631.     }

    2632. 

  2632. }

    2633. 

  2633. 

    2634. 

  2634. function icl_translation_send_strings($string_ids, $target_languages) {

    2635. 

  2635.     global $WPML_String_Translation;

    2636. 

  2636.     

    2637. 

  2637.     $errors = 0;

    2638. 

  2638.     

    2639. 

  2639.     

    2640. 

  2640.     // send to each language

    2641. 

  2641.     foreach($target_languages as $target=>$service){

    2642. 

  2642.         if($service == 'icanlocalize'){

    2643. 

  2643.             if( !_icl_translation_send_strings_icanlocalize($string_ids, $target, $service) ) $errors++;

    2644. 

  2644.         }elseif($service == 'local'){

    2645. 

  2645.             if( ! _icl_translation_send_strings_local($string_ids, $target, $service) ) $errors++;

    2646. 

  2646.         }

    2647. 

  2647.     }

    2648. 

  2648.     

    2649. 

  2649.     if($errors == count($target_languages)){

    2650. 

  2650.        $WPML_String_Translation->add_message(__('No string was sent to translation.','wpml-string-translation'), 'error');

    2651. 

  2651.     }elseif($errors > 0){

    2652. 

  2652.         $WPML_String_Translation->add_message(__('Some strings were not sent to translation.','wpml-string-translation'), 'error');

    2653. 

  2653.     }else{

    2654. 

  2654.         if(count($string_ids) > 1){

    2655. 

  2655.             $WPML_String_Translation->add_message(__('All strings were sent to translation.','wpml-string-translation'));                

    2656. 

  2656.         }else{

    2657. 

  2657.             $WPML_String_Translation->add_message(__('The string was sent to translation.','wpml-string-translation'));    

    2658. 

  2658.         }       

    2659. 

  2659.     }

    2660. 

  2660. }

    2661. 

  2661. 

    2662. 

  2662. function _icl_translation_send_strings_local($string_ids, $target) {

    2663. 

  2663.     global $wpdb, $sitepress_settings;

    2664. 

  2664.     static $site_translators;

    2665. 

  2665.     $site_translators = TranslationManagement::get_blog_translators();

    2666. 

  2666. 

    2667. 

  2667.     $mkey = $wpdb->prefix . 'strings_notification'; 

    2668. 

  2668.     $lkey = $wpdb->prefix . 'language_pairs'; 

    2669. 

  2669.     $slang =& $sitepress_settings['st']['strings_language'];

    2670. 

  2670.     

    2671. 

  2671.     foreach($string_ids as $string_id) {    

    2672. 

  2672.         $added = icl_add_string_translation($string_id, $target, NULL , ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR);

    2673. 

  2673.         

    2674. 

  2674.         if($added)

    2675. 

  2675.         foreach($site_translators as $key=>$st){                        

    2676. 

  2676.             $ulangs = isset($st->$lkey) ? $st->$lkey : false;

    2677. 

  2677.             if(!empty($ulangs) && !empty($ulangs[$slang][$target])){

    2678. 

  2678.             

    2679. 

  2679.                 $enot = isset($st->$mkey) ? $st->$mkey : false;

    2680. 

  2680.                 if(empty($enot[$sitepress_settings['st']['strings_language']][$target])){

    2681. 

  2681.                     _icl_st_translator_notification($st, $sitepress_settings['st']['strings_language'], $target);    

    2682. 

  2682.                     $enot[$sitepress_settings['st']['strings_language']][$target] = 1;

    2683. 

  2683.                     $site_translators[$key]->$mkey = $enot;                

    2684. 

  2684.                     update_option($wpdb->prefix . 'icl_translators_cached', $site_translators);

    2685. 

  2685.                     //printf("Notify %d for %s -> %s <br />", $st->ID, $sitepress_settings['st']['strings_language'], $target); 

    2686. 

  2686.                 }else{

    2687. 

  2687.                     //printf("Already notified %d for %s -> %s <br />", $st->ID, $sitepress_settings['st']['strings_language'], $target); 

    2688. 

  2688.                 }

    2689. 

  2689.                 

    2690. 

  2690.             }

    2691. 

  2691.             

    2692. 

  2692.         }

    2693. 

  2693.     }

    2694. 

  2694.     

    2695. 

  2695.     return 1;

    2696. 

  2696. }

    2697. 

  2697. 

    2698. 

  2698. function _icl_st_translator_notification($user, $source, $target){

    2699. 

  2699.     global $wpdb, $sitepress;

    2700. 

  2700.     

    2701. 

  2701.     $_ldetails = $sitepress->get_language_details($source);

    2702. 

  2702.     $source_en = $_ldetails['english_name'];

    2703. 

  2703.     $_ldetails = $sitepress->get_language_details($target);

    2704. 

  2704.     $target_en = $_ldetails['english_name'];

    2705. 

  2705.     

    2706. 

  2706.     $message = __("You have been assigned to new translation job from %s to %s.

    2707. 

  2707. 

    2708. 

  2708. Start editing: %s

    2709. 

  2709. 

    2710. 

  2710. You can view your other translation jobs here: %s

    2711. 

  2711. 

    2712. 

  2712.  This message was automatically sent by Translation Management running on WPML. To stop receiving these notifications contact the system administrator at %s.

    2713. 

  2713. 

    2714. 

  2714.  This email is not monitored for replies.

    2715. 

  2715. 

    2716. 

  2716.  - The folks at ICanLocalize

    2717. 

  2717.  101 Convention Center Dr., Las Vegas, Nevada, 89109, USA

    2718. 

  2718. ", 'sitepress');

    2719. 

  2719.     

    2720. 

  2720.     

    2721. 

  2721.     $to = $user->user_email;

    2722. 

  2722.     $subject = sprintf(__("You have been assigned to new translation job on %s.", 'sitepress'), get_bloginfo('name'));

    2723. 

  2723.     $body = sprintf($message, 

    2724. 

  2724.         $source_en, $target_en, admin_url('admin.php?page='.WPML_ST_FOLDER.'/menu/string-translation.php'), 

    2725. 

  2725.             admin_url('admin.php?page='.WPML_TM_FOLDER.'/menu/translations-queue.php'), home_url());

    2726. 

  2726. 

    2727. 

  2727.     wp_mail($to, $subject, $body);

    2728. 

  2728.     

    2729. 

  2729.     $meta = get_user_meta($user->ID, $wpdb->prefix . 'strings_notification', 1);

    2730. 

  2730.     $meta[$source][$target] = 1;        

    2731. 

  2731.     update_user_meta($user->ID, $wpdb->prefix . 'strings_notification', $meta);

    2732. 

  2732. }

    2733. 

  2733. 

    2734. 

  2734. function icl_st_reset_current_trasnslator_notifications(){

    2735. 

  2735.     global $sitepress, $wpdb;

    2736. 

  2736.     $current_user = $sitepress->get_current_user();

    2737. 

  2737.     $mkey = $wpdb->prefix . 'strings_notification'; 

    2738. 

  2738.     if(!empty($current_user->$mkey)){

    2739. 

  2739.         update_user_meta($current_user->ID, $mkey, array());

    2740. 

  2740.     }

    2741. 

  2741. }

    2742. 

  2742. 

    2743. 

  2743. function _icl_translation_send_strings_icanlocalize($string_ids, $target) {

    2744. 

  2744.     global $wpdb, $sitepress, $sitepress_settings;

    2745. 

  2745.                                                                         

    2746. 

  2746.     if(!$sitepress_settings['st']['strings_language']) 

    2747. 

  2747.         $sitepress_settings['st']['strings_language'] = $sitepress->get_default_language();

    2748. 

  2748.     

    2749. 

  2749.     $target_details = $sitepress->get_language_details($target);

    2750. 

  2750.     

    2751. 

  2751.     // get all the untranslated strings

    2752. 

  2752.     $untranslated = array();

    2753. 

  2753.     foreach($string_ids as $st_id) {        

    2754. 

  2754.         $status = $wpdb->get_var($wpdb->prepare("SELECT status FROM {$wpdb->prefix}icl_string_translations WHERE string_id=%d and language=%s", $st_id, $target));

    2755. 

  2755.         if ($status != ICL_STRING_TRANSLATION_COMPLETE) {

    2756. 

  2756.             $untranslated[] = $st_id;

    2757. 

  2757.         }

    2758. 

  2758.     }

    2759. 

  2759.     

    2760. 

  2760.     if (sizeof($untranslated) >  0) {

    2761. 

  2761.         // Something to translate.

    2762. 

  2762.         $target_for_server = array(ICL_Pro_Translation::server_languages_map($target_details['english_name'])); //filter some language names to match the names on the server

    2763. 

  2763.         $data = array(

    2764. 

  2764.             'url'=>'', 

    2765. 

  2765.             'target_languages' => $target_for_server,

    2766. 

  2766.         );

    2767. 

  2767.         $string_values = array();

    2768. 

  2768.         foreach($untranslated as $st_id) {

    2769. 

  2769.             

    2770. 

  2770.             $string = $wpdb->get_row($wpdb->prepare("SELECT context, name, value FROM {$wpdb->prefix}icl_strings WHERE id=%d", $st_id));

    2771. 

  2771.             $string_values[$st_id] = $string->value;

    2772. 

  2772.             $data['contents']['string-'.$st_id.'-context'] = array(

    2773. 

  2773.                     'translate'=>0,

    2774. 

  2774.                     'data'=>base64_encode(esc_attr($string->context)),

    2775. 

  2775.                     'format'=>'base64',

    2776. 

  2776.             );

    2777. 

  2777.             $data['contents']['string-'.$st_id.'-name'] = array(

    2778. 

  2778.                     'translate'=>0,

    2779. 

  2779.                     'data'=>base64_encode(esc_attr($string->name)),

    2780. 

  2780.                     'format'=>'base64',

    2781. 

  2781.             );

    2782. 

  2782.             $data['contents']['string-'.$st_id.'-value'] = array(

    2783. 

  2783.                     'translate'=>1,

    2784. 

  2784.                     'data'=>base64_encode(esc_attr($string->value)),

    2785. 

  2785.                     'format'=>'base64',

    2786. 

  2786.             );

    2787. 

  2787.             

    2788. 

  2788.         }

    2789. 

  2789. 

    2790. 

  2790.         $iclq = new ICanLocalizeQuery($sitepress_settings['site_id'], $sitepress_settings['access_key']);

    2791. 

  2791.         

    2792. 

  2792.         $orig_lang = $sitepress->get_language_details($sitepress_settings['st']['strings_language']);

    2793. 

  2793.         $orig_lang_for_server = ICL_Pro_Translation::server_languages_map($orig_lang['english_name']);

    2794. 

  2794. 

    2795. 

  2795.         $timestamp = date('Y-m-d H:i:s');

    2796. 

  2796.         

    2797. 

  2797.         $xml = $iclq->build_cms_request_xml($data, $orig_lang_for_server);

    2798. 

  2798.         $args = array(

    2799. 

  2799.             'xml'           => $xml,

    2800. 

  2800.             'title'         => "String translations",

    2801. 

  2801.             'to_languages'  =>  $target_for_server,

    2802. 

  2802.             'orig_language' => $orig_lang_for_server

    2803. 

  2803.             

    2804. 

  2804.         );

    2805. 

  2805.         

    2806. 

  2806.         $res = $iclq->send_request($args);

    2807. 

  2807. 

    2808. 

  2808.         if($res > 0){

    2809. 

  2809.             foreach($string_values as $st_id => $value){

    2810. 

  2810.                 $wpdb->insert($wpdb->prefix.'icl_string_status', 

    2811. 

  2811.                     array('rid'=>$res, 'string_translation_id'=>$st_id, 'timestamp'=>$timestamp, 'md5'=>md5($value))); //insert rid

    2812. 

  2812.             }

    2813. 

  2813.             $wpdb->insert($wpdb->prefix.'icl_core_status', array('rid'=>$res,

    2814. 

  2814.                                                                      'origin'=>$orig_lang['code'],

    2815. 

  2815.                                                                      'target'=>$target,

    2816. 

  2816.                                                                      'status'=>CMS_REQUEST_WAITING_FOR_PROJECT_CREATION));

    2817. 

  2817.             return $res;

    2818. 

  2818.         }else{

    2819. 

  2819.             return 0;

    2820. 

  2820.             

    2821. 

  2821.         }

    2822. 

  2822.     }

    2823. 

  2823. }

    2824. 

  2824. 

    2825. 

  2825. function icl_decode_translation_status_id($status){

    2826. 

  2826.     switch($status){

    2827. 

  2827.         case CMS_TARGET_LANGUAGE_CREATED: $st = __('Waiting for translator','wpml-string-translation');break;

    2828. 

  2828.         case CMS_TARGET_LANGUAGE_ASSIGNED: $st = __('In progress','wpml-string-translation');break; 

    2829. 

  2829.         case CMS_TARGET_LANGUAGE_TRANSLATED: $st = __('Translation received','wpml-string-translation');break;

    2830. 

  2830.         case CMS_TARGET_LANGUAGE_DONE: $st = __('Translation complete','wpml-string-translation');break;

    2831. 

  2831.         case CMS_REQUEST_FAILED: $st = __('Request failed','wpml-string-translation');break;

    2832. 

  2832.         default: $st = __('Not translated','wpml-string-translation');

    2833. 

  2833.     }

    2834. 

  2834.     

    2835. 

  2835.     return $st;

    2836. 

  2836. }

    2837. 

  2837. 

    2838. 

  2838. function icl_translation_get_string_translation_status($string_id) {

    2839. 

  2839.     global $wpdb;

    2840. 

  2840.     $status = $wpdb->get_var($wpdb->prepare("

    2841. 

  2841.             SELECT

    2842. 

  2842.                 MIN(cs.status) 

    2843. 

  2843.             FROM

    2844. 

  2844.                 {$wpdb->prefix}icl_core_status cs

    2845. 

  2845.             JOIN 

    2846. 

  2846.                {$wpdb->prefix}icl_string_status ss

    2847. 

  2847.             ON

    2848. 

  2848.                ss.rid = cs.rid

    2849. 

  2849.             WHERE

    2850. 

  2850.                 ss.string_translation_id=%d

    2851. 

  2851.             ", $string_id    

    2852. 

  2852.             ));

    2853. 

  2853.     

    2854. 

  2854.     if ($status === null){

    2855. 

  2855.         return "";

    2856. 

  2856.     }

    2857. 

  2857.     

    2858. 

  2858.     $status = icl_decode_translation_status_id($status);

    2859. 

  2859.     

    2860. 

  2860.     return $status;

    2861. 

  2861.         

    2862. 

  2862. }

    2863. 

  2863. 

    2864. 

  2864. function icl_translation_send_untranslated_strings($target_languages) {

    2865. 

  2865.     global $wpdb;

    2866. 

  2866.     $untranslated = $wpdb->get_col($wpdb->prepare("SELECT id FROM {$wpdb->prefix}icl_strings WHERE status <> %d", ICL_STRING_TRANSLATION_COMPLETE));

    2867. 

  2867.     

    2868. 

  2868.     icl_translation_send_strings($untranslated, $target_languages);

    2869. 

  2869.     

    2870. 

  2870. }

    2871. 

  2871. 

    2872. 

  2872. function icl_is_string_translation($translation) {

    2873. 

  2873.     // determine if the $translation data is for string translation.

    2874. 

  2874.     

    2875. 

  2875.     foreach($translation as $key => $value) {

    2876. 

  2876.         if($key == 'body' or $key == 'title') {

    2877. 

  2877.             return false;

    2878. 

  2878.         }

    2879. 

  2879.         if (preg_match("/string-.*?-value/", $key)){

    2880. 

  2880.             return true;

    2881. 

  2881.         }

    2882. 

  2882.     }

    2883. 

  2883.     

    2884. 

  2884.     // if we get here assume it's not a string.

    2885. 

  2885.     return false;

    2886. 

  2886.     

    2887. 

  2887. }

    2888. 

  2888. 

    2889. 

  2889. function icl_translation_add_string_translation($rid, $translation, $lang_code){

    2890. 

  2890.     global $wpdb, $sitepress_settings, $sitepress;

    2891. 

  2891.     foreach($translation as $key => $value) {

    2892. 

  2892.         if (preg_match("/string-(.*?)-value/", $key, $match)){

    2893. 

  2893.             $string_id = $match[1];

    2894. 

  2894.             

    2895. 

  2895.             $md5_when_sent = $wpdb->get_var($wpdb->prepare("SELECT md5 FROM {$wpdb->prefix}icl_string_status 

    2896. 

  2896.                 WHERE string_translation_id=%d AND rid=%d", $string_id, $rid));

    2897. 

  2897.             $current_string_value = $wpdb->get_var($wpdb->prepare("SELECT value FROM {$wpdb->prefix}icl_strings WHERE id=%d", $string_id));

    2898. 

  2898.             if ($md5_when_sent == md5($current_string_value)) {

    2899. 

  2899.                 $status = ICL_STRING_TRANSLATION_COMPLETE;

    2900. 

  2900.             } else {

    2901. 

  2901.                 $status = ICL_STRING_TRANSLATION_NEEDS_UPDATE;

    2902. 

  2902.             }

    2903. 

  2903.             $value = str_replace ( '&#0A;', "\n", $value );

    2904. 

  2904.             icl_add_string_translation($string_id, $lang_code, html_entity_decode($value), $status, 0);

    2905. 

  2905.         }

    2906. 

  2906.     }

    2907. 

  2907. 

    2908. 

  2908.     // update translation status

    2909. 

  2909.     $wpdb->update($wpdb->prefix.'icl_core_status', array('status'=>CMS_TARGET_LANGUAGE_DONE), array('rid'=>$rid, 'target'=>$lang_code));

    2910. 

  2910.     

    2911. 

  2911.     return true;

    2912. 

  2912. }

    2913. 

  2913. 

    2914. 

  2914. function icl_st_get_pending_string_translations_stats(){

    2915. 

  2915.     global $wpdb, $sitepress, $sitepress_settings;

    2916. 

  2916.     

    2917. 

  2917.     $current_user = $sitepress->get_current_user();

    2918. 

  2918.     

    2919. 

  2919.     $user_lang_pairs = get_user_meta($current_user->ID, $wpdb->prefix.'language_pairs', true);    

    2920. 

  2920.     

    2921. 

  2921.     $stats = array();

    2922. 

  2922.     

    2923. 

  2923.     if(!empty($user_lang_pairs[$sitepress_settings['st']['strings_language']])){

    2924. 

  2924.         $results = $wpdb->get_results($wpdb->prepare("

    2925. 

  2925.             SELECT COUNT(id) AS c, language 

    2926. 

  2926.             FROM {$wpdb->prefix}icl_string_translations 

    2927. 

  2927.             WHERE status=%d AND language IN ('".join("','", array_keys($user_lang_pairs[$sitepress_settings['st']['strings_language']]))."')

    2928. 

  2928.                     AND (translator_id IS NULL or translator_id > 0)

    2929. 

  2929.             GROUP BY language

    2930. 

  2930.             ORDER BY c DESC

    2931. 

  2931.             ",

    2932. 

  2932.             ICL_STRING_TRANSLATION_WAITING_FOR_TRANSLATOR    

    2933. 

  2933.         ));

    2934. 

  2934.         

    2935. 

  2935.         foreach($results as $r){

    2936. 

  2936.             $_stats[$r->language] = $r->c;

    2937. 

  2937.         }

    2938. 

  2938.         

    2939. 

  2939.         foreach($user_lang_pairs[$sitepress_settings['st']['strings_language']] as $lang=>$one){

    2940. 

  2940.             $stats[$lang] = isset($_stats[$lang]) ? $_stats[$lang] : 0;

    2941. 

  2941.         }

    2942. 

  2942.         

    2943. 

  2943.     }

    2944. 

  2944.     

    2945. 

  2945.     

    2946. 

  2946.     return $stats;

    2947. 

  2947. }

    2948. 

  2948. 

    2949. 

  2949. function icl_st_is_translator(){

    2950. 

  2950.     return current_user_can('translate') && !current_user_can('manage_options');

    2951. 

  2951. }

    2952. 

  2952. 

    2953. 

  2953. function icl_st_debug($str){

    2954. 

  2954.     trigger_error($str, E_USER_WARNING);

    2955. 

  2955. }

    2956. 

  2956. 

    2957. 

  2957. function icl_st_admin_notices_string_updated() {

    2958. 

  2958. 	?>

    2959. 

  2959. 	<div class="updated">

    2960. 

  2960. 			<p><?php _e( 'Strings translations updated', 'wpml-string-translation' ); ?></p>

    2961. 

  2961. 	</div>

    2962. 

  2962. 	<?php

    2963. 

  2963. }

    2964. 

  2964.