aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2014-06-25 06:38:17 +0200
committerAokromes <Aokromes@users.noreply.github.com>2014-06-25 06:38:17 +0200
commit689f7c2fc6a69475151f1b0f15e636833ee38b86 (patch)
tree0ff17b035bdb06b366a44ae65aff48662c3a5722 /sql
parent04d72fa73f1c3f6ac1475ff5908bb53f3b54af3d (diff)
DB/Creature: Challe's Home For Little Tykes
Closes #5921
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2014_06_25_02_world_creature.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_06_25_02_world_creature.sql b/sql/updates/world/2014_06_25_02_world_creature.sql
new file mode 100644
index 00000000000..8c43786c8e8
--- /dev/null
+++ b/sql/updates/world/2014_06_25_02_world_creature.sql
@@ -0,0 +1,6 @@
+--
+SET @CGUID := 72776;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID+0, 23108, 530, 1, 1, -493.0895, 7448.848, 178.6083, 4.83718, 120, 5, 1), -- 23108 (Area: 0)
+(@CGUID+1, 23107, 530, 1, 1, -475.5646, 7463.805, 181.9694, 1.496497, 120, 5, 1), -- 23107 (Area: 0)
+(@CGUID+2, 23106, 530, 1, 1, -511.7721, 7500.889, 183.1165, 5.096361, 120, 0, 0); -- 23106 (Area: 0)