diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2018_08_11_09_world_335.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2018_08_11_09_world_335.sql b/sql/updates/world/3.3.5/2018_08_11_09_world_335.sql new file mode 100644 index 00000000000..93b8fa5dbe0 --- /dev/null +++ b/sql/updates/world/3.3.5/2018_08_11_09_world_335.sql @@ -0,0 +1,26 @@ +-- Evidence Marker --> Add missing spawns +SET @GUID1 := 38851; +SET @GUID2 := 42847; +SET @GUID3 := 42850; +DELETE FROM `creature` WHERE `guid` IN (@GUID1,@GUID2,@GUID3); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `ScriptName`, `VerifiedBuild`) VALUES +(@GUID1,23583,1,0,0,1,1,0,0,-3700.58,-2534.09,68.7248,3.05433,300,0,0,41,0,0,0,0,0,"",0), +(@GUID2,23583,1,0,0,1,1,0,0,-3721.85,-2541.17,69.7589,3.05433,300,0,0,41,0,0,0,0,0,"",0), +(@GUID3,23583,1,0,0,1,1,0,0,-3734.45,-2530.79,73.2862,3.30957,300,0,0,41,0,0,0,0,0,"",0); + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=23567; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`) VALUES +(23567,1,1,2,0); + +-- Fix "Reflective Dust" +UPDATE `creature_template_addon` SET `auras`="42171 42175" WHERE `entry`=23583; + +-- Fix rotation for some objects +UPDATE `gameobject` SET `rotation0`=0.556657, `rotation1`=-0.434788, `rotation2`=0.43101, `rotation3`=0.561536 WHERE `guid`=6376; -- Theramore Guard Badge +UPDATE `gameobject` SET `rotation0`=-0.105384, `rotation1`=0.677422, `rotation2`=0.042204, `rotation3`=0.726783 WHERE `guid`=6821; -- Black Shield + +-- Add condition for Inspector Tarem's gossip option +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8761; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15,8761,0,0,0,8,0,11123,0,0,0,0,0,"","Show gossip option if quest 'Inspecting the Ruins' is rewarded"), +(15,8761,0,0,1,8,0,11124,0,0,0,0,0,"","Show gossip option if quest 'Inspecting the Ruins' is rewarded"); |