diff options
| author | durotar <durotar@trinity.contrib> | 2012-01-05 10:58:18 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2012-01-05 10:58:18 +0100 |
| commit | 02cf6e156e7bcde5f158bedd7392b8391ef2a8a0 (patch) | |
| tree | 86a3b33fc60b0f6ecde94a91499dfd9be88c61aa | |
| parent | 0d6a66a88f63ad424c0ee761025af5b20173e290 (diff) | |
DB/Quest: Need to know now has all objects
closes #3443
| -rw-r--r-- | sql/updates/world/2012_01_05_02_world_gameobject_template.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2012_01_05_02_world_gameobject_template.sql b/sql/updates/world/2012_01_05_02_world_gameobject_template.sql new file mode 100644 index 00000000000..022c82d539d --- /dev/null +++ b/sql/updates/world/2012_01_05_02_world_gameobject_template.sql @@ -0,0 +1,7 @@ +-- Fixing quest 12234 "Need to Know" +UPDATE `gameobject_template` SET `flags`=`flags`|4 WHERE `entry`=188675; -- Scarlet Onslaught Daily Orders: Barracks by sniff +UPDATE `gameobject_template` SET `flags`=`flags`|4 WHERE `entry`=188676; -- Scarlet Onslaught Daily Orders: Abbey by sniff +UPDATE `gameobject_template` SET `flags`=`flags`|4 WHERE `entry`=188677; -- Scarlet Onslaught Daily Orders: Beach by sniff +DELETE FROM `gameobject` WHERE `id`=188677; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(219,188677,571,1,1,2567.449,-388.7118,3.573463,-2.879789,0,0,-0.9914446,0.1305283,300,100,1); |