diff options
| -rw-r--r-- | sql/updates/world/2012_12_02_00_world_game_object.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/2012_12_02_00_world_game_object.sql b/sql/updates/world/2012_12_02_00_world_game_object.sql new file mode 100644 index 00000000000..3205159a703 --- /dev/null +++ b/sql/updates/world/2012_12_02_00_world_game_object.sql @@ -0,0 +1,24 @@ +-- Some Spell focus corrections +-- Signal Fire +SET @GUID :=99716; +DELETE FROM `gameobject` WHERE `guid`=@GUID; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID,194151,571,1,1,4061.978,7109.135,170.0001,0,0,0,0,1,120,255,1); + +DELETE FROM `gameobject_template` WHERE `entry`=300242; + +-- Shrine Of Remulos +UPDATE `gameobject` SET `id`=15885 WHERE `id`=300142; +DELETE FROM `gameobject_template` WHERE `entry`=300142; + +-- Witherbark Village +UPDATE `gameobject` SET `id`=142698 WHERE `id`=300016; +DELETE FROM `gameobject_template` WHERE `entry`=300016; + +-- Maraudon Portal +UPDATE `gameobject` SET `id`=178400 WHERE `id`=300037; +DELETE FROM `gameobject_template` WHERE `entry`=300037; + +-- Scorched Grove Runeston +UPDATE `gameobject` SET `id`=181260 WHERE `id`=300086; +DELETE FROM `gameobject_template` WHERE `entry`=300086; |