PageRenderTime 98ms CodeModel.GetById 47ms 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

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

    

  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.str…
    1138.

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