aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorRushor <PBienati@web.de>2015-01-30 17:27:58 +0100
committerRushor <PBienati@web.de>2015-02-12 00:05:15 +0100
commit9eea348d8256633a0f333dd7d6eb256b4c25ec06 (patch)
tree659663177975e689350754ce6e23847a7edfff17 /sql
parentccdc100d10143285bc058d968f0472ea4d073120 (diff)
Scripts/Areatrigger: Assign Script to 'Ancient Leaves' Trigger
Diffstat (limited to 'sql')
-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);