aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMalcrom <malcromdev@gmail.com>2012-05-31 17:48:30 -0230
committerMalcrom <malcromdev@gmail.com>2012-05-31 17:48:30 -0230
commit2f557f507d075c55c3f913cba51bd2ae4f795172 (patch)
treefaa31c8f5d85f5a09353aac261bc1f927148a7fa
parent2172705b998003e7ea276c9efce00ad6a6c26128 (diff)
DB/gameobject: Add Missing Draconic for Dummies Objects
-rw-r--r--sql/updates/world/2012_05_31_06_world_gameobject.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2012_05_31_06_world_gameobject.sql b/sql/updates/world/2012_05_31_06_world_gameobject.sql
new file mode 100644
index 00000000000..1db1d6fbd76
--- /dev/null
+++ b/sql/updates/world/2012_05_31_06_world_gameobject.sql
@@ -0,0 +1,7 @@
+-- Add Missing Draconic for Dummies Objects
+SET @GUID := 4595;
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @GUID AND @GUID+2;
+INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES
+(@GUID,180665,0,1,1,-8340.196,413.7499,124.489677,2.82742977,0,0,0.987688,0.156436,180,255,1),
+(@GUID+1,180666,0,1,1,1628.83984,133.9376,-60.96726,-0.401424885,0,0,-0.199368,0.979925,180,255,1),
+(@GUID+2,180667,469,1,1,-7526.57,-924.776,458.826,0.558504,0,0,0.275637,0.961262,180,255,1);