From afbb5f2e3c369e0690c781a58b759750b6f88773 Mon Sep 17 00:00:00 2001 From: teacher Date: Fri, 26 Mar 2010 14:40:09 +0100 Subject: Moved sql update files to sql\updates\3.3.2_old. --HG-- branch : trunk --- sql/updates/3.3.2_old/7587_world_script_texts.sql | 74 +++++++ sql/updates/3.3.2_old/7591_world_spell_dbc.sql | 3 + sql/updates/3.3.2_old/7597_world_scriptname.sql | 1 + sql/updates/3.3.2_old/7598_world_scriptname.sql | 2 + .../7604_characters_item_refund_instance.sql | 19 ++ .../3.3.2_old/7609_world_spell_proc_event.sql | 4 + sql/updates/3.3.2_old/7610_world_scriptname.sql | 1 + .../7611_characters_item_refund_instance.sql | 14 ++ sql/updates/3.3.2_old/7625_world_scriptname.sql | 1 + sql/updates/3.3.2_old/7646_world_scriptname.sql | 3 + sql/updates/3.3.2_old/7655_world_script_texts.sql | 233 +++++++++++++++++++++ sql/updates/3.3.2_old/7655_world_scriptname.sql | 6 + .../3.3.2_old/7656_world_instance_template.sql | 2 + sql/updates/3.3.2_old/7658_world_scriptname.sql | 2 + .../3.3.2_old/7660_world_creature_template.sql | 3 + sql/updates/3.3.2_old/7665_world_scriptname.sql | 1 + sql/updates/3.3.2_old/7666_world_script_texts.sql | 3 + sql/updates/3.3.2_old/7668_world_scriptname.sql | 6 + sql/updates/3.3.2_old/7672_world_scriptname.sql | 1 + sql/updates/3.3.2_old/7677_realmd_realmlist.sql | 1 + .../3.3.2_old/7680_world_quest_template.sql | 1 + .../3.3.2_old/7691_world_creature_template.sql | 2 + sql/updates/3.3.2_old/7691_world_spell_dbc.sql | 10 + .../3.3.2_old/7694_world_creature_template.sql | 1 + .../3.3.2_old/7694_world_gameobject_template.sql | 1 + sql/updates/3.3.2_old/7694_world_item_template.sql | 1 + sql/updates/3.3.2_old/7694_world_npc_text.sql | 1 + sql/updates/3.3.2_old/7694_world_page_text.sql | 1 + .../3.3.2_old/7694_world_quest_template.sql | 1 + sql/updates/3.3.2_old/7697_world_npc_trainer.sql | 2 + sql/updates/3.3.2_old/7697_world_npc_vendor.sql | 2 + sql/updates/3.3.2_old/7701_world_spell_dbc.sql | 1 + sql/updates/7587_world_script_texts.sql | 74 ------- sql/updates/7591_world_spell_dbc.sql | 3 - sql/updates/7597_world_scriptname.sql | 1 - sql/updates/7598_world_scriptname.sql | 2 - .../7604_characters_item_refund_instance.sql | 19 -- sql/updates/7609_world_spell_proc_event.sql | 4 - sql/updates/7610_world_scriptname.sql | 1 - .../7611_characters_item_refund_instance.sql | 14 -- sql/updates/7625_world_scriptname.sql | 1 - sql/updates/7646_world_scriptname.sql | 3 - sql/updates/7655_world_script_texts.sql | 233 --------------------- sql/updates/7655_world_scriptname.sql | 6 - sql/updates/7656_world_instance_template.sql | 2 - sql/updates/7658_world_scriptname.sql | 2 - sql/updates/7660_world_creature_template.sql | 3 - sql/updates/7665_world_scriptname.sql | 1 - sql/updates/7666_world_script_texts.sql | 3 - sql/updates/7668_world_scriptname.sql | 6 - sql/updates/7672_world_scriptname.sql | 1 - sql/updates/7677_realmd_realmlist.sql | 1 - sql/updates/7680_world_quest_template.sql | 1 - sql/updates/7691_world_creature_template.sql | 2 - sql/updates/7691_world_spell_dbc.sql | 10 - sql/updates/7694_world_creature_template.sql | 1 - sql/updates/7694_world_gameobject_template.sql | 1 - sql/updates/7694_world_item_template.sql | 1 - sql/updates/7694_world_npc_text.sql | 1 - sql/updates/7694_world_page_text.sql | 1 - sql/updates/7694_world_quest_template.sql | 1 - sql/updates/7697_world_npc_trainer.sql | 2 - sql/updates/7697_world_npc_vendor.sql | 2 - sql/updates/7701_world_spell_dbc.sql | 1 - 64 files changed, 404 insertions(+), 404 deletions(-) create mode 100644 sql/updates/3.3.2_old/7587_world_script_texts.sql create mode 100644 sql/updates/3.3.2_old/7591_world_spell_dbc.sql create mode 100644 sql/updates/3.3.2_old/7597_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7598_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7604_characters_item_refund_instance.sql create mode 100644 sql/updates/3.3.2_old/7609_world_spell_proc_event.sql create mode 100644 sql/updates/3.3.2_old/7610_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7611_characters_item_refund_instance.sql create mode 100644 sql/updates/3.3.2_old/7625_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7646_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7655_world_script_texts.sql create mode 100644 sql/updates/3.3.2_old/7655_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7656_world_instance_template.sql create mode 100644 sql/updates/3.3.2_old/7658_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7660_world_creature_template.sql create mode 100644 sql/updates/3.3.2_old/7665_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7666_world_script_texts.sql create mode 100644 sql/updates/3.3.2_old/7668_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7672_world_scriptname.sql create mode 100644 sql/updates/3.3.2_old/7677_realmd_realmlist.sql create mode 100644 sql/updates/3.3.2_old/7680_world_quest_template.sql create mode 100644 sql/updates/3.3.2_old/7691_world_creature_template.sql create mode 100644 sql/updates/3.3.2_old/7691_world_spell_dbc.sql create mode 100644 sql/updates/3.3.2_old/7694_world_creature_template.sql create mode 100644 sql/updates/3.3.2_old/7694_world_gameobject_template.sql create mode 100644 sql/updates/3.3.2_old/7694_world_item_template.sql create mode 100644 sql/updates/3.3.2_old/7694_world_npc_text.sql create mode 100644 sql/updates/3.3.2_old/7694_world_page_text.sql create mode 100644 sql/updates/3.3.2_old/7694_world_quest_template.sql create mode 100644 sql/updates/3.3.2_old/7697_world_npc_trainer.sql create mode 100644 sql/updates/3.3.2_old/7697_world_npc_vendor.sql create mode 100644 sql/updates/3.3.2_old/7701_world_spell_dbc.sql delete mode 100644 sql/updates/7587_world_script_texts.sql delete mode 100644 sql/updates/7591_world_spell_dbc.sql delete mode 100644 sql/updates/7597_world_scriptname.sql delete mode 100644 sql/updates/7598_world_scriptname.sql delete mode 100644 sql/updates/7604_characters_item_refund_instance.sql delete mode 100644 sql/updates/7609_world_spell_proc_event.sql delete mode 100644 sql/updates/7610_world_scriptname.sql delete mode 100644 sql/updates/7611_characters_item_refund_instance.sql delete mode 100644 sql/updates/7625_world_scriptname.sql delete mode 100644 sql/updates/7646_world_scriptname.sql delete mode 100644 sql/updates/7655_world_script_texts.sql delete mode 100644 sql/updates/7655_world_scriptname.sql delete mode 100644 sql/updates/7656_world_instance_template.sql delete mode 100644 sql/updates/7658_world_scriptname.sql delete mode 100644 sql/updates/7660_world_creature_template.sql delete mode 100644 sql/updates/7665_world_scriptname.sql delete mode 100644 sql/updates/7666_world_script_texts.sql delete mode 100644 sql/updates/7668_world_scriptname.sql delete mode 100644 sql/updates/7672_world_scriptname.sql delete mode 100644 sql/updates/7677_realmd_realmlist.sql delete mode 100644 sql/updates/7680_world_quest_template.sql delete mode 100644 sql/updates/7691_world_creature_template.sql delete mode 100644 sql/updates/7691_world_spell_dbc.sql delete mode 100644 sql/updates/7694_world_creature_template.sql delete mode 100644 sql/updates/7694_world_gameobject_template.sql delete mode 100644 sql/updates/7694_world_item_template.sql delete mode 100644 sql/updates/7694_world_npc_text.sql delete mode 100644 sql/updates/7694_world_page_text.sql delete mode 100644 sql/updates/7694_world_quest_template.sql delete mode 100644 sql/updates/7697_world_npc_trainer.sql delete mode 100644 sql/updates/7697_world_npc_vendor.sql delete mode 100644 sql/updates/7701_world_spell_dbc.sql (limited to 'sql') diff --git a/sql/updates/3.3.2_old/7587_world_script_texts.sql b/sql/updates/3.3.2_old/7587_world_script_texts.sql new file mode 100644 index 00000000000..1a044fc6dd0 --- /dev/null +++ b/sql/updates/3.3.2_old/7587_world_script_texts.sql @@ -0,0 +1,74 @@ +-- set Halls of Stone text entry to correct range +-- Maiden of Grief +UPDATE `script_texts` SET `entry`=-1599000 WHERE `npc_entry`=27975 and `entry`=-1603000; +UPDATE `script_texts` SET `entry`=-1599001 WHERE `npc_entry`=27975 and `entry`=-1603001; +UPDATE `script_texts` SET `entry`=-1599002 WHERE `npc_entry`=27975 and `entry`=-1603002; +UPDATE `script_texts` SET `entry`=-1599003 WHERE `npc_entry`=27975 and `entry`=-1603003; +UPDATE `script_texts` SET `entry`=-1599004 WHERE `npc_entry`=27975 and `entry`=-1603004; +UPDATE `script_texts` SET `entry`=-1599005 WHERE `npc_entry`=27975 and `entry`=-1603005; +UPDATE `script_texts` SET `entry`=-1599006 WHERE `npc_entry`=27975 and `entry`=-1603006; +-- Krystallus +UPDATE `script_texts` SET `entry`=-1599007 WHERE `npc_entry`=27977 and `entry`=-1603007; +UPDATE `script_texts` SET `entry`=-1599008 WHERE `npc_entry`=27977 and `entry`=-1603008; +UPDATE `script_texts` SET `entry`=-1599009 WHERE `npc_entry`=27977 and `entry`=-1603009; +UPDATE `script_texts` SET `entry`=-1599010 WHERE `npc_entry`=27977 and `entry`=-1603010; +-- Sjonnir +UPDATE `script_texts` SET `entry`=-1599011,`sound`=14180 WHERE `npc_entry`=27978 and `entry`=-1603011; +UPDATE `script_texts` SET `entry`=-1599012,`sound`=14182 WHERE `npc_entry`=27978 and `entry`=-1603012; +UPDATE `script_texts` SET `entry`=-1599013,`sound`=14183 WHERE `npc_entry`=27978 and `entry`=-1603013; +UPDATE `script_texts` SET `entry`=-1599015,`sound`=14184 WHERE `npc_entry`=27978 and `entry`=-1603015; + +-- Brann and Tribunal Event +UPDATE `script_texts` SET `entry`=-1599016 WHERE `npc_entry`=28070 and `entry`=-1603016; +UPDATE `script_texts` SET `entry`=-1599017 WHERE `npc_entry`=28070 and `entry`=-1603017; +UPDATE `script_texts` SET `entry`=-1599018 WHERE `npc_entry`=28070 and `entry`=-1603018; +UPDATE `script_texts` SET `entry`=-1599019 WHERE `npc_entry`=28070 and `entry`=-1603019; +UPDATE `script_texts` SET `entry`=-1599020 WHERE `npc_entry`=28070 and `entry`=-1603020; +UPDATE `script_texts` SET `entry`=-1599021 WHERE `npc_entry`=28070 and `entry`=-1603021; +UPDATE `script_texts` SET `entry`=-1599022 WHERE `npc_entry`=28070 and `entry`=-1603022; +UPDATE `script_texts` SET `entry`=-1599023 WHERE `npc_entry`=28070 and `entry`=-1603023; +UPDATE `script_texts` SET `entry`=-1599024 WHERE `npc_entry`=28070 and `entry`=-1603024; +UPDATE `script_texts` SET `entry`=-1599025 WHERE `npc_entry`=28070 and `entry`=-1603025; +UPDATE `script_texts` SET `entry`=-1599026 WHERE `npc_entry`=28070 and `entry`=-1603026; +UPDATE `script_texts` SET `entry`=-1599027 WHERE `npc_entry`=28070 and `entry`=-1603027; +UPDATE `script_texts` SET `entry`=-1599028 WHERE `npc_entry`=28070 and `entry`=-1603028; +UPDATE `script_texts` SET `entry`=-1599029 WHERE `npc_entry`=28070 and `entry`=-1603029; +UPDATE `script_texts` SET `entry`=-1599030 WHERE `npc_entry`=28070 and `entry`=-1603030; +UPDATE `script_texts` SET `entry`=-1599031 WHERE `npc_entry`=28070 and `entry`=-1603031; +UPDATE `script_texts` SET `entry`=-1599032 WHERE `npc_entry`=28070 and `entry`=-1603032; +UPDATE `script_texts` SET `entry`=-1599033 WHERE `npc_entry`=28070 and `entry`=-1603033; +UPDATE `script_texts` SET `entry`=-1599034 WHERE `npc_entry`=28070 and `entry`=-1603034; +UPDATE `script_texts` SET `entry`=-1599035 WHERE `npc_entry`=28070 and `entry`=-1603035; +UPDATE `script_texts` SET `entry`=-1599036 WHERE `npc_entry`=28070 and `entry`=-1603036; +UPDATE `script_texts` SET `entry`=-1599037 WHERE `npc_entry`=28070 and `entry`=-1603037; +UPDATE `script_texts` SET `entry`=-1599038 WHERE `npc_entry`=28070 and `entry`=-1603038; +UPDATE `script_texts` SET `entry`=-1599039 WHERE `npc_entry`=28070 and `entry`=-1603039; +UPDATE `script_texts` SET `entry`=-1599040 WHERE `npc_entry`=28070 and `entry`=-1603040; +UPDATE `script_texts` SET `entry`=-1599041 WHERE `npc_entry`=28070 and `entry`=-1603041; +UPDATE `script_texts` SET `entry`=-1599042 WHERE `npc_entry`=28070 and `entry`=-1603042; +UPDATE `script_texts` SET `entry`=-1599043 WHERE `npc_entry`=28070 and `entry`=-1603043; +UPDATE `script_texts` SET `entry`=-1599044 WHERE `npc_entry`=28070 and `entry`=-1603044; +UPDATE `script_texts` SET `entry`=-1599045 WHERE `npc_entry`=28070 and `entry`=-1603045; +UPDATE `script_texts` SET `entry`=-1599046 WHERE `npc_entry`=28070 and `entry`=-1603046; +UPDATE `script_texts` SET `entry`=-1599047 WHERE `npc_entry`=28070 and `entry`=-1603047; +UPDATE `script_texts` SET `entry`=-1599048 WHERE `npc_entry`=28070 and `entry`=-1603048; +UPDATE `script_texts` SET `entry`=-1599049 WHERE `npc_entry`=28070 and `entry`=-1603049; +UPDATE `script_texts` SET `entry`=-1599050 WHERE `npc_entry`=28070 and `entry`=-1603050; +UPDATE `script_texts` SET `entry`=-1599051 WHERE `npc_entry`=28070 and `entry`=-1603051; +UPDATE `script_texts` SET `entry`=-1599052 WHERE `npc_entry`=28070 and `entry`=-1603052; +UPDATE `script_texts` SET `entry`=-1599053 WHERE `npc_entry`=28070 and `entry`=-1603053; +UPDATE `script_texts` SET `entry`=-1599054 WHERE `npc_entry`=28070 and `entry`=-1603054; +UPDATE `script_texts` SET `entry`=-1599055 WHERE `npc_entry`=28070 and `entry`=-1603055; +UPDATE `script_texts` SET `entry`=-1599056 WHERE `npc_entry`=28070 and `entry`=-1603056; +UPDATE `script_texts` SET `entry`=-1599057 WHERE `npc_entry`=28070 and `entry`=-1603057; +UPDATE `script_texts` SET `entry`=-1599058 WHERE `npc_entry`=28070 and `entry`=-1603058; +UPDATE `script_texts` SET `entry`=-1599059 WHERE `npc_entry`=28070 and `entry`=-1603059; +UPDATE `script_texts` SET `entry`=-1599060 WHERE `npc_entry`=28070 and `entry`=-1603060; +UPDATE `script_texts` SET `entry`=-1599061 WHERE `npc_entry`=28070 and `entry`=-1603061; +UPDATE `script_texts` SET `entry`=-1599062 WHERE `npc_entry`=28070 and `entry`=-1603062; +UPDATE `script_texts` SET `entry`=-1599063 WHERE `npc_entry`=28070 and `entry`=-1603063; +UPDATE `script_texts` SET `entry`=-1599064 WHERE `npc_entry`=28070 and `entry`=-1603064; +UPDATE `script_texts` SET `entry`=-1599065 WHERE `npc_entry`=28070 and `entry`=-1603065; +UPDATE `script_texts` SET `entry`=-1599066 WHERE `npc_entry`=28070 and `entry`=-1603066; +UPDATE `script_texts` SET `entry`=-1599067 WHERE `npc_entry`=28070 and `entry`=-1603067; +UPDATE `script_texts` SET `entry`=-1599068 WHERE `npc_entry`=28070 and `entry`=-1603068; diff --git a/sql/updates/3.3.2_old/7591_world_spell_dbc.sql b/sql/updates/3.3.2_old/7591_world_spell_dbc.sql new file mode 100644 index 00000000000..33c2f0ad08a --- /dev/null +++ b/sql/updates/3.3.2_old/7591_world_spell_dbc.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_dbc` WHERE `Id` = 200000; +INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`,`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`,`EffectBaseDice1`,`EffectBaseDice2`,`EffectBaseDice3`,`EffectDicePerLevel1`,`EffectDicePerLevel2`,`EffectDicePerLevel3`,`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`,`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`,`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`,`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`,`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES +(200000,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,8,1,0,-1,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,0,0,1,1,1,0,1,'Drain Soul increased damage - serverside spell'); diff --git a/sql/updates/3.3.2_old/7597_world_scriptname.sql b/sql/updates/3.3.2_old/7597_world_scriptname.sql new file mode 100644 index 00000000000..0c7e42939f4 --- /dev/null +++ b/sql/updates/3.3.2_old/7597_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`= 'npc_argent_tournament_post' WHERE `entry`=35473; diff --git a/sql/updates/3.3.2_old/7598_world_scriptname.sql b/sql/updates/3.3.2_old/7598_world_scriptname.sql new file mode 100644 index 00000000000..8c2d0ea32cc --- /dev/null +++ b/sql/updates/3.3.2_old/7598_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ScriptName`= 'npc_tallhorn_stag' WHERE `entry`=26363; +UPDATE `creature_template` SET `ScriptName`= 'npc_amberpine_woodsman' WHERE `entry`=27293; diff --git a/sql/updates/3.3.2_old/7604_characters_item_refund_instance.sql b/sql/updates/3.3.2_old/7604_characters_item_refund_instance.sql new file mode 100644 index 00000000000..de7ce6d69a5 --- /dev/null +++ b/sql/updates/3.3.2_old/7604_characters_item_refund_instance.sql @@ -0,0 +1,19 @@ +DROP TABLE IF EXISTS `item_refund_instance`; +CREATE TABLE `item_refund_instance` ( +`item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID', +`player_guid` int(11) unsigned NOT NULL COMMENT 'Player GUID', +`paidMoney` int(11) unsigned NOT NULL DEFAULT '0', +`paidHonor` int(11) unsigned NOT NULL DEFAULT '0', +`paidArena` int(11) unsigned NOT NULL DEFAULT '0', +`paidItem_1` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'item_template.entry', +`paidItemCount_1` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_2` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_3` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_4` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItem_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +`paidItemCount_5` mediumint(6) unsigned NOT NULL DEFAULT '0', +PRIMARY KEY (`item_guid`, `player_guid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 diff --git a/sql/updates/3.3.2_old/7609_world_spell_proc_event.sql b/sql/updates/3.3.2_old/7609_world_spell_proc_event.sql new file mode 100644 index 00000000000..2111d9b3f85 --- /dev/null +++ b/sql/updates/3.3.2_old/7609_world_spell_proc_event.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (42370); +INSERT INTO `spell_proc_event` +(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) +VALUES ( 42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Merciless Totem of the Third Wind diff --git a/sql/updates/3.3.2_old/7610_world_scriptname.sql b/sql/updates/3.3.2_old/7610_world_scriptname.sql new file mode 100644 index 00000000000..89b005f00e0 --- /dev/null +++ b/sql/updates/3.3.2_old/7610_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`= 'npc_seaforium_depth_charge' WHERE `entry`=25401; diff --git a/sql/updates/3.3.2_old/7611_characters_item_refund_instance.sql b/sql/updates/3.3.2_old/7611_characters_item_refund_instance.sql new file mode 100644 index 00000000000..cd859a47ee0 --- /dev/null +++ b/sql/updates/3.3.2_old/7611_characters_item_refund_instance.sql @@ -0,0 +1,14 @@ +ALTER TABLE `item_refund_instance` +DROP COLUMN `paidHonor`, +DROP COLUMN `paidArena`, +DROP COLUMN `paidItem_1`, +DROP COLUMN `paidItemCount_1`, +DROP COLUMN `paidItem_2`, +DROP COLUMN `paidItemCount_2`, +DROP COLUMN `paidItem_3`, +DROP COLUMN `paidItemCount_3`, +DROP COLUMN `paidItem_4`, +DROP COLUMN `paidItemCount_4`, +DROP COLUMN `paidItem_5`, +DROP COLUMN `paidItemCount_5`, +ADD COLUMN `paidExtendedCost` int(11) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/3.3.2_old/7625_world_scriptname.sql b/sql/updates/3.3.2_old/7625_world_scriptname.sql new file mode 100644 index 00000000000..ac0de6986ac --- /dev/null +++ b/sql/updates/3.3.2_old/7625_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`='instance_zulfarrak' WHERE `map`=209; diff --git a/sql/updates/3.3.2_old/7646_world_scriptname.sql b/sql/updates/3.3.2_old/7646_world_scriptname.sql new file mode 100644 index 00000000000..f9dbb6d2972 --- /dev/null +++ b/sql/updates/3.3.2_old/7646_world_scriptname.sql @@ -0,0 +1,3 @@ +UPDATE `creature_template` SET `ScriptName`='boss_drakos' WHERE `entry`=27654; +UPDATE `creature_template` SET `ScriptName`='npc_oculus_drake' WHERE `entry` IN (27657,27658,27659); +UPDATE `instance_template` SET `script`='instance_oculus' WHERE `map`=578; diff --git a/sql/updates/3.3.2_old/7655_world_script_texts.sql b/sql/updates/3.3.2_old/7655_world_script_texts.sql new file mode 100644 index 00000000000..a7213b1e518 --- /dev/null +++ b/sql/updates/3.3.2_old/7655_world_script_texts.sql @@ -0,0 +1,233 @@ +DELETE FROM `script_texts` WHERE `entry` BETWEEN -1603999 AND -1603000; +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES +-- Algalon +(32871,-1603000,'Your actions are illogical. All possible results for this encounter have been calculated. The Pantheon will receive the Observer''s message regardless of outcome.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15386,1,0,0,'algalon SAY_AGGRO'), +(32871,-1603001,'Loss of life, unavoidable.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15387,1,0,0,'algalon SAY_SLAY_1'), +(32871,-1603002,'I do what I must.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15388,1,0,0,'algalon SAY_SLAY_2'), +(32871,-1603003,'See your world through my eyes: A universe so vast as to be immeasurable - incomprehensible even to your greatest minds.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15390,1,0,0,'algalon SAY_ENGADED_FOR_FIRTS_TIME'), +(32871,-1603004,'Beware!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15391,1,0,0,'algalon SAY_PHASE_2'), +(32871,-1603005,'The stars come to my aid.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15392,1,0,0,'algalon SAY_SUMMON_COLLAPSING_STAR'), +(32871,-1603006,'I have seen worlds bathed in the Makers'' flames. Their denizens fading without so much as a whimper. Entire planetary systems born and raised in the time that it takes your mortal hearts to beat once. Yet all throughout, my own heart, devoid of emotion... of empathy. I... have... felt... NOTHING! A million, million lives wasted. Had they all held within them your tenacity? Had they all loved life as you do?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15393,1,0,0,'algalon SAY_DEATH_1'), +(32871,-1603007,'Perhaps it is your imperfection that which grants you free will. That allows you to persevere against cosmically calculated odds. You prevailed where the Titans'' own perfect creations have failed.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15401,1,0,0,'algalon SAY_DEATH_2'), +(32871,-1603008,'I''ve rearranged the reply code. Your planet will be spared. I cannot be certain of my own calculations anymore.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15402,1,0,0,'algalon SAY_DEATH_3'), +(32871,-1603009,'I lack the strength to transmit the signal. You must hurry. Find a place of power close to the skies.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15403,1,0,0,'algalon SAY_DEATH_4'), +(32871,-1603010,'Do not worry about my fate $N. If the signal is not transmitted in time re-origination will proceed regardless. Save. Your. World.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15404,1,0,0,'algalon SAY_DEATH_5'), +(32871,-1603011,'You are... out of time.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15394,1,0,0,'algalon SAY_BERSERK'), +(32871,-1603012,'Witness the fury of cosmos!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15396,1,0,0,'algalon SAY_BIGBANG_1'), +(32871,-1603013,'Behold the tools of creation!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15397,1,0,0,'algalon SAY_BIGBANG_2'), +(32871,-1603014,'Analysis complete. There is partial corruption in the planet''s life-support systems as well as complete corruption in most of the planet''s defense mechanisms.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15398,1,0,0,'algalon SAY_TIMER_1'), +(32871,-1603015,'Begin uplink: Reply Code: ''Omega''. Planetary re-origination requested.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15399,1,0,0,'algalon SAY_TIMER_2'), +(32871,-1603016,'Farewell, mortals. Your bravery is admirable, for such flawed creatures.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15400,1,0,0,'algalon SAY_TIMER_3'), +(32871,-1603017,'Trans-location complete. Commencing planetary analysis of Azeroth.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15405,1,0,0,'algalon SAY_SUMMON_1'), +(32871,-1603018,'Stand back, mortals. I am not here to fight you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15406,1,0,0,'algalon SAY_SUMMON_2'), +(32871,-1603019,'It is in the universe''s best interest to re-originate this planet should my analysis find systemic corruption. Do not interfere.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15407,1,0,0,'algalon SAY_SUMMON_3'), + +-- Assembly of Iron - Stellbreaker +(32867,-1603020,'You will not defeat the Assembly of Iron so easily, invaders!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15674,1,0,0,'steelbreaker SAY_AGGRO'), +(32867,-1603021,'So fragile and weak!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15675,1,0,0,'steelbreaker SAY_SLAY_1'), +(32867,-1603022,'Flesh... such a hindrance.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15676,1,0,0,'steelbreaker SAY_SLAY_2'), +(32867,-1603023,'You seek the secrets of Ulduar? Then take them!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15677,1,0,0,'steelbreaker SAY_POWER'), +(32867,-1603024,'My death only serves to hasten your demise.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15678,1,0,0,'steelbreaker SAY_DEATH_1'), +(32867,-1603025,'Impossible!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15679,1,0,0,'steelbreaker SAY_DEATH_2'), +(32867,-1603026,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15680,1,0,0,'steelbreaker SAY_BERSERK'), + +-- Assembly of Iron - Runemaster Molgeim +(32927,-1603030,'Nothing short of total decimation will suffice.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15657,1,0,0,'Molgeim SAY_AGGRO'), +(32927,-1603031,'The world suffers yet another insignificant loss.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15658,1,0,0,'Molgeim SAY_SLAY_1'), +(32927,-1603032,'Death is the price of your arrogance.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15659,1,0,0,'Molgeim SAY_SLAY_2'), +(32927,-1603033,'Decipher this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15660,1,0,0,'Molgeim SAY_RUNE_DEATH'), +(32927,-1603034,'Face the lightning surge!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15661,1,0,0,'Molgeim SAY_SUMMON'), +(32927,-1603035,'The legacy of storms shall not be undone.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15662,1,0,0,'Molgeim SAY_DEATH_1'), +(32927,-1603036,'What have you gained from my defeat? You are no less doomed, mortals!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15663,1,0,0,'Molgeim SAY_DEATH_2'), +(32927,-1603037,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15664,1,0,0,'Molgeim SAY_BERSERK'), + +-- Assembly of Iron - Stormcaller Brundir +(32857,-1603040,'Whether the world''s greatest gnats or the world''s greatest heroes, you''re still only mortal!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15684,1,0,0,'Brundir SAY_AGGRO'), +(32857,-1603041,'A merciful kill!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15685,1,0,0,'Brundir SAY_SLAY_1'), +(32857,-1603042,'HAH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15686,1,0,0,'Brundir SAY_SLAY_2'), +(32857,-1603043,'Stand still and stare into the light!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15687,1,0,0,'Brundir SAY_SPECIAL'), +(32857,-1603044,'Let the storm clouds rise and rain down death from above!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15688,1,0,0,'Brundir SAY_FLIGHT'), +(32857,-1603045,'The power of the storm lives on...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15689,1,0,0,'Brundir SAY_DEATH_1'), +(32857,-1603046,'You rush headlong into the maw of madness!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15690,1,0,0,'Brundir SAY_DEATH_2'), +(32857,-1603047,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15691,1,0,0,'Brundir SAY_BERSERK'), + +-- Auriaya +(33515,-1603050,'Some things are better left alone!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15473,1,0,0,'Auriaya SAY_AGGRO'), +(33515,-1603051,'The secret dies with you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15474,1,0,0,'Auriaya SAY_SLAY_1'), +(33515,-1603052,'There is no escape!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15475,1,0,0,'Auriaya SAY_SLAY_2'), +(33515,-1603053,'Auriaya screams in agony.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,15476,'Auriaya SAY_DEATH'), +(33515,-1603054,'You waste my time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15477,1,0,0,'Auriaya SAY_BERSERK'), + +-- Flame Leviathan +(33113,-1603060,'Hostile entities detected. Threat assessment protocol active. Primary target engaged. Time minus thirty seconds to re-evaluation.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15506,1,0,0,'Flame Leviathan SAY_AGGRO'), +(33113,-1603061,'Threat assessment routine modified. Current target threat level: zero. Acquiring new target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15521,1,0,0,'Flame Leviathan SAY_SLAY'), +(33113,-1603062,'Total systems failure. Defense protocols breached. Leviathan Unit shutting down.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15520,1,0,0,'Flame Leviathan SAY_DEATH'), +(33113,-1603063,'Threat re-evaluated. Target assessment complete. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15507,1,0,0,'Flame Leviathan SAY_TARGET_1'), +(33113,-1603064,'Pursuit objective modified. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15508,1,0,0,'Flame Leviathan SAY_TARGET_2'), +(33113,-1603065,'Hostile entity stratagem predicted. Rerouting battle function. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15509,1,0,0,'Flame Leviathan SAY_TARGET_3'), +(33113,-1603066,'Orbital countermeasures enabled.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15510,1,0,0,'Flame Leviathan SAY_HARDMODE'), +(33113,-1603067,'Alert! Static defense system failure. Orbital countermeasures disabled.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15511,1,0,0,'Flame Leviathan SAY_TOWER_NONE'), +(33113,-1603068,'''Hodir''s Fury'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15512,1,0,0,'Flame Leviathan SAY_TOWER_FROST'), +(33113,-1603069,'''Mimiron''s Inferno'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15513,1,0,0,'Flame Leviathan SAY_TOWER_FLAME'), +(33113,-1603070,'''Freya''s Ward'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15514,1,0,0,'Flame Leviathan SAY_TOWER_NATURE'), +(33113,-1603071,'''Thorim''s Hammer'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15515,1,0,0,'Flame Leviathan SAY_TOWER_STORM'), +(33113,-1603072,'Unauthorized entity attempting circuit overload. Activating anti-personnel countermeasures.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15516,1,0,0,'Flame Leviathan SAY_PLAYER_RIDING'), +(33113,-1603073,'System malfunction. Diverting power to support systems.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15517,1,0,0,'Flame Leviathan SAY_OVERLOAD_1'), +(33113,-1603074,'Combat matrix overload. Powering do-o-o-own...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15518,1,0,0,'Flame Leviathan SAY_OVERLOAD_2'), +(33113,-1603075,'System restart required. Deactivating weapon systems.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15519,1,0,0,'Flame Leviathan SAY_OVERLOAD_3'), +-- reserve 1603076-1603179 to implement other texts related to flame leviathan encounter + +-- Freya +(32906,-1603180,'The Conservatory must be protected!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15526,1,0,0,'Freya SAY_AGGRO'), +(32906,-1603181,'Elders, grant me your strength!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15527,1,0,0,'Freya SAY_AGGRO_WITH_ELDER'), +(32906,-1603182,'Forgive me.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15529,1,0,0,'Freya SAY_SLAY_1'), +(32906,-1603183,'From your death springs life anew!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15530,1,0,0,'Freya SAY_SLAY_2'), +(32906,-1603184,'His hold on me dissipates. I can see clearly once more. Thank you, heroes.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15531,1,0,0,'Freya SAY_DEATH'), +(32906,-1603185,'You have strayed too far, wasted too much time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15532,1,0,0,'Freya SAY_BERSERK'), +(32906,-1603186,'Eonar, your servant requires aid!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15528,1,0,0,'Freya SAY_SUMMON_CONSERVATOR'), +(32906,-1603187,'Children, assist me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15331,1,0,0,'Freya SAY_SUMMON_TRIO'), +(32906,-1603188,'The swarm of the elements shall overtake you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15534,1,0,0,'Freya SAY_SUMMON_LASHERS'), +(32906,-1603189,'Eonar, your servant calls for your blessing!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15535,1,0,0,'Freya SAY_YS_HELP'), + +-- Elder Brightleaf +(32915,-1603190,'Matron, the Conservatory has been breached!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15483,1,0,0,'Elder Brightleaf SAY_AGGRO'), +(32915,-1603191,'Fertilizer.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15485,1,0,0,'Elder Brightleaf SAY_SLAY_1'), +(32915,-1603192,'Your corpse will nourish the soil!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15486,1,0,0,'Elder Brightleaf SAY_SLAY_2'), +(32915,-1603193,'Matron, one has fallen!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15487,1,0,0,'Elder Brightleaf SAY_DEATH'), + +-- Elder Ironbranch +(32913,-1603194,'Mortals have no place here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15493,1,0,0,'Elder Ironbranch SAY_AGGRO'), +(32913,-1603195,'I return you whence you came!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15494,1,0,0,'Elder Ironbranch SAY_SLAY_1'), +(32913,-1603196,'BEGONE!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15495,1,0,0,'Elder Ironbranch SAY_SLAY_2'), +(32913,-1603197,'Freya! They come for you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15496,1,0,0,'Elder Ironbranch SAY_DEATH'), + +-- Elder Stonebark +(32914,-1603198,'This place will serve as your graveyard.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15500,1,0,0,'Elder Stonebark SAY_AGGRO'), +(32914,-1603199,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15501,1,0,0,'Elder Stonebark SAY_SLAY_1'), +(32914,-1603200,'Such a waste.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15502,1,0,0,'Elder Stonebark SAY_SLAY_2'), +(32914,-1603201,'Matron, flee! They are ruthless....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15503,1,0,0,'Elder Stonebark SAY_DEATH'), + +-- Hodir +(32845,-1603210,'You will suffer for this trespass!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15552,1,0,0,'Hodir SAY_AGGRO'), +(32845,-1603211,'Tragic. To come so far, only to fail.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15553,1,0,0,'Hodir SAY_SLAY_1'), +(32845,-1603212,'Welcome to the endless winter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15554,1,0,0,'Hodir SAY_SLAY_2'), +(32845,-1603213,'Winds of the north consume you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15555,1,0,0,'Hodir SAY_FLASH_FREEZE'), +(32845,-1603214,'Hodir roars furious.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15556,6,0,0,'Hodir SAY_STALACTITE'), +(32845,-1603215,'I... I am released from his grasp... at last.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15557,1,0,0,'Hodir SAY_DEATH'), +(32845,-1603216,'Enough! This ends now!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15558,1,0,0,'Hodir SAY_BERSERK'), +(32845,-1603217,'The veil of winter will protect you, champions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15559,1,0,0,'Hodir SAY_YS_HELP'), +(32845,-1603218,'Hodir shatters the Rare Cache of Hodir!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,0,'Hodir SAY_HARD_MODE_MISSED'), + +-- Ignis +(33118,-1603220,'Insolent whelps! Your blood will temper the weapons used to reclaim this world!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15564,1,0,0,'Ignis SAY_AGGRO'), +(33118,-1603221,'More scraps for the scrapheap!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15569,1,0,0,'Ignis SAY_SLAY_1'), +(33118,-1603222,'Your bones will serve as kindling!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15570,1,0,0,'Ignis SAY_SLAY_2'), +(33118,-1603223,'I. Have. Failed.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15572,1,0,0,'Ignis SAY_DEATH'), +(33118,-1603224,'Arise, soldiers of the Iron Crucible! The Makers'' will be done!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15565,1,0,0,'Ignis SAY_SUMMON'), +(33118,-1603225,'I will burn away your impurities!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15566,1,0,0,'Ignis SAY_SLAG_POT'), +(33118,-1603226,'Let the inferno consume you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15567,1,0,0,'Ignis SAY_SCORCH_1'), +(33118,-1603227,'BURN! Burn in the makers fire!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15568,1,0,0,'Ignis SAY_SCORCH_2'), +(33118,-1603228,'Let it be finished!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15571,1,0,0,'Ignis SAY_BERSERK'), + +-- Kologarn +(32930,-1603230,'None shall pass!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15586,1,0,0,'Kologarn SAY_AGGRO'), +(32930,-1603231,'KOL-THARISH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15587,1,0,0,'Kologarn SAY_SLAY_1'), +(32930,-1603232,'YOU FAIL!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15588,1,0,0,'Kologarn SAY_SLAY_2'), +(32930,-1603233,'Just a scratch!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15589,1,0,0,'Kologarn SAY_LEFT_ARM_GONE'), +(32930,-1603234,'Only a flesh wound!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15590,1,0,0,'Kologarn SAY_RIGHT_ARM_GONE'), +(32930,-1603235,'OBLIVION!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15591,1,0,0,'Kologarn SAY_SHOCKWAVE'), +(32930,-1603236,'I will squeeze the life from you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15592,1,0,0,'Kologarn SAY_GRAB_PLAYER'), +(32930,-1603237,'Master, they come...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15593,1,0,0,'Kologarn SAY_DEATH'), +(32930,-1603238,'I am invincible!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15594,1,0,0,'Kologarn SAY_BERSERK'), + +-- Mimiron +(33350,-1603240,'Oh, my! I wasn''t expecting company! The workshop is such a mess! How embarrassing!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15611,1,0,0,'Mimiron SAY_AGGRO'), +(33350,-1603241,'Now why would you go and do something like that? Didn''t you see the sign that said ''DO NOT PUSH THIS BUTTON!''? How will we finish testing with the self-destruct mechanism active?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15629,1,0,0,'Mimiron SAY_HARDMODE_ON'), +(33350,-1603242,'We haven''t much time, friends! You''re going to help me test out my latest and greatest creation. Now, before you change your minds, remember, that you kind of owe it to me after the mess you made with the XT-002.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15612,1,0,0,'Mimiron SAY_MKII_ACTIVATE'), +(33350,-1603243,'MEDIC!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15613,1,0,0,'Mimiron SAY_MKII_SLAY_1'), +(33350,-1603244,'I can fix that... or, maybe not! Sheesh, what a mess...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15614,1,0,0,'Mimiron SAY_MKII_SLAY_2'), +(33350,-1603245,'WONDERFUL! Positively marvelous results! Hull integrity at 98.9 percent! Barely a dent! Moving right along.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15615,1,0,0,'Mimiron SAY_MKII_DEATH'), +(33350,-1603246,'Behold the VX-001 Anti-personnel Assault Cannon! You might want to take cover.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15616,1,0,0,'Mimiron SAY_VX001_ACTIVATE'), +(33350,-1603247,'Fascinating. I think they call that a "clean kill".',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15617,1,0,0,'Mimiron SAY_VX001_SLAY_1'), +(33350,-1603248,'Note to self: Cannon highly effective against flesh.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15618,1,0,0,'Mimiron SAY_VX001_SLAY_2'), +(33350,-1603249,'Thank you, friends! Your efforts have yielded some fantastic data! Now, where did I put-- oh, there it is!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15619,1,0,0,'Mimiron SAY_VX001_DEATH'), +(33350,-1603250,'Isn''t it beautiful? I call it the magnificent aerial command unit!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15620,1,0,0,'Mimiron SAY_AERIAL_ACTIVATE'), +(33350,-1603251,'Outplayed!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15621,1,0,0,'Mimiron SAY_AERIAL_SLAY_1'), +(33350,-1603252,'You can do better than that!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15622,1,0,0,'Mimiron SAY_AERIAL_SLAY_2'), +(33350,-1603253,'Preliminary testing phase complete. Now comes the true test!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15623,1,0,0,'Mimiron SAY_AERIAL_DEATH'), +(33350,-1603254,'Gaze upon its magnificence! Bask in its glorious, um, glory! I present you... V-07-TR-0N!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15624,1,0,0,'Mimiron SAY_V07TRON_ACTIVATE'), +(33350,-1603255,'Prognosis: Negative!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15625,1,0,0,'Mimiron SAY_V07TRON_SLAY_1'), +(33350,-1603256,'You''re not going to get up from that one, friend.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15626,1,0,0,'Mimiron SAY_V07TRON_SLAY_2'), +(33350,-1603257,'It would appear that I''ve made a slight miscalculation. I allowed my mind to be corrupted by the fiend in the prison, overriding my primary directive. All systems seem to be functional now. Clear.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15627,1,0,0,'Mimiron SAY_V07TRON_DEATH'), +(33350,-1603258,'Oh, my! It would seem that we are out of time, my friends!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15628,1,0,0,'Mimiron SAY_BERSERK'), +(33350,-1603259,'Combat matrix enhanced. Behold wonderous rapidity!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15630,1,0,0,'Mimiron SAY_YS_HELP'), + +-- Razorscale encounter +(33210,-1603260,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15647,1,0,0,'Exp. Commander SAY_INTRO'), +(33210,-1603261,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15648,1,0,0,'Exp. Commander SAY_GROUND'), + +-- Thorim +(33413,-1603270,'Interlopers! You mortals who dare to interfere with my sport will pay... Wait--you...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15733,1,0,0,'Thorim SAY_AGGRO_1'), +(33413,-1603271,'I remember you... In the mountains... But you... what is this? Where am--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15734,1,0,0,'Thorim SAY_AGGRO_2'), +(33413,-1603272,'Behold the power of the storms and despair!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15735,1,0,0,'Thorim SAY_SPECIAL_1'), +(33413,-1603273,'Do not hold back! Destroy them!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15736,1,0,0,'Thorim SAY_SPECIAL_2'), +(33413,-1603274,'Have you begun to regret your intrusion?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15737,1,0,0,'Thorim SAY_SPECIAL_3'), +(33413,-1603275,'Impertinent whelps! You dare challenge me atop my pedestal! I will crush you myself!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15738,1,0,0,'Thorim SAY_JUMPDOWN'), +(33413,-1603276,'Can''t you at least put up a fight!?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15739,1,0,0,'Thorim SAY_SLAY_1'), +(33413,-1603277,'Pathetic!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15740,1,0,0,'Thorim SAY_SLAY_2'), +(33413,-1603278,'My patience has reached its limit!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15741,1,0,0,'Thorim SAY_BERSERK'), +(33413,-1603279,'Failures! Weaklings!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15742,1,0,0,'Thorim SAY_WIPE'), +(33413,-1603280,'Stay your arms! I yield!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15743,1,0,0,'Thorim SAY_DEATH'), +(33413,-1603281,'I feel as though I am awakening from a nightmare, but the shadows in this place yet linger.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15744,1,0,0,'Thorim SAY_END_NORMAL_1'), +(33413,-1603282,'Sif... was Sif here? Impossible--she died by my brother''s hand. A dark nightmare indeed....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15745,1,0,0,'Thorim SAY_END_NORMAL_2'), +(33413,-1603283,'I need time to reflect.... I will aid your cause if you should require it. I owe you at least that much. Farewell.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15746,1,0,0,'Thorim SAY_END_NORMAL_3'), +(33413,-1603284,'You! Fiend! You are not my beloved! Be gone!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15747,1,0,0,'Thorim SAY_END_HARD_1'), +(33413,-1603285,'Behold the hand behind all the evil that has befallen Ulduar! Left my kingdom in ruins, corrupted my brother and slain my wife!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15748,1,0,0,'Thorim SAY_END_HARD_2'), +(33413,-1603286,'And now it falls to you, champions, to avenge us all! The task before you is great, but I will lend you my aid as I am able. You must prevail!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15749,1,0,0,'Thorim SAY_END_HARD_3'), +(33413,-1603287,'Golganneth, lend me your strengh! Grant my mortal allies the power of thunder!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15750,1,0,0,'Thorim SAY_YS_HELP'), + +-- General Vezax +(33271,-1603290,'Your destruction will herald a new age of suffering!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15542,1,0,0,'Vezax SAY_AGGRO'), +(33271,-1603291,'You thought to stand before the legions of death... and survive?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15543,1,0,0,'Vezax SAY_SLAY_1'), +(33271,-1603292,'Defiance... a flaw of mortality.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15544,1,0,0,'Vezax SAY_SLAY_2'), +(33271,-1603293,'The black blood of Yogg-Saron courses through me! I. AM. UNSTOPPABLE!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15545,1,0,0,'Vezax SAY_SURGE_DARKNESS'), +(33271,-1603294,'Oh, what horrors await....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15546,1,0,0,'Vezax SAY_DEATH'), +(33271,-1603295,'Your defeat was inevitable!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15547,1,0,0,'Vezax SAY_BERSERK'), +(33271,-1603296,'Behold, now! Terror, absolute!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15548,1,0,0,'Vezax SAY_HARDMODE_ON'), + +-- XT002 +(33293,-1603300,'New toys? For me? I promise I won''t break them this time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15724,1,0,0,'XT002 SAY_AGGRO'), +(33293,-1603301,'So tired. I will rest for just a moment!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15725,1,0,0,'XT002 SAY_HEART_OPENED'), +(33293,-1603302,'I''m ready to play!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15726,1,0,0,'XT002 SAY_HEART_CLOSED'), +(33293,-1603303,'NO! NO! NO! NO! NO!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15727,1,0,0,'XT002 SAY_TYMPANIC_TANTRUM'), +(33293,-1603304,'I... I think I broke it.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15728,1,0,0,'XT002 SAY_SLAY_1'), +(33293,-1603305,'I guess it doesn''t bend that way.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15729,1,0,0,'XT002 SAY_SLAY_2'), +(33293,-1603306,'I''m tired of these toys. I don''t want to play anymore!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15730,1,0,0,'XT002 SAY_BERSERK'), +(33293,-1603307,'You are bad... Toys... Very... Baaaaad!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15731,1,0,0,'XT002 SAY_DEATH'), +(33293,-1603308,'Time for a new game! My old toys will fight my new toys!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15732,1,0,0,'XT002 SAY_SUMMON'), + +-- Sara (YS) +(33134,-1603310,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15771,1,0,0,'Sara SAY_PREFIGHT_1'), +(33134,-1603311,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15772,1,0,0,'Sara SAY_PREFIGHT_2'), +(33134,-1603312,'The time to strike at the head of the beast will soon be upon us! Focus your anger and hatred on his minions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15775,1,0,0,'Sara SAY_AGGRO_1'), +(33134,-1603313,'Yes! YES! Show them no mercy! Give no pause to your attacks!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15773,1,0,0,'Sara SAY_AGGRO_2'), +(33134,-1603314,'Let hatred and rage guide your blows!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15774,1,0,0,'Sara SAY_AGGRO_3'), +(33134,-1603315,'Powerless to act...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15778,1,0,0,'Sara SAY_SLAY_1'), +(33134,-1603316,'Could they have been saved?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15779,1,0,0,'Sara SAY_SLAY_2'), +(33134,-1603317,'Weak-minded fools!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15780,5,0,0,'Sara WHISP_INSANITY'), +(33134,-1603318,'Suffocate upon your own hate!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15776,1,0,0,'Sara SAY_PHASE2_1'), +(33134,-1603319,'Tremble, mortals, before the coming of the end!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15777,1,0,0,'Sara SAY_PHASE2_2'), + +-- YoggSaron +(33288,-1603330,'I am the lucid dream.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15754,1,0,0,'YoggSaron SAY_PHASE2_1'), -- sound 15754 contains the 5 texts +(33288,-1603331,'The monster in your nightmares.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_2'), +(33288,-1603332,'The fiend of a thousand faces.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_3'), +(33288,-1603333,'Cower before my true form.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_4'), +(33288,-1603334,'BOW DOWN BEFORE THE GOD OF DEATH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_5'), +(33288,-1603335,'Look upon the true face of death and know that your end comes soon!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15755,1,0,0,'YoggSaron SAY_PHASE3'), +(33288,-1603336,'MADNESS WILL CONSUME YOU!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15756,1,0,0,'YoggSaron SAY_VISION'), +(33288,-1603337,'Hoohehehahahaha... AHAHAHAHAHAHA!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15757,1,0,0,'YoggSaron SAY_SLAY_1'), +(33288,-1603338,'Eternal suffering awaits!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15758,1,0,0,'YoggSaron SAY_SLAY_2'), +(33288,-1603339,'Your will is no longer you own...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15759,5,0,0,'YoggSaron WHISP_INSANITY_1'), +(33288,-1603340,'Destroy them minion, your master commands it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15760,5,0,0,'YoggSaron WHISP_INSANITY_2'), +(33288,-1603341,'Your fate is sealed. The end of days is finally upon you and ALL who inhabit this miserable little seedling. Uulwi ifis halahs gag erh''ongg w''ssh.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15761,1,0,0,'YoggSaron SAY_DEATH'); diff --git a/sql/updates/3.3.2_old/7655_world_scriptname.sql b/sql/updates/3.3.2_old/7655_world_scriptname.sql new file mode 100644 index 00000000000..12bb45c4fe2 --- /dev/null +++ b/sql/updates/3.3.2_old/7655_world_scriptname.sql @@ -0,0 +1,6 @@ +UPDATE `creature_template` SET `ScriptName`='mob_xt002_heart' WHERE `entry`=33329; +UPDATE `creature_template` SET `ScriptName`='mob_scrapbot' WHERE `entry`=33343; +UPDATE `creature_template` SET `ScriptName`='mob_pummeller' WHERE `entry`=33344; +UPDATE `creature_template` SET `ScriptName`='mob_boombot' WHERE `entry`=33346; +UPDATE `creature_template` SET `ScriptName`='mob_void_zone' WHERE `entry`=34001; +UPDATE `creature_template` SET `ScriptName`='mob_life_spark' WHERE `entry`=34004; diff --git a/sql/updates/3.3.2_old/7656_world_instance_template.sql b/sql/updates/3.3.2_old/7656_world_instance_template.sql new file mode 100644 index 00000000000..54d50b04e3f --- /dev/null +++ b/sql/updates/3.3.2_old/7656_world_instance_template.sql @@ -0,0 +1,2 @@ +ALTER TABLE `instance_template` ADD COLUMN `allowMount` tinyint(1) NOT NULL DEFAULT '0'; + diff --git a/sql/updates/3.3.2_old/7658_world_scriptname.sql b/sql/updates/3.3.2_old/7658_world_scriptname.sql new file mode 100644 index 00000000000..69bace778c9 --- /dev/null +++ b/sql/updates/3.3.2_old/7658_world_scriptname.sql @@ -0,0 +1,2 @@ +UPDATE `creature_template` SET `ScriptName`='npc_twilight_fissure' WHERE `entry`=30641; +UPDATE `creature_template` SET `ScriptName`='npc_flame_tsunami' WHERE `entry`=30616; diff --git a/sql/updates/3.3.2_old/7660_world_creature_template.sql b/sql/updates/3.3.2_old/7660_world_creature_template.sql new file mode 100644 index 00000000000..e987add88e9 --- /dev/null +++ b/sql/updates/3.3.2_old/7660_world_creature_template.sql @@ -0,0 +1,3 @@ +ALTER TABLE creature_template ADD COLUMN speed_run float NOT NULL default '1.14286' COMMENT 'Result of 8.0/7.0, most common value' AFTER speed; +UPDATE creature_template SET speed=1 WHERE speed IS NULL; +ALTER TABLE creature_template CHANGE COLUMN speed speed_walk FLOAT NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value'; diff --git a/sql/updates/3.3.2_old/7665_world_scriptname.sql b/sql/updates/3.3.2_old/7665_world_scriptname.sql new file mode 100644 index 00000000000..d049751b323 --- /dev/null +++ b/sql/updates/3.3.2_old/7665_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_unstable_sphere' WHERE `entry`=28166; diff --git a/sql/updates/3.3.2_old/7666_world_script_texts.sql b/sql/updates/3.3.2_old/7666_world_script_texts.sql new file mode 100644 index 00000000000..ec6a760adea --- /dev/null +++ b/sql/updates/3.3.2_old/7666_world_script_texts.sql @@ -0,0 +1,3 @@ +DELETE FROM `script_texts` WHERE `entry`=-1603187; +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES +(32906,-1603187,'Children, assist me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15533,1,0,0,'Freya SAY_SUMMON_TRIO'); diff --git a/sql/updates/3.3.2_old/7668_world_scriptname.sql b/sql/updates/3.3.2_old/7668_world_scriptname.sql new file mode 100644 index 00000000000..0dd91ff5785 --- /dev/null +++ b/sql/updates/3.3.2_old/7668_world_scriptname.sql @@ -0,0 +1,6 @@ +UPDATE `creature_template` SET `ScriptName`='boss_koralon' WHERE `entry`=35013; +UPDATE `creature_template` SET `ScriptName`='mob_flame_warder' WHERE `entry`=35143; +UPDATE `creature_template` SET `ScriptName`='boss_toravon' WHERE `entry`=38433; +UPDATE `creature_template` SET `ScriptName`='mob_frost_warder' WHERE `entry`=38482; +UPDATE `creature_template` SET `ScriptName`='mob_frozen_orb_stalker' WHERE `entry`=38461; +UPDATE `creature_template` SET `ScriptName`='mob_frozen_orb' WHERE `entry`=38456; diff --git a/sql/updates/3.3.2_old/7672_world_scriptname.sql b/sql/updates/3.3.2_old/7672_world_scriptname.sql new file mode 100644 index 00000000000..b9451e75629 --- /dev/null +++ b/sql/updates/3.3.2_old/7672_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_ruins_dweller' WHERE `entry`=29920; diff --git a/sql/updates/3.3.2_old/7677_realmd_realmlist.sql b/sql/updates/3.3.2_old/7677_realmd_realmlist.sql new file mode 100644 index 00000000000..cddab25c060 --- /dev/null +++ b/sql/updates/3.3.2_old/7677_realmd_realmlist.sql @@ -0,0 +1 @@ +ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11403'; diff --git a/sql/updates/3.3.2_old/7680_world_quest_template.sql b/sql/updates/3.3.2_old/7680_world_quest_template.sql new file mode 100644 index 00000000000..296f2d5cdba --- /dev/null +++ b/sql/updates/3.3.2_old/7680_world_quest_template.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` ADD COLUMN `MaxLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `MinLevel`; diff --git a/sql/updates/3.3.2_old/7691_world_creature_template.sql b/sql/updates/3.3.2_old/7691_world_creature_template.sql new file mode 100644 index 00000000000..9487f5f0e8f --- /dev/null +++ b/sql/updates/3.3.2_old/7691_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Spells for Wintergarde Gryphon +UPDATE `creature_template` SET `spell1`=48363,`spell2`=48397,`spell3`=54170 WHERE `entry`=27258; diff --git a/sql/updates/3.3.2_old/7691_world_spell_dbc.sql b/sql/updates/3.3.2_old/7691_world_spell_dbc.sql new file mode 100644 index 00000000000..79b55b77285 --- /dev/null +++ b/sql/updates/3.3.2_old/7691_world_spell_dbc.sql @@ -0,0 +1,10 @@ +-- Add serverside spells place holders for future development +DELETE FROM `spell_dbc` WHERE `Id` IN (42876,44987,48803,68496,72958,32780,45453); +INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES +(42876, 'Quest 9275 reward serverside spell'), +(44987, 'Quest 11521 reward serverside spell'), +(48803, 'Quest 12214 reward serverside spell'), +(68496, 'Item_template serverside spell'), +(72958, 'Item_template serverside spell'), +(32780, 'Quest 10040 reward serverside spell'), +(45453, 'Quest 11587 reward serverside spell'); diff --git a/sql/updates/3.3.2_old/7694_world_creature_template.sql b/sql/updates/3.3.2_old/7694_world_creature_template.sql new file mode 100644 index 00000000000..a094f2ca9f2 --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_creature_template.sql @@ -0,0 +1 @@ +ALTER TABLE `creature_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7694_world_gameobject_template.sql b/sql/updates/3.3.2_old/7694_world_gameobject_template.sql new file mode 100644 index 00000000000..8e9e5cb59aa --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_gameobject_template.sql @@ -0,0 +1 @@ +ALTER TABLE `gameobject_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7694_world_item_template.sql b/sql/updates/3.3.2_old/7694_world_item_template.sql new file mode 100644 index 00000000000..cab268a8c68 --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_item_template.sql @@ -0,0 +1 @@ +ALTER TABLE `item_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7694_world_npc_text.sql b/sql/updates/3.3.2_old/7694_world_npc_text.sql new file mode 100644 index 00000000000..adcb38b570f --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_npc_text.sql @@ -0,0 +1 @@ +ALTER TABLE `npc_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7694_world_page_text.sql b/sql/updates/3.3.2_old/7694_world_page_text.sql new file mode 100644 index 00000000000..ccbe66997e1 --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_page_text.sql @@ -0,0 +1 @@ +ALTER TABLE `page_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7694_world_quest_template.sql b/sql/updates/3.3.2_old/7694_world_quest_template.sql new file mode 100644 index 00000000000..1c0cb7dc47f --- /dev/null +++ b/sql/updates/3.3.2_old/7694_world_quest_template.sql @@ -0,0 +1 @@ +ALTER TABLE `quest_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/3.3.2_old/7697_world_npc_trainer.sql b/sql/updates/3.3.2_old/7697_world_npc_trainer.sql new file mode 100644 index 00000000000..0e79b01c931 --- /dev/null +++ b/sql/updates/3.3.2_old/7697_world_npc_trainer.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_trainer` MODIFY COLUMN `spell` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/updates/3.3.2_old/7697_world_npc_vendor.sql b/sql/updates/3.3.2_old/7697_world_npc_vendor.sql new file mode 100644 index 00000000000..e2fcff7deb1 --- /dev/null +++ b/sql/updates/3.3.2_old/7697_world_npc_vendor.sql @@ -0,0 +1,2 @@ +ALTER TABLE `npc_vendor` MODIFY COLUMN `item` MEDIUMINT(8) NOT NULL DEFAULT 0; + diff --git a/sql/updates/3.3.2_old/7701_world_spell_dbc.sql b/sql/updates/3.3.2_old/7701_world_spell_dbc.sql new file mode 100644 index 00000000000..e5bcc19a098 --- /dev/null +++ b/sql/updates/3.3.2_old/7701_world_spell_dbc.sql @@ -0,0 +1 @@ +UPDATE `spell_dbc` SET `DurationIndex` = 4, `EffectImplicitTargetA1` = 25 WHERE `Id` = 61988; diff --git a/sql/updates/7587_world_script_texts.sql b/sql/updates/7587_world_script_texts.sql deleted file mode 100644 index 1a044fc6dd0..00000000000 --- a/sql/updates/7587_world_script_texts.sql +++ /dev/null @@ -1,74 +0,0 @@ --- set Halls of Stone text entry to correct range --- Maiden of Grief -UPDATE `script_texts` SET `entry`=-1599000 WHERE `npc_entry`=27975 and `entry`=-1603000; -UPDATE `script_texts` SET `entry`=-1599001 WHERE `npc_entry`=27975 and `entry`=-1603001; -UPDATE `script_texts` SET `entry`=-1599002 WHERE `npc_entry`=27975 and `entry`=-1603002; -UPDATE `script_texts` SET `entry`=-1599003 WHERE `npc_entry`=27975 and `entry`=-1603003; -UPDATE `script_texts` SET `entry`=-1599004 WHERE `npc_entry`=27975 and `entry`=-1603004; -UPDATE `script_texts` SET `entry`=-1599005 WHERE `npc_entry`=27975 and `entry`=-1603005; -UPDATE `script_texts` SET `entry`=-1599006 WHERE `npc_entry`=27975 and `entry`=-1603006; --- Krystallus -UPDATE `script_texts` SET `entry`=-1599007 WHERE `npc_entry`=27977 and `entry`=-1603007; -UPDATE `script_texts` SET `entry`=-1599008 WHERE `npc_entry`=27977 and `entry`=-1603008; -UPDATE `script_texts` SET `entry`=-1599009 WHERE `npc_entry`=27977 and `entry`=-1603009; -UPDATE `script_texts` SET `entry`=-1599010 WHERE `npc_entry`=27977 and `entry`=-1603010; --- Sjonnir -UPDATE `script_texts` SET `entry`=-1599011,`sound`=14180 WHERE `npc_entry`=27978 and `entry`=-1603011; -UPDATE `script_texts` SET `entry`=-1599012,`sound`=14182 WHERE `npc_entry`=27978 and `entry`=-1603012; -UPDATE `script_texts` SET `entry`=-1599013,`sound`=14183 WHERE `npc_entry`=27978 and `entry`=-1603013; -UPDATE `script_texts` SET `entry`=-1599015,`sound`=14184 WHERE `npc_entry`=27978 and `entry`=-1603015; - --- Brann and Tribunal Event -UPDATE `script_texts` SET `entry`=-1599016 WHERE `npc_entry`=28070 and `entry`=-1603016; -UPDATE `script_texts` SET `entry`=-1599017 WHERE `npc_entry`=28070 and `entry`=-1603017; -UPDATE `script_texts` SET `entry`=-1599018 WHERE `npc_entry`=28070 and `entry`=-1603018; -UPDATE `script_texts` SET `entry`=-1599019 WHERE `npc_entry`=28070 and `entry`=-1603019; -UPDATE `script_texts` SET `entry`=-1599020 WHERE `npc_entry`=28070 and `entry`=-1603020; -UPDATE `script_texts` SET `entry`=-1599021 WHERE `npc_entry`=28070 and `entry`=-1603021; -UPDATE `script_texts` SET `entry`=-1599022 WHERE `npc_entry`=28070 and `entry`=-1603022; -UPDATE `script_texts` SET `entry`=-1599023 WHERE `npc_entry`=28070 and `entry`=-1603023; -UPDATE `script_texts` SET `entry`=-1599024 WHERE `npc_entry`=28070 and `entry`=-1603024; -UPDATE `script_texts` SET `entry`=-1599025 WHERE `npc_entry`=28070 and `entry`=-1603025; -UPDATE `script_texts` SET `entry`=-1599026 WHERE `npc_entry`=28070 and `entry`=-1603026; -UPDATE `script_texts` SET `entry`=-1599027 WHERE `npc_entry`=28070 and `entry`=-1603027; -UPDATE `script_texts` SET `entry`=-1599028 WHERE `npc_entry`=28070 and `entry`=-1603028; -UPDATE `script_texts` SET `entry`=-1599029 WHERE `npc_entry`=28070 and `entry`=-1603029; -UPDATE `script_texts` SET `entry`=-1599030 WHERE `npc_entry`=28070 and `entry`=-1603030; -UPDATE `script_texts` SET `entry`=-1599031 WHERE `npc_entry`=28070 and `entry`=-1603031; -UPDATE `script_texts` SET `entry`=-1599032 WHERE `npc_entry`=28070 and `entry`=-1603032; -UPDATE `script_texts` SET `entry`=-1599033 WHERE `npc_entry`=28070 and `entry`=-1603033; -UPDATE `script_texts` SET `entry`=-1599034 WHERE `npc_entry`=28070 and `entry`=-1603034; -UPDATE `script_texts` SET `entry`=-1599035 WHERE `npc_entry`=28070 and `entry`=-1603035; -UPDATE `script_texts` SET `entry`=-1599036 WHERE `npc_entry`=28070 and `entry`=-1603036; -UPDATE `script_texts` SET `entry`=-1599037 WHERE `npc_entry`=28070 and `entry`=-1603037; -UPDATE `script_texts` SET `entry`=-1599038 WHERE `npc_entry`=28070 and `entry`=-1603038; -UPDATE `script_texts` SET `entry`=-1599039 WHERE `npc_entry`=28070 and `entry`=-1603039; -UPDATE `script_texts` SET `entry`=-1599040 WHERE `npc_entry`=28070 and `entry`=-1603040; -UPDATE `script_texts` SET `entry`=-1599041 WHERE `npc_entry`=28070 and `entry`=-1603041; -UPDATE `script_texts` SET `entry`=-1599042 WHERE `npc_entry`=28070 and `entry`=-1603042; -UPDATE `script_texts` SET `entry`=-1599043 WHERE `npc_entry`=28070 and `entry`=-1603043; -UPDATE `script_texts` SET `entry`=-1599044 WHERE `npc_entry`=28070 and `entry`=-1603044; -UPDATE `script_texts` SET `entry`=-1599045 WHERE `npc_entry`=28070 and `entry`=-1603045; -UPDATE `script_texts` SET `entry`=-1599046 WHERE `npc_entry`=28070 and `entry`=-1603046; -UPDATE `script_texts` SET `entry`=-1599047 WHERE `npc_entry`=28070 and `entry`=-1603047; -UPDATE `script_texts` SET `entry`=-1599048 WHERE `npc_entry`=28070 and `entry`=-1603048; -UPDATE `script_texts` SET `entry`=-1599049 WHERE `npc_entry`=28070 and `entry`=-1603049; -UPDATE `script_texts` SET `entry`=-1599050 WHERE `npc_entry`=28070 and `entry`=-1603050; -UPDATE `script_texts` SET `entry`=-1599051 WHERE `npc_entry`=28070 and `entry`=-1603051; -UPDATE `script_texts` SET `entry`=-1599052 WHERE `npc_entry`=28070 and `entry`=-1603052; -UPDATE `script_texts` SET `entry`=-1599053 WHERE `npc_entry`=28070 and `entry`=-1603053; -UPDATE `script_texts` SET `entry`=-1599054 WHERE `npc_entry`=28070 and `entry`=-1603054; -UPDATE `script_texts` SET `entry`=-1599055 WHERE `npc_entry`=28070 and `entry`=-1603055; -UPDATE `script_texts` SET `entry`=-1599056 WHERE `npc_entry`=28070 and `entry`=-1603056; -UPDATE `script_texts` SET `entry`=-1599057 WHERE `npc_entry`=28070 and `entry`=-1603057; -UPDATE `script_texts` SET `entry`=-1599058 WHERE `npc_entry`=28070 and `entry`=-1603058; -UPDATE `script_texts` SET `entry`=-1599059 WHERE `npc_entry`=28070 and `entry`=-1603059; -UPDATE `script_texts` SET `entry`=-1599060 WHERE `npc_entry`=28070 and `entry`=-1603060; -UPDATE `script_texts` SET `entry`=-1599061 WHERE `npc_entry`=28070 and `entry`=-1603061; -UPDATE `script_texts` SET `entry`=-1599062 WHERE `npc_entry`=28070 and `entry`=-1603062; -UPDATE `script_texts` SET `entry`=-1599063 WHERE `npc_entry`=28070 and `entry`=-1603063; -UPDATE `script_texts` SET `entry`=-1599064 WHERE `npc_entry`=28070 and `entry`=-1603064; -UPDATE `script_texts` SET `entry`=-1599065 WHERE `npc_entry`=28070 and `entry`=-1603065; -UPDATE `script_texts` SET `entry`=-1599066 WHERE `npc_entry`=28070 and `entry`=-1603066; -UPDATE `script_texts` SET `entry`=-1599067 WHERE `npc_entry`=28070 and `entry`=-1603067; -UPDATE `script_texts` SET `entry`=-1599068 WHERE `npc_entry`=28070 and `entry`=-1603068; diff --git a/sql/updates/7591_world_spell_dbc.sql b/sql/updates/7591_world_spell_dbc.sql deleted file mode 100644 index 33c2f0ad08a..00000000000 --- a/sql/updates/7591_world_spell_dbc.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_dbc` WHERE `Id` = 200000; -INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`,`MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`,`EffectBaseDice1`,`EffectBaseDice2`,`EffectBaseDice3`,`EffectDicePerLevel1`,`EffectDicePerLevel2`,`EffectDicePerLevel3`,`EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`,`EffectImplicitTargetB1`,`EffectImplicitTargetB2`,`EffectImplicitTargetB3`,`EffectRadiusIndex1`,`EffectRadiusIndex2`,`EffectRadiusIndex3`,`EffectApplyAuraName1`,`EffectApplyAuraName2`,`EffectApplyAuraName3`,`EffectAmplitude1`,`EffectAmplitude2`,`EffectAmplitude3`,`EffectMultipleValue1`,`EffectMultipleValue2`,`EffectMultipleValue3`,`EffectMiscValue1`,`EffectMiscValue2`,`EffectMiscValue3`,`EffectMiscValueB1`,`EffectMiscValueB2`,`EffectMiscValueB3`,`EffectTriggerSpell1`,`EffectTriggerSpell2`,`EffectTriggerSpell3`,`EffectSpellClassMaskA1`,`EffectSpellClassMaskA2`,`EffectSpellClassMaskA3`,`EffectSpellClassMaskB1`,`EffectSpellClassMaskB2`,`EffectSpellClassMaskB3`,`EffectSpellClassMaskC1`,`EffectSpellClassMaskC2`,`EffectSpellClassMaskC3`,`MaxTargetLevel`,`SpellFamilyName`,`SpellFamilyFlags1`,`SpellFamilyFlags2`,`SpellFamilyFlags3`,`MaxAffectedTargets`,`DmgClass`,`PreventionType`,`DmgMultiplier1`,`DmgMultiplier2`,`DmgMultiplier3`,`AreaGroupId`,`SchoolMask`,`Comment`) VALUES -(200000,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,8,1,0,-1,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,0,0,0,0,1,1,1,0,1,'Drain Soul increased damage - serverside spell'); diff --git a/sql/updates/7597_world_scriptname.sql b/sql/updates/7597_world_scriptname.sql deleted file mode 100644 index 0c7e42939f4..00000000000 --- a/sql/updates/7597_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`= 'npc_argent_tournament_post' WHERE `entry`=35473; diff --git a/sql/updates/7598_world_scriptname.sql b/sql/updates/7598_world_scriptname.sql deleted file mode 100644 index 8c2d0ea32cc..00000000000 --- a/sql/updates/7598_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`= 'npc_tallhorn_stag' WHERE `entry`=26363; -UPDATE `creature_template` SET `ScriptName`= 'npc_amberpine_woodsman' WHERE `entry`=27293; diff --git a/sql/updates/7604_characters_item_refund_instance.sql b/sql/updates/7604_characters_item_refund_instance.sql deleted file mode 100644 index de7ce6d69a5..00000000000 --- a/sql/updates/7604_characters_item_refund_instance.sql +++ /dev/null @@ -1,19 +0,0 @@ -DROP TABLE IF EXISTS `item_refund_instance`; -CREATE TABLE `item_refund_instance` ( -`item_guid` int(11) unsigned NOT NULL COMMENT 'Item GUID', -`player_guid` int(11) unsigned NOT NULL COMMENT 'Player GUID', -`paidMoney` int(11) unsigned NOT NULL DEFAULT '0', -`paidHonor` int(11) unsigned NOT NULL DEFAULT '0', -`paidArena` int(11) unsigned NOT NULL DEFAULT '0', -`paidItem_1` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'item_template.entry', -`paidItemCount_1` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_2` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_2` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_3` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_3` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_4` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_4` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItem_5` mediumint(6) unsigned NOT NULL DEFAULT '0', -`paidItemCount_5` mediumint(6) unsigned NOT NULL DEFAULT '0', -PRIMARY KEY (`item_guid`, `player_guid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 diff --git a/sql/updates/7609_world_spell_proc_event.sql b/sql/updates/7609_world_spell_proc_event.sql deleted file mode 100644 index 2111d9b3f85..00000000000 --- a/sql/updates/7609_world_spell_proc_event.sql +++ /dev/null @@ -1,4 +0,0 @@ -DELETE FROM `spell_proc_event` WHERE `entry` IN (42370); -INSERT INTO `spell_proc_event` -(`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) -VALUES ( 42370, 0x00, 11, 0x00000080, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0); -- Merciless Totem of the Third Wind diff --git a/sql/updates/7610_world_scriptname.sql b/sql/updates/7610_world_scriptname.sql deleted file mode 100644 index 89b005f00e0..00000000000 --- a/sql/updates/7610_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`= 'npc_seaforium_depth_charge' WHERE `entry`=25401; diff --git a/sql/updates/7611_characters_item_refund_instance.sql b/sql/updates/7611_characters_item_refund_instance.sql deleted file mode 100644 index cd859a47ee0..00000000000 --- a/sql/updates/7611_characters_item_refund_instance.sql +++ /dev/null @@ -1,14 +0,0 @@ -ALTER TABLE `item_refund_instance` -DROP COLUMN `paidHonor`, -DROP COLUMN `paidArena`, -DROP COLUMN `paidItem_1`, -DROP COLUMN `paidItemCount_1`, -DROP COLUMN `paidItem_2`, -DROP COLUMN `paidItemCount_2`, -DROP COLUMN `paidItem_3`, -DROP COLUMN `paidItemCount_3`, -DROP COLUMN `paidItem_4`, -DROP COLUMN `paidItemCount_4`, -DROP COLUMN `paidItem_5`, -DROP COLUMN `paidItemCount_5`, -ADD COLUMN `paidExtendedCost` int(11) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/7625_world_scriptname.sql b/sql/updates/7625_world_scriptname.sql deleted file mode 100644 index ac0de6986ac..00000000000 --- a/sql/updates/7625_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `instance_template` SET `script`='instance_zulfarrak' WHERE `map`=209; diff --git a/sql/updates/7646_world_scriptname.sql b/sql/updates/7646_world_scriptname.sql deleted file mode 100644 index f9dbb6d2972..00000000000 --- a/sql/updates/7646_world_scriptname.sql +++ /dev/null @@ -1,3 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_drakos' WHERE `entry`=27654; -UPDATE `creature_template` SET `ScriptName`='npc_oculus_drake' WHERE `entry` IN (27657,27658,27659); -UPDATE `instance_template` SET `script`='instance_oculus' WHERE `map`=578; diff --git a/sql/updates/7655_world_script_texts.sql b/sql/updates/7655_world_script_texts.sql deleted file mode 100644 index a7213b1e518..00000000000 --- a/sql/updates/7655_world_script_texts.sql +++ /dev/null @@ -1,233 +0,0 @@ -DELETE FROM `script_texts` WHERE `entry` BETWEEN -1603999 AND -1603000; -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES --- Algalon -(32871,-1603000,'Your actions are illogical. All possible results for this encounter have been calculated. The Pantheon will receive the Observer''s message regardless of outcome.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15386,1,0,0,'algalon SAY_AGGRO'), -(32871,-1603001,'Loss of life, unavoidable.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15387,1,0,0,'algalon SAY_SLAY_1'), -(32871,-1603002,'I do what I must.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15388,1,0,0,'algalon SAY_SLAY_2'), -(32871,-1603003,'See your world through my eyes: A universe so vast as to be immeasurable - incomprehensible even to your greatest minds.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15390,1,0,0,'algalon SAY_ENGADED_FOR_FIRTS_TIME'), -(32871,-1603004,'Beware!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15391,1,0,0,'algalon SAY_PHASE_2'), -(32871,-1603005,'The stars come to my aid.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15392,1,0,0,'algalon SAY_SUMMON_COLLAPSING_STAR'), -(32871,-1603006,'I have seen worlds bathed in the Makers'' flames. Their denizens fading without so much as a whimper. Entire planetary systems born and raised in the time that it takes your mortal hearts to beat once. Yet all throughout, my own heart, devoid of emotion... of empathy. I... have... felt... NOTHING! A million, million lives wasted. Had they all held within them your tenacity? Had they all loved life as you do?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15393,1,0,0,'algalon SAY_DEATH_1'), -(32871,-1603007,'Perhaps it is your imperfection that which grants you free will. That allows you to persevere against cosmically calculated odds. You prevailed where the Titans'' own perfect creations have failed.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15401,1,0,0,'algalon SAY_DEATH_2'), -(32871,-1603008,'I''ve rearranged the reply code. Your planet will be spared. I cannot be certain of my own calculations anymore.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15402,1,0,0,'algalon SAY_DEATH_3'), -(32871,-1603009,'I lack the strength to transmit the signal. You must hurry. Find a place of power close to the skies.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15403,1,0,0,'algalon SAY_DEATH_4'), -(32871,-1603010,'Do not worry about my fate $N. If the signal is not transmitted in time re-origination will proceed regardless. Save. Your. World.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15404,1,0,0,'algalon SAY_DEATH_5'), -(32871,-1603011,'You are... out of time.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15394,1,0,0,'algalon SAY_BERSERK'), -(32871,-1603012,'Witness the fury of cosmos!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15396,1,0,0,'algalon SAY_BIGBANG_1'), -(32871,-1603013,'Behold the tools of creation!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15397,1,0,0,'algalon SAY_BIGBANG_2'), -(32871,-1603014,'Analysis complete. There is partial corruption in the planet''s life-support systems as well as complete corruption in most of the planet''s defense mechanisms.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15398,1,0,0,'algalon SAY_TIMER_1'), -(32871,-1603015,'Begin uplink: Reply Code: ''Omega''. Planetary re-origination requested.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15399,1,0,0,'algalon SAY_TIMER_2'), -(32871,-1603016,'Farewell, mortals. Your bravery is admirable, for such flawed creatures.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15400,1,0,0,'algalon SAY_TIMER_3'), -(32871,-1603017,'Trans-location complete. Commencing planetary analysis of Azeroth.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15405,1,0,0,'algalon SAY_SUMMON_1'), -(32871,-1603018,'Stand back, mortals. I am not here to fight you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15406,1,0,0,'algalon SAY_SUMMON_2'), -(32871,-1603019,'It is in the universe''s best interest to re-originate this planet should my analysis find systemic corruption. Do not interfere.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15407,1,0,0,'algalon SAY_SUMMON_3'), - --- Assembly of Iron - Stellbreaker -(32867,-1603020,'You will not defeat the Assembly of Iron so easily, invaders!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15674,1,0,0,'steelbreaker SAY_AGGRO'), -(32867,-1603021,'So fragile and weak!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15675,1,0,0,'steelbreaker SAY_SLAY_1'), -(32867,-1603022,'Flesh... such a hindrance.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15676,1,0,0,'steelbreaker SAY_SLAY_2'), -(32867,-1603023,'You seek the secrets of Ulduar? Then take them!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15677,1,0,0,'steelbreaker SAY_POWER'), -(32867,-1603024,'My death only serves to hasten your demise.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15678,1,0,0,'steelbreaker SAY_DEATH_1'), -(32867,-1603025,'Impossible!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15679,1,0,0,'steelbreaker SAY_DEATH_2'), -(32867,-1603026,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15680,1,0,0,'steelbreaker SAY_BERSERK'), - --- Assembly of Iron - Runemaster Molgeim -(32927,-1603030,'Nothing short of total decimation will suffice.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15657,1,0,0,'Molgeim SAY_AGGRO'), -(32927,-1603031,'The world suffers yet another insignificant loss.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15658,1,0,0,'Molgeim SAY_SLAY_1'), -(32927,-1603032,'Death is the price of your arrogance.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15659,1,0,0,'Molgeim SAY_SLAY_2'), -(32927,-1603033,'Decipher this!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15660,1,0,0,'Molgeim SAY_RUNE_DEATH'), -(32927,-1603034,'Face the lightning surge!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15661,1,0,0,'Molgeim SAY_SUMMON'), -(32927,-1603035,'The legacy of storms shall not be undone.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15662,1,0,0,'Molgeim SAY_DEATH_1'), -(32927,-1603036,'What have you gained from my defeat? You are no less doomed, mortals!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15663,1,0,0,'Molgeim SAY_DEATH_2'), -(32927,-1603037,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15664,1,0,0,'Molgeim SAY_BERSERK'), - --- Assembly of Iron - Stormcaller Brundir -(32857,-1603040,'Whether the world''s greatest gnats or the world''s greatest heroes, you''re still only mortal!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15684,1,0,0,'Brundir SAY_AGGRO'), -(32857,-1603041,'A merciful kill!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15685,1,0,0,'Brundir SAY_SLAY_1'), -(32857,-1603042,'HAH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15686,1,0,0,'Brundir SAY_SLAY_2'), -(32857,-1603043,'Stand still and stare into the light!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15687,1,0,0,'Brundir SAY_SPECIAL'), -(32857,-1603044,'Let the storm clouds rise and rain down death from above!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15688,1,0,0,'Brundir SAY_FLIGHT'), -(32857,-1603045,'The power of the storm lives on...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15689,1,0,0,'Brundir SAY_DEATH_1'), -(32857,-1603046,'You rush headlong into the maw of madness!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15690,1,0,0,'Brundir SAY_DEATH_2'), -(32857,-1603047,'This meeting of the Assembly of Iron is adjourned!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15691,1,0,0,'Brundir SAY_BERSERK'), - --- Auriaya -(33515,-1603050,'Some things are better left alone!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15473,1,0,0,'Auriaya SAY_AGGRO'), -(33515,-1603051,'The secret dies with you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15474,1,0,0,'Auriaya SAY_SLAY_1'), -(33515,-1603052,'There is no escape!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15475,1,0,0,'Auriaya SAY_SLAY_2'), -(33515,-1603053,'Auriaya screams in agony.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,15476,'Auriaya SAY_DEATH'), -(33515,-1603054,'You waste my time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15477,1,0,0,'Auriaya SAY_BERSERK'), - --- Flame Leviathan -(33113,-1603060,'Hostile entities detected. Threat assessment protocol active. Primary target engaged. Time minus thirty seconds to re-evaluation.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15506,1,0,0,'Flame Leviathan SAY_AGGRO'), -(33113,-1603061,'Threat assessment routine modified. Current target threat level: zero. Acquiring new target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15521,1,0,0,'Flame Leviathan SAY_SLAY'), -(33113,-1603062,'Total systems failure. Defense protocols breached. Leviathan Unit shutting down.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15520,1,0,0,'Flame Leviathan SAY_DEATH'), -(33113,-1603063,'Threat re-evaluated. Target assessment complete. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15507,1,0,0,'Flame Leviathan SAY_TARGET_1'), -(33113,-1603064,'Pursuit objective modified. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15508,1,0,0,'Flame Leviathan SAY_TARGET_2'), -(33113,-1603065,'Hostile entity stratagem predicted. Rerouting battle function. Changing course.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15509,1,0,0,'Flame Leviathan SAY_TARGET_3'), -(33113,-1603066,'Orbital countermeasures enabled.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15510,1,0,0,'Flame Leviathan SAY_HARDMODE'), -(33113,-1603067,'Alert! Static defense system failure. Orbital countermeasures disabled.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15511,1,0,0,'Flame Leviathan SAY_TOWER_NONE'), -(33113,-1603068,'''Hodir''s Fury'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15512,1,0,0,'Flame Leviathan SAY_TOWER_FROST'), -(33113,-1603069,'''Mimiron''s Inferno'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15513,1,0,0,'Flame Leviathan SAY_TOWER_FLAME'), -(33113,-1603070,'''Freya''s Ward'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15514,1,0,0,'Flame Leviathan SAY_TOWER_NATURE'), -(33113,-1603071,'''Thorim''s Hammer'' online. Acquiring target.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15515,1,0,0,'Flame Leviathan SAY_TOWER_STORM'), -(33113,-1603072,'Unauthorized entity attempting circuit overload. Activating anti-personnel countermeasures.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15516,1,0,0,'Flame Leviathan SAY_PLAYER_RIDING'), -(33113,-1603073,'System malfunction. Diverting power to support systems.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15517,1,0,0,'Flame Leviathan SAY_OVERLOAD_1'), -(33113,-1603074,'Combat matrix overload. Powering do-o-o-own...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15518,1,0,0,'Flame Leviathan SAY_OVERLOAD_2'), -(33113,-1603075,'System restart required. Deactivating weapon systems.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15519,1,0,0,'Flame Leviathan SAY_OVERLOAD_3'), --- reserve 1603076-1603179 to implement other texts related to flame leviathan encounter - --- Freya -(32906,-1603180,'The Conservatory must be protected!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15526,1,0,0,'Freya SAY_AGGRO'), -(32906,-1603181,'Elders, grant me your strength!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15527,1,0,0,'Freya SAY_AGGRO_WITH_ELDER'), -(32906,-1603182,'Forgive me.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15529,1,0,0,'Freya SAY_SLAY_1'), -(32906,-1603183,'From your death springs life anew!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15530,1,0,0,'Freya SAY_SLAY_2'), -(32906,-1603184,'His hold on me dissipates. I can see clearly once more. Thank you, heroes.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15531,1,0,0,'Freya SAY_DEATH'), -(32906,-1603185,'You have strayed too far, wasted too much time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15532,1,0,0,'Freya SAY_BERSERK'), -(32906,-1603186,'Eonar, your servant requires aid!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15528,1,0,0,'Freya SAY_SUMMON_CONSERVATOR'), -(32906,-1603187,'Children, assist me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15331,1,0,0,'Freya SAY_SUMMON_TRIO'), -(32906,-1603188,'The swarm of the elements shall overtake you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15534,1,0,0,'Freya SAY_SUMMON_LASHERS'), -(32906,-1603189,'Eonar, your servant calls for your blessing!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15535,1,0,0,'Freya SAY_YS_HELP'), - --- Elder Brightleaf -(32915,-1603190,'Matron, the Conservatory has been breached!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15483,1,0,0,'Elder Brightleaf SAY_AGGRO'), -(32915,-1603191,'Fertilizer.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15485,1,0,0,'Elder Brightleaf SAY_SLAY_1'), -(32915,-1603192,'Your corpse will nourish the soil!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15486,1,0,0,'Elder Brightleaf SAY_SLAY_2'), -(32915,-1603193,'Matron, one has fallen!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15487,1,0,0,'Elder Brightleaf SAY_DEATH'), - --- Elder Ironbranch -(32913,-1603194,'Mortals have no place here!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15493,1,0,0,'Elder Ironbranch SAY_AGGRO'), -(32913,-1603195,'I return you whence you came!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15494,1,0,0,'Elder Ironbranch SAY_SLAY_1'), -(32913,-1603196,'BEGONE!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15495,1,0,0,'Elder Ironbranch SAY_SLAY_2'), -(32913,-1603197,'Freya! They come for you.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15496,1,0,0,'Elder Ironbranch SAY_DEATH'), - --- Elder Stonebark -(32914,-1603198,'This place will serve as your graveyard.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15500,1,0,0,'Elder Stonebark SAY_AGGRO'), -(32914,-1603199,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15501,1,0,0,'Elder Stonebark SAY_SLAY_1'), -(32914,-1603200,'Such a waste.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15502,1,0,0,'Elder Stonebark SAY_SLAY_2'), -(32914,-1603201,'Matron, flee! They are ruthless....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15503,1,0,0,'Elder Stonebark SAY_DEATH'), - --- Hodir -(32845,-1603210,'You will suffer for this trespass!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15552,1,0,0,'Hodir SAY_AGGRO'), -(32845,-1603211,'Tragic. To come so far, only to fail.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15553,1,0,0,'Hodir SAY_SLAY_1'), -(32845,-1603212,'Welcome to the endless winter.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15554,1,0,0,'Hodir SAY_SLAY_2'), -(32845,-1603213,'Winds of the north consume you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15555,1,0,0,'Hodir SAY_FLASH_FREEZE'), -(32845,-1603214,'Hodir roars furious.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15556,6,0,0,'Hodir SAY_STALACTITE'), -(32845,-1603215,'I... I am released from his grasp... at last.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15557,1,0,0,'Hodir SAY_DEATH'), -(32845,-1603216,'Enough! This ends now!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15558,1,0,0,'Hodir SAY_BERSERK'), -(32845,-1603217,'The veil of winter will protect you, champions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15559,1,0,0,'Hodir SAY_YS_HELP'), -(32845,-1603218,'Hodir shatters the Rare Cache of Hodir!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,6,0,0,'Hodir SAY_HARD_MODE_MISSED'), - --- Ignis -(33118,-1603220,'Insolent whelps! Your blood will temper the weapons used to reclaim this world!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15564,1,0,0,'Ignis SAY_AGGRO'), -(33118,-1603221,'More scraps for the scrapheap!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15569,1,0,0,'Ignis SAY_SLAY_1'), -(33118,-1603222,'Your bones will serve as kindling!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15570,1,0,0,'Ignis SAY_SLAY_2'), -(33118,-1603223,'I. Have. Failed.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15572,1,0,0,'Ignis SAY_DEATH'), -(33118,-1603224,'Arise, soldiers of the Iron Crucible! The Makers'' will be done!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15565,1,0,0,'Ignis SAY_SUMMON'), -(33118,-1603225,'I will burn away your impurities!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15566,1,0,0,'Ignis SAY_SLAG_POT'), -(33118,-1603226,'Let the inferno consume you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15567,1,0,0,'Ignis SAY_SCORCH_1'), -(33118,-1603227,'BURN! Burn in the makers fire!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15568,1,0,0,'Ignis SAY_SCORCH_2'), -(33118,-1603228,'Let it be finished!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15571,1,0,0,'Ignis SAY_BERSERK'), - --- Kologarn -(32930,-1603230,'None shall pass!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15586,1,0,0,'Kologarn SAY_AGGRO'), -(32930,-1603231,'KOL-THARISH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15587,1,0,0,'Kologarn SAY_SLAY_1'), -(32930,-1603232,'YOU FAIL!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15588,1,0,0,'Kologarn SAY_SLAY_2'), -(32930,-1603233,'Just a scratch!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15589,1,0,0,'Kologarn SAY_LEFT_ARM_GONE'), -(32930,-1603234,'Only a flesh wound!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15590,1,0,0,'Kologarn SAY_RIGHT_ARM_GONE'), -(32930,-1603235,'OBLIVION!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15591,1,0,0,'Kologarn SAY_SHOCKWAVE'), -(32930,-1603236,'I will squeeze the life from you!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15592,1,0,0,'Kologarn SAY_GRAB_PLAYER'), -(32930,-1603237,'Master, they come...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15593,1,0,0,'Kologarn SAY_DEATH'), -(32930,-1603238,'I am invincible!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15594,1,0,0,'Kologarn SAY_BERSERK'), - --- Mimiron -(33350,-1603240,'Oh, my! I wasn''t expecting company! The workshop is such a mess! How embarrassing!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15611,1,0,0,'Mimiron SAY_AGGRO'), -(33350,-1603241,'Now why would you go and do something like that? Didn''t you see the sign that said ''DO NOT PUSH THIS BUTTON!''? How will we finish testing with the self-destruct mechanism active?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15629,1,0,0,'Mimiron SAY_HARDMODE_ON'), -(33350,-1603242,'We haven''t much time, friends! You''re going to help me test out my latest and greatest creation. Now, before you change your minds, remember, that you kind of owe it to me after the mess you made with the XT-002.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15612,1,0,0,'Mimiron SAY_MKII_ACTIVATE'), -(33350,-1603243,'MEDIC!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15613,1,0,0,'Mimiron SAY_MKII_SLAY_1'), -(33350,-1603244,'I can fix that... or, maybe not! Sheesh, what a mess...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15614,1,0,0,'Mimiron SAY_MKII_SLAY_2'), -(33350,-1603245,'WONDERFUL! Positively marvelous results! Hull integrity at 98.9 percent! Barely a dent! Moving right along.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15615,1,0,0,'Mimiron SAY_MKII_DEATH'), -(33350,-1603246,'Behold the VX-001 Anti-personnel Assault Cannon! You might want to take cover.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15616,1,0,0,'Mimiron SAY_VX001_ACTIVATE'), -(33350,-1603247,'Fascinating. I think they call that a "clean kill".',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15617,1,0,0,'Mimiron SAY_VX001_SLAY_1'), -(33350,-1603248,'Note to self: Cannon highly effective against flesh.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15618,1,0,0,'Mimiron SAY_VX001_SLAY_2'), -(33350,-1603249,'Thank you, friends! Your efforts have yielded some fantastic data! Now, where did I put-- oh, there it is!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15619,1,0,0,'Mimiron SAY_VX001_DEATH'), -(33350,-1603250,'Isn''t it beautiful? I call it the magnificent aerial command unit!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15620,1,0,0,'Mimiron SAY_AERIAL_ACTIVATE'), -(33350,-1603251,'Outplayed!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15621,1,0,0,'Mimiron SAY_AERIAL_SLAY_1'), -(33350,-1603252,'You can do better than that!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15622,1,0,0,'Mimiron SAY_AERIAL_SLAY_2'), -(33350,-1603253,'Preliminary testing phase complete. Now comes the true test!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15623,1,0,0,'Mimiron SAY_AERIAL_DEATH'), -(33350,-1603254,'Gaze upon its magnificence! Bask in its glorious, um, glory! I present you... V-07-TR-0N!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15624,1,0,0,'Mimiron SAY_V07TRON_ACTIVATE'), -(33350,-1603255,'Prognosis: Negative!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15625,1,0,0,'Mimiron SAY_V07TRON_SLAY_1'), -(33350,-1603256,'You''re not going to get up from that one, friend.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15626,1,0,0,'Mimiron SAY_V07TRON_SLAY_2'), -(33350,-1603257,'It would appear that I''ve made a slight miscalculation. I allowed my mind to be corrupted by the fiend in the prison, overriding my primary directive. All systems seem to be functional now. Clear.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15627,1,0,0,'Mimiron SAY_V07TRON_DEATH'), -(33350,-1603258,'Oh, my! It would seem that we are out of time, my friends!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15628,1,0,0,'Mimiron SAY_BERSERK'), -(33350,-1603259,'Combat matrix enhanced. Behold wonderous rapidity!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15630,1,0,0,'Mimiron SAY_YS_HELP'), - --- Razorscale encounter -(33210,-1603260,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15647,1,0,0,'Exp. Commander SAY_INTRO'), -(33210,-1603261,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15648,1,0,0,'Exp. Commander SAY_GROUND'), - --- Thorim -(33413,-1603270,'Interlopers! You mortals who dare to interfere with my sport will pay... Wait--you...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15733,1,0,0,'Thorim SAY_AGGRO_1'), -(33413,-1603271,'I remember you... In the mountains... But you... what is this? Where am--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15734,1,0,0,'Thorim SAY_AGGRO_2'), -(33413,-1603272,'Behold the power of the storms and despair!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15735,1,0,0,'Thorim SAY_SPECIAL_1'), -(33413,-1603273,'Do not hold back! Destroy them!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15736,1,0,0,'Thorim SAY_SPECIAL_2'), -(33413,-1603274,'Have you begun to regret your intrusion?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15737,1,0,0,'Thorim SAY_SPECIAL_3'), -(33413,-1603275,'Impertinent whelps! You dare challenge me atop my pedestal! I will crush you myself!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15738,1,0,0,'Thorim SAY_JUMPDOWN'), -(33413,-1603276,'Can''t you at least put up a fight!?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15739,1,0,0,'Thorim SAY_SLAY_1'), -(33413,-1603277,'Pathetic!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15740,1,0,0,'Thorim SAY_SLAY_2'), -(33413,-1603278,'My patience has reached its limit!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15741,1,0,0,'Thorim SAY_BERSERK'), -(33413,-1603279,'Failures! Weaklings!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15742,1,0,0,'Thorim SAY_WIPE'), -(33413,-1603280,'Stay your arms! I yield!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15743,1,0,0,'Thorim SAY_DEATH'), -(33413,-1603281,'I feel as though I am awakening from a nightmare, but the shadows in this place yet linger.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15744,1,0,0,'Thorim SAY_END_NORMAL_1'), -(33413,-1603282,'Sif... was Sif here? Impossible--she died by my brother''s hand. A dark nightmare indeed....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15745,1,0,0,'Thorim SAY_END_NORMAL_2'), -(33413,-1603283,'I need time to reflect.... I will aid your cause if you should require it. I owe you at least that much. Farewell.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15746,1,0,0,'Thorim SAY_END_NORMAL_3'), -(33413,-1603284,'You! Fiend! You are not my beloved! Be gone!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15747,1,0,0,'Thorim SAY_END_HARD_1'), -(33413,-1603285,'Behold the hand behind all the evil that has befallen Ulduar! Left my kingdom in ruins, corrupted my brother and slain my wife!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15748,1,0,0,'Thorim SAY_END_HARD_2'), -(33413,-1603286,'And now it falls to you, champions, to avenge us all! The task before you is great, but I will lend you my aid as I am able. You must prevail!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15749,1,0,0,'Thorim SAY_END_HARD_3'), -(33413,-1603287,'Golganneth, lend me your strengh! Grant my mortal allies the power of thunder!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15750,1,0,0,'Thorim SAY_YS_HELP'), - --- General Vezax -(33271,-1603290,'Your destruction will herald a new age of suffering!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15542,1,0,0,'Vezax SAY_AGGRO'), -(33271,-1603291,'You thought to stand before the legions of death... and survive?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15543,1,0,0,'Vezax SAY_SLAY_1'), -(33271,-1603292,'Defiance... a flaw of mortality.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15544,1,0,0,'Vezax SAY_SLAY_2'), -(33271,-1603293,'The black blood of Yogg-Saron courses through me! I. AM. UNSTOPPABLE!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15545,1,0,0,'Vezax SAY_SURGE_DARKNESS'), -(33271,-1603294,'Oh, what horrors await....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15546,1,0,0,'Vezax SAY_DEATH'), -(33271,-1603295,'Your defeat was inevitable!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15547,1,0,0,'Vezax SAY_BERSERK'), -(33271,-1603296,'Behold, now! Terror, absolute!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15548,1,0,0,'Vezax SAY_HARDMODE_ON'), - --- XT002 -(33293,-1603300,'New toys? For me? I promise I won''t break them this time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15724,1,0,0,'XT002 SAY_AGGRO'), -(33293,-1603301,'So tired. I will rest for just a moment!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15725,1,0,0,'XT002 SAY_HEART_OPENED'), -(33293,-1603302,'I''m ready to play!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15726,1,0,0,'XT002 SAY_HEART_CLOSED'), -(33293,-1603303,'NO! NO! NO! NO! NO!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15727,1,0,0,'XT002 SAY_TYMPANIC_TANTRUM'), -(33293,-1603304,'I... I think I broke it.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15728,1,0,0,'XT002 SAY_SLAY_1'), -(33293,-1603305,'I guess it doesn''t bend that way.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15729,1,0,0,'XT002 SAY_SLAY_2'), -(33293,-1603306,'I''m tired of these toys. I don''t want to play anymore!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15730,1,0,0,'XT002 SAY_BERSERK'), -(33293,-1603307,'You are bad... Toys... Very... Baaaaad!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15731,1,0,0,'XT002 SAY_DEATH'), -(33293,-1603308,'Time for a new game! My old toys will fight my new toys!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15732,1,0,0,'XT002 SAY_SUMMON'), - --- Sara (YS) -(33134,-1603310,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15771,1,0,0,'Sara SAY_PREFIGHT_1'), -(33134,-1603311,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15772,1,0,0,'Sara SAY_PREFIGHT_2'), -(33134,-1603312,'The time to strike at the head of the beast will soon be upon us! Focus your anger and hatred on his minions!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15775,1,0,0,'Sara SAY_AGGRO_1'), -(33134,-1603313,'Yes! YES! Show them no mercy! Give no pause to your attacks!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15773,1,0,0,'Sara SAY_AGGRO_2'), -(33134,-1603314,'Let hatred and rage guide your blows!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15774,1,0,0,'Sara SAY_AGGRO_3'), -(33134,-1603315,'Powerless to act...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15778,1,0,0,'Sara SAY_SLAY_1'), -(33134,-1603316,'Could they have been saved?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15779,1,0,0,'Sara SAY_SLAY_2'), -(33134,-1603317,'Weak-minded fools!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15780,5,0,0,'Sara WHISP_INSANITY'), -(33134,-1603318,'Suffocate upon your own hate!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15776,1,0,0,'Sara SAY_PHASE2_1'), -(33134,-1603319,'Tremble, mortals, before the coming of the end!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15777,1,0,0,'Sara SAY_PHASE2_2'), - --- YoggSaron -(33288,-1603330,'I am the lucid dream.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15754,1,0,0,'YoggSaron SAY_PHASE2_1'), -- sound 15754 contains the 5 texts -(33288,-1603331,'The monster in your nightmares.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_2'), -(33288,-1603332,'The fiend of a thousand faces.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_3'), -(33288,-1603333,'Cower before my true form.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_4'), -(33288,-1603334,'BOW DOWN BEFORE THE GOD OF DEATH!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,'YoggSaron SAY_PHASE2_5'), -(33288,-1603335,'Look upon the true face of death and know that your end comes soon!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15755,1,0,0,'YoggSaron SAY_PHASE3'), -(33288,-1603336,'MADNESS WILL CONSUME YOU!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15756,1,0,0,'YoggSaron SAY_VISION'), -(33288,-1603337,'Hoohehehahahaha... AHAHAHAHAHAHA!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15757,1,0,0,'YoggSaron SAY_SLAY_1'), -(33288,-1603338,'Eternal suffering awaits!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15758,1,0,0,'YoggSaron SAY_SLAY_2'), -(33288,-1603339,'Your will is no longer you own...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15759,5,0,0,'YoggSaron WHISP_INSANITY_1'), -(33288,-1603340,'Destroy them minion, your master commands it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15760,5,0,0,'YoggSaron WHISP_INSANITY_2'), -(33288,-1603341,'Your fate is sealed. The end of days is finally upon you and ALL who inhabit this miserable little seedling. Uulwi ifis halahs gag erh''ongg w''ssh.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15761,1,0,0,'YoggSaron SAY_DEATH'); diff --git a/sql/updates/7655_world_scriptname.sql b/sql/updates/7655_world_scriptname.sql deleted file mode 100644 index 12bb45c4fe2..00000000000 --- a/sql/updates/7655_world_scriptname.sql +++ /dev/null @@ -1,6 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='mob_xt002_heart' WHERE `entry`=33329; -UPDATE `creature_template` SET `ScriptName`='mob_scrapbot' WHERE `entry`=33343; -UPDATE `creature_template` SET `ScriptName`='mob_pummeller' WHERE `entry`=33344; -UPDATE `creature_template` SET `ScriptName`='mob_boombot' WHERE `entry`=33346; -UPDATE `creature_template` SET `ScriptName`='mob_void_zone' WHERE `entry`=34001; -UPDATE `creature_template` SET `ScriptName`='mob_life_spark' WHERE `entry`=34004; diff --git a/sql/updates/7656_world_instance_template.sql b/sql/updates/7656_world_instance_template.sql deleted file mode 100644 index 54d50b04e3f..00000000000 --- a/sql/updates/7656_world_instance_template.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `instance_template` ADD COLUMN `allowMount` tinyint(1) NOT NULL DEFAULT '0'; - diff --git a/sql/updates/7658_world_scriptname.sql b/sql/updates/7658_world_scriptname.sql deleted file mode 100644 index 69bace778c9..00000000000 --- a/sql/updates/7658_world_scriptname.sql +++ /dev/null @@ -1,2 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_twilight_fissure' WHERE `entry`=30641; -UPDATE `creature_template` SET `ScriptName`='npc_flame_tsunami' WHERE `entry`=30616; diff --git a/sql/updates/7660_world_creature_template.sql b/sql/updates/7660_world_creature_template.sql deleted file mode 100644 index e987add88e9..00000000000 --- a/sql/updates/7660_world_creature_template.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE creature_template ADD COLUMN speed_run float NOT NULL default '1.14286' COMMENT 'Result of 8.0/7.0, most common value' AFTER speed; -UPDATE creature_template SET speed=1 WHERE speed IS NULL; -ALTER TABLE creature_template CHANGE COLUMN speed speed_walk FLOAT NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value'; diff --git a/sql/updates/7665_world_scriptname.sql b/sql/updates/7665_world_scriptname.sql deleted file mode 100644 index d049751b323..00000000000 --- a/sql/updates/7665_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_unstable_sphere' WHERE `entry`=28166; diff --git a/sql/updates/7666_world_script_texts.sql b/sql/updates/7666_world_script_texts.sql deleted file mode 100644 index ec6a760adea..00000000000 --- a/sql/updates/7666_world_script_texts.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `script_texts` WHERE `entry`=-1603187; -INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES -(32906,-1603187,'Children, assist me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15533,1,0,0,'Freya SAY_SUMMON_TRIO'); diff --git a/sql/updates/7668_world_scriptname.sql b/sql/updates/7668_world_scriptname.sql deleted file mode 100644 index 0dd91ff5785..00000000000 --- a/sql/updates/7668_world_scriptname.sql +++ /dev/null @@ -1,6 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='boss_koralon' WHERE `entry`=35013; -UPDATE `creature_template` SET `ScriptName`='mob_flame_warder' WHERE `entry`=35143; -UPDATE `creature_template` SET `ScriptName`='boss_toravon' WHERE `entry`=38433; -UPDATE `creature_template` SET `ScriptName`='mob_frost_warder' WHERE `entry`=38482; -UPDATE `creature_template` SET `ScriptName`='mob_frozen_orb_stalker' WHERE `entry`=38461; -UPDATE `creature_template` SET `ScriptName`='mob_frozen_orb' WHERE `entry`=38456; diff --git a/sql/updates/7672_world_scriptname.sql b/sql/updates/7672_world_scriptname.sql deleted file mode 100644 index b9451e75629..00000000000 --- a/sql/updates/7672_world_scriptname.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_ruins_dweller' WHERE `entry`=29920; diff --git a/sql/updates/7677_realmd_realmlist.sql b/sql/updates/7677_realmd_realmlist.sql deleted file mode 100644 index cddab25c060..00000000000 --- a/sql/updates/7677_realmd_realmlist.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `realmlist` CHANGE COLUMN `gamebuild` `gamebuild` int(11) unsigned NOT NULL default '11403'; diff --git a/sql/updates/7680_world_quest_template.sql b/sql/updates/7680_world_quest_template.sql deleted file mode 100644 index 296f2d5cdba..00000000000 --- a/sql/updates/7680_world_quest_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `quest_template` ADD COLUMN `MaxLevel` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `MinLevel`; diff --git a/sql/updates/7691_world_creature_template.sql b/sql/updates/7691_world_creature_template.sql deleted file mode 100644 index 9487f5f0e8f..00000000000 --- a/sql/updates/7691_world_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Spells for Wintergarde Gryphon -UPDATE `creature_template` SET `spell1`=48363,`spell2`=48397,`spell3`=54170 WHERE `entry`=27258; diff --git a/sql/updates/7691_world_spell_dbc.sql b/sql/updates/7691_world_spell_dbc.sql deleted file mode 100644 index 79b55b77285..00000000000 --- a/sql/updates/7691_world_spell_dbc.sql +++ /dev/null @@ -1,10 +0,0 @@ --- Add serverside spells place holders for future development -DELETE FROM `spell_dbc` WHERE `Id` IN (42876,44987,48803,68496,72958,32780,45453); -INSERT INTO `spell_dbc` (`Id`,`Comment`) VALUES -(42876, 'Quest 9275 reward serverside spell'), -(44987, 'Quest 11521 reward serverside spell'), -(48803, 'Quest 12214 reward serverside spell'), -(68496, 'Item_template serverside spell'), -(72958, 'Item_template serverside spell'), -(32780, 'Quest 10040 reward serverside spell'), -(45453, 'Quest 11587 reward serverside spell'); diff --git a/sql/updates/7694_world_creature_template.sql b/sql/updates/7694_world_creature_template.sql deleted file mode 100644 index a094f2ca9f2..00000000000 --- a/sql/updates/7694_world_creature_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `creature_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7694_world_gameobject_template.sql b/sql/updates/7694_world_gameobject_template.sql deleted file mode 100644 index 8e9e5cb59aa..00000000000 --- a/sql/updates/7694_world_gameobject_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `gameobject_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7694_world_item_template.sql b/sql/updates/7694_world_item_template.sql deleted file mode 100644 index cab268a8c68..00000000000 --- a/sql/updates/7694_world_item_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `item_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7694_world_npc_text.sql b/sql/updates/7694_world_npc_text.sql deleted file mode 100644 index adcb38b570f..00000000000 --- a/sql/updates/7694_world_npc_text.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `npc_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7694_world_page_text.sql b/sql/updates/7694_world_page_text.sql deleted file mode 100644 index ccbe66997e1..00000000000 --- a/sql/updates/7694_world_page_text.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `page_text` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7694_world_quest_template.sql b/sql/updates/7694_world_quest_template.sql deleted file mode 100644 index 1c0cb7dc47f..00000000000 --- a/sql/updates/7694_world_quest_template.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `quest_template` CHANGE COLUMN `WDBVerified` `WDBVerified` smallint(5) signed DEFAULT '1'; \ No newline at end of file diff --git a/sql/updates/7697_world_npc_trainer.sql b/sql/updates/7697_world_npc_trainer.sql deleted file mode 100644 index 0e79b01c931..00000000000 --- a/sql/updates/7697_world_npc_trainer.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `npc_trainer` MODIFY COLUMN `spell` MEDIUMINT(8) NOT NULL DEFAULT 0; - diff --git a/sql/updates/7697_world_npc_vendor.sql b/sql/updates/7697_world_npc_vendor.sql deleted file mode 100644 index e2fcff7deb1..00000000000 --- a/sql/updates/7697_world_npc_vendor.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE `npc_vendor` MODIFY COLUMN `item` MEDIUMINT(8) NOT NULL DEFAULT 0; - diff --git a/sql/updates/7701_world_spell_dbc.sql b/sql/updates/7701_world_spell_dbc.sql deleted file mode 100644 index e5bcc19a098..00000000000 --- a/sql/updates/7701_world_spell_dbc.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `spell_dbc` SET `DurationIndex` = 4, `EffectImplicitTargetA1` = 25 WHERE `Id` = 61988; -- cgit v1.2.3