diff options
| -rw-r--r-- | sql/updates/world/2012_08_27_00_world_creature_template.sql (renamed from sql/updates/world/2012_08_27_00_creature_template.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql (renamed from sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2012_08_27_03_world_gameobject.sql | 6 |
3 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2012_08_27_00_creature_template.sql b/sql/updates/world/2012_08_27_00_world_creature_template.sql index 804d7b5c61d..804d7b5c61d 100644 --- a/sql/updates/world/2012_08_27_00_creature_template.sql +++ b/sql/updates/world/2012_08_27_00_world_creature_template.sql diff --git a/sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql b/sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql index 9c664142bba..9c664142bba 100644 --- a/sql/updates/world/2012_08_27_02_playercreateinfo_spell.sql +++ b/sql/updates/world/2012_08_27_02_world_playercreateinfo_spell.sql diff --git a/sql/updates/world/2012_08_27_03_world_gameobject.sql b/sql/updates/world/2012_08_27_03_world_gameobject.sql new file mode 100644 index 00000000000..1bf836c96e0 --- /dev/null +++ b/sql/updates/world/2012_08_27_03_world_gameobject.sql @@ -0,0 +1,6 @@ +-- Spawn Blackened Urn (194092) GO based on sniff by Aokromes +SET @GUID := 334; -- Set by TDB team + +DELETE FROM `gameobject` WHERE `id`=194092; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID,194092,532,1,1,-11126.87,-1874.455,91.47264,6.056293,0,0,-0.113203,0.9935719,180,100,1); |