diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2018_10_11_02_world.sql | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_10_11_02_world.sql b/sql/updates/world/master/2018_10_11_02_world.sql new file mode 100644 index 00000000000..7df675deb2b --- /dev/null +++ b/sql/updates/world/master/2018_10_11_02_world.sql @@ -0,0 +1,109 @@ +DELETE FROM `spell_target_position` WHERE (`ID`=241998 AND `EffectIndex`=0) OR (`ID`=240122 AND `EffectIndex`=1) OR (`ID`=239341 AND `EffectIndex`=1) OR (`ID`=235116 AND `EffectIndex`=0) OR (`ID`=231762 AND `EffectIndex`=0) OR (`ID`=229575 AND `EffectIndex`=1) OR (`ID`=232201 AND `EffectIndex`=0) OR (`ID`=231698 AND `EffectIndex`=0) OR (`ID`=229931 AND `EffectIndex`=0) OR (`ID`=229942 AND `EffectIndex`=0) OR (`ID`=255442 AND `EffectIndex`=1) OR (`ID`=254664 AND `EffectIndex`=0) OR (`ID`=250365 AND `EffectIndex`=0) OR (`ID`=248543 AND `EffectIndex`=0) OR (`ID`=251677 AND `EffectIndex`=0) OR (`ID`=255218 AND `EffectIndex`=0) OR (`ID`=251210 AND `EffectIndex`=0) OR (`ID`=255215 AND `EffectIndex`=0) OR (`ID`=251594 AND `EffectIndex`=0) OR (`ID`=252494 AND `EffectIndex`=0) OR (`ID`=255216 AND `EffectIndex`=0) OR (`ID`=251222 AND `EffectIndex`=0) OR (`ID`=250367 AND `EffectIndex`=0) OR (`ID`=251041 AND `EffectIndex`=0) OR (`ID`=216920 AND `EffectIndex`=1) OR (`ID`=216163 AND `EffectIndex`=0) OR (`ID`=215653 AND `EffectIndex`=0) OR (`ID`=227216 AND `EffectIndex`=1) OR (`ID`=227216 AND `EffectIndex`=0) OR (`ID`=224616 AND `EffectIndex`=2) OR (`ID`=223442 AND `EffectIndex`=0) OR (`ID`=226968 AND `EffectIndex`=1) OR (`ID`=279114 AND `EffectIndex`=0) OR (`ID`=227172 AND `EffectIndex`=0) OR (`ID`=239973 AND `EffectIndex`=0) OR (`ID`=240603 AND `EffectIndex`=0) OR (`ID`=236671 AND `EffectIndex`=2) OR (`ID`=240161 AND `EffectIndex`=1) OR (`ID`=206277 AND `EffectIndex`=0) OR (`ID`=190067 AND `EffectIndex`=0) OR (`ID`=185613 AND `EffectIndex`=0) OR (`ID`=205571 AND `EffectIndex`=0) OR (`ID`=205570 AND `EffectIndex`=0) OR (`ID`=205569 AND `EffectIndex`=0) OR (`ID`=205568 AND `EffectIndex`=0) OR (`ID`=205565 AND `EffectIndex`=0) OR (`ID`=205566 AND `EffectIndex`=0) OR (`ID`=259106 AND `EffectIndex`=0) OR (`ID`=234521 AND `EffectIndex`=1) OR (`ID`=203822 AND `EffectIndex`=0) OR (`ID`=281403 AND `EffectIndex`=0) OR (`ID`=220892 AND `EffectIndex`=0) OR (`ID`=225293 AND `EffectIndex`=0) OR (`ID`=229361 AND `EffectIndex`=0) OR (`ID`=214400 AND `EffectIndex`=0) OR (`ID`=214442 AND `EffectIndex`=0) OR (`ID`=228640 AND `EffectIndex`=0) OR (`ID`=217015 AND `EffectIndex`=0) OR (`ID`=217014 AND `EffectIndex`=0) OR (`ID`=203986 AND `EffectIndex`=0) OR (`ID`=196971 AND `EffectIndex`=0) OR (`ID`=231401 AND `EffectIndex`=0) OR (`ID`=231402 AND `EffectIndex`=1) OR (`ID`=231400 AND `EffectIndex`=0) OR (`ID`=231399 AND `EffectIndex`=1) OR (`ID`=231740 AND `EffectIndex`=0) OR (`ID`=229500 AND `EffectIndex`=1) OR (`ID`=206185 AND `EffectIndex`=0) OR (`ID`=251472 AND `EffectIndex`=1) OR (`ID`=208649 AND `EffectIndex`=0) OR (`ID`=215277 AND `EffectIndex`=0) OR (`ID`=234742 AND `EffectIndex`=0) OR (`ID`=213076 AND `EffectIndex`=0) OR (`ID`=220464 AND `EffectIndex`=0) OR (`ID`=220465 AND `EffectIndex`=0) OR (`ID`=255214 AND `EffectIndex`=0) OR (`ID`=251213 AND `EffectIndex`=0) OR (`ID`=251162 AND `EffectIndex`=0) OR (`ID`=250362 AND `EffectIndex`=0) OR (`ID`=248045 AND `EffectIndex`=0) OR (`ID`=241647 AND `EffectIndex`=0) OR (`ID`=250546 AND `EffectIndex`=1) OR (`ID`=241454 AND `EffectIndex`=0) OR (`ID`=250455 AND `EffectIndex`=0) OR (`ID`=243270 AND `EffectIndex`=1) OR (`ID`=239337 AND `EffectIndex`=0) OR (`ID`=238571 AND `EffectIndex`=0) OR (`ID`=235132 AND `EffectIndex`=0) OR (`ID`=234679 AND `EffectIndex`=0) OR (`ID`=229754 AND `EffectIndex`=0) OR (`ID`=239219 AND `EffectIndex`=0) OR (`ID`=220463 AND `EffectIndex`=0) OR (`ID`=229432 AND `EffectIndex`=0) OR (`ID`=232241 AND `EffectIndex`=0) OR (`ID`=229548 AND `EffectIndex`=1) OR (`ID`=229061 AND `EffectIndex`=0) OR (`ID`=229157 AND `EffectIndex`=0) OR (`ID`=228951 AND `EffectIndex`=0) OR (`ID`=230903 AND `EffectIndex`=0) OR (`ID`=229237 AND `EffectIndex`=2) OR (`ID`=226060 AND `EffectIndex`=0) OR (`ID`=213233 AND `EffectIndex`=0) OR (`ID`=208702 AND `EffectIndex`=0) OR (`ID`=208631 AND `EffectIndex`=0) OR (`ID`=224873 AND `EffectIndex`=0); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(241998, 0, 1746, 75.78, -224.62, 938.13, 27980), -- Spell: Teleport Players to TK Arcatraz Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(240122, 1, 1220, -1498.81, 3218.14, 103.32, 27980), -- Spell: Dismiss Champion Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(239341, 1, 1220, -949.07, 2066.05, 39.09, 27980), -- Spell: Summon Champion Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(235116, 0, 1220, -858.23, 4644.17, 1158.19, 27980), -- Spell: Portal: The Dalaran Spire (Teleport) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(231762, 0, 1220, -493.42, 3017.62, 96.83, 27980), -- Spell: Portal: The Broken Shore (Teleport) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229575, 1, 1220, 2079.75, 3933.3, 113.25, 27980), -- Spell: Activate Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(232201, 0, 1220, 2060.89, 3354.49, 280.45, 27980), -- Spell: Teleport: Oculeth's Test Chamber Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(231698, 0, 1220, 1751.18, 4634, 126.62, 27980), -- Spell: Summon Hologram Efffect: 28 (SPELL_EFFECT_SUMMON) +(229931, 0, 1220, 749.74, 3605.19, 98.12, 27980), -- Spell: Teleport: Back to Post Siege Khadgar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229942, 0, 1220, 1181.4, 5887.44, -12.73, 27980), -- Spell: The Oculeth Special Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(255442, 1, 1669, 5646.19, 10624, 5.7, 27980), -- Spell: Cross Over Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(254664, 0, 1669, 4838.36, 9741.27, -65.25, 27980), -- Spell: Teleport to Exodus Point Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(250365, 0, 1669, 4601.1, 9831.9, 68.1, 27980), -- Spell: Teleport to Vindicaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(248543, 0, 1669, 497.15, 1468.22, 765.93, 27980), -- Spell: Teleport to Vindicaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251677, 0, 1779, 5701.32, -1432.57, 23.98, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(255218, 0, 1779, -1759.4, -1415.87, 29.31, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251210, 0, 1779, -1759.4, -1415.87, 29.31, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(255215, 0, 1779, 748.89, 728.24, 41.32, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251594, 0, 1779, 748.89, 728.24, 41.32, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(252494, 0, 1669, -2927.74, 8822.08, -232.15, 27980), -- Spell: Return to Hope's Landing Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(255216, 0, 1779, -4163.78, 651.57, 17.91, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251222, 0, 1779, -4163.78, 651.57, 17.91, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(250367, 0, 1669, -2602.1, 8573.3, -67, 27980), -- Spell: Teleport to Vindicaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251041, 0, 1669, 389.98, 1417.1, 769.6, 27980), -- Spell: Teleport: The Vindicaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(216920, 1, 1623, 1090.66, 1048.37, 210.59, 27980), -- Spell: Teleport: Hall of the Guardian Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(216163, 0, 1623, 1340.27, 1236.56, 172.96, 27980), -- Spell: Oculus Ground Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(215653, 0, 1623, 1072.79, 1049.12, 602.71, 27980), -- Spell: Start Scenario Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(227216, 1, 530, -3563.9, 205.91, 44.46, 27980), -- Spell: Warden's Trap Efffect: 219 (SPELL_EFFECT_219) +(227216, 0, 530, -3563.9, 205.91, 44.46, 27980), -- Spell: Warden's Trap Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(224616, 2, 1621, 651.16, 295.38, 396.36, 27980), -- Spell: Destiny Efffect: 28 (SPELL_EFFECT_SUMMON) +(223442, 0, 1621, 674.69, 305.4, 353.19, 27980), -- Spell: Teleport Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(226968, 1, 939, 3243.7, -5002.98, 194.09, 27980), -- Spell: Call to Xe'ra Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(279114, 0, 1, 7446.79, -49.47, 6.21, 27980), -- Spell: Evacuate Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(227172, 0, 1646, 3264.82, 7287.42, 90.77, 27980), -- Spell: Abscond Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(239973, 0, 1220, -1617.29, 3199.94, 129.02, 27980), -- Spell: Teleport To Deliverance Point Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(240603, 0, 1666, -1111.6, 2969.71, 186.02, 27980), -- Spell: Teleport to Mid Command Ship Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(236671, 2, 1666, -1188.32, 2953.37, 153.63, 27980), -- Spell: Demonic Gateway Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(240161, 1, 1220, -833.82, 4279.78, 746.28, 27980), -- Spell: Seamless Transfer to Broken Shore Scenario Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(206277, 0, 1220, -756.83, 4601.69, 728.9, 27980), -- Spell: Teleport to Dalaran Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(190067, 0, 1220, 2825.3, 877.51, 78.18, 27980), -- Spell: Narrow Escape Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(185613, 0, 1220, 3209.48, 3072.73, 440.212, 27980), -- Spell: Teleport: Wreck of the Skyfire Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(205571, 0, 1475, 4588.2, 2669, 138.89, 27980), -- Spell: Lorna Talking Head 09 Efffect: 219 (SPELL_EFFECT_219) +(205570, 0, 1475, 4588.2, 2669, 138.89, 27980), -- Spell: Lorna Talking Head 08 Efffect: 219 (SPELL_EFFECT_219) +(205569, 0, 1475, 4588.2, 2669, 138.89, 27980), -- Spell: Rogers Talking Head 04 Efffect: 219 (SPELL_EFFECT_219) +(205568, 0, 1475, 4950.38, 2877.51, 137.08, 27980), -- Spell: Rogers Talking Head 03 Efffect: 219 (SPELL_EFFECT_219) +(205565, 0, 1475, 4950.38, 2877.51, 137.08, 27980), -- Spell: Rogers Talking Head 01 Efffect: 219 (SPELL_EFFECT_219) +(205566, 0, 1475, 4950.38, 2877.51, 137.08, 27980), -- Spell: Rogers Talking Head 02 Efffect: 219 (SPELL_EFFECT_219) +(259106, 0, 1, 1590.86, -4199.37, 53.6, 27980), -- Spell: Teleport: Orgrimmar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(234521, 1, 530, -246.76, 928.58, 84.38, 27980), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(203822, 0, 1220, 3689.28, 7095.63, 25.21, 27843), -- Spell: Grove Expulsion Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(281403, 0, 1643, 1137.36, -538.6, 17.53, 27843), -- Spell: Teleport: Boralus Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(220892, 0, 1220, 372.29, 3996.95, 3.16, 27980), -- Spell: Teleport to Tavern Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(225293, 0, 1220, 1143.82, 4255.53, 21.33, 27980), -- Spell: Voluntary Vehicle Exit Spell - Cancel Immunity Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229361, 0, 1220, 526.07, 3768.77, 33.02, 27980), -- Spell: Teleport: Lighthouse Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(214400, 0, 1220, 204.29, 4732.39, -69.37, 27980), -- Spell: Vargoth Teleport Out Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(214442, 0, 1220, 184.3, 4711.71, -90.84, 27980), -- Spell: Demonic Portal Summon Efffect: 28 (SPELL_EFFECT_SUMMON) +(228640, 0, 1220, 290.59, 4606.81, -90.71, 27980), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(217015, 0, 1220, 819.09, 5191.23, 37.46, 27980), -- Spell: Teleport to Kyrtos's Lair Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(217014, 0, 1220, 663.41, 4820.57, -131.49, 27980), -- Spell: Teleport to Legion Ship Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(203986, 0, 1220, 664.96, 4822.75, -90.06, 27980), -- Spell: Teleport To Legion Ship Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(196971, 0, 1220, 312.84, 4928.55, -85.18, 27980), -- Spell: Summon Efffect: 28 (SPELL_EFFECT_SUMMON) +(231401, 0, 1220, 523.26, 3799.67, 1.49, 27980), -- Spell: Teleport: Evermoon Terrace Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(231402, 1, 1220, 519.13, 3779.64, 33.37, 27980), -- Spell: Teleportation Aura Efffect: 3 (SPELL_EFFECT_DUMMY) +(231400, 0, 1220, 518.32, 3774.72, 33.02, 27980), -- Spell: Teleport: Evermoon Terrace Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(231399, 1, 1220, 522.62, 3796.12, 1.55, 27980), -- Spell: Teleportation Aura Efffect: 3 (SPELL_EFFECT_DUMMY) +(231740, 0, 1220, 2799.17, 4387.51, 418.85, 27980), -- Spell: Teleport to Lunar Crucible Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229500, 1, 1220, -799.02, 4657.16, 933.84, 27980), -- Spell: Teleport: The Purple Parlor Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(206185, 0, 1220, -812.76, 4548.52, -156.88, 27980), -- Spell: Teleport to The Postmaster's Office Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251472, 1, 1220, -1617.29, 3199.94, 129.02, 27980), -- Spell: Complete Scenario / Teleport To Deliverance Point Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(208649, 0, 1220, 4495.8, 4849.9, 662, 27980), -- Spell: Eagle Banishment Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(215277, 0, 1220, 4944.53, 4963.3, 781.74, 27980), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(234742, 0, 1220, 1886.64, 3541.64, 265.97, 27980), -- Spell: Portal: Crimson Thicket (Teleport) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(213076, 0, 1220, -892.49, 4667.5, 955.92, 27843), -- Spell: Portal: Archmage Vargoth's Retreat (Teleport) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(220464, 0, 1220, 2836.21, 3215.08, 652.98, 27843), -- Spell: Mage-Ring Network Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(220465, 0, 1220, 2904.48, 6782.44, 271.9, 27843), -- Spell: Mage-Ring Network Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(255214, 0, 1779, -1399.98, 899.03, 90.31, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251213, 0, 1779, -1399.98, 899.03, 90.31, 27980), -- Spell: Rift Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251162, 0, 1220, -828.72, 4371.78, 738.64, 27980), -- Spell: Teleport: Dalaran Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(250362, 0, 1669, 380, 1412.5, 769.6, 27980), -- Spell: Teleport to Vindicaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(248045, 0, 1669, 388.85, 1416.41, 769.59, 27980), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(241647, 0, 1669, 1351.49, 1862.95, 548.24, 27980), -- Spell: Summon Beacon Efffect: 171 (SPELL_EFFECT_171) +(250546, 1, 1669, 628.28, 1448, 620.52, 27980), -- Spell: Darkfall Ridge Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(241454, 0, 1669, 459.02, 1450.02, 757.57, 27980), -- Spell: To Argus! Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(250455, 0, 1750, -3961.16, -11977.3, 158.64, 27980), -- Spell: Boarding Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(243270, 1, 1750, -4235.34, -11335.4, 8.85, 27980), -- Spell: Teleport: Azuremyst Isle Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(239337, 0, 1220, -860.92, 4544.25, 728.31, 27980), -- Spell: Teleporting Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(238571, 0, 1733, -9516.74, 1954.86, -55.72, 27980), -- Spell: Azeroth's Warning Scenario Launch Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(235132, 0, 1220, -473.71, 7792.56, 115.6, 27980), -- Spell: Teleport: Faronaar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(234679, 0, 1220, -851.9, 4622.84, 749.37, 27980), -- Spell: Acquire the Gift Efffect: 43 (SPELL_EFFECT_TELEPORT_UNITS_FACE_CASTER) +(229754, 0, 1220, -854.45, 4596.88, 748.82, 27980), -- Spell: Teleport: Violet Citadel Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(239219, 0, 1220, -1734.96, 3073.44, 18.76, 27980), -- Spell: Teleport Out of Super Secret Cave Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(220463, 0, 1220, 3954.06, 5467.33, 629.92, 27980), -- Spell: Mage-Ring Network Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229432, 0, 1220, 871.91, 3637.16, 98.1, 27980), -- Spell: Teleport: Astravar Harbor Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(232241, 0, 1220, 1776.73, 4637.35, 124, 27980), -- Spell: Teleport: Hub Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229548, 1, 1220, 476.29, 3745.05, 1.23, 27980), -- Spell: Teleport to Lighthouse Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229061, 0, 1220, 154.64, 5276.77, 1.2, 27980), -- Spell: Boat Ride Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(229157, 0, 1220, 686.79, 3735.8, 2.85, 27980), -- Spell: Shackled Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(228951, 0, 1220, 220.7, 3822.05, 0.36, 27980), -- Spell: Summon Nightborne Gondola Efffect: 28 (SPELL_EFFECT_SUMMON) +(230903, 0, 1220, 400.64, 3955.46, 1.39, 27980), -- Spell: Summon Guard Efffect: 28 (SPELL_EFFECT_SUMMON) +(229237, 2, 1662, 949.07, 4166.23, 1.42, 27980), -- Spell: Teleport: Sanctum of Order Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(226060, 0, 1220, 1022.01, 3848.6, 7.83, 27980), -- Spell: Safety Exit Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(213233, 0, 1571, 1067.74, 3291.17, 23.59, 27980), -- Spell: Uninvited Guest Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(208702, 0, 1571, 961.92, 3464.99, 2.23, 27980), -- Spell: Exit Boat Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(208631, 0, 1571, 940.44, 3841.49, 0, 27980), -- Spell: Summon Boat Efffect: 28 (SPELL_EFFECT_SUMMON) +(224873, 0, 1220, -828.72, 4371.78, 738.64, 27980); -- Spell: Portal: Dalaran - Broken Isles Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) + +UPDATE `spell_target_position` SET `PositionX`=2933.14, `PositionY`=871.86, `PositionZ`=515.35, `VerifiedBuild`=27980 WHERE (`ID`=191558 AND `EffectIndex`=0); |