diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-03-24 11:39:28 +0000 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-03-27 02:01:55 +0000 |
| commit | 7d80f1a8debc53a9afb347d139c57845d8057e30 (patch) | |
| tree | 6ecf7fcea5c83af3cc6fbe564b82cdcba051b061 | |
| parent | 3499f43bed5885d6433023823ad608a8122cc24e (diff) | |
DB/Misc: Another error
As Aokromes suggested when I originally committed fix for Teleport This! I must have accidentally searched for creature guid instead of go guid.
(cherry picked from commit 1944b3bce5218618cd36c2a5889ec00d5331c980)
Conflicts:
sql/updates/world/2015_03_24_01_world.sql
| -rw-r--r-- | sql/updates/world/2015_03_24_01_world_f355.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2015_03_24_01_world_f355.sql b/sql/updates/world/2015_03_24_01_world_f355.sql new file mode 100644 index 00000000000..31034d87c4a --- /dev/null +++ b/sql/updates/world/2015_03_24_01_world_f355.sql @@ -0,0 +1,10 @@ + +DELETE FROM `gameobject` WHERE `guid` IN (69717, 69718, 69719, 6220,6221,6222) AND `id`=185215; +DELETE FROM `gameobject` WHERE `guid` IN (69717, 69718, 69719) AND `id` IN(2040,1732,1733); +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(6220, 185215, 530, 1, 1, 4697.5, 3298.68, 178.892, 2.02823, 0, 0, 0.849013, 0.528372, 120, 0, 1), +(6221, 185215, 530, 1, 1, 4734.71, 3193.67, 161.48, 0.386745, 0, 0, 0.19217, 0.981362, 120, 0, 1), +(6222, 185215, 530, 1, 1, 4673.28, 3126.67, 166.725, 5.42979, 0, 0, 0.413867, -0.910337, 120, 0, 1), +(69717, 2040, 0, 1, 1, -1246, -2071, 50.241, 2.284, 0, 0, 0, 0, 900, 255, 1), +(69718, 1732, 0, 1, 1, -1246, -2071, 50.241, 2.284, 0, 0, 0, 0, 900, 255, 1), +(69719, 1733, 0, 1, 1, -1246, -2071, 50.241, 2.284, 0, 0, 0, 0, 900, 255, 1); |