From 25a77fc3672a558d94aafe1b279379dcde49eee3 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 11 Sep 2011 19:29:30 +0100 Subject: DB/GO: Spawn GO 179545 & 179485 in Dire Maul Closes #527 & #533. Thanks UDB. --- sql/updates/world/2011_09_11_03_world_gameobject.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2011_09_11_03_world_gameobject.sql (limited to 'sql') diff --git a/sql/updates/world/2011_09_11_03_world_gameobject.sql b/sql/updates/world/2011_09_11_03_world_gameobject.sql new file mode 100644 index 00000000000..b72898ba8a9 --- /dev/null +++ b/sql/updates/world/2011_09_11_03_world_gameobject.sql @@ -0,0 +1,5 @@ +UPDATE `gameobject_template` SET `WDBVerified`=12340 WHERE `entry`=179545; +DELETE FROM `gameobject` WHERE `id` IN (179545,179485); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(6,179545,429,1,1,116.135,638.836,-48.467,-0.785397,0,0,0,1,7200,255,1), +(159,179485,429,1,1,558.806,550.065,-25.4008,3.14159,0,0,0,1,180,255,1); -- cgit v1.2.3