key,en,zh-CN,ja,ko,de,fr,es,pt-BR,ru,pl,tr,it
ui_main_play,Play,开始游戏,プレイ,시작,Spielen,Jouer,Jugar,Jogar,Играть,Graj,Oyna,Gioca
ui_main_settings,Settings,设置,設定,설정,Einstellungen,Paramètres,Ajustes,Configurações,Настройки,Ustawienia,Ayarlar,Impostazioni
ui_main_quit,Quit,退出,終了,종료,Beenden,Quitter,Salir,Sair,Выход,Wyjdź,Çık,Esci
dialog_npc_greeting_01,"Hello, {player_name}!","你好，{player_name}！","こんにちは、{player_name}！","안녕, {player_name}!","Hallo, {player_name}!","Bonjour, {player_name}!","¡Hola, {player_name}!","Olá, {player_name}!","Привет, {player_name}!","Cześć, {player_name}!","Merhaba, {player_name}!","Ciao, {player_name}!"
item_sword_name,Iron Sword,铁剑,鉄の剣,철검,Eisenschwert,Épée de fer,Espada de ferro,Espada de ferro,Железный меч,Żelazny miecz,Demir kılıç,Spada di ferro

{
  "ui": {
    "main": {
      "play": {
        "en": "Play",
        "zh-CN": "开始游戏",
        "ja": "プレイ",
        "ko": "시작"
      },
      "settings": {
        "en": "Settings",
        "zh-CN": "设置",
        "ja": "設定",
        "ko": "설정"
      }
    }
  },
  "dialog": {
    "npc": {
      "greeting_01": {
        "en": "Hello, {player_name}!",
        "zh-CN": "你好，{player_name}！"
      }
    }
  }
}

{
  "en": {
    "ui_main_play": "Play",
    "ui_main_settings": "Settings",
    "dialog_npc_greeting_01": "Hello, {player_name}!"
  },
  "zh-CN": {
    "ui_main_play": "开始游戏",
    "ui_main_settings": "设置",
    "dialog_npc_greeting_01": "你好，{player_name}！"
  }
}

using UnityEngine.Localization;
using UnityEngine.Localization.Settings;

public class LocalizationManager : MonoBehaviour
{
    public LocalizedString localizedText;
    
    void Start()
    {
        // 设置当前语言
        LocalizationSettings.SelectedLocale = LocalizationSettings.AvailableLocales.GetLocale(SystemLanguage.ChineseSimplified);
        
        // 获取翻译文本
        string text = localizedText.GetLocalizedString();
        Debug.Log(text);
    }
    
    // 带参数的文本
    public string GetGreeting(string playerName)
    {
        return LocalizationSettings.StringDatabase.GetLocalizedString("dialog", "npc_greeting_01", playerName);
    }
}

extends Node

func _ready():
    # 设置当前语言
    TranslationServer.set_locale("zh_CN")
    
    # 获取翻译文本
    var text = tr("ui_main_play")
    print(text)  # 输出: 开始游戏
    
    # 带参数的文本
    var greeting = tr("dialog_npc_greeting_01").format({"player_name": "勇者"})
    print(greeting)  # 输出: 你好，勇者！

func change_language(locale: String):
    TranslationServer.set_locale(locale)
    # 自动更新所有使用 tr() 的 UI 元素

# Godot
var text = tr("dialog_npc_greeting").format({"player_name": "勇者", "location": "村庄"})

// Unity
string text = string.Format(localizedText.GetLocalizedString(), playerName, location);

{
  "item_count": {
    "en": {
      "one": "{count} item",
      "other": "{count} items"
    },
    "ru": {
      "one": "{count} предмет",
      "few": "{count} предмета",
      "many": "{count} предметов"
    },
    "zh-CN": "{count} 个物品"
  }
}

{
  "player_class_warrior": {
    "en": "Warrior",
    "fr": {
      "male": "Guerrier",
      "female": "Guerrière"
    },
    "es": {
      "male": "Guerrero",
      "female": "Guerrera"
    }
  }
}

// Unity TextMeshPro
public TMP_FontAsset[] fontFallbackChain = new TMP_FontAsset[]
{
    mainFont,           // 拉丁字母
    cjkFont,            // 中日韩
    cyrillicFont,       // 西里尔
    arabicFont          // 阿拉伯语
};

using UnityEngine.UI;

public class AutoResizeText : MonoBehaviour
{
    public Text textComponent;
    public float minFontSize = 12f;
    public float maxFontSize = 24f;
    
    void Start()
    {
        ResizeTextToFit();
    }
    
    void ResizeTextToFit()
    {
        textComponent.resizeTextForBestFit = true;
        textComponent.resizeTextMinSize = (int)minFontSize;
        textComponent.resizeTextMaxSize = (int)maxFontSize;
    }
}

# 翻译 Brief：[游戏名称]

## 游戏概述
- 类型：[例如：2D Roguelike 动作游戏]
- 主题：[例如：中世纪奇幻、赛博朋克]
- 目标受众：[例如：18-35 岁核心玩家]
- 游戏时长：[例如：20-40 小时]

## 语言风格指南
- 语气：[例如：轻松幽默 / 严肃史诗 / 黑暗压抑]
- 称谓：[例如：使用"你"而非"您"]
- 专业术语：[例如：HP/MP 不翻译，保留英文]
- 禁止词汇：[例如：避免使用宗教敏感词汇]

## 技术限制
- 最大字符数：见 CSV 的 max_length 列
- 变量占位符：{player_name}、{count} 等，必须保留
- HTML 标签：<color=red> 等，必须保留
- 换行符：\n 必须保留

## 上下文说明
- UI 文本：简短、直接、适合按钮和标签
- 对话文本：符合角色性格，注意情感表达
- 物品描述：简洁明了，突出关键属性
- 教程文本：清晰易懂，步骤明确

## 参考材料
- 游戏截图：[链接]
- 游戏视频：[链接]
- 术语表：[链接]
- 风格指南：[链接]

## 交付要求
- 格式：CSV / JSON
- 截止日期：[日期]
- 反馈渠道：[邮箱/Discord]

using System.Globalization;

public class NumberFormatter : MonoBehaviour
{
    public string FormatNumber(float number, string locale)
    {
        CultureInfo culture = new CultureInfo(locale);
        return number.ToString("N2", culture);
    }
    
    public string FormatDate(DateTime date, string locale)
    {
        CultureInfo culture = new CultureInfo(locale);
        return date.ToString("d", culture);
    }
}

using UnityEngine;
using UnityEngine.UI;
using UnityEngine.Localization;

public class SubtitleSystem : MonoBehaviour
{
    public Text subtitleText;
    public LocalizedStringTable stringTable;
    
    private AudioSource audioSource;
    private float currentTime;
    
    void Update()
    {
        if (audioSource.isPlaying)
        {
            currentTime = audioSource.time;
            UpdateSubtitle();
        }
    }
    
    void UpdateSubtitle()
    {
        // 根据当前时间查找对应的字幕
        string subtitleKey = GetSubtitleKeyForTime(currentTime);
        if (!string.IsNullOrEmpty(subtitleKey))
        {
            subtitleText.text = stringTable.GetLocalizedString(subtitleKey);
        }
    }
    
    string GetSubtitleKeyForTime(float time)
    {
        // 从字幕时间轴数据中查找
        // 返回对应的 Key
        return "subtitle_dialog_01";
    }
    
    public void ChangeLanguage(string locale)
    {
        LocalizationSettings.SelectedLocale = LocalizationSettings.AvailableLocales.GetLocale(locale);
        UpdateSubtitle();
    }
}

#!/usr/bin/env python3
"""
本地化自动化测试脚本
检查 CSV/JSON 本地化文件的常见问题
"""

import csv
import json
import re
import sys

def check_csv_localization(file_path):
    """检查 CSV 本地化文件"""
    issues = []
    
    with open(file_path, 'r', encoding='utf-8') as f:
        reader = csv.DictReader(f)
        rows = list(reader)
    
    # 检查 1: 空翻译
    for row in rows:
        key = row['key']
        for lang in ['zh-CN', 'ja', 'ko', 'de', 'fr']:
            if lang in row and not row[lang].strip():
                issues.append(f"空翻译: {key} -> {lang}")
    
    # 检查 2: 变量占位符一致性
    for row in rows:
        key = row['key']
        en_text = row.get('en', '')
        en_vars = set(re.findall(r'\{(\w+)\}', en_text))
        
        for lang in ['zh-CN', 'ja', 'ko', 'de', 'fr']:
            if lang in row:
                lang_text = row[lang]
                lang_vars = set(re.findall(r'\{(\w+)\}', lang_text))
                
                if en_vars != lang_vars:
                    issues.append(f"变量不一致: {key} -> {lang} (期望: {en_vars}, 实际: {lang_vars})")
    
    # 检查 3: 文本长度超限
    for row in rows:
        key = row['key']
        max_length = row.get('max_length', '')
        if max_length:
            max_len = int(max_length)
            for lang in ['zh-CN', 'ja', 'ko', 'de', 'fr']:
                if lang in row:
                    lang_text = row[lang]
                    if len(lang_text) > max_len:
                        issues.append(f"文本超长: {key} -> {lang} (限制: {max_len}, 实际: {len(lang_text)})")
    
    # 检查 4: HTML 标签一致性
    for row in rows:
        key = row['key']
        en_text = row.get('en', '')
        en_tags = set(re.findall(r'<[^>]+>', en_text))
        
        for lang in ['zh-CN', 'ja', 'ko', 'de', 'fr']:
            if lang in row:
                lang_text = row[lang]
                lang_tags = set(re.findall(r'<[^>]+>', lang_text))
                
                if en_tags != lang_tags:
                    issues.append(f"标签不一致: {key} -> {lang}")
    
    return issues

def check_json_localization(file_path):
    """检查 JSON 本地化文件"""
    issues = []
    
    with open(file_path, 'r', encoding='utf-8') as f:
        data = json.load(f)
    
    # 检查 Key 一致性
    en_keys = set(data.get('en', {}).keys())
    
    for lang in ['zh-CN', 'ja', 'ko', 'de', 'fr']:
        if lang in data:
            lang_keys = set(data[lang].keys())
            
            missing = en_keys - lang_keys
            extra = lang_keys - en_keys
            
            if missing:
                issues.append(f"缺失 Key: {lang} -> {missing}")
            if extra:
                issues.append(f"多余 Key: {lang} -> {extra}")
    
    return issues

if __name__ == '__main__':
    if len(sys.argv) < 2:
        print("用法: python localization_test.py <file_path>")
        sys.exit(1)
    
    file_path = sys.argv[1]
    
    if file_path.endswith('.csv'):
        issues = check_csv_localization(file_path)
    elif file_path.endswith('.json'):
        issues = check_json_localization(file_path)
    else:
        print("不支持的文件格式")
        sys.exit(1)
    
    if issues:
        print(f"发现 {len(issues)} 个问题:")
        for issue in issues:
            print(f"  - {issue}")
        sys.exit(1)
    else:
        print("✅ 本地化文件检查通过")
        sys.exit(0)

key,en,zh-CN,ja,ko,de,fr,es,pt-BR,ru,pl,tr,it,context,max_length
ui_main_play,Play,开始游戏,플레이,Spielen,Jouer,Jugar,Jogar,Играть,Graj,Oyna,Gioca,主菜单开始按钮,15
ui_main_settings,Settings,设置,設定,설정,Einstellungen,Paramètres,Ajustes,Configurações,Настройки,Ustawienia,Ayarlar,Impostazioni,主菜单设置按钮,20
ui_main_quit,Quit,退出,終了,종료,Beenden,Quitter,Salir,Sair,Выход,Wyjdź,Çık,Esci,主菜单退出按钮,10
dialog_npc_guard_greeting_01,"Halt! Who goes there?","站住！谁在那里？","止まれ！そこにいるのは誰だ？","멈춰! 거기 누구냐?","Halt! Wer da?","Halte! Qui va là?","¡Alto! ¿Quién va ahí?","Pare! Quem está aí?","Стой! Кто идёт?","Stój! Kto tam?","Dur! Orada kim var?","Fermo! Chi va là?",守卫NPC第一次问候,50
item_weapon_iron_sword_name,Iron Sword,铁剑,鉄の剣,철검,Eisenschwert,Épée de fer,Espada de hierro,Espada de ferro,Железный меч,Żelazny mieç,Demir kılıç,Spada di ferro,铁制剑的名称,25
item_weapon_iron_sword_desc,A basic iron sword. Reliable and sturdy.,基础铁剑。可靠且坚固。,基本的な鉄の剣。信頼性と耐久性に優れる。,기본 철검. 신뢰할 수 있고 튼튼하다.,Ein einfaches Eisenschwert. Zuverlässig und robust.,Une épée de fer basique. Fiable et robuste.,Una espada de hierro básica. Fiable y resistente.,Uma espada de ferro básica. Confiável e resistente.,Базовый железный меч. Надёжный и крепki.,Podstawowy żelazny miecz. Niezawodny i solidny.,Temel bir demir kılıç. Güvenilir ve sağlam.,Una spada di ferro di base. Affidabile e robusta.,铁制剑的描述,100

{
  "en": {
    "ui_main_play": "Play",
    "ui_main_settings": "Settings",
    "ui_main_quit": "Quit",
    "dialog_npc_guard_greeting_01": "Halt! Who goes there?",
    "item_weapon_iron_sword_name": "Iron Sword",
    "item_weapon_iron_sword_desc": "A basic iron sword. Reliable and sturdy."
  },
  "zh-CN": {
    "ui_main_play": "开始游戏",
    "ui_main_settings": "设置",
    "ui_main_quit": "退出",
    "dialog_npc_guard_greeting_01": "站住！谁在那里？",
    "item_weapon_iron_sword_name": "铁剑",
    "item_weapon_iron_sword_desc": "基础铁剑。可靠且坚固。"
  },
  "ja": {
    "ui_main_play": "プレイ",
    "ui_main_settings": "設定",
    "ui_main_quit": "終了",
    "dialog_npc_guard_greeting_01": "止まれ！そこにいるのは誰だ？",
    "item_weapon_iron_sword_name": "鉄の剣",
    "item_weapon_iron_sword_desc": "基本的な鉄の剣。信頼性と耐久性に優れる。"
  }
}

import re
import json
import os

def extract_strings(file_path):
    """从 C# 文件中提取硬编码字符串"""
    with open(file_path, 'r', encoding='utf-8') as f:
        content = f.read()
    
    # 匹配字符串字面量
    pattern = r'"([^"\\]|\\.)*"'
    matches = re.findall(pattern, content)
    
    strings = []
    for match in matches:
        # 清理转义字符
        cleaned = match[1:-1].replace('\\"', '"').replace('\\n', '\n')
        strings.append(cleaned)
    
    return strings

def generate_localization_files(strings, output_dir):
    """生成本地化 JSON 文件"""
    # 生成 Key
    keys = []
    for i, s in enumerate(strings):
        # 简单的 Key 生成规则
        key = f"text_{i+1:04d}"
        keys.append(key)
    
    # 生成英文 JSON
    en_data = {}
    for key, text in zip(keys, strings):
        en_data[key] = text
    
    with open(os.path.join(output_dir, 'en.json'), 'w', encoding='utf-8') as f:
        json.dump(en_data, f, ensure_ascii=False, indent=2)
    
    return keys

# 使用示例
strings = extract_strings('Assets/Scripts/GameManager.cs')
keys = generate_localization_files(strings, 'Assets/Localization/Tables/')
print(f"提取了 {len(strings)} 个字符串")