diff options
| author | Killyana <morphone1@gmail.com> | 2016-05-31 16:59:30 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-11 23:01:11 +0100 |
| commit | 75d37defd7b78b60d5f71a941da2f0f90359554d (patch) | |
| tree | 9bb840eb77baad4cd5244725ea1cef2dd60279f2 | |
| parent | 956125831d910315932b7e33bea72af9c729bbd9 (diff) | |
DB: Scripts for teleportation Pads in Storm Peaks and K3
Closes #17236
By SnapperRy
(cherry picked from commit 73b51bb15fe4f4862a77c7cdcbb15d0f00996e38)
| -rw-r--r-- | sql/updates/world/master/2017_01_11_08_world_2016_05_31_04_world.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_08_world_2016_05_31_04_world.sql b/sql/updates/world/master/2017_01_11_08_world_2016_05_31_04_world.sql new file mode 100644 index 00000000000..d3ddfcfa05c --- /dev/null +++ b/sql/updates/world/master/2017_01_11_08_world_2016_05_31_04_world.sql @@ -0,0 +1,15 @@ +-- +DELETE FROM `areatrigger_scripts` WHERE `entry` IN (5187, 5190); +INSERT INTO `areatrigger_scripts` VALUES +(5187, "SmartTrigger"), +(5190, "SmartTrigger"); + +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (5187, 5190) AND `source_type`=2; +INSERT INTO `smart_scripts` VALUES +(5187, 2, 0, 0, 46, 0, 100, 0, 0, 0, 0, 0, 62, 571, 0, 0, 0, 0, 0, 7, 0, 0, 0, 6150.7563, -1071.3817, 402.7154, 2.1916, "Areatrigger - On Trigger - Teleport"), +(5190, 2, 0, 0, 46, 0, 100, 0, 0, 0, 0, 0, 62, 571, 0, 0, 0, 0, 0, 7, 0, 0, 0, 6314.1860, -1758.2946, 457.0714, 1.6787, "Areatrigger - On Trigger - Teleport"); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceId`=2 AND SourceEntry IN (5187, 5190); +INSERT INTO `conditions` VALUES +(22, 1, 5187, 2, 0, 8, 0, 12821, 0, 0, 0, 0, 0, "", "Event requires quest rewarded"), +(22, 1, 5190, 2, 0, 8, 0, 12821, 0, 0, 0, 0, 0, "", "Event requires quest rewarded"); |