From ce794f3978e853341b2dc0c782e7bda34303b3f8 Mon Sep 17 00:00:00 2001 From: Shauren Date: Mon, 31 Dec 2018 21:35:55 +0100 Subject: Core/Spells: Fixed ErrorCube spell missiles (cherry picked from commit 3b5014fdae1b57add7fd204a9f9f10f3c2092b83) --- .../hotfixes/master/2021_11_18_00_hotfixes.sql | 94 ++++++++++++++++++++++ 1 file changed, 94 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_11_18_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2021_11_18_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_11_18_00_hotfixes.sql new file mode 100644 index 00000000000..01af175f5cb --- /dev/null +++ b/sql/updates/hotfixes/master/2021_11_18_00_hotfixes.sql @@ -0,0 +1,94 @@ +-- +-- Table structure for table `spell_visual` +-- +DROP TABLE IF EXISTS `spell_visual`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `spell_visual` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MissileCastOffset1` float NOT NULL DEFAULT '0', + `MissileCastOffset2` float NOT NULL DEFAULT '0', + `MissileCastOffset3` float NOT NULL DEFAULT '0', + `MissileImpactOffset1` float NOT NULL DEFAULT '0', + `MissileImpactOffset2` float NOT NULL DEFAULT '0', + `MissileImpactOffset3` float NOT NULL DEFAULT '0', + `AnimEventSoundID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `MissileAttachment` tinyint(4) NOT NULL DEFAULT '0', + `MissileDestinationAttachment` tinyint(4) NOT NULL DEFAULT '0', + `MissileCastPositionerID` int(10) unsigned NOT NULL DEFAULT '0', + `MissileImpactPositionerID` int(10) unsigned NOT NULL DEFAULT '0', + `MissileTargetingKit` int(11) NOT NULL DEFAULT '0', + `HostileSpellVisualID` int(10) unsigned NOT NULL DEFAULT '0', + `CasterSpellVisualID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellVisualMissileSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DamageNumberDelay` smallint(5) unsigned NOT NULL DEFAULT '0', + `LowViolenceSpellVisualID` int(10) unsigned NOT NULL DEFAULT '0', + `RaidSpellVisualMissileSetID` int(10) unsigned NOT NULL DEFAULT '0', + `ReducedUnexpectedCameraMovementSpellVisualID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_visual_effect_name` +-- +DROP TABLE IF EXISTS `spell_visual_effect_name`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `spell_visual_effect_name` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ModelFileDataID` int(11) NOT NULL DEFAULT '0', + `BaseMissileSpeed` float NOT NULL DEFAULT '0', + `Scale` float NOT NULL DEFAULT '0', + `MinAllowedScale` float NOT NULL DEFAULT '0', + `MaxAllowedScale` float NOT NULL DEFAULT '0', + `Alpha` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `TextureFileDataID` int(11) NOT NULL DEFAULT '0', + `EffectRadius` float NOT NULL DEFAULT '0', + `Type` int(10) unsigned NOT NULL DEFAULT '0', + `GenericID` int(11) NOT NULL DEFAULT '0', + `RibbonQualityID` int(10) unsigned NOT NULL DEFAULT '0', + `DissolveEffectID` int(11) NOT NULL DEFAULT '0', + `ModelPosition` int(11) NOT NULL DEFAULT '0', + `Unknown901` tinyint(4) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_visual_missile` +-- +DROP TABLE IF EXISTS `spell_visual_missile`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `spell_visual_missile` ( + `CastOffset1` float NOT NULL DEFAULT '0', + `CastOffset2` float NOT NULL DEFAULT '0', + `CastOffset3` float NOT NULL DEFAULT '0', + `ImpactOffset1` float NOT NULL DEFAULT '0', + `ImpactOffset2` float NOT NULL DEFAULT '0', + `ImpactOffset3` float NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellVisualEffectNameID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SoundEntriesID` int(10) unsigned NOT NULL DEFAULT '0', + `Attachment` tinyint(4) NOT NULL DEFAULT '0', + `DestinationAttachment` tinyint(4) NOT NULL DEFAULT '0', + `CastPositionerID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ImpactPositionerID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FollowGroundHeight` int(11) NOT NULL DEFAULT '0', + `FollowGroundDropSpeed` int(10) unsigned NOT NULL DEFAULT '0', + `FollowGroundApproach` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `SpellMissileMotionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AnimKitID` int(10) unsigned NOT NULL DEFAULT '0', + `ClutterLevel` tinyint(4) NOT NULL DEFAULT '0', + `DecayTimeAfterImpact` int(11) NOT NULL DEFAULT '0', + `SpellVisualMissileSetID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; -- cgit v1.2.3