diff -r 53cff4b4a802 -r bde1974c263b web/wp-content/plugins/zdmultilang/zd_multilang.php --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/wp-content/plugins/zdmultilang/zd_multilang.php Wed Feb 03 15:37:20 2010 +0000 @@ -0,0 +1,1835 @@ + $LanguageID) { + if ($LanguageID!=$ZdmlCache['DefLang']) echo ''.$LanguageID.' '; + } + } +} + +function zd_media_button() { + global $ZdmlCache, $PluginDIR; + $id=$_GET['post']; + if ($id) { + $BaseURL='admin.php?page='.plugin_basename (__FILE__); + if ($ZdmlCache['Languages']) foreach ($ZdmlCache['Languages'] as $Permalink => $LanguageID) { + if ($LanguageID!=$ZdmlCache['DefLang']) echo ''.$LanguageID.''; + } + } +} + +function zd_multilang_where_filter($filter) { + global $ZdmlCache, $locale,$display_untranslated, $wpdb, $wp_query; + + if ((get_option('show_on_front')=='page')&&(is_array($wp_query->query))&&(count($wp_query->query)<=1)&&(isset($wp_query->query['lang']))) { + $lang=$WP->query['lang']; + $filter=" AND ".$wpdb->posts.".ID = ".get_option('page_on_front'); + $wp_query->is_page=1; + $wp_query->is_home=0; + } + + if ($locale==$ZdmlCache['DefLang']) return $filter; + if (get_option($display_untranslated)=="hide") { + $filter.=" AND ".$wpdb->posts.".ID in (".$ZdmlCache['TranslatedPosts'][$locale].')'; + } + return $filter; +} + +function zd_multilang_np_where_filter($filter) { + global $ZdmlCache, $locale,$display_untranslated, $wpdb; + if ($locale==$ZdmlCache['DefLang']) return $filter; + if (get_option($display_untranslated)=="hide") { + $filter.=" AND p.ID in (".$ZdmlCache['TranslatedPosts'][$locale].')'; + } + return $filter; +} + +function zd_multilang_set_locale($WP) { + global $wp_query,$wpdb, $wp_rewrite,$default_language_option,$locale,$CurrentLanguagePermalink,$CurrentLang; + global $ZdmlCache; + + $language_table=$wpdb->prefix.'zd_ml_langs'; + $termtrans=$wpdb->prefix.'zd_ml_termtrans'; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + $linktrans=$wpdb->prefix.'zd_ml_linktrans'; + + $ZdmlCache['DefLang']=get_option("zd_multilang_defaultlanguage"); + $ZdmlCache['InsertInPosts']=get_option("zd_multilang_lang_switcher"); + $ZdmlCache['ShowLanguages']=get_option("zd_multilang_langnames"); + $ZdmlCache['ShowFlags']=get_option("zd_multilang_show_flags"); + $ZdmlCache['SwitcherPosition']=get_option('zd_multilang_position'); + $ZdmlCache['Lang_Switch_Class']=(get_option("zd_multilang_switcher_class")!="") ? get_option("zd_multilang_switcher_class") : "lang_switch"; + + $TheLocale=$ZdmlCache['DefLang']; + + if (!isset($ZdmlCache['Languages'])) { + $query="SELECT * FROM $language_table ORDER BY LanguageName"; + $results=$wpdb->get_results($query, ARRAY_A); + if ($results) { + foreach ($results as $ID => $V) { + $ZdmlCache['Languages'][$V['LangPermalink']]=$V['LanguageID']; + $ZdmlCache['LanguageNames'][$V['LangPermalink']]=$V['LanguageName']; + $ZdmlCache['Options'][$V['LanguageID']]['blogname']=$V['BlogName']; + $ZdmlCache['Options'][$V['LanguageID']]['blogdescription']=$V['BlogDescription']; + } + } + } + else { + foreach ($ZdmlCache['Languages'] as $Permalink => $LangID) { + $results[$i]['LangPermalink']=$Permalink; + $results[$i]['LanguageID']=$LangID; + $i++; + } + } + + if ($_SERVER['HTTPS']) $QUERY="https://".$_SERVER['HTTP_HOST']; + else $QUERY="http://".$_SERVER['HTTP_HOST']; + $QUERY.=$_SERVER['REQUEST_URI']; + + if ($results) { + foreach ($results as $ID => $Lang) { + $regexp.=$Lang['LangPermalink']."|"; + } + $regexp=substr($regexp, 0, -1); + } + if (strstr($QUERY,"?")) $RegularExpression="`".get_bloginfo('url')."\/.*lang=($regexp)(.*)?`U"; + else $RegularExpression="`".get_bloginfo('url')."\/($regexp)\/(.*)?`U"; + + if (preg_match($RegularExpression,$QUERY,$res)==TRUE) { + $Lang=$res[1]; + $CurrentLanguagePermalink=$res[1]; + foreach ($ZdmlCache['Languages'] as $Permalink => $LangFound) { + if ($Permalink==$Lang) { + $Language= $LangFound; + break; + } + } + $CurrentLang=$Language; + if ($Language) $TheLocale=$Language; + } + $locale=$TheLocale; + + if (!isset($ZdmlCache['Terms'])) { + $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)"; + $term=$wpdb->get_results($query, ARRAY_A); + foreach ($term as $ID => $Value) { + if ($Value['t_name']!=NULL) $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['name']=$Value['t_name']; + else $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['name']=$Value['name']; + $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['o_name']=$Value['name']; + $ZdmlCache['Terms'][$Value['term_id']][$Value['LanguageID']]['description']=$Value['description']; + } + } + + if (!isset($ZdmlCache['Links'])) { + $query="SELECT * from $linktrans"; + $links=$wpdb->get_results($query); + foreach ($links as $id => $Values) { + $ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['name']=$Values->link_name; + $ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['url']=$Values->link_url; + $ZdmlCache['Links'][$Values->link_id][$Values->LanguageID]['description']=$Values->link_description; + } + } + + if (!isset($ZdmlCache['TranslatedPosts'])) { + if ($ZdmlCache['Languages']) foreach ($ZdmlCache['Languages'] as $Permalink => $LangID) { + if ($LangID!=$ZdmlCache['DefLang']) { + $query="SELECT ID from $posttrans WHERE LanguageID='$LangID' and post_status='published'"; + $res=$wpdb->get_results($query, ARRAY_A); + if ($res) { + $ZdmlCache['TranslatedPosts'][$LangID]=""; + foreach ($res as $key => $V) { + $ZdmlCache['TranslatedPosts'][$LangID].=$V['ID'].","; + } + $ZdmlCache['TranslatedPosts'][$LangID]=substr($ZdmlCache['TranslatedPosts'][$LangID],0,-1); + } + } + } + } + + return $WP; +} + +function zd_multilang_permalink($permalink) { + global $wpdb, $wp_rewrite,$default_language_option, $CurrentLanguagePermalink,$CurrentLang,$permalink_default, $locale, $wp_query; + global $ZdmlCache; + $langstable=$wpdb->prefix.'zd_ml_langs'; + + $Lang=$CurrentLanguagePermalink; + if ($Lang=="") { + $CurrentLang=$ZdmlCache['DefLang']; + $query="SELECT LangPermalink FROM $langstable where LanguageID='$CurrentLang'"; + $CurrentLanguagePermalink=$wpdb->get_var($query); + $Lang=$CurrentLanguagePermalink; + } + $link=$permalink; + + $PermalinkDef=get_option($permalink_default); + if (($PermalinkDef=="no")&&($ZdmlCache['DefLang']==$locale)) return $link; + + if ($wp_rewrite->using_permalinks()) { + $url=get_bloginfo('url'); + $end=substr($link,strlen($url)); + if ($Lang=="") $link=$url.$end; + else $link=$url.'/'.$Lang.$end; + } else if ($Lang) $link.= ((!strpos($link,'?'))? '?': '') ."&lang=".$Lang; + + return $link; +} + +function zd_multilang_rewrite($permalink_structure) { + global $ZdmlCache; + global $wpdb, $wp_rewrite; + $langs=$wpdb->prefix.'zd_ml_langs'; + + $query="SELECT * FROM $langs order by LanguageID"; + $Lines=$wpdb->get_results($query, ARRAY_A); + if ($Lines) { + $regexp='('; + foreach ($Lines as $Value) { + $regexp.=$Value['LangPermalink'].'|'; + } + $regexp=substr($regexp,0,-1); + $regexp.=')'; + + if ($permalink_structure) foreach ($permalink_structure as $Rule => $Definition) { + $def=explode('?',$Definition); + $rule=$Definition; + if (preg_match_all('/(.*matches)\[([0-9]+)\]/U',$rule,$res)) { + $rule=""; + foreach ($res[1] as $index => $text) { + $rule.=$text.'['.($index+2).']'; + } + } + $rule.='&lang=$matches[1]'; + $new_rules[$regexp.'/'.$Rule]=$rule; + } + $new_rules2[$regexp.'/?']='index.php?lang=$matches[1]'; + if ($permalink_structure) $permalink_structure = $new_rules+ $new_rules2 + $permalink_structure; + } + return $permalink_structure; +} + +function zd_multilang_is_translated($id, $lang) { + global $ZdmlCache, $locale; + if ($lang==$ZdmlCache['DefLang']) return TRUE; + $Posts=explode(',',$ZdmlCache['TranslatedPosts'][$lang]); + foreach ($Posts as $key => $ID) { + if ($ID==$id) { + return TRUE; + } + } + return FALSE; +} + +function zd_multilang_install() { + global $ZdmlCache; + global $wpdb; + $termtrans=$wpdb->prefix.'zd_ml_termtrans'; + $langs=$wpdb->prefix.'zd_ml_langs'; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + $linktrans=$wpdb->prefix.'zd_ml_linktrans'; + $commenttrans=$wpdb->prefix.'zd_ml_comments'; + + $dbversion=get_option('zd_multilang_dbschema'); + if ($dbversion<"125") { + $sql="CREATE TABLE $langs ( + LanguageID varchar(5) NOT NULL, + LanguageName varchar(100) character set utf8 NOT NULL, + LangPermalink varchar(50) NOT NULL UNIQUE, + BlogName longtext, + BlogDescription longtext, + primary key (LanguageID) + );"; + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); + dbDelta($sql); + + $sql="CREATE TABLE $termtrans ( + term_id varchar(5) NOT NULL, + LanguageID varchar(5) NOT NULL, + name varchar(255) character set utf8 NOT NULL, + description longtext NOT NULL, + primary key (term_id,LanguageID) + );"; + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); + dbDelta($sql); + + $sql="CREATE TABLE $posttrans ( + ID BIGINT(20) NOT NULL, + LanguageID varchar(5), + post_content longtext character set utf8, + post_excerpt text character set utf8, + post_title text character set utf8 NOT NULL, + post_status varchar(10), + primary key (ID, LanguageID) + );"; + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); + dbDelta($sql); + + $sql="CREATE TABLE $linktrans ( + link_id BIGINT(20) NOT NULL, + LanguageID varchar(5), + link_url varchar(255), + link_name varchar(255) character set utf8, + link_description varchar(255) character set utf8, + primary key (link_id, LanguageID) + );"; + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); + dbDelta($sql); + + $sql="UPDATE $posttrans set post_status='published' where post_status is NULL"; + $wpdb->query($sql); + + // Comment translations only should keep track of the language where a single comment has been submitted + $sql="CREATE TABLE $commenttrans ( + comment_id BIGINT(20) UNSIGNED NOT NULL, + post_id BIGINT(20) UNSIGNED NOT NULL, + LanguageID varchar(5), + primary key (comment_id) + );"; + require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); + dbDelta($sql); + + update_option('zd_multilang_dbschema',125); + update_option('zd_multilang_access',10); + } +} + +function zd_multilang_add_pages() { + global $Allowed_Access; + $Allowed_Access_Level=get_option($Allowed_Access); + add_menu_page('Zd_MultiLang', __('Translations','zd_multilang'), $Allowed_Access_Level, __FILE__, 'zd_multilang_page'); + add_submenu_page(__FILE__,__('Posts','zd_multilang'),__('Posts','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=posts&tr=posts','zd_multilang_page'); + add_submenu_page(__FILE__,__('Pages','zd_multilang'),__('Pages','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=posts&tr=pages','zd_multilang_page'); + add_submenu_page(__FILE__,__('Categories','zd_multilang'),__('Categories','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=translations&tr=cat','zd_multilang_page'); + add_submenu_page(__FILE__,__('Tags','zd_multilang'),__('Tags','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=translations&tr=tags','zd_multilang_page'); + add_submenu_page(__FILE__,__('Links','zd_multilang'),__('Links','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=links','zd_multilang_page'); + add_submenu_page(__FILE__,__('Link Categories','zd_multilang'),__('Link Categories','zd_multilang'),$Allowed_Access_Level,__FILE__.'&fct=translations&tr=linkcat','zd_multilang_page'); + add_submenu_page(__FILE__,__('Languages','zd_multilang'),__('Languages','zd_multilang'),'manage_options',__FILE__.'&fct=languages','zd_multilang_page'); + add_submenu_page(__FILE__,__('Options','zd_multilang'),__('Options','zd_multilang'),'manage_options',__FILE__.'&fct=options','zd_multilang_page'); +} + +function zd_multilang_page() { + global $BaseURL, $current_user; + get_currentuserinfo(); + echo "\n".'
'; + if ($_POST['fct']) $_GET['fct']=$_POST['fct']; + switch ($_GET['fct']) { + case 'options': + if ($current_user->allcaps['manage_options']==1) + zd_multilang_options(); + else { + echo '

Only the administrator can edit the options

'; + zd_multilang_dashboard(); + } + break; + case 'edit': + if ($current_user->allcaps['manage_options']==1) + zd_multilang_edit_language(); + else { + echo '

Only the administrator can edit the options

'; + zd_multilang_dashboard(); + } + break; + case 'delete': + if ($current_user->allcaps['manage_options']==1) + zd_multilang_delete_language(); + else { + echo '

Only the administrator can edit the options

'; + zd_multilang_dashboard(); + } + break; + case 'posts': + zd_multilang_post_translations(); + break; + case 'translations'; + zd_multilang_term_translations(); + break; + case 'languages': + if ($current_user->allcaps['manage_options']==1) + zd_multilang_languages(); + else { + echo '

Only the administrator can edit the options

'; + zd_multilang_dashboard(); + } + break; + case 'links': + zd_multilang_link_translations(); + break; + default: + zd_multilang_dashboard(); + break; + } + echo "\n
"; +} + +function zd_multilang_dashboard() { + global $BaseURL, $current_user; + get_currentuserinfo();; + echo '

'.__('Language Dashboard','zd_multilang').'

'; + echo ''; + echo '
+ + + + +
'; +} + +function zd_multilang_options() { + global $wpdb, $BaseURL,$default_language_option,$insert_lang_switch_option,$show_flags_option,$display_google_translate; + global $show_languages_option,$lang_switcher_class_option,$permalink_default,$display_untranslated, $display_original_option,$keep_separate_comments, $Allowed_Access,$Autosave_Option; + global $ZdmlCache; + + $language_table=$wpdb->prefix.'zd_ml_langs'; + $termtrans=$wpdb->prefix.'zd_ml_termtrans'; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + $hidden_field="zd_multilang_update_options"; + $language_table= $wpdb->prefix.'zd_ml_langs'; + + echo '
+ + + + +
'; + + if ($_POST[$hidden_field]) { + $OldLang=get_option($default_language_option); + $DefLang=$_POST['def_lang']; + $DisplayOriginal=$_POST['display_original']; + $InsertInPosts=$_POST['show_language_switcher']; + $Show_Languages=$_POST['show_languages']; + $Show_Flags=$_POST['show_flags']; + $Lang_Switch_Class=$_POST['lang_switch_class']; + $SwitcherPosition=$_POST['language_switcher_position']; + $KeepSeparateComments=$_POST['keep_separate_comments']; + $PermalinkDef=$_POST['permalink_for_default']; + $Exchange=$_POST['exchange_lang']; + $DisplayUntranslated=$_POST['display_untranslated']; + $DisplayGLink=$_POST['display_glink']; + $Allowed_Access_Level=$_POST['access_level']; + $Autosave=$_POST['autosave']; + + update_option('zd_multilang_position',$SwitcherPosition); + update_option($default_language_option,$DefLang); + update_option($display_original_option, $DisplayOriginal); + update_option($insert_lang_switch_option,$InsertInPosts); + update_option($show_languages_option,$Show_Languages); + update_option($show_flags_option,$Show_Flags); + update_option($lang_switcher_class_option,$Lang_Switch_Class); + update_option($permalink_default, $PermalinkDef); + update_option($display_untranslated,$DisplayUntranslated); + update_option($display_google_translate,$DisplayGLink); + update_option($keep_separate_comments, $KeepSeparateComments); + update_option($Allowed_Access,$Allowed_Access_Level); + update_option($Autosave_Option,$Autosave); + + echo '
'; + if ($Exchange=="on") { + $query="SELECT * FROM $posttrans where LanguageID='$DefLang'"; + $TrPosts=$wpdb->get_results($query, ARRAY_A); + $query="SELECT * FROM $termtrans where LanguageID='$DefLang'"; + $TrTerms=$wpdb->get_results($query, ARRAY_A); + + if ($TrPosts) foreach ($TrPosts as $key => $V) { + $query="SELECT * from ".$wpdb->posts." WHERE ID=".$V['ID']; + $res=$wpdb->get_row($query); + $OriginalTitle=$res->post_title; + $OriginalContent=$wpdb->escape($res->post_content); + $NewContent=$wpdb->escape($V['post_content']); + $NewTitle=$V['post_title']; + $q1="UPDATE ".$wpdb->posts." set post_title='$NewTitle', post_content='$NewContent' WHERE ID=".$V['ID']; + $wpdb->query($q1); + $q1="UPDATE $posttrans set post_title='$OriginalTitle', post_content='$OriginalContent', LanguageID='$OldLang' WHERE ID=".$V['ID']." and LanguageID='$DefLang'"; + $wpdb->query($q1); + } + if ($TrTerms) foreach ($TrTerms as $key => $V) { + $query="SELECT * from ".$wpdb->terms." WHERE term_id=".$V['term_id']; + $res=$wpdb->get_row($query); + $OriginalTerm=$res->name; + $NewTerm=$V['name']; + $q1="UPDATE ".$wpdb->terms." SET name='$NewTerm' WHERE term_id=".$V['term_id']; + $wpdb->query($q1); + $q1="UPDATE $termtrans SET name='$OriginalTerm', LanguageID='$OldLang' WHERE LanguageID='$DefLang' and term_id=".$V['term_id']; + + $wpdb->query($q1); + } + echo '

'.__('Default Languages Exchanged','zd_multilang').'

'; + } + echo '

'.__('Options updated','zd_multilang').'

'; + echo '
'; + } + $query="SELECT * FROM $language_table order by LanguageName"; + $Languages=$wpdb->get_results($query, ARRAY_A); + $DefaultLanguage=get_option($default_language_option); + $InsertInPosts=get_option($insert_lang_switch_option); + $ShowLanguages=get_option($show_languages_option); + $ShowFlags=get_option($show_flags_option); + $SwitcherPosition=get_option('zd_multilang_position'); + $DisplayUntranslated=get_option($display_untranslated); + $DisplayGlink=get_option($display_google_translate); + $DisplayOriginal=get_option($display_original_option); + $Lang_Switch_Class=(get_option($lang_switcher_class_option)!="") ? get_option($lang_switcher_class_option) : "lang_switch"; + $Allowed_Access_Level=get_option($Allowed_Access); + $Autosave=get_option($Autosave_Option); + + echo ''; + + echo "\n\t

".__('General Options','zd_multilang')."

"; + echo "\n\t".'
'; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo '
".__('Level required to translate items','zd_multilang').""; + echo ''; + echo "
".__('Default Language','zd_multilang').""; + echo ''; + echo "
".__('Exchange Languages','zd_multilang')."
".__('Only use this option if you want to switch old default language with new one. This will exchange translations between them','zd_multilang')."		"; + echo ''; + echo "
".__('Display Original post while translating','zd_multilang').""; + echo ''; + echo "
".__('Automatically save translation every 5 minutes','zd_multilang').""; + echo ''; + echo "
".__('Generate permalink for Default language','zd_multilang').""; + echo ''; + echo "
".__('Keep separate comments for each language','zd_multilang').""; + echo ''; + echo "
".__('Display untranslated posts','zd_multilang').""; + echo ''; + echo "
".__('If Yes, display link "Translate Original post with Google Translate"','zd_multilang').""; + echo ''; + echo "
'; + echo '

'.__('Language Switcher','zd_multilang').'

'; + echo "\n\t".''; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; echo "\n\t\t"; + echo "\n\t".'
".__('Show Language Switcher in post','zd_multilang').""; + echo ''; + echo "
".__('Language Switcher Position','zd_multilang').""; + echo ''; + echo "
".__('Show Language names in switcher','zd_multilang').""; + echo ''; + echo "
".__('Show Flags in switcher','zd_multilang').""; + echo ''; + echo "
".__('Language Switcher CSS class','zd_multilang').""; + echo ''; + echo "
'; + echo "\n\t".'

'; + echo "\n".'
'; +} + +function zd_multilang_edit_language() { + global $wpdb, $BaseURL,$default_language_option, $BaseURL, $PluginDIR, $wp_rewrite; + global $ZdmlCache; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $hidden_field="zd_multilang_edit_language"; + + + if ($_POST[$hidden_field]) { + $Action=$_POST[$hidden_field]; + $LangCode=$_POST['lang_code']; + $LangName=$_POST['lang_name']; + $LangPermalink=$_POST['lang_permalink']; + $BlogName=$_POST['blog_name']; + $BlogDesc=$_POST['blog_description']; + echo '

'; + if ($Action=="edit") { + $query="UPDATE $language_table set LanguageName='$LangName',LangPermalink='$LangPermalink', BlogName='$BlogName', BlogDescription='$BlogDesc' WHERE LanguageID='$LangCode'"; + $wpdb->query($query); + if ($_POST['def_lang']=="on") update_option($default_language_option,$LangCode); + echo __('Language Edited','zd_multilang'); + } + echo '

'; + zd_multilang_languages(); + return; + } + $DefaultLanguage=$ZdmlCache['DefLang']; + $Code=$_GET['lang']; + $query="SELECT * FROM $language_table where LanguageID='$Code'"; + $row=$wpdb->get_row($query, ARRAY_A); + + echo "

".__('Languages','zd_multilang').'


'; + echo "

".__('Edit Language','zd_multi').' '.$_GET['lang'].'

'; + echo "\n\t".'
'; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t".'
".__('Language Name','zd_multilang').""; + echo ''; + echo "
".__('Language Permalink','zd_multilang').""; + echo ''; + echo "
".__('Blog name','zd_multilang').""; + echo ''; + echo "
".__('Blog description','zd_multilang').""; + echo ''; + echo "
".__('Default Language','zd_multilang')." ?"; + if ($row['LanguageID']==$DefaultLanguage) $selected='checked="on"'; + else $selected=""; + echo ''; + echo "
'; + echo "\n\t".'

'; + echo "\n\t
"; +} + +function zd_multilang_languages() { + global $ZdmlCache; + global $wpdb, $BaseURL,$default_language_option, $BaseURL, $PluginDIR, $wp_rewrite; + $language_table= $wpdb->prefix.'zd_ml_langs'; + + $hidden_field="zd_multilang_add_language"; + + echo "

".__('Languages','zd_multilang').'


'; + + if ($_POST[$hidden_field]) { + $Action=$_POST[$hidden_field]; + $LangCode=$_POST['lang_code']; + $LangName=$_POST['lang_name']; + $LangPermalink=$_POST['lang_permalink']; + echo '

'; + if ($Action=="add") { + $query="INSERT INTO $language_table VALUES ('$LangCode','$LangName','$LangPermalink',NULL,NULL)"; + $wpdb->query($query); + if ($_POST['def_lang']=="on") update_option($default_language_option,$LangCode); + echo __('Language Added','zd_multilang'); + } + echo '


'; + } + + $DefaultLanguage=$ZdmlCache['DefLang']; + $query="SELECT * FROM $language_table order by LanguageName"; + $Languages=$wpdb->get_results($query, ARRAY_A); + if ($Languages) { + echo ''; + echo ''; + foreach ($Languages as $Index => $Values) { + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + } + echo '
'.__('Action','zd_multilang').''.__('Language Name','zd_multilang').''.__('Language Code','zd_multilang').''.__('Permalink','zd_multilang').''.__('Default','zd_multilang').'
'.__('Edit','zd_multilang').' - '.__('Delete','zd_multilang').' '.$Values['LanguageName'].''.$Values['LanguageID'].''.$Values['LangPermalink'].' '; + if ($Values['LanguageID']==$DefaultLanguage) echo "".__('Default Language', 'zd_multilang').""; + echo '
'; + } + + echo "

".__('Add Language','zd_multilang').'

'; + echo "\n\t".'
'; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t\t"; + echo "\n\t".'
".__('Language Name','zd_multilang').""; + echo ''; + echo "
".__('Language Code','zd_multilang').""; + echo ''; + echo "
".__('Language Permalink','zd_multilang').""; + echo ''; + echo "
".__('Default Language','zd_multilang')." ?"; + echo ''; + echo "
'; + echo "\n\t".'

'; + echo "\n\t

".__('Show/Hide Available default codes','zd_multilang')."

"; + + $DefaultLanguagesCodes=array ( + 'ar' => array ('Arabian', 'ar'),'bn_BD' => array ('Bengali','bn'),'be_BY' => array ('Belarusian','be'), + 'bg_BG' => array ('Bulgarian','bg'),'ca' => array ('Catalan','ca'),'zh_CN' => array ('Chinese','cn'), + 'zh_HK' => array ('Hong Kong','hk'),'zh_TW' => array ('Taiwan','tw'),'hr' => array ('Croatian','hr'), + 'cz_CZ' => array ('Czech','cz'),'da_DK' => array ('Danish','dk'),'nl_NL' => array ('Dutch','nl'), + 'en_US' => array ('English','en'),'eu' => array ('Euskadi','eu'),'eo' => array ('Esperanto','eo'), + 'et' => array ('Estonian','et'),'fo' => array ('Faroe','fo'),'fi_FI' => array ('Finnish','fi'), + 'fr_FR' => array ('French','fr'),'gl_ES' => array ('Galician','gl'),'de_DE' => array ('German','de'), + 'el' => array ('Greek','gr'),'he_IL' => array ('Hebrew','il'),'hu_HU' => array ('Hungarian','hu'), + 'is_IS' => array ('Icelandic','is'),'id_ID' => array ('Indonesian','id'),'it_IT' => array ('Italian','it'), + 'ja' => array ('Japanese','jp'),'km_KH' => array ('Khmer','km'),'ko_KR' => array ('Korean','ko'), + 'ku' => array ('Kurdish','ku'),'lv' => array ('Latvian','lv'),'lt' => array ('Lithuanian','lt'), + 'mk_MK' => array ('Macedonian','mk'),'mg_MG' => array ('Malgasy','mg'),'ms_MY' => array ('Malay','my'), + 'nb_NO' => array ('Norwegian','no'),'pl_PL' => array ('Polish','pl'),'pt_BR' => array ('Brazilian Portuguese','br'), + 'pt_PT' => array ('European Portuguese','pt'),'ro' => array ('Romanian','ro'),'ru_RU' => array ('Russian','ru'), + 'sr_RS' => array ('Serbian','sr'),'si_LK' => array ('Sinhala','lk'),'sl_SI' => array ('Slovenian','sl'), + 'sk' => array ('Slovak','sk'),'es_ES' => array ('Spanish','es'),'sv_SE' => array ('Swedish','se'), + 'th' => array ('Thai','th'),'tr' => array ('Turkish','tr'),'ua_UA' => array ('Ukrainian','ua'), + 'uz_UZ' => array ('Uzbek','uz'),'vi_VN' => array ('Vietnamse','vn'),'cy' => array ('Welsh','cy') + ); + + echo ' +'; + + $wp_rewrite->flush_rules(); +} + +function zd_multilang_delete_language() { + global $ZdmlCache; + global $BaseURL, $wpdb,$default_language_option; + $DefaultLanguage=$ZdmlCache['DefLang']; + + $language_table= $wpdb->prefix.'zd_ml_langs';$termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $LangCode=$_GET['lang']; + $query="DELETE FROM $language_table WHERE LanguageID='$LangCode'"; + $wpdb->query($query); + $query="DELETE FROM $termtrans_table WHERE LanguageID='$LangCode'"; + $wpdb->query($query); + + echo '

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

'; + zd_multilang_languages(); +} + +function zd_multilang_post_translations() { + global $ZdmlCache; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR, $display_original_option; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + $hidden_field="zd_multilang_edit_translation"; + + $Autosave=get_option('zdmultilang_autosave'); + + echo "

".__('Posts & Pages','zd_multilang').'

'; + + $query="SELECT * FROM $language_table order by LanguageName"; + $Languages=$wpdb->get_results($query, ARRAY_A); + if (!$Languages) { + echo '

'.__('No languages defined, please define some first','zd_multilang').'

'; + return; + } + $DefaultLanguage=$ZdmlCache['DefLang']; + + if ($_POST['id']) { + list($ID, $Lang) = split("\.",$_POST['id']); + $Content=$_POST['content']; + $Title=$_POST['post_title']; + $Status=$_POST['post_status']; + $Excerpt=$_POST['post_excerpt']; + $var=$wpdb->get_var("SELECT ID from $posttrans WHERE ID='$ID' and LanguageID='$Lang'"); + if ($var==$ID) { + $query="UPDATE $posttrans set post_content='$Content', post_title='$Title', post_status='$Status', post_excerpt='$Excerpt' WHERE ID='$ID' and LanguageID='$Lang'"; + } else $query="INSERT INTO $posttrans (`ID`, `LanguageID`, `post_content`, `post_title`, `post_status`, `post_excerpt`) values ('$ID', '$Lang', '$Content', '$Title','$Status', '$Excerpt')"; + $wpdb->query($query); + echo '

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


'; + $_GET['id']=$_POST['id']; + } + if ($_GET['id']) { + list($ID, $Lang) = split('\.', $_GET['id']); + $query='SELECT * FROM '.$wpdb->prefix.'posts WHERE ID='.$ID; + $res=$wpdb->get_results($query); + $OriginalText=str_replace(array("\r","\n"),array ("",""), strip_tags($res[0]->post_content)); + $OriginalPost=$res[0]->post_content; + echo '
'; + $query="SELECT * FROM $posttrans WHERE LanguageID='$Lang' and ID=".$ID; + $res=$wpdb->get_results($query, ARRAY_A); + + if ($res[0]['post_status']==NULL) $res[0]['post_status']='draft'; + + $From=array_search($DefaultLanguage,$ZdmlCache['Languages']); + $To=array_search($Lang,$ZdmlCache['Languages']); + + echo '
'; + echo ''; + echo ''; + echo '
'; + echo '
+
+
+

+

+ +

+ +
+

+ +
+

+
+
'.__('Actions','zd_multilang').'
+ + + + + + + +
+
'; + echo '
'; + + echo '
'; + echo '
'; + echo '

'.__('Title','zd_multilang').'

'; + echo '
'; + echo '
'; + echo '
'; + echo '

'.__('Translations','zd_multilang').'

'; + echo ''; + the_editor($res[0]['post_content']); + echo '
'; + echo '

'.__('Excerpt','zd_multilang').'

+
+ +
'; + $DisplayOriginal=get_option($display_original_option); + if ($DisplayOriginal=='yes') { + $OriginalPost = apply_filters('the_content', $OriginalPost); + $OriginalPost = str_replace(']]>', ']]>', $OriginalPost); + echo '

'.__('Original post','zd_multilang').'

+
'.$OriginalPost.'
'; + } + echo '
'; + echo '
'; + if ($Autosave=='yes') { + wp_print_scripts('sack'); + echo ''; + } + echo '
+
'; + echo ''; + } else if ($_GET['tr']) { + switch ($_GET['tr']) { + case 'posts': + $query='SELECT * FROM '.$wpdb->prefix.'posts WHERE post_type="post" order by post_status, post_date desc'; + break; + case 'pages': + $query='SELECT * FROM '.$wpdb->prefix.'posts WHERE post_type="page" order by post_status, post_date desc'; + break; + default: + $query=""; + break; + } + + $q="SELECT * from $posttrans order by ID"; + $Translated=$wpdb->get_results($q, ARRAY_A); + if ($Translated) foreach ($Translated as $Idx => $Row) { + $Posts[$Row['ID']][$Row['LanguageID']]=$Row['post_status']; + } + + $results=$wpdb->get_results($query, ARRAY_A); + if ($results) { + echo ''; + echo ''; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) echo ''; + } + echo ''; + foreach ($results as $ID => $row) { + echo ''; + echo ''; + echo ''; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) { + echo ''; + } + } + echo ''; + } + echo '
'.__('Original title','zd_multilang').''.__('Published date', 'zd_multilang').''.$Lang['LanguageName'].'
'.$row['post_title'].''.date_i18n(get_option('date_format').' - '.get_option('time_format'),strtotime($row['post_date'])).''; + if ($Posts[$row['ID']][$Lang['LanguageID']]) echo ' '.__($Posts[$row['ID']][$Lang['LanguageID']],'zd_multilang'); + else echo ' '.__('Translate','zd_multilang'); + echo '
'; + } + } else { + $query="SELECT distinct(ID) from $posttrans"; + $res=$wpdb->get_results($query); + foreach ($res as $Line) { + $count++; + } + printf(__('%d posts or pages are translated','zd_multilang'),$count); + } +} + +function zd_multilang_autosave() { + global $wpdb; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + list($ID, $Lang) = split("\.",$_POST['id']); + $Content=$_POST['content']; + $Title=$_POST['post_title']; + $Status=$_POST['post_status']; + $Excerpt=$_POST['post_excerpt']; + $var=$wpdb->get_var("SELECT ID from $posttrans WHERE ID='$ID' and LanguageID='$Lang'"); + if ($var==$ID) { + $query="UPDATE $posttrans set post_content='$Content', post_title='$Title', post_status='$Status', post_excerpt='$Excerpt' WHERE ID='$ID' and LanguageID='$Lang'"; + } else $query="INSERT INTO $posttrans (`ID`, `LanguageID`, `post_content`, `post_title`, `post_status`, `post_excerpt`) values ('$ID', '$Lang', '$Content', '$Title','$Status', '$Excerpt')"; + $wpdb->query($query); + die ('jQuery(\'#autosave_status\').html("Transaltion has been automatically saved at '.strftime("%H:%M on %Y/%m/%d").'"); + jQuery(\'#autosave_status\').show();'); +} + +function zd_multilang_link_translations() { + global $ZdmlCache, $locale; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $linktrans=$wpdb->prefix.'zd_ml_linktrans'; + $hidden_field="zd_multilang_edit_link"; + + echo "

".__('Links','zd_multilang').'

'; + $DefLang=get_option($default_language_option); + if (isset($_POST['link_id'])) { + $_GET['link_id']=$_POST['link_id']; + $url=$_POST['link_url']; + $name=$_POST['link_name']; + $description=$_POST['link_description']; + $Language=$_POST['lng']; + $link_id=$_POST['link_id']; + $check="SELECT count(*) from $linktrans where link_id=$link_id and LanguageID='$Language'"; + $res=$wpdb->get_var($check); + if ($res) $query="UPDATE $linktrans set link_name='$name', link_url='$url', link_description='$description' WHERE link_id=$link_id and LanguageID='$Language'"; + else $query="INSERT INTO $linktrans VALUES ($link_id, '$Language', '$url', '$name', '$description')"; + $wpdb->query($query); + } + if (isset($_GET['link_id'])) { + $Language=$_GET['lng']; + $link_id=$_GET['link_id']; + $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"; + $results=$wpdb->get_results($query); + $found=0; + if ($results) { + foreach ($results as $Link) { + if ($Link->LanguageID==$Language) { + $found=1; + break; + } + } + if (!$found) { + $Link->link_name=""; + $Link->link_url=""; + $Link->link_description=""; + } + echo ' + + + + + + +
'.$Link->o_name.''.$Link->o_url.''.$Link->o_desc.'
'; + echo '
+ + + + + +

+
'; + } + } else { + $query="SELECT l.link_id, lt.LanguageID, lt.link_name, l.link_url o_url, l.link_name o_name FROM $linktrans lt RIGHT JOIN $wpdb->links l on (l.link_id=lt.link_id)"; + $results=$wpdb->get_results($query); + if ($results) + foreach ($results as $row) { + $Link[$row->link_id]['name_'.$row->LanguageID]=$row->link_name; + $Link[$row->link_id]['o_name']=$row->o_name; + $Link[$row->link_id]['o_url']=$row->o_url; + } + + echo ''; + echo ''; + foreach ($ZdmlCache['Languages'] as $LanguageID => $Lang) { + if ($Lang!=$DefLang) echo ''; + } + echo ''; + if ($Link) + foreach ($Link as $link_id => $L) { + echo ''; + echo ''; + foreach ($ZdmlCache['Languages'] as $LanguageID => $Lang) { + if ($Lang!=$DefLang) echo ''; + } + echo ''; + } + echo '
'.__('Original Link','zd_multilang').' '.$ZdmlCache['LanguageNames'][$LanguageID].'
'.$L['o_name'].' '.__('Translate','zd_multilang').'
'; + } +} + +function zd_multilang_term_translations() { + global $ZdmlCache; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $hidden_field="zd_multilang_edit_translation"; + + echo "

".__('Translations','zd_multilang').'

'; + $Option=$_GET['tr']; + $DefaultLanguage=$ZdmlCache['DefLang']; + + $query="SELECT * FROM $language_table order by LanguageName"; + $Languages=$wpdb->get_results($query, ARRAY_A); + if (!$Languages) { + echo '

'.__('No languages defined, please define some first','zd_multilang').'

'; + return; + } + + if ($_POST[$hidden_field]=="update") { + $termid=$_POST['term_id']; + $Option=$_POST['tr']; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) { + $LangID=$Lang['LanguageID']; + $Translation=$_POST[$termid."_".$LangID]; + $Desc=$_POST['desc_'.$termid."_".$LangID]; + $query="SELECT name FROM $termtrans_table WHERE LanguageID='$LangID' and term_id='$termid' "; + $oldvalue=$wpdb->get_var($query); + if ($oldvalue) { + $query="UPDATE $termtrans_table set name='$Translation', description='$Desc' where term_id=$termid and LanguageID='$LangID'"; + } else { + if ($Translation) $query="INSERT INTO $termtrans_table VALUES ('$termid','$LangID','$Translation', '$Desc')"; + } + $wpdb->query($query); + $_GET['id']=$termid; + } + } + } + + if ($_GET['id']) { + $term_id=$_GET['id']; + $query="SELECT t.name, tt.term_id, tt.description FROM ".$wpdb->prefix."term_taxonomy tt, ".$wpdb->prefix."terms t WHERE t.term_id=tt.term_id and t.term_id=".$term_id." order by name"; + $res=$wpdb->get_row($query, ARRAY_A); + + $query="SELECT * FROM $termtrans_table WHERE term_id=$term_id"; + $Trans=$wpdb->get_results($query, ARRAY_A); + if ($Trans) foreach ($Trans as $Values) { + $Translations[$Values['LanguageID']]['term']=$Values['name']; + $Translations[$Values['LanguageID']]['desc']=$Values['description']; + } + + echo '
'; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + echo "\n\t".''; + + echo "\n\t".''; + echo ''; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) { + echo ''; + echo ''; + echo ''; + echo ''; + echo ''; + } + } + echo '
'.__('Original Term','zd_multilang').''.$res['name'].''.$res['description'].'
'.$Lang['LanguageName'].'
'; + echo "\n\t".'

'; + echo "
"; + } else { + switch ($Option) { + default: + $Option="cat"; + case 'cat': + $query="SELECT t.name, tt.term_id FROM ".$wpdb->prefix."term_taxonomy tt, ".$wpdb->prefix."terms t WHERE t.term_id=tt.term_id and taxonomy='category' order by name"; + $Results=$wpdb->get_results($query, ARRAY_A); + break; + case 'tags': + $query="SELECT t.name, tt.term_id FROM ".$wpdb->prefix."term_taxonomy tt, ".$wpdb->prefix."terms t WHERE t.term_id=tt.term_id and taxonomy='post_tag' order by name"; + $Results=$wpdb->get_results($query, ARRAY_A); + break; + case 'linkcat': + $query="SELECT t.name, tt.term_id FROM ".$wpdb->prefix."term_taxonomy tt, ".$wpdb->prefix."terms t WHERE t.term_id=tt.term_id and taxonomy='link_category' order by name"; + $Results=$wpdb->get_results($query, ARRAY_A); + break; + } + if ($Results) { + foreach ($Results as $Line) { + $in.=$Line['term_id'].","; + } + $in=substr($in, 0, -1); + $query="SELECT * FROM $termtrans_table WHERE term_id in ($in)"; + $Trans=$wpdb->get_results($query, ARRAY_A); + if ($Trans) foreach ($Trans as $Values) { + $Translations[$Values["term_id"]][$Values['LanguageID']]=$Values['name']; + } + echo ''; + echo ''; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) echo ''; + } + echo ''; + foreach ($Results as $Id => $Value) { + $term_id=$Value['term_id']; + echo ''; + foreach ($Languages as $Lang) { + if ($Lang['LanguageID']!=$DefaultLanguage) echo ''; + } + echo ''; + } + echo '
 '.__('Original Term','zd_multilang').' '.$Lang['LanguageName'].'
'.$Value['name'].''.$Translations[$term_id][$Lang['LanguageID']].'
'; + } + } +} + +function zd_multilang_translate_term($args="", $taxonomy="") { + global $ZdmlCache, $locale; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR,$CurrentLanguagePermalink,$CurrentLang; + + if ($ZdmlCache['DefLang']==$locale) return $args; + + if ($ZdmlCache['Terms']) { + if ($ZdmlCache['Terms'][$args->term_id][$locale]) { + $args->cat_name=$ZdmlCache['Terms'][$args->term_id][$locale]['name']; + $args->name=$ZdmlCache['Terms'][$args->term_id][$locale]['name']; + $args->description=$ZdmlCache['Terms'][$args->term_id][$locale]['description']; + } + } + return $args; +} + +function zd_multilang_translate_link_cat($terms="") { + global $ZdmlCache, $locale; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR,$CurrentLanguagePermalink,$CurrentLang; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $DefaultLanguage=$ZdmlCache['DefLang']; + + if ($ZdmlCache['DefLang']==$locale) return $terms; + + $termes=explode("\n",$terms); + $term_list=""; + foreach ($termes as $ID => $term) { + preg_match_all("|(.*)(.*)(.*)|i", $term,$res); + $t=""; + foreach ($ZdmlCache['Terms'] as $termid => $Values) { + foreach ($Values as $LangID => $V) { + if (($t=="")&&($LangID==$locale)&&($V['o_name']==$res[2][0])) { + $t=$V['name']; + } + } + } + if ($t=="") $term_list.=$res[0][0]."\n"; + else $term_list.=$res[1][0].$t.$res[3][0]."\n"; + echo $res[3][0]; + } + return $term_list."\n"; +} + +function zd_multilang_postlink($arg) { + global $locale, $ZdmlCache, $wpdb; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + + preg_match_all("|(.*)(.*)(.*)|ms",$arg,$res); + $postname=$res[2][0]; + + $query="SELECT pt.post_title FROM $posttrans pt, $wpdb->posts p WHERE pt.ID=p.ID and LanguageID='".$locale."' AND p.post_title='$postname' and pt.post_status='published'"; + $title=$wpdb->get_var($query); + $link=$res[1][0]; + if ($title) return $link.$title.$res[3][0]; + return $arg; +} + +function zd_multilang_translate_cat($term="") { + global $ZdmlCache, $locale; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR,$CurrentLanguagePermalink,$CurrentLang; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $DefaultLanguage=$ZdmlCache['DefLang']; + + if ($ZdmlCache['DefLang']==$locale) return $term; + + if ($ZdmlCache['Terms']) { + foreach ($ZdmlCache['Terms'] as $TermID => $V) { + foreach ($ZdmlCache['Terms'][$TermID] as $Language => $V) { + if (($Language==$locale)&&($V['o_name']==$term)) { + return $V['name']; + } + } + } + } + return $term; +} + +function zd_multilang_cat($arg) { + global $ZdmlCache, $locale; + $termid=$arg->term_id; + + if (isset($ZdmlCache['Terms'][$termid][$locale])) { + $arg->name=$ZdmlCache['Terms'][$termid][$locale]['name']; + $arg->description=$ZdmlCache['Terms'][$termid][$locale]['description']; + $arg->category_description=$ZdmlCache['Terms'][$termid][$locale]['description']; + } + return $arg; +} + +function zd_multilang_cat_desc($arg, $arg2) { + if (is_object($arg2)) { + $cat=zd_multilang_cat($arg2); + return $cat->description; + } + return $arg; +} + +function zd_multilang_translate_bookmarks($links) { + global $ZdmlCache, $locale; + if (!is_admin()) { + foreach ($links as $Idx => $Datas) { + $termid=$Datas->term_taxonomy_id; + $linkid=$Datas->link_id; + if ($ZdmlCache['Terms'][$termid][$locale]['description']) $links[$Idx]->description=$ZdmlCache['Terms'][$termid][$locale]['description']; + if ($ZdmlCache['Links'][$linkid][$locale]['description']) $links[$Idx]->link_description=$ZdmlCache['Links'][$linkid][$locale]['description']; + if ($ZdmlCache['Links'][$linkid][$locale]['name']) $links[$Idx]->link_name=$ZdmlCache['Links'][$linkid][$locale]['name']; + if ($ZdmlCache['Links'][$linkid][$locale]['url']) $links[$Idx]->link_url=$ZdmlCache['Links'][$linkid][$locale]['url']; + } + } + return $links; +} + +function zd_multilang_translate_list_bookmarks($bm) { + global $ZdmlCache, $locale; + $bookmarks=explode("\n",$bm); + $bm_return=array(); + foreach ($bookmarks as $line) { + if (preg_match_all('|()(.*)()|U',$line,$res)) { + $bm_return[]=$res[1][0].zd_multilang_translate_cat($res[2][0]).$res[3][0]; + } else { + $bm_return[]=$line; + } + } + return implode("\n",$bm_return); +} + +function zd_multilang_translate_post($posts) { + global $ZdmlCache; + global $BaseURL, $wpdb,$default_language_option, $wp_query, $wp_rewrite,$insert_lang_switch_option,$CurrentLanguagePermalink,$CurrentLang; + global $locale, $display_google_translate; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + $posttrans=$wpdb->prefix.'zd_ml_trans'; + + $Lang = $CurrentLanguagePermalink; + if ($Lang=="") $Language=$ZdmlCache['DefLang']; + $Language=$CurrentLang; + + if ($ZdmlCache['DefLang']!=$CurrentLang) { + foreach ($posts as $Idc => $Post) { + $post_list.=$Post->ID.','; + } + $post_list=substr($post_list,0, -1); + $query="SELECT post_content, post_title, ID, post_excerpt FROM $posttrans WHERE LanguageID='".$Language."' AND ID in (".$post_list.") AND post_status='published'"; + $rows=$wpdb->get_results($query, ARRAY_A); + if ($rows) foreach ($rows as $Id => $P) { + $row[$P['ID']]->post_content=$P['post_content']; + $row[$P['ID']]->post_title=$P['post_title']; + $row[$P['ID']]->post_excerpt=$P['post_excerpt']; + } + } + + foreach ($posts as $Idx => $Post) { + $postid=$Post->ID; + if ($row[$Post->ID]) { + $posts[$Idx]->post_content=$row[$Post->ID]->post_content; + $posts[$Idx]->post_excerpt=$row[$Post->ID]->post_excerpt; + if ($ZdmlCache['SwitcherPosition']=="footer") $posts[$Idx]->post_content.=zd_multilang_lang_switcher($posts[$Idx]->ID); + else $posts[$Idx]->post_content=zd_multilang_lang_switcher($posts[$Idx]->ID).$posts[$Idx]->post_content; + $posts[$Idx]->post_title=$row[$Post->ID]->post_title; + } else { + if ((!zd_multilang_is_translated($postid,$Language))&&($ZdmlCache['DefLang']!=$locale)&&(get_option($display_google_translate)=="show")) { + $posts[$Idx]->post_content="

".__('Translate original post with Google Translate',"zd_multilang").'

' + .$posts[$Idx]->post_content; + } + if ($ZdmlCache['SwitcherPosition']=="footer") $posts[$Idx]->post_content.=zd_multilang_lang_switcher($posts[$Idx]->ID); + else $posts[$Idx]->post_content=zd_multilang_lang_switcher($posts[$Idx]->ID).$posts[$Idx]->post_content; + } + // always get the appropriate number of comments (otherwise it won't work with default language) + $comment_count = zd_multilang_get_comment_count ($Post->ID, $Post); + if ($comment_count !== false) + $posts[$Idx]->comment_count = $comment_count; + } + return $posts; +} + +function zd_multilang_translate_tags($Tags) { + global $ZdmlCache; + global $BaseURL, $wpdb,$default_language_option,$PluginDIR,$CurrentLanguagePermalink,$CurrentLang; + $language_table= $wpdb->prefix.'zd_ml_langs'; + $termtrans_table = $wpdb->prefix.'zd_ml_termtrans'; + + $Lang = $CurrentLanguagePermalink; + if ($Lang=="") $Language=$ZdmlCache['DefLang']; + $Language=$CurrentLang; + + if ($ZdmlCache['DefLang']==$CurrentLang) return $Tags; + + foreach ($Tags as $ID => $args) { + if ($ZdmlCache['Terms']) { + foreach ($ZdmlCache['Terms'] as $TermID => $V) { + if (($TermID==$args->term_id) and ($V['LanguageID']==$Language)) + $Tags[$ID]->name=$V['name']; + } + } + } + return $Tags; +} + +function zd_multilang_lang_switcher($post_id) { + global $ZdmlCache; + global $wpdb,$wp_rewrite,$display_untranslated; + global $insert_lang_switch_option,$insert_lang_switch_option,$show_flags_option,$show_languages_option,$lang_switcher_class_option,$permalink_default, $locale; + + if (get_option($insert_lang_switch_option)=="show") { + $PluginDIR = get_bloginfo('wpurl').'/'.PLUGINDIR . '/' . dirname(plugin_basename (__FILE__)); + $language_table= $wpdb->prefix.'zd_ml_langs'; + + $langswitch_class=get_option($lang_switcher_class_option); + if ($langswitch_class) $class=' class="'.$langswitch_class.'"'; + $retour=""; + + if (!isset($ZdmlCache['Languages'])) { + $query="SELECT * FROM $language_table ORDER BY LanguageName"; + $results=$wpdb->get_results($query, ARRAY_A); + if ($results) { + foreach ($results as $ID => $V) + $ZdmlCache['Languages'][$V['LangPermalink']]=$V['LanguageID']; + } + } + else { + foreach ($ZdmlCache['Languages'] as $Permalink => $LangID) { + $results[$i]['LangPermalink']=$Permalink; + $results[$i]['LanguageID']=$LangID; + $i++; + } + } + if ($results) { + foreach ($results as $ID => $Lang) { + $regexp.=$Lang['LangPermalink']."|"; + } + $regexp=substr($regexp, 0, -1); + } + $QUERY=get_permalink($post_id); + if ($results) foreach ($results as $ID => $row) { + if (get_option($permalink_default)=="no") { + $regexp=""; + if ($results) { + foreach ($results as $ID => $Lang) { + if ($Lang['LanguageID']!=$ZdmlCache['DefLang']) $regexp.=$Lang['LangPermalink']."|"; + } + $regexp=substr($regexp, 0, -1); + } + if ($wp_rewrite->using_permalinks()) { + if ($ZdmlCache['DefLang']==$row['LanguageID']) $QUERY=preg_replace("`".get_bloginfo('url')."\/($regexp)\/(.*)`U",get_bloginfo('url')."/${3}",$QUERY); + else { + if ($locale==$ZdmlCache['DefLang']) { + $QUERY=preg_replace("`".get_bloginfo('url')."\/(.*)`U",get_bloginfo('url').'/'.$row['LangPermalink']."/${2}",$QUERY); + } else $QUERY=preg_replace("`".get_bloginfo('url')."\/($regexp)\/(.*)`U",get_bloginfo('url').'/'.$row['LangPermalink']."/${3}",$QUERY); + } + } else { + if ($ZdmlCache['DefLang']==$row['LanguageID']) $QUERY=preg_replace("`(".get_bloginfo('url')."\/.*)&lang=($regexp)(.*)`U",'${1}'."${3}",$QUERY); + else { + if ($locale==$ZdmlCache['DefLang']) { + $QUERY=preg_replace("`(".get_bloginfo('url')."\/.*)$`U",'${1}&lang='.$row['LangPermalink'],$QUERY); + } else $QUERY=preg_replace("`(".get_bloginfo('url')."\/.*lang=)($regexp)(.*)`U",'${1}'.$row['LangPermalink']."${3}",$QUERY); + } + } + } else { + if ($wp_rewrite->using_permalinks()) { + if ($QUERY!=get_bloginfo('url').'/') $QUERY=preg_replace("`".get_bloginfo('url')."\/($regexp)\/(.*)`U",get_bloginfo('url').'/'.$row['LangPermalink']."/${3}",$QUERY); + else $QUERY.=$row['LangPermalink'].'/'; + } else { + $QUERY=preg_replace("`(".get_bloginfo('url')."\/.*lang=)($regexp)(.*)`U",'${1}'.$row['LangPermalink']."${3}",$QUERY); + } + } + if ((zd_multilang_is_translated($post_id,$row['LanguageID']))&&($locale!=$row['LanguageID'])) { + $retour.=""; + $retour.=''; + if (get_option($show_flags_option)=="show") $retour.=''.$ZdmlCache['LanguageNames'][$row['LangPermalink']].''; + if (get_option($show_languages_option)=="show") $retour.=$ZdmlCache['LanguageNames'][$row['LangPermalink']]; + $retour.=''; + $retour.=''; + } + } + $retour.=''; + return $retour; + } + return ""; +} + +/******** Short Circuit Options ********/ +function zd_multilang_blogname($value) { + $v=zd_multilang_option("blogname"); + if ($v) return $v; + return $value; +} +function zd_multilang_blogdescription($value) { + $v=zd_multilang_option("blogdescription"); + if ($v) return $v; + return $value; +} + +function zd_multilang_option($optionname) { + global $locale, $ZdmlCache; + return $ZdmlCache['Options'][$locale][$optionname]; +} + + +/******* Widgets *******/ + +function zd_multilang_menu($show_name=true, $show_flags=true) { + global $wpdb,$wp_rewrite,$locale; // ... MG - Oct. 27, 2008 - need locale for check below ... + $PluginDIR = get_bloginfo('wpurl').'/'.PLUGINDIR . '/' . dirname(plugin_basename (__FILE__)); + $language_table= $wpdb->prefix.'zd_ml_langs'; + + $query="SELECT * FROM $language_table ORDER BY LanguageName"; + $results=$wpdb->get_results($query, ARRAY_A); + + if ($results) { + foreach ($results as $ID => $Lang) { + $regexp.=$Lang['LangPermalink']."|"; + } + $regexp=substr($regexp, 0, -1); + } + $retour=""; + if ($results) foreach ($results as $ID => $row) { + if ($wp_rewrite->using_permalinks()) { // ... MG - Oct. 27, 2008 - not on the home page when switching language - deal with it ... + if ( is_front_page() && !is_paged() ) $QUERY=get_bloginfo('url').'/'.$row['LangPermalink'].'/'; + else $QUERY=str_replace('/'.substr($locale,0,2).'/', '/'.$row['LangPermalink'].'/', $_SERVER['REQUEST_URI']); + } else { + if ( is_front_page() && !is_paged() ) $QUERY=get_bloginfo('url').'/?lang='.$row['LangPermalink']; + else $QUERY=str_replace('lang='.substr($locale,0,2), 'lang='.$row['LangPermalink'], $_SERVER['REQUEST_URI']); + } + if ( $locale != $row['LanguageID'] ) {// ... MG - Oct. 27, 2008 - no need to display the flag for active language ... + $retour.='
  • '; + if ($show_flags) $retour.=''; + if ($show_name) $retour.=' '.$row['LanguageName']; + $retour.='
    • '; + } + } + return $retour; +} + +function zd_multilang_widget($args) { + global $ZdmlCache; + global $wpdb,$wp_rewrite; + global $insert_lang_switch_option,$insert_lang_switch_option,$show_flags_option,$show_languages_option,$lang_switcher_class_option,$permalink_default, $locale; + $PluginDIR = get_bloginfo('wpurl').'/'.PLUGINDIR . '/' . dirname(plugin_basename (__FILE__)); + $language_table= $wpdb->prefix.'zd_ml_langs'; + + extract($args); + $WidgetTitle=get_option('zdml_widget_title'); + $WidgetOptions=get_option('zdml_widget_options'); + if (!$WidgetTitle) echo $before_widget.$before_title.__('Language','zd_multilang').$after_title; + else echo $before_widget.$before_title.$WidgetTitle.$after_title; + + echo '
      '; + echo zd_multilang_menu($WidgetOptions,get_option('zdml_widget_options_flag')); + echo '
    '; + + echo $after_widget; +} + +function zd_multilang_widget_options() { + global $ZdmlCache; + global $wpdb; + if ((isset($_POST['zdml_widget_title']))||(isset($_POST['zdml_sname']))) { + update_option('zdml_widget_title',$_POST['zdml_widget_title']); + $Options=($_POST['zdml_sname']=='on') ? '1' : '0'; + update_option('zdml_widget_options',$Options); + $Options=($_POST['zdml_sflag']=='on') ? '1' : '0'; + update_option('zdml_widget_options_flag',$Options); + } + $WidgetTitle=get_option('zdml_widget_title'); + $WidgetOptions=(get_option('zdml_widget_options')==1)? 'checked="checked"': ''; + $WidgetFlagOptions=(get_option('zdml_widget_options_flag')==1)? 'checked="checked"': ''; + echo '

    '; + echo '

    '; + echo '

    '; +} + + +/** comments */ +/** Author of this section Pau Sanchez **/ + + /** + * When a new comment is created, we should add it to the database, no matter if it has been approved or not + */ + function zd_multilang_insert_comment ($comment_id, $comment) { + global $locale, $wpdb; + $commenttrans=$wpdb->prefix.'zd_ml_comments'; + + // escape comment pulled from DB + $post_id = $comment->comment_post_ID; + + $wpdb->query( $wpdb->prepare("INSERT INTO $commenttrans (comment_id, post_id, LanguageID) VALUES (%d, %d, %s)", $comment_id, $post_id, $locale) ); + return true; + } + + /** + * When the post is deleted, we should delete it from the database + */ + function zd_multilang_delete_comment ($comment_id) { + global $locale, $wpdb; + $commenttrans=$wpdb->prefix.'zd_ml_comments'; + $wpdb->query( $wpdb->prepare("DELETE FROM $commenttrans WHERE comment_ID = %d LIMIT 1", $comment_id) ); + return true; + } + + /** + * Filter comments for the wp-content themes only (for the current language), not for the admin + */ + function zd_multilang_comments_array ($comments, $post_id) + { + global $locale, $wpdb, $keep_separate_comments; + + if (empty ($comments) || !is_array ($comments) || (get_option($keep_separate_comments) != 'yes')) + return $comments; + + $commenttrans=$wpdb->prefix.'zd_ml_comments'; + + // get ALL comments for current post, no matter the language + // this is to allow compability with old posts before installing the plugin + $query=$wpdb->prepare ("SELECT * FROM $commenttrans WHERE post_id = %d", $post_id); + $results=$wpdb->get_results($query, ARRAY_A); + + // no i18n comments? + if ($results === NULL) + return $comments; + + // create a map of comment IDs written in current language + // and another list of comments written in any other language (it will make sense later) + $commentsInLocale = array(); + $commentsNotInLocale = array(); + foreach ($results as $row) { + if (strcasecmp ($row['LanguageID'], $locale) == 0) + $commentsInLocale[] = $row ['comment_id']; + else + $commentsNotInLocale[] = $row ['comment_id']; + } + + // now generate the new list of commets (please note that comments is an array of objects) + $oldComments = $comments; + $comments = array (); + + foreach ($oldComments as $comment) + { + // if the comment is written in the current $locale OR we have no information + // about which language was used (not in our table), display comment + if ( + in_array ($comment->comment_ID, $commentsInLocale) || + !in_array ($comment->comment_ID, $commentsNotInLocale) // this makes the plugin compatible with old comments + ) + { + $comments [] = $comment; + } + } + + // intersect posts in current language with comments provided + return $comments; + } + + /** + * This is an internal function, be careful to avoid calling this function if it's not needed + * Returns the number of comments in current locale or FALSE if it could not retrieve the number of comments + * (only when keep_separate_comments = false and no $Post is passed) + */ + function zd_multilang_get_comment_count ($post_id, $Post = NULL) + { + global $locale, $wpdb, $keep_separate_comments; + + // do not keep separate comments + if (get_option($keep_separate_comments) != 'yes') { + if ($Post !== NULL) { + return $Post->comment_count; + } + + // in theory this should never happen + return false; + } + + $commenttrans = $wpdb->prefix.'zd_ml_comments'; + + // check if it's the admin interface => in the admin interface show the actual number of comments (no matter the language) + $isAdminInterface = (strpos ($_SERVER['PHP_SELF'], '/wp-admin/') !== false); + if ($isAdminInterface) { + if ($Post === NULL) { + $Post = get_post ($post_id); + if ($Post === NULL) + return 0; + } + return $Post->comment_count; + } + + // this is a bit tricky, it could be optimized, but will be clearer if left seprate + $comment_count = 0; + + // 1st sum all comments in current language + $query=$wpdb->prepare ("SELECT COUNT(*) AS total FROM $commenttrans WHERE post_id = %d AND LanguageID = %s", $post_id, $locale); + $results=$wpdb->get_results($query, ARRAY_A); + if ($results !== NULL) + $comment_count += $results[0]['total']; + + // 2nd sum all comments that are not available in any language + $query=$wpdb->prepare ( + "SELECT COUNT(*) AS total FROM wp_comments AS c1 WHERE (comment_post_ID = %d) AND NOT EXISTS (SELECT * FROM wp_zd_ml_comments AS c2 WHERE c1.comment_ID = c2.comment_id)", + $post_id + ); + $results=$wpdb->get_results($query, ARRAY_A); + if ($results !== NULL) + $comment_count += $results[0]['total']; + + return $comment_count; + } + + // filter that returns the appropriate number of comments (themes usually use comments_number function) + function zd_multilang_get_comments_number($count) + { + global $id; + $comment_count = zd_multilang_get_comment_count($id); + return ($comment_count === false ? $count : $comment_count); + } + + /** misc */ + + // function to return the current locale (to avoid using global variables) + function zd_multilang_get_locale () { + global $locale; + return $locale; + } + +function zd_multilang_initwidget() { + global $ZdmlCache; + if ( !function_exists('register_sidebar_widget') || !function_exists('register_widget_control') ) + return; + register_sidebar_widget(array('Zd Multilang','widgets'),'zd_multilang_widget'); + register_widget_control(array('Zd Multilang', 'widgets'), 'zd_multilang_widget_options'); +} +add_action('widgets_init', 'zd_multilang_initwidget'); + +?>