M端WOW私服数据库汉化方法

#说明mcn库是汉化完整的库 ，mangos库是没汉化的库
#要先准备一个库是汉化完整的，然后命名为mcn



UPDATE
mcn.areatrigger_teleport a,
mangos.areatrigger_teleport b
set
b.name = a.name
WHERE
a.id = b.id;

UPDATE
mcn.creature_ai_texts a,
mangos.creature_ai_texts b
set
b.content_default = a.content_default
WHERE
a.entry = b.entry;

UPDATE
mcn.db_script_string a,
mangos.db_script_string b
set
b.content_default = a.content_default
WHERE
a.entry = b.entry;

UPDATE
mcn.gossip_menu_option a,
mangos.gossip_menu_option b
set
b.option_text = a.option_text
WHERE
a.menu_id = b.menu_id AND a.id = b.id;

UPDATE
mcn.page_text a,
mangos.page_text b
set
b.text = a.text
WHERE
a.entry = b.entry;



UPDATE
mcn.npc_option a,
mangos.npc_option b
set
b.option_text = a.option_text
WHERE
a.id = b.id;




UPDATE
mcn.quest_template a,
mangos.quest_template b
set
b.title=a.title,
b.details=a.details,
b.objectives=a.objectives,
b.offerrewardtext = a.offerrewardtext,
b.requestitemstext=a.requestitemstext,
b.endtext=a.endtext,
b.ObjectiveText1=a.ObjectiveText1,
b.ObjectiveText2=a.ObjectiveText2,
b.ObjectiveText3=a.ObjectiveText3,
b.ObjectiveText4=a.ObjectiveText4
WHERE
a.entry = b.entry;



UPDATE
mcn.creature_template a,
mangos.creature_template b
set
b.name = a.name,
b.subname = a.subname
WHERE
a.entry = b.entry;



UPDATE
mcn.gameobject_template a,
mangos.gameobject_template b
set
b.name = a.name
WHERE
a.entry = b.entry;

UPDATE
mcn.game_event a,
mangos.game_event b
set
b.description=a.description
WHERE
a.entry = b.entry;


UPDATE
mcn.item_template a,
mangos.item_template b
set
b.name = a.name,
b.description=a.description
WHERE
a.entry = b.entry;


UPDATE
mcn.npc_text a,
mangos.npc_text b
set
b.text0_0 = a.text0_0,
b.text0_1 = a.text0_1,
b.text1_0 = a.text1_0,
b.text1_1 = a.text1_1,
b.text2_0 = a.text2_0,
b.text2_1 = a.text2_1,
b.text3_0 = a.text3_0,
b.text3_1 = a.text3_1,
b.text4_0 = a.text4_0,
b.text4_1 = a.text4_1,
b.text5_0 = a.text5_0,
b.text5_1 = a.text5_1,
b.text6_0 = a.text6_0,
b.text6_1 = a.text6_1,
b.text7_0 = a.text7_0,
b.text7_1 = a.text7_1
WHERE
a.id = b.id;



UPDATE
mcn.transports a,
mangos.transports b
set
b.name = a.name
WHERE
a.entry = b.entry;

UPDATE
mcn.command a,
mangos.command b
set
b.help = a.help
WHERE
a.name = b.name;

UPDATE
mcn.game_tele a,
mangos.game_tele b
set
b.name = a.name
WHERE
a.id = b.id;

UPDATE
mcn.mangos_string a,
mangos.mangos_string b
set
b.content_default = a.content_default
WHERE
a.entry = b.entry;