MangosTwo_Localised/3_InitialSaveEnglish.sql at master · ddzzhen/MangosTwo_Localised · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
-- 1/13
UPDATE `locales_creature`
INNER JOIN `creature_template` ON `locales_creature`.`entry` = creature_template.`Entry`
SET `locales_creature`.`name_loc0` = creature_template.`Name`,`locales_creature`.`subname_loc0` = COALESCE(creature_template.`subName`,'');

-- 2/13
UPDATE `creature_ai_texts`
SET `content_loc0` = `content_default`;

-- 3/13
UPDATE `db_script_string`
SET `content_loc0` = `content_default`;

-- 4/13
UPDATE `locales_gameobject`
INNER JOIN `gameobject_template` ON `locales_gameobject`.`entry` = gameobject_template.`Entry`
SET `locales_gameobject`.`name_loc0` = gameobject_template.`Name`;

-- 5/13
UPDATE `gossip_texts`
SET `content_loc0` = `content_default`;

-- 6/13
UPDATE `locales_gossip_menu_option`
INNER JOIN `gossip_menu_option` ON `locales_gossip_menu_option`.`menu_id` = gossip_menu_option.`menu_id` AND `locales_gossip_menu_option`.`id` = gossip_menu_option.`id`
SET `locales_gossip_menu_option`.`option_text_loc0` = gossip_menu_option.`option_text`,`locales_gossip_menu_option`.`box_text_loc0` = gossip_menu_option.`box_text`;

-- 7/13
UPDATE `locales_item`
INNER JOIN `item_template` ON `locales_item`.`entry` = item_template.`Entry`
SET `locales_item`.`name_loc0` = item_template.`Name`,`locales_item`.`description_loc0` = COALESCE(item_template.`description`,'');

-- 8/13
UPDATE `mangos_string`
SET `content_loc0` = `content_default`;

-- 9/13
UPDATE `locales_page_text`
INNER JOIN `page_text` ON `locales_page_text`.`entry` = page_text.`entry`
SET `locales_page_text`.`Text_loc0` = page_text.`Text`;

-- 10/13
UPDATE `locales_points_of_interest`
INNER JOIN `points_of_interest` ON `locales_points_of_interest`.`entry` = points_of_interest.`entry`
SET `locales_points_of_interest`.`icon_name_loc0` = points_of_interest.`icon_name`;

-- 11/13
UPDATE `locales_quest`
INNER JOIN `quest_template` ON `locales_quest`.`entry` = quest_template.`entry`
SET `locales_quest`.`Title_loc0` = quest_template.`Title`,
    `locales_quest`.`Details_loc0` = quest_template.`Details`,
    `locales_quest`.`Objectives_loc0` = quest_template.`Objectives`,
    `locales_quest`.`OfferRewardText_loc0` = quest_template.`OfferRewardText`,
    `locales_quest`.`RequestItemsText_loc0` = quest_template.`RequestItemsText`,
    `locales_quest`.`EndText_loc0` = quest_template.`EndText`,
    `locales_quest`.`ObjectiveText1_loc0` = quest_template.`ObjectiveText1`,
    `locales_quest`.`ObjectiveText2_loc0` = quest_template.`ObjectiveText2`,
    `locales_quest`.`ObjectiveText3_loc0` = quest_template.`ObjectiveText3`,
    `locales_quest`.`ObjectiveText4_loc0` = quest_template.`ObjectiveText4`;

-- 12/13
UPDATE `script_texts`
SET `content_loc0` = `content_default`;

-- 13/13
UPDATE `locales_npc_text`
INNER JOIN `npc_text` ON `locales_npc_text`.`entry` = npc_text.`id`
SET `locales_npc_text`.`Text0_0_loc0` = npc_text.`Text0_0`,
    `locales_npc_text`.`Text0_1_loc0` = npc_text.`Text0_1`,
    `locales_npc_text`.`Text1_0_loc0` = npc_text.`Text1_0`,
    `locales_npc_text`.`Text1_1_loc0` = npc_text.`Text1_1`,
    `locales_npc_text`.`Text2_0_loc0` = npc_text.`Text2_0`,
    `locales_npc_text`.`Text2_1_loc0` = npc_text.`Text2_1`,
    `locales_npc_text`.`Text3_0_loc0` = npc_text.`Text3_0`,
    `locales_npc_text`.`Text3_1_loc0` = npc_text.`Text3_1`,
    `locales_npc_text`.`Text4_0_loc0` = npc_text.`Text4_0`,
    `locales_npc_text`.`Text4_1_loc0` = npc_text.`Text4_1`,
    `locales_npc_text`.`Text5_0_loc0` = npc_text.`Text5_0`,
    `locales_npc_text`.`Text5_1_loc0` = npc_text.`Text5_1`,
    `locales_npc_text`.`Text6_0_loc0` = npc_text.`Text6_0`,
    `locales_npc_text`.`Text6_1_loc0` = npc_text.`Text6_1`,
    `locales_npc_text`.`Text7_0_loc0` = npc_text.`Text7_0`,
    `locales_npc_text`.`Text7_1_loc0` = npc_text.`Text7_1`;