A_replace_BaseEnglish_with_Italian.sql

-- TODO: NEED TO LOAD ACHIEVEMENT LOCALE DATA

-- ----------------------------------------------------------------------------------------------------------------
-- WARNING: Running this script will replace the English text in the base World Database with the localised version
-- ----------------------------------------------------------------------------------------------------------------

-- -----------------------------------------------------------------------------------------------------------------------
-- ATTENZIONE: Eseguire questo script sostituirà il testo Inglese nel Database World originale con la versione localizzata
-- -----------------------------------------------------------------------------------------------------------------------
-- 1/14
-- Update Creature_Template
UPDATE `creature_template`
INNER JOIN `locales_creature` ON `creature_template`.`entry` = `locales_creature`.`Entry`
SET creature_template.`Name`=`locales_creature`.`name_loc11` WHERE `locales_creature`.`name_loc11` <>'';

-- Update Creature_Template
UPDATE `creature_template`
INNER JOIN `locales_creature` ON `creature_template`.`entry` = `locales_creature`.`Entry`
SET creature_template.`subName`=`locales_creature`.`subname_loc11`
WHERE `locales_creature`.`subname_loc11` <>'';

-- 2/14
UPDATE `creature_ai_texts`
SET `content_default` = COALESCE(`content_loc11`,`content_default`);

-- 3/14
UPDATE `db_script_string`
SET `content_default` = COALESCE(`content_loc11`,`content_default`) ;

-- 4/14
-- Update GameObject_Template
UPDATE `gameobject_template`
INNER JOIN `locales_gameobject` ON `gameobject_template`.`entry` = `locales_gameobject`.`Entry`
SET gameobject_template.`Name` = `locales_gameobject`.`name_loc11`
WHERE `locales_gameobject`.`name_loc11` <>'';

-- 5/14
UPDATE `gossip_texts`
SET `content_default` = COALESCE(`content_loc11`,`content_default`) ;

-- 6/14
-- Update Gossip_menu
UPDATE `gossip_menu_option`
INNER JOIN `locales_gossip_menu_option` ON gossip_menu_option.`menu_id`=`locales_gossip_menu_option`.`menu_id` AND gossip_menu_option.`id`=`locales_gossip_menu_option`.`id`
SET gossip_menu_option.`option_text`=`locales_gossip_menu_option`.`option_text_loc11`
WHERE `locales_gossip_menu_option`.`option_text_loc11` <>'';

-- Update Gossip_menu
UPDATE `gossip_menu_option`
INNER JOIN `locales_gossip_menu_option` ON gossip_menu_option.`menu_id`=`locales_gossip_menu_option`.`menu_id` AND gossip_menu_option.`id`=`locales_gossip_menu_option`.`id`
SET gossip_menu_option.`box_text`=`locales_gossip_menu_option`.`box_text_loc11`
WHERE `locales_gossip_menu_option`.`box_text_loc11` <>'';

-- 7/14
-- Update item_template
UPDATE `item_template`
INNER JOIN `locales_item` ON item_template.`Entry`=`locales_item`.`entry`
SET item_template.`Name`=`locales_item`.`name_loc11`
WHERE `locales_item`.`name_loc11` <>'';

-- Update item_template
UPDATE `item_template`
INNER JOIN `locales_item` ON item_template.`Entry`=`locales_item`.`entry`
SET item_template.`description`=COALESCE(`locales_item`.`description_loc11`,'')
WHERE `locales_item`.`description_loc11` <>'';
 
-- 8/14 
UPDATE `mangos_string`
SET `content_default` = COALESCE(`content_loc11`,`content_default`) ; 

-- Update page_text
UPDATE `page_text`
INNER JOIN `locales_page_text` ON page_text.`entry`=`locales_page_text`.`entry`
SET page_text.`Text`=COALESCE(`locales_page_text`.`Text_loc11`,'')
WHERE `locales_page_text`.`Text_loc11`<>'';

-- Update points_of_interest
UPDATE `points_of_interest`
INNER JOIN `locales_points_of_interest` ON points_of_interest.`entry`=`locales_points_of_interest`.`entry`
SET points_of_interest.`icon_name`=COALESCE(`locales_points_of_interest`.`icon_name_loc11`,`locales_points_of_interest`.`icon_name_loc0`);

-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`Title`=`locales_quest`.`Title_loc11`
WHERE `locales_quest`.`Title_loc11` <>'';

-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`Details`=`locales_quest`.`Details_loc11`
WHERE `locales_quest`.`Details_loc11` <>'';

-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`Objectives`=`locales_quest`.`Objectives_loc11`
WHERE `locales_quest`.`Objectives_loc11` <>'';

-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`OfferRewardText`=`locales_quest`.`OfferRewardText_loc11`
WHERE `locales_quest`.`OfferRewardText_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`RequestItemsText`=`locales_quest`.`RequestItemsText_loc11`
WHERE `locales_quest`.`RequestItemsText_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`EndText`=`locales_quest`.`EndText_loc11`
WHERE `locales_quest`.`EndText_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText1`=`locales_quest`.`ObjectiveText1_loc11`
WHERE `locales_quest`.`ObjectiveText1_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText2`=`locales_quest`.`ObjectiveText2_loc11`
WHERE `locales_quest`.`ObjectiveText2_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText3`=`locales_quest`.`ObjectiveText3_loc11`
WHERE `locales_quest`.`ObjectiveText3_loc11` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText4`=`locales_quest`.`ObjectiveText4_loc11`
WHERE `locales_quest`.`ObjectiveText4_loc11` <>'';

-- 12/14
UPDATE `script_texts`
SET `content_default` = COALESCE(`content_loc11`,`content_default`);

-- 13/14
-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text0_0`=`locales_npc_text`.`Text0_0_loc11`
WHERE `locales_npc_text`.`Text0_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text0_1`=`locales_npc_text`.`Text0_1_loc11`
WHERE `locales_npc_text`.`Text0_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text1_0`=`locales_npc_text`.`Text1_0_loc11`
WHERE `locales_npc_text`.`Text1_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text1_1`=`locales_npc_text`.`Text1_1_loc11`
WHERE `locales_npc_text`.`Text1_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text2_0`=`locales_npc_text`.`Text2_0_loc11`
WHERE `locales_npc_text`.`Text2_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text2_1`=`locales_npc_text`.`Text2_1_loc11`
WHERE `locales_npc_text`.`Text2_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text3_0`=`locales_npc_text`.`Text3_0_loc11`
WHERE `locales_npc_text`.`Text3_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text3_1`=`locales_npc_text`.`Text3_1_loc11`
WHERE `locales_npc_text`.`Text3_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text4_0`=`locales_npc_text`.`Text4_0_loc11`
WHERE `locales_npc_text`.`Text4_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text4_1`=`locales_npc_text`.`Text4_1_loc11`
WHERE `locales_npc_text`.`Text4_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text5_0`=`locales_npc_text`.`Text5_0_loc11`
WHERE `locales_npc_text`.`Text5_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text5_1`=`locales_npc_text`.`Text5_1_loc11`
WHERE `locales_npc_text`.`Text5_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text6_0`=`locales_npc_text`.`Text6_0_loc11`
WHERE `locales_npc_text`.`Text6_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text6_1`=`locales_npc_text`.`Text6_1_loc11`
WHERE `locales_npc_text`.`Text6_1_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text7_0`=`locales_npc_text`.`Text7_0_loc11`
WHERE `locales_npc_text`.`Text7_0_loc11`<>'';

-- Update npc_text
UPDATE `npc_text`
INNER JOIN `locales_npc_text` ON npc_text.`id`=`locales_npc_text`.`entry` 
SET npc_text.`Text7_1`=`locales_npc_text`.`Text7_1_loc11`
WHERE `locales_npc_text`.`Text7_1_loc11`<>'';

-- 14/14
-- UPDATE `command`
-- INNER JOIN `locales_command` ON `command`.`id`=`locales_command`.`id`
-- SET `command`.`help_text`=`locales_command`.`help_text_loc11`);
-- WHERE `locales_command`.`help_text_loc11`<>'';