diff options
| -rw-r--r-- | sql/updates/world/6.x/2016_09_13_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_09_13_00_world.sql b/sql/updates/world/6.x/2016_09_13_00_world.sql new file mode 100644 index 00000000000..25263e20398 --- /dev/null +++ b/sql/updates/world/6.x/2016_09_13_00_world.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_target_position` WHERE (`ID`=222727 AND `EffectIndex`=0) OR (`ID`=201960 AND `EffectIndex`=0) OR (`ID`=201652 AND `EffectIndex`=0) OR (`ID`=201643 AND `EffectIndex`=0) OR (`ID`=167220 AND `EffectIndex`=0) OR (`ID`=220883 AND `EffectIndex`=0) OR (`ID`=225434 AND `EffectIndex`=0) OR (`ID`=227249 AND `EffectIndex`=0) OR (`ID`=227533 AND `EffectIndex`=0) OR (`ID`=185334 AND `EffectIndex`=0) OR (`ID`=185335 AND `EffectIndex`=0); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(222727, 0, 1629, 1244.42, 1344.24, 185.02, 22566), -- Spell: Enter Netherlight Temple Efffect: 227 (SPELL_EFFECT_TELEPORT_TO_LFG_DUNGEON) +(167220, 0, 1116, 5535.01, 5019.88, 12.6375, 22566), -- Spell: Teleport Out: Horde Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(220883, 0, 1220, 1093.98, 4173.8, 179.35, 22566), -- Spell: Teleport Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(225434, 0, 1220, 1128.27, 2143.5, 5.76, 22566), -- Spell: Town Portal: Sashj'tar Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(227533, 0, 1220, 2453.22, 6943.77, 114.16, 22566), -- Spell: Teleport from Lost Wisp [DNT] Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(185334, 0, 1220, -228.676, 5854.51, 91.558, 22566), -- Spell: Ley Portal Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(185335, 0, 1220, -529.019, 6449.31, 209.078, 22566); -- Spell: Ley Portal Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) |