A_replace_BaseEnglish_with_Italian.sql

-- ----------------------------------------------------------------------------------------------------------------
-- 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/15
-- Update Creature_Template
UPDATE `creature_template`
INNER JOIN `locales_creature` ON `creature_template`.`entry` = `locales_creature`.`Entry`
SET creature_template.`Name`=`locales_creature`.`name_loc9` WHERE `locales_creature`.`name_loc9` <>'';

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

-- 2/15
UPDATE `creature_ai_texts`
SET `content_default` = COALESCE(`content_loc9`,`content_default`);

-- 3/15
UPDATE `db_script_string`
SET `content_default` = COALESCE(`content_loc9`,`content_default`) ;

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

-- 5/15
UPDATE `gossip_texts`
SET `content_default` = COALESCE(`content_loc9`,`content_default`) ;

-- 6/15
-- 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_loc9`
WHERE `locales_gossip_menu_option`.`option_text_loc9` <>'';

-- 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_loc9`
WHERE `locales_gossip_menu_option`.`box_text_loc9` <>'';

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

-- 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_loc9`,'')
WHERE `locales_item`.`description_loc9` <>'';
 
-- 8/15 
UPDATE `mangos_string`
SET `content_default` = COALESCE(`content_loc9`,`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_loc9`,'')
WHERE `locales_page_text`.`Text_loc9`<>'';

-- 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_loc9`,`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_loc9`
WHERE `locales_quest`.`Title_loc9` <>'';

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

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

-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`OfferRewardText`=`locales_quest`.`OfferRewardText_loc9`
WHERE `locales_quest`.`OfferRewardText_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`RequestItemsText`=`locales_quest`.`RequestItemsText_loc9`
WHERE `locales_quest`.`RequestItemsText_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`EndText`=`locales_quest`.`EndText_loc9`
WHERE `locales_quest`.`EndText_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText1`=`locales_quest`.`ObjectiveText1_loc9`
WHERE `locales_quest`.`ObjectiveText1_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText2`=`locales_quest`.`ObjectiveText2_loc9`
WHERE `locales_quest`.`ObjectiveText2_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText3`=`locales_quest`.`ObjectiveText3_loc9`
WHERE `locales_quest`.`ObjectiveText3_loc9` <>'';
    
-- Update quest_template
UPDATE `quest_template`
INNER JOIN `locales_quest` ON quest_template.`entry`=`locales_quest`.`entry` 
SET quest_template.`ObjectiveText4`=`locales_quest`.`ObjectiveText4_loc9`
WHERE `locales_quest`.`ObjectiveText4_loc9` <>'';

-- 12/15
UPDATE `script_texts`
SET `content_default` = COALESCE(`content_loc9`,`content_default`);

-- 13/15
-- 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_loc9`
WHERE `locales_npc_text`.`Text0_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text0_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text1_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text1_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text2_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text2_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text3_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text3_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text4_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text4_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text5_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text5_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text6_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text6_1_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text7_0_loc9`<>'';

-- 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_loc9`
WHERE `locales_npc_text`.`Text7_1_loc9`<>'';

-- 14/15
UPDATE `command`
INNER JOIN `locales_command` ON `command`.`id`=`locales_command`.`id`
SET `command`.`help_text`=COALESCE(`locales_command`.`help_text_loc9`,`command`.`help_text`);
WHERE `locales_command`.`help_text_loc9`<>'';

-- 15/15
UPDATE `achievement_reward`
INNER JOIN `achievement_reward`.`entry`=`locales_achievement_reward`.`entry`
SET `achievement_reward`.`subject`=COALESCE(`locales_achievement_reward`.`subject_loc9`,`locales_achievement_reward`.`subject_loc0`),
SET `achievement_reward`.`text`=COALESCE(`locales_achievement_reward`.`text_loc9`,`locales_achievement_reward`.`text_loc0`);