diff options
| -rw-r--r-- | sql/updates/world/master/2018_09_24_01_world.sql | 337 |
1 files changed, 337 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_09_24_01_world.sql b/sql/updates/world/master/2018_09_24_01_world.sql new file mode 100644 index 00000000000..3a7c1b79e4f --- /dev/null +++ b/sql/updates/world/master/2018_09_24_01_world.sql @@ -0,0 +1,337 @@ +-- +DELETE FROM `spell_target_position` WHERE (`ID`=164208 AND `EffectIndex`=0) OR (`ID`=172354 AND `EffectIndex`=0) OR (`ID`=165003 AND `EffectIndex`=0) OR (`ID`=168918 AND `EffectIndex`=0) OR (`ID`=165484 AND `EffectIndex`=0) OR (`ID`=155941 AND `EffectIndex`=0) OR (`ID`=162562 AND `EffectIndex`=0) OR (`ID`=155892 AND `EffectIndex`=0) OR (`ID`=155895 AND `EffectIndex`=0) OR (`ID`=155894 AND `EffectIndex`=0) OR (`ID`=167166 AND `EffectIndex`=0) OR (`ID`=164277 AND `EffectIndex`=0) OR (`ID`=165800 AND `EffectIndex`=0) OR (`ID`=165619 AND `EffectIndex`=0) OR (`ID`=165618 AND `EffectIndex`=0) OR (`ID`=165612 AND `EffectIndex`=0) OR (`ID`=165611 AND `EffectIndex`=0) OR (`ID`=165617 AND `EffectIndex`=0) OR (`ID`=165616 AND `EffectIndex`=0) OR (`ID`=165615 AND `EffectIndex`=0) OR (`ID`=161706 AND `EffectIndex`=0) OR (`ID`=161720 AND `EffectIndex`=0) OR (`ID`=161721 AND `EffectIndex`=0) OR (`ID`=161728 AND `EffectIndex`=0) OR (`ID`=161726 AND `EffectIndex`=0) OR (`ID`=161725 AND `EffectIndex`=0) OR (`ID`=161671 AND `EffectIndex`=0) OR (`ID`=178326 AND `EffectIndex`=0) OR (`ID`=164802 AND `EffectIndex`=0) OR (`ID`=164801 AND `EffectIndex`=0) OR (`ID`=164800 AND `EffectIndex`=0) OR (`ID`=164799 AND `EffectIndex`=0) OR (`ID`=164798 AND `EffectIndex`=0) OR (`ID`=164797 AND `EffectIndex`=0) OR (`ID`=134652 AND `EffectIndex`=1) OR (`ID`=125319 AND `EffectIndex`=0) OR (`ID`=125709 AND `EffectIndex`=0) OR (`ID`=123786 AND `EffectIndex`=0) OR (`ID`=121922 AND `EffectIndex`=1) OR (`ID`=123264 AND `EffectIndex`=0) OR (`ID`=122798 AND `EffectIndex`=0) OR (`ID`=127900 AND `EffectIndex`=1) OR (`ID`=125924 AND `EffectIndex`=0) OR (`ID`=125922 AND `EffectIndex`=0) OR (`ID`=125641 AND `EffectIndex`=0) OR (`ID`=125064 AND `EffectIndex`=0) OR (`ID`=122788 AND `EffectIndex`=1) OR (`ID`=122796 AND `EffectIndex`=0) OR (`ID`=127845 AND `EffectIndex`=0) OR (`ID`=130559 AND `EffectIndex`=0) OR (`ID`=121798 AND `EffectIndex`=0) OR (`ID`=106179 AND `EffectIndex`=0) OR (`ID`=106180 AND `EffectIndex`=0) OR (`ID`=106176 AND `EffectIndex`=1) OR (`ID`=106177 AND `EffectIndex`=0) OR (`ID`=106178 AND `EffectIndex`=0) OR (`ID`=106077 AND `EffectIndex`=0) OR (`ID`=113741 AND `EffectIndex`=0) OR (`ID`=132401 AND `EffectIndex`=0) OR (`ID`=125515 AND `EffectIndex`=0) OR (`ID`=105667 AND `EffectIndex`=0) OR (`ID`=105664 AND `EffectIndex`=2) OR (`ID`=125420 AND `EffectIndex`=0) OR (`ID`=125411 AND `EffectIndex`=0) OR (`ID`=103623 AND `EffectIndex`=0) OR (`ID`=103620 AND `EffectIndex`=0) OR (`ID`=103608 AND `EffectIndex`=0) OR (`ID`=104119 AND `EffectIndex`=0) OR (`ID`=103567 AND `EffectIndex`=0) OR (`ID`=103568 AND `EffectIndex`=0) OR (`ID`=103564 AND `EffectIndex`=0) OR (`ID`=103563 AND `EffectIndex`=0) OR (`ID`=103239 AND `EffectIndex`=0) OR (`ID`=103425 AND `EffectIndex`=0) OR (`ID`=103428 AND `EffectIndex`=0) OR (`ID`=106007 AND `EffectIndex`=0) OR (`ID`=106004 AND `EffectIndex`=0) OR (`ID`=105940 AND `EffectIndex`=0) OR (`ID`=113502 AND `EffectIndex`=0) OR (`ID`=105941 AND `EffectIndex`=0) OR (`ID`=105975 AND `EffectIndex`=0) OR (`ID`=105938 AND `EffectIndex`=0) OR (`ID`=103537 AND `EffectIndex`=0) OR (`ID`=103539 AND `EffectIndex`=0) OR (`ID`=103237 AND `EffectIndex`=0) OR (`ID`=103609 AND `EffectIndex`=0) OR (`ID`=105882 AND `EffectIndex`=0) OR (`ID`=105883 AND `EffectIndex`=0) OR (`ID`=105884 AND `EffectIndex`=0) OR (`ID`=105885 AND `EffectIndex`=0) OR (`ID`=130499 AND `EffectIndex`=0) OR (`ID`=130961 AND `EffectIndex`=0) OR (`ID`=130951 AND `EffectIndex`=0) OR (`ID`=113087 AND `EffectIndex`=0) OR (`ID`=113088 AND `EffectIndex`=0) OR (`ID`=113091 AND `EffectIndex`=0) OR (`ID`=113094 AND `EffectIndex`=0) OR (`ID`=103592 AND `EffectIndex`=0) OR (`ID`=103552 AND `EffectIndex`=0) OR (`ID`=123071 AND `EffectIndex`=0) OR (`ID`=130866 AND `EffectIndex`=1) OR (`ID`=131603 AND `EffectIndex`=0) OR (`ID`=131758 AND `EffectIndex`=0) OR (`ID`=130321 AND `EffectIndex`=0) OR (`ID`=251062 AND `EffectIndex`=0) OR (`ID`=158500 AND `EffectIndex`=0) OR (`ID`=158496 AND `EffectIndex`=0) OR (`ID`=159720 AND `EffectIndex`=1) OR (`ID`=159326 AND `EffectIndex`=1) OR (`ID`=163627 AND `EffectIndex`=0) OR (`ID`=162173 AND `EffectIndex`=0) OR (`ID`=159985 AND `EffectIndex`=0) OR (`ID`=178295 AND `EffectIndex`=0) OR (`ID`=167292 AND `EffectIndex`=0) OR (`ID`=168470 AND `EffectIndex`=0) OR (`ID`=167580 AND `EffectIndex`=0) OR (`ID`=167317 AND `EffectIndex`=1) OR (`ID`=167941 AND `EffectIndex`=0) OR (`ID`=167316 AND `EffectIndex`=0) OR (`ID`=167162 AND `EffectIndex`=0) OR (`ID`=167140 AND `EffectIndex`=0) OR (`ID`=167128 AND `EffectIndex`=1) OR (`ID`=171726 AND `EffectIndex`=0) OR (`ID`=129947 AND `EffectIndex`=0) OR (`ID`=132055 AND `EffectIndex`=0) OR (`ID`=129611 AND `EffectIndex`=0) OR (`ID`=132121 AND `EffectIndex`=0) OR (`ID`=132122 AND `EffectIndex`=0) OR (`ID`=117963 AND `EffectIndex`=1) OR (`ID`=117965 AND `EffectIndex`=0) OR (`ID`=117966 AND `EffectIndex`=0) OR (`ID`=117542 AND `EffectIndex`=0) OR (`ID`=119648 AND `EffectIndex`=0) OR (`ID`=125184 AND `EffectIndex`=0) OR (`ID`=125181 AND `EffectIndex`=0) OR (`ID`=123896 AND `EffectIndex`=0) OR (`ID`=123734 AND `EffectIndex`=0) OR (`ID`=118957 AND `EffectIndex`=0) OR (`ID`=118953 AND `EffectIndex`=0) OR (`ID`=118447 AND `EffectIndex`=0) OR (`ID`=117703 AND `EffectIndex`=0) OR (`ID`=117397 AND `EffectIndex`=0) OR (`ID`=117404 AND `EffectIndex`=0) OR (`ID`=116103 AND `EffectIndex`=0) OR (`ID`=116101 AND `EffectIndex`=0) OR (`ID`=116102 AND `EffectIndex`=0) OR (`ID`=116112 AND `EffectIndex`=0) OR (`ID`=115452 AND `EffectIndex`=0) OR (`ID`=115261 AND `EffectIndex`=0) OR (`ID`=115208 AND `EffectIndex`=0) OR (`ID`=115260 AND `EffectIndex`=0) OR (`ID`=115102 AND `EffectIndex`=0) OR (`ID`=121003 AND `EffectIndex`=0) OR (`ID`=120741 AND `EffectIndex`=0) OR (`ID`=120739 AND `EffectIndex`=0) OR (`ID`=120476 AND `EffectIndex`=0) OR (`ID`=120833 AND `EffectIndex`=0) OR (`ID`=176248 AND `EffectIndex`=0) OR (`ID`=117759 AND `EffectIndex`=0) OR (`ID`=111536 AND `EffectIndex`=0) OR (`ID`=111539 AND `EffectIndex`=0) OR (`ID`=111538 AND `EffectIndex`=0) OR (`ID`=111537 AND `EffectIndex`=0) OR (`ID`=111466 AND `EffectIndex`=0) OR (`ID`=107771 AND `EffectIndex`=0) OR (`ID`=108071 AND `EffectIndex`=0) OR (`ID`=106628 AND `EffectIndex`=0) OR (`ID`=106618 AND `EffectIndex`=0) OR (`ID`=106554 AND `EffectIndex`=0) OR (`ID`=106605 AND `EffectIndex`=0) OR (`ID`=106552 AND `EffectIndex`=0) OR (`ID`=106599 AND `EffectIndex`=0) OR (`ID`=106336 AND `EffectIndex`=0) OR (`ID`=106324 AND `EffectIndex`=0) OR (`ID`=105811 AND `EffectIndex`=0) OR (`ID`=105810 AND `EffectIndex`=0) OR (`ID`=110356 AND `EffectIndex`=0) OR (`ID`=105522 AND `EffectIndex`=0) OR (`ID`=105519 AND `EffectIndex`=0) OR (`ID`=105504 AND `EffectIndex`=0) OR (`ID`=105296 AND `EffectIndex`=0) OR (`ID`=105508 AND `EffectIndex`=0) OR (`ID`=124530 AND `EffectIndex`=0) OR (`ID`=105835 AND `EffectIndex`=0) OR (`ID`=125944 AND `EffectIndex`=0) OR (`ID`=125942 AND `EffectIndex`=0) OR (`ID`=125952 AND `EffectIndex`=0) OR (`ID`=125949 AND `EffectIndex`=0) OR (`ID`=125966 AND `EffectIndex`=0) OR (`ID`=125965 AND `EffectIndex`=0) OR (`ID`=125472 AND `EffectIndex`=2) OR (`ID`=125374 AND `EffectIndex`=0) OR (`ID`=108018 AND `EffectIndex`=0) OR (`ID`=128950 AND `EffectIndex`=0) OR (`ID`=110360 AND `EffectIndex`=0) OR (`ID`=110354 AND `EffectIndex`=0) OR (`ID`=110338 AND `EffectIndex`=0) OR (`ID`=110351 AND `EffectIndex`=0) OR (`ID`=103120 AND `EffectIndex`=0) OR (`ID`=102828 AND `EffectIndex`=0) OR (`ID`=105364 AND `EffectIndex`=0) OR (`ID`=105251 AND `EffectIndex`=0) OR (`ID`=105016 AND `EffectIndex`=0) OR (`ID`=104032 AND `EffectIndex`=0) OR (`ID`=120134 AND `EffectIndex`=0) OR (`ID`=120128 AND `EffectIndex`=0) OR (`ID`=106017 AND `EffectIndex`=1) OR (`ID`=119923 AND `EffectIndex`=0) OR (`ID`=114343 AND `EffectIndex`=0) OR (`ID`=106316 AND `EffectIndex`=0) OR (`ID`=106311 AND `EffectIndex`=0) OR (`ID`=106308 AND `EffectIndex`=0) OR (`ID`=120049 AND `EffectIndex`=0) OR (`ID`=113837 AND `EffectIndex`=2) OR (`ID`=113837 AND `EffectIndex`=1) OR (`ID`=113837 AND `EffectIndex`=0) OR (`ID`=113835 AND `EffectIndex`=0) OR (`ID`=113834 AND `EffectIndex`=0) OR (`ID`=113541 AND `EffectIndex`=0) OR (`ID`=106570 AND `EffectIndex`=0) OR (`ID`=212983 AND `EffectIndex`=0) OR (`ID`=212982 AND `EffectIndex`=0) OR (`ID`=212979 AND `EffectIndex`=0) OR (`ID`=214778 AND `EffectIndex`=0) OR (`ID`=214730 AND `EffectIndex`=0) OR (`ID`=214719 AND `EffectIndex`=1) OR (`ID`=223429 AND `EffectIndex`=0) OR (`ID`=196604 AND `EffectIndex`=0) OR (`ID`=196262 AND `EffectIndex`=0) OR (`ID`=195549 AND `EffectIndex`=0) OR (`ID`=195454 AND `EffectIndex`=0) OR (`ID`=281404 AND `EffectIndex`=0) OR (`ID`=203976 AND `EffectIndex`=0) OR (`ID`=208013 AND `EffectIndex`=0) OR (`ID`=207901 AND `EffectIndex`=0) OR (`ID`=211719 AND `EffectIndex`=0) OR (`ID`=241271 AND `EffectIndex`=0) OR (`ID`=203675 AND `EffectIndex`=0) OR (`ID`=203241 AND `EffectIndex`=0) OR (`ID`=245992 AND `EffectIndex`=1) OR (`ID`=247057 AND `EffectIndex`=1) OR (`ID`=228326 AND `EffectIndex`=0) OR (`ID`=200891 AND `EffectIndex`=1) OR (`ID`=208514 AND `EffectIndex`=0) OR (`ID`=181546 AND `EffectIndex`=0) OR (`ID`=227791 AND `EffectIndex`=0) OR (`ID`=218636 AND `EffectIndex`=0) OR (`ID`=199358 AND `EffectIndex`=0) OR (`ID`=164450 AND `EffectIndex`=0) OR (`ID`=167579 AND `EffectIndex`=0) OR (`ID`=166011 AND `EffectIndex`=0) OR (`ID`=165975 AND `EffectIndex`=0) OR (`ID`=166251 AND `EffectIndex`=0) OR (`ID`=166145 AND `EffectIndex`=0) OR (`ID`=166160 AND `EffectIndex`=0) OR (`ID`=167835 AND `EffectIndex`=0) OR (`ID`=182464 AND `EffectIndex`=0) OR (`ID`=170110 AND `EffectIndex`=0) OR (`ID`=163736 AND `EffectIndex`=0) OR (`ID`=182317 AND `EffectIndex`=0) OR (`ID`=186007 AND `EffectIndex`=0) OR (`ID`=182748 AND `EffectIndex`=0) OR (`ID`=182745 AND `EffectIndex`=0) OR (`ID`=182725 AND `EffectIndex`=0) OR (`ID`=182755 AND `EffectIndex`=0) OR (`ID`=173140 AND `EffectIndex`=0) OR (`ID`=115590 AND `EffectIndex`=0) OR (`ID`=128764 AND `EffectIndex`=2) OR (`ID`=116622 AND `EffectIndex`=0) OR (`ID`=116619 AND `EffectIndex`=0) OR (`ID`=116618 AND `EffectIndex`=0) OR (`ID`=116630 AND `EffectIndex`=0) OR (`ID`=116528 AND `EffectIndex`=0) OR (`ID`=112872 AND `EffectIndex`=0) OR (`ID`=132342 AND `EffectIndex`=1) OR (`ID`=113615 AND `EffectIndex`=0) OR (`ID`=113156 AND `EffectIndex`=0) OR (`ID`=113155 AND `EffectIndex`=0) OR (`ID`=112924 AND `EffectIndex`=0) OR (`ID`=112923 AND `EffectIndex`=0) OR (`ID`=112901 AND `EffectIndex`=0) OR (`ID`=112900 AND `EffectIndex`=0) OR (`ID`=113034 AND `EffectIndex`=0) OR (`ID`=113033 AND `EffectIndex`=0) OR (`ID`=113032 AND `EffectIndex`=0) OR (`ID`=113026 AND `EffectIndex`=0) OR (`ID`=110654 AND `EffectIndex`=0) OR (`ID`=110552 AND `EffectIndex`=0) OR (`ID`=110564 AND `EffectIndex`=0) OR (`ID`=110563 AND `EffectIndex`=0) OR (`ID`=110333 AND `EffectIndex`=0) OR (`ID`=109267 AND `EffectIndex`=2) OR (`ID`=106913 AND `EffectIndex`=0) OR (`ID`=106987 AND `EffectIndex`=0) OR (`ID`=106912 AND `EffectIndex`=0) OR (`ID`=106986 AND `EffectIndex`=0) OR (`ID`=106911 AND `EffectIndex`=0) OR (`ID`=106985 AND `EffectIndex`=0) OR (`ID`=110752 AND `EffectIndex`=0) OR (`ID`=110751 AND `EffectIndex`=0) OR (`ID`=109511 AND `EffectIndex`=0) OR (`ID`=131280 AND `EffectIndex`=0) OR (`ID`=109490 AND `EffectIndex`=0) OR (`ID`=109488 AND `EffectIndex`=0) OR (`ID`=109489 AND `EffectIndex`=0) OR (`ID`=109486 AND `EffectIndex`=0) OR (`ID`=160216 AND `EffectIndex`=0) OR (`ID`=160220 AND `EffectIndex`=0) OR (`ID`=160217 AND `EffectIndex`=0) OR (`ID`=167221 AND `EffectIndex`=0) OR (`ID`=164041 AND `EffectIndex`=0) OR (`ID`=167960 AND `EffectIndex`=0) OR (`ID`=167431 AND `EffectIndex`=0) OR (`ID`=167771 AND `EffectIndex`=0) OR (`ID`=267877 AND `EffectIndex`=0) OR (`ID`=122726 AND `EffectIndex`=0) OR (`ID`=122717 AND `EffectIndex`=0) OR (`ID`=138818 AND `EffectIndex`=0) OR (`ID`=139553 AND `EffectIndex`=0) OR (`ID`=140125 AND `EffectIndex`=0) OR (`ID`=138023 AND `EffectIndex`=0) OR (`ID`=121307 AND `EffectIndex`=0) OR (`ID`=117428 AND `EffectIndex`=0) OR (`ID`=118970 AND `EffectIndex`=0) OR (`ID`=118246 AND `EffectIndex`=0) OR (`ID`=118115 AND `EffectIndex`=0) OR (`ID`=117788 AND `EffectIndex`=0) OR (`ID`=117974 AND `EffectIndex`=0) OR (`ID`=117927 AND `EffectIndex`=0) OR (`ID`=117929 AND `EffectIndex`=0); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(164208, 0, 1116, 3639.39, 5512.71, 52.8115, 27602), -- Spell: And Justice for Thrall: End of Cinematic 02 - Teleport to the Stones of Prophecy Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(172354, 0, 0, 2558.18, 5743.95, 103.759, 27602), -- Spell: A Choice to Make: Workshop Tracking Event Quest Complete - Alliance 02 Efffect: 198 (SPELL_EFFECT_198) +(165003, 0, 0, -1094.45, 2284.87, 6.15341, 27602), -- Spell: Inn Efffect: 198 (SPELL_EFFECT_198) +(168918, 0, 1116, -647.717, 1569.47, 33.9886, 27602), -- Spell: Summon Reshad Efffect: 28 (SPELL_EFFECT_SUMMON) +(165484, 0, 1277, 1002.85, -2930.59, 99.3366, 27602), -- Spell: Teleport Into Karabor Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(155941, 0, 1116, 642.66, -1280.54, 2.73, 27602), -- Spell: Summon Maraad Efffect: 28 (SPELL_EFFECT_SUMMON) +(162562, 0, 1116, 599.078, -1230.39, -21.4233, 27602), -- Spell: Summon Yrel Efffect: 28 (SPELL_EFFECT_SUMMON) +(155892, 0, 1116, 932.299, -837.962, -28.8337, 27602), -- Spell: Summon Velen Efffect: 28 (SPELL_EFFECT_SUMMON) +(155895, 0, 1116, 935.578, -838.849, -28.8338, 27602), -- Spell: Summon Yrel Efffect: 28 (SPELL_EFFECT_SUMMON) +(155894, 0, 1116, 931.457, -834.543, -28.8257, 27602), -- Spell: Summon Maraad Efffect: 28 (SPELL_EFFECT_SUMMON) +(167166, 0, 1116, 1486.75, -1919.36, 67.4675, 27547), -- Spell: Summon Conversation Bunny Efffect: 28 (SPELL_EFFECT_SUMMON) +(164277, 0, 1116, 1485.43, -2042.35, 10.1931, 27547), -- Spell: Summon Malfunctioning Crystal Efffect: 28 (SPELL_EFFECT_SUMMON) +(165800, 0, 1116, 1214.31, -1496.32, -4.1427, 27547), -- Spell: Summon Maraad Efffect: 28 (SPELL_EFFECT_SUMMON) +(165619, 0, 1116, 1217.77, -1496.8, -3.47803, 27547), -- Spell: Summon Fungal Freak Efffect: 28 (SPELL_EFFECT_SUMMON) +(165618, 0, 1116, 1179.57, -1507.81, 2.56837, 27547), -- Spell: Summon Crystal Efffect: 28 (SPELL_EFFECT_SUMMON) +(165612, 0, 1116, 1231.38, -1477.18, 0.911299, 27547), -- Spell: Summon Naielle Efffect: 28 (SPELL_EFFECT_SUMMON) +(165611, 0, 1116, 1173.38, -1515.15, -5.10943, 27547), -- Spell: Summon Hataaru Efffect: 28 (SPELL_EFFECT_SUMMON) +(165617, 0, 1116, 1159.41, -1511.75, -5.40878, 27547), -- Spell: Summon Guard 3 Efffect: 28 (SPELL_EFFECT_SUMMON) +(165616, 0, 1116, 1183.48, -1489.6, -5.35286, 27547), -- Spell: Summon Guard 2 Efffect: 28 (SPELL_EFFECT_SUMMON) +(165615, 0, 1116, 1196.36, -1513.01, -5.42194, 27547), -- Spell: Summon Guard 1 Efffect: 28 (SPELL_EFFECT_SUMMON) +(161706, 0, 1116, 1179.69, -1507.27, -5.11036, 27547), -- Spell: Primary Pylon Powerup Effects Efffect: 198 (SPELL_EFFECT_198) +(161720, 0, 1116, 1179.69, -1507.27, -5.11036, 27547), -- Spell: Secondary Pylon Powerup Effects Efffect: 198 (SPELL_EFFECT_198) +(161721, 0, 1116, 1179.69, -1507.27, -5.11036, 27547), -- Spell: Tertiary Pylon Powerup Effects Efffect: 198 (SPELL_EFFECT_198) +(161728, 0, 1116, 1167.27, -1494.87, -3.67496, 27547), -- Spell: Summon Tertiary Pylon Efffect: 28 (SPELL_EFFECT_SUMMON) +(161726, 0, 1116, 1180.45, -1524.46, -3.69849, 27547), -- Spell: Summon Secondary Pylon Efffect: 28 (SPELL_EFFECT_SUMMON) +(161725, 0, 1116, 1197.46, -1499.5, -3.68724, 27547), -- Spell: Summon Primary Pylon Efffect: 28 (SPELL_EFFECT_SUMMON) +(161671, 0, 1116, 1203.74, -1499.48, -5.07, 27547), -- Spell: Summon Hataaru Efffect: 28 (SPELL_EFFECT_SUMMON) +(178326, 0, 1116, 1195.51, -1478.63, -7.10502, 27547), -- Spell: Summon Maraad Efffect: 28 (SPELL_EFFECT_SUMMON) +(164802, 0, 1116, 1390.57, -1176.99, -12.2602, 27547), -- Spell: Summon Workhorse Efffect: 28 (SPELL_EFFECT_SUMMON) +(164801, 0, 1116, 1389.89, -1174.63, -12.6457, 27547), -- Spell: Summon Pandaren Efffect: 28 (SPELL_EFFECT_SUMMON) +(164800, 0, 1116, 1386.43, -1160.4, -12.6857, 27547), -- Spell: Summon Human Efffect: 28 (SPELL_EFFECT_SUMMON) +(164799, 0, 1116, 1397.6, -1168.68, -12.9623, 27547), -- Spell: Summon Dwarf Efffect: 28 (SPELL_EFFECT_SUMMON) +(164798, 0, 1116, 1349.56, -1199.35, -15.3365, 27547), -- Spell: Summon Akama Efffect: 28 (SPELL_EFFECT_SUMMON) +(164797, 0, 1116, 1391.1, -1169.28, -12.9786, 27547), -- Spell: Summon Maraad Efffect: 28 (SPELL_EFFECT_SUMMON) +(134652, 1, 870, -1140.53, -1243.93, 28.5142, 27377), -- Spell: Lion's Landing: Teleport and Phase Update Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(125319, 0, 870, -1307.68, 3134.55, 1.19462, 27377), -- Spell: The Mariner's Revenge: Summon Mist-Hopper Jr. Efffect: 28 (SPELL_EFFECT_SUMMON) +(125709, 0, 870, -1156.8, 3208.06, 1.02052, 27377), -- Spell: The Mariner's Revenge: Summon Soggy Efffect: 28 (SPELL_EFFECT_SUMMON) +(123786, 0, 870, -378.231, 4763.73, -28.9177, 27377), -- Spell: Break Amber Efffect: 28 (SPELL_EFFECT_SUMMON) +(121922, 1, 870, -378.238, 4763.96, -31.2163, 27377), -- Spell: Break Amber: Initiate Efffect: 171 (SPELL_EFFECT_171) +(123264, 0, 870, 589.756, 4017.51, 206.888, 27377), -- Spell: Summon Forked Blade Efffect: 28 (SPELL_EFFECT_SUMMON) +(122798, 0, 0, 814.656, 4073.29, 210.344, 27377), -- Spell: Amber Knockback Efffect: 144 (SPELL_EFFECT_KNOCK_BACK_DEST) +(127900, 1, 0, -916.142, 2559.9, 103.842, 27377), -- Spell: Break Amber Efffect: 28 (SPELL_EFFECT_SUMMON) +(125924, 0, 0, -1153.94, 3904.71, 1.83506, 27377), -- Spell: Summon Kaz'tik Efffect: 28 (SPELL_EFFECT_SUMMON) +(125922, 0, 0, -1151.75, 3905.93, 1.83506, 27377), -- Spell: Summon Kovok Efffect: 28 (SPELL_EFFECT_SUMMON) +(125641, 0, 0, -1127.53, 3927.36, 0.818132, 27377), -- Spell: Summon Kovok Efffect: 28 (SPELL_EFFECT_SUMMON) +(125064, 0, 0, -849.224, 3821.36, -0.380372, 27377), -- Spell: Summon Kaz'tik the Manipulator Efffect: 28 (SPELL_EFFECT_SUMMON) +(122788, 1, 870, -848.675, 3823.35, -0.381892, 27377), -- Spell: Update Phases and Summon Rocks Efffect: 28 (SPELL_EFFECT_SUMMON) +(122796, 0, 870, -849.224, 3821.36, -3.93105, 27377), -- Spell: Klaxxi Tuning Fork Efffect: 28 (SPELL_EFFECT_SUMMON) +(127845, 0, 870, 393.495, 2256.18, 235.407, 27377), -- Spell: Psycho Mantid: Summon Lann Efffect: 28 (SPELL_EFFECT_SUMMON) +(130559, 0, 870, 657.146, 2120.58, 328.811, 27377), -- Spell: Shado-Pan Rope Efffect: 28 (SPELL_EFFECT_SUMMON) +(121798, 0, 870, 656.071, 2121.34, 367.641, 27377), -- Spell: Shado-Pan Rope Efffect: 28 (SPELL_EFFECT_SUMMON) +(106179, 0, 870, -64.6048, -3147.84, 82.0644, 27356), -- Spell: Summon Sully Efffect: 28 (SPELL_EFFECT_SUMMON) +(106180, 0, 870, -66.6031, -3145.09, 81.0039, 27356), -- Spell: Summon Amber Efffect: 28 (SPELL_EFFECT_SUMMON) +(106176, 1, 870, -37.2326, -3150.47, 86.2455, 27356), -- Spell: Summon Anduin Efffect: 28 (SPELL_EFFECT_SUMMON) +(106177, 0, 870, -37.7396, -3155.66, 86.2455, 27356), -- Spell: Summon Ren Whitepaw Efffect: 28 (SPELL_EFFECT_SUMMON) +(106178, 0, 870, -42.5729, -3155.85, 86.2455, 27356), -- Spell: Summon Lina Whitepaw Efffect: 28 (SPELL_EFFECT_SUMMON) +(106077, 0, 870, -37.2326, -3150.47, 86.2455, 27356), -- Spell: Summon Anduin Efffect: 28 (SPELL_EFFECT_SUMMON) +(113741, 0, 870, -624.859, -2359.53, 22.8657, 27356), -- Spell: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(132401, 0, 870, -626.629, -2361.17, 22.8657, 27356), -- Spell: Dream Brew Scene Efffect: 198 (SPELL_EFFECT_198) +(125515, 0, 870, -626.964, -2361.55, 22.8657, 27356), -- Spell: Summon Personal Gong Efffect: 28 (SPELL_EFFECT_SUMMON) +(105667, 0, 870, -630.465, -2366.95, 22.9746, 27356), -- Spell: Summon Ka Pao Efffect: 28 (SPELL_EFFECT_SUMMON) +(105664, 2, 870, -624.063, -2358.86, 22.8657, 27356), -- Spell: Stun Phase Summon Efffect: 28 (SPELL_EFFECT_SUMMON) +(125420, 0, 870, -601.254, -2360.81, 23.9079, 27356), -- Spell: Summon Personal Crane 2 Efffect: 28 (SPELL_EFFECT_SUMMON) +(125411, 0, 870, -626.134, -2299.58, 22.4628, 27356), -- Spell: Summon Personal Crane 1 Efffect: 28 (SPELL_EFFECT_SUMMON) +(103623, 0, 870, 1299.44, -402.289, 340.615, 27356), -- Spell: The Debriefing 04: Summon Sully Efffect: 28 (SPELL_EFFECT_SUMMON) +(103620, 0, 870, 1296.96, -430.156, 344.718, 27356), -- Spell: The Debriefing 04: Sniper Rifle Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(103608, 0, 870, 1133.93, -599.199, 397.124, 27356), -- Spell: The Debriefing 04: Teleport In Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(104119, 0, 870, 1504.61, -1296.82, 249.618, 27356), -- Spell: The Debriefing 03: Summon Widow Efffect: 28 (SPELL_EFFECT_SUMMON) +(103567, 0, 870, 1533.57, -1212.19, 240.079, 27356), -- Spell: The Debriefing 03: Summon Amber Efffect: 28 (SPELL_EFFECT_SUMMON) +(103568, 0, 870, 1528.49, -1212.56, 239.549, 27356), -- Spell: The Debriefing 03: Summon Rell Efffect: 28 (SPELL_EFFECT_SUMMON) +(103564, 0, 870, 1517.21, -1215, 238.093, 27356), -- Spell: The Debriefing 03: Summon Yu Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(103563, 0, 870, 1517.21, -1215, 238.093, 27356), -- Spell: The Debriefing 03: Teleport In Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(103239, 0, 870, 717.102, -2111.16, 64.7809, 27356), -- Spell: The Debriefing 02: Teleport In Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(103425, 0, 870, 274.425, -2009.81, 69.6661, 27356), -- Spell: The Debriefing 01: Summon Rell Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(103428, 0, 870, 274.425, -2009.81, 69.6661, 27356), -- Spell: The Debriefing 01: Teleport In Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(106007, 0, 870, -213.702, -2641.74, -0.273174, 27356), -- Spell: Summon Flag Efffect: 28 (SPELL_EFFECT_SUMMON) +(106004, 0, 870, -218.497, -2627.44, -0.301992, 27356), -- Spell: Summon Player Efffect: 28 (SPELL_EFFECT_SUMMON) +(105940, 0, 870, -214.03, -2638.73, -0.20931, 27356), -- Spell: Summon Jinyu Warrior Efffect: 28 (SPELL_EFFECT_SUMMON) +(113502, 0, 870, -212.661, -2643.58, -0.288439, 27356), -- Spell: Summon Hozu Warrior Efffect: 28 (SPELL_EFFECT_SUMMON) +(105941, 0, 870, -218.382, -2642.49, -0.208264, 27356), -- Spell: Summon Spirit Efffect: 28 (SPELL_EFFECT_SUMMON) +(105975, 0, 870, -207.268, -2639.15, -0.303158, 27356), -- Spell: Summon Staff Efffect: 28 (SPELL_EFFECT_SUMMON) +(105938, 0, 870, -205.674, -2638.67, -0.21501, 27356), -- Spell: Summon Elder Lusshan-Om Efffect: 28 (SPELL_EFFECT_SUMMON) +(103537, 0, 870, 715.034, -2109.59, 65.5811, 27356), -- Spell: The Debriefing 02: Summon Amber Efffect: 28 (SPELL_EFFECT_SUMMON) +(103539, 0, 870, 719.215, -2111.33, 65.8085, 27356), -- Spell: The Debriefing 02: Summon Little Yu Efffect: 28 (SPELL_EFFECT_SUMMON) +(103237, 0, 870, 717.102, -2111.16, 64.7809, 27356), -- Spell: The Debriefing 02: Summon Sully Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(103609, 0, 870, 1133.93, -599.199, 397.124, 27356), -- Spell: The Debriefing 04: Summon Amber Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(105882, 0, 870, -150.095, -2665.97, 1.56877, 27356), -- Spell: Summon Bold Karasshi Efffect: 28 (SPELL_EFFECT_SUMMON) +(105883, 0, 870, -159.253, -2672.84, 1.14168, 27356), -- Spell: Summon Little Lu Efffect: 28 (SPELL_EFFECT_SUMMON) +(105884, 0, 870, -158.747, -2660.19, 1.20186, 27356), -- Spell: Summon Sully Efffect: 28 (SPELL_EFFECT_SUMMON) +(105885, 0, 870, -161.137, -2663.21, 1.23009, 27356), -- Spell: Summon Rell Efffect: 28 (SPELL_EFFECT_SUMMON) +(130499, 0, 870, -174.492, -2585.53, 39.2751, 27356), -- Spell: Summon Rogers' Gyrocopter Efffect: 28 (SPELL_EFFECT_SUMMON) +(130961, 0, 0, -205.288, -2627.22, 87.484, 27356), -- Spell: Summon Alliance Gunship - Exit Efffect: 28 (SPELL_EFFECT_SUMMON) +(130951, 0, 0, -502.88, -2658.44, 163.625, 27356), -- Spell: Summon Alliance Gunship Efffect: 28 (SPELL_EFFECT_SUMMON) +(113087, 0, 870, -150.095, -2665.97, 1.48544, 27356), -- Spell: Summon Bold Karasshi Efffect: 28 (SPELL_EFFECT_SUMMON) +(113088, 0, 870, -176.468, -2646.5, -0.0734082, 27356), -- Spell: Summon Rell Nightwind Efffect: 28 (SPELL_EFFECT_SUMMON) +(113091, 0, 870, -163.051, -2632.59, 0.213854, 27356), -- Spell: Summon Mishka Efffect: 28 (SPELL_EFFECT_SUMMON) +(113094, 0, 870, -170.586, -2637.36, 0.551186, 27356), -- Spell: Summon Sully Efffect: 28 (SPELL_EFFECT_SUMMON) +(103592, 0, 870, -183.592, -2331.5, 35.9344, 27356), -- Spell: Summon Bold Karasshi Efffect: 28 (SPELL_EFFECT_SUMMON) +(103552, 0, 870, -187.384, -2333.85, 36.0594, 27356), -- Spell: Summon Admiral Taylor Efffect: 28 (SPELL_EFFECT_SUMMON) +(123071, 0, 0, -8192.8, 546.038, 117.65, 27356), -- Spell: Portal: Stormwind Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(130866, 1, 870, -290.059, -1773.17, 61.5927, 27356), -- Spell: Envoy of the Alliance: Completion Event Efffect: 28 (SPELL_EFFECT_SUMMON) +(131603, 0, 870, -671.709, -1480.73, 130.2, 27356), -- Spell: Gunship Portal Click Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(131758, 0, 0, -835.386, -1790.02, 5.6409, 27356), -- Spell: Summon Taran Zhu Efffect: 28 (SPELL_EFFECT_SUMMON) +(130321, 0, 870, -667.89, -1482.25, 130.25, 27356), -- Spell: The Mission: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(251062, 0, 1669, 403.8, 1449.06, 772.66, 27356), -- Spell: Hearthstone Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(158500, 0, 1116, 2421.56, 2758.93, 115.091, 27602), -- Spell: Teleport Self Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(158496, 0, 1116, 2531.7, 2719.86, 234.954, 27602), -- Spell: Teleport Self Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(159720, 1, 1116, 1452.82, 3158.04, 101.967, 27602), -- Spell: Demonic Gateway Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(159326, 1, 1268, 404.814, 505.161, 243.199, 27602), -- Spell: Demonic Gateway Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(163627, 0, 1116, 3595.84, 1683.31, 172.9, 27602), -- Spell: Alliance Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(162173, 0, 1116, 1684.08, 1716.85, 296.76, 27602), -- Spell: Grappling Hook and rope Efffect: 28 (SPELL_EFFECT_SUMMON) +(159985, 0, 0, 3626.4, 1656.23, 175.975, 27602), -- Spell: Armory Outpost Efffect: 198 (SPELL_EFFECT_198) +(178295, 0, 1116, -490.05, 1863.32, 43.234, 27602), -- Spell: Destruction of the Terraces - cancel scene Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167292, 0, 1116, -651.85, 1564.93, 34.046, 27602), -- Spell: Abandon Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(168470, 0, 1116, -659.212, 1579.46, 36.289, 27602), -- Spell: Summon Ka'alu the Raven Mother Efffect: 28 (SPELL_EFFECT_SUMMON) +(167580, 0, 1116, -669.576, 1617.75, 65.7046, 27602), -- Spell: Summon Ka'alu Efffect: 28 (SPELL_EFFECT_SUMMON) +(167317, 1, 1116, 211.415, 2784.29, 83.5542, 27602), -- Spell: The Avatar of Terokk: Begin Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167941, 0, 1116, -461.738, 1865.33, 41.1196, 27602), -- Spell: A Worthy Vessel: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167316, 0, 1116, -176.038, 857.701, 122.305, 27602), -- Spell: Terokk's Fall: Begin Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167162, 0, 1116, -503.786, 1858.94, 44.7815, 27602), -- Spell: The Talon King: Exit Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167140, 0, 1116, -1718.45, 1482.94, 0.98, 27602), -- Spell: The Talon King: Summon Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(167128, 1, 1116, -1718.45, 1482.94, 0.981446, 27602), -- Spell: The Talon King: Begin Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(171726, 0, 1116, 89.4375, 2530.84, 79.3332, 27602), -- Spell: Apexis Turret Exit Spell Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(129947, 0, 870, 1811.2, 1360.95, 468.855, 27377), -- Spell: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(132055, 0, 870, 3783.4, 534.917, 639.0072, 27377), -- Spell: Jump to Combat Spot 02 Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(129611, 0, 0, 3821.08, 520.953, 638.757, 27377), -- Spell: Summon Taran Zhu Efffect: 28 (SPELL_EFFECT_SUMMON) +(132121, 0, 870, 3783.4, 534.917, 639.0072, 27377), -- Spell: Jump to Combat Spot 01 Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(132122, 0, 870, 3783.4, 534.917, 639.0072, 27377), -- Spell: Jump to Combat Spot 03 Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(117963, 1, 870, 4220.33, 653.701, 113.201, 27377), -- Spell: Quest - Start Funeral Event Efffect: 171 (SPELL_EFFECT_171) +(117965, 0, 870, 4219.73, 640.686, 113.626, 27377), -- Spell: Quest - Kun-Lai Summit - Spawn Gravestone 2 Efffect: 171 (SPELL_EFFECT_171) +(117966, 0, 0, 4232.31, 642.12, 113.164, 27377), -- Spell: Quest - Kun-Lai Summit - Spawn Gravestone 3 Efffect: 171 (SPELL_EFFECT_171) +(117542, 0, 870, 4727.87, 1046.71, 1.44629, 27377), -- Spell: Xiao Follower Summon Efffect: 28 (SPELL_EFFECT_SUMMON) +(119648, 0, 870, 4337.12, 850.927, 107.454, 27377), -- Spell: Summon Shomi Efffect: 28 (SPELL_EFFECT_SUMMON) +(125184, 0, 870, 4394.87, 870.747, 102.639, 27377), -- Spell: Summon Villager 2 Efffect: 28 (SPELL_EFFECT_SUMMON) +(125181, 0, 870, 4356.23, 857.788, 106.502, 27377), -- Spell: Summon Villager 1 Efffect: 28 (SPELL_EFFECT_SUMMON) +(123896, 0, 870, 4161.65, 863.01, 164.057, 27377), -- Spell: Summon Shomi (Balloon Ride) Efffect: 28 (SPELL_EFFECT_SUMMON) +(123734, 0, 870, 3943.45, 869.03, 416.442, 27377), -- Spell: Summon Whispercloud's Balloon -> Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(118957, 0, 870, 3485.96, 2100.87, 1084.04, 27377), -- Spell: The Tongue of Ba-Shon: Objective Complete Efffect: 3 (SPELL_EFFECT_DUMMY) +(118953, 0, 370, 3488.63, 2099.02, 1084.03, 27377), -- Spell: The Tongue of Ba-Shon: Summon Lorewalker Cho Efffect: 28 (SPELL_EFFECT_SUMMON) +(118447, 0, 870, 3572.39, 1826.93, 877.935, 27377), -- Spell: Summon Lha-Po Efffect: 28 (SPELL_EFFECT_SUMMON) +(117703, 0, 870, 3556.44, 1671.5, 839.949, 27377), -- Spell: Summon Sho Lien Efffect: 28 (SPELL_EFFECT_SUMMON) +(117397, 0, 870, 2435.83, 2538.07, 744.455, 27377), -- Spell: A Fair Trade: Summon Kota Kon Efffect: 28 (SPELL_EFFECT_SUMMON) +(117404, 0, 870, 2438.1, 2528.31, 743.889, 27377), -- Spell: A Fair Trade: Summon Burrberry Efffect: 28 (SPELL_EFFECT_SUMMON) +(116103, 0, 870, 2945.73, 1966.62, 642.986, 27377), -- Spell: The Hozen King: Summon Rabbitsfoot 01 Efffect: 28 (SPELL_EFFECT_SUMMON) +(116101, 0, 870, 2945.18, 1961.63, 643.091, 27377), -- Spell: The Hozen King: Summon Tassle Efffect: 28 (SPELL_EFFECT_SUMMON) +(116102, 0, 870, 2945.97, 1964.34, 643.044, 27377), -- Spell: The Hozen King: Summon Yakshoe 02 Efffect: 28 (SPELL_EFFECT_SUMMON) +(116112, 0, 870, 2978.69, 1960.43, 643.025, 27377), -- Spell: The Hozen King: Summon Chomp Chomp Efffect: 28 (SPELL_EFFECT_SUMMON) +(115452, 0, 0, 3131.97, 1784.39, 631.315, 27377), -- Spell: Release Old Poot Poot Efffect: 28 (SPELL_EFFECT_SUMMON) +(115261, 0, 870, 2657.35, 1283.22, 643.467, 27377), -- Spell: Monkey Idol: Summon Hozen 003 Efffect: 28 (SPELL_EFFECT_SUMMON) +(115208, 0, 0, 2579.79, 1550.36, 618.602, 27377), -- Spell: Monkey Idol: Summon Hozen 001 Efffect: 28 (SPELL_EFFECT_SUMMON) +(115260, 0, 870, 2634.35, 1568.99, 643.676, 27377), -- Spell: Monkey Idol: Summon Hozen 002 Efffect: 28 (SPELL_EFFECT_SUMMON) +(115102, 0, 870, 2679.46, 1766.81, 648.984, 27377), -- Spell: Summon Shazboodle Exposition 001 Efffect: 28 (SPELL_EFFECT_SUMMON) +(121003, 0, 0, 3205.33, 1654.68, 815.496, 27377), -- Spell: Summon Rampaging Yeti Efffect: 28 (SPELL_EFFECT_SUMMON) +(120741, 0, 0, 3048.23, 1253.79, 655.1, 27377), -- Spell: Summon Ji-Lu's Cart -> Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(120739, 0, 0, 3045.21, 1256.98, 654.944, 27377), -- Spell: Summon Yak - Neverrest Cart - 1 Efffect: 28 (SPELL_EFFECT_SUMMON) +(120476, 0, 870, 3044.47, 1251.32, 654.669, 27377), -- Spell: Summon Lorewalker Cho Efffect: 28 (SPELL_EFFECT_SUMMON) +(120833, 0, 0, 3042.91, 1253.85, 654.703, 27377), -- Spell: Summon Lucky Bluestring Efffect: 28 (SPELL_EFFECT_SUMMON) +(176248, 0, 1116, 3744.33, -4055.88, 46.55, 27377), -- Spell: Teleport: Stormshield Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(117759, 0, 870, 2158.2, 1466.69, 487.887, 27377), -- Spell: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(111536, 0, 870, -158.578, 608.821, 175.643, 27377), -- Spell: Summon Yoon Efffect: 28 (SPELL_EFFECT_SUMMON) +(111539, 0, 870, -202.954, 624.229, 166.629, 27377), -- Spell: Summon Mudclaw Efffect: 28 (SPELL_EFFECT_SUMMON) +(111538, 0, 870, -202.103, 621.209, 166.785, 27377), -- Spell: Summon Fung Efffect: 28 (SPELL_EFFECT_SUMMON) +(111537, 0, 870, -205.963, 624.375, 166.755, 27377), -- Spell: Summon Mung-Mung Efffect: 28 (SPELL_EFFECT_SUMMON) +(111466, 0, 870, -160.422, 637.535, 165.493, 27377), -- Spell: Summon Yoon Efffect: 28 (SPELL_EFFECT_SUMMON) +(107771, 0, 0, 374.769, 353.7, 185.924, 27377), -- Spell: Ashyo's Vision: Summon Ashyo Actor (Vision) Efffect: 28 (SPELL_EFFECT_SUMMON) +(108071, 0, 870, -206.72, 459.28, 180.976, 27377), -- Spell: Chen's Resolution: Summon Mudmug Efffect: 28 (SPELL_EFFECT_SUMMON) +(106628, 0, 870, -814, 1291.56, 112.924, 27377), -- Spell: Broken Dreams: Summon Wuk-Wuk Efffect: 28 (SPELL_EFFECT_SUMMON) +(106618, 0, 870, -744.423, 1310.25, 146.695, 27377), -- Spell: Broken Dreams: Summon Beer Elemental Efffect: 28 (SPELL_EFFECT_SUMMON) +(106554, 0, 870, -774.987, 1421.53, 139.585, 27377), -- Spell: Broken Dreams: Summon Chen Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(106605, 0, 870, -752.073, 1336.05, 146.725, 27377), -- Spell: Broken Dreams: Summon Gao Efffect: 28 (SPELL_EFFECT_SUMMON) +(106552, 0, 870, -774.987, 1421.53, 139.585, 27377), -- Spell: Broken Dreams: Teleport In Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(106599, 0, 870, -60.7899, -36.7986, 154.575, 27377), -- Spell: Li Li's Day Off: Summon Chen Efffect: 28 (SPELL_EFFECT_SUMMON) +(106336, 0, 870, 48.3267, -115.196, 201.494, 27377), -- Spell: Great Minds Drink Alike: Summon Mudmug Efffect: 28 (SPELL_EFFECT_SUMMON) +(106324, 0, 870, 166.943, -275.458, 236.261, 27377), -- Spell: Great Minds Drink Alike: Summon Chen Efffect: 28 (SPELL_EFFECT_SUMMON) +(105811, 0, 870, 236.962, -389.321, 247.849, 27377), -- Spell: Summon Shang 02 Efffect: 28 (SPELL_EFFECT_SUMMON) +(105810, 0, 870, 231.297, -408.311, 244.431, 27377), -- Spell: Summon Shang 01 Efffect: 28 (SPELL_EFFECT_SUMMON) +(110356, 0, 870, 415.55, -293.571, 202.721, 27377), -- Spell: Chuck Meat Efffect: 3 (SPELL_EFFECT_DUMMY) +(105522, 0, 870, 437, -286, 203, 27377), -- Spell: Launch New Friend Efffect: 3 (SPELL_EFFECT_DUMMY) +(105519, 0, 870, 437, -286, 203, 27377), -- Spell: Launch Watermelon Efffect: 3 (SPELL_EFFECT_DUMMY) +(105504, 0, 870, 437, -286, 203, 27377), -- Spell: Launch Extra-Spicy Tofu Efffect: 3 (SPELL_EFFECT_DUMMY) +(105296, 0, 870, 437, -286, 203, 27377), -- Spell: Launch Turnip Efffect: 3 (SPELL_EFFECT_DUMMY) +(105508, 0, 870, 511.152, -647.788, 260.012, 27377), -- Spell: Summon Miss Fanny Efffect: 28 (SPELL_EFFECT_SUMMON) +(124530, 0, 870, 1748.55, -670.19, 328.345, 27366), -- Spell: Captain Jack Summon Hozen Efffect: 28 (SPELL_EFFECT_SUMMON) +(105835, 0, 870, 517.318, -693.748, 247.253, 27366), -- Spell: Chen and Li Li: Summon Chen Efffect: 28 (SPELL_EFFECT_SUMMON) +(125944, 0, 870, 774.232, -1901.71, 86, 27366), -- Spell: Summon Mishi Efffect: 28 (SPELL_EFFECT_SUMMON) +(125942, 0, 870, 764.344, -1879.06, 62.1583, 27366), -- Spell: Summon Taylor Efffect: 28 (SPELL_EFFECT_SUMMON) +(125952, 0, 870, 807.094, -1769.66, 89.2818, 27366), -- Spell: Summon Mishi Efffect: 28 (SPELL_EFFECT_SUMMON) +(125949, 0, 870, 782.474, -1785.52, 56.524, 27366), -- Spell: Summon Mishka Efffect: 28 (SPELL_EFFECT_SUMMON) +(125966, 0, 870, 924.643, -1848.8, 90, 27366), -- Spell: Summon Mishi Efffect: 28 (SPELL_EFFECT_SUMMON) +(125965, 0, 870, 897.278, -1867.26, 60.484, 27366), -- Spell: Summon Sully Efffect: 28 (SPELL_EFFECT_SUMMON) +(125472, 2, 870, 794.975, -1988.87, 54.3475, 27366), -- Spell: Eject Teleport Boss Emote Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(125374, 0, 870, 531.958, -1674.62, 198.983, 27366), -- Spell: Summon Mishi Efffect: 28 (SPELL_EFFECT_SUMMON) +(108018, 0, 870, 917.928, -2595.7, 181.321, 27366), -- Spell: East Temple Arrival: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(128950, 0, 870, 917.93, -2595.7, 181.29, 27366), -- Spell: East Temple Arrival Scene Efffect: 198 (SPELL_EFFECT_198) +(110360, 0, 870, 1550.99, -2559.73, 151.274, 27366), -- Spell: Teleport Player Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(110354, 0, 870, 1543.71, -2564.95, 151.234, 27366), -- Spell: Summon Green Hatchling Efffect: 28 (SPELL_EFFECT_SUMMON) +(110338, 0, 870, 1552.85, -2567.15, 151.512, 27366), -- Spell: Summon Instructor Skythorn Efffect: 28 (SPELL_EFFECT_SUMMON) +(110351, 0, 870, 1543.71, -2564.95, 151.234, 27366), -- Spell: Summon Green Egg Efffect: 28 (SPELL_EFFECT_SUMMON) +(103120, 0, 0, 0, 0, 0, 27366), -- Spell: The Great Banquet: Summon Wu's Mug Efffect: 28 (SPELL_EFFECT_SUMMON) +(102828, 0, 870, 2573.59, -1532.59, 406.295, 27366), -- Spell: The Great Banquet: Summon High Elder Cloudfall Efffect: 28 (SPELL_EFFECT_SUMMON) +(105364, 0, 870, 3067.39, -1582.62, 221, 27366), -- Spell: To Bridge Earth and Sky: Summon Shan Jitong Gate Bunny Outro Efffect: 28 (SPELL_EFFECT_SUMMON) +(105251, 0, 870, 3067.39, -1582.62, 223.355, 27366), -- Spell: To Bridge Earth and Sky: Summon Shan Jitong Actor Outro Efffect: 28 (SPELL_EFFECT_SUMMON) +(105016, 0, 870, 2952.86, -1636.97, 252.833, 27366), -- Spell: Summon Pei-Zhi Actor (To Bridge Earth and Sky) Efffect: 28 (SPELL_EFFECT_SUMMON) +(104032, 0, 870, 2931.7, -1645.79, 252.833, 27366), -- Spell: Interrupt the Ritual - Summon Shan Jitong Efffect: 28 (SPELL_EFFECT_SUMMON) +(120134, 0, 870, 2388.85, -2106, 231, 27366), -- Spell: Fresco Scene Efffect: 195 (SPELL_EFFECT_195) +(120128, 0, 870, 2406.87, -2122.99, 219.385, 27366), -- Spell: What's Mined Is Yours: Completion Efffect: 28 (SPELL_EFFECT_SUMMON) +(106017, 1, 0, 2297.66, -1718.57, 219.136, 27366), -- Spell: Mann's Man: Rescue Hao Efffect: 28 (SPELL_EFFECT_SUMMON) +(119923, 0, 870, 2297.75, -1718.81, 219.667, 27366), -- Spell: Mann's Man: Summon Hao Rubble Efffect: 171 (SPELL_EFFECT_171) +(114343, 0, 870, 2312.13, -1748.6, 238.654, 27366), -- Spell: Jade Mines Arrival Event: Dust Explosion Effect Efffect: 3 (SPELL_EFFECT_DUMMY) +(106316, 0, 870, 2297.05, -1721.63, 219.915, 27366), -- Spell: Jade Mines Arrival Event: Summon Fleeing Miner 2 Efffect: 28 (SPELL_EFFECT_SUMMON) +(106311, 0, 870, 2301.98, -1726.5, 224.355, 27366), -- Spell: Jade Mines Arrival Event: Summon Fleeing Miner 1 Efffect: 28 (SPELL_EFFECT_SUMMON) +(106308, 0, 0, 2307.78, -1754.61, 244.841, 27366), -- Spell: Jade Mines Arrival Event: Summon Controller / Trigger Cooldown Efffect: 28 (SPELL_EFFECT_SUMMON) +(120049, 0, 870, 2388.85, -2106, 231, 27366), -- Spell: Fresco Scene Efffect: 195 (SPELL_EFFECT_195) +(113837, 2, 870, 1856.72, -2192.19, 225.77, 27366), -- Spell: Summon Actors Efffect: 28 (SPELL_EFFECT_SUMMON) +(113837, 1, 870, 1856.72, -2192.19, 225.77, 27366), -- Spell: Summon Actors Efffect: 28 (SPELL_EFFECT_SUMMON) +(113837, 0, 870, 1856.72, -2192.19, 225.77, 27366), -- Spell: Summon Actors Efffect: 28 (SPELL_EFFECT_SUMMON) +(113835, 0, 0, 1878.14, -2218.96, 232.226, 27366), -- Spell: Summon Syra Alerage Efffect: 28 (SPELL_EFFECT_SUMMON) +(113834, 0, 0, 1877.72, -2220.64, 232.212, 27366), -- Spell: Summon Lo Flamelager Efffect: 28 (SPELL_EFFECT_SUMMON) +(113541, 0, 0, 1543.1, -1804.18, 246.208, 27366), -- Spell: Summon Lo Flamelager Efffect: 28 (SPELL_EFFECT_SUMMON) +(106570, 0, 0, 1498.71, -1332.21, 245.644, 27366), -- Spell: An Windfur Finale (Summon) Efffect: 28 (SPELL_EFFECT_SUMMON) +(212983, 0, 1220, -847.73, 4526.65, 745.53, 27843), -- Spell: Blinks Blinks Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(212982, 0, 1220, -852.01, 4524.17, 748.69, 27843), -- Spell: Blinks Blinks Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(212979, 0, 1220, -842.17, 4530.64, 749.65, 27843), -- Spell: Blinks Blinks Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(214778, 0, 1616, -420.84, 8008.8, 66.1, 27843), -- Spell: Teleport: Out of Eredar Realm Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(214730, 0, 1616, -4396, 406.64, 436.6, 27843), -- Spell: Fel Grip and Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(214719, 1, 1616, -418.6, 8009.27, 70, 27843), -- Spell: Fel Grip and Teleport Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(223429, 0, 1220, 1578.66, 4802.07, 140.97, 27843), -- Spell: Mage-Ring Network Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(196604, 0, 1220, -854.6, 4596.13, 748.84, 27843), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(196262, 0, 1480, 4677.44, 2769.44, 364.09, 27843), -- Spell: Displacement Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(195549, 0, 1480, 4082.37, 2483.97, 365.79, 27843), -- Spell: Teleport to Ice Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(195454, 0, 0, 278.29, 450.76, 57.75, 27843), -- Spell: Summon Aethas Efffect: 28 (SPELL_EFFECT_SUMMON) +(281404, 0, 1642, -1129.19, 774.15, 433.33, 27843), -- Spell: Teleport: Dazar'alor Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(203976, 0, 1513, -835.08, 4693.55, 939.99, 27843), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(208013, 0, 1583, 4211.5, 7094.3, 268.2, 27843), -- Spell: Teleport - Nexus Vault Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(207901, 0, 1583, 1137.76, 1009.34, 308.29, 27843), -- Spell: Teleport - Nexus Vault Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(211719, 0, 1583, 3723.76, 7359.61, 266.8, 27843), -- Spell: Teleport - Nexus Vault Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(241271, 0, 1669, 389.98, 1417.1, 769.6, 27843), -- Spell: Transporting Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(203675, 0, 1513, -823.27, 4693.47, 939.66, 27843), -- Spell: Transporting Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(203241, 0, 1494, 1276.16, -263.27, 44.36, 27843), -- Spell: Start Scenario Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(245992, 1, 0, -8998.14, 861.25, 29.62, 27843), -- Spell: Portal: Stormwind Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(247057, 1, 1, 1776.5, -4338.8, -7.48, 27843), -- Spell: Portal: Orgrimmar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(228326, 0, 0, -11099.8, -2212.36, 757.83, 27843), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(200891, 1, 0, -8393.52, 229.79, 155.35, 27843), -- Spell: Summon Jace Darkweaver Efffect: 28 (SPELL_EFFECT_SUMMON) +(208514, 0, 0, -8400.18, 1383.11, 135.12, 27843), -- Spell: Teleport to Stormwind Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(181546, 0, 1460, 1408.14, 2159.62, 21.48, 27843), -- Spell: Stage 3 Port Efffect: 15 (SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL) +(227791, 0, 1460, 817.67, 2171.36, 86.06, 27843), -- Spell: Stage 2 Teleport Efffect: 15 (SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL) +(218636, 0, 1460, 1131.99, 2473.47, 36.17, 27843), -- Spell: Stage 2 Far Sight Efffect: 72 (SPELL_EFFECT_ADD_FARSIGHT) +(199358, 0, 1460, 441.2, 2023.75, 4.44, 27843), -- Spell: Stage 1 Port Efffect: 15 (SPELL_EFFECT_RITUAL_ACTIVATE_PORTAL) +(164450, 0, 0, 2393.03, 6616.5, 267.392, 27602), -- Spell: Shadow Missiles Efffect: 3 (SPELL_EFFECT_DUMMY) +(167579, 0, 0, 2807.4, 6157.68, 57.0683, 27602); -- Spell: Summon Nobundo At Spirit Woods Efffect: 28 (SPELL_EFFECT_SUMMON) + +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(166011, 0, 1116, 1967.55, 4705.12, 335.893, 27602), -- Spell: Morgak's Overwatch Portal to End Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(165975, 0, 1116, 2245.11, 4617.95, 246.685, 27602), -- Spell: Morgak's Overwatch Portal to Start Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(166251, 0, 1116, 3121.06, 5293.47, 17.603, 27602), -- Spell: Summon Relic Bunny Efffect: 28 (SPELL_EFFECT_SUMMON) +(166145, 0, 1116, 3121.55, 5294.85, 15.1139, 27602), -- Spell: Toss Relic Efffect: 3 (SPELL_EFFECT_DUMMY) +(166160, 0, 1116, 3154.58, 5300.25, 19.7779, 27602), -- Spell: Summon Relic Bunny Efffect: 28 (SPELL_EFFECT_SUMMON) +(167835, 0, 1116, 7709.39, 332.125, 131.905, 27602), -- Spell: Portal to Gorgrond Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(182464, 0, 1159, 1936.9, 341.35, 90.28, 27602), -- Spell: Portal to Garrison Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(170110, 0, 1116, 6331.89, 740.269, 115.307, 27602), -- Spell: Enter Mole Machine Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(163736, 0, 0, 6350.22, 726.78, 115.967, 27602), -- Spell: Lumber Mill Outpost Efffect: 198 (SPELL_EFFECT_198) +(182317, 0, 1464, 3435.5, -2150.64, 7.36478, 27602), -- Spell: 6.2 - Tanaan Invasion - Boat Scene - Teleport Units Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(186007, 0, 1116, 2129.62, 420.888, 16.2556, 27602), -- Spell: Garrison Shipyard Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(182748, 0, 1116, 8700.22, 920.716, 4.99974, 27602), -- Spell: Rope Down to Ground Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(182745, 0, 1116, 8686.55, 918.945, 55.1945, 27602), -- Spell: Grapple to Bunker Efffect: 42 (SPELL_EFFECT_JUMP_DEST) +(182725, 0, 1116, 8711.81, 925.902, 7.08525, 27602), -- Spell: Launch Grapple Efffect: 28 (SPELL_EFFECT_SUMMON) +(182755, 0, 1116, 8650.51, 425.877, 12.5143, 27602), -- Spell: Escorting Roark Efffect: 28 (SPELL_EFFECT_SUMMON) +(173140, 0, 1116, 3667.8, -3843, 44.1352, 27602), -- Spell: Teleport to Ashran - Alliance Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(115590, 0, 870, -337, 2383, 185.6, 27377), -- Spell: Summon Mantid Colossus Efffect: 28 (SPELL_EFFECT_SUMMON) +(128764, 2, 870, -373.717, 1966.59, 128.562, 27377), -- Spell: Stoneplow Finale Scene: Leave Cinematic Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(116622, 0, 0, -2583.08, 777.302, 0.1, 27377), -- Spell: Croc Tale: Summon Actor C Efffect: 28 (SPELL_EFFECT_SUMMON) +(116619, 0, 0, -2588.27, 788.858, 0.1, 27377), -- Spell: Croc Tale: Summon Actor B Efffect: 28 (SPELL_EFFECT_SUMMON) +(116618, 0, 0, -2572.67, 781.74, 0.1, 27377), -- Spell: Croc Tale: Summon Actor A Efffect: 28 (SPELL_EFFECT_SUMMON) +(116630, 0, 870, -2572.67, 781.74, 0.1, 27377), -- Spell: Croc Tale: Summon Controller Efffect: 28 (SPELL_EFFECT_SUMMON) +(116528, 0, 870, -2503.11, 526.028, 0, 27377), -- Spell: Chuck Raft Efffect: 3 (SPELL_EFFECT_DUMMY) +(112872, 0, 0, -1172.52, 1790.3, 18.1612, 27377), -- Spell: Summon Vaeldrin Efffect: 28 (SPELL_EFFECT_SUMMON) +(132342, 1, 870, -1164.56, 1043.37, 21.8841, 27377), -- Spell: Sha Can Awe: Summon Anduin Guardian Efffect: 28 (SPELL_EFFECT_SUMMON) +(113615, 0, 870, -1193.12, 1050.09, 21.8639, 27377), -- Spell: Refugee Camp Act II: Begin Efffect: 28 (SPELL_EFFECT_SUMMON) +(113156, 0, 870, -1204.72, 900.37, 36.3654, 27377), -- Spell: Unsafe Passage: Summon Ambusher F Efffect: 28 (SPELL_EFFECT_SUMMON) +(113155, 0, 870, -1212.32, 891.189, 30.4431, 27377), -- Spell: Unsafe Passage: Summon Ambusher E Efffect: 28 (SPELL_EFFECT_SUMMON) +(112924, 0, 870, -1277.77, 851.186, 39.4304, 27377), -- Spell: Unsafe Passage: Summon Ambusher D Efffect: 28 (SPELL_EFFECT_SUMMON) +(112923, 0, 870, -1274.8, 854.634, 38.6437, 27377), -- Spell: Unsafe Passage: Summon Ambusher C Efffect: 28 (SPELL_EFFECT_SUMMON) +(112901, 0, 870, -1297.36, 848.809, 25.3578, 27377), -- Spell: Unsafe Passage: Summon Ambusher B Efffect: 28 (SPELL_EFFECT_SUMMON) +(112900, 0, 870, -1302.52, 844.479, 24.818, 27377), -- Spell: Unsafe Passage: Summon Ambusher A Efffect: 28 (SPELL_EFFECT_SUMMON) +(113034, 0, 870, -1519.06, 890.866, 18.0819, 27377), -- Spell: Unsafe Passage: Summon Refugee D Efffect: 28 (SPELL_EFFECT_SUMMON) +(113033, 0, 870, -1516.19, 885.557, 18.8988, 27377), -- Spell: Unsafe Passage: Summon Refugee C Efffect: 28 (SPELL_EFFECT_SUMMON) +(113032, 0, 870, -1520.65, 882.156, 18.2046, 27377), -- Spell: Unsafe Passage: Summon Refugee B Efffect: 28 (SPELL_EFFECT_SUMMON) +(113026, 0, 870, -1518.57, 879.656, 19.2248, 27377), -- Spell: Unsafe Passage: Summon Refugee A Efffect: 28 (SPELL_EFFECT_SUMMON) +(110654, 0, 870, -384.764, -637.573, 116.977, 27377), -- Spell: Zhu's Despair: Summon Yi-Mo Efffect: 28 (SPELL_EFFECT_SUMMON) +(110552, 0, 870, -330.934, -624.592, 119.894, 27377), -- Spell: Zhu's Despair: Summon Ken-Ken Efffect: 28 (SPELL_EFFECT_SUMMON) +(110564, 0, 870, -331.09, -642.776, 120.283, 27377), -- Spell: Why So Serious?: Outro Efffect: 28 (SPELL_EFFECT_SUMMON) +(110563, 0, 870, -344.186, -630.028, 118.506, 27377), -- Spell: Materia Medica Outro Efffect: 28 (SPELL_EFFECT_SUMMON) +(110333, 0, 870, -352.021, -644.697, 120.288, 27377), -- Spell: Cheer Up, Yi-Mo: Outro Transition Effect Efffect: 28 (SPELL_EFFECT_SUMMON) +(109267, 2, 870, -323.196, -863.092, 120.124, 27377), -- Spell: Cheer Up, Yi-Mo: Summon Yi-Mo Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(106913, 0, 870, 253.788, 1966.78, 162.121, 27377), -- Spell: Unyielding Fists: Summon Stone Stack Efffect: 28 (SPELL_EFFECT_SUMMON) +(106987, 0, 870, 278.648, 1961, 164.516, 27377), -- Spell: Unyielding Fists 03: Summon Master Efffect: 28 (SPELL_EFFECT_SUMMON) +(106912, 0, 870, 252.694, 1962.79, 162.105, 27377), -- Spell: Unyielding Fists: Summon Wood Stack Efffect: 28 (SPELL_EFFECT_SUMMON) +(106986, 0, 870, 278.648, 1961, 164.516, 27377), -- Spell: Unyielding Fists 02: Summon Master Efffect: 28 (SPELL_EFFECT_SUMMON) +(106911, 0, 870, 253.927, 1958.36, 162.053, 27377), -- Spell: Unyielding Fists: Summon Bamboo Stack Efffect: 28 (SPELL_EFFECT_SUMMON) +(106985, 0, 870, 278.648, 1961, 164.516, 27377), -- Spell: Unyielding Fists 01: Summon Master Efffect: 28 (SPELL_EFFECT_SUMMON) +(110752, 0, 0, -883.568, 1900.4, 162.363, 27377), -- Spell: Summon Hemet Nesingwary Efffect: 28 (SPELL_EFFECT_SUMMON) +(110751, 0, 0, -884.089, 1897.89, 162.363, 27377), -- Spell: Summon Hemet Nesingwary Jr. Efffect: 28 (SPELL_EFFECT_SUMMON) +(109511, 0, 0, -672.79, 1338.47, 135.812, 27377), -- Spell: Summon Ook-Ook Efffect: 28 (SPELL_EFFECT_SUMMON) +(131280, 0, 0, -259.54, 592.547, 167.548, 27377), -- Spell: Summon Gina Mudclaw Efffect: 28 (SPELL_EFFECT_SUMMON) +(109490, 0, 870, -193.061, 474.153, 187.878, 27377), -- Spell: Chuck Keg Efffect: 3 (SPELL_EFFECT_DUMMY) +(109488, 0, 870, -193.061, 474.153, 187.878, 27377), -- Spell: Chuck Keg Efffect: 3 (SPELL_EFFECT_DUMMY) +(109489, 0, 870, -193.061, 474.153, 187.878, 27377), -- Spell: Chuck Keg Efffect: 3 (SPELL_EFFECT_DUMMY) +(109486, 0, 870, -194.872, 476.955, 187.189, 27377), -- Spell: Summon Beer Cart Efffect: 28 (SPELL_EFFECT_SUMMON) +(160216, 0, 1116, 206.306, -451.467, -3.9091, 27547), -- Spell: Summon Yrel Efffect: 28 (SPELL_EFFECT_SUMMON) +(160220, 0, 1116, 212.615, -452.438, -3.83569, 27547), -- Spell: Summon Rangari Lookout Efffect: 28 (SPELL_EFFECT_SUMMON) +(160217, 0, 1116, 213.125, -449.878, -3.74188, 27547), -- Spell: Summon Rangari Lookout Efffect: 28 (SPELL_EFFECT_SUMMON) +(167221, 0, 1116, 2308.57, 447.469, 5.11977, 27404), -- Spell: Teleport Out: Alliance Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(164041, 0, 1265, 4058.72, -2021.89, 73.1662, 27404), -- Spell: Shooting Gallery Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167960, 0, 1265, 4406.44, -2832.71, 4.72191, 27404), -- Spell: Kill Your Hundred: Teleport to Center Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167431, 0, 1265, 4066.64, -2378.48, 94.7866, 27404), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(167771, 0, 1265, 4066.5, -2382.25, 94.8536, 27404), -- Spell: Teleport to Tanaan Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(267877, 0, 1643, 1144.69, -521.45, 17.53, 27377), -- Spell: Portal: Boralus Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(122726, 0, 870, 3703.28, 5415.13, 86.5208, 27377), -- Spell: Portal: Shan'ze Dao Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(122717, 0, 870, 1879.89, 4288.8, 148.7, 27377), -- Spell: Portal: Shado-Pan Garrison Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(138818, 0, 870, 1920.35, 4221.34, 132.828, 27377), -- Spell: Portal: Shado-Pan Garrison Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(139553, 0, 1064, 5838.68, 6346.18, 1.59685, 27377), -- Spell: Teleport to Za'Tual Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(140125, 0, 1064, 5335.15, 5607.88, 65.38, 27377), -- Spell: Teleport to Thunder Isle Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(138023, 0, 1064, 6150.31, 5004.16, 35.7921, 27377), -- Spell: Teleport: Isle of the Thunder King Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(121307, 0, 870, 1214.39, 4111.31, 187, 27377), -- Spell: Summon Personal Nurong's Gun Vehicle Efffect: 28 (SPELL_EFFECT_SUMMON) +(117428, 0, 0, 1854.93, 3175.58, 308.994, 27377), -- Spell: Spinning Torch Efffect: 3 (SPELL_EFFECT_DUMMY) +(118970, 0, 870, 1744.78, 2336.7, 377.424, 27377), -- Spell: Summon Sha Efffect: 28 (SPELL_EFFECT_SUMMON) +(118246, 0, 870, 1762.35, 2335.46, 377.511, 27377), -- Spell: Summon Yalia Efffect: 28 (SPELL_EFFECT_SUMMON) +(118115, 0, 870, 1756.68, 2328.65, 377.511, 27377), -- Spell: Summon Xiao Tu Efffect: 28 (SPELL_EFFECT_SUMMON) +(117788, 0, 870, 2618.35, 3265.33, 423.827, 27377), -- Spell: Plant Banner Efffect: 28 (SPELL_EFFECT_SUMMON) +(117974, 0, 870, 2661.79, 3267.42, 425.659, 27377), -- Spell: Summon Suna Efffect: 28 (SPELL_EFFECT_SUMMON) +(117927, 0, 870, 2387.5, 2992.5, 417.455, 27377), -- Spell: Summon Taran Efffect: 28 (SPELL_EFFECT_SUMMON) +(117929, 0, 870, 2387.28, 2995.74, 417.455, 27377); -- Spell: Summon Taoshi Efffect: 28 (SPELL_EFFECT_SUMMON) + +UPDATE `spell_target_position` SET `PositionX`=-1824.32, `PositionY`=5417.23, `VerifiedBuild`=27843 WHERE (`ID`=121853 AND `EffectIndex`=0); |