PageRenderTime 77ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/zd_multilang.php

https://github.com/wp-plugins/zdmultilang
PHP | 1835 lines | 1601 code | 166 blank | 68 comment | 223 complexity | e8570c5e52e2c00779b95a4cf865c5e9 MD5 | raw file

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

    

  1. <?php
    2. 

  2. /*
    3. 

  3. Plugin Name: ZdMultiLang
    4. 

  4. Plugin URI: http://blog.zen-dreams.com/en/zdmultilang
    5. 

  5. Description: This plugin adds multilingual capabilities to wordpress
    6. 

  6. Version: 1.2.5
    7. 

  7. Author: Anthony PETITBOIS, Pau Sanchez
    8. 

  8. Author URI: http://www.zen-dreams.com/
    9. 

    10. 

  10. Copyright 2008  Anthony PETITBOIS  (email : anthony@zen-dreams.com)
    11. 

    12. 

  12.     This program is free software; you can redistribute it and/or modify
    13. 

  13.     it under the terms of the GNU General Public License as published by
    14. 

  14.     the Free Software Foundation; either version 2 of the License, or
    15. 

  15.     (at your option) any later version.
    16. 

    17. 

  17.     This program is distributed in the hope that it will be useful,
    18. 

  18.     but WITHOUT ANY WARRANTY; without even the implied warranty of
    19. 

  19.     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    20. 

  20.     GNU General Public License for more details.
    21. 

    22. 

  22.     You should have received a copy of the GNU General Public License
    23. 

  23.     along with this program; if not, write to the Free Software
    24. 

  24.     Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
    25. 

  25. */
    26. 

  26. 

  27. $ZdmlCache=array();
    28. 

  28. $BaseURL=$_SERVER['PHP_SELF'].'?page='.plugin_basename (__FILE__);
    29. 

  29. $default_language_option="zd_multilang_defaultlanguage";
    30. 

  30. $insert_lang_switch_option="zd_multilang_lang_switcher";
    31. 

  31. $show_flags_option="zd_multilang_show_flags";
    32. 

  32. $show_languages_option="zd_multilang_langnames";
    33. 

  33. $lang_switcher_class_option="zd_multilang_switcher_class";
    34. 

  34. $permalink_default="zd_multilang_permalink_def";
    35. 

  35. $display_untranslated="zd_multilang_display_untranslated";
    36. 

  36. $display_google_translate="zd_multilang_display_glink";
    37. 

  37. $display_original_option="zd_multilang_display_original";
    38. 

  38. $keep_separate_comments="zd_multilang_keep_separate_comments";
    39. 

  39. $Allowed_Access="zd_multilang_access";
    40. 

  40. $Autosave_Option="zdmultilang_autosave";
    41. 

  41. $CurrentLanguagePermalink="";
    42. 

  42. $PluginDIR = '../'.PLUGINDIR . '/' . dirname(plugin_basename (__FILE__));
    43. 

  43. 

  44. load_plugin_textdomain('zd_multilang',PLUGINDIR . '/' . dirname(plugin_basename (__FILE__)) . '/lang');
    45. 

  45. register_activation_hook(__FILE__,'zd_multilang_install');
    46. 

  46. add_action('admin_menu', 'zd_multilang_add_pages');
    47. 

  47. add_filter('get_term', 'zd_multilang_translate_term',2);	// Translate single terms
    48. 

  48. add_filter('admin_head','zd_multilang_tinymce');
    49. 

  49. add_filter('the_category','zd_multilang_translate_link_cat');  // Categories for posts
    50. 

  50. add_filter('get_pages','zd_multilang_translate_post');  // Translation of Pages
    51. 

  51. add_filter('get_tags','zd_multilang_translate_tags');  // Translation of tags
    52. 

  52. add_filter('list_cats','zd_multilang_translate_cat');	 // Categories for lists (widget)
    53. 

  53. add_filter('get_bookmarks','zd_multilang_translate_bookmarks');
    54. 

  54. add_filter('wp_list_bookmarks','zd_multilang_translate_list_bookmarks');
    55. 

  55. add_filter('wp_tag_cloud','zd_multilang_translate_link_cat');
    56. 

  56. add_filter('category_description','zd_multilang_cat_desc',10,2);
    57. 

  57. add_filter('get_categories','zd_multilang_cat');
    58. 

  58. add_filter('the_posts','zd_multilang_translate_post',10,1);
    59. 

  59. add_filter('query_vars', 'zd_multilang_queryvars');
    60. 

  60. add_filter('rewrite_rules_array', 'zd_multilang_rewrite');
    61. 

  61. add_filter('next_post_link','zd_multilang_postlink');
    62. 

  62. add_filter('previous_post_link','zd_multilang_postlink');
    63. 

  63. add_filter('post_link','zd_multilang_permalink',1);
    64. 

  64. add_filter('page_link','zd_multilang_permalink',1);
    65. 

  65. add_filter('category_link','zd_multilang_permalink',1);
    66. 

  66. add_filter('get_category','zd_multilang_cat',1);
    67. 

  67. add_filter('tag_link','zd_multilang_permalink',1);
    68. 

  68. add_filter('year_link','zd_multilang_permalink',1);
    69. 

  69. add_filter('month_link','zd_multilang_permalink',1);
    70. 

  70. add_filter('day_link','zd_multilang_permalink',1);
    71. 

  71. add_filter('feed_link','zd_multilang_permalink',1);
    72. 

  72. add_filter('author_link','zd_multilang_permalink',1);
    73. 

  73. add_filter('wp','zd_multilang_set_locale');
    74. 

  74. add_filter('manage_posts_columns', 'zd_multilang_manage_col_def');
    75. 

  75. add_filter('manage_pages_columns', 'zd_multilang_manage_col_def');
    76. 

  76. add_filter('posts_where','zd_multilang_where_filter');
    77. 

  77. add_filter('get_next_post_where','zd_multilang_np_where_filter');
    78. 

  78. add_filter('get_previous_post_where','zd_multilang_np_where_filter');
    79. 

  79. /* Filters for comments */
    80. 

  80. add_action ('wp_insert_comment', 'zd_multilang_insert_comment', 10, 2);
    81. 

  81. add_action ('delete_comment', 'zd_multilang_delete_comment');
    82. 

  82. add_filter ('comments_array','zd_multilang_comments_array', 10, 2);
    83. 

  83. add_filter ('get_comments_number', 'zd_multilang_get_comments_number');
    84. 

  84. 

  85. /* Options short circuit */
    86. 

  86. add_filter('option_blogname','zd_multilang_blogname');
    87. 

  87. add_filter('option_blogdescription','zd_multilang_blogdescription');
    88. 

  88. /* Options short circuit */
    89. 

  89. 

  90. add_action('manage_posts_custom_column', 'zd_multilang_manage_col', 10, 2);
    91. 

  91. add_action('manage_pages_custom_column', 'zd_multilang_manage_col', 10, 2);
    92. 

  92. add_action('media_buttons', 'zd_media_button', 30);
    93. 

  93. 

  94. /** Action handler for autosave feature **/
    95. 

  95. add_action('wp_ajax_zdmultilang_autosave', 'zd_multilang_autosave');
    96. 

  96. //add_action('wp_ajax_nopriv_my_special_action', 'my_action_callback');
    97. 

  97. 

  98. zd_multilang_set_locale("");
    99. 

  99. 

  100. function zd_multilang_tinymce() {
    101. 

  101. 	if (($_GET['fct']=="posts")||($_POST['fct']=="posts")) {
    102. 

  102. 		wp_enqueue_script( 'common' );
    103. 

  103. 		wp_enqueue_script( 'jquery-color' );
    104. 

  104. 		wp_print_scripts('editor');
    105. 

  105. 		if (function_exists('add_thickbox')) add_thickbox();
    106. 

  106. 		wp_print_scripts('media-upload');
    107. 

  107. 		if (function_exists('wp_tiny_mce')) wp_tiny_mce();
    108. 

  108. 		wp_admin_css();
    109. 

  109. 		wp_enqueue_script('utils');
    110. 

  110. 		do_action("admin_print_styles-post-php");
    111. 

  111. 		do_action('admin_print_styles');
    112. 

  112. 	}
    113. 

  113. }
    114. 

  114. 

  115. function zd_multilang_queryvars( $qvars ) {
    116. 

  116.   $qvars[] = 'lang';
    117. 

  117.   return $qvars;
    118. 

  118. }
    119. 

  119. 

  120. function zd_multilang_manage_col_def ($cols) {
    121. 

  121. 	$cols['translate']=__('Translate','zd_multilang');
    122. 

  122. 	return $cols;
    123. 

  123. }
    124. 

  124. 

  125. function zd_multilang_manage_col($column_name, $id) {
    126. 

  126. 	global $ZdmlCache, $PluginDIR;
    127. 

  127. 	$BaseURL='admin.php?page='.plugin_basename (__FILE__);
    128. 

  128. 	if( $column_name == 'translate' ) {
    129. 

  129. 		if ($ZdmlCache['Languages']) foreach ($ZdmlCache['Languages'] as $Permalink => $LanguageID) {
    130. 

  130. 			if ($LanguageID!=$ZdmlCache['DefLang']) echo '<a href="'.$BaseURL.'&amp;fct=posts&amp;id='.$id.'.'.$LanguageID.'"><img src="'.$PluginDIR.'/flags/'.$LanguageID.'.png" alt="'.$LanguageID.'" title="'.$LanguageID.'"></a> ';
    131. 

  131. 		}
    132. 

  132. 	}
    133. 

  133. }
    134. 

  134. 

  135. function zd_media_button() {
    136. 

  136. 	global $ZdmlCache, $PluginDIR;
    137. 

  137. 	$id=$_GET['post'];
    138. 

  138. 	if ($id) {
    139. 

  139. 		$BaseURL='admin.php?page='.plugin_basename (__FILE__);
    140. 

  140. 		if ($ZdmlCache['Languages']) foreach ($ZdmlCache['Languages'] as $Permalink => $LanguageID) {
    141. 

  141. 			if ($LanguageID!=$ZdmlCache['DefLang']) echo '<a href="'.$BaseURL.'&amp;fct=posts&amp;id='.$id.'.'.$LanguageID.'" target="_blank" title="'.__('Translate','zd_multilang').'"><img src="'.$PluginDIR.'/flags/'.$LanguageID.'.png" alt="'.$LanguageID.'" title="'.$LanguageID.'"></a>';
    142. 

  142. 		}
    143. 

  143. 	}
    144. 

  144. }
    145. 

  145. 

  146. function zd_multilang_where_filter($filter) {
    147. 

  147. 	global $ZdmlCache, $locale,$display_untranslated, $wpdb, $wp_query;
    148. 

  148. 

  149. 	if ((get_option('show_on_front')=='page')&&(is_array($wp_query->query))&&(count($wp_query->query)<=1)&&(isset($wp_query->query['lang']))) {
    150. 

  150. 		$lang=$WP->query['lang'];
    151. 

  151. 		$filter=" AND ".$wpdb->posts.".ID = ".get_option('page_on_front');
    152. 

  152. 		$wp_query->is_page=1;
    153. 

  153. 		$wp_query->is_home=0;
    154. 

  154. 	}
    155. 

  155. 	
    156. 

  156. 	if ($locale==$ZdmlCache['DefLang']) return $filter;
    157. 

  157. 	if (get_option($display_untranslated)=="hide") {
    158. 

  158. 		$filter.=" AND ".$wpdb->posts.".ID in (".$ZdmlCache['TranslatedPosts'][$locale].')';
    159. 

  159. 	}
    160. 

  160. 	return $filter;
    161. 

  161. }
    162. 

  162. 

  163. function zd_multilang_np_where_filter($filter) {
    164. 

  164. 	global $ZdmlCache, $locale,$display_untranslated, $wpdb;
    165. 

  165. 	if ($locale==$ZdmlCache['DefLang']) return $filter;
    166. 

  166. 	if (get_option($display_untranslated)=="hide") {
    167. 

  167. 		$filter.=" AND p.ID in (".$ZdmlCache['TranslatedPosts'][$locale].')';
    168. 

  168. 	}
    169. 

  169. 	return $filter;
    170. 

  170. }
    171. 

  171. 

  172. function zd_multilang_set_locale($WP) {
    173. 

  173. 	global $wp_query,$wpdb, $wp_rewrite,$default_language_option,$locale,$CurrentLanguagePermalink,$CurrentLang;
    174. 

  174. 	global $ZdmlCache;
    175. 

  175. 	
    176. 

  176. 	$language_table=$wpdb->prefix.'zd_ml_langs';
    177. 

  177. 	$termtrans=$wpdb->prefix.'zd_ml_termtrans';
    178. 

  178. 	$posttrans=$wpdb->prefix.'zd_ml_trans';
    179. 

  179. 	$linktrans=$wpdb->prefix.'zd_ml_linktrans';
    180. 

  180. 

  181. 	$ZdmlCache['DefLang']=get_option("zd_multilang_defaultlanguage");
    182. 

  182. 	$ZdmlCache['InsertInPosts']=get_option("zd_multilang_lang_switcher");
    183. 

  183. 	$ZdmlCache['ShowLanguages']=get_option("zd_multilang_langnames");
    184. 

  184. 	$ZdmlCache['ShowFlags']=get_option("zd_multilang_show_flags");
    185. 

  185. 	$ZdmlCache['SwitcherPosition']=get_option('zd_multilang_position');
    186. 

  186. 	$ZdmlCache['Lang_Switch_Class']=(get_option("zd_multilang_switcher_class")!="") ? get_option("zd_multilang_switcher_class") : "lang_switch";
    187. 

  187. 

  188. 	$TheLocale=$ZdmlCache['DefLang'];
    189. 

  189. 	
    190. 

  190. 	if (!isset($ZdmlCache['Languages'])) {
    191. 

  191. 		$query="SELECT * FROM $language_table ORDER BY LanguageName";
    192. 

  192. 		$results=$wpdb->get_results($query, ARRAY_A);
    193. 

  193. 		if ($results) {
    194. 

  194. 			foreach ($results as $ID => $V) {
    195. 

  195. 				$ZdmlCache['Languages'][$V['LangPermalink']]=$V['LanguageID'];
    196. 

  196. 				$ZdmlCache['LanguageNames'][$V['LangPermalink']]=$V['LanguageName'];
    197. 

  197. 				$ZdmlCache['Options'][$V['LanguageID']]['blogname']=$V['BlogName'];
    198. 

  198. 				$ZdmlCache['Options'][$V['LanguageID']]['blogdescription']=$V['BlogDescription'];
    199. 

  199. 			}
    200. 

  200. 		}
    201. 

  201. 	}	
    202. 

  202. 	 else {
    203. 

  203. 		foreach ($ZdmlCache['Languages'] as $Permalink => $LangID) {
    204. 

  204. 			$results[$i]['LangPermalink']=$Permalink;
    205. 

  205. 			$results[$i]['LanguageID']=$LangID;
    206. 

  206. 			$i++;
    207. 

  207. 		}
    208. 

  208. 	}
    209. 

  209. 	
    210. 

  210. 	if ($_SERVER['HTTPS']) $QUERY="https://".$_SERVER['HTTP_HOST'];
    211. 

  211. 	else $QUERY="http://".$_SERVER['HTTP_HOST'];
    212. 

  212. 	$QUERY.=$_SERVER['REQUEST_URI'];
    213. 

  213. 

  214. 	if ($results) {
    215. 

  215. 		foreach ($results as $ID => $Lang) {
    216. 

  216. 			$regexp.=$Lang['LangPermalink']."|";
    217. 

  217. 		}
    218. 

  218. 		$regexp=substr($regexp, 0, -1);
    219. 

  219. 	}
    220. 

  220. 	if (strstr($QUERY,"?")) $RegularExpression="`".get_bloginfo('url')."\/.*lang=($regexp)(.*)?`U";
    221. 

  221. 	else $RegularExpression="`".get_bloginfo('url')."\/($regexp)\/(.*)?`U";
    222. 

  222. 	
    223. 

  223. 	if (preg_match($RegularExpression,$QUERY,$res)==TRUE) {
    224. 

  224. 		$Lang=$res[1];
    225. 

  225. 		$CurrentLanguagePermalink=$res[1];
    226. 

  226. 		foreach ($ZdmlCache['Languages'] as $Permalink => $LangFound) {
    227. 

  227. 			if ($Permalink==$Lang) {
    228. 

  228. 				$Language= $LangFound;
    229. 

  229. 				break;
    230. 

  230. 			}
    231. 

  231. 		}
    232. 

  232. 		$CurrentLang=$Language;
    233. 

  233. 		if ($Language) $TheLocale=$Language;
    234. 

  234. 	}
    235. 

  235. 	$locale=$TheLocale;
    236. 

  236. 

  237. 	if (!isset($ZdmlCache['Terms'])) {
    238. 

  238. 		$query="SELECT tt.LanguageID, tt.name as t_name, tt.description as description, t.* FROM $termtrans tt RIGHT JOIN ".$wpdb->prefix."terms t on (tt.term_id=t.term_id)";
    239. 

  239. 		$term=$wpdb->get_results($query, ARRAY_A);
    240. 

  240. 		foreach ($term as $ID => $Value) {
    241. 

  241. 			if ($Value['t_name']!=NULL) $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['name']=$Value['t_name'];
    242. 

  242. 			else $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['name']=$Value['name'];
    243. 

  243. 			$ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['o_name']=$Value['name'];
    244. 

  244. 			$ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['description']=$Value['description'];
    245. 

  245. 		}
    246. 

  246. 	}
    247. 

  247. 	
    248. 

  248. 	if (!isset($ZdmlCache['Links'])) {
    249. 

  249. 		$query="SELECT * from $linktrans";
    250. 

  250. 		$links=$wpdb->get_results($query);
    251. 

  251. 		foreach ($links as $id => $Values) {
    252. 

  252. 			$ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['name']=$Values->link_name;
    253. 

  253. 			$ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['url']=$Values->link_url;
    254. 

  254. 			$ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['description']=$Values->link_description;
    255. 

  255. 		}
    256. 

  256. 	}
    257. 

  257. 

  258. 	if (!isset($ZdmlCache['TranslatedPosts'])) {
    259. 

  259. 		if ($ZdmlCache['Languages']) foreach ($ZdmlCache['Languages'] as $Permalink => $LangID) {
    260. 

  260. 			if ($LangID!=$ZdmlCache['DefLang']) {
    261. 

  261. 				$query="SELECT ID from $posttrans WHERE LanguageID='$LangID' and post_status='published'";
    262. 

  262. 				$res=$wpdb->get_results($query, ARRAY_A);
    263. 

  263. 				if ($res) {
    264. 

  264. 					$ZdmlCache['TranslatedPosts'][$LangID]="";
    265. 

  265. 					foreach ($res as $key => $V) {
    266. 

  266. 						$ZdmlCache['TranslatedPosts'][$LangID].=$V['ID'].",";
    267. 

  267. 					}
    268. 

  268. 					$ZdmlCache['TranslatedPosts'][$LangID]=substr($ZdmlCache['TranslatedPosts'][$LangID],0,-1);
    269. 

  269. 				}
    270. 

  270. 			}
    271. 

  271. 		}
    272. 

  272. 	}
    273. 

  273. 	
    274. 

  274. 	return $WP;
    275. 

  275. }
    276. 

  276. 

  277. function zd_multilang_permalink($permalink) {
    278. 

  278. 	global $wpdb, $wp_rewrite,$default_language_option, $CurrentLanguagePermalink,$CurrentLang,$permalink_default, $locale, $wp_query;
    279. 

  279. 	global $ZdmlCache;
    280. 

  280. 	$langstable=$wpdb->prefix.'zd_ml_langs';
    281. 

  281. 	
    282. 

  282. 	$Lang=$CurrentLanguagePermalink;
    283. 

  283. 	if ($Lang=="") {
    284. 

  284. 		$CurrentLang=$ZdmlCache['DefLang'];
    285. 

  285. 		$query="SELECT LangPermalink FROM $langstable where LanguageID='$CurrentLang'";
    286. 

  286. 		$CurrentLanguagePermalink=$wpdb->get_var($query);
    287. 

  287. 		$Lang=$CurrentLanguagePermalink;
    288. 

  288. 	}
    289. 

  289. 	$link=$permalink;
    290. 

  290. 

  291. 	$PermalinkDef=get_option($permalink_default);
    292. 

  292. 	if (($PermalinkDef=="no")&&($ZdmlCache['DefLang']==$locale)) return $link;
    293. 

  293. 	
    294. 

  294. 	if ($wp_rewrite->using_permalinks()) {
    295. 

  295. 		$url=get_bloginfo('url');
    296. 

  296. 		$end=substr($link,strlen($url));
    297. 

  297. 		if ($Lang=="") $link=$url.$end;
    298. 

  298. 		else $link=$url.'/'.$Lang.$end;
    299. 

  299. 	} else if ($Lang) $link.= ((!strpos($link,'?'))? '?': '') ."&lang=".$Lang;
    300. 

  300. 

  301. 	return $link;
    302. 

  302. }
    303. 

  303. 

  304. function zd_multilang_rewrite($permalink_structure) {
    305. 

  305. 	global $ZdmlCache;
    306. 

  306. 	global $wpdb, $wp_rewrite;
    307. 

  307. 	$langs=$wpdb->prefix.'zd_ml_langs';
    308. 

  308. 	
    309. 

  309. 	$query="SELECT * FROM $langs order by LanguageID";
    310. 

  310. 	$Lines=$wpdb->get_results($query, ARRAY_A);
    311. 

  311. 	if ($Lines) {
    312. 

  312. 		$regexp='(';
    313. 

  313. 		foreach ($Lines as $Value) {
    314. 

  314. 			$regexp.=$Value['LangPermalink'].'|';
    315. 

  315. 		}
    316. 

  316. 		$regexp=substr($regexp,0,-1);
    317. 

  317. 		$regexp.=')';
    318. 

  318. 

  319. 		if ($permalink_structure) foreach ($permalink_structure as $Rule => $Definition) {
    320. 

  320. 			$def=explode('?',$Definition);
    321. 

  321. 			$rule=$Definition;
    322. 

  322. 			if (preg_match_all('/(.*matches)\[([0-9]+)\]/U',$rule,$res)) {
    323. 

  323. 				$rule="";
    324. 

  324. 				foreach ($res[1] as $index => $text) {
    325. 

  325. 					$rule.=$text.'['.($index+2).']';
    326. 

  326. 				}
    327. 

  327. 			}
    328. 

  328. 			$rule.='&lang=$matches[1]';
    329. 

  329. 			$new_rules[$regexp.'/'.$Rule]=$rule;
    330. 

  330. 		}
    331. 

  331. 		$new_rules2[$regexp.'/?']='index.php?lang=$matches[1]';
    332. 

  332. 		if ($permalink_structure) $permalink_structure = $new_rules+ $new_rules2 + $permalink_structure;
    333. 

  333. 	}
    334. 

  334. 	return $permalink_structure;
    335. 

  335. }
    336. 

  336. 

  337. function zd_multilang_is_translated($id, $lang) {
    338. 

  338. 	global $ZdmlCache, $locale;
    339. 

  339. 	if ($lang==$ZdmlCache['DefLang']) return TRUE;
    340. 

  340. 	$Posts=explode(',',$ZdmlCache['TranslatedPosts'][$lang]);
    341. 

  341. 	foreach ($Posts as $key => $ID) {
    342. 

  342. 		if ($ID==$id) {
    343. 

  343. 			return TRUE;
    344. 

  344. 		}
    345. 

  345. 	}
    346. 

  346. 	return FALSE;
    347. 

  347. }
    348. 

  348. 

  349. function zd_multilang_install() {
    350. 

  350. 	global $ZdmlCache;
    351. 

  351. 	global $wpdb;
    352. 

  352. 	$termtrans=$wpdb->prefix.'zd_ml_termtrans';
    353. 

  353. 	$langs=$wpdb->prefix.'zd_ml_langs';
    354. 

  354. 	$posttrans=$wpdb->prefix.'zd_ml_trans';
    355. 

  355. 	$linktrans=$wpdb->prefix.'zd_ml_linktrans';
    356. 

  356. 	$commenttrans=$wpdb->prefix.'zd_ml_comments';
    357. 

  357. 	
    358. 

  358. 	$dbversion=get_option('zd_multilang_dbschema');
    359. 

  359. 	if ($dbversion<"125") {
    360. 

  360. 		$sql="CREATE TABLE $langs (
    361. 

  361. 			LanguageID varchar(5) NOT NULL,
    362. 

  362. 			LanguageName varchar(100) character set utf8 NOT NULL,
    363. 

  363. 			LangPermalink varchar(50) NOT NULL UNIQUE,
    364. 

  364. 			BlogName longtext,
    365. 

  365. 			BlogDescription longtext,
    366. 

  366. 			primary key (LanguageID)
    367. 

  367. 		);";
    368. 

  368. 		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    369. 

  369. 		dbDelta($sql);
    370. 

  370. 

  371. 		$sql="CREATE TABLE $termtrans (
    372. 

  372. 			term_id varchar(5) NOT NULL,
    373. 

  373. 			LanguageID varchar(5) NOT NULL,
    374. 

  374. 			name varchar(255) character set utf8 NOT NULL,
    375. 

  375. 			description longtext NOT NULL,
    376. 

  376. 			primary key (term_id,LanguageID)
    377. 

  377. 		);";
    378. 

  378. 		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    379. 

  379. 		dbDelta($sql);
    380. 

  380. 		
    381. 

  381. 		$sql="CREATE TABLE $posttrans (
    382. 

  382. 			ID BIGINT(20) NOT NULL,
    383. 

  383. 			LanguageID varchar(5),
    384. 

  384. 			post_content longtext character set utf8,
    385. 

  385. 			post_excerpt text character set utf8,
    386. 

  386. 			post_title text character set utf8 NOT NULL,
    387. 

  387. 			post_status varchar(10),
    388. 

  388. 			primary key (ID, LanguageID)
    389. 

  389. 		);";
    390. 

  390. 		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    391. 

  391. 		dbDelta($sql);
    392. 

  392. 		
    393. 

  393. 		$sql="CREATE TABLE $linktrans (
    394. 

  394. 			link_id BIGINT(20) NOT NULL,
    395. 

  395. 			LanguageID varchar(5),
    396. 

  396. 			link_url varchar(255),
    397. 

  397. 			link_name varchar(255) character set utf8,
    398. 

  398. 			link_description varchar(255) character set utf8,
    399. 

  399. 			primary key (link_id, LanguageID)
    400. 

  400. 		);";
    401. 

  401. 		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    402. 

  402. 		dbDelta($sql);
    403. 

  403. 	
    404. 

  404. 		$sql="UPDATE $posttrans set post_status='published' where post_status is NULL";
    405. 

  405. 		$wpdb->query($sql);
    406. 

  406. 		
    407. 

  407. 		// Comment translations only should keep track of the language where a single comment has been submitted
    408. 

  408. 		$sql="CREATE TABLE $commenttrans (
    409. 

  409. 			comment_id BIGINT(20) UNSIGNED NOT NULL,
    410. 

  410. 			post_id BIGINT(20) UNSIGNED NOT NULL,
    411. 

  411. 			LanguageID varchar(5),
    412. 

  412. 			primary key (comment_id)
    413. 

  413. 		);";
    414. 

  414. 		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
    415. 

  415. 		dbDelta($sql);
    416. 

  416. 		
    417. 

  417. 		update_option('zd_multilang_dbschema',125);
    418. 

  418. 		update_option('zd_multilang_access',10);
    419. 

  419. 	}
    420. 

  420. }
    421. 

  421. 

  422. function zd_multilang_add_pages() {
    423. 

  423. 	global $Allowed_Access;
    424. 

  424. 	$Allowed_Access_Level=get_option($Allowed_Access);
    425. 

  425. 	add_menu_page('Zd_MultiLang', __('Translations','zd_multilang'), $Allowed_Access_Level,  __FILE__, 'zd_multilang_page');
    426. 

  426. 	add_submenu_page(__FILE__,__('Posts','zd_multilang'),__('Posts','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=posts&amp;tr=posts','zd_multilang_page');
    427. 

  427. 	add_submenu_page(__FILE__,__('Pages','zd_multilang'),__('Pages','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=posts&amp;tr=pages','zd_multilang_page');
    428. 

  428. 	add_submenu_page(__FILE__,__('Categories','zd_multilang'),__('Categories','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=translations&amp;tr=cat','zd_multilang_page');
    429. 

  429. 	add_submenu_page(__FILE__,__('Tags','zd_multilang'),__('Tags','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=translations&amp;tr=tags','zd_multilang_page');
    430. 

  430. 	add_submenu_page(__FILE__,__('Links','zd_multilang'),__('Links','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=links','zd_multilang_page');
    431. 

  431. 	add_submenu_page(__FILE__,__('Link Categories','zd_multilang'),__('Link Categories','zd_multilang'),$Allowed_Access_Level,__FILE__.'&amp;fct=translations&amp;tr=linkcat','zd_multilang_page');
    432. 

  432. 	add_submenu_page(__FILE__,__('Languages','zd_multilang'),__('Languages','zd_multilang'),'manage_options',__FILE__.'&amp;fct=languages','zd_multilang_page');
    433. 

  433. 	add_submenu_page(__FILE__,__('Options','zd_multilang'),__('Options','zd_multilang'),'manage_options',__FILE__.'&amp;fct=options','zd_multilang_page');
    434. 

  434. }
    435. 

  435. 

  436. function zd_multilang_page() {
    437. 

  437. 	global $BaseURL, $current_user;
    438. 

  438. 	get_currentuserinfo();
    439. 

  439. 	echo "\n".'<div class="wrap">';
    440. 

  440. 	if ($_POST['fct']) $_GET['fct']=$_POST['fct'];
    441. 

  441. 	switch ($_GET['fct']) {
    442. 

  442. 		case 'options':
    443. 

  443. 			if ($current_user->allcaps['manage_options']==1)
    444. 

  444. 				zd_multilang_options();
    445. 

  445. 			else {
    446. 

  446. 				echo '<div id="message" class="error"><p>Only the administrator can edit the options</p></div>';
    447. 

  447. 				zd_multilang_dashboard();
    448. 

  448. 			}
    449. 

  449. 			break;
    450. 

  450. 		case 'edit':
    451. 

  451. 			if ($current_user->allcaps['manage_options']==1)
    452. 

  452. 				zd_multilang_edit_language();
    453. 

  453. 			else {
    454. 

  454. 				echo '<div id="message" class="error"><p>Only the administrator can edit the options</p></div>';
    455. 

  455. 				zd_multilang_dashboard();
    456. 

  456. 			}
    457. 

  457. 			break;
    458. 

  458. 		case 'delete':
    459. 

  459. 			if ($current_user->allcaps['manage_options']==1)
    460. 

  460. 				zd_multilang_delete_language();
    461. 

  461. 			else {
    462. 

  462. 				echo '<div id="message" class="error"><p>Only the administrator can edit the options</p></div>';
    463. 

  463. 				zd_multilang_dashboard();
    464. 

  464. 			}
    465. 

  465. 			break;
    466. 

  466. 		case 'posts':
    467. 

  467. 			zd_multilang_post_translations();
    468. 

  468. 			break;
    469. 

  469. 		case 'translations';
    470. 

  470. 			zd_multilang_term_translations();
    471. 

  471. 			break;
    472. 

  472. 		case 'languages':
    473. 

  473. 			if ($current_user->allcaps['manage_options']==1)
    474. 

  474. 				zd_multilang_languages();
    475. 

  475. 			else {
    476. 

  476. 				echo '<div id="message" class="error"><p>Only the administrator can edit the options</p></div>';
    477. 

  477. 				zd_multilang_dashboard();
    478. 

  478. 			}
    479. 

  479. 			break;
    480. 

  480. 		case 'links':
    481. 

  481. 			zd_multilang_link_translations();
    482. 

  482. 			break;
    483. 

  483. 		default:
    484. 

  484. 			zd_multilang_dashboard();
    485. 

  485. 			break;
    486. 

  486. 	}
    487. 

  487. 	echo "\n</div>";
    488. 

  488. }
    489. 

  489. 

  490. function zd_multilang_dashboard() {
    491. 

  491. 	global $BaseURL, $current_user;
    492. 

  492. 	get_currentuserinfo();;
    493. 

  493. 	echo '<h2>'.__('Language Dashboard','zd_multilang').'</h2>';
    494. 

  494. 	echo '<ul>';
    495. 

  495. 		echo '<li><a href="'.$BaseURL.'&amp;fct=posts&amp;tr=posts">'.__('Translate posts','zd_multilang').'</a></li>';
    496. 

  496. 		echo '<li><a href="'.$BaseURL.'&amp;fct=posts&amp;tr=pages">'.__('Translate pages','zd_multilang').'</a></li>';
    497. 

  497. 		echo '<li><a href="'.$BaseURL.'&amp;fct=translations&amp;tr=cat">'.__('Translate categories','zd_multilang').'</a></li>';
    498. 

  498. 		echo '<li><a href="'.$BaseURL.'&amp;fct=translations&amp;tr=tags">'.__('Translate tags','zd_multilang').'</a></li>';
    499. 

  499. 		echo '<li><a href="'.$BaseURL.'&amp;fct=links">'.__('Translate links','zd_multilang').'</a></li>';
    500. 

  500. 		echo '<li><a href="'.$BaseURL.'&amp;fct=translations&amp;tr=linkcat">'.__('Translate link categories','zd_multilang').'</a></li>';
    501. 

  501. 		if ($current_user->allcaps['manage_options']==1) echo '<li><a href="'.$BaseURL.'&amp;fct=languages">'.__('Define languages','zd_multilang').'</a></li>';
    502. 

  502. 		if ($current_user->allcaps['manage_options']==1) echo '<li><a href="'.$BaseURL.'&amp;fct=options">'.__('Manage options','zd_multilang').'</a></li>';
    503. 

  503. 	echo '</ul>';
    504. 

  504. 	echo '<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
    505. 

  505. <input type="hidden" name="cmd" value="_s-xclick">
    506. 

  506. <input type="hidden" name="hosted_button_id" value="8262513">
    507. 

  507. <input type="image" src="https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
    508. 

  508. <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
    509. 

  509. </form>';
    510. 

  510. }
    511. 

  511. 

  512. function zd_multilang_options() {
    513. 

  513. 	global $wpdb, $BaseURL,$default_language_option,$insert_lang_switch_option,$show_flags_option,$display_google_translate;
    514. 

  514. 	global $show_languages_option,$lang_switcher_class_option,$permalink_default,$display_untranslated, $display_original_option,$keep_separate_comments, $Allowed_Access,$Autosave_Option;
    515. 

  515. 	global $ZdmlCache;
    516. 

  516. 	
    517. 

  517. 	$language_table=$wpdb->prefix.'zd_ml_langs';
    518. 

  518. 	$termtrans=$wpdb->prefix.'zd_ml_termtrans';
    519. 

  519. 	$posttrans=$wpdb->prefix.'zd_ml_trans';
    520. 

  520. 	$hidden_field="zd_multilang_update_options";
    521. 

  521. 	$language_table= $wpdb->prefix.'zd_ml_langs';
    522. 

  522. 	
    523. 

  523. 	echo '<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
    524. 

  524. <input type="hidden" name="cmd" value="_s-xclick">
    525. 

  525. <input type="hidden" name="hosted_button_id" value="8262513">
    526. 

  526. <input type="image" src="https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
    527. 

  527. <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
    528. 

  528. </form>';
    529. 

  529. 	
    530. 

  530. 	if ($_POST[$hidden_field]) {
    531. 

  531. 		$OldLang=get_option($default_language_option);
    532. 

  532. 		$DefLang=$_POST['def_lang'];
    533. 

  533. 		$DisplayOriginal=$_POST['display_original'];
    534. 

  534. 		$InsertInPosts=$_POST['show_language_switcher'];
    535. 

  535. 		$Show_Languages=$_POST['show_languages'];
    536. 

  536. 		$Show_Flags=$_POST['show_flags'];
    537. 

  537. 		$Lang_Switch_Class=$_POST['lang_switch_class'];
    538. 

  538. 		$SwitcherPosition=$_POST['language_switcher_position'];
    539. 

  539. 		$KeepSeparateComments=$_POST['keep_separate_comments'];
    540. 

  540. 		$PermalinkDef=$_POST['permalink_for_default'];
    541. 

  541. 		$Exchange=$_POST['exchange_lang'];
    542. 

  542. 		$DisplayUntranslated=$_POST['display_untranslated'];
    543. 

  543. 		$DisplayGLink=$_POST['display_glink'];
    544. 

  544. 		$Allowed_Access_Level=$_POST['access_level'];
    545. 

  545. 		$Autosave=$_POST['autosave'];
    546. 

  546. 		
    547. 

  547. 		update_option('zd_multilang_position',$SwitcherPosition);
    548. 

  548. 		update_option($default_language_option,$DefLang);
    549. 

  549. 		update_option($display_original_option, $DisplayOriginal);
    550. 

  550. 		update_option($insert_lang_switch_option,$InsertInPosts);
    551. 

  551. 		update_option($show_languages_option,$Show_Languages);
    552. 

  552. 		update_option($show_flags_option,$Show_Flags);
    553. 

  553. 		update_option($lang_switcher_class_option,$Lang_Switch_Class);
    554. 

  554. 		update_option($permalink_default, $PermalinkDef);
    555. 

  555. 		update_option($display_untranslated,$DisplayUntranslated);
    556. 

  556. 		update_option($display_google_translate,$DisplayGLink);
    557. 

  557. 		update_option($keep_separate_comments, $KeepSeparateComments);
    558. 

  558. 		update_option($Allowed_Access,$Allowed_Access_Level);
    559. 

  559. 		update_option($Autosave_Option,$Autosave);
    560. 

  560. 		
    561. 

  561. 		echo '<div id="message" class="updated fade">';
    562. 

  562. 		if ($Exchange=="on") {
    563. 

  563. 			$query="SELECT * FROM $posttrans where LanguageID='$DefLang'";
    564. 

  564. 			$TrPosts=$wpdb->get_results($query, ARRAY_A);
    565. 

  565. 			$query="SELECT * FROM $termtrans where LanguageID='$DefLang'";
    566. 

  566. 			$TrTerms=$wpdb->get_results($query, ARRAY_A);
    567. 

  567. 

  568. 			if ($TrPosts) foreach ($TrPosts as $key => $V) {
    569. 

  569. 				$query="SELECT * from ".$wpdb->posts." WHERE ID=".$V['ID'];
    570. 

  570. 				$res=$wpdb->get_row($query);
    571. 

  571. 				$OriginalTitle=$res->post_title;
    572. 

  572. 				$OriginalContent=$wpdb->escape($res->post_content);
    573. 

  573. 				$NewContent=$wpdb->escape($V['post_content']);
    574. 

  574. 				$NewTitle=$V['post_title'];
    575. 

  575. 				$q1="UPDATE ".$wpdb->posts." set post_title='$NewTitle', post_content='$NewContent' WHERE ID=".$V['ID'];
    576. 

  576. 				$wpdb->query($q1);
    577. 

  577. 				$q1="UPDATE $posttrans set post_title='$OriginalTitle', post_content='$OriginalContent', LanguageID='$OldLang' WHERE ID=".$V['ID']." and LanguageID='$DefLang'";
    578. 

  578. 				$wpdb->query($q1);
    579. 

  579. 			}
    580. 

  580. 			if ($TrTerms) foreach ($TrTerms as $key => $V) {
    581. 

  581. 				$query="SELECT * from ".$wpdb->terms." WHERE term_id=".$V['term_id'];
    582. 

  582. 				$res=$wpdb->get_row($query);
    583. 

  583. 				$OriginalTerm=$res->name;
    584. 

  584. 				$NewTerm=$V['name'];
    585. 

  585. 				$q1="UPDATE ".$wpdb->terms." SET name='$NewTerm' WHERE term_id=".$V['term_id'];
    586. 

  586. 				$wpdb->query($q1);
    587. 

  587. 				$q1="UPDATE $termtrans SET name='$OriginalTerm', LanguageID='$OldLang' WHERE LanguageID='$DefLang' and term_id=".$V['term_id'];
    588. 

  588. 

  589. 				$wpdb->query($q1);
    590. 

  590. 			}
    591. 

  591. 			echo '<p>'.__('Default Languages Exchanged','zd_multilang').'</p>';
    592. 

  592. 		}
    593. 

  593. 		echo '<p>'.__('Options updated','zd_multilang').'</p>';
    594. 

  594. 		echo '</div>';
    595. 

  595. 	}
    596. 

  596. 	$query="SELECT * FROM $language_table order by LanguageName";
    597. 

  597. 	$Languages=$wpdb->get_results($query, ARRAY_A);
    598. 

  598. 	$DefaultLanguage=get_option($default_language_option);
    599. 

  599. 	$InsertInPosts=get_option($insert_lang_switch_option);
    600. 

  600. 	$ShowLanguages=get_option($show_languages_option);
    601. 

  601. 	$ShowFlags=get_option($show_flags_option);
    602. 

  602. 	$SwitcherPosition=get_option('zd_multilang_position');
    603. 

  603. 	$DisplayUntranslated=get_option($display_untranslated);
    604. 

  604. 	$DisplayGlink=get_option($display_google_translate);
    605. 

  605. 	$DisplayOriginal=get_option($display_original_option);
    606. 

  606. 	$Lang_Switch_Class=(get_option($lang_switcher_class_option)!="") ? get_option($lang_switcher_class_option) : "lang_switch";
    607. 

  607. 	$Allowed_Access_Level=get_option($Allowed_Access);
    608. 

  608. 	$Autosave=get_option($Autosave_Option);
    609. 

  609. 	
    610. 

  610. 	echo '<style>
    611. 

  611. 	td select { width: 150px;}
    612. 

  612. 	td input { width: 150px;}
    613. 

  613. 	</style>';
    614. 

    615. 

  615. 	echo "\n\t<h2>".__('General Options','zd_multilang')."</h2>";
    616. 

  616. 	echo "\n\t".'<form action="'.$BaseURL.'" method="post">';
    617. 

  617. 	echo "\n\t".'<input type="hidden" name="'.$hidden_field.'" value="update" />';
    618. 

  618. 	echo "\n\t".'<input type="hidden" name="fct" value="options" />';
    619. 

  619. 	echo "\n\t".'<table class="form-table">';
    620. 

  620. 	echo "\n\t\t<tr><td width=\"400\">".__('Level required to translate items','zd_multilang')."</td><td>";
    621. 

  621. 		echo '<select name="access_level">';
    622. 

  622. 			echo '<option value="0"';if ($Allowed_Access_Level=="0") echo ' selected="selected"';echo '>'.__('Subscriber').'</option>';
    623. 

  623. 			echo '<option value="1"';if ($Allowed_Access_Level=="1") echo ' selected="selected"';echo '>'.__('Contributor').'</option>';
    624. 

  624. 			echo '<option value="2"';if ($Allowed_Access_Level=="2") echo ' selected="selected"';echo '>'.__('Author').'</option>';
    625. 

  625. 			echo '<option value="7"';if ($Allowed_Access_Level=="7") echo ' selected="selected"';echo '>'.__('Editor').'</option>';
    626. 

  626. 			echo '<option value="10"';if ($Allowed_Access_Level=="10") echo ' selected="selected"';echo '>'.__('Administrator').'</option>';
    627. 

  627. 		echo '</select>';
    628. 

  628. 	echo "</td></tr>";
    629. 

  629. 	echo "\n\t\t<tr><td>".__('Default Language','zd_multilang')."</td><td>";
    630. 

  630. 		echo '<select name="def_lang" onchange="getElementById(\'hidden_option\').style.display=\'table-row\';">';
    631. 

  631. 			if ($Languages) foreach ($Languages as $Index => $Values) {
    632. 

  632. 				echo '<option value="'.$Values['LanguageID'].'"';
    633. 

  633. 					if ($DefaultLanguage==$Values['LanguageID']) echo ' selected="selected"';
    634. 

  634. 				echo '>'.$Values['LanguageName'].'</option>';
    635. 

  635. 			}
    636. 

  636. 		echo '</select>';
    637. 

  637. 	echo "</td></tr>";
    638. 

  638. 	echo "\n\t\t<tr id=\"hidden_option\" style=\"display: none;\"><td>".__('Exchange Languages','zd_multilang')."<br /><small>".__('Only use this option if you want to switch old default language with new one. This will exchange translations between them','zd_multilang')."</small></td><td>";
    639. 

  639. 		echo '<input type="checkbox" name="exchange_lang">';
    640. 

  640. 	echo "</td></tr>";
    641. 

  641. 	echo "\n\t\t<tr><td>".__('Display Original post while translating','zd_multilang')."</td><td>";
    642. 

  642. 		echo '<select name="display_original">';
    643. 

  643. 			echo '<option value="yes"';if ($DisplayOriginal=="yes") echo ' selected="selected"';echo '>'.__('Yes','zd_multilang').'</option>';
    644. 

  644. 			echo '<option value="no"';if ($DisplayOriginal=="no") echo ' selected="selected"';echo '>'.__('No','zd_multilang').'</option>';
    645. 

  645. 		echo '</select>';
    646. 

  646. 	echo "</td></tr>";
    647. 

  647. 	echo "\n\t\t<tr><td>".__('Automatically save translation every 5 minutes','zd_multilang')."</td><td>";
    648. 

  648. 		echo '<select name="autosave">';
    649. 

  649. 			echo '<option value="yes"';if ($Autosave=="yes") echo ' selected="selected"';echo '>'.__('Yes','zd_multilang').'</option>';
    650. 

  650. 			echo '<option value="no"';if ($Autosave=="no") echo ' selected="selected"';echo '>'.__('No','zd_multilang').'</option>';
    651. 

  651. 		echo '</select>';
    652. 

  652. 	echo "</td></tr>";
    653. 

  653. 	echo "\n\t\t<tr><td>".__('Generate permalink for Default language','zd_multilang')."</td><td>";
    654. 

  654. 		echo '<select name="permalink_for_default">';
    655. 

  655. 			echo '<option value="yes"';if ($PermalinkDef=="yes") echo ' selected="selected"';echo '>'.__('Yes','zd_multilang').'</option>';
    656. 

  656. 			echo '<option value="no"';if ($PermalinkDef=="no") echo ' selected="selected"';echo '>'.__('No','zd_multilang').'</option>';
    657. 

  657. 		echo '</select>';
    658. 

  658. 	echo "</td></tr>";
    659. 

  659. 	echo "\n\t\t<tr><td>".__('Keep separate comments for each language','zd_multilang')."</td><td>";
    660. 

  660. 		echo '<select name="keep_separate_comments">';
    661. 

  661. 			echo '<option value="yes"';if ($KeepSeparateComments=="yes") echo ' selected="selected"';echo '>'.__('Yes','zd_multilang').'</option>';
    662. 

  662. 			echo '<option value="no"';if ($KeepSeparateComments=="no") echo ' selected="selected"';echo '>'.__('No','zd_multilang').'</option>';
    663. 

  663. 		echo '</select>';
    664. 

  664. 	echo "</td></tr>";
    665. 

  665. 	echo "\n\t\t<tr><td>".__('Display untranslated posts','zd_multilang')."</td><td>";
    666. 

  666. 		echo '<select name="display_untranslated">';
    667. 

  667. 			echo '<option value="show"';if ($DisplayUntranslated=="show") echo ' selected="selected"';echo '>'.__('Show','zd_multilang').'</option>';
    668. 

  668. 			echo '<option value="hide"';if ($DisplayUntranslated=="hide") echo ' selected="selected"';echo '>'.__('Hide','zd_multilang').'</option>';
    669. 

  669. 		echo '</select>';
    670. 

  670. 	echo "</td></tr>";
    671. 

  671. 	echo "\n\t\t<tr><td>".__('If Yes, display link "Translate Original post with Google Translate"','zd_multilang')."</td><td>";
    672. 

  672. 		echo '<select name="display_glink">';
    673. 

  673. 			echo '<option value="show"';if ($DisplayGlink=="show") echo ' selected="selected"';echo '>'.__('Show','zd_multilang').'</option>';
    674. 

  674. 			echo '<option value="hide"';if ($DisplayGlink=="hide") echo ' selected="selected"';echo '>'.__('Hide','zd_multilang').'</option>';
    675. 

  675. 		echo '</select>';
    676. 

  676. 	echo "</td></tr>";
    677. 

  677. 	echo '</table>';
    678. 

  678. 	echo '<br /><h2>'.__('Language Switcher','zd_multilang').'</h2>';
    679. 

  679. 	echo "\n\t".'<table class="form-table">';
    680. 

  680. 	echo "\n\t\t<tr><td width=\"400\">".__('Show Language Switcher in post','zd_multilang')."</td><td>";
    681. 

  681. 		echo '<select name="show_language_switcher">';
    682. 

  682. 			echo '<option value="show"';if ($InsertInPosts=="show") echo ' selected="selected"';echo '>'.__('Show','zd_multilang').'</option>';
    683. 

  683. 			echo '<option value="hide"';if ($InsertInPosts=="hide") echo ' selected="selected"';echo '>'.__('Hide','zd_multilang').'</option>';
    684. 

  684. 		echo '</select>';
    685. 

  685. 	echo "</td></tr>";
    686. 

  686. 	echo "\n\t\t<tr><td>".__('Language Switcher Position','zd_multilang')."</td><td>";
    687. 

  687. 		echo '<select name="language_switcher_position">';
    688. 

  688. 			echo '<option value="top"';if ($SwitcherPosition=="top") echo ' selected="selected"';echo '>'.__('Top','zd_multilang').'</option>';
    689. 

  689. 			echo '<option value="footer"';if ($SwitcherPosition=="footer") echo ' selected="selected"';echo '>'.__('Bottom','zd_multilang').'</option>';
    690. 

  690. 		echo '</select>';
    691. 

  691. 	echo "</td></tr>";
    692. 

  692. 	echo "\n\t\t<tr><td>".__('Show Language names in switcher','zd_multilang')."</td><td>";
    693. 

  693. 		echo '<select name="show_languages">';
    694. 

  694. 			echo '<option value="show"';if ($ShowLanguages=="show") echo ' selected="selected"';echo '>'.__('Show','zd_multilang').'</option>';
    695. 

  695. 			echo '<option value="hide"';if ($ShowLanguages=="hide") echo ' selected="selected"';echo '>'.__('Hide','zd_multilang').'</option>';
    696. 

  696. 		echo '</select>';
    697. 

  697. 	echo "</td></tr>";
    698. 

  698. 	echo "\n\t\t<tr><td>".__('Show Flags in switcher','zd_multilang')."</td><td>";
    699. 

  699. 		echo '<select name="show_flags">';
    700. 

  700. 			echo '<option value="show"';if ($ShowFlags=="show") echo ' selected="selected"';echo '>'.__('Show','zd_multilang').'</option>';
    701. 

  701. 			echo '<option value="hide"';if ($ShowFlags=="hide") echo ' selected="selected"';echo '>'.__('Hide','zd_multilang').'</option>';
    702. 

  702. 		echo '</select>';
    703. 

  703. 	echo "</td></tr>";	echo "\n\t\t<tr><td>".__('Language Switcher CSS class','zd_multilang')."</td><td>";
    704. 

  704. 		echo '<input name="lang_switch_class" value="'.$Lang_Switch_Class.'">';
    705. 

  705. 	echo "</td></tr>";
    706. 

  706. 	echo "\n\t".'</table>';
    707. 

  707. 	echo "\n\t".'<p class="submit"><input class="button" type="submit" value="'.__('Update options','zd_multilang').'" name="submit"/></p>';
    708. 

  708. 	echo "\n".'</form>';
    709. 

  709. }
    710. 

  710. 

  711. function zd_multilang_edit_language() {
    712. 

  712. 	global $wpdb, $BaseURL,$default_language_option, $BaseURL, $PluginDIR, $wp_rewrite;
    713. 

  713. 	global $ZdmlCache;
    714. 

  714. 	$language_table= $wpdb->prefix.'zd_ml_langs';
    715. 

  715. 	$hidden_field="zd_multilang_edit_language";
    716. 

  716. 

  717. 

  718. 	if ($_POST[$hidden_field]) {
    719. 

  719. 		$Action=$_POST[$hidden_field];
    720. 

  720. 		$LangCode=$_POST['lang_code'];
    721. 

  721. 		$LangName=$_POST['lang_name'];
    722. 

  722. 		$LangPermalink=$_POST['lang_permalink'];
    723. 

  723. 		$BlogName=$_POST['blog_name'];
    724. 

  724. 		$BlogDesc=$_POST['blog_description'];
    725. 

  725. 		echo '<div id="message" class="updated fade"><p>';
    726. 

  726. 		if ($Action=="edit") {
    727. 

  727. 			$query="UPDATE $language_table set LanguageName='$LangName',LangPermalink='$LangPermalink', BlogName='$BlogName', BlogDescription='$BlogDesc' WHERE LanguageID='$LangCode'";
    728. 

  728. 			$wpdb->query($query);
    729. 

  729. 			if ($_POST['def_lang']=="on") update_option($default_language_option,$LangCode);
    730. 

  730. 			echo __('Language Edited','zd_multilang');
    731. 

  731. 		}
    732. 

  732. 		echo '</p></div>';
    733. 

  733. 		zd_multilang_languages();
    734. 

  734. 		return;
    735. 

  735. 	}
    736. 

  736. 	$DefaultLanguage=$ZdmlCache['DefLang'];
    737. 

  737. 	$Code=$_GET['lang'];
    738. 

  738. 	$query="SELECT * FROM $language_table where LanguageID='$Code'";
    739. 

  739. 	$row=$wpdb->get_row($query, ARRAY_A);
    740. 

  740. 	
    741. 

  741. 	echo "<h2>".__('Languages','zd_multilang').'</h2><br />';
    742. 

  742. 	echo "<h3>".__('Edit Language','zd_multi').' <em>'.$_GET['lang'].'</em></h3>';
    743. 

  743. 	echo "\n\t".'<form action="'.$BaseURL.'" method="post">';
    744. 

  744. 	echo "\n\t".'<input type="hidden" name="lang_code" value="'.$Code.'" />';
    745. 

  745. 	echo "\n\t".'<input type="hidden" name="'.$hidden_field.'" value="edit" />';
    746. 

  746. 	echo "\n\t".'<input type="hidden" name="fct" value="edit" />';
    747. 

  747. 	echo "\n\t".'<table>';
    748. 

  748. 	echo "\n\t\t<tr><td>".__('Language Name','zd_multilang')."</td><td>";
    749. 

  749. 		echo '<input type="text" name="lang_name" value="'.$row['LanguageName'].'">';
    750. 

  750. 	echo "</td></tr>";
    751. 

  751. 	echo "\n\t\t<tr><td>".__('Language Permalink','zd_multilang')."</td><td>";
    752. 

  752. 		echo '<input type="text" name="lang_permalink" value="'.$row['LangPermalink'].'">';
    753. 

  753. 	echo "</td></tr>";
    754. 

  754. 	echo "\n\t\t<tr><td>".__('Blog name','zd_multilang')."</td><td>";
    755. 

  755. 		echo '<input type="text" name="blog_name" value="'.$row['BlogName'].'">';
    756. 

  756. 	echo "</td></tr>";
    757. 

  757. 	echo "\n\t\t<tr><td>".__('Blog description','zd_multilang')."</td><td>";
    758. 

  758. 		echo '<input type="text" name="blog_description" value="'.$row['BlogDescription'].'">';
    759. 

  759. 	echo "</td></tr>";
    760. 

  760. 	echo "\n\t\t<tr><td>".__('Default Language','zd_multilang')." ?</td><td>";
    761. 

  761. 		if ($row['LanguageID']==$DefaultLanguage) $selected='checked="on"';
    762. 

  762. 		else $selected="";
    763. 

  763. 		echo '<input type="checkbox" name="def_lang" '.$selected.'>';
    764. 

  764. 	echo "</td></tr>";
    765. 

  765. 	echo "\n\t".'</table>';
    766. 

  766. 	echo "\n\t".'<p class="submit"><input class="button" type="submit" value="'.__('Edit Language','zd_multilang').'" name="submit"/></p>';
    767. 

  767. 	echo "\n\t</form>";
    768. 

  768. }
    769. 

  769. 

  770. function zd_multilang_languages() {
    771. 

  771. 	global $ZdmlCache;
    772. 

  772. 	global $wpdb, $BaseURL,$default_language_option, $BaseURL, $PluginDIR, $wp_rewrite;
    773. 

  773. 	$language_table= $wpdb->prefix.'zd_ml_langs';
    774. 

  774. 

  775. 	$hidden_field="zd_multilang_add_language";
    776. 

  776. 

  777. 	echo "<h2>".__('Languages','zd_multilang').'</h2><br />';
    778. 

  778. 

  779. 	if ($_POST[$hidden_field]) {
    780. 

  780. 		$Action=$_POST[$hidden_field];
    781. 

  781. 		$LangCode=$_POST['lang_code'];
    782. 

  782. 		$LangName=$_POST['lang_name'];
    783. 

  783. 		$LangPermalink=$_POST['lang_permalink'];
    784. 

  784. 		echo '<div id="message" class="updated fade"><p>';
    785. 

  785. 		if ($Action=="add") {
    786. 

  786. 			$query="INSERT INTO $language_table VALUES ('$LangCode','$LangName','$LangPermalink',NULL,NULL)";
    787. 

  787. 			$wpdb->query($query);
    788. 

  788. 			if ($_POST['def_lang']=="on") update_option($default_language_option,$LangCode);
    789. 

  789. 			echo __('Language Added','zd_multilang');
    790. 

  790. 		}
    791. 

  791. 		echo '</p></div><br />';
    792. 

  792. 	}
    793. 

  793. 

  794. 	$DefaultLanguage=$ZdmlCache['DefLang'];
    795. 

  795. 	$query="SELECT * FROM $language_table order by LanguageName";
    796. 

  796. 	$Languages=$wpdb->get_results($query, ARRAY_A);
    797. 

  797. 	if ($Languages) {
    798. 

  798. 		echo '<table class="widefat">';
    799. 

  799. 		echo '<tr style="background: #E4F2FD";><th>'.__('Action','zd_multilang').'</th><th>'.__('Language Name','zd_multilang').'</th><th>'.__('Language Code','zd_multilang').'</th><th>'.__('Permalink','zd_multilang').'</th><th>'.__('Default','zd_multilang').'</th></tr>';
    800. 

  800. 		foreach ($Languages as $Index => $Values) {
    801. 

  801. 			echo '<tr>';
    802. 

  802. 				echo '<td><span class="edit_language"><a href="'.$BaseURL.'&amp;fct=edit&amp;lang='.$Values['LanguageID'].'">'.__('Edit','zd_multilang').'</a>&nbsp;-&nbsp;<a href="'.$BaseURL.'&amp;fct=delete&amp;lang='.$Values['LanguageID'].'">'.__('Delete','zd_multilang').'</a></span></td>';
    803. 

  803. 				echo '<td><img src="'.$PluginDIR.'/flags/'.$Values['LanguageID'].'.png">&nbsp;'.$Values['LanguageName'].'</td>';
    804. 

  804. 				echo '<td>'.$Values['LanguageID'].'</td>';
    805. 

  805. 				echo '<td>'.$Values['LangPermalink'].'</td>';
    806. 

  806. 				echo '<td>&nbsp;';
    807. 

  807. 					if ($Values['LanguageID']==$DefaultLanguage) echo "<strong>".__('Default Language', 'zd_multilang')."</strong>";
    808. 

  808. 				echo '</td>';
    809. 

  809. 			echo '</tr>';
    810. 

  810. 		}
    811. 

  811. 		echo '</table>';
    812. 

  812. 	}
    813. 

  813. 	
    814. 

  814. 	echo "<div id=\"form\" style=\"float: left; margin-right: 30px;\"><h3>".__('Add Language','zd_multilang').'</h3>';
    815. 

  815. 	echo "\n\t".'<form action="'.$BaseURL.'" method="post">';
    816. 

  816. 	echo "\n\t".'<input type="hidden" name="'.$hidden_field.'" value="add" />';
    817. 

  817. 	echo "\n\t".'<input type="hidden" name="fct" value="languages" />';
    818. 

  818. 	echo "\n\t".'<table>';
    819. 

  819. 	echo "\n\t\t<tr><td>".__('Language Name','zd_multilang')."</td><td>";
    820. 

  820. 		echo '<input type="text" name="lang_name" id="lang_name">';
    821. 

  821. 	echo "</td></tr>";
    822. 

  822. 	echo "\n\t\t<tr><td>".__('Language Code','zd_multilang')."</td><td>";
    823. 

  823. 		echo '<input type="text" name="lang_code" id="lang_code">';
    824. 

  824. 	echo "</td></tr>";
    825. 

  825. 	echo "\n\t\t<tr><td>".__('Language Permalink','zd_multilang')."</td><td>";
    826. 

  826. 		echo '<input type="text" name="lang_permalink" id="lang_permalink">';
    827. 

  827. 	echo "</td></tr>";
    828. 

  828. 	echo "\n\t\t<tr><td>".__('Default Language','zd_multilang')." ?</td><td>";
    829. 

  829. 		echo '<input type="checkbox" name="def_lang">';
    830. 

  830. 	echo "</td></tr>";
    831. 

  831. 	echo "\n\t".'</table>';
    832. 

  832. 	echo "\n\t".'<p class="submit"><input class="button" type="submit" value="'.__('Add Language','zd_multilang').'" name="submit"/></p>';
    833. 

  833. 	echo "\n\t</form></div><p><a href=\"#\" onclick=\"jQuery('div#help').toggle();\">".__('Show/Hide Available default codes','zd_multilang')."</a></p>";
    834. 

  834. 	
    835. 

  835. 	$DefaultLanguagesCodes=array (
    836. 

  836. 		'ar' => array ('Arabian', 'ar'),'bn_BD' => array ('Bengali','bn'),'be_BY' => array ('Belarusian','be'),
    837. 

  837. 		'bg_BG' => array ('Bulgarian','bg'),'ca' => array ('Catalan','ca'),'zh_CN' => array ('Chinese','cn'),
    838. 

  838. 		'zh_HK' => array ('Hong Kong','hk'),'zh_TW' => array ('Taiwan','tw'),'hr' => array ('Croatian','hr'),
    839. 

  839. 		'cz_CZ' => array ('Czech','cz'),'da_DK' => array ('Danish','dk'),'nl_NL' => array ('Dutch','nl'),
    840. 

  840. 		'en_US' => array ('English','en'),'eu' => array ('Euskadi','eu'),'eo' => array ('Esperanto','eo'),
    841. 

  841. 		'et' => array ('Estonian','et'),'fo' => array ('Faroe','fo'),'fi_FI' => array ('Finnish','fi'),
    842. 

  842. 		'fr_FR' => array ('French','fr'),'gl_ES' => array ('Galician','gl'),'de_DE' => array ('German','de'),
    843. 

  843. 		'el' => array ('Greek','gr'),'he_IL' => array ('Hebrew','il'),'hu_HU' => array ('Hungarian','hu'),
    844. 

  844. 		'is_IS' => array ('Icelandic','is'),'id_ID' => array ('Indonesian','id'),'it_IT' => array ('Italian','it'),
    845. 

  845. 		'ja' => array ('Japanese','jp'),'km_KH' => array ('Khmer','km'),'ko_KR' => array ('Korean','ko'),
    846. 

  846. 		'ku' => array ('Kurdish','ku'),'lv' => array ('Latvian','lv'),'lt' => array ('Lithuanian','lt'),
    847. 

  847. 		'mk_MK' => array ('Macedonian','mk'),'mg_MG' => array ('Malgasy','mg'),'ms_MY' => array ('Malay','my'),
    848. 

  848. 		'nb_NO' => array ('Norwegian','no'),'pl_PL' => array ('Polish','pl'),'pt_BR' => array ('Brazilian Portuguese','br'),
    849. 

  849. 		'pt_PT' => array ('European Portuguese','pt'),'ro' => array ('Romanian','ro'),'ru_RU' => array ('Russian','ru'),
    850. 

  850. 		'sr_RS' => array ('Serbian','sr'),'si_LK' => array ('Sinhala','lk'),'sl_SI' => array ('Slovenian','sl'),
    851. 

  851. 		'sk' => array ('Slovak','sk'),'es_ES' => array ('Spanish','es'),'sv_SE' => array ('Swedish','se'),
    852. 

  852. 		'th' => array ('Thai','th'),'tr' => array ('Turkish','tr'),'ua_UA' => array ('Ukrainian','ua'),
    853. 

  853. 		'uz_UZ' => array ('Uzbek','uz'),'vi_VN' => array ('Vietnamse','vn'),'cy' => array ('Welsh','cy')
    854. 

  854. 	);
    855. 

  855. 	
    856. 

  856. 	echo '<div id="help" style="height: 300px; overflow: auto !important; display: none;">
    857. 

  857. 	<table>
    858. 

  858. 		<tr><th width="16">Flag</th><th width="200">'.__('Language Name','zd_multilang').'</th><th>'.__('Language Permalink','zd_multilang').'</th><th>'.__('Language Code','zd_multilang').'</th></tr>';
    859. 

  859. 	foreach ($DefaultLanguagesCodes as $lang_code => $v) {
    860. 

  860. 		echo '<tr><td><img src="'.$PluginDIR.'/flags/'.$lang_code.'.png" alt="'.$v[0].'" title="'.$v[0].'" onclick="zdml_fillInfos(\''.$v[0].'\',\''.$lang_code.'\',\''.$v[1].'\');"/></td><td><a href="javascript:zdml_fillInfos(\''.$v[0].'\',\''.$lang_code.'\',\''.$v[1].'\')">'.$v[0].'</a></td><td>'.$v[1].'</td><td>'.$lang_code.'</td></tr>';
    861. 

  861. 	}
    862. 

  862. 	echo '		</table>
    863. 

  863. </div>
    864. 

  864. <script type="text/javascript">
    865. 

  865. 	function zdml_fillInfos(name, code, permalink) {
    866. 

  866. 		document.getElementById("lang_name").value=name;
    867. 

  867. 		document.getElementById("lang_code").value=code;
    868. 

  868. 		document.getElementById("lang_permalink").value=permalink;
    869. 

  869. 	}
    870. 

  870. </script>';
    871. 

  871. 	
    872. 

  872. 	$wp_rewrite->flush_rules();
    873. 

  873. }
    874. 

  874. 

  875. function zd_multilang_delete_language() {
    876. 

  876. 	global $ZdmlCache;
    877. 

  877. 	global $BaseURL, $wpdb,$default_language_option;
    878. 

  878. 	$DefaultLanguage=$ZdmlCache['DefLang'];
    879. 

  879. 

  880. 	$language_table= $wpdb->prefix.'zd_ml_langs';$termtrans_table = $wpdb->prefix.'zd_ml_termtrans';
    881. 

  881. 	$LangCode=$_GET['lang'];
    882. 

  882. 	$query="DELETE FROM $language_table WHERE LanguageID='$LangCode'";
    883. 

  883. 	$wpdb->query($query);
    884. 

  884. 	$query="DELETE FROM $termtrans_table WHERE LanguageID='$LangCode'";
    885. 

  885. 	$wpdb->query($query);
    886. 

  886. 	
    887. 

  887. 	echo '<br /><div id="message" class="updated fade"><p>';
    888. 

  888. 	echo __('Language deleted','zd_multilang');
    889. 

  889. 	echo '</p></div>';
    890. 

  890. 	zd_multilang_languages();
    891. 

  891. }
    892. 

  892. 

  893. function zd_multilang_post_translations() {
    894. 

  894. 	global $ZdmlCache;
    895. 

  895. 	global $BaseURL, $wpdb,$default_language_option,$PluginDIR, $display_original_option;
    896. 

  896. 	$language_table= $wpdb->prefix.'zd_ml_langs';
    897. 

  897. 	$termtrans_table = $wpdb->prefix.'zd_ml_termtrans';
    898. 

  898. 	$posttrans=$wpdb->prefix.'zd_ml_trans';
    899. 

  899. 	$hidden_field="zd_multilang_edit_translation";
    900. 

  900. 	
    901. 

  901. 	$Autosave=get_option('zdmultilang_autosave');
    902. 

  902. 

  903. 	echo "<h2>".__('Posts & Pages','zd_multilang').'</h2>';
    904. 

  904. 	
    905. 

  905. 	$query="SELECT * FROM $language_table order by LanguageName";
    906. 

  906. 	$Languages=$wpdb->get_results($query, ARRAY_A);
    907. 

  907. 	if (!$Languages) {
    908. 

  908. 		echo '<p>'.__('No languages defined, please define some first','zd_multilang').'</p>';
    909. 

  909. 		return;
    910. 

  910. 	}
    911. 

  911. 	$DefaultLanguage=$ZdmlCache['DefLang'];
    912. 

  912. 	
    913. 

  913. 	if ($_POST['id']) {
    914. 

  914. 		list($ID, $Lang) = split("\.",$_POST['id']);
    915. 

  915. 		$Content=$_POST['content'];
    916. 

  916. 		$Title=$_POST['post_title'];
    917. 

  917. 		$Status=$_POST['post_status'];
    918. 

  918. 		$Excerpt=$_POST['post_excerpt'];
    919. 

  919. 		$var=$wpdb->get_var("SELECT ID from $posttrans WHERE ID='$ID' and LanguageID='$Lang'");
    920. 

  920. 		if ($var==$ID) {
    921. 

  921. 			$query="UPDATE $posttrans set post_content='$Content', post_title='$Title', post_status='$Status', post_excerpt='$Excerpt' WHERE ID='$ID' and LanguageID='$Lang'";
    922. 

  922. 		} else $query="INSERT INTO $posttrans (`ID`, `LanguageID`, `post_content`, `post_title`, `post_status`, `post_excerpt`) values ('$ID', '$Lang', '$Content', '$Title','$Status', '$Excerpt')";
    923. 

  923. 		$wpdb->query($query);
    924. 

  924. 		echo '<div id="message" class="updated fade"><p>';
    925. 

  925. 		echo __('Post or Page updated','zd_multilang');
    926. 

  926. 		echo '</p></div><br />';
    927. 

  927. 		$_GET['id']=$_POST['id'];
    928. 

  928. 	}
    929. 

  929. 	if ($_GET['id']) {
    930. 

  930. 		list($ID, $Lang) = split('\.', $_GET['id']);
    931. 

  931. 		$query='SELECT * FROM  '.$wpdb->prefix.'posts WHERE ID='.$ID;
    932. 

  932. 		$res=$wpdb->get_results($query);
    933. 

  933. 		$OriginalText=str_replace(array("\r","\n"),array ("",""), strip_tags($res[0]->post_content));
    934. 

  934. 		$OriginalPost=$res[0]->post_content;
    935. 

  935. 		echo '<div id="poststuff">';
    936. 

  936. 		$query="SELECT * FROM $posttrans WHERE LanguageID='$Lang' and ID=".$ID;
    937. 

  937. 		$res=$wpdb->get_results($query, ARRAY_A);
    938. 

  938. 		
    939. 

  939. 		if ($res[0]['post_status']==NULL) $res[0]['post_status']='draft';
    940. 

  940. 

  941. 		$From=array_search($DefaultLanguage,$ZdmlCache['Languages']);
    942. 

  942. 		$To=array_search($Lang,$ZdmlCache['Languages']);
    943. 

  943. 

  944. 		echo '<form action="'.$BaseURL.'" method="post">';
    945. 

  945. 		echo '<input type="hidden" name="fct" value="posts" />';
    946. 

  946. 		echo '<input type="hidden" name="id" value="'.$_GET['id'].'" />';
    947. 

  947. 		echo '<div id="poststuff" class="metabox-holder has-right-sidebar">';
    948. 

  948. 		echo '<div id="side-info-column" class="inner-sidebar submitbox">
    949. 

  949. 			<div id="side-sortables" class="meta-box-sortables ui-sortable" style="position: relative;">
    950. 

  950. 				<div id="submitpost" class="postbox inside">
    951. 

  951. 					<p><strong><label for="post_status">'.__('Translation Status','zd_multilang').'</label></strong></p>
    952. 

  952. 					<p>
    953. 

  953. 					<select tabindex="4" id="post_status" name="post_status">
    954. 

  954. 					<option value="published"';if ($res[0]['post_status']=="published") echo ' selected="selected"';echo '>'.__('Published','zd_multilang').'</option>
    955. 

  955. 					<option value="draft"';if ($res[0]['post_status']=="draft") echo ' selected="selected"';echo '>'.__('Draft','zd_multilang').'</option>
    956. 

  956. 					</select>
    957. 

  957. 					</p>
    958. 

  958. 					<p id="autosave_status" style="display: none;"><strong>Post autosaved</strong></p>
    959. 

  959. 					</div>
    960. 

  960. 					<p class="submit">
    961. 

  961. 					<input type="submit" class="button button-highlighted" tabindex="4" value="Save" id="save-post" name="save"/>
    962. 

  962. 					<br class="clear"/>
    963. 

  963. 					</p>
    964. 

  964. 				<div class="side-info">
    965. 

  965. 					<h5>'.__('Actions','zd_multilang').'</h5>
    966. 

  966. 					<ul>
    967. 

  967. 					<li><a href="post.php?action=edit&post='.$ID.'" target="_blank">'.__('See Original post','zd_multilang').'</a></li>
    968. 

  968. 					<li><a href="http://translate.google.com/translate_t#'.$From.'|'.$To.'|'.addslashes(htmlentities($OriginalText,ENT_COMPAT,'UTF-8')).'" target="_blank">'.__('See translation in Google Translate','zd_multilang').'</a></li>
    969. 

  969. 					</ul>
    970. 

  970. 					<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
    971. 

  971. <input type="hidden" name="cmd" value="_s-xclick">
    972. 

  972. <input type="hidden" name="hosted_button_id" value="8262513">
    973. 

  973. <input type="image" src="https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
    974. 

  974. <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
    975. 

  975. </form>
    976. 

  976. 				</div>
    977. 

  977. 			</div>';
    978. 

  978. 		echo '</div>';
    979. 

  979. 		
    980. 

  980. 			echo '<div id="post-body" class="has-sidebar">';
    981. 

  981. 			echo '<div id="post-body-content" class="has-sidebar-content">';
    982. 

  982. 				echo '<div id="titlediv"><h3>'.__('Title','zd_multilang').'</h3>';
    983. 

  983. 					echo '<div id="titlewrap"><input id="title" type="text" autocomplete="off" tabindex="1" size="30" name="post_title" value="'.$res[0]['post_title'].'"></div>';
    984. 

  984. 				echo '</div>';
    985. 

  985. 				echo '<div id="';echo user_can_richedit() ? 'postdivrich' : 'postdiv';echo '" class="postarea">';
    986. 

  986. 					echo '<h3>'.__('Translations','zd_multilang').'</h3>';
    987. 

  987. 					echo '<input type="hidden" id="user-id" name="user_ID" value="'.$user_ID.'" />';
    988. 

  988. 					the_editor($res[0]['post_content']);
    989. 

  989. 				echo '</div>';
    990. 

  990. 				echo '<div id="titlediv" style="margin-bottom: 0px;"><h3>'.__('Excerpt','zd_multilang').'</h3></div>
    991. 

  991. 				<div id="tr_excerpt" class="postarea">
    992. 

  992. 					<textarea id="post_excerpt" name="post_excerpt" style="width: 98%; height: 150px;">'.$res[0]['post_excerpt'].'</textarea>
    993. 

  993. 				</div>';
    994. 

  994. 				$DisplayOriginal=get_option($display_original_option);
    995. 

  995. 				if ($DisplayOriginal=='yes') {
    996. 

  996. 					$OriginalPost = apply_filters('the_content', $OriginalPost);
    997. 

  997. 					$OriginalPost = str_replace(']]>', ']]&gt;', $OriginalPost);
    998. 

  998. 					echo '<div id="titlediv" style="margin-bottom: 0px;"><h3>'.__('Original post','zd_multilang').'</h3></div>
    999. 

  999. 					<div style="border:1px solid #CCCCCC; padding: 5px;overflow: auto; height: 300px;">'.$OriginalPost.'</div>';
    1000. 

  1000. 				}
    1001. 

  1001. 			echo '</div>';
    1002. 

  1002. 		echo '</div>';
    1003. 

  1003. 		if ($Autosave=='yes') {
    1004. 

  1004. 			wp_print_scripts('sack');
    1005. 

  1005. 			echo '<script type="text/javascript">
    1006. 

  1006. 		setTimeout(\'zdml_autosave();\',300000);
    1007. 

  1007. 		function zdml_autosave() {
    1008. 

  1008. 			content=tinyMCE.activeEditor.getContent();
    1009. 

  1009. 			var mysack = new sack("'.get_bloginfo( 'wpurl' ).'/wp-admin/admin-ajax.php" );
    1010. 

  1010. 			if (jQuery(\'#post_status\').val()=="published") return;
    1011. 

  1011. 			mysack.execute = 1;
    1012. 

  1012. 			mysack.method = \'POST\';
    1013. 

  1013. 			mysack.setVar( "id", \''.$_GET['id'].'\' );
    1014. 

  1014. 			mysack.setVar( "content", content );
    1015. 

  1015. 			mysack.setVar( "action", "zdmultilang_autosave" );
    1016. 

  1016. 			mysack.setVar( "post_title", jQuery(\'#title\').val() );
    1017. 

  1017. 			mysack.setVar( "post_status", jQuery(\'#post_status\').val() );
    1018. 

  1018. 			mysack.setVar( "post_excerpt", jQuery(\'#post_excerpt\').val() );
    1019. 

  1019. 			mysack.onError = function() { alert(\'Ajax error in outlink collection\' )};
    1020. 

  1020. 			mysack.runAJAX();
    1021. 

  1021. 			setTimeout(\'zdml_autosave();\',300000);
    1022. 

  1022. 		}
    1023. 

  1023. 	</script>';
    1024. 

  1024. 		}
    1025. 

  1025. 		echo '<br class="clear" />
    1026. 

  1026. 		</div>';
    1027. 

  1027. 		echo '</form>';
    1028. 

  1028. 	} else if ($_GET['tr']) {
    1029. 

  1029. 		switch ($_GET['tr']) {
    1030. 

  1030. 			case 'posts':
    1031. 

  1031. 				$query='SELECT * FROM '.$wpdb->prefix.'posts WHERE post_type="post" order by post_status, post_date desc';
    1032. 

  1032. 				break;
    1033. 

  1033. 			case 'pages':
    1034. 

  1034. 				$query='SELECT * FROM '.$wpdb->prefix.'posts WHERE post_type="page" order by post_status, post_date desc';
    1035. 

  1035. 				break;
    1036. 

  1036. 			default:
    1037. 

  1037. 				$query="";
    1038. 

  1038. 				break;
    1039. 

  1039. 		}
    1040. 

  1040. 		
    1041. 

  1041. 		$q="SELECT * from $posttrans order by ID";
    1042. 

  1042. 		$Translated=$wpdb->get_results($q, ARRAY_A);
    1043. 

  1043. 		if ($Translated) foreach ($Translated as $Idx => $Row) {
    1044. 

  1044. 			$Posts[$Row['ID']][$Row['LanguageID']]=$Row['post_status'];
    1045. 

  1045. 		}
    1046. 

  1046. 		
    1047. 

  1047. 		$results=$wpdb->get_results($query, ARRAY_A);
    1048. 

  1048. 		if ($results) {
    1049. 

  1049. 			echo '<table class="widefat">';
    1050. 

  1050. 			echo '<tr style="background: rgb(228, 242, 253);"><th>'.__('Original title','zd_multilang').'</th><th>'.__('Published date', 'zd_multilang').'</th>';
    1051. 

  1051. 			forea…
    1052.

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