VM端使用自带locales表用汉化sql

会飞的精灵

brison521 发表于 2024-1-15 20:31
我记得以前发过一个数据库命令就可以直接把汉化倒过去的，只需要执行一行数据库命令即可 ...

好像是之前有一个大佬分享过一个命令可以直接用命令的

pujiang584

语句是可以做到的。但我发现个问题，自带的汉化表，有些是不全的，头衔部分有些是空白的，所以游戏内，NPC头衔大概率仍然是英文，比如奥格瑞玛勇士大厅里，换高督装备的那些NPC

pujiang584

自带的汉化也不是很全。

pujiang584

VM自带的并不完整。任务很多还是英文。NPC喊话内容也很多是英文，NPC名字和副名也有些是英文

yxb135

汉化在哪，下载了就这一张TXT文件，内容如下：
UPDATE creature_template bt  JOIN locales_creature lbt ON bt.entry = lbt.entry  SET bt.name = lbt.name_loc4  WHERE lbt.name_loc4  <> '';
UPDATE creature_template bt  JOIN locales_creature lbt ON bt.entry = lbt.entry  SET bt.subname = lbt.subname_loc4  WHERE lbt.subname_loc4  <> '';

UPDATE item_template bt  JOIN locales_item lbt ON bt.entry = lbt.entry  SET bt.name = lbt.name_loc4  WHERE lbt.name_loc4  <> '';
UPDATE item_template bt  JOIN locales_item lbt ON bt.entry = lbt.entry  SET bt.description = lbt.description_loc4  WHERE lbt.description_loc4  <> '';

UPDATE faction bt  JOIN locales_faction lbt ON bt.id = lbt.entry  SET bt.name = lbt.name_loc4  WHERE lbt.name_loc4  <> '';
UPDATE faction bt  JOIN locales_faction lbt ON bt.id = lbt.entry  SET bt.description = lbt.description_loc4  WHERE lbt.description_loc4  <> '';

UPDATE gameobject_template bt  JOIN locales_gameobject lbt ON bt.entry = lbt.entry  SET bt.name = lbt.name_loc4  WHERE lbt.name_loc4  <> '';

UPDATE gossip_menu_option bt  JOIN locales_gossip_menu_option lbt ON bt.menu_id = lbt.menu_id AND  bt.id = lbt.id  SET bt.option_text = lbt.option_text_loc4  WHERE lbt.option_text_loc4  <> '';
UPDATE gossip_menu_option bt  JOIN locales_gossip_menu_option lbt ON bt.menu_id = lbt.menu_id AND  bt.id = lbt.id  SET bt.box_text = lbt.box_text_loc4  WHERE lbt.box_text_loc4  <> '';

UPDATE broadcast_text bt  JOIN locales_broadcast_text lbt ON bt.entry = lbt.entry  SET bt.male_text = lbt.male_text_loc4  WHERE lbt.male_text_loc4  <> '';
UPDATE broadcast_text bt  JOIN locales_broadcast_text lbt ON bt.entry = lbt.entry  SET bt.female_text = lbt.female_text_loc4  WHERE lbt.female_text_loc4 <> '';

UPDATE page_text bt  JOIN locales_page_text lbt ON bt.entry = lbt.entry  SET bt.text = lbt.Text_loc4  WHERE lbt.Text_loc4  <> '';

UPDATE points_of_interest bt  JOIN locales_points_of_interest lbt ON bt.entry = lbt.entry  SET bt.icon_name = lbt.icon_name_loc4  WHERE lbt.icon_name_loc4  <> '';

UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.Title = lbt.Title_loc4  WHERE lbt.Title_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.Details = lbt.Details_loc4  WHERE lbt.Details_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.Objectives = lbt.Objectives_loc4  WHERE lbt.Objectives_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.OfferRewardText = lbt.OfferRewardText_loc4  WHERE lbt.OfferRewardText_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.RequestItemsText = lbt.RequestItemsText_loc4  WHERE lbt.RequestItemsText_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.EndText = lbt.EndText_loc4  WHERE lbt.EndText_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.ObjectiveText1 = lbt.ObjectiveText1_loc4  WHERE lbt.ObjectiveText1_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.ObjectiveText2 = lbt.ObjectiveText2_loc4  WHERE lbt.ObjectiveText2_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.ObjectiveText3 = lbt.ObjectiveText3_loc4  WHERE lbt.ObjectiveText3_loc4  <> '';
UPDATE quest_template bt  JOIN locales_quest lbt ON bt.entry = lbt.entry  SET bt.ObjectiveText4 = lbt.ObjectiveText4_loc4  WHERE lbt.ObjectiveText4_loc4  <> '';

UPDATE spell_template bt  JOIN locales_spell lbt ON bt.entry = lbt.entry  SET bt.name = lbt.name_loc4  WHERE lbt.name_loc4  <> '';
UPDATE spell_template bt  JOIN locales_spell lbt ON bt.entry = lbt.entry  SET bt.nameSubtext = lbt.nameSubtext_loc4  WHERE lbt.nameSubtext_loc4  <> '';
UPDATE spell_template bt  JOIN locales_spell lbt ON bt.entry = lbt.entry  SET bt.description = lbt.description_loc4  WHERE lbt.description_loc4  <> '';
UPDATE spell_template bt  JOIN locales_spell lbt ON bt.entry = lbt.entry  SET bt.auraDescription = lbt.auraDescription_loc4  WHERE lbt.auraDescription_loc4  <> '';

mcvital

楼主好人！

mcvital

yxb135 发表于 2024-6-18 10:58
汉化在哪，下载了就这一张TXT文件，内容如下：
UPDATE creature_template bt  JOIN locales_creature lbt O ...

楼主已经写的很清楚了，在mangos数据库新建查询，然后复制下载的命令到里面点击运行即可！

虫狼

差点以为是VMware软件

kk6tong

谢谢分享。