From 02cf6e156e7bcde5f158bedd7392b8391ef2a8a0 Mon Sep 17 00:00:00 2001 From: durotar Date: Thu, 5 Jan 2012 10:58:18 +0100 Subject: DB/Quest: Need to know now has all objects closes #3443 --- sql/updates/world/2012_01_05_02_world_gameobject_template.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2012_01_05_02_world_gameobject_template.sql (limited to 'sql/updates') 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); -- cgit v1.2.3