diff options
| author | Malcrom <malcromdev@gmail.com> | 2012-05-05 21:08:16 -0230 |
|---|---|---|
| committer | Malcrom <malcromdev@gmail.com> | 2012-05-05 21:08:16 -0230 |
| commit | 072bab69512bb91d13905ad422ab90c6ef629299 (patch) | |
| tree | f7ea52d23181a052402693ff43816a80ea056909 /sql | |
| parent | fb9cbf96a75713940b2d400f5936ac8ef79fe73c (diff) | |
DB/Gameobjects: Add some missing Blood of Heroes spawns
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_05_05_02_world_gameobject.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_05_02_world_gameobject.sql b/sql/updates/world/2012_05_05_02_world_gameobject.sql new file mode 100644 index 00000000000..c0b2c6b147b --- /dev/null +++ b/sql/updates/world/2012_05_05_02_world_gameobject.sql @@ -0,0 +1,10 @@ +-- Add some missing Blood of Heroes spawns +SET @GUID := 5276; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @GUID AND @GUID+5; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@GUID,176213,0,1,1,1529.10242,-1427.06946,65.49049,-3.001947,0,0,-0.9975634,0.06976615,7200,100,1), +(@GUID+1,176213,0,1,1,1705.87439,-4690.138,48.9742165,-3.08918333,0,0,-0.9996567,0.02620165,7200,100,1), +(@GUID+2,176213,0,1,1,1846.79382,-3825.265,135.5159,1.83259487,0,0,0.7933531,0.6087617,7200,100,1), +(@GUID+3,176213,0,1,1,1748.16333,-4453.13525,74.26272,-2.0594883,0,0,0,0,7200,100,1), +(@GUID+4,176213,0,1,1,2159.835,-2442.754,62.0804,-0.4886912,0,0,-0.2419214,0.9702958,7200,100,1), +(@GUID+5,176213,0,1,1,1342.557,-1382.568,46.89193,2.775069,0,0,0.9832544,0.182238,7200,100,1); |