aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorMitchesD <majklprofik@seznam.cz>2015-02-15 12:21:35 +0100
committerMitchesD <majklprofik@seznam.cz>2015-02-15 12:21:35 +0100
commit89a7026898af8da7a24486795cbbbf6eb9777693 (patch)
treeac047446ab63a1a5837ba5eae619d0faaa8bc222 /sql/updates
parent164c12cab0cc3c4226738a12bf24a55437679047 (diff)
parent9eea348d8256633a0f333dd7d6eb256b4c25ec06 (diff)
Merge pull request #13989 from Rushor/Leaves
Scripts/Areatrigger: Assign Script to 'Ancient Leaves' Trigger
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2015_01_30_01_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2015_01_30_01_world.sql b/sql/updates/world/2015_01_30_01_world.sql
new file mode 100644
index 00000000000..56212e2873c
--- /dev/null
+++ b/sql/updates/world/2015_01_30_01_world.sql
@@ -0,0 +1,11 @@
+--
+DELETE FROM `areatrigger_scripts` WHERE `entry`=3587;
+INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
+(3587, 'at_ancient_leaf');
+DELETE FROM `creature` WHERE `id` IN (14524, 14525, 14526);
+
+DELETE FROM `creature_summon_groups` WHERE `summonerId`=1;
+INSERT INTO `creature_summon_groups` (`summonerId`, `summonerType`, `groupId`, `entry`, `position_x`, `position_y`, `position_z`, `orientation`, `summonType`, `summonTime`) VALUES
+(1, 2, 1, 14524, 6204.051758, -1172.575684, 370.079224, 0.86052, 3, 100000),
+(1, 2, 1, 14525, 6246.953613, -1155.985718, 366.182953, 2.90269, 3, 100000),
+(1, 2, 1, 14526, 6193.449219, -1137.834106, 366.260529, 5.77332, 3, 100000);