From 9f66158ae552ea8195e870703f55f0a4483745d0 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Sun, 15 Sep 2019 09:23:26 +0000 Subject: TDB 335.19091 - 2019/09/15 --- sql/base/auth_database.sql | 5 +++-- sql/base/characters_database.sql | 5 +++-- sql/base/dev/world_database.sql | 3 ++- .../auth/19081_2019_09_15/2019_08_16_00_auth.sql | 2 ++ .../19081_2019_09_15/2019_08_16_00_characters.sql | 2 ++ .../world/19081_2019_09_15/2019_08_16_00_world.sql | 3 +++ .../world/19081_2019_09_15/2019_08_17_00_world.sql | 6 ++++++ .../world/19081_2019_09_15/2019_08_17_01_world.sql | 4 ++++ .../world/19081_2019_09_15/2019_08_17_02_world.sql | 3 +++ .../world/19081_2019_09_15/2019_08_18_00_world.sql | 4 ++++ .../world/19081_2019_09_15/2019_08_22_00_world.sql | 3 +++ .../world/19081_2019_09_15/2019_08_30_00_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_07_00_world.sql | 10 ++++++++++ .../world/19081_2019_09_15/2019_09_07_01_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_07_02_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_07_03_world.sql | 14 ++++++++++++++ .../world/19081_2019_09_15/2019_09_07_04_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_08_00_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_08_01_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_09_00_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_09_01_world_335.sql | 5 +++++ .../world/19081_2019_09_15/2019_09_09_02_world.sql | 18 ++++++++++++++++++ .../world/19081_2019_09_15/2019_09_10_00_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_12_01_world.sql | 2 ++ .../world/19081_2019_09_15/2019_09_12_02_world.sql | 3 +++ .../world/19081_2019_09_15/2019_09_12_03_world.sql | 2 ++ sql/updates/auth/3.3.5/2019_08_16_00_auth.sql | 2 -- sql/updates/auth/3.3.5/2019_09_15_00_auth.sql | 2 ++ .../characters/3.3.5/2019_08_16_00_characters.sql | 2 -- .../characters/3.3.5/2019_09_15_00_characters.sql | 2 ++ sql/updates/world/3.3.5/2019_08_16_00_world.sql | 3 --- sql/updates/world/3.3.5/2019_08_17_00_world.sql | 6 ------ sql/updates/world/3.3.5/2019_08_17_01_world.sql | 4 ---- sql/updates/world/3.3.5/2019_08_17_02_world.sql | 3 --- sql/updates/world/3.3.5/2019_08_18_00_world.sql | 4 ---- sql/updates/world/3.3.5/2019_08_22_00_world.sql | 3 --- sql/updates/world/3.3.5/2019_08_30_00_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_07_00_world.sql | 10 ---------- sql/updates/world/3.3.5/2019_09_07_01_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_07_02_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_07_03_world.sql | 14 -------------- sql/updates/world/3.3.5/2019_09_07_04_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_08_00_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_08_01_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_09_00_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_09_01_world_335.sql | 5 ----- sql/updates/world/3.3.5/2019_09_09_02_world.sql | 18 ------------------ sql/updates/world/3.3.5/2019_09_10_00_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_12_01_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_12_02_world.sql | 3 --- sql/updates/world/3.3.5/2019_09_12_03_world.sql | 2 -- sql/updates/world/3.3.5/2019_09_15_00_world.sql | 3 +++ 52 files changed, 112 insertions(+), 102 deletions(-) create mode 100644 sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql create mode 100644 sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql create mode 100644 sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql delete mode 100644 sql/updates/auth/3.3.5/2019_08_16_00_auth.sql create mode 100644 sql/updates/auth/3.3.5/2019_09_15_00_auth.sql delete mode 100644 sql/updates/characters/3.3.5/2019_08_16_00_characters.sql create mode 100644 sql/updates/characters/3.3.5/2019_09_15_00_characters.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_16_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_17_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_17_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_17_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_18_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_22_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_08_30_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_07_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_07_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_07_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_07_03_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_07_04_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_08_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_08_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_09_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_09_01_world_335.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_09_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_10_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_12_01_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_12_02_world.sql delete mode 100644 sql/updates/world/3.3.5/2019_09_12_03_world.sql create mode 100644 sql/updates/world/3.3.5/2019_09_15_00_world.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 61c08d40e26..8e6557fb577 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1833,7 +1833,8 @@ INSERT INTO `updates` VALUES ('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0), ('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0), ('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0), -('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0); +('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0), +('2019_09_15_00_auth.sql','2EEE632B5A365D45747B7BB25DE5239FB5B1A1BD','ARCHIVED','2019-09-15 09:21:36',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -1935,4 +1936,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-08-16 6:25:10 +-- Dump completed on 2019-09-15 9:21:37 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b786a9e588f..8e78687cb1e 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2636,7 +2636,8 @@ INSERT INTO `updates` VALUES ('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0), ('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0), ('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0), -('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0); +('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0), +('2019_09_15_00_characters.sql','75F3355AF6E9C0A2CAF5F523D87208C726C9D042','ARCHIVED','2019-09-15 09:21:36',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; @@ -2803,4 +2804,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-08-16 6:25:11 +-- Dump completed on 2019-09-15 9:21:37 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 82243763ca4..33ad1402358 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -3443,6 +3443,7 @@ CREATE TABLE `spell_proc` ( `SpellPhaseMask` int(10) unsigned NOT NULL DEFAULT '0', `HitMask` int(10) unsigned NOT NULL DEFAULT '0', `AttributesMask` int(10) unsigned NOT NULL DEFAULT '0', + `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0', `ProcsPerMinute` float NOT NULL DEFAULT '0', `Chance` float NOT NULL DEFAULT '0', `Cooldown` int(10) unsigned NOT NULL DEFAULT '0', @@ -3842,4 +3843,4 @@ CREATE TABLE `waypoints` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2019-08-16 6:25:11 +-- Dump completed on 2019-09-15 9:21:37 diff --git a/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql new file mode 100644 index 00000000000..6544c316449 --- /dev/null +++ b/sql/old/3.3.5a/auth/19081_2019_09_15/2019_08_16_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.19081 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql new file mode 100644 index 00000000000..5d9a26ec653 --- /dev/null +++ b/sql/old/3.3.5a/characters/19081_2019_09_15/2019_08_16_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.19081 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql new file mode 100644 index 00000000000..7cb4c1c9abb --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_16_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.19081 world +UPDATE `version` SET `db_version`='TDB 335.19081', `cache_id`=19081 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql new file mode 100644 index 00000000000..860c830e416 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_00_world.sql @@ -0,0 +1,6 @@ +-- Burn with fire spell_linked_spell hack +DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-19386, -24132, -24133, -27068, -49011, -49012); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_wyvern_sting'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(-19386,'spell_hun_wyvern_sting'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql new file mode 100644 index 00000000000..f9239dd8a2e --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_01_world.sql @@ -0,0 +1,4 @@ +ALTER TABLE `spell_proc` ADD `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesMask`; + +UPDATE `spell_proc` SET `DisableEffectsMask`=((`AttributesMask` >> 4) & 0x7); +UPDATE `spell_proc` SET `AttributesMask`=(`AttributesMask` & 0xF); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql new file mode 100644 index 00000000000..fa322bbb391 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_17_02_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `waypoint_data` SET `position_z`= 154.61 WHERE `id`= 1287390; +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|536870912 WHERE `entry` = 29047; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql new file mode 100644 index 00000000000..bc781184e28 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_18_00_world.sql @@ -0,0 +1,4 @@ +-- Missing 5 man normal spellid +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_stampede_charge' AND `spell_id`=55220; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(55220,'spell_gal_darah_stampede_charge'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql new file mode 100644 index 00000000000..d5b8414eaa8 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_22_00_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_clear_puncture'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(60022,'spell_gal_darah_clear_puncture'); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql new file mode 100644 index 00000000000..7f0e90367a7 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_08_30_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `unit_flags`=33554688, `speed_walk`=1.2, `speed_run`=1.71429 WHERE `entry` IN (36678,38431,38585,38586); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql new file mode 100644 index 00000000000..4b5eb530785 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_00_world.sql @@ -0,0 +1,10 @@ +-- +DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=13381; +DELETE FROM `quest_template_addon` WHERE `ID` IN (13404, 13382); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `SpecialFlags`) VALUES +(13404, 13380,1), +(13382, 13381,1); +UPDATE `quest_template_addon` SET `PrevQuestID`=13374 WHERE `id`=13376; +DELETE FROM `player_factionchange_quests` WHERE `alliance_id`=13404; +INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES +(13404, 13406); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql new file mode 100644 index 00000000000..f47fcb7d056 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `action_param1`=83 WHERE `entryorguid` IN (-32379,-32378,-32380, 12858) AND `source_type`=0 AND `id`=0; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql new file mode 100644 index 00000000000..3b100cd4b75 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_02_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_offer_reward` SET `RewardText`="They're being driven insane? Voices in their heads?$B$BVoices in your head?!$B$BI want you to clear your mind of the taint that has crept into that place, $g boy : girl;.$B$BWe'll try to get the remainder of them out of there again tomorrow when you've had a chance to rest." WHERE `ID`=13302; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql new file mode 100644 index 00000000000..cc2285867f9 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_03_world.sql @@ -0,0 +1,14 @@ +-- +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=23; +UPDATE `smart_scripts` SET `event_type`=38, `event_param1`=15, `event_param2`=15 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=27; +UPDATE `creature_text` SET `Type`=14 WHERE `CreatureID` IN (18471) AND `GroupID`=12; +DELETE FROM `creature_text` WHERE `CreatureID` IN (18471) AND `GroupID`=13; +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +(18471,13,0,"For the first time in the Ring of Blood's history, Mogor has chosen to exercise his right of battle! On this wartorn ground, $n will face Mogor, hero of the Warmaul!",14,0,100,0,0,0,15481,0,'Gurgthock'); +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=9; +UPDATE `smart_scripts` SET `event_type`=40, `event_param1`=3, `event_param2`=18069, `action_type`=45, `action_param1`=1, `action_param2`=6, `target_type`=19, `target_param1`=18471 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=10; +DELETE FROM `smart_scripts` WHERE `entryorguid`=18471 AND `source_type`=0 AND `id` IN (29,30); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(18471, 0, 29, 0, 38, 0, 100, 0, 1, 6, 0, 0, 1, 13, 2000, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Gurgthock - On Data Set 1 13 - Say Line 13"), +(18471, 0, 30, 0, 52, 0, 100, 0, 13, 18471, 0, 0, 1, 3, 0, 0, 0, 0, 0, 19, 18069, 0, 0, 0, 0, 0, 0, "Gurgthock - On text over - Say Line 3"); +UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id` IN (4,10,0,6,8); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql new file mode 100644 index 00000000000..e465b964d02 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_07_04_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=2; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql new file mode 100644 index 00000000000..613583dbd6b --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_request_items` SET `CompletionText`="Finally, you've arrived... and discretely also. Good.$b$bOur world is full of fools, $N. Even the mighty Thrall has greater flaws than most can see. He turns his back on the power needed to make this land ours completely! We're not the same people who were manipulated and used by creatures from the Nether. We are our own people. We are proud... and we are strong." WHERE `ID`=3090; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql new file mode 100644 index 00000000000..852c6588cb8 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_08_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `quest_request_items` SET `CompletionText`="Our spells of Fortify are very powerful, $N. They allow our companions to take further injury from all types of attacks and survive in situations where they would normally fall. But this is nothing when compared to our abilities to heal. There are no greater healers than a priest--do well to remember that. Your power alone can turn the tides of battle easily." WHERE `ID`=5621; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql new file mode 100644 index 00000000000..68eb8bdd2c0 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_00_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7725; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql new file mode 100644 index 00000000000..7fd1fa416d6 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_01_world_335.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `gameobject_template` WHERE `entry` IN (183278,183282); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES +(183282, 6, 0, "Infernaling Summoner Damage Trap", 1, 0, 1, 4, 29115, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019), +(183278, 6, 5752, "Infernaling Summoner", 2.5, 0, 0, 0, 33533, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql new file mode 100644 index 00000000000..595175a2f40 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_09_02_world.sql @@ -0,0 +1,18 @@ +-- +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19067,19210) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1906700,1921000) AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(19067, 0, 0, 0, 8, 0, 100, 0, 33531, 0, 0, 0, 80, 1906700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - On spell hit - Action list"), +(1906700, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.210368, "Fel Cannon: Hate - Action list - set orientation"), +(1906700, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - cast spell"), +(1906700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19067, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Credit quest"), +(1906700, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Interrupt spell"), +(1906700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Self cast spell"), +(1906700, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - set orientation"), +(19210, 0, 0, 0, 8, 0, 100, 0, 33532, 0, 0, 0, 80, 1921000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - On spell hit - Action list"), +(1921000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.737549, "Fel Cannon: Fear - Action list - set orientation"), +(1921000, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - cast spell"), +(1921000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19210, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Credit quest"), +(1921000, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Interrupt spell"), +(1921000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Self cast spell"), +(1921000, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - set orientation"); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql new file mode 100644 index 00000000000..7afa08f854e --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_10_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` =21321; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql new file mode 100644 index 00000000000..e492c6cdb5a --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_01_world.sql @@ -0,0 +1,2 @@ +-- O'Mally's Instrument Bunny (entry: 22021) +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=22021; diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql new file mode 100644 index 00000000000..805033401e7 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_02_world.sql @@ -0,0 +1,3 @@ +-- +UPDATE `creature_template` SET `unit_flags`=320 WHERE `entry` IN (37591,37606); +UPDATE `creature_template` SET `gossip_menu_id`=10923 WHERE `entry` IN (37607); diff --git a/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql new file mode 100644 index 00000000000..033a7471c56 --- /dev/null +++ b/sql/old/3.3.5a/world/19081_2019_09_15/2019_09_12_03_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `unit_flags`=32832, `dynamicflags`=0 WHERE `entry` IN (37604 ,37809, 37779); diff --git a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql deleted file mode 100644 index 6544c316449..00000000000 --- a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql +++ /dev/null @@ -1,2 +0,0 @@ --- TDB 335.19081 auth -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql new file mode 100644 index 00000000000..2bca2a89a56 --- /dev/null +++ b/sql/updates/auth/3.3.5/2019_09_15_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.19091 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql b/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql deleted file mode 100644 index 5d9a26ec653..00000000000 --- a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql +++ /dev/null @@ -1,2 +0,0 @@ --- TDB 335.19081 characters -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql new file mode 100644 index 00000000000..e01645f91b0 --- /dev/null +++ b/sql/updates/characters/3.3.5/2019_09_15_00_characters.sql @@ -0,0 +1,2 @@ +-- TDB 335.19091 characters +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2019_08_16_00_world.sql b/sql/updates/world/3.3.5/2019_08_16_00_world.sql deleted file mode 100644 index 7cb4c1c9abb..00000000000 --- a/sql/updates/world/3.3.5/2019_08_16_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 335.19081 world -UPDATE `version` SET `db_version`='TDB 335.19081', `cache_id`=19081 LIMIT 1; -UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/updates/world/3.3.5/2019_08_17_00_world.sql b/sql/updates/world/3.3.5/2019_08_17_00_world.sql deleted file mode 100644 index 860c830e416..00000000000 --- a/sql/updates/world/3.3.5/2019_08_17_00_world.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Burn with fire spell_linked_spell hack -DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (-19386, -24132, -24133, -27068, -49011, -49012); - -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_hun_wyvern_sting'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(-19386,'spell_hun_wyvern_sting'); diff --git a/sql/updates/world/3.3.5/2019_08_17_01_world.sql b/sql/updates/world/3.3.5/2019_08_17_01_world.sql deleted file mode 100644 index f9239dd8a2e..00000000000 --- a/sql/updates/world/3.3.5/2019_08_17_01_world.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE `spell_proc` ADD `DisableEffectsMask` int(10) unsigned NOT NULL DEFAULT '0' AFTER `AttributesMask`; - -UPDATE `spell_proc` SET `DisableEffectsMask`=((`AttributesMask` >> 4) & 0x7); -UPDATE `spell_proc` SET `AttributesMask`=(`AttributesMask` & 0xF); diff --git a/sql/updates/world/3.3.5/2019_08_17_02_world.sql b/sql/updates/world/3.3.5/2019_08_17_02_world.sql deleted file mode 100644 index fa322bbb391..00000000000 --- a/sql/updates/world/3.3.5/2019_08_17_02_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -UPDATE `waypoint_data` SET `position_z`= 154.61 WHERE `id`= 1287390; -UPDATE `creature_template` SET `flags_extra`=`flags_extra`|536870912 WHERE `entry` = 29047; diff --git a/sql/updates/world/3.3.5/2019_08_18_00_world.sql b/sql/updates/world/3.3.5/2019_08_18_00_world.sql deleted file mode 100644 index bc781184e28..00000000000 --- a/sql/updates/world/3.3.5/2019_08_18_00_world.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Missing 5 man normal spellid -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_stampede_charge' AND `spell_id`=55220; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(55220,'spell_gal_darah_stampede_charge'); diff --git a/sql/updates/world/3.3.5/2019_08_22_00_world.sql b/sql/updates/world/3.3.5/2019_08_22_00_world.sql deleted file mode 100644 index d5b8414eaa8..00000000000 --- a/sql/updates/world/3.3.5/2019_08_22_00_world.sql +++ /dev/null @@ -1,3 +0,0 @@ -DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gal_darah_clear_puncture'; -INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES -(60022,'spell_gal_darah_clear_puncture'); diff --git a/sql/updates/world/3.3.5/2019_08_30_00_world.sql b/sql/updates/world/3.3.5/2019_08_30_00_world.sql deleted file mode 100644 index 7f0e90367a7..00000000000 --- a/sql/updates/world/3.3.5/2019_08_30_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template` SET `unit_flags`=33554688, `speed_walk`=1.2, `speed_run`=1.71429 WHERE `entry` IN (36678,38431,38585,38586); diff --git a/sql/updates/world/3.3.5/2019_09_07_00_world.sql b/sql/updates/world/3.3.5/2019_09_07_00_world.sql deleted file mode 100644 index 4b5eb530785..00000000000 --- a/sql/updates/world/3.3.5/2019_09_07_00_world.sql +++ /dev/null @@ -1,10 +0,0 @@ --- -DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=13381; -DELETE FROM `quest_template_addon` WHERE `ID` IN (13404, 13382); -INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`, `SpecialFlags`) VALUES -(13404, 13380,1), -(13382, 13381,1); -UPDATE `quest_template_addon` SET `PrevQuestID`=13374 WHERE `id`=13376; -DELETE FROM `player_factionchange_quests` WHERE `alliance_id`=13404; -INSERT INTO `player_factionchange_quests` (`alliance_id`, `horde_id`) VALUES -(13404, 13406); diff --git a/sql/updates/world/3.3.5/2019_09_07_01_world.sql b/sql/updates/world/3.3.5/2019_09_07_01_world.sql deleted file mode 100644 index f47fcb7d056..00000000000 --- a/sql/updates/world/3.3.5/2019_09_07_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `smart_scripts` SET `action_param1`=83 WHERE `entryorguid` IN (-32379,-32378,-32380, 12858) AND `source_type`=0 AND `id`=0; diff --git a/sql/updates/world/3.3.5/2019_09_07_02_world.sql b/sql/updates/world/3.3.5/2019_09_07_02_world.sql deleted file mode 100644 index 3b100cd4b75..00000000000 --- a/sql/updates/world/3.3.5/2019_09_07_02_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `quest_offer_reward` SET `RewardText`="They're being driven insane? Voices in their heads?$B$BVoices in your head?!$B$BI want you to clear your mind of the taint that has crept into that place, $g boy : girl;.$B$BWe'll try to get the remainder of them out of there again tomorrow when you've had a chance to rest." WHERE `ID`=13302; diff --git a/sql/updates/world/3.3.5/2019_09_07_03_world.sql b/sql/updates/world/3.3.5/2019_09_07_03_world.sql deleted file mode 100644 index cc2285867f9..00000000000 --- a/sql/updates/world/3.3.5/2019_09_07_03_world.sql +++ /dev/null @@ -1,14 +0,0 @@ --- -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=23; -UPDATE `smart_scripts` SET `event_type`=38, `event_param1`=15, `event_param2`=15 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=27; -UPDATE `creature_text` SET `Type`=14 WHERE `CreatureID` IN (18471) AND `GroupID`=12; -DELETE FROM `creature_text` WHERE `CreatureID` IN (18471) AND `GroupID`=13; -INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES -(18471,13,0,"For the first time in the Ring of Blood's history, Mogor has chosen to exercise his right of battle! On this wartorn ground, $n will face Mogor, hero of the Warmaul!",14,0,100,0,0,0,15481,0,'Gurgthock'); -UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=9; -UPDATE `smart_scripts` SET `event_type`=40, `event_param1`=3, `event_param2`=18069, `action_type`=45, `action_param1`=1, `action_param2`=6, `target_type`=19, `target_param1`=18471 WHERE `entryorguid` IN (18069) AND `source_type`=0 AND `id`=10; -DELETE FROM `smart_scripts` WHERE `entryorguid`=18471 AND `source_type`=0 AND `id` IN (29,30); -INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES -(18471, 0, 29, 0, 38, 0, 100, 0, 1, 6, 0, 0, 1, 13, 2000, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, "Gurgthock - On Data Set 1 13 - Say Line 13"), -(18471, 0, 30, 0, 52, 0, 100, 0, 13, 18471, 0, 0, 1, 3, 0, 0, 0, 0, 0, 19, 18069, 0, 0, 0, 0, 0, 0, "Gurgthock - On text over - Say Line 3"); -UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id` IN (4,10,0,6,8); diff --git a/sql/updates/world/3.3.5/2019_09_07_04_world.sql b/sql/updates/world/3.3.5/2019_09_07_04_world.sql deleted file mode 100644 index e465b964d02..00000000000 --- a/sql/updates/world/3.3.5/2019_09_07_04_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `smart_scripts` SET `target_type`=7, `target_param1`=0 WHERE `entryorguid` IN (18471) AND `source_type`=0 AND `id`=2; diff --git a/sql/updates/world/3.3.5/2019_09_08_00_world.sql b/sql/updates/world/3.3.5/2019_09_08_00_world.sql deleted file mode 100644 index 613583dbd6b..00000000000 --- a/sql/updates/world/3.3.5/2019_09_08_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `quest_request_items` SET `CompletionText`="Finally, you've arrived... and discretely also. Good.$b$bOur world is full of fools, $N. Even the mighty Thrall has greater flaws than most can see. He turns his back on the power needed to make this land ours completely! We're not the same people who were manipulated and used by creatures from the Nether. We are our own people. We are proud... and we are strong." WHERE `ID`=3090; diff --git a/sql/updates/world/3.3.5/2019_09_08_01_world.sql b/sql/updates/world/3.3.5/2019_09_08_01_world.sql deleted file mode 100644 index 852c6588cb8..00000000000 --- a/sql/updates/world/3.3.5/2019_09_08_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `quest_request_items` SET `CompletionText`="Our spells of Fortify are very powerful, $N. They allow our companions to take further injury from all types of attacks and survive in situations where they would normally fall. But this is nothing when compared to our abilities to heal. There are no greater healers than a priest--do well to remember that. Your power alone can turn the tides of battle easily." WHERE `ID`=5621; diff --git a/sql/updates/world/3.3.5/2019_09_09_00_world.sql b/sql/updates/world/3.3.5/2019_09_09_00_world.sql deleted file mode 100644 index 68eb8bdd2c0..00000000000 --- a/sql/updates/world/3.3.5/2019_09_09_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=7725; diff --git a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql b/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql deleted file mode 100644 index 7fd1fa416d6..00000000000 --- a/sql/updates/world/3.3.5/2019_09_09_01_world_335.sql +++ /dev/null @@ -1,5 +0,0 @@ --- -DELETE FROM `gameobject_template` WHERE `entry` IN (183278,183282); -INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `AIName`, `ScriptName`, `VerifiedBuild`) VALUES -(183282, 6, 0, "Infernaling Summoner Damage Trap", 1, 0, 1, 4, 29115, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019), -(183278, 6, 5752, "Infernaling Summoner", 2.5, 0, 0, 0, 33533, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", "", -18019); diff --git a/sql/updates/world/3.3.5/2019_09_09_02_world.sql b/sql/updates/world/3.3.5/2019_09_09_02_world.sql deleted file mode 100644 index 595175a2f40..00000000000 --- a/sql/updates/world/3.3.5/2019_09_09_02_world.sql +++ /dev/null @@ -1,18 +0,0 @@ --- -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (19067,19210) AND `source_type`=0; -DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1906700,1921000) AND `source_type`=9; -INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES -(19067, 0, 0, 0, 8, 0, 100, 0, 33531, 0, 0, 0, 80, 1906700, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - On spell hit - Action list"), -(1906700, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.210368, "Fel Cannon: Hate - Action list - set orientation"), -(1906700, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - cast spell"), -(1906700, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19067, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Credit quest"), -(1906700, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Interrupt spell"), -(1906700, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19212, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - Self cast spell"), -(1906700, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Hate - Action list - set orientation"), -(19210, 0, 0, 0, 8, 0, 100, 0, 33532, 0, 0, 0, 80, 1921000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - On spell hit - Action list"), -(1921000, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2.737549, "Fel Cannon: Fear - Action list - set orientation"), -(1921000, 9, 1, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 33535, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - cast spell"), -(1921000, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 33, 19210, 0, 0, 0, 0, 0, 16, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Credit quest"), -(1921000, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 92, 0, 33535, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Interrupt spell"), -(1921000, 9, 4, 0, 0, 0, 100, 0, 0, 0, 0, 0, 85, 42346, 0, 0, 0, 0, 0, 19, 19211, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - Self cast spell"), -(1921000, 9, 5, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Fel Cannon: Fear - Action list - set orientation"); diff --git a/sql/updates/world/3.3.5/2019_09_10_00_world.sql b/sql/updates/world/3.3.5/2019_09_10_00_world.sql deleted file mode 100644 index 7afa08f854e..00000000000 --- a/sql/updates/world/3.3.5/2019_09_10_00_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template` SET `flags_extra` = `flags_extra`|128 WHERE `entry` =21321; diff --git a/sql/updates/world/3.3.5/2019_09_12_01_world.sql b/sql/updates/world/3.3.5/2019_09_12_01_world.sql deleted file mode 100644 index e492c6cdb5a..00000000000 --- a/sql/updates/world/3.3.5/2019_09_12_01_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- O'Mally's Instrument Bunny (entry: 22021) -UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=22021; diff --git a/sql/updates/world/3.3.5/2019_09_12_02_world.sql b/sql/updates/world/3.3.5/2019_09_12_02_world.sql deleted file mode 100644 index 805033401e7..00000000000 --- a/sql/updates/world/3.3.5/2019_09_12_02_world.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -UPDATE `creature_template` SET `unit_flags`=320 WHERE `entry` IN (37591,37606); -UPDATE `creature_template` SET `gossip_menu_id`=10923 WHERE `entry` IN (37607); diff --git a/sql/updates/world/3.3.5/2019_09_12_03_world.sql b/sql/updates/world/3.3.5/2019_09_12_03_world.sql deleted file mode 100644 index 033a7471c56..00000000000 --- a/sql/updates/world/3.3.5/2019_09_12_03_world.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template` SET `unit_flags`=32832, `dynamicflags`=0 WHERE `entry` IN (37604 ,37809, 37779); diff --git a/sql/updates/world/3.3.5/2019_09_15_00_world.sql b/sql/updates/world/3.3.5/2019_09_15_00_world.sql new file mode 100644 index 00000000000..6d3536df062 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_09_15_00_world.sql @@ -0,0 +1,3 @@ +-- TDB 335.19091 world +UPDATE `version` SET `db_version`='TDB 335.19091', `cache_id`=19091 LIMIT 1; +UPDATE `updates` SET `state`='ARCHIVED'; -- cgit v1.2.3