diff options
| author | Nay <dnpd.dd@gmail.com> | 2013-02-09 15:13:49 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2013-02-09 15:13:49 +0000 |
| commit | e33f70c002531ac048d154c16c1e5a57a9fefd49 (patch) | |
| tree | 65798f4fc4ca45ee3bcfaf2f904ac49018648767 | |
| parent | f902362ad1fb5681305a9eaac14e1c0ec55449e9 (diff) | |
DB/Quests: Fix quest The Collapse and Deploy the Shake-n-Quake
Ref #1005
Ref #2034
Ref ae307048475ff14863d5a
Closes #3595
| -rw-r--r-- | sql/updates/world/2013_02_09_00_world_gameobject.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_02_09_00_world_gameobject.sql b/sql/updates/world/2013_02_09_00_world_gameobject.sql new file mode 100644 index 00000000000..386ca974e99 --- /dev/null +++ b/sql/updates/world/2013_02_09_00_world_gameobject.sql @@ -0,0 +1,10 @@ +SET @GUID = 4522; +SET @SINK = 300177; + +-- spawn TEMP South Sinkhole +DELETE FROM `gameobject` WHERE `guid`=@GUID AND `id`=@SINK; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@GUID, @SINK, 571, 1, 1, 3488.48, 4515.98, -20.7394, 5.34436, 0, 0, 0.452361, -0.891835, 300, 0, 1); + +-- increase TEMP South Sinkhole spellfocus radius +UPDATE `gameobject_template` SET `data1`=20 WHERE `entry`=@SINK; |