diff options
| author | w1sht0l1v3 <w1sht0l1v3@gmail.com> | 2012-09-12 00:49:16 +0300 |
|---|---|---|
| committer | w1sht0l1v3 <w1sht0l1v3@gmail.com> | 2012-09-12 00:49:16 +0300 |
| commit | f6c799a26babac7593d657387a611a0a521f0c53 (patch) | |
| tree | 1ab9cf6b84847486ae37862f707a06bb36b62643 | |
| parent | 78d0fac217bb7cd0dece38842a5aca07582e141e (diff) | |
DB/Gameobject: Update Trial of Grand Crusader door info.
| -rw-r--r-- | sql/updates/world/2012_09_10_15_world_misc.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_10_15_world_misc.sql b/sql/updates/world/2012_09_10_15_world_misc.sql new file mode 100644 index 00000000000..50896ce414c --- /dev/null +++ b/sql/updates/world/2012_09_10_15_world_misc.sql @@ -0,0 +1,9 @@ +-- East Porticullis(195648): close and corrections +UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=0 WHERE `guid`=151176; + +-- North Portcullis(195650): delete extra spawn and corrections +DELETE FROM `gameobject` WHERE `guid`=150080; +UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=1 WHERE `guid`=151178; + +-- Web Door(195485): corrections +UPDATE `gameobject` SET `spawnMask`=15,`rotation2`=0.7071067,`rotation3`=0.7071068,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=151192; |