1 <?php

     2 /*

     3 Plugin Name: ZdMultiLang

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

     5 Description: This plugin adds multilingual capabilities to wordpress

     6 Version: 1.2.5

     7 Author: Anthony PETITBOIS, Pau Sanchez

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

     9 

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

    11 

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

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

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

    15     (at your option) any later version.

    16 

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

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

    19     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    20     GNU General Public License for more details.

    21 

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

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

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

    25 */

    26 

    27 $ZdmlCache=array();

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

    29 $default_language_option="zd_multilang_defaultlanguage";

    30 $insert_lang_switch_option="zd_multilang_lang_switcher";

    31 $show_flags_option="zd_multilang_show_flags";

    32 $show_languages_option="zd_multilang_langnames";

    33 $lang_switcher_class_option="zd_multilang_switcher_class";

    34 $permalink_default="zd_multilang_permalink_def";

    35 $display_untranslated="zd_multilang_display_untranslated";

    36 $display_google_translate="zd_multilang_display_glink";

    37 $display_original_option="zd_multilang_display_original";

    38 $keep_separate_comments="zd_multilang_keep_separate_comments";

    39 $Allowed_Access="zd_multilang_access";

    40 $Autosave_Option="zdmultilang_autosave";

    41 $CurrentLanguagePermalink="";

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

    43 

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

    45 register_activation_hook(__FILE__,'zd_multilang_install');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    79 /* Filters for comments */

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

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

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

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

    84 

    85 /* Options short circuit */

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

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

    88 /* Options short circuit */

    89 

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

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

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

    93 

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

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

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

    97 

    98 zd_multilang_set_locale("");

    99 

   100 function zd_multilang_tinymce() {

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

   102 		wp_enqueue_script( 'common' );

   103 		wp_enqueue_script( 'jquery-color' );

   104 		wp_print_scripts('editor');

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

   106 		wp_print_scripts('media-upload');

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

   108 		wp_admin_css();

   109 		wp_enqueue_script('utils');

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

   111 		do_action('admin_print_styles');

   112 	}

   113 }

   114 

   115 function zd_multilang_queryvars( $qvars ) {

   116   $qvars[] = 'lang';

   117   return $qvars;

   118 }

   119 

   120 function zd_multilang_manage_col_def ($cols) {

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

   122 	return $cols;

   123 }

   124 

   125 function zd_multilang_manage_col($column_name, $id) {

   126 	global $ZdmlCache, $PluginDIR;

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

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

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

   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 		}

   132 	}

   133 }

   134 

   135 function zd_media_button() {

   136 	global $ZdmlCache, $PluginDIR;

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

   138 	if ($id) {

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

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

   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 		}

   143 	}

   144 }

   145 

   146 function zd_multilang_where_filter($filter) {

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

   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 		$lang=$WP->query['lang'];

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

   152 		$wp_query->is_page=1;

   153 		$wp_query->is_home=0;

   154 	}

   155 	

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

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

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

   159 	}

   160 	return $filter;

   161 }

   162 

   163 function zd_multilang_np_where_filter($filter) {

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

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

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

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

   168 	}

   169 	return $filter;

   170 }

   171 

   172 function zd_multilang_set_locale($WP) {

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

   174 	global $ZdmlCache;

   175 	

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

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

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

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

   180 

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

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

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

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

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

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

   187 

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

   189 	

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

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

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

   193 		if ($results) {

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

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

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

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

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

   199 			}

   200 		}

   201 	}	

   202 	 else {

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

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

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

   206 			$i++;

   207 		}

   208 	}

   209 	

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

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

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

   213 

   214 	if ($results) {

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

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

   217 		}

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

   219 	}

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

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

   222 	

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

   224 		$Lang=$res[1];

   225 		$CurrentLanguagePermalink=$res[1];

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

   227 			if ($Permalink==$Lang) {

   228 				$Language= $LangFound;

   229 				break;

   230 			}

   231 		}

   232 		$CurrentLang=$Language;

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

   234 	}

   235 	$locale=$TheLocale;

   236 

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

   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 		$term=$wpdb->get_results($query, ARRAY_A);

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

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

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

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

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

   245 		}

   246 	}

   247 	

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

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

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

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

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

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

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

   255 		}

   256 	}

   257 

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

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

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

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

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

   263 				if ($res) {

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

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

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

   267 					}

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

   269 				}

   270 			}

   271 		}

   272 	}

   273 	

   274 	return $WP;

   275 }

   276 

   277 function zd_multilang_permalink($permalink) {

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

   279 	global $ZdmlCache;

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

   281 	

   282 	$Lang=$CurrentLanguagePermalink;

   283 	if ($Lang=="") {

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

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

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

   287 		$Lang=$CurrentLanguagePermalink;

   288 	}

   289 	$link=$permalink;

   290 

   291 	$PermalinkDef=get_option($permalink_default);

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

   293 	

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

   295 		$url=get_bloginfo('url');

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

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

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

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

   300 

   301 	return $link;

   302 }

   303 

   304 function zd_multilang_rewrite($permalink_structure) {

   305 	global $ZdmlCache;

   306 	global $wpdb, $wp_rewrite;

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

   308 	

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

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

   311 	if ($Lines) {

   312 		$regexp='(';

   313 		foreach ($Lines as $Value) {

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

   315 		}

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

   317 		$regexp.=')';

   318 

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

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

   321 			$rule=$Definition;

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

   323 				$rule="";

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

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

   326 				}

   327 			}

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

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

   330 		}

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

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

   333 	}

   334 	return $permalink_structure;

   335 }

   336 

   337 function zd_multilang_is_translated($id, $lang) {

   338 	global $ZdmlCache, $locale;

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

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

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

   342 		if ($ID==$id) {

   343 			return TRUE;

   344 		}

   345 	}

   346 	return FALSE;

   347 }

   348 

   349 function zd_multilang_install() {

   350 	global $ZdmlCache;

   351 	global $wpdb;

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

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

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

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

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

   357 	

   358 	$dbversion=get_option('zd_multilang_dbschema');

   359 	if ($dbversion<"125") {

   360 		$sql="CREATE TABLE $langs (

   361 			LanguageID varchar(5) NOT NULL,

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

   363 			LangPermalink varchar(50) NOT NULL UNIQUE,

   364 			BlogName longtext,

   365 			BlogDescription longtext,

   366 			primary key (LanguageID)

   367 		);";

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

   369 		dbDelta($sql);

   370 

   371 		$sql="CREATE TABLE $termtrans (

   372 			term_id varchar(5) NOT NULL,

   373 			LanguageID varchar(5) NOT NULL,

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

   375 			description longtext NOT NULL,

   376 			primary key (term_id,LanguageID)

   377 		);";

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

   379 		dbDelta($sql);

   380 		

   381 		$sql="CREATE TABLE $posttrans (

   382 			ID BIGINT(20) NOT NULL,

   383 			LanguageID varchar(5),

   384 			post_content longtext character set utf8,

   385 			post_excerpt text character set utf8,

   386 			post_title text character set utf8 NOT NULL,

   387 			post_status varchar(10),

   388 			primary key (ID, LanguageID)

   389 		);";

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

   391 		dbDelta($sql);

   392 		

   393 		$sql="CREATE TABLE $linktrans (

   394 			link_id BIGINT(20) NOT NULL,

   395 			LanguageID varchar(5),

   396 			link_url varchar(255),

   397 			link_name varchar(255) character set utf8,

   398 			link_description varchar(255) character set utf8,

   399 			primary key (link_id, LanguageID)

   400 		);";

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

   402 		dbDelta($sql);

   403 	

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

   405 		$wpdb->query($sql);

   406 		

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

   408 		$sql="CREATE TABLE $commenttrans (

   409 			comment_id BIGINT(20) UNSIGNED NOT NULL,

   410 			post_id BIGINT(20) UNSIGNED NOT NULL,

   411 			LanguageID varchar(5),

   412 			primary key (comment_id)

   413 		);";

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

   415 		dbDelta($sql);

   416 		

   417 		update_option('zd_multilang_dbschema',125);

   418 		update_option('zd_multilang_access',10);

   419 	}

   420 }

   421 

   422 function zd_multilang_add_pages() {

   423 	global $Allowed_Access;

   424 	$Allowed_Access_Level=get_option($Allowed_Access);

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

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

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

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

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

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

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

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

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

   434 }

   435 

   436 function zd_multilang_page() {

   437 	global $BaseURL, $current_user;

   438 	get_currentuserinfo();

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

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

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

   442 		case 'options':

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

   444 				zd_multilang_options();

   445 			else {

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

   447 				zd_multilang_dashboard();

   448 			}

   449 			break;

   450 		case 'edit':

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

   452 				zd_multilang_edit_language();

   453 			else {

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

   455 				zd_multilang_dashboard();

   456 			}

   457 			break;

   458 		case 'delete':

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

   460 				zd_multilang_delete_language();

   461 			else {

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

   463 				zd_multilang_dashboard();

   464 			}

   465 			break;

   466 		case 'posts':

   467 			zd_multilang_post_translations();

   468 			break;

   469 		case 'translations';

   470 			zd_multilang_term_translations();

   471 			break;

   472 		case 'languages':

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

   474 				zd_multilang_languages();

   475 			else {

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

   477 				zd_multilang_dashboard();

   478 			}

   479 			break;

   480 		case 'links':

   481 			zd_multilang_link_translations();

   482 			break;

   483 		default:

   484 			zd_multilang_dashboard();

   485 			break;

   486 	}

   487 	echo "\n</div>";

   488 }

   489 

   490 function zd_multilang_dashboard() {

   491 	global $BaseURL, $current_user;

   492 	get_currentuserinfo();;

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

   494 	echo '<ul>';

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

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

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

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

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

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

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

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

   503 	echo '</ul>';

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

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

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

   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 <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">

   509 </form>';

   510 }

   511 

   512 function zd_multilang_options() {

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

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

   515 	global $ZdmlCache;

   516 	

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

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

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

   520 	$hidden_field="zd_multilang_update_options";

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

   522 	

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

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

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

   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 <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">

   528 </form>';

   529 	

   530 	if ($_POST[$hidden_field]) {

   531 		$OldLang=get_option($default_language_option);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   546 		

   547 		update_option('zd_multilang_position',$SwitcherPosition);

   548 		update_option($default_language_option,$DefLang);

   549 		update_option($display_original_option, $DisplayOriginal);

   550 		update_option($insert_lang_switch_option,$InsertInPosts);

   551 		update_option($show_languages_option,$Show_Languages);

   552 		update_option($show_flags_option,$Show_Flags);

   553 		update_option($lang_switcher_class_option,$Lang_Switch_Class);

   554 		update_option($permalink_default, $PermalinkDef);

   555 		update_option($display_untranslated,$DisplayUntranslated);

   556 		update_option($display_google_translate,$DisplayGLink);

   557 		update_option($keep_separate_comments, $KeepSeparateComments);

   558 		update_option($Allowed_Access,$Allowed_Access_Level);

   559 		update_option($Autosave_Option,$Autosave);

   560 		

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

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

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

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

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

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

   567 

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

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

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

   571 				$OriginalTitle=$res->post_title;

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

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

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

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

   576 				$wpdb->query($q1);

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

   578 				$wpdb->query($q1);

   579 			}

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

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

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

   583 				$OriginalTerm=$res->name;

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

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

   586 				$wpdb->query($q1);

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

   588 

   589 				$wpdb->query($q1);

   590 			}

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

   592 		}

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

   594 		echo '</div>';

   595 	}

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

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

   598 	$DefaultLanguage=get_option($default_language_option);

   599 	$InsertInPosts=get_option($insert_lang_switch_option);

   600 	$ShowLanguages=get_option($show_languages_option);

   601 	$ShowFlags=get_option($show_flags_option);

   602 	$SwitcherPosition=get_option('zd_multilang_position');

   603 	$DisplayUntranslated=get_option($display_untranslated);

   604 	$DisplayGlink=get_option($display_google_translate);

   605 	$DisplayOriginal=get_option($display_original_option);

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

   607 	$Allowed_Access_Level=get_option($Allowed_Access);

   608 	$Autosave=get_option($Autosave_Option);

   609 	

   610 	echo '<style>

   611 	td select { width: 150px;}

   612 	td input { width: 150px;}

   613 	</style>';

   614 

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

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

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

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

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

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

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

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

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

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

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

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

   627 		echo '</select>';

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

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

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

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

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

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

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

   635 			}

   636 		echo '</select>';

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

   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 		echo '<input type="checkbox" name="exchange_lang">';

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

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

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

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

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

   645 		echo '</select>';

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

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

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

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

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

   651 		echo '</select>';

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

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

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

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

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

   657 		echo '</select>';

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

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

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

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

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

   663 		echo '</select>';

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

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

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

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

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

   669 		echo '</select>';

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

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

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

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

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

   675 		echo '</select>';

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

   677 	echo '</table>';

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

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

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

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

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

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

   684 		echo '</select>';

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

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

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

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

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

   690 		echo '</select>';

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

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

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

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

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

   696 		echo '</select>';

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

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

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

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

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

   702 		echo '</select>';

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

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

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

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

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

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

   709 }

   710 

   711 function zd_multilang_edit_language() {

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

   713 	global $ZdmlCache;

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

   715 	$hidden_field="zd_multilang_edit_language";

   716 

   717 

   718 	if ($_POST[$hidden_field]) {

   719 		$Action=$_POST[$hidden_field];

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

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

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

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

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

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

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

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

   728 			$wpdb->query($query);

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

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

   731 		}

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

   733 		zd_multilang_languages();

   734 		return;

   735 	}

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

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

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

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

   740 	

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   762 		else $selected="";

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

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

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

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

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

   768 }

   769 

   770 function zd_multilang_languages() {

   771 	global $ZdmlCache;

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

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

   774 

   775 	$hidden_field="zd_multilang_add_language";

   776 

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

   778 

   779 	if ($_POST[$hidden_field]) {

   780 		$Action=$_POST[$hidden_field];

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

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

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

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

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

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

   787 			$wpdb->query($query);

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

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

   790 		}

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

   792 	}

   793 

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

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

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

   797 	if ($Languages) {

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

   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 		foreach ($Languages as $Index => $Values) {

   801 			echo '<tr>';

   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 				echo '<td><img src="'.$PluginDIR.'/flags/'.$Values['LanguageID'].'.png">&nbsp;'.$Values['LanguageName'].'</td>';

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

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

   806 				echo '<td>&nbsp;';

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

   808 				echo '</td>';

   809 			echo '</tr>';

   810 		}

   811 		echo '</table>';

   812 	}

   813 	

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   834 	

   835 	$DefaultLanguagesCodes=array (

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

   854 	);

   855 	

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

   857 	<table>

   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 	foreach ($DefaultLanguagesCodes as $lang_code => $v) {

   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 	}

   862 	echo '		</table>

   863 </div>

   864 <script type="text/javascript">

   865 	function zdml_fillInfos(name, code, permalink) {

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

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

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

   869 	}

   870 </script>';

   871 	

   872 	$wp_rewrite->flush_rules();

   873 }

   874 

   875 function zd_multilang_delete_language() {

   876 	global $ZdmlCache;

   877 	global $BaseURL, $wpdb,$default_language_option;

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

   879 

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

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

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

   883 	$wpdb->query($query);

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

   885 	$wpdb->query($query);

   886 	

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

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

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

   890 	zd_multilang_languages();

   891 }

   892 

   893 function zd_multilang_post_translations() {

   894 	global $ZdmlCache;

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

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

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

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

   899 	$hidden_field="zd_multilang_edit_translation";

   900 	

   901 	$Autosave=get_option('zdmultilang_autosave');

   902 

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

   904 	

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

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

   907 	if (!$Languages) {

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

   909 		return;

   910 	}

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

   912 	

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

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

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

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

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

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

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

   920 		if ($var==$ID) {

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

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

   923 		$wpdb->query($query);

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

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

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

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

   928 	}

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

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

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

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

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

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

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

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

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

   938 		

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

   940 

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

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

   943 

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

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

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

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

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

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

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

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

   952 					<p>

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

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

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

   956 					</select>

   957 					</p>

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

   959 					</div>

   960 					<p class="submit">

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

   962 					<br class="clear"/>

   963 					</p>

   964 				<div class="side-info">

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

   966 					<ul>

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

   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 					</ul>

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

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

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

   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 <img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">

   975 </form>

   976 				</div>

   977 			</div>';

   978 		echo '</div>';

   979 		

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

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

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

   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 				echo '</div>';

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

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

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

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

   989 				echo '</div>';

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

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

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

   993 				</div>';

   994 				$DisplayOriginal=get_option($display_original_option);

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

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

   997 					$OriginalPost = str_replace(']]>', ']]>', $OriginalPost);

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

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

  1000 				}

  1001 			echo '</div>';

  1002 		echo '</div>';

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

  1004 			wp_print_scripts('sack');

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

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

  1007 		function zdml_autosave() {

  1008 			content=tinyMCE.activeEditor.getContent();

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

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

  1011 			mysack.execute = 1;

  1012 			mysack.method = \'POST\';

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

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

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

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

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

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

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

  1020 			mysack.runAJAX();

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

  1022 		}

  1023 	</script>';

  1024 		}

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

  1026 		</div>';

  1027 		echo '</form>';

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

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

  1030 			case 'posts':

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

  1032 				break;

  1033 			case 'pages':

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

  1035 				break;

  1036 			default:

  1037 				$query="";

  1038 				break;

  1039 		}

  1040 		

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

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

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

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

  1045 		}

  1046 		

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

  1048 		if ($results) {

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

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

  1051 			foreach ($Languages as $Lang) {

  1052 					if ($Lang['LanguageID']!=$DefaultLanguage) echo '<td><img src="'.$PluginDIR.'/flags/'.$Lang['LanguageID'].'.png" alt="'.$Lang['LanguageName'].'"></td>';

  1053 				}

  1054 			echo '</tr>';

  1055 			foreach ($results as $ID => $row) {

  1056 				echo '<tr>';

  1057 				echo '<td><a href="post.php?action=edit&post='.$row['ID'].'">'.$row['post_title'].'</a></td>';

  1058 				echo '<td>'.date_i18n(get_option('date_format').' - '.get_option('time_format'),strtotime($row['post_date'])).'</td>';

  1059 				foreach ($Languages as $Lang) {

  1060 					if ($Lang['LanguageID']!=$DefaultLanguage) {

  1061 						echo '<td><a href="'.$BaseURL.'&amp;fct=posts&amp;id='.$row['ID'].'.'.$Lang['LanguageID'].'">';

  1062 						if ($Posts[$row['ID']][$Lang['LanguageID']]) echo '<img src="'.$PluginDIR.'/images/edit.png" style="vertical-align: middle;" /> '.__($Posts[$row['ID']][$Lang['LanguageID']],'zd_multilang');

  1063 						else echo '<img src="'.$PluginDIR.'/images/add.png" style="vertical-align: middle;" /> '.__('Translate','zd_multilang');

  1064 						echo '</a></td>';

  1065 					}

  1066 				}

  1067 				echo '</tr>';

  1068 			}

  1069 			echo '</table>';

  1070 		}

  1071 	} else {

  1072 		$query="SELECT distinct(ID) from $posttrans";

  1073 		$res=$wpdb->get_results($query);

  1074 		foreach ($res as $Line) {

  1075 			$count++;

  1076 		}

  1077 		printf(__('%d posts or pages are translated','zd_multilang'),$count);

  1078 	}

  1079 }

  1080 

  1081 function zd_multilang_autosave() {

  1082 	global $wpdb;

  1083 	$posttrans=$wpdb->prefix.'zd_ml_trans';

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

  1085 	$Content=$_POST['content'];

  1086 	$Title=$_POST['post_title'];

  1087 	$Status=$_POST['post_status'];

  1088 	$Excerpt=$_POST['post_excerpt'];

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

  1090 	if ($var==$ID) {

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

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

  1093 	$wpdb->query($query);

  1094 	die ('jQuery(\'#autosave_status\').html("<strong>Transaltion has been automatically saved at '.strftime("%H:%M on %Y/%m/%d").'</strong>");

  1095 	jQuery(\'#autosave_status\').show();');

  1096 }

  1097 

  1098 function zd_multilang_link_translations() {

  1099 	global $ZdmlCache, $locale;

  1100 	global $BaseURL, $wpdb,$default_language_option,$PluginDIR;

  1101 	$language_table= $wpdb->prefix.'zd_ml_langs';

  1102 	$termtrans_table = $wpdb->prefix.'zd_ml_termtrans';

  1103 	$linktrans=$wpdb->prefix.'zd_ml_linktrans';

  1104 	$hidden_field="zd_multilang_edit_link";

  1105 	

  1106 	echo "<h2>".__('Links','zd_multilang').'</h2>';

  1107 	$DefLang=get_option($default_language_option);

  1108 	if (isset($_POST['link_id'])) {

  1109 		$_GET['link_id']=$_POST['link_id'];

  1110 		$url=$_POST['link_url'];

  1111 		$name=$_POST['link_name'];

  1112 		$description=$_POST['link_description'];

  1113 		$Language=$_POST['lng'];

  1114 		$link_id=$_POST['link_id'];

  1115 		$check="SELECT count(*) from $linktrans where link_id=$link_id and LanguageID='$Language'";

  1116 		$res=$wpdb->get_var($check);

  1117 		if ($res) $query="UPDATE $linktrans set link_name='$name', link_url='$url', link_description='$description' WHERE link_id=$link_id and LanguageID='$Language'";

  1118 		else $query="INSERT INTO $linktrans VALUES ($link_id, '$Language', '$url', '$name', '$description')";

  1119 		$wpdb->query($query);

  1120 	}

  1121 	if (isset($_GET['link_id'])) {

  1122 		$Language=$_GET['lng'];

  1123 		$link_id=$_GET['link_id'];

  1124 		$query="SELECT l.link_id, lt.link_url, lt.link_name, lt.link_description, lt.LanguageID, l.link_url o_url, l.link_name o_name, l.link_description o_desc FROM $linktrans lt RIGHT JOIN $wpdb->links l on (l.link_id=lt.link_id) where l.link_id=$link_id";

  1125 		$results=$wpdb->get_results($query);

  1126 		$found=0;

  1127 		if ($results) {

  1128 			foreach ($results as $Link) {

  1129 				if ($Link->LanguageID==$Language) {

  1130 					$found=1;

  1131 					break;

  1132 				}

  1133 			}

  1134 			if (!$found) {

  1135 				$Link->link_name="";

  1136 				$Link->link_url="";